DBA Data[Home] [Help]

APPS.IGF_SL_REL_DISB dependencies on APP_EXCEPTION

Line 70: app_exception.raise_exception;

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:
73: FUNCTION chk_attendance(
74: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 167: app_exception.raise_exception;

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:
170: FUNCTION chk_fed_elig(
171: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE, p_fund_type VARCHAR2

Line 233: app_exception.raise_exception;

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:
236: FUNCTION chk_loan_active(p_loan_id igf_sl_loans_all.loan_id%TYPE)
237: RETURN BOOLEAN

Line 275: app_exception.raise_exception;

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:
278: FUNCTION per_in_fa(
279: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE, p_ci_cal_type VARCHAR2,

Line 333: app_exception.raise_exception;

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:
336:
337: ----------------------------------------------------------------------------------------------------------------------------------

Line 770: app_exception.raise_exception;

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:
773: FUNCTION chk_credit_status(p_award_id igf_aw_award_all.award_id%TYPE)
774: RETURN BOOLEAN

Line 823: app_exception.raise_exception;

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:
826: FUNCTION chk_todo_result(
827: p_message_name OUT NOCOPY VARCHAR2,

Line 999: app_exception.raise_exception;

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:
1002: PROCEDURE insert_pays_prg_uts(
1003: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 1127: app_exception.raise_exception;

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:
1130: FUNCTION chk_pays_prg(
1131: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

Line 1209: app_exception.raise_exception;

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:
1212: FUNCTION chk_pays_uts(
1213: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

Line 1291: app_exception.raise_exception;

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:
1294: FUNCTION chk_fclass_result(
1295: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 1404: app_exception.raise_exception;

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:
1407: PROCEDURE delete_pays
1408: AS

Line 1448: app_exception.raise_exception;

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:
1451: FUNCTION get_loan_num(p_loan_id igf_sl_loans_all.loan_id%TYPE)
1452: RETURN VARCHAR2

Line 1493: app_exception.raise_exception;

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:
1496: FUNCTION get_cut_off_dt(
1497: p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE,

Line 1582: app_exception.raise_exception;

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:
1585: PROCEDURE set_dri_true(
1586: p_award_id igf_aw_awd_disb_all.award_id%TYPE,

Line 1691: WHEN app_exception.record_lock_exception

1687: x_fund_return_mthd_code => get_adisb_rec.fund_return_mthd_code,
1688: x_direct_to_borr_flag => get_adisb_rec.direct_to_borr_flag
1689: );
1690: EXCEPTION
1691: WHEN app_exception.record_lock_exception
1692: THEN
1693: RAISE;
1694: WHEN OTHERS
1695: THEN

Line 1702: app_exception.raise_exception;

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;
1704:
1705:
1706: --------------------------------------------------------------------------------------------------------------------------------

Line 3183: WHEN app_exception.record_lock_exception

3179:
3180: EXIT;
3181: END IF;
3182: EXCEPTION
3183: WHEN app_exception.record_lock_exception
3184: THEN
3185: RAISE;
3186: WHEN skip_record
3187: THEN

Line 3226: WHEN app_exception.record_lock_exception

3222: CLOSE cur_awd_disb_fed_no_trans;
3223: END IF;
3224: END IF; --(IF cur_awd_disb%NOTFOUND)
3225: EXCEPTION
3226: WHEN app_exception.record_lock_exception
3227: THEN
3228: RAISE;
3229: WHEN OTHERS
3230: THEN

Line 3237: app_exception.raise_exception;

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:
3240:
3241: --------------------------------------------------------------------------------------------------------------------------------

Line 4030: WHEN app_exception.record_lock_exception

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
4032: ROLLBACK;
4033: p_retcode := 2;
4034: fnd_message.set_name('IGF', 'IGF_GE_LOCK_ERROR');