2882: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2883: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2884: END IF;
2885: -- Insert Yield Data corresponding to this Transaction
2886: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
2887: IF(IS_DEBUG_PROCEDURE_ON) THEN
2888: BEGIN
2889: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
2890: END;
2885: -- Insert Yield Data corresponding to this Transaction
2886: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
2887: IF(IS_DEBUG_PROCEDURE_ON) THEN
2888: BEGIN
2889: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
2890: END;
2891: END IF;
2892: Okl_Sif_Yields_Pub.insert_sif_yields(
2893: p_api_version => p_api_version
2888: BEGIN
2889: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
2890: END;
2891: END IF;
2892: Okl_Sif_Yields_Pub.insert_sif_yields(
2893: p_api_version => p_api_version
2894: ,p_init_msg_list => p_init_msg_list
2895: ,x_return_status => l_return_status
2896: ,x_msg_count => x_msg_count
2899:
2900: ,x_siyv_tbl => lx_siyv_tbl);
2901: --Added by kthiruva for Debugging
2902: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2903: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Yields_Pub.insert_sif_yields, the return status is :'||l_return_status);
2904: END IF;
2905:
2906:
2907: IF(IS_DEBUG_PROCEDURE_ON) THEN
2905:
2906:
2907: IF(IS_DEBUG_PROCEDURE_ON) THEN
2908: BEGIN
2909: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
2910: END;
2911: END IF;
2912:
2913: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
2909: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
2910: END;
2911: END IF;
2912:
2913: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
2914: IF l_return_status = G_RET_STS_ERROR THEN
2915: RAISE G_EXCEPTION_ERROR;
2916: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2917: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3519: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3520: END IF;
3521: -- Insert Yield Data corresponding to this Transaction
3522:
3523: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
3524: IF(IS_DEBUG_PROCEDURE_ON) THEN
3525: BEGIN
3526: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
3527: END;
3522:
3523: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
3524: IF(IS_DEBUG_PROCEDURE_ON) THEN
3525: BEGIN
3526: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
3527: END;
3528: END IF;
3529: Okl_Sif_Yields_Pub.insert_sif_yields(
3530: p_api_version => p_api_version
3525: BEGIN
3526: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
3527: END;
3528: END IF;
3529: Okl_Sif_Yields_Pub.insert_sif_yields(
3530: p_api_version => p_api_version
3531: ,p_init_msg_list => p_init_msg_list
3532: ,x_return_status => l_return_status
3533: ,x_msg_count => x_msg_count
3535: ,p_siyv_tbl => lp_siyv_tbl
3536: ,x_siyv_tbl => lx_siyv_tbl);
3537: --Added by kthiruva for Debug Logging
3538: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Yields_Pub.insert_sif_yields,return status is :'||l_return_status);
3540: END IF;
3541:
3542: IF(IS_DEBUG_PROCEDURE_ON) THEN
3543: BEGIN
3541:
3542: IF(IS_DEBUG_PROCEDURE_ON) THEN
3543: BEGIN
3544:
3545: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
3546:
3547: END;
3548: END IF;
3549: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
3545: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
3546:
3547: END;
3548: END IF;
3549: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
3550: IF l_return_status = G_RET_STS_ERROR THEN
3551: RAISE G_EXCEPTION_ERROR;
3552: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3553: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4221: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4222: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4223: END IF;
4224: -- Insert Yield Data corresponding to this Transaction
4225: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4226: IF(IS_DEBUG_PROCEDURE_ON) THEN
4227: BEGIN
4228: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4229: END;
4224: -- Insert Yield Data corresponding to this Transaction
4225: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4226: IF(IS_DEBUG_PROCEDURE_ON) THEN
4227: BEGIN
4228: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4229: END;
4230: END IF;
4231: Okl_Sif_Yields_Pub.insert_sif_yields(
4232: p_api_version => p_api_version
4227: BEGIN
4228: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4229: END;
4230: END IF;
4231: Okl_Sif_Yields_Pub.insert_sif_yields(
4232: p_api_version => p_api_version
4233: ,p_init_msg_list => p_init_msg_list
4234: ,x_return_status => l_return_status
4235: ,x_msg_count => x_msg_count
4237: ,p_siyv_tbl => lp_siyv_tbl
4238: ,x_siyv_tbl => lx_siyv_tbl);
4239: IF(IS_DEBUG_PROCEDURE_ON) THEN
4240: BEGIN
4241: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4242: END;
4243:
4244: END IF;
4245: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4241: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4242: END;
4243:
4244: END IF;
4245: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4246: IF l_return_status = G_RET_STS_ERROR THEN
4247: RAISE G_EXCEPTION_ERROR;
4248: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4249:
4757: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4758: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4759: END IF;
4760: -- Insert Yield Data corresponding to this Transaction
4761: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4762: IF(IS_DEBUG_PROCEDURE_ON) THEN
4763: BEGIN
4764: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4765: END;
4760: -- Insert Yield Data corresponding to this Transaction
4761: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4762: IF(IS_DEBUG_PROCEDURE_ON) THEN
4763: BEGIN
4764: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4765: END;
4766: END IF;
4767: Okl_Sif_Yields_Pub.insert_sif_yields(
4768: p_api_version => p_api_version
4763: BEGIN
4764: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4765: END;
4766: END IF;
4767: Okl_Sif_Yields_Pub.insert_sif_yields(
4768: p_api_version => p_api_version
4769: ,p_init_msg_list => p_init_msg_list
4770: ,x_return_status => l_return_status
4771: ,x_msg_count => x_msg_count
4774: ,p_siyv_tbl => lp_siyv_tbl
4775: ,x_siyv_tbl => lx_siyv_tbl);
4776: IF(IS_DEBUG_PROCEDURE_ON) THEN
4777: BEGIN
4778: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4779: END;
4780: END IF;
4781: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4782: IF l_return_status = G_RET_STS_ERROR THEN
4777: BEGIN
4778: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4779: END;
4780: END IF;
4781: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4782: IF l_return_status = G_RET_STS_ERROR THEN
4783: RAISE G_EXCEPTION_ERROR;
4784: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4785: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
5227: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5228: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
5229: END IF;
5230: -- Insert Yield Data corresponding to this Transaction
5231: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
5232:
5233: IF(IS_DEBUG_PROCEDURE_ON) THEN
5234: BEGIN
5235: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
5231: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
5232:
5233: IF(IS_DEBUG_PROCEDURE_ON) THEN
5234: BEGIN
5235: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
5236: END;
5237: END IF;
5238: Okl_Sif_Yields_Pub.insert_sif_yields(
5239:
5234: BEGIN
5235: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
5236: END;
5237: END IF;
5238: Okl_Sif_Yields_Pub.insert_sif_yields(
5239:
5240: p_api_version => p_api_version
5241: ,p_init_msg_list => p_init_msg_list
5242: ,x_return_status => l_return_status
5245: ,p_siyv_tbl => lp_siyv_tbl
5246: ,x_siyv_tbl => lx_siyv_tbl);
5247: IF(IS_DEBUG_PROCEDURE_ON) THEN
5248: BEGIN
5249: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
5250: END;
5251: END IF;
5252: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
5253: IF l_return_status = G_RET_STS_ERROR THEN
5248: BEGIN
5249: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
5250: END;
5251: END IF;
5252: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
5253: IF l_return_status = G_RET_STS_ERROR THEN
5254: RAISE G_EXCEPTION_ERROR;
5255: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
5256: