APPS.FND_MESSAGE dependencies on FND_NEW_MESSAGES

Line 14: message_text FND_NEW_MESSAGES.message_text%TYPE,

10: FND_LOG_MODULE varchar2(255) := DEFAULT_FND_LOG_MODULE;
11:
12: TYPE MSG_REC_TYPE is RECORD (
13: message_name VARCHAR(90), -- Concat of MSGNAME(30), LANGCODE(4), APPSHRT(50)
14: message_text FND_NEW_MESSAGES.message_text%TYPE,
15: message_number FND_NEW_MESSAGES.message_number%TYPE,
16: type FND_NEW_MESSAGES.type%TYPE,
17: fnd_log_severity FND_NEW_MESSAGES.fnd_log_severity%TYPE,
18: category FND_NEW_MESSAGES.category%TYPE,

Line 15: message_number FND_NEW_MESSAGES.message_number%TYPE,

11:
12: TYPE MSG_REC_TYPE is RECORD (
13: message_name VARCHAR(90), -- Concat of MSGNAME(30), LANGCODE(4), APPSHRT(50)
14: message_text FND_NEW_MESSAGES.message_text%TYPE,
15: message_number FND_NEW_MESSAGES.message_number%TYPE,
16: type FND_NEW_MESSAGES.type%TYPE,
17: fnd_log_severity FND_NEW_MESSAGES.fnd_log_severity%TYPE,
18: category FND_NEW_MESSAGES.category%TYPE,
19: severity FND_NEW_MESSAGES.severity%TYPE

Line 16: type FND_NEW_MESSAGES.type%TYPE,

12: TYPE MSG_REC_TYPE is RECORD (
13: message_name VARCHAR(90), -- Concat of MSGNAME(30), LANGCODE(4), APPSHRT(50)
14: message_text FND_NEW_MESSAGES.message_text%TYPE,
15: message_number FND_NEW_MESSAGES.message_number%TYPE,
16: type FND_NEW_MESSAGES.type%TYPE,
17: fnd_log_severity FND_NEW_MESSAGES.fnd_log_severity%TYPE,
18: category FND_NEW_MESSAGES.category%TYPE,
19: severity FND_NEW_MESSAGES.severity%TYPE
20: );

Line 17: fnd_log_severity FND_NEW_MESSAGES.fnd_log_severity%TYPE,

13: message_name VARCHAR(90), -- Concat of MSGNAME(30), LANGCODE(4), APPSHRT(50)
14: message_text FND_NEW_MESSAGES.message_text%TYPE,
15: message_number FND_NEW_MESSAGES.message_number%TYPE,
16: type FND_NEW_MESSAGES.type%TYPE,
17: fnd_log_severity FND_NEW_MESSAGES.fnd_log_severity%TYPE,
18: category FND_NEW_MESSAGES.category%TYPE,
19: severity FND_NEW_MESSAGES.severity%TYPE
20: );
21:

Line 18: category FND_NEW_MESSAGES.category%TYPE,

14: message_text FND_NEW_MESSAGES.message_text%TYPE,
15: message_number FND_NEW_MESSAGES.message_number%TYPE,
16: type FND_NEW_MESSAGES.type%TYPE,
17: fnd_log_severity FND_NEW_MESSAGES.fnd_log_severity%TYPE,
18: category FND_NEW_MESSAGES.category%TYPE,
19: severity FND_NEW_MESSAGES.severity%TYPE
20: );
21:
22: type MSG_TAB_TYPE is table of MSG_REC_TYPE index by binary_integer;

Line 19: severity FND_NEW_MESSAGES.severity%TYPE

15: message_number FND_NEW_MESSAGES.message_number%TYPE,
16: type FND_NEW_MESSAGES.type%TYPE,
17: fnd_log_severity FND_NEW_MESSAGES.fnd_log_severity%TYPE,
18: category FND_NEW_MESSAGES.category%TYPE,
19: severity FND_NEW_MESSAGES.severity%TYPE
20: );
21:
22: type MSG_TAB_TYPE is table of MSG_REC_TYPE index by binary_integer;
23:

Line 537: from fnd_new_messages m, fnd_application a

533: MSG_REC MSG_REC_TYPE;
534: LANG_CODE varchar2(4);
535: cursor c1(NAME_ARG varchar2, LANG_ARG varchar2) is
536: select message_text, message_number, type, fnd_log_severity, category, severity
537: from fnd_new_messages m, fnd_application a
538: where NAME_ARG = m.message_name
539: and LANG_ARG = m.language_code
540: and APPIN = a.application_short_name
541: and m.application_id = a.application_id;