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.57.12020000.6 2013/01/28 12:48:24 venkatho 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 608: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'

604:
605: BEGIN
606:
607: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
608: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
609: ,'Begin(+)');
610: END IF;
611:
612: -- ------------------------

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

1101: l_tiltl_cnt := 0;
1102: l_tldtl_cnt := 0;
1103:
1104: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1105: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
1106: ,'End(-)');
1107: END IF;
1108:
1109: Okl_Api.END_ACTIVITY (

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

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',
1125: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1126: END IF;
1127:
1128: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

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

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',
1141: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1142: END IF;
1143:
1144: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

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

1152: WHEN OTHERS THEN
1153: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
1154:
1155: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
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 (

Line 1819: Okl_Stream_Billing_Pvt.get_customer_dtls (p_khr_id => p_bill_tbl(k).khr_id,

1815:
1816: IF (p_bill_tbl(k).khr_id IS NOT NULL )
1817: THEN
1818:
1819: Okl_Stream_Billing_Pvt.get_customer_dtls (p_khr_id => p_bill_tbl(k).khr_id,
1820: p_cust_acct_id => l_cust_acct_id,
1821: p_cust_party_id => l_cust_party_id);
1822: END IF;
1823:

Line 1827: l_bankruptcy_flag := Okl_Stream_Billing_Pvt.get_bankruptcy_status_new (p_cust_acct_id => l_cust_acct_id,

1823:
1824: IF (l_cust_acct_id IS NOT NULL AND l_cust_party_id IS NOT NULL)
1825: THEN
1826:
1827: l_bankruptcy_flag := Okl_Stream_Billing_Pvt.get_bankruptcy_status_new (p_cust_acct_id => l_cust_acct_id,
1828: p_cust_party_id => l_cust_party_id
1829: );
1830: END IF;
1831:

Line 1847: l_bankruptcy_flag := Okl_Stream_Billing_Pvt.get_bankruptcy_status_new (p_cust_acct_id => l_inv_cust_acct_id,

1843: -- Added as part of Bug: 15959293 -- START
1844: ELSIF (l_is_inv = 1 AND l_inv_cust_acct_id IS NOT NULL AND l_inv_party_id IS NOT NULL )
1845: THEN
1846:
1847: l_bankruptcy_flag := Okl_Stream_Billing_Pvt.get_bankruptcy_status_new (p_cust_acct_id => l_inv_cust_acct_id,
1848: p_cust_party_id => l_inv_party_id
1849: );
1850: IF (l_bankruptcy_flag = 'Y') THEN
1851:

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

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',
2490: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');
2491: END IF;
2492:
2493: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

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

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',
2506: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
2507: END IF;
2508:
2509: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

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

2517: WHEN OTHERS THEN
2518: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 3) => '||SQLERRM);
2519:
2520: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
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 (

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

3700:
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
3702:
3703: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3704: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3705: TO_CHAR(i) || ': ' || lx_msg_data);
3706: END IF;
3707:
3708: END LOOP;

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

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',
3725: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3726: END IF;
3727:
3728: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

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

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',
3741: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3742: END IF;
3743:
3744: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

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

3752: WHEN OTHERS THEN
3753: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 2) => '||SQLERRM);
3754:
3755: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
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 (

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

3799:
3800: BEGIN
3801:
3802: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3803: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
3804: ,'Begin(+)');
3805: END IF;
3806: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3807: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Start time Bill_Streams : '||TO_CHAR(SYSDATE, 'HH:MI:SS'));

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

3850: ,p_request_id => l_request_id); -- Bug 7584183
3851:
3852:
3853: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3854: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE,'okl_stream_billing_pvt'
3855: ,'End(-)');
3856: END IF;
3857:
3858: -- -------------------------------------------

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

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

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

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

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

3938: COMMIT;
3939: END IF;
3940:
3941: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
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 (

Line 3956: END Okl_Stream_Billing_Pvt;

3952: p_api_type => '_PVT');
3953:
3954: END bill_streams;
3955:
3956: END Okl_Stream_Billing_Pvt;