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

Line 35: jtm_message_log_pkg.Log_Msg

31: /*** get debug level ***/
32: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
33:
34: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
35: jtm_message_log_pkg.Log_Msg
36: ( p_instance_id
37: , g_table_name
38: , 'Entering Replicate_Record'
39: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 46: jtm_message_log_pkg.Log_Msg

42: /*** is resource a mobile user? ***/
43: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
44: /*** No -> exit ***/
45: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
46: jtm_message_log_pkg.Log_Msg
47: ( p_instance_id
48: , g_table_name
49: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
50: 'Resource_id ' || p_resource_id || ' is not a mobile user.'

Line 63: jtm_message_log_pkg.Log_Msg

59: FETCH c_item_instance INTO r_item_instance;
60: IF c_item_instance%NOTFOUND THEN
61: /*** could not find item instance record -> exit ***/
62: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
63: jtm_message_log_pkg.Log_Msg
64: ( p_instance_id
65: , g_table_name
66: , 'Replicate_Record error: Could not find instance_id ' || p_instance_id
67: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 76: jtm_message_log_pkg.Log_Msg

72: END IF;
73: CLOSE c_item_instance;
74:
75: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
76: jtm_message_log_pkg.Log_Msg
77: ( p_instance_id
78: , g_table_name
79: , 'Replicate_Record returned TRUE'
80: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 154: jtm_message_log_pkg.Log_Msg

150: l_current_run_date date;
151: BEGIN
152:
153: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
154: jtm_message_log_pkg.Log_Msg
155: ( 0
156: , l_table_name
157: , 'Entering Insert_Item_Attr'
158: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 173: jtm_message_log_pkg.Log_Msg

169: FOR r_insert_diffs in c_insert_diffs(r_LastRundate.LAST_RUN_DATE)
170: LOOP
171:
172: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
173: jtm_message_log_pkg.Log_Msg
174: ( 0
175: , l_table_name
176: , 'Inserting ACC record for resource_id = ' || r_insert_diffs.resource_id
177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 195: jtm_message_log_pkg.Log_Msg

191: FOR r_updates in c_updates(r_LastRundate.LAST_RUN_DATE)
192: LOOP
193:
194: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
195: jtm_message_log_pkg.Log_Msg
196: ( 0
197: , l_table_name
198: , 'Updating ACC record for resource_id = ' || r_updates.resource_id
199: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 217: jtm_message_log_pkg.Log_Msg

213: FOR r_end_dates in c_end_dates(r_LastRundate.LAST_RUN_DATE)
214: LOOP
215:
216: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
217: jtm_message_log_pkg.Log_Msg
218: ( 0
219: , l_table_name
220: , 'Updating ACC record for resource_id = ' || r_end_dates.resource_id
221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 244: jtm_message_log_pkg.Log_Msg

240: COMMIT;
241:
242:
243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
244: jtm_message_log_pkg.Log_Msg
245: ( 0
246: , l_table_name
247: , 'Leaving Con_item_Attr'
248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 259: jtm_message_log_pkg.Log_Msg

255:
256: WHEN OTHERS THEN
257: p_status := 'ERROR';
258: p_message := 'Error in CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR: ' || substr(SQLERRM, 1, 2000);
259: jtm_message_log_pkg.Log_Msg
260: (0,
261: 'CSL_CSI_ITEM_ATTR_ACC',
262: 'Exception occured in CON_ITEM_ATTR ',
263: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 295: jtm_message_log_pkg.Log_Msg

291:
292: BEGIN
293:
294: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
295: jtm_message_log_pkg.Log_Msg
296: ( p_instance_id
297: , g_table_name
298: , 'Entering Insert_Item_Attr'
299: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 303: jtm_message_log_pkg.Log_Msg

299: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
300: END IF;
301:
302: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
303: jtm_message_log_pkg.Log_Msg
304: ( p_instance_id
305: , g_table_name
306: , 'Inserting ACC record for resource_id = ' || p_resource_id
307: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 325: jtm_message_log_pkg.Log_Msg

321: END LOOP;
322:
323:
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( p_instance_id
327: , g_table_name
328: , 'Leaving Insert_ACC_Record'
329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 358: jtm_message_log_pkg.Log_Msg

354:
355: BEGIN
356:
357: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
358: jtm_message_log_pkg.Log_Msg
359: ( p_instance_id
360: , g_table_name
361: , 'Entering Delete_Item_Attr'
362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 366: jtm_message_log_pkg.Log_Msg

362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
363: END IF;
364:
365: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
366: jtm_message_log_pkg.Log_Msg
367: ( p_instance_id
368: , g_table_name
369: , 'Deleting ACC record for resource_id = ' || p_resource_id
370: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 387: jtm_message_log_pkg.Log_Msg

383:
384: END LOOP;
385:
386: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
387: jtm_message_log_pkg.Log_Msg
388: ( p_instance_id
389: , g_table_name
390: , 'Leaving Delete_Item_Attr'
391: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 416: jtm_message_log_pkg.Log_Msg

412: l_org_id NUMBER;
413: l_return BOOLEAN;
414: BEGIN
415: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
416: jtm_message_log_pkg.Log_Msg
417: ( p_instance_id
418: , g_table_name
419: , 'Entering Insert_ACC_Record'
420: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 424: jtm_message_log_pkg.Log_Msg

420: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
421: END IF;
422:
423: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
424: jtm_message_log_pkg.Log_Msg
425: ( p_instance_id
426: , g_table_name
427: , 'Inserting ACC record for resource_id = ' || p_resource_id
428: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 443: jtm_message_log_pkg.Log_Msg

439: -- ER 3168446
440: g_ib_count := g_ib_count + 1;
441:
442: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
443: jtm_message_log_pkg.Log_Msg
444: ( p_instance_id
445: , g_table_name
446: , 'Calling Non-critical dependent hooks'
447: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 493: jtm_message_log_pkg.Log_Msg

489: ,p_resource_id => p_resource_id
490: ,p_flow_type => p_flow_type);
491:
492: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
493: jtm_message_log_pkg.Log_Msg
494: ( p_instance_id
495: , g_table_name
496: , 'Leaving Insert_ACC_Record'
497: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 510: jtm_message_log_pkg.Log_Msg

506: )
507: IS
508: BEGIN
509: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
510: jtm_message_log_pkg.Log_Msg
511: ( p_instance_id
512: , g_table_name
513: , 'Entering Update_ACC_Record'
514: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 518: jtm_message_log_pkg.Log_Msg

514: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
515: END IF;
516:
517: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
518: jtm_message_log_pkg.Log_Msg
519: ( p_instance_id
520: , g_table_name
521: , 'Updating ACC record for resource_id = ' || p_resource_id
522: || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id

Line 534: jtm_message_log_pkg.Log_Msg

530: ,P_ACCESS_ID => p_acc_id
531: );
532:
533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
534: jtm_message_log_pkg.Log_Msg
535: ( p_instance_id
536: , g_table_name
537: , 'Leaving Update_ACC_Record'
538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 563: jtm_message_log_pkg.Log_Msg

559: l_org_id NUMBER;
560: l_return BOOLEAN;
561: BEGIN
562: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
563: jtm_message_log_pkg.Log_Msg
564: ( p_instance_id
565: , g_table_name
566: , 'Entering Delete_ACC_Record'
567: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 571: jtm_message_log_pkg.Log_Msg

567: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
568: END IF;
569:
570: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
571: jtm_message_log_pkg.Log_Msg
572: ( p_instance_id
573: , g_table_name
574: , 'Deleting ACC record for resource_id = ' || p_resource_id
575: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 631: jtm_message_log_pkg.Log_Msg

627: ,p_resource_id => p_resource_id
628: ,p_flow_type => p_flow_type);
629:
630: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
631: jtm_message_log_pkg.Log_Msg
632: ( p_instance_id
633: , g_table_name
634: , 'Leaving Delete_ACC_Record'
635: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 660: jtm_message_log_pkg.Log_Msg

656: /*** get debug level ***/
657: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
658:
659: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
660: jtm_message_log_pkg.Log_Msg
661: ( p_instance_id
662: , g_table_name
663: , 'Entering Insert_Childs'
664: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 680: jtm_message_log_pkg.Log_Msg

676: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
677: );
678:
679: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
680: jtm_message_log_pkg.Log_Msg
681: ( p_instance_id
682: , g_table_name
683: , 'Child Instance inserted into ACC - INSTANCE_ID: ' || r_child_instance.subject_id
684: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 690: jtm_message_log_pkg.Log_Msg

686: END LOOP; -- Next child IB
687: END IF;
688:
689: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
690: jtm_message_log_pkg.Log_Msg
691: ( p_instance_id
692: , g_table_name
693: , 'Leaving Insert_Childs'
694: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 719: jtm_message_log_pkg.Log_Msg

715: /*** get debug level ***/
716: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
717:
718: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
719: jtm_message_log_pkg.Log_Msg
720: ( p_instance_id
721: , g_table_name
722: , 'Entering Insert_Parents'
723: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 740: jtm_message_log_pkg.Log_Msg

736: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
737: );
738:
739: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
740: jtm_message_log_pkg.Log_Msg
741: ( p_instance_id
742: , g_table_name
743: , 'Parent Instance inserted into ACC - INSTANCE_ID: ' || r_parent_instance.object_id
744: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 750: jtm_message_log_pkg.Log_Msg

746: END LOOP; -- Next child IB
747: END IF;
748:
749: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
750: jtm_message_log_pkg.Log_Msg
751: ( p_instance_id
752: , g_table_name
753: , 'Leaving Insert_Parents'
754: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 874: jtm_message_log_pkg.Log_Msg

870: /*** get debug level ***/
871: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
872:
873: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
874: jtm_message_log_pkg.Log_Msg
875: ( p_instance_id
876: , g_table_name
877: , 'Entering Pre_Insert_Child procedure'
878: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 926: jtm_message_log_pkg.Log_Msg

922: END LOOP;
923: END IF;
924:
925: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
926: jtm_message_log_pkg.Log_Msg
927: ( p_instance_id
928: , g_table_name
929: , 'Leaving Pre_Insert_Child procedure'
930: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 972: jtm_message_log_pkg.Log_Msg

968: /*** get debug level ***/
969: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
970:
971: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
972: jtm_message_log_pkg.Log_Msg
973: ( p_instance_id
974: , g_table_name
975: , 'Entering Delete_Childs'
976: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 992: jtm_message_log_pkg.Log_Msg

988: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
989: );
990:
991: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
992: jtm_message_log_pkg.Log_Msg
993: ( p_instance_id
994: , g_table_name
995: , 'Child removed from ACC - INSTANCE_ID: ' || r_child_instance.subject_id
996: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1002: jtm_message_log_pkg.Log_Msg

998: END LOOP; -- Next child IB
999: END IF;
1000:
1001: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1002: jtm_message_log_pkg.Log_Msg
1003: ( p_instance_id
1004: , g_table_name
1005: , 'Leaving Delete_Childs'
1006: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1029: jtm_message_log_pkg.Log_Msg

1025: /*** get debug level ***/
1026: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1027:
1028: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1029: jtm_message_log_pkg.Log_Msg
1030: ( p_instance_id
1031: , g_table_name
1032: , 'Entering Delete_Parents'
1033: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1050: jtm_message_log_pkg.Log_Msg

1046: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
1047: );
1048:
1049: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1050: jtm_message_log_pkg.Log_Msg
1051: ( p_instance_id
1052: , g_table_name
1053: , 'Parent removed from ACC - INSTANCE_ID: ' || r_parent_instance.object_id
1054: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1060: jtm_message_log_pkg.Log_Msg

1056: END LOOP; -- Next child IB
1057: END IF;
1058:
1059: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1060: jtm_message_log_pkg.Log_Msg
1061: ( p_instance_id
1062: , g_table_name
1063: , 'Leaving Delete_Parents'
1064: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1113: jtm_message_log_pkg.Log_Msg

1109: /*** get debug level ***/
1110: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1111:
1112: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1113: jtm_message_log_pkg.Log_Msg
1114: ( p_instance_id
1115: , g_table_name
1116: , 'Entering Post_Delete_Child'
1117: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1139: jtm_message_log_pkg.Log_Msg

1135:
1136: END LOOP;
1137:
1138: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1139: jtm_message_log_pkg.Log_Msg
1140: ( p_instance_id
1141: , g_table_name
1142: , 'Leaving Post_Delete_Child'
1143: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1174: jtm_message_log_pkg.Log_Msg

1170: BEGIN
1171: /*** get debug level ***/
1172: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1173: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1174: jtm_message_log_pkg.Log_Msg
1175: ( p_resource_id
1176: , g_table_name
1177: , 'Entering Pre_Insert_Item'
1178: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1183: jtm_message_log_pkg.Log_Msg

1179: END IF;
1180:
1181: FOR r_item_instance IN c_item_instance ( p_inventory_item_id, p_organization_id, p_subinventory_code ) LOOP
1182: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1183: jtm_message_log_pkg.Log_Msg
1184: ( r_item_instance.instance_id
1185: , g_table_name
1186: , 'Inserting ACC record for resource_id = ' || p_resource_id
1187: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1209: jtm_message_log_pkg.Log_Msg

1205:
1206: END LOOP;
1207:
1208: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1209: jtm_message_log_pkg.Log_Msg
1210: ( p_resource_id
1211: , g_table_name
1212: , 'Leaving Pre_Insert_Item'
1213: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1244: jtm_message_log_pkg.Log_Msg

1240: BEGIN
1241: /*** get debug level ***/
1242: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1244: jtm_message_log_pkg.Log_Msg
1245: ( p_resource_id
1246: , g_table_name
1247: , 'Entering Post_Delete_Item'
1248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1253: jtm_message_log_pkg.Log_Msg

1249: END IF;
1250:
1251: FOR r_item_instance IN c_item_instance ( p_inventory_item_id, p_organization_id, p_subinventory_code ) LOOP
1252: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1253: jtm_message_log_pkg.Log_Msg
1254: ( r_item_instance.instance_id
1255: , g_table_name
1256: , 'Deleting ACC record for resource_id = ' || p_resource_id
1257: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1280: jtm_message_log_pkg.Log_Msg

1276:
1277: END LOOP;
1278:
1279: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1280: jtm_message_log_pkg.Log_Msg
1281: ( p_resource_id
1282: , g_table_name
1283: , 'Leaving Post_Delete_Item'
1284: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1332: jtm_message_log_pkg.Log_Msg

1328: /*** get debug level ***/
1329: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1330:
1331: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1332: jtm_message_log_pkg.Log_Msg
1333: ( p_instance_id
1334: , g_table_name
1335: , 'Entering POST_INSERT hook'
1336: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1343: jtm_message_log_pkg.Log_Msg

1339:
1340: /*** Is this a parent ? ***/
1341: FOR r_is_parent IN c_is_parent( p_instance_id ) LOOP
1342: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1343: jtm_message_log_pkg.Log_Msg
1344: ( p_instance_id
1345: , g_table_name
1346: , 'Instance is parent for resource: '||r_is_parent.resource_id
1347: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1358: jtm_message_log_pkg.Log_Msg

1354:
1355: /*Is this a child ?*/
1356: FOR r_is_child IN c_is_child( p_instance_id ) LOOP
1357: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1358: jtm_message_log_pkg.Log_Msg
1359: ( p_instance_id
1360: , g_table_name
1361: , 'Instance is child for resource: '||r_is_child.resource_id
1362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1372: jtm_message_log_pkg.Log_Msg

1368: );
1369: END LOOP;
1370:
1371: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1372: jtm_message_log_pkg.Log_Msg
1373: ( p_instance_id
1374: , g_table_name
1375: , 'Leaving POST_INSERT hook'
1376: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1385: jtm_message_log_pkg.Log_Msg

1381:
1382: EXCEPTION WHEN OTHERS THEN
1383: /*** hook failed -> log error ***/
1384: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1385: jtm_message_log_pkg.Log_Msg
1386: ( p_instance_id
1387: , g_table_name
1388: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
1389: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 1465: jtm_message_log_pkg.Log_Msg

1461: /*** get debug level ***/
1462: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1463:
1464: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1465: jtm_message_log_pkg.Log_Msg
1466: ( 0
1467: , g_table_name
1468: , 'Entering CONC_ITEM_INSTANCES hook'
1469: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1479: jtm_message_log_pkg.Log_Msg

1475: FETCH c_changed BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
1476:
1477: IF (l_tab_access_id.COUNT > 0) THEN
1478: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1479: jtm_message_log_pkg.Log_Msg
1480: ( 0
1481: , g_table_name
1482: , 'Update ACC record for all resources, count = ' || l_tab_access_id.COUNT
1483: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1528: jtm_message_log_pkg.Log_Msg

1524:
1525: IF (inst_id.COUNT > 0) THEN
1526: FOR i IN inst_id.FIRST..inst_id.LAST LOOP
1527: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1528: jtm_message_log_pkg.Log_Msg
1529: ( inst_id(i)
1530: , g_table_name
1531: , 'Inserting ACC record for resource_id = ' || res_id(i)
1532: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1584: jtm_message_log_pkg.Log_Msg

1580:
1581: IF (inst_id.COUNT > 0) THEN
1582: FOR i IN inst_id.FIRST..inst_id.LAST LOOP
1583: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1584: jtm_message_log_pkg.Log_Msg
1585: ( inst_id(i)
1586: , g_table_name
1587: , 'Deleting ACC record for resource_id = ' || res_id(i)
1588: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1610: jtm_message_log_pkg.Log_Msg

1606: END IF;
1607:
1608:
1609: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1610: jtm_message_log_pkg.Log_Msg
1611: ( 0
1612: , g_table_name
1613: , 'Leaving CONC_ITEM_INSTANCES hook'
1614: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);