DBA Data[Home] [Help]

APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_DEBUG_PUB

Line 5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

1: PACKAGE BODY OKL_LA_PAYMENTS_PVT as
2: /* $Header: OKLRPYTB.pls 120.42.12020000.2 2012/08/07 12:21:23 bkatraga ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7:
8: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 3720: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

3716: l_var_int_sched_counter NUMBER;
3717:
3718: begin
3719: IF (G_DEBUG_ENABLED = 'Y') THEN
3720: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3721: END IF;
3722:
3723: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In variable_interest_schedule... p_chr_id=' || p_chr_id);

Line 3724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In variable_interest_schedule... p_chr_id=' || p_chr_id);

3720: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3721: END IF;
3722:
3723: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In variable_interest_schedule... p_chr_id=' || p_chr_id);
3725: END IF;
3726: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3727: x_return_status := OKL_API.START_ACTIVITY(
3728: p_api_name => l_api_name,

Line 3760: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);

3756: l_deal_type := l_pdt_parameter_rec.deal_type;
3757:
3758: l_term := get_term(p_chr_id);
3759:
3760: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);
3761: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);
3762: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);
3763: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);
3764: IF ( l_deal_type = 'LOAN' AND

Line 3761: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);

3757:
3758: l_term := get_term(p_chr_id);
3759:
3760: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);
3761: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);
3762: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);
3763: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);
3764: IF ( l_deal_type = 'LOAN' AND
3765: l_interest_calculation_basis IN ('FLOAT', 'CATCHUP/CLEANUP') ) OR

Line 3762: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);

3758: l_term := get_term(p_chr_id);
3759:
3760: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);
3761: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);
3762: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);
3763: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);
3764: IF ( l_deal_type = 'LOAN' AND
3765: l_interest_calculation_basis IN ('FLOAT', 'CATCHUP/CLEANUP') ) OR
3766: ( l_deal_type = 'LOAN-REVOLVING' AND

Line 3763: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);

3759:
3760: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);
3761: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);
3762: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);
3763: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);
3764: IF ( l_deal_type = 'LOAN' AND
3765: l_interest_calculation_basis IN ('FLOAT', 'CATCHUP/CLEANUP') ) OR
3766: ( l_deal_type = 'LOAN-REVOLVING' AND
3767: l_interest_calculation_basis = 'FLOAT' ) THEN

Line 3788: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_id=' || l_payment_id);

3784: END IF;
3785:
3786: -- 4895333
3787: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3788: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_id=' || l_payment_id);
3789: END IF;
3790: FOR r IN get_sts_code_csr(p_chr_id)
3791: LOOP
3792: l_sts_code := r.sts_code;

Line 3795: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_sts_code=' || l_sts_code);

3791: LOOP
3792: l_sts_code := r.sts_code;
3793: END LOOP;
3794: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3795: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_sts_code=' || l_sts_code);
3796:
3797: END IF;
3798: FOR r_var_int_sched_counter_csr IN
3799: var_int_sched_counter_csr(p_chr_id, l_payment_id)

Line 3805: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_var_int_sched_counter=' || l_var_int_sched_counter);

3801: l_var_int_sched_counter := r_var_int_sched_counter_csr.counter;
3802: END LOOP;
3803:
3804: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3805: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_var_int_sched_counter=' || l_var_int_sched_counter);
3806: END IF;
3807: -- 4895333
3808: IF (l_var_int_sched_counter < 1) AND (l_sts_code <> 'BOOKED') THEN
3809: get_payment(

Line 3833: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_slh_id null... cant create...');

3829: END IF;
3830:
3831: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then
3832: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3833: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_slh_id null... cant create...');
3834: END IF;
3835: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3836: x_msg_data => x_msg_data);
3837: return;

Line 3974: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

3970: AND sts.ste_code NOT IN ('EXPIRED','TERMINATED','CANCELLED');
3971:
3972: begin
3973: IF (G_DEBUG_ENABLED = 'Y') THEN
3974: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3975: END IF;
3976:
3977: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3978: x_return_status := OKL_API.START_ACTIVITY(