174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: NULL;
177: WHEN OTHERS THEN
178: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
179: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
180: FND_MSG_PUB.ADD;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: END;
175: WHEN NO_DATA_FOUND THEN
176: NULL;
177: WHEN OTHERS THEN
178: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
179: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
180: FND_MSG_PUB.ADD;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: END;
183: END IF; -- p_from_fk_id <> p_to_fk_id
317: EXCEPTION
318: WHEN NO_DATA_FOUND THEN
319: NULL;
320: WHEN OTHERS THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
323: FND_MSG_PUB.ADD;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325: END;
318: WHEN NO_DATA_FOUND THEN
319: NULL;
320: WHEN OTHERS THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
323: FND_MSG_PUB.ADD;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325: END;
326: END IF;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: NULL;
471: WHEN OTHERS THEN
472: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: END;
469: WHEN NO_DATA_FOUND THEN
470: NULL;
471: WHEN OTHERS THEN
472: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: END;
477: END IF;
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: NULL;
631: WHEN OTHERS THEN
632: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
634: FND_MSG_PUB.ADD;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: END;
629: WHEN NO_DATA_FOUND THEN
630: NULL;
631: WHEN OTHERS THEN
632: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
634: FND_MSG_PUB.ADD;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: END;
637: END IF;
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN
843: NULL;
844: WHEN OTHERS THEN
845: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
847: FND_MSG_PUB.ADD;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: end ZX_CUSTOMER_VETO_PVT;
842: WHEN NO_DATA_FOUND THEN
843: NULL;
844: WHEN OTHERS THEN
845: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
847: FND_MSG_PUB.ADD;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: end ZX_CUSTOMER_VETO_PVT;
850:
999: EXCEPTION
1000: WHEN NO_DATA_FOUND THEN
1001: NULL;
1002: WHEN OTHERS THEN
1003: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1004: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1005: FND_MSG_PUB.ADD;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: END;
1000: WHEN NO_DATA_FOUND THEN
1001: NULL;
1002: WHEN OTHERS THEN
1003: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1004: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1005: FND_MSG_PUB.ADD;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: END;
1008: END IF;