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

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

423: ,p_source IN VARCHAR2
424: ) IS
425:
426: l_api_name CONSTANT VARCHAR2(30) := 'BULK_PROCESS';
427: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
428: l_api_version CONSTANT NUMBER := 1;
429:
430: CURSOR acc_dstrs_csr( p_source_id IN NUMBER, p_source_table IN VARCHAR2 ) IS
431: SELECT CR_DR_FLAG,

Line 560: l_return_status := Okl_Api.START_ACTIVITY(

556: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
557: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_commit '||p_commit);
558:
559: END IF;
560: l_return_status := Okl_Api.START_ACTIVITY(
561: p_api_name => l_api_name,
562: p_pkg_name => G_PKG_NAME,
563: p_init_msg_list => p_init_msg_list,
564: l_api_version => l_api_version,

Line 810: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

806: x_dist_info_rec => l_dist_info_rec,
807: x_ctxt_val_tbl => l_ctxt_val_tbl,
808: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
809:
810: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
811: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
812: x_return_status := l_return_status;
813: END IF;
814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 811: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

807: x_ctxt_val_tbl => l_ctxt_val_tbl,
808: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
809:
810: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
811: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
812: x_return_status := l_return_status;
813: END IF;
814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: END IF;

Line 814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

810: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
811: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
812: x_return_status := l_return_status;
813: END IF;
814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: END IF;
816:
817: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST
818:

Line 868: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

864: x_amount_tbl => l_amount_out_tbl,
865: p_trx_header_id => l_trx_header_id,
866: p_trx_header_table => l_trx_header_tbl);
867:
868: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;

Line 869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

865: p_trx_header_id => l_trx_header_id,
866: p_trx_header_table => l_trx_header_tbl);
867:
868: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:

Line 870: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

866: p_trx_header_table => l_trx_header_tbl);
867:
868: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874: --DELETE local tables

Line 871: RAISE OKL_API.G_EXCEPTION_ERROR;

867:
868: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874: --DELETE local tables
875: l_acc_gen_tbl.DELETE;

Line 1047: Okl_Api.END_ACTIVITY (

1043: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
1044: ,'End(-)');
1045: END IF;
1046:
1047: Okl_Api.END_ACTIVITY (
1048: x_msg_count => x_msg_count,
1049: x_msg_data => x_msg_data);
1050:
1051:

Line 1058: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1054: ------------------------------------------------------------
1055: -- Exception handling
1056: ------------------------------------------------------------
1057:
1058: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1059: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1060:
1061: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1062: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

Line 1063: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

1059: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1060:
1061: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1062: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1063: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1064: END IF;
1065:
1066: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1067: p_api_name => l_api_name,

Line 1066: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1062: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1063: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1064: END IF;
1065:
1066: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1067: p_api_name => l_api_name,
1068: p_pkg_name => G_PKG_NAME,
1069: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1070: x_msg_count => x_msg_count,

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

1065:
1066: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1067: p_api_name => l_api_name,
1068: p_pkg_name => G_PKG_NAME,
1069: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1070: x_msg_count => x_msg_count,
1071: x_msg_data => x_msg_data,
1072: p_api_type => '_PVT');
1073:

Line 1074: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1070: x_msg_count => x_msg_count,
1071: x_msg_data => x_msg_data,
1072: p_api_type => '_PVT');
1073:
1074: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1076:
1077: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1078: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

Line 1079: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

1075: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1076:
1077: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1078: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1079: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1080: END IF;
1081:
1082: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1083: p_api_name => l_api_name,

Line 1082: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1078: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1079: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1080: END IF;
1081:
1082: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1083: p_api_name => l_api_name,
1084: p_pkg_name => G_PKG_NAME,
1085: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1086: x_msg_count => x_msg_count,

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

1081:
1082: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1083: p_api_name => l_api_name,
1084: p_pkg_name => G_PKG_NAME,
1085: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1086: x_msg_count => x_msg_count,
1087: x_msg_data => x_msg_data,
1088: p_api_type => '_PVT');
1089:

Line 1098: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1094: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1095: 'EXCEPTION :'||'OTHERS');
1096: END IF;
1097:
1098: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1099: p_api_name => l_api_name,
1100: p_pkg_name => G_PKG_NAME,
1101: p_exc_name => 'OTHERS',
1102: x_msg_count => x_msg_count,

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

1224: -- Declare variables required by APIs
1225: ------------------------------------------------------------
1226:
1227: l_api_version CONSTANT NUMBER := 1;
1228: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1229:
1230: ------------------------------------------------------------
1231: -- Variables for Error Processing and Committing Stream Billing
1232: -- Transactions

Line 1583: l_return_status := Okl_Api.START_ACTIVITY(

1579: END IF;
1580: ------------------------------------------------------------
1581: -- Start processing
1582: ------------------------------------------------------------
1583: l_return_status := Okl_Api.START_ACTIVITY(
1584: p_api_name => l_api_name,
1585: p_pkg_name => G_PKG_NAME,
1586: p_init_msg_list => p_init_msg_list,
1587: l_api_version => l_api_version,

Line 1593: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;

1589: p_api_type => '_PVT',
1590: x_return_status => l_return_status);
1591:
1592: IF l_overall_err_sts IS NULL THEN
1593: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
1594: END IF;
1595:
1596: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1597: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1596: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1592: IF l_overall_err_sts IS NULL THEN
1593: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
1594: END IF;
1595:
1596: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1597: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1598: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Start time Process_Bill_Tbl : '||TO_CHAR(SYSDATE, 'HH:MI:SS'));
1599: END IF;
1600: ------------------------------------------------------------

Line 2240: ,p_init_msg_list => OKL_API.G_FALSE

2236:
2237: -- make call to get invoice format API to get the formats
2238: OKL_INTERNAL_BILLING_PVT.Get_Invoice_format(
2239: p_api_version => p_api_version
2240: ,p_init_msg_list => OKL_API.G_FALSE
2241: ,x_return_status => l_return_status
2242: ,x_msg_count => lx_msg_count
2243: ,x_msg_data => lx_msg_data
2244: ,p_inf_id => tai_tbl(l_tai_cnt).inf_id

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

2245: ,p_sty_id => tld_tbl(l_tld_cnt).sty_id
2246: ,x_invoice_format_type => lx_invoice_format_type
2247: ,x_invoice_format_line_type => lx_invoice_format_line_type);
2248:
2249: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2251: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2252: RAISE OKL_API.G_EXCEPTION_ERROR;
2253: END IF;

Line 2250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2246: ,x_invoice_format_type => lx_invoice_format_type
2247: ,x_invoice_format_line_type => lx_invoice_format_line_type);
2248:
2249: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2251: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2252: RAISE OKL_API.G_EXCEPTION_ERROR;
2253: END IF;
2254:

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

2247: ,x_invoice_format_line_type => lx_invoice_format_line_type);
2248:
2249: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2251: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2252: RAISE OKL_API.G_EXCEPTION_ERROR;
2253: END IF;
2254:
2255: tld_tbl(l_tld_cnt).invoice_format_type := lx_invoice_format_type;

Line 2252: RAISE OKL_API.G_EXCEPTION_ERROR;

2248:
2249: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2251: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2252: RAISE OKL_API.G_EXCEPTION_ERROR;
2253: END IF;
2254:
2255: tld_tbl(l_tld_cnt).invoice_format_type := lx_invoice_format_type;
2256: tld_tbl(l_tld_cnt).invoice_format_line_type := lx_invoice_format_line_type;

Line 2295: Okl_Api.END_ACTIVITY (

2291: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End PROCESS_BILL_TBL (-)');
2292:
2293:
2294: END IF;
2295: Okl_Api.END_ACTIVITY (
2296: x_msg_count => x_msg_count,
2297: x_msg_data => x_msg_data);
2298:
2299: EXCEPTION

Line 2304: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2300: ------------------------------------------------------------
2301: -- Exception handling
2302: ------------------------------------------------------------
2303:
2304: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2305: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2306:
2307: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2308: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

Line 2309: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');

2305: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2306:
2307: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2308: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2309: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');
2310: END IF;
2311:
2312: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2313: p_api_name => l_api_name,

Line 2312: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2308: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2309: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');
2310: END IF;
2311:
2312: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2313: p_api_name => l_api_name,
2314: p_pkg_name => G_PKG_NAME,
2315: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2316: x_msg_count => x_msg_count,

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

2311:
2312: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2313: p_api_name => l_api_name,
2314: p_pkg_name => G_PKG_NAME,
2315: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2316: x_msg_count => x_msg_count,
2317: x_msg_data => x_msg_data,
2318: p_api_type => '_PVT');
2319:

Line 2320: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2316: x_msg_count => x_msg_count,
2317: x_msg_data => x_msg_data,
2318: p_api_type => '_PVT');
2319:
2320: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2321: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2322:
2323: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2324: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

Line 2325: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

2321: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2322:
2323: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2324: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2325: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
2326: END IF;
2327:
2328: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2329: p_api_name => l_api_name,

Line 2328: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2324: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2325: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
2326: END IF;
2327:
2328: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2329: p_api_name => l_api_name,
2330: p_pkg_name => G_PKG_NAME,
2331: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2332: x_msg_count => x_msg_count,

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

2327:
2328: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2329: p_api_name => l_api_name,
2330: p_pkg_name => G_PKG_NAME,
2331: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2332: x_msg_count => x_msg_count,
2333: x_msg_data => x_msg_data,
2334: p_api_type => '_PVT');
2335:

Line 2344: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2340: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2341: 'EXCEPTION (Process_bill_tbl):'||'OTHERS');
2342: END IF;
2343:
2344: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2345: p_api_name => l_api_name,
2346: p_pkg_name => G_PKG_NAME,
2347: p_exc_name => 'OTHERS',
2348: x_msg_count => x_msg_count,

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

2372: ,p_request_id IN NUMBER --Bug 7584183
2373: ) IS
2374:
2375: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS_MASTER';
2376: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2377: l_api_version CONSTANT NUMBER := 1;
2378:
2379: CURSOR c1 IS
2380: --1st select for all streams other than Property tax streams

Line 3109: l_return_status := Okl_Api.START_ACTIVITY(

3105:
3106:
3107: BEGIN
3108:
3109: l_return_status := Okl_Api.START_ACTIVITY(
3110: p_api_name => l_api_name,
3111: p_pkg_name => G_PKG_NAME,
3112: p_init_msg_list => p_init_msg_list,
3113: l_api_version => l_api_version,

Line 3522: Okl_Api.END_ACTIVITY (

3518: END LOOP;
3519: END IF;
3520:
3521:
3522: Okl_Api.END_ACTIVITY (
3523: x_msg_count => x_msg_count,
3524: x_msg_data => x_msg_data);
3525:
3526: EXCEPTION

Line 3530: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3526: EXCEPTION
3527: ------------------------------------------------------------
3528: -- Exception handling
3529: ------------------------------------------------------------
3530: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3531: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3532:
3533: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3534: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

Line 3535: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

3531: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3532:
3533: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3534: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3535: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3536: END IF;
3537:
3538: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3539: p_api_name => l_api_name,

Line 3538: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3534: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3535: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3536: END IF;
3537:
3538: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3539: p_api_name => l_api_name,
3540: p_pkg_name => G_PKG_NAME,
3541: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3542: x_msg_count => x_msg_count,

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

3537:
3538: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3539: p_api_name => l_api_name,
3540: p_pkg_name => G_PKG_NAME,
3541: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3542: x_msg_count => x_msg_count,
3543: x_msg_data => x_msg_data,
3544: p_api_type => '_PVT');
3545:

Line 3546: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3542: x_msg_count => x_msg_count,
3543: x_msg_data => x_msg_data,
3544: p_api_type => '_PVT');
3545:
3546: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3547: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3548:
3549: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3550: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

Line 3551: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

3547: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3548:
3549: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3550: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3551: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3552: END IF;
3553:
3554: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3555: p_api_name => l_api_name,

Line 3554: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3550: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3551: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3552: END IF;
3553:
3554: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3555: p_api_name => l_api_name,
3556: p_pkg_name => G_PKG_NAME,
3557: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3558: x_msg_count => x_msg_count,

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

3553:
3554: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3555: p_api_name => l_api_name,
3556: p_pkg_name => G_PKG_NAME,
3557: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3558: x_msg_count => x_msg_count,
3559: x_msg_data => x_msg_data,
3560: p_api_type => '_PVT');
3561:

Line 3570: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3566: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3567: 'EXCEPTION :'||'OTHERS');
3568: END IF;
3569:
3570: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3571: p_api_name => l_api_name,
3572: p_pkg_name => G_PKG_NAME,
3573: p_exc_name => 'OTHERS',
3574: x_msg_count => x_msg_count,

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

3596: ,p_source IN VARCHAR2
3597: ) IS
3598:
3599: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
3600: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3601: l_api_version CONSTANT NUMBER := 1;
3602: --Bug 7584183-Added by kkorrapo
3603: l_request_id NUMBER := -1;
3604: CURSOR req_id_csr IS

Line 3630: l_return_status := Okl_Api.START_ACTIVITY(

3626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_to_bill_date '||p_to_bill_date);
3627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_source '||p_source);
3628:
3629: END IF;
3630: l_return_status := Okl_Api.START_ACTIVITY(
3631: p_api_name => l_api_name,
3632: p_pkg_name => G_PKG_NAME,
3633: p_init_msg_list => p_init_msg_list,
3634: l_api_version => l_api_version,

Line 3680: Okl_Api.END_ACTIVITY (

3676: COMMIT;
3677:
3678: END IF;
3679:
3680: Okl_Api.END_ACTIVITY (
3681: x_msg_count => x_msg_count,
3682: x_msg_data => x_msg_data);
3683:
3684: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3698: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3694: ------------------------------------------------------------
3695: -- Exception handling
3696: ------------------------------------------------------------
3697:
3698: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3700:
3701: IF p_assigned_process IS NOT NULL THEN
3702: DELETE OKL_PARALLEL_PROCESSES

Line 3709: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

3705: END IF;
3706:
3707: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3708: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3709: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3710: END IF;
3711:
3712: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3713: p_api_name => l_api_name,

Line 3712: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3708: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3709: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3710: END IF;
3711:
3712: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3713: p_api_name => l_api_name,
3714: p_pkg_name => G_PKG_NAME,
3715: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3716: x_msg_count => x_msg_count,

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

3711:
3712: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3713: p_api_name => l_api_name,
3714: p_pkg_name => G_PKG_NAME,
3715: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3716: x_msg_count => x_msg_count,
3717: x_msg_data => x_msg_data,
3718: p_api_type => '_PVT');
3719:

Line 3720: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3716: x_msg_count => x_msg_count,
3717: x_msg_data => x_msg_data,
3718: p_api_type => '_PVT');
3719:
3720: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3721: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3722:
3723: IF p_assigned_process IS NOT NULL THEN
3724: DELETE OKL_PARALLEL_PROCESSES

Line 3731: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

3727: END IF;
3728:
3729: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3730: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3731: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3732: END IF;
3733:
3734: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3735: p_api_name => l_api_name,

Line 3734: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3730: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3731: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3732: END IF;
3733:
3734: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3735: p_api_name => l_api_name,
3736: p_pkg_name => G_PKG_NAME,
3737: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3738: x_msg_count => x_msg_count,

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

3733:
3734: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3735: p_api_name => l_api_name,
3736: p_pkg_name => G_PKG_NAME,
3737: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3738: x_msg_count => x_msg_count,
3739: x_msg_data => x_msg_data,
3740: p_api_type => '_PVT');
3741:

Line 3756: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3752: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3753: 'EXCEPTION :'||'OTHERS');
3754: END IF;
3755:
3756: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3757: p_api_name => l_api_name,
3758: p_pkg_name => G_PKG_NAME,
3759: p_exc_name => 'OTHERS',
3760: x_msg_count => x_msg_count,