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

Line 25: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

21: -- Procedure BIL_STREAMS to bill outstanding stream elements
22: ------------------------------------------------------------------
23: PROCEDURE billing_charges(
24: p_api_version IN NUMBER
25: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ,x_msg_count OUT NOCOPY NUMBER
28: ,x_msg_data OUT NOCOPY VARCHAR2
29: ,p_name IN VARCHAR2 DEFAULT NULL

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

127: -- Declare variables required by APIs
128: ------------------------------------------------------------
129: l_api_version CONSTANT NUMBER := 1;
130: l_api_name CONSTANT VARCHAR2(30) := 'EXTERNAL_BILLING_CHARGES';
131: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
132: l_stm_id NUMBER;
133:
134: CURSOR c_stm_id ( p_khr_id NUMBER, p_sty_id NUMBER ) IS
135: SELECT id

Line 516: x_return_status := OKL_API.G_RET_STS_SUCCESS;

512:
513: ------------------------------------------------------------
514: -- Start processing
515: ------------------------------------------------------------
516: x_return_status := OKL_API.G_RET_STS_SUCCESS;
517:
518: l_return_status := OKL_API.START_ACTIVITY(
519: p_api_name => l_api_name
520: ,p_pkg_name => G_PKG_NAME

Line 518: l_return_status := OKL_API.START_ACTIVITY(

514: -- Start processing
515: ------------------------------------------------------------
516: x_return_status := OKL_API.G_RET_STS_SUCCESS;
517:
518: l_return_status := OKL_API.START_ACTIVITY(
519: p_api_name => l_api_name
520: ,p_pkg_name => G_PKG_NAME
521: ,p_init_msg_list => p_init_msg_list
522: ,l_api_version => l_api_version

Line 527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

523: ,p_api_version => p_api_version
524: ,p_api_type => '_PVT'
525: ,x_return_status => l_return_status);
526:
527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
530: RAISE Okl_Api.G_EXCEPTION_ERROR;
531: END IF;

Line 528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

524: ,p_api_type => '_PVT'
525: ,x_return_status => l_return_status);
526:
527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
530: RAISE Okl_Api.G_EXCEPTION_ERROR;
531: END IF;
532:

Line 529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

525: ,x_return_status => l_return_status);
526:
527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
530: RAISE Okl_Api.G_EXCEPTION_ERROR;
531: END IF;
532:
533: ------------------------------------------------------------

Line 530: RAISE Okl_Api.G_EXCEPTION_ERROR;

526:
527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
530: RAISE Okl_Api.G_EXCEPTION_ERROR;
531: END IF;
532:
533: ------------------------------------------------------------
534: -- Process every external billing line for billing import

Line 570: RAISE OKL_API.G_EXCEPTION_ERROR;

566: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');
568: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
569:
570: RAISE OKL_API.G_EXCEPTION_ERROR;
571: END IF;
572:
573: if l_request_id = -1 then
574: l_request_id := NULL;

Line 590: RAISE OKL_API.G_EXCEPTION_ERROR;

586: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
587: FND_FILE.PUT_LINE (FND_FILE.log,
588: 'Cannot determine request Id from profile. The function Fnd_Global.CONC_REQUEST_ID returns -1.');
589: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
590: RAISE OKL_API.G_EXCEPTION_ERROR;
591: END IF;
592:
593: -- -------------------------------
594: -- Process each cursor record

Line 1390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1386: IF x_return_status <> 'S' THEN
1387: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1388: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- ERROR: Creating Billing Transactions using Billing Engine');
1389: END IF;
1390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1391: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1392: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1393: RAISE Okl_Api.G_EXCEPTION_ERROR;
1394: END IF;

Line 1391: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1387: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1388: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- ERROR: Creating Billing Transactions using Billing Engine');
1389: END IF;
1390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1391: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1392: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1393: RAISE Okl_Api.G_EXCEPTION_ERROR;
1394: END IF;
1395: END IF;

Line 1392: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1388: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- ERROR: Creating Billing Transactions using Billing Engine');
1389: END IF;
1390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1391: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1392: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1393: RAISE Okl_Api.G_EXCEPTION_ERROR;
1394: END IF;
1395: END IF;
1396: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1393: RAISE Okl_Api.G_EXCEPTION_ERROR;

1389: END IF;
1390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1391: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1392: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1393: RAISE Okl_Api.G_EXCEPTION_ERROR;
1394: END IF;
1395: END IF;
1396: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1397: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - call to billing centralized API.');

Line 1905: Okl_Api.END_ACTIVITY (

1901: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End (-)');
1902: END IF;
1903: END IF;
1904:
1905: Okl_Api.END_ACTIVITY (
1906: x_msg_count => x_msg_count,
1907: x_msg_data => x_msg_data);
1908: EXCEPTION
1909: ------------------------------------------------------------

Line 1912: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1908: EXCEPTION
1909: ------------------------------------------------------------
1910: -- Exception handling
1911: ------------------------------------------------------------
1912: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1914: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1915: p_api_name => l_api_name,
1916: p_pkg_name => G_PKG_NAME,

Line 1914: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1910: -- Exception handling
1911: ------------------------------------------------------------
1912: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1914: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1915: p_api_name => l_api_name,
1916: p_pkg_name => G_PKG_NAME,
1917: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1918: x_msg_count => x_msg_count,

Line 1917: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

1913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1914: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1915: p_api_name => l_api_name,
1916: p_pkg_name => G_PKG_NAME,
1917: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1918: x_msg_count => x_msg_count,
1919: x_msg_data => x_msg_data,
1920: p_api_type => '_PVT');
1921: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1921: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1917: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1918: x_msg_count => x_msg_count,
1919: x_msg_data => x_msg_data,
1920: p_api_type => '_PVT');
1921: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1924: p_api_name => l_api_name,
1925: p_pkg_name => G_PKG_NAME,

Line 1923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1919: x_msg_data => x_msg_data,
1920: p_api_type => '_PVT');
1921: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1924: p_api_name => l_api_name,
1925: p_pkg_name => G_PKG_NAME,
1926: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1927: x_msg_count => x_msg_count,

Line 1926: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1924: p_api_name => l_api_name,
1925: p_pkg_name => G_PKG_NAME,
1926: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1927: x_msg_count => x_msg_count,
1928: x_msg_data => x_msg_data,
1929: p_api_type => '_PVT');
1930: WHEN OTHERS THEN

Line 1932: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1928: x_msg_data => x_msg_data,
1929: p_api_type => '_PVT');
1930: WHEN OTHERS THEN
1931: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1932: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1933: p_api_name => l_api_name,
1934: p_pkg_name => G_PKG_NAME,
1935: p_exc_name => 'OTHERS',
1936: x_msg_count => x_msg_count,