103: (l_deal_type LIKE 'LEASE%' AND l_int_cal_basis IN ('FLOAT_FACTORS','REAMORT') ) -- SECHAWLA 20-JAN-06 4970009 : added
104: ) THEN
105:
106: IF (is_debug_statement_on) THEN
107: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_VARIABLE_INT_UTIL_PVT.get_last_interim_int_calc_date');
108: END IF;
109: -- get last interest calculation till date
110: l_last_int_calc_till_date := OKL_VARIABLE_INT_UTIL_PVT.get_last_interim_int_calc_date(
111: x_return_status => l_return_status,
106: IF (is_debug_statement_on) THEN
107: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_VARIABLE_INT_UTIL_PVT.get_last_interim_int_calc_date');
108: END IF;
109: -- get last interest calculation till date
110: l_last_int_calc_till_date := OKL_VARIABLE_INT_UTIL_PVT.get_last_interim_int_calc_date(
111: x_return_status => l_return_status,
112: p_khr_id => p_contract_id);
113: IF (is_debug_statement_on) THEN
114: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_VARIABLE_INT_UTIL_PVT.get_last_interim_int_calc_date , return status: ' || l_return_status);
110: l_last_int_calc_till_date := OKL_VARIABLE_INT_UTIL_PVT.get_last_interim_int_calc_date(
111: x_return_status => l_return_status,
112: p_khr_id => p_contract_id);
113: IF (is_debug_statement_on) THEN
114: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_VARIABLE_INT_UTIL_PVT.get_last_interim_int_calc_date , return status: ' || l_return_status);
115: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_last_int_calc_till_date: ' || l_last_int_calc_till_date);
116: END IF;
117:
118: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
140:
141: -- get last scheduled interest calculation date before termination date
142:
143: IF (is_debug_statement_on) THEN
144: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_VARIABLE_INT_UTIL_PVT.get_last_sch_int_calc_date');
145: END IF;
146: -- added for bug 14049528
147: IF (p_trn_date > sysdate) THEN
148: l_trn_date := sysdate;
148: l_trn_date := sysdate;
149: ELSE
150: l_trn_date := p_trn_date;
151: END IF;
152: l_last_sch_int_calc_date := OKL_VARIABLE_INT_UTIL_PVT.get_last_sch_int_calc_date(
153: x_return_status => l_return_status,
154: p_khr_id => p_contract_id,
155: p_effective_date => l_trn_date);
156: IF (is_debug_statement_on) THEN
153: x_return_status => l_return_status,
154: p_khr_id => p_contract_id,
155: p_effective_date => l_trn_date);
156: IF (is_debug_statement_on) THEN
157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_VARIABLE_INT_UTIL_PVT.get_last_sch_int_calc_date , return status: ' || l_return_status);
158: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_last_sch_int_calc_date: ' || l_last_sch_int_calc_date);
159: END IF;
160:
161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN