DBA Data[Home] [Help]

APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_SL_DL_CHG_ORIG

Line 1: PACKAGE BODY igf_sl_dl_chg_orig AS

1: PACKAGE BODY igf_sl_dl_chg_orig AS
2: /* $Header: IGFSL05B.pls 120.1 2006/04/19 08:40:35 bvisvana noship $ */
3:
4: --
5: ---------------------------------------------------------------------------------------

Line 366: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.COMP_LOR_LOC');

362: IF c_chg_code%ISOPEN THEN
363: CLOSE c_chg_code;
364: END IF;
365: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
366: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.COMP_LOR_LOC');
367: fnd_file.put_line(fnd_file.log,SQLERRM);
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END comp_lor_loc;

Line 527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| lc_lor.loan_number);

523:
524: -- PUT THE DEBUGGING LOG MESSAGES
525:
526: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| lc_lor.loan_number);
528: END IF;
529: l_loan_number := lc_lor.loan_number ;
530: -- To get the academic begin and end dates.
531: -- masehgal # 2593215 removed begin/end dates fetching functions

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);

538: lv_message ) ;
539:
540:
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_chg_orig.chg_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
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_chg_orig.chg_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_begin_date);
546: END IF;

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_begin_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_chg_orig.chg_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
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_chg_orig.chg_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_begin_date);
546: END IF;
547: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_end_date);
549: END IF;

Line 548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_end_date);

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_chg_orig.chg_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_begin_date);
546: END IF;
547: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_end_date);
549: END IF;
550: -- ## The If conditions checks if it is Plus records and else the Stafford records
551:
552: lc_chg_flag := 'N';

Line 1201: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.TRANS_REC');

1197: IF cur_chg_rec%ISOPEN THEN
1198: CLOSE cur_chg_rec;
1199: END IF;
1200: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1201: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.TRANS_REC');
1202: fnd_file.put_line(fnd_file.log,SQLERRM);
1203: igs_ge_msg_stack.add;
1204: app_exception.raise_exception;
1205: END Trans_Rec;

Line 1207: END igf_sl_dl_chg_orig;

1203: igs_ge_msg_stack.add;
1204: app_exception.raise_exception;
1205: END Trans_Rec;
1206:
1207: END igf_sl_dl_chg_orig;