DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_52 dependencies on HZ_MATCH_RULE_52

Line 1: PACKAGE BODY HZ_MATCH_RULE_52 AS

1: PACKAGE BODY HZ_MATCH_RULE_52 AS
2: /*=======================================================================+
3: | Copyright (c) 1999 Oracle Corporation Redwood Shores, California, USA|
4: | All rights reserved. |
5: +=======================================================================+

Line 7: | HZ_MATCH_RULE_52

3: | Copyright (c) 1999 Oracle Corporation Redwood Shores, California, USA|
4: | All rights reserved. |
5: +=======================================================================+
6: | NAME
7: | HZ_MATCH_RULE_52
8: |
9: | DESCRIPTION
10: |
11: | Compiled by the HZ Match Rule Compiler

Line 2273: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_parties');

2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: WHEN OTHERS THEN
2271: ROLLBACK to find_parties;
2272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2273: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_parties');
2274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END find_parties;

Line 2928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_persons');

2924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2925: WHEN OTHERS THEN
2926: ROLLBACK to find_persons;
2927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_persons');
2929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2930: FND_MSG_PUB.ADD;
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END find_persons;

Line 2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');

2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END find_party_details;

Line 3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');

3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3084: WHEN OTHERS THEN
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');
3087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3090: END find_duplicate_parties;

Line 3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');

3170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: WHEN OTHERS THEN
3173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');
3175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3176: FND_MSG_PUB.ADD;
3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3178: END find_duplicate_party_sites;

Line 3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');

3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: WHEN OTHERS THEN
3265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');
3267: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3268: FND_MSG_PUB.ADD;
3269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3270: END find_duplicate_contacts;

Line 3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');

3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: WHEN OTHERS THEN
3341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');
3343: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3344: FND_MSG_PUB.ADD;
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3346: END find_duplicate_contact_points;

Line 3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');

3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3731: WHEN OTHERS THEN
3732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');
3734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3735: FND_MSG_PUB.ADD;
3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3737: END call_api_dynamic;

Line 3961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_party_sites');

3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: WHEN OTHERS THEN
3959: ROLLBACK to get_matching_party_sites ;
3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_party_sites');
3962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3965: END get_matching_party_sites;

Line 4184: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contacts');

4180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4181: WHEN OTHERS THEN
4182: ROLLBACK to get_matching_contacts ;
4183: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4184: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contacts');
4185: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4186: FND_MSG_PUB.ADD;
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: END get_matching_contacts;

Line 4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contact_points');

4328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4329: WHEN OTHERS THEN
4330: ROLLBACK to get_matching_contact_points ;
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contact_points');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END get_matching_contact_points;

Line 4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_score_details');

4559: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4560: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4561: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_score_details');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: END get_score_details;