Hi,
I am working on forms personalizations on 12.1.3.
I have a condition on WHEN_VALIDATE_RECORD. In actions I have added a message to display the error message and on second line I have given RAISE FORM_TRIGGER_FAILURE.
On the actual form when I am saving the changes, the error message is getting displayed. But when I close the window another message pops up asking to save changes. On clicking Yes the changes are saved. This should not happen. Somehow FORM_TRIGGER_FAILURE is not working.
I have tried creating a built in procedure to call from personalizations. But this action is not getting called at all.
I have also tried with various trigger events and item-block properties, but still all the changes are getting saved.
Am I missing any step here? Is there any alternative to stop the form from saving the changes?
Thank you.
Aditya
