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_SP_AWARD dependencies on FND_MESSAGE

Line 568: fnd_message.set_name('IGS',l_v_message_name);

564: p_ret_ci_sequence_number => l_n_fee_ci_seq_num,
565: p_message_name => l_v_message_name)) THEN
566: -- If there was any error in retrieving the calendar info, return 0
567: IF l_v_message_name IS NOT NULL THEN
568: fnd_message.set_name('IGS',l_v_message_name);
569: fnd_file.put_line(fnd_file.log,fnd_message.get);
570: RETURN 0;
571: END IF;
572: END IF;

Line 569: fnd_file.put_line(fnd_file.log,fnd_message.get);

565: p_message_name => l_v_message_name)) THEN
566: -- If there was any error in retrieving the calendar info, return 0
567: IF l_v_message_name IS NOT NULL THEN
568: fnd_message.set_name('IGS',l_v_message_name);
569: fnd_file.put_line(fnd_file.log,fnd_message.get);
570: RETURN 0;
571: END IF;
572: END IF;
573:

Line 1106: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');

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;
1110: l_n_cnt := NVL(l_n_cnt,0) + 1;

Line 1107: fnd_file.put_line(fnd_file.log,fnd_message.get);

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;
1110: l_n_cnt := NVL(l_n_cnt,0) + 1;
1111: g_rowid := NULL;

Line 1164: fnd_message.set_name('IGF','IGF_SP_CREATE_AWARD');

1160: );
1161:
1162: -- Log Message only once and when the Fee Class Details are defined
1163: IF l_n_cnt = 1 THEN
1164: fnd_message.set_name('IGF','IGF_SP_CREATE_AWARD');
1165: fnd_file.put_line(fnd_file.log,fnd_message.get);
1166: log_parameters(g_v_award_id,l_award_id);
1167: END IF;
1168:

Line 1165: fnd_file.put_line(fnd_file.log,fnd_message.get);

1161:
1162: -- Log Message only once and when the Fee Class Details are defined
1163: IF l_n_cnt = 1 THEN
1164: fnd_message.set_name('IGF','IGF_SP_CREATE_AWARD');
1165: fnd_file.put_line(fnd_file.log,fnd_message.get);
1166: log_parameters(g_v_award_id,l_award_id);
1167: END IF;
1168:
1169: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');

Line 1169: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');

1165: fnd_file.put_line(fnd_file.log,fnd_message.get);
1166: log_parameters(g_v_award_id,l_award_id);
1167: END IF;
1168:
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));

Line 1170: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));

1166: log_parameters(g_v_award_id,l_award_id);
1167: END IF;
1168:
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);

Line 1171: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

Line 1257: fnd_message.set_name('IGF','IGF_SP_CREATE_AWARD');

1253: x_notification_status_date => NULL,
1254: x_publish_in_ss_flag => 'N'
1255: );
1256:
1257: fnd_message.set_name('IGF','IGF_SP_CREATE_AWARD');
1258: fnd_file.put_line(fnd_file.log,fnd_message.get);
1259: log_parameters(g_v_award_id,l_award_id);
1260:
1261: l_disb_num := get_disb_num (l_award_id);

Line 1258: fnd_file.put_line(fnd_file.log,fnd_message.get);

1254: x_publish_in_ss_flag => 'N'
1255: );
1256:
1257: fnd_message.set_name('IGF','IGF_SP_CREATE_AWARD');
1258: fnd_file.put_line(fnd_file.log,fnd_message.get);
1259: log_parameters(g_v_award_id,l_award_id);
1260:
1261: l_disb_num := get_disb_num (l_award_id);
1262: g_rowid := NULL;

Line 1312: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');

1308: x_fund_return_mthd_code => NULL,
1309: x_direct_to_borr_flag => 'N'
1310: );
1311:
1312: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
1313: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));
1314: fnd_file.put_line(fnd_file.log,fnd_message.get);
1315: log_parameters(g_v_disb_fee_class,NULL);
1316: log_parameters(g_v_disb_amount,l_n_tot_spns_amt);

Line 1313: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));

1309: x_direct_to_borr_flag => 'N'
1310: );
1311:
1312: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
1313: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));
1314: fnd_file.put_line(fnd_file.log,fnd_message.get);
1315: log_parameters(g_v_disb_fee_class,NULL);
1316: log_parameters(g_v_disb_amount,l_n_tot_spns_amt);
1317: log_parameters(g_v_award_amount,l_n_tot_spns_amt);

Line 1314: fnd_file.put_line(fnd_file.log,fnd_message.get);

1310: );
1311:
1312: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
1313: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));
1314: fnd_file.put_line(fnd_file.log,fnd_message.get);
1315: log_parameters(g_v_disb_fee_class,NULL);
1316: log_parameters(g_v_disb_amount,l_n_tot_spns_amt);
1317: log_parameters(g_v_award_amount,l_n_tot_spns_amt);
1318: -- create disb detail adjustment

Line 1466: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');

1462: log_parameters(g_v_award_id,l_award_id);
1463: g_b_msg_logged := TRUE;
1464: END IF;
1465:
1466: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1467: fnd_file.put_line(fnd_file.log,fnd_message.get);
1468: -- make trans type P to A
1469: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1470: x_award_id => rec_aw_awd_disb.award_id ,

Line 1467: fnd_file.put_line(fnd_file.log,fnd_message.get);

1463: g_b_msg_logged := TRUE;
1464: END IF;
1465:
1466: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1467: fnd_file.put_line(fnd_file.log,fnd_message.get);
1468: -- make trans type P to A
1469: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1470: x_award_id => rec_aw_awd_disb.award_id ,
1471: x_disb_num => rec_aw_awd_disb.disb_num ,

Line 1525: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');

1521: END LOOP;
1522: IF g_b_msg_logged THEN
1523: log_parameters(g_v_award_amount,get_award_amount(l_award_id));
1524: ELSE
1525: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1526: fnd_file.put_line(fnd_file.log, fnd_message.get);
1527: log_parameters(g_v_award_id,l_award_id);
1528: END IF;
1529: ELSIF l_manual_update = 'N' AND p_n_total_spnsr_amt IS NOT NULL AND p_award_type = 'A' THEN

Line 1526: fnd_file.put_line(fnd_file.log, fnd_message.get);

1522: IF g_b_msg_logged THEN
1523: log_parameters(g_v_award_amount,get_award_amount(l_award_id));
1524: ELSE
1525: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1526: fnd_file.put_line(fnd_file.log, fnd_message.get);
1527: log_parameters(g_v_award_id,l_award_id);
1528: END IF;
1529: ELSIF l_manual_update = 'N' AND p_n_total_spnsr_amt IS NOT NULL AND p_award_type = 'A' THEN
1530: -- When invoked in the Actual Mode then get all the Planned Disbursement Records and check if the

Line 1539: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');

1535: p_min_credit_points => p_min_credit_points ,
1536: p_ld_cal_type => p_ld_cal_type,
1537: p_ld_sequence_number => p_ld_sequence_number ) THEN
1538: log_parameters(g_v_disb_fee_class,NULL);
1539: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1540: fnd_file.put_line(fnd_file.log,fnd_message.get);
1541: ELSE
1542: log_parameters(g_v_award_id,l_award_id);
1543:

Line 1540: fnd_file.put_line(fnd_file.log,fnd_message.get);

1536: p_ld_cal_type => p_ld_cal_type,
1537: p_ld_sequence_number => p_ld_sequence_number ) THEN
1538: log_parameters(g_v_disb_fee_class,NULL);
1539: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1540: fnd_file.put_line(fnd_file.log,fnd_message.get);
1541: ELSE
1542: log_parameters(g_v_award_id,l_award_id);
1543:
1544: -- Fetch the Disbursement Amount using the following function.

Line 1556: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');

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')
1555: LOOP
1556: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1557: fnd_file.put_line(fnd_file.log,fnd_message.get);
1558: -- make trans type P to A
1559: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1560: x_award_id => rec_aw_awd_disb.award_id ,

Line 1557: fnd_file.put_line(fnd_file.log,fnd_message.get);

1553: -- the award type is A
1554: FOR rec_aw_awd_disb IN c_aw_awd_disb (l_award_id,NULL,'P')
1555: LOOP
1556: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1557: fnd_file.put_line(fnd_file.log,fnd_message.get);
1558: -- make trans type P to A
1559: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1560: x_award_id => rec_aw_awd_disb.award_id ,
1561: x_disb_num => rec_aw_awd_disb.disb_num ,

Line 1657: fnd_message.set_name('IGF','IGF_SP_NO_UPDATE_DISB');

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));
1659: l_v_msg(i) := fnd_message.get;
1660: ELSE
1661: IF NVL(l_disb_gross_amt,0) <> rec_aw_awd_disb.disb_net_amt THEN

Line 1658: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));

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));
1659: l_v_msg(i) := fnd_message.get;
1660: ELSE
1661: IF NVL(l_disb_gross_amt,0) <> rec_aw_awd_disb.disb_net_amt THEN
1662: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');

Line 1659: l_v_msg(i) := fnd_message.get;

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));
1659: l_v_msg(i) := fnd_message.get;
1660: ELSE
1661: IF NVL(l_disb_gross_amt,0) <> rec_aw_awd_disb.disb_net_amt THEN
1662: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');
1663: l_v_upd_msg_text := fnd_message.get;

Line 1662: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');

1658: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));
1659: l_v_msg(i) := fnd_message.get;
1660: ELSE
1661: IF NVL(l_disb_gross_amt,0) <> rec_aw_awd_disb.disb_net_amt THEN
1662: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');
1663: l_v_upd_msg_text := fnd_message.get;
1664: IF rec_aw_awd_disb.trans_type = 'P' AND p_award_type = 'A' THEN
1665: i := i+1;
1666: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');

Line 1663: l_v_upd_msg_text := fnd_message.get;

1659: l_v_msg(i) := fnd_message.get;
1660: ELSE
1661: IF NVL(l_disb_gross_amt,0) <> rec_aw_awd_disb.disb_net_amt THEN
1662: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');
1663: l_v_upd_msg_text := fnd_message.get;
1664: IF rec_aw_awd_disb.trans_type = 'P' AND p_award_type = 'A' THEN
1665: i := i+1;
1666: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1667: l_v_msg(i) := fnd_message.get;

Line 1666: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');

1662: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');
1663: l_v_upd_msg_text := fnd_message.get;
1664: IF rec_aw_awd_disb.trans_type = 'P' AND p_award_type = 'A' THEN
1665: i := i+1;
1666: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1667: l_v_msg(i) := fnd_message.get;
1668: ELSE
1669: i := i+1;
1670: fnd_message.set_name('IGF','IGF_SP_UPDATE_DISB');

Line 1667: l_v_msg(i) := fnd_message.get;

1663: l_v_upd_msg_text := fnd_message.get;
1664: IF rec_aw_awd_disb.trans_type = 'P' AND p_award_type = 'A' THEN
1665: i := i+1;
1666: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1667: l_v_msg(i) := fnd_message.get;
1668: ELSE
1669: i := i+1;
1670: fnd_message.set_name('IGF','IGF_SP_UPDATE_DISB');
1671: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));

Line 1670: fnd_message.set_name('IGF','IGF_SP_UPDATE_DISB');

1666: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1667: l_v_msg(i) := fnd_message.get;
1668: ELSE
1669: i := i+1;
1670: fnd_message.set_name('IGF','IGF_SP_UPDATE_DISB');
1671: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));
1672: l_v_msg(i) := fnd_message.get;
1673: END IF;
1674:

Line 1671: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));

1667: l_v_msg(i) := fnd_message.get;
1668: ELSE
1669: i := i+1;
1670: fnd_message.set_name('IGF','IGF_SP_UPDATE_DISB');
1671: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));
1672: l_v_msg(i) := fnd_message.get;
1673: END IF;
1674:
1675: i := i+1;

Line 1672: l_v_msg(i) := fnd_message.get;

1668: ELSE
1669: i := i+1;
1670: fnd_message.set_name('IGF','IGF_SP_UPDATE_DISB');
1671: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));
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);

Line 1736: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');

1732: create_disb_dtl (rec_aw_awd_disb.award_id, rec_aw_awd_disb.disb_num);
1733: END IF;
1734: ELSE
1735: IF p_award_type ='A' AND rec_aw_awd_disb.trans_type = 'P' THEN
1736: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1737: i := i+1;
1738: l_v_msg(i) := fnd_message.get;
1739:
1740: i := i+1;

Line 1738: l_v_msg(i) := fnd_message.get;

1734: ELSE
1735: IF p_award_type ='A' AND rec_aw_awd_disb.trans_type = 'P' THEN
1736: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
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:

Line 1804: fnd_message.set_name('IGF','IGF_SP_NO_UPDATE_DISB');

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;
1807: l_v_msg(i) := fnd_message.get;
1808: END IF;

