WFENG_COMMIT_INSIDE error...

One of the reason for WFENG_COMMIT_INSIDE error is workflow engine detect the commit in the program called from the worlflow process.

Workflow user guide clearly says that we should not put commit or rollback in API code called from workflow process.

If your workflow activity stuck , then you can try to progress the workflow by either RETRY (if you want to execute the underliying code ) or SKIP (if you want to skip the inderlying code).API for that is WF_ENGINE.HANDLE_ERROR.

For more Info on Workflow , please refer
http://eoracleapps.blogspot.com/2008/07/oracle-workflow-concept.html

http://eoracleapps.blogspot.com/2009/04/how-to-progress-stuck-order-lines-in.html

To refer how to design a Master Detail Workflow
http://eoracleapps.blogspot.com/2008/07/designing-simple-masterdeatil-oracle.html