121:
122: exception
123: when others then
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
122: exception
123: when others then
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);
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:
133: end;
134:
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:
133: end;
134:
135: -- OA Framework version of bookmarkthis which can do some really
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. ');
196: htp.p ('Profile - APPS_PORTAL is null') ;
197: end If ;
198:
199: l_end := instrb(l_url,'/',-1,1);
192: val => l_url);
193:
194: if l_url IS NULL Then
195: htp.p ('Please contact System Administrator. ');
196: htp.p ('Profile - APPS_PORTAL is null') ;
197: end If ;
198:
199: l_end := instrb(l_url,'/',-1,1);
200: l_url := substrb(l_url,1,l_end);
203: owa_util.redirect_url(l_url);
204:
205: exception
206: when others then
207: -- htp.p(SQLERRM);
208: htp.p(dbms_utility.format_error_stack);
209: end;
210:
211: function listener_token return varchar2 is
204:
205: exception
206: when others then
207: -- htp.p(SQLERRM);
208: htp.p(dbms_utility.format_error_stack);
209: end;
210:
211: function listener_token return varchar2 is
212:
582: owa_util.redirect_url(l_gen_redirect_url);
583:
584: exception
585: when others then
586: -- htp.p(SQLERRM);
587: htp.p(dbms_utility.format_error_stack);
588:
589: end;
590:
583:
584: exception
585: when others then
586: -- htp.p(SQLERRM);
587: htp.p(dbms_utility.format_error_stack);
588:
589: end;
590:
591: procedure execute (F IN VARCHAR2,
967: FUNCTION_ID = l_function_id,
968: FUNCTION_TYPE = l_function_type
969: where SESSION_ID = l_session_id;
970: commit;
971: htp.p('');
972:
973: ELSE
974: icx_sec.g_prog_appl_id := -1;
975: -- session not valid... or current user cannot access function
1053: END IF;
1054:
1055: EXCEPTION
1056: WHEN e_refresh_4_cookie THEN
1057: htp.p('');
1058:
1059: WHEN e_invalid_function THEN
1060:
1061: fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
1173: value => '-1',
1174: path => '/',
1175: domain => icx_sec.getsessioncookiedomain
1176: );
1177: --htp.p('Content-Length: ' || length(l_img));
1178: htp.p('Expires: Thu, 29 Oct 1970 17:04:19 GMT');
1179: htp.p('Pragma: no-cache');
1180: htp.p('Cache-Control: no-cache');
1181: owa_util.redirect_url('/OA_MEDIA/completeind_status.gif');
1174: path => '/',
1175: domain => icx_sec.getsessioncookiedomain
1176: );
1177: --htp.p('Content-Length: ' || length(l_img));
1178: htp.p('Expires: Thu, 29 Oct 1970 17:04:19 GMT');
1179: htp.p('Pragma: no-cache');
1180: htp.p('Cache-Control: no-cache');
1181: owa_util.redirect_url('/OA_MEDIA/completeind_status.gif');
1182: owa_util.http_header_close;
1175: domain => icx_sec.getsessioncookiedomain
1176: );
1177: --htp.p('Content-Length: ' || length(l_img));
1178: htp.p('Expires: Thu, 29 Oct 1970 17:04:19 GMT');
1179: htp.p('Pragma: no-cache');
1180: htp.p('Cache-Control: no-cache');
1181: owa_util.redirect_url('/OA_MEDIA/completeind_status.gif');
1182: owa_util.http_header_close;
1183: --wpg_docload.download_file(l_img);
1176: );
1177: --htp.p('Content-Length: ' || length(l_img));
1178: htp.p('Expires: Thu, 29 Oct 1970 17:04:19 GMT');
1179: htp.p('Pragma: no-cache');
1180: htp.p('Cache-Control: no-cache');
1181: owa_util.redirect_url('/OA_MEDIA/completeind_status.gif');
1182: owa_util.http_header_close;
1183: --wpg_docload.download_file(l_img);
1184: EXCEPTION
1182: owa_util.http_header_close;
1183: --wpg_docload.download_file(l_img);
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: -- htp.p(sqlerrm);
1187: htp.p(dbms_utility.format_error_stack);
1188: END logout;
1189:
1190: end OracleSSWA;
1183: --wpg_docload.download_file(l_img);
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: -- htp.p(sqlerrm);
1187: htp.p(dbms_utility.format_error_stack);
1188: END logout;
1189:
1190: end OracleSSWA;