174: OPEN c_prnt_ind(l_ci_cal_type,l_ci_sequence_number);
175: FETCH c_prnt_ind INTO l_print_option,l_awd_year;
176: IF c_prnt_ind%NOTFOUND THEN
177: CLOSE c_prnt_ind;
178: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_DL_SETUP');
179: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
180: RAISE NO_DATA_FOUND;
181: END IF;
182: CLOSE c_prnt_ind;
175: FETCH c_prnt_ind INTO l_print_option,l_awd_year;
176: IF c_prnt_ind%NOTFOUND THEN
177: CLOSE c_prnt_ind;
178: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_DL_SETUP');
179: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
180: RAISE NO_DATA_FOUND;
181: END IF;
182: CLOSE c_prnt_ind;
183:
184:
185: /* Check whether the School is configured to Print and Process Promissory Note or not. If not then display valid message in log file */
186:
187: IF ( l_print_option <> 'F' ) THEN
188: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_SCH_NOPRNT');
189: FND_MESSAGE.SET_TOKEN('AWD_YR', l_awd_year );
190: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
191: RETURN;
192: END IF;
185: /* Check whether the School is configured to Print and Process Promissory Note or not. If not then display valid message in log file */
186:
187: IF ( l_print_option <> 'F' ) THEN
188: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_SCH_NOPRNT');
189: FND_MESSAGE.SET_TOKEN('AWD_YR', l_awd_year );
190: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
191: RETURN;
192: END IF;
193:
186:
187: IF ( l_print_option <> 'F' ) THEN
188: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_SCH_NOPRNT');
189: FND_MESSAGE.SET_TOKEN('AWD_YR', l_awd_year );
190: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
191: RETURN;
192: END IF;
193:
194:
367: EXCEPTION
368: WHEN app_exception.record_lock_exception THEN
369:
370: fnd_file.put_line(fnd_file.log,' ');
371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
375: fnd_file.put_line(fnd_file.log,fnd_message.get);
368: WHEN app_exception.record_lock_exception THEN
369:
370: fnd_file.put_line(fnd_file.log,' ');
371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
375: fnd_file.put_line(fnd_file.log,fnd_message.get);
376: fnd_file.put_line(fnd_file.log,' ');
370: fnd_file.put_line(fnd_file.log,' ');
371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
375: fnd_file.put_line(fnd_file.log,fnd_message.get);
376: fnd_file.put_line(fnd_file.log,' ');
377: ROLLBACK TO sp_prom_manifest;
378:
371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
375: fnd_file.put_line(fnd_file.log,fnd_message.get);
376: fnd_file.put_line(fnd_file.log,' ');
377: ROLLBACK TO sp_prom_manifest;
378:
379: END;
384: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
386:
387:
388: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_OF_PNOTES');
389: FND_MESSAGE.SET_TOKEN('NO_OF_PNOTES', l_total_pnote );
390: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
391:
392: IF l_total_pnote = 0 THEN
385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
386:
387:
388: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_OF_PNOTES');
389: FND_MESSAGE.SET_TOKEN('NO_OF_PNOTES', l_total_pnote );
390: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
391:
392: IF l_total_pnote = 0 THEN
393: --There are no Signed Promissory Notes.Promissory Note Manifest has not been created.
386:
387:
388: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_OF_PNOTES');
389: FND_MESSAGE.SET_TOKEN('NO_OF_PNOTES', l_total_pnote );
390: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
391:
392: IF l_total_pnote = 0 THEN
393: --There are no Signed Promissory Notes.Promissory Note Manifest has not been created.
394: fnd_message.set_name('IGF','IGF_SL_NO_SIGN_PROMNOTE');
390: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
391:
392: IF l_total_pnote = 0 THEN
393: --There are no Signed Promissory Notes.Promissory Note Manifest has not been created.
394: fnd_message.set_name('IGF','IGF_SL_NO_SIGN_PROMNOTE');
395: fnd_file.put_line(fnd_file.log,fnd_message.get);
396: END IF;
397:
398: IF l_batch_seq_num IS NOT NULL THEN
391:
392: IF l_total_pnote = 0 THEN
393: --There are no Signed Promissory Notes.Promissory Note Manifest has not been created.
394: fnd_message.set_name('IGF','IGF_SL_NO_SIGN_PROMNOTE');
395: fnd_file.put_line(fnd_file.log,fnd_message.get);
396: END IF;
397:
398: IF l_batch_seq_num IS NOT NULL THEN
399:
396: END IF;
397:
398: IF l_batch_seq_num IS NOT NULL THEN
399:
400: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_BATCH_SEQNO');
401: FND_MESSAGE.SET_TOKEN('PNOTE_BATCH_SEQNO', NVL( l_batch_seq_num, NULL) );
402: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
403:
404: END IF;
397:
398: IF l_batch_seq_num IS NOT NULL THEN
399:
400: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_BATCH_SEQNO');
401: FND_MESSAGE.SET_TOKEN('PNOTE_BATCH_SEQNO', NVL( l_batch_seq_num, NULL) );
402: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
403:
404: END IF;
405:
398: IF l_batch_seq_num IS NOT NULL THEN
399:
400: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_BATCH_SEQNO');
401: FND_MESSAGE.SET_TOKEN('PNOTE_BATCH_SEQNO', NVL( l_batch_seq_num, NULL) );
402: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
403:
404: END IF;
405:
406:
409: NULL;
410: WHEN app_exception.record_lock_exception THEN
411: ROLLBACK;
412: RETCODE := 2;
413: ERRBUF := FND_MESSAGE.GET_STRING('IGF','IGF_GE_LOCK_ERROR');
414: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
415:
416: WHEN OTHERS THEN
417: ROLLBACK;
415:
416: WHEN OTHERS THEN
417: ROLLBACK;
418: RETCODE :=2;
419: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
420: FND_MESSAGE.SET_TOKEN('NAME','igf_sl_dl_print_manifest.process_manifest');
421: ERRBUF := FND_MESSAGE.GET;
422: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
423:
416: WHEN OTHERS THEN
417: ROLLBACK;
418: RETCODE :=2;
419: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
420: FND_MESSAGE.SET_TOKEN('NAME','igf_sl_dl_print_manifest.process_manifest');
421: ERRBUF := FND_MESSAGE.GET;
422: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
423:
424: END process_manifest;
417: ROLLBACK;
418: RETCODE :=2;
419: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
420: FND_MESSAGE.SET_TOKEN('NAME','igf_sl_dl_print_manifest.process_manifest');
421: ERRBUF := FND_MESSAGE.GET;
422: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
423:
424: END process_manifest;
425: