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 INV_ORGHIERARCHY_PVT

Line 1: PACKAGE BODY INV_ORGHIERARCHY_PVT AS

1: PACKAGE BODY INV_ORGHIERARCHY_PVT AS
2: /* $Header: INVVORGB.pls 120.4.12020000.2 2013/04/02 13:40:30 abhissri ship $ */
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 543: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '

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

Line 550: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '

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||
554: ':New_Msg:Business Grp :'||fnd_global.per_business_group_id

Line 567: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '

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;
571:

Line 578: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '

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;
582:

Line 598: , 'INV_ORGHIERARCHY_PVT.contained_in_hierarchy '

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;
602:

Line 653: INV_ORGHIERARCHY_PVT.Log

649: AND pos.organization_structure_id(+) = psp.organization_structure_id;
650:
651: BEGIN
652: IF G_DEBUG = 'Y' THEN
653: INV_ORGHIERARCHY_PVT.Log
654: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
655: , 'Start of Proc:Org Hierarchy Access'
656: );
657: END IF;

Line 654: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

650:
651: BEGIN
652: IF G_DEBUG = 'Y' THEN
653: INV_ORGHIERARCHY_PVT.Log
654: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
655: , 'Start of Proc:Org Hierarchy Access'
656: );
657: END IF;
658:

Line 662: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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;
666:

Line 673: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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;
677:

Line 685: INV_ORGHIERARCHY_PVT.Log

681: Error/Exception logging should not depend on
682: FND Debug Enabled profile otpion. Bug: 3555234
683: IF G_DEBUG = 'Y' THEN
684: */
685: INV_ORGHIERARCHY_PVT.Log
686: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
687: , 'Security Profile Id is not set for the responsibility');
688:
689: --END IF;

Line 686: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR

682: FND Debug Enabled profile otpion. Bug: 3555234
683: IF G_DEBUG = 'Y' THEN
684: */
685: INV_ORGHIERARCHY_PVT.Log
686: ( INV_ORGHIERARCHY_PVT.G_LOG_ERROR
687: , 'Security Profile Id is not set for the responsibility');
688:
689: --END IF;
690:

Line 694: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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;
698:

Line 717: INV_ORGHIERARCHY_PVT.Log

713: Error/Exception logging should not depend on
714: FND Debug Enabled profile otpion. Bug: 3555234
715: IF G_DEBUG = 'Y' THEN
716: */
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)

Line 718: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

714: FND Debug Enabled profile otpion. Bug: 3555234
715: IF G_DEBUG = 'Y' THEN
716: */
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

Line 724: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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

Line 733: INV_ORGHIERARCHY_PVT.Log

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
736: );
737: INV_ORGHIERARCHY_PVT.Log

Line 734: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

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
736: );
737: INV_ORGHIERARCHY_PVT.Log
738: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 737: INV_ORGHIERARCHY_PVT.Log

733: INV_ORGHIERARCHY_PVT.Log
734: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
735: ,'Profile Hierarchy Name:' || l_profile_hierarchy_name
736: );
737: INV_ORGHIERARCHY_PVT.Log
738: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
739: ,'View All Organizations Flag:' || l_view_all_org_flag
740: || ' Include Top Organization Flag:' ||l_include_top_org_flag
741: || ' Top Organization Id:' || to_char(l_top_organization_id)

Line 738: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

734: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
735: ,'Profile Hierarchy Name:' || l_profile_hierarchy_name
736: );
737: INV_ORGHIERARCHY_PVT.Log
738: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
739: ,'View All Organizations Flag:' || l_view_all_org_flag
740: || ' Include Top Organization Flag:' ||l_include_top_org_flag
741: || ' Top Organization Id:' || to_char(l_top_organization_id)
742: );

Line 745: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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:
749: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 750: , '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:
754: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 755: , '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:
759: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 760: , '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;
764:

Line 772: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List

768: (l_view_all_org_flag = 'N')) THEN
769:
770: -- Obtain List of Organizations for the Security profile Org
771: -- Hierarchy Name starting from the top organization
772: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List
773: ( l_profile_hierarchy_name
774: , l_top_organization_id
775: , l_security_profile_org_list
776: );

Line 780: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List

776: );
777:
778: -- Obtain List of Organizations for the Org Hierarchy Name
779: -- where hierarchy level id is null
780: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List
781: ( p_org_hierarchy_name
782: , l_org_hier_level_id
783: , l_org_list
784: );

Line 792: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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;
796:

Line 807: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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

Line 819: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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;
823:

Line 830: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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

Line 857: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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

Line 866: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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;
870:

Line 867: , 'End of INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access returning l_org_access_flag :' ||l_org_access_flag

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;
870:
871: RETURN l_org_access_flag;

Line 874: INV_ORGHIERARCHY_PVT.Log

870:
871: RETURN l_org_access_flag;
872:
873: IF G_DEBUG = 'Y' THEN
874: INV_ORGHIERARCHY_PVT.Log
875: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
876: ,'End of Proc:Org Hierarchy Access'
877: );
878: END IF;

Line 875: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

871: RETURN l_org_access_flag;
872:
873: IF G_DEBUG = 'Y' THEN
874: INV_ORGHIERARCHY_PVT.Log
875: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
876: ,'End of Proc:Org Hierarchy Access'
877: );
878: END IF;
879:

Line 889: INV_ORGHIERARCHY_PVT.Log

885: Error/Exception logging should not depend on
886: FND Debug Enabled profile otpion. Bug: 3555234
887: IF G_DEBUG = 'Y' THEN
888: */
889: INV_ORGHIERARCHY_PVT.Log
890: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
891: ,'Others' || to_char(l_errorcode) || l_errortext
892: );
893: --END IF;

Line 890: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

886: FND Debug Enabled profile otpion. Bug: 3555234
887: IF G_DEBUG = 'Y' THEN
888: */
889: INV_ORGHIERARCHY_PVT.Log
890: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
891: ,'Others' || to_char(l_errorcode) || l_errortext
892: );
893: --END IF;
894:

Line 898: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'

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;
902:

Line 899: , 'Exception in INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access: '||sqlerrm(sqlcode)

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;
902:
903: RETURN NULL;

Line 959: INV_ORGHIERARCHY_PVT.Log

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

Line 960: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

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'
962: );
963:
964: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 965: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
969: -- get the profile id of the user

Line 980: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
984:

Line 996: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
1000:

Line 1008: INV_ORGHIERARCHY_PVT.Log

1004: Error/Exception logging should not depend on
1005: FND Debug Enabled profile otpion. Bug: 3555234
1006: IF G_DEBUG = 'Y' THEN
1007: */
1008: INV_ORGHIERARCHY_PVT.Log
1009: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1010: ,'Profile hierarchy name not found'
1011: );
1012: --END IF;

Line 1009: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1005: FND Debug Enabled profile otpion. Bug: 3555234
1006: IF G_DEBUG = 'Y' THEN
1007: */
1008: INV_ORGHIERARCHY_PVT.Log
1009: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1010: ,'Profile hierarchy name not found'
1011: );
1012: --END IF;
1013: END IF;

Line 1022: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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:
1026: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 1027: , '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
1031: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

Line 1031: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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
1035: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

Line 1035: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
1039:

Line 1065: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List

1061:
1062:
1063: -- Obtain List of Organizations for the Organization Hierarchy Name
1064: -- where hierarchy level id is null
1065: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List
1066: (p_org_hierarchy_name,l_org_hier_level_id,l_org_list);
1067:
1068: -- To check whether the entered Organization Hierarchy Level Id is
1069: -- within the entered organization hierarchy name

Line 1078: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
1082:

Line 1093: INV_ORGHIERARCHY_PVT.Log

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' ||
1096: l_org_level_validity_flag
1097: );

Line 1094: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

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' ||
1096: l_org_level_validity_flag
1097: );
1098:

Line 1100: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
1104:

Line 1113: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List

1109: (l_view_all_org_flag = 'N')) THEN
1110:
1111: -- Obtain List of Organizations for the Security profile Org
1112: -- Hierarchy Name
1113: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List
1114: (l_profile_hierarchy_name,l_top_organization_id,
1115: l_security_profile_org_list);
1116:
1117: -- initialize the security profile org list index

