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

Line 47: jtm_message_log_pkg.Log_Msg

43: l_dummy BOOLEAN;
44:
45: BEGIN
46: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
47: jtm_message_log_pkg.Log_Msg
48: ( 0
49: , g_table_name
50: , 'Entering UPDATE_ACC_REC_MARKDIRTY'
51: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 62: jtm_message_log_pkg.Log_Msg

58: /*Call oracle lite*/
59: IF l_tab_access_id.COUNT > 0 THEN
60: /*** 1 or more acc rows retrieved -> push to resource ***/
61: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
62: jtm_message_log_pkg.Log_Msg
63: ( 0
64: , g_table_name
65: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
66: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 81: jtm_message_log_pkg.Log_Msg

77: END IF;
78: CLOSE c_changed;
79:
80: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
81: jtm_message_log_pkg.Log_Msg
82: ( 0
83: , g_table_name
84: , 'Leaving UPDATE_ACC_REC_MARKDIRTY'
85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 90: jtm_message_log_pkg.Log_Msg

86: );
87: END IF;
88: EXCEPTION
89: WHEN OTHERS THEN
90: jtm_message_log_pkg.Log_Msg
91: ( 0
92: , g_table_name
93: , 'UPDATE_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
94: 'Error: '||sqlerrm

Line 130: jtm_message_log_pkg.Log_Msg

126: l_dummy BOOLEAN;
127: -- CSL.CSL_ACC_SEQUENCE
128: BEGIN
129: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
130: jtm_message_log_pkg.Log_Msg
131: ( 0
132: , g_table_name
133: , 'Entering INSERT_ACC_REC_MARKDIRTY'
134: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 158: jtm_message_log_pkg.Log_Msg

154: /*Call oracle lite*/
155: IF l_tab_access_id.COUNT > 0 THEN
156: /*** 1 or more acc rows retrieved -> push to resource ***/
157: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
158: jtm_message_log_pkg.Log_Msg
159: ( 0
160: , g_table_name
161: , 'Pushing ' || l_tab_access_id.COUNT || ' inserted record(s)'
162: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 184: jtm_message_log_pkg.Log_Msg

180: END IF;
181: CLOSE c_inserted;
182:
183: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
184: jtm_message_log_pkg.Log_Msg
185: ( 0
186: , g_table_name
187: , 'Leaving INSERT_ACC_REC_MARKDIRTY'
188: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 193: jtm_message_log_pkg.Log_Msg

189: );
190: END IF;
191: EXCEPTION
192: WHEN OTHERS THEN
193: jtm_message_log_pkg.Log_Msg
194: ( 0
195: , g_table_name
196: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
197: 'Error: '||sqlerrm

Line 283: jtm_message_log_pkg.Log_Msg

279: BEGIN
280: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
281:
282: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
283: jtm_message_log_pkg.Log_Msg
284: ( v_object_id => p_inventory_location_id
285: , v_object_name => g_table_name
286: , v_message => 'Entering Insert_Item_Location'
287: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 291: jtm_message_log_pkg.Log_Msg

287: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
288: END IF;
289:
290: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
291: jtm_message_log_pkg.Log_Msg
292: ( v_object_id => p_organization_id
293: , v_object_name => g_table_name
294: , v_message => 'Inserting ACC record :' || p_inventory_location_id || ' for resource id '
295: || p_resource_id

Line 311: jtm_message_log_pkg.Log_Msg

307: ,p_pk2_num_value => p_organization_id
308: );
309:
310: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
311: jtm_message_log_pkg.Log_Msg
312: ( v_object_id => p_inventory_location_id
313: , v_object_name => g_table_name
314: , v_message => 'Leaving Insert_Item_Location'
315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 340: jtm_message_log_pkg.Log_Msg

336: BEGIN
337: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
338:
339: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
340: jtm_message_log_pkg.Log_Msg
341: ( v_object_id => p_inventory_location_id
342: , v_object_name => g_table_name
343: , v_message => 'Entering Update_Item_Location'
344: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 348: jtm_message_log_pkg.Log_Msg

344: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
345: END IF;
346:
347: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
348: jtm_message_log_pkg.Log_Msg
349: ( v_object_id => p_organization_id
350: , v_object_name => g_table_name
351: , v_message => 'Deleting ACC record :' || p_inventory_location_id || ' for resource id '
352: || p_resource_id

Line 374: jtm_message_log_pkg.Log_Msg

370: );
371: END IF;
372:
373: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
374: jtm_message_log_pkg.Log_Msg
375: ( v_object_id => p_inventory_location_id
376: , v_object_name => g_table_name
377: , v_message => 'Leaving Update_Item_Location'
378: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 392: jtm_message_log_pkg.Log_Msg

388: BEGIN
389: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
390:
391: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
392: jtm_message_log_pkg.Log_Msg
393: ( v_object_id => p_inventory_location_id
394: , v_object_name => g_table_name
395: , v_message => 'Entering Delete_Item_Location'
396: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 400: jtm_message_log_pkg.Log_Msg

396: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
397: END IF;
398:
399: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
400: jtm_message_log_pkg.Log_Msg
401: ( v_object_id => p_organization_id
402: , v_object_name => g_table_name
403: , v_message => 'Deleting ACC record :' || p_inventory_location_id || ' for resource id '
404: || p_resource_id

Line 420: jtm_message_log_pkg.Log_Msg

416: ,p_pk2_num_value => p_organization_id
417: );
418:
419: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
420: jtm_message_log_pkg.Log_Msg
421: ( v_object_id => p_inventory_location_id
422: , v_object_name => g_table_name
423: , v_message => 'Leaving Delete_Item_Location'
424: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 462: jtm_message_log_pkg.Log_Msg

458: /*Call oracle lite*/
459: IF l_tab_access_id.COUNT > 0 THEN
460: /*** 1 or more acc rows retrieved -> push to resource ***/
461: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
462: jtm_message_log_pkg.Log_Msg
463: ( 0
464: , g_table_name
465: , 'Pushing ' || l_tab_access_id.COUNT || ' inserted record(s)'
466: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 489: jtm_message_log_pkg.Log_Msg

485: END IF;
486: CLOSE c_inserted;
487: COMMIT;
488: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
489: jtm_message_log_pkg.Log_Msg
490: ( 0
491: , g_table_name
492: , 'Leaving INSERT_ACC_REC_MARKDIRTY'
493: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 499: jtm_message_log_pkg.Log_Msg

495: END IF;
496: EXCEPTION
497: WHEN OTHERS THEN
498: ROLLBACK;
499: jtm_message_log_pkg.Log_Msg
500: ( 0
501: , g_table_name
502: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
503: 'Error: '||sqlerrm

Line 524: jtm_message_log_pkg.Log_Msg

520: BEGIN
521: /*** get debug level ***/
522: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
523: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
524: jtm_message_log_pkg.Log_Msg
525: ( 0
526: , g_table_name
527: , 'Entering CON_REQUEST_MTL_ITEM_LOCATIONS'
528: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 541: jtm_message_log_pkg.Log_Msg

537: l_current_run_date := SYSDATE;
538:
539: /*** Push updated system item records to resources ***/
540: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
541: jtm_message_log_pkg.Log_Msg
542: ( 0
543: , g_table_name
544: , 'Pushing updated records'
545: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 556: jtm_message_log_pkg.Log_Msg

552: /*** Get the mobile laptop resources and loop over all of them ***/
553: INSERT_ACC_REC_MARKDIRTY( p_last_run_date => r_LastRundate.last_run_date );
554:
555: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
556: jtm_message_log_pkg.Log_Msg
557: ( 0
558: , g_table_name
559: , 'Updating LAST_RUN_DATE from '||r_LastRundate.LAST_RUN_DATE||' to '||l_current_run_date
560: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 573: jtm_message_log_pkg.Log_Msg

569:
570: COMMIT;
571:
572: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
573: jtm_message_log_pkg.Log_Msg
574: ( 0
575: , g_table_name
576: , 'Leaving CON_REQUEST_ITEM_LOCATIONS'
577: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 584: jtm_message_log_pkg.Log_Msg

580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
584: jtm_message_log_pkg.Log_Msg
585: ( 0
586: , g_table_name
587: , 'CON_REQUEST_ITEM_LOCATIONS'||fnd_global.local_chr(10)||
588: 'Error: '||sqlerrm