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

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

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

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

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

343: portalUrl := fnd_profile.value('APPS_PORTAL');
344: portalUrlBase := substr(portalUrl, 0, length(portalUrl) - 4);
345:
346: if (l_url_requested = 'APPSHOMEPAGE') then
347: if(fnd_profile.value('APPS_SSO') = 'SSO_SDK') then
348: l_url_requested :=
349: 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);
350: else
351: l_url_requested := FND_WEB_CONFIG.PLSQL_AGENT||'OracleMyPage.Home';

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

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

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

543: owa_util.get_cgi_env('SCRIPT_NAME')||
544: owa_util.get_cgi_env('PATH_INFO')||'?'||
545: owa_util.get_cgi_env('QUERY_STRING');
546:
547: fnd_profile.get(name => 'APPS_SSO',
548: val => l_apps_sso);
549: -- Wait SSO
550: IF ((nvl(l_apps_sso,'SSWA')='SSO_SDK') OR (nvl(l_apps_sso,'SSWA')='SSWA_SSO')) THEN
551:

Line 681: fnd_profile.get_specific(

677: raise e_invalid_function;
678:
679: END IF;--e is null
680: -- function identified
681: fnd_profile.get_specific(
682: name_z => 'APPS_SSO',
683: user_id_z => l_user_id,
684: val_z => l_apps_sso,
685: defined_z => l_profile_defined);

Line 725: fnd_profile.get_specific(

721: where rownum < 2;
722:
723: if l_multi_org_flag = 'Y'
724: then
725: fnd_profile.get_specific(
726: name_z => 'ORG_ID',
727: responsibility_id_z => l_responsibility_id,
728: application_id_z => l_resp_appl_id,
729: val_z => l_org_id,

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

749: commit;
750:
751: ELSE
752: --get anonymous user info
753: -- fnd_profile.get(name => 'GUEST_USER_PWD',
754: -- val => l_guest_profile_value);
755: -- Using new api to retrieve GUEST credentials.
756: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
757: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);

Line 779: fnd_profile.get_specific(

775: l_mode := '115X';
776: END IF;
777: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
778: /*
779: fnd_profile.get_specific(
780: name_z => 'APPS_WEB_AGENT',
781: responsibility_id_z => l_responsibility_id,
782: application_id_z => l_resp_appl_id,
783: val_z => l_apps_web_agent,

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

782: application_id_z => l_resp_appl_id,
783: val_z => l_apps_web_agent,
784: defined_z => l_profile_defined);
785: */
786: fnd_profile.get(name => 'APPS_WEB_AGENT',
787: val => l_apps_web_agent);
788:
789: l_url := FND_WEB_CONFIG.TRAIL_SLASH(l_apps_web_agent);
790:

Line 829: fnd_profile.get_specific(

825:
826: IF f_type = 'FORM' THEN
827:
828: /* 3220523 Replace hard coded RF.jsp
829: fnd_profile.get_specific(
830: name_z => 'APPS_SERVLET_AGENT',
831: val_z => l_servlet_agent,
832: defined_z => l_profile_defined);
833: l_servlet_agent:=FND_WEB_CONFIG.TRAIL_SLASH(replace(upper(l_servlet_agent),'OA_SERVLETS','OA_HTML'));

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

831: val_z => l_servlet_agent,
832: defined_z => l_profile_defined);
833: l_servlet_agent:=FND_WEB_CONFIG.TRAIL_SLASH(replace(upper(l_servlet_agent),'OA_SERVLETS','OA_HTML'));
834:
835: fnd_profile.get(name => 'APPS_DATABASE_ID',
836: val => l_dbc);
837:
838: if l_dbc is null
839: then

Line 895: fnd_profile.get_specific(

891: and i.USER_ID = fu.USER_ID;
892:
893: l_recreate_code := icx_call.encrypt(l_session_id||'*'||l_user_name||'**]');
894:
895: fnd_profile.get_specific(
896: name_z => 'APPS_WEB_AGENT',
897: responsibility_id_z => l_responsibility_id,
898: application_id_z => l_resp_appl_id,
899: val_z => l_apps_web_agent,

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

908: ELSIF (fnd_function.test_id(l_function_id)) -- OR (l_function_id=2594)
909: THEN -- VS Failed.. if function is public, create session and go!
910: icx_sec.g_prog_appl_id := -1;
911: --get anonymous user info
912: -- fnd_profile.get(name => 'GUEST_USER_PWD',
913: -- val => l_guest_profile_value);
914: -- Using new api to retrieve GUEST credentials.
915: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
916: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);

Line 937: fnd_profile.get_specific(

933: ELSE
934: l_mode := '115X';
935: END IF;
936: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
937: fnd_profile.get_specific(
938: name_z => 'APPS_WEB_AGENT',
939: responsibility_id_z => l_responsibility_id,
940: application_id_z => l_resp_appl_id,
941: val_z => l_apps_web_agent,

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

952: into l_multi_org_flag
953: from fnd_product_groups
954: where rownum < 2;
955: if l_multi_org_flag = 'Y' THEN
956: fnd_profile.get_specific(name_z => 'ORG_ID',
957: responsibility_id_z => l_responsibility_id,
958: application_id_z => l_resp_appl_id,
959: val_z => l_org_id,
960: defined_z => l_profile_defined);

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

980: ELSE
981:
982: --need a session for convertsession to work
983: --get anonymous user info
984: -- fnd_profile.get(name => 'GUEST_USER_PWD',
985: -- val => l_guest_profile_value);
986: -- Using new api to retrieve GUEST credentials.
987: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
988: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);

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

1007: ELSE
1008: l_mode := '115X';
1009: END IF;
1010: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
1011: -- l_url := FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'));
1012: -- 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||'*'||'**]'));
1013:
1014: owa_util.mime_header('text/html', FALSE);
1015: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545

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

1023: into l_multi_org_flag
1024: from fnd_product_groups
1025: where rownum < 2;
1026: if l_multi_org_flag = 'Y' THEN
1027: fnd_profile.get_specific(name_z => 'ORG_ID',
1028: responsibility_id_z => l_responsibility_id,
1029: application_id_z => l_resp_appl_id,
1030: val_z => l_org_id,
1031: defined_z => l_profile_defined);

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

1095:
1096: BEGIN
1097:
1098: IF p_req_url IS NULL THEN
1099: fnd_profile.get_specific(name_z => 'APPS_PORTAL',
1100: val_z => l_urlrequested,
1101: defined_z => l_defined );
1102: ELSE
1103: l_urlrequested :=p_req_url;

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

1102: ELSE
1103: l_urlrequested :=p_req_url;
1104: END IF;
1105: IF p_cancel_url IS NULL THEN
1106: fnd_profile.get_specific(name_z => 'APPS_PORTAL',
1107: val_z => l_urlcancel,
1108: defined_z => l_defined );
1109: ELSE
1110: l_urlcancel:=p_cancel_url;