83:
84: EXCEPTION
85: WHEN RESOURCE_BUSY THEN
86: FND_MESSAGE.SET_NAME('FTE','FTE_FACILITY_LOCK');
87: FND_MSG_PUB.ADD;
88: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
89: WHEN OTHERS THEN
90: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
91: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
88: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
89: WHEN OTHERS THEN
90: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
91: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
92: FND_MSG_PUB.ADD;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94:
95: END merge_facility_contacts;
96: