61: END IF;
62:
63: EXCEPTION
64: WHEN OTHERS THEN
65: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
66: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
67: FND_MSG_PUB.ADD;
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69:
62:
63: EXCEPTION
64: WHEN OTHERS THEN
65: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
66: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
67: FND_MSG_PUB.ADD;
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69:
70: END merge_profitability;