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

Line 58: jtm_message_log_pkg.Log_Msg

54: /*** get debug level ***/
55: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
56:
57: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
58: jtm_message_log_pkg.Log_Msg
59: ( p_task_assignment_id
60: , g_table_name
61: , 'Entering Replicate_Record'
62: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 70: jtm_message_log_pkg.Log_Msg

66: FETCH c_task_assignment INTO r_task_assignment;
67: IF c_task_assignment%NOTFOUND THEN
68: /*** could not find assignment record -> exit ***/
69: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
70: jtm_message_log_pkg.Log_Msg
71: ( p_task_assignment_id
72: , g_table_name
73: , 'Replicate_Record error: Could not find task_assignment_id ' || p_task_assignment_id
74: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 86: jtm_message_log_pkg.Log_Msg

82: /*** is this an ASSIGNEE task assignment? ***/
83: IF NVL(r_task_assignment.assignee_role,'') <> 'ASSIGNEE' THEN
84: /*** No -> exit ***/
85: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
86: jtm_message_log_pkg.Log_Msg
87: ( p_task_assignment_id
88: , g_table_name
89: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
90: 'ASSIGNEE_ROLE <> ''ASSIGNEE'''

Line 101: jtm_message_log_pkg.Log_Msg

97: /*** is resource a mobile user? ***/
98: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( r_task_assignment.resource_id ) THEN
99: /*** No -> exit ***/
100: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
101: jtm_message_log_pkg.Log_Msg
102: ( p_task_assignment_id
103: , g_table_name
104: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
105: 'Resource_id ' || r_task_assignment.resource_id || ' is not a mobile user.'

Line 124: jtm_message_log_pkg.Log_Msg

120: /*** status should not be replicated -> exit ***/
121: CLOSE c_assignment_status;
122: CLOSE c_personal_task;
123: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
124: jtm_message_log_pkg.Log_Msg
125: ( p_task_assignment_id
126: , g_table_name
127: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
128: 'Assignment status should have either ASSIGNED_FLAG, CANCELLED_FLAG, '||

Line 139: jtm_message_log_pkg.Log_Msg

135: END IF; --c_personal_task%NOTFOUND
136: CLOSE c_personal_task;
137:
138: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
139: jtm_message_log_pkg.Log_Msg
140: ( p_task_assignment_id
141: , g_table_name
142: , 'Replicate_Record returned TRUE'
143: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 165: jtm_message_log_pkg.Log_Msg

161: l_debrief_header_id NUMBER;
162:
163: BEGIN
164: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
165: jtm_message_log_pkg.Log_Msg
166: ( p_task_assignment_id
167: , g_table_name
168: , 'Entering Insert_ACC_Record'
169: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 173: jtm_message_log_pkg.Log_Msg

169: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
170: END IF;
171:
172: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
173: jtm_message_log_pkg.Log_Msg
174: ( p_task_assignment_id
175: , g_table_name
176: , 'Inserting ACC record for resource_id = ' || p_resource_id
177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 208: jtm_message_log_pkg.Log_Msg

204: );
205:
206:
207: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
208: jtm_message_log_pkg.Log_Msg
209: ( p_task_assignment_id
210: , g_table_name
211: , 'Leaving Insert_ACC_Record'
212: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 225: jtm_message_log_pkg.Log_Msg

221: )
222: IS
223: BEGIN
224: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
225: jtm_message_log_pkg.Log_Msg
226: ( p_task_assignment_id
227: , g_table_name
228: , 'Entering Update_ACC_Record'
229: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 233: jtm_message_log_pkg.Log_Msg

229: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
230: END IF;
231:
232: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
233: jtm_message_log_pkg.Log_Msg
234: ( p_task_assignment_id
235: , g_table_name
236: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
237: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 248: jtm_message_log_pkg.Log_Msg

244: ,P_ACCESS_ID => p_acc_id
245: );
246:
247: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
248: jtm_message_log_pkg.Log_Msg
249: ( p_task_assignment_id
250: , g_table_name
251: , 'Leaving Update_ACC_Record'
252: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 264: jtm_message_log_pkg.Log_Msg

260: )
261: IS
262: BEGIN
263: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
264: jtm_message_log_pkg.Log_Msg
265: ( p_task_assignment_id
266: , g_table_name
267: , 'Entering Delete_ACC_Record'
268: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 285: jtm_message_log_pkg.Log_Msg

281: p_resource_id
282: );
283:
284: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
285: jtm_message_log_pkg.Log_Msg
286: ( p_task_assignment_id
287: , g_table_name
288: , 'Deleting ACC record for resource_id = ' || p_resource_id
289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 302: jtm_message_log_pkg.Log_Msg

298: ,P_RESOURCE_ID => p_resource_id
299: );
300:
301: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
302: jtm_message_log_pkg.Log_Msg
303: ( p_task_assignment_id
304: , g_table_name
305: , 'Leaving Delete_ACC_Record'
306: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 327: jtm_message_log_pkg.Log_Msg

323: IF c_task_assignment%NOTFOUND THEN
324: /*** could not find assignment record -> exit ***/
325: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
326: CLOSE c_task_assignment;
327: jtm_message_log_pkg.Log_Msg
328: ( p_task_assignment_id
329: , g_table_name
330: , 'Post_Delete_Child error: Could not find task_assignment_id ' || p_task_assignment_id
331: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 358: jtm_message_log_pkg.Log_Msg

354: /*** get debug level ***/
355: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
356:
357: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
358: jtm_message_log_pkg.Log_Msg
359: ( p_task_assignment_id
360: , g_table_name
361: , 'Entering Pre_Insert_Child procedure'
362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 389: jtm_message_log_pkg.Log_Msg

385: END IF;
386: END IF;
387:
388: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
389: jtm_message_log_pkg.Log_Msg
390: ( p_task_assignment_id
391: , g_table_name
392: , 'Leaving Pre_Insert_Child procedure'
393: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 414: jtm_message_log_pkg.Log_Msg

410: /*** get debug level ***/
411: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
412:
413: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
414: jtm_message_log_pkg.Log_Msg
415: ( p_task_assignment_id
416: , g_table_name
417: , 'Entering Post_Delete_Child'
418: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 436: jtm_message_log_pkg.Log_Msg

432: ,p_resource_id);
433:
434: /*** call delete task ***/
435: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
436: jtm_message_log_pkg.Log_Msg
437: ( p_task_assignment_id
438: , g_table_name
439: , 'Calling CSL_JTF_TASKS_ACC_PKG.Post_Delete_Child'
440: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 449: jtm_message_log_pkg.Log_Msg

445: END IF;
446: END IF;
447:
448: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
449: jtm_message_log_pkg.Log_Msg
450: ( p_task_assignment_id
451: , g_table_name
452: , 'Leaving Post_Delete_Child'
453: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 532: jtm_message_log_pkg.Log_Msg

528: /*** get debug level ***/
529: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
530:
531: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
532: jtm_message_log_pkg.Log_Msg
533: ( l_task_assignment_id
534: , g_table_name
535: , 'Entering POST_INSERT hook'
536: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 546: jtm_message_log_pkg.Log_Msg

542: ,l_resource_id
543: );
544:
545: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
546: jtm_message_log_pkg.Log_Msg
547: ( l_task_assignment_id
548: , g_table_name
549: , 'Leaving POST_INSERT hook'
550: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 559: jtm_message_log_pkg.Log_Msg

555:
556: EXCEPTION WHEN OTHERS THEN
557: /*** hook failed -> log error ***/
558: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
559: jtm_message_log_pkg.Log_Msg
560: ( l_task_assignment_id
561: , g_table_name
562: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
563: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 596: jtm_message_log_pkg.Log_Msg

592: /*** get debug level ***/
593: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
594:
595: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
596: jtm_message_log_pkg.Log_Msg
597: ( l_task_assignment_id
598: , g_table_name
599: , 'Entering PRE_UPDATE hook'
600: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 610: jtm_message_log_pkg.Log_Msg

606: g_old_resource_id := r_task_assignment.resource_id;
607: CLOSE c_task_assignment;
608:
609: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
610: jtm_message_log_pkg.Log_Msg
611: ( l_task_assignment_id
612: , g_table_name
613: , 'Leaving PRE_UPDATE hook'
614: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 622: jtm_message_log_pkg.Log_Msg

618:
619: EXCEPTION WHEN OTHERS THEN
620: /*** hook failed -> log error ***/
621: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
622: jtm_message_log_pkg.Log_Msg
623: ( l_task_assignment_id
624: , g_table_name
625: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
626: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 658: jtm_message_log_pkg.Log_Msg

654: /*** get debug level ***/
655: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
656:
657: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
658: jtm_message_log_pkg.Log_Msg
659: ( l_task_assignment_id
660: , g_table_name
661: , 'Entering POST_UPDATE hook'
662: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 669: jtm_message_log_pkg.Log_Msg

665: /*** did resource_id get changed? ***/
666: IF (g_old_resource_id <> l_resource_id) THEN
667: /*** yes -> do cascading delete for old resource_id ***/
668: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
669: jtm_message_log_pkg.Log_Msg
670: ( l_task_assignment_id
671: , g_table_name
672: , 'Task assignment resource_id changed from ' || g_old_resource_id || ' to ' || l_resource_id || '.' || fnd_global.local_chr(10) ||
673: 'Deleting old assignment ACC record (if exists).'

Line 713: jtm_message_log_pkg.Log_Msg

709: /*** record should not be replicated ***/
710: IF l_acc_id > -1 THEN
711: /*** record exists on mobile but should not be replicated anymore -> delete from mobile ***/
712: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
713: jtm_message_log_pkg.Log_Msg
714: ( l_task_assignment_id
715: , g_table_name
716: , 'Task assignment was replicated before update, but should not be replicated anymore.'
717: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 727: jtm_message_log_pkg.Log_Msg

723: END IF;
724: END IF;
725:
726: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
727: jtm_message_log_pkg.Log_Msg
728: ( l_task_assignment_id
729: , g_table_name
730: , 'Leaving POST_UPDATE hook'
731: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 738: jtm_message_log_pkg.Log_Msg

734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735: EXCEPTION WHEN OTHERS THEN
736: /*** hook failed -> log error ***/
737: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
738: jtm_message_log_pkg.Log_Msg
739: ( l_task_assignment_id
740: , g_table_name
741: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
742: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 771: jtm_message_log_pkg.Log_Msg

767: /*** get debug level ***/
768: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
769:
770: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
771: jtm_message_log_pkg.Log_Msg
772: ( l_task_assignment_id
773: , g_table_name
774: , 'Entering PRE_DELETE hook'
775: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 786: jtm_message_log_pkg.Log_Msg

782:
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784:
785: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
786: jtm_message_log_pkg.Log_Msg
787: ( l_task_assignment_id
788: , g_table_name
789: , 'Leaving PRE_DELETE hook'
790: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 796: jtm_message_log_pkg.Log_Msg

792:
793: EXCEPTION WHEN OTHERS THEN
794: /*** hook failed -> log error ***/
795: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
796: jtm_message_log_pkg.Log_Msg
797: ( l_task_assignment_id
798: , g_table_name
799: , 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm
800: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 871: jtm_message_log_pkg.Log_Msg

867: ROLLBACK;
868: p_status := 'ERROR';
869: p_message := 'Error in CSL_JTF_TASK_ASS_ACC_PKG.PURGE_TASK_ASSIGNMENTS: ' || substr(SQLERRM, 1, 2000);
870:
871: jtm_message_log_pkg.Log_Msg
872: (rcur_purge_task_assignments.task_assignment_id,
873: 'CSL_JTF_TASK_ASS_ACC',
874: 'Exception occured in PURGE_TASK_ASSIGNMENT for id: ' || rcur_purge_task_assignments.task_assignment_id,
875: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);