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

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

497: IF cur_alternate_code%NOTFOUND THEN
498: CLOSE cur_alternate_code;
499: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
500: igs_ge_msg_stack.add;
501: fnd_file.put_line(fnd_file.log,fnd_message.get);
502: app_exception.raise_exception;
503: END IF;
504: CLOSE cur_alternate_code;
505:

Line 518: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));

514: END LOOP;
515: CLOSE cur_get_parameters;
516:
517: --Show the parameters passed
518: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
519: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
520: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
521: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
522:

Line 519: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);

515: CLOSE cur_get_parameters;
516:
517: --Show the parameters passed
518: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
519: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
520: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
521: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
522:
523: fnd_file.put_line(fnd_file.log,' ');

Line 520: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));

516:
517: --Show the parameters passed
518: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
519: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
520: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
521: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
522:
523: fnd_file.put_line(fnd_file.log,' ');
524:

Line 521: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);

517: --Show the parameters passed
518: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
519: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
520: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
521: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
522:
523: fnd_file.put_line(fnd_file.log,' ');
524:
525: -- Fetch the Distinct set of Recipient details

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

519: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
520: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
521: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
522:
523: fnd_file.put_line(fnd_file.log,' ');
524:
525: -- Fetch the Distinct set of Recipient details
526: IF p_loan_catg = 'CL_STAFFORD' THEN
527: l_lookup_type :='IGF_SL_CL_STAFFORD';

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

579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient description not found');
580: END IF;
581: fnd_message.set_name('IGF','IGF_SL_RECIP_NOT_FOUND');
582: fnd_message.set_token('REL_CODE',orec.relationship_cd);
583: fnd_file.put_line(fnd_file.log,fnd_message.get);
584: ELSE
585: --The recipient information exists
586:
587: CLOSE cur_recip_desc;

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

629: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Concurrent request failed');
630: END IF;
631: app_exception.raise_exception;
632: ELSE
633: fnd_file.new_line(fnd_file.log,2);
634: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_CREATED');
635: fnd_message.set_token('P_FILENAME',RPAD(TO_CHAR(lv_request_id),10));
636: fnd_message.set_token('P_RECIP_ID',RPAD(recip_desc_rec.recipient_id,10));
637: fnd_message.set_token('P_RECIP_NAME',recip_desc_rec.recip_description||' ');

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

637: fnd_message.set_token('P_RECIP_NAME',recip_desc_rec.recip_description||' ');
638: fnd_message.set_token('P_RECIP_BRC_ID',RPAD(NVL(recip_desc_rec.recip_non_ed_brc_id,' '),'10'));
639:
640: -- IGF.#P_FILENAME : #P_RECIP_ID #P_RECIP_NAME #P_RECIP_BRC_ID
641: fnd_file.put_line(fnd_file.log, fnd_message.get);
642: fnd_file.new_line(fnd_file.log,2);
643: END IF;
644: END IF;
645: END LOOP;

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

638: fnd_message.set_token('P_RECIP_BRC_ID',RPAD(NVL(recip_desc_rec.recip_non_ed_brc_id,' '),'10'));
639:
640: -- IGF.#P_FILENAME : #P_RECIP_ID #P_RECIP_NAME #P_RECIP_BRC_ID
641: fnd_file.put_line(fnd_file.log, fnd_message.get);
642: fnd_file.new_line(fnd_file.log,2);
643: END IF;
644: END IF;
645: END LOOP;
646:

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

648: IF lv_recipient_id_found = FALSE THEN
649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient Id not found');
651: END IF;
652: fnd_file.new_line(fnd_file.log,2);
653: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
654: fnd_file.new_line(fnd_file.log,2);
655: END IF;
656:

Line 653: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));

649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient Id not found');
651: END IF;
652: fnd_file.new_line(fnd_file.log,2);
653: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
654: fnd_file.new_line(fnd_file.log,2);
655: END IF;
656:
657: COMMIT;

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

650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient Id not found');
651: END IF;
652: fnd_file.new_line(fnd_file.log,2);
653: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
654: fnd_file.new_line(fnd_file.log,2);
655: END IF;
656:
657: COMMIT;
658:

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

1533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Recipient description not found');
1534: END IF;
1535: fnd_message.set_name('IGF','IGF_SL_RECIP_NOT_FOUND');
1536: fnd_message.set_token('REL_CODE',p_relationship_cd);
1537: fnd_file.put_line(fnd_file.log,fnd_message.get);
1538: RETURN;
1539: END IF;
1540: CLOSE cur_recip_desc;
1541:

Line 1720: fnd_file.put_line(fnd_file.output,UPPER(lv_header_rec));

1716:
1717: -- To output the Header Record into every file that would be created for the distinct Recipient details
1718:
1719:
1720: fnd_file.put_line(fnd_file.output,UPPER(lv_header_rec));
1721:
1722: -- To insert the Computed Batch Number into CL Batch Table
1723: lv_row_id := NULL;
1724: igf_sl_cl_batch_pkg.insert_row (

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

1765: -- FACR116 Check if the alt_loan_code is not null and the set up record is present or not
1766: IF loan_rec_temp.fed_fund_code = 'ALT' THEN
1767: IF loan_rec_temp.alt_loan_code IS NULL THEN
1768: fnd_message.set_name('IGF','IGF_AW_NO_ALT_LOAN_CODE');
1769: fnd_file.put_line(fnd_file.log,fnd_message.get);
1770: RAISE SKIP_RECORD;
1771: ELSIF lv_rel_code IS NULL AND lv_person_id IS NULL THEN
1772: fnd_message.set_name('IGF','IGF_SL_NO_ALT_SETUP');
1773: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1769: fnd_file.put_line(fnd_file.log,fnd_message.get);
1770: RAISE SKIP_RECORD;
1771: ELSIF lv_rel_code IS NULL AND lv_person_id IS NULL THEN
1772: fnd_message.set_name('IGF','IGF_SL_NO_ALT_SETUP');
1773: fnd_file.put_line(fnd_file.log,fnd_message.get);
1774: RAISE SKIP_RECORD;
1775: END IF;
1776: END IF;
1777: /*

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

1789: IF cur_isir_depend_status%NOTFOUND THEN
1790: CLOSE cur_isir_depend_status;
1791: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
1792: fnd_message.set_token('P_RECORD','igf_ap_fa_base_rec');
1793: fnd_file.put_line(fnd_file.log,fnd_message.get);
1794: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1795: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Record Data not found');
1796: END IF;
1797: RAISE SKIP_RECORD;

Line 2406: fnd_file.put_line(fnd_file.output, UPPER(lv_first_part_trans_rec

2402:
2403:
2404: -- Spool @1 Record
2405: -- masehgal 2477912 Made record "upper" to resolve NCAT reported errors
2406: fnd_file.put_line(fnd_file.output, UPPER(lv_first_part_trans_rec
2407: ||RPAD(lv_1_final_disb_date,32,'0')
2408: ||lv_third_part_trans_rec
2409: ||RPAD(lv_1_final_hold_rel_ind,4,' ')--fields 85 to 88(disbursement hold/release indicator)
2410: ||lv_fifth_part_trans_rec

Line 2640: fnd_file.put_line(fnd_file.output,UPPER(l_at4Record));

2636:
2637: l_at4Record := l_at4Record ||LPAD(' ',288,' ') --Filler
2638: ||'*';
2639:
2640: fnd_file.put_line(fnd_file.output,UPPER(l_at4Record));
2641:
2642: ELSIF lv_cl_version = 'RELEASE-4' THEN
2643: l_v_owner_code := 'NCLP03';
2644: l_at4Record := '@4' ||l_v_owner_code

Line 2744: fnd_file.put_line(fnd_file.output,UPPER (l_at4Record));

2740: ||NVL(alter_rec.repayment_opt_code,' ') -- Repayment Option Code
2741: ||LPAD(' ',307,' ') -- Filler
2742: ||'*';
2743:
2744: fnd_file.put_line(fnd_file.output,UPPER (l_at4Record));
2745: END IF;
2746:
2747: -- Count the @4 Records being sent.
2748: l_count_4 := l_count_4 +1;

Line 2758: fnd_file.put_line(fnd_file.output,UPPER ( '@8NCLP05'

2754: -- disbursement details in the @8 Send record.
2755: -- masehgal 2477912 Made record "upper" to resolve NCAT reported errors
2756:
2757: IF lv_counter > 4 THEN
2758: fnd_file.put_line(fnd_file.output,UPPER ( '@8NCLP05'
2759: ||RPAD(lv_8_final_disb_date,128,'0')
2760: ||RPAD(lv_8_final_hold_rel_ind,16,' ')
2761: ||RPAD(NVL(lv_8_final_gross_amt,'0'),80,'0')
2762: ||RPAD(lv_8_direct_to_borr_flag,16,' ')

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

2899:
2900: EXCEPTION
2901: WHEN SKIP_RECORD THEN
2902: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
2903: fnd_file.put_line(fnd_file.log,fnd_message.get);
2904: fnd_file.new_line(fnd_file.log,1);
2905: END;
2906: END LOOP;
2907:

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

2900: EXCEPTION
2901: WHEN SKIP_RECORD THEN
2902: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
2903: fnd_file.put_line(fnd_file.log,fnd_message.get);
2904: fnd_file.new_line(fnd_file.log,1);
2905: END;
2906: END LOOP;
2907:
2908:

Line 2959: fnd_file.put_line(fnd_file.output,UPPER(lv_trailer_rec));

2955: ||LPAD(' ',9,' ')
2956: ||LPAD(' ',718,' ')
2957: ||'*');
2958: END IF;
2959: fnd_file.put_line(fnd_file.output,UPPER(lv_trailer_rec));
2960:
2961: COMMIT;
2962:
2963: EXCEPTION

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

2976: -- OR all records which were valid and ready to Send, were not Valid.
2977:
2978: retcode := 2;
2979: errbuf := fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA');
2980: fnd_file.put_line(fnd_file.log, '');
2981: fnd_file.put_line(fnd_file.log, errbuf);
2982: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
2983: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','No loan origination data found');
2984: END IF;

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

2977:
2978: retcode := 2;
2979: errbuf := fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA');
2980: fnd_file.put_line(fnd_file.log, '');
2981: fnd_file.put_line(fnd_file.log, errbuf);
2982: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
2983: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','No loan origination data found');
2984: END IF;
2985: errbuf := NULL;