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

Line 1: PACKAGE BODY igf_sl_dl_record AS

1: PACKAGE BODY igf_sl_dl_record AS
2: /* $Header: IGFSL11B.pls 120.1 2006/04/21 05:01:20 bvisvana noship $ */
3:
4: /*
5: --------------------------------------------------------------------

Line 50: Header_Rec IN OUT NOCOPY igf_sl_dl_record.DLHeaderType)

46: p_school_code IN VARCHAR2,
47: p_dbth_id IN OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,
48: p_batch_id IN OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
49: p_mesg_class IN OUT NOCOPY igf_sl_dl_batch.message_class%TYPE,
50: Header_Rec IN OUT NOCOPY igf_sl_dl_record.DLHeaderType)
51: AS
52:
53: /*************************************************************
54: Created By : venagara

Line 174: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLHeader_cur.exception',SQLERRM);

170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: WHEN OTHERS THEN
173: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
174: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLHeader_cur.exception',SQLERRM);
175: END IF;
176: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
177: fnd_message.set_token('NAME','igf_sl_dl_record.DLHeader_cur');
178: igs_ge_msg_stack.add;

Line 177: fnd_message.set_token('NAME','igf_sl_dl_record.DLHeader_cur');

173: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
174: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLHeader_cur.exception',SQLERRM);
175: END IF;
176: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
177: fnd_message.set_token('NAME','igf_sl_dl_record.DLHeader_cur');
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END DLHeader_cur;
181:

Line 185: Trailer_Rec IN OUT NOCOPY igf_sl_dl_record.DLTrailerType)

181:
182:
183: PROCEDURE DLTrailer_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
184: p_num_of_rec NUMBER,
185: Trailer_Rec IN OUT NOCOPY igf_sl_dl_record.DLTrailerType)
186: AS
187: /*************************************************************
188: Created By : venagara
189: Date Created On : 2000/11/13

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLTrailer_cur.exception',SQLERRM);

216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLTrailer_cur.exception',SQLERRM);
221: END IF;
222: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','igf_sl_dl_record.DLTrailer_cur');
224: igs_ge_msg_stack.add;

Line 223: fnd_message.set_token('NAME','igf_sl_dl_record.DLTrailer_cur');

219: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLTrailer_cur.exception',SQLERRM);
221: END IF;
222: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','igf_sl_dl_record.DLTrailer_cur');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception;
226: END DLTrailer_cur;
227:

Line 370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_base_id passed to get_key_program:'|| l_base_id);

366: -- if a laon exists then a person has to exist .. therefore not checking for notfound condition
367:
368: -- PUT DEBUG MESSAGES HERE
369: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_base_id passed to get_key_program:'|| l_base_id);
371: END IF;
372: -- Call generic API get_key_program to get course code and version number
373: igf_ap_gen_001.get_key_program(l_base_id,l_course_cd,l_ver_num);
374:

Line 376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_course_cd got from get_key_program:'|| l_course_cd);

372: -- Call generic API get_key_program to get course code and version number
373: igf_ap_gen_001.get_key_program(l_base_id,l_course_cd,l_ver_num);
374:
375: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_course_cd got from get_key_program:'|| l_course_cd);
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_ver_num got from get_key_program:'|| l_ver_num);
378: END IF;
379:
380: IF p_acad_begin_date IS NOT NULL AND p_acad_end_date IS NOT NULL THEN

Line 377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_ver_num got from get_key_program:'|| l_ver_num);

373: igf_ap_gen_001.get_key_program(l_base_id,l_course_cd,l_ver_num);
374:
375: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_course_cd got from get_key_program:'|| l_course_cd);
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_ver_num got from get_key_program:'|| l_ver_num);
378: END IF;
379:
380: IF p_acad_begin_date IS NOT NULL AND p_acad_end_date IS NOT NULL THEN
381:

Line 420: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.exception',SQLERRM);

416:
417: EXCEPTION
418: WHEN OTHERS THEN
419: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
420: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.exception',SQLERRM);
421: END IF;
422: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
423: FND_MESSAGE.SET_TOKEN('NAME','IGF_SL_DL_RECORD.GET_ACAD_CAL_DTLS');
424: IGS_GE_MSG_STACK.ADD;

Line 423: FND_MESSAGE.SET_TOKEN('NAME','IGF_SL_DL_RECORD.GET_ACAD_CAL_DTLS');

419: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
420: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.exception',SQLERRM);
421: END IF;
422: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
423: FND_MESSAGE.SET_TOKEN('NAME','IGF_SL_DL_RECORD.GET_ACAD_CAL_DTLS');
424: IGS_GE_MSG_STACK.ADD;
425: APP_EXCEPTION.RAISE_EXCEPTION;
426: END get_acad_cal_dtls ;
427:

Line 437: Orig_Rec IN OUT NOCOPY igf_sl_dl_record.DLOrigType)

433: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
434: p_dl_loan_number igf_sl_loans.loan_number%TYPE,
435: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
436: p_school_code IN VARCHAR2,
437: Orig_Rec IN OUT NOCOPY igf_sl_dl_record.DLOrigType)
438: AS
439: /*************************************************************
440: Created By : venagara
441: Date Created On : 2000/11/13

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

562: lv_acad_begin_dt,
563: lv_acad_end_dt,
564: lv_message ) ;
565: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_message got from get_acad_cal_dtls:'|| lv_message);
567: END IF;
568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);
570: END IF;

Line 569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);

565: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_message got from get_acad_cal_dtls:'|| lv_message);
567: END IF;
568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);
570: END IF;
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_end_date got from get_acad_cal_dtls:'|| lv_acad_end_dt);
573: END IF;

Line 572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_end_date got from get_acad_cal_dtls:'|| lv_acad_end_dt);

568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);
570: END IF;
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_end_date got from get_acad_cal_dtls:'|| lv_acad_end_dt);
573: END IF;
574: -- FA 122 Loan Enhancements derive the paramters to be passed to the c_lor cursor
575: IF p_dl_loan_catg = 'DL_STAFFORD' THEN
576: l_fed_fund_1 := 'DLS';

Line 855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLOrig_cur.exception',SQLERRM);

851:
852: EXCEPTION
853: WHEN OTHERS THEN
854: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLOrig_cur.exception',SQLERRM);
856: END IF;
857: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
858: fnd_message.set_token('NAME','igf_sl_dl_record.DLOrig_cur');
859: igs_ge_msg_stack.add;

Line 858: fnd_message.set_token('NAME','igf_sl_dl_record.DLOrig_cur');

854: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLOrig_cur.exception',SQLERRM);
856: END IF;
857: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
858: fnd_message.set_token('NAME','igf_sl_dl_record.DLOrig_cur');
859: igs_ge_msg_stack.add;
860: app_exception.raise_exception;
861: END DLOrig_cur;
862:

Line 864: END igf_sl_dl_record;

860: app_exception.raise_exception;
861: END DLOrig_cur;
862:
863:
864: END igf_sl_dl_record;