228: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
229: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.GET_BORROWER_PARENT_ID');
230: fnd_file.put_line(fnd_file.log,fnd_message.get || '-' || SQLERRM);
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: END get_borrower_parent_id;
234:
235:
236: PROCEDURE populate_cosigner_data (p_loan_id igf_sl_loans_all.loan_id%TYPE,
435: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
436: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.POPULATE_COSIGNER_DATA');
437: fnd_file.put_line(fnd_file.log,fnd_message.get || '-' || SQLERRM);
438: igs_ge_msg_stack.add;
439: app_exception.raise_exception;
440: END populate_cosigner_data;
441:
442:
443:
600: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
601: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.GET_DL_ENTITY_ID');
602: fnd_file.put_line(fnd_file.log,SQLERRM);
603: igs_ge_msg_stack.add;
604: app_exception.raise_exception;
605:
606: END get_dl_entity_id;
607:
608: FUNCTION get_loan_start_dt ( p_award_id igf_aw_award_all.award_id%TYPE)
909: WHEN NO_DATA_FOUND THEN
910: fnd_message.set_name('IGF','IGF_GE_NO_DATA_FOUND');
911: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.RET_LOAN_NUMBER');
912: igs_ge_msg_stack.add;
913: app_exception.raise_exception;
914:
915: WHEN OTHERS THEN
916: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
917: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.RET_LOAN_NUMBER');
916: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
917: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.RET_LOAN_NUMBER');
918: fnd_file.put_line(fnd_file.log,SQLERRM);
919: igs_ge_msg_stack.add;
920: app_exception.raise_exception;
921:
922: END ret_loan_number;
923:
924: PROCEDURE get_dl_cl_std_code ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1037: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1038: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.GET_DL_CL_STD_CODE');
1039: fnd_file.put_line(fnd_file.log,SQLERRM);
1040: igs_ge_msg_stack.add;
1041: app_exception.raise_exception;
1042: END get_dl_cl_std_code ;
1043:
1044:
1045: PROCEDURE return_entities ( P_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1234: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1235: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.GET_FA_BASE_DETAILS');
1236: fnd_file.put_line(fnd_file.log,SQLERRM);
1237: igs_ge_msg_stack.add;
1238: app_exception.raise_exception;
1239: END get_fa_base_details;
1240:
1241:
1242:
1460: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1461: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.INSERT_LOR_DL_RECORDS');
1462: fnd_file.put_line(fnd_file.log,SQLERRM);
1463: igs_ge_msg_stack.add;
1464: app_exception.raise_exception;
1465:
1466: END insert_lor_dl_records;
1467:
1468:
1965: WHEN NO_DATA_FOUND THEN
1966: fnd_message.set_name('IGF','IGF_GE_NO_DATA_FOUND');
1967: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.INSERT_LOR_CL_RECORDS');
1968: igs_ge_msg_stack.add;
1969: app_exception.raise_exception;
1970: WHEN OTHERS THEN
1971: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1972: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_lar_creation.insert_lor_cl_records.exception',SQLERRM);
1973: END IF;
1974: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1975: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.INSERT_LOR_CL_RECORDS');
1976: fnd_file.put_line(fnd_file.log,SQLERRM);
1977: igs_ge_msg_stack.add;
1978: app_exception.raise_exception;
1979:
1980: END insert_lor_cl_records;
1981:
1982:
2589: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2590: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_lar_creation.update_loan_rec.exception','Exception:'||SQLERRM);
2591: END IF;
2592: igs_ge_msg_stack.add;
2593: app_exception.raise_exception;
2594:
2595: END update_loan_rec;
2596: -- FA 134
2597:
3020: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3021: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.create_loan_records');
3022: fnd_file.put_line(fnd_file.log,SQLERRM);
3023: igs_ge_msg_stack.add;
3024: app_exception.raise_exception;
3025:
3026: END create_loan_records;
3027:
3028:
3080: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3081: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.per_in_fa.exception','Exception:'||SQLERRM);
3082: END IF;
3083: igs_ge_msg_stack.add;
3084: app_exception.raise_exception;
3085:
3086: END per_in_fa;
3087:
3088: -- FA 134