DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_CHECK dependencies on FND_MSG_PUB

Line 95: FND_MSG_PUB.ADD;

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(

Line 227: FND_MSG_PUB.ADD;

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(

Line 276: FND_MSG_PUB.ADD;

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:

Line 332: FND_MSG_PUB.ADD;

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:

Line 405: FND_MSG_PUB.ADD;

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:

Line 467: FND_MSG_PUB.ADD;

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(

Line 574: FND_MSG_PUB.ADD;

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:

Line 629: FND_MSG_PUB.ADD;

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(

Line 680: FND_MSG_PUB.ADD;

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(

Line 727: FND_MSG_PUB.ADD;

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:

Line 785: FND_MSG_PUB.ADD;

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:

Line 843: FND_MSG_PUB.ADD;

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(

Line 886: FND_MSG_PUB.ADD;

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:

Line 950: FND_MSG_PUB.ADD;

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:

Line 995: FND_MSG_PUB.ADD;

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(

Line 1041: FND_MSG_PUB.ADD;

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(

Line 1084: FND_MSG_PUB.ADD;

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(

Line 1301: FND_MSG_PUB.ADD;

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

Line 1365: FND_MSG_PUB.ADD;

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;