APPS.QPR_DEAL_ETL dependencies on DBMS_UTILITY

Line 189: log_debug(dbms_utility.format_error_backtrace);

185: t_er_val.delete;
186: t_tot_er.delete;
187: exception
188: when others then
189: log_debug(dbms_utility.format_error_backtrace);
190: raise;
191: end insert_price_adj_recs;
192:
193: function insert_prices(

Line 354: log_debug(dbms_utility.format_error_backtrace);

350: return (l_base_price);
351: exception
352: when others then
353: log_debug('Failed to insert prices');
354: log_debug(dbms_utility.format_error_backtrace);
355: raise;
356: end insert_prices;
357:
358: procedure insert_policy_details(

Line 485: log_debug(dbms_utility.format_error_backtrace);

481: end if;
482: exception
483: when others then
484: log_debug('Failed in policy fetching');
485: log_debug(dbms_utility.format_error_backtrace);
486: raise;
487: end insert_policy_details;
488:
489: function score_calc(p_list_price in number,

Line 737: log_debug(dbms_utility.format_error_backtrace);

733: end loop;
734: exception
735: when others then
736: log_debug('failed in inserting model line');
737: log_debug(dbms_utility.format_error_backtrace);
738: raise;
739: end;
740:
741: procedure insert_req_res_header_lines(

Line 1321: log_debug(dbms_utility.format_error_backtrace);

1317: when others then
1318: errbuf := sqlerrm;
1319: retcode := 2;
1320: log_debug(sqlerrm);
1321: log_debug(dbms_utility.format_error_backtrace);
1322: end insert_req_res_header_lines;
1323:
1324:
1325: procedure insert_price_int_adj_recs(p_source_ref_hdr_id in number,

Line 1496: log_debug(dbms_utility.format_error_backtrace);

1492: end if;
1493:
1494: exception
1495: when others then
1496: log_debug(dbms_utility.format_error_backtrace);
1497: raise;
1498: end insert_price_int_adj_recs;
1499:
1500: function determine_line_price(p_src_ref_hdr_id in number,

Line 1772: log_debug(dbms_utility.format_error_backtrace);

1768: exception
1769: when others then
1770: retcode := 2;
1771: errbuf := sqlerrm;
1772: log_debug(dbms_utility.format_error_backtrace);
1773: end do_deal_preprocess;
1774:
1775: -- called from concurrent program --
1776: procedure process_deal(

Line 1885: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1881: when others then
1882: retcode := 2;
1883: errbuf := FND_MESSAGE.GET;
1884: fnd_file.put_line( fnd_file.log, 'Unexpected error '||substr(sqlerrm,1200));
1885: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1886: end process_deal;
1887:
1888: procedure process_deal_api(
1889: errbuf OUT NOCOPY VARCHAR2,

Line 1986: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1982: when others then
1983: retcode := 2;
1984: errbuf := FND_MESSAGE.GET;
1985: fnd_file.put_line( fnd_file.log, 'Unexpected error '||substr(sqlerrm,1200));
1986: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1987: end process_deal_api;
1988:
1989: procedure create_deal_version(errbuf out nocopy varchar2,
1990: retcode out nocopy varchar2,