242: EXCEPTION
243: WHEN OTHERS THEN
244: IF (SQLCODE = 54) THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
247: ELSE
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: END IF;
250: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
285: WHEN OTHERS THEN
286:
287: IF (SQLCODE = 54) THEN
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MESSAGE.SET_NAME('ZX','ZX_RESOURCE_BUSY');
290: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
291: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
292: END IF;
293: ELSE