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 486: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

482: ,p_source IN VARCHAR2
483: ) IS
484:
485: l_api_name CONSTANT VARCHAR2(30) := 'BULK_PROCESS';
486: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
487: l_api_version CONSTANT NUMBER := 1;
488:
489: CURSOR acc_dstrs_csr( p_source_id IN NUMBER, p_source_table IN VARCHAR2 ) IS
490: SELECT CR_DR_FLAG,

Line 619: l_return_status := Okl_Api.START_ACTIVITY(

615: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_commit '||p_commit);
617:
618: END IF;
619: l_return_status := Okl_Api.START_ACTIVITY(
620: p_api_name => l_api_name,
621: p_pkg_name => G_PKG_NAME,
622: p_init_msg_list => p_init_msg_list,
623: l_api_version => l_api_version,

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

865: x_dist_info_rec => l_dist_info_rec,
866: x_ctxt_val_tbl => l_ctxt_val_tbl,
867: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
868:
869: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
870: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
871: x_return_status := l_return_status;
872: END IF;
873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

866: x_ctxt_val_tbl => l_ctxt_val_tbl,
867: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
868:
869: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
870: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
871: x_return_status := l_return_status;
872: END IF;
873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: END IF;

Line 873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

869: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
870: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
871: x_return_status := l_return_status;
872: END IF;
873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: END IF;
875:
876: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST
877:

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

923: x_amount_tbl => l_amount_out_tbl,
924: p_trx_header_id => l_trx_header_id,
925: p_trx_header_table => l_trx_header_tbl);
926:
927: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_ERROR;
931: END IF;

Line 928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

924: p_trx_header_id => l_trx_header_id,
925: p_trx_header_table => l_trx_header_tbl);
926:
927: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_ERROR;
931: END IF;
932:

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

925: p_trx_header_table => l_trx_header_tbl);
926:
927: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_ERROR;
931: END IF;
932:
933: --DELETE local tables

Line 930: RAISE OKL_API.G_EXCEPTION_ERROR;

926:
927: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_ERROR;
931: END IF;
932:
933: --DELETE local tables
934: l_acc_gen_tbl.DELETE;

Line 1109: Okl_Api.END_ACTIVITY (

1105: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
1106: ,'End(-)');
1107: END IF;
1108:
1109: Okl_Api.END_ACTIVITY (
1110: x_msg_count => x_msg_count,
1111: x_msg_data => x_msg_data);
1112:
1113:

Line 1120: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1116: ------------------------------------------------------------
1117: -- Exception handling
1118: ------------------------------------------------------------
1119:
1120: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1121: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1122:
1123: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1124: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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

1121: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1122:
1123: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1124: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1125: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1126: END IF;
1127:
1128: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1129: p_api_name => l_api_name,

Line 1128: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1124: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1125: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1126: END IF;
1127:
1128: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1129: p_api_name => l_api_name,
1130: p_pkg_name => G_PKG_NAME,
1131: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1132: x_msg_count => x_msg_count,

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

1127:
1128: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1129: p_api_name => l_api_name,
1130: p_pkg_name => G_PKG_NAME,
1131: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1132: x_msg_count => x_msg_count,
1133: x_msg_data => x_msg_data,
1134: p_api_type => '_PVT');
1135:

Line 1136: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1132: x_msg_count => x_msg_count,
1133: x_msg_data => x_msg_data,
1134: p_api_type => '_PVT');
1135:
1136: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1137: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1138:
1139: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1140: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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

1137: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1138:
1139: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1140: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1141: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1142: END IF;
1143:
1144: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1145: p_api_name => l_api_name,

Line 1144: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1140: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1141: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1142: END IF;
1143:
1144: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1145: p_api_name => l_api_name,
1146: p_pkg_name => G_PKG_NAME,
1147: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1148: x_msg_count => x_msg_count,

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

1143:
1144: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1145: p_api_name => l_api_name,
1146: p_pkg_name => G_PKG_NAME,
1147: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1148: x_msg_count => x_msg_count,
1149: x_msg_data => x_msg_data,
1150: p_api_type => '_PVT');
1151:

Line 1160: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1156: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1157: 'EXCEPTION :'||'OTHERS');
1158: END IF;
1159:
1160: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1161: p_api_name => l_api_name,
1162: p_pkg_name => G_PKG_NAME,
1163: p_exc_name => 'OTHERS',
1164: x_msg_count => x_msg_count,

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

1286: -- Declare variables required by APIs
1287: ------------------------------------------------------------
1288:
1289: l_api_version CONSTANT NUMBER := 1;
1290: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1291:
1292: ------------------------------------------------------------
1293: -- Variables for Error Processing and Committing Stream Billing
1294: -- Transactions

Line 1654: l_return_status := Okl_Api.START_ACTIVITY(

1650: END IF;
1651: ------------------------------------------------------------
1652: -- Start processing
1653: ------------------------------------------------------------
1654: l_return_status := Okl_Api.START_ACTIVITY(
1655: p_api_name => l_api_name,
1656: p_pkg_name => G_PKG_NAME,
1657: p_init_msg_list => p_init_msg_list,
1658: l_api_version => l_api_version,

Line 1664: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;

1660: p_api_type => '_PVT',
1661: x_return_status => l_return_status);
1662:
1663: IF l_overall_err_sts IS NULL THEN
1664: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
1665: END IF;
1666:
1667: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1668: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1667: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1663: IF l_overall_err_sts IS NULL THEN
1664: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
1665: END IF;
1666:
1667: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1668: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1669: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Start time Process_Bill_Tbl : '||TO_CHAR(SYSDATE, 'HH:MI:SS'));
1670: END IF;
1671: ------------------------------------------------------------

Line 2421: ,p_init_msg_list => OKL_API.G_FALSE

2417:
2418: -- make call to get invoice format API to get the formats
2419: OKL_INTERNAL_BILLING_PVT.Get_Invoice_format(
2420: p_api_version => p_api_version
2421: ,p_init_msg_list => OKL_API.G_FALSE
2422: ,x_return_status => l_return_status
2423: ,x_msg_count => lx_msg_count
2424: ,x_msg_data => lx_msg_data
2425: ,p_inf_id => tai_tbl(l_tai_cnt).inf_id

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

2426: ,p_sty_id => tld_tbl(l_tld_cnt).sty_id
2427: ,x_invoice_format_type => lx_invoice_format_type
2428: ,x_invoice_format_line_type => lx_invoice_format_line_type);
2429:
2430: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF;

Line 2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2427: ,x_invoice_format_type => lx_invoice_format_type
2428: ,x_invoice_format_line_type => lx_invoice_format_line_type);
2429:
2430: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF;
2435:

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

2428: ,x_invoice_format_line_type => lx_invoice_format_line_type);
2429:
2430: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF;
2435:
2436: tld_tbl(l_tld_cnt).invoice_format_type := lx_invoice_format_type;

Line 2433: RAISE OKL_API.G_EXCEPTION_ERROR;

2429:
2430: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF;
2435:
2436: tld_tbl(l_tld_cnt).invoice_format_type := lx_invoice_format_type;
2437: tld_tbl(l_tld_cnt).invoice_format_line_type := lx_invoice_format_line_type;

Line 2476: Okl_Api.END_ACTIVITY (

2472: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End PROCESS_BILL_TBL (-)');
2473:
2474:
2475: END IF;
2476: Okl_Api.END_ACTIVITY (
2477: x_msg_count => x_msg_count,
2478: x_msg_data => x_msg_data);
2479:
2480: EXCEPTION

Line 2485: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2481: ------------------------------------------------------------
2482: -- Exception handling
2483: ------------------------------------------------------------
2484:
2485: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2487:
2488: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2489: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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

2486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2487:
2488: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2489: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2490: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');
2491: END IF;
2492:
2493: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2494: p_api_name => l_api_name,

Line 2493: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2489: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2490: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');
2491: END IF;
2492:
2493: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2494: p_api_name => l_api_name,
2495: p_pkg_name => G_PKG_NAME,
2496: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2497: x_msg_count => x_msg_count,

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

2492:
2493: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2494: p_api_name => l_api_name,
2495: p_pkg_name => G_PKG_NAME,
2496: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2497: x_msg_count => x_msg_count,
2498: x_msg_data => x_msg_data,
2499: p_api_type => '_PVT');
2500:

Line 2501: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2497: x_msg_count => x_msg_count,
2498: x_msg_data => x_msg_data,
2499: p_api_type => '_PVT');
2500:
2501: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2502: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2503:
2504: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2505: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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

2502: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2503:
2504: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2505: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2506: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
2507: END IF;
2508:
2509: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2510: p_api_name => l_api_name,

Line 2509: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2505: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2506: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
2507: END IF;
2508:
2509: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2510: p_api_name => l_api_name,
2511: p_pkg_name => G_PKG_NAME,
2512: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2513: x_msg_count => x_msg_count,

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

2508:
2509: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2510: p_api_name => l_api_name,
2511: p_pkg_name => G_PKG_NAME,
2512: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2513: x_msg_count => x_msg_count,
2514: x_msg_data => x_msg_data,
2515: p_api_type => '_PVT');
2516:

Line 2525: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2521: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2522: 'EXCEPTION (Process_bill_tbl):'||'OTHERS');
2523: END IF;
2524:
2525: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2526: p_api_name => l_api_name,
2527: p_pkg_name => G_PKG_NAME,
2528: p_exc_name => 'OTHERS',
2529: x_msg_count => x_msg_count,

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

2553: ,p_request_id IN NUMBER --Bug 7584183
2554: ) IS
2555:
2556: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS_MASTER';
2557: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2558: l_api_version CONSTANT NUMBER := 1;
2559:
2560: --Bug# 9690217: Added stream element amount to ORDER BY clause
2561: -- to support grouping positive amounts into invoices

Line 3299: l_return_status := Okl_Api.START_ACTIVITY(

3295:
3296:
3297: BEGIN
3298:
3299: l_return_status := Okl_Api.START_ACTIVITY(
3300: p_api_name => l_api_name,
3301: p_pkg_name => G_PKG_NAME,
3302: p_init_msg_list => p_init_msg_list,
3303: l_api_version => l_api_version,

Line 3712: Okl_Api.END_ACTIVITY (

3708: END LOOP;
3709: END IF;
3710:
3711:
3712: Okl_Api.END_ACTIVITY (
3713: x_msg_count => x_msg_count,
3714: x_msg_data => x_msg_data);
3715:
3716: EXCEPTION

Line 3720: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3716: EXCEPTION
3717: ------------------------------------------------------------
3718: -- Exception handling
3719: ------------------------------------------------------------
3720: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3721: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3722:
3723: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3724: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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

3721: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3722:
3723: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3724: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3725: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3726: END IF;
3727:
3728: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3729: p_api_name => l_api_name,

Line 3728: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3724: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3725: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3726: END IF;
3727:
3728: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3729: p_api_name => l_api_name,
3730: p_pkg_name => G_PKG_NAME,
3731: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3732: x_msg_count => x_msg_count,

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

3727:
3728: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3729: p_api_name => l_api_name,
3730: p_pkg_name => G_PKG_NAME,
3731: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3732: x_msg_count => x_msg_count,
3733: x_msg_data => x_msg_data,
3734: p_api_type => '_PVT');
3735:

Line 3736: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3732: x_msg_count => x_msg_count,
3733: x_msg_data => x_msg_data,
3734: p_api_type => '_PVT');
3735:
3736: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3737: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3738:
3739: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3740: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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

3737: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3738:
3739: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3740: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3741: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3742: END IF;
3743:
3744: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3745: p_api_name => l_api_name,

Line 3744: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3740: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3741: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3742: END IF;
3743:
3744: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3745: p_api_name => l_api_name,
3746: p_pkg_name => G_PKG_NAME,
3747: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3748: x_msg_count => x_msg_count,

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

3743:
3744: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3745: p_api_name => l_api_name,
3746: p_pkg_name => G_PKG_NAME,
3747: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3748: x_msg_count => x_msg_count,
3749: x_msg_data => x_msg_data,
3750: p_api_type => '_PVT');
3751:

Line 3760: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

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

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

3786: ,p_source IN VARCHAR2
3787: ) IS
3788:
3789: l_api_name CONSTANT VARCHAR2(30) := 'BILL_STREAMS';
3790: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3791: l_api_version CONSTANT NUMBER := 1;
3792: --Bug 7584183-Added by kkorrapo
3793: l_request_id NUMBER := -1;
3794: CURSOR req_id_csr IS

Line 3820: l_return_status := Okl_Api.START_ACTIVITY(

3816: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_to_bill_date '||p_to_bill_date);
3817: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_source '||p_source);
3818:
3819: END IF;
3820: l_return_status := Okl_Api.START_ACTIVITY(
3821: p_api_name => l_api_name,
3822: p_pkg_name => G_PKG_NAME,
3823: p_init_msg_list => p_init_msg_list,
3824: l_api_version => l_api_version,

Line 3870: Okl_Api.END_ACTIVITY (

3866: COMMIT;
3867:
3868: END IF;
3869:
3870: Okl_Api.END_ACTIVITY (
3871: x_msg_count => x_msg_count,
3872: x_msg_data => x_msg_data);
3873:
3874: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3888: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3884: ------------------------------------------------------------
3885: -- Exception handling
3886: ------------------------------------------------------------
3887:
3888: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3889: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3890:
3891: IF p_assigned_process IS NOT NULL THEN
3892: DELETE OKL_PARALLEL_PROCESSES

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

3895: END IF;
3896:
3897: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3898: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3899: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3900: END IF;
3901:
3902: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3903: p_api_name => l_api_name,

Line 3902: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3898: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3899: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3900: END IF;
3901:
3902: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3903: p_api_name => l_api_name,
3904: p_pkg_name => G_PKG_NAME,
3905: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3906: x_msg_count => x_msg_count,

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

3901:
3902: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3903: p_api_name => l_api_name,
3904: p_pkg_name => G_PKG_NAME,
3905: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3906: x_msg_count => x_msg_count,
3907: x_msg_data => x_msg_data,
3908: p_api_type => '_PVT');
3909:

Line 3910: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3906: x_msg_count => x_msg_count,
3907: x_msg_data => x_msg_data,
3908: p_api_type => '_PVT');
3909:
3910: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3911: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3912:
3913: IF p_assigned_process IS NOT NULL THEN
3914: DELETE OKL_PARALLEL_PROCESSES

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

3917: END IF;
3918:
3919: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3920: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3921: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3922: END IF;
3923:
3924: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3925: p_api_name => l_api_name,

Line 3924: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3920: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3921: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3922: END IF;
3923:
3924: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3925: p_api_name => l_api_name,
3926: p_pkg_name => G_PKG_NAME,
3927: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3928: x_msg_count => x_msg_count,

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

3923:
3924: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3925: p_api_name => l_api_name,
3926: p_pkg_name => G_PKG_NAME,
3927: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3928: x_msg_count => x_msg_count,
3929: x_msg_data => x_msg_data,
3930: p_api_type => '_PVT');
3931:

Line 3946: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3942: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3943: 'EXCEPTION :'||'OTHERS');
3944: END IF;
3945:
3946: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3947: p_api_name => l_api_name,
3948: p_pkg_name => G_PKG_NAME,
3949: p_exc_name => 'OTHERS',
3950: x_msg_count => x_msg_count,