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_BPD_TERMINATION_ADJ_PVT dependencies on OKL_API

Line 14: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

10:
11:
12: PROCEDURE create_debit_memo(
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
15: p_sel_id IN NUMBER,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 20: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2) IS
19:
20: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
21: l_api_version CONSTANT NUMBER := 1;
22: l_api_name CONSTANT VARCHAR2(30) := 'create_debit_memo';
23:
24: -----------------------------------------------------------------

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

153: BEGIN
154: IF (G_DEBUG_ENABLED = 'Y') THEN
155: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
156: END IF;
157: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
158: G_PKG_NAME,
159: p_init_msg_list,
160: l_api_version,
161: p_api_version,

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

161: p_api_version,
162: '_PVT',
163: l_return_status);
164:
165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;

Line 166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

162: '_PVT',
163: l_return_status);
164:
165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;
170:

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

163: l_return_status);
164:
165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;
170:
171: -- Processing starts

Line 168: RAISE OKL_API.G_EXCEPTION_ERROR;

164:
165: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;
170:
171: -- Processing starts
172:

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

258: ,p_tplv_tbl => l_tplv_tbl
259: ,x_tapv_rec => lx_tapv_rec
260: ,x_tplv_tbl => lx_tplv_tbl);
261:
262: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
265: l_created_tpl := FALSE;
266: END IF;

Line 263: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

259: ,x_tapv_rec => lx_tapv_rec
260: ,x_tplv_tbl => lx_tplv_tbl);
261:
262: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
265: l_created_tpl := FALSE;
266: END IF;
267:

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

260: ,x_tplv_tbl => lx_tplv_tbl);
261:
262: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
265: l_created_tpl := FALSE;
266: END IF;
267:
268: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

314: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'after updating lsm with Reversed status, Status : ' || l_return_status); -- rmunjulu R12 Billing Fixes: commented
315: -- rmunjulu R12 Billing Fixes
316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'after updating TLD with Reversed status, Status : ' || l_return_status);
317: END IF;
318: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
321: RAISE OKL_API.G_EXCEPTION_ERROR;
322: END IF;

Line 319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

315: -- rmunjulu R12 Billing Fixes
316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'after updating TLD with Reversed status, Status : ' || l_return_status);
317: END IF;
318: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
321: RAISE OKL_API.G_EXCEPTION_ERROR;
322: END IF;
323: END IF;

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

316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'after updating TLD with Reversed status, Status : ' || l_return_status);
317: END IF;
318: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
321: RAISE OKL_API.G_EXCEPTION_ERROR;
322: END IF;
323: END IF;
324: END LOOP;

Line 321: RAISE OKL_API.G_EXCEPTION_ERROR;

317: END IF;
318: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
321: RAISE OKL_API.G_EXCEPTION_ERROR;
322: END IF;
323: END IF;
324: END LOOP;
325:

Line 329: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

325:
326: -- Processing ends
327:
328: x_return_status := l_return_status;
329: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
330: EXCEPTION
331: WHEN OKL_API.G_EXCEPTION_ERROR THEN
332: x_return_status := OKL_API.G_RET_STS_ERROR;
333: WHEN OTHERS THEN

Line 331: WHEN OKL_API.G_EXCEPTION_ERROR THEN

327:
328: x_return_status := l_return_status;
329: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
330: EXCEPTION
331: WHEN OKL_API.G_EXCEPTION_ERROR THEN
332: x_return_status := OKL_API.G_RET_STS_ERROR;
333: WHEN OTHERS THEN
334: x_return_status := OKL_API.HANDLE_EXCEPTIONS
335: (

Line 332: x_return_status := OKL_API.G_RET_STS_ERROR;

328: x_return_status := l_return_status;
329: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
330: EXCEPTION
331: WHEN OKL_API.G_EXCEPTION_ERROR THEN
332: x_return_status := OKL_API.G_RET_STS_ERROR;
333: WHEN OTHERS THEN
334: x_return_status := OKL_API.HANDLE_EXCEPTIONS
335: (
336: l_api_name,

Line 334: x_return_status := OKL_API.HANDLE_EXCEPTIONS

330: EXCEPTION
331: WHEN OKL_API.G_EXCEPTION_ERROR THEN
332: x_return_status := OKL_API.G_RET_STS_ERROR;
333: WHEN OTHERS THEN
334: x_return_status := OKL_API.HANDLE_EXCEPTIONS
335: (
336: l_api_name,
337: G_PKG_NAME,
338: 'OTHERS',

Line 375: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

371: ---------------------------------------------------------------------------
372:
373: PROCEDURE get_billing_adjust(
374: p_api_version IN NUMBER,
375: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
376: p_input_tbl IN input_tbl_type,
377: x_baj_tbl OUT NOCOPY baj_tbl_type,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,

Line 382: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2) IS
381:
382: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
383: l_api_version CONSTANT NUMBER := 1;
384: l_api_name CONSTANT VARCHAR2(30) := 'get_billing_adjust';
385:
386: l_input_rec input_rec_type;

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

455: and cim.object1_id1 = to_char(p_line_id)
456: and cim.object1_id2 = '#';
457: --akrangan bug 5655680 -- end
458: BEGIN
459: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
460: G_PKG_NAME,
461: p_init_msg_list,
462: l_api_version,
463: p_api_version,

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

463: p_api_version,
464: '_PVT',
465: l_return_status);
466:
467: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
469: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
470: RAISE OKL_API.G_EXCEPTION_ERROR;
471: END IF;

Line 468: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

464: '_PVT',
465: l_return_status);
466:
467: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
469: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
470: RAISE OKL_API.G_EXCEPTION_ERROR;
471: END IF;
472:

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

465: l_return_status);
466:
467: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
469: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
470: RAISE OKL_API.G_EXCEPTION_ERROR;
471: END IF;
472:
473: -- Processing starts

Line 470: RAISE OKL_API.G_EXCEPTION_ERROR;

466:
467: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
469: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
470: RAISE OKL_API.G_EXCEPTION_ERROR;
471: END IF;
472:
473: -- Processing starts
474: l_input_tbl := p_input_tbl;

Line 493: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

489: lx_baj_tbl(baj_cnt) := cur_bill_adj;
490: END LOOP;
491: END LOOP;
492: --akrangan Bug 5655680 end --
493: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
494: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
495: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
496: RAISE okl_api.G_EXCEPTION_ERROR;
497: END IF;

Line 494: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

490: END LOOP;
491: END LOOP;
492: --akrangan Bug 5655680 end --
493: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
494: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
495: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
496: RAISE okl_api.G_EXCEPTION_ERROR;
497: END IF;
498:

Line 495: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

491: END LOOP;
492: --akrangan Bug 5655680 end --
493: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
494: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
495: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
496: RAISE okl_api.G_EXCEPTION_ERROR;
497: END IF;
498:
499: input_cnt := l_input_tbl.NEXT(input_cnt);

Line 496: RAISE okl_api.G_EXCEPTION_ERROR;

492: --akrangan Bug 5655680 end --
493: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
494: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
495: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
496: RAISE okl_api.G_EXCEPTION_ERROR;
497: END IF;
498:
499: input_cnt := l_input_tbl.NEXT(input_cnt);
500: END LOOP;

Line 506: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

502: -- Processing ends
503: x_baj_tbl := lx_baj_tbl;
504: x_return_status := l_return_status;
505:
506: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
507: EXCEPTION
508: WHEN OKL_API.G_EXCEPTION_ERROR THEN
509: x_return_status := OKL_API.G_RET_STS_ERROR;
510: WHEN OTHERS THEN

Line 508: WHEN OKL_API.G_EXCEPTION_ERROR THEN

