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

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

Line 1412: RAISE FND_API.G_EXC_ERROR;

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

Line 1416: RAISE FND_API.G_EXC_ERROR;

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

Line 1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1653: RAISE FND_API.G_EXC_ERROR;

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

Line 1657: RAISE FND_API.G_EXC_ERROR;

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

Line 1661: RAISE FND_API.G_EXC_ERROR;

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

Line 1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1800: RAISE FND_API.G_EXC_ERROR;

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

Line 1804: RAISE FND_API.G_EXC_ERROR;

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

Line 1808: RAISE FND_API.G_EXC_ERROR;

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

Line 1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2073: RAISE FND_API.G_EXC_ERROR;

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

Line 2077: RAISE FND_API.G_EXC_ERROR;

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

Line 2081: RAISE FND_API.G_EXC_ERROR;

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

Line 2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2339: RAISE FND_API.G_EXC_ERROR;

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

Line 2387: RAISE FND_API.G_EXC_ERROR;

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

Line 2460: RAISE FND_API.G_EXC_ERROR;

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

Line 2572: RAISE FND_API.G_EXC_ERROR;

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

Line 2683: RAISE FND_API.G_EXC_ERROR;

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

Line 2908: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3115: WHEN FND_API.G_EXC_ERROR THEN

3111: END IF;
3112: EXCEPTION
3113: WHEN L_RETURN_IMM_EXC THEN
3114: RETURN;
3115: WHEN FND_API.G_EXC_ERROR THEN
3116: RAISE FND_API.G_EXC_ERROR;
3117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3119: WHEN OTHERS THEN

Line 3116: RAISE FND_API.G_EXC_ERROR;

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

Line 3117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3317: RAISE FND_API.G_EXC_ERROR;

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

Line 3365: RAISE FND_API.G_EXC_ERROR;

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

Line 3401: RAISE FND_API.G_EXC_ERROR;

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

Line 3405: RAISE FND_API.G_EXC_ERROR;

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

Line 3407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3477: RAISE FND_API.G_EXC_ERROR;

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

Line 3736: RAISE FND_API.G_EXC_ERROR;

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

Line 3849: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3971: WHEN FND_API.G_EXC_ERROR THEN

3967: END IF;
3968: EXCEPTION
3969: WHEN L_RETURN_IMM_EXC THEN
3970: RETURN;
3971: WHEN FND_API.G_EXC_ERROR THEN
3972: RAISE FND_API.G_EXC_ERROR;
3973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: WHEN OTHERS THEN

Line 3972: RAISE FND_API.G_EXC_ERROR;

3968: EXCEPTION
3969: WHEN L_RETURN_IMM_EXC THEN
3970: RETURN;
3971: WHEN FND_API.G_EXC_ERROR THEN
3972: RAISE FND_API.G_EXC_ERROR;
3973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: WHEN OTHERS THEN
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3969: WHEN L_RETURN_IMM_EXC THEN
3970: RETURN;
3971: WHEN FND_API.G_EXC_ERROR THEN
3972: RAISE FND_API.G_EXC_ERROR;
3973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: WHEN OTHERS THEN
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3977: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');

Line 3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3970: RETURN;
3971: WHEN FND_API.G_EXC_ERROR THEN
3972: RAISE FND_API.G_EXC_ERROR;
3973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: WHEN OTHERS THEN
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3977: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');
3978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4039: WHEN FND_API.G_EXC_ERROR THEN

4035: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4036: 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);
4037: END IF;
4038: EXCEPTION
4039: WHEN FND_API.G_EXC_ERROR THEN
4040: RAISE FND_API.G_EXC_ERROR;
4041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4043: WHEN OTHERS THEN

Line 4040: RAISE FND_API.G_EXC_ERROR;

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

Line 4041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4037: END IF;
4038: EXCEPTION
4039: WHEN FND_API.G_EXC_ERROR THEN
4040: RAISE FND_API.G_EXC_ERROR;
4041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4043: WHEN OTHERS THEN
4044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_party_details');

Line 4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4038: EXCEPTION
4039: WHEN FND_API.G_EXC_ERROR THEN
4040: RAISE FND_API.G_EXC_ERROR;
4041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4043: WHEN OTHERS THEN
4044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_party_details');
4046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4156: WHEN FND_API.G_EXC_ERROR THEN

