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.CSD_GEN_ERRMSGS_PVT dependencies on FND_LOG

Line 67: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

63: l_app_short_name VARCHAR2(30);
64: l_message_name VARCHAR2(30);
65: BEGIN
66:
67: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
68: THEN
69: fnd_log.STRING (fnd_log.level_procedure,
70: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS.BEGIN',
71: 'Entered SAVE_FND_MSGS'

Line 69: fnd_log.STRING (fnd_log.level_procedure,

65: BEGIN
66:
67: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
68: THEN
69: fnd_log.STRING (fnd_log.level_procedure,
70: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS.BEGIN',
71: 'Entered SAVE_FND_MSGS'
72: );
73: END IF;

Line 89: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

85:
86: -- initialize return status
87: x_return_status := fnd_api.g_ret_sts_success;
88:
89: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
90: THEN
91: fnd_log.STRING (fnd_log.level_statement,
92: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
93: 'Checking required params'

Line 91: fnd_log.STRING (fnd_log.level_statement,

87: x_return_status := fnd_api.g_ret_sts_success;
88:
89: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
90: THEN
91: fnd_log.STRING (fnd_log.level_statement,
92: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
93: 'Checking required params'
94: );
95: END IF;

Line 103: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

99: p_param_name => 'p_module_code',
100: p_api_name => l_api_name
101: );
102:
103: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
104: THEN
105: fnd_log.STRING (fnd_log.level_statement,
106: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
107: 'module code is ok'

Line 105: fnd_log.STRING (fnd_log.level_statement,

101: );
102:
103: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
104: THEN
105: fnd_log.STRING (fnd_log.level_statement,
106: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
107: 'module code is ok'
108: );
109: END IF;

Line 117: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

113: p_param_name => 'p_source_entity_id1',
114: p_api_name => l_api_name
115: );
116:
117: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
118: THEN
119: fnd_log.STRING (fnd_log.level_statement,
120: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
121: 'p_source_entity_id1 is ok'

Line 119: fnd_log.STRING (fnd_log.level_statement,

115: );
116:
117: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
118: THEN
119: fnd_log.STRING (fnd_log.level_statement,
120: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
121: 'p_source_entity_id1 is ok'
122: );
123: END IF;

Line 131: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

127: p_param_name => 'p_source_entity_type_code',
128: p_api_name => l_api_name
129: );
130:
131: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
132: THEN
133: fnd_log.STRING (fnd_log.level_statement,
134: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
135: 'p_source_entity_type_code is ok'

Line 133: fnd_log.STRING (fnd_log.level_statement,

129: );
130:
131: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
132: THEN
133: fnd_log.STRING (fnd_log.level_statement,
134: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
135: 'p_source_entity_type_code is ok'
136: );
137: END IF;

Line 145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

141: p_param_name => 'p_source_entity_id2',
142: p_api_name => l_api_name
143: );
144:
145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
146: THEN
147: fnd_log.STRING (fnd_log.level_statement,
148: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
149: 'p_source_entity_id2 is ok'

Line 147: fnd_log.STRING (fnd_log.level_statement,

143: );
144:
145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
146: THEN
147: fnd_log.STRING (fnd_log.level_statement,
148: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
149: 'p_source_entity_id2 is ok'
150: );
151: END IF;

Line 160: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

156: fnd_msg_pub.ADD;
157: RAISE fnd_api.g_exc_error;
158: END IF;
159:
160: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
161: THEN
162: fnd_log.STRING (fnd_log.level_statement,
163: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
164: 'p_msg_module validation passed'

Line 162: fnd_log.STRING (fnd_log.level_statement,

158: END IF;
159:
160: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
161: THEN
162: fnd_log.STRING (fnd_log.level_statement,
163: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
164: 'p_msg_module validation passed'
165: );
166: END IF;

Line 172: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

168: fnd_msg_pub.RESET (p_mode => fnd_msg_pub.g_first);
169: l_count := fnd_msg_pub.count_msg;
170:
171: --Loop thru the message stack and insert into the generic error messages table.
172: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
173: THEN
174: fnd_log.STRING (fnd_log.level_statement,
175: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
176: 'Count of messages in the stack[' || l_count || ']'

Line 174: fnd_log.STRING (fnd_log.level_statement,

170:
171: --Loop thru the message stack and insert into the generic error messages table.
172: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
173: THEN
174: fnd_log.STRING (fnd_log.level_statement,
175: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
176: 'Count of messages in the stack[' || l_count || ']'
177: );
178: END IF;

Line 188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

184: -- to use the get_detail api. The message type should have been
185: -- added by the add_detail API.
186: l_msg := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_true);
187:
188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
189: THEN
190: fnd_log.STRING (fnd_log.level_statement,
191: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
192: 'Encoded message[' || l_msg || ']'

Line 190: fnd_log.STRING (fnd_log.level_statement,

186: l_msg := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_true);
187:
188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
189: THEN
190: fnd_log.STRING (fnd_log.level_statement,
191: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
192: 'Encoded message[' || l_msg || ']'
193: );
194: END IF;

Line 210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

206: (token => fnd_msg_pub.g_message_type_token_name,
207: remove_from_message => 'Y'
208: );
209:
210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
211: THEN
212: fnd_log.STRING (fnd_log.level_statement,
213: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
214: 'Message type[' || l_msg_type || ']'

Line 212: fnd_log.STRING (fnd_log.level_statement,

208: );
209:
210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
211: THEN
212: fnd_log.STRING (fnd_log.level_statement,
213: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
214: 'Message type[' || l_msg_type || ']'
215: );
216: END IF;

Line 248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

244: -- suppress the CS_COST_NO_CHARGE_EXIST message from charges
245: IF (l_msg IS NOT NULL)
246: AND NOT (l_app_short_name = 'CS' AND l_message_name = 'CS_COST_NO_CHARGE_EXIST')
247: THEN
248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
249: THEN
250: fnd_log.STRING (fnd_log.level_statement,
251: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
252: 'Adding record into generic error messages'

Line 250: fnd_log.STRING (fnd_log.level_statement,

246: AND NOT (l_app_short_name = 'CS' AND l_message_name = 'CS_COST_NO_CHARGE_EXIST')
247: THEN
248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
249: THEN
250: fnd_log.STRING (fnd_log.level_statement,
251: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
252: 'Adding record into generic error messages'
253: );
254: END IF;

Line 274: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

270: p_last_update_login => fnd_global.login_id,
271: p_object_version_number => 1 -- not needed
272: );
273:
274: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
275: THEN
276: fnd_log.STRING (fnd_log.level_statement,
277: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
278: 'Insert into generic error successful,id['

Line 276: fnd_log.STRING (fnd_log.level_statement,

272: );
273:
274: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
275: THEN
276: fnd_log.STRING (fnd_log.level_statement,
277: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
278: 'Insert into generic error successful,id['
279: || l_generic_errmsgs_id
280: || ']'

Line 298: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

294: -- Standard call to get message count and IF count is get message info.
295: fnd_msg_pub.count_and_get (p_count => x_msg_count,
296: p_data => x_msg_data);
297:
298: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
299: THEN
300: fnd_log.STRING (fnd_log.level_procedure,
301: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS.END',
302: 'Leaving SAVE_FND_MSGS'

Line 300: fnd_log.STRING (fnd_log.level_procedure,

296: p_data => x_msg_data);
297:
298: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
299: THEN
300: fnd_log.STRING (fnd_log.level_procedure,
301: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS.END',
302: 'Leaving SAVE_FND_MSGS'
303: );
304: END IF;

Line 314: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

310: fnd_msg_pub.count_and_get (p_count => x_msg_count,
311: p_data => x_msg_data
312: );
313:
314: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
315: THEN
316: fnd_log.STRING (fnd_log.level_error,
317: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
318: 'EXC_ERROR[' || x_msg_data || ']'

Line 316: fnd_log.STRING (fnd_log.level_error,

312: );
313:
314: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
315: THEN
316: fnd_log.STRING (fnd_log.level_error,
317: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
318: 'EXC_ERROR[' || x_msg_data || ']'
319: );
320: END IF;

Line 329: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

325: fnd_msg_pub.count_and_get (p_count => x_msg_count,
326: p_data => x_msg_data
327: );
328:
329: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
330: THEN
331: fnd_log.STRING (fnd_log.level_exception,
332: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
333: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'

Line 331: fnd_log.STRING (fnd_log.level_exception,

327: );
328:
329: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
330: THEN
331: fnd_log.STRING (fnd_log.level_exception,
332: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
333: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
334: );
335: END IF;

Line 350: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

346: fnd_msg_pub.count_and_get (p_count => x_msg_count,
347: p_data => x_msg_data
348: );
349:
350: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
351: THEN
352: fnd_log.STRING (fnd_log.level_exception,
353: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
354: 'SQL Message[' || SQLERRM || ']'

Line 352: fnd_log.STRING (fnd_log.level_exception,

348: );
349:
350: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
351: THEN
352: fnd_log.STRING (fnd_log.level_exception,
353: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
354: 'SQL Message[' || SQLERRM || ']'
355: );
356: END IF;

Line 386: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

382: l_api_name CONSTANT VARCHAR2 (30) := 'Purge_Msg';
383: BEGIN
384:
385:
386: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
387: THEN
388: fnd_log.STRING (fnd_log.level_procedure,
389: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG.BEGIN',
390: 'Entered Purge_Msg'

Line 388: fnd_log.STRING (fnd_log.level_procedure,

384:
385:
386: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
387: THEN
388: fnd_log.STRING (fnd_log.level_procedure,
389: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG.BEGIN',
390: 'Entered Purge_Msg'
391: );
392: END IF;

Line 427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

423: -- Standard call to get message count and IF count is get message info.
424: fnd_msg_pub.count_and_get (p_count => x_msg_count,
425: p_data => x_msg_data);
426:
427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
428: THEN
429: fnd_log.STRING (fnd_log.level_procedure,
430: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG.END',
431: 'Leaving Purge_Msg'

Line 429: fnd_log.STRING (fnd_log.level_procedure,

425: p_data => x_msg_data);
426:
427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
428: THEN
429: fnd_log.STRING (fnd_log.level_procedure,
430: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG.END',
431: 'Leaving Purge_Msg'
432: );
433: END IF;

Line 443: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

439: fnd_msg_pub.count_and_get (p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442:
443: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
444: THEN
445: fnd_log.STRING (fnd_log.level_error,
446: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG',
447: 'EXC_ERROR[' || x_msg_data || ']'

Line 445: fnd_log.STRING (fnd_log.level_error,

441: );
442:
443: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
444: THEN
445: fnd_log.STRING (fnd_log.level_error,
446: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG',
447: 'EXC_ERROR[' || x_msg_data || ']'
448: );
449: END IF;

Line 458: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

454: fnd_msg_pub.count_and_get (p_count => x_msg_count,
455: p_data => x_msg_data
456: );
457:
458: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
459: THEN
460: fnd_log.STRING (fnd_log.level_exception,
461: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG',
462: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'

Line 460: fnd_log.STRING (fnd_log.level_exception,

456: );
457:
458: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
459: THEN
460: fnd_log.STRING (fnd_log.level_exception,
461: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG',
462: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
463: );
464: END IF;

Line 479: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

475: fnd_msg_pub.count_and_get (p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478:
479: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
480: THEN
481: fnd_log.STRING (fnd_log.level_exception,
482: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG',
483: 'SQL Message[' || SQLERRM || ']'

Line 481: fnd_log.STRING (fnd_log.level_exception,

477: );
478:
479: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
480: THEN
481: fnd_log.STRING (fnd_log.level_exception,
482: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG',
483: 'SQL Message[' || SQLERRM || ']'
484: );
485: END IF;

Line 527: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

523: l_api_version_number CONSTANT NUMBER := 1.0;
524: l_api_name CONSTANT VARCHAR2 (30) := 'PURGE_ENTITY_MSGS';
525: BEGIN
526:
527: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
528: THEN
529: fnd_log.STRING
530: (fnd_log.level_procedure,
531: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS.BEGIN',

Line 529: fnd_log.STRING

525: BEGIN
526:
527: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
528: THEN
529: fnd_log.STRING
530: (fnd_log.level_procedure,
531: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS.BEGIN',
532: 'Entered PURGE_ENTITY_MSGS'
533: );

Line 530: (fnd_log.level_procedure,

526:
527: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
528: THEN
529: fnd_log.STRING
530: (fnd_log.level_procedure,
531: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS.BEGIN',
532: 'Entered PURGE_ENTITY_MSGS'
533: );
534: END IF;

Line 581: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

577: -- Standard call to get message count and IF count is get message info.
578: fnd_msg_pub.count_and_get (p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
582: THEN
583: fnd_log.STRING
584: (fnd_log.level_procedure,
585: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS.END',

Line 583: fnd_log.STRING

579: p_data => x_msg_data);
580:
581: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
582: THEN
583: fnd_log.STRING
584: (fnd_log.level_procedure,
585: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS.END',
586: 'Leaving PURGE_ENTITY_MSGS'
587: );

Line 584: (fnd_log.level_procedure,

580:
581: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
582: THEN
583: fnd_log.STRING
584: (fnd_log.level_procedure,
585: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS.END',
586: 'Leaving PURGE_ENTITY_MSGS'
587: );
588: END IF;

Line 598: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

594: fnd_msg_pub.count_and_get (p_count => x_msg_count,
595: p_data => x_msg_data
596: );
597:
598: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
599: THEN
600: fnd_log.STRING
601: (fnd_log.level_error,
602: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',

Line 600: fnd_log.STRING

596: );
597:
598: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
599: THEN
600: fnd_log.STRING
601: (fnd_log.level_error,
602: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',
603: 'EXC_ERROR[' || x_msg_data || ']'
604: );

Line 601: (fnd_log.level_error,

597:
598: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
599: THEN
600: fnd_log.STRING
601: (fnd_log.level_error,
602: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',
603: 'EXC_ERROR[' || x_msg_data || ']'
604: );
605: END IF;

Line 614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

610: fnd_msg_pub.count_and_get (p_count => x_msg_count,
611: p_data => x_msg_data
612: );
613:
614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
615: THEN
616: fnd_log.STRING
617: (fnd_log.level_exception,
618: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',

Line 616: fnd_log.STRING

612: );
613:
614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
615: THEN
616: fnd_log.STRING
617: (fnd_log.level_exception,
618: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',
619: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
620: );

Line 617: (fnd_log.level_exception,

613:
614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
615: THEN
616: fnd_log.STRING
617: (fnd_log.level_exception,
618: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',
619: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
620: );
621: END IF;

Line 636: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

632: fnd_msg_pub.count_and_get (p_count => x_msg_count,
633: p_data => x_msg_data
634: );
635:
636: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
637: THEN
638: fnd_log.STRING
639: (fnd_log.level_exception,
640: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',

Line 638: fnd_log.STRING

634: );
635:
636: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
637: THEN
638: fnd_log.STRING
639: (fnd_log.level_exception,
640: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',
641: 'SQL Message[' || SQLERRM || ']'
642: );

Line 639: (fnd_log.level_exception,

635:
636: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
637: THEN
638: fnd_log.STRING
639: (fnd_log.level_exception,
640: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',
641: 'SQL Message[' || SQLERRM || ']'
642: );
643: END IF;

Line 763: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

759: WHERE task_id = p_entity_id;
760: BEGIN
761:
762:
763: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
764: THEN
765: fnd_log.STRING (fnd_log.level_procedure,
766: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS.BEGIN',
767: 'Entered GET_ERRMSGS'

Line 765: fnd_log.STRING (fnd_log.level_procedure,

761:
762:
763: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
764: THEN
765: fnd_log.STRING (fnd_log.level_procedure,
766: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS.BEGIN',
767: 'Entered GET_ERRMSGS'
768: );
769: END IF;

Line 790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

786:
787: -- initialize return status
788: x_return_status := fnd_api.g_ret_sts_success;
789:
790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
791: THEN
792: fnd_log.STRING (fnd_log.level_statement,
793: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
794: 'Checking for required parameters'

Line 792: fnd_log.STRING (fnd_log.level_statement,

788: x_return_status := fnd_api.g_ret_sts_success;
789:
790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
791: THEN
792: fnd_log.STRING (fnd_log.level_statement,
793: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
794: 'Checking for required parameters'
795: );
796: END IF;

Line 804: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

800: p_param_name => 'p_module_code',
801: p_api_name => l_api_name
802: );
803:
804: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
805: THEN
806: fnd_log.STRING (fnd_log.level_statement,
807: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
808: 'module code is ok'

Line 806: fnd_log.STRING (fnd_log.level_statement,

802: );
803:
804: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
805: THEN
806: fnd_log.STRING (fnd_log.level_statement,
807: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
808: 'module code is ok'
809: );
810: END IF;

Line 819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

815: p_param_name => 'p_source_entity_id_1',
816: p_api_name => l_api_name
817: );
818:
819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
820: THEN
821: fnd_log.STRING (fnd_log.level_statement,
822: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
823: 'p_source_entity_id_1 is ok'

Line 821: fnd_log.STRING (fnd_log.level_statement,

817: );
818:
819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
820: THEN
821: fnd_log.STRING (fnd_log.level_statement,
822: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
823: 'p_source_entity_id_1 is ok'
824: );
825: END IF;

Line 829: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

825: END IF;
826:
827: l_index := 1;
828:
829: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
830: THEN
831: fnd_log.STRING (fnd_log.level_statement,
832: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
833: 'p_module_code=[' || p_module_code || ']'

Line 831: fnd_log.STRING (fnd_log.level_statement,

827: l_index := 1;
828:
829: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
830: THEN
831: fnd_log.STRING (fnd_log.level_statement,
832: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
833: 'p_module_code=[' || p_module_code || ']'
834: );
835: fnd_log.STRING (fnd_log.level_statement,

Line 835: fnd_log.STRING (fnd_log.level_statement,

831: fnd_log.STRING (fnd_log.level_statement,
832: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
833: 'p_module_code=[' || p_module_code || ']'
834: );
835: fnd_log.STRING (fnd_log.level_statement,
836: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
837: 'p_source_entity_type_code=['
838: || p_source_entity_type_code
839: || ']'

Line 841: fnd_log.STRING (fnd_log.level_statement,

837: 'p_source_entity_type_code=['
838: || p_source_entity_type_code
839: || ']'
840: );
841: fnd_log.STRING (fnd_log.level_statement,
842: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
843: 'p_source_entity_id_1=[' || p_source_entity_id_1
844: || ']'
845: );

Line 846: fnd_log.STRING (fnd_log.level_statement,

842: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
843: 'p_source_entity_id_1=[' || p_source_entity_id_1
844: || ']'
845: );
846: fnd_log.STRING (fnd_log.level_statement,
847: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
848: 'p_source_entity_id_2=[' || p_source_entity_id_2
849: || ']'
850: );

Line 952: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

948: x_errmsgs_tbl (l_index).msg := fnd_message.get;
949: l_index := l_index + 1;
950: END LOOP;
951:
952: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
953: THEN
954: fnd_log.STRING (fnd_log.level_statement,
955: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
956: 'Populated errmsgs table'

Line 954: fnd_log.STRING (fnd_log.level_statement,

950: END LOOP;
951:
952: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
953: THEN
954: fnd_log.STRING (fnd_log.level_statement,
955: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
956: 'Populated errmsgs table'
957: );
958: END IF;

Line 960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

956: 'Populated errmsgs table'
957: );
958: END IF;
959:
960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
961: THEN
962: fnd_log.STRING (fnd_log.level_procedure,
963: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS.END',
964: 'Leaving GET_ERRMSGS'

Line 962: fnd_log.STRING (fnd_log.level_procedure,

958: END IF;
959:
960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
961: THEN
962: fnd_log.STRING (fnd_log.level_procedure,
963: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS.END',
964: 'Leaving GET_ERRMSGS'
965: );
966: END IF;

Line 979: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

975: fnd_msg_pub.count_and_get (p_count => x_msg_count,
976: p_data => x_msg_data
977: );
978:
979: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
980: THEN
981: fnd_log.STRING (fnd_log.level_error,
982: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
983: 'EXC_ERROR[' || x_msg_data || ']'

Line 981: fnd_log.STRING (fnd_log.level_error,

977: );
978:
979: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
980: THEN
981: fnd_log.STRING (fnd_log.level_error,
982: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
983: 'EXC_ERROR[' || x_msg_data || ']'
984: );
985: END IF;

Line 993: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

989: fnd_msg_pub.count_and_get (p_count => x_msg_count,
990: p_data => x_msg_data
991: );
992:
993: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
994: THEN
995: fnd_log.STRING (fnd_log.level_exception,
996: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
997: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'

Line 995: fnd_log.STRING (fnd_log.level_exception,

991: );
992:
993: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
994: THEN
995: fnd_log.STRING (fnd_log.level_exception,
996: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
997: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
998: );
999: END IF;

Line 1013: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

1009: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012:
1013: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1014: THEN
1015: fnd_log.STRING (fnd_log.level_unexpected,
1016: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
1017: 'SQL Message[' || SQLERRM || ']'

Line 1015: fnd_log.STRING (fnd_log.level_unexpected,

1011: );
1012:
1013: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1014: THEN
1015: fnd_log.STRING (fnd_log.level_unexpected,
1016: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
1017: 'SQL Message[' || SQLERRM || ']'
1018: );
1019: END IF;

Line 1055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1051: l_msg_data VARCHAR2 (2000);
1052: l_msg_index_out NUMBER;
1053: l_index NUMBER;
1054: BEGIN
1055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1056: THEN
1057: fnd_log.STRING
1058: (fnd_log.level_procedure,
1059: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP.BEGIN',

Line 1057: fnd_log.STRING

1053: l_index NUMBER;
1054: BEGIN
1055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1056: THEN
1057: fnd_log.STRING
1058: (fnd_log.level_procedure,
1059: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP.BEGIN',
1060: 'Entered PURGE_ENTITY_MSGS_CP'
1061: );

Line 1058: (fnd_log.level_procedure,

1054: BEGIN
1055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1056: THEN
1057: fnd_log.STRING
1058: (fnd_log.level_procedure,
1059: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP.BEGIN',
1060: 'Entered PURGE_ENTITY_MSGS_CP'
1061: );
1062: END IF;

Line 1086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1082: p_encoded => fnd_api.g_false,
1083: p_data => l_msg_data,
1084: p_msg_index_out => l_msg_index_out
1085: );
1086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1087: THEN
1088: fnd_log.STRING
1089: (fnd_log.level_exception,
1090: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP',

Line 1088: fnd_log.STRING

1084: p_msg_index_out => l_msg_index_out
1085: );
1086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1087: THEN
1088: fnd_log.STRING
1089: (fnd_log.level_exception,
1090: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP',
1091: 'Error message [' || l_msg_data || ']'
1092: );

Line 1089: (fnd_log.level_exception,

1085: );
1086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1087: THEN
1088: fnd_log.STRING
1089: (fnd_log.level_exception,
1090: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP',
1091: 'Error message [' || l_msg_data || ']'
1092: );
1093: END IF;

Line 1101: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1097: errbuf := l_msg_data;
1098: retcode := 1;
1099: END IF;
1100:
1101: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1102: THEN
1103: fnd_log.STRING
1104: (fnd_log.level_procedure,
1105: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP.END',

Line 1103: fnd_log.STRING

1099: END IF;
1100:
1101: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1102: THEN
1103: fnd_log.STRING
1104: (fnd_log.level_procedure,
1105: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP.END',
1106: 'Leaving PURGE_ENTITY_MSGS_CP'
1107: );

Line 1104: (fnd_log.level_procedure,

1100:
1101: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1102: THEN
1103: fnd_log.STRING
1104: (fnd_log.level_procedure,
1105: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP.END',
1106: 'Leaving PURGE_ENTITY_MSGS_CP'
1107: );
1108: END IF;

Line 1112: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1108: END IF;
1109: EXCEPTION
1110: WHEN OTHERS
1111: THEN
1112: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1113: THEN
1114: fnd_log.STRING
1115: (fnd_log.level_exception,
1116: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP',

Line 1114: fnd_log.STRING

1110: WHEN OTHERS
1111: THEN
1112: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1113: THEN
1114: fnd_log.STRING
1115: (fnd_log.level_exception,
1116: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP',
1117: 'SQL Message[' || SQLERRM || ']'
1118: );

Line 1115: (fnd_log.level_exception,

1111: THEN
1112: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1113: THEN
1114: fnd_log.STRING
1115: (fnd_log.level_exception,
1116: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS_CP',
1117: 'SQL Message[' || SQLERRM || ']'
1118: );
1119: END IF;

Line 1150: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1146: );
1147:
1148: l_tmp_char VARCHAR2 (1);
1149: BEGIN
1150: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1151: THEN
1152: fnd_log.STRING
1153: (fnd_log.level_procedure,
1154: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE.BEGIN',

Line 1152: fnd_log.STRING

1148: l_tmp_char VARCHAR2 (1);
1149: BEGIN
1150: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1151: THEN
1152: fnd_log.STRING
1153: (fnd_log.level_procedure,
1154: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE.BEGIN',
1155: 'Entered VALIDATE_MODULE_CODE'
1156: );

Line 1153: (fnd_log.level_procedure,

1149: BEGIN
1150: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1151: THEN
1152: fnd_log.STRING
1153: (fnd_log.level_procedure,
1154: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE.BEGIN',
1155: 'Entered VALIDATE_MODULE_CODE'
1156: );
1157: END IF;

Line 1171: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1167: ELSE
1168: RETURN FALSE;
1169: END IF;
1170:
1171: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1172: THEN
1173: fnd_log.STRING
1174: (fnd_log.level_procedure,
1175: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE.END',

Line 1173: fnd_log.STRING

1169: END IF;
1170:
1171: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1172: THEN
1173: fnd_log.STRING
1174: (fnd_log.level_procedure,
1175: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE.END',
1176: 'Leaving VALIDATE_MODULE_CODE'
1177: );

Line 1174: (fnd_log.level_procedure,

1170:
1171: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1172: THEN
1173: fnd_log.STRING
1174: (fnd_log.level_procedure,
1175: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE.END',
1176: 'Leaving VALIDATE_MODULE_CODE'
1177: );
1178: END IF;

Line 1182: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1178: END IF;
1179: EXCEPTION
1180: WHEN OTHERS
1181: THEN
1182: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1183: THEN
1184: fnd_log.STRING
1185: (fnd_log.level_exception,
1186: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE',

Line 1184: fnd_log.STRING

1180: WHEN OTHERS
1181: THEN
1182: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1183: THEN
1184: fnd_log.STRING
1185: (fnd_log.level_exception,
1186: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE',
1187: 'SQL Error[' || SQLERRM || ']'
1188: );

Line 1185: (fnd_log.level_exception,

1181: THEN
1182: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1183: THEN
1184: fnd_log.STRING
1185: (fnd_log.level_exception,
1186: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.VALIDATE_MODULE_CODE',
1187: 'SQL Error[' || SQLERRM || ']'
1188: );
1189: END IF;