eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_NEW_MESSAGES_PKG dependencies on FND_NEW_MESSAGES

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 16: FROM fnd_new_messages

12: PRAGMA EXCEPTION_INIT(COL_NOT_FOUND, -904);
13: BEGIN
14:
15: sqlbuf := 'SELECT category, severity, fnd_log_severity
16: FROM fnd_new_messages
17: WHERE ROWNUM < 2';
18:
19: begin
20:

Line 42: update FND_NEW_MESSAGES T set (

38: begin
39:
40: /***** Commented Update Statement
41:
42: update FND_NEW_MESSAGES T set (
43: MESSAGE_TEXT
44: ) = (select
45: B.MESSAGE_TEXT
46: from FND_NEW_MESSAGES B

Line 46: from FND_NEW_MESSAGES B

42: update FND_NEW_MESSAGES T set (
43: MESSAGE_TEXT
44: ) = (select
45: B.MESSAGE_TEXT
46: from FND_NEW_MESSAGES B
47: where B.APPLICATION_ID = T.APPLICATION_ID
48: and B.LANGUAGE_CODE = T.LANGUAGE_CODE
49: and B.MESSAGE_NAME = T.MESSAGE_NAME
50: and B.LANGUAGE = T.SOURCE_LANG)

Line 61: from FND_NEW_MESSAGES SUBB, FND_NEW_MESSAGES SUBT

57: SUBT.APPLICATION_ID,
58: SUBT.LANGUAGE_CODE,
59: SUBT.MESSAGE_NAME,
60: SUBT.LANGUAGE
61: from FND_NEW_MESSAGES SUBB, FND_NEW_MESSAGES SUBT
62: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
63: and SUBB.LANGUAGE_CODE = SUBT.LANGUAGE_CODE
64: and SUBB.MESSAGE_NAME = SUBT.MESSAGE_NAME
65: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 69: insert into FND_NEW_MESSAGES (

65: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
66: and (SUBB.MESSAGE_TEXT <> SUBT.MESSAGE_TEXT
67: ));
68:
69: insert into FND_NEW_MESSAGES (
70: FND_LOG_SEVERITY,
71: APPLICATION_ID,
72: LANGUAGE_CODE,
73: MESSAGE_NUMBER,

Line 103: from FND_NEW_MESSAGES B, FND_LANGUAGES L

99: B.TYPE,
100: B.MAX_LENGTH,
101: B.CATEGORY,
102: B.SEVERITY
103: from FND_NEW_MESSAGES B, FND_LANGUAGES L
104: where L.INSTALLED_FLAG in ('I', 'B')
105: and B.LANGUAGE_CODE = userenv('LANG')
106: and not exists
107: (select NULL

Line 108: from FND_NEW_MESSAGES T

104: where L.INSTALLED_FLAG in ('I', 'B')
105: and B.LANGUAGE_CODE = userenv('LANG')
106: and not exists
107: (select NULL
108: from FND_NEW_MESSAGES T
109: where T.APPLICATION_ID = B.APPLICATION_ID
110: and T.LANGUAGE_CODE = L.LANGUAGE_CODE
111: and T.MESSAGE_NAME = B.MESSAGE_NAME);
112: ******************/

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 121: sql_string := 'insert into FND_NEW_MESSAGES (

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,
124: MESSAGE_NUMBER,
125: MESSAGE_NAME,

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 166: ' from FND_NEW_MESSAGES B, FND_LANGUAGES L

162: B.FND_LOG_SEVERITY ';
163: end if;
164:
165: sql_string := sql_string ||
166: ' from FND_NEW_MESSAGES B, FND_LANGUAGES L
167: where L.INSTALLED_FLAG in (''I'', ''B'')
168: and B.LANGUAGE_CODE = ''' || userenv('LANG') || '''' ||
169: ' and not exists
170: (select NULL

Line 171: from FND_NEW_MESSAGES T

167: where L.INSTALLED_FLAG in (''I'', ''B'')
168: and B.LANGUAGE_CODE = ''' || userenv('LANG') || '''' ||
169: ' and not exists
170: (select NULL
171: from FND_NEW_MESSAGES T
172: where T.APPLICATION_ID = B.APPLICATION_ID
173: and T.LANGUAGE_CODE = L.LANGUAGE_CODE
174: and T.MESSAGE_NAME = B.MESSAGE_NAME)';
175:

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 308: from FND_NEW_MESSAGES

304:
305: begin
306: select LAST_UPDATED_BY, LAST_UPDATE_DATE
307: into db_luby, db_ludate
308: from FND_NEW_MESSAGES
309: where application_id = app_id
310: and language_code = userenv('LANG')
311: and message_name = X_MESSAGE_NAME;
312:

Line 329: sql_string := 'update fnd_new_messages set

325: -- Moved message_text to sql_string2 so message_text will be
326: -- updated for the current language only. NLS mode handles
327: -- updating message_text for translations.
328:
329: sql_string := 'update fnd_new_messages set
330: message_number = :1,
331: description = :2,
332: type = :3,
333: max_length = :4,';

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 366: sql_string := 'update fnd_new_messages set

362:
363: end if;
364:
365: -- bug 3562652 Added to handle TRANS attribute
366: sql_string := 'update fnd_new_messages set
367: message_text = :1
368: where application_id = :2
369: and message_name = :3
370: and language_code = ''' || userenv('LANG') || '''';

Line 382: sql_string := 'insert into fnd_new_messages

378: -- According to which DB (category/severity present or not present)
379: -- is being used, the correct section will execute for insertion.
380: -- This is backward compatible for upgrades.
381:
382: sql_string := 'insert into fnd_new_messages
383: (application_id,
384: language_code,
385: message_number,
386: message_name,

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 494: from FND_NEW_MESSAGES

490:
491: begin
492: select LAST_UPDATED_BY, LAST_UPDATE_DATE
493: into db_luby, db_ludate
494: from FND_NEW_MESSAGES
495: where application_id = app_id
496: and language_code = userenv('LANG')
497: and message_name = X_MESSAGE_NAME;
498:

Line 501: update fnd_new_messages set

497: and message_name = X_MESSAGE_NAME;
498:
499: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
500: db_ludate, X_CUSTOM_MODE)) then
501: update fnd_new_messages set
502: message_text = nvl(X_MESSAGE_TEXT, message_text),
503: last_updated_by = f_luby,
504: last_update_date = f_ludate,
505: last_update_login = 0

Line 521: sql_string := 'insert into fnd_new_messages

517: -- If row is not found during NLS mode, then just default the data from
518: -- any language, with a preference for US first, then Base,
519: -- then anything else
520:
521: sql_string := 'insert into fnd_new_messages
522: (application_id,
523: language_code,
524: message_number,
525: message_name,

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 589: ' from fnd_new_messages

585: end if;
586:
587:
588: sql_string := sql_string ||
589: ' from fnd_new_messages
590: where application_id = :6
591: and message_name = :7
592: order by decode(language_code, ''US'', 1,
593: (select L.language_code from fnd_languages L

Line 614: delete from FND_NEW_MESSAGES

610: X_MESSAGE_NAME in VARCHAR2
611: ) is
612: begin
613:
614: delete from FND_NEW_MESSAGES
615: where APPLICATION_ID = X_APPLICATION_ID
616: and LANGUAGE_CODE = X_LANGUAGE_CODE
617: and MESSAGE_NAME = X_MESSAGE_NAME;
618:

Line 1024: end FND_NEW_MESSAGES_PKG;

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