DBA Data[Home] [Help]

APPS.OKC_PARTY_MERGE_PUB dependencies on OKC_API

Line 336: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 337: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 338: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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: --

Line 339: RAISE OKC_API.G_EXCEPTION_ERROR;

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)

Line 363: when OKC_API.G_EXCEPTION_ERROR THEN -- Bug 2949149

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

Line 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