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

Line 42: jtm_message_log_pkg.Log_Msg

38: /*** get debug level ***/
39: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
40:
41: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
42: jtm_message_log_pkg.Log_Msg
43: ( v_object_id => null
44: , v_object_name => g_table_name
45: , v_message => 'Entering REFRESH_ONHAND_QTY'
46: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 97: jtm_message_log_pkg.Log_Msg

93:
94: /*** Process all records from Bulk recordset ***/
95: IF (sub_code.COUNT > 0) THEN
96: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
97: jtm_message_log_pkg.Log_Msg
98: ( v_object_id => null
99: , v_object_name => g_table_name
100: , v_message => 'Number of updated records for REFRESH_ONHAND_QTY : '
101: || sub_code.COUNT

Line 184: jtm_message_log_pkg.Log_Msg

180: /*** Processed MV table, now push changes to ACC table ***/
181: PROCESS_ACC(l_current_run_date);
182:
183: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
184: jtm_message_log_pkg.Log_Msg
185: ( v_object_id => 1
186: , v_object_name => g_table_name
187: , v_message => 'Leaving REFRESH_ONHAND_QTY'
188: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 194: jtm_message_log_pkg.Log_Msg

190: END IF;
191: EXCEPTION WHEN OTHERS THEN
192: /*** hook failed -> log error ***/
193: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
194: jtm_message_log_pkg.Log_Msg
195: ( v_object_id => 1
196: , v_object_name => g_table_name
197: , v_message => 'Caught exception in REFRESH_ONHAND_QTY hook:' || fnd_global.local_chr(10) || sqlerrm
198: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 251: jtm_message_log_pkg.Log_Msg

247: /*** get debug level ***/
248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
249:
250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
251: jtm_message_log_pkg.Log_Msg
252: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
253: , v_object_name => g_table_name
254: , v_message => 'Entering PROCESS_ACC'
255: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 264: jtm_message_log_pkg.Log_Msg

260: FOR r_secinv_resources IN c_secinv_resources LOOP
261: /*** First retrieve access_id of updated records and push them ***/
262:
263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
264: jtm_message_log_pkg.Log_Msg
265: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
266: , v_object_name => g_table_name
267: , v_message => 'Checking updates and inserts for resource_id = ' || r_secinv_resources.resource_id
268: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 290: jtm_message_log_pkg.Log_Msg

286: IF (acc_id.COUNT > 0) THEN
287: /*** push to oLite using asg_download ***/
288:
289: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
290: jtm_message_log_pkg.Log_Msg
291: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
292: , v_object_name => g_table_name
293: , v_message => 'Pushing ' || acc_id.COUNT || ' updated record(s)'
294: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 300: jtm_message_log_pkg.Log_Msg

296: END IF;
297:
298: FOR i IN acc_id.FIRST..acc_id.LAST LOOP
299: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
300: jtm_message_log_pkg.Log_Msg
301: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
302: , v_object_name => g_table_name
303: , v_message => 'Pushing record with access_id = ' || acc_id(i)
304: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 364: jtm_message_log_pkg.Log_Msg

360:
361: IF (acc_id.COUNT > 0) THEN
362: /*** push to oLite using asg_download ***/
363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
364: jtm_message_log_pkg.Log_Msg
365: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
366: , v_object_name => g_table_name
367: , v_message => 'Pushing ' || acc_id.COUNT || ' inserted record(s)'
368: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 381: jtm_message_log_pkg.Log_Msg

377:
378: FOR i IN acc_id.FIRST..acc_id.LAST LOOP
379:
380: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
381: jtm_message_log_pkg.Log_Msg
382: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
383: , v_object_name => g_table_name
384: , v_message => 'Pushing record with access_id = ' || acc_id(i)
385: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 399: jtm_message_log_pkg.Log_Msg

395: );
396:
397: IF NVL(track_flag(i),'N') <> 'Y' THEN
398: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
399: jtm_message_log_pkg.Log_Msg
400: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
401: , v_object_name => g_table_name
402: , v_message => 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.PRE_INSERT_CHILD'
403: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 443: jtm_message_log_pkg.Log_Msg

439:
440: IF (acc_id.COUNT > 0) THEN
441: /*** push to oLite using asg_download ***/
442: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
443: jtm_message_log_pkg.Log_Msg
444: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
445: , v_object_name => g_table_name
446: , v_message => 'Pushing ' || acc_id.COUNT || ' deleted record(s)'
447: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 454: jtm_message_log_pkg.Log_Msg

450:
451: FOR i IN acc_id.FIRST..acc_id.LAST LOOP
452:
453: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
454: jtm_message_log_pkg.Log_Msg
455: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
456: , v_object_name => g_table_name
457: , v_message => 'Pushing record with access_id = ' || acc_id(i)
458: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 472: jtm_message_log_pkg.Log_Msg

468: );
469:
470: IF NVL(track_flag(i),'N') <> 'Y' THEN
471: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
472: jtm_message_log_pkg.Log_Msg
473: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
474: , v_object_name => g_table_name
475: , v_message => 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.POST_DELETE_CHILD'
476: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 499: jtm_message_log_pkg.Log_Msg

495:
496: COMMIT;
497:
498: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
501: , v_object_name => g_table_name
502: , v_message => 'Leaving PROCESS_ACC'
503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 509: jtm_message_log_pkg.Log_Msg

505: END IF;
506: EXCEPTION WHEN OTHERS THEN
507: /*** hook failed -> log error ***/
508: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
509: jtm_message_log_pkg.Log_Msg
510: ( v_object_id => 1
511: , v_object_name => g_table_name
512: , v_message => 'Caught exception in PROCESS_ACC hook:' || fnd_global.local_chr(10) || sqlerrm
513: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 530: jtm_message_log_pkg.Log_Msg

526: BEGIN
527: /*** get debug level ***/
528: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
529: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
530: jtm_message_log_pkg.Log_Msg
531: ( p_resource_id
532: , g_table_name
533: , 'Entering DELETE_ALL_ACC_RECORDS'
534: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 550: jtm_message_log_pkg.Log_Msg

546: WHERE RESOURCE_ID = p_resource_id;
547:
548: IF l_tab_access_id.COUNT > 0 THEN
549: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
550: jtm_message_log_pkg.Log_Msg
551: ( p_resource_id
552: , g_table_name
553: , 'Pulling '||l_tab_access_id.COUNT||' records from Oracle Lite for resource '||p_resource_id
554: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 578: jtm_message_log_pkg.Log_Msg

574:
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576:
577: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
578: jtm_message_log_pkg.Log_Msg
579: ( p_resource_id
580: , g_table_name
581: , 'Leaving DELETE_ALL_ACC_RECORDS'
582: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 591: jtm_message_log_pkg.Log_Msg

587: /*** hook failed -> log error ***/
588: -- x_return_status := FND_API.G_RET_STS_ERROR;
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
590: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
591: jtm_message_log_pkg.Log_Msg
592: ( v_object_id => 1
593: , v_object_name => g_table_name
594: , v_message => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
595: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR