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_SETUPOVDTEMPLATES_PVT dependencies on OKC_API

Line 78: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

74: p_context_org IN NUMBER,
75: p_context_inv_org IN NUMBER,
76: p_context_asset_book IN VARCHAR2
77: ) RETURN VARCHAR2 IS
78: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
79: BEGIN
80: IF p_context_org <> Okl_Api.G_MISS_NUM AND
81: p_org_id <> p_context_org THEN
82: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE, p_ovtv_rec IN ovtv_rec_type,

113: -- is ok with rest of the product - contract relationships
114: ---------------------------------------------------------------------------
115: PROCEDURE check_constraints (
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE, p_ovtv_rec IN ovtv_rec_type,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: x_valid OUT NOCOPY BOOLEAN

Line 172: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

168: l_check VARCHAR2(1) := '?';
169: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY') , 'DD/MM/YYYY');
170: l_row_not_found BOOLEAN := FALSE;
171: l_rulv_rec rulv_rec_type;
172: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
173: l_no_data_found BOOLEAN := FALSE;
174: l_object_id_number NUMBER := 0;
175: l_rule VARCHAR2(30);
176: l_rulegroup VARCHAR2(30);

Line 418: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

414: x_ovtv_rec OUT NOCOPY ovtv_rec_type
415: ) IS
416: l_api_version CONSTANT NUMBER := 1;
417: l_api_name CONSTANT VARCHAR2(30) := 'insert_ovdtemplates';
418: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
419: l_valid BOOLEAN;
420: l_ovtv_rec ovtv_rec_type;
421: BEGIN
422: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 422: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

418: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
419: l_valid BOOLEAN;
420: l_ovtv_rec ovtv_rec_type;
421: BEGIN
422: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
423: l_return_status := Okc_Api.START_ACTIVITY(p_api_name => l_api_name,
424: p_pkg_name => G_PKG_NAME,
425: p_init_msg_list => p_init_msg_list,
426: l_api_version => l_api_version,

Line 423: l_return_status := Okc_Api.START_ACTIVITY(p_api_name => l_api_name,

419: l_valid BOOLEAN;
420: l_ovtv_rec ovtv_rec_type;
421: BEGIN
422: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
423: l_return_status := Okc_Api.START_ACTIVITY(p_api_name => l_api_name,
424: p_pkg_name => G_PKG_NAME,
425: p_init_msg_list => p_init_msg_list,
426: l_api_version => l_api_version,
427: p_api_version => p_api_version,

Line 430: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

426: l_api_version => l_api_version,
427: p_api_version => p_api_version,
428: p_api_type => '_PVT',
429: x_return_status => l_return_status);
430: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
433: RAISE Okc_Api.G_EXCEPTION_ERROR;
434: END IF;

Line 431: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

427: p_api_version => p_api_version,
428: p_api_type => '_PVT',
429: x_return_status => l_return_status);
430: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
433: RAISE Okc_Api.G_EXCEPTION_ERROR;
434: END IF;
435:

Line 432: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

428: p_api_type => '_PVT',
429: x_return_status => l_return_status);
430: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
433: RAISE Okc_Api.G_EXCEPTION_ERROR;
434: END IF;
435:
436: l_ovtv_rec := p_ovtv_rec;

Line 433: RAISE Okc_Api.G_EXCEPTION_ERROR;

429: x_return_status => l_return_status);
430: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
433: RAISE Okc_Api.G_EXCEPTION_ERROR;
434: END IF;
435:
436: l_ovtv_rec := p_ovtv_rec;
437:

Line 448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

444: x_msg_data => x_msg_data,
445: x_valid => l_valid);
446:
447: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
450: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
451: l_valid <> TRUE) THEN
452: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 453: RAISE Okc_Api.G_EXCEPTION_ERROR;

449: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
450: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
451: l_valid <> TRUE) THEN
452: x_return_status := Okl_Api.G_RET_STS_ERROR;
453: RAISE Okc_Api.G_EXCEPTION_ERROR;
454: END IF;
455:
456: /* public api to insert option value rule templates */
457: Okl_Ovd_Rul_Tmls_Pub.insert_ovd_rul_tmls(p_api_version => p_api_version,

Line 465: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN

461: x_msg_data => x_msg_data,
462: p_ovtv_rec => l_ovtv_rec,
463: x_ovtv_rec => x_ovtv_rec);
464:
465: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN
466: RAISE Okc_Api.G_EXCEPTION_ERROR;
467: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
469: END IF;

Line 466: RAISE Okc_Api.G_EXCEPTION_ERROR;

462: p_ovtv_rec => l_ovtv_rec,
463: x_ovtv_rec => x_ovtv_rec);
464:
465: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN
466: RAISE Okc_Api.G_EXCEPTION_ERROR;
467: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
469: END IF;
470:

Line 467: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

463: x_ovtv_rec => x_ovtv_rec);
464:
465: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN
466: RAISE Okc_Api.G_EXCEPTION_ERROR;
467: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
469: END IF;
470:
471: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,

Line 468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

464:
465: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN
466: RAISE Okc_Api.G_EXCEPTION_ERROR;
467: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
469: END IF;
470:
471: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data);

Line 471: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,

467: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
469: END IF;
470:
471: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data);
473: EXCEPTION
474: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
475: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 474: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

470:
471: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data);
473: EXCEPTION
474: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
475: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
476: p_pkg_name => G_PKG_NAME,
477: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
478: x_msg_count => x_msg_count,

Line 475: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

471: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data);
473: EXCEPTION
474: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
475: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
476: p_pkg_name => G_PKG_NAME,
477: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
478: x_msg_count => x_msg_count,
479: x_msg_data => x_msg_data,

Line 477: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

473: EXCEPTION
474: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
475: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
476: p_pkg_name => G_PKG_NAME,
477: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
478: x_msg_count => x_msg_count,
479: x_msg_data => x_msg_data,
480: p_api_type => '_PVT');
481: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 481: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

477: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
478: x_msg_count => x_msg_count,
479: x_msg_data => x_msg_data,
480: p_api_type => '_PVT');
481: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
482: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
483: p_pkg_name => G_PKG_NAME,
484: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
485: x_msg_count => x_msg_count,

Line 482: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

478: x_msg_count => x_msg_count,
479: x_msg_data => x_msg_data,
480: p_api_type => '_PVT');
481: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
482: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
483: p_pkg_name => G_PKG_NAME,
484: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
485: x_msg_count => x_msg_count,
486: x_msg_data => x_msg_data,

Line 484: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

480: p_api_type => '_PVT');
481: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
482: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
483: p_pkg_name => G_PKG_NAME,
484: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
485: x_msg_count => x_msg_count,
486: x_msg_data => x_msg_data,
487: p_api_type => '_PVT');
488: WHEN OTHERS THEN

Line 489: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

485: x_msg_count => x_msg_count,
486: x_msg_data => x_msg_data,
487: p_api_type => '_PVT');
488: WHEN OTHERS THEN
489: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
490: p_pkg_name => G_PKG_NAME,
491: p_exc_name => 'OTHERS',
492: x_msg_count => x_msg_count,
493: x_msg_data => x_msg_data,

Line 518: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

514: l_db_ovtv_rec ovtv_rec_type;
515: l_rulv_tbl Okl_Rule_Pub.rulv_tbl_type;
516: l_no_data_found BOOLEAN := TRUE;
517: l_api_name CONSTANT VARCHAR2(30) := 'delete_ovdtemplates';
518: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
519: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
520: l_valid BOOLEAN;
521: i NUMBER;
522:

Line 519: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

515: l_rulv_tbl Okl_Rule_Pub.rulv_tbl_type;
516: l_no_data_found BOOLEAN := TRUE;
517: l_api_name CONSTANT VARCHAR2(30) := 'delete_ovdtemplates';
518: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
519: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
520: l_valid BOOLEAN;
521: i NUMBER;
522:
523:

Line 525: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

521: i NUMBER;
522:
523:
524: BEGIN
525: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
526: l_return_status := Okc_Api.START_ACTIVITY(p_api_name => l_api_name,
527: p_pkg_name => G_PKG_NAME,
528: p_init_msg_list => p_init_msg_list,
529: l_api_version => l_api_version,

Line 526: l_return_status := Okc_Api.START_ACTIVITY(p_api_name => l_api_name,

522:
523:
524: BEGIN
525: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
526: l_return_status := Okc_Api.START_ACTIVITY(p_api_name => l_api_name,
527: p_pkg_name => G_PKG_NAME,
528: p_init_msg_list => p_init_msg_list,
529: l_api_version => l_api_version,
530: p_api_version => p_api_version,

Line 533: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

529: l_api_version => l_api_version,
530: p_api_version => p_api_version,
531: p_api_type => '_PVT',
532: x_return_status => l_return_status);
533: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
534: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
535: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
536: RAISE Okc_Api.G_EXCEPTION_ERROR;
537: END IF;

Line 534: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

530: p_api_version => p_api_version,
531: p_api_type => '_PVT',
532: x_return_status => l_return_status);
533: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
534: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
535: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
536: RAISE Okc_Api.G_EXCEPTION_ERROR;
537: END IF;
538:

Line 535: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

531: p_api_type => '_PVT',
532: x_return_status => l_return_status);
533: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
534: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
535: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
536: RAISE Okc_Api.G_EXCEPTION_ERROR;
537: END IF;
538:
539: l_ovtv_tbl := p_ovtv_tbl;

Line 536: RAISE Okc_Api.G_EXCEPTION_ERROR;

532: x_return_status => l_return_status);
533: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
534: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
535: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
536: RAISE Okc_Api.G_EXCEPTION_ERROR;
537: END IF;
538:
539: l_ovtv_tbl := p_ovtv_tbl;
540: IF (l_ovtv_tbl.COUNT > 0) THEN

Line 595: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

591: -- return overall status
592: l_return_status := l_overall_status;
593: END IF;
594: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
597: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
598: l_valid <> TRUE) THEN
599: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 600: RAISE Okc_Api.G_EXCEPTION_ERROR;

596: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) OR
597: (l_return_status = Okl_Api.G_RET_STS_SUCCESS AND
598: l_valid <> TRUE) THEN
599: x_return_status := Okl_Api.G_RET_STS_ERROR;
600: RAISE Okc_Api.G_EXCEPTION_ERROR;
601: END IF;
602:
603: /* public api to delete option value rules */
604: Okl_Ovd_Rul_Tmls_Pub.delete_ovd_rul_tmls(p_api_version => p_api_version,

Line 611: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN

607: x_msg_count => x_msg_count,
608: x_msg_data => x_msg_data,
609: p_ovtv_tbl => l_ovtv_tbl);
610:
611: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN
612: RAISE Okc_Api.G_EXCEPTION_ERROR;
613: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
614: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
615: END IF;

Line 612: RAISE Okc_Api.G_EXCEPTION_ERROR;

608: x_msg_data => x_msg_data,
609: p_ovtv_tbl => l_ovtv_tbl);
610:
611: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN
612: RAISE Okc_Api.G_EXCEPTION_ERROR;
613: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
614: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
615: END IF;
616:

Line 613: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

609: p_ovtv_tbl => l_ovtv_tbl);
610:
611: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN
612: RAISE Okc_Api.G_EXCEPTION_ERROR;
613: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
614: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
615: END IF;
616:
617: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,

Line 614: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

610:
611: IF l_return_status = Okc_Api.G_RET_STS_ERROR THEN
612: RAISE Okc_Api.G_EXCEPTION_ERROR;
613: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
614: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
615: END IF;
616:
617: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data);

Line 617: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,

613: ELSIF l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
614: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
615: END IF;
616:
617: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data);
619: EXCEPTION
620: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
621: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 620: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

616:
617: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data);
619: EXCEPTION
620: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
621: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
622: p_pkg_name => G_PKG_NAME,
623: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
624: x_msg_count => x_msg_count,

Line 621: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

617: Okc_Api.END_ACTIVITY(x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data);
619: EXCEPTION
620: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
621: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
622: p_pkg_name => G_PKG_NAME,
623: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
624: x_msg_count => x_msg_count,
625: x_msg_data => x_msg_data,

Line 623: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

619: EXCEPTION
620: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
621: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
622: p_pkg_name => G_PKG_NAME,
623: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
624: x_msg_count => x_msg_count,
625: x_msg_data => x_msg_data,
626: p_api_type => '_PVT');
627: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 627: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

623: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
624: x_msg_count => x_msg_count,
625: x_msg_data => x_msg_data,
626: p_api_type => '_PVT');
627: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
628: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
629: p_pkg_name => G_PKG_NAME,
630: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
631: x_msg_count => x_msg_count,

Line 628: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

624: x_msg_count => x_msg_count,
625: x_msg_data => x_msg_data,
626: p_api_type => '_PVT');
627: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
628: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
629: p_pkg_name => G_PKG_NAME,
630: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
631: x_msg_count => x_msg_count,
632: x_msg_data => x_msg_data,

Line 630: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

626: p_api_type => '_PVT');
627: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
628: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
629: p_pkg_name => G_PKG_NAME,
630: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
631: x_msg_count => x_msg_count,
632: x_msg_data => x_msg_data,
633: p_api_type => '_PVT');
634: WHEN OTHERS THEN

Line 635: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

631: x_msg_count => x_msg_count,
632: x_msg_data => x_msg_data,
633: p_api_type => '_PVT');
634: WHEN OTHERS THEN
635: x_return_status := Okc_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
636: p_pkg_name => G_PKG_NAME,
637: p_exc_name => 'OTHERS',
638: x_msg_count => x_msg_count,
639: x_msg_data => x_msg_data,