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 1153: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

1149: --sechawla 18-dec-07 6690811 : Moved the folllowing code outside here from the IF below
1150: OPEN get_k_end_date_csr(p_term_rec.p_contract_id);
1151: 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
1152: CLOSE get_k_end_date_csr;
1153: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1154:
1155: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1156: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1157:

Line 1155: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

1151: 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
1152: CLOSE get_k_end_date_csr;
1153: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1154:
1155: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1156: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1157:
1158: ELSE
1159:

Line 1156: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

1152: CLOSE get_k_end_date_csr;
1153: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1154:
1155: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1156: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1157:
1158: ELSE
1159:
1160: l_quote_accpt_date := l_k_end_date; -- rmunjulu 4150696 Changed to pass contract end date

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

1191: -- rmunjulu EDAT
1192: -- If quote exists then cancelation date is quote eff from date else sysdate
1193:
1194: /* --sechawla 18-dec-07 6690811 : Moved outside the IF
1195: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1196:
1197: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1198: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1199:

Line 1197: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

1193:
1194: /* --sechawla 18-dec-07 6690811 : Moved outside the IF
1195: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1196:
1197: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1198: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1199:
1200: ELSE
1201:

Line 1198: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

1194: /* --sechawla 18-dec-07 6690811 : Moved outside the IF
1195: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
1196:
1197: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
1198: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
1199:
1200: ELSE
1201:
1202: l_quote_accpt_date := l_k_end_date; -- rmunjulu 4150696 Changed to pass contract end date

Line 2370: -- of OKL_AM_LEASE_LOAN_TRMNT_PVT api

2366: --
2367: -- Procedure Name : validate_lease
2368: -- Description : Validates the lease (Contract) -- Add additional validations
2369: -- if needed, most of the validations covered in validate_contract
2370: -- of OKL_AM_LEASE_LOAN_TRMNT_PVT api
2371: -- : RMUNJULU 3061751 SERVICE K INTEGRATION CODE
2372: -- Business Rules :
2373: -- Parameters :
2374: -- Version : 1.0

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

2492: IF p_term_rec.p_control_flag LIKE 'BATCH%'
2493: -- AND l_recycle_yn = 'N' THEN
2494: AND (p_term_rec.p_quote_id IS NULL OR p_term_rec.p_quote_id = OKL_API.G_MISS_NUM) THEN
2495:
2496: -- 20-JAN-06 SECHAWLA 4970009 : not required since OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done has
2497: -- been modified to check for lease contracts ('FLOAT_FACTORS','REAMORT')
2498: /* -- gboomina Bug 4755490 - Start
2499: FOR get_interest_calc_method_rec IN get_interest_calc_method_csr(p_term_rec.p_contract_id) LOOP
2500: l_interest_calc_method := get_interest_calc_method_rec.value;

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

2514: RAISE OKL_API.G_EXCEPTION_ERROR;
2515: END IF;
2516: END IF;
2517: -- gboomina Bug 4755490 - End
2518: */ -- 20-JAN-06 SECHAWLA 4970009 : not required since OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done has
2519: -- been modified to check for lease contracts ('FLOAT_FACTORS','REAMORT')
2520:
2521: -- 23-JAN-06 SECHAWLA 4970009 : begin
2522: OPEN l_okcheaders_b(p_term_rec.p_contract_id);

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

2525: -- 23-JAN-06 SECHAWLA 4970009 : end
2526:
2527: -- 20-JAN-06 SECHAWLA 4970009 : added begin
2528: IF (is_debug_statement_on) THEN
2529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done');
2530: END IF;
2531: l_int_calc_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done(
2532: p_contract_id => p_term_rec.p_contract_id,
2533: p_contract_number => p_term_rec.p_contract_number,

Line 2531: l_int_calc_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done(

2527: -- 20-JAN-06 SECHAWLA 4970009 : added begin
2528: IF (is_debug_statement_on) THEN
2529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done');
2530: END IF;
2531: l_int_calc_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_int_calc_done(
2532: p_contract_id => p_term_rec.p_contract_id,
2533: p_contract_number => p_term_rec.p_contract_number,
2534: -- p_quote_number => db_quote_number,
2535: p_source => 'TERMINATE',

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

2546: l_return_status := OKL_API.G_RET_STS_ERROR;
2547: END IF;
2548: -- 20-JAN-06 SECHAWLA 4970009 : added end
2549: IF (is_debug_statement_on) THEN
2550: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done');
2551: END IF;
2552: -- BPD Now provides a API which tells till when the billing was done, use that
2553: l_billing_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done(
2554: p_contract_id => p_term_rec.p_contract_id,

Line 2553: l_billing_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done(

2549: IF (is_debug_statement_on) THEN
2550: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done');
2551: END IF;
2552: -- BPD Now provides a API which tells till when the billing was done, use that
2553: l_billing_done := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_billing_done(
2554: p_contract_id => p_term_rec.p_contract_id,
2555: p_contract_number => p_term_rec.p_contract_number,
2556: p_trn_date => p_sys_date );
2557: IF (is_debug_statement_on) THEN

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

2993: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
2994:
2995: -- rmunjulu EDAT
2996: -- If quote exists then cancelation date is quote eff from date else sysdate
2997: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
2998:
2999: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3000: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3001:

Line 2999: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

2995: -- rmunjulu EDAT
2996: -- If quote exists then cancelation date is quote eff from date else sysdate
2997: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
2998:
2999: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3000: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3001:
3002: ELSE
3003:

Line 3000: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

2996: -- If quote exists then cancelation date is quote eff from date else sysdate
2997: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
2998:
2999: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3000: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3001:
3002: ELSE
3003:
3004: l_quote_accpt_date := p_sys_date;

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

4238: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
4239:
4240: -- rmunjulu EDAT
4241: -- If quote exists then cancelation date is quote eff from date else sysdate
4242: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4243:
4244: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4245: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4246:

Line 4244: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

4240: -- rmunjulu EDAT
4241: -- If quote exists then cancelation date is quote eff from date else sysdate
4242: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4243:
4244: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4245: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4246:
4247: ELSE
4248:

Line 4245: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

4241: -- If quote exists then cancelation date is quote eff from date else sysdate
4242: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4243:
4244: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4245: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4246:
4247: ELSE
4248:
4249: l_quote_accpt_date := p_sys_date;

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

4822:
4823: SAVEPOINT auto_invoice;
4824:
4825: -- If quote exists then close date is quote accept date else sysdate
4826: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4827:
4828: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4829: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4830:

Line 4828: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

4824:
4825: -- If quote exists then close date is quote accept date else sysdate
4826: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4827:
4828: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4829: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4830:
4831: ELSE
4832:

Line 4829: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

4825: -- If quote exists then close date is quote accept date else sysdate
4826: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4827:
4828: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4829: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4830:
4831: ELSE
4832:
4833: l_quote_accpt_date := p_sys_date;

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

5543: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
5544:
5545: -- rmunjulu EDAT
5546: -- If quote exists then close date is quote accept date else sysdate
5547: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
5548:
5549: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5550: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5551:

Line 5549: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

5545: -- rmunjulu EDAT
5546: -- If quote exists then close date is quote accept date else sysdate
5547: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
5548:
5549: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5550: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5551:
5552: ELSE
5553:

Line 5550: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

5546: -- If quote exists then close date is quote accept date else sysdate
5547: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
5548:
5549: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5550: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5551:
5552: ELSE
5553:
5554: l_quote_accpt_date := p_sys_date;

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

6686: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
6687:
6688: -- rmunjulu EDAT
6689: -- If quote exists then accnting date is quote accept date else sysdate
6690: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
6691: THEN
6692:
6693: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
6694: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

Line 6693: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

6689: -- If quote exists then accnting date is quote accept date else sysdate
6690: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
6691: THEN
6692:
6693: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
6694: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
6695:
6696: ELSE
6697:

Line 6694: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

6690: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
6691: THEN
6692:
6693: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
6694: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
6695:
6696: ELSE
6697:
6698: l_quote_accpt_date := l_k_end_date; -- rmunjulu Bug 4162862 Changed to contract end date

Line 7220: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y' THEN -- 13074256 Add condition to do Reversal Of Accruals only if Termination from Quote (Not if Expiration)

7216: IF nvl(p_source, '*') <> ('EVERGREEN')
7217: THEN
7218:
7219: -- rmunjulu bug 13074256, first do the reversal and then catchup or else reversal was reversing catchup
7220: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y' THEN -- 13074256 Add condition to do Reversal Of Accruals only if Termination from Quote (Not if Expiration)
7221:
7222: -- rmunjulu 4769094 Based on CHK_ACCRUAL_PREVIOUS_MNTH_YN setup check accruals till quote eff date OR previous month last date
7223: OPEN check_accrual_previous_csr;
7224: FETCH check_accrual_previous_csr

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

7225: INTO l_accrual_previous_mnth_yn;
7226: CLOSE check_accrual_previous_csr;
7227: -- fix for bug -- 5623356 -- added below condition
7228: -- If quote exists then cancelation date is quote eff from date else sysdate
7229: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
7230:
7231: -- asahoo bug 13259692 derive the period in which termination is falling first and then
7232: -- derive the current or next period based on Check_Accrual_Till_Previous_Month flag
7233:

Line 7548: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y' THEN -- 13074256 Add condition to do Accrual Acceleration only if Termination from Quote (Not if Expiration)

7544:
7545: */
7546: -- Bug#7248153 - rbruno - commented - End
7547:
7548: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y' THEN -- 13074256 Add condition to do Accrual Acceleration only if Termination from Quote (Not if Expiration)
7549: -- Added by ansethur for bug#6156337 08-Aug-2007 start
7550: FOR primary_sty_id_rec in primary_sty_id_csr(p_term_rec.p_contract_id) LOOP
7551:
7552:

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

7596: l_acceleration_rec.accelerate_till_date := l_accelerate_till_date;
7597: END IF;
7598: -- fix for bug -- 5623356 -- added below condition
7599: -- If quote exists then cancelation date is quote eff from date else sysdate
7600: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
7601: --akrangan Bug 5526955 fix start
7602: --Based on CHK_ACCRUAL_PREVIOUS_MNTH_YN setup check accruals till quote eff date OR previous month last date
7603: IF nvl(l_accrual_previous_mnth_yn,'N') = 'N' THEN
7604: l_acceleration_rec.accelerate_from_date := TRUNC(LAST_DAY(l_quote_eff_date) + 1);

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

7686:
7687: --Bug# 3999921: pagarg +++ T and A +++++++ Start ++++++++++
7688: END IF; -- p_term_rec.p_quote_type <> 'TER_RELEASE_WO_PURCHASE'
7689: IF (is_debug_statement_on) THEN
7690: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');
7691: END IF;
7692: okl_am_lease_loan_trmnt_pvt.process_adjustments(p_api_version => p_api_version,
7693: p_init_msg_list => okl_api.g_false,
7694: x_return_status => l_return_status,

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

7688: END IF; -- p_term_rec.p_quote_type <> 'TER_RELEASE_WO_PURCHASE'
7689: IF (is_debug_statement_on) THEN
7690: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');
7691: END IF;
7692: okl_am_lease_loan_trmnt_pvt.process_adjustments(p_api_version => p_api_version,
7693: p_init_msg_list => okl_api.g_false,
7694: x_return_status => l_return_status,
7695: x_msg_count => x_msg_count,
7696: x_msg_data => x_msg_data,

Line 7702: 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);

7698: p_tcnv_rec => px_tcnv_rec, -- rmunjulu TNA Added since trn_id is needed
7699: p_call_origin => 'FULL',
7700: p_termination_date => p_sys_date);
7701: IF (is_debug_statement_on) THEN
7702: 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);
7703: END IF;
7704:
7705: IF (is_debug_statement_on) THEN
7706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');

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

7702: 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);
7703: END IF;
7704:
7705: IF (is_debug_statement_on) THEN
7706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_adjustments');
7707: END IF;
7708: --Bug# 3999921: pagarg +++ T and A +++++++ End ++++++++++
7709:
7710: -- End MDOKAL Bug 3061765

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

7709:
7710: -- End MDOKAL Bug 3061765
7711: -- Smoduga
7712: -- Call to Process discount and Subsidy during acceptance of a termination quote
7713: okl_am_lease_loan_trmnt_pvt.process_discount_subsidy(p_api_version => p_api_version,
7714: p_init_msg_list => okl_api.g_false,
7715: x_return_status => l_return_status,
7716: x_msg_count => x_msg_count,
7717: x_msg_data => x_msg_data,

Line 7722: 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);

7718: p_term_rec => p_term_rec,
7719: p_call_origin => NULL,
7720: p_termination_date => p_sys_date);
7721: IF (is_debug_statement_on) THEN
7722: 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);
7723: END IF;
7724: IF l_return_status <> okl_api.g_ret_sts_success
7725: THEN
7726:

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

7737: END IF;
7738: -- Smoduga
7739: -- Call to Process discount and Subsidy during acceptance of a termination quote
7740: IF (is_debug_statement_on) THEN
7741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_loan_refunds');
7742: END IF;
7743: -- rmunjulu LOANS_ENHANCEMENTS Call to refund excess loan payments
7744: okl_am_lease_loan_trmnt_pvt.process_loan_refunds(p_api_version => p_api_version,
7745: p_init_msg_list => okl_api.g_false,

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

7740: IF (is_debug_statement_on) THEN
7741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_am_lease_loan_trmnt_pvt.process_loan_refunds');
7742: END IF;
7743: -- rmunjulu LOANS_ENHANCEMENTS Call to refund excess loan payments
7744: okl_am_lease_loan_trmnt_pvt.process_loan_refunds(p_api_version => p_api_version,
7745: p_init_msg_list => okl_api.g_false,
7746: x_return_status => l_return_status,
7747: x_msg_count => x_msg_count,
7748: x_msg_data => x_msg_data,

Line 7754: 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);

7750: p_tcnv_rec => px_tcnv_rec,
7751: p_call_origin => 'FULL',
7752: p_termination_date => p_sys_date);
7753: IF (is_debug_statement_on) THEN
7754: 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);
7755: END IF;
7756: IF l_return_status <> okl_api.g_ret_sts_success
7757: THEN
7758:

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

9391: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
9392:
9393: -- rmunjulu EDAT
9394: -- If quote exists then accnting date is quote accept date else sysdate
9395: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
9396:
9397: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
9398: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
9399:

Line 9397: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

9393: -- rmunjulu EDAT
9394: -- If quote exists then accnting date is quote accept date else sysdate
9395: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
9396:
9397: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
9398: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
9399:
9400: ELSE
9401:

Line 9398: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

9394: -- If quote exists then accnting date is quote accept date else sysdate
9395: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
9396:
9397: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
9398: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
9399:
9400: ELSE
9401:
9402: l_quote_accpt_date := p_sys_date;

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

10251: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
10252:
10253: -- rmunjulu EDAT
10254: -- If quote exists then accnting date is quote accept date else sysdate
10255: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
10256:
10257: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
10258: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
10259:

Line 10257: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

10253: -- rmunjulu EDAT
10254: -- If quote exists then accnting date is quote accept date else sysdate
10255: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
10256:
10257: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
10258: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
10259:
10260: ELSE
10261:

Line 10258: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

10254: -- If quote exists then accnting date is quote accept date else sysdate
10255: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
10256:
10257: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
10258: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
10259:
10260: ELSE
10261:
10262: l_quote_accpt_date := p_sys_date;

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

10296: -- if early termination assume from quote else contract exp
10297: -- IF (l_k_end_date <> OKL_API.G_MISS_DATE)
10298: -- AND (TRUNC(l_k_end_date) < TRUNC(p_sys_date)) THEN
10299: -- rmunjulu EDAT modified condition to say if quote exists then EXE_TERMINATION_QUOTE else EXPIRATION
10300: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN -- rmunjulu EDAT
10301: lp_artv_rec.art1_code := 'EXE_TERMINATION_QUOTE';
10302: ELSE
10303: lp_artv_rec.art1_code := 'CONTRACT_EXPIRATION';
10304: END IF;

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

10837:
10838: -- rmunjulu EDAT Get the quote effectivity date and quote acceptance date
10839: -- and store as global variables, will be used later on in other procedures
10840: IF (is_debug_statement_on) THEN
10841: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');
10842: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_term_rec.p_quote_id = '||l_term_rec.p_quote_id);
10843: END IF;
10844:
10845: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates(

Line 10845: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates(

10841: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');
10842: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_term_rec.p_quote_id = '||l_term_rec.p_quote_id);
10843: END IF;
10844:
10845: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates(
10846: p_qte_id => l_term_rec.p_quote_id,
10847: x_return_status => l_return_status);
10848: IF (is_debug_statement_on) THEN
10849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');

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

10845: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates(
10846: p_qte_id => l_term_rec.p_quote_id,
10847: x_return_status => l_return_status);
10848: IF (is_debug_statement_on) THEN
10849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_quote_dates');
10850: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'l_return_status = '||l_return_status);
10851: END IF;
10852:
10853: -- Rollback if error setting activity for api

Line 10968: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(

10964: p_trx_id => lp_tcnv_rec.id,
10965: x_return_status => l_return_status);
10966:
10967: -- RMUNJULU 3018641 Added code to get and set TMG_RUN
10968: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(
10969: p_trx_id => lp_tcnv_rec.id,
10970: x_return_status => l_return_status);
10971:
10972: -- abort since validation failed

Line 11041: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(

11037: p_trx_id => lp_tcnv_rec.id,
11038: x_return_status => l_return_status);
11039:
11040: -- RMUNJULU 3018641 Added code to get and set TMG_RUN
11041: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(
11042: p_trx_id => lp_tcnv_rec.id,
11043: x_return_status => l_return_status);
11044:
11045: -- abort since validation failed

Line 11111: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(

11107: p_trx_id => lp_tcnv_rec.id,
11108: x_return_status => l_return_status);
11109:
11110: -- RMUNJULU 3018641 Added code to get and set TMG_RUN
11111: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(
11112: p_trx_id => lp_tcnv_rec.id,
11113: x_return_status => l_return_status);
11114:
11115: -- abort since evergreen was found

Line 11283: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date

11279: ,x_return_status => l_return_status
11280: ,x_msg_count => x_msg_count
11281: ,x_msg_data => x_msg_data
11282: ,p_khr_id => l_term_rec.p_contract_id
11283: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date
11284: ,p_stream_type_subclass => 'RENT'
11285: ,x_value => l_is_securitized
11286: ,x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl );
11287: -- rollback if processing transaction failed

Line 11303: ,p_transaction_date => okl_am_lease_loan_trmnt_pvt.g_quote_accept_date

11299: ,p_init_msg_list => OKL_API.G_FALSE
11300: ,p_transaction_reason => OKL_SECURITIZATION_PVT.G_TRX_REASON_EARLY_TERMINATION
11301: ,p_khr_id => l_term_rec.p_contract_id
11302: ,p_stream_type_subclass => 'RENT'
11303: ,p_transaction_date => okl_am_lease_loan_trmnt_pvt.g_quote_accept_date
11304: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date
11305: ,x_return_status => l_return_status
11306: ,x_msg_count => x_msg_count
11307: ,x_msg_data => x_msg_data );

Line 11304: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date

11300: ,p_transaction_reason => OKL_SECURITIZATION_PVT.G_TRX_REASON_EARLY_TERMINATION
11301: ,p_khr_id => l_term_rec.p_contract_id
11302: ,p_stream_type_subclass => 'RENT'
11303: ,p_transaction_date => okl_am_lease_loan_trmnt_pvt.g_quote_accept_date
11304: ,p_effective_date => okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date
11305: ,x_return_status => l_return_status
11306: ,x_msg_count => x_msg_count
11307: ,x_msg_data => x_msg_data );
11308: -- rollback if processing transaction failed

Line 11398: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(

11394: p_trx_id => lp_tcnv_rec.id,
11395: x_return_status => l_return_status);
11396:
11397: -- RMUNJULU 3018641 Added code to get and set TMG_RUN
11398: OKL_AM_LEASE_LOAN_TRMNT_PVT.get_set_tmg_run(
11399: p_trx_id => lp_tcnv_rec.id,
11400: x_return_status => l_return_status);
11401:
11402: -- Set the return status