DBA Data[Home] [Help]

APPS.IGF_AW_GEN_003 dependencies on IGF_GR_GEN

Line 2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));

2873: IF NVL(p_return_status,'N') = 'E' THEN
2874: RETURN;
2875: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
2876: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_ERR');
2877: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
2878: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
2879: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
2880: fnd_message.set_token('CALC_AMT',p_term_aid);
2881: p_message := fnd_message.get;

Line 3426: OPEN cur_max_lf_count( p_fund_code,igf_gr_gen.get_person_id(p_base_id));

3422: OPEN cur_total_award_amt(p_award_id);
3423: FETCH cur_total_award_amt INTO total_award_amt_rec;
3424: CLOSE cur_total_award_amt;
3425:
3426: OPEN cur_max_lf_count( p_fund_code,igf_gr_gen.get_person_id(p_base_id));
3427: FETCH cur_max_lf_count INTO max_lf_count_rec;
3428: CLOSE cur_max_lf_count;
3429:
3430: OPEN cur_agg_lf_count( p_fund_code,igf_gr_gen.get_person_id(p_base_id));

Line 3430: OPEN cur_agg_lf_count( p_fund_code,igf_gr_gen.get_person_id(p_base_id));

3426: OPEN cur_max_lf_count( p_fund_code,igf_gr_gen.get_person_id(p_base_id));
3427: FETCH cur_max_lf_count INTO max_lf_count_rec;
3428: CLOSE cur_max_lf_count;
3429:
3430: OPEN cur_agg_lf_count( p_fund_code,igf_gr_gen.get_person_id(p_base_id));
3431: FETCH cur_agg_lf_count INTO agg_lf_count_rec;
3432: CLOSE cur_agg_lf_count;
3433:
3434: max_lf_count_rec.lf_total := max_lf_count_rec.lf_total + agg_lf_count_rec.lf_total;

Line 3576: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));

3572: lv_message := p_message;
3573: RETURN lv_message;
3574: ELSIF NVL(p_term_aid,0) < term_amounts_rec.term_total THEN
3575: fnd_message.set_name('IGF','IGF_AW_PELL_DISB_WARN');
3576: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(term_amounts_rec.ld_cal_type,term_amounts_rec.ld_sequence_number));
3577: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',term_amounts_rec.base_attendance_type_code));
3578: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
3579: fnd_message.set_token('CALC_AMT',p_term_aid);
3580: fnd_msg_pub.add;