[Home] [Help]
188: l_anul_unsub_total NUMBER;
189:
190: BEGIN
191:
192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - START');
194: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_base_id '|| l_base_id );
195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :fund_type '|| fund_type );
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
189:
190: BEGIN
191:
192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - START');
194: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_base_id '|| l_base_id );
195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :fund_type '|| fund_type );
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
190: BEGIN
191:
192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - START');
194: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_base_id '|| l_base_id );
195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :fund_type '|| fund_type );
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
191:
192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - START');
194: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_base_id '|| l_base_id );
195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :fund_type '|| fund_type );
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_awd_period '|| l_awd_period );
192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - START');
194: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_base_id '|| l_base_id );
195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :fund_type '|| fund_type );
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_awd_period '|| l_awd_period );
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_called_from '|| l_called_from );
193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - START');
194: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_base_id '|| l_base_id );
195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :fund_type '|| fund_type );
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_awd_period '|| l_awd_period );
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_called_from '|| l_called_from );
201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :p_chk_aggr_limit '|| p_chk_aggr_limit );
194: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_base_id '|| l_base_id );
195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :fund_type '|| fund_type );
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_awd_period '|| l_awd_period );
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_called_from '|| l_called_from );
201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :p_chk_aggr_limit '|| p_chk_aggr_limit );
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - END');
195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :fund_type '|| fund_type );
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_awd_period '|| l_awd_period );
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_called_from '|| l_called_from );
201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :p_chk_aggr_limit '|| p_chk_aggr_limit );
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - END');
203: END IF;
196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_award_id '|| l_award_id );
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_awd_period '|| l_awd_period );
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_called_from '|| l_called_from );
201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :p_chk_aggr_limit '|| p_chk_aggr_limit );
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - END');
203: END IF;
204:
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_aid '|| l_aid );
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_awd_period '|| l_awd_period );
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_called_from '|| l_called_from );
201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :p_chk_aggr_limit '|| p_chk_aggr_limit );
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - END');
203: END IF;
204:
205: p_msg_name := NULL;
198: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_adplans_id '|| l_adplans_id );
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_awd_period '|| l_awd_period );
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :l_called_from '|| l_called_from );
201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','In Param :p_chk_aggr_limit '|| p_chk_aggr_limit );
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Parameter List - END');
203: END IF;
204:
205: p_msg_name := NULL;
206:
211: OPEN cur_grade_overide(l_award_id);
212: FETCH cur_grade_overide INTO grade_overide_rec;
213: CLOSE cur_grade_overide;
214:
215: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
216: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','grade_overide '|| grade_overide_rec.override_grade_level_code);
217: END IF;
218: --
219: -- If there is not grade level override record
212: FETCH cur_grade_overide INTO grade_overide_rec;
213: CLOSE cur_grade_overide;
214:
215: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
216: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','grade_overide '|| grade_overide_rec.override_grade_level_code);
217: END IF;
218: --
219: -- If there is not grade level override record
220: -- or if grade level override is null then derive class
227: l_award_id,
228: lv_course_type,
229: l_awd_period,
230: l_called_from);
231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
232: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','lv_class_standing:'||lv_class_standing);
233: END IF;
234: IF lv_class_standing IS NULL THEN
235: p_msg_name := 'IGF_AW_CLS_STD_NOT_FND';
228: lv_course_type,
229: l_awd_period,
230: l_called_from);
231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
232: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','lv_class_standing:'||lv_class_standing);
233: END IF;
234: IF lv_class_standing IS NULL THEN
235: p_msg_name := 'IGF_AW_CLS_STD_NOT_FND';
236: l_aid := 0;
235: p_msg_name := 'IGF_AW_CLS_STD_NOT_FND';
236: l_aid := 0;
237: RETURN;
238: END IF;
239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','calling dl cl std code with parameters - base_id: ' ||l_base_id|| ', class standing: ' ||lv_class_standing|| ', course type: ' ||lv_course_type);
241: END IF;
242:
243: igf_sl_lar_creation.get_dl_cl_std_code(l_base_id,
236: l_aid := 0;
237: RETURN;
238: END IF;
239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','calling dl cl std code with parameters - base_id: ' ||l_base_id|| ', class standing: ' ||lv_class_standing|| ', course type: ' ||lv_course_type);
241: END IF;
242:
243: igf_sl_lar_creation.get_dl_cl_std_code(l_base_id,
244: lv_class_standing,
244: lv_class_standing,
245: lv_course_type,
246: l_dl_std_code,
247: l_cl_std_code);
248: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
249: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','after dl cl std code');
250: END IF;
251:
252: IF l_dl_std_code IS NULL AND l_cl_std_code IS NULL THEN
245: lv_course_type,
246: l_dl_std_code,
247: l_cl_std_code);
248: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
249: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','after dl cl std code');
250: END IF;
251:
252: IF l_dl_std_code IS NULL AND l_cl_std_code IS NULL THEN
253: p_msg_name := 'IGF_AW_CLSSTD_MAP_NOT_FND';
255: RETURN;
256: END IF;
257: END IF;
258:
259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_dl_std_code: '||l_dl_std_code||' l_cl_std_code: '||l_cl_std_code);
261: END IF;
262:
263: OPEN c_get_status ;
256: END IF;
257: END IF;
258:
259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_dl_std_code: '||l_dl_std_code||' l_cl_std_code: '||l_cl_std_code);
261: END IF;
262:
263: OPEN c_get_status ;
264: FETCH c_get_status INTO l_get_status;
279: igs_ge_msg_stack.add;
280: END IF;
281: CLOSE c_nslds_loans;
282:
283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
284: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nslds_loan_rec.aggr_subs_loan: '||l_nslds_loan_rec.aggr_subs_loan);
285: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nslds_loan_rec.aggr_total_loan: '||l_nslds_loan_rec.aggr_total_loan);
286: END IF;
287:
280: END IF;
281: CLOSE c_nslds_loans;
282:
283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
284: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nslds_loan_rec.aggr_subs_loan: '||l_nslds_loan_rec.aggr_subs_loan);
285: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nslds_loan_rec.aggr_total_loan: '||l_nslds_loan_rec.aggr_total_loan);
286: END IF;
287:
288: IF l_std_loan_tab IS NOT NULL AND l_std_loan_tab.COUNT > 0 THEN -- check whether the table parameter is passed with rows
281: CLOSE c_nslds_loans;
282:
283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
284: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nslds_loan_rec.aggr_subs_loan: '||l_nslds_loan_rec.aggr_subs_loan);
285: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nslds_loan_rec.aggr_total_loan: '||l_nslds_loan_rec.aggr_total_loan);
286: END IF;
287:
288: IF l_std_loan_tab IS NOT NULL AND l_std_loan_tab.COUNT > 0 THEN -- check whether the table parameter is passed with rows
289:
286: END IF;
287:
288: IF l_std_loan_tab IS NOT NULL AND l_std_loan_tab.COUNT > 0 THEN -- check whether the table parameter is passed with rows
289:
290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_std_loan_tab.COUNT:'||l_std_loan_tab.COUNT);
292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Inside the pl-sql tab IF');
293: END IF;
294:
287:
288: IF l_std_loan_tab IS NOT NULL AND l_std_loan_tab.COUNT > 0 THEN -- check whether the table parameter is passed with rows
289:
290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_std_loan_tab.COUNT:'||l_std_loan_tab.COUNT);
292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Inside the pl-sql tab IF');
293: END IF;
294:
295:
288: IF l_std_loan_tab IS NOT NULL AND l_std_loan_tab.COUNT > 0 THEN -- check whether the table parameter is passed with rows
289:
290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_std_loan_tab.COUNT:'||l_std_loan_tab.COUNT);
292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Inside the pl-sql tab IF');
293: END IF;
294:
295:
296: FOR i IN 1..l_std_loan_tab.COUNT LOOP
294:
295:
296: FOR i IN 1..l_std_loan_tab.COUNT LOOP
297:
298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
299: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Inside the pl-sql tab loop');
300: END IF;
301:
302: l_yr_loan_amt := NVL(l_yr_loan_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
295:
296: FOR i IN 1..l_std_loan_tab.COUNT LOOP
297:
298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
299: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Inside the pl-sql tab loop');
300: END IF;
301:
302: l_yr_loan_amt := NVL(l_yr_loan_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
303:
301:
302: l_yr_loan_amt := NVL(l_yr_loan_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
303:
304: -- Log
305: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
306: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','added, to l_yr_loan_amt,award:'||NVL(l_std_loan_tab(i).award_amount,0)||' from:'||l_std_loan_tab(i).fund_code);
307: END IF;
308:
309: IF l_std_loan_tab(i).award_date >= l_nslds_loan_rec.tran_process_date THEN
302: l_yr_loan_amt := NVL(l_yr_loan_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
303:
304: -- Log
305: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
306: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','added, to l_yr_loan_amt,award:'||NVL(l_std_loan_tab(i).award_amount,0)||' from:'||l_std_loan_tab(i).fund_code);
307: END IF;
308:
309: IF l_std_loan_tab(i).award_date >= l_nslds_loan_rec.tran_process_date THEN
310: l_nsl_nc_ln_amt := NVL(l_nsl_nc_ln_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
309: IF l_std_loan_tab(i).award_date >= l_nslds_loan_rec.tran_process_date THEN
310: l_nsl_nc_ln_amt := NVL(l_nsl_nc_ln_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
311:
312: -- Log
313: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
314: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','added, to l_nsl_nc_ln_amt,award:'||NVL(l_std_loan_tab(i).award_amount,0)||' from:'||l_std_loan_tab(i).fund_code);
315: END IF;
316: END IF;
317:
310: l_nsl_nc_ln_amt := NVL(l_nsl_nc_ln_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
311:
312: -- Log
313: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
314: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','added, to l_nsl_nc_ln_amt,award:'||NVL(l_std_loan_tab(i).award_amount,0)||' from:'||l_std_loan_tab(i).fund_code);
315: END IF;
316: END IF;
317:
318: IF l_std_loan_tab(i).fed_fund_code IN ('FLS','DLS') THEN
317:
318: IF l_std_loan_tab(i).fed_fund_code IN ('FLS','DLS') THEN
319: l_yr_subs_amt := NVL(l_yr_subs_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
320: -- Log
321: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
322: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','added, to l_yr_subs_amt,award:'||NVL(l_std_loan_tab(i).award_amount,0)||' from:'||l_std_loan_tab(i).fund_code);
323: END IF;
324:
325: IF l_std_loan_tab(i).award_date >= l_nslds_loan_rec.tran_process_date THEN
318: IF l_std_loan_tab(i).fed_fund_code IN ('FLS','DLS') THEN
319: l_yr_subs_amt := NVL(l_yr_subs_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
320: -- Log
321: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
322: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','added, to l_yr_subs_amt,award:'||NVL(l_std_loan_tab(i).award_amount,0)||' from:'||l_std_loan_tab(i).fund_code);
323: END IF;
324:
325: IF l_std_loan_tab(i).award_date >= l_nslds_loan_rec.tran_process_date THEN
326: l_nsl_nc_sub_amt := NVL(l_nsl_nc_sub_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
325: IF l_std_loan_tab(i).award_date >= l_nslds_loan_rec.tran_process_date THEN
326: l_nsl_nc_sub_amt := NVL(l_nsl_nc_sub_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
327:
328: -- Log
329: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
330: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','added, to l_nsl_nc_sub_amt,award:'||NVL(l_std_loan_tab(i).award_amount,0)||' from:'||l_std_loan_tab(i).fund_code);
331: END IF;
332: END IF;
333: END IF;
326: l_nsl_nc_sub_amt := NVL(l_nsl_nc_sub_amt,0) + NVL(l_std_loan_tab(i).award_amount,0);
327:
328: -- Log
329: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
330: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','added, to l_nsl_nc_sub_amt,award:'||NVL(l_std_loan_tab(i).award_amount,0)||' from:'||l_std_loan_tab(i).fund_code);
331: END IF;
332: END IF;
333: END IF;
334: END LOOP; -- End for loop of student table
334: END LOOP; -- End for loop of student table
335:
336: ELSE
337:
338: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Inside the pl-sql tab ELSE');
340: END IF;
341:
342: OPEN c_get_anl_awd;
335:
336: ELSE
337:
338: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Inside the pl-sql tab ELSE');
340: END IF;
341:
342: OPEN c_get_anl_awd;
343: FETCH c_get_anl_awd INTO l_anl_awd_rec;
352:
353: l_nsl_nc_ln_amt := NVL(l_addtnl_awd_rec.loan_amt,0);
354: l_nsl_nc_sub_amt := NVL(l_addtnl_awd_rec.subs_loan_amt,0);
355:
356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_loan_amt:'||l_yr_loan_amt);
358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_subs_amt:'||l_yr_subs_amt);
359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_ln_amt:'||l_nsl_nc_ln_amt);
360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_sub_amt:'||l_nsl_nc_sub_amt);
353: l_nsl_nc_ln_amt := NVL(l_addtnl_awd_rec.loan_amt,0);
354: l_nsl_nc_sub_amt := NVL(l_addtnl_awd_rec.subs_loan_amt,0);
355:
356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_loan_amt:'||l_yr_loan_amt);
358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_subs_amt:'||l_yr_subs_amt);
359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_ln_amt:'||l_nsl_nc_ln_amt);
360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_sub_amt:'||l_nsl_nc_sub_amt);
361: END IF;
354: l_nsl_nc_sub_amt := NVL(l_addtnl_awd_rec.subs_loan_amt,0);
355:
356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_loan_amt:'||l_yr_loan_amt);
358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_subs_amt:'||l_yr_subs_amt);
359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_ln_amt:'||l_nsl_nc_ln_amt);
360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_sub_amt:'||l_nsl_nc_sub_amt);
361: END IF;
362:
355:
356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_loan_amt:'||l_yr_loan_amt);
358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_subs_amt:'||l_yr_subs_amt);
359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_ln_amt:'||l_nsl_nc_ln_amt);
360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_sub_amt:'||l_nsl_nc_sub_amt);
361: END IF;
362:
363: END IF; --End of table parameter check
356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_loan_amt:'||l_yr_loan_amt);
358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_subs_amt:'||l_yr_subs_amt);
359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_ln_amt:'||l_nsl_nc_ln_amt);
360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_nsl_nc_sub_amt:'||l_nsl_nc_sub_amt);
361: END IF;
362:
363: END IF; --End of table parameter check
364:
367: -- here the unsub aggregate and subsidized amounts are calculated to be used ahead.
368: l_aggr_unsb_total := l_aggr_loan_amt - l_aggr_subs_amt;
369: l_anul_unsub_total := l_yr_loan_amt - l_yr_subs_amt;
370:
371: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_loan_amt:'||l_aggr_loan_amt);
373: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_subs_amt:'||l_aggr_subs_amt);
374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_unsb_total:'||l_aggr_unsb_total);
375: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_anul_unsub_total:'||l_anul_unsub_total);
368: l_aggr_unsb_total := l_aggr_loan_amt - l_aggr_subs_amt;
369: l_anul_unsub_total := l_yr_loan_amt - l_yr_subs_amt;
370:
371: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_loan_amt:'||l_aggr_loan_amt);
373: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_subs_amt:'||l_aggr_subs_amt);
374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_unsb_total:'||l_aggr_unsb_total);
375: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_anul_unsub_total:'||l_anul_unsub_total);
376: END IF;
369: l_anul_unsub_total := l_yr_loan_amt - l_yr_subs_amt;
370:
371: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_loan_amt:'||l_aggr_loan_amt);
373: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_subs_amt:'||l_aggr_subs_amt);
374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_unsb_total:'||l_aggr_unsb_total);
375: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_anul_unsub_total:'||l_anul_unsub_total);
376: END IF;
377:
370:
371: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_loan_amt:'||l_aggr_loan_amt);
373: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_subs_amt:'||l_aggr_subs_amt);
374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_unsb_total:'||l_aggr_unsb_total);
375: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_anul_unsub_total:'||l_anul_unsub_total);
376: END IF;
377:
378: /* Added by svuppala as part of bug: 3416936 */
371: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_loan_amt:'||l_aggr_loan_amt);
373: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_subs_amt:'||l_aggr_subs_amt);
374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_unsb_total:'||l_aggr_unsb_total);
375: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_anul_unsub_total:'||l_anul_unsub_total);
376: END IF;
377:
378: /* Added by svuppala as part of bug: 3416936 */
379: IF (l_fabase_det.adnl_unsub_loan_elig_flag ='Y' AND l_get_status.dependency_status ='D') THEN
401:
402: IF (fund_type IN ('DLP','DLS','DLU') AND c_loan_limit_dl%FOUND)
403: OR (fund_type IN ('FLP','FLS','FLU','ALT') AND c_loan_limit_ffelp%FOUND) THEN
404:
405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Stafford loan limits(as in setup) for fund '||fund_type||':');
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_aggr_lt:'||l_loan_limit.tot_aggr_lt);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_annual_lt:'||l_loan_limit.tot_annual_lt);
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_aggr_lt:'||l_loan_limit.subs_aggr_lt);
402: IF (fund_type IN ('DLP','DLS','DLU') AND c_loan_limit_dl%FOUND)
403: OR (fund_type IN ('FLP','FLS','FLU','ALT') AND c_loan_limit_ffelp%FOUND) THEN
404:
405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Stafford loan limits(as in setup) for fund '||fund_type||':');
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_aggr_lt:'||l_loan_limit.tot_aggr_lt);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_annual_lt:'||l_loan_limit.tot_annual_lt);
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_aggr_lt:'||l_loan_limit.subs_aggr_lt);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_annual_lt:'||l_loan_limit.subs_annual_lt);
403: OR (fund_type IN ('FLP','FLS','FLU','ALT') AND c_loan_limit_ffelp%FOUND) THEN
404:
405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Stafford loan limits(as in setup) for fund '||fund_type||':');
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_aggr_lt:'||l_loan_limit.tot_aggr_lt);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_annual_lt:'||l_loan_limit.tot_annual_lt);
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_aggr_lt:'||l_loan_limit.subs_aggr_lt);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_annual_lt:'||l_loan_limit.subs_annual_lt);
411: END IF;
404:
405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Stafford loan limits(as in setup) for fund '||fund_type||':');
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_aggr_lt:'||l_loan_limit.tot_aggr_lt);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_annual_lt:'||l_loan_limit.tot_annual_lt);
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_aggr_lt:'||l_loan_limit.subs_aggr_lt);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_annual_lt:'||l_loan_limit.subs_annual_lt);
411: END IF;
412:
405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Stafford loan limits(as in setup) for fund '||fund_type||':');
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_aggr_lt:'||l_loan_limit.tot_aggr_lt);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_annual_lt:'||l_loan_limit.tot_annual_lt);
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_aggr_lt:'||l_loan_limit.subs_aggr_lt);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_annual_lt:'||l_loan_limit.subs_annual_lt);
411: END IF;
412:
413: -- Subs+Unsubs Aggr limit check
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Stafford loan limits(as in setup) for fund '||fund_type||':');
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_aggr_lt:'||l_loan_limit.tot_aggr_lt);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.tot_annual_lt:'||l_loan_limit.tot_annual_lt);
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_aggr_lt:'||l_loan_limit.subs_aggr_lt);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_loan_limit.subs_annual_lt:'||l_loan_limit.subs_annual_lt);
411: END IF;
412:
413: -- Subs+Unsubs Aggr limit check
414: /* Check if loan is within aggregate loan limits and adjust the amount accordingly */
413: -- Subs+Unsubs Aggr limit check
414: /* Check if loan is within aggregate loan limits and adjust the amount accordingly */
415: IF p_chk_aggr_limit = 'Y' THEN
416:
417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check - START');
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr already received by student= ' ||NVL(l_aggr_loan_amt,0));
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Aggr(as in setup)= ' ||NVL(l_loan_limit.tot_aggr_lt,0));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
414: /* Check if loan is within aggregate loan limits and adjust the amount accordingly */
415: IF p_chk_aggr_limit = 'Y' THEN
416:
417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check - START');
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr already received by student= ' ||NVL(l_aggr_loan_amt,0));
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Aggr(as in setup)= ' ||NVL(l_loan_limit.tot_aggr_lt,0));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
422: END IF;
415: IF p_chk_aggr_limit = 'Y' THEN
416:
417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check - START');
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr already received by student= ' ||NVL(l_aggr_loan_amt,0));
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Aggr(as in setup)= ' ||NVL(l_loan_limit.tot_aggr_lt,0));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
422: END IF;
423:
416:
417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check - START');
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr already received by student= ' ||NVL(l_aggr_loan_amt,0));
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Aggr(as in setup)= ' ||NVL(l_loan_limit.tot_aggr_lt,0));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
422: END IF;
423:
424: IF (( NVL(l_aggr_loan_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.tot_aggr_lt,0) ) THEN
417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check - START');
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr already received by student= ' ||NVL(l_aggr_loan_amt,0));
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Aggr(as in setup)= ' ||NVL(l_loan_limit.tot_aggr_lt,0));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
422: END IF;
423:
424: IF (( NVL(l_aggr_loan_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.tot_aggr_lt,0) ) THEN
425: l_aid := NVL(l_loan_limit.tot_aggr_lt,0) - NVL(l_aggr_loan_amt,0);
424: IF (( NVL(l_aggr_loan_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.tot_aggr_lt,0) ) THEN
425: l_aid := NVL(l_loan_limit.tot_aggr_lt,0) - NVL(l_aggr_loan_amt,0);
426: END IF;
427:
428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Aggr l_aid(after adjustment): '||l_aid );
430: END IF;
431:
432: -- if the l_aid is less than 0 it means that already the limits have been exhausted so just set the
425: l_aid := NVL(l_loan_limit.tot_aggr_lt,0) - NVL(l_aggr_loan_amt,0);
426: END IF;
427:
428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Aggr l_aid(after adjustment): '||l_aid );
430: END IF;
431:
432: -- if the l_aid is less than 0 it means that already the limits have been exhausted so just set the
433: -- appropriate the message and return.
439: IF c_loan_limit_ffelp%ISOPEN THEN
440: CLOSE c_loan_limit_ffelp;
441: END IF;
442:
443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check FAILED with IGF_AW_AGGR_LMT_ERR');
445: END IF;
446:
447: RETURN;
440: CLOSE c_loan_limit_ffelp;
441: END IF;
442:
443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check FAILED with IGF_AW_AGGR_LMT_ERR');
445: END IF;
446:
447: RETURN;
448: END IF;
446:
447: RETURN;
448: END IF;
449:
450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check PASSED');
452: END IF;
453: END IF; -- <
454:
447: RETURN;
448: END IF;
449:
450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Aggr limit check PASSED');
452: END IF;
453: END IF; -- <
454:
455: -- Subs+Unsubs Annual limit check
453: END IF; -- <
454:
455: -- Subs+Unsubs Annual limit check
456: /* Check if loan is within annual loan limits and adjust the amount accordingly*/
457: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check - START');
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual already received by student= ' ||NVL(l_yr_loan_amt,0));
460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Annual(as in setup)= ' ||NVL(l_loan_limit.tot_annual_lt,0));
461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
454:
455: -- Subs+Unsubs Annual limit check
456: /* Check if loan is within annual loan limits and adjust the amount accordingly*/
457: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check - START');
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual already received by student= ' ||NVL(l_yr_loan_amt,0));
460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Annual(as in setup)= ' ||NVL(l_loan_limit.tot_annual_lt,0));
461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
462: END IF;
455: -- Subs+Unsubs Annual limit check
456: /* Check if loan is within annual loan limits and adjust the amount accordingly*/
457: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check - START');
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual already received by student= ' ||NVL(l_yr_loan_amt,0));
460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Annual(as in setup)= ' ||NVL(l_loan_limit.tot_annual_lt,0));
461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
462: END IF;
463:
456: /* Check if loan is within annual loan limits and adjust the amount accordingly*/
457: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check - START');
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual already received by student= ' ||NVL(l_yr_loan_amt,0));
460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Annual(as in setup)= ' ||NVL(l_loan_limit.tot_annual_lt,0));
461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
462: END IF;
463:
464: IF (( NVL(l_yr_loan_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.tot_annual_lt,0) ) THEN
457: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check - START');
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual already received by student= ' ||NVL(l_yr_loan_amt,0));
460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Total Annual(as in setup)= ' ||NVL(l_loan_limit.tot_annual_lt,0));
461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
462: END IF;
463:
464: IF (( NVL(l_yr_loan_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.tot_annual_lt,0) ) THEN
465: l_aid := NVL(l_loan_limit.tot_annual_lt,0) - NVL(l_yr_loan_amt,0);
464: IF (( NVL(l_yr_loan_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.tot_annual_lt,0) ) THEN
465: l_aid := NVL(l_loan_limit.tot_annual_lt,0) - NVL(l_yr_loan_amt,0);
466: END IF;
467:
468: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Annual l_aid(after adjustment) : '||l_aid );
470: END IF;
471:
472: IF l_aid < 0 THEN
465: l_aid := NVL(l_loan_limit.tot_annual_lt,0) - NVL(l_yr_loan_amt,0);
466: END IF;
467:
468: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
469: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Annual l_aid(after adjustment) : '||l_aid );
470: END IF;
471:
472: IF l_aid < 0 THEN
473: p_msg_name := 'IGF_AW_ANNUAL_LMT_ERR';
479: IF c_loan_limit_ffelp%ISOPEN THEN
480: CLOSE c_loan_limit_ffelp;
481: END IF;
482:
483: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
484: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check FAILED with IGF_AW_ANNUAL_LMT_ERR');
485: END IF;
486:
487: RETURN;
480: CLOSE c_loan_limit_ffelp;
481: END IF;
482:
483: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
484: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check FAILED with IGF_AW_ANNUAL_LMT_ERR');
485: END IF;
486:
487: RETURN;
488: END IF;
486:
487: RETURN;
488: END IF;
489:
490: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check PASSED');
492: END IF;
493:
494: /* Check if loan is a subsidized loan and then check whether annual and aggregate
487: RETURN;
488: END IF;
489:
490: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Total Annual limit check PASSED');
492: END IF;
493:
494: /* Check if loan is a subsidized loan and then check whether annual and aggregate
495: subisidzed loan limits are met for the student and adjust the aid accordingly */
495: subisidzed loan limits are met for the student and adjust the aid accordingly */
496: IF fund_type IN('DLS','FLS') THEN
497: -- Subsidized Aggr limit check
498: IF p_chk_aggr_limit = 'Y' THEN
499: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
500: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check - START');
501: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr already received by student= ' ||NVL(l_aggr_subs_amt,0));
502: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Aggr (as in setup)= ' ||NVL(l_loan_limit.subs_aggr_lt,0));
503: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
496: IF fund_type IN('DLS','FLS') THEN
497: -- Subsidized Aggr limit check
498: IF p_chk_aggr_limit = 'Y' THEN
499: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
500: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check - START');
501: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr already received by student= ' ||NVL(l_aggr_subs_amt,0));
502: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Aggr (as in setup)= ' ||NVL(l_loan_limit.subs_aggr_lt,0));
503: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
504: END IF;
497: -- Subsidized Aggr limit check
498: IF p_chk_aggr_limit = 'Y' THEN
499: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
500: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check - START');
501: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr already received by student= ' ||NVL(l_aggr_subs_amt,0));
502: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Aggr (as in setup)= ' ||NVL(l_loan_limit.subs_aggr_lt,0));
503: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
504: END IF;
505:
498: IF p_chk_aggr_limit = 'Y' THEN
499: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
500: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check - START');
501: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr already received by student= ' ||NVL(l_aggr_subs_amt,0));
502: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Aggr (as in setup)= ' ||NVL(l_loan_limit.subs_aggr_lt,0));
503: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
504: END IF;
505:
506: IF (( NVL(l_aggr_subs_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.subs_aggr_lt,0)) THEN
499: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
500: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check - START');
501: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr already received by student= ' ||NVL(l_aggr_subs_amt,0));
502: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Aggr (as in setup)= ' ||NVL(l_loan_limit.subs_aggr_lt,0));
503: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
504: END IF;
505:
506: IF (( NVL(l_aggr_subs_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.subs_aggr_lt,0)) THEN
507:
504: END IF;
505:
506: IF (( NVL(l_aggr_subs_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.subs_aggr_lt,0)) THEN
507:
508: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
509: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_subs_amt + aid > l_loan_limit.subs_aggr_lt');
510: END IF;
511:
512: l_aid := NVL(l_loan_limit.subs_aggr_lt,0) - NVL(l_aggr_subs_amt,0);
505:
506: IF (( NVL(l_aggr_subs_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.subs_aggr_lt,0)) THEN
507:
508: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
509: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aggr_subs_amt + aid > l_loan_limit.subs_aggr_lt');
510: END IF;
511:
512: l_aid := NVL(l_loan_limit.subs_aggr_lt,0) - NVL(l_aggr_subs_amt,0);
513: END IF;
511:
512: l_aid := NVL(l_loan_limit.subs_aggr_lt,0) - NVL(l_aggr_subs_amt,0);
513: END IF;
514:
515: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
516: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr l_aid(after adjustment) : '||l_aid );
517: END IF;
518:
519: IF l_aid < 0 THEN
512: l_aid := NVL(l_loan_limit.subs_aggr_lt,0) - NVL(l_aggr_subs_amt,0);
513: END IF;
514:
515: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
516: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr l_aid(after adjustment) : '||l_aid );
517: END IF;
518:
519: IF l_aid < 0 THEN
520: p_msg_name := 'IGF_AW_SUB_AGGR_LMT_ERR';
524: IF c_loan_limit_ffelp%ISOPEN THEN
525: CLOSE c_loan_limit_ffelp;
526: END IF;
527:
528: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
529: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check FAILED with IGF_AW_SUB_AGGR_LMT_ERR');
530: END IF;
531:
532: RETURN;
525: CLOSE c_loan_limit_ffelp;
526: END IF;
527:
528: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
529: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check FAILED with IGF_AW_SUB_AGGR_LMT_ERR');
530: END IF;
531:
532: RETURN;
533: END IF;
531:
532: RETURN;
533: END IF;
534:
535: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
536: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check PASSED');
537: END IF;
538: END IF; -- <
539:
532: RETURN;
533: END IF;
534:
535: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
536: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Aggr limit check PASSED');
537: END IF;
538: END IF; -- <
539:
540: -- Subsidized Annual limit check
537: END IF;
538: END IF; -- <
539:
540: -- Subsidized Annual limit check
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check - START');
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual already received by student= ' ||NVL(l_yr_subs_amt,0));
544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Annual (as in setup)= ' ||NVL(l_loan_limit.subs_annual_lt,0));
545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
538: END IF; -- <
539:
540: -- Subsidized Annual limit check
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check - START');
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual already received by student= ' ||NVL(l_yr_subs_amt,0));
544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Annual (as in setup)= ' ||NVL(l_loan_limit.subs_annual_lt,0));
545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
546: END IF;
539:
540: -- Subsidized Annual limit check
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check - START');
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual already received by student= ' ||NVL(l_yr_subs_amt,0));
544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Annual (as in setup)= ' ||NVL(l_loan_limit.subs_annual_lt,0));
545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
546: END IF;
547:
540: -- Subsidized Annual limit check
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check - START');
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual already received by student= ' ||NVL(l_yr_subs_amt,0));
544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Annual (as in setup)= ' ||NVL(l_loan_limit.subs_annual_lt,0));
545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
546: END IF;
547:
548: IF (( NVL(l_yr_subs_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.subs_annual_lt,0)) THEN
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check - START');
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual already received by student= ' ||NVL(l_yr_subs_amt,0));
544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Permissible Subs Annual (as in setup)= ' ||NVL(l_loan_limit.subs_annual_lt,0));
545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid(current loan amt)= ' ||NVL(l_aid,0));
546: END IF;
547:
548: IF (( NVL(l_yr_subs_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.subs_annual_lt,0)) THEN
549:
546: END IF;
547:
548: IF (( NVL(l_yr_subs_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.subs_annual_lt,0)) THEN
549:
550: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_subs_amt + aid > l_loan_limit.subs_annual_lt');
552: END IF;
553:
554: l_aid := NVL(l_loan_limit.subs_annual_lt,0) - NVL(l_yr_subs_amt,0);
547:
548: IF (( NVL(l_yr_subs_amt,0) + NVL(l_aid,0)) > NVL(l_loan_limit.subs_annual_lt,0)) THEN
549:
550: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_yr_subs_amt + aid > l_loan_limit.subs_annual_lt');
552: END IF;
553:
554: l_aid := NVL(l_loan_limit.subs_annual_lt,0) - NVL(l_yr_subs_amt,0);
555: END IF;
553:
554: l_aid := NVL(l_loan_limit.subs_annual_lt,0) - NVL(l_yr_subs_amt,0);
555: END IF;
556:
557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual l_aid(after adjustment) : '||l_aid );
559: END IF;
560:
561: IF l_aid < 0 THEN
554: l_aid := NVL(l_loan_limit.subs_annual_lt,0) - NVL(l_yr_subs_amt,0);
555: END IF;
556:
557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual l_aid(after adjustment) : '||l_aid );
559: END IF;
560:
561: IF l_aid < 0 THEN
562: p_msg_name := 'IGF_AW_SUB_LMT_ERR';
566: IF c_loan_limit_ffelp%ISOPEN THEN
567: CLOSE c_loan_limit_ffelp;
568: END IF;
569:
570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check FAILED with IGF_AW_SUB_LMT_ERR');
572: END IF;
573:
574: RETURN;
567: CLOSE c_loan_limit_ffelp;
568: END IF;
569:
570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check FAILED with IGF_AW_SUB_LMT_ERR');
572: END IF;
573:
574: RETURN;
575: END IF;
573:
574: RETURN;
575: END IF;
576:
577: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
578: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check PASSED');
579: END IF;
580: END IF; -- << fund_type IN('DLS','FLS') >>
581:
574: RETURN;
575: END IF;
576:
577: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
578: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check PASSED');
579: END IF;
580: END IF; -- << fund_type IN('DLS','FLS') >>
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
578: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Subs Annual limit check PASSED');
579: END IF;
580: END IF; -- << fund_type IN('DLS','FLS') >>
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid:'||l_aid);
584: END IF;
585:
586: ELSIF (fund_type IN ('DLP','DLS','DLU') AND c_loan_limit_dl%NOTFOUND)
579: END IF;
580: END IF; -- << fund_type IN('DLS','FLS') >>
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','l_aid:'||l_aid);
584: END IF;
585:
586: ELSIF (fund_type IN ('DLP','DLS','DLU') AND c_loan_limit_dl%NOTFOUND)
587: OR (fund_type IN ('FLP','FLS','FLU','ALT') AND c_loan_limit_ffelp%NOTFOUND) THEN
587: OR (fund_type IN ('FLP','FLS','FLU','ALT') AND c_loan_limit_ffelp%NOTFOUND) THEN
588: p_msg_name := 'IGF_AW_LOAN_LMT_NOT_FND';
589: l_aid := 0;
590:
591: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Stafford loan limits not defined, msg is IGF_AW_LOAN_LMT_NOT_FND');
593: END IF;
594: END IF;
595:
588: p_msg_name := 'IGF_AW_LOAN_LMT_NOT_FND';
589: l_aid := 0;
590:
591: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.check_loan_limits.debug','Stafford loan limits not defined, msg is IGF_AW_LOAN_LMT_NOT_FND');
593: END IF;
594: END IF;
595:
596: IF c_loan_limit_dl%ISOPEN THEN
741: IF l_isir_id.primary_efc = 0 AND NVL(l_isir_id.auto_zero_efc,'*') = 'Y' THEN
742: l_efc_f := 0;
743: l_pell_efc := 0;
744: l_efc_ay := 0;
745: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
746: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_fed_efc.debug','since auto_zero_efc=Y, returning zero');
747: END IF;
748: RETURN;
749: END IF;
742: l_efc_f := 0;
743: l_pell_efc := 0;
744: l_efc_ay := 0;
745: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
746: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_fed_efc.debug','since auto_zero_efc=Y, returning zero');
747: END IF;
748: RETURN;
749: END IF;
750:
787: ELSE
788: l_efc_f := NULL;
789: END IF;
790:
791: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
792: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_fed_efc.debug','l_efc_f: '||l_efc_f||' l_pell_efc: '||l_pell_efc);
793: END IF;
794:
795: EXCEPTION
788: l_efc_f := NULL;
789: END IF;
790:
791: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
792: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_fed_efc.debug','l_efc_f: '||l_efc_f||' l_pell_efc: '||l_pell_efc);
793: END IF;
794:
795: EXCEPTION
796: WHEN OTHERS THEN
1036: BEGIN
1037:
1038: -- Call generic API get_key_program to get the cource code
1039: igf_ap_gen_001.get_key_program(p_base_id,l_course_cd,l_ver_number);
1040: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1041: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1042: 'key_program_course_cd:'||l_course_cd||'key_program_version_number'||l_ver_number);
1043: END IF;
1044: igs_en_gen_015.get_academic_cal( p_person_id,l_course_cd,l_acad_cal_type,l_acad_seq_num,l_message);
1037:
1038: -- Call generic API get_key_program to get the cource code
1039: igf_ap_gen_001.get_key_program(p_base_id,l_course_cd,l_ver_number);
1040: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1041: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1042: 'key_program_course_cd:'||l_course_cd||'key_program_version_number'||l_ver_number);
1043: END IF;
1044: igs_en_gen_015.get_academic_cal( p_person_id,l_course_cd,l_acad_cal_type,l_acad_seq_num,l_message);
1045: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1041: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1042: 'key_program_course_cd:'||l_course_cd||'key_program_version_number'||l_ver_number);
1043: END IF;
1044: igs_en_gen_015.get_academic_cal( p_person_id,l_course_cd,l_acad_cal_type,l_acad_seq_num,l_message);
1045: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1046: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1047: 'l_acad_cal_type:'||l_acad_cal_type||'l_acad_seq_num'||l_acad_seq_num||'l_message'||l_message);
1048: END IF;
1049:
1042: 'key_program_course_cd:'||l_course_cd||'key_program_version_number'||l_ver_number);
1043: END IF;
1044: igs_en_gen_015.get_academic_cal( p_person_id,l_course_cd,l_acad_cal_type,l_acad_seq_num,l_message);
1045: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1046: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1047: 'l_acad_cal_type:'||l_acad_cal_type||'l_acad_seq_num'||l_acad_seq_num||'l_message'||l_message);
1048: END IF;
1049:
1050:
1091: -- Predictive Class Standing
1092: l_pred_flag := 'Y';
1093:
1094: -- Log message
1095: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1096: fnd_log.string(fnd_log.level_statement,
1097: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1098: 'Computing PREDICTIVE class standing for date ' || TO_CHAR(l_ear_term_start_date, 'DD-MON-YYYY'));
1099: END IF;
1092: l_pred_flag := 'Y';
1093:
1094: -- Log message
1095: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1096: fnd_log.string(fnd_log.level_statement,
1097: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1098: 'Computing PREDICTIVE class standing for date ' || TO_CHAR(l_ear_term_start_date, 'DD-MON-YYYY'));
1099: END IF;
1100: ELSE
1101: -- Actual Class Standing
1102: l_pred_flag := 'N';
1103:
1104: -- Log message
1105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1106: fnd_log.string(fnd_log.level_statement,
1107: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1108: 'Computing ACTUAL class standing for date ' || TO_CHAR(l_ear_term_start_date, 'DD-MON-YYYY'));
1109: END IF;
1102: l_pred_flag := 'N';
1103:
1104: -- Log message
1105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1106: fnd_log.string(fnd_log.level_statement,
1107: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1108: 'Computing ACTUAL class standing for date ' || TO_CHAR(l_ear_term_start_date, 'DD-MON-YYYY'));
1109: END IF;
1110: END IF;
1119: p_load_ci_sequence_number => NULL
1120: );
1121:
1122: -- Log message
1123: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1124: fnd_log.string(fnd_log.level_statement,
1125: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1126: 'Class Standing= ' || l_class_standing);
1127: END IF;
1120: );
1121:
1122: -- Log message
1123: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1124: fnd_log.string(fnd_log.level_statement,
1125: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1126: 'Class Standing= ' || l_class_standing);
1127: END IF;
1128: ELSIF p_award_id IS NOT NULL THEN
1134: CLOSE c_get_ear_term_st_date_awd;
1135:
1136: IF l_ear_term_start_date IS NOT NULL AND l_ear_term_start_date > TRUNC(SYSDATE) THEN
1137: l_pred_flag := 'Y';
1138: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1139: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug','computing predictive class standing for'||TO_CHAR(l_ear_term_start_date));
1140: END IF;
1141: ELSE
1142: l_pred_flag := 'N';
1135:
1136: IF l_ear_term_start_date IS NOT NULL AND l_ear_term_start_date > TRUNC(SYSDATE) THEN
1137: l_pred_flag := 'Y';
1138: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1139: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug','computing predictive class standing for'||TO_CHAR(l_ear_term_start_date));
1140: END IF;
1141: ELSE
1142: l_pred_flag := 'N';
1143: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1139: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug','computing predictive class standing for'||TO_CHAR(l_ear_term_start_date));
1140: END IF;
1141: ELSE
1142: l_pred_flag := 'N';
1143: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1144: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug','computing actual class standing for'||TO_CHAR(l_ear_term_start_date));
1145: END IF;
1146: END IF;
1147:
1140: END IF;
1141: ELSE
1142: l_pred_flag := 'N';
1143: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1144: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug','computing actual class standing for'||TO_CHAR(l_ear_term_start_date));
1145: END IF;
1146: END IF;
1147:
1148: -- Get Class Standing
1186: -- Found anticipated Prog type
1187: p_course_type := l_get_ant_prog_type_rec.prog_type;
1188:
1189: -- Log message
1190: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1191: fnd_log.string(fnd_log.level_statement,
1192: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1193: 'Actual Prog type not available, but found anticipated Prog type.');
1194: fnd_log.string(fnd_log.level_statement,
1187: p_course_type := l_get_ant_prog_type_rec.prog_type;
1188:
1189: -- Log message
1190: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1191: fnd_log.string(fnd_log.level_statement,
1192: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1193: 'Actual Prog type not available, but found anticipated Prog type.');
1194: fnd_log.string(fnd_log.level_statement,
1195: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1190: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1191: fnd_log.string(fnd_log.level_statement,
1192: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1193: 'Actual Prog type not available, but found anticipated Prog type.');
1194: fnd_log.string(fnd_log.level_statement,
1195: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1196: 'Base Id: ' ||NVL(p_base_id,'')|| '. Anticipated Prog type=' ||p_course_type|| ', Term cal type=' ||l_get_ant_prog_type_rec.load_cal_type|| ', Term sequence number=' ||l_get_ant_prog_type_rec.load_seq_num);
1197: END IF;
1198: ELSE
1200: -- any of the terms in the awarding period.
1201: p_course_type := NULL;
1202:
1203: -- Log message
1204: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1205: fnd_log.string(fnd_log.level_statement,
1206: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1207: 'Both actual and anticipated Prog type is not available for - ' ||'Base Id: ' ||NVL(p_base_id,'')|| ' for any of the terms in the awarding period: ' ||p_awd_period);
1208: END IF;
1201: p_course_type := NULL;
1202:
1203: -- Log message
1204: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1205: fnd_log.string(fnd_log.level_statement,
1206: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1207: 'Both actual and anticipated Prog type is not available for - ' ||'Base Id: ' ||NVL(p_base_id,'')|| ' for any of the terms in the awarding period: ' ||p_awd_period);
1208: END IF;
1209: END IF; -- End (c_get_ant_prog_type%FOUND)
1235: -- Found anticipated Class Standing
1236: l_class_standing := l_get_ant_class_stnd_rec.class_standing;
1237:
1238: -- Log message
1239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1240: fnd_log.string(fnd_log.level_statement,
1241: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1242: 'Actual class standing data not available, but found anticipated class standing.');
1243: fnd_log.string(fnd_log.level_statement,
1236: l_class_standing := l_get_ant_class_stnd_rec.class_standing;
1237:
1238: -- Log message
1239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1240: fnd_log.string(fnd_log.level_statement,
1241: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1242: 'Actual class standing data not available, but found anticipated class standing.');
1243: fnd_log.string(fnd_log.level_statement,
1244: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1240: fnd_log.string(fnd_log.level_statement,
1241: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1242: 'Actual class standing data not available, but found anticipated class standing.');
1243: fnd_log.string(fnd_log.level_statement,
1244: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1245: 'Base Id: ' ||NVL(p_base_id,'')|| '. Anticipated class standing =' ||l_class_standing|| ', Term cal type=' ||l_get_ant_class_stnd_rec.load_cal_type|| ', Term sequence number=' ||l_get_ant_class_stnd_rec.load_seq_num);
1246: END IF;
1247:
1254: -- awarding period.
1255: l_class_standing := NULL;
1256:
1257: -- Log message
1258: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1259: fnd_log.string(fnd_log.level_statement,
1260: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1261: 'Both actual and anticipated class standing is not available for - ' ||'Base Id: ' ||NVL(p_base_id,'')|| ' for any of the terms in the awarding period: ' ||p_awd_period);
1262: END IF;
1255: l_class_standing := NULL;
1256:
1257: -- Log message
1258: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1259: fnd_log.string(fnd_log.level_statement,
1260: 'igf.plsql.igf_aw_packng_subfns.get_class_stnd.debug',
1261: 'Both actual and anticipated class standing is not available for - ' ||'Base Id: ' ||NVL(p_base_id,'')|| ' for any of the terms in the awarding period: ' ||p_awd_period);
1262: END IF;
1263: END IF; -- End of (l_class_standing IS NULL) AND (igf_aw_coa_gen.canUseAnticipVal) AND (p_called_from = 'PACKAGING')