DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_EXECUTE_FORMULA_PUB

Line 6879: l_params okl_execute_formula_pub.ctxt_val_tbl_type; ---+++ Effective Dated Termination ++++----

6875: l_contract_line NUMBER;
6876: l_api_name CONSTANT VARCHAR2(30) := 'get_refund';
6877: l_api_version CONSTANT NUMBER := 1;
6878: l_return_status VARCHAR2(1) ;
6879: l_params okl_execute_formula_pub.ctxt_val_tbl_type; ---+++ Effective Dated Termination ++++----
6880:
6881: CURSOR okl_ipy_rec(p_policy_id NUMBER) IS
6882: SELECT KHR_ID , KLE_ID
6883: FROM OKL_INS_POLICIES_B

Line 6911: -- Start of wraper code generated automatically by Debug code generator for OKL_EXECUTE_FORMULA_PUB.EXECUTE

6907: CLOSE okl_ipy_rec ;
6908: RAISE OKC_API.G_EXCEPTION_ERROR;
6909: END if ;
6910: CLOSE okl_ipy_rec ;
6911: -- Start of wraper code generated automatically by Debug code generator for OKL_EXECUTE_FORMULA_PUB.EXECUTE
6912: IF(L_DEBUG_ENABLED='Y') THEN
6913: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
6914: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
6915: END IF;

Line 6918: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_EXECUTE_FORMULA_PUB.EXECUTE ');

6914: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
6915: END IF;
6916: IF(IS_DEBUG_PROCEDURE_ON) THEN
6917: BEGIN
6918: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_EXECUTE_FORMULA_PUB.EXECUTE ');
6919: END;
6920: END IF;
6921: --++ Effective Dated Termination ++----
6922: l_params(1).name := G_FORMULA_PARAM_1;

Line 6928: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => l_api_version,

6924: l_params(2).name := G_FORMULA_PARAM_2;
6925: l_params(2).value := to_char(p_crx_code);
6926: --++ Effective Dated Termination ++----
6927:
6928: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => l_api_version,
6929: p_init_msg_list => OKC_API.G_FALSE,
6930: x_return_status => x_return_status,
6931: x_msg_count => x_msg_count,
6932: x_msg_data => x_msg_data,

Line 6940: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_EXECUTE_FORMULA_PUB.EXECUTE ');

6936: p_additional_parameters => l_params, ---+++ Eff Dated Term changes ++----
6937: x_value => x_refund_amount );
6938: IF(IS_DEBUG_PROCEDURE_ON) THEN
6939: BEGIN
6940: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_EXECUTE_FORMULA_PUB.EXECUTE ');
6941: END;
6942: END IF;
6943: -- End of wraper code generated automatically by Debug code generator for OKL_EXECUTE_FORMULA_PUB.EXECUTE
6944: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6943: -- End of wraper code generated automatically by Debug code generator for OKL_EXECUTE_FORMULA_PUB.EXECUTE

6939: BEGIN
6940: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_EXECUTE_FORMULA_PUB.EXECUTE ');
6941: END;
6942: END IF;
6943: -- End of wraper code generated automatically by Debug code generator for OKL_EXECUTE_FORMULA_PUB.EXECUTE
6944: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6946: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6947: RAISE OKC_API.G_EXCEPTION_ERROR;