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_SL_DL_VALIDATION dependencies on IGF_SL_DL_RECORD

Line 520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| orec.loan_number);

516:
517: -- PUT THE DEBUGGING LOG MESSAGES
518:
519: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| orec.loan_number);
521: END IF;
522:
523: -- Get the Academic Year Start and End Dates for this Award Year
524: -- masehgal # 2593215 removed begin/end dates fetching functions

Line 526: igf_sl_dl_record.get_acad_cal_dtls ( orec.loan_number,

522:
523: -- Get the Academic Year Start and End Dates for this Award Year
524: -- masehgal # 2593215 removed begin/end dates fetching functions
525: -- used procedure get_acad_cal_dtls instead
526: igf_sl_dl_record.get_acad_cal_dtls ( orec.loan_number,
527: lv_acad_cal_type,
528: lv_acad_seq_num,
529: lv_acad_begin_date,
530: lv_acad_end_date,

Line 539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);

535: -- We will log that as an error code in processing below where we chk if acad_dates are null and
536: -- report appropriate error code.
537:
538: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
540: END IF;
541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
543: END IF;

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);

538: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
540: END IF;
541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
543: END IF;
544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
546: END IF;

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);

541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
543: END IF;
544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
546: END IF;
547: lv_complete := TRUE;
548:
549: -- Delete records from Edit Report table, with type="V" (VALIDATION) for this Loan#

Line 869: --This is because this procedure in turn calls igf_sl_dl_record package academic year functions

865: RAISE;
866: WHEN OTHERS THEN
867:
868: --Removed the fnd_message.setname with Package.Procedure name.
869: --This is because this procedure in turn calls igf_sl_dl_record package academic year functions
870: --which return valid exceptions.only if we just propogate this exception
871: --we will be able to trap both in form and in dl orig process.
872: --hence removed code.
873: --Bug :-2415041 Loan Orig with incorrect error messages.

Line 976: --The procedure igf_sl_dl_record.get_acad_cal_dtls will be called only if the acad_begin_date and acad_end_date are NULL

972: --
973: -- Get academic calendar details
974: --
975: --akomurav FA162 This code will pick the values from the lor_all table
976: --The procedure igf_sl_dl_record.get_acad_cal_dtls will be called only if the acad_begin_date and acad_end_date are NULL
977: lv_acad_begin_date := p_loan_rec.acad_begin_date;
978: lv_acad_end_date := p_loan_rec.acad_end_date;
979:
980: IF lv_acad_begin_date IS NULL OR lv_acad_end_date IS NULL THEN

Line 981: igf_sl_dl_record.get_acad_cal_dtls ( p_loan_rec.loan_number,

977: lv_acad_begin_date := p_loan_rec.acad_begin_date;
978: lv_acad_end_date := p_loan_rec.acad_end_date;
979:
980: IF lv_acad_begin_date IS NULL OR lv_acad_end_date IS NULL THEN
981: igf_sl_dl_record.get_acad_cal_dtls ( p_loan_rec.loan_number,
982: lv_acad_cal_type,
983: lv_acad_seq_num,
984: lv_acad_begin_date,
985: lv_acad_end_date,

Line 990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);

986: lv_message );
987: END IF;
988:
989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
991: END IF;
992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
994: END IF;

Line 993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);

989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
991: END IF;
992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
994: END IF;
995: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
996: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
997: END IF;

Line 996: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);

992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
994: END IF;
995: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
996: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
997: END IF;
998:
999: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_loan_rec.base_id),student_dtl_cur);
1000: FETCH student_dtl_cur INTO student_dtl_rec;