7753: END;
7754:
7755: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7756: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
7757: 'OKC_CONTRACT_APPROVAL_PUB.k_approval_start(p_contract_id= '||
7758: p_contract_id||' p_process_id='||p_process_id||')');
7759: END IF;
7760:
7761: BEGIN
7758: p_contract_id||' p_process_id='||p_process_id||')');
7759: END IF;
7760:
7761: BEGIN
7762: OKC_CONTRACT_APPROVAL_PUB.k_approval_start
7763: (
7764: p_api_version => p_api_version,
7765: p_init_msg_list => p_init_msg_list,
7766: x_return_status => x_return_status,
7786: END IF;
7787: END;
7788: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7789: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
7790: 'OKC_CONTRACT_APPROVAL_PUB.k_approval_start(x_return_status= '||
7791: x_return_status||' x_msg_count='||x_msg_count||')');
7792: END IF;
7793: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7794: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
7870: END IF;
7871:
7872: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7873: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
7874: 'OKC_CONTRACT_APPROVAL_PUB.k_approval_start(p_contract_id= '||
7875: l_contract_id||' p_process_id='||l_pdf_id||')');
7876: END IF;
7877: BEGIN
7878: k_approval_start
7898: END IF;
7899: END;
7900: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7901: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
7902: 'OKC_CONTRACT_APPROVAL_PUB.k_approval_start(x_return_status= '||
7903: l_return_status||' x_msg_count='||l_msg_count||')');
7904: END IF;
7905:
7906: IF l_return_status <> G_RET_STS_SUCCESS THEN
8639: aname => 'CONTRACT_ID');
8640:
8641: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8642: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8643: 'OKC_CONTRACT_APPROVAL_PUB.k_approved(p_contract_id= '||l_contract_id||')');
8644: END IF;
8645: -- update the date approved of the contract
8646: OKC_CONTRACT_APPROVAL_PUB.k_approved
8647: (
8642: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8643: 'OKC_CONTRACT_APPROVAL_PUB.k_approved(p_contract_id= '||l_contract_id||')');
8644: END IF;
8645: -- update the date approved of the contract
8646: OKC_CONTRACT_APPROVAL_PUB.k_approved
8647: (
8648: p_contract_id => l_contract_id,
8649: x_return_status => l_return_status
8650: );
8649: x_return_status => l_return_status
8650: );
8651: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8652: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8653: 'OKC_CONTRACT_APPROVAL_PUB.k_approved(x_return_status= '||l_return_status||')');
8654: END IF;
8655: IF l_return_status <> G_RET_STS_SUCCESS THEN
8656: update_negotiation_status
8657: (
8703: END IF;
8704:
8705: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8706: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8707: 'OKC_CONTRACT_APPROVAL_PUB.k_signed(p_contract_id= '||l_contract_id||')');
8708: END IF;
8709: -- sign the contract
8710: OKC_CONTRACT_APPROVAL_PUB.k_signed
8711: (
8706: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8707: 'OKC_CONTRACT_APPROVAL_PUB.k_signed(p_contract_id= '||l_contract_id||')');
8708: END IF;
8709: -- sign the contract
8710: OKC_CONTRACT_APPROVAL_PUB.k_signed
8711: (
8712: p_contract_id => l_contract_id,
8713: p_complete_k_prcs => 'N',
8714: x_return_status => l_return_status
8714: x_return_status => l_return_status
8715: );
8716: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8717: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8718: 'OKC_CONTRACT_APPROVAL_PUB.k_signed(x_return_status= '||l_return_status||')');
8719: END IF;
8720: IF l_return_status <> G_RET_STS_SUCCESS THEN
8721: update_negotiation_status
8722: (