Line 1805: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));

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;
1807: l_v_msg(i) := fnd_message.get;
1808: END IF;
1809: END IF;

Line 1807: l_v_msg(i) := fnd_message.get;

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;
1807: l_v_msg(i) := fnd_message.get;
1808: END IF;
1809: END IF;
1810: END IF;
1811: ELSE

Line 1814: fnd_message.set_name('IGF','IGF_SP_NO_UPDATE_DISB');

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

Line 1815: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',rec_aw_awd_disb.trans_type));

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;
1818: END IF;
1819: ELSE

Line 1817: l_v_msg(i) := fnd_message.get;

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;
1818: END IF;
1819: ELSE
1820: -- a new record needs to be created.
1821: l_disb_gross_amt := recal_dis_gross_amt (p_spnsr_stdnt_id => p_spnsr_stdnt_id,

Line 1835: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');

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;
1837: ELSE
1838: g_rowid := NULL;
1839: l_n_disb_num := get_disb_num(l_award_id);

Line 1836: l_v_msg(i) := fnd_message.get;

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;
1837: ELSE
1838: g_rowid := NULL;
1839: l_n_disb_num := get_disb_num(l_award_id);
1840: g_b_award_updated := TRUE;

Line 1842: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');

1838: g_rowid := NULL;
1839: l_n_disb_num := get_disb_num(l_award_id);
1840: g_b_award_updated := TRUE;
1841:
1842: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');
1843: l_v_upd_msg_text := fnd_message.get;
1844:
1845:
1846: igf_aw_awd_disb_pkg.insert_row(x_rowid => g_rowid,

Line 1843: l_v_upd_msg_text := fnd_message.get;

1839: l_n_disb_num := get_disb_num(l_award_id);
1840: g_b_award_updated := TRUE;
1841:
1842: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');
1843: l_v_upd_msg_text := fnd_message.get;
1844:
1845:
1846: igf_aw_awd_disb_pkg.insert_row(x_rowid => g_rowid,
1847: x_award_id => l_award_id,

Line 1894: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');

1890: x_fund_return_mthd_code => NULL,
1891: x_direct_to_borr_flag => 'N'
1892: );
1893:
1894: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
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;

Line 1895: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));

1891: x_direct_to_borr_flag => 'N'
1892: );
1893:
1894: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
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);

Line 1897: l_v_msg(i) := fnd_message.get;

1893:
1894: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
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;

Line 1951: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');

1947: END LOOP;
1948: -- Once the messages are logged clear the table contents
1949: l_v_msg := l_v_msg_null;
1950: ELSE
1951: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1952: fnd_file.put_line(fnd_file.log, fnd_message.get);
1953: log_parameters(g_v_award_id,l_award_id);
1954: END IF;
1955: ELSE

Line 1952: fnd_file.put_line(fnd_file.log, fnd_message.get);

1948: -- Once the messages are logged clear the table contents
1949: l_v_msg := l_v_msg_null;
1950: ELSE
1951: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1952: fnd_file.put_line(fnd_file.log, fnd_message.get);
1953: log_parameters(g_v_award_id,l_award_id);
1954: END IF;
1955: ELSE
1956: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');

Line 1956: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');

1952: fnd_file.put_line(fnd_file.log, fnd_message.get);
1953: log_parameters(g_v_award_id,l_award_id);
1954: END IF;
1955: ELSE
1956: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1957: fnd_file.put_line(fnd_file.log, fnd_message.get);
1958: log_parameters(g_v_award_id,l_award_id);
1959: END IF;-- check for manual update
1960: END LOOP;

Line 1957: fnd_file.put_line(fnd_file.log, fnd_message.get);

1953: log_parameters(g_v_award_id,l_award_id);
1954: END IF;
1955: ELSE
1956: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1957: fnd_file.put_line(fnd_file.log, fnd_message.get);
1958: log_parameters(g_v_award_id,l_award_id);
1959: END IF;-- check for manual update
1960: END LOOP;
1961: CLOSE c_manual_update;

Line 1972: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');

1968: p_min_credit_points,
1969: p_ld_cal_type,
1970: p_ld_sequence_number) THEN
1971: log_parameters(g_v_disb_fee_class,NULL);
1972: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1973: fnd_file.put_line(fnd_file.log,fnd_message.get);
1974: ELSE
1975: create_aw_award (p_fund_id => p_fund_id,
1976: p_base_id => p_base_id,

Line 1973: fnd_file.put_line(fnd_file.log,fnd_message.get);

1969: p_ld_cal_type,
1970: p_ld_sequence_number) THEN
1971: log_parameters(g_v_disb_fee_class,NULL);
1972: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1973: fnd_file.put_line(fnd_file.log,fnd_message.get);
1974: ELSE
1975: create_aw_award (p_fund_id => p_fund_id,
1976: p_base_id => p_base_id,
1977: p_ld_cal_type => p_ld_cal_type,

Line 2107: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');

2103: rec_sp_std_dtls.min_credit_points,
2104: rec_sp_std_dtls.ld_cal_type,
2105: rec_sp_std_dtls.ld_sequence_number) THEN
2106: log_parameters(g_v_disb_fee_class,NULL);
2107: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
2108: fnd_file.put_line(fnd_file.log,fnd_message.get);
2109: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));
2110: EXIT;
2111: ELSE

Line 2108: fnd_file.put_line(fnd_file.log,fnd_message.get);

2104: rec_sp_std_dtls.ld_cal_type,
2105: rec_sp_std_dtls.ld_sequence_number) THEN
2106: log_parameters(g_v_disb_fee_class,NULL);
2107: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
2108: fnd_file.put_line(fnd_file.log,fnd_message.get);
2109: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));
2110: EXIT;
2111: ELSE
2112: loop_thru_spnsr_dtl_pvt(p_person_id => rec_sp_std_dtls.person_id,

Line 2410: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

2406: -- check if the input parameters are not valid
2407: -- when not valid then return from the process after logging which all parameters are not valid
2408: IF NOT l_b_award_year THEN
2409: l_b_param_valid := FALSE;
2410: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2411: fnd_message.set_token('PARAMETER',g_v_award_yr);
2412: fnd_file.put_line(fnd_file.log, fnd_message.get);
2413: END IF;
2414:

Line 2411: fnd_message.set_token('PARAMETER',g_v_award_yr);

2407: -- when not valid then return from the process after logging which all parameters are not valid
2408: IF NOT l_b_award_year THEN
2409: l_b_param_valid := FALSE;
2410: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2411: fnd_message.set_token('PARAMETER',g_v_award_yr);
2412: fnd_file.put_line(fnd_file.log, fnd_message.get);
2413: END IF;
2414:
2415: IF NOT l_b_term THEN

Line 2412: fnd_file.put_line(fnd_file.log, fnd_message.get);

2408: IF NOT l_b_award_year THEN
2409: l_b_param_valid := FALSE;
2410: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2411: fnd_message.set_token('PARAMETER',g_v_award_yr);
2412: fnd_file.put_line(fnd_file.log, fnd_message.get);
2413: END IF;
2414:
2415: IF NOT l_b_term THEN
2416: l_b_param_valid := FALSE;

Line 2417: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

2413: END IF;
2414:
2415: IF NOT l_b_term THEN
2416: l_b_param_valid := FALSE;
2417: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2418: fnd_message.set_token('PARAMETER',g_v_term);
2419: fnd_file.put_line(fnd_file.log, fnd_message.get);
2420: END IF;
2421:

Line 2418: fnd_message.set_token('PARAMETER',g_v_term);

2414:
2415: IF NOT l_b_term THEN
2416: l_b_param_valid := FALSE;
2417: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2418: fnd_message.set_token('PARAMETER',g_v_term);
2419: fnd_file.put_line(fnd_file.log, fnd_message.get);
2420: END IF;
2421:
2422: IF NOT l_b_person_number THEN

Line 2419: fnd_file.put_line(fnd_file.log, fnd_message.get);

2415: IF NOT l_b_term THEN
2416: l_b_param_valid := FALSE;
2417: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2418: fnd_message.set_token('PARAMETER',g_v_term);
2419: fnd_file.put_line(fnd_file.log, fnd_message.get);
2420: END IF;
2421:
2422: IF NOT l_b_person_number THEN
2423: l_b_param_valid := FALSE;

Line 2424: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

2420: END IF;
2421:
2422: IF NOT l_b_person_number THEN
2423: l_b_param_valid := FALSE;
2424: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2425: fnd_message.set_token('PARAMETER',g_v_person_num_pmt);
2426: fnd_file.put_line(fnd_file.log, fnd_message.get);
2427: END IF;
2428:

Line 2425: fnd_message.set_token('PARAMETER',g_v_person_num_pmt);

2421:
2422: IF NOT l_b_person_number THEN
2423: l_b_param_valid := FALSE;
2424: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2425: fnd_message.set_token('PARAMETER',g_v_person_num_pmt);
2426: fnd_file.put_line(fnd_file.log, fnd_message.get);
2427: END IF;
2428:
2429: -- If the person group validation has failed earlier or the person group

Line 2426: fnd_file.put_line(fnd_file.log, fnd_message.get);

2422: IF NOT l_b_person_number THEN
2423: l_b_param_valid := FALSE;
2424: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2425: fnd_message.set_token('PARAMETER',g_v_person_num_pmt);
2426: fnd_file.put_line(fnd_file.log, fnd_message.get);
2427: END IF;
2428:
2429: -- If the person group validation has failed earlier or the person group
2430: -- is closed, then error message is logged

Line 2433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

2429: -- If the person group validation has failed earlier or the person group
2430: -- is closed, then error message is logged
2431: IF NOT l_b_person_group OR NVL(l_c_pers_id_grp.closed_ind,'N') = 'Y' THEN
2432: l_b_param_valid := FALSE;
2433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2434: fnd_message.set_token('PARAMETER',g_v_person_group);
2435: fnd_file.put_line(fnd_file.log, fnd_message.get);
2436: END IF;
2437:

Line 2434: fnd_message.set_token('PARAMETER',g_v_person_group);

2430: -- is closed, then error message is logged
2431: IF NOT l_b_person_group OR NVL(l_c_pers_id_grp.closed_ind,'N') = 'Y' THEN
2432: l_b_param_valid := FALSE;
2433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2434: fnd_message.set_token('PARAMETER',g_v_person_group);
2435: fnd_file.put_line(fnd_file.log, fnd_message.get);
2436: END IF;
2437:
2438: IF NOT l_b_sponsor_code THEN

Line 2435: fnd_file.put_line(fnd_file.log, fnd_message.get);

2431: IF NOT l_b_person_group OR NVL(l_c_pers_id_grp.closed_ind,'N') = 'Y' THEN
2432: l_b_param_valid := FALSE;
2433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2434: fnd_message.set_token('PARAMETER',g_v_person_group);
2435: fnd_file.put_line(fnd_file.log, fnd_message.get);
2436: END IF;
2437:
2438: IF NOT l_b_sponsor_code THEN
2439: l_b_param_valid := FALSE;

Line 2440: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

2436: END IF;
2437:
2438: IF NOT l_b_sponsor_code THEN
2439: l_b_param_valid := FALSE;
2440: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2441: fnd_message.set_token('PARAMETER',g_v_spnr_cd);
2442: fnd_file.put_line(fnd_file.log, fnd_message.get);
2443: END IF;
2444:

Line 2441: fnd_message.set_token('PARAMETER',g_v_spnr_cd);

2437:
2438: IF NOT l_b_sponsor_code THEN
2439: l_b_param_valid := FALSE;
2440: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2441: fnd_message.set_token('PARAMETER',g_v_spnr_cd);
2442: fnd_file.put_line(fnd_file.log, fnd_message.get);
2443: END IF;
2444:
2445: IF NOT l_b_award_type THEN

Line 2442: fnd_file.put_line(fnd_file.log, fnd_message.get);

2438: IF NOT l_b_sponsor_code THEN
2439: l_b_param_valid := FALSE;
2440: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2441: fnd_message.set_token('PARAMETER',g_v_spnr_cd);
2442: fnd_file.put_line(fnd_file.log, fnd_message.get);
2443: END IF;
2444:
2445: IF NOT l_b_award_type THEN
2446: l_b_param_valid := FALSE;

Line 2447: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

2443: END IF;
2444:
2445: IF NOT l_b_award_type THEN
2446: l_b_param_valid := FALSE;
2447: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2448: fnd_message.set_token('PARAMETER',g_v_award_type);
2449: fnd_file.put_line(fnd_file.log, fnd_message.get);
2450: END IF;
2451:

Line 2448: fnd_message.set_token('PARAMETER',g_v_award_type);

2444:
2445: IF NOT l_b_award_type THEN
2446: l_b_param_valid := FALSE;
2447: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2448: fnd_message.set_token('PARAMETER',g_v_award_type);
2449: fnd_file.put_line(fnd_file.log, fnd_message.get);
2450: END IF;
2451:
2452: IF NOT l_b_test_mode THEN

Line 2449: fnd_file.put_line(fnd_file.log, fnd_message.get);

2445: IF NOT l_b_award_type THEN
2446: l_b_param_valid := FALSE;
2447: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2448: fnd_message.set_token('PARAMETER',g_v_award_type);
2449: fnd_file.put_line(fnd_file.log, fnd_message.get);
2450: END IF;
2451:
2452: IF NOT l_b_test_mode THEN
2453: l_b_param_valid := FALSE;

Line 2454: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

2450: END IF;
2451:
2452: IF NOT l_b_test_mode THEN
2453: l_b_param_valid := FALSE;
2454: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2455: fnd_message.set_token('PARAMETER',g_v_test_mode);
2456: fnd_file.put_line(fnd_file.log, fnd_message.get);
2457: END IF;
2458:

Line 2455: fnd_message.set_token('PARAMETER',g_v_test_mode);

2451:
2452: IF NOT l_b_test_mode THEN
2453: l_b_param_valid := FALSE;
2454: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2455: fnd_message.set_token('PARAMETER',g_v_test_mode);
2456: fnd_file.put_line(fnd_file.log, fnd_message.get);
2457: END IF;
2458:
2459: IF NOT l_b_param_valid THEN

Line 2456: fnd_file.put_line(fnd_file.log, fnd_message.get);

2452: IF NOT l_b_test_mode THEN
2453: l_b_param_valid := FALSE;
2454: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2455: fnd_message.set_token('PARAMETER',g_v_test_mode);
2456: fnd_file.put_line(fnd_file.log, fnd_message.get);
2457: END IF;
2458:
2459: IF NOT l_b_param_valid THEN
2460: RETURN;

Line 2468: fnd_message.set_name('IGS','IGS_FI_PRS_OR_PRSIDGRP');

2464: -- both p_person_id and person_group_id cannot be passed at a time
2465: IF p_person_id IS NOT NULL AND p_person_group_id IS NOT NULL THEN
2466: retcode := 2;
2467: -- Removed assignment of error message to errbuf to prevent dual messages appearing in the log
2468: fnd_message.set_name('IGS','IGS_FI_PRS_OR_PRSIDGRP');
2469: fnd_file.put_line(fnd_file.log, fnd_message.get);
2470: RETURN;
2471: END IF;
2472:

Line 2469: fnd_file.put_line(fnd_file.log, fnd_message.get);

2465: IF p_person_id IS NOT NULL AND p_person_group_id IS NOT NULL THEN
2466: retcode := 2;
2467: -- Removed assignment of error message to errbuf to prevent dual messages appearing in the log
2468: fnd_message.set_name('IGS','IGS_FI_PRS_OR_PRSIDGRP');
2469: fnd_file.put_line(fnd_file.log, fnd_message.get);
2470: RETURN;
2471: END IF;
2472:
2473: --Validate the Award Year Status. If the status is not open, log the message in log file and

Line 2483: fnd_message.set_name('IGF',l_v_message_name);

2479: p_v_message_name => l_v_message_name
2480: );
2481: IF l_v_message_name IS NOT NULL THEN
2482: IF l_v_message_name = 'IGF_SP_INVALID_AWD_YR_STATUS' THEN
2483: fnd_message.set_name('IGF',l_v_message_name);
2484: ELSE
2485: fnd_message.set_name('IGS',l_v_message_name);
2486: END IF;
2487: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 2485: fnd_message.set_name('IGS',l_v_message_name);

2481: IF l_v_message_name IS NOT NULL THEN
2482: IF l_v_message_name = 'IGF_SP_INVALID_AWD_YR_STATUS' THEN
2483: fnd_message.set_name('IGF',l_v_message_name);
2484: ELSE
2485: fnd_message.set_name('IGS',l_v_message_name);
2486: END IF;
2487: fnd_file.put_line(fnd_file.log,fnd_message.get);
2488: retcode := 2;
2489: RETURN;

Line 2487: fnd_file.put_line(fnd_file.log,fnd_message.get);

2483: fnd_message.set_name('IGF',l_v_message_name);
2484: ELSE
2485: fnd_message.set_name('IGS',l_v_message_name);
2486: END IF;
2487: fnd_file.put_line(fnd_file.log,fnd_message.get);
2488: retcode := 2;
2489: RETURN;
2490: END IF;
2491:

Line 2498: fnd_message.set_name('IGS',l_v_message_name);

2494: igs_fi_com_rec_interface.chk_manage_account( p_v_manage_acc => l_v_manage_acc,
2495: p_v_message_name => l_v_message_name);
2496: IF (l_v_manage_acc IS NULL) THEN
2497: retcode := 2;
2498: fnd_message.set_name('IGS',l_v_message_name);
2499: fnd_file.put_line(fnd_file.log,fnd_message.get);
2500: RETURN;
2501: END IF;
2502:

Line 2499: fnd_file.put_line(fnd_file.log,fnd_message.get);

2495: p_v_message_name => l_v_message_name);
2496: IF (l_v_manage_acc IS NULL) THEN
2497: retcode := 2;
2498: fnd_message.set_name('IGS',l_v_message_name);
2499: fnd_file.put_line(fnd_file.log,fnd_message.get);
2500: RETURN;
2501: END IF;
2502:
2503: -- Get the select statement when the person id Group is provided

Line 2559: fnd_message.set_name('IGF','IGF_SP_TEST_MODE');

2555: -- if the job is run with test_mode set to Y, rollback the transaction
2556: IF g_b_records_found THEN
2557: IF p_test_mode = 'Y' THEN
2558: fnd_file.put_line(fnd_file.log,'');
2559: fnd_message.set_name('IGF','IGF_SP_TEST_MODE');
2560: fnd_file.put_line(fnd_file.log,fnd_message.get);
2561: END IF;
2562: ELSE
2563: fnd_file.put_line(fnd_file.log,'');

Line 2560: fnd_file.put_line(fnd_file.log,fnd_message.get);

2556: IF g_b_records_found THEN
2557: IF p_test_mode = 'Y' THEN
2558: fnd_file.put_line(fnd_file.log,'');
2559: fnd_message.set_name('IGF','IGF_SP_TEST_MODE');
2560: fnd_file.put_line(fnd_file.log,fnd_message.get);
2561: END IF;
2562: ELSE
2563: fnd_file.put_line(fnd_file.log,'');
2564: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');

Line 2564: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');

2560: fnd_file.put_line(fnd_file.log,fnd_message.get);
2561: END IF;
2562: ELSE
2563: fnd_file.put_line(fnd_file.log,'');
2564: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
2565: fnd_file.put_line(fnd_file.log,fnd_message.get);
2566: END IF;
2567:
2568: EXCEPTION

Line 2565: fnd_file.put_line(fnd_file.log,fnd_message.get);

2561: END IF;
2562: ELSE
2563: fnd_file.put_line(fnd_file.log,'');
2564: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
2565: fnd_file.put_line(fnd_file.log,fnd_message.get);
2566: END IF;
2567:
2568: EXCEPTION
2569: WHEN OTHERS THEN

Line 2573: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2569: WHEN OTHERS THEN
2570: ROLLBACK;
2571: fnd_file.put_line(fnd_file.log,SQLERRM);
2572: retcode := 2 ;
2573: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2574: fnd_message.set_token('NAME','CREATE_AWARD_DISB');
2575: errbuf := fnd_message.get||' - '||SQLERRM;
2576: igs_ge_msg_stack.conc_exception_hndl ;
2577: END create_award_disb;

Line 2574: fnd_message.set_token('NAME','CREATE_AWARD_DISB');

2570: ROLLBACK;
2571: fnd_file.put_line(fnd_file.log,SQLERRM);
2572: retcode := 2 ;
2573: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2574: fnd_message.set_token('NAME','CREATE_AWARD_DISB');
2575: errbuf := fnd_message.get||' - '||SQLERRM;
2576: igs_ge_msg_stack.conc_exception_hndl ;
2577: END create_award_disb;
2578: END igf_sp_award;

Line 2575: errbuf := fnd_message.get||' - '||SQLERRM;

2571: fnd_file.put_line(fnd_file.log,SQLERRM);
2572: retcode := 2 ;
2573: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2574: fnd_message.set_token('NAME','CREATE_AWARD_DISB');
2575: errbuf := fnd_message.get||' - '||SQLERRM;
2576: igs_ge_msg_stack.conc_exception_hndl ;
2577: END create_award_disb;
2578: END igf_sp_award;