DBA Data[Home] [Help]

APPS.IGF_GR_ESS_ESD_DATA dependencies on FND_MESSAGE

Line 116: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

112: WHEN igf_gr_gen.no_file_version THEN
113: RAISE;
114:
115: WHEN OTHERS THEN
116: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
117: fnd_message.set_token('NAME','igf_gr_ess_esd_data.split_ess_fields');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120:

Line 117: fnd_message.set_token('NAME','igf_gr_ess_esd_data.split_ess_fields');

113: RAISE;
114:
115: WHEN OTHERS THEN
116: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
117: fnd_message.set_token('NAME','igf_gr_ess_esd_data.split_ess_fields');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120:
121: END split_ess_fields;

Line 188: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

184: WHEN igf_gr_gen.no_file_version THEN
185: RAISE;
186:
187: WHEN OTHERS THEN
188: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
189: fnd_message.set_token('NAME','igf_gr_ess_esd_data.split_esd_fields');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192:

Line 189: fnd_message.set_token('NAME','igf_gr_ess_esd_data.split_esd_fields');

185: RAISE;
186:
187: WHEN OTHERS THEN
188: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
189: fnd_message.set_token('NAME','igf_gr_ess_esd_data.split_esd_fields');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192:
193: END split_esd_fields;

Line 238: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

234: x_gaps_award_num => p_ess_rec.gaps_award_num );
235:
236: EXCEPTION
237: WHEN OTHERS THEN
238: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
239: fnd_message.set_token('NAME','igf_gr_ess_esd_data.insert_in_ess_table');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242:

Line 239: fnd_message.set_token('NAME','igf_gr_ess_esd_data.insert_in_ess_table');

235:
236: EXCEPTION
237: WHEN OTHERS THEN
238: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
239: fnd_message.set_token('NAME','igf_gr_ess_esd_data.insert_in_ess_table');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242:
243: END insert_in_ess_table;

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

274: x_adj_batch_id => p_esd_rec.adj_batch_id);
275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
279: fnd_message.set_token('NAME','igf_gr_ess_esd_data.insert_in_esd_table');
280: igs_ge_msg_stack.add;
281: app_exception.raise_exception;
282:

Line 279: fnd_message.set_token('NAME','igf_gr_ess_esd_data.insert_in_esd_table');

275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
279: fnd_message.set_token('NAME','igf_gr_ess_esd_data.insert_in_esd_table');
280: igs_ge_msg_stack.add;
281: app_exception.raise_exception;
282:
283: END insert_in_esd_table;

Line 320: fnd_message.set_name ('IGF',l_c_message);

316:
317: -- Check the award year matches with the award year in PELL setup.
318: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
319: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
320: fnd_message.set_name ('IGF',l_c_message);
321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
322: fnd_message.set_token('BATCH',l_batch_id);
323: fnd_message.set_token('AWD_YR',g_c_alt_code);
324: fnd_message.set_token('VRSN',g_ver_num);

Line 321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));

317: -- Check the award year matches with the award year in PELL setup.
318: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
319: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
320: fnd_message.set_name ('IGF',l_c_message);
321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
322: fnd_message.set_token('BATCH',l_batch_id);
323: fnd_message.set_token('AWD_YR',g_c_alt_code);
324: fnd_message.set_token('VRSN',g_ver_num);
325: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 322: fnd_message.set_token('BATCH',l_batch_id);

318: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
319: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
320: fnd_message.set_name ('IGF',l_c_message);
321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
322: fnd_message.set_token('BATCH',l_batch_id);
323: fnd_message.set_token('AWD_YR',g_c_alt_code);
324: fnd_message.set_token('VRSN',g_ver_num);
325: fnd_file.put_line(fnd_file.log,fnd_message.get);
326: RAISE invalid_version;

Line 323: fnd_message.set_token('AWD_YR',g_c_alt_code);

319: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
320: fnd_message.set_name ('IGF',l_c_message);
321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
322: fnd_message.set_token('BATCH',l_batch_id);
323: fnd_message.set_token('AWD_YR',g_c_alt_code);
324: fnd_message.set_token('VRSN',g_ver_num);
325: fnd_file.put_line(fnd_file.log,fnd_message.get);
326: RAISE invalid_version;
327: END IF;

Line 324: fnd_message.set_token('VRSN',g_ver_num);

320: fnd_message.set_name ('IGF',l_c_message);
321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
322: fnd_message.set_token('BATCH',l_batch_id);
323: fnd_message.set_token('AWD_YR',g_c_alt_code);
324: fnd_message.set_token('VRSN',g_ver_num);
325: fnd_file.put_line(fnd_file.log,fnd_message.get);
326: RAISE invalid_version;
327: END IF;
328:

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

321: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
322: fnd_message.set_token('BATCH',l_batch_id);
323: fnd_message.set_token('AWD_YR',g_c_alt_code);
324: fnd_message.set_token('VRSN',g_ver_num);
325: fnd_file.put_line(fnd_file.log,fnd_message.get);
326: RAISE invalid_version;
327: END IF;
328:
329: IF l_number_rec > 0 THEN

Line 370: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_PASS');

366:
367: insert_in_ess_table(lv_ess_row);
368:
369:
370: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_PASS');
371: fnd_message.set_token('VALUE',' ');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373:
374: lp_count := lp_count + 1;

Line 371: fnd_message.set_token('VALUE',' ');

367: insert_in_ess_table(lv_ess_row);
368:
369:
370: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_PASS');
371: fnd_message.set_token('VALUE',' ');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373:
374: lp_count := lp_count + 1;
375:

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

368:
369:
370: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_PASS');
371: fnd_message.set_token('VALUE',' ');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373:
374: lp_count := lp_count + 1;
375:
376: EXCEPTION

Line 378: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_FAIL');

374: lp_count := lp_count + 1;
375:
376: EXCEPTION
377: WHEN igf_gr_gen.skip_this_record THEN
378: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_FAIL');
379: fnd_message.set_token('VALUE',' ');
380: fnd_file.put_line(fnd_file.log,fnd_message.get);
381:
382: lf_count := lf_count + 1;

Line 379: fnd_message.set_token('VALUE',' ');

375:
376: EXCEPTION
377: WHEN igf_gr_gen.skip_this_record THEN
378: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_FAIL');
379: fnd_message.set_token('VALUE',' ');
380: fnd_file.put_line(fnd_file.log,fnd_message.get);
381:
382: lf_count := lf_count + 1;
383: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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

376: EXCEPTION
377: WHEN igf_gr_gen.skip_this_record THEN
378: fnd_message.set_name('IGF','IGF_GR_ESS_LOAD_FAIL');
379: fnd_message.set_token('VALUE',' ');
380: fnd_file.put_line(fnd_file.log,fnd_message.get);
381:
382: lf_count := lf_count + 1;
383: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
384: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

379: fnd_message.set_token('VALUE',' ');
380: fnd_file.put_line(fnd_file.log,fnd_message.get);
381:
382: lf_count := lf_count + 1;
383: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385:
386: WHEN igf_gr_gen.no_file_version THEN
387: RAISE;

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

380: fnd_file.put_line(fnd_file.log,fnd_message.get);
381:
382: lf_count := lf_count + 1;
383: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385:
386: WHEN igf_gr_gen.no_file_version THEN
387: RAISE;
388:

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

396:
397: END IF;
398:
399: IF l_number_rec <> (lp_count + lf_count) THEN
400: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
401: fnd_file.put_line(fnd_file.log,fnd_message.get);
402: RAISE igf_gr_gen.file_not_loaded;
403: END IF;
404:

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

397: END IF;
398:
399: IF l_number_rec <> (lp_count + lf_count) THEN
400: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
401: fnd_file.put_line(fnd_file.log,fnd_message.get);
402: RAISE igf_gr_gen.file_not_loaded;
403: END IF;
404:
405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

Line 405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

