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: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
345: -- Using fnd_global.per_business_group_id instead.

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: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
345: -- Using fnd_global.per_business_group_id instead.
346: l_business_group_id :=
347: -- TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );

Line 344: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.

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: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
345: -- Using fnd_global.per_business_group_id instead.
346: l_business_group_id :=
347: -- TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );
348: TO_NUMBER( FND_GLOBAL.per_business_group_id );

Line 347: -- TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );

343: TO_NUMBER( FND_PROFILE.value( 'PER_SECURITY_PROFILE_ID' ) );
344: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
345: -- Using fnd_global.per_business_group_id instead.
346: l_business_group_id :=
347: -- TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );
348: TO_NUMBER( FND_GLOBAL.per_business_group_id );
349:
350:
351: -- Note: oe_debug_pub is part of 11i baseline

Line 534: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.

530: BEGIN
531: -- bug#2563291 fix
532: -- get profile business group id of the responsibility
533:
534: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
535: -- Using fnd_global.per_business_group_id instead.
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);

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

533:
534: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
535: -- Using fnd_global.per_business_group_id instead.
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

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

644: psp.include_top_organization_flag,
645: psp.organization_id
646: FROM per_security_profiles psp,
647: per_organization_structures pos
648: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')
649: AND pos.organization_structure_id(+) = psp.organization_structure_id;
650:
651: BEGIN
652: IF G_DEBUG = 'Y' THEN

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

664: );
665: END IF;
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

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

948: psp.include_top_organization_flag,
949: psp.organization_id
950: FROM per_security_profiles psp,
951: per_organization_structures pos
952: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')
953: AND pos.organization_structure_id(+) = psp.organization_structure_id;
954:
955:
956: BEGIN

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

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
970: l_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');
971:
972: IF l_profile_id is NULL THEN
973: RAISE_APPLICATION_ERROR(-20101, 'Security Profile Id is not set for
974: the responsibility');

Line 1292: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.

1288:
1289: AND ltrim(rtrim(OS.NAME)) = ltrim(rtrim(c_hierarchy_name))
1290: --Bug 9775787
1291: AND (OS.BUSINESS_GROUP_ID =
1292: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
1293: -- Using fnd_global.per_business_group_id instead.
1294: -- TO_NUMBER( FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') ) OR
1295: TO_NUMBER(FND_GLOBAL.per_business_group_id) OR
1296: OS.BUSINESS_GROUP_ID IS NULL);

Line 1294: -- TO_NUMBER( FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') ) OR

1290: --Bug 9775787
1291: AND (OS.BUSINESS_GROUP_ID =
1292: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
1293: -- Using fnd_global.per_business_group_id instead.
1294: -- TO_NUMBER( FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') ) OR
1295: TO_NUMBER(FND_GLOBAL.per_business_group_id) OR
1296: OS.BUSINESS_GROUP_ID IS NULL);
1297:
1298:

Line 1366: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.

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:
1366: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
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:

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

1364: END IF;
1365:
1366: -- Bugfix 16344080: fnd_profile.value is not working for 'PER_BUSINESS_GROUP_ID'.
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

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

1464: CLOSE c_parent_organization;
1465: END IF;
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

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

2645: --=======================================================================--
2646: PROCEDURE Log_Initialize
2647: IS
2648: BEGIN
2649: g_log_level := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
2650: IF g_log_level IS NULL THEN
2651: g_log_mode := 'OFF';
2652: ELSE
2653: IF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0) THEN

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

2649: g_log_level := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
2650: IF g_log_level IS NULL THEN
2651: g_log_mode := 'OFF';
2652: ELSE
2653: IF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0) THEN
2654: g_log_mode := 'SRS';
2655: ELSE
2656: g_log_mode := 'SQL';
2657: END IF;