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_5 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 482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

478: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
479: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END;
484:
485:
486: /************************************************

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
499: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
501: FND_MSG_PUB.ADD;
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END;
504:
505:
506: /************************************************

Line 522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

518: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
519: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
520: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
521: FND_MSG_PUB.ADD;
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END;
524:
525:
526: /************************************************

Line 542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

538: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
539: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: END;
544:
545: PROCEDURE init_score_context (
546: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 609: RAISE FND_API.G_EXC_ERROR;

605: p_contact_list,
606: p_contact_point_list) THEN
607: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
608: FND_MSG_PUB.ADD;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
612: 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);
613: END IF;

Line 827: RAISE FND_API.G_EXC_ERROR;

823: IF lengthb(l_party_contains_str) > 4000 THEN
824: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
825: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
826: FND_MSG_PUB.ADD;
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829: IF (p_match_str = ' AND ' OR p_party_max_score 830: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
831: 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 889: RAISE FND_API.G_EXC_ERROR;

885: IF lengthb(l_contains_str) > 4000 THEN
886: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
887: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
888: FND_MSG_PUB.ADD;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: x_denorm_str := l_den_contains_str;
892: RETURN l_contains_str;
893: END;

Line 1140: RAISE FND_API.G_EXC_ERROR;

1136: when others then
1137: if (instrb(SQLERRM,'DRG-51030')>0) then
1138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1139: FND_MSG_PUB.ADD;
1140: RAISE FND_API.G_EXC_ERROR;
1141: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_ERROR;

Line 1144: RAISE FND_API.G_EXC_ERROR;

1140: RAISE FND_API.G_EXC_ERROR;
1141: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_ERROR;
1145: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1147: FND_MSG_PUB.ADD;
1148: RAISE FND_API.G_EXC_ERROR;

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144: RAISE FND_API.G_EXC_ERROR;
1145: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1147: FND_MSG_PUB.ADD;
1148: RAISE FND_API.G_EXC_ERROR;
1149: else
1150: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1152: FND_MSG_PUB.ADD;

Line 1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1149: else
1150: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: end if;
1155: END;
1156:
1157: PROCEDURE open_party_site_cursor(

Line 1385: RAISE FND_API.G_EXC_ERROR;

1381: when others then
1382: if (instrb(SQLERRM,'DRG-51030')>0) then
1383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1384: FND_MSG_PUB.ADD;
1385: RAISE FND_API.G_EXC_ERROR;
1386: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;

Line 1389: RAISE FND_API.G_EXC_ERROR;

1385: RAISE FND_API.G_EXC_ERROR;
1386: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1392: FND_MSG_PUB.ADD;
1393: RAISE FND_API.G_EXC_ERROR;

Line 1393: RAISE FND_API.G_EXC_ERROR;

1389: RAISE FND_API.G_EXC_ERROR;
1390: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1392: FND_MSG_PUB.ADD;
1393: RAISE FND_API.G_EXC_ERROR;
1394: else
1395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1397: FND_MSG_PUB.ADD;

Line 1398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1394: else
1395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1397: FND_MSG_PUB.ADD;
1398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1399: end if;
1400: END;
1401:
1402: PROCEDURE open_contact_cursor(

Line 1532: RAISE FND_API.G_EXC_ERROR;

1528: when others then
1529: if (instrb(SQLERRM,'DRG-51030')>0) then
1530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;
1533: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1534: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1535: FND_MSG_PUB.ADD;
1536: RAISE FND_API.G_EXC_ERROR;

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532: RAISE FND_API.G_EXC_ERROR;
1533: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1534: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1535: FND_MSG_PUB.ADD;
1536: RAISE FND_API.G_EXC_ERROR;
1537: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: RAISE FND_API.G_EXC_ERROR;
1537: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: else
1542: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1544: FND_MSG_PUB.ADD;

Line 1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1541: else
1542: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546: end if;
1547: END;
1548:
1549: PROCEDURE open_contact_pt_cursor(

Line 1805: RAISE FND_API.G_EXC_ERROR;

1801: when others then
1802: if (instrb(SQLERRM,'DRG-51030')>0) then
1803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1804: FND_MSG_PUB.ADD;
1805: RAISE FND_API.G_EXC_ERROR;
1806: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1808: FND_MSG_PUB.ADD;
1809: RAISE FND_API.G_EXC_ERROR;

Line 1809: RAISE FND_API.G_EXC_ERROR;

1805: RAISE FND_API.G_EXC_ERROR;
1806: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1808: FND_MSG_PUB.ADD;
1809: RAISE FND_API.G_EXC_ERROR;
1810: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1811: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1812: FND_MSG_PUB.ADD;
1813: RAISE FND_API.G_EXC_ERROR;

Line 1813: RAISE FND_API.G_EXC_ERROR;

1809: RAISE FND_API.G_EXC_ERROR;
1810: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1811: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1812: FND_MSG_PUB.ADD;
1813: RAISE FND_API.G_EXC_ERROR;
1814: else
1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1817: FND_MSG_PUB.ADD;

Line 1818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1814: else
1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1819: end if;
1820: END;
1821:
1822:

Line 2066: RAISE FND_API.G_EXC_ERROR;

2062: 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);
2063: END IF;
2064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2065: FND_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2067: ELSE
2068: push_eval;
2069: RETURN;
2070: END IF;

Line 2114: RAISE FND_API.G_EXC_ERROR;

2110: 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);
2111: END IF;
2112: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2113: FND_MSG_PUB.ADD;
2114: RAISE FND_API.G_EXC_ERROR;
2115: ELSE
2116: push_eval;
2117: RETURN;
2118: END IF;

Line 2187: RAISE FND_API.G_EXC_ERROR;

2183: 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);
2184: END IF;
2185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2186: FND_MSG_PUB.ADD;
2187: RAISE FND_API.G_EXC_ERROR;
2188: ELSE
2189: push_eval;
2190: RETURN;
2191: END IF;

Line 2299: RAISE FND_API.G_EXC_ERROR;

2295: 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);
2296: END IF;
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2298: FND_MSG_PUB.ADD;
2299: RAISE FND_API.G_EXC_ERROR;
2300: ELSE
2301: push_eval;
2302: RETURN;
2303: END IF;

Line 2410: RAISE FND_API.G_EXC_ERROR;

2406: 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);
2407: END IF;
2408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2409: FND_MSG_PUB.ADD;
2410: RAISE FND_API.G_EXC_ERROR;
2411: ELSE
2412: push_eval;
2413: RETURN;
2414: END IF;

Line 2554: RAISE FND_API.G_EXC_ERROR;

2550: 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);
2551: END IF;
2552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2553: FND_MSG_PUB.ADD;
2554: RAISE FND_API.G_EXC_ERROR;
2555: END IF;
2556: ELSE
2557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2558: 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 2562: RAISE FND_API.G_EXC_ERROR;

2558: 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);
2559: END IF;
2560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2561: FND_MSG_PUB.ADD;
2562: RAISE FND_API.G_EXC_ERROR;
2563: END IF;
2564: END IF;
2565: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2566: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2804: WHEN FND_API.G_EXC_ERROR THEN

2800: END IF;
2801: EXCEPTION
2802: WHEN L_RETURN_IMM_EXC THEN
2803: RETURN;
2804: WHEN FND_API.G_EXC_ERROR THEN
2805: RAISE FND_API.G_EXC_ERROR;
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: WHEN OTHERS THEN

Line 2805: RAISE FND_API.G_EXC_ERROR;

2801: EXCEPTION
2802: WHEN L_RETURN_IMM_EXC THEN
2803: RETURN;
2804: WHEN FND_API.G_EXC_ERROR THEN
2805: RAISE FND_API.G_EXC_ERROR;
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: WHEN OTHERS THEN
2809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2802: WHEN L_RETURN_IMM_EXC THEN
2803: RETURN;
2804: WHEN FND_API.G_EXC_ERROR THEN
2805: RAISE FND_API.G_EXC_ERROR;
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: WHEN OTHERS THEN
2809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2810: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');

Line 2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2803: RETURN;
2804: WHEN FND_API.G_EXC_ERROR THEN
2805: RAISE FND_API.G_EXC_ERROR;
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: WHEN OTHERS THEN
2809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2810: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');
2811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2810: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');
2811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2812: FND_MSG_PUB.ADD;
2813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2814: END find_parties;
2815:
2816: PROCEDURE find_persons (
2817: p_rule_id IN NUMBER,

Line 3001: RAISE FND_API.G_EXC_ERROR;

2997: 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);
2998: END IF;
2999: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSE
3003: push_eval;
3004: RETURN;
3005: END IF;

Line 3049: RAISE FND_API.G_EXC_ERROR;

3045: 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);
3046: END IF;
3047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3048: FND_MSG_PUB.ADD;
3049: RAISE FND_API.G_EXC_ERROR;
3050: ELSE
3051: push_eval;
3052: RETURN;
3053: END IF;

Line 3085: RAISE FND_API.G_EXC_ERROR;

3081: when others then
3082: if (instrb(SQLERRM,'DRG-51030')>0) then
3083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3084: FND_MSG_PUB.ADD;
3085: RAISE FND_API.G_EXC_ERROR;
3086: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_ERROR;

Line 3089: RAISE FND_API.G_EXC_ERROR;

3085: RAISE FND_API.G_EXC_ERROR;
3086: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_ERROR;
3090: else
3091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3092: end if;
3093: END;

Line 3091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_ERROR;
3090: else
3091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3092: end if;
3093: END;
3094:
3095: /** Private procedure to acquire and score at party site level ***/

Line 3161: RAISE FND_API.G_EXC_ERROR;

3157: 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);
3158: END IF;
3159: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3160: FND_MSG_PUB.ADD;
3161: RAISE FND_API.G_EXC_ERROR;
3162: ELSE
3163: push_eval;
3164: RETURN;
3165: END IF;

Line 3350: RAISE FND_API.G_EXC_ERROR;

3346: 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);
3347: END IF;
3348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: ELSE
3352: push_eval;
3353: RETURN;
3354: END IF;

Line 3438: RAISE FND_API.G_EXC_ERROR;

3434: 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);
3435: END IF;
3436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3437: FND_MSG_PUB.ADD;
3438: RAISE FND_API.G_EXC_ERROR;
3439: END IF;
3440: ELSE
3441: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3442: 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 3446: RAISE FND_API.G_EXC_ERROR;

3442: 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);
3443: END IF;
3444: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3445: FND_MSG_PUB.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: END IF;
3448: END IF;
3449: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3450: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3586: WHEN FND_API.G_EXC_ERROR THEN

3582: END IF;
3583: EXCEPTION
3584: WHEN L_RETURN_IMM_EXC THEN
3585: RETURN;
3586: WHEN FND_API.G_EXC_ERROR THEN
3587: RAISE FND_API.G_EXC_ERROR;
3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3590: WHEN OTHERS THEN

Line 3587: RAISE FND_API.G_EXC_ERROR;

3583: EXCEPTION
3584: WHEN L_RETURN_IMM_EXC THEN
3585: RETURN;
3586: WHEN FND_API.G_EXC_ERROR THEN
3587: RAISE FND_API.G_EXC_ERROR;
3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3590: WHEN OTHERS THEN
3591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3584: WHEN L_RETURN_IMM_EXC THEN
3585: RETURN;
3586: WHEN FND_API.G_EXC_ERROR THEN
3587: RAISE FND_API.G_EXC_ERROR;
3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3590: WHEN OTHERS THEN
3591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');

Line 3589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3585: RETURN;
3586: WHEN FND_API.G_EXC_ERROR THEN
3587: RAISE FND_API.G_EXC_ERROR;
3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3590: WHEN OTHERS THEN
3591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3594: FND_MSG_PUB.ADD;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: END find_persons;
3597:
3598: PROCEDURE find_persons (
3599: p_rule_id IN NUMBER,

Line 3654: WHEN FND_API.G_EXC_ERROR THEN

3650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3651: 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);
3652: END IF;
3653: EXCEPTION
3654: WHEN FND_API.G_EXC_ERROR THEN
3655: RAISE FND_API.G_EXC_ERROR;
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: WHEN OTHERS THEN

Line 3655: RAISE FND_API.G_EXC_ERROR;

3651: 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);
3652: END IF;
3653: EXCEPTION
3654: WHEN FND_API.G_EXC_ERROR THEN
3655: RAISE FND_API.G_EXC_ERROR;
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: WHEN OTHERS THEN
3659: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3652: END IF;
3653: EXCEPTION
3654: WHEN FND_API.G_EXC_ERROR THEN
3655: RAISE FND_API.G_EXC_ERROR;
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: WHEN OTHERS THEN
3659: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3660: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');

Line 3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3653: EXCEPTION
3654: WHEN FND_API.G_EXC_ERROR THEN
3655: RAISE FND_API.G_EXC_ERROR;
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: WHEN OTHERS THEN
3659: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3660: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3661: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3659: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3660: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3661: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3662: FND_MSG_PUB.ADD;
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END find_party_details;
3665:
3666: PROCEDURE find_duplicate_parties (
3667: p_rule_id IN NUMBER,

Line 3771: WHEN FND_API.G_EXC_ERROR THEN

3767: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3768: 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);
3769: END IF;
3770: EXCEPTION
3771: WHEN FND_API.G_EXC_ERROR THEN
3772: RAISE FND_API.G_EXC_ERROR;
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3775: WHEN OTHERS THEN

Line 3772: RAISE FND_API.G_EXC_ERROR;

3768: 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);
3769: END IF;
3770: EXCEPTION
3771: WHEN FND_API.G_EXC_ERROR THEN
3772: RAISE FND_API.G_EXC_ERROR;
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3775: WHEN OTHERS THEN
3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3769: END IF;
3770: EXCEPTION
3771: WHEN FND_API.G_EXC_ERROR THEN
3772: RAISE FND_API.G_EXC_ERROR;
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3775: WHEN OTHERS THEN
3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3777: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');

Line 3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3770: EXCEPTION
3771: WHEN FND_API.G_EXC_ERROR THEN
3772: RAISE FND_API.G_EXC_ERROR;
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3775: WHEN OTHERS THEN
3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3777: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3778: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3777: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3778: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3779: FND_MSG_PUB.ADD;
3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3781: END find_duplicate_parties;
3782:
3783: PROCEDURE find_duplicate_party_sites (
3784: p_rule_id IN NUMBER,

Line 3856: WHEN FND_API.G_EXC_ERROR THEN

3852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3853: 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);
3854: END IF;
3855: EXCEPTION
3856: WHEN FND_API.G_EXC_ERROR THEN
3857: RAISE FND_API.G_EXC_ERROR;
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3860: WHEN OTHERS THEN

Line 3857: RAISE FND_API.G_EXC_ERROR;

3853: 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);
3854: END IF;
3855: EXCEPTION
3856: WHEN FND_API.G_EXC_ERROR THEN
3857: RAISE FND_API.G_EXC_ERROR;
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3860: WHEN OTHERS THEN
3861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3854: END IF;
3855: EXCEPTION
3856: WHEN FND_API.G_EXC_ERROR THEN
3857: RAISE FND_API.G_EXC_ERROR;
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3860: WHEN OTHERS THEN
3861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3862: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');

Line 3859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3855: EXCEPTION
3856: WHEN FND_API.G_EXC_ERROR THEN
3857: RAISE FND_API.G_EXC_ERROR;
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3860: WHEN OTHERS THEN
3861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3862: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');
3863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3862: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');
3863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3864: FND_MSG_PUB.ADD;
3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3866: END find_duplicate_party_sites;
3867:
3868: PROCEDURE find_duplicate_contacts (
3869: p_rule_id IN NUMBER,

Line 3945: WHEN FND_API.G_EXC_ERROR THEN

3941: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3942: 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);
3943: END IF;
3944: EXCEPTION
3945: WHEN FND_API.G_EXC_ERROR THEN
3946: RAISE FND_API.G_EXC_ERROR;
3947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3949: WHEN OTHERS THEN

Line 3946: RAISE FND_API.G_EXC_ERROR;

3942: 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);
3943: END IF;
3944: EXCEPTION
3945: WHEN FND_API.G_EXC_ERROR THEN
3946: RAISE FND_API.G_EXC_ERROR;
3947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3949: WHEN OTHERS THEN
3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3943: END IF;
3944: EXCEPTION
3945: WHEN FND_API.G_EXC_ERROR THEN
3946: RAISE FND_API.G_EXC_ERROR;
3947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3949: WHEN OTHERS THEN
3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');

Line 3948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3944: EXCEPTION
3945: WHEN FND_API.G_EXC_ERROR THEN
3946: RAISE FND_API.G_EXC_ERROR;
3947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3949: WHEN OTHERS THEN
3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3953: FND_MSG_PUB.ADD;
3954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3955: END find_duplicate_contacts;
3956:
3957: PROCEDURE find_duplicate_contact_points (
3958: p_rule_id IN NUMBER,

Line 4018: WHEN FND_API.G_EXC_ERROR THEN

4014: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4015: 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);
4016: END IF;
4017: EXCEPTION
4018: WHEN FND_API.G_EXC_ERROR THEN
4019: RAISE FND_API.G_EXC_ERROR;
4020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4022: WHEN OTHERS THEN

Line 4019: RAISE FND_API.G_EXC_ERROR;

4015: 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);
4016: END IF;
4017: EXCEPTION
4018: WHEN FND_API.G_EXC_ERROR THEN
4019: RAISE FND_API.G_EXC_ERROR;
4020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4022: WHEN OTHERS THEN
4023: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4016: END IF;
4017: EXCEPTION
4018: WHEN FND_API.G_EXC_ERROR THEN
4019: RAISE FND_API.G_EXC_ERROR;
4020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4022: WHEN OTHERS THEN
4023: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4024: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');

Line 4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4017: EXCEPTION
4018: WHEN FND_API.G_EXC_ERROR THEN
4019: RAISE FND_API.G_EXC_ERROR;
4020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4022: WHEN OTHERS THEN
4023: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4024: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4025: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4023: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4024: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4025: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4026: FND_MSG_PUB.ADD;
4027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4028: END find_duplicate_contact_points;
4029:
4030: PROCEDURE find_parties_dynamic (
4031: p_rule_id IN NUMBER,

Line 4278: WHEN FND_API.G_EXC_ERROR THEN

4274: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4275: 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);
4276: END IF;
4277: EXCEPTION
4278: WHEN FND_API.G_EXC_ERROR THEN
4279: RAISE FND_API.G_EXC_ERROR;
4280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4282: WHEN OTHERS THEN

Line 4279: RAISE FND_API.G_EXC_ERROR;

4275: 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);
4276: END IF;
4277: EXCEPTION
4278: WHEN FND_API.G_EXC_ERROR THEN
4279: RAISE FND_API.G_EXC_ERROR;
4280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4282: WHEN OTHERS THEN
4283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4276: END IF;
4277: EXCEPTION
4278: WHEN FND_API.G_EXC_ERROR THEN
4279: RAISE FND_API.G_EXC_ERROR;
4280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4282: WHEN OTHERS THEN
4283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4284: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');

Line 4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4277: EXCEPTION
4278: WHEN FND_API.G_EXC_ERROR THEN
4279: RAISE FND_API.G_EXC_ERROR;
4280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4282: WHEN OTHERS THEN
4283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4284: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4285: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4284: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4285: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4286: FND_MSG_PUB.ADD;
4287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4288: END call_api_dynamic;
4289:
4290:
4291: PROCEDURE get_matching_party_sites (

Line 4512: WHEN FND_API.G_EXC_ERROR THEN

4508: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4509: 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);
4510: END IF;
4511: EXCEPTION
4512: WHEN FND_API.G_EXC_ERROR THEN
4513: RAISE FND_API.G_EXC_ERROR;
4514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4516: WHEN OTHERS THEN

Line 4513: RAISE FND_API.G_EXC_ERROR;

4509: 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);
4510: END IF;
4511: EXCEPTION
4512: WHEN FND_API.G_EXC_ERROR THEN
4513: RAISE FND_API.G_EXC_ERROR;
4514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4516: WHEN OTHERS THEN
4517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4510: END IF;
4511: EXCEPTION
4512: WHEN FND_API.G_EXC_ERROR THEN
4513: RAISE FND_API.G_EXC_ERROR;
4514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4516: WHEN OTHERS THEN
4517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4518: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');

Line 4515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4511: EXCEPTION
4512: WHEN FND_API.G_EXC_ERROR THEN
4513: RAISE FND_API.G_EXC_ERROR;
4514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4516: WHEN OTHERS THEN
4517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4518: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4519: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4518: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4519: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4520: FND_MSG_PUB.ADD;
4521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4522: END get_matching_party_sites;
4523:
4524:
4525: PROCEDURE get_matching_contacts (

Line 4737: WHEN FND_API.G_EXC_ERROR THEN

4733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4734: 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);
4735: END IF;
4736: EXCEPTION
4737: WHEN FND_API.G_EXC_ERROR THEN
4738: RAISE FND_API.G_EXC_ERROR;
4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4741: WHEN OTHERS THEN

Line 4738: RAISE FND_API.G_EXC_ERROR;

4734: 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);
4735: END IF;
4736: EXCEPTION
4737: WHEN FND_API.G_EXC_ERROR THEN
4738: RAISE FND_API.G_EXC_ERROR;
4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4741: WHEN OTHERS THEN
4742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4735: END IF;
4736: EXCEPTION
4737: WHEN FND_API.G_EXC_ERROR THEN
4738: RAISE FND_API.G_EXC_ERROR;
4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4741: WHEN OTHERS THEN
4742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4743: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');

Line 4740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4736: EXCEPTION
4737: WHEN FND_API.G_EXC_ERROR THEN
4738: RAISE FND_API.G_EXC_ERROR;
4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4741: WHEN OTHERS THEN
4742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4743: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4744: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4743: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4744: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4745: FND_MSG_PUB.ADD;
4746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4747: END get_matching_contacts;
4748:
4749:
4750: PROCEDURE get_matching_contact_points (

Line 4876: WHEN FND_API.G_EXC_ERROR THEN

4872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4873: 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);
4874: END IF;
4875: EXCEPTION
4876: WHEN FND_API.G_EXC_ERROR THEN
4877: RAISE FND_API.G_EXC_ERROR;
4878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4880: WHEN OTHERS THEN

Line 4877: RAISE FND_API.G_EXC_ERROR;

4873: 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);
4874: END IF;
4875: EXCEPTION
4876: WHEN FND_API.G_EXC_ERROR THEN
4877: RAISE FND_API.G_EXC_ERROR;
4878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4874: END IF;
4875: EXCEPTION
4876: WHEN FND_API.G_EXC_ERROR THEN
4877: RAISE FND_API.G_EXC_ERROR;
4878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');

Line 4879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4875: EXCEPTION
4876: WHEN FND_API.G_EXC_ERROR THEN
4877: RAISE FND_API.G_EXC_ERROR;
4878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4884: FND_MSG_PUB.ADD;
4885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4886: END get_matching_contact_points;
4887:
4888: /**********************************************************
4889: This procedure finds the score details for a specific party that

Line 5075: WHEN FND_API.G_EXC_ERROR THEN

5071: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5072: 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);
5073: END IF;
5074: EXCEPTION
5075: WHEN FND_API.G_EXC_ERROR THEN
5076: RAISE FND_API.G_EXC_ERROR;
5077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5079: WHEN OTHERS THEN

Line 5076: RAISE FND_API.G_EXC_ERROR;

5072: 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);
5073: END IF;
5074: EXCEPTION
5075: WHEN FND_API.G_EXC_ERROR THEN
5076: RAISE FND_API.G_EXC_ERROR;
5077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5079: WHEN OTHERS THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5073: END IF;
5074: EXCEPTION
5075: WHEN FND_API.G_EXC_ERROR THEN
5076: RAISE FND_API.G_EXC_ERROR;
5077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5079: WHEN OTHERS THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');

Line 5078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5074: EXCEPTION
5075: WHEN FND_API.G_EXC_ERROR THEN
5076: RAISE FND_API.G_EXC_ERROR;
5077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5079: WHEN OTHERS THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5080: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5083: FND_MSG_PUB.ADD;
5084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5085: END get_score_details;
5086:
5087:
5088: /************************************************

Line 5153: WHEN FND_API.G_EXC_ERROR THEN

5149: END LOOP;
5150: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5151: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
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: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5151: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
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: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
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','get_party_for_search');

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','get_party_for_search');
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','get_party_for_search');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5163: END get_party_for_search;
5164:
5165: PROCEDURE get_search_criteria (
5166: p_party_id IN NUMBER,

Line 5193: WHEN FND_API.G_EXC_ERROR THEN

5189: END IF;
5190: get_party_site_rec(p_party_site_ids, x_party_site_list);
5191: END IF;
5192: EXCEPTION
5193: WHEN FND_API.G_EXC_ERROR THEN
5194: RAISE FND_API.G_EXC_ERROR;
5195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: WHEN OTHERS THEN

Line 5194: RAISE FND_API.G_EXC_ERROR;

5190: get_party_site_rec(p_party_site_ids, x_party_site_list);
5191: END IF;
5192: EXCEPTION
5193: WHEN FND_API.G_EXC_ERROR THEN
5194: RAISE FND_API.G_EXC_ERROR;
5195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: WHEN OTHERS THEN
5198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5191: END IF;
5192: EXCEPTION
5193: WHEN FND_API.G_EXC_ERROR THEN
5194: RAISE FND_API.G_EXC_ERROR;
5195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: WHEN OTHERS THEN
5198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5199: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5192: EXCEPTION
5193: WHEN FND_API.G_EXC_ERROR THEN
5194: RAISE FND_API.G_EXC_ERROR;
5195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: WHEN OTHERS THEN
5198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5199: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5199: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5201: FND_MSG_PUB.ADD;
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: END get_search_criteria;
5204:
5205:
5206: /************************************************

Line 5263: RAISE FND_API.G_EXC_ERROR;

5259: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5260: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_ERROR;
5264: END get_party_rec;
5265:
5266: /************************************************
5267: This procedure retrieves the match rule party site attributes into

Line 5319: RAISE FND_API.G_EXC_ERROR;

5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;
5320: END get_party_site_rec;
5321:
5322: /************************************************
5323: This procedure retrieves the match rule contact attributes into

Line 5375: RAISE FND_API.G_EXC_ERROR;

5371: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5372: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5373: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5374: FND_MSG_PUB.ADD;
5375: RAISE FND_API.G_EXC_ERROR;
5376: END get_contact_rec;
5377:
5378: /************************************************
5379: This procedure retrieves the match rule contact point attributes into

Line 5427: RAISE FND_API.G_EXC_ERROR;

5423: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5424: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_ERROR;
5428: END get_contact_point_rec;
5429:
5430: /************************************************
5431: This procedure maps a search record from the logical

Line 5532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5528: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5529: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5531: FND_MSG_PUB.ADD;
5532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5533: END;
5534:
5535:
5536: /************************************************

Line 5647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5643: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5644: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5645: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5646: FND_MSG_PUB.ADD;
5647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5648: END;
5649:
5650:
5651: /************************************************

Line 5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5685: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5686: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: END;
5691:
5692:
5693: /************************************************

Line 5732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5728: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5729: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5730: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5731: FND_MSG_PUB.ADD;
5732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5733: END;
5734:
5735:
5736: /************************************************

Line 5760: WHEN FND_API.G_EXC_ERROR THEN

5756: END IF;
5757: END LOOP;
5758: RETURN FALSE;
5759: EXCEPTION
5760: WHEN FND_API.G_EXC_ERROR THEN
5761: RAISE FND_API.G_EXC_ERROR;
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5761: RAISE FND_API.G_EXC_ERROR;

5757: END LOOP;
5758: RETURN FALSE;
5759: EXCEPTION
5760: WHEN FND_API.G_EXC_ERROR THEN
5761: RAISE FND_API.G_EXC_ERROR;
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5766: FND_MSG_PUB.ADD;
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: END check_prim_cond;
5769:
5770: /************************************************
5771: This procedure checks if the input search condition

Line 5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5808: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5809: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5810: FND_MSG_PUB.ADD;
5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5812: END check_party_site_cond;
5813:
5814: /************************************************
5815: This procedure checks if the input search condition

Line 5849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5846: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5848: FND_MSG_PUB.ADD;
5849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5850: END check_contact_cond;
5851:
5852: /************************************************
5853: This procedure checks if the input search condition

Line 5870: RAISE FND_API.G_EXC_ERROR;

5866: FOR I IN 1..p_contact_point_list.COUNT LOOP
5867: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_ERROR;
5871: END IF;
5872: END LOOP;
5873:
5874: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5882: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5883: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5885: FND_MSG_PUB.ADD;
5886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5887: END check_contact_point_cond;
5888:
5889: FUNCTION check_staged RETURN BOOLEAN IS
5890: