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_98 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 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
547: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END;
552:
553:
554: /************************************************

Line 570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

566: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
567: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
569: FND_MSG_PUB.ADD;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END;
572:
573:
574: /************************************************

Line 590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

586: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
587: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
588: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
589: FND_MSG_PUB.ADD;
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END;
592:
593:
594: /************************************************

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
607: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
609: FND_MSG_PUB.ADD;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END;
612:
613: PROCEDURE init_score_context (
614: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 677: RAISE FND_API.G_EXC_ERROR;

673: p_contact_list,
674: p_contact_point_list) THEN
675: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
676: FND_MSG_PUB.ADD;
677: RAISE FND_API.G_EXC_ERROR;
678: END IF;
679: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
680: 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);
681: END IF;

Line 895: RAISE FND_API.G_EXC_ERROR;

891: IF lengthb(l_party_contains_str) > 4000 THEN
892: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
893: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: IF (p_match_str = ' AND ' OR p_party_max_score 898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
899: 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 973: RAISE FND_API.G_EXC_ERROR;

969: IF lengthb(l_contains_str) > 4000 THEN
970: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
971: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: x_denorm_str := l_den_contains_str;
976: RETURN l_contains_str;
977: END;

Line 1054: RAISE FND_API.G_EXC_ERROR;

1050: IF lengthb(l_contains_str) > 4000 THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1052: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1053: FND_MSG_PUB.ADD;
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056: x_denorm_str := l_den_contains_str;
1057: RETURN l_contains_str;
1058: END;

Line 1266: RAISE FND_API.G_EXC_ERROR;

1262: when others then
1263: if (instrb(SQLERRM,'DRG-51030')>0) then
1264: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1265: FND_MSG_PUB.ADD;
1266: RAISE FND_API.G_EXC_ERROR;
1267: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1269: FND_MSG_PUB.ADD;
1270: RAISE FND_API.G_EXC_ERROR;

Line 1270: RAISE FND_API.G_EXC_ERROR;

1266: RAISE FND_API.G_EXC_ERROR;
1267: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1269: FND_MSG_PUB.ADD;
1270: RAISE FND_API.G_EXC_ERROR;
1271: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_ERROR;

Line 1274: RAISE FND_API.G_EXC_ERROR;

1270: RAISE FND_API.G_EXC_ERROR;
1271: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_ERROR;
1275: else
1276: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1277: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1278: FND_MSG_PUB.ADD;

Line 1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1275: else
1276: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1277: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1278: FND_MSG_PUB.ADD;
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: end if;
1281: END;
1282:
1283: PROCEDURE open_party_site_cursor(

Line 1511: RAISE FND_API.G_EXC_ERROR;

1507: when others then
1508: if (instrb(SQLERRM,'DRG-51030')>0) then
1509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1510: FND_MSG_PUB.ADD;
1511: RAISE FND_API.G_EXC_ERROR;
1512: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;

Line 1515: RAISE FND_API.G_EXC_ERROR;

1511: RAISE FND_API.G_EXC_ERROR;
1512: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;
1516: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1518: FND_MSG_PUB.ADD;
1519: RAISE FND_API.G_EXC_ERROR;

Line 1519: RAISE FND_API.G_EXC_ERROR;

1515: RAISE FND_API.G_EXC_ERROR;
1516: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1518: FND_MSG_PUB.ADD;
1519: RAISE FND_API.G_EXC_ERROR;
1520: else
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1522: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1523: FND_MSG_PUB.ADD;

Line 1524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1520: else
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1522: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1523: FND_MSG_PUB.ADD;
1524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1525: end if;
1526: END;
1527:
1528: PROCEDURE open_contact_cursor(

Line 1658: RAISE FND_API.G_EXC_ERROR;

1654: when others then
1655: if (instrb(SQLERRM,'DRG-51030')>0) then
1656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1657: FND_MSG_PUB.ADD;
1658: RAISE FND_API.G_EXC_ERROR;
1659: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1660: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1661: FND_MSG_PUB.ADD;
1662: RAISE FND_API.G_EXC_ERROR;

Line 1662: RAISE FND_API.G_EXC_ERROR;

1658: RAISE FND_API.G_EXC_ERROR;
1659: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1660: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1661: FND_MSG_PUB.ADD;
1662: RAISE FND_API.G_EXC_ERROR;
1663: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1665: FND_MSG_PUB.ADD;
1666: RAISE FND_API.G_EXC_ERROR;

Line 1666: RAISE FND_API.G_EXC_ERROR;

1662: RAISE FND_API.G_EXC_ERROR;
1663: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1665: FND_MSG_PUB.ADD;
1666: RAISE FND_API.G_EXC_ERROR;
1667: else
1668: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1670: FND_MSG_PUB.ADD;

Line 1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1667: else
1668: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1670: FND_MSG_PUB.ADD;
1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1672: end if;
1673: END;
1674:
1675: PROCEDURE open_contact_pt_cursor(

Line 1931: RAISE FND_API.G_EXC_ERROR;

1927: when others then
1928: if (instrb(SQLERRM,'DRG-51030')>0) then
1929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1930: FND_MSG_PUB.ADD;
1931: RAISE FND_API.G_EXC_ERROR;
1932: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1933: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_ERROR;

Line 1935: RAISE FND_API.G_EXC_ERROR;

1931: RAISE FND_API.G_EXC_ERROR;
1932: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1933: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_ERROR;
1936: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1938: FND_MSG_PUB.ADD;
1939: RAISE FND_API.G_EXC_ERROR;

Line 1939: RAISE FND_API.G_EXC_ERROR;

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

Line 1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1940: else
1941: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1943: FND_MSG_PUB.ADD;
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: end if;
1946: END;
1947:
1948:

Line 2193: RAISE FND_API.G_EXC_ERROR;

2189: 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);
2190: END IF;
2191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2192: FND_MSG_PUB.ADD;
2193: RAISE FND_API.G_EXC_ERROR;
2194: ELSE
2195: push_eval;
2196: RETURN;
2197: END IF;

Line 2241: RAISE FND_API.G_EXC_ERROR;

2237: 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);
2238: END IF;
2239: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2240: FND_MSG_PUB.ADD;
2241: RAISE FND_API.G_EXC_ERROR;
2242: ELSE
2243: push_eval;
2244: RETURN;
2245: END IF;

Line 2314: RAISE FND_API.G_EXC_ERROR;

2310: 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);
2311: END IF;
2312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2313: FND_MSG_PUB.ADD;
2314: RAISE FND_API.G_EXC_ERROR;
2315: ELSE
2316: push_eval;
2317: RETURN;
2318: END IF;

Line 2426: RAISE FND_API.G_EXC_ERROR;

2422: 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);
2423: END IF;
2424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2425: FND_MSG_PUB.ADD;
2426: RAISE FND_API.G_EXC_ERROR;
2427: ELSE
2428: push_eval;
2429: RETURN;
2430: END IF;

Line 2537: RAISE FND_API.G_EXC_ERROR;

2533: 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);
2534: END IF;
2535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2536: FND_MSG_PUB.ADD;
2537: RAISE FND_API.G_EXC_ERROR;
2538: ELSE
2539: push_eval;
2540: RETURN;
2541: END IF;

Line 2762: RAISE FND_API.G_EXC_ERROR;

2758: 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);
2759: END IF;
2760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2761: FND_MSG_PUB.ADD;
2762: RAISE FND_API.G_EXC_ERROR;
2763: END IF;
2764: ELSE
2765: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2766: 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 2770: RAISE FND_API.G_EXC_ERROR;

2766: 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);
2767: END IF;
2768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2769: FND_MSG_PUB.ADD;
2770: RAISE FND_API.G_EXC_ERROR;
2771: END IF;
2772: END IF;
2773: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2774: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2969: WHEN FND_API.G_EXC_ERROR THEN

2965: END IF;
2966: EXCEPTION
2967: WHEN L_RETURN_IMM_EXC THEN
2968: RETURN;
2969: WHEN FND_API.G_EXC_ERROR THEN
2970: RAISE FND_API.G_EXC_ERROR;
2971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2973: WHEN OTHERS THEN

Line 2970: RAISE FND_API.G_EXC_ERROR;

2966: EXCEPTION
2967: WHEN L_RETURN_IMM_EXC THEN
2968: RETURN;
2969: WHEN FND_API.G_EXC_ERROR THEN
2970: RAISE FND_API.G_EXC_ERROR;
2971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2973: WHEN OTHERS THEN
2974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2967: WHEN L_RETURN_IMM_EXC THEN
2968: RETURN;
2969: WHEN FND_API.G_EXC_ERROR THEN
2970: RAISE FND_API.G_EXC_ERROR;
2971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2973: WHEN OTHERS THEN
2974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2975: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_parties');

Line 2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2968: RETURN;
2969: WHEN FND_API.G_EXC_ERROR THEN
2970: RAISE FND_API.G_EXC_ERROR;
2971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2973: WHEN OTHERS THEN
2974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2975: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_parties');
2976: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2975: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_parties');
2976: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2977: FND_MSG_PUB.ADD;
2978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2979: END find_parties;
2980:
2981: PROCEDURE find_persons (
2982: p_rule_id IN NUMBER,

Line 3167: RAISE FND_API.G_EXC_ERROR;

3163: 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);
3164: END IF;
3165: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3166: FND_MSG_PUB.ADD;
3167: RAISE FND_API.G_EXC_ERROR;
3168: ELSE
3169: push_eval;
3170: RETURN;
3171: END IF;

Line 3215: RAISE FND_API.G_EXC_ERROR;

3211: 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);
3212: END IF;
3213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3214: FND_MSG_PUB.ADD;
3215: RAISE FND_API.G_EXC_ERROR;
3216: ELSE
3217: push_eval;
3218: RETURN;
3219: END IF;

Line 3251: RAISE FND_API.G_EXC_ERROR;

3247: when others then
3248: if (instrb(SQLERRM,'DRG-51030')>0) then
3249: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3250: FND_MSG_PUB.ADD;
3251: RAISE FND_API.G_EXC_ERROR;
3252: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3254: FND_MSG_PUB.ADD;
3255: RAISE FND_API.G_EXC_ERROR;

Line 3255: RAISE FND_API.G_EXC_ERROR;

3251: RAISE FND_API.G_EXC_ERROR;
3252: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3254: FND_MSG_PUB.ADD;
3255: RAISE FND_API.G_EXC_ERROR;
3256: else
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258: end if;
3259: END;

Line 3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3254: FND_MSG_PUB.ADD;
3255: RAISE FND_API.G_EXC_ERROR;
3256: else
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258: end if;
3259: END;
3260:
3261: /** Private procedure to acquire and score at party site level ***/

Line 3327: RAISE FND_API.G_EXC_ERROR;

3323: 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);
3324: END IF;
3325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3326: FND_MSG_PUB.ADD;
3327: RAISE FND_API.G_EXC_ERROR;
3328: ELSE
3329: push_eval;
3330: RETURN;
3331: END IF;

Line 3586: RAISE FND_API.G_EXC_ERROR;

3582: 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);
3583: END IF;
3584: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3585: FND_MSG_PUB.ADD;
3586: RAISE FND_API.G_EXC_ERROR;
3587: ELSE
3588: push_eval;
3589: RETURN;
3590: END IF;

Line 3699: RAISE FND_API.G_EXC_ERROR;

3695: 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);
3696: END IF;
3697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_ERROR;
3700: END IF;
3701: ELSE
3702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3703: 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 3707: RAISE FND_API.G_EXC_ERROR;

3703: 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);
3704: END IF;
3705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3706: FND_MSG_PUB.ADD;
3707: RAISE FND_API.G_EXC_ERROR;
3708: END IF;
3709: END IF;
3710: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3711: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3821: WHEN FND_API.G_EXC_ERROR THEN

3817: END IF;
3818: EXCEPTION
3819: WHEN L_RETURN_IMM_EXC THEN
3820: RETURN;
3821: WHEN FND_API.G_EXC_ERROR THEN
3822: RAISE FND_API.G_EXC_ERROR;
3823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3825: WHEN OTHERS THEN

Line 3822: RAISE FND_API.G_EXC_ERROR;

3818: EXCEPTION
3819: WHEN L_RETURN_IMM_EXC THEN
3820: RETURN;
3821: WHEN FND_API.G_EXC_ERROR THEN
3822: RAISE FND_API.G_EXC_ERROR;
3823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3825: WHEN OTHERS THEN
3826: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3819: WHEN L_RETURN_IMM_EXC THEN
3820: RETURN;
3821: WHEN FND_API.G_EXC_ERROR THEN
3822: RAISE FND_API.G_EXC_ERROR;
3823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3825: WHEN OTHERS THEN
3826: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3827: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');

Line 3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3820: RETURN;
3821: WHEN FND_API.G_EXC_ERROR THEN
3822: RAISE FND_API.G_EXC_ERROR;
3823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3825: WHEN OTHERS THEN
3826: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3827: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3826: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3827: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3829: FND_MSG_PUB.ADD;
3830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3831: END find_persons;
3832:
3833: PROCEDURE find_persons (
3834: p_rule_id IN NUMBER,

Line 3889: WHEN FND_API.G_EXC_ERROR THEN

3885: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3886: 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);
3887: END IF;
3888: EXCEPTION
3889: WHEN FND_API.G_EXC_ERROR THEN
3890: RAISE FND_API.G_EXC_ERROR;
3891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3893: WHEN OTHERS THEN

Line 3890: RAISE FND_API.G_EXC_ERROR;

3886: 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);
3887: END IF;
3888: EXCEPTION
3889: WHEN FND_API.G_EXC_ERROR THEN
3890: RAISE FND_API.G_EXC_ERROR;
3891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3893: WHEN OTHERS THEN
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3887: END IF;
3888: EXCEPTION
3889: WHEN FND_API.G_EXC_ERROR THEN
3890: RAISE FND_API.G_EXC_ERROR;
3891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3893: WHEN OTHERS THEN
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');

Line 3892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3888: EXCEPTION
3889: WHEN FND_API.G_EXC_ERROR THEN
3890: RAISE FND_API.G_EXC_ERROR;
3891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3893: WHEN OTHERS THEN
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3897: FND_MSG_PUB.ADD;
3898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3899: END find_party_details;
3900:
3901: PROCEDURE find_duplicate_parties (
3902: p_rule_id IN NUMBER,

Line 4006: WHEN FND_API.G_EXC_ERROR THEN

4002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4003: 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);
4004: END IF;
4005: EXCEPTION
4006: WHEN FND_API.G_EXC_ERROR THEN
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: WHEN OTHERS THEN

Line 4007: RAISE FND_API.G_EXC_ERROR;

4003: 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);
4004: END IF;
4005: EXCEPTION
4006: WHEN FND_API.G_EXC_ERROR THEN
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: WHEN OTHERS THEN
4011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4004: END IF;
4005: EXCEPTION
4006: WHEN FND_API.G_EXC_ERROR THEN
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: WHEN OTHERS THEN
4011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4012: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');

Line 4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4005: EXCEPTION
4006: WHEN FND_API.G_EXC_ERROR THEN
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: WHEN OTHERS THEN
4011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4012: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4013: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4012: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4013: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4014: FND_MSG_PUB.ADD;
4015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4016: END find_duplicate_parties;
4017:
4018: PROCEDURE find_duplicate_party_sites (
4019: p_rule_id IN NUMBER,

Line 4091: WHEN FND_API.G_EXC_ERROR THEN

4087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4088: 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);
4089: END IF;
4090: EXCEPTION
4091: WHEN FND_API.G_EXC_ERROR THEN
4092: RAISE FND_API.G_EXC_ERROR;
4093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: WHEN OTHERS THEN

Line 4092: RAISE FND_API.G_EXC_ERROR;

4088: 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);
4089: END IF;
4090: EXCEPTION
4091: WHEN FND_API.G_EXC_ERROR THEN
4092: RAISE FND_API.G_EXC_ERROR;
4093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: WHEN OTHERS THEN
4096: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4089: END IF;
4090: EXCEPTION
4091: WHEN FND_API.G_EXC_ERROR THEN
4092: RAISE FND_API.G_EXC_ERROR;
4093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: WHEN OTHERS THEN
4096: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4097: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');

Line 4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4090: EXCEPTION
4091: WHEN FND_API.G_EXC_ERROR THEN
4092: RAISE FND_API.G_EXC_ERROR;
4093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: WHEN OTHERS THEN
4096: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4097: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4098: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4096: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4097: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4098: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4099: FND_MSG_PUB.ADD;
4100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4101: END find_duplicate_party_sites;
4102:
4103: PROCEDURE find_duplicate_contacts (
4104: p_rule_id IN NUMBER,

Line 4180: WHEN FND_API.G_EXC_ERROR THEN

4176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4177: 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);
4178: END IF;
4179: EXCEPTION
4180: WHEN FND_API.G_EXC_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN

Line 4181: RAISE FND_API.G_EXC_ERROR;

4177: 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);
4178: END IF;
4179: EXCEPTION
4180: WHEN FND_API.G_EXC_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4178: END IF;
4179: EXCEPTION
4180: WHEN FND_API.G_EXC_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');

Line 4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4179: EXCEPTION
4180: WHEN FND_API.G_EXC_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4188: FND_MSG_PUB.ADD;
4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4190: END find_duplicate_contacts;
4191:
4192: PROCEDURE find_duplicate_contact_points (
4193: p_rule_id IN NUMBER,

Line 4253: WHEN FND_API.G_EXC_ERROR THEN

4249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4250: 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);
4251: END IF;
4252: EXCEPTION
4253: WHEN FND_API.G_EXC_ERROR THEN
4254: RAISE FND_API.G_EXC_ERROR;
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4257: WHEN OTHERS THEN

Line 4254: RAISE FND_API.G_EXC_ERROR;

4250: 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);
4251: END IF;
4252: EXCEPTION
4253: WHEN FND_API.G_EXC_ERROR THEN
4254: RAISE FND_API.G_EXC_ERROR;
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4257: WHEN OTHERS THEN
4258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4251: END IF;
4252: EXCEPTION
4253: WHEN FND_API.G_EXC_ERROR THEN
4254: RAISE FND_API.G_EXC_ERROR;
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4257: WHEN OTHERS THEN
4258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');

Line 4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4252: EXCEPTION
4253: WHEN FND_API.G_EXC_ERROR THEN
4254: RAISE FND_API.G_EXC_ERROR;
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4257: WHEN OTHERS THEN
4258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4261: FND_MSG_PUB.ADD;
4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4263: END find_duplicate_contact_points;
4264:
4265: PROCEDURE find_parties_dynamic (
4266: p_rule_id IN NUMBER,

Line 4547: WHEN FND_API.G_EXC_ERROR THEN

4543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4544: 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);
4545: END IF;
4546: EXCEPTION
4547: WHEN FND_API.G_EXC_ERROR THEN
4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4551: WHEN OTHERS THEN

Line 4548: RAISE FND_API.G_EXC_ERROR;

4544: 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);
4545: END IF;
4546: EXCEPTION
4547: WHEN FND_API.G_EXC_ERROR THEN
4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4551: WHEN OTHERS THEN
4552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4545: END IF;
4546: EXCEPTION
4547: WHEN FND_API.G_EXC_ERROR THEN
4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4551: WHEN OTHERS THEN
4552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');

Line 4550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4546: EXCEPTION
4547: WHEN FND_API.G_EXC_ERROR THEN
4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4551: WHEN OTHERS THEN
4552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4555: FND_MSG_PUB.ADD;
4556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4557: END call_api_dynamic;
4558:
4559:
4560: PROCEDURE get_matching_party_sites (

Line 4782: WHEN FND_API.G_EXC_ERROR THEN

4778: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4779: 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);
4780: END IF;
4781: EXCEPTION
4782: WHEN FND_API.G_EXC_ERROR THEN
4783: RAISE FND_API.G_EXC_ERROR;
4784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4786: WHEN OTHERS THEN

Line 4783: RAISE FND_API.G_EXC_ERROR;

4779: 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);
4780: END IF;
4781: EXCEPTION
4782: WHEN FND_API.G_EXC_ERROR THEN
4783: RAISE FND_API.G_EXC_ERROR;
4784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4786: WHEN OTHERS THEN
4787: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4780: END IF;
4781: EXCEPTION
4782: WHEN FND_API.G_EXC_ERROR THEN
4783: RAISE FND_API.G_EXC_ERROR;
4784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4786: WHEN OTHERS THEN
4787: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4788: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');

Line 4785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4781: EXCEPTION
4782: WHEN FND_API.G_EXC_ERROR THEN
4783: RAISE FND_API.G_EXC_ERROR;
4784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4786: WHEN OTHERS THEN
4787: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4788: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4789: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4787: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4788: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4789: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4790: FND_MSG_PUB.ADD;
4791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4792: END get_matching_party_sites;
4793:
4794:
4795: PROCEDURE get_matching_contacts (

Line 5011: WHEN FND_API.G_EXC_ERROR THEN

5007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5008: 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);
5009: END IF;
5010: EXCEPTION
5011: WHEN FND_API.G_EXC_ERROR THEN
5012: RAISE FND_API.G_EXC_ERROR;
5013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: WHEN OTHERS THEN

Line 5012: RAISE FND_API.G_EXC_ERROR;

5008: 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);
5009: END IF;
5010: EXCEPTION
5011: WHEN FND_API.G_EXC_ERROR THEN
5012: RAISE FND_API.G_EXC_ERROR;
5013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: WHEN OTHERS THEN
5016: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5009: END IF;
5010: EXCEPTION
5011: WHEN FND_API.G_EXC_ERROR THEN
5012: RAISE FND_API.G_EXC_ERROR;
5013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: WHEN OTHERS THEN
5016: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5017: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');

Line 5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5010: EXCEPTION
5011: WHEN FND_API.G_EXC_ERROR THEN
5012: RAISE FND_API.G_EXC_ERROR;
5013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: WHEN OTHERS THEN
5016: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5017: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5018: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5016: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5017: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5018: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5019: FND_MSG_PUB.ADD;
5020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5021: END get_matching_contacts;
5022:
5023:
5024: PROCEDURE get_matching_contact_points (

Line 5153: WHEN FND_API.G_EXC_ERROR THEN

5149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5150: 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);
5151: END IF;
5152: EXCEPTION
5153: WHEN FND_API.G_EXC_ERROR THEN
5154: RAISE FND_API.G_EXC_ERROR;
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5157: WHEN OTHERS THEN

Line 5154: RAISE FND_API.G_EXC_ERROR;

5150: 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);
5151: END IF;
5152: EXCEPTION
5153: WHEN FND_API.G_EXC_ERROR THEN
5154: RAISE FND_API.G_EXC_ERROR;
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5157: WHEN OTHERS THEN
5158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5151: END IF;
5152: EXCEPTION
5153: WHEN FND_API.G_EXC_ERROR THEN
5154: RAISE FND_API.G_EXC_ERROR;
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5157: WHEN OTHERS THEN
5158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5159: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');

Line 5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5152: EXCEPTION
5153: WHEN FND_API.G_EXC_ERROR THEN
5154: RAISE FND_API.G_EXC_ERROR;
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5157: WHEN OTHERS THEN
5158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5159: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5159: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5163: END get_matching_contact_points;
5164:
5165: /**********************************************************
5166: This procedure finds the score details for a specific party that

Line 5357: WHEN FND_API.G_EXC_ERROR THEN

5353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5354: 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);
5355: END IF;
5356: EXCEPTION
5357: WHEN FND_API.G_EXC_ERROR THEN
5358: RAISE FND_API.G_EXC_ERROR;
5359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: WHEN OTHERS THEN

Line 5358: RAISE FND_API.G_EXC_ERROR;

5354: 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);
5355: END IF;
5356: EXCEPTION
5357: WHEN FND_API.G_EXC_ERROR THEN
5358: RAISE FND_API.G_EXC_ERROR;
5359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: WHEN OTHERS THEN
5362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5355: END IF;
5356: EXCEPTION
5357: WHEN FND_API.G_EXC_ERROR THEN
5358: RAISE FND_API.G_EXC_ERROR;
5359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: WHEN OTHERS THEN
5362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');

Line 5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5356: EXCEPTION
5357: WHEN FND_API.G_EXC_ERROR THEN
5358: RAISE FND_API.G_EXC_ERROR;
5359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: WHEN OTHERS THEN
5362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5365: FND_MSG_PUB.ADD;
5366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5367: END get_score_details;
5368:
5369:
5370: /************************************************

Line 5445: WHEN FND_API.G_EXC_ERROR THEN

5441: END LOOP;
5442: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5443: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5444: EXCEPTION
5445: WHEN FND_API.G_EXC_ERROR THEN
5446: RAISE FND_API.G_EXC_ERROR;
5447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5449: WHEN OTHERS THEN

Line 5446: RAISE FND_API.G_EXC_ERROR;

5442: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5443: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5444: EXCEPTION
5445: WHEN FND_API.G_EXC_ERROR THEN
5446: RAISE FND_API.G_EXC_ERROR;
5447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5449: WHEN OTHERS THEN
5450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5443: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5444: EXCEPTION
5445: WHEN FND_API.G_EXC_ERROR THEN
5446: RAISE FND_API.G_EXC_ERROR;
5447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5449: WHEN OTHERS THEN
5450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5451: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5444: EXCEPTION
5445: WHEN FND_API.G_EXC_ERROR THEN
5446: RAISE FND_API.G_EXC_ERROR;
5447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5449: WHEN OTHERS THEN
5450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5451: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5451: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5453: FND_MSG_PUB.ADD;
5454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5455: END get_party_for_search;
5456:
5457: PROCEDURE get_search_criteria (
5458: p_party_id IN NUMBER,

Line 5491: WHEN FND_API.G_EXC_ERROR THEN

5487: END IF;
5488: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5489: END IF;
5490: EXCEPTION
5491: WHEN FND_API.G_EXC_ERROR THEN
5492: RAISE FND_API.G_EXC_ERROR;
5493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: WHEN OTHERS THEN

Line 5492: RAISE FND_API.G_EXC_ERROR;

5488: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5489: END IF;
5490: EXCEPTION
5491: WHEN FND_API.G_EXC_ERROR THEN
5492: RAISE FND_API.G_EXC_ERROR;
5493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: WHEN OTHERS THEN
5496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5489: END IF;
5490: EXCEPTION
5491: WHEN FND_API.G_EXC_ERROR THEN
5492: RAISE FND_API.G_EXC_ERROR;
5493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: WHEN OTHERS THEN
5496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5497: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5490: EXCEPTION
5491: WHEN FND_API.G_EXC_ERROR THEN
5492: RAISE FND_API.G_EXC_ERROR;
5493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: WHEN OTHERS THEN
5496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5497: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5498: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5497: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5498: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5499: FND_MSG_PUB.ADD;
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: END get_search_criteria;
5502:
5503:
5504: /************************************************

Line 5545: RAISE FND_API.G_EXC_ERROR;

5541: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5542: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_ERROR;
5546: END get_party_rec;
5547:
5548: /************************************************
5549: This procedure retrieves the match rule party site attributes into

Line 5597: RAISE FND_API.G_EXC_ERROR;

5593: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5594: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;
5597: RAISE FND_API.G_EXC_ERROR;
5598: END get_party_site_rec;
5599:
5600: /************************************************
5601: This procedure retrieves the match rule contact attributes into

Line 5655: RAISE FND_API.G_EXC_ERROR;

5651: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5652: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5654: FND_MSG_PUB.ADD;
5655: RAISE FND_API.G_EXC_ERROR;
5656: END get_contact_rec;
5657:
5658: /************************************************
5659: This procedure retrieves the match rule contact point attributes into

Line 5711: RAISE FND_API.G_EXC_ERROR;

5707: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5708: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5710: FND_MSG_PUB.ADD;
5711: RAISE FND_API.G_EXC_ERROR;
5712: END get_contact_point_rec;
5713:
5714: /************************************************
5715: This procedure maps a search record from the logical

Line 5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5846: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5847: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5848: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5849: FND_MSG_PUB.ADD;
5850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5851: END;
5852:
5853:
5854: /************************************************

Line 5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5903: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5904: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5906: FND_MSG_PUB.ADD;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5908: END;
5909:
5910:
5911: /************************************************

Line 6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6034: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6035: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6036: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6037: FND_MSG_PUB.ADD;
6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6039: END;
6040:
6041:
6042: /************************************************

Line 6063: RAISE FND_API.G_EXC_ERROR;

6059: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6060: ) THEN
6061: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6062: FND_MSG_PUB.ADD;
6063: RAISE FND_API.G_EXC_ERROR;
6064: END IF;
6065: END LOOP;
6066:
6067: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN

Line 6087: WHEN FND_API.G_EXC_ERROR THEN

6083: END IF;
6084: END LOOP;
6085: RETURN FALSE;
6086: EXCEPTION
6087: WHEN FND_API.G_EXC_ERROR THEN
6088: RAISE FND_API.G_EXC_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6088: RAISE FND_API.G_EXC_ERROR;

6084: END LOOP;
6085: RETURN FALSE;
6086: EXCEPTION
6087: WHEN FND_API.G_EXC_ERROR THEN
6088: RAISE FND_API.G_EXC_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END check_prim_cond;
6096:
6097: /************************************************
6098: This procedure checks if the input search condition

Line 6140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6137: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6138: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6139: FND_MSG_PUB.ADD;
6140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6141: END check_party_site_cond;
6142:
6143: /************************************************
6144: This procedure checks if the input search condition

Line 6196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6193: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6195: FND_MSG_PUB.ADD;
6196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6197: END check_contact_cond;
6198:
6199: /************************************************
6200: This procedure checks if the input search condition

Line 6217: RAISE FND_API.G_EXC_ERROR;

6213: FOR I IN 1..p_contact_point_list.COUNT LOOP
6214: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6215: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6216: FND_MSG_PUB.ADD;
6217: RAISE FND_API.G_EXC_ERROR;
6218: END IF;
6219: END LOOP;
6220:
6221: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6239: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6240: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6241: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6242: FND_MSG_PUB.ADD;
6243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6244: END check_contact_point_cond;
6245:
6246: FUNCTION check_staged RETURN BOOLEAN IS
6247: