[Home] [Help]
1: package body OracleSSWA as
2: /* $Header: ICXSSWAB.pls 120.1 2007/12/28 09:56:26 stadepal ship $ */
3:
4: procedure bookmarkthis (icxtoken in varchar2,
5: p in varchar2) is
124: icx_sec.g_validateSession_flag := true;
125: htp.p('User does not have access to this function');
126: htp.nl;
127: --NEED TO DO!::
128: --if this is portal/sso, send to oraclesswa.convertsession
129: --if this is php, send to oracleapps.convertsession with encrypted param string
130: -- htp.p(SQLERRM);
131: htp.p(dbms_utility.format_error_stack);
132:
176: where function_name = 'FND_NAVIGATE_SCTX_PORTLET')
177: and user_id = l_user_id;
178:
179: -- Do whatever the BookmarkThis
180: OracleSSWA.BookmarkThis(icxtoken, p);
181: end;
182:
183:
184: procedure switchpage (pagename in varchar2) is
283: begin
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,
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:
540: l_listener_token := OracleSSWA.listener_token;
541:
542: l_call := dbms_sql.open_cursor;
543: -- l_gen_redirect_url:= wwsec_sso_enabler.generate_redirect(p_lsnr_token => l_listener_token,
544: -- p_url_requested => l_urlrequested,
775: val => l_apps_web_agent);
776:
777: l_url := FND_WEB_CONFIG.TRAIL_SLASH(l_apps_web_agent);
778:
779: --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||'*'||'**]'));
780:
781: --bug 267712 added L parm to anchor
782: c_anchor := 'OracleSSWA.Execute?F='||F||'&E='||E||'&P='||P||'&L='||L;
783:
778:
779: --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||'*'||'**]'));
780:
781: --bug 267712 added L parm to anchor
782: c_anchor := 'OracleSSWA.Execute?F='||F||'&E='||E||'&P='||P||'&L='||L;
783:
784: owa_util.mime_header('text/html', FALSE);
785: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
786: icx_sec.sendSessionCookie(l_session_id);
886: application_id_z => l_resp_appl_id,
887: val_z => l_apps_web_agent,
888: defined_z => l_profile_defined);
889: l_url := FND_WEB_CONFIG.TRAIL_SLASH(l_apps_web_agent);
890: l_url := l_url||'OracleSSWA.Execute?E='||icx_call.encrypt(l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||l_function_id||'*'||'**]')||'&'||'P='||P||'&'||'L='||L;
891:
892: OracleApps.displayLogin(i_direct => l_url,
893: recreate => l_recreate_code);
894:
928: application_id_z => l_resp_appl_id,
929: val_z => l_apps_web_agent,
930: defined_z => l_profile_defined);
931: l_url := FND_WEB_CONFIG.TRAIL_SLASH(l_apps_web_agent);
932: 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||'*'||'**]'));
933:
934: owa_util.mime_header('text/html', FALSE);
935: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
936: icx_sec.sendSessionCookie(l_session_id);
963: -- session not valid... or current user cannot access function
964: -- function is not public... need to login.
965: IF ((nvl(l_apps_sso,'SSWA')='SSO_SDK') OR
966: (nvl(l_apps_sso,'SSWA')='SSWA_SSO'))THEN
967: OracleSSWA.convertSession;
968: ELSE
969:
970: --need a session for convertsession to work
971: --get anonymous user info
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
1004: icx_sec.sendSessionCookie(l_session_id);
1099: END IF;
1100:
1101: -- Wait SSO
1102:
1103: l_listener_token := OracleSSWA.listener_token;
1104: -- l_gen_redirect_url := wwsec_sso_enabler.generate_redirect(p_lsnr_token => l_listener_token,
1105: -- p_url_requested => l_urlrequested,
1106: -- p_url_cancel => l_urlcancel);
1107:
1174: -- htp.p(sqlerrm);
1175: htp.p(dbms_utility.format_error_stack);
1176: END logout;
1177:
1178: end OracleSSWA;