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_ORGHIERARCHY_PVT dependencies on FND_LOG

Line 540: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

536:
537: -- l_business_group_id := TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
538: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);
539:
540: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
541: THEN
542: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
543: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
544: , 'Start of API p_org_hierarchy_name: '|| p_org_hierarchy_name ||

Line 542: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

538: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);
539:
540: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
541: THEN
542: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
543: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
544: , 'Start of API p_org_hierarchy_name: '|| p_org_hierarchy_name ||
545: ':p_org_id :'|| p_org_id ||
546: ':New_Msg:l_business_group_id:' || l_business_group_id

Line 549: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

545: ':p_org_id :'|| p_org_id ||
546: ':New_Msg:l_business_group_id:' || l_business_group_id
547: );
548:
549: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
550: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
551: , 'User :'||fnd_global.user_id||
552: ':Resp :'||fnd_global.resp_id||
553: ':Appl :'||fnd_global.resp_appl_id||

Line 564: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

560: OPEN hierarchy_version_csr;
561: FETCH hierarchy_version_csr INTO l_org_structure_version_id;
562: CLOSE hierarchy_version_csr;
563:
564: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
565: THEN
566: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
567: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
568: , 'l_org_structure_version_id: '|| l_org_structure_version_id

Line 566: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

562: CLOSE hierarchy_version_csr;
563:
564: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
565: THEN
566: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
567: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
568: , 'l_org_structure_version_id: '|| l_org_structure_version_id
569: );
570: END IF;

Line 575: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

571:
572: OPEN hierarchy_contains_csr;
573: FETCH hierarchy_contains_csr INTO l_count;
574:
575: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
576: THEN
577: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
578: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
579: , 'l_count: '|| l_count

Line 577: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

573: FETCH hierarchy_contains_csr INTO l_count;
574:
575: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
576: THEN
577: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
578: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
579: , 'l_count: '|| l_count
580: );
581: END IF;

Line 595: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

591: END IF;
592: --Testfix: Moving this inside
593: --CLOSE hierarchy_contains_csr;
594:
595: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
596: THEN
597: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
598: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
599: , 'Exiting l_contains :'|| l_contains

Line 597: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

593: --CLOSE hierarchy_contains_csr;
594:
595: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
596: THEN
597: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
598: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '
599: , 'Exiting l_contains :'|| l_contains
600: );
601: END IF;

Line 659: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

655: , 'Start of Proc:Org Hierarchy Access'
656: );
657: END IF;
658:
659: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
660: THEN
661: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
662: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
663: , 'Start of Proc:Org Hierarchy Access p_org_hierarchy_name : '||p_org_hierarchy_name

Line 661: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

657: END IF;
658:
659: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
660: THEN
661: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
662: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
663: , 'Start of Proc:Org Hierarchy Access p_org_hierarchy_name : '||p_org_hierarchy_name
664: );
665: END IF;

Line 670: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

666:
667: -- get the profile id of the user
668: l_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');
669:
670: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
671: THEN
672: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
673: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
674: , 'l_profile_id :' ||l_profile_id

Line 672: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

668: l_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');
669:
670: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
671: THEN
672: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
673: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
674: , 'l_profile_id :' ||l_profile_id
675: );
676: END IF;

Line 691: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

687: , 'Security Profile Id is not set for the responsibility');
688:
689: --END IF;
690:
691: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
692: THEN
693: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
694: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
695: , 'Security Profile Id is not set for the responsibility'

Line 693: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

689: --END IF;
690:
691: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
692: THEN
693: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
694: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
695: , 'Security Profile Id is not set for the responsibility'
696: );
697: END IF;

Line 721: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

717: INV_ORGHIERARCHY_PVT.Log
718: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
719: ,'Security Profile not found');
720:
721: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
722: THEN
723: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
724: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
725: , 'Security Profile not found'

Line 723: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

719: ,'Security Profile not found');
720:
721: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
722: THEN
723: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
724: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
725: , 'Security Profile not found'
726: );
727: END IF;

Line 731: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

727: END IF;
728: --END IF;
729: END IF;
730:
731: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
732: THEN
733: INV_ORGHIERARCHY_PVT.Log
734: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
735: ,'Profile Hierarchy Name:' || l_profile_hierarchy_name

Line 744: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

740: || ' Include Top Organization Flag:' ||l_include_top_org_flag
741: || ' Top Organization Id:' || to_char(l_top_organization_id)
742: );
743:
744: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
745: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
746: , 'Profile Hierarchy Name: '||l_profile_hierarchy_name
747: );
748:

Line 749: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

745: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
746: , 'Profile Hierarchy Name: '||l_profile_hierarchy_name
747: );
748:
749: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
750: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
751: , 'View All Organizations Flag: '|| l_view_all_org_flag
752: );
753:

Line 754: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

750: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
751: , 'View All Organizations Flag: '|| l_view_all_org_flag
752: );
753:
754: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
755: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
756: , 'Include Top Organization Flag: '|| l_include_top_org_flag
757: );
758:

Line 759: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

755: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
756: , 'Include Top Organization Flag: '|| l_include_top_org_flag
757: );
758:
759: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
760: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
761: , 'Top Organization Id: '|| to_char(l_top_organization_id)
762: );
763: END IF;

Line 789: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

785:
786: -- initialize the security profile org list index
787: l_security_index := l_security_profile_org_list.FIRST;
788:
789: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
790: THEN
791: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
792: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
793: , 'l_security_index :' || l_security_index

Line 791: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

787: l_security_index := l_security_profile_org_list.FIRST;
788:
789: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
790: THEN
791: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
792: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
793: , 'l_security_index :' || l_security_index
794: );
795: END IF;

Line 804: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

800: -- organization list
801: -- skip the top organization id
802: l_security_index := l_security_index + 1;
803:
804: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
805: THEN
806: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
807: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
808: , 'l_include_top_org_flag is N so increment l_security_index to :' || l_security_index

Line 806: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

802: l_security_index := l_security_index + 1;
803:
804: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
805: THEN
806: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
807: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
808: , 'l_include_top_org_flag is N so increment l_security_index to :' || l_security_index
809: );
810: END IF;

Line 816: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

812:
813: -- To check whether the entered Organization Hierarchy has an access
814: -- for the user
815: WHILE (l_security_index <= l_security_profile_org_list.LAST) LOOP
816: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
817: THEN
818: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
819: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
820: , 'l_security_index :'|| l_security_index

Line 818: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

814: -- for the user
815: WHILE (l_security_index <= l_security_profile_org_list.LAST) LOOP
816: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
817: THEN
818: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
819: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
820: , 'l_security_index :'|| l_security_index
821: );
822: END IF;

Line 827: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

823:
824: l_org_index := l_org_list.FIRST;
825: WHILE (l_org_index <= l_org_list.LAST) LOOP
826:
827: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
828: THEN
829: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
830: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
831: , 'l_org_index :'|| l_org_index ||

Line 829: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

825: WHILE (l_org_index <= l_org_list.LAST) LOOP
826:
827: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
828: THEN
829: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
830: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
831: , 'l_org_index :'|| l_org_index ||
832: ' l_org_list(l_org_index) :' || l_org_list(l_org_index) ||
833: ' l_security_profile_org_list(l_security_index) :'|| l_security_profile_org_list(l_security_index)

Line 854: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

850: -- User has access to view all the organizations.
851: -- Set the org access flag to Y
852: l_org_access_flag := 'Y';
853:
854: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
855: THEN
856: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
857: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
858: , 'User has access to view all the organizations. Setting l_org_access_flag to Y'

Line 856: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

852: l_org_access_flag := 'Y';
853:
854: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
855: THEN
856: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
857: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
858: , 'User has access to view all the organizations. Setting l_org_access_flag to Y'
859: );
860: END IF;

Line 863: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

859: );
860: END IF;
861: END IF;
862:
863: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
864: THEN
865: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
866: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
867: , 'End of INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access returning l_org_access_flag :' ||l_org_access_flag

Line 865: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

861: END IF;
862:
863: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
864: THEN
865: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
866: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
867: , 'End of INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access returning l_org_access_flag :' ||l_org_access_flag
868: );
869: END IF;

Line 895: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

891: ,'Others' || to_char(l_errorcode) || l_errortext
892: );
893: --END IF;
894:
895: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
896: THEN
897: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
898: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
899: , 'Exception in INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access: '||sqlerrm(sqlcode)

Line 897: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

893: --END IF;
894:
895: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
896: THEN
897: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
898: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
899: , 'Exception in INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access: '||sqlerrm(sqlcode)
900: );
901: END IF;

Line 957: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

953: AND pos.organization_structure_id(+) = psp.organization_structure_id;
954:
955:
956: BEGIN
957: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
958: THEN
959: INV_ORGHIERARCHY_PVT.Log
960: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
961: ,'Start of Proc:Org Hierarchy Level Access'

Line 964: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

960: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
961: ,'Start of Proc:Org Hierarchy Level Access'
962: );
963:
964: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
965: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
966: , 'Start of Proc:Org Hierarchy Level Access p_org_hierarchy_name :'|| p_org_hierarchy_name ||' p_org_hier_level_id :'||p_org_hier_level_id
967: );
968: END IF;

Line 977: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

973: RAISE_APPLICATION_ERROR(-20101, 'Security Profile Id is not set for
974: the responsibility');
975: END IF;
976:
977: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
978: THEN
979: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
980: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
981: , 'l_profile_id :'|| l_profile_id

Line 979: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

975: END IF;
976:
977: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
978: THEN
979: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
980: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
981: , 'l_profile_id :'|| l_profile_id
982: );
983: END IF;

Line 993: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

989: l_include_top_org_flag,
990: l_top_organization_id;
991:
992: IF c_profile_hierarchy%NOTFOUND THEN
993: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
994: THEN
995: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
996: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
997: , 'Profile hierarchy name not found'

Line 995: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

991:
992: IF c_profile_hierarchy%NOTFOUND THEN
993: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
994: THEN
995: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
996: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
997: , 'Profile hierarchy name not found'
998: );
999: END IF;

Line 1019: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1015: CLOSE c_profile_hierarchy;
1016:
1017: l_org_level_access_flag := 'N'; -- initialize the access flag
1018:
1019: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1020: THEN
1021: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1022: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1023: , 'l_profile_hierarchy_name :'|| l_profile_hierarchy_name

Line 1021: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1017: l_org_level_access_flag := 'N'; -- initialize the access flag
1018:
1019: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1020: THEN
1021: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1022: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1023: , 'l_profile_hierarchy_name :'|| l_profile_hierarchy_name
1024: );
1025:

Line 1026: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1022: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1023: , 'l_profile_hierarchy_name :'|| l_profile_hierarchy_name
1024: );
1025:
1026: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1027: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1028: , 'l_view_all_org_flag :'|| l_view_all_org_flag
1029: );
1030: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 1030: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1026: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1027: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1028: , 'l_view_all_org_flag :'|| l_view_all_org_flag
1029: );
1030: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1031: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1032: , 'l_include_top_org_flag :'|| l_include_top_org_flag
1033: );
1034: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 1034: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1030: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1031: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1032: , 'l_include_top_org_flag :'|| l_include_top_org_flag
1033: );
1034: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1035: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1036: , 'l_top_organization_id :'|| l_top_organization_id
1037: );
1038: END IF;

Line 1075: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1071:
1072: l_index := l_org_list.FIRST;
1073:
1074: WHILE (l_index <= l_org_list.LAST) LOOP
1075: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1076: THEN
1077: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1078: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1079: , 'l_index :'|| l_index ||' l_org_list(l_index) :'|| l_org_list(l_index)

Line 1077: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1073:
1074: WHILE (l_index <= l_org_list.LAST) LOOP
1075: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1076: THEN
1077: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1078: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1079: , 'l_index :'|| l_index ||' l_org_list(l_index) :'|| l_org_list(l_index)
1080: );
1081: END IF;

Line 1091: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1087: END IF;
1088: l_index := l_org_list.NEXT(l_index);
1089: END LOOP;
1090:
1091: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1092: THEN
1093: INV_ORGHIERARCHY_PVT.Log
1094: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1095: , 'Organization Level Validity flag' ||

Line 1099: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1095: , 'Organization Level Validity flag' ||
1096: l_org_level_validity_flag
1097: );
1098:
1099: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1100: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1101: , 'Organization Level Validity flag :'|| l_org_level_validity_flag
1102: );
1103: END IF;

Line 1120: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1116:
1117: -- initialize the security profile org list index
1118: l_security_index := l_security_profile_org_list.FIRST;
1119:
1120: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1121: THEN
1122: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1123: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1124: , 'l_security_index :'|| l_security_index

Line 1122: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1118: l_security_index := l_security_profile_org_list.FIRST;
1119:
1120: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1121: THEN
1122: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1123: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1124: , 'l_security_index :'|| l_security_index
1125: );
1126: END IF;

Line 1135: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1131: -- organization list
1132: -- skip the top organization id
1133: l_security_index := l_security_index + 1;
1134:
1135: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1136: THEN
1137: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1138: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1139: , 'exclude the top organization from the security profile so incr l_security_index :'|| l_security_index

Line 1137: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1133: l_security_index := l_security_index + 1;
1134:
1135: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1136: THEN
1137: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1138: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1139: , 'exclude the top organization from the security profile so incr l_security_index :'|| l_security_index
1140: );
1141: END IF;

Line 1148: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1144: -- To check whether the entered Organization Hierarchy Level has an
1145: -- access for the user
1146: WHILE (l_security_index <= l_security_profile_org_list.LAST) LOOP
1147:
1148: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1149: THEN
1150: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1151: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1152: , 'l_security_index :'|| l_security_index || ' l_security_profile_org_list(l_security_index) :'|| l_security_profile_org_list(l_security_index)

Line 1150: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1146: WHILE (l_security_index <= l_security_profile_org_list.LAST) LOOP
1147:
1148: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1149: THEN
1150: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1151: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1152: , 'l_security_index :'|| l_security_index || ' l_security_profile_org_list(l_security_index) :'|| l_security_profile_org_list(l_security_index)
1153: );
1154: END IF;

Line 1169: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1165:
1166: ELSIF ((l_profile_hierarchy_name IS NULL) AND
1167: (l_view_all_org_flag = 'Y')) THEN
1168: -- User has access to all the organizations
1169: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1170: THEN
1171: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1172: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1173: , 'User has access to all the organizations '

Line 1171: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1167: (l_view_all_org_flag = 'Y')) THEN
1168: -- User has access to all the organizations
1169: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1170: THEN
1171: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1172: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1173: , 'User has access to all the organizations '
1174: );
1175: END IF;

Line 1183: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1179: ELSE
1180: l_org_level_access_flag := 'N';
1181: END IF;
1182:
1183: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1184: THEN
1185: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1186: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1187: , 'Exiting INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access returning l_org_level_access_flag: '|| l_org_level_access_flag

Line 1185: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1181: END IF;
1182:
1183: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1184: THEN
1185: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1186: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'
1187: , 'Exiting INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access returning l_org_level_access_flag: '|| l_org_level_access_flag
1188: );
1189: END IF;

Line 1220: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1216: IF c_profile_hierarchy%ISOPEN THEN
1217: CLOSE c_profile_hierarchy;
1218: END IF;
1219:
1220: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1221: THEN
1222: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1223: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access ERROR'
1224: , 'Exception :'|| sqlerrm(sqlcode)

Line 1222: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1218: END IF;
1219:
1220: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1221: THEN
1222: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1223: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access ERROR'
1224: , 'Exception :'|| sqlerrm(sqlcode)
1225: );
1226: END IF;

Line 1353: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1349:
1350:
1351: BEGIN
1352:
1353: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1354: THEN
1355: INV_ORGHIERARCHY_PVT.Log
1356: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1357: ,'Start of Proc:Org Hierarchy List'

Line 1360: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1356: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1357: ,'Start of Proc:Org Hierarchy List'
1358: );
1359:
1360: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1361: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1362: , 'Start of the API p_org_hierarchy_name :'|| p_org_hierarchy_name ||' p_org_hier_level_id :'|| p_org_hier_level_id
1363: );
1364: END IF;

Line 1371: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1367: -- Using fnd_global.per_business_group_id instead.
1368: -- l_business_group_id := TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
1369: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);
1370:
1371: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1372: THEN
1373: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1374: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1375: , 'l_business_group_id :'|| l_business_group_id

Line 1373: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1369: l_business_group_id := TO_NUMBER(FND_GLOBAL.per_business_group_id);
1370:
1371: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1372: THEN
1373: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1374: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1375: , 'l_business_group_id :'|| l_business_group_id
1376: );
1377: END IF;

Line 1392: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1388: INTO l_structure_version_id,
1389: l_business_group_id;
1390:
1391: IF c_organization_version%NOTFOUND THEN
1392: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1393: THEN
1394: INV_ORGHIERARCHY_PVT.Log
1395: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1396: ,'Organization Version Id:'||to_char(l_structure_version_id)

Line 1399: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1395: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1396: ,'Organization Version Id:'||to_char(l_structure_version_id)
1397: );
1398:
1399: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1400: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1401: , 'Organization structure version id not found '
1402: );
1403: END IF;

Line 1411: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1407: END IF;
1408:
1409: CLOSE c_organization_version;
1410:
1411: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1412: THEN
1413: INV_ORGHIERARCHY_PVT.Log
1414: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1415: ,'Organization Version Id:' || to_char(l_structure_version_id)

Line 1423: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1419: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1420: ,'Business Group Id:' || to_char(l_business_group_id)
1421: );
1422:
1423: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1424: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1425: , 'l_structure_version_id: '||l_structure_version_id
1426: );
1427:

Line 1428: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1424: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1425: , 'l_structure_version_id: '||l_structure_version_id
1426: );
1427:
1428: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1429: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1430: , 'l_business_group_id: '|| l_business_group_id
1431: );
1432: END IF;

Line 1442: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1438: OPEN c_parent_organization(l_structure_version_id);
1439: FETCH c_parent_organization INTO l_org_hierarchy_parent_id;
1440:
1441: IF c_parent_organization%NOTFOUND THEN
1442: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1443: THEN
1444: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1445: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1446: , 'Parent organization Id not found when hierarchy level is null'

Line 1444: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1440:
1441: IF c_parent_organization%NOTFOUND THEN
1442: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1443: THEN
1444: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1445: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1446: , 'Parent organization Id not found when hierarchy level is null'
1447: );
1448: END IF;

Line 1470: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1466:
1467: -- get the responsibility id
1468: l_user_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
1469:
1470: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1471: THEN
1472: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1473: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1474: , 'l_user_resp_id :' || l_user_resp_id

Line 1472: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1468: l_user_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
1469:
1470: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1471: THEN
1472: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1473: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1474: , 'l_user_resp_id :' || l_user_resp_id
1475: );
1476: END IF;

Line 1486: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1482: l_business_group_id,
1483: l_user_resp_id) = 'Y') THEN
1484:
1485: -- include the parent organization code in the dynamic table
1486: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1487: THEN
1488: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1489: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1490: , 'Adding parent org :'||l_org_hierarchy_parent_id||' to the dynamic table'

Line 1488: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1484:
1485: -- include the parent organization code in the dynamic table
1486: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1487: THEN
1488: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1489: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1490: , 'Adding parent org :'||l_org_hierarchy_parent_id||' to the dynamic table'
1491: );
1492: END IF;

Line 1517: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1513:
1514: l_orgcode := v_organizations.organization_id_child;
1515: l_level := v_organizations.level;
1516:
1517: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1518: THEN
1519: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1520: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1521: , 'Checking for valid org resp access for l_orgcode :'|| l_orgcode||

Line 1519: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1515: l_level := v_organizations.level;
1516:
1517: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1518: THEN
1519: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1520: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1521: , 'Checking for valid org resp access for l_orgcode :'|| l_orgcode||
1522: ' l_business_group_id :'|| l_business_group_id ||
1523: ' l_user_resp_id :'|| l_user_resp_id ||

Line 1537: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1533:
1534: list_id := list_id + 1;
1535: x_org_code_list( list_id ) := l_orgcode;
1536:
1537: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1538: THEN
1539: INV_ORGHIERARCHY_PVT.Log
1540: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1541: , 'Organization Hierarchy Code:'||LPAD(' ', 6 * (l_level - 1))||

Line 1545: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1541: , 'Organization Hierarchy Code:'||LPAD(' ', 6 * (l_level - 1))||
1542: to_char(x_org_code_list(list_id))
1543: );
1544:
1545: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1546: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1547: , 'Access prrsent adding :'|| LPAD(' ', 6 * (l_level - 1))|| to_char(x_org_code_list(list_id))
1548: );
1549: END IF;

Line 1556: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1552:
1553: END LOOP;
1554:
1555: IF l_orgcode is NULL THEN
1556: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1557: THEN
1558: INV_ORGHIERARCHY_PVT.Log
1559: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1560: ,'No Valid Child exist for the parent organization code:' ||

Line 1564: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1560: ,'No Valid Child exist for the parent organization code:' ||
1561: to_char(l_org_hierarchy_parent_id)
1562: );
1563:
1564: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1565: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1566: , 'No Valid Child exist for the parent organization code:'|| to_char(l_org_hierarchy_parent_id)
1567: );
1568: END IF;

Line 1571: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1567: );
1568: END IF;
1569: END IF;
1570:
1571: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1572: THEN
1573: INV_ORGHIERARCHY_PVT.Log
1574: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1575: ,'End of Proc:Org Hierarchy List'

Line 1578: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1574: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1575: ,'End of Proc:Org Hierarchy List'
1576: );
1577:
1578: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1579: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '
1580: , 'Exiting Org_Hierarchy_List '
1581: );
1582: END IF;

Line 2177: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2173: l_errorcode NUMBER;
2174: l_errortext VARCHAR2(200);
2175:
2176: BEGIN
2177: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2178: THEN
2179: INV_ORGHIERARCHY_PVT.Log
2180: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2181: ,'Start of Proc:Org Hierarchy Level Responsibility Access'

Line 2184: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2180: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2181: ,'Start of Proc:Org Hierarchy Level Responsibility Access'
2182: );
2183:
2184: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2185: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2186: , 'Start of Proc: p_org_id :'|| p_org_id ||' p_business_group_id :'|| p_business_group_id ||' p_responsibility_id :'|| p_responsibility_id
2187: );
2188: END IF;

Line 2205: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2201: OPEN c_unxpire_organization(p_org_id,p_business_group_id);
2202: FETCH c_unxpire_organization INTO l_org_valid_flag;
2203:
2204: IF c_unxpire_organization%NOTFOUND THEN
2205: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2206: THEN
2207: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2208: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2209: , 'c_unxpire_organization%NOTFOUND organization expired '

Line 2207: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2203:
2204: IF c_unxpire_organization%NOTFOUND THEN
2205: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2206: THEN
2207: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2208: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2209: , 'c_unxpire_organization%NOTFOUND organization expired '
2210: );
2211: END IF;

Line 2237: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2233: OPEN c_unxpire_organization_global(p_org_id);
2234: FETCH c_unxpire_organization_global INTO l_org_valid_flag;
2235:
2236: IF c_unxpire_organization_global%NOTFOUND THEN
2237: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2238: THEN
2239: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2240: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2241: , 'c_unxpire_organization_global%NOTFOUND organization expired '

Line 2239: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2235:
2236: IF c_unxpire_organization_global%NOTFOUND THEN
2237: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2238: THEN
2239: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2240: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2241: , 'c_unxpire_organization_global%NOTFOUND organization expired '
2242: );
2243: END IF;

Line 2265: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2261: END IF;
2262:
2263: --Bug 9775787. End code changes.
2264:
2265: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2266: THEN
2267: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2268: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2269: , 'l_org_valid_flag :'|| l_org_valid_flag

Line 2267: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2263: --Bug 9775787. End code changes.
2264:
2265: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2266: THEN
2267: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2268: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2269: , 'l_org_valid_flag :'|| l_org_valid_flag
2270: );
2271: END IF;

Line 2309: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2305: ,'Organization Responsibility Valid Access Flag:'|| l_org_resp_access_flag
2306: );
2307: END IF;
2308:
2309: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2310: THEN
2311: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2312: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2313: , 'Exiting l_org_resp_access_flag :'|| l_org_resp_access_flag

Line 2311: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2307: END IF;
2308:
2309: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2310: THEN
2311: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2312: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '
2313: , 'Exiting l_org_resp_access_flag :'|| l_org_resp_access_flag
2314: );
2315: END IF;

Line 2403: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2399: l_errortext VARCHAR2(200);
2400:
2401: BEGIN
2402:
2403: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2404: THEN
2405: INV_ORGHIERARCHY_PVT.Log
2406: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2407: ,'Start of Proc:Org Hierarchy Origin Responsibility Access'

Line 2410: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2406: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2407: ,'Start of Proc:Org Hierarchy Origin Responsibility Access'
2408: );
2409:
2410: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2411: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '
2412: , 'Start of API p_org_id :'|| p_org_id ||' p_responsibility_id :'|| p_responsibility_id
2413: );
2414: END IF;

Line 2425: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2421: OPEN c_origin_resp_access(p_org_id, p_responsibility_id);
2422: FETCH c_origin_resp_access INTO l_origin_resp_access_flag;
2423:
2424: IF c_origin_resp_access%NOTFOUND THEN
2425: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2426: THEN
2427: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2428: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '
2429: , 'c_origin_resp_access%NOTFOUND Org has no access '

Line 2427: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2423:
2424: IF c_origin_resp_access%NOTFOUND THEN
2425: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2426: THEN
2427: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2428: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '
2429: , 'c_origin_resp_access%NOTFOUND Org has no access '
2430: );
2431: END IF;

Line 2449: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2445: END IF;
2446:
2447: CLOSE c_origin_resp_access;
2448:
2449: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2450: THEN
2451: INV_ORGHIERARCHY_PVT.Log
2452: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2453: ,'Origin responsibility access flag:'|| l_origin_resp_access_flag

Line 2456: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2452: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2453: ,'Origin responsibility access flag:'|| l_origin_resp_access_flag
2454: );
2455:
2456: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2457: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '
2458: , 'l_origin_resp_access_flag :' || l_origin_resp_access_flag
2459: );
2460: END IF;

Line 2462: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2458: , 'l_origin_resp_access_flag :' || l_origin_resp_access_flag
2459: );
2460: END IF;
2461:
2462: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2463: THEN
2464: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2465: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '
2466: , 'Exiting l_origin_resp_access_flag :'||l_origin_resp_access_flag

Line 2464: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2460: END IF;
2461:
2462: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2463: THEN
2464: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2465: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '
2466: , 'Exiting l_origin_resp_access_flag :'||l_origin_resp_access_flag
2467: );
2468: END IF;

Line 2500: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2496: IF c_origin_resp_access%ISOPEN THEN
2497: CLOSE c_origin_resp_access;
2498: END IF;
2499:
2500: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2501: THEN
2502: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2503: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '
2504: , 'Exception :'||sqlerrm(sqlcode)

Line 2502: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2498: END IF;
2499:
2500: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2501: THEN
2502: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2503: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '
2504: , 'Exception :'||sqlerrm(sqlcode)
2505: );
2506: END IF;

Line 2531: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2527: l_errorcode NUMBER;
2528: l_errortext VARCHAR2(200);
2529:
2530: BEGIN
2531: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2532: THEN
2533: INV_ORGHIERARCHY_PVT.Log
2534: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2535: ,'Start of Proc:Org exists in hierarchy'

Line 2538: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2534: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2535: ,'Start of Proc:Org exists in hierarchy'
2536: );
2537:
2538: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2539: , 'INV_ORGHIERARCHY_PVT.Org_exists_in_hierarchy '
2540: , 'Start of API p_organization_id :'|| p_organization_id
2541: );
2542: END IF;

Line 2556: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2552: IF g_orgid_index_list.EXISTS(l_org_index) THEN
2553: l_org_exists_flag := 'Y';
2554: END IF;
2555:
2556: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2557: THEN
2558: INV_ORGHIERARCHY_PVT.Log
2559: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2560: ,'Organization exists flag:'|| l_org_exists_flag

Line 2563: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

2559: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2560: ,'Organization exists flag:'|| l_org_exists_flag
2561: );
2562:
2563: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
2564: , 'INV_ORGHIERARCHY_PVT.Org_exists_in_hierarchy '
2565: , 'Organization exists flag :' || l_org_exists_flag
2566: );
2567: END IF;