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_DB_DISB dependencies on FND_LOG

Line 137: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

133: l_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type => get_loan_dtls_rec.ci_cal_type, -- IN
134: p_ci_seq_num => get_loan_dtls_rec.ci_sequence_number, -- IN
135: p_relationship_cd =>l_rel_code, -- IN
136: p_base_id => get_loan_dtls_rec.base_id); -- IN
137: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
138: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.get_cl_version.debug','get_cl_version.l_cl_version:'||l_cl_version);
139: END IF;
140: RETURN l_cl_version;
141: END get_cl_version;

Line 138: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.get_cl_version.debug','get_cl_version.l_cl_version:'||l_cl_version);

134: p_ci_seq_num => get_loan_dtls_rec.ci_sequence_number, -- IN
135: p_relationship_cd =>l_rel_code, -- IN
136: p_base_id => get_loan_dtls_rec.base_id); -- IN
137: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
138: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.get_cl_version.debug','get_cl_version.l_cl_version:'||l_cl_version);
139: END IF;
140: RETURN l_cl_version;
141: END get_cl_version;
142:

Line 271: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

267:
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
272: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_db_disb.log_parameters.exception','Exception:'||SQLERRM);
273: END IF;
274: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
275: fnd_message.set_token('NAME','IGF_DB_DISB.LOG_PARAMETERS');

Line 272: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_db_disb.log_parameters.exception','Exception:'||SQLERRM);

268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
272: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_db_disb.log_parameters.exception','Exception:'||SQLERRM);
273: END IF;
274: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
275: fnd_message.set_token('NAME','IGF_DB_DISB.LOG_PARAMETERS');
276: igs_ge_msg_stack.add;

Line 542: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

538: -- Update transaction type to 'actual'
539:
540: get_adisb_rec.trans_type := 'A';
541:
542: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','set transaction type to A');
544: END IF;
545:
546: -- These assignements are needed, if we are making a cancelled disbursement an actual one

Line 543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','set transaction type to A');

539:
540: get_adisb_rec.trans_type := 'A';
541:
542: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','set transaction type to A');
544: END IF;
545:
546: -- These assignements are needed, if we are making a cancelled disbursement an actual one
547:

Line 558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

554:
555: IF NVL(get_adisb_rec.disb_accepted_amt,0) = 0 THEN
556: RAISE gross_amt_zero;
557: END IF;
558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.disb_accepted_amt:'||get_adisb_rec.disb_accepted_amt);
560: END IF;
561:
562: -- If it is a forced disbursement, set the eligibility status to forced

Line 559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.disb_accepted_amt:'||get_adisb_rec.disb_accepted_amt);

555: IF NVL(get_adisb_rec.disb_accepted_amt,0) = 0 THEN
556: RAISE gross_amt_zero;
557: END IF;
558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.disb_accepted_amt:'||get_adisb_rec.disb_accepted_amt);
560: END IF;
561:
562: -- If it is a forced disbursement, set the eligibility status to forced
563: IF p_lb_force = TRUE THEN

Line 570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

566: ELSE
567: get_adisb_rec.elig_status := 'Y';
568: get_adisb_rec.elig_status_date := TRUNC(SYSDATE);
569: END IF;
570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.elig_status:'||get_adisb_rec.elig_status);
572: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.elig_status_date:'||get_adisb_rec.elig_status_date);
573: END IF;
574:

Line 571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.elig_status:'||get_adisb_rec.elig_status);

567: get_adisb_rec.elig_status := 'Y';
568: get_adisb_rec.elig_status_date := TRUNC(SYSDATE);
569: END IF;
570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.elig_status:'||get_adisb_rec.elig_status);
572: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.elig_status_date:'||get_adisb_rec.elig_status_date);
573: END IF;
574:
575: -- Check if any adjustment record is present for this award

Line 572: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.elig_status_date:'||get_adisb_rec.elig_status_date);

568: get_adisb_rec.elig_status_date := TRUNC(SYSDATE);
569: END IF;
570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.elig_status:'||get_adisb_rec.elig_status);
572: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.elig_status_date:'||get_adisb_rec.elig_status_date);
573: END IF;
574:
575: -- Check if any adjustment record is present for this award
576:

Line 587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

583: disb_dtl_rec.award_id := get_adisb_rec.award_id;
584: disb_dtl_rec.disb_num := get_adisb_rec.disb_num;
585: disb_dtl_rec.disb_seq_num := chk_adj_rec.disb_seq_num;
586: disb_dtl_rec.disb_gross_amt := get_adisb_rec.disb_accepted_amt;
587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.award_id:'||get_adisb_rec.award_id);
589: END IF;
590:
591: IF NVL(disb_dtl_rec.disb_gross_amt,0) = 0 THEN

Line 588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.award_id:'||get_adisb_rec.award_id);

584: disb_dtl_rec.disb_num := get_adisb_rec.disb_num;
585: disb_dtl_rec.disb_seq_num := chk_adj_rec.disb_seq_num;
586: disb_dtl_rec.disb_gross_amt := get_adisb_rec.disb_accepted_amt;
587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','get_adisb_rec.award_id:'||get_adisb_rec.award_id);
589: END IF;
590:
591: IF NVL(disb_dtl_rec.disb_gross_amt,0) = 0 THEN
592: RAISE gross_amt_zero;

Line 615: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

611: ELSE
612: disb_dtl_rec.disb_activity := 'A';
613: disb_dtl_rec.disb_adj_amt := get_adisb_rec.disb_net_amt;
614: END IF;
615: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
616: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','disb_dtl_rec.disb_activity:'||disb_dtl_rec.disb_activity);
617: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','disb_dtl_rec.disb_adj_amt:'||disb_dtl_rec.disb_adj_amt);
618: END IF;
619:

Line 616: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','disb_dtl_rec.disb_activity:'||disb_dtl_rec.disb_activity);

612: disb_dtl_rec.disb_activity := 'A';
613: disb_dtl_rec.disb_adj_amt := get_adisb_rec.disb_net_amt;
614: END IF;
615: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
616: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','disb_dtl_rec.disb_activity:'||disb_dtl_rec.disb_activity);
617: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','disb_dtl_rec.disb_adj_amt:'||disb_dtl_rec.disb_adj_amt);
618: END IF;
619:
620: lv_rowid := NULL;

Line 617: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','disb_dtl_rec.disb_adj_amt:'||disb_dtl_rec.disb_adj_amt);

613: disb_dtl_rec.disb_adj_amt := get_adisb_rec.disb_net_amt;
614: END IF;
615: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
616: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','disb_dtl_rec.disb_activity:'||disb_dtl_rec.disb_activity);
617: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','disb_dtl_rec.disb_adj_amt:'||disb_dtl_rec.disb_adj_amt);
618: END IF;
619:
620: lv_rowid := NULL;
621: fnd_message.set_name('IGF','IGF_DB_CREATE_ACT');

Line 627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

623: fnd_message.set_token('DISB_NUM',TO_CHAR(disb_dtl_rec.disb_num));
624: fnd_file.put_line(fnd_file.log,RPAD(' ',28) ||fnd_message.get);
625: fnd_file.new_line(fnd_file.log,1);
626:
627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','creating actual disbursment with disb_gross_amt '|| disb_dtl_rec.disb_gross_amt);
629: END IF;
630: igf_db_awd_disb_dtl_pkg.insert_row(x_rowid => lv_rowid,
631: x_award_id => disb_dtl_rec.award_id ,

Line 628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','creating actual disbursment with disb_gross_amt '|| disb_dtl_rec.disb_gross_amt);

624: fnd_file.put_line(fnd_file.log,RPAD(' ',28) ||fnd_message.get);
625: fnd_file.new_line(fnd_file.log,1);
626:
627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','creating actual disbursment with disb_gross_amt '|| disb_dtl_rec.disb_gross_amt);
629: END IF;
630: igf_db_awd_disb_dtl_pkg.insert_row(x_rowid => lv_rowid,
631: x_award_id => disb_dtl_rec.award_id ,
632: x_disb_num => disb_dtl_rec.disb_num ,

Line 668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

664:
665:
666: ln_act_disb := 1 + ln_act_disb;
667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','updating igf_aw_awd_disb for award '||get_adisb_rec.award_id);
670: END IF;
671: igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id ,
672: x_award_id => get_adisb_rec.award_id ,

Line 669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','updating igf_aw_awd_disb for award '||get_adisb_rec.award_id);

665:
666: ln_act_disb := 1 + ln_act_disb;
667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','updating igf_aw_awd_disb for award '||get_adisb_rec.award_id);
670: END IF;
671: igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id ,
672: x_award_id => get_adisb_rec.award_id ,
673: x_disb_num => get_adisb_rec.disb_num ,

Line 877: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

873: OPEN cur_get_adisb (p_row_id);
874: FETCH cur_get_adisb INTO get_adisb_rec;
875: CLOSE cur_get_adisb;
876:
877: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','p_fund_type:'||p_fund_type);
879: END IF;
880:
881: --If the award is PELL

Line 878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','p_fund_type:'||p_fund_type);

874: FETCH cur_get_adisb INTO get_adisb_rec;
875: CLOSE cur_get_adisb;
876:
877: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','p_fund_type:'||p_fund_type);
879: END IF;
880:
881: --If the award is PELL
882: IF p_fund_type='P' THEN

Line 897: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

893:
894:
895: IF p_fund_type IN ('D','F') THEN
896: IF igf_sl_award.chk_loan_upd_lock(get_adisb_rec.award_id) = 'TRUE' THEN
897: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','chk_loan_upd_lock returned TRUE');
899: END IF;
900: RAISE ORIG_STATUS;
901: END IF;

Line 898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','chk_loan_upd_lock returned TRUE');

894:
895: IF p_fund_type IN ('D','F') THEN
896: IF igf_sl_award.chk_loan_upd_lock(get_adisb_rec.award_id) = 'TRUE' THEN
897: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','chk_loan_upd_lock returned TRUE');
899: END IF;
900: RAISE ORIG_STATUS;
901: END IF;
902: END IF;

Line 909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

905: OPEN cur_reported_adj(get_adisb_rec.award_id,get_adisb_rec.disb_num);
906: FETCH cur_reported_adj INTO reported_adj_rec;
907: CLOSE cur_reported_adj;
908:
909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
910: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','reported_adj_rec.adj_cnt:'||reported_adj_rec.adj_cnt);
911: END IF;
912: IF reported_adj_rec.adj_cnt > 0 THEN
913: RAISE ORIG_STATUS;

Line 910: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','reported_adj_rec.adj_cnt:'||reported_adj_rec.adj_cnt);

906: FETCH cur_reported_adj INTO reported_adj_rec;
907: CLOSE cur_reported_adj;
908:
909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
910: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','reported_adj_rec.adj_cnt:'||reported_adj_rec.adj_cnt);
911: END IF;
912: IF reported_adj_rec.adj_cnt > 0 THEN
913: RAISE ORIG_STATUS;
914: END IF;

Line 926: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

922: OPEN c_get_awd_det(cp_awd_id => get_adisb_rec.award_id);
923: FETCH c_get_awd_det INTO awd_det_rec;
924: CLOSE c_get_awd_det;
925:
926: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
927: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','grant_orig_rec.origination_id:'||grant_orig_rec.origination_id);
928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','grant_orig_rec.orig_action_code:'||grant_orig_rec.orig_action_code);
929: END IF;
930: IF grant_orig_rec.orig_action_code = 'S' THEN

Line 927: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','grant_orig_rec.origination_id:'||grant_orig_rec.origination_id);

923: FETCH c_get_awd_det INTO awd_det_rec;
924: CLOSE c_get_awd_det;
925:
926: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
927: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','grant_orig_rec.origination_id:'||grant_orig_rec.origination_id);
928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','grant_orig_rec.orig_action_code:'||grant_orig_rec.orig_action_code);
929: END IF;
930: IF grant_orig_rec.orig_action_code = 'S' THEN
931: RAISE ORIG_STATUS;

Line 928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','grant_orig_rec.orig_action_code:'||grant_orig_rec.orig_action_code);

924: CLOSE c_get_awd_det;
925:
926: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
927: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','grant_orig_rec.origination_id:'||grant_orig_rec.origination_id);
928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','grant_orig_rec.orig_action_code:'||grant_orig_rec.orig_action_code);
929: END IF;
930: IF grant_orig_rec.orig_action_code = 'S' THEN
931: RAISE ORIG_STATUS;
932: ELSIF NVL(grant_disb_rec.disb_ack_act_status,'*') = 'S' THEN

Line 1000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

996: l_disb_gross_amt := get_adisb_rec.disb_gross_amt;
997: END IF;
998: END IF;
999:
1000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_accepted_amt:'||l_disb_accepted_amt);
1002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_net_amt:'||l_disb_net_amt);
1003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','updating the disbursement '||get_adisb_rec.disb_num||' as cancelled');
1004: END IF;

Line 1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_accepted_amt:'||l_disb_accepted_amt);

997: END IF;
998: END IF;
999:
1000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_accepted_amt:'||l_disb_accepted_amt);
1002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_net_amt:'||l_disb_net_amt);
1003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','updating the disbursement '||get_adisb_rec.disb_num||' as cancelled');
1004: END IF;
1005:

Line 1002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_net_amt:'||l_disb_net_amt);

998: END IF;
999:
1000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_accepted_amt:'||l_disb_accepted_amt);
1002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_net_amt:'||l_disb_net_amt);
1003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','updating the disbursement '||get_adisb_rec.disb_num||' as cancelled');
1004: END IF;
1005:
1006: --update the current disbursement as Cancelled

Line 1003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','updating the disbursement '||get_adisb_rec.disb_num||' as cancelled');

999:
1000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_accepted_amt:'||l_disb_accepted_amt);
1002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','l_disb_net_amt:'||l_disb_net_amt);
1003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','updating the disbursement '||get_adisb_rec.disb_num||' as cancelled');
1004: END IF;
1005:
1006: --update the current disbursement as Cancelled
1007: igf_aw_awd_disb_pkg.update_row

Line 1065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1061:
1062: get_adisb_rec.disb_date := 1 + max_disb_rec.disb_date;
1063: get_adisb_rec.disb_num := 1 + max_disb_rec.disb_num;
1064:
1065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_date:'||get_adisb_rec.disb_date);
1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_num:'||get_adisb_rec.disb_num);
1068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','inserting to igf_aw_awd_disb with award_id '||get_adisb_rec.award_id);
1069: END IF;

Line 1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_date:'||get_adisb_rec.disb_date);

1062: get_adisb_rec.disb_date := 1 + max_disb_rec.disb_date;
1063: get_adisb_rec.disb_num := 1 + max_disb_rec.disb_num;
1064:
1065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_date:'||get_adisb_rec.disb_date);
1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_num:'||get_adisb_rec.disb_num);
1068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','inserting to igf_aw_awd_disb with award_id '||get_adisb_rec.award_id);
1069: END IF;
1070: -- table handler for igf_aw_awd_disb table, in case of pell disbursements

Line 1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_num:'||get_adisb_rec.disb_num);

1063: get_adisb_rec.disb_num := 1 + max_disb_rec.disb_num;
1064:
1065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_date:'||get_adisb_rec.disb_date);
1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_num:'||get_adisb_rec.disb_num);
1068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','inserting to igf_aw_awd_disb with award_id '||get_adisb_rec.award_id);
1069: END IF;
1070: -- table handler for igf_aw_awd_disb table, in case of pell disbursements
1071: -- should insert / update records in igf_gr_rfms_disb table

Line 1068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','inserting to igf_aw_awd_disb with award_id '||get_adisb_rec.award_id);

1064:
1065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_date:'||get_adisb_rec.disb_date);
1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_num:'||get_adisb_rec.disb_num);
1068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','inserting to igf_aw_awd_disb with award_id '||get_adisb_rec.award_id);
1069: END IF;
1070: -- table handler for igf_aw_awd_disb table, in case of pell disbursements
1071: -- should insert / update records in igf_gr_rfms_disb table
1072: igf_aw_awd_disb_pkg.insert_row( x_rowid => lv_rowid ,

Line 1163: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1159: LOOP
1160: FETCH cur_pays_prg INTO pays_prg_rec;
1161: EXIT WHEN cur_pays_prg%NOTFOUND;
1162: igf_db_pays_prg_t_pkg.delete_row(pays_prg_rec.row_id);
1163: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');
1165: END IF;
1166: END LOOP;
1167: CLOSE cur_pays_prg;

Line 1164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');

1160: FETCH cur_pays_prg INTO pays_prg_rec;
1161: EXIT WHEN cur_pays_prg%NOTFOUND;
1162: igf_db_pays_prg_t_pkg.delete_row(pays_prg_rec.row_id);
1163: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');
1165: END IF;
1166: END LOOP;
1167: CLOSE cur_pays_prg;
1168:

Line 1412: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1408: dbpays_rec igf_db_pays_prg_t%ROWTYPE;
1409: lv_rowid ROWID;
1410:
1411: BEGIN
1412: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_cal_type:'||p_acad_cal_type);
1414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:'||p_acad_ci_seq_num);
1415: END IF;
1416: FOR get_acad_tp_rec IN cur_get_acad_tp(

Line 1413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_cal_type:'||p_acad_cal_type);

1409: lv_rowid ROWID;
1410:
1411: BEGIN
1412: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_cal_type:'||p_acad_cal_type);
1414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:'||p_acad_ci_seq_num);
1415: END IF;
1416: FOR get_acad_tp_rec IN cur_get_acad_tp(
1417: p_acad_cal_type,

Line 1414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:'||p_acad_ci_seq_num);

1410:
1411: BEGIN
1412: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_cal_type:'||p_acad_cal_type);
1414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:'||p_acad_ci_seq_num);
1415: END IF;
1416: FOR get_acad_tp_rec IN cur_get_acad_tp(
1417: p_acad_cal_type,
1418: p_acad_ci_seq_num

Line 1421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1417: p_acad_cal_type,
1418: p_acad_ci_seq_num
1419: )
1420: LOOP
1421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id('||p_base_id||'):'||igf_gr_gen.get_person_id(p_base_id));
1423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:'||get_acad_tp_rec.tp_cal_type);
1424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'||get_acad_tp_rec.tp_sequence_number);
1425: END IF;

Line 1422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id('||p_base_id||'):'||igf_gr_gen.get_person_id(p_base_id));

1418: p_acad_ci_seq_num
1419: )
1420: LOOP
1421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id('||p_base_id||'):'||igf_gr_gen.get_person_id(p_base_id));
1423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:'||get_acad_tp_rec.tp_cal_type);
1424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'||get_acad_tp_rec.tp_sequence_number);
1425: END IF;
1426: FOR get_att_rec IN cur_get_att(

Line 1423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:'||get_acad_tp_rec.tp_cal_type);

1419: )
1420: LOOP
1421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id('||p_base_id||'):'||igf_gr_gen.get_person_id(p_base_id));
1423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:'||get_acad_tp_rec.tp_cal_type);
1424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'||get_acad_tp_rec.tp_sequence_number);
1425: END IF;
1426: FOR get_att_rec IN cur_get_att(
1427: igf_gr_gen.get_person_id(p_base_id),

Line 1424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'||get_acad_tp_rec.tp_sequence_number);

1420: LOOP
1421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id('||p_base_id||'):'||igf_gr_gen.get_person_id(p_base_id));
1423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:'||get_acad_tp_rec.tp_cal_type);
1424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'||get_acad_tp_rec.tp_sequence_number);
1425: END IF;
1426: FOR get_att_rec IN cur_get_att(
1427: igf_gr_gen.get_person_id(p_base_id),
1428: p_acad_cal_type,

Line 1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1434: dbpays_rec.program_cd := get_att_rec.prg_course_cd;
1435: dbpays_rec.prg_ver_num := get_att_rec.prg_ver_num;
1436: dbpays_rec.unit_cd := get_att_rec.unit_course_cd;
1437: dbpays_rec.unit_ver_num := get_att_rec.unit_ver_num;
1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1439: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:'||dbpays_rec.program_cd);
1440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:'||dbpays_rec.prg_ver_num);
1441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:'||dbpays_rec.unit_cd);
1442: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:'||dbpays_rec.unit_ver_num);

Line 1439: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:'||dbpays_rec.program_cd);

1435: dbpays_rec.prg_ver_num := get_att_rec.prg_ver_num;
1436: dbpays_rec.unit_cd := get_att_rec.unit_course_cd;
1437: dbpays_rec.unit_ver_num := get_att_rec.unit_ver_num;
1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1439: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:'||dbpays_rec.program_cd);
1440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:'||dbpays_rec.prg_ver_num);
1441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:'||dbpays_rec.unit_cd);
1442: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:'||dbpays_rec.unit_ver_num);
1443: END IF;

Line 1440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:'||dbpays_rec.prg_ver_num);

1436: dbpays_rec.unit_cd := get_att_rec.unit_course_cd;
1437: dbpays_rec.unit_ver_num := get_att_rec.unit_ver_num;
1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1439: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:'||dbpays_rec.program_cd);
1440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:'||dbpays_rec.prg_ver_num);
1441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:'||dbpays_rec.unit_cd);
1442: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:'||dbpays_rec.unit_ver_num);
1443: END IF;
1444:

Line 1441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:'||dbpays_rec.unit_cd);

1437: dbpays_rec.unit_ver_num := get_att_rec.unit_ver_num;
1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1439: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:'||dbpays_rec.program_cd);
1440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:'||dbpays_rec.prg_ver_num);
1441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:'||dbpays_rec.unit_cd);
1442: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:'||dbpays_rec.unit_ver_num);
1443: END IF;
1444:
1445: lv_rowid := NULL;

Line 1442: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:'||dbpays_rec.unit_ver_num);

1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1439: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:'||dbpays_rec.program_cd);
1440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:'||dbpays_rec.prg_ver_num);
1441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:'||dbpays_rec.unit_cd);
1442: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:'||dbpays_rec.unit_ver_num);
1443: END IF;
1444:
1445: lv_rowid := NULL;
1446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1442: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:'||dbpays_rec.unit_ver_num);
1443: END IF;
1444:
1445: lv_rowid := NULL;
1446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');
1448: END IF;
1449: igf_db_pays_prg_t_pkg.insert_row(
1450: x_rowid => lv_rowid,

Line 1447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');

1443: END IF;
1444:
1445: lv_rowid := NULL;
1446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');
1448: END IF;
1449: igf_db_pays_prg_t_pkg.insert_row(
1450: x_rowid => lv_rowid,
1451: x_dbpays_id => dbpays_rec.dbpays_id,

Line 2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2066: fnd_message.set_token('FDESC',get_fund_desc(awd_disb_rec.fund_id));
2067: fnd_file.put_line(fnd_file.log,RPAD(' ',15) ||fnd_message.get);
2068: END IF;
2069:
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2071: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','ln_enfr_disb:'||ln_enfr_disb);
2072: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','lv_fund_type:'||lv_fund_type);
2073: END IF;
2074:

Line 2071: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','ln_enfr_disb:'||ln_enfr_disb);

2067: fnd_file.put_line(fnd_file.log,RPAD(' ',15) ||fnd_message.get);
2068: END IF;
2069:
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2071: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','ln_enfr_disb:'||ln_enfr_disb);
2072: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','lv_fund_type:'||lv_fund_type);
2073: END IF;
2074:
2075: fnd_file.new_line(fnd_file.log,1);

Line 2072: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','lv_fund_type:'||lv_fund_type);

2068: END IF;
2069:
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2071: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','ln_enfr_disb:'||ln_enfr_disb);
2072: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','lv_fund_type:'||lv_fund_type);
2073: END IF;
2074:
2075: fnd_file.new_line(fnd_file.log,1);
2076: fnd_message.set_name('IGF','IGF_DB_PROCESS_AWD_DISB');

Line 2082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2078: fnd_message.set_token('AWARD_ID',TO_CHAR(awd_disb_rec.award_id));
2079: fnd_message.set_token('DISB_NUM',TO_CHAR(awd_disb_rec.disb_num));
2080: fnd_file.put_line(fnd_file.log,RPAD(' ',20) ||fnd_message.get);
2081: fnd_file.new_line(fnd_file.log,1);
2082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','processing disb '||awd_disb_rec.disb_num||' of award '||awd_disb_rec.award_id);
2084: END IF;
2085: --
2086: -- Validations

Line 2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','processing disb '||awd_disb_rec.disb_num||' of award '||awd_disb_rec.award_id);

2079: fnd_message.set_token('DISB_NUM',TO_CHAR(awd_disb_rec.disb_num));
2080: fnd_file.put_line(fnd_file.log,RPAD(' ',20) ||fnd_message.get);
2081: fnd_file.new_line(fnd_file.log,1);
2082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','processing disb '||awd_disb_rec.disb_num||' of award '||awd_disb_rec.award_id);
2084: END IF;
2085: --
2086: -- Validations
2087: --

Line 2158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2154: 'Y',
2155: TRUNC(SYSDATE),
2156: ln_credit_pts);
2157:
2158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','awd_disb_rec.min_credit_pts:'||awd_disb_rec.min_credit_pts);
2160: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','ln_credit_pts:'||ln_credit_pts);
2161: END IF;
2162:

Line 2159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','awd_disb_rec.min_credit_pts:'||awd_disb_rec.min_credit_pts);

2155: TRUNC(SYSDATE),
2156: ln_credit_pts);
2157:
2158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','awd_disb_rec.min_credit_pts:'||awd_disb_rec.min_credit_pts);
2160: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','ln_credit_pts:'||ln_credit_pts);
2161: END IF;
2162:
2163: IF NVL(ln_credit_pts,0) < NVL(awd_disb_rec.min_credit_pts,0) THEN

Line 2160: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','ln_credit_pts:'||ln_credit_pts);

2156: ln_credit_pts);
2157:
2158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','awd_disb_rec.min_credit_pts:'||awd_disb_rec.min_credit_pts);
2160: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','ln_credit_pts:'||ln_credit_pts);
2161: END IF;
2162:
2163: IF NVL(ln_credit_pts,0) < NVL(awd_disb_rec.min_credit_pts,0) THEN
2164: lb_cp_result := FALSE;

Line 2180: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2176: awd_disb_rec.attendance_type_code,
2177: p_message
2178: );
2179:
2180: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2181: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','awd_disb_rec.attendance_type_code:'||awd_disb_rec.attendance_type_code);
2182: END IF;
2183:
2184: IF NOT lb_att_result THEN

Line 2181: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','awd_disb_rec.attendance_type_code:'||awd_disb_rec.attendance_type_code);

2177: p_message
2178: );
2179:
2180: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2181: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','awd_disb_rec.attendance_type_code:'||awd_disb_rec.attendance_type_code);
2182: END IF;
2183:
2184: IF NOT lb_att_result THEN
2185: fnd_message.set_name('IGF','IGF_DB_FAIL_ATT');

Line 2214: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2210: fnd_file.put_line(fnd_file.log,RPAD(' ',20) ||fnd_message.get);
2211:
2212: ln_enfr_disb_p := 1 + ln_enfr_disb_p;
2213:
2214: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2215: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','updating igf_aw_awd_disb for award '||get_adisb_rec.award_id||' disb '||get_adisb_rec.disb_num);
2216: END IF;
2217:
2218: igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id ,

Line 2215: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','updating igf_aw_awd_disb for award '||get_adisb_rec.award_id||' disb '||get_adisb_rec.disb_num);

2211:
2212: ln_enfr_disb_p := 1 + ln_enfr_disb_p;
2213:
2214: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2215: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_verf_enf.debug','updating igf_aw_awd_disb for award '||get_adisb_rec.award_id||' disb '||get_adisb_rec.disb_num);
2216: END IF;
2217:
2218: igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id ,
2219: x_award_id => get_adisb_rec.award_id ,

Line 2534: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2530:
2531: -- Bug : 2738181 (log file should be more appropriate.)
2532: -- nsidana (4/16/2003)
2533: -- Added the folowing IF condition to check if the p_fnd_id is null. If yes, display a new message having just one parameter.
2534: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2535: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_awd_disb%NOTFOUND');
2536: END IF;
2537: IF p_fund_id IS NULL THEN
2538: -- Add a new message having just one parameter.

Line 2535: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_awd_disb%NOTFOUND');

2531: -- Bug : 2738181 (log file should be more appropriate.)
2532: -- nsidana (4/16/2003)
2533: -- Added the folowing IF condition to check if the p_fnd_id is null. If yes, display a new message having just one parameter.
2534: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2535: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_awd_disb%NOTFOUND');
2536: END IF;
2537: IF p_fund_id IS NULL THEN
2538: -- Add a new message having just one parameter.
2539: fnd_message.set_name('IGF','IGF_DB_NO_PLAN_REC');

Line 2541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2537: IF p_fund_id IS NULL THEN
2538: -- Add a new message having just one parameter.
2539: fnd_message.set_name('IGF','IGF_DB_NO_PLAN_REC');
2540: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));
2543: END IF;
2544: ELSE
2545: -- Add old message having two parameters.

Line 2542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));

2538: -- Add a new message having just one parameter.
2539: fnd_message.set_name('IGF','IGF_DB_NO_PLAN_REC');
2540: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));
2543: END IF;
2544: ELSE
2545: -- Add old message having two parameters.
2546: fnd_message.set_name('IGF','IGF_DB_NO_STD_FUND');

Line 2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2545: -- Add old message having two parameters.
2546: fnd_message.set_name('IGF','IGF_DB_NO_STD_FUND');
2547: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2548: fnd_message.set_token('FDESC',get_fund_desc(p_fund_id));
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));
2551: END IF;
2552: END IF;
2553: p_result := fnd_message.get;

Line 2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));

2546: fnd_message.set_name('IGF','IGF_DB_NO_STD_FUND');
2547: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2548: fnd_message.set_token('FDESC',get_fund_desc(p_fund_id));
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));
2551: END IF;
2552: END IF;
2553: p_result := fnd_message.get;
2554: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||p_result);

Line 2559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2555: -- No Planned Disbursements found for Student and Fund )
2556: CLOSE cur_awd_disb;
2557:
2558: ELSIF cur_awd_disb%FOUND THEN
2559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_awd_disb%FOUND');
2561: END IF;
2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling delete_pays');

Line 2560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_awd_disb%FOUND');

2556: CLOSE cur_awd_disb;
2557:
2558: ELSIF cur_awd_disb%FOUND THEN
2559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_awd_disb%FOUND');
2561: END IF;
2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling delete_pays');
2564: END IF;

Line 2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2558: ELSIF cur_awd_disb%FOUND THEN
2559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_awd_disb%FOUND');
2561: END IF;
2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling delete_pays');
2564: END IF;
2565: -- truncate previous records that were used in determining eligibility of the student in the previous run
2566: delete_pays();

Line 2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling delete_pays');

2559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_awd_disb%FOUND');
2561: END IF;
2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling delete_pays');
2564: END IF;
2565: -- truncate previous records that were used in determining eligibility of the student in the previous run
2566: delete_pays();
2567: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2567: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling delete_pays');
2564: END IF;
2565: -- truncate previous records that were used in determining eligibility of the student in the previous run
2566: delete_pays();
2567: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called delete_pays');
2569: END IF;
2570: ln_old_fund := -1 ;
2571: ln_new_fund := 0;

Line 2568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called delete_pays');

2564: END IF;
2565: -- truncate previous records that were used in determining eligibility of the student in the previous run
2566: delete_pays();
2567: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called delete_pays');
2569: END IF;
2570: ln_old_fund := -1 ;
2571: ln_new_fund := 0;
2572:

Line 2582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2578:
2579: lv_new_ld_c := '0';
2580: ln_new_ld_n := 0;
2581:
2582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');
2584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_cal_type:'||awd_disb_rec.ci_cal_type);
2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'||awd_disb_rec.ci_sequence_number);
2586: END IF;

Line 2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');

2579: lv_new_ld_c := '0';
2580: ln_new_ld_n := 0;
2581:
2582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');
2584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_cal_type:'||awd_disb_rec.ci_cal_type);
2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'||awd_disb_rec.ci_sequence_number);
2586: END IF;
2587: -- Get Academic Calendar Information

Line 2584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_cal_type:'||awd_disb_rec.ci_cal_type);

2580: ln_new_ld_n := 0;
2581:
2582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');
2584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_cal_type:'||awd_disb_rec.ci_cal_type);
2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'||awd_disb_rec.ci_sequence_number);
2586: END IF;
2587: -- Get Academic Calendar Information
2588: igf_ap_oss_integr.get_acad_cal_from_awd( awd_disb_rec.ci_cal_type,awd_disb_rec.ci_sequence_number,

Line 2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'||awd_disb_rec.ci_sequence_number);

2581:
2582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');
2584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_cal_type:'||awd_disb_rec.ci_cal_type);
2585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'||awd_disb_rec.ci_sequence_number);
2586: END IF;
2587: -- Get Academic Calendar Information
2588: igf_ap_oss_integr.get_acad_cal_from_awd( awd_disb_rec.ci_cal_type,awd_disb_rec.ci_sequence_number,
2589: lv_acad_cal_type,ln_acad_seq_num,lv_acad_alt_code);

Line 2590: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2586: END IF;
2587: -- Get Academic Calendar Information
2588: igf_ap_oss_integr.get_acad_cal_from_awd( awd_disb_rec.ci_cal_type,awd_disb_rec.ci_sequence_number,
2589: lv_acad_cal_type,ln_acad_seq_num,lv_acad_alt_code);
2590: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_cal_type:'||lv_acad_cal_type);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_acad_seq_num:'||ln_acad_seq_num);
2594: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_alt_code:'||lv_acad_alt_code);

Line 2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_acad_cal_from_awd returned the following info');

2587: -- Get Academic Calendar Information
2588: igf_ap_oss_integr.get_acad_cal_from_awd( awd_disb_rec.ci_cal_type,awd_disb_rec.ci_sequence_number,
2589: lv_acad_cal_type,ln_acad_seq_num,lv_acad_alt_code);
2590: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_cal_type:'||lv_acad_cal_type);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_acad_seq_num:'||ln_acad_seq_num);
2594: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_alt_code:'||lv_acad_alt_code);
2595: END IF;

Line 2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_cal_type:'||lv_acad_cal_type);

2588: igf_ap_oss_integr.get_acad_cal_from_awd( awd_disb_rec.ci_cal_type,awd_disb_rec.ci_sequence_number,
2589: lv_acad_cal_type,ln_acad_seq_num,lv_acad_alt_code);
2590: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_cal_type:'||lv_acad_cal_type);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_acad_seq_num:'||ln_acad_seq_num);
2594: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_alt_code:'||lv_acad_alt_code);
2595: END IF;
2596: --

Line 2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_acad_seq_num:'||ln_acad_seq_num);

2589: lv_acad_cal_type,ln_acad_seq_num,lv_acad_alt_code);
2590: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_cal_type:'||lv_acad_cal_type);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_acad_seq_num:'||ln_acad_seq_num);
2594: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_alt_code:'||lv_acad_alt_code);
2595: END IF;
2596: --
2597: -- First get all the enrolled programs, unit sets for the student and insert into IGF_DB_PAYS_PRG_T

Line 2594: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_alt_code:'||lv_acad_alt_code);

2590: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2591: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2592: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_cal_type:'||lv_acad_cal_type);
2593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_acad_seq_num:'||ln_acad_seq_num);
2594: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_acad_alt_code:'||lv_acad_alt_code);
2595: END IF;
2596: --
2597: -- First get all the enrolled programs, unit sets for the student and insert into IGF_DB_PAYS_PRG_T
2598: -- We are doing this before starting the main loop.

Line 2603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2599: -- It may very well happen that there are no Pays onlu units or programs defined in fund setup
2600: -- Still we need to have the the enrolled programs, unit sets for the student into IGF_DB_PAYS_PRG_T
2601: --
2602:
2603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling insert_pays_prg_uts');
2605: END IF;
2606: insert_pays_prg_uts(awd_disb_rec.base_id,
2607: lv_acad_cal_type,ln_acad_seq_num);

Line 2604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling insert_pays_prg_uts');

2600: -- Still we need to have the the enrolled programs, unit sets for the student into IGF_DB_PAYS_PRG_T
2601: --
2602:
2603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling insert_pays_prg_uts');
2605: END IF;
2606: insert_pays_prg_uts(awd_disb_rec.base_id,
2607: lv_acad_cal_type,ln_acad_seq_num);
2608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling insert_pays_prg_uts');
2605: END IF;
2606: insert_pays_prg_uts(awd_disb_rec.base_id,
2607: lv_acad_cal_type,ln_acad_seq_num);
2608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2609: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called insert_pays_prg_uts');
2610: END IF;
2611: --
2612: -- Get FED_VERIF_STATUS of the Student

Line 2609: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called insert_pays_prg_uts');

2605: END IF;
2606: insert_pays_prg_uts(awd_disb_rec.base_id,
2607: lv_acad_cal_type,ln_acad_seq_num);
2608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2609: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called insert_pays_prg_uts');
2610: END IF;
2611: --
2612: -- Get FED_VERIF_STATUS of the Student
2613: --

Line 2618: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2614: OPEN cur_get_ver(awd_disb_rec.base_id);
2615: FETCH cur_get_ver INTO get_ver_rec;
2616: CLOSE cur_get_ver;
2617:
2618: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2619: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','starting processing for '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));
2620: END IF;
2621: LOOP
2622: BEGIN

Line 2619: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','starting processing for '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));

2615: FETCH cur_get_ver INTO get_ver_rec;
2616: CLOSE cur_get_ver;
2617:
2618: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2619: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','starting processing for '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));
2620: END IF;
2621: LOOP
2622: BEGIN
2623: -- clear message stack

Line 2643: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2639: ELSIF awd_disb_rec.fed_fund_code IN ('PRK','FSEOG') THEN
2640: lv_fund_type := 'C'; -- Perkins, FSEOG Fund
2641: END IF;
2642:
2643: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_fund_type:'||lv_fund_type);
2645: END IF;
2646:
2647: ln_old_fund := ln_new_fund;

Line 2644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_fund_type:'||lv_fund_type);

2640: lv_fund_type := 'C'; -- Perkins, FSEOG Fund
2641: END IF;
2642:
2643: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_fund_type:'||lv_fund_type);
2645: END IF;
2646:
2647: ln_old_fund := ln_new_fund;
2648: ln_new_fund := awd_disb_rec.fund_id;

Line 2668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2664: fnd_message.set_token('DISB_NUM',TO_CHAR(awd_disb_rec.disb_num));
2665: fnd_file.put_line(fnd_file.log,RPAD(' ',15) ||fnd_message.get);
2666: fnd_file.new_line(fnd_file.log,1);
2667:
2668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.award_id:'||awd_disb_rec.award_id);
2670: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.disb_num:'||awd_disb_rec.disb_num);
2671: END IF;
2672:

Line 2669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.award_id:'||awd_disb_rec.award_id);

2665: fnd_file.put_line(fnd_file.log,RPAD(' ',15) ||fnd_message.get);
2666: fnd_file.new_line(fnd_file.log,1);
2667:
2668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.award_id:'||awd_disb_rec.award_id);
2670: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.disb_num:'||awd_disb_rec.disb_num);
2671: END IF;
2672:
2673: IF NVL(awd_disb_rec.disb_exp_dt,TRUNC(SYSDATE)+1) <= TRUNC(SYSDATE) THEN

Line 2670: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.disb_num:'||awd_disb_rec.disb_num);

2666: fnd_file.new_line(fnd_file.log,1);
2667:
2668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.award_id:'||awd_disb_rec.award_id);
2670: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.disb_num:'||awd_disb_rec.disb_num);
2671: END IF;
2672:
2673: IF NVL(awd_disb_rec.disb_exp_dt,TRUNC(SYSDATE)+1) <= TRUNC(SYSDATE) THEN
2674: fnd_message.set_name('IGF','IGF_DB_CANCEL_EXP');

Line 2681: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2677: -- 'Cancelling disbursement for award ,disbursement as expiration date has reached'
2678: p_result := fnd_message.get;
2679: fnd_file.put_line(fnd_file.log,RPAD(' ',15) ||p_result);
2680: revert_disb(awd_disb_rec.row_id,'X',lv_fund_type);
2681: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cancelled award '||awd_disb_rec.award_id||' '||awd_disb_rec.disb_num);
2683: END IF;
2684: -- Go to Next Record
2685: RAISE SKIP_RECORD;

Line 2682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cancelled award '||awd_disb_rec.award_id||' '||awd_disb_rec.disb_num);

2678: p_result := fnd_message.get;
2679: fnd_file.put_line(fnd_file.log,RPAD(' ',15) ||p_result);
2680: revert_disb(awd_disb_rec.row_id,'X',lv_fund_type);
2681: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cancelled award '||awd_disb_rec.award_id||' '||awd_disb_rec.disb_num);
2683: END IF;
2684: -- Go to Next Record
2685: RAISE SKIP_RECORD;
2686: END IF;

Line 2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2684: -- Go to Next Record
2685: RAISE SKIP_RECORD;
2686: END IF;
2687:
2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.force_disb:'||awd_disb_rec.force_disb);
2690: END IF;
2691: IF NVL(awd_disb_rec.force_disb,'N') ='Y' THEN
2692: --

Line 2689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.force_disb:'||awd_disb_rec.force_disb);

2685: RAISE SKIP_RECORD;
2686: END IF;
2687:
2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.force_disb:'||awd_disb_rec.force_disb);
2690: END IF;
2691: IF NVL(awd_disb_rec.force_disb,'N') ='Y' THEN
2692: --
2693: -- FA131 Changes

Line 2719: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2715: ELSE
2716: create_actual(awd_disb_rec.row_id,FALSE,TRUE,awd_disb_rec.fund_id);
2717: END IF;
2718: -- Go to Next Record
2719: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2720: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual for fund '||awd_disb_rec.fund_id);
2721: END IF;
2722: END IF;
2723:

Line 2720: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual for fund '||awd_disb_rec.fund_id);

2716: create_actual(awd_disb_rec.row_id,FALSE,TRUE,awd_disb_rec.fund_id);
2717: END IF;
2718: -- Go to Next Record
2719: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2720: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual for fund '||awd_disb_rec.fund_id);
2721: END IF;
2722: END IF;
2723:
2724: RAISE SKIP_RECORD;

Line 2741: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2737: --
2738: --
2739: IF ln_old_fund <> ln_new_fund THEN
2740:
2741: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','processing '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));
2743: END IF;
2744: -- For each new fund that is visible within this scope,
2745: -- the result variables are initialized

Line 2742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','processing '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));

2738: --
2739: IF ln_old_fund <> ln_new_fund THEN
2740:
2741: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','processing '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));
2743: END IF;
2744: -- For each new fund that is visible within this scope,
2745: -- the result variables are initialized
2746:

Line 2810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2806: p_result := fnd_message.get;
2807: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2808: END IF;
2809:
2810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2811:
2812: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_call_from <> FORM');
2813:
2814: IF NOT lb_hold_result THEN

Line 2812: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_call_from <> FORM');

2808: END IF;
2809:
2810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2811:
2812: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_call_from <> FORM');
2813:
2814: IF NOT lb_hold_result THEN
2815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment hold exist');
2816: ELSE

Line 2815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment hold exist');

2811:
2812: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_call_from <> FORM');
2813:
2814: IF NOT lb_hold_result THEN
2815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment hold exist');
2816: ELSE
2817: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment hold do not exist');
2818: END IF;
2819:

Line 2817: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment hold do not exist');

