Control message format from a database package into a standard EBS Forms
Hello,
Some details.
I need to control the entered values of the emails in the CRM forms Contact Center and Service.
2 controls: 1 the email must be like %@%.% and must be unique in the database.
I have start to work on a database trigger on the table hz_contact_points who call a specific database package for the rules of the controls.
That work but the message return to the user in the form is not user friendly.
in my package i have insert this code
fnd_message.set_name('XXX','XXX_CUSTOM_CSCCCRC_MAIL'):
app_exception.raise_exception;
and in the form i receive a Note popup with