eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_53 dependencies on FND_API

Line 102: RAISE FND_API.G_EXC_ERROR;

98: when others then
99: if (instrb(SQLERRM,'DRG-51030')>0) then
100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;

Line 106: RAISE FND_API.G_EXC_ERROR;

102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;
110: END;

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;
110: END;
111:
112:

Line 878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

874: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
875: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
877: FND_MSG_PUB.ADD;
878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
879: END;
880:
881:
882: /************************************************

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

899: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
900: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
901: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END;
905:
906:
907: /************************************************

Line 923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

919: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
920: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END;
925:
926:
927: /************************************************

Line 943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
940: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END;
945:
946: PROCEDURE init_score_context (
947: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1010: RAISE FND_API.G_EXC_ERROR;

1006: p_contact_list,
1007: p_contact_point_list) THEN
1008: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1013: hz_utility_v2pub.debug(p_message=>'In init_search calling util package set_score',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1014: END IF;

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: IF lengthb(l_party_contains_str) > 4000 THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: IF (p_match_str = ' AND ' OR p_party_max_score 1305: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1306: hz_utility_v2pub.debug(p_message=>'party contains string returned by init_search is an AND between these strings ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1401: RAISE FND_API.G_EXC_ERROR;

1397: IF lengthb(l_contains_str) > 4000 THEN
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1399: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403: x_denorm_str := l_den_contains_str;
1404: RETURN l_contains_str;
1405: END;

Line 1708: RAISE FND_API.G_EXC_ERROR;

1704: when others then
1705: if (instrb(SQLERRM,'DRG-51030')>0) then
1706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1707: FND_MSG_PUB.ADD;
1708: RAISE FND_API.G_EXC_ERROR;
1709: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1711: FND_MSG_PUB.ADD;
1712: RAISE FND_API.G_EXC_ERROR;

Line 1712: RAISE FND_API.G_EXC_ERROR;

1708: RAISE FND_API.G_EXC_ERROR;
1709: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1711: FND_MSG_PUB.ADD;
1712: RAISE FND_API.G_EXC_ERROR;
1713: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;

Line 1716: RAISE FND_API.G_EXC_ERROR;

1712: RAISE FND_API.G_EXC_ERROR;
1713: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;
1717: else
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1720: FND_MSG_PUB.ADD;

Line 1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1717: else
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1720: FND_MSG_PUB.ADD;
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: end if;
1723: END;
1724:
1725: PROCEDURE open_party_site_cursor(

Line 1953: RAISE FND_API.G_EXC_ERROR;

1949: when others then
1950: if (instrb(SQLERRM,'DRG-51030')>0) then
1951: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1952: FND_MSG_PUB.ADD;
1953: RAISE FND_API.G_EXC_ERROR;
1954: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1956: FND_MSG_PUB.ADD;
1957: RAISE FND_API.G_EXC_ERROR;

Line 1957: RAISE FND_API.G_EXC_ERROR;

1953: RAISE FND_API.G_EXC_ERROR;
1954: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1956: FND_MSG_PUB.ADD;
1957: RAISE FND_API.G_EXC_ERROR;
1958: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;

Line 1961: RAISE FND_API.G_EXC_ERROR;

1957: RAISE FND_API.G_EXC_ERROR;
1958: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: else
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1965: FND_MSG_PUB.ADD;

Line 1966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1962: else
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1967: end if;
1968: END;
1969:
1970: PROCEDURE open_contact_cursor(

Line 2100: RAISE FND_API.G_EXC_ERROR;

2096: when others then
2097: if (instrb(SQLERRM,'DRG-51030')>0) then
2098: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2099: FND_MSG_PUB.ADD;
2100: RAISE FND_API.G_EXC_ERROR;
2101: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2103: FND_MSG_PUB.ADD;
2104: RAISE FND_API.G_EXC_ERROR;

Line 2104: RAISE FND_API.G_EXC_ERROR;

2100: RAISE FND_API.G_EXC_ERROR;
2101: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2103: FND_MSG_PUB.ADD;
2104: RAISE FND_API.G_EXC_ERROR;
2105: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2106: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2107: FND_MSG_PUB.ADD;
2108: RAISE FND_API.G_EXC_ERROR;

Line 2108: RAISE FND_API.G_EXC_ERROR;

2104: RAISE FND_API.G_EXC_ERROR;
2105: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2106: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2107: FND_MSG_PUB.ADD;
2108: RAISE FND_API.G_EXC_ERROR;
2109: else
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2112: FND_MSG_PUB.ADD;

Line 2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2109: else
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2112: FND_MSG_PUB.ADD;
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2114: end if;
2115: END;
2116:
2117: PROCEDURE open_contact_pt_cursor(

Line 2373: RAISE FND_API.G_EXC_ERROR;

2369: when others then
2370: if (instrb(SQLERRM,'DRG-51030')>0) then
2371: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2372: FND_MSG_PUB.ADD;
2373: RAISE FND_API.G_EXC_ERROR;
2374: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2376: FND_MSG_PUB.ADD;
2377: RAISE FND_API.G_EXC_ERROR;

Line 2377: RAISE FND_API.G_EXC_ERROR;

2373: RAISE FND_API.G_EXC_ERROR;
2374: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2376: FND_MSG_PUB.ADD;
2377: RAISE FND_API.G_EXC_ERROR;
2378: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2379: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_ERROR;

Line 2381: RAISE FND_API.G_EXC_ERROR;

2377: RAISE FND_API.G_EXC_ERROR;
2378: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2379: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_ERROR;
2382: else
2383: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2384: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2385: FND_MSG_PUB.ADD;

Line 2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2382: else
2383: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2384: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2385: FND_MSG_PUB.ADD;
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: end if;
2388: END;
2389:
2390:

Line 2645: RAISE FND_API.G_EXC_ERROR;

2641: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2642: END IF;
2643: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2644: FND_MSG_PUB.ADD;
2645: RAISE FND_API.G_EXC_ERROR;
2646: ELSE
2647: push_eval;
2648: RETURN;
2649: END IF;

Line 2695: RAISE FND_API.G_EXC_ERROR;

2691: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2692: END IF;
2693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2694: FND_MSG_PUB.ADD;
2695: RAISE FND_API.G_EXC_ERROR;
2696: ELSE
2697: push_eval;
2698: RETURN;
2699: END IF;

Line 2768: RAISE FND_API.G_EXC_ERROR;

2764: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2765: END IF;
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2767: FND_MSG_PUB.ADD;
2768: RAISE FND_API.G_EXC_ERROR;
2769: ELSE
2770: push_eval;
2771: RETURN;
2772: END IF;

Line 2880: RAISE FND_API.G_EXC_ERROR;

2876: hz_utility_v2pub.debug(p_message=>'In eval contact level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2877: END IF;
2878: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2879: FND_MSG_PUB.ADD;
2880: RAISE FND_API.G_EXC_ERROR;
2881: ELSE
2882: push_eval;
2883: RETURN;
2884: END IF;

Line 2991: RAISE FND_API.G_EXC_ERROR;

2987: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2988: END IF;
2989: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2990: FND_MSG_PUB.ADD;
2991: RAISE FND_API.G_EXC_ERROR;
2992: ELSE
2993: push_eval;
2994: RETURN;
2995: END IF;

Line 3216: RAISE FND_API.G_EXC_ERROR;

3212: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3213: END IF;
3214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3215: FND_MSG_PUB.ADD;
3216: RAISE FND_API.G_EXC_ERROR;
3217: END IF;
3218: ELSE
3219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3220: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 3224: RAISE FND_API.G_EXC_ERROR;

3220: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3221: END IF;
3222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3223: FND_MSG_PUB.ADD;
3224: RAISE FND_API.G_EXC_ERROR;
3225: END IF;
3226: END IF;
3227: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3228: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3423: WHEN FND_API.G_EXC_ERROR THEN

3419: END IF;
3420: EXCEPTION
3421: WHEN L_RETURN_IMM_EXC THEN
3422: RETURN;
3423: WHEN FND_API.G_EXC_ERROR THEN
3424: RAISE FND_API.G_EXC_ERROR;
3425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: WHEN OTHERS THEN

Line 3424: RAISE FND_API.G_EXC_ERROR;

3420: EXCEPTION
3421: WHEN L_RETURN_IMM_EXC THEN
3422: RETURN;
3423: WHEN FND_API.G_EXC_ERROR THEN
3424: RAISE FND_API.G_EXC_ERROR;
3425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: WHEN OTHERS THEN
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3421: WHEN L_RETURN_IMM_EXC THEN
3422: RETURN;
3423: WHEN FND_API.G_EXC_ERROR THEN
3424: RAISE FND_API.G_EXC_ERROR;
3425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: WHEN OTHERS THEN
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3429: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');

Line 3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3422: RETURN;
3423: WHEN FND_API.G_EXC_ERROR THEN
3424: RAISE FND_API.G_EXC_ERROR;
3425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: WHEN OTHERS THEN
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3429: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');
3430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3429: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');
3430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3431: FND_MSG_PUB.ADD;
3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3433: END find_parties;
3434:
3435: PROCEDURE find_persons (
3436: p_rule_id IN NUMBER,

Line 3631: RAISE FND_API.G_EXC_ERROR;

3627: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3628: END IF;
3629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3630: FND_MSG_PUB.ADD;
3631: RAISE FND_API.G_EXC_ERROR;
3632: ELSE
3633: push_eval;
3634: RETURN;
3635: END IF;

Line 3681: RAISE FND_API.G_EXC_ERROR;

3677: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3678: END IF;
3679: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_ERROR;
3682: ELSE
3683: push_eval;
3684: RETURN;
3685: END IF;

Line 3717: RAISE FND_API.G_EXC_ERROR;

3713: when others then
3714: if (instrb(SQLERRM,'DRG-51030')>0) then
3715: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3716: FND_MSG_PUB.ADD;
3717: RAISE FND_API.G_EXC_ERROR;
3718: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3720: FND_MSG_PUB.ADD;
3721: RAISE FND_API.G_EXC_ERROR;

Line 3721: RAISE FND_API.G_EXC_ERROR;

3717: RAISE FND_API.G_EXC_ERROR;
3718: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3720: FND_MSG_PUB.ADD;
3721: RAISE FND_API.G_EXC_ERROR;
3722: else
3723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3724: end if;
3725: END;

Line 3723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3720: FND_MSG_PUB.ADD;
3721: RAISE FND_API.G_EXC_ERROR;
3722: else
3723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3724: end if;
3725: END;
3726:
3727: /** Private procedure to acquire and score at party site level ***/

Line 3793: RAISE FND_API.G_EXC_ERROR;

3789: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3790: END IF;
3791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3792: FND_MSG_PUB.ADD;
3793: RAISE FND_API.G_EXC_ERROR;
3794: ELSE
3795: push_eval;
3796: RETURN;
3797: END IF;

Line 4052: RAISE FND_API.G_EXC_ERROR;

4048: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4049: END IF;
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4051: FND_MSG_PUB.ADD;
4052: RAISE FND_API.G_EXC_ERROR;
4053: ELSE
4054: push_eval;
4055: RETURN;
4056: END IF;

Line 4165: RAISE FND_API.G_EXC_ERROR;

4161: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4162: END IF;
4163: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4164: FND_MSG_PUB.ADD;
4165: RAISE FND_API.G_EXC_ERROR;
4166: END IF;
4167: ELSE
4168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4169: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4173: RAISE FND_API.G_EXC_ERROR;

4169: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4170: END IF;
4171: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4172: FND_MSG_PUB.ADD;
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;
4175: END IF;
4176: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4177: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4287: WHEN FND_API.G_EXC_ERROR THEN

4283: END IF;
4284: EXCEPTION
4285: WHEN L_RETURN_IMM_EXC THEN
4286: RETURN;
4287: WHEN FND_API.G_EXC_ERROR THEN
4288: RAISE FND_API.G_EXC_ERROR;
4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: WHEN OTHERS THEN

Line 4288: RAISE FND_API.G_EXC_ERROR;

4284: EXCEPTION
4285: WHEN L_RETURN_IMM_EXC THEN
4286: RETURN;
4287: WHEN FND_API.G_EXC_ERROR THEN
4288: RAISE FND_API.G_EXC_ERROR;
4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: WHEN OTHERS THEN
4292: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4285: WHEN L_RETURN_IMM_EXC THEN
4286: RETURN;
4287: WHEN FND_API.G_EXC_ERROR THEN
4288: RAISE FND_API.G_EXC_ERROR;
4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: WHEN OTHERS THEN
4292: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4293: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');

Line 4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4286: RETURN;
4287: WHEN FND_API.G_EXC_ERROR THEN
4288: RAISE FND_API.G_EXC_ERROR;
4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: WHEN OTHERS THEN
4292: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4293: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');
4294: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4292: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4293: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');
4294: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4295: FND_MSG_PUB.ADD;
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: END find_persons;
4298:
4299: PROCEDURE find_persons (
4300: p_rule_id IN NUMBER,

Line 4355: WHEN FND_API.G_EXC_ERROR THEN

4351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4352: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4353: END IF;
4354: EXCEPTION
4355: WHEN FND_API.G_EXC_ERROR THEN
4356: RAISE FND_API.G_EXC_ERROR;
4357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4359: WHEN OTHERS THEN

Line 4356: RAISE FND_API.G_EXC_ERROR;

4352: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4353: END IF;
4354: EXCEPTION
4355: WHEN FND_API.G_EXC_ERROR THEN
4356: RAISE FND_API.G_EXC_ERROR;
4357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4359: WHEN OTHERS THEN
4360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4353: END IF;
4354: EXCEPTION
4355: WHEN FND_API.G_EXC_ERROR THEN
4356: RAISE FND_API.G_EXC_ERROR;
4357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4359: WHEN OTHERS THEN
4360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');

Line 4358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4354: EXCEPTION
4355: WHEN FND_API.G_EXC_ERROR THEN
4356: RAISE FND_API.G_EXC_ERROR;
4357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4359: WHEN OTHERS THEN
4360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');
4362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');
4362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4363: FND_MSG_PUB.ADD;
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: END find_party_details;
4366:
4367: PROCEDURE find_duplicate_parties (
4368: p_rule_id IN NUMBER,

Line 4472: WHEN FND_API.G_EXC_ERROR THEN

4468: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4469: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4470: END IF;
4471: EXCEPTION
4472: WHEN FND_API.G_EXC_ERROR THEN
4473: RAISE FND_API.G_EXC_ERROR;
4474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4476: WHEN OTHERS THEN

Line 4473: RAISE FND_API.G_EXC_ERROR;

4469: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4470: END IF;
4471: EXCEPTION
4472: WHEN FND_API.G_EXC_ERROR THEN
4473: RAISE FND_API.G_EXC_ERROR;
4474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4476: WHEN OTHERS THEN
4477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4470: END IF;
4471: EXCEPTION
4472: WHEN FND_API.G_EXC_ERROR THEN
4473: RAISE FND_API.G_EXC_ERROR;
4474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4476: WHEN OTHERS THEN
4477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4478: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');

Line 4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4471: EXCEPTION
4472: WHEN FND_API.G_EXC_ERROR THEN
4473: RAISE FND_API.G_EXC_ERROR;
4474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4476: WHEN OTHERS THEN
4477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4478: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');
4479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4478: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');
4479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4480: FND_MSG_PUB.ADD;
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: END find_duplicate_parties;
4483:
4484: PROCEDURE find_duplicate_party_sites (
4485: p_rule_id IN NUMBER,

Line 4557: WHEN FND_API.G_EXC_ERROR THEN

4553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4554: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4555: END IF;
4556: EXCEPTION
4557: WHEN FND_API.G_EXC_ERROR THEN
4558: RAISE FND_API.G_EXC_ERROR;
4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: WHEN OTHERS THEN

Line 4558: RAISE FND_API.G_EXC_ERROR;

4554: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4555: END IF;
4556: EXCEPTION
4557: WHEN FND_API.G_EXC_ERROR THEN
4558: RAISE FND_API.G_EXC_ERROR;
4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: WHEN OTHERS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4555: END IF;
4556: EXCEPTION
4557: WHEN FND_API.G_EXC_ERROR THEN
4558: RAISE FND_API.G_EXC_ERROR;
4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: WHEN OTHERS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');

Line 4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4556: EXCEPTION
4557: WHEN FND_API.G_EXC_ERROR THEN
4558: RAISE FND_API.G_EXC_ERROR;
4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: WHEN OTHERS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: END find_duplicate_party_sites;
4568:
4569: PROCEDURE find_duplicate_contacts (
4570: p_rule_id IN NUMBER,

Line 4646: WHEN FND_API.G_EXC_ERROR THEN

4642: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4643: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4644: END IF;
4645: EXCEPTION
4646: WHEN FND_API.G_EXC_ERROR THEN
4647: RAISE FND_API.G_EXC_ERROR;
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: WHEN OTHERS THEN

Line 4647: RAISE FND_API.G_EXC_ERROR;

4643: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4644: END IF;
4645: EXCEPTION
4646: WHEN FND_API.G_EXC_ERROR THEN
4647: RAISE FND_API.G_EXC_ERROR;
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: WHEN OTHERS THEN
4651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4644: END IF;
4645: EXCEPTION
4646: WHEN FND_API.G_EXC_ERROR THEN
4647: RAISE FND_API.G_EXC_ERROR;
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: WHEN OTHERS THEN
4651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4652: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');

Line 4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4645: EXCEPTION
4646: WHEN FND_API.G_EXC_ERROR THEN
4647: RAISE FND_API.G_EXC_ERROR;
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: WHEN OTHERS THEN
4651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4652: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');
4653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4652: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');
4653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4654: FND_MSG_PUB.ADD;
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: END find_duplicate_contacts;
4657:
4658: PROCEDURE find_duplicate_contact_points (
4659: p_rule_id IN NUMBER,

Line 4719: WHEN FND_API.G_EXC_ERROR THEN

4715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4716: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4717: END IF;
4718: EXCEPTION
4719: WHEN FND_API.G_EXC_ERROR THEN
4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN

Line 4720: RAISE FND_API.G_EXC_ERROR;

4716: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4717: END IF;
4718: EXCEPTION
4719: WHEN FND_API.G_EXC_ERROR THEN
4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4717: END IF;
4718: EXCEPTION
4719: WHEN FND_API.G_EXC_ERROR THEN
4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');

Line 4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4718: EXCEPTION
4719: WHEN FND_API.G_EXC_ERROR THEN
4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: END find_duplicate_contact_points;
4730:
4731: PROCEDURE find_parties_dynamic (
4732: p_rule_id IN NUMBER,

Line 5021: WHEN FND_API.G_EXC_ERROR THEN

5017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5018: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5019: END IF;
5020: EXCEPTION
5021: WHEN FND_API.G_EXC_ERROR THEN
5022: RAISE FND_API.G_EXC_ERROR;
5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: WHEN OTHERS THEN

Line 5022: RAISE FND_API.G_EXC_ERROR;

5018: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5019: END IF;
5020: EXCEPTION
5021: WHEN FND_API.G_EXC_ERROR THEN
5022: RAISE FND_API.G_EXC_ERROR;
5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: WHEN OTHERS THEN
5026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5019: END IF;
5020: EXCEPTION
5021: WHEN FND_API.G_EXC_ERROR THEN
5022: RAISE FND_API.G_EXC_ERROR;
5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: WHEN OTHERS THEN
5026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5027: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');

Line 5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5020: EXCEPTION
5021: WHEN FND_API.G_EXC_ERROR THEN
5022: RAISE FND_API.G_EXC_ERROR;
5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: WHEN OTHERS THEN
5026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5027: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5027: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5029: FND_MSG_PUB.ADD;
5030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5031: END call_api_dynamic;
5032:
5033:
5034: PROCEDURE get_matching_party_sites (

Line 5261: WHEN FND_API.G_EXC_ERROR THEN

5257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5258: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5259: END IF;
5260: EXCEPTION
5261: WHEN FND_API.G_EXC_ERROR THEN
5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN

Line 5262: RAISE FND_API.G_EXC_ERROR;

5258: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5259: END IF;
5260: EXCEPTION
5261: WHEN FND_API.G_EXC_ERROR THEN
5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5259: END IF;
5260: EXCEPTION
5261: WHEN FND_API.G_EXC_ERROR THEN
5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');

Line 5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5260: EXCEPTION
5261: WHEN FND_API.G_EXC_ERROR THEN
5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_party_sites;
5272:
5273:
5274: PROCEDURE get_matching_contacts (

Line 5486: WHEN FND_API.G_EXC_ERROR THEN

5482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5483: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5484: END IF;
5485: EXCEPTION
5486: WHEN FND_API.G_EXC_ERROR THEN
5487: RAISE FND_API.G_EXC_ERROR;
5488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5490: WHEN OTHERS THEN

Line 5487: RAISE FND_API.G_EXC_ERROR;

5483: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5484: END IF;
5485: EXCEPTION
5486: WHEN FND_API.G_EXC_ERROR THEN
5487: RAISE FND_API.G_EXC_ERROR;
5488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5490: WHEN OTHERS THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5484: END IF;
5485: EXCEPTION
5486: WHEN FND_API.G_EXC_ERROR THEN
5487: RAISE FND_API.G_EXC_ERROR;
5488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5490: WHEN OTHERS THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5492: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');

Line 5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5485: EXCEPTION
5486: WHEN FND_API.G_EXC_ERROR THEN
5487: RAISE FND_API.G_EXC_ERROR;
5488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5490: WHEN OTHERS THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5492: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5493: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5492: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5493: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5494: FND_MSG_PUB.ADD;
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: END get_matching_contacts;
5497:
5498:
5499: PROCEDURE get_matching_contact_points (

Line 5625: WHEN FND_API.G_EXC_ERROR THEN

5621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5622: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5623: END IF;
5624: EXCEPTION
5625: WHEN FND_API.G_EXC_ERROR THEN
5626: RAISE FND_API.G_EXC_ERROR;
5627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5629: WHEN OTHERS THEN

Line 5626: RAISE FND_API.G_EXC_ERROR;

5622: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5623: END IF;
5624: EXCEPTION
5625: WHEN FND_API.G_EXC_ERROR THEN
5626: RAISE FND_API.G_EXC_ERROR;
5627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5623: END IF;
5624: EXCEPTION
5625: WHEN FND_API.G_EXC_ERROR THEN
5626: RAISE FND_API.G_EXC_ERROR;
5627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');

Line 5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5624: EXCEPTION
5625: WHEN FND_API.G_EXC_ERROR THEN
5626: RAISE FND_API.G_EXC_ERROR;
5627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5633: FND_MSG_PUB.ADD;
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: END get_matching_contact_points;
5636:
5637: /**********************************************************
5638: This procedure finds the score details for a specific party that

Line 5854: WHEN FND_API.G_EXC_ERROR THEN

5850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5851: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5852: END IF;
5853: EXCEPTION
5854: WHEN FND_API.G_EXC_ERROR THEN
5855: RAISE FND_API.G_EXC_ERROR;
5856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5858: WHEN OTHERS THEN

Line 5855: RAISE FND_API.G_EXC_ERROR;

5851: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5852: END IF;
5853: EXCEPTION
5854: WHEN FND_API.G_EXC_ERROR THEN
5855: RAISE FND_API.G_EXC_ERROR;
5856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5858: WHEN OTHERS THEN
5859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5852: END IF;
5853: EXCEPTION
5854: WHEN FND_API.G_EXC_ERROR THEN
5855: RAISE FND_API.G_EXC_ERROR;
5856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5858: WHEN OTHERS THEN
5859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');

Line 5857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5853: EXCEPTION
5854: WHEN FND_API.G_EXC_ERROR THEN
5855: RAISE FND_API.G_EXC_ERROR;
5856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5858: WHEN OTHERS THEN
5859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5862: FND_MSG_PUB.ADD;
5863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5864: END get_score_details;
5865:
5866:
5867: /************************************************

Line 5932: WHEN FND_API.G_EXC_ERROR THEN

5928: END LOOP;
5929: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5930: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5931: EXCEPTION
5932: WHEN FND_API.G_EXC_ERROR THEN
5933: RAISE FND_API.G_EXC_ERROR;
5934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: WHEN OTHERS THEN

Line 5933: RAISE FND_API.G_EXC_ERROR;

5929: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5930: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5931: EXCEPTION
5932: WHEN FND_API.G_EXC_ERROR THEN
5933: RAISE FND_API.G_EXC_ERROR;
5934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5930: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5931: EXCEPTION
5932: WHEN FND_API.G_EXC_ERROR THEN
5933: RAISE FND_API.G_EXC_ERROR;
5934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5931: EXCEPTION
5932: WHEN FND_API.G_EXC_ERROR THEN
5933: RAISE FND_API.G_EXC_ERROR;
5934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: END get_party_for_search;
5943:
5944: PROCEDURE get_search_criteria (
5945: p_party_id IN NUMBER,

Line 5972: WHEN FND_API.G_EXC_ERROR THEN

5968: END IF;
5969: get_party_site_rec(p_party_site_ids, x_party_site_list);
5970: END IF;
5971: EXCEPTION
5972: WHEN FND_API.G_EXC_ERROR THEN
5973: RAISE FND_API.G_EXC_ERROR;
5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN

Line 5973: RAISE FND_API.G_EXC_ERROR;

5969: get_party_site_rec(p_party_site_ids, x_party_site_list);
5970: END IF;
5971: EXCEPTION
5972: WHEN FND_API.G_EXC_ERROR THEN
5973: RAISE FND_API.G_EXC_ERROR;
5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5970: END IF;
5971: EXCEPTION
5972: WHEN FND_API.G_EXC_ERROR THEN
5973: RAISE FND_API.G_EXC_ERROR;
5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5971: EXCEPTION
5972: WHEN FND_API.G_EXC_ERROR THEN
5973: RAISE FND_API.G_EXC_ERROR;
5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5980: FND_MSG_PUB.ADD;
5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5982: END get_search_criteria;
5983:
5984:
5985: /************************************************

Line 6046: RAISE FND_API.G_EXC_ERROR;

6042: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END get_party_rec;
6048:
6049: /************************************************
6050: This procedure retrieves the match rule party site attributes into

Line 6108: RAISE FND_API.G_EXC_ERROR;

6104: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6105: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6107: FND_MSG_PUB.ADD;
6108: RAISE FND_API.G_EXC_ERROR;
6109: END get_party_site_rec;
6110:
6111: /************************************************
6112: This procedure retrieves the match rule contact attributes into

Line 6164: RAISE FND_API.G_EXC_ERROR;

6160: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6161: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6162: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6163: FND_MSG_PUB.ADD;
6164: RAISE FND_API.G_EXC_ERROR;
6165: END get_contact_rec;
6166:
6167: /************************************************
6168: This procedure retrieves the match rule contact point attributes into

Line 6216: RAISE FND_API.G_EXC_ERROR;

6212: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6213: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6214: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6215: FND_MSG_PUB.ADD;
6216: RAISE FND_API.G_EXC_ERROR;
6217: END get_contact_point_rec;
6218:
6219: /************************************************
6220: This procedure maps a search record from the logical

Line 6430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6426: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6427: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6429: FND_MSG_PUB.ADD;
6430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6431: END;
6432:
6433:
6434: /************************************************

Line 6642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6641: FND_MSG_PUB.ADD;
6642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6643: END;
6644:
6645:
6646: /************************************************

Line 6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6685: END;
6686:
6687:
6688: /************************************************

Line 6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6747: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6748: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6750: FND_MSG_PUB.ADD;
6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6752: END;
6753:
6754:
6755: /************************************************

Line 6811: WHEN FND_API.G_EXC_ERROR THEN

6807: END IF;
6808: END LOOP;
6809: RETURN FALSE;
6810: EXCEPTION
6811: WHEN FND_API.G_EXC_ERROR THEN
6812: RAISE FND_API.G_EXC_ERROR;
6813: WHEN OTHERS THEN
6814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6815: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6812: RAISE FND_API.G_EXC_ERROR;

6808: END LOOP;
6809: RETURN FALSE;
6810: EXCEPTION
6811: WHEN FND_API.G_EXC_ERROR THEN
6812: RAISE FND_API.G_EXC_ERROR;
6813: WHEN OTHERS THEN
6814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6815: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6815: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6817: FND_MSG_PUB.ADD;
6818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6819: END check_prim_cond;
6820:
6821: /************************************************
6822: This procedure checks if the input search condition

Line 6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6867: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6869: FND_MSG_PUB.ADD;
6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6871: END check_party_site_cond;
6872:
6873: /************************************************
6874: This procedure checks if the input search condition

Line 6908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6904: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6905: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6907: FND_MSG_PUB.ADD;
6908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6909: END check_contact_cond;
6910:
6911: /************************************************
6912: This procedure checks if the input search condition

Line 6929: RAISE FND_API.G_EXC_ERROR;

6925: FOR I IN 1..p_contact_point_list.COUNT LOOP
6926: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6927: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6928: FND_MSG_PUB.ADD;
6929: RAISE FND_API.G_EXC_ERROR;
6930: END IF;
6931: END LOOP;
6932:
6933: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6942: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6944: FND_MSG_PUB.ADD;
6945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6946: END check_contact_point_cond;
6947:
6948: FUNCTION check_staged RETURN BOOLEAN IS
6949: