APPS.INV_ITEM_ORG_ASSIGN_CP dependencies on INV_ORGHIERARCHY_PVT

Line 91: -- PARAMETERS: p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type

87: --===================
88:
89: -- ==========================================================================
90: -- PROCEDURE : validate_gl_account PRIVATE
91: -- PARAMETERS: p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type
92: -- Organization List of the Hierarchy and Origin
93: --
94: -- x_valid_org_tbl OUT INV_OrgHierarchy_PVT.OrgID_tbl_type
95: -- Shortened Organization List containing only valid organizations

Line 94: -- x_valid_org_tbl OUT INV_OrgHierarchy_PVT.OrgID_tbl_type

90: -- PROCEDURE : validate_gl_account PRIVATE
91: -- PARAMETERS: p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type
92: -- Organization List of the Hierarchy and Origin
93: --
94: -- x_valid_org_tbl OUT INV_OrgHierarchy_PVT.OrgID_tbl_type
95: -- Shortened Organization List containing only valid organizations
96: --
97: -- COMMENT : Validate GL account info against GL_CODE_COMBINATIONS for each
98: -- organization in the Organization List

Line 105: (p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type

101: -- Otherwise, set to 'N' for NOT a valid code combination
102: -- Short list the organization list only for valid organizations
103: -- =====================================================================
104: PROCEDURE validate_gl_account
105: (p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type
106: ,x_valid_org_tbl OUT NOCOPY INV_OrgHierarchy_PVT.OrgID_tbl_type
107: )
108: IS
109:

Line 106: ,x_valid_org_tbl OUT NOCOPY INV_OrgHierarchy_PVT.OrgID_tbl_type

102: -- Short list the organization list only for valid organizations
103: -- =====================================================================
104: PROCEDURE validate_gl_account
105: (p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type
106: ,x_valid_org_tbl OUT NOCOPY INV_OrgHierarchy_PVT.OrgID_tbl_type
107: )
108: IS
109:
110: -- Get Chart of Accounts Id for the organization

Line 148: INV_ORGHIERARCHY_PVT.Log

144:
145: BEGIN
146:
147: IF G_DEBUG = 'Y' THEN
148: INV_ORGHIERARCHY_PVT.Log
149: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
150: , '> validate_gl_account'
151: );
152: END IF;

Line 149: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

145: BEGIN
146:
147: IF G_DEBUG = 'Y' THEN
148: INV_ORGHIERARCHY_PVT.Log
149: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
150: , '> validate_gl_account'
151: );
152: END IF;
153:

Line 190: INV_ORGHIERARCHY_PVT.Log

186: l_valid_flag := 'Y';
187: ELSE
188: l_valid_flag := 'N';
189: IF G_DEBUG = 'Y' THEN
190: INV_ORGHIERARCHY_PVT.Log
191: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
192: ,'Cost of Sales Account NOT valid for organization Id:' || l_organization_id
193: );
194: END IF;

Line 191: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR

187: ELSE
188: l_valid_flag := 'N';
189: IF G_DEBUG = 'Y' THEN
190: INV_ORGHIERARCHY_PVT.Log
191: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
192: ,'Cost of Sales Account NOT valid for organization Id:' || l_organization_id
193: );
194: END IF;
195: END IF;

Line 219: INV_ORGHIERARCHY_PVT.Log

215: l_valid_flag := 'Y';
216: ELSE
217: l_valid_flag := 'N';
218: IF G_DEBUG = 'Y' THEN
219: INV_ORGHIERARCHY_PVT.Log
220: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
221: ,'Encumbrance Account NOT valid for organization Id:' || l_organization_id
222: );
223: END IF;

Line 220: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR

216: ELSE
217: l_valid_flag := 'N';
218: IF G_DEBUG = 'Y' THEN
219: INV_ORGHIERARCHY_PVT.Log
220: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
221: ,'Encumbrance Account NOT valid for organization Id:' || l_organization_id
222: );
223: END IF;
224: END IF;

Line 251: INV_ORGHIERARCHY_PVT.Log

247: l_valid_flag := 'Y';
248: ELSE
249: l_valid_flag := 'N';
250: IF G_DEBUG = 'Y' THEN
251: INV_ORGHIERARCHY_PVT.Log
252: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
253: ,'Sales Account NOT valid for organization Id:' || l_organization_id
254: );
255: END IF;

Line 252: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR

248: ELSE
249: l_valid_flag := 'N';
250: IF G_DEBUG = 'Y' THEN
251: INV_ORGHIERARCHY_PVT.Log
252: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
253: ,'Sales Account NOT valid for organization Id:' || l_organization_id
254: );
255: END IF;
256: END IF;

Line 281: INV_ORGHIERARCHY_PVT.Log

277: l_valid_flag := 'Y';
278: ELSE
279: l_valid_flag := 'N';
280: IF G_DEBUG = 'Y' THEN
281: INV_ORGHIERARCHY_PVT.Log
282: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
283: ,'Expense Account NOT valid for organization Id:' || l_organization_id
284: );
285: END IF;

Line 282: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR

278: ELSE
279: l_valid_flag := 'N';
280: IF G_DEBUG = 'Y' THEN
281: INV_ORGHIERARCHY_PVT.Log
282: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
283: ,'Expense Account NOT valid for organization Id:' || l_organization_id
284: );
285: END IF;
286: END IF;

Line 300: INV_ORGHIERARCHY_PVT.Log

296: G_ORG_GL_REV_TBL(l_organization_id_idx).valid_flag := l_valid_flag;
297:
298: IF G_DEBUG = 'Y' THEN
299: IF l_valid_flag = 'Y' THEN
300: INV_ORGHIERARCHY_PVT.Log
301: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
302: , 'GL Account Info Valid for the organization Id:' || l_organization_id
303: );
304: END IF;

Line 301: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

297:
298: IF G_DEBUG = 'Y' THEN
299: IF l_valid_flag = 'Y' THEN
300: INV_ORGHIERARCHY_PVT.Log
301: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
302: , 'GL Account Info Valid for the organization Id:' || l_organization_id
303: );
304: END IF;
305: END IF;

Line 318: INV_ORGHIERARCHY_PVT.Log

314:
315: END LOOP;
316:
317: IF G_DEBUG = 'Y' THEN
318: INV_ORGHIERARCHY_PVT.Log
319: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
320: , '< validate_gl_account'
321: );
322: END IF;

Line 319: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

315: END LOOP;
316:
317: IF G_DEBUG = 'Y' THEN
318: INV_ORGHIERARCHY_PVT.Log
319: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
320: , '< validate_gl_account'
321: );
322: END IF;
323:

Line 329: -- PARAMETERS: p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type

325:
326:
327: -- ====================================================================
328: -- PROCEDURE : Retrieve_gl_rev PRIVATE
329: -- PARAMETERS: p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type
330: -- COMMENT : Retrieve GL Account Info and starting revision for each
331: -- organization in the Organization List
332: -- Store the values in global PL/SQL table G_ORG_GL_REV_TBL
333: -- Organization Id itself is the index

Line 335: PROCEDURE Retrieve_gl_rev(p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type)

331: -- organization in the Organization List
332: -- Store the values in global PL/SQL table G_ORG_GL_REV_TBL
333: -- Organization Id itself is the index
334: -- ====================================================================
335: PROCEDURE Retrieve_gl_rev(p_org_tbl IN INV_OrgHierarchy_PVT.OrgID_tbl_type)
336: IS
337:
338: -- Cursor to retrieve GL Account Info and starting revision
339: -- of the organization

Line 361: INV_ORGHIERARCHY_PVT.Log

357:
358: BEGIN
359:
360: IF G_DEBUG = 'Y' THEN
361: INV_ORGHIERARCHY_PVT.Log
362: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
363: , '> Retrieve_gl_rev'
364: );
365: END IF;

Line 362: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

358: BEGIN
359:
360: IF G_DEBUG = 'Y' THEN
361: INV_ORGHIERARCHY_PVT.Log
362: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
363: , '> Retrieve_gl_rev'
364: );
365: END IF;
366:

Line 394: INV_ORGHIERARCHY_PVT.Log

390:
391: END LOOP;
392:
393: IF G_DEBUG = 'Y' THEN
394: INV_ORGHIERARCHY_PVT.Log
395: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
396: , 'Org GL Revision table count: ' || G_ORG_GL_REV_TBL.COUNT
397: );
398: END IF;

Line 395: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

391: END LOOP;
392:
393: IF G_DEBUG = 'Y' THEN
394: INV_ORGHIERARCHY_PVT.Log
395: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
396: , 'Org GL Revision table count: ' || G_ORG_GL_REV_TBL.COUNT
397: );
398: END IF;
399:

Line 444: INV_ORGHIERARCHY_PVT.Log

440: l_cat_scenario VARCHAR2(2);
441: BEGIN
442:
443: IF G_DEBUG = 'Y' THEN
444: INV_ORGHIERARCHY_PVT.Log
445: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
446: , '> Build_Item_Cursor'
447: );
448: END IF;

Line 445: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

441: BEGIN
442:
443: IF G_DEBUG = 'Y' THEN
444: INV_ORGHIERARCHY_PVT.Log
445: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
446: , '> Build_Item_Cursor'
447: );
448: END IF;
449:

Line 475: INV_ORGHIERARCHY_PVT.Log

471: END IF;
472: END LOOP;
473:
474: IF G_DEBUG = 'Y' THEN
475: INV_ORGHIERARCHY_PVT.Log
476: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
477: , 'item flexfield segments:'||l_mstk_segs
478: );
479: END IF;

Line 476: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

472: END LOOP;
473:
474: IF G_DEBUG = 'Y' THEN
475: INV_ORGHIERARCHY_PVT.Log
476: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
477: , 'item flexfield segments:'||l_mstk_segs
478: );
479: END IF;
480:

Line 508: INV_ORGHIERARCHY_PVT.Log

504: END IF;
505: END LOOP;
506:
507: IF G_DEBUG = 'Y' THEN
508: INV_ORGHIERARCHY_PVT.Log
509: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
510: , 'category flexfield segments:'||l_mcat_segs
511: );
512: END IF;

Line 509: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

505: END LOOP;
506:
507: IF G_DEBUG = 'Y' THEN
508: INV_ORGHIERARCHY_PVT.Log
509: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
510: , 'category flexfield segments:'||l_mcat_segs
511: );
512: END IF;
513:

Line 582: INV_ORGHIERARCHY_PVT.Log

578: x_scenario := null;
579: x_scenario := l_item_scenario || l_cat_scenario ;
580:
581: IF G_DEBUG = 'Y' THEN
582: INV_ORGHIERARCHY_PVT.Log
583: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
584: , 'l_item_scenario => '|| l_item_scenario
585: );
586:

Line 583: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

579: x_scenario := l_item_scenario || l_cat_scenario ;
580:
581: IF G_DEBUG = 'Y' THEN
582: INV_ORGHIERARCHY_PVT.Log
583: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
584: , 'l_item_scenario => '|| l_item_scenario
585: );
586:
587: INV_ORGHIERARCHY_PVT.Log

Line 587: INV_ORGHIERARCHY_PVT.Log

583: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
584: , 'l_item_scenario => '|| l_item_scenario
585: );
586:
587: INV_ORGHIERARCHY_PVT.Log
588: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
589: , 'l_cat_scenario => '|| l_cat_scenario
590: );
591:

Line 588: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

584: , 'l_item_scenario => '|| l_item_scenario
585: );
586:
587: INV_ORGHIERARCHY_PVT.Log
588: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
589: , 'l_cat_scenario => '|| l_cat_scenario
590: );
591:
592: INV_ORGHIERARCHY_PVT.Log

Line 592: INV_ORGHIERARCHY_PVT.Log

588: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
589: , 'l_cat_scenario => '|| l_cat_scenario
590: );
591:
592: INV_ORGHIERARCHY_PVT.Log
593: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
594: , 'before cursor , x_scenario => '|| x_scenario
595: );
596: END IF;

Line 593: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

589: , 'l_cat_scenario => '|| l_cat_scenario
590: );
591:
592: INV_ORGHIERARCHY_PVT.Log
593: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
594: , 'before cursor , x_scenario => '|| x_scenario
595: );
596: END IF;
597:

Line 607: INV_ORGHIERARCHY_PVT.Log

603: l_mcat_w1 ||
604: l_mcat_w2;
605:
606: IF G_DEBUG = 'Y' THEN
607: INV_ORGHIERARCHY_PVT.Log
608: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
609: , SUBSTR(x_item_cursor, 1, 250)
610: );
611: INV_ORGHIERARCHY_PVT.Log

Line 608: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

604: l_mcat_w2;
605:
606: IF G_DEBUG = 'Y' THEN
607: INV_ORGHIERARCHY_PVT.Log
608: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
609: , SUBSTR(x_item_cursor, 1, 250)
610: );
611: INV_ORGHIERARCHY_PVT.Log
612: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 611: INV_ORGHIERARCHY_PVT.Log

607: INV_ORGHIERARCHY_PVT.Log
608: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
609: , SUBSTR(x_item_cursor, 1, 250)
610: );
611: INV_ORGHIERARCHY_PVT.Log
612: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
613: , SUBSTR(x_item_cursor, 251, 500)
614: );
615: INV_ORGHIERARCHY_PVT.Log

Line 612: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

608: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
609: , SUBSTR(x_item_cursor, 1, 250)
610: );
611: INV_ORGHIERARCHY_PVT.Log
612: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
613: , SUBSTR(x_item_cursor, 251, 500)
614: );
615: INV_ORGHIERARCHY_PVT.Log
616: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 615: INV_ORGHIERARCHY_PVT.Log

611: INV_ORGHIERARCHY_PVT.Log
612: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
613: , SUBSTR(x_item_cursor, 251, 500)
614: );
615: INV_ORGHIERARCHY_PVT.Log
616: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
617: , SUBSTR(x_item_cursor, 501, 750)
618: );
619:

Line 616: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

612: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
613: , SUBSTR(x_item_cursor, 251, 500)
614: );
615: INV_ORGHIERARCHY_PVT.Log
616: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
617: , SUBSTR(x_item_cursor, 501, 750)
618: );
619:
620: INV_ORGHIERARCHY_PVT.Log

Line 620: INV_ORGHIERARCHY_PVT.Log

616: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
617: , SUBSTR(x_item_cursor, 501, 750)
618: );
619:
620: INV_ORGHIERARCHY_PVT.Log
621: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
622: , '< Build_Item_Cursor'
623: );
624: END IF;

Line 621: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

617: , SUBSTR(x_item_cursor, 501, 750)
618: );
619:
620: INV_ORGHIERARCHY_PVT.Log
621: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
622: , '< Build_Item_Cursor'
623: );
624: END IF;
625:

Line 630: INV_ORGHIERARCHY_PVT.Log

626:
627: EXCEPTION
628: WHEN OTHERS THEN
629: IF G_DEBUG = 'Y' THEN
630: INV_ORGHIERARCHY_PVT.Log
631: ( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
632: , FND_FLEX_KEY_API.message
633: );
634: END IF;

Line 631: ( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

627: EXCEPTION
628: WHEN OTHERS THEN
629: IF G_DEBUG = 'Y' THEN
630: INV_ORGHIERARCHY_PVT.Log
631: ( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
632: , FND_FLEX_KEY_API.message
633: );
634: END IF;
635: RAISE;

Line 657: INV_ORGHIERARCHY_PVT.Log

653: l_master_org_id NUMBER;
654: BEGIN
655:
656: IF G_DEBUG = 'Y' THEN
657: INV_ORGHIERARCHY_PVT.Log
658: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
659: , '> Get_Master_Org'
660: );
661: END IF;

Line 658: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

654: BEGIN
655:
656: IF G_DEBUG = 'Y' THEN
657: INV_ORGHIERARCHY_PVT.Log
658: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
659: , '> Get_Master_Org'
660: );
661: END IF;
662:

Line 669: INV_ORGHIERARCHY_PVT.Log

665: FROM mtl_parameters
666: WHERE organization_id = p_org_hier_origin_id;
667:
668: IF G_DEBUG = 'Y' THEN
669: INV_ORGHIERARCHY_PVT.Log
670: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
671: , '< Get_Master_Org'
672: );
673: END IF;

Line 670: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

666: WHERE organization_id = p_org_hier_origin_id;
667:
668: IF G_DEBUG = 'Y' THEN
669: INV_ORGHIERARCHY_PVT.Log
670: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
671: , '< Get_Master_Org'
672: );
673: END IF;
674:

Line 693: INV_ORGHIERARCHY_PVT.Log

689: l_set_process_id NUMBER;
690: BEGIN
691:
692: IF G_DEBUG = 'Y' THEN
693: INV_ORGHIERARCHY_PVT.Log
694: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
695: , '> Get_Set_Process_ID'
696: );
697: END IF;

Line 694: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

