I am using Workflow within APEX for a business process creating users and this requires an approval step.
For some of the steps in the process I am calling PL/SQL within the ATP database.
If one of these were to fail, I can raise an error in the exception block and this faults the workflow.
Is there a way to return an informative error message that will display in the workflow admin audit?
Should I be using the APEX_ERROR package, if so how do I associate the error to the workflow / step?
Is there another standard package I can call to put a useful message into the table/view so the workflow admin person knows what is wrong and can fix the issue before retrying the workflow?
Thanks
Mike