APPS.OKL_LEASE_RATE_FACTORS_PVT dependencies on OKL_API

Line 31: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

27: lp_lrfv_upd_tbl lrfv_tbl_type;
28: lx_lrfv_upd_tbl lrfv_tbl_type;
29: l_api_name CONSTANT varchar2(30) := 'handle_lrf_ents';
30: l_api_version CONSTANT number := 1.0;
31: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
32: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_factors_pvt.handle_lrf_ents';
33: l_debug_enabled varchar2(10);
34: is_debug_procedure_on boolean;
35: is_debug_statement_on boolean;

Line 56: l_return_status := okl_api.start_activity(p_api_name => l_api_name

52:
53: -- call START_ACTIVITY to create savepoint, check compatibility
54: -- and initialize message list
55:
56: l_return_status := okl_api.start_activity(p_api_name => l_api_name
57: ,p_pkg_name => g_pkg_name
58: ,p_init_msg_list => p_init_msg_list
59: ,l_api_version => l_api_version
60: ,p_api_version => p_api_version

Line 66: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

62: ,x_return_status => x_return_status);
63:
64: -- check if activity started successfully
65:
66: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
67: RAISE okl_api.g_exception_unexpected_error;
68: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
69: RAISE okl_api.g_exception_error;
70: END IF;

Line 67: RAISE okl_api.g_exception_unexpected_error;

63:
64: -- check if activity started successfully
65:
66: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
67: RAISE okl_api.g_exception_unexpected_error;
68: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
69: RAISE okl_api.g_exception_error;
70: END IF;
71: lp_lrfv_tbl := p_lrfv_tbl;

Line 68: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

64: -- check if activity started successfully
65:
66: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
67: RAISE okl_api.g_exception_unexpected_error;
68: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
69: RAISE okl_api.g_exception_error;
70: END IF;
71: lp_lrfv_tbl := p_lrfv_tbl;
72: lp_lrlv_tbl := p_lrlv_tbl; -- call validate_periods to see sum of periods = term/frequency

Line 69: RAISE okl_api.g_exception_error;

65:
66: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
67: RAISE okl_api.g_exception_unexpected_error;
68: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
69: RAISE okl_api.g_exception_error;
70: END IF;
71: lp_lrfv_tbl := p_lrfv_tbl;
72: lp_lrlv_tbl := p_lrlv_tbl; -- call validate_periods to see sum of periods = term/frequency
73:

Line 94: RAISE okl_api.g_exception_error;

90: ,'Procedure okl_lrf_pvt.insert_row with status ' ||
91: l_return_status);
92: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
93: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
94: RAISE okl_api.g_exception_error;
95: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
96: RAISE okl_api.g_exception_unexpected_error;
97: END IF;
98: FOR j IN lp_lrlv_tbl.FIRST..lp_lrlv_tbl.LAST LOOP

Line 96: RAISE okl_api.g_exception_unexpected_error;

92: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
93: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
94: RAISE okl_api.g_exception_error;
95: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
96: RAISE okl_api.g_exception_unexpected_error;
97: END IF;
98: FOR j IN lp_lrlv_tbl.FIRST..lp_lrlv_tbl.LAST LOOP
99:
100: --if the ecl_id in lp_ecv_tbl(i) is same as the id in the recently inserter record

Line 126: RAISE okl_api.g_exception_error;

122: ,'Procedure okl_lrl_pvt.insert_row with status ' ||
123: l_return_status);
124: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
125: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
126: RAISE okl_api.g_exception_error;
127: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: END IF;
130: ELSE

Line 128: RAISE okl_api.g_exception_unexpected_error;

124: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
125: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
126: RAISE okl_api.g_exception_error;
127: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: END IF;
130: ELSE
131: okl_lrl_pvt.update_row(l_api_version
132: ,g_false

Line 148: RAISE okl_api.g_exception_error;

144: ,'Procedure okl_lrl_pvt.update_row with status ' ||
145: l_return_status);
146: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
147: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
148: RAISE okl_api.g_exception_error;
149: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
150: RAISE okl_api.g_exception_unexpected_error;
151: END IF;
152: END IF;

Line 150: RAISE okl_api.g_exception_unexpected_error;

146: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
147: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
148: RAISE okl_api.g_exception_error;
149: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
150: RAISE okl_api.g_exception_unexpected_error;
151: END IF;
152: END IF;
153: END IF;
154: END LOOP;

Line 173: RAISE okl_api.g_exception_error;

169: ,'Procedure okl_lrf_pvt.update_row with status ' ||
170: l_return_status);
171: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
172: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
173: RAISE okl_api.g_exception_error;
174: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
175: RAISE okl_api.g_exception_unexpected_error;
176: END IF;
177: FOR j IN lp_lrlv_tbl.FIRST..lp_lrlv_tbl.LAST LOOP

Line 175: RAISE okl_api.g_exception_unexpected_error;

171: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
172: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
173: RAISE okl_api.g_exception_error;
174: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
175: RAISE okl_api.g_exception_unexpected_error;
176: END IF;
177: FOR j IN lp_lrlv_tbl.FIRST..lp_lrlv_tbl.LAST LOOP
178:
179: --if the ecl_id in lp_ecv_tbl(i) is same as the id in the recently inserter record

Line 202: RAISE okl_api.g_exception_error;

198: ,'Procedure okl_lrl_pvt.insert_row with status ' ||
199: l_return_status);
200: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
201: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
202: RAISE okl_api.g_exception_error;
203: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
204: RAISE okl_api.g_exception_unexpected_error;
205: END IF;
206: ELSE

Line 204: RAISE okl_api.g_exception_unexpected_error;

200: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
201: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
202: RAISE okl_api.g_exception_error;
203: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
204: RAISE okl_api.g_exception_unexpected_error;
205: END IF;
206: ELSE
207: okl_lrl_pvt.update_row(l_api_version
208: ,g_false

Line 224: RAISE okl_api.g_exception_error;

220: ,'Procedure okl_lrl_pvt.update_row with status ' ||
221: l_return_status);
222: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
224: RAISE okl_api.g_exception_error;
225: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
226: RAISE okl_api.g_exception_unexpected_error;
227: END IF;
228: END IF;

Line 226: RAISE okl_api.g_exception_unexpected_error;

222: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
224: RAISE okl_api.g_exception_error;
225: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
226: RAISE okl_api.g_exception_unexpected_error;
227: END IF;
228: END IF;
229: END IF;
230: END LOOP;

Line 237: okl_api.end_activity(x_msg_count => x_msg_count

233: END LOOP; --Assign value to OUT variables
234: x_lrfv_tbl := lx_lrfv_tbl;
235: x_lrlv_tbl := lx_lrlv_tbl;
236: x_return_status := l_return_status;
237: okl_api.end_activity(x_msg_count => x_msg_count
238: ,x_msg_data => x_msg_data);
239:
240: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
241: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 247: WHEN okl_api.g_exception_error THEN

243: ,'end debug OKLRECVB.pls.pls call handle_lrf_ents');
244: END IF;
245:
246: EXCEPTION
247: WHEN okl_api.g_exception_error THEN
248: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
249: ,p_pkg_name => g_pkg_name
250: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
251: ,x_msg_count => x_msg_count

Line 248: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

244: END IF;
245:
246: EXCEPTION
247: WHEN okl_api.g_exception_error THEN
248: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
249: ,p_pkg_name => g_pkg_name
250: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
251: ,x_msg_count => x_msg_count
252: ,x_msg_data => x_msg_data

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

246: EXCEPTION
247: WHEN okl_api.g_exception_error THEN
248: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
249: ,p_pkg_name => g_pkg_name
250: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
251: ,x_msg_count => x_msg_count
252: ,x_msg_data => x_msg_data
253: ,p_api_type => g_api_type);
254: WHEN okl_api.g_exception_unexpected_error THEN

Line 254: WHEN okl_api.g_exception_unexpected_error THEN

250: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
251: ,x_msg_count => x_msg_count
252: ,x_msg_data => x_msg_data
253: ,p_api_type => g_api_type);
254: WHEN okl_api.g_exception_unexpected_error THEN
255: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
256: ,p_pkg_name => g_pkg_name
257: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
258: ,x_msg_count => x_msg_count

Line 255: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

251: ,x_msg_count => x_msg_count
252: ,x_msg_data => x_msg_data
253: ,p_api_type => g_api_type);
254: WHEN okl_api.g_exception_unexpected_error THEN
255: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
256: ,p_pkg_name => g_pkg_name
257: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
258: ,x_msg_count => x_msg_count
259: ,x_msg_data => x_msg_data

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

253: ,p_api_type => g_api_type);
254: WHEN okl_api.g_exception_unexpected_error THEN
255: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
256: ,p_pkg_name => g_pkg_name
257: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
258: ,x_msg_count => x_msg_count
259: ,x_msg_data => x_msg_data
260: ,p_api_type => g_api_type);
261: WHEN OTHERS THEN

Line 262: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

258: ,x_msg_count => x_msg_count
259: ,x_msg_data => x_msg_data
260: ,p_api_type => g_api_type);
261: WHEN OTHERS THEN
262: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
263: ,p_pkg_name => g_pkg_name
264: ,p_exc_name => 'OTHERS'
265: ,x_msg_count => x_msg_count
266: ,x_msg_data => x_msg_data

Line 296: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

292: WHERE rate_set_version_id = p_lrv_id;
293: i number;
294: l_api_name CONSTANT varchar2(30) := 'delete_lrf';
295: l_api_version CONSTANT number := 1.0;
296: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
297: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_factors_pvt.delete_lease_rate_factors';
298: l_debug_enabled varchar2(10);
299: is_debug_procedure_on boolean;
300: is_debug_statement_on boolean;

Line 321: l_return_status := okl_api.start_activity(p_api_name => l_api_name

317:
318: -- call START_ACTIVITY to create savepoint, check compatibility
319: -- and initialize message list
320:
321: l_return_status := okl_api.start_activity(p_api_name => l_api_name
322: ,p_pkg_name => g_pkg_name
323: ,p_init_msg_list => p_init_msg_list
324: ,l_api_version => l_api_version
325: ,p_api_version => p_api_version

Line 331: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

327: ,x_return_status => x_return_status);
328:
329: -- check if activity started successfully
330:
331: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
332: RAISE okl_api.g_exception_unexpected_error;
333: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
334: RAISE okl_api.g_exception_error;
335: END IF;

Line 332: RAISE okl_api.g_exception_unexpected_error;

328:
329: -- check if activity started successfully
330:
331: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
332: RAISE okl_api.g_exception_unexpected_error;
333: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
334: RAISE okl_api.g_exception_error;
335: END IF;
336: l_lrv_id := p_lrv_id;

Line 333: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

329: -- check if activity started successfully
330:
331: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
332: RAISE okl_api.g_exception_unexpected_error;
333: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
334: RAISE okl_api.g_exception_error;
335: END IF;
336: l_lrv_id := p_lrv_id;
337:

Line 334: RAISE okl_api.g_exception_error;

330:
331: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
332: RAISE okl_api.g_exception_unexpected_error;
333: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
334: RAISE okl_api.g_exception_error;
335: END IF;
336: l_lrv_id := p_lrv_id;
337:
338: --populate factors table with all the factors of rate_Set_version_id

Line 360: ,p_init_msg_list => okl_api.g_false

356: --delete all levels
357:
358: IF l_lrlv_tbl.COUNT > 0 THEN
359: okl_lrl_pvt.delete_row(p_api_version => p_api_version
360: ,p_init_msg_list => okl_api.g_false
361: ,x_return_status => l_return_status
362: ,x_msg_count => x_msg_count
363: ,x_msg_data => x_msg_data
364: ,p_lrlv_tbl => l_lrlv_tbl);

Line 375: RAISE okl_api.g_exception_error;

371: ,'Procedure OKL_LRL_PVT.delete_row returned with status ' ||
372: l_return_status);
373: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
374: IF l_return_status = g_ret_sts_error THEN
375: RAISE okl_api.g_exception_error;
376: ELSIF l_return_status = g_ret_sts_unexp_error THEN
377: RAISE okl_api.g_exception_unexpected_error;
378: END IF;
379: END IF;

Line 377: RAISE okl_api.g_exception_unexpected_error;

373: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
374: IF l_return_status = g_ret_sts_error THEN
375: RAISE okl_api.g_exception_error;
376: ELSIF l_return_status = g_ret_sts_unexp_error THEN
377: RAISE okl_api.g_exception_unexpected_error;
378: END IF;
379: END IF;
380:
381: --delete all factors

Line 385: ,p_init_msg_list => okl_api.g_false

381: --delete all factors
382:
383: IF l_lrfv_tbl.COUNT > 0 THEN
384: okl_lrf_pvt.delete_row(p_api_version => p_api_version
385: ,p_init_msg_list => okl_api.g_false
386: ,x_return_status => l_return_status
387: ,x_msg_count => x_msg_count
388: ,x_msg_data => x_msg_data
389: ,p_lrfv_tbl => l_lrfv_tbl);

Line 400: RAISE okl_api.g_exception_error;

396: ,'Procedure OKL_LRF_PVT.delete_row returned with status ' ||
397: l_return_status);
398: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
399: IF l_return_status = g_ret_sts_error THEN
400: RAISE okl_api.g_exception_error;
401: ELSIF l_return_status = g_ret_sts_unexp_error THEN
402: RAISE okl_api.g_exception_unexpected_error;
403: END IF;
404: END IF;

Line 402: RAISE okl_api.g_exception_unexpected_error;

398: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
399: IF l_return_status = g_ret_sts_error THEN
400: RAISE okl_api.g_exception_error;
401: ELSIF l_return_status = g_ret_sts_unexp_error THEN
402: RAISE okl_api.g_exception_unexpected_error;
403: END IF;
404: END IF;
405: x_return_status := l_return_status;
406: okl_api.end_activity(x_msg_count => x_msg_count

Line 406: okl_api.end_activity(x_msg_count => x_msg_count

402: RAISE okl_api.g_exception_unexpected_error;
403: END IF;
404: END IF;
405: x_return_status := l_return_status;
406: okl_api.end_activity(x_msg_count => x_msg_count
407: ,x_msg_data => x_msg_data);
408:
409: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
410: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 416: WHEN okl_api.g_exception_error THEN

412: ,'end debug OKLRECVB.pls.pls call delete_lease_rate_factors');
413: END IF;
414:
415: EXCEPTION
416: WHEN okl_api.g_exception_error THEN
417: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
418: ,p_pkg_name => g_pkg_name
419: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
420: ,x_msg_count => x_msg_count

Line 417: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

413: END IF;
414:
415: EXCEPTION
416: WHEN okl_api.g_exception_error THEN
417: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
418: ,p_pkg_name => g_pkg_name
419: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
420: ,x_msg_count => x_msg_count
421: ,x_msg_data => x_msg_data

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

415: EXCEPTION
416: WHEN okl_api.g_exception_error THEN
417: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
418: ,p_pkg_name => g_pkg_name
419: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
420: ,x_msg_count => x_msg_count
421: ,x_msg_data => x_msg_data
422: ,p_api_type => g_api_type);
423: WHEN okl_api.g_exception_unexpected_error THEN

Line 423: WHEN okl_api.g_exception_unexpected_error THEN

419: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
420: ,x_msg_count => x_msg_count
421: ,x_msg_data => x_msg_data
422: ,p_api_type => g_api_type);
423: WHEN okl_api.g_exception_unexpected_error THEN
424: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
425: ,p_pkg_name => g_pkg_name
426: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
427: ,x_msg_count => x_msg_count

Line 424: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

420: ,x_msg_count => x_msg_count
421: ,x_msg_data => x_msg_data
422: ,p_api_type => g_api_type);
423: WHEN okl_api.g_exception_unexpected_error THEN
424: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
425: ,p_pkg_name => g_pkg_name
426: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
427: ,x_msg_count => x_msg_count
428: ,x_msg_data => x_msg_data

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

422: ,p_api_type => g_api_type);
423: WHEN okl_api.g_exception_unexpected_error THEN
424: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
425: ,p_pkg_name => g_pkg_name
426: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
427: ,x_msg_count => x_msg_count
428: ,x_msg_data => x_msg_data
429: ,p_api_type => g_api_type);
430: WHEN OTHERS THEN

Line 431: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

427: ,x_msg_count => x_msg_count
428: ,x_msg_data => x_msg_data
429: ,p_api_type => g_api_type);
430: WHEN OTHERS THEN
431: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
432: ,p_pkg_name => g_pkg_name
433: ,p_exc_name => 'OTHERS'
434: ,x_msg_count => x_msg_count
435: ,x_msg_data => x_msg_data

Line 459: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

455: WHERE rate_set_factor_id = p_lrfv_rec.id;
456: i number;
457: l_api_name CONSTANT varchar2(30) := 'rmv_lrs_factor';
458: l_api_version CONSTANT number := 1.0;
459: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
460: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_factors_pvt.remove_lrs_factor';
461: l_debug_enabled varchar2(10);
462: is_debug_procedure_on boolean;
463: is_debug_statement_on boolean;

Line 484: l_return_status := okl_api.start_activity(p_api_name => l_api_name

480:
481: -- call START_ACTIVITY to create savepoint, check compatibility
482: -- and initialize message list
483:
484: l_return_status := okl_api.start_activity(p_api_name => l_api_name
485: ,p_pkg_name => g_pkg_name
486: ,p_init_msg_list => p_init_msg_list
487: ,l_api_version => l_api_version
488: ,p_api_version => p_api_version

Line 494: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

490: ,x_return_status => x_return_status);
491:
492: -- check if activity started successfully
493:
494: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
495: RAISE okl_api.g_exception_unexpected_error;
496: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
497: RAISE okl_api.g_exception_error;
498: END IF;

Line 495: RAISE okl_api.g_exception_unexpected_error;

491:
492: -- check if activity started successfully
493:
494: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
495: RAISE okl_api.g_exception_unexpected_error;
496: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
497: RAISE okl_api.g_exception_error;
498: END IF;
499: l_lrfv_rec := p_lrfv_rec;

Line 496: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

492: -- check if activity started successfully
493:
494: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
495: RAISE okl_api.g_exception_unexpected_error;
496: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
497: RAISE okl_api.g_exception_error;
498: END IF;
499: l_lrfv_rec := p_lrfv_rec;
500:

Line 497: RAISE okl_api.g_exception_error;

493:
494: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
495: RAISE okl_api.g_exception_unexpected_error;
496: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
497: RAISE okl_api.g_exception_error;
498: END IF;
499: l_lrfv_rec := p_lrfv_rec;
500:
501: --populate levels table with all the levels of rate_Set_version_id

Line 514: ,p_init_msg_list => okl_api.g_false

510: --delete all levels
511:
512: IF l_lrlv_tbl.COUNT > 0 THEN
513: okl_lrl_pvt.delete_row(p_api_version => p_api_version
514: ,p_init_msg_list => okl_api.g_false
515: ,x_return_status => l_return_status
516: ,x_msg_count => x_msg_count
517: ,x_msg_data => x_msg_data
518: ,p_lrlv_tbl => l_lrlv_tbl);

Line 520: RAISE okl_api.g_exception_error;

516: ,x_msg_count => x_msg_count
517: ,x_msg_data => x_msg_data
518: ,p_lrlv_tbl => l_lrlv_tbl);
519: IF l_return_status = g_ret_sts_error THEN
520: RAISE okl_api.g_exception_error;
521: ELSIF l_return_status = g_ret_sts_unexp_error THEN
522: RAISE okl_api.g_exception_unexpected_error;
523: END IF;
524: END IF; --delete factor row

Line 522: RAISE okl_api.g_exception_unexpected_error;

518: ,p_lrlv_tbl => l_lrlv_tbl);
519: IF l_return_status = g_ret_sts_error THEN
520: RAISE okl_api.g_exception_error;
521: ELSIF l_return_status = g_ret_sts_unexp_error THEN
522: RAISE okl_api.g_exception_unexpected_error;
523: END IF;
524: END IF; --delete factor row
525: okl_lrf_pvt.delete_row(p_api_version => p_api_version
526: ,p_init_msg_list => okl_api.g_false

Line 526: ,p_init_msg_list => okl_api.g_false

522: RAISE okl_api.g_exception_unexpected_error;
523: END IF;
524: END IF; --delete factor row
525: okl_lrf_pvt.delete_row(p_api_version => p_api_version
526: ,p_init_msg_list => okl_api.g_false
527: ,x_return_status => l_return_status
528: ,x_msg_count => x_msg_count
529: ,x_msg_data => x_msg_data
530: ,p_lrfv_rec => l_lrfv_rec);

Line 533: RAISE okl_api.g_exception_error;

529: ,x_msg_data => x_msg_data
530: ,p_lrfv_rec => l_lrfv_rec);
531:
532: IF l_return_status = g_ret_sts_error THEN
533: RAISE okl_api.g_exception_error;
534: ELSIF l_return_status = g_ret_sts_unexp_error THEN
535: RAISE okl_api.g_exception_unexpected_error;
536: END IF;
537: x_return_status := l_return_status;

Line 535: RAISE okl_api.g_exception_unexpected_error;

531:
532: IF l_return_status = g_ret_sts_error THEN
533: RAISE okl_api.g_exception_error;
534: ELSIF l_return_status = g_ret_sts_unexp_error THEN
535: RAISE okl_api.g_exception_unexpected_error;
536: END IF;
537: x_return_status := l_return_status;
538: okl_api.end_activity(x_msg_count => x_msg_count
539: ,x_msg_data => x_msg_data);

Line 538: okl_api.end_activity(x_msg_count => x_msg_count

534: ELSIF l_return_status = g_ret_sts_unexp_error THEN
535: RAISE okl_api.g_exception_unexpected_error;
536: END IF;
537: x_return_status := l_return_status;
538: okl_api.end_activity(x_msg_count => x_msg_count
539: ,x_msg_data => x_msg_data);
540:
541: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
542: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 548: WHEN okl_api.g_exception_error THEN

544: ,'end debug OKLRECVB.pls.pls call remove_lrs_factor');
545: END IF;
546:
547: EXCEPTION
548: WHEN okl_api.g_exception_error THEN
549: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
550: ,p_pkg_name => g_pkg_name
551: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
552: ,x_msg_count => x_msg_count

Line 549: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

545: END IF;
546:
547: EXCEPTION
548: WHEN okl_api.g_exception_error THEN
549: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
550: ,p_pkg_name => g_pkg_name
551: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
552: ,x_msg_count => x_msg_count
553: ,x_msg_data => x_msg_data

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

547: EXCEPTION
548: WHEN okl_api.g_exception_error THEN
549: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
550: ,p_pkg_name => g_pkg_name
551: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
552: ,x_msg_count => x_msg_count
553: ,x_msg_data => x_msg_data
554: ,p_api_type => g_api_type);
555: WHEN okl_api.g_exception_unexpected_error THEN

Line 555: WHEN okl_api.g_exception_unexpected_error THEN

551: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
552: ,x_msg_count => x_msg_count
553: ,x_msg_data => x_msg_data
554: ,p_api_type => g_api_type);
555: WHEN okl_api.g_exception_unexpected_error THEN
556: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
557: ,p_pkg_name => g_pkg_name
558: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
559: ,x_msg_count => x_msg_count

Line 556: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

552: ,x_msg_count => x_msg_count
553: ,x_msg_data => x_msg_data
554: ,p_api_type => g_api_type);
555: WHEN okl_api.g_exception_unexpected_error THEN
556: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
557: ,p_pkg_name => g_pkg_name
558: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
559: ,x_msg_count => x_msg_count
560: ,x_msg_data => x_msg_data

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

554: ,p_api_type => g_api_type);
555: WHEN okl_api.g_exception_unexpected_error THEN
556: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
557: ,p_pkg_name => g_pkg_name
558: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
559: ,x_msg_count => x_msg_count
560: ,x_msg_data => x_msg_data
561: ,p_api_type => g_api_type);
562: WHEN OTHERS THEN

Line 563: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

559: ,x_msg_count => x_msg_count
560: ,x_msg_data => x_msg_data
561: ,p_api_type => g_api_type);
562: WHEN OTHERS THEN
563: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
564: ,p_pkg_name => g_pkg_name
565: ,p_exc_name => 'OTHERS'
566: ,x_msg_count => x_msg_count
567: ,x_msg_data => x_msg_data

Line 583: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

579: ,p_lrlv_rec IN okl_lrlv_rec) IS
580: l_lrlv_rec okl_lrlv_rec;
581: l_api_name CONSTANT varchar2(30) := 'rmv_lrs_level';
582: l_api_version CONSTANT number := 1.0;
583: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
584: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_factors_pvt.remove_lrs_level';
585: l_debug_enabled varchar2(10);
586: is_debug_procedure_on boolean;
587: is_debug_statement_on boolean;

Line 608: l_return_status := okl_api.start_activity(p_api_name => l_api_name

604:
605: -- call START_ACTIVITY to create savepoint, check compatibility
606: -- and initialize message list
607:
608: l_return_status := okl_api.start_activity(p_api_name => l_api_name
609: ,p_pkg_name => g_pkg_name
610: ,p_init_msg_list => p_init_msg_list
611: ,l_api_version => l_api_version
612: ,p_api_version => p_api_version

Line 618: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

614: ,x_return_status => x_return_status);
615:
616: -- check if activity started successfully
617:
618: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
619: RAISE okl_api.g_exception_unexpected_error;
620: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
621: RAISE okl_api.g_exception_error;
622: END IF;

Line 619: RAISE okl_api.g_exception_unexpected_error;

615:
616: -- check if activity started successfully
617:
618: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
619: RAISE okl_api.g_exception_unexpected_error;
620: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
621: RAISE okl_api.g_exception_error;
622: END IF;
623: l_lrlv_rec := p_lrlv_rec;

Line 620: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

616: -- check if activity started successfully
617:
618: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
619: RAISE okl_api.g_exception_unexpected_error;
620: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
621: RAISE okl_api.g_exception_error;
622: END IF;
623: l_lrlv_rec := p_lrlv_rec;
624: okl_lrl_pvt.delete_row(p_api_version => p_api_version

Line 621: RAISE okl_api.g_exception_error;

617:
618: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
619: RAISE okl_api.g_exception_unexpected_error;
620: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
621: RAISE okl_api.g_exception_error;
622: END IF;
623: l_lrlv_rec := p_lrlv_rec;
624: okl_lrl_pvt.delete_row(p_api_version => p_api_version
625: ,p_init_msg_list => okl_api.g_false

Line 625: ,p_init_msg_list => okl_api.g_false

621: RAISE okl_api.g_exception_error;
622: END IF;
623: l_lrlv_rec := p_lrlv_rec;
624: okl_lrl_pvt.delete_row(p_api_version => p_api_version
625: ,p_init_msg_list => okl_api.g_false
626: ,x_return_status => l_return_status
627: ,x_msg_count => x_msg_count
628: ,x_msg_data => x_msg_data
629: ,p_lrlv_rec => l_lrlv_rec);

Line 632: RAISE okl_api.g_exception_error;

628: ,x_msg_data => x_msg_data
629: ,p_lrlv_rec => l_lrlv_rec);
630:
631: IF l_return_status = g_ret_sts_error THEN
632: RAISE okl_api.g_exception_error;
633: ELSIF l_return_status = g_ret_sts_unexp_error THEN
634: RAISE okl_api.g_exception_unexpected_error;
635: END IF;
636: x_return_status := l_return_status;

Line 634: RAISE okl_api.g_exception_unexpected_error;

630:
631: IF l_return_status = g_ret_sts_error THEN
632: RAISE okl_api.g_exception_error;
633: ELSIF l_return_status = g_ret_sts_unexp_error THEN
634: RAISE okl_api.g_exception_unexpected_error;
635: END IF;
636: x_return_status := l_return_status;
637: okl_api.end_activity(x_msg_count => x_msg_count
638: ,x_msg_data => x_msg_data);

Line 637: okl_api.end_activity(x_msg_count => x_msg_count

633: ELSIF l_return_status = g_ret_sts_unexp_error THEN
634: RAISE okl_api.g_exception_unexpected_error;
635: END IF;
636: x_return_status := l_return_status;
637: okl_api.end_activity(x_msg_count => x_msg_count
638: ,x_msg_data => x_msg_data);
639:
640: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
641: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 647: WHEN okl_api.g_exception_error THEN

643: ,'end debug OKLRECVB.pls.pls call remove_lrs_level');
644: END IF;
645:
646: EXCEPTION
647: WHEN okl_api.g_exception_error THEN
648: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
649: ,p_pkg_name => g_pkg_name
650: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
651: ,x_msg_count => x_msg_count

Line 648: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

644: END IF;
645:
646: EXCEPTION
647: WHEN okl_api.g_exception_error THEN
648: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
649: ,p_pkg_name => g_pkg_name
650: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
651: ,x_msg_count => x_msg_count
652: ,x_msg_data => x_msg_data

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

646: EXCEPTION
647: WHEN okl_api.g_exception_error THEN
648: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
649: ,p_pkg_name => g_pkg_name
650: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
651: ,x_msg_count => x_msg_count
652: ,x_msg_data => x_msg_data
653: ,p_api_type => g_api_type);
654: WHEN okl_api.g_exception_unexpected_error THEN

Line 654: WHEN okl_api.g_exception_unexpected_error THEN

650: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
651: ,x_msg_count => x_msg_count
652: ,x_msg_data => x_msg_data
653: ,p_api_type => g_api_type);
654: WHEN okl_api.g_exception_unexpected_error THEN
655: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
656: ,p_pkg_name => g_pkg_name
657: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
658: ,x_msg_count => x_msg_count

Line 655: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

651: ,x_msg_count => x_msg_count
652: ,x_msg_data => x_msg_data
653: ,p_api_type => g_api_type);
654: WHEN okl_api.g_exception_unexpected_error THEN
655: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
656: ,p_pkg_name => g_pkg_name
657: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
658: ,x_msg_count => x_msg_count
659: ,x_msg_data => x_msg_data

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

653: ,p_api_type => g_api_type);
654: WHEN okl_api.g_exception_unexpected_error THEN
655: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
656: ,p_pkg_name => g_pkg_name
657: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
658: ,x_msg_count => x_msg_count
659: ,x_msg_data => x_msg_data
660: ,p_api_type => g_api_type);
661: WHEN OTHERS THEN

Line 662: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

658: ,x_msg_count => x_msg_count
659: ,x_msg_data => x_msg_data
660: ,p_api_type => g_api_type);
661: WHEN OTHERS THEN
662: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
663: ,p_pkg_name => g_pkg_name
664: ,p_exc_name => 'OTHERS'
665: ,x_msg_count => x_msg_count
666: ,x_msg_data => x_msg_data

Line 707: okl_api.set_message(p_app_name => g_app_name

703:
704: --at least 1 rate factor should be present
705:
706: IF p_lrfv_tbl.COUNT = 0 THEN
707: okl_api.set_message(p_app_name => g_app_name
708: ,p_msg_name => 'OKL_RATE_FACTOR_NOT_PRESENT');
709: RETURN okl_api.g_ret_sts_error;
710: END IF;
711:

Line 709: RETURN okl_api.g_ret_sts_error;

705:
706: IF p_lrfv_tbl.COUNT = 0 THEN
707: okl_api.set_message(p_app_name => g_app_name
708: ,p_msg_name => 'OKL_RATE_FACTOR_NOT_PRESENT');
709: RETURN okl_api.g_ret_sts_error;
710: END IF;
711:
712: SELECT decode(p_freq, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)
713: INTO l_freq

Line 721: okl_api.set_message(p_app_name => g_app_name

717:
718: --term should be exact multiple of frequency
719:
720: IF p_lrfv_tbl(i).term_in_months MOD l_freq <> 0 THEN
721: okl_api.set_message(p_app_name => g_app_name
722: ,p_msg_name => 'OKL_TERM_NOT_MULT_OF_FREQ'
723: ,p_token1 => 'TERM'
724: ,p_token1_value => p_lrfv_tbl(i).term_in_months);
725: RETURN okl_api.g_ret_sts_error;

Line 725: RETURN okl_api.g_ret_sts_error;

721: okl_api.set_message(p_app_name => g_app_name
722: ,p_msg_name => 'OKL_TERM_NOT_MULT_OF_FREQ'
723: ,p_token1 => 'TERM'
724: ,p_token1_value => p_lrfv_tbl(i).term_in_months);
725: RETURN okl_api.g_ret_sts_error;
726: END IF;
727: l_payments := p_lrfv_tbl(i).term_in_months / l_freq;
728: l_periods := 0;
729:

Line 733: okl_api.set_message(p_app_name => g_app_name

729:
730: --at least 1 rate factor leval should be present
731:
732: IF p_lrlv_tbl.COUNT = 0 THEN
733: okl_api.set_message(p_app_name => g_app_name
734: ,p_msg_name => 'OKL_LEVEL_NOT_PRESENT'
735: ,p_token1 => 'TERM'
736: ,p_token1_value => p_lrfv_tbl(i).term_in_months);
737: RETURN okl_api.g_ret_sts_error;

Line 737: RETURN okl_api.g_ret_sts_error;

733: okl_api.set_message(p_app_name => g_app_name
734: ,p_msg_name => 'OKL_LEVEL_NOT_PRESENT'
735: ,p_token1 => 'TERM'
736: ,p_token1_value => p_lrfv_tbl(i).term_in_months);
737: RETURN okl_api.g_ret_sts_error;
738: END IF; --sum of periods of all levels(of the factor) should be equal to total payments for the term
739:
740: FOR j IN p_lrlv_tbl.FIRST..p_lrlv_tbl.LAST LOOP
741:

Line 749: okl_api.set_message(p_app_name => g_app_name

745:
746: END LOOP;
747:
748: IF l_payments <> l_periods THEN
749: okl_api.set_message(p_app_name => g_app_name
750: ,p_msg_name => 'OKL_PERIODS_NOT_EQ_PAYMENTS'
751: ,p_token1 => 'TERM'
752: ,p_token1_value => p_lrfv_tbl(i).term_in_months);
753: RETURN okl_api.g_ret_sts_error;

Line 753: RETURN okl_api.g_ret_sts_error;

749: okl_api.set_message(p_app_name => g_app_name
750: ,p_msg_name => 'OKL_PERIODS_NOT_EQ_PAYMENTS'
751: ,p_token1 => 'TERM'
752: ,p_token1_value => p_lrfv_tbl(i).term_in_months);
753: RETURN okl_api.g_ret_sts_error;
754: END IF;
755:
756: END LOOP;
757:

Line 763: RETURN okl_api.g_ret_sts_success;

759: okl_debug_pub.log_debug(fnd_log.level_procedure
760: ,l_module
761: ,'end debug OKLRECVB.pls.pls call validate_factor_levels');
762: END IF;
763: RETURN okl_api.g_ret_sts_success;
764: END validate_factor_levels;
765: /**
766: This function validates whether the residual tolerance is less than or equal
767: to the minimum of the difference between the residual values.

Line 954: okl_api.set_message(p_app_name => okl_api.g_app_name

950: FOR i IN p_lrfv_tbl.FIRST..p_lrfv_tbl.LAST - 1 LOOP
951: FOR j IN i + 1..p_lrfv_tbl.LAST LOOP
952: IF p_lrfv_tbl(i).term_in_months = p_lrfv_tbl(j).term_in_months
953: AND p_lrfv_tbl(i).residual_value_percent = p_lrfv_tbl(j).residual_value_percent THEN
954: okl_api.set_message(p_app_name => okl_api.g_app_name
955: ,p_msg_name => 'OKL_DUPLICATE_TERM_VALUE'
956: ,p_token1 => 'TERM'
957: ,p_token1_value => p_lrfv_tbl(i).term_in_months
958: ,p_token2 => 'VALUE'

Line 960: RETURN okl_api.g_ret_sts_error;

956: ,p_token1 => 'TERM'
957: ,p_token1_value => p_lrfv_tbl(i).term_in_months
958: ,p_token2 => 'VALUE'
959: ,p_token2_value => p_lrfv_tbl(i).residual_value_percent);
960: RETURN okl_api.g_ret_sts_error;
961: END IF;
962: END LOOP;
963: END LOOP;
964:

Line 972: RETURN okl_api.g_ret_sts_success;

968: okl_debug_pub.log_debug(fnd_log.level_procedure
969: ,l_module
970: ,'end debug OKLRECVB.pls.pls call validate_unique_term_values');
971: END IF;
972: RETURN okl_api.g_ret_sts_success;
973: END validate_unique_term_values;
974: /**
975: This procedure deletes the existing lease rate factors for a lease rate set
976: version.

Line 980: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

976: version.
977: **/
978:
979: PROCEDURE handle_lease_rate_factors(p_api_version IN number
980: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
981: ,x_return_status OUT NOCOPY varchar2
982: ,x_msg_count OUT NOCOPY number
983: ,x_msg_data OUT NOCOPY varchar2
984: ,p_lrtv_rec IN lrtv_rec_type

Line 997: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

993: lp_lrfv_tbl lrfv_tbl_type;
994: l_rate number;
995: l_api_name CONSTANT varchar2(30) := 'handle_lrf';
996: l_api_version CONSTANT number := 1.0;
997: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
998: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_factors_pvt.handle_lease_rate_factors';
999: l_debug_enabled varchar2(10);
1000: is_debug_procedure_on boolean;
1001: is_debug_statement_on boolean;

Line 1022: l_return_status := okl_api.start_activity(p_api_name => l_api_name

1018:
1019: -- call START_ACTIVITY to create savepoint, check compatibility
1020: -- and initialize message list
1021:
1022: l_return_status := okl_api.start_activity(p_api_name => l_api_name
1023: ,p_pkg_name => g_pkg_name
1024: ,p_init_msg_list => p_init_msg_list
1025: ,l_api_version => l_api_version
1026: ,p_api_version => p_api_version

Line 1032: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1028: ,x_return_status => x_return_status);
1029:
1030: -- check if activity started successfully
1031:
1032: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1033: RAISE okl_api.g_exception_unexpected_error;
1034: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1035: RAISE okl_api.g_exception_error;
1036: END IF;

Line 1033: RAISE okl_api.g_exception_unexpected_error;

1029:
1030: -- check if activity started successfully
1031:
1032: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1033: RAISE okl_api.g_exception_unexpected_error;
1034: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1035: RAISE okl_api.g_exception_error;
1036: END IF;
1037: lp_lrvv_rec := p_lrvv_rec;

Line 1034: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1030: -- check if activity started successfully
1031:
1032: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1033: RAISE okl_api.g_exception_unexpected_error;
1034: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1035: RAISE okl_api.g_exception_error;
1036: END IF;
1037: lp_lrvv_rec := p_lrvv_rec;
1038: lp_lrtv_rec := p_lrtv_rec;

Line 1035: RAISE okl_api.g_exception_error;

1031:
1032: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1033: RAISE okl_api.g_exception_unexpected_error;
1034: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1035: RAISE okl_api.g_exception_error;
1036: END IF;
1037: lp_lrvv_rec := p_lrvv_rec;
1038: lp_lrtv_rec := p_lrtv_rec;
1039: lp_lrfv_tbl := p_lrfv_tbl;

Line 1044: IF lp_lrvv_rec.lrs_rate IS NULL OR lp_lrvv_rec.lrs_rate = okl_api.g_miss_num THEN

1040: lp_lrlv_tbl := p_lrlv_tbl;
1041:
1042: --derive the rate from srt if no rate is present on lrs
1043:
1044: IF lp_lrvv_rec.lrs_rate IS NULL OR lp_lrvv_rec.lrs_rate = okl_api.g_miss_num THEN
1045: l_rate := get_rate_from_srt(lp_lrvv_rec.std_rate_tmpl_ver_id
1046: ,lp_lrvv_rec.effective_from_date);
1047: ELSE
1048: l_rate := lp_lrvv_rec.lrs_rate;

Line 1052: okl_api.set_message(p_app_name => okl_api.g_app_name

1048: l_rate := lp_lrvv_rec.lrs_rate;
1049: END IF;
1050:
1051: IF l_rate IS NULL THEN
1052: okl_api.set_message(p_app_name => okl_api.g_app_name
1053: ,p_msg_name => 'OKL_RATE_UNDETERMINED_FOR_LRS');
1054: RAISE okl_api.g_exception_error;
1055: END IF;
1056:

Line 1054: RAISE okl_api.g_exception_error;

1050:
1051: IF l_rate IS NULL THEN
1052: okl_api.set_message(p_app_name => okl_api.g_app_name
1053: ,p_msg_name => 'OKL_RATE_UNDETERMINED_FOR_LRS');
1054: RAISE okl_api.g_exception_error;
1055: END IF;
1056:
1057: --validate that no duplicate term value pairs are present
1058:

Line 1061: IF l_return_status = okl_api.g_ret_sts_error THEN

1057: --validate that no duplicate term value pairs are present
1058:
1059: l_return_status := validate_unique_term_values(lp_lrfv_tbl);
1060:
1061: IF l_return_status = okl_api.g_ret_sts_error THEN
1062: RAISE okl_api.g_exception_error;
1063: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
1064: RAISE okl_api.g_exception_unexpected_error;
1065: END IF;

Line 1062: RAISE okl_api.g_exception_error;

1058:
1059: l_return_status := validate_unique_term_values(lp_lrfv_tbl);
1060:
1061: IF l_return_status = okl_api.g_ret_sts_error THEN
1062: RAISE okl_api.g_exception_error;
1063: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
1064: RAISE okl_api.g_exception_unexpected_error;
1065: END IF;
1066:

Line 1063: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN

1059: l_return_status := validate_unique_term_values(lp_lrfv_tbl);
1060:
1061: IF l_return_status = okl_api.g_ret_sts_error THEN
1062: RAISE okl_api.g_exception_error;
1063: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
1064: RAISE okl_api.g_exception_unexpected_error;
1065: END IF;
1066:
1067: --validate the rate factors and levels

Line 1064: RAISE okl_api.g_exception_unexpected_error;

1060:
1061: IF l_return_status = okl_api.g_ret_sts_error THEN
1062: RAISE okl_api.g_exception_error;
1063: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
1064: RAISE okl_api.g_exception_unexpected_error;
1065: END IF;
1066:
1067: --validate the rate factors and levels
1068:

Line 1083: RAISE okl_api.g_exception_error;

1079: l_return_status);
1080: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1081:
1082: IF l_return_status = g_ret_sts_error THEN
1083: RAISE okl_api.g_exception_error;
1084: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1085: RAISE okl_api.g_exception_unexpected_error;
1086: END IF;
1087:

Line 1085: RAISE okl_api.g_exception_unexpected_error;

1081:
1082: IF l_return_status = g_ret_sts_error THEN
1083: RAISE okl_api.g_exception_error;
1084: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1085: RAISE okl_api.g_exception_unexpected_error;
1086: END IF;
1087:
1088: --validate the residual tolerance
1089: --residual tolerance should not be greater than (min of difference between pairs of residual values)

Line 1090: IF lp_lrvv_rec.residual_tolerance = okl_api.g_miss_num THEN

1086: END IF;
1087:
1088: --validate the residual tolerance
1089: --residual tolerance should not be greater than (min of difference between pairs of residual values)
1090: IF lp_lrvv_rec.residual_tolerance = okl_api.g_miss_num THEN
1091: lp_lrvv_rec.residual_tolerance := 0;
1092: END IF;
1093: IF NOT is_residual_tolerance_valid(lp_lrfv_tbl
1094: ,nvl(lp_lrvv_rec.residual_tolerance

Line 1096: okl_api.set_message(p_app_name => okl_api.g_app_name

1092: END IF;
1093: IF NOT is_residual_tolerance_valid(lp_lrfv_tbl
1094: ,nvl(lp_lrvv_rec.residual_tolerance
1095: ,0)) THEN
1096: okl_api.set_message(p_app_name => okl_api.g_app_name
1097: ,p_msg_name => 'OKL_INVALID_RESIDUAL_TOLERANCE');
1098: RAISE okl_api.g_exception_error;
1099: END IF;
1100:

Line 1098: RAISE okl_api.g_exception_error;

1094: ,nvl(lp_lrvv_rec.residual_tolerance
1095: ,0)) THEN
1096: okl_api.set_message(p_app_name => okl_api.g_app_name
1097: ,p_msg_name => 'OKL_INVALID_RESIDUAL_TOLERANCE');
1098: RAISE okl_api.g_exception_error;
1099: END IF;
1100:
1101: --set the foreign key values and interest rate
1102:

Line 1121: ,p_init_msg_list => okl_api.g_false

1117: --we need to delete as eot version might have changed so existing lrfs, term value pairs are not valid.
1118: --also user has changed the existing lrf values
1119:
1120: delete_lease_rate_factors(p_api_version => p_api_version
1121: ,p_init_msg_list => okl_api.g_false
1122: ,x_return_status => l_return_status
1123: ,x_msg_count => x_msg_count
1124: ,x_msg_data => x_msg_data
1125: ,p_lrv_id => lp_lrvv_rec.rate_set_version_id);

Line 1137: RAISE okl_api.g_exception_error;

1133: l_return_status);
1134: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1135:
1136: IF l_return_status = g_ret_sts_error THEN
1137: RAISE okl_api.g_exception_error;
1138: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1139: RAISE okl_api.g_exception_unexpected_error;
1140: END IF;
1141:

Line 1139: RAISE okl_api.g_exception_unexpected_error;

1135:
1136: IF l_return_status = g_ret_sts_error THEN
1137: RAISE okl_api.g_exception_error;
1138: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1139: RAISE okl_api.g_exception_unexpected_error;
1140: END IF;
1141:
1142: --call handlelrf API to insert levels and factors
1143:

Line 1146: ,p_init_msg_list => okl_api.g_false

1142: --call handlelrf API to insert levels and factors
1143:
1144: IF lp_lrfv_tbl.COUNT > 0 THEN
1145: handle_lrf_ents(p_api_version => p_api_version
1146: ,p_init_msg_list => okl_api.g_false
1147: ,x_return_status => l_return_status
1148: ,x_msg_count => x_msg_count
1149: ,x_msg_data => x_msg_data
1150: ,p_lrfv_tbl => lp_lrfv_tbl

Line 1164: RAISE okl_api.g_exception_error;

1160: ,'Procedure handle_lrf_ents with status ' ||
1161: l_return_status);
1162: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1163: IF l_return_status = g_ret_sts_error THEN
1164: RAISE okl_api.g_exception_error;
1165: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1166: RAISE okl_api.g_exception_unexpected_error;
1167: END IF;
1168: END IF;

Line 1166: RAISE okl_api.g_exception_unexpected_error;

1162: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1163: IF l_return_status = g_ret_sts_error THEN
1164: RAISE okl_api.g_exception_error;
1165: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1166: RAISE okl_api.g_exception_unexpected_error;
1167: END IF;
1168: END IF;
1169: x_return_status := l_return_status;
1170: okl_api.end_activity(x_msg_count => x_msg_count

Line 1170: okl_api.end_activity(x_msg_count => x_msg_count

1166: RAISE okl_api.g_exception_unexpected_error;
1167: END IF;
1168: END IF;
1169: x_return_status := l_return_status;
1170: okl_api.end_activity(x_msg_count => x_msg_count
1171: ,x_msg_data => x_msg_data);
1172:
1173: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1174: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1180: WHEN okl_api.g_exception_error THEN

1176: ,'end debug OKLRECVB.pls.pls call handle_lease_rate_factors');
1177: END IF;
1178:
1179: EXCEPTION
1180: WHEN okl_api.g_exception_error THEN
1181: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1182: ,p_pkg_name => g_pkg_name
1183: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1184: ,x_msg_count => x_msg_count

Line 1181: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

1177: END IF;
1178:
1179: EXCEPTION
1180: WHEN okl_api.g_exception_error THEN
1181: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1182: ,p_pkg_name => g_pkg_name
1183: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1184: ,x_msg_count => x_msg_count
1185: ,x_msg_data => x_msg_data

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

1179: EXCEPTION
1180: WHEN okl_api.g_exception_error THEN
1181: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1182: ,p_pkg_name => g_pkg_name
1183: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1184: ,x_msg_count => x_msg_count
1185: ,x_msg_data => x_msg_data
1186: ,p_api_type => g_api_type);
1187: WHEN okl_api.g_exception_unexpected_error THEN

Line 1187: WHEN okl_api.g_exception_unexpected_error THEN

1183: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1184: ,x_msg_count => x_msg_count
1185: ,x_msg_data => x_msg_data
1186: ,p_api_type => g_api_type);
1187: WHEN okl_api.g_exception_unexpected_error THEN
1188: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1189: ,p_pkg_name => g_pkg_name
1190: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1191: ,x_msg_count => x_msg_count

Line 1188: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

1184: ,x_msg_count => x_msg_count
1185: ,x_msg_data => x_msg_data
1186: ,p_api_type => g_api_type);
1187: WHEN okl_api.g_exception_unexpected_error THEN
1188: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1189: ,p_pkg_name => g_pkg_name
1190: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1191: ,x_msg_count => x_msg_count
1192: ,x_msg_data => x_msg_data

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

1186: ,p_api_type => g_api_type);
1187: WHEN okl_api.g_exception_unexpected_error THEN
1188: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1189: ,p_pkg_name => g_pkg_name
1190: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1191: ,x_msg_count => x_msg_count
1192: ,x_msg_data => x_msg_data
1193: ,p_api_type => g_api_type);
1194: WHEN OTHERS THEN

Line 1195: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

1191: ,x_msg_count => x_msg_count
1192: ,x_msg_data => x_msg_data
1193: ,p_api_type => g_api_type);
1194: WHEN OTHERS THEN
1195: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1196: ,p_pkg_name => g_pkg_name
1197: ,p_exc_name => 'OTHERS'
1198: ,x_msg_count => x_msg_count
1199: ,x_msg_data => x_msg_data

Line 1208: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

1204: submit the lease rate set for approval.
1205: **/
1206:
1207: PROCEDURE handle_lrf_submit(p_api_version IN number
1208: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1209: ,x_return_status OUT NOCOPY varchar2
1210: ,x_msg_count OUT NOCOPY number
1211: ,x_msg_data OUT NOCOPY varchar2
1212: ,p_lrtv_rec IN lrtv_rec_type

Line 1225: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1221: lp_lrfv_tbl lrfv_tbl_type;
1222: l_rate number;
1223: l_api_name CONSTANT varchar2(30) := 'handle_lrf_submit';
1224: l_api_version CONSTANT number := 1.0;
1225: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1226: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_factors_pvt.handle_lrf_submit';
1227: l_debug_enabled varchar2(10);
1228: is_debug_procedure_on boolean;
1229: is_debug_statement_on boolean;

Line 1250: l_return_status := okl_api.start_activity(p_api_name => l_api_name

1246:
1247: -- call START_ACTIVITY to create savepoint, check compatibility
1248: -- and initialize message list
1249:
1250: l_return_status := okl_api.start_activity(p_api_name => l_api_name
1251: ,p_pkg_name => g_pkg_name
1252: ,p_init_msg_list => p_init_msg_list
1253: ,l_api_version => l_api_version
1254: ,p_api_version => p_api_version

Line 1260: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1256: ,x_return_status => x_return_status);
1257:
1258: -- check if activity started successfully
1259:
1260: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1261: RAISE okl_api.g_exception_unexpected_error;
1262: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1263: RAISE okl_api.g_exception_error;
1264: END IF;

Line 1261: RAISE okl_api.g_exception_unexpected_error;

1257:
1258: -- check if activity started successfully
1259:
1260: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1261: RAISE okl_api.g_exception_unexpected_error;
1262: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1263: RAISE okl_api.g_exception_error;
1264: END IF;
1265: lp_lrvv_rec := p_lrvv_rec;

Line 1262: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1258: -- check if activity started successfully
1259:
1260: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1261: RAISE okl_api.g_exception_unexpected_error;
1262: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1263: RAISE okl_api.g_exception_error;
1264: END IF;
1265: lp_lrvv_rec := p_lrvv_rec;
1266: lp_lrtv_rec := p_lrtv_rec;

Line 1263: RAISE okl_api.g_exception_error;

1259:
1260: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1261: RAISE okl_api.g_exception_unexpected_error;
1262: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1263: RAISE okl_api.g_exception_error;
1264: END IF;
1265: lp_lrvv_rec := p_lrvv_rec;
1266: lp_lrtv_rec := p_lrtv_rec;
1267: lp_lrfv_tbl := p_lrfv_tbl;

Line 1272: IF lp_lrvv_rec.lrs_rate IS NULL OR lp_lrvv_rec.lrs_rate = okl_api.g_miss_num THEN

1268: lp_lrlv_tbl := p_lrlv_tbl;
1269:
1270: --derive the rate from srt if no rate is present on lrs
1271:
1272: IF lp_lrvv_rec.lrs_rate IS NULL OR lp_lrvv_rec.lrs_rate = okl_api.g_miss_num THEN
1273: l_rate := get_rate_from_srt(lp_lrvv_rec.std_rate_tmpl_ver_id
1274: ,lp_lrvv_rec.effective_from_date);
1275: ELSE
1276: l_rate := lp_lrvv_rec.lrs_rate;

Line 1280: okl_api.set_message(p_app_name => okl_api.g_app_name

1276: l_rate := lp_lrvv_rec.lrs_rate;
1277: END IF;
1278:
1279: IF l_rate IS NULL THEN
1280: okl_api.set_message(p_app_name => okl_api.g_app_name
1281: ,p_msg_name => 'OKL_RATE_UNDETERMINED_FOR_LRS');
1282: RAISE okl_api.g_exception_error;
1283: END IF;
1284:

Line 1282: RAISE okl_api.g_exception_error;

1278:
1279: IF l_rate IS NULL THEN
1280: okl_api.set_message(p_app_name => okl_api.g_app_name
1281: ,p_msg_name => 'OKL_RATE_UNDETERMINED_FOR_LRS');
1282: RAISE okl_api.g_exception_error;
1283: END IF;
1284:
1285: --validate that no duplicate term value pairs are present
1286:

Line 1289: IF l_return_status = okl_api.g_ret_sts_error THEN

1285: --validate that no duplicate term value pairs are present
1286:
1287: l_return_status := validate_unique_term_values(lp_lrfv_tbl);
1288:
1289: IF l_return_status = okl_api.g_ret_sts_error THEN
1290: RAISE okl_api.g_exception_error;
1291: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
1292: RAISE okl_api.g_exception_unexpected_error;
1293: END IF;

Line 1290: RAISE okl_api.g_exception_error;

1286:
1287: l_return_status := validate_unique_term_values(lp_lrfv_tbl);
1288:
1289: IF l_return_status = okl_api.g_ret_sts_error THEN
1290: RAISE okl_api.g_exception_error;
1291: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
1292: RAISE okl_api.g_exception_unexpected_error;
1293: END IF;
1294:

Line 1291: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN

1287: l_return_status := validate_unique_term_values(lp_lrfv_tbl);
1288:
1289: IF l_return_status = okl_api.g_ret_sts_error THEN
1290: RAISE okl_api.g_exception_error;
1291: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
1292: RAISE okl_api.g_exception_unexpected_error;
1293: END IF;
1294:
1295: --validate the rate factors and levels

Line 1292: RAISE okl_api.g_exception_unexpected_error;

1288:
1289: IF l_return_status = okl_api.g_ret_sts_error THEN
1290: RAISE okl_api.g_exception_error;
1291: ELSIF l_return_status = okl_api.g_ret_sts_unexp_error THEN
1292: RAISE okl_api.g_exception_unexpected_error;
1293: END IF;
1294:
1295: --validate the rate factors and levels
1296:

Line 1302: RAISE okl_api.g_exception_error;

1298: ,p_lrlv_tbl => lp_lrlv_tbl
1299: ,p_freq => lp_lrtv_rec.frq_code);
1300:
1301: IF l_return_status = g_ret_sts_error THEN
1302: RAISE okl_api.g_exception_error;
1303: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1304: RAISE okl_api.g_exception_unexpected_error;
1305: END IF;
1306:

Line 1304: RAISE okl_api.g_exception_unexpected_error;

1300:
1301: IF l_return_status = g_ret_sts_error THEN
1302: RAISE okl_api.g_exception_error;
1303: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1304: RAISE okl_api.g_exception_unexpected_error;
1305: END IF;
1306:
1307: --validate the residual tolerance
1308: --residual tolerance should not be greater than (min of difference between pairs of residual values)

Line 1309: IF lp_lrvv_rec.residual_tolerance = okl_api.g_miss_num THEN

1305: END IF;
1306:
1307: --validate the residual tolerance
1308: --residual tolerance should not be greater than (min of difference between pairs of residual values)
1309: IF lp_lrvv_rec.residual_tolerance = okl_api.g_miss_num THEN
1310: lp_lrvv_rec.residual_tolerance := 0;
1311: END IF;
1312: IF NOT is_residual_tolerance_valid(lp_lrfv_tbl
1313: ,nvl(lp_lrvv_rec.residual_tolerance

Line 1315: okl_api.set_message(p_app_name => okl_api.g_app_name

1311: END IF;
1312: IF NOT is_residual_tolerance_valid(lp_lrfv_tbl
1313: ,nvl(lp_lrvv_rec.residual_tolerance
1314: ,0)) THEN
1315: okl_api.set_message(p_app_name => okl_api.g_app_name
1316: ,p_msg_name => 'OKL_INVALID_RESIDUAL_TOLERANCE');
1317: RAISE okl_api.g_exception_error;
1318: END IF;
1319:

Line 1317: RAISE okl_api.g_exception_error;

1313: ,nvl(lp_lrvv_rec.residual_tolerance
1314: ,0)) THEN
1315: okl_api.set_message(p_app_name => okl_api.g_app_name
1316: ,p_msg_name => 'OKL_INVALID_RESIDUAL_TOLERANCE');
1317: RAISE okl_api.g_exception_error;
1318: END IF;
1319:
1320: --set the foreign key values and interest rate
1321:

Line 1340: ,p_init_msg_list => okl_api.g_false

1336: --we need to delete as eot version might have changed so existing lrfs, term value pairs are not valid.
1337: --also user has changed the existing lrf values
1338:
1339: delete_lease_rate_factors(p_api_version => p_api_version
1340: ,p_init_msg_list => okl_api.g_false
1341: ,x_return_status => l_return_status
1342: ,x_msg_count => x_msg_count
1343: ,x_msg_data => x_msg_data
1344: ,p_lrv_id => lp_lrvv_rec.rate_set_version_id);

Line 1347: RAISE okl_api.g_exception_error;

1343: ,x_msg_data => x_msg_data
1344: ,p_lrv_id => lp_lrvv_rec.rate_set_version_id);
1345:
1346: IF l_return_status = g_ret_sts_error THEN
1347: RAISE okl_api.g_exception_error;
1348: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1349: RAISE okl_api.g_exception_unexpected_error;
1350: END IF;
1351:

Line 1349: RAISE okl_api.g_exception_unexpected_error;

1345:
1346: IF l_return_status = g_ret_sts_error THEN
1347: RAISE okl_api.g_exception_error;
1348: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1349: RAISE okl_api.g_exception_unexpected_error;
1350: END IF;
1351:
1352: --call handlelrf API to insert levels and factors
1353:

Line 1356: ,p_init_msg_list => okl_api.g_false

1352: --call handlelrf API to insert levels and factors
1353:
1354: IF lp_lrfv_tbl.COUNT > 0 THEN
1355: handle_lrf_ents(p_api_version => p_api_version
1356: ,p_init_msg_list => okl_api.g_false
1357: ,x_return_status => l_return_status
1358: ,x_msg_count => x_msg_count
1359: ,x_msg_data => x_msg_data
1360: ,p_lrfv_tbl => lp_lrfv_tbl

Line 1365: RAISE okl_api.g_exception_error;

1361: ,x_lrfv_tbl => x_lrfv_tbl
1362: ,p_lrlv_tbl => lp_lrlv_tbl
1363: ,x_lrlv_tbl => x_lrlv_tbl);
1364: IF l_return_status = g_ret_sts_error THEN
1365: RAISE okl_api.g_exception_error;
1366: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1367: RAISE okl_api.g_exception_unexpected_error;
1368: END IF;
1369: END IF;

Line 1367: RAISE okl_api.g_exception_unexpected_error;

1363: ,x_lrlv_tbl => x_lrlv_tbl);
1364: IF l_return_status = g_ret_sts_error THEN
1365: RAISE okl_api.g_exception_error;
1366: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1367: RAISE okl_api.g_exception_unexpected_error;
1368: END IF;
1369: END IF;
1370:
1371: --submit the lrs

Line 1381: RAISE okl_api.g_exception_error;

1377: ,x_msg_data => x_msg_data
1378: ,p_rate_set_version_id => lp_lrvv_rec.rate_set_version_id);
1379:
1380: IF l_return_status = g_ret_sts_error THEN
1381: RAISE okl_api.g_exception_error;
1382: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1383: RAISE okl_api.g_exception_unexpected_error;
1384: END IF;
1385: x_return_status := l_return_status;

Line 1383: RAISE okl_api.g_exception_unexpected_error;

1379:
1380: IF l_return_status = g_ret_sts_error THEN
1381: RAISE okl_api.g_exception_error;
1382: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1383: RAISE okl_api.g_exception_unexpected_error;
1384: END IF;
1385: x_return_status := l_return_status;
1386: okl_api.end_activity(x_msg_count => x_msg_count
1387: ,x_msg_data => x_msg_data);

Line 1386: okl_api.end_activity(x_msg_count => x_msg_count

1382: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1383: RAISE okl_api.g_exception_unexpected_error;
1384: END IF;
1385: x_return_status := l_return_status;
1386: okl_api.end_activity(x_msg_count => x_msg_count
1387: ,x_msg_data => x_msg_data);
1388:
1389: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1390: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1396: WHEN okl_api.g_exception_error THEN

1392: ,'end debug OKLRECVB.pls.pls call handle_lrf_submit');
1393: END IF;
1394:
1395: EXCEPTION
1396: WHEN okl_api.g_exception_error THEN
1397: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1398: ,p_pkg_name => g_pkg_name
1399: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1400: ,x_msg_count => x_msg_count

Line 1397: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

1393: END IF;
1394:
1395: EXCEPTION
1396: WHEN okl_api.g_exception_error THEN
1397: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1398: ,p_pkg_name => g_pkg_name
1399: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1400: ,x_msg_count => x_msg_count
1401: ,x_msg_data => x_msg_data

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

1395: EXCEPTION
1396: WHEN okl_api.g_exception_error THEN
1397: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1398: ,p_pkg_name => g_pkg_name
1399: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1400: ,x_msg_count => x_msg_count
1401: ,x_msg_data => x_msg_data
1402: ,p_api_type => g_api_type);
1403: WHEN okl_api.g_exception_unexpected_error THEN

Line 1403: WHEN okl_api.g_exception_unexpected_error THEN

1399: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
1400: ,x_msg_count => x_msg_count
1401: ,x_msg_data => x_msg_data
1402: ,p_api_type => g_api_type);
1403: WHEN okl_api.g_exception_unexpected_error THEN
1404: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1405: ,p_pkg_name => g_pkg_name
1406: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1407: ,x_msg_count => x_msg_count

Line 1404: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

1400: ,x_msg_count => x_msg_count
1401: ,x_msg_data => x_msg_data
1402: ,p_api_type => g_api_type);
1403: WHEN okl_api.g_exception_unexpected_error THEN
1404: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1405: ,p_pkg_name => g_pkg_name
1406: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1407: ,x_msg_count => x_msg_count
1408: ,x_msg_data => x_msg_data

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

1402: ,p_api_type => g_api_type);
1403: WHEN okl_api.g_exception_unexpected_error THEN
1404: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1405: ,p_pkg_name => g_pkg_name
1406: ,p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR'
1407: ,x_msg_count => x_msg_count
1408: ,x_msg_data => x_msg_data
1409: ,p_api_type => g_api_type);
1410: WHEN OTHERS THEN

Line 1411: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name

1407: ,x_msg_count => x_msg_count
1408: ,x_msg_data => x_msg_data
1409: ,p_api_type => g_api_type);
1410: WHEN OTHERS THEN
1411: x_return_status := okl_api.handle_exceptions(p_api_name => l_api_name
1412: ,p_pkg_name => g_pkg_name
1413: ,p_exc_name => 'OTHERS'
1414: ,x_msg_count => x_msg_count
1415: ,x_msg_data => x_msg_data