197: EXCEPTION
198: WHEN NO_DATA_FOUND THEN
199: NULL;
200: WHEN OTHERS THEN
201: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
203: FND_MSG_PUB.ADD;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: END;
198: WHEN NO_DATA_FOUND THEN
199: NULL;
200: WHEN OTHERS THEN
201: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
203: FND_MSG_PUB.ADD;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: END;
206: end if; -- p_from_fk_id <> p_to_fk_id
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: NULL;
346: WHEN OTHERS THEN
347: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
348: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: END;
344: WHEN NO_DATA_FOUND THEN
345: NULL;
346: WHEN OTHERS THEN
347: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
348: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: END;
352: end if;
500: EXCEPTION
501: WHEN NO_DATA_FOUND THEN
502: NULL;
503: WHEN OTHERS THEN
504: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
505: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
506: FND_MSG_PUB.ADD;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: END;
501: WHEN NO_DATA_FOUND THEN
502: NULL;
503: WHEN OTHERS THEN
504: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
505: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
506: FND_MSG_PUB.ADD;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: END;
509: end if;
619: EXCEPTION
620: WHEN NO_DATA_FOUND THEN
621: NULL;
622: WHEN OTHERS THEN
623: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
625: FND_MSG_PUB.ADD;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: END;
620: WHEN NO_DATA_FOUND THEN
621: NULL;
622: WHEN OTHERS THEN
623: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
625: FND_MSG_PUB.ADD;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: END;
628: end if;
756: EXCEPTION
757: WHEN NO_DATA_FOUND THEN
758: NULL;
759: WHEN OTHERS THEN
760: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
762: FND_MSG_PUB.ADD;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: end ZX_CUSTOMER_VETO;
757: WHEN NO_DATA_FOUND THEN
758: NULL;
759: WHEN OTHERS THEN
760: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
762: FND_MSG_PUB.ADD;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: end ZX_CUSTOMER_VETO;
765:
918: EXCEPTION
919: WHEN NO_DATA_FOUND THEN
920: NULL;
921: WHEN OTHERS THEN
922: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
924: FND_MSG_PUB.ADD;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: END;
919: WHEN NO_DATA_FOUND THEN
920: NULL;
921: WHEN OTHERS THEN
922: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
924: FND_MSG_PUB.ADD;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: END;
927: end if;