HELP!!!!
My question is:
If I have several validations and one of them fails, do the page processes below them get executed or are they bypassed, waiting for the validations to pass? I have two processes called Update_MthYr and UpdateInvoiceTotal declared as PL/SQL anonymous Blocks that are called and executed after the APPLYMRU and APPLYMRD processes in a Master/Detail form. Do these processes get called anyway even if a validation fails?
The processes update the Detail table with calculated information. I am afraid that the failed validation process is not keeping the page processes from executing thereby causing a COMMIT and then the associated 'Current version of data in database has changed since user initiated update process.' error when I try to update a field on the detail portion of the page.
What do you think?
Should these processes be called in triggers instead?
Can I call procedures to update the same table that the trigger is based on? Ex. Procedure updates Vendor_detail and Trigger is associated with Vendor_detail.