DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_51 dependencies on HZ_MATCH_RULE_51

Line 1: PACKAGE BODY HZ_MATCH_RULE_51 AS

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

Line 7: | HZ_MATCH_RULE_51

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

Line 1932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_parties');

1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: WHEN OTHERS THEN
1930: ROLLBACK to find_parties;
1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_parties');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END find_parties;

Line 2584: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_persons');

2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: WHEN OTHERS THEN
2582: ROLLBACK to find_persons;
2583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2584: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_persons');
2585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2586: FND_MSG_PUB.ADD;
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END find_persons;

Line 2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');

2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: WHEN OTHERS THEN
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');
2655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2656: FND_MSG_PUB.ADD;
2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2658: END find_party_details;

Line 2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');

2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: WHEN OTHERS THEN
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');
2743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2744: FND_MSG_PUB.ADD;
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2746: END find_duplicate_parties;

Line 2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');

2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2828: WHEN OTHERS THEN
2829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');
2831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2832: FND_MSG_PUB.ADD;
2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2834: END find_duplicate_party_sites;

Line 2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');

2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: WHEN OTHERS THEN
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');
2923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2924: FND_MSG_PUB.ADD;
2925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2926: END find_duplicate_contacts;

Line 2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contact_points');

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_51.find_duplicate_contact_points');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END find_duplicate_contact_points;

Line 3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');

3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: WHEN OTHERS THEN
3336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');
3338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3339: FND_MSG_PUB.ADD;
3340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3341: END call_api_dynamic;

Line 3564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_party_sites');

3560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3561: WHEN OTHERS THEN
3562: ROLLBACK to get_matching_party_sites ;
3563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_party_sites');
3565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3566: FND_MSG_PUB.ADD;
3567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3568: END get_matching_party_sites;

Line 3783: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contacts');

3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: WHEN OTHERS THEN
3781: ROLLBACK to get_matching_contacts ;
3782: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3783: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contacts');
3784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3785: FND_MSG_PUB.ADD;
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3787: END get_matching_contacts;

Line 3930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contact_points');

3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: WHEN OTHERS THEN
3928: ROLLBACK to get_matching_contact_points ;
3929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contact_points');
3931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3932: FND_MSG_PUB.ADD;
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END get_matching_contact_points;

Line 4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');

4147: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4153: FND_MSG_PUB.ADD;
4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4155: END get_score_details;