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.

[Home] [Help]

APPS.INV_ORGHIERARCHY_PVT dependencies on INV_ORGHIERARCHY_PVT

Line 1: PACKAGE BODY INV_ORGHIERARCHY_PVT AS

1: PACKAGE BODY INV_ORGHIERARCHY_PVT AS
2: /* $Header: INVVORGB.pls 120.2 2006/03/27 01:21:30 amohamme noship $ */
3: --+=======================================================================+
4: --| Copyright (c) 2000 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 12: --| Spec of INV_ORGHIERARCHY_PVT |

8: --| FILENAME |
9: --| INVVORGB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| Spec of INV_ORGHIERARCHY_PVT |
13: --| |
14: --| HISTORY |
15: --| 08/28/00 vjavli Created |
16: --| 09/06/00 vjavli Updated profile for business group id |

Line 84: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ORGHIERARCHY_PVT';

80:
81: --===================
82: -- GLOBALS
83: --===================
84: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ORGHIERARCHY_PVT';
85:
86: g_log_level NUMBER := NULL; -- 0 for manual test
87: g_log_mode VARCHAR2(3) := 'OFF'; -- possible values: OFF, SQL, SRS
88: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

Line 597: INV_ORGHIERARCHY_PVT.Log

593: AND pos.organization_structure_id(+) = psp.organization_structure_id;
594:
595: BEGIN
596: IF G_DEBUG = 'Y' THEN
597: INV_ORGHIERARCHY_PVT.Log
598: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
599: , 'Start of Proc:Org Hierarchy Access'
600: );
601: END IF;

Line 598: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

594:
595: BEGIN
596: IF G_DEBUG = 'Y' THEN
597: INV_ORGHIERARCHY_PVT.Log
598: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
599: , 'Start of Proc:Org Hierarchy Access'
600: );
601: END IF;
602:

Line 612: INV_ORGHIERARCHY_PVT.Log

608: Error/Exception logging should not depend on
609: FND Debug Enabled profile otpion. Bug: 3555234
610: IF G_DEBUG = 'Y' THEN
611: */
612: INV_ORGHIERARCHY_PVT.Log
613: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
614: , 'Security Profile Id is not set for the responsibility');
615:
616: --END IF;

Line 613: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR

609: FND Debug Enabled profile otpion. Bug: 3555234
610: IF G_DEBUG = 'Y' THEN
611: */
612: INV_ORGHIERARCHY_PVT.Log
613: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
614: , 'Security Profile Id is not set for the responsibility');
615:
616: --END IF;
617:

Line 637: INV_ORGHIERARCHY_PVT.Log

633: Error/Exception logging should not depend on
634: FND Debug Enabled profile otpion. Bug: 3555234
635: IF G_DEBUG = 'Y' THEN
636: */
637: INV_ORGHIERARCHY_PVT.Log
638: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
639: ,'Security Profile not found');
640: --END IF;
641: END IF;

Line 638: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

634: FND Debug Enabled profile otpion. Bug: 3555234
635: IF G_DEBUG = 'Y' THEN
636: */
637: INV_ORGHIERARCHY_PVT.Log
638: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
639: ,'Security Profile not found');
640: --END IF;
641: END IF;
642:

Line 644: INV_ORGHIERARCHY_PVT.Log

640: --END IF;
641: END IF;
642:
643: IF G_DEBUG = 'Y' THEN
644: INV_ORGHIERARCHY_PVT.Log
645: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
646: ,'Profile Hierarchy Name:' || l_profile_hierarchy_name
647: );
648: INV_ORGHIERARCHY_PVT.Log

Line 645: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

641: END IF;
642:
643: IF G_DEBUG = 'Y' THEN
644: INV_ORGHIERARCHY_PVT.Log
645: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
646: ,'Profile Hierarchy Name:' || l_profile_hierarchy_name
647: );
648: INV_ORGHIERARCHY_PVT.Log
649: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 648: INV_ORGHIERARCHY_PVT.Log

644: INV_ORGHIERARCHY_PVT.Log
645: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
646: ,'Profile Hierarchy Name:' || l_profile_hierarchy_name
647: );
648: INV_ORGHIERARCHY_PVT.Log
649: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
650: ,'View All Organizations Flag:' || l_view_all_org_flag
651: || ' Include Top Organization Flag:' ||l_include_top_org_flag
652: || ' Top Organization Id:' || to_char(l_top_organization_id)

Line 649: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

645: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
646: ,'Profile Hierarchy Name:' || l_profile_hierarchy_name
647: );
648: INV_ORGHIERARCHY_PVT.Log
649: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
650: ,'View All Organizations Flag:' || l_view_all_org_flag
651: || ' Include Top Organization Flag:' ||l_include_top_org_flag
652: || ' Top Organization Id:' || to_char(l_top_organization_id)
653: );

Line 662: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List

658: (l_view_all_org_flag = 'N')) THEN
659:
660: -- Obtain List of Organizations for the Security profile Org
661: -- Hierarchy Name starting from the top organization
662: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List
663: ( l_profile_hierarchy_name
664: , l_top_organization_id
665: , l_security_profile_org_list
666: );

Line 670: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List

666: );
667:
668: -- Obtain List of Organizations for the Org Hierarchy Name
669: -- where hierarchy level id is null
670: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List
671: ( p_org_hierarchy_name
672: , l_org_hier_level_id
673: , l_org_list
674: );

Line 714: INV_ORGHIERARCHY_PVT.Log

710:
711: RETURN l_org_access_flag;
712:
713: IF G_DEBUG = 'Y' THEN
714: INV_ORGHIERARCHY_PVT.Log
715: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
716: ,'End of Proc:Org Hierarchy Access'
717: );
718: END IF;

Line 715: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

711: RETURN l_org_access_flag;
712:
713: IF G_DEBUG = 'Y' THEN
714: INV_ORGHIERARCHY_PVT.Log
715: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
716: ,'End of Proc:Org Hierarchy Access'
717: );
718: END IF;
719:

Line 729: INV_ORGHIERARCHY_PVT.Log

725: Error/Exception logging should not depend on
726: FND Debug Enabled profile otpion. Bug: 3555234
727: IF G_DEBUG = 'Y' THEN
728: */
729: INV_ORGHIERARCHY_PVT.Log
730: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
731: ,'Others' || to_char(l_errorcode) || l_errortext
732: );
733: --END IF;

Line 730: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

726: FND Debug Enabled profile otpion. Bug: 3555234
727: IF G_DEBUG = 'Y' THEN
728: */
729: INV_ORGHIERARCHY_PVT.Log
730: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
731: ,'Others' || to_char(l_errorcode) || l_errortext
732: );
733: --END IF;
734: RETURN NULL;

Line 789: INV_ORGHIERARCHY_PVT.Log

785:
786:
787: BEGIN
788: IF G_DEBUG = 'Y' THEN
789: INV_ORGHIERARCHY_PVT.Log
790: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
791: ,'Start of Proc:Org Hierarchy Level Access'
792: );
793: END IF;

Line 790: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

786:
787: BEGIN
788: IF G_DEBUG = 'Y' THEN
789: INV_ORGHIERARCHY_PVT.Log
790: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
791: ,'Start of Proc:Org Hierarchy Level Access'
792: );
793: END IF;
794: -- get the profile id of the user

Line 815: INV_ORGHIERARCHY_PVT.Log

811: Error/Exception logging should not depend on
812: FND Debug Enabled profile otpion. Bug: 3555234
813: IF G_DEBUG = 'Y' THEN
814: */
815: INV_ORGHIERARCHY_PVT.Log
816: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
817: ,'Profile hierarchy name not found'
818: );
819: --END IF;

Line 816: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

812: FND Debug Enabled profile otpion. Bug: 3555234
813: IF G_DEBUG = 'Y' THEN
814: */
815: INV_ORGHIERARCHY_PVT.Log
816: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
817: ,'Profile hierarchy name not found'
818: );
819: --END IF;
820: END IF;

Line 851: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List

847:
848:
849: -- Obtain List of Organizations for the Organization Hierarchy Name
850: -- where hierarchy level id is null
851: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List
852: (p_org_hierarchy_name,l_org_hier_level_id,l_org_list);
853:
854: -- To check whether the entered Organization Hierarchy Level Id is
855: -- within the entered organization hierarchy name

Line 868: INV_ORGHIERARCHY_PVT.Log

864: l_index := l_org_list.NEXT(l_index);
865: END LOOP;
866:
867: IF G_DEBUG = 'Y' THEN
868: INV_ORGHIERARCHY_PVT.Log
869: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
870: , 'Organization Level Validity flag' ||
871: l_org_level_validity_flag
872: );

Line 869: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

865: END LOOP;
866:
867: IF G_DEBUG = 'Y' THEN
868: INV_ORGHIERARCHY_PVT.Log
869: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
870: , 'Organization Level Validity flag' ||
871: l_org_level_validity_flag
872: );
873: END IF;

Line 883: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List

879: (l_view_all_org_flag = 'N')) THEN
880:
881: -- Obtain List of Organizations for the Security profile Org
882: -- Hierarchy Name
883: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List
884: (l_profile_hierarchy_name,l_top_organization_id,
885: l_security_profile_org_list);
886:
887: -- initialize the security profile org list index

Line 924: INV_ORGHIERARCHY_PVT.Log

920:
921: RETURN l_org_level_access_flag;
922:
923: IF G_DEBUG = 'Y' THEN
924: INV_ORGHIERARCHY_PVT.Log
925: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
926: ,'End of Proc:Org Hierarchy Level Access'
927: );
928: END IF;

Line 925: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

921: RETURN l_org_level_access_flag;
922:
923: IF G_DEBUG = 'Y' THEN
924: INV_ORGHIERARCHY_PVT.Log
925: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
926: ,'End of Proc:Org Hierarchy Level Access'
927: );
928: END IF;
929:

Line 940: INV_ORGHIERARCHY_PVT.Log

936: Error/Exception logging should not depend on
937: FND Debug Enabled profile otpion. Bug: 3555234
938: IF G_DEBUG = 'Y' THEN
939: */
940: INV_ORGHIERARCHY_PVT.Log
941: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
942: ,to_char(l_errorcode) || l_errortext
943: );
944: --END IF;

Line 941: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

937: FND Debug Enabled profile otpion. Bug: 3555234
938: IF G_DEBUG = 'Y' THEN
939: */
940: INV_ORGHIERARCHY_PVT.Log
941: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
942: ,to_char(l_errorcode) || l_errortext
943: );
944: --END IF;
945: RETURN NULL;

Line 1066: INV_ORGHIERARCHY_PVT.Log

1062:
1063: BEGIN
1064:
1065: IF G_DEBUG = 'Y' THEN
1066: INV_ORGHIERARCHY_PVT.Log
1067: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1068: ,'Start of Proc:Org Hierarchy List'
1069: );
1070: END IF;

Line 1067: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1063: BEGIN
1064:
1065: IF G_DEBUG = 'Y' THEN
1066: INV_ORGHIERARCHY_PVT.Log
1067: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1068: ,'Start of Proc:Org Hierarchy List'
1069: );
1070: END IF;
1071:

Line 1076: INV_ORGHIERARCHY_PVT.Log

1072: l_business_group_id :=
1073: TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
1074:
1075: IF G_DEBUG = 'Y' THEN
1076: INV_ORGHIERARCHY_PVT.Log
1077: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1078: ,'Business Group Id:'||to_char(l_business_group_id)
1079: );
1080: END IF;

Line 1077: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1073: TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
1074:
1075: IF G_DEBUG = 'Y' THEN
1076: INV_ORGHIERARCHY_PVT.Log
1077: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1078: ,'Business Group Id:'||to_char(l_business_group_id)
1079: );
1080: END IF;
1081:

Line 1089: INV_ORGHIERARCHY_PVT.Log

1085: l_business_group_id;
1086:
1087: IF c_organization_version%NOTFOUND THEN
1088: IF G_DEBUG = 'Y' THEN
1089: INV_ORGHIERARCHY_PVT.Log
1090: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1091: ,'Organization Version Id:'||to_char(l_structure_version_id)
1092: );
1093: END IF;

Line 1090: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1086:
1087: IF c_organization_version%NOTFOUND THEN
1088: IF G_DEBUG = 'Y' THEN
1089: INV_ORGHIERARCHY_PVT.Log
1090: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1091: ,'Organization Version Id:'||to_char(l_structure_version_id)
1092: );
1093: END IF;
1094:

Line 1103: INV_ORGHIERARCHY_PVT.Log

1099:
1100: CLOSE c_organization_version;
1101:
1102: IF G_DEBUG = 'Y' THEN
1103: INV_ORGHIERARCHY_PVT.Log
1104: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1105: ,'Organization Version Id:' || to_char(l_structure_version_id)
1106: );
1107:

Line 1104: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1100: CLOSE c_organization_version;
1101:
1102: IF G_DEBUG = 'Y' THEN
1103: INV_ORGHIERARCHY_PVT.Log
1104: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1105: ,'Organization Version Id:' || to_char(l_structure_version_id)
1106: );
1107:
1108: INV_ORGHIERARCHY_PVT.Log

Line 1108: INV_ORGHIERARCHY_PVT.Log

1104: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1105: ,'Organization Version Id:' || to_char(l_structure_version_id)
1106: );
1107:
1108: INV_ORGHIERARCHY_PVT.Log
1109: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1110: ,'Business Group Id:' || to_char(l_business_group_id)
1111: );
1112: END IF;

Line 1109: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1105: ,'Organization Version Id:' || to_char(l_structure_version_id)
1106: );
1107:
1108: INV_ORGHIERARCHY_PVT.Log
1109: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1110: ,'Business Group Id:' || to_char(l_business_group_id)
1111: );
1112: END IF;
1113:

Line 1132: INV_ORGHIERARCHY_PVT.Log

1128: Error/Exception logging should not depend on
1129: FND Debug Enabled profile otpion. Bug: 3555234
1130: IF G_DEBUG = 'Y' THEN
1131: */
1132: INV_ORGHIERARCHY_PVT.Log
1133: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1134: ,'Parent Organization Id not found when hierarchy level null'
1135: );
1136: -- END IF;

Line 1133: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1129: FND Debug Enabled profile otpion. Bug: 3555234
1130: IF G_DEBUG = 'Y' THEN
1131: */
1132: INV_ORGHIERARCHY_PVT.Log
1133: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1134: ,'Parent Organization Id not found when hierarchy level null'
1135: );
1136: -- END IF;
1137: END IF;

Line 1148: IF (INV_ORGHIERARCHY_PVT.

1144: l_user_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
1145:
1146: -- check whether the parent organization id is unexpired and
1147: -- has an access to the current user responsibility
1148: IF (INV_ORGHIERARCHY_PVT.
1149: Org_Hier_Level_Resp_Access(l_org_hierarchy_parent_id,
1150: l_business_group_id,
1151: l_user_resp_id) = 'Y') THEN
1152:

Line 1158: INV_ORGHIERARCHY_PVT.Log

1154: list_id := list_id + 1;
1155: x_org_code_list(list_id) := l_org_hierarchy_parent_id;
1156:
1157: IF G_DEBUG = 'Y' THEN
1158: INV_ORGHIERARCHY_PVT.Log
1159: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1160: ,'Parent Organization Hierarchy Code:' ||
1161: to_char(x_org_code_list(list_id))
1162: );

Line 1159: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1155: x_org_code_list(list_id) := l_org_hierarchy_parent_id;
1156:
1157: IF G_DEBUG = 'Y' THEN
1158: INV_ORGHIERARCHY_PVT.Log
1159: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1160: ,'Parent Organization Hierarchy Code:' ||
1161: to_char(x_org_code_list(list_id))
1162: );
1163: END IF;

Line 1177: IF (INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access

1173: l_orgcode := v_organizations.organization_id_child;
1174: l_level := v_organizations.level;
1175:
1176: -- check for valid organization and user responsibility access
1177: IF (INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access
1178: (l_orgcode,
1179: l_business_group_id,
1180: l_user_resp_id ) = 'Y' ) THEN
1181:

Line 1186: INV_ORGHIERARCHY_PVT.Log

1182: list_id := list_id + 1;
1183: x_org_code_list( list_id ) := l_orgcode;
1184:
1185: IF G_DEBUG = 'Y' THEN
1186: INV_ORGHIERARCHY_PVT.Log
1187: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1188: , 'Organization Hierarchy Code:'||LPAD(' ', 6 * (l_level - 1))||
1189: to_char(x_org_code_list(list_id))
1190: );

Line 1187: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1183: x_org_code_list( list_id ) := l_orgcode;
1184:
1185: IF G_DEBUG = 'Y' THEN
1186: INV_ORGHIERARCHY_PVT.Log
1187: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1188: , 'Organization Hierarchy Code:'||LPAD(' ', 6 * (l_level - 1))||
1189: to_char(x_org_code_list(list_id))
1190: );
1191: END IF;

Line 1199: INV_ORGHIERARCHY_PVT.Log

1195: END LOOP;
1196:
1197: IF l_orgcode is NULL THEN
1198: IF G_DEBUG = 'Y' THEN
1199: INV_ORGHIERARCHY_PVT.Log
1200: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1201: ,'No Valid Child exist for the parent organization code:' ||
1202: to_char(l_org_hierarchy_parent_id)
1203: );

Line 1200: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1196:
1197: IF l_orgcode is NULL THEN
1198: IF G_DEBUG = 'Y' THEN
1199: INV_ORGHIERARCHY_PVT.Log
1200: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1201: ,'No Valid Child exist for the parent organization code:' ||
1202: to_char(l_org_hierarchy_parent_id)
1203: );
1204: END IF;

Line 1208: INV_ORGHIERARCHY_PVT.Log

1204: END IF;
1205: END IF;
1206:
1207: IF G_DEBUG = 'Y' THEN
1208: INV_ORGHIERARCHY_PVT.Log
1209: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1210: ,'End of Proc:Org Hierarchy List'
1211: );
1212: END IF;

Line 1209: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1205: END IF;
1206:
1207: IF G_DEBUG = 'Y' THEN
1208: INV_ORGHIERARCHY_PVT.Log
1209: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1210: ,'End of Proc:Org Hierarchy List'
1211: );
1212: END IF;
1213:

Line 1224: INV_ORGHIERARCHY_PVT.Log

1220: FND Debug Enabled profile otpion. Log level has been
1221: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
1222: IF G_DEBUG = 'Y' THEN
1223: */
1224: INV_ORGHIERARCHY_PVT.Log
1225: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1226: ,to_char(l_errorcode) || l_errortext
1227: );
1228: --END IF;

Line 1225: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

1221: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
1222: IF G_DEBUG = 'Y' THEN
1223: */
1224: INV_ORGHIERARCHY_PVT.Log
1225: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1226: ,to_char(l_errorcode) || l_errortext
1227: );
1228: --END IF;
1229:

Line 1549: INV_ORGHIERARCHY_PVT.Log

1545:
1546:
1547: BEGIN
1548: IF G_DEBUG = 'Y' THEN
1549: INV_ORGHIERARCHY_PVT.Log
1550: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1551: ,'Start of Proc:Org Hierarchy Level Property Access'
1552: );
1553: END IF;

Line 1550: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1546:
1547: BEGIN
1548: IF G_DEBUG = 'Y' THEN
1549: INV_ORGHIERARCHY_PVT.Log
1550: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1551: ,'Start of Proc:Org Hierarchy Level Property Access'
1552: );
1553: END IF;
1554:

Line 1555: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List(p_org_hierarchy_name,

1551: ,'Start of Proc:Org Hierarchy Level Property Access'
1552: );
1553: END IF;
1554:
1555: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List(p_org_hierarchy_name,
1556: p_org_hier_level_id,l_org_code_list);
1557:
1558: IF (p_property_type = 'MASTER') THEN
1559: -- check for unique item master for the organizations

Line 1593: INV_ORGHIERARCHY_PVT.Log

1589:
1590: -- ONE Item Master exists for the given organization hierarchy
1591: l_org_level_property_status := 'Y';
1592: IF G_DEBUG = 'Y' THEN
1593: INV_ORGHIERARCHY_PVT.Log
1594: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1595: ,'Master Org Id: ' || to_char(l_master_orgid)
1596: );
1597: END IF;

Line 1594: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1590: -- ONE Item Master exists for the given organization hierarchy
1591: l_org_level_property_status := 'Y';
1592: IF G_DEBUG = 'Y' THEN
1593: INV_ORGHIERARCHY_PVT.Log
1594: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1595: ,'Master Org Id: ' || to_char(l_master_orgid)
1596: );
1597: END IF;
1598:

Line 1633: INV_ORGHIERARCHY_PVT.Log

1629: END LOOP;
1630: -- ONE Calendar exist for the given organization hierarchy
1631: l_org_level_property_status := 'Y';
1632: IF G_DEBUG = 'Y' THEN
1633: INV_ORGHIERARCHY_PVT.Log
1634: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1635: ,'Calendar: ' || l_period_set_name
1636: );
1637: END IF;

Line 1634: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1630: -- ONE Calendar exist for the given organization hierarchy
1631: l_org_level_property_status := 'Y';
1632: IF G_DEBUG = 'Y' THEN
1633: INV_ORGHIERARCHY_PVT.Log
1634: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1635: ,'Calendar: ' || l_period_set_name
1636: );
1637: END IF;
1638:

Line 1675: INV_ORGHIERARCHY_PVT.Log

1671: -- ONE Chart of Accounts exist for the given organization
1672: -- hierarchy
1673: l_org_level_property_status := 'Y';
1674: IF G_DEBUG = 'Y' THEN
1675: INV_ORGHIERARCHY_PVT.Log
1676: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1677: ,'Chart of Accounts:' || to_char(l_chart_accounts_id)
1678: );
1679: END IF;

Line 1676: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1672: -- hierarchy
1673: l_org_level_property_status := 'Y';
1674: IF G_DEBUG = 'Y' THEN
1675: INV_ORGHIERARCHY_PVT.Log
1676: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1677: ,'Chart of Accounts:' || to_char(l_chart_accounts_id)
1678: );
1679: END IF;
1680:

Line 1686: INV_ORGHIERARCHY_PVT.Log

1682:
1683: RETURN l_org_level_property_status;
1684:
1685: IF G_DEBUG = 'Y' THEN
1686: INV_ORGHIERARCHY_PVT.Log
1687: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1688: ,'End of Proc:Org Hierarchy Level Property Access'
1689: );
1690: END IF;

Line 1687: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1683: RETURN l_org_level_property_status;
1684:
1685: IF G_DEBUG = 'Y' THEN
1686: INV_ORGHIERARCHY_PVT.Log
1687: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1688: ,'End of Proc:Org Hierarchy Level Property Access'
1689: );
1690: END IF;
1691:

Line 1701: INV_ORGHIERARCHY_PVT.Log

1697: Error/Exception logging should not depend on
1698: FND Debug Enabled profile otpion. Bug: 3555234
1699: IF G_DEBUG = 'Y' THEN
1700: */
1701: INV_ORGHIERARCHY_PVT.Log
1702: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1703: ,'More than one item master exists for the Organization Hierarchy'
1704: );
1705: --END IF;

Line 1702: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1698: FND Debug Enabled profile otpion. Bug: 3555234
1699: IF G_DEBUG = 'Y' THEN
1700: */
1701: INV_ORGHIERARCHY_PVT.Log
1702: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1703: ,'More than one item master exists for the Organization Hierarchy'
1704: );
1705: --END IF;
1706: RETURN l_org_level_property_status;

Line 1715: INV_ORGHIERARCHY_PVT.Log

1711: Error/Exception logging should not depend on
1712: FND Debug Enabled profile otpion. Bug: 3555234
1713: IF G_DEBUG = 'Y' THEN
1714: */
1715: INV_ORGHIERARCHY_PVT.Log
1716: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1717: ,'More than one calendar exists for the Organization Hierarchy'
1718: );
1719: --END IF;

Line 1716: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1712: FND Debug Enabled profile otpion. Bug: 3555234
1713: IF G_DEBUG = 'Y' THEN
1714: */
1715: INV_ORGHIERARCHY_PVT.Log
1716: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1717: ,'More than one calendar exists for the Organization Hierarchy'
1718: );
1719: --END IF;
1720: RETURN l_org_level_property_status;

Line 1729: INV_ORGHIERARCHY_PVT.Log

1725: Error/Exception logging should not depend on
1726: FND Debug Enabled profile otpion. Bug: 3555234
1727: IF G_DEBUG = 'Y' THEN
1728: */
1729: INV_ORGHIERARCHY_PVT.Log
1730: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1731: ,'More than one chart of accounts exists for the Organization
1732: Hierarchy'
1733: );

Line 1730: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1726: FND Debug Enabled profile otpion. Bug: 3555234
1727: IF G_DEBUG = 'Y' THEN
1728: */
1729: INV_ORGHIERARCHY_PVT.Log
1730: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1731: ,'More than one chart of accounts exists for the Organization
1732: Hierarchy'
1733: );
1734: --END IF;

Line 1747: INV_ORGHIERARCHY_PVT.Log

1743: FND Debug Enabled profile otpion. Log level has been
1744: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
1745: IF G_DEBUG = 'Y' THEN
1746: */
1747: INV_ORGHIERARCHY_PVT.Log
1748: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1749: ,to_char(l_errorcode) || l_errortext
1750: );
1751: --END IF;

Line 1748: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

1744: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
1745: IF G_DEBUG = 'Y' THEN
1746: */
1747: INV_ORGHIERARCHY_PVT.Log
1748: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1749: ,to_char(l_errorcode) || l_errortext
1750: );
1751: --END IF;
1752: RETURN NULL;

Line 1800: INV_ORGHIERARCHY_PVT.Log

1796: l_errortext VARCHAR2(200);
1797:
1798: BEGIN
1799: IF G_DEBUG = 'Y' THEN
1800: INV_ORGHIERARCHY_PVT.Log
1801: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1802: ,'Start of Proc:Org Hierarchy Level Responsibility Access'
1803: );
1804: END IF;

Line 1801: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1797:
1798: BEGIN
1799: IF G_DEBUG = 'Y' THEN
1800: INV_ORGHIERARCHY_PVT.Log
1801: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1802: ,'Start of Proc:Org Hierarchy Level Responsibility Access'
1803: );
1804: END IF;
1805:

Line 1825: INV_ORGHIERARCHY_PVT.Log

1821: Error/Exception logging should not depend on
1822: FND Debug Enabled profile otpion. Bug: 3555234
1823: IF G_DEBUG = 'Y' THEN
1824: */
1825: INV_ORGHIERARCHY_PVT.Log
1826: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1827: ,'Organization Id expired:' || to_char(p_org_id) ||
1828: 'Business Group Id:' || to_char(p_business_group_id)
1829: );

Line 1826: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1822: FND Debug Enabled profile otpion. Bug: 3555234
1823: IF G_DEBUG = 'Y' THEN
1824: */
1825: INV_ORGHIERARCHY_PVT.Log
1826: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1827: ,'Organization Id expired:' || to_char(p_org_id) ||
1828: 'Business Group Id:' || to_char(p_business_group_id)
1829: );
1830: --END IF;

Line 1865: INV_ORGHIERARCHY_PVT.Log

1861:
1862: END IF; -- for the valid organization
1863:
1864: IF G_DEBUG = 'Y' THEN
1865: INV_ORGHIERARCHY_PVT.Log
1866: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1867: ,'Organization Responsibility Valid Access Flag:'|| l_org_resp_access_flag
1868: );
1869: END IF;

Line 1866: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1862: END IF; -- for the valid organization
1863:
1864: IF G_DEBUG = 'Y' THEN
1865: INV_ORGHIERARCHY_PVT.Log
1866: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1867: ,'Organization Responsibility Valid Access Flag:'|| l_org_resp_access_flag
1868: );
1869: END IF;
1870:

Line 1874: INV_ORGHIERARCHY_PVT.Log

1870:
1871: RETURN l_org_resp_access_flag;
1872:
1873: IF G_DEBUG = 'Y' THEN
1874: INV_ORGHIERARCHY_PVT.Log
1875: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1876: ,'End of Proc:Org Hierarchy Level Responsibility Access'
1877: );
1878: END IF;

Line 1875: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1871: RETURN l_org_resp_access_flag;
1872:
1873: IF G_DEBUG = 'Y' THEN
1874: INV_ORGHIERARCHY_PVT.Log
1875: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1876: ,'End of Proc:Org Hierarchy Level Responsibility Access'
1877: );
1878: END IF;
1879:

Line 1891: INV_ORGHIERARCHY_PVT.Log

1887: FND Debug Enabled profile otpion. Log leve has b een
1888: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
1889: IF G_DEBUG = 'Y' THEN
1890: */
1891: INV_ORGHIERARCHY_PVT.Log
1892: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1893: ,to_char(l_errorcode) || l_errortext
1894: );
1895: --END IF;

Line 1892: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

1888: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
1889: IF G_DEBUG = 'Y' THEN
1890: */
1891: INV_ORGHIERARCHY_PVT.Log
1892: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1893: ,to_char(l_errorcode) || l_errortext
1894: );
1895: --END IF;
1896: RETURN NULL;

Line 1950: INV_ORGHIERARCHY_PVT.Log

1946:
1947: BEGIN
1948:
1949: IF G_DEBUG = 'Y' THEN
1950: INV_ORGHIERARCHY_PVT.Log
1951: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1952: ,'Start of Proc:Org Hierarchy Origin Responsibility Access'
1953: );
1954: END IF;

Line 1951: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1947: BEGIN
1948:
1949: IF G_DEBUG = 'Y' THEN
1950: INV_ORGHIERARCHY_PVT.Log
1951: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1952: ,'Start of Proc:Org Hierarchy Origin Responsibility Access'
1953: );
1954: END IF;
1955:

Line 1973: INV_ORGHIERARCHY_PVT.Log

1969: Error/Exception logging should not depend on
1970: FND Debug Enabled profile otpion. Bug: 3555234
1971: IF G_DEBUG = 'Y' THEN
1972: */
1973: INV_ORGHIERARCHY_PVT.Log
1974: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1975: ,'Organization Id has no access:' || to_char(p_org_id)
1976: );
1977: --END IF;

Line 1974: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1970: FND Debug Enabled profile otpion. Bug: 3555234
1971: IF G_DEBUG = 'Y' THEN
1972: */
1973: INV_ORGHIERARCHY_PVT.Log
1974: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1975: ,'Organization Id has no access:' || to_char(p_org_id)
1976: );
1977: --END IF;
1978: END IF;

Line 1983: INV_ORGHIERARCHY_PVT.Log

1979:
1980: CLOSE c_origin_resp_access;
1981:
1982: IF G_DEBUG = 'Y' THEN
1983: INV_ORGHIERARCHY_PVT.Log
1984: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1985: ,'Origin responsibility access flag:'|| l_origin_resp_access_flag
1986: );
1987: END IF;

Line 1984: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1980: CLOSE c_origin_resp_access;
1981:
1982: IF G_DEBUG = 'Y' THEN
1983: INV_ORGHIERARCHY_PVT.Log
1984: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1985: ,'Origin responsibility access flag:'|| l_origin_resp_access_flag
1986: );
1987: END IF;
1988:

Line 1992: INV_ORGHIERARCHY_PVT.Log

1988:
1989: RETURN l_origin_resp_access_flag;
1990:
1991: IF G_DEBUG = 'Y' THEN
1992: INV_ORGHIERARCHY_PVT.Log
1993: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1994: ,'End of Proc:Org Hierarchy Origin Responsibility Access'
1995: );
1996: END IF;

Line 1993: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1989: RETURN l_origin_resp_access_flag;
1990:
1991: IF G_DEBUG = 'Y' THEN
1992: INV_ORGHIERARCHY_PVT.Log
1993: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1994: ,'End of Proc:Org Hierarchy Origin Responsibility Access'
1995: );
1996: END IF;
1997:

Line 2009: INV_ORGHIERARCHY_PVT.Log

2005: FND Debug Enabled profile otpion. Log level has been
2006: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2007: IF G_DEBUG = 'Y' THEN
2008: */
2009: INV_ORGHIERARCHY_PVT.Log
2010: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2011: ,to_char(l_errorcode) || l_errortext
2012: );
2013: --END IF;

Line 2010: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

2006: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2007: IF G_DEBUG = 'Y' THEN
2008: */
2009: INV_ORGHIERARCHY_PVT.Log
2010: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2011: ,to_char(l_errorcode) || l_errortext
2012: );
2013: --END IF;
2014: RETURN NULL;

Line 2038: INV_ORGHIERARCHY_PVT.Log

2034: l_errortext VARCHAR2(200);
2035:
2036: BEGIN
2037: IF G_DEBUG = 'Y' THEN
2038: INV_ORGHIERARCHY_PVT.Log
2039: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2040: ,'Start of Proc:Org exists in hierarchy'
2041: );
2042: END IF;

Line 2039: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2035:
2036: BEGIN
2037: IF G_DEBUG = 'Y' THEN
2038: INV_ORGHIERARCHY_PVT.Log
2039: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2040: ,'Start of Proc:Org exists in hierarchy'
2041: );
2042: END IF;
2043:

Line 2057: INV_ORGHIERARCHY_PVT.Log

2053: l_org_exists_flag := 'Y';
2054: END IF;
2055:
2056: IF G_DEBUG = 'Y' THEN
2057: INV_ORGHIERARCHY_PVT.Log
2058: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2059: ,'Organization exists flag:'|| l_org_exists_flag
2060: );
2061: END IF;

Line 2058: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2054: END IF;
2055:
2056: IF G_DEBUG = 'Y' THEN
2057: INV_ORGHIERARCHY_PVT.Log
2058: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2059: ,'Organization exists flag:'|| l_org_exists_flag
2060: );
2061: END IF;
2062:

Line 2066: INV_ORGHIERARCHY_PVT.Log

2062:
2063: RETURN l_org_exists_flag;
2064:
2065: IF G_DEBUG = 'Y' THEN
2066: INV_ORGHIERARCHY_PVT.Log
2067: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2068: ,'End of Proc:Org exists in hierarchy'
2069: );
2070: END IF;

Line 2067: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2063: RETURN l_org_exists_flag;
2064:
2065: IF G_DEBUG = 'Y' THEN
2066: INV_ORGHIERARCHY_PVT.Log
2067: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2068: ,'End of Proc:Org exists in hierarchy'
2069: );
2070: END IF;
2071:

Line 2083: INV_ORGHIERARCHY_PVT.Log

2079: FND Debug Enabled profile otpion. Log level has been
2080: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2081: IF G_DEBUG = 'Y' THEN
2082: */
2083: INV_ORGHIERARCHY_PVT.Log
2084: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2085: ,to_char(l_errorcode) || l_errortext
2086: );
2087: --END IF;

Line 2084: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

2080: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2081: IF G_DEBUG = 'Y' THEN
2082: */
2083: INV_ORGHIERARCHY_PVT.Log
2084: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2085: ,to_char(l_errorcode) || l_errortext
2086: );
2087: --END IF;
2088: RETURN NULL;

Line 2112: INV_ORGHIERARCHY_PVT.Log

2108: l_organization_id hr_all_organization_units.organization_id%TYPE;
2109:
2110: BEGIN
2111: IF G_DEBUG = 'Y' THEN
2112: INV_ORGHIERARCHY_PVT.Log
2113: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2114: ,'Start of Proc: Insert hierarchy index list'
2115: );
2116: END IF;

Line 2113: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2109:
2110: BEGIN
2111: IF G_DEBUG = 'Y' THEN
2112: INV_ORGHIERARCHY_PVT.Log
2113: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2114: ,'Start of Proc: Insert hierarchy index list'
2115: );
2116: END IF;
2117:

Line 2125: INV_ORGHIERARCHY_PVT.Log

2121: g_orgid_index_list(l_org_index) := l_organization_id;
2122: END LOOP;
2123:
2124: IF G_DEBUG = 'Y' THEN
2125: INV_ORGHIERARCHY_PVT.Log
2126: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2127: ,'End of Proc: Insert hierarchy index list'
2128: );
2129: END IF;

Line 2126: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2122: END LOOP;
2123:
2124: IF G_DEBUG = 'Y' THEN
2125: INV_ORGHIERARCHY_PVT.Log
2126: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2127: ,'End of Proc: Insert hierarchy index list'
2128: );
2129: END IF;
2130:

Line 2202: END INV_ORGHIERARCHY_PVT;

2198: NULL;
2199: END Log;
2200:
2201:
2202: END INV_ORGHIERARCHY_PVT;