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

APPS.IGF_AW_GEN_003 dependencies on FND_LOG

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

170: cp_disb_num => p_disb_num)
171: LOOP
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;

Line 175: fnd_log.string(fnd_log.level_statement,

171: LOOP
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:

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

783:
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

Line 788: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ','ROUND FACTOR = '||l_disb_round_factor);

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

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

858:
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;

Line 863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ','l_disb_no = '||l_disb_no);

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:

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

882:
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;

Line 887: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ',

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;

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

899: l_disb_structure_rec(l_special_disb_no).disb_num := l_special_disb_no;
900: l_disb_structure_rec(l_special_disb_no).disb_amt := l_disb_amt;
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));

Line 904: fnd_log.string(fnd_log.level_statement,

900: l_disb_structure_rec(l_special_disb_no).disb_amt := l_disb_amt;
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;

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

932: NVL(l_disb_rec.fee_paid_1,0) +
933: NVL(l_disb_rec.fee_paid_2,0) +
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:

Line 937: fnd_log.string(fnd_log.level_statement,

933: NVL(l_disb_rec.fee_paid_2,0) +
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,

Line 941: fnd_log.string(fnd_log.level_statement,

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 ',
943: ' Disbursement number: ' ||l_disb_no||
944: ' Old Disbursement amount: ' ||l_disb_rec.disb_gross_amt||
945: ' New disbursement amount after applying rounding logic: ' ||NVL(l_disb_structure_rec(l_disb_no).disb_amt, 0));

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

1575: l_adplans_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
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);

Line 1580: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_fund_id:'||p_fund_id);

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);

Line 1581: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_id:'||p_award_id);

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);

Line 1582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_adplans_id:'||p_adplans_id);

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;

Line 1583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_method_code:'||p_method_code);

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:

Line 1584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_offered_amt:'||p_offered_amt);

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);

Line 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);

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;

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

1595:
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: --

Line 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);

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

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

1624: /* method check */
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);

Line 1629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb');

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

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

1643: FETCH c_auto_disb INTO lc_auto_disb;
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);

Line 1648: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','opening c_auto_disb_wcoa');

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

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

1672: OPEN cur_terms_count_pell(get_base_rec.base_id,p_adplans_id);
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

Line 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);

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;

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

1686: OPEN cur_terms_count(get_base_rec.base_id,p_adplans_id,p_awd_prd_code);
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

Line 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);

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;

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

1702: OPEN cur_terms_count_wcoa_pell(p_adplans_id);
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;

Line 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);

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;

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

1719: OPEN cur_terms_count_wcoa(p_adplans_id,p_awd_prd_code);
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;

Line 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);

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;

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

1747: OPEN c_coa_pell(get_base_rec.base_id,p_adplans_id);
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

Line 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);

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;

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

1761: OPEN c_coa(get_base_rec.base_id,p_adplans_id,p_awd_prd_code);
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

Line 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);

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;

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

1793: ld_verf_enfr_dt := NULL;
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);

Line 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);

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);

Line 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);

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);

Line 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);

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);

Line 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);

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);

Line 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);

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);

Line 1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','perct:'||lc_auto_disb.perct);

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);

Line 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);

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;

Line 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);

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:

Line 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);

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

Line 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);

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

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

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
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

Line 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);

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

Line 1817: 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
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

Line 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');

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

Line 1822: 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
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;

Line 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');

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

Line 1827: 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
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:

Line 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);

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.

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

1831:
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;

Line 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);

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

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

1839: ln_count := ln_count + 1;
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

Line 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);

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

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

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
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:

Line 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);

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 (

Line 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);

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,

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

1864: p_disb_net_amt => ln_dummy_net_amt,
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:

Line 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);

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

Line 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);

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,

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

1878: ln_int_rebate_amt,
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:

Line 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);

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

Line 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);

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:

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

1910: ln_fee_2 := ln_fee_2 * ln_disb_gross_amt/100;
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:

Line 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);

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,

Line 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);

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,

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

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:

Line 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);

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

Line 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);

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

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

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
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);

Line 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);

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;

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

1933:
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: --

Line 1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_count:'||ln_count);

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

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

1947: AND ( igf_sl_gen.chk_dl_fed_fund_code (l_get_fund_dtls.fed_fund_code) = 'TRUE'
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;

Line 1952: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','inside fed_fund_code checks');

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:

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

1960: IF cur_nslds_hist%NOTFOUND THEN
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);

Line 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.');

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);

Line 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);

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;

Line 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);

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:

Line 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);

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(

Line 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);

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,

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

1976: l_get_fund_dtls.nslds_disb_da
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

Line 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);

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',

Line 1984: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level 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',
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;

Line 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

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

1987: END IF;
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:

Line 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.');

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;

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

2015: );
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;

Line 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.');

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;

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

2059: existing CANCELLED award is reinstated to OFFERED/ACCEPTED status.
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);

Line 2064: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Updating existing disbursement (Repackaging)');

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);

Line 2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);

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);

Line 2066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);

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;

Line 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);

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:

Line 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);

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');

Line 2069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);

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:

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

2124: -- disbursement (or) it is a new award whose disbursement needs to be
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);

Line 2129: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Creating new disbursement (Packaging)');

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);

Line 2130: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','award_id:'||p_award_id);

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);

Line 2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','disb_num:'||ln_count);

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;

Line 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);

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:

Line 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);

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 (

Line 2134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);

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',

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

2185: END IF;
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

Line 2190: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','-----fetching next disbursment-----');

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;

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

2207: END IF;
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

Line 2212: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','-----fetching next disbursment-----');

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;

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

2229: END IF;
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;

Line 2234: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','-----fetching next disbursment-----');

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;

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

2294: OPEN c_disb(p_award_id,1);
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(

Line 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);

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',

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

2378: WHEN NO_COMMON_TERMS THEN
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

Line 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');

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');

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

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;
2429:

Line 2426: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_gen_003.create_auto_disb.exception','sql error message:'|| SQLERRM);

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;

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

3392: l_subz_loan VARCHAR2(1);
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);

Line 3397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - START');

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);

Line 3398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_calling_form: ' ||p_calling_form);

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);

Line 3399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_base_id: ' ||p_base_id);

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);

Line 3400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_id: ' ||p_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_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);

Line 3401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_fund_code: ' ||p_fund_code);

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);

Line 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);

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);

Line 3403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_person_number: ' ||p_person_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);

Line 3404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_award_id: ' ||p_award_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);
3408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - END');

Line 3405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','p_act_isir: ' ||p_act_isir);

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;

Line 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);

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:

Line 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);

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';

Line 3408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','Parameter List - END');

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 := '*';

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

3464: -- down the line in the call to get_resource_need()
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';

Line 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');

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:

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

3470: END IF;
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:

Line 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');

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

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

3788: l_pell_efc => l_dummy_pell_efc,
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

Line 3793: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.check_amounts.debug','l_efc:'||l_efc);

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:

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

3811: p_calc_for_subz_loan => l_subz_loan
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

Line 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);

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:

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

3842: p_calc_for_subz_loan => l_subz_loan
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

Line 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);

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: