We are using APEX 20.1 with on a 18.0 DB
I have an interactive grid, works fine most of the time. Using a PL/SQL Target type code for processing.
The PL/SQL has pre-insert and pre-update validations in the insert/update packages.
The insert/update process all seems to be working just fine and the records refresh when all validations in the page are passed and the validations in the package are successful.
The page works as expected when a page validation fails. The error message is displayed, with no extra messages.
The problem comes in when the validations in the page are passed and then one of the validations in the package fail.
In the PL/SQL Code that is calling the package I am using the following to display the error returned from the package where v_error_msg is the message I want to display:
apex_error.add_error(p_message => v_error_msg,
p_display_location => apex_error.c_inline_in_notification );
What happens is that when an error is returned from the package, the correct error displays, but the page still attempts to refresh so the message "There are unsaved changes. Do you want to continue?" comes up also. How do I get the page to refresh when there is complete success and not when there are errors from the PL/SQL package.
I am currently using a Dynamic Action to refresh the page with server side condition "Inline Validation Errors NOT displayed" and the false action being Refresh region :
Really do not know what to try next. Any assistance on this would be appreciated.
Tillie