2813:
2814: IF NOT lb_hold_result THEN
2815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment hold exist');
2816: ELSE
2817: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment hold do not exist');
2818: END IF;
2819:
2820: IF NOT lb_todo_result THEN
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed to do items check');

Line 2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed to do items check');

2817: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment hold do not exist');
2818: END IF;
2819:
2820: IF NOT lb_todo_result THEN
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed to do items check');
2822: ELSE
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed to do items check');
2824: END IF;
2825:

Line 2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed to do items check');

2819:
2820: IF NOT lb_todo_result THEN
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed to do items check');
2822: ELSE
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed to do items check');
2824: END IF;
2825:
2826: IF NOT lb_pays_prg THEN
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pays only prog check');

Line 2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pays only prog check');

2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed to do items check');
2824: END IF;
2825:
2826: IF NOT lb_pays_prg THEN
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pays only prog check');
2828: ELSE
2829: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed pays only prog check');
2830: END IF;
2831:

Line 2829: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed pays only prog check');

2825:
2826: IF NOT lb_pays_prg THEN
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pays only prog check');
2828: ELSE
2829: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed pays only prog check');
2830: END IF;
2831:
2832: IF NOT lb_pays_uts THEN
2833: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pays only units check');

Line 2833: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pays only units check');

2829: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed pays only prog check');
2830: END IF;
2831:
2832: IF NOT lb_pays_uts THEN
2833: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pays only units check');
2834: ELSE
2835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed pays only units check');
2836: END IF;
2837:

Line 2835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed pays only units check');

2831:
2832: IF NOT lb_pays_uts THEN
2833: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pays only units check');
2834: ELSE
2835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed pays only units check');
2836: END IF;
2837:
2838: IF NOT lb_elig_result THEN
2839:

Line 2841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pell eligibilty check');

2837:
2838: IF NOT lb_elig_result THEN
2839:
2840: IF lv_fund_type = 'P' THEN
2841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pell eligibilty check');
2842: ELSE
2843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student..debug','passed pell eligibilty check');
2844: END IF;
2845:

Line 2843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student..debug','passed pell eligibilty check');

2839:
2840: IF lv_fund_type = 'P' THEN
2841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed pell eligibilty check');
2842: ELSE
2843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student..debug','passed pell eligibilty check');
2844: END IF;
2845:
2846: IF lv_fund_type IN ('D','F') THEN
2847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed NSLDS eligibilty check');

Line 2847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed NSLDS eligibilty check');

2843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student..debug','passed pell eligibilty check');
2844: END IF;
2845:
2846: IF lv_fund_type IN ('D','F') THEN
2847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed NSLDS eligibilty check');
2848: ELSE
2849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed NSLDS eligibilty check');
2850: END IF;
2851:

Line 2849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed NSLDS eligibilty check');

2845:
2846: IF lv_fund_type IN ('D','F') THEN
2847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','failed NSLDS eligibilty check');
2848: ELSE
2849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','passed NSLDS eligibilty check');
2850: END IF;
2851:
2852: END IF; -- Pell Elig
2853:

Line 2854: END IF; -- FND Log End If

2850: END IF;
2851:
2852: END IF; -- Pell Elig
2853:
2854: END IF; -- FND Log End If
2855:
2856: END IF; -- old fund id not new fund
2857:
2858: --

Line 2877: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2873: lb_active_result := TRUE;
2874: lb_orig_result := TRUE;
2875: lb_prom_result := TRUE;
2876:
2877: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_fund_type:'||lv_fund_type);
2879: END IF;
2880:
2881: IF lv_fund_type IN ('D','F') THEN

Line 2878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_fund_type:'||lv_fund_type);

2874: lb_orig_result := TRUE;
2875: lb_prom_result := TRUE;
2876:
2877: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_fund_type:'||lv_fund_type);
2879: END IF;
2880:
2881: IF lv_fund_type IN ('D','F') THEN
2882: OPEN cur_get_loans (awd_disb_rec.award_id);

Line 2891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2887: fnd_message.set_name('IGF','IGF_SL_LOAN_ID_NOT_FOUND');
2888: p_result := fnd_message.get;
2889: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2890: -- message ' Loan Not created for this award '
2891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_get_loans%NOTFOUND');
2893: END IF;
2894: ELSIF cur_get_loans%FOUND THEN
2895: IF NVL(get_loans_rec.active,'N') <> 'Y' THEN

Line 2892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_get_loans%NOTFOUND');

2888: p_result := fnd_message.get;
2889: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2890: -- message ' Loan Not created for this award '
2891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_get_loans%NOTFOUND');
2893: END IF;
2894: ELSIF cur_get_loans%FOUND THEN
2895: IF NVL(get_loans_rec.active,'N') <> 'Y' THEN
2896: fnd_message.set_name('IGF','IGF_DB_LOAN_INACTIVE');

Line 2901: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2897: fnd_message.set_token('LOAN_NUMBER',get_loans_rec.loan_number);
2898: p_result := fnd_message.get;
2899: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2900: lb_active_result := FALSE;
2901: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2902: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan '||get_loans_rec.loan_number||' is inactive');
2903: END IF;
2904: END IF;
2905:

Line 2902: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan '||get_loans_rec.loan_number||' is inactive');

2898: p_result := fnd_message.get;
2899: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2900: lb_active_result := FALSE;
2901: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2902: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan '||get_loans_rec.loan_number||' is inactive');
2903: END IF;
2904: END IF;
2905:
2906: CLOSE cur_get_loans;

Line 2919: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2915: fnd_message.set_name('IGF','IGF_DB_LOAN_ORIG_NOT_FOUND');
2916: p_result := fnd_message.get;
2917: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2918: -- message ' Loan Not created for this award '
2919: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2920: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan not created for '||get_loans_rec.loan_id);
2921: END IF;
2922:
2923: ELSIF cur_pnote_stat%FOUND THEN

Line 2920: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan not created for '||get_loans_rec.loan_id);

2916: p_result := fnd_message.get;
2917: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2918: -- message ' Loan Not created for this award '
2919: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2920: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan not created for '||get_loans_rec.loan_id);
2921: END IF;
2922:
2923: ELSIF cur_pnote_stat%FOUND THEN
2924: CLOSE cur_pnote_stat;

Line 2925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2921: END IF;
2922:
2923: ELSIF cur_pnote_stat%FOUND THEN
2924: CLOSE cur_pnote_stat;
2925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.org_record_req:'||awd_disb_rec.org_record_req);
2927: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_loans_rec.loan_status:'||get_loans_rec.loan_status);
2928: END IF;
2929: IF NVL(awd_disb_rec.org_record_req,'N') = 'Y' THEN

Line 2926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.org_record_req:'||awd_disb_rec.org_record_req);

2922:
2923: ELSIF cur_pnote_stat%FOUND THEN
2924: CLOSE cur_pnote_stat;
2925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.org_record_req:'||awd_disb_rec.org_record_req);
2927: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_loans_rec.loan_status:'||get_loans_rec.loan_status);
2928: END IF;
2929: IF NVL(awd_disb_rec.org_record_req,'N') = 'Y' THEN
2930: IF NVL(get_loans_rec.loan_status,'N') <>'A' THEN

Line 2927: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_loans_rec.loan_status:'||get_loans_rec.loan_status);

2923: ELSIF cur_pnote_stat%FOUND THEN
2924: CLOSE cur_pnote_stat;
2925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.org_record_req:'||awd_disb_rec.org_record_req);
2927: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_loans_rec.loan_status:'||get_loans_rec.loan_status);
2928: END IF;
2929: IF NVL(awd_disb_rec.org_record_req,'N') = 'Y' THEN
2930: IF NVL(get_loans_rec.loan_status,'N') <>'A' THEN
2931: fnd_message.set_name('IGF','IGF_DB_LOAN_ORIG_NOT_ACC');

Line 2937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2933: p_result := fnd_message.get;
2934: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2935:
2936: lb_orig_result := FALSE;
2937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan not accepted');
2939: END IF;
2940: END IF;
2941: END IF;

Line 2938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan not accepted');

2934: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2935:
2936: lb_orig_result := FALSE;
2937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan not accepted');
2939: END IF;
2940: END IF;
2941: END IF;
2942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','loan not accepted');
2939: END IF;
2940: END IF;
2941: END IF;
2942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2943: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.prom_note_req:'||awd_disb_rec.prom_note_req);
2944: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.pnote_status:'||pnote_stat_rec.pnote_status);
2945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.mpn_confirm_code:'||pnote_stat_rec.pnote_status);
2946: END IF;

Line 2943: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.prom_note_req:'||awd_disb_rec.prom_note_req);

2939: END IF;
2940: END IF;
2941: END IF;
2942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2943: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.prom_note_req:'||awd_disb_rec.prom_note_req);
2944: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.pnote_status:'||pnote_stat_rec.pnote_status);
2945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.mpn_confirm_code:'||pnote_stat_rec.pnote_status);
2946: END IF;
2947: IF NVL(awd_disb_rec.prom_note_req,'N') = 'Y' THEN

Line 2944: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.pnote_status:'||pnote_stat_rec.pnote_status);

2940: END IF;
2941: END IF;
2942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2943: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.prom_note_req:'||awd_disb_rec.prom_note_req);
2944: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.pnote_status:'||pnote_stat_rec.pnote_status);
2945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.mpn_confirm_code:'||pnote_stat_rec.pnote_status);
2946: END IF;
2947: IF NVL(awd_disb_rec.prom_note_req,'N') = 'Y' THEN
2948: -- bvisvana - Bug # 4575843 - Promissory Note check for CL 4 also included

Line 2945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.mpn_confirm_code:'||pnote_stat_rec.pnote_status);

2941: END IF;
2942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2943: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.prom_note_req:'||awd_disb_rec.prom_note_req);
2944: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.pnote_status:'||pnote_stat_rec.pnote_status);
2945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','pnote_stat_rec.mpn_confirm_code:'||pnote_stat_rec.pnote_status);
2946: END IF;
2947: IF NVL(awd_disb_rec.prom_note_req,'N') = 'Y' THEN
2948: -- bvisvana - Bug # 4575843 - Promissory Note check for CL 4 also included
2949: lb_invalid_pnote := FALSE;

Line 2969: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2965: fnd_message.set_name('IGF','IGF_DB_PNOTE_NOT_ACC');
2966: p_result := fnd_message.get;
2967: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2968: -- message 'Prom Note not accepted'
2969: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2970: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','prom note not accepted');
2971: END IF;
2972: END IF;
2973: END IF;

Line 2970: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','prom note not accepted');

2966: p_result := fnd_message.get;
2967: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2968: -- message 'Prom Note not accepted'
2969: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2970: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','prom note not accepted');
2971: END IF;
2972: END IF;
2973: END IF;
2974: END IF;

Line 2992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2988: fnd_message.set_name('IGF','IGF_DB_GRANT_ID_NOT_FOUND');
2989: p_result := fnd_message.get;
2990: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2991: -- message 'Pell Origination record not found'
2992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_get_pell%NOTFOUND');
2994: END IF;
2995: ELSIF cur_get_pell%FOUND THEN
2996: CLOSE cur_get_pell;

Line 2993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_get_pell%NOTFOUND');

2989: p_result := fnd_message.get;
2990: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
2991: -- message 'Pell Origination record not found'
2992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_get_pell%NOTFOUND');
2994: END IF;
2995: ELSIF cur_get_pell%FOUND THEN
2996: CLOSE cur_get_pell;
2997: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2997: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','cur_get_pell%NOTFOUND');
2994: END IF;
2995: ELSIF cur_get_pell%FOUND THEN
2996: CLOSE cur_get_pell;
2997: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2998: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_pell_rec.orig_action_code:'||get_pell_rec.orig_action_code);
2999: END IF;
3000: IF NVL(get_pell_rec.orig_action_code,'N') <> 'A' THEN
3001: lb_orig_result := FALSE;

Line 2998: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_pell_rec.orig_action_code:'||get_pell_rec.orig_action_code);

2994: END IF;
2995: ELSIF cur_get_pell%FOUND THEN
2996: CLOSE cur_get_pell;
2997: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2998: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_pell_rec.orig_action_code:'||get_pell_rec.orig_action_code);
2999: END IF;
3000: IF NVL(get_pell_rec.orig_action_code,'N') <> 'A' THEN
3001: lb_orig_result := FALSE;
3002: fnd_message.set_name('IGF','IGF_DB_GRANT_ORIG_NOT_ACC');

Line 3007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3003: fnd_message.set_token('ORIGINATION_ID',get_pell_rec.origination_id);
3004: p_result := fnd_message.get;
3005: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3006: -- message 'Origination not accepted'
3007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3008: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','orig not accepted');
3009: END IF;
3010: END IF;
3011: END IF;

Line 3008: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','orig not accepted');

3004: p_result := fnd_message.get;
3005: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3006: -- message 'Origination not accepted'
3007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3008: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','orig not accepted');
3009: END IF;
3010: END IF;
3011: END IF;
3012: END IF;

Line 3112: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3108:
3109: fnd_message.set_name('IGF','IGF_DB_CL_DISB_NOT_ACC');
3110: p_result := fnd_message.get;
3111: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3112: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment not accepted');
3114: END IF;
3115: END IF;
3116: END IF;

Line 3113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment not accepted');

3109: fnd_message.set_name('IGF','IGF_DB_CL_DISB_NOT_ACC');
3110: p_result := fnd_message.get;
3111: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3112: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment not accepted');
3114: END IF;
3115: END IF;
3116: END IF;
3117:

Line 3129: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3125:
3126: fnd_message.set_name('IGF','IGF_DB_GRANT_DISB_NOT_FOUND');
3127: p_result := fnd_message.get;
3128: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3129: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment records not found');
3131: END IF;
3132: ELSIF cur_get_disb%FOUND THEN
3133: CLOSE cur_get_disb;

Line 3130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment records not found');

3126: fnd_message.set_name('IGF','IGF_DB_GRANT_DISB_NOT_FOUND');
3127: p_result := fnd_message.get;
3128: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3129: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','disbursment records not found');
3131: END IF;
3132: ELSIF cur_get_disb%FOUND THEN
3133: CLOSE cur_get_disb;
3134: IF NVL(get_disb_rec.disb_ack_act_status,'N') NOT IN ('A','C') THEN

Line 3140: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3136: fnd_message.set_name('IGF','IGF_DB_GRANT_DISB_NOT_ACC');
3137: fnd_message.set_token('ORIGINATION_ID',get_pell_rec.origination_id);
3138: p_result := fnd_message.get;
3139: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3140: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3141: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug',get_pell_rec.origination_id||' not accepted');
3142: END IF;
3143: END IF;
3144: END IF;

Line 3141: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug',get_pell_rec.origination_id||' not accepted');

3137: fnd_message.set_token('ORIGINATION_ID',get_pell_rec.origination_id);
3138: p_result := fnd_message.get;
3139: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3140: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3141: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug',get_pell_rec.origination_id||' not accepted');
3142: END IF;
3143: END IF;
3144: END IF;
3145: END IF;

Line 3155: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3151: fnd_message.set_name('IGF','IGF_DB_CL_NOT_FUNDED');
3152: p_result := fnd_message.get;
3153: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3154: lb_recv_result := FALSE;
3155: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3156: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','funds are not yet received');
3157: END IF;
3158: END IF;
3159: END IF;

Line 3156: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','funds are not yet received');

3152: p_result := fnd_message.get;
3153: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3154: lb_recv_result := FALSE;
3155: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3156: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','funds are not yet received');
3157: END IF;
3158: END IF;
3159: END IF;
3160: END IF;

Line 3167: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3163: -- Get the Academic Year information
3164:
3165: lb_cp_result := TRUE;
3166: IF awd_disb_rec.min_credit_pts IS NOT NULL THEN
3167: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.min_credit_pts:'||awd_disb_rec.min_credit_pts);
3169: END IF;
3170: igs_en_prc_load.enrp_clc_cp_upto_tp_start_dt(
3171: igf_gr_gen.get_person_id(awd_disb_rec.base_id),

Line 3168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.min_credit_pts:'||awd_disb_rec.min_credit_pts);

3164:
3165: lb_cp_result := TRUE;
3166: IF awd_disb_rec.min_credit_pts IS NOT NULL THEN
3167: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.min_credit_pts:'||awd_disb_rec.min_credit_pts);
3169: END IF;
3170: igs_en_prc_load.enrp_clc_cp_upto_tp_start_dt(
3171: igf_gr_gen.get_person_id(awd_disb_rec.base_id),
3172: awd_disb_rec.ld_cal_type,

Line 3182: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3178: ),
3179: ln_credit_pts
3180: );
3181:
3182: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3183: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_credit_pts:'||ln_credit_pts);
3184: END IF;
3185: IF NVL(ln_credit_pts,0) < NVL(awd_disb_rec.min_credit_pts,0) THEN
3186: lb_cp_result := FALSE;

Line 3183: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_credit_pts:'||ln_credit_pts);

3179: ln_credit_pts
3180: );
3181:
3182: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3183: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','ln_credit_pts:'||ln_credit_pts);
3184: END IF;
3185: IF NVL(ln_credit_pts,0) < NVL(awd_disb_rec.min_credit_pts,0) THEN
3186: lb_cp_result := FALSE;
3187: --

Line 3198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3194: END IF;
3195:
3196: lb_att_result := TRUE;
3197: IF awd_disb_rec.attendance_type_code IS NOT NULL THEN
3198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.attendance_type_code:'||awd_disb_rec.attendance_type_code);
3200: END IF;
3201: p_message := NULL;
3202: lb_att_result := chk_att_result(awd_disb_rec.base_id,

Line 3199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.attendance_type_code:'||awd_disb_rec.attendance_type_code);

3195:
3196: lb_att_result := TRUE;
3197: IF awd_disb_rec.attendance_type_code IS NOT NULL THEN
3198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.attendance_type_code:'||awd_disb_rec.attendance_type_code);
3200: END IF;
3201: p_message := NULL;
3202: lb_att_result := chk_att_result(awd_disb_rec.base_id,
3203: awd_disb_rec.ld_cal_type,

Line 3219: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3215: p_result := p_message ||fnd_global.newline ||p_result;
3216: END IF;
3217: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3218:
3219: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3220: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','min attendance type check failed');
3221: END IF;
3222: END IF;
3223:

Line 3220: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','min attendance type check failed');

3216: END IF;
3217: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3218:
3219: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3220: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','min attendance type check failed');
3221: END IF;
3222: END IF;
3223:
3224: --

Line 3227: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3223:
3224: --
3225: -- Based on these results, create actual record
3226: --
3227: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3228: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_ver_rec.fed_verif_status:'||get_ver_rec.fed_verif_status);
3229: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ver_app_stat_override:'||awd_disb_rec.ver_app_stat_override);
3230: END IF;
3231:

Line 3228: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_ver_rec.fed_verif_status:'||get_ver_rec.fed_verif_status);

3224: --
3225: -- Based on these results, create actual record
3226: --
3227: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3228: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_ver_rec.fed_verif_status:'||get_ver_rec.fed_verif_status);
3229: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ver_app_stat_override:'||awd_disb_rec.ver_app_stat_override);
3230: END IF;
3231:
3232: IF lv_fund_type = 'D' THEN

Line 3229: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ver_app_stat_override:'||awd_disb_rec.ver_app_stat_override);

3225: -- Based on these results, create actual record
3226: --
3227: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3228: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','get_ver_rec.fed_verif_status:'||get_ver_rec.fed_verif_status);
3229: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.ver_app_stat_override:'||awd_disb_rec.ver_app_stat_override);
3230: END IF;
3231:
3232: IF lv_fund_type = 'D' THEN
3233: IF lb_todo_result AND

Line 3256: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3252: lb_send_wdoc := TRUE;
3253: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3254: p_result := fnd_message.get;
3255: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3256: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3257: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','first disb without doc');
3258: END IF;
3259: ELSE
3260: lb_send_wdoc := FALSE;

Line 3257: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','first disb without doc');

3253: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3254: p_result := fnd_message.get;
3255: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3256: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3257: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','first disb without doc');
3258: END IF;
3259: ELSE
3260: lb_send_wdoc := FALSE;
3261: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');

Line 3264: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3260: lb_send_wdoc := FALSE;
3261: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');
3262: p_result := fnd_message.get;
3263: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3264: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3265: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');
3266: END IF;
3267: END IF;
3268: ELSE

Line 3265: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');

3261: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');
3262: p_result := fnd_message.get;
3263: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3264: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3265: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');
3266: END IF;
3267: END IF;
3268: ELSE
3269: fnd_message.set_name('IGF','IGF_DB_FAIL_VERF_STAT');

Line 3273: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3269: fnd_message.set_name('IGF','IGF_DB_FAIL_VERF_STAT');
3270: p_result := fnd_message.get;
3271: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3272: lb_send_wdoc := FALSE;
3273: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3274: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');
3275: END IF;
3276: END IF;
3277: END IF;

Line 3274: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');

3270: p_result := fnd_message.get;
3271: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3272: lb_send_wdoc := FALSE;
3273: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3274: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');
3275: END IF;
3276: END IF;
3277: END IF;
3278: END IF;

Line 3282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3278: END IF;
3279:
3280: IF lb_send_wdoc THEN
3281: create_actual(awd_disb_rec.row_id,TRUE,FALSE,awd_disb_rec.fund_id);
3282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3284: END IF;
3285: END IF;
3286: END IF;

Line 3283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);

3279:
3280: IF lb_send_wdoc THEN
3281: create_actual(awd_disb_rec.row_id,TRUE,FALSE,awd_disb_rec.fund_id);
3282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3284: END IF;
3285: END IF;
3286: END IF;
3287: ELSIF lv_fund_type = 'F' THEN

Line 3314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3310: lb_send_wdoc := TRUE;
3311: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3312: p_result := fnd_message.get;
3313: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');
3316: END IF;
3317: ELSE
3318: lb_send_wdoc := FALSE;

Line 3315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');

3311: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3312: p_result := fnd_message.get;
3313: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');
3316: END IF;
3317: ELSE
3318: lb_send_wdoc := FALSE;
3319: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');

Line 3322: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3318: lb_send_wdoc := FALSE;
3319: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');
3320: p_result := fnd_message.get;
3321: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3322: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3323: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');
3324: END IF;
3325: END IF;
3326: ELSE

Line 3323: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');

3319: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');
3320: p_result := fnd_message.get;
3321: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3322: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3323: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');
3324: END IF;
3325: END IF;
3326: ELSE
3327: fnd_message.set_name('IGF','IGF_DB_FAIL_VERF_STAT');

Line 3331: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3327: fnd_message.set_name('IGF','IGF_DB_FAIL_VERF_STAT');
3328: p_result := fnd_message.get;
3329: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3330: lb_send_wdoc := FALSE;
3331: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3332: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');
3333: END IF;
3334: END IF;
3335: END IF;

Line 3332: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');

3328: p_result := fnd_message.get;
3329: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3330: lb_send_wdoc := FALSE;
3331: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3332: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');
3333: END IF;
3334: END IF;
3335: END IF;
3336: END IF;

Line 3340: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3336: END IF;
3337:
3338: IF lb_send_wdoc THEN
3339: create_actual(awd_disb_rec.row_id,TRUE,FALSE,awd_disb_rec.fund_id);
3340: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3342: END IF;
3343: END IF;
3344: END IF;

Line 3341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);

3337:
3338: IF lb_send_wdoc THEN
3339: create_actual(awd_disb_rec.row_id,TRUE,FALSE,awd_disb_rec.fund_id);
3340: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3342: END IF;
3343: END IF;
3344: END IF;
3345: ELSIF lv_fund_type = 'P' THEN

Line 3370: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3366: lb_send_wdoc := TRUE;
3367: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3368: p_result := fnd_message.get;
3369: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3370: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');
3372: END IF;
3373: ELSE
3374: lb_send_wdoc := FALSE;

Line 3371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');

3367: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3368: p_result := fnd_message.get;
3369: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3370: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');
3372: END IF;
3373: ELSE
3374: lb_send_wdoc := FALSE;
3375: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');

Line 3378: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3374: lb_send_wdoc := FALSE;
3375: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');
3376: p_result := fnd_message.get;
3377: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3378: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3379: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');
3380: END IF;
3381: END IF;
3382: ELSE

Line 3379: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');

3375: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');
3376: p_result := fnd_message.get;
3377: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3378: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3379: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');
3380: END IF;
3381: END IF;
3382: ELSE
3383: fnd_message.set_name('IGF','IGF_DB_FAIL_VERF_STAT');

Line 3387: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3383: fnd_message.set_name('IGF','IGF_DB_FAIL_VERF_STAT');
3384: p_result := fnd_message.get;
3385: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3386: lb_send_wdoc := FALSE;
3387: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3388: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');
3389: END IF;
3390: END IF;
3391: END IF;

Line 3388: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');

3384: p_result := fnd_message.get;
3385: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3386: lb_send_wdoc := FALSE;
3387: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3388: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');
3389: END IF;
3390: END IF;
3391: END IF;
3392: END IF;

Line 3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3392: END IF;
3393:
3394: IF lb_send_wdoc THEN
3395: create_actual(awd_disb_rec.row_id,TRUE,FALSE,awd_disb_rec.fund_id);
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3398: END IF;
3399: END IF;
3400: END IF;

Line 3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);

3393:
3394: IF lb_send_wdoc THEN
3395: create_actual(awd_disb_rec.row_id,TRUE,FALSE,awd_disb_rec.fund_id);
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3398: END IF;
3399: END IF;
3400: END IF;
3401: ELSIF lv_fund_type = 'C' THEN

Line 3422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3418: lb_send_wdoc := TRUE;
3419: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3420: p_result := fnd_message.get;
3421: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');
3424: END IF;
3425: ELSE
3426: lb_send_wdoc := FALSE;

Line 3423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');

3419: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3420: p_result := fnd_message.get;
3421: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igd_db_disb.process_student.debug','verf is not without doc.first disb without doc');
3424: END IF;
3425: ELSE
3426: lb_send_wdoc := FALSE;
3427: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');

Line 3430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3426: lb_send_wdoc := FALSE;
3427: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');
3428: p_result := fnd_message.get;
3429: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');
3432: END IF;
3433: END IF;
3434: ELSE

Line 3431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');

3427: fnd_message.set_name('IGF','IGF_DB_FAIL_SEC_VER');
3428: p_result := fnd_message.get;
3429: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc.cannot make disb');
3432: END IF;
3433: END IF;
3434: ELSE
3435: fnd_message.set_name('IGF','IGF_DB_FAIL_VERF_STAT');

Line 3439: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3435: fnd_message.set_name('IGF','IGF_DB_FAIL_VERF_STAT');
3436: p_result := fnd_message.get;
3437: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3438: lb_send_wdoc := FALSE;
3439: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');
3441: END IF;
3442: END IF;
3443: END IF;

Line 3440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');

3436: p_result := fnd_message.get;
3437: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3438: lb_send_wdoc := FALSE;
3439: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3440: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','without doc');
3441: END IF;
3442: END IF;
3443: END IF;
3444: END IF;

Line 3448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3444: END IF;
3445:
3446: IF lb_send_wdoc THEN
3447: create_actual(awd_disb_rec.row_id,TRUE,FALSE,awd_disb_rec.fund_id);
3448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3449: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3450: END IF;
3451: END IF;
3452: END IF;

Line 3449: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);

3445:
3446: IF lb_send_wdoc THEN
3447: create_actual(awd_disb_rec.row_id,TRUE,FALSE,awd_disb_rec.fund_id);
3448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3449: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3450: END IF;
3451: END IF;
3452: END IF;
3453: ELSE

Line 3462: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3458: lb_att_result AND
3459: lb_hold_result AND
3460: lb_cp_result THEN
3461: create_actual(awd_disb_rec.row_id,FALSE,FALSE,awd_disb_rec.fund_id);
3462: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3463: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3464: END IF;
3465: END IF;
3466: END IF;

Line 3463: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);

3459: lb_hold_result AND
3460: lb_cp_result THEN
3461: create_actual(awd_disb_rec.row_id,FALSE,FALSE,awd_disb_rec.fund_id);
3462: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3463: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called create_actual with fund_id '||awd_disb_rec.fund_id);
3464: END IF;
3465: END IF;
3466: END IF;
3467:

Line 3514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3510: l_course_cd,
3511: l_ver_num,
3512: lv_acad_cal_type,
3513: ln_acad_seq_num);
3514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called disb_verf_enf');
3516: END IF;
3517: END IF;
3518:

Line 3515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called disb_verf_enf');

3511: l_ver_num,
3512: lv_acad_cal_type,
3513: ln_acad_seq_num);
3514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called disb_verf_enf');
3516: END IF;
3517: END IF;
3518:
3519: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3519: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called disb_verf_enf');
3516: END IF;
3517: END IF;
3518:
3519: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3520: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_call_from:'||lv_call_from);
3521: END IF;
3522:
3523: --lock COA at the student level

Line 3520: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_call_from:'||lv_call_from);

3516: END IF;
3517: END IF;
3518:
3519: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3520: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','lv_call_from:'||lv_call_from);
3521: END IF;
3522:
3523: --lock COA at the student level
3524: IF lv_profile_value IS NULL THEN

Line 3531: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3527: END IF;
3528:
3529: IF lv_profile_value = 'DISBURSED' THEN
3530:
3531: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3532: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling igf_aw_coa_gen.doLock for base_id '||p_base_id);
3533: END IF;
3534:
3535: IF NOT igf_aw_coa_gen.isCOALocked(p_base_id) THEN

Line 3532: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling igf_aw_coa_gen.doLock for base_id '||p_base_id);

3528:
3529: IF lv_profile_value = 'DISBURSED' THEN
3530:
3531: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3532: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling igf_aw_coa_gen.doLock for base_id '||p_base_id);
3533: END IF;
3534:
3535: IF NOT igf_aw_coa_gen.isCOALocked(p_base_id) THEN
3536: lv_locking_success := igf_aw_coa_gen.doLock(p_base_id);

Line 3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3689:
3690: l_ci_cal_type := RTRIM(SUBSTR(p_award_year,1,10));
3691: l_ci_sequence_number := RTRIM(SUBSTR(p_award_year,11));
3692:
3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_cal_type:'||l_ci_cal_type);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_sequence_number:'||l_ci_sequence_number);
3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);
3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);

Line 3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_cal_type:'||l_ci_cal_type);

3690: l_ci_cal_type := RTRIM(SUBSTR(p_award_year,1,10));
3691: l_ci_sequence_number := RTRIM(SUBSTR(p_award_year,11));
3692:
3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_cal_type:'||l_ci_cal_type);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_sequence_number:'||l_ci_sequence_number);
3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);
3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);
3698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_per_grp_id:'||p_per_grp_id);

Line 3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_sequence_number:'||l_ci_sequence_number);

3691: l_ci_sequence_number := RTRIM(SUBSTR(p_award_year,11));
3692:
3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_cal_type:'||l_ci_cal_type);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_sequence_number:'||l_ci_sequence_number);
3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);
3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);
3698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_per_grp_id:'||p_per_grp_id);
3699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_base_id:'||p_base_id);

Line 3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);

3692:
3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_cal_type:'||l_ci_cal_type);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_sequence_number:'||l_ci_sequence_number);
3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);
3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);
3698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_per_grp_id:'||p_per_grp_id);
3699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_base_id:'||p_base_id);
3700: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_fund_id:'||p_fund_id);

Line 3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);

3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_cal_type:'||l_ci_cal_type);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_sequence_number:'||l_ci_sequence_number);
3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);
3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);
3698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_per_grp_id:'||p_per_grp_id);
3699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_base_id:'||p_base_id);
3700: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_fund_id:'||p_fund_id);
3701: END IF;

Line 3698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_per_grp_id:'||p_per_grp_id);

3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_cal_type:'||l_ci_cal_type);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_sequence_number:'||l_ci_sequence_number);
3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);
3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);
3698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_per_grp_id:'||p_per_grp_id);
3699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_base_id:'||p_base_id);
3700: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_fund_id:'||p_fund_id);
3701: END IF;
3702:

Line 3699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_base_id:'||p_base_id);

3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','l_ci_sequence_number:'||l_ci_sequence_number);
3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);
3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);
3698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_per_grp_id:'||p_per_grp_id);
3699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_base_id:'||p_base_id);
3700: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_fund_id:'||p_fund_id);
3701: END IF;
3702:
3703: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL THEN

Line 3700: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_fund_id:'||p_fund_id);

3696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_award_year:'||p_award_year);
3697: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_run_for:'||p_run_for);
3698: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_per_grp_id:'||p_per_grp_id);
3699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_base_id:'||p_base_id);
3700: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','p_fund_id:'||p_fund_id);
3701: END IF;
3702:
3703: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL THEN
3704:

Line 3776: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3772: END IF;
3773:
3774: FETCH cur_per_grp INTO l_person_id;
3775:
3776: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3777: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Starting to process person group '||p_per_grp_id);
3778: END IF;
3779:
3780: IF cur_per_grp%NOTFOUND THEN

Line 3777: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Starting to process person group '||p_per_grp_id);

3773:
3774: FETCH cur_per_grp INTO l_person_id;
3775:
3776: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3777: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Starting to process person group '||p_per_grp_id);
3778: END IF;
3779:
3780: IF cur_per_grp%NOTFOUND THEN
3781: CLOSE cur_per_grp;

Line 3785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3781: CLOSE cur_per_grp;
3782: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
3783: -- No student found in Person Group
3784: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || fnd_message.get);
3785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3786: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','No persons in group '||p_per_grp_id);
3787: END IF;
3788: ELSE
3789: IF cur_per_grp%FOUND THEN

Line 3786: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','No persons in group '||p_per_grp_id);

3782: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
3783: -- No student found in Person Group
3784: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || fnd_message.get);
3785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3786: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','No persons in group '||p_per_grp_id);
3787: END IF;
3788: ELSE
3789: IF cur_per_grp%FOUND THEN
3790: fnd_message.set_name('IGF','IGF_DB_PROCESS_PER_GRP');

Line 3812: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3808: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
3809: fnd_message.set_token('STDNT',lv_person_number);
3810: fnd_file.put_line(fnd_file.log,fnd_message.get);
3811:
3812: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3813: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Processing student '||lv_person_number);
3814: END IF;
3815: --
3816: -- Check for Academic Holds, only if con job is run

Line 3813: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Processing student '||lv_person_number);

3809: fnd_message.set_token('STDNT',lv_person_number);
3810: fnd_file.put_line(fnd_file.log,fnd_message.get);
3811:
3812: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3813: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Processing student '||lv_person_number);
3814: END IF;
3815: --
3816: -- Check for Academic Holds, only if con job is run
3817: --

Line 3821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3817: --
3818: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(ln_base_id)) = 'F' THEN
3819: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3820: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3823: END IF;
3824: ELSE
3825: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');

3818: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(ln_base_id)) = 'F' THEN
3819: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3820: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3823: END IF;
3824: ELSE
3825: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||ln_base_id);

Line 3825: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3823: END IF;
3824: ELSE
3825: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||ln_base_id);
3827: END IF;
3828: process_student(ln_base_id,lv_result);
3829:

Line 3826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||ln_base_id);

3822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3823: END IF;
3824: ELSE
3825: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||ln_base_id);
3827: END IF;
3828: process_student(ln_base_id,lv_result);
3829:
3830:

Line 3837: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3833: -- End of processing for person number
3834: fnd_message.set_token('PER_NUM',lv_person_number);
3835: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3836: fnd_file.new_line(fnd_file.log,1);
3837: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3838: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);
3839: END IF;
3840: ELSE
3841: -- log a message and skip this person

Line 3838: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);

3834: fnd_message.set_token('PER_NUM',lv_person_number);
3835: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3836: fnd_file.new_line(fnd_file.log,1);
3837: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3838: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);
3839: END IF;
3840: ELSE
3841: -- log a message and skip this person
3842: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');

Line 3847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3843: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
3844: fnd_message.set_token('AWD_YR',l_award_det.alternate_code);
3845: -- Person PER_NUM does not exist in FA
3846: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
3849: END IF;
3850: END IF;
3851:

Line 3848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');

3844: fnd_message.set_token('AWD_YR',l_award_det.alternate_code);
3845: -- Person PER_NUM does not exist in FA
3846: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
3849: END IF;
3850: END IF;
3851:
3852: ELSE

Line 3874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3870: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
3871: fnd_message.set_token('STDNT',lv_person_number);
3872: fnd_file.put_line(fnd_file.log,fnd_message.get);
3873:
3874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3875: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Starting processing single student '||lv_person_number);
3876: END IF;
3877: --
3878: -- Check for Academic Holds, only if con job is run

Line 3875: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Starting processing single student '||lv_person_number);

3871: fnd_message.set_token('STDNT',lv_person_number);
3872: fnd_file.put_line(fnd_file.log,fnd_message.get);
3873:
3874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3875: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','Starting processing single student '||lv_person_number);
3876: END IF;
3877: --
3878: -- Check for Academic Holds, only if con job is run
3879: --

Line 3884: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3880:
3881: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(p_base_id)) = 'F' THEN
3882: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3883: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3884: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3886: END IF;
3887:
3888: ELSE

Line 3885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');

3881: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(p_base_id)) = 'F' THEN
3882: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3883: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3884: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3886: END IF;
3887:
3888: ELSE
3889: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3889: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3886: END IF;
3887:
3888: ELSE
3889: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3890: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||p_base_id);
3891: END IF;
3892: process_student(p_base_id,lv_result);
3893:

Line 3890: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||p_base_id);

3886: END IF;
3887:
3888: ELSE
3889: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3890: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||p_base_id);
3891: END IF;
3892: process_student(p_base_id,lv_result);
3893:
3894: END IF;

Line 3900: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3896: -- End of processing for person number
3897: fnd_message.set_token('PER_NUM',lv_person_number);
3898: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3899: fnd_file.new_line(fnd_file.log,1);
3900: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);
3902: END IF;
3903:
3904: ELSIF p_run_for = 'F' AND p_fund_id IS NOT NULL THEN

Line 3901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);

3897: fnd_message.set_token('PER_NUM',lv_person_number);
3898: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3899: fnd_file.new_line(fnd_file.log,1);
3900: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);
3902: END IF;
3903:
3904: ELSIF p_run_for = 'F' AND p_fund_id IS NOT NULL THEN
3905:

Line 3910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3906: -- Get all the Students for which the Award is given
3907: OPEN cur_award_std (p_fund_id);
3908: FETCH cur_award_std INTO award_std_rec;
3909:
3910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3911: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','starting processing for fund_id '||p_fund_id);
3912: END IF;
3913:
3914: IF cur_award_std%NOTFOUND THEN

Line 3911: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','starting processing for fund_id '||p_fund_id);

3907: OPEN cur_award_std (p_fund_id);
3908: FETCH cur_award_std INTO award_std_rec;
3909:
3910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3911: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','starting processing for fund_id '||p_fund_id);
3912: END IF;
3913:
3914: IF cur_award_std%NOTFOUND THEN
3915: CLOSE cur_award_std;

Line 3920: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3916: fnd_message.set_name('IGF','IGF_DB_NO_AWARDS');
3917: fnd_message.set_token('FDESC',get_fund_desc(p_fund_id));
3918: -- No Awards found for this Fund : < fund desc >
3919: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
3920: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3921: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','No award for fund '||get_fund_desc(p_fund_id));
3922: END IF;
3923: ELSE
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3921: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','No award for fund '||get_fund_desc(p_fund_id));

3917: fnd_message.set_token('FDESC',get_fund_desc(p_fund_id));
3918: -- No Awards found for this Fund : < fund desc >
3919: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
3920: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3921: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','No award for fund '||get_fund_desc(p_fund_id));
3922: END IF;
3923: ELSE
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3925: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','award_std_rec.fed_fund_code:'||award_std_rec.fed_fund_code);

Line 3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3920: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3921: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','No award for fund '||get_fund_desc(p_fund_id));
3922: END IF;
3923: ELSE
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3925: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','award_std_rec.fed_fund_code:'||award_std_rec.fed_fund_code);
3926: END IF;
3927: IF award_std_rec.fed_fund_code NOT IN ('FWS','SPNSR') THEN
3928: LOOP

Line 3925: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','award_std_rec.fed_fund_code:'||award_std_rec.fed_fund_code);

3921: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','No award for fund '||get_fund_desc(p_fund_id));
3922: END IF;
3923: ELSE
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3925: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','award_std_rec.fed_fund_code:'||award_std_rec.fed_fund_code);
3926: END IF;
3927: IF award_std_rec.fed_fund_code NOT IN ('FWS','SPNSR') THEN
3928: LOOP
3929: lv_person_number := igf_gr_gen.get_per_num (award_std_rec.base_id);

Line 3935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3931: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
3932: fnd_message.set_token('STDNT',lv_person_number);
3933: fnd_file.put_line(fnd_file.log,fnd_message.get);
3934:
3935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3936: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','starting processing '||lv_person_number);
3937: END IF;
3938: --
3939: -- Check for Academic Holds, only if con job is run

Line 3936: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','starting processing '||lv_person_number);

3932: fnd_message.set_token('STDNT',lv_person_number);
3933: fnd_file.put_line(fnd_file.log,fnd_message.get);
3934:
3935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3936: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','starting processing '||lv_person_number);
3937: END IF;
3938: --
3939: -- Check for Academic Holds, only if con job is run
3940: --

Line 3944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3940: --
3941: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(award_std_rec.base_id)) = 'F' THEN
3942: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3943: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3946: END IF;
3947: ELSE
3948: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');

3941: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(award_std_rec.base_id)) = 'F' THEN
3942: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3943: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3946: END IF;
3947: ELSE
3948: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3949: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||award_std_rec.base_id);

Line 3948: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3946: END IF;
3947: ELSE
3948: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3949: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||award_std_rec.base_id);
3950: END IF;
3951: process_student(award_std_rec.base_id,lv_result,p_fund_id);
3952:

Line 3949: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||award_std_rec.base_id);

3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');
3946: END IF;
3947: ELSE
3948: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3949: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','calling process_student for base_id '||award_std_rec.base_id);
3950: END IF;
3951: process_student(award_std_rec.base_id,lv_result,p_fund_id);
3952:
3953: END IF;

Line 3961: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3957: fnd_message.set_token('PER_NUM',lv_person_number);
3958: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3959: fnd_file.new_line(fnd_file.log,1);
3960:
3961: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3962: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);
3963: END IF;
3964:
3965: FETCH cur_award_std INTO award_std_rec;

Line 3962: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);

3958: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3959: fnd_file.new_line(fnd_file.log,1);
3960:
3961: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3962: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','end processing '||lv_person_number);
3963: END IF;
3964:
3965: FETCH cur_award_std INTO award_std_rec;
3966: EXIT WHEN cur_award_std%NOTFOUND;

Line 3974: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3970:
3971: ELSE
3972: fnd_message.set_name('IGF','IGF_DB_NO_FWSS');
3973: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3974: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3975: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','unsupported fund type '||award_std_rec.fed_fund_code);
3976: END IF;
3977: END IF;
3978: END IF;

Line 3975: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','unsupported fund type '||award_std_rec.fed_fund_code);

3971: ELSE
3972: fnd_message.set_name('IGF','IGF_DB_NO_FWSS');
3973: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3974: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3975: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','unsupported fund type '||award_std_rec.fed_fund_code);
3976: END IF;
3977: END IF;
3978: END IF;
3979: ELSE