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

Line 66: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

62: END IF;
63: EXCEPTION
64: WHEN OTHERS
65: THEN
66: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
67: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.GET_FUND_DESC ' || SQLERRM);
68: fnd_file.put_line(fnd_file.log, SQLERRM);
69: igs_ge_msg_stack.ADD;
70: app_exception.raise_exception;

Line 67: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.GET_FUND_DESC ' || SQLERRM);

63: EXCEPTION
64: WHEN OTHERS
65: THEN
66: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
67: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.GET_FUND_DESC ' || SQLERRM);
68: fnd_file.put_line(fnd_file.log, SQLERRM);
69: igs_ge_msg_stack.ADD;
70: app_exception.raise_exception;
71: END get_fund_desc;

Line 131: p_result := fnd_message.get;

127: );
128: EXCEPTION
129: WHEN OTHERS
130: THEN
131: p_result := fnd_message.get;
132: RETURN FALSE;
133: END;
134:
135: OPEN cur_get_range(p_load_cal_type, l_key_att_type);

Line 161: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

157: END IF;
158: EXCEPTION
159: WHEN OTHERS
160: THEN
161: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
162: fnd_message.set_token(
163: 'NAME', 'igf_sl_rel_disb.chk_attendance' || SQLERRM
164: );
165: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 162: fnd_message.set_token(

158: EXCEPTION
159: WHEN OTHERS
160: THEN
161: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
162: fnd_message.set_token(
163: 'NAME', 'igf_sl_rel_disb.chk_attendance' || SQLERRM
164: );
165: fnd_file.put_line(fnd_file.log, SQLERRM);
166: igs_ge_msg_stack.ADD;

Line 227: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

223: END IF;
224: EXCEPTION
225: WHEN OTHERS
226: THEN
227: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token(
229: 'NAME', 'IGF_SL_REL_DISB.CHK_FED_ELIG ' || SQLERRM
230: );
231: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 228: fnd_message.set_token(

224: EXCEPTION
225: WHEN OTHERS
226: THEN
227: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token(
229: 'NAME', 'IGF_SL_REL_DISB.CHK_FED_ELIG ' || SQLERRM
230: );
231: fnd_file.put_line(fnd_file.log, SQLERRM);
232: igs_ge_msg_stack.ADD;

Line 269: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

265: END IF;
266: EXCEPTION
267: WHEN OTHERS
268: THEN
269: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
270: fnd_message.set_token(
271: 'NAME', 'IGF_SL_REL_DISB.CHK_FED_ELIG ' || SQLERRM
272: );
273: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 270: fnd_message.set_token(

266: EXCEPTION
267: WHEN OTHERS
268: THEN
269: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
270: fnd_message.set_token(
271: 'NAME', 'IGF_SL_REL_DISB.CHK_FED_ELIG ' || SQLERRM
272: );
273: fnd_file.put_line(fnd_file.log, SQLERRM);
274: igs_ge_msg_stack.ADD;

Line 329: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

325: END IF;
326: EXCEPTION
327: WHEN OTHERS
328: THEN
329: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
330: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.PER_IN_FA ' || SQLERRM);
331: fnd_file.put_line(fnd_file.log, SQLERRM);
332: igs_ge_msg_stack.ADD;
333: app_exception.raise_exception;

Line 330: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.PER_IN_FA ' || SQLERRM);

326: EXCEPTION
327: WHEN OTHERS
328: THEN
329: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
330: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.PER_IN_FA ' || SQLERRM);
331: fnd_file.put_line(fnd_file.log, SQLERRM);
332: igs_ge_msg_stack.ADD;
333: app_exception.raise_exception;
334: END per_in_fa;

Line 509: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

505: THEN
506: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_rel_dis.log_parameters.exception','Exception:' || SQLERRM);
507: END IF;
508:
509: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
510: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.LOG_PARAMETERS');
511: igs_ge_msg_stack.ADD;
512: END log_parameters;
513:

Line 510: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.LOG_PARAMETERS');

506: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_rel_dis.log_parameters.exception','Exception:' || SQLERRM);
507: END IF;
508:
509: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
510: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.LOG_PARAMETERS');
511: igs_ge_msg_stack.ADD;
512: END log_parameters;
513:
514: FUNCTION chk_fund_meth_dl(

Line 764: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

760: END IF;
761: EXCEPTION
762: WHEN OTHERS
763: THEN
764: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
765: fnd_message.set_token(
766: 'NAME', 'IGF_SL__REL_DISB.CHK_FUND_METHOD_PELL ' || SQLERRM
767: );
768: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 765: fnd_message.set_token(

761: EXCEPTION
762: WHEN OTHERS
763: THEN
764: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
765: fnd_message.set_token(
766: 'NAME', 'IGF_SL__REL_DISB.CHK_FUND_METHOD_PELL ' || SQLERRM
767: );
768: fnd_file.put_line(fnd_file.log, SQLERRM);
769: igs_ge_msg_stack.ADD;

Line 817: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

813: END IF;
814: EXCEPTION
815: WHEN OTHERS
816: THEN
817: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
818: fnd_message.set_token(
819: 'NAME', 'IGF_SL_REL_DISB.CHK_CREDIT_STATUS ' || SQLERRM
820: );
821: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 818: fnd_message.set_token(

814: EXCEPTION
815: WHEN OTHERS
816: THEN
817: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
818: fnd_message.set_token(
819: 'NAME', 'IGF_SL_REL_DISB.CHK_CREDIT_STATUS ' || SQLERRM
820: );
821: fnd_file.put_line(fnd_file.log, SQLERRM);
822: igs_ge_msg_stack.ADD;

Line 993: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

989: RETURN lb_result;
990: EXCEPTION
991: WHEN OTHERS
992: THEN
993: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
994: fnd_message.set_token(
995: 'NAME', 'IGF_SL_REL_DISB.CHK_TODO_RESULT ' || SQLERRM
996: );
997: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 994: fnd_message.set_token(

990: EXCEPTION
991: WHEN OTHERS
992: THEN
993: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
994: fnd_message.set_token(
995: 'NAME', 'IGF_SL_REL_DISB.CHK_TODO_RESULT ' || SQLERRM
996: );
997: fnd_file.put_line(fnd_file.log, SQLERRM);
998: igs_ge_msg_stack.ADD;

Line 1121: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

1117: END LOOP;
1118: EXCEPTION
1119: WHEN OTHERS
1120: THEN
1121: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1122: fnd_message.set_token(
1123: 'NAME', 'IGF_SL_REL_DISB.INSERT_PAYS_PRG_UTS ' || SQLERRM
1124: );
1125: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 1122: fnd_message.set_token(

1118: EXCEPTION
1119: WHEN OTHERS
1120: THEN
1121: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1122: fnd_message.set_token(
1123: 'NAME', 'IGF_SL_REL_DISB.INSERT_PAYS_PRG_UTS ' || SQLERRM
1124: );
1125: fnd_file.put_line(fnd_file.log, SQLERRM);
1126: igs_ge_msg_stack.ADD;

Line 1205: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

1201: END IF;
1202: EXCEPTION
1203: WHEN OTHERS
1204: THEN
1205: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1206: fnd_message.set_token('NAME', 'IGF_DB_DISB.CHK_PAYS_PRG ' || SQLERRM);
1207: fnd_file.put_line(fnd_file.log, SQLERRM);
1208: igs_ge_msg_stack.ADD;
1209: app_exception.raise_exception;

Line 1206: fnd_message.set_token('NAME', 'IGF_DB_DISB.CHK_PAYS_PRG ' || SQLERRM);

1202: EXCEPTION
1203: WHEN OTHERS
1204: THEN
1205: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1206: fnd_message.set_token('NAME', 'IGF_DB_DISB.CHK_PAYS_PRG ' || SQLERRM);
1207: fnd_file.put_line(fnd_file.log, SQLERRM);
1208: igs_ge_msg_stack.ADD;
1209: app_exception.raise_exception;
1210: END chk_pays_prg;

Line 1287: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

1283: END IF;
1284: EXCEPTION
1285: WHEN OTHERS
1286: THEN
1287: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1288: fnd_message.set_token('NAME', 'IGF_DB_DISB.CHK_PAYS_UTS ' || SQLERRM);
1289: fnd_file.put_line(fnd_file.log, SQLERRM);
1290: igs_ge_msg_stack.ADD;
1291: app_exception.raise_exception;

Line 1288: fnd_message.set_token('NAME', 'IGF_DB_DISB.CHK_PAYS_UTS ' || SQLERRM);

1284: EXCEPTION
1285: WHEN OTHERS
1286: THEN
1287: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1288: fnd_message.set_token('NAME', 'IGF_DB_DISB.CHK_PAYS_UTS ' || SQLERRM);
1289: fnd_file.put_line(fnd_file.log, SQLERRM);
1290: igs_ge_msg_stack.ADD;
1291: app_exception.raise_exception;
1292: END chk_pays_uts;

Line 1398: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

1394: END IF;
1395: EXCEPTION
1396: WHEN OTHERS
1397: THEN
1398: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1399: fnd_message.set_token(
1400: 'NAME', 'IGF_DB_DISB.CHK_FCLASS_RESULT ' || SQLERRM
1401: );
1402: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 1399: fnd_message.set_token(

1395: EXCEPTION
1396: WHEN OTHERS
1397: THEN
1398: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1399: fnd_message.set_token(
1400: 'NAME', 'IGF_DB_DISB.CHK_FCLASS_RESULT ' || SQLERRM
1401: );
1402: fnd_file.put_line(fnd_file.log, SQLERRM);
1403: igs_ge_msg_stack.ADD;

Line 1442: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

1438: CLOSE cur_pays_prg;
1439: EXCEPTION
1440: WHEN OTHERS
1441: THEN
1442: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1443: fnd_message.set_token(
1444: 'NAME', 'IGF_SL_REL_DISB.DELETE_PAYS ' || SQLERRM
1445: );
1446: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 1443: fnd_message.set_token(

1439: EXCEPTION
1440: WHEN OTHERS
1441: THEN
1442: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1443: fnd_message.set_token(
1444: 'NAME', 'IGF_SL_REL_DISB.DELETE_PAYS ' || SQLERRM
1445: );
1446: fnd_file.put_line(fnd_file.log, SQLERRM);
1447: igs_ge_msg_stack.ADD;

Line 1487: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

1483: END IF;
1484: EXCEPTION
1485: WHEN OTHERS
1486: THEN
1487: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1488: fnd_message.set_token(
1489: 'NAME', 'IGF_SL_REL_DISB.DELETE_PAYS ' || SQLERRM
1490: );
1491: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 1488: fnd_message.set_token(

1484: EXCEPTION
1485: WHEN OTHERS
1486: THEN
1487: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1488: fnd_message.set_token(
1489: 'NAME', 'IGF_SL_REL_DISB.DELETE_PAYS ' || SQLERRM
1490: );
1491: fnd_file.put_line(fnd_file.log, SQLERRM);
1492: igs_ge_msg_stack.ADD;

Line 1576: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

1572: RETURN ld_cut_off_dt;
1573: EXCEPTION
1574: WHEN OTHERS
1575: THEN
1576: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1577: fnd_message.set_token(
1578: 'NAME', 'IGF_DB_DISB.GET_CUT_OFF_DT ' || SQLERRM
1579: );
1580: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 1577: fnd_message.set_token(

1573: EXCEPTION
1574: WHEN OTHERS
1575: THEN
1576: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1577: fnd_message.set_token(
1578: 'NAME', 'IGF_DB_DISB.GET_CUT_OFF_DT ' || SQLERRM
1579: );
1580: fnd_file.put_line(fnd_file.log, SQLERRM);
1581: igs_ge_msg_stack.ADD;

Line 1696: fnd_message.CLEAR;

1692: THEN
1693: RAISE;
1694: WHEN OTHERS
1695: THEN
1696: fnd_message.CLEAR;
1697: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1698: fnd_message.set_token('NAME', 'IGF_DB_DISB.CREATE_ACTUAL ' || SQLERRM);
1699: fnd_file.put_line(fnd_file.log, SQLERRM);
1700: igs_ge_msg_stack.initialize;

Line 1697: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

1693: RAISE;
1694: WHEN OTHERS
1695: THEN
1696: fnd_message.CLEAR;
1697: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1698: fnd_message.set_token('NAME', 'IGF_DB_DISB.CREATE_ACTUAL ' || SQLERRM);
1699: fnd_file.put_line(fnd_file.log, SQLERRM);
1700: igs_ge_msg_stack.initialize;
1701: igs_ge_msg_stack.ADD;

Line 1698: fnd_message.set_token('NAME', 'IGF_DB_DISB.CREATE_ACTUAL ' || SQLERRM);

1694: WHEN OTHERS
1695: THEN
1696: fnd_message.CLEAR;
1697: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1698: fnd_message.set_token('NAME', 'IGF_DB_DISB.CREATE_ACTUAL ' || SQLERRM);
1699: fnd_file.put_line(fnd_file.log, SQLERRM);
1700: igs_ge_msg_stack.initialize;
1701: igs_ge_msg_stack.ADD;
1702: app_exception.raise_exception;

Line 1994: fnd_message.set_name('IGF', 'IGF_SL_NO_DISB_TO_REL');

1990: END IF;
1991:
1992:
1993: -- No Disbursements found for Student and Fund )
1994: fnd_message.set_name('IGF', 'IGF_SL_NO_DISB_TO_REL');
1995: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
1996: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
1997:
1998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 1995: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));

1991:
1992:
1993: -- No Disbursements found for Student and Fund )
1994: fnd_message.set_name('IGF', 'IGF_SL_NO_DISB_TO_REL');
1995: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
1996: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
1997:
1998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1999: THEN

Line 1996: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));

1992:
1993: -- No Disbursements found for Student and Fund )
1994: fnd_message.set_name('IGF', 'IGF_SL_NO_DISB_TO_REL');
1995: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
1996: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
1997:
1998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1999: THEN
2000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no disbursments availaible for release'|| igf_gr_gen.get_per_num(p_base_id));

Line 2003: p_result := fnd_message.get;

1999: THEN
2000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no disbursments availaible for release'|| igf_gr_gen.get_per_num(p_base_id));
2001: END IF;
2002:
2003: p_result := fnd_message.get;
2004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || p_result);
2005: ELSE -- record found then
2006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2007: THEN

Line 2079: fnd_message.CLEAR;

2075: -- FOR all the records IN CUR_AWD_DISB
2076: LOOP
2077: BEGIN
2078: -- clear message stack
2079: fnd_message.CLEAR;
2080:
2081: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2082: THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_fund_type:' || l_fund_type);

Line 2093: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_STD_FUND');

2089: IF l_old_fund = 0
2090: OR (l_old_fund <> l_new_fund AND l_old_fund > 1)
2091: THEN
2092: fnd_file.new_line(fnd_file.log, 1);
2093: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_STD_FUND');
2094: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
2095: fnd_message.set_token('FDESC', get_fund_desc(awd_disb_rec.fund_id));
2096: fnd_file.put_line(
2097: fnd_file.log, RPAD(' ', 10) || fnd_message.get

Line 2094: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));

2090: OR (l_old_fund <> l_new_fund AND l_old_fund > 1)
2091: THEN
2092: fnd_file.new_line(fnd_file.log, 1);
2093: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_STD_FUND');
2094: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
2095: fnd_message.set_token('FDESC', get_fund_desc(awd_disb_rec.fund_id));
2096: fnd_file.put_line(
2097: fnd_file.log, RPAD(' ', 10) || fnd_message.get
2098: );

Line 2095: fnd_message.set_token('FDESC', get_fund_desc(awd_disb_rec.fund_id));

2091: THEN
2092: fnd_file.new_line(fnd_file.log, 1);
2093: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_STD_FUND');
2094: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
2095: fnd_message.set_token('FDESC', get_fund_desc(awd_disb_rec.fund_id));
2096: fnd_file.put_line(
2097: fnd_file.log, RPAD(' ', 10) || fnd_message.get
2098: );
2099: END IF;

Line 2097: fnd_file.log, RPAD(' ', 10) || fnd_message.get

2093: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_STD_FUND');
2094: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
2095: fnd_message.set_token('FDESC', get_fund_desc(awd_disb_rec.fund_id));
2096: fnd_file.put_line(
2097: fnd_file.log, RPAD(' ', 10) || fnd_message.get
2098: );
2099: END IF;
2100:
2101: fnd_file.new_line(fnd_file.log, 1);

Line 2102: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_AWD_DISB');

2098: );
2099: END IF;
2100:
2101: fnd_file.new_line(fnd_file.log, 1);
2102: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_AWD_DISB');
2103: -- 'Processing disbursement for award ,disbursement '
2104: fnd_message.set_token('AWARD_ID', TO_CHAR(awd_disb_rec.award_id));
2105: fnd_message.set_token('DISB_NUM', TO_CHAR(awd_disb_rec.disb_num));
2106: fnd_file.put_line(fnd_file.log, RPAD(' ', 15) || fnd_message.get);

Line 2104: fnd_message.set_token('AWARD_ID', TO_CHAR(awd_disb_rec.award_id));

2100:
2101: fnd_file.new_line(fnd_file.log, 1);
2102: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_AWD_DISB');
2103: -- 'Processing disbursement for award ,disbursement '
2104: fnd_message.set_token('AWARD_ID', TO_CHAR(awd_disb_rec.award_id));
2105: fnd_message.set_token('DISB_NUM', TO_CHAR(awd_disb_rec.disb_num));
2106: fnd_file.put_line(fnd_file.log, RPAD(' ', 15) || fnd_message.get);
2107: fnd_file.new_line(fnd_file.log, 1);
2108:

Line 2105: fnd_message.set_token('DISB_NUM', TO_CHAR(awd_disb_rec.disb_num));

2101: fnd_file.new_line(fnd_file.log, 1);
2102: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_AWD_DISB');
2103: -- 'Processing disbursement for award ,disbursement '
2104: fnd_message.set_token('AWARD_ID', TO_CHAR(awd_disb_rec.award_id));
2105: fnd_message.set_token('DISB_NUM', TO_CHAR(awd_disb_rec.disb_num));
2106: fnd_file.put_line(fnd_file.log, RPAD(' ', 15) || fnd_message.get);
2107: fnd_file.new_line(fnd_file.log, 1);
2108:
2109: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 2106: fnd_file.put_line(fnd_file.log, RPAD(' ', 15) || fnd_message.get);

2102: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_AWD_DISB');
2103: -- 'Processing disbursement for award ,disbursement '
2104: fnd_message.set_token('AWARD_ID', TO_CHAR(awd_disb_rec.award_id));
2105: fnd_message.set_token('DISB_NUM', TO_CHAR(awd_disb_rec.disb_num));
2106: fnd_file.put_line(fnd_file.log, RPAD(' ', 15) || fnd_message.get);
2107: fnd_file.new_line(fnd_file.log, 1);
2108:
2109: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2110: THEN

Line 2164: fnd_message.set_name('IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL');

2160: );
2161:
2162: IF NOT l_ac_hold_result
2163: THEN
2164: fnd_message.set_name('IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL');
2165: p_result := fnd_message.get;
2166: fnd_file.put_line(
2167: fnd_file.log, RPAD(' ', 17) || p_result
2168: );

Line 2165: p_result := fnd_message.get;

2161:
2162: IF NOT l_ac_hold_result
2163: THEN
2164: fnd_message.set_name('IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL');
2165: p_result := fnd_message.get;
2166: fnd_file.put_line(
2167: fnd_file.log, RPAD(' ', 17) || p_result
2168: );
2169: END IF;

Line 2173: fnd_message.set_name('IGF', l_message_name);

2169: END IF;
2170:
2171: IF NOT l_todo_result AND l_message_name IS NOT NULL
2172: THEN
2173: fnd_message.set_name('IGF', l_message_name);
2174: -- 'Disbursement failed Fund To Do check'
2175: p_result := fnd_message.get;
2176: fnd_file.put_line(
2177: fnd_file.log, RPAD(' ', 17) || p_result

Line 2175: p_result := fnd_message.get;

2171: IF NOT l_todo_result AND l_message_name IS NOT NULL
2172: THEN
2173: fnd_message.set_name('IGF', l_message_name);
2174: -- 'Disbursement failed Fund To Do check'
2175: p_result := fnd_message.get;
2176: fnd_file.put_line(
2177: fnd_file.log, RPAD(' ', 17) || p_result
2178: );
2179: END IF;

Line 2183: fnd_message.set_name('IGF', 'IGF_DB_FAIL_PPRG');

2179: END IF;
2180:
2181: IF NOT l_pays_prg
2182: THEN
2183: fnd_message.set_name('IGF', 'IGF_DB_FAIL_PPRG');
2184: -- 'Disbursement failed Fund Pays Only Program check'
2185: p_result := fnd_message.get;
2186: fnd_file.put_line(
2187: fnd_file.log, RPAD(' ', 17) || p_result

Line 2185: p_result := fnd_message.get;

2181: IF NOT l_pays_prg
2182: THEN
2183: fnd_message.set_name('IGF', 'IGF_DB_FAIL_PPRG');
2184: -- 'Disbursement failed Fund Pays Only Program check'
2185: p_result := fnd_message.get;
2186: fnd_file.put_line(
2187: fnd_file.log, RPAD(' ', 17) || p_result
2188: );
2189: END IF;

Line 2193: fnd_message.set_name('IGF', 'IGF_DB_FAIL_PUNT');

2189: END IF;
2190:
2191: IF NOT l_pays_uts
2192: THEN
2193: fnd_message.set_name('IGF', 'IGF_DB_FAIL_PUNT');
2194: -- 'Disbursement failed Fund Pays Only Unit check'
2195: p_result := fnd_message.get;
2196: fnd_file.put_line(
2197: fnd_file.log, RPAD(' ', 17) || p_result

Line 2195: p_result := fnd_message.get;

2191: IF NOT l_pays_uts
2192: THEN
2193: fnd_message.set_name('IGF', 'IGF_DB_FAIL_PUNT');
2194: -- 'Disbursement failed Fund Pays Only Unit check'
2195: p_result := fnd_message.get;
2196: fnd_file.put_line(
2197: fnd_file.log, RPAD(' ', 17) || p_result
2198: );
2199: END IF;

Line 2205: fnd_message.set_name('IGF', 'IGF_GR_PELL_INELIGIBLE');

2201: IF NOT l_elig_result
2202: THEN
2203: IF l_fund_type = 'P'
2204: THEN
2205: fnd_message.set_name('IGF', 'IGF_GR_PELL_INELIGIBLE');
2206: -- 'Disbursement failed Pell Eligiblity check'
2207: END IF;
2208:
2209: IF l_fund_type = 'D'

Line 2211: fnd_message.set_name('IGF', 'IGF_DB_FAIL_FEDL_ELIG');

2207: END IF;
2208:
2209: IF l_fund_type = 'D'
2210: THEN
2211: fnd_message.set_name('IGF', 'IGF_DB_FAIL_FEDL_ELIG');
2212: -- 'Disbursement failed NSLDS Eligiblity check'
2213: END IF;
2214:
2215: p_result := fnd_message.get;

Line 2215: p_result := fnd_message.get;

2211: fnd_message.set_name('IGF', 'IGF_DB_FAIL_FEDL_ELIG');
2212: -- 'Disbursement failed NSLDS Eligiblity check'
2213: END IF;
2214:
2215: p_result := fnd_message.get;
2216: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2217: END IF;
2218:
2219: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level

Line 2296: fnd_message.set_name('IGF', 'IGF_SL_LOAN_ID_NOT_FOUND');

2292: IF cur_get_loans%NOTFOUND
2293: THEN
2294: l_active_result := FALSE;
2295: CLOSE cur_get_loans;
2296: fnd_message.set_name('IGF', 'IGF_SL_LOAN_ID_NOT_FOUND');
2297: p_result := fnd_message.get;
2298: fnd_file.put_line(
2299: fnd_file.log, RPAD(' ', 17) || p_result
2300: );

Line 2297: p_result := fnd_message.get;

2293: THEN
2294: l_active_result := FALSE;
2295: CLOSE cur_get_loans;
2296: fnd_message.set_name('IGF', 'IGF_SL_LOAN_ID_NOT_FOUND');
2297: p_result := fnd_message.get;
2298: fnd_file.put_line(
2299: fnd_file.log, RPAD(' ', 17) || p_result
2300: );
2301:

Line 2318: fnd_message.set_name('IGF', 'IGF_SL_LOAN_INACTIVE_DRI');

2314: CLOSE cur_get_loans;
2315:
2316: IF NVL(get_loans_rec.active, 'N') <> 'Y'
2317: THEN
2318: fnd_message.set_name('IGF', 'IGF_SL_LOAN_INACTIVE_DRI');
2319: fnd_message.set_token(
2320: 'LOAN_NUMBER', get_loans_rec.loan_number
2321: );
2322: p_result := fnd_message.get;

Line 2319: fnd_message.set_token(

2315:
2316: IF NVL(get_loans_rec.active, 'N') <> 'Y'
2317: THEN
2318: fnd_message.set_name('IGF', 'IGF_SL_LOAN_INACTIVE_DRI');
2319: fnd_message.set_token(
2320: 'LOAN_NUMBER', get_loans_rec.loan_number
2321: );
2322: p_result := fnd_message.get;
2323: fnd_file.put_line(

Line 2322: p_result := fnd_message.get;

2318: fnd_message.set_name('IGF', 'IGF_SL_LOAN_INACTIVE_DRI');
2319: fnd_message.set_token(
2320: 'LOAN_NUMBER', get_loans_rec.loan_number
2321: );
2322: p_result := fnd_message.get;
2323: fnd_file.put_line(
2324: fnd_file.log, RPAD(' ', 17) || p_result
2325: );
2326: l_active_result := FALSE;

Line 2343: fnd_message.set_name('IGF', 'IGF_SL_LOAN_SENT_DRI');

2339:
2340: IF get_loans_rec.loan_status = 'S'
2341: OR NVL(get_loans_rec.loan_chg_status, '*') = 'S'
2342: THEN
2343: fnd_message.set_name('IGF', 'IGF_SL_LOAN_SENT_DRI');
2344: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);
2345: p_result := fnd_message.get;
2346: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2347: l_active_result := FALSE;

Line 2344: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);

2340: IF get_loans_rec.loan_status = 'S'
2341: OR NVL(get_loans_rec.loan_chg_status, '*') = 'S'
2342: THEN
2343: fnd_message.set_name('IGF', 'IGF_SL_LOAN_SENT_DRI');
2344: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);
2345: p_result := fnd_message.get;
2346: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2347: l_active_result := FALSE;
2348:

Line 2345: p_result := fnd_message.get;

2341: OR NVL(get_loans_rec.loan_chg_status, '*') = 'S'
2342: THEN
2343: fnd_message.set_name('IGF', 'IGF_SL_LOAN_SENT_DRI');
2344: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);
2345: p_result := fnd_message.get;
2346: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2347: l_active_result := FALSE;
2348:
2349: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level THEN

Line 2359: fnd_message.set_name('IGF', 'IGF_SL_LOAN_REJ_DRI'); -- Rejected Loan

2355:
2356: IF get_loans_rec.loan_status = 'R'
2357: OR NVL(get_loans_rec.loan_chg_status, '*') = 'R'
2358: THEN
2359: fnd_message.set_name('IGF', 'IGF_SL_LOAN_REJ_DRI'); -- Rejected Loan
2360: fnd_message.set_token(
2361: 'LOAN_NUMBER', get_loans_rec.loan_number
2362: );
2363: p_result := fnd_message.get;

Line 2360: fnd_message.set_token(

2356: IF get_loans_rec.loan_status = 'R'
2357: OR NVL(get_loans_rec.loan_chg_status, '*') = 'R'
2358: THEN
2359: fnd_message.set_name('IGF', 'IGF_SL_LOAN_REJ_DRI'); -- Rejected Loan
2360: fnd_message.set_token(
2361: 'LOAN_NUMBER', get_loans_rec.loan_number
2362: );
2363: p_result := fnd_message.get;
2364: fnd_file.put_line(

Line 2363: p_result := fnd_message.get;

2359: fnd_message.set_name('IGF', 'IGF_SL_LOAN_REJ_DRI'); -- Rejected Loan
2360: fnd_message.set_token(
2361: 'LOAN_NUMBER', get_loans_rec.loan_number
2362: );
2363: p_result := fnd_message.get;
2364: fnd_file.put_line(
2365: fnd_file.log, RPAD(' ', 17) || p_result
2366: );
2367: l_active_result := FALSE;

Line 2384: fnd_message.set_name('IGF', 'IGF_SL_LOAN_RELEASE4_DRI'); -- not a release 4 loan

2380:
2381: IF l_fund_type = 'F' THEN
2382: IF get_loans_rec.loan_status = 'A'THEN
2383: IF igf_sl_award.get_loan_cl_version(awd_disb_rec.award_id) <> 'RELEASE-4' THEN
2384: fnd_message.set_name('IGF', 'IGF_SL_LOAN_RELEASE4_DRI'); -- not a release 4 loan
2385: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);
2386: p_result := fnd_message.get;
2387: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2388: l_active_result := FALSE;

Line 2385: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);

2381: IF l_fund_type = 'F' THEN
2382: IF get_loans_rec.loan_status = 'A'THEN
2383: IF igf_sl_award.get_loan_cl_version(awd_disb_rec.award_id) <> 'RELEASE-4' THEN
2384: fnd_message.set_name('IGF', 'IGF_SL_LOAN_RELEASE4_DRI'); -- not a release 4 loan
2385: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);
2386: p_result := fnd_message.get;
2387: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2388: l_active_result := FALSE;
2389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 2386: p_result := fnd_message.get;

2382: IF get_loans_rec.loan_status = 'A'THEN
2383: IF igf_sl_award.get_loan_cl_version(awd_disb_rec.award_id) <> 'RELEASE-4' THEN
2384: fnd_message.set_name('IGF', 'IGF_SL_LOAN_RELEASE4_DRI'); -- not a release 4 loan
2385: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);
2386: p_result := fnd_message.get;
2387: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2388: l_active_result := FALSE;
2389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2390: THEN fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2430: fnd_message.set_name(

2426: );
2427:
2428: IF NOT l_crdt_st_check_plus
2429: THEN
2430: fnd_message.set_name(
2431: 'IGF', 'IGF_SL_DLP_CRDT_STATUS_FAIL'
2432: );
2433: p_result := fnd_message.get;
2434: fnd_file.put_line(

Line 2433: p_result := fnd_message.get;

2429: THEN
2430: fnd_message.set_name(
2431: 'IGF', 'IGF_SL_DLP_CRDT_STATUS_FAIL'
2432: );
2433: p_result := fnd_message.get;
2434: fnd_file.put_line(
2435: fnd_file.log, RPAD(' ', 17) || p_result
2436: );
2437:

Line 2468: fnd_message.set_name('IGF', 'IGF_SL_PELL_SENT_DRI');

2464: CLOSE cur_get_pell;
2465:
2466: IF NVL(get_pell_rec.orig_action_code, '*') = 'S'
2467: THEN
2468: fnd_message.set_name('IGF', 'IGF_SL_PELL_SENT_DRI');
2469: fnd_message.set_token(
2470: 'ORIGINATION_ID', get_pell_rec.origination_id
2471: );
2472: p_result := fnd_message.get;

Line 2469: fnd_message.set_token(

2465:
2466: IF NVL(get_pell_rec.orig_action_code, '*') = 'S'
2467: THEN
2468: fnd_message.set_name('IGF', 'IGF_SL_PELL_SENT_DRI');
2469: fnd_message.set_token(
2470: 'ORIGINATION_ID', get_pell_rec.origination_id
2471: );
2472: p_result := fnd_message.get;
2473: fnd_file.put_line(

Line 2472: p_result := fnd_message.get;

2468: fnd_message.set_name('IGF', 'IGF_SL_PELL_SENT_DRI');
2469: fnd_message.set_token(
2470: 'ORIGINATION_ID', get_pell_rec.origination_id
2471: );
2472: p_result := fnd_message.get;
2473: fnd_file.put_line(
2474: fnd_file.log, RPAD(' ', 17) || p_result
2475: );
2476: l_active_result := FALSE;

Line 2492: fnd_message.set_name('IGF', 'IGF_SL_PELL_REJ_DRI');

2488: END IF;
2489:
2490: IF NVL(get_pell_rec.orig_action_code, '*') = 'E'
2491: THEN -- Rejected Pell
2492: fnd_message.set_name('IGF', 'IGF_SL_PELL_REJ_DRI');
2493: fnd_message.set_token(
2494: 'ORIGINATION_ID', get_pell_rec.origination_id
2495: );
2496: p_result := fnd_message.get;

Line 2493: fnd_message.set_token(

2489:
2490: IF NVL(get_pell_rec.orig_action_code, '*') = 'E'
2491: THEN -- Rejected Pell
2492: fnd_message.set_name('IGF', 'IGF_SL_PELL_REJ_DRI');
2493: fnd_message.set_token(
2494: 'ORIGINATION_ID', get_pell_rec.origination_id
2495: );
2496: p_result := fnd_message.get;
2497: fnd_file.put_line(

Line 2496: p_result := fnd_message.get;

2492: fnd_message.set_name('IGF', 'IGF_SL_PELL_REJ_DRI');
2493: fnd_message.set_token(
2494: 'ORIGINATION_ID', get_pell_rec.origination_id
2495: );
2496: p_result := fnd_message.get;
2497: fnd_file.put_line(
2498: fnd_file.log, RPAD(' ', 17) || p_result
2499: );
2500: l_active_result := FALSE;

Line 2585: fnd_message.set_name('IGF', 'IGF_DB_FAIL_FCLS');

2581: END IF;
2582:
2583: IF NOT l_fclass_result
2584: THEN
2585: fnd_message.set_name('IGF', 'IGF_DB_FAIL_FCLS');
2586: --Disbursement failed Pays Only Fee Class Check
2587: p_result := fnd_message.get;
2588: fnd_file.put_line(
2589: fnd_file.log, RPAD(' ', 17) || p_result

Line 2587: p_result := fnd_message.get;

2583: IF NOT l_fclass_result
2584: THEN
2585: fnd_message.set_name('IGF', 'IGF_DB_FAIL_FCLS');
2586: --Disbursement failed Pays Only Fee Class Check
2587: p_result := fnd_message.get;
2588: fnd_file.put_line(
2589: fnd_file.log, RPAD(' ', 17) || p_result
2590: );
2591: END IF;

Line 2595: fnd_message.set_name('IGF', 'IGF_SL_SYS_HOLD_FAIL');

2591: END IF;
2592:
2593: IF NOT l_sys_hold_result
2594: THEN
2595: fnd_message.set_name('IGF', 'IGF_SL_SYS_HOLD_FAIL');
2596: --System hold exsist on the disbursment
2597: p_result := fnd_message.get;
2598: fnd_file.put_line(
2599: fnd_file.log, RPAD(' ', 17) || p_result

Line 2597: p_result := fnd_message.get;

2593: IF NOT l_sys_hold_result
2594: THEN
2595: fnd_message.set_name('IGF', 'IGF_SL_SYS_HOLD_FAIL');
2596: --System hold exsist on the disbursment
2597: p_result := fnd_message.get;
2598: fnd_file.put_line(
2599: fnd_file.log, RPAD(' ', 17) || p_result
2600: );
2601: END IF;

Line 2685: fnd_message.set_name('IGF', 'IGF_DB_FAIL_CRP');

2681: IF NVL(l_credit_pts, 0) <
2682: NVL(awd_disb_rec.min_credit_pts, 0)
2683: THEN
2684: l_crdt_pt_result := FALSE;
2685: fnd_message.set_name('IGF', 'IGF_DB_FAIL_CRP');
2686: p_result := fnd_message.get;
2687: fnd_file.put_line(
2688: fnd_file.log, RPAD(' ', 17) || p_result
2689: );

Line 2686: p_result := fnd_message.get;

2682: NVL(awd_disb_rec.min_credit_pts, 0)
2683: THEN
2684: l_crdt_pt_result := FALSE;
2685: fnd_message.set_name('IGF', 'IGF_DB_FAIL_CRP');
2686: p_result := fnd_message.get;
2687: fnd_file.put_line(
2688: fnd_file.log, RPAD(' ', 17) || p_result
2689: );
2690:

Line 2751: fnd_message.set_name('IGF', 'IGF_DB_FAIL_ATT');

2747: END IF;
2748:
2749: IF NOT l_att_result
2750: THEN
2751: fnd_message.set_name('IGF', 'IGF_DB_FAIL_ATT');
2752: --Disbursement failed Attendance Type Check
2753: p_result := fnd_message.get;
2754:
2755: IF p_message IS NOT NULL

Line 2753: p_result := fnd_message.get;

2749: IF NOT l_att_result
2750: THEN
2751: fnd_message.set_name('IGF', 'IGF_DB_FAIL_ATT');
2752: --Disbursement failed Attendance Type Check
2753: p_result := fnd_message.get;
2754:
2755: IF p_message IS NOT NULL
2756: THEN
2757: IF fnd_log.level_statement >=

Line 2818: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_NOT_CORR');

2814: 'result of funding method check is NULL'
2815: );
2816: END IF;
2817:
2818: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_NOT_CORR');
2819: p_result := fnd_message.get;
2820: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2821: RAISE skip_record;
2822:

Line 2819: p_result := fnd_message.get;

2815: );
2816: END IF;
2817:
2818: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_NOT_CORR');
2819: p_result := fnd_message.get;
2820: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2821: RAISE skip_record;
2822:
2823: IF fnd_log.level_statement >=

Line 2836: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_CHK_FAIL');

2832: ELSIF NOT l_fund_meth_result
2833: THEN
2834: -- funding method check failed so DRI can't be set to true
2835:
2836: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_CHK_FAIL');
2837: p_result := fnd_message.get;
2838: fnd_file.put_line(
2839: fnd_file.log, RPAD(' ', 17) || p_result
2840: );

Line 2837: p_result := fnd_message.get;

2833: THEN
2834: -- funding method check failed so DRI can't be set to true
2835:
2836: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_CHK_FAIL');
2837: p_result := fnd_message.get;
2838: fnd_file.put_line(
2839: fnd_file.log, RPAD(' ', 17) || p_result
2840: );
2841:

Line 2895: fnd_message.set_name(

2891: );
2892: END IF;
2893: ELSE
2894: -- null is returned if the funding type is incorrect
2895: fnd_message.set_name(
2896: 'IGF', 'IGF_SL_FUND_METH_NOT_CORR'
2897: );
2898: p_result := fnd_message.get;
2899: fnd_file.put_line(

Line 2898: p_result := fnd_message.get;

2894: -- null is returned if the funding type is incorrect
2895: fnd_message.set_name(
2896: 'IGF', 'IGF_SL_FUND_METH_NOT_CORR'
2897: );
2898: p_result := fnd_message.get;
2899: fnd_file.put_line(
2900: fnd_file.log, RPAD(' ', 17) || p_result
2901: );
2902: RAISE skip_record;

Line 2918: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_CHK_FAIL');

2914: ELSIF NOT l_fund_meth_result
2915: THEN
2916: -- funding method check failed so DRI can't be set to true
2917:
2918: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_CHK_FAIL');
2919: p_result := fnd_message.get;
2920: fnd_file.put_line(
2921: fnd_file.log, RPAD(' ', 17) || p_result
2922: );

Line 2919: p_result := fnd_message.get;

2915: THEN
2916: -- funding method check failed so DRI can't be set to true
2917:
2918: fnd_message.set_name('IGF', 'IGF_SL_FUND_METH_CHK_FAIL');
2919: p_result := fnd_message.get;
2920: fnd_file.put_line(
2921: fnd_file.log, RPAD(' ', 17) || p_result
2922: );
2923:

Line 3189: fnd_message.CLEAR;

3185: RAISE;
3186: WHEN skip_record
3187: THEN
3188: -- clear message stack
3189: fnd_message.CLEAR;
3190:
3191: IF l_fund_type IN ('D', 'P')
3192: THEN
3193: FETCH cur_awd_disb_dl INTO awd_disb_rec;

Line 3231: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');

3227: THEN
3228: RAISE;
3229: WHEN OTHERS
3230: THEN
3231: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
3232: fnd_message.set_token(
3233: 'NAME', 'IGF_DB_DISB.PROCESS_STUDENT' || SQLERRM
3234: );
3235: fnd_file.put_line(fnd_file.log, SQLERRM);

Line 3232: fnd_message.set_token(

3228: RAISE;
3229: WHEN OTHERS
3230: THEN
3231: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
3232: fnd_message.set_token(
3233: 'NAME', 'IGF_DB_DISB.PROCESS_STUDENT' || SQLERRM
3234: );
3235: fnd_file.put_line(fnd_file.log, SQLERRM);
3236: igs_ge_msg_stack.ADD;

Line 3448: fnd_message.set_name('IGF', 'IGF_SL_AWD_YR_NOT_FOUND');

3444: FETCH cur_awdyear INTO awdyear_rec;
3445:
3446: IF cur_awdyear%NOTFOUND
3447: THEN
3448: fnd_message.set_name('IGF', 'IGF_SL_AWD_YR_NOT_FOUND');
3449: fnd_file.put_line(fnd_file.log, fnd_message.get);
3450: fnd_file.new_line(fnd_file.log, 1);
3451: CLOSE cur_awdyear;
3452: RETURN;

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

3445:
3446: IF cur_awdyear%NOTFOUND
3447: THEN
3448: fnd_message.set_name('IGF', 'IGF_SL_AWD_YR_NOT_FOUND');
3449: fnd_file.put_line(fnd_file.log, fnd_message.get);
3450: fnd_file.new_line(fnd_file.log, 1);
3451: CLOSE cur_awdyear;
3452: RETURN;
3453: ELSE

Line 3462: fnd_message.set_name('IGF', 'IGF_AW_NO_SUCH_FUND');

3458: FETCH cur_get_fund_type INTO get_fund_type_rec;
3459:
3460: IF cur_get_fund_type%NOTFOUND
3461: THEN
3462: fnd_message.set_name('IGF', 'IGF_AW_NO_SUCH_FUND');
3463: fnd_message.set_token('FUND_ID', p_fund_id);
3464: fnd_file.put_line(fnd_file.log, fnd_message.get);
3465: fnd_file.new_line(fnd_file.log, 1);
3466: CLOSE cur_get_fund_type;

Line 3463: fnd_message.set_token('FUND_ID', p_fund_id);

3459:
3460: IF cur_get_fund_type%NOTFOUND
3461: THEN
3462: fnd_message.set_name('IGF', 'IGF_AW_NO_SUCH_FUND');
3463: fnd_message.set_token('FUND_ID', p_fund_id);
3464: fnd_file.put_line(fnd_file.log, fnd_message.get);
3465: fnd_file.new_line(fnd_file.log, 1);
3466: CLOSE cur_get_fund_type;
3467: RETURN;

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

3460: IF cur_get_fund_type%NOTFOUND
3461: THEN
3462: fnd_message.set_name('IGF', 'IGF_AW_NO_SUCH_FUND');
3463: fnd_message.set_token('FUND_ID', p_fund_id);
3464: fnd_file.put_line(fnd_file.log, fnd_message.get);
3465: fnd_file.new_line(fnd_file.log, 1);
3466: CLOSE cur_get_fund_type;
3467: RETURN;
3468: ELSE

Line 3484: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');

3480:
3481: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL
3482: OR p_fund_id IS NULL
3483: THEN
3484: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3485: fnd_file.new_line(fnd_file.log, 2);
3486: fnd_file.put_line(fnd_file.log, fnd_message.get);
3487: fnd_file.new_line(fnd_file.log, 2);
3488: RAISE param_exception;

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

3482: OR p_fund_id IS NULL
3483: THEN
3484: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3485: fnd_file.new_line(fnd_file.log, 2);
3486: fnd_file.put_line(fnd_file.log, fnd_message.get);
3487: fnd_file.new_line(fnd_file.log, 2);
3488: RAISE param_exception;
3489: END IF;
3490:

Line 3498: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');

3494: THEN
3495: -- If Person ID Group is specified then cannot specify values for Person Number or Loan number
3496: IF p_base_id IS NOT NULL OR p_loan_id IS NOT NULL
3497: THEN
3498: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3499: fnd_file.new_line(fnd_file.log, 2);
3500: fnd_file.put_line(fnd_file.log, fnd_message.get);
3501: fnd_file.new_line(fnd_file.log, 2);
3502: RAISE param_exception;

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

3496: IF p_base_id IS NOT NULL OR p_loan_id IS NOT NULL
3497: THEN
3498: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3499: fnd_file.new_line(fnd_file.log, 2);
3500: fnd_file.put_line(fnd_file.log, fnd_message.get);
3501: fnd_file.new_line(fnd_file.log, 2);
3502: RAISE param_exception;
3503: END IF;
3504: END IF;

Line 3536: fnd_message.set_name('IGF', 'IGF_DB_NO_PER_GRP');

3532: -- If no student found in Person Group
3533: IF cur_per_grp%NOTFOUND
3534: THEN
3535: CLOSE cur_per_grp;
3536: fnd_message.set_name('IGF', 'IGF_DB_NO_PER_GRP');
3537: fnd_file.put_line(fnd_file.log, RPAD(' ', 5) || fnd_message.get);
3538:
3539: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3540: THEN

Line 3537: fnd_file.put_line(fnd_file.log, RPAD(' ', 5) || fnd_message.get);

3533: IF cur_per_grp%NOTFOUND
3534: THEN
3535: CLOSE cur_per_grp;
3536: fnd_message.set_name('IGF', 'IGF_DB_NO_PER_GRP');
3537: fnd_file.put_line(fnd_file.log, RPAD(' ', 5) || fnd_message.get);
3538:
3539: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3540: THEN
3541: fnd_log.string(

Line 3549: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_PER_GRP');

3545: );
3546: END IF;
3547: ELSE
3548: -- IF cur_per_grp%FOUND THEN
3549: fnd_message.set_name('IGF', 'IGF_DB_PROCESS_PER_GRP');
3550: -- Processing Disbursements for Person Group
3551: OPEN cur_per_grp_name(p_per_grp_id);
3552: FETCH cur_per_grp_name INTO per_grp_rec;
3553: CLOSE cur_per_grp_name;

Line 3555: fnd_file.log, RPAD(' ', 5) || fnd_message.get || ' '

3551: OPEN cur_per_grp_name(p_per_grp_id);
3552: FETCH cur_per_grp_name INTO per_grp_rec;
3553: CLOSE cur_per_grp_name;
3554: fnd_file.put_line(
3555: fnd_file.log, RPAD(' ', 5) || fnd_message.get || ' '
3556: || per_grp_rec.group_cd
3557: );
3558:
3559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 3582: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');

3578: IF l_person_number IS NOT NULL
3579: THEN
3580: IF l_base_id IS NOT NULL
3581: THEN
3582: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3583: fnd_message.set_token('STDNT', l_person_number);
3584: fnd_file.put_line(
3585: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3586: );

Line 3583: fnd_message.set_token('STDNT', l_person_number);

3579: THEN
3580: IF l_base_id IS NOT NULL
3581: THEN
3582: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3583: fnd_message.set_token('STDNT', l_person_number);
3584: fnd_file.put_line(
3585: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3586: );
3587:

Line 3585: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3581: THEN
3582: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3583: fnd_message.set_token('STDNT', l_person_number);
3584: fnd_file.put_line(
3585: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3586: );
3587:
3588: IF fnd_log.level_statement >=
3589: fnd_log.g_current_runtime_level

Line 3605: fnd_message.set_name(

3601: IF igf_aw_gen_005.get_stud_hold_effect(
3602: 'D', igf_gr_gen.get_person_id(l_base_id)
3603: ) = 'F'
3604: THEN
3605: fnd_message.set_name(
3606: 'IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL'
3607: );
3608: fnd_file.put_line(
3609: fnd_file.log, RPAD(' ', 10) || fnd_message.get

Line 3609: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3605: fnd_message.set_name(
3606: 'IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL'
3607: );
3608: fnd_file.put_line(
3609: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3610: );
3611:
3612: IF fnd_log.level_statement >=
3613: fnd_log.g_current_runtime_level

Line 3641: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER'); -- if hold exsist

3637: p_trans_type => p_trans_type
3638: );
3639: END IF;
3640:
3641: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER'); -- if hold exsist
3642: -- End of processing for person number
3643: fnd_message.set_token('PER_NUM', l_person_number);
3644: fnd_file.put_line(
3645: fnd_file.log, RPAD(' ', 10) || fnd_message.get

Line 3643: fnd_message.set_token('PER_NUM', l_person_number);

3639: END IF;
3640:
3641: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER'); -- if hold exsist
3642: -- End of processing for person number
3643: fnd_message.set_token('PER_NUM', l_person_number);
3644: fnd_file.put_line(
3645: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3646: );
3647: fnd_file.new_line(fnd_file.log, 1);

Line 3645: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3641: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER'); -- if hold exsist
3642: -- End of processing for person number
3643: fnd_message.set_token('PER_NUM', l_person_number);
3644: fnd_file.put_line(
3645: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3646: );
3647: fnd_file.new_line(fnd_file.log, 1);
3648:
3649: IF fnd_log.level_statement >=

Line 3660: fnd_message.set_name('IGF', 'IGF_GR_LI_PER_INVALID');

3656: );
3657: END IF;
3658: ELSE -- l_base_id IS NULL THEN
3659: -- log a message and skip this person since the person doesnt exsist in FA
3660: fnd_message.set_name('IGF', 'IGF_GR_LI_PER_INVALID');
3661: fnd_message.set_token('PERSON_NUMBER', l_person_number);
3662: fnd_message.set_token(
3663: 'AWD_YR', awdyear_rec.alternate_code
3664: );

Line 3661: fnd_message.set_token('PERSON_NUMBER', l_person_number);

3657: END IF;
3658: ELSE -- l_base_id IS NULL THEN
3659: -- log a message and skip this person since the person doesnt exsist in FA
3660: fnd_message.set_name('IGF', 'IGF_GR_LI_PER_INVALID');
3661: fnd_message.set_token('PERSON_NUMBER', l_person_number);
3662: fnd_message.set_token(
3663: 'AWD_YR', awdyear_rec.alternate_code
3664: );
3665: -- Person PER_NUM does not exist in FA

Line 3662: fnd_message.set_token(

3658: ELSE -- l_base_id IS NULL THEN
3659: -- log a message and skip this person since the person doesnt exsist in FA
3660: fnd_message.set_name('IGF', 'IGF_GR_LI_PER_INVALID');
3661: fnd_message.set_token('PERSON_NUMBER', l_person_number);
3662: fnd_message.set_token(
3663: 'AWD_YR', awdyear_rec.alternate_code
3664: );
3665: -- Person PER_NUM does not exist in FA
3666: fnd_file.put_line(

Line 3667: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3663: 'AWD_YR', awdyear_rec.alternate_code
3664: );
3665: -- Person PER_NUM does not exist in FA
3666: fnd_file.put_line(
3667: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3668: );
3669:
3670: IF fnd_log.level_statement >=
3671: fnd_log.g_current_runtime_level

Line 3682: fnd_message.set_name('IGF', 'IGF_AP_PE_NOT_EXIST');

3678: );
3679: END IF;
3680: END IF; -- (IF l_base_id IS NOT NULL)
3681: ELSE -- IF l_person_number IS NULL THEN
3682: fnd_message.set_name('IGF', 'IGF_AP_PE_NOT_EXIST');
3683: fnd_file.put_line(
3684: fnd_file.log, RPAD(' ', 5) || fnd_message.get
3685: );
3686: END IF; ---- (IF l_person_number IS NOT NULL)

Line 3684: fnd_file.log, RPAD(' ', 5) || fnd_message.get

3680: END IF; -- (IF l_base_id IS NOT NULL)
3681: ELSE -- IF l_person_number IS NULL THEN
3682: fnd_message.set_name('IGF', 'IGF_AP_PE_NOT_EXIST');
3683: fnd_file.put_line(
3684: fnd_file.log, RPAD(' ', 5) || fnd_message.get
3685: );
3686: END IF; ---- (IF l_person_number IS NOT NULL)
3687:
3688: FETCH cur_per_grp INTO l_person_id;

Line 3719: fnd_message.set_name('IGF', 'IGF_DB_NO_AWARDS');

3715:
3716: IF cur_award_std%NOTFOUND
3717: THEN
3718: CLOSE cur_award_std;
3719: fnd_message.set_name('IGF', 'IGF_DB_NO_AWARDS');
3720: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
3721: -- No Awards found for this Fund : < fund desc >
3722: fnd_file.put_line(
3723: fnd_file.log, RPAD(' ', 5) || fnd_message.get

Line 3720: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));

3716: IF cur_award_std%NOTFOUND
3717: THEN
3718: CLOSE cur_award_std;
3719: fnd_message.set_name('IGF', 'IGF_DB_NO_AWARDS');
3720: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
3721: -- No Awards found for this Fund : < fund desc >
3722: fnd_file.put_line(
3723: fnd_file.log, RPAD(' ', 5) || fnd_message.get
3724: );

Line 3723: fnd_file.log, RPAD(' ', 5) || fnd_message.get

3719: fnd_message.set_name('IGF', 'IGF_DB_NO_AWARDS');
3720: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
3721: -- No Awards found for this Fund : < fund desc >
3722: fnd_file.put_line(
3723: fnd_file.log, RPAD(' ', 5) || fnd_message.get
3724: );
3725:
3726: IF fnd_log.level_statement >=
3727: fnd_log.g_current_runtime_level

Line 3777: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');

3773: 'l_person_number:' || l_person_number
3774: );
3775: END IF;
3776:
3777: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3778: fnd_message.set_token('STDNT', l_person_number);
3779: fnd_file.put_line(
3780: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3781: );

Line 3778: fnd_message.set_token('STDNT', l_person_number);

3774: );
3775: END IF;
3776:
3777: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3778: fnd_message.set_token('STDNT', l_person_number);
3779: fnd_file.put_line(
3780: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3781: );
3782:

Line 3780: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3776:
3777: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3778: fnd_message.set_token('STDNT', l_person_number);
3779: fnd_file.put_line(
3780: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3781: );
3782:
3783: IF fnd_log.level_statement >=
3784: fnd_log.g_current_runtime_level

Line 3801: fnd_message.set_name(

3797: 'D',
3798: igf_gr_gen.get_person_id(award_std_rec.base_id)
3799: ) = 'F'
3800: THEN
3801: fnd_message.set_name(
3802: 'IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL'
3803: );
3804: fnd_file.put_line(
3805: fnd_file.log, RPAD(' ', 10) || fnd_message.get

Line 3805: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3801: fnd_message.set_name(
3802: 'IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL'
3803: );
3804: fnd_file.put_line(
3805: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3806: );
3807:
3808: IF fnd_log.level_statement >=
3809: fnd_log.g_current_runtime_level

Line 3867: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER');

3863: );
3864: END IF;
3865: END IF;
3866:
3867: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER');
3868: -- End of processing for person number
3869: fnd_message.set_token('PER_NUM', l_person_number);
3870: fnd_file.put_line(
3871: fnd_file.log, RPAD(' ', 10) || fnd_message.get

Line 3869: fnd_message.set_token('PER_NUM', l_person_number);

3865: END IF;
3866:
3867: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER');
3868: -- End of processing for person number
3869: fnd_message.set_token('PER_NUM', l_person_number);
3870: fnd_file.put_line(
3871: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3872: );
3873: fnd_file.new_line(fnd_file.log, 1);

Line 3871: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3867: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER');
3868: -- End of processing for person number
3869: fnd_message.set_token('PER_NUM', l_person_number);
3870: fnd_file.put_line(
3871: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3872: );
3873: fnd_file.new_line(fnd_file.log, 1);
3874:
3875: IF fnd_log.level_statement >=

Line 3891: fnd_message.set_name('IGF', 'IGF_SL_ONLY_PELL_LOANS');

3887: END LOOP;
3888:
3889: CLOSE cur_award_std;
3890: ELSE -- Fund code is not PELL or Direct Loan so raise an error
3891: fnd_message.set_name('IGF', 'IGF_SL_ONLY_PELL_LOANS');
3892: fnd_file.put_line(
3893: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3894: );
3895:

Line 3893: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3889: CLOSE cur_award_std;
3890: ELSE -- Fund code is not PELL or Direct Loan so raise an error
3891: fnd_message.set_name('IGF', 'IGF_SL_ONLY_PELL_LOANS');
3892: fnd_file.put_line(
3893: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3894: );
3895:
3896: IF fnd_log.level_statement >=
3897: fnd_log.g_current_runtime_level

Line 3910: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');

3906: END IF; -- (IF award_std_rec.fed_fund_code NOT IN ('FWS','SPNSR','PRK'))
3907: END IF; -- (IF cur_award_std%NOTFOUND)
3908: ELSE
3909: -- Fund Id is NULL so raise error
3910: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3911: fnd_file.new_line(fnd_file.log, 2);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.new_line(fnd_file.log, 2);
3914: RAISE param_exception;

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

3908: ELSE
3909: -- Fund Id is NULL so raise error
3910: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3911: fnd_file.new_line(fnd_file.log, 2);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.new_line(fnd_file.log, 2);
3914: RAISE param_exception;
3915: END IF; -- (IF p_fund_id IS NOT NULL)
3916: ELSE

Line 3920: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');

3916: ELSE
3917: -- i.e, base_id is specified therefore process for the particular student only
3918:
3919: l_person_number := igf_gr_gen.get_per_num(p_base_id);
3920: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3921: fnd_message.set_token('STDNT', l_person_number);
3922: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
3923:
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 3921: fnd_message.set_token('STDNT', l_person_number);

3917: -- i.e, base_id is specified therefore process for the particular student only
3918:
3919: l_person_number := igf_gr_gen.get_per_num(p_base_id);
3920: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3921: fnd_message.set_token('STDNT', l_person_number);
3922: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
3923:
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3925: THEN

Line 3922: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);

3918:
3919: l_person_number := igf_gr_gen.get_per_num(p_base_id);
3920: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3921: fnd_message.set_token('STDNT', l_person_number);
3922: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
3923:
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3925: THEN
3926: fnd_log.string(

Line 3941: fnd_message.set_name('IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL');

3937: IF igf_aw_gen_005.get_stud_hold_effect(
3938: 'D', igf_gr_gen.get_person_id(p_base_id)
3939: ) = 'F'
3940: THEN
3941: fnd_message.set_name('IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL');
3942: fnd_file.put_line(
3943: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3944: );
3945:

Line 3943: fnd_file.log, RPAD(' ', 10) || fnd_message.get

3939: ) = 'F'
3940: THEN
3941: fnd_message.set_name('IGF', 'IGF_SL_DISB_FUND_HOLD_FAIL');
3942: fnd_file.put_line(
3943: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3944: );
3945:
3946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3947: THEN

Line 4001: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER');

3997: );
3998: END IF;
3999: END IF;
4000:
4001: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER');
4002: -- End of processing for person number
4003: fnd_message.set_token('PER_NUM', l_person_number);
4004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
4005: fnd_file.new_line(fnd_file.log, 1);

Line 4003: fnd_message.set_token('PER_NUM', l_person_number);

3999: END IF;
4000:
4001: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER');
4002: -- End of processing for person number
4003: fnd_message.set_token('PER_NUM', l_person_number);
4004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
4005: fnd_file.new_line(fnd_file.log, 1);
4006:
4007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 4004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);

4000:
4001: fnd_message.set_name('IGF', 'IGF_DB_END_PROC_PER');
4002: -- End of processing for person number
4003: fnd_message.set_token('PER_NUM', l_person_number);
4004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
4005: fnd_file.new_line(fnd_file.log, 1);
4006:
4007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
4008: THEN

Line 4027: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');

4023: WHEN param_exception
4024: THEN
4025: ROLLBACK;
4026: p_retcode := 2;
4027: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
4028: igs_ge_msg_stack.ADD;
4029: igs_ge_msg_stack.conc_exception_hndl;
4030: WHEN app_exception.record_lock_exception
4031: THEN

Line 4034: fnd_message.set_name('IGF', 'IGF_GE_LOCK_ERROR');

4030: WHEN app_exception.record_lock_exception
4031: THEN
4032: ROLLBACK;
4033: p_retcode := 2;
4034: fnd_message.set_name('IGF', 'IGF_GE_LOCK_ERROR');
4035: igs_ge_msg_stack.ADD;
4036: p_errbuf := fnd_message.get;
4037: WHEN OTHERS
4038: THEN

Line 4036: p_errbuf := fnd_message.get;

4032: ROLLBACK;
4033: p_retcode := 2;
4034: fnd_message.set_name('IGF', 'IGF_GE_LOCK_ERROR');
4035: igs_ge_msg_stack.ADD;
4036: p_errbuf := fnd_message.get;
4037: WHEN OTHERS
4038: THEN
4039: ROLLBACK;
4040: p_retcode := 2;

Line 4041: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

4037: WHEN OTHERS
4038: THEN
4039: ROLLBACK;
4040: p_retcode := 2;
4041: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
4042: fnd_file.put_line(fnd_file.log, SQLERRM);
4043: igs_ge_msg_stack.ADD;
4044: p_errbuf := fnd_message.get;
4045: END rel_disb_process;

Line 4044: p_errbuf := fnd_message.get;

4040: p_retcode := 2;
4041: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
4042: fnd_file.put_line(fnd_file.log, SQLERRM);
4043: igs_ge_msg_stack.ADD;
4044: p_errbuf := fnd_message.get;
4045: END rel_disb_process;
4046: END igf_sl_rel_disb;