APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_API

Line 15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

11: G_EXCEPTION_STOP_VALIDATION exception;
12:
13:
14: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LA_PAYMENTS_PVT';
15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
16: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
17: l_api_name VARCHAR2(35) := 'LA_PAYMENTS';
18:
19: l_detail_count NUMBER := 0;

Line 73: l_ret_value := OKL_API.G_FALSE;

69: l_ret_value VARCHAR2(1);
70:
71: BEGIN
72:
73: l_ret_value := OKL_API.G_FALSE;
74:
75: OPEN l_fee_csr(p_cle_id => p_cle_id);
76: FETCH l_fee_csr INTO l_fee_rec;
77: CLOSE l_fee_csr;

Line 80: l_ret_value := OKL_API.G_TRUE;

76: FETCH l_fee_csr INTO l_fee_rec;
77: CLOSE l_fee_csr;
78:
79: IF l_fee_rec.fee_purpose_code = 'SALESTAX' THEN
80: l_ret_value := OKL_API.G_TRUE;
81: END IF;
82:
83: RETURN l_ret_value;
84:

Line 111: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

107: x_msg_count => x_msg_count,
108: x_msg_data => x_msg_data,
109: p_chr_id => p_chr_id);
110:
111: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
112: l_upfront_tax_prog_sts := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR;
113: x_return_status := OKL_API.G_RET_STS_SUCCESS;
114: ELSE
115: l_upfront_tax_prog_sts := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 113: x_return_status := OKL_API.G_RET_STS_SUCCESS;

109: p_chr_id => p_chr_id);
110:
111: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
112: l_upfront_tax_prog_sts := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR;
113: x_return_status := OKL_API.G_RET_STS_SUCCESS;
114: ELSE
115: l_upfront_tax_prog_sts := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
116: END IF;
117:

Line 128: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

124: x_msg_data => x_msg_data,
125: p_khr_status => 'PASSED',
126: p_chr_id => p_chr_id);
127:
128: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
131: RAISE OKL_API.G_EXCEPTION_ERROR;
132: END IF;

Line 129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

125: p_khr_status => 'PASSED',
126: p_chr_id => p_chr_id);
127:
128: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
131: RAISE OKL_API.G_EXCEPTION_ERROR;
132: END IF;
133:

Line 130: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

126: p_chr_id => p_chr_id);
127:
128: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
131: RAISE OKL_API.G_EXCEPTION_ERROR;
132: END IF;
133:
134: --call to cascade status on to lines

Line 131: RAISE OKL_API.G_EXCEPTION_ERROR;

127:
128: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
131: RAISE OKL_API.G_EXCEPTION_ERROR;
132: END IF;
133:
134: --call to cascade status on to lines
135: OKL_CONTRACT_STATUS_PUB.cascade_lease_status

Line 143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

139: x_msg_count => x_msg_count,
140: x_msg_data => x_msg_data,
141: p_chr_id => p_chr_id);
142:
143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_ERROR;
147: END IF;

Line 144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

140: x_msg_data => x_msg_data,
141: p_chr_id => p_chr_id);
142:
143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_ERROR;
147: END IF;
148:

Line 145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

141: p_chr_id => p_chr_id);
142:
143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_ERROR;
147: END IF;
148:
149: -- Update status of Validate Contract process to Complete

Line 146: RAISE OKL_API.G_EXCEPTION_ERROR;

142:
143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_ERROR;
147: END IF;
148:
149: -- Update status of Validate Contract process to Complete
150: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(

Line 160: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

156: p_khr_id => p_chr_id ,
157: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_VALIDATE_CONTRACT ,
158: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
159:
160: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
163: RAISE OKL_API.G_EXCEPTION_ERROR;
164: END IF;

Line 161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

157: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_VALIDATE_CONTRACT ,
158: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
159:
160: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
163: RAISE OKL_API.G_EXCEPTION_ERROR;
164: END IF;
165:

Line 162: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

158: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
159:
160: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
163: RAISE OKL_API.G_EXCEPTION_ERROR;
164: END IF;
165:
166: -- Update status of Calculate Upfront Tax process to Complete or Error

Line 163: RAISE OKL_API.G_EXCEPTION_ERROR;

159:
160: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
163: RAISE OKL_API.G_EXCEPTION_ERROR;
164: END IF;
165:
166: -- Update status of Calculate Upfront Tax process to Complete or Error
167: -- based on the results of OKL_LA_SALES_TAX_PVT.validate_upfront_tax_fee

Line 178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

174: p_khr_id => p_chr_id ,
175: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_CALC_UPFRONT_TAX ,
176: p_progress_status => l_upfront_tax_prog_sts);
177:
178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
181: RAISE OKL_API.G_EXCEPTION_ERROR;
182: END IF;

Line 179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

175: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_CALC_UPFRONT_TAX ,
176: p_progress_status => l_upfront_tax_prog_sts);
177:
178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
181: RAISE OKL_API.G_EXCEPTION_ERROR;
182: END IF;
183:

Line 180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

176: p_progress_status => l_upfront_tax_prog_sts);
177:
178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
181: RAISE OKL_API.G_EXCEPTION_ERROR;
182: END IF;
183:
184: EXCEPTION

Line 181: RAISE OKL_API.G_EXCEPTION_ERROR;

177:
178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
181: RAISE OKL_API.G_EXCEPTION_ERROR;
182: END IF;
183:
184: EXCEPTION
185: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 185: WHEN OKL_API.G_EXCEPTION_ERROR THEN

181: RAISE OKL_API.G_EXCEPTION_ERROR;
182: END IF;
183:
184: EXCEPTION
185: WHEN OKL_API.G_EXCEPTION_ERROR THEN
186: x_return_status := OKL_API.G_RET_STS_ERROR;
187:
188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 186: x_return_status := OKL_API.G_RET_STS_ERROR;

182: END IF;
183:
184: EXCEPTION
185: WHEN OKL_API.G_EXCEPTION_ERROR THEN
186: x_return_status := OKL_API.G_RET_STS_ERROR;
187:
188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190:

Line 188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

184: EXCEPTION
185: WHEN OKL_API.G_EXCEPTION_ERROR THEN
186: x_return_status := OKL_API.G_RET_STS_ERROR;
187:
188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190:
191: WHEN OTHERS THEN
192: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

185: WHEN OKL_API.G_EXCEPTION_ERROR THEN
186: x_return_status := OKL_API.G_RET_STS_ERROR;
187:
188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190:
191: WHEN OTHERS THEN
192: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
193:

Line 192: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190:
191: WHEN OTHERS THEN
192: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
193:
194: END process_upfront_tax_pymt;
195:
196: --Bug# 7440232

Line 250: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

246: x_msg_data => x_msg_data,
247: p_khr_id => p_chr_id,
248: x_pdt_parameter_rec => l_pdt_params_rec);
249:
250: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
253: RAISE OKL_API.G_EXCEPTION_ERROR;
254: END IF;

Line 251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

247: p_khr_id => p_chr_id,
248: x_pdt_parameter_rec => l_pdt_params_rec);
249:
250: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
253: RAISE OKL_API.G_EXCEPTION_ERROR;
254: END IF;
255:

Line 252: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

248: x_pdt_parameter_rec => l_pdt_params_rec);
249:
250: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
253: RAISE OKL_API.G_EXCEPTION_ERROR;
254: END IF;
255:
256: IF (l_pdt_params_rec.interest_calculation_basis = 'FIXED' AND

Line 253: RAISE OKL_API.G_EXCEPTION_ERROR;

249:
250: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
253: RAISE OKL_API.G_EXCEPTION_ERROR;
254: END IF;
255:
256: IF (l_pdt_params_rec.interest_calculation_basis = 'FIXED' AND
257: l_pdt_params_rec.revenue_recognition_method = 'STREAMS') THEN

Line 283: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

279: x_msg_count => x_msg_count,
280: x_msg_data => x_msg_data,
281: p_krpdel_tbl => l_krpdel_tbl);
282:
283: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
284: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
285: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
286: RAISE OKL_API.G_EXCEPTION_ERROR;
287: END IF;

Line 284: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

280: x_msg_data => x_msg_data,
281: p_krpdel_tbl => l_krpdel_tbl);
282:
283: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
284: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
285: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
286: RAISE OKL_API.G_EXCEPTION_ERROR;
287: END IF;
288: END IF;

Line 285: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

281: p_krpdel_tbl => l_krpdel_tbl);
282:
283: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
284: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
285: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
286: RAISE OKL_API.G_EXCEPTION_ERROR;
287: END IF;
288: END IF;
289: END IF;

Line 286: RAISE OKL_API.G_EXCEPTION_ERROR;

282:
283: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
284: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
285: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
286: RAISE OKL_API.G_EXCEPTION_ERROR;
287: END IF;
288: END IF;
289: END IF;
290: END IF;

Line 293: WHEN OKL_API.G_EXCEPTION_ERROR THEN

289: END IF;
290: END IF;
291:
292: EXCEPTION
293: WHEN OKL_API.G_EXCEPTION_ERROR THEN
294: x_return_status := OKL_API.G_RET_STS_ERROR;
295:
296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
297: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 294: x_return_status := OKL_API.G_RET_STS_ERROR;

290: END IF;
291:
292: EXCEPTION
293: WHEN OKL_API.G_EXCEPTION_ERROR THEN
294: x_return_status := OKL_API.G_RET_STS_ERROR;
295:
296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
297: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
298:

Line 296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

292: EXCEPTION
293: WHEN OKL_API.G_EXCEPTION_ERROR THEN
294: x_return_status := OKL_API.G_RET_STS_ERROR;
295:
296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
297: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
298:
299: WHEN OTHERS THEN
300: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 297: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

293: WHEN OKL_API.G_EXCEPTION_ERROR THEN
294: x_return_status := OKL_API.G_RET_STS_ERROR;
295:
296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
297: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
298:
299: WHEN OTHERS THEN
300: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
301:

Line 300: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
297: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
298:
299: WHEN OTHERS THEN
300: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
301:
302: END delete_interest_rate_params;
303:
304: -- start: Sept 02, 2005 cklee: Modification for GE - 20 variable rate ER

Line 315: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

311: p_service_fee_id number,
312: p_payment_id number
313: ) RETURN VARCHAR2
314: IS
315: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
316: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
317: l_dummy number;
318: l_api_version NUMBER := 1.0;
319: x_msg_count NUMBER;

Line 316: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

312: p_payment_id number
313: ) RETURN VARCHAR2
314: IS
315: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
316: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
317: l_dummy number;
318: l_api_version NUMBER := 1.0;
319: x_msg_count NUMBER;
320: x_msg_data VARCHAR2(4000);

Line 321: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

317: l_dummy number;
318: l_api_version NUMBER := 1.0;
319: x_msg_count NUMBER;
320: x_msg_data VARCHAR2(4000);
321: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
322:
323: l_stream_type_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%type;
324:
325: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;

Line 341: p_asset_id <> OKL_API.G_MISS_NUM)

337: BEGIN
338:
339: -- check only if it's an asset line payment
340: IF (p_asset_id IS NOT NULL AND
341: p_asset_id <> OKL_API.G_MISS_NUM)
342: AND
343: (p_service_fee_id IS NULL OR
344: p_service_fee_id = OKL_API.G_MISS_NUM)
345: THEN

Line 344: p_service_fee_id = OKL_API.G_MISS_NUM)

340: IF (p_asset_id IS NOT NULL AND
341: p_asset_id <> OKL_API.G_MISS_NUM)
342: AND
343: (p_service_fee_id IS NULL OR
344: p_service_fee_id = OKL_API.G_MISS_NUM)
345: THEN
346:
347: -- get stream type purpose code
348: open c_stream_type_purpose(p_payment_id);

Line 362: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

358: x_msg_data => x_msg_data,
359: p_khr_id => p_chr_id,
360: x_pdt_parameter_rec => l_pdt_params_rec);
361:
362: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
365: RAISE OKL_API.G_EXCEPTION_ERROR;
366: END IF;

Line 363: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

359: p_khr_id => p_chr_id,
360: x_pdt_parameter_rec => l_pdt_params_rec);
361:
362: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
365: RAISE OKL_API.G_EXCEPTION_ERROR;
366: END IF;
367:

Line 364: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

360: x_pdt_parameter_rec => l_pdt_params_rec);
361:
362: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
365: RAISE OKL_API.G_EXCEPTION_ERROR;
366: END IF;
367:
368: l_book_class := l_pdt_params_rec.deal_type;

Line 365: RAISE OKL_API.G_EXCEPTION_ERROR;

361:
362: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
365: RAISE OKL_API.G_EXCEPTION_ERROR;
366: END IF;
367:
368: l_book_class := l_pdt_params_rec.deal_type;
369: l_interest_calc_basis := l_pdt_params_rec.interest_calculation_basis;

Line 379: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

375: IF l_book_class IN ('LEASEOP', 'LEASEDF', 'LEASEST') AND
376: l_interest_calc_basis IN ('FIXED','FLOAT_FACTORS', 'REAMORT') AND
377: l_stream_type_purpose NOT IN ('RENT', 'ESTIMATED_PROPERTY_TAX', 'DOWN_PAYMENT') THEN
378:
379: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
380: ,p_msg_name => G_OKL_LLA_VAR_RATE_PAYMENT1);
381:
382: RAISE G_EXCEPTION_HALT_VALIDATION;
383: END IF;

Line 395: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

391: IF l_book_class = 'LOAN' AND
392: l_interest_calc_basis IN ('FIXED','FLOAT', 'CATCHUP/CLEANUP', 'REAMORT') AND
393: l_stream_type_purpose NOT IN ('RENT', 'ESTIMATED_PROPERTY_TAX', 'DOWN_PAYMENT', 'PRINCIPAL_PAYMENT', 'UNSCHEDULED_PRINCIPAL_PAYMENT','UNSCHEDULED_LOAN_PAYMENT') THEN
394:
395: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
396: ,p_msg_name => G_OKL_LLA_VAR_RATE_PAYMENT2);
397:
398: RAISE G_EXCEPTION_HALT_VALIDATION;
399: END IF;

Line 409: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

405: IF l_book_class = 'LOAN-REVOLVING' AND
406: l_interest_calc_basis IN ('FLOAT') AND
407: l_stream_type_purpose IS NOT NULL THEN
408:
409: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
410: ,p_msg_name => G_OKL_LLA_VAR_RATE_PAYMENT3);
411:
412: RAISE G_EXCEPTION_HALT_VALIDATION;
413: END IF;

Line 425: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

421: l_stream_type_purpose IN ('PRINCIPAL_PAYMENT') THEN
422:
423: IF NOT (NVL(okl_streams_util.get_pricing_engine(p_chr_id), 'INTERNAL') = 'EXTERNAL') THEN
424:
425: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
426: ,p_msg_name => G_OKL_LLA_VAR_RATE_PAYMENT4);
427:
428: RAISE G_EXCEPTION_HALT_VALIDATION;
429: END IF;

Line 439: l_return_status := OKL_API.G_RET_STS_ERROR;

435: RETURN l_return_status;
436:
437: EXCEPTION
438: WHEN G_EXCEPTION_HALT_VALIDATION THEN
439: l_return_status := OKL_API.G_RET_STS_ERROR;
440: RETURN l_return_status;
441: WHEN OTHERS THEN
442: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
443: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 442: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

438: WHEN G_EXCEPTION_HALT_VALIDATION THEN
439: l_return_status := OKL_API.G_RET_STS_ERROR;
440: RETURN l_return_status;
441: WHEN OTHERS THEN
442: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
443: OKL_API.Set_Message(p_app_name => G_APP_NAME,
444: p_msg_name => G_UNEXPECTED_ERROR,
445: p_token1 => G_SQLCODE_TOKEN,
446: p_token1_value => SQLCODE,

Line 443: OKL_API.Set_Message(p_app_name => G_APP_NAME,

439: l_return_status := OKL_API.G_RET_STS_ERROR;
440: RETURN l_return_status;
441: WHEN OTHERS THEN
442: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
443: OKL_API.Set_Message(p_app_name => G_APP_NAME,
444: p_msg_name => G_UNEXPECTED_ERROR,
445: p_token1 => G_SQLCODE_TOKEN,
446: p_token1_value => SQLCODE,
447: p_token2 => G_SQLERRM_TOKEN,

Line 464: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

460: p_service_fee_id number,
461: p_payment_id number
462: ) RETURN VARCHAR2
463: IS
464: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
465: l_dummy number;
466:
467: l_downpayment_sty_found boolean := false;
468:

Line 490: p_asset_id <> OKL_API.G_MISS_NUM)

486: FOR this_r IN c_is_donwpayment_sty(p_payment_id) LOOP
487:
488: -- check only if it's an asset line payment
489: IF (p_asset_id IS NOT NULL AND
490: p_asset_id <> OKL_API.G_MISS_NUM)
491: AND
492: (p_service_fee_id IS NULL OR
493: p_service_fee_id = OKL_API.G_MISS_NUM)
494: THEN

Line 493: p_service_fee_id = OKL_API.G_MISS_NUM)

489: IF (p_asset_id IS NOT NULL AND
490: p_asset_id <> OKL_API.G_MISS_NUM)
491: AND
492: (p_service_fee_id IS NULL OR
493: p_service_fee_id = OKL_API.G_MISS_NUM)
494: THEN
495:
496: IF (this_r.STREAM_TYPE_PURPOSE = 'DOWN_PAYMENT') THEN
497:

Line 502: OKL_API.Set_Message(p_app_name => G_APP_NAME,

498: FOR this_row IN c_is_capitalize(p_asset_id) LOOP
499:
500: IF NOT(this_row.CAPITALIZE_DOWN_PAYMENT_YN = 'N' AND
501: this_row.DOWN_PAYMENT_RECEIVER_CODE = 'LESSOR') THEN
502: OKL_API.Set_Message(p_app_name => G_APP_NAME,
503: p_msg_name => 'OKL_LA_CAPITALIZE_DOWNPAYMENT');
504:
505: RAISE G_EXCEPTION_HALT_VALIDATION;
506: END IF;

Line 515: OKL_API.Set_Message(p_app_name => G_APP_NAME,

511: ELSE -- downpayemnt only allow for asset line payment
512:
513: IF (this_r.STREAM_TYPE_PURPOSE = 'DOWN_PAYMENT') THEN
514:
515: OKL_API.Set_Message(p_app_name => G_APP_NAME,
516: p_msg_name => 'OKL_LA_DOWNPAYMENT_STY_CODE');
517: RAISE G_EXCEPTION_HALT_VALIDATION;
518: END IF;
519:

Line 528: l_return_status := OKL_API.G_RET_STS_ERROR;

524: RETURN l_return_status;
525:
526: EXCEPTION
527: WHEN G_EXCEPTION_HALT_VALIDATION THEN
528: l_return_status := OKL_API.G_RET_STS_ERROR;
529: RETURN l_return_status;
530: WHEN OTHERS THEN
531: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
532: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 531: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

527: WHEN G_EXCEPTION_HALT_VALIDATION THEN
528: l_return_status := OKL_API.G_RET_STS_ERROR;
529: RETURN l_return_status;
530: WHEN OTHERS THEN
531: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
532: OKL_API.Set_Message(p_app_name => G_APP_NAME,
533: p_msg_name => G_UNEXPECTED_ERROR,
534: p_token1 => G_SQLCODE_TOKEN,
535: p_token1_value => SQLCODE,

Line 532: OKL_API.Set_Message(p_app_name => G_APP_NAME,

528: l_return_status := OKL_API.G_RET_STS_ERROR;
529: RETURN l_return_status;
530: WHEN OTHERS THEN
531: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
532: OKL_API.Set_Message(p_app_name => G_APP_NAME,
533: p_msg_name => G_UNEXPECTED_ERROR,
534: p_token1 => G_SQLCODE_TOKEN,
535: p_token1_value => SQLCODE,
536: p_token2 => G_SQLERRM_TOKEN,

Line 819: -- if(l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then

815: ID = P_ID;
816:
817: BEGIN
818:
819: -- if(l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then
820: if(l_rgp_id is not null) then
821: open RGP_CSR(l_rgp_id);
822: fetch RGP_CSR into l_chr_id, l_cle_id;
823: close RGP_CSR;

Line 955: if(p_stub_days is not null and p_stub_days <> OKL_API.G_MISS_CHAR) then -- end date for stub entry.

951: RETURN VARCHAR2 IS
952: l_end_date date;
953: l_end_date_disp varchar2(40);
954: BEGIN
955: if(p_stub_days is not null and p_stub_days <> OKL_API.G_MISS_CHAR) then -- end date for stub entry.
956: l_end_date := FND_DATE.canonical_to_date(p_start_date) + to_number(p_stub_days);
957: l_end_date := l_end_date - 1;
958: l_end_date_disp := OKL_LLA_UTIL_PVT.get_display_date(nvl(FND_DATE.date_to_canonical(l_end_date),''));
959: else -- end date for level entry.

Line 1109: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1105:
1106: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
1107: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
1108:
1109: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1110: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE_DETAILS';
1111: l_api_version CONSTANT NUMBER := 1.0;
1112:
1113: -- cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938

Line 1130: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1126: --end bkatraga
1127:
1128: begin
1129:
1130: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1131: -- call START_ACTIVITY to create savepoint, check compatibility
1132: -- and initialize message list
1133: x_return_status := OKL_API.START_ACTIVITY(
1134: p_api_name => l_api_name,

Line 1133: x_return_status := OKL_API.START_ACTIVITY(

1129:
1130: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1131: -- call START_ACTIVITY to create savepoint, check compatibility
1132: -- and initialize message list
1133: x_return_status := OKL_API.START_ACTIVITY(
1134: p_api_name => l_api_name,
1135: p_pkg_name => G_PKG_NAME,
1136: p_init_msg_list => p_init_msg_list,
1137: l_api_version => l_api_version,

Line 1143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1139: p_api_type => G_API_TYPE,
1140: x_return_status => x_return_status);
1141:
1142: -- check if activity started successfully
1143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1146: raise OKL_API.G_EXCEPTION_ERROR;
1147: END IF;

Line 1144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1140: x_return_status => x_return_status);
1141:
1142: -- check if activity started successfully
1143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1146: raise OKL_API.G_EXCEPTION_ERROR;
1147: END IF;
1148: l_end_date := get_start_date(p_rgp_id => p_rgp_id);

Line 1145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

1141:
1142: -- check if activity started successfully
1143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1146: raise OKL_API.G_EXCEPTION_ERROR;
1147: END IF;
1148: l_end_date := get_start_date(p_rgp_id => p_rgp_id);
1149:

Line 1146: raise OKL_API.G_EXCEPTION_ERROR;

1142: -- check if activity started successfully
1143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1146: raise OKL_API.G_EXCEPTION_ERROR;
1147: END IF;
1148: l_end_date := get_start_date(p_rgp_id => p_rgp_id);
1149:
1150: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938

Line 1173: rule_rec.rule_information7 <> OKL_API.G_MISS_CHAR ) then

1169:
1170: FOR rule_rec in sll_instances(P_RGP_ID, P_CHR_ID, P_SLH_ID) loop
1171:
1172: if( rule_rec.rule_information7 is not null and -- stub days
1173: rule_rec.rule_information7 <> OKL_API.G_MISS_CHAR ) then
1174: l_start_date := l_end_date + 1;
1175: l_end_date := l_start_date + to_number(rule_rec.rule_information7);
1176: l_end_date := l_end_date - 1;
1177: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(l_start_date);

Line 1193: x_return_status := OKL_API.g_ret_sts_error;

1189: IF p_validate_date_yn = 'Y' THEN
1190: -- Check whether stubs end date exceeds contract/line end date.
1191: l_line_end_date := get_line_end_date(p_rgp_id);
1192: if ( trunc(l_end_date) > trunc(l_line_end_date) ) then
1193: x_return_status := OKL_API.g_ret_sts_error;
1194: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1195: , p_msg_name => 'OKL_PAYMENT_DT_EXCEEDS_LINE_DT');
1196: raise OKL_API.G_EXCEPTION_ERROR;
1197: end if;

Line 1194: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1190: -- Check whether stubs end date exceeds contract/line end date.
1191: l_line_end_date := get_line_end_date(p_rgp_id);
1192: if ( trunc(l_end_date) > trunc(l_line_end_date) ) then
1193: x_return_status := OKL_API.g_ret_sts_error;
1194: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1195: , p_msg_name => 'OKL_PAYMENT_DT_EXCEEDS_LINE_DT');
1196: raise OKL_API.G_EXCEPTION_ERROR;
1197: end if;
1198: END IF;

Line 1196: raise OKL_API.G_EXCEPTION_ERROR;

1192: if ( trunc(l_end_date) > trunc(l_line_end_date) ) then
1193: x_return_status := OKL_API.g_ret_sts_error;
1194: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1195: , p_msg_name => 'OKL_PAYMENT_DT_EXCEEDS_LINE_DT');
1196: raise OKL_API.G_EXCEPTION_ERROR;
1197: end if;
1198: END IF;
1199: -- nikshah Bug 7828786 - End
1200:

Line 1202: rule_rec.rule_information3 <> OKL_API.G_MISS_CHAR ) then

1198: END IF;
1199: -- nikshah Bug 7828786 - End
1200:
1201: elsif(rule_rec.rule_information3 is not null and -- periods
1202: rule_rec.rule_information3 <> OKL_API.G_MISS_CHAR ) then
1203: l_start_date := l_end_date + 1;
1204: --l_end_date := get_end_date(l_start_date, rule_rec.OBJECT1_ID1, rule_rec.RULE_INFORMATION3);
1205: l_end_date := get_end_date(l_start_date, rule_rec.OBJECT1_ID1, rule_rec.RULE_INFORMATION3,l_start_day, l_contract_end_date);--Bug#5441811
1206: l_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(l_start_date);

Line 1217: x_return_status := OKL_API.g_ret_sts_error;

1213: -- gboomina Bug 6152538 - Start
1214: -- Check whether payments end date exceeds contract/line end date.
1215: l_line_end_date := get_line_end_date(p_rgp_id);
1216: if ( trunc(l_end_date) > trunc(l_line_end_date) ) then
1217: x_return_status := OKL_API.g_ret_sts_error;
1218: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1219: , p_msg_name => 'OKL_PAYMENT_DT_EXCEEDS_LINE_DT');
1220: raise OKL_API.G_EXCEPTION_ERROR;
1221: end if;

Line 1218: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1214: -- Check whether payments end date exceeds contract/line end date.
1215: l_line_end_date := get_line_end_date(p_rgp_id);
1216: if ( trunc(l_end_date) > trunc(l_line_end_date) ) then
1217: x_return_status := OKL_API.g_ret_sts_error;
1218: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1219: , p_msg_name => 'OKL_PAYMENT_DT_EXCEEDS_LINE_DT');
1220: raise OKL_API.G_EXCEPTION_ERROR;
1221: end if;
1222: -- gboomina Bug 6152538 - End

Line 1220: raise OKL_API.G_EXCEPTION_ERROR;

1216: if ( trunc(l_end_date) > trunc(l_line_end_date) ) then
1217: x_return_status := OKL_API.g_ret_sts_error;
1218: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1219: , p_msg_name => 'OKL_PAYMENT_DT_EXCEEDS_LINE_DT');
1220: raise OKL_API.G_EXCEPTION_ERROR;
1221: end if;
1222: -- gboomina Bug 6152538 - End
1223: END IF;
1224: -- Bug# 6438785

Line 1228: if (frequency is not null and frequency <> OKL_API.G_MISS_CHAR) then

1224: -- Bug# 6438785
1225: end if;
1226:
1227: --Added else by bkatraga for bug 13478101
1228: if (frequency is not null and frequency <> OKL_API.G_MISS_CHAR) then
1229: l_rulv_rec.jtot_object1_code := 'OKL_TUOM';
1230: l_rulv_rec.object1_id1 := frequency;
1231: else
1232: l_frequency := rule_rec.object1_id1;

Line 1235: if (arrears is not null and arrears <> OKL_API.G_MISS_CHAR) then

1231: else
1232: l_frequency := rule_rec.object1_id1;
1233: end if;
1234:
1235: if (arrears is not null and arrears <> OKL_API.G_MISS_CHAR) then
1236: l_rulv_rec.rule_information10 := arrears;
1237: --Bug# 9966316: Update arrears to NULL when value is NULL
1238: elsif (arrears is null) then
1239: l_rulv_rec.rule_information10 := arrears;

Line 1243: if (structure is not null and structure <> OKL_API.G_MISS_CHAR) then

1239: l_rulv_rec.rule_information10 := arrears;
1240: end if;
1241:
1242: --Added else by bkatraga for bug 13478101
1243: if (structure is not null and structure <> OKL_API.G_MISS_CHAR) then
1244: l_rulv_rec.rule_information5 := structure;
1245: else
1246: l_structure := rule_rec.rule_information5;
1247: end if;

Line 1261: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1257: p_rulv_rec => l_rulv_rec,
1258: x_rulv_rec => lx_rulv_rec);
1259:
1260:
1261: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1263: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;

Line 1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1258: x_rulv_rec => lx_rulv_rec);
1259:
1260:
1261: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1263: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;
1266:

Line 1263: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1259:
1260:
1261: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1263: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;
1266:
1267:

Line 1264: RAISE OKL_API.G_EXCEPTION_ERROR;

1260:
1261: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1263: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;
1266:
1267:
1268: end loop;

Line 1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1308: x_msg_count => x_msg_count,
1309: x_msg_data => x_msg_data,
1310: p_rulv_rec => l_stub_rulv_rec,
1311: x_rulv_rec => lx_stub_rulv_rec);
1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;

Line 1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1309: x_msg_data => x_msg_data,
1310: p_rulv_rec => l_stub_rulv_rec,
1311: x_rulv_rec => lx_stub_rulv_rec);
1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317: END IF;

Line 1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1310: p_rulv_rec => l_stub_rulv_rec,
1311: x_rulv_rec => lx_stub_rulv_rec);
1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317: END IF;
1318: --end bkatraga

Line 1315: RAISE OKL_API.G_EXCEPTION_ERROR;

1311: x_rulv_rec => lx_stub_rulv_rec);
1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317: END IF;
1318: --end bkatraga
1319:

Line 1321: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1317: END IF;
1318: --end bkatraga
1319:
1320: --Call End Activity
1321: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1322: x_msg_data => x_msg_data);
1323:
1324:
1325: EXCEPTION

Line 1326: when OKL_API.G_EXCEPTION_ERROR then

1322: x_msg_data => x_msg_data);
1323:
1324:
1325: EXCEPTION
1326: when OKL_API.G_EXCEPTION_ERROR then
1327: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
1328: if(sll_instances%ISOPEN) then
1329: close sll_instances;
1330: end if;

Line 1335: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1331: IF(l_okl_sll_count_csr%ISOPEN) THEN
1332: CLOSE l_okl_sll_count_csr;
1333: END IF;
1334: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
1335: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1336: p_api_name => l_api_name,
1337: p_pkg_name => G_PKG_NAME,
1338: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1339: x_msg_count => x_msg_count,

Line 1338: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1334: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
1335: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1336: p_api_name => l_api_name,
1337: p_pkg_name => G_PKG_NAME,
1338: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1339: x_msg_count => x_msg_count,
1340: x_msg_data => x_msg_data,
1341: p_api_type => G_API_TYPE);
1342:

Line 1343: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1339: x_msg_count => x_msg_count,
1340: x_msg_data => x_msg_data,
1341: p_api_type => G_API_TYPE);
1342:
1343: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1344: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
1345: if(sll_instances%ISOPEN) then
1346: close sll_instances;
1347: end if;

Line 1352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1348: IF(l_okl_sll_count_csr%ISOPEN) THEN
1349: CLOSE l_okl_sll_count_csr;
1350: END IF;
1351: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
1352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1353: p_api_name => l_api_name,
1354: p_pkg_name => G_PKG_NAME,
1355: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1356: x_msg_count => x_msg_count,

Line 1355: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1351: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
1352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1353: p_api_name => l_api_name,
1354: p_pkg_name => G_PKG_NAME,
1355: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1356: x_msg_count => x_msg_count,
1357: x_msg_data => x_msg_data,
1358: p_api_type => G_API_TYPE);
1359:

Line 1369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1365: IF(l_okl_sll_count_csr%ISOPEN) THEN
1366: CLOSE l_okl_sll_count_csr;
1367: END IF;
1368: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
1369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1370: p_api_name => l_api_name,
1371: p_pkg_name => G_PKG_NAME,
1372: p_exc_name => 'OTHERS',
1373: x_msg_count => x_msg_count,

Line 1386: if(p_num is null or p_num = OKL_API.G_MISS_CHAR ) then

1382: p_num IN VARCHAR2)
1383: RETURN boolean IS
1384: l_num number;
1385: BEGIN
1386: if(p_num is null or p_num = OKL_API.G_MISS_CHAR ) then
1387: return false;
1388: else
1389: l_num := to_number(p_num);
1390: return true;

Line 1411: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1407: p_type IN VARCHAR2
1408: ) IS
1409:
1410:
1411: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1412: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PAYMENTS';
1413: l_api_version CONSTANT NUMBER := 1.0;
1414:
1415: i NUMBER := 0;

Line 1431: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1427: l_message VARCHAR2(1000);
1428:
1429: begin
1430:
1431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1432: -- call START_ACTIVITY to create savepoint, check compatibility
1433: -- and initialize message list
1434: x_return_status := OKL_API.START_ACTIVITY(
1435: p_api_name => l_api_name,

Line 1434: x_return_status := OKL_API.START_ACTIVITY(

1430:
1431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1432: -- call START_ACTIVITY to create savepoint, check compatibility
1433: -- and initialize message list
1434: x_return_status := OKL_API.START_ACTIVITY(
1435: p_api_name => l_api_name,
1436: p_pkg_name => G_PKG_NAME,
1437: p_init_msg_list => p_init_msg_list,
1438: l_api_version => l_api_version,

Line 1444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1440: p_api_type => G_API_TYPE,
1441: x_return_status => x_return_status);
1442:
1443: -- check if activity started successfully
1444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1445: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1447: raise OKL_API.G_EXCEPTION_ERROR;
1448: END IF;

Line 1445: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1441: x_return_status => x_return_status);
1442:
1443: -- check if activity started successfully
1444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1445: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1447: raise OKL_API.G_EXCEPTION_ERROR;
1448: END IF;
1449:

Line 1446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

1442:
1443: -- check if activity started successfully
1444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1445: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1447: raise OKL_API.G_EXCEPTION_ERROR;
1448: END IF;
1449:
1450: if( p_rulv_rec.rule_information7 is not null and

Line 1447: raise OKL_API.G_EXCEPTION_ERROR;

1443: -- check if activity started successfully
1444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1445: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1446: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1447: raise OKL_API.G_EXCEPTION_ERROR;
1448: END IF;
1449:
1450: if( p_rulv_rec.rule_information7 is not null and
1451: p_rulv_rec.rule_information7 <> OKL_API.G_MISS_CHAR) then

Line 1451: p_rulv_rec.rule_information7 <> OKL_API.G_MISS_CHAR) then

1447: raise OKL_API.G_EXCEPTION_ERROR;
1448: END IF;
1449:
1450: if( p_rulv_rec.rule_information7 is not null and
1451: p_rulv_rec.rule_information7 <> OKL_API.G_MISS_CHAR) then
1452: l_days := true;
1453:
1454: end if;
1455: if( p_rulv_rec.rule_information8 is not null and

Line 1456: p_rulv_rec.rule_information8 <> OKL_API.G_MISS_CHAR) then

1452: l_days := true;
1453:
1454: end if;
1455: if( p_rulv_rec.rule_information8 is not null and
1456: p_rulv_rec.rule_information8 <> OKL_API.G_MISS_CHAR) then
1457: l_days_amt := true;
1458: end if;
1459: if( p_rulv_rec.rule_information3 is not null and
1460: p_rulv_rec.rule_information3 <> OKL_API.G_MISS_CHAR) then

Line 1460: p_rulv_rec.rule_information3 <> OKL_API.G_MISS_CHAR) then

1456: p_rulv_rec.rule_information8 <> OKL_API.G_MISS_CHAR) then
1457: l_days_amt := true;
1458: end if;
1459: if( p_rulv_rec.rule_information3 is not null and
1460: p_rulv_rec.rule_information3 <> OKL_API.G_MISS_CHAR) then
1461: l_period := true;
1462: end if;
1463: if( p_rulv_rec.rule_information6 is not null and
1464: p_rulv_rec.rule_information6 <> OKL_API.G_MISS_CHAR) then

Line 1464: p_rulv_rec.rule_information6 <> OKL_API.G_MISS_CHAR) then

1460: p_rulv_rec.rule_information3 <> OKL_API.G_MISS_CHAR) then
1461: l_period := true;
1462: end if;
1463: if( p_rulv_rec.rule_information6 is not null and
1464: p_rulv_rec.rule_information6 <> OKL_API.G_MISS_CHAR) then
1465: l_period_amt := true;
1466: end if;
1467: -- Start fix for bug 7111749
1468: -- Set l_structure TRUE if non-level

Line 1470: p_rulv_rec.rule_information5 <> OKL_API.G_MISS_CHAR) and

1466: end if;
1467: -- Start fix for bug 7111749
1468: -- Set l_structure TRUE if non-level
1469: if( p_rulv_rec.rule_information5 is not null and
1470: p_rulv_rec.rule_information5 <> OKL_API.G_MISS_CHAR) and
1471: (TRUNC(NVL(p_rulv_rec.rule_information5, '-1')) <> '0') then
1472: l_structure := true;
1473: end if;
1474: -- End fix for bug 7111749

Line 1478: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1474: -- End fix for bug 7111749
1475:
1476: if(p_payment_type = 'VIR_PAYMENT') then
1477: if(l_period and is_num(p_rulv_rec.rule_information3) and to_number(p_rulv_rec.rule_information3) > 0 ) then
1478: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1479: x_msg_data => x_msg_data);
1480: return;
1481: else
1482: x_return_status := OKL_API.g_ret_sts_error;

Line 1482: x_return_status := OKL_API.g_ret_sts_error;

1478: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1479: x_msg_data => x_msg_data);
1480: return;
1481: else
1482: x_return_status := OKL_API.g_ret_sts_error;
1483: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1484: , p_msg_name => l_message);
1485: raise OKL_API.G_EXCEPTION_ERROR;
1486: end if;

Line 1483: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1479: x_msg_data => x_msg_data);
1480: return;
1481: else
1482: x_return_status := OKL_API.g_ret_sts_error;
1483: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1484: , p_msg_name => l_message);
1485: raise OKL_API.G_EXCEPTION_ERROR;
1486: end if;
1487: end if;

Line 1485: raise OKL_API.G_EXCEPTION_ERROR;

1481: else
1482: x_return_status := OKL_API.g_ret_sts_error;
1483: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1484: , p_msg_name => l_message);
1485: raise OKL_API.G_EXCEPTION_ERROR;
1486: end if;
1487: end if;
1488:
1489: if((l_days and l_period) or (l_days_amt and l_period_amt)) then

Line 1527: x_return_status := OKL_API.g_ret_sts_error;

1523: end if;
1524: end if;
1525: -- End fix for bug 7111749
1526: if(l_message is not null) then
1527: x_return_status := OKL_API.g_ret_sts_error;
1528: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1529: , p_msg_name => l_message);
1530: raise OKL_API.G_EXCEPTION_ERROR;
1531: end if;

Line 1528: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1524: end if;
1525: -- End fix for bug 7111749
1526: if(l_message is not null) then
1527: x_return_status := OKL_API.g_ret_sts_error;
1528: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1529: , p_msg_name => l_message);
1530: raise OKL_API.G_EXCEPTION_ERROR;
1531: end if;
1532:

Line 1530: raise OKL_API.G_EXCEPTION_ERROR;

1526: if(l_message is not null) then
1527: x_return_status := OKL_API.g_ret_sts_error;
1528: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1529: , p_msg_name => l_message);
1530: raise OKL_API.G_EXCEPTION_ERROR;
1531: end if;
1532:
1533:
1534: if( p_fee_line_type is null or

Line 1536: p_fee_line_type = OKL_API.G_MISS_CHAR ) then

1532:
1533:
1534: if( p_fee_line_type is null or
1535: p_fee_line_type = '' or
1536: p_fee_line_type = OKL_API.G_MISS_CHAR ) then
1537:
1538: --x_rulv_rec := l_rulv_rec;
1539:
1540: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1540: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1536: p_fee_line_type = OKL_API.G_MISS_CHAR ) then
1537:
1538: --x_rulv_rec := l_rulv_rec;
1539:
1540: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1541: x_msg_data => x_msg_data);
1542: return;
1543: end if;
1544:

Line 1551: x_return_status := OKL_API.g_ret_sts_error;

1547:
1548: l_payment_code := get_payment_type(l_rulv_rec.object2_id1);
1549: if( l_payment_code <> 'SECURITY_DEPOSIT') then -- cklee: 11/01/04, 12-03-2004
1550:
1551: x_return_status := OKL_API.g_ret_sts_error;
1552: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
1553: p_region_code => G_AK_REGION_NAME,
1554: p_attribute_code => 'OKL_LA_PYMTS_TYPE');
1555: OKL_API.SET_MESSAGE( p_app_name => g_app_name

Line 1555: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1551: x_return_status := OKL_API.g_ret_sts_error;
1552: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
1553: p_region_code => G_AK_REGION_NAME,
1554: p_attribute_code => 'OKL_LA_PYMTS_TYPE');
1555: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1556: , p_msg_name => 'OKL_LLA_PYMTS_SEC_PYMT'
1557: , p_token1 => 'COL_NAME'
1558: , p_token1_value => l_ak_prompt
1559: );

Line 1561: raise OKL_API.G_EXCEPTION_ERROR;

1557: , p_token1 => 'COL_NAME'
1558: , p_token1_value => l_ak_prompt
1559: );
1560:
1561: raise OKL_API.G_EXCEPTION_ERROR;
1562:
1563: end if;
1564:
1565: end if;

Line 1571: x_return_status := OKL_API.g_ret_sts_error;

1567:
1568: if(p_fee_line_type is not null and p_fee_line_type = 'SECDEPOSIT') then
1569: l_lty_code := get_lty_code(l_rulv_rec.rgp_id);
1570: if(l_lty_code is not null and l_lty_code = 'LINK_FEE_ASSET') then
1571: x_return_status := OKL_API.g_ret_sts_error;
1572: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1573: , p_msg_name => 'OKL_LLA_PYMTS_FEE_NO_ASSET');
1574: raise OKL_API.G_EXCEPTION_ERROR;
1575: end if;

Line 1572: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1568: if(p_fee_line_type is not null and p_fee_line_type = 'SECDEPOSIT') then
1569: l_lty_code := get_lty_code(l_rulv_rec.rgp_id);
1570: if(l_lty_code is not null and l_lty_code = 'LINK_FEE_ASSET') then
1571: x_return_status := OKL_API.g_ret_sts_error;
1572: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1573: , p_msg_name => 'OKL_LLA_PYMTS_FEE_NO_ASSET');
1574: raise OKL_API.G_EXCEPTION_ERROR;
1575: end if;
1576: end if;

Line 1574: raise OKL_API.G_EXCEPTION_ERROR;

1570: if(l_lty_code is not null and l_lty_code = 'LINK_FEE_ASSET') then
1571: x_return_status := OKL_API.g_ret_sts_error;
1572: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1573: , p_msg_name => 'OKL_LLA_PYMTS_FEE_NO_ASSET');
1574: raise OKL_API.G_EXCEPTION_ERROR;
1575: end if;
1576: end if;
1577:
1578: --Call End Activity

Line 1579: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1575: end if;
1576: end if;
1577:
1578: --Call End Activity
1579: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1580: x_msg_data => x_msg_data);
1581:
1582:
1583: EXCEPTION

Line 1584: when OKL_API.G_EXCEPTION_ERROR then

1580: x_msg_data => x_msg_data);
1581:
1582:
1583: EXCEPTION
1584: when OKL_API.G_EXCEPTION_ERROR then
1585: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1586: p_api_name => l_api_name,
1587: p_pkg_name => G_PKG_NAME,
1588: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1585: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1581:
1582:
1583: EXCEPTION
1584: when OKL_API.G_EXCEPTION_ERROR then
1585: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1586: p_api_name => l_api_name,
1587: p_pkg_name => G_PKG_NAME,
1588: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1589: x_msg_count => x_msg_count,

Line 1588: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1584: when OKL_API.G_EXCEPTION_ERROR then
1585: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1586: p_api_name => l_api_name,
1587: p_pkg_name => G_PKG_NAME,
1588: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1589: x_msg_count => x_msg_count,
1590: x_msg_data => x_msg_data,
1591: p_api_type => G_API_TYPE);
1592:

Line 1593: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1589: x_msg_count => x_msg_count,
1590: x_msg_data => x_msg_data,
1591: p_api_type => G_API_TYPE);
1592:
1593: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1594: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1595: p_api_name => l_api_name,
1596: p_pkg_name => G_PKG_NAME,
1597: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1594: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1590: x_msg_data => x_msg_data,
1591: p_api_type => G_API_TYPE);
1592:
1593: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1594: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1595: p_api_name => l_api_name,
1596: p_pkg_name => G_PKG_NAME,
1597: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1598: x_msg_count => x_msg_count,

Line 1597: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1593: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1594: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1595: p_api_name => l_api_name,
1596: p_pkg_name => G_PKG_NAME,
1597: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1598: x_msg_count => x_msg_count,
1599: x_msg_data => x_msg_data,
1600: p_api_type => G_API_TYPE);
1601:

Line 1603: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1599: x_msg_data => x_msg_data,
1600: p_api_type => G_API_TYPE);
1601:
1602: when OTHERS then
1603: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1604: p_api_name => l_api_name,
1605: p_pkg_name => G_PKG_NAME,
1606: p_exc_name => 'OTHERS',
1607: x_msg_count => x_msg_count,

Line 1703: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1699: sty.name
1700: FROM OKL_STRM_TYPE_V sty
1701: WHERE sty.ID = p_sty_id;
1702: BEGIN
1703: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1704: -- call START_ACTIVITY to create savepoint, check compatibility
1705: -- and initialize message list
1706: x_return_status := OKL_API.START_ACTIVITY(
1707: p_api_name => l_api_name,

Line 1706: x_return_status := OKL_API.START_ACTIVITY(

1702: BEGIN
1703: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1704: -- call START_ACTIVITY to create savepoint, check compatibility
1705: -- and initialize message list
1706: x_return_status := OKL_API.START_ACTIVITY(
1707: p_api_name => l_api_name,
1708: p_pkg_name => G_PKG_NAME,
1709: p_init_msg_list => p_init_msg_list,
1710: l_api_version => l_api_version,

Line 1716: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1712: p_api_type => G_API_TYPE,
1713: x_return_status => x_return_status);
1714:
1715: -- check if activity started successfully
1716: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1717: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1718: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1719: raise OKL_API.G_EXCEPTION_ERROR;
1720: END IF;

Line 1717: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1713: x_return_status => x_return_status);
1714:
1715: -- check if activity started successfully
1716: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1717: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1718: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1719: raise OKL_API.G_EXCEPTION_ERROR;
1720: END IF;
1721:

Line 1718: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

1714:
1715: -- check if activity started successfully
1716: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1717: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1718: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1719: raise OKL_API.G_EXCEPTION_ERROR;
1720: END IF;
1721:
1722: --Added l_stream_type_name by bkatraga for bug 14111538

Line 1719: raise OKL_API.G_EXCEPTION_ERROR;

1715: -- check if activity started successfully
1716: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1717: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1718: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1719: raise OKL_API.G_EXCEPTION_ERROR;
1720: END IF;
1721:
1722: --Added l_stream_type_name by bkatraga for bug 14111538
1723: -- get stream type purpose code

Line 1732: Okl_Api.set_message(

1728: IF(l_stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE') THEN
1729: IF(p_pym_hdr_rec.arrears = 'N') THEN
1730: --Modified by bkatraga for bug 14111538 to change the message code and token
1731: --Also added raise statement
1732: Okl_Api.set_message(
1733: p_app_name => G_APP_NAME,
1734: p_msg_name => 'OKL_ADVANCE_PMNT_NOT_ALLOWED',
1735: p_token1 => 'STRM_TYPE',
1736: p_token1_value => l_stream_type_name);

Line 1737: RAISE OKL_API.G_EXCEPTION_ERROR;

1733: p_app_name => G_APP_NAME,
1734: p_msg_name => 'OKL_ADVANCE_PMNT_NOT_ALLOWED',
1735: p_token1 => 'STRM_TYPE',
1736: p_token1_value => l_stream_type_name);
1737: RAISE OKL_API.G_EXCEPTION_ERROR;
1738: END IF;
1739: --Added by bkatraga for bug 14111538
1740: IF(p_pym_tbl.count > 0) THEN
1741: i := p_pym_tbl.FIRST;

Line 1744: IF((p_pym_tbl(i).STUB_AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).STUB_AMOUNT <> 0) OR

1740: IF(p_pym_tbl.count > 0) THEN
1741: i := p_pym_tbl.FIRST;
1742: LOOP
1743: IF(p_pym_tbl(i).update_type <> 'DELETE') THEN
1744: IF((p_pym_tbl(i).STUB_AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).STUB_AMOUNT <> 0) OR
1745: (p_pym_tbl(i).AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).AMOUNT <> 0)) THEN
1746: Okl_Api.set_message(
1747: p_app_name => G_APP_NAME,
1748: p_msg_name => 'OKL_VAR_INT_AMOUNT_ZERO');

Line 1745: (p_pym_tbl(i).AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).AMOUNT <> 0)) THEN

1741: i := p_pym_tbl.FIRST;
1742: LOOP
1743: IF(p_pym_tbl(i).update_type <> 'DELETE') THEN
1744: IF((p_pym_tbl(i).STUB_AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).STUB_AMOUNT <> 0) OR
1745: (p_pym_tbl(i).AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).AMOUNT <> 0)) THEN
1746: Okl_Api.set_message(
1747: p_app_name => G_APP_NAME,
1748: p_msg_name => 'OKL_VAR_INT_AMOUNT_ZERO');
1749: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1746: Okl_Api.set_message(

1742: LOOP
1743: IF(p_pym_tbl(i).update_type <> 'DELETE') THEN
1744: IF((p_pym_tbl(i).STUB_AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).STUB_AMOUNT <> 0) OR
1745: (p_pym_tbl(i).AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).AMOUNT <> 0)) THEN
1746: Okl_Api.set_message(
1747: p_app_name => G_APP_NAME,
1748: p_msg_name => 'OKL_VAR_INT_AMOUNT_ZERO');
1749: RAISE OKL_API.G_EXCEPTION_ERROR;
1750: END IF;

Line 1749: RAISE OKL_API.G_EXCEPTION_ERROR;

1745: (p_pym_tbl(i).AMOUNT <> OKL_API.G_MISS_CHAR AND p_pym_tbl(i).AMOUNT <> 0)) THEN
1746: Okl_Api.set_message(
1747: p_app_name => G_APP_NAME,
1748: p_msg_name => 'OKL_VAR_INT_AMOUNT_ZERO');
1749: RAISE OKL_API.G_EXCEPTION_ERROR;
1750: END IF;
1751: END IF;
1752: EXIT WHEN (i >= p_pym_tbl.LAST);
1753: i:= p_pym_tbl.NEXT(i);

Line 1759: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1755: END IF;
1756: --end bkatraga
1757: END IF;
1758:
1759: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1760: x_msg_data => x_msg_data);
1761: EXCEPTION
1762: when OKL_API.G_EXCEPTION_ERROR then
1763: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1762: when OKL_API.G_EXCEPTION_ERROR then

1758:
1759: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1760: x_msg_data => x_msg_data);
1761: EXCEPTION
1762: when OKL_API.G_EXCEPTION_ERROR then
1763: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1764: p_api_name => l_api_name,
1765: p_pkg_name => G_PKG_NAME,
1766: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1763: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1759: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1760: x_msg_data => x_msg_data);
1761: EXCEPTION
1762: when OKL_API.G_EXCEPTION_ERROR then
1763: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1764: p_api_name => l_api_name,
1765: p_pkg_name => G_PKG_NAME,
1766: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1767: x_msg_count => x_msg_count,

Line 1766: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1762: when OKL_API.G_EXCEPTION_ERROR then
1763: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1764: p_api_name => l_api_name,
1765: p_pkg_name => G_PKG_NAME,
1766: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1767: x_msg_count => x_msg_count,
1768: x_msg_data => x_msg_data,
1769: p_api_type => G_API_TYPE);
1770:

Line 1771: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1767: x_msg_count => x_msg_count,
1768: x_msg_data => x_msg_data,
1769: p_api_type => G_API_TYPE);
1770:
1771: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1772: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1773: p_api_name => l_api_name,
1774: p_pkg_name => G_PKG_NAME,
1775: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1772: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1768: x_msg_data => x_msg_data,
1769: p_api_type => G_API_TYPE);
1770:
1771: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1772: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1773: p_api_name => l_api_name,
1774: p_pkg_name => G_PKG_NAME,
1775: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1776: x_msg_count => x_msg_count,

Line 1775: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1771: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1772: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1773: p_api_name => l_api_name,
1774: p_pkg_name => G_PKG_NAME,
1775: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1776: x_msg_count => x_msg_count,
1777: x_msg_data => x_msg_data,
1778: p_api_type => G_API_TYPE);
1779:

Line 1781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1777: x_msg_data => x_msg_data,
1778: p_api_type => G_API_TYPE);
1779:
1780: when OTHERS then
1781: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1782: p_api_name => l_api_name,
1783: p_pkg_name => G_PKG_NAME,
1784: p_exc_name => 'OTHERS',
1785: x_msg_count => x_msg_count,

Line 1809: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and

1805: valid boolean := true;
1806:
1807: Begin
1808:
1809: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and
1810: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and
1811: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and
1812: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then
1813: valid := false;

Line 1810: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and

1806:
1807: Begin
1808:
1809: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and
1810: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and
1811: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and
1812: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then
1813: valid := false;
1814: end if;

Line 1811: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and

1807: Begin
1808:
1809: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and
1810: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and
1811: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and
1812: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then
1813: valid := false;
1814: end if;
1815:

Line 1812: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then

1808:
1809: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and
1810: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and
1811: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and
1812: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then
1813: valid := false;
1814: end if;
1815:
1816: if(not valid) then

Line 1859: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and

1855: FUNCTION check_rec(p_pym_rec IN pym_rec_type)
1856: RETURN boolean IS
1857:
1858: BEGIN
1859: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and
1860: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and
1861: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and
1862: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then
1863: return true;

Line 1860: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and

1856: RETURN boolean IS
1857:
1858: BEGIN
1859: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and
1860: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and
1861: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and
1862: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then
1863: return true;
1864: else

Line 1861: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and

1857:
1858: BEGIN
1859: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and
1860: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and
1861: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and
1862: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then
1863: return true;
1864: else
1865: return false;

Line 1862: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then

1858: BEGIN
1859: if((p_pym_rec.stub_days is null or p_pym_rec.stub_days = OKL_API.G_MISS_CHAR) and
1860: (p_pym_rec.stub_amount is null or p_pym_rec.stub_amount = OKL_API.G_MISS_CHAR) and
1861: (p_pym_rec.period is null or p_pym_rec.period = OKL_API.G_MISS_CHAR) and
1862: (p_pym_rec.amount is null or p_pym_rec.amount = OKL_API.G_MISS_CHAR)) then
1863: return true;
1864: else
1865: return false;
1866: end if;

Line 1877: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

1873: x_return_status OUT NOCOPY VARCHAR2,
1874: x_msg_count OUT NOCOPY NUMBER,
1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1877: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1878: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1880: x_pym_level OUT NOCOPY VARCHAR2,
1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,

Line 1878: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

1874: x_msg_count OUT NOCOPY NUMBER,
1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1877: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1878: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1880: x_pym_level OUT NOCOPY VARCHAR2,
1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1882: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,

Line 1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1882: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,
1883: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS
1884:
1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1886: l_api_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT';
1887: l_api_version CONSTANT NUMBER := 1.0;
1888:
1889: l_pym_level VARCHAR2(30) := 'HEADER';

Line 1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

1886: l_api_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT';
1887: l_api_version CONSTANT NUMBER := 1.0;
1888:
1889: l_pym_level VARCHAR2(30) := 'HEADER';
1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1894:

Line 1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

1887: l_api_version CONSTANT NUMBER := 1.0;
1888:
1889: l_pym_level VARCHAR2(30) := 'HEADER';
1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1894:
1895: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

1888:
1889: l_pym_level VARCHAR2(30) := 'HEADER';
1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1894:
1895: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1896:

Line 1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

1889: l_pym_level VARCHAR2(30) := 'HEADER';
1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1894:
1895: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1896:
1897: ------------- temp

Line 1937: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1933: -- SLH.OBJECT1_ID1 = TO_CHAR(P_PAYMENT_ID);
1934:
1935: begin
1936:
1937: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1938: -- call START_ACTIVITY to create savepoint, check compatibility
1939: -- and initialize message list
1940: x_return_status := OKL_API.START_ACTIVITY(
1941: p_api_name => l_api_name,

Line 1940: x_return_status := OKL_API.START_ACTIVITY(

1936:
1937: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1938: -- call START_ACTIVITY to create savepoint, check compatibility
1939: -- and initialize message list
1940: x_return_status := OKL_API.START_ACTIVITY(
1941: p_api_name => l_api_name,
1942: p_pkg_name => G_PKG_NAME,
1943: p_init_msg_list => p_init_msg_list,
1944: l_api_version => l_api_version,

Line 1950: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1946: p_api_type => G_API_TYPE,
1947: x_return_status => x_return_status);
1948:
1949: -- check if activity started successfully
1950: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1951: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1952: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1953: raise OKL_API.G_EXCEPTION_ERROR;
1954: END IF;

Line 1951: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1947: x_return_status => x_return_status);
1948:
1949: -- check if activity started successfully
1950: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1951: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1952: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1953: raise OKL_API.G_EXCEPTION_ERROR;
1954: END IF;
1955:

Line 1952: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

1948:
1949: -- check if activity started successfully
1950: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1951: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1952: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1953: raise OKL_API.G_EXCEPTION_ERROR;
1954: END IF;
1955:
1956: /* -- temp

Line 1953: raise OKL_API.G_EXCEPTION_ERROR;

1949: -- check if activity started successfully
1950: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1951: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1952: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1953: raise OKL_API.G_EXCEPTION_ERROR;
1954: END IF;
1955:
1956: /* -- temp
1957: open get_dir;

Line 1968: if( p_payment_id is null or p_payment_id = OKL_API.G_MISS_NUM) then

1964: --fnd_file.put_names(l_log, l_out, l_temp_dir);
1965: -- temp
1966:
1967:
1968: if( p_payment_id is null or p_payment_id = OKL_API.G_MISS_NUM) then
1969: x_return_status := OKL_API.g_ret_sts_error;
1970: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1971: , p_msg_name => 'OKL_LLA_PMT_SELECT');
1972: raise OKL_API.G_EXCEPTION_ERROR;

Line 1969: x_return_status := OKL_API.g_ret_sts_error;

1965: -- temp
1966:
1967:
1968: if( p_payment_id is null or p_payment_id = OKL_API.G_MISS_NUM) then
1969: x_return_status := OKL_API.g_ret_sts_error;
1970: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1971: , p_msg_name => 'OKL_LLA_PMT_SELECT');
1972: raise OKL_API.G_EXCEPTION_ERROR;
1973: end if;

Line 1970: OKL_API.SET_MESSAGE( p_app_name => g_app_name

1966:
1967:
1968: if( p_payment_id is null or p_payment_id = OKL_API.G_MISS_NUM) then
1969: x_return_status := OKL_API.g_ret_sts_error;
1970: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1971: , p_msg_name => 'OKL_LLA_PMT_SELECT');
1972: raise OKL_API.G_EXCEPTION_ERROR;
1973: end if;
1974:

Line 1972: raise OKL_API.G_EXCEPTION_ERROR;

1968: if( p_payment_id is null or p_payment_id = OKL_API.G_MISS_NUM) then
1969: x_return_status := OKL_API.g_ret_sts_error;
1970: OKL_API.SET_MESSAGE( p_app_name => g_app_name
1971: , p_msg_name => 'OKL_LLA_PMT_SELECT');
1972: raise OKL_API.G_EXCEPTION_ERROR;
1973: end if;
1974:
1975:
1976: if( p_asset_id is not null and p_asset_id <> OKL_API.G_MISS_NUM) then

Line 1976: if( p_asset_id is not null and p_asset_id <> OKL_API.G_MISS_NUM) then

1972: raise OKL_API.G_EXCEPTION_ERROR;
1973: end if;
1974:
1975:
1976: if( p_asset_id is not null and p_asset_id <> OKL_API.G_MISS_NUM) then
1977: l_pym_level := 'ASSET';
1978: l_cle_id := p_asset_id;
1979: end if;
1980: if(p_service_fee_id is not null and p_service_fee_id <> OKL_API.G_MISS_NUM) then

Line 1980: if(p_service_fee_id is not null and p_service_fee_id <> OKL_API.G_MISS_NUM) then

1976: if( p_asset_id is not null and p_asset_id <> OKL_API.G_MISS_NUM) then
1977: l_pym_level := 'ASSET';
1978: l_cle_id := p_asset_id;
1979: end if;
1980: if(p_service_fee_id is not null and p_service_fee_id <> OKL_API.G_MISS_NUM) then
1981: if(l_pym_level = 'ASSET') then
1982: l_pym_level := 'SUBLINE';
1983: else
1984: l_pym_level := 'SERVICE_FEE';

Line 2005: if(l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then

2001: fetch RGP_CLE_CSR into l_rgp_id;
2002: close RGP_CLE_CSR;
2003: end if;
2004:
2005: if(l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then
2006: open SLH_CSR(l_rgp_id, p_payment_id);
2007: fetch SLH_CSR into l_slh_id;
2008: close SLH_CSR;
2009:

Line 2020: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2016: x_cle_id := l_cle_id;
2017:
2018:
2019: --Call End Activity
2020: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2021: x_msg_data => x_msg_data);
2022:
2023: EXCEPTION
2024: when OKL_API.G_EXCEPTION_ERROR then

Line 2024: when OKL_API.G_EXCEPTION_ERROR then

2020: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2021: x_msg_data => x_msg_data);
2022:
2023: EXCEPTION
2024: when OKL_API.G_EXCEPTION_ERROR then
2025: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2026: p_api_name => l_api_name,
2027: p_pkg_name => G_PKG_NAME,
2028: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2025: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2021: x_msg_data => x_msg_data);
2022:
2023: EXCEPTION
2024: when OKL_API.G_EXCEPTION_ERROR then
2025: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2026: p_api_name => l_api_name,
2027: p_pkg_name => G_PKG_NAME,
2028: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2029: x_msg_count => x_msg_count,

Line 2028: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2024: when OKL_API.G_EXCEPTION_ERROR then
2025: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2026: p_api_name => l_api_name,
2027: p_pkg_name => G_PKG_NAME,
2028: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2029: x_msg_count => x_msg_count,
2030: x_msg_data => x_msg_data,
2031: p_api_type => G_API_TYPE);
2032:

Line 2033: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2029: x_msg_count => x_msg_count,
2030: x_msg_data => x_msg_data,
2031: p_api_type => G_API_TYPE);
2032:
2033: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2034: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2035: p_api_name => l_api_name,
2036: p_pkg_name => G_PKG_NAME,
2037: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2034: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2030: x_msg_data => x_msg_data,
2031: p_api_type => G_API_TYPE);
2032:
2033: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2034: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2035: p_api_name => l_api_name,
2036: p_pkg_name => G_PKG_NAME,
2037: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2038: x_msg_count => x_msg_count,

Line 2037: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2033: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2034: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2035: p_api_name => l_api_name,
2036: p_pkg_name => G_PKG_NAME,
2037: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2038: x_msg_count => x_msg_count,
2039: x_msg_data => x_msg_data,
2040: p_api_type => G_API_TYPE);
2041:

Line 2043: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2039: x_msg_data => x_msg_data,
2040: p_api_type => G_API_TYPE);
2041:
2042: when OTHERS then
2043: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2044: p_api_name => l_api_name,
2045: p_pkg_name => G_PKG_NAME,
2046: p_exc_name => 'OTHERS',
2047: x_msg_count => x_msg_count,

Line 2086: --l_ret_value := OKL_API.G_FALSE;

2082: --l_ret_value VARCHAR2(1);
2083:
2084: BEGIN
2085:
2086: --l_ret_value := OKL_API.G_FALSE;
2087:
2088: OPEN inv_dtls_csr(p_chr_id => p_chr_id);
2089: FETCH inv_dtls_csr INTO l_inv_dtls;
2090: CLOSE inv_dtls_csr;

Line 2120: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

2116: x_return_status OUT NOCOPY VARCHAR2,
2117: x_msg_count OUT NOCOPY NUMBER,
2118: x_msg_data OUT NOCOPY VARCHAR2,
2119: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
2120: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2121: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2122: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2123: p_pym_hdr_rec IN pym_hdr_rec_type,
2124: p_pym_tbl IN pym_tbl_type,

Line 2121: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

2117: x_msg_count OUT NOCOPY NUMBER,
2118: x_msg_data OUT NOCOPY VARCHAR2,
2119: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
2120: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2121: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2122: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2123: p_pym_hdr_rec IN pym_hdr_rec_type,
2124: p_pym_tbl IN pym_tbl_type,
2125: p_update_type IN VARCHAR2,

Line 2128: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2124: p_pym_tbl IN pym_tbl_type,
2125: p_update_type IN VARCHAR2,
2126: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
2127:
2128: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2129: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PAYMENT';
2130: l_api_version CONSTANT NUMBER := 1.0;
2131: l_totalpayment NUMBER :=0 ;
2132: i NUMBER := 0;

Line 2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

2153: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
2154: lx_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
2155:
2156: l_pym_level VARCHAR2(30) := 'HEADER';
2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;

Line 2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

2154: lx_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
2155:
2156: l_pym_level VARCHAR2(30) := 'HEADER';
2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
2162:

Line 2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

2155:
2156: l_pym_level VARCHAR2(30) := 'HEADER';
2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
2162:
2163: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;

Line 2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

2156: l_pym_level VARCHAR2(30) := 'HEADER';
2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
2162:
2163: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;
2164: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;

Line 2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;

2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
2162:
2163: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;
2164: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
2165: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 2258: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2254: begin
2255:
2256:
2257:
2258: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2259: -- call START_ACTIVITY to create savepoint, check compatibility
2260: -- and initialize message list
2261: x_return_status := OKL_API.START_ACTIVITY(
2262: p_api_name => l_api_name,

Line 2261: x_return_status := OKL_API.START_ACTIVITY(

2257:
2258: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2259: -- call START_ACTIVITY to create savepoint, check compatibility
2260: -- and initialize message list
2261: x_return_status := OKL_API.START_ACTIVITY(
2262: p_api_name => l_api_name,
2263: p_pkg_name => G_PKG_NAME,
2264: p_init_msg_list => p_init_msg_list,
2265: l_api_version => l_api_version,

Line 2271: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2267: p_api_type => G_API_TYPE,
2268: x_return_status => x_return_status);
2269:
2270: -- check if activity started successfully
2271: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2272: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2274: raise OKL_API.G_EXCEPTION_ERROR;
2275: END IF;

Line 2272: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2268: x_return_status => x_return_status);
2269:
2270: -- check if activity started successfully
2271: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2272: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2274: raise OKL_API.G_EXCEPTION_ERROR;
2275: END IF;
2276:

Line 2273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2269:
2270: -- check if activity started successfully
2271: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2272: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2274: raise OKL_API.G_EXCEPTION_ERROR;
2275: END IF;
2276:
2277: /* -- temp

Line 2274: raise OKL_API.G_EXCEPTION_ERROR;

2270: -- check if activity started successfully
2271: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2272: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2274: raise OKL_API.G_EXCEPTION_ERROR;
2275: END IF;
2276:
2277: /* -- temp
2278: open get_dir;

Line 2291: x_return_status := OKL_API.g_ret_sts_error;

2287:
2288: -- R12B Authoring OA Migration
2289: -- Check if the Payment is for an Upfront Tax Fee line
2290: /* IF(not is_investor_fee_payment(p_chr_id =>p_chr_id, p_cle_id => p_service_fee_id , p_rgp_id => l_rulv_rec.rgp_id )) then
2291: x_return_status := OKL_API.g_ret_sts_error;
2292: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2293: , p_msg_name => 'OKL_LA_INV_PAY_MISMATCH');
2294: raise OKL_API.G_EXCEPTION_ERROR;
2295: end if;

Line 2292: OKL_API.SET_MESSAGE( p_app_name => g_app_name

2288: -- R12B Authoring OA Migration
2289: -- Check if the Payment is for an Upfront Tax Fee line
2290: /* IF(not is_investor_fee_payment(p_chr_id =>p_chr_id, p_cle_id => p_service_fee_id , p_rgp_id => l_rulv_rec.rgp_id )) then
2291: x_return_status := OKL_API.g_ret_sts_error;
2292: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2293: , p_msg_name => 'OKL_LA_INV_PAY_MISMATCH');
2294: raise OKL_API.G_EXCEPTION_ERROR;
2295: end if;
2296: */

Line 2294: raise OKL_API.G_EXCEPTION_ERROR;

2290: /* IF(not is_investor_fee_payment(p_chr_id =>p_chr_id, p_cle_id => p_service_fee_id , p_rgp_id => l_rulv_rec.rgp_id )) then
2291: x_return_status := OKL_API.g_ret_sts_error;
2292: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2293: , p_msg_name => 'OKL_LA_INV_PAY_MISMATCH');
2294: raise OKL_API.G_EXCEPTION_ERROR;
2295: end if;
2296: */
2297: l_upfront_tax_pymt_yn := OKL_API.G_FALSE;
2298: IF (p_service_fee_id IS NOT NULL) THEN

Line 2297: l_upfront_tax_pymt_yn := OKL_API.G_FALSE;

2293: , p_msg_name => 'OKL_LA_INV_PAY_MISMATCH');
2294: raise OKL_API.G_EXCEPTION_ERROR;
2295: end if;
2296: */
2297: l_upfront_tax_pymt_yn := OKL_API.G_FALSE;
2298: IF (p_service_fee_id IS NOT NULL) THEN
2299: l_upfront_tax_pymt_yn := is_upfront_tax_fee_payment(p_chr_id => p_chr_id,
2300: p_cle_id => p_service_fee_id);
2301:

Line 2302: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN

2298: IF (p_service_fee_id IS NOT NULL) THEN
2299: l_upfront_tax_pymt_yn := is_upfront_tax_fee_payment(p_chr_id => p_chr_id,
2300: p_cle_id => p_service_fee_id);
2301:
2302: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN
2303: OPEN l_contract_csr(p_chr_id => p_chr_id);
2304: FETCH l_contract_csr INTO l_contract_rec;
2305: CLOSE l_contract_csr;
2306:

Line 2316: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2312: (p_asset_id => p_asset_id,
2313: p_service_fee_id => p_service_fee_id,
2314: p_payment_id => p_payment_id);
2315: --- Store the highest degree of error
2316: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2317: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2319: raise OKL_API.G_EXCEPTION_ERROR;
2320: END IF;

Line 2317: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2313: p_service_fee_id => p_service_fee_id,
2314: p_payment_id => p_payment_id);
2315: --- Store the highest degree of error
2316: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2317: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2319: raise OKL_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: -- END: June 24, 2005 cklee: Modification for okl.h Sales Quote enhancement

Line 2318: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2314: p_payment_id => p_payment_id);
2315: --- Store the highest degree of error
2316: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2317: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2319: raise OKL_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: -- END: June 24, 2005 cklee: Modification for okl.h Sales Quote enhancement
2322:

Line 2319: raise OKL_API.G_EXCEPTION_ERROR;

2315: --- Store the highest degree of error
2316: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2317: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2319: raise OKL_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: -- END: June 24, 2005 cklee: Modification for okl.h Sales Quote enhancement
2322:
2323: -- START: Setp 02, 2005 cklee: Variable rate ER for GE - 20

Line 2330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2326: p_asset_id => p_asset_id,
2327: p_service_fee_id => p_service_fee_id,
2328: p_payment_id => p_payment_id);
2329: --- Store the highest degree of error
2330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2331: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2333: raise OKL_API.G_EXCEPTION_ERROR;
2334: END IF;

Line 2331: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2327: p_service_fee_id => p_service_fee_id,
2328: p_payment_id => p_payment_id);
2329: --- Store the highest degree of error
2330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2331: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2333: raise OKL_API.G_EXCEPTION_ERROR;
2334: END IF;
2335: -- END: Setp 02, 2005 cklee: Variable rate ER for GE - 20

Line 2332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2328: p_payment_id => p_payment_id);
2329: --- Store the highest degree of error
2330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2331: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2333: raise OKL_API.G_EXCEPTION_ERROR;
2334: END IF;
2335: -- END: Setp 02, 2005 cklee: Variable rate ER for GE - 20
2336:

Line 2333: raise OKL_API.G_EXCEPTION_ERROR;

2329: --- Store the highest degree of error
2330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2331: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2333: raise OKL_API.G_EXCEPTION_ERROR;
2334: END IF;
2335: -- END: Setp 02, 2005 cklee: Variable rate ER for GE - 20
2336:
2337: --Added parameter p_pym_tbl by bkatraga for bug 14111538

Line 2349: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2345: p_payment_id => p_payment_id,
2346: p_pym_hdr_rec => p_pym_hdr_rec,
2347: p_pym_tbl => p_pym_tbl);
2348:
2349: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2350: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2352: raise OKL_API.G_EXCEPTION_ERROR;
2353: END IF;

Line 2350: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2346: p_pym_hdr_rec => p_pym_hdr_rec,
2347: p_pym_tbl => p_pym_tbl);
2348:
2349: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2350: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2352: raise OKL_API.G_EXCEPTION_ERROR;
2353: END IF;
2354: --end bkatraga

Line 2351: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2347: p_pym_tbl => p_pym_tbl);
2348:
2349: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2350: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2352: raise OKL_API.G_EXCEPTION_ERROR;
2353: END IF;
2354: --end bkatraga
2355:

Line 2352: raise OKL_API.G_EXCEPTION_ERROR;

2348:
2349: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2350: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2352: raise OKL_API.G_EXCEPTION_ERROR;
2353: END IF;
2354: --end bkatraga
2355:
2356: get_payment(

Line 2372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2368: x_rgp_id => l_rgp_id,
2369: x_cle_id => l_cle_id);
2370:
2371:
2372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2373: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2375: raise OKL_API.G_EXCEPTION_ERROR;
2376: END IF;

Line 2373: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2369: x_cle_id => l_cle_id);
2370:
2371:
2372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2373: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2375: raise OKL_API.G_EXCEPTION_ERROR;
2376: END IF;
2377:

Line 2374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2370:
2371:
2372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2373: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2375: raise OKL_API.G_EXCEPTION_ERROR;
2376: END IF;
2377:
2378: --Bug# 4959361

Line 2375: raise OKL_API.G_EXCEPTION_ERROR;

2371:
2372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2373: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2375: raise OKL_API.G_EXCEPTION_ERROR;
2376: END IF;
2377:
2378: --Bug# 4959361
2379: IF l_cle_id IS NOT NULL THEN

Line 2388: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2384: x_msg_count => x_msg_count,
2385: x_msg_data => x_msg_data,
2386: p_cle_id => l_cle_id);
2387:
2388: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2391: RAISE OKL_API.G_EXCEPTION_ERROR;
2392: END IF;

Line 2389: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2385: x_msg_data => x_msg_data,
2386: p_cle_id => l_cle_id);
2387:
2388: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2391: RAISE OKL_API.G_EXCEPTION_ERROR;
2392: END IF;
2393: END IF;

Line 2390: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2386: p_cle_id => l_cle_id);
2387:
2388: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2391: RAISE OKL_API.G_EXCEPTION_ERROR;
2392: END IF;
2393: END IF;
2394: --Bug# 4959361

Line 2391: RAISE OKL_API.G_EXCEPTION_ERROR;

2387:
2388: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2391: RAISE OKL_API.G_EXCEPTION_ERROR;
2392: END IF;
2393: END IF;
2394: --Bug# 4959361
2395:

Line 2396: if(l_rgp_id is null or l_rgp_id = OKL_API.G_MISS_NUM) then

2392: END IF;
2393: END IF;
2394: --Bug# 4959361
2395:
2396: if(l_rgp_id is null or l_rgp_id = OKL_API.G_MISS_NUM) then
2397: if(l_pym_level = 'HEADER') then
2398: l_rgpv_rec.chr_id := p_chr_id;
2399: l_rgpv_rec.dnz_chr_id := p_chr_id;
2400: l_rgpv_rec.cle_id := null;

Line 2425: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2421:
2422:
2423: l_rgp_id := lx_rgpv_rec.id;
2424:
2425: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2426: RAISE OKL_API.G_EXCEPTION_ERROR;
2427: END IF;
2428: end if;
2429:

Line 2426: RAISE OKL_API.G_EXCEPTION_ERROR;

2422:
2423: l_rgp_id := lx_rgpv_rec.id;
2424:
2425: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2426: RAISE OKL_API.G_EXCEPTION_ERROR;
2427: END IF;
2428: end if;
2429:
2430:

Line 2431: IF(l_slh_id is null or l_slh_id = OKL_API.G_MISS_NUM) then

2427: END IF;
2428: end if;
2429:
2430:
2431: IF(l_slh_id is null or l_slh_id = OKL_API.G_MISS_NUM) then
2432: l_rulv_rec := l_rulv_rec2;
2433: -- l_rulv_rec.object_version_number := l_rgr_rec.object_version_number;
2434: l_rulv_rec.dnz_chr_id := p_chr_id;
2435: l_rulv_rec.rgp_id := l_rgp_id;

Line 2453: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2449: x_msg_data => x_msg_data,
2450: p_rulv_rec => l_rulv_rec,
2451: x_rulv_rec => lx_rulv_rec);
2452:
2453: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2454: RAISE OKL_API.G_EXCEPTION_ERROR;
2455: END IF;
2456: l_slh_id := lx_rulv_rec.id;
2457: end if;

Line 2454: RAISE OKL_API.G_EXCEPTION_ERROR;

2450: p_rulv_rec => l_rulv_rec,
2451: x_rulv_rec => lx_rulv_rec);
2452:
2453: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2454: RAISE OKL_API.G_EXCEPTION_ERROR;
2455: END IF;
2456: l_slh_id := lx_rulv_rec.id;
2457: end if;
2458:

Line 2486: and p_pym_tbl(i).rule_id is not null and p_pym_tbl(i).rule_id <> OKL_API.G_MISS_NUM)) then

2482: --Added by bkatraga for bug 13478101
2483: l_update_type := p_pym_tbl(i).update_type;
2484:
2485: if(p_pym_tbl(i).update_type = 'DELETE' or (empty_rec
2486: and p_pym_tbl(i).rule_id is not null and p_pym_tbl(i).rule_id <> OKL_API.G_MISS_NUM)) then
2487: l_rulv_rec.id := p_pym_tbl(i).rule_id;
2488: l := l + 1;
2489: l_delt_rulv_tbl(l) := l_rulv_rec;
2490:

Line 2515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2511: p_payment_type => p_update_type,
2512: p_type => p_pym_tbl(i).update_type);
2513:
2514:
2515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2516: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2518: raise OKL_API.G_EXCEPTION_ERROR;
2519: END IF;

Line 2516: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2512: p_type => p_pym_tbl(i).update_type);
2513:
2514:
2515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2516: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2518: raise OKL_API.G_EXCEPTION_ERROR;
2519: END IF;
2520:

Line 2517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2513:
2514:
2515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2516: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2518: raise OKL_API.G_EXCEPTION_ERROR;
2519: END IF;
2520:
2521: if(l_rulv_rec.rule_information8 is not null and is_num(l_rulv_rec.rule_information8)) then

Line 2518: raise OKL_API.G_EXCEPTION_ERROR;

2514:
2515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2516: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2518: raise OKL_API.G_EXCEPTION_ERROR;
2519: END IF;
2520:
2521: if(l_rulv_rec.rule_information8 is not null and is_num(l_rulv_rec.rule_information8)) then
2522: l_rulv_rec.rule_information8 := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(

Line 2550: x_return_status := OKL_API.g_ret_sts_error;

2546: i:= p_pym_tbl.NEXT(i);
2547: end loop;
2548: end if;
2549: IF(not is_investor_fee_payment(p_chr_id =>p_chr_id, p_payment =>l_totalpayment , p_rgp_id => l_rgp_id )) then
2550: x_return_status := OKL_API.g_ret_sts_error;
2551: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2552: , p_msg_name => 'OKL_LA_INV_PAY_MISMATCH');
2553: raise OKL_API.G_EXCEPTION_ERROR;
2554: end if;

Line 2551: OKL_API.SET_MESSAGE( p_app_name => g_app_name

2547: end loop;
2548: end if;
2549: IF(not is_investor_fee_payment(p_chr_id =>p_chr_id, p_payment =>l_totalpayment , p_rgp_id => l_rgp_id )) then
2550: x_return_status := OKL_API.g_ret_sts_error;
2551: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2552: , p_msg_name => 'OKL_LA_INV_PAY_MISMATCH');
2553: raise OKL_API.G_EXCEPTION_ERROR;
2554: end if;
2555:

Line 2553: raise OKL_API.G_EXCEPTION_ERROR;

2549: IF(not is_investor_fee_payment(p_chr_id =>p_chr_id, p_payment =>l_totalpayment , p_rgp_id => l_rgp_id )) then
2550: x_return_status := OKL_API.g_ret_sts_error;
2551: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2552: , p_msg_name => 'OKL_LA_INV_PAY_MISMATCH');
2553: raise OKL_API.G_EXCEPTION_ERROR;
2554: end if;
2555:
2556: if (l_delt_rulv_tbl.count > 0) then
2557: OKL_RULE_PUB.delete_rule(

Line 2565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2561: x_msg_count => x_msg_count,
2562: x_msg_data => x_msg_data,
2563: p_rulv_tbl => l_delt_rulv_tbl);
2564:
2565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2566: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2568: raise OKL_API.G_EXCEPTION_ERROR;
2569: END IF;

Line 2566: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2562: x_msg_data => x_msg_data,
2563: p_rulv_tbl => l_delt_rulv_tbl);
2564:
2565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2566: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2568: raise OKL_API.G_EXCEPTION_ERROR;
2569: END IF;
2570: end if;

Line 2567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2563: p_rulv_tbl => l_delt_rulv_tbl);
2564:
2565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2566: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2568: raise OKL_API.G_EXCEPTION_ERROR;
2569: END IF;
2570: end if;
2571:

Line 2568: raise OKL_API.G_EXCEPTION_ERROR;

2564:
2565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2566: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2568: raise OKL_API.G_EXCEPTION_ERROR;
2569: END IF;
2570: end if;
2571:
2572: if (l_crea_rulv_tbl.count > 0) then

Line 2593: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2589: x_rulv_tbl => x_rulv_tbl);
2590:
2591:
2592:
2593: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2595: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2596: RAISE OKL_API.G_EXCEPTION_ERROR;
2597: END IF;

Line 2594: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2590:
2591:
2592:
2593: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2595: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2596: RAISE OKL_API.G_EXCEPTION_ERROR;
2597: END IF;
2598: end if;

Line 2595: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2591:
2592:
2593: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2595: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2596: RAISE OKL_API.G_EXCEPTION_ERROR;
2597: END IF;
2598: end if;
2599:

Line 2596: RAISE OKL_API.G_EXCEPTION_ERROR;

2592:
2593: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2595: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2596: RAISE OKL_API.G_EXCEPTION_ERROR;
2597: END IF;
2598: end if;
2599:
2600: if (l_updt_rulv_tbl.count > 0) then

Line 2605: p_asset_id <> OKL_API.G_MISS_NUM)

2601:
2602: -- added for bug 5115701 - start
2603: -- check only if it's an asset sub line payment
2604: IF (p_asset_id IS NOT NULL AND
2605: p_asset_id <> OKL_API.G_MISS_NUM)
2606: AND
2607: (p_service_fee_id IS NOT NULL AND
2608: p_service_fee_id <> OKL_API.G_MISS_NUM)
2609: THEN

Line 2608: p_service_fee_id <> OKL_API.G_MISS_NUM)

2604: IF (p_asset_id IS NOT NULL AND
2605: p_asset_id <> OKL_API.G_MISS_NUM)
2606: AND
2607: (p_service_fee_id IS NOT NULL AND
2608: p_service_fee_id <> OKL_API.G_MISS_NUM)
2609: THEN
2610:
2611: OPEN GET_FEE_TYPE_SUB_CSR(p_chr_id, p_service_fee_id);
2612: FETCH GET_FEE_TYPE_SUB_CSR INTO l_subline_fee_type;

Line 2618: x_return_status := OKL_API.g_ret_sts_error;

2614:
2615:
2616: IF(l_subline_fee_type IS NOT NULL AND l_subline_fee_type = 'FINANCED') then
2617:
2618: x_return_status := OKL_API.g_ret_sts_error;
2619: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2620: , p_msg_name => 'OKL_LLA_PYMTS_NO_UPDATE');
2621: raise OKL_API.G_EXCEPTION_ERROR;
2622: END IF;

Line 2619: OKL_API.SET_MESSAGE( p_app_name => g_app_name

2615:
2616: IF(l_subline_fee_type IS NOT NULL AND l_subline_fee_type = 'FINANCED') then
2617:
2618: x_return_status := OKL_API.g_ret_sts_error;
2619: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2620: , p_msg_name => 'OKL_LLA_PYMTS_NO_UPDATE');
2621: raise OKL_API.G_EXCEPTION_ERROR;
2622: END IF;
2623: END IF;

Line 2621: raise OKL_API.G_EXCEPTION_ERROR;

2617:
2618: x_return_status := OKL_API.g_ret_sts_error;
2619: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2620: , p_msg_name => 'OKL_LLA_PYMTS_NO_UPDATE');
2621: raise OKL_API.G_EXCEPTION_ERROR;
2622: END IF;
2623: END IF;
2624: -- added for bug 5115701 - End
2625:

Line 2636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2632: p_rulv_tbl => l_updt_rulv_tbl,
2633: x_rulv_tbl => x_rulv_tbl);
2634:
2635:
2636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2639: RAISE OKL_API.G_EXCEPTION_ERROR;
2640: END IF;

Line 2637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2633: x_rulv_tbl => x_rulv_tbl);
2634:
2635:
2636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2639: RAISE OKL_API.G_EXCEPTION_ERROR;
2640: END IF;
2641: end if;

Line 2638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2634:
2635:
2636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2639: RAISE OKL_API.G_EXCEPTION_ERROR;
2640: END IF;
2641: end if;
2642:

Line 2639: RAISE OKL_API.G_EXCEPTION_ERROR;

2635:
2636: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2638: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2639: RAISE OKL_API.G_EXCEPTION_ERROR;
2640: END IF;
2641: end if;
2642:
2643: if(l_pym_level <> 'HEADER') then

Line 2654: x_return_status := OKL_API.g_ret_sts_error;

2650: l_slh_id,
2651: p_chr_id);
2652: if( l_detail_count < 1 and l_invalid_line = 'N') then
2653: IF (l_deal_type NOT IN ('LOAN', 'LOAN-REVOLVING')) THEN -- Bug 4887014
2654: x_return_status := OKL_API.g_ret_sts_error;
2655: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2656: , p_msg_name => 'OKL_LLA_PYM_ONE_PERIOD');
2657: raise OKL_API.G_EXCEPTION_ERROR;
2658: END IF;

Line 2655: OKL_API.SET_MESSAGE( p_app_name => g_app_name

2651: p_chr_id);
2652: if( l_detail_count < 1 and l_invalid_line = 'N') then
2653: IF (l_deal_type NOT IN ('LOAN', 'LOAN-REVOLVING')) THEN -- Bug 4887014
2654: x_return_status := OKL_API.g_ret_sts_error;
2655: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2656: , p_msg_name => 'OKL_LLA_PYM_ONE_PERIOD');
2657: raise OKL_API.G_EXCEPTION_ERROR;
2658: END IF;
2659: end if;

Line 2657: raise OKL_API.G_EXCEPTION_ERROR;

2653: IF (l_deal_type NOT IN ('LOAN', 'LOAN-REVOLVING')) THEN -- Bug 4887014
2654: x_return_status := OKL_API.g_ret_sts_error;
2655: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2656: , p_msg_name => 'OKL_LLA_PYM_ONE_PERIOD');
2657: raise OKL_API.G_EXCEPTION_ERROR;
2658: END IF;
2659: end if;
2660: if(l_fee_line_type is not null and l_fee_line_type = 'SECDEPOSIT') then
2661: l_detail_count := verify_sec_deposit_count(l_rgp_id,

Line 2665: x_return_status := OKL_API.g_ret_sts_error;

2661: l_detail_count := verify_sec_deposit_count(l_rgp_id,
2662: l_slh_id,
2663: p_chr_id);
2664: if( l_detail_count > 1 ) then
2665: x_return_status := OKL_API.g_ret_sts_error;
2666: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2667: , p_msg_name => 'OKL_LLA_PYMTS_FEE_PERIOD');
2668: raise OKL_API.G_EXCEPTION_ERROR;
2669: end if;

Line 2666: OKL_API.SET_MESSAGE( p_app_name => g_app_name

2662: l_slh_id,
2663: p_chr_id);
2664: if( l_detail_count > 1 ) then
2665: x_return_status := OKL_API.g_ret_sts_error;
2666: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2667: , p_msg_name => 'OKL_LLA_PYMTS_FEE_PERIOD');
2668: raise OKL_API.G_EXCEPTION_ERROR;
2669: end if;
2670: end if;

Line 2668: raise OKL_API.G_EXCEPTION_ERROR;

2664: if( l_detail_count > 1 ) then
2665: x_return_status := OKL_API.g_ret_sts_error;
2666: OKL_API.SET_MESSAGE( p_app_name => g_app_name
2667: , p_msg_name => 'OKL_LLA_PYMTS_FEE_PERIOD');
2668: raise OKL_API.G_EXCEPTION_ERROR;
2669: end if;
2670: end if;
2671:
2672:

Line 2693: x_return_status := OKL_API.g_ret_sts_error;

2689: l_detail_count := get_sll_count(l_rgp_id,
2690: l_slh_id,
2691: p_chr_id);
2692: if( l_detail_count < 1 ) then
2693: x_return_status := OKL_API.g_ret_sts_error;
2694: OKL_API.SET_MESSAGE(p_app_name => g_app_name
2695: ,p_msg_name => 'OKL_LA_VAR_INT_SCHED_DEL');
2696: raise OKL_API.G_EXCEPTION_ERROR;
2697: end if;

Line 2694: OKL_API.SET_MESSAGE(p_app_name => g_app_name

2690: l_slh_id,
2691: p_chr_id);
2692: if( l_detail_count < 1 ) then
2693: x_return_status := OKL_API.g_ret_sts_error;
2694: OKL_API.SET_MESSAGE(p_app_name => g_app_name
2695: ,p_msg_name => 'OKL_LA_VAR_INT_SCHED_DEL');
2696: raise OKL_API.G_EXCEPTION_ERROR;
2697: end if;
2698:

Line 2696: raise OKL_API.G_EXCEPTION_ERROR;

2692: if( l_detail_count < 1 ) then
2693: x_return_status := OKL_API.g_ret_sts_error;
2694: OKL_API.SET_MESSAGE(p_app_name => g_app_name
2695: ,p_msg_name => 'OKL_LA_VAR_INT_SCHED_DEL');
2696: raise OKL_API.G_EXCEPTION_ERROR;
2697: end if;
2698:
2699: END IF;
2700: END IF;

Line 2719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2715: arrears => p_pym_hdr_rec.ARREARS,
2716: p_update_type => l_update_type);
2717:
2718:
2719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2722: RAISE OKL_API.G_EXCEPTION_ERROR;
2723: END IF;

Line 2720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2716: p_update_type => l_update_type);
2717:
2718:
2719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2722: RAISE OKL_API.G_EXCEPTION_ERROR;
2723: END IF;
2724:

Line 2721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2717:
2718:
2719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2722: RAISE OKL_API.G_EXCEPTION_ERROR;
2723: END IF;
2724:
2725: lx_rulv_tbl(1).id := l_slh_id;

Line 2722: RAISE OKL_API.G_EXCEPTION_ERROR;

2718:
2719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2721: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2722: RAISE OKL_API.G_EXCEPTION_ERROR;
2723: END IF;
2724:
2725: lx_rulv_tbl(1).id := l_slh_id;
2726: lx_rulv_tbl(1).rgp_id := l_rgp_id;

Line 2732: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN

2728:
2729: x_rulv_tbl := lx_rulv_tbl;
2730:
2731: -- R12B Authoring OA Migration
2732: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN
2733: IF (l_contract_rec.sts_code IN ('PASSED','COMPLETE','APPROVED','PENDING_APPROVAL')) THEN
2734:
2735: OKL_LA_PAYMENTS_PVT.process_upfront_tax_pymt(
2736: p_api_version => p_api_version,

Line 2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2739: x_msg_count => x_msg_count,
2740: x_msg_data => x_msg_data,
2741: p_chr_id => p_chr_id);
2742:
2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2746: RAISE OKL_API.G_EXCEPTION_ERROR;
2747: END IF;

Line 2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2740: x_msg_data => x_msg_data,
2741: p_chr_id => p_chr_id);
2742:
2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2746: RAISE OKL_API.G_EXCEPTION_ERROR;
2747: END IF;
2748:

Line 2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2741: p_chr_id => p_chr_id);
2742:
2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2746: RAISE OKL_API.G_EXCEPTION_ERROR;
2747: END IF;
2748:
2749: END IF;

Line 2746: RAISE OKL_API.G_EXCEPTION_ERROR;

2742:
2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2746: RAISE OKL_API.G_EXCEPTION_ERROR;
2747: END IF;
2748:
2749: END IF;
2750: END IF;

Line 2763: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2759: x_msg_count => x_msg_count,
2760: x_msg_data => x_msg_data,
2761: p_chr_id => p_chr_id);
2762:
2763: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2764: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2765: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2766: RAISE OKL_API.G_EXCEPTION_ERROR;
2767: END IF;

Line 2764: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2760: x_msg_data => x_msg_data,
2761: p_chr_id => p_chr_id);
2762:
2763: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2764: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2765: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2766: RAISE OKL_API.G_EXCEPTION_ERROR;
2767: END IF;
2768:

Line 2765: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2761: p_chr_id => p_chr_id);
2762:
2763: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2764: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2765: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2766: RAISE OKL_API.G_EXCEPTION_ERROR;
2767: END IF;
2768:
2769: --Call End Activity

Line 2766: RAISE OKL_API.G_EXCEPTION_ERROR;

2762:
2763: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2764: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2765: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2766: RAISE OKL_API.G_EXCEPTION_ERROR;
2767: END IF;
2768:
2769: --Call End Activity
2770: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 2770: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2766: RAISE OKL_API.G_EXCEPTION_ERROR;
2767: END IF;
2768:
2769: --Call End Activity
2770: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2771: x_msg_data => x_msg_data);
2772:
2773: EXCEPTION
2774: when OKL_API.G_EXCEPTION_ERROR then

Line 2774: when OKL_API.G_EXCEPTION_ERROR then

2770: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2771: x_msg_data => x_msg_data);
2772:
2773: EXCEPTION
2774: when OKL_API.G_EXCEPTION_ERROR then
2775: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2776: p_api_name => l_api_name,
2777: p_pkg_name => G_PKG_NAME,
2778: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2775: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2771: x_msg_data => x_msg_data);
2772:
2773: EXCEPTION
2774: when OKL_API.G_EXCEPTION_ERROR then
2775: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2776: p_api_name => l_api_name,
2777: p_pkg_name => G_PKG_NAME,
2778: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2779: x_msg_count => x_msg_count,

Line 2778: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2774: when OKL_API.G_EXCEPTION_ERROR then
2775: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2776: p_api_name => l_api_name,
2777: p_pkg_name => G_PKG_NAME,
2778: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2779: x_msg_count => x_msg_count,
2780: x_msg_data => x_msg_data,
2781: p_api_type => G_API_TYPE);
2782:

Line 2783: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2779: x_msg_count => x_msg_count,
2780: x_msg_data => x_msg_data,
2781: p_api_type => G_API_TYPE);
2782:
2783: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2784: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2785: p_api_name => l_api_name,
2786: p_pkg_name => G_PKG_NAME,
2787: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2784: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2780: x_msg_data => x_msg_data,
2781: p_api_type => G_API_TYPE);
2782:
2783: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2784: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2785: p_api_name => l_api_name,
2786: p_pkg_name => G_PKG_NAME,
2787: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2788: x_msg_count => x_msg_count,

Line 2787: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2783: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2784: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2785: p_api_name => l_api_name,
2786: p_pkg_name => G_PKG_NAME,
2787: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2788: x_msg_count => x_msg_count,
2789: x_msg_data => x_msg_data,
2790: p_api_type => G_API_TYPE);
2791:

Line 2793: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2789: x_msg_data => x_msg_data,
2790: p_api_type => G_API_TYPE);
2791:
2792: when OTHERS then
2793: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2794: p_api_name => l_api_name,
2795: p_pkg_name => G_PKG_NAME,
2796: p_exc_name => 'OTHERS',
2797: x_msg_count => x_msg_count,

Line 2820: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2816: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2817: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2818: -- x_rulv_tbl OKL_RULE_PUB.RULV_TBL_TYPE;
2819:
2820: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2821: l_api_name CONSTANT VARCHAR2(30) := 'VARIABLE_INTEREST_PAYMENT';
2822: l_api_version CONSTANT NUMBER := 1.0;
2823:
2824: l_payment_id NUMBER;

Line 2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

2828: l_flag VARCHAR2(1) := 'N';
2829: l_term okl_k_headers.term_duration%TYPE;
2830:
2831: l_pym_level VARCHAR2(30) := 'HEADER';
2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2833: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2834: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2835:
2836: -- x_return_status varchar2(1);

Line 2833: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

2829: l_term okl_k_headers.term_duration%TYPE;
2830:
2831: l_pym_level VARCHAR2(30) := 'HEADER';
2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2833: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2834: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2835:
2836: -- x_return_status varchar2(1);
2837: x_primary_sty_id okl_strm_type_b.ID%TYPE;

Line 2834: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

2830:
2831: l_pym_level VARCHAR2(30) := 'HEADER';
2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2833: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2834: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2835:
2836: -- x_return_status varchar2(1);
2837: x_primary_sty_id okl_strm_type_b.ID%TYPE;
2838:

Line 2889: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2885: */
2886:
2887: begin
2888:
2889: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2890: -- call START_ACTIVITY to create savepoint, check compatibility
2891: -- and initialize message list
2892: x_return_status := OKL_API.START_ACTIVITY(
2893: p_api_name => l_api_name,

Line 2892: x_return_status := OKL_API.START_ACTIVITY(

2888:
2889: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2890: -- call START_ACTIVITY to create savepoint, check compatibility
2891: -- and initialize message list
2892: x_return_status := OKL_API.START_ACTIVITY(
2893: p_api_name => l_api_name,
2894: p_pkg_name => G_PKG_NAME,
2895: p_init_msg_list => p_init_msg_list,
2896: l_api_version => p_api_version,

Line 2902: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2898: p_api_type => G_API_TYPE,
2899: x_return_status => x_return_status);
2900:
2901: -- check if activity started successfully
2902: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2903: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2904: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2905: raise OKL_API.G_EXCEPTION_ERROR;
2906: END IF;

Line 2903: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2899: x_return_status => x_return_status);
2900:
2901: -- check if activity started successfully
2902: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2903: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2904: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2905: raise OKL_API.G_EXCEPTION_ERROR;
2906: END IF;
2907:

Line 2904: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2900:
2901: -- check if activity started successfully
2902: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2903: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2904: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2905: raise OKL_API.G_EXCEPTION_ERROR;
2906: END IF;
2907:
2908:

Line 2905: raise OKL_API.G_EXCEPTION_ERROR;

2901: -- check if activity started successfully
2902: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2903: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2904: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2905: raise OKL_API.G_EXCEPTION_ERROR;
2906: END IF;
2907:
2908:
2909: --Bug 4018298

Line 2925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2921: x_return_status => l_return_status,
2922: x_primary_sty_id => l_payment_id
2923: );
2924:
2925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2926: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2928: raise OKL_API.G_EXCEPTION_ERROR;
2929: END IF;

Line 2926: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2922: x_primary_sty_id => l_payment_id
2923: );
2924:
2925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2926: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2928: raise OKL_API.G_EXCEPTION_ERROR;
2929: END IF;
2930:

Line 2927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2923: );
2924:
2925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2926: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2928: raise OKL_API.G_EXCEPTION_ERROR;
2929: END IF;
2930:
2931: /*

Line 2928: raise OKL_API.G_EXCEPTION_ERROR;

2924:
2925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2926: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2928: raise OKL_API.G_EXCEPTION_ERROR;
2929: END IF;
2930:
2931: /*
2932: OPEN PAYMENT_TYPE;

Line 2953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2949: x_rgp_id => l_rgp_id,
2950: x_cle_id => l_cle_id);
2951:
2952:
2953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2954: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2956: raise OKL_API.G_EXCEPTION_ERROR;
2957: END IF;

Line 2954: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2950: x_cle_id => l_cle_id);
2951:
2952:
2953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2954: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2956: raise OKL_API.G_EXCEPTION_ERROR;
2957: END IF;
2958:

Line 2955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2951:
2952:
2953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2954: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2956: raise OKL_API.G_EXCEPTION_ERROR;
2957: END IF;
2958:
2959: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then

Line 2956: raise OKL_API.G_EXCEPTION_ERROR;

2952:
2953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2954: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2956: raise OKL_API.G_EXCEPTION_ERROR;
2957: END IF;
2958:
2959: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then
2960: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 2959: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then

2955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2956: raise OKL_API.G_EXCEPTION_ERROR;
2957: END IF;
2958:
2959: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then
2960: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2961: x_msg_data => x_msg_data);
2962: return;
2963: end if;

Line 2960: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2956: raise OKL_API.G_EXCEPTION_ERROR;
2957: END IF;
2958:
2959: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then
2960: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2961: x_msg_data => x_msg_data);
2962: return;
2963: end if;
2964:

Line 2970: * OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2966: *FETCH VIR_PAYMENT INTO l_flag, l_term;
2967: *CLOSE VIR_PAYMENT;
2968: *
2969: *if(l_flag <> 'Y') then
2970: * OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2971: * x_msg_data => x_msg_data);
2972: * return;
2973: *end if;
2974: */

Line 3008: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3004: p_pym_tbl => l_pym_tbl,
3005: p_update_type => 'VIR_PAYMENT',
3006: x_rulv_tbl => x_rulv_tbl);
3007:
3008: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3009: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3010: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3011: raise OKL_API.G_EXCEPTION_ERROR;
3012: END IF;

Line 3009: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3005: p_update_type => 'VIR_PAYMENT',
3006: x_rulv_tbl => x_rulv_tbl);
3007:
3008: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3009: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3010: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3011: raise OKL_API.G_EXCEPTION_ERROR;
3012: END IF;
3013: END IF;

Line 3010: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3006: x_rulv_tbl => x_rulv_tbl);
3007:
3008: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3009: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3010: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3011: raise OKL_API.G_EXCEPTION_ERROR;
3012: END IF;
3013: END IF;
3014:

Line 3011: raise OKL_API.G_EXCEPTION_ERROR;

3007:
3008: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3009: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3010: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3011: raise OKL_API.G_EXCEPTION_ERROR;
3012: END IF;
3013: END IF;
3014:
3015: -- ----------------------------------------

Line 3018: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

3014:
3015: -- ----------------------------------------
3016:
3017: --Call End Activity
3018: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3019: x_msg_data => x_msg_data);
3020:
3021:
3022: EXCEPTION

Line 3023: when OKL_API.G_EXCEPTION_ERROR then

3019: x_msg_data => x_msg_data);
3020:
3021:
3022: EXCEPTION
3023: when OKL_API.G_EXCEPTION_ERROR then
3024: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3025: p_api_name => l_api_name,
3026: p_pkg_name => G_PKG_NAME,
3027: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3024: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3020:
3021:
3022: EXCEPTION
3023: when OKL_API.G_EXCEPTION_ERROR then
3024: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3025: p_api_name => l_api_name,
3026: p_pkg_name => G_PKG_NAME,
3027: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3028: x_msg_count => x_msg_count,

Line 3027: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

3023: when OKL_API.G_EXCEPTION_ERROR then
3024: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3025: p_api_name => l_api_name,
3026: p_pkg_name => G_PKG_NAME,
3027: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3028: x_msg_count => x_msg_count,
3029: x_msg_data => x_msg_data,
3030: p_api_type => G_API_TYPE);
3031:

Line 3032: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

3028: x_msg_count => x_msg_count,
3029: x_msg_data => x_msg_data,
3030: p_api_type => G_API_TYPE);
3031:
3032: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3034: p_api_name => l_api_name,
3035: p_pkg_name => G_PKG_NAME,
3036: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3029: x_msg_data => x_msg_data,
3030: p_api_type => G_API_TYPE);
3031:
3032: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3034: p_api_name => l_api_name,
3035: p_pkg_name => G_PKG_NAME,
3036: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3037: x_msg_count => x_msg_count,

Line 3036: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

3032: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3034: p_api_name => l_api_name,
3035: p_pkg_name => G_PKG_NAME,
3036: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3037: x_msg_count => x_msg_count,
3038: x_msg_data => x_msg_data,
3039: p_api_type => G_API_TYPE);
3040:

Line 3042: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3038: x_msg_data => x_msg_data,
3039: p_api_type => G_API_TYPE);
3040:
3041: when OTHERS then
3042: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3043: p_api_name => l_api_name,
3044: p_pkg_name => G_PKG_NAME,
3045: p_exc_name => 'OTHERS',
3046: x_msg_count => x_msg_count,

Line 3062: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

3058: x_return_status OUT NOCOPY VARCHAR2,
3059: x_msg_count OUT NOCOPY NUMBER,
3060: x_msg_data OUT NOCOPY VARCHAR2,
3061: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3062: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3063: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3064: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
3065: p_update_type IN VARCHAR2,
3066: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS

Line 3063: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

3059: x_msg_count OUT NOCOPY NUMBER,
3060: x_msg_data OUT NOCOPY VARCHAR2,
3061: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3062: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3063: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3064: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
3065: p_update_type IN VARCHAR2,
3066: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
3067:

Line 3068: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3064: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
3065: p_update_type IN VARCHAR2,
3066: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
3067:
3068: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3069: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PAYMENT2';
3070: l_api_version CONSTANT NUMBER := 1.0;
3071:
3072: l_pym_level VARCHAR2(30) := 'HEADER';

Line 3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

3069: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_PAYMENT2';
3070: l_api_version CONSTANT NUMBER := 1.0;
3071:
3072: l_pym_level VARCHAR2(30) := 'HEADER';
3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;

Line 3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

3070: l_api_version CONSTANT NUMBER := 1.0;
3071:
3072: l_pym_level VARCHAR2(30) := 'HEADER';
3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
3078:

Line 3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

3071:
3072: l_pym_level VARCHAR2(30) := 'HEADER';
3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
3078:
3079: lx_rulv_tbl rulv_tbl_type;

Line 3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

3072: l_pym_level VARCHAR2(30) := 'HEADER';
3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
3078:
3079: lx_rulv_tbl rulv_tbl_type;
3080:

Line 3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;

3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
3078:
3079: lx_rulv_tbl rulv_tbl_type;
3080:
3081: -- R12B Authoring OA Migration

Line 3093: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3089: l_contract_rec l_contract_csr%ROWTYPE;
3090:
3091: begin
3092:
3093: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3094: -- call START_ACTIVITY to create savepoint, check compatibility
3095: -- and initialize message list
3096: x_return_status := OKL_API.START_ACTIVITY(
3097: p_api_name => l_api_name,

Line 3096: x_return_status := OKL_API.START_ACTIVITY(

3092:
3093: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3094: -- call START_ACTIVITY to create savepoint, check compatibility
3095: -- and initialize message list
3096: x_return_status := OKL_API.START_ACTIVITY(
3097: p_api_name => l_api_name,
3098: p_pkg_name => G_PKG_NAME,
3099: p_init_msg_list => p_init_msg_list,
3100: l_api_version => p_api_version,

Line 3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3102: p_api_type => G_API_TYPE,
3103: x_return_status => x_return_status);
3104:
3105: -- check if activity started successfully
3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3109: raise OKL_API.G_EXCEPTION_ERROR;
3110: END IF;

Line 3107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3103: x_return_status => x_return_status);
3104:
3105: -- check if activity started successfully
3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3109: raise OKL_API.G_EXCEPTION_ERROR;
3110: END IF;
3111:

Line 3108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3104:
3105: -- check if activity started successfully
3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3109: raise OKL_API.G_EXCEPTION_ERROR;
3110: END IF;
3111:
3112: /* -- temp

Line 3109: raise OKL_API.G_EXCEPTION_ERROR;

3105: -- check if activity started successfully
3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3107: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3109: raise OKL_API.G_EXCEPTION_ERROR;
3110: END IF;
3111:
3112: /* -- temp
3113: open get_dir;

Line 3125: l_upfront_tax_pymt_yn := OKL_API.G_FALSE;

3121: -- temp
3122:
3123: -- R12B Authoring OA Migration
3124: -- Check if the Payment is for an Upfront Tax Fee line
3125: l_upfront_tax_pymt_yn := OKL_API.G_FALSE;
3126: IF (p_service_fee_id IS NOT NULL) THEN
3127: l_upfront_tax_pymt_yn := is_upfront_tax_fee_payment(p_chr_id => p_chr_id,
3128: p_cle_id => p_service_fee_id);
3129:

Line 3130: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN

3126: IF (p_service_fee_id IS NOT NULL) THEN
3127: l_upfront_tax_pymt_yn := is_upfront_tax_fee_payment(p_chr_id => p_chr_id,
3128: p_cle_id => p_service_fee_id);
3129:
3130: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN
3131: OPEN l_contract_csr(p_chr_id => p_chr_id);
3132: FETCH l_contract_csr INTO l_contract_rec;
3133: CLOSE l_contract_csr;
3134: END IF;

Line 3143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3139: (p_asset_id => p_asset_id,
3140: p_service_fee_id => p_service_fee_id,
3141: p_payment_id => p_payment_id);
3142: --- Store the highest degree of error
3143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3146: raise OKL_API.G_EXCEPTION_ERROR;
3147: END IF;

Line 3144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3140: p_service_fee_id => p_service_fee_id,
3141: p_payment_id => p_payment_id);
3142: --- Store the highest degree of error
3143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3146: raise OKL_API.G_EXCEPTION_ERROR;
3147: END IF;
3148: -- END: June 24, 2005 cklee: Modification for okl.h Sales Quote enhancement

Line 3145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3141: p_payment_id => p_payment_id);
3142: --- Store the highest degree of error
3143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3146: raise OKL_API.G_EXCEPTION_ERROR;
3147: END IF;
3148: -- END: June 24, 2005 cklee: Modification for okl.h Sales Quote enhancement
3149:

Line 3146: raise OKL_API.G_EXCEPTION_ERROR;

3142: --- Store the highest degree of error
3143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3144: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3146: raise OKL_API.G_EXCEPTION_ERROR;
3147: END IF;
3148: -- END: June 24, 2005 cklee: Modification for okl.h Sales Quote enhancement
3149:
3150: /* -- 4542290 Do not create var interest schedules. Will do from

Line 3163: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3159: p_chr_id => p_chr_id,
3160: x_rulv_tbl => lx_rulv_tbl
3161: );
3162:
3163: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3164: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3165: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3166: raise OKL_API.G_EXCEPTION_ERROR;
3167: END IF;

Line 3164: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3160: x_rulv_tbl => lx_rulv_tbl
3161: );
3162:
3163: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3164: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3165: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3166: raise OKL_API.G_EXCEPTION_ERROR;
3167: END IF;
3168: /*

Line 3165: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3161: );
3162:
3163: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3164: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3165: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3166: raise OKL_API.G_EXCEPTION_ERROR;
3167: END IF;
3168: /*
3169: lx_rulv_tbl(1).id := l_slh_id;

Line 3166: raise OKL_API.G_EXCEPTION_ERROR;

3162:
3163: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3164: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3165: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3166: raise OKL_API.G_EXCEPTION_ERROR;
3167: END IF;
3168: /*
3169: lx_rulv_tbl(1).id := l_slh_id;
3170: lx_rulv_tbl(1).rgp_id := l_rgp_id;

Line 3178: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

3174: /* - 4542290
3175: x_rulv_tbl := lx_rulv_tbl;
3176:
3177: --Call End Activity
3178: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3179: x_msg_data => x_msg_data);
3180: return;
3181:
3182: end if; */

Line 3202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3198: x_rgp_id => l_rgp_id,
3199: x_cle_id => l_cle_id);
3200:
3201:
3202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3205: raise OKL_API.G_EXCEPTION_ERROR;
3206: END IF;

Line 3203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3199: x_cle_id => l_cle_id);
3200:
3201:
3202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3205: raise OKL_API.G_EXCEPTION_ERROR;
3206: END IF;
3207:

Line 3204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3200:
3201:
3202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3205: raise OKL_API.G_EXCEPTION_ERROR;
3206: END IF;
3207:
3208: --Bug# 4959361

Line 3205: raise OKL_API.G_EXCEPTION_ERROR;

3201:
3202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3205: raise OKL_API.G_EXCEPTION_ERROR;
3206: END IF;
3207:
3208: --Bug# 4959361
3209: IF l_cle_id IS NOT NULL THEN

Line 3218: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3214: x_msg_count => x_msg_count,
3215: x_msg_data => x_msg_data,
3216: p_cle_id => l_cle_id);
3217:
3218: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3220: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3221: RAISE OKL_API.G_EXCEPTION_ERROR;
3222: END IF;

Line 3219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3215: x_msg_data => x_msg_data,
3216: p_cle_id => l_cle_id);
3217:
3218: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3220: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3221: RAISE OKL_API.G_EXCEPTION_ERROR;
3222: END IF;
3223: END IF;

Line 3220: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3216: p_cle_id => l_cle_id);
3217:
3218: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3220: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3221: RAISE OKL_API.G_EXCEPTION_ERROR;
3222: END IF;
3223: END IF;
3224: --Bug# 4959361

Line 3221: RAISE OKL_API.G_EXCEPTION_ERROR;

3217:
3218: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3220: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3221: RAISE OKL_API.G_EXCEPTION_ERROR;
3222: END IF;
3223: END IF;
3224: --Bug# 4959361
3225:

Line 3227: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM

3223: END IF;
3224: --Bug# 4959361
3225:
3226: if(p_update_type is not null and p_update_type = 'DELETE') then
3227: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM
3228: and l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then
3229:
3230: OKL_PAYMENT_APPLICATION_PUB.delete_payment(
3231: p_api_version => p_api_version,

Line 3228: and l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then

3224: --Bug# 4959361
3225:
3226: if(p_update_type is not null and p_update_type = 'DELETE') then
3227: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM
3228: and l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then
3229:
3230: OKL_PAYMENT_APPLICATION_PUB.delete_payment(
3231: p_api_version => p_api_version,
3232: p_init_msg_list => p_init_msg_list,

Line 3240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3236: p_chr_id => p_chr_id,
3237: p_rgp_id => l_rgp_id,
3238: p_rule_id => l_slh_id);
3239:
3240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3241: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3243: raise OKL_API.G_EXCEPTION_ERROR;
3244: END IF;

Line 3241: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3237: p_rgp_id => l_rgp_id,
3238: p_rule_id => l_slh_id);
3239:
3240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3241: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3243: raise OKL_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: else

Line 3242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3238: p_rule_id => l_slh_id);
3239:
3240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3241: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3243: raise OKL_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: else
3246: x_return_status := OKL_API.g_ret_sts_error;

Line 3243: raise OKL_API.G_EXCEPTION_ERROR;

3239:
3240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3241: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3243: raise OKL_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: else
3246: x_return_status := OKL_API.g_ret_sts_error;
3247: OKL_API.SET_MESSAGE( p_app_name => g_app_name

Line 3246: x_return_status := OKL_API.g_ret_sts_error;

3242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3243: raise OKL_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: else
3246: x_return_status := OKL_API.g_ret_sts_error;
3247: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3248: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3249: raise OKL_API.G_EXCEPTION_ERROR;
3250: end if;

Line 3247: OKL_API.SET_MESSAGE( p_app_name => g_app_name

3243: raise OKL_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: else
3246: x_return_status := OKL_API.g_ret_sts_error;
3247: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3248: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3249: raise OKL_API.G_EXCEPTION_ERROR;
3250: end if;
3251: elsif(p_update_type is not null and p_update_type = 'APPLY') then

Line 3249: raise OKL_API.G_EXCEPTION_ERROR;

3245: else
3246: x_return_status := OKL_API.g_ret_sts_error;
3247: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3248: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3249: raise OKL_API.G_EXCEPTION_ERROR;
3250: end if;
3251: elsif(p_update_type is not null and p_update_type = 'APPLY') then
3252: if(p_chr_id is not null and p_chr_id <> OKL_API.G_MISS_NUM
3253: and p_payment_id is not null and p_payment_id <> OKL_API.G_MISS_NUM) then

Line 3252: if(p_chr_id is not null and p_chr_id <> OKL_API.G_MISS_NUM

3248: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3249: raise OKL_API.G_EXCEPTION_ERROR;
3250: end if;
3251: elsif(p_update_type is not null and p_update_type = 'APPLY') then
3252: if(p_chr_id is not null and p_chr_id <> OKL_API.G_MISS_NUM
3253: and p_payment_id is not null and p_payment_id <> OKL_API.G_MISS_NUM) then
3254: l_stream_id := to_char(p_payment_id);
3255: if is_prop_tax_payment(l_stream_id) then
3256: OKL_PAYMENT_APPLICATION_PVT.apply_propery_tax_payment(

Line 3253: and p_payment_id is not null and p_payment_id <> OKL_API.G_MISS_NUM) then

3249: raise OKL_API.G_EXCEPTION_ERROR;
3250: end if;
3251: elsif(p_update_type is not null and p_update_type = 'APPLY') then
3252: if(p_chr_id is not null and p_chr_id <> OKL_API.G_MISS_NUM
3253: and p_payment_id is not null and p_payment_id <> OKL_API.G_MISS_NUM) then
3254: l_stream_id := to_char(p_payment_id);
3255: if is_prop_tax_payment(l_stream_id) then
3256: OKL_PAYMENT_APPLICATION_PVT.apply_propery_tax_payment(
3257: p_api_version => p_api_version,

Line 3264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3260: x_msg_count => x_msg_count,
3261: x_msg_data => x_msg_data,
3262: p_chr_id => p_chr_id,
3263: p_stream_id => l_stream_id);
3264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3265: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3267: raise OKL_API.G_EXCEPTION_ERROR;
3268: END IF;

Line 3265: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3261: x_msg_data => x_msg_data,
3262: p_chr_id => p_chr_id,
3263: p_stream_id => l_stream_id);
3264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3265: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3267: raise OKL_API.G_EXCEPTION_ERROR;
3268: END IF;
3269: /* Manu 13-Sep-2004. For Rollover Fee Payment */

Line 3266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3262: p_chr_id => p_chr_id,
3263: p_stream_id => l_stream_id);
3264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3265: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3267: raise OKL_API.G_EXCEPTION_ERROR;
3268: END IF;
3269: /* Manu 13-Sep-2004. For Rollover Fee Payment */
3270: -- start: cklee: 6/22/05 -- okl.h

Line 3267: raise OKL_API.G_EXCEPTION_ERROR;

3263: p_stream_id => l_stream_id);
3264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3265: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3267: raise OKL_API.G_EXCEPTION_ERROR;
3268: END IF;
3269: /* Manu 13-Sep-2004. For Rollover Fee Payment */
3270: -- start: cklee: 6/22/05 -- okl.h
3271: -- elsif is_rollover_fee_payment(p_service_fee_id) then

Line 3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3281: x_msg_data => x_msg_data,
3282: p_chr_id => p_chr_id,
3283: p_kle_id => p_service_fee_id,
3284: p_stream_id => l_stream_id);
3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3288: raise OKL_API.G_EXCEPTION_ERROR;
3289: END IF;

Line 3286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3282: p_chr_id => p_chr_id,
3283: p_kle_id => p_service_fee_id,
3284: p_stream_id => l_stream_id);
3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3288: raise OKL_API.G_EXCEPTION_ERROR;
3289: END IF;
3290: else

Line 3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3283: p_kle_id => p_service_fee_id,
3284: p_stream_id => l_stream_id);
3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3288: raise OKL_API.G_EXCEPTION_ERROR;
3289: END IF;
3290: else
3291: OKL_PAYMENT_APPLICATION_PUB.apply_payment(

Line 3288: raise OKL_API.G_EXCEPTION_ERROR;

3284: p_stream_id => l_stream_id);
3285: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3287: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3288: raise OKL_API.G_EXCEPTION_ERROR;
3289: END IF;
3290: else
3291: OKL_PAYMENT_APPLICATION_PUB.apply_payment(
3292: p_api_version => p_api_version,

Line 3299: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3295: x_msg_count => x_msg_count,
3296: x_msg_data => x_msg_data,
3297: p_chr_id => p_chr_id,
3298: p_stream_id => l_stream_id);
3299: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3300: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3301: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3302: raise OKL_API.G_EXCEPTION_ERROR;
3303: END IF;

Line 3300: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3296: x_msg_data => x_msg_data,
3297: p_chr_id => p_chr_id,
3298: p_stream_id => l_stream_id);
3299: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3300: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3301: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3302: raise OKL_API.G_EXCEPTION_ERROR;
3303: END IF;
3304: end if;

Line 3301: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3297: p_chr_id => p_chr_id,
3298: p_stream_id => l_stream_id);
3299: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3300: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3301: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3302: raise OKL_API.G_EXCEPTION_ERROR;
3303: END IF;
3304: end if;
3305: else

Line 3302: raise OKL_API.G_EXCEPTION_ERROR;

3298: p_stream_id => l_stream_id);
3299: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3300: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3301: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3302: raise OKL_API.G_EXCEPTION_ERROR;
3303: END IF;
3304: end if;
3305: else
3306: x_return_status := OKL_API.g_ret_sts_error;

Line 3306: x_return_status := OKL_API.g_ret_sts_error;

3302: raise OKL_API.G_EXCEPTION_ERROR;
3303: END IF;
3304: end if;
3305: else
3306: x_return_status := OKL_API.g_ret_sts_error;
3307: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3308: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3309: raise OKL_API.G_EXCEPTION_ERROR;
3310: end if;

Line 3307: OKL_API.SET_MESSAGE( p_app_name => g_app_name

3303: END IF;
3304: end if;
3305: else
3306: x_return_status := OKL_API.g_ret_sts_error;
3307: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3308: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3309: raise OKL_API.G_EXCEPTION_ERROR;
3310: end if;
3311: elsif(p_update_type is not null and p_update_type = 'CALCULATE') then

Line 3309: raise OKL_API.G_EXCEPTION_ERROR;

3305: else
3306: x_return_status := OKL_API.g_ret_sts_error;
3307: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3308: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3309: raise OKL_API.G_EXCEPTION_ERROR;
3310: end if;
3311: elsif(p_update_type is not null and p_update_type = 'CALCULATE') then
3312: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM
3313: and l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then

Line 3312: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM

3308: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3309: raise OKL_API.G_EXCEPTION_ERROR;
3310: end if;
3311: elsif(p_update_type is not null and p_update_type = 'CALCULATE') then
3312: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM
3313: and l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then
3314:
3315: --Bug# 10257857: Modified call to send in arrears as OKL_API.G_MISS_CHAR
3316: -- so that it does not get updated to NULL

Line 3313: and l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then

3309: raise OKL_API.G_EXCEPTION_ERROR;
3310: end if;
3311: elsif(p_update_type is not null and p_update_type = 'CALCULATE') then
3312: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM
3313: and l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then
3314:
3315: --Bug# 10257857: Modified call to send in arrears as OKL_API.G_MISS_CHAR
3316: -- so that it does not get updated to NULL
3317: calculate_details(

Line 3315: --Bug# 10257857: Modified call to send in arrears as OKL_API.G_MISS_CHAR

3311: elsif(p_update_type is not null and p_update_type = 'CALCULATE') then
3312: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM
3313: and l_rgp_id is not null and l_rgp_id <> OKL_API.G_MISS_NUM) then
3314:
3315: --Bug# 10257857: Modified call to send in arrears as OKL_API.G_MISS_CHAR
3316: -- so that it does not get updated to NULL
3317: calculate_details(
3318: p_api_version => p_api_version,
3319: p_init_msg_list => p_init_msg_list,

Line 3328: arrears => OKL_API.G_MISS_CHAR);

3324: p_rgp_id => l_rgp_id,
3325: p_slh_id => l_slh_id,
3326: structure => null,
3327: frequency => null,
3328: arrears => OKL_API.G_MISS_CHAR);
3329:
3330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3326: structure => null,
3327: frequency => null,
3328: arrears => OKL_API.G_MISS_CHAR);
3329:
3330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3333: RAISE OKL_API.G_EXCEPTION_ERROR;
3334: END IF;

Line 3331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3327: frequency => null,
3328: arrears => OKL_API.G_MISS_CHAR);
3329:
3330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3333: RAISE OKL_API.G_EXCEPTION_ERROR;
3334: END IF;
3335:

Line 3332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3328: arrears => OKL_API.G_MISS_CHAR);
3329:
3330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3333: RAISE OKL_API.G_EXCEPTION_ERROR;
3334: END IF;
3335:
3336: else

Line 3333: RAISE OKL_API.G_EXCEPTION_ERROR;

3329:
3330: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3332: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3333: RAISE OKL_API.G_EXCEPTION_ERROR;
3334: END IF;
3335:
3336: else
3337: x_return_status := OKL_API.g_ret_sts_error;

Line 3337: x_return_status := OKL_API.g_ret_sts_error;

3333: RAISE OKL_API.G_EXCEPTION_ERROR;
3334: END IF;
3335:
3336: else
3337: x_return_status := OKL_API.g_ret_sts_error;
3338: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3339: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3340: raise OKL_API.G_EXCEPTION_ERROR;
3341: end if;

Line 3338: OKL_API.SET_MESSAGE( p_app_name => g_app_name

3334: END IF;
3335:
3336: else
3337: x_return_status := OKL_API.g_ret_sts_error;
3338: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3339: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3340: raise OKL_API.G_EXCEPTION_ERROR;
3341: end if;
3342: end if;

Line 3340: raise OKL_API.G_EXCEPTION_ERROR;

3336: else
3337: x_return_status := OKL_API.g_ret_sts_error;
3338: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3339: , p_msg_name => 'OKL_LLA_PMT_SELECT');
3340: raise OKL_API.G_EXCEPTION_ERROR;
3341: end if;
3342: end if;
3343:
3344: -- end if;

Line 3353: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN

3349:
3350: x_rulv_tbl := lx_rulv_tbl;
3351:
3352: -- R12B Authoring OA Migration
3353: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN
3354: IF (l_contract_rec.sts_code IN ('PASSED','COMPLETE','APPROVED','PENDING_APPROVAL')) THEN
3355:
3356: OKL_LA_PAYMENTS_PVT.process_upfront_tax_pymt(
3357: p_api_version => p_api_version,

Line 3364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3360: x_msg_count => x_msg_count,
3361: x_msg_data => x_msg_data,
3362: p_chr_id => p_chr_id);
3363:
3364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3367: RAISE OKL_API.G_EXCEPTION_ERROR;
3368: END IF;

Line 3365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3361: x_msg_data => x_msg_data,
3362: p_chr_id => p_chr_id);
3363:
3364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3367: RAISE OKL_API.G_EXCEPTION_ERROR;
3368: END IF;
3369:

Line 3366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3362: p_chr_id => p_chr_id);
3363:
3364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3367: RAISE OKL_API.G_EXCEPTION_ERROR;
3368: END IF;
3369:
3370: END IF;

Line 3367: RAISE OKL_API.G_EXCEPTION_ERROR;

3363:
3364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3367: RAISE OKL_API.G_EXCEPTION_ERROR;
3368: END IF;
3369:
3370: END IF;
3371: END IF;

Line 3384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3380: x_msg_count => x_msg_count,
3381: x_msg_data => x_msg_data,
3382: p_chr_id => p_chr_id);
3383:
3384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3387: RAISE OKL_API.G_EXCEPTION_ERROR;
3388: END IF;

Line 3385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3381: x_msg_data => x_msg_data,
3382: p_chr_id => p_chr_id);
3383:
3384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3387: RAISE OKL_API.G_EXCEPTION_ERROR;
3388: END IF;
3389:

Line 3386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3382: p_chr_id => p_chr_id);
3383:
3384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3387: RAISE OKL_API.G_EXCEPTION_ERROR;
3388: END IF;
3389:
3390: --Call End Activity

Line 3387: RAISE OKL_API.G_EXCEPTION_ERROR;

3383:
3384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3387: RAISE OKL_API.G_EXCEPTION_ERROR;
3388: END IF;
3389:
3390: --Call End Activity
3391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 3391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

3387: RAISE OKL_API.G_EXCEPTION_ERROR;
3388: END IF;
3389:
3390: --Call End Activity
3391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3392: x_msg_data => x_msg_data);
3393:
3394: EXCEPTION
3395: when OKL_API.G_EXCEPTION_ERROR then

Line 3395: when OKL_API.G_EXCEPTION_ERROR then

3391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3392: x_msg_data => x_msg_data);
3393:
3394: EXCEPTION
3395: when OKL_API.G_EXCEPTION_ERROR then
3396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3397: p_api_name => l_api_name,
3398: p_pkg_name => G_PKG_NAME,
3399: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3392: x_msg_data => x_msg_data);
3393:
3394: EXCEPTION
3395: when OKL_API.G_EXCEPTION_ERROR then
3396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3397: p_api_name => l_api_name,
3398: p_pkg_name => G_PKG_NAME,
3399: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3400: x_msg_count => x_msg_count,

Line 3399: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

3395: when OKL_API.G_EXCEPTION_ERROR then
3396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3397: p_api_name => l_api_name,
3398: p_pkg_name => G_PKG_NAME,
3399: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3400: x_msg_count => x_msg_count,
3401: x_msg_data => x_msg_data,
3402: p_api_type => G_API_TYPE);
3403:

Line 3404: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

3400: x_msg_count => x_msg_count,
3401: x_msg_data => x_msg_data,
3402: p_api_type => G_API_TYPE);
3403:
3404: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3406: p_api_name => l_api_name,
3407: p_pkg_name => G_PKG_NAME,
3408: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3401: x_msg_data => x_msg_data,
3402: p_api_type => G_API_TYPE);
3403:
3404: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3406: p_api_name => l_api_name,
3407: p_pkg_name => G_PKG_NAME,
3408: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3409: x_msg_count => x_msg_count,

Line 3408: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

3404: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3406: p_api_name => l_api_name,
3407: p_pkg_name => G_PKG_NAME,
3408: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3409: x_msg_count => x_msg_count,
3410: x_msg_data => x_msg_data,
3411: p_api_type => G_API_TYPE);
3412:

Line 3414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3410: x_msg_data => x_msg_data,
3411: p_api_type => G_API_TYPE);
3412:
3413: when OTHERS then
3414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3415: p_api_name => l_api_name,
3416: p_pkg_name => G_PKG_NAME,
3417: p_exc_name => 'OTHERS',
3418: x_msg_count => x_msg_count,

Line 3436: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3432: -- Bug #7498330
3433: p_source_trx IN VARCHAR2 DEFAULT 'NA') IS
3434:
3435:
3436: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3437: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PAYMENT';
3438: l_api_version CONSTANT NUMBER := 1.0;
3439:
3440: i NUMBER := 0;

Line 3470: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3466: l_stream_type_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
3467:
3468: begin
3469:
3470: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3471: -- call START_ACTIVITY to create savepoint, check compatibility
3472: -- and initialize message list
3473: x_return_status := OKL_API.START_ACTIVITY(
3474: p_api_name => l_api_name,

Line 3473: x_return_status := OKL_API.START_ACTIVITY(

3469:
3470: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3471: -- call START_ACTIVITY to create savepoint, check compatibility
3472: -- and initialize message list
3473: x_return_status := OKL_API.START_ACTIVITY(
3474: p_api_name => l_api_name,
3475: p_pkg_name => G_PKG_NAME,
3476: p_init_msg_list => p_init_msg_list,
3477: l_api_version => l_api_version,

Line 3483: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3479: p_api_type => G_API_TYPE,
3480: x_return_status => x_return_status);
3481:
3482: -- check if activity started successfully
3483: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3484: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3486: raise OKL_API.G_EXCEPTION_ERROR;
3487: END IF;

Line 3484: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3480: x_return_status => x_return_status);
3481:
3482: -- check if activity started successfully
3483: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3484: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3486: raise OKL_API.G_EXCEPTION_ERROR;
3487: END IF;
3488:

Line 3485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3481:
3482: -- check if activity started successfully
3483: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3484: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3486: raise OKL_API.G_EXCEPTION_ERROR;
3487: END IF;
3488:
3489:

Line 3486: raise OKL_API.G_EXCEPTION_ERROR;

3482: -- check if activity started successfully
3483: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3484: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3486: raise OKL_API.G_EXCEPTION_ERROR;
3487: END IF;
3488:
3489:
3490: -- R12B Authoring OA Migration

Line 3492: l_upfront_tax_pymt_yn := OKL_API.G_FALSE;

3488:
3489:
3490: -- R12B Authoring OA Migration
3491: -- Check if the Payment is for an Upfront Tax Fee line
3492: l_upfront_tax_pymt_yn := OKL_API.G_FALSE;
3493:
3494: if (p_del_pym_tbl.count > 0) then
3495: i := p_del_pym_tbl.FIRST;
3496: loop

Line 3501: x_return_status := OKL_API.g_ret_sts_error;

3497: --bug # 7498330 added check for source trx is Termination (TQ)
3498: --added by rkuttiya
3499: IF p_source_trx <> 'TQ' THEN
3500: if( is_ppd_payment(p_del_pym_tbl(i).slh_id)) then
3501: x_return_status := OKL_API.g_ret_sts_error;
3502: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3503: , p_msg_name => 'OKL_LA_PPD_PAYMENT');
3504: raise OKL_API.G_EXCEPTION_ERROR;
3505: end if;

Line 3502: OKL_API.SET_MESSAGE( p_app_name => g_app_name

3498: --added by rkuttiya
3499: IF p_source_trx <> 'TQ' THEN
3500: if( is_ppd_payment(p_del_pym_tbl(i).slh_id)) then
3501: x_return_status := OKL_API.g_ret_sts_error;
3502: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3503: , p_msg_name => 'OKL_LA_PPD_PAYMENT');
3504: raise OKL_API.G_EXCEPTION_ERROR;
3505: end if;
3506: END IF;

Line 3504: raise OKL_API.G_EXCEPTION_ERROR;

3500: if( is_ppd_payment(p_del_pym_tbl(i).slh_id)) then
3501: x_return_status := OKL_API.g_ret_sts_error;
3502: OKL_API.SET_MESSAGE( p_app_name => g_app_name
3503: , p_msg_name => 'OKL_LA_PPD_PAYMENT');
3504: raise OKL_API.G_EXCEPTION_ERROR;
3505: end if;
3506: END IF;
3507:
3508: -- R12B Authoring OA Migration

Line 3522: p_cle_id => l_cle_id) = OKL_API.G_TRUE) THEN

3518: IF l_cle_id IS NOT NULL THEN
3519:
3520: l_chr_id := p_del_pym_tbl(i).chr_id;
3521: IF (is_upfront_tax_fee_payment(p_chr_id => l_chr_id,
3522: p_cle_id => l_cle_id) = OKL_API.G_TRUE) THEN
3523: l_upfront_tax_pymt_yn := OKL_API.G_TRUE;
3524:
3525: OPEN l_contract_csr(p_chr_id => l_chr_id);
3526: FETCH l_contract_csr INTO l_contract_rec;

Line 3523: l_upfront_tax_pymt_yn := OKL_API.G_TRUE;

3519:
3520: l_chr_id := p_del_pym_tbl(i).chr_id;
3521: IF (is_upfront_tax_fee_payment(p_chr_id => l_chr_id,
3522: p_cle_id => l_cle_id) = OKL_API.G_TRUE) THEN
3523: l_upfront_tax_pymt_yn := OKL_API.G_TRUE;
3524:
3525: OPEN l_contract_csr(p_chr_id => l_chr_id);
3526: FETCH l_contract_csr INTO l_contract_rec;
3527: CLOSE l_contract_csr;

Line 3547: x_return_status := OKL_API.g_ret_sts_error;

3543: p_khr_id => p_del_pym_tbl(i).chr_id,
3544: x_pdt_parameter_rec => l_pdt_parameter_rec);
3545:
3546: IF (l_pdt_parameter_rec.interest_calculation_basis = 'FLOAT') THEN
3547: x_return_status := OKL_API.g_ret_sts_error;
3548: OKL_API.SET_MESSAGE(p_app_name => g_app_name
3549: ,p_msg_name => 'OKL_LA_VAR_INT_SCHED_DEL');
3550: RAISE OKL_API.G_EXCEPTION_ERROR;
3551: END IF;

Line 3548: OKL_API.SET_MESSAGE(p_app_name => g_app_name

3544: x_pdt_parameter_rec => l_pdt_parameter_rec);
3545:
3546: IF (l_pdt_parameter_rec.interest_calculation_basis = 'FLOAT') THEN
3547: x_return_status := OKL_API.g_ret_sts_error;
3548: OKL_API.SET_MESSAGE(p_app_name => g_app_name
3549: ,p_msg_name => 'OKL_LA_VAR_INT_SCHED_DEL');
3550: RAISE OKL_API.G_EXCEPTION_ERROR;
3551: END IF;
3552: END IF;

Line 3550: RAISE OKL_API.G_EXCEPTION_ERROR;

3546: IF (l_pdt_parameter_rec.interest_calculation_basis = 'FLOAT') THEN
3547: x_return_status := OKL_API.g_ret_sts_error;
3548: OKL_API.SET_MESSAGE(p_app_name => g_app_name
3549: ,p_msg_name => 'OKL_LA_VAR_INT_SCHED_DEL');
3550: RAISE OKL_API.G_EXCEPTION_ERROR;
3551: END IF;
3552: END IF;
3553: --Bug# 13973475
3554:

Line 3567: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3563: p_rule_id => p_del_pym_tbl(i).slh_id);
3564:
3565:
3566:
3567: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3569: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3570: RAISE OKL_API.G_EXCEPTION_ERROR;
3571: END IF;

Line 3568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3564:
3565:
3566:
3567: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3569: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3570: RAISE OKL_API.G_EXCEPTION_ERROR;
3571: END IF;
3572:

Line 3569: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3565:
3566:
3567: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3569: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3570: RAISE OKL_API.G_EXCEPTION_ERROR;
3571: END IF;
3572:
3573: exit when (i >= p_del_pym_tbl.last);

Line 3570: RAISE OKL_API.G_EXCEPTION_ERROR;

3566:
3567: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3569: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3570: RAISE OKL_API.G_EXCEPTION_ERROR;
3571: END IF;
3572:
3573: exit when (i >= p_del_pym_tbl.last);
3574: i:= p_del_pym_tbl.NEXT(i);

Line 3579: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN

3575: end loop;
3576: end if;
3577:
3578: -- R12B Authoring OA Migration
3579: IF (l_upfront_tax_pymt_yn = OKL_API.G_TRUE) THEN
3580: IF (l_contract_rec.sts_code IN ('PASSED','COMPLETE','APPROVED','PENDING_APPROVAL')) THEN
3581:
3582: OKL_LA_PAYMENTS_PVT.process_upfront_tax_pymt(
3583: p_api_version => p_api_version,

Line 3590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3586: x_msg_count => x_msg_count,
3587: x_msg_data => x_msg_data,
3588: p_chr_id => l_chr_id);
3589:
3590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3593: RAISE OKL_API.G_EXCEPTION_ERROR;
3594: END IF;

Line 3591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3587: x_msg_data => x_msg_data,
3588: p_chr_id => l_chr_id);
3589:
3590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3593: RAISE OKL_API.G_EXCEPTION_ERROR;
3594: END IF;
3595:

Line 3592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3588: p_chr_id => l_chr_id);
3589:
3590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3593: RAISE OKL_API.G_EXCEPTION_ERROR;
3594: END IF;
3595:
3596: END IF;

Line 3593: RAISE OKL_API.G_EXCEPTION_ERROR;

3589:
3590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3593: RAISE OKL_API.G_EXCEPTION_ERROR;
3594: END IF;
3595:
3596: END IF;
3597: END IF;

Line 3610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3606: x_msg_count => x_msg_count,
3607: x_msg_data => x_msg_data,
3608: p_chr_id => p_del_pym_tbl(i).chr_id);
3609:
3610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3612: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;

Line 3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3607: x_msg_data => x_msg_data,
3608: p_chr_id => p_del_pym_tbl(i).chr_id);
3609:
3610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3612: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;
3615:

Line 3612: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3608: p_chr_id => p_del_pym_tbl(i).chr_id);
3609:
3610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3612: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;
3615:
3616: --Call End Activity

Line 3613: RAISE OKL_API.G_EXCEPTION_ERROR;

3609:
3610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3612: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;
3615:
3616: --Call End Activity
3617: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 3617: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;
3615:
3616: --Call End Activity
3617: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3618: x_msg_data => x_msg_data);
3619:
3620:
3621: EXCEPTION

Line 3622: when OKL_API.G_EXCEPTION_ERROR then

3618: x_msg_data => x_msg_data);
3619:
3620:
3621: EXCEPTION
3622: when OKL_API.G_EXCEPTION_ERROR then
3623: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3624: p_api_name => l_api_name,
3625: p_pkg_name => G_PKG_NAME,
3626: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3623: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3619:
3620:
3621: EXCEPTION
3622: when OKL_API.G_EXCEPTION_ERROR then
3623: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3624: p_api_name => l_api_name,
3625: p_pkg_name => G_PKG_NAME,
3626: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3627: x_msg_count => x_msg_count,

Line 3626: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

3622: when OKL_API.G_EXCEPTION_ERROR then
3623: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3624: p_api_name => l_api_name,
3625: p_pkg_name => G_PKG_NAME,
3626: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3627: x_msg_count => x_msg_count,
3628: x_msg_data => x_msg_data,
3629: p_api_type => G_API_TYPE);
3630:

Line 3631: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

3627: x_msg_count => x_msg_count,
3628: x_msg_data => x_msg_data,
3629: p_api_type => G_API_TYPE);
3630:
3631: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3632: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3633: p_api_name => l_api_name,
3634: p_pkg_name => G_PKG_NAME,
3635: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3632: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3628: x_msg_data => x_msg_data,
3629: p_api_type => G_API_TYPE);
3630:
3631: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3632: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3633: p_api_name => l_api_name,
3634: p_pkg_name => G_PKG_NAME,
3635: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3636: x_msg_count => x_msg_count,

Line 3635: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

3631: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3632: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3633: p_api_name => l_api_name,
3634: p_pkg_name => G_PKG_NAME,
3635: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3636: x_msg_count => x_msg_count,
3637: x_msg_data => x_msg_data,
3638: p_api_type => G_API_TYPE);
3639:

Line 3641: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3637: x_msg_data => x_msg_data,
3638: p_api_type => G_API_TYPE);
3639:
3640: when OTHERS then
3641: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3642: p_api_name => l_api_name,
3643: p_pkg_name => G_PKG_NAME,
3644: p_exc_name => 'OTHERS',
3645: x_msg_count => x_msg_count,

Line 3679: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3675: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3676: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3677: -- x_rulv_tbl OKL_RULE_PUB.RULV_TBL_TYPE;
3678:
3679: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3680: l_api_name CONSTANT VARCHAR2(30) :='VARIABLE_INTEREST_SCHEDULE';
3681: l_api_version CONSTANT NUMBER := 1.0;
3682:
3683: l_payment_id NUMBER;

Line 3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

3686:
3687: l_term okl_k_headers.term_duration%TYPE;
3688:
3689: l_pym_level VARCHAR2(30) := 'HEADER';
3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3691: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3692: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3693:
3694: x_primary_sty_id okl_strm_type_b.ID%TYPE;

Line 3691: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

3687: l_term okl_k_headers.term_duration%TYPE;
3688:
3689: l_pym_level VARCHAR2(30) := 'HEADER';
3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3691: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3692: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3693:
3694: x_primary_sty_id okl_strm_type_b.ID%TYPE;
3695:

Line 3692: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;

3688:
3689: l_pym_level VARCHAR2(30) := 'HEADER';
3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3691: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3692: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3693:
3694: x_primary_sty_id okl_strm_type_b.ID%TYPE;
3695:
3696: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

Line 3726: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3722:
3723: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In variable_interest_schedule... p_chr_id=' || p_chr_id);
3725: END IF;
3726: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3727: x_return_status := OKL_API.START_ACTIVITY(
3728: p_api_name => l_api_name,
3729: p_pkg_name => G_PKG_NAME,
3730: p_init_msg_list => p_init_msg_list,

Line 3727: x_return_status := OKL_API.START_ACTIVITY(

3723: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In variable_interest_schedule... p_chr_id=' || p_chr_id);
3725: END IF;
3726: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3727: x_return_status := OKL_API.START_ACTIVITY(
3728: p_api_name => l_api_name,
3729: p_pkg_name => G_PKG_NAME,
3730: p_init_msg_list => p_init_msg_list,
3731: l_api_version => p_api_version,

Line 3737: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3733: p_api_type => G_API_TYPE,
3734: x_return_status => x_return_status);
3735:
3736: -- check if activity started successfully
3737: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3738: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3739: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3740: raise OKL_API.G_EXCEPTION_ERROR;
3741: END IF;

Line 3738: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3734: x_return_status => x_return_status);
3735:
3736: -- check if activity started successfully
3737: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3738: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3739: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3740: raise OKL_API.G_EXCEPTION_ERROR;
3741: END IF;
3742:

Line 3739: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3735:
3736: -- check if activity started successfully
3737: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3738: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3739: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3740: raise OKL_API.G_EXCEPTION_ERROR;
3741: END IF;
3742:
3743:

Line 3740: raise OKL_API.G_EXCEPTION_ERROR;

3736: -- check if activity started successfully
3737: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3738: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3739: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3740: raise OKL_API.G_EXCEPTION_ERROR;
3741: END IF;
3742:
3743:
3744: /*

Line 3780: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3776: x_return_status => l_return_status,
3777: x_primary_sty_id => l_payment_id
3778: );
3779:
3780: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3781: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3782: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3783: raise OKL_API.G_EXCEPTION_ERROR;
3784: END IF;

Line 3781: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3777: x_primary_sty_id => l_payment_id
3778: );
3779:
3780: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3781: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3782: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3783: raise OKL_API.G_EXCEPTION_ERROR;
3784: END IF;
3785:

Line 3782: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3778: );
3779:
3780: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3781: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3782: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3783: raise OKL_API.G_EXCEPTION_ERROR;
3784: END IF;
3785:
3786: -- 4895333

Line 3783: raise OKL_API.G_EXCEPTION_ERROR;

3779:
3780: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3781: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3782: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3783: raise OKL_API.G_EXCEPTION_ERROR;
3784: END IF;
3785:
3786: -- 4895333
3787: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3821: x_rgp_id => l_rgp_id,
3822: x_cle_id => l_cle_id);
3823:
3824:
3825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3826: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3828: raise OKL_API.G_EXCEPTION_ERROR;
3829: END IF;

Line 3826: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3822: x_cle_id => l_cle_id);
3823:
3824:
3825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3826: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3828: raise OKL_API.G_EXCEPTION_ERROR;
3829: END IF;
3830:

Line 3827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3823:
3824:
3825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3826: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3828: raise OKL_API.G_EXCEPTION_ERROR;
3829: END IF;
3830:
3831: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then

Line 3828: raise OKL_API.G_EXCEPTION_ERROR;

3824:
3825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3826: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3828: raise OKL_API.G_EXCEPTION_ERROR;
3829: END IF;
3830:
3831: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then
3832: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3831: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then

3827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3828: raise OKL_API.G_EXCEPTION_ERROR;
3829: END IF;
3830:
3831: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then
3832: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3833: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_slh_id null... cant create...');
3834: END IF;
3835: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 3835: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

3831: if(l_slh_id is not null and l_slh_id <> OKL_API.G_MISS_NUM) then
3832: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3833: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_slh_id null... cant create...');
3834: END IF;
3835: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3836: x_msg_data => x_msg_data);
3837: return;
3838: end if;
3839:

Line 3873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3869: p_pym_tbl => l_pym_tbl,
3870: p_update_type => 'VIR_PAYMENT',
3871: x_rulv_tbl => x_rulv_tbl);
3872:
3873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3874: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3876: raise OKL_API.G_EXCEPTION_ERROR;
3877: END IF;

Line 3874: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3870: p_update_type => 'VIR_PAYMENT',
3871: x_rulv_tbl => x_rulv_tbl);
3872:
3873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3874: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3876: raise OKL_API.G_EXCEPTION_ERROR;
3877: END IF;
3878:

Line 3875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3871: x_rulv_tbl => x_rulv_tbl);
3872:
3873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3874: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3876: raise OKL_API.G_EXCEPTION_ERROR;
3877: END IF;
3878:
3879: END IF; -- if counter < 1

Line 3876: raise OKL_API.G_EXCEPTION_ERROR;

3872:
3873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3874: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3876: raise OKL_API.G_EXCEPTION_ERROR;
3877: END IF;
3878:
3879: END IF; -- if counter < 1
3880: /* END IF; */

Line 3882: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

3878:
3879: END IF; -- if counter < 1
3880: /* END IF; */
3881:
3882: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3883: x_msg_data => x_msg_data);
3884:
3885: EXCEPTION
3886: when OKL_API.G_EXCEPTION_ERROR then

Line 3886: when OKL_API.G_EXCEPTION_ERROR then

3882: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3883: x_msg_data => x_msg_data);
3884:
3885: EXCEPTION
3886: when OKL_API.G_EXCEPTION_ERROR then
3887: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3888: p_api_name => l_api_name,
3889: p_pkg_name => G_PKG_NAME,
3890: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3887: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3883: x_msg_data => x_msg_data);
3884:
3885: EXCEPTION
3886: when OKL_API.G_EXCEPTION_ERROR then
3887: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3888: p_api_name => l_api_name,
3889: p_pkg_name => G_PKG_NAME,
3890: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3891: x_msg_count => x_msg_count,

Line 3890: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

3886: when OKL_API.G_EXCEPTION_ERROR then
3887: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3888: p_api_name => l_api_name,
3889: p_pkg_name => G_PKG_NAME,
3890: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3891: x_msg_count => x_msg_count,
3892: x_msg_data => x_msg_data,
3893: p_api_type => G_API_TYPE);
3894:

Line 3895: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

3891: x_msg_count => x_msg_count,
3892: x_msg_data => x_msg_data,
3893: p_api_type => G_API_TYPE);
3894:
3895: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3896: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3897: p_api_name => l_api_name,
3898: p_pkg_name => G_PKG_NAME,
3899: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3896: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3892: x_msg_data => x_msg_data,
3893: p_api_type => G_API_TYPE);
3894:
3895: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3896: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3897: p_api_name => l_api_name,
3898: p_pkg_name => G_PKG_NAME,
3899: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3900: x_msg_count => x_msg_count,

Line 3899: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

3895: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
3896: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3897: p_api_name => l_api_name,
3898: p_pkg_name => G_PKG_NAME,
3899: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3900: x_msg_count => x_msg_count,
3901: x_msg_data => x_msg_data,
3902: p_api_type => G_API_TYPE);
3903:

Line 3905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3901: x_msg_data => x_msg_data,
3902: p_api_type => G_API_TYPE);
3903:
3904: when OTHERS then
3905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3906: p_api_name => l_api_name,
3907: p_pkg_name => G_PKG_NAME,
3908: p_exc_name => 'OTHERS',
3909: x_msg_count => x_msg_count,

Line 3928: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3924: x_msg_data OUT NOCOPY VARCHAR2,
3925: p_chr_id IN NUMBER,
3926: p_cle_id IN NUMBER DEFAULT NULL) IS
3927:
3928: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3929: l_api_name CONSTANT VARCHAR2(30) :='UPDATE_PYMT_START_DATE';
3930: l_api_version CONSTANT NUMBER := 1.0;
3931:
3932: CURSOR c_all_pymts_csr(p_chr_id NUMBER) IS

Line 3977: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3973: IF (G_DEBUG_ENABLED = 'Y') THEN
3974: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3975: END IF;
3976:
3977: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3978: x_return_status := OKL_API.START_ACTIVITY(
3979: p_api_name => l_api_name,
3980: p_pkg_name => G_PKG_NAME,
3981: p_init_msg_list => p_init_msg_list,

Line 3978: x_return_status := OKL_API.START_ACTIVITY(

3974: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3975: END IF;
3976:
3977: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3978: x_return_status := OKL_API.START_ACTIVITY(
3979: p_api_name => l_api_name,
3980: p_pkg_name => G_PKG_NAME,
3981: p_init_msg_list => p_init_msg_list,
3982: l_api_version => p_api_version,

Line 3988: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

3984: p_api_type => G_API_TYPE,
3985: x_return_status => x_return_status);
3986:
3987: -- check if activity started successfully
3988: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3989: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3990: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3991: raise OKL_API.G_EXCEPTION_ERROR;
3992: END IF;

Line 3989: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3985: x_return_status => x_return_status);
3986:
3987: -- check if activity started successfully
3988: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3989: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3990: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3991: raise OKL_API.G_EXCEPTION_ERROR;
3992: END IF;
3993:

Line 3990: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

3986:
3987: -- check if activity started successfully
3988: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3989: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3990: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3991: raise OKL_API.G_EXCEPTION_ERROR;
3992: END IF;
3993:
3994: IF p_cle_id IS NOT NULL THEN

Line 3991: raise OKL_API.G_EXCEPTION_ERROR;

3987: -- check if activity started successfully
3988: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3989: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3990: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3991: raise OKL_API.G_EXCEPTION_ERROR;
3992: END IF;
3993:
3994: IF p_cle_id IS NOT NULL THEN
3995:

Line 3999: --Bug# 10257857: Modified call to send in arrears as OKL_API.G_MISS_CHAR

3995:
3996: FOR r_line_pymts_rec IN c_line_pymts_csr(p_chr_id => p_chr_id,
3997: p_cle_id => p_cle_id) LOOP
3998:
3999: --Bug# 10257857: Modified call to send in arrears as OKL_API.G_MISS_CHAR
4000: -- so that it does not get updated to NULL
4001: calculate_details(
4002: p_api_version => p_api_version,
4003: p_init_msg_list => p_init_msg_list,

Line 4012: arrears => OKL_API.G_MISS_CHAR,

4008: p_rgp_id => r_line_pymts_rec.rgp_lalevl_id,
4009: p_slh_id => r_line_pymts_rec.rul_laslh_id,
4010: structure => NULL,
4011: frequency => NULL,
4012: arrears => OKL_API.G_MISS_CHAR,
4013: p_validate_date_yn => 'N');
4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

4011: frequency => NULL,
4012: arrears => OKL_API.G_MISS_CHAR,
4013: p_validate_date_yn => 'N');
4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4018: RAISE OKL_API.G_EXCEPTION_ERROR;
4019: END IF;

Line 4016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4012: arrears => OKL_API.G_MISS_CHAR,
4013: p_validate_date_yn => 'N');
4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4018: RAISE OKL_API.G_EXCEPTION_ERROR;
4019: END IF;
4020:

Line 4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

4013: p_validate_date_yn => 'N');
4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4018: RAISE OKL_API.G_EXCEPTION_ERROR;
4019: END IF;
4020:
4021: END LOOP;

Line 4018: RAISE OKL_API.G_EXCEPTION_ERROR;

4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4018: RAISE OKL_API.G_EXCEPTION_ERROR;
4019: END IF;
4020:
4021: END LOOP;
4022:

Line 4028: --Bug# 10257857: Modified call to send in arrears as OKL_API.G_MISS_CHAR

4024:
4025: FOR r_all_pymts_rec IN c_all_pymts_csr(p_chr_id => p_chr_id) LOOP
4026:
4027: --Added p_update_type by bkatraga for bug 13478101
4028: --Bug# 10257857: Modified call to send in arrears as OKL_API.G_MISS_CHAR
4029: -- so that it does not get updated to NULL
4030: calculate_details(
4031: p_api_version => p_api_version,
4032: p_init_msg_list => p_init_msg_list,

Line 4041: arrears => OKL_API.G_MISS_CHAR,

4037: p_rgp_id => r_all_pymts_rec.rgp_lalevl_id,
4038: p_slh_id => r_all_pymts_rec.rul_laslh_id,
4039: structure => NULL,
4040: frequency => NULL,
4041: arrears => OKL_API.G_MISS_CHAR,
4042: p_validate_date_yn => 'N',
4043: p_update_type => 'UPDATE');
4044:
4045: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4045: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

4041: arrears => OKL_API.G_MISS_CHAR,
4042: p_validate_date_yn => 'N',
4043: p_update_type => 'UPDATE');
4044:
4045: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4046: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4047: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4048: RAISE OKL_API.G_EXCEPTION_ERROR;
4049: END IF;

Line 4046: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4042: p_validate_date_yn => 'N',
4043: p_update_type => 'UPDATE');
4044:
4045: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4046: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4047: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4048: RAISE OKL_API.G_EXCEPTION_ERROR;
4049: END IF;
4050:

Line 4047: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

4043: p_update_type => 'UPDATE');
4044:
4045: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4046: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4047: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4048: RAISE OKL_API.G_EXCEPTION_ERROR;
4049: END IF;
4050:
4051: END LOOP;

Line 4048: RAISE OKL_API.G_EXCEPTION_ERROR;

4044:
4045: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4046: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4047: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4048: RAISE OKL_API.G_EXCEPTION_ERROR;
4049: END IF;
4050:
4051: END LOOP;
4052: END IF;

Line 4054: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

4050:
4051: END LOOP;
4052: END IF;
4053:
4054: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
4055: x_msg_data => x_msg_data);
4056:
4057: EXCEPTION
4058: when OKL_API.G_EXCEPTION_ERROR then

Line 4058: when OKL_API.G_EXCEPTION_ERROR then

4054: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
4055: x_msg_data => x_msg_data);
4056:
4057: EXCEPTION
4058: when OKL_API.G_EXCEPTION_ERROR then
4059: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4060: p_api_name => l_api_name,
4061: p_pkg_name => G_PKG_NAME,
4062: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 4059: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4055: x_msg_data => x_msg_data);
4056:
4057: EXCEPTION
4058: when OKL_API.G_EXCEPTION_ERROR then
4059: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4060: p_api_name => l_api_name,
4061: p_pkg_name => G_PKG_NAME,
4062: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4063: x_msg_count => x_msg_count,

Line 4062: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

4058: when OKL_API.G_EXCEPTION_ERROR then
4059: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4060: p_api_name => l_api_name,
4061: p_pkg_name => G_PKG_NAME,
4062: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4063: x_msg_count => x_msg_count,
4064: x_msg_data => x_msg_data,
4065: p_api_type => G_API_TYPE);
4066:

Line 4067: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

4063: x_msg_count => x_msg_count,
4064: x_msg_data => x_msg_data,
4065: p_api_type => G_API_TYPE);
4066:
4067: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4068: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4069: p_api_name => l_api_name,
4070: p_pkg_name => G_PKG_NAME,
4071: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 4068: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4064: x_msg_data => x_msg_data,
4065: p_api_type => G_API_TYPE);
4066:
4067: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4068: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4069: p_api_name => l_api_name,
4070: p_pkg_name => G_PKG_NAME,
4071: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4072: x_msg_count => x_msg_count,

Line 4071: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

4067: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4068: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4069: p_api_name => l_api_name,
4070: p_pkg_name => G_PKG_NAME,
4071: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4072: x_msg_count => x_msg_count,
4073: x_msg_data => x_msg_data,
4074: p_api_type => G_API_TYPE);
4075:

Line 4077: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4073: x_msg_data => x_msg_data,
4074: p_api_type => G_API_TYPE);
4075:
4076: when OTHERS then
4077: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4078: p_api_name => l_api_name,
4079: p_pkg_name => G_PKG_NAME,
4080: p_exc_name => 'OTHERS',
4081: x_msg_count => x_msg_count,