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 740: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

736: END;
737:
738: PROCEDURE get_tld_balance(
739: p_api_version IN NUMBER
740: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
741: ,p_tld_id IN NUMBER
742: ,x_return_status OUT NOCOPY VARCHAR2
743: ,x_msg_count OUT NOCOPY NUMBER
744: ,x_msg_data OUT NOCOPY VARCHAR2

Line 825: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

821:
822: EXCEPTION
823: WHEN OTHERS THEN
824:
825: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
826: p_api_name => l_api_name,
827: p_pkg_name => G_PKG_NAME,
828: p_exc_name => 'OTHERS',
829: x_msg_count => x_msg_count,

Line 839: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

835:
836:
837: PROCEDURE get_contract_invoice_balance(
838: p_api_version IN NUMBER
839: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
840: ,p_contract_number IN VARCHAR2
841: ,p_trx_number IN VARCHAR2
842: ,x_return_status OUT NOCOPY VARCHAR2
843: ,x_msg_count OUT NOCOPY NUMBER

Line 877: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

873:
874: EXCEPTION
875: WHEN OTHERS THEN
876:
877: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
878: p_api_name => l_api_name,
879: p_pkg_name => G_PKG_NAME,
880: p_exc_name => 'OTHERS',
881: x_msg_count => x_msg_count,

Line 1040: l_init_msg_list := Okl_Api.G_TRUE;

1036: x_errbuf := null;
1037: x_any_data_exists := FALSE;
1038:
1039: l_api_version := 1.0;
1040: l_init_msg_list := Okl_Api.G_TRUE;
1041: l_msg_count := 0;
1042:
1043: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
1044: G_PKG_NAME,

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

1039: l_api_version := 1.0;
1040: l_init_msg_list := Okl_Api.G_TRUE;
1041: l_msg_count := 0;
1042:
1043: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
1044: G_PKG_NAME,
1045: l_init_msg_list,
1046: l_api_version,
1047: l_api_version,

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

1046: l_api_version,
1047: l_api_version,
1048: '_PVT',
1049: l_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;

Line 1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1047: l_api_version,
1048: '_PVT',
1049: l_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;
1055:

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

1048: '_PVT',
1049: l_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;
1055:
1056: -- Printing In Process Billing Transactions report header. The formatting of the message titles is

Line 1053: RAISE OKL_API.G_EXCEPTION_ERROR;

1049: l_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;
1055:
1056: -- Printing In Process Billing Transactions report header. The formatting of the message titles is
1057: -- also taken care here.

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

1195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/
1196: END IF;
1197: CLOSE cnsld_pstv_check_csr;
1198:
1199: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
1200: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1201: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRUPGB.pls call IN_PROCESS_BILLING_TXN');
1202: END IF;
1203:

Line 1698: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1694:
1695: --Added by bkatraga for bug 12378106
1696: PROCEDURE CR_INVOICE_AMOUNT_FOR_STREAM(
1697: p_api_version IN NUMBER
1698: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1699: ,x_return_status OUT NOCOPY VARCHAR2
1700: ,x_msg_count OUT NOCOPY NUMBER
1701: ,x_msg_data OUT NOCOPY VARCHAR2
1702: ,p_stream_purpose IN VARCHAR2

Line 1759: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1755: x_tot_inv_line_amount := NVL(x_tot_inv_line_amount, 0);
1756: x_return_status := 'S';
1757: EXCEPTION
1758: WHEN OTHERS THEN
1759: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1760: p_api_name => l_api_name,
1761: p_pkg_name => G_PKG_NAME,
1762: p_exc_name => 'OTHERS',
1763: x_msg_count => x_msg_count,