54: p_function_id => l_function_id,
55: p_parameters => P,
56: p_url_only => 'Y');
57:
58: owa_util.mime_header('text/html', FALSE);
59:
60: owa_util.redirect_url(l_url);
61:
62: owa_util.http_header_close;
56: p_url_only => 'Y');
57:
58: owa_util.mime_header('text/html', FALSE);
59:
60: owa_util.redirect_url(l_url);
61:
62: owa_util.http_header_close;
63:
64: /*
58: owa_util.mime_header('text/html', FALSE);
59:
60: owa_util.redirect_url(l_url);
61:
62: owa_util.http_header_close;
63:
64: /*
65: select TYPE
66: into l_function_type
199: l_end := instrb(l_url,'/',-1,1);
200: l_url := substrb(l_url,1,l_end);
201: l_url := l_url||'url/page/'||pagename;
202:
203: owa_util.redirect_url(l_url);
204:
205: exception
206: when others then
207: -- htp.p(SQLERRM);
403: SET last_connect = sysdate,
404: first_connect = SYSDATE,
405: counter = 1
406: WHERE session_id = l_session_id;
407: owa_util.mime_header('text/html', FALSE);
408: owa_util.redirect_url(l_url_requested);
409: owa_util.http_header_close;
410: ELSIF ((l_session_status<>'INVALID') AND (c_user_id = l_anon_id) AND (l_anon_id <> -999) AND (c_user_id <> l_user_id)) THEN
411:
404: first_connect = SYSDATE,
405: counter = 1
406: WHERE session_id = l_session_id;
407: owa_util.mime_header('text/html', FALSE);
408: owa_util.redirect_url(l_url_requested);
409: owa_util.http_header_close;
410: ELSIF ((l_session_status<>'INVALID') AND (c_user_id = l_anon_id) AND (l_anon_id <> -999) AND (c_user_id <> l_user_id)) THEN
411:
412: icx_sec.setUserNLS
405: counter = 1
406: WHERE session_id = l_session_id;
407: owa_util.mime_header('text/html', FALSE);
408: owa_util.redirect_url(l_url_requested);
409: owa_util.http_header_close;
410: ELSIF ((l_session_status<>'INVALID') AND (c_user_id = l_anon_id) AND (l_anon_id <> -999) AND (c_user_id <> l_user_id)) THEN
411:
412: icx_sec.setUserNLS
413: (l_user_id,
439: last_connect = sysdate,
440: first_connect = SYSDATE,
441: counter = 1
442: WHERE session_id = l_session_id;
443: owa_util.mime_header('text/html', FALSE);
444: owa_util.redirect_url(l_url_requested);
445: owa_util.http_header_close;
446: --end code for preservation of session_id when switching from anonymous user to authenticated user
447: ELSE
440: first_connect = SYSDATE,
441: counter = 1
442: WHERE session_id = l_session_id;
443: owa_util.mime_header('text/html', FALSE);
444: owa_util.redirect_url(l_url_requested);
445: owa_util.http_header_close;
446: --end code for preservation of session_id when switching from anonymous user to authenticated user
447: ELSE
448:
441: counter = 1
442: WHERE session_id = l_session_id;
443: owa_util.mime_header('text/html', FALSE);
444: owa_util.redirect_url(l_url_requested);
445: owa_util.http_header_close;
446: --end code for preservation of session_id when switching from anonymous user to authenticated user
447: ELSE
448:
449: --this is not an anonymous session conversion.. create a new session and send a new cookie!
459: END IF;
460: l_session_id := icx_sec.createSession
461: (p_user_id => l_user_id,
462: c_mode_code => l_mode);
463: owa_util.mime_header('text/html', FALSE);
464: owa_cookie.send(name=>'DEBUG_COOKIE', value=>'-1', expires=>'', path=>'/');
465: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
466: icx_sec.sendsessioncookie(l_session_id);
467: owa_util.redirect_url(l_url_requested);
463: owa_util.mime_header('text/html', FALSE);
464: owa_cookie.send(name=>'DEBUG_COOKIE', value=>'-1', expires=>'', path=>'/');
465: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
466: icx_sec.sendsessioncookie(l_session_id);
467: owa_util.redirect_url(l_url_requested);
468: owa_util.http_header_close;
469:
470: END IF;
471:
464: owa_cookie.send(name=>'DEBUG_COOKIE', value=>'-1', expires=>'', path=>'/');
465: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
466: icx_sec.sendsessioncookie(l_session_id);
467: owa_util.redirect_url(l_url_requested);
468: owa_util.http_header_close;
469:
470: END IF;
471:
472: exception
475: (nvl(l_apps_sso,'SSWA')='SSWA_SSO')) AND
476: (icx_sec.g_window_cookie_name = 'X')
477: THEN
478: l_url_requested := fnd_sso_manager.getLoginUrl;
479: owa_util.mime_header('text/html', FALSE);
480: owa_util.redirect_url(l_url_requested);
481: owa_util.http_header_close;
482: ELSE
483: raise;
476: (icx_sec.g_window_cookie_name = 'X')
477: THEN
478: l_url_requested := fnd_sso_manager.getLoginUrl;
479: owa_util.mime_header('text/html', FALSE);
480: owa_util.redirect_url(l_url_requested);
481: owa_util.http_header_close;
482: ELSE
483: raise;
484: END IF;
477: THEN
478: l_url_requested := fnd_sso_manager.getLoginUrl;
479: owa_util.mime_header('text/html', FALSE);
480: owa_util.redirect_url(l_url_requested);
481: owa_util.http_header_close;
482: ELSE
483: raise;
484: END IF;
485: end sign_on;
522: l_apps_sso VARCHAR2(30);
523:
524:
525: begin
526: --lower(owa_util.get_cgi_env('REQUEST_PROTOCOL'))||'://'||
527: l_urlrequested :=
528: FND_WEB_CONFIG.PROTOCOL||'//'||
529: owa_util.get_cgi_env('SERVER_NAME')||':'||
530: owa_util.get_cgi_env('SERVER_PORT')||
525: begin
526: --lower(owa_util.get_cgi_env('REQUEST_PROTOCOL'))||'://'||
527: l_urlrequested :=
528: FND_WEB_CONFIG.PROTOCOL||'//'||
529: owa_util.get_cgi_env('SERVER_NAME')||':'||
530: owa_util.get_cgi_env('SERVER_PORT')||
531: owa_util.get_cgi_env('SCRIPT_NAME')||
532: owa_util.get_cgi_env('PATH_INFO')||'?'||
533: owa_util.get_cgi_env('QUERY_STRING');
526: --lower(owa_util.get_cgi_env('REQUEST_PROTOCOL'))||'://'||
527: l_urlrequested :=
528: FND_WEB_CONFIG.PROTOCOL||'//'||
529: owa_util.get_cgi_env('SERVER_NAME')||':'||
530: owa_util.get_cgi_env('SERVER_PORT')||
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:
527: l_urlrequested :=
528: FND_WEB_CONFIG.PROTOCOL||'//'||
529: owa_util.get_cgi_env('SERVER_NAME')||':'||
530: owa_util.get_cgi_env('SERVER_PORT')||
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',
528: FND_WEB_CONFIG.PROTOCOL||'//'||
529: owa_util.get_cgi_env('SERVER_NAME')||':'||
530: owa_util.get_cgi_env('SERVER_PORT')||
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);
529: owa_util.get_cgi_env('SERVER_NAME')||':'||
530: owa_util.get_cgi_env('SERVER_PORT')||
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
566:
567: dbms_sql.close_cursor(l_call);
568:
569: END IF;--apps_sso profile
570: owa_util.redirect_url(l_gen_redirect_url);
571:
572: exception
573: when others then
574: -- htp.p(SQLERRM);
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);
787: owa_util.http_header_close;
788:
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);
787: owa_util.http_header_close;
788:
789: RAISE e_refresh_4_cookie;
790:
791: END IF;--cookie
840: P_RESP_APPL_ID => l_resp_appl_id,
841: P_RESP_ID => l_responsibility_id,
842: P_SECURITY_GROUP_ID => nvl(l_security_group_id,'0'));
843:
844: owa_util.redirect_url(l_servlet_agent);
845:
846: ELSE
847: IF p IS NOT NULL THEN
848: l_params := icx_call.decrypt(P);
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);
937: owa_util.http_header_close;
938:
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);
937: owa_util.http_header_close;
938:
939: select multi_org_flag
940: into l_multi_org_flag
941: from fnd_product_groups
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);
1005: owa_util.http_header_close;
1006: --- end create new session
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);
1005: owa_util.http_header_close;
1006: --- end create new session
1007:
1008: END IF;
1009:
1152: -- '00000D000D0040041FF0C949'||
1153: -- '2B618CD4C92AD65B2872DF73'||
1154: -- '4965088EEC8865CF4BAE64AA'||
1155: -- 'D2ED1601003B');
1156: owa_util.mime_header('image/gif', FALSE);
1157: -- Reset cookie
1158: owa_cookie.send
1159: (
1160: name => icx_sec.getsessioncookiename,
1165: --htp.p('Content-Length: ' || length(l_img));
1166: htp.p('Expires: Thu, 29 Oct 1970 17:04:19 GMT');
1167: htp.p('Pragma: no-cache');
1168: htp.p('Cache-Control: no-cache');
1169: owa_util.redirect_url('/OA_MEDIA/completeind_status.gif');
1170: owa_util.http_header_close;
1171: --wpg_docload.download_file(l_img);
1172: EXCEPTION
1173: WHEN OTHERS THEN
1166: htp.p('Expires: Thu, 29 Oct 1970 17:04:19 GMT');
1167: htp.p('Pragma: no-cache');
1168: htp.p('Cache-Control: no-cache');
1169: owa_util.redirect_url('/OA_MEDIA/completeind_status.gif');
1170: owa_util.http_header_close;
1171: --wpg_docload.download_file(l_img);
1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: -- htp.p(sqlerrm);