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

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

223: --
224: IF p_rfms_rec.disb_ref_num IS NULL OR
225: p_rfms_rec.db_cr_flag IS NULL OR
226: p_rfms_rec.disb_amt IS NULL THEN
227: fnd_file.new_line(fnd_file.log,1);
228: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);

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

226: p_rfms_rec.disb_amt IS NULL THEN
227: fnd_file.new_line(fnd_file.log,1);
228: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);
232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);
233: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_AMT'),50) || ' : ' ||p_rfms_rec.disb_amt);
234: fnd_file.new_line(fnd_file.log,1);

Line 231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);

227: fnd_file.new_line(fnd_file.log,1);
228: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);
232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);
233: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_AMT'),50) || ' : ' ||p_rfms_rec.disb_amt);
234: fnd_file.new_line(fnd_file.log,1);
235: ELSE

Line 232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);

228: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);
232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);
233: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_AMT'),50) || ' : ' ||p_rfms_rec.disb_amt);
234: fnd_file.new_line(fnd_file.log,1);
235: ELSE
236: IF g_ver_num IN ('2002-2003','2003-2004','2004-2005') THEN

Line 233: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_AMT'),50) || ' : ' ||p_rfms_rec.disb_amt);

229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);
232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);
233: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_AMT'),50) || ' : ' ||p_rfms_rec.disb_amt);
234: fnd_file.new_line(fnd_file.log,1);
235: ELSE
236: IF g_ver_num IN ('2002-2003','2003-2004','2004-2005') THEN
237: l_data := RPAD(p_rfms_rec.origination_id,23) ||

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

230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);
232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);
233: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_AMT'),50) || ' : ' ||p_rfms_rec.disb_amt);
234: fnd_file.new_line(fnd_file.log,1);
235: ELSE
236: IF g_ver_num IN ('2002-2003','2003-2004','2004-2005') THEN
237: l_data := RPAD(p_rfms_rec.origination_id,23) ||
238: RPAD(NVL(p_rfms_rec.inst_cross_ref_cd,' '),13) ||

Line 261: fnd_file.put_line(fnd_file.output, UPPER(g_header));

257: NVL(igf_gr_gen.get_min_pell_disb ( p_rfms_rec.origination_id ),0) THEN
258: IF igf_gr_gen.send_orig_disb( p_rfms_rec.origination_id) THEN
259:
260: IF (g_header_written = 'N') THEN
261: fnd_file.put_line(fnd_file.output, UPPER(g_header));
262: g_header_written := 'Y';
263: END IF;
264:
265: fnd_file.put_line(fnd_file.output,UPPER(l_data));

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

261: fnd_file.put_line(fnd_file.output, UPPER(g_header));
262: g_header_written := 'Y';
263: END IF;
264:
265: fnd_file.put_line(fnd_file.output,UPPER(l_data));
266: upd_rfms_disb(p_rfms_rec,p_rfmb_id);
267: p_num_of_records := p_num_of_records + 1;
268:
269: ELSE

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

273: ' : ' || p_rfms_rec.origination_id ||
274: ' , ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||
275: ' : ' || p_rfms_rec.disb_ref_num);
276:
277: fnd_file.put_line(fnd_file.log,fnd_message.get);
278: END IF;
279: ELSE
280:
281: IF (g_header_written = 'N') THEN

Line 282: fnd_file.put_line(fnd_file.output, UPPER(g_header));

278: END IF;
279: ELSE
280:
281: IF (g_header_written = 'N') THEN
282: fnd_file.put_line(fnd_file.output, UPPER(g_header));
283: g_header_written := 'Y';
284: END IF;
285:
286: fnd_file.put_line(fnd_file.output,UPPER(l_data));

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

282: fnd_file.put_line(fnd_file.output, UPPER(g_header));
283: g_header_written := 'Y';
284: END IF;
285:
286: fnd_file.put_line(fnd_file.output,UPPER(l_data));
287: upd_rfms_disb(p_rfms_rec,p_rfmb_id);
288: p_num_of_records := p_num_of_records + 1;
289:
290: END IF;

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

