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_238 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 638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

634: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
635: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END;
640:
641:
642: /************************************************

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

654: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
655: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
657: FND_MSG_PUB.ADD;
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END;
660:
661:
662: /************************************************

Line 678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

674: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
675: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END;
680:
681:
682: /************************************************

Line 698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

694: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
695: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END;
700:
701: PROCEDURE init_score_context (
702: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 765: RAISE FND_API.G_EXC_ERROR;

761: p_contact_list,
762: p_contact_point_list) THEN
763: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
764: FND_MSG_PUB.ADD;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
768: 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);
769: END IF;

Line 1017: RAISE FND_API.G_EXC_ERROR;

1013: IF lengthb(l_party_contains_str) > 4000 THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1015: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1016: FND_MSG_PUB.ADD;
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019: IF (p_match_str = ' AND ' OR p_party_max_score 1020: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1021: 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 1086: RAISE FND_API.G_EXC_ERROR;

1082: IF lengthb(l_contains_str) > 4000 THEN
1083: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1084: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1085: FND_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_ERROR;
1087: END IF;
1088: x_denorm_str := l_den_contains_str;
1089: RETURN l_contains_str;
1090: END;

Line 1176: RAISE FND_API.G_EXC_ERROR;

1172: IF lengthb(l_contains_str) > 4000 THEN
1173: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1174: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1175: FND_MSG_PUB.ADD;
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: x_denorm_str := l_den_contains_str;
1179: RETURN l_contains_str;
1180: END;

Line 1403: RAISE FND_API.G_EXC_ERROR;

1399: when others then
1400: if (instrb(SQLERRM,'DRG-51030')>0) then
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1406: FND_MSG_PUB.ADD;
1407: RAISE FND_API.G_EXC_ERROR;

Line 1407: RAISE FND_API.G_EXC_ERROR;

1403: RAISE FND_API.G_EXC_ERROR;
1404: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1406: FND_MSG_PUB.ADD;
1407: RAISE FND_API.G_EXC_ERROR;
1408: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1410: FND_MSG_PUB.ADD;
1411: RAISE FND_API.G_EXC_ERROR;

Line 1411: RAISE FND_API.G_EXC_ERROR;

1407: RAISE FND_API.G_EXC_ERROR;
1408: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1410: FND_MSG_PUB.ADD;
1411: RAISE FND_API.G_EXC_ERROR;
1412: else
1413: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;

Line 1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1412: else
1413: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1417: end if;
1418: END;
1419:
1420: PROCEDURE open_party_site_cursor(

Line 1648: RAISE FND_API.G_EXC_ERROR;

1644: when others then
1645: if (instrb(SQLERRM,'DRG-51030')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1651: FND_MSG_PUB.ADD;
1652: RAISE FND_API.G_EXC_ERROR;

Line 1652: RAISE FND_API.G_EXC_ERROR;

1648: RAISE FND_API.G_EXC_ERROR;
1649: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1651: FND_MSG_PUB.ADD;
1652: RAISE FND_API.G_EXC_ERROR;
1653: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1655: FND_MSG_PUB.ADD;
1656: RAISE FND_API.G_EXC_ERROR;

Line 1656: RAISE FND_API.G_EXC_ERROR;

1652: RAISE FND_API.G_EXC_ERROR;
1653: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1655: FND_MSG_PUB.ADD;
1656: RAISE FND_API.G_EXC_ERROR;
1657: else
1658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1659: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1660: FND_MSG_PUB.ADD;

Line 1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1657: else
1658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1659: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1660: FND_MSG_PUB.ADD;
1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1662: end if;
1663: END;
1664:
1665: PROCEDURE open_contact_cursor(

Line 1795: RAISE FND_API.G_EXC_ERROR;

1791: when others then
1792: if (instrb(SQLERRM,'DRG-51030')>0) then
1793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1794: FND_MSG_PUB.ADD;
1795: RAISE FND_API.G_EXC_ERROR;
1796: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1798: FND_MSG_PUB.ADD;
1799: RAISE FND_API.G_EXC_ERROR;

Line 1799: RAISE FND_API.G_EXC_ERROR;

1795: RAISE FND_API.G_EXC_ERROR;
1796: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1798: FND_MSG_PUB.ADD;
1799: RAISE FND_API.G_EXC_ERROR;
1800: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1802: FND_MSG_PUB.ADD;
1803: RAISE FND_API.G_EXC_ERROR;

Line 1803: RAISE FND_API.G_EXC_ERROR;

1799: RAISE FND_API.G_EXC_ERROR;
1800: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1802: FND_MSG_PUB.ADD;
1803: RAISE FND_API.G_EXC_ERROR;
1804: else
1805: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1807: FND_MSG_PUB.ADD;

Line 1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1804: else
1805: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: end if;
1810: END;
1811:
1812: PROCEDURE open_contact_pt_cursor(

Line 2068: RAISE FND_API.G_EXC_ERROR;

2064: when others then
2065: if (instrb(SQLERRM,'DRG-51030')>0) then
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2067: FND_MSG_PUB.ADD;
2068: RAISE FND_API.G_EXC_ERROR;
2069: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2071: FND_MSG_PUB.ADD;
2072: RAISE FND_API.G_EXC_ERROR;

Line 2072: RAISE FND_API.G_EXC_ERROR;

2068: RAISE FND_API.G_EXC_ERROR;
2069: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2071: FND_MSG_PUB.ADD;
2072: RAISE FND_API.G_EXC_ERROR;
2073: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2074: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2075: FND_MSG_PUB.ADD;
2076: RAISE FND_API.G_EXC_ERROR;

Line 2076: RAISE FND_API.G_EXC_ERROR;

2072: RAISE FND_API.G_EXC_ERROR;
2073: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2074: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2075: FND_MSG_PUB.ADD;
2076: RAISE FND_API.G_EXC_ERROR;
2077: else
2078: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2079: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2080: FND_MSG_PUB.ADD;

Line 2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2077: else
2078: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2079: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2080: FND_MSG_PUB.ADD;
2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2082: end if;
2083: END;
2084:
2085:

Line 2330: RAISE FND_API.G_EXC_ERROR;

2326: 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);
2327: END IF;
2328: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2329: FND_MSG_PUB.ADD;
2330: RAISE FND_API.G_EXC_ERROR;
2331: ELSE
2332: push_eval;
2333: RETURN;
2334: END IF;

Line 2378: RAISE FND_API.G_EXC_ERROR;

2374: 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);
2375: END IF;
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2377: FND_MSG_PUB.ADD;
2378: RAISE FND_API.G_EXC_ERROR;
2379: ELSE
2380: push_eval;
2381: RETURN;
2382: END IF;

Line 2451: RAISE FND_API.G_EXC_ERROR;

2447: 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);
2448: END IF;
2449: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2450: FND_MSG_PUB.ADD;
2451: RAISE FND_API.G_EXC_ERROR;
2452: ELSE
2453: push_eval;
2454: RETURN;
2455: END IF;

Line 2563: RAISE FND_API.G_EXC_ERROR;

2559: 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);
2560: END IF;
2561: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2562: FND_MSG_PUB.ADD;
2563: RAISE FND_API.G_EXC_ERROR;
2564: ELSE
2565: push_eval;
2566: RETURN;
2567: END IF;

Line 2674: RAISE FND_API.G_EXC_ERROR;

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

Line 2899: RAISE FND_API.G_EXC_ERROR;

2895: 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);
2896: END IF;
2897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2898: FND_MSG_PUB.ADD;
2899: RAISE FND_API.G_EXC_ERROR;
2900: END IF;
2901: ELSE
2902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2903: 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 2907: RAISE FND_API.G_EXC_ERROR;

2903: 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);
2904: END IF;
2905: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2906: FND_MSG_PUB.ADD;
2907: RAISE FND_API.G_EXC_ERROR;
2908: END IF;
2909: END IF;
2910: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2911: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3106: WHEN FND_API.G_EXC_ERROR THEN

3102: END IF;
3103: EXCEPTION
3104: WHEN L_RETURN_IMM_EXC THEN
3105: RETURN;
3106: WHEN FND_API.G_EXC_ERROR THEN
3107: RAISE FND_API.G_EXC_ERROR;
3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: WHEN OTHERS THEN

Line 3107: RAISE FND_API.G_EXC_ERROR;

3103: EXCEPTION
3104: WHEN L_RETURN_IMM_EXC THEN
3105: RETURN;
3106: WHEN FND_API.G_EXC_ERROR THEN
3107: RAISE FND_API.G_EXC_ERROR;
3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: WHEN OTHERS THEN
3111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3104: WHEN L_RETURN_IMM_EXC THEN
3105: RETURN;
3106: WHEN FND_API.G_EXC_ERROR THEN
3107: RAISE FND_API.G_EXC_ERROR;
3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: WHEN OTHERS THEN
3111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3112: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_parties');

Line 3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3105: RETURN;
3106: WHEN FND_API.G_EXC_ERROR THEN
3107: RAISE FND_API.G_EXC_ERROR;
3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: WHEN OTHERS THEN
3111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3112: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_parties');
3113: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3112: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_parties');
3113: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3114: FND_MSG_PUB.ADD;
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: END find_parties;
3117:
3118: PROCEDURE find_persons (
3119: p_rule_id IN NUMBER,

Line 3304: RAISE FND_API.G_EXC_ERROR;

3300: 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);
3301: END IF;
3302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3303: FND_MSG_PUB.ADD;
3304: RAISE FND_API.G_EXC_ERROR;
3305: ELSE
3306: push_eval;
3307: RETURN;
3308: END IF;

Line 3352: RAISE FND_API.G_EXC_ERROR;

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

Line 3388: RAISE FND_API.G_EXC_ERROR;

3384: when others then
3385: if (instrb(SQLERRM,'DRG-51030')>0) then
3386: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3387: FND_MSG_PUB.ADD;
3388: RAISE FND_API.G_EXC_ERROR;
3389: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3391: FND_MSG_PUB.ADD;
3392: RAISE FND_API.G_EXC_ERROR;

Line 3392: RAISE FND_API.G_EXC_ERROR;

3388: RAISE FND_API.G_EXC_ERROR;
3389: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3391: FND_MSG_PUB.ADD;
3392: RAISE FND_API.G_EXC_ERROR;
3393: else
3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3395: end if;
3396: END;

Line 3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3391: FND_MSG_PUB.ADD;
3392: RAISE FND_API.G_EXC_ERROR;
3393: else
3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3395: end if;
3396: END;
3397:
3398: /** Private procedure to acquire and score at party site level ***/

Line 3464: RAISE FND_API.G_EXC_ERROR;

3460: 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);
3461: END IF;
3462: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3463: FND_MSG_PUB.ADD;
3464: RAISE FND_API.G_EXC_ERROR;
3465: ELSE
3466: push_eval;
3467: RETURN;
3468: END IF;

Line 3723: RAISE FND_API.G_EXC_ERROR;

3719: 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);
3720: END IF;
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: ELSE
3725: push_eval;
3726: RETURN;
3727: END IF;

Line 3836: RAISE FND_API.G_EXC_ERROR;

3832: 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);
3833: END IF;
3834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3835: FND_MSG_PUB.ADD;
3836: RAISE FND_API.G_EXC_ERROR;
3837: END IF;
3838: ELSE
3839: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3840: 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 3844: RAISE FND_API.G_EXC_ERROR;

3840: 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);
3841: END IF;
3842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3843: FND_MSG_PUB.ADD;
3844: RAISE FND_API.G_EXC_ERROR;
3845: END IF;
3846: END IF;
3847: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3848: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3958: WHEN FND_API.G_EXC_ERROR THEN

3954: END IF;
3955: EXCEPTION
3956: WHEN L_RETURN_IMM_EXC THEN
3957: RETURN;
3958: WHEN FND_API.G_EXC_ERROR THEN
3959: RAISE FND_API.G_EXC_ERROR;
3960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: WHEN OTHERS THEN

Line 3959: RAISE FND_API.G_EXC_ERROR;

3955: EXCEPTION
3956: WHEN L_RETURN_IMM_EXC THEN
3957: RETURN;
3958: WHEN FND_API.G_EXC_ERROR THEN
3959: RAISE FND_API.G_EXC_ERROR;
3960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: WHEN OTHERS THEN
3963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3956: WHEN L_RETURN_IMM_EXC THEN
3957: RETURN;
3958: WHEN FND_API.G_EXC_ERROR THEN
3959: RAISE FND_API.G_EXC_ERROR;
3960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: WHEN OTHERS THEN
3963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_persons');

Line 3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3957: RETURN;
3958: WHEN FND_API.G_EXC_ERROR THEN
3959: RAISE FND_API.G_EXC_ERROR;
3960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: WHEN OTHERS THEN
3963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_persons');
3965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_persons');
3965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END find_persons;
3969:
3970: PROCEDURE find_persons (
3971: p_rule_id IN NUMBER,

Line 4026: WHEN FND_API.G_EXC_ERROR THEN

4022: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4023: 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);
4024: END IF;
4025: EXCEPTION
4026: WHEN FND_API.G_EXC_ERROR THEN
4027: RAISE FND_API.G_EXC_ERROR;
4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4030: WHEN OTHERS THEN

Line 4027: RAISE FND_API.G_EXC_ERROR;

4023: 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);
4024: END IF;
4025: EXCEPTION
4026: WHEN FND_API.G_EXC_ERROR THEN
4027: RAISE FND_API.G_EXC_ERROR;
4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4030: WHEN OTHERS THEN
4031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4024: END IF;
4025: EXCEPTION
4026: WHEN FND_API.G_EXC_ERROR THEN
4027: RAISE FND_API.G_EXC_ERROR;
4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4030: WHEN OTHERS THEN
4031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4032: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_party_details');

Line 4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4025: EXCEPTION
4026: WHEN FND_API.G_EXC_ERROR THEN
4027: RAISE FND_API.G_EXC_ERROR;
4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4030: WHEN OTHERS THEN
4031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4032: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_party_details');
4033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4032: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_party_details');
4033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4034: FND_MSG_PUB.ADD;
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: END find_party_details;
4037:
4038: PROCEDURE find_duplicate_parties (
4039: p_rule_id IN NUMBER,

Line 4143: WHEN FND_API.G_EXC_ERROR THEN

4139: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4140: 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);
4141: END IF;
4142: EXCEPTION
4143: WHEN FND_API.G_EXC_ERROR THEN
4144: RAISE FND_API.G_EXC_ERROR;
4145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4147: WHEN OTHERS THEN

Line 4144: RAISE FND_API.G_EXC_ERROR;

4140: 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);
4141: END IF;
4142: EXCEPTION
4143: WHEN FND_API.G_EXC_ERROR THEN
4144: RAISE FND_API.G_EXC_ERROR;
4145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4147: WHEN OTHERS THEN
4148: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4141: END IF;
4142: EXCEPTION
4143: WHEN FND_API.G_EXC_ERROR THEN
4144: RAISE FND_API.G_EXC_ERROR;
4145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4147: WHEN OTHERS THEN
4148: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4149: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_parties');

Line 4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4142: EXCEPTION
4143: WHEN FND_API.G_EXC_ERROR THEN
4144: RAISE FND_API.G_EXC_ERROR;
4145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4147: WHEN OTHERS THEN
4148: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4149: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_parties');
4150: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4148: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4149: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_parties');
4150: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4151: FND_MSG_PUB.ADD;
4152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4153: END find_duplicate_parties;
4154:
4155: PROCEDURE find_duplicate_party_sites (
4156: p_rule_id IN NUMBER,

Line 4228: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4229: RAISE FND_API.G_EXC_ERROR;

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

Line 4230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4317: WHEN FND_API.G_EXC_ERROR THEN

4313: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4314: 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);
4315: END IF;
4316: EXCEPTION
4317: WHEN FND_API.G_EXC_ERROR THEN
4318: RAISE FND_API.G_EXC_ERROR;
4319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: WHEN OTHERS THEN

Line 4318: RAISE FND_API.G_EXC_ERROR;

4314: 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);
4315: END IF;
4316: EXCEPTION
4317: WHEN FND_API.G_EXC_ERROR THEN
4318: RAISE FND_API.G_EXC_ERROR;
4319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: WHEN OTHERS THEN
4322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4315: END IF;
4316: EXCEPTION
4317: WHEN FND_API.G_EXC_ERROR THEN
4318: RAISE FND_API.G_EXC_ERROR;
4319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: WHEN OTHERS THEN
4322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4323: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contacts');

Line 4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4316: EXCEPTION
4317: WHEN FND_API.G_EXC_ERROR THEN
4318: RAISE FND_API.G_EXC_ERROR;
4319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: WHEN OTHERS THEN
4322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4323: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contacts');
4324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4323: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contacts');
4324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4325: FND_MSG_PUB.ADD;
4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4327: END find_duplicate_contacts;
4328:
4329: PROCEDURE find_duplicate_contact_points (
4330: p_rule_id IN NUMBER,

Line 4390: WHEN FND_API.G_EXC_ERROR THEN

4386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4387: 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);
4388: END IF;
4389: EXCEPTION
4390: WHEN FND_API.G_EXC_ERROR THEN
4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN

Line 4391: RAISE FND_API.G_EXC_ERROR;

4387: 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);
4388: END IF;
4389: EXCEPTION
4390: WHEN FND_API.G_EXC_ERROR THEN
4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4388: END IF;
4389: EXCEPTION
4390: WHEN FND_API.G_EXC_ERROR THEN
4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contact_points');

Line 4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4389: EXCEPTION
4390: WHEN FND_API.G_EXC_ERROR THEN
4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contact_points');
4397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contact_points');
4397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4398: FND_MSG_PUB.ADD;
4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4400: END find_duplicate_contact_points;
4401:
4402: PROCEDURE find_parties_dynamic (
4403: p_rule_id IN NUMBER,

Line 4681: WHEN FND_API.G_EXC_ERROR THEN

4677: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4678: 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);
4679: END IF;
4680: EXCEPTION
4681: WHEN FND_API.G_EXC_ERROR THEN
4682: RAISE FND_API.G_EXC_ERROR;
4683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4685: WHEN OTHERS THEN

Line 4682: RAISE FND_API.G_EXC_ERROR;

4678: 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);
4679: END IF;
4680: EXCEPTION
4681: WHEN FND_API.G_EXC_ERROR THEN
4682: RAISE FND_API.G_EXC_ERROR;
4683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4685: WHEN OTHERS THEN
4686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4679: END IF;
4680: EXCEPTION
4681: WHEN FND_API.G_EXC_ERROR THEN
4682: RAISE FND_API.G_EXC_ERROR;
4683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4685: WHEN OTHERS THEN
4686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.call_api_dynamic');

Line 4684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4680: EXCEPTION
4681: WHEN FND_API.G_EXC_ERROR THEN
4682: RAISE FND_API.G_EXC_ERROR;
4683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4685: WHEN OTHERS THEN
4686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.call_api_dynamic');
4688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.call_api_dynamic');
4688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4689: FND_MSG_PUB.ADD;
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: END call_api_dynamic;
4692:
4693:
4694: PROCEDURE get_matching_party_sites (

Line 4916: WHEN FND_API.G_EXC_ERROR THEN

4912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4913: 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);
4914: END IF;
4915: EXCEPTION
4916: WHEN FND_API.G_EXC_ERROR THEN
4917: RAISE FND_API.G_EXC_ERROR;
4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4920: WHEN OTHERS THEN

Line 4917: RAISE FND_API.G_EXC_ERROR;

4913: 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);
4914: END IF;
4915: EXCEPTION
4916: WHEN FND_API.G_EXC_ERROR THEN
4917: RAISE FND_API.G_EXC_ERROR;
4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4920: WHEN OTHERS THEN
4921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4914: END IF;
4915: EXCEPTION
4916: WHEN FND_API.G_EXC_ERROR THEN
4917: RAISE FND_API.G_EXC_ERROR;
4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4920: WHEN OTHERS THEN
4921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_party_sites');

Line 4919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4915: EXCEPTION
4916: WHEN FND_API.G_EXC_ERROR THEN
4917: RAISE FND_API.G_EXC_ERROR;
4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4920: WHEN OTHERS THEN
4921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_party_sites');
4923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_party_sites');
4923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4924: FND_MSG_PUB.ADD;
4925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4926: END get_matching_party_sites;
4927:
4928:
4929: PROCEDURE get_matching_contacts (

Line 5142: WHEN FND_API.G_EXC_ERROR THEN

5138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5139: 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);
5140: END IF;
5141: EXCEPTION
5142: WHEN FND_API.G_EXC_ERROR THEN
5143: RAISE FND_API.G_EXC_ERROR;
5144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: WHEN OTHERS THEN

Line 5143: RAISE FND_API.G_EXC_ERROR;

5139: 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);
5140: END IF;
5141: EXCEPTION
5142: WHEN FND_API.G_EXC_ERROR THEN
5143: RAISE FND_API.G_EXC_ERROR;
5144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: WHEN OTHERS THEN
5147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5140: END IF;
5141: EXCEPTION
5142: WHEN FND_API.G_EXC_ERROR THEN
5143: RAISE FND_API.G_EXC_ERROR;
5144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: WHEN OTHERS THEN
5147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5148: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contacts');

Line 5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5141: EXCEPTION
5142: WHEN FND_API.G_EXC_ERROR THEN
5143: RAISE FND_API.G_EXC_ERROR;
5144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: WHEN OTHERS THEN
5147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5148: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contacts');
5149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5148: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contacts');
5149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5150: FND_MSG_PUB.ADD;
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: END get_matching_contacts;
5153:
5154:
5155: PROCEDURE get_matching_contact_points (

Line 5282: WHEN FND_API.G_EXC_ERROR THEN

5278: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5279: 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);
5280: END IF;
5281: EXCEPTION
5282: WHEN FND_API.G_EXC_ERROR THEN
5283: RAISE FND_API.G_EXC_ERROR;
5284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: WHEN OTHERS THEN

Line 5283: RAISE FND_API.G_EXC_ERROR;

5279: 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);
5280: END IF;
5281: EXCEPTION
5282: WHEN FND_API.G_EXC_ERROR THEN
5283: RAISE FND_API.G_EXC_ERROR;
5284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: WHEN OTHERS THEN
5287: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5280: END IF;
5281: EXCEPTION
5282: WHEN FND_API.G_EXC_ERROR THEN
5283: RAISE FND_API.G_EXC_ERROR;
5284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: WHEN OTHERS THEN
5287: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5288: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contact_points');

