Validation Triggers in Oracle Forms

• When-Validate-Item:- Fires during the Validate the Item process. Specifically, it fires as the last part of item validation for items with the New or Changed validation status.                                                                                                                                                                              
• When-Validate-Record:- Fires during the Validate the Record process. Specifically, it fires as the last part of record validation for records with the New or Changed validation status.

• User-Named Trigger:-A user-named trigger is a trigger that you define yourself in a form, and then call explicitly from other triggers or user-named subprograms. Each user-named trigger defined at the same definition level must have a unique name.                                                     To execute a user-named trigger, you must call the EXECUTE_TRIGGER built-in procedure, as shown here:

          Execute_Trigger('user_named_trigger');