335: RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50);
336: l_msg_str_1 := RPAD(p_batch_id,50) ||
337: RPAD(p_origination_id,50);
338:
339: fnd_file.put_line(fnd_file.log,'');
340: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
341: fnd_file.put_line(fnd_file.log,fnd_message.get);
342: fnd_file.put_line(fnd_file.log,' ');
343: fnd_file.put_line(fnd_file.log,l_msg_str_0);

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

337: RPAD(p_origination_id,50);
338:
339: fnd_file.put_line(fnd_file.log,'');
340: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
341: fnd_file.put_line(fnd_file.log,fnd_message.get);
342: fnd_file.put_line(fnd_file.log,' ');
343: fnd_file.put_line(fnd_file.log,l_msg_str_0);
344: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
345:

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

338:
339: fnd_file.put_line(fnd_file.log,'');
340: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
341: fnd_file.put_line(fnd_file.log,fnd_message.get);
342: fnd_file.put_line(fnd_file.log,' ');
343: fnd_file.put_line(fnd_file.log,l_msg_str_0);
344: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
345:
346: fnd_file.put_line(fnd_file.log,l_msg_str_1);

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

339: fnd_file.put_line(fnd_file.log,'');
340: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
341: fnd_file.put_line(fnd_file.log,fnd_message.get);
342: fnd_file.put_line(fnd_file.log,' ');
343: fnd_file.put_line(fnd_file.log,l_msg_str_0);
344: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
345:
346: fnd_file.put_line(fnd_file.log,l_msg_str_1);
347:

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

340: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
341: fnd_file.put_line(fnd_file.log,fnd_message.get);
342: fnd_file.put_line(fnd_file.log,' ');
343: fnd_file.put_line(fnd_file.log,l_msg_str_0);
344: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
345:
346: fnd_file.put_line(fnd_file.log,l_msg_str_1);
347:
348:

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

342: fnd_file.put_line(fnd_file.log,' ');
343: fnd_file.put_line(fnd_file.log,l_msg_str_0);
344: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
345:
346: fnd_file.put_line(fnd_file.log,l_msg_str_1);
347:
348:
349: EXCEPTION
350: WHEN others THEN

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

384: RPAD(p_disb_ref_num,30);
385:
386: IF l_msg_prn_1 = TRUE THEN
387: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
388: fnd_file.put_line(fnd_file.output,fnd_message.get);
389: fnd_file.new_line(fnd_file.output,1);
390: fnd_file.put_line(fnd_file.output,l_msg_str_0);
391: fnd_file.put_line(fnd_file.output,RPAD('-',100,'-'));
392: l_msg_prn_1 := FALSE;

Line 389: fnd_file.new_line(fnd_file.output,1);

385:
386: IF l_msg_prn_1 = TRUE THEN
387: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
388: fnd_file.put_line(fnd_file.output,fnd_message.get);
389: fnd_file.new_line(fnd_file.output,1);
390: fnd_file.put_line(fnd_file.output,l_msg_str_0);
391: fnd_file.put_line(fnd_file.output,RPAD('-',100,'-'));
392: l_msg_prn_1 := FALSE;
393: END IF;

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

386: IF l_msg_prn_1 = TRUE THEN
387: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
388: fnd_file.put_line(fnd_file.output,fnd_message.get);
389: fnd_file.new_line(fnd_file.output,1);
390: fnd_file.put_line(fnd_file.output,l_msg_str_0);
391: fnd_file.put_line(fnd_file.output,RPAD('-',100,'-'));
392: l_msg_prn_1 := FALSE;
393: END IF;
394: fnd_file.put_line(fnd_file.output,l_msg_str_1);

Line 391: fnd_file.put_line(fnd_file.output,RPAD('-',100,'-'));

387: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
388: fnd_file.put_line(fnd_file.output,fnd_message.get);
389: fnd_file.new_line(fnd_file.output,1);
390: fnd_file.put_line(fnd_file.output,l_msg_str_0);
391: fnd_file.put_line(fnd_file.output,RPAD('-',100,'-'));
392: l_msg_prn_1 := FALSE;
393: END IF;
394: fnd_file.put_line(fnd_file.output,l_msg_str_1);
395:

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

390: fnd_file.put_line(fnd_file.output,l_msg_str_0);
391: fnd_file.put_line(fnd_file.output,RPAD('-',100,'-'));
392: l_msg_prn_1 := FALSE;
393: END IF;
394: fnd_file.put_line(fnd_file.output,l_msg_str_1);
395:
396:
397: EXCEPTION
398: WHEN others THEN

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

440:
441: BEGIN
442:
443: IF NVL(TO_NUMBER(RTRIM(LTRIM(p_edit_code))),0) > 0 THEN
444: fnd_file.new_line(fnd_file.log,1);
445: fnd_message.set_name('IGF','IGF_GR_REC_CONTAIN_EDIT_CODES');
446: fnd_file.put_line(fnd_file.log,fnd_message.get);
447:
448: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50) ||

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

442:
443: IF NVL(TO_NUMBER(RTRIM(LTRIM(p_edit_code))),0) > 0 THEN
444: fnd_file.new_line(fnd_file.log,1);
445: fnd_message.set_name('IGF','IGF_GR_REC_CONTAIN_EDIT_CODES');
446: fnd_file.put_line(fnd_file.log,fnd_message.get);
447:
448: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50) ||
449: RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50);
450:

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

452: RPAD(p_disb_ref_num,30);
453:
454:
455: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EDIT_CODE'),50);
456: fnd_file.put_line(fnd_file.log,l_msg_str_0);
457: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
458: fnd_file.put_line(fnd_file.log,l_msg_str_1);
459: fnd_file.put_line(fnd_file.log,' ');
460:

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

453:
454:
455: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EDIT_CODE'),50);
456: fnd_file.put_line(fnd_file.log,l_msg_str_0);
457: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
458: fnd_file.put_line(fnd_file.log,l_msg_str_1);
459: fnd_file.put_line(fnd_file.log,' ');
460:
461: IF NVL(p_edit_code,'0') <> '0' THEN

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

454:
455: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EDIT_CODE'),50);
456: fnd_file.put_line(fnd_file.log,l_msg_str_0);
457: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
458: fnd_file.put_line(fnd_file.log,l_msg_str_1);
459: fnd_file.put_line(fnd_file.log,' ');
460:
461: IF NVL(p_edit_code,'0') <> '0' THEN
462: fnd_file.put_line(fnd_file.log,l_msg_str_2);

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

455: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EDIT_CODE'),50);
456: fnd_file.put_line(fnd_file.log,l_msg_str_0);
457: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
458: fnd_file.put_line(fnd_file.log,l_msg_str_1);
459: fnd_file.put_line(fnd_file.log,' ');
460:
461: IF NVL(p_edit_code,'0') <> '0' THEN
462: fnd_file.put_line(fnd_file.log,l_msg_str_2);
463: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));

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

458: fnd_file.put_line(fnd_file.log,l_msg_str_1);
459: fnd_file.put_line(fnd_file.log,' ');
460:
461: IF NVL(p_edit_code,'0') <> '0' THEN
462: fnd_file.put_line(fnd_file.log,l_msg_str_2);
463: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
464: END IF;
465:
466: FOR l_cn IN 1 .. 25 LOOP

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

459: fnd_file.put_line(fnd_file.log,' ');
460:
461: IF NVL(p_edit_code,'0') <> '0' THEN
462: fnd_file.put_line(fnd_file.log,l_msg_str_2);
463: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
464: END IF;
465:
466: FOR l_cn IN 1 .. 25 LOOP
467:

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

468: l_error_code := NVL(SUBSTR(p_edit_code,l_count,3),'000');
469: IF l_error_code <>'000' THEN
470:
471: l_msg_str_3 := RPAD(l_error_code,5);
472: fnd_file.put_line(fnd_file.log,l_msg_str_3);
473:
474: END IF;
475: l_count := l_count + 3;
476: END LOOP;

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

596: CLOSE cur_rfms_disb;
597: IF (g_persid_grp IS NULL)THEN
598: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
599: igs_ge_msg_stack.add;
600: fnd_file.put_line(fnd_file.log,fnd_message.get);
601: RAISE no_data_in_table;
602: ELSE
603: RAISE next_record;
604: END IF;

Line 619: -- fnd_file.put_line(fnd_file.output,UPPER(l_header));

615: p_ci_sequence_number);
616:
617: -- Header can not be written into output datafile unless and until we are sure that
618: -- at least one data record will be created. Hence commenting out the following line.
619: -- fnd_file.put_line(fnd_file.output,UPPER(l_header));
620: -- Header(above line) will be written in prepare_data procedure just before first
621: -- data record is written. by ugummall.
622:
623: fnd_file.new_line(fnd_file.log,1);

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

619: -- fnd_file.put_line(fnd_file.output,UPPER(l_header));
620: -- Header(above line) will be written in prepare_data procedure just before first
621: -- data record is written. by ugummall.
622:
623: fnd_file.new_line(fnd_file.log,1);
624: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'
625: ||' '|| l_batch_id);
626: fnd_file.new_line(fnd_file.log,1);
627:

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

620: -- Header(above line) will be written in prepare_data procedure just before first
621: -- data record is written. by ugummall.
622:
623: fnd_file.new_line(fnd_file.log,1);
624: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'
625: ||' '|| l_batch_id);
626: fnd_file.new_line(fnd_file.log,1);
627:
628: l_amount_total := 0;

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

622:
623: fnd_file.new_line(fnd_file.log,1);
624: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID'),10)||' :'
625: ||' '|| l_batch_id);
626: fnd_file.new_line(fnd_file.log,1);
627:
628: l_amount_total := 0;
629: l_num_of_rec := 0;
630:

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

641: l_valid_rec := TRUE;
642:
643: fnd_message.set_name('IGF','IGF_GR_RFMS_ORG_ID');
644: fnd_message.set_token('ORIG_ID',l_running_orig_id);
645: fnd_file.put_line(fnd_file.log,fnd_message.get);
646:
647: -- Get The Payment ISIR Transaction Number
648: cur_pymnt_isir_rec := NULL;
649: OPEN cur_pymnt_isir(rec_rfms_disb.base_id);

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

655: l_valid_rec := FALSE;
656:
657: IF cur_pymnt_isir_rec.transaction_num IS NULL THEN
658: fnd_message.set_name('IGF','IGF_AP_NO_PAYMENT_ISIR');
659: fnd_file.put_line(fnd_file.log,fnd_message.get);
660: ELSE
661: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');
662: fnd_file.put_line(fnd_file.log,fnd_message.get);
663: END IF;

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

658: fnd_message.set_name('IGF','IGF_AP_NO_PAYMENT_ISIR');
659: fnd_file.put_line(fnd_file.log,fnd_message.get);
660: ELSE
661: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');
662: fnd_file.put_line(fnd_file.log,fnd_message.get);
663: END IF;
664: END IF;
665:
666: -- check if attending pell is a child of reporting pell id.

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

675: IF (cur_attending_pell%NOTFOUND) THEN
676: l_valid_rec := FALSE;
677:
678: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_ATTEND_PELL_NOT_SETUP');
679: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
680: END IF;
681: CLOSE cur_attending_pell;
682:
683: -- Check if sum of disbursement amounts is less than origination record's amount.

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

691: fnd_message.set_name('IGF','IGF_GR_PELL_DIFF_AMTS');
692: FND_MESSAGE.SET_TOKEN('DISB_AMT', TO_CHAR(rec_disb_amt_tot.disb_amt_tot));
693: FND_MESSAGE.SET_TOKEN('PELL_TOT', TO_CHAR(rec_rfms_disb.pell_amount));
694:
695: fnd_file.put_line(fnd_file.log,fnd_message.get);
696: END IF;
697:
698: -- if Context student record is invalid for sending his disbersements
699: -- due to transaction number mismatch or attending pell child does not exist.

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

734: l_num_of_rec,
735: l_amount_total,
736: l_batch_id);
737:
738: fnd_file.new_line(fnd_file.log,1);
739: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
740: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: -- p_num_of_rec || ' records written into data file

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

737:
738: fnd_file.new_line(fnd_file.log,1);
739: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
740: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: -- p_num_of_rec || ' records written into data file
743: fnd_file.new_line(fnd_file.log,1);
744:
745: IF l_num_of_rec > 0 THEN

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

739: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
740: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: -- p_num_of_rec || ' records written into data file
743: fnd_file.new_line(fnd_file.log,1);
744:
745: IF l_num_of_rec > 0 THEN
746: fnd_file.put_line(fnd_file.output,UPPER(l_trailer));
747: ELSE

Line 746: fnd_file.put_line(fnd_file.output,UPPER(l_trailer));

742: -- p_num_of_rec || ' records written into data file
743: fnd_file.new_line(fnd_file.log,1);
744:
745: IF l_num_of_rec > 0 THEN
746: fnd_file.put_line(fnd_file.output,UPPER(l_trailer));
747: ELSE
748: RAISE batch_not_created;
749: END IF;
750:

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

833: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));
834: fnd_message.set_token('BATCH',l_batch_id);
835: fnd_message.set_token('VRSN',g_ver_num);
836: fnd_message.set_token('AWD_YR',g_alt_code);
837: fnd_file.put_line(fnd_file.log,fnd_message.get);
838: RAISE invalid_version;
839: END IF;
840:
841: IF l_number_rec > 0 THEN

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

911: EXCEPTION
912: -- The exception caught here will be the data format exceptions
913: WHEN OTHERS THEN
914: lf_count := lf_count + 1;
915: fnd_file.put_line(fnd_file.log, ' ' );
916: fnd_message.set_name('IGF','IGF_GR_DISB_INVALID_RECORD');
917: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
918: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
919: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

915: fnd_file.put_line(fnd_file.log, ' ' );
916: fnd_message.set_name('IGF','IGF_GR_DISB_INVALID_RECORD');
917: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
918: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
919: fnd_file.put_line(fnd_file.log,fnd_message.get);
920:
921: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
922: fnd_file.put_line(fnd_file.log,fnd_message.get);
923: fnd_file.put_line(fnd_file.log, ' ' );

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

918: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
919: fnd_file.put_line(fnd_file.log,fnd_message.get);
920:
921: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
922: fnd_file.put_line(fnd_file.log,fnd_message.get);
923: fnd_file.put_line(fnd_file.log, ' ' );
924:
925: RAISE igf_gr_gen.skip_this_record;
926:

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

919: fnd_file.put_line(fnd_file.log,fnd_message.get);
920:
921: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
922: fnd_file.put_line(fnd_file.log,fnd_message.get);
923: fnd_file.put_line(fnd_file.log, ' ' );
924:
925: RAISE igf_gr_gen.skip_this_record;
926:
927: END;

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

939: FETCH cur_disb_orig INTO rec_disb_orig;
940:
941: IF cur_disb_orig%NOTFOUND THEN
942: CLOSE cur_disb_orig;
943: fnd_file.put_line(fnd_file.log,' ');
944: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
945: fnd_file.put_line(fnd_file.log,fnd_message.get);
946: --write to log file
947: log_message(l_batch_id,LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));

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

