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

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

367:
368:
369: l_api_version CONSTANT NUMBER := 1;
370: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
371: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
372:
373:
374: ------------------------------------------------------------
375: -- Declare variables to call Accounting Engine.

Line 502: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

Line 505: l_return_status := Okl_Api.START_ACTIVITY(

501:
502: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
503:
504:
505: l_return_status := Okl_Api.START_ACTIVITY(
506: p_api_name => l_api_name,
507: p_pkg_name => G_PKG_NAME,
508: p_init_msg_list => p_init_msg_list,
509: l_api_version => l_api_version,

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

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

Line 516: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

513:
514:
515: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
516: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
517: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
518: RAISE Okl_Api.G_EXCEPTION_ERROR;
519: END IF;
520:
521:

Line 518: RAISE Okl_Api.G_EXCEPTION_ERROR;

514:
515: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
516: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
517: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
518: RAISE Okl_Api.G_EXCEPTION_ERROR;
519: END IF;
520:
521:
522: ------------------------------------------------------------

Line 967: Okl_Api.END_ACTIVITY (

963: -- End processing
964: ------------------------------------------------------------
965:
966:
967: Okl_Api.END_ACTIVITY (
968: x_msg_count => x_msg_count,
969: x_msg_data => x_msg_data);
970:
971:

Line 982: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

978: -- Exception handling
979: ------------------------------------------------------------
980:
981:
982: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
984: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
985: p_api_name => l_api_name,
986: p_pkg_name => G_PKG_NAME,

Line 984: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

980:
981:
982: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
984: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
985: p_api_name => l_api_name,
986: p_pkg_name => G_PKG_NAME,
987: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
988: x_msg_count => x_msg_count,

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

983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
984: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
985: p_api_name => l_api_name,
986: p_pkg_name => G_PKG_NAME,
987: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
988: x_msg_count => x_msg_count,
989: x_msg_data => x_msg_data,
990: p_api_type => '_PVT');
991:

Line 993: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

989: x_msg_data => x_msg_data,
990: p_api_type => '_PVT');
991:
992:
993: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
994: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
995: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
996: p_api_name => l_api_name,
997: p_pkg_name => G_PKG_NAME,

Line 995: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

991:
992:
993: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
994: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
995: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
996: p_api_name => l_api_name,
997: p_pkg_name => G_PKG_NAME,
998: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
999: x_msg_count => x_msg_count,

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

994: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
995: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
996: p_api_name => l_api_name,
997: p_pkg_name => G_PKG_NAME,
998: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
999: x_msg_count => x_msg_count,
1000: x_msg_data => x_msg_data,
1001: p_api_type => '_PVT');
1002:

Line 1006: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1002:
1003:
1004: WHEN OTHERS THEN
1005: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
1006: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1007: p_api_name => l_api_name,
1008: p_pkg_name => G_PKG_NAME,
1009: p_exc_name => 'OTHERS',
1010: x_msg_count => x_msg_count,

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

1155:
1156:
1157: l_api_version CONSTANT NUMBER := 1;
1158: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
1159: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1160:
1161:
1162: ------------------------------------------------------------
1163: -- Declare variables to call Accounting Engine.

Line 1223: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1219: -- Start processing
1220: ------------------------------------------------------------
1221:
1222:
1223: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1224:
1225:
1226: l_return_status := Okl_Api.START_ACTIVITY(
1227: p_api_name => l_api_name,

Line 1226: l_return_status := Okl_Api.START_ACTIVITY(

1222:
1223: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1224:
1225:
1226: l_return_status := Okl_Api.START_ACTIVITY(
1227: p_api_name => l_api_name,
1228: p_pkg_name => G_PKG_NAME,
1229: p_init_msg_list => p_init_msg_list,
1230: l_api_version => l_api_version,

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

1232: p_api_type => '_PVT',
1233: x_return_status => l_return_status);
1234:
1235:
1236: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1239: RAISE Okl_Api.G_EXCEPTION_ERROR;
1240: END IF;

Line 1237: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1233: x_return_status => l_return_status);
1234:
1235:
1236: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1239: RAISE Okl_Api.G_EXCEPTION_ERROR;
1240: END IF;
1241:

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

1234:
1235:
1236: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1239: RAISE Okl_Api.G_EXCEPTION_ERROR;
1240: END IF;
1241:
1242:

Line 1239: RAISE Okl_Api.G_EXCEPTION_ERROR;

1235:
1236: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1239: RAISE Okl_Api.G_EXCEPTION_ERROR;
1240: END IF;
1241:
1242:
1243: ------------------------------------------------------------

Line 1477: Okl_Api.END_ACTIVITY (

1473: -- End processing
1474: ------------------------------------------------------------
1475:
1476:
1477: Okl_Api.END_ACTIVITY (
1478: x_msg_count => x_msg_count,
1479: x_msg_data => x_msg_data);
1480:
1481:

Line 1490: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1486: -- Exception handling
1487: ------------------------------------------------------------
1488:
1489:
1490: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1491: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1492: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1493: p_api_name => l_api_name,
1494: p_pkg_name => G_PKG_NAME,

Line 1492: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1488:
1489:
1490: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1491: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1492: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1493: p_api_name => l_api_name,
1494: p_pkg_name => G_PKG_NAME,
1495: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1496: x_msg_count => x_msg_count,

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

1491: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1492: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1493: p_api_name => l_api_name,
1494: p_pkg_name => G_PKG_NAME,
1495: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1496: x_msg_count => x_msg_count,
1497: x_msg_data => x_msg_data,
1498: p_api_type => '_PVT');
1499:

Line 1501: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1497: x_msg_data => x_msg_data,
1498: p_api_type => '_PVT');
1499:
1500:
1501: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1502: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1503: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1504: p_api_name => l_api_name,
1505: p_pkg_name => G_PKG_NAME,

Line 1503: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1499:
1500:
1501: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1502: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1503: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1504: p_api_name => l_api_name,
1505: p_pkg_name => G_PKG_NAME,
1506: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1507: x_msg_count => x_msg_count,

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

1502: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1503: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1504: p_api_name => l_api_name,
1505: p_pkg_name => G_PKG_NAME,
1506: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1507: x_msg_count => x_msg_count,
1508: x_msg_data => x_msg_data,
1509: p_api_type => '_PVT');
1510:

Line 1514: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1510:
1511:
1512: WHEN OTHERS THEN
1513: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
1514: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1515: p_api_name => l_api_name,
1516: p_pkg_name => G_PKG_NAME,
1517: p_exc_name => 'OTHERS',
1518: x_msg_count => x_msg_count,

Line 1615: p_init_msg_list => Okl_Api.G_FALSE,

1611:
1612:
1613: ON_ACCT_Bill_adjustments (
1614: p_api_version => l_api_version,
1615: p_init_msg_list => Okl_Api.G_FALSE,
1616: x_return_status => lx_return_status,
1617: x_msg_count => lx_msg_count,
1618: x_msg_data => errbuf,
1619: p_contract_number => p_contract_number

Line 1636: p_init_msg_list => Okl_Api.G_FALSE,

1632:
1633:
1634: CM_Bill_adjustments (
1635: p_api_version => l_api_version,
1636: p_init_msg_list => Okl_Api.G_FALSE,
1637: x_return_status => lx_return_status,
1638: x_msg_count => lx_msg_count,
1639: x_msg_data => errbuf,
1640: p_contract_number => p_contract_number

Line 1659: p_init_msg_list => Okl_Api.G_FALSE,

1655:
1656:
1657: OKL_CUSTOM_PVT.CUSTOM_CM_Bill_adjustments (
1658: p_api_version => l_api_version,
1659: p_init_msg_list => Okl_Api.G_FALSE,
1660: x_return_status => lx_return_status,
1661: x_msg_count => lx_msg_count,
1662: x_msg_data => errbuf,
1663: p_contract_number => p_contract_number

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

1937:
1938:
1939: l_api_version CONSTANT NUMBER := 1;
1940: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
1941: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1942:
1943:
1944: ------------------------------------------------------------
1945: -- Declare variables to call Accounting Engine.

Line 2080: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2076: -- Start processing
2077: ------------------------------------------------------------
2078:
2079:
2080: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2081:
2082:
2083: l_return_status := Okl_Api.START_ACTIVITY(
2084: p_api_name => l_api_name,

Line 2083: l_return_status := Okl_Api.START_ACTIVITY(

2079:
2080: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2081:
2082:
2083: l_return_status := Okl_Api.START_ACTIVITY(
2084: p_api_name => l_api_name,
2085: p_pkg_name => G_PKG_NAME,
2086: p_init_msg_list => p_init_msg_list,
2087: l_api_version => l_api_version,

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

2089: p_api_type => '_PVT',
2090: x_return_status => l_return_status);
2091:
2092:
2093: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2096: RAISE Okl_Api.G_EXCEPTION_ERROR;
2097: END IF;

Line 2094: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2090: x_return_status => l_return_status);
2091:
2092:
2093: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2096: RAISE Okl_Api.G_EXCEPTION_ERROR;
2097: END IF;
2098:

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

2091:
2092:
2093: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2096: RAISE Okl_Api.G_EXCEPTION_ERROR;
2097: END IF;
2098:
2099:

Line 2096: RAISE Okl_Api.G_EXCEPTION_ERROR;

2092:
2093: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2096: RAISE Okl_Api.G_EXCEPTION_ERROR;
2097: END IF;
2098:
2099:
2100: ------------------------------------------------------------

Line 2506: Okl_Api.END_ACTIVITY (

2502: -- End processing
2503: ------------------------------------------------------------
2504:
2505:
2506: Okl_Api.END_ACTIVITY (
2507: x_msg_count => x_msg_count,
2508: x_msg_data => x_msg_data);
2509:
2510:

Line 2521: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2517: -- Exception handling
2518: ------------------------------------------------------------
2519:
2520:
2521: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2524: p_api_name => l_api_name,
2525: p_pkg_name => G_PKG_NAME,

Line 2523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2519:
2520:
2521: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2524: p_api_name => l_api_name,
2525: p_pkg_name => G_PKG_NAME,
2526: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2527: x_msg_count => x_msg_count,

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

2522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2524: p_api_name => l_api_name,
2525: p_pkg_name => G_PKG_NAME,
2526: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2527: x_msg_count => x_msg_count,
2528: x_msg_data => x_msg_data,
2529: p_api_type => '_PVT');
2530:

Line 2532: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2528: x_msg_data => x_msg_data,
2529: p_api_type => '_PVT');
2530:
2531:
2532: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2535: p_api_name => l_api_name,
2536: p_pkg_name => G_PKG_NAME,

Line 2534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2530:
2531:
2532: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2535: p_api_name => l_api_name,
2536: p_pkg_name => G_PKG_NAME,
2537: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2538: x_msg_count => x_msg_count,

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

2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2535: p_api_name => l_api_name,
2536: p_pkg_name => G_PKG_NAME,
2537: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2538: x_msg_count => x_msg_count,
2539: x_msg_data => x_msg_data,
2540: p_api_type => '_PVT');
2541:

Line 2545: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2541:
2542:
2543: WHEN OTHERS THEN
2544: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
2545: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2546: p_api_name => l_api_name,
2547: p_pkg_name => G_PKG_NAME,
2548: p_exc_name => 'OTHERS',
2549: x_msg_count => x_msg_count,

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

2592:
2593:
2594: l_api_version CONSTANT NUMBER := 1;
2595: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
2596: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2597:
2598:
2599: ------------------------------------------------------------
2600: -- Declare variables to call Accounting Engine.

Line 2660: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2656: -- Start processing
2657: ------------------------------------------------------------
2658:
2659:
2660: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2661:
2662:
2663: l_return_status := Okl_Api.START_ACTIVITY(
2664: p_api_name => l_api_name,

Line 2663: l_return_status := Okl_Api.START_ACTIVITY(

2659:
2660: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2661:
2662:
2663: l_return_status := Okl_Api.START_ACTIVITY(
2664: p_api_name => l_api_name,
2665: p_pkg_name => G_PKG_NAME,
2666: p_init_msg_list => p_init_msg_list,
2667: l_api_version => l_api_version,

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

2669: p_api_type => '_PVT',
2670: x_return_status => l_return_status);
2671:
2672:
2673: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2674: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2675: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2676: RAISE Okl_Api.G_EXCEPTION_ERROR;
2677: END IF;

Line 2674: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2670: x_return_status => l_return_status);
2671:
2672:
2673: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2674: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2675: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2676: RAISE Okl_Api.G_EXCEPTION_ERROR;
2677: END IF;
2678:

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

2671:
2672:
2673: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2674: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2675: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2676: RAISE Okl_Api.G_EXCEPTION_ERROR;
2677: END IF;
2678:
2679:

Line 2676: RAISE Okl_Api.G_EXCEPTION_ERROR;

2672:
2673: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2674: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2675: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2676: RAISE Okl_Api.G_EXCEPTION_ERROR;
2677: END IF;
2678:
2679:
2680:

Line 2906: Okl_Api.END_ACTIVITY (

2902: -- End processing
2903: ------------------------------------------------------------
2904:
2905:
2906: Okl_Api.END_ACTIVITY (
2907: x_msg_count => x_msg_count,
2908: x_msg_data => x_msg_data);
2909:
2910:

Line 2919: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2915: -- Exception handling
2916: ------------------------------------------------------------
2917:
2918:
2919: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2920: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2921: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2922: p_api_name => l_api_name,
2923: p_pkg_name => G_PKG_NAME,

Line 2921: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2917:
2918:
2919: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2920: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2921: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2922: p_api_name => l_api_name,
2923: p_pkg_name => G_PKG_NAME,
2924: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2925: x_msg_count => x_msg_count,

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

2920: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2921: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2922: p_api_name => l_api_name,
2923: p_pkg_name => G_PKG_NAME,
2924: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2925: x_msg_count => x_msg_count,
2926: x_msg_data => x_msg_data,
2927: p_api_type => '_PVT');
2928:

Line 2930: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2926: x_msg_data => x_msg_data,
2927: p_api_type => '_PVT');
2928:
2929:
2930: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2931: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2932: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2933: p_api_name => l_api_name,
2934: p_pkg_name => G_PKG_NAME,

Line 2932: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2928:
2929:
2930: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2931: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2932: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2933: p_api_name => l_api_name,
2934: p_pkg_name => G_PKG_NAME,
2935: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2936: x_msg_count => x_msg_count,

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

2931: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2932: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2933: p_api_name => l_api_name,
2934: p_pkg_name => G_PKG_NAME,
2935: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2936: x_msg_count => x_msg_count,
2937: x_msg_data => x_msg_data,
2938: p_api_type => '_PVT');
2939:

Line 2943: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2939:
2940:
2941: WHEN OTHERS THEN
2942: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
2943: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2944: p_api_name => l_api_name,
2945: p_pkg_name => G_PKG_NAME,
2946: p_exc_name => 'OTHERS',
2947: x_msg_count => x_msg_count,

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

2971:
2972:
2973: l_api_version CONSTANT NUMBER := 1;
2974: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
2975: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2976:
2977:
2978: BEGIN
2979:

Line 2988: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2984: -- Start processing
2985: ------------------------------------------------------------
2986:
2987:
2988: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2989:
2990:
2991: l_return_status := Okl_Api.START_ACTIVITY(
2992: p_api_name => l_api_name,

Line 2991: l_return_status := Okl_Api.START_ACTIVITY(

2987:
2988: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2989:
2990:
2991: l_return_status := Okl_Api.START_ACTIVITY(
2992: p_api_name => l_api_name,
2993: p_pkg_name => G_PKG_NAME,
2994: p_init_msg_list => p_init_msg_list,
2995: l_api_version => l_api_version,

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

2997: p_api_type => '_PVT',
2998: x_return_status => l_return_status);
2999:
3000:
3001: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3003: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3004: RAISE Okl_Api.G_EXCEPTION_ERROR;
3005: END IF;

Line 3002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2998: x_return_status => l_return_status);
2999:
3000:
3001: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3003: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3004: RAISE Okl_Api.G_EXCEPTION_ERROR;
3005: END IF;
3006:

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

2999:
3000:
3001: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3003: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3004: RAISE Okl_Api.G_EXCEPTION_ERROR;
3005: END IF;
3006:
3007:

Line 3004: RAISE Okl_Api.G_EXCEPTION_ERROR;

3000:
3001: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3003: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3004: RAISE Okl_Api.G_EXCEPTION_ERROR;
3005: END IF;
3006:
3007:
3008: ------------------------------------------------------------

Line 3029: p_init_msg_list => Okl_Api.G_FALSE,

3025:
3026:
3027: ON_ACCT_Bill_adjustments (
3028: p_api_version => p_api_version,
3029: p_init_msg_list => Okl_Api.G_FALSE,
3030: x_return_status => x_return_status,
3031: x_msg_count => x_msg_count,
3032: x_msg_data => x_msg_data,
3033: p_rebook_adj_tbl => p_rebook_adj_tbl

Line 3050: p_init_msg_list => Okl_Api.G_FALSE,

3046:
3047:
3048: CM_Bill_adjustments (
3049: p_api_version => p_api_version,
3050: p_init_msg_list => Okl_Api.G_FALSE,
3051: x_return_status => x_return_status,
3052: x_msg_count => x_msg_count,
3053: x_msg_data => x_msg_data,
3054: p_commit => p_commit,

Line 3074: p_init_msg_list => Okl_Api.G_FALSE,

3070:
3071:
3072: OKL_CUSTOM_PVT.CUSTOM_CM_Bill_adjustments (
3073: p_api_version => p_api_version,
3074: p_init_msg_list => Okl_Api.G_FALSE,
3075: x_return_status => x_return_status,
3076: x_msg_count => x_msg_count,
3077: x_msg_data => x_msg_data,
3078: p_rebook_adj_tbl => p_rebook_adj_tbl

Line 3103: Okl_Api.END_ACTIVITY (

3099: -- End processing
3100: ------------------------------------------------------------
3101:
3102:
3103: Okl_Api.END_ACTIVITY (
3104: x_msg_count => x_msg_count,
3105: x_msg_data => x_msg_data);
3106:
3107:

Line 3116: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3112: -- Exception handling
3113: ------------------------------------------------------------
3114:
3115:
3116: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3118: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3119: p_api_name => l_api_name,
3120: p_pkg_name => G_PKG_NAME,

Line 3118: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3114:
3115:
3116: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3118: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3119: p_api_name => l_api_name,
3120: p_pkg_name => G_PKG_NAME,
3121: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3122: x_msg_count => x_msg_count,

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

3117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3118: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3119: p_api_name => l_api_name,
3120: p_pkg_name => G_PKG_NAME,
3121: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3122: x_msg_count => x_msg_count,
3123: x_msg_data => x_msg_data,
3124: p_api_type => '_PVT');
3125:

Line 3127: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3123: x_msg_data => x_msg_data,
3124: p_api_type => '_PVT');
3125:
3126:
3127: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3128: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3129: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3130: p_api_name => l_api_name,
3131: p_pkg_name => G_PKG_NAME,

Line 3129: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3125:
3126:
3127: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3128: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3129: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3130: p_api_name => l_api_name,
3131: p_pkg_name => G_PKG_NAME,
3132: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3133: x_msg_count => x_msg_count,

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

3128: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3129: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3130: p_api_name => l_api_name,
3131: p_pkg_name => G_PKG_NAME,
3132: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3133: x_msg_count => x_msg_count,
3134: x_msg_data => x_msg_data,
3135: p_api_type => '_PVT');
3136:

Line 3140: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3136:
3137:
3138: WHEN OTHERS THEN
3139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
3140: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3141: p_api_name => l_api_name,
3142: p_pkg_name => G_PKG_NAME,
3143: p_exc_name => 'OTHERS',
3144: x_msg_count => x_msg_count,