DBA Data[Home] [Help]

APPS.CSY_KPI_PKG dependencies on FND_FILE

Line 276: fnd_file.put_line(fnd_file.log,'Message No:'||to_char(g_seq) ||

272: else
273: insert into biv_debug(message, report_id,seq_no) values (
274: l_msg, 'XX', g_seq);
275: end if;
276: fnd_file.put_line(fnd_file.log,'Message No:'||to_char(g_seq) ||
277: ' =====================================================');
278: fnd_file.put_line(fnd_file.log,l_msg);
279: */
280: g_seq := g_seq + 1;

Line 278: fnd_file.put_line(fnd_file.log,l_msg);

274: l_msg, 'XX', g_seq);
275: end if;
276: fnd_file.put_line(fnd_file.log,'Message No:'||to_char(g_seq) ||
277: ' =====================================================');
278: fnd_file.put_line(fnd_file.log,l_msg);
279: */
280: g_seq := g_seq + 1;
281: end;
282: procedure get_sr_backlog (p_from_date in date,

Line 872: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);

868: debug('After Sr Resolution count Reversal:'||to_char(sysdate,'hh24:mi:ss'));
869: --
870: exception
871: when others then
872: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
873: raise fnd_api.g_exc_unexpected_error;
874: end get_resolution_timings;
875: procedure upload_first_resolutions(p_sql varchar2,
876: p_owner_type varchar2,

Line 983: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);

979: end loop;
980: close c_first_resolutions;
981: exception
982: when others then
983: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
984: raise fnd_api.g_exc_unexpected_error;
985: end;
986: procedure get_sr_resolutions (p_from_date in date,
987: p_to_date in date) is

Line 1215: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);

1211: ---
1212: ---
1213: exception
1214: when others then
1215: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1216: raise fnd_api.g_exc_unexpected_error;
1217: end;
1218: procedure upload_assignments(p_sql varchar2,
1219: p_load_type varchar2,

Line 1534: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);

1530: /*
1531: */
1532: exception
1533: when others then
1534: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1535: raise fnd_api.g_exc_unexpected_error;
1536: end;
1537: procedure get_sr_group_assignments(p_from_date in date,
1538: p_to_date in date) is

Line 1611: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);

1607: b.sr_out,
1608: -1, 'G');
1609: exception
1610: when others then
1611: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1612: ***************************************************************************/
1613: end;
1614: procedure get_response_timings(p_from_date in date,
1615: p_to_date in date) as

Line 2049: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);

2045: debug('After Sr Response Count Reversal:'||to_char(sysdate,'hh24:mi:ss'));
2046: --
2047: exception
2048: when others then
2049: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
2050: raise fnd_api.g_exc_unexpected_error;
2051: end;
2052: procedure update_group_data (p_from_date date,
2053: p_to_date date) is

Line 2183: fnd_file.put_line(fnd_file.log,'Please Run: KPI summary: Initial Data Laod Set');

2179: 'YYYYMMDD HH24:MI:SS')
2180: into l_from_date
2181: from dual;
2182: if (l_from_date is null) then
2183: fnd_file.put_line(fnd_file.log,'Please Run: KPI summary: Initial Data Laod Set');
2184: p_errbuf := '"KPI Summary: Initial Data load Set" has never been run.';
2185: p_errbuf := p_errbuf || ' So Please Run:"KPI summary: Initial Data Load Set" before running Incremental Data Load';
2186: p_retcode := 2;
2187: return;