APPS.CZ_UI_GENERATOR dependencies on FND_NEW_MESSAGES

Line 473: var_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

469: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
470: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
471:
472: FUNCTION getMessage(in_message IN VARCHAR2) RETURN VARCHAR IS
473: var_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
474: BEGIN
475: var_message_text:=NULL;
476: SELECT MESSAGE_TEXT INTO var_message_text FROM FND_NEW_MESSAGES
477: WHERE MESSAGE_NAME=in_message AND language_code=mCURRENT_LANG;

Line 476: SELECT MESSAGE_TEXT INTO var_message_text FROM FND_NEW_MESSAGES

472: FUNCTION getMessage(in_message IN VARCHAR2) RETURN VARCHAR IS
473: var_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
474: BEGIN
475: var_message_text:=NULL;
476: SELECT MESSAGE_TEXT INTO var_message_text FROM FND_NEW_MESSAGES
477: WHERE MESSAGE_NAME=in_message AND language_code=mCURRENT_LANG;
478: RETURN var_message_text;
479: EXCEPTION
480: WHEN NO_DATA_FOUND THEN

Line 5504: FOR i IN(SELECT message_text,language_code FROM FND_NEW_MESSAGES WHERE message_name=in_caption)

5500: IF in_caption IS NOT NULL THEN
5501: var_caption_id:=getTXTSeqVal;
5502: UPDATE CZ_UI_NODES SET caption_id=var_caption_id
5503: WHERE ui_def_id=in_def_id AND ui_node_id=in_id;
5504: FOR i IN(SELECT message_text,language_code FROM FND_NEW_MESSAGES WHERE message_name=in_caption)
5505: LOOP
5506: INSERT INTO CZ_LOCALIZED_TEXTS
5507: (INTL_TEXT_ID,
5508: LOCALIZED_STR,