DBA Data[Home] [Help]

APPS.IGF_SL_DL_VALIDATION dependencies on FND_FILE

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

458: p_dl_version := igf_sl_gen.get_dl_version(p_ci_cal_type, p_ci_sequence_number);
459: EXCEPTION
460: WHEN NO_DATA_FOUND THEN
461: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
462: fnd_file.put_line(fnd_file.log,fnd_message.get);
463: RAISE NO_DATA_FOUND;
464: END;
465:
466:

Line 824: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

820: AND orig_chg_code = 'V';
821: BEGIN
822:
823:
824: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
825: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
826: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||orec.loan_number;
827: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;

Line 825: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

821: BEGIN
822:
823:
824: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
825: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
826: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||orec.loan_number;
827: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
829: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);

Line 827: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);

823:
824: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
825: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
826: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||orec.loan_number;
827: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
829: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
830: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
831: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;

Line 829: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);

825: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
826: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||orec.loan_number;
827: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
829: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
830: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
831: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
832: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
833: FOR rej_rec IN c_reject LOOP

Line 832: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);

828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
829: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
830: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
831: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
832: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
833: FOR rej_rec IN c_reject LOOP
834: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||rej_rec.reject_desc);
835: END LOOP;
836:

Line 834: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||rej_rec.reject_desc);

830: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
831: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
832: FND_FILE.PUT_LINE(FND_FILE.LOG, lv_log_mesg);
833: FOR rej_rec IN c_reject LOOP
834: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||rej_rec.reject_desc);
835: END LOOP;
836:
837: END;
838: END IF;

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

950: END IF;
951: EXCEPTION
952: WHEN NO_DATA_FOUND THEN
953: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
954: fnd_file.put_line(fnd_file.log,fnd_message.get);
955: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
956: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Setup gone ' );
957: END IF;
958: RAISE NO_DATA_FOUND;

Line 1824: fnd_file.put_line(fnd_file.log, '');

1820: SELECT rpad(field_desc,50)||sl_error_desc reject_desc FROM igf_sl_edit_report_v
1821: WHERE loan_number = p_loan_rec.loan_number
1822: AND orig_chg_code = 'V';
1823: BEGIN
1824: fnd_file.put_line(fnd_file.log, '');
1825: fnd_file.put_line(fnd_file.log, '');
1826: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||p_loan_rec.loan_number;
1827: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;

Line 1825: fnd_file.put_line(fnd_file.log, '');

1821: WHERE loan_number = p_loan_rec.loan_number
1822: AND orig_chg_code = 'V';
1823: BEGIN
1824: fnd_file.put_line(fnd_file.log, '');
1825: fnd_file.put_line(fnd_file.log, '');
1826: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||p_loan_rec.loan_number;
1827: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
1829: fnd_file.put_line(fnd_file.log, lv_log_mesg);

Line 1827: fnd_file.put_line(fnd_file.log, lv_log_mesg);

1823: BEGIN
1824: fnd_file.put_line(fnd_file.log, '');
1825: fnd_file.put_line(fnd_file.log, '');
1826: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||p_loan_rec.loan_number;
1827: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
1829: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1830: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1831: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;

Line 1829: fnd_file.put_line(fnd_file.log, lv_log_mesg);

1825: fnd_file.put_line(fnd_file.log, '');
1826: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||p_loan_rec.loan_number;
1827: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
1829: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1830: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1831: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
1832: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1833: FOR rej_rec IN c_reject LOOP

Line 1832: fnd_file.put_line(fnd_file.log, lv_log_mesg);

1828: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
1829: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1830: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1831: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
1832: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1833: FOR rej_rec IN c_reject LOOP
1834: fnd_file.put_line(fnd_file.log,' '||rej_rec.reject_desc);
1835: END LOOP;
1836: END;

Line 1834: fnd_file.put_line(fnd_file.log,' '||rej_rec.reject_desc);

1830: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1831: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
1832: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1833: FOR rej_rec IN c_reject LOOP
1834: fnd_file.put_line(fnd_file.log,' '||rej_rec.reject_desc);
1835: END LOOP;
1836: END;
1837: END IF;
1838: