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

Line 79: fnd_profile.get_specific(

75: where rownum < 2;
76:
77: if l_multi_org_flag = 'Y'
78: then
79: fnd_profile.get_specific(
80: name_z => 'ORG_ID',
81: responsibility_id_z => l_responsibility_id,
82: application_id_z => l_resp_appl_id,
83: val_z => l_org_id,

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

187: l_end number;
188:
189: begin
190:
191: fnd_profile.get(name => 'APPS_PORTAL',
192: val => l_url);
193:
194: if l_url IS NULL Then
195: htp.p ('Please contact System Administrator. ');

Line 219: fnd_profile.get_specific(

215: l_server VARCHAR2(240);
216:
217: begin
218:
219: fnd_profile.get_specific(
220: name_z => 'APPS_SSO_LISTENER_TOKEN',
221: val_z => l_listener_token,
222: defined_z => l_profile_defined);
223:

Line 229: fnd_profile.get_specific(

225:
226: then
227:
228: -- bug 2712473
229: fnd_profile.get_specific(
230: name_z => 'APPS_DATABASE_ID',
231: val_z => l_listener_token,
232: defined_z => l_profile_defined);
233: if l_listener_token is null

Line 288: fnd_profile.get_specific(

284:
285: icx_sec.ServerLevel;
286:
287: l_listener_token := OracleSSWA.listener_token;
288: fnd_profile.get_specific(
289: name_z => 'APPS_SSO',
290: user_id_z => l_user_id,
291: val_z => l_apps_sso,
292: defined_z => l_profile_defined);

Line 341: portalUrl := fnd_profile.value('APPS_PORTAL');

337: dbms_sql.close_cursor(l_call);
338:
339: END IF;--apps_sso profile option
340:
341: portalUrl := fnd_profile.value('APPS_PORTAL');
342: portalUrlBase := substr(portalUrl, 0, length(portalUrl) - 4);
343:
344: if (l_url_requested = 'APPSHOMEPAGE') then
345: if(fnd_profile.value('APPS_SSO') = 'SSO_SDK') then

Line 345: if(fnd_profile.value('APPS_SSO') = 'SSO_SDK') then

341: portalUrl := fnd_profile.value('APPS_PORTAL');
342: portalUrlBase := substr(portalUrl, 0, length(portalUrl) - 4);
343:
344: if (l_url_requested = 'APPSHOMEPAGE') then
345: if(fnd_profile.value('APPS_SSO') = 'SSO_SDK') then
346: l_url_requested :=
347: portalUrlBase||'wwsec_app_priv.login?p_requested_url='||wfa_html.conv_special_url_chars(portalUrl)||'&p_cancel_url='||wfa_html.conv_special_url_chars(portalUrl);
348: else
349: l_url_requested := FND_WEB_CONFIG.PLSQL_AGENT||'OracleMyPage.Home';

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

373: EXCEPTION
374: WHEN no_data_found THEN
375: c_user_id := -999;
376: END;
377: -- fnd_profile.get(name => 'GUEST_USER_PWD',
378: -- val => l_anon_name);
379: -- Using new api to retrieve GUEST credentials.
380: l_anon_name := fnd_web_sec.get_guest_username_pwd;
381:

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

531: owa_util.get_cgi_env('SCRIPT_NAME')||
532: owa_util.get_cgi_env('PATH_INFO')||'?'||
533: owa_util.get_cgi_env('QUERY_STRING');
534:
535: fnd_profile.get(name => 'APPS_SSO',
536: val => l_apps_sso);
537: -- Wait SSO
538: IF ((nvl(l_apps_sso,'SSWA')='SSO_SDK') OR (nvl(l_apps_sso,'SSWA')='SSWA_SSO')) THEN
539:

Line 669: fnd_profile.get_specific(

665: raise e_invalid_function;
666:
667: END IF;--e is null
668: -- function identified
669: fnd_profile.get_specific(
670: name_z => 'APPS_SSO',
671: user_id_z => l_user_id,
672: val_z => l_apps_sso,
673: defined_z => l_profile_defined);

Line 713: fnd_profile.get_specific(

709: where rownum < 2;
710:
711: if l_multi_org_flag = 'Y'
712: then
713: fnd_profile.get_specific(
714: name_z => 'ORG_ID',
715: responsibility_id_z => l_responsibility_id,
716: application_id_z => l_resp_appl_id,
717: val_z => l_org_id,

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

737: commit;
738:
739: ELSE
740: --get anonymous user info
741: -- fnd_profile.get(name => 'GUEST_USER_PWD',
742: -- val => l_guest_profile_value);
743: -- Using new api to retrieve GUEST credentials.
744: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
745: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);

Line 767: fnd_profile.get_specific(

763: l_mode := '115X';
764: END IF;
765: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
766: /*
767: fnd_profile.get_specific(
768: name_z => 'APPS_WEB_AGENT',
769: responsibility_id_z => l_responsibility_id,
770: application_id_z => l_resp_appl_id,
771: val_z => l_apps_web_agent,

Line 774: fnd_profile.get(name => 'APPS_WEB_AGENT',

770: application_id_z => l_resp_appl_id,
771: val_z => l_apps_web_agent,
772: defined_z => l_profile_defined);
773: */
774: fnd_profile.get(name => 'APPS_WEB_AGENT',
775: val => l_apps_web_agent);
776:
777: l_url := FND_WEB_CONFIG.TRAIL_SLASH(l_apps_web_agent);
778:

Line 817: fnd_profile.get_specific(

813:
814: IF f_type = 'FORM' THEN
815:
816: /* 3220523 Replace hard coded RF.jsp
817: fnd_profile.get_specific(
818: name_z => 'APPS_SERVLET_AGENT',
819: val_z => l_servlet_agent,
820: defined_z => l_profile_defined);
821: l_servlet_agent:=FND_WEB_CONFIG.TRAIL_SLASH(replace(upper(l_servlet_agent),'OA_SERVLETS','OA_HTML'));

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

819: val_z => l_servlet_agent,
820: defined_z => l_profile_defined);
821: l_servlet_agent:=FND_WEB_CONFIG.TRAIL_SLASH(replace(upper(l_servlet_agent),'OA_SERVLETS','OA_HTML'));
822:
823: fnd_profile.get(name => 'APPS_DATABASE_ID',
824: val => l_dbc);
825:
826: if l_dbc is null
827: then

Line 883: fnd_profile.get_specific(

879: and i.USER_ID = fu.USER_ID;
880:
881: l_recreate_code := icx_call.encrypt(l_session_id||'*'||l_user_name||'**]');
882:
883: fnd_profile.get_specific(
884: name_z => 'APPS_WEB_AGENT',
885: responsibility_id_z => l_responsibility_id,
886: application_id_z => l_resp_appl_id,
887: val_z => l_apps_web_agent,

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

896: ELSIF (fnd_function.test_id(l_function_id)) -- OR (l_function_id=2594)
897: THEN -- VS Failed.. if function is public, create session and go!
898: icx_sec.g_prog_appl_id := -1;
899: --get anonymous user info
900: -- fnd_profile.get(name => 'GUEST_USER_PWD',
901: -- val => l_guest_profile_value);
902: -- Using new api to retrieve GUEST credentials.
903: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
904: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);

Line 925: fnd_profile.get_specific(

921: ELSE
922: l_mode := '115X';
923: END IF;
924: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
925: fnd_profile.get_specific(
926: name_z => 'APPS_WEB_AGENT',
927: responsibility_id_z => l_responsibility_id,
928: application_id_z => l_resp_appl_id,
929: val_z => l_apps_web_agent,

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

940: into l_multi_org_flag
941: from fnd_product_groups
942: where rownum < 2;
943: if l_multi_org_flag = 'Y' THEN
944: fnd_profile.get_specific(name_z => 'ORG_ID',
945: responsibility_id_z => l_responsibility_id,
946: application_id_z => l_resp_appl_id,
947: val_z => l_org_id,
948: defined_z => l_profile_defined);

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

968: ELSE
969:
970: --need a session for convertsession to work
971: --get anonymous user info
972: -- fnd_profile.get(name => 'GUEST_USER_PWD',
973: -- val => l_guest_profile_value);
974: -- Using new api to retrieve GUEST credentials.
975: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
976: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);

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

995: ELSE
996: l_mode := '115X';
997: END IF;
998: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
999: -- l_url := FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'));
1000: -- c_anchor := 'OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||l_function_id||'*'||'**]'));
1001:
1002: owa_util.mime_header('text/html', FALSE);
1003: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545

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

1011: into l_multi_org_flag
1012: from fnd_product_groups
1013: where rownum < 2;
1014: if l_multi_org_flag = 'Y' THEN
1015: fnd_profile.get_specific(name_z => 'ORG_ID',
1016: responsibility_id_z => l_responsibility_id,
1017: application_id_z => l_resp_appl_id,
1018: val_z => l_org_id,
1019: defined_z => l_profile_defined);

Line 1087: fnd_profile.get_specific(name_z => 'APPS_PORTAL',

1083:
1084: BEGIN
1085:
1086: IF p_req_url IS NULL THEN
1087: fnd_profile.get_specific(name_z => 'APPS_PORTAL',
1088: val_z => l_urlrequested,
1089: defined_z => l_defined );
1090: ELSE
1091: l_urlrequested :=p_req_url;

Line 1094: fnd_profile.get_specific(name_z => 'APPS_PORTAL',

1090: ELSE
1091: l_urlrequested :=p_req_url;
1092: END IF;
1093: IF p_cancel_url IS NULL THEN
1094: fnd_profile.get_specific(name_z => 'APPS_PORTAL',
1095: val_z => l_urlcancel,
1096: defined_z => l_defined );
1097: ELSE
1098: l_urlcancel:=p_cancel_url;