DBA Data[Home] [Help]

APPS.IGF_DB_DISB dependencies on APP_EXCEPTION

Line 360: app_exception.raise_exception;

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:

Line 405: app_exception.raise_exception;

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:

Line 471: app_exception.raise_exception;

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,

Line 724: WHEN app_exception.record_lock_exception THEN

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;

Line 735: app_exception.raise_exception;

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:

Line 1122: WHEN app_exception.record_lock_exception THEN

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');

Line 1134: app_exception.raise_exception;

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:

Line 1175: app_exception.raise_exception;

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:

Line 1338: app_exception.raise_exception;

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:

Line 1468: app_exception.raise_exception;

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:

Line 1560: app_exception.raise_exception;

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,

Line 1650: app_exception.raise_exception;

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:

Line 1716: app_exception.raise_exception;

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,

Line 1837: app_exception.raise_exception;

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,

Line 1928: app_exception.raise_exception;

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:

Line 2280: WHEN app_exception.record_lock_exception THEN

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');

Line 2288: app_exception.raise_exception;

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,

Line 3476: WHEN app_exception.record_lock_exception THEN

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');

Line 3579: WHEN app_exception.record_lock_exception THEN

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');

Line 3587: app_exception.raise_exception;

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,

Line 4001: WHEN app_exception.record_lock_exception THEN

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');