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_38 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 945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

941: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
942: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
944: FND_MSG_PUB.ADD;
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END;
947:
948:
949: /************************************************

Line 970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

966: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
967: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: END;
972:
973:
974: /************************************************

Line 990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

986: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
987: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END;
992:
993:
994: /************************************************

Line 1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1006: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END;
1012:
1013: PROCEDURE init_score_context (
1014: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1077: RAISE FND_API.G_EXC_ERROR;

1073: p_contact_list,
1074: p_contact_point_list) THEN
1075: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1076: FND_MSG_PUB.ADD;
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1080: 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);
1081: END IF;

Line 1295: RAISE FND_API.G_EXC_ERROR;

1291: IF lengthb(l_party_contains_str) > 4000 THEN
1292: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1293: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1294: FND_MSG_PUB.ADD;
1295: RAISE FND_API.G_EXC_ERROR;
1296: END IF;
1297: IF (p_match_str = ' AND ' OR p_party_max_score 1298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1299: 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 1374: RAISE FND_API.G_EXC_ERROR;

1370: IF lengthb(l_contains_str) > 4000 THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1372: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1373: FND_MSG_PUB.ADD;
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376: x_denorm_str := l_den_contains_str;
1377: RETURN l_contains_str;
1378: END;

Line 1421: RAISE FND_API.G_EXC_ERROR;

1417: IF lengthb(l_contains_str) > 4000 THEN
1418: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1419: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1420: FND_MSG_PUB.ADD;
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423: x_denorm_str := l_den_contains_str;
1424: RETURN l_contains_str;
1425: END;

Line 1466: RAISE FND_API.G_EXC_ERROR;

1462: IF lengthb(l_contains_str) > 4000 THEN
1463: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1464: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1465: FND_MSG_PUB.ADD;
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468: x_denorm_str := l_den_contains_str;
1469: RETURN l_contains_str;
1470: END;

Line 1693: RAISE FND_API.G_EXC_ERROR;

1689: when others then
1690: if (instrb(SQLERRM,'DRG-51030')>0) then
1691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1692: FND_MSG_PUB.ADD;
1693: RAISE FND_API.G_EXC_ERROR;
1694: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;

Line 1697: RAISE FND_API.G_EXC_ERROR;

1693: RAISE FND_API.G_EXC_ERROR;
1694: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;

Line 1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: end if;
1708: END;
1709:
1710: PROCEDURE open_party_site_cursor(

Line 1938: RAISE FND_API.G_EXC_ERROR;

1934: when others then
1935: if (instrb(SQLERRM,'DRG-51030')>0) then
1936: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1937: FND_MSG_PUB.ADD;
1938: RAISE FND_API.G_EXC_ERROR;
1939: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1941: FND_MSG_PUB.ADD;
1942: RAISE FND_API.G_EXC_ERROR;

Line 1942: RAISE FND_API.G_EXC_ERROR;

1938: RAISE FND_API.G_EXC_ERROR;
1939: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1941: FND_MSG_PUB.ADD;
1942: RAISE FND_API.G_EXC_ERROR;
1943: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_ERROR;

Line 1946: RAISE FND_API.G_EXC_ERROR;

1942: RAISE FND_API.G_EXC_ERROR;
1943: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_ERROR;
1947: else
1948: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1949: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1950: FND_MSG_PUB.ADD;

Line 1951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1947: else
1948: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1949: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1952: end if;
1953: END;
1954:
1955: PROCEDURE open_contact_cursor(

Line 2085: RAISE FND_API.G_EXC_ERROR;

2081: when others then
2082: if (instrb(SQLERRM,'DRG-51030')>0) then
2083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2084: FND_MSG_PUB.ADD;
2085: RAISE FND_API.G_EXC_ERROR;
2086: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2088: FND_MSG_PUB.ADD;
2089: RAISE FND_API.G_EXC_ERROR;

Line 2089: RAISE FND_API.G_EXC_ERROR;

2085: RAISE FND_API.G_EXC_ERROR;
2086: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2088: FND_MSG_PUB.ADD;
2089: RAISE FND_API.G_EXC_ERROR;
2090: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;

Line 2093: RAISE FND_API.G_EXC_ERROR;

2089: RAISE FND_API.G_EXC_ERROR;
2090: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: else
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2096: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2097: FND_MSG_PUB.ADD;

Line 2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2094: else
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2096: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2097: FND_MSG_PUB.ADD;
2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2099: end if;
2100: END;
2101:
2102: PROCEDURE open_contact_pt_cursor(

Line 2358: RAISE FND_API.G_EXC_ERROR;

2354: when others then
2355: if (instrb(SQLERRM,'DRG-51030')>0) then
2356: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2357: FND_MSG_PUB.ADD;
2358: RAISE FND_API.G_EXC_ERROR;
2359: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2361: FND_MSG_PUB.ADD;
2362: RAISE FND_API.G_EXC_ERROR;

Line 2362: RAISE FND_API.G_EXC_ERROR;

2358: RAISE FND_API.G_EXC_ERROR;
2359: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2361: FND_MSG_PUB.ADD;
2362: RAISE FND_API.G_EXC_ERROR;
2363: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2365: FND_MSG_PUB.ADD;
2366: RAISE FND_API.G_EXC_ERROR;

Line 2366: RAISE FND_API.G_EXC_ERROR;

2362: RAISE FND_API.G_EXC_ERROR;
2363: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2365: FND_MSG_PUB.ADD;
2366: RAISE FND_API.G_EXC_ERROR;
2367: else
2368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2370: FND_MSG_PUB.ADD;

Line 2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2367: else
2368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2370: FND_MSG_PUB.ADD;
2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2372: end if;
2373: END;
2374:
2375:

Line 2632: RAISE FND_API.G_EXC_ERROR;

2628: 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);
2629: END IF;
2630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2631: FND_MSG_PUB.ADD;
2632: RAISE FND_API.G_EXC_ERROR;
2633: ELSE
2634: push_eval;
2635: RETURN;
2636: END IF;

Line 2680: RAISE FND_API.G_EXC_ERROR;

2676: 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);
2677: END IF;
2678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2679: FND_MSG_PUB.ADD;
2680: RAISE FND_API.G_EXC_ERROR;
2681: ELSE
2682: push_eval;
2683: RETURN;
2684: END IF;

Line 2753: RAISE FND_API.G_EXC_ERROR;

2749: 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);
2750: END IF;
2751: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2752: FND_MSG_PUB.ADD;
2753: RAISE FND_API.G_EXC_ERROR;
2754: ELSE
2755: push_eval;
2756: RETURN;
2757: END IF;

Line 2865: RAISE FND_API.G_EXC_ERROR;

2861: 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);
2862: END IF;
2863: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2864: FND_MSG_PUB.ADD;
2865: RAISE FND_API.G_EXC_ERROR;
2866: ELSE
2867: push_eval;
2868: RETURN;
2869: END IF;

Line 2976: RAISE FND_API.G_EXC_ERROR;

2972: 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);
2973: END IF;
2974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2975: FND_MSG_PUB.ADD;
2976: RAISE FND_API.G_EXC_ERROR;
2977: ELSE
2978: push_eval;
2979: RETURN;
2980: END IF;

Line 3120: RAISE FND_API.G_EXC_ERROR;

3116: 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);
3117: END IF;
3118: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3119: FND_MSG_PUB.ADD;
3120: RAISE FND_API.G_EXC_ERROR;
3121: END IF;
3122: ELSE
3123: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3124: 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 3128: RAISE FND_API.G_EXC_ERROR;

3124: 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);
3125: END IF;
3126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3127: FND_MSG_PUB.ADD;
3128: RAISE FND_API.G_EXC_ERROR;
3129: END IF;
3130: END IF;
3131: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3132: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3370: WHEN FND_API.G_EXC_ERROR THEN

3366: END IF;
3367: EXCEPTION
3368: WHEN L_RETURN_IMM_EXC THEN
3369: RETURN;
3370: WHEN FND_API.G_EXC_ERROR THEN
3371: RAISE FND_API.G_EXC_ERROR;
3372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: WHEN OTHERS THEN

Line 3371: RAISE FND_API.G_EXC_ERROR;

3367: EXCEPTION
3368: WHEN L_RETURN_IMM_EXC THEN
3369: RETURN;
3370: WHEN FND_API.G_EXC_ERROR THEN
3371: RAISE FND_API.G_EXC_ERROR;
3372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: WHEN OTHERS THEN
3375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3368: WHEN L_RETURN_IMM_EXC THEN
3369: RETURN;
3370: WHEN FND_API.G_EXC_ERROR THEN
3371: RAISE FND_API.G_EXC_ERROR;
3372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: WHEN OTHERS THEN
3375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3376: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_parties');

Line 3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3369: RETURN;
3370: WHEN FND_API.G_EXC_ERROR THEN
3371: RAISE FND_API.G_EXC_ERROR;
3372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: WHEN OTHERS THEN
3375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3376: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_parties');
3377: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3376: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_parties');
3377: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3378: FND_MSG_PUB.ADD;
3379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3380: END find_parties;
3381:
3382: PROCEDURE find_persons (
3383: p_rule_id IN NUMBER,

Line 3580: RAISE FND_API.G_EXC_ERROR;

3576: 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);
3577: END IF;
3578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3579: FND_MSG_PUB.ADD;
3580: RAISE FND_API.G_EXC_ERROR;
3581: ELSE
3582: push_eval;
3583: RETURN;
3584: END IF;

Line 3628: RAISE FND_API.G_EXC_ERROR;

3624: 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);
3625: END IF;
3626: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3627: FND_MSG_PUB.ADD;
3628: RAISE FND_API.G_EXC_ERROR;
3629: ELSE
3630: push_eval;
3631: RETURN;
3632: END IF;

Line 3664: RAISE FND_API.G_EXC_ERROR;

3660: when others then
3661: if (instrb(SQLERRM,'DRG-51030')>0) then
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3663: FND_MSG_PUB.ADD;
3664: RAISE FND_API.G_EXC_ERROR;
3665: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3667: FND_MSG_PUB.ADD;
3668: RAISE FND_API.G_EXC_ERROR;

Line 3668: RAISE FND_API.G_EXC_ERROR;

3664: RAISE FND_API.G_EXC_ERROR;
3665: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3667: FND_MSG_PUB.ADD;
3668: RAISE FND_API.G_EXC_ERROR;
3669: else
3670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3671: end if;
3672: END;

Line 3670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3667: FND_MSG_PUB.ADD;
3668: RAISE FND_API.G_EXC_ERROR;
3669: else
3670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3671: end if;
3672: END;
3673:
3674: /** Private procedure to acquire and score at party site level ***/

Line 3740: RAISE FND_API.G_EXC_ERROR;

3736: 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);
3737: END IF;
3738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3739: FND_MSG_PUB.ADD;
3740: RAISE FND_API.G_EXC_ERROR;
3741: ELSE
3742: push_eval;
3743: RETURN;
3744: END IF;

Line 3929: RAISE FND_API.G_EXC_ERROR;

3925: 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);
3926: END IF;
3927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3928: FND_MSG_PUB.ADD;
3929: RAISE FND_API.G_EXC_ERROR;
3930: ELSE
3931: push_eval;
3932: RETURN;
3933: END IF;

Line 4017: RAISE FND_API.G_EXC_ERROR;

4013: 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);
4014: END IF;
4015: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4016: FND_MSG_PUB.ADD;
4017: RAISE FND_API.G_EXC_ERROR;
4018: END IF;
4019: ELSE
4020: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4021: 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 4025: RAISE FND_API.G_EXC_ERROR;

4021: 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);
4022: END IF;
4023: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4024: FND_MSG_PUB.ADD;
4025: RAISE FND_API.G_EXC_ERROR;
4026: END IF;
4027: END IF;
4028: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4029: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4165: WHEN FND_API.G_EXC_ERROR THEN

4161: END IF;
4162: EXCEPTION
4163: WHEN L_RETURN_IMM_EXC THEN
4164: RETURN;
4165: WHEN FND_API.G_EXC_ERROR THEN
4166: RAISE FND_API.G_EXC_ERROR;
4167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4169: WHEN OTHERS THEN

Line 4166: RAISE FND_API.G_EXC_ERROR;

4162: EXCEPTION
4163: WHEN L_RETURN_IMM_EXC THEN
4164: RETURN;
4165: WHEN FND_API.G_EXC_ERROR THEN
4166: RAISE FND_API.G_EXC_ERROR;
4167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4169: WHEN OTHERS THEN
4170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4163: WHEN L_RETURN_IMM_EXC THEN
4164: RETURN;
4165: WHEN FND_API.G_EXC_ERROR THEN
4166: RAISE FND_API.G_EXC_ERROR;
4167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4169: WHEN OTHERS THEN
4170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');

Line 4168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4164: RETURN;
4165: WHEN FND_API.G_EXC_ERROR THEN
4166: RAISE FND_API.G_EXC_ERROR;
4167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4169: WHEN OTHERS THEN
4170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4173: FND_MSG_PUB.ADD;
4174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4175: END find_persons;
4176:
4177: PROCEDURE find_persons (
4178: p_rule_id IN NUMBER,

Line 4233: WHEN FND_API.G_EXC_ERROR THEN

4229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4230: 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);
4231: END IF;
4232: EXCEPTION
4233: WHEN FND_API.G_EXC_ERROR THEN
4234: RAISE FND_API.G_EXC_ERROR;
4235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: WHEN OTHERS THEN

Line 4234: RAISE FND_API.G_EXC_ERROR;

4230: 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);
4231: END IF;
4232: EXCEPTION
4233: WHEN FND_API.G_EXC_ERROR THEN
4234: RAISE FND_API.G_EXC_ERROR;
4235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: WHEN OTHERS THEN
4238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4231: END IF;
4232: EXCEPTION
4233: WHEN FND_API.G_EXC_ERROR THEN
4234: RAISE FND_API.G_EXC_ERROR;
4235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: WHEN OTHERS THEN
4238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');

Line 4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4232: EXCEPTION
4233: WHEN FND_API.G_EXC_ERROR THEN
4234: RAISE FND_API.G_EXC_ERROR;
4235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: WHEN OTHERS THEN
4238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');
4240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');
4240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4241: FND_MSG_PUB.ADD;
4242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4243: END find_party_details;
4244:
4245: PROCEDURE find_duplicate_parties (
4246: p_rule_id IN NUMBER,

Line 4350: WHEN FND_API.G_EXC_ERROR THEN

4346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4347: 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);
4348: END IF;
4349: EXCEPTION
4350: WHEN FND_API.G_EXC_ERROR THEN
4351: RAISE FND_API.G_EXC_ERROR;
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4354: WHEN OTHERS THEN

Line 4351: RAISE FND_API.G_EXC_ERROR;

4347: 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);
4348: END IF;
4349: EXCEPTION
4350: WHEN FND_API.G_EXC_ERROR THEN
4351: RAISE FND_API.G_EXC_ERROR;
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4354: WHEN OTHERS THEN
4355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4348: END IF;
4349: EXCEPTION
4350: WHEN FND_API.G_EXC_ERROR THEN
4351: RAISE FND_API.G_EXC_ERROR;
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4354: WHEN OTHERS THEN
4355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4356: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');

Line 4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4349: EXCEPTION
4350: WHEN FND_API.G_EXC_ERROR THEN
4351: RAISE FND_API.G_EXC_ERROR;
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4354: WHEN OTHERS THEN
4355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4356: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4357: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4356: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4357: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4358: FND_MSG_PUB.ADD;
4359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4360: END find_duplicate_parties;
4361:
4362: PROCEDURE find_duplicate_party_sites (
4363: p_rule_id IN NUMBER,

Line 4435: WHEN FND_API.G_EXC_ERROR THEN

4431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4432: 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);
4433: END IF;
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_ERROR THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN

Line 4436: RAISE FND_API.G_EXC_ERROR;

4432: 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);
4433: END IF;
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_ERROR THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4433: END IF;
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_ERROR THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');

Line 4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4434: EXCEPTION
4435: WHEN FND_API.G_EXC_ERROR THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4443: FND_MSG_PUB.ADD;
4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4445: END find_duplicate_party_sites;
4446:
4447: PROCEDURE find_duplicate_contacts (
4448: p_rule_id IN NUMBER,

Line 4524: WHEN FND_API.G_EXC_ERROR THEN

4520: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4521: 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);
4522: END IF;
4523: EXCEPTION
4524: WHEN FND_API.G_EXC_ERROR THEN
4525: RAISE FND_API.G_EXC_ERROR;
4526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4528: WHEN OTHERS THEN

Line 4525: RAISE FND_API.G_EXC_ERROR;

4521: 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);
4522: END IF;
4523: EXCEPTION
4524: WHEN FND_API.G_EXC_ERROR THEN
4525: RAISE FND_API.G_EXC_ERROR;
4526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4528: WHEN OTHERS THEN
4529: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4522: END IF;
4523: EXCEPTION
4524: WHEN FND_API.G_EXC_ERROR THEN
4525: RAISE FND_API.G_EXC_ERROR;
4526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4528: WHEN OTHERS THEN
4529: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4530: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');

Line 4527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4523: EXCEPTION
4524: WHEN FND_API.G_EXC_ERROR THEN
4525: RAISE FND_API.G_EXC_ERROR;
4526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4528: WHEN OTHERS THEN
4529: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4530: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4529: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4530: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4532: FND_MSG_PUB.ADD;
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: END find_duplicate_contacts;
4535:
4536: PROCEDURE find_duplicate_contact_points (
4537: p_rule_id IN NUMBER,

Line 4597: WHEN FND_API.G_EXC_ERROR THEN

4593: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4594: 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);
4595: END IF;
4596: EXCEPTION
4597: WHEN FND_API.G_EXC_ERROR THEN
4598: RAISE FND_API.G_EXC_ERROR;
4599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: WHEN OTHERS THEN

Line 4598: RAISE FND_API.G_EXC_ERROR;

4594: 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);
4595: END IF;
4596: EXCEPTION
4597: WHEN FND_API.G_EXC_ERROR THEN
4598: RAISE FND_API.G_EXC_ERROR;
4599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: WHEN OTHERS THEN
4602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4595: END IF;
4596: EXCEPTION
4597: WHEN FND_API.G_EXC_ERROR THEN
4598: RAISE FND_API.G_EXC_ERROR;
4599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: WHEN OTHERS THEN
4602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4603: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');

Line 4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4596: EXCEPTION
4597: WHEN FND_API.G_EXC_ERROR THEN
4598: RAISE FND_API.G_EXC_ERROR;
4599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: WHEN OTHERS THEN
4602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4603: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4603: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4605: FND_MSG_PUB.ADD;
4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4607: END find_duplicate_contact_points;
4608:
4609: PROCEDURE find_parties_dynamic (
4610: p_rule_id IN NUMBER,

Line 4940: WHEN FND_API.G_EXC_ERROR THEN

4936: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4937: 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);
4938: END IF;
4939: EXCEPTION
4940: WHEN FND_API.G_EXC_ERROR THEN
4941: RAISE FND_API.G_EXC_ERROR;
4942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: WHEN OTHERS THEN

Line 4941: RAISE FND_API.G_EXC_ERROR;

4937: 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);
4938: END IF;
4939: EXCEPTION
4940: WHEN FND_API.G_EXC_ERROR THEN
4941: RAISE FND_API.G_EXC_ERROR;
4942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: WHEN OTHERS THEN
4945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4938: END IF;
4939: EXCEPTION
4940: WHEN FND_API.G_EXC_ERROR THEN
4941: RAISE FND_API.G_EXC_ERROR;
4942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: WHEN OTHERS THEN
4945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');

Line 4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4939: EXCEPTION
4940: WHEN FND_API.G_EXC_ERROR THEN
4941: RAISE FND_API.G_EXC_ERROR;
4942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: WHEN OTHERS THEN
4945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4948: FND_MSG_PUB.ADD;
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: END call_api_dynamic;
4951:
4952:
4953: PROCEDURE get_matching_party_sites (

Line 5187: WHEN FND_API.G_EXC_ERROR THEN

5183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5184: 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);
5185: END IF;
5186: EXCEPTION
5187: WHEN FND_API.G_EXC_ERROR THEN
5188: RAISE FND_API.G_EXC_ERROR;
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: WHEN OTHERS THEN

Line 5188: RAISE FND_API.G_EXC_ERROR;

5184: 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);
5185: END IF;
5186: EXCEPTION
5187: WHEN FND_API.G_EXC_ERROR THEN
5188: RAISE FND_API.G_EXC_ERROR;
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: WHEN OTHERS THEN
5192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5185: END IF;
5186: EXCEPTION
5187: WHEN FND_API.G_EXC_ERROR THEN
5188: RAISE FND_API.G_EXC_ERROR;
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: WHEN OTHERS THEN
5192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5193: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');

Line 5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5186: EXCEPTION
5187: WHEN FND_API.G_EXC_ERROR THEN
5188: RAISE FND_API.G_EXC_ERROR;
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: WHEN OTHERS THEN
5192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5193: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5193: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5195: FND_MSG_PUB.ADD;
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: END get_matching_party_sites;
5198:
5199:
5200: PROCEDURE get_matching_contacts (

Line 5416: WHEN FND_API.G_EXC_ERROR THEN

5412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5413: 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);
5414: END IF;
5415: EXCEPTION
5416: WHEN FND_API.G_EXC_ERROR THEN
5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN

Line 5417: RAISE FND_API.G_EXC_ERROR;

5413: 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);
5414: END IF;
5415: EXCEPTION
5416: WHEN FND_API.G_EXC_ERROR THEN
5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5414: END IF;
5415: EXCEPTION
5416: WHEN FND_API.G_EXC_ERROR THEN
5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');

Line 5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5415: EXCEPTION
5416: WHEN FND_API.G_EXC_ERROR THEN
5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5426: END get_matching_contacts;
5427:
5428:
5429: PROCEDURE get_matching_contact_points (

Line 5558: WHEN FND_API.G_EXC_ERROR THEN

5554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5555: 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);
5556: END IF;
5557: EXCEPTION
5558: WHEN FND_API.G_EXC_ERROR THEN
5559: RAISE FND_API.G_EXC_ERROR;
5560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5562: WHEN OTHERS THEN

Line 5559: RAISE FND_API.G_EXC_ERROR;

5555: 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);
5556: END IF;
5557: EXCEPTION
5558: WHEN FND_API.G_EXC_ERROR THEN
5559: RAISE FND_API.G_EXC_ERROR;
5560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5562: WHEN OTHERS THEN
5563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5556: END IF;
5557: EXCEPTION
5558: WHEN FND_API.G_EXC_ERROR THEN
5559: RAISE FND_API.G_EXC_ERROR;
5560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5562: WHEN OTHERS THEN
5563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');

Line 5561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5557: EXCEPTION
5558: WHEN FND_API.G_EXC_ERROR THEN
5559: RAISE FND_API.G_EXC_ERROR;
5560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5562: WHEN OTHERS THEN
5563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5566: FND_MSG_PUB.ADD;
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568: END get_matching_contact_points;
5569:
5570: /**********************************************************
5571: This procedure finds the score details for a specific party that

Line 5797: WHEN FND_API.G_EXC_ERROR THEN

5793: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5794: 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);
5795: END IF;
5796: EXCEPTION
5797: WHEN FND_API.G_EXC_ERROR THEN
5798: RAISE FND_API.G_EXC_ERROR;
5799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5801: WHEN OTHERS THEN

Line 5798: RAISE FND_API.G_EXC_ERROR;

5794: 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);
5795: END IF;
5796: EXCEPTION
5797: WHEN FND_API.G_EXC_ERROR THEN
5798: RAISE FND_API.G_EXC_ERROR;
5799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5795: END IF;
5796: EXCEPTION
5797: WHEN FND_API.G_EXC_ERROR THEN
5798: RAISE FND_API.G_EXC_ERROR;
5799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');

Line 5800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5796: EXCEPTION
5797: WHEN FND_API.G_EXC_ERROR THEN
5798: RAISE FND_API.G_EXC_ERROR;
5799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5807: END get_score_details;
5808:
5809:
5810: /************************************************

Line 5920: WHEN FND_API.G_EXC_ERROR THEN

5916: END LOOP;
5917: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5918: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5919: EXCEPTION
5920: WHEN FND_API.G_EXC_ERROR THEN
5921: RAISE FND_API.G_EXC_ERROR;
5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5924: WHEN OTHERS THEN

Line 5921: RAISE FND_API.G_EXC_ERROR;

5917: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5918: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5919: EXCEPTION
5920: WHEN FND_API.G_EXC_ERROR THEN
5921: RAISE FND_API.G_EXC_ERROR;
5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5924: WHEN OTHERS THEN
5925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5918: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5919: EXCEPTION
5920: WHEN FND_API.G_EXC_ERROR THEN
5921: RAISE FND_API.G_EXC_ERROR;
5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5924: WHEN OTHERS THEN
5925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5926: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5919: EXCEPTION
5920: WHEN FND_API.G_EXC_ERROR THEN
5921: RAISE FND_API.G_EXC_ERROR;
5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5924: WHEN OTHERS THEN
5925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5926: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5926: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: END get_party_for_search;
5931:
5932: PROCEDURE get_search_criteria (
5933: p_party_id IN NUMBER,

Line 5972: WHEN FND_API.G_EXC_ERROR THEN

5968: END IF;
5969: get_contact_point_rec(p_contact_pt_ids, x_contact_point_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_contact_point_rec(p_contact_pt_ids, x_contact_point_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 6026: RAISE FND_API.G_EXC_ERROR;

6022: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6024: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6025: FND_MSG_PUB.ADD;
6026: RAISE FND_API.G_EXC_ERROR;
6027: END get_party_rec;
6028:
6029: /************************************************
6030: This procedure retrieves the match rule party site attributes into

Line 6092: RAISE FND_API.G_EXC_ERROR;

6088: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6089: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_ERROR;
6093: END get_party_site_rec;
6094:
6095: /************************************************
6096: This procedure retrieves the match rule contact attributes into

Line 6150: RAISE FND_API.G_EXC_ERROR;

6146: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6147: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6149: FND_MSG_PUB.ADD;
6150: RAISE FND_API.G_EXC_ERROR;
6151: END get_contact_rec;
6152:
6153: /************************************************
6154: This procedure retrieves the match rule contact point attributes into

Line 6206: RAISE FND_API.G_EXC_ERROR;

6202: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6203: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6205: FND_MSG_PUB.ADD;
6206: RAISE FND_API.G_EXC_ERROR;
6207: END get_contact_point_rec;
6208:
6209: /************************************************
6210: This procedure maps a search record from the logical

Line 6302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6298: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6299: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6301: FND_MSG_PUB.ADD;
6302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6303: END;
6304:
6305:
6306: /************************************************

Line 6572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6571: FND_MSG_PUB.ADD;
6572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6573: END;
6574:
6575:
6576: /************************************************

Line 6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6628: FND_MSG_PUB.ADD;
6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6630: END;
6631:
6632:
6633: /************************************************

Line 6736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6732: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6733: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6735: FND_MSG_PUB.ADD;
6736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6737: END;
6738:
6739:
6740: /************************************************

Line 6760: RAISE FND_API.G_EXC_ERROR;

6756: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6757: ) THEN
6758: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6759: FND_MSG_PUB.ADD;
6760: RAISE FND_API.G_EXC_ERROR;
6761: END IF;
6762: END LOOP;
6763:
6764: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN

Line 6794: WHEN FND_API.G_EXC_ERROR THEN

6790: END IF;
6791: END LOOP;
6792: RETURN FALSE;
6793: EXCEPTION
6794: WHEN FND_API.G_EXC_ERROR THEN
6795: RAISE FND_API.G_EXC_ERROR;
6796: WHEN OTHERS THEN
6797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6798: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6795: RAISE FND_API.G_EXC_ERROR;

6791: END LOOP;
6792: RETURN FALSE;
6793: EXCEPTION
6794: WHEN FND_API.G_EXC_ERROR THEN
6795: RAISE FND_API.G_EXC_ERROR;
6796: WHEN OTHERS THEN
6797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6798: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6798: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6800: FND_MSG_PUB.ADD;
6801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6802: END check_prim_cond;
6803:
6804: /************************************************
6805: This procedure checks if the input search condition

Line 6862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6859: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6861: FND_MSG_PUB.ADD;
6862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6863: END check_party_site_cond;
6864:
6865: /************************************************
6866: This procedure checks if the input search condition

Line 6917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6914: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6916: FND_MSG_PUB.ADD;
6917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6918: END check_contact_cond;
6919:
6920: /************************************************
6921: This procedure checks if the input search condition

Line 6938: RAISE FND_API.G_EXC_ERROR;

6934: FOR I IN 1..p_contact_point_list.COUNT LOOP
6935: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6936: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6937: FND_MSG_PUB.ADD;
6938: RAISE FND_API.G_EXC_ERROR;
6939: END IF;
6940: END LOOP;
6941:
6942: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6960: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6962: FND_MSG_PUB.ADD;
6963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6964: END check_contact_point_cond;
6965:
6966: FUNCTION check_staged RETURN BOOLEAN IS
6967: