eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_PACKAGING dependencies on IGF_AW_GEN

Line 412: IF NOT igf_aw_gen_003.check_coa(p_base_id,p_awd_prd_code) THEN

408: l_tot_teach_prds NUMBER;
409: l_tot_terms NUMBER;
410:
411: BEGIN
412: IF NOT igf_aw_gen_003.check_coa(p_base_id,p_awd_prd_code) THEN
413: OPEN c_term_wcoa(p_adplans_id,p_awd_prd_code);
414: FETCH c_term_wcoa INTO l_tot_teach_prds,l_tot_terms;
415: CLOSE c_term_wcoa;
416: ELSE

Line 969: igf_aw_gen.check_ld_cal_tps(p_adplans_id,p_result);

965: p_result := 'IGF_AW_DIST_CODE_FAIL';
966: CLOSE cur_get_plan_cd;
967: ELSE
968: CLOSE cur_get_plan_cd;
969: igf_aw_gen.check_ld_cal_tps(p_adplans_id,p_result);
970: IF p_result = 'TRUE' THEN
971: p_method_code := l_get_plan_cd.dist_plan_method_code;
972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.check_plan.debug '|| g_req_id,'p_method_code:'||p_method_code);

Line 2530: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );

2526: fnd_file.put_line(fnd_file.output,' ' );
2527: fnd_message.set_name('IGF','IGF_AW_AWD_DTLS');
2528: fnd_file.put_line(fnd_file.output,RPAD('-',10,'-') ||' '|| RPAD(fnd_message.get,20) ||' '|| RPAD('-',10,'-'));
2529:
2530: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
2531: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
2532: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
2533: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
2534: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);

Line 2531: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );

2527: fnd_message.set_name('IGF','IGF_AW_AWD_DTLS');
2528: fnd_file.put_line(fnd_file.output,RPAD('-',10,'-') ||' '|| RPAD(fnd_message.get,20) ||' '|| RPAD('-',10,'-'));
2529:
2530: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
2531: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
2532: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
2533: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
2534: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
2535: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);

Line 2532: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);

2528: fnd_file.put_line(fnd_file.output,RPAD('-',10,'-') ||' '|| RPAD(fnd_message.get,20) ||' '|| RPAD('-',10,'-'));
2529:
2530: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
2531: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
2532: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
2533: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
2534: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
2535: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);
2536: fnd_file.put_line(fnd_file.output,' ' );

Line 2533: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );

2529:
2530: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
2531: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
2532: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
2533: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
2534: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
2535: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);
2536: fnd_file.put_line(fnd_file.output,' ' );
2537:

Line 2534: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);

2530: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
2531: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
2532: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
2533: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
2534: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
2535: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);
2536: fnd_file.put_line(fnd_file.output,' ' );
2537:
2538: l_fee1 := NULL;

Line 2535: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);

2531: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
2532: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
2533: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
2534: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
2535: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);
2536: fnd_file.put_line(fnd_file.output,' ' );
2537:
2538: l_fee1 := NULL;
2539: l_fee2 := NULL;

Line 3218: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );

3214: fnd_file.put_line(fnd_file.output,' ' );
3215: fnd_message.set_name('IGF','IGF_AW_AWD_DTLS');
3216: fnd_file.put_line(fnd_file.output,RPAD('-',10,'-') ||' '|| RPAD(fnd_message.get,20) ||' '|| RPAD('-',10,'-'));
3217:
3218: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
3219: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
3220: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
3221: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
3222: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);

Line 3219: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );

3215: fnd_message.set_name('IGF','IGF_AW_AWD_DTLS');
3216: fnd_file.put_line(fnd_file.output,RPAD('-',10,'-') ||' '|| RPAD(fnd_message.get,20) ||' '|| RPAD('-',10,'-'));
3217:
3218: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
3219: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
3220: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
3221: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
3222: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
3223: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);

Line 3220: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);

3216: fnd_file.put_line(fnd_file.output,RPAD('-',10,'-') ||' '|| RPAD(fnd_message.get,20) ||' '|| RPAD('-',10,'-'));
3217:
3218: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
3219: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
3220: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
3221: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
3222: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
3223: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);
3224: fnd_file.put_line(fnd_file.output,' ' );

Line 3221: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );

3217:
3218: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
3219: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
3220: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
3221: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
3222: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
3223: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);
3224: fnd_file.put_line(fnd_file.output,' ' );
3225:

Line 3222: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);

3218: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'PERSON_NUMBER'), 40, ' ') || ' : ' || l_person_number.person_number );
3219: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
3220: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
3221: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
3222: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
3223: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);
3224: fnd_file.put_line(fnd_file.output,' ' );
3225:
3226: l_fee1 := NULL;

Line 3223: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);

3219: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'SSN'), 40, ' ') || ' : ' || l_person_number.ssn );
3220: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'FUND_CODE'), 40, ' ') || ' : ' || l_fmast.fund_code);
3221: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG', 'OFFERED_AMT'), 40, ' ') || ' : ' || TO_CHAR(l_awd_tot.offered_amt * ln_com_perct/100) );
3222: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN'), 40, ' ') || ' : ' || lv_method_name);
3223: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD'),40,' ') || ' : ' || lv_method_desc);
3224: fnd_file.put_line(fnd_file.output,' ' );
3225:
3226: l_fee1 := NULL;
3227: l_fee2 := NULL;

Line 3972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Flag set - updating disb num 1 with disb date delayed by NSLDS offset: ' ||l_disb_date1);

3968: FETCH c_disb INTO l_disb;
3969: CLOSE c_disb;
3970:
3971: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Flag set - updating disb num 1 with disb date delayed by NSLDS offset: ' ||l_disb_date1);
3973: END IF;
3974:
3975: igf_aw_awd_disb_pkg.update_row(
3976: x_mode => 'R',

Line 4047: igf_aw_gen.update_fabase_awds( l_base_id, 'SINGLE' );

4043:
4044: -- Update Student FA Base record with the Total Offered Amount, Accepted Amount and the Packaging status
4045: -- Update Notification status if the process is run in Single Fund or Autio Packaged.
4046: IF g_sf_packaging = 'T' THEN
4047: igf_aw_gen.update_fabase_awds( l_base_id, 'SINGLE' );
4048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with SINGLE');
4050: END IF;
4051: lv_update_notif_stat := 'T';

Line 4049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with SINGLE');

4045: -- Update Notification status if the process is run in Single Fund or Autio Packaged.
4046: IF g_sf_packaging = 'T' THEN
4047: igf_aw_gen.update_fabase_awds( l_base_id, 'SINGLE' );
4048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with SINGLE');
4050: END IF;
4051: lv_update_notif_stat := 'T';
4052: ELSIF ( l_post = 'Y' ) THEN
4053: igf_aw_gen.update_fabase_awds( l_base_id, 'SIMULATED' );

Line 4053: igf_aw_gen.update_fabase_awds( l_base_id, 'SIMULATED' );

4049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with SINGLE');
4050: END IF;
4051: lv_update_notif_stat := 'T';
4052: ELSIF ( l_post = 'Y' ) THEN
4053: igf_aw_gen.update_fabase_awds( l_base_id, 'SIMULATED' );
4054: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4055: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with SIMULATED');
4056: END IF;
4057: lv_update_notif_stat := 'F';

Line 4055: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with SIMULATED');

4051: lv_update_notif_stat := 'T';
4052: ELSIF ( l_post = 'Y' ) THEN
4053: igf_aw_gen.update_fabase_awds( l_base_id, 'SIMULATED' );
4054: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4055: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with SIMULATED');
4056: END IF;
4057: lv_update_notif_stat := 'F';
4058: ELSE
4059: igf_aw_gen.update_fabase_awds( l_base_id, 'AUTO_PACKAGED' );

Line 4059: igf_aw_gen.update_fabase_awds( l_base_id, 'AUTO_PACKAGED' );

4055: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with SIMULATED');
4056: END IF;
4057: lv_update_notif_stat := 'F';
4058: ELSE
4059: igf_aw_gen.update_fabase_awds( l_base_id, 'AUTO_PACKAGED' );
4060: lv_update_notif_stat := 'T';
4061: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with AUTO_PACKAGED');
4063: END IF;

Line 4062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with AUTO_PACKAGED');

4058: ELSE
4059: igf_aw_gen.update_fabase_awds( l_base_id, 'AUTO_PACKAGED' );
4060: lv_update_notif_stat := 'T';
4061: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called igf_aw_gen.update_fabase_awds with AUTO_PACKAGED');
4063: END IF;
4064: END IF; -- Notification End
4065:
4066: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 5971: IF igf_aw_gen_005.get_stud_hold_effect( 'A', l_person_id, l_fund_ld.fund_code ) = 'F' THEN

5967:
5968: END IF;
5969:
5970: -- Check whether the fund can be awarded to the Person, if not skip the fund
5971: IF igf_aw_gen_005.get_stud_hold_effect( 'A', l_person_id, l_fund_ld.fund_code ) = 'F' THEN
5972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'after c_remv_funds cursor loop,igf_aw_gen_005.get_stud_hold_effect(A,'||l_person_id||','||l_fund_ld.fund_code||'=F');
5974: END IF;
5975: fnd_message.set_name('IGF','IGF_AW_AWD_FUND_HOLD_FAIL');

Line 5973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'after c_remv_funds cursor loop,igf_aw_gen_005.get_stud_hold_effect(A,'||l_person_id||','||l_fund_ld.fund_code||'=F');

5969:
5970: -- Check whether the fund can be awarded to the Person, if not skip the fund
5971: IF igf_aw_gen_005.get_stud_hold_effect( 'A', l_person_id, l_fund_ld.fund_code ) = 'F' THEN
5972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'after c_remv_funds cursor loop,igf_aw_gen_005.get_stud_hold_effect(A,'||l_person_id||','||l_fund_ld.fund_code||'=F');
5974: END IF;
5975: fnd_message.set_name('IGF','IGF_AW_AWD_FUND_HOLD_FAIL');
5976: fnd_message.set_token('FUND',l_fund_ld.fund_code);
5977: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 5987: igf_aw_gen_003.check_common_terms(NVL(l_fund_ld.adplans_id,g_plan_id),l_base_id,l_terms);

5983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.adplans_id: '||l_fund_ld.adplans_id || 'g_plan_id : '||g_plan_id);
5984: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.max_num_disb: '||l_fund_ld.max_num_disb);
5985: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.min_num_disb: '||l_fund_ld.min_num_disb);
5986: END IF;
5987: igf_aw_gen_003.check_common_terms(NVL(l_fund_ld.adplans_id,g_plan_id),l_base_id,l_terms);
5988:
5989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_terms:'||l_terms);
5991: END IF;

Line 6000: IF igf_aw_gen_003.check_coa(l_base_id) = FALSE AND g_sf_packaging = 'T' AND NVL(g_allow_to_exceed,'*') = 'COA' THEN

5996: in single fund packaging, the allow_to_exceed is set to COA,
5997: then load the fund if the distribution plan is not 'Match COA'
5998: else dont load the fund
5999: */
6000: IF igf_aw_gen_003.check_coa(l_base_id) = FALSE AND g_sf_packaging = 'T' AND NVL(g_allow_to_exceed,'*') = 'COA' THEN
6001: --check the distribution type
6002: check_plan(NVL(l_fund_ld.adplans_id,g_plan_id),lv_result,lv_method_code);
6003: IF lv_result = 'TRUE' AND lv_method_code = 'C' THEN
6004: lb_create_funds := FALSE;

Line 7760: IF igf_aw_gen_005.validate_student_efc(l_base_id,g_awd_prd) = 'F' THEN

7756:
7757:
7758: -- Check for the valid EFC of the student. If no valid EFC, show message and stop processing
7759: IF g_sf_packaging <> 'T' THEN
7760: IF igf_aw_gen_005.validate_student_efc(l_base_id,g_awd_prd) = 'F' THEN
7761: fnd_message.set_name('IGF','IGF_AW_NO_VALID_EFC');
7762: fnd_message.set_token('STDNT', l_pers_num );
7763: fnd_file.put_line(fnd_file.log,fnd_message.get);
7764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 7786: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN

7782: END IF;
7783:
7784: --Cbeck if student has valid COA in multiple fund packaging.if not error out
7785:
7786: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN
7787: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');
7788: fnd_file.put_line(fnd_file.log,fnd_message.get);
7789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7790: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'no COA for '||l_person_number.person_number);

Line 7801: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN

7797:
7798: IF g_allow_to_exceed IS NULL THEN
7799: -- If COA Value is not set, then cannot proceed further
7800: -- Log a message and exit from the Job
7801: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN
7802:
7803: --get the plan name for the token
7804: get_plan_desc(g_plan_id,lv_name,lv_desc);
7805:

Line 7817: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN

7813: END IF;
7814:
7815: ELSIF g_allow_to_exceed = 'NEED' THEN
7816:
7817: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN
7818: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');
7819: fnd_file.put_line(fnd_file.log,fnd_message.get);
7820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'no COA for '||l_person_number.person_number ||' and allow_to_exceed=NEED');

Line 7849: IF igf_aw_gen_005.get_stud_hold_effect('A', l_fabase.person_id, NULL ) = 'F' THEN

7845: FETCH c_fabase INTO l_fabase;
7846: EXIT WHEN c_fabase%NOTFOUND;
7847:
7848: -- Check whether are there any package hold are present at the student level, if not continue the packaging
7849: IF igf_aw_gen_005.get_stud_hold_effect('A', l_fabase.person_id, NULL ) = 'F' THEN
7850: fnd_message.set_name('IGF','IGF_AW_AWD_PACK_HOLD_FAIL');
7851: fnd_file.put_line(fnd_file.log,fnd_message.get);
7852: CLOSE c_fabase;
7853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 7854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'igf_aw_gen_005.get_stud_hold_effect(A,'||l_fabase.person_id||',NULL=F');

7850: fnd_message.set_name('IGF','IGF_AW_AWD_PACK_HOLD_FAIL');
7851: fnd_file.put_line(fnd_file.log,fnd_message.get);
7852: CLOSE c_fabase;
7853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'igf_aw_gen_005.get_stud_hold_effect(A,'||l_fabase.person_id||',NULL=F');
7855: END IF;
7856: RETURN;
7857: END IF;
7858:

Line 7945: l_loan_amt := get_perct_amt(l_frml_plcy.max_loan_perct_fact,l_frml_plcy.max_loan_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7941: l_loan_amt := l_frml_plcy.max_loan_amt;
7942: ELSIF l_frml_plcy.max_loan_perct IS NULL THEN
7943: l_loan_amt := 0;
7944: ELSE
7945: l_loan_amt := get_perct_amt(l_frml_plcy.max_loan_perct_fact,l_frml_plcy.max_loan_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7946: END IF;
7947:
7948: -- Calculate the Max Grant Amt ( directly from the grant amt or grom the % defined at the Frml Policy level)
7949: IF l_frml_plcy.max_grant_amt IS NOT NULL THEN

Line 7955: l_grant_amt := get_perct_amt(l_frml_plcy.max_grant_perct_fact,l_frml_plcy.max_grant_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7951:
7952: ELSIF l_frml_plcy.max_grant_perct IS NULL THEN
7953: l_grant_amt := 0;
7954: ELSE
7955: l_grant_amt := get_perct_amt(l_frml_plcy.max_grant_perct_fact,l_frml_plcy.max_grant_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7956: END IF;
7957:
7958: -- Calculate the Max Work Amt ( directly from the work amt or from the % defined at the Frml Policy level)
7959: IF l_frml_plcy.max_work_amt IS NOT NULL THEN

Line 7965: l_work_amt := get_perct_amt(l_frml_plcy.max_work_perct_fact,l_frml_plcy.max_work_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7961:
7962: ELSIF l_frml_plcy.max_work_perct IS NULL THEN
7963: l_work_amt := 0;
7964: ELSE
7965: l_work_amt := get_perct_amt(l_frml_plcy.max_work_perct_fact,l_frml_plcy.max_work_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7966: END IF;
7967:
7968: -- Calculate the Max Self Help Amt
7969: IF l_frml_plcy.max_shelp_amt IS NOT NULL THEN

Line 7975: l_shelp_amt := get_perct_amt(l_frml_plcy.max_shelp_perct_fact,l_frml_plcy.max_shelp_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7971:
7972: ELSIF l_frml_plcy.max_shelp_perct IS NULL THEN
7973: l_shelp_amt := 0;
7974: ELSE
7975: l_shelp_amt := get_perct_amt(l_frml_plcy.max_shelp_perct_fact,l_frml_plcy.max_shelp_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7976: END IF;
7977:
7978: -- Calculate the Max Gift Aid Amt
7979: IF l_frml_plcy.max_gift_amt IS NOT NULL THEN

Line 7985: l_gift_amt := get_perct_amt(l_frml_plcy.max_gift_perct_fact,l_frml_plcy.max_gift_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7981:
7982: ELSIF l_frml_plcy.max_gift_perct IS NULL THEN
7983: l_gift_amt := 0;
7984: ELSE
7985: l_gift_amt := get_perct_amt(l_frml_plcy.max_gift_perct_fact,l_frml_plcy.max_gift_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7986: END IF;
7987:
7988: -- Calculate the Max Scholarship Amt
7989: IF l_frml_plcy.max_schlrshp_amt IS NOT NULL THEN

Line 7995: l_schlp_amt := get_perct_amt(l_frml_plcy.max_schlrshp_perct_fact,l_frml_plcy.max_schlrshp_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7991:
7992: ELSIF l_frml_plcy.max_schlrshp_perct IS NULL THEN
7993: l_schlp_amt := 0;
7994: ELSE
7995: l_schlp_amt := get_perct_amt(l_frml_plcy.max_schlrshp_perct_fact,l_frml_plcy.max_schlrshp_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7996: END IF;
7997:
7998: -- Calculate the Gap Amount
7999: IF l_frml_plcy.max_gap_amt IS NOT NULL THEN

Line 8005: l_gap_amt := get_perct_amt(l_frml_plcy.max_gap_perct_fact,l_frml_plcy.max_gap_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

8001: ELSIF l_frml_plcy.max_gap_perct IS NULL THEN
8002:
8003: l_gap_amt := 0;
8004: ELSE
8005: l_gap_amt := get_perct_amt(l_frml_plcy.max_gap_perct_fact,l_frml_plcy.max_gap_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
8006: END IF;
8007:
8008: -- Get the Max Aid Package
8009: l_max_aid_pkg := l_frml_plcy.max_aid_pkg;

Line 8205: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);

8201:
8202: WHEN NON_MERGABLE_FUNDS THEN
8203: ROLLBACK TO STUD_SP;
8204: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
8205: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);
8206: fnd_file.new_line(fnd_file.log,1);
8207:
8208: WHEN INVALID_DISTR_PLAN THEN
8209: ROLLBACK TO STUD_SP;

Line 8211: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);

8207:
8208: WHEN INVALID_DISTR_PLAN THEN
8209: ROLLBACK TO STUD_SP;
8210: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
8211: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);
8212: fnd_file.new_line(fnd_file.log,1);
8213:
8214: WHEN INV_FWS_AWARD THEN
8215: ROLLBACK TO STUD_SP;

Line 8217: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);

8213:
8214: WHEN INV_FWS_AWARD THEN
8215: ROLLBACK TO STUD_SP;
8216: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
8217: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);
8218: fnd_file.new_line(fnd_file.log,1);
8219:
8220: WHEN PELL_NO_REPACK THEN
8221: ROLLBACK TO STUD_SP;

Line 8223: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);

8219:
8220: WHEN PELL_NO_REPACK THEN
8221: ROLLBACK TO STUD_SP;
8222: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
8223: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);
8224: fnd_file.new_line(fnd_file.log,1);
8225:
8226: WHEN OTHERS THEN
8227: ROLLBACK TO STUD_SP;

Line 8237: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);

8233: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.stud_run.exception '|| g_req_id,'sql error message: '||SQLERRM);
8234: END IF;
8235: igs_ge_msg_stack.conc_exception_hndl;
8236: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
8237: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);
8238: fnd_file.put_line(fnd_file.log,' ');
8239:
8240: -------------------------------------------------------------------------
8241: -- Important : Do not remove these comments

Line 9214: l_efc_i := igf_aw_gen_004.efc_i(l_fabase.base_id,g_awd_prd);

9210: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'c_rem_efc%NOTFOUND');
9211: END IF;
9212:
9213: -- If Awarding PROFILE is present for the student, get the EFC, NEED
9214: l_efc_i := igf_aw_gen_004.efc_i(l_fabase.base_id,g_awd_prd);
9215:
9216: IF l_use_fixed_costs = 'Y' THEN
9217: l_need_i := NVL(l_fabase.coa_fixed,0) - NVL(l_efc_i,0) - NVL(l_gap_amt,0);
9218: ELSE

Line 9355: IF igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN

9351:
9352: --if student has no COA defined and g_allow_to_exceed is set to 'COA' in single_fund_packaging,call the pell wrapper with cp_called_from as 'PACKAGING_DP'
9353: --else call it with 'PACKAGING' as the wrapper needs to take care of the distribution
9354:
9355: IF igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN
9356: lb_coa_defined := TRUE;
9357: ELSE
9358: lb_coa_defined := FALSE;
9359: END IF;

Line 9706: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN -- COA Check

9702: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'fund code is FLP/DLP');
9703: END IF;
9704:
9705: --if student has coa defined
9706: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN -- COA Check
9707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'student has no COA defined');
9709: END IF;
9710: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');

Line 9747: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN --COA Check

9743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'fund code is not FLP/DLP');
9744: END IF;
9745:
9746: --if student has coa
9747: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN --COA Check
9748: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9749: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'student has no COA defined');
9750: END IF;
9751: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');

