eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_DL_ORIG_ACK dependencies on FND_MESSAGE

Line 204: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');

200: l_rec_batch_rej_code,
201: l_rec_batch_type;
202: IF c_header%NOTFOUND THEN
203: CLOSE c_header;
204: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
205: fnd_file.put_line(fnd_file.log,fnd_message.get);
206: -- Message : Response File uploaded is not complete.
207: RAISE file_not_loaded;
208: END IF;

Line 205: fnd_file.put_line(fnd_file.log,fnd_message.get);

201: l_rec_batch_type;
202: IF c_header%NOTFOUND THEN
203: CLOSE c_header;
204: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
205: fnd_file.put_line(fnd_file.log,fnd_message.get);
206: -- Message : Response File uploaded is not complete.
207: RAISE file_not_loaded;
208: END IF;
209: CLOSE c_header;

Line 230: fnd_message.set_name('IGF','IGF_SL_COD_NO_CRDT_ACK');

226:
227: IF igf_sl_dl_validation.check_full_participant (awd_year_rec.ci_cal_type, awd_year_rec.ci_sequence_number,'DL') THEN
228:
229: IF g_entry_point = 'CREDIT' THEN
230: fnd_message.set_name('IGF','IGF_SL_COD_NO_CRDT_ACK');
231: fnd_file.put_line(fnd_file.log,fnd_message.get);
232: raise yr_full_participant;
233:
234: ELSE

Line 231: fnd_file.put_line(fnd_file.log,fnd_message.get);

227: IF igf_sl_dl_validation.check_full_participant (awd_year_rec.ci_cal_type, awd_year_rec.ci_sequence_number,'DL') THEN
228:
229: IF g_entry_point = 'CREDIT' THEN
230: fnd_message.set_name('IGF','IGF_SL_COD_NO_CRDT_ACK');
231: fnd_file.put_line(fnd_file.log,fnd_message.get);
232: raise yr_full_participant;
233:
234: ELSE
235: fnd_message.set_name('IGF','IGF_SL_COD_NO_ACK');

Line 235: fnd_message.set_name('IGF','IGF_SL_COD_NO_ACK');

231: fnd_file.put_line(fnd_file.log,fnd_message.get);
232: raise yr_full_participant;
233:
234: ELSE
235: fnd_message.set_name('IGF','IGF_SL_COD_NO_ACK');
236: fnd_file.put_line(fnd_file.log,fnd_message.get);
237: raise yr_full_participant;
238: END IF;
239:

Line 236: fnd_file.put_line(fnd_file.log,fnd_message.get);

232: raise yr_full_participant;
233:
234: ELSE
235: fnd_message.set_name('IGF','IGF_SL_COD_NO_ACK');
236: fnd_file.put_line(fnd_file.log,fnd_message.get);
237: raise yr_full_participant;
238: END IF;
239:
240: END IF;

Line 253: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');

249: AND l_dl_loan_catg IN ('DL_STAFFORD','DL_PLUS')
250: AND g_entry_point = 'NULL' THEN
251: NULL;
252: ELSIF g_entry_point <> 'CREDIT' THEN
253: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
254: fnd_file.put_line(fnd_file.log,fnd_message.get);
255: -- Message : This is not a valid file
256: RAISE file_not_loaded;
257: END IF;

Line 254: fnd_file.put_line(fnd_file.log,fnd_message.get);

250: AND g_entry_point = 'NULL' THEN
251: NULL;
252: ELSIF g_entry_point <> 'CREDIT' THEN
253: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
254: fnd_file.put_line(fnd_file.log,fnd_message.get);
255: -- Message : This is not a valid file
256: RAISE file_not_loaded;
257: END IF;
258:

Line 270: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');

266: AND l_dl_loan_catg = 'DL_PLUS_CREDIT'
267: AND g_entry_point = 'CREDIT' THEN
268: NULL;
269: ELSIF g_entry_point <> 'NULL' THEN
270: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
271: fnd_file.put_line(fnd_file.log,fnd_message.get);
272: -- Message : This is not a valid file
273: RAISE file_not_loaded;
274: END IF;

Line 271: fnd_file.put_line(fnd_file.log,fnd_message.get);

267: AND g_entry_point = 'CREDIT' THEN
268: NULL;
269: ELSIF g_entry_point <> 'NULL' THEN
270: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
271: fnd_file.put_line(fnd_file.log,fnd_message.get);
272: -- Message : This is not a valid file
273: RAISE file_not_loaded;
274: END IF;
275:

Line 278: fnd_message.set_name('IGF','IGF_SL_DL_ORIG_ACK_FILE');

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

Line 279: fnd_file.put_line(fnd_file.log,fnd_message.get);

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
283: fnd_message.set_name('IGF','IGF_SL_DL_CREDIT_ACK_FILE');

Line 283: fnd_message.set_name('IGF','IGF_SL_DL_CREDIT_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
283: fnd_message.set_name('IGF','IGF_SL_DL_CREDIT_ACK_FILE');
284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285:
286: END IF;
287:

Line 284: 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
283: fnd_message.set_name('IGF','IGF_SL_DL_CREDIT_ACK_FILE');
284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285:
286: END IF;
287:
288:

Line 296: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');

292: FETCH c_trailer into l_last_lort_id, l_number_rec, l_accept_rec,
293: l_reject_rec, l_pending_rec;
294: IF c_trailer%NOTFOUND THEN
295: CLOSE c_trailer;
296: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
297: fnd_file.put_line(fnd_file.log,fnd_message.get);
298: RAISE file_not_loaded;
299: END IF;
300: CLOSE c_trailer;

Line 297: fnd_file.put_line(fnd_file.log,fnd_message.get);

293: l_reject_rec, l_pending_rec;
294: IF c_trailer%NOTFOUND THEN
295: CLOSE c_trailer;
296: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
297: fnd_file.put_line(fnd_file.log,fnd_message.get);
298: RAISE file_not_loaded;
299: END IF;
300: CLOSE c_trailer;
301:

Line 304: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');

300: CLOSE c_trailer;
301:
302:
303: IF l_rec_batch_rej_code IS NOT NULL THEN
304: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
305: fnd_message.set_token('BATCH', l_rec_batch_id);
306: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308: RAISE file_not_loaded;

Line 305: fnd_message.set_token('BATCH', l_rec_batch_id);

301:
302:
303: IF l_rec_batch_rej_code IS NOT NULL THEN
304: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
305: fnd_message.set_token('BATCH', l_rec_batch_id);
306: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308: RAISE file_not_loaded;
309: END IF;

Line 306: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));

302:
303: IF l_rec_batch_rej_code IS NOT NULL THEN
304: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
305: fnd_message.set_token('BATCH', l_rec_batch_id);
306: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308: RAISE file_not_loaded;
309: END IF;
310:

Line 307: fnd_file.put_line(fnd_file.log,fnd_message.get);

303: IF l_rec_batch_rej_code IS NOT NULL THEN
304: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
305: fnd_message.set_token('BATCH', l_rec_batch_id);
306: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308: RAISE file_not_loaded;
309: END IF;
310:
311:

Line 365: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');

361: x_elec_mpn_ind => NVL(RTRIM(SUBSTR(orec.record_data,65,1)),'P') --added for 2216956
362: );
363: END LOOP;
364: IF l_actual_rec <> l_number_rec THEN
365: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
366: -- Message : The Actual Number of records does not match with the one mentioned in the trailer
367: fnd_file.put_line(fnd_file.log,fnd_message.get);
368: RAISE file_not_loaded;
369: END IF;

Line 367: fnd_file.put_line(fnd_file.log,fnd_message.get);

363: END LOOP;
364: IF l_actual_rec <> l_number_rec THEN
365: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
366: -- Message : The Actual Number of records does not match with the one mentioned in the trailer
367: fnd_file.put_line(fnd_file.log,fnd_message.get);
368: RAISE file_not_loaded;
369: END IF;
370: END IF;
371:

Line 389: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');

385: X_status => 'N'
386: );
387: END LOOP;
388: IF l_actual_rec <> l_number_rec THEN
389: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
390: fnd_file.put_line(fnd_file.log,fnd_message.get);
391: RAISE file_not_loaded;
392: END IF;
393: END IF;

Line 390: fnd_file.put_line(fnd_file.log,fnd_message.get);

386: );
387: END LOOP;
388: IF l_actual_rec <> l_number_rec THEN
389: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
390: fnd_file.put_line(fnd_file.log,fnd_message.get);
391: RAISE file_not_loaded;
392: END IF;
393: END IF;
394:

Line 425: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');

421: x_elec_mpn_ind => NVL(RTRIM(SUBSTR(orec.record_data,65,1)),'P') --added for 2216956
422: );
423: END LOOP;
424: IF l_actual_rec <> l_number_rec THEN
425: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
426: -- Message : The Actual Number of records does not match with the one mentioned in the trailer
427: fnd_file.put_line(fnd_file.log,fnd_message.get);
428: RAISE file_not_loaded;
429: END IF;

Line 427: fnd_file.put_line(fnd_file.log,fnd_message.get);

423: END LOOP;
424: IF l_actual_rec <> l_number_rec THEN
425: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
426: -- Message : The Actual Number of records does not match with the one mentioned in the trailer
427: fnd_file.put_line(fnd_file.log,fnd_message.get);
428: RAISE file_not_loaded;
429: END IF;
430: END IF;
431:

Line 454: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');

450: x_mpn_indicator => LTRIM(RTRIM(SUBSTR(orec.record_data,59,1)))
451: );
452: END LOOP;
453: IF l_actual_rec <> l_number_rec THEN
454: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
455: fnd_file.put_line(fnd_file.log,fnd_message.get);
456: RAISE file_not_loaded;
457: END IF;
458: END IF;

Line 455: fnd_file.put_line(fnd_file.log,fnd_message.get);

451: );
452: END LOOP;
453: IF l_actual_rec <> l_number_rec THEN
454: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
455: fnd_file.put_line(fnd_file.log,fnd_message.get);
456: RAISE file_not_loaded;
457: END IF;
458: END IF;
459:

Line 477: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

473: RAISE;
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;

Line 478: fnd_message.set_token('NAME','IGF_SL_DL_ORIG_ACK.DL_LOAD_DATA');

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:

Line 596: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');

592:
593: upd_lor_record(resp_rec.loan_number, 'ORIG_ACK', l_rec_present, l_rec_updated);
594:
595: IF l_rec_present = 'N' THEN
596: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
597: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
598: fnd_file.put_line(fnd_file.log, fnd_message.get);
599: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
600: ELSE

Line 597: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);

593: upd_lor_record(resp_rec.loan_number, 'ORIG_ACK', l_rec_present, l_rec_updated);
594:
595: IF l_rec_present = 'N' THEN
596: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
597: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
598: fnd_file.put_line(fnd_file.log, fnd_message.get);
599: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
600: ELSE
601: -- If the Loan Number is a Valid Loan-number

Line 598: fnd_file.put_line(fnd_file.log, fnd_message.get);

594:
595: IF l_rec_present = 'N' THEN
596: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
597: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
598: fnd_file.put_line(fnd_file.log, fnd_message.get);
599: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
600: ELSE
601: -- If the Loan Number is a Valid Loan-number
602:

Line 604: fnd_message.set_name('IGF','IGF_SL_OLD_ORIG_ACK_DATE');

600: ELSE
601: -- If the Loan Number is a Valid Loan-number
602:
603: IF l_rec_updated = 'N' THEN
604: fnd_message.set_name('IGF','IGF_SL_OLD_ORIG_ACK_DATE');
605: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
606: fnd_file.put_line(fnd_file.log, fnd_message.get);
607: -- Message : Acknowledgment for Loan ID #LOAN_NUMBER not loaded, due to old acknowledgement date
608: ELSE

Line 605: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);

601: -- If the Loan Number is a Valid Loan-number
602:
603: IF l_rec_updated = 'N' THEN
604: fnd_message.set_name('IGF','IGF_SL_OLD_ORIG_ACK_DATE');
605: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
606: fnd_file.put_line(fnd_file.log, fnd_message.get);
607: -- Message : Acknowledgment for Loan ID #LOAN_NUMBER not loaded, due to old acknowledgement date
608: ELSE
609: -- Show any Origination Reject Codes in the Log File, if any.

Line 606: fnd_file.put_line(fnd_file.log, fnd_message.get);

602:
603: IF l_rec_updated = 'N' THEN
604: fnd_message.set_name('IGF','IGF_SL_OLD_ORIG_ACK_DATE');
605: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
606: fnd_file.put_line(fnd_file.log, fnd_message.get);
607: -- Message : Acknowledgment for Loan ID #LOAN_NUMBER not loaded, due to old acknowledgement date
608: ELSE
609: -- Show any Origination Reject Codes in the Log File, if any.
610: DECLARE

Line 695: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');

691: -- Update the IGF_SL_LOR record.
692: upd_lor_record(crresp_rec.loan_number, 'CREDIT_ACK', l_rec_present, l_rec_updated);
693:
694: IF l_rec_present = 'N' THEN
695: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
696: fnd_message.set_token('LOAN_NUMBER',crresp_rec.loan_number);
697: fnd_file.put_line(fnd_file.log, fnd_message.get);
698: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
699: ELSE

Line 696: fnd_message.set_token('LOAN_NUMBER',crresp_rec.loan_number);

692: upd_lor_record(crresp_rec.loan_number, 'CREDIT_ACK', l_rec_present, l_rec_updated);
693:
694: IF l_rec_present = 'N' THEN
695: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
696: fnd_message.set_token('LOAN_NUMBER',crresp_rec.loan_number);
697: fnd_file.put_line(fnd_file.log, fnd_message.get);
698: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
699: ELSE
700: -- If the Loan Number is a Valid Loan-number

Line 697: fnd_file.put_line(fnd_file.log, fnd_message.get);

693:
694: IF l_rec_present = 'N' THEN
695: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
696: fnd_message.set_token('LOAN_NUMBER',crresp_rec.loan_number);
697: fnd_file.put_line(fnd_file.log, fnd_message.get);
698: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
699: ELSE
700: -- If the Loan Number is a Valid Loan-number
701: IF l_rec_updated = 'N' THEN

Line 702: fnd_message.set_name('IGF','IGF_SL_OLD_CREDT_ACK_DATE');

698: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
699: ELSE
700: -- If the Loan Number is a Valid Loan-number
701: IF l_rec_updated = 'N' THEN
702: fnd_message.set_name('IGF','IGF_SL_OLD_CREDT_ACK_DATE');
703: fnd_message.set_token('LOAN_NUMBER',crresp_rec.loan_number);
704: fnd_file.put_line(fnd_file.log, fnd_message.get);
705: -- Message : Acknowledgment for Loan ID #LOAN_NUMBER not loaded, due to old credit acknowledgement date
706: END IF; -- End of condition for "l_rec_updated = 'N' "

Line 703: fnd_message.set_token('LOAN_NUMBER',crresp_rec.loan_number);

699: ELSE
700: -- If the Loan Number is a Valid Loan-number
701: IF l_rec_updated = 'N' THEN
702: fnd_message.set_name('IGF','IGF_SL_OLD_CREDT_ACK_DATE');
703: fnd_message.set_token('LOAN_NUMBER',crresp_rec.loan_number);
704: fnd_file.put_line(fnd_file.log, fnd_message.get);
705: -- Message : Acknowledgment for Loan ID #LOAN_NUMBER not loaded, due to old credit acknowledgement date
706: END IF; -- End of condition for "l_rec_updated = 'N' "
707: END IF; -- End of condition for "l_rec_present = 'N' "

Line 704: fnd_file.put_line(fnd_file.log, fnd_message.get);

700: -- If the Loan Number is a Valid Loan-number
701: IF l_rec_updated = 'N' THEN
702: fnd_message.set_name('IGF','IGF_SL_OLD_CREDT_ACK_DATE');
703: fnd_message.set_token('LOAN_NUMBER',crresp_rec.loan_number);
704: fnd_file.put_line(fnd_file.log, fnd_message.get);
705: -- Message : Acknowledgment for Loan ID #LOAN_NUMBER not loaded, due to old credit acknowledgement date
706: END IF; -- End of condition for "l_rec_updated = 'N' "
707: END IF; -- End of condition for "l_rec_present = 'N' "
708:

Line 761: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

757: EXCEPTION
758: WHEN app_exception.record_lock_exception THEN
759: ROLLBACK;
760: retcode := 2;
761: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
762: igs_ge_msg_stack.conc_exception_hndl;
763: WHEN file_not_loaded THEN
764: ROLLBACK;
765: retcode := 2;

Line 766: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');

762: igs_ge_msg_stack.conc_exception_hndl;
763: WHEN file_not_loaded THEN
764: ROLLBACK;
765: retcode := 2;
766: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
767: igs_ge_msg_stack.conc_exception_hndl;
768: WHEN OTHERS THEN
769: ROLLBACK;
770: retcode := 2;

Line 771: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

767: igs_ge_msg_stack.conc_exception_hndl;
768: WHEN OTHERS THEN
769: ROLLBACK;
770: retcode := 2;
771: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
772: fnd_file.put_line(fnd_file.log,SQLERRM);
773: igs_ge_msg_stack.conc_exception_hndl;
774: END dl_orig_ack;
775:

Line 1083: fnd_message.set_name('IGF','IGF_SL_LOAN_STATUS');

1079: l_update_loan := 'Y';
1080: END IF;
1081:
1082: IF l_update_loan = 'Y' THEN
1083: fnd_message.set_name('IGF','IGF_SL_LOAN_STATUS');
1084: fnd_message.set_token('LOAN_NUMBER',p_loan_number);
1085: fnd_message.set_token('LOAN_STATUS',igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_status));
1086: fnd_file.put_line(fnd_file.log, fnd_message.get);
1087: -- Message : Loan ID #LOAN_NUMBER has been #LOAN_STATUS

Line 1084: fnd_message.set_token('LOAN_NUMBER',p_loan_number);

1080: END IF;
1081:
1082: IF l_update_loan = 'Y' THEN
1083: fnd_message.set_name('IGF','IGF_SL_LOAN_STATUS');
1084: fnd_message.set_token('LOAN_NUMBER',p_loan_number);
1085: fnd_message.set_token('LOAN_STATUS',igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_status));
1086: fnd_file.put_line(fnd_file.log, fnd_message.get);
1087: -- Message : Loan ID #LOAN_NUMBER has been #LOAN_STATUS
1088:

Line 1085: fnd_message.set_token('LOAN_STATUS',igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_status));

1081:
1082: IF l_update_loan = 'Y' THEN
1083: fnd_message.set_name('IGF','IGF_SL_LOAN_STATUS');
1084: fnd_message.set_token('LOAN_NUMBER',p_loan_number);
1085: fnd_message.set_token('LOAN_STATUS',igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_status));
1086: fnd_file.put_line(fnd_file.log, fnd_message.get);
1087: -- Message : Loan ID #LOAN_NUMBER has been #LOAN_STATUS
1088:
1089: -- Set the Loan Status and Loan Status Date to New Values

Line 1086: fnd_file.put_line(fnd_file.log, fnd_message.get);

1082: IF l_update_loan = 'Y' THEN
1083: fnd_message.set_name('IGF','IGF_SL_LOAN_STATUS');
1084: fnd_message.set_token('LOAN_NUMBER',p_loan_number);
1085: fnd_message.set_token('LOAN_STATUS',igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_status));
1086: fnd_file.put_line(fnd_file.log, fnd_message.get);
1087: -- Message : Loan ID #LOAN_NUMBER has been #LOAN_STATUS
1088:
1089: -- Set the Loan Status and Loan Status Date to New Values
1090: g_lor_loc_rec.loan_status := l_loan_status;

Line 1130: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1126:
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;

Line 1131: fnd_message.set_token('NAME','IGF_SL_DL_ORIG_ACK.UPD_LOR_RECORD');

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;

Line 1410: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1406: EXCEPTION
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;

Line 1411: fnd_message.set_token('NAME','IGF_SL_DL_ORIG_ACK.UPD_LOR_LOC_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:

Line 1438: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

1434:
1435: WHEN app_exception.record_lock_exception THEN
1436: ROLLBACK;
1437: retcode := 2;
1438: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
1439: igs_ge_msg_stack.conc_exception_hndl;
1440: WHEN file_not_loaded THEN
1441: ROLLBACK;
1442: retcode := 2;

Line 1443: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');

1439: igs_ge_msg_stack.conc_exception_hndl;
1440: WHEN file_not_loaded THEN
1441: ROLLBACK;
1442: retcode := 2;
1443: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
1444: igs_ge_msg_stack.conc_exception_hndl;
1445: WHEN OTHERS THEN
1446: ROLLBACK;
1447: retcode := 2;

Line 1448: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1444: igs_ge_msg_stack.conc_exception_hndl;
1445: WHEN OTHERS THEN
1446: ROLLBACK;
1447: retcode := 2;
1448: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1449: fnd_file.put_line(fnd_file.log,SQLERRM);
1450: igs_ge_msg_stack.conc_exception_hndl;
1451:
1452: END dl_credit_ack;