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_PUB

Line 1726: Okl_Sif_Fees_Pub.insert_sif_fees(

1722: RAISE G_EXCEPTION_ERROR;
1723: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1724: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1725: END IF;
1726: Okl_Sif_Fees_Pub.insert_sif_fees(
1727: p_api_version => p_api_version
1728: ,p_init_msg_list => p_init_msg_list
1729:
1730: ,x_return_status => l_return_status

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:
1923: ,p_init_msg_list => p_init_msg_list
1924:

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

1929: ,p_sfev_tbl => lp_sfev_loan_levels_tbl
1930: ,x_sfev_tbl => lx_sfev_loan_levels_tbl);
1931:
1932:
1933: /*insert into err_msgs_log values ('Okl_Sif_Fees_Pub.insert_sif_fees x_return_status'||x_return_status);
1934: commit;
1935: */
1936:
1937: IF l_return_status = G_RET_STS_ERROR THEN

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

2438:
2439: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2440: END IF;
2441: -- Insert Rent Details
2442: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2443: IF(IS_DEBUG_PROCEDURE_ON) THEN
2444:
2445: BEGIN
2446: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

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

2442: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2443: IF(IS_DEBUG_PROCEDURE_ON) THEN
2444:
2445: BEGIN
2446: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2447: END;
2448: END IF;
2449:
2450:

Line 2451: Okl_Sif_Fees_Pub.insert_sif_fees(

2447: END;
2448: END IF;
2449:
2450:
2451: Okl_Sif_Fees_Pub.insert_sif_fees(
2452: p_api_version => p_api_version
2453: ,p_init_msg_list => p_init_msg_list
2454: ,x_return_status => l_return_status
2455: ,x_msg_count => x_msg_count

Line 2461: 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);

2457: ,p_sfev_tbl => lp_sfev_rent_tbl
2458: ,x_sfev_tbl => lx_sfev_rent_tbl);
2459: --Added by kthiruva for Debugging
2460: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2461: 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);
2462: END IF;
2463:
2464: IF(IS_DEBUG_PROCEDURE_ON) THEN
2465: BEGIN

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

2462: END IF;
2463:
2464: IF(IS_DEBUG_PROCEDURE_ON) THEN
2465: BEGIN
2466: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2467: END;
2468: END IF;
2469:
2470: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

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

2466: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2467: END;
2468: END IF;
2469:
2470: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2471:
2472:
2473: IF l_return_status = G_RET_STS_ERROR THEN
2474: RAISE G_EXCEPTION_ERROR;

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

2512: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2513: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2514: END IF;
2515:
2516: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2517: IF(IS_DEBUG_PROCEDURE_ON) THEN
2518: BEGIN
2519: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2520: END;

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

2515:
2516: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2517: IF(IS_DEBUG_PROCEDURE_ON) THEN
2518: BEGIN
2519: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2520: END;
2521: END IF;
2522:
2523: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 2523: Okl_Sif_Fees_Pub.insert_sif_fees(

2519: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2520: END;
2521: END IF;
2522:
2523: Okl_Sif_Fees_Pub.insert_sif_fees(
2524:
2525: p_api_version => p_api_version
2526: ,p_init_msg_list => p_init_msg_list
2527: ,x_return_status => l_return_status

Line 2534: 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);

2530: ,p_sfev_tbl => lp_sfev_one_off_tbl
2531: ,x_sfev_tbl => lx_sfev_one_off_tbl);
2532: --Added by kthiruva for Debugging
2533: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2534: 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);
2535: END IF;
2536:
2537:
2538:

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

2537:
2538:
2539: IF(IS_DEBUG_PROCEDURE_ON) THEN
2540: BEGIN
2541: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2542: END;
2543: END IF;
2544: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2545: IF l_return_status = G_RET_STS_ERROR THEN

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

2540: BEGIN
2541: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2542: END;
2543: END IF;
2544: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2545: IF l_return_status = G_RET_STS_ERROR THEN
2546: RAISE G_EXCEPTION_ERROR;
2547: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2548: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

