eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_ORIG dependencies on FND_LOG

Line 483: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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:

Line 537: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN

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

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

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

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

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;

Line 540: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_number:'||p_loan_number);

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,

Line 541: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','p_loan_catg:'||p_loan_catg);

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,

Line 542: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Calling cl_lar_validate');

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,

Line 553: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN

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

Line 554: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Called cl_lar_validate');

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

Line 556: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned true');

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;

Line 558: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.cl_originate.debug','cl_lar_validate returned false');

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

Line 563: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

Line 564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_lookup_type:' || l_lookup_type);

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

Line 565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'l_alternate_code:' || l_alternate_code);

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;

Line 566: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'p_loan_number:' || p_loan_number);

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:

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

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:

Line 568: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug', 'relatioship code :' || orec.relationship_cd);

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

Line 578: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

Line 579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient description not found');

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

Line 628: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN

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

Line 629: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Concurrent request failed');

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

Line 649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

Line 650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.cl_originate.debug','Recipient Id not found');

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

Line 667: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN

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;

Line 668: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.cl_originate.exception',SQLERRM);

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:

Line 682: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN

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:

Line 683: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.cl_originate.exception',SQLERRM);

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;

Line 741: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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 (

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

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

Line 947: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

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

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:

Line 954: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN

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:

Line 955: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.exception', 'Lock row failed' );

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

Line 963: IF(fnd_log.level_exception >= g_debug_runtime_level)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;

Line 964: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.exception',SQLERRM);

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:

Line 1033: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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 ;

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

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 ;

Line 1170: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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;

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

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:

Line 1179: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN

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:

Line 1180: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.exception','Record Lock Exception');

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

Line 1185: IF(fnd_log.level_exception >= g_debug_runtime_level)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');

Line 1186: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.exception',SQLERRM);

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;

Line 1514: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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;

Line 1532: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

Line 1533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Recipient description not found');

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

Line 1563: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN

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

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

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

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

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

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

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

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

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;

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

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:

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

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,

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

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,

Line 1587: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN

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;

Line 1588: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','No loan data found');

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:

Line 1593: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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;

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

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:

Line 1603: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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:

Line 1604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_eft_authorization:' || lv_eft_authorization);

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:

Line 1605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'p_media_type:' || p_media_type);

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.

Line 1617: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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.

Line 1618: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_process_year:' || lv_process_year);

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

Line 1638: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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:

Line 1639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_software_code:' || lv_software_code);

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

Line 1640: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_software_version:' || lv_software_version);

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

Line 1649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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:

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

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

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

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;

Line 1794: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN

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

Line 1795: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Record Data not found');

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;

Line 1838: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;

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

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:

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

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

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

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

Line 1857: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

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

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

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

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

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

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

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

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;

Line 1862: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);

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:

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

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

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

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;

Line 1876: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

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

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

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

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

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

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

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

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;

Line 1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_dependency_status:' ||lv_dependency_status);

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:

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

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;

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

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;

Line 1903: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

Line 1904: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'l_coa:' ||l_coa);

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(

Line 1916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

Line 1917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','l_efc:'||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:

Line 1927: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

Line 1928: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'l_est_fin:' ||l_est_fin);

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;

Line 1935: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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:

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

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

Line 1971: IF (fnd_log.level_statement >= g_debug_runtime_level) 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;

Line 1972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_indi:' ||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;
1976:

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

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

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

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;

Line 2154: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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;

Line 2155: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Current loan is a plus loan');

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;

Line 2167: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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;

Line 2168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Current loan is a alternate loan');

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

Line 2817: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;

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

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:

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

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 (

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

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

Line 2848: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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:

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

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

Line 2866: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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 (

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

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

Line 2889: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

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;

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

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;

Line 2968: IF(fnd_log.level_exception >= g_debug_runtime_level)THEN

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;

Line 2969: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.exception','Record Lock Exception');

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:

Line 2982: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN

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:

Line 2983: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','No loan origination data found');

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

Line 2992: IF(fnd_log.level_exception >= g_debug_runtime_level)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:

Line 2993: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.exception', SQLERRM );

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;