[Home] [Help]
529: itemkey => itemkey,
530: aname => G_WF_ITM_AGREEMENT_ID);
531:
532: IF(G_WF_ITM_APPROVED_YN_YES = lv_approval_status OR lv_approval_status_ame = 'Y')THEN
533: okl_contract_status_pub.update_contract_status(p_api_version => '1.0'
534: ,p_init_msg_list => OKL_API.G_TRUE
535: ,x_return_status => x_return_status
536: ,x_msg_count => x_msg_count
537: ,x_msg_data => x_msg_data
541: -- write to log
542: IF(NVL(l_debug_enabled,'N')='Y') THEN
543: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
544: l_module,
545: 'okl_contract_status_pub.update_contract_status G_ACTIVE_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
546: );
547: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
548: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status OR lv_approval_status_ame = 'N')THEN
554: okl_contract_status_pub.update_contract_status(p_api_version => '1.0'
555: ,p_init_msg_list => OKL_API.G_TRUE
556: ,x_return_status => x_return_status
557: ,x_msg_count => x_msg_count
558: ,x_msg_data => x_msg_data
562: -- write to log
563: IF(NVL(l_debug_enabled,'N')='Y') THEN
564: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
565: l_module,
566: 'okl_contract_status_pub.update_contract_status G_DECLINED_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
567: );
568: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
569: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;