1670:
1671: WHEN OTHERS THEN
1672: ROLLBACK TO create_link;
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1675: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1676: FND_MSG_PUB.ADD;
1677: FND_MSG_PUB.Count_And_Get(
1678: p_encoded => FND_API.G_FALSE,
1671: WHEN OTHERS THEN
1672: ROLLBACK TO create_link;
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1675: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1676: FND_MSG_PUB.ADD;
1677: FND_MSG_PUB.Count_And_Get(
1678: p_encoded => FND_API.G_FALSE,
1679: p_count => x_msg_count,
1831:
1832: WHEN OTHERS THEN
1833: ROLLBACK TO update_link;
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;
1838: FND_MSG_PUB.Count_And_Get(
1839: p_encoded => FND_API.G_FALSE,
1832: WHEN OTHERS THEN
1833: ROLLBACK TO update_link;
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;
1838: FND_MSG_PUB.Count_And_Get(
1839: p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,