DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_50 dependencies on HZ_MATCH_RULE_50

Line 1: PACKAGE BODY HZ_MATCH_RULE_50 AS

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

Line 7: | HZ_MATCH_RULE_50

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

Line 2206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_parties');

2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2203: WHEN OTHERS THEN
2204: ROLLBACK to find_parties;
2205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_parties');
2207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2208: FND_MSG_PUB.ADD;
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END find_parties;

Line 2860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_persons');

2856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2857: WHEN OTHERS THEN
2858: ROLLBACK to find_persons;
2859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_persons');
2861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2864: END find_persons;

Line 2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');

2926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: WHEN OTHERS THEN
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');
2931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2934: END find_party_details;

Line 3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');

3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: WHEN OTHERS THEN
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');
3019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3022: END find_duplicate_parties;

Line 3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');

3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3104: WHEN OTHERS THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');
3107: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3108: FND_MSG_PUB.ADD;
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: END find_duplicate_party_sites;

Line 3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');

3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: WHEN OTHERS THEN
3197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');
3199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3200: FND_MSG_PUB.ADD;
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END find_duplicate_contacts;

Line 3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');

3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3272: WHEN OTHERS THEN
3273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');
3275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3276: FND_MSG_PUB.ADD;
3277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3278: END find_duplicate_contact_points;

Line 3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');

3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END call_api_dynamic;

Line 3868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_party_sites');

3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: ROLLBACK to get_matching_party_sites ;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_party_sites');
3869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END get_matching_party_sites;

Line 4090: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contacts');

4086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4087: WHEN OTHERS THEN
4088: ROLLBACK to get_matching_contacts ;
4089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4090: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contacts');
4091: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4092: FND_MSG_PUB.ADD;
4093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4094: END get_matching_contacts;

Line 4237: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contact_points');

4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: WHEN OTHERS THEN
4235: ROLLBACK to get_matching_contact_points ;
4236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4237: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contact_points');
4238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4239: FND_MSG_PUB.ADD;
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: END get_matching_contact_points;

Line 4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_score_details');

4461: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4462: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4463: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_score_details');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END get_score_details;