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_60 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 1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1030: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1031: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1032: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1033: FND_MSG_PUB.ADD;
1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1035: END;
1036:
1037:
1038: /************************************************

Line 1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1055: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1056: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1058: FND_MSG_PUB.ADD;
1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060: END;
1061:
1062:
1063: /************************************************

Line 1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1075: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1076: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1078: FND_MSG_PUB.ADD;
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: END;
1081:
1082:
1083: /************************************************

Line 1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1095: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1096: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1098: FND_MSG_PUB.ADD;
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END;
1101:
1102: PROCEDURE init_score_context (
1103: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1166: RAISE FND_API.G_EXC_ERROR;

1162: p_contact_list,
1163: p_contact_point_list) THEN
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1165: FND_MSG_PUB.ADD;
1166: RAISE FND_API.G_EXC_ERROR;
1167: END IF;
1168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1169: 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);
1170: END IF;

Line 1435: RAISE FND_API.G_EXC_ERROR;

1431: IF lengthb(l_party_contains_str) > 4000 THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1433: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1434: FND_MSG_PUB.ADD;
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: IF (p_match_str = ' AND ' OR p_party_max_score 1438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1439: 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 1548: RAISE FND_API.G_EXC_ERROR;

1544: IF lengthb(l_contains_str) > 4000 THEN
1545: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1546: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550: x_denorm_str := l_den_contains_str;
1551: RETURN l_contains_str;
1552: END;

Line 1595: RAISE FND_API.G_EXC_ERROR;

1591: IF lengthb(l_contains_str) > 4000 THEN
1592: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1593: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1594: FND_MSG_PUB.ADD;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597: x_denorm_str := l_den_contains_str;
1598: RETURN l_contains_str;
1599: END;

Line 1676: RAISE FND_API.G_EXC_ERROR;

1672: IF lengthb(l_contains_str) > 4000 THEN
1673: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1674: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678: x_denorm_str := l_den_contains_str;
1679: RETURN l_contains_str;
1680: END;

Line 1948: RAISE FND_API.G_EXC_ERROR;

1944: when others then
1945: if (instrb(SQLERRM,'DRG-51030')>0) then
1946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_ERROR;
1949: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1951: FND_MSG_PUB.ADD;
1952: RAISE FND_API.G_EXC_ERROR;

Line 1952: RAISE FND_API.G_EXC_ERROR;

1948: RAISE FND_API.G_EXC_ERROR;
1949: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1951: FND_MSG_PUB.ADD;
1952: RAISE FND_API.G_EXC_ERROR;
1953: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_ERROR;

Line 1956: RAISE FND_API.G_EXC_ERROR;

1952: RAISE FND_API.G_EXC_ERROR;
1953: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_ERROR;
1957: else
1958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1960: FND_MSG_PUB.ADD;

Line 1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1957: else
1958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1962: end if;
1963: END;
1964:
1965: PROCEDURE open_party_site_cursor(

Line 2193: RAISE FND_API.G_EXC_ERROR;

2189: when others then
2190: if (instrb(SQLERRM,'DRG-51030')>0) then
2191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2192: FND_MSG_PUB.ADD;
2193: RAISE FND_API.G_EXC_ERROR;
2194: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2196: FND_MSG_PUB.ADD;
2197: RAISE FND_API.G_EXC_ERROR;

Line 2197: RAISE FND_API.G_EXC_ERROR;

2193: RAISE FND_API.G_EXC_ERROR;
2194: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2196: FND_MSG_PUB.ADD;
2197: RAISE FND_API.G_EXC_ERROR;
2198: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2199: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2200: FND_MSG_PUB.ADD;
2201: RAISE FND_API.G_EXC_ERROR;

Line 2201: RAISE FND_API.G_EXC_ERROR;

2197: RAISE FND_API.G_EXC_ERROR;
2198: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2199: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2200: FND_MSG_PUB.ADD;
2201: RAISE FND_API.G_EXC_ERROR;
2202: else
2203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2205: FND_MSG_PUB.ADD;

Line 2206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2202: else
2203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2205: FND_MSG_PUB.ADD;
2206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2207: end if;
2208: END;
2209:
2210: PROCEDURE open_contact_cursor(

Line 2340: RAISE FND_API.G_EXC_ERROR;

2336: when others then
2337: if (instrb(SQLERRM,'DRG-51030')>0) then
2338: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2339: FND_MSG_PUB.ADD;
2340: RAISE FND_API.G_EXC_ERROR;
2341: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2342: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2343: FND_MSG_PUB.ADD;
2344: RAISE FND_API.G_EXC_ERROR;

Line 2344: RAISE FND_API.G_EXC_ERROR;

2340: RAISE FND_API.G_EXC_ERROR;
2341: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2342: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2343: FND_MSG_PUB.ADD;
2344: RAISE FND_API.G_EXC_ERROR;
2345: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2346: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2347: FND_MSG_PUB.ADD;
2348: RAISE FND_API.G_EXC_ERROR;

Line 2348: RAISE FND_API.G_EXC_ERROR;

2344: RAISE FND_API.G_EXC_ERROR;
2345: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2346: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2347: FND_MSG_PUB.ADD;
2348: RAISE FND_API.G_EXC_ERROR;
2349: else
2350: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2351: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2352: FND_MSG_PUB.ADD;

Line 2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2349: else
2350: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2351: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2352: FND_MSG_PUB.ADD;
2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2354: end if;
2355: END;
2356:
2357: PROCEDURE open_contact_pt_cursor(

Line 2613: RAISE FND_API.G_EXC_ERROR;

2609: when others then
2610: if (instrb(SQLERRM,'DRG-51030')>0) then
2611: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2612: FND_MSG_PUB.ADD;
2613: RAISE FND_API.G_EXC_ERROR;
2614: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2615: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2616: FND_MSG_PUB.ADD;
2617: RAISE FND_API.G_EXC_ERROR;

Line 2617: RAISE FND_API.G_EXC_ERROR;

2613: RAISE FND_API.G_EXC_ERROR;
2614: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2615: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2616: FND_MSG_PUB.ADD;
2617: RAISE FND_API.G_EXC_ERROR;
2618: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2619: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;

Line 2621: RAISE FND_API.G_EXC_ERROR;

2617: RAISE FND_API.G_EXC_ERROR;
2618: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2619: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: else
2623: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2625: FND_MSG_PUB.ADD;

Line 2626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2622: else
2623: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2627: end if;
2628: END;
2629:
2630:

Line 2888: RAISE FND_API.G_EXC_ERROR;

2884: 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);
2885: END IF;
2886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2887: FND_MSG_PUB.ADD;
2888: RAISE FND_API.G_EXC_ERROR;
2889: ELSE
2890: push_eval;
2891: RETURN;
2892: END IF;

Line 2938: RAISE FND_API.G_EXC_ERROR;

2934: 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);
2935: END IF;
2936: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2937: FND_MSG_PUB.ADD;
2938: RAISE FND_API.G_EXC_ERROR;
2939: ELSE
2940: push_eval;
2941: RETURN;
2942: END IF;

Line 3011: RAISE FND_API.G_EXC_ERROR;

3007: 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);
3008: END IF;
3009: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3010: FND_MSG_PUB.ADD;
3011: RAISE FND_API.G_EXC_ERROR;
3012: ELSE
3013: push_eval;
3014: RETURN;
3015: END IF;

Line 3123: RAISE FND_API.G_EXC_ERROR;

3119: 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);
3120: END IF;
3121: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3122: FND_MSG_PUB.ADD;
3123: RAISE FND_API.G_EXC_ERROR;
3124: ELSE
3125: push_eval;
3126: RETURN;
3127: END IF;

Line 3234: RAISE FND_API.G_EXC_ERROR;

3230: 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);
3231: END IF;
3232: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3233: FND_MSG_PUB.ADD;
3234: RAISE FND_API.G_EXC_ERROR;
3235: ELSE
3236: push_eval;
3237: RETURN;
3238: END IF;

Line 3459: RAISE FND_API.G_EXC_ERROR;

3455: 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);
3456: END IF;
3457: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3458: FND_MSG_PUB.ADD;
3459: RAISE FND_API.G_EXC_ERROR;
3460: END IF;
3461: ELSE
3462: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3463: 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 3467: RAISE FND_API.G_EXC_ERROR;

3463: 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);
3464: END IF;
3465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3466: FND_MSG_PUB.ADD;
3467: RAISE FND_API.G_EXC_ERROR;
3468: END IF;
3469: END IF;
3470: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3471: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3666: WHEN FND_API.G_EXC_ERROR THEN

3662: END IF;
3663: EXCEPTION
3664: WHEN L_RETURN_IMM_EXC THEN
3665: RETURN;
3666: WHEN FND_API.G_EXC_ERROR THEN
3667: RAISE FND_API.G_EXC_ERROR;
3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3670: WHEN OTHERS THEN

Line 3667: RAISE FND_API.G_EXC_ERROR;

3663: EXCEPTION
3664: WHEN L_RETURN_IMM_EXC THEN
3665: RETURN;
3666: WHEN FND_API.G_EXC_ERROR THEN
3667: RAISE FND_API.G_EXC_ERROR;
3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3670: WHEN OTHERS THEN
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3664: WHEN L_RETURN_IMM_EXC THEN
3665: RETURN;
3666: WHEN FND_API.G_EXC_ERROR THEN
3667: RAISE FND_API.G_EXC_ERROR;
3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3670: WHEN OTHERS THEN
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3672: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');

Line 3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3665: RETURN;
3666: WHEN FND_API.G_EXC_ERROR THEN
3667: RAISE FND_API.G_EXC_ERROR;
3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3670: WHEN OTHERS THEN
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3672: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3673: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3672: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3673: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: END find_parties;
3677:
3678: PROCEDURE find_persons (
3679: p_rule_id IN NUMBER,

Line 3877: RAISE FND_API.G_EXC_ERROR;

3873: 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);
3874: END IF;
3875: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3876: FND_MSG_PUB.ADD;
3877: RAISE FND_API.G_EXC_ERROR;
3878: ELSE
3879: push_eval;
3880: RETURN;
3881: END IF;

Line 3927: RAISE FND_API.G_EXC_ERROR;

3923: 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);
3924: END IF;
3925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3926: FND_MSG_PUB.ADD;
3927: RAISE FND_API.G_EXC_ERROR;
3928: ELSE
3929: push_eval;
3930: RETURN;
3931: END IF;

Line 3963: RAISE FND_API.G_EXC_ERROR;

3959: when others then
3960: if (instrb(SQLERRM,'DRG-51030')>0) then
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3962: FND_MSG_PUB.ADD;
3963: RAISE FND_API.G_EXC_ERROR;
3964: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_ERROR;

Line 3967: RAISE FND_API.G_EXC_ERROR;

3963: RAISE FND_API.G_EXC_ERROR;
3964: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_ERROR;
3968: else
3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3970: end if;
3971: END;

Line 3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_ERROR;
3968: else
3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3970: end if;
3971: END;
3972:
3973: /** Private procedure to acquire and score at party site level ***/

Line 4039: RAISE FND_API.G_EXC_ERROR;

4035: 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);
4036: END IF;
4037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4038: FND_MSG_PUB.ADD;
4039: RAISE FND_API.G_EXC_ERROR;
4040: ELSE
4041: push_eval;
4042: RETURN;
4043: END IF;

Line 4298: RAISE FND_API.G_EXC_ERROR;

4294: 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);
4295: END IF;
4296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4297: FND_MSG_PUB.ADD;
4298: RAISE FND_API.G_EXC_ERROR;
4299: ELSE
4300: push_eval;
4301: RETURN;
4302: END IF;

Line 4411: RAISE FND_API.G_EXC_ERROR;

4407: 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);
4408: END IF;
4409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4410: FND_MSG_PUB.ADD;
4411: RAISE FND_API.G_EXC_ERROR;
4412: END IF;
4413: ELSE
4414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4415: 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 4419: RAISE FND_API.G_EXC_ERROR;

4415: 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);
4416: END IF;
4417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4418: FND_MSG_PUB.ADD;
4419: RAISE FND_API.G_EXC_ERROR;
4420: END IF;
4421: END IF;
4422: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4423: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4533: WHEN FND_API.G_EXC_ERROR THEN

4529: END IF;
4530: EXCEPTION
4531: WHEN L_RETURN_IMM_EXC THEN
4532: RETURN;
4533: WHEN FND_API.G_EXC_ERROR THEN
4534: RAISE FND_API.G_EXC_ERROR;
4535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4537: WHEN OTHERS THEN

Line 4534: RAISE FND_API.G_EXC_ERROR;

4530: EXCEPTION
4531: WHEN L_RETURN_IMM_EXC THEN
4532: RETURN;
4533: WHEN FND_API.G_EXC_ERROR THEN
4534: RAISE FND_API.G_EXC_ERROR;
4535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4537: WHEN OTHERS THEN
4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4531: WHEN L_RETURN_IMM_EXC THEN
4532: RETURN;
4533: WHEN FND_API.G_EXC_ERROR THEN
4534: RAISE FND_API.G_EXC_ERROR;
4535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4537: WHEN OTHERS THEN
4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4539: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');

Line 4536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4532: RETURN;
4533: WHEN FND_API.G_EXC_ERROR THEN
4534: RAISE FND_API.G_EXC_ERROR;
4535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4537: WHEN OTHERS THEN
4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4539: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');
4540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4539: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');
4540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4541: FND_MSG_PUB.ADD;
4542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4543: END find_persons;
4544:
4545: PROCEDURE find_persons (
4546: p_rule_id IN NUMBER,

Line 4601: WHEN FND_API.G_EXC_ERROR THEN

4597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4598: 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);
4599: END IF;
4600: EXCEPTION
4601: WHEN FND_API.G_EXC_ERROR THEN
4602: RAISE FND_API.G_EXC_ERROR;
4603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4605: WHEN OTHERS THEN

Line 4602: RAISE FND_API.G_EXC_ERROR;

4598: 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);
4599: END IF;
4600: EXCEPTION
4601: WHEN FND_API.G_EXC_ERROR THEN
4602: RAISE FND_API.G_EXC_ERROR;
4603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4605: WHEN OTHERS THEN
4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4599: END IF;
4600: EXCEPTION
4601: WHEN FND_API.G_EXC_ERROR THEN
4602: RAISE FND_API.G_EXC_ERROR;
4603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4605: WHEN OTHERS THEN
4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4607: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');

Line 4604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4600: EXCEPTION
4601: WHEN FND_API.G_EXC_ERROR THEN
4602: RAISE FND_API.G_EXC_ERROR;
4603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4605: WHEN OTHERS THEN
4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4607: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');
4608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4607: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');
4608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4609: FND_MSG_PUB.ADD;
4610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4611: END find_party_details;
4612:
4613: PROCEDURE find_duplicate_parties (
4614: p_rule_id IN NUMBER,

Line 4718: WHEN FND_API.G_EXC_ERROR THEN

4714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4715: 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);
4716: END IF;
4717: EXCEPTION
4718: WHEN FND_API.G_EXC_ERROR THEN
4719: RAISE FND_API.G_EXC_ERROR;
4720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: WHEN OTHERS THEN

Line 4719: RAISE FND_API.G_EXC_ERROR;

4715: 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);
4716: END IF;
4717: EXCEPTION
4718: WHEN FND_API.G_EXC_ERROR THEN
4719: RAISE FND_API.G_EXC_ERROR;
4720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: WHEN OTHERS THEN
4723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4716: END IF;
4717: EXCEPTION
4718: WHEN FND_API.G_EXC_ERROR THEN
4719: RAISE FND_API.G_EXC_ERROR;
4720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: WHEN OTHERS THEN
4723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4724: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_parties');

Line 4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4717: EXCEPTION
4718: WHEN FND_API.G_EXC_ERROR THEN
4719: RAISE FND_API.G_EXC_ERROR;
4720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: WHEN OTHERS THEN
4723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4724: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_parties');
4725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4724: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_parties');
4725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4726: FND_MSG_PUB.ADD;
4727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4728: END find_duplicate_parties;
4729:
4730: PROCEDURE find_duplicate_party_sites (
4731: p_rule_id IN NUMBER,

Line 4803: WHEN FND_API.G_EXC_ERROR THEN

4799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4800: 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);
4801: END IF;
4802: EXCEPTION
4803: WHEN FND_API.G_EXC_ERROR THEN
4804: RAISE FND_API.G_EXC_ERROR;
4805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: WHEN OTHERS THEN

Line 4804: RAISE FND_API.G_EXC_ERROR;

4800: 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);
4801: END IF;
4802: EXCEPTION
4803: WHEN FND_API.G_EXC_ERROR THEN
4804: RAISE FND_API.G_EXC_ERROR;
4805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: WHEN OTHERS THEN
4808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4801: END IF;
4802: EXCEPTION
4803: WHEN FND_API.G_EXC_ERROR THEN
4804: RAISE FND_API.G_EXC_ERROR;
4805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: WHEN OTHERS THEN
4808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4809: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');

Line 4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4802: EXCEPTION
4803: WHEN FND_API.G_EXC_ERROR THEN
4804: RAISE FND_API.G_EXC_ERROR;
4805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: WHEN OTHERS THEN
4808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4809: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');
4810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4809: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');
4810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4811: FND_MSG_PUB.ADD;
4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4813: END find_duplicate_party_sites;
4814:
4815: PROCEDURE find_duplicate_contacts (
4816: p_rule_id IN NUMBER,

Line 4892: WHEN FND_API.G_EXC_ERROR THEN

4888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4889: 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);
4890: END IF;
4891: EXCEPTION
4892: WHEN FND_API.G_EXC_ERROR THEN
4893: RAISE FND_API.G_EXC_ERROR;
4894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4896: WHEN OTHERS THEN

Line 4893: RAISE FND_API.G_EXC_ERROR;

4889: 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);
4890: END IF;
4891: EXCEPTION
4892: WHEN FND_API.G_EXC_ERROR THEN
4893: RAISE FND_API.G_EXC_ERROR;
4894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4896: WHEN OTHERS THEN
4897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4890: END IF;
4891: EXCEPTION
4892: WHEN FND_API.G_EXC_ERROR THEN
4893: RAISE FND_API.G_EXC_ERROR;
4894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4896: WHEN OTHERS THEN
4897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4898: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');

Line 4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4891: EXCEPTION
4892: WHEN FND_API.G_EXC_ERROR THEN
4893: RAISE FND_API.G_EXC_ERROR;
4894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4896: WHEN OTHERS THEN
4897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4898: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');
4899: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4898: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');
4899: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4900: FND_MSG_PUB.ADD;
4901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4902: END find_duplicate_contacts;
4903:
4904: PROCEDURE find_duplicate_contact_points (
4905: p_rule_id IN NUMBER,

Line 4965: WHEN FND_API.G_EXC_ERROR THEN

4961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4962: 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);
4963: END IF;
4964: EXCEPTION
4965: WHEN FND_API.G_EXC_ERROR THEN
4966: RAISE FND_API.G_EXC_ERROR;
4967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4969: WHEN OTHERS THEN

Line 4966: RAISE FND_API.G_EXC_ERROR;

4962: 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);
4963: END IF;
4964: EXCEPTION
4965: WHEN FND_API.G_EXC_ERROR THEN
4966: RAISE FND_API.G_EXC_ERROR;
4967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4969: WHEN OTHERS THEN
4970: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4963: END IF;
4964: EXCEPTION
4965: WHEN FND_API.G_EXC_ERROR THEN
4966: RAISE FND_API.G_EXC_ERROR;
4967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4969: WHEN OTHERS THEN
4970: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4971: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');

Line 4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4964: EXCEPTION
4965: WHEN FND_API.G_EXC_ERROR THEN
4966: RAISE FND_API.G_EXC_ERROR;
4967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4969: WHEN OTHERS THEN
4970: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4971: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');
4972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4970: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4971: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');
4972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4973: FND_MSG_PUB.ADD;
4974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4975: END find_duplicate_contact_points;
4976:
4977: PROCEDURE find_parties_dynamic (
4978: p_rule_id IN NUMBER,

Line 5322: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5323: RAISE FND_API.G_EXC_ERROR;

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

Line 5324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5320: END IF;
5321: EXCEPTION
5322: WHEN FND_API.G_EXC_ERROR THEN
5323: RAISE FND_API.G_EXC_ERROR;
5324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5326: WHEN OTHERS THEN
5327: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5328: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');

Line 5325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5321: EXCEPTION
5322: WHEN FND_API.G_EXC_ERROR THEN
5323: RAISE FND_API.G_EXC_ERROR;
5324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5326: WHEN OTHERS THEN
5327: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5328: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');
5329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5327: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5328: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');
5329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5330: FND_MSG_PUB.ADD;
5331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5332: END call_api_dynamic;
5333:
5334:
5335: PROCEDURE get_matching_party_sites (

Line 5567: WHEN FND_API.G_EXC_ERROR THEN

5563: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5564: 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);
5565: END IF;
5566: EXCEPTION
5567: WHEN FND_API.G_EXC_ERROR THEN
5568: RAISE FND_API.G_EXC_ERROR;
5569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5571: WHEN OTHERS THEN

Line 5568: RAISE FND_API.G_EXC_ERROR;

5564: 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);
5565: END IF;
5566: EXCEPTION
5567: WHEN FND_API.G_EXC_ERROR THEN
5568: RAISE FND_API.G_EXC_ERROR;
5569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5571: WHEN OTHERS THEN
5572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5565: END IF;
5566: EXCEPTION
5567: WHEN FND_API.G_EXC_ERROR THEN
5568: RAISE FND_API.G_EXC_ERROR;
5569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5571: WHEN OTHERS THEN
5572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5573: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');

Line 5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5566: EXCEPTION
5567: WHEN FND_API.G_EXC_ERROR THEN
5568: RAISE FND_API.G_EXC_ERROR;
5569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5571: WHEN OTHERS THEN
5572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5573: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');
5574: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5573: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');
5574: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5575: FND_MSG_PUB.ADD;
5576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5577: END get_matching_party_sites;
5578:
5579:
5580: PROCEDURE get_matching_contacts (

Line 5796: WHEN FND_API.G_EXC_ERROR THEN

5792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5793: 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);
5794: END IF;
5795: EXCEPTION
5796: WHEN FND_API.G_EXC_ERROR THEN
5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: WHEN OTHERS THEN

Line 5797: RAISE FND_API.G_EXC_ERROR;

5793: 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);
5794: END IF;
5795: EXCEPTION
5796: WHEN FND_API.G_EXC_ERROR THEN
5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5794: END IF;
5795: EXCEPTION
5796: WHEN FND_API.G_EXC_ERROR THEN
5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');

Line 5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5795: EXCEPTION
5796: WHEN FND_API.G_EXC_ERROR THEN
5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5803: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5803: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5804: FND_MSG_PUB.ADD;
5805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5806: END get_matching_contacts;
5807:
5808:
5809: PROCEDURE get_matching_contact_points (

Line 5938: WHEN FND_API.G_EXC_ERROR THEN

5934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5935: 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);
5936: END IF;
5937: EXCEPTION
5938: WHEN FND_API.G_EXC_ERROR THEN
5939: RAISE FND_API.G_EXC_ERROR;
5940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: WHEN OTHERS THEN

Line 5939: RAISE FND_API.G_EXC_ERROR;

5935: 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);
5936: END IF;
5937: EXCEPTION
5938: WHEN FND_API.G_EXC_ERROR THEN
5939: RAISE FND_API.G_EXC_ERROR;
5940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5936: END IF;
5937: EXCEPTION
5938: WHEN FND_API.G_EXC_ERROR THEN
5939: RAISE FND_API.G_EXC_ERROR;
5940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');

Line 5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5937: EXCEPTION
5938: WHEN FND_API.G_EXC_ERROR THEN
5939: RAISE FND_API.G_EXC_ERROR;
5940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5948: END get_matching_contact_points;
5949:
5950: /**********************************************************
5951: This procedure finds the score details for a specific party that

Line 6179: WHEN FND_API.G_EXC_ERROR THEN

6175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6176: 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);
6177: END IF;
6178: EXCEPTION
6179: WHEN FND_API.G_EXC_ERROR THEN
6180: RAISE FND_API.G_EXC_ERROR;
6181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6183: WHEN OTHERS THEN

Line 6180: RAISE FND_API.G_EXC_ERROR;

6176: 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);
6177: END IF;
6178: EXCEPTION
6179: WHEN FND_API.G_EXC_ERROR THEN
6180: RAISE FND_API.G_EXC_ERROR;
6181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6183: WHEN OTHERS THEN
6184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6177: END IF;
6178: EXCEPTION
6179: WHEN FND_API.G_EXC_ERROR THEN
6180: RAISE FND_API.G_EXC_ERROR;
6181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6183: WHEN OTHERS THEN
6184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');

Line 6182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6178: EXCEPTION
6179: WHEN FND_API.G_EXC_ERROR THEN
6180: RAISE FND_API.G_EXC_ERROR;
6181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6183: WHEN OTHERS THEN
6184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');
6186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');
6186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6187: FND_MSG_PUB.ADD;
6188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6189: END get_score_details;
6190:
6191:
6192: /************************************************

Line 6302: WHEN FND_API.G_EXC_ERROR THEN

6298: END LOOP;
6299: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6300: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6301: EXCEPTION
6302: WHEN FND_API.G_EXC_ERROR THEN
6303: RAISE FND_API.G_EXC_ERROR;
6304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6306: WHEN OTHERS THEN

Line 6303: RAISE FND_API.G_EXC_ERROR;

6299: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6300: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6301: EXCEPTION
6302: WHEN FND_API.G_EXC_ERROR THEN
6303: RAISE FND_API.G_EXC_ERROR;
6304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6300: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6301: EXCEPTION
6302: WHEN FND_API.G_EXC_ERROR THEN
6303: RAISE FND_API.G_EXC_ERROR;
6304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6301: EXCEPTION
6302: WHEN FND_API.G_EXC_ERROR THEN
6303: RAISE FND_API.G_EXC_ERROR;
6304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6312: END get_party_for_search;
6313:
6314: PROCEDURE get_search_criteria (
6315: p_party_id IN NUMBER,

Line 6354: WHEN FND_API.G_EXC_ERROR THEN

6350: END IF;
6351: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6352: END IF;
6353: EXCEPTION
6354: WHEN FND_API.G_EXC_ERROR THEN
6355: RAISE FND_API.G_EXC_ERROR;
6356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: WHEN OTHERS THEN

Line 6355: RAISE FND_API.G_EXC_ERROR;

6351: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6352: END IF;
6353: EXCEPTION
6354: WHEN FND_API.G_EXC_ERROR THEN
6355: RAISE FND_API.G_EXC_ERROR;
6356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6352: END IF;
6353: EXCEPTION
6354: WHEN FND_API.G_EXC_ERROR THEN
6355: RAISE FND_API.G_EXC_ERROR;
6356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6353: EXCEPTION
6354: WHEN FND_API.G_EXC_ERROR THEN
6355: RAISE FND_API.G_EXC_ERROR;
6356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6364: END get_search_criteria;
6365:
6366:
6367: /************************************************

Line 6428: RAISE FND_API.G_EXC_ERROR;

6424: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6425: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6427: FND_MSG_PUB.ADD;
6428: RAISE FND_API.G_EXC_ERROR;
6429: END get_party_rec;
6430:
6431: /************************************************
6432: This procedure retrieves the match rule party site attributes into

Line 6492: RAISE FND_API.G_EXC_ERROR;

6488: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6489: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6491: FND_MSG_PUB.ADD;
6492: RAISE FND_API.G_EXC_ERROR;
6493: END get_party_site_rec;
6494:
6495: /************************************************
6496: This procedure retrieves the match rule contact attributes into

Line 6550: RAISE FND_API.G_EXC_ERROR;

6546: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6547: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_ERROR;
6551: END get_contact_rec;
6552:
6553: /************************************************
6554: This procedure retrieves the match rule contact point attributes into

Line 6606: RAISE FND_API.G_EXC_ERROR;

6602: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6603: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6605: FND_MSG_PUB.ADD;
6606: RAISE FND_API.G_EXC_ERROR;
6607: END get_contact_point_rec;
6608:
6609: /************************************************
6610: This procedure maps a search record from the logical

Line 6780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6776: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6777: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6778: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6779: FND_MSG_PUB.ADD;
6780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6781: END;
6782:
6783:
6784: /************************************************

Line 7021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7017: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7018: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7020: FND_MSG_PUB.ADD;
7021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7022: END;
7023:
7024:
7025: /************************************************

Line 7078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7074: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7075: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7076: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7077: FND_MSG_PUB.ADD;
7078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7079: END;
7080:
7081:
7082: /************************************************

Line 7209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7208: FND_MSG_PUB.ADD;
7209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7210: END;
7211:
7212:
7213: /************************************************

Line 7234: RAISE FND_API.G_EXC_ERROR;

7230: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7231: ) THEN
7232: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7233: FND_MSG_PUB.ADD;
7234: RAISE FND_API.G_EXC_ERROR;
7235: END IF;
7236: END LOOP;
7237:
7238: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 7297: WHEN FND_API.G_EXC_ERROR THEN

7293: END IF;
7294: END LOOP;
7295: RETURN FALSE;
7296: EXCEPTION
7297: WHEN FND_API.G_EXC_ERROR THEN
7298: RAISE FND_API.G_EXC_ERROR;
7299: WHEN OTHERS THEN
7300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7301: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 7298: RAISE FND_API.G_EXC_ERROR;

7294: END LOOP;
7295: RETURN FALSE;
7296: EXCEPTION
7297: WHEN FND_API.G_EXC_ERROR THEN
7298: RAISE FND_API.G_EXC_ERROR;
7299: WHEN OTHERS THEN
7300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7301: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 7304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7301: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7303: FND_MSG_PUB.ADD;
7304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7305: END check_prim_cond;
7306:
7307: /************************************************
7308: This procedure checks if the input search condition

Line 7368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7365: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7367: FND_MSG_PUB.ADD;
7368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7369: END check_party_site_cond;
7370:
7371: /************************************************
7372: This procedure checks if the input search condition

Line 7424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7421: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7423: FND_MSG_PUB.ADD;
7424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7425: END check_contact_cond;
7426:
7427: /************************************************
7428: This procedure checks if the input search condition

Line 7445: RAISE FND_API.G_EXC_ERROR;

7441: FOR I IN 1..p_contact_point_list.COUNT LOOP
7442: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7443: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7444: FND_MSG_PUB.ADD;
7445: RAISE FND_API.G_EXC_ERROR;
7446: END IF;
7447: END LOOP;
7448:
7449: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7468: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7470: FND_MSG_PUB.ADD;
7471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7472: END check_contact_point_cond;
7473:
7474: FUNCTION check_staged RETURN BOOLEAN IS
7475: