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.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_AM_LEASE_LOAN_TRMNT_PVT

Line 161: OKL_AM_LEASE_LOAN_TRMNT_PVT

157: -- All other errors such as not able to do accounting entries, or not able to
158: -- update k header or lines will result in soft error so will be propagated
159: -- out of this API as "Success".
160:
161: OKL_AM_LEASE_LOAN_TRMNT_PVT
162: -- The Rec Type procedure calls the rec type of Lease termination API
163: -- The Tbl Type procedure calls the rec type of this same API
164:
165: OKL_AM_LEASE_LOAN_TRMNT_PUB

Line 1037: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

1033: --sechawla 18-dec-07 6690811 : Moved the folllowing code outside here from the IF below
1034: OPEN get_k_end_date_csr(p_term_rec.p_contract_id);
1035: FETCH get_k_end_date_csr INTO l_k_end_date, l_k_sts_code; --sechawla 18-dec-07 6690811 : added l_k_sts_code
1036: CLOSE get_k_end_date_csr;
1037: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1038:
1039: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1040: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1041:

Line 1039: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

1035: FETCH get_k_end_date_csr INTO l_k_end_date, l_k_sts_code; --sechawla 18-dec-07 6690811 : added l_k_sts_code
1036: CLOSE get_k_end_date_csr;
1037: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1038:
1039: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1040: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1041:
1042: ELSE
1043:

Line 1040: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

1036: CLOSE get_k_end_date_csr;
1037: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1038:
1039: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1040: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1041:
1042: ELSE
1043:
1044: l_quote_accpt_date := l_k_end_date; -- rmunjulu 4150696 Changed to pass contract end date

Line 1079: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

1075: -- rmunjulu EDAT
1076: -- If quote exists then cancelation date is quote eff from date else sysdate
1077:
1078: /* --sechawla 18-dec-07 6690811 : Moved outside the IF
1079: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1080:
1081: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1082: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1083:

Line 1081: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

1077:
1078: /* --sechawla 18-dec-07 6690811 : Moved outside the IF
1079: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1080:
1081: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1082: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1083:
1084: ELSE
1085:

Line 1082: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

1078: /* --sechawla 18-dec-07 6690811 : Moved outside the IF
1079: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1080:
1081: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1082: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1083:
1084: ELSE
1085:
1086: l_quote_accpt_date := l_k_end_date; -- rmunjulu 4150696 Changed to pass contract end date

Line 2254: -- of OKL_AM_LEASE_LOAN_TRMNT_PVT api

2250: --
2251: -- Procedure Name : validate_lease
2252: -- Description : Validates the lease (Contract) -- Add additional validations
2253: -- if needed, most of the validations covered in validate_contract
2254: -- of OKL_AM_LEASE_LOAN_TRMNT_PVT api
2255: -- : RMUNJULU 3061751 SERVICE K INTEGRATION CODE
2256: -- Business Rules :
2257: -- Parameters :
2258: -- Version : 1.0

Line 2380: -- 20-JAN-06 SECHAWLA 4970009 : not required since OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done has

2376: IF p_term_rec.p_control_flag LIKE 'BATCH%'
2377: -- AND l_recycle_yn = 'N' THEN
2378: AND (p_term_rec.p_quote_id IS NULL OR p_term_rec.p_quote_id = OKL_API.G_MISS_NUM) THEN
2379:
2380: -- 20-JAN-06 SECHAWLA 4970009 : not required since OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done has
2381: -- been modified to check for lease contracts ('FLOAT_FACTORS','REAMORT')
2382: /* -- gboomina Bug 4755490 - Start
2383: FOR get_interest_calc_method_rec IN get_interest_calc_method_csr(p_term_rec.p_contract_id) LOOP
2384: l_interest_calc_method := get_interest_calc_method_rec.value;

Line 2402: */ -- 20-JAN-06 SECHAWLA 4970009 : not required since OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done has

2398: RAISE OKL_API.G_EXCEPTION_ERROR;
2399: END IF;
2400: END IF;
2401: -- gboomina Bug 4755490 - End
2402: */ -- 20-JAN-06 SECHAWLA 4970009 : not required since OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done has
2403: -- been modified to check for lease contracts ('FLOAT_FACTORS','REAMORT')
2404:
2405: -- 23-JAN-06 SECHAWLA 4970009 : begin
2406: OPEN l_okcheaders_b(p_term_rec.p_contract_id);

Line 2413: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done');

2409: -- 23-JAN-06 SECHAWLA 4970009 : end
2410:
2411: -- 20-JAN-06 SECHAWLA 4970009 : added begin
2412: IF (is_debug_statement_on) THEN
2413: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done');
2414: END IF;
2415: l_int_calc_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done(
2416: p_contract_id => p_term_rec.p_contract_id,
2417: p_contract_number => p_term_rec.p_contract_number,

Line 2415: l_int_calc_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done(

2411: -- 20-JAN-06 SECHAWLA 4970009 : added begin
2412: IF (is_debug_statement_on) THEN
2413: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done');
2414: END IF;
2415: l_int_calc_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done(
2416: p_contract_id => p_term_rec.p_contract_id,
2417: p_contract_number => p_term_rec.p_contract_number,
2418: -- p_quote_number => db_quote_number,
2419: p_source => 'TERMINATE',

Line 2434: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done');

2430: l_return_status := OKL_API.G_RET_STS_ERROR;
2431: END IF;
2432: -- 20-JAN-06 SECHAWLA 4970009 : added end
2433: IF (is_debug_statement_on) THEN
2434: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done');
2435: END IF;
2436: -- BPD Now provides a API which tells till when the billing was done, use that
2437: l_billing_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done(
2438: p_contract_id => p_term_rec.p_contract_id,

Line 2437: l_billing_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done(

2433: IF (is_debug_statement_on) THEN
2434: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done');
2435: END IF;
2436: -- BPD Now provides a API which tells till when the billing was done, use that
2437: l_billing_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done(
2438: p_contract_id => p_term_rec.p_contract_id,
2439: p_contract_number => p_term_rec.p_contract_number,
2440: p_trn_date => p_sys_date );
2441: IF (is_debug_statement_on) THEN

Line 2881: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

2877: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
2878:
2879: -- rmunjulu EDAT
2880: -- If quote exists then cancelation date is quote eff from date else sysdate
2881: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
2882:
2883: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
2884: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
2885:

Line 2883: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

2879: -- rmunjulu EDAT
2880: -- If quote exists then cancelation date is quote eff from date else sysdate
2881: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
2882:
2883: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
2884: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
2885:
2886: ELSE
2887:

Line 2884: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

2880: -- If quote exists then cancelation date is quote eff from date else sysdate
2881: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
2882:
2883: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
2884: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
2885:
2886: ELSE
2887:
2888: l_quote_accpt_date := p_sys_date;

Line 4126: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

4122: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
4123:
4124: -- rmunjulu EDAT
4125: -- If quote exists then cancelation date is quote eff from date else sysdate
4126: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4127:
4128: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4129: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4130:

Line 4128: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

4124: -- rmunjulu EDAT
4125: -- If quote exists then cancelation date is quote eff from date else sysdate
4126: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4127:
4128: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4129: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4130:
4131: ELSE
4132:

Line 4129: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

4125: -- If quote exists then cancelation date is quote eff from date else sysdate
4126: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4127:
4128: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4129: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4130:
4131: ELSE
4132:
4133: l_quote_accpt_date := p_sys_date;

Line 4682: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

4678:
4679: SAVEPOINT auto_invoice;
4680:
4681: -- If quote exists then close date is quote accept date else sysdate
4682: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4683:
4684: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4685: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4686:

Line 4684: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

4680:
4681: -- If quote exists then close date is quote accept date else sysdate
4682: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4683:
4684: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4685: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4686:
4687: ELSE
4688:

Line 4685: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

4681: -- If quote exists then close date is quote accept date else sysdate
4682: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4683:
4684: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4685: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4686:
4687: ELSE
4688:
4689: l_quote_accpt_date := p_sys_date;

Line 5381: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

5377: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
5378:
5379: -- rmunjulu EDAT
5380: -- If quote exists then close date is quote accept date else sysdate
5381: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
5382:
5383: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5384: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5385:

Line 5383: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

5379: -- rmunjulu EDAT
5380: -- If quote exists then close date is quote accept date else sysdate
5381: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
5382:
5383: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5384: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5385:
5386: ELSE
5387:

Line 5384: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

5380: -- If quote exists then close date is quote accept date else sysdate
5381: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
5382:
5383: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5384: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5385:
5386: ELSE
5387:
5388: l_quote_accpt_date := p_sys_date;

Line 6518: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'

6514: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
6515:
6516: -- rmunjulu EDAT
6517: -- If quote exists then accnting date is quote accept date else sysdate
6518: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
6519: THEN
6520:
6521: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
6522: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

Line 6521: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

6517: -- If quote exists then accnting date is quote accept date else sysdate
6518: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
6519: THEN
6520:
6521: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
6522: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
6523:
6524: ELSE
6525:

Line 6522: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

6518: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
6519: THEN
6520:
6521: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
6522: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
6523:
6524: ELSE
6525:
6526: l_quote_accpt_date := l_k_end_date; -- rmunjulu Bug 4162862 Changed to contract end date

Line 7245: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

7241: INTO l_accrual_previous_mnth_yn;
7242: CLOSE check_accrual_previous_csr;
7243: -- fix for bug -- 5623356 -- added below condition
7244: -- If quote exists then cancelation date is quote eff from date else sysdate
7245: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
7246: IF nvl(l_accrual_previous_mnth_yn, 'N') = 'N'
7247: THEN
7248: -- rmunjulu 4769094 continue with current reversal date as quote effective date
7249: -- rmunjulu bug 4507662

Line 7411: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

7407: l_acceleration_rec.accelerate_till_date := l_accelerate_till_date;
7408: END IF;
7409: -- fix for bug -- 5623356 -- added below condition
7410: -- If quote exists then cancelation date is quote eff from date else sysdate
7411: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
7412: --akrangan Bug 5526955 fix start
7413: --Based on CHK_ACCRUAL_PREVIOUS_MNTH_YN setup check accruals till quote eff date OR previous month last date
7414: IF nvl(l_accrual_previous_mnth_yn,'N') = 'N' THEN
7415: l_acceleration_rec.accelerate_from_date := TRUNC(LAST_DAY(l_quote_eff_date) + 1);

Line 7491: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');

7487: END LOOP; -- Added by ansethur for bug#6156337 08-Aug-2007 start
7488: --Bug# 3999921: pagarg +++ T and A +++++++ Start ++++++++++
7489: END IF; -- p_term_rec.p_quote_type <> 'TER_RELEASE_WO_PURCHASE'
7490: IF (is_debug_statement_on) THEN
7491: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');
7492: END IF;
7493: okl_am_lease_loan_trmnt_pvt.process_adjustments(p_api_version => p_api_version,
7494: p_init_msg_list => okl_api.g_false,
7495: x_return_status => l_return_status,

Line 7493: okl_am_lease_loan_trmnt_pvt.process_adjustments(p_api_version => p_api_version,

7489: END IF; -- p_term_rec.p_quote_type <> 'TER_RELEASE_WO_PURCHASE'
7490: IF (is_debug_statement_on) THEN
7491: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');
7492: END IF;
7493: okl_am_lease_loan_trmnt_pvt.process_adjustments(p_api_version => p_api_version,
7494: p_init_msg_list => okl_api.g_false,
7495: x_return_status => l_return_status,
7496: x_msg_count => x_msg_count,
7497: x_msg_data => x_msg_data,

Line 7503: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_am_lease_loan_trmnt_pvt.process_adjustments l_return_status = '||l_return_status);

7499: p_tcnv_rec => px_tcnv_rec, -- rmunjulu TNA Added since trn_id is needed
7500: p_call_origin => 'FULL',
7501: p_termination_date => p_sys_date);
7502: IF (is_debug_statement_on) THEN
7503: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_am_lease_loan_trmnt_pvt.process_adjustments l_return_status = '||l_return_status);
7504: END IF;
7505:
7506: IF (is_debug_statement_on) THEN
7507: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');

Line 7507: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');

7503: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_am_lease_loan_trmnt_pvt.process_adjustments l_return_status = '||l_return_status);
7504: END IF;
7505:
7506: IF (is_debug_statement_on) THEN
7507: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');
7508: END IF;
7509: --Bug# 3999921: pagarg +++ T and A +++++++ End ++++++++++
7510:
7511: -- End MDOKAL Bug 3061765

Line 7514: okl_am_lease_loan_trmnt_pvt.process_discount_subsidy(p_api_version => p_api_version,

7510:
7511: -- End MDOKAL Bug 3061765
7512: -- Smoduga
7513: -- Call to Process discount and Subsidy during acceptance of a termination quote
7514: okl_am_lease_loan_trmnt_pvt.process_discount_subsidy(p_api_version => p_api_version,
7515: p_init_msg_list => okl_api.g_false,
7516: x_return_status => l_return_status,
7517: x_msg_count => x_msg_count,
7518: x_msg_data => x_msg_data,

Line 7523: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_am_lease_loan_trmnt_pvt.process_adjustments l_return_status = '||l_return_status);

7519: p_term_rec => p_term_rec,
7520: p_call_origin => NULL,
7521: p_termination_date => p_sys_date);
7522: IF (is_debug_statement_on) THEN
7523: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_am_lease_loan_trmnt_pvt.process_adjustments l_return_status = '||l_return_status);
7524: END IF;
7525: IF l_return_status <> okl_api.g_ret_sts_success
7526: THEN
7527:

Line 7542: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_loan_refunds');

7538: END IF;
7539: -- Smoduga
7540: -- Call to Process discount and Subsidy during acceptance of a termination quote
7541: IF (is_debug_statement_on) THEN
7542: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_loan_refunds');
7543: END IF;
7544: -- rmunjulu LOANS_ENHANCEMENTS Call to refund excess loan payments
7545: okl_am_lease_loan_trmnt_pvt.process_loan_refunds(p_api_version => p_api_version,
7546: p_init_msg_list => okl_api.g_false,

Line 7545: okl_am_lease_loan_trmnt_pvt.process_loan_refunds(p_api_version => p_api_version,

7541: IF (is_debug_statement_on) THEN
7542: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_loan_refunds');
7543: END IF;
7544: -- rmunjulu LOANS_ENHANCEMENTS Call to refund excess loan payments
7545: okl_am_lease_loan_trmnt_pvt.process_loan_refunds(p_api_version => p_api_version,
7546: p_init_msg_list => okl_api.g_false,
7547: x_return_status => l_return_status,
7548: x_msg_count => x_msg_count,
7549: x_msg_data => x_msg_data,

Line 7555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_am_lease_loan_trmnt_pvt.process_loan_refunds l_return_status = '||l_return_status);

7551: p_tcnv_rec => px_tcnv_rec,
7552: p_call_origin => 'FULL',
7553: p_termination_date => p_sys_date);
7554: IF (is_debug_statement_on) THEN
7555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_am_lease_loan_trmnt_pvt.process_loan_refunds l_return_status = '||l_return_status);
7556: END IF;
7557: IF l_return_status <> okl_api.g_ret_sts_success
7558: THEN
7559:

Line 9196: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

9192: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
9193:
9194: -- rmunjulu EDAT
9195: -- If quote exists then accnting date is quote accept date else sysdate
9196: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
9197:
9198: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
9199: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
9200:

Line 9198: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

9194: -- rmunjulu EDAT
9195: -- If quote exists then accnting date is quote accept date else sysdate
9196: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
9197:
9198: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
9199: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
9200:
9201: ELSE
9202:

Line 9199: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

9195: -- If quote exists then accnting date is quote accept date else sysdate
9196: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
9197:
9198: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
9199: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
9200:
9201: ELSE
9202:
9203: l_quote_accpt_date := p_sys_date;

Line 10056: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

10052: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
10053:
10054: -- rmunjulu EDAT
10055: -- If quote exists then accnting date is quote accept date else sysdate
10056: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
10057:
10058: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
10059: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
10060:

Line 10058: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

10054: -- rmunjulu EDAT
10055: -- If quote exists then accnting date is quote accept date else sysdate
10056: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
10057:
10058: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
10059: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
10060:
10061: ELSE
10062:

Line 10059: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

10055: -- If quote exists then accnting date is quote accept date else sysdate
10056: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
10057:
10058: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
10059: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
10060:
10061: ELSE
10062:
10063: l_quote_accpt_date := p_sys_date;

Line 10101: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN -- rmunjulu EDAT

10097: -- if early termination assume from quote else contract exp
10098: -- IF (l_k_end_date <> OKL_API.G_MISS_DATE)
10099: -- AND (TRUNC(l_k_end_date) < TRUNC(p_sys_date)) THEN
10100: -- rmunjulu EDAT modified condition to say if quote exists then EXE_TERMINATION_QUOTE else EXPIRATION
10101: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN -- rmunjulu EDAT
10102: lp_artv_rec.art1_code := 'EXE_TERMINATION_QUOTE';
10103: ELSE
10104: lp_artv_rec.art1_code := 'CONTRACT_EXPIRATION';
10105: END IF;

Line 10642: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');

10638:
10639: -- rmunjulu EDAT Get the quote effectivity date and quote acceptance date
10640: -- and store as global variables, will be used later on in other procedures
10641: IF (is_debug_statement_on) THEN
10642: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');
10643: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_term_rec.p_quote_id = '||l_term_rec.p_quote_id);
10644: END IF;
10645:
10646: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates(

Line 10646: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates(

10642: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');
10643: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_term_rec.p_quote_id = '||l_term_rec.p_quote_id);
10644: END IF;
10645:
10646: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates(
10647: p_qte_id => l_term_rec.p_quote_id,
10648: x_return_status => l_return_status);
10649: IF (is_debug_statement_on) THEN
10650: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');

Line 10650: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');

10646: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates(
10647: p_qte_id => l_term_rec.p_quote_id,
10648: x_return_status => l_return_status);
10649: IF (is_debug_statement_on) THEN
10650: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');
10651: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_return_status = '||l_return_status);
10652: END IF;
10653:
10654: -- Rollback if error setting activity for api

Line 10769: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(

10765: p_trx_id => lp_tcnv_rec.id,
10766: x_return_status => l_return_status);
10767:
10768: -- RMUNJULU 3018641 Added code to get and set TMG_RUN
10769: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(
10770: p_trx_id => lp_tcnv_rec.id,
10771: x_return_status => l_return_status);
10772:
10773: -- abort since validation failed

Line 10842: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(

10838: p_trx_id => lp_tcnv_rec.id,
10839: x_return_status => l_return_status);
10840:
10841: -- RMUNJULU 3018641 Added code to get and set TMG_RUN
10842: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(
10843: p_trx_id => lp_tcnv_rec.id,
10844: x_return_status => l_return_status);
10845:
10846: -- abort since validation failed

Line 10912: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(

10908: p_trx_id => lp_tcnv_rec.id,
10909: x_return_status => l_return_status);
10910:
10911: -- RMUNJULU 3018641 Added code to get and set TMG_RUN
10912: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(
10913: p_trx_id => lp_tcnv_rec.id,
10914: x_return_status => l_return_status);
10915:
10916: -- abort since evergreen was found

Line 11084: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date

11080: ,x_return_status => l_return_status
11081: ,x_msg_count => x_msg_count
11082: ,x_msg_data => x_msg_data
11083: ,p_khr_id => l_term_rec.p_contract_id
11084: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date
11085: ,p_stream_type_subclass => 'RENT'
11086: ,x_value => l_is_securitized
11087: ,x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl );
11088: -- rollback if processing transaction failed

Line 11104: ,p_transaction_date => okl_am_lease_loan_trmnt_pvt.g_quote_accept_date

11100: ,p_init_msg_list => OKL_API.G_FALSE
11101: ,p_transaction_reason => OKL_SECURITIZATION_PVT.G_TRX_REASON_EARLY_TERMINATION
11102: ,p_khr_id => l_term_rec.p_contract_id
11103: ,p_stream_type_subclass => 'RENT'
11104: ,p_transaction_date => okl_am_lease_loan_trmnt_pvt.g_quote_accept_date
11105: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date
11106: ,x_return_status => l_return_status
11107: ,x_msg_count => x_msg_count
11108: ,x_msg_data => x_msg_data );

Line 11105: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date

11101: ,p_transaction_reason => OKL_SECURITIZATION_PVT.G_TRX_REASON_EARLY_TERMINATION
11102: ,p_khr_id => l_term_rec.p_contract_id
11103: ,p_stream_type_subclass => 'RENT'
11104: ,p_transaction_date => okl_am_lease_loan_trmnt_pvt.g_quote_accept_date
11105: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date
11106: ,x_return_status => l_return_status
11107: ,x_msg_count => x_msg_count
11108: ,x_msg_data => x_msg_data );
11109: -- rollback if processing transaction failed

Line 11199: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(

11195: p_trx_id => lp_tcnv_rec.id,
11196: x_return_status => l_return_status);
11197:
11198: -- RMUNJULU 3018641 Added code to get and set TMG_RUN
11199: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(
11200: p_trx_id => lp_tcnv_rec.id,
11201: x_return_status => l_return_status);
11202:
11203: -- Set the return status