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

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

Line 1142: RAISE FND_API.G_EXC_ERROR;

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

Line 1146: RAISE FND_API.G_EXC_ERROR;

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

Line 1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1383: RAISE FND_API.G_EXC_ERROR;

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

Line 1387: RAISE FND_API.G_EXC_ERROR;

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

Line 1391: RAISE FND_API.G_EXC_ERROR;

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

Line 1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1530: RAISE FND_API.G_EXC_ERROR;

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

Line 1534: RAISE FND_API.G_EXC_ERROR;

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

Line 1538: RAISE FND_API.G_EXC_ERROR;

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

Line 1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1803: RAISE FND_API.G_EXC_ERROR;

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

Line 1807: RAISE FND_API.G_EXC_ERROR;

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

Line 1811: RAISE FND_API.G_EXC_ERROR;

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

Line 1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2063: RAISE FND_API.G_EXC_ERROR;

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

Line 2111: RAISE FND_API.G_EXC_ERROR;

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

Line 2184: RAISE FND_API.G_EXC_ERROR;

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

Line 2296: RAISE FND_API.G_EXC_ERROR;

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

Line 2407: RAISE FND_API.G_EXC_ERROR;

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

Line 2551: RAISE FND_API.G_EXC_ERROR;

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

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

Line 2801: WHEN FND_API.G_EXC_ERROR THEN

2797: END IF;
2798: EXCEPTION
2799: WHEN L_RETURN_IMM_EXC THEN
2800: RETURN;
2801: WHEN FND_API.G_EXC_ERROR THEN
2802: RAISE FND_API.G_EXC_ERROR;
2803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2805: WHEN OTHERS THEN

Line 2802: RAISE FND_API.G_EXC_ERROR;

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

Line 2803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2997: RAISE FND_API.G_EXC_ERROR;

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

Line 3045: RAISE FND_API.G_EXC_ERROR;

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

Line 3081: RAISE FND_API.G_EXC_ERROR;

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

Line 3085: RAISE FND_API.G_EXC_ERROR;

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

Line 3087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3157: RAISE FND_API.G_EXC_ERROR;

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

Line 3346: RAISE FND_API.G_EXC_ERROR;

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

Line 3434: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3582: WHEN FND_API.G_EXC_ERROR THEN

3578: END IF;
3579: EXCEPTION
3580: WHEN L_RETURN_IMM_EXC THEN
3581: RETURN;
3582: WHEN FND_API.G_EXC_ERROR THEN
3583: RAISE FND_API.G_EXC_ERROR;
3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: WHEN OTHERS THEN

Line 3583: RAISE FND_API.G_EXC_ERROR;

3579: EXCEPTION
3580: WHEN L_RETURN_IMM_EXC THEN
3581: RETURN;
3582: WHEN FND_API.G_EXC_ERROR THEN
3583: RAISE FND_API.G_EXC_ERROR;
3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: WHEN OTHERS THEN
3587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3580: WHEN L_RETURN_IMM_EXC THEN
3581: RETURN;
3582: WHEN FND_API.G_EXC_ERROR THEN
3583: RAISE FND_API.G_EXC_ERROR;
3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: WHEN OTHERS THEN
3587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');

Line 3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3581: RETURN;
3582: WHEN FND_API.G_EXC_ERROR THEN
3583: RAISE FND_API.G_EXC_ERROR;
3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: WHEN OTHERS THEN
3587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3650: WHEN FND_API.G_EXC_ERROR THEN

3646: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3647: 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);
3648: END IF;
3649: EXCEPTION
3650: WHEN FND_API.G_EXC_ERROR THEN
3651: RAISE FND_API.G_EXC_ERROR;
3652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3654: WHEN OTHERS THEN

Line 3651: RAISE FND_API.G_EXC_ERROR;

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

Line 3652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3648: END IF;
3649: EXCEPTION
3650: WHEN FND_API.G_EXC_ERROR THEN
3651: RAISE FND_API.G_EXC_ERROR;
3652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3654: WHEN OTHERS THEN
3655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3656: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');

Line 3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3649: EXCEPTION
3650: WHEN FND_API.G_EXC_ERROR THEN
3651: RAISE FND_API.G_EXC_ERROR;
3652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3654: WHEN OTHERS THEN
3655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3656: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3767: WHEN FND_API.G_EXC_ERROR THEN

3763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3764: 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);
3765: END IF;
3766: EXCEPTION
3767: WHEN FND_API.G_EXC_ERROR THEN
3768: RAISE FND_API.G_EXC_ERROR;
3769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3771: WHEN OTHERS THEN

Line 3768: RAISE FND_API.G_EXC_ERROR;

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

Line 3769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3765: END IF;
3766: EXCEPTION
3767: WHEN FND_API.G_EXC_ERROR THEN
3768: RAISE FND_API.G_EXC_ERROR;
3769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3771: WHEN OTHERS THEN
3772: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3773: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');

Line 3770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3766: EXCEPTION
3767: WHEN FND_API.G_EXC_ERROR THEN
3768: RAISE FND_API.G_EXC_ERROR;
3769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3771: WHEN OTHERS THEN
3772: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3773: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3852: WHEN FND_API.G_EXC_ERROR THEN

3848: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3849: 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);
3850: END IF;
3851: EXCEPTION
3852: WHEN FND_API.G_EXC_ERROR THEN
3853: RAISE FND_API.G_EXC_ERROR;
3854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: WHEN OTHERS THEN

Line 3853: RAISE FND_API.G_EXC_ERROR;

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

Line 3854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3850: END IF;
3851: EXCEPTION
3852: WHEN FND_API.G_EXC_ERROR THEN
3853: RAISE FND_API.G_EXC_ERROR;
3854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: WHEN OTHERS THEN
3857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3858: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');

Line 3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3851: EXCEPTION
3852: WHEN FND_API.G_EXC_ERROR THEN
3853: RAISE FND_API.G_EXC_ERROR;
3854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: WHEN OTHERS THEN
3857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3858: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');
3859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3941: WHEN FND_API.G_EXC_ERROR THEN

3937: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3938: 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);
3939: END IF;
3940: EXCEPTION
3941: WHEN FND_API.G_EXC_ERROR THEN
3942: RAISE FND_API.G_EXC_ERROR;
3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: WHEN OTHERS THEN

Line 3942: RAISE FND_API.G_EXC_ERROR;

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

Line 3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3939: END IF;
3940: EXCEPTION
3941: WHEN FND_API.G_EXC_ERROR THEN
3942: RAISE FND_API.G_EXC_ERROR;
3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: WHEN OTHERS THEN
3946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3947: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');

Line 3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3940: EXCEPTION
3941: WHEN FND_API.G_EXC_ERROR THEN
3942: RAISE FND_API.G_EXC_ERROR;
3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: WHEN OTHERS THEN
3946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3947: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3948: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4014: WHEN FND_API.G_EXC_ERROR THEN

4010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4011: 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);
4012: END IF;
4013: EXCEPTION
4014: WHEN FND_API.G_EXC_ERROR THEN
4015: RAISE FND_API.G_EXC_ERROR;
4016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4018: WHEN OTHERS THEN

Line 4015: RAISE FND_API.G_EXC_ERROR;

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

Line 4016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4012: END IF;
4013: EXCEPTION
4014: WHEN FND_API.G_EXC_ERROR THEN
4015: RAISE FND_API.G_EXC_ERROR;
4016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4018: WHEN OTHERS THEN
4019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4020: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');

Line 4017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4013: EXCEPTION
4014: WHEN FND_API.G_EXC_ERROR THEN
4015: RAISE FND_API.G_EXC_ERROR;
4016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4018: WHEN OTHERS THEN
4019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4020: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4274: WHEN FND_API.G_EXC_ERROR THEN

4270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4271: 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);
4272: END IF;
4273: EXCEPTION
4274: WHEN FND_API.G_EXC_ERROR THEN
4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN

Line 4275: RAISE FND_API.G_EXC_ERROR;

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

Line 4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4272: END IF;
4273: EXCEPTION
4274: WHEN FND_API.G_EXC_ERROR THEN
4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');

Line 4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4273: EXCEPTION
4274: WHEN FND_API.G_EXC_ERROR THEN
4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4284: END call_api_dynamic;
4285:
4286:
4287: PROCEDURE get_matching_party_sites (

Line 4508: WHEN FND_API.G_EXC_ERROR THEN

4504: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4505: 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);
4506: END IF;
4507: EXCEPTION
4508: WHEN FND_API.G_EXC_ERROR THEN
4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN

Line 4509: RAISE FND_API.G_EXC_ERROR;

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

Line 4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4506: END IF;
4507: EXCEPTION
4508: WHEN FND_API.G_EXC_ERROR THEN
4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');

Line 4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4507: EXCEPTION
4508: WHEN FND_API.G_EXC_ERROR THEN
4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4518: END get_matching_party_sites;
4519:
4520:
4521: PROCEDURE get_matching_contacts (

Line 4733: WHEN FND_API.G_EXC_ERROR THEN

4729: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4730: 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);
4731: END IF;
4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN

Line 4734: RAISE FND_API.G_EXC_ERROR;

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

Line 4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4731: END IF;
4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');

Line 4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4743: END get_matching_contacts;
4744:
4745:
4746: PROCEDURE get_matching_contact_points (

Line 4872: WHEN FND_API.G_EXC_ERROR THEN

4868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4869: 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);
4870: END IF;
4871: EXCEPTION
4872: WHEN FND_API.G_EXC_ERROR THEN
4873: RAISE FND_API.G_EXC_ERROR;
4874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4876: WHEN OTHERS THEN

Line 4873: RAISE FND_API.G_EXC_ERROR;

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

Line 4874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4870: END IF;
4871: EXCEPTION
4872: WHEN FND_API.G_EXC_ERROR THEN
4873: RAISE FND_API.G_EXC_ERROR;
4874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4876: WHEN OTHERS THEN
4877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4878: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');

Line 4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4871: EXCEPTION
4872: WHEN FND_API.G_EXC_ERROR THEN
4873: RAISE FND_API.G_EXC_ERROR;
4874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4876: WHEN OTHERS THEN
4877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4878: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5070: WHEN FND_API.G_EXC_ERROR THEN

5066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5067: 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);
5068: END IF;
5069: EXCEPTION
5070: WHEN FND_API.G_EXC_ERROR THEN
5071: RAISE FND_API.G_EXC_ERROR;
5072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5074: WHEN OTHERS THEN

Line 5071: RAISE FND_API.G_EXC_ERROR;

5067: 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);
5068: END IF;
5069: EXCEPTION
5070: WHEN FND_API.G_EXC_ERROR THEN
5071: RAISE FND_API.G_EXC_ERROR;
5072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5074: WHEN OTHERS THEN
5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5068: END IF;
5069: EXCEPTION
5070: WHEN FND_API.G_EXC_ERROR THEN
5071: RAISE FND_API.G_EXC_ERROR;
5072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5074: WHEN OTHERS THEN
5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5076: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');

Line 5073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5069: EXCEPTION
5070: WHEN FND_API.G_EXC_ERROR THEN
5071: RAISE FND_API.G_EXC_ERROR;
5072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5074: WHEN OTHERS THEN
5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5076: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5076: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5078: FND_MSG_PUB.ADD;
5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5080: END get_score_details;
5081:
5082:
5083: /************************************************

Line 5148: WHEN FND_API.G_EXC_ERROR THEN

5144: END LOOP;
5145: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5146: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5147: EXCEPTION
5148: WHEN FND_API.G_EXC_ERROR THEN
5149: RAISE FND_API.G_EXC_ERROR;
5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: WHEN OTHERS THEN

Line 5149: RAISE FND_API.G_EXC_ERROR;

5145: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5146: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5147: EXCEPTION
5148: WHEN FND_API.G_EXC_ERROR THEN
5149: RAISE FND_API.G_EXC_ERROR;
5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: WHEN OTHERS THEN
5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5146: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5147: EXCEPTION
5148: WHEN FND_API.G_EXC_ERROR THEN
5149: RAISE FND_API.G_EXC_ERROR;
5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: WHEN OTHERS THEN
5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5154: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5147: EXCEPTION
5148: WHEN FND_API.G_EXC_ERROR THEN
5149: RAISE FND_API.G_EXC_ERROR;
5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: WHEN OTHERS THEN
5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5154: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5154: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5156: FND_MSG_PUB.ADD;
5157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5158: END get_party_for_search;
5159:
5160: PROCEDURE get_search_criteria (
5161: p_party_id IN NUMBER,

Line 5188: WHEN FND_API.G_EXC_ERROR THEN

5184: END IF;
5185: get_party_site_rec(p_party_site_ids, x_party_site_list);
5186: END IF;
5187: EXCEPTION
5188: WHEN FND_API.G_EXC_ERROR THEN
5189: RAISE FND_API.G_EXC_ERROR;
5190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5192: WHEN OTHERS THEN

Line 5189: RAISE FND_API.G_EXC_ERROR;

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

Line 5190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5194: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5196: FND_MSG_PUB.ADD;
5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5198: END get_search_criteria;
5199:
5200:
5201: /************************************************

Line 5258: RAISE FND_API.G_EXC_ERROR;

5254: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5255: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5257: FND_MSG_PUB.ADD;
5258: RAISE FND_API.G_EXC_ERROR;
5259: END get_party_rec;
5260:
5261: /************************************************
5262: This procedure retrieves the match rule party site attributes into

Line 5314: RAISE FND_API.G_EXC_ERROR;

5310: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5311: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5312: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5313: FND_MSG_PUB.ADD;
5314: RAISE FND_API.G_EXC_ERROR;
5315: END get_party_site_rec;
5316:
5317: /************************************************
5318: This procedure retrieves the match rule contact attributes into

Line 5370: RAISE FND_API.G_EXC_ERROR;

5366: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5367: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5369: FND_MSG_PUB.ADD;
5370: RAISE FND_API.G_EXC_ERROR;
5371: END get_contact_rec;
5372:
5373: /************************************************
5374: This procedure retrieves the match rule contact point attributes into

Line 5422: RAISE FND_API.G_EXC_ERROR;

5418: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5419: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5421: FND_MSG_PUB.ADD;
5422: RAISE FND_API.G_EXC_ERROR;
5423: END get_contact_point_rec;
5424:
5425: /************************************************
5426: This procedure maps a search record from the logical

Line 5527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5523: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5524: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5526: FND_MSG_PUB.ADD;
5527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5528: END;
5529:
5530:
5531: /************************************************

Line 5642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5641: FND_MSG_PUB.ADD;
5642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5643: END;
5644:
5645:
5646: /************************************************

Line 5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5683: FND_MSG_PUB.ADD;
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: END;
5686:
5687:
5688: /************************************************

Line 5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END;
5729:
5730:
5731: /************************************************

Line 5755: WHEN FND_API.G_EXC_ERROR THEN

5751: END IF;
5752: END LOOP;
5753: RETURN FALSE;
5754: EXCEPTION
5755: WHEN FND_API.G_EXC_ERROR THEN
5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN OTHERS THEN
5758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5759: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5756: RAISE FND_API.G_EXC_ERROR;

5752: END LOOP;
5753: RETURN FALSE;
5754: EXCEPTION
5755: WHEN FND_API.G_EXC_ERROR THEN
5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN OTHERS THEN
5758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5759: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5759: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: END check_prim_cond;
5764:
5765: /************************************************
5766: This procedure checks if the input search condition

Line 5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5807: END check_party_site_cond;
5808:
5809: /************************************************
5810: This procedure checks if the input search condition

Line 5844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5841: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5843: FND_MSG_PUB.ADD;
5844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5845: END check_contact_cond;
5846:
5847: /************************************************
5848: This procedure checks if the input search condition

Line 5865: RAISE FND_API.G_EXC_ERROR;

5861: FOR I IN 1..p_contact_point_list.COUNT LOOP
5862: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5863: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END IF;
5867: END LOOP;
5868:
5869: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5878: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5880: FND_MSG_PUB.ADD;
5881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5882: END check_contact_point_cond;
5883:
5884: FUNCTION check_staged RETURN BOOLEAN IS
5885: