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_HOOK_UTIL_PKG

Line 18: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

14: */
15:
16: /*** Globals ***/
17: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_MTL_ITEM_LOCATIONS_ACC';
18: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
19: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_ITEM_LOCATIONS');
20: g_table_name CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
21: g_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';
22: g_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 19: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_ITEM_LOCATIONS');

15:
16: /*** Globals ***/
17: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_MTL_ITEM_LOCATIONS_ACC';
18: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
19: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_ITEM_LOCATIONS');
20: g_table_name CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
21: g_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';
22: g_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
23: g_debug_level NUMBER; -- debug level

Line 46: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

42: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
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'

Line 51: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
52: );
53: END IF;
54:
55: /*Fetch all changed item locations that are in the acc table*/

Line 61: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

57: FETCH c_changed BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
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)'

Line 66: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
67: );
68: END IF;
69: /*** push to oLite using asg_download ***/
70: l_dummy := asg_download.markdirty(

Line 80: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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

Line 85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
86: );
87: END IF;
88: EXCEPTION
89: WHEN OTHERS THEN

Line 95: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

91: ( 0
92: , g_table_name
93: , 'UPDATE_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
94: 'Error: '||sqlerrm
95: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
96: RAISE;
97: END UPDATE_ACC_REC_MARKDIRTY;
98:
99: /*

Line 129: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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

Line 134: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
135: );
136: END IF;
137:
138: /*Increment count if the record already exists */

Line 157: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

153: INTO l_tab_access_id, l_tab_resource_id, locations, organizations, counters;
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)'

Line 162: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
163: );
164: END IF;
165:
166: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST

Line 183: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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

Line 188: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
189: );
190: END IF;
191: EXCEPTION
192: WHEN OTHERS THEN

Line 198: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

194: ( 0
195: , g_table_name
196: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
197: 'Error: '||sqlerrm
198: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
199: RAISE;
200: END INSERT_ACC_REC_MARKDIRTY;
201:
202: /*

Line 280: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

276: , p_resource_id IN NUMBER
277: )
278: IS
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

Line 282: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

278: IS
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'

Line 287: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
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

Line 290: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

286: , v_message => 'Entering Insert_Item_Location'
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 '

Line 296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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
296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
297: END IF;
298:
299: /*** Call common package to insert record into ACC table ***/
300: JTM_HOOK_UTIL_PKG.Insert_Acc

Line 300: JTM_HOOK_UTIL_PKG.Insert_Acc

296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
297: END IF;
298:
299: /*** Call common package to insert record into ACC table ***/
300: JTM_HOOK_UTIL_PKG.Insert_Acc
301: ( p_publication_item_names => g_publication_item_name
302: ,p_acc_table_name => g_acc_table_name
303: ,p_resource_id => p_resource_id
304: ,p_pk1_name => g_pk1_name

Line 310: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

306: ,p_pk2_name => g_pk2_name
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'

Line 315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
316: END IF;
317: END Insert_Item_Location;
318:
319: PROCEDURE Update_Item_Location

Line 337: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

333: WHERE INVENTORY_LOCATION_ID = b_inventory_location_id
334: AND ORGANIZATION_ID = b_organization_id
335: AND RESOURCE_ID = b_resource_id;
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

Line 339: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

335: AND RESOURCE_ID = b_resource_id;
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'

Line 344: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
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

Line 347: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

343: , v_message => 'Entering Update_Item_Location'
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 '

Line 353: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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
353: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
354: END IF;
355:
356: OPEN c_item_location_acc(
357: p_inventory_location_id,

Line 365: JTM_HOOK_UTIL_PKG.Update_Acc

361: CLOSE c_item_location_acc;
362:
363: IF l_access_id IS NOT NULL THEN
364: /*** Call common package to delete record from ACC table ***/
365: JTM_HOOK_UTIL_PKG.Update_Acc
366: ( p_publication_item_names => g_publication_item_name
367: ,p_acc_table_name => g_acc_table_name
368: ,p_resource_id => p_resource_id
369: ,p_access_id => l_access_id

Line 373: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

369: ,p_access_id => l_access_id
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'

Line 378: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
379: END IF;
380: END Update_Item_Location;
381:
382: PROCEDURE Delete_Item_Location

Line 389: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

385: , p_resource_id IN NUMBER
386: )
387: IS
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

Line 391: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

387: IS
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'

Line 396: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
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

Line 399: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

395: , v_message => 'Entering Delete_Item_Location'
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 '

Line 405: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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
405: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
406: END IF;
407:
408: /*** Call common package to delete record from ACC table ***/
409: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 409: JTM_HOOK_UTIL_PKG.Delete_Acc

405: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
406: END IF;
407:
408: /*** Call common package to delete record from ACC table ***/
409: JTM_HOOK_UTIL_PKG.Delete_Acc
410: ( p_publication_item_names => g_publication_item_name
411: ,p_acc_table_name => g_acc_table_name
412: ,p_resource_id => p_resource_id
413: ,p_pk1_name => g_pk1_name

Line 419: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

415: ,p_pk2_name => g_pk2_name
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'

Line 424: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
425: END IF;
426: END Delete_Item_Location;
427:
428: /*

Line 461: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

457: INTO l_tab_access_id, l_tab_resource_id, locations, organizations, counters;
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)'

Line 466: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
467: );
468: END IF;
469:
470: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST

Line 488: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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

Line 493: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
494: );
495: END IF;
496: EXCEPTION
497: WHEN OTHERS THEN

Line 504: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

500: ( 0
501: , g_table_name
502: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
503: 'Error: '||sqlerrm
504: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
505: RAISE;
506: END POPULATE_ITEM_LOCATIONS_ACC;
507:
508: PROCEDURE CON_REQUEST_ITEM_LOCATIONS

Line 522: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

518: r_LastRundate c_LastRundate%ROWTYPE;
519: l_current_run_date DATE;
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

Line 523: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

519: l_current_run_date DATE;
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'

Line 528: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
529: );
530: END IF;
531:
532: /*** First retrieve last run date of the conccurent program ***/

Line 540: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

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

Line 545: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
546: );
547: END IF;
548: UPDATE_ACC_REC_MARKDIRTY( p_last_run_date => r_LastRundate.last_run_date );
549: COMMIT;

Line 555: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

551: -- INSERT new records if found, for the mobile users' subinventories
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

Line 560: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

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
561: );
562: END IF;
563:
564: /*Update the last run date*/

Line 572: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

568: AND procedure_name = 'CON_REQUEST_ITEM_LOCATIONS';
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'

Line 577: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

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
578: );
579: END IF;
580:
581: EXCEPTION

Line 583: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

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

Line 589: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

585: ( 0
586: , g_table_name
587: , 'CON_REQUEST_ITEM_LOCATIONS'||fnd_global.local_chr(10)||
588: 'Error: '||sqlerrm
589: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
590: END IF;
591: ROLLBACK;
592: END CON_REQUEST_ITEM_LOCATIONS;
593: