APPS.CSL_JTF_TASKS_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 59: jtm_message_log_pkg.Log_Msg

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

Line 71: jtm_message_log_pkg.Log_Msg

67: FETCH c_task INTO r_task;
68: IF c_task%NOTFOUND THEN
69: /*** could not find task record -> exit ***/
70: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
71: jtm_message_log_pkg.Log_Msg
72: ( p_task_id
73: , g_table_name
74: , 'Replicate_Record error: Could not find task_id ' || p_task_id
75: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 87: jtm_message_log_pkg.Log_Msg

83: /*** is this a SR or personal (trip) task? ***/
84: IF r_task.source_object_type_code NOT IN ('TASK', 'SR') THEN
85: /*** no -> don't replicate ***/
86: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
87: jtm_message_log_pkg.Log_Msg
88: ( p_task_id
89: , g_table_name
90: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
91: 'SOURCE_OBJECT_TYPE CODE NOT IN (''SR'',''TASK'')'

Line 102: jtm_message_log_pkg.Log_Msg

98: IF r_task.scheduled_start_date IS NULL OR
99: r_task.scheduled_end_date IS NULL THEN
100: /*** no -> don't replicate ***/
101: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
102: jtm_message_log_pkg.Log_Msg
103: ( p_task_id
104: , g_table_name
105: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
106: 'SCHEDULED_START_DATE and SCHEDULED_END_DATE should both be NOT NULL.'

Line 122: jtm_message_log_pkg.Log_Msg

118: IF c_task_type%NOTFOUND THEN
119: /*** no -> don't replicate ***/
120: CLOSE c_task_type;
121: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
122: jtm_message_log_pkg.Log_Msg
123: ( p_task_id
124: , g_table_name
125: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
126: 'Task''s task type RULE <> ''DISPATCH''.'

Line 140: jtm_message_log_pkg.Log_Msg

136: IF c_task_status%NOTFOUND THEN
137: /*** no -> don't replicate ***/
138: CLOSE c_task_status;
139: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
140: jtm_message_log_pkg.Log_Msg
141: ( p_task_id
142: , g_table_name
143: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
144: 'Task status for SR tasks should have either ASSIGNED_FLAG, CANCELLED_FLAG, '||

Line 162: jtm_message_log_pkg.Log_Msg

158: IF c_private_task_type%NOTFOUND THEN
159: /*** no -> don't replicate ***/
160: CLOSE c_private_task_type;
161: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
162: jtm_message_log_pkg.Log_Msg
163: ( p_task_id
164: , g_table_name
165: , 'Replicate_Record returned FALSE ' || fnd_global.local_chr(10) ||
166: 'Task''s task type private flag <> ''Y''.'

Line 175: jtm_message_log_pkg.Log_Msg

171: CLOSE c_private_task_type;
172: END IF;
173:
174: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
175: jtm_message_log_pkg.Log_Msg
176: ( p_task_id
177: , g_table_name
178: , 'Replicate_Record returned TRUE'
179: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 225: jtm_message_log_pkg.Log_Msg

221: r_task c_task%ROWTYPE;
222:
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_id
227: , g_table_name
228: , 'Entering Insert_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_id
235: , g_table_name
236: , 'Inserting ACC record for resource_id = ' || p_resource_id
237: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 251: jtm_message_log_pkg.Log_Msg

247: );
248:
249: /*Insert the non critical dependant record*/
250: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
251: jtm_message_log_pkg.Log_Msg
252: ( p_task_id
253: , g_table_name
254: , 'Inserting non-critical dependant records'
255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 287: jtm_message_log_pkg.Log_Msg

283: CLOSE c_task;
284:
285:
286: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
287: jtm_message_log_pkg.Log_Msg
288: ( p_task_id
289: , g_table_name
290: , 'Leaving Insert_ACC_Record'
291: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 304: jtm_message_log_pkg.Log_Msg

300: )
301: IS
302: BEGIN
303: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
304: jtm_message_log_pkg.Log_Msg
305: ( p_task_id
306: , g_table_name
307: , 'Entering Update_ACC_Record'
308: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 312: jtm_message_log_pkg.Log_Msg

308: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
309: END IF;
310:
311: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
312: jtm_message_log_pkg.Log_Msg
313: ( p_task_id
314: , g_table_name
315: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) ||
316: 'access_id = ' || p_acc_id

Line 328: jtm_message_log_pkg.Log_Msg

324: ,P_ACCESS_ID => p_acc_id
325: );
326:
327: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
328: jtm_message_log_pkg.Log_Msg
329: ( p_task_id
330: , g_table_name
331: , 'Leaving Update_ACC_Record'
332: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 352: jtm_message_log_pkg.Log_Msg

348: r_task c_task%ROWTYPE;
349:
350: BEGIN
351: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
352: jtm_message_log_pkg.Log_Msg
353: ( p_task_id
354: , g_table_name
355: , 'Entering Delete_ACC_Record'
356: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 360: jtm_message_log_pkg.Log_Msg

356: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
357: END IF;
358:
359: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
360: jtm_message_log_pkg.Log_Msg
361: ( p_task_id
362: , g_table_name
363: , 'Deleting ACC record for resource_id = ' || p_resource_id
364: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 377: jtm_message_log_pkg.Log_Msg

373: ,P_RESOURCE_ID => p_resource_id
374: );
375:
376: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
377: jtm_message_log_pkg.Log_Msg
378: ( p_task_id
379: , g_table_name
380: , 'Deleting Non-critical dependant records'
381: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 411: jtm_message_log_pkg.Log_Msg

407: END IF;
408: CLOSE c_task;
409:
410: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
411: jtm_message_log_pkg.Log_Msg
412: ( p_task_id
413: , g_table_name
414: , 'Leaving Delete_ACC_Record'
415: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 437: jtm_message_log_pkg.Log_Msg

433: /*** get debug level ***/
434: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
435:
436: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
437: jtm_message_log_pkg.Log_Msg
438: ( p_task_id
439: , g_table_name
440: , 'Entering Pre_Insert_Child procedure'
441: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 478: jtm_message_log_pkg.Log_Msg

474: );
475: END IF;
476:
477: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
478: jtm_message_log_pkg.Log_Msg
479: ( p_task_id
480: , g_table_name
481: , 'Leaving Pre_Insert_Child procedure'
482: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 502: jtm_message_log_pkg.Log_Msg

498: /*** get debug level ***/
499: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
500:
501: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
502: jtm_message_log_pkg.Log_Msg
503: ( p_task_id
504: , g_table_name
505: , 'Entering Post_Delete_Child'
506: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 517: jtm_message_log_pkg.Log_Msg

513: , p_flow_type);
514:
515: /*** call delete service request ***/
516: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
517: jtm_message_log_pkg.Log_Msg
518: ( p_task_id
519: , g_table_name
520: , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child'
521: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 534: jtm_message_log_pkg.Log_Msg

530: END IF;
531: END IF;
532:
533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
534: jtm_message_log_pkg.Log_Msg
535: ( p_task_id
536: , g_table_name
537: , 'Leaving Post_Delete_Child'
538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 577: jtm_message_log_pkg.Log_Msg

573: /*** get debug level ***/
574: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
575:
576: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
577: jtm_message_log_pkg.Log_Msg
578: ( l_task_id
579: , g_table_name
580: , 'Entering POST_INSERT_TASK hook'
581: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 600: jtm_message_log_pkg.Log_Msg

596: END IF;--c_task%FOUND
597: CLOSE c_task;
598:
599: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
600: jtm_message_log_pkg.Log_Msg
601: ( l_task_id
602: , g_table_name
603: , 'Leaving POST_INSERT_TASK hook'
604: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 611: jtm_message_log_pkg.Log_Msg

607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608: EXCEPTION WHEN OTHERS THEN
609: /*** hook failed -> log error ***/
610: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
611: jtm_message_log_pkg.Log_Msg
612: ( l_task_id
613: , g_table_name
614: , 'Caught exception in POST_INSERT_TASK hook:' || fnd_global.local_chr(10) || sqlerrm
615: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 646: jtm_message_log_pkg.Log_Msg

642: /*** get debug level ***/
643: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
644:
645: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
646: jtm_message_log_pkg.Log_Msg
647: ( l_task_id
648: , g_table_name
649: , 'Entering PRE_UPDATE hook'
650: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 663: jtm_message_log_pkg.Log_Msg

659:
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
663: jtm_message_log_pkg.Log_Msg
664: ( l_task_id
665: , g_table_name
666: , 'Leaving PRE_UPDATE hook'
667: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 673: jtm_message_log_pkg.Log_Msg

669:
670: EXCEPTION WHEN OTHERS THEN
671: /*** hook failed -> log error ***/
672: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
673: jtm_message_log_pkg.Log_Msg
674: ( l_task_id
675: , g_table_name
676: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
677: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 723: jtm_message_log_pkg.Log_Msg

719: /*** get debug level ***/
720: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
721:
722: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
723: jtm_message_log_pkg.Log_Msg
724: ( l_task_id
725: , g_table_name
726: , 'Entering POST_UPDATE hook'
727: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 739: jtm_message_log_pkg.Log_Msg

735: /*** yes -> was record already replicated? ***/
736: IF g_replicate_pre_update THEN
737: /*** yes -> re-send updated task record to all resources ***/
738: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
739: jtm_message_log_pkg.Log_Msg
740: ( l_task_id
741: , g_table_name
742: , 'Task was replicateable before and after update. Re-sending task record to mobile users.'
743: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 790: jtm_message_log_pkg.Log_Msg

786: record was not replicated before update but should be replicated now ->
787: send record related data to all resources
788: ***/
789: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
790: jtm_message_log_pkg.Log_Msg
791: ( l_task_id
792: , g_table_name
793: , 'Task was not replicated before update, but should be replicated now.'
794: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 800: jtm_message_log_pkg.Log_Msg

796:
797: FOR r_task_assignment IN c_task_assignment( l_task_id ) LOOP
798:
799: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
800: jtm_message_log_pkg.Log_Msg
801: ( l_task_id
802: , g_table_name
803: , 'Evaluating task_assignment_id ' ||
804: r_task_assignment.task_assignment_id || fnd_global.local_chr(10) ||

Line 821: jtm_message_log_pkg.Log_Msg

817: /*** record should not be replicated anymore -> was it replicated before? ***/
818: IF g_replicate_pre_update THEN
819: /*** yes -> delete record related data for all resources ***/
820: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
821: jtm_message_log_pkg.Log_Msg
822: ( l_task_id
823: , g_table_name
824: , 'Task was replicated before update, but should no longer be replicated.'
825: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 831: jtm_message_log_pkg.Log_Msg

827:
828: FOR r_task_assignment IN c_task_assignment( l_task_id ) LOOP
829:
830: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
831: jtm_message_log_pkg.Log_Msg
832: ( l_task_id
833: , g_table_name
834: , 'Evaluating task_assignment_id ' || r_task_assignment.task_assignment_id ||
835: fnd_global.local_chr(10) ||'for resource_id ' || r_task_assignment.resource_id

Line 851: jtm_message_log_pkg.Log_Msg

847:
848: x_return_status := FND_API.G_RET_STS_SUCCESS;
849:
850: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
851: jtm_message_log_pkg.Log_Msg
852: ( l_task_id
853: , g_table_name
854: , 'Leaving POST_UPDATE hook'
855: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 861: jtm_message_log_pkg.Log_Msg

857:
858: EXCEPTION WHEN OTHERS THEN
859: /*** hook failed -> log error ***/
860: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
861: jtm_message_log_pkg.Log_Msg
862: ( l_task_id
863: , g_table_name
864: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
865: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 904: jtm_message_log_pkg.Log_Msg

900: AND au.RESOURCE_ID = b_resource_id;
901: r_task c_task%ROWTYPE;
902: BEGIN
903: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
904: jtm_message_log_pkg.Log_Msg
905: ( p_resource_id
906: , g_table_name
907: , 'Entering POST_INSERT hook'
908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 921: jtm_message_log_pkg.Log_Msg

917: );
918: END LOOP;
919:
920: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
921: jtm_message_log_pkg.Log_Msg
922: ( p_resource_id
923: , g_table_name
924: , 'Leaving POST_INSERT hook'
925: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 933: jtm_message_log_pkg.Log_Msg

929:
930: EXCEPTION
931: WHEN OTHERS THEN
932: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
933: jtm_message_log_pkg.Log_Msg
934: ( p_resource_id
935: , g_table_name
936: , 'Caught exception in INSERT_ALL_ACC_RECORDS:' || fnd_global.local_chr(10) || sqlerrm
937: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 974: jtm_message_log_pkg.Log_Msg

970:
971: EXCEPTION
972:
973: WHEN OTHERS THEN
974: jtm_message_log_pkg.Log_Msg
975: (rcur_purge_tasks.task_id,
976: 'CSL_JTF_TASK_ASS_ACC',
977: 'Exception occured in PURGE_TASKS for id: ' || rcur_purge_tasks.task_id,
978: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);