[Home] [Help]
121: END IF;
122:
123: BEGIN
124: igs_en_prc_load.enrp_get_inst_latt(
125: igf_gr_gen.get_person_id(p_base_id), p_load_cal_type,
126: p_load_seq_number, l_key_att_type, l_credit_pts, l_fte
127: );
128: EXCEPTION
129: WHEN OTHERS
478: || get_fund_code_rec.fund_code
479: );
480: fnd_file.put_line(
481: fnd_file.log, RPAD(l_person_number, 40) || ' : '
482: || igf_gr_gen.get_per_num(p_base_id)
483: );
484: fnd_file.put_line(fnd_file.log, RPAD(l_loan_id, 40) || ' : ' || p_loan_id);
485:
486: fnd_file.put_line(
1072: )
1073: LOOP
1074: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1075: THEN
1076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id(' || p_base_id || '):'|| igf_gr_gen.get_person_id(p_base_id));
1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:' || get_acad_tp_rec.tp_cal_type);
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'|| get_acad_tp_rec.tp_sequence_number);
1079: END IF;
1080:
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'|| get_acad_tp_rec.tp_sequence_number);
1079: END IF;
1080:
1081: FOR get_att_rec IN cur_get_att(
1082: igf_gr_gen.get_person_id(p_base_id),
1083: p_acad_cal_type, get_acad_tp_rec.tp_cal_type,
1084: get_acad_tp_rec.tp_sequence_number
1085: )
1086: LOOP
1371: IF p_message_name IS NULL
1372: THEN
1373: OPEN cur_fee_cls(
1374: p_fund_id, p_fee_cal_type, p_fee_ci_sequence_number,
1375: igf_gr_gen.get_person_id(p_base_id)
1376: );
1377: FETCH cur_fee_cls INTO fee_cls_rec;
1378:
1379: IF cur_fee_cls%FOUND
1991:
1992:
1993: -- No Disbursements found for Student
1994: fnd_message.set_name('IGF', 'IGF_SL_NO_DISB_TO_REL');
1995: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
1996: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
1997:
1998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1999: THEN
1996: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
1997:
1998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1999: THEN
2000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no disbursments availaible for release'|| igf_gr_gen.get_per_num(p_base_id));
2001: END IF;
2002:
2003: p_result := fnd_message.get;
2004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || p_result);
2068: END IF;
2069:
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2071: THEN
2072: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','starting processing for ' || igf_gr_gen.get_per_num(p_base_id)|| ' ' || get_fund_desc(awd_disb_rec.fund_id));
2073: END IF;
2074:
2075: -- FOR all the records IN CUR_AWD_DISB
2076: LOOP
2090: OR (l_old_fund <> l_new_fund AND l_old_fund > 1)
2091: THEN
2092: fnd_file.new_line(fnd_file.log, 1);
2093: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_STD_FUND');
2094: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
2095: fnd_message.set_token('FDESC', get_fund_desc(awd_disb_rec.fund_id));
2096: fnd_file.put_line(
2097: fnd_file.log, RPAD(' ', 10) || fnd_message.get
2098: );
2124: IF l_old_fund <> l_new_fund
2125: THEN
2126: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level
2127: THEN
2128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','processing in award year context '|| igf_gr_gen.get_per_num(p_base_id) || ' '|| get_fund_desc(awd_disb_rec.fund_id));
2129: END IF;
2130:
2131: -- For each new fund that is visible within this scope,
2132: -- the result variables are initialized
2137: l_elig_result := TRUE;
2138: l_ac_hold_result := TRUE;
2139:
2140: IF igf_aw_gen_005.get_stud_hold_effect(
2141: 'D', igf_gr_gen.get_person_id(p_base_id),
2142: awd_disb_rec.fund_code
2143: ) = 'F'
2144: THEN
2145: l_ac_hold_result := FALSE;
2659: );
2660: END IF;
2661:
2662: igs_en_prc_load.enrp_clc_cp_upto_tp_start_dt(
2663: igf_gr_gen.get_person_id(awd_disb_rec.base_id),
2664: awd_disb_rec.ld_cal_type, awd_disb_rec.ld_sequence_number,
2665: 'Y', get_cut_off_dt(
2666: awd_disb_rec.ld_sequence_number,
2667: awd_disb_rec.disb_date
3598: --
3599: -- Check for Academic Holds, only if con job is run
3600: --
3601: IF igf_aw_gen_005.get_stud_hold_effect(
3602: 'D', igf_gr_gen.get_person_id(l_base_id)
3603: ) = 'F'
3604: THEN
3605: fnd_message.set_name(
3606: 'IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL'
3672: THEN
3673: fnd_log.string(
3674: fnd_log.level_statement,
3675: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3676: igf_gr_gen.get_per_num_oss(l_person_id)
3677: || ' not in FA'
3678: );
3679: END IF;
3680: END IF; -- (IF l_base_id IS NOT NULL)
3759: || award_std_rec.base_id
3760: );
3761: END IF;
3762:
3763: l_person_number := igf_gr_gen.get_per_num(
3764: award_std_rec.base_id
3765: );
3766:
3767: IF fnd_log.level_statement >=
3794: -- Check for Academic Holds, only if con job is run
3795: --
3796: IF igf_aw_gen_005.get_stud_hold_effect(
3797: 'D',
3798: igf_gr_gen.get_person_id(award_std_rec.base_id)
3799: ) = 'F'
3800: THEN
3801: fnd_message.set_name(
3802: 'IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL'
3915: END IF; -- (IF p_fund_id IS NOT NULL)
3916: ELSE
3917: -- i.e, base_id is specified therefore process for the particular student only
3918:
3919: l_person_number := igf_gr_gen.get_per_num(p_base_id);
3920: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3921: fnd_message.set_token('STDNT', l_person_number);
3922: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
3923:
3934: -- Check for Academic Holds, only if con job is run
3935: --
3936:
3937: IF igf_aw_gen_005.get_stud_hold_effect(
3938: 'D', igf_gr_gen.get_person_id(p_base_id)
3939: ) = 'F'
3940: THEN
3941: fnd_message.set_name('IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL');
3942: fnd_file.put_line(