[Home] [Help]
881: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_students_need.debug '|| g_req_id,'Calculated NEED values are l_normal_efc: '||l_normal_efc||' and p_coa : '||p_coa);
883: END IF;
884:
885: igf_aw_award_t_pkg.insert_row(
886: x_rowid => lv_rowid ,
887: x_process_id => l_process_id ,
888: x_sl_number => l_sl_number,
889: x_fund_id => NULL,
2009: 'igf.plsql.igf_aw_packaging.round_off_disbursements.debug '|| g_req_id,
2010: 'Disbursement number: ' ||l_disb_no|| ' Old Disbursement amount: ' ||l_disb_rec.temp_num_val1|| ' New disbursement amount after applying rounding logic: ' ||NVL(l_disb_structure_rec(l_disb_no).disb_amt, 0));
2011: END IF;
2012:
2013: igf_aw_award_t_pkg.update_row(
2014: x_rowid => l_disb_rec.rowid,
2015: x_process_id => l_disb_rec.process_id,
2016: x_sl_number => l_disb_rec.sl_number,
2017: x_fund_id => l_disb_rec.fund_id,
4820: ' l_merge.temp_val3_num:'||l_merge.temp_val3_num||
4821: 'l_merge.temp_val4_num:'||l_merge.temp_val4_num
4822: );
4823: END IF;
4824: igf_aw_award_t_pkg.update_row(
4825: x_rowid => l_merge.row_id,
4826: x_process_id => l_merge.process_id,
4827: x_sl_number => l_merge.sl_number,
4828: x_fund_id => l_merge.fund_id,
5133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:OV for fund:'||p_fund_id||' and base_id:'||p_base_id);
5134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'l_awds.remaining_amt:'||l_awds.remaining_amt);
5135: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'l_overaward:'||l_overaward);
5136: END IF;
5137: igf_aw_award_t_pkg.insert_row(
5138: x_rowid => lv_rowid ,
5139: x_process_id => l_process_id ,
5140: x_sl_number => l_sl_number,
5141: x_fund_id => p_fund_id,
5348: IF lb_awards_locked THEN
5349: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'created locked award');
5351: END IF;
5352: igf_aw_award_t_pkg.insert_row(
5353: x_rowid => lv_rowid ,
5354: x_process_id => l_process_id ,
5355: x_sl_number => l_sl_number,
5356: x_fund_id => p_fund_id,
5382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'created unlocked award');
5383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'l_awds.max_award_amt:'||l_awds.max_award_amt||',l_awds.min_award_amt:'||l_awds.min_award_amt);
5384: END IF;
5385:
5386: igf_aw_award_t_pkg.insert_row(
5387: x_rowid => lv_rowid ,
5388: x_process_id => l_process_id ,
5389: x_sl_number => l_sl_number,
5390: x_fund_id => p_fund_id,
5423: -- for the fund when there are any existing locked awards from that
5424: -- fund
5425: FOR l_exist_awd IN c_get_unlocked_award(p_fund_id, p_base_id)
5426: LOOP
5427: igf_aw_award_t_pkg.update_row(
5428: x_rowid => l_exist_awd.rowid,
5429: x_process_id => l_exist_awd.process_id,
5430: x_sl_number => l_exist_awd.sl_number,
5431: x_fund_id => l_exist_awd.fund_id,
5480: FOR l_lock_pell_awd IN c_lock_pell_awd(p_fund_id,p_base_id) LOOP
5481: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5482: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'locked award_id:'||l_lock_pell_awd.award_id);
5483: END IF;
5484: igf_aw_award_t_pkg.update_row(
5485: x_rowid => l_lock_pell_awd.row_id,
5486: x_process_id => l_lock_pell_awd.process_id,
5487: x_sl_number => l_lock_pell_awd.sl_number,
5488: x_fund_id => l_lock_pell_awd.fund_id,
5529: FOR l_lock_pell_awd IN c_lock_pell_awd1(p_fund_id,p_base_id,l_latest_awd.award_id) LOOP
5530: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5531: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'locked award_id:'||l_lock_pell_awd.award_id);
5532: END IF;
5533: igf_aw_award_t_pkg.update_row(
5534: x_rowid => l_lock_pell_awd.row_id,
5535: x_process_id => l_lock_pell_awd.process_id,
5536: x_sl_number => l_lock_pell_awd.sl_number,
5537: x_fund_id => l_lock_pell_awd.fund_id,
6332: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'also g_plan_id:'||g_plan_id||',l_fund_ld.fund_id:'||l_fund_ld.adplans_id);
6333: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'also l_fund_ld.max_award_amt:'||l_fund_ld.max_award_amt||',l_fund_ld.min_award_amt:'||l_fund_ld.min_award_amt);
6334: END IF;
6335:
6336: igf_aw_award_t_pkg.insert_row(
6337: x_rowid => lv_rowid ,
6338: x_process_id => l_process_id ,
6339: x_sl_number => l_sl_number,
6340: x_fund_id => l_fund_ld.fund_id,
6400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.remaining_amt:'||l_fund_ld.remaining_amt);
6401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_overaward:'||l_overaward);
6402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'adplans_id:'||NVL(l_fund_ld.adplans_id,g_plan_id));
6403: END IF;
6404: igf_aw_award_t_pkg.insert_row(
6405: x_rowid => lv_rowid ,
6406: x_process_id => l_process_id ,
6407: x_sl_number => l_sl_number,
6408: x_fund_id => l_fund_ld.fund_id,
6479: cp_base_id => l_base_id,
6480: cp_process_id => l_process_id)
6481: LOOP
6482: -- Cancel awards
6483: igf_aw_award_t_pkg.update_row(
6484: x_rowid => l_cancel_awd_rec.rowid,
6485: x_process_id => l_cancel_awd_rec.process_id,
6486: x_sl_number => l_cancel_awd_rec.sl_number,
6487: x_fund_id => l_cancel_awd_rec.fund_id,
6741: ' base_id:'||l_init_flag.base_id||' to flag:'||l_flag
6742: );
6743: END IF;
6744:
6745: igf_aw_award_t_pkg.update_row(
6746: x_rowid => l_init_flag.row_id,
6747: x_process_id => l_init_flag.process_id,
6748: x_sl_number => l_init_flag.sl_number,
6749: x_fund_id => l_init_flag.fund_id,
6856: ' base_id:'||l_fund_chk.base_id||' to flag:'||l_flag
6857: );
6858: END IF;
6859:
6860: igf_aw_award_t_pkg.update_row(
6861: x_rowid => l_fund_chk.row_id,
6862: x_process_id => l_fund_chk.process_id,
6863: x_sl_number => l_fund_chk.sl_number,
6864: x_fund_id => l_fund_chk.fund_id,
6958: ' base_id:'||l_fund_chk.base_id||' to flag:'||l_flag
6959: );
6960: END IF;
6961:
6962: igf_aw_award_t_pkg.update_row(
6963: x_rowid => l_fund_chk.row_id,
6964: x_process_id => l_fund_chk.process_id,
6965: x_sl_number => l_fund_chk.sl_number,
6966: x_fund_id => l_fund_chk.fund_id,
7171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'c_rem_efc%FOUND - so updating values with '||' l_need:'||l_need||' l_efc:'||l_efc||' l_rem_efc:'||l_rem_efc||' l_need_VB_AC: '||l_need_VB_AC);
7172: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'p_awds.replace_fc:'||p_awds.replace_fc||' p_awds.update_need:'||p_awds.update_need||'adplans_id:'||l_efc_cur.adplans_id);
7173: END IF;
7174:
7175: igf_aw_award_t_pkg.update_row(
7176: x_rowid => l_efc_cur.row_id ,
7177: x_process_id => l_efc_cur.process_id ,
7178: x_sl_number => l_efc_cur.sl_number,
7179: x_fund_id => l_efc_cur.fund_id,
7349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'l_need_f:'||l_need_f||' l_need_i:'||l_need_i||' l_need_VB_AC_f:'||l_need_VB_AC_f|| ' l_need_VB_AC_i:' ||l_need_VB_AC_i);
7350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'inserting calculated values into igf_aw_award_t with x_temp_char_val1=FEDERAL');
7351: END IF;
7352: -- insert the record into Temp table
7353: igf_aw_award_t_pkg.insert_row(
7354: x_rowid => lv_rowid ,
7355: x_process_id => l_process_id ,
7356: x_sl_number => l_sl_number,
7357: x_fund_id => NULL,
7381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'inserting calculating values into igf_aw_award_t with x_temp_char_val1=INSTITUTIONAL');
7383: END IF;
7384: -- insert the record into Temp table
7385: igf_aw_award_t_pkg.insert_row(
7386: x_rowid => lv_rowid ,
7387: x_process_id => l_process_id ,
7388: x_sl_number => l_sl_number,
7389: x_fund_id => NULL,
9274: fnd_message.set_token('MONTH',l_efc_months);
9275: fnd_file.put_line(fnd_file.log,fnd_message.get);
9276:
9277:
9278: igf_aw_award_t_pkg.insert_row(
9279: x_rowid => lv_rowid ,
9280: x_process_id => l_process_id ,
9281: x_sl_number => l_sl_number,
9282: x_fund_id => l_fund.fund_id,
9303: x_temp_char2_txt => NULL,
9304: x_temp_char3_txt => NULL
9305: );
9306:
9307: igf_aw_award_t_pkg.insert_row(
9308: x_rowid => lv_rowid ,
9309: x_process_id => l_process_id ,
9310: x_sl_number => l_sl_number,
9311: x_fund_id => l_fund.fund_id,
9588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_term_amounts.adplans_id:'||l_term_amounts.adplans_id);
9589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_fund.award_id:'||l_fund.award_id);
9590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
9591: END IF;
9592: igf_aw_award_t_pkg.insert_row(
9593: x_rowid => lv_rowid ,
9594: x_process_id => l_process_id ,
9595: x_sl_number => l_sl_number,
9596: x_fund_id => l_fund.fund_id,
10754: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10755: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'after awarding updating amount for the fund as l_remaining_amt:'||l_remaining_amt||' l_overaward:'||l_overaward);
10756: END IF;
10757:
10758: igf_aw_award_t_pkg.update_row(
10759: x_rowid => l_cur_ovr_awd.row_id,
10760: x_process_id => l_cur_ovr_awd.process_id,
10761: x_sl_number => l_cur_ovr_awd.sl_number,
10762: x_fund_id => l_cur_ovr_awd.fund_id,
10803: 'process_id:'||l_process_id||
10804: 'fund_id:'||l_fmast.fund_id||
10805: 'base_id:'||l_fabase.base_id);
10806: END IF;
10807: igf_aw_award_t_pkg.insert_row(
10808: x_rowid => lv_rowid ,
10809: x_process_id => l_process_id ,
10810: x_sl_number => l_sl_number,
10811: x_fund_id => l_fmast.fund_id,
10843: 'base_id:'||l_fabase.base_id||
10844: 'award_id:'||l_temp_awd.award_id
10845: );
10846: END IF;
10847: igf_aw_award_t_pkg.update_row(
10848: x_rowid => l_temp_awd.row_id,
10849: x_process_id => l_temp_awd.process_id,
10850: x_sl_number => l_temp_awd.sl_number,
10851: x_fund_id => l_fmast.fund_id,
11024: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'after awarding,updating igf_aw_awrd_t (ONLY INSTITUTIONAL) with l_need_i :'||l_need_i|| ' l_need_VB_AC_i: ' ||l_need_VB_AC_i);
11026: END IF;
11027:
11028: igf_aw_award_t_pkg.update_row(
11029: x_rowid => l_rem_efc.row_id ,
11030: x_process_id => l_rem_efc.process_id ,
11031: x_sl_number => l_rem_efc.sl_number,
11032: x_fund_id => l_rem_efc.fund_id,
11061: 'after awarding,updating igf_aw_awrd_t (ONLY FEDERAL) with l_rem_rep_efc:'||l_rem_rep_efc
11062: ||' l_need_f :'||l_need_f|| ' l_need_VB_AC_f: ' ||l_need_VB_AC_f);
11063: END IF;
11064:
11065: igf_aw_award_t_pkg.update_row(
11066: x_rowid => l_rem_efc.row_id ,
11067: x_process_id => l_rem_efc.process_id ,
11068: x_sl_number => l_rem_efc.sl_number,
11069: x_fund_id => l_rem_efc.fund_id,
11384: LOOP
11385:
11386: FETCH c_awd_grp_funds INTO l_awd_grp_funds;
11387: EXIT WHEN c_awd_grp_funds%NOTFOUND;
11388: igf_aw_award_t_pkg.delete_row(l_awd_grp_funds.row_id);
11389: END LOOP;
11390: CLOSE c_awd_grp_funds;
11391:
11392: -- Insert one consolidated Value per fund ID
11519: ||' l_awd_grp.award_id:'||l_awd_grp.award_id
11520: );
11521: END IF;
11522:
11523: igf_aw_award_t_pkg.insert_row(
11524: x_rowid => lv_rowid ,
11525: x_process_id => l_process_id ,
11526: x_sl_number => l_sl_number,
11527: x_fund_id => l_awd_grp.fund_id,
11753: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'base_id:'||l_awd_det.base_id);
11754: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'flag:'||l_awd_det.flag);
11755: END IF;
11756:
11757: igf_aw_award_t_pkg.delete_row( x_rowid => l_awd_det.row_id );
11758: ELSE
11759: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11760: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'Calling update_row for');
11761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'fund_id:'||l_awd_det.fund_id);
11785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11786: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'cancelling the award');
11787: END IF;
11788: CLOSE c_awd_ex;
11789: igf_aw_award_t_pkg.update_row(
11790: x_rowid => l_awd_det.row_id,
11791: x_process_id => l_awd_det.process_id,
11792: x_sl_number => l_awd_det.sl_number,
11793: x_fund_id => l_awd_det.fund_id,
11819: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'deleting the award');
11821: END IF;
11822: CLOSE c_awd_ex;
11823: igf_aw_award_t_pkg.delete_row( x_rowid => l_awd_det.row_id );
11824: END IF;
11825: END IF;
11826: END LOOP;
11827:
12293: END IF;
12294: -- Create a disbursements INTO the temporary table with the fund deatils and the newly calculated disbursements amounts with the status = 'DB'
12295: l_sl_number := NULL;
12296:
12297: igf_aw_award_t_pkg.insert_row(
12298: x_rowid => lv_rowid,
12299: x_process_id => l_process_id,
12300: x_sl_number => l_sl_number,
12301: x_fund_id => l_fund_id,
12454: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12455: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'full participant logic');
12456: END IF;
12457: FOR i IN 1..g_pell_tab.COUNT LOOP
12458: igf_aw_award_t_pkg.insert_row(
12459: x_rowid => lv_rowid,
12460: x_process_id => l_process_id,
12461: x_sl_number => l_sl_number,
12462: x_fund_id => l_fund_id,
12551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.ld_sequence_number:'||l_pelldisb.ld_sequence_number);
12552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.award_id:'||l_pelldisb.award_id);
12553: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
12554: END IF;
12555: igf_aw_award_t_pkg.insert_row(
12556: x_rowid => lv_rowid,
12557: x_process_id => l_process_id,
12558: x_sl_number => l_sl_number,
12559: x_fund_id => l_fund_id,
12605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.adplans_id:'||l_pell_new_disb.adplans_id);
12606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.award_id:'||l_pell_new_disb.award_id);
12607: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
12608: END IF;
12609: igf_aw_award_t_pkg.insert_row(
12610: x_rowid => lv_rowid,
12611: x_process_id => l_process_id,
12612: x_sl_number => l_sl_number,
12613: x_fund_id => l_fund_id,
13655: LOOP
13656: FETCH c_temp_rec INTO l_temp_rec;
13657: EXIT WHEN c_temp_rec%NOTFOUND;
13658:
13659: igf_aw_award_t_pkg.delete_row(l_temp_rec.row_id );
13660:
13661: END LOOP;
13662: CLOSE c_temp_rec;
13663: