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

Line 21: NVL(VALUE,OKL_API.G_MISS_CHAR) VALUE,

17: SFWT_FLAG,
18: DSF_ID,
19: PMR_ID,
20: SEQUENCE_NUMBER,
21: NVL(VALUE,OKL_API.G_MISS_CHAR) VALUE,
22: NVL(INSTRUCTIONS,OKL_API.G_MISS_CHAR) INSTRUCTIONS,
23: FPR_TYPE,
24: CREATED_BY,
25: CREATION_DATE,

Line 22: NVL(INSTRUCTIONS,OKL_API.G_MISS_CHAR) INSTRUCTIONS,

18: DSF_ID,
19: PMR_ID,
20: SEQUENCE_NUMBER,
21: NVL(VALUE,OKL_API.G_MISS_CHAR) VALUE,
22: NVL(INSTRUCTIONS,OKL_API.G_MISS_CHAR) INSTRUCTIONS,
23: FPR_TYPE,
24: CREATED_BY,
25: CREATION_DATE,
26: LAST_UPDATED_BY,

Line 28: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN

24: CREATED_BY,
25: CREATION_DATE,
26: LAST_UPDATED_BY,
27: LAST_UPDATE_DATE,
28: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
29: FROM Okl_Fnctn_Prmtrs_V
30: WHERE okl_Fnctn_Prmtrs_V.id = p_id;
31: l_okl_fprv_pk okl_fprv_pk_csr%ROWTYPE;
32: l_fprv_rec fprv_rec_type;

Line 34: x_return_status := OKL_API.G_RET_STS_SUCCESS;

30: WHERE okl_Fnctn_Prmtrs_V.id = p_id;
31: l_okl_fprv_pk okl_fprv_pk_csr%ROWTYPE;
32: l_fprv_rec fprv_rec_type;
33: BEGIN
34: x_return_status := OKL_API.G_RET_STS_SUCCESS;
35: x_no_data_found := TRUE;
36:
37: -- Get current database values
38: OPEN okl_fprv_pk_csr (p_fprv_rec.id);

Line 60: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

56: x_fprv_rec := l_fprv_rec;
57: EXCEPTION
58: WHEN OTHERS THEN
59: -- store SQL error message on message stack
60: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
61: p_msg_name => G_UNEXPECTED_ERROR,
62: p_token1 => G_SQLCODE_TOKEN,
63: p_token1_value => sqlcode,
64: p_token2 => G_SQLERRM_TOKEN,

Line 67: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

63: p_token1_value => sqlcode,
64: p_token2 => G_SQLERRM_TOKEN,
65: p_token2_value => sqlerrm);
66: -- notify UNEXPECTED error for calling API.
67: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
68:
69: IF (okl_fprv_pk_csr%ISOPEN) THEN
70: CLOSE okl_fprv_pk_csr;
71: END IF;

Line 97: x_return_status := OKL_API.G_RET_STS_SUCCESS;

93: l_check VARCHAR2(1) := '?';
94: l_row_not_found BOOLEAN := FALSE;
95: BEGIN
96: x_valid := TRUE;
97: x_return_status := OKL_API.G_RET_STS_SUCCESS;
98:
99: -- Check for function parameter sequence
100: OPEN okl_fprv_pk_csr (p_fprv_rec.dsf_id,
101: p_fprv_rec.sequence_number);

Line 107: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

103: l_row_not_found := okl_fprv_pk_csr%NOTFOUND;
104: CLOSE okl_fprv_pk_csr;
105:
106: IF l_row_not_found = FALSE then
107: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
108: p_msg_name => G_SEQUENCE_NUMBER,
109: p_token1 => G_COL_NAME_TOKEN,
110: p_token1_value => 'DSF_ID');
111: x_valid := FALSE;

Line 112: x_return_status := OKL_API.G_RET_STS_ERROR;

108: p_msg_name => G_SEQUENCE_NUMBER,
109: p_token1 => G_COL_NAME_TOKEN,
110: p_token1_value => 'DSF_ID');
111: x_valid := FALSE;
112: x_return_status := OKL_API.G_RET_STS_ERROR;
113: END IF;
114: EXCEPTION
115: WHEN OTHERS THEN
116: -- store SQL error message on message stack

Line 117: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

113: END IF;
114: EXCEPTION
115: WHEN OTHERS THEN
116: -- store SQL error message on message stack
117: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
118: p_msg_name => G_UNEXPECTED_ERROR,
119: p_token1 => G_SQLCODE_TOKEN,
120: p_token1_value => sqlcode,
121: p_token2 => G_SQLERRM_TOKEN,

Line 124: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

120: p_token1_value => sqlcode,
121: p_token2 => G_SQLERRM_TOKEN,
122: p_token2_value => sqlerrm);
123: x_valid := FALSE;
124: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
125:
126: IF (okl_fprv_pk_csr%ISOPEN) THEN
127: CLOSE okl_fprv_pk_csr;
128: END IF;

Line 354: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

350: ---------------------------------------------------------------------------
351: -- PROCEDURE insert_dsfparameters for: OKL_FNCTN_PRMTRS_V
352: ---------------------------------------------------------------------------
353: PROCEDURE insert_dsfparameters(p_api_version IN NUMBER,
354: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
355: x_return_status OUT NOCOPY VARCHAR2,
356: x_msg_count OUT NOCOPY NUMBER,
357: x_msg_data OUT NOCOPY VARCHAR2,
358: p_dsfv_rec IN dsfv_rec_type,

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

394: /* call check_constraints to check the validity of this relationship */
395: check_constraints(p_fprv_rec => l_fprv_rec,
396: x_return_status => l_return_status,
397: x_valid => l_valid);
398: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
401: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
402: l_valid <> TRUE) THEN

Line 400: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR

396: x_return_status => l_return_status,
397: x_valid => l_valid);
398: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
401: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
402: l_valid <> TRUE) THEN
403: x_return_status := OKL_API.G_RET_STS_ERROR;
404: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 401: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

397: x_valid => l_valid);
398: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
401: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
402: l_valid <> TRUE) THEN
403: x_return_status := OKL_API.G_RET_STS_ERROR;
404: RAISE OKC_API.G_EXCEPTION_ERROR;
405: END IF;

Line 403: x_return_status := OKL_API.G_RET_STS_ERROR;

399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
401: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
402: l_valid <> TRUE) THEN
403: x_return_status := OKL_API.G_RET_STS_ERROR;
404: RAISE OKC_API.G_EXCEPTION_ERROR;
405: END IF;
406:
407: /* public api to insert function parameters */

Line 453: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

449: ---------------------------------------------------------------------------
450: -- PROCEDURE update_dsfparameters for: OKL_FNCTN_PRMTRS_V
451: ---------------------------------------------------------------------------
452: PROCEDURE update_dsfparameters(p_api_version IN NUMBER,
453: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
454: x_return_status OUT NOCOPY VARCHAR2,
455: x_msg_count OUT NOCOPY NUMBER,
456: x_msg_data OUT NOCOPY VARCHAR2,
457: p_dsfv_rec IN dsfv_rec_type,

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

485: /* call check_constraints to check the validity of this relationship */
486: check_constraints(p_fprv_rec => l_fprv_rec,
487: x_return_status => l_return_status,
488: x_valid => l_valid);
489: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
492: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
493: l_valid <> TRUE) THEN

Line 491: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR

487: x_return_status => l_return_status,
488: x_valid => l_valid);
489: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
492: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
493: l_valid <> TRUE) THEN
494: x_return_status := OKL_API.G_RET_STS_ERROR;
495: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 492: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

488: x_valid => l_valid);
489: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
492: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
493: l_valid <> TRUE) THEN
494: x_return_status := OKL_API.G_RET_STS_ERROR;
495: RAISE OKC_API.G_EXCEPTION_ERROR;
496: END IF;

Line 494: x_return_status := OKL_API.G_RET_STS_ERROR;

490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
492: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
493: l_valid <> TRUE) THEN
494: x_return_status := OKL_API.G_RET_STS_ERROR;
495: RAISE OKC_API.G_EXCEPTION_ERROR;
496: END IF;
497:
498: /* public api to insert function parameters */

Line 546: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

542: -- PROCEDURE delete_dsfparameters for: OKL_FNCTN_PRMTRS_V
543: -- This allows the user to delete table of records
544: ---------------------------------------------------------------------------
545: PROCEDURE delete_dsfparameters(p_api_version IN NUMBER,
546: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
547: x_return_status OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2,
550: p_fprv_tbl IN fprv_tbl_type

Line 621: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

617: -- PROCEDURE insert_dsfparameters for: OKL_FNCTN_PRMTRS_V - TBL
618: ---------------------------------------------------------------------------
619: PROCEDURE insert_dsfparameters(
620: p_api_version IN NUMBER,
621: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
622: x_return_status OUT NOCOPY VARCHAR2,
623: x_msg_count OUT NOCOPY NUMBER,
624: x_msg_data OUT NOCOPY VARCHAR2,
625: p_dsfv_rec IN dsfv_rec_type,

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

627: x_fprv_tbl OUT NOCOPY fprv_tbl_type) IS
628:
629: l_api_version CONSTANT NUMBER := 1;
630: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_dsfparameters';
631: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
632: i NUMBER := 0;
633: -- overall error status
634: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
635:

Line 634: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

630: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_dsfparameters';
631: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
632: i NUMBER := 0;
633: -- overall error status
634: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
635:
636: BEGIN
637: Okl_Api.init_msg_list(p_init_msg_list);
638: -- Make sure PL/SQL table has records in it before passing

Line 637: Okl_Api.init_msg_list(p_init_msg_list);

633: -- overall error status
634: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
635:
636: BEGIN
637: Okl_Api.init_msg_list(p_init_msg_list);
638: -- Make sure PL/SQL table has records in it before passing
639: IF (p_fprv_tbl.COUNT > 0) THEN
640: i := p_fprv_tbl.FIRST;
641: LOOP

Line 644: p_init_msg_list => Okl_Api.G_FALSE,

640: i := p_fprv_tbl.FIRST;
641: LOOP
642: insert_dsfparameters (
643: p_api_version => p_api_version,
644: p_init_msg_list => Okl_Api.G_FALSE,
645: x_return_status => x_return_status,
646: x_msg_count => x_msg_count,
647: p_dsfv_rec => p_dsfv_rec,
648: x_msg_data => x_msg_data,

Line 653: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

649: p_fprv_rec => p_fprv_tbl(i),
650: x_fprv_rec => x_fprv_tbl(i));
651:
652: -- store the highest degree of error
653: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
654: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
655: l_overall_status := x_return_status;
656: END IF;
657: END IF;

Line 654: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

650: x_fprv_rec => x_fprv_tbl(i));
651:
652: -- store the highest degree of error
653: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
654: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
655: l_overall_status := x_return_status;
656: END IF;
657: END IF;
658:

Line 670: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

666:
667:
668: END IF;
669: EXCEPTION
670: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
671: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
672: (
673: l_api_name,
674: G_PKG_NAME,

Line 671: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

667:
668: END IF;
669: EXCEPTION
670: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
671: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
672: (
673: l_api_name,
674: G_PKG_NAME,
675: 'Okl_Api.G_RET_STS_ERROR',

Line 675: 'Okl_Api.G_RET_STS_ERROR',

671: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
672: (
673: l_api_name,
674: G_PKG_NAME,
675: 'Okl_Api.G_RET_STS_ERROR',
676: x_msg_count,
677: x_msg_data,
678: '_PVT'
679: );

Line 680: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

676: x_msg_count,
677: x_msg_data,
678: '_PVT'
679: );
680: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
681: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
682: (
683: l_api_name,
684: G_PKG_NAME,

Line 681: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

677: x_msg_data,
678: '_PVT'
679: );
680: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
681: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
682: (
683: l_api_name,
684: G_PKG_NAME,
685: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 685: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

681: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
682: (
683: l_api_name,
684: G_PKG_NAME,
685: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
686: x_msg_count,
687: x_msg_data,
688: '_PVT'
689: );

Line 691: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

687: x_msg_data,
688: '_PVT'
689: );
690: WHEN OTHERS THEN
691: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
692: (
693: l_api_name,
694: G_PKG_NAME,
695: 'OTHERS',

Line 710: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

706: -- PROCEDURE update_dsfparameters for: OKL_FNCTN_PRMTRS_V -TBL
707: ---------------------------------------------------------------------------
708: PROCEDURE update_dsfparameters(
709: p_api_version IN NUMBER,
710: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,
713: x_msg_data OUT NOCOPY VARCHAR2,
714: p_dsfv_rec IN dsfv_rec_type,

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

716: x_fprv_tbl OUT NOCOPY fprv_tbl_type) IS
717:
718: l_api_version CONSTANT NUMBER := 1;
719: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_dsfparameters';
720: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
721: i NUMBER := 0;
722: -- overall error status
723: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
724:

Line 723: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

719: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_dsfparameters';
720: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
721: i NUMBER := 0;
722: -- overall error status
723: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
724:
725: BEGIN
726:
727: -- Make sure PL/SQL table has records in it before passing

Line 734: p_init_msg_list => Okl_Api.G_FALSE,

730: LOOP
731:
732: update_dsfparameters (
733: p_api_version => p_api_version,
734: p_init_msg_list => Okl_Api.G_FALSE,
735: x_return_status => x_return_status,
736: x_msg_count => x_msg_count,
737: p_dsfv_rec => p_dsfv_rec,
738: x_msg_data => x_msg_data,

Line 744: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

740: x_fprv_rec => x_fprv_tbl(i));
741:
742:
743: -- store the highest degree of error
744: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
745: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
746: l_overall_status := x_return_status;
747: END IF;
748: END IF;

Line 745: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

741:
742:
743: -- store the highest degree of error
744: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
745: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
746: l_overall_status := x_return_status;
747: END IF;
748: END IF;
749:

Line 761: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

757:
758:
759: END IF;
760: EXCEPTION
761: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
762: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
763: (
764: l_api_name,
765: G_PKG_NAME,

Line 762: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

758:
759: END IF;
760: EXCEPTION
761: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
762: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
763: (
764: l_api_name,
765: G_PKG_NAME,
766: 'Okl_Api.G_RET_STS_ERROR',

Line 766: 'Okl_Api.G_RET_STS_ERROR',

762: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
763: (
764: l_api_name,
765: G_PKG_NAME,
766: 'Okl_Api.G_RET_STS_ERROR',
767: x_msg_count,
768: x_msg_data,
769: '_PVT'
770: );

Line 771: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

767: x_msg_count,
768: x_msg_data,
769: '_PVT'
770: );
771: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
772: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
773: (
774: l_api_name,
775: G_PKG_NAME,

Line 772: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

768: x_msg_data,
769: '_PVT'
770: );
771: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
772: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
773: (
774: l_api_name,
775: G_PKG_NAME,
776: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 776: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

772: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
773: (
774: l_api_name,
775: G_PKG_NAME,
776: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
777: x_msg_count,
778: x_msg_data,
779: '_PVT'
780: );

Line 782: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

778: x_msg_data,
779: '_PVT'
780: );
781: WHEN OTHERS THEN
782: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
783: (
784: l_api_name,
785: G_PKG_NAME,
786: 'OTHERS',