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:
570: owa_util.redirect_url(l_gen_redirect_url);
571:
572: exception
573: when others then
574: -- htp.p(SQLERRM);
575: htp.p(dbms_utility.format_error_stack);
576:
577: end;
578:
571:
572: exception
573: when others then
574: -- htp.p(SQLERRM);
575: htp.p(dbms_utility.format_error_stack);
576:
577: end;
578:
579: procedure execute (F IN VARCHAR2,
955: FUNCTION_ID = l_function_id,
956: FUNCTION_TYPE = l_function_type
957: where SESSION_ID = l_session_id;
958: commit;
959: htp.p('');
960:
961: ELSE
962: icx_sec.g_prog_appl_id := -1;
963: -- session not valid... or current user cannot access function
1041: END IF;
1042:
1043: EXCEPTION
1044: WHEN e_refresh_4_cookie THEN
1045: htp.p('');
1046:
1047: WHEN e_invalid_function THEN
1048:
1049: fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
1161: value => '-1',
1162: path => '/',
1163: domain => icx_sec.getsessioncookiedomain
1164: );
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');
1162: path => '/',
1163: domain => icx_sec.getsessioncookiedomain
1164: );
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;
1163: domain => icx_sec.getsessioncookiedomain
1164: );
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);
1164: );
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
1170: owa_util.http_header_close;
1171: --wpg_docload.download_file(l_img);
1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: -- htp.p(sqlerrm);
1175: htp.p(dbms_utility.format_error_stack);
1176: END logout;
1177:
1178: end OracleSSWA;
1171: --wpg_docload.download_file(l_img);
1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: -- htp.p(sqlerrm);
1175: htp.p(dbms_utility.format_error_stack);
1176: END logout;
1177:
1178: end OracleSSWA;