69: END IF;
70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
74: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
75: FND_MSG_PUB.ADD;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: END;
70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
74: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
75: FND_MSG_PUB.ADD;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: END;
78:
152: WHEN OTHERS THEN
153: IF c1%ISOPEN THEN
154: CLOSE c1;
155: END IF;
156: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
157: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
158: FND_MSG_PUB.ADD;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160:
153: IF c1%ISOPEN THEN
154: CLOSE c1;
155: END IF;
156: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
157: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
158: FND_MSG_PUB.ADD;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160:
161: END;
281: EXCEPTION
282:
283: WHEN OTHERS THEN
284:
285: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
286: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
287: FND_MSG_PUB.ADD;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289:
282:
283: WHEN OTHERS THEN
284:
285: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
286: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
287: FND_MSG_PUB.ADD;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289:
290: END;