eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_GR_MRR_LOAD_DATA dependencies on FND_MESSAGE

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

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');
100: fnd_message.set_token('NAME','igf_gr_mrr_load_data.split_into_fields');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103:

Line 100: fnd_message.set_token('NAME','igf_gr_mrr_load_data.split_into_fields');

96: RAISE;
97:
98: WHEN OTHERS THEN
99: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
100: fnd_message.set_token('NAME','igf_gr_mrr_load_data.split_into_fields');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103:
104: END split_into_fields;

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

162: ) ;
163:
164: EXCEPTION
165: WHEN OTHERS THEN
166: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
167: fnd_message.set_token('NAME','igf_gr_mrr_load_data.insert_in_mrr_table');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END insert_in_mrr_table;

Line 167: fnd_message.set_token('NAME','igf_gr_mrr_load_data.insert_in_mrr_table');

163:
164: EXCEPTION
165: WHEN OTHERS THEN
166: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
167: fnd_message.set_token('NAME','igf_gr_mrr_load_data.insert_in_mrr_table');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END insert_in_mrr_table;
171:

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

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);
210: fnd_message.set_token('AWD_YR',g_c_alt_code);
211: fnd_message.set_token('VRSN',g_ver_num);

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

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);
210: fnd_message.set_token('AWD_YR',g_c_alt_code);
211: fnd_message.set_token('VRSN',g_ver_num);
212: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

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);
210: fnd_message.set_token('AWD_YR',g_c_alt_code);
211: fnd_message.set_token('VRSN',g_ver_num);
212: fnd_file.put_line(fnd_file.log,fnd_message.get);
213: RAISE invalid_version;

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

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);
210: fnd_message.set_token('AWD_YR',g_c_alt_code);
211: fnd_message.set_token('VRSN',g_ver_num);
212: fnd_file.put_line(fnd_file.log,fnd_message.get);
213: RAISE invalid_version;
214: END IF;

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

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);
210: fnd_message.set_token('AWD_YR',g_c_alt_code);
211: fnd_message.set_token('VRSN',g_ver_num);
212: fnd_file.put_line(fnd_file.log,fnd_message.get);
213: RAISE invalid_version;
214: END IF;
215:

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

208: fnd_message.set_token('CYCL',substr(l_batch_id,3,4));
209: fnd_message.set_token('BATCH',l_batch_id);
210: fnd_message.set_token('AWD_YR',g_c_alt_code);
211: fnd_message.set_token('VRSN',g_ver_num);
212: fnd_file.put_line(fnd_file.log,fnd_message.get);
213: RAISE invalid_version;
214: END IF;
215:
216: IF l_number_rec > 0 THEN

Line 260: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_PASS');

256: insert_in_mrr_table (lv_mrr_row );
257: --
258: -- Make an entry in the log file indicating Success
259: --
260: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_PASS');
261: fnd_message.set_token('STUD_ORIG_SSN',lv_mrr_row.stud_orig_ssn);
262: fnd_file.put_line(fnd_file.log,fnd_message.get());
263: lp_count := lp_count + 1;
264:

Line 261: fnd_message.set_token('STUD_ORIG_SSN',lv_mrr_row.stud_orig_ssn);

257: --
258: -- Make an entry in the log file indicating Success
259: --
260: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_PASS');
261: fnd_message.set_token('STUD_ORIG_SSN',lv_mrr_row.stud_orig_ssn);
262: fnd_file.put_line(fnd_file.log,fnd_message.get());
263: lp_count := lp_count + 1;
264:
265: EXCEPTION

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

258: -- Make an entry in the log file indicating Success
259: --
260: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_PASS');
261: fnd_message.set_token('STUD_ORIG_SSN',lv_mrr_row.stud_orig_ssn);
262: fnd_file.put_line(fnd_file.log,fnd_message.get());
263: lp_count := lp_count + 1;
264:
265: EXCEPTION
266:

Line 268: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_FAIL');

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;
272: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

Line 269: fnd_message.set_token('STUD_ORIG_SSN',SUBSTR( mrr_rec_data.record_data, 28, 9));

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;
272: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
273: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

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;
272: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
273: fnd_file.put_line(fnd_file.log,fnd_message.get);
274:

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

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

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

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

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

292:
293: END IF;
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:

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

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

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

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);
303: fnd_file.put_line(fnd_file.log,fnd_message.get);
304:
305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');

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

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);
303: fnd_file.put_line(fnd_file.log,fnd_message.get);
304:
305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
306: fnd_message.set_token('CNT',lp_count);

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

299: END IF;
300:
301: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
302: fnd_message.set_token('CNT',l_number_rec);
303: fnd_file.put_line(fnd_file.log,fnd_message.get);
304:
305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
306: fnd_message.set_token('CNT',lp_count);
307: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

301: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
302: fnd_message.set_token('CNT',l_number_rec);
303: fnd_file.put_line(fnd_file.log,fnd_message.get);
304:
305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
306: fnd_message.set_token('CNT',lp_count);
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308:
309: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

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

302: fnd_message.set_token('CNT',l_number_rec);
303: fnd_file.put_line(fnd_file.log,fnd_message.get);
304:
305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
306: fnd_message.set_token('CNT',lp_count);
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308:
309: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
310: fnd_message.set_token('CNT',lf_count);

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

303: fnd_file.put_line(fnd_file.log,fnd_message.get);
304:
305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
306: fnd_message.set_token('CNT',lp_count);
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308:
309: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
310: fnd_message.set_token('CNT',lf_count);
311: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

305: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
306: fnd_message.set_token('CNT',lp_count);
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308:
309: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
310: fnd_message.set_token('CNT',lf_count);
311: fnd_file.put_line(fnd_file.log,fnd_message.get);
312:
313: EXCEPTION

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

306: fnd_message.set_token('CNT',lp_count);
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308:
309: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
310: fnd_message.set_token('CNT',lf_count);
311: fnd_file.put_line(fnd_file.log,fnd_message.get);
312:
313: EXCEPTION
314: WHEN invalid_version THEN

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

307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308:
309: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
310: fnd_message.set_token('CNT',lf_count);
311: fnd_file.put_line(fnd_file.log,fnd_message.get);
312:
313: EXCEPTION
314: WHEN invalid_version THEN
315: RAISE;

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

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');
325: fnd_message.set_token('NAME','igf_gr_mrr_load_data.load_ack');
326: igs_ge_msg_stack.add;
327: app_exception.raise_exception;
328:

Line 325: fnd_message.set_token('NAME','igf_gr_mrr_load_data.load_ack');

321: RAISE;
322:
323: WHEN OTHERS THEN
324: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
325: fnd_message.set_token('NAME','igf_gr_mrr_load_data.load_ack');
326: igs_ge_msg_stack.add;
327: app_exception.raise_exception;
328:
329: END load_ack;

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

386:
387: WHEN param_error THEN
388: ROLLBACK;
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;

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

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);
398:
399: WHEN igf_gr_gen.file_not_loaded THEN
400: ROLLBACK;

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

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);
404:
405: WHEN igf_gr_gen.no_file_version THEN
406: ROLLBACK;

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

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;
410:
411: WHEN others THEN
412:

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

411: WHEN others THEN
412:
413: ROLLBACK;
414: retcode := 2;
415: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
416: igs_ge_msg_stack.conc_exception_hndl;
417:
418:
419: END mrr_load_file;