2567:
2568: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2569: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2570: END IF;
2571: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2572: IF(IS_DEBUG_PROCEDURE_ON) THEN
2573: BEGIN
2574: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2575: END;

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

2570: END IF;
2571: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2572: IF(IS_DEBUG_PROCEDURE_ON) THEN
2573: BEGIN
2574: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2575: END;
2576: END IF;
2577:
2578: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 2578: Okl_Sif_Fees_Pub.insert_sif_fees(

2574: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2575: END;
2576: END IF;
2577:
2578: Okl_Sif_Fees_Pub.insert_sif_fees(
2579: p_api_version => p_api_version
2580:
2581: ,p_init_msg_list => p_init_msg_list
2582: ,x_return_status => l_return_status

Line 2589: 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);

2585: ,p_sfev_tbl => lp_sfev_periodic_tbl
2586: ,x_sfev_tbl => lx_sfev_periodic_tbl);
2587: --Added by kthiruva for Debugging
2588: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2589: 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);
2590: END IF;
2591:
2592:
2593: IF(IS_DEBUG_PROCEDURE_ON) THEN

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

2591:
2592:
2593: IF(IS_DEBUG_PROCEDURE_ON) THEN
2594: BEGIN
2595: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2596: END;
2597: END IF;
2598: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2599: IF l_return_status = G_RET_STS_ERROR THEN

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

2594: BEGIN
2595: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2596: END;
2597: END IF;
2598: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2599: IF l_return_status = G_RET_STS_ERROR THEN
2600: RAISE G_EXCEPTION_ERROR;
2601: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2602: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

3074: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3075: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3076: END IF;
3077: -- Insert Loan Levels
3078: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3079: IF(IS_DEBUG_PROCEDURE_ON) THEN
3080: BEGIN
3081: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3082: END;

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

3077: -- Insert Loan Levels
3078: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3079: IF(IS_DEBUG_PROCEDURE_ON) THEN
3080: BEGIN
3081: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3082: END;
3083:
3084: END IF;
3085:

Line 3086: Okl_Sif_Fees_Pub.insert_sif_fees(

3082: END;
3083:
3084: END IF;
3085:
3086: Okl_Sif_Fees_Pub.insert_sif_fees(
3087: p_api_version => p_api_version
3088: ,p_init_msg_list => p_init_msg_list
3089: ,x_return_status => l_return_status
3090: ,x_msg_count => x_msg_count

Line 3097: 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);

3093: ,p_sfev_tbl => lp_sfev_loan_levels_tbl
3094: ,x_sfev_tbl => lx_sfev_loan_levels_tbl);
3095: --Added by kthiruva for Debug Logging
3096: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3097: 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);
3098: END IF;
3099:
3100: IF(IS_DEBUG_PROCEDURE_ON) THEN
3101: BEGIN

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

3098: END IF;
3099:
3100: IF(IS_DEBUG_PROCEDURE_ON) THEN
3101: BEGIN
3102: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3103: END;
3104: END IF;
3105: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3106: IF l_return_status = G_RET_STS_ERROR THEN

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

3101: BEGIN
3102: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3103: END;
3104: END IF;
3105: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3106: IF l_return_status = G_RET_STS_ERROR THEN
3107: RAISE G_EXCEPTION_ERROR;
3108: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3109: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

3125: RAISE G_EXCEPTION_ERROR;
3126: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3127: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3128: END IF;
3129: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3130: IF(IS_DEBUG_PROCEDURE_ON) THEN
3131: BEGIN
3132: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3133:

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

3128: END IF;
3129: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3130: IF(IS_DEBUG_PROCEDURE_ON) THEN
3131: BEGIN
3132: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3133:
3134: END;
3135: END IF;
3136: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 3136: Okl_Sif_Fees_Pub.insert_sif_fees(

3132: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3133:
3134: END;
3135: END IF;
3136: Okl_Sif_Fees_Pub.insert_sif_fees(
3137: p_api_version => p_api_version
3138: ,p_init_msg_list => p_init_msg_list
3139: ,x_return_status => l_return_status
3140: ,x_msg_count => x_msg_count

Line 3146: 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);

3142: ,p_sfev_tbl => lp_sfev_one_off_tbl
3143: ,x_sfev_tbl => lx_sfev_one_off_tbl);
3144: --Added by kthiruva for Debug Logging
3145: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3146: 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);
3147: END IF;
3148:
3149:
3150: IF(IS_DEBUG_PROCEDURE_ON) THEN

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

3148:
3149:
3150: IF(IS_DEBUG_PROCEDURE_ON) THEN
3151: BEGIN
3152: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3153: END;
3154: END IF;
3155:
3156: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

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

3152: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3153: END;
3154: END IF;
3155:
3156: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3157: IF l_return_status = G_RET_STS_ERROR THEN
3158: RAISE G_EXCEPTION_ERROR;
3159: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3160: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

3176: RAISE G_EXCEPTION_ERROR;
3177: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3178: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3179: END IF;
3180: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3181: IF(IS_DEBUG_PROCEDURE_ON) THEN
3182: BEGIN
3183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3184: END;

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

3179: END IF;
3180: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3181: IF(IS_DEBUG_PROCEDURE_ON) THEN
3182: BEGIN
3183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3184: END;
3185: END IF;
3186: Okl_Sif_Fees_Pub.insert_sif_fees(
3187: p_api_version => p_api_version

Line 3186: Okl_Sif_Fees_Pub.insert_sif_fees(

3182: BEGIN
3183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3184: END;
3185: END IF;
3186: Okl_Sif_Fees_Pub.insert_sif_fees(
3187: p_api_version => p_api_version
3188: ,p_init_msg_list => p_init_msg_list
3189: ,x_return_status => l_return_status
3190: ,x_msg_count => x_msg_count

Line 3196: 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);

3192: ,p_sfev_tbl => lp_sfev_periodic_expenses_tbl
3193: ,x_sfev_tbl => lx_sfev_periodic_expenses_tbl);
3194: --Added by kthiruva for Debug Logging
3195: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3196: 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);
3197: END IF;
3198:
3199:
3200: IF(IS_DEBUG_PROCEDURE_ON) THEN

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

3199:
3200: IF(IS_DEBUG_PROCEDURE_ON) THEN
3201: BEGIN
3202:
3203: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3204: END;
3205: END IF;
3206: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3207: IF l_return_status = G_RET_STS_ERROR THEN

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

3202:
3203: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3204: END;
3205: END IF;
3206: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3207: IF l_return_status = G_RET_STS_ERROR THEN
3208: RAISE G_EXCEPTION_ERROR;
3209: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3210: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 3226: OKL_SIF_FEES_PUB.insert_sif_fees(

3222:
3223: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3224: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3225: END IF;
3226: OKL_SIF_FEES_PUB.insert_sif_fees(
3227: p_api_version => p_api_version
3228: ,p_init_msg_list => p_init_msg_list
3229: ,x_return_status => l_return_status
3230: ,x_msg_count => x_msg_count

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

3838: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3839:
3840: END IF;
3841: -- Insert Rent Details
3842: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3843:
3844: IF(IS_DEBUG_PROCEDURE_ON) THEN
3845: BEGIN
3846: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

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

3842: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3843:
3844: IF(IS_DEBUG_PROCEDURE_ON) THEN
3845: BEGIN
3846: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3847: END;
3848: END IF;
3849:
3850: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 3850: Okl_Sif_Fees_Pub.insert_sif_fees(

3846: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3847: END;
3848: END IF;
3849:
3850: Okl_Sif_Fees_Pub.insert_sif_fees(
3851: p_api_version => p_api_version
3852: ,p_init_msg_list => p_init_msg_list
3853: ,x_return_status => l_return_status
3854: ,x_msg_count => x_msg_count

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

3856: ,p_sfev_tbl => lp_sfev_rent_tbl
3857: ,x_sfev_tbl => lx_sfev_rent_tbl);
3858: IF(IS_DEBUG_PROCEDURE_ON) THEN
3859: BEGIN
3860: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3861: END;
3862: END IF;
3863: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3864: IF l_return_status = G_RET_STS_ERROR THEN

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

3859: BEGIN
3860: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3861: END;
3862: END IF;
3863: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3864: IF l_return_status = G_RET_STS_ERROR THEN
3865: RAISE G_EXCEPTION_ERROR;
3866: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3867: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

3879: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3880:
3881: END IF;
3882:
3883: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3884: IF(IS_DEBUG_PROCEDURE_ON) THEN
3885: BEGIN
3886: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3887: END;

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

3882:
3883: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3884: IF(IS_DEBUG_PROCEDURE_ON) THEN
3885: BEGIN
3886: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3887: END;
3888: END IF;
3889: Okl_Sif_Fees_Pub.insert_sif_fees(
3890: p_api_version => p_api_version

Line 3889: Okl_Sif_Fees_Pub.insert_sif_fees(

3885: BEGIN
3886: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3887: END;
3888: END IF;
3889: Okl_Sif_Fees_Pub.insert_sif_fees(
3890: p_api_version => p_api_version
3891: ,p_init_msg_list => p_init_msg_list
3892: ,x_return_status => l_return_status
3893: ,x_msg_count => x_msg_count

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

3895: ,p_sfev_tbl => lp_sfev_one_off_tbl
3896: ,x_sfev_tbl => lx_sfev_one_off_tbl);
3897: IF(IS_DEBUG_PROCEDURE_ON) THEN
3898: BEGIN
3899: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3900: END;
3901: END IF;
3902: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3903: IF l_return_status = G_RET_STS_ERROR THEN

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

3898: BEGIN
3899: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3900: END;
3901: END IF;
3902: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3903: IF l_return_status = G_RET_STS_ERROR THEN
3904:
3905: RAISE G_EXCEPTION_ERROR;
3906: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN

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

3918: RAISE G_EXCEPTION_ERROR;
3919: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3920: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3921: END IF;
3922: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3923: IF(IS_DEBUG_PROCEDURE_ON) THEN
3924: BEGIN
3925: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3926: END;

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

3921: END IF;
3922: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3923: IF(IS_DEBUG_PROCEDURE_ON) THEN
3924: BEGIN
3925: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3926: END;
3927: END IF;
3928: Okl_Sif_Fees_Pub.insert_sif_fees(
3929: p_api_version => p_api_version

Line 3928: Okl_Sif_Fees_Pub.insert_sif_fees(

3924: BEGIN
3925: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3926: END;
3927: END IF;
3928: Okl_Sif_Fees_Pub.insert_sif_fees(
3929: p_api_version => p_api_version
3930: ,p_init_msg_list => p_init_msg_list
3931: ,x_return_status => l_return_status
3932: ,x_msg_count => x_msg_count

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

3935: ,p_sfev_tbl => lp_sfev_periodic_tbl
3936: ,x_sfev_tbl => lx_sfev_periodic_tbl);
3937: IF(IS_DEBUG_PROCEDURE_ON) THEN
3938: BEGIN
3939: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3940:
3941: END;
3942: END IF;
3943: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

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

3939: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3940:
3941: END;
3942: END IF;
3943: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3944: IF l_return_status = G_RET_STS_ERROR THEN
3945: RAISE G_EXCEPTION_ERROR;
3946: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3947: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

4358: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4359: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4360: END IF;
4361: -- Insert Loan Levels
4362: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4363: IF(IS_DEBUG_PROCEDURE_ON) THEN
4364: BEGIN
4365: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4366: END;

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

4361: -- Insert Loan Levels
4362: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4363: IF(IS_DEBUG_PROCEDURE_ON) THEN
4364: BEGIN
4365: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4366: END;
4367: END IF;
4368:
4369: --Added by kthiruva for populating the method to be used by the Balance Tag

Line 4384: Okl_Sif_Fees_Pub.insert_sif_fees(

4380: --End of Changes
4381:
4382:
4383:
4384: Okl_Sif_Fees_Pub.insert_sif_fees(
4385: p_api_version => p_api_version
4386: ,p_init_msg_list => p_init_msg_list
4387: ,x_return_status => l_return_status
4388:

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

4392: ,x_sfev_tbl => lx_sfev_loan_levels_tbl);
4393:
4394: IF(IS_DEBUG_PROCEDURE_ON) THEN
4395: BEGIN
4396: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4397: END;
4398: END IF;
4399: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4400: IF l_return_status = G_RET_STS_ERROR THEN

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

4395: BEGIN
4396: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4397: END;
4398: END IF;
4399: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4400: IF l_return_status = G_RET_STS_ERROR THEN
4401: RAISE G_EXCEPTION_ERROR;
4402: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4403: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

4414: RAISE G_EXCEPTION_ERROR;
4415: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4416: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4417: END IF;
4418: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4419: IF(IS_DEBUG_PROCEDURE_ON) THEN
4420: BEGIN
4421: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4422: END;

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

4417: END IF;
4418: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4419: IF(IS_DEBUG_PROCEDURE_ON) THEN
4420: BEGIN
4421: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4422: END;
4423: END IF;
4424: Okl_Sif_Fees_Pub.insert_sif_fees(
4425: p_api_version => p_api_version

Line 4424: Okl_Sif_Fees_Pub.insert_sif_fees(

4420: BEGIN
4421: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4422: END;
4423: END IF;
4424: Okl_Sif_Fees_Pub.insert_sif_fees(
4425: p_api_version => p_api_version
4426: ,p_init_msg_list => p_init_msg_list
4427:
4428: ,x_return_status => l_return_status

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

4432: ,x_sfev_tbl => lx_sfev_one_off_tbl);
4433:
4434: IF(IS_DEBUG_PROCEDURE_ON) THEN
4435: BEGIN
4436: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4437: END;
4438: END IF;
4439: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4440: IF l_return_status = G_RET_STS_ERROR THEN

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

4435: BEGIN
4436: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4437: END;
4438: END IF;
4439: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4440: IF l_return_status = G_RET_STS_ERROR THEN
4441: RAISE G_EXCEPTION_ERROR;
4442: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4443: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

4455: RAISE G_EXCEPTION_ERROR;
4456: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4457: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4458: END IF;
4459: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4460: IF(IS_DEBUG_PROCEDURE_ON) THEN
4461: BEGIN
4462: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4463: END;

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

4458: END IF;
4459: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4460: IF(IS_DEBUG_PROCEDURE_ON) THEN
4461: BEGIN
4462: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4463: END;
4464: END IF;
4465: Okl_Sif_Fees_Pub.insert_sif_fees(
4466: p_api_version => p_api_version

Line 4465: Okl_Sif_Fees_Pub.insert_sif_fees(

4461: BEGIN
4462: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4463: END;
4464: END IF;
4465: Okl_Sif_Fees_Pub.insert_sif_fees(
4466: p_api_version => p_api_version
4467: ,p_init_msg_list => p_init_msg_list
4468:
4469: ,x_return_status => l_return_status

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

4472: ,p_sfev_tbl => lp_sfev_periodic_expenses_tbl
4473: ,x_sfev_tbl => lx_sfev_periodic_expenses_tbl);
4474: IF(IS_DEBUG_PROCEDURE_ON) THEN
4475: BEGIN
4476: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4477: END;
4478: END IF;
4479: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4480: IF l_return_status = G_RET_STS_ERROR THEN

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

4475: BEGIN
4476: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4477: END;
4478: END IF;
4479: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4480: IF l_return_status = G_RET_STS_ERROR THEN
4481: RAISE G_EXCEPTION_ERROR;
4482: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4483: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

4842: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4843: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4844: END IF;
4845: -- Insert Rent Details
4846: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4847: IF(IS_DEBUG_PROCEDURE_ON) THEN
4848: BEGIN
4849: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4850: END;

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

4845: -- Insert Rent Details
4846: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4847: IF(IS_DEBUG_PROCEDURE_ON) THEN
4848: BEGIN
4849: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4850: END;
4851: END IF;
4852:
4853: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 4853: Okl_Sif_Fees_Pub.insert_sif_fees(

4849: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4850: END;
4851: END IF;
4852:
4853: Okl_Sif_Fees_Pub.insert_sif_fees(
4854: p_api_version => p_api_version
4855: ,p_init_msg_list => p_init_msg_list
4856: ,x_return_status => l_return_status
4857: ,x_msg_count => x_msg_count

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

4859: ,p_sfev_tbl => lp_sfev_rent_tbl
4860: ,x_sfev_tbl => lx_sfev_rent_tbl);
4861: IF(IS_DEBUG_PROCEDURE_ON) THEN
4862: BEGIN
4863: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4864: END;
4865:
4866: END IF;
4867: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

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

4863: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4864: END;
4865:
4866: END IF;
4867: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4868: IF l_return_status = G_RET_STS_ERROR THEN
4869: RAISE G_EXCEPTION_ERROR;
4870: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4871: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

4883: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4884: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4885: END IF;
4886:
4887: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4888: IF(IS_DEBUG_PROCEDURE_ON) THEN
4889: BEGIN
4890: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4891: END;

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

4886:
4887: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4888: IF(IS_DEBUG_PROCEDURE_ON) THEN
4889: BEGIN
4890: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4891: END;
4892: END IF;
4893: Okl_Sif_Fees_Pub.insert_sif_fees(
4894: p_api_version => p_api_version

Line 4893: Okl_Sif_Fees_Pub.insert_sif_fees(

4889: BEGIN
4890: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4891: END;
4892: END IF;
4893: Okl_Sif_Fees_Pub.insert_sif_fees(
4894: p_api_version => p_api_version
4895: ,p_init_msg_list => p_init_msg_list
4896: ,x_return_status => l_return_status
4897: ,x_msg_count => x_msg_count

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

4899: ,p_sfev_tbl => lp_sfev_one_off_tbl
4900: ,x_sfev_tbl => lx_sfev_one_off_tbl);
4901: IF(IS_DEBUG_PROCEDURE_ON) THEN
4902: BEGIN
4903: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4904: END;
4905: END IF;
4906: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4907: IF l_return_status = G_RET_STS_ERROR THEN

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

4902: BEGIN
4903: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4904: END;
4905: END IF;
4906: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4907: IF l_return_status = G_RET_STS_ERROR THEN
4908: RAISE G_EXCEPTION_ERROR;
4909: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4910: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

4923:
4924: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4925: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4926: END IF;
4927: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4928: IF(IS_DEBUG_PROCEDURE_ON) THEN
4929: BEGIN
4930: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4931: END;

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

4926: END IF;
4927: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4928: IF(IS_DEBUG_PROCEDURE_ON) THEN
4929: BEGIN
4930: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4931: END;
4932: END IF;
4933: Okl_Sif_Fees_Pub.insert_sif_fees(
4934: p_api_version => p_api_version

Line 4933: Okl_Sif_Fees_Pub.insert_sif_fees(

4929: BEGIN
4930: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4931: END;
4932: END IF;
4933: Okl_Sif_Fees_Pub.insert_sif_fees(
4934: p_api_version => p_api_version
4935: ,p_init_msg_list => p_init_msg_list
4936: ,x_return_status => l_return_status
4937: ,x_msg_count => x_msg_count

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

4940: ,x_sfev_tbl => lx_sfev_periodic_tbl);
4941: IF(IS_DEBUG_PROCEDURE_ON) THEN
4942: BEGIN
4943:
4944: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4945: END;
4946: END IF;
4947: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4948: IF l_return_status = G_RET_STS_ERROR THEN

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

4943:
4944: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4945: END;
4946: END IF;
4947: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4948: IF l_return_status = G_RET_STS_ERROR THEN
4949: RAISE G_EXCEPTION_ERROR;
4950: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4951: RAISE G_EXCEPTION_UNEXPECTED_ERROR;