DBA Data[Home] [Help]

APPS.IGF_SL_CL_VALIDATION dependencies on FND_FILE

Line 164: fnd_file.put_line(fnd_file.log,SQLERRM);

160: EXCEPTION
161: WHEN OTHERS THEN
162: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
163: fnd_message.set_token('NAME','IGF_SL_CL_VALIDATION.CHECK_FOR_REQD');
164: fnd_file.put_line(fnd_file.log,SQLERRM);
165: igs_ge_msg_stack.add;
166: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN
167: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_validation.check_for_reqd.exception', 'Unhandled excepion in check_for_reqd');
168: END IF;

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

725:
726: EXCEPTION
727: WHEN NO_DATA_FOUND THEN
728: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
729: fnd_file.put_line(fnd_file.log,fnd_message.get);
730: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
731: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.set_complete_status.debug', 'No CL Setup found');
732: END IF;
733: RAISE NO_DATA_FOUND;

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

1532: SELECT RPAD(field_desc,70)||sl_error_desc reject_desc FROM igf_sl_edit_report_v
1533: WHERE loan_number = lor_rec.loan_number
1534: AND orig_chg_code = 'V';
1535: BEGIN
1536: fnd_file.put_line(fnd_file.log, '');
1537: fnd_file.put_line(fnd_file.log, '');
1538:
1539: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER')||' : '||igf_gr_gen.get_per_num(lor_rec.base_id);
1540: fnd_file.put_line(fnd_file.log, lv_log_mesg);

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

1533: WHERE loan_number = lor_rec.loan_number
1534: AND orig_chg_code = 'V';
1535: BEGIN
1536: fnd_file.put_line(fnd_file.log, '');
1537: fnd_file.put_line(fnd_file.log, '');
1538:
1539: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER')||' : '||igf_gr_gen.get_per_num(lor_rec.base_id);
1540: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1541:

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

1536: fnd_file.put_line(fnd_file.log, '');
1537: fnd_file.put_line(fnd_file.log, '');
1538:
1539: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER')||' : '||igf_gr_gen.get_per_num(lor_rec.base_id);
1540: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1541:
1542: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||lor_rec.loan_number;
1543: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1544:

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

1539: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER')||' : '||igf_gr_gen.get_per_num(lor_rec.base_id);
1540: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1541:
1542: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||lor_rec.loan_number;
1543: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1544:
1545: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
1546: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1547:

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

1542: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER')||' : '||lor_rec.loan_number;
1543: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1544:
1545: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||student_dtl_rec.p_ssn;
1546: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1547:
1548: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1549: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
1550: fnd_file.put_line(fnd_file.log, lv_log_mesg);

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

1546: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1547:
1548: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1549: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
1550: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1551:
1552: FOR rej_rec IN c_reject LOOP
1553: fnd_file.put_line(fnd_file.log,' '||rej_rec.reject_desc);
1554: END LOOP;

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

1549: ||student_dtl_rec.p_first_name||' '||student_dtl_rec.p_last_name;
1550: fnd_file.put_line(fnd_file.log, lv_log_mesg);
1551:
1552: FOR rej_rec IN c_reject LOOP
1553: fnd_file.put_line(fnd_file.log,' '||rej_rec.reject_desc);
1554: END LOOP;
1555: --FA 161 - Bug 5006583 - Give message to use the update mode
1556: IF g_update_mode_required THEN
1557: fnd_file.new_line(fnd_file.log,2);

Line 1557: fnd_file.new_line(fnd_file.log,2);

1553: fnd_file.put_line(fnd_file.log,' '||rej_rec.reject_desc);
1554: END LOOP;
1555: --FA 161 - Bug 5006583 - Give message to use the update mode
1556: IF g_update_mode_required THEN
1557: fnd_file.new_line(fnd_file.log,2);
1558: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_UPD_CORR');
1559: fnd_file.put_line(fnd_file.log,fnd_message.get);
1560: END IF;
1561: END;

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

1555: --FA 161 - Bug 5006583 - Give message to use the update mode
1556: IF g_update_mode_required THEN
1557: fnd_file.new_line(fnd_file.log,2);
1558: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_UPD_CORR');
1559: fnd_file.put_line(fnd_file.log,fnd_message.get);
1560: END IF;
1561: END;
1562: END IF;
1563: