DBA Data[Home] [Help]

APPS.IGF_GR_MRR_LOAD_DATA dependencies on FND_FILE

Line 212: fnd_file.put_line(fnd_file.log,fnd_message.get);

208: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
209: fnd_message.set_token('BATCH',l_batch_id);
210: fnd_message.set_token('AWD_YR',g_c_alt_code);
211: fnd_message.set_token('VRSN',g_ver_num);
212: fnd_file.put_line(fnd_file.log,fnd_message.get);
213: RAISE invalid_version;
214: END IF;
215:
216: IF l_number_rec > 0 THEN

Line 262: fnd_file.put_line(fnd_file.log,fnd_message.get());

258: -- Make an entry in the log file indicating Success
259: --
260: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_PASS');
261: fnd_message.set_token('STUD_ORIG_SSN',lv_mrr_row.stud_orig_ssn);
262: fnd_file.put_line(fnd_file.log,fnd_message.get());
263: lp_count := lp_count + 1;
264:
265: EXCEPTION
266:

Line 270: fnd_file.put_line(fnd_file.log,fnd_message.get());

266:
267: WHEN igf_gr_gen.skip_this_record THEN
268: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_FAIL');
269: fnd_message.set_token('STUD_ORIG_SSN',SUBSTR( mrr_rec_data.record_data, 28, 9));
270: fnd_file.put_line(fnd_file.log,fnd_message.get());
271: lf_count := lf_count + 1;
272: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
273: fnd_file.put_line(fnd_file.log,fnd_message.get);
274:

Line 273: fnd_file.put_line(fnd_file.log,fnd_message.get);

269: fnd_message.set_token('STUD_ORIG_SSN',SUBSTR( mrr_rec_data.record_data, 28, 9));
270: fnd_file.put_line(fnd_file.log,fnd_message.get());
271: lf_count := lf_count + 1;
272: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
273: fnd_file.put_line(fnd_file.log,fnd_message.get);
274:
275: WHEN igf_gr_gen.no_file_version THEN
276: RAISE;
277:

Line 297: fnd_file.put_line(fnd_file.log,fnd_message.get);

293: END IF;
294:
295: IF l_number_rec <> (lp_count + lf_count) THEN
296: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
297: fnd_file.put_line(fnd_file.log,fnd_message.get);
298: RAISE igf_gr_gen.file_not_loaded;
299: END IF;
300:
301: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

Line 303: fnd_file.put_line(fnd_file.log,fnd_message.get);

299: END IF;
300:
301: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
302: fnd_message.set_token('CNT',l_number_rec);
303: fnd_file.put_line(fnd_file.log,fnd_message.get);
304:
305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
306: fnd_message.set_token('CNT',lp_count);
307: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 307: fnd_file.put_line(fnd_file.log,fnd_message.get);

303: fnd_file.put_line(fnd_file.log,fnd_message.get);
304:
305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
306: fnd_message.set_token('CNT',lp_count);
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308:
309: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
310: fnd_message.set_token('CNT',lf_count);
311: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 311: fnd_file.put_line(fnd_file.log,fnd_message.get);

307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308:
309: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
310: fnd_message.set_token('CNT',lf_count);
311: fnd_file.put_line(fnd_file.log,fnd_message.get);
312:
313: EXCEPTION
314: WHEN invalid_version THEN
315: RAISE;

Line 391: fnd_file.put_line(fnd_file.log,errbuf);

387: WHEN param_error THEN
388: ROLLBACK;
389: retcode := 2;
390: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
391: fnd_file.put_line(fnd_file.log,errbuf);
392:
393: WHEN igf_gr_gen.corrupt_data_file THEN
394: ROLLBACK;
395: retcode := 2;

Line 397: fnd_file.put_line(fnd_file.log,errbuf);

393: WHEN igf_gr_gen.corrupt_data_file THEN
394: ROLLBACK;
395: retcode := 2;
396: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
397: fnd_file.put_line(fnd_file.log,errbuf);
398:
399: WHEN igf_gr_gen.file_not_loaded THEN
400: ROLLBACK;
401: retcode := 2;

Line 403: fnd_file.put_line(fnd_file.log,errbuf);

399: WHEN igf_gr_gen.file_not_loaded THEN
400: ROLLBACK;
401: retcode := 2;
402: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
403: fnd_file.put_line(fnd_file.log,errbuf);
404:
405: WHEN igf_gr_gen.no_file_version THEN
406: ROLLBACK;
407: retcode := 2;