DBA Data[Home] [Help]

APPS.IGF_SL_DL_PRINT_MANIFEST dependencies on FND_MESSAGE

Line 178: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_DL_SETUP');

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;

Line 179: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

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:

Line 188: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_SCH_NOPRNT');

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;

Line 189: FND_MESSAGE.SET_TOKEN('AWD_YR', l_awd_year );

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:

Line 190: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

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:

Line 371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');

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);

Line 372: 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,' ');

Line 374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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:

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

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;

Line 388: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_OF_PNOTES');

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

Line 389: FND_MESSAGE.SET_TOKEN('NO_OF_PNOTES', l_total_pnote );

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.

Line 390: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

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');

Line 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

Line 395: 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
399:

Line 400: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_BATCH_SEQNO');

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;

Line 401: FND_MESSAGE.SET_TOKEN('PNOTE_BATCH_SEQNO', NVL( l_batch_seq_num, NULL) );

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:

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

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:

Line 413: ERRBUF := FND_MESSAGE.GET_STRING('IGF','IGF_GE_LOCK_ERROR');

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;

Line 419: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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:

Line 420: FND_MESSAGE.SET_TOKEN('NAME','igf_sl_dl_print_manifest.process_manifest');

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;

Line 421: ERRBUF := FND_MESSAGE.GET;

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: