You can override messages in the form level ON-MESSAGE trigger.
The following is an example from the help.
DECLARE
alert_button NUMBER;
lv_errtype VARCHAR2(3) := MESSAGE_TYPE;
lv_errcod NUMBER := MESSAGE_CODE;
lv_errtxt VARCHAR2(80) := MESSAGE_TEXT;
BEGIN
IF lv_errcod = 40350 THEN
alert_button := Show_Alert('continue_alert');
IF alert_button = ALERT_BUTTON1 THEN
...
ELSE
...
END IF;
ELSE
Message(lv_errtyp||'-'||to_char(lv_errcod)||': '||lv_errtxt);
RAISE Form_Trigger_Failure;
END IF;
END;
Brian West wrote in message <38A04D19.C5F834E0_at_indosoft.nb.ca>...
>I am trying to override the default alert that oracle provides when
>unsaved changes exist and you try to exit the form. I would like my
>alert to be 'Unsaved Changes exist? Do you wish to save them?'
>YES -- No -- CANCEL ---> If 'yes' is clicked, a validation routine
>is run. If 'cancel' is clicked, you return to the form. These work fine.
>The problem is that when 'no' is clicked, I want to exit the form
>(full_rollback, no_commit), but the default oracle message appears
>following. Does anyoneknow how to suppress this? This functionality is
>currently inside the form level do_key(exit_form) trigger.
>
>Thanks
>
Received on Fri Feb 11 2000 - 10:00:32 CST