DBA Data[Home] [Help]

APPS.ZX_PARTY_MERGE_PKG dependencies on FND_MESSAGE

Line 201: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 347: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 348: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 504: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 505: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 623: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 760: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 922: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;