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

Line 41: jtm_message_log_pkg.Log_Msg

37: /*** get debug level ***/
38: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
39:
40: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
41: jtm_message_log_pkg.Log_Msg
42: ( p_debrief_line_id
43: , g_table_name
44: , 'Entering Get_Debrief_Header_Id'
45: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 53: jtm_message_log_pkg.Log_Msg

49: FETCH c_debrief_line INTO r_debrief_line;
50: IF c_debrief_line%NOTFOUND THEN
51: /*** could not find debrief_line record -> exit ***/
52: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
53: jtm_message_log_pkg.Log_Msg
54: ( p_debrief_line_id
55: , g_table_name
56: , 'Get_Debrief_Header_Id error: Could not find debrief_line_id ' ||
57: p_debrief_line_id

Line 67: jtm_message_log_pkg.Log_Msg

63: END IF;
64: CLOSE c_debrief_line;
65:
66: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
67: jtm_message_log_pkg.Log_Msg
68: ( p_debrief_line_id
69: , g_table_name
70: , 'Get_Debrief_Header_Id returned TRUE'
71: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 95: jtm_message_log_pkg.Log_Msg

91: /*** get debug level ***/
92: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
93:
94: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
95: jtm_message_log_pkg.Log_Msg
96: ( p_debrief_line_id
97: , g_table_name
98: , 'Entering Replicate_Record'
99: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 107: jtm_message_log_pkg.Log_Msg

103: FETCH c_debrief_line INTO r_debrief_line;
104: IF c_debrief_line%NOTFOUND THEN
105: /*** could not find debrief_line record -> exit ***/
106: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
107: jtm_message_log_pkg.Log_Msg
108: ( p_debrief_line_id
109: , g_table_name
110: , 'Replicate_Record error: Could not find debrief_line_id ' || p_debrief_line_id
111: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 120: jtm_message_log_pkg.Log_Msg

116: END IF;
117: CLOSE c_debrief_line;
118:
119: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
120: jtm_message_log_pkg.Log_Msg
121: ( p_debrief_line_id
122: , g_table_name
123: , 'Replicate_Record returned TRUE'
124: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 140: jtm_message_log_pkg.Log_Msg

136: )
137: IS
138: BEGIN
139: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
140: jtm_message_log_pkg.Log_Msg
141: ( p_debrief_line_id
142: , g_table_name
143: , 'Entering Insert_ACC_Record'
144: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 148: jtm_message_log_pkg.Log_Msg

144: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
145: END IF;
146:
147: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
148: jtm_message_log_pkg.Log_Msg
149: ( p_debrief_line_id
150: , g_table_name
151: , 'Inserting ACC record for resource_id = ' || p_resource_id
152: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 165: jtm_message_log_pkg.Log_Msg

161: ,P_RESOURCE_ID => p_resource_id
162: );
163:
164: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
165: jtm_message_log_pkg.Log_Msg
166: ( p_debrief_line_id
167: , g_table_name
168: , 'Leaving Insert_ACC_Record'
169: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 182: jtm_message_log_pkg.Log_Msg

178: )
179: IS
180: BEGIN
181: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
182: jtm_message_log_pkg.Log_Msg
183: ( p_debrief_line_id
184: , g_table_name
185: , 'Entering Update_ACC_Record'
186: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 190: jtm_message_log_pkg.Log_Msg

186: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
187: END IF;
188:
189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
190: jtm_message_log_pkg.Log_Msg
191: ( p_debrief_line_id
192: , g_table_name
193: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
194: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 206: jtm_message_log_pkg.Log_Msg

202: ,P_ACCESS_ID => p_acc_id
203: );
204:
205: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
206: jtm_message_log_pkg.Log_Msg
207: ( p_debrief_line_id
208: , g_table_name
209: , 'Leaving Update_ACC_Record'
210: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 222: jtm_message_log_pkg.Log_Msg

218: )
219: IS
220: BEGIN
221: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
222: jtm_message_log_pkg.Log_Msg
223: ( p_debrief_line_id
224: , g_table_name
225: , 'Entering Delete_ACC_Record'
226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 230: jtm_message_log_pkg.Log_Msg

226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
227: END IF;
228:
229: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
230: jtm_message_log_pkg.Log_Msg
231: ( p_debrief_line_id
232: , g_table_name
233: , 'Deleting ACC record for resource_id = ' || p_resource_id
234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 247: jtm_message_log_pkg.Log_Msg

243: ,P_RESOURCE_ID => p_resource_id
244: );
245:
246: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
247: jtm_message_log_pkg.Log_Msg
248: ( p_debrief_line_id
249: , g_table_name
250: , 'Leaving Delete_ACC_Record'
251: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 282: jtm_message_log_pkg.Log_Msg

278: /*** get debug level ***/
279: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
280:
281: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
282: jtm_message_log_pkg.Log_Msg
283: ( p_debrief_line_id
284: , g_table_name
285: , 'Entering Pre_Insert_Child procedure'
286: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 325: jtm_message_log_pkg.Log_Msg

321: l_success := TRUE;
322: END IF;
323:
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( p_debrief_line_id
327: , g_table_name
328: , 'Leaving Pre_Insert_Child procedure'
329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 356: jtm_message_log_pkg.Log_Msg

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

Line 373: jtm_message_log_pkg.Log_Msg

369: );
370:
371: IF l_dummy = FALSE THEN
372: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
373: jtm_message_log_pkg.Log_Msg
374: ( p_task_assignment_id
375: , g_table_name
376: , 'Pre_Insert_Children: debrief line was not insertable.'
377: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 383: jtm_message_log_pkg.Log_Msg

379: END IF;
380: END LOOP;
381:
382: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
383: jtm_message_log_pkg.Log_Msg
384: ( p_task_assignment_id
385: , g_table_name
386: , 'Leaving Pre_Insert_Children procedure'
387: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 417: jtm_message_log_pkg.Log_Msg

413: /*** get debug level ***/
414: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
415:
416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
417: jtm_message_log_pkg.Log_Msg
418: ( p_debrief_line_id
419: , g_table_name
420: , 'Entering Post_Delete_Child'
421: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 454: jtm_message_log_pkg.Log_Msg

450: ,p_resource_id
451: );
452:
453: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
454: jtm_message_log_pkg.Log_Msg
455: ( p_debrief_line_id
456: , g_table_name
457: , 'Leaving Post_Delete_Child'
458: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 482: jtm_message_log_pkg.Log_Msg

478: /*** get debug level ***/
479: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
480:
481: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
482: jtm_message_log_pkg.Log_Msg
483: ( p_task_assignment_id
484: , g_table_name
485: , 'Entering Post_Delete_Children procedure'
486: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 499: jtm_message_log_pkg.Log_Msg

495: );
496: END LOOP;
497:
498: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
499: jtm_message_log_pkg.Log_Msg
500: ( p_task_assignment_id
501: , g_table_name
502: , 'Leaving Post_Delete_Children procedure'
503: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 526: jtm_message_log_pkg.Log_Msg

522: AND dbl.debrief_line_id = b_debrief_line_id;
523: r_resource c_resource%ROWTYPE;
524: BEGIN
525: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
526: jtm_message_log_pkg.Log_Msg
527: ( p_debrief_line_id
528: , g_table_name
529: , 'Entering Get_Resource_Id function'
530: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 538: jtm_message_log_pkg.Log_Msg

534: FETCH c_resource INTO r_resource;
535: CLOSE c_resource;
536:
537: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
538: jtm_message_log_pkg.Log_Msg
539: ( p_debrief_line_id
540: , g_table_name
541: , 'Leaving Get_Resource_Id function'
542: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 575: jtm_message_log_pkg.Log_Msg

571: /*** get debug level ***/
572: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
573:
574: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
575: jtm_message_log_pkg.Log_Msg
576: ( l_debrief_line_id
577: , g_table_name
578: , 'Entering POST_INSERT hook'
579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 590: jtm_message_log_pkg.Log_Msg

586: /*** is resource a mobile user? ***/
587: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN
588: /*** No -> exit ***/
589: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
590: jtm_message_log_pkg.Log_Msg
591: ( l_debrief_line_id
592: , g_table_name
593: , 'POST_INSERT_DEBRIEF_LINE' || fnd_global.local_chr(10) ||
594: 'Resource_id ' || l_resource_id || ' is not a mobile user.'

Line 607: jtm_message_log_pkg.Log_Msg

603: );
604: END IF;
605:
606: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
607: jtm_message_log_pkg.Log_Msg
608: ( l_debrief_line_id
609: , g_table_name
610: , 'Leaving POST_INSERT hook'
611: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 620: jtm_message_log_pkg.Log_Msg

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

Line 652: jtm_message_log_pkg.Log_Msg

648: /*** default value of pre replication ***/
649: g_pre_replicate := FALSE;
650:
651: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
652: jtm_message_log_pkg.Log_Msg
653: ( l_debrief_line_id
654: , g_table_name
655: , 'Entering PRE_UPDATE hook'
656: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 670: jtm_message_log_pkg.Log_Msg

666: END IF;
667:
668: IF g_pre_replicate THEN
669: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
670: jtm_message_log_pkg.Log_Msg
671: ( l_debrief_line_id
672: , g_table_name
673: , 'Debrief line was replicated before update.'
674: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 683: jtm_message_log_pkg.Log_Msg

679: FETCH c_update_cache_rec INTO g_pre_update_rec;
680: CLOSE c_update_cache_rec;
681:
682: ELSIF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
683: jtm_message_log_pkg.Log_Msg
684: ( l_debrief_line_id
685: , g_table_name
686: , 'Debrief line was not replicated before update'
687: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 693: jtm_message_log_pkg.Log_Msg

689:
690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691:
692: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
693: jtm_message_log_pkg.Log_Msg
694: ( l_debrief_line_id
695: , g_table_name
696: , 'Leaving PRE_UPDATE hook'
697: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 703: jtm_message_log_pkg.Log_Msg

699:
700: EXCEPTION WHEN OTHERS THEN
701: /*** hook failed -> log error ***/
702: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
703: jtm_message_log_pkg.Log_Msg
704: ( l_debrief_line_id
705: , g_table_name
706: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 740: jtm_message_log_pkg.Log_Msg

736: /*** get debug level ***/
737: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
738:
739: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
740: jtm_message_log_pkg.Log_Msg
741: ( l_debrief_line_id
742: , g_table_name
743: , 'Entering POST_UPDATE hook'
744: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 759: jtm_message_log_pkg.Log_Msg

755: END IF;
756:
757: IF l_replicate THEN
758: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
759: jtm_message_log_pkg.Log_Msg
760: ( l_debrief_line_id
761: , g_table_name
762: , 'Debrief line should be replicated after update.'
763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 766: jtm_message_log_pkg.Log_Msg

762: , 'Debrief line should be replicated after update.'
763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
764: END IF;
765: ELSIF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
766: jtm_message_log_pkg.Log_Msg
767: ( l_debrief_line_id
768: , g_table_name
769: , 'Debrief line should not be replicated after update'
770: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 785: jtm_message_log_pkg.Log_Msg

781: ( l_debrief_line_id
782: , l_resource_id );
783:
784: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
785: jtm_message_log_pkg.Log_Msg
786: ( l_debrief_line_id
787: , g_table_name
788: , 'Debrief line was deleted during post update.'
789: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 796: jtm_message_log_pkg.Log_Msg

792: ELSE
793:
794: /*** yes -> re-send updated debrief record to resource ***/
795: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
796: jtm_message_log_pkg.Log_Msg
797: ( l_debrief_line_id
798: , g_table_name
799: , 'Debrief line being re-sent to mobile user.'
800: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 824: jtm_message_log_pkg.Log_Msg

820: IF (g_pre_update_rec.inventory_item_id <> l_post_update_rec.inventory_item_id
821: OR g_pre_update_rec.organization_id <> l_post_update_rec.organization_id) THEN
822: -- yes -> remove old item and insert new item
823: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
824: jtm_message_log_pkg.Log_Msg
825: ( l_debrief_line_id
826: , g_table_name
827: , 'System item changed -> deleting old item and inserting new item.'
828: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 849: jtm_message_log_pkg.Log_Msg

845:
846: ELSIF l_replicate THEN
847: /*** record was not replicated before update -> replicate now ***/
848: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
849: jtm_message_log_pkg.Log_Msg
850: ( l_debrief_line_id
851: , g_table_name
852: , 'Debrief line was inserted during post update.'
853: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 864: jtm_message_log_pkg.Log_Msg

860: );
861: END IF;
862:
863: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
864: jtm_message_log_pkg.Log_Msg
865: ( l_debrief_line_id
866: , g_table_name
867: , 'Leaving POST_UPDATE hook'
868: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 876: jtm_message_log_pkg.Log_Msg

872:
873: EXCEPTION WHEN OTHERS THEN
874: /*** hook failed -> log error ***/
875: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
876: jtm_message_log_pkg.Log_Msg
877: ( l_debrief_line_id
878: , g_table_name
879: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
880: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 902: jtm_message_log_pkg.Log_Msg

898: /*** get debug level ***/
899: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
900:
901: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
902: jtm_message_log_pkg.Log_Msg
903: ( v_object_id => l_debrief_line_id
904: , v_object_name => g_table_name
905: , v_message => 'Entering PRE_DELETE hook'
906: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 920: jtm_message_log_pkg.Log_Msg

916:
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918:
919: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
920: jtm_message_log_pkg.Log_Msg
921: ( v_object_id => l_debrief_line_id
922: , v_object_name => g_table_name
923: , v_message => 'Leaving PRE_DELETE hook'
924: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 931: jtm_message_log_pkg.Log_Msg

927: EXCEPTION WHEN OTHERS THEN
928:
929: /*** hook failed -> log error ***/
930: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
931: jtm_message_log_pkg.Log_Msg
932: ( v_object_id => l_debrief_line_id
933: , v_object_name => g_table_name
934: , v_message => 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm
935: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);