1: PACKAGE BODY HZ_MATCH_RULE_58 AS
2: /*=======================================================================+
3: | Copyright (c) 1999 Oracle Corporation Redwood Shores, California, USA|
4: | All rights reserved. |
5: +=======================================================================+
3: | Copyright (c) 1999 Oracle Corporation Redwood Shores, California, USA|
4: | All rights reserved. |
5: +=======================================================================+
6: | NAME
7: | HZ_MATCH_RULE_58
8: |
9: | DESCRIPTION
10: |
11: | Compiled by the HZ Match Rule Compiler
3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END find_parties;
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4056: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4058: FND_MSG_PUB.ADD;
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: END find_persons;
4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: WHEN OTHERS THEN
4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4124: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4126: FND_MSG_PUB.ADD;
4127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4128: END find_party_details;
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: WHEN OTHERS THEN
4240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4241: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4243: FND_MSG_PUB.ADD;
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: END find_duplicate_parties;
4322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4324: WHEN OTHERS THEN
4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4326: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4328: FND_MSG_PUB.ADD;
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: END find_duplicate_party_sites;
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: WHEN OTHERS THEN
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4415: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: END find_duplicate_contacts;
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4486: WHEN OTHERS THEN
4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4488: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4492: END find_duplicate_contact_points;
4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END call_api_dynamic;
5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036: WHEN OTHERS THEN
5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5040: FND_MSG_PUB.ADD;
5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5042: END get_matching_party_sites;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_contacts;
5405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: WHEN OTHERS THEN
5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5411: FND_MSG_PUB.ADD;
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5413: END get_matching_contact_points;
5615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5621: FND_MSG_PUB.ADD;
5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5623: END get_score_details;