690: BEGIN
691:
692: IF G_DEBUG = 'Y' THEN
693: INV_ORGHIERARCHY_PVT.Log
694: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
695: , '> Get_Set_Process_ID'
696: );
697: END IF;
698:

Line 704: INV_ORGHIERARCHY_PVT.Log

700: INTO l_set_process_id
701: FROM dual;
702:
703: IF G_DEBUG = 'Y' THEN
704: INV_ORGHIERARCHY_PVT.Log
705: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
706: , '< Get_Set_Process_ID'
707: );
708: END IF;

Line 705: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

701: FROM dual;
702:
703: IF G_DEBUG = 'Y' THEN
704: INV_ORGHIERARCHY_PVT.Log
705: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
706: , '< Get_Set_Process_ID'
707: );
708: END IF;
709:

Line 732: INV_ORGHIERARCHY_PVT.Log

728: l_result BOOLEAN;
729: BEGIN
730:
731: IF G_DEBUG = 'Y' THEN
732: INV_ORGHIERARCHY_PVT.Log
733: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
734: , '> Has_Worker_Completed'
735: );
736: END IF;

Line 733: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

729: BEGIN
730:
731: IF G_DEBUG = 'Y' THEN
732: INV_ORGHIERARCHY_PVT.Log
733: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
734: , '> Has_Worker_Completed'
735: );
736: END IF;
737:

Line 751: INV_ORGHIERARCHY_PVT.Log

747: l_result := FALSE;
748: END IF;
749:
750: IF G_DEBUG = 'Y' THEN
751: INV_ORGHIERARCHY_PVT.Log
752: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
753: , '< Has_Worker_Completed'
754: );
755: END IF;

Line 752: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

748: END IF;
749:
750: IF G_DEBUG = 'Y' THEN
751: INV_ORGHIERARCHY_PVT.Log
752: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
753: , '< Has_Worker_Completed'
754: );
755: END IF;
756:

Line 780: INV_ORGHIERARCHY_PVT.Log

776: l_done BOOLEAN;
777: BEGIN
778:
779: IF G_DEBUG = 'Y' THEN
780: INV_ORGHIERARCHY_PVT.Log
781: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
782: , '> Wait_For_Worker'
783: );
784: END IF;

Line 781: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

777: BEGIN
778:
779: IF G_DEBUG = 'Y' THEN
780: INV_ORGHIERARCHY_PVT.Log
781: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
782: , '> Wait_For_Worker'
783: );
784: END IF;
785:

Line 807: INV_ORGHIERARCHY_PVT.Log

803:
804: END LOOP;
805:
806: IF G_DEBUG = 'Y' THEN
807: INV_ORGHIERARCHY_PVT.Log
808: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
809: , '< Wait_For_Worker'
810: );
811: END IF;

Line 808: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

804: END LOOP;
805:
806: IF G_DEBUG = 'Y' THEN
807: INV_ORGHIERARCHY_PVT.Log
808: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
809: , '< Wait_For_Worker'
810: );
811: END IF;
812:

Line 830: INV_ORGHIERARCHY_PVT.Log

826: l_done BOOLEAN;
827: BEGIN
828:
829: IF G_DEBUG = 'Y' THEN
830: INV_ORGHIERARCHY_PVT.Log
831: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
832: , '> Wait_For_All_Workers'
833: );
834: END IF;

Line 831: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

827: BEGIN
828:
829: IF G_DEBUG = 'Y' THEN
830: INV_ORGHIERARCHY_PVT.Log
831: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
832: , '> Wait_For_All_Workers'
833: );
834: END IF;
835:

Line 858: INV_ORGHIERARCHY_PVT.Log

854:
855: END LOOP;
856:
857: IF G_DEBUG = 'Y' THEN
858: INV_ORGHIERARCHY_PVT.Log
859: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
860: , '< Wait_For_All_Workers'
861: );
862: END IF;

Line 859: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

855: END LOOP;
856:
857: IF G_DEBUG = 'Y' THEN
858: INV_ORGHIERARCHY_PVT.Log
859: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
860: , '< Wait_For_All_Workers'
861: );
862: END IF;
863:

Line 891: INV_ORGHIERARCHY_PVT.Log

887: l_request_id NUMBER;
888: BEGIN
889:
890: IF G_DEBUG = 'Y' THEN
891: INV_ORGHIERARCHY_PVT.Log
892: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
893: , '> Submit_Item_Import'
894: );
895: END IF;

Line 892: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

888: BEGIN
889:
890: IF G_DEBUG = 'Y' THEN
891: INV_ORGHIERARCHY_PVT.Log
892: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
893: , '> Submit_Item_Import'
894: );
895: END IF;
896:

Line 938: INV_ORGHIERARCHY_PVT.Log

934:
935: COMMIT;
936:
937: IF G_DEBUG = 'Y' THEN
938: INV_ORGHIERARCHY_PVT.Log
939: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
940: , '< Submit_Item_Import'
941: );
942: END IF;

Line 939: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

935: COMMIT;
936:
937: IF G_DEBUG = 'Y' THEN
938: INV_ORGHIERARCHY_PVT.Log
939: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
940: , '< Submit_Item_Import'
941: );
942: END IF;
943:

Line 957: ( p_org_tbl IN INV_ORGHIERARCHY_PVT.OrgID_tbl_type

953: -- where the organization to which a given item is already
954: -- assigned are removed.
955: --=========================================================================
956: PROCEDURE Filter_Org_List
957: ( p_org_tbl IN INV_ORGHIERARCHY_PVT.OrgID_tbl_type
958: , p_inventory_item_id IN NUMBER
959: , x_filtered_org_tbl IN OUT NOCOPY INV_ORGHIERARCHY_PVT.OrgID_tbl_type
960: )
961: IS

Line 959: , x_filtered_org_tbl IN OUT NOCOPY INV_ORGHIERARCHY_PVT.OrgID_tbl_type

955: --=========================================================================
956: PROCEDURE Filter_Org_List
957: ( p_org_tbl IN INV_ORGHIERARCHY_PVT.OrgID_tbl_type
958: , p_inventory_item_id IN NUMBER
959: , x_filtered_org_tbl IN OUT NOCOPY INV_ORGHIERARCHY_PVT.OrgID_tbl_type
960: )
961: IS
962: l_count NUMBER;
963: BEGIN

Line 966: INV_ORGHIERARCHY_PVT.Log

962: l_count NUMBER;
963: BEGIN
964:
965: IF G_DEBUG = 'Y' THEN
966: INV_ORGHIERARCHY_PVT.Log
967: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
968: , '> Filter_Org_List'
969: );
970: END IF;

Line 967: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

963: BEGIN
964:
965: IF G_DEBUG = 'Y' THEN
966: INV_ORGHIERARCHY_PVT.Log
967: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
968: , '> Filter_Org_List'
969: );
970: END IF;
971:

Line 990: INV_ORGHIERARCHY_PVT.Log

986:
987: END LOOP;
988:
989: IF G_DEBUG = 'Y' THEN
990: INV_ORGHIERARCHY_PVT.Log
991: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
992: , '< Filter_Org_List'
993: );
994: END IF;

Line 991: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

987: END LOOP;
988:
989: IF G_DEBUG = 'Y' THEN
990: INV_ORGHIERARCHY_PVT.Log
991: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
992: , '< Filter_Org_List'
993: );
994: END IF;
995:

Line 1015: INV_ORGHIERARCHY_PVT.Log

1011: l_error_count NUMBER;
1012: BEGIN
1013:
1014: IF G_DEBUG = 'Y' THEN
1015: INV_ORGHIERARCHY_PVT.Log
1016: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1017: , '> Determine_Return_Code'
1018: );
1019: END IF;

Line 1016: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1012: BEGIN
1013:
1014: IF G_DEBUG = 'Y' THEN
1015: INV_ORGHIERARCHY_PVT.Log
1016: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1017: , '> Determine_Return_Code'
1018: );
1019: END IF;
1020:

Line 1042: INV_ORGHIERARCHY_PVT.Log

1038: x_retcode := RETCODE_SUCCESS;
1039: x_errbuff := NULL;
1040: END IF;
1041: IF G_DEBUG = 'Y' THEN
1042: INV_ORGHIERARCHY_PVT.Log
1043: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1044: , '< Determine_Return_Code'
1045: );
1046: END IF;

Line 1043: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1039: x_errbuff := NULL;
1040: END IF;
1041: IF G_DEBUG = 'Y' THEN
1042: INV_ORGHIERARCHY_PVT.Log
1043: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1044: , '< Determine_Return_Code'
1045: );
1046: END IF;
1047:

Line 1085: INV_ORGHIERARCHY_PVT.Log

1081:
1082: EXCEPTION
1083: WHEN cost_of_sales_no_found_exc THEN
1084: IF G_DEBUG = 'Y' THEN
1085: INV_ORGHIERARCHY_PVT.Log
1086: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Cost of Sales Account NOT found for the organization' || p_organization_id);
1087: END IF;
1088: RAISE;
1089:

Line 1086: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Cost of Sales Account NOT found for the organization' || p_organization_id);

1082: EXCEPTION
1083: WHEN cost_of_sales_no_found_exc THEN
1084: IF G_DEBUG = 'Y' THEN
1085: INV_ORGHIERARCHY_PVT.Log
1086: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Cost of Sales Account NOT found for the organization' || p_organization_id);
1087: END IF;
1088: RAISE;
1089:
1090: END;

Line 1124: INV_ORGHIERARCHY_PVT.Log

1120:
1121: EXCEPTION
1122: WHEN encumbrance_account_no_exc THEN
1123: IF G_DEBUG = 'Y' THEN
1124: INV_ORGHIERARCHY_PVT.Log
1125: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Encumbrance Account NOT found for the organization' || p_organization_id);
1126: END IF;
1127: RAISE;
1128:

Line 1125: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Encumbrance Account NOT found for the organization' || p_organization_id);

1121: EXCEPTION
1122: WHEN encumbrance_account_no_exc THEN
1123: IF G_DEBUG = 'Y' THEN
1124: INV_ORGHIERARCHY_PVT.Log
1125: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Encumbrance Account NOT found for the organization' || p_organization_id);
1126: END IF;
1127: RAISE;
1128:
1129: END;

Line 1162: INV_ORGHIERARCHY_PVT.Log

1158:
1159: EXCEPTION
1160: WHEN sales_account_no_found_exc THEN
1161: IF G_DEBUG = 'Y' THEN
1162: INV_ORGHIERARCHY_PVT.Log
1163: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Sales Account NOT found for the organization' || p_organization_id);
1164: END IF;
1165: RAISE;
1166:

Line 1163: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Sales Account NOT found for the organization' || p_organization_id);

1159: EXCEPTION
1160: WHEN sales_account_no_found_exc THEN
1161: IF G_DEBUG = 'Y' THEN
1162: INV_ORGHIERARCHY_PVT.Log
1163: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Sales Account NOT found for the organization' || p_organization_id);
1164: END IF;
1165: RAISE;
1166:
1167: END;

Line 1200: INV_ORGHIERARCHY_PVT.Log

1196:
1197: EXCEPTION
1198: WHEN expense_account_no_found_exc THEN
1199: IF G_DEBUG = 'Y' THEN
1200: INV_ORGHIERARCHY_PVT.Log
1201: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Expense Account NOT found for the organization Id:' || p_organization_id);
1202: END IF;
1203: RAISE;
1204:

Line 1201: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Expense Account NOT found for the organization Id:' || p_organization_id);

1197: EXCEPTION
1198: WHEN expense_account_no_found_exc THEN
1199: IF G_DEBUG = 'Y' THEN
1200: INV_ORGHIERARCHY_PVT.Log
1201: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Expense Account NOT found for the organization Id:' || p_organization_id);
1202: END IF;
1203: RAISE;
1204:
1205: END;

Line 1238: INV_ORGHIERARCHY_PVT.Log

1234:
1235: EXCEPTION
1236: WHEN start_revision_no_found_exc THEN
1237: IF G_DEBUG = 'Y' THEN
1238: INV_ORGHIERARCHY_PVT.Log
1239: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Starting Reivision NOT found for the organization' || p_organization_id);
1240: END IF;
1241: RAISE;
1242:

Line 1239: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Starting Reivision NOT found for the organization' || p_organization_id);

1235: EXCEPTION
1236: WHEN start_revision_no_found_exc THEN
1237: IF G_DEBUG = 'Y' THEN
1238: INV_ORGHIERARCHY_PVT.Log
1239: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,'Starting Reivision NOT found for the organization' || p_organization_id);
1240: END IF;
1241: RAISE;
1242:
1243: END;

Line 1305: l_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;

1301: , p_request_count IN NUMBER
1302: )
1303: IS
1304:
1305: l_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;
1306: l_filtered_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;
1307: l_org_id NUMBER;
1308: l_src_master NUMBER; -- Source Org. Item Master
1309: l_master_org_id NUMBER;

Line 1306: l_filtered_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;

1302: )
1303: IS
1304:
1305: l_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;
1306: l_filtered_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;
1307: l_org_id NUMBER;
1308: l_src_master NUMBER; -- Source Org. Item Master
1309: l_master_org_id NUMBER;
1310: l_max_batch_size NUMBER;

Line 1335: l_valid_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;

1331: l_return_code INTEGER;
1332: l_err_text VARCHAR2(240);
1333:
1334: -- GL Account valid organization List
1335: l_valid_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;
1336:
1337: -- Cursor to retrieve primary unit of measure for the item
1338: -- and also to validate with mtl_units_of_measure
1339: CURSOR primary_uom_cur(c_master_org_id NUMBER

Line 1385: INV_ORGHIERARCHY_PVT.Log_Initialize;

1381: BEGIN
1382:
1383: IF G_DEBUG = 'Y' THEN
1384: -- initialize log
1385: INV_ORGHIERARCHY_PVT.Log_Initialize;
1386: INV_ORGHIERARCHY_PVT.Log
1387: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1388: , '> Item_Org_Assignment'
1389: );

Line 1386: INV_ORGHIERARCHY_PVT.Log

1382:
1383: IF G_DEBUG = 'Y' THEN
1384: -- initialize log
1385: INV_ORGHIERARCHY_PVT.Log_Initialize;
1386: INV_ORGHIERARCHY_PVT.Log
1387: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1388: , '> Item_Org_Assignment'
1389: );
1390: END IF;

Line 1387: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1383: IF G_DEBUG = 'Y' THEN
1384: -- initialize log
1385: INV_ORGHIERARCHY_PVT.Log_Initialize;
1386: INV_ORGHIERARCHY_PVT.Log
1387: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1388: , '> Item_Org_Assignment'
1389: );
1390: END IF;
1391:

Line 1405: INV_ORGHIERARCHY_PVT.get_organization_list

1401: );
1402:
1403:
1404: -- Get Organization List
1405: INV_ORGHIERARCHY_PVT.get_organization_list
1406: ( p_hierarchy_id => p_org_hierarchy_id
1407: , p_origin_org_id => p_org_hier_origin_id
1408: , x_org_id_tbl => l_org_tbl
1409: , p_include_origin => 'Y'

Line 1413: l_property_flag := INV_ORGHIERARCHY_PVT.

1409: , p_include_origin => 'Y'
1410: );
1411:
1412: -- Validate for the same item master
1413: l_property_flag := INV_ORGHIERARCHY_PVT.
1414: validate_property(l_org_tbl, 'MASTER');
1415:
1416: IF G_DEBUG = 'Y' THEN
1417: INV_ORGHIERARCHY_PVT.Log

Line 1417: INV_ORGHIERARCHY_PVT.Log

1413: l_property_flag := INV_ORGHIERARCHY_PVT.
1414: validate_property(l_org_tbl, 'MASTER');
1415:
1416: IF G_DEBUG = 'Y' THEN
1417: INV_ORGHIERARCHY_PVT.Log
1418: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1419: ,'Property Flag:' || l_property_flag );
1420: END IF;
1421:

Line 1418: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT

1414: validate_property(l_org_tbl, 'MASTER');
1415:
1416: IF G_DEBUG = 'Y' THEN
1417: INV_ORGHIERARCHY_PVT.Log
1418: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1419: ,'Property Flag:' || l_property_flag );
1420: END IF;
1421:
1422: -- 3306087 : Start Code Change

Line 1492: INV_ORGHIERARCHY_PVT.Log

1488: ,x_valid_org_tbl => l_valid_org_tbl
1489: );
1490:
1491: IF G_DEBUG = 'Y' THEN
1492: INV_ORGHIERARCHY_PVT.Log
1493: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1494: , 'Valid Org table size: '|| TO_CHAR(l_valid_org_tbl.COUNT)
1495: );
1496: END IF;

Line 1493: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1489: );
1490:
1491: IF G_DEBUG = 'Y' THEN
1492: INV_ORGHIERARCHY_PVT.Log
1493: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1494: , 'Valid Org table size: '|| TO_CHAR(l_valid_org_tbl.COUNT)
1495: );
1496: END IF;
1497:

Line 1516: INV_ORGHIERARCHY_PVT.Log

1512: l_batch_size := 0;
1513: l_set_process_id := Get_Set_Process_ID;
1514:
1515: IF G_DEBUG = 'Y' THEN
1516: INV_ORGHIERARCHY_PVT.Log
1517: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1518: , 'About to call Build_Item_Cursor '
1519: );
1520: END IF;

Line 1517: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1513: l_set_process_id := Get_Set_Process_ID;
1514:
1515: IF G_DEBUG = 'Y' THEN
1516: INV_ORGHIERARCHY_PVT.Log
1517: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1518: , 'About to call Build_Item_Cursor '
1519: );
1520: END IF;
1521:

Line 1540: INV_ORGHIERARCHY_PVT.Log

1536: , x_scenario => l_scenario
1537: );
1538:
1539: IF G_DEBUG = 'Y' THEN
1540: INV_ORGHIERARCHY_PVT.Log
1541: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1542: , 'Out of Build_Item_Cursor '
1543: );
1544: INV_ORGHIERARCHY_PVT.Log

Line 1541: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1537: );
1538:
1539: IF G_DEBUG = 'Y' THEN
1540: INV_ORGHIERARCHY_PVT.Log
1541: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1542: , 'Out of Build_Item_Cursor '
1543: );
1544: INV_ORGHIERARCHY_PVT.Log
1545: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 1544: INV_ORGHIERARCHY_PVT.Log

1540: INV_ORGHIERARCHY_PVT.Log
1541: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1542: , 'Out of Build_Item_Cursor '
1543: );
1544: INV_ORGHIERARCHY_PVT.Log
1545: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1546: , 'l_scenario => '|| l_scenario
1547: );
1548: END IF;

Line 1545: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1541: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1542: , 'Out of Build_Item_Cursor '
1543: );
1544: INV_ORGHIERARCHY_PVT.Log
1545: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1546: , 'l_scenario => '|| l_scenario
1547: );
1548: END IF;
1549:

Line 1696: INV_ORGHIERARCHY_PVT.Log

1692: -- Old code commented --
1693: -- OPEN l_item_cur FOR l_item_cursor; --
1694:
1695: IF G_DEBUG = 'Y' THEN
1696: INV_ORGHIERARCHY_PVT.Log
1697: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1698: , 'start LOOP on l_item_cur'
1699: );
1700: END IF;

Line 1697: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1693: -- OPEN l_item_cur FOR l_item_cursor; --
1694:
1695: IF G_DEBUG = 'Y' THEN
1696: INV_ORGHIERARCHY_PVT.Log
1697: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1698: , 'start LOOP on l_item_cur'
1699: );
1700: END IF;
1701:

Line 1727: INV_ORGHIERARCHY_PVT.Log

1723: , x_filtered_org_tbl => l_filtered_org_tbl
1724: );
1725:
1726: IF G_DEBUG = 'Y' THEN
1727: INV_ORGHIERARCHY_PVT.Log
1728: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1729: , 'Filtered table size: '|| TO_CHAR(l_filtered_org_tbl.COUNT)
1730: );
1731: END IF;

Line 1728: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1724: );
1725:
1726: IF G_DEBUG = 'Y' THEN
1727: INV_ORGHIERARCHY_PVT.Log
1728: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1729: , 'Filtered table size: '|| TO_CHAR(l_filtered_org_tbl.COUNT)
1730: );
1731: END IF;
1732:

Line 1746: INV_ORGHIERARCHY_PVT.Log

1742:
1743: LOOP
1744:
1745: IF G_DEBUG = 'Y' THEN
1746: INV_ORGHIERARCHY_PVT.Log
1747: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1748: , 'Loop on a batch'
1749: );
1750:

Line 1747: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1743: LOOP
1744:
1745: IF G_DEBUG = 'Y' THEN
1746: INV_ORGHIERARCHY_PVT.Log
1747: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1748: , 'Loop on a batch'
1749: );
1750:
1751: INV_ORGHIERARCHY_PVT.Log

Line 1751: INV_ORGHIERARCHY_PVT.Log

1747: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1748: , 'Loop on a batch'
1749: );
1750:
1751: INV_ORGHIERARCHY_PVT.Log
1752: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1753: , 'Min index:'||TO_CHAR(l_min_index)
1754: );
1755: INV_ORGHIERARCHY_PVT.Log

Line 1752: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1748: , 'Loop on a batch'
1749: );
1750:
1751: INV_ORGHIERARCHY_PVT.Log
1752: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1753: , 'Min index:'||TO_CHAR(l_min_index)
1754: );
1755: INV_ORGHIERARCHY_PVT.Log
1756: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 1755: INV_ORGHIERARCHY_PVT.Log

1751: INV_ORGHIERARCHY_PVT.Log
1752: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1753: , 'Min index:'||TO_CHAR(l_min_index)
1754: );
1755: INV_ORGHIERARCHY_PVT.Log
1756: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1757: , 'Max index:'||TO_CHAR(l_max_index)
1758: );
1759: END IF;

Line 1756: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1752: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1753: , 'Min index:'||TO_CHAR(l_min_index)
1754: );
1755: INV_ORGHIERARCHY_PVT.Log
1756: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1757: , 'Max index:'||TO_CHAR(l_max_index)
1758: );
1759: END IF;
1760:

Line 1858: INV_ORGHIERARCHY_PVT.Log

1854:
1855:
1856: /* commented for better performance
1857: IF G_DEBUG = 'Y' THEN
1858: INV_ORGHIERARCHY_PVT.Log
1859: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1860: , 'Assign Master default successful:'|| items_interface_row.rowid
1861: || ' Item Id:' || items_interface_row.inventory_item_id ||
1862: ' Org Id:' || items_interface_row.organization_id

Line 1859: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1855:
1856: /* commented for better performance
1857: IF G_DEBUG = 'Y' THEN
1858: INV_ORGHIERARCHY_PVT.Log
1859: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1860: , 'Assign Master default successful:'|| items_interface_row.rowid
1861: || ' Item Id:' || items_interface_row.inventory_item_id ||
1862: ' Org Id:' || items_interface_row.organization_id
1863: );

Line 1921: INV_ORGHIERARCHY_PVT.Log

1917: );
1918:
1919: /* commented for better performance
1920: IF G_DEBUG = 'Y' THEN
1921: INV_ORGHIERARCHY_PVT.Log
1922: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1923: , 'Revision interface successful:'|| items_interface_row.rowid
1924: || ' Item Id:' || items_interface_row.inventory_item_id ||
1925: ' Org Id:' || items_interface_row.organization_id

Line 1922: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1918:
1919: /* commented for better performance
1920: IF G_DEBUG = 'Y' THEN
1921: INV_ORGHIERARCHY_PVT.Log
1922: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1923: , 'Revision interface successful:'|| items_interface_row.rowid
1924: || ' Item Id:' || items_interface_row.inventory_item_id ||
1925: ' Org Id:' || items_interface_row.organization_id
1926: );

Line 1961: INV_ORGHIERARCHY_PVT.Log

1957:
1958: END LOOP; -- end loop of filter org list
1959:
1960: IF G_DEBUG = 'Y' THEN
1961: INV_ORGHIERARCHY_PVT.Log
1962: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1963: , 'Interface records inserted for Item:' || l_inventory_item_id
1964: || ' '|| 'Process Id:'|| l_set_process_id
1965: );

Line 1962: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT

1958: END LOOP; -- end loop of filter org list
1959:
1960: IF G_DEBUG = 'Y' THEN
1961: INV_ORGHIERARCHY_PVT.Log
1962: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1963: , 'Interface records inserted for Item:' || l_inventory_item_id
1964: || ' '|| 'Process Id:'|| l_set_process_id
1965: );
1966: END IF;

Line 1973: INV_ORGHIERARCHY_PVT.Log

1969:
1970: ELSE
1971:
1972: IF G_DEBUG = 'Y' THEN
1973: INV_ORGHIERARCHY_PVT.Log
1974: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1975: , 'Valid Primary Unit of Measure not found for the item id:'||
1976: l_inventory_item_id
1977: );

Line 1974: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1970: ELSE
1971:
1972: IF G_DEBUG = 'Y' THEN
1973: INV_ORGHIERARCHY_PVT.Log
1974: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1975: , 'Valid Primary Unit of Measure not found for the item id:'||
1976: l_inventory_item_id
1977: );
1978: END IF;

Line 2006: INV_ORGHIERARCHY_PVT.Log

2002: , x_errbuff => x_errbuff
2003: );
2004:
2005: IF G_DEBUG = 'Y' THEN
2006: INV_ORGHIERARCHY_PVT.Log
2007: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2008: , '< Item_Org_Assignment'
2009: );
2010: END IF;

Line 2007: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2003: );
2004:
2005: IF G_DEBUG = 'Y' THEN
2006: INV_ORGHIERARCHY_PVT.Log
2007: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2008: , '< Item_Org_Assignment'
2009: );
2010: END IF;
2011:

Line 2021: INV_ORGHIERARCHY_PVT.Log

2017: x_retcode := RETCODE_ERROR;
2018:
2019: WHEN l_hierarchy_validation THEN
2020: IF G_DEBUG = 'Y' THEN
2021: INV_ORGHIERARCHY_PVT.Log
2022: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);
2023: END IF;
2024: x_retcode := RETCODE_ERROR;
2025:

Line 2022: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);

2018:
2019: WHEN l_hierarchy_validation THEN
2020: IF G_DEBUG = 'Y' THEN
2021: INV_ORGHIERARCHY_PVT.Log
2022: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);
2023: END IF;
2024: x_retcode := RETCODE_ERROR;
2025:
2026: WHEN assign_master_default_except THEN

Line 2028: INV_ORGHIERARCHY_PVT.Log

2024: x_retcode := RETCODE_ERROR;
2025:
2026: WHEN assign_master_default_except THEN
2027: IF G_DEBUG = 'Y' THEN
2028: INV_ORGHIERARCHY_PVT.Log
2029: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,l_err_text);
2030: END IF;
2031: x_errbuff := l_err_text;
2032: x_retcode := l_return_code;

Line 2029: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,l_err_text);

2025:
2026: WHEN assign_master_default_except THEN
2027: IF G_DEBUG = 'Y' THEN
2028: INV_ORGHIERARCHY_PVT.Log
2029: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,l_err_text);
2030: END IF;
2031: x_errbuff := l_err_text;
2032: x_retcode := l_return_code;
2033:

Line 2036: INV_ORGHIERARCHY_PVT.Log

2032: x_retcode := l_return_code;
2033:
2034: WHEN assign_status_attrib_except THEN
2035: IF G_DEBUG = 'Y' THEN
2036: INV_ORGHIERARCHY_PVT.Log
2037: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,l_err_text);
2038: END IF;
2039: x_errbuff := l_err_text;
2040: x_retcode := l_return_code;

Line 2037: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,l_err_text);

2033:
2034: WHEN assign_status_attrib_except THEN
2035: IF G_DEBUG = 'Y' THEN
2036: INV_ORGHIERARCHY_PVT.Log
2037: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,l_err_text);
2038: END IF;
2039: x_errbuff := l_err_text;
2040: x_retcode := l_return_code;
2041: