499: if (fnd_web_config.check_enabled(proc) = 'Y') then
500: cmd := 'begin '||proc||'(:1); end;';
501: execute immediate cmd using in arg;
502: else
503: htp.htmlOpen;
504: htp.headOpen;
505: htp.title('Access Denied');
506: htp.headClose;
507: htp.bodyOpen;
500: cmd := 'begin '||proc||'(:1); end;';
501: execute immediate cmd using in arg;
502: else
503: htp.htmlOpen;
504: htp.headOpen;
505: htp.title('Access Denied');
506: htp.headClose;
507: htp.bodyOpen;
508: htp.p('Access Denied');
501: execute immediate cmd using in arg;
502: else
503: htp.htmlOpen;
504: htp.headOpen;
505: htp.title('Access Denied');
506: htp.headClose;
507: htp.bodyOpen;
508: htp.p('Access Denied');
509: htp.hr;
502: else
503: htp.htmlOpen;
504: htp.headOpen;
505: htp.title('Access Denied');
506: htp.headClose;
507: htp.bodyOpen;
508: htp.p('Access Denied');
509: htp.hr;
510:
503: htp.htmlOpen;
504: htp.headOpen;
505: htp.title('Access Denied');
506: htp.headClose;
507: htp.bodyOpen;
508: htp.p('Access Denied');
509: htp.hr;
510:
511: -- If the procedure contains an HTML tag, don't display it.
504: htp.headOpen;
505: htp.title('Access Denied');
506: htp.headClose;
507: htp.bodyOpen;
508: htp.p('Access Denied');
509: htp.hr;
510:
511: -- If the procedure contains an HTML tag, don't display it.
512: --
505: htp.title('Access Denied');
506: htp.headClose;
507: htp.bodyOpen;
508: htp.p('Access Denied');
509: htp.hr;
510:
511: -- If the procedure contains an HTML tag, don't display it.
512: --
513: if (instr(proc,'<') > 0) then
510:
511: -- If the procedure contains an HTML tag, don't display it.
512: --
513: if (instr(proc,'<') > 0) then
514: htp.p('Not authorized to access procedure.');
515: else
516: htp.p('Not authorized to access '||proc||'.');
517: end if;
518:
512: --
513: if (instr(proc,'<') > 0) then
514: htp.p('Not authorized to access procedure.');
515: else
516: htp.p('Not authorized to access '||proc||'.');
517: end if;
518:
519: htp.bodyClose;
520: htp.htmlClose;
515: else
516: htp.p('Not authorized to access '||proc||'.');
517: end if;
518:
519: htp.bodyClose;
520: htp.htmlClose;
521: end if;
522:
523: exception
516: htp.p('Not authorized to access '||proc||'.');
517: end if;
518:
519: htp.bodyClose;
520: htp.htmlClose;
521: end if;
522:
523: exception
524: when others then
774: * in the database.
775: */
776: PROCEDURE test is
777: begin
778: htp.print('Success');
779: end;
780: /*--------------------------------------------------------------------------*/
781: /*
782: * get_iso_charset
860: doc blob;
861: ct varchar2(100);
862: begin
863: if (fnd_gfm.authenticate(access, file_id) = FALSE) then
864: htp.p(Fnd_Message.Get_String('PAY','HR_51401_WEB_NOT_AUTHORIZED'));
865: else
866: fnd_gfm.download_blob(file_id);
867:
868: if (purge = 'yes') then
972: end if;
973:
974: owa_util.mime_header(ctype, FALSE, cs);
975: if (pn = 'export' and nce is not null) then
976: htp.p( 'Content-length: ' || dbms_lob.getlength(lob_loc));
977: else
978: htp.p( 'Content-length: ' || dbms_lob.getlength(doc));
979: end if;
980: /* Commenting out the following do resolve the issue with Export
974: owa_util.mime_header(ctype, FALSE, cs);
975: if (pn = 'export' and nce is not null) then
976: htp.p( 'Content-length: ' || dbms_lob.getlength(lob_loc));
977: else
978: htp.p( 'Content-length: ' || dbms_lob.getlength(doc));
979: end if;
980: /* Commenting out the following do resolve the issue with Export
981: failing on Internet Explorer.
982: htp.p( 'Cache-Control: no-cache' ); */
978: htp.p( 'Content-length: ' || dbms_lob.getlength(doc));
979: end if;
980: /* Commenting out the following do resolve the issue with Export
981: failing on Internet Explorer.
982: htp.p( 'Cache-Control: no-cache' ); */
983: owa_util.http_header_close;
984: if (pn = 'export' and nce is not null) then
985: wpg_docload.download_file(lob_loc);
986: dbms_lob.freetemporary(lob_loc);
990: end if;
991:
992: exception
993: when no_data_found then
994: htp.htmlOpen;
995: htp.headOpen; htp.title('404 Not Found'); htp.headClose;
996: htp.bodyOpen; htp.hr; htp.header(nsize=>1, cheader=>'HTTP Error 404');
997: htp.hr;
998: htp.p(Fnd_Message.Get_String('GMD','LM_BAD_FILENAME'));
991:
992: exception
993: when no_data_found then
994: htp.htmlOpen;
995: htp.headOpen; htp.title('404 Not Found'); htp.headClose;
996: htp.bodyOpen; htp.hr; htp.header(nsize=>1, cheader=>'HTTP Error 404');
997: htp.hr;
998: htp.p(Fnd_Message.Get_String('GMD','LM_BAD_FILENAME'));
999: htp.bodyClose; htp.htmlClose;
992: exception
993: when no_data_found then
994: htp.htmlOpen;
995: htp.headOpen; htp.title('404 Not Found'); htp.headClose;
996: htp.bodyOpen; htp.hr; htp.header(nsize=>1, cheader=>'HTTP Error 404');
997: htp.hr;
998: htp.p(Fnd_Message.Get_String('GMD','LM_BAD_FILENAME'));
999: htp.bodyClose; htp.htmlClose;
1000: when others then
993: when no_data_found then
994: htp.htmlOpen;
995: htp.headOpen; htp.title('404 Not Found'); htp.headClose;
996: htp.bodyOpen; htp.hr; htp.header(nsize=>1, cheader=>'HTTP Error 404');
997: htp.hr;
998: htp.p(Fnd_Message.Get_String('GMD','LM_BAD_FILENAME'));
999: htp.bodyClose; htp.htmlClose;
1000: when others then
1001: fnd_gfm.err_msg('download_blob');
994: htp.htmlOpen;
995: htp.headOpen; htp.title('404 Not Found'); htp.headClose;
996: htp.bodyOpen; htp.hr; htp.header(nsize=>1, cheader=>'HTTP Error 404');
997: htp.hr;
998: htp.p(Fnd_Message.Get_String('GMD','LM_BAD_FILENAME'));
999: htp.bodyClose; htp.htmlClose;
1000: when others then
1001: fnd_gfm.err_msg('download_blob');
1002: raise;
995: htp.headOpen; htp.title('404 Not Found'); htp.headClose;
996: htp.bodyOpen; htp.hr; htp.header(nsize=>1, cheader=>'HTTP Error 404');
997: htp.hr;
998: htp.p(Fnd_Message.Get_String('GMD','LM_BAD_FILENAME'));
999: htp.bodyClose; htp.htmlClose;
1000: when others then
1001: fnd_gfm.err_msg('download_blob');
1002: raise;
1003: end download_blob;
1121: access := substr(p_path,instr(p_path,'/',1)+1,instr(p_path,'/',2)-2);
1122: file_id := substr(p_path,instr(p_path,'/',2)+1,(instr(p_path,'/',-1)-instr(p_path,'/',2)-1));
1123:
1124: if (fnd_gfm.authenticate(access, file_id) = FALSE) then
1125: htp.p(Fnd_Message.Get_String('PAY','HR_51401_WEB_NOT_AUTHORIZED'));
1126: else
1127: fnd_gfm.download_blob(file_id);
1128:
1129: end if;