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

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

326:
327: -- File is a valid Disbursement Roster File. It should be processed.
328:
329: fnd_message.set_name('IGF','IGF_DB_CL_ROSTER_FILE');
330: fnd_file.put_line(fnd_file.log,fnd_message.get);
331:
332: --Check whether file has been transmitted completely or not
333:
334: OPEN c_trailer;

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

447:
448: END LOOP;
449: CLOSE c_get_header_parameters;
450:
451: fnd_file.new_line(fnd_file.output,1);
452: fnd_file.put_line(fnd_file.output, lv_header);
453: fnd_file.new_line(fnd_file.output,1);
454: fnd_file.put_line(fnd_file.output, RPAD(lv_source_id,30) || ' : '|| RPAD(l_source_id,40) || RPAD(lv_source_name,30) || ' : '|| l_source_name );
455: fnd_file.put_line(fnd_file.output, RPAD(lv_recipient_id,30) || ' : '|| RPAD(l_recipient_id,40) || RPAD(lv_recipient_name,30) || ' : '|| l_recipient_name);

Line 452: fnd_file.put_line(fnd_file.output, lv_header);

448: END LOOP;
449: CLOSE c_get_header_parameters;
450:
451: fnd_file.new_line(fnd_file.output,1);
452: fnd_file.put_line(fnd_file.output, lv_header);
453: fnd_file.new_line(fnd_file.output,1);
454: fnd_file.put_line(fnd_file.output, RPAD(lv_source_id,30) || ' : '|| RPAD(l_source_id,40) || RPAD(lv_source_name,30) || ' : '|| l_source_name );
455: fnd_file.put_line(fnd_file.output, RPAD(lv_recipient_id,30) || ' : '|| RPAD(l_recipient_id,40) || RPAD(lv_recipient_name,30) || ' : '|| l_recipient_name);
456: fnd_file.put_line(fnd_file.output, RPAD(lv_file_creation_date,30) || ' : '|| RPAD(l_file_creation_dt,40) || RPAD(lv_file_creation_time,30) || ' : '|| l_file_creation_time);

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

449: CLOSE c_get_header_parameters;
450:
451: fnd_file.new_line(fnd_file.output,1);
452: fnd_file.put_line(fnd_file.output, lv_header);
453: fnd_file.new_line(fnd_file.output,1);
454: fnd_file.put_line(fnd_file.output, RPAD(lv_source_id,30) || ' : '|| RPAD(l_source_id,40) || RPAD(lv_source_name,30) || ' : '|| l_source_name );
455: fnd_file.put_line(fnd_file.output, RPAD(lv_recipient_id,30) || ' : '|| RPAD(l_recipient_id,40) || RPAD(lv_recipient_name,30) || ' : '|| l_recipient_name);
456: fnd_file.put_line(fnd_file.output, RPAD(lv_file_creation_date,30) || ' : '|| RPAD(l_file_creation_dt,40) || RPAD(lv_file_creation_time,30) || ' : '|| l_file_creation_time);
457: fnd_file.new_line(fnd_file.output,1);

Line 454: fnd_file.put_line(fnd_file.output, RPAD(lv_source_id,30) || ' : '|| RPAD(l_source_id,40) || RPAD(lv_source_name,30) || ' : '|| l_source_name );

450:
451: fnd_file.new_line(fnd_file.output,1);
452: fnd_file.put_line(fnd_file.output, lv_header);
453: fnd_file.new_line(fnd_file.output,1);
454: fnd_file.put_line(fnd_file.output, RPAD(lv_source_id,30) || ' : '|| RPAD(l_source_id,40) || RPAD(lv_source_name,30) || ' : '|| l_source_name );
455: fnd_file.put_line(fnd_file.output, RPAD(lv_recipient_id,30) || ' : '|| RPAD(l_recipient_id,40) || RPAD(lv_recipient_name,30) || ' : '|| l_recipient_name);
456: fnd_file.put_line(fnd_file.output, RPAD(lv_file_creation_date,30) || ' : '|| RPAD(l_file_creation_dt,40) || RPAD(lv_file_creation_time,30) || ' : '|| l_file_creation_time);
457: fnd_file.new_line(fnd_file.output,1);
458:

Line 455: fnd_file.put_line(fnd_file.output, RPAD(lv_recipient_id,30) || ' : '|| RPAD(l_recipient_id,40) || RPAD(lv_recipient_name,30) || ' : '|| l_recipient_name);

451: fnd_file.new_line(fnd_file.output,1);
452: fnd_file.put_line(fnd_file.output, lv_header);
453: fnd_file.new_line(fnd_file.output,1);
454: fnd_file.put_line(fnd_file.output, RPAD(lv_source_id,30) || ' : '|| RPAD(l_source_id,40) || RPAD(lv_source_name,30) || ' : '|| l_source_name );
455: fnd_file.put_line(fnd_file.output, RPAD(lv_recipient_id,30) || ' : '|| RPAD(l_recipient_id,40) || RPAD(lv_recipient_name,30) || ' : '|| l_recipient_name);
456: fnd_file.put_line(fnd_file.output, RPAD(lv_file_creation_date,30) || ' : '|| RPAD(l_file_creation_dt,40) || RPAD(lv_file_creation_time,30) || ' : '|| l_file_creation_time);
457: fnd_file.new_line(fnd_file.output,1);
458:
459:

Line 456: fnd_file.put_line(fnd_file.output, RPAD(lv_file_creation_date,30) || ' : '|| RPAD(l_file_creation_dt,40) || RPAD(lv_file_creation_time,30) || ' : '|| l_file_creation_time);

452: fnd_file.put_line(fnd_file.output, lv_header);
453: fnd_file.new_line(fnd_file.output,1);
454: fnd_file.put_line(fnd_file.output, RPAD(lv_source_id,30) || ' : '|| RPAD(l_source_id,40) || RPAD(lv_source_name,30) || ' : '|| l_source_name );
455: fnd_file.put_line(fnd_file.output, RPAD(lv_recipient_id,30) || ' : '|| RPAD(l_recipient_id,40) || RPAD(lv_recipient_name,30) || ' : '|| l_recipient_name);
456: fnd_file.put_line(fnd_file.output, RPAD(lv_file_creation_date,30) || ' : '|| RPAD(l_file_creation_dt,40) || RPAD(lv_file_creation_time,30) || ' : '|| l_file_creation_time);
457: fnd_file.new_line(fnd_file.output,1);
458:
459:
460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

453: fnd_file.new_line(fnd_file.output,1);
454: fnd_file.put_line(fnd_file.output, RPAD(lv_source_id,30) || ' : '|| RPAD(l_source_id,40) || RPAD(lv_source_name,30) || ' : '|| l_source_name );
455: fnd_file.put_line(fnd_file.output, RPAD(lv_recipient_id,30) || ' : '|| RPAD(l_recipient_id,40) || RPAD(lv_recipient_name,30) || ' : '|| l_recipient_name);
456: fnd_file.put_line(fnd_file.output, RPAD(lv_file_creation_date,30) || ' : '|| RPAD(l_file_creation_dt,40) || RPAD(lv_file_creation_time,30) || ' : '|| l_file_creation_time);
457: fnd_file.new_line(fnd_file.output,1);
458:
459:
460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','after print header');

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

491: END LOOP;
492: CLOSE c_get_trailer_parameters;
493:
494:
495: fnd_file.new_line(fnd_file.output,1);
496: fnd_file.put_line(fnd_file.output, lv_trailer);
497: fnd_file.new_line(fnd_file.output,1);
498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);
499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);

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

492: CLOSE c_get_trailer_parameters;
493:
494:
495: fnd_file.new_line(fnd_file.output,1);
496: fnd_file.put_line(fnd_file.output, lv_trailer);
497: fnd_file.new_line(fnd_file.output,1);
498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);
499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);
500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);

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

493:
494:
495: fnd_file.new_line(fnd_file.output,1);
496: fnd_file.put_line(fnd_file.output, lv_trailer);
497: fnd_file.new_line(fnd_file.output,1);
498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);
499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);
500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);
501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);

Line 498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);

494:
495: fnd_file.new_line(fnd_file.output,1);
496: fnd_file.put_line(fnd_file.output, lv_trailer);
497: fnd_file.new_line(fnd_file.output,1);
498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);
499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);
500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);
501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);
502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);

Line 499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);

495: fnd_file.new_line(fnd_file.output,1);
496: fnd_file.put_line(fnd_file.output, lv_trailer);
497: fnd_file.new_line(fnd_file.output,1);
498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);
499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);
500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);
501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);
502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);
503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);

Line 500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);

496: fnd_file.put_line(fnd_file.output, lv_trailer);
497: fnd_file.new_line(fnd_file.output,1);
498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);
499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);
500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);
501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);
502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);
503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);
504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);

Line 501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);

