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_PROFILE

Line 88: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

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');
89:
90: --========================================================================
91: -- FUNCTION : get_organization_list PUBLIC
92: -- PARAMETERS: p_hierarchy_id IN NUMBER

Line 341: TO_NUMBER( FND_PROFILE.VALUE( 'RESP_ID' ) );

337: BEGIN
338:
339:
340: l_responsibility_id :=
341: TO_NUMBER( FND_PROFILE.VALUE( 'RESP_ID' ) );
342: l_security_profile_id :=
343: TO_NUMBER( FND_PROFILE.value( 'PER_SECURITY_PROFILE_ID' ) );
344: l_business_group_id :=
345: TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );

Line 343: TO_NUMBER( FND_PROFILE.value( 'PER_SECURITY_PROFILE_ID' ) );

339:
340: l_responsibility_id :=
341: TO_NUMBER( FND_PROFILE.VALUE( 'RESP_ID' ) );
342: l_security_profile_id :=
343: TO_NUMBER( FND_PROFILE.value( 'PER_SECURITY_PROFILE_ID' ) );
344: l_business_group_id :=
345: TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );
346:
347:

Line 345: TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );

341: TO_NUMBER( FND_PROFILE.VALUE( 'RESP_ID' ) );
342: l_security_profile_id :=
343: TO_NUMBER( FND_PROFILE.value( 'PER_SECURITY_PROFILE_ID' ) );
344: l_business_group_id :=
345: TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );
346:
347:
348: -- Note: oe_debug_pub is part of 11i baseline
349: oe_debug_pub.add( 'Responsibility Id: ' || l_responsibility_id, 2 );

Line 528: l_business_group_id := TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));

524:
525: BEGIN
526: -- bug#2563291 fix
527: -- get profile business group id of the responsibility
528: l_business_group_id := TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
529: IF l_business_group_id IS NOT NULL THEN
530: -- this check ensures that no glboal hierarchy is picked up
531: OPEN hierarchy_version_csr;
532: FETCH hierarchy_version_csr INTO l_org_structure_version_id;

Line 592: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')

588: psp.include_top_organization_flag,
589: psp.organization_id
590: FROM per_security_profiles psp,
591: per_organization_structures pos
592: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')
593: AND pos.organization_structure_id(+) = psp.organization_structure_id;
594:
595: BEGIN
596: IF G_DEBUG = 'Y' THEN

Line 604: l_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');

600: );
601: END IF;
602:
603: -- get the profile id of the user
604: l_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');
605: IF l_profile_id is NULL THEN
606:
607: /* This executable is used by concurrent program so
608: Error/Exception logging should not depend on

Line 783: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')

779: psp.include_top_organization_flag,
780: psp.organization_id
781: FROM per_security_profiles psp,
782: per_organization_structures pos
783: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')
784: AND pos.organization_structure_id(+) = psp.organization_structure_id;
785:
786:
787: BEGIN

Line 795: l_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');

791: ,'Start of Proc:Org Hierarchy Level Access'
792: );
793: END IF;
794: -- get the profile id of the user
795: l_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');
796: IF l_profile_id is NULL THEN
797: RAISE_APPLICATION_ERROR(-20101, 'Security Profile Id is not set for
798: the responsibility');
799: END IF;

Line 1008: TO_NUMBER( FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') );

1004: )
1005:
1006: AND ltrim(rtrim(OS.NAME)) = ltrim(rtrim(c_hierarchy_name))
1007: AND OS.BUSINESS_GROUP_ID =
1008: TO_NUMBER( FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') );
1009:
1010:
1011: -- cursor to obtain the parent organization id for the organization structure
1012: -- hierarchy version when p_org_hierarchy_level is null

Line 1073: TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));

1069: );
1070: END IF;
1071:
1072: l_business_group_id :=
1073: TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
1074:
1075: IF G_DEBUG = 'Y' THEN
1076: INV_ORGHIERARCHY_PVT.Log
1077: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

Line 1144: l_user_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));

1140:
1141: END IF;
1142:
1143: -- get the responsibility id
1144: l_user_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
1145:
1146: -- check whether the parent organization id is unexpired and
1147: -- has an access to the current user responsibility
1148: IF (INV_ORGHIERARCHY_PVT.

Line 2143: g_log_level := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));

2139: --=======================================================================--
2140: PROCEDURE Log_Initialize
2141: IS
2142: BEGIN
2143: g_log_level := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
2144: IF g_log_level IS NULL THEN
2145: g_log_mode := 'OFF';
2146: ELSE
2147: IF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0) THEN

Line 2147: IF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0) THEN

2143: g_log_level := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
2144: IF g_log_level IS NULL THEN
2145: g_log_mode := 'OFF';
2146: ELSE
2147: IF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0) THEN
2148: g_log_mode := 'SRS';
2149: ELSE
2150: g_log_mode := 'SQL';
2151: END IF;