Line 1123: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
1127:

Line 1138: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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

Line 1151: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
1155:

Line 1172: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
1176:

Line 1186: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access'

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;
1190:

Line 1187: , 'Exiting INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access returning l_org_level_access_flag: '|| l_org_level_access_flag

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;
1190:
1191: RETURN l_org_level_access_flag;

Line 1194: INV_ORGHIERARCHY_PVT.Log

1190:
1191: RETURN l_org_level_access_flag;
1192:
1193: IF G_DEBUG = 'Y' THEN
1194: INV_ORGHIERARCHY_PVT.Log
1195: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1196: ,'End of Proc:Org Hierarchy Level Access'
1197: );
1198: END IF;

Line 1195: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1191: RETURN l_org_level_access_flag;
1192:
1193: IF G_DEBUG = 'Y' THEN
1194: INV_ORGHIERARCHY_PVT.Log
1195: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1196: ,'End of Proc:Org Hierarchy Level Access'
1197: );
1198: END IF;
1199:

Line 1210: INV_ORGHIERARCHY_PVT.Log

1206: Error/Exception logging should not depend on
1207: FND Debug Enabled profile otpion. Bug: 3555234
1208: IF G_DEBUG = 'Y' THEN
1209: */
1210: INV_ORGHIERARCHY_PVT.Log
1211: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1212: ,to_char(l_errorcode) || l_errortext
1213: );
1214: --END IF;

Line 1211: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

1207: FND Debug Enabled profile otpion. Bug: 3555234
1208: IF G_DEBUG = 'Y' THEN
1209: */
1210: INV_ORGHIERARCHY_PVT.Log
1211: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1212: ,to_char(l_errorcode) || l_errortext
1213: );
1214: --END IF;
1215:

Line 1223: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Level_Access ERROR'

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;
1227:

Line 1355: INV_ORGHIERARCHY_PVT.Log

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

Line 1356: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

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'
1358: );
1359:
1360: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 1361: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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;
1365:

Line 1374: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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;
1378:

Line 1380: INV_ORGHIERARCHY_PVT.Log

1376: );
1377: END IF;
1378:
1379: IF G_DEBUG = 'Y' THEN
1380: INV_ORGHIERARCHY_PVT.Log
1381: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1382: ,'Business Group Id:'||to_char(l_business_group_id)
1383: );
1384: END IF;

Line 1381: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1377: END IF;
1378:
1379: IF G_DEBUG = 'Y' THEN
1380: INV_ORGHIERARCHY_PVT.Log
1381: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1382: ,'Business Group Id:'||to_char(l_business_group_id)
1383: );
1384: END IF;
1385:

Line 1394: INV_ORGHIERARCHY_PVT.Log

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)
1397: );
1398:

Line 1395: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

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)
1397: );
1398:
1399: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 1400: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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;
1404:

Line 1413: INV_ORGHIERARCHY_PVT.Log

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)
1416: );
1417:

Line 1414: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

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)
1416: );
1417:
1418: INV_ORGHIERARCHY_PVT.Log

Line 1418: INV_ORGHIERARCHY_PVT.Log

1414: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1415: ,'Organization Version Id:' || to_char(l_structure_version_id)
1416: );
1417:
1418: INV_ORGHIERARCHY_PVT.Log
1419: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1420: ,'Business Group Id:' || to_char(l_business_group_id)
1421: );
1422:

Line 1419: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1415: ,'Organization Version Id:' || to_char(l_structure_version_id)
1416: );
1417:
1418: INV_ORGHIERARCHY_PVT.Log
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

Line 1424: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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:
1428: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 1429: , '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;
1433:

Line 1445: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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;
1449:

Line 1457: INV_ORGHIERARCHY_PVT.Log

1453: Error/Exception logging should not depend on
1454: FND Debug Enabled profile otpion. Bug: 3555234
1455: IF G_DEBUG = 'Y' THEN
1456: */
1457: INV_ORGHIERARCHY_PVT.Log
1458: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1459: ,'Parent Organization Id not found when hierarchy level null'
1460: );
1461: -- END IF;

Line 1458: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

1454: FND Debug Enabled profile otpion. Bug: 3555234
1455: IF G_DEBUG = 'Y' THEN
1456: */
1457: INV_ORGHIERARCHY_PVT.Log
1458: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
1459: ,'Parent Organization Id not found when hierarchy level null'
1460: );
1461: -- END IF;
1462: END IF;

Line 1473: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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;
1477:

Line 1480: IF (INV_ORGHIERARCHY_PVT.

1476: END IF;
1477:
1478: -- check whether the parent organization id is unexpired and
1479: -- has an access to the current user responsibility
1480: IF (INV_ORGHIERARCHY_PVT.
1481: Org_Hier_Level_Resp_Access(l_org_hierarchy_parent_id,
1482: l_business_group_id,
1483: l_user_resp_id) = 'Y') THEN
1484:

Line 1489: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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;
1493:

Line 1498: INV_ORGHIERARCHY_PVT.Log

1494: list_id := list_id + 1;
1495: x_org_code_list(list_id) := l_org_hierarchy_parent_id;
1496:
1497: IF G_DEBUG = 'Y' THEN
1498: INV_ORGHIERARCHY_PVT.Log
1499: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1500: ,'Parent Organization Hierarchy Code:' ||
1501: to_char(x_org_code_list(list_id))
1502: );

Line 1499: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1495: x_org_code_list(list_id) := l_org_hierarchy_parent_id;
1496:
1497: IF G_DEBUG = 'Y' THEN
1498: INV_ORGHIERARCHY_PVT.Log
1499: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1500: ,'Parent Organization Hierarchy Code:' ||
1501: to_char(x_org_code_list(list_id))
1502: );
1503: END IF;

Line 1520: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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 ||
1524: ' l_level :'|| l_level

Line 1529: IF (INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access

1525: );
1526: END IF;
1527:
1528: -- check for valid organization and user responsibility access
1529: IF (INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access
1530: (l_orgcode,
1531: l_business_group_id,
1532: l_user_resp_id ) = 'Y' ) THEN
1533:

Line 1539: INV_ORGHIERARCHY_PVT.Log

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))||
1542: to_char(x_org_code_list(list_id))
1543: );

Line 1540: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

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))||
1542: to_char(x_org_code_list(list_id))
1543: );
1544:

Line 1546: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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;
1550:

Line 1558: INV_ORGHIERARCHY_PVT.Log

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:' ||
1561: to_char(l_org_hierarchy_parent_id)
1562: );

Line 1559: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

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:' ||
1561: to_char(l_org_hierarchy_parent_id)
1562: );
1563:

Line 1565: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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

Line 1573: INV_ORGHIERARCHY_PVT.Log

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

Line 1574: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

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'
1576: );
1577:
1578: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 1579: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_List '

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;
1583:

Line 1594: INV_ORGHIERARCHY_PVT.Log

1590: FND Debug Enabled profile otpion. Log level has been
1591: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
1592: IF G_DEBUG = 'Y' THEN
1593: */
1594: INV_ORGHIERARCHY_PVT.Log
1595: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1596: ,to_char(l_errorcode) || l_errortext
1597: );
1598: --END IF;

Line 1595: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

1591: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
1592: IF G_DEBUG = 'Y' THEN
1593: */
1594: INV_ORGHIERARCHY_PVT.Log
1595: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
1596: ,to_char(l_errorcode) || l_errortext
1597: );
1598: --END IF;
1599:

Line 1926: INV_ORGHIERARCHY_PVT.Log

1922:
1923:
1924: BEGIN
1925: IF G_DEBUG = 'Y' THEN
1926: INV_ORGHIERARCHY_PVT.Log
1927: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1928: ,'Start of Proc:Org Hierarchy Level Property Access'
1929: );
1930: END IF;

Line 1927: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

1923:
1924: BEGIN
1925: IF G_DEBUG = 'Y' THEN
1926: INV_ORGHIERARCHY_PVT.Log
1927: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
1928: ,'Start of Proc:Org Hierarchy Level Property Access'
1929: );
1930: END IF;
1931:

Line 1932: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List(p_org_hierarchy_name,

1928: ,'Start of Proc:Org Hierarchy Level Property Access'
1929: );
1930: END IF;
1931:
1932: INV_ORGHIERARCHY_PVT.Org_Hierarchy_List(p_org_hierarchy_name,
1933: p_org_hier_level_id,l_org_code_list);
1934:
1935: IF (p_property_type = 'MASTER') THEN
1936: -- check for unique item master for the organizations

Line 1968: INV_ORGHIERARCHY_PVT.Log

1964:
1965: -- ONE Item Master exists for the given organization hierarchy
1966: l_org_level_property_status := 'Y';
1967: IF G_DEBUG = 'Y' THEN
1968: INV_ORGHIERARCHY_PVT.Log
1969: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1970: ,'Master Org Id: ' || to_char(l_master_orgid)
1971: );
1972: END IF;

Line 1969: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1965: -- ONE Item Master exists for the given organization hierarchy
1966: l_org_level_property_status := 'Y';
1967: IF G_DEBUG = 'Y' THEN
1968: INV_ORGHIERARCHY_PVT.Log
1969: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1970: ,'Master Org Id: ' || to_char(l_master_orgid)
1971: );
1972: END IF;
1973:

Line 2006: INV_ORGHIERARCHY_PVT.Log

2002: END LOOP;
2003: -- ONE Calendar exist for the given organization hierarchy
2004: l_org_level_property_status := 'Y';
2005: IF G_DEBUG = 'Y' THEN
2006: INV_ORGHIERARCHY_PVT.Log
2007: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2008: ,'Calendar: ' || l_period_set_name
2009: );
2010: END IF;

Line 2007: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2003: -- ONE Calendar exist for the given organization hierarchy
2004: l_org_level_property_status := 'Y';
2005: IF G_DEBUG = 'Y' THEN
2006: INV_ORGHIERARCHY_PVT.Log
2007: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2008: ,'Calendar: ' || l_period_set_name
2009: );
2010: END IF;
2011:

Line 2046: INV_ORGHIERARCHY_PVT.Log

2042: -- ONE Chart of Accounts exist for the given organization
2043: -- hierarchy
2044: l_org_level_property_status := 'Y';
2045: IF G_DEBUG = 'Y' THEN
2046: INV_ORGHIERARCHY_PVT.Log
2047: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2048: ,'Chart of Accounts:' || to_char(l_chart_accounts_id)
2049: );
2050: END IF;

Line 2047: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2043: -- hierarchy
2044: l_org_level_property_status := 'Y';
2045: IF G_DEBUG = 'Y' THEN
2046: INV_ORGHIERARCHY_PVT.Log
2047: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2048: ,'Chart of Accounts:' || to_char(l_chart_accounts_id)
2049: );
2050: END IF;
2051:

Line 2057: INV_ORGHIERARCHY_PVT.Log

2053:
2054: RETURN l_org_level_property_status;
2055:
2056: IF G_DEBUG = 'Y' THEN
2057: INV_ORGHIERARCHY_PVT.Log
2058: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2059: ,'End of Proc:Org Hierarchy Level Property Access'
2060: );
2061: END IF;

Line 2058: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2054: RETURN l_org_level_property_status;
2055:
2056: IF G_DEBUG = 'Y' THEN
2057: INV_ORGHIERARCHY_PVT.Log
2058: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2059: ,'End of Proc:Org Hierarchy Level Property Access'
2060: );
2061: END IF;
2062:

Line 2072: INV_ORGHIERARCHY_PVT.Log

2068: Error/Exception logging should not depend on
2069: FND Debug Enabled profile otpion. Bug: 3555234
2070: IF G_DEBUG = 'Y' THEN
2071: */
2072: INV_ORGHIERARCHY_PVT.Log
2073: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2074: ,'More than one item master exists for the Organization Hierarchy'
2075: );
2076: --END IF;

Line 2073: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

2069: FND Debug Enabled profile otpion. Bug: 3555234
2070: IF G_DEBUG = 'Y' THEN
2071: */
2072: INV_ORGHIERARCHY_PVT.Log
2073: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2074: ,'More than one item master exists for the Organization Hierarchy'
2075: );
2076: --END IF;
2077: RETURN l_org_level_property_status;

Line 2086: INV_ORGHIERARCHY_PVT.Log

