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.ORACLEAPPS dependencies on FND_PROFILE

Line 307: fnd_profile.get_specific(

303: into l_user_id
304: from icx_sessions
305: where session_id = n_session_id;
306:
307: fnd_profile.get_specific(
308: name_z => 'ICX_LANGUAGE',
309: user_id_z => l_user_id,
310: val_z => l_language,
311: defined_z => l_profile_defined);

Line 327: fnd_profile.get_specific(

323:
324:
325: end if;
326:
327: fnd_profile.get_specific(
328: name_z => 'ICX_DATE_FORMAT_MASK',
329: user_id_z => l_user_id,
330: val_z => l_date_format,
331: defined_z => l_profile_defined);

Line 433: fnd_profile.get_specific(

429: into l_user_id
430: from icx_sessions
431: where session_id = n_session_id;
432:
433: fnd_profile.get_specific(
434: name_z => 'ICX_LANGUAGE',
435: user_id_z => l_user_id,
436: val_z => l_language,
437: defined_z => l_profile_defined);

Line 452: fnd_profile.get_specific(

448:
449:
450: end if;
451:
452: fnd_profile.get_specific(
453: name_z => 'ICX_DATE_FORMAT_MASK',
454: user_id_z => l_user_id,
455: val_z => l_date_format,
456: defined_z => l_profile_defined);

Line 673: if fnd_profile.defined('APPLICATIONS_HOME_PAGE')

669: -- 2802333 nlbarlow
670: --bug Dale
671:
672:
673: if fnd_profile.defined('APPLICATIONS_HOME_PAGE')
674: then
675:
676: l_url := fnd_sso_manager.getLoginUrl(requestUrl => i_direct);
677:

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

706:
707: else
708:
709:
710: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',
711: val => l_hosted_profile);
712:
713: IF (upper(l_hosted_profile)='HOSTED') THEN
714: b_hosted:=TRUE;

Line 722: fnd_profile.get(name => 'APPS_SSO',

718: icx_sec.writeAudit;
719:
720: --add redirect code to send to portal and sso if portal agent profile is not null
721: --check SSO_SDK, if null, then check apps_portal
722: fnd_profile.get(name => 'APPS_SSO',
723: val => l_apps_sso);
724: fnd_profile.get(name => 'APPS_PORTAL',
725: val => l_url);
726: fnd_profile.get(name => 'APPS_MAINTENANCE_MODE',

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

720: --add redirect code to send to portal and sso if portal agent profile is not null
721: --check SSO_SDK, if null, then check apps_portal
722: fnd_profile.get(name => 'APPS_SSO',
723: val => l_apps_sso);
724: fnd_profile.get(name => 'APPS_PORTAL',
725: val => l_url);
726: fnd_profile.get(name => 'APPS_MAINTENANCE_MODE',
727: val => l_maint_mode);-- check for MAINTENANCE mode
728: l_maint_mode := nvl(l_maint_mode,'NORMAL');

Line 726: fnd_profile.get(name => 'APPS_MAINTENANCE_MODE',

722: fnd_profile.get(name => 'APPS_SSO',
723: val => l_apps_sso);
724: fnd_profile.get(name => 'APPS_PORTAL',
725: val => l_url);
726: fnd_profile.get(name => 'APPS_MAINTENANCE_MODE',
727: val => l_maint_mode);-- check for MAINTENANCE mode
728: l_maint_mode := nvl(l_maint_mode,'NORMAL');
729:
730: IF l_apps_sso = 'PORTAL' THEN

Line 1236: fnd_profile.get(name => 'APPS_DATABASE_ID',

1232: icx_sec.sendsessioncookie(l_session_id);
1233:
1234: if (instr(l_anchor,'OA.jsp') > 0)
1235: then
1236: fnd_profile.get(name => 'APPS_DATABASE_ID',
1237: val => l_dbc);
1238:
1239: if l_dbc is null
1240: then

Line 1353: fnd_profile.get(name => 'APPS_DATABASE_ID',

1349: icx_sec.sendsessioncookie(l_session_id);
1350:
1351: if (instr(l_anchor,'OA.jsp') > 0)
1352: then
1353: fnd_profile.get(name => 'APPS_DATABASE_ID',
1354: val => l_dbc);
1355:
1356: if l_dbc is null
1357: then

Line 2463: fnd_profile.get_specific(

2459: where rownum < 2;
2460:
2461: if l_multi_org_flag = 'Y'
2462: then
2463: fnd_profile.get_specific(
2464: name_z => 'ORG_ID',
2465: responsibility_id_z => l_responsibility_id,
2466: application_id_z => l_resp_appl_id,
2467: val_z => l_org_id,

Line 2673: fnd_profile.get_specific(

2669:
2670: /* Supposed to support MSOB
2671: if c_anchor is null
2672: then
2673: fnd_profile.get_specific(
2674: name_z => 'APPS_WEB_AGENT',
2675: responsibility_id_z => l_responsibility_id,
2676: val_z => c_anchor,
2677: defined_z => l_profile_defined);

Line 2718: fnd_profile.get(name => 'APPS_SERVLET_AGENT',

2714: elsif f.type = 'SERVLET' then
2715:
2716: l_encrypted_session_id := icx_call.encrypt3(n_session_id);
2717:
2718: fnd_profile.get(name => 'APPS_SERVLET_AGENT',
2719: val => c_anchor);
2720:
2721: c_anchor := FND_WEB_CONFIG.trail_slash(c_anchor)||f.WEB_HTML_CALL||
2722: '?dbc='||FND_WEB_CONFIG.DATABASE_ID||

Line 2739: fnd_profile.get(name => 'APPS_FRAMEWORK_AGENT',

2735: l_web_html_call := replace(f.WEB_HTML_CALL,'apps.jsp','OA.jsp');
2736:
2737: if (instr(l_web_html_call,'OA.jsp') > 0)
2738: then
2739: fnd_profile.get(name => 'APPS_FRAMEWORK_AGENT',
2740: val => c_anchor);
2741: l_message := 'Applications Framework Agent';
2742: else
2743: fnd_profile.get(name => 'APPS_SERVLET_AGENT',

Line 2743: fnd_profile.get(name => 'APPS_SERVLET_AGENT',

2739: fnd_profile.get(name => 'APPS_FRAMEWORK_AGENT',
2740: val => c_anchor);
2741: l_message := 'Applications Framework Agent';
2742: else
2743: fnd_profile.get(name => 'APPS_SERVLET_AGENT',
2744: val => c_anchor);
2745: l_message := 'Applications Servlet Agent';
2746: end if;
2747:

Line 2774: fnd_profile.get(name => 'APPS_DATABASE_ID',

2770: c_anchor := FND_WEB_CONFIG.trail_slash(c_anchor)||
2771: FND_WEB_CONFIG.trail_slash(icx_sec.g_OA_HTML)||
2772: l_web_html_call;
2773:
2774: fnd_profile.get(name => 'APPS_DATABASE_ID',
2775: val => l_dbc);
2776:
2777: if l_dbc is null
2778: then

Line 3235: fnd_profile.get_specific(

3231: l_numeric_characters := icx_sec.g_numeric_characters;
3232:
3233: --get profile value for CLIENT_TIMEZONE_ID
3234: --decode into displayed_name
3235: fnd_profile.get_specific(
3236: name_z => 'CLIENT_TIMEZONE_ID',
3237: user_id_z => icx_sec.g_user_id,
3238: val_z => l_timezone,
3239: defined_z => l_profile_defined);

Line 3241: fnd_profile.get_specific(

3237: user_id_z => icx_sec.g_user_id,
3238: val_z => l_timezone,
3239: defined_z => l_profile_defined);
3240:
3241: fnd_profile.get_specific(
3242: name_z => 'FND_NATIVE_CLIENT_ENCODING',
3243: user_id_z => icx_sec.g_user_id,
3244: val_z => l_encoding,
3245: defined_z => l_profile_defined);

Line 3248: fnd_profile.get_specific(

3244: val_z => l_encoding,
3245: defined_z => l_profile_defined);
3246:
3247:
3248: fnd_profile.get_specific(
3249: name_z => 'ENABLE_TIMEZONE_CONVERSIONS',
3250: user_id_z => icx_sec.g_user_id,
3251: val_z => l_tz_enabled,
3252: defined_z => l_profile_defined);

Line 3332: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));

3328:
3329: htp.p('function savepref() {
3330: var l_alert = false');
3331:
3332: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));
3333: fnd_message.set_name('FND','PASSWORD-LONGER');
3334: fnd_message.set_token('LENGTH',to_char(l_pwlen));
3335: l_message := icx_util.replace_quotes(fnd_message.get);
3336: htp.p(' var lpwd = document.userpref.i_5.value;

Line 3705: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));

3701: icx_admin_sig.help_win_script('/OA_DOC/'||c_language_code||'/aic/icxhlpmp.htm');
3702: htp.p('function update_user(){
3703: var l_alert = false;');
3704:
3705: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));
3706: fnd_message.set_name('FND','PASSWORD-LONGER');
3707: fnd_message.set_token('LENGTH',to_char(l_pwlen));
3708: l_message := icx_util.replace_quotes(fnd_message.get);
3709: htp.p(' var lpwd = document.newpass.i_3.value;

Line 3870: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'FND_NATIVE_CLIENT_ENCODING',

3866: l_password_updated := TRUE;
3867:
3868: --put timezone profile value
3869:
3870: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'FND_NATIVE_CLIENT_ENCODING',
3871: X_VALUE => c_ENCODING,
3872: X_LEVEL_NAME =>'USER',
3873: X_LEVEL_VALUE => l_user_id);
3874:

Line 3875: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'CLIENT_TIMEZONE_ID',

3871: X_VALUE => c_ENCODING,
3872: X_LEVEL_NAME =>'USER',
3873: X_LEVEL_VALUE => l_user_id);
3874:
3875: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'CLIENT_TIMEZONE_ID',
3876: X_VALUE => c_TIMEZONE,
3877: X_LEVEL_NAME =>'USER',
3878: X_LEVEL_VALUE => l_user_id);
3879: if l_return_stat = FALSE then

Line 4009: fnd_profile.get(name => 'ICX_NLS_SORT',

4005: -- get prof option vals for date_lang and sort.
4006: -- call fnd_global.set_nls to get return vals for date_lang and sort.
4007: -- when the prof vals are null, use the returns from fnd_global in the update to icx_sessions.
4008:
4009: fnd_profile.get(name => 'ICX_NLS_SORT',
4010: val => prof_sort);
4011: fnd_profile.get(name => 'ICX_DATE_LANGUAGE',
4012: val => prof_date_lang);
4013:

Line 4011: fnd_profile.get(name => 'ICX_DATE_LANGUAGE',

4007: -- when the prof vals are null, use the returns from fnd_global in the update to icx_sessions.
4008:
4009: fnd_profile.get(name => 'ICX_NLS_SORT',
4010: val => prof_sort);
4011: fnd_profile.get(name => 'ICX_DATE_LANGUAGE',
4012: val => prof_date_lang);
4013:
4014: fnd_global.set_nls(
4015: p_nls_language => c_LANGUAGE,

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

4529: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);
4530: --c_nls_language := ''''||c_nls_language||'''';
4531: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language);--removed in favor of above call to fnd_global -- mputman
4532: end if;
4533: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',
4534: val => l_hosted_profile);
4535:
4536: IF (upper(l_hosted_profile)='HOSTED') THEN
4537: b_hosted:=TRUE;

Line 4683: fnd_profile.get(name => 'APPS_SSO',

4679: l_timeout number;
4680:
4681: BEGIN
4682: --add redirect code to send to portal and sso if portal agent profile is not null
4683: fnd_profile.get(name => 'APPS_SSO',
4684: val => l_apps_sso);
4685: IF l_apps_sso = 'PORTAL' THEN
4686: l_portal:=TRUE;
4687: ELSIF l_apps_sso = 'SSO_SDK' THEN

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

4710: RAISE e_portal_no_sso;
4711: END IF;
4712: ELSE
4713:
4714: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',
4715: val => l_hosted_profile);
4716:
4717: IF (upper(l_hosted_profile)='HOSTED') THEN
4718: b_hosted:=TRUE;