Technology Stack - EBS (MOSC)

MOSC Banner

Control message format from a database package into a standard EBS Forms

edited Aug 20, 2021 10:51AM in Technology Stack - EBS (MOSC) Question

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center