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_AWARD dependencies on IGF_SL_AWARD

Line 1: PACKAGE BODY igf_sl_award AS

1: PACKAGE BODY igf_sl_award AS
2: /* $Header: IGFSL13B.pls 120.5 2006/08/10 16:16:24 museshad ship $ */
3:
4: --
5: ----------------------------------------------------------------------------------------

Line 135: igf_sl_award.pick_setup(p_base_id,p_ci_cal_type,p_ci_seq_num,l_rel_code,l_person_id,l_party_id,p_alt_rel_code);

131: l_party_id := NULL;
132: l_person_id := NULL;
133:
134: -- pick the values from the setup base on the base_id
135: igf_sl_award.pick_setup(p_base_id,p_ci_cal_type,p_ci_seq_num,l_rel_code,l_person_id,l_party_id,p_alt_rel_code);
136: g_rel_code := l_rel_code;
137: g_party_id := l_party_id;
138: -- put debug log messages
139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);

136: g_rel_code := l_rel_code;
137: g_party_id := l_party_id;
138: -- put debug log messages
139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
141: END IF;
142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);
144: END IF;

Line 143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);

139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
141: END IF;
142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);
144: END IF;
145:
146:
147: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN

Line 157: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.exception',SQLERRM);

153: RETURN l_hold_rel_ind;
154:
155: EXCEPTION WHEN OTHERS THEN
156: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
157: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.exception',SQLERRM);
158: END IF;
159: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
160: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_HOLD_REL_IND');
161: igs_ge_msg_stack.conc_exception_hndl;

Line 160: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_HOLD_REL_IND');

156: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
157: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.exception',SQLERRM);
158: END IF;
159: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
160: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_HOLD_REL_IND');
161: igs_ge_msg_stack.conc_exception_hndl;
162: app_exception.raise_exception;
163:
164: END get_cl_hold_rel_ind;

Line 212: igf_sl_award.pick_setup(p_base_id,p_ci_cal_type,p_ci_seq_num,l_rel_code,l_person_id,l_party_id,p_alt_rel_code);

208: --
209: -- pick the values from the setup base on the base_id
210: --
211:
212: igf_sl_award.pick_setup(p_base_id,p_ci_cal_type,p_ci_seq_num,l_rel_code,l_person_id,l_party_id,p_alt_rel_code);
213: g_rel_code := l_rel_code ;
214: g_party_id := l_party_id;
215: --
216: -- put debug log messages

Line 219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);

215: --
216: -- put debug log messages
217: --
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
220: END IF;
221: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);
223: END IF;

Line 222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);

218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
220: END IF;
221: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);
223: END IF;
224:
225: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN
226: OPEN c_clsetup(g_rel_code,g_party_id);

Line 235: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.exception',SQLERRM);

231: RETURN l_auto_late_disb_ind;
232:
233: EXCEPTION WHEN OTHERS THEN
234: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
235: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.exception',SQLERRM);
236: END IF;
237: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
238: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_AUTO_LATE_IND');
239: igs_ge_msg_stack.conc_exception_hndl;

Line 238: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_AUTO_LATE_IND');

234: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
235: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.exception',SQLERRM);
236: END IF;
237: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
238: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_AUTO_LATE_IND');
239: igs_ge_msg_stack.conc_exception_hndl;
240: app_exception.raise_exception;
241:
242: END get_cl_auto_late_ind;

Line 321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);

317:
318: g_party_id := l_party_id;
319:
320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
322: END IF;
323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
325: END IF;

Line 324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);

320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
322: END IF;
323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
325: END IF;
326:
327: OPEN c_clsetup(g_rel_code,g_party_id);
328: FETCH c_clsetup INTO l_cl_fee1,l_cl_alt_fee1;

Line 351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);

347:
348: g_party_id := l_party_id;
349:
350: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
352: END IF;
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
355: END IF;

Line 354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);

350: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
352: END IF;
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
355: END IF;
356:
357: OPEN c_clsetup(g_rel_code,g_party_id);
358: FETCH c_clsetup INTO l_cl_fee1,l_cl_alt_fee1;

Line 368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee1.exception',SQLERRM);

364:
365: RETURN 0;
366: EXCEPTION WHEN OTHERS THEN
367: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee1.exception',SQLERRM);
369: END IF;
370: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
371: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE1');
372: igs_ge_msg_stack.conc_exception_hndl;

Line 371: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE1');

367: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee1.exception',SQLERRM);
369: END IF;
370: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
371: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE1');
372: igs_ge_msg_stack.conc_exception_hndl;
373: app_exception.raise_exception;
374:
375: END get_loan_fee1;

Line 447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned rel_code: '||l_rel_code);

443: --
444: -- put debug log messages
445: --
446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned rel_code: '||l_rel_code);
448: END IF;
449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);
451: END IF;

Line 450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);

446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned rel_code: '||l_rel_code);
448: END IF;
449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);
451: END IF;
452:
453:
454: IF igf_sl_gen.chk_cl_alt(p_fed_fund_code) = 'TRUE' THEN

Line 472: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee2.exception',SQLERRM);

468: RETURN 0;
469:
470: EXCEPTION WHEN OTHERS THEN
471: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
472: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee2.exception',SQLERRM);
473: END IF;
474: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
475: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE2');
476: igs_ge_msg_stack.conc_exception_hndl;

Line 475: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE2');

471: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
472: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee2.exception',SQLERRM);
473: END IF;
474: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
475: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE2');
476: igs_ge_msg_stack.conc_exception_hndl;
477: app_exception.raise_exception;
478: END get_loan_fee2;
479:

Line 528: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_disb_date.exception',SQLERRM);

524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
528: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_disb_date.exception',SQLERRM);
529: END IF;
530: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
531: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_DISB_DATE');
532: igs_ge_msg_stack.conc_exception_hndl;

Line 531: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_DISB_DATE');

527: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
528: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_disb_date.exception',SQLERRM);
529: END IF;
530: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
531: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_DISB_DATE');
532: igs_ge_msg_stack.conc_exception_hndl;
533: app_exception.raise_exception;
534:
535: END chk_disb_date;

Line 559: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_alt_rel_code.exception',SQLERRM);

555:
556: RETURN l_alt_rel_code;
557: EXCEPTION WHEN OTHERS THEN
558: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
559: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_alt_rel_code.exception',SQLERRM);
560: END IF;
561: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
562: fnd_message.set_token('NAME','IGF_SL_AWARD.get_alt_rel_code');
563: igs_ge_msg_stack.conc_exception_hndl;

Line 562: fnd_message.set_token('NAME','IGF_SL_AWARD.get_alt_rel_code');

558: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
559: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_alt_rel_code.exception',SQLERRM);
560: END IF;
561: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
562: fnd_message.set_token('NAME','IGF_SL_AWARD.get_alt_rel_code');
563: igs_ge_msg_stack.conc_exception_hndl;
564: app_exception.raise_exception;
565:
566: END get_alt_rel_code;

Line 604: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.Award_id', p_award_id);

600: -- not allow to update anything in Awards Table. So, returning
601: -- FALSE, saying do not allow update to awards.
602:
603: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
604: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.Award_id', p_award_id);
605: END IF;
606:
607: OPEN c_loans(p_award_id);
608: FETCH c_loans INTO l_loan_id, l_loan_status, l_loan_chg_status;

Line 614: l_n_cl_version := igf_sl_award.get_loan_cl_version(p_n_award_id => p_award_id);

610:
611: IF l_loan_id IS NOT NULL THEN
612:
613: -- get the loan version for the input award id
614: l_n_cl_version := igf_sl_award.get_loan_cl_version(p_n_award_id => p_award_id);
615:
616: -- FA 122 Loan Enhancements BKKUMAR 30-SEP-2003
617: -- first get the fund code to see if it is a DL Record or FFELP Loan Record
618: l_get_fed_fund_code := NULL;

Line 653: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.exception',SQLERRM);

649: END IF;
650: RETURN 'FALSE';
651: EXCEPTION WHEN OTHERS THEN
652: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
653: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.exception',SQLERRM);
654: END IF;
655: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
656: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_LOAN_UPD_LOCK');
657: igs_ge_msg_stack.conc_exception_hndl;

Line 656: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_LOAN_UPD_LOCK');

652: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
653: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.exception',SQLERRM);
654: END IF;
655: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
656: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_LOAN_UPD_LOCK');
657: igs_ge_msg_stack.conc_exception_hndl;
658: app_exception.raise_exception;
659:
660: END chk_loan_upd_lock;

Line 714: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_amts.exception',SQLERRM);

710: p_rebate_amt := p_net_amt - ( p_gross_amt - p_loan_fee_amt);
711:
712: EXCEPTION WHEN OTHERS THEN
713: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
714: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_amts.exception',SQLERRM);
715: END IF;
716: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_AMTS');
718: igs_ge_msg_stack.conc_exception_hndl;

Line 717: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_AMTS');

713: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
714: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_amts.exception',SQLERRM);
715: END IF;
716: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_AMTS');
718: igs_ge_msg_stack.conc_exception_hndl;
719: app_exception.raise_exception;
720:
721:

Line 803: igf_sl_award.pick_setup(p_base_id,p_cal_type,p_sequence_number,l_rel_code,l_person_id,l_party_id,l_alt_rel_code);

799: FETCH c_get_alt_code INTO l_alt_rel_code;
800: CLOSE c_get_alt_code;
801:
802: -- pick the values from the setup base on the base_id
803: igf_sl_award.pick_setup(p_base_id,p_cal_type,p_sequence_number,l_rel_code,l_person_id,l_party_id,l_alt_rel_code);
804: IF l_rel_code = p_rel_code THEN
805: g_party_id := l_party_id;
806: ELSE
807: g_party_id := NULL;

Line 811: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned rel_code: '||l_rel_code);

807: g_party_id := NULL;
808: END IF;
809: -- put debug log messages
810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
811: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned rel_code: '||l_rel_code);
812: END IF;
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned party_id: '||l_party_id);
815: END IF;

Line 814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned party_id: '||l_party_id);

810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
811: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned rel_code: '||l_rel_code);
812: END IF;
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned party_id: '||l_party_id);
815: END IF;
816:
817: g_rel_code := p_rel_code;
818:

Line 826: l_fee1 := igf_sl_award.get_loan_fee1(

822: CLOSE c_get_fed_fund_code;
823:
824: -- museshad (Bug 3943742). Passed NULL for p_rel_code in both get_loan_fee1() and get_loan_fee2()
825: -- get the fee1 and fee2 for the setup
826: l_fee1 := igf_sl_award.get_loan_fee1(
827: p_fed_fund_code => l_get_fed_fund_code.fed_fund_code,
828: p_ci_cal_type => p_cal_type,
829: p_ci_seq_num => p_sequence_number,
830: p_base_id => p_base_id,

Line 835: l_fee2 := igf_sl_award.get_loan_fee2(

831: p_rel_code => NULL,
832: p_alt_rel_code => NULL
833: );
834:
835: l_fee2 := igf_sl_award.get_loan_fee2(
836: p_fed_fund_code => l_get_fed_fund_code.fed_fund_code,
837: p_ci_cal_type => p_cal_type,
838: p_ci_seq_num => p_sequence_number,
839: p_base_id => p_base_id,

Line 911: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.recalc_fees.exception',SQLERRM);

907: END LOOP;
908:
909: EXCEPTION WHEN OTHERS THEN
910: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
911: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.recalc_fees.exception',SQLERRM);
912: END IF;
913: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
914: fnd_message.set_token('NAME','IGF_SL_AWARD.RECALC_FEES');
915: igs_ge_msg_stack.conc_exception_hndl;

Line 914: fnd_message.set_token('NAME','IGF_SL_AWARD.RECALC_FEES');

910: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
911: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.recalc_fees.exception',SQLERRM);
912: END IF;
913: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
914: fnd_message.set_token('NAME','IGF_SL_AWARD.RECALC_FEES');
915: igs_ge_msg_stack.conc_exception_hndl;
916: app_exception.raise_exception;
917:
918: END recalc_fees;

Line 1042: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.pick_setup.debug','The value select_org returned : '||g_party_id);

1038: g_base_id := p_base_id;
1039: igf_sl_gen.get_associated_org(g_base_id, lv_party_number, g_party_id, lv_module, lv_return_status, lv_msg_data);
1040:
1041: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1042: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.pick_setup.debug','The value select_org returned : '||g_party_id);
1043: END IF;
1044: --FACR116
1045: -- If the alt_rel_code passed is NOT NULL means it has to be done for the Alternative Loans
1046: IF p_alt_rel_code IS NOT NULL THEN

Line 1211: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.pick_setup.exception',SQLERRM);

1207: p_party_id := g_party_id;
1208:
1209: EXCEPTION WHEN OTHERS THEN
1210: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1211: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.pick_setup.exception',SQLERRM);
1212: END IF;
1213: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1214: fnd_message.set_token('NAME','IGF_SL_AWARD.PICK_SETUP');
1215: igs_ge_msg_stack.conc_exception_hndl;

Line 1214: fnd_message.set_token('NAME','IGF_SL_AWARD.PICK_SETUP');

1210: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1211: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.pick_setup.exception',SQLERRM);
1212: END IF;
1213: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1214: fnd_message.set_token('NAME','IGF_SL_AWARD.PICK_SETUP');
1215: igs_ge_msg_stack.conc_exception_hndl;
1216: app_exception.raise_exception;
1217:
1218: END pick_setup;

Line 1271: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_chg_enable exception',SQLERRM);

1267: RETURN TRUE;
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1271: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_chg_enable exception',SQLERRM);
1272: END IF;
1273: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1274: fnd_message.set_token('NAME','igf_sl_award.chk_chg_enable');
1275: igs_ge_msg_stack.add;

Line 1274: fnd_message.set_token('NAME','igf_sl_award.chk_chg_enable');

1270: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1271: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_chg_enable exception',SQLERRM);
1272: END IF;
1273: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1274: fnd_message.set_token('NAME','igf_sl_award.chk_chg_enable');
1275: igs_ge_msg_stack.add;
1276: app_exception.raise_exception;
1277: END chk_chg_enable;
1278:

Line 1329: l_return_val:= igf_sl_award.chk_chg_enable (p_n_award_id => l_n_award_id);

1325: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1326: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1327: CLOSE c_igf_aw_awd_disb ;
1328:
1329: l_return_val:= igf_sl_award.chk_chg_enable (p_n_award_id => l_n_award_id);
1330:
1331: IF NOT (l_return_val) THEN
1332: RETURN TRUE;
1333: END IF;

Line 1345: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_add_new_disb exception',SQLERRM);

1341:
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_add_new_disb exception',SQLERRM);
1346: END IF;
1347: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1348: fnd_message.set_token('NAME','igf_sl_award.chk_add_new_disb');
1349: igs_ge_msg_stack.add;

Line 1348: fnd_message.set_token('NAME','igf_sl_award.chk_add_new_disb');

1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_add_new_disb exception',SQLERRM);
1346: END IF;
1347: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1348: fnd_message.set_token('NAME','igf_sl_award.chk_add_new_disb');
1349: igs_ge_msg_stack.add;
1350: app_exception.raise_exception;
1351: END chk_add_new_disb;
1352:

Line 1450: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_loan_increase exception',SQLERRM);

1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1450: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_loan_increase exception',SQLERRM);
1451: END IF;
1452: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1453: fnd_message.set_token('NAME','igf_sl_award.chk_loan_increase');
1454: igs_ge_msg_stack.add;

Line 1453: fnd_message.set_token('NAME','igf_sl_award.chk_loan_increase');

1449: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1450: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_loan_increase exception',SQLERRM);
1451: END IF;
1452: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1453: fnd_message.set_token('NAME','igf_sl_award.chk_loan_increase');
1454: igs_ge_msg_stack.add;
1455: app_exception.raise_exception;
1456: END chk_loan_increase;
1457:

Line 1528: fnd_log.string(fnd_log.level_exception,'igf_sl_award.get_loan_cl_version exception',SQLERRM);

1524:
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1528: fnd_log.string(fnd_log.level_exception,'igf_sl_award.get_loan_cl_version exception',SQLERRM);
1529: END IF;
1530: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1531: fnd_message.set_token('NAME','igf_sl_award.get_loan_cl_version');
1532: igs_ge_msg_stack.add;

Line 1531: fnd_message.set_token('NAME','igf_sl_award.get_loan_cl_version');

1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1528: fnd_log.string(fnd_log.level_exception,'igf_sl_award.get_loan_cl_version exception',SQLERRM);
1529: END IF;
1530: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1531: fnd_message.set_token('NAME','igf_sl_award.get_loan_cl_version');
1532: igs_ge_msg_stack.add;
1533: app_exception.raise_exception;
1534: END get_loan_cl_version;
1535:

Line 1611: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_fund_st_chg exception',SQLERRM);

1607: RETURN TRUE;
1608: EXCEPTION
1609: WHEN OTHERS THEN
1610: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1611: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_fund_st_chg exception',SQLERRM);
1612: END IF;
1613: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1614: fnd_message.set_token('NAME','igf_sl_award.chk_fund_st_chg');
1615: igs_ge_msg_stack.add;

Line 1614: fnd_message.set_token('NAME','igf_sl_award.chk_fund_st_chg');

1610: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1611: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_fund_st_chg exception',SQLERRM);
1612: END IF;
1613: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1614: fnd_message.set_token('NAME','igf_sl_award.chk_fund_st_chg');
1615: igs_ge_msg_stack.add;
1616: app_exception.raise_exception;
1617: END chk_fund_st_chg;
1618:

Line 1619: END igf_sl_award;

1615: igs_ge_msg_stack.add;
1616: app_exception.raise_exception;
1617: END chk_fund_st_chg;
1618:
1619: END igf_sl_award;