which oracle table stores error messages please ? Is it FND_NEW_MESSAGES . E.g when loading data from interface to standard table , a validation fails , where is that error message stored please ? And how to fetch that message please in a procedure ?
Are customized messages stored in this table please ?
Also can you fetch name & text by using a procedure passing message num as parameter please ? Thanks.Yes.
twinklin_girl wrote:Why don't you simply use the functions provided by the package API? See the code of the package in the two links referenced in my previous reply.
E.g O need to fetch MESSAGE_NAME,MESSAGE_TEXT,DESCRIPTION from FND_NEW_MESSAGES based on MESSAGE_NUMBER . Can I use a procedure as :
PROCEDURE fetch_msg_det(NUM IN NUMBER,m_name OUT VARCHAR2,m_t OUT VARCHAR2) is
SELECT m.message_name, m.message_text
FROM FND_NEW_MESSAGES M
WHERE m.language_code = 'US'
and m.message_number = :num ;
I need to fetch these values(m_name,m_t) and store into another table , how do I do that ?