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_VALIDATION dependencies on FND_LOG

Line 98: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

94: --Change History:
95: --Who When What
96: ------------------------------------------------------------------
97: BEGIN
98: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
99: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_validation.'||p_v_module||'.'||p_v_log_category, p_v_string);
100: END IF;
101: END log_to_fnd;
102:

Line 99: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_validation.'||p_v_module||'.'||p_v_log_category, p_v_string);

95: --Who When What
96: ------------------------------------------------------------------
97: BEGIN
98: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
99: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_validation.'||p_v_module||'.'||p_v_log_category, p_v_string);
100: END IF;
101: END log_to_fnd;
102:
103: FUNCTION check_for_reqd(

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

162: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
163: fnd_message.set_token('NAME','IGF_SL_CL_VALIDATION.CHECK_FOR_REQD');
164: fnd_file.put_line(fnd_file.log,SQLERRM);
165: igs_ge_msg_stack.add;
166: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN
167: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_validation.check_for_reqd.exception', 'Unhandled excepion in check_for_reqd');
168: END IF;
169: app_exception.raise_exception;
170:

Line 167: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_validation.check_for_reqd.exception', 'Unhandled excepion in check_for_reqd');

163: fnd_message.set_token('NAME','IGF_SL_CL_VALIDATION.CHECK_FOR_REQD');
164: fnd_file.put_line(fnd_file.log,SQLERRM);
165: igs_ge_msg_stack.add;
166: IF (fnd_log.level_exception >= g_debug_runtime_level) THEN
167: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_validation.check_for_reqd.exception', 'Unhandled excepion in check_for_reqd');
168: END IF;
169: app_exception.raise_exception;
170:
171: END check_for_reqd;

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

499: resource_rec resource_cur%ROWTYPE;
500: ln_coa NUMBER;
501: ln_efc NUMBER;
502: BEGIN
503: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
504: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_base_id:' || p_base_id);
505: END IF;
506:
507: OPEN resource_cur;

Line 504: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_base_id:' || p_base_id);

500: ln_coa NUMBER;
501: ln_efc NUMBER;
502: BEGIN
503: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
504: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_base_id:' || p_base_id);
505: END IF;
506:
507: OPEN resource_cur;
508: FETCH resource_cur INTO resource_rec;

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

517: ELSE
518: p_resource_f_fc := resource_rec.resource_fm_f;
519: END IF;
520:
521: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_coa:' || ln_coa);
523: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_efc:' || ln_efc);
524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f:' || p_resource_f);
525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f_fc:' || p_resource_f_fc);

Line 522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_coa:' || ln_coa);

518: p_resource_f_fc := resource_rec.resource_fm_f;
519: END IF;
520:
521: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_coa:' || ln_coa);
523: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_efc:' || ln_efc);
524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f:' || p_resource_f);
525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f_fc:' || p_resource_f_fc);
526: END IF;

Line 523: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_efc:' || ln_efc);

519: END IF;
520:
521: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_coa:' || ln_coa);
523: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_efc:' || ln_efc);
524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f:' || p_resource_f);
525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f_fc:' || p_resource_f_fc);
526: END IF;
527:

Line 524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f:' || p_resource_f);

520:
521: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_coa:' || ln_coa);
523: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_efc:' || ln_efc);
524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f:' || p_resource_f);
525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f_fc:' || p_resource_f_fc);
526: END IF;
527:
528: IF ln_coa > ln_efc THEN

Line 525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f_fc:' || p_resource_f_fc);

521: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_coa:' || ln_coa);
523: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'ln_efc:' || ln_efc);
524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f:' || p_resource_f);
525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_resource_f_fc:' || p_resource_f_fc);
526: END IF;
527:
528: IF ln_coa > ln_efc THEN
529: p_unmet_need_f := ln_coa - ln_efc - NVL (p_resource_f, 0) + NVL (p_resource_f_fc, 0);

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

530: ELSE
531: p_unmet_need_f := ln_coa - p_resource_f_fc;
532: END IF;
533:
534: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
535: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_unmet_need_f:' || p_unmet_need_f);
536: END IF;
537:
538: RETURN p_unmet_need_f;

Line 535: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_unmet_need_f:' || p_unmet_need_f);

531: p_unmet_need_f := ln_coa - p_resource_f_fc;
532: END IF;
533:
534: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
535: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.unmetneed.debug', 'p_unmet_need_f:' || p_unmet_need_f);
536: END IF;
537:
538: RETURN p_unmet_need_f;
539: END unmetneed;

Line 647: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

643: -- Start of Main Procedure
644:
645: BEGIN
646:
647: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
648:
649: IF p_call_mode = 'FORM' THEN
650: p_status_1 := 'G';
651: p_status_2 := 'N';

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

677: p_fed_fund_1 := 'GPLUSFL';
678: p_fed_fund_2 := 'GPLUSFL';
679: END IF;
680:
681: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_call_mode:' || p_call_mode);
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_1:' || p_status_1);
684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);
685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);

Line 682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_call_mode:' || p_call_mode);

678: p_fed_fund_2 := 'GPLUSFL';
679: END IF;
680:
681: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_call_mode:' || p_call_mode);
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_1:' || p_status_1);
684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);
685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);
686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);

Line 683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_1:' || p_status_1);

679: END IF;
680:
681: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_call_mode:' || p_call_mode);
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_1:' || p_status_1);
684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);
685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);
686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);

Line 684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);

680:
681: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_call_mode:' || p_call_mode);
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_1:' || p_status_1);
684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);
685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);
686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);
688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);

Line 685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);

681: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_call_mode:' || p_call_mode);
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_1:' || p_status_1);
684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);
685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);
686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);
688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);
689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);

Line 686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);

682: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_call_mode:' || p_call_mode);
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_1:' || p_status_1);
684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);
685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);
686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);
688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);
689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);
690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);

Line 687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);

683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_1:' || p_status_1);
684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);
685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);
686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);
688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);
689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);
690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);
691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_number:' || p_loan_number);

Line 688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);

684: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_2:' || p_status_2);
685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);
686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);
688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);
689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);
690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);
691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_number:' || p_loan_number);
692: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_school_id :' || p_school_id );

Line 689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);

685: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_status_3:' || p_status_3);
686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);
688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);
689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);
690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);
691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_number:' || p_loan_number);
692: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_school_id :' || p_school_id );
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_base_id :' || p_base_id );

Line 690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);

686: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_catg:' || p_loan_catg);
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);
688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);
689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);
690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);
691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_number:' || p_loan_number);
692: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_school_id :' || p_school_id );
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_base_id :' || p_base_id );
694: END IF;

Line 691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_number:' || p_loan_number);

687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_1:' || p_fed_fund_1);
688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);
689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);
690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);
691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_number:' || p_loan_number);
692: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_school_id :' || p_school_id );
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_base_id :' || p_base_id );
694: END IF;
695:

Line 692: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_school_id :' || p_school_id );

688: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_fed_fund_2:' || p_fed_fund_2);
689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);
690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);
691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_number:' || p_loan_number);
692: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_school_id :' || p_school_id );
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_base_id :' || p_base_id );
694: END IF;
695:
696:

Line 693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_base_id :' || p_base_id );

689: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_cal_type:' || p_ci_cal_type);
690: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_ci_seq_number:' || p_ci_sequence_number);
691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_loan_number:' || p_loan_number);
692: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_school_id :' || p_school_id );
693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'p_base_id :' || p_base_id );
694: END IF;
695:
696:
697: FOR lor_rec IN cur_lor_details_recs(p_fed_fund_1,

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

726: EXCEPTION
727: WHEN NO_DATA_FOUND THEN
728: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
729: fnd_file.put_line(fnd_file.log,fnd_message.get);
730: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
731: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.set_complete_status.debug', 'No CL Setup found');
732: END IF;
733: RAISE NO_DATA_FOUND;
734: END;

Line 731: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.set_complete_status.debug', 'No CL Setup found');

727: WHEN NO_DATA_FOUND THEN
728: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
729: fnd_file.put_line(fnd_file.log,fnd_message.get);
730: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
731: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.set_complete_status.debug', 'No CL Setup found');
732: END IF;
733: RAISE NO_DATA_FOUND;
734: END;
735:

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

745: CLOSE cur_isir_depend_status;
746: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
747: fnd_message.set_token('P_RECORD','IGF_AP_FA_BASE_REC');
748: igs_ge_msg_stack.add;
749: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
750: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate', 'cur_isir_depend_status cursor failed');
751: END IF;
752: app_exception.raise_exception;
753: END IF;

Line 750: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate', 'cur_isir_depend_status cursor failed');

746: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
747: fnd_message.set_token('P_RECORD','IGF_AP_FA_BASE_REC');
748: igs_ge_msg_stack.add;
749: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
750: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate', 'cur_isir_depend_status cursor failed');
751: END IF;
752: app_exception.raise_exception;
753: END IF;
754: CLOSE cur_isir_depend_status;

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

1476: ELSE
1477: lv_loan_status := 'V'; -- VALID and READY TO SEND
1478: END IF;
1479:
1480: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1481: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'lv_loan_status:' || lv_loan_status);
1482: END IF;
1483:
1484: DECLARE

Line 1481: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'lv_loan_status:' || lv_loan_status);

1477: lv_loan_status := 'V'; -- VALID and READY TO SEND
1478: END IF;
1479:
1480: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1481: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'lv_loan_status:' || lv_loan_status);
1482: END IF;
1483:
1484: DECLARE
1485: CURSOR c_tbh_cur IS

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

1488: BEGIN
1489:
1490: FOR tbh_rec in c_tbh_cur LOOP
1491:
1492: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'Updating tbh_rec.loan_id:' || tbh_rec.loan_id);
1494: END IF;
1495:
1496: -- Modified the update row call for the Borrower Determination as part of Refunds DLD 2144600

Line 1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'Updating tbh_rec.loan_id:' || tbh_rec.loan_id);

1489:
1490: FOR tbh_rec in c_tbh_cur LOOP
1491:
1492: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'Updating tbh_rec.loan_id:' || tbh_rec.loan_id);
1494: END IF;
1495:
1496: -- Modified the update row call for the Borrower Determination as part of Refunds DLD 2144600
1497: igf_sl_loans_pkg.update_row (

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

1514: x_external_loan_id_txt => tbh_rec.external_loan_id_txt
1515:
1516: );
1517:
1518: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1519: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'Updated tbh_rec.loan_id:' || tbh_rec.loan_id);
1520: END IF;
1521:
1522: END LOOP;

Line 1519: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'Updated tbh_rec.loan_id:' || tbh_rec.loan_id);

1515:
1516: );
1517:
1518: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1519: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'Updated tbh_rec.loan_id:' || tbh_rec.loan_id);
1520: END IF;
1521:
1522: END LOOP;
1523: END;