Thursday, December 19, 2013

FND_MESSAGE Displaying only message code and not message text



--Application: The short name of the application this message is associated with. This short name references the application
--you associate with your message when
--you define it using the Messages form.
--
--Name: The message name that identifies your message. This name is identical to the name you use when you define your message

--using the Messages form. Message Dictionary names are not case sensitive (for example, MESSAGE_NAME is the same name as message_name).

--

--Procedure FND_MESSAGE.SET_NAME(application IN varchar2,
--                               name IN varchar2);

DECLARE
   l_message VARCHAR2 (4000);

BEGIN
   FND_MESSAGE.SET_NAME ('XXTST', 'XX_TEST_MSG_NAME');
   l_message := FND_MESSAGE.GET;
   DBMS_OUTPUT.put_line(l_message);

END;

--Note:-IF FND_MESSAGE.GET displays only the message code whatever
--is passed in the 2nd parameter and not message text, then, it
--means either the "Application Short Name" or the "Message Name" is
--incorrect
 

--Also, make sure the "Generate Messages" Concurrent Program is run
--from "Application Developer" responsibility

2 comments:

  1. "Madhu has 10+ years of experience in implementing Oracle Financials for Fortune 500 clients.
    He has around 3 years experience in imparting offline and online oracle apps technical trainings.
    You can contact him at madhusudhan10@gmail"
    skype id : madhusudhan.oracle


    Introduction to ERP

    Introduction of ERPs
    Key Attributes of ERP
    Dimensions of ERP
    ERP implementation overview
    ERP implementation phases
    Different ERPs and their features

    Introduction of Oracle Apps
    Advantages of Oracle Apps and its features
    Different finance functional modules and their basic functional flow.
    Major tables and their relationships in AP,GL,AR modules
    Architecture of Oracle Apps

    AOL
    Users and Responsibilities
    Concurrent Program
    Other AOL Objects
    •Profile Options
    •Lookups
    •Functions
    •Menus
    •Flexfield – Key/Descriptive
    •Messages
    Multi-Org Access Control (MOAC)
    Migration of AOL objects

    ReplyDelete