4152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4153: 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);
4154: END IF;
4155: EXCEPTION
4156: WHEN FND_API.G_EXC_ERROR THEN
4157: RAISE FND_API.G_EXC_ERROR;
4158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160: WHEN OTHERS THEN

Line 4157: RAISE FND_API.G_EXC_ERROR;

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

Line 4158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4154: END IF;
4155: EXCEPTION
4156: WHEN FND_API.G_EXC_ERROR THEN
4157: RAISE FND_API.G_EXC_ERROR;
4158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160: WHEN OTHERS THEN
4161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');

Line 4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4155: EXCEPTION
4156: WHEN FND_API.G_EXC_ERROR THEN
4157: RAISE FND_API.G_EXC_ERROR;
4158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160: WHEN OTHERS THEN
4161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');
4163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4241: WHEN FND_API.G_EXC_ERROR THEN

4237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4238: 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);
4239: END IF;
4240: EXCEPTION
4241: WHEN FND_API.G_EXC_ERROR THEN
4242: RAISE FND_API.G_EXC_ERROR;
4243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: WHEN OTHERS THEN

Line 4242: RAISE FND_API.G_EXC_ERROR;

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

Line 4243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4239: END IF;
4240: EXCEPTION
4241: WHEN FND_API.G_EXC_ERROR THEN
4242: RAISE FND_API.G_EXC_ERROR;
4243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: WHEN OTHERS THEN
4246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4247: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');

Line 4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4240: EXCEPTION
4241: WHEN FND_API.G_EXC_ERROR THEN
4242: RAISE FND_API.G_EXC_ERROR;
4243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: WHEN OTHERS THEN
4246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4247: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');
4248: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4330: WHEN FND_API.G_EXC_ERROR THEN

4326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4327: 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);
4328: END IF;
4329: EXCEPTION
4330: WHEN FND_API.G_EXC_ERROR THEN
4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN

Line 4331: RAISE FND_API.G_EXC_ERROR;

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

Line 4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4328: END IF;
4329: EXCEPTION
4330: WHEN FND_API.G_EXC_ERROR THEN
4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');

Line 4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4329: EXCEPTION
4330: WHEN FND_API.G_EXC_ERROR THEN
4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4403: WHEN FND_API.G_EXC_ERROR THEN

4399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4400: 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);
4401: END IF;
4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: RAISE FND_API.G_EXC_ERROR;
4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN

Line 4404: RAISE FND_API.G_EXC_ERROR;

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

Line 4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4401: END IF;
4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: RAISE FND_API.G_EXC_ERROR;
4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN
4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contact_points');

Line 4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: RAISE FND_API.G_EXC_ERROR;
4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN
4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contact_points');
4410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4711: WHEN FND_API.G_EXC_ERROR THEN

4707: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4708: 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);
4709: END IF;
4710: EXCEPTION
4711: WHEN FND_API.G_EXC_ERROR THEN
4712: RAISE FND_API.G_EXC_ERROR;
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4715: WHEN OTHERS THEN

Line 4712: RAISE FND_API.G_EXC_ERROR;

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

Line 4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4709: END IF;
4710: EXCEPTION
4711: WHEN FND_API.G_EXC_ERROR THEN
4712: RAISE FND_API.G_EXC_ERROR;
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4715: WHEN OTHERS THEN
4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');

Line 4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4710: EXCEPTION
4711: WHEN FND_API.G_EXC_ERROR THEN
4712: RAISE FND_API.G_EXC_ERROR;
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4715: WHEN OTHERS THEN
4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4718: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4718: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4719: FND_MSG_PUB.ADD;
4720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4721: END call_api_dynamic;
4722:
4723:
4724: PROCEDURE get_matching_party_sites (

Line 4949: WHEN FND_API.G_EXC_ERROR THEN

4945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4946: 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);
4947: END IF;
4948: EXCEPTION
4949: WHEN FND_API.G_EXC_ERROR THEN
4950: RAISE FND_API.G_EXC_ERROR;
4951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4953: WHEN OTHERS THEN

Line 4950: RAISE FND_API.G_EXC_ERROR;

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

Line 4951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4947: END IF;
4948: EXCEPTION
4949: WHEN FND_API.G_EXC_ERROR THEN
4950: RAISE FND_API.G_EXC_ERROR;
4951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4953: WHEN OTHERS THEN
4954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4955: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');

Line 4952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4948: EXCEPTION
4949: WHEN FND_API.G_EXC_ERROR THEN
4950: RAISE FND_API.G_EXC_ERROR;
4951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4953: WHEN OTHERS THEN
4954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4955: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');
4956: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4955: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');
4956: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4957: FND_MSG_PUB.ADD;
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: END get_matching_party_sites;
4960:
4961:
4962: PROCEDURE get_matching_contacts (

Line 5177: WHEN FND_API.G_EXC_ERROR THEN

5173: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5174: 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);
5175: END IF;
5176: EXCEPTION
5177: WHEN FND_API.G_EXC_ERROR THEN
5178: RAISE FND_API.G_EXC_ERROR;
5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5181: WHEN OTHERS THEN

Line 5178: RAISE FND_API.G_EXC_ERROR;

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

Line 5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5175: END IF;
5176: EXCEPTION
5177: WHEN FND_API.G_EXC_ERROR THEN
5178: RAISE FND_API.G_EXC_ERROR;
5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5181: WHEN OTHERS THEN
5182: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5183: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');

Line 5180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5176: EXCEPTION
5177: WHEN FND_API.G_EXC_ERROR THEN
5178: RAISE FND_API.G_EXC_ERROR;
5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5181: WHEN OTHERS THEN
5182: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5183: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5184: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5182: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5183: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5184: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5185: FND_MSG_PUB.ADD;
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: END get_matching_contacts;
5188:
5189:
5190: PROCEDURE get_matching_contact_points (

Line 5319: WHEN FND_API.G_EXC_ERROR THEN

5315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5316: 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);
5317: END IF;
5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN

Line 5320: RAISE FND_API.G_EXC_ERROR;

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

Line 5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5317: END IF;
5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');

Line 5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5532: WHEN FND_API.G_EXC_ERROR THEN

5528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5529: 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);
5530: END IF;
5531: EXCEPTION
5532: WHEN FND_API.G_EXC_ERROR THEN
5533: RAISE FND_API.G_EXC_ERROR;
5534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5536: WHEN OTHERS THEN

Line 5533: RAISE FND_API.G_EXC_ERROR;

5529: 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);
5530: END IF;
5531: EXCEPTION
5532: WHEN FND_API.G_EXC_ERROR THEN
5533: RAISE FND_API.G_EXC_ERROR;
5534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5536: WHEN OTHERS THEN
5537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5530: END IF;
5531: EXCEPTION
5532: WHEN FND_API.G_EXC_ERROR THEN
5533: RAISE FND_API.G_EXC_ERROR;
5534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5536: WHEN OTHERS THEN
5537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5538: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');

Line 5535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5531: EXCEPTION
5532: WHEN FND_API.G_EXC_ERROR THEN
5533: RAISE FND_API.G_EXC_ERROR;
5534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5536: WHEN OTHERS THEN
5537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5538: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5538: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5540: FND_MSG_PUB.ADD;
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: END get_score_details;
5543:
5544:
5545: /************************************************

Line 5642: WHEN FND_API.G_EXC_ERROR THEN

5638: END LOOP;
5639: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5640: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5641: EXCEPTION
5642: WHEN FND_API.G_EXC_ERROR THEN
5643: RAISE FND_API.G_EXC_ERROR;
5644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: WHEN OTHERS THEN

Line 5643: RAISE FND_API.G_EXC_ERROR;

5639: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5640: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5641: EXCEPTION
5642: WHEN FND_API.G_EXC_ERROR THEN
5643: RAISE FND_API.G_EXC_ERROR;
5644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: WHEN OTHERS THEN
5647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5640: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5641: EXCEPTION
5642: WHEN FND_API.G_EXC_ERROR THEN
5643: RAISE FND_API.G_EXC_ERROR;
5644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: WHEN OTHERS THEN
5647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5648: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5648: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: END get_party_for_search;
5653:
5654: PROCEDURE get_search_criteria (
5655: p_party_id IN NUMBER,

Line 5688: WHEN FND_API.G_EXC_ERROR THEN

5684: END IF;
5685: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5686: END IF;
5687: EXCEPTION
5688: WHEN FND_API.G_EXC_ERROR THEN
5689: RAISE FND_API.G_EXC_ERROR;
5690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5692: WHEN OTHERS THEN

Line 5689: RAISE FND_API.G_EXC_ERROR;

5685: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5686: END IF;
5687: EXCEPTION
5688: WHEN FND_API.G_EXC_ERROR THEN
5689: RAISE FND_API.G_EXC_ERROR;
5690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5692: WHEN OTHERS THEN
5693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5686: END IF;
5687: EXCEPTION
5688: WHEN FND_API.G_EXC_ERROR THEN
5689: RAISE FND_API.G_EXC_ERROR;
5690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5692: WHEN OTHERS THEN
5693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5694: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5687: EXCEPTION
5688: WHEN FND_API.G_EXC_ERROR THEN
5689: RAISE FND_API.G_EXC_ERROR;
5690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5692: WHEN OTHERS THEN
5693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5694: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5695: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5694: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5695: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5696: FND_MSG_PUB.ADD;
5697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5698: END get_search_criteria;
5699:
5700:
5701: /************************************************

Line 5758: RAISE FND_API.G_EXC_ERROR;

5754: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5755: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5756: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5757: FND_MSG_PUB.ADD;
5758: RAISE FND_API.G_EXC_ERROR;
5759: END get_party_rec;
5760:
5761: /************************************************
5762: This procedure retrieves the match rule party site attributes into

Line 5814: RAISE FND_API.G_EXC_ERROR;

5810: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5811: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5813: FND_MSG_PUB.ADD;
5814: RAISE FND_API.G_EXC_ERROR;
5815: END get_party_site_rec;
5816:
5817: /************************************************
5818: This procedure retrieves the match rule contact attributes into

Line 5870: RAISE FND_API.G_EXC_ERROR;

5866: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5867: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_ERROR;
5871: END get_contact_rec;
5872:
5873: /************************************************
5874: This procedure retrieves the match rule contact point attributes into

Line 5926: RAISE FND_API.G_EXC_ERROR;

5922: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5923: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_ERROR;
5927: END get_contact_point_rec;
5928:
5929: /************************************************
5930: This procedure maps a search record from the logical

Line 6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6036: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END;
6042:
6043:
6044: /************************************************

Line 6158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6154: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6155: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6157: FND_MSG_PUB.ADD;
6158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6159: END;
6160:
6161:
6162: /************************************************

Line 6200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6196: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6197: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6199: FND_MSG_PUB.ADD;
6200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6201: END;
6202:
6203:
6204: /************************************************

Line 6331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6327: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6328: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6330: FND_MSG_PUB.ADD;
6331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6332: END;
6333:
6334:
6335: /************************************************

Line 6355: RAISE FND_API.G_EXC_ERROR;

6351: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6352: ) THEN
6353: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6354: FND_MSG_PUB.ADD;
6355: RAISE FND_API.G_EXC_ERROR;
6356: END IF;
6357: END LOOP;
6358:
6359: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 6382: WHEN FND_API.G_EXC_ERROR THEN

6378: END IF;
6379: END LOOP;
6380: RETURN FALSE;
6381: EXCEPTION
6382: WHEN FND_API.G_EXC_ERROR THEN
6383: RAISE FND_API.G_EXC_ERROR;
6384: WHEN OTHERS THEN
6385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6386: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6383: RAISE FND_API.G_EXC_ERROR;

6379: END LOOP;
6380: RETURN FALSE;
6381: EXCEPTION
6382: WHEN FND_API.G_EXC_ERROR THEN
6383: RAISE FND_API.G_EXC_ERROR;
6384: WHEN OTHERS THEN
6385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6386: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6387: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6441: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6443: FND_MSG_PUB.ADD;
6444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6445: END check_party_site_cond;
6446:
6447: /************************************************
6448: This procedure checks if the input search condition

Line 6491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6492: END check_contact_cond;
6493:
6494: /************************************************
6495: This procedure checks if the input search condition

Line 6512: RAISE FND_API.G_EXC_ERROR;

6508: FOR I IN 1..p_contact_point_list.COUNT LOOP
6509: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6511: FND_MSG_PUB.ADD;
6512: RAISE FND_API.G_EXC_ERROR;
6513: END IF;
6514: END LOOP;
6515:
6516: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6538: END check_contact_point_cond;
6539:
6540: FUNCTION check_staged RETURN BOOLEAN IS
6541: