APPS.PAY_GB_NICAT_UPD dependencies on FND_FILE

Line 258: fnd_file.put_line(FND_FILE.OUTPUT,report_output(i));

254: --Display the report.
255: if counter >2 THEN
256: FOR i IN 1..report_output.count
257: LOOP
258: fnd_file.put_line(FND_FILE.OUTPUT,report_output(i));
259: END LOOP;
260: else
261: fnd_file.put_line(FND_FILE.OUTPUT,' ');
262: fnd_file.put_line(FND_FILE.OUTPUT,rpad('-',68,'-')||'No records updated'||rpad('-',69,'-'));

Line 261: fnd_file.put_line(FND_FILE.OUTPUT,' ');

257: LOOP
258: fnd_file.put_line(FND_FILE.OUTPUT,report_output(i));
259: END LOOP;
260: else
261: fnd_file.put_line(FND_FILE.OUTPUT,' ');
262: fnd_file.put_line(FND_FILE.OUTPUT,rpad('-',68,'-')||'No records updated'||rpad('-',69,'-'));
263: fnd_file.put_line(FND_FILE.OUTPUT,' ');
264: end if;
265:

Line 262: fnd_file.put_line(FND_FILE.OUTPUT,rpad('-',68,'-')||'No records updated'||rpad('-',69,'-'));

258: fnd_file.put_line(FND_FILE.OUTPUT,report_output(i));
259: END LOOP;
260: else
261: fnd_file.put_line(FND_FILE.OUTPUT,' ');
262: fnd_file.put_line(FND_FILE.OUTPUT,rpad('-',68,'-')||'No records updated'||rpad('-',69,'-'));
263: fnd_file.put_line(FND_FILE.OUTPUT,' ');
264: end if;
265:
266: EXCEPTION

Line 263: fnd_file.put_line(FND_FILE.OUTPUT,' ');

259: END LOOP;
260: else
261: fnd_file.put_line(FND_FILE.OUTPUT,' ');
262: fnd_file.put_line(FND_FILE.OUTPUT,rpad('-',68,'-')||'No records updated'||rpad('-',69,'-'));
263: fnd_file.put_line(FND_FILE.OUTPUT,' ');
264: end if;
265:
266: EXCEPTION
267: WHEN OTHERS THEN

Line 269: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));

265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: ROLLBACK;
269: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
270: fnd_file.put_line(FND_FILE.LOG,'Error Record :');
271: fnd_file.put_line(FND_FILE.LOG,report_output(report_output.LAST));
272: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
273: fnd_file.put_line(FND_FILE.LOG,SQLCODE||' - '||SQLERRM);

Line 270: fnd_file.put_line(FND_FILE.LOG,'Error Record :');

266: EXCEPTION
267: WHEN OTHERS THEN
268: ROLLBACK;
269: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
270: fnd_file.put_line(FND_FILE.LOG,'Error Record :');
271: fnd_file.put_line(FND_FILE.LOG,report_output(report_output.LAST));
272: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
273: fnd_file.put_line(FND_FILE.LOG,SQLCODE||' - '||SQLERRM);
274: RAISE_APPLICATION_ERROR(-20001, SQLCODE||' - '||SQLERRM);

Line 271: fnd_file.put_line(FND_FILE.LOG,report_output(report_output.LAST));

267: WHEN OTHERS THEN
268: ROLLBACK;
269: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
270: fnd_file.put_line(FND_FILE.LOG,'Error Record :');
271: fnd_file.put_line(FND_FILE.LOG,report_output(report_output.LAST));
272: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
273: fnd_file.put_line(FND_FILE.LOG,SQLCODE||' - '||SQLERRM);
274: RAISE_APPLICATION_ERROR(-20001, SQLCODE||' - '||SQLERRM);
275: END update_ni_category_pension;

Line 272: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));

268: ROLLBACK;
269: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
270: fnd_file.put_line(FND_FILE.LOG,'Error Record :');
271: fnd_file.put_line(FND_FILE.LOG,report_output(report_output.LAST));
272: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
273: fnd_file.put_line(FND_FILE.LOG,SQLCODE||' - '||SQLERRM);
274: RAISE_APPLICATION_ERROR(-20001, SQLCODE||' - '||SQLERRM);
275: END update_ni_category_pension;
276:

Line 273: fnd_file.put_line(FND_FILE.LOG,SQLCODE||' - '||SQLERRM);

269: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
270: fnd_file.put_line(FND_FILE.LOG,'Error Record :');
271: fnd_file.put_line(FND_FILE.LOG,report_output(report_output.LAST));
272: fnd_file.put_line(FND_FILE.LOG,rpad('-',155,'-'));
273: fnd_file.put_line(FND_FILE.LOG,SQLCODE||' - '||SQLERRM);
274: RAISE_APPLICATION_ERROR(-20001, SQLCODE||' - '||SQLERRM);
275: END update_ni_category_pension;
276:
277: END pay_gb_nicat_upd;