1: PACKAGE BODY HZ_MATCH_RULE_2 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_2
8: |
9: | DESCRIPTION
10: |
11: | Compiled by the HZ Match Rule Compiler
2910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END find_parties;
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694: WHEN OTHERS THEN
3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3697: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3700: END find_persons;
3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3762: WHEN OTHERS THEN
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3766: FND_MSG_PUB.ADD;
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: END find_party_details;
3877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3879: WHEN OTHERS THEN
3880: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3881: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3883: FND_MSG_PUB.ADD;
3884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3885: END find_duplicate_parties;
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: WHEN OTHERS THEN
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3966: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3967: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3968: FND_MSG_PUB.ADD;
3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3970: END find_duplicate_party_sites;
4051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4053: WHEN OTHERS THEN
4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4057: FND_MSG_PUB.ADD;
4058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4059: END find_duplicate_contacts;
4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126: WHEN OTHERS THEN
4127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');
4129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4130: FND_MSG_PUB.ADD;
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4132: END find_duplicate_contact_points;
4391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4393: WHEN OTHERS THEN
4394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4395: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4397: FND_MSG_PUB.ADD;
4398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4399: END call_api_dynamic;
4624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: WHEN OTHERS THEN
4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4630: FND_MSG_PUB.ADD;
4631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4632: END get_matching_party_sites;
4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: WHEN OTHERS THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4855: FND_MSG_PUB.ADD;
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: END get_matching_contacts;
4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: WHEN OTHERS THEN
4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4994: FND_MSG_PUB.ADD;
4995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4996: END get_matching_contact_points;
5186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5188: WHEN OTHERS THEN
5189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5192: FND_MSG_PUB.ADD;
5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5194: END get_score_details;