eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ICX_SEC dependencies on FND_PROFILE

Line 123: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',

119: --htp.p('VP');--mputman debug
120: -- start additions for 1916792
121: -- icx_sec.g_security_group_id:=c_sec_grp_id; --mputman hosted update
122: --SECURITY_GROUP_KEY in the FND_SECURITY_GROUPS
123: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',
124: val => l_hosted_profile);
125:
126: IF (upper(l_hosted_profile)='HOSTED') THEN
127: b_hosted:=TRUE;

Line 148: fnd_profile.get_specific(name_z => 'ICX_LANGUAGE',

144: t_user_id := NULL;
145: END;
146:
147: IF t_user_id IS NOT NULL THEN
148: fnd_profile.get_specific(name_z => 'ICX_LANGUAGE',
149: user_id_z => t_user_id,
150: val_z => t_language,
151: defined_z => l_profile_defined);
152: ELSE

Line 153: t_language := fnd_profile.value('ICX_LANGUAGE');

149: user_id_z => t_user_id,
150: val_z => t_language,
151: defined_z => l_profile_defined);
152: ELSE
153: t_language := fnd_profile.value('ICX_LANGUAGE');
154:
155: --start bug 3100151
156:
157: l_remote_addr := owa_util.get_cgi_env('REMOTE_ADDR');

Line 660: -- fnd_profile.get_specific

656: -- l_XSID := FND_SESSION_MANAGEMENT.NewXSID;
657: l_XSID := icx_call.encrypt3(p_session_id);
658:
659: -- Is user GUEST
660: -- fnd_profile.get_specific
661: -- (name_z => 'GUEST_USER_PWD',
662: -- val_z => l_guest_username ,
663: -- defined_z => l_profile_defined);
664: -- Using new api to retrieve GUEST credentials.

Line 686: fnd_profile.get_specific

682: else
683: l_guest := 'N';
684: end if;
685:
686: fnd_profile.get_specific
687: (name_z => 'DISTRIBUTED_ENVIRONMENT',
688: val_z => l_dist,
689: defined_z => l_profile_defined);
690:

Line 1192: fnd_profile.get_specific(

1188: where rownum < 2;
1189:
1190: if l_multi_org_flag = 'Y'
1191: then
1192: fnd_profile.get_specific(
1193: name_z => 'ORG_ID',
1194: responsibility_id_z => l_responsibility_id,
1195: application_id_z => l_resp_appl_id,
1196: val_z => l_org_id,

Line 1642: fnd_profile.get(name => 'ICX_OA_HTML',

1638: icx_sec.g_nls_sort,
1639: icx_sec.g_nls_territory);
1640:
1641: /* nlbarlow 1574527
1642: fnd_profile.get(name => 'ICX_OA_HTML',
1643: val => l_OA_HTML);
1644:
1645: if l_OA_HTML is not null
1646: then

Line 1650: fnd_profile.get(name => 'ICX_OA_MEDIA',

1646: then
1647: icx_sec.g_OA_HTML := l_OA_HTML;
1648: end if;
1649:
1650: fnd_profile.get(name => 'ICX_OA_MEDIA',
1651: val => l_OA_MEDIA);
1652:
1653: if l_OA_MEDIA is not null
1654: then

Line 1658: fnd_profile.get(name => 'ICX_STYLE_SHEET',

1654: then
1655: icx_sec.g_OA_MEDIA := l_OA_MEDIA;
1656: end if;
1657:
1658: fnd_profile.get(name => 'ICX_STYLE_SHEET',
1659: val => l_style_sheet);
1660:
1661: if l_style_sheet is not null
1662: then

Line 1667: fnd_profile.get(name => 'ICX_PREFIX',

1663: icx_sec.g_style_sheet := l_style_sheet;
1664: end if;
1665: */
1666:
1667: fnd_profile.get(name => 'ICX_PREFIX',
1668: val => l_prefix);
1669:
1670: -- GK: Bug 1622218
1671: -- There is an extra slash before OA_HTML when l_prefix is null

Line 1715: fnd_profile.get_specific(

1711:
1712: if l_multi_org_flag = 'Y'
1713: then
1714: /* 3219471 nlbarlow replaced get_specific
1715: fnd_profile.get_specific(
1716: name_z => 'ORG_ID',
1717: responsibility_id_z => icx_sec.g_responsibility_id,
1718: application_id_z => icx_sec.g_resp_appl_id,
1719: val_z => icx_sec.g_org_id,

Line 1722: fnd_profile.get(name => 'ORG_ID',

1718: application_id_z => icx_sec.g_resp_appl_id,
1719: val_z => icx_sec.g_org_id,
1720: defined_z => l_profile_defined);
1721: */
1722: fnd_profile.get(name => 'ORG_ID',
1723: val => icx_sec.g_org_id);
1724: end if;
1725: end if;
1726:

Line 1745: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',

1741:
1742: -- begin additions for 1755317 mputman
1743:
1744: /* 3219471 nlbarlow replaced get_specific
1745: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',
1746: application_id_z => g_resp_appl_id,
1747: responsibility_id_z => icx_sec.g_responsibility_id, user_id_z => icx_sec.g_user_id,
1748: val_z => l_session_timeout ,
1749: defined_z => l_profile_defined);

Line 1751: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',

1747: responsibility_id_z => icx_sec.g_responsibility_id, user_id_z => icx_sec.g_user_id,
1748: val_z => l_session_timeout ,
1749: defined_z => l_profile_defined);
1750: */
1751: fnd_profile.get(name => 'ICX_SESSION_TIMEOUT',
1752: val => l_session_timeout);
1753:
1754: IF (l_session_timeout ) IS NOT NULL AND (l_session_timeout > 0) THEN
1755: IF (((SYSDATE-l_last_connect)*24*60)> l_session_timeout ) THEN

Line 1860: l_url := FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'));

1856: --removed portal support and moved it to oracleapps.displaylogin mputman 2053850
1857: IF (c_user_name IS NOT NULL) AND (g_session_id IS NOT NULL) THEN
1858: l_recreate_code:=icx_call.encrypt(g_session_id||'*'||c_user_name||'**]');
1859:
1860: l_url := FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'));
1861: l_url := l_url||'OracleApps.displayLogin?recreate='||l_recreate_code;
1862: -- this fix isnt adequately tested. Will implement in later patch after testing
1863: --begin fix for 2214199
1864: /*

Line 1922: fnd_profile.get_specific(name_z => 'APPS_SSO',

1918: };
1919: };');
1920:
1921:
1922: fnd_profile.get_specific(name_z => 'APPS_SSO',
1923: user_id_z => icx_sec.g_user_id,
1924: val_z => l_portal_url,
1925: defined_z => l_profile_defined);
1926: IF (nvl(l_portal_url,'SSWA') = 'PORTAL') OR

Line 1955: fnd_profile.get(name => 'APPS_PORTAL',

1951:
1952: when e_no_function_id
1953: then
1954: if c_validate_only = 'N' then
1955: fnd_profile.get(name => 'APPS_PORTAL',
1956: val =>l_portal_url);
1957: IF l_portal_url IS NOT NULL THEN
1958: --portal instance.. direct through SSO
1959: -- fnd_profile.get(name => 'GUEST_USER_PWD',

Line 1959: -- fnd_profile.get(name => 'GUEST_USER_PWD',

1955: fnd_profile.get(name => 'APPS_PORTAL',
1956: val =>l_portal_url);
1957: IF l_portal_url IS NOT NULL THEN
1958: --portal instance.. direct through SSO
1959: -- fnd_profile.get(name => 'GUEST_USER_PWD',
1960: -- val => l_anon_name);
1961: -- Using new api to retrieve GUEST credentials.
1962: l_anon_name := fnd_web_sec.get_guest_username_pwd;
1963: l_anon_name := SUBSTR(l_anon_name, 1, INSTR(l_anon_name, '/') -1);

Line 1981: -- fnd_profile.get(name => 'GUEST_USER_PWD',

1977:
1978: RETURN FALSE;
1979: END IF; -- an anonymous user
1980: ELSE -- not portal
1981: -- fnd_profile.get(name => 'GUEST_USER_PWD',
1982: -- val => l_anon_name);
1983: -- Using new api to retrieve GUEST credentials.
1984: l_anon_name := fnd_web_sec.get_guest_username_pwd;
1985:

Line 2238: fnd_profile.get_specific

2234:
2235: if (c_disabled_flag = 'Y') then
2236: raise e_session_invalid;
2237: end if;
2238: fnd_profile.get_specific
2239: (name_z => 'ICX_SESSION_TIMEOUT',
2240: application_id_z => l_app_resp_id,
2241: user_id_z => l_user_id,
2242: responsibility_id_z => l_resp_id,

Line 2251: fnd_profile.get_specific

2247: IF (((SYSDATE-l_last_connect)*24*60)> l_session_timeout ) THEN
2248: RAISE e_exceed_limit;
2249: ELSE
2250: -- nlbarlow 2847057
2251: fnd_profile.get_specific
2252: (name_z => 'DISTRIBUTED_ENVIRONMENT',
2253: application_id_z => l_app_resp_id,
2254: user_id_z => l_user_id,
2255: responsibility_id_z => l_resp_id,

Line 2995: fnd_profile.get_specific(

2991:
2992: elsif n_param = PV_USER_REQ_TEMPLATE -- ** REQ DEFAULT TEMPLATE (25)
2993: then
2994:
2995: fnd_profile.get_specific(
2996: name_z => 'ICX_REQ_DEFAULT_TEMPLATE',
2997: application_id_z => icx_sec.g_resp_appl_id,
2998: user_id_z => icx_sec.g_user_id,
2999: responsibility_id_z => icx_sec.g_responsibility_id,

Line 3007: fnd_profile.get_specific(

3003:
3004: elsif n_param = PV_USER_REQ_OVERRIDE_REQUESTOR -- ** PV_USER_REQ_OVERRIDE_REQUESTOR (26)
3005: then
3006:
3007: fnd_profile.get_specific(
3008: name_z => 'ICX_REQ_OVERRIDE_REQUESTOR_CODE',
3009: application_id_z => icx_sec.g_resp_appl_id,
3010: user_id_z => icx_sec.g_user_id,
3011: responsibility_id_z => icx_sec.g_responsibility_id,

Line 3018: fnd_profile.get_specific(

3014:
3015: elsif n_param = PV_USER_REQ_OVERRIDE_LOC_FLAG -- ** PV_USER_REQ_OVERRIDE_LOC_FLAG (27)
3016: then
3017:
3018: fnd_profile.get_specific(
3019: name_z => 'ICX_REQ_OVERRIDE_LOCATION_FLAG',
3020: application_id_z => icx_sec.g_resp_appl_id,
3021: user_id_z => icx_sec.g_user_id,
3022: responsibility_id_z => icx_sec.g_responsibility_id,

Line 3029: fnd_profile.get_specific(

3025:
3026: elsif n_param = PV_USER_REQ_DAYS_NEEDED_BY -- ** PV_USER_REQ_DAYS_NEEDED_BY (28)
3027: then
3028:
3029: fnd_profile.get_specific(
3030: name_z => 'ICX_DAYS_NEEDED_BY',
3031: application_id_z => icx_sec.g_resp_appl_id,
3032: user_id_z => icx_sec.g_user_id,
3033: responsibility_id_z => icx_sec.g_responsibility_id,

Line 3496: l_session_cookie_domain := trim(fnd_profile.value('ICX_SESSION_COOKIE_DOMAIN'));

3492: --Modified above logic remove the above restriction.
3493: --now session cookie domain can have any number of elements.
3494:
3495: begin
3496: l_session_cookie_domain := trim(fnd_profile.value('ICX_SESSION_COOKIE_DOMAIN'));
3497: IF l_session_cookie_domain IS NULL THEN
3498:
3499: select SESSION_COOKIE_DOMAIN
3500: into l_session_cookie_domain

Line 3738: fnd_profile.get_specific(

3734: where rownum < 2;
3735:
3736: if l_multi_org_flag = 'Y'
3737: then
3738: fnd_profile.get_specific(
3739: name_z => 'ORG_ID',
3740: responsibility_id_z => p_responsibility_id,
3741: application_id_z => p_application_id,
3742: val_z => l_org_id,

Line 3855: l_url := FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'));

3851: end if;
3852:
3853: if l_url is null
3854: then
3855: l_url := FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'));
3856: end if;
3857:
3858: l_url := l_url||l_web_html_call;
3859:

Line 4242: -- fnd_profile.get(name => 'APPS_PORTAL',

4238:
4239: --if portal
4240: -- IF l_mode='115X' THEN
4241:
4242: -- fnd_profile.get(name => 'APPS_PORTAL',
4243: -- val => l_url);
4244:
4245: -- l_url2 := wfa_html.conv_special_url_chars(l_url);
4246: -- l_url := replace(l_url,'home','wwsec_app_priv.logout ?p_done_url='||(nvl(l_url3,l_url2)));

Line 4250: l_url:=FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'))||'OracleApps.displayLogin?recreate='||icx_call.encrypt(p_session_id||'*'||p_user_name||'**]');

4246: -- l_url := replace(l_url,'home','wwsec_app_priv.logout ?p_done_url='||(nvl(l_url3,l_url2)));
4247:
4248: --else PHP
4249: -- ELSE
4250: l_url:=FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'))||'OracleApps.displayLogin?recreate='||icx_call.encrypt(p_session_id||'*'||p_user_name||'**]');
4251:
4252: -- END IF;
4253: return (l_url);
4254:

Line 4422: -- fnd_profile.get(name => 'GUEST_USER_PWD',

4418:
4419: BEGIN
4420: IF p_user_id IS NULL THEN
4421:
4422: -- fnd_profile.get(name => 'GUEST_USER_PWD',
4423: -- val => l_anon_name);
4424: -- Using new api to retrieve GUEST credentials.
4425: l_anon_name := fnd_web_sec.get_guest_username_pwd;
4426: l_anon_name := SUBSTR(l_anon_name, 1, INSTR(l_anon_name, '/') -1);

Line 4568: fnd_profile.get_specific(name_z => 'ICX_LANGUAGE',

4564: begin
4565:
4566: -- The following Profiles should be set
4567:
4568: fnd_profile.get_specific(name_z => 'ICX_LANGUAGE',
4569: user_id_z => p_user_id,
4570: val_z => l_language,
4571: defined_z => l_profile_defined);
4572:

Line 4591: fnd_profile.get_specific(name_z => 'ICX_NLS_SORT',

4587: into l_language_code
4588: from fnd_languages
4589: where nls_language = l_language;
4590:
4591: fnd_profile.get_specific(name_z => 'ICX_NLS_SORT',
4592: user_id_z => p_user_id,
4593: val_z => l_nls_sort,
4594: defined_z => l_profile_defined);
4595:

Line 4608: fnd_profile.get_specific(name_z => 'ICX_DATE_FORMAT_MASK',

4604:
4605:
4606: end if;
4607:
4608: fnd_profile.get_specific(name_z => 'ICX_DATE_FORMAT_MASK',
4609: user_id_z => p_user_id,
4610: val_z => l_date_format,
4611: defined_z => l_profile_defined);
4612:

Line 4638: fnd_profile.get_specific(name_z => 'ICX_DATE_LANGUAGE',

4634: or AL32UTF8. But the profile ICX_DATE_LANGUAGE overrides
4635: all that if it is set.
4636: */
4637:
4638: fnd_profile.get_specific(name_z => 'ICX_DATE_LANGUAGE',
4639: user_id_z => p_user_id,
4640: val_z => l_date_language,
4641: defined_z => l_profile_defined);
4642:

Line 4657: fnd_profile.get_specific(name_z => 'ICX_NUMERIC_CHARACTERS',

4653: end if;
4654:
4655: end if;
4656:
4657: fnd_profile.get_specific(name_z => 'ICX_NUMERIC_CHARACTERS',
4658: user_id_z => p_user_id,
4659: val_z => l_numeric_characters,
4660: defined_z => l_profile_defined);
4661:

Line 4673: fnd_profile.get_specific(name_z => 'ICX_TERRITORY',

4669: l_numeric_characters:=getNLS_PARAMETER('NLS_NUMERIC_CHARACTERS'); -- replaces above select mputman 1574527
4670:
4671: end if;
4672:
4673: fnd_profile.get_specific(name_z => 'ICX_TERRITORY',
4674: user_id_z => p_user_id,
4675: val_z => l_nls_territory,
4676: defined_z => l_profile_defined);
4677:

Line 4690: fnd_profile.get_specific(name_z => 'ICX_LIMIT_TIME',

4686:
4687:
4688: end if;
4689:
4690: fnd_profile.get_specific(name_z => 'ICX_LIMIT_TIME',
4691: user_id_z => p_user_id,
4692: val_z => l_limit_time,
4693: defined_z => l_profile_defined);
4694:

Line 4699: fnd_profile.get_specific(name_z => 'ICX_LIMIT_CONNECT',

4695: if l_limit_time is null then
4696: l_limit_time := 4;
4697: end if;
4698:
4699: fnd_profile.get_specific(name_z => 'ICX_LIMIT_CONNECT',
4700: user_id_z => p_user_id,
4701: val_z => l_limit_connects,
4702: defined_z => l_profile_defined);
4703:

Line 4709: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',

4705: then
4706: l_limit_connects := 1000;
4707: end if;
4708:
4709: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',
4710: user_id_z => p_user_id,
4711: val_z => l_timeout,
4712: defined_z => l_profile_defined);
4713:

Line 4721: fnd_profile.get_specific(name_z => 'ORG_ID',

4717: from fnd_product_groups
4718: where rownum < 2;
4719:
4720: if l_multi_org_flag = 'Y' then
4721: fnd_profile.get_specific(name_z => 'ORG_ID',
4722: val_z => l_org_id,
4723: defined_z => l_profile_defined);
4724: end if;
4725: