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.CSM_NEW_MESSAGES_PKG dependencies on CSM_NEW_MESSAGES

Line 1: PACKAGE BODY CSM_NEW_MESSAGES_PKG AS

1: PACKAGE BODY CSM_NEW_MESSAGES_PKG AS
2: /* $Header: csmlnmgb.pls 120.2 2006/05/09 05:52:12 utekumal noship $ */
3:
4: PROCEDURE INSERT_ROW (
5: X_MESSAGE_ID NUMBER,

Line 18: INSERT INTO CSM_NEW_MESSAGES

14: IS
15:
16: BEGIN
17: --Insert into base table
18: INSERT INTO CSM_NEW_MESSAGES
19: (MESSAGE_ID,
20: MESSAGE_NAME,
21: MESSAGE_TYPE,
22: MESSAGE_LENGTH,

Line 41: INSERT INTO CSM_NEW_MESSAGES_TL

37: );
38:
39:
40: --Insert into TL table
41: INSERT INTO CSM_NEW_MESSAGES_TL
42: (MESSAGE_ID,
43: MESSAGE_NAME,
44: MESSAGE_TEXT,
45: DESCRIPTION,

Line 66: FROM CSM_NEW_MESSAGES_TL T

62: FROM FND_LANGUAGES L
63: WHERE L.INSTALLED_FLAG in ('I', 'B')
64: AND NOT EXISTS
65: (SELECT NULL
66: FROM CSM_NEW_MESSAGES_TL T
67: WHERE T.MESSAGE_NAME = X_MESSAGE_NAME);
68:
69:
70: END INSERT_ROW;

Line 76: DELETE FROM CSM_NEW_MESSAGES_TL TL

72: PROCEDURE ADD_LANGUAGE
73: IS
74: BEGIN
75: --deleting obsolete TL records
76: DELETE FROM CSM_NEW_MESSAGES_TL TL
77: WHERE NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES B
78: WHERE B.MESSAGE_ID=TL.MESSAGE_ID);
79:
80: --no need for TL table update since we are taking care of it in UPDATE_ROW api itself.

Line 77: WHERE NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES B

73: IS
74: BEGIN
75: --deleting obsolete TL records
76: DELETE FROM CSM_NEW_MESSAGES_TL TL
77: WHERE NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES B
78: WHERE B.MESSAGE_ID=TL.MESSAGE_ID);
79:
80: --no need for TL table update since we are taking care of it in UPDATE_ROW api itself.
81:

Line 84: INSERT INTO CSM_NEW_MESSAGES_TL

80: --no need for TL table update since we are taking care of it in UPDATE_ROW api itself.
81:
82:
83: --insert TL records for new language
84: INSERT INTO CSM_NEW_MESSAGES_TL
85: (MESSAGE_ID,
86: MESSAGE_NAME,
87: MESSAGE_TEXT,
88: DESCRIPTION,

Line 105: FROM CSM_NEW_MESSAGES_TL B,

101: B.CREATION_DATE,
102: B.CREATED_BY,
103: B.LAST_UPDATE_DATE,
104: B.LAST_UPDATED_BY
105: FROM CSM_NEW_MESSAGES_TL B,
106: FND_LANGUAGES L
107: WHERE B.LANGUAGE = userenv('LANG')
108: AND L.INSTALLED_FLAG in ('I', 'B')
109: AND NOT EXISTS

Line 111: FROM CSM_NEW_MESSAGES_TL T

107: WHERE B.LANGUAGE = userenv('LANG')
108: AND L.INSTALLED_FLAG in ('I', 'B')
109: AND NOT EXISTS
110: (SELECT NULL
111: FROM CSM_NEW_MESSAGES_TL T
112: WHERE T.MESSAGE_NAME = B.MESSAGE_NAME
113: AND T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: END ADD_LANGUAGE;

Line 131: UPDATE CSM_NEW_MESSAGES

127: IS
128:
129: BEGIN
130: --Update base Table
131: UPDATE CSM_NEW_MESSAGES
132: SET MESSAGE_TYPE = X_MESSAGE_TYPE,
133: MESSAGE_LENGTH = X_MESSAGE_LENGTH,
134: UPDATABLE = X_UPDATABLE,
135: LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0),

Line 140: UPDATE CSM_NEW_MESSAGES_TL

136: LAST_UPDATE_DATE = SYSDATE
137: WHERE MESSAGE_NAME = X_MESSAGE_NAME;
138:
139: --Update TL Table
140: UPDATE CSM_NEW_MESSAGES_TL
141: SET MESSAGE_TEXT = X_MESSAGE_TEXT,
142: DESCRIPTION = X_DESCRIPTION,
143: SOURCE_LANGUAGE = userenv('LANG'),
144: LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0),

Line 165: FROM CSM_NEW_MESSAGES CNM

161: IS
162:
163: CURSOR c_message_exists(b_message_name VARCHAR2) IS
164: SELECT 1
165: FROM CSM_NEW_MESSAGES CNM
166: WHERE CNM.MESSAGE_NAME = b_message_name;
167:
168: l_exists NUMBER;
169:

Line 180: SELECT CSM_NEW_MESSAGES_S.NEXTVAL into X_MESSAGE_ID FROM dual;

176: CLOSE c_message_exists;
177:
178: IF l_exists IS NULL THEN
179:
180: SELECT CSM_NEW_MESSAGES_S.NEXTVAL into X_MESSAGE_ID FROM dual;
181:
182: Insert_Row(
183: X_MESSAGE_ID,
184: X_MESSAGE_NAME,

Line 222: FROM CSM_NEW_MESSAGES CNM

218: IS
219:
220: CURSOR c_message_exists(b_message_name VARCHAR2) IS
221: SELECT 1
222: FROM CSM_NEW_MESSAGES CNM
223: WHERE CNM.MESSAGE_NAME = b_message_name;
224:
225: l_exists NUMBER;
226:

Line 235: UPDATE CSM_NEW_MESSAGES_TL SET

231: CLOSE c_message_exists;
232:
233: IF l_exists IS NOT NULL THEN
234:
235: UPDATE CSM_NEW_MESSAGES_TL SET
236: MESSAGE_TEXT = nvl(X_MESSAGE_TEXT, MESSAGE_TEXT),
237: DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),
238: LAST_UPDATE_DATE = SYSDATE,
239: LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0),

Line 266: INSERT INTO CSM_NEW_MESSAGES_PERZ

262: errmsg varchar2(4000);
263:
264: BEGIN
265: --Insert into Perz table
266: INSERT INTO CSM_NEW_MESSAGES_PERZ
267: (MESSAGE_ID,
268: MESSAGE_NAME,
269: LEVEL_ID,
270: LEVEL_VALUE,

Line 309: UPDATE CSM_NEW_MESSAGES_PERZ

305: IS
306:
307: BEGIN
308: --Update base Table
309: UPDATE CSM_NEW_MESSAGES_PERZ
310: SET MESSAGE_TEXT = X_MESSAGE_TEXT,
311: DESCRIPTION = X_DESCRIPTION,
312: LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0),
313: LAST_UPDATE_DATE = SYSDATE

Line 335: FROM CSM_NEW_MESSAGES_PERZ PERZ

331: IS
332:
333: CURSOR c_message_exists(b_message_name VARCHAR2, b_level_id NUMBER, b_level_value NUMBER, b_language VARCHAR2) IS
334: SELECT 1
335: FROM CSM_NEW_MESSAGES_PERZ PERZ
336: WHERE PERZ.MESSAGE_NAME = b_message_name
337: AND PERZ.LEVEL_ID = b_level_id
338: AND PERZ.LEVEL_VALUE = b_level_value
339: AND PERZ.LANGUAGE = b_language;

Line 344: FROM CSM_NEW_MESSAGES CNM

340:
341:
342: CURSOR c_get_msg_id(b_message_name VARCHAR2) IS
343: SELECT MESSAGE_ID
344: FROM CSM_NEW_MESSAGES CNM
345: WHERE CNM.MESSAGE_NAME = b_message_name;
346:
347: l_exists NUMBER;
348:

Line 392: END CSM_NEW_MESSAGES_PKG;

388:
389: END LOAD_ROW_PERZ;
390:
391:
392: END CSM_NEW_MESSAGES_PKG;