[Home] [Help]
635: -- Log values
636: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
637: fnd_log.string(fnd_log.level_statement,
638: 'igf.plsql.igf_aw_packaging.get_term_start_date.debug '|| g_req_id,
639: 'IGF_AP_GEN_001.get_term_dates called with the following parameters: p_base_id/p_ld_cal_type/p_ld_sequence_number = ' ||p_base_id|| '/' ||p_ld_cal_type|| '/' ||p_ld_sequence_number);
640: END IF;
641:
642: -- Get term's start date
643: IGF_AP_GEN_001.get_term_dates (
639: 'IGF_AP_GEN_001.get_term_dates called with the following parameters: p_base_id/p_ld_cal_type/p_ld_sequence_number = ' ||p_base_id|| '/' ||p_ld_cal_type|| '/' ||p_ld_sequence_number);
640: END IF;
641:
642: -- Get term's start date
643: IGF_AP_GEN_001.get_term_dates (
644: p_base_id,
645: p_ld_cal_type,
646: p_ld_sequence_number,
647: l_term_start_date,
6160: -- (b) Admissions data
6161: -- (c) FA Anticipated data
6162:
6163: -- (a) Get the Student's Key Program from Enrollment (Actual data)
6164: IGF_AP_GEN_001.get_key_program( cp_base_id => l_base_id,
6165: cp_course_cd => l_stud_program_cd,
6166: cp_version_number => l_stud_program_ver);
6167:
6168: IF l_stud_program_cd IS NULL THEN -- Enrollment
9474: lv_return_status := NULL;
9475: l_pell_schedule_code := NULL;
9476: l_term_aid := NULL;
9477:
9478: igf_ap_gen_001.get_key_program(
9479: cp_base_id => l_fabase.base_id,
9480: cp_course_cd => l_program_cd,
9481: cp_version_number => l_program_version
9482: );
9542: l_term_end := NULL;
9543: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'calling get_term_dates');
9545: END IF;
9546: igf_ap_gen_001.get_term_dates(
9547: p_base_id => l_fabase.base_id,
9548: p_ld_cal_type => l_term_amounts.ld_cal_type,
9549: p_ld_sequence_number => l_term_amounts.ld_sequence_number,
9550: p_ld_start_date => l_term_start,
12343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_disb_dt('||l_cnt||').base_attendance_type ' || l_disb_dt(l_cnt).base_attendance_type_code);
12344: END IF;
12345:
12346: -- Get the Offset data alias instances of the Fund.
12347: l_disb_dt(l_cnt).nslds_disb_date := igf_ap_gen_001.get_date_alias_val(
12348: l_base_id,
12349: l_tp_perct.ld_cal_type,
12350: l_tp_perct.ld_sequence_number,
12351: l_nslds_da
12349: l_tp_perct.ld_cal_type,
12350: l_tp_perct.ld_sequence_number,
12351: l_nslds_da
12352: );
12353: l_disb_dt(l_cnt).disb_exp_dt := igf_ap_gen_001.get_date_alias_val(
12354: l_base_id,
12355: l_tp_perct.ld_cal_type,
12356: l_tp_perct.ld_sequence_number,
12357: l_exp_da
12355: l_tp_perct.ld_cal_type,
12356: l_tp_perct.ld_sequence_number,
12357: l_exp_da
12358: );
12359: l_disb_dt(l_cnt).disb_verf_dt := igf_ap_gen_001.get_date_alias_val(
12360: l_base_id,
12361: l_tp_perct.ld_cal_type,
12362: l_tp_perct.ld_sequence_number,
12363: l_verf_da
12810: || Known limitations, enhancements or remarks :
12811: || Change History :
12812: || Who WHEN What
12813: || (reverse chronological order - newest change first)
12814: || veramach 30-Oct-2004 FA 152 Modified code to call igf_ap_gen_001.get_date_alias_val
12815: */
12816:
12817: BEGIN
12818:
12815: */
12816:
12817: BEGIN
12818:
12819: RETURN igf_ap_gen_001.get_date_alias_val(
12820: p_base_id => p_base_id,
12821: p_cal_type => p_cal_type,
12822: p_sequence_number => p_cal_sequence,
12823: p_date_alias => p_dt_alias
13114: l_awd_grp c_awd_grp%ROWTYPE;
13115:
13116: BEGIN
13117:
13118: l_param_pass_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
13119: l_awd_yr_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
13120: l_pers_number_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
13121: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13115:
13116: BEGIN
13117:
13118: l_param_pass_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
13119: l_awd_yr_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
13120: l_pers_number_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
13121: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13116: BEGIN
13117:
13118: l_param_pass_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
13119: l_awd_yr_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
13120: l_pers_number_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
13121: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13117:
13118: l_param_pass_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
13119: l_awd_yr_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
13120: l_pers_number_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
13121: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13118: l_param_pass_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
13119: l_awd_yr_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
13120: l_pers_number_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
13121: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13119: l_awd_yr_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
13120: l_pers_number_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
13121: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13120: l_pers_number_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
13121: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13121: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13122: l_ap_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_PERIOD');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13130: l_agrp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_GRP');
13123: l_fund_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','FUND_CODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13130: l_agrp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_GRP');
13131: l_sim_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','SIM_MODE');
13124: l_dp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_DIST_PLAN');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13130: l_agrp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_GRP');
13131: l_sim_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','SIM_MODE');
13132: l_runm_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RUN_MODE');
13125: l_sf_min_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MIN_AMOUNT');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13130: l_agrp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_GRP');
13131: l_sim_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','SIM_MODE');
13132: l_runm_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RUN_MODE');
13133: l_publish_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PUBLISH_IN_SS');
13126: l_sf_max_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','MAX_AMOUNT');
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13130: l_agrp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_GRP');
13131: l_sim_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','SIM_MODE');
13132: l_runm_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RUN_MODE');
13133: l_publish_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PUBLISH_IN_SS');
13134:
13127: l_allow_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','ALLOW_EXCEED');
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13130: l_agrp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_GRP');
13131: l_sim_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','SIM_MODE');
13132: l_runm_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RUN_MODE');
13133: l_publish_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PUBLISH_IN_SS');
13134:
13135: fnd_file.put_line(fnd_file.log,l_param_pass_log);
13128: l_notif_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','UPD_NOTIF_STAT');
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13130: l_agrp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_GRP');
13131: l_sim_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','SIM_MODE');
13132: l_runm_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RUN_MODE');
13133: l_publish_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PUBLISH_IN_SS');
13134:
13135: fnd_file.put_line(fnd_file.log,l_param_pass_log);
13136:
13129: l_lock_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOCK_AWD');
13130: l_agrp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWD_GRP');
13131: l_sim_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','SIM_MODE');
13132: l_runm_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RUN_MODE');
13133: l_publish_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PUBLISH_IN_SS');
13134:
13135: fnd_file.put_line(fnd_file.log,l_param_pass_log);
13136:
13137: --log award year