In forms personalization , How to call pl/sql funtion in MESSAGE action tab.

Hello Experts,

On Receipts workbench, When the user clicks on Reverse..1 button to reverse that particular receipt, we want to fire custom code to do the reversal of some other receipts as well.

So I created forms personalization on WHEN-VALIDATE-RECORD of RGW_REVERSAL_MODAL.

I have created PL/SQL function which calls the API to do the reversal of other receipts and return an error message.

FUNCTION reverse_branch_receipts(p_hq_rcpt_id NUMBER DEFAULT NULL) RETURN VARCHAR2 IS

........

Now, in case of any error, I have to show the error message and raise form_trigger_failure.

So in Actions tab, I am using type as "Message"