eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_RESTRUCTURE_RENTS_PVT dependencies on OKL_API

Line 19: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

15: -- End of comments
16:
17: PROCEDURE initiate_request(
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
20: p_quote_id IN OKL_TRX_QUOTES_B.ID%TYPE,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,

Line 73: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;

69: lx_req_stream_types_tbl csm_stream_types_tbl_type;
70: lx_csm_line_details_tbl csm_line_details_tbl_type;
71: lx_rents_tbl csm_periodic_expenses_tbl_type;
72:
73: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;
74:
75: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
76: l_api_name CONSTANT VARCHAR2(30):= 'initiate_request';
77: l_api_version CONSTANT NUMBER := 1;

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

71: lx_rents_tbl csm_periodic_expenses_tbl_type;
72:
73: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;
74:
75: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
76: l_api_name CONSTANT VARCHAR2(30):= 'initiate_request';
77: l_api_version CONSTANT NUMBER := 1;
78: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
79:

Line 78: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

74:
75: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
76: l_api_name CONSTANT VARCHAR2(30):= 'initiate_request';
77: l_api_version CONSTANT NUMBER := 1;
78: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
79:
80: l_chr_id NUMBER;
81: l_ind NUMBER := 0;
82: l_advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE;

Line 98: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

94:
95:
96: BEGIN
97: --Check API version, initialize message list and create savepoint.
98: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
99: G_PKG_NAME,
100: p_init_msg_list,
101: l_api_version,
102: p_api_version,

Line 106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

102: p_api_version,
103: '_PVT',
104: x_return_status);
105:
106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
109: RAISE OKL_API.G_EXCEPTION_ERROR;
110: END IF;

Line 107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

103: '_PVT',
104: x_return_status);
105:
106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
109: RAISE OKL_API.G_EXCEPTION_ERROR;
110: END IF;
111:

Line 108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

104: x_return_status);
105:
106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
109: RAISE OKL_API.G_EXCEPTION_ERROR;
110: END IF;
111:
112: OPEN l_qtev_csr (p_quote_id);

Line 109: RAISE OKL_API.G_EXCEPTION_ERROR;

105:
106: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
108: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
109: RAISE OKL_API.G_EXCEPTION_ERROR;
110: END IF;
111:
112: OPEN l_qtev_csr (p_quote_id);
113: FETCH l_qtev_csr INTO l_qtev_rec;

Line 121: RAISE OKL_API.G_EXCEPTION_ERROR;

117: p_app_name => 'OKC'
118: ,p_msg_name => G_INVALID_VALUE
119: ,p_token1 => G_COL_NAME_TOKEN
120: ,p_token1_value => 'p_quote_id');
121: RAISE OKL_API.G_EXCEPTION_ERROR;
122: END IF;
123:
124: CLOSE l_qtev_csr;
125:

Line 145: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

141: x_req_stream_types_tbl => lx_req_stream_types_tbl,
142: x_csm_line_details_tbl => lx_csm_line_details_tbl,
143: x_rents_tbl => lx_rents_tbl);
144:
145: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: END IF;

Line 146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

142: x_csm_line_details_tbl => lx_csm_line_details_tbl,
143: x_rents_tbl => lx_rents_tbl);
144:
145: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: END IF;
150:

Line 147: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

143: x_rents_tbl => lx_rents_tbl);
144:
145: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: END IF;
150:
151: -- Set the restructure values

Line 148: RAISE OKL_API.G_EXCEPTION_ERROR;

144:
145: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: END IF;
150:
151: -- Set the restructure values
152: lx_csm_lease_header.jtot_object1_code := 'OKL_TRX_QUOTES_B';

Line 220: OKL_API.SET_MESSAGE (

216:
217: IF l_next_billing_date IS NULL THEN
218:
219: IF l_last_billing_date IS NULL THEN
220: OKL_API.SET_MESSAGE (
221: p_app_name => G_APP_NAME
222: ,p_msg_name => 'OKL_LLA_NO_STREAM_ELEMENT');
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: ELSE

Line 223: RAISE OKL_API.G_EXCEPTION_ERROR;

219: IF l_last_billing_date IS NULL THEN
220: OKL_API.SET_MESSAGE (
221: p_app_name => G_APP_NAME
222: ,p_msg_name => 'OKL_LLA_NO_STREAM_ELEMENT');
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: ELSE
225:
226: IF l_period = 'A' THEN
227: l_add_months := 12;

Line 263: RAISE OKL_API.G_EXCEPTION_ERROR;

259: lx_rents_tbl(l_ind).amount := 0;
260: lx_rents_tbl(l_ind).number_of_periods := l_new_periods;
261:
262: ELSE
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
265: ELSE
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;

Line 266: RAISE OKL_API.G_EXCEPTION_ERROR;

262: ELSE
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
265: ELSE
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: -- Yields
270: FOR i IN lx_csm_yields_tbl.FIRST..lx_csm_yields_tbl.LAST LOOP

Line 282: AND l_qtev_rec.purchase_amount <> OKL_API.G_MISS_NUM THEN

278:
279: lx_csm_line_details_tbl(i).purchase_option := l_qtev_rec.pop_code_end;
280:
281: IF l_qtev_rec.purchase_amount IS NOT NULL
282: AND l_qtev_rec.purchase_amount <> OKL_API.G_MISS_NUM THEN
283: lx_csm_line_details_tbl(i).purchase_option_amount := l_qtev_rec.purchase_amount;
284:
285: ELSIF l_qtev_rec.purchase_formula IS NOT NULL
286: AND l_qtev_rec.purchase_formula <> OKL_API.G_MISS_CHAR THEN

Line 286: AND l_qtev_rec.purchase_formula <> OKL_API.G_MISS_CHAR THEN

282: AND l_qtev_rec.purchase_amount <> OKL_API.G_MISS_NUM THEN
283: lx_csm_line_details_tbl(i).purchase_option_amount := l_qtev_rec.purchase_amount;
284:
285: ELSIF l_qtev_rec.purchase_formula IS NOT NULL
286: AND l_qtev_rec.purchase_formula <> OKL_API.G_MISS_CHAR THEN
287:
288: okl_am_util_pvt.get_formula_value (
289: p_formula_name => l_qtev_rec.purchase_formula,
290: p_chr_id => l_chr_id,

Line 295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

291: p_cle_id => lx_csm_line_details_tbl(i).kle_asset_id,
292: x_formula_value => lx_csm_line_details_tbl(i).purchase_option_amount,
293: x_return_status => l_return_status);
294:
295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;

Line 296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

292: x_formula_value => lx_csm_line_details_tbl(i).purchase_option_amount,
293: x_return_status => l_return_status);
294:
295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:

Line 297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

293: x_return_status => l_return_status);
294:
295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:
301: ELSE

Line 298: RAISE OKL_API.G_EXCEPTION_ERROR;

294:
295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:
301: ELSE
302: lx_csm_line_details_tbl(i).purchase_option_amount := 0;

Line 325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

321: x_return_status => l_return_status,
322: x_msg_count => x_msg_count,
323: x_msg_data => x_msg_data);
324:
325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
328: RAISE OKL_API.G_EXCEPTION_ERROR;
329: END IF;

Line 326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

322: x_msg_count => x_msg_count,
323: x_msg_data => x_msg_data);
324:
325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
328: RAISE OKL_API.G_EXCEPTION_ERROR;
329: END IF;
330:

Line 327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

323: x_msg_data => x_msg_data);
324:
325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
328: RAISE OKL_API.G_EXCEPTION_ERROR;
329: END IF;
330:
331: -- end the transaction

Line 328: RAISE OKL_API.G_EXCEPTION_ERROR;

324:
325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
328: RAISE OKL_API.G_EXCEPTION_ERROR;
329: END IF;
330:
331: -- end the transaction
332: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 332: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

328: RAISE OKL_API.G_EXCEPTION_ERROR;
329: END IF;
330:
331: -- end the transaction
332: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
333:
334: EXCEPTION
335: WHEN OKL_API.G_EXCEPTION_ERROR THEN
336: IF (l_qtev_csr%ISOPEN) THEN

Line 335: WHEN OKL_API.G_EXCEPTION_ERROR THEN

331: -- end the transaction
332: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
333:
334: EXCEPTION
335: WHEN OKL_API.G_EXCEPTION_ERROR THEN
336: IF (l_qtev_csr%ISOPEN) THEN
337: CLOSE l_qtev_csr;
338: END IF;
339: IF (l_stream_csr%ISOPEN) THEN

Line 342: x_return_status := OKL_API.HANDLE_EXCEPTIONS

338: END IF;
339: IF (l_stream_csr%ISOPEN) THEN
340: CLOSE l_stream_csr;
341: END IF;
342: x_return_status := OKL_API.HANDLE_EXCEPTIONS
343: (
344: l_api_name,
345: G_PKG_NAME,
346: 'OKL_API.G_RET_STS_ERROR',

Line 346: 'OKL_API.G_RET_STS_ERROR',

342: x_return_status := OKL_API.HANDLE_EXCEPTIONS
343: (
344: l_api_name,
345: G_PKG_NAME,
346: 'OKL_API.G_RET_STS_ERROR',
347: x_msg_count,
348: x_msg_data,
349: '_PVT'
350: );

Line 352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

348: x_msg_data,
349: '_PVT'
350: );
351:
352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
353: IF (l_qtev_csr%ISOPEN) THEN
354: CLOSE l_qtev_csr;
355: END IF;
356: IF (l_stream_csr%ISOPEN) THEN

Line 359: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

355: END IF;
356: IF (l_stream_csr%ISOPEN) THEN
357: CLOSE l_stream_csr;
358: END IF;
359: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
360: (
361: l_api_name,
362: G_PKG_NAME,
363: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 363: 'OKL_API.G_RET_STS_UNEXP_ERROR',

359: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
360: (
361: l_api_name,
362: G_PKG_NAME,
363: 'OKL_API.G_RET_STS_UNEXP_ERROR',
364: x_msg_count,
365: x_msg_data,
366: '_PVT'
367: );

Line 376: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

372: END IF;
373: IF (l_stream_csr%ISOPEN) THEN
374: CLOSE l_stream_csr;
375: END IF;
376: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
377: (
378: l_api_name,
379: G_PKG_NAME,
380: 'OTHERS',

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

408: lx_tqlv_tbl tqlv_tbl_type;
409: l_qtev_rec qtev_rec_type;
410: lx_qtev_rec qtev_rec_type;
411:
412: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
413: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
414:
415: l_api_version CONSTANT NUMBER := G_API_VERSION;
416: l_msg_count NUMBER := G_MISS_NUM;

Line 413: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

409: l_qtev_rec qtev_rec_type;
410: lx_qtev_rec qtev_rec_type;
411:
412: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
413: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
414:
415: l_api_version CONSTANT NUMBER := G_API_VERSION;
416: l_msg_count NUMBER := G_MISS_NUM;
417: l_msg_data VARCHAR2(2000);

Line 433: p_init_msg_list => OKL_API.G_FALSE,

429: l_qtev_rec.qst_code := 'DRAFTED';
430:
431: OKL_TRX_QUOTES_PUB.update_trx_quotes (
432: p_api_version => l_api_version,
433: p_init_msg_list => OKL_API.G_FALSE,
434: x_return_status => l_return_status,
435: x_msg_count => l_msg_count,
436: x_msg_data => l_msg_data,
437: p_qtev_rec => l_qtev_rec,

Line 440: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

436: x_msg_data => l_msg_data,
437: p_qtev_rec => l_qtev_rec,
438: x_qtev_rec => lx_qtev_rec);
439:
440: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
441: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
442: l_overall_status := l_return_status;
443: END IF;
444: END IF;

Line 441: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

437: p_qtev_rec => l_qtev_rec,
438: x_qtev_rec => lx_qtev_rec);
439:
440: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
441: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
442: l_overall_status := l_return_status;
443: END IF;
444: END IF;
445:

Line 525: p_init_msg_list => OKL_API.G_FALSE,

521: IF l_tqlv_tbl.COUNT > 0 THEN
522:
523: OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines (
524: p_api_version => l_api_version,
525: p_init_msg_list => OKL_API.G_FALSE,
526: x_return_status => l_return_status,
527: x_msg_count => l_msg_count,
528: x_msg_data => l_msg_data,
529: p_tqlv_tbl => l_tqlv_tbl,

Line 532: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

528: x_msg_data => l_msg_data,
529: p_tqlv_tbl => l_tqlv_tbl,
530: x_tqlv_tbl => lx_tqlv_tbl);
531:
532: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
533: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
534: l_overall_status := l_return_status;
535: END IF;
536: END IF;

Line 533: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

529: p_tqlv_tbl => l_tqlv_tbl,
530: x_tqlv_tbl => lx_tqlv_tbl);
531:
532: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
533: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
534: l_overall_status := l_return_status;
535: END IF;
536: END IF;
537:

Line 552: OKL_API.SET_MESSAGE (

548:
549: WHEN OTHERS THEN
550:
551: -- store SQL error message on message stack for caller
552: OKL_API.SET_MESSAGE (
553: p_app_name => G_APP_NAME
554: ,p_msg_name => G_UNEXPECTED_ERROR
555: ,p_token1 => G_SQLCODE_TOKEN
556: ,p_token1_value => sqlcode

Line 561: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

557: ,p_token2 => G_SQLERRM_TOKEN
558: ,p_token2_value => sqlerrm);
559:
560: -- notify caller of an UNEXPECTED error
561: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
562:
563: END;
564:
565:

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

586: x_return_status OUT NOCOPY VARCHAR2,
587: x_msg_count OUT NOCOPY NUMBER,
588: x_msg_data OUT NOCOPY VARCHAR2) IS
589:
590: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
591: l_api_name CONSTANT VARCHAR2(30):= 'process_results';
592: l_api_version CONSTANT NUMBER := 1;
593: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
594: l_tqlv_tbl tqlv_tbl_type;

Line 593: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

589:
590: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
591: l_api_name CONSTANT VARCHAR2(30):= 'process_results';
592: l_api_version CONSTANT NUMBER := 1;
593: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
594: l_tqlv_tbl tqlv_tbl_type;
595:
596: BEGIN
597:

Line 599: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

595:
596: BEGIN
597:
598: --Check API version, initialize message list and create savepoint.
599: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
600: G_PKG_NAME,
601: p_init_msg_list,
602: l_api_version,
603: p_api_version,

Line 607: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

603: p_api_version,
604: '_PVT',
605: x_return_status);
606:
607: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
609: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
610: RAISE OKL_API.G_EXCEPTION_ERROR;
611: END IF;

Line 608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

604: '_PVT',
605: x_return_status);
606:
607: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
609: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
610: RAISE OKL_API.G_EXCEPTION_ERROR;
611: END IF;
612:

Line 609: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

605: x_return_status);
606:
607: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
609: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
610: RAISE OKL_API.G_EXCEPTION_ERROR;
611: END IF;
612:
613: populate_rent_levels (

Line 610: RAISE OKL_API.G_EXCEPTION_ERROR;

606:
607: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
609: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
610: RAISE OKL_API.G_EXCEPTION_ERROR;
611: END IF;
612:
613: populate_rent_levels (
614: p_quote_id => p_object1_id1,

Line 620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

616: p_yield_tbl => p_yield_tbl,
617: x_tqlv_tbl => l_tqlv_tbl,
618: x_return_status => l_return_status);
619:
620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
623: RAISE OKL_API.G_EXCEPTION_ERROR;
624: END IF;

Line 621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

617: x_tqlv_tbl => l_tqlv_tbl,
618: x_return_status => l_return_status);
619:
620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
623: RAISE OKL_API.G_EXCEPTION_ERROR;
624: END IF;
625:

Line 622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

618: x_return_status => l_return_status);
619:
620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
623: RAISE OKL_API.G_EXCEPTION_ERROR;
624: END IF;
625:
626: x_return_status := l_return_status;

Line 623: RAISE OKL_API.G_EXCEPTION_ERROR;

619:
620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
623: RAISE OKL_API.G_EXCEPTION_ERROR;
624: END IF;
625:
626: x_return_status := l_return_status;
627:

Line 629: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

625:
626: x_return_status := l_return_status;
627:
628: -- end the transaction
629: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
630:
631: EXCEPTION
632: WHEN OKL_API.G_EXCEPTION_ERROR THEN
633: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 632: WHEN OKL_API.G_EXCEPTION_ERROR THEN

628: -- end the transaction
629: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
630:
631: EXCEPTION
632: WHEN OKL_API.G_EXCEPTION_ERROR THEN
633: x_return_status := OKL_API.HANDLE_EXCEPTIONS
634: (
635: l_api_name,
636: G_PKG_NAME,

Line 633: x_return_status := OKL_API.HANDLE_EXCEPTIONS

629: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
630:
631: EXCEPTION
632: WHEN OKL_API.G_EXCEPTION_ERROR THEN
633: x_return_status := OKL_API.HANDLE_EXCEPTIONS
634: (
635: l_api_name,
636: G_PKG_NAME,
637: 'OKL_API.G_RET_STS_ERROR',

Line 637: 'OKL_API.G_RET_STS_ERROR',

633: x_return_status := OKL_API.HANDLE_EXCEPTIONS
634: (
635: l_api_name,
636: G_PKG_NAME,
637: 'OKL_API.G_RET_STS_ERROR',
638: x_msg_count,
639: x_msg_data,
640: '_PVT'
641: );

Line 642: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

638: x_msg_count,
639: x_msg_data,
640: '_PVT'
641: );
642: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
643: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
644: (
645: l_api_name,
646: G_PKG_NAME,

Line 643: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

639: x_msg_data,
640: '_PVT'
641: );
642: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
643: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
644: (
645: l_api_name,
646: G_PKG_NAME,
647: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 647: 'OKL_API.G_RET_STS_UNEXP_ERROR',

643: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
644: (
645: l_api_name,
646: G_PKG_NAME,
647: 'OKL_API.G_RET_STS_UNEXP_ERROR',
648: x_msg_count,
649: x_msg_data,
650: '_PVT'
651: );

Line 653: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

649: x_msg_data,
650: '_PVT'
651: );
652: WHEN OTHERS THEN
653: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
654: (
655: l_api_name,
656: G_PKG_NAME,
657: 'OTHERS',