DBA Data[Home] [Help]

APPS.WF_MAIL dependencies on UTL_HTTP

Line 6355: url_pieces utl_http.html_pieces;

6351: as
6352: no_program_unit exception;
6353: pragma exception_init(no_program_unit, -6508);
6354:
6355: url_pieces utl_http.html_pieces;
6356: err_name varchar2(30);
6357: err_message varchar2(2000);
6358: err_stack varchar2(4000);
6359: content_array url_content_array;

Line 6363: url_pieces := utl_http.request_pieces(url);

6359: content_array url_content_array;
6360:
6361: begin
6362:
6363: url_pieces := utl_http.request_pieces(url);
6364:
6365: for l_rec_num in 1..url_pieces.count loop
6366: wf_mail.content_array(l_rec_num) := url_pieces(l_rec_num);
6367: piece_count := l_rec_num;

Line 6372: when utl_http.init_failed then

6368: end loop;
6369:
6370: exception
6371:
6372: when utl_http.init_failed then
6373: error_result := 'UTL_HTTP.INIT_FAILED';
6374: error_result := error_result || sqlerrm;
6375: wf_core.context('WF_MAIL', 'GetUrlContent', url);
6376:

Line 6373: error_result := 'UTL_HTTP.INIT_FAILED';

6369:
6370: exception
6371:
6372: when utl_http.init_failed then
6373: error_result := 'UTL_HTTP.INIT_FAILED';
6374: error_result := error_result || sqlerrm;
6375: wf_core.context('WF_MAIL', 'GetUrlContent', url);
6376:
6377: when utl_http.request_failed then

Line 6377: when utl_http.request_failed then

6373: error_result := 'UTL_HTTP.INIT_FAILED';
6374: error_result := error_result || sqlerrm;
6375: wf_core.context('WF_MAIL', 'GetUrlContent', url);
6376:
6377: when utl_http.request_failed then
6378: error_result := 'UTL_HTTP.REQUEST_FAILED';
6379: error_result := error_result || sqlerrm;
6380: wf_core.context('WF_MAIL', 'GetUrlContent', url);
6381:

Line 6378: error_result := 'UTL_HTTP.REQUEST_FAILED';

6374: error_result := error_result || sqlerrm;
6375: wf_core.context('WF_MAIL', 'GetUrlContent', url);
6376:
6377: when utl_http.request_failed then
6378: error_result := 'UTL_HTTP.REQUEST_FAILED';
6379: error_result := error_result || sqlerrm;
6380: wf_core.context('WF_MAIL', 'GetUrlContent', url);
6381:
6382: when no_program_unit then