Hi,
I'm currently in the middle of a migration project. I need the following.
Change the status of a record.
During the status change a plsql procedure is called doing some checks.
Multiple errors can occur which are written in a table.
At the end show the errors in the application.
So far I'm using apex_error to achieve this.
I have a validation process which fires when I press a button.
After this a save process is executed.
In the validation a plsql procedure is called doing the checks.
And at the end is querying my table.
Working fine.
Like
for r in (select \*
from my\_table
)
loop
apex\_error.add\_error( p\_display\_location => apex\_error.c\_inline\_in\_notification
, p\_message => r.text);
end loop;
But here is the problem.
Some of the checks are only warnings. Not errors. And the status change should be executed anyway.
If I use apex_error than the status change will not be executed. I guess the save process will not be fired any more?
So how can I achieve to show warnings to the user?
And to save the status change.
Regards, Peter