2082: Error/Exception logging should not depend on
2083: FND Debug Enabled profile otpion. Bug: 3555234
2084: IF G_DEBUG = 'Y' THEN
2085: */
2086: INV_ORGHIERARCHY_PVT.Log
2087: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2088: ,'More than one calendar exists for the Organization Hierarchy'
2089: );
2090: --END IF;

Line 2087: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

2083: FND Debug Enabled profile otpion. Bug: 3555234
2084: IF G_DEBUG = 'Y' THEN
2085: */
2086: INV_ORGHIERARCHY_PVT.Log
2087: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2088: ,'More than one calendar exists for the Organization Hierarchy'
2089: );
2090: --END IF;
2091: RETURN l_org_level_property_status;

Line 2100: INV_ORGHIERARCHY_PVT.Log

2096: Error/Exception logging should not depend on
2097: FND Debug Enabled profile otpion. Bug: 3555234
2098: IF G_DEBUG = 'Y' THEN
2099: */
2100: INV_ORGHIERARCHY_PVT.Log
2101: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2102: ,'More than one chart of accounts exists for the Organization
2103: Hierarchy'
2104: );

Line 2101: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

2097: FND Debug Enabled profile otpion. Bug: 3555234
2098: IF G_DEBUG = 'Y' THEN
2099: */
2100: INV_ORGHIERARCHY_PVT.Log
2101: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2102: ,'More than one chart of accounts exists for the Organization
2103: Hierarchy'
2104: );
2105: --END IF;

Line 2118: INV_ORGHIERARCHY_PVT.Log

2114: FND Debug Enabled profile otpion. Log level has been
2115: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2116: IF G_DEBUG = 'Y' THEN
2117: */
2118: INV_ORGHIERARCHY_PVT.Log
2119: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2120: ,to_char(l_errorcode) || l_errortext
2121: );
2122: --END IF;

Line 2119: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

2115: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2116: IF G_DEBUG = 'Y' THEN
2117: */
2118: INV_ORGHIERARCHY_PVT.Log
2119: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2120: ,to_char(l_errorcode) || l_errortext
2121: );
2122: --END IF;
2123: RETURN NULL;

Line 2179: INV_ORGHIERARCHY_PVT.Log

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

Line 2180: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

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'
2182: );
2183:
2184: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 2185: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '

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;
2189:

Line 2208: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '

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;
2212:

Line 2220: INV_ORGHIERARCHY_PVT.Log

2216: Error/Exception logging should not depend on
2217: FND Debug Enabled profile otpion. Bug: 3555234
2218: IF G_DEBUG = 'Y' THEN
2219: */
2220: INV_ORGHIERARCHY_PVT.Log
2221: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2222: ,'Organization Id expired:' || to_char(p_org_id) ||
2223: 'Business Group Id:' || to_char(p_business_group_id)
2224: );

Line 2221: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

2217: FND Debug Enabled profile otpion. Bug: 3555234
2218: IF G_DEBUG = 'Y' THEN
2219: */
2220: INV_ORGHIERARCHY_PVT.Log
2221: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2222: ,'Organization Id expired:' || to_char(p_org_id) ||
2223: 'Business Group Id:' || to_char(p_business_group_id)
2224: );
2225: --END IF;

Line 2240: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '

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;
2244:

Line 2252: INV_ORGHIERARCHY_PVT.Log

2248: Error/Exception logging should not depend on
2249: FND Debug Enabled profile otpion. Bug: 3555234
2250: IF G_DEBUG = 'Y' THEN
2251: */
2252: INV_ORGHIERARCHY_PVT.Log
2253: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2254: ,'Organization Id expired:' || to_char(p_org_id)
2255: );
2256: --END IF;

Line 2253: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

2249: FND Debug Enabled profile otpion. Bug: 3555234
2250: IF G_DEBUG = 'Y' THEN
2251: */
2252: INV_ORGHIERARCHY_PVT.Log
2253: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2254: ,'Organization Id expired:' || to_char(p_org_id)
2255: );
2256: --END IF;
2257: END IF;

Line 2268: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '

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;
2272:

Line 2303: INV_ORGHIERARCHY_PVT.Log

