[Home] [Help]
1: PACKAGE BODY igf_aw_gen_003 AS
2: /* $Header: IGFAW12B.pls 120.23 2006/08/04 07:40:11 veramach ship $ */
3:
4:
5: FUNCTION get_plan_disb_count(p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
172:
173: -- Log
174: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
175: fnd_log.string(fnd_log.level_statement,
176: 'igf.plsql.igf_aw_gen_003.cancel_extra_disb',
177: 'Cancelling disb num ' ||disb_cancel_rec.disb_num|| ' in award_id:' ||p_award_id);
178: END IF;
179:
180: -- cancel the disbursement
421: EXCEPTION
422:
423: WHEN OTHERS THEN
424: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
425: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_PELL_DISB'||' ' ||SQLERRM);
426: app_exception.raise_exception;
427:
428: END create_pell_disb;
429:
699: EXCEPTION
700:
701: WHEN OTHERS THEN
702: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
703: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATING_COA_IN_FA_BASE'||' ' ||SQLERRM);
704: app_exception.raise_exception;
705:
706: END updating_coa_in_fa_base;
707:
784: IF l_disb_round_factor IN ('ONE_FIRST','DEC_FIRST','ONE_LAST','DEC_LAST') THEN -- disb_round_factor
785:
786: -- Log useful values
787: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
788: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ','ROUND FACTOR = '||l_disb_round_factor);
789: END IF;
790:
791: -- Set the attributes common to ONEs rounding factor
792: IF l_disb_round_factor = 'ONE_FIRST' OR l_disb_round_factor = 'ONE_LAST' THEN
859: l_disb_no := NVL(l_disb_no, 0) + l_step;
860:
861: -- Log useful values
862: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ','l_disb_no = '||l_disb_no);
864: END IF;
865: END LOOP;
866: END IF;
867:
883: l_disb_inter_sum_amt := NVL((l_disb_inter_sum_amt + l_disb_amt), 0);
884:
885: -- Log useful values
886: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
887: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ',
888: 'Disbursement number: '||l_disb_structure_rec(l_disb_no).disb_num ||
889: 'Disbursement amount: ' || to_char(l_disb_structure_rec(l_disb_no).disb_amt));
890: END IF;
891: END IF;
901:
902: -- Log useful values
903: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
904: fnd_log.string(fnd_log.level_statement,
905: ' igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ',
906: ' Disbursement number: '|| l_disb_structure_rec(l_special_disb_no).disb_num ||
907: ' Disbursement amount: ' || to_char(l_disb_structure_rec(l_special_disb_no).disb_amt));
908: END IF;
909:
934: NVL(l_disb_rec.int_rebate_amt,0);
935:
936: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
937: fnd_log.string(fnd_log.level_statement,
938: ' igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ',
939: 'Disbursement amounts before and after applying rounding logic');
940:
941: fnd_log.string(fnd_log.level_statement,
942: 'igf.plsql.igf_aw_packaging.round_off_disbursements.debug ',
1576:
1577: BEGIN
1578:
1579: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1580: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_fund_id:'||p_fund_id);
1581: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_id:'||p_award_id);
1582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_adplans_id:'||p_adplans_id);
1583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_method_code:'||p_method_code);
1584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_offered_amt:'||p_offered_amt);
1577: BEGIN
1578:
1579: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1580: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_fund_id:'||p_fund_id);
1581: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_id:'||p_award_id);
1582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_adplans_id:'||p_adplans_id);
1583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_method_code:'||p_method_code);
1584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_offered_amt:'||p_offered_amt);
1585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_awd_prd_code:'||p_awd_prd_code);
1578:
1579: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1580: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_fund_id:'||p_fund_id);
1581: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_id:'||p_award_id);
1582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_adplans_id:'||p_adplans_id);
1583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_method_code:'||p_method_code);
1584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_offered_amt:'||p_offered_amt);
1585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_awd_prd_code:'||p_awd_prd_code);
1586: END IF;
1579: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1580: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_fund_id:'||p_fund_id);
1581: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_id:'||p_award_id);
1582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_adplans_id:'||p_adplans_id);
1583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_method_code:'||p_method_code);
1584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_offered_amt:'||p_offered_amt);
1585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_awd_prd_code:'||p_awd_prd_code);
1586: END IF;
1587:
1580: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_fund_id:'||p_fund_id);
1581: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_id:'||p_award_id);
1582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_adplans_id:'||p_adplans_id);
1583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_method_code:'||p_method_code);
1584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_offered_amt:'||p_offered_amt);
1585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_awd_prd_code:'||p_awd_prd_code);
1586: END IF;
1587:
1588: OPEN cur_get_base(p_award_id);
1581: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_id:'||p_award_id);
1582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_adplans_id:'||p_adplans_id);
1583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_method_code:'||p_method_code);
1584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_offered_amt:'||p_offered_amt);
1585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_awd_prd_code:'||p_awd_prd_code);
1586: END IF;
1587:
1588: OPEN cur_get_base(p_award_id);
1589: FETCH cur_get_base INTO get_base_rec;
1596: ln_run_disb_gross_amt := 0;
1597: l_adplans_name := l_adplans_dtls.awd_dist_plan_cd_desc;
1598:
1599: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1600: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','base_id:'||get_base_rec.base_id);
1601: END IF;
1602:
1603: --
1604: -- Check for common terms only if COA is present
1625: IF p_method_code = 'M' THEN -- Manual distribution
1626:
1627: IF lb_coa_exist THEN
1628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb');
1630: END IF;
1631: IF l_get_fund_dtls.fed_fund_code = 'PELL' THEN
1632: OPEN c_auto_disb_pell(get_base_rec.base_id,p_adplans_id);
1633: IF c_auto_disb_pell%NOTFOUND THEN
1644: END IF;
1645: END IF;
1646: ELSE
1647: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1648: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb_wcoa');
1649: END IF;
1650: IF l_get_fund_dtls.fed_fund_code = 'PELL' THEN
1651: OPEN c_auto_disb_wcoa_pell(get_base_rec.base_id,p_adplans_id);
1652: IF c_auto_disb_wcoa_pell%NOTFOUND THEN
1673: FETCH cur_terms_count_pell INTO l_terms_count;
1674: CLOSE cur_terms_count_pell;
1675:
1676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1677: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb_equal_pell with l_terms_count:'||l_terms_count);
1678: END IF;
1679: OPEN c_auto_disb_equal_pell(get_base_rec.base_id,p_adplans_id,l_terms_count);
1680: IF c_auto_disb_equal_pell%NOTFOUND THEN
1681: CLOSE c_auto_disb_equal_pell;
1687: FETCH cur_terms_count INTO l_terms_count;
1688: CLOSE cur_terms_count;
1689:
1690: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb_equal with l_terms_count:'||l_terms_count);
1692: END IF;
1693: OPEN c_auto_disb_equal(get_base_rec.base_id,p_adplans_id,l_terms_count,p_awd_prd_code);
1694: IF c_auto_disb_equal%NOTFOUND THEN
1695: CLOSE c_auto_disb_equal;
1703: FETCH cur_terms_count_wcoa_pell INTO l_terms_count;
1704: CLOSE cur_terms_count_wcoa_pell;
1705:
1706: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb_equal_wcoa_pell with l_terms_count:'||l_terms_count);
1708: END IF;
1709: IF l_terms_count = 0 THEN
1710: RAISE NO_AP_DP_COMM_TERMS;
1711: END IF;
1720: FETCH cur_terms_count_wcoa INTO l_terms_count;
1721: CLOSE cur_terms_count_wcoa;
1722:
1723: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1724: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb_equal_wcoa with l_terms_count:'||l_terms_count);
1725: END IF;
1726: IF l_terms_count = 0 THEN
1727: RAISE NO_AP_DP_COMM_TERMS;
1728: END IF;
1748: FETCH c_coa_pell INTO ln_coa;
1749: CLOSE c_coa_pell;
1750:
1751: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1752: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb_coa_match_pell with ln_coa:'||ln_coa);
1753: END IF;
1754: OPEN c_auto_disb_coa_match_pell(get_base_rec.base_id,p_adplans_id,NVL(ln_coa,0));
1755: IF c_auto_disb_coa_match_pell%NOTFOUND THEN
1756: CLOSE c_auto_disb_coa_match_pell;
1762: FETCH c_coa INTO ln_coa;
1763: CLOSE c_coa;
1764:
1765: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb_coa_match with ln_coa:'||ln_coa);
1767: END IF;
1768: OPEN c_auto_disb_coa_match(get_base_rec.base_id,p_adplans_id,NVL(ln_coa,0),p_awd_prd_code);
1769: IF c_auto_disb_coa_match%NOTFOUND THEN
1770: CLOSE c_auto_disb_coa_match;
1794: ld_disb_date := NULL;
1795: ld_disb_exp_dt := NULL;
1796:
1797: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1798: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_dt:'||lc_auto_disb.disb_dt);
1799: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_cal_type:'||lc_auto_disb.ld_cal_type);
1800: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_cal_type:'||lc_auto_disb.tp_cal_type);
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1795: ld_disb_exp_dt := NULL;
1796:
1797: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1798: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_dt:'||lc_auto_disb.disb_dt);
1799: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_cal_type:'||lc_auto_disb.ld_cal_type);
1800: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_cal_type:'||lc_auto_disb.tp_cal_type);
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1796:
1797: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1798: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_dt:'||lc_auto_disb.disb_dt);
1799: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_cal_type:'||lc_auto_disb.ld_cal_type);
1800: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_cal_type:'||lc_auto_disb.tp_cal_type);
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','start_dt:'||lc_auto_disb.start_dt);
1797: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1798: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_dt:'||lc_auto_disb.disb_dt);
1799: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_cal_type:'||lc_auto_disb.ld_cal_type);
1800: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_cal_type:'||lc_auto_disb.tp_cal_type);
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','start_dt:'||lc_auto_disb.start_dt);
1805: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_offset_da:'||lc_auto_disb.tp_offset_da);
1798: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_dt:'||lc_auto_disb.disb_dt);
1799: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_cal_type:'||lc_auto_disb.ld_cal_type);
1800: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_cal_type:'||lc_auto_disb.tp_cal_type);
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','start_dt:'||lc_auto_disb.start_dt);
1805: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_offset_da:'||lc_auto_disb.tp_offset_da);
1806: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','min_credit_points:'||lc_auto_disb.min_credit_points);
1799: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_cal_type:'||lc_auto_disb.ld_cal_type);
1800: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_cal_type:'||lc_auto_disb.tp_cal_type);
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','start_dt:'||lc_auto_disb.start_dt);
1805: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_offset_da:'||lc_auto_disb.tp_offset_da);
1806: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','min_credit_points:'||lc_auto_disb.min_credit_points);
1807: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','attendance_type_code:'||lc_auto_disb.attendance_type_code);
1800: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_cal_type:'||lc_auto_disb.tp_cal_type);
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','start_dt:'||lc_auto_disb.start_dt);
1805: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_offset_da:'||lc_auto_disb.tp_offset_da);
1806: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','min_credit_points:'||lc_auto_disb.min_credit_points);
1807: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','attendance_type_code:'||lc_auto_disb.attendance_type_code);
1808: END IF;
1801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_cal_type:'||lc_auto_disb.tp_cal_type);
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','start_dt:'||lc_auto_disb.start_dt);
1805: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_offset_da:'||lc_auto_disb.tp_offset_da);
1806: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','min_credit_points:'||lc_auto_disb.min_credit_points);
1807: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','attendance_type_code:'||lc_auto_disb.attendance_type_code);
1808: END IF;
1809:
1802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_sequence_number:'||lc_auto_disb.tp_sequence_number);
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','start_dt:'||lc_auto_disb.start_dt);
1805: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_offset_da:'||lc_auto_disb.tp_offset_da);
1806: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','min_credit_points:'||lc_auto_disb.min_credit_points);
1807: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','attendance_type_code:'||lc_auto_disb.attendance_type_code);
1808: END IF;
1809:
1810: IF p_method_code = 'E' THEN
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','start_dt:'||lc_auto_disb.start_dt);
1805: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','tp_offset_da:'||lc_auto_disb.tp_offset_da);
1806: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','min_credit_points:'||lc_auto_disb.min_credit_points);
1807: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','attendance_type_code:'||lc_auto_disb.attendance_type_code);
1808: END IF;
1809:
1810: IF p_method_code = 'E' THEN
1811: IF l_get_fund_dtls.fed_fund_code = 'PELL' AND lb_coa_exist THEN
1809:
1810: IF p_method_code = 'E' THEN
1811: IF l_get_fund_dtls.fed_fund_code = 'PELL' AND lb_coa_exist THEN
1812: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1813: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','calling num_disb with plan/cal_type/seq_num->'||p_adplans_id||'/'||lc_auto_disb.ld_cal_type||'/'||lc_auto_disb.ld_sequence_number);
1814: END IF;
1815: lc_auto_disb.perct := 100 / igf_gr_pell_calc.num_disb(p_adplans_id,lc_auto_disb.ld_cal_type,lc_auto_disb.ld_sequence_number);
1816: ELSIF l_get_fund_dtls.fed_fund_code = 'PELL' AND NOT lb_coa_exist THEN
1817: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1814: END IF;
1815: lc_auto_disb.perct := 100 / igf_gr_pell_calc.num_disb(p_adplans_id,lc_auto_disb.ld_cal_type,lc_auto_disb.ld_sequence_number);
1816: ELSIF l_get_fund_dtls.fed_fund_code = 'PELL' AND NOT lb_coa_exist THEN
1817: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','calling num_disb with plan/cal_type/seq_num->'||p_adplans_id||'/NULL/NULL');
1819: END IF;
1820: lc_auto_disb.perct := 100 / igf_gr_pell_calc.num_disb(p_adplans_id,NULL,NULL);
1821: ELSE
1822: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1819: END IF;
1820: lc_auto_disb.perct := 100 / igf_gr_pell_calc.num_disb(p_adplans_id,NULL,NULL);
1821: ELSE
1822: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','calling num_disb with plan/cal_type/seq_num->'||p_adplans_id||'/NULL/NULL');
1824: END IF;
1825: lc_auto_disb.perct := 100 / igf_gr_pell_calc.num_disb(p_adplans_id,NULL,NULL);
1826: END IF;
1827: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1824: END IF;
1825: lc_auto_disb.perct := 100 / igf_gr_pell_calc.num_disb(p_adplans_id,NULL,NULL);
1826: END IF;
1827: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','reset lc_auto_disb.perct to:'||lc_auto_disb.perct);
1829: END IF;
1830: END IF;
1831:
1832: -- Calculate the Disbursement Gross Amount.
1832: -- Calculate the Disbursement Gross Amount.
1833: ln_disb_gross_amt := NVL(((p_offered_amt) * lc_auto_disb.perct)/100, 0);
1834:
1835: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1836: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_gross_amt:'||ln_disb_gross_amt);
1837: END IF;
1838:
1839: ln_count := ln_count + 1;
1840: -- Calculate the running totals
1840: -- Calculate the running totals
1841: ln_run_disb_gross_amt := ln_run_disb_gross_amt + ln_disb_gross_amt;
1842:
1843: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','all others ln_count: '||ln_count||' ln_disb_gross_amt: '||ln_disb_gross_amt);
1845: END IF;
1846: -- Calculate the Fee_1, Rebate Amount and the net amount for Direct Loans
1847: IF igf_sl_gen.chk_dl_fed_fund_code(l_get_fund_dtls.fed_fund_code) = 'TRUE' THEN
1848: -- we are passing dummys here for Net and Fee amount as they will
1847: IF igf_sl_gen.chk_dl_fed_fund_code(l_get_fund_dtls.fed_fund_code) = 'TRUE' THEN
1848: -- we are passing dummys here for Net and Fee amount as they will
1849: -- be calculated later on
1850: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','before round off call chk_dl_fed_fund_code = TRUE!ln_disb_net_amt:'||ln_disb_net_amt);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','before round off call ln_disb_gross_amt:'||ln_disb_gross_amt);
1853: END IF;
1854:
1855: igf_sl_roundoff_digits_pkg.gross_fees_roundoff (
1848: -- we are passing dummys here for Net and Fee amount as they will
1849: -- be calculated later on
1850: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','before round off call chk_dl_fed_fund_code = TRUE!ln_disb_net_amt:'||ln_disb_net_amt);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','before round off call ln_disb_gross_amt:'||ln_disb_gross_amt);
1853: END IF;
1854:
1855: igf_sl_roundoff_digits_pkg.gross_fees_roundoff (
1856: p_last_disb_num => ln_total_disbs,
1865: p_fee => ln_dummy_fee_1
1866: ) ;
1867:
1868: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1869: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','after round off call ln_disb_net_amt:'||ln_disb_net_amt);
1870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','after round off call ln_disb_gross_amt:'||ln_disb_gross_amt);
1871: END IF;
1872:
1873: -- This routine will return Net Amount/ Fee Amounts / Interest Rebate Amount
1866: ) ;
1867:
1868: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1869: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','after round off call ln_disb_net_amt:'||ln_disb_net_amt);
1870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','after round off call ln_disb_gross_amt:'||ln_disb_gross_amt);
1871: END IF;
1872:
1873: -- This routine will return Net Amount/ Fee Amounts / Interest Rebate Amount
1874: igf_sl_award.get_loan_amts( l_get_fund_dtls.awd_cal_type,
1879: ln_fee_1,
1880: ln_disb_net_amt);
1881:
1882: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','After get loan amts ln_disb_net_amt:'||ln_disb_net_amt);
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','After get loan amts ln_disb_gross_amt:'||ln_disb_gross_amt);
1885: END IF;
1886:
1887: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_get_fund_dtls.fed_fund_code) = 'TRUE' THEN
1880: ln_disb_net_amt);
1881:
1882: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','After get loan amts ln_disb_net_amt:'||ln_disb_net_amt);
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','After get loan amts ln_disb_gross_amt:'||ln_disb_gross_amt);
1885: END IF;
1886:
1887: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_get_fund_dtls.fed_fund_code) = 'TRUE' THEN
1888:
1911: ln_fee_2 := TRUNC(ln_fee_2);
1912:
1913: -- get the rounded off gross amount by using this routine
1914: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1915: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','before round off call chk_cl_fed_fund_code = TRUE!ln_disb_net_amt:'||ln_disb_net_amt);
1916: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','before round off call ln_disb_gross_amt:'||ln_disb_gross_amt);
1917: END IF;
1918:
1919: igf_sl_roundoff_digits_pkg.cl_gross_fees_roundoff ( p_last_disb_num => ln_total_disbs,
1912:
1913: -- get the rounded off gross amount by using this routine
1914: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1915: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','before round off call chk_cl_fed_fund_code = TRUE!ln_disb_net_amt:'||ln_disb_net_amt);
1916: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','before round off call ln_disb_gross_amt:'||ln_disb_gross_amt);
1917: END IF;
1918:
1919: igf_sl_roundoff_digits_pkg.cl_gross_fees_roundoff ( p_last_disb_num => ln_total_disbs,
1920: p_offered_amt => p_offered_amt,
1921: p_disb_gross_amt => ln_disb_gross_amt );
1922:
1923: ln_disb_net_amt := NVL(ln_disb_gross_amt,0) - NVL(ln_fee_1,0) - NVL(ln_fee_2,0);
1924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1925: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','after round off call chk_cl_fed_fund_code = TRUE!ln_disb_net_amt:'||ln_disb_net_amt);
1926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','after round off call ln_disb_gross_amt:'||ln_disb_gross_amt);
1927: END IF;
1928:
1929: ELSE
1922:
1923: ln_disb_net_amt := NVL(ln_disb_gross_amt,0) - NVL(ln_fee_1,0) - NVL(ln_fee_2,0);
1924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1925: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','after round off call chk_cl_fed_fund_code = TRUE!ln_disb_net_amt:'||ln_disb_net_amt);
1926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','after round off call ln_disb_gross_amt:'||ln_disb_gross_amt);
1927: END IF;
1928:
1929: ELSE
1930: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1927: END IF;
1928:
1929: ELSE
1930: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1931: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','chk_dl_fed_fund_code,chk_cl_fed_fund_code = FALSE!ln_disb_net_amt:'||ln_disb_net_amt);
1932: END IF;
1933:
1934: ln_disb_net_amt := NVL(ln_disb_gross_amt,0);
1935: END IF;
1934: ln_disb_net_amt := NVL(ln_disb_gross_amt,0);
1935: END IF;
1936:
1937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_count:'||ln_count);
1939: END IF;
1940:
1941: --
1942: -- For all types of loans and it it is a first disbursement disbursement date
1948: OR igf_sl_gen.chk_cl_fed_fund_code (l_get_fund_dtls.fed_fund_code) = 'TRUE' )
1949: AND (l_get_fund_dtls.nslds_disb_da IS NOT NULL) THEN
1950:
1951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1952: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','inside fed_fund_code checks');
1953: END IF;
1954:
1955: ld_disb_date1 := NULL;
1956:
1961: --
1962: -- No NSLDS History exists for current student , so delay the disbursement
1963: --
1964: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','student has no NSLDS history, so applying NSLDS date offset.');
1966: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.tp_offset_da:'||lc_auto_disb.tp_offset_da);
1967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_cal_type:'||lc_auto_disb.ld_cal_type);
1968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1969: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','l_get_fund_dtls.nslds_disb_da:'||l_get_fund_dtls.nslds_disb_da);
1962: -- No NSLDS History exists for current student , so delay the disbursement
1963: --
1964: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','student has no NSLDS history, so applying NSLDS date offset.');
1966: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.tp_offset_da:'||lc_auto_disb.tp_offset_da);
1967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_cal_type:'||lc_auto_disb.ld_cal_type);
1968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1969: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','l_get_fund_dtls.nslds_disb_da:'||l_get_fund_dtls.nslds_disb_da);
1970: END IF;
1963: --
1964: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','student has no NSLDS history, so applying NSLDS date offset.');
1966: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.tp_offset_da:'||lc_auto_disb.tp_offset_da);
1967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_cal_type:'||lc_auto_disb.ld_cal_type);
1968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1969: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','l_get_fund_dtls.nslds_disb_da:'||l_get_fund_dtls.nslds_disb_da);
1970: END IF;
1971:
1964: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','student has no NSLDS history, so applying NSLDS date offset.');
1966: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.tp_offset_da:'||lc_auto_disb.tp_offset_da);
1967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_cal_type:'||lc_auto_disb.ld_cal_type);
1968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1969: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','l_get_fund_dtls.nslds_disb_da:'||l_get_fund_dtls.nslds_disb_da);
1970: END IF;
1971:
1972: ld_disb_date1 := igf_ap_gen_001.get_date_alias_val(
1965: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','student has no NSLDS history, so applying NSLDS date offset.');
1966: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.tp_offset_da:'||lc_auto_disb.tp_offset_da);
1967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_cal_type:'||lc_auto_disb.ld_cal_type);
1968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','lc_auto_disb.ld_sequence_number:'||lc_auto_disb.ld_sequence_number);
1969: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','l_get_fund_dtls.nslds_disb_da:'||l_get_fund_dtls.nslds_disb_da);
1970: END IF;
1971:
1972: ld_disb_date1 := igf_ap_gen_001.get_date_alias_val(
1973: get_base_rec.base_id,
1977: );
1978:
1979: IF ld_disb_date1 IS NOT NULL THEN
1980: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1981: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','NSLDS Disb Offset date, ld_disb_date1:' ||ld_disb_date1);
1982: END IF;
1983: ELSE
1984: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1985: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug',
1981: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','NSLDS Disb Offset date, ld_disb_date1:' ||ld_disb_date1);
1982: END IF;
1983: ELSE
1984: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1985: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug',
1986: 'Cannot compute NSLDS offset date. Some error in computing NSLDS offset date. So using the actual disb date.');
1987: END IF;
1988: END IF;
1989: ELSE
1988: END IF;
1989: ELSE
1990: -- NSLDS history exists. Do not delay disb date.
1991: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1992: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Student has NSLDS history, so NOT applying NSLDS date offset.');
1993: END IF;
1994: END IF;
1995:
1996: CLOSE cur_nslds_hist;
2016:
2017: IF ld_disb_date1 IS NOT NULL AND ln_count = 1 THEN
2018: -- Student does NOT have NSLDS history, apply NSLDS date offset to delay disb date
2019: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2020: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Setting lb_nslds_ind to FALSE, so that NSLDS date offset will be applied.');
2021: END IF;
2022:
2023: lb_nslds_ind := FALSE;
2024: END IF;
2060: */
2061:
2062: -- Log
2063: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Updating existing disbursement (Repackaging)');
2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2061:
2062: -- Log
2063: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Updating existing disbursement (Repackaging)');
2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2062: -- Log
2063: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Updating existing disbursement (Repackaging)');
2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2070: END IF;
2063: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Updating existing disbursement (Repackaging)');
2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2070: END IF;
2071:
2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Updating existing disbursement (Repackaging)');
2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2070: END IF;
2071:
2072: l_hold_ind := NVL(l_disb.hold_rel_ind, 'FALSE');
2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2070: END IF;
2071:
2072: l_hold_ind := NVL(l_disb.hold_rel_ind, 'FALSE');
2073:
2125: -- created. So, create the disbursement
2126:
2127: -- Log
2128: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2129: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Creating new disbursement (Packaging)');
2130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2132: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2126:
2127: -- Log
2128: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2129: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Creating new disbursement (Packaging)');
2130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2132: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2127: -- Log
2128: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2129: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Creating new disbursement (Packaging)');
2130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2132: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2135: END IF;
2128: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2129: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Creating new disbursement (Packaging)');
2130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2132: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2135: END IF;
2136:
2129: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Creating new disbursement (Packaging)');
2130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2132: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2135: END IF;
2136:
2137: igf_aw_awd_disb_pkg.insert_row (
2130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);
2132: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_gross_amt:'||ln_disb_gross_amt);
2133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2135: END IF;
2136:
2137: igf_aw_awd_disb_pkg.insert_row (
2138: x_mode => 'R',
2186: CLOSE c_disb;
2187:
2188: IF p_method_code = 'M' THEN /*Manual distribution */
2189: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2190: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','-----fetching next disbursment-----');
2191: END IF;
2192: IF lb_coa_exist THEN
2193: IF l_get_fund_dtls.fed_fund_code = 'PELL' THEN
2194: FETCH c_auto_disb_pell INTO lc_auto_disb;
2208: END IF;
2209:
2210: ELSIF p_method_code = 'E' THEN /* Equal Distribution */
2211: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2212: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','-----fetching next disbursment-----');
2213: END IF;
2214: IF lb_coa_exist THEN
2215: IF l_get_fund_dtls.fed_fund_code = 'PELL' THEN
2216: FETCH c_auto_disb_equal_pell INTO lc_auto_disb;
2230: END IF;
2231:
2232: ELSIF p_method_code = 'C' THEN /* Match COA distribution */
2233: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2234: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','-----fetching next disbursment-----');
2235: END IF;
2236: IF l_get_fund_dtls.fed_fund_code = 'PELL' THEN
2237: FETCH c_auto_disb_coa_match_pell INTO lc_auto_disb;
2238: EXIT WHEN c_auto_disb_coa_match_pell%NOTFOUND;
2295: FETCH c_disb INTO l_disb;
2296: CLOSE c_disb;
2297:
2298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2299: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Flag set - updating disb num 1 with NSLDS disb offset date: ' ||ld_disb_date1);
2300: END IF;
2301:
2302: igf_aw_awd_disb_pkg.update_row(
2303: x_mode => 'R',
2379: fnd_message.set_name('IGF','IGF_AW_COA_COMMON_TERMS_FAIL');
2380: fnd_message.set_token('PLAN_CD',l_adplans_name);
2381: fnd_file.put_line(fnd_file.log,fnd_message.get);
2382: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2383: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','no common terms between COA and distribution plan');
2384: END IF;
2385:
2386: WHEN NO_AP_DP_COMM_TERMS THEN
2387: fnd_message.set_name('IGF','IGF_AW_NO_APDP_COM_TERM');
2420: CLOSE c_auto_disb_coa_match_pell;
2421: END IF;
2422:
2423: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2424: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_AUTO_DISB' || ' ' || SQLERRM);
2425: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2426: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','sql error message:'|| SQLERRM);
2427: END IF;
2428: app_exception.raise_exception;
2422:
2423: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2424: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_AUTO_DISB' || ' ' || SQLERRM);
2425: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2426: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','sql error message:'|| SQLERRM);
2427: END IF;
2428: app_exception.raise_exception;
2429:
2430: END create_auto_disb;
2535:
2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2539: fnd_message.set_token('NAME','IGF_AW_GEN_003.REMOVE_AWD_RULES_OVERRIDE'||' ' ||SQLERRM);
2540: app_exception.raise_exception;
2541:
2542: END remove_awd_rules_override;
2543:
2586: EXCEPTION
2587:
2588: WHEN OTHERS THEN
2589: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2590: fnd_message.set_token('NAME','IGF_AW_GEN_003.PLACE_OVAWD_HOLDS'||' ' ||SQLERRM);
2591: app_exception.raise_exception;
2592:
2593: END place_ovawd_holds;
2594:
2674: EXCEPTION
2675:
2676: WHEN OTHERS THEN
2677: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2678: fnd_message.set_token('NAME','IGF_AW_GEN_003.CREATE_OVER_AWD_HOLDS'||' ' ||SQLERRM);
2679: app_exception.raise_exception;
2680:
2681: END create_over_awd_holds;
2682:
2782: ROLLBACK;
2783:
2784: WHEN OTHERS THEN
2785: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2786: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_ACCEPT_AMOUNT'||' ' ||SQLERRM);
2787: app_exception.raise_exception;
2788:
2789: END update_accept_amount;
2790:
2847:
2848: BEGIN
2849:
2850: IF p_fed_fund_code = 'PELL' THEN
2851: IF igf_aw_gen_003.check_coa(p_base_id) THEN
2852:
2853: OPEN cur_active_isir(p_base_id);
2854: FETCH cur_active_isir INTO active_isir_rec;
2855: IF cur_active_isir%FOUND THEN
3013: ROLLBACK;
3014:
3015: WHEN OTHERS THEN
3016: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3017: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_AWD_CANCELL_TO_OFFER'||' ' || SQLERRM);
3018: app_exception.raise_exception;
3019:
3020: END update_awd_cancell_to_offer;
3021:
3132: EXCEPTION
3133:
3134: WHEN OTHERS THEN
3135: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3136: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_DISBDTS'||' ' || SQLERRM);
3137: app_exception.raise_exception;
3138:
3139: END check_disbdts;
3140:
3393: l_efc_ay NUMBER;
3394:
3395: BEGIN
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - START');
3398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_calling_form: ' ||p_calling_form);
3399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_base_id: ' ||p_base_id);
3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_fund_id);
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3394:
3395: BEGIN
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - START');
3398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_calling_form: ' ||p_calling_form);
3399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_base_id: ' ||p_base_id);
3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_fund_id);
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3395: BEGIN
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - START');
3398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_calling_form: ' ||p_calling_form);
3399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_base_id: ' ||p_base_id);
3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_fund_id);
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - START');
3398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_calling_form: ' ||p_calling_form);
3399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_base_id: ' ||p_base_id);
3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_fund_id);
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - START');
3398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_calling_form: ' ||p_calling_form);
3399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_base_id: ' ||p_base_id);
3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_fund_id);
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);
3398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_calling_form: ' ||p_calling_form);
3399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_base_id: ' ||p_base_id);
3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_fund_id);
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);
3406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_ld_seq_number: ' ||p_ld_seq_number);
3399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_base_id: ' ||p_base_id);
3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_fund_id);
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);
3406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_ld_seq_number: ' ||p_ld_seq_number);
3407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_awd_prd_code: ' ||p_awd_prd_code);
3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_fund_id);
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);
3406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_ld_seq_number: ' ||p_ld_seq_number);
3407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_awd_prd_code: ' ||p_awd_prd_code);
3408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - END');
3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);
3406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_ld_seq_number: ' ||p_ld_seq_number);
3407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_awd_prd_code: ' ||p_awd_prd_code);
3408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - END');
3409: END IF;
3402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fed_fund_code: ' ||p_fed_fund_code);
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);
3406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_ld_seq_number: ' ||p_ld_seq_number);
3407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_awd_prd_code: ' ||p_awd_prd_code);
3408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - END');
3409: END IF;
3410:
3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_number);
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);
3406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_ld_seq_number: ' ||p_ld_seq_number);
3407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_awd_prd_code: ' ||p_awd_prd_code);
3408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - END');
3409: END IF;
3410:
3411: lv_message := 'NULL';
3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_id);
3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);
3406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_ld_seq_number: ' ||p_ld_seq_number);
3407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_awd_prd_code: ' ||p_awd_prd_code);
3408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - END');
3409: END IF;
3410:
3411: lv_message := 'NULL';
3412: p_chk_holds := '*';
3465: IF p_fed_fund_code IN ('DLS','FLS') THEN
3466: l_subz_loan := 'Y';
3467:
3468: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3469: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Fund is DLS/FLS, so set l_subz_loan to Y');
3470: END IF;
3471: ELSE
3472: l_subz_loan := 'N';
3473:
3471: ELSE
3472: l_subz_loan := 'N';
3473:
3474: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3475: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Fund is NOT DLS/FLS, so set l_subz_loan to N');
3476: END IF;
3477: END IF;
3478:
3479: -- This would ensure that if the Award Status is accepted and the disb number's transaction type
3789: l_efc_ay => l_efc_ay
3790: );
3791:
3792: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3793: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','l_efc:'||l_efc);
3794: END IF;
3795:
3796: IF l_efc IS NOT NULL THEN
3797:
3812: );
3813:
3814:
3815: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','P_AWD_PRD_CODE>ln_unmet_need_f:'|| P_AWD_PRD_CODE || ' >' || ln_unmet_need_f);
3817: END IF;
3818:
3819: IF NVL(ln_unmet_need_f,0) < 0 THEN
3820:
3843: );
3844:
3845:
3846: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Award Year >ln_unmet_need_f: > '|| ln_unmet_need_f);
3848: END IF;
3849:
3850: IF NVL(ln_unmet_need_f,0) < 0 THEN
3851:
3861:
3862: EXCEPTION
3863: WHEN OTHERS THEN
3864: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3865: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_AMOUNTS'|| ' ' ||SQLERRM );
3866: app_exception.raise_exception;
3867:
3868: END check_amounts;
3869:
3971:
3972: WHEN app_exception.record_lock_exception THEN
3973: ROLLBACK to bill_upd_sp;
3974: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
3975: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG' );
3976: app_exception.raise_exception;
3977:
3978: WHEN others THEN
3979: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3976: app_exception.raise_exception;
3977:
3978: WHEN others THEN
3979: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3980: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_BILL_FLAG'|| ' ' || SQLERRM);
3981: app_exception.raise_exception;
3982:
3983:
3984: END update_bill_flag;
4216: lv_message := fnd_message.get;
4217: RETURN lv_message;
4218: ELSE
4219: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );
4220: fnd_message.set_token('NAME','IGF_AW_GEN_003.DELETE_AWD_DISB'||' '||SQLERRM);
4221: app_exception.raise_exception;
4222: END IF;
4223:
4224:
4258: EXCEPTION
4259:
4260: WHEN OTHERS THEN
4261: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4262: fnd_message.set_token('NAME','IGF_AW_GEN_003.GET_TOTAL_DISB' || ' ' || SQLERRM);
4263: app_exception.raise_exception;
4264:
4265: END get_total_disb;
4266:
4349: CLOSE c_chk_awd_grp_per;
4350: END IF;
4351:
4352: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP' );
4353: fnd_message.set_token('NAME','IGF_AW_GEN_003.AWD_GROUP_FREEZE'||' '|| SQLERRM);
4354: app_exception.raise_exception;
4355:
4356: END awd_group_freeze;
4357:
4606:
4607: EXCEPTION
4608: WHEN OTHERS THEN
4609: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4610: fnd_message.set_token('NAME','IGF_AW_GEN_003.UPDATE_AWARD_APP_TRANS '||SQLERRM);
4611: igs_ge_msg_stack.add;
4612: app_exception.raise_exception;
4613:
4614: END update_award_app_trans;
4638: END IF;
4639: EXCEPTION
4640: WHEN OTHERS THEN
4641: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4642: fnd_message.set_token('NAME','IGF_AW_GEN_003.CHECK_COA '||SQLERRM);
4643: igs_ge_msg_stack.add;
4644: app_exception.raise_exception;
4645:
4646: END check_coa;
4643: igs_ge_msg_stack.add;
4644: app_exception.raise_exception;
4645:
4646: END check_coa;
4647: END igf_aw_gen_003;