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

Line 32: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

28: --1. need to tune the sql for the cursor, gives full scan for ra_customer_trx_lines_all
29:
30: PROCEDURE Last_Invoice_Date(
31: p_api_version IN NUMBER
32: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
33: ,x_return_status OUT NOCOPY VARCHAR2
34: ,x_msg_count OUT NOCOPY NUMBER
35: ,x_msg_data OUT NOCOPY VARCHAR2
36: ,p_contract_id IN NUMBER

Line 68: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

64: IF c_last_invoice_date%ISOPEN THEN
65: CLOSE c_last_invoice_date;
66: END IF;
67:
68: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
69: p_api_name => l_api_name,
70: p_pkg_name => G_PKG_NAME,
71: p_exc_name => 'OTHERS',
72: x_msg_count => x_msg_count,

Line 103: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

99: -- Comments:
100: --
101: PROCEDURE INVOICE_AMOUNT_FOR_STREAM(
102: p_api_version IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
104: ,x_return_status OUT NOCOPY VARCHAR2
105: ,x_msg_count OUT NOCOPY NUMBER
106: ,x_msg_data OUT NOCOPY VARCHAR2
107: ,p_stream_purpose IN VARCHAR2

Line 140: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

136: x_return_status := 'S';
137: EXCEPTION
138: WHEN OTHERS THEN
139:
140: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
141: p_api_name => l_api_name,
142: p_pkg_name => G_PKG_NAME,
143: p_exc_name => 'OTHERS',
144: x_msg_count => x_msg_count,

Line 587: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

583: END;
584:
585: PROCEDURE get_tld_balance(
586: p_api_version IN NUMBER
587: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
588: ,p_tld_id IN NUMBER
589: ,x_return_status OUT NOCOPY VARCHAR2
590: ,x_msg_count OUT NOCOPY NUMBER
591: ,x_msg_data OUT NOCOPY VARCHAR2

Line 672: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

668:
669: EXCEPTION
670: WHEN OTHERS THEN
671:
672: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
673: p_api_name => l_api_name,
674: p_pkg_name => G_PKG_NAME,
675: p_exc_name => 'OTHERS',
676: x_msg_count => x_msg_count,

Line 686: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

682:
683:
684: PROCEDURE get_contract_invoice_balance(
685: p_api_version IN NUMBER
686: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
687: ,p_contract_number IN VARCHAR2
688: ,p_trx_number IN VARCHAR2
689: ,x_return_status OUT NOCOPY VARCHAR2
690: ,x_msg_count OUT NOCOPY NUMBER

Line 724: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

720:
721: EXCEPTION
722: WHEN OTHERS THEN
723:
724: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
725: p_api_name => l_api_name,
726: p_pkg_name => G_PKG_NAME,
727: p_exc_name => 'OTHERS',
728: x_msg_count => x_msg_count,

Line 887: l_init_msg_list := Okl_Api.G_TRUE;

883: x_errbuf := null;
884: x_any_data_exists := FALSE;
885:
886: l_api_version := 1.0;
887: l_init_msg_list := Okl_Api.G_TRUE;
888: l_msg_count := 0;
889:
890: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
891: G_PKG_NAME,

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

886: l_api_version := 1.0;
887: l_init_msg_list := Okl_Api.G_TRUE;
888: l_msg_count := 0;
889:
890: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
891: G_PKG_NAME,
892: l_init_msg_list,
893: l_api_version,
894: l_api_version,

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

893: l_api_version,
894: l_api_version,
895: '_PVT',
896: l_return_status);
897: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: RAISE OKL_API.G_EXCEPTION_ERROR;
901: END IF;

Line 898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

894: l_api_version,
895: '_PVT',
896: l_return_status);
897: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: RAISE OKL_API.G_EXCEPTION_ERROR;
901: END IF;
902:

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

895: '_PVT',
896: l_return_status);
897: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: RAISE OKL_API.G_EXCEPTION_ERROR;
901: END IF;
902:
903: -- Printing In Process Billing Transactions report header. The formatting of the message titles is

Line 900: RAISE OKL_API.G_EXCEPTION_ERROR;

896: l_return_status);
897: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: RAISE OKL_API.G_EXCEPTION_ERROR;
901: END IF;
902:
903: -- Printing In Process Billing Transactions report header. The formatting of the message titles is
904: -- also taken care here.

Line 1046: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

1042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/
1043: END IF;
1044: CLOSE cnsld_pstv_check_csr;
1045:
1046: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
1047: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1048: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRUPGB.pls call IN_PROCESS_BILLING_TXN');
1049: END IF;
1050: