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_MESSAGE

Line 382: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_HEADER');

378: OPEN cur_Hrecord('CL_ORIG_ACK','@H');
379: FETCH cur_Hrecord INTO Header_rec;
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;

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 397: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_TRAILER');

393: OPEN cur_Trecord('CL_ORIG_ACK','@T');
394: FETCH cur_Trecord INTO l_trailer;
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;

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 420: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_FILE_TYPE');

416: IF p_cl_file_type = 'CL_ORIG_ACK' THEN
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;

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 427: fnd_message.set_name('IGF','IGF_SL_CL_INVALID_CL_VERSION');

423: RAISE batch_exceptions;
424: END IF;
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;

Line 428: fnd_message.set_token('RESP_VER',g_v_cl_version);

424: END IF;
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:

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 434: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_ACK');

430: RAISE batch_exceptions;
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' ||' ';

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 543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

539: END IF;
540: RAISE;
541: WHEN OTHERS THEN
542:
543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
544: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.CL_LOAD_FILE');
545: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
546: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.exception',gv_debug_str||' '|| SQLERRM);
547: END IF;

Line 544: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.CL_LOAD_FILE');

540: RAISE;
541: WHEN OTHERS THEN
542:
543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
544: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.CL_LOAD_FILE');
545: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
546: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.exception',gv_debug_str||' '|| SQLERRM);
547: END IF;
548: gv_debug_str := '';

Line 744: fnd_message.set_name('IGF','IGF_SL_CL_INS_RESP_REC');

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' ||' ';
748: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');

Line 745: fnd_message.set_token('LOAN_NUMBER', l_loan_number);

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' ||' ';
748: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
749: fnd_message.set_token('LOAN_NUMBER',l_loan_number);

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 748: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');

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);
751: fnd_file.new_line(fnd_file.log,1);
752: log_to_fnd(p_v_module => 'process_1_records',

Line 749: fnd_message.set_token('LOAN_NUMBER',l_loan_number);

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);
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 '||

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 769: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_VERSION_PRC');

765: lv_sys_loan_version := '-1';
766: lv_sys_loan_version := igf_sl_award.get_loan_cl_version(p_n_award_id => l_n_award_id);
767: IF lv_sys_loan_version <> g_v_cl_version THEN
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;

Line 770: fnd_message.set_token('RESP_VER',g_v_cl_version);

766: lv_sys_loan_version := igf_sl_award.get_loan_cl_version(p_n_award_id => l_n_award_id);
767: IF lv_sys_loan_version <> g_v_cl_version THEN
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;

Line 771: fnd_message.set_token('SYS_LOAN_VER',lv_sys_loan_version);

767: IF lv_sys_loan_version <> g_v_cl_version THEN
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;

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 782: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_INACTIVE');

778:
779: IF l_loan_active = 'N' THEN
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;

Line 783: fnd_message.set_token('LOAN_NUMBER',l_loan_number);

779: IF l_loan_active = 'N' THEN
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:

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 791: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');

787:
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:

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 833: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');

829: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - cl version is 4 lv_resp_rec_type - ' || lv_resp_rec_type
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:

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 849: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

845: IF ((l_v_rec_type_ind = 'R' AND lv_resp_rec_type <> 'N') OR
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;

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 858: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

854: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - not reprint ';
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 ';

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 866: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

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
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 ';

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 874: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

870: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - not A,C ';
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 ';

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 882: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

878: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - not T ';
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

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 893: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');

889: ELSIF g_v_cl_version = 'RELEASE-5' THEN
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 ';

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 904: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

900: IF ((l_v_rec_type_ind = 'R' AND lv_resp_rec_type <> 'N') OR
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;

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 913: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

909: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 2 ';
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 ';

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 921: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

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
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 ';

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 929: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

925: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 4 ';
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

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 938: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

934: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - Release 5 5 ';
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: */

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 1144: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1140: EXCEPTION
1141: WHEN app_exception.record_lock_exception THEN
1142: RAISE;
1143: WHEN OTHERS THEN
1144: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1145: fnd_message.set_token('NAME','IGF_SL_CL_ACK.PROCESS_1_RECORDS');
1146: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1147: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.exception',gv_debug_str||' '||SQLERRM);
1148: END IF;

Line 1145: fnd_message.set_token('NAME','IGF_SL_CL_ACK.PROCESS_1_RECORDS');

1141: WHEN app_exception.record_lock_exception THEN
1142: RAISE;
1143: WHEN OTHERS THEN
1144: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1145: fnd_message.set_token('NAME','IGF_SL_CL_ACK.PROCESS_1_RECORDS');
1146: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1147: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.exception',gv_debug_str||' '||SQLERRM);
1148: END IF;
1149: gv_debug_str := '';

Line 1690: fnd_message.set_name('IGF','IGF_SL_CL_FORMAT_NOT_SUPP');

1686: END IF;
1687:
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;

Line 1691: fnd_message.set_token('FORMAT',LTRIM(RTRIM(SUBSTR(other_rec.record_data,1,2))));

1687:
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:

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 1749: fnd_message.set_name('IGF','IGF_SL_CL_FORMAT_NOT_SUPP');

1745: v_tab_clchrs_dtls(l_n_ctr_r6).error_message_3_code := LTRIM(RTRIM(SUBSTR(other_rec.record_data,487,3)));
1746: v_tab_clchrs_dtls(l_n_ctr_r6).error_message_4_code := LTRIM(RTRIM(SUBSTR(other_rec.record_data,490,3)));
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:

Line 1750: fnd_message.set_token('FORMAT',LTRIM(RTRIM(SUBSTR(other_rec.record_data,1,2))));

1746: v_tab_clchrs_dtls(l_n_ctr_r6).error_message_4_code := LTRIM(RTRIM(SUBSTR(other_rec.record_data,490,3)));
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

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 1757: fnd_message.set_name('IGF','IGF_SL_CL_FORMAT_NOT_SUPP');

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' || ' ';
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;

Line 1758: fnd_message.set_token('FORMAT',LTRIM(RTRIM(SUBSTR(other_rec.record_data,1,2))));

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' || ' ';
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 := '';

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 1868: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1864: EXCEPTION
1865: WHEN app_exception.record_lock_exception THEN
1866: RAISE;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1869: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP1');
1870: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1871: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.exception',gv_debug_str||' '|| SQLERRM);
1872: END IF;

Line 1869: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP1');

1865: WHEN app_exception.record_lock_exception THEN
1866: RAISE;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1869: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP1');
1870: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1871: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.exception',gv_debug_str||' '|| SQLERRM);
1872: END IF;
1873: gv_debug_str := '';

Line 1958: fnd_message.set_name('IGF','IGF_SL_CL_INS_RESP_REC');

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:
1962: gv_debug_str := gv_debug_str || 'MAIN - 9' || ' ';

Line 1959: fnd_message.set_token('LOAN_NUMBER', l_loan_number);

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:
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;

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 2033: fnd_message.set_name('IGF','IGF_SL_CL_PRIN_REJ_DT');

2029: gv_debug_str := '';
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;

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 2219: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

2215:
2216: WHEN app_exception.record_lock_exception THEN
2217: ROLLBACK;
2218: retcode := 2;
2219: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
2220: igs_ge_msg_stack.conc_exception_hndl;
2221: WHEN OTHERS THEN
2222: ROLLBACK;
2223: RETCODE := 2;

Line 2224: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2220: igs_ge_msg_stack.conc_exception_hndl;
2221: WHEN OTHERS THEN
2222: ROLLBACK;
2223: RETCODE := 2;
2224: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2225: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.PROCESS_ACK');
2226: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2227: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_ack.exception',gv_debug_str||' '|| SQLERRM);
2228: END IF;

Line 2225: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.PROCESS_ACK');

2221: WHEN OTHERS THEN
2222: ROLLBACK;
2223: RETCODE := 2;
2224: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2225: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.PROCESS_ACK');
2226: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2227: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_ack.exception',gv_debug_str||' '|| SQLERRM);
2228: END IF;
2229: gv_debug_str := '';

Line 2230: errbuf := fnd_message.get;

2226: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2227: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_ack.exception',gv_debug_str||' '|| SQLERRM);
2228: END IF;
2229: gv_debug_str := '';
2230: errbuf := fnd_message.get;
2231: igs_ge_msg_stack.conc_exception_hndl;
2232:
2233: END process_ack;
2234:

Line 2375: fnd_message.set_name('IGF','IGF_SL_CL_LEND_CHG_UPD');

2371: IF lv_lender_id IS NOT NULL
2372: AND tbh_rec.lender_id IS NOT NULL
2373: AND (lv_lender_id <> tbh_rec.lender_id) THEN
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:

Line 2376: fnd_message.set_token('LOR_LEND_CODE',tbh_rec.lender_id);

2372: AND tbh_rec.lender_id IS NOT NULL
2373: AND (lv_lender_id <> tbh_rec.lender_id) THEN
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;

Line 2377: fnd_message.set_token('ACK_FILE_LEND',lv_lender_id);

2373: AND (lv_lender_id <> tbh_rec.lender_id) THEN
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;

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 2388: fnd_message.set_name('IGF','IGF_SL_CL_GURANT_CHG_UPD');

2384: IF lv_guarant_id IS NOT NULL
2385: AND tbh_rec.guarantor_id IS NOT NULL
2386: AND(lv_guarant_id <> tbh_rec.guarantor_id) THEN
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:

Line 2389: fnd_message.set_token('LOR_GUARN_CODE',tbh_rec.guarantor_id);

2385: AND tbh_rec.guarantor_id IS NOT NULL
2386: AND(lv_guarant_id <> tbh_rec.guarantor_id) THEN
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;

Line 2390: fnd_message.set_token('ACK_FILE_GUARN',lv_guarant_id);

2386: AND(lv_guarant_id <> tbh_rec.guarantor_id) THEN
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:

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 2398: fnd_message.set_name('IGF','IGF_SL_CL_LNDBR_CHG_UPD');

2394:
2395: END IF;
2396: IF NVL(lv_lend_non_ed_id,'*') <> NVL(tbh_rec.lend_non_ed_brc_id,'*') THEN
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:

Line 2399: fnd_message.set_token('LOR_LNBR_CODE',NVL(tbh_rec.lend_non_ed_brc_id,'NULL'));

2395: END IF;
2396: IF NVL(lv_lend_non_ed_id,'*') <> NVL(tbh_rec.lend_non_ed_brc_id,'*') THEN
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;

Line 2400: fnd_message.set_token('ACK_FILE_BRC',NVL(lv_lend_non_ed_id,'NULL'));

2396: IF NVL(lv_lend_non_ed_id,'*') <> NVL(tbh_rec.lend_non_ed_brc_id,'*') THEN
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:

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 2411: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_RECIP_INFO');

2407: IF lb_info_change THEN
2408: --
2409: -- Print Recipient Information
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:

Line 2412: fnd_message.set_token('RECIP',lv_recipient_id);

2408: --
2409: -- Print Recipient Information
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: --

Line 2413: fnd_message.set_token('BRC_CD',NVL(lv_recip_non_ed_id,'NULL'));

2409: -- Print Recipient Information
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

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 2424: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_UPD_EN_FALSE');

2420: FETCH cur_find_lender INTO find_lender_rec;
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;

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 2437: fnd_message.set_name('IGF','IGF_SL_CL_LEND_INFO_UPD');

2433: OPEN cur_find_rel_code(find_lender_rec.relationship_cd,tbh_rec.ci_cal_type,tbh_rec.ci_sequence_number);
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

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 2443: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_LND_AY_NOTFND');

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');
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);

Line 2444: fnd_message.set_token('REL_CODE',find_lender_rec.relationship_cd);

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');
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;

Line 2445: fnd_message.set_token('AWD_YR',tbh_rec.ci_alternate_code);

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');
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;

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 2454: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_LND_NOTFND');

2450: END IF;
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;

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 2613: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_SENT');

2609:
2610: IF loaded_1rec.cl_version_code = 'RELEASE-5' THEN
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'

Line 2614: fnd_message.set_token('LOAN_STATUS',rec_c_igf_sl_loans.loan_status);

2610: IF loaded_1rec.cl_version_code = 'RELEASE-5' THEN
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: );

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 2625: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_RT_RC');

2621: IF ((rec_c_igf_sl_loans.loan_status = 'S') AND
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: );

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 2634: fnd_message.set_name('IGF','IGF_SL_CL_CHG_X_SPRT');

2630: RAISE skip_update_loans;
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: );

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 2650: fnd_message.set_name('IGF','IGF_SL_CL_CHG_ST_SE_ACC');

2646: IF loaded_1rec.rec_type_ind = 'R' THEN
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'

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 2663: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_SENT');

2659: END IF;
2660: -- common to both RELEASE-4 AND RELEASE-5
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'

Line 2664: fnd_message.set_token('LOAN_STATUS',rec_c_igf_sl_loans.loan_status);

2660: -- common to both RELEASE-4 AND RELEASE-5
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: );

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 2677: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_PT_RC');

2673: loaded_1rec.prc_type_code = 'GP') THEN
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: );

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 2687: fnd_message.set_name('IGF','IGF_SL_CL_INV_COMB_RT_RC');

2683: END IF;
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: );

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 2695: fnd_message.set_name('IGF','IGF_SL_CL_SKIP_SENT_M');

2691: );
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: );

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 3112: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');

3108: AND tbh_rec.crdt_decision_status IN ('05','35')) THEN
3109: -- Loan is Accepted
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',

Line 3113: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3109: -- Loan is Accepted
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'

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 3127: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');

3123:
3124: -- Loan is Rejected
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',

Line 3128: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3124: -- Loan is Rejected
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'

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 3140: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');

3136: OR tbh_rec.lend_status_code='30') THEN
3137:
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' || ' ';

Line 3141: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3137:
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:

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 3152: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');

3148: IF loaded_1rec.prc_type_code='GO' THEN
3149: IF ( tbh_rec.guarnt_status_code ='40' AND
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',

Line 3153: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3149: IF ( tbh_rec.guarnt_status_code ='40' AND
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'

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 3163: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');

3159: END IF;
3160: IF (tbh_rec.guarnt_status_code ='30'OR
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',

Line 3164: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3160: IF (tbh_rec.guarnt_status_code ='30'OR
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'

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 3174: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');

3170: END IF;
3171: IF (tbh_rec.guarnt_status_code = '35') THEN
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',

Line 3175: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3171: IF (tbh_rec.guarnt_status_code = '35') THEN
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'

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 3189: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');

3185: IF loaded_1rec.cl_version_code = 'RELEASE-4' THEN
3186: --MN 16-Dec-2004 15:27 Both G and B to be treated as Accepted for GP requests.
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',

Line 3190: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3186: --MN 16-Dec-2004 15:27 Both G and B to be treated as Accepted for GP requests.
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'

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 3200: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_ACC');

3196: END IF;
3197: --MN 16-Dec-2004 15:27 Both G and B to be treated as Accepted for GO requests.
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',

Line 3201: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3197: --MN 16-Dec-2004 15:27 Both G and B to be treated as Accepted for GO requests.
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'

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 3210: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');

3206: );
3207: END IF;
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',

Line 3211: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3207: END IF;
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'

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 3220: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_REJ');

3216: );
3217: END IF;
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',

Line 3221: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3217: END IF;
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'

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 3231: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_TER');

3227: END IF;
3228: IF ((loaded_1rec.prc_type_code IN ('GO','GP')) AND (loaded_1rec.cl_rec_status = 'T')) THEN
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',

Line 3232: fnd_message.set_token('LOAN_NUMBER',loaded_1rec.loan_number);

3228: IF ((loaded_1rec.prc_type_code IN ('GO','GP')) AND (loaded_1rec.cl_rec_status = 'T')) THEN
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'

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 3294: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3290: WHEN app_exception.record_lock_exception THEN
3291: RAISE;
3292:
3293: WHEN OTHERS THEN
3294: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3295: fnd_message.set_token('NAME','IGF_SL_CL_ACK.UPDATE_LOR');
3296: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.update_lor.exception',gv_debug_str||' '|| SQLERRM);
3298: END IF;

Line 3295: fnd_message.set_token('NAME','IGF_SL_CL_ACK.UPDATE_LOR');

3291: RAISE;
3292:
3293: WHEN OTHERS THEN
3294: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3295: fnd_message.set_token('NAME','IGF_SL_CL_ACK.UPDATE_LOR');
3296: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.update_lor.exception',gv_debug_str||' '|| SQLERRM);
3298: END IF;
3299: gv_debug_str := '';

Line 3684: fnd_message.set_name('IGF','IGF_SL_CL_UPD_DISB_DTLS');

3680: NVL(tbh_rec.direct_to_borr_flag,'*') <> NVL(loc_disb.direct_to_borr_flag,'*')
3681: THEN -- LOR LOC Diff Check
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

Line 3685: fnd_message.set_token('DISB_NUM',loc_disb.clrp8_id);

3681: THEN -- LOR LOC Diff Check
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 (

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 3868: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_DISB_NUM');

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:
3872: show_disb_details;

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 3922: fnd_message.set_name('IGF','IGF_SL_CL_DIFF_DISB_AMTS');

3918: --
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:

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 3959: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3955: WHEN app_exception.record_lock_exception THEN
3956: RAISE;
3957:
3958: WHEN OTHERS THEN
3959: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3960: fnd_message.set_token('NAME','IGF_SL_CL_ACK.COMPARE_DISBURSEMENTS');
3961: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3962: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.exception',gv_debug_str||' '|| SQLERRM);
3963: END IF;

Line 3960: fnd_message.set_token('NAME','IGF_SL_CL_ACK.COMPARE_DISBURSEMENTS');

3956: RAISE;
3957:
3958: WHEN OTHERS THEN
3959: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3960: fnd_message.set_token('NAME','IGF_SL_CL_ACK.COMPARE_DISBURSEMENTS');
3961: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3962: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.exception',gv_debug_str||' '|| SQLERRM);
3963: END IF;
3964: gv_debug_str := '';

Line 4140: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

4136:
4137:
4138: EXCEPTION
4139: WHEN OTHERS THEN
4140: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4141: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP_R4');
4142: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4143: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp_r4.exception',gv_debug_str||' '|| SQLERRM);
4144: END IF;

Line 4141: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP_R4');

4137:
4138: EXCEPTION
4139: WHEN OTHERS THEN
4140: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4141: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP_R4');
4142: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4143: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp_r4.exception',gv_debug_str||' '|| SQLERRM);
4144: END IF;
4145: gv_debug_str := '';

Line 4334: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

4330:
4331: EXCEPTION
4332:
4333: WHEN OTHERS THEN
4334: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4335: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.SHOW_ALT_DETAILS');
4336: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4337: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.show_alt_details.exception',gv_debug_str||' '|| SQLERRM);
4338: END IF;

Line 4335: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.SHOW_ALT_DETAILS');

4331: EXCEPTION
4332:
4333: WHEN OTHERS THEN
4334: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4335: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.SHOW_ALT_DETAILS');
4336: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4337: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.show_alt_details.exception',gv_debug_str||' '|| SQLERRM);
4338: END IF;
4339: gv_debug_str := '';

Line 4942: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_NOFOUND');

4938:
4939: log_to_fnd(p_v_module => 'perform_ssn_match',
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;

Line 4943: fnd_message.set_token('SSN',l_v_ssn);

4939: log_to_fnd(p_v_module => 'perform_ssn_match',
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;

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 4966: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_FOUND');

4962: );
4963: p_n_person_id := v_tab_personid_typ(l_n_cnt);
4964: p_n_person_number := v_tab_personnum_typ(l_n_cnt);
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;

Line 4967: fnd_message.set_token('SSN',l_v_ssn);

4963: p_n_person_id := v_tab_personid_typ(l_n_cnt);
4964: p_n_person_number := v_tab_personnum_typ(l_n_cnt);
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;

Line 4968: fnd_message.set_token('PERSON_NUMBER',p_n_person_number);

4964: p_n_person_number := v_tab_personnum_typ(l_n_cnt);
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;

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 5048: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_FAIL');

5044: IF c_person_id_type%NOTFOUND THEN
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: );

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 5148: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_FAIL');

5144: x_attribute24 => NULL*/
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: );

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 5157: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_SUC');

5153: p_n_person_id := NULL;
5154: p_n_person_number := NULL;
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

Line 5158: fnd_message.set_token('PERSON_NUMBER',l_v_person_number);

5154: p_n_person_number := NULL;
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: );

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 5322: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_ADD_FAIL');

5318: p_status => 'A'
5319: );
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 '

Line 5323: fnd_message.set_token('PERSON_NUMBER',l_v_person_number);

5319: );
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: );

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 5337: fnd_message.set_name('IGF','IGF_SL_CL_SCR_P_ADD_SUC');

5333: p_v_string => ' Person address creation warning '
5334: );
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

Line 5338: fnd_message.set_token('PERSON_NUMBER',l_v_person_number);

5334: );
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: );

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 5564: fnd_message.set_name('IGF','IGF_SL_CL_SCR_REL_EXSIST');

5560: OPEN c_get_relationship (p_n_borrower_id, p_n_student_id);
5561: FETCH c_get_relationship INTO l_relationship;
5562: IF c_get_relationship%FOUND THEN --Relationship exsists.
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;

Line 5565: fnd_message.set_token('PERSON_NUMBER',p_v_borrower_number);

5561: FETCH c_get_relationship INTO l_relationship;
5562: IF c_get_relationship%FOUND THEN --Relationship exsists.
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

Line 5566: fnd_message.set_token('ST_PERSON_NUM',p_v_student_number);

5562: IF c_get_relationship%FOUND THEN --Relationship exsists.
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;

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 5591: fnd_message.set_name('IGF','IGF_SL_CL_SCR_REL_FAIL');

5587: p_object_version_number => l_n_location_ovn
5588: );
5589:
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',

Line 5592: fnd_message.set_token('PERSON_NUMBER',p_v_borrower_number);

5588: );
5589:
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 '

Line 5593: fnd_message.set_token('ST_PERSON_NUM',p_v_student_number);

5589:
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: );

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 5600: fnd_message.set_name('IGF','IGF_SL_CL_SCR_REL_SUC');

5596: p_v_string => ' igs_pe_relationships_pkg.creatupdate_party_relationship failed '
5597: );
5598: RETURN FALSE;
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',

Line 5601: fnd_message.set_token('PERSON_NUMBER',p_v_borrower_number);

5597: );
5598: RETURN FALSE;
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. '

Line 5602: fnd_message.set_token('ST_PERSON_NUM',p_v_student_number);

5598: RETURN FALSE;
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: );

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;