7449: END;
7450:
7451: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7452: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
7453: 'OKC_CONTRACT_APPROVAL_PUB.k_approval_start(p_contract_id= '||
7454: p_contract_id||' p_process_id='||p_process_id||')');
7455: END IF;
7456:
7457: BEGIN
7454: p_contract_id||' p_process_id='||p_process_id||')');
7455: END IF;
7456:
7457: BEGIN
7458: OKC_CONTRACT_APPROVAL_PUB.k_approval_start
7459: (
7460: p_api_version => p_api_version,
7461: p_init_msg_list => p_init_msg_list,
7462: x_return_status => x_return_status,
7482: END IF;
7483: END;
7484: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7485: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
7486: 'OKC_CONTRACT_APPROVAL_PUB.k_approval_start(x_return_status= '||
7487: x_return_status||' x_msg_count='||x_msg_count||')');
7488: END IF;
7489: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
7566: END IF;
7567:
7568: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7569: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
7570: 'OKC_CONTRACT_APPROVAL_PUB.k_approval_start(p_contract_id= '||
7571: l_contract_id||' p_process_id='||l_pdf_id||')');
7572: END IF;
7573: BEGIN
7574: k_approval_start
7594: END IF;
7595: END;
7596: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7597: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
7598: 'OKC_CONTRACT_APPROVAL_PUB.k_approval_start(x_return_status= '||
7599: l_return_status||' x_msg_count='||l_msg_count||')');
7600: END IF;
7601:
7602: IF l_return_status <> G_RET_STS_SUCCESS THEN
8335: aname => 'CONTRACT_ID');
8336:
8337: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8338: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8339: 'OKC_CONTRACT_APPROVAL_PUB.k_approved(p_contract_id= '||l_contract_id||')');
8340: END IF;
8341: -- update the date approved of the contract
8342: OKC_CONTRACT_APPROVAL_PUB.k_approved
8343: (
8338: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8339: 'OKC_CONTRACT_APPROVAL_PUB.k_approved(p_contract_id= '||l_contract_id||')');
8340: END IF;
8341: -- update the date approved of the contract
8342: OKC_CONTRACT_APPROVAL_PUB.k_approved
8343: (
8344: p_contract_id => l_contract_id,
8345: x_return_status => l_return_status
8346: );
8345: x_return_status => l_return_status
8346: );
8347: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8348: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8349: 'OKC_CONTRACT_APPROVAL_PUB.k_approved(x_return_status= '||l_return_status||')');
8350: END IF;
8351: IF l_return_status <> G_RET_STS_SUCCESS THEN
8352: update_negotiation_status
8353: (
8399: END IF;
8400:
8401: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8402: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8403: 'OKC_CONTRACT_APPROVAL_PUB.k_signed(p_contract_id= '||l_contract_id||')');
8404: END IF;
8405: -- sign the contract
8406: OKC_CONTRACT_APPROVAL_PUB.k_signed
8407: (
8402: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
8403: 'OKC_CONTRACT_APPROVAL_PUB.k_signed(p_contract_id= '||l_contract_id||')');
8404: END IF;
8405: -- sign the contract
8406: OKC_CONTRACT_APPROVAL_PUB.k_signed
8407: (
8408: p_contract_id => l_contract_id,
8409: p_complete_k_prcs => 'N',
8410: x_return_status => l_return_status
8410: x_return_status => l_return_status
8411: );
8412: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8413: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
8414: 'OKC_CONTRACT_APPROVAL_PUB.k_signed(x_return_status= '||l_return_status||')');
8415: END IF;
8416: IF l_return_status <> G_RET_STS_SUCCESS THEN
8417: update_negotiation_status
8418: (