332: OKC_OKS_PUB.OKS_UPDATE_CONTRACT(p_from_id => p_from_fk_id,
333: p_to_id => p_to_fk_id,
334: x_return_status => l_return_status);
335:
336: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
339: RAISE OKC_API.G_EXCEPTION_ERROR;
340: END IF;
333: p_to_id => p_to_fk_id,
334: x_return_status => l_return_status);
335:
336: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
339: RAISE OKC_API.G_EXCEPTION_ERROR;
340: END IF;
341:
334: x_return_status => l_return_status);
335:
336: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
339: RAISE OKC_API.G_EXCEPTION_ERROR;
340: END IF;
341:
342: --
335:
336: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
339: RAISE OKC_API.G_EXCEPTION_ERROR;
340: END IF;
341:
342: --
343: -- Following where clause removed after update from TCA (02/09/2001)
359: arp_message.set_name('AR','AR_ROWS_UPDATED');
360: arp_message.set_token('NUM_ROWS',to_char(l_count));
361: --
362: exception
363: when OKC_API.G_EXCEPTION_ERROR THEN -- Bug 2949149
364: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
365: fnd_file.put_line(fnd_file.log, g_proc_name||'.'||l_api_name||':'||sqlerrm);
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN -- Bug 2949149
363: when OKC_API.G_EXCEPTION_ERROR THEN -- Bug 2949149
364: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
365: fnd_file.put_line(fnd_file.log, g_proc_name||'.'||l_api_name||':'||sqlerrm);
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN -- Bug 2949149
368: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
369: fnd_file.put_line(fnd_file.log, g_proc_name||'.'||l_api_name||':'||sqlerrm);
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: when others then