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 958: Okl_Api.END_ACTIVITY (

954: -- End processing
955: ------------------------------------------------------------
956:
957:
958: Okl_Api.END_ACTIVITY (
959: x_msg_count => x_msg_count,
960: x_msg_data => x_msg_data);
961:
962:

Line 973: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

969: -- Exception handling
970: ------------------------------------------------------------
971:
972:
973: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
974: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
975: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
976: p_api_name => l_api_name,
977: p_pkg_name => G_PKG_NAME,

Line 975: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

971:
972:
973: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
974: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
975: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
976: p_api_name => l_api_name,
977: p_pkg_name => G_PKG_NAME,
978: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
979: x_msg_count => x_msg_count,

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

974: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
975: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
976: p_api_name => l_api_name,
977: p_pkg_name => G_PKG_NAME,
978: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
979: x_msg_count => x_msg_count,
980: x_msg_data => x_msg_data,
981: p_api_type => '_PVT');
982:

Line 984: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

980: x_msg_data => x_msg_data,
981: p_api_type => '_PVT');
982:
983:
984: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
985: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
986: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
987: p_api_name => l_api_name,
988: p_pkg_name => G_PKG_NAME,

Line 986: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

982:
983:
984: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
985: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
986: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
987: p_api_name => l_api_name,
988: p_pkg_name => G_PKG_NAME,
989: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
990: x_msg_count => x_msg_count,

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

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

Line 997: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

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

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

1146:
1147:
1148: l_api_version CONSTANT NUMBER := 1;
1149: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
1150: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1151:
1152:
1153: ------------------------------------------------------------
1154: -- Declare variables to call Accounting Engine.

Line 1214: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1210: -- Start processing
1211: ------------------------------------------------------------
1212:
1213:
1214: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1215:
1216:
1217: l_return_status := Okl_Api.START_ACTIVITY(
1218: p_api_name => l_api_name,

Line 1217: l_return_status := Okl_Api.START_ACTIVITY(

1213:
1214: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1215:
1216:
1217: l_return_status := Okl_Api.START_ACTIVITY(
1218: p_api_name => l_api_name,
1219: p_pkg_name => G_PKG_NAME,
1220: p_init_msg_list => p_init_msg_list,
1221: l_api_version => l_api_version,

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

1223: p_api_type => '_PVT',
1224: x_return_status => l_return_status);
1225:
1226:
1227: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1228: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1229: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1230: RAISE Okl_Api.G_EXCEPTION_ERROR;
1231: END IF;

Line 1228: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1224: x_return_status => l_return_status);
1225:
1226:
1227: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1228: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1229: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1230: RAISE Okl_Api.G_EXCEPTION_ERROR;
1231: END IF;
1232:

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

1225:
1226:
1227: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1228: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1229: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1230: RAISE Okl_Api.G_EXCEPTION_ERROR;
1231: END IF;
1232:
1233:

Line 1230: RAISE Okl_Api.G_EXCEPTION_ERROR;

1226:
1227: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1228: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1229: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1230: RAISE Okl_Api.G_EXCEPTION_ERROR;
1231: END IF;
1232:
1233:
1234: ------------------------------------------------------------

Line 1462: Okl_Api.END_ACTIVITY (

1458: -- End processing
1459: ------------------------------------------------------------
1460:
1461:
1462: Okl_Api.END_ACTIVITY (
1463: x_msg_count => x_msg_count,
1464: x_msg_data => x_msg_data);
1465:
1466:

Line 1475: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1471: -- Exception handling
1472: ------------------------------------------------------------
1473:
1474:
1475: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1476: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1477: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1478: p_api_name => l_api_name,
1479: p_pkg_name => G_PKG_NAME,

Line 1477: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1473:
1474:
1475: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1476: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1477: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1478: p_api_name => l_api_name,
1479: p_pkg_name => G_PKG_NAME,
1480: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1481: x_msg_count => x_msg_count,

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

1476: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1477: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1478: p_api_name => l_api_name,
1479: p_pkg_name => G_PKG_NAME,
1480: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1481: x_msg_count => x_msg_count,
1482: x_msg_data => x_msg_data,
1483: p_api_type => '_PVT');
1484:

Line 1486: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1482: x_msg_data => x_msg_data,
1483: p_api_type => '_PVT');
1484:
1485:
1486: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1488: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1489: p_api_name => l_api_name,
1490: p_pkg_name => G_PKG_NAME,

Line 1488: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1484:
1485:
1486: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1488: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1489: p_api_name => l_api_name,
1490: p_pkg_name => G_PKG_NAME,
1491: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1492: x_msg_count => x_msg_count,

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

1487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1488: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1489: p_api_name => l_api_name,
1490: p_pkg_name => G_PKG_NAME,
1491: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1492: x_msg_count => x_msg_count,
1493: x_msg_data => x_msg_data,
1494: p_api_type => '_PVT');
1495:

Line 1499: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1495:
1496:
1497: WHEN OTHERS THEN
1498: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
1499: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1500: p_api_name => l_api_name,
1501: p_pkg_name => G_PKG_NAME,
1502: p_exc_name => 'OTHERS',
1503: x_msg_count => x_msg_count,

Line 1600: p_init_msg_list => Okl_Api.G_FALSE,

1596:
1597:
1598: ON_ACCT_Bill_adjustments (
1599: p_api_version => l_api_version,
1600: p_init_msg_list => Okl_Api.G_FALSE,
1601: x_return_status => lx_return_status,
1602: x_msg_count => lx_msg_count,
1603: x_msg_data => errbuf,
1604: p_contract_number => p_contract_number

Line 1621: p_init_msg_list => Okl_Api.G_FALSE,

1617:
1618:
1619: CM_Bill_adjustments (
1620: p_api_version => l_api_version,
1621: p_init_msg_list => Okl_Api.G_FALSE,
1622: x_return_status => lx_return_status,
1623: x_msg_count => lx_msg_count,
1624: x_msg_data => errbuf,
1625: p_contract_number => p_contract_number

Line 1644: p_init_msg_list => Okl_Api.G_FALSE,

1640:
1641:
1642: OKL_CUSTOM_PVT.CUSTOM_CM_Bill_adjustments (
1643: p_api_version => l_api_version,
1644: p_init_msg_list => Okl_Api.G_FALSE,
1645: x_return_status => lx_return_status,
1646: x_msg_count => lx_msg_count,
1647: x_msg_data => errbuf,
1648: p_contract_number => p_contract_number

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

1922:
1923:
1924: l_api_version CONSTANT NUMBER := 1;
1925: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
1926: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1927:
1928:
1929: ------------------------------------------------------------
1930: -- Declare variables to call Accounting Engine.

Line 2065: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2061: -- Start processing
2062: ------------------------------------------------------------
2063:
2064:
2065: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2066:
2067:
2068: l_return_status := Okl_Api.START_ACTIVITY(
2069: p_api_name => l_api_name,

Line 2068: l_return_status := Okl_Api.START_ACTIVITY(

2064:
2065: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2066:
2067:
2068: l_return_status := Okl_Api.START_ACTIVITY(
2069: p_api_name => l_api_name,
2070: p_pkg_name => G_PKG_NAME,
2071: p_init_msg_list => p_init_msg_list,
2072: l_api_version => l_api_version,

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

2074: p_api_type => '_PVT',
2075: x_return_status => l_return_status);
2076:
2077:
2078: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2079: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2080: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2081: RAISE Okl_Api.G_EXCEPTION_ERROR;
2082: END IF;

Line 2079: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2075: x_return_status => l_return_status);
2076:
2077:
2078: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2079: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2080: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2081: RAISE Okl_Api.G_EXCEPTION_ERROR;
2082: END IF;
2083:

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

2076:
2077:
2078: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2079: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2080: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2081: RAISE Okl_Api.G_EXCEPTION_ERROR;
2082: END IF;
2083:
2084:

Line 2081: RAISE Okl_Api.G_EXCEPTION_ERROR;

2077:
2078: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2079: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2080: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2081: RAISE Okl_Api.G_EXCEPTION_ERROR;
2082: END IF;
2083:
2084:
2085: ------------------------------------------------------------

Line 2491: Okl_Api.END_ACTIVITY (

2487: -- End processing
2488: ------------------------------------------------------------
2489:
2490:
2491: Okl_Api.END_ACTIVITY (
2492: x_msg_count => x_msg_count,
2493: x_msg_data => x_msg_data);
2494:
2495:

Line 2506: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2502: -- Exception handling
2503: ------------------------------------------------------------
2504:
2505:
2506: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2508: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2509: p_api_name => l_api_name,
2510: p_pkg_name => G_PKG_NAME,

Line 2508: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2504:
2505:
2506: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2508: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2509: p_api_name => l_api_name,
2510: p_pkg_name => G_PKG_NAME,
2511: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2512: x_msg_count => x_msg_count,

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

2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2508: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2509: p_api_name => l_api_name,
2510: p_pkg_name => G_PKG_NAME,
2511: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2512: x_msg_count => x_msg_count,
2513: x_msg_data => x_msg_data,
2514: p_api_type => '_PVT');
2515:

Line 2517: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2513: x_msg_data => x_msg_data,
2514: p_api_type => '_PVT');
2515:
2516:
2517: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2518: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2519: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2520: p_api_name => l_api_name,
2521: p_pkg_name => G_PKG_NAME,

Line 2519: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2515:
2516:
2517: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2518: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2519: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2520: p_api_name => l_api_name,
2521: p_pkg_name => G_PKG_NAME,
2522: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2523: x_msg_count => x_msg_count,

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

2518: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2519: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2520: p_api_name => l_api_name,
2521: p_pkg_name => G_PKG_NAME,
2522: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2523: x_msg_count => x_msg_count,
2524: x_msg_data => x_msg_data,
2525: p_api_type => '_PVT');
2526:

Line 2530: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2526:
2527:
2528: WHEN OTHERS THEN
2529: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
2530: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2531: p_api_name => l_api_name,
2532: p_pkg_name => G_PKG_NAME,
2533: p_exc_name => 'OTHERS',
2534: x_msg_count => x_msg_count,

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

2577:
2578:
2579: l_api_version CONSTANT NUMBER := 1;
2580: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
2581: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2582:
2583:
2584: ------------------------------------------------------------
2585: -- Declare variables to call Accounting Engine.

Line 2645: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2641: -- Start processing
2642: ------------------------------------------------------------
2643:
2644:
2645: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2646:
2647:
2648: l_return_status := Okl_Api.START_ACTIVITY(
2649: p_api_name => l_api_name,

Line 2648: l_return_status := Okl_Api.START_ACTIVITY(

2644:
2645: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2646:
2647:
2648: l_return_status := Okl_Api.START_ACTIVITY(
2649: p_api_name => l_api_name,
2650: p_pkg_name => G_PKG_NAME,
2651: p_init_msg_list => p_init_msg_list,
2652: l_api_version => l_api_version,

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

2654: p_api_type => '_PVT',
2655: x_return_status => l_return_status);
2656:
2657:
2658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2661: RAISE Okl_Api.G_EXCEPTION_ERROR;
2662: END IF;

Line 2659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2655: x_return_status => l_return_status);
2656:
2657:
2658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2661: RAISE Okl_Api.G_EXCEPTION_ERROR;
2662: END IF;
2663:

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

2656:
2657:
2658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2661: RAISE Okl_Api.G_EXCEPTION_ERROR;
2662: END IF;
2663:
2664:

Line 2661: RAISE Okl_Api.G_EXCEPTION_ERROR;

2657:
2658: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2659: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2660: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2661: RAISE Okl_Api.G_EXCEPTION_ERROR;
2662: END IF;
2663:
2664:
2665:

Line 2891: Okl_Api.END_ACTIVITY (

2887: -- End processing
2888: ------------------------------------------------------------
2889:
2890:
2891: Okl_Api.END_ACTIVITY (
2892: x_msg_count => x_msg_count,
2893: x_msg_data => x_msg_data);
2894:
2895:

Line 2904: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2900: -- Exception handling
2901: ------------------------------------------------------------
2902:
2903:
2904: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2907: p_api_name => l_api_name,
2908: p_pkg_name => G_PKG_NAME,

Line 2906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2902:
2903:
2904: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2907: p_api_name => l_api_name,
2908: p_pkg_name => G_PKG_NAME,
2909: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2910: x_msg_count => x_msg_count,

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

2905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2907: p_api_name => l_api_name,
2908: p_pkg_name => G_PKG_NAME,
2909: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2910: x_msg_count => x_msg_count,
2911: x_msg_data => x_msg_data,
2912: p_api_type => '_PVT');
2913:

Line 2915: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2911: x_msg_data => x_msg_data,
2912: p_api_type => '_PVT');
2913:
2914:
2915: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2916: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2917: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2918: p_api_name => l_api_name,
2919: p_pkg_name => G_PKG_NAME,

Line 2917: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2913:
2914:
2915: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2916: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2917: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2918: p_api_name => l_api_name,
2919: p_pkg_name => G_PKG_NAME,
2920: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2921: x_msg_count => x_msg_count,

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

2916: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2917: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2918: p_api_name => l_api_name,
2919: p_pkg_name => G_PKG_NAME,
2920: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2921: x_msg_count => x_msg_count,
2922: x_msg_data => x_msg_data,
2923: p_api_type => '_PVT');
2924:

Line 2928: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2924:
2925:
2926: WHEN OTHERS THEN
2927: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
2928: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2929: p_api_name => l_api_name,
2930: p_pkg_name => G_PKG_NAME,
2931: p_exc_name => 'OTHERS',
2932: x_msg_count => x_msg_count,

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

2956:
2957:
2958: l_api_version CONSTANT NUMBER := 1;
2959: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
2960: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2961:
2962:
2963: BEGIN
2964:

Line 2973: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2969: -- Start processing
2970: ------------------------------------------------------------
2971:
2972:
2973: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2974:
2975:
2976: l_return_status := Okl_Api.START_ACTIVITY(
2977: p_api_name => l_api_name,

Line 2976: l_return_status := Okl_Api.START_ACTIVITY(

2972:
2973: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2974:
2975:
2976: l_return_status := Okl_Api.START_ACTIVITY(
2977: p_api_name => l_api_name,
2978: p_pkg_name => G_PKG_NAME,
2979: p_init_msg_list => p_init_msg_list,
2980: l_api_version => l_api_version,

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

2982: p_api_type => '_PVT',
2983: x_return_status => l_return_status);
2984:
2985:
2986: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okl_Api.G_EXCEPTION_ERROR;
2990: END IF;

Line 2987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2983: x_return_status => l_return_status);
2984:
2985:
2986: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okl_Api.G_EXCEPTION_ERROR;
2990: END IF;
2991:

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

2984:
2985:
2986: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okl_Api.G_EXCEPTION_ERROR;
2990: END IF;
2991:
2992:

Line 2989: RAISE Okl_Api.G_EXCEPTION_ERROR;

2985:
2986: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okl_Api.G_EXCEPTION_ERROR;
2990: END IF;
2991:
2992:
2993: ------------------------------------------------------------

Line 3014: p_init_msg_list => Okl_Api.G_FALSE,

3010:
3011:
3012: ON_ACCT_Bill_adjustments (
3013: p_api_version => p_api_version,
3014: p_init_msg_list => Okl_Api.G_FALSE,
3015: x_return_status => x_return_status,
3016: x_msg_count => x_msg_count,
3017: x_msg_data => x_msg_data,
3018: p_rebook_adj_tbl => p_rebook_adj_tbl

Line 3035: p_init_msg_list => Okl_Api.G_FALSE,

3031:
3032:
3033: CM_Bill_adjustments (
3034: p_api_version => p_api_version,
3035: p_init_msg_list => Okl_Api.G_FALSE,
3036: x_return_status => x_return_status,
3037: x_msg_count => x_msg_count,
3038: x_msg_data => x_msg_data,
3039: p_commit => p_commit,

Line 3059: p_init_msg_list => Okl_Api.G_FALSE,

3055:
3056:
3057: OKL_CUSTOM_PVT.CUSTOM_CM_Bill_adjustments (
3058: p_api_version => p_api_version,
3059: p_init_msg_list => Okl_Api.G_FALSE,
3060: x_return_status => x_return_status,
3061: x_msg_count => x_msg_count,
3062: x_msg_data => x_msg_data,
3063: p_rebook_adj_tbl => p_rebook_adj_tbl

Line 3088: Okl_Api.END_ACTIVITY (

3084: -- End processing
3085: ------------------------------------------------------------
3086:
3087:
3088: Okl_Api.END_ACTIVITY (
3089: x_msg_count => x_msg_count,
3090: x_msg_data => x_msg_data);
3091:
3092:

Line 3101: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3097: -- Exception handling
3098: ------------------------------------------------------------
3099:
3100:
3101: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3103: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3104: p_api_name => l_api_name,
3105: p_pkg_name => G_PKG_NAME,

Line 3103: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3099:
3100:
3101: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3103: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3104: p_api_name => l_api_name,
3105: p_pkg_name => G_PKG_NAME,
3106: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3107: x_msg_count => x_msg_count,

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

3102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3103: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3104: p_api_name => l_api_name,
3105: p_pkg_name => G_PKG_NAME,
3106: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3107: x_msg_count => x_msg_count,
3108: x_msg_data => x_msg_data,
3109: p_api_type => '_PVT');
3110:

Line 3112: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3108: x_msg_data => x_msg_data,
3109: p_api_type => '_PVT');
3110:
3111:
3112: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3114: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3115: p_api_name => l_api_name,
3116: p_pkg_name => G_PKG_NAME,

Line 3114: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3110:
3111:
3112: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3114: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3115: p_api_name => l_api_name,
3116: p_pkg_name => G_PKG_NAME,
3117: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3118: x_msg_count => x_msg_count,

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

3113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3114: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3115: p_api_name => l_api_name,
3116: p_pkg_name => G_PKG_NAME,
3117: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3118: x_msg_count => x_msg_count,
3119: x_msg_data => x_msg_data,
3120: p_api_type => '_PVT');
3121:

Line 3125: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3121:
3122:
3123: WHEN OTHERS THEN
3124: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
3125: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3126: p_api_name => l_api_name,
3127: p_pkg_name => G_PKG_NAME,
3128: p_exc_name => 'OTHERS',
3129: x_msg_count => x_msg_count,