DBA Data[Home] [Help]

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 1691: RAISE FND_API.G_EXC_ERROR;

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

Line 1695: RAISE FND_API.G_EXC_ERROR;

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

Line 1699: RAISE FND_API.G_EXC_ERROR;

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

Line 1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1936: RAISE FND_API.G_EXC_ERROR;

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

Line 1940: RAISE FND_API.G_EXC_ERROR;

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

Line 1944: RAISE FND_API.G_EXC_ERROR;

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

Line 1949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2083: RAISE FND_API.G_EXC_ERROR;

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

Line 2087: RAISE FND_API.G_EXC_ERROR;

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

Line 2091: RAISE FND_API.G_EXC_ERROR;

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

Line 2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2356: RAISE FND_API.G_EXC_ERROR;

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

Line 2360: RAISE FND_API.G_EXC_ERROR;

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

Line 2364: RAISE FND_API.G_EXC_ERROR;

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

Line 2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2629: RAISE FND_API.G_EXC_ERROR;

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

Line 2677: RAISE FND_API.G_EXC_ERROR;

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

Line 2750: RAISE FND_API.G_EXC_ERROR;

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

Line 2862: RAISE FND_API.G_EXC_ERROR;

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

Line 2973: RAISE FND_API.G_EXC_ERROR;

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

Line 3117: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3367: WHEN FND_API.G_EXC_ERROR THEN

3363: END IF;
3364: EXCEPTION
3365: WHEN L_RETURN_IMM_EXC THEN
3366: RETURN;
3367: WHEN FND_API.G_EXC_ERROR THEN
3368: RAISE FND_API.G_EXC_ERROR;
3369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3371: WHEN OTHERS THEN

Line 3368: RAISE FND_API.G_EXC_ERROR;

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

Line 3369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3576: RAISE FND_API.G_EXC_ERROR;

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

Line 3624: RAISE FND_API.G_EXC_ERROR;

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

Line 3660: RAISE FND_API.G_EXC_ERROR;

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

Line 3664: RAISE FND_API.G_EXC_ERROR;

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

Line 3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3736: RAISE FND_API.G_EXC_ERROR;

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

Line 3925: RAISE FND_API.G_EXC_ERROR;

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

Line 4013: RAISE FND_API.G_EXC_ERROR;

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

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

Line 4161: WHEN FND_API.G_EXC_ERROR THEN

4157: END IF;
4158: EXCEPTION
4159: WHEN L_RETURN_IMM_EXC THEN
4160: RETURN;
4161: WHEN FND_API.G_EXC_ERROR THEN
4162: RAISE FND_API.G_EXC_ERROR;
4163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: WHEN OTHERS THEN

Line 4162: RAISE FND_API.G_EXC_ERROR;

4158: EXCEPTION
4159: WHEN L_RETURN_IMM_EXC THEN
4160: RETURN;
4161: WHEN FND_API.G_EXC_ERROR THEN
4162: RAISE FND_API.G_EXC_ERROR;
4163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: WHEN OTHERS THEN
4166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4159: WHEN L_RETURN_IMM_EXC THEN
4160: RETURN;
4161: WHEN FND_API.G_EXC_ERROR THEN
4162: RAISE FND_API.G_EXC_ERROR;
4163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: WHEN OTHERS THEN
4166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');

Line 4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4160: RETURN;
4161: WHEN FND_API.G_EXC_ERROR THEN
4162: RAISE FND_API.G_EXC_ERROR;
4163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: WHEN OTHERS THEN
4166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4229: WHEN FND_API.G_EXC_ERROR THEN

4225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4226: 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);
4227: END IF;
4228: EXCEPTION
4229: WHEN FND_API.G_EXC_ERROR THEN
4230: RAISE FND_API.G_EXC_ERROR;
4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4233: WHEN OTHERS THEN

Line 4230: RAISE FND_API.G_EXC_ERROR;

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

Line 4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4227: END IF;
4228: EXCEPTION
4229: WHEN FND_API.G_EXC_ERROR THEN
4230: RAISE FND_API.G_EXC_ERROR;
4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4233: WHEN OTHERS THEN
4234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');

Line 4232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4228: EXCEPTION
4229: WHEN FND_API.G_EXC_ERROR THEN
4230: RAISE FND_API.G_EXC_ERROR;
4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4233: WHEN OTHERS THEN
4234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');
4236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4346: WHEN FND_API.G_EXC_ERROR THEN

4342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4343: 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);
4344: END IF;
4345: EXCEPTION
4346: WHEN FND_API.G_EXC_ERROR THEN
4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN

Line 4347: RAISE FND_API.G_EXC_ERROR;

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

Line 4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4344: END IF;
4345: EXCEPTION
4346: WHEN FND_API.G_EXC_ERROR THEN
4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');

Line 4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4345: EXCEPTION
4346: WHEN FND_API.G_EXC_ERROR THEN
4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4431: WHEN FND_API.G_EXC_ERROR THEN

4427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4428: 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);
4429: END IF;
4430: EXCEPTION
4431: WHEN FND_API.G_EXC_ERROR THEN
4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN

Line 4432: RAISE FND_API.G_EXC_ERROR;

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

Line 4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4429: END IF;
4430: EXCEPTION
4431: WHEN FND_API.G_EXC_ERROR THEN
4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');

Line 4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4430: EXCEPTION
4431: WHEN FND_API.G_EXC_ERROR THEN
4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4520: WHEN FND_API.G_EXC_ERROR THEN

4516: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4517: 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);
4518: END IF;
4519: EXCEPTION
4520: WHEN FND_API.G_EXC_ERROR THEN
4521: RAISE FND_API.G_EXC_ERROR;
4522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4524: WHEN OTHERS THEN

Line 4521: RAISE FND_API.G_EXC_ERROR;

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

Line 4522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4518: END IF;
4519: EXCEPTION
4520: WHEN FND_API.G_EXC_ERROR THEN
4521: RAISE FND_API.G_EXC_ERROR;
4522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4524: WHEN OTHERS THEN
4525: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4526: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');

Line 4523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4519: EXCEPTION
4520: WHEN FND_API.G_EXC_ERROR THEN
4521: RAISE FND_API.G_EXC_ERROR;
4522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4524: WHEN OTHERS THEN
4525: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4526: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4593: WHEN FND_API.G_EXC_ERROR THEN

4589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4590: 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);
4591: END IF;
4592: EXCEPTION
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: RAISE FND_API.G_EXC_ERROR;
4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN

Line 4594: RAISE FND_API.G_EXC_ERROR;

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

Line 4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4591: END IF;
4592: EXCEPTION
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: RAISE FND_API.G_EXC_ERROR;
4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');

Line 4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4592: EXCEPTION
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: RAISE FND_API.G_EXC_ERROR;
4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4936: WHEN FND_API.G_EXC_ERROR THEN

4932: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4933: 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);
4934: END IF;
4935: EXCEPTION
4936: WHEN FND_API.G_EXC_ERROR THEN
4937: RAISE FND_API.G_EXC_ERROR;
4938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4940: WHEN OTHERS THEN

Line 4937: RAISE FND_API.G_EXC_ERROR;

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

Line 4938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4934: END IF;
4935: EXCEPTION
4936: WHEN FND_API.G_EXC_ERROR THEN
4937: RAISE FND_API.G_EXC_ERROR;
4938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4940: WHEN OTHERS THEN
4941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4942: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');

Line 4939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4935: EXCEPTION
4936: WHEN FND_API.G_EXC_ERROR THEN
4937: RAISE FND_API.G_EXC_ERROR;
4938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4940: WHEN OTHERS THEN
4941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4942: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4942: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4944: FND_MSG_PUB.ADD;
4945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4946: END call_api_dynamic;
4947:
4948:
4949: PROCEDURE get_matching_party_sites (

Line 5183: WHEN FND_API.G_EXC_ERROR THEN

5179: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5180: 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);
5181: END IF;
5182: EXCEPTION
5183: WHEN FND_API.G_EXC_ERROR THEN
5184: RAISE FND_API.G_EXC_ERROR;
5185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: WHEN OTHERS THEN

Line 5184: RAISE FND_API.G_EXC_ERROR;

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

Line 5185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5181: END IF;
5182: EXCEPTION
5183: WHEN FND_API.G_EXC_ERROR THEN
5184: RAISE FND_API.G_EXC_ERROR;
5185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: WHEN OTHERS THEN
5188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5189: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');

Line 5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5182: EXCEPTION
5183: WHEN FND_API.G_EXC_ERROR THEN
5184: RAISE FND_API.G_EXC_ERROR;
5185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: WHEN OTHERS THEN
5188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5189: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5189: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5191: FND_MSG_PUB.ADD;
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: END get_matching_party_sites;
5194:
5195:
5196: PROCEDURE get_matching_contacts (

Line 5412: WHEN FND_API.G_EXC_ERROR THEN

5408: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5409: 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);
5410: END IF;
5411: EXCEPTION
5412: WHEN FND_API.G_EXC_ERROR THEN
5413: RAISE FND_API.G_EXC_ERROR;
5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN

Line 5413: RAISE FND_API.G_EXC_ERROR;

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

Line 5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5410: END IF;
5411: EXCEPTION
5412: WHEN FND_API.G_EXC_ERROR THEN
5413: RAISE FND_API.G_EXC_ERROR;
5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');

Line 5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5411: EXCEPTION
5412: WHEN FND_API.G_EXC_ERROR THEN
5413: RAISE FND_API.G_EXC_ERROR;
5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: END get_matching_contacts;
5423:
5424:
5425: PROCEDURE get_matching_contact_points (

Line 5554: WHEN FND_API.G_EXC_ERROR THEN

5550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5551: 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);
5552: END IF;
5553: EXCEPTION
5554: WHEN FND_API.G_EXC_ERROR THEN
5555: RAISE FND_API.G_EXC_ERROR;
5556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5558: WHEN OTHERS THEN

Line 5555: RAISE FND_API.G_EXC_ERROR;

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

Line 5556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5552: END IF;
5553: EXCEPTION
5554: WHEN FND_API.G_EXC_ERROR THEN
5555: RAISE FND_API.G_EXC_ERROR;
5556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');

Line 5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5553: EXCEPTION
5554: WHEN FND_API.G_EXC_ERROR THEN
5555: RAISE FND_API.G_EXC_ERROR;
5556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5561: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5792: WHEN FND_API.G_EXC_ERROR THEN

5788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5789: 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);
5790: END IF;
5791: EXCEPTION
5792: WHEN FND_API.G_EXC_ERROR THEN
5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN

Line 5793: RAISE FND_API.G_EXC_ERROR;

5789: 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);
5790: END IF;
5791: EXCEPTION
5792: WHEN FND_API.G_EXC_ERROR THEN
5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5790: END IF;
5791: EXCEPTION
5792: WHEN FND_API.G_EXC_ERROR THEN
5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');

Line 5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5791: EXCEPTION
5792: WHEN FND_API.G_EXC_ERROR THEN
5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5802: END get_score_details;
5803:
5804:
5805: /************************************************

Line 5915: WHEN FND_API.G_EXC_ERROR THEN

5911: END LOOP;
5912: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5913: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5914: EXCEPTION
5915: WHEN FND_API.G_EXC_ERROR THEN
5916: RAISE FND_API.G_EXC_ERROR;
5917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5919: WHEN OTHERS THEN

Line 5916: RAISE FND_API.G_EXC_ERROR;

5912: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5913: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5914: EXCEPTION
5915: WHEN FND_API.G_EXC_ERROR THEN
5916: RAISE FND_API.G_EXC_ERROR;
5917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5919: WHEN OTHERS THEN
5920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5913: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5914: EXCEPTION
5915: WHEN FND_API.G_EXC_ERROR THEN
5916: RAISE FND_API.G_EXC_ERROR;
5917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5919: WHEN OTHERS THEN
5920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5921: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5914: EXCEPTION
5915: WHEN FND_API.G_EXC_ERROR THEN
5916: RAISE FND_API.G_EXC_ERROR;
5917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5919: WHEN OTHERS THEN
5920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5921: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5921: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5923: FND_MSG_PUB.ADD;
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: END get_party_for_search;
5926:
5927: PROCEDURE get_search_criteria (
5928: p_party_id IN NUMBER,

Line 5967: WHEN FND_API.G_EXC_ERROR THEN

5963: END IF;
5964: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5965: END IF;
5966: EXCEPTION
5967: WHEN FND_API.G_EXC_ERROR THEN
5968: RAISE FND_API.G_EXC_ERROR;
5969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: WHEN OTHERS THEN

Line 5968: RAISE FND_API.G_EXC_ERROR;

5964: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5965: END IF;
5966: EXCEPTION
5967: WHEN FND_API.G_EXC_ERROR THEN
5968: RAISE FND_API.G_EXC_ERROR;
5969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: WHEN OTHERS THEN
5972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5965: END IF;
5966: EXCEPTION
5967: WHEN FND_API.G_EXC_ERROR THEN
5968: RAISE FND_API.G_EXC_ERROR;
5969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: WHEN OTHERS THEN
5972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5973: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5966: EXCEPTION
5967: WHEN FND_API.G_EXC_ERROR THEN
5968: RAISE FND_API.G_EXC_ERROR;
5969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: WHEN OTHERS THEN
5972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5973: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5973: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5975: FND_MSG_PUB.ADD;
5976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5977: END get_search_criteria;
5978:
5979:
5980: /************************************************

Line 6021: RAISE FND_API.G_EXC_ERROR;

6017: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6018: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6020: FND_MSG_PUB.ADD;
6021: RAISE FND_API.G_EXC_ERROR;
6022: END get_party_rec;
6023:
6024: /************************************************
6025: This procedure retrieves the match rule party site attributes into

Line 6087: RAISE FND_API.G_EXC_ERROR;

6083: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6084: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;
6087: RAISE FND_API.G_EXC_ERROR;
6088: END get_party_site_rec;
6089:
6090: /************************************************
6091: This procedure retrieves the match rule contact attributes into

Line 6145: RAISE FND_API.G_EXC_ERROR;

6141: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6142: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_ERROR;
6146: END get_contact_rec;
6147:
6148: /************************************************
6149: This procedure retrieves the match rule contact point attributes into

Line 6201: RAISE FND_API.G_EXC_ERROR;

6197: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6198: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_ERROR;
6202: END get_contact_point_rec;
6203:
6204: /************************************************
6205: This procedure maps a search record from the logical

Line 6297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6293: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6294: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6295: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6296: FND_MSG_PUB.ADD;
6297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6298: END;
6299:
6300:
6301: /************************************************

Line 6567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6563: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6564: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6566: FND_MSG_PUB.ADD;
6567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6568: END;
6569:
6570:
6571: /************************************************

Line 6624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6621: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6623: FND_MSG_PUB.ADD;
6624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6625: END;
6626:
6627:
6628: /************************************************

Line 6731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6727: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6728: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6730: FND_MSG_PUB.ADD;
6731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6732: END;
6733:
6734:
6735: /************************************************

Line 6755: RAISE FND_API.G_EXC_ERROR;

6751: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6752: ) THEN
6753: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_ERROR;
6756: END IF;
6757: END LOOP;
6758:
6759: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN

Line 6789: WHEN FND_API.G_EXC_ERROR THEN

6785: END IF;
6786: END LOOP;
6787: RETURN FALSE;
6788: EXCEPTION
6789: WHEN FND_API.G_EXC_ERROR THEN
6790: RAISE FND_API.G_EXC_ERROR;
6791: WHEN OTHERS THEN
6792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6793: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6790: RAISE FND_API.G_EXC_ERROR;

6786: END LOOP;
6787: RETURN FALSE;
6788: EXCEPTION
6789: WHEN FND_API.G_EXC_ERROR THEN
6790: RAISE FND_API.G_EXC_ERROR;
6791: WHEN OTHERS THEN
6792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6793: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6793: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6795: FND_MSG_PUB.ADD;
6796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6797: END check_prim_cond;
6798:
6799: /************************************************
6800: This procedure checks if the input search condition

Line 6857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6853: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6854: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6855: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6856: FND_MSG_PUB.ADD;
6857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6858: END check_party_site_cond;
6859:
6860: /************************************************
6861: This procedure checks if the input search condition

Line 6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6933: RAISE FND_API.G_EXC_ERROR;

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

Line 6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6955: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6956: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6957: FND_MSG_PUB.ADD;
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6959: END check_contact_point_cond;
6960:
6961: FUNCTION check_staged RETURN BOOLEAN IS
6962: