91: EXCEPTION
92: WHEN OTHERS THEN
93: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
94: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
95: FND_MSG_PUB.ADD;
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: END check_financial_profile_dup;
98:
99: FUNCTION check_contact_point_dup(
223: EXCEPTION
224: WHEN OTHERS THEN
225: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
226: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
227: FND_MSG_PUB.ADD;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: END check_contact_point_dup;
230:
231: FUNCTION check_references_dup(
272: EXCEPTION
273: WHEN OTHERS THEN
274: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
276: FND_MSG_PUB.ADD;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: END check_references_dup;
279:
280:
328: EXCEPTION
329: WHEN OTHERS THEN
330: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
332: FND_MSG_PUB.ADD;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: END check_certification_dup;
335:
336:
401: EXCEPTION
402: WHEN OTHERS THEN
403: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
404: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
405: FND_MSG_PUB.ADD;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: END check_credit_ratings_dup;
408:
409:
463: EXCEPTION
464: WHEN OTHERS THEN
465: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
467: FND_MSG_PUB.ADD;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: END check_security_issued_dup;
470:
471: FUNCTION check_financial_reports_dup(
570: EXCEPTION
571: WHEN OTHERS THEN
572: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
574: FND_MSG_PUB.ADD;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: END check_financial_reports_dup;
577:
578:
625: EXCEPTION
626: WHEN OTHERS THEN
627: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
628: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
629: FND_MSG_PUB.ADD;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: END check_org_indicators_dup;
632:
633: FUNCTION check_ind_reference_dup(
676: EXCEPTION
677: WHEN OTHERS THEN
678: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
679: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
680: FND_MSG_PUB.ADD;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: END check_ind_reference_dup;
683:
684: FUNCTION check_per_interest_dup(
723: EXCEPTION
724: WHEN OTHERS THEN
725: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
727: FND_MSG_PUB.ADD;
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: END check_per_interest_dup;
730:
731:
781: EXCEPTION
782: WHEN OTHERS THEN
783: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
785: FND_MSG_PUB.ADD;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: END check_citizenship_dup;
788:
789:
839: EXCEPTION
840: WHEN OTHERS THEN
841: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
843: FND_MSG_PUB.ADD;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: END check_education_dup;
846:
847: FUNCTION check_work_class_dup(
882: EXCEPTION
883: WHEN OTHERS THEN
884: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
886: FND_MSG_PUB.ADD;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: END check_work_class_dup;
889:
890:
946: EXCEPTION
947: WHEN OTHERS THEN
948: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
949: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
950: FND_MSG_PUB.ADD;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952: END check_emp_history_dup;
953:
954:
991: EXCEPTION
992: WHEN OTHERS THEN
993: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
994: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
995: FND_MSG_PUB.ADD;
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: END check_languages_dup;
998:
999: FUNCTION check_party_site_use_dup(
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1041: FND_MSG_PUB.ADD;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: END check_party_site_use_dup;
1044:
1045: FUNCTION check_party_site_dup(
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1084: FND_MSG_PUB.ADD;
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: END check_party_site_dup;
1087:
1088: FUNCTION check_code_assignment_dup(
1297: EXCEPTION
1298: WHEN OTHERS THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1301: FND_MSG_PUB.ADD;
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1303: END check_contact_preference_dup;
1304:
1305: --Bug No: 4577535 fix checking for duplicate addresses
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1365: FND_MSG_PUB.ADD;
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367: END check_address_dup;
1368:
1369: END HZ_MERGE_DUP_CHECK;