356: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
357: fnd_message.set_token('NAME','IGF_DB_DISB.GET_CUT_OFF_DT '||SQLERRM);
358: fnd_file.put_line(fnd_file.log,SQLERRM);
359: igs_ge_msg_stack.add;
360: app_exception.raise_exception;
361:
362:
363: END get_cut_off_dt;
364:
401: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
402: fnd_message.set_token('NAME','IGF_DB_DISB.GET_FUND_DESC ' ||SQLERRM);
403: fnd_file.put_line(fnd_file.log,SQLERRM);
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406:
407: END get_fund_desc;
408:
409:
467: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
468: fnd_message.set_token('NAME','IGF_DB_DISB.PER_IN_FA '||SQLERRM);
469: fnd_file.put_line(fnd_file.log,SQLERRM);
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472:
473: END per_in_fa;
474:
475: PROCEDURE create_actual ( p_row_id ROWID,
720:
721: WHEN gross_amt_zero THEN
722: RAISE gross_amt_zero;
723:
724: WHEN app_exception.record_lock_exception THEN
725: RAISE;
726:
727: WHEN OTHERS THEN
728: fnd_message.clear;
731: fnd_message.set_token('NAME','IGF_DB_DISB.CREATE_ACTUAL '||SQLERRM);
732: fnd_file.put_line(fnd_file.log,SQLERRM);
733: igs_ge_msg_stack.initialize;
734: igs_ge_msg_stack.add;
735: app_exception.raise_exception;
736:
737: END create_actual;
738:
739:
1118: );
1119: END IF; --for lb_create_new
1120:
1121: EXCEPTION
1122: WHEN app_exception.record_lock_exception THEN
1123: RAISE;
1124:
1125: WHEN ORIG_STATUS THEN
1126: fnd_message.set_name('IGF','IGF_AW_LOAN_SENT');
1130: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1131: fnd_message.set_token('NAME','IGF_DB_DISB.REVERT_DISB '||SQLERRM);
1132: fnd_file.put_line(fnd_file.log,SQLERRM);
1133: igs_ge_msg_stack.add;
1134: app_exception.raise_exception;
1135:
1136: END revert_disb;
1137:
1138:
1171: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1172: fnd_message.set_token('NAME','IGF_DB_DISB.DELETE_PAYS '||SQLERRM);
1173: fnd_file.put_line(fnd_file.log,SQLERRM);
1174: igs_ge_msg_stack.add;
1175: app_exception.raise_exception;
1176:
1177: END delete_pays;
1178:
1179:
1334: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1335: fnd_message.set_token('NAME','IGF_DB_DISB.CHK_TODO_RESULT '||SQLERRM);
1336: fnd_file.put_line(fnd_file.log,SQLERRM);
1337: igs_ge_msg_stack.add;
1338: app_exception.raise_exception;
1339:
1340: END chk_todo_result;
1341:
1342:
1464: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1465: fnd_message.set_token('NAME','IGF_DB_DISB.INSERT_PAYS_PRG_UTS '||SQLERRM);
1466: fnd_file.put_line(fnd_file.log,SQLERRM);
1467: igs_ge_msg_stack.add;
1468: app_exception.raise_exception;
1469:
1470: END insert_pays_prg_uts;
1471:
1472:
1556: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1557: fnd_message.set_token('NAME','IGF_DB_DISB.CHK_PAYS_PRG '||SQLERRM);
1558: fnd_file.put_line(fnd_file.log,SQLERRM);
1559: igs_ge_msg_stack.add;
1560: app_exception.raise_exception;
1561:
1562: END chk_pays_prg;
1563:
1564: FUNCTION chk_pays_uts( p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1646: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1647: fnd_message.set_token('NAME','IGF_DB_DISB.CHK_PAYS_UTS '||SQLERRM);
1648: fnd_file.put_line(fnd_file.log,SQLERRM);
1649: igs_ge_msg_stack.add;
1650: app_exception.raise_exception;
1651:
1652: END chk_pays_uts;
1653:
1654:
1712: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1713: fnd_message.set_token('NAME','IGF_DB_DISB.CHK_FED_ELIG '||SQLERRM);
1714: fnd_file.put_line(fnd_file.log,SQLERRM);
1715: igs_ge_msg_stack.add;
1716: app_exception.raise_exception;
1717:
1718: END chk_fed_elig;
1719:
1720: FUNCTION chk_fclass_result(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1833: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1834: fnd_message.set_token('NAME','IGF_DB_DISB.CHK_FCLASS_RESULT '||SQLERRM);
1835: fnd_file.put_line(fnd_file.log,SQLERRM);
1836: igs_ge_msg_stack.add;
1837: app_exception.raise_exception;
1838:
1839: END chk_fclass_result;
1840:
1841: FUNCTION chk_att_result(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1924: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1925: fnd_message.set_token('NAME','IGF_DB_DISB.CHK_ATT_RESULT '||SQLERRM);
1926: fnd_file.put_line(fnd_file.log,SQLERRM);
1927: igs_ge_msg_stack.add;
1928: app_exception.raise_exception;
1929:
1930: END chk_att_result;
1931:
1932:
2276: CLOSE cur_awd_disb;
2277:
2278: EXCEPTION
2279:
2280: WHEN app_exception.record_lock_exception THEN
2281: RAISE;
2282:
2283: WHEN OTHERS THEN
2284: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2284: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2285: fnd_message.set_token('NAME','IGF_DB_DISB.DISB_VERF_ENF '||SQLERRM);
2286: fnd_file.put_line(fnd_file.log,SQLERRM);
2287: igs_ge_msg_stack.add;
2288: app_exception.raise_exception;
2289:
2290: END disb_verf_enf;
2291:
2292: PROCEDURE process_student( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
3472: EXIT WHEN cur_awd_disb%NOTFOUND;
3473:
3474: EXCEPTION
3475:
3476: WHEN app_exception.record_lock_exception THEN
3477: RAISE;
3478:
3479: WHEN gross_amt_zero THEN
3480: fnd_message.set_name('IGF','IGF_DB_CREATE_ZERO');
3575:
3576:
3577: EXCEPTION
3578:
3579: WHEN app_exception.record_lock_exception THEN
3580: RAISE;
3581:
3582: WHEN OTHERS THEN
3583: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3583: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3584: fnd_message.set_token('NAME','IGF_DB_DISB.PROCESS_STUDENT' || SQLERRM);
3585: fnd_file.put_line(fnd_file.log,SQLERRM);
3586: igs_ge_msg_stack.add;
3587: app_exception.raise_exception;
3588:
3589: END process_student;
3590:
3591: PROCEDURE disb_process( errbuf OUT NOCOPY VARCHAR2,
3997: fnd_message.set_name('IGF','IGF_DB_PARAM_EX');
3998: igs_ge_msg_stack.add;
3999: igs_ge_msg_stack.conc_exception_hndl;
4000:
4001: WHEN app_exception.record_lock_exception THEN
4002:
4003: ROLLBACK;
4004: retcode := 2;
4005: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');