2299:
2300: END IF; -- for the valid organization
2301:
2302: IF G_DEBUG = 'Y' THEN
2303: INV_ORGHIERARCHY_PVT.Log
2304: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2305: ,'Organization Responsibility Valid Access Flag:'|| l_org_resp_access_flag
2306: );
2307: END IF;

Line 2304: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2300: END IF; -- for the valid organization
2301:
2302: IF G_DEBUG = 'Y' THEN
2303: INV_ORGHIERARCHY_PVT.Log
2304: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2305: ,'Organization Responsibility Valid Access Flag:'|| l_org_resp_access_flag
2306: );
2307: END IF;
2308:

Line 2312: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Level_Resp_Access '

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;
2316:

Line 2320: INV_ORGHIERARCHY_PVT.Log

2316:
2317: RETURN l_org_resp_access_flag;
2318:
2319: IF G_DEBUG = 'Y' THEN
2320: INV_ORGHIERARCHY_PVT.Log
2321: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2322: ,'End of Proc:Org Hierarchy Level Responsibility Access'
2323: );
2324: END IF;

Line 2321: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2317: RETURN l_org_resp_access_flag;
2318:
2319: IF G_DEBUG = 'Y' THEN
2320: INV_ORGHIERARCHY_PVT.Log
2321: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2322: ,'End of Proc:Org Hierarchy Level Responsibility Access'
2323: );
2324: END IF;
2325:

Line 2337: INV_ORGHIERARCHY_PVT.Log

2333: FND Debug Enabled profile otpion. Log leve has b een
2334: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2335: IF G_DEBUG = 'Y' THEN
2336: */
2337: INV_ORGHIERARCHY_PVT.Log
2338: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2339: ,to_char(l_errorcode) || l_errortext
2340: );
2341: --END IF;

Line 2338: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

2334: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2335: IF G_DEBUG = 'Y' THEN
2336: */
2337: INV_ORGHIERARCHY_PVT.Log
2338: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2339: ,to_char(l_errorcode) || l_errortext
2340: );
2341: --END IF;
2342: IF c_unxpire_organization%ISOPEN THEN

Line 2405: INV_ORGHIERARCHY_PVT.Log

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

Line 2406: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

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'
2408: );
2409:
2410: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 2411: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '

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;
2415:

Line 2428: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '

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;
2432:

Line 2440: INV_ORGHIERARCHY_PVT.Log

2436: Error/Exception logging should not depend on
2437: FND Debug Enabled profile otpion. Bug: 3555234
2438: IF G_DEBUG = 'Y' THEN
2439: */
2440: INV_ORGHIERARCHY_PVT.Log
2441: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2442: ,'Organization Id has no access:' || to_char(p_org_id)
2443: );
2444: --END IF;

Line 2441: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR

2437: FND Debug Enabled profile otpion. Bug: 3555234
2438: IF G_DEBUG = 'Y' THEN
2439: */
2440: INV_ORGHIERARCHY_PVT.Log
2441: (INV_ORGHIERARCHY_PVT.G_LOG_ERROR
2442: ,'Organization Id has no access:' || to_char(p_org_id)
2443: );
2444: --END IF;
2445: END IF;

Line 2451: INV_ORGHIERARCHY_PVT.Log

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
2454: );
2455:

Line 2452: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

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
2454: );
2455:
2456: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 2457: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '

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;
2461:

Line 2465: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '

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;
2469:

Line 2473: INV_ORGHIERARCHY_PVT.Log

2469:
2470: RETURN l_origin_resp_access_flag;
2471:
2472: IF G_DEBUG = 'Y' THEN
2473: INV_ORGHIERARCHY_PVT.Log
2474: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2475: ,'End of Proc:Org Hierarchy Origin Responsibility Access'
2476: );
2477: END IF;

Line 2474: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2470: RETURN l_origin_resp_access_flag;
2471:
2472: IF G_DEBUG = 'Y' THEN
2473: INV_ORGHIERARCHY_PVT.Log
2474: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2475: ,'End of Proc:Org Hierarchy Origin Responsibility Access'
2476: );
2477: END IF;
2478:

Line 2490: INV_ORGHIERARCHY_PVT.Log

