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_CREATE_STREAMS_PVT dependencies on OKL_SIF_FEES

Line 880: --sechawla 24-jul-09 For subsidy line in okl_sif_fees, orig_contract_line_id

876: l_sfev_one_off_tbl(i).kle_id := p_csm_one_off_fee_tbl(i).other_type_id;
877:
878: --sechawla 15-jul-09 PRB ESG Enhancements : assign orig_contract_line_id
879: --IF l_PROSPECTIVE_REBOOK_YN = 'Y' then
880: --sechawla 24-jul-09 For subsidy line in okl_sif_fees, orig_contract_line_id
881: -- should be the orig_contract_line_id corresponding to subsidy line, not financial asset line
882: open get_orig_subsidy_line_id(p_csm_one_off_fee_tbl(i).other_type_id);
883: fetch get_orig_subsidy_line_id into l_sfev_one_off_tbl(i).orig_contract_line_id;
884: close get_orig_subsidy_line_id;

Line 1285: CURSOR l_okl_sfe_ids_csr(p_sif_id IN OKL_SIF_FEES.sif_id%TYPE)

1281: p_csm_stream_types_tbl IN csm_stream_types_tbl_type,
1282: x_return_status OUT NOCOPY VARCHAR2
1283: ) RETURN sitv_tbl_type
1284: IS
1285: CURSOR l_okl_sfe_ids_csr(p_sif_id IN OKL_SIF_FEES.sif_id%TYPE)
1286:
1287: IS
1288: SELECT DISTINCT
1289: KLE_ID, ID

Line 1290: FROM OKL_SIF_FEES

1286:
1287: IS
1288: SELECT DISTINCT
1289: KLE_ID, ID
1290: FROM OKL_SIF_FEES
1291: WHERE SIF_ID = p_sif_id
1292: AND kle_id IS NOT NULL;
1293: -- gboomina commented Bug#4508077
1294: /*

Line 1298: SELECT id FROM OKL_SIF_FEES

1294: /*
1295: -- bug 3548593 smahapat added to filter out one time expenses
1296: -- since streams are not generated
1297: AND id NOT IN (
1298: SELECT id FROM OKL_SIF_FEES
1299: WHERE sfe_type = 'SFO'
1300:
1301: AND INCOME_OR_EXPENSE = 'EXPENSE'
1302: );

Line 1312: CURSOR l_okl_sil_sfe_ids_csr(p_sif_id IN OKL_SIF_FEES.sif_id%TYPE,

1308: SELECT NAME
1309: FROM OKL_STRM_TYPE_TL
1310: WHERE ID = p_sty_id
1311: AND LANGUAGE = USERENV('LANG'); -- smahapat fixed bug# 3323146
1312: CURSOR l_okl_sil_sfe_ids_csr(p_sif_id IN OKL_SIF_FEES.sif_id%TYPE,
1313:
1314: p_sil_id IN OKL_SIF_FEES.sil_id%TYPE,
1315: p_description IN OKL_SIF_FEES.description%TYPE)
1316: IS

Line 1314: p_sil_id IN OKL_SIF_FEES.sil_id%TYPE,

1310: WHERE ID = p_sty_id
1311: AND LANGUAGE = USERENV('LANG'); -- smahapat fixed bug# 3323146
1312: CURSOR l_okl_sil_sfe_ids_csr(p_sif_id IN OKL_SIF_FEES.sif_id%TYPE,
1313:
1314: p_sil_id IN OKL_SIF_FEES.sil_id%TYPE,
1315: p_description IN OKL_SIF_FEES.description%TYPE)
1316: IS
1317: SELECT
1318: ID

Line 1315: p_description IN OKL_SIF_FEES.description%TYPE)

1311: AND LANGUAGE = USERENV('LANG'); -- smahapat fixed bug# 3323146
1312: CURSOR l_okl_sil_sfe_ids_csr(p_sif_id IN OKL_SIF_FEES.sif_id%TYPE,
1313:
1314: p_sil_id IN OKL_SIF_FEES.sil_id%TYPE,
1315: p_description IN OKL_SIF_FEES.description%TYPE)
1316: IS
1317: SELECT
1318: ID
1319: FROM OKL_SIF_FEES

Line 1319: FROM OKL_SIF_FEES

1315: p_description IN OKL_SIF_FEES.description%TYPE)
1316: IS
1317: SELECT
1318: ID
1319: FROM OKL_SIF_FEES
1320: WHERE SIF_ID = p_sif_id
1321: AND SIL_ID = p_sil_id
1322: AND (level_index_number = 0 OR level_index_number IS NULL)
1323: AND DESCRIPTION = p_description

Line 1327: SELECT id FROM OKL_SIF_FEES

1323: AND DESCRIPTION = p_description
1324: -- bug 3548593 smahapat added to filter out one time expenses
1325: -- since streams are not generated
1326: AND id NOT IN (
1327: SELECT id FROM OKL_SIF_FEES
1328: WHERE sfe_type = 'SFO'
1329: AND INCOME_OR_EXPENSE = 'EXPENSE'
1330: );
1331: l_sitv_tbl sitv_tbl_type;

Line 1382: FROM OKL_SIF_FEES

1378: -- assign sfe_id
1379: SELECT
1380: ID
1381: INTO l_sitv_tbl(i).sfe_id
1382: FROM OKL_SIF_FEES
1383: WHERE SIF_ID = p_sif_id
1384: AND SIL_ID = l_sitv_tbl(i).sil_id
1385: --AND SFE_TYPE = 'SFR' -- 04/10/2002
1386: -- 04/23/2002,mvasudev

Line 1920: Okl_Sif_Fees_Pub.insert_sif_fees(

1916: RAISE G_EXCEPTION_ERROR;
1917: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1918: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1919: END IF;
1920: Okl_Sif_Fees_Pub.insert_sif_fees(
1921: p_api_version => p_api_version
1922: ,p_init_msg_list => p_init_msg_list
1923:
1924: ,x_return_status => l_return_status

Line 2144: Okl_Sif_Fees_Pub.insert_sif_fees(

2140: RAISE G_EXCEPTION_ERROR;
2141: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2142: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2143: END IF;
2144: Okl_Sif_Fees_Pub.insert_sif_fees(
2145: p_api_version => p_api_version
2146:
2147: ,p_init_msg_list => p_init_msg_list
2148:

Line 2157: /*insert into err_msgs_log values ('Okl_Sif_Fees_Pub.insert_sif_fees x_return_status'||x_return_status);

2153: ,p_sfev_tbl => lp_sfev_loan_levels_tbl
2154: ,x_sfev_tbl => lx_sfev_loan_levels_tbl);
2155:
2156:
2157: /*insert into err_msgs_log values ('Okl_Sif_Fees_Pub.insert_sif_fees x_return_status'||x_return_status);
2158: commit;
2159: */
2160:
2161: IF l_return_status = G_RET_STS_ERROR THEN

Line 2704: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

2700:
2701: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2702: END IF;
2703: -- Insert Rent Details
2704: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2705: IF(IS_DEBUG_PROCEDURE_ON) THEN
2706:
2707: BEGIN
2708: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line 2708: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2704: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2705: IF(IS_DEBUG_PROCEDURE_ON) THEN
2706:
2707: BEGIN
2708: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2709: END;
2710: END IF;
2711:
2712:

Line 2713: Okl_Sif_Fees_Pub.insert_sif_fees(

2709: END;
2710: END IF;
2711:
2712:
2713: Okl_Sif_Fees_Pub.insert_sif_fees(
2714: p_api_version => p_api_version
2715: ,p_init_msg_list => p_init_msg_list
2716: ,x_return_status => l_return_status
2717: ,x_msg_count => x_msg_count

Line 2723: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);

2719: ,p_sfev_tbl => lp_sfev_rent_tbl
2720: ,x_sfev_tbl => lx_sfev_rent_tbl);
2721: --Added by kthiruva for Debugging
2722: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2723: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
2724: END IF;
2725:
2726: IF(IS_DEBUG_PROCEDURE_ON) THEN
2727: BEGIN

Line 2728: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2724: END IF;
2725:
2726: IF(IS_DEBUG_PROCEDURE_ON) THEN
2727: BEGIN
2728: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2729: END;
2730: END IF;
2731:
2732: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

Line 2732: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

2728: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2729: END;
2730: END IF;
2731:
2732: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2733:
2734:
2735: IF l_return_status = G_RET_STS_ERROR THEN
2736: RAISE G_EXCEPTION_ERROR;

Line 2778: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

2774: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2775: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2776: END IF;
2777:
2778: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2779: IF(IS_DEBUG_PROCEDURE_ON) THEN
2780: BEGIN
2781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2782: END;

Line 2781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2777:
2778: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2779: IF(IS_DEBUG_PROCEDURE_ON) THEN
2780: BEGIN
2781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2782: END;
2783: END IF;
2784:
2785: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 2785: Okl_Sif_Fees_Pub.insert_sif_fees(

2781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2782: END;
2783: END IF;
2784:
2785: Okl_Sif_Fees_Pub.insert_sif_fees(
2786:
2787: p_api_version => p_api_version
2788: ,p_init_msg_list => p_init_msg_list
2789: ,x_return_status => l_return_status

Line 2796: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);

2792: ,p_sfev_tbl => lp_sfev_one_off_tbl
2793: ,x_sfev_tbl => lx_sfev_one_off_tbl);
2794: --Added by kthiruva for Debugging
2795: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2796: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
2797: END IF;
2798:
2799:
2800:

Line 2803: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2799:
2800:
2801: IF(IS_DEBUG_PROCEDURE_ON) THEN
2802: BEGIN
2803: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2804: END;
2805: END IF;
2806: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2807: IF l_return_status = G_RET_STS_ERROR THEN

Line 2806: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

2802: BEGIN
2803: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2804: END;
2805: END IF;
2806: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2807: IF l_return_status = G_RET_STS_ERROR THEN
2808: RAISE G_EXCEPTION_ERROR;
2809: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2810: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 2833: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

2829:
2830: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2831: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2832: END IF;
2833: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2834: IF(IS_DEBUG_PROCEDURE_ON) THEN
2835: BEGIN
2836: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2837: END;

Line 2836: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2832: END IF;
2833: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2834: IF(IS_DEBUG_PROCEDURE_ON) THEN
2835: BEGIN
2836: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2837: END;
2838: END IF;
2839:
2840: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 2840: Okl_Sif_Fees_Pub.insert_sif_fees(

2836: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2837: END;
2838: END IF;
2839:
2840: Okl_Sif_Fees_Pub.insert_sif_fees(
2841: p_api_version => p_api_version
2842:
2843: ,p_init_msg_list => p_init_msg_list
2844: ,x_return_status => l_return_status

Line 2851: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);

2847: ,p_sfev_tbl => lp_sfev_periodic_tbl
2848: ,x_sfev_tbl => lx_sfev_periodic_tbl);
2849: --Added by kthiruva for Debugging
2850: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2851: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
2852: END IF;
2853:
2854:
2855: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2857: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2853:
2854:
2855: IF(IS_DEBUG_PROCEDURE_ON) THEN
2856: BEGIN
2857: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2858: END;
2859: END IF;
2860: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2861: IF l_return_status = G_RET_STS_ERROR THEN

Line 2860: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

2856: BEGIN
2857: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2858: END;
2859: END IF;
2860: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2861: IF l_return_status = G_RET_STS_ERROR THEN
2862: RAISE G_EXCEPTION_ERROR;
2863: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2864: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 3340: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

3336: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3337: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3338: END IF;
3339: -- Insert Loan Levels
3340: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3341: IF(IS_DEBUG_PROCEDURE_ON) THEN
3342: BEGIN
3343: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3344: END;

Line 3343: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3339: -- Insert Loan Levels
3340: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3341: IF(IS_DEBUG_PROCEDURE_ON) THEN
3342: BEGIN
3343: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3344: END;
3345:
3346: END IF;
3347:

Line 3348: Okl_Sif_Fees_Pub.insert_sif_fees(

3344: END;
3345:
3346: END IF;
3347:
3348: Okl_Sif_Fees_Pub.insert_sif_fees(
3349: p_api_version => p_api_version
3350: ,p_init_msg_list => p_init_msg_list
3351: ,x_return_status => l_return_status
3352: ,x_msg_count => x_msg_count

Line 3359: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);

3355: ,p_sfev_tbl => lp_sfev_loan_levels_tbl
3356: ,x_sfev_tbl => lx_sfev_loan_levels_tbl);
3357: --Added by kthiruva for Debug Logging
3358: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3359: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
3360: END IF;
3361:
3362: IF(IS_DEBUG_PROCEDURE_ON) THEN
3363: BEGIN

Line 3364: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3360: END IF;
3361:
3362: IF(IS_DEBUG_PROCEDURE_ON) THEN
3363: BEGIN
3364: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3365: END;
3366: END IF;
3367: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3368: IF l_return_status = G_RET_STS_ERROR THEN

Line 3367: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

3363: BEGIN
3364: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3365: END;
3366: END IF;
3367: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3368: IF l_return_status = G_RET_STS_ERROR THEN
3369: RAISE G_EXCEPTION_ERROR;
3370: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3371: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 3391: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

3387: RAISE G_EXCEPTION_ERROR;
3388: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3389: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3390: END IF;
3391: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3392: IF(IS_DEBUG_PROCEDURE_ON) THEN
3393: BEGIN
3394: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3395:

Line 3394: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3390: END IF;
3391: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3392: IF(IS_DEBUG_PROCEDURE_ON) THEN
3393: BEGIN
3394: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3395:
3396: END;
3397: END IF;
3398: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 3398: Okl_Sif_Fees_Pub.insert_sif_fees(

3394: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3395:
3396: END;
3397: END IF;
3398: Okl_Sif_Fees_Pub.insert_sif_fees(
3399: p_api_version => p_api_version
3400: ,p_init_msg_list => p_init_msg_list
3401: ,x_return_status => l_return_status
3402: ,x_msg_count => x_msg_count

Line 3408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);

3404: ,p_sfev_tbl => lp_sfev_one_off_tbl
3405: ,x_sfev_tbl => lx_sfev_one_off_tbl);
3406: --Added by kthiruva for Debug Logging
3407: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
3409: END IF;
3410:
3411:
3412: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 3414: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3410:
3411:
3412: IF(IS_DEBUG_PROCEDURE_ON) THEN
3413: BEGIN
3414: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3415: END;
3416: END IF;
3417:
3418: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

Line 3418: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

3414: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3415: END;
3416: END IF;
3417:
3418: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3419: IF l_return_status = G_RET_STS_ERROR THEN
3420: RAISE G_EXCEPTION_ERROR;
3421: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3422: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 3442: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

3438: RAISE G_EXCEPTION_ERROR;
3439: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3440: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3441: END IF;
3442: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3443: IF(IS_DEBUG_PROCEDURE_ON) THEN
3444: BEGIN
3445: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3446: END;

Line 3445: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3441: END IF;
3442: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3443: IF(IS_DEBUG_PROCEDURE_ON) THEN
3444: BEGIN
3445: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3446: END;
3447: END IF;
3448: Okl_Sif_Fees_Pub.insert_sif_fees(
3449: p_api_version => p_api_version

Line 3448: Okl_Sif_Fees_Pub.insert_sif_fees(

3444: BEGIN
3445: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3446: END;
3447: END IF;
3448: Okl_Sif_Fees_Pub.insert_sif_fees(
3449: p_api_version => p_api_version
3450: ,p_init_msg_list => p_init_msg_list
3451: ,x_return_status => l_return_status
3452: ,x_msg_count => x_msg_count

Line 3458: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);

3454: ,p_sfev_tbl => lp_sfev_periodic_expenses_tbl
3455: ,x_sfev_tbl => lx_sfev_periodic_expenses_tbl);
3456: --Added by kthiruva for Debug Logging
3457: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3458: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
3459: END IF;
3460:
3461:
3462: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 3465: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3461:
3462: IF(IS_DEBUG_PROCEDURE_ON) THEN
3463: BEGIN
3464:
3465: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3466: END;
3467: END IF;
3468: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3469: IF l_return_status = G_RET_STS_ERROR THEN

Line 3468: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

3464:
3465: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3466: END;
3467: END IF;
3468: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3469: IF l_return_status = G_RET_STS_ERROR THEN
3470: RAISE G_EXCEPTION_ERROR;
3471: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3472: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 3488: OKL_SIF_FEES_PUB.insert_sif_fees(

3484:
3485: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3486: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3487: END IF;
3488: OKL_SIF_FEES_PUB.insert_sif_fees(
3489: p_api_version => p_api_version
3490: ,p_init_msg_list => p_init_msg_list
3491: ,x_return_status => l_return_status
3492: ,x_msg_count => x_msg_count

Line 4104: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4100: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4101:
4102: END IF;
4103: -- Insert Rent Details
4104: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4105:
4106: IF(IS_DEBUG_PROCEDURE_ON) THEN
4107: BEGIN
4108: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line 4108: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4104: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4105:
4106: IF(IS_DEBUG_PROCEDURE_ON) THEN
4107: BEGIN
4108: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4109: END;
4110: END IF;
4111:
4112: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 4112: Okl_Sif_Fees_Pub.insert_sif_fees(

4108: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4109: END;
4110: END IF;
4111:
4112: Okl_Sif_Fees_Pub.insert_sif_fees(
4113: p_api_version => p_api_version
4114: ,p_init_msg_list => p_init_msg_list
4115: ,x_return_status => l_return_status
4116: ,x_msg_count => x_msg_count

Line 4122: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4118: ,p_sfev_tbl => lp_sfev_rent_tbl
4119: ,x_sfev_tbl => lx_sfev_rent_tbl);
4120: IF(IS_DEBUG_PROCEDURE_ON) THEN
4121: BEGIN
4122: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4123: END;
4124: END IF;
4125: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4126: IF l_return_status = G_RET_STS_ERROR THEN

Line 4125: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4121: BEGIN
4122: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4123: END;
4124: END IF;
4125: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4126: IF l_return_status = G_RET_STS_ERROR THEN
4127: RAISE G_EXCEPTION_ERROR;
4128: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4129: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 4145: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4141: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4142:
4143: END IF;
4144:
4145: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4146: IF(IS_DEBUG_PROCEDURE_ON) THEN
4147: BEGIN
4148: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4149: END;

Line 4148: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4144:
4145: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4146: IF(IS_DEBUG_PROCEDURE_ON) THEN
4147: BEGIN
4148: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4149: END;
4150: END IF;
4151: Okl_Sif_Fees_Pub.insert_sif_fees(
4152: p_api_version => p_api_version

Line 4151: Okl_Sif_Fees_Pub.insert_sif_fees(

4147: BEGIN
4148: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4149: END;
4150: END IF;
4151: Okl_Sif_Fees_Pub.insert_sif_fees(
4152: p_api_version => p_api_version
4153: ,p_init_msg_list => p_init_msg_list
4154: ,x_return_status => l_return_status
4155: ,x_msg_count => x_msg_count

Line 4161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4157: ,p_sfev_tbl => lp_sfev_one_off_tbl
4158: ,x_sfev_tbl => lx_sfev_one_off_tbl);
4159: IF(IS_DEBUG_PROCEDURE_ON) THEN
4160: BEGIN
4161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4162: END;
4163: END IF;
4164: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4165: IF l_return_status = G_RET_STS_ERROR THEN

Line 4164: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4160: BEGIN
4161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4162: END;
4163: END IF;
4164: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4165: IF l_return_status = G_RET_STS_ERROR THEN
4166:
4167: RAISE G_EXCEPTION_ERROR;
4168: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 4184: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4180: RAISE G_EXCEPTION_ERROR;
4181: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4182: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4183: END IF;
4184: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4185: IF(IS_DEBUG_PROCEDURE_ON) THEN
4186: BEGIN
4187: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4188: END;

Line 4187: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4183: END IF;
4184: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4185: IF(IS_DEBUG_PROCEDURE_ON) THEN
4186: BEGIN
4187: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4188: END;
4189: END IF;
4190: Okl_Sif_Fees_Pub.insert_sif_fees(
4191: p_api_version => p_api_version

Line 4190: Okl_Sif_Fees_Pub.insert_sif_fees(

4186: BEGIN
4187: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4188: END;
4189: END IF;
4190: Okl_Sif_Fees_Pub.insert_sif_fees(
4191: p_api_version => p_api_version
4192: ,p_init_msg_list => p_init_msg_list
4193: ,x_return_status => l_return_status
4194: ,x_msg_count => x_msg_count

Line 4201: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4197: ,p_sfev_tbl => lp_sfev_periodic_tbl
4198: ,x_sfev_tbl => lx_sfev_periodic_tbl);
4199: IF(IS_DEBUG_PROCEDURE_ON) THEN
4200: BEGIN
4201: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4202:
4203: END;
4204: END IF;
4205: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

Line 4205: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4201: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4202:
4203: END;
4204: END IF;
4205: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4206: IF l_return_status = G_RET_STS_ERROR THEN
4207: RAISE G_EXCEPTION_ERROR;
4208: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4209: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 4624: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4620: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4621: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4622: END IF;
4623: -- Insert Loan Levels
4624: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4625: IF(IS_DEBUG_PROCEDURE_ON) THEN
4626: BEGIN
4627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4628: END;

Line 4627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4623: -- Insert Loan Levels
4624: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4625: IF(IS_DEBUG_PROCEDURE_ON) THEN
4626: BEGIN
4627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4628: END;
4629: END IF;
4630:
4631: --Added by kthiruva for populating the method to be used by the Balance Tag

Line 4646: Okl_Sif_Fees_Pub.insert_sif_fees(

4642: --End of Changes
4643:
4644:
4645:
4646: Okl_Sif_Fees_Pub.insert_sif_fees(
4647: p_api_version => p_api_version
4648: ,p_init_msg_list => p_init_msg_list
4649: ,x_return_status => l_return_status
4650:

Line 4658: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4654: ,x_sfev_tbl => lx_sfev_loan_levels_tbl);
4655:
4656: IF(IS_DEBUG_PROCEDURE_ON) THEN
4657: BEGIN
4658: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4659: END;
4660: END IF;
4661: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4662: IF l_return_status = G_RET_STS_ERROR THEN

Line 4661: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4657: BEGIN
4658: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4659: END;
4660: END IF;
4661: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4662: IF l_return_status = G_RET_STS_ERROR THEN
4663: RAISE G_EXCEPTION_ERROR;
4664: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4665: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 4680: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4676: RAISE G_EXCEPTION_ERROR;
4677: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4678: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4679: END IF;
4680: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4681: IF(IS_DEBUG_PROCEDURE_ON) THEN
4682: BEGIN
4683: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4684: END;

Line 4683: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4679: END IF;
4680: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4681: IF(IS_DEBUG_PROCEDURE_ON) THEN
4682: BEGIN
4683: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4684: END;
4685: END IF;
4686: Okl_Sif_Fees_Pub.insert_sif_fees(
4687: p_api_version => p_api_version

Line 4686: Okl_Sif_Fees_Pub.insert_sif_fees(

4682: BEGIN
4683: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4684: END;
4685: END IF;
4686: Okl_Sif_Fees_Pub.insert_sif_fees(
4687: p_api_version => p_api_version
4688: ,p_init_msg_list => p_init_msg_list
4689:
4690: ,x_return_status => l_return_status

Line 4698: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4694: ,x_sfev_tbl => lx_sfev_one_off_tbl);
4695:
4696: IF(IS_DEBUG_PROCEDURE_ON) THEN
4697: BEGIN
4698: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4699: END;
4700: END IF;
4701: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4702: IF l_return_status = G_RET_STS_ERROR THEN

Line 4701: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4697: BEGIN
4698: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4699: END;
4700: END IF;
4701: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4702: IF l_return_status = G_RET_STS_ERROR THEN
4703: RAISE G_EXCEPTION_ERROR;
4704: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4705: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 4721: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4717: RAISE G_EXCEPTION_ERROR;
4718: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4719: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4720: END IF;
4721: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4722: IF(IS_DEBUG_PROCEDURE_ON) THEN
4723: BEGIN
4724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4725: END;

Line 4724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4720: END IF;
4721: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4722: IF(IS_DEBUG_PROCEDURE_ON) THEN
4723: BEGIN
4724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4725: END;
4726: END IF;
4727: Okl_Sif_Fees_Pub.insert_sif_fees(
4728: p_api_version => p_api_version

Line 4727: Okl_Sif_Fees_Pub.insert_sif_fees(

4723: BEGIN
4724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4725: END;
4726: END IF;
4727: Okl_Sif_Fees_Pub.insert_sif_fees(
4728: p_api_version => p_api_version
4729: ,p_init_msg_list => p_init_msg_list
4730:
4731: ,x_return_status => l_return_status

Line 4738: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4734: ,p_sfev_tbl => lp_sfev_periodic_expenses_tbl
4735: ,x_sfev_tbl => lx_sfev_periodic_expenses_tbl);
4736: IF(IS_DEBUG_PROCEDURE_ON) THEN
4737: BEGIN
4738: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4739: END;
4740: END IF;
4741: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4742: IF l_return_status = G_RET_STS_ERROR THEN

Line 4741: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

4737: BEGIN
4738: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4739: END;
4740: END IF;
4741: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4742: IF l_return_status = G_RET_STS_ERROR THEN
4743: RAISE G_EXCEPTION_ERROR;
4744: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4745: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 5111: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

5107: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5108: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
5109: END IF;
5110: -- Insert Rent Details
5111: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5112: IF(IS_DEBUG_PROCEDURE_ON) THEN
5113: BEGIN
5114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5115: END;

Line 5114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5110: -- Insert Rent Details
5111: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5112: IF(IS_DEBUG_PROCEDURE_ON) THEN
5113: BEGIN
5114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5115: END;
5116: END IF;
5117:
5118: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 5118: Okl_Sif_Fees_Pub.insert_sif_fees(

5114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5115: END;
5116: END IF;
5117:
5118: Okl_Sif_Fees_Pub.insert_sif_fees(
5119: p_api_version => p_api_version
5120: ,p_init_msg_list => p_init_msg_list
5121: ,x_return_status => l_return_status
5122: ,x_msg_count => x_msg_count

Line 5128: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5124: ,p_sfev_tbl => lp_sfev_rent_tbl
5125: ,x_sfev_tbl => lx_sfev_rent_tbl);
5126: IF(IS_DEBUG_PROCEDURE_ON) THEN
5127: BEGIN
5128: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5129: END;
5130:
5131: END IF;
5132: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

Line 5132: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

5128: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5129: END;
5130:
5131: END IF;
5132: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5133: IF l_return_status = G_RET_STS_ERROR THEN
5134: RAISE G_EXCEPTION_ERROR;
5135: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5136: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 5152: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

5148: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5149: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
5150: END IF;
5151:
5152: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5153: IF(IS_DEBUG_PROCEDURE_ON) THEN
5154: BEGIN
5155: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5156: END;

Line 5155: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5151:
5152: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5153: IF(IS_DEBUG_PROCEDURE_ON) THEN
5154: BEGIN
5155: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5156: END;
5157: END IF;
5158: Okl_Sif_Fees_Pub.insert_sif_fees(
5159: p_api_version => p_api_version

Line 5158: Okl_Sif_Fees_Pub.insert_sif_fees(

5154: BEGIN
5155: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5156: END;
5157: END IF;
5158: Okl_Sif_Fees_Pub.insert_sif_fees(
5159: p_api_version => p_api_version
5160: ,p_init_msg_list => p_init_msg_list
5161: ,x_return_status => l_return_status
5162: ,x_msg_count => x_msg_count

Line 5168: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5164: ,p_sfev_tbl => lp_sfev_one_off_tbl
5165: ,x_sfev_tbl => lx_sfev_one_off_tbl);
5166: IF(IS_DEBUG_PROCEDURE_ON) THEN
5167: BEGIN
5168: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5169: END;
5170: END IF;
5171: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5172: IF l_return_status = G_RET_STS_ERROR THEN

Line 5171: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

5167: BEGIN
5168: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5169: END;
5170: END IF;
5171: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5172: IF l_return_status = G_RET_STS_ERROR THEN
5173: RAISE G_EXCEPTION_ERROR;
5174: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5175: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 5192: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

5188:
5189: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5190: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
5191: END IF;
5192: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5193: IF(IS_DEBUG_PROCEDURE_ON) THEN
5194: BEGIN
5195: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5196: END;

Line 5195: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5191: END IF;
5192: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5193: IF(IS_DEBUG_PROCEDURE_ON) THEN
5194: BEGIN
5195: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5196: END;
5197: END IF;
5198: Okl_Sif_Fees_Pub.insert_sif_fees(
5199: p_api_version => p_api_version

Line 5198: Okl_Sif_Fees_Pub.insert_sif_fees(

5194: BEGIN
5195: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5196: END;
5197: END IF;
5198: Okl_Sif_Fees_Pub.insert_sif_fees(
5199: p_api_version => p_api_version
5200: ,p_init_msg_list => p_init_msg_list
5201: ,x_return_status => l_return_status
5202: ,x_msg_count => x_msg_count

Line 5209: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5205: ,x_sfev_tbl => lx_sfev_periodic_tbl);
5206: IF(IS_DEBUG_PROCEDURE_ON) THEN
5207: BEGIN
5208:
5209: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5210: END;
5211: END IF;
5212: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5213: IF l_return_status = G_RET_STS_ERROR THEN

Line 5212: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

5208:
5209: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5210: END;
5211: END IF;
5212: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5213: IF l_return_status = G_RET_STS_ERROR THEN
5214: RAISE G_EXCEPTION_ERROR;
5215: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5216: RAISE G_EXCEPTION_UNEXPECTED_ERROR;