I usually develop database packages from where all business logic should be taken, which simplifies development for different interfaces. However, I don't know what I am missing here.
After running this application, page 2 (customers) shows a report where I click on a pencil so I can edit its information on page 3, which is a popup. Page 3 has a validation which runs after submitting (Validate ADM_CUSTOMERS), and it calls a database package which validates all data that was submitted. Problem: I was expecting the PL/SQL function returning an error text to return a message, however I get a generic error instead.
Reproducing the issue is simple: after clicking the pencil to edit the only row at page 2, just erase "Name" field, click "Apply changes" button to submit it, and user should get an error message: "name must be informed". But I get a generic error instead: "error processing validation". I am sure this is pretty simple, however I cannot find what I am doing wrong, or how to workaround it. Thanks for supporting.
Credentials for apex.oracle.com:
workspace: franklinjr
username: help
password: helphelp
application: 102817 (Leasing)
Regards, Franklin