Line 9813: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN --COA Check

9809: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9810: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'since COA can be exceeded l_aid=fund max='||l_aid);
9811: END IF;
9812: ELSE
9813: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN --COA Check
9814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'student has no COA defined');
9816: END IF;
9817: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');

Line 10215: IF igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN

10211:
10212: ln_award_perct := 0;
10213: IF lv_method_code = 'M' THEN
10214:
10215: IF igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN
10216:
10217: FOR c_get_term_prsnt_rec IN c_get_term_prsnt(l_fund.adplans_id, l_fabase.base_id) LOOP
10218: ln_award_perct := ln_award_perct + c_get_term_prsnt_rec.ld_perct_num;
10219: END LOOP;

Line 10236: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN') || ' : ' || lv_method_name);

10232: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'ln_award_perct:'||ln_award_perct);
10233: END IF;
10234:
10235: get_plan_desc(l_fund.adplans_id,lv_method_name,lv_method_desc);
10236: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN') || ' : ' || lv_method_name);
10237: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD') || ' : ' || lv_method_desc);
10238:
10239: fnd_message.set_name('IGF','IGF_AW_PKG_PERSNT_CALC');
10240: fnd_message.set_token('PERSNT',ln_award_perct);

Line 10237: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD') || ' : ' || lv_method_desc);

10233: END IF;
10234:
10235: get_plan_desc(l_fund.adplans_id,lv_method_name,lv_method_desc);
10236: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DIST_PLAN') || ' : ' || lv_method_name);
10237: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DIST_PLAN_METHOD') || ' : ' || lv_method_desc);
10238:
10239: fnd_message.set_name('IGF','IGF_AW_PKG_PERSNT_CALC');
10240: fnd_message.set_token('PERSNT',ln_award_perct);
10241: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 11442: g_awarded_aid(l_cnt).need_f := NVL(igf_aw_gen_004.need_f(l_fabase.base_id,g_awd_prd),0);

11438: END IF;
11439: l_cnt := 1;
11440: g_awarded_aid.extend;
11441: g_awarded_aid(l_cnt).base_id := l_fabase.base_id;
11442: g_awarded_aid(l_cnt).need_f := NVL(igf_aw_gen_004.need_f(l_fabase.base_id,g_awd_prd),0);
11443: g_awarded_aid(l_cnt).awarded_aid := NVL(l_aid,0);
11444: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11445: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'set g_awarded_aid('||l_cnt||').base_id:'||g_awarded_aid(l_cnt).base_id);
11446: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'set g_awarded_aid('||l_cnt||').need_f:'||g_awarded_aid(l_cnt).need_f);

Line 11490: g_awarded_aid(l_cnt).need_f := NVL(igf_aw_gen_004.need_f(l_fabase.base_id,g_awd_prd),0);

11486:
11487: l_cnt := l_cnt + 1;
11488: g_awarded_Aid.extend;
11489: g_awarded_aid(l_cnt).base_id := l_fabase.base_id;
11490: g_awarded_aid(l_cnt).need_f := NVL(igf_aw_gen_004.need_f(l_fabase.base_id,g_awd_prd),0);
11491: g_awarded_aid(l_cnt).awarded_aid := NVL(l_aid,0);
11492:
11493: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_rec_fnd=FALSE!g_awarded_aid('||l_cnt||').awarded_aid:'||g_awarded_aid(l_cnt).awarded_aid);

Line 11512: igf_aw_gen_003.get_common_perct(l_awd_grp.adplans_id,l_fabase.base_id,ln_com_perct);

11508: -- Insert a new consolidated record into the temp table.
11509: -- These are the actual awards to the inserted in the igf_aw_award and igf_aw_awd_disb
11510:
11511: ln_com_perct := 100;
11512: igf_aw_gen_003.get_common_perct(l_awd_grp.adplans_id,l_fabase.base_id,ln_com_perct);
11513:
11514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'Before inserting with FL flag in the temp, ln_com_perct : '||ln_com_perct
11516: ||' l_awd_grp.fund_id:'||l_awd_grp.fund_id

Line 12161: IF igf_aw_gen_003.check_coa(l_base_id) = FALSE AND g_sf_packaging = 'T' AND g_allow_to_exceed = 'COA' THEN

12157:
12158: /*
12159: check if the student has COA or not and set a flag specifying what cursor should be used
12160: */
12161: IF igf_aw_gen_003.check_coa(l_base_id) = FALSE AND g_sf_packaging = 'T' AND g_allow_to_exceed = 'COA' THEN
12162: IF lv_method_code IN ('M','E') THEN
12163: lb_use_wcoa_cur := TRUE;
12164: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12165: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'have to use alternate cursor for base_id:'||l_base_id||' and adplans_id:'||l_adplans_id);

Line 12193: OPEN c_auto_disb_equal(l_adplans_id,l_base_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));

12189: FETCH cur_terms_count INTO l_terms_count;
12190: CLOSE cur_terms_count;
12191:
12192: IF lb_use_wcoa_cur = FALSE THEN
12193: OPEN c_auto_disb_equal(l_adplans_id,l_base_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));
12194: FETCH c_auto_disb_equal INTO l_tp_perct;
12195: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'opened and fetched cursor c_auto_disb_equal');
12197: END IF;

Line 12200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'igf_aw_gen_003.get_plan_disb_count('||l_adplans_id||'):'||igf_aw_gen_003.get_plan_disb_count(l_adplans_id));

12196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'opened and fetched cursor c_auto_disb_equal');
12197: END IF;
12198: ELSE
12199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'igf_aw_gen_003.get_plan_disb_count('||l_adplans_id||'):'||igf_aw_gen_003.get_plan_disb_count(l_adplans_id));
12201: END IF;
12202: OPEN c_auto_disb_equal_wcoa(l_base_id,l_adplans_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));
12203: FETCH c_auto_disb_equal_wcoa INTO l_tp_perct;
12204: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 12202: OPEN c_auto_disb_equal_wcoa(l_base_id,l_adplans_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));

12198: ELSE
12199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'igf_aw_gen_003.get_plan_disb_count('||l_adplans_id||'):'||igf_aw_gen_003.get_plan_disb_count(l_adplans_id));
12201: END IF;
12202: OPEN c_auto_disb_equal_wcoa(l_base_id,l_adplans_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));
12203: FETCH c_auto_disb_equal_wcoa INTO l_tp_perct;
12204: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12205: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'opened and fetched cursor c_auto_disb_equal_wcoa');
12206: END IF;

Line 13197: fnd_file.put_line(fnd_file.log,RPAD(l_allow_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AW_SF_ALLOW_EXCEED',p_allow_to_exceed));

13193: END IF;
13194:
13195: --log allow to exceed
13196: IF p_allow_to_exceed IS NOT NULL THEN
13197: fnd_file.put_line(fnd_file.log,RPAD(l_allow_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AW_SF_ALLOW_EXCEED',p_allow_to_exceed));
13198: END IF;
13199:
13200: --log update award notification status
13201: IF p_upd_awd_notif_status IS NOT NULL THEN

Line 13202: fnd_file.put_line(fnd_file.log,RPAD(l_notif_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_upd_awd_notif_status));

13198: END IF;
13199:
13200: --log update award notification status
13201: IF p_upd_awd_notif_status IS NOT NULL THEN
13202: fnd_file.put_line(fnd_file.log,RPAD(l_notif_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_upd_awd_notif_status));
13203: END IF;
13204:
13205: --log lock award setting
13206: IF p_lock_award IS NOT NULL THEN

Line 13207: fnd_file.put_line(fnd_file.log,RPAD(l_lock_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_lock_award));

13203: END IF;
13204:
13205: --log lock award setting
13206: IF p_lock_award IS NOT NULL THEN
13207: fnd_file.put_line(fnd_file.log,RPAD(l_lock_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_lock_award));
13208: END IF;
13209:
13210: --log award group
13211: IF p_grp_code IS NOT NULL THEN

Line 13220: fnd_file.put_line(fnd_file.log,RPAD(l_sim_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_sim_mode));

13216: END IF;
13217:
13218: --log simulation
13219: IF p_sim_mode IS NOT NULL THEN
13220: fnd_file.put_line(fnd_file.log,RPAD(l_sim_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_sim_mode));
13221: END IF;
13222:
13223: --log run mode
13224: IF p_run_mode IS NOT NULL THEN

Line 13230: fnd_file.put_line(fnd_file.log,RPAD(l_publish_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_publish_in_ss_flag));

13226: END IF;
13227:
13228: --log publish mode
13229: IF p_publish_in_ss_flag IS NOT NULL THEN
13230: fnd_file.put_line(fnd_file.log,RPAD(l_publish_log,40) || ' : ' || igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_publish_in_ss_flag));
13231: END IF;
13232:
13233: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
13234: END log_parameters;

Line 13259: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);

13255: || Purpose :
13256: || Known limitations, enhancements or remarks :
13257: || Change History :
13258: || Who WHEN What
13259: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
13260: || veramach 13-OCT-2003 FA 124 Build - Added logic for validations on g_sf_max_award_amt,g_sf_min_award_amt,g_allow_to_exceed
13261: || (reverse chronological order - newest change first)
13262: */
13263:

Line 13364: igf_aw_gen.set_org_id(NULL);

13360: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
13361:
13362: l_error_code NUMBER;
13363: BEGIN
13364: igf_aw_gen.set_org_id(NULL);
13365: IF g_req_id IS NULL THEN
13366: g_req_id := fnd_global.conc_request_id;
13367: END IF;
13368:

Line 13633: l_str := RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'), 40, ' ');

13629: EXIT WHEN c_summary_awd%NOTFOUND;
13630: l_count := c_summary_awd%ROWCOUNT;
13631:
13632: IF c_summary_awd%ROWCOUNT = 1 THEN
13633: l_str := RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'), 40, ' ');
13634: l_str := l_str ||RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_COUNT'), 30, ' ');
13635: l_str := l_str ||RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_AMOUNT'), 30, ' ');
13636: fnd_file.put_line(fnd_file.output,RPAD('-',90,'-'));
13637: fnd_file.put_line(fnd_file.output,l_str);

Line 13634: l_str := l_str ||RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_COUNT'), 30, ' ');

13630: l_count := c_summary_awd%ROWCOUNT;
13631:
13632: IF c_summary_awd%ROWCOUNT = 1 THEN
13633: l_str := RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'), 40, ' ');
13634: l_str := l_str ||RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_COUNT'), 30, ' ');
13635: l_str := l_str ||RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_AMOUNT'), 30, ' ');
13636: fnd_file.put_line(fnd_file.output,RPAD('-',90,'-'));
13637: fnd_file.put_line(fnd_file.output,l_str);
13638: fnd_file.put_line(fnd_file.output,RPAD('-',90,'-'));

Line 13635: l_str := l_str ||RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_AMOUNT'), 30, ' ');

13631:
13632: IF c_summary_awd%ROWCOUNT = 1 THEN
13633: l_str := RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'), 40, ' ');
13634: l_str := l_str ||RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_COUNT'), 30, ' ');
13635: l_str := l_str ||RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_AMOUNT'), 30, ' ');
13636: fnd_file.put_line(fnd_file.output,RPAD('-',90,'-'));
13637: fnd_file.put_line(fnd_file.output,l_str);
13638: fnd_file.put_line(fnd_file.output,RPAD('-',90,'-'));
13639: END IF;

Line 13715: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);

13711: || Known limitations, enhancements or remarks :
13712: || Change History :
13713: || Who WHEN What
13714: || (reverse chronological order - newest change first)
13715: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
13716: || veramach 30-Jun-2004 bug 3709109 - Added call to function check_disb to enforce the rule that FWS funds can
13717: || have only one disbursement per term
13718: || veramach 20-NOV-2003 FA 125 multiple distribution method
13719: || Added p_dist_id as parameter and validations on this parameter

Line 13729: igf_aw_gen.set_org_id(NULL);

13725: lv_method_code VARCHAR2(80) := NULL;
13726: l_terms NUMBER := 0;
13727:
13728: BEGIN
13729: igf_aw_gen.set_org_id(NULL);
13730: IF g_req_id IS NULL THEN
13731: g_req_id := fnd_global.conc_request_id;
13732: END IF;
13733: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN