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_HOOK_UTIL_PKG

Line 7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

3:
4:
5: /*** Globals for notifications ***/
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_MTL_ONHAND_QTY_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_MTL_ONHAND_QTY');
9: g_table_name CONSTANT VARCHAR2(30) := 'MTL_ONHAND_QUANTITIES';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_MTL_ONHAND_QTY');

4:
5: /*** Globals for notifications ***/
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_MTL_ONHAND_QTY_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_MTL_ONHAND_QTY');
9: g_table_name CONSTANT VARCHAR2(30) := 'MTL_ONHAND_QUANTITIES';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
12: g_pk3_name CONSTANT VARCHAR2(30) := 'SUBINVENTORY_CODE';

Line 39: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

35: l_current_run_date DATE;
36:
37: BEGIN
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

Line 41: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

37: BEGIN
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'

Line 46: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
47: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
48: END IF;
49:
50: l_current_run_date := SYSDATE;

Line 96: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

92: );
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 : '

Line 102: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
102: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
103: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
104: END IF;
105: FORALL i IN sub_code.FIRST..sub_code.LAST
106: UPDATE CSL_MTL_ONHAND_QTY_MV SET LAST_UPDATE_DATE = l_current_run_date, TOT_TXN_QUANTITY = qty(i)

Line 183: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

179:
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'

Line 188: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
189: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
190: END IF;
191: EXCEPTION WHEN OTHERS THEN
192: /*** hook failed -> log error ***/

Line 193: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

189: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
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

Line 198: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

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
199: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
200: END IF;
201: ROLLBACK;
202: fnd_msg_pub.Add_Exc_Msg('CSL_MTL_ONHAND_QTY_ACC_PKG','REFRESH_ONHAND_QTY',sqlerrm);

Line 248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

244: l_dummy BOOLEAN;
245:
246: BEGIN
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')

Line 250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

246: BEGIN
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'

Line 255: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
256: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
257: END IF;
258:
259: /*** Loop through resources to which a subinventory is assigned ***/

Line 263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

259: /*** Loop through resources to which a subinventory is assigned ***/
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

Line 268: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
269: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
270: END IF;
271:
272: /*** Push updated record to client ***/

Line 289: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

285:
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)'

Line 294: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
295: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
296: END IF;
297:
298: FOR i IN acc_id.FIRST..acc_id.LAST LOOP

Line 299: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

295: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
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)

Line 304: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
305: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
306: END IF;
307:
308: l_dummy := asg_download.markdirty(

Line 363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

359: );
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)'

Line 368: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
369: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
370: END IF;
371:
372: FORALL i IN acc_id.FIRST..acc_id.LAST

Line 380: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

376: rvsion(i), loc_id(i), lot_num(i), acc_id(i),1,SYSDATE,1,SYSDATE,1);
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)

Line 385: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
386: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
387: END IF;
388:
389: l_dummy := asg_download.markdirty(

Line 398: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

394: , P_TIMESTAMP => SYSDATE
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'

Line 403: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
404: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
405: END IF;
406: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.PRE_INSERT_CHILD(inv_id(i),org_id(i),r_secinv_resources.resource_id);
407: END IF;

Line 442: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

438: );
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)'

Line 447: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
448: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
449: END IF;
450:
451: FOR i IN acc_id.FIRST..acc_id.LAST LOOP

Line 453: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

449: END IF;
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)

Line 458: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
459: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
460: END IF;
461:
462: l_dummy := asg_download.markdirty(

Line 471: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

467: , P_TIMESTAMP => SYSDATE
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'

Line 476: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
477: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
478: END IF;
479:
480: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.POST_DELETE_CHILD( inv_id(i)

Line 498: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

494: CSL_CSI_ITEM_INSTANCES_ACC_PKG.CONC_ITEM_INSTANCES(l_current_run_date);
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'

Line 503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
504: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
505: END IF;
506: EXCEPTION WHEN OTHERS THEN
507: /*** hook failed -> log error ***/

Line 508: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

504: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
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

Line 513: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

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
514: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
515: END IF;
516: ROLLBACK;
517: fnd_msg_pub.Add_Exc_Msg('CSL_MTL_ONHAND_QTY_ACC_PKG','PROCESS_ACC',sqlerrm);

Line 528: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

524: l_tab_access_id dbms_sql.Number_Table;
525: l_dummy BOOLEAN;
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

Line 529: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

525: l_dummy BOOLEAN;
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'

Line 534: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
535: , v_module => 'csl_mtl_onhand_qty_acc_pkg'
536: );
537: END IF;
538:

Line 549: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

545: FROM CSL_MTL_ONHAND_QTY_ACC
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

Line 554: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
555: , v_module => 'csl_mtl_onhand_qty_acc_pkg'
556: );
557: END IF;
558:

Line 577: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

573: END IF;
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'

Line 582: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
583: , v_module => 'csl_mtl_onhand_qty_acc_pkg'
584: );
585: END IF;
586: EXCEPTION WHEN OTHERS THEN

Line 590: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

586: EXCEPTION WHEN OTHERS THEN
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

Line 595: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

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
596: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
597: END IF;
598: fnd_msg_pub.Add_Exc_Msg('CSL_MTL_ONHAND_QTY_ACC_PKG','PROCESS_ACC',sqlerrm);
599: END DELETE_ALL_ACC_RECORDS;