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_RFMS_ORIG dependencies on FND_FILE

Line 262: fnd_file.new_line(fnd_file.log,1);

258: p_rfms_rec.total_pymt_prds IS NULL OR
259: p_rfms_rec.enrollment_status IS NULL OR
260: p_rfms_rec.enrollment_dt IS NULL
261: THEN
262: fnd_file.new_line(fnd_file.log,1);
263: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
264: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);

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

261: THEN
262: fnd_file.new_line(fnd_file.log,1);
263: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
264: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);

Line 266: fnd_file.new_line(fnd_file.log,1);

262: fnd_file.new_line(fnd_file.log,1);
263: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
264: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);

Line 267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);

263: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
264: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);

Line 268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);

264: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);

Line 269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);

265: fnd_file.put_line(fnd_file.log,fnd_message.get);
266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);

Line 270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);

266: fnd_file.new_line(fnd_file.log,1);
267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);

Line 271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);

267: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EFC'),50) || ' : ' ||p_rfms_rec.efc);
268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);

Line 272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);

268: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.pell_amount);
269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);

Line 273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);

269: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','FT_PELL_AMOUNT'),50) || ' : ' ||p_rfms_rec.ft_pell_amount);
270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '

Line 274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);

270: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TRANSACTION_NUM'),50) || ' : ' ||p_rfms_rec.transaction_num);
271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '
278: fnd_file.new_line(fnd_file.log,1);

Line 275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);

271: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ACADEMIC_CALENDAR'),50) || ' : ' ||p_rfms_rec.academic_calendar);
272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '
278: fnd_file.new_line(fnd_file.log,1);
279: ELSE

Line 276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);

272: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','PAYMENT_METHOD'),50) || ' : ' ||p_rfms_rec.payment_method);
273: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EST_DISB_DT1'),50) || ' : ' ||p_rfms_rec.est_disb_dt1);
274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '
278: fnd_file.new_line(fnd_file.log,1);
279: ELSE
280:

Line 278: fnd_file.new_line(fnd_file.log,1);

274: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TOTAL_PYMT_PRDS'),50) || ' : ' ||p_rfms_rec.total_pymt_prds);
275: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_STATUS'),50) || ' : ' ||p_rfms_rec.enrollment_status);
276: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ENROLLMENT_DT'),50) || ' : ' ||p_rfms_rec.enrollment_dt);
277: -- 'Data not sufficient to create Origination Record for Person '
278: fnd_file.new_line(fnd_file.log,1);
279: ELSE
280:
281: --Set the value for Printing Header Record as 'Y' only if its 'N'
282: --Bug 2460904

Line 374: fnd_file.put_line(fnd_file.output,UPPER(l_header)||RPAD(' ',200));

370: IF igf_gr_gen.send_orig_disb( p_rfms_rec.origination_id) THEN
371: --Print Header for the first time and reset value so that it does not get printed further
372: --Bug 2460904
373: IF g_print_header='Y' THEN
374: fnd_file.put_line(fnd_file.output,UPPER(l_header)||RPAD(' ',200));
375: g_print_header:='Z';
376: END IF;
377:
378: -- Since we are going to write the record to file, print log message if we had been set enrollment_status.

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

379: IF p_enrl_status_mesgnum = 1 THEN
380: -- default to 'Others'
381: fnd_message.set_name('IGF','IGF_GR_DEFAULT_ENRL_STAT');
382: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));
383: fnd_file.put_line(fnd_file.log,fnd_message.get);
384: ELSIF p_enrl_status_mesgnum = 2 THEN
385: -- set to pell attendance code.
386: fnd_message.set_name('IGF','IGF_GR_SET_ENRL_STAT');
387: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));

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

384: ELSIF p_enrl_status_mesgnum = 2 THEN
385: -- set to pell attendance code.
386: fnd_message.set_name('IGF','IGF_GR_SET_ENRL_STAT');
387: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));
388: fnd_file.put_line(fnd_file.log,fnd_message.get);
389: END IF;
390:
391: fnd_file.put_line(fnd_file.output,UPPER(l_data));
392: p_num_of_records := p_num_of_records + 1;

Line 391: fnd_file.put_line(fnd_file.output,UPPER(l_data));

387: fnd_message.set_token('EN_STAT',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT', p_rfms_rec.enrollment_status));
388: fnd_file.put_line(fnd_file.log,fnd_message.get);
389: END IF;
390:
391: fnd_file.put_line(fnd_file.output,UPPER(l_data));
392: p_num_of_records := p_num_of_records + 1;
393: p_originated :='Y';
394: update_orig_rec(p_rfms_rec,p_rfmb_id);
395: ELSE

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

395: ELSE
396: fnd_message.set_name('IGF','IGF_GR_VERF_STAT_W');
397: fnd_message.set_token('ORIG_ID',igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||
398: ' : ' || p_rfms_rec.origination_id );
399: fnd_file.put_line(fnd_file.log,fnd_message.get);
400: p_originated :='N';
401: END IF;
402: END IF;
403:

Line 447: fnd_file.put_line(fnd_file.log,' ');

443: RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
444: l_msg_str_1 := RPAD(p_batch_id,50) ||
445: RPAD(p_origination_id,50);
446:
447: fnd_file.put_line(fnd_file.log,' ');
448: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
449: fnd_file.put_line(fnd_file.log,fnd_message.get);
450: fnd_file.put_line(fnd_file.log,' ');
451: fnd_file.put_line(fnd_file.log,l_msg_str_0);

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

445: RPAD(p_origination_id,50);
446:
447: fnd_file.put_line(fnd_file.log,' ');
448: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
449: fnd_file.put_line(fnd_file.log,fnd_message.get);
450: fnd_file.put_line(fnd_file.log,' ');
451: fnd_file.put_line(fnd_file.log,l_msg_str_0);
452: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
453: fnd_file.put_line(fnd_file.log,l_msg_str_1);

Line 450: fnd_file.put_line(fnd_file.log,' ');

446:
447: fnd_file.put_line(fnd_file.log,' ');
448: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
449: fnd_file.put_line(fnd_file.log,fnd_message.get);
450: fnd_file.put_line(fnd_file.log,' ');
451: fnd_file.put_line(fnd_file.log,l_msg_str_0);
452: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
453: fnd_file.put_line(fnd_file.log,l_msg_str_1);
454:

Line 451: fnd_file.put_line(fnd_file.log,l_msg_str_0);

447: fnd_file.put_line(fnd_file.log,' ');
448: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
449: fnd_file.put_line(fnd_file.log,fnd_message.get);
450: fnd_file.put_line(fnd_file.log,' ');
451: fnd_file.put_line(fnd_file.log,l_msg_str_0);
452: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
453: fnd_file.put_line(fnd_file.log,l_msg_str_1);
454:
455:

Line 452: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));

448: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
449: fnd_file.put_line(fnd_file.log,fnd_message.get);
450: fnd_file.put_line(fnd_file.log,' ');
451: fnd_file.put_line(fnd_file.log,l_msg_str_0);
452: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
453: fnd_file.put_line(fnd_file.log,l_msg_str_1);
454:
455:
456: EXCEPTION

Line 453: fnd_file.put_line(fnd_file.log,l_msg_str_1);

449: fnd_file.put_line(fnd_file.log,fnd_message.get);
450: fnd_file.put_line(fnd_file.log,' ');
451: fnd_file.put_line(fnd_file.log,l_msg_str_0);
452: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
453: fnd_file.put_line(fnd_file.log,l_msg_str_1);
454:
455:
456: EXCEPTION
457: WHEN others THEN

Line 495: fnd_file.put_line(fnd_file.output,fnd_message.get);

491: l_msg_str_1 := RPAD(p_origination_id,50);
492:
493: IF l_msg_prn_1 = TRUE THEN
494: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
495: fnd_file.put_line(fnd_file.output,fnd_message.get);
496: fnd_file.put_line(fnd_file.output,'');
497: fnd_file.put_line(fnd_file.output,l_msg_str_0);
498: fnd_file.put_line(fnd_file.output,RPAD('-',50,'-'));
499: l_msg_prn_1 := FALSE;

Line 496: fnd_file.put_line(fnd_file.output,'');

492:
493: IF l_msg_prn_1 = TRUE THEN
494: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
495: fnd_file.put_line(fnd_file.output,fnd_message.get);
496: fnd_file.put_line(fnd_file.output,'');
497: fnd_file.put_line(fnd_file.output,l_msg_str_0);
498: fnd_file.put_line(fnd_file.output,RPAD('-',50,'-'));
499: l_msg_prn_1 := FALSE;
500: END IF;

Line 497: fnd_file.put_line(fnd_file.output,l_msg_str_0);

493: IF l_msg_prn_1 = TRUE THEN
494: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
495: fnd_file.put_line(fnd_file.output,fnd_message.get);
496: fnd_file.put_line(fnd_file.output,'');
497: fnd_file.put_line(fnd_file.output,l_msg_str_0);
498: fnd_file.put_line(fnd_file.output,RPAD('-',50,'-'));
499: l_msg_prn_1 := FALSE;
500: END IF;
501: fnd_file.put_line(fnd_file.output,l_msg_str_1);

Line 498: fnd_file.put_line(fnd_file.output,RPAD('-',50,'-'));

494: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
495: fnd_file.put_line(fnd_file.output,fnd_message.get);
496: fnd_file.put_line(fnd_file.output,'');
497: fnd_file.put_line(fnd_file.output,l_msg_str_0);
498: fnd_file.put_line(fnd_file.output,RPAD('-',50,'-'));
499: l_msg_prn_1 := FALSE;
500: END IF;
501: fnd_file.put_line(fnd_file.output,l_msg_str_1);
502:

Line 501: fnd_file.put_line(fnd_file.output,l_msg_str_1);

497: fnd_file.put_line(fnd_file.output,l_msg_str_0);
498: fnd_file.put_line(fnd_file.output,RPAD('-',50,'-'));
499: l_msg_prn_1 := FALSE;
500: END IF;
501: fnd_file.put_line(fnd_file.output,l_msg_str_1);
502:
503:
504: EXCEPTION
505: WHEN others THEN

Line 546: fnd_file.put_line(fnd_file.log,'');

542: l_msg_desc VARCHAR2(4000) DEFAULT NULL;
543:
544: BEGIN
545:
546: fnd_file.put_line(fnd_file.log,'');
547: IF NVL(TO_NUMBER(RTRIM(LTRIM(p_orig_reject_code))),0) > 0 THEN
548: fnd_message.set_name('IGF','IGF_GR_REC_CONTAIN_EDIT_CODES');
549: fnd_file.put_line(fnd_file.log,fnd_message.get);
550:

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

545:
546: fnd_file.put_line(fnd_file.log,'');
547: IF NVL(TO_NUMBER(RTRIM(LTRIM(p_orig_reject_code))),0) > 0 THEN
548: fnd_message.set_name('IGF','IGF_GR_REC_CONTAIN_EDIT_CODES');
549: fnd_file.put_line(fnd_file.log,fnd_message.get);
550:
551: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
552: l_msg_str_1 := RPAD(p_origination_id,50);
553: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIG_REJECT_CODE'),50);

Line 555: fnd_file.put_line(fnd_file.log,' ');

551: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
552: l_msg_str_1 := RPAD(p_origination_id,50);
553: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIG_REJECT_CODE'),50);
554:
555: fnd_file.put_line(fnd_file.log,' ');
556: fnd_file.put_line(fnd_file.log,l_msg_str_0);
557: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
558: fnd_file.put_line(fnd_file.log,l_msg_str_1);
559: fnd_file.put_line(fnd_file.log,l_msg_str_2);

Line 556: fnd_file.put_line(fnd_file.log,l_msg_str_0);

552: l_msg_str_1 := RPAD(p_origination_id,50);
553: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIG_REJECT_CODE'),50);
554:
555: fnd_file.put_line(fnd_file.log,' ');
556: fnd_file.put_line(fnd_file.log,l_msg_str_0);
557: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
558: fnd_file.put_line(fnd_file.log,l_msg_str_1);
559: fnd_file.put_line(fnd_file.log,l_msg_str_2);
560: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));

Line 557: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));

553: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIG_REJECT_CODE'),50);
554:
555: fnd_file.put_line(fnd_file.log,' ');
556: fnd_file.put_line(fnd_file.log,l_msg_str_0);
557: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
558: fnd_file.put_line(fnd_file.log,l_msg_str_1);
559: fnd_file.put_line(fnd_file.log,l_msg_str_2);
560: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
561:

Line 558: fnd_file.put_line(fnd_file.log,l_msg_str_1);

554:
555: fnd_file.put_line(fnd_file.log,' ');
556: fnd_file.put_line(fnd_file.log,l_msg_str_0);
557: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
558: fnd_file.put_line(fnd_file.log,l_msg_str_1);
559: fnd_file.put_line(fnd_file.log,l_msg_str_2);
560: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
561:
562: FOR l_cn IN 1 .. 25 LOOP

Line 559: fnd_file.put_line(fnd_file.log,l_msg_str_2);

555: fnd_file.put_line(fnd_file.log,' ');
556: fnd_file.put_line(fnd_file.log,l_msg_str_0);
557: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
558: fnd_file.put_line(fnd_file.log,l_msg_str_1);
559: fnd_file.put_line(fnd_file.log,l_msg_str_2);
560: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
561:
562: FOR l_cn IN 1 .. 25 LOOP
563:

Line 560: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));

556: fnd_file.put_line(fnd_file.log,l_msg_str_0);
557: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
558: fnd_file.put_line(fnd_file.log,l_msg_str_1);
559: fnd_file.put_line(fnd_file.log,l_msg_str_2);
560: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
561:
562: FOR l_cn IN 1 .. 25 LOOP
563:
564: l_error_code := NVL(SUBSTR(p_orig_reject_code,l_count,3),'000');

Line 567: fnd_file.put_line(fnd_file.log,l_msg_str_3);

563:
564: l_error_code := NVL(SUBSTR(p_orig_reject_code,l_count,3),'000');
565: IF l_error_code <> '000' THEN
566: l_msg_str_3 := RPAD(l_error_code,5);
567: fnd_file.put_line(fnd_file.log,l_msg_str_3);
568: END IF;
569: l_count := l_count + 3;
570: END LOOP;
571: END IF;

Line 760: fnd_file.new_line(fnd_file.log,1);

756: p_ci_cal_type,
757: p_ci_sequence_number
758: );
759:
760: fnd_file.new_line(fnd_file.log,1);
761: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'
762: ||' '|| l_batch_id);
763:
764: fnd_file.new_line(fnd_file.log,1);

Line 761: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'

757: p_ci_sequence_number
758: );
759:
760: fnd_file.new_line(fnd_file.log,1);
761: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'
762: ||' '|| l_batch_id);
763:
764: fnd_file.new_line(fnd_file.log,1);
765: fnd_message.set_name('IGF','IGF_GR_ORIG_RECORDS');

Line 764: fnd_file.new_line(fnd_file.log,1);

760: fnd_file.new_line(fnd_file.log,1);
761: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'
762: ||' '|| l_batch_id);
763:
764: fnd_file.new_line(fnd_file.log,1);
765: fnd_message.set_name('IGF','IGF_GR_ORIG_RECORDS');
766: fnd_file.put_line(fnd_file.log,fnd_message.get);
767:
768: l_amount_total := 0;

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

762: ||' '|| l_batch_id);
763:
764: fnd_file.new_line(fnd_file.log,1);
765: fnd_message.set_name('IGF','IGF_GR_ORIG_RECORDS');
766: fnd_file.put_line(fnd_file.log,fnd_message.get);
767:
768: l_amount_total := 0;
769: l_num_of_rec := 0;
770:

Line 806: fnd_file.new_line(fnd_file.log,1);

802: END IF;
803: END IF;
804:
805: IF (lv_persid_flag) THEN -- Is person-id in person-group or not ?
806: fnd_file.new_line(fnd_file.log,1);
807: fnd_message.set_name('IGF','IGF_GR_PROCESS_STUD');
808: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(rfms_rec.base_id));
809: fnd_message.set_token('ORIG_ID',rfms_rec.origination_id);
810: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

806: fnd_file.new_line(fnd_file.log,1);
807: fnd_message.set_name('IGF','IGF_GR_PROCESS_STUD');
808: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(rfms_rec.base_id));
809: fnd_message.set_token('ORIG_ID',rfms_rec.origination_id);
810: fnd_file.put_line(fnd_file.log,fnd_message.get);
811:
812: -- check if attending pell is a child of reporting pell id.
813: l_attending_pell_exists := NULL;
814: OPEN cur_attending_pell(rfms_rec.ci_cal_type,

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

821: -- No attending pell child record exists. Skip this record
822: CLOSE cur_attending_pell;
823: FND_MESSAGE.SET_NAME('IGF','IGF_GR_ATTEND_PELL_NOT_SETUP');
824: FND_MESSAGE.SET_TOKEN('ATT_PELL','');
825: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
826: ELSE
827: -- attending pell child record exists. Proceed further...
828: CLOSE cur_attending_pell;
829:

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

884: CLOSE cur_pymnt_isir;
885:
886: IF NOT l_isir_present THEN
887: fnd_message.set_name('IGF','IGF_AP_NO_PAYMENT_ISIR');
888: fnd_file.put_line(fnd_file.log,fnd_message.get);
889:
890: -- If the Transaction Number being reported does not match do not Originate
891: ELSIF rfms_rec.transaction_num <> NVL(cur_pymnt_isir_rec.transaction_num,-1) THEN
892: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');

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

889:
890: -- If the Transaction Number being reported does not match do not Originate
891: ELSIF rfms_rec.transaction_num <> NVL(cur_pymnt_isir_rec.transaction_num,-1) THEN
892: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');
893: fnd_file.put_line(fnd_file.log,fnd_message.get);
894:
895: ELSE
896:
897: -- Get disbursements amounts total

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

905: fnd_message.set_name('IGF','IGF_GR_PELL_DIFF_AMTS');
906: FND_MESSAGE.SET_TOKEN('DISB_AMT', TO_CHAR(rec_disb_amt_tot.disb_amt_tot));
907: FND_MESSAGE.SET_TOKEN('PELL_TOT', TO_CHAR(rfms_rec.pell_amount));
908:
909: fnd_file.put_line(fnd_file.log,fnd_message.get);
910: ELSE
911:
912: l_awd_disb_tot := NULL;
913: OPEN c_awd_disb_tot(rfms_rec.award_id);

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

918: --put messages here
919: fnd_message.set_name('IGF','IGF_GR_PELL_AWD_DIFF_AMT');
920: fnd_message.set_token('RFMS_DISB_TOT',TO_CHAR(rec_disb_amt_tot.disb_amt_tot));
921: fnd_message.set_token('AWD_DISB_TOT',TO_CHAR(NVL(l_awd_disb_tot.pell_award,0)));
922: fnd_file.put_line(fnd_file.log,fnd_message.get);
923:
924: ELSE
925:
926: -- Calculate Pell amount and Full time Pell amount

Line 937: fnd_file.put_line(fnd_file.log,l_return_mesg_text);

933: cp_return_status => l_return_status,
934: cp_message => l_return_mesg_text
935: );
936: IF (l_return_status = 'E') THEN
937: fnd_file.put_line(fnd_file.log,l_return_mesg_text);
938: ELSE
939: IF l_pell_amt > l_ft_pell_amt THEN
940: fnd_message.set_name('IGF','IGF_GR_LIMIT_EXC');
941: fnd_message.set_token('PEL_AMT',l_ft_pell_amt);

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

939: IF l_pell_amt > l_ft_pell_amt THEN
940: fnd_message.set_name('IGF','IGF_GR_LIMIT_EXC');
941: fnd_message.set_token('PEL_AMT',l_ft_pell_amt);
942: fnd_message.set_token('AWD_AMT',rfms_rec.pell_amount);
943: fnd_file.put_line(fnd_file.log,fnd_message.get);
944: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
945: fnd_file.put_line(fnd_file.log,fnd_message.get);
946: ELSE
947: rfms_rec.pell_amount := l_pell_amt;

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

941: fnd_message.set_token('PEL_AMT',l_ft_pell_amt);
942: fnd_message.set_token('AWD_AMT',rfms_rec.pell_amount);
943: fnd_file.put_line(fnd_file.log,fnd_message.get);
944: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
945: fnd_file.put_line(fnd_file.log,fnd_message.get);
946: ELSE
947: rfms_rec.pell_amount := l_pell_amt;
948: rfms_rec.ft_pell_amount := l_ft_pell_amt;
949: IF (p_orig_run_mode = 'MAX_PELL') THEN

Line 988: fnd_file.new_line(fnd_file.log,1);

984: '#O',
985: l_num_of_rec,
986: l_amount_total,
987: l_batch_id);
988: fnd_file.new_line(fnd_file.log,1);
989: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
990: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
991: fnd_file.put_line(fnd_file.log,fnd_message.get);
992: -- p_num_of_rec || ' records written into data file

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

987: l_batch_id);
988: fnd_file.new_line(fnd_file.log,1);
989: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
990: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
991: fnd_file.put_line(fnd_file.log,fnd_message.get);
992: -- p_num_of_rec || ' records written into data file
993: fnd_file.new_line(fnd_file.log,1);
994:
995: IF l_num_of_rec > 0 THEN

Line 993: fnd_file.new_line(fnd_file.log,1);

989: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
990: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
991: fnd_file.put_line(fnd_file.log,fnd_message.get);
992: -- p_num_of_rec || ' records written into data file
993: fnd_file.new_line(fnd_file.log,1);
994:
995: IF l_num_of_rec > 0 THEN
996: fnd_file.put_line(fnd_file.output,UPPER(l_trailer)||RPAD(' ',200));
997: ELSE

Line 996: fnd_file.put_line(fnd_file.output,UPPER(l_trailer)||RPAD(' ',200));

992: -- p_num_of_rec || ' records written into data file
993: fnd_file.new_line(fnd_file.log,1);
994:
995: IF l_num_of_rec > 0 THEN
996: fnd_file.put_line(fnd_file.output,UPPER(l_trailer)||RPAD(' ',200));
997: ELSE
998: RAISE batch_not_created;
999: END IF;
1000:

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

1085: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));
1086: fnd_message.set_token('BATCH',l_batch_id);
1087: fnd_message.set_token('VRSN',g_ver_num);
1088: fnd_message.set_token('AWD_YR',g_alt_code);
1089: fnd_file.put_line(fnd_file.log,fnd_message.get);
1090: RAISE invalid_version;
1091: END IF;
1092:
1093: IF l_number_rec > 0 THEN

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

1150:
1151: fnd_message.set_name('IGF','IGF_GR_ORIG_BATCH_MISMATCH');
1152: fnd_message.set_token('BATCH_ID',l_batch_id);
1153: fnd_message.set_token('ORIG_ID',LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));
1154: fnd_file.put_line(fnd_file.log,fnd_message.get);
1155: fnd_file.new_line(fnd_file.log,1);
1156:
1157: RAISE igf_gr_gen.skip_this_record;
1158: END IF;

Line 1155: fnd_file.new_line(fnd_file.log,1);

1151: fnd_message.set_name('IGF','IGF_GR_ORIG_BATCH_MISMATCH');
1152: fnd_message.set_token('BATCH_ID',l_batch_id);
1153: fnd_message.set_token('ORIG_ID',LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));
1154: fnd_file.put_line(fnd_file.log,fnd_message.get);
1155: fnd_file.new_line(fnd_file.log,1);
1156:
1157: RAISE igf_gr_gen.skip_this_record;
1158: END IF;
1159: --Record should be in "Sent" status for acknowledgment processing"

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

1162: fnd_message.set_name('IGF','IGF_GR_ORIG_NOT_IN_SENT');
1163: fnd_message.set_token('ORIG_ID',LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));
1164: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',get_pell_rec.orig_action_code);
1165: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS);
1166: fnd_file.put_line(fnd_file.log,fnd_message.get);
1167: fnd_file.new_line(fnd_file.log,1);
1168: RAISE igf_gr_gen.skip_this_record;
1169: END IF;
1170:

Line 1167: fnd_file.new_line(fnd_file.log,1);

1163: fnd_message.set_token('ORIG_ID',LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));
1164: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',get_pell_rec.orig_action_code);
1165: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS);
1166: fnd_file.put_line(fnd_file.log,fnd_message.get);
1167: fnd_file.new_line(fnd_file.log,1);
1168: RAISE igf_gr_gen.skip_this_record;
1169: END IF;
1170:
1171: ----end Bug #2938258

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

1231: WHEN OTHERS THEN
1232: lf_count := lf_count + 1;
1233: fnd_message.set_name('IGF','IGF_GR_INVALID_RECORD');
1234: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1235: fnd_file.put_line(fnd_file.log,fnd_message.get);
1236:
1237: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1238: fnd_file.put_line(fnd_file.log,fnd_message.get);
1239: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data

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

1234: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1235: fnd_file.put_line(fnd_file.log,fnd_message.get);
1236:
1237: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1238: fnd_file.put_line(fnd_file.log,fnd_message.get);
1239: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
1240: fnd_file.put_line(fnd_file.log, ' ' );
1241:
1242: RAISE igf_gr_gen.skip_this_record;

Line 1240: fnd_file.put_line(fnd_file.log, ' ' );

1236:
1237: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1238: fnd_file.put_line(fnd_file.log,fnd_message.get);
1239: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
1240: fnd_file.put_line(fnd_file.log, ' ' );
1241:
1242: RAISE igf_gr_gen.skip_this_record;
1243:
1244: END;

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

1252: igf_gr_gen.insert_sys_holds(get_pell_rec.award_id,NULL,'PELL');
1253: fnd_message.set_name('IGF','IGF_GR_DIFF_PELL_AMT');
1254: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1255: -- The Reported and Received Pell Award Amount for this Origination Record are different
1256: fnd_file.put_line(fnd_file.log,fnd_message.get);
1257:
1258: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1259: fnd_message.set_token('AMT', TO_CHAR(get_pell_rec.pell_amount));
1260: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1256: fnd_file.put_line(fnd_file.log,fnd_message.get);
1257:
1258: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1259: fnd_message.set_token('AMT', TO_CHAR(get_pell_rec.pell_amount));
1260: fnd_file.put_line(fnd_file.log,fnd_message.get);
1261:
1262: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1263: fnd_message.set_token('AMT', TO_CHAR(ln_pell_awd));
1264: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1260: fnd_file.put_line(fnd_file.log,fnd_message.get);
1261:
1262: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1263: fnd_message.set_token('AMT', TO_CHAR(ln_pell_awd));
1264: fnd_file.put_line(fnd_file.log,fnd_message.get);
1265: fnd_file.new_line(fnd_file.log,1);
1266:
1267: --
1268: -- print both amounts fnd_message.set_name('IGF','IGF_

Line 1265: fnd_file.new_line(fnd_file.log,1);

1261:
1262: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1263: fnd_message.set_token('AMT', TO_CHAR(ln_pell_awd));
1264: fnd_file.put_line(fnd_file.log,fnd_message.get);
1265: fnd_file.new_line(fnd_file.log,1);
1266:
1267: --
1268: -- print both amounts fnd_message.set_name('IGF','IGF_
1269: --

Line 1358: fnd_file.new_line(fnd_file.log,2);

1354: RAISE igf_gr_gen.file_not_loaded;
1355: END IF;
1356: END; -- Inner Begin
1357:
1358: fnd_file.new_line(fnd_file.log,2);
1359: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
1360: fnd_message.set_token('CNT',l_number_rec);
1361: fnd_file.put_line(fnd_file.log,fnd_message.get);
1362:

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

1357:
1358: fnd_file.new_line(fnd_file.log,2);
1359: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
1360: fnd_message.set_token('CNT',l_number_rec);
1361: fnd_file.put_line(fnd_file.log,fnd_message.get);
1362:
1363: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1364: fnd_message.set_token('CNT',lp_count);
1365: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1361: fnd_file.put_line(fnd_file.log,fnd_message.get);
1362:
1363: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1364: fnd_message.set_token('CNT',lp_count);
1365: fnd_file.put_line(fnd_file.log,fnd_message.get);
1366:
1367: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1368: fnd_message.set_token('CNT',lf_count);
1369: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1365: fnd_file.put_line(fnd_file.log,fnd_message.get);
1366:
1367: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1368: fnd_message.set_token('CNT',lf_count);
1369: fnd_file.put_line(fnd_file.log,fnd_message.get);
1370:
1371: END IF; -- if l_num_rec
1372:
1373: EXCEPTION

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

1474: -- and stop processing else continue the process
1475: IF l_cod_year_flag THEN
1476:
1477: fnd_message.set_name('IGF','IGF_GR_COD_NO_ORIG');
1478: fnd_file.put_line(fnd_file.log,fnd_message.get);
1479: RETURN;
1480:
1481: END IF;
1482:

Line 1486: fnd_file.put_line(fnd_file.log,l_msg_str_1);

1482:
1483: -- show parameter 1 - award year
1484: l_msg_str_1 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','AWARD_YEAR'),30) ||
1485: RPAD(igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number),20);
1486: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1487:
1488: -- show parameter 2 - report pell id
1489: l_msg_str_3 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'REPORT_PELL'),30) || p_reporting_pell;
1490: fnd_file.put_line(fnd_file.log,l_msg_str_3);

Line 1490: fnd_file.put_line(fnd_file.log,l_msg_str_3);

1486: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1487:
1488: -- show parameter 2 - report pell id
1489: l_msg_str_3 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'REPORT_PELL'),30) || p_reporting_pell;
1490: fnd_file.put_line(fnd_file.log,l_msg_str_3);
1491:
1492: -- show parameter 3 - attend pell id
1493: IF (p_attending_pell IS NOT NULL) THEN
1494: l_msg_str_4 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'ATTEND_PELL'),30) || p_attending_pell;

Line 1495: fnd_file.put_line(fnd_file.log,l_msg_str_4);

1491:
1492: -- show parameter 3 - attend pell id
1493: IF (p_attending_pell IS NOT NULL) THEN
1494: l_msg_str_4 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'ATTEND_PELL'),30) || p_attending_pell;
1495: fnd_file.put_line(fnd_file.log,l_msg_str_4);
1496: END IF;
1497:
1498: -- show parameter 4 - base id
1499: IF (base_id IS NOT NULL) THEN

Line 1502: fnd_file.put_line(fnd_file.log,l_msg_str_2);

1498: -- show parameter 4 - base id
1499: IF (base_id IS NOT NULL) THEN
1500: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BASE_ID'),30) ||
1501: RPAD(igf_gr_gen.get_per_num(ln_base_id),20);
1502: fnd_file.put_line(fnd_file.log,l_msg_str_2);
1503: END IF;
1504:
1505: -- show parameter 5 - Person Id Group
1506: IF (p_persid_grp IS NOT NULL) THEN

Line 1511: fnd_file.put_line(fnd_file.log,l_msg_str_5);

1507: OPEN cur_person_group(p_persid_grp);
1508: FETCH cur_person_group INTO rec_person_group;
1509: CLOSE cur_person_group;
1510: l_msg_str_5 := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS', 'PERSON_ID_GROUP'),30) || rec_person_group.group_name;
1511: fnd_file.put_line(fnd_file.log,l_msg_str_5);
1512: END IF;
1513:
1514: -- show parameter 6 - Orgination Run Mode
1515: l_msg_str_6 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'PELL_ORIG_RUN_MODE'),30) || p_orig_run_mode;

Line 1516: fnd_file.put_line(fnd_file.log,l_msg_str_6);

1512: END IF;
1513:
1514: -- show parameter 6 - Orgination Run Mode
1515: l_msg_str_6 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'PELL_ORIG_RUN_MODE'),30) || p_orig_run_mode;
1516: fnd_file.put_line(fnd_file.log,l_msg_str_6);
1517:
1518: -- FA 126. base_id and attending pell are mutually exclusive.
1519: IF (base_id IS NOT NULL AND p_attending_pell IS NOT NULL) THEN
1520: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_PORIG_INCOMPAT');

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

1517:
1518: -- FA 126. base_id and attending pell are mutually exclusive.
1519: IF (base_id IS NOT NULL AND p_attending_pell IS NOT NULL) THEN
1520: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_PORIG_INCOMPAT');
1521: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1522: mutually_exclusive := FALSE;
1523: END IF;
1524:
1525: -- FA 131. Person Number(base_id) and Person Group are mutually exclusive.

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

1524:
1525: -- FA 131. Person Number(base_id) and Person Group are mutually exclusive.
1526: IF (base_id IS NOT NULL AND p_persid_grp IS NOT NULL) THEN
1527: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_PERSID_GRP_INCOMPAT');
1528: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1529: mutually_exclusive := FALSE;
1530: END IF;
1531:
1532: IF NOT mutually_exclusive THEN

Line 1563: fnd_file.put_line(fnd_file.log,errbuf);

1559: WHEN igf_gr_gen.no_file_version THEN
1560: ROLLBACK;
1561: retcode := 2;
1562: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
1563: fnd_file.put_line(fnd_file.log,errbuf);
1564: WHEN batch_not_created THEN
1565: ROLLBACK;
1566: WHEN param_error THEN
1567: ROLLBACK;

Line 1570: fnd_file.put_line(fnd_file.log,errbuf);

1566: WHEN param_error THEN
1567: ROLLBACK;
1568: retcode := 2;
1569: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
1570: fnd_file.put_line(fnd_file.log,errbuf);
1571: WHEN no_data_in_table THEN
1572: ROLLBACK;
1573: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');
1574: fnd_file.put_line(fnd_file.log,errbuf);

Line 1574: fnd_file.put_line(fnd_file.log,errbuf);

1570: fnd_file.put_line(fnd_file.log,errbuf);
1571: WHEN no_data_in_table THEN
1572: ROLLBACK;
1573: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');
1574: fnd_file.put_line(fnd_file.log,errbuf);
1575: WHEN app_exception.record_lock_exception THEN
1576: ROLLBACK;
1577: retcode:=2;
1578: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

Line 1579: fnd_file.put_line(fnd_file.log,errbuf);

1575: WHEN app_exception.record_lock_exception THEN
1576: ROLLBACK;
1577: retcode:=2;
1578: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
1579: fnd_file.put_line(fnd_file.log,errbuf);
1580: WHEN persid_grp_sql_stmt_error THEN
1581: ROLLBACK;
1582: retcode := 2;
1583: errbuf := fnd_message.get_string('IGF','IGF_AP_INVALID_QUERY');

Line 1584: fnd_file.put_line(fnd_file.log,errbuf);

1580: WHEN persid_grp_sql_stmt_error THEN
1581: ROLLBACK;
1582: retcode := 2;
1583: errbuf := fnd_message.get_string('IGF','IGF_AP_INVALID_QUERY');
1584: fnd_file.put_line(fnd_file.log,errbuf);
1585: WHEN OTHERS THEN
1586: ROLLBACK;
1587: retcode := 2;
1588: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || SQLERRM;

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

1635: -- and stop processing else continue the process
1636: IF igf_sl_dl_validation.check_full_participant (l_ci_cal_type,l_ci_sequence_number,'PELL') THEN
1637:
1638: fnd_message.set_name('IGF','IGF_GR_COD_NO_ORIG_ACK');
1639: fnd_file.put_line(fnd_file.log,fnd_message.get);
1640: RETURN;
1641:
1642: END IF;
1643:

Line 1672: fnd_file.put_line(fnd_file.log,errbuf);

1668: WHEN igf_gr_gen.no_file_version THEN
1669: ROLLBACK;
1670: retcode := 2;
1671: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
1672: fnd_file.put_line(fnd_file.log,errbuf);
1673:
1674: WHEN app_exception.record_lock_exception THEN
1675: ROLLBACK;
1676: retcode := 2;

Line 1678: fnd_file.put_line(fnd_file.log,errbuf);

1674: WHEN app_exception.record_lock_exception THEN
1675: ROLLBACK;
1676: retcode := 2;
1677: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
1678: fnd_file.put_line(fnd_file.log,errbuf);
1679:
1680: WHEN param_error THEN
1681: ROLLBACK;
1682: retcode := 2;

Line 1684: fnd_file.put_line(fnd_file.log,errbuf);

1680: WHEN param_error THEN
1681: ROLLBACK;
1682: retcode := 2;
1683: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
1684: fnd_file.put_line(fnd_file.log,errbuf);
1685:
1686: WHEN igf_gr_gen.file_not_loaded THEN
1687: ROLLBACK;
1688: retcode := 2;

Line 1690: fnd_file.put_line(fnd_file.log,errbuf);

1686: WHEN igf_gr_gen.file_not_loaded THEN
1687: ROLLBACK;
1688: retcode := 2;
1689: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
1690: fnd_file.put_line(fnd_file.log,errbuf);
1691:
1692: WHEN no_data_in_table THEN
1693: ROLLBACK;
1694: retcode := 2;

Line 1696: fnd_file.put_line(fnd_file.log,errbuf);

1692: WHEN no_data_in_table THEN
1693: ROLLBACK;
1694: retcode := 2;
1695: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');
1696: fnd_file.put_line(fnd_file.log,errbuf);
1697:
1698: WHEN igf_gr_gen.batch_not_in_system THEN
1699: ROLLBACK;
1700: retcode := 2;

Line 1702: fnd_file.put_line(fnd_file.log,errbuf);

1698: WHEN igf_gr_gen.batch_not_in_system THEN
1699: ROLLBACK;
1700: retcode := 2;
1701: errbuf := fnd_message.get; -- Bug # 4008991
1702: fnd_file.put_line(fnd_file.log,errbuf);
1703:
1704: WHEN igf_gr_gen.corrupt_data_file THEN
1705: ROLLBACK;
1706: retcode := 2;

Line 1708: fnd_file.put_line(fnd_file.log,errbuf);

1704: WHEN igf_gr_gen.corrupt_data_file THEN
1705: ROLLBACK;
1706: retcode := 2;
1707: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
1708: fnd_file.put_line(fnd_file.log,errbuf);
1709:
1710: WHEN OTHERS THEN
1711: ROLLBACK;
1712: retcode := 2;