532:
533: WHEN OTHERS THEN
534:
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
538: FND_MSG_PUB.ADD;
539: FND_MSG_PUB.Count_And_Get(
540: p_encoded => FND_API.G_FALSE,
533: WHEN OTHERS THEN
534:
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
538: FND_MSG_PUB.ADD;
539: FND_MSG_PUB.Count_And_Get(
540: p_encoded => FND_API.G_FALSE,
541: p_count => x_msg_count,