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_41 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 667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

663: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
664: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
666: FND_MSG_PUB.ADD;
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END;
669:
670:
671: /************************************************

Line 687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

683: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
684: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
686: FND_MSG_PUB.ADD;
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END;
689:
690:
691: /************************************************

Line 707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

703: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
704: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END;
709:
710:
711: /************************************************

Line 727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
724: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
726: FND_MSG_PUB.ADD;
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END;
729:
730: PROCEDURE init_score_context (
731: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 794: RAISE FND_API.G_EXC_ERROR;

790: p_contact_list,
791: p_contact_point_list) THEN
792: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
797: 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);
798: END IF;

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: IF lengthb(l_party_contains_str) > 4000 THEN
1026: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1027: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1028: FND_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: IF (p_match_str = ' AND ' OR p_party_max_score 1032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1033: 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 1098: RAISE FND_API.G_EXC_ERROR;

1094: IF lengthb(l_contains_str) > 4000 THEN
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1096: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: x_denorm_str := l_den_contains_str;
1101: RETURN l_contains_str;
1102: END;

Line 1188: RAISE FND_API.G_EXC_ERROR;

1184: IF lengthb(l_contains_str) > 4000 THEN
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1186: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1187: FND_MSG_PUB.ADD;
1188: RAISE FND_API.G_EXC_ERROR;
1189: END IF;
1190: x_denorm_str := l_den_contains_str;
1191: RETURN l_contains_str;
1192: END;

Line 1406: RAISE FND_API.G_EXC_ERROR;

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

Line 1410: RAISE FND_API.G_EXC_ERROR;

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

Line 1414: RAISE FND_API.G_EXC_ERROR;

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

Line 1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1651: RAISE FND_API.G_EXC_ERROR;

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

Line 1655: RAISE FND_API.G_EXC_ERROR;

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

Line 1659: RAISE FND_API.G_EXC_ERROR;

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

Line 1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1798: RAISE FND_API.G_EXC_ERROR;

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

Line 1802: RAISE FND_API.G_EXC_ERROR;

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

Line 1806: RAISE FND_API.G_EXC_ERROR;

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

Line 1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2071: RAISE FND_API.G_EXC_ERROR;

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

Line 2075: RAISE FND_API.G_EXC_ERROR;

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

Line 2079: RAISE FND_API.G_EXC_ERROR;

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

Line 2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2336: RAISE FND_API.G_EXC_ERROR;

2332: 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);
2333: END IF;
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2335: FND_MSG_PUB.ADD;
2336: RAISE FND_API.G_EXC_ERROR;
2337: ELSE
2338: push_eval;
2339: RETURN;
2340: END IF;

Line 2384: RAISE FND_API.G_EXC_ERROR;

2380: 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);
2381: END IF;
2382: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2383: FND_MSG_PUB.ADD;
2384: RAISE FND_API.G_EXC_ERROR;
2385: ELSE
2386: push_eval;
2387: RETURN;
2388: END IF;

Line 2457: RAISE FND_API.G_EXC_ERROR;

2453: 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);
2454: END IF;
2455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2456: FND_MSG_PUB.ADD;
2457: RAISE FND_API.G_EXC_ERROR;
2458: ELSE
2459: push_eval;
2460: RETURN;
2461: END IF;

Line 2569: RAISE FND_API.G_EXC_ERROR;

2565: 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);
2566: END IF;
2567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2568: FND_MSG_PUB.ADD;
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSE
2571: push_eval;
2572: RETURN;
2573: END IF;

Line 2680: RAISE FND_API.G_EXC_ERROR;

2676: 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);
2677: END IF;
2678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2679: FND_MSG_PUB.ADD;
2680: RAISE FND_API.G_EXC_ERROR;
2681: ELSE
2682: push_eval;
2683: RETURN;
2684: END IF;

Line 2905: RAISE FND_API.G_EXC_ERROR;

2901: 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);
2902: END IF;
2903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2904: FND_MSG_PUB.ADD;
2905: RAISE FND_API.G_EXC_ERROR;
2906: END IF;
2907: ELSE
2908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2909: 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 2913: RAISE FND_API.G_EXC_ERROR;

2909: 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);
2910: END IF;
2911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2912: FND_MSG_PUB.ADD;
2913: RAISE FND_API.G_EXC_ERROR;
2914: END IF;
2915: END IF;
2916: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2917: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3112: WHEN FND_API.G_EXC_ERROR THEN

3108: END IF;
3109: EXCEPTION
3110: WHEN L_RETURN_IMM_EXC THEN
3111: RETURN;
3112: WHEN FND_API.G_EXC_ERROR THEN
3113: RAISE FND_API.G_EXC_ERROR;
3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: WHEN OTHERS THEN

Line 3113: RAISE FND_API.G_EXC_ERROR;

3109: EXCEPTION
3110: WHEN L_RETURN_IMM_EXC THEN
3111: RETURN;
3112: WHEN FND_API.G_EXC_ERROR THEN
3113: RAISE FND_API.G_EXC_ERROR;
3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: WHEN OTHERS THEN
3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3110: WHEN L_RETURN_IMM_EXC THEN
3111: RETURN;
3112: WHEN FND_API.G_EXC_ERROR THEN
3113: RAISE FND_API.G_EXC_ERROR;
3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: WHEN OTHERS THEN
3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_parties');

Line 3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3111: RETURN;
3112: WHEN FND_API.G_EXC_ERROR THEN
3113: RAISE FND_API.G_EXC_ERROR;
3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: WHEN OTHERS THEN
3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_parties');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_parties');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3120: FND_MSG_PUB.ADD;
3121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3122: END find_parties;
3123:
3124: PROCEDURE find_persons (
3125: p_rule_id IN NUMBER,

Line 3313: RAISE FND_API.G_EXC_ERROR;

3309: 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);
3310: END IF;
3311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3312: FND_MSG_PUB.ADD;
3313: RAISE FND_API.G_EXC_ERROR;
3314: ELSE
3315: push_eval;
3316: RETURN;
3317: END IF;

Line 3361: RAISE FND_API.G_EXC_ERROR;

3357: 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);
3358: END IF;
3359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3360: FND_MSG_PUB.ADD;
3361: RAISE FND_API.G_EXC_ERROR;
3362: ELSE
3363: push_eval;
3364: RETURN;
3365: END IF;

Line 3397: RAISE FND_API.G_EXC_ERROR;

3393: when others then
3394: if (instrb(SQLERRM,'DRG-51030')>0) then
3395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3396: FND_MSG_PUB.ADD;
3397: RAISE FND_API.G_EXC_ERROR;
3398: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3400: FND_MSG_PUB.ADD;
3401: RAISE FND_API.G_EXC_ERROR;

Line 3401: RAISE FND_API.G_EXC_ERROR;

3397: RAISE FND_API.G_EXC_ERROR;
3398: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3400: FND_MSG_PUB.ADD;
3401: RAISE FND_API.G_EXC_ERROR;
3402: else
3403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3404: end if;
3405: END;

Line 3403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3400: FND_MSG_PUB.ADD;
3401: RAISE FND_API.G_EXC_ERROR;
3402: else
3403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3404: end if;
3405: END;
3406:
3407: /** Private procedure to acquire and score at party site level ***/

Line 3473: RAISE FND_API.G_EXC_ERROR;

3469: 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);
3470: END IF;
3471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3472: FND_MSG_PUB.ADD;
3473: RAISE FND_API.G_EXC_ERROR;
3474: ELSE
3475: push_eval;
3476: RETURN;
3477: END IF;

Line 3732: RAISE FND_API.G_EXC_ERROR;

3728: 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);
3729: END IF;
3730: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3731: FND_MSG_PUB.ADD;
3732: RAISE FND_API.G_EXC_ERROR;
3733: ELSE
3734: push_eval;
3735: RETURN;
3736: END IF;

Line 3845: RAISE FND_API.G_EXC_ERROR;

3841: 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);
3842: END IF;
3843: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3844: FND_MSG_PUB.ADD;
3845: RAISE FND_API.G_EXC_ERROR;
3846: END IF;
3847: ELSE
3848: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3849: 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 3853: RAISE FND_API.G_EXC_ERROR;

3849: 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);
3850: END IF;
3851: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3852: FND_MSG_PUB.ADD;
3853: RAISE FND_API.G_EXC_ERROR;
3854: END IF;
3855: END IF;
3856: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3857: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3967: WHEN FND_API.G_EXC_ERROR THEN

3963: END IF;
3964: EXCEPTION
3965: WHEN L_RETURN_IMM_EXC THEN
3966: RETURN;
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN

Line 3968: RAISE FND_API.G_EXC_ERROR;

3964: EXCEPTION
3965: WHEN L_RETURN_IMM_EXC THEN
3966: RETURN;
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3965: WHEN L_RETURN_IMM_EXC THEN
3966: RETURN;
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');

Line 3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3966: RETURN;
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_persons;
3978:
3979: PROCEDURE find_persons (
3980: p_rule_id IN NUMBER,

Line 4035: WHEN FND_API.G_EXC_ERROR THEN

4031: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4032: 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);
4033: END IF;
4034: EXCEPTION
4035: WHEN FND_API.G_EXC_ERROR THEN
4036: RAISE FND_API.G_EXC_ERROR;
4037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4039: WHEN OTHERS THEN

Line 4036: RAISE FND_API.G_EXC_ERROR;

4032: 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);
4033: END IF;
4034: EXCEPTION
4035: WHEN FND_API.G_EXC_ERROR THEN
4036: RAISE FND_API.G_EXC_ERROR;
4037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4039: WHEN OTHERS THEN
4040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4033: END IF;
4034: EXCEPTION
4035: WHEN FND_API.G_EXC_ERROR THEN
4036: RAISE FND_API.G_EXC_ERROR;
4037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4039: WHEN OTHERS THEN
4040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_party_details');

Line 4038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4034: EXCEPTION
4035: WHEN FND_API.G_EXC_ERROR THEN
4036: RAISE FND_API.G_EXC_ERROR;
4037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4039: WHEN OTHERS THEN
4040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_party_details');
4042: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_party_details');
4042: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4043: FND_MSG_PUB.ADD;
4044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4045: END find_party_details;
4046:
4047: PROCEDURE find_duplicate_parties (
4048: p_rule_id IN NUMBER,

Line 4152: WHEN FND_API.G_EXC_ERROR THEN

4148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4149: 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);
4150: END IF;
4151: EXCEPTION
4152: WHEN FND_API.G_EXC_ERROR THEN
4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN

Line 4153: RAISE FND_API.G_EXC_ERROR;

4149: 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);
4150: END IF;
4151: EXCEPTION
4152: WHEN FND_API.G_EXC_ERROR THEN
4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4150: END IF;
4151: EXCEPTION
4152: WHEN FND_API.G_EXC_ERROR THEN
4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');

Line 4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4151: EXCEPTION
4152: WHEN FND_API.G_EXC_ERROR THEN
4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4162: END find_duplicate_parties;
4163:
4164: PROCEDURE find_duplicate_party_sites (
4165: p_rule_id IN NUMBER,

Line 4237: WHEN FND_API.G_EXC_ERROR THEN

4233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4234: 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);
4235: END IF;
4236: EXCEPTION
4237: WHEN FND_API.G_EXC_ERROR THEN
4238: RAISE FND_API.G_EXC_ERROR;
4239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: WHEN OTHERS THEN

Line 4238: RAISE FND_API.G_EXC_ERROR;

4234: 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);
4235: END IF;
4236: EXCEPTION
4237: WHEN FND_API.G_EXC_ERROR THEN
4238: RAISE FND_API.G_EXC_ERROR;
4239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: WHEN OTHERS THEN
4242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4235: END IF;
4236: EXCEPTION
4237: WHEN FND_API.G_EXC_ERROR THEN
4238: RAISE FND_API.G_EXC_ERROR;
4239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: WHEN OTHERS THEN
4242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4243: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');

Line 4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4236: EXCEPTION
4237: WHEN FND_API.G_EXC_ERROR THEN
4238: RAISE FND_API.G_EXC_ERROR;
4239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: WHEN OTHERS THEN
4242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4243: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');
4244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4243: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');
4244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4245: FND_MSG_PUB.ADD;
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: END find_duplicate_party_sites;
4248:
4249: PROCEDURE find_duplicate_contacts (
4250: p_rule_id IN NUMBER,

Line 4326: WHEN FND_API.G_EXC_ERROR THEN

4322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4323: 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);
4324: END IF;
4325: EXCEPTION
4326: WHEN FND_API.G_EXC_ERROR THEN
4327: RAISE FND_API.G_EXC_ERROR;
4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: WHEN OTHERS THEN

Line 4327: RAISE FND_API.G_EXC_ERROR;

4323: 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);
4324: END IF;
4325: EXCEPTION
4326: WHEN FND_API.G_EXC_ERROR THEN
4327: RAISE FND_API.G_EXC_ERROR;
4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4324: END IF;
4325: EXCEPTION
4326: WHEN FND_API.G_EXC_ERROR THEN
4327: RAISE FND_API.G_EXC_ERROR;
4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');

Line 4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4325: EXCEPTION
4326: WHEN FND_API.G_EXC_ERROR THEN
4327: RAISE FND_API.G_EXC_ERROR;
4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END find_duplicate_contacts;
4337:
4338: PROCEDURE find_duplicate_contact_points (
4339: p_rule_id IN NUMBER,

Line 4399: WHEN FND_API.G_EXC_ERROR THEN

4395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4396: 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);
4397: END IF;
4398: EXCEPTION
4399: WHEN FND_API.G_EXC_ERROR THEN
4400: RAISE FND_API.G_EXC_ERROR;
4401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4403: WHEN OTHERS THEN

Line 4400: RAISE FND_API.G_EXC_ERROR;

4396: 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);
4397: END IF;
4398: EXCEPTION
4399: WHEN FND_API.G_EXC_ERROR THEN
4400: RAISE FND_API.G_EXC_ERROR;
4401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4403: WHEN OTHERS THEN
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4397: END IF;
4398: EXCEPTION
4399: WHEN FND_API.G_EXC_ERROR THEN
4400: RAISE FND_API.G_EXC_ERROR;
4401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4403: WHEN OTHERS THEN
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4405: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contact_points');

Line 4402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4398: EXCEPTION
4399: WHEN FND_API.G_EXC_ERROR THEN
4400: RAISE FND_API.G_EXC_ERROR;
4401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4403: WHEN OTHERS THEN
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4405: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contact_points');
4406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4405: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contact_points');
4406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4407: FND_MSG_PUB.ADD;
4408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4409: END find_duplicate_contact_points;
4410:
4411: PROCEDURE find_parties_dynamic (
4412: p_rule_id IN NUMBER,

Line 4707: WHEN FND_API.G_EXC_ERROR THEN

4703: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4704: 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);
4705: END IF;
4706: EXCEPTION
4707: WHEN FND_API.G_EXC_ERROR THEN
4708: RAISE FND_API.G_EXC_ERROR;
4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN

Line 4708: RAISE FND_API.G_EXC_ERROR;

4704: 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);
4705: END IF;
4706: EXCEPTION
4707: WHEN FND_API.G_EXC_ERROR THEN
4708: RAISE FND_API.G_EXC_ERROR;
4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4705: END IF;
4706: EXCEPTION
4707: WHEN FND_API.G_EXC_ERROR THEN
4708: RAISE FND_API.G_EXC_ERROR;
4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');

Line 4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4706: EXCEPTION
4707: WHEN FND_API.G_EXC_ERROR THEN
4708: RAISE FND_API.G_EXC_ERROR;
4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4715: FND_MSG_PUB.ADD;
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END call_api_dynamic;
4718:
4719:
4720: PROCEDURE get_matching_party_sites (

Line 4945: WHEN FND_API.G_EXC_ERROR THEN

4941: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4942: 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);
4943: END IF;
4944: EXCEPTION
4945: WHEN FND_API.G_EXC_ERROR THEN
4946: RAISE FND_API.G_EXC_ERROR;
4947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: WHEN OTHERS THEN

Line 4946: RAISE FND_API.G_EXC_ERROR;

4942: 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);
4943: END IF;
4944: EXCEPTION
4945: WHEN FND_API.G_EXC_ERROR THEN
4946: RAISE FND_API.G_EXC_ERROR;
4947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: WHEN OTHERS THEN
4950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4943: END IF;
4944: EXCEPTION
4945: WHEN FND_API.G_EXC_ERROR THEN
4946: RAISE FND_API.G_EXC_ERROR;
4947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: WHEN OTHERS THEN
4950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');

Line 4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4944: EXCEPTION
4945: WHEN FND_API.G_EXC_ERROR THEN
4946: RAISE FND_API.G_EXC_ERROR;
4947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: WHEN OTHERS THEN
4950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');
4952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');
4952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: END get_matching_party_sites;
4956:
4957:
4958: PROCEDURE get_matching_contacts (

Line 5173: WHEN FND_API.G_EXC_ERROR THEN

5169: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5170: 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);
5171: END IF;
5172: EXCEPTION
5173: WHEN FND_API.G_EXC_ERROR THEN
5174: RAISE FND_API.G_EXC_ERROR;
5175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5177: WHEN OTHERS THEN

Line 5174: RAISE FND_API.G_EXC_ERROR;

5170: 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);
5171: END IF;
5172: EXCEPTION
5173: WHEN FND_API.G_EXC_ERROR THEN
5174: RAISE FND_API.G_EXC_ERROR;
5175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5177: WHEN OTHERS THEN
5178: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5171: END IF;
5172: EXCEPTION
5173: WHEN FND_API.G_EXC_ERROR THEN
5174: RAISE FND_API.G_EXC_ERROR;
5175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5177: WHEN OTHERS THEN
5178: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5179: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');

Line 5176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5172: EXCEPTION
5173: WHEN FND_API.G_EXC_ERROR THEN
5174: RAISE FND_API.G_EXC_ERROR;
5175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5177: WHEN OTHERS THEN
5178: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5179: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5178: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5179: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5181: FND_MSG_PUB.ADD;
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: END get_matching_contacts;
5184:
5185:
5186: PROCEDURE get_matching_contact_points (

Line 5315: WHEN FND_API.G_EXC_ERROR THEN

5311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5312: 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);
5313: END IF;
5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN

Line 5316: RAISE FND_API.G_EXC_ERROR;

5312: 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);
5313: END IF;
5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5313: END IF;
5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');

Line 5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: END get_matching_contact_points;
5326:
5327: /**********************************************************
5328: This procedure finds the score details for a specific party that

Line 5527: WHEN FND_API.G_EXC_ERROR THEN

5523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5524: 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);
5525: END IF;
5526: EXCEPTION
5527: WHEN FND_API.G_EXC_ERROR THEN
5528: RAISE FND_API.G_EXC_ERROR;
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN

Line 5528: RAISE FND_API.G_EXC_ERROR;

5524: 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);
5525: END IF;
5526: EXCEPTION
5527: WHEN FND_API.G_EXC_ERROR THEN
5528: RAISE FND_API.G_EXC_ERROR;
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5525: END IF;
5526: EXCEPTION
5527: WHEN FND_API.G_EXC_ERROR THEN
5528: RAISE FND_API.G_EXC_ERROR;
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');

Line 5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5526: EXCEPTION
5527: WHEN FND_API.G_EXC_ERROR THEN
5528: RAISE FND_API.G_EXC_ERROR;
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5535: FND_MSG_PUB.ADD;
5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5537: END get_score_details;
5538:
5539:
5540: /************************************************

Line 5637: WHEN FND_API.G_EXC_ERROR THEN

5633: END LOOP;
5634: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5635: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5636: EXCEPTION
5637: WHEN FND_API.G_EXC_ERROR THEN
5638: RAISE FND_API.G_EXC_ERROR;
5639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: WHEN OTHERS THEN

Line 5638: RAISE FND_API.G_EXC_ERROR;

5634: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5635: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5636: EXCEPTION
5637: WHEN FND_API.G_EXC_ERROR THEN
5638: RAISE FND_API.G_EXC_ERROR;
5639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: WHEN OTHERS THEN
5642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5635: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5636: EXCEPTION
5637: WHEN FND_API.G_EXC_ERROR THEN
5638: RAISE FND_API.G_EXC_ERROR;
5639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: WHEN OTHERS THEN
5642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5643: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5636: EXCEPTION
5637: WHEN FND_API.G_EXC_ERROR THEN
5638: RAISE FND_API.G_EXC_ERROR;
5639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: WHEN OTHERS THEN
5642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5643: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5643: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5645: FND_MSG_PUB.ADD;
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: END get_party_for_search;
5648:
5649: PROCEDURE get_search_criteria (
5650: p_party_id IN NUMBER,

Line 5683: WHEN FND_API.G_EXC_ERROR THEN

5679: END IF;
5680: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5681: END IF;
5682: EXCEPTION
5683: WHEN FND_API.G_EXC_ERROR THEN
5684: RAISE FND_API.G_EXC_ERROR;
5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5687: WHEN OTHERS THEN

Line 5684: RAISE FND_API.G_EXC_ERROR;

5680: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5681: END IF;
5682: EXCEPTION
5683: WHEN FND_API.G_EXC_ERROR THEN
5684: RAISE FND_API.G_EXC_ERROR;
5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5687: WHEN OTHERS THEN
5688: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5681: END IF;
5682: EXCEPTION
5683: WHEN FND_API.G_EXC_ERROR THEN
5684: RAISE FND_API.G_EXC_ERROR;
5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5687: WHEN OTHERS THEN
5688: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5689: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5682: EXCEPTION
5683: WHEN FND_API.G_EXC_ERROR THEN
5684: RAISE FND_API.G_EXC_ERROR;
5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5687: WHEN OTHERS THEN
5688: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5689: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5690: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5688: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5689: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5690: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5691: FND_MSG_PUB.ADD;
5692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5693: END get_search_criteria;
5694:
5695:
5696: /************************************************

Line 5753: RAISE FND_API.G_EXC_ERROR;

5749: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5750: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5752: FND_MSG_PUB.ADD;
5753: RAISE FND_API.G_EXC_ERROR;
5754: END get_party_rec;
5755:
5756: /************************************************
5757: This procedure retrieves the match rule party site attributes into

Line 5809: RAISE FND_API.G_EXC_ERROR;

5805: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5806: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5808: FND_MSG_PUB.ADD;
5809: RAISE FND_API.G_EXC_ERROR;
5810: END get_party_site_rec;
5811:
5812: /************************************************
5813: This procedure retrieves the match rule contact attributes into

Line 5865: RAISE FND_API.G_EXC_ERROR;

5861: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5862: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END get_contact_rec;
5867:
5868: /************************************************
5869: This procedure retrieves the match rule contact point attributes into

Line 5921: RAISE FND_API.G_EXC_ERROR;

5917: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5918: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5919: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5920: FND_MSG_PUB.ADD;
5921: RAISE FND_API.G_EXC_ERROR;
5922: END get_contact_point_rec;
5923:
5924: /************************************************
5925: This procedure maps a search record from the logical

Line 6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6031: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6036: END;
6037:
6038:
6039: /************************************************

Line 6153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6149: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6152: FND_MSG_PUB.ADD;
6153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6154: END;
6155:
6156:
6157: /************************************************

Line 6195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6191: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6192: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6193: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6194: FND_MSG_PUB.ADD;
6195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6196: END;
6197:
6198:
6199: /************************************************

Line 6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6322: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6323: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6325: FND_MSG_PUB.ADD;
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END;
6328:
6329:
6330: /************************************************

Line 6350: RAISE FND_API.G_EXC_ERROR;

6346: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6347: ) THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6349: FND_MSG_PUB.ADD;
6350: RAISE FND_API.G_EXC_ERROR;
6351: END IF;
6352: END LOOP;
6353:
6354: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 6377: WHEN FND_API.G_EXC_ERROR THEN

6373: END IF;
6374: END LOOP;
6375: RETURN FALSE;
6376: EXCEPTION
6377: WHEN FND_API.G_EXC_ERROR THEN
6378: RAISE FND_API.G_EXC_ERROR;
6379: WHEN OTHERS THEN
6380: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6381: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6378: RAISE FND_API.G_EXC_ERROR;

6374: END LOOP;
6375: RETURN FALSE;
6376: EXCEPTION
6377: WHEN FND_API.G_EXC_ERROR THEN
6378: RAISE FND_API.G_EXC_ERROR;
6379: WHEN OTHERS THEN
6380: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6381: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6435: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6436: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6437: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6438: FND_MSG_PUB.ADD;
6439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6440: END check_party_site_cond;
6441:
6442: /************************************************
6443: This procedure checks if the input search condition

Line 6486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6483: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6485: FND_MSG_PUB.ADD;
6486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6487: END check_contact_cond;
6488:
6489: /************************************************
6490: This procedure checks if the input search condition

Line 6507: RAISE FND_API.G_EXC_ERROR;

6503: FOR I IN 1..p_contact_point_list.COUNT LOOP
6504: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6505: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6506: FND_MSG_PUB.ADD;
6507: RAISE FND_API.G_EXC_ERROR;
6508: END IF;
6509: END LOOP;
6510:
6511: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6529: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6531: FND_MSG_PUB.ADD;
6532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6533: END check_contact_point_cond;
6534:
6535: FUNCTION check_staged RETURN BOOLEAN IS
6536: