A user-named trigger is a trigger defined in a form by the developer. User-Named triggers do not automatically fire in response to a Oracle Forms event, and must be called 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('my_user_named_trigger');
Definition Level form, block, or item
Any commands that are legal in the parent trigger from which the user-named trigger was called.
Enter Query Mode no
Sets the FORM_FAILURE Built-in to TRUE. Because the user-named trigger is always called by the EXECUTE_TRIGGER Built-in, you can test the outcome of a user-named trigger the same way you test the outcome of a Built-in subprogram; that is, by testing for errors with the Built-in functions FORM_FAILURE, FORM_SUCCESS, FORM_FATAL .