Hello, I am stumped on an issue, and have not found a solution using google. I am running on 12c forms, One of the data blocks has a timer that fires when specific data value is entered. This timer runs a function that inserts data into tables that are not on the form. This timer is launched from the pre-insert or pre-update triggers of the data block. This works great when using the Yellow "Save" button. The issue comes up when using the Green Door "Exit" with unsaved data. I am presented with "Do you want to save your Changes" and if I select Yes, it saves the data on the form, but not what runs in the timer. Thank you in advance for any assistance.
Here is the Key-Exit Trigger of the form
declare
alert_button number;
begin
IF :System.Form_Status = 'CHANGED' OR :System.Form_Status = 'NEW' THEN
alert_button := decision_appmsg(574); --Do you want to save the changes you made?
if alert_button = ALERT_BUTTON1 then
commit_form;
if Form_Success then
exit_form(do_commit);
else
raise FORM_TRIGGER_FAILURE;
end if;
else
exit_form(no_validate);
end if;
end if;
exit_form(ASK_COMMIT);
end;