Line 5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5281: EXCEPTION
5282: WHEN FND_API.G_EXC_ERROR THEN
5283: RAISE FND_API.G_EXC_ERROR;
5284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: WHEN OTHERS THEN
5287: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5288: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contact_points');
5289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5287: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5288: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contact_points');
5289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5292: END get_matching_contact_points;
5293:
5294: /**********************************************************
5295: This procedure finds the score details for a specific party that

Line 5484: WHEN FND_API.G_EXC_ERROR THEN

5480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5481: 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);
5482: END IF;
5483: EXCEPTION
5484: WHEN FND_API.G_EXC_ERROR THEN
5485: RAISE FND_API.G_EXC_ERROR;
5486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: WHEN OTHERS THEN

Line 5485: RAISE FND_API.G_EXC_ERROR;

5481: 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);
5482: END IF;
5483: EXCEPTION
5484: WHEN FND_API.G_EXC_ERROR THEN
5485: RAISE FND_API.G_EXC_ERROR;
5486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: WHEN OTHERS THEN
5489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5482: END IF;
5483: EXCEPTION
5484: WHEN FND_API.G_EXC_ERROR THEN
5485: RAISE FND_API.G_EXC_ERROR;
5486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: WHEN OTHERS THEN
5489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_score_details');

Line 5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5483: EXCEPTION
5484: WHEN FND_API.G_EXC_ERROR THEN
5485: RAISE FND_API.G_EXC_ERROR;
5486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: WHEN OTHERS THEN
5489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_score_details');
5491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_score_details');
5491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5494: END get_score_details;
5495:
5496:
5497: /************************************************

Line 5594: WHEN FND_API.G_EXC_ERROR THEN

5590: END LOOP;
5591: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5592: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5593: EXCEPTION
5594: WHEN FND_API.G_EXC_ERROR THEN
5595: RAISE FND_API.G_EXC_ERROR;
5596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: WHEN OTHERS THEN

Line 5595: RAISE FND_API.G_EXC_ERROR;

5591: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5592: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5593: EXCEPTION
5594: WHEN FND_API.G_EXC_ERROR THEN
5595: RAISE FND_API.G_EXC_ERROR;
5596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5592: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5593: EXCEPTION
5594: WHEN FND_API.G_EXC_ERROR THEN
5595: RAISE FND_API.G_EXC_ERROR;
5596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5593: EXCEPTION
5594: WHEN FND_API.G_EXC_ERROR THEN
5595: RAISE FND_API.G_EXC_ERROR;
5596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END get_party_for_search;
5605:
5606: PROCEDURE get_search_criteria (
5607: p_party_id IN NUMBER,

Line 5640: WHEN FND_API.G_EXC_ERROR THEN

5636: END IF;
5637: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5638: END IF;
5639: EXCEPTION
5640: WHEN FND_API.G_EXC_ERROR THEN
5641: RAISE FND_API.G_EXC_ERROR;
5642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5644: WHEN OTHERS THEN

Line 5641: RAISE FND_API.G_EXC_ERROR;

5637: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5638: END IF;
5639: EXCEPTION
5640: WHEN FND_API.G_EXC_ERROR THEN
5641: RAISE FND_API.G_EXC_ERROR;
5642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5644: WHEN OTHERS THEN
5645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5638: END IF;
5639: EXCEPTION
5640: WHEN FND_API.G_EXC_ERROR THEN
5641: RAISE FND_API.G_EXC_ERROR;
5642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5644: WHEN OTHERS THEN
5645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5646: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5639: EXCEPTION
5640: WHEN FND_API.G_EXC_ERROR THEN
5641: RAISE FND_API.G_EXC_ERROR;
5642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5644: WHEN OTHERS THEN
5645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5646: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5646: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5648: FND_MSG_PUB.ADD;
5649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5650: END get_search_criteria;
5651:
5652:
5653: /************************************************

Line 5712: RAISE FND_API.G_EXC_ERROR;

5708: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5709: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5711: FND_MSG_PUB.ADD;
5712: RAISE FND_API.G_EXC_ERROR;
5713: END get_party_rec;
5714:
5715: /************************************************
5716: This procedure retrieves the match rule party site attributes into

Line 5768: RAISE FND_API.G_EXC_ERROR;

5764: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5765: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_ERROR;
5769: END get_party_site_rec;
5770:
5771: /************************************************
5772: This procedure retrieves the match rule contact attributes into

Line 5824: RAISE FND_API.G_EXC_ERROR;

5820: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5821: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5822: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5823: FND_MSG_PUB.ADD;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END get_contact_rec;
5826:
5827: /************************************************
5828: This procedure retrieves the match rule contact point attributes into

Line 5878: RAISE FND_API.G_EXC_ERROR;

5874: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;
5878: RAISE FND_API.G_EXC_ERROR;
5879: END get_contact_point_rec;
5880:
5881: /************************************************
5882: This procedure maps a search record from the logical

Line 5996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5992: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5993: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5994: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5995: FND_MSG_PUB.ADD;
5996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5997: END;
5998:
5999:
6000: /************************************************

Line 6091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6087: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6090: FND_MSG_PUB.ADD;
6091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6092: END;
6093:
6094:
6095: /************************************************

Line 6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6129: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6134: END;
6135:
6136:
6137: /************************************************

Line 6225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6221: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6222: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6224: FND_MSG_PUB.ADD;
6225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6226: END;
6227:
6228:
6229: /************************************************

Line 6249: RAISE FND_API.G_EXC_ERROR;

6245: p_contact_point_list(I).PHONE_NUMBER IS NOT NULL
6246: ) THEN
6247: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6248: FND_MSG_PUB.ADD;
6249: RAISE FND_API.G_EXC_ERROR;
6250: END IF;
6251: END LOOP;
6252:
6253: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 6279: WHEN FND_API.G_EXC_ERROR THEN

6275: END IF;
6276: END LOOP;
6277: RETURN FALSE;
6278: EXCEPTION
6279: WHEN FND_API.G_EXC_ERROR THEN
6280: RAISE FND_API.G_EXC_ERROR;
6281: WHEN OTHERS THEN
6282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6283: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6280: RAISE FND_API.G_EXC_ERROR;

6276: END LOOP;
6277: RETURN FALSE;
6278: EXCEPTION
6279: WHEN FND_API.G_EXC_ERROR THEN
6280: RAISE FND_API.G_EXC_ERROR;
6281: WHEN OTHERS THEN
6282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6283: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6283: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6285: FND_MSG_PUB.ADD;
6286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6287: END check_prim_cond;
6288:
6289: /************************************************
6290: This procedure checks if the input search condition

Line 6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6339: FND_MSG_PUB.ADD;
6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6341: END check_party_site_cond;
6342:
6343: /************************************************
6344: This procedure checks if the input search condition

Line 6386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6382: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6383: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6384: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6385: FND_MSG_PUB.ADD;
6386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6387: END check_contact_cond;
6388:
6389: /************************************************
6390: This procedure checks if the input search condition

Line 6407: RAISE FND_API.G_EXC_ERROR;

6403: FOR I IN 1..p_contact_point_list.COUNT LOOP
6404: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6405: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6406: FND_MSG_PUB.ADD;
6407: RAISE FND_API.G_EXC_ERROR;
6408: END IF;
6409: END LOOP;
6410:
6411: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6428: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6432: END check_contact_point_cond;
6433:
6434: FUNCTION check_staged RETURN BOOLEAN IS
6435: