APPS.FND_NEW_MESSAGES_PKG dependencies on FND_NEW_MESSAGES_PKG

Line 1: package body FND_NEW_MESSAGES_PKG as

1: package body FND_NEW_MESSAGES_PKG as
2: /* $Header: AFMDMSGB.pls 120.4.12000000.1 2007/01/18 13:20:55 appldev ship $ */
3:
4: PROCEDURE CHECK_COMPATIBILITY is
5: sqlbuf VARCHAR2(1000);

Line 119: fnd_new_messages_pkg.check_compatibility;

115: -- which executes the insert statement according to which DB
116: -- (category/severity present or not present) is being used.
117: -- This is backward compatible for upgrades.
118:
119: fnd_new_messages_pkg.check_compatibility;
120:
121: sql_string := 'insert into FND_NEW_MESSAGES (
122: APPLICATION_ID,
123: LANGUAGE_CODE,

Line 136: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

132: DESCRIPTION,
133: TYPE,
134: MAX_LENGTH ';
135:
136: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
137: sql_string := sql_string || ',CATEGORY,
138: SEVERITY,
139: FND_LOG_SEVERITY ';
140: end if;

Line 158: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

154: B.DESCRIPTION,
155: B.TYPE,
156: B.MAX_LENGTH ';
157:
158: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
159: sql_string := sql_string ||
160: ', B.CATEGORY,
161: B.SEVERITY,
162: B.FND_LOG_SEVERITY ';

Line 196: fnd_new_messages_pkg.LOAD_ROW (

192: X_OWNER in VARCHAR2,
193: X_CUSTOM_MODE in VARCHAR2
194: ) is
195: begin
196: fnd_new_messages_pkg.LOAD_ROW (
197: X_APPLICATION_ID => X_APPLICATION_ID,
198: X_MESSAGE_NAME => X_MESSAGE_NAME,
199: X_MESSAGE_NUMBER => X_MESSAGE_NUMBER,
200: X_MESSAGE_TEXT => X_MESSAGE_TEXT,

Line 335: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

331: description = :2,
332: type = :3,
333: max_length = :4,';
334:
335: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
336:
337: sql_string := sql_string ||
338: 'category = :5,
339: severity = :6,

Line 351: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

347: last_update_login = 0
348: where application_id = :10
349: and message_name = :11';
350:
351: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
352:
353: execute immediate sql_string USING message_number,
354: description, msg_type, max_length,
355: category, severity, fnd_log_severity,

Line 397: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

393: description,
394: type,
395: max_length ';
396:
397: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
398: sql_string := sql_string || ',category,
399: severity,
400: fnd_log_severity ';
401: end if;

Line 419: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

415: :9,
416: :10,
417: :11';
418:
419: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
420: sql_string := sql_string ||
421: ', :12,
422: :13,
423: :14) ';

Line 428: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

424: else
425: sql_string := sql_string || ')';
426: end if;
427:
428: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
429:
430: execute immediate sql_string USING app_id, message_number,
431: X_MESSAGE_NAME, X_MESSAGE_TEXT,
432: f_ludate, f_luby, f_ludate, f_luby,

Line 453: fnd_new_messages_pkg.TRANSLATE_ROW (

449: X_OWNER in VARCHAR2,
450: X_CUSTOM_MODE in VARCHAR2
451: ) is
452: begin
453: fnd_new_messages_pkg.TRANSLATE_ROW (
454: X_APPLICATION_ID => X_APPLICATION_ID,
455: X_MESSAGE_NAME => X_MESSAGE_NAME,
456: X_MESSAGE_TEXT => X_MESSAGE_TEXT,
457: X_OWNER => X_OWNER,

Line 536: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

532: description,
533: type,
534: max_length ';
535:
536: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
537: sql_string := sql_string || ',category,
538: severity,
539: fnd_log_severity ';
540: end if;

Line 558: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

554: description,
555: type,
556: max_length';
557:
558: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
559: sql_string := sql_string ||
560: ', category,
561: severity,
562: fnd_log_severity ';

Line 581: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then

577: description,
578: type,
579: max_length ';
580:
581: if (FND_NEW_MESSAGES_PKG.ADDN_COLS = 'Y') then
582: sql_string := sql_string || ',category,
583: severity,
584: fnd_log_severity ';
585: end if;

Line 1024: end FND_NEW_MESSAGES_PKG;

1020: end if;
1021:
1022: end CHECK_CATEGORY_SEVERITY;
1023:
1024: end FND_NEW_MESSAGES_PKG;