DBA Data[Home] [Help]

APPS.CSY_KPI_PKG dependencies on FND_FILE

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

234: else
235: insert into biv_debug(message, report_id,seq_no) values (
236: l_msg, 'XX', g_seq);
237: end if;
238: fnd_file.put_line(fnd_file.log,'Message No:'||to_char(g_seq) ||
239: ' =====================================================');
240: fnd_file.put_line(fnd_file.log,l_msg);
241: */
242: g_seq := g_seq + 1;

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

236: l_msg, 'XX', g_seq);
237: end if;
238: fnd_file.put_line(fnd_file.log,'Message No:'||to_char(g_seq) ||
239: ' =====================================================');
240: fnd_file.put_line(fnd_file.log,l_msg);
241: */
242: g_seq := g_seq + 1;
243: end;
244: procedure get_sr_backlog (p_from_date in date,

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

830: debug('After Sr Resolution count Reversal:'||to_char(sysdate,'hh24:mi:ss'));
831: --
832: exception
833: when others then
834: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
835: raise fnd_api.g_exc_unexpected_error;
836: end get_resolution_timings;
837: procedure upload_first_resolutions(p_sql varchar2,
838: p_owner_type varchar2,

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

941: end loop;
942: close c_first_resolutions;
943: exception
944: when others then
945: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
946: raise fnd_api.g_exc_unexpected_error;
947: end;
948: procedure get_sr_resolutions (p_from_date in date,
949: p_to_date in date) is

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

1173: ---
1174: ---
1175: exception
1176: when others then
1177: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1178: raise fnd_api.g_exc_unexpected_error;
1179: end;
1180: procedure upload_assignments(p_sql varchar2,
1181: p_load_type varchar2,

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

1492: /*
1493: */
1494: exception
1495: when others then
1496: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1497: raise fnd_api.g_exc_unexpected_error;
1498: end;
1499: procedure get_sr_group_assignments(p_from_date in date,
1500: p_to_date in date) is

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

1569: b.sr_out,
1570: -1, 'G');
1571: exception
1572: when others then
1573: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1574: ***************************************************************************/
1575: end;
1576: procedure get_response_timings(p_from_date in date,
1577: p_to_date in date) as

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

2003: debug('After Sr Response Count Reversal:'||to_char(sysdate,'hh24:mi:ss'));
2004: --
2005: exception
2006: when others then
2007: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
2008: raise fnd_api.g_exc_unexpected_error;
2009: end;
2010: procedure update_group_data (p_from_date date,
2011: p_to_date date) is

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

2137: 'YYYYMMDD HH24:MI:SS')
2138: into l_from_date
2139: from dual;
2140: if (l_from_date is null) then
2141: fnd_file.put_line(fnd_file.log,'Please Run: KPI summary: Initial Data Laod Set');
2142: p_errbuf := '"KPI Summary: Initial Data load Set" has never been run.';
2143: p_errbuf := p_errbuf || ' So Please Run:"KPI summary: Initial Data Load Set" before running Incremental Data Load';
2144: p_retcode := 2;
2145: return;