DBA Data[Home] [Help]

APPS.IGF_SP_AWARD dependencies on IGS_FI_GEN_GL

Line 420: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

416: disb_dtl_rec.disb_status := NULL;
417: disb_dtl_rec.disb_status_date := NULL;
418: g_rowid := NULL;
419:
420: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
421: igf_db_awd_disb_dtl_pkg.insert_row( x_rowid => g_rowid,
422: x_award_id => disb_dtl_rec.award_id ,
423: x_disb_num => disb_dtl_rec.disb_num ,
424: x_disb_seq_num => disb_dtl_rec.disb_seq_num ,

Line 425: x_disb_gross_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_gross_amt) ,

421: igf_db_awd_disb_dtl_pkg.insert_row( x_rowid => g_rowid,
422: x_award_id => disb_dtl_rec.award_id ,
423: x_disb_num => disb_dtl_rec.disb_num ,
424: x_disb_seq_num => disb_dtl_rec.disb_seq_num ,
425: x_disb_gross_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_gross_amt) ,
426: x_fee_1 => disb_dtl_rec.fee_1 ,
427: x_fee_2 => disb_dtl_rec.fee_2 ,
428: x_disb_net_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_net_amt) ,
429: x_disb_adj_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_adj_amt) ,

Line 428: x_disb_net_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_net_amt) ,

424: x_disb_seq_num => disb_dtl_rec.disb_seq_num ,
425: x_disb_gross_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_gross_amt) ,
426: x_fee_1 => disb_dtl_rec.fee_1 ,
427: x_fee_2 => disb_dtl_rec.fee_2 ,
428: x_disb_net_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_net_amt) ,
429: x_disb_adj_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_adj_amt) ,
430: x_disb_date => disb_dtl_rec.disb_date ,
431: x_fee_paid_1 => disb_dtl_rec.fee_paid_1 ,
432: x_fee_paid_2 => disb_dtl_rec.fee_paid_2 ,

Line 429: x_disb_adj_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_adj_amt) ,

425: x_disb_gross_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_gross_amt) ,
426: x_fee_1 => disb_dtl_rec.fee_1 ,
427: x_fee_2 => disb_dtl_rec.fee_2 ,
428: x_disb_net_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_net_amt) ,
429: x_disb_adj_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_adj_amt) ,
430: x_disb_date => disb_dtl_rec.disb_date ,
431: x_fee_paid_1 => disb_dtl_rec.fee_paid_1 ,
432: x_fee_paid_2 => disb_dtl_rec.fee_paid_2 ,
433: x_disb_activity => disb_dtl_rec.disb_activity ,

Line 1098: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1094: l_disb_gross_amt := recal_dis_gross_amt (p_spnsr_stdnt_id => rec_stdnt_rel.spnsr_stdnt_id,
1095: p_fee_cls_id => rec_std_fc.fee_cls_id,
1096: p_chk_elig => p_chk_elig);
1097:
1098: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1099: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);
1100:
1101: -- Log the fee class details
1102: IF NVL(l_disb_gross_amt ,0) = 0 THEN

Line 1099: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);

1095: p_fee_cls_id => rec_std_fc.fee_cls_id,
1096: p_chk_elig => p_chk_elig);
1097:
1098: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1099: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);
1100:
1101: -- Log the fee class details
1102: IF NVL(l_disb_gross_amt ,0) = 0 THEN
1103: -- No disb gross amount

Line 1105: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_std_fc.fee_class));

1101: -- Log the fee class details
1102: IF NVL(l_disb_gross_amt ,0) = 0 THEN
1103: -- No disb gross amount
1104: -- log the message only once
1105: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_std_fc.fee_class));
1106: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1107: fnd_file.put_line(fnd_file.log,fnd_message.get);
1108: ELSE
1109: g_b_msg_logged := TRUE;

Line 1173: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_std_fc.fee_class));

1169: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
1170: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));
1171: fnd_file.put_line(fnd_file.log,fnd_message.get);
1172:
1173: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_std_fc.fee_class));
1174: log_parameters(g_v_disb_amount,l_disb_gross_amt);
1175:
1176: IF p_award_type = 'A' THEN
1177: create_disb_dtl (l_award_id, l_disb_num);

Line 1206: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1202: -- create record in igf_aw_award and igf_aw_awd_disb with the same amount
1203: g_rowid := NULL;
1204: l_award_id := NULL;
1205:
1206: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1207: l_n_tot_spns_amt := igs_fi_gen_gl.get_formatted_amount(l_n_tot_spns_amt);
1208:
1209: igf_aw_award_pkg.insert_row(
1210: x_rowid => g_rowid ,

Line 1207: l_n_tot_spns_amt := igs_fi_gen_gl.get_formatted_amount(l_n_tot_spns_amt);

1203: g_rowid := NULL;
1204: l_award_id := NULL;
1205:
1206: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1207: l_n_tot_spns_amt := igs_fi_gen_gl.get_formatted_amount(l_n_tot_spns_amt);
1208:
1209: igf_aw_award_pkg.insert_row(
1210: x_rowid => g_rowid ,
1211: x_award_id => l_award_id ,

Line 1518: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class));

1514: x_direct_to_borr_flag => rec_aw_awd_disb.direct_to_borr_flag
1515:
1516: );
1517:
1518: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class));
1519: log_parameters(g_v_disb_amount,rec_aw_awd_disb.disb_net_amt);
1520: create_disb_dtl (rec_aw_awd_disb.award_id, rec_aw_awd_disb.disb_num);
1521: END LOOP;
1522: IF g_b_msg_logged THEN

Line 1549: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1545: l_n_tot_spns_amt := recal_dis_gross_amt(p_spnsr_stdnt_id => p_spnsr_stdnt_id,
1546: p_fee_cls_id => NULL,
1547: p_chk_elig => l_chk_elig);
1548:
1549: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1550: l_n_tot_spns_amt := igs_fi_gen_gl.get_formatted_amount(l_n_tot_spns_amt);
1551:
1552: -- fetch record from igf_aw_awd_disb based on award id obtained and update only if
1553: -- the award type is A

Line 1550: l_n_tot_spns_amt := igs_fi_gen_gl.get_formatted_amount(l_n_tot_spns_amt);

1546: p_fee_cls_id => NULL,
1547: p_chk_elig => l_chk_elig);
1548:
1549: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1550: l_n_tot_spns_amt := igs_fi_gen_gl.get_formatted_amount(l_n_tot_spns_amt);
1551:
1552: -- fetch record from igf_aw_awd_disb based on award id obtained and update only if
1553: -- the award type is A
1554: FOR rec_aw_awd_disb IN c_aw_awd_disb (l_award_id,NULL,'P')

Line 1608: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class));

1604: x_direct_to_borr_flag => rec_aw_awd_disb.direct_to_borr_flag
1605:
1606: );
1607:
1608: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class));
1609: log_parameters(g_v_disb_amount,l_n_tot_spns_amt);
1610: create_disb_dtl(rec_aw_awd_disb.award_id, rec_aw_awd_disb.disb_num);
1611: END LOOP;
1612: log_parameters(g_v_award_amount,get_award_amount(l_award_id));

Line 1647: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1643: l_disb_gross_amt:= recal_dis_gross_amt(p_spnsr_stdnt_id => p_spnsr_stdnt_id,
1644: p_fee_cls_id => rec_c_igf_sp_std_fc.fee_cls_id,
1645: p_chk_elig => l_chk_elig);
1646:
1647: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1648: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);
1649:
1650: IF NVL(l_disb_gross_amt,0) = 0 THEN
1651: -- No disb gross amount

Line 1648: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);

1644: p_fee_cls_id => rec_c_igf_sp_std_fc.fee_cls_id,
1645: p_chk_elig => l_chk_elig);
1646:
1647: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1648: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);
1649:
1650: IF NVL(l_disb_gross_amt,0) = 0 THEN
1651: -- No disb gross amount
1652: -- log the message only once

Line 1654: l_v_msg(i) := g_v_disb_fee_class ||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);

1650: IF NVL(l_disb_gross_amt,0) = 0 THEN
1651: -- No disb gross amount
1652: -- log the message only once
1653: i := i+1;
1654: l_v_msg(i) := g_v_disb_fee_class ||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);
1655:
1656: i := i+1;
1657: fnd_message.set_name('IGF','IGF_SP_NO_UPDATE_DISB');
1658: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));

Line 1676: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);

1672: l_v_msg(i) := fnd_message.get;
1673: END IF;
1674:
1675: i := i+1;
1676: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);
1677: i := i+1;
1678: l_v_msg(i) := g_v_ext_disb_amount||' : '|| rec_aw_awd_disb.disb_net_amt;
1679: i := i+1;
1680: l_v_msg(i) := g_v_upd_disb_amount||' : '|| l_disb_gross_amt;

Line 1741: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);

1737: i := i+1;
1738: l_v_msg(i) := fnd_message.get;
1739:
1740: i := i+1;
1741: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);
1742:
1743: i := i+1;
1744: l_v_msg(i) := g_v_disb_amount||' : '|| rec_aw_awd_disb.disb_net_amt;
1745:

Line 1802: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);

1798: create_disb_dtl (rec_aw_awd_disb.award_id, rec_aw_awd_disb.disb_num);
1799: END IF;
1800: ELSE
1801: i := i+1;
1802: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);
1803:
1804: fnd_message.set_name('IGF','IGF_SP_NO_UPDATE_DISB');
1805: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));
1806: i := i+1;

Line 1813: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);

1809: END IF;
1810: END IF;
1811: ELSE
1812: i := i+1;
1813: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_aw_awd_disb.fee_class);
1814: fnd_message.set_name('IGF','IGF_SP_NO_UPDATE_DISB');
1815: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));
1816: i := i+1;
1817: l_v_msg(i) := fnd_message.get;

Line 1825: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1821: l_disb_gross_amt := recal_dis_gross_amt (p_spnsr_stdnt_id => p_spnsr_stdnt_id,
1822: p_fee_cls_id => rec_c_igf_sp_std_fc.fee_cls_id,
1823: p_chk_elig => l_chk_elig);
1824:
1825: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1826: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);
1827:
1828: -- Log the fee class details
1829: IF NVL(l_disb_gross_amt ,0) = 0 THEN

Line 1826: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);

1822: p_fee_cls_id => rec_c_igf_sp_std_fc.fee_cls_id,
1823: p_chk_elig => l_chk_elig);
1824:
1825: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1826: l_disb_gross_amt := igs_fi_gen_gl.get_formatted_amount(l_disb_gross_amt);
1827:
1828: -- Log the fee class details
1829: IF NVL(l_disb_gross_amt ,0) = 0 THEN
1830: -- No disb gross amount

Line 1832: l_v_msg(i) := g_v_disb_fee_class||' : '||igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_c_igf_sp_std_fc.fee_class);

1828: -- Log the fee class details
1829: IF NVL(l_disb_gross_amt ,0) = 0 THEN
1830: -- No disb gross amount
1831: i := i+1;
1832: l_v_msg(i) := g_v_disb_fee_class||' : '||igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_c_igf_sp_std_fc.fee_class);
1833:
1834: i := i+1;
1835: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1836: l_v_msg(i) := fnd_message.get;

Line 1899: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_c_igf_sp_std_fc.fee_class);

1895: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));
1896: i := i+1;
1897: l_v_msg(i) := fnd_message.get;
1898: i := i+1;
1899: l_v_msg(i) := g_v_disb_fee_class||' : '|| igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_c_igf_sp_std_fc.fee_class);
1900: i := i+1;
1901: l_v_msg(i) := g_v_disb_amount||' : '|| l_disb_gross_amt;
1902: IF p_award_type = 'A' THEN
1903: create_disb_dtl (l_award_id, l_n_disb_num);

Line 2397: g_v_log_text := igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_mode);

2393: l_b_test_mode := FALSE;
2394: g_v_log_text := NULL;
2395: ELSE
2396: l_b_test_mode := TRUE;
2397: g_v_log_text := igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_mode);
2398: END IF;
2399: ELSE
2400: l_b_test_mode := FALSE;
2401: g_v_log_text := NULL;