504: x_return_status := l_return_status;
505:
506: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
507: EXCEPTION
508: WHEN OKL_API.G_EXCEPTION_ERROR THEN
509: x_return_status := OKL_API.G_RET_STS_ERROR;
510: WHEN OTHERS THEN
511: x_return_status := OKL_API.HANDLE_EXCEPTIONS
512: (

Line 509: x_return_status := OKL_API.G_RET_STS_ERROR;

505:
506: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
507: EXCEPTION
508: WHEN OKL_API.G_EXCEPTION_ERROR THEN
509: x_return_status := OKL_API.G_RET_STS_ERROR;
510: WHEN OTHERS THEN
511: x_return_status := OKL_API.HANDLE_EXCEPTIONS
512: (
513: l_api_name,

Line 511: x_return_status := OKL_API.HANDLE_EXCEPTIONS

507: EXCEPTION
508: WHEN OKL_API.G_EXCEPTION_ERROR THEN
509: x_return_status := OKL_API.G_RET_STS_ERROR;
510: WHEN OTHERS THEN
511: x_return_status := OKL_API.HANDLE_EXCEPTIONS
512: (
513: l_api_name,
514: G_PKG_NAME,
515: 'OTHERS',

Line 526: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

522: ---------------------------------------------------------------------------
523:
524: PROCEDURE get_unbilled_recvbl(
525: p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
527: p_input_tbl IN input_tbl_type,
528: x_baj_tbl OUT NOCOPY baj_tbl_type,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,

Line 533: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2) IS
532:
533: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
534: l_api_version CONSTANT NUMBER := 1;
535: l_api_name CONSTANT VARCHAR2(30) := 'get_unbilled_recvbl';
536:
537: l_input_rec input_rec_type;

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

587: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
588: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
589: ORDER BY 1, 2, 3;
590: BEGIN
591: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
592: G_PKG_NAME,
593: p_init_msg_list,
594: l_api_version,
595: p_api_version,

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

595: p_api_version,
596: '_PVT',
597: l_return_status);
598:
599: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_ERROR;
603: END IF;

Line 600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

596: '_PVT',
597: l_return_status);
598:
599: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_ERROR;
603: END IF;
604:

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

597: l_return_status);
598:
599: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_ERROR;
603: END IF;
604:
605: -- Processing starts

Line 602: RAISE OKL_API.G_EXCEPTION_ERROR;

598:
599: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_ERROR;
603: END IF;
604:
605: -- Processing starts
606: l_input_tbl := p_input_tbl;

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

614: baj_cnt := baj_cnt + 1;
615: lx_baj_tbl(baj_cnt) := cur_bill_adj;
616: END LOOP;
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: lx_baj_tbl(baj_cnt) := cur_bill_adj;
616: END LOOP;
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:

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

616: END LOOP;
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:
624: input_cnt := l_input_tbl.NEXT(input_cnt);

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:
624: input_cnt := l_input_tbl.NEXT(input_cnt);
625: END LOOP;

Line 631: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

627: -- Processing ends
628: x_baj_tbl := lx_baj_tbl;
629: x_return_status := l_return_status;
630:
631: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
632: EXCEPTION
633: WHEN OKL_API.G_EXCEPTION_ERROR THEN
634: x_return_status := OKL_API.G_RET_STS_ERROR;
635: WHEN OTHERS THEN

Line 633: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 634: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 636: x_return_status := OKL_API.HANDLE_EXCEPTIONS

632: EXCEPTION
633: WHEN OKL_API.G_EXCEPTION_ERROR THEN
634: x_return_status := OKL_API.G_RET_STS_ERROR;
635: WHEN OTHERS THEN
636: x_return_status := OKL_API.HANDLE_EXCEPTIONS
637: (
638: l_api_name,
639: G_PKG_NAME,
640: 'OTHERS',

Line 651: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

647: ---------------------------------------------------------------------------
648:
649: PROCEDURE create_passthru_adj(
650: p_api_version IN NUMBER,
651: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
652: p_baj_tbl IN baj_tbl_type,
653: x_return_status OUT NOCOPY VARCHAR2,
654: x_msg_count OUT NOCOPY NUMBER,
655: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 657: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

653: x_return_status OUT NOCOPY VARCHAR2,
654: x_msg_count OUT NOCOPY NUMBER,
655: x_msg_data OUT NOCOPY VARCHAR2) IS
656:
657: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
658: l_api_version CONSTANT NUMBER := 1;
659: l_api_name CONSTANT VARCHAR2(30) := 'create_passthru_adj';
660: l_ableto_complete BOOLEAN := TRUE;
661:

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

663: l_baj_tbl baj_tbl_type;
664:
665: cnt NUMBER;
666: BEGIN
667: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
668: G_PKG_NAME,
669: p_init_msg_list,
670: l_api_version,
671: p_api_version,

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

671: p_api_version,
672: '_PVT',
673: l_return_status);
674:
675: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;

Line 676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

672: '_PVT',
673: l_return_status);
674:
675: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;
680:

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

673: l_return_status);
674:
675: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;
680:
681: -- Processing starts

Line 678: RAISE OKL_API.G_EXCEPTION_ERROR;

674:
675: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;
680:
681: -- Processing starts
682: l_baj_tbl := p_baj_tbl;

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

693: x_return_status => l_return_status,
694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data);
696:
697: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
699: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
700: l_ableto_complete := FALSE;
701: END IF;

Line 698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data);
696:
697: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
699: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
700: l_ableto_complete := FALSE;
701: END IF;
702:

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

695: x_msg_data => x_msg_data);
696:
697: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
699: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
700: l_ableto_complete := FALSE;
701: END IF;
702:
703: cnt := l_baj_tbl.NEXT(cnt);

Line 708: x_return_status := OKL_API.G_RET_STS_ERROR;

704: END LOOP;
705:
706: -- Processing ends
707: IF NOT(l_ableto_complete) THEN
708: x_return_status := OKL_API.G_RET_STS_ERROR;
709: ELSE
710: x_return_status := OKL_API.G_RET_STS_SUCCESS;
711: END IF;
712:

Line 710: x_return_status := OKL_API.G_RET_STS_SUCCESS;

706: -- Processing ends
707: IF NOT(l_ableto_complete) THEN
708: x_return_status := OKL_API.G_RET_STS_ERROR;
709: ELSE
710: x_return_status := OKL_API.G_RET_STS_SUCCESS;
711: END IF;
712:
713: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
714: EXCEPTION

Line 713: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

709: ELSE
710: x_return_status := OKL_API.G_RET_STS_SUCCESS;
711: END IF;
712:
713: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
714: EXCEPTION
715: WHEN OKL_API.G_EXCEPTION_ERROR THEN
716: x_return_status := OKL_API.G_RET_STS_ERROR;
717: WHEN OTHERS THEN

Line 715: WHEN OKL_API.G_EXCEPTION_ERROR THEN

711: END IF;
712:
713: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
714: EXCEPTION
715: WHEN OKL_API.G_EXCEPTION_ERROR THEN
716: x_return_status := OKL_API.G_RET_STS_ERROR;
717: WHEN OTHERS THEN
718: x_return_status := OKL_API.HANDLE_EXCEPTIONS
719: (

Line 716: x_return_status := OKL_API.G_RET_STS_ERROR;

712:
713: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
714: EXCEPTION
715: WHEN OKL_API.G_EXCEPTION_ERROR THEN
716: x_return_status := OKL_API.G_RET_STS_ERROR;
717: WHEN OTHERS THEN
718: x_return_status := OKL_API.HANDLE_EXCEPTIONS
719: (
720: l_api_name,

Line 718: x_return_status := OKL_API.HANDLE_EXCEPTIONS

714: EXCEPTION
715: WHEN OKL_API.G_EXCEPTION_ERROR THEN
716: x_return_status := OKL_API.G_RET_STS_ERROR;
717: WHEN OTHERS THEN
718: x_return_status := OKL_API.HANDLE_EXCEPTIONS
719: (
720: l_api_name,
721: G_PKG_NAME,
722: 'OTHERS',

Line 733: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

729: ---------------------------------------------------------------------------
730:
731: PROCEDURE get_unbilled_prop_tax(
732: p_api_version IN NUMBER,
733: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
734: p_input_tbl IN input_tbl_type,
735: x_baj_tbl OUT NOCOPY baj_tbl_type,
736: x_return_status OUT NOCOPY VARCHAR2,
737: x_msg_count OUT NOCOPY NUMBER,

Line 740: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

736: x_return_status OUT NOCOPY VARCHAR2,
737: x_msg_count OUT NOCOPY NUMBER,
738: x_msg_data OUT NOCOPY VARCHAR2) IS
739:
740: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
741: l_api_version CONSTANT NUMBER := 1;
742: l_api_name CONSTANT VARCHAR2(30) := 'get_unbilled_prop_tax';
743:
744: l_input_rec input_rec_type;

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

806: AND sty.stream_type_purpose = 'ESTIMATED_PROPERTY_TAX'
807: ORDER BY 1, 2, 3;
808:
809: BEGIN
810: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
811: G_PKG_NAME,
812: p_init_msg_list,
813: l_api_version,
814: p_api_version,

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

814: p_api_version,
815: '_PVT',
816: l_return_status);
817:
818: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
819: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
820: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
821: RAISE OKL_API.G_EXCEPTION_ERROR;
822: END IF;

Line 819: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

815: '_PVT',
816: l_return_status);
817:
818: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
819: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
820: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
821: RAISE OKL_API.G_EXCEPTION_ERROR;
822: END IF;
823:

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

816: l_return_status);
817:
818: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
819: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
820: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
821: RAISE OKL_API.G_EXCEPTION_ERROR;
822: END IF;
823:
824: -- Processing starts

Line 821: RAISE OKL_API.G_EXCEPTION_ERROR;

817:
818: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
819: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
820: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
821: RAISE OKL_API.G_EXCEPTION_ERROR;
822: END IF;
823:
824: -- Processing starts
825: l_input_tbl := p_input_tbl;

Line 837: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

833: baj_cnt := baj_cnt + 1;
834: lx_baj_tbl(baj_cnt) := cur_bill_adj;
835: END LOOP;
836:
837: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
840: RAISE okl_api.G_EXCEPTION_ERROR;
841: END IF;

Line 838: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

834: lx_baj_tbl(baj_cnt) := cur_bill_adj;
835: END LOOP;
836:
837: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
840: RAISE okl_api.G_EXCEPTION_ERROR;
841: END IF;
842:

Line 839: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

835: END LOOP;
836:
837: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
840: RAISE okl_api.G_EXCEPTION_ERROR;
841: END IF;
842:
843: input_cnt := l_input_tbl.NEXT(input_cnt);

Line 840: RAISE okl_api.G_EXCEPTION_ERROR;

836:
837: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
840: RAISE okl_api.G_EXCEPTION_ERROR;
841: END IF;
842:
843: input_cnt := l_input_tbl.NEXT(input_cnt);
844: END LOOP;

Line 850: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

846: -- Processing ends
847: x_baj_tbl := lx_baj_tbl;
848: x_return_status := l_return_status;
849:
850: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
851: EXCEPTION
852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
853: x_return_status := OKL_API.G_RET_STS_ERROR;
854: WHEN OTHERS THEN

Line 852: WHEN OKL_API.G_EXCEPTION_ERROR THEN

848: x_return_status := l_return_status;
849:
850: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
851: EXCEPTION
852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
853: x_return_status := OKL_API.G_RET_STS_ERROR;
854: WHEN OTHERS THEN
855: x_return_status := OKL_API.HANDLE_EXCEPTIONS
856: (

Line 853: x_return_status := OKL_API.G_RET_STS_ERROR;

849:
850: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
851: EXCEPTION
852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
853: x_return_status := OKL_API.G_RET_STS_ERROR;
854: WHEN OTHERS THEN
855: x_return_status := OKL_API.HANDLE_EXCEPTIONS
856: (
857: l_api_name,

Line 855: x_return_status := OKL_API.HANDLE_EXCEPTIONS

851: EXCEPTION
852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
853: x_return_status := OKL_API.G_RET_STS_ERROR;
854: WHEN OTHERS THEN
855: x_return_status := OKL_API.HANDLE_EXCEPTIONS
856: (
857: l_api_name,
858: G_PKG_NAME,
859: 'OTHERS',

Line 871: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

867: --interface between rebook api and bpd processing apis by fmiao
868: ------------------------------------------------------------------
869: PROCEDURE create_rbk_passthru_adj(
870: p_api_version IN NUMBER,
871: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
872: p_rebook_adj_tbl IN rebook_adj_tbl,
873: x_disb_rec OUT NOCOPY disb_rec_type,
874: x_return_status OUT NOCOPY VARCHAR2,
875: x_msg_count OUT NOCOPY NUMBER,

Line 878: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

874: x_return_status OUT NOCOPY VARCHAR2,
875: x_msg_count OUT NOCOPY NUMBER,
876: x_msg_data OUT NOCOPY VARCHAR2) IS
877:
878: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
879: l_api_version CONSTANT NUMBER := 1;
880: l_api_name CONSTANT VARCHAR2(30) := 'create_rbk_passthru_adj';
881:
882: l_disb_rec disb_rec_type;

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

920: BEGIN
921: --Bug# 4884423
922: x_return_status := OKC_API.G_RET_STS_SUCCESS;
923:
924: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
925: G_PKG_NAME,
926: p_init_msg_list,
927: l_api_version,
928: p_api_version,

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

928: p_api_version,
929: '_PVT',
930: l_return_status);
931:
932: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_ERROR;
936: END IF;

Line 933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

929: '_PVT',
930: l_return_status);
931:
932: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_ERROR;
936: END IF;
937:

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

930: l_return_status);
931:
932: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_ERROR;
936: END IF;
937:
938: IF p_rebook_adj_tbl.COUNT > 0 THEN

Line 935: RAISE OKL_API.G_EXCEPTION_ERROR;

931:
932: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
935: RAISE OKL_API.G_EXCEPTION_ERROR;
936: END IF;
937:
938: IF p_rebook_adj_tbl.COUNT > 0 THEN
939: i := p_rebook_adj_tbl.FIRST;

Line 985: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

981: x_msg_count => x_msg_count,
982: x_msg_data => x_msg_data,
983: p_disb_rec => l_disb_rec);
984:
985: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
987: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
988: RAISE OKL_API.G_EXCEPTION_ERROR;
989: END IF;

Line 986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

982: x_msg_data => x_msg_data,
983: p_disb_rec => l_disb_rec);
984:
985: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
987: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
988: RAISE OKL_API.G_EXCEPTION_ERROR;
989: END IF;
990: END IF;

Line 987: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

983: p_disb_rec => l_disb_rec);
984:
985: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
987: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
988: RAISE OKL_API.G_EXCEPTION_ERROR;
989: END IF;
990: END IF;
991:

Line 988: RAISE OKL_API.G_EXCEPTION_ERROR;

984:
985: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
987: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
988: RAISE OKL_API.G_EXCEPTION_ERROR;
989: END IF;
990: END IF;
991:
992: EXIT WHEN (i = p_rebook_adj_tbl.LAST);

Line 997: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

993: i := p_rebook_adj_tbl.NEXT(i);
994: END LOOP;
995: END IF;
996:
997: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
998: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1000: RAISE OKL_API.G_EXCEPTION_ERROR;
1001: END IF;

Line 998: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

994: END LOOP;
995: END IF;
996:
997: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
998: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1000: RAISE OKL_API.G_EXCEPTION_ERROR;
1001: END IF;
1002:

Line 999: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

995: END IF;
996:
997: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
998: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1000: RAISE OKL_API.G_EXCEPTION_ERROR;
1001: END IF;
1002:
1003: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1000: RAISE OKL_API.G_EXCEPTION_ERROR;

996:
997: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
998: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1000: RAISE OKL_API.G_EXCEPTION_ERROR;
1001: END IF;
1002:
1003: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1004: EXCEPTION

Line 1003: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

999: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1000: RAISE OKL_API.G_EXCEPTION_ERROR;
1001: END IF;
1002:
1003: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1004: EXCEPTION
1005: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1006: x_return_status := OKL_API.G_RET_STS_ERROR;
1007: WHEN OTHERS THEN

Line 1005: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1001: END IF;
1002:
1003: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1004: EXCEPTION
1005: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1006: x_return_status := OKL_API.G_RET_STS_ERROR;
1007: WHEN OTHERS THEN
1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1009: (

Line 1006: x_return_status := OKL_API.G_RET_STS_ERROR;

1002:
1003: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1004: EXCEPTION
1005: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1006: x_return_status := OKL_API.G_RET_STS_ERROR;
1007: WHEN OTHERS THEN
1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1009: (
1010: l_api_name,

Line 1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1004: EXCEPTION
1005: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1006: x_return_status := OKL_API.G_RET_STS_ERROR;
1007: WHEN OTHERS THEN
1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1009: (
1010: l_api_name,
1011: G_PKG_NAME,
1012: 'OTHERS',