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.INV_MGD_POSITIONS_PROC dependencies on INV_MGD_POS_UTIL

Line 62: INV_MGD_POS_UTIL.Log

58: l_count NUMBER;
59: BEGIN
60:
61: IF G_DEBUG = 'Y' THEN
62: INV_MGD_POS_UTIL.Log
63: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
64: , p_msg => '> '||G_PKG_NAME||'.'||'Data_Set_Exists'
65: );
66: END IF;

Line 63: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

59: BEGIN
60:
61: IF G_DEBUG = 'Y' THEN
62: INV_MGD_POS_UTIL.Log
63: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
64: , p_msg => '> '||G_PKG_NAME||'.'||'Data_Set_Exists'
65: );
66: END IF;
67:

Line 74: INV_MGD_POS_UTIL.Log

70: FROM mtl_mgd_inventory_positions
71: WHERE data_set_name = p_data_set_name;
72:
73: IF G_DEBUG = 'Y' THEN
74: INV_MGD_POS_UTIL.Log
75: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
76: , p_msg => '< '||G_PKG_NAME||'.'||'Data_Set_Exists'
77: );
78: END IF;

Line 75: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

71: WHERE data_set_name = p_data_set_name;
72:
73: IF G_DEBUG = 'Y' THEN
74: INV_MGD_POS_UTIL.Log
75: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
76: , p_msg => '< '||G_PKG_NAME||'.'||'Data_Set_Exists'
77: );
78: END IF;
79:

Line 107: INV_MGD_POS_UTIL.Log

103: IS
104: BEGIN
105:
106: IF G_DEBUG = 'Y' THEN
107: INV_MGD_POS_UTIL.Log
108: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
109: , p_msg => '> '||G_PKG_NAME||'.'||'Get_Context'
110: );
111: END IF;

Line 108: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

104: BEGIN
105:
106: IF G_DEBUG = 'Y' THEN
107: INV_MGD_POS_UTIL.Log
108: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
109: , p_msg => '> '||G_PKG_NAME||'.'||'Get_Context'
110: );
111: END IF;
112:

Line 143: INV_MGD_POS_UTIL.Log

139: FROM mtl_parameters
140: WHERE organization_code = p_parent_org_code;
141:
142: IF G_DEBUG = 'Y' THEN
143: INV_MGD_POS_UTIL.Log
144: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
145: , p_msg => '< '||G_PKG_NAME||'.'||'Get_Context'
146: );
147: END IF;

Line 144: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

140: WHERE organization_code = p_parent_org_code;
141:
142: IF G_DEBUG = 'Y' THEN
143: INV_MGD_POS_UTIL.Log
144: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
145: , p_msg => '< '||G_PKG_NAME||'.'||'Get_Context'
146: );
147: END IF;
148:

Line 179: INV_MGD_POS_UTIL.Log

175: PRAGMA AUTONOMOUS_TRANSACTION;
176: BEGIN
177:
178: IF G_DEBUG = 'Y' THEN
179: INV_MGD_POS_UTIL.Log
180: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
181: , p_msg => '> '||G_PKG_NAME||'.'||'Reserve_Data_Set_Name'
182: );
183: END IF;

Line 180: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

176: BEGIN
177:
178: IF G_DEBUG = 'Y' THEN
179: INV_MGD_POS_UTIL.Log
180: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
181: , p_msg => '> '||G_PKG_NAME||'.'||'Reserve_Data_Set_Name'
182: );
183: END IF;
184:

Line 221: INV_MGD_POS_UTIL.Log

217:
218: END IF;
219:
220: IF G_DEBUG = 'Y' THEN
221: INV_MGD_POS_UTIL.Log
222: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
223: , p_msg => '< '||G_PKG_NAME||'.'||'Reserve_Data_Set_Name'
224: );
225: END IF;

Line 222: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

218: END IF;
219:
220: IF G_DEBUG = 'Y' THEN
221: INV_MGD_POS_UTIL.Log
222: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
223: , p_msg => '< '||G_PKG_NAME||'.'||'Reserve_Data_Set_Name'
224: );
225: END IF;
226:

Line 245: INV_MGD_POS_UTIL.Log

241: PRAGMA AUTONOMOUS_TRANSACTION;
242: BEGIN
243:
244: IF G_DEBUG = 'Y' THEN
245: INV_MGD_POS_UTIL.Log
246: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
247: , p_msg => '> '||G_PKG_NAME||'.'||'Release_Data_Set_Name'
248: );
249: END IF;

Line 246: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

242: BEGIN
243:
244: IF G_DEBUG = 'Y' THEN
245: INV_MGD_POS_UTIL.Log
246: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
247: , p_msg => '> '||G_PKG_NAME||'.'||'Release_Data_Set_Name'
248: );
249: END IF;
250:

Line 259: INV_MGD_POS_UTIL.Log

255: AND inventory_item_id = -1;
256: COMMIT;
257:
258: IF G_DEBUG = 'Y' THEN
259: INV_MGD_POS_UTIL.Log
260: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
261: , p_msg => '< '||G_PKG_NAME||'.'||'Release_Data_Set_Name'
262: );
263: END IF;

Line 260: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

256: COMMIT;
257:
258: IF G_DEBUG = 'Y' THEN
259: INV_MGD_POS_UTIL.Log
260: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
261: , p_msg => '< '||G_PKG_NAME||'.'||'Release_Data_Set_Name'
262: );
263: END IF;
264:

Line 278: INV_MGD_POS_UTIL.Log

274: l_master_org_id NUMBER;
275: BEGIN
276:
277: IF G_DEBUG = 'Y' THEN
278: INV_MGD_POS_UTIL.Log
279: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
280: , p_msg => '> '||G_PKG_NAME||'.'||'Get_Master_Org'
281: );
282: END IF;

Line 279: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

275: BEGIN
276:
277: IF G_DEBUG = 'Y' THEN
278: INV_MGD_POS_UTIL.Log
279: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
280: , p_msg => '> '||G_PKG_NAME||'.'||'Get_Master_Org'
281: );
282: END IF;
283:

Line 290: INV_MGD_POS_UTIL.Log

286: FROM mtl_parameters
287: WHERE organization_id = p_hierarchy_level;
288:
289: IF G_DEBUG = 'Y' THEN
290: INV_MGD_POS_UTIL.Log
291: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
292: , p_msg => '< '||G_PKG_NAME||'.'||'Get_Master_Org'
293: );
294: END IF;

Line 291: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

287: WHERE organization_id = p_hierarchy_level;
288:
289: IF G_DEBUG = 'Y' THEN
290: INV_MGD_POS_UTIL.Log
291: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
292: , p_msg => '< '||G_PKG_NAME||'.'||'Get_Master_Org'
293: );
294: END IF;
295:

Line 328: INV_MGD_POS_UTIL.Log

324: AND organization_id_parent = p_organization_id;
325: BEGIN
326:
327: IF G_DEBUG = 'Y' THEN
328: INV_MGD_POS_UTIL.Log
329: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
330: , p_msg => '> '||G_PKG_NAME||'.'||'Get_Child_Organizations'
331: );
332: END IF;

Line 329: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

325: BEGIN
326:
327: IF G_DEBUG = 'Y' THEN
328: INV_MGD_POS_UTIL.Log
329: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
330: , p_msg => '> '||G_PKG_NAME||'.'||'Get_Child_Organizations'
331: );
332: END IF;
333:

Line 348: INV_MGD_POS_UTIL.Log

344:
345: CLOSE l_org_children_crsr;
346:
347: IF G_DEBUG = 'Y' THEN
348: INV_MGD_POS_UTIL.Log
349: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
350: , p_msg => '< '||G_PKG_NAME||'.'||'Get_Child_Organizations'
351: );
352: END IF;

Line 349: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

345: CLOSE l_org_children_crsr;
346:
347: IF G_DEBUG = 'Y' THEN
348: INV_MGD_POS_UTIL.Log
349: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
350: , p_msg => '< '||G_PKG_NAME||'.'||'Get_Child_Organizations'
351: );
352: END IF;
353:

Line 357: INV_MGD_POS_UTIL.Log

353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: IF G_DEBUG = 'Y' THEN
357: INV_MGD_POS_UTIL.Log
358: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
359: , p_msg => 'Exception: '||SQLERRM
360: );
361: END IF;

Line 358: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

354: EXCEPTION
355: WHEN OTHERS THEN
356: IF G_DEBUG = 'Y' THEN
357: INV_MGD_POS_UTIL.Log
358: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
359: , p_msg => 'Exception: '||SQLERRM
360: );
361: END IF;
362: IF l_org_children_crsr%ISOPEN THEN

Line 376: ( p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type

372: -- COMMENT : TRUE if all the organizations in p_child_organizations are
373: -- marked as completed in p_organization_tbl; FALSE otherwise
374: --========================================================================
375: FUNCTION All_Completed
376: ( p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type
377: , p_child_organizations IN g_organization_tbl_type
378: ) RETURN BOOLEAN
379: IS
380: l_completed BOOLEAN;

Line 384: INV_MGD_POS_UTIL.Log

380: l_completed BOOLEAN;
381: BEGIN
382:
383: IF G_DEBUG = 'Y' THEN
384: INV_MGD_POS_UTIL.Log
385: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
386: , p_msg => '> '||G_PKG_NAME||'.'||'All_Completed'
387: );
388: END IF;

Line 385: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

381: BEGIN
382:
383: IF G_DEBUG = 'Y' THEN
384: INV_MGD_POS_UTIL.Log
385: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
386: , p_msg => '> '||G_PKG_NAME||'.'||'All_Completed'
387: );
388: END IF;
389:

Line 406: INV_MGD_POS_UTIL.Log

402:
403: END LOOP;
404:
405: IF G_DEBUG = 'Y' THEN
406: INV_MGD_POS_UTIL.Log
407: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
408: , p_msg => '< '||G_PKG_NAME||'.'||'All_Completed'
409: );
410: END IF;

Line 407: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

403: END LOOP;
404:
405: IF G_DEBUG = 'Y' THEN
406: INV_MGD_POS_UTIL.Log
407: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
408: , p_msg => '< '||G_PKG_NAME||'.'||'All_Completed'
409: );
410: END IF;
411:

Line 442: INV_MGD_POS_UTIL.Log

438:
439: BEGIN
440:
441: IF G_DEBUG = 'Y' THEN
442: INV_MGD_POS_UTIL.Log
443: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
444: , p_msg => '> '||G_PKG_NAME||'.'||'Calc_Item_Begin_Qty'
445: );
446: END IF;

Line 443: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

439: BEGIN
440:
441: IF G_DEBUG = 'Y' THEN
442: INV_MGD_POS_UTIL.Log
443: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
444: , p_msg => '> '||G_PKG_NAME||'.'||'Calc_Item_Begin_Qty'
445: );
446: END IF;
447:

Line 473: INV_MGD_POS_UTIL.Log

469:
470: l_begin_qty := l_current_qty - l_rollback_qty;
471:
472: IF G_DEBUG = 'Y' THEN
473: INV_MGD_POS_UTIL.Log
474: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
475: , p_msg => 'l_begin_qty:'||TO_CHAR(l_begin_qty)
476: );
477: END IF;

Line 474: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

470: l_begin_qty := l_current_qty - l_rollback_qty;
471:
472: IF G_DEBUG = 'Y' THEN
473: INV_MGD_POS_UTIL.Log
474: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
475: , p_msg => 'l_begin_qty:'||TO_CHAR(l_begin_qty)
476: );
477: END IF;
478:

Line 482: INV_MGD_POS_UTIL.Log

478:
479: x_quantity := l_begin_qty;
480:
481: IF G_DEBUG = 'Y' THEN
482: INV_MGD_POS_UTIL.Log
483: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
484: , p_msg => '< '||G_PKG_NAME||'.'||'Calc_Item_Begin_Qty'
485: );
486: END IF;

Line 483: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

479: x_quantity := l_begin_qty;
480:
481: IF G_DEBUG = 'Y' THEN
482: INV_MGD_POS_UTIL.Log
483: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
484: , p_msg => '< '||G_PKG_NAME||'.'||'Calc_Item_Begin_Qty'
485: );
486: END IF;
487: END Calc_Item_Begin_Qty;

Line 504: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type

500: -- for the next bucket
501: --========================================================================
502: PROCEDURE Process_Bucket
503: ( p_context_rec IN g_context_rec_type
504: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type
505: , p_bucket_rec IN INV_MGD_POS_UTIL.bucket_rec_type
506: , p_begin_qty IN NUMBER
507: , x_end_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
508: )

Line 505: , p_bucket_rec IN INV_MGD_POS_UTIL.bucket_rec_type

501: --========================================================================
502: PROCEDURE Process_Bucket
503: ( p_context_rec IN g_context_rec_type
504: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type
505: , p_bucket_rec IN INV_MGD_POS_UTIL.bucket_rec_type
506: , p_begin_qty IN NUMBER
507: , x_end_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
508: )
509: IS

Line 515: INV_MGD_POS_UTIL.Log

511: l_org_issued_qty NUMBER;
512: BEGIN
513:
514: IF G_DEBUG = 'Y' THEN
515: INV_MGD_POS_UTIL.Log
516: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
517: , p_msg => '> '||G_PKG_NAME||'.'||'Process_Bucket'
518: );
519: END IF;

Line 516: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

512: BEGIN
513:
514: IF G_DEBUG = 'Y' THEN
515: INV_MGD_POS_UTIL.Log
516: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
517: , p_msg => '> '||G_PKG_NAME||'.'||'Process_Bucket'
518: );
519: END IF;
520:

Line 576: INV_MGD_POS_UTIL.Log

572:
573: x_end_qty := NVL(p_begin_qty,0) + l_org_received_qty - l_org_issued_qty;
574:
575: IF G_DEBUG = 'Y' THEN
576: INV_MGD_POS_UTIL.Log
577: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
578: , p_msg => '< '||G_PKG_NAME||'.'||'Process_Bucket'
579: );
580: END IF;

Line 577: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

573: x_end_qty := NVL(p_begin_qty,0) + l_org_received_qty - l_org_issued_qty;
574:
575: IF G_DEBUG = 'Y' THEN
576: INV_MGD_POS_UTIL.Log
577: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
578: , p_msg => '< '||G_PKG_NAME||'.'||'Process_Bucket'
579: );
580: END IF;
581: END Process_Bucket;

Line 594: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type

590: -- across the list of buckets
591: --========================================================================
592: PROCEDURE Calc_Org_Level_Info
593: ( p_context_rec IN g_context_rec_type
594: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type
595: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type
596: )
597: IS
598: l_begin_qty NUMBER;

Line 595: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type

591: --========================================================================
592: PROCEDURE Calc_Org_Level_Info
593: ( p_context_rec IN g_context_rec_type
594: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type
595: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type
596: )
597: IS
598: l_begin_qty NUMBER;
599:

Line 605: INV_MGD_POS_UTIL.Log

601: l_end_qty NUMBER;
602: BEGIN
603:
604: IF G_DEBUG = 'Y' THEN
605: INV_MGD_POS_UTIL.Log
606: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
607: , p_msg => '> '||G_PKG_NAME||'.'||'Calc_Org_Level_Info'
608: );
609: END IF;

Line 606: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

602: BEGIN
603:
604: IF G_DEBUG = 'Y' THEN
605: INV_MGD_POS_UTIL.Log
606: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
607: , p_msg => '> '||G_PKG_NAME||'.'||'Calc_Org_Level_Info'
608: );
609: END IF;
610:

Line 619: INV_MGD_POS_UTIL.Log

615: , x_quantity => l_begin_qty
616: );
617:
618: IF G_DEBUG = 'Y' THEN
619: INV_MGD_POS_UTIL.Log
620: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
621: , p_msg => 'Looping on buckets'
622: );
623: END IF;

Line 620: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

616: );
617:
618: IF G_DEBUG = 'Y' THEN
619: INV_MGD_POS_UTIL.Log
620: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
621: , p_msg => 'Looping on buckets'
622: );
623: END IF;
624: FOR l_Idx IN 1..p_bucket_tbl.COUNT

Line 627: INV_MGD_POS_UTIL.Log

623: END IF;
624: FOR l_Idx IN 1..p_bucket_tbl.COUNT
625: LOOP
626: IF G_DEBUG = 'Y' THEN
627: INV_MGD_POS_UTIL.Log
628: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
629: , p_msg => 'Bucket: '||p_bucket_tbl(l_Idx).name
630: );
631: END IF;

Line 628: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

624: FOR l_Idx IN 1..p_bucket_tbl.COUNT
625: LOOP
626: IF G_DEBUG = 'Y' THEN
627: INV_MGD_POS_UTIL.Log
628: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
629: , p_msg => 'Bucket: '||p_bucket_tbl(l_Idx).name
630: );
631: END IF;
632:

Line 645: INV_MGD_POS_UTIL.Log

641: l_begin_qty := l_end_qty;
642: END LOOP;
643:
644: IF G_DEBUG = 'Y' THEN
645: INV_MGD_POS_UTIL.Log
646: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
647: , p_msg => '< '||G_PKG_NAME||'.'||'Calc_Org_Level_Info'
648: );
649: END IF;

Line 646: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

642: END LOOP;
643:
644: IF G_DEBUG = 'Y' THEN
645: INV_MGD_POS_UTIL.Log
646: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
647: , p_msg => '< '||G_PKG_NAME||'.'||'Calc_Org_Level_Info'
648: );
649: END IF;
650:

Line 667: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type

663: PROCEDURE Get_Hierarchy_Level_Data
664: ( p_context_rec IN g_context_rec_type
665: , p_organization_id IN NUMBER
666: , p_child_organizations IN g_organization_tbl_type
667: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type
668: , p_bucket_rec IN INV_MGD_POS_UTIL.bucket_rec_type
669: , x_hier_delta_qty OUT NOCOPY NUMBER
670: , x_hier_end_on_hand_qty OUT NOCOPY NUMBER
671: )

Line 668: , p_bucket_rec IN INV_MGD_POS_UTIL.bucket_rec_type

664: ( p_context_rec IN g_context_rec_type
665: , p_organization_id IN NUMBER
666: , p_child_organizations IN g_organization_tbl_type
667: , p_item_rec IN INV_MGD_POS_UTIL.item_rec_type
668: , p_bucket_rec IN INV_MGD_POS_UTIL.bucket_rec_type
669: , x_hier_delta_qty OUT NOCOPY NUMBER
670: , x_hier_end_on_hand_qty OUT NOCOPY NUMBER
671: )
672: IS

Line 716: INV_MGD_POS_UTIL.Log

712: AND inventory_item_id = p_inventory_item_id;
713: BEGIN
714:
715: IF G_DEBUG = 'Y' THEN
716: INV_MGD_POS_UTIL.Log
717: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
718: , p_msg => '> '||G_PKG_NAME||'.'||'Get_Hierarchy_Level_Data'
719: );
720: END IF;

Line 717: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

713: BEGIN
714:
715: IF G_DEBUG = 'Y' THEN
716: INV_MGD_POS_UTIL.Log
717: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
718: , p_msg => '> '||G_PKG_NAME||'.'||'Get_Hierarchy_Level_Data'
719: );
720: END IF;
721:

Line 736: INV_MGD_POS_UTIL.Log

732: END IF;
733: CLOSE l_org_data_crsr;
734:
735: IF G_DEBUG = 'Y' THEN
736: INV_MGD_POS_UTIL.Log
737: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
738: , p_msg => 'hierarchy origin on hand qty :'||l_old_on_hand_qty
739: );
740: END IF;

Line 737: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

733: CLOSE l_org_data_crsr;
734:
735: IF G_DEBUG = 'Y' THEN
736: INV_MGD_POS_UTIL.Log
737: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
738: , p_msg => 'hierarchy origin on hand qty :'||l_old_on_hand_qty
739: );
740: END IF;
741:

Line 763: INV_MGD_POS_UTIL.Log

759: Get_Child_Organizations(p_context_rec,p_child_organizations(l_Idx), l_child_organization);
760:
761: IF (l_child_organization IS NOT NULL AND l_child_organization.COUNT > 0)THEN
762: IF G_DEBUG = 'Y' THEN
763: INV_MGD_POS_UTIL.Log
764: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
765: , p_msg => 'child org Id : '||p_child_organizations(l_Idx)
766: );
767: INV_MGD_POS_UTIL.Log

Line 764: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

760:
761: IF (l_child_organization IS NOT NULL AND l_child_organization.COUNT > 0)THEN
762: IF G_DEBUG = 'Y' THEN
763: INV_MGD_POS_UTIL.Log
764: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
765: , p_msg => 'child org Id : '||p_child_organizations(l_Idx)
766: );
767: INV_MGD_POS_UTIL.Log
768: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

Line 767: INV_MGD_POS_UTIL.Log

763: INV_MGD_POS_UTIL.Log
764: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
765: , p_msg => 'child org Id : '||p_child_organizations(l_Idx)
766: );
767: INV_MGD_POS_UTIL.Log
768: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
769: , p_msg => 'Number of children : '||l_child_organization.COUNT
770: );
771: END IF ;

Line 768: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

764: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
765: , p_msg => 'child org Id : '||p_child_organizations(l_Idx)
766: );
767: INV_MGD_POS_UTIL.Log
768: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
769: , p_msg => 'Number of children : '||l_child_organization.COUNT
770: );
771: END IF ;
772: FOR l_index IN 1..l_child_organization.COUNT

Line 775: INV_MGD_POS_UTIL.Log

771: END IF ;
772: FOR l_index IN 1..l_child_organization.COUNT
773: LOOP
774: IF G_DEBUG = 'Y' THEN
775: INV_MGD_POS_UTIL.Log
776: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
777: , p_msg => 'Sub child organization Id :'||l_child_organization(l_index)
778: );
779: END IF;

Line 776: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

772: FOR l_index IN 1..l_child_organization.COUNT
773: LOOP
774: IF G_DEBUG = 'Y' THEN
775: INV_MGD_POS_UTIL.Log
776: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
777: , p_msg => 'Sub child organization Id :'||l_child_organization(l_index)
778: );
779: END IF;
780: Get_Child_Organizations(p_context_rec,l_child_organization(l_index), l_sub_child_organization);

Line 787: INV_MGD_POS_UTIL.Log

783:
784: l_delta_qty := l_delta_qty + l_sub_delta_qty;
785: l_on_hand_qty := l_on_hand_qty + l_sub_on_hand_qty;
786: IF G_DEBUG = 'Y' THEN
787: INV_MGD_POS_UTIL.Log
788: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
789: , p_msg => 'Delta Qty:'||l_delta_qty
790: );
791: INV_MGD_POS_UTIL.Log

Line 788: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

784: l_delta_qty := l_delta_qty + l_sub_delta_qty;
785: l_on_hand_qty := l_on_hand_qty + l_sub_on_hand_qty;
786: IF G_DEBUG = 'Y' THEN
787: INV_MGD_POS_UTIL.Log
788: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
789: , p_msg => 'Delta Qty:'||l_delta_qty
790: );
791: INV_MGD_POS_UTIL.Log
792: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

Line 791: INV_MGD_POS_UTIL.Log

787: INV_MGD_POS_UTIL.Log
788: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
789: , p_msg => 'Delta Qty:'||l_delta_qty
790: );
791: INV_MGD_POS_UTIL.Log
792: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
793: , p_msg => 'Onhand Qty :'||l_on_hand_qty
794: );
795: INV_MGD_POS_UTIL.Log

Line 792: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

788: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
789: , p_msg => 'Delta Qty:'||l_delta_qty
790: );
791: INV_MGD_POS_UTIL.Log
792: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
793: , p_msg => 'Onhand Qty :'||l_on_hand_qty
794: );
795: INV_MGD_POS_UTIL.Log
796: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

Line 795: INV_MGD_POS_UTIL.Log

791: INV_MGD_POS_UTIL.Log
792: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
793: , p_msg => 'Onhand Qty :'||l_on_hand_qty
794: );
795: INV_MGD_POS_UTIL.Log
796: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
797: , p_msg => 'Sub Delta Qty :'||l_sub_delta_qty
798: );
799: INV_MGD_POS_UTIL.Log

Line 796: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

792: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
793: , p_msg => 'Onhand Qty :'||l_on_hand_qty
794: );
795: INV_MGD_POS_UTIL.Log
796: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
797: , p_msg => 'Sub Delta Qty :'||l_sub_delta_qty
798: );
799: INV_MGD_POS_UTIL.Log
800: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

Line 799: INV_MGD_POS_UTIL.Log

795: INV_MGD_POS_UTIL.Log
796: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
797: , p_msg => 'Sub Delta Qty :'||l_sub_delta_qty
798: );
799: INV_MGD_POS_UTIL.Log
800: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
801: , p_msg => 'Sub Onhand Qty :'||l_sub_on_hand_qty
802: );
803: END IF;

Line 800: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

796: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
797: , p_msg => 'Sub Delta Qty :'||l_sub_delta_qty
798: );
799: INV_MGD_POS_UTIL.Log
800: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
801: , p_msg => 'Sub Onhand Qty :'||l_sub_on_hand_qty
802: );
803: END IF;
804: END LOOP;

Line 811: INV_MGD_POS_UTIL.Log

807: END IF;
808: CLOSE l_hier_data_crsr;
809:
810: IF G_DEBUG = 'Y' THEN
811: INV_MGD_POS_UTIL.Log
812: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
813: , p_msg => 'child org on hand qty :'||l_on_hand_qty
814: );
815: END IF;

Line 812: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

808: CLOSE l_hier_data_crsr;
809:
810: IF G_DEBUG = 'Y' THEN
811: INV_MGD_POS_UTIL.Log
812: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
813: , p_msg => 'child org on hand qty :'||l_on_hand_qty
814: );
815: END IF;
816:

Line 823: INV_MGD_POS_UTIL.Log

819:
820: END LOOP;
821:
822: IF G_DEBUG = 'Y' THEN
823: INV_MGD_POS_UTIL.Log
824: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
825: , p_msg => 'hierarchy on hand qty :'||l_old_on_hand_qty
826: );
827: END IF;

Line 824: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

820: END LOOP;
821:
822: IF G_DEBUG = 'Y' THEN
823: INV_MGD_POS_UTIL.Log
824: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
825: , p_msg => 'hierarchy on hand qty :'||l_old_on_hand_qty
826: );
827: END IF;
828:

Line 833: INV_MGD_POS_UTIL.Log

829: x_hier_delta_qty := l_old_delta_qty;
830: x_hier_end_on_hand_qty := l_old_on_hand_qty;
831:
832: IF G_DEBUG = 'Y' THEN
833: INV_MGD_POS_UTIL.Log
834: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
835: , p_msg => '< '||G_PKG_NAME||'.'||'Get_Hierarchy_Level_Data'
836: );
837: END IF;

Line 834: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

830: x_hier_end_on_hand_qty := l_old_on_hand_qty;
831:
832: IF G_DEBUG = 'Y' THEN
833: INV_MGD_POS_UTIL.Log
834: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
835: , p_msg => '< '||G_PKG_NAME||'.'||'Get_Hierarchy_Level_Data'
836: );
837: END IF;
838:

Line 842: INV_MGD_POS_UTIL.Log

838:
839: EXCEPTION
840: WHEN OTHERS THEN
841: IF G_DEBUG = 'Y' THEN
842: INV_MGD_POS_UTIL.Log
843: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
844: , p_msg => 'Exception: '||SQLERRM
845: );
846: END IF;

Line 843: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

839: EXCEPTION
840: WHEN OTHERS THEN
841: IF G_DEBUG = 'Y' THEN
842: INV_MGD_POS_UTIL.Log
843: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
844: , p_msg => 'Exception: '||SQLERRM
845: );
846: END IF;
847: IF l_org_data_crsr%ISOPEN THEN

Line 868: , p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type

864: -- COMMENT : calculates the hierarchy level data for a given organization
865: --========================================================================
866: PROCEDURE Calc_Hier_Level_Info
867: ( p_context_rec IN g_context_rec_type
868: , p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type
869: , p_organization_idx IN NUMBER
870: , p_item_tbl IN INV_MGD_POS_UTIL.item_tbl_type
871: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type
872: , x_completed_flag OUT NOCOPY /* file.sql.39 change */ BOOLEAN

Line 870: , p_item_tbl IN INV_MGD_POS_UTIL.item_tbl_type

866: PROCEDURE Calc_Hier_Level_Info
867: ( p_context_rec IN g_context_rec_type
868: , p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type
869: , p_organization_idx IN NUMBER
870: , p_item_tbl IN INV_MGD_POS_UTIL.item_tbl_type
871: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type
872: , x_completed_flag OUT NOCOPY /* file.sql.39 change */ BOOLEAN
873: )
874: IS

Line 871: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type

867: ( p_context_rec IN g_context_rec_type
868: , p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type
869: , p_organization_idx IN NUMBER
870: , p_item_tbl IN INV_MGD_POS_UTIL.item_tbl_type
871: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type
872: , x_completed_flag OUT NOCOPY /* file.sql.39 change */ BOOLEAN
873: )
874: IS
875: l_child_org_tbl g_organization_tbl_type;

Line 881: INV_MGD_POS_UTIL.Log

877: l_end_on_hand_qty NUMBER;
878: BEGIN
879:
880: IF G_DEBUG = 'Y' THEN
881: INV_MGD_POS_UTIL.Log
882: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
883: , p_msg => '> '||G_PKG_NAME||'.'||'Calc_Hier_Level_Info'
884: );
885: END IF;

Line 882: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

878: BEGIN
879:
880: IF G_DEBUG = 'Y' THEN
881: INV_MGD_POS_UTIL.Log
882: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
883: , p_msg => '> '||G_PKG_NAME||'.'||'Calc_Hier_Level_Info'
884: );
885: END IF;
886:

Line 903: INV_MGD_POS_UTIL.Log

899: FOR l_itm_Idx IN 1..p_item_tbl.COUNT
900: LOOP
901:
902: IF G_DEBUG = 'Y' THEN
903: INV_MGD_POS_UTIL.Log
904: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
905: , p_msg => 'itm_idx: '||l_itm_idx
906: );
907: END IF;

Line 904: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

900: LOOP
901:
902: IF G_DEBUG = 'Y' THEN
903: INV_MGD_POS_UTIL.Log
904: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
905: , p_msg => 'itm_idx: '||l_itm_idx
906: );
907: END IF;
908:

Line 914: INV_MGD_POS_UTIL.Log

910: p_organization_tbl(p_organization_idx).id
911: THEN
912:
913: IF G_DEBUG = 'Y' THEN
914: INV_MGD_POS_UTIL.Log
915: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
916: , p_msg => 'item: '||p_item_tbl(l_itm_idx).item_id
917: );
918: END IF;

Line 915: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

911: THEN
912:
913: IF G_DEBUG = 'Y' THEN
914: INV_MGD_POS_UTIL.Log
915: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
916: , p_msg => 'item: '||p_item_tbl(l_itm_idx).item_id
917: );
918: END IF;
919:

Line 926: INV_MGD_POS_UTIL.Log

922: FOR l_Bkt_Idx IN 1..p_bucket_tbl.COUNT
923: LOOP
924:
925: IF G_DEBUG = 'Y' THEN
926: INV_MGD_POS_UTIL.Log
927: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
928: , p_msg => 'bucket: '||p_bucket_tbl(l_bkt_idx).name
929: );
930: END IF;

Line 927: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

923: LOOP
924:
925: IF G_DEBUG = 'Y' THEN
926: INV_MGD_POS_UTIL.Log
927: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
928: , p_msg => 'bucket: '||p_bucket_tbl(l_bkt_idx).name
929: );
930: END IF;
931:

Line 943: INV_MGD_POS_UTIL.Log

939: , x_hier_end_on_hand_qty => l_end_on_hand_qty
940: );
941:
942: IF G_DEBUG = 'Y' THEN
943: INV_MGD_POS_UTIL.Log
944: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
945: , p_msg => 'delta qty: '||l_delta_qty
946: );
947: INV_MGD_POS_UTIL.Log

Line 944: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

940: );
941:
942: IF G_DEBUG = 'Y' THEN
943: INV_MGD_POS_UTIL.Log
944: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
945: , p_msg => 'delta qty: '||l_delta_qty
946: );
947: INV_MGD_POS_UTIL.Log
948: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

Line 947: INV_MGD_POS_UTIL.Log

943: INV_MGD_POS_UTIL.Log
944: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
945: , p_msg => 'delta qty: '||l_delta_qty
946: );
947: INV_MGD_POS_UTIL.Log
948: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
949: , p_msg => 'end on hand qty: '||l_end_on_hand_qty
950: );
951: END IF;

Line 948: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

944: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
945: , p_msg => 'delta qty: '||l_delta_qty
946: );
947: INV_MGD_POS_UTIL.Log
948: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
949: , p_msg => 'end on hand qty: '||l_end_on_hand_qty
950: );
951: END IF;
952:

Line 977: INV_MGD_POS_UTIL.Log

973:
974: END IF;
975:
976: IF G_DEBUG = 'Y' THEN
977: INV_MGD_POS_UTIL.Log
978: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
979: , p_msg => '< '||G_PKG_NAME||'.'||'Calc_Hier_Level_Info'
980: );
981: END IF;

Line 978: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

974: END IF;
975:
976: IF G_DEBUG = 'Y' THEN
977: INV_MGD_POS_UTIL.Log
978: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
979: , p_msg => '< '||G_PKG_NAME||'.'||'Calc_Hier_Level_Info'
980: );
981: END IF;
982:

Line 996: , x_organization_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.organization_tbl_type

992: -- data set in the temporary table
993: --========================================================================
994: PROCEDURE Fetch_Data
995: ( p_context_rec IN g_context_rec_type
996: , x_organization_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.organization_tbl_type
997: , p_item_tbl IN INV_MGD_POS_UTIL.item_tbl_type
998: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type
999: )
1000: IS

Line 997: , p_item_tbl IN INV_MGD_POS_UTIL.item_tbl_type

993: --========================================================================
994: PROCEDURE Fetch_Data
995: ( p_context_rec IN g_context_rec_type
996: , x_organization_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.organization_tbl_type
997: , p_item_tbl IN INV_MGD_POS_UTIL.item_tbl_type
998: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type
999: )
1000: IS
1001: l_all_org_completed BOOLEAN;

Line 998: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type

994: PROCEDURE Fetch_Data
995: ( p_context_rec IN g_context_rec_type
996: , x_organization_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.organization_tbl_type
997: , p_item_tbl IN INV_MGD_POS_UTIL.item_tbl_type
998: , p_bucket_tbl IN INV_MGD_POS_UTIL.bucket_tbl_type
999: )
1000: IS
1001: l_all_org_completed BOOLEAN;
1002: BEGIN

Line 1005: INV_MGD_POS_UTIL.Log

1001: l_all_org_completed BOOLEAN;
1002: BEGIN
1003:
1004: IF G_DEBUG = 'Y' THEN
1005: INV_MGD_POS_UTIL.Log
1006: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1007: , p_msg => '> '||G_PKG_NAME||'.'||'Fetch_Data'
1008: );
1009:

Line 1006: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

1002: BEGIN
1003:
1004: IF G_DEBUG = 'Y' THEN
1005: INV_MGD_POS_UTIL.Log
1006: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1007: , p_msg => '> '||G_PKG_NAME||'.'||'Fetch_Data'
1008: );
1009:
1010: INV_MGD_POS_UTIL.Log

Line 1010: INV_MGD_POS_UTIL.Log

1006: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1007: , p_msg => '> '||G_PKG_NAME||'.'||'Fetch_Data'
1008: );
1009:
1010: INV_MGD_POS_UTIL.Log
1011: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1012: , p_msg => 'Looping on items'
1013: );
1014: END IF;

Line 1011: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

1007: , p_msg => '> '||G_PKG_NAME||'.'||'Fetch_Data'
1008: );
1009:
1010: INV_MGD_POS_UTIL.Log
1011: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1012: , p_msg => 'Looping on items'
1013: );
1014: END IF;
1015:

Line 1020: INV_MGD_POS_UTIL.Log

1016: FOR l_Idx IN 1..p_item_tbl.COUNT
1017: LOOP
1018:
1019: IF G_DEBUG = 'Y' THEN
1020: INV_MGD_POS_UTIL.Log
1021: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1022: , p_msg => 'item '||p_item_tbl(l_Idx).item_id ||
1023: ' org '||p_item_tbl(l_Idx).organization_id
1024: );

Line 1021: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

1017: LOOP
1018:
1019: IF G_DEBUG = 'Y' THEN
1020: INV_MGD_POS_UTIL.Log
1021: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1022: , p_msg => 'item '||p_item_tbl(l_Idx).item_id ||
1023: ' org '||p_item_tbl(l_Idx).organization_id
1024: );
1025: END IF;

Line 1036: INV_MGD_POS_UTIL.Log

1032:
1033: END LOOP;
1034:
1035: IF G_DEBUG = 'Y' THEN
1036: INV_MGD_POS_UTIL.Log
1037: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1038: , p_msg => 'Looping while orgs are not completed'
1039: );
1040: END IF;

Line 1037: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

1033: END LOOP;
1034:
1035: IF G_DEBUG = 'Y' THEN
1036: INV_MGD_POS_UTIL.Log
1037: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1038: , p_msg => 'Looping while orgs are not completed'
1039: );
1040: END IF;
1041: LOOP

Line 1046: INV_MGD_POS_UTIL.Log

1042:
1043: l_all_org_completed := TRUE;
1044:
1045: IF G_DEBUG = 'Y' THEN
1046: INV_MGD_POS_UTIL.Log
1047: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1048: , p_msg => 'Looping on organizations'
1049: );
1050: END IF;

Line 1047: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

1043: l_all_org_completed := TRUE;
1044:
1045: IF G_DEBUG = 'Y' THEN
1046: INV_MGD_POS_UTIL.Log
1047: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1048: , p_msg => 'Looping on organizations'
1049: );
1050: END IF;
1051: FOR l_Idx IN 1..x_organization_tbl.COUNT

Line 1054: INV_MGD_POS_UTIL.Log

1050: END IF;
1051: FOR l_Idx IN 1..x_organization_tbl.COUNT
1052: LOOP
1053: IF G_DEBUG = 'Y' THEN
1054: INV_MGD_POS_UTIL.Log
1055: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1056: , p_msg => 'org: '||x_organization_tbl(l_Idx).id
1057: );
1058: END IF;

Line 1055: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT

1051: FOR l_Idx IN 1..x_organization_tbl.COUNT
1052: LOOP
1053: IF G_DEBUG = 'Y' THEN
1054: INV_MGD_POS_UTIL.Log
1055: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
1056: , p_msg => 'org: '||x_organization_tbl(l_Idx).id
1057: );
1058: END IF;
1059: IF NOT x_organization_tbl(l_Idx).complete_flag THEN

Line 1081: INV_MGD_POS_UTIL.Log

1077:
1078: END LOOP;
1079:
1080: IF G_DEBUG = 'Y' THEN
1081: INV_MGD_POS_UTIL.Log
1082: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1083: , p_msg => '< '||G_PKG_NAME||'.'||'Fetch_Data'
1084: );
1085: END IF;

Line 1082: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

1078: END LOOP;
1079:
1080: IF G_DEBUG = 'Y' THEN
1081: INV_MGD_POS_UTIL.Log
1082: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1083: , p_msg => '< '||G_PKG_NAME||'.'||'Fetch_Data'
1084: );
1085: END IF;
1086:

Line 1129: l_organization_tbl INV_MGD_POS_UTIL.organization_tbl_type;

1125: l_api_name CONSTANT VARCHAR2(30):= 'Build';
1126: l_return_status VARCHAR2(1);
1127: l_master_org_id NUMBER;
1128: l_context_rec g_context_rec_type;
1129: l_organization_tbl INV_MGD_POS_UTIL.organization_tbl_type;
1130: l_item_tbl INV_MGD_POS_UTIL.item_tbl_type;
1131: l_bucket_tbl INV_MGD_POS_UTIL.bucket_tbl_type;
1132: l_dupl_data_set_name EXCEPTION;
1133: l_empty_data_set EXCEPTION;

Line 1130: l_item_tbl INV_MGD_POS_UTIL.item_tbl_type;

1126: l_return_status VARCHAR2(1);
1127: l_master_org_id NUMBER;
1128: l_context_rec g_context_rec_type;
1129: l_organization_tbl INV_MGD_POS_UTIL.organization_tbl_type;
1130: l_item_tbl INV_MGD_POS_UTIL.item_tbl_type;
1131: l_bucket_tbl INV_MGD_POS_UTIL.bucket_tbl_type;
1132: l_dupl_data_set_name EXCEPTION;
1133: l_empty_data_set EXCEPTION;
1134:

Line 1131: l_bucket_tbl INV_MGD_POS_UTIL.bucket_tbl_type;

1127: l_master_org_id NUMBER;
1128: l_context_rec g_context_rec_type;
1129: l_organization_tbl INV_MGD_POS_UTIL.organization_tbl_type;
1130: l_item_tbl INV_MGD_POS_UTIL.item_tbl_type;
1131: l_bucket_tbl INV_MGD_POS_UTIL.bucket_tbl_type;
1132: l_dupl_data_set_name EXCEPTION;
1133: l_empty_data_set EXCEPTION;
1134:
1135: BEGIN

Line 1138: INV_MGD_POS_UTIL.Log

1134:
1135: BEGIN
1136:
1137: IF G_DEBUG = 'Y' THEN
1138: INV_MGD_POS_UTIL.Log
1139: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1140: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
1141: );
1142: END IF;

Line 1139: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

1135: BEGIN
1136:
1137: IF G_DEBUG = 'Y' THEN
1138: INV_MGD_POS_UTIL.Log
1139: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1140: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
1141: );
1142: END IF;
1143:

Line 1224: INV_MGD_POS_UTIL.Log

1220: );
1221:
1222: -- calculate hierarchy level information
1223: IF G_DEBUG = 'Y' THEN
1224: INV_MGD_POS_UTIL.Log
1225: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1226: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
1227: );
1228: END IF;

Line 1225: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

1221:
1222: -- calculate hierarchy level information
1223: IF G_DEBUG = 'Y' THEN
1224: INV_MGD_POS_UTIL.Log
1225: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1226: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
1227: );
1228: END IF;
1229:

Line 1327: INV_MGD_POS_UTIL.Log

1323:
1324: BEGIN
1325:
1326: IF G_DEBUG = 'Y' THEN
1327: INV_MGD_POS_UTIL.Log
1328: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1329: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
1330: );
1331: END IF;

Line 1328: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

1324: BEGIN
1325:
1326: IF G_DEBUG = 'Y' THEN
1327: INV_MGD_POS_UTIL.Log
1328: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1329: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
1330: );
1331: END IF;
1332:

Line 1356: INV_MGD_POS_UTIL.Log

1352: , p_data => x_msg_data
1353: );
1354:
1355: IF G_DEBUG = 'Y' THEN
1356: INV_MGD_POS_UTIL.Log
1357: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1358: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
1359: );
1360: END IF;

Line 1357: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE

1353: );
1354:
1355: IF G_DEBUG = 'Y' THEN
1356: INV_MGD_POS_UTIL.Log
1357: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
1358: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
1359: );
1360: END IF;
1361: