1: PACKAGE BODY HZ_MATCH_RULE_35 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_35
8: |
9: | DESCRIPTION
10: |
11: | Compiled by the HZ Match Rule Compiler
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3290: WHEN OTHERS THEN
3291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3294: FND_MSG_PUB.ADD;
3295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3296: END find_parties;
4147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: WHEN OTHERS THEN
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4153: FND_MSG_PUB.ADD;
4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4155: END find_persons;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4221: FND_MSG_PUB.ADD;
4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4223: END find_party_details;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4340: END find_duplicate_parties;
4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: WHEN OTHERS THEN
4420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4421: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');
4422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4423: FND_MSG_PUB.ADD;
4424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4425: END find_duplicate_party_sites;
4506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4508: WHEN OTHERS THEN
4509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4510: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4511: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4512: FND_MSG_PUB.ADD;
4513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4514: END find_duplicate_contacts;
4579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4581: WHEN OTHERS THEN
4582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4583: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');
4584: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4585: FND_MSG_PUB.ADD;
4586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4587: END find_duplicate_contact_points;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4875: END call_api_dynamic;
5105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: WHEN OTHERS THEN
5108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5109: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5111: FND_MSG_PUB.ADD;
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: END get_matching_party_sites;
5330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5332: WHEN OTHERS THEN
5333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5336: FND_MSG_PUB.ADD;
5337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5338: END get_matching_contacts;
5469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5471: WHEN OTHERS THEN
5472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5473: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5475: FND_MSG_PUB.ADD;
5476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5477: END get_matching_contact_points;
5688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: WHEN OTHERS THEN
5691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5694: FND_MSG_PUB.ADD;
5695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5696: END get_score_details;