DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_CHECK dependencies on FND_MESSAGE

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

89: RETURN FND_API.G_TRUE;
90:
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;

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

90:
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:

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

221: RETURN FND_API.G_TRUE;
222:
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;

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

222:
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:

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

270: RETURN FND_API.G_TRUE;
271:
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;

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

271:
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:

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

326: RETURN FND_API.G_TRUE;
327:
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;

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

327:
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:

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

399:
400: RETURN FND_API.G_TRUE;
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;

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

400: RETURN FND_API.G_TRUE;
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:

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

461: RETURN FND_API.G_TRUE;
462:
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;

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

462:
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:

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

568: RETURN FND_API.G_TRUE;
569:
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;

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

569:
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:

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

623: RETURN FND_API.G_TRUE;
624:
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;

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

624:
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:

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

674: RETURN FND_API.G_TRUE;
675:
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;

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

675:
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:

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

721: RETURN FND_API.G_TRUE;
722:
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;

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

722:
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:

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

779: RETURN FND_API.G_TRUE;
780:
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;

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

780:
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:

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

837: RETURN FND_API.G_TRUE;
838:
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;

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

838:
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:

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

880: RETURN FND_API.G_TRUE;
881:
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;

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

881:
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:

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

944: RETURN FND_API.G_TRUE;
945:
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;

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

945:
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:

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

989: RETURN FND_API.G_TRUE;
990:
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;

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

990:
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:

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

1035: RETURN FND_API.G_TRUE;
1036:
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;

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

1036:
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:

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

1078: RETURN FND_API.G_TRUE;
1079:
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;

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

1079:
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:

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

1295: RETURN FND_API.G_TRUE;
1296:
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;

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

1296:
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:

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

1359: RETURN FND_API.G_TRUE;
1360:
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;

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

1360:
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: