APPS.QPR_DEAL_ETL dependencies on FND_FILE

Line 19: fnd_file.put_line( fnd_file.log, text);

15: );
16:
17: procedure log_debug(text varchar2) is
18: begin
19: fnd_file.put_line( fnd_file.log, text);
20:
21: if (g_origin = 660 or g_origin = 697) then
22: qpr_deal_pvt.debug_ext_log(text, g_origin);
23: end if;

Line 1880: fnd_file.put_line( fnd_file.log, 'Deal not found in Interface tables');

1876: exception
1877: WHEN NO_DATA_FOUND THEN
1878: retcode := 2;
1879: errbuf := FND_MESSAGE.GET;
1880: fnd_file.put_line( fnd_file.log, 'Deal not found in Interface tables');
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));

Line 1884: fnd_file.put_line( fnd_file.log, 'Unexpected error '||substr(sqlerrm,1200));

1880: fnd_file.put_line( fnd_file.log, 'Deal not found in Interface tables');
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(

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 1985: fnd_file.put_line( fnd_file.log, 'Unexpected error '||substr(sqlerrm,1200));

1981: exception
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,

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,