2486: FND Debug Enabled profile otpion. Log level has been
2487: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2488: IF G_DEBUG = 'Y' THEN
2489: */
2490: INV_ORGHIERARCHY_PVT.Log
2491: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2492: ,to_char(l_errorcode) || l_errortext
2493: );
2494: --END IF;

Line 2491: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

2487: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2488: IF G_DEBUG = 'Y' THEN
2489: */
2490: INV_ORGHIERARCHY_PVT.Log
2491: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2492: ,to_char(l_errorcode) || l_errortext
2493: );
2494: --END IF;
2495:

Line 2503: , 'INV_ORGHIERARCHY_PVT.Org_Hier_Origin_Resp_Access '

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;
2507:

Line 2533: INV_ORGHIERARCHY_PVT.Log

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

Line 2534: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

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'
2536: );
2537:
2538: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 2539: , 'INV_ORGHIERARCHY_PVT.Org_exists_in_hierarchy '

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;
2543:

Line 2558: INV_ORGHIERARCHY_PVT.Log

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
2561: );
2562:

Line 2559: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

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
2561: );
2562:
2563: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 2564: , 'INV_ORGHIERARCHY_PVT.Org_exists_in_hierarchy '

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;
2568:

Line 2572: INV_ORGHIERARCHY_PVT.Log

2568:
2569: RETURN l_org_exists_flag;
2570:
2571: IF G_DEBUG = 'Y' THEN
2572: INV_ORGHIERARCHY_PVT.Log
2573: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2574: ,'End of Proc:Org exists in hierarchy'
2575: );
2576: END IF;

Line 2573: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2569: RETURN l_org_exists_flag;
2570:
2571: IF G_DEBUG = 'Y' THEN
2572: INV_ORGHIERARCHY_PVT.Log
2573: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2574: ,'End of Proc:Org exists in hierarchy'
2575: );
2576: END IF;
2577:

Line 2589: INV_ORGHIERARCHY_PVT.Log

2585: FND Debug Enabled profile otpion. Log level has been
2586: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2587: IF G_DEBUG = 'Y' THEN
2588: */
2589: INV_ORGHIERARCHY_PVT.Log
2590: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2591: ,to_char(l_errorcode) || l_errortext
2592: );
2593: --END IF;

Line 2590: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

2586: changed from G_LOG_ERROR to G_LOG_EXCEPTION. Bug: 3555234
2587: IF G_DEBUG = 'Y' THEN
2588: */
2589: INV_ORGHIERARCHY_PVT.Log
2590: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2591: ,to_char(l_errorcode) || l_errortext
2592: );
2593: --END IF;
2594: RETURN NULL;

Line 2618: INV_ORGHIERARCHY_PVT.Log

2614: l_organization_id hr_all_organization_units.organization_id%TYPE;
2615:
2616: BEGIN
2617: IF G_DEBUG = 'Y' THEN
2618: INV_ORGHIERARCHY_PVT.Log
2619: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2620: ,'Start of Proc: Insert hierarchy index list'
2621: );
2622: END IF;

Line 2619: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2615:
2616: BEGIN
2617: IF G_DEBUG = 'Y' THEN
2618: INV_ORGHIERARCHY_PVT.Log
2619: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2620: ,'Start of Proc: Insert hierarchy index list'
2621: );
2622: END IF;
2623:

Line 2631: INV_ORGHIERARCHY_PVT.Log

2627: g_orgid_index_list(l_org_index) := l_organization_id;
2628: END LOOP;
2629:
2630: IF G_DEBUG = 'Y' THEN
2631: INV_ORGHIERARCHY_PVT.Log
2632: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2633: ,'End of Proc: Insert hierarchy index list'
2634: );
2635: END IF;

Line 2632: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2628: END LOOP;
2629:
2630: IF G_DEBUG = 'Y' THEN
2631: INV_ORGHIERARCHY_PVT.Log
2632: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2633: ,'End of Proc: Insert hierarchy index list'
2634: );
2635: END IF;
2636:

Line 2708: END INV_ORGHIERARCHY_PVT;

2704: NULL;
2705: END Log;
2706:
2707:
2708: END INV_ORGHIERARCHY_PVT;