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

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

380: IF cur_Hrecord%NOTFOUND THEN
381: CLOSE cur_Hrecord;
382: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_HEADER');
383: -- replace IGF_GE_INVALID_FILE with new one IGF_SL_CL_INVALID_HEADER
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385: fnd_file.new_line(fnd_file.log,1);
386: RAISE batch_exceptions;
387: END IF;
388: CLOSE cur_Hrecord;

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

381: CLOSE cur_Hrecord;
382: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_HEADER');
383: -- replace IGF_GE_INVALID_FILE with new one IGF_SL_CL_INVALID_HEADER
384: fnd_file.put_line(fnd_file.log,fnd_message.get);
385: fnd_file.new_line(fnd_file.log,1);
386: RAISE batch_exceptions;
387: END IF;
388: CLOSE cur_Hrecord;
389:

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

395: IF cur_Trecord%NOTFOUND THEN
396: CLOSE cur_Trecord;
397: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_TRAILER');
398: -- replace IGF_GE_FILE_NOT_COMPLETE with new one IGF_SL_CL_INVALID_TRAILER
399: fnd_file.put_line(fnd_file.log,fnd_message.get);
400: fnd_file.new_line(fnd_file.log,1);
401: RAISE batch_exceptions;
402: END IF;
403: CLOSE cur_Trecord;

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

396: CLOSE cur_Trecord;
397: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_TRAILER');
398: -- replace IGF_GE_FILE_NOT_COMPLETE with new one IGF_SL_CL_INVALID_TRAILER
399: fnd_file.put_line(fnd_file.log,fnd_message.get);
400: fnd_file.new_line(fnd_file.log,1);
401: RAISE batch_exceptions;
402: END IF;
403: CLOSE cur_Trecord;
404:

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

417: NULL;
418: ELSE
419: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 6' ||' ';
420: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_FILE_TYPE');
421: fnd_file.put_line(fnd_file.log,fnd_message.get);
422: fnd_file.new_line(fnd_file.log,1);
423: RAISE batch_exceptions;
424: END IF;
425:

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

418: ELSE
419: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 6' ||' ';
420: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_FILE_TYPE');
421: fnd_file.put_line(fnd_file.log,fnd_message.get);
422: fnd_file.new_line(fnd_file.log,1);
423: RAISE batch_exceptions;
424: END IF;
425:
426: IF g_v_cl_version NOT IN ('RELEASE-5','RELEASE-4') THEN

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

425:
426: IF g_v_cl_version NOT IN ('RELEASE-5','RELEASE-4') THEN
427: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_CL_VERSION');
428: fnd_message.set_token('RESP_VER',g_v_cl_version);
429: fnd_file.put_line(fnd_file.log, fnd_message.get);
430: RAISE batch_exceptions;
431: END IF;
432:
433:

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

431: END IF;
432:
433:
434: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_ACK');
435: fnd_file.put_line(fnd_file.log, fnd_message.get);
436:
437: g_loaded_batch_id := LTRIM(RTRIM(SUBSTR(header_rec.record_data, 11,12)));
438: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 7' ||' ';
439: l_file_creation_date := fnd_date.string_to_date(LTRIM(RTRIM(SUBSTR(Header_rec.record_data,23,14))),'YYYYMMDDHH24MISS');

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

512:
513: END IF;
514: CLOSE cur_batch;
515:
516: fnd_file.new_line(fnd_file.log,1);
517:
518: -- Call Procedure to Process all the Transaction Records
519:
520: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 10' ||' ';

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

684:
685: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 2' ||' ';
686: l_loan_active := NULL;
687:
688: fnd_file.new_line(fnd_file.log,1);
689: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
690: fnd_file.new_line(fnd_file.log,1);
691:
692: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),

Line 689: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));

685: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 2' ||' ';
686: l_loan_active := NULL;
687:
688: fnd_file.new_line(fnd_file.log,1);
689: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
690: fnd_file.new_line(fnd_file.log,1);
691:
692: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),
693: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_VERSION',g_v_cl_version)

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

686: l_loan_active := NULL;
687:
688: fnd_file.new_line(fnd_file.log,1);
689: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
690: fnd_file.new_line(fnd_file.log,1);
691:
692: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),
693: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_VERSION',g_v_cl_version)
694: );

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

727: END IF;
728: -- new message
729: -- if processing type is not CR then only check for loan existing in system
730: --
731: fnd_file.new_line(fnd_file.log,2);
732: OPEN c_loan;
733: FETCH c_loan INTO rec_c_loan;
734: l_loan_active := rec_c_loan.active;
735: l_n_award_id := rec_c_loan.award_id;

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

739: l_resp_record_status := 'I';
740: --
741: -- Loan Number not found in the System
742: --
743: fnd_file.new_line(fnd_file.log,1);
744: fnd_message.set_name('IGF','IGF_SL_CL_INS_RESP_REC');
745: fnd_message.set_token('LOAN_NUMBER', l_loan_number);
746: fnd_file.put_line(fnd_file.log,fnd_message.get);
747: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 3' ||' ';

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

742: --
743: fnd_file.new_line(fnd_file.log,1);
744: fnd_message.set_name('IGF','IGF_SL_CL_INS_RESP_REC');
745: fnd_message.set_token('LOAN_NUMBER', l_loan_number);
746: fnd_file.put_line(fnd_file.log,fnd_message.get);
747: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 3' ||' ';
748: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
749: fnd_message.set_token('LOAN_NUMBER',l_loan_number);
750: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

746: fnd_file.put_line(fnd_file.log,fnd_message.get);
747: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 3' ||' ';
748: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
749: fnd_message.set_token('LOAN_NUMBER',l_loan_number);
750: fnd_file.put_line(fnd_file.log,fnd_message.get);
751: fnd_file.new_line(fnd_file.log,1);
752: log_to_fnd(p_v_module => 'process_1_records',
753: p_v_string => ' Loan number '||l_loan_number||' not found in the system '||
754: ' Processing Type ' ||igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)

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

747: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 3' ||' ';
748: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
749: fnd_message.set_token('LOAN_NUMBER',l_loan_number);
750: fnd_file.put_line(fnd_file.log,fnd_message.get);
751: fnd_file.new_line(fnd_file.log,1);
752: log_to_fnd(p_v_module => 'process_1_records',
753: p_v_string => ' Loan number '||l_loan_number||' not found in the system '||
754: ' Processing Type ' ||igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)
755: );

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

768: l_resp_record_status := 'M';
769: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_VERSION_PRC');
770: fnd_message.set_token('RESP_VER',g_v_cl_version);
771: fnd_message.set_token('SYS_LOAN_VER',lv_sys_loan_version);
772: fnd_file.put_line(fnd_file.log, fnd_message.get);
773: RAISE e_skip;
774: END IF;
775: END IF;
776:

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

780: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 7' ||' ';
781: l_resp_record_status := 'I'; -- inactive loan
782: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_INACTIVE');
783: fnd_message.set_token('LOAN_NUMBER',l_loan_number);
784: fnd_file.put_line(fnd_file.log, fnd_message.get);
785: RAISE e_skip;
786: END IF;
787:
788: IF lv_resp_prc_type NOT IN ('GP','CR','GO') THEN

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

788: IF lv_resp_prc_type NOT IN ('GP','CR','GO') THEN
789: l_resp_record_status := 'IP';
790: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 4 invalid prc type' ||' ';
791: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');
792: fnd_file.put_line(fnd_file.log, fnd_message.get);
793: RAISE e_skip;
794: END IF;
795:
796: -- bvisvana - FA 161 - Bug # 5006583

Line 806: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ACK_REC_STATUS','IA'));

802: (lv_loan_type = 'GB' AND NVL(lv_fed_appl_form_code,'*') <> 'G')
803: ) THEN
804: l_resp_record_status := 'IA';
805: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - invalid fed appl form code' ||' ';
806: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ACK_REC_STATUS','IA'));
807: RAISE e_skip;
808: END IF;
809:
810: OPEN c_igf_sl_lor (cp_v_loan_number => l_loan_number);

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

830: || ' - lv_resp_prc_type - ' || lv_resp_prc_type || ' ';
831: IF lv_resp_rec_type NOT IN ('A','I','G','B','P','D','C','M','N','R','T') THEN
832: l_resp_record_status := 'IR';
833: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');
834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835: RAISE e_skip;
836: END IF;
837:
838: IF lv_resp_prc_type IN ('GP','GO') THEN

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

846: (l_v_rec_type_ind <> 'R' AND lv_resp_rec_type = 'N')
847: )THEN
848: l_resp_record_status := 'IC';
849: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
850: fnd_file.put_line(fnd_file.log, fnd_message.get);
851: RAISE e_skip;
852: END IF;
853: END IF;
854: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - not reprint ';

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

855: IF l_v_rec_type_ind IN ('A','C') AND
856: lv_resp_rec_type NOT IN ('R','M') THEN
857: l_resp_record_status := 'IC';
858: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
859: fnd_file.put_line(fnd_file.log, fnd_message.get);
860: RAISE e_skip;
861: END IF;
862: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - not M,R ';
863: IF l_v_rec_type_ind NOT IN ('A','C') AND

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

863: IF l_v_rec_type_ind NOT IN ('A','C') AND
864: lv_resp_rec_type IN ('R','M') THEN
865: l_resp_record_status := 'IC';
866: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
867: fnd_file.put_line(fnd_file.log, fnd_message.get);
868: RAISE e_skip;
869: END IF;
870: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - not A,C ';
871: IF l_v_rec_type_ind = 'T' AND

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

871: IF l_v_rec_type_ind = 'T' AND
872: lv_resp_rec_type <> 'T' THEN
873: l_resp_record_status := 'IC';
874: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
875: fnd_file.put_line(fnd_file.log, fnd_message.get);
876: RAISE e_skip;
877: END IF;
878: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - not T ';
879: IF l_v_rec_type_ind <> 'T' AND

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

879: IF l_v_rec_type_ind <> 'T' AND
880: lv_resp_rec_type = 'T' THEN
881: l_resp_record_status := 'IC';
882: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
883: fnd_file.put_line(fnd_file.log, fnd_message.get);
884: RAISE e_skip;
885: END IF;
886: END IF; -- rec type values
887: END IF; -- GO,GP

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

890: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 not T ';
891: IF lv_resp_rec_type NOT IN ('M','N','R','S','C') THEN
892: l_resp_record_status := 'IR';
893: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');
894: fnd_file.put_line(fnd_file.log, fnd_message.get);
895: RAISE e_skip;
896: END IF;
897: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 1 ';
898: IF lv_resp_prc_type IN ('GP','GO') THEN

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

901: (l_v_rec_type_ind <> 'R' AND lv_resp_rec_type = 'N')
902: )THEN
903: l_resp_record_status := 'IC';
904: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
905: fnd_file.put_line(fnd_file.log, fnd_message.get);
906: RAISE e_skip;
907: END IF;
908: END IF;
909: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 2 ';

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

910: IF l_v_rec_type_ind IN ('A','C','T') AND
911: lv_resp_rec_type NOT IN ('S','R','M') THEN
912: l_resp_record_status := 'IC';
913: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
914: fnd_file.put_line(fnd_file.log, fnd_message.get);
915: RAISE e_skip;
916: END IF;
917: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 3 ';
918: IF l_v_rec_type_ind NOT IN ('A','C','T') AND

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

918: IF l_v_rec_type_ind NOT IN ('A','C','T') AND
919: lv_resp_rec_type IN ('S','R','M') THEN
920: l_resp_record_status := 'IC';
921: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
922: fnd_file.put_line(fnd_file.log, fnd_message.get);
923: RAISE e_skip;
924: END IF;
925: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 4 ';
926: IF l_v_rec_type_ind = 'T' AND

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

926: IF l_v_rec_type_ind = 'T' AND
927: lv_resp_rec_type <> 'S' THEN
928: l_resp_record_status := 'IC';
929: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
930: fnd_file.put_line(fnd_file.log, fnd_message.get);
931: RAISE e_skip;
932: END IF;
933: --Bug 4093687 UNABLE TO UPLOAD ORIGINATION ACKNOWLEGMENT FOR CL5
934: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 5 ';

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

935: /*IF l_v_rec_type_ind <> 'T' AND
936: lv_resp_rec_type = 'S' THEN
937: l_resp_record_status := 'IC';
938: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
939: fnd_file.put_line(fnd_file.log, fnd_message.get);
940: RAISE e_skip;
941: END IF;
942: */
943: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 6 ';

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

1050: p_v_string => ' School Certification Request information - processing borrower student data'
1051: );
1052: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - CR Processing 8';
1053: process_borrow_stud_rec (p_rec_resp_r1 => rec_scr_sl_resp);
1054: fnd_file.new_line(fnd_file.log,1);
1055: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - CR Processing 9';
1056: log_to_fnd(p_v_module => 'process_1_records',
1057: p_v_string => ' School Certification Request information - processed borrower student data'
1058: );

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

1688: ELSIF LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,188,2))) <> 'AL' THEN
1689: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 11' || ' ';
1690: fnd_message.set_name('IGF','IGF_SL_CL_FORMAT_NOT_SUPP');
1691: fnd_message.set_token('FORMAT',LTRIM(RTRIM(SUBSTR(other_rec.record_data,1,2))));
1692: fnd_file.put_line(fnd_file.log, fnd_message.get);
1693:
1694: END IF;
1695:
1696: ELSIF LTRIM(RTRIM(SUBSTR(other_rec.record_data,1,2))) ='@2' THEN

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

1747: v_tab_clchrs_dtls(l_n_ctr_r6).error_message_5_code := LTRIM(RTRIM(SUBSTR(other_rec.record_data,493,3)));
1748: ELSE
1749: fnd_message.set_name('IGF','IGF_SL_CL_FORMAT_NOT_SUPP');
1750: fnd_message.set_token('FORMAT',LTRIM(RTRIM(SUBSTR(other_rec.record_data,1,2))));
1751: fnd_file.put_line(fnd_file.log, fnd_message.get);
1752: END IF;
1753:
1754: ELSE -- Display Message only for Record Formats other than @T ,@1 @8, @2,@3,@7 , @6 and @4
1755: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 12' || ' ';

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

1755: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 12' || ' ';
1756: -- Other Record Types are Not Supported in the Current Release.
1757: fnd_message.set_name('IGF','IGF_SL_CL_FORMAT_NOT_SUPP');
1758: fnd_message.set_token('FORMAT',LTRIM(RTRIM(SUBSTR(other_rec.record_data,1,2))));
1759: fnd_file.put_line(fnd_file.log, fnd_message.get);
1760:
1761: END IF;
1762: gv_debug_str := '';
1763: END LOOP;

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

1953: lb_rejected_rec := FALSE;
1954: lb_print_mess := TRUE;
1955: l_loan_number := loaded_1rec.loan_number;
1956:
1957: fnd_file.new_line(fnd_file.log,1);
1958: fnd_message.set_name('IGF','IGF_SL_CL_INS_RESP_REC');
1959: fnd_message.set_token('LOAN_NUMBER', l_loan_number);
1960: fnd_file.put_line(fnd_file.log,fnd_message.get);
1961:

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

1956:
1957: fnd_file.new_line(fnd_file.log,1);
1958: fnd_message.set_name('IGF','IGF_SL_CL_INS_RESP_REC');
1959: fnd_message.set_token('LOAN_NUMBER', l_loan_number);
1960: fnd_file.put_line(fnd_file.log,fnd_message.get);
1961:
1962: gv_debug_str := gv_debug_str || 'MAIN - 9' || ' ';
1963: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||loaded_1rec.s_ssn;
1964: fnd_file.put_line(fnd_file.log, l_log_mesg);

Line 1964: fnd_file.put_line(fnd_file.log, l_log_mesg);

1960: fnd_file.put_line(fnd_file.log,fnd_message.get);
1961:
1962: gv_debug_str := gv_debug_str || 'MAIN - 9' || ' ';
1963: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||loaded_1rec.s_ssn;
1964: fnd_file.put_line(fnd_file.log, l_log_mesg);
1965: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1966: ||loaded_1rec.s_first_name||' '||loaded_1rec.s_last_name;
1967: fnd_file.put_line(fnd_file.log, l_log_mesg);
1968: --MN 16-Dec-2004 15:25 Log Borrower Name and SS as well.

Line 1967: fnd_file.put_line(fnd_file.log, l_log_mesg);

1963: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||loaded_1rec.s_ssn;
1964: fnd_file.put_line(fnd_file.log, l_log_mesg);
1965: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1966: ||loaded_1rec.s_first_name||' '||loaded_1rec.s_last_name;
1967: fnd_file.put_line(fnd_file.log, l_log_mesg);
1968: --MN 16-Dec-2004 15:25 Log Borrower Name and SS as well.
1969: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_SSN') ||' : '||loaded_1rec.b_ssn;
1970: fnd_file.put_line(fnd_file.log, l_log_mesg);
1971: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_FULL_NAME')||' : '

Line 1970: fnd_file.put_line(fnd_file.log, l_log_mesg);

1966: ||loaded_1rec.s_first_name||' '||loaded_1rec.s_last_name;
1967: fnd_file.put_line(fnd_file.log, l_log_mesg);
1968: --MN 16-Dec-2004 15:25 Log Borrower Name and SS as well.
1969: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_SSN') ||' : '||loaded_1rec.b_ssn;
1970: fnd_file.put_line(fnd_file.log, l_log_mesg);
1971: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_FULL_NAME')||' : '
1972: ||loaded_1rec.b_first_name||' '||loaded_1rec.b_last_name;
1973: fnd_file.put_line(fnd_file.log, l_log_mesg);
1974: --

Line 1973: fnd_file.put_line(fnd_file.log, l_log_mesg);

1969: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_SSN') ||' : '||loaded_1rec.b_ssn;
1970: fnd_file.put_line(fnd_file.log, l_log_mesg);
1971: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_FULL_NAME')||' : '
1972: ||loaded_1rec.b_first_name||' '||loaded_1rec.b_last_name;
1973: fnd_file.put_line(fnd_file.log, l_log_mesg);
1974: --
1975: -- Delete records from Edit Report table with type="R" (Rejections) for this Loan Number
1976: --
1977: gv_debug_str := gv_debug_str || 'MAIN - 5' || ' ';

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

2030: END LOOP;
2031: FOR rej_rec IN c_reject('R') LOOP
2032: IF lb_print_mess THEN
2033: fnd_message.set_name('IGF','IGF_SL_CL_PRIN_REJ_DT');
2034: fnd_file.new_line(fnd_file.log,1);
2035: fnd_file.put_line(fnd_file.log,fnd_message.get);
2036: lb_rejected_rec := TRUE;
2037: END IF;
2038: lb_print_mess := FALSE;

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

2031: FOR rej_rec IN c_reject('R') LOOP
2032: IF lb_print_mess THEN
2033: fnd_message.set_name('IGF','IGF_SL_CL_PRIN_REJ_DT');
2034: fnd_file.new_line(fnd_file.log,1);
2035: fnd_file.put_line(fnd_file.log,fnd_message.get);
2036: lb_rejected_rec := TRUE;
2037: END IF;
2038: lb_print_mess := FALSE;
2039: gv_debug_str := gv_debug_str || 'MAIN - 10' || ' ';

Line 2040: fnd_file.put_line(fnd_file.log,' '||rej_rec.reject_desc);

2036: lb_rejected_rec := TRUE;
2037: END IF;
2038: lb_print_mess := FALSE;
2039: gv_debug_str := gv_debug_str || 'MAIN - 10' || ' ';
2040: fnd_file.put_line(fnd_file.log,' '||rej_rec.reject_desc);
2041: gv_debug_str := '';
2042: END LOOP;
2043: --
2044: -- Call Procedure to update the LOR Table

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

2047: gv_debug_str := gv_debug_str || 'MAIN - 11' || ' ';
2048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);
2050: END IF;
2051: fnd_file.new_line(fnd_file.log,1);
2052: update_lor(loaded_1rec.clrp1_id,l_loan_number,lb_rejected_rec);
2053: gv_debug_str := '';
2054: --
2055: -- Update the all the Response Record Status to 'Y'

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

2374: lb_info_change := TRUE;
2375: fnd_message.set_name('IGF','IGF_SL_CL_LEND_CHG_UPD');
2376: fnd_message.set_token('LOR_LEND_CODE',tbh_rec.lender_id);
2377: fnd_message.set_token('ACK_FILE_LEND',lv_lender_id);
2378: fnd_file.put_line(fnd_file.log,fnd_message.get);
2379:
2380: tbh_rec.lender_id := lv_lender_id;
2381: tbh_rec.borw_lender_id := lv_lender_id;
2382:

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

2387: lb_info_change := TRUE;
2388: fnd_message.set_name('IGF','IGF_SL_CL_GURANT_CHG_UPD');
2389: fnd_message.set_token('LOR_GUARN_CODE',tbh_rec.guarantor_id);
2390: fnd_message.set_token('ACK_FILE_GUARN',lv_guarant_id);
2391: fnd_file.put_line(fnd_file.log,fnd_message.get);
2392:
2393: tbh_rec.guarantor_id := lv_guarant_id;
2394:
2395: END IF;

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

2397: lb_info_change := TRUE;
2398: fnd_message.set_name('IGF','IGF_SL_CL_LNDBR_CHG_UPD');
2399: fnd_message.set_token('LOR_LNBR_CODE',NVL(tbh_rec.lend_non_ed_brc_id,'NULL'));
2400: fnd_message.set_token('ACK_FILE_BRC',NVL(lv_lend_non_ed_id,'NULL'));
2401: fnd_file.put_line(fnd_file.log,fnd_message.get);
2402:
2403: tbh_rec.lend_non_ed_brc_id := lv_lend_non_ed_id;
2404:
2405: END IF;

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

2410: --
2411: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_RECIP_INFO');
2412: fnd_message.set_token('RECIP',lv_recipient_id);
2413: fnd_message.set_token('BRC_CD',NVL(lv_recip_non_ed_id,'NULL'));
2414: fnd_file.put_line(fnd_file.log,fnd_message.get);
2415:
2416: --
2417: -- Check if record exists for this combination
2418: --

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

2421: IF cur_find_lender%FOUND THEN
2422: CLOSE cur_find_lender;
2423: IF find_lender_rec.enabled = 'N' THEN
2424: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_UPD_EN_FALSE');
2425: fnd_file.put_line(fnd_file.log,fnd_message.get);
2426: fnd_file.new_line(fnd_file.log,1);
2427:
2428: RAISE SKIP_UPDATE_LOANS;
2429: ELSE

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

2422: CLOSE cur_find_lender;
2423: IF find_lender_rec.enabled = 'N' THEN
2424: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_UPD_EN_FALSE');
2425: fnd_file.put_line(fnd_file.log,fnd_message.get);
2426: fnd_file.new_line(fnd_file.log,1);
2427:
2428: RAISE SKIP_UPDATE_LOANS;
2429: ELSE
2430: --

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

2434: FETCH cur_find_rel_code INTO find_rel_code_rec;
2435: IF cur_find_rel_code%FOUND THEN
2436: CLOSE cur_find_rel_code;
2437: fnd_message.set_name('IGF','IGF_SL_CL_LEND_INFO_UPD');
2438: fnd_file.put_line(fnd_file.log,fnd_message.get);
2439: fnd_file.new_line(fnd_file.log,1);
2440: tbh_rec.relationship_cd := find_lender_rec.relationship_cd;
2441: ELSIF cur_find_rel_code%NOTFOUND THEN
2442: CLOSE cur_find_rel_code;

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

2435: IF cur_find_rel_code%FOUND THEN
2436: CLOSE cur_find_rel_code;
2437: fnd_message.set_name('IGF','IGF_SL_CL_LEND_INFO_UPD');
2438: fnd_file.put_line(fnd_file.log,fnd_message.get);
2439: fnd_file.new_line(fnd_file.log,1);
2440: tbh_rec.relationship_cd := find_lender_rec.relationship_cd;
2441: ELSIF cur_find_rel_code%NOTFOUND THEN
2442: CLOSE cur_find_rel_code;
2443: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_LND_AY_NOTFND');

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

2442: CLOSE cur_find_rel_code;
2443: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_LND_AY_NOTFND');
2444: fnd_message.set_token('REL_CODE',find_lender_rec.relationship_cd);
2445: fnd_message.set_token('AWD_YR',tbh_rec.ci_alternate_code);
2446: fnd_file.put_line(fnd_file.log,fnd_message.get);
2447: fnd_file.new_line(fnd_file.log,1);
2448: RAISE SKIP_UPDATE_LOANS;
2449: END IF;
2450: END IF;

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

2443: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_LND_AY_NOTFND');
2444: fnd_message.set_token('REL_CODE',find_lender_rec.relationship_cd);
2445: fnd_message.set_token('AWD_YR',tbh_rec.ci_alternate_code);
2446: fnd_file.put_line(fnd_file.log,fnd_message.get);
2447: fnd_file.new_line(fnd_file.log,1);
2448: RAISE SKIP_UPDATE_LOANS;
2449: END IF;
2450: END IF;
2451: ELSIF cur_find_lender%NOTFOUND THEN

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

2451: ELSIF cur_find_lender%NOTFOUND THEN
2452: CLOSE cur_find_lender;
2453:
2454: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_LND_NOTFND');
2455: fnd_file.put_line(fnd_file.log,fnd_message.get);
2456: fnd_file.new_line(fnd_file.log,1);
2457:
2458: RAISE SKIP_UPDATE_LOANS;
2459: END IF;

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

2452: CLOSE cur_find_lender;
2453:
2454: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_LND_NOTFND');
2455: fnd_file.put_line(fnd_file.log,fnd_message.get);
2456: fnd_file.new_line(fnd_file.log,1);
2457:
2458: RAISE SKIP_UPDATE_LOANS;
2459: END IF;
2460: END IF;

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

2611: IF loaded_1rec.rec_type_ind = 'S' THEN
2612: IF (rec_c_igf_sl_loans.loan_status <> 'S') THEN
2613: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_SENT');
2614: fnd_message.set_token('LOAN_STATUS',rec_c_igf_sl_loans.loan_status);
2615: fnd_file.put_line(fnd_file.log, fnd_message.get);
2616: log_to_fnd(p_v_module => 'UPDATE_LOR',
2617: p_v_string => ' loan status <> S'
2618: );
2619: RAISE skip_update_loans;

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

2622: (tbh_rec.rec_type_ind IN ('A','C','T')) ) THEN
2623: NULL;
2624: ELSE
2625: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_RT_RC');
2626: fnd_file.put_line(fnd_file.log, fnd_message.get);
2627: log_to_fnd(p_v_module => 'UPDATE_LOR',
2628: p_v_string => ' loan status <> S and lor rec_type_ind NOT IN (A,C,T)'
2629: );
2630: RAISE skip_update_loans;

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

2631: END IF;
2632: END IF;
2633: IF loaded_1rec.rec_type_ind = 'X' THEN
2634: fnd_message.set_name('IGF','IGF_SL_CL_CHG_X_SPRT');
2635: fnd_file.put_line(fnd_file.log, fnd_message.get);
2636: log_to_fnd(p_v_module => 'UPDATE_LOR',
2637: p_v_string => ' Response Record type = X'
2638: );
2639: RAISE skip_update_loans;

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

2647: IF ((rec_c_igf_sl_loans.loan_status = 'A') AND (rec_c_igf_sl_loans.loan_chg_status = 'S')) THEN
2648: NULL;
2649: ELSE
2650: fnd_message.set_name('IGF','IGF_SL_CL_CHG_ST_SE_ACC');
2651: fnd_file.put_line(fnd_file.log, fnd_message.get);
2652: log_to_fnd(p_v_module => 'UPDATE_LOR',
2653: p_v_string => ' R Record cannot be uploaded into the system. '||
2654: ' Loan status is not Accepted and Loan change status is not sent'
2655: );

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

2661: IF loaded_1rec.rec_type_ind = 'N' THEN
2662: IF (rec_c_igf_sl_loans.loan_status <> 'S') THEN
2663: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_SENT');
2664: fnd_message.set_token('LOAN_STATUS',rec_c_igf_sl_loans.loan_status);
2665: fnd_file.put_line(fnd_file.log, fnd_message.get);
2666: log_to_fnd(p_v_module => 'UPDATE_LOR',
2667: p_v_string => ' loan status <> S'
2668: );
2669: RAISE skip_update_loans;

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

2674: NULL;
2675: ELSE
2676: -- bvisvana - Bug # 4168692 - IGF_SL_CL_INV_COMB_RT_RC changed to IGF_SL_CL_INV_COMB_PT_RC
2677: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');
2678: fnd_file.put_line(fnd_file.log, fnd_message.get);
2679: log_to_fnd(p_v_module => 'UPDATE_LOR',
2680: p_v_string => ' loan status <> S and lor rec_type_ind NOT IN (A,C,T)'
2681: );
2682: RAISE skip_update_loans;

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

2684: END IF;
2685: IF loaded_1rec.rec_type_ind = 'M' THEN
2686: IF tbh_rec.rec_type_ind NOT IN ('A','C') THEN
2687: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_RT_RC');
2688: fnd_file.put_line(fnd_file.log, fnd_message.get);
2689: log_to_fnd(p_v_module => 'UPDATE_LOR',
2690: p_v_string => ' send record type not in A and C'
2691: );
2692: RAISE skip_update_loans;

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

2692: RAISE skip_update_loans;
2693: END IF;
2694: IF (rec_c_igf_sl_loans.loan_status NOT IN ('A','S')) THEN
2695: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_SENT_M');
2696: fnd_file.put_line(fnd_file.log, fnd_message.get);
2697: log_to_fnd(p_v_module => 'UPDATE_LOR',
2698: p_v_string => ' loan status <> S'
2699: );
2700: RAISE skip_update_loans;

Line 2717: fnd_file.put_line(fnd_file.log, lv_log_mesg);

2713:
2714: IF loaded_1rec.fed_appl_form_code IN ('Q','G') THEN
2715: IF(loaded_1rec.defer_req_code IS NOT NULL) THEN
2716: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DEFER_REQ_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');
2717: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2718: lv_defer_req_code := NULL;
2719: END IF;
2720: IF(loaded_1rec.s_signature_code IS NOT NULL) THEN
2721: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SIGNATURE_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');

Line 2722: fnd_file.put_line(fnd_file.log, lv_log_mesg);

2718: lv_defer_req_code := NULL;
2719: END IF;
2720: IF(loaded_1rec.s_signature_code IS NOT NULL) THEN
2721: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SIGNATURE_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');
2722: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2723: lv_s_signature_code := NULL;
2724: END IF;
2725: IF(loaded_1rec.stud_sign_ind IS NOT NULL) THEN
2726: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_ESIGN_IND_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');

Line 2727: fnd_file.put_line(fnd_file.log, lv_log_mesg);

2723: lv_s_signature_code := NULL;
2724: END IF;
2725: IF(loaded_1rec.stud_sign_ind IS NOT NULL) THEN
2726: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_ESIGN_IND_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');
2727: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2728: lv_stud_sign_ind := NULL;
2729: END IF;
2730: END IF; -- loaded_1rec.fed_appl_form_code = 'Q'
2731:

Line 2735: fnd_file.put_line(fnd_file.log, lv_log_mesg);

2731:
2732: IF loaded_1rec.fed_appl_form_code = 'M' THEN
2733: IF(loaded_1rec.defer_req_code IS NOT NULL) THEN
2734: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DEFER_REQ_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');
2735: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2736: lv_defer_req_code := NULL;
2737: END IF;
2738: END IF; -- loaded_1rec.fed_appl_form_code = 'M'
2739: END IF;

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

3110: gv_debug_str := gv_debug_str || 'UPDATE_LOR-16' || ' ';
3111: l_loan_status:='A';
3112: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');
3113: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3114: fnd_file.put_line(fnd_file.log,fnd_message.get);
3115: fnd_file.new_line(fnd_file.log,1);
3116: log_to_fnd(p_v_module => 'update_lor',
3117: p_v_string => ' Loan is Accepted'
3118: );

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

3111: l_loan_status:='A';
3112: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');
3113: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3114: fnd_file.put_line(fnd_file.log,fnd_message.get);
3115: fnd_file.new_line(fnd_file.log,1);
3116: log_to_fnd(p_v_module => 'update_lor',
3117: p_v_string => ' Loan is Accepted'
3118: );
3119:

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

3125: gv_debug_str := gv_debug_str || 'UPDATE_LOR-17' || ' ';
3126: l_loan_status:='R';
3127: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');
3128: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3129: fnd_file.put_line(fnd_file.log,fnd_message.get);
3130: fnd_file.new_line(fnd_file.log,1);
3131: log_to_fnd(p_v_module => 'update_lor',
3132: p_v_string => ' Loan is Rejected'
3133: );

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

3126: l_loan_status:='R';
3127: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');
3128: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3129: fnd_file.put_line(fnd_file.log,fnd_message.get);
3130: fnd_file.new_line(fnd_file.log,1);
3131: log_to_fnd(p_v_module => 'update_lor',
3132: p_v_string => ' Loan is Rejected'
3133: );
3134:

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

3138: -- Loan is Terminated
3139: l_loan_status:='T';
3140: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');
3141: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3142: fnd_file.put_line(fnd_file.log,fnd_message.get);
3143: fnd_file.new_line(fnd_file.log,1);
3144: gv_debug_str := gv_debug_str || 'UPDATE_LOR-18' || ' ';
3145:
3146: END IF;

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

3139: l_loan_status:='T';
3140: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');
3141: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3142: fnd_file.put_line(fnd_file.log,fnd_message.get);
3143: fnd_file.new_line(fnd_file.log,1);
3144: gv_debug_str := gv_debug_str || 'UPDATE_LOR-18' || ' ';
3145:
3146: END IF;
3147: END IF; -- End of Condition of 'GP'

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

3150: tbh_rec.lend_status_code = '45') THEN
3151: l_loan_status := 'A';
3152: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');
3153: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3154: fnd_file.put_line(fnd_file.log,fnd_message.get);
3155: fnd_file.new_line(fnd_file.log,1);
3156: log_to_fnd(p_v_module => 'update_lor',
3157: p_v_string => ' Loan is Accepted'
3158: );

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

3151: l_loan_status := 'A';
3152: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');
3153: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3154: fnd_file.put_line(fnd_file.log,fnd_message.get);
3155: fnd_file.new_line(fnd_file.log,1);
3156: log_to_fnd(p_v_module => 'update_lor',
3157: p_v_string => ' Loan is Accepted'
3158: );
3159: END IF;

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

3161: tbh_rec.lend_status_code IN ('25','35')) THEN
3162: l_loan_status:='R';
3163: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');
3164: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3165: fnd_file.put_line(fnd_file.log,fnd_message.get);
3166: fnd_file.new_line(fnd_file.log,1);
3167: log_to_fnd(p_v_module => 'update_lor',
3168: p_v_string => ' Loan is Rejected'
3169: );

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

3162: l_loan_status:='R';
3163: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');
3164: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3165: fnd_file.put_line(fnd_file.log,fnd_message.get);
3166: fnd_file.new_line(fnd_file.log,1);
3167: log_to_fnd(p_v_module => 'update_lor',
3168: p_v_string => ' Loan is Rejected'
3169: );
3170: END IF;

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

3172: -- Loan is Terminated
3173: l_loan_status:='T';
3174: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');
3175: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3176: fnd_file.put_line(fnd_file.log,fnd_message.get);
3177: fnd_file.new_line(fnd_file.log,1);
3178: log_to_fnd(p_v_module => 'update_lor',
3179: p_v_string => ' Loan is Terminated'
3180: );

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

3173: l_loan_status:='T';
3174: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');
3175: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3176: fnd_file.put_line(fnd_file.log,fnd_message.get);
3177: fnd_file.new_line(fnd_file.log,1);
3178: log_to_fnd(p_v_module => 'update_lor',
3179: p_v_string => ' Loan is Terminated'
3180: );
3181: END IF;

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

3187: IF ((loaded_1rec.prc_type_code='GP') AND (loaded_1rec.cl_rec_status in ('B', 'G'))) THEN
3188: l_loan_status := 'A';
3189: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');
3190: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3191: fnd_file.put_line(fnd_file.log,fnd_message.get);
3192: fnd_file.new_line(fnd_file.log,1);
3193: log_to_fnd(p_v_module => 'update_lor',
3194: p_v_string => ' Loan is Accepted'
3195: );

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

3188: l_loan_status := 'A';
3189: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');
3190: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3191: fnd_file.put_line(fnd_file.log,fnd_message.get);
3192: fnd_file.new_line(fnd_file.log,1);
3193: log_to_fnd(p_v_module => 'update_lor',
3194: p_v_string => ' Loan is Accepted'
3195: );
3196: END IF;

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

3198: IF ((loaded_1rec.prc_type_code='GO') AND (loaded_1rec.cl_rec_status in ('B', 'G'))) THEN
3199: l_loan_status := 'A';
3200: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');
3201: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3202: fnd_file.put_line(fnd_file.log,fnd_message.get);
3203: fnd_file.new_line(fnd_file.log,1);
3204: log_to_fnd(p_v_module => 'update_lor',
3205: p_v_string => ' Loan is Accepted'
3206: );

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

3199: l_loan_status := 'A';
3200: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');
3201: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3202: fnd_file.put_line(fnd_file.log,fnd_message.get);
3203: fnd_file.new_line(fnd_file.log,1);
3204: log_to_fnd(p_v_module => 'update_lor',
3205: p_v_string => ' Loan is Accepted'
3206: );
3207: END IF;

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

3208: IF ((loaded_1rec.prc_type_code='GP') AND (loaded_1rec.cl_rec_status = 'D')) THEN
3209: l_loan_status:='R';
3210: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');
3211: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3212: fnd_file.put_line(fnd_file.log,fnd_message.get);
3213: fnd_file.new_line(fnd_file.log,1);
3214: log_to_fnd(p_v_module => 'update_lor',
3215: p_v_string => ' Loan is Rejected'
3216: );

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

3209: l_loan_status:='R';
3210: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');
3211: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3212: fnd_file.put_line(fnd_file.log,fnd_message.get);
3213: fnd_file.new_line(fnd_file.log,1);
3214: log_to_fnd(p_v_module => 'update_lor',
3215: p_v_string => ' Loan is Rejected'
3216: );
3217: END IF;

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

3218: IF ((loaded_1rec.prc_type_code='GO') AND (loaded_1rec.cl_rec_status = 'D')) THEN
3219: l_loan_status:='R';
3220: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');
3221: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3222: fnd_file.put_line(fnd_file.log,fnd_message.get);
3223: fnd_file.new_line(fnd_file.log,1);
3224: log_to_fnd(p_v_module => 'update_lor',
3225: p_v_string => ' Loan is rejected'
3226: );

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

3219: l_loan_status:='R';
3220: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');
3221: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3222: fnd_file.put_line(fnd_file.log,fnd_message.get);
3223: fnd_file.new_line(fnd_file.log,1);
3224: log_to_fnd(p_v_module => 'update_lor',
3225: p_v_string => ' Loan is rejected'
3226: );
3227: END IF;

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

3229: -- Loan is Terminated
3230: l_loan_status:='T';
3231: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');
3232: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3233: fnd_file.put_line(fnd_file.log,fnd_message.get);
3234: fnd_file.new_line(fnd_file.log,1);
3235: log_to_fnd(p_v_module => 'update_lor',
3236: p_v_string => ' Loan is Terminated'
3237: );

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

3230: l_loan_status:='T';
3231: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');
3232: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);
3233: fnd_file.put_line(fnd_file.log,fnd_message.get);
3234: fnd_file.new_line(fnd_file.log,1);
3235: log_to_fnd(p_v_module => 'update_lor',
3236: p_v_string => ' Loan is Terminated'
3237: );
3238: END IF;

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

3475: ||RPAD('-',30,'-')
3476: ||RPAD('-',35,'-');
3477: END IF;
3478:
3479: fnd_file.put_line(fnd_file.log,' ');
3480: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3481: fnd_file.put_line(fnd_file.log,p_disb_title);
3482: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3483: --To show the Disbursement Details in OFA

Line 3480: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));

3476: ||RPAD('-',35,'-');
3477: END IF;
3478:
3479: fnd_file.put_line(fnd_file.log,' ');
3480: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3481: fnd_file.put_line(fnd_file.log,p_disb_title);
3482: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3483: --To show the Disbursement Details in OFA
3484:

Line 3481: fnd_file.put_line(fnd_file.log,p_disb_title);

3477: END IF;
3478:
3479: fnd_file.put_line(fnd_file.log,' ');
3480: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3481: fnd_file.put_line(fnd_file.log,p_disb_title);
3482: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3483: --To show the Disbursement Details in OFA
3484:
3485: FOR OFA_disb IN cur_old_disbursements

Line 3482: fnd_file.put_line(fnd_file.log,p_disb_under_line);

3478:
3479: fnd_file.put_line(fnd_file.log,' ');
3480: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3481: fnd_file.put_line(fnd_file.log,p_disb_title);
3482: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3483: --To show the Disbursement Details in OFA
3484:
3485: FOR OFA_disb IN cur_old_disbursements
3486: LOOP

Line 3487: fnd_file.put_line(fnd_file.log,

3483: --To show the Disbursement Details in OFA
3484:
3485: FOR OFA_disb IN cur_old_disbursements
3486: LOOP
3487: fnd_file.put_line(fnd_file.log,
3488: LPAD(TO_CHAR(OFA_disb.disb_num),30)
3489: ||LPAD(fnd_date.date_to_displaydate(OFA_disb.disb_date),30)
3490: ||LPAD(TO_CHAR(OFA_disb.disb_accepted_amt),30) -- disb gorss amt changed to disb accepted amt
3491: ||LPAD(TO_CHAR(OFA_disb.fee_1),30)

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

3496: ||LPAD(OFA_disb.direct_to_borr_flag,30));
3497: END LOOP;
3498:
3499: --To show the Disbursement details in File
3500: fnd_file.put_line(fnd_file.log,' ');
3501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3502: fnd_file.put_line(fnd_file.log,p_disb_title);
3503: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3504:

Line 3501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));

3497: END LOOP;
3498:
3499: --To show the Disbursement details in File
3500: fnd_file.put_line(fnd_file.log,' ');
3501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3502: fnd_file.put_line(fnd_file.log,p_disb_title);
3503: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3504:
3505: FOR LOC_disb IN cur_new_disbursements('N')

Line 3502: fnd_file.put_line(fnd_file.log,p_disb_title);

3498:
3499: --To show the Disbursement details in File
3500: fnd_file.put_line(fnd_file.log,' ');
3501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3502: fnd_file.put_line(fnd_file.log,p_disb_title);
3503: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3504:
3505: FOR LOC_disb IN cur_new_disbursements('N')
3506: LOOP

Line 3503: fnd_file.put_line(fnd_file.log,p_disb_under_line);

3499: --To show the Disbursement details in File
3500: fnd_file.put_line(fnd_file.log,' ');
3501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3502: fnd_file.put_line(fnd_file.log,p_disb_title);
3503: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3504:
3505: FOR LOC_disb IN cur_new_disbursements('N')
3506: LOOP
3507: fnd_file.put_line(fnd_file.log,

Line 3507: fnd_file.put_line(fnd_file.log,

3503: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3504:
3505: FOR LOC_disb IN cur_new_disbursements('N')
3506: LOOP
3507: fnd_file.put_line(fnd_file.log,
3508: LPAD(TO_CHAR(LOC_disb.clrp8_id),30)
3509: ||LPAD(fnd_date.date_to_displaydate(LOC_disb.disb_date),30)
3510: ||LPAD(TO_CHAR(LOC_disb.disb_gross_amt),30)
3511: ||LPAD(TO_CHAR(LOC_disb.orig_fee),30)

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

3613: END IF;
3614: END LOOP;
3615: END LOOP;
3616: -- Display the information now
3617: fnd_file.put_line(fnd_file.log,' ');
3618: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3619: fnd_file.put_line(fnd_file.log,l_disb_title);
3620: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3621:

Line 3618: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));

3614: END LOOP;
3615: END LOOP;
3616: -- Display the information now
3617: fnd_file.put_line(fnd_file.log,' ');
3618: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3619: fnd_file.put_line(fnd_file.log,l_disb_title);
3620: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3621:
3622: FOR i IN 1..counter LOOP

Line 3619: fnd_file.put_line(fnd_file.log,l_disb_title);

3615: END LOOP;
3616: -- Display the information now
3617: fnd_file.put_line(fnd_file.log,' ');
3618: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3619: fnd_file.put_line(fnd_file.log,l_disb_title);
3620: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3621:
3622: FOR i IN 1..counter LOOP
3623: fnd_file.put_line(fnd_file.log,awd_disb_array(i));

Line 3620: fnd_file.put_line(fnd_file.log,l_disb_under_line);

3616: -- Display the information now
3617: fnd_file.put_line(fnd_file.log,' ');
3618: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3619: fnd_file.put_line(fnd_file.log,l_disb_title);
3620: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3621:
3622: FOR i IN 1..counter LOOP
3623: fnd_file.put_line(fnd_file.log,awd_disb_array(i));
3624: END LOOP;

Line 3623: fnd_file.put_line(fnd_file.log,awd_disb_array(i));

3619: fnd_file.put_line(fnd_file.log,l_disb_title);
3620: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3621:
3622: FOR i IN 1..counter LOOP
3623: fnd_file.put_line(fnd_file.log,awd_disb_array(i));
3624: END LOOP;
3625:
3626: fnd_file.put_line(fnd_file.log,' ');
3627: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));

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

3622: FOR i IN 1..counter LOOP
3623: fnd_file.put_line(fnd_file.log,awd_disb_array(i));
3624: END LOOP;
3625:
3626: fnd_file.put_line(fnd_file.log,' ');
3627: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3628: fnd_file.put_line(fnd_file.log,l_disb_title);
3629: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3630:

Line 3627: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));

3623: fnd_file.put_line(fnd_file.log,awd_disb_array(i));
3624: END LOOP;
3625:
3626: fnd_file.put_line(fnd_file.log,' ');
3627: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3628: fnd_file.put_line(fnd_file.log,l_disb_title);
3629: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3630:
3631: FOR i IN 1..counter LOOP

Line 3628: fnd_file.put_line(fnd_file.log,l_disb_title);

3624: END LOOP;
3625:
3626: fnd_file.put_line(fnd_file.log,' ');
3627: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3628: fnd_file.put_line(fnd_file.log,l_disb_title);
3629: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3630:
3631: FOR i IN 1..counter LOOP
3632: fnd_file.put_line(fnd_file.log,loc_disb_array(i));

Line 3629: fnd_file.put_line(fnd_file.log,l_disb_under_line);

3625:
3626: fnd_file.put_line(fnd_file.log,' ');
3627: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3628: fnd_file.put_line(fnd_file.log,l_disb_title);
3629: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3630:
3631: FOR i IN 1..counter LOOP
3632: fnd_file.put_line(fnd_file.log,loc_disb_array(i));
3633: END LOOP;

Line 3632: fnd_file.put_line(fnd_file.log,loc_disb_array(i));

3628: fnd_file.put_line(fnd_file.log,l_disb_title);
3629: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3630:
3631: FOR i IN 1..counter LOOP
3632: fnd_file.put_line(fnd_file.log,loc_disb_array(i));
3633: END LOOP;
3634:
3635: fnd_file.put_line(fnd_file.log,' ');
3636:

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

3631: FOR i IN 1..counter LOOP
3632: fnd_file.put_line(fnd_file.log,loc_disb_array(i));
3633: END LOOP;
3634:
3635: fnd_file.put_line(fnd_file.log,' ');
3636:
3637: END show_differing_disb_details;
3638:
3639: --Procedure to update award disbursments Fee details with values from the File

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

3682:
3683: IF g_c_update_disb_dtls = 'Y' THEN -- Update Flag Check
3684: fnd_message.set_name('IGF','IGF_SL_CL_UPD_DISB_DTLS');
3685: fnd_message.set_token('DISB_NUM',loc_disb.clrp8_id);
3686: fnd_file.put_line(fnd_file.log,fnd_message.get);
3687:
3688: -- Update Flag Check
3689: igf_aw_awd_disb_pkg.update_row (
3690: x_Mode => 'R',

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

3863: --
3864: -- put a message here comparing loc and system data,
3865: -- different number of loc and system disbursements
3866: --
3867: fnd_file.new_line(fnd_file.log,1);
3868: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_DISB_NUM');
3869: fnd_file.put_line(fnd_file.log,fnd_message.get);
3870: fnd_file.new_line(fnd_file.log,1);
3871:

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

3865: -- different number of loc and system disbursements
3866: --
3867: fnd_file.new_line(fnd_file.log,1);
3868: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_DISB_NUM');
3869: fnd_file.put_line(fnd_file.log,fnd_message.get);
3870: fnd_file.new_line(fnd_file.log,1);
3871:
3872: show_disb_details;
3873:

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

3866: --
3867: fnd_file.new_line(fnd_file.log,1);
3868: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_DISB_NUM');
3869: fnd_file.put_line(fnd_file.log,fnd_message.get);
3870: fnd_file.new_line(fnd_file.log,1);
3871:
3872: show_disb_details;
3873:
3874: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 5' ||' ';

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

3919: -- put a message here
3920: -- different amounts
3921: --
3922: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_DISB_AMTS');
3923: fnd_file.new_line(fnd_file.log,1);
3924: fnd_file.put_line(fnd_file.log,fnd_message.get);
3925: fnd_file.new_line(fnd_file.log,1);
3926:
3927: show_disb_details;

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

3920: -- different amounts
3921: --
3922: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_DISB_AMTS');
3923: fnd_file.new_line(fnd_file.log,1);
3924: fnd_file.put_line(fnd_file.log,fnd_message.get);
3925: fnd_file.new_line(fnd_file.log,1);
3926:
3927: show_disb_details;
3928:

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

3921: --
3922: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_DISB_AMTS');
3923: fnd_file.new_line(fnd_file.log,1);
3924: fnd_file.put_line(fnd_file.log,fnd_message.get);
3925: fnd_file.new_line(fnd_file.log,1);
3926:
3927: show_disb_details;
3928:
3929: -- Place Process Holds on All the Disbursement records.

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

4304: END IF;
4305:
4306: --To display the ALt Borrower's Details
4307:
4308: fnd_file.put_line(fnd_file.log, '');
4309:
4310: --To display the Heading for Fields having a difference and also the corresponding data
4311:
4312: IF l_counter <> 0 THEN

Line 4315: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| title_array(17) || title_array(18));

4311:
4312: IF l_counter <> 0 THEN
4313: BEGIN
4314:
4315: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| title_array(17) || title_array(18));
4316: fnd_file.put_line(fnd_file.log, RPAD(' ',5)||RPAD(' ',50)||RPAD('-',34,'-')||' '||RPAD('-',35,'-'));
4317:
4318: FOR i IN 1..l_counter LOOP
4319: fnd_file.put_line(fnd_file.log, RPAD(' ',5)||data_array(i));

Line 4316: fnd_file.put_line(fnd_file.log, RPAD(' ',5)||RPAD(' ',50)||RPAD('-',34,'-')||' '||RPAD('-',35,'-'));

4312: IF l_counter <> 0 THEN
4313: BEGIN
4314:
4315: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| title_array(17) || title_array(18));
4316: fnd_file.put_line(fnd_file.log, RPAD(' ',5)||RPAD(' ',50)||RPAD('-',34,'-')||' '||RPAD('-',35,'-'));
4317:
4318: FOR i IN 1..l_counter LOOP
4319: fnd_file.put_line(fnd_file.log, RPAD(' ',5)||data_array(i));
4320: END LOOP;

Line 4319: fnd_file.put_line(fnd_file.log, RPAD(' ',5)||data_array(i));

4315: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| title_array(17) || title_array(18));
4316: fnd_file.put_line(fnd_file.log, RPAD(' ',5)||RPAD(' ',50)||RPAD('-',34,'-')||' '||RPAD('-',35,'-'));
4317:
4318: FOR i IN 1..l_counter LOOP
4319: fnd_file.put_line(fnd_file.log, RPAD(' ',5)||data_array(i));
4320: END LOOP;
4321:
4322: END;
4323:

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

4940: p_v_string => ' No active SSNs found in the System. creating person record'
4941: );
4942: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_NOFOUND');
4943: fnd_message.set_token('SSN',l_v_ssn);
4944: fnd_file.put_line(fnd_file.log, fnd_message.get);
4945: p_n_person_id := NULL;
4946: p_n_person_number := NULL;
4947: p_c_pers_exists := FALSE;
4948: RETURN;

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

4965: p_c_pers_exists := TRUE;
4966: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_FOUND');
4967: fnd_message.set_token('SSN',l_v_ssn);
4968: fnd_message.set_token('PERSON_NUMBER',p_n_person_number);
4969: fnd_file.put_line(fnd_file.log, fnd_message.get);
4970: EXIT;
4971: END IF;
4972: END LOOP;
4973:

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

5045: log_to_fnd(p_v_module => 'create_person_record',
5046: p_v_string => ' Alternate Person ID of type SSN is not setup. Unable to create SSN record for the student.'
5047: );
5048: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_FAIL');
5049: fnd_file.put_line(fnd_file.log, fnd_message.get);
5050: log_to_fnd(p_v_module => 'create_person_record',
5051: p_v_string => ' Person creation failed '
5052: );
5053: p_n_person_id := NULL;

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

5145: );
5146:
5147: IF l_v_return_status <> 'S' THEN
5148: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_FAIL');
5149: fnd_file.put_line(fnd_file.log, fnd_message.get);
5150: log_to_fnd(p_v_module => 'create_person_record',
5151: p_v_string => ' Person creation failed '
5152: );
5153: p_n_person_id := NULL;

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

5155: RETURN FALSE;
5156: END IF;
5157: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_SUC');
5158: fnd_message.set_token('PERSON_NUMBER',l_v_person_number);
5159: fnd_file.put_line(fnd_file.log, fnd_message.get);
5160: log_to_fnd(p_v_module => 'create_person_record',
5161: p_v_string => ' Person created, Person Number '||l_v_person_number
5162: );
5163: -- If Person is created successfully then create Address Information

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

5320: -- if address creation failed
5321: IF l_v_return_status IN ('E','U') THEN
5322: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_ADD_FAIL');
5323: fnd_message.set_token('PERSON_NUMBER',l_v_person_number);
5324: fnd_file.put_line(fnd_file.log, fnd_message.get);
5325: log_to_fnd(p_v_module => 'create_person_addr_record',
5326: p_v_string => ' Person address creation failed '
5327: );
5328: RETURN FALSE;

Line 5331: fnd_file.put_line(fnd_file.log, l_v_msg_data);

5327: );
5328: RETURN FALSE;
5329: -- bug 5348743
5330: ELSIF l_v_return_status = 'W' THEN
5331: fnd_file.put_line(fnd_file.log, l_v_msg_data);
5332: log_to_fnd(p_v_module => 'create_person_addr_record',
5333: p_v_string => ' Person address creation warning '
5334: );
5335: ELSE

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

5335: ELSE
5336: -- person address created successfully
5337: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_ADD_SUC');
5338: fnd_message.set_token('PERSON_NUMBER',l_v_person_number);
5339: fnd_file.put_line(fnd_file.log, fnd_message.get);
5340: log_to_fnd(p_v_module => 'create_person_addr_record',
5341: p_v_string => ' Person address created, Person Number '||l_v_person_number
5342: );
5343: END IF;

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

5563: CLOSE c_get_relationship;
5564: fnd_message.set_name('IGF','IGF_SL_CL_SCR_REL_EXSIST');
5565: fnd_message.set_token('PERSON_NUMBER',p_v_borrower_number);
5566: fnd_message.set_token('ST_PERSON_NUM',p_v_student_number);
5567: fnd_file.put_line(fnd_file.log, fnd_message.get);
5568: RETURN FALSE;
5569: ELSE -- Create relationship
5570: CLOSE c_get_relationship;
5571: igs_pe_relationships_pkg.creatupdate_party_relationship(

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

5590: IF (l_v_return_status <> 'S') THEN
5591: fnd_message.set_name('IGF','IGF_SL_CL_SCR_REL_FAIL');
5592: fnd_message.set_token('PERSON_NUMBER',p_v_borrower_number);
5593: fnd_message.set_token('ST_PERSON_NUM',p_v_student_number);
5594: fnd_file.put_line(fnd_file.log, fnd_message.get);
5595: log_to_fnd(p_v_module => 'create_borrow_stud_rel',
5596: p_v_string => ' igs_pe_relationships_pkg.creatupdate_party_relationship failed '
5597: );
5598: RETURN FALSE;

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

5599: END IF;
5600: fnd_message.set_name('IGF','IGF_SL_CL_SCR_REL_SUC');
5601: fnd_message.set_token('PERSON_NUMBER',p_v_borrower_number);
5602: fnd_message.set_token('ST_PERSON_NUM',p_v_student_number);
5603: fnd_file.put_line(fnd_file.log, fnd_message.get);
5604: log_to_fnd(p_v_module => 'create_borrow_stud_rel',
5605: p_v_string => ' igs_pe_relationships_pkg.creatupdate_party_relationship successful. '
5606: );
5607: RETURN TRUE;

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

6790: p_v_string => '|p_n_clrp1_id = ' || p_n_clrp1_id ||
6791: '|p_v_loan_number = ' || p_v_loan_number
6792: );
6793: l_n_clrp1_id := p_n_clrp1_id;
6794: fnd_file.new_line(fnd_file.log,2);
6795: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
6796:
6797: FOR rec_c_sl_clchsn_dtls IN c_sl_clchsn_dtls (cp_v_loan_number => p_v_loan_number) -- sl_cl_chsn_dtls rec processing
6798: LOOP

Line 6795: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));

6791: '|p_v_loan_number = ' || p_v_loan_number
6792: );
6793: l_n_clrp1_id := p_n_clrp1_id;
6794: fnd_file.new_line(fnd_file.log,2);
6795: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
6796:
6797: FOR rec_c_sl_clchsn_dtls IN c_sl_clchsn_dtls (cp_v_loan_number => p_v_loan_number) -- sl_cl_chsn_dtls rec processing
6798: LOOP
6799: -- Missing c_sl_clchrs_dtls means that the change is accepted by the processor

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

6886: );
6887:
6888: END LOOP; -- END sl_cl_chsn_dtls rec processing
6889:
6890: fnd_file.new_line(fnd_file.log,2);
6891: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40));
6892:
6893: END process_change_records;
6894:

Line 6891: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40));

6887:
6888: END LOOP; -- END sl_cl_chsn_dtls rec processing
6889:
6890: fnd_file.new_line(fnd_file.log,2);
6891: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40));
6892:
6893: END process_change_records;
6894:
6895: PROCEDURE log_parameters ( p_v_param_typ IN VARCHAR2,

Line 6916: fnd_file.put_line(fnd_file.log, p_v_param_typ || ' : ' || p_v_param_val );

6912: --Change History:
6913: --Who When What
6914: ------------------------------------------------------------------
6915: BEGIN
6916: fnd_file.put_line(fnd_file.log, p_v_param_typ || ' : ' || p_v_param_val );
6917: END log_parameters;
6918:
6919: END igf_sl_cl_orig_ack;