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.CSL_TASKS_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 31: jtm_message_log_pkg.Log_Msg

27: l_msg_data VARCHAR2(240);
28: l_task_id jtf_tasks_b.task_id%type;
29: BEGIN
30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
31: jtm_message_log_pkg.Log_Msg
32: ( v_object_id => p_record.task_id
33: , v_object_name => g_object_name
34: , v_message => 'Entering CSL_TASKS_PKG.APPLY_INSERT'
35: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 92: jtm_message_log_pkg.Log_Msg

88: );
89: END IF;
90:
91: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
92: jtm_message_log_pkg.Log_Msg
93: ( v_object_id => p_record.task_id
94: , v_object_name => g_object_name
95: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_INSERT'
96: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 101: jtm_message_log_pkg.Log_Msg

97: END IF;
98:
99: EXCEPTION WHEN OTHERS THEN
100: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
101: jtm_message_log_pkg.Log_Msg
102: ( v_object_id => p_record.task_id
103: , v_object_name => g_object_name
104: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
105: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 115: jtm_message_log_pkg.Log_Msg

111: p_api_error => TRUE
112: );
113:
114: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
115: jtm_message_log_pkg.Log_Msg
116: ( v_object_id => p_record.task_id
117: , v_object_name => g_object_name
118: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_INSERT'
119: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 157: jtm_message_log_pkg.Log_Msg

153: l_profile_value VARCHAR2(240);
154:
155: BEGIN
156: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
157: jtm_message_log_pkg.Log_Msg
158: ( v_object_id => p_record.task_id
159: , v_object_name => g_object_name
160: , v_message => 'Entering CSL_TASKS_PKG.APPLY_UPDATE'
161: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 174: jtm_message_log_pkg.Log_Msg

170: if c_last_update_date%found then
171: if r_last_update_date.last_update_date <> p_record.last_update_date then
172: close c_last_update_date;
173: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
174: jtm_message_log_pkg.Log_Msg
175: ( v_object_id => p_record.task_id
176: , v_object_name => g_object_name
177: , v_message => 'Record has stale data'
178: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 186: jtm_message_log_pkg.Log_Msg

182: , 'JTM_STALE_DATA'
183: );
184: fnd_msg_pub.add;
185: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
186: jtm_message_log_pkg.Log_Msg
187: ( v_object_id => p_record.task_id
188: , v_object_name => g_object_name
189: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
190: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 198: jtm_message_log_pkg.Log_Msg

194: return;
195: end if;
196: else
197: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
198: jtm_message_log_pkg.Log_Msg
199: ( v_object_id => p_record.task_id
200: , v_object_name => g_object_name
201: , v_message => 'No record found in Apps Database.'
202: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 261: jtm_message_log_pkg.Log_Msg

257: );
258: END IF;
259:
260: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
261: jtm_message_log_pkg.Log_Msg
262: ( v_object_id => p_record.task_id
263: , v_object_name => g_object_name
264: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_UPDATE'
265: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 270: jtm_message_log_pkg.Log_Msg

266: END IF;
267:
268: EXCEPTION WHEN OTHERS THEN
269: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
270: jtm_message_log_pkg.Log_Msg
271: ( v_object_id => p_record.task_id
272: , v_object_name => g_object_name
273: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
274: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 284: jtm_message_log_pkg.Log_Msg

280: p_api_error => TRUE
281: );
282:
283: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
284: jtm_message_log_pkg.Log_Msg
285: ( v_object_id => p_record.task_id
286: , v_object_name => g_object_name
287: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_UPDATE'
288: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 311: jtm_message_log_pkg.Log_Msg

307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: FND_MSG_PUB.INITIALIZE;
309:
310: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
311: jtm_message_log_pkg.Log_Msg
312: ( v_object_id => p_record.task_id
313: , v_object_name => g_object_name
314: , v_message => 'Entering CSL_TASKS_PKG.APPLY_RECORD'
315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 319: jtm_message_log_pkg.Log_Msg

315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
316: END IF;
317:
318: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
319: jtm_message_log_pkg.Log_Msg
320: ( v_object_id => p_record.task_id
321: , v_object_name => g_object_name
322: , v_message => 'Processing task_id = ' || p_record.task_id || fnd_global.local_chr(10) ||
323: 'DMLTYPE = ' || p_record.dmltype$$

Line 346: jtm_message_log_pkg.Log_Msg

342: );
343: ELSIF p_record.dmltype$$='D' THEN
344: -- Process delete; not supported for this entity
345: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
346: jtm_message_log_pkg.Log_Msg
347: ( v_object_id => p_record.task_id
348: , v_object_name => g_object_name
349: , v_message => 'Delete is not supported for this entity'
350: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 364: jtm_message_log_pkg.Log_Msg

360: x_return_status := FND_API.G_RET_STS_ERROR;
361: ELSE
362: -- invalid dml type
363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
364: jtm_message_log_pkg.Log_Msg
365: ( v_object_id => p_record.task_id
366: , v_object_name => g_object_name
367: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
368: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 398: jtm_message_log_pkg.Log_Msg

394: );
395: END IF;
396:
397: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
398: jtm_message_log_pkg.Log_Msg
399: ( v_object_id => p_record.task_id
400: , v_object_name => g_object_name
401: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_RECORD'
402: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 407: jtm_message_log_pkg.Log_Msg

403: END IF;
404: EXCEPTION WHEN OTHERS THEN
405: /*** defer record when any process exception occurs ***/
406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
407: jtm_message_log_pkg.Log_Msg
408: ( v_object_id => p_record.task_id
409: , v_object_name => g_object_name
410: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
411: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 421: jtm_message_log_pkg.Log_Msg

417: p_api_error => TRUE
418: );
419:
420: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
421: jtm_message_log_pkg.Log_Msg
422: ( v_object_id => p_record.task_id
423: , v_object_name => g_object_name
424: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_RECORD'
425: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 452: jtm_message_log_pkg.Log_Msg

448: g_debug_level := p_debug_level;
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
452: jtm_message_log_pkg.Log_Msg
453: ( v_object_id => null
454: , v_object_name => g_object_name
455: , v_message => 'Entering CSL_TASKS_PKG.Apply_Client_Changes'
456: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 476: jtm_message_log_pkg.Log_Msg

472: /*** was record processed successfully? ***/
473: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
474: /*** Yes -> delete record from inqueue ***/
475: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
476: jtm_message_log_pkg.Log_Msg
477: ( v_object_id => r_task.task_id
478: , v_object_name => g_object_name
479: , v_message => 'Record successfully processed, deleting from inqueue'
480: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 499: jtm_message_log_pkg.Log_Msg

495: /*** was delete successful? ***/
496: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
497: /*** no -> rollback ***/
498: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => r_task.task_id
501: , v_object_name => g_object_name
502: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 512: jtm_message_log_pkg.Log_Msg

508:
509: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
510: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
511: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
512: jtm_message_log_pkg.Log_Msg
513: ( v_object_id => r_task.task_id
514: , v_object_name => g_object_name
515: , v_message => 'Record not processed successfully, deferring and rejecting record'
516: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 536: jtm_message_log_pkg.Log_Msg

532: /*** Was defer successful? ***/
533: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
534: /*** no -> rollback ***/
535: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
536: jtm_message_log_pkg.Log_Msg
537: ( v_object_id => r_task.task_id
538: , v_object_name => g_object_name
539: , v_message => 'Defer record failed, rolling back to savepoint'
540: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 549: jtm_message_log_pkg.Log_Msg

545:
546: END LOOP;
547:
548: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
549: jtm_message_log_pkg.Log_Msg
550: ( v_object_id => null
551: , v_object_name => g_object_name
552: , v_message => 'Leaving CSL_TASKS_PKG.Apply_Client_Changes'
553: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 559: jtm_message_log_pkg.Log_Msg

555:
556: EXCEPTION WHEN OTHERS THEN
557: /*** catch and log exceptions ***/
558: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
559: jtm_message_log_pkg.Log_Msg
560: ( v_object_id => null
561: , v_object_name => g_object_name
562: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
563: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);