DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_EXECUTE_FORMULA_PUB

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

6882: l_contract_line NUMBER;
6883: l_api_name CONSTANT VARCHAR2(30) := 'get_refund';
6884: l_api_version CONSTANT NUMBER := 1;
6885: l_return_status VARCHAR2(1) ;
6886: l_params okl_execute_formula_pub.ctxt_val_tbl_type; ---+++ Effective Dated Termination ++++----
6887:
6888: CURSOR okl_ipy_rec(p_policy_id NUMBER) IS
6889: SELECT KHR_ID , KLE_ID
6890: FROM OKL_INS_POLICIES_B

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

6914: CLOSE okl_ipy_rec ;
6915: RAISE OKC_API.G_EXCEPTION_ERROR;
6916: END if ;
6917: CLOSE okl_ipy_rec ;
6918: -- Start of wraper code generated automatically by Debug code generator for OKL_EXECUTE_FORMULA_PUB.EXECUTE
6919: IF(L_DEBUG_ENABLED='Y') THEN
6920: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
6921: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
6922: END IF;

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

6921: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
6922: END IF;
6923: IF(IS_DEBUG_PROCEDURE_ON) THEN
6924: BEGIN
6925: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_EXECUTE_FORMULA_PUB.EXECUTE ');
6926: END;
6927: END IF;
6928: --++ Effective Dated Termination ++----
6929: l_params(1).name := G_FORMULA_PARAM_1;

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

6931: l_params(2).name := G_FORMULA_PARAM_2;
6932: l_params(2).value := to_char(p_crx_code);
6933: --++ Effective Dated Termination ++----
6934:
6935: OKL_EXECUTE_FORMULA_PUB.EXECUTE(p_api_version => l_api_version,
6936: p_init_msg_list => OKC_API.G_FALSE,
6937: x_return_status => x_return_status,
6938: x_msg_count => x_msg_count,
6939: x_msg_data => x_msg_data,

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

6943: p_additional_parameters => l_params, ---+++ Eff Dated Term changes ++----
6944: x_value => x_refund_amount );
6945: IF(IS_DEBUG_PROCEDURE_ON) THEN
6946: BEGIN
6947: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_EXECUTE_FORMULA_PUB.EXECUTE ');
6948: END;
6949: END IF;
6950: -- End of wraper code generated automatically by Debug code generator for OKL_EXECUTE_FORMULA_PUB.EXECUTE
6951: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

6946: BEGIN
6947: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_EXECUTE_FORMULA_PUB.EXECUTE ');
6948: END;
6949: END IF;
6950: -- End of wraper code generated automatically by Debug code generator for OKL_EXECUTE_FORMULA_PUB.EXECUTE
6951: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6952: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6953: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6954: RAISE OKC_API.G_EXCEPTION_ERROR;