DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_AM_UTIL_PVT

Line 75: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');

71: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_trn_date: '|| p_trn_date);
72: END IF;
73:
74: IF (is_debug_statement_on) THEN
75: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
76: END IF;
77: -- Get the contract product details
78: OKL_AM_UTIL_PVT.get_contract_product_details(
79: p_khr_id => p_contract_id,

Line 78: OKL_AM_UTIL_PVT.get_contract_product_details(

74: IF (is_debug_statement_on) THEN
75: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
76: END IF;
77: -- Get the contract product details
78: OKL_AM_UTIL_PVT.get_contract_product_details(
79: p_khr_id => p_contract_id,
80: x_deal_type => l_deal_type,
81: x_rev_rec_method => l_rev_rec_method,
82: x_int_cal_basis => l_int_cal_basis,

Line 86: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_product_details , return status: ' || l_return_status);

82: x_int_cal_basis => l_int_cal_basis,
83: x_tax_owner => l_tax_owner,
84: x_return_status => l_return_status);
85: IF (is_debug_statement_on) THEN
86: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_product_details , return status: ' || l_return_status);
87: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_deal_type: ' || l_deal_type);
88: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rev_rec_method: ' || l_rev_rec_method);
89: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_int_cal_basis: ' || l_int_cal_basis);
90: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_tax_owner: ' || l_tax_owner);

Line 1875: lx_trn_tbl OKL_AM_UTIL_PVT.trn_tbl_type;

1871:
1872:
1873: -- RMUNJULU -- 11-DEC-02 Bug # 2484327 -- Added variables for checking
1874: -- related to asset level termination
1875: lx_trn_tbl OKL_AM_UTIL_PVT.trn_tbl_type;
1876: i NUMBER;
1877:
1878: -- RMUNJULU 18-DEC-02 2484327 -- Added variable for checking
1879: -- related to asset level termination

Line 1880: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;

1876: i NUMBER;
1877:
1878: -- RMUNJULU 18-DEC-02 2484327 -- Added variable for checking
1879: -- related to asset level termination
1880: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
1881:
1882:
1883:
1884: BEGIN

Line 2014: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');

2010: -- *****************
2011:
2012:
2013: IF (is_debug_statement_on) THEN
2014: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');
2015: END IF;
2016: -- Get all the unprocessed transactions for the contract
2017: OKL_AM_UTIL_PVT.get_contract_transactions (
2018: p_khr_id => k_header_rec.id,

Line 2017: OKL_AM_UTIL_PVT.get_contract_transactions (

2013: IF (is_debug_statement_on) THEN
2014: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');
2015: END IF;
2016: -- Get all the unprocessed transactions for the contract
2017: OKL_AM_UTIL_PVT.get_contract_transactions (
2018: p_khr_id => k_header_rec.id,
2019: x_trn_tbl => lx_trn_tbl,
2020: x_return_status => l_return_status);
2021: IF (is_debug_statement_on) THEN

Line 2022: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_transactions , return status: ' || l_return_status);

2018: p_khr_id => k_header_rec.id,
2019: x_trn_tbl => lx_trn_tbl,
2020: x_return_status => l_return_status);
2021: IF (is_debug_statement_on) THEN
2022: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_transactions , return status: ' || l_return_status);
2023: END IF;
2024:
2025:
2026: -- Check the return status

Line 2056: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');

2052: -- IF NO accepted quote with no trn exists for contract then error
2053: -- *****************
2054:
2055: IF (is_debug_statement_on) THEN
2056: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');
2057: END IF;
2058: -- Get accepted quote for contract with no trn
2059: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (
2060: p_khr_id => k_header_rec.id,

Line 2059: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (

2055: IF (is_debug_statement_on) THEN
2056: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');
2057: END IF;
2058: -- Get accepted quote for contract with no trn
2059: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (
2060: p_khr_id => k_header_rec.id,
2061: x_quote_tbl => lx_quote_tbl,
2062: x_return_status => l_return_status);
2063: IF (is_debug_statement_on) THEN

Line 2064: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_non_trn_contract_quotes , return status: ' || l_return_status);

2060: p_khr_id => k_header_rec.id,
2061: x_quote_tbl => lx_quote_tbl,
2062: x_return_status => l_return_status);
2063: IF (is_debug_statement_on) THEN
2064: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_non_trn_contract_quotes , return status: ' || l_return_status);
2065: END IF;
2066:
2067: -- Check the return status
2068: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2124: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');

2120: -- IF unprocessed FULL termination trn exists for the contract then error
2121: -- *****************
2122:
2123: IF (is_debug_statement_on) THEN
2124: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');
2125: END IF;
2126: -- Get all the unprocessed transactions for the contract
2127: OKL_AM_UTIL_PVT.get_contract_transactions (
2128: p_khr_id => k_header_rec.id,

Line 2127: OKL_AM_UTIL_PVT.get_contract_transactions (

2123: IF (is_debug_statement_on) THEN
2124: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');
2125: END IF;
2126: -- Get all the unprocessed transactions for the contract
2127: OKL_AM_UTIL_PVT.get_contract_transactions (
2128: p_khr_id => k_header_rec.id,
2129: x_trn_tbl => lx_trn_tbl,
2130: x_return_status => l_return_status);
2131: IF (is_debug_statement_on) THEN

Line 2132: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_transactions , return status: ' || l_return_status);

2128: p_khr_id => k_header_rec.id,
2129: x_trn_tbl => lx_trn_tbl,
2130: x_return_status => l_return_status);
2131: IF (is_debug_statement_on) THEN
2132: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_transactions , return status: ' || l_return_status);
2133: END IF;
2134:
2135: -- Check the return status
2136: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2817: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;

2813: l_partial_yn VARCHAR2(1) := 'N';
2814:
2815: -- RMUNJULU 18-DEC-02 2484327
2816: l_qte_rec l_qte_csr%ROWTYPE;
2817: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
2818:
2819: -- RMUNJULU 3061751 27-AUG-2003
2820: l_service_integration_needed VARCHAR2(3) := 'N';
2821:

Line 2945: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');

2941: -- Get accepted quote with no trn if exists for contract
2942: -- *****************
2943:
2944: IF (is_debug_statement_on) THEN
2945: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');
2946: END IF;
2947: -- Get accepted quote for contract with no trn
2948: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (
2949: p_khr_id => lp_term_rec.p_contract_id,

Line 2948: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (

2944: IF (is_debug_statement_on) THEN
2945: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');
2946: END IF;
2947: -- Get accepted quote for contract with no trn
2948: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (
2949: p_khr_id => lp_term_rec.p_contract_id,
2950: x_quote_tbl => lx_quote_tbl,
2951: x_return_status => l_return_status);
2952: IF (is_debug_statement_on) THEN

Line 2953: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_non_trn_contract_quotes , return status: ' || l_return_status);

2949: p_khr_id => lp_term_rec.p_contract_id,
2950: x_quote_tbl => lx_quote_tbl,
2951: x_return_status => l_return_status);
2952: IF (is_debug_statement_on) THEN
2953: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_non_trn_contract_quotes , return status: ' || l_return_status);
2954: END IF;
2955:
2956: -- Check the return status
2957: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 5018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');

5014: l_quote_eff_date := p_termination_date;
5015: END IF;
5016:
5017: IF (is_debug_statement_on) THEN
5018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
5019: END IF;
5020: okl_am_util_pvt.get_transaction_id (
5021: p_try_name => 'CREDIT MEMO',
5022: x_return_status => l_return_status,

Line 5020: okl_am_util_pvt.get_transaction_id (

5016:
5017: IF (is_debug_statement_on) THEN
5018: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
5019: END IF;
5020: okl_am_util_pvt.get_transaction_id (
5021: p_try_name => 'CREDIT MEMO',
5022: x_return_status => l_return_status,
5023: x_try_id => l_cm_try_id);
5024: IF (is_debug_statement_on) THEN

Line 5025: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status : ' || l_return_status);

5021: p_try_name => 'CREDIT MEMO',
5022: x_return_status => l_return_status,
5023: x_try_id => l_cm_try_id);
5024: IF (is_debug_statement_on) THEN
5025: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status : ' || l_return_status);
5026: END IF;
5027:
5028: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
5029: OR NVL (l_cm_try_id, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM

Line 5251: okl_am_util_pvt.get_transaction_id (

5247: IF lx_accrual_adjustment_tbl.COUNT > 0 THEN
5248:
5249: -- rmunjulu TNA Brought the below code into this IF
5250: /* -- rmunjulu TNA Not needed
5251: okl_am_util_pvt.get_transaction_id (
5252: p_try_name => 'TERMINATION',
5253: x_return_status => l_return_status,
5254: x_try_id => l_trmnt_try_id);
5255:

Line 5591: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_excess_loan_payment');

5587: END IF;
5588:
5589: -- get excess loan payment amount
5590: IF (is_debug_statement_on) THEN
5591: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_excess_loan_payment');
5592: END IF;
5593: l_loan_refund_amount := OKL_AM_UTIL_PVT.get_excess_loan_payment(
5594: x_return_status => l_return_status,
5595: p_khr_id => p_term_rec.p_contract_id);

Line 5593: l_loan_refund_amount := OKL_AM_UTIL_PVT.get_excess_loan_payment(

5589: -- get excess loan payment amount
5590: IF (is_debug_statement_on) THEN
5591: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_excess_loan_payment');
5592: END IF;
5593: l_loan_refund_amount := OKL_AM_UTIL_PVT.get_excess_loan_payment(
5594: x_return_status => l_return_status,
5595: p_khr_id => p_term_rec.p_contract_id);
5596: IF (is_debug_statement_on) THEN
5597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_excess_loan_payment , return status : ' || l_return_status);

Line 5597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_excess_loan_payment , return status : ' || l_return_status);

5593: l_loan_refund_amount := OKL_AM_UTIL_PVT.get_excess_loan_payment(
5594: x_return_status => l_return_status,
5595: p_khr_id => p_term_rec.p_contract_id);
5596: IF (is_debug_statement_on) THEN
5597: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_excess_loan_payment , return status : ' || l_return_status);
5598: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_loan_refund_amount : ' || l_loan_refund_amount);
5599: END IF;
5600:
5601: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5612: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_transaction_id');

5608:
5609: IF l_loan_refund_amount <> 0 THEN
5610:
5611: IF (is_debug_statement_on) THEN
5612: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_transaction_id');
5613: END IF;
5614: OKL_AM_UTIL_PVT.get_transaction_id (
5615: p_try_name => 'CREDIT MEMO',
5616: x_return_status => l_return_status,

Line 5614: OKL_AM_UTIL_PVT.get_transaction_id (

5610:
5611: IF (is_debug_statement_on) THEN
5612: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_transaction_id');
5613: END IF;
5614: OKL_AM_UTIL_PVT.get_transaction_id (
5615: p_try_name => 'CREDIT MEMO',
5616: x_return_status => l_return_status,
5617: x_try_id => l_cm_try_id);
5618: IF (is_debug_statement_on) THEN

Line 5619: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_transaction_id , return status : ' || l_return_status);

5615: p_try_name => 'CREDIT MEMO',
5616: x_return_status => l_return_status,
5617: x_try_id => l_cm_try_id);
5618: IF (is_debug_statement_on) THEN
5619: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_transaction_id , return status : ' || l_return_status);
5620: END IF;
5621:
5622: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
5623: OR NVL (l_cm_try_id, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM

Line 5635: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();

5631:
5632: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5633: END IF;
5634:
5635: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();
5636:
5637: IF (is_debug_statement_on) THEN
5638: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
5639: END IF;