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.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 3740: fnd_profile.get_specific(

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

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

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

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

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

Line 4247: 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||'**]');

4243: -- l_url := replace(l_url,'home','wwsec_app_priv.logout ?p_done_url='||(nvl(l_url3,l_url2)));
4244:
4245: --else PHP
4246: -- ELSE
4247: 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||'**]');
4248:
4249: -- END IF;
4250: return (l_url);
4251:

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

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

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

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

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

4583: into l_language_code
4584: from fnd_languages
4585: where nls_language = l_language;
4586:
4587: fnd_profile.get_specific(name_z => 'ICX_NLS_SORT',
4588: user_id_z => p_user_id,
4589: val_z => l_nls_sort,
4590: defined_z => l_profile_defined);
4591:

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

4600:
4601:
4602: end if;
4603:
4604: fnd_profile.get_specific(name_z => 'ICX_DATE_FORMAT_MASK',
4605: user_id_z => p_user_id,
4606: val_z => l_date_format,
4607: defined_z => l_profile_defined);
4608:

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

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

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

4649: end if;
4650:
4651: end if;
4652:
4653: fnd_profile.get_specific(name_z => 'ICX_NUMERIC_CHARACTERS',
4654: user_id_z => p_user_id,
4655: val_z => l_numeric_characters,
4656: defined_z => l_profile_defined);
4657:

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

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

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

4682:
4683:
4684: end if;
4685:
4686: fnd_profile.get_specific(name_z => 'ICX_LIMIT_TIME',
4687: user_id_z => p_user_id,
4688: val_z => l_limit_time,
4689: defined_z => l_profile_defined);
4690:

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

4691: if l_limit_time is null then
4692: l_limit_time := 4;
4693: end if;
4694:
4695: fnd_profile.get_specific(name_z => 'ICX_LIMIT_CONNECT',
4696: user_id_z => p_user_id,
4697: val_z => l_limit_connects,
4698: defined_z => l_profile_defined);
4699:

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

4701: then
4702: l_limit_connects := 1000;
4703: end if;
4704:
4705: fnd_profile.get_specific(name_z => 'ICX_SESSION_TIMEOUT',
4706: user_id_z => p_user_id,
4707: val_z => l_timeout,
4708: defined_z => l_profile_defined);
4709:

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

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