401: fnd_file.put_line(fnd_file.log,fnd_message.get);
402: RAISE igf_gr_gen.file_not_loaded;
403: END IF;
404:
405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
406: fnd_message.set_token('CNT',l_number_rec);
407: fnd_file.put_line(fnd_file.log,fnd_message.get);
408:
409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');

Line 406: fnd_message.set_token('CNT',l_number_rec);

402: RAISE igf_gr_gen.file_not_loaded;
403: END IF;
404:
405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
406: fnd_message.set_token('CNT',l_number_rec);
407: fnd_file.put_line(fnd_file.log,fnd_message.get);
408:
409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
410: fnd_message.set_token('CNT',lp_count);

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

403: END IF;
404:
405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
406: fnd_message.set_token('CNT',l_number_rec);
407: fnd_file.put_line(fnd_file.log,fnd_message.get);
408:
409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
410: fnd_message.set_token('CNT',lp_count);
411: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');

405: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
406: fnd_message.set_token('CNT',l_number_rec);
407: fnd_file.put_line(fnd_file.log,fnd_message.get);
408:
409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
410: fnd_message.set_token('CNT',lp_count);
411: fnd_file.put_line(fnd_file.log,fnd_message.get);
412:
413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

Line 410: fnd_message.set_token('CNT',lp_count);

406: fnd_message.set_token('CNT',l_number_rec);
407: fnd_file.put_line(fnd_file.log,fnd_message.get);
408:
409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
410: fnd_message.set_token('CNT',lp_count);
411: fnd_file.put_line(fnd_file.log,fnd_message.get);
412:
413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
414: fnd_message.set_token('CNT',lf_count);

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

407: fnd_file.put_line(fnd_file.log,fnd_message.get);
408:
409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
410: fnd_message.set_token('CNT',lp_count);
411: fnd_file.put_line(fnd_file.log,fnd_message.get);
412:
413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
414: fnd_message.set_token('CNT',lf_count);
415: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

409: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
410: fnd_message.set_token('CNT',lp_count);
411: fnd_file.put_line(fnd_file.log,fnd_message.get);
412:
413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
414: fnd_message.set_token('CNT',lf_count);
415: fnd_file.put_line(fnd_file.log,fnd_message.get);
416:
417:

Line 414: fnd_message.set_token('CNT',lf_count);

410: fnd_message.set_token('CNT',lp_count);
411: fnd_file.put_line(fnd_file.log,fnd_message.get);
412:
413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
414: fnd_message.set_token('CNT',lf_count);
415: fnd_file.put_line(fnd_file.log,fnd_message.get);
416:
417:
418: EXCEPTION

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

411: fnd_file.put_line(fnd_file.log,fnd_message.get);
412:
413: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
414: fnd_message.set_token('CNT',lf_count);
415: fnd_file.put_line(fnd_file.log,fnd_message.get);
416:
417:
418: EXCEPTION
419: WHEN invalid_version THEN

Line 430: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

426: WHEN igf_gr_gen.file_not_loaded THEN
427: RAISE;
428:
429: WHEN OTHERS THEN
430: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
431: fnd_message.set_token('NAME','igf_gr_ess_esd_data.ess_load ');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434:

Line 431: fnd_message.set_token('NAME','igf_gr_ess_esd_data.ess_load ');

427: RAISE;
428:
429: WHEN OTHERS THEN
430: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
431: fnd_message.set_token('NAME','igf_gr_ess_esd_data.ess_load ');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434:
435: END ess_load;

Line 469: fnd_message.set_name ('IGF',l_c_message);

465:
466: -- Check the award year matches with the award year in PELL setup.
467: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
468: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
469: fnd_message.set_name ('IGF',l_c_message);
470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
471: fnd_message.set_token('BATCH',l_batch_id);
472: fnd_message.set_token('AWD_YR',g_c_alt_code);
473: fnd_message.set_token('VRSN',g_ver_num);

Line 470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));

466: -- Check the award year matches with the award year in PELL setup.
467: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
468: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
469: fnd_message.set_name ('IGF',l_c_message);
470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
471: fnd_message.set_token('BATCH',l_batch_id);
472: fnd_message.set_token('AWD_YR',g_c_alt_code);
473: fnd_message.set_token('VRSN',g_ver_num);
474: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 471: fnd_message.set_token('BATCH',l_batch_id);

467: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
468: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
469: fnd_message.set_name ('IGF',l_c_message);
470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
471: fnd_message.set_token('BATCH',l_batch_id);
472: fnd_message.set_token('AWD_YR',g_c_alt_code);
473: fnd_message.set_token('VRSN',g_ver_num);
474: fnd_file.put_line(fnd_file.log,fnd_message.get);
475: RAISE invalid_version;

Line 472: fnd_message.set_token('AWD_YR',g_c_alt_code);

468: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
469: fnd_message.set_name ('IGF',l_c_message);
470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
471: fnd_message.set_token('BATCH',l_batch_id);
472: fnd_message.set_token('AWD_YR',g_c_alt_code);
473: fnd_message.set_token('VRSN',g_ver_num);
474: fnd_file.put_line(fnd_file.log,fnd_message.get);
475: RAISE invalid_version;
476: END IF;

Line 473: fnd_message.set_token('VRSN',g_ver_num);

469: fnd_message.set_name ('IGF',l_c_message);
470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
471: fnd_message.set_token('BATCH',l_batch_id);
472: fnd_message.set_token('AWD_YR',g_c_alt_code);
473: fnd_message.set_token('VRSN',g_ver_num);
474: fnd_file.put_line(fnd_file.log,fnd_message.get);
475: RAISE invalid_version;
476: END IF;
477:

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

470: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
471: fnd_message.set_token('BATCH',l_batch_id);
472: fnd_message.set_token('AWD_YR',g_c_alt_code);
473: fnd_message.set_token('VRSN',g_ver_num);
474: fnd_file.put_line(fnd_file.log,fnd_message.get);
475: RAISE invalid_version;
476: END IF;
477:
478: IF l_number_rec > 0 THEN

Line 518: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_PASS');

514:
515: insert_in_esd_table(lv_esd_row);
516:
517:
518: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_PASS');
519: fnd_message.set_token('VALUE',' ');
520: fnd_file.put_line(fnd_file.log,fnd_message.get);
521: lp_count := lp_count + 1;
522:

Line 519: fnd_message.set_token('VALUE',' ');

515: insert_in_esd_table(lv_esd_row);
516:
517:
518: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_PASS');
519: fnd_message.set_token('VALUE',' ');
520: fnd_file.put_line(fnd_file.log,fnd_message.get);
521: lp_count := lp_count + 1;
522:
523: EXCEPTION

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

516:
517:
518: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_PASS');
519: fnd_message.set_token('VALUE',' ');
520: fnd_file.put_line(fnd_file.log,fnd_message.get);
521: lp_count := lp_count + 1;
522:
523: EXCEPTION
524: WHEN igf_gr_gen.skip_this_record THEN

Line 525: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_FAIL');

521: lp_count := lp_count + 1;
522:
523: EXCEPTION
524: WHEN igf_gr_gen.skip_this_record THEN
525: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_FAIL');
526: fnd_message.set_token('VALUE',' ' );
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: lf_count := lf_count + 1;
529: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

Line 526: fnd_message.set_token('VALUE',' ' );

522:
523: EXCEPTION
524: WHEN igf_gr_gen.skip_this_record THEN
525: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_FAIL');
526: fnd_message.set_token('VALUE',' ' );
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: lf_count := lf_count + 1;
529: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
530: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

523: EXCEPTION
524: WHEN igf_gr_gen.skip_this_record THEN
525: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_FAIL');
526: fnd_message.set_token('VALUE',' ' );
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: lf_count := lf_count + 1;
529: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
530: fnd_file.put_line(fnd_file.log,fnd_message.get);
531:

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

525: fnd_message.set_name('IGF','IGF_GR_ESD_LOAD_FAIL');
526: fnd_message.set_token('VALUE',' ' );
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: lf_count := lf_count + 1;
529: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
530: fnd_file.put_line(fnd_file.log,fnd_message.get);
531:
532: WHEN igf_gr_gen.no_file_version THEN
533: RAISE;

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

526: fnd_message.set_token('VALUE',' ' );
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: lf_count := lf_count + 1;
529: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
530: fnd_file.put_line(fnd_file.log,fnd_message.get);
531:
532: WHEN igf_gr_gen.no_file_version THEN
533: RAISE;
534: END;

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

541:
542: END IF;
543:
544: IF l_number_rec <> (lp_count + lf_count) THEN
545: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
546: fnd_file.put_line(fnd_file.log,fnd_message.get);
547: RAISE igf_gr_gen.file_not_loaded;
548: END IF;
549:

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

542: END IF;
543:
544: IF l_number_rec <> (lp_count + lf_count) THEN
545: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
546: fnd_file.put_line(fnd_file.log,fnd_message.get);
547: RAISE igf_gr_gen.file_not_loaded;
548: END IF;
549:
550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

Line 550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

546: fnd_file.put_line(fnd_file.log,fnd_message.get);
547: RAISE igf_gr_gen.file_not_loaded;
548: END IF;
549:
550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
551: fnd_message.set_token('CNT',l_number_rec);
552: fnd_file.put_line(fnd_file.log,fnd_message.get);
553:
554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');

Line 551: fnd_message.set_token('CNT',l_number_rec);

547: RAISE igf_gr_gen.file_not_loaded;
548: END IF;
549:
550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
551: fnd_message.set_token('CNT',l_number_rec);
552: fnd_file.put_line(fnd_file.log,fnd_message.get);
553:
554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
555: fnd_message.set_token('CNT',lp_count);

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

548: END IF;
549:
550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
551: fnd_message.set_token('CNT',l_number_rec);
552: fnd_file.put_line(fnd_file.log,fnd_message.get);
553:
554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
555: fnd_message.set_token('CNT',lp_count);
556: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');

550: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
551: fnd_message.set_token('CNT',l_number_rec);
552: fnd_file.put_line(fnd_file.log,fnd_message.get);
553:
554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
555: fnd_message.set_token('CNT',lp_count);
556: fnd_file.put_line(fnd_file.log,fnd_message.get);
557:
558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

Line 555: fnd_message.set_token('CNT',lp_count);

551: fnd_message.set_token('CNT',l_number_rec);
552: fnd_file.put_line(fnd_file.log,fnd_message.get);
553:
554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
555: fnd_message.set_token('CNT',lp_count);
556: fnd_file.put_line(fnd_file.log,fnd_message.get);
557:
558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
559: fnd_message.set_token('CNT',lf_count);

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

552: fnd_file.put_line(fnd_file.log,fnd_message.get);
553:
554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
555: fnd_message.set_token('CNT',lp_count);
556: fnd_file.put_line(fnd_file.log,fnd_message.get);
557:
558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
559: fnd_message.set_token('CNT',lf_count);
560: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

554: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
555: fnd_message.set_token('CNT',lp_count);
556: fnd_file.put_line(fnd_file.log,fnd_message.get);
557:
558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
559: fnd_message.set_token('CNT',lf_count);
560: fnd_file.put_line(fnd_file.log,fnd_message.get);
561:
562:

Line 559: fnd_message.set_token('CNT',lf_count);

555: fnd_message.set_token('CNT',lp_count);
556: fnd_file.put_line(fnd_file.log,fnd_message.get);
557:
558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
559: fnd_message.set_token('CNT',lf_count);
560: fnd_file.put_line(fnd_file.log,fnd_message.get);
561:
562:
563:

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

556: fnd_file.put_line(fnd_file.log,fnd_message.get);
557:
558: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
559: fnd_message.set_token('CNT',lf_count);
560: fnd_file.put_line(fnd_file.log,fnd_message.get);
561:
562:
563:
564: EXCEPTION

Line 575: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

571: WHEN igf_gr_gen.file_not_loaded THEN
572: RAISE;
573:
574: WHEN OTHERS THEN
575: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
576: fnd_message.set_token('NAME','igf_gr_ess_esd_data.esd_load ');
577: igs_ge_msg_stack.add;
578: app_exception.raise_exception;
579:

Line 576: fnd_message.set_token('NAME','igf_gr_ess_esd_data.esd_load ');

572: RAISE;
573:
574: WHEN OTHERS THEN
575: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
576: fnd_message.set_token('NAME','igf_gr_ess_esd_data.esd_load ');
577: igs_ge_msg_stack.add;
578: app_exception.raise_exception;
579:
580: END esd_load;

Line 646: errbuf := fnd_message.get_string('IGF','IGF_GR_NO_PELL_SETUP');

642:
643: WHEN no_data_found THEN
644: ROLLBACK;
645: retcode := 2;
646: errbuf := fnd_message.get_string('IGF','IGF_GR_NO_PELL_SETUP');
647: fnd_file.put_line(fnd_file.log,errbuf);
648:
649: WHEN param_error THEN
650: ROLLBACK;

Line 652: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');

648:
649: WHEN param_error THEN
650: ROLLBACK;
651: retcode := 2;
652: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
653: fnd_file.put_line(fnd_file.log,errbuf);
654:
655: WHEN igf_gr_gen.corrupt_data_file THEN
656: ROLLBACK;

Line 658: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');

654:
655: WHEN igf_gr_gen.corrupt_data_file THEN
656: ROLLBACK;
657: retcode := 2;
658: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
659: fnd_file.put_line(fnd_file.log,errbuf);
660:
661: WHEN igf_gr_gen.file_not_loaded THEN
662: ROLLBACK;

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

660:
661: WHEN igf_gr_gen.file_not_loaded THEN
662: ROLLBACK;
663: retcode := 2;
664: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
665: fnd_file.put_line(fnd_file.log,errbuf);
666:
667: WHEN igf_gr_gen.no_file_version THEN
668: ROLLBACK;

Line 670: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');

666:
667: WHEN igf_gr_gen.no_file_version THEN
668: ROLLBACK;
669: retcode := 2;
670: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
671: igs_ge_msg_stack.conc_exception_hndl;
672:
673: WHEN others THEN
674:

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

673: WHEN others THEN
674:
675: ROLLBACK;
676: retcode := 2;
677: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
678: igs_ge_msg_stack.conc_exception_hndl;
679:
680: END main;
681:

Line 745: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');

741:
742: WHEN param_error THEN
743: ROLLBACK;
744: retcode := 2;
745: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
746: fnd_file.put_line(fnd_file.log,errbuf);
747:
748: WHEN igf_gr_gen.corrupt_data_file THEN
749: ROLLBACK;

Line 751: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');

747:
748: WHEN igf_gr_gen.corrupt_data_file THEN
749: ROLLBACK;
750: retcode := 2;
751: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
752: fnd_file.put_line(fnd_file.log,errbuf);
753:
754: WHEN igf_gr_gen.file_not_loaded THEN
755: ROLLBACK;

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

753:
754: WHEN igf_gr_gen.file_not_loaded THEN
755: ROLLBACK;
756: retcode := 2;
757: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
758: fnd_file.put_line(fnd_file.log,errbuf);
759:
760: WHEN igf_gr_gen.no_file_version THEN
761: ROLLBACK;

Line 763: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');

759:
760: WHEN igf_gr_gen.no_file_version THEN
761: ROLLBACK;
762: retcode := 2;
763: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
764: igs_ge_msg_stack.conc_exception_hndl;
765:
766: WHEN others THEN
767:

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

766: WHEN others THEN
767:
768: ROLLBACK;
769: retcode := 2;
770: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
771: igs_ge_msg_stack.conc_exception_hndl;
772:
773: END main_s;
774: