APPS.OKL_BILL_STATUS_PVT dependencies on OKL_API

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

480: AND opn_code = 'CHECK_RULE';
481:
482: l_api_version CONSTANT NUMBER := 1;
483: l_api_name CONSTANT VARCHAR2(30) := 'billing_status';
484: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
485: l_stream_id NUMBER;
486:
487: -- l_khr_id NUMBER;
488: i NUMBER;

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

518:
519:
520: BEGIN
521:
522: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
523: G_PKG_NAME,
524: p_init_msg_list,
525: l_api_version,
526: p_api_version,

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

527: '_PVT',
528: x_return_status);
529:
530:
531: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
533: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
534: RAISE OKL_API.G_EXCEPTION_ERROR;
535: END IF;

Line 532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

528: x_return_status);
529:
530:
531: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
533: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
534: RAISE OKL_API.G_EXCEPTION_ERROR;
535: END IF;
536:

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

529:
530:
531: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
533: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
534: RAISE OKL_API.G_EXCEPTION_ERROR;
535: END IF;
536:
537:

Line 534: RAISE OKL_API.G_EXCEPTION_ERROR;

530:
531: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
533: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
534: RAISE OKL_API.G_EXCEPTION_ERROR;
535: END IF;
536:
537:
538: i := 0;

Line 853: Okl_Api.END_ACTIVITY (

849:
850: -- abindal START bug 4290677 --
851:
852: x_bill_stat_tbl := l_bill_stat_tbl;
853: Okl_Api.END_ACTIVITY (
854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data);
856:
857: EXCEPTION

Line 858: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data);
856:
857: EXCEPTION
858: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
859: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
860: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
861: (
862: l_api_name,

Line 860: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

856:
857: EXCEPTION
858: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
859: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
860: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
861: (
862: l_api_name,
863: G_PKG_NAME,
864: 'Okl_Api.G_RET_STS_ERROR',

Line 864: 'Okl_Api.G_RET_STS_ERROR',

860: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
861: (
862: l_api_name,
863: G_PKG_NAME,
864: 'Okl_Api.G_RET_STS_ERROR',
865: x_msg_count,
866: x_msg_data,
867: '_PVT'
868: );

Line 869: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

865: x_msg_count,
866: x_msg_data,
867: '_PVT'
868: );
869: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
871: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
872: (
873: l_api_name,

Line 871: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

867: '_PVT'
868: );
869: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
871: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
872: (
873: l_api_name,
874: G_PKG_NAME,
875: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 875: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

871: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
872: (
873: l_api_name,
874: G_PKG_NAME,
875: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
876: x_msg_count,
877: x_msg_data,
878: '_PVT'
879: );

Line 882: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

878: '_PVT'
879: );
880: WHEN OTHERS THEN
881: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Others) => '||SQLERRM);
882: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
883: (
884: l_api_name,
885: G_PKG_NAME,
886: 'OTHERS',