[Home] [Help]
1: package body OracleSSWA as
2: /* $Header: ICXSSWAB.pls 120.6 2012/04/12 19:48:36 ctilley 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
285: begin
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,
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:
552: l_listener_token := OracleSSWA.listener_token;
553:
554: l_call := dbms_sql.open_cursor;
555: -- l_gen_redirect_url:= wwsec_sso_enabler.generate_redirect(p_lsnr_token => l_listener_token,
556: -- p_url_requested => l_urlrequested,
787: val => l_apps_web_agent);
788:
789: l_url := FND_WEB_CONFIG.TRAIL_SLASH(l_apps_web_agent);
790:
791: --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||'*'||'**]'));
792:
793: --bug 267712 added L parm to anchor
794: c_anchor := 'OracleSSWA.Execute?F='||F||'&E='||E||'&P='||P||'&L='||L;
795:
790:
791: --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||'*'||'**]'));
792:
793: --bug 267712 added L parm to anchor
794: c_anchor := 'OracleSSWA.Execute?F='||F||'&E='||E||'&P='||P||'&L='||L;
795:
796: owa_util.mime_header('text/html', FALSE);
797: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
798: icx_sec.sendSessionCookie(l_session_id);
898: application_id_z => l_resp_appl_id,
899: val_z => l_apps_web_agent,
900: defined_z => l_profile_defined);
901: l_url := FND_WEB_CONFIG.TRAIL_SLASH(l_apps_web_agent);
902: 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;
903:
904: OracleApps.displayLogin(i_direct => l_url,
905: recreate => l_recreate_code);
906:
940: application_id_z => l_resp_appl_id,
941: val_z => l_apps_web_agent,
942: defined_z => l_profile_defined);
943: l_url := FND_WEB_CONFIG.TRAIL_SLASH(l_apps_web_agent);
944: 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||'*'||'**]'));
945:
946: owa_util.mime_header('text/html', FALSE);
947: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
948: icx_sec.sendSessionCookie(l_session_id);
975: -- session not valid... or current user cannot access function
976: -- function is not public... need to login.
977: IF ((nvl(l_apps_sso,'SSWA')='SSO_SDK') OR
978: (nvl(l_apps_sso,'SSWA')='SSWA_SSO'))THEN
979: OracleSSWA.convertSession;
980: ELSE
981:
982: --need a session for convertsession to work
983: --get anonymous user info
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
1016: icx_sec.sendSessionCookie(l_session_id);
1111: END IF;
1112:
1113: -- Wait SSO
1114:
1115: l_listener_token := OracleSSWA.listener_token;
1116: -- l_gen_redirect_url := wwsec_sso_enabler.generate_redirect(p_lsnr_token => l_listener_token,
1117: -- p_url_requested => l_urlrequested,
1118: -- p_url_cancel => l_urlcancel);
1119:
1186: -- htp.p(sqlerrm);
1187: htp.p(dbms_utility.format_error_stack);
1188: END logout;
1189:
1190: end OracleSSWA;