941: IF cur_disb_orig%NOTFOUND THEN
942: CLOSE cur_disb_orig;
943: fnd_file.put_line(fnd_file.log,' ');
944: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
945: fnd_file.put_line(fnd_file.log,fnd_message.get);
946: --write to log file
947: log_message(l_batch_id,LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));
948: RAISE igf_gr_gen.skip_this_record;
949: END IF;

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

953:
954: fnd_message.set_name('IGF','IGF_GR_DISB_BATCH_MISMATCH');
955: fnd_message.set_token('BATCH_ID',l_batch_id);
956: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
957: fnd_file.put_line(fnd_file.log,fnd_message.get);
958: fnd_file.new_line(fnd_file.log,1);
959: RAISE igf_gr_gen.skip_this_record;
960: END IF;
961:

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

954: fnd_message.set_name('IGF','IGF_GR_DISB_BATCH_MISMATCH');
955: fnd_message.set_token('BATCH_ID',l_batch_id);
956: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
957: fnd_file.put_line(fnd_file.log,fnd_message.get);
958: fnd_file.new_line(fnd_file.log,1);
959: RAISE igf_gr_gen.skip_this_record;
960: END IF;
961:
962: IF rec_disb_orig.disb_ack_act_status <> 'S' THEN

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

965: fnd_message.set_name('IGF','IGF_GR_DISB_NOT_IN_SENT');
966: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
967: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',rec_disb_orig.disb_ack_act_status);
968: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS );
969: fnd_file.put_line(fnd_file.log,fnd_message.get);
970: fnd_file.new_line(fnd_file.log,1);
971:
972: RAISE igf_gr_gen.skip_this_record;
973: END IF;

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

966: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
967: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',rec_disb_orig.disb_ack_act_status);
968: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS );
969: fnd_file.put_line(fnd_file.log,fnd_message.get);
970: fnd_file.new_line(fnd_file.log,1);
971:
972: RAISE igf_gr_gen.skip_this_record;
973: END IF;
974:

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

1020: igf_gr_gen.insert_sys_holds(rec_award.award_id,rec_disb_orig.disb_ref_num,'PELL');
1021: fnd_message.set_name('IGF','IGF_GR_DIFF_PELL_DISB');
1022: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1023: fnd_message.set_token('DISB_NUM',l_rfms.disb_ref_num);
1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:
1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));
1028: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:
1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));
1028: fnd_file.put_line(fnd_file.log,fnd_message.get);
1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));
1032: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1028: fnd_file.put_line(fnd_file.log,fnd_message.get);
1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));
1032: fnd_file.put_line(fnd_file.log,fnd_message.get);
1033: fnd_file.new_line(fnd_file.log,1);
1034:
1035: END IF;
1036:

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

1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));
1032: fnd_file.put_line(fnd_file.log,fnd_message.get);
1033: fnd_file.new_line(fnd_file.log,1);
1034:
1035: END IF;
1036:
1037: CLOSE cur_award;

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

1058: END IF;
1059:
1060: END; -- Inner Begin
1061:
1062: fnd_file.new_line(fnd_file.log,2);
1063:
1064: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
1065: fnd_message.set_token('CNT',l_number_rec);
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1062: fnd_file.new_line(fnd_file.log,2);
1063:
1064: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
1065: fnd_message.set_token('CNT',l_number_rec);
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1069: fnd_message.set_token('CNT',lp_count);
1070: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1069: fnd_message.set_token('CNT',lp_count);
1070: fnd_file.put_line(fnd_file.log,fnd_message.get);
1071:
1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1073: fnd_message.set_token('CNT',lf_count);
1074: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1070: fnd_file.put_line(fnd_file.log,fnd_message.get);
1071:
1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1073: fnd_message.set_token('CNT',lf_count);
1074: fnd_file.put_line(fnd_file.log,fnd_message.get);
1075:
1076: END IF; -- if l_num_rec --
1077:
1078: EXCEPTION

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

1205: -- and stop processing else continue the process
1206: IF l_cod_year_flag THEN
1207:
1208: fnd_message.set_name('IGF','IGF_GR_COD_NO_DISB');
1209: fnd_file.put_line(fnd_file.log,fnd_message.get);
1210: RETURN;
1211:
1212: END IF;
1213:

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

1213:
1214: -- FA 126. base_id and attending pell are mutually exclusive.
1215: IF (base_id IS NOT NULL AND p_attending_pell IS NOT NULL) OR (p_pers_id_grp IS NOT NULL AND p_attending_pell IS NOT NULL) THEN
1216: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_PORIG_INCOMPAT');
1217: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1218: RETURN;
1219: END IF;
1220:
1221: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL THEN

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

1240: END IF;
1241:
1242: -- show parameter 1 - award year
1243: l_msg_str_1 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','AWARD_YEAR'),20) || RPAD(igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number),20);
1244: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1245:
1246: -- show parameter 2 - report pell id
1247: l_msg_str_3 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'REPORT_PELL'),20) || p_reporting_pell;
1248: fnd_file.put_line(fnd_file.log,l_msg_str_3);

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

1244: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1245:
1246: -- show parameter 2 - report pell id
1247: l_msg_str_3 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'REPORT_PELL'),20) || p_reporting_pell;
1248: fnd_file.put_line(fnd_file.log,l_msg_str_3);
1249:
1250: -- show parameter 3 - attend pell id
1251: IF (p_attending_pell IS NOT NULL) THEN
1252: l_msg_str_4 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'ATTEND_PELL'),20) || p_attending_pell;

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

1249:
1250: -- show parameter 3 - attend pell id
1251: IF (p_attending_pell IS NOT NULL) THEN
1252: l_msg_str_4 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS', 'ATTEND_PELL'),20) || p_attending_pell;
1253: fnd_file.put_line(fnd_file.log,l_msg_str_4);
1254: END IF;
1255:
1256: -- show trans_type parameter
1257: l_msg_str_6 := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS', 'TRANS_TYPE'),20) || igf_aw_gen.lookup_desc('IGF_GR_TRANS_TYPE',p_trans_type);

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

1254: END IF;
1255:
1256: -- show trans_type parameter
1257: l_msg_str_6 := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS', 'TRANS_TYPE'),20) || igf_aw_gen.lookup_desc('IGF_GR_TRANS_TYPE',p_trans_type);
1258: fnd_file.put_line(fnd_file.log,l_msg_str_6);
1259:
1260: -- show parameter 4 - base id
1261: IF (base_id IS NOT NULL) THEN
1262: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BASE_ID'),20) || RPAD(igf_gr_gen.get_per_num(base_id),20);

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

1259:
1260: -- show parameter 4 - base id
1261: IF (base_id IS NOT NULL) THEN
1262: l_msg_str_2 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BASE_ID'),20) || RPAD(igf_gr_gen.get_per_num(base_id),20);
1263: fnd_file.put_line(fnd_file.log,l_msg_str_2);
1264: END IF;
1265:
1266: -- show parameter 5 - person id group
1267: IF p_pers_id_grp IS NOT NULL THEN

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

1268: OPEN c_pers_id_grp_name(p_pers_id_grp);
1269: FETCH c_pers_id_grp_name INTO l_pers_id_grp_name;
1270: CLOSE c_pers_id_grp_name;
1271: l_msg_str_5 := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),20) || l_pers_id_grp_name.group_name;
1272: fnd_file.put_line(fnd_file.log,l_msg_str_5);
1273: END IF;
1274: fnd_file.new_line(fnd_file.log,1);
1275:
1276: /*

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

1270: CLOSE c_pers_id_grp_name;
1271: l_msg_str_5 := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),20) || l_pers_id_grp_name.group_name;
1272: fnd_file.put_line(fnd_file.log,l_msg_str_5);
1273: END IF;
1274: fnd_file.new_line(fnd_file.log,1);
1275:
1276: /*
1277: Main logic starts here.
1278: */

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

1325: RAISE no_data_in_table;
1326: END IF;
1327: ELSE
1328: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1329: fnd_file.put_line(fnd_file.log,fnd_message.get);
1330: END IF;
1331: ELSE
1332: RAISE param_error;
1333: END IF;

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

1338: WHEN igf_gr_gen.no_file_version THEN
1339: ROLLBACK;
1340: retcode := 2;
1341: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
1342: fnd_file.put_line(fnd_file.log,errbuf);
1343: WHEN batch_not_created THEN
1344: ROLLBACK;
1345: WHEN param_error THEN
1346: ROLLBACK;

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

1345: WHEN param_error THEN
1346: ROLLBACK;
1347: retcode := 2;
1348: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
1349: fnd_file.put_line(fnd_file.log,errbuf);
1350: WHEN no_data_in_table THEN
1351: ROLLBACK;
1352: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');
1353: fnd_file.put_line(fnd_file.log,errbuf);

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

1349: fnd_file.put_line(fnd_file.log,errbuf);
1350: WHEN no_data_in_table THEN
1351: ROLLBACK;
1352: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');
1353: fnd_file.put_line(fnd_file.log,errbuf);
1354: WHEN OTHERS THEN
1355: ROLLBACK;
1356: retcode := 2;
1357: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || SQLERRM;

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

1405: -- and stop processing else continue the process
1406: IF igf_sl_dl_validation.check_full_participant (l_ci_cal_type,l_ci_sequence_number,'PELL') THEN
1407:
1408: fnd_message.set_name('IGF','IGF_GR_COD_NO_DISB_ACK');
1409: fnd_file.put_line(fnd_file.log,fnd_message.get);
1410: RETURN;
1411:
1412: END IF;
1413:

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

1436: WHEN igf_gr_gen.no_file_version THEN
1437: ROLLBACK;
1438: retcode := 2;
1439: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
1440: fnd_file.put_line(fnd_file.log,errbuf);
1441:
1442: WHEN batch_not_created THEN
1443: ROLLBACK;
1444:

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

1445: WHEN param_error THEN
1446: ROLLBACK;
1447: retcode := 2;
1448: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
1449: fnd_file.put_line(fnd_file.log,errbuf);
1450:
1451: WHEN igf_gr_gen.corrupt_data_file THEN
1452: ROLLBACK;
1453: retcode := 2;

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

1451: WHEN igf_gr_gen.corrupt_data_file THEN
1452: ROLLBACK;
1453: retcode := 2;
1454: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
1455: fnd_file.put_line(fnd_file.log,errbuf);
1456:
1457: WHEN igf_gr_gen.batch_not_in_system THEN
1458: ROLLBACK;
1459: retcode := 2;

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

1457: WHEN igf_gr_gen.batch_not_in_system THEN
1458: ROLLBACK;
1459: retcode := 2;
1460: errbuf := fnd_message.get; -- Bug # 4008991
1461: fnd_file.put_line(fnd_file.log,errbuf);
1462:
1463: WHEN igf_gr_gen.file_not_loaded THEN
1464: ROLLBACK;
1465: retcode := 2;

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

1463: WHEN igf_gr_gen.file_not_loaded THEN
1464: ROLLBACK;
1465: retcode := 2;
1466: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
1467: fnd_file.put_line(fnd_file.log,errbuf);
1468:
1469: WHEN no_data_in_table THEN
1470: ROLLBACK;
1471: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');

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

1468:
1469: WHEN no_data_in_table THEN
1470: ROLLBACK;
1471: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');
1472: fnd_file.put_line(fnd_file.log,errbuf);
1473:
1474: WHEN OTHERS THEN
1475: ROLLBACK;
1476: retcode := 2;