How to Use Message in Oracle Apps?

     

How to Use Message in Oracle Apps?

         Step 1:- First Create Custom Message.

          Navigation:- Application Developer -> Application -> Messages

        Name:- XXC05 TEST MESSAGE

Step 2:- Use custom message in our code.

declare

xxc_message varchar2(100);

begin

fnd_global.apps_initialize(user_id=>1013459,

       resp_id=>65722,

                                                       resp_appl_id=>706

                                           );

fnd_message.clear;

             --fnd_message.set_name(Application Short Name,Message Name);

fnd_message.set_name('WIP','XXC05 TEST MESSAGE');

xxc_message:=fnd_message.get;

dbms_output.put_line(xxc_message);                           

end;

Output:-

This message created by Sajal Agarwal.

How to Use Token in Message Oracle Apps?

               Step 1:- First Create Custom Message.

              Navigation:- Application Developer -> Application -> Messages

                Name:- XXC05 TOKEN MESSAGE

Step 2:- Use custom message in our code.

       declare

xxc_message varchar2(100);

begin

fnd_global.apps_initialize(user_id=>1013459,

                                                   resp_id=>65722,

                                                       resp_appl_id=>706

                                                       );

fnd_message.clear;

             --fnd_message.set_name(Application short name,msg name);

fnd_message.set_name('WIP','XXC05 TOKEN MESSAGE');

             --fnd_message.set_token(Token Name,Value);

fnd_message.set_token('USERID',fnd_global.user_id);

fnd_message.set_token('ORGID',fnd_global.org_id);

xxc_message:=fnd_message.get;

dbms_output.put_line(xxc_message);                           

end;

Output:-

This message is the example of Token Message.User id is 1013459 and Org id is 204.