48: AND party_type in ('C', 'E', 'CARRIER');
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
53: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
54: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', SQLERRM);
55: FND_MSG_PUB.add;
56: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
53: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
54: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', SQLERRM);
55: FND_MSG_PUB.add;
56: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
57: END ecx_party_merge;
50: EXCEPTION
51: WHEN OTHERS THEN
52: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
53: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
54: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', SQLERRM);
55: FND_MSG_PUB.add;
56: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
57: END ecx_party_merge;
58:
98: AND party_type in ('C', 'E', 'CARRIER');
99:
100: EXCEPTION
101: WHEN OTHERS THEN
102: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
103: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
104: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', SQLERRM);
105: FND_MSG_PUB.add;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99:
100: EXCEPTION
101: WHEN OTHERS THEN
102: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
103: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
104: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', SQLERRM);
105: FND_MSG_PUB.add;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: END ecx_party_sites_merge;
100: EXCEPTION
101: WHEN OTHERS THEN
102: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
103: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
104: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', SQLERRM);
105: FND_MSG_PUB.add;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: END ecx_party_sites_merge;
108: END ECX_TP_MERGE_PKG;