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 502: x_return_status := OKL_API.G_RET_STS_SUCCESS;

498:
499: ------------------------------------------------------------
500: -- Start processing
501: ------------------------------------------------------------
502: x_return_status := OKL_API.G_RET_STS_SUCCESS;
503:
504: l_return_status := OKL_API.START_ACTIVITY(
505: p_api_name => l_api_name
506: ,p_pkg_name => G_PKG_NAME

Line 504: l_return_status := OKL_API.START_ACTIVITY(

500: -- Start processing
501: ------------------------------------------------------------
502: x_return_status := OKL_API.G_RET_STS_SUCCESS;
503:
504: l_return_status := OKL_API.START_ACTIVITY(
505: p_api_name => l_api_name
506: ,p_pkg_name => G_PKG_NAME
507: ,p_init_msg_list => p_init_msg_list
508: ,l_api_version => l_api_version

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

509: ,p_api_version => p_api_version
510: ,p_api_type => '_PVT'
511: ,x_return_status => l_return_status);
512:
513: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
514: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
515: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
516: RAISE Okl_Api.G_EXCEPTION_ERROR;
517: END IF;

Line 514: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

510: ,p_api_type => '_PVT'
511: ,x_return_status => l_return_status);
512:
513: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
514: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
515: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
516: RAISE Okl_Api.G_EXCEPTION_ERROR;
517: END IF;
518:

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

511: ,x_return_status => l_return_status);
512:
513: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
514: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
515: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
516: RAISE Okl_Api.G_EXCEPTION_ERROR;
517: END IF;
518:
519: ------------------------------------------------------------

Line 516: RAISE Okl_Api.G_EXCEPTION_ERROR;

512:
513: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
514: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
515: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
516: RAISE Okl_Api.G_EXCEPTION_ERROR;
517: END IF;
518:
519: ------------------------------------------------------------
520: -- Process every external billing line for billing import

Line 556: RAISE OKL_API.G_EXCEPTION_ERROR;

552: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
553: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');
554: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
555:
556: RAISE OKL_API.G_EXCEPTION_ERROR;
557: END IF;
558:
559: if l_request_id = -1 then
560: l_request_id := NULL;

Line 576: RAISE OKL_API.G_EXCEPTION_ERROR;

572: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
573: FND_FILE.PUT_LINE (FND_FILE.log,
574: 'Cannot determine request Id from profile. The function Fnd_Global.CONC_REQUEST_ID returns -1.');
575: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:
579: -- -------------------------------
580: -- Process each cursor record

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

1314: IF x_return_status <> 'S' THEN
1315: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- ERROR: Creating Billing Transactions using Billing Engine');
1317: END IF;
1318: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1321: RAISE Okl_Api.G_EXCEPTION_ERROR;
1322: END IF;

Line 1319: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1315: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- ERROR: Creating Billing Transactions using Billing Engine');
1317: END IF;
1318: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1321: RAISE Okl_Api.G_EXCEPTION_ERROR;
1322: END IF;
1323: END IF;

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

1316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- ERROR: Creating Billing Transactions using Billing Engine');
1317: END IF;
1318: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1321: RAISE Okl_Api.G_EXCEPTION_ERROR;
1322: END IF;
1323: END IF;
1324: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1321: RAISE Okl_Api.G_EXCEPTION_ERROR;

1317: END IF;
1318: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1321: RAISE Okl_Api.G_EXCEPTION_ERROR;
1322: END IF;
1323: END IF;
1324: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1325: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - call to billing centralized API.');

Line 1833: Okl_Api.END_ACTIVITY (

1829: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End (-)');
1830: END IF;
1831: END IF;
1832:
1833: Okl_Api.END_ACTIVITY (
1834: x_msg_count => x_msg_count,
1835: x_msg_data => x_msg_data);
1836: EXCEPTION
1837: ------------------------------------------------------------

Line 1840: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1836: EXCEPTION
1837: ------------------------------------------------------------
1838: -- Exception handling
1839: ------------------------------------------------------------
1840: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1841: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1842: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1843: p_api_name => l_api_name,
1844: p_pkg_name => G_PKG_NAME,

Line 1842: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1838: -- Exception handling
1839: ------------------------------------------------------------
1840: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1841: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1842: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1843: p_api_name => l_api_name,
1844: p_pkg_name => G_PKG_NAME,
1845: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1846: x_msg_count => x_msg_count,

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

1841: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1842: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1843: p_api_name => l_api_name,
1844: p_pkg_name => G_PKG_NAME,
1845: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1846: x_msg_count => x_msg_count,
1847: x_msg_data => x_msg_data,
1848: p_api_type => '_PVT');
1849: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1849: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1845: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1846: x_msg_count => x_msg_count,
1847: x_msg_data => x_msg_data,
1848: p_api_type => '_PVT');
1849: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1850: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1851: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1852: p_api_name => l_api_name,
1853: p_pkg_name => G_PKG_NAME,

Line 1851: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1847: x_msg_data => x_msg_data,
1848: p_api_type => '_PVT');
1849: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1850: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1851: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1852: p_api_name => l_api_name,
1853: p_pkg_name => G_PKG_NAME,
1854: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1855: x_msg_count => x_msg_count,

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

1850: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1851: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1852: p_api_name => l_api_name,
1853: p_pkg_name => G_PKG_NAME,
1854: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1855: x_msg_count => x_msg_count,
1856: x_msg_data => x_msg_data,
1857: p_api_type => '_PVT');
1858: WHEN OTHERS THEN

Line 1860: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1856: x_msg_data => x_msg_data,
1857: p_api_type => '_PVT');
1858: WHEN OTHERS THEN
1859: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1860: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1861: p_api_name => l_api_name,
1862: p_pkg_name => G_PKG_NAME,
1863: p_exc_name => 'OTHERS',
1864: x_msg_count => x_msg_count,