eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_GR_ESS_ESD_DATA dependencies on FND_FILE

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

321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
322: fnd_message.set_token('BATCH',l_batch_id);
323: fnd_message.set_token('AWD_YR',g_c_alt_code);
324: fnd_message.set_token('VRSN',g_ver_num);
325: fnd_file.put_line(fnd_file.log,fnd_message.get);
326: RAISE invalid_version;
327: END IF;
328:
329: IF l_number_rec > 0 THEN

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

368:
369:
370: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_PASS');
371: fnd_message.set_token('VALUE',' ');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373:
374: lp_count := lp_count + 1;
375:
376: EXCEPTION

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

376: EXCEPTION
377: WHEN igf_gr_gen.skip_this_record THEN
378: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_FAIL');
379: fnd_message.set_token('VALUE',' ');
380: fnd_file.put_line(fnd_file.log,fnd_message.get);
381:
382: lf_count := lf_count + 1;
383: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
384: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

380: fnd_file.put_line(fnd_file.log,fnd_message.get);
381:
382: lf_count := lf_count + 1;
383: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385:
386: WHEN igf_gr_gen.no_file_version THEN
387: RAISE;
388:

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

397: END IF;
398:
399: IF l_number_rec <> (lp_count + lf_count) THEN
400: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
401: fnd_file.put_line(fnd_file.log,fnd_message.get);
402: RAISE igf_gr_gen.file_not_loaded;
403: END IF;
404:
405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

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

403: END IF;
404:
405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
406: fnd_message.set_token('CNT',l_number_rec);
407: fnd_file.put_line(fnd_file.log,fnd_message.get);
408:
409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
410: fnd_message.set_token('CNT',lp_count);
411: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

407: fnd_file.put_line(fnd_file.log,fnd_message.get);
408:
409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
410: fnd_message.set_token('CNT',lp_count);
411: fnd_file.put_line(fnd_file.log,fnd_message.get);
412:
413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
414: fnd_message.set_token('CNT',lf_count);
415: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

411: fnd_file.put_line(fnd_file.log,fnd_message.get);
412:
413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
414: fnd_message.set_token('CNT',lf_count);
415: fnd_file.put_line(fnd_file.log,fnd_message.get);
416:
417:
418: EXCEPTION
419: WHEN invalid_version THEN

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

470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
471: fnd_message.set_token('BATCH',l_batch_id);
472: fnd_message.set_token('AWD_YR',g_c_alt_code);
473: fnd_message.set_token('VRSN',g_ver_num);
474: fnd_file.put_line(fnd_file.log,fnd_message.get);
475: RAISE invalid_version;
476: END IF;
477:
478: IF l_number_rec > 0 THEN

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

516:
517:
518: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_PASS');
519: fnd_message.set_token('VALUE',' ');
520: fnd_file.put_line(fnd_file.log,fnd_message.get);
521: lp_count := lp_count + 1;
522:
523: EXCEPTION
524: WHEN igf_gr_gen.skip_this_record THEN

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

523: EXCEPTION
524: WHEN igf_gr_gen.skip_this_record THEN
525: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_FAIL');
526: fnd_message.set_token('VALUE',' ' );
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: lf_count := lf_count + 1;
529: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
530: fnd_file.put_line(fnd_file.log,fnd_message.get);
531:

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

526: fnd_message.set_token('VALUE',' ' );
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: lf_count := lf_count + 1;
529: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
530: fnd_file.put_line(fnd_file.log,fnd_message.get);
531:
532: WHEN igf_gr_gen.no_file_version THEN
533: RAISE;
534: END;

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

542: END IF;
543:
544: IF l_number_rec <> (lp_count + lf_count) THEN
545: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
546: fnd_file.put_line(fnd_file.log,fnd_message.get);
547: RAISE igf_gr_gen.file_not_loaded;
548: END IF;
549:
550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

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

548: END IF;
549:
550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
551: fnd_message.set_token('CNT',l_number_rec);
552: fnd_file.put_line(fnd_file.log,fnd_message.get);
553:
554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
555: fnd_message.set_token('CNT',lp_count);
556: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

552: fnd_file.put_line(fnd_file.log,fnd_message.get);
553:
554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
555: fnd_message.set_token('CNT',lp_count);
556: fnd_file.put_line(fnd_file.log,fnd_message.get);
557:
558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
559: fnd_message.set_token('CNT',lf_count);
560: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

556: fnd_file.put_line(fnd_file.log,fnd_message.get);
557:
558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
559: fnd_message.set_token('CNT',lf_count);
560: fnd_file.put_line(fnd_file.log,fnd_message.get);
561:
562:
563:
564: EXCEPTION

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

643: WHEN no_data_found THEN
644: ROLLBACK;
645: retcode := 2;
646: errbuf := fnd_message.get_string('IGF','IGF_GR_NO_PELL_SETUP');
647: fnd_file.put_line(fnd_file.log,errbuf);
648:
649: WHEN param_error THEN
650: ROLLBACK;
651: retcode := 2;

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

649: WHEN param_error THEN
650: ROLLBACK;
651: retcode := 2;
652: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
653: fnd_file.put_line(fnd_file.log,errbuf);
654:
655: WHEN igf_gr_gen.corrupt_data_file THEN
656: ROLLBACK;
657: retcode := 2;

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

655: WHEN igf_gr_gen.corrupt_data_file THEN
656: ROLLBACK;
657: retcode := 2;
658: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
659: fnd_file.put_line(fnd_file.log,errbuf);
660:
661: WHEN igf_gr_gen.file_not_loaded THEN
662: ROLLBACK;
663: retcode := 2;

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

661: WHEN igf_gr_gen.file_not_loaded THEN
662: ROLLBACK;
663: retcode := 2;
664: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
665: fnd_file.put_line(fnd_file.log,errbuf);
666:
667: WHEN igf_gr_gen.no_file_version THEN
668: ROLLBACK;
669: retcode := 2;

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

742: WHEN param_error THEN
743: ROLLBACK;
744: retcode := 2;
745: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
746: fnd_file.put_line(fnd_file.log,errbuf);
747:
748: WHEN igf_gr_gen.corrupt_data_file THEN
749: ROLLBACK;
750: retcode := 2;

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

748: WHEN igf_gr_gen.corrupt_data_file THEN
749: ROLLBACK;
750: retcode := 2;
751: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
752: fnd_file.put_line(fnd_file.log,errbuf);
753:
754: WHEN igf_gr_gen.file_not_loaded THEN
755: ROLLBACK;
756: retcode := 2;

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

754: WHEN igf_gr_gen.file_not_loaded THEN
755: ROLLBACK;
756: retcode := 2;
757: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
758: fnd_file.put_line(fnd_file.log,errbuf);
759:
760: WHEN igf_gr_gen.no_file_version THEN
761: ROLLBACK;
762: retcode := 2;