497: fnd_file.new_line(fnd_file.output,1);
498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);
499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);
500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);
501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);
502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);
503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);
504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);
505: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_cancel_amt ,50) || ' : '|| l_tot_net_cancel_amt);

Line 502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);

498: fnd_file.put_line(fnd_file.output, RPAD(lv_number_rec,50) || ' : '|| l_number_rec);
499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);
500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);
501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);
502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);
503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);
504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);
505: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_cancel_amt ,50) || ' : '|| l_tot_net_cancel_amt);
506: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_out_cancel_amt,50) || ' : '|| l_tot_net_out_cancel_amt);

Line 503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);

499: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_disb_amt ,50) || ' : '|| l_tot_net_disb_amt);
500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);
501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);
502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);
503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);
504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);
505: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_cancel_amt ,50) || ' : '|| l_tot_net_cancel_amt);
506: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_out_cancel_amt,50) || ' : '|| l_tot_net_out_cancel_amt);
507: fnd_file.new_line(fnd_file.output,1);

Line 504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);

500: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_eft_amt,50) || ' : '|| l_tot_net_eft_amt);
501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);
502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);
503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);
504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);
505: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_cancel_amt ,50) || ' : '|| l_tot_net_cancel_amt);
506: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_out_cancel_amt,50) || ' : '|| l_tot_net_out_cancel_amt);
507: fnd_file.new_line(fnd_file.output,1);
508:

Line 505: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_cancel_amt ,50) || ' : '|| l_tot_net_cancel_amt);

501: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_non_eft_amt,50) || ' : '|| l_tot_net_non_eft_amt);
502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);
503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);
504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);
505: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_cancel_amt ,50) || ' : '|| l_tot_net_cancel_amt);
506: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_out_cancel_amt,50) || ' : '|| l_tot_net_out_cancel_amt);
507: fnd_file.new_line(fnd_file.output,1);
508:
509:

Line 506: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_out_cancel_amt,50) || ' : '|| l_tot_net_out_cancel_amt);

502: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_reissue_amt,50) || ' : '|| l_tot_reissue_amt);
503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);
504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);
505: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_cancel_amt ,50) || ' : '|| l_tot_net_cancel_amt);
506: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_out_cancel_amt,50) || ' : '|| l_tot_net_out_cancel_amt);
507: fnd_file.new_line(fnd_file.output,1);
508:
509:
510:

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

503: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_cancel_amt,50) || ' : '|| l_tot_cancel_amt);
504: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_deficit_amt,50) || ' : '|| l_tot_deficit_amt);
505: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_cancel_amt ,50) || ' : '|| l_tot_net_cancel_amt);
506: fnd_file.put_line(fnd_file.output, RPAD(lv_tot_net_out_cancel_amt,50) || ' : '|| l_tot_net_out_cancel_amt);
507: fnd_file.new_line(fnd_file.output,1);
508:
509:
510:
511: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

584: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','begin data processing ');
586: END IF;
587:
588: fnd_file.new_line(fnd_file.output,1);
589: fnd_file.put_line(fnd_file.output, lv_disb);
590:
591: FOR db_rec IN c_dbcl
592: LOOP

Line 589: fnd_file.put_line(fnd_file.output, lv_disb);

585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','begin data processing ');
586: END IF;
587:
588: fnd_file.new_line(fnd_file.output,1);
589: fnd_file.put_line(fnd_file.output, lv_disb);
590:
591: FOR db_rec IN c_dbcl
592: LOOP
593:

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

641: l_netted_cancel_amt := NULL;
642: l_outstd_cancel_amt := NULL;
643: l_sch_non_ed_brc_id := NULL;
644: END IF;
645: fnd_file.new_line(fnd_file.output,1);
646: fnd_file.put_line(fnd_file.output, RPAD(lv_record_type,40) || ' : '|| l_record_type);
647: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_number,40) || ' : '|| RPAD(l_loan_number,40) || RPAD(lv_loan_sequence_number,30) || ' : '|| l_cl_seq_number);
648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);
649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);

Line 646: fnd_file.put_line(fnd_file.output, RPAD(lv_record_type,40) || ' : '|| l_record_type);

642: l_outstd_cancel_amt := NULL;
643: l_sch_non_ed_brc_id := NULL;
644: END IF;
645: fnd_file.new_line(fnd_file.output,1);
646: fnd_file.put_line(fnd_file.output, RPAD(lv_record_type,40) || ' : '|| l_record_type);
647: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_number,40) || ' : '|| RPAD(l_loan_number,40) || RPAD(lv_loan_sequence_number,30) || ' : '|| l_cl_seq_number);
648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);
649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);
650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );

Line 647: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_number,40) || ' : '|| RPAD(l_loan_number,40) || RPAD(lv_loan_sequence_number,30) || ' : '|| l_cl_seq_number);

643: l_sch_non_ed_brc_id := NULL;
644: END IF;
645: fnd_file.new_line(fnd_file.output,1);
646: fnd_file.put_line(fnd_file.output, RPAD(lv_record_type,40) || ' : '|| l_record_type);
647: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_number,40) || ' : '|| RPAD(l_loan_number,40) || RPAD(lv_loan_sequence_number,30) || ' : '|| l_cl_seq_number);
648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);
649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);
650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );
651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );

Line 648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);

644: END IF;
645: fnd_file.new_line(fnd_file.output,1);
646: fnd_file.put_line(fnd_file.output, RPAD(lv_record_type,40) || ' : '|| l_record_type);
647: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_number,40) || ' : '|| RPAD(l_loan_number,40) || RPAD(lv_loan_sequence_number,30) || ' : '|| l_cl_seq_number);
648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);
649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);
650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );
651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );
652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);

Line 649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);

645: fnd_file.new_line(fnd_file.output,1);
646: fnd_file.put_line(fnd_file.output, RPAD(lv_record_type,40) || ' : '|| l_record_type);
647: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_number,40) || ' : '|| RPAD(l_loan_number,40) || RPAD(lv_loan_sequence_number,30) || ' : '|| l_cl_seq_number);
648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);
649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);
650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );
651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );
652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);
653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);

Line 650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );

646: fnd_file.put_line(fnd_file.output, RPAD(lv_record_type,40) || ' : '|| l_record_type);
647: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_number,40) || ' : '|| RPAD(l_loan_number,40) || RPAD(lv_loan_sequence_number,30) || ' : '|| l_cl_seq_number);
648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);
649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);
650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );
651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );
652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);
653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);
654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);

Line 651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );

647: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_number,40) || ' : '|| RPAD(l_loan_number,40) || RPAD(lv_loan_sequence_number,30) || ' : '|| l_cl_seq_number);
648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);
649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);
650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );
651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );
652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);
653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);
654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);
655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );

Line 652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);

648: fnd_file.put_line(fnd_file.output, RPAD(lv_loan_period_start_date,40) || ' : '|| RPAD(l_loan_per_start_date,40) || RPAD(lv_loan_period_end_date,30) || ' : '|| l_loan_per_end_date);
649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);
650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );
651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );
652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);
653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);
654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);
655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );
656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );

Line 653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);

649: fnd_file.put_line(fnd_file.output, RPAD(lv_lender_id,40) || ' : '|| RPAD(l_lender_id,40) || RPAD(lv_lender_non_ed_branch_id,30) || ' : '|| l_lend_non_ed_brc_id);
650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );
651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );
652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);
653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);
654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);
655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );
656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );
657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);

Line 654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);

650: fnd_file.put_line(fnd_file.output, RPAD(lv_total_schd_disb,40) || ' : '|| RPAD(l_tot_sched_disb,40) || RPAD(lv_disbursement_number,30) || ' : '|| l_disb_num );
651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );
652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);
653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);
654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);
655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );
656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );
657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);
658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);

Line 655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );

651: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantor_id,40) || ' : '|| RPAD(l_guarantor_id,40) || RPAD(lv_guarantee_date,30) || ' : '|| l_guarantee_date );
652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);
653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);
654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);
655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );
656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );
657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);
658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);
659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );

Line 656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );

652: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_amount ,40) || ' : '|| l_guarantee_amt);
653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);
654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);
655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );
656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );
657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);
658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);
659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );
660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));

Line 657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);

653: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_release_date,40) || ' : '|| l_fund_release_date);
654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);
655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );
656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );
657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);
658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);
659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );
660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));
661: fnd_file.put_line(fnd_file.output, RPAD(lv_esign_src_typ_cd,40) || ' : '|| LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))));

Line 658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);

654: fnd_file.put_line(fnd_file.output, RPAD(lv_gross_disbursement_amount,40) || ' : '|| RPAD(l_gross_disb_amt,40) || RPAD(lv_guarantee_fees,30) || ' : '|| l_fee_2);
655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );
656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );
657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);
658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);
659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );
660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));
661: fnd_file.put_line(fnd_file.output, RPAD(lv_esign_src_typ_cd,40) || ' : '|| LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))));
662: fnd_file.put_line(fnd_file.output, RPAD(lv_direct_to_borr_ind_mng,40) || ' : '|| l_direct_to_borr_ind);

