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_FILE

Line 68: fnd_file.put_line(fnd_file.log, SQLERRM);

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

Line 165: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
167: app_exception.raise_exception;
168: END chk_attendance;
169:

Line 231: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
233: app_exception.raise_exception;
234: END chk_fed_elig;
235:

Line 273: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
275: app_exception.raise_exception;
276: END chk_loan_active;
277:

Line 331: fnd_file.put_line(fnd_file.log, SQLERRM);

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

Line 468: fnd_file.new_line(fnd_file.log, 1);

464: CLOSE cur_get_trans_type;
465: END IF;
466: END IF;
467:
468: fnd_file.new_line(fnd_file.log, 1);
469: fnd_file.put_line(
470: fnd_file.log, igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS')
471: );
472: fnd_file.new_line(fnd_file.log, 1);

Line 469: fnd_file.put_line(

465: END IF;
466: END IF;
467:
468: fnd_file.new_line(fnd_file.log, 1);
469: fnd_file.put_line(
470: fnd_file.log, igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS')
471: );
472: fnd_file.new_line(fnd_file.log, 1);
473: fnd_file.put_line(

Line 470: fnd_file.log, igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS')

466: END IF;
467:
468: fnd_file.new_line(fnd_file.log, 1);
469: fnd_file.put_line(
470: fnd_file.log, igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS')
471: );
472: fnd_file.new_line(fnd_file.log, 1);
473: fnd_file.put_line(
474: fnd_file.log, RPAD(l_award_year, 40) || ' : ' || p_alt_code

Line 472: fnd_file.new_line(fnd_file.log, 1);

468: fnd_file.new_line(fnd_file.log, 1);
469: fnd_file.put_line(
470: fnd_file.log, igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS')
471: );
472: fnd_file.new_line(fnd_file.log, 1);
473: fnd_file.put_line(
474: fnd_file.log, RPAD(l_award_year, 40) || ' : ' || p_alt_code
475: );
476: fnd_file.put_line(

Line 473: fnd_file.put_line(

469: fnd_file.put_line(
470: fnd_file.log, igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS')
471: );
472: fnd_file.new_line(fnd_file.log, 1);
473: fnd_file.put_line(
474: fnd_file.log, RPAD(l_award_year, 40) || ' : ' || p_alt_code
475: );
476: fnd_file.put_line(
477: fnd_file.log, RPAD(l_fund_code, 40) || ' : '

Line 474: fnd_file.log, RPAD(l_award_year, 40) || ' : ' || p_alt_code

470: fnd_file.log, igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS')
471: );
472: fnd_file.new_line(fnd_file.log, 1);
473: fnd_file.put_line(
474: fnd_file.log, RPAD(l_award_year, 40) || ' : ' || p_alt_code
475: );
476: fnd_file.put_line(
477: fnd_file.log, RPAD(l_fund_code, 40) || ' : '
478: || get_fund_code_rec.fund_code

Line 476: fnd_file.put_line(

472: fnd_file.new_line(fnd_file.log, 1);
473: fnd_file.put_line(
474: fnd_file.log, RPAD(l_award_year, 40) || ' : ' || p_alt_code
475: );
476: fnd_file.put_line(
477: fnd_file.log, RPAD(l_fund_code, 40) || ' : '
478: || get_fund_code_rec.fund_code
479: );
480: fnd_file.put_line(

Line 477: fnd_file.log, RPAD(l_fund_code, 40) || ' : '

473: fnd_file.put_line(
474: fnd_file.log, RPAD(l_award_year, 40) || ' : ' || p_alt_code
475: );
476: fnd_file.put_line(
477: fnd_file.log, RPAD(l_fund_code, 40) || ' : '
478: || get_fund_code_rec.fund_code
479: );
480: fnd_file.put_line(
481: fnd_file.log, RPAD(l_person_number, 40) || ' : '

Line 480: fnd_file.put_line(

476: fnd_file.put_line(
477: fnd_file.log, RPAD(l_fund_code, 40) || ' : '
478: || get_fund_code_rec.fund_code
479: );
480: fnd_file.put_line(
481: fnd_file.log, RPAD(l_person_number, 40) || ' : '
482: || igf_gr_gen.get_per_num(p_base_id)
483: );
484: fnd_file.put_line(fnd_file.log, RPAD(l_loan_id, 40) || ' : ' || p_loan_id);

Line 481: fnd_file.log, RPAD(l_person_number, 40) || ' : '

477: fnd_file.log, RPAD(l_fund_code, 40) || ' : '
478: || get_fund_code_rec.fund_code
479: );
480: fnd_file.put_line(
481: fnd_file.log, RPAD(l_person_number, 40) || ' : '
482: || igf_gr_gen.get_per_num(p_base_id)
483: );
484: fnd_file.put_line(fnd_file.log, RPAD(l_loan_id, 40) || ' : ' || p_loan_id);
485:

Line 484: fnd_file.put_line(fnd_file.log, RPAD(l_loan_id, 40) || ' : ' || p_loan_id);

480: fnd_file.put_line(
481: fnd_file.log, RPAD(l_person_number, 40) || ' : '
482: || igf_gr_gen.get_per_num(p_base_id)
483: );
484: fnd_file.put_line(fnd_file.log, RPAD(l_loan_id, 40) || ' : ' || p_loan_id);
485:
486: fnd_file.put_line(
487: fnd_file.log, RPAD(l_trans_type, 40) || ' : '
488: || get_trans_type_rec.meaning

Line 486: fnd_file.put_line(

482: || igf_gr_gen.get_per_num(p_base_id)
483: );
484: fnd_file.put_line(fnd_file.log, RPAD(l_loan_id, 40) || ' : ' || p_loan_id);
485:
486: fnd_file.put_line(
487: fnd_file.log, RPAD(l_trans_type, 40) || ' : '
488: || get_trans_type_rec.meaning
489: );
490:

Line 487: fnd_file.log, RPAD(l_trans_type, 40) || ' : '

483: );
484: fnd_file.put_line(fnd_file.log, RPAD(l_loan_id, 40) || ' : ' || p_loan_id);
485:
486: fnd_file.put_line(
487: fnd_file.log, RPAD(l_trans_type, 40) || ' : '
488: || get_trans_type_rec.meaning
489: );
490:
491: fnd_file.put_line(

Line 491: fnd_file.put_line(

487: fnd_file.log, RPAD(l_trans_type, 40) || ' : '
488: || get_trans_type_rec.meaning
489: );
490:
491: fnd_file.put_line(
492: fnd_file.log, RPAD(l_person_id_group, 40) || ' : '
493: || get_grp_name_rec.group_cd
494: );
495: fnd_file.new_line(fnd_file.log, 1);

Line 492: fnd_file.log, RPAD(l_person_id_group, 40) || ' : '

488: || get_trans_type_rec.meaning
489: );
490:
491: fnd_file.put_line(
492: fnd_file.log, RPAD(l_person_id_group, 40) || ' : '
493: || get_grp_name_rec.group_cd
494: );
495: fnd_file.new_line(fnd_file.log, 1);
496: fnd_file.put_line(

Line 495: fnd_file.new_line(fnd_file.log, 1);

491: fnd_file.put_line(
492: fnd_file.log, RPAD(l_person_id_group, 40) || ' : '
493: || get_grp_name_rec.group_cd
494: );
495: fnd_file.new_line(fnd_file.log, 1);
496: fnd_file.put_line(
497: fnd_file.log,
498: '--------------------------------------------------------'
499: );

Line 496: fnd_file.put_line(

492: fnd_file.log, RPAD(l_person_id_group, 40) || ' : '
493: || get_grp_name_rec.group_cd
494: );
495: fnd_file.new_line(fnd_file.log, 1);
496: fnd_file.put_line(
497: fnd_file.log,
498: '--------------------------------------------------------'
499: );
500: fnd_file.new_line(fnd_file.log, 1);

Line 497: fnd_file.log,

493: || get_grp_name_rec.group_cd
494: );
495: fnd_file.new_line(fnd_file.log, 1);
496: fnd_file.put_line(
497: fnd_file.log,
498: '--------------------------------------------------------'
499: );
500: fnd_file.new_line(fnd_file.log, 1);
501: EXCEPTION

Line 500: fnd_file.new_line(fnd_file.log, 1);

496: fnd_file.put_line(
497: fnd_file.log,
498: '--------------------------------------------------------'
499: );
500: fnd_file.new_line(fnd_file.log, 1);
501: EXCEPTION
502: WHEN OTHERS
503: THEN
504: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level

Line 768: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
770: app_exception.raise_exception;
771: END chk_fund_meth_pell;
772:

Line 821: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
823: app_exception.raise_exception;
824: END chk_credit_status;
825:

Line 997: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
999: app_exception.raise_exception;
1000: END chk_todo_result;
1001:

Line 1125: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
1127: app_exception.raise_exception;
1128: END insert_pays_prg_uts;
1129:

Line 1207: fnd_file.put_line(fnd_file.log, SQLERRM);

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

Line 1289: fnd_file.put_line(fnd_file.log, SQLERRM);

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

Line 1402: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
1404: app_exception.raise_exception;
1405: END chk_fclass_result;
1406:

Line 1446: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
1448: app_exception.raise_exception;
1449: END delete_pays;
1450:

Line 1491: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
1493: app_exception.raise_exception;
1494: END get_loan_num;
1495:

Line 1580: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
1582: app_exception.raise_exception;
1583: END get_cut_off_dt;
1584:

Line 1699: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
1703: END set_dri_true;

Line 2004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || p_result);

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
2008: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','cur_awd_disb%FOUND');

Line 2092: fnd_file.new_line(fnd_file.log, 1);

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

Line 2096: fnd_file.put_line(

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

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 2101: fnd_file.new_line(fnd_file.log, 1);

2097: fnd_file.log, RPAD(' ', 10) || fnd_message.get
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));

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 2107: fnd_file.new_line(fnd_file.log, 1);

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
2111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.award_id:' || awd_disb_rec.award_id);

Line 2166: fnd_file.put_line(

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

Line 2167: fnd_file.log, RPAD(' ', 17) || p_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;
2170:
2171: IF NOT l_todo_result AND l_message_name IS NOT NULL

Line 2176: fnd_file.put_line(

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

Line 2177: fnd_file.log, RPAD(' ', 17) || p_result

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;
2180:
2181: IF NOT l_pays_prg

Line 2186: fnd_file.put_line(

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

Line 2187: fnd_file.log, RPAD(' ', 17) || p_result

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;
2190:
2191: IF NOT l_pays_uts

Line 2196: fnd_file.put_line(

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

Line 2197: fnd_file.log, RPAD(' ', 17) || p_result

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;
2200:
2201: IF NOT l_elig_result

Line 2216: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);

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

Line 2298: fnd_file.put_line(

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:
2302: -- message ' Loan Not created for this award '

Line 2299: fnd_file.log, RPAD(' ', 17) || p_result

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:
2302: -- message ' Loan Not created for this award '
2303: IF fnd_log.level_statement >=

Line 2323: fnd_file.put_line(

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

Line 2324: fnd_file.log, RPAD(' ', 17) || p_result

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;
2327:
2328: IF fnd_log.level_statement >=

Line 2346: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);

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
2350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','loan ' || get_loans_rec.loan_number

Line 2364: fnd_file.put_line(

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

Line 2365: fnd_file.log, RPAD(' ', 17) || p_result

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;
2368:
2369: IF fnd_log.level_statement >=

Line 2387: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);

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',
2391: 'loan ' || get_loans_rec.loan_number || ' is not release-4');

Line 2434: fnd_file.put_line(

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:
2438: IF fnd_log.level_statement >=

Line 2435: fnd_file.log, RPAD(' ', 17) || p_result

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:
2438: IF fnd_log.level_statement >=
2439: fnd_log.g_current_runtime_level

Line 2473: fnd_file.put_line(

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

Line 2474: fnd_file.log, RPAD(' ', 17) || p_result

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;
2477:
2478: IF fnd_log.level_statement >=

Line 2497: fnd_file.put_line(

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

Line 2498: fnd_file.log, RPAD(' ', 17) || p_result

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;
2501:
2502: IF fnd_log.level_statement >=

Line 2588: fnd_file.put_line(

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

Line 2589: fnd_file.log, RPAD(' ', 17) || p_result

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;
2592:
2593: IF NOT l_sys_hold_result

Line 2598: fnd_file.put_line(

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

Line 2599: fnd_file.log, RPAD(' ', 17) || p_result

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;
2602:
2603: IF fnd_log.level_statement >=

Line 2687: fnd_file.put_line(

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:
2691: IF fnd_log.level_statement >=

Line 2688: fnd_file.log, RPAD(' ', 17) || p_result

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:
2691: IF fnd_log.level_statement >=
2692: fnd_log.g_current_runtime_level

Line 2771: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);

2767: --p_result := p_message ||fnd_global.newline ||p_result;
2768: p_result := p_message || ' ' || p_result;
2769: END IF;
2770:
2771: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2772:
2773: IF fnd_log.level_statement >=
2774: fnd_log.g_current_runtime_level
2775: THEN

Line 2820: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);

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 >=
2824: fnd_log.g_current_runtime_level

Line 2838: fnd_file.put_line(

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:
2842: IF fnd_log.level_statement >=

Line 2839: fnd_file.log, RPAD(' ', 17) || p_result

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:
2842: IF fnd_log.level_statement >=
2843: fnd_log.g_current_runtime_level

Line 2879: fnd_file.put_line(

2875: IF l_status = 'E'
2876: THEN
2877: -- error message is returned by the method
2878: p_result := p_message;
2879: fnd_file.put_line(
2880: fnd_file.log, RPAD(' ', 17) || p_result
2881: );
2882: RAISE skip_record;
2883:

Line 2880: fnd_file.log, RPAD(' ', 17) || p_result

2876: THEN
2877: -- error message is returned by the method
2878: p_result := p_message;
2879: fnd_file.put_line(
2880: fnd_file.log, RPAD(' ', 17) || p_result
2881: );
2882: RAISE skip_record;
2883:
2884: IF fnd_log.level_statement >=

Line 2899: fnd_file.put_line(

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

Line 2900: fnd_file.log, RPAD(' ', 17) || p_result

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;
2903:
2904: IF fnd_log.level_statement >=

Line 2920: fnd_file.put_line(

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:
2924: IF fnd_log.level_statement >=

Line 2921: fnd_file.log, RPAD(' ', 17) || p_result

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:
2924: IF fnd_log.level_statement >=
2925: fnd_log.g_current_runtime_level

Line 3235: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
3237: app_exception.raise_exception;
3238: END process_student;
3239:

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 3450: fnd_file.new_line(fnd_file.log, 1);

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
3454: CLOSE cur_awdyear;

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 3465: fnd_file.new_line(fnd_file.log, 1);

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
3469: CLOSE cur_get_fund_type;

Line 3485: fnd_file.new_line(fnd_file.log, 2);

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

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 3487: fnd_file.new_line(fnd_file.log, 2);

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:
3491: -- Person ID Group would not pick up any value in case the Person Number or Loan Number is populated

Line 3499: fnd_file.new_line(fnd_file.log, 2);

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

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 3501: fnd_file.new_line(fnd_file.log, 2);

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

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 3554: fnd_file.put_line(

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;
3554: fnd_file.put_line(
3555: fnd_file.log, RPAD(' ', 5) || fnd_message.get || ' '
3556: || per_grp_rec.group_cd
3557: );
3558:

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 3584: fnd_file.put_line(

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:
3588: IF fnd_log.level_statement >=

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 3608: fnd_file.put_line(

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
3610: );
3611:
3612: IF fnd_log.level_statement >=

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 3644: fnd_file.put_line(

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

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 3647: fnd_file.new_line(fnd_file.log, 1);

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 >=
3650: fnd_log.g_current_runtime_level
3651: THEN

Line 3666: fnd_file.put_line(

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(
3667: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3668: );
3669:
3670: IF fnd_log.level_statement >=

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 3683: fnd_file.put_line(

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

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 3722: fnd_file.put_line(

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: );
3725:
3726: IF fnd_log.level_statement >=

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 3779: fnd_file.put_line(

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:
3783: IF fnd_log.level_statement >=

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 3804: fnd_file.put_line(

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
3806: );
3807:
3808: IF fnd_log.level_statement >=

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 3870: fnd_file.put_line(

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

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 3873: fnd_file.new_line(fnd_file.log, 1);

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 >=
3876: fnd_log.g_current_runtime_level
3877: THEN

Line 3892: fnd_file.put_line(

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:
3896: IF fnd_log.level_statement >=

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 3911: fnd_file.new_line(fnd_file.log, 2);

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;
3915: END IF; -- (IF p_fund_id IS NOT NULL)

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 3913: fnd_file.new_line(fnd_file.log, 2);

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
3917: -- i.e, base_id is specified therefore process for the particular student only

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 3942: fnd_file.put_line(

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:
3946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

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 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 4005: fnd_file.new_line(fnd_file.log, 1);

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
4009: fnd_log.string(

Line 4042: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
4046: END igf_sl_rel_disb;