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;
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;
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);
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:
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:
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:
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);
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;
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);
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;
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: