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

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

Line 1272: RAISE FND_API.G_EXC_ERROR;

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

Line 1276: RAISE FND_API.G_EXC_ERROR;

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

Line 1281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1513: RAISE FND_API.G_EXC_ERROR;

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

Line 1517: RAISE FND_API.G_EXC_ERROR;

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

Line 1521: RAISE FND_API.G_EXC_ERROR;

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

Line 1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1660: RAISE FND_API.G_EXC_ERROR;

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

Line 1664: RAISE FND_API.G_EXC_ERROR;

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

Line 1668: RAISE FND_API.G_EXC_ERROR;

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

Line 1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1933: RAISE FND_API.G_EXC_ERROR;

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

Line 1937: RAISE FND_API.G_EXC_ERROR;

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

Line 1941: RAISE FND_API.G_EXC_ERROR;

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

Line 1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2196: RAISE FND_API.G_EXC_ERROR;

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

Line 2244: RAISE FND_API.G_EXC_ERROR;

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

Line 2317: RAISE FND_API.G_EXC_ERROR;

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

Line 2429: RAISE FND_API.G_EXC_ERROR;

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

Line 2540: RAISE FND_API.G_EXC_ERROR;

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

Line 2765: RAISE FND_API.G_EXC_ERROR;

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

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

Line 2972: WHEN FND_API.G_EXC_ERROR THEN

2968: END IF;
2969: EXCEPTION
2970: WHEN L_RETURN_IMM_EXC THEN
2971: RETURN;
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: RAISE FND_API.G_EXC_ERROR;
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976: WHEN OTHERS THEN

Line 2973: RAISE FND_API.G_EXC_ERROR;

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

Line 2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3171: RAISE FND_API.G_EXC_ERROR;

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

Line 3219: RAISE FND_API.G_EXC_ERROR;

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

Line 3255: RAISE FND_API.G_EXC_ERROR;

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

Line 3259: RAISE FND_API.G_EXC_ERROR;

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

Line 3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3331: RAISE FND_API.G_EXC_ERROR;

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

Line 3590: RAISE FND_API.G_EXC_ERROR;

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

Line 3703: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3825: WHEN FND_API.G_EXC_ERROR THEN

3821: END IF;
3822: EXCEPTION
3823: WHEN L_RETURN_IMM_EXC THEN
3824: RETURN;
3825: WHEN FND_API.G_EXC_ERROR THEN
3826: RAISE FND_API.G_EXC_ERROR;
3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: WHEN OTHERS THEN

Line 3826: RAISE FND_API.G_EXC_ERROR;

3822: EXCEPTION
3823: WHEN L_RETURN_IMM_EXC THEN
3824: RETURN;
3825: WHEN FND_API.G_EXC_ERROR THEN
3826: RAISE FND_API.G_EXC_ERROR;
3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: WHEN OTHERS THEN
3830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3823: WHEN L_RETURN_IMM_EXC THEN
3824: RETURN;
3825: WHEN FND_API.G_EXC_ERROR THEN
3826: RAISE FND_API.G_EXC_ERROR;
3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: WHEN OTHERS THEN
3830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');

Line 3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3824: RETURN;
3825: WHEN FND_API.G_EXC_ERROR THEN
3826: RAISE FND_API.G_EXC_ERROR;
3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: WHEN OTHERS THEN
3830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3893: WHEN FND_API.G_EXC_ERROR THEN

3889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3890: 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);
3891: END IF;
3892: EXCEPTION
3893: WHEN FND_API.G_EXC_ERROR THEN
3894: RAISE FND_API.G_EXC_ERROR;
3895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3897: WHEN OTHERS THEN

Line 3894: RAISE FND_API.G_EXC_ERROR;

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

Line 3895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3891: END IF;
3892: EXCEPTION
3893: WHEN FND_API.G_EXC_ERROR THEN
3894: RAISE FND_API.G_EXC_ERROR;
3895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3897: WHEN OTHERS THEN
3898: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3899: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');

Line 3896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3892: EXCEPTION
3893: WHEN FND_API.G_EXC_ERROR THEN
3894: RAISE FND_API.G_EXC_ERROR;
3895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3897: WHEN OTHERS THEN
3898: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3899: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4010: WHEN FND_API.G_EXC_ERROR THEN

4006: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4007: 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);
4008: END IF;
4009: EXCEPTION
4010: WHEN FND_API.G_EXC_ERROR THEN
4011: RAISE FND_API.G_EXC_ERROR;
4012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN

Line 4011: RAISE FND_API.G_EXC_ERROR;

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

Line 4012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4008: END IF;
4009: EXCEPTION
4010: WHEN FND_API.G_EXC_ERROR THEN
4011: RAISE FND_API.G_EXC_ERROR;
4012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN
4015: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4016: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');

Line 4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4009: EXCEPTION
4010: WHEN FND_API.G_EXC_ERROR THEN
4011: RAISE FND_API.G_EXC_ERROR;
4012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN
4015: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4016: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4017: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4095: WHEN FND_API.G_EXC_ERROR THEN

4091: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4092: 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);
4093: END IF;
4094: EXCEPTION
4095: WHEN FND_API.G_EXC_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN

Line 4096: RAISE FND_API.G_EXC_ERROR;

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

Line 4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4093: END IF;
4094: EXCEPTION
4095: WHEN FND_API.G_EXC_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN
4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');

Line 4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4094: EXCEPTION
4095: WHEN FND_API.G_EXC_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN
4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4184: WHEN FND_API.G_EXC_ERROR THEN

4180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4181: 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);
4182: END IF;
4183: EXCEPTION
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN

Line 4185: RAISE FND_API.G_EXC_ERROR;

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

Line 4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4182: END IF;
4183: EXCEPTION
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');

Line 4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4183: EXCEPTION
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4257: WHEN FND_API.G_EXC_ERROR THEN

4253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4254: 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);
4255: END IF;
4256: EXCEPTION
4257: WHEN FND_API.G_EXC_ERROR THEN
4258: RAISE FND_API.G_EXC_ERROR;
4259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: WHEN OTHERS THEN

Line 4258: RAISE FND_API.G_EXC_ERROR;

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

Line 4259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4255: END IF;
4256: EXCEPTION
4257: WHEN FND_API.G_EXC_ERROR THEN
4258: RAISE FND_API.G_EXC_ERROR;
4259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: WHEN OTHERS THEN
4262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4263: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');

Line 4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4256: EXCEPTION
4257: WHEN FND_API.G_EXC_ERROR THEN
4258: RAISE FND_API.G_EXC_ERROR;
4259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: WHEN OTHERS THEN
4262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4263: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4551: WHEN FND_API.G_EXC_ERROR THEN

4547: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4548: 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);
4549: END IF;
4550: EXCEPTION
4551: WHEN FND_API.G_EXC_ERROR THEN
4552: RAISE FND_API.G_EXC_ERROR;
4553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: WHEN OTHERS THEN

Line 4552: RAISE FND_API.G_EXC_ERROR;

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

Line 4553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4549: END IF;
4550: EXCEPTION
4551: WHEN FND_API.G_EXC_ERROR THEN
4552: RAISE FND_API.G_EXC_ERROR;
4553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: WHEN OTHERS THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');

Line 4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4550: EXCEPTION
4551: WHEN FND_API.G_EXC_ERROR THEN
4552: RAISE FND_API.G_EXC_ERROR;
4553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: WHEN OTHERS THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4559: FND_MSG_PUB.ADD;
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: END call_api_dynamic;
4562:
4563:
4564: PROCEDURE get_matching_party_sites (

Line 4786: WHEN FND_API.G_EXC_ERROR THEN

4782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4783: 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);
4784: END IF;
4785: EXCEPTION
4786: WHEN FND_API.G_EXC_ERROR THEN
4787: RAISE FND_API.G_EXC_ERROR;
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: WHEN OTHERS THEN

Line 4787: RAISE FND_API.G_EXC_ERROR;

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

Line 4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4784: END IF;
4785: EXCEPTION
4786: WHEN FND_API.G_EXC_ERROR THEN
4787: RAISE FND_API.G_EXC_ERROR;
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: WHEN OTHERS THEN
4791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4792: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');

Line 4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4785: EXCEPTION
4786: WHEN FND_API.G_EXC_ERROR THEN
4787: RAISE FND_API.G_EXC_ERROR;
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: WHEN OTHERS THEN
4791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4792: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4792: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4794: FND_MSG_PUB.ADD;
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: END get_matching_party_sites;
4797:
4798:
4799: PROCEDURE get_matching_contacts (

Line 5015: WHEN FND_API.G_EXC_ERROR THEN

5011: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5012: 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);
5013: END IF;
5014: EXCEPTION
5015: WHEN FND_API.G_EXC_ERROR THEN
5016: RAISE FND_API.G_EXC_ERROR;
5017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5019: WHEN OTHERS THEN

Line 5016: RAISE FND_API.G_EXC_ERROR;

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

Line 5017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5013: END IF;
5014: EXCEPTION
5015: WHEN FND_API.G_EXC_ERROR THEN
5016: RAISE FND_API.G_EXC_ERROR;
5017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5019: WHEN OTHERS THEN
5020: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5021: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');

Line 5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5014: EXCEPTION
5015: WHEN FND_API.G_EXC_ERROR THEN
5016: RAISE FND_API.G_EXC_ERROR;
5017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5019: WHEN OTHERS THEN
5020: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5021: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5020: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5021: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5023: FND_MSG_PUB.ADD;
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: END get_matching_contacts;
5026:
5027:
5028: PROCEDURE get_matching_contact_points (

Line 5157: WHEN FND_API.G_EXC_ERROR THEN

5153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5154: 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);
5155: END IF;
5156: EXCEPTION
5157: WHEN FND_API.G_EXC_ERROR THEN
5158: RAISE FND_API.G_EXC_ERROR;
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5161: WHEN OTHERS THEN

Line 5158: RAISE FND_API.G_EXC_ERROR;

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

Line 5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5155: END IF;
5156: EXCEPTION
5157: WHEN FND_API.G_EXC_ERROR THEN
5158: RAISE FND_API.G_EXC_ERROR;
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5161: WHEN OTHERS THEN
5162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5163: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');

Line 5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5156: EXCEPTION
5157: WHEN FND_API.G_EXC_ERROR THEN
5158: RAISE FND_API.G_EXC_ERROR;
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5161: WHEN OTHERS THEN
5162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5163: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');
5164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5362: WHEN FND_API.G_EXC_ERROR THEN

5358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5359: 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);
5360: END IF;
5361: EXCEPTION
5362: WHEN FND_API.G_EXC_ERROR THEN
5363: RAISE FND_API.G_EXC_ERROR;
5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5366: WHEN OTHERS THEN

Line 5363: RAISE FND_API.G_EXC_ERROR;

5359: 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);
5360: END IF;
5361: EXCEPTION
5362: WHEN FND_API.G_EXC_ERROR THEN
5363: RAISE FND_API.G_EXC_ERROR;
5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5366: WHEN OTHERS THEN
5367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5360: END IF;
5361: EXCEPTION
5362: WHEN FND_API.G_EXC_ERROR THEN
5363: RAISE FND_API.G_EXC_ERROR;
5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5366: WHEN OTHERS THEN
5367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5368: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');

Line 5365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5361: EXCEPTION
5362: WHEN FND_API.G_EXC_ERROR THEN
5363: RAISE FND_API.G_EXC_ERROR;
5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5366: WHEN OTHERS THEN
5367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5368: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5368: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5372: END get_score_details;
5373:
5374:
5375: /************************************************

Line 5450: WHEN FND_API.G_EXC_ERROR THEN

5446: END LOOP;
5447: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5448: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5449: EXCEPTION
5450: WHEN FND_API.G_EXC_ERROR THEN
5451: RAISE FND_API.G_EXC_ERROR;
5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5454: WHEN OTHERS THEN

Line 5451: RAISE FND_API.G_EXC_ERROR;

5447: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5448: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5449: EXCEPTION
5450: WHEN FND_API.G_EXC_ERROR THEN
5451: RAISE FND_API.G_EXC_ERROR;
5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5454: WHEN OTHERS THEN
5455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5448: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5449: EXCEPTION
5450: WHEN FND_API.G_EXC_ERROR THEN
5451: RAISE FND_API.G_EXC_ERROR;
5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5454: WHEN OTHERS THEN
5455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5456: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5449: EXCEPTION
5450: WHEN FND_API.G_EXC_ERROR THEN
5451: RAISE FND_API.G_EXC_ERROR;
5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5454: WHEN OTHERS THEN
5455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5456: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5456: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5458: FND_MSG_PUB.ADD;
5459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5460: END get_party_for_search;
5461:
5462: PROCEDURE get_search_criteria (
5463: p_party_id IN NUMBER,

Line 5496: WHEN FND_API.G_EXC_ERROR THEN

5492: END IF;
5493: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5494: END IF;
5495: EXCEPTION
5496: WHEN FND_API.G_EXC_ERROR THEN
5497: RAISE FND_API.G_EXC_ERROR;
5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5500: WHEN OTHERS THEN

Line 5497: RAISE FND_API.G_EXC_ERROR;

5493: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5494: END IF;
5495: EXCEPTION
5496: WHEN FND_API.G_EXC_ERROR THEN
5497: RAISE FND_API.G_EXC_ERROR;
5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5500: WHEN OTHERS THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5494: END IF;
5495: EXCEPTION
5496: WHEN FND_API.G_EXC_ERROR THEN
5497: RAISE FND_API.G_EXC_ERROR;
5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5500: WHEN OTHERS THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5502: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5495: EXCEPTION
5496: WHEN FND_API.G_EXC_ERROR THEN
5497: RAISE FND_API.G_EXC_ERROR;
5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5500: WHEN OTHERS THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5502: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5503: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5502: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5503: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5504: FND_MSG_PUB.ADD;
5505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5506: END get_search_criteria;
5507:
5508:
5509: /************************************************

Line 5550: RAISE FND_API.G_EXC_ERROR;

5546: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5547: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;
5551: END get_party_rec;
5552:
5553: /************************************************
5554: This procedure retrieves the match rule party site attributes into

Line 5602: RAISE FND_API.G_EXC_ERROR;

5598: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5599: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5601: FND_MSG_PUB.ADD;
5602: RAISE FND_API.G_EXC_ERROR;
5603: END get_party_site_rec;
5604:
5605: /************************************************
5606: This procedure retrieves the match rule contact attributes into

Line 5660: RAISE FND_API.G_EXC_ERROR;

5656: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_ERROR;
5661: END get_contact_rec;
5662:
5663: /************************************************
5664: This procedure retrieves the match rule contact point attributes into

Line 5716: RAISE FND_API.G_EXC_ERROR;

5712: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5713: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5715: FND_MSG_PUB.ADD;
5716: RAISE FND_API.G_EXC_ERROR;
5717: END get_contact_point_rec;
5718:
5719: /************************************************
5720: This procedure maps a search record from the logical

Line 5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5809: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5811: FND_MSG_PUB.ADD;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5813: END;
5814:
5815:
5816: /************************************************

Line 5855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5851: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5852: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5853: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5854: FND_MSG_PUB.ADD;
5855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5856: END;
5857:
5858:
5859: /************************************************

Line 5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5908: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END;
5914:
5915:
5916: /************************************************

Line 6043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6039: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6040: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6042: FND_MSG_PUB.ADD;
6043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6044: END;
6045:
6046:
6047: /************************************************

Line 6068: RAISE FND_API.G_EXC_ERROR;

6064: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6065: ) THEN
6066: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6067: FND_MSG_PUB.ADD;
6068: RAISE FND_API.G_EXC_ERROR;
6069: END IF;
6070: END LOOP;
6071:
6072: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN

Line 6092: WHEN FND_API.G_EXC_ERROR THEN

6088: END IF;
6089: END LOOP;
6090: RETURN FALSE;
6091: EXCEPTION
6092: WHEN FND_API.G_EXC_ERROR THEN
6093: RAISE FND_API.G_EXC_ERROR;
6094: WHEN OTHERS THEN
6095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6096: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6093: RAISE FND_API.G_EXC_ERROR;

6089: END LOOP;
6090: RETURN FALSE;
6091: EXCEPTION
6092: WHEN FND_API.G_EXC_ERROR THEN
6093: RAISE FND_API.G_EXC_ERROR;
6094: WHEN OTHERS THEN
6095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6096: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6096: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6100: END check_prim_cond;
6101:
6102: /************************************************
6103: This procedure checks if the input search condition

Line 6145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6142: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6146: END check_party_site_cond;
6147:
6148: /************************************************
6149: This procedure checks if the input search condition

Line 6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6198: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6202: END check_contact_cond;
6203:
6204: /************************************************
6205: This procedure checks if the input search condition

Line 6222: RAISE FND_API.G_EXC_ERROR;

6218: FOR I IN 1..p_contact_point_list.COUNT LOOP
6219: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6220: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6221: FND_MSG_PUB.ADD;
6222: RAISE FND_API.G_EXC_ERROR;
6223: END IF;
6224: END LOOP;
6225:
6226: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6245: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6247: FND_MSG_PUB.ADD;
6248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6249: END check_contact_point_cond;
6250:
6251: FUNCTION check_staged RETURN BOOLEAN IS
6252: