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_TASK_ASSIGNMENTS_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 51: jtm_message_log_pkg.Log_Msg

47: l_task_status_name VARCHAR2(30);
48:
49: BEGIN
50: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
51: jtm_message_log_pkg.Log_Msg
52: ( v_object_id => p_record.task_assignment_id
53: , v_object_name => g_object_name
54: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
55: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 93: jtm_message_log_pkg.Log_Msg

89: INTO r_task_assignment;
90: IF c_task_assignment%NOTFOUND THEN
91: CLOSE c_task_assignment;
92: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
93: jtm_message_log_pkg.Log_Msg
94: ( v_object_id => p_record.task_assignment_id
95: , v_object_name => g_object_name
96: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
97: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 132: jtm_message_log_pkg.Log_Msg

128: (
129: p_api_error => TRUE
130: );
131: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
132: jtm_message_log_pkg.Log_Msg
133: ( v_object_id => p_record.task_assignment_id
134: , v_object_name => g_object_name
135: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
136: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 142: jtm_message_log_pkg.Log_Msg

138: RETURN;
139: END IF;
140:
141: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
142: jtm_message_log_pkg.Log_Msg
143: ( v_object_id => p_record.task_assignment_id
144: , v_object_name => g_object_name
145: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
146: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 151: jtm_message_log_pkg.Log_Msg

147: END IF;
148:
149: EXCEPTION WHEN OTHERS THEN
150: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
151: jtm_message_log_pkg.Log_Msg
152: ( v_object_id => p_record.task_assignment_id
153: , v_object_name => g_object_name
154: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
155: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 165: jtm_message_log_pkg.Log_Msg

161: p_api_error => TRUE
162: );
163:
164: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
165: jtm_message_log_pkg.Log_Msg
166: ( v_object_id => p_record.task_assignment_id
167: , v_object_name => g_object_name
168: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
169: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 218: jtm_message_log_pkg.Log_Msg

214: l_task_type_id NUMBER;
215:
216: BEGIN
217: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
218: jtm_message_log_pkg.Log_Msg
219: ( v_object_id => p_record.task_assignment_id
220: , v_object_name => g_object_name
221: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
222: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 239: jtm_message_log_pkg.Log_Msg

235: if c_last_update_date%found then
236: if r_last_update_date.last_updated_by <> asg_base.get_user_id( p_record.clid$$cs ) AND r_last_update_date.last_update_date <> p_record.last_update_date then
237: close c_last_update_date;
238: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
239: jtm_message_log_pkg.Log_Msg
240: ( v_object_id => p_record.task_assignment_id
241: , v_object_name => g_object_name
242: , v_message => 'Record is stale data'
243: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 252: jtm_message_log_pkg.Log_Msg

248: );
249: fnd_msg_pub.add;
250:
251: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
252: jtm_message_log_pkg.Log_Msg
253: ( v_object_id => p_record.task_assignment_id
254: , v_object_name => g_object_name
255: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
256: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 264: jtm_message_log_pkg.Log_Msg

260: return;
261: end if;
262: else
263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
264: jtm_message_log_pkg.Log_Msg
265: ( v_object_id => p_record.task_assignment_id
266: , v_object_name => g_object_name
267: , v_message => 'No record found in Apps Database.'
268: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 284: jtm_message_log_pkg.Log_Msg

280: INTO r_task_assignment;
281: IF c_task_assignment%NOTFOUND THEN
282: CLOSE c_task_assignment;
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_assignment_id
286: , v_object_name => g_object_name
287: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
288: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 347: jtm_message_log_pkg.Log_Msg

343: (
344: p_api_error => TRUE
345: );
346: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
347: jtm_message_log_pkg.Log_Msg
348: ( v_object_id => p_record.task_assignment_id
349: , v_object_name => g_object_name
350: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
351: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 391: jtm_message_log_pkg.Log_Msg

387: (
388: p_api_error => TRUE
389: );
390: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
391: jtm_message_log_pkg.Log_Msg
392: ( v_object_id => p_record.task_assignment_id
393: , v_object_name => g_object_name
394: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
395: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 402: jtm_message_log_pkg.Log_Msg

398: END IF;
399: END IF;
400:
401: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
402: jtm_message_log_pkg.Log_Msg
403: ( v_object_id => p_record.task_assignment_id
404: , v_object_name => g_object_name
405: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
406: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 411: jtm_message_log_pkg.Log_Msg

407: END IF;
408:
409: EXCEPTION WHEN OTHERS THEN
410: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
411: jtm_message_log_pkg.Log_Msg
412: ( v_object_id => p_record.task_assignment_id
413: , v_object_name => g_object_name
414: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
415: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 425: jtm_message_log_pkg.Log_Msg

421: p_api_error => TRUE
422: );
423:
424: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
425: jtm_message_log_pkg.Log_Msg
426: ( v_object_id => p_record.task_assignment_id
427: , v_object_name => g_object_name
428: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
429: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 452: jtm_message_log_pkg.Log_Msg

448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449: FND_MSG_PUB.INITIALIZE;
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 => p_record.task_assignment_id
454: , v_object_name => g_object_name
455: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
456: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 460: jtm_message_log_pkg.Log_Msg

456: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
457: END IF;
458:
459: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
460: jtm_message_log_pkg.Log_Msg
461: ( v_object_id => p_record.task_assignment_id
462: , v_object_name => g_object_name
463: , v_message => 'Processing TASK_ASSIGNMENT_ID = ' || p_record.task_assignment_id || fnd_global.local_chr(10) ||
464: 'DMLTYPE = ' || p_record.dmltype$$

Line 487: jtm_message_log_pkg.Log_Msg

483: );
484: ELSIF p_record.dmltype$$='D' THEN
485: -- Process delete; not supported for this entity
486: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
487: jtm_message_log_pkg.Log_Msg
488: ( v_object_id => p_record.task_assignment_id
489: , v_object_name => g_object_name
490: , v_message => 'Delete is not supported for this entity'
491: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 505: jtm_message_log_pkg.Log_Msg

501: x_return_status := FND_API.G_RET_STS_ERROR;
502: ELSE
503: -- invalid dml type
504: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
505: jtm_message_log_pkg.Log_Msg
506: ( v_object_id => p_record.task_assignment_id
507: , v_object_name => g_object_name
508: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
509: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 540: jtm_message_log_pkg.Log_Msg

536: );
537: END IF;
538:
539: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
540: jtm_message_log_pkg.Log_Msg
541: ( v_object_id => p_record.task_assignment_id
542: , v_object_name => g_object_name
543: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
544: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 549: jtm_message_log_pkg.Log_Msg

545: END IF;
546: EXCEPTION WHEN OTHERS THEN
547: /*** defer record when any process exception occurs ***/
548: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
549: jtm_message_log_pkg.Log_Msg
550: ( v_object_id => p_record.task_assignment_id
551: , v_object_name => g_object_name
552: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
553: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 563: jtm_message_log_pkg.Log_Msg

559: p_api_error => TRUE
560: );
561:
562: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
563: jtm_message_log_pkg.Log_Msg
564: ( v_object_id => p_record.task_assignment_id
565: , v_object_name => g_object_name
566: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
567: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 631: jtm_message_log_pkg.Log_Msg

627: g_debug_level := p_debug_level;
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
631: jtm_message_log_pkg.Log_Msg
632: ( v_object_id => null
633: , v_object_name => g_object_name
634: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
635: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 651: jtm_message_log_pkg.Log_Msg

647: , l_error_msg
648: , l_process_status
649: );
650:
651: jtm_message_log_pkg.Log_Msg
652: ( v_object_id => r_task_ass.task_assignment_id
653: , v_object_name => g_object_name
654: , v_message => 'l_error_msg = ' || l_error_msg || fnd_global.local_chr(10) ||
655: 'l_process_status = ' || l_process_status

Line 685: jtm_message_log_pkg.Log_Msg

681: END IF;
682:
683: /*** Yes -> delete record from inqueue ***/
684: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
685: jtm_message_log_pkg.Log_Msg
686: ( v_object_id => r_task_ass.task_assignment_id
687: , v_object_name => g_object_name
688: , v_message => 'Record successfully processed, deleting from inqueue'
689: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 708: jtm_message_log_pkg.Log_Msg

704: /*** was delete successful? ***/
705: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
706: /*** no -> rollback ***/
707: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
708: jtm_message_log_pkg.Log_Msg
709: ( v_object_id => r_task_ass.task_assignment_id
710: , v_object_name => g_object_name
711: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
712: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 721: jtm_message_log_pkg.Log_Msg

717:
718: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
719: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
720: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
721: jtm_message_log_pkg.Log_Msg
722: ( v_object_id => r_task_ass.task_assignment_id
723: , v_object_name => g_object_name
724: , v_message => 'Record not processed successfully, deferring and rejecting record'
725: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 745: jtm_message_log_pkg.Log_Msg

741: /*** Was defer successful? ***/
742: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
743: /*** no -> rollback ***/
744: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
745: jtm_message_log_pkg.Log_Msg
746: ( v_object_id => r_task_ass.task_assignment_id
747: , v_object_name => g_object_name
748: , v_message => 'Defer record failed, rolling back to savepoint'
749: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 758: jtm_message_log_pkg.Log_Msg

754:
755: END LOOP;
756:
757: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
758: jtm_message_log_pkg.Log_Msg
759: ( v_object_id => null
760: , v_object_name => g_object_name
761: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
762: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 768: jtm_message_log_pkg.Log_Msg

764:
765: EXCEPTION WHEN OTHERS THEN
766: /*** catch and log exceptions ***/
767: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
768: jtm_message_log_pkg.Log_Msg
769: ( v_object_id => null
770: , v_object_name => g_object_name
771: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
772: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 806: jtm_message_log_pkg.Log_Msg

802: AND a.SEQNO$$ = p_sequence;
803:
804: BEGIN
805:
806: jtm_message_log_pkg.Log_Msg
807: ( v_object_id => null
808: , v_object_name => g_object_name
809: , v_message => 'Entering Task Assignments CONFLICT_RESOLUTION_HANDLER : User '
810: ||p_user_name