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