[Home] [Help]
1: PACKAGE BODY igf_sl_dl_orig_ack AS
2: /* $Header: IGFSL04B.pls 120.5 2006/04/18 03:28:34 akomurav noship $ */
3: ---------------------------------------------------------------------------------
4: -- akomurav 28-Feb-2006 Build FA161.
5: -- TBH Impact change done in upd_lor_record() and
274: END IF;
275:
276: IF l_dl_loan_catg in ('DL_STAFFORD','DL_PLUS') THEN
277: -- This is an Direct Loan Origination Acknowledgment File
278: fnd_message.set_name('IGF','IGF_SL_DL_ORIG_ACK_FILE');
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280:
281: ELSIF l_dl_loan_catg = 'DL_PLUS_CREDIT' THEN
282: -- This is an Direct Loan Credit Response File
474: WHEN yr_full_participant THEN
475: NULL;
476: WHEN OTHERS THEN
477: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
478: fnd_message.set_token('NAME','IGF_SL_DL_ORIG_ACK.DL_LOAD_DATA');
479: fnd_file.put_line(fnd_file.log,SQLERRM);
480: igs_ge_msg_stack.add;
481: app_exception.raise_exception;
482:
1127: WHEN app_exception.record_lock_exception THEN
1128: RAISE;
1129: WHEN others THEN
1130: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1131: fnd_message.set_token('NAME','IGF_SL_DL_ORIG_ACK.UPD_LOR_RECORD');
1132: fnd_file.put_line(fnd_file.log,SQLERRM);
1133: igs_ge_msg_stack.add;
1134: app_exception.raise_exception;
1135: END upd_lor_record;
1407: WHEN app_exception.record_lock_exception THEN
1408: RAISE;
1409: WHEN others THEN
1410: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1411: fnd_message.set_token('NAME','IGF_SL_DL_ORIG_ACK.UPD_LOR_LOC_RECORD');
1412: fnd_file.put_line(fnd_file.log,SQLERRM);
1413: igs_ge_msg_stack.add;
1414: app_exception.raise_exception;
1415:
1451:
1452: END dl_credit_ack;
1453:
1454:
1455: END igf_sl_dl_orig_ack;