DBA Data[Home] [Help]

APPS.IGF_GR_MRR_LOAD_DATA dependencies on IGF_GR_GEN

Line 82: RAISE igf_gr_gen.skip_this_record;

78: p_igf_gr_mrr_row.current_ssn := SUBSTR(p_record_data,433,9);
79:
80: EXCEPTION
81: WHEN OTHERS THEN -- Number / Date format exception
82: RAISE igf_gr_gen.skip_this_record;
83:
84: END;
85:
86: ELSE

Line 87: RAISE igf_gr_gen.no_file_version;

83:
84: END;
85:
86: ELSE
87: RAISE igf_gr_gen.no_file_version;
88: END IF;
89:
90: EXCEPTION
91:

Line 92: WHEN igf_gr_gen.skip_this_record THEN

88: END IF;
89:
90: EXCEPTION
91:
92: WHEN igf_gr_gen.skip_this_record THEN
93: RAISE;
94:
95: WHEN igf_gr_gen.no_file_version THEN
96: RAISE;

Line 95: WHEN igf_gr_gen.no_file_version THEN

91:
92: WHEN igf_gr_gen.skip_this_record THEN
93: RAISE;
94:
95: WHEN igf_gr_gen.no_file_version THEN
96: RAISE;
97:
98: WHEN OTHERS THEN
99: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 198: igf_gr_gen.process_pell_ack ( g_ver_num,

194:
195: BEGIN
196:
197:
198: igf_gr_gen.process_pell_ack ( g_ver_num,
199: 'MRR',
200: l_number_rec,
201: l_last_gldr_id,
202: l_batch_id);

Line 205: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);

201: l_last_gldr_id,
202: l_batch_id);
203:
204: -- Check the award year matches with the award year in PELL setup.
205: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, l_c_message);
206: IF l_c_message = 'IGF_GR_VRSN_MISMTCH' THEN
207: fnd_message.set_name ('IGF',l_c_message);
208: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
209: fnd_message.set_token('BATCH',l_batch_id);

Line 267: WHEN igf_gr_gen.skip_this_record THEN

263: lp_count := lp_count + 1;
264:
265: EXCEPTION
266:
267: WHEN igf_gr_gen.skip_this_record THEN
268: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_FAIL');
269: fnd_message.set_token('STUD_ORIG_SSN',SUBSTR( mrr_rec_data.record_data, 28, 9));
270: fnd_file.put_line(fnd_file.log,fnd_message.get());
271: lf_count := lf_count + 1;

Line 275: WHEN igf_gr_gen.no_file_version THEN

271: lf_count := lf_count + 1;
272: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
273: fnd_file.put_line(fnd_file.log,fnd_message.get);
274:
275: WHEN igf_gr_gen.no_file_version THEN
276: RAISE;
277:
278: END ;
279:

Line 288: WHEN igf_gr_gen.no_file_version THEN

284: END LOOP;
285:
286: EXCEPTION
287:
288: WHEN igf_gr_gen.no_file_version THEN
289: RAISE;
290:
291: END;
292:

Line 298: RAISE igf_gr_gen.file_not_loaded;

294:
295: IF l_number_rec <> (lp_count + lf_count) THEN
296: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
297: fnd_file.put_line(fnd_file.log,fnd_message.get);
298: RAISE igf_gr_gen.file_not_loaded;
299: END IF;
300:
301: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
302: fnd_message.set_token('CNT',l_number_rec);

Line 316: WHEN igf_gr_gen.no_file_version THEN

312:
313: EXCEPTION
314: WHEN invalid_version THEN
315: RAISE;
316: WHEN igf_gr_gen.no_file_version THEN
317: RAISE;
318: WHEN igf_gr_gen.corrupt_data_file THEN
319: RAISE;
320: WHEN igf_gr_gen.file_not_loaded THEN

Line 318: WHEN igf_gr_gen.corrupt_data_file THEN

314: WHEN invalid_version THEN
315: RAISE;
316: WHEN igf_gr_gen.no_file_version THEN
317: RAISE;
318: WHEN igf_gr_gen.corrupt_data_file THEN
319: RAISE;
320: WHEN igf_gr_gen.file_not_loaded THEN
321: RAISE;
322:

Line 320: WHEN igf_gr_gen.file_not_loaded THEN

316: WHEN igf_gr_gen.no_file_version THEN
317: RAISE;
318: WHEN igf_gr_gen.corrupt_data_file THEN
319: RAISE;
320: WHEN igf_gr_gen.file_not_loaded THEN
321: RAISE;
322:
323: WHEN OTHERS THEN
324: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 372: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);

368: --
369: -- Get the Flat File Version and then Proceed
370: --
371: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');
372: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
373:
374: IF g_ver_num ='NULL' THEN
375: RAISE igf_gr_gen.no_file_version;
376: ELSE

Line 375: RAISE igf_gr_gen.no_file_version;

371: g_ver_num := igf_aw_gen.get_ver_num(l_ci_cal_type,l_ci_sequence_number,'P');
372: g_c_alt_code := igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
373:
374: IF g_ver_num ='NULL' THEN
375: RAISE igf_gr_gen.no_file_version;
376: ELSE
377: load_ack;
378: END IF;
379:

Line 393: WHEN igf_gr_gen.corrupt_data_file THEN

389: retcode := 2;
390: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
391: fnd_file.put_line(fnd_file.log,errbuf);
392:
393: WHEN igf_gr_gen.corrupt_data_file THEN
394: ROLLBACK;
395: retcode := 2;
396: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
397: fnd_file.put_line(fnd_file.log,errbuf);

Line 399: WHEN igf_gr_gen.file_not_loaded THEN

395: retcode := 2;
396: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
397: fnd_file.put_line(fnd_file.log,errbuf);
398:
399: WHEN igf_gr_gen.file_not_loaded THEN
400: ROLLBACK;
401: retcode := 2;
402: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
403: fnd_file.put_line(fnd_file.log,errbuf);

Line 405: WHEN igf_gr_gen.no_file_version THEN

401: retcode := 2;
402: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
403: fnd_file.put_line(fnd_file.log,errbuf);
404:
405: WHEN igf_gr_gen.no_file_version THEN
406: ROLLBACK;
407: retcode := 2;
408: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
409: igs_ge_msg_stack.conc_exception_hndl;