479:
480:
481: BEGIN
482:
483: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
484: lv_recipient_id_found := FALSE;
485: retcode:=0;
486: igf_aw_gen.set_org_id(p_org_id);
487:
533: l_lookup_type := 'IGF_SL_CL_GPLUS';
534: END IF;
535:
536: -- Need to call the CL Validation Process before output of Data
537: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
538: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_cal_type:'||lv_ci_cal_type);
539: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_sequence_number:'||lv_ci_sequence_number);
540: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_number:'||p_loan_number);
541: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_catg:'||p_loan_catg);
534: END IF;
535:
536: -- Need to call the CL Validation Process before output of Data
537: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
538: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_cal_type:'||lv_ci_cal_type);
539: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_sequence_number:'||lv_ci_sequence_number);
540: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_number:'||p_loan_number);
541: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_catg:'||p_loan_catg);
542: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Calling cl_lar_validate');
535:
536: -- Need to call the CL Validation Process before output of Data
537: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
538: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_cal_type:'||lv_ci_cal_type);
539: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_sequence_number:'||lv_ci_sequence_number);
540: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_number:'||p_loan_number);
541: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_catg:'||p_loan_catg);
542: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Calling cl_lar_validate');
543: END IF;
536: -- Need to call the CL Validation Process before output of Data
537: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
538: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_cal_type:'||lv_ci_cal_type);
539: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_sequence_number:'||lv_ci_sequence_number);
540: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_number:'||p_loan_number);
541: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_catg:'||p_loan_catg);
542: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Calling cl_lar_validate');
543: END IF;
544: lv_complete := igf_sl_cl_validation.cl_lar_validate(lv_ci_cal_type,
537: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
538: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_cal_type:'||lv_ci_cal_type);
539: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_sequence_number:'||lv_ci_sequence_number);
540: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_number:'||p_loan_number);
541: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_catg:'||p_loan_catg);
542: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Calling cl_lar_validate');
543: END IF;
544: lv_complete := igf_sl_cl_validation.cl_lar_validate(lv_ci_cal_type,
545: lv_ci_sequence_number,
538: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_cal_type:'||lv_ci_cal_type);
539: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','lv_ci_sequence_number:'||lv_ci_sequence_number);
540: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_number:'||p_loan_number);
541: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_catg:'||p_loan_catg);
542: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Calling cl_lar_validate');
543: END IF;
544: lv_complete := igf_sl_cl_validation.cl_lar_validate(lv_ci_cal_type,
545: lv_ci_sequence_number,
546: p_loan_number,
549: p_school_id,
550: p_base_id
551: );
552:
553: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
554: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Called cl_lar_validate');
555: IF lv_complete THEN
556: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned true');
557: ELSE
550: p_base_id
551: );
552:
553: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
554: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Called cl_lar_validate');
555: IF lv_complete THEN
556: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned true');
557: ELSE
558: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned false');
552:
553: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
554: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Called cl_lar_validate');
555: IF lv_complete THEN
556: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned true');
557: ELSE
558: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned false');
559: END IF;
560: END IF;
554: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Called cl_lar_validate');
555: IF lv_complete THEN
556: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned true');
557: ELSE
558: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned false');
559: END IF;
560: END IF;
561:
562: FOR orec IN cur_recip_dts('V','Y',l_lookup_type,'Y',p_recipient_id) LOOP
559: END IF;
560: END IF;
561:
562: FOR orec IN cur_recip_dts('V','Y',l_lookup_type,'Y',p_recipient_id) LOOP
563: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_lookup_type:' || l_lookup_type);
565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_alternate_code:' || l_alternate_code);
566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'p_loan_number:' || p_loan_number);
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_para_rec(1):' || l_para_rec(1));
560: END IF;
561:
562: FOR orec IN cur_recip_dts('V','Y',l_lookup_type,'Y',p_recipient_id) LOOP
563: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_lookup_type:' || l_lookup_type);
565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_alternate_code:' || l_alternate_code);
566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'p_loan_number:' || p_loan_number);
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_para_rec(1):' || l_para_rec(1));
568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'relatioship code :' || orec.relationship_cd);
561:
562: FOR orec IN cur_recip_dts('V','Y',l_lookup_type,'Y',p_recipient_id) LOOP
563: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_lookup_type:' || l_lookup_type);
565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_alternate_code:' || l_alternate_code);
566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'p_loan_number:' || p_loan_number);
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_para_rec(1):' || l_para_rec(1));
568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'relatioship code :' || orec.relationship_cd);
569: END IF;
562: FOR orec IN cur_recip_dts('V','Y',l_lookup_type,'Y',p_recipient_id) LOOP
563: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_lookup_type:' || l_lookup_type);
565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_alternate_code:' || l_alternate_code);
566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'p_loan_number:' || p_loan_number);
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_para_rec(1):' || l_para_rec(1));
568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'relatioship code :' || orec.relationship_cd);
569: END IF;
570:
563: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_lookup_type:' || l_lookup_type);
565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_alternate_code:' || l_alternate_code);
566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'p_loan_number:' || p_loan_number);
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_para_rec(1):' || l_para_rec(1));
568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'relatioship code :' || orec.relationship_cd);
569: END IF;
570:
571:
564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_lookup_type:' || l_lookup_type);
565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_alternate_code:' || l_alternate_code);
566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'p_loan_number:' || p_loan_number);
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_para_rec(1):' || l_para_rec(1));
568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'relatioship code :' || orec.relationship_cd);
569: END IF;
570:
571:
572: -- Fetch the Recipient Description
574: FETCH cur_recip_desc INTO recip_desc_rec;
575: IF cur_recip_desc%NOTFOUND THEN
576: CLOSE cur_recip_desc;
577: --The recipient information does not exist
578: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient description not found');
580: END IF;
581: fnd_message.set_name('IGF','IGF_SL_RECIP_NOT_FOUND');
582: fnd_message.set_token('REL_CODE',orec.relationship_cd);
575: IF cur_recip_desc%NOTFOUND THEN
576: CLOSE cur_recip_desc;
577: --The recipient information does not exist
578: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient description not found');
580: END IF;
581: fnd_message.set_name('IGF','IGF_SL_RECIP_NOT_FOUND');
582: fnd_message.set_token('REL_CODE',orec.relationship_cd);
583: fnd_file.put_line(fnd_file.log,fnd_message.get);
624: -- On Failure of Concurrent Request
625: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_REQ_FAIL');
626: fnd_message.set_token('NAME',TO_CHAR(lv_request_id));
627: igs_ge_msg_stack.add;
628: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN
629: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Concurrent request failed');
630: END IF;
631: app_exception.raise_exception;
632: ELSE
625: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_REQ_FAIL');
626: fnd_message.set_token('NAME',TO_CHAR(lv_request_id));
627: igs_ge_msg_stack.add;
628: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN
629: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Concurrent request failed');
630: END IF;
631: app_exception.raise_exception;
632: ELSE
633: fnd_file.new_line(fnd_file.log,2);
645: END LOOP;
646:
647: -- In case No Recipient details have been fetched for any of the User Inputs then Need to display a Message in the LOG File
648: IF lv_recipient_id_found = FALSE THEN
649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient Id not found');
651: END IF;
652: fnd_file.new_line(fnd_file.log,2);
653: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
646:
647: -- In case No Recipient details have been fetched for any of the User Inputs then Need to display a Message in the LOG File
648: IF lv_recipient_id_found = FALSE THEN
649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient Id not found');
651: END IF;
652: fnd_file.new_line(fnd_file.log,2);
653: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
654: fnd_file.new_line(fnd_file.log,2);
663: CLOSE cur_recip_dts;
664: END IF;
665: retcode := 2;
666: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
667: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
668: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.cl_originate.exception',SQLERRM);
669: END IF;
670:
671: igs_ge_msg_stack.conc_exception_hndl;
664: END IF;
665: retcode := 2;
666: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
667: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
668: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.cl_originate.exception',SQLERRM);
669: END IF;
670:
671: igs_ge_msg_stack.conc_exception_hndl;
672:
678: retcode := 2;
679: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
680: fnd_message.set_token('NAME','IGF_SL_CL_ORIG.CL_ORIGINATE');
681: errbuf := fnd_message.get;
682: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
683: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.cl_originate.exception',SQLERRM);
684: END IF;
685: igs_ge_msg_stack.conc_exception_hndl;
686:
679: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
680: fnd_message.set_token('NAME','IGF_SL_CL_ORIG.CL_ORIGINATE');
681: errbuf := fnd_message.get;
682: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
683: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.cl_originate.exception',SQLERRM);
684: END IF;
685: igs_ge_msg_stack.conc_exception_hndl;
686:
687: END cl_originate;
737:
738: -- masehgal 08-Jan-2003 # 2593215 Removed redundant calls to acad
739: -- begin/end date fetching functions of SL11B.
740:
741: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Before inserting into igf_sl_lor_loc' );
743: END IF;
744:
745: igf_sl_lor_loc_pkg.insert_row (
738: -- masehgal 08-Jan-2003 # 2593215 Removed redundant calls to acad
739: -- begin/end date fetching functions of SL11B.
740:
741: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Before inserting into igf_sl_lor_loc' );
743: END IF;
744:
745: igf_sl_lor_loc_pkg.insert_row (
746: x_mode => 'R',
943: x_esign_src_typ_cd => loan_rec.esign_src_typ_cd
944:
945: );
946:
947: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
948: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Insertion into igf_sl_lor_loc succeeded' );
949: END IF;
950:
951: EXCEPTION
944:
945: );
946:
947: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
948: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Insertion into igf_sl_lor_loc succeeded' );
949: END IF;
950:
951: EXCEPTION
952:
950:
951: EXCEPTION
952:
953: WHEN app_exception.record_lock_exception THEN
954: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN
955: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.exception', 'Lock row failed' );
956: END IF;
957: RAISE;
958:
951: EXCEPTION
952:
953: WHEN app_exception.record_lock_exception THEN
954: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN
955: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.exception', 'Lock row failed' );
956: END IF;
957: RAISE;
958:
959: WHEN OTHERS THEN
959: WHEN OTHERS THEN
960:
961: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
962: fnd_message.set_token('NAME','IGF_SL_CL_ORIG.INSERT_LOR_LOC_REC');
963: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
964: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.exception',SQLERRM);
965: END IF;
966: igs_ge_msg_stack.add;
967: app_exception.raise_exception;
960:
961: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
962: fnd_message.set_token('NAME','IGF_SL_CL_ORIG.INSERT_LOR_LOC_REC');
963: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
964: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.exception',SQLERRM);
965: END IF;
966: igs_ge_msg_stack.add;
967: app_exception.raise_exception;
968:
1029: ELSE
1030: l_sch_date:=TRUNC(SYSDATE);
1031: END IF;
1032:
1033: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1034: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.update_batch_orig_id.debug', 'Before inserting into igf_sl_lor, loan_id:'||tbh_rec.loan_id);
1035: END IF;
1036: OPEN c_sl_loans (cp_n_loan_id => tbh_rec.loan_id);
1037: FETCH c_sl_loans INTO l_v_ext_loan_id_txt ;
1030: l_sch_date:=TRUNC(SYSDATE);
1031: END IF;
1032:
1033: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1034: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.update_batch_orig_id.debug', 'Before inserting into igf_sl_lor, loan_id:'||tbh_rec.loan_id);
1035: END IF;
1036: OPEN c_sl_loans (cp_n_loan_id => tbh_rec.loan_id);
1037: FETCH c_sl_loans INTO l_v_ext_loan_id_txt ;
1038: CLOSE c_sl_loans ;
1166: x_acad_end_date => tbh_rec.acad_end_date
1167:
1168: );
1169:
1170: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.debug', 'Insertion into igf_sl_lor succeeded, loan_id:'||tbh_rec.loan_id);
1172: END IF;
1173:
1174: END LOOP;
1167:
1168: );
1169:
1170: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.debug', 'Insertion into igf_sl_lor succeeded, loan_id:'||tbh_rec.loan_id);
1172: END IF;
1173:
1174: END LOOP;
1175:
1175:
1176: EXCEPTION
1177:
1178: WHEN app_exception.record_lock_exception THEN
1179: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
1180: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.exception','Record Lock Exception');
1181: END IF;
1182: RAISE;
1183:
1176: EXCEPTION
1177:
1178: WHEN app_exception.record_lock_exception THEN
1179: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
1180: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.exception','Record Lock Exception');
1181: END IF;
1182: RAISE;
1183:
1184: WHEN OTHERS THEN
1181: END IF;
1182: RAISE;
1183:
1184: WHEN OTHERS THEN
1185: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
1186: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.exception',SQLERRM);
1187: END IF;
1188: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1189: fnd_message.set_token('NAME','IGF_SL_CL_ORIG.UPDATE_ORIG_BATCH_ID');
1182: RAISE;
1183:
1184: WHEN OTHERS THEN
1185: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
1186: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.exception',SQLERRM);
1187: END IF;
1188: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1189: fnd_message.set_token('NAME','IGF_SL_CL_ORIG.UPDATE_ORIG_BATCH_ID');
1190: igs_ge_msg_stack.add;
1510: NULL;
1511: END get_contact_info;
1512:
1513: BEGIN
1514: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1515: l_count_4 := 0;
1516: lv_trans_count := 0;
1517: lv_8_disb_count := 0;
1518: retcode:=0;
1528: IF cur_recip_desc%NOTFOUND THEN
1529: CLOSE cur_recip_desc;
1530:
1531: --The recipient information does not exist
1532: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Recipient description not found');
1534: END IF;
1535: fnd_message.set_name('IGF','IGF_SL_RECIP_NOT_FOUND');
1536: fnd_message.set_token('REL_CODE',p_relationship_cd);
1529: CLOSE cur_recip_desc;
1530:
1531: --The recipient information does not exist
1532: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Recipient description not found');
1534: END IF;
1535: fnd_message.set_name('IGF','IGF_SL_RECIP_NOT_FOUND');
1536: fnd_message.set_token('REL_CODE',p_relationship_cd);
1537: fnd_file.put_line(fnd_file.log,fnd_message.get);
1559: p_fed_fund_1 := 'GPLUSFL';
1560: p_fed_fund_2 := 'GPLUSFL';
1561: END IF;
1562:
1563: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1564: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_cal_type:'||p_ci_cal_type);
1565: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_sequence_number:'||p_ci_sequence_number);
1566: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_1:'||p_fed_fund_1);
1567: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_2:'||p_fed_fund_2);
1560: p_fed_fund_2 := 'GPLUSFL';
1561: END IF;
1562:
1563: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1564: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_cal_type:'||p_ci_cal_type);
1565: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_sequence_number:'||p_ci_sequence_number);
1566: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_1:'||p_fed_fund_1);
1567: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_2:'||p_fed_fund_2);
1568: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_loan_number:'||NVL(p_loan_number,'NULL'));
1561: END IF;
1562:
1563: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1564: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_cal_type:'||p_ci_cal_type);
1565: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_sequence_number:'||p_ci_sequence_number);
1566: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_1:'||p_fed_fund_1);
1567: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_2:'||p_fed_fund_2);
1568: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_loan_number:'||NVL(p_loan_number,'NULL'));
1569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_type:'||NVL(recip_desc_rec.recipient_type,'NULL'));
1562:
1563: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1564: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_cal_type:'||p_ci_cal_type);
1565: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_sequence_number:'||p_ci_sequence_number);
1566: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_1:'||p_fed_fund_1);
1567: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_2:'||p_fed_fund_2);
1568: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_loan_number:'||NVL(p_loan_number,'NULL'));
1569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_type:'||NVL(recip_desc_rec.recipient_type,'NULL'));
1570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_id:'||recip_desc_rec.recipient_id);
1563: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1564: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_cal_type:'||p_ci_cal_type);
1565: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_sequence_number:'||p_ci_sequence_number);
1566: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_1:'||p_fed_fund_1);
1567: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_2:'||p_fed_fund_2);
1568: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_loan_number:'||NVL(p_loan_number,'NULL'));
1569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_type:'||NVL(recip_desc_rec.recipient_type,'NULL'));
1570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_id:'||recip_desc_rec.recipient_id);
1571: END IF;
1564: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_cal_type:'||p_ci_cal_type);
1565: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_sequence_number:'||p_ci_sequence_number);
1566: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_1:'||p_fed_fund_1);
1567: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_2:'||p_fed_fund_2);
1568: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_loan_number:'||NVL(p_loan_number,'NULL'));
1569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_type:'||NVL(recip_desc_rec.recipient_type,'NULL'));
1570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_id:'||recip_desc_rec.recipient_id);
1571: END IF;
1572:
1565: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_ci_sequence_number:'||p_ci_sequence_number);
1566: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_1:'||p_fed_fund_1);
1567: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_2:'||p_fed_fund_2);
1568: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_loan_number:'||NVL(p_loan_number,'NULL'));
1569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_type:'||NVL(recip_desc_rec.recipient_type,'NULL'));
1570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_id:'||recip_desc_rec.recipient_id);
1571: END IF;
1572:
1573: OPEN cur_loan_dtls(p_ci_cal_type,
1566: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_1:'||p_fed_fund_1);
1567: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_fed_fund_2:'||p_fed_fund_2);
1568: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','p_loan_number:'||NVL(p_loan_number,'NULL'));
1569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_type:'||NVL(recip_desc_rec.recipient_type,'NULL'));
1570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','recipient_id:'||recip_desc_rec.recipient_id);
1571: END IF;
1572:
1573: OPEN cur_loan_dtls(p_ci_cal_type,
1574: p_ci_sequence_number,
1583: );
1584: FETCH cur_loan_dtls INTO loan_rec;
1585: IF cur_loan_dtls%NOTFOUND THEN
1586: CLOSE cur_loan_dtls;
1587: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1588: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','No loan data found');
1589: END IF;
1590: RAISE no_loan_data;
1591: END IF;
1584: FETCH cur_loan_dtls INTO loan_rec;
1585: IF cur_loan_dtls%NOTFOUND THEN
1586: CLOSE cur_loan_dtls;
1587: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1588: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','No loan data found');
1589: END IF;
1590: RAISE no_loan_data;
1591: END IF;
1592:
1589: END IF;
1590: RAISE no_loan_data;
1591: END IF;
1592:
1593: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1594: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Processing Loan Number:' || loan_rec.loan_number);
1595: END IF;
1596:
1597: CLOSE cur_loan_dtls;
1590: RAISE no_loan_data;
1591: END IF;
1592:
1593: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1594: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Processing Loan Number:' || loan_rec.loan_number);
1595: END IF;
1596:
1597: CLOSE cur_loan_dtls;
1598:
1599:
1600: --Fetch School Id for the Recipient Details fetched
1601: -- Removed the cursor cur_school_id as p_school_id is now used instead of fetching School ID.
1602:
1603: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_eft_authorization:' || lv_eft_authorization);
1605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'p_media_type:' || p_media_type);
1606: END IF;
1607:
1600: --Fetch School Id for the Recipient Details fetched
1601: -- Removed the cursor cur_school_id as p_school_id is now used instead of fetching School ID.
1602:
1603: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_eft_authorization:' || lv_eft_authorization);
1605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'p_media_type:' || p_media_type);
1606: END IF;
1607:
1608:
1601: -- Removed the cursor cur_school_id as p_school_id is now used instead of fetching School ID.
1602:
1603: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_eft_authorization:' || lv_eft_authorization);
1605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'p_media_type:' || p_media_type);
1606: END IF;
1607:
1608:
1609: -- code which fetches ope_id code using cur_ope_id into lv_ope_id is removed.
1613: -- Fetch Data For concatenating values for Header Record to get value for Processing Year for concatenation
1614:
1615: lv_process_year := get_process_year;
1616:
1617: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1618: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_process_year:' || lv_process_year);
1619: END IF;
1620:
1621: -- Compute Batch ID.
1614:
1615: lv_process_year := get_process_year;
1616:
1617: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1618: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_process_year:' || lv_process_year);
1619: END IF;
1620:
1621: -- Compute Batch ID.
1622: -- Note : Though Batch ID is computed, not sending this batch id to commonline, as our computed
1634: -- Get the Software Details
1635: lv_software_code := get_software_code;
1636: lv_software_version := get_software_version;
1637:
1638: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_software_code:' || lv_software_code);
1640: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_software_version:' || lv_software_version);
1641: END IF;
1642:
1635: lv_software_code := get_software_code;
1636: lv_software_version := get_software_version;
1637:
1638: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_software_code:' || lv_software_code);
1640: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_software_version:' || lv_software_version);
1641: END IF;
1642:
1643: -- museshad(Bug# 4346258) - Added the parameter p_base_id due to change in the
1636: lv_software_version := get_software_version;
1637:
1638: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_software_code:' || lv_software_code);
1640: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_software_version:' || lv_software_version);
1641: END IF;
1642:
1643: -- museshad(Bug# 4346258) - Added the parameter p_base_id due to change in the
1644: -- signature of the function 'get_cl_version()'
1645: lv_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type, p_ci_sequence_number,loan_rec.relationship_cd,p_base_id);
1646: lv_file_ident_code := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-CODE');
1647: lv_file_ident_name := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-NAME');
1648:
1649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_code:' || lv_file_ident_code);
1651: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_name:' || lv_file_ident_name);
1652: END IF;
1653:
1646: lv_file_ident_code := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-CODE');
1647: lv_file_ident_name := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-NAME');
1648:
1649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_code:' || lv_file_ident_code);
1651: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_name:' || lv_file_ident_name);
1652: END IF;
1653:
1654: -- Get School name for p_school_id
1647: lv_file_ident_name := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-NAME');
1648:
1649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_code:' || lv_file_ident_code);
1651: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_name:' || lv_file_ident_name);
1652: END IF;
1653:
1654: -- Get School name for p_school_id
1655: OPEN cur_get_school_name;
1790: CLOSE cur_isir_depend_status;
1791: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
1792: fnd_message.set_token('P_RECORD','igf_ap_fa_base_rec');
1793: fnd_file.put_line(fnd_file.log,fnd_message.get);
1794: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1795: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Record Data not found');
1796: END IF;
1797: RAISE SKIP_RECORD;
1798: ELSE
1791: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
1792: fnd_message.set_token('P_RECORD','igf_ap_fa_base_rec');
1793: fnd_file.put_line(fnd_file.log,fnd_message.get);
1794: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1795: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Record Data not found');
1796: END IF;
1797: RAISE SKIP_RECORD;
1798: ELSE
1799: CLOSE cur_isir_depend_status;
1834: CLOSE citizenship_dtl_cur;
1835:
1836: -- logging details of student and parent
1837:
1838: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1839: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Full Name :' ||student_dtl_rec.p_full_name );
1840: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student First Name :' ||student_dtl_rec.p_first_name);
1841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Birth date :' ||student_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1835:
1836: -- logging details of student and parent
1837:
1838: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1839: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Full Name :' ||student_dtl_rec.p_full_name );
1840: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student First Name :' ||student_dtl_rec.p_first_name);
1841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Birth date :' ||student_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1836: -- logging details of student and parent
1837:
1838: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1839: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Full Name :' ||student_dtl_rec.p_full_name );
1840: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student First Name :' ||student_dtl_rec.p_first_name);
1841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Birth date :' ||student_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1837:
1838: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1839: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Full Name :' ||student_dtl_rec.p_full_name );
1840: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student First Name :' ||student_dtl_rec.p_first_name);
1841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Birth date :' ||student_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1838: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1839: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Full Name :' ||student_dtl_rec.p_full_name );
1840: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student First Name :' ||student_dtl_rec.p_first_name);
1841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Birth date :' ||student_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1839: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Full Name :' ||student_dtl_rec.p_full_name );
1840: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student First Name :' ||student_dtl_rec.p_first_name);
1841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Birth date :' ||student_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1840: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student First Name :' ||student_dtl_rec.p_first_name);
1841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Birth date :' ||student_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1841: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student Birth date :' ||student_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1842: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address1 :' ||student_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1843: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student address2 :' ||student_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address2 :' ||parent_dtl_rec.p_permt_addr2);
1844: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License Num :' ||student_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address2 :' ||parent_dtl_rec.p_permt_addr2);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License Num :' ||parent_dtl_rec.p_license_num);
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student License State :' ||student_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address2 :' ||parent_dtl_rec.p_permt_addr2);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License Num :' ||parent_dtl_rec.p_license_num);
1853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License State :' ||parent_dtl_rec.p_license_state);
1846: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Student SSN :' ||student_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address2 :' ||parent_dtl_rec.p_permt_addr2);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License Num :' ||parent_dtl_rec.p_license_num);
1853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License State :' ||parent_dtl_rec.p_license_state);
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower SSN :' ||parent_dtl_rec.p_ssn);
1847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Full Name :' ||parent_dtl_rec.p_full_name );
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address2 :' ||parent_dtl_rec.p_permt_addr2);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License Num :' ||parent_dtl_rec.p_license_num);
1853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License State :' ||parent_dtl_rec.p_license_state);
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower SSN :' ||parent_dtl_rec.p_ssn);
1855: END IF;
1848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower First Name :' ||parent_dtl_rec.p_first_name);
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address2 :' ||parent_dtl_rec.p_permt_addr2);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License Num :' ||parent_dtl_rec.p_license_num);
1853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License State :' ||parent_dtl_rec.p_license_state);
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower SSN :' ||parent_dtl_rec.p_ssn);
1855: END IF;
1856:
1849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower Birth date :' ||parent_dtl_rec.p_date_of_birth);
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address2 :' ||parent_dtl_rec.p_permt_addr2);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License Num :' ||parent_dtl_rec.p_license_num);
1853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License State :' ||parent_dtl_rec.p_license_state);
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower SSN :' ||parent_dtl_rec.p_ssn);
1855: END IF;
1856:
1857: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address1 :' ||parent_dtl_rec.p_permt_addr1);
1851: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower address2 :' ||parent_dtl_rec.p_permt_addr2);
1852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License Num :' ||parent_dtl_rec.p_license_num);
1853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License State :' ||parent_dtl_rec.p_license_state);
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower SSN :' ||parent_dtl_rec.p_ssn);
1855: END IF;
1856:
1857: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower License State :' ||parent_dtl_rec.p_license_state);
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower SSN :' ||parent_dtl_rec.p_ssn);
1855: END IF;
1856:
1857: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Borrower SSN :' ||parent_dtl_rec.p_ssn);
1855: END IF;
1856:
1857: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1862: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1855: END IF;
1856:
1857: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1862: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1856:
1857: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1862: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1864: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1857: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1862: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1864: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1865: END IF;
1858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1862: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1864: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1865: END IF;
1866:
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1862: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1864: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1865: END IF;
1866:
1867: --Code added for bug 3603289 start
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1862: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1864: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1865: END IF;
1866:
1867: --Code added for bug 3603289 start
1868: lv_s_license_number := student_dtl_rec.p_license_num;
1872: lv_s_legal_res_date := student_dtl_rec.p_legal_res_date;
1873: lv_s_legal_res_state := student_dtl_rec.p_state_of_legal_res;
1874: --Code added for bug 3603289 end
1875:
1876: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1873: lv_s_legal_res_state := student_dtl_rec.p_state_of_legal_res;
1874: --Code added for bug 3603289 end
1875:
1876: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1874: --Code added for bug 3603289 end
1875:
1876: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1875:
1876: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1876: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1884: END IF;
1877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_number:' ||lv_s_license_number);
1878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1884: END IF;
1885:
1878: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_license_state:' ||lv_s_license_state);
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1884: END IF;
1885:
1886: lv_s_permt_phone := NULL;
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_citizenship_status:' ||lv_s_citizenship_status);
1880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_alien_reg_num:' ||lv_alien_reg_num);
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_date:' ||lv_s_legal_res_date);
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_s_legal_res_state:' ||lv_s_legal_res_state);
1884: END IF;
1885:
1886: lv_s_permt_phone := NULL;
1887: lv_p_permt_phone := NULL;
1899: OPEN cur_get_fabase;
1900: FETCH cur_get_fabase INTO l_coa;
1901: CLOSE cur_get_fabase;
1902:
1903: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1904: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'l_coa:' ||l_coa);
1905: END IF;
1906:
1907: -- Get the EFC months for the for the Award Yr
1900: FETCH cur_get_fabase INTO l_coa;
1901: CLOSE cur_get_fabase;
1902:
1903: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1904: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'l_coa:' ||l_coa);
1905: END IF;
1906:
1907: -- Get the EFC months for the for the Award Yr
1908: igf_aw_packng_subfns.get_fed_efc(
1912: l_pell_efc => l_dummy_pell_efc,
1913: l_efc_ay => l_efc
1914: );
1915:
1916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','l_efc:'||l_efc);
1918: END IF;
1919:
1920: l_efc := TRUNC(l_efc);
1913: l_efc_ay => l_efc
1914: );
1915:
1916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','l_efc:'||l_efc);
1918: END IF;
1919:
1920: l_efc := TRUNC(l_efc);
1921:
1923: OPEN cur_get_fin_aid('OFFERED','ACCEPTED');
1924: FETCH cur_get_fin_aid INTO l_est_fin;
1925: CLOSE cur_get_fin_aid;
1926:
1927: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'l_est_fin:' ||l_est_fin);
1929: END IF;
1930:
1931: OPEN cur_get_disb_num(loan_rec.award_id);
1924: FETCH cur_get_fin_aid INTO l_est_fin;
1925: CLOSE cur_get_fin_aid;
1926:
1927: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'l_est_fin:' ||l_est_fin);
1929: END IF;
1930:
1931: OPEN cur_get_disb_num(loan_rec.award_id);
1932: FETCH cur_get_disb_num INTO ln_num_of_disb;
1931: OPEN cur_get_disb_num(loan_rec.award_id);
1932: FETCH cur_get_disb_num INTO ln_num_of_disb;
1933: CLOSE cur_get_disb_num;
1934:
1935: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1936: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'ln_num_of_disb:' ||ln_num_of_disb);
1937: END IF;
1938:
1939:
1932: FETCH cur_get_disb_num INTO ln_num_of_disb;
1933: CLOSE cur_get_disb_num;
1934:
1935: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1936: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'ln_num_of_disb:' ||ln_num_of_disb);
1937: END IF;
1938:
1939:
1940: IF lv_cl_version = 'RELEASE-5' THEN
1967: lv_indi := ' ';
1968: lv_stud_sign_ind := ' ';
1969: END IF;
1970:
1971: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_indi:' ||lv_indi);
1973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_borr_sign_ind:' ||lv_borr_sign_ind);
1974: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_stud_sign_ind:' ||lv_stud_sign_ind);
1975: END IF;
1968: lv_stud_sign_ind := ' ';
1969: END IF;
1970:
1971: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_indi:' ||lv_indi);
1973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_borr_sign_ind:' ||lv_borr_sign_ind);
1974: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_stud_sign_ind:' ||lv_stud_sign_ind);
1975: END IF;
1976:
1969: END IF;
1970:
1971: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_indi:' ||lv_indi);
1973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_borr_sign_ind:' ||lv_borr_sign_ind);
1974: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_stud_sign_ind:' ||lv_stud_sign_ind);
1975: END IF;
1976:
1977: OPEN c_sl_lor (cp_n_loan_id => loan_rec.loan_id);
1970:
1971: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_indi:' ||lv_indi);
1973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_borr_sign_ind:' ||lv_borr_sign_ind);
1974: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_stud_sign_ind:' ||lv_stud_sign_ind);
1975: END IF;
1976:
1977: OPEN c_sl_lor (cp_n_loan_id => loan_rec.loan_id);
1978: FETCH c_sl_lor INTO rec_c_sl_lor;
2150:
2151: --Check if its FLP
2152: IF igf_sl_gen.chk_cl_plus(loan_rec.fed_fund_code)='TRUE' OR igf_sl_gen.chk_cl_gplus(loan_rec.fed_fund_code)='TRUE' THEN
2153:
2154: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2155: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Current loan is a plus loan');
2156: END IF;
2157:
2158: l_phone := lv_p_permt_phone;
2151: --Check if its FLP
2152: IF igf_sl_gen.chk_cl_plus(loan_rec.fed_fund_code)='TRUE' OR igf_sl_gen.chk_cl_gplus(loan_rec.fed_fund_code)='TRUE' THEN
2153:
2154: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2155: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Current loan is a plus loan');
2156: END IF;
2157:
2158: l_phone := lv_p_permt_phone;
2159: l_plus_cert_amt := loan_rec.loan_amt_accepted;
2163: lv_borw_interest_ind := NULL;
2164:
2165: ELSIF igf_sl_gen.chk_cl_alt(loan_rec.fed_fund_code)='TRUE' THEN
2166:
2167: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Current loan is a alternate loan');
2169: END IF;
2170:
2171: l_plus_cert_amt := NULL;
2164:
2165: ELSIF igf_sl_gen.chk_cl_alt(loan_rec.fed_fund_code)='TRUE' THEN
2166:
2167: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Current loan is a alternate loan');
2169: END IF;
2170:
2171: l_plus_cert_amt := NULL;
2172: l_alt_cert_amt := loan_rec.loan_amt_accepted; -- should be sum of all disb for this loan
2813: BEGIN
2814: FOR tbh_rec IN c_tbh_cur LOOP
2815: lv_row_id := NULL;
2816:
2817: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_awd_disb_loc_pkg.insert_row');
2819: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.award_id ' || tbh_rec.award_id );
2820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_num ' || tbh_rec.disb_num );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2814: FOR tbh_rec IN c_tbh_cur LOOP
2815: lv_row_id := NULL;
2816:
2817: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_awd_disb_loc_pkg.insert_row');
2819: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.award_id ' || tbh_rec.award_id );
2820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_num ' || tbh_rec.disb_num );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2815: lv_row_id := NULL;
2816:
2817: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_awd_disb_loc_pkg.insert_row');
2819: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.award_id ' || tbh_rec.award_id );
2820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_num ' || tbh_rec.disb_num );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2816:
2817: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_awd_disb_loc_pkg.insert_row');
2819: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.award_id ' || tbh_rec.award_id );
2820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_num ' || tbh_rec.disb_num );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2817: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_awd_disb_loc_pkg.insert_row');
2819: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.award_id ' || tbh_rec.award_id );
2820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_num ' || tbh_rec.disb_num );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_date ' || tbh_rec.disb_date );
2818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_awd_disb_loc_pkg.insert_row');
2819: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.award_id ' || tbh_rec.award_id );
2820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_num ' || tbh_rec.disb_num );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_date ' || tbh_rec.disb_date );
2826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.hold_rel_ind ' || tbh_rec.hold_rel_ind );
2819: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.award_id ' || tbh_rec.award_id );
2820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_num ' || tbh_rec.disb_num );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_date ' || tbh_rec.disb_date );
2826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.hold_rel_ind ' || tbh_rec.hold_rel_ind );
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_1 ' || tbh_rec.fee_paid_1 );
2820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_num ' || tbh_rec.disb_num );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_date ' || tbh_rec.disb_date );
2826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.hold_rel_ind ' || tbh_rec.hold_rel_ind );
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_1 ' || tbh_rec.fee_paid_1 );
2828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_2 ' || tbh_rec.fee_paid_2 );
2821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_accepted_amt ' || tbh_rec.disb_accepted_amt );
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_date ' || tbh_rec.disb_date );
2826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.hold_rel_ind ' || tbh_rec.hold_rel_ind );
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_1 ' || tbh_rec.fee_paid_1 );
2828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_2 ' || tbh_rec.fee_paid_2 );
2829: END IF;
2822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_1 ' || tbh_rec.fee_1 );
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_date ' || tbh_rec.disb_date );
2826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.hold_rel_ind ' || tbh_rec.hold_rel_ind );
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_1 ' || tbh_rec.fee_paid_1 );
2828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_2 ' || tbh_rec.fee_paid_2 );
2829: END IF;
2830:
2823: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_2 ' || tbh_rec.fee_2 );
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_date ' || tbh_rec.disb_date );
2826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.hold_rel_ind ' || tbh_rec.hold_rel_ind );
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_1 ' || tbh_rec.fee_paid_1 );
2828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_2 ' || tbh_rec.fee_paid_2 );
2829: END IF;
2830:
2831: igf_sl_awd_disb_loc_pkg.insert_row (
2824: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_net_amt ' || tbh_rec.disb_net_amt );
2825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.disb_date ' || tbh_rec.disb_date );
2826: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.hold_rel_ind ' || tbh_rec.hold_rel_ind );
2827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_1 ' || tbh_rec.fee_paid_1 );
2828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', ' tbh_rec.fee_paid_2 ' || tbh_rec.fee_paid_2 );
2829: END IF;
2830:
2831: igf_sl_awd_disb_loc_pkg.insert_row (
2832: x_Mode => 'R',
2844: );
2845: END LOOP;
2846: END;
2847:
2848: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'igf_sl_awd_disb_loc_pkg.insert_row succeeded');
2850: END IF;
2851:
2852:
2845: END LOOP;
2846: END;
2847:
2848: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2849: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'igf_sl_awd_disb_loc_pkg.insert_row succeeded');
2850: END IF;
2851:
2852:
2853: -- Update the Loan Status to Sent and Loan Status Date to SYSDATE
2862:
2863: -- Modified the Update Row call of the IGF_SL_LOANS_PKG, as part of Refunds DLD 2144600 for Borrower
2864: -- determination
2865:
2866: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_loans_pkg.update_row');
2868: END IF;
2869:
2870: igf_sl_loans_pkg.update_row (
2863: -- Modified the Update Row call of the IGF_SL_LOANS_PKG, as part of Refunds DLD 2144600 for Borrower
2864: -- determination
2865:
2866: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_loans_pkg.update_row');
2868: END IF;
2869:
2870: igf_sl_loans_pkg.update_row (
2871: x_Mode => 'R',
2885: x_borw_detrm_code => tbh_rec.borw_detrm_code,
2886: x_legacy_record_flag => NULL,
2887: x_external_loan_id_txt => tbh_rec.external_loan_id_txt
2888: );
2889: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2890: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'igf_sl_loans_pkg.update_row succeeded');
2891: END IF;
2892:
2893: END LOOP;
2886: x_legacy_record_flag => NULL,
2887: x_external_loan_id_txt => tbh_rec.external_loan_id_txt
2888: );
2889: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2890: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'igf_sl_loans_pkg.update_row succeeded');
2891: END IF;
2892:
2893: END LOOP;
2894: END;
2964: WHEN app_exception.record_lock_exception THEN
2965: ROLLBACK;
2966: retcode := 2;
2967: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
2968: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
2969: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.exception','Record Lock Exception');
2970: END IF;
2971:
2972: igs_ge_msg_stack.conc_exception_hndl;
2965: ROLLBACK;
2966: retcode := 2;
2967: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
2968: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
2969: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.exception','Record Lock Exception');
2970: END IF;
2971:
2972: igs_ge_msg_stack.conc_exception_hndl;
2973:
2978: retcode := 2;
2979: errbuf := fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA');
2980: fnd_file.put_line(fnd_file.log, '');
2981: fnd_file.put_line(fnd_file.log, errbuf);
2982: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
2983: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','No loan origination data found');
2984: END IF;
2985: errbuf := NULL;
2986:
2979: errbuf := fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA');
2980: fnd_file.put_line(fnd_file.log, '');
2981: fnd_file.put_line(fnd_file.log, errbuf);
2982: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
2983: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','No loan origination data found');
2984: END IF;
2985: errbuf := NULL;
2986:
2987: WHEN OTHERS THEN
2988: ROLLBACK;
2989: retcode := 2;
2990: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2991: fnd_message.set_token('NAME','IGF_SL_CL_ORIG.SUB_CL_ORIGINATE');
2992: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
2993: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.exception', SQLERRM );
2994: END IF;
2995: errbuf := fnd_message.get;
2996:
2989: retcode := 2;
2990: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2991: fnd_message.set_token('NAME','IGF_SL_CL_ORIG.SUB_CL_ORIGINATE');
2992: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN
2993: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.exception', SQLERRM );
2994: END IF;
2995: errbuf := fnd_message.get;
2996:
2997: igs_ge_msg_stack.conc_exception_hndl;