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.35.12010000.6 2009/01/22 09:22:09 nikshah 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 3422: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

3418: l_var_int_sched_counter NUMBER;
3419:
3420: begin
3421: IF (G_DEBUG_ENABLED = 'Y') THEN
3422: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3423: END IF;
3424:
3425: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3426: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In variable_interest_schedule... p_chr_id=' || p_chr_id);

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

3422: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3423: END IF;
3424:
3425: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3426: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In variable_interest_schedule... p_chr_id=' || p_chr_id);
3427: END IF;
3428: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3429: x_return_status := OKL_API.START_ACTIVITY(
3430: p_api_name => l_api_name,

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

3458: l_deal_type := l_pdt_parameter_rec.deal_type;
3459:
3460: l_term := get_term(p_chr_id);
3461:
3462: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);
3463: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);
3464: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);
3465: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);
3466: IF ( l_deal_type = 'LOAN' AND

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

3459:
3460: l_term := get_term(p_chr_id);
3461:
3462: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);
3463: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);
3464: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);
3465: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);
3466: IF ( l_deal_type = 'LOAN' AND
3467: l_interest_calculation_basis IN ('FLOAT', 'CATCHUP/CLEANUP') ) OR

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

3460: l_term := get_term(p_chr_id);
3461:
3462: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);
3463: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);
3464: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);
3465: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);
3466: IF ( l_deal_type = 'LOAN' AND
3467: l_interest_calculation_basis IN ('FLOAT', 'CATCHUP/CLEANUP') ) OR
3468: ( l_deal_type = 'LOAN-REVOLVING' AND

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

3461:
3462: okl_debug_pub.logmessage('p_chr_id=' || p_chr_id);
3463: okl_debug_pub.logmessage('l_int_cal_basis=' || l_interest_calculation_basis);
3464: okl_debug_pub.logmessage('l_rev_rec_method=' || l_revenue_recognition_method);
3465: okl_debug_pub.logmessage('l_deal_type=' || l_deal_type);
3466: IF ( l_deal_type = 'LOAN' AND
3467: l_interest_calculation_basis IN ('FLOAT', 'CATCHUP/CLEANUP') ) OR
3468: ( l_deal_type = 'LOAN-REVOLVING' AND
3469: l_interest_calculation_basis = 'FLOAT' ) THEN

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

3486: END IF;
3487:
3488: -- 4895333
3489: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3490: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_id=' || l_payment_id);
3491: END IF;
3492: FOR r IN get_sts_code_csr(p_chr_id)
3493: LOOP
3494: l_sts_code := r.sts_code;

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

3493: LOOP
3494: l_sts_code := r.sts_code;
3495: END LOOP;
3496: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_sts_code=' || l_sts_code);
3498:
3499: END IF;
3500: FOR r_var_int_sched_counter_csr IN
3501: var_int_sched_counter_csr(p_chr_id, l_payment_id)

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

3503: l_var_int_sched_counter := r_var_int_sched_counter_csr.counter;
3504: END LOOP;
3505:
3506: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3507: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_var_int_sched_counter=' || l_var_int_sched_counter);
3508: END IF;
3509: -- 4895333
3510: IF (l_var_int_sched_counter < 1) AND (l_sts_code <> 'BOOKED') THEN
3511: get_payment(

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

3531: END IF;
3532:
3533: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then
3534: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3535: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_slh_id null... cant create...');
3536: END IF;
3537: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3538: x_msg_data => x_msg_data);
3539: return;

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

3672: AND sts.ste_code NOT IN ('EXPIRED','TERMINATED','CANCELLED');
3673:
3674: begin
3675: IF (G_DEBUG_ENABLED = 'Y') THEN
3676: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3677: END IF;
3678:
3679: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3680: x_return_status := OKL_API.START_ACTIVITY(