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

Line 38: jtm_message_log_pkg.Log_Msg

34: l_dummy BOOLEAN;
35:
36: BEGIN
37: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
38: jtm_message_log_pkg.Log_Msg
39: ( 0
40: , g_table_name
41: , 'Entering UPDATE_ACC_REC_MARKDIRTY'
42: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 53: jtm_message_log_pkg.Log_Msg

49: /*Call oracle lite*/
50: IF l_tab_access_id.COUNT > 0 THEN
51: /*** 1 or more acc rows retrieved -> push to resource ***/
52: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
53: jtm_message_log_pkg.Log_Msg
54: ( 0
55: , g_table_name
56: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
57: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 72: jtm_message_log_pkg.Log_Msg

68: END IF;
69: CLOSE c_changed;
70:
71: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
72: jtm_message_log_pkg.Log_Msg
73: ( 0
74: , g_table_name
75: , 'Leaving UPDATE_ACC_REC_MARKDIRTY'
76: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 81: jtm_message_log_pkg.Log_Msg

77: );
78: END IF;
79: EXCEPTION
80: WHEN OTHERS THEN
81: jtm_message_log_pkg.Log_Msg
82: ( 0
83: , g_table_name
84: , 'UPDATE_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
85: 'Error: '||sqlerrm

Line 132: jtm_message_log_pkg.Log_Msg

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

Line 169: jtm_message_log_pkg.Log_Msg

165: /*Call oracle lite*/
166: IF l_tab_access_id.COUNT > 0 THEN
167: /*** 1 or more acc rows retrieved -> push to resource ***/
168: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
169: jtm_message_log_pkg.Log_Msg
170: ( 0
171: , g_table_name
172: , 'Pushing ' || l_tab_access_id.COUNT || ' inserted record(s)'
173: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 195: jtm_message_log_pkg.Log_Msg

191: END IF;
192: CLOSE c_inserted;
193:
194: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
195: jtm_message_log_pkg.Log_Msg
196: ( 0
197: , g_table_name
198: , 'Leaving INSERT_ACC_REC_MARKDIRTY'
199: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 204: jtm_message_log_pkg.Log_Msg

200: );
201: END IF;
202: EXCEPTION
203: WHEN OTHERS THEN
204: jtm_message_log_pkg.Log_Msg
205: ( 0
206: , g_table_name
207: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
208: 'Error: '||sqlerrm

Line 236: jtm_message_log_pkg.Log_Msg

232: BEGIN
233: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
234:
235: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
236: jtm_message_log_pkg.Log_Msg
237: ( v_object_id => p_inventory_item_id
238: , v_object_name => g_table_name
239: , v_message => 'Entering Insert_Secondary_Locators'
240: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 246: jtm_message_log_pkg.Log_Msg

242:
243: FOR r_sec_locator IN c_sec_locator(p_inventory_item_id, p_organization_id, p_resource_id)
244: LOOP
245: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
246: jtm_message_log_pkg.Log_Msg
247: ( v_object_id => p_organization_id
248: , v_object_name => g_table_name
249: , v_message => 'Inserting ACC record :' || p_inventory_item_id || ' for resource id '
250: || p_resource_id

Line 277: jtm_message_log_pkg.Log_Msg

273: );
274: END LOOP;
275:
276: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
277: jtm_message_log_pkg.Log_Msg
278: ( v_object_id => p_inventory_item_id
279: , v_object_name => g_table_name
280: , v_message => 'Leaving Insert_Secondary_Locators'
281: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 314: jtm_message_log_pkg.Log_Msg

310: BEGIN
311: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
312:
313: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
314: jtm_message_log_pkg.Log_Msg
315: ( v_object_id => p_inventory_item_id
316: , v_object_name => g_table_name
317: , v_message => 'Entering Delete_Secondary_Locators'
318: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 324: jtm_message_log_pkg.Log_Msg

320:
321: FOR r_sec_locator IN c_sec_locator(p_inventory_item_id, p_organization_id, p_resource_id)
322: LOOP
323: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
324: jtm_message_log_pkg.Log_Msg
325: ( v_object_id => p_organization_id
326: , v_object_name => g_table_name
327: , v_message => 'Deleting ACC record :' || p_inventory_item_id || ' for resource id '
328: || p_resource_id

Line 354: jtm_message_log_pkg.Log_Msg

350: );
351: END LOOP;
352:
353: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
354: jtm_message_log_pkg.Log_Msg
355: ( v_object_id => p_inventory_item_id
356: , v_object_name => g_table_name
357: , v_message => 'Leaving Delete_Secondary_Locators'
358: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 402: jtm_message_log_pkg.Log_Msg

398: /*Call oracle lite*/
399: IF l_tab_access_id.COUNT > 0 THEN
400: /*** 1 or more acc rows retrieved -> push to resource ***/
401: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
402: jtm_message_log_pkg.Log_Msg
403: ( 0
404: , g_table_name
405: , 'Pushing ' || l_tab_access_id.COUNT || ' inserted record(s)'
406: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 429: jtm_message_log_pkg.Log_Msg

425: END IF;
426: CLOSE c_inserted;
427: COMMIT;
428: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
429: jtm_message_log_pkg.Log_Msg
430: ( 0
431: , g_table_name
432: , 'Leaving INSERT_ACC_REC_MARKDIRTY'
433: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 439: jtm_message_log_pkg.Log_Msg

435: END IF;
436: EXCEPTION
437: WHEN OTHERS THEN
438: ROLLBACK;
439: jtm_message_log_pkg.Log_Msg
440: ( 0
441: , g_table_name
442: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
443: 'Error: '||sqlerrm

Line 468: jtm_message_log_pkg.Log_Msg

464: BEGIN
465: /*** get debug level ***/
466: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
467: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
468: jtm_message_log_pkg.Log_Msg
469: ( 0
470: , g_table_name
471: , 'Entering CON_REQUEST_SECONDARY_LOCATORS'
472: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 485: jtm_message_log_pkg.Log_Msg

481: l_current_run_date := SYSDATE;
482:
483: /*** Push updated system item records to resources ***/
484: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
485: jtm_message_log_pkg.Log_Msg
486: ( 0
487: , g_table_name
488: , 'Pushing updated records'
489: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 500: jtm_message_log_pkg.Log_Msg

496: /*** Get the mobile laptop resources and loop over all of them ***/
497: INSERT_ACC_REC_MARKDIRTY( p_last_run_date => r_LastRundate.last_run_date );
498:
499: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
500: jtm_message_log_pkg.Log_Msg
501: ( 0
502: , g_table_name
503: , 'Updating LAST_RUN_DATE from '||r_LastRundate.LAST_RUN_DATE||' to '||l_current_run_date
504: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 517: jtm_message_log_pkg.Log_Msg

513:
514: COMMIT;
515:
516: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
517: jtm_message_log_pkg.Log_Msg
518: ( 0
519: , g_table_name
520: , 'Leaving CON_REQUEST_SECONDARY_LOCATORS'
521: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 528: jtm_message_log_pkg.Log_Msg

524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
528: jtm_message_log_pkg.Log_Msg
529: ( 0
530: , g_table_name
531: , 'CON_REQUEST_SECONDARY_LOCATORS'||fnd_global.local_chr(10)||
532: 'Error: '||sqlerrm