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_STREAM_BILLING_PVT

Line 1: PACKAGE BODY Okl_Stream_Billing_Pvt AS

1: PACKAGE BODY Okl_Stream_Billing_Pvt AS
2: /* $Header: OKLRBSTB.pls 120.49.12010000.3 2008/12/12 20:27:10 cklee ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 549: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'

545:
546: BEGIN
547:
548: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
549: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
550: ,'Begin(+)');
551: END IF;
552:
553: -- ------------------------

Line 1043: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'

1039: l_tiltl_cnt := 0;
1040: l_tldtl_cnt := 0;
1041:
1042: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1043: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
1044: ,'End(-)');
1045: END IF;
1046:
1047: Okl_Api.END_ACTIVITY (

Line 1062: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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',
1063: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1064: END IF;
1065:
1066: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 1078: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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',
1079: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1080: END IF;
1081:
1082: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 1094: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

1090: WHEN OTHERS THEN
1091: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
1092:
1093: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
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 (

Line 2308: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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',
2309: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');
2310: END IF;
2311:
2312: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 2324: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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',
2325: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
2326: END IF;
2327:
2328: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 2340: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

2336: WHEN OTHERS THEN
2337: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 3) => '||SQLERRM);
2338:
2339: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
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 (

Line 3514: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

3510:
3511: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
3512:
3513: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3514: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3515: TO_CHAR(i) || ': ' || lx_msg_data);
3516: END IF;
3517:
3518: END LOOP;

Line 3534: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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',
3535: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3536: END IF;
3537:
3538: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 3550: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

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',
3551: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3552: END IF;
3553:
3554: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

Line 3566: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

3562: WHEN OTHERS THEN
3563: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 2) => '||SQLERRM);
3564:
3565: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
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 (

Line 3613: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'

3609:
3610: BEGIN
3611:
3612: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3613: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
3614: ,'Begin(+)');
3615: END IF;
3616: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Start time Bill_Streams : '||TO_CHAR(SYSDATE, 'HH:MI:SS'));

Line 3664: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'

3660: ,p_request_id => l_request_id); -- Bug 7584183
3661:
3662:
3663: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3664: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
3665: ,'End(-)');
3666: END IF;
3667:
3668: -- -------------------------------------------

Line 3708: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

3704: COMMIT;
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 (

Line 3730: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

3726: COMMIT;
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 (

Line 3752: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',

3748: COMMIT;
3749: END IF;
3750:
3751: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
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 (

Line 3766: END Okl_Stream_Billing_Pvt;

3762: p_api_type => '_PVT');
3763:
3764: END bill_streams;
3765:
3766: END Okl_Stream_Billing_Pvt;