Line 659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );

655: fnd_file.put_line(fnd_file.output, RPAD(lv_origination_fees_paid,40) || ' : '|| RPAD(l_fee_paid_1,40) || RPAD(lv_origination_fees,30) || ' : '|| l_fee_1 );
656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );
657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);
658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);
659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );
660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));
661: fnd_file.put_line(fnd_file.output, RPAD(lv_esign_src_typ_cd,40) || ' : '|| LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))));
662: fnd_file.put_line(fnd_file.output, RPAD(lv_direct_to_borr_ind_mng,40) || ' : '|| l_direct_to_borr_ind);
663: fnd_file.new_line(fnd_file.output,1);

Line 660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));

656: fnd_file.put_line(fnd_file.output, RPAD(lv_guarantee_fees_paid ,40) || ' : '|| RPAD(NVL(l_fee_paid_2,0),40) || RPAD( lv_net_disbursement_amount,30) || ' : '|| l_net_disb_amt );
657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);
658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);
659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );
660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));
661: fnd_file.put_line(fnd_file.output, RPAD(lv_esign_src_typ_cd,40) || ' : '|| LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))));
662: fnd_file.put_line(fnd_file.output, RPAD(lv_direct_to_borr_ind_mng,40) || ' : '|| l_direct_to_borr_ind);
663: fnd_file.new_line(fnd_file.output,1);
664: igf_db_cl_disb_resp_pkg.insert_row (x_mode => 'R',

Line 661: fnd_file.put_line(fnd_file.output, RPAD(lv_esign_src_typ_cd,40) || ' : '|| LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))));

657: fnd_file.put_line(fnd_file.output, RPAD(lv_fund_distribution_method ,40) || ' : '|| RPAD(l_fund_dist_mthd,40) || RPAD(lv_check_number,30) || ' : '|| l_check_number);
658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);
659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );
660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));
661: fnd_file.put_line(fnd_file.output, RPAD(lv_esign_src_typ_cd,40) || ' : '|| LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))));
662: fnd_file.put_line(fnd_file.output, RPAD(lv_direct_to_borr_ind_mng,40) || ' : '|| l_direct_to_borr_ind);
663: fnd_file.new_line(fnd_file.output,1);
664: igf_db_cl_disb_resp_pkg.insert_row (x_mode => 'R',
665: x_rowid => l_rowid,

Line 662: fnd_file.put_line(fnd_file.output, RPAD(lv_direct_to_borr_ind_mng,40) || ' : '|| l_direct_to_borr_ind);

658: fnd_file.put_line(fnd_file.output, RPAD(lv_late_disbursement ,40) || ' : '|| RPAD(l_late_disb_ind,40) || RPAD(lv_previously_reported,30) || ' : '|| l_prev_reported_ind);
659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );
660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));
661: fnd_file.put_line(fnd_file.output, RPAD(lv_esign_src_typ_cd,40) || ' : '|| LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))));
662: fnd_file.put_line(fnd_file.output, RPAD(lv_direct_to_borr_ind_mng,40) || ' : '|| l_direct_to_borr_ind);
663: fnd_file.new_line(fnd_file.output,1);
664: igf_db_cl_disb_resp_pkg.insert_row (x_mode => 'R',
665: x_rowid => l_rowid,
666: x_cdbr_id => l_cdbr_id,

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

659: fnd_file.put_line(fnd_file.output, RPAD(lv_net_cancellation_amount,40) || ' : '|| RPAD(l_net_cancel_amt,40) || RPAD(lv_netted_cancel_amount,30) || ' : '|| NVL(l_netted_cancel_amt,0) );
660: fnd_file.put_line(fnd_file.output, RPAD(lv_outstanding_can_amt,40) || ' : '|| NVL(l_outstd_cancel_amt,0));
661: fnd_file.put_line(fnd_file.output, RPAD(lv_esign_src_typ_cd,40) || ' : '|| LTRIM(RTRIM(SUBSTR(db_rec.record_data,473,9))));
662: fnd_file.put_line(fnd_file.output, RPAD(lv_direct_to_borr_ind_mng,40) || ' : '|| l_direct_to_borr_ind);
663: fnd_file.new_line(fnd_file.output,1);
664: igf_db_cl_disb_resp_pkg.insert_row (x_mode => 'R',
665: x_rowid => l_rowid,
666: x_cdbr_id => l_cdbr_id,
667: x_cbth_id => l_cbth_id,

Line 887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);

883: EXCEPTION
884: WHEN OTHERS THEN
885: ROLLBACK TO IGFDB04B_SP1_1;
886: fnd_message.set_name('IGF','IGF_SL_DB_ERROR_UPLOAD');
887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);
888: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
889: fnd_file.put_line(fnd_file.log, fnd_message.get);
890: fnd_file.new_line(fnd_file.log, 1);
891: END;

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

885: ROLLBACK TO IGFDB04B_SP1_1;
886: fnd_message.set_name('IGF','IGF_SL_DB_ERROR_UPLOAD');
887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);
888: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
889: fnd_file.put_line(fnd_file.log, fnd_message.get);
890: fnd_file.new_line(fnd_file.log, 1);
891: END;
892:
893: END LOOP;

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

886: fnd_message.set_name('IGF','IGF_SL_DB_ERROR_UPLOAD');
887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);
888: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
889: fnd_file.put_line(fnd_file.log, fnd_message.get);
890: fnd_file.new_line(fnd_file.log, 1);
891: END;
892:
893: END LOOP;
894: IF l_actual_rec <> l_number_rec THEN

Line 909: fnd_file.put_line(fnd_file.log,SQLERRM);

905: RAISE;
906: WHEN OTHERS THEN
907: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
908: fnd_message.set_token('NAME','IGF_DB_CL_ROSTER.CL_LOAD_DATA');
909: fnd_file.put_line(fnd_file.log,SQLERRM);
910: igs_ge_msg_stack.add;
911: app_exception.raise_exception;
912:
913: END cl_load_data;

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

983: fee_paid_1_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1');
984: fee_paid_2_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2');
985: disb_gross_amt_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT');
986: direct_to_borr_ind_desc := igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND');
987: fnd_file.put_line(fnd_file.log, '');
988: l_msg_str_0 := RPAD(loan_number_desc,30)||' : '|| p_loan_number ||'
989: '||RPAD(disb_num_desc,30) ||' : '||TO_CHAR(p_disb_num);
990:
991: fnd_file.put_line(fnd_file.log,l_msg_str_0);

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

987: fnd_file.put_line(fnd_file.log, '');
988: l_msg_str_0 := RPAD(loan_number_desc,30)||' : '|| p_loan_number ||'
989: '||RPAD(disb_num_desc,30) ||' : '||TO_CHAR(p_disb_num);
990:
991: fnd_file.put_line(fnd_file.log,l_msg_str_0);
992:
993: END log_start;
994:
995:

Line 1097: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code1));

1093: OR cbth_rec.err_code4 IS NOT NULL
1094: OR cbth_rec.err_code5 IS NOT NULL THEN
1095:
1096: IF cbth_rec.err_code1 IS NOT NULL THEN
1097: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code1));
1098: END IF;
1099: IF cbth_rec.err_code2 IS NOT NULL THEN
1100: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code2));
1101: END IF;

Line 1100: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code2));

1096: IF cbth_rec.err_code1 IS NOT NULL THEN
1097: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code1));
1098: END IF;
1099: IF cbth_rec.err_code2 IS NOT NULL THEN
1100: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code2));
1101: END IF;
1102: IF cbth_rec.err_code3 IS NOT NULL THEN
1103: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code3));
1104: END IF;

Line 1103: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code3));

1099: IF cbth_rec.err_code2 IS NOT NULL THEN
1100: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code2));
1101: END IF;
1102: IF cbth_rec.err_code3 IS NOT NULL THEN
1103: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code3));
1104: END IF;
1105: IF cbth_rec.err_code4 IS NOT NULL THEN
1106: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code4));
1107: END IF;

Line 1106: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code4));

1102: IF cbth_rec.err_code3 IS NOT NULL THEN
1103: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code3));
1104: END IF;
1105: IF cbth_rec.err_code4 IS NOT NULL THEN
1106: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code4));
1107: END IF;
1108: IF cbth_rec.err_code5 IS NOT NULL THEN
1109: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code5));
1110: END IF;

Line 1109: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code5));

1105: IF cbth_rec.err_code4 IS NOT NULL THEN
1106: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code4));
1107: END IF;
1108: IF cbth_rec.err_code5 IS NOT NULL THEN
1109: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',cbth_rec.err_code5));
1110: END IF;
1111: END IF;
1112:
1113:

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

1117: IF cur_awdisb%NOTFOUND THEN
1118: CLOSE cur_awdisb;
1119: fnd_message.set_name('IGF','IGF_SL_NO_AWD_DISB');
1120: -- No Records in Award-Disbursement Table.
1121: fnd_file.new_line(fnd_file.log,1);
1122: fnd_file.put_line(fnd_file.log,fnd_message.get);
1123: fnd_file.new_line(fnd_file.log,1);
1124: lv_rec_status := 'F';
1125: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

1118: CLOSE cur_awdisb;
1119: fnd_message.set_name('IGF','IGF_SL_NO_AWD_DISB');
1120: -- No Records in Award-Disbursement Table.
1121: fnd_file.new_line(fnd_file.log,1);
1122: fnd_file.put_line(fnd_file.log,fnd_message.get);
1123: fnd_file.new_line(fnd_file.log,1);
1124: lv_rec_status := 'F';
1125: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1126: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','skip flag TRUE ');

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

1119: fnd_message.set_name('IGF','IGF_SL_NO_AWD_DISB');
1120: -- No Records in Award-Disbursement Table.
1121: fnd_file.new_line(fnd_file.log,1);
1122: fnd_file.put_line(fnd_file.log,fnd_message.get);
1123: fnd_file.new_line(fnd_file.log,1);
1124: lv_rec_status := 'F';
1125: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1126: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','skip flag TRUE ');
1127: END IF;

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

1136: FETCH c_clset INTO l_auto_late_ind;
1137: IF c_clset%NOTFOUND THEN
1138: CLOSE c_clset;
1139: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
1140: fnd_file.put_line(fnd_file.log,fnd_message.get);
1141: -- No Records in CommonLine Setup Table.
1142: igs_ge_msg_stack.add;
1143: RAISE CLSETUP_NOT_FOUND;
1144: END IF;

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

1163: -- If the fund status is already funded then skip this record
1164: -- No updates for igf_aw_awd_disb table
1165: IF l_rec_type = 'N' THEN
1166: fnd_message.set_name('IGF','IGF_DB_ROST_ALFND_NOUPD');
1167: fnd_file.put_line(fnd_file.log,fnd_message.get);
1168: fnd_file.new_line(fnd_file.log,1);
1169: RAISE SKIP_THIS_RECORD;
1170: ELSE
1171: lv_rec_status := 'A';

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

1164: -- No updates for igf_aw_awd_disb table
1165: IF l_rec_type = 'N' THEN
1166: fnd_message.set_name('IGF','IGF_DB_ROST_ALFND_NOUPD');
1167: fnd_file.put_line(fnd_file.log,fnd_message.get);
1168: fnd_file.new_line(fnd_file.log,1);
1169: RAISE SKIP_THIS_RECORD;
1170: ELSE
1171: lv_rec_status := 'A';
1172: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');

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

1169: RAISE SKIP_THIS_RECORD;
1170: ELSE
1171: lv_rec_status := 'A';
1172: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');
1173: fnd_file.put_line(fnd_file.log,fnd_message.get);
1174: fnd_file.new_line(fnd_file.log,1);
1175: END IF;
1176: END IF;
1177:

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

1170: ELSE
1171: lv_rec_status := 'A';
1172: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');
1173: fnd_file.put_line(fnd_file.log,fnd_message.get);
1174: fnd_file.new_line(fnd_file.log,1);
1175: END IF;
1176: END IF;
1177:
1178: -- Condition 3 : Check if the Amounts are Different.

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

1209: LPAD(direct_to_borr_ind_desc,30) || LPAD(NVL(l_direct_to_borr_ind,' '),30) ||LPAD(NVL(l_awd_direct_to_borr_ind,' '),30);
1210:
1211: fnd_message.set_name('IGF','IGF_DB_INFO_DIFFER');
1212: --Amounts are different in file and table for this record
1213: fnd_file.put_line(fnd_file.log,fnd_message.get);
1214: fnd_file.put_line(fnd_file.log,l_msg_str2);
1215: fnd_file.new_line(fnd_file.log,1);
1216: IF p_update_disb = 'N' THEN
1217: lv_rec_status := 'D';

Line 1214: fnd_file.put_line(fnd_file.log,l_msg_str2);

1210:
1211: fnd_message.set_name('IGF','IGF_DB_INFO_DIFFER');
1212: --Amounts are different in file and table for this record
1213: fnd_file.put_line(fnd_file.log,fnd_message.get);
1214: fnd_file.put_line(fnd_file.log,l_msg_str2);
1215: fnd_file.new_line(fnd_file.log,1);
1216: IF p_update_disb = 'N' THEN
1217: lv_rec_status := 'D';
1218: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_NOUPD');

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

1211: fnd_message.set_name('IGF','IGF_DB_INFO_DIFFER');
1212: --Amounts are different in file and table for this record
1213: fnd_file.put_line(fnd_file.log,fnd_message.get);
1214: fnd_file.put_line(fnd_file.log,l_msg_str2);
1215: fnd_file.new_line(fnd_file.log,1);
1216: IF p_update_disb = 'N' THEN
1217: lv_rec_status := 'D';
1218: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_NOUPD');
1219: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1215: fnd_file.new_line(fnd_file.log,1);
1216: IF p_update_disb = 'N' THEN
1217: lv_rec_status := 'D';
1218: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_NOUPD');
1219: fnd_file.put_line(fnd_file.log,fnd_message.get);
1220: fnd_file.new_line(fnd_file.log,1);
1221: RAISE SKIP_THIS_RECORD;
1222: ELSIF p_update_disb = 'Y' THEN
1223: lv_rec_status := 'U';

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

1216: IF p_update_disb = 'N' THEN
1217: lv_rec_status := 'D';
1218: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_NOUPD');
1219: fnd_file.put_line(fnd_file.log,fnd_message.get);
1220: fnd_file.new_line(fnd_file.log,1);
1221: RAISE SKIP_THIS_RECORD;
1222: ELSIF p_update_disb = 'Y' THEN
1223: lv_rec_status := 'U';
1224: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_YSUPD');

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

1221: RAISE SKIP_THIS_RECORD;
1222: ELSIF p_update_disb = 'Y' THEN
1223: lv_rec_status := 'U';
1224: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_YSUPD');
1225: fnd_file.put_line(fnd_file.log,fnd_message.get);
1226: fnd_file.new_line(fnd_file.log,1);
1227: disb_rec.fee_1 := l_fee_1;
1228: disb_rec.fee_2 := l_fee_2;
1229: disb_rec.disb_net_amt := l_net_disb_amt;

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

1222: ELSIF p_update_disb = 'Y' THEN
1223: lv_rec_status := 'U';
1224: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_YSUPD');
1225: fnd_file.put_line(fnd_file.log,fnd_message.get);
1226: fnd_file.new_line(fnd_file.log,1);
1227: disb_rec.fee_1 := l_fee_1;
1228: disb_rec.fee_2 := l_fee_2;
1229: disb_rec.disb_net_amt := l_net_disb_amt;
1230: disb_rec.disb_accepted_amt := l_disb_gross_amt;

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

1258: LPAD(direct_to_borr_ind_desc,30) ||LPAD(NVL(l_direct_to_borr_ind,' '),30);
1259:
1260: fnd_message.set_name('IGF','IGF_SL_LATE_DISB');
1261: -- Late disbursement set for this record.
1262: fnd_file.put_line(fnd_file.log,fnd_message.get);
1263: fnd_file.put_line(fnd_file.log,l_msg_str1);
1264: lv_rec_status := 'L';
1265: RAISE SKIP_THIS_RECORD;
1266: END IF;

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

1259:
1260: fnd_message.set_name('IGF','IGF_SL_LATE_DISB');
1261: -- Late disbursement set for this record.
1262: fnd_file.put_line(fnd_file.log,fnd_message.get);
1263: fnd_file.put_line(fnd_file.log,l_msg_str1);
1264: lv_rec_status := 'L';
1265: RAISE SKIP_THIS_RECORD;
1266: END IF;
1267:

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

1270: -- set the fund status = FUNDED
1271: IF lv_rec_status = 'N' THEN
1272: lv_rec_status := 'U';
1273: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');
1274: fnd_file.put_line(fnd_file.log,fnd_message.get);
1275: fnd_file.new_line(fnd_file.log,1);
1276: END IF;
1277:
1278: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

1271: IF lv_rec_status = 'N' THEN
1272: lv_rec_status := 'U';
1273: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');
1274: fnd_file.put_line(fnd_file.log,fnd_message.get);
1275: fnd_file.new_line(fnd_file.log,1);
1276: END IF;
1277:
1278: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1279: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug',

Line 1446: fnd_file.put_line(fnd_file.log,SQLERRM);

1442: WHEN OTHERS THEN
1443: ROLLBACK;
1444: retcode := 2;
1445: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1446: fnd_file.put_line(fnd_file.log,SQLERRM);
1447: igs_ge_msg_stack.conc_exception_hndl;
1448:
1449: END roster_ack;
1450: