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_33 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 1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1017: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1018: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END;
1023:
1024:
1025: /************************************************

Line 1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1042: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1043: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1045: FND_MSG_PUB.ADD;
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END;
1048:
1049:
1050: /************************************************

Line 1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1062: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1063: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1065: FND_MSG_PUB.ADD;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END;
1068:
1069:
1070: /************************************************

Line 1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1082: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1083: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1085: FND_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END;
1088:
1089: PROCEDURE init_score_context (
1090: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1153: RAISE FND_API.G_EXC_ERROR;

1149: p_contact_list,
1150: p_contact_point_list) THEN
1151: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: 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);
1157: END IF;

Line 1422: RAISE FND_API.G_EXC_ERROR;

1418: IF lengthb(l_party_contains_str) > 4000 THEN
1419: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1420: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1421: FND_MSG_PUB.ADD;
1422: RAISE FND_API.G_EXC_ERROR;
1423: END IF;
1424: IF (p_match_str = ' AND ' OR p_party_max_score 1425: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1426: 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 1528: RAISE FND_API.G_EXC_ERROR;

1524: IF lengthb(l_contains_str) > 4000 THEN
1525: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1526: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1527: FND_MSG_PUB.ADD;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530: x_denorm_str := l_den_contains_str;
1531: RETURN l_contains_str;
1532: END;

Line 1574: RAISE FND_API.G_EXC_ERROR;

1570: IF lengthb(l_contains_str) > 4000 THEN
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1572: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;
1576: x_denorm_str := l_den_contains_str;
1577: RETURN l_contains_str;
1578: END;

Line 1655: RAISE FND_API.G_EXC_ERROR;

1651: IF lengthb(l_contains_str) > 4000 THEN
1652: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1653: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_ERROR;
1656: END IF;
1657: x_denorm_str := l_den_contains_str;
1658: RETURN l_contains_str;
1659: END;

Line 1915: RAISE FND_API.G_EXC_ERROR;

1911: when others then
1912: if (instrb(SQLERRM,'DRG-51030')>0) then
1913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1914: FND_MSG_PUB.ADD;
1915: RAISE FND_API.G_EXC_ERROR;
1916: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1917: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1918: FND_MSG_PUB.ADD;
1919: RAISE FND_API.G_EXC_ERROR;

Line 1919: RAISE FND_API.G_EXC_ERROR;

1915: RAISE FND_API.G_EXC_ERROR;
1916: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1917: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1918: FND_MSG_PUB.ADD;
1919: RAISE FND_API.G_EXC_ERROR;
1920: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1922: FND_MSG_PUB.ADD;
1923: RAISE FND_API.G_EXC_ERROR;

Line 1923: RAISE FND_API.G_EXC_ERROR;

1919: RAISE FND_API.G_EXC_ERROR;
1920: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1922: FND_MSG_PUB.ADD;
1923: RAISE FND_API.G_EXC_ERROR;
1924: else
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;

Line 1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1924: else
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: end if;
1930: END;
1931:
1932: PROCEDURE open_party_site_cursor(

Line 2160: RAISE FND_API.G_EXC_ERROR;

2156: when others then
2157: if (instrb(SQLERRM,'DRG-51030')>0) then
2158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2159: FND_MSG_PUB.ADD;
2160: RAISE FND_API.G_EXC_ERROR;
2161: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;

Line 2164: RAISE FND_API.G_EXC_ERROR;

2160: RAISE FND_API.G_EXC_ERROR;
2161: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2167: FND_MSG_PUB.ADD;
2168: RAISE FND_API.G_EXC_ERROR;

Line 2168: RAISE FND_API.G_EXC_ERROR;

2164: RAISE FND_API.G_EXC_ERROR;
2165: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2167: FND_MSG_PUB.ADD;
2168: RAISE FND_API.G_EXC_ERROR;
2169: else
2170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2172: FND_MSG_PUB.ADD;

Line 2173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2169: else
2170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2172: FND_MSG_PUB.ADD;
2173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2174: end if;
2175: END;
2176:
2177: PROCEDURE open_contact_cursor(

Line 2307: RAISE FND_API.G_EXC_ERROR;

2303: when others then
2304: if (instrb(SQLERRM,'DRG-51030')>0) then
2305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2309: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2310: FND_MSG_PUB.ADD;
2311: RAISE FND_API.G_EXC_ERROR;

Line 2311: RAISE FND_API.G_EXC_ERROR;

2307: RAISE FND_API.G_EXC_ERROR;
2308: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2309: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2310: FND_MSG_PUB.ADD;
2311: RAISE FND_API.G_EXC_ERROR;
2312: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2314: FND_MSG_PUB.ADD;
2315: RAISE FND_API.G_EXC_ERROR;

Line 2315: RAISE FND_API.G_EXC_ERROR;

2311: RAISE FND_API.G_EXC_ERROR;
2312: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2314: FND_MSG_PUB.ADD;
2315: RAISE FND_API.G_EXC_ERROR;
2316: else
2317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2319: FND_MSG_PUB.ADD;

Line 2320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2316: else
2317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2319: FND_MSG_PUB.ADD;
2320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2321: end if;
2322: END;
2323:
2324: PROCEDURE open_contact_pt_cursor(

Line 2580: RAISE FND_API.G_EXC_ERROR;

2576: when others then
2577: if (instrb(SQLERRM,'DRG-51030')>0) then
2578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2579: FND_MSG_PUB.ADD;
2580: RAISE FND_API.G_EXC_ERROR;
2581: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;

Line 2584: RAISE FND_API.G_EXC_ERROR;

2580: RAISE FND_API.G_EXC_ERROR;
2581: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2586: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2587: FND_MSG_PUB.ADD;
2588: RAISE FND_API.G_EXC_ERROR;

Line 2588: RAISE FND_API.G_EXC_ERROR;

2584: RAISE FND_API.G_EXC_ERROR;
2585: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2586: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2587: FND_MSG_PUB.ADD;
2588: RAISE FND_API.G_EXC_ERROR;
2589: else
2590: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2592: FND_MSG_PUB.ADD;

Line 2593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2589: else
2590: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2592: FND_MSG_PUB.ADD;
2593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2594: end if;
2595: END;
2596:
2597:

Line 2854: RAISE FND_API.G_EXC_ERROR;

2850: 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);
2851: END IF;
2852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2853: FND_MSG_PUB.ADD;
2854: RAISE FND_API.G_EXC_ERROR;
2855: ELSE
2856: push_eval;
2857: RETURN;
2858: END IF;

Line 2902: RAISE FND_API.G_EXC_ERROR;

2898: 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);
2899: END IF;
2900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2901: FND_MSG_PUB.ADD;
2902: RAISE FND_API.G_EXC_ERROR;
2903: ELSE
2904: push_eval;
2905: RETURN;
2906: END IF;

Line 2975: RAISE FND_API.G_EXC_ERROR;

2971: 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);
2972: END IF;
2973: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: ELSE
2977: push_eval;
2978: RETURN;
2979: END IF;

Line 3087: RAISE FND_API.G_EXC_ERROR;

3083: 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);
3084: END IF;
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3086: FND_MSG_PUB.ADD;
3087: RAISE FND_API.G_EXC_ERROR;
3088: ELSE
3089: push_eval;
3090: RETURN;
3091: END IF;

Line 3198: RAISE FND_API.G_EXC_ERROR;

3194: 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);
3195: END IF;
3196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: ELSE
3200: push_eval;
3201: RETURN;
3202: END IF;

Line 3423: RAISE FND_API.G_EXC_ERROR;

3419: 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);
3420: END IF;
3421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3422: FND_MSG_PUB.ADD;
3423: RAISE FND_API.G_EXC_ERROR;
3424: END IF;
3425: ELSE
3426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3427: 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 3431: RAISE FND_API.G_EXC_ERROR;

3427: 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);
3428: END IF;
3429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3430: FND_MSG_PUB.ADD;
3431: RAISE FND_API.G_EXC_ERROR;
3432: END IF;
3433: END IF;
3434: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3435: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3630: WHEN FND_API.G_EXC_ERROR THEN

3626: END IF;
3627: EXCEPTION
3628: WHEN L_RETURN_IMM_EXC THEN
3629: RETURN;
3630: WHEN FND_API.G_EXC_ERROR THEN
3631: RAISE FND_API.G_EXC_ERROR;
3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3634: WHEN OTHERS THEN

Line 3631: RAISE FND_API.G_EXC_ERROR;

3627: EXCEPTION
3628: WHEN L_RETURN_IMM_EXC THEN
3629: RETURN;
3630: WHEN FND_API.G_EXC_ERROR THEN
3631: RAISE FND_API.G_EXC_ERROR;
3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3634: WHEN OTHERS THEN
3635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3628: WHEN L_RETURN_IMM_EXC THEN
3629: RETURN;
3630: WHEN FND_API.G_EXC_ERROR THEN
3631: RAISE FND_API.G_EXC_ERROR;
3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3634: WHEN OTHERS THEN
3635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3636: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');

Line 3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3629: RETURN;
3630: WHEN FND_API.G_EXC_ERROR THEN
3631: RAISE FND_API.G_EXC_ERROR;
3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3634: WHEN OTHERS THEN
3635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3636: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3636: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3638: FND_MSG_PUB.ADD;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3640: END find_parties;
3641:
3642: PROCEDURE find_persons (
3643: p_rule_id IN NUMBER,

Line 3840: RAISE FND_API.G_EXC_ERROR;

3836: 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);
3837: END IF;
3838: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3839: FND_MSG_PUB.ADD;
3840: RAISE FND_API.G_EXC_ERROR;
3841: ELSE
3842: push_eval;
3843: RETURN;
3844: END IF;

Line 3888: RAISE FND_API.G_EXC_ERROR;

3884: 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);
3885: END IF;
3886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3887: FND_MSG_PUB.ADD;
3888: RAISE FND_API.G_EXC_ERROR;
3889: ELSE
3890: push_eval;
3891: RETURN;
3892: END IF;

Line 3924: RAISE FND_API.G_EXC_ERROR;

3920: when others then
3921: if (instrb(SQLERRM,'DRG-51030')>0) then
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3923: FND_MSG_PUB.ADD;
3924: RAISE FND_API.G_EXC_ERROR;
3925: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_ERROR;

Line 3928: RAISE FND_API.G_EXC_ERROR;

3924: RAISE FND_API.G_EXC_ERROR;
3925: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_ERROR;
3929: else
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: end if;
3932: END;

Line 3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_ERROR;
3929: else
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: end if;
3932: END;
3933:
3934: /** Private procedure to acquire and score at party site level ***/

Line 4000: RAISE FND_API.G_EXC_ERROR;

3996: 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);
3997: END IF;
3998: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3999: FND_MSG_PUB.ADD;
4000: RAISE FND_API.G_EXC_ERROR;
4001: ELSE
4002: push_eval;
4003: RETURN;
4004: END IF;

Line 4259: RAISE FND_API.G_EXC_ERROR;

4255: 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);
4256: END IF;
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4258: FND_MSG_PUB.ADD;
4259: RAISE FND_API.G_EXC_ERROR;
4260: ELSE
4261: push_eval;
4262: RETURN;
4263: END IF;

Line 4372: RAISE FND_API.G_EXC_ERROR;

4368: 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);
4369: END IF;
4370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4371: FND_MSG_PUB.ADD;
4372: RAISE FND_API.G_EXC_ERROR;
4373: END IF;
4374: ELSE
4375: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4376: 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 4380: RAISE FND_API.G_EXC_ERROR;

4376: 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);
4377: END IF;
4378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4379: FND_MSG_PUB.ADD;
4380: RAISE FND_API.G_EXC_ERROR;
4381: END IF;
4382: END IF;
4383: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4384: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4494: WHEN FND_API.G_EXC_ERROR THEN

4490: END IF;
4491: EXCEPTION
4492: WHEN L_RETURN_IMM_EXC THEN
4493: RETURN;
4494: WHEN FND_API.G_EXC_ERROR THEN
4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: WHEN OTHERS THEN

Line 4495: RAISE FND_API.G_EXC_ERROR;

4491: EXCEPTION
4492: WHEN L_RETURN_IMM_EXC THEN
4493: RETURN;
4494: WHEN FND_API.G_EXC_ERROR THEN
4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: WHEN OTHERS THEN
4499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4492: WHEN L_RETURN_IMM_EXC THEN
4493: RETURN;
4494: WHEN FND_API.G_EXC_ERROR THEN
4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: WHEN OTHERS THEN
4499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4500: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');

Line 4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4493: RETURN;
4494: WHEN FND_API.G_EXC_ERROR THEN
4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: WHEN OTHERS THEN
4499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4500: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4500: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4502: FND_MSG_PUB.ADD;
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: END find_persons;
4505:
4506: PROCEDURE find_persons (
4507: p_rule_id IN NUMBER,

Line 4562: WHEN FND_API.G_EXC_ERROR THEN

4558: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4559: 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);
4560: END IF;
4561: EXCEPTION
4562: WHEN FND_API.G_EXC_ERROR THEN
4563: RAISE FND_API.G_EXC_ERROR;
4564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4566: WHEN OTHERS THEN

Line 4563: RAISE FND_API.G_EXC_ERROR;

4559: 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);
4560: END IF;
4561: EXCEPTION
4562: WHEN FND_API.G_EXC_ERROR THEN
4563: RAISE FND_API.G_EXC_ERROR;
4564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4566: WHEN OTHERS THEN
4567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4560: END IF;
4561: EXCEPTION
4562: WHEN FND_API.G_EXC_ERROR THEN
4563: RAISE FND_API.G_EXC_ERROR;
4564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4566: WHEN OTHERS THEN
4567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4568: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');

Line 4565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4561: EXCEPTION
4562: WHEN FND_API.G_EXC_ERROR THEN
4563: RAISE FND_API.G_EXC_ERROR;
4564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4566: WHEN OTHERS THEN
4567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4568: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4568: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4570: FND_MSG_PUB.ADD;
4571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4572: END find_party_details;
4573:
4574: PROCEDURE find_duplicate_parties (
4575: p_rule_id IN NUMBER,

Line 4679: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4680: RAISE FND_API.G_EXC_ERROR;

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

Line 4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4677: END IF;
4678: EXCEPTION
4679: WHEN FND_API.G_EXC_ERROR THEN
4680: RAISE FND_API.G_EXC_ERROR;
4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4683: WHEN OTHERS THEN
4684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4685: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');

Line 4682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4678: EXCEPTION
4679: WHEN FND_API.G_EXC_ERROR THEN
4680: RAISE FND_API.G_EXC_ERROR;
4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4683: WHEN OTHERS THEN
4684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4685: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4686: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4685: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4686: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4687: FND_MSG_PUB.ADD;
4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4689: END find_duplicate_parties;
4690:
4691: PROCEDURE find_duplicate_party_sites (
4692: p_rule_id IN NUMBER,

Line 4764: WHEN FND_API.G_EXC_ERROR THEN

4760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4761: 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);
4762: END IF;
4763: EXCEPTION
4764: WHEN FND_API.G_EXC_ERROR THEN
4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN

Line 4765: RAISE FND_API.G_EXC_ERROR;

4761: 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);
4762: END IF;
4763: EXCEPTION
4764: WHEN FND_API.G_EXC_ERROR THEN
4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4762: END IF;
4763: EXCEPTION
4764: WHEN FND_API.G_EXC_ERROR THEN
4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');

Line 4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4763: EXCEPTION
4764: WHEN FND_API.G_EXC_ERROR THEN
4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4774: END find_duplicate_party_sites;
4775:
4776: PROCEDURE find_duplicate_contacts (
4777: p_rule_id IN NUMBER,

Line 4853: WHEN FND_API.G_EXC_ERROR THEN

4849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4850: 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);
4851: END IF;
4852: EXCEPTION
4853: WHEN FND_API.G_EXC_ERROR THEN
4854: RAISE FND_API.G_EXC_ERROR;
4855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: WHEN OTHERS THEN

Line 4854: RAISE FND_API.G_EXC_ERROR;

4850: 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);
4851: END IF;
4852: EXCEPTION
4853: WHEN FND_API.G_EXC_ERROR THEN
4854: RAISE FND_API.G_EXC_ERROR;
4855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: WHEN OTHERS THEN
4858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4851: END IF;
4852: EXCEPTION
4853: WHEN FND_API.G_EXC_ERROR THEN
4854: RAISE FND_API.G_EXC_ERROR;
4855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: WHEN OTHERS THEN
4858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4859: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');

Line 4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4852: EXCEPTION
4853: WHEN FND_API.G_EXC_ERROR THEN
4854: RAISE FND_API.G_EXC_ERROR;
4855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: WHEN OTHERS THEN
4858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4859: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4859: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4861: FND_MSG_PUB.ADD;
4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4863: END find_duplicate_contacts;
4864:
4865: PROCEDURE find_duplicate_contact_points (
4866: p_rule_id IN NUMBER,

Line 4926: WHEN FND_API.G_EXC_ERROR THEN

4922: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4923: 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);
4924: END IF;
4925: EXCEPTION
4926: WHEN FND_API.G_EXC_ERROR THEN
4927: RAISE FND_API.G_EXC_ERROR;
4928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930: WHEN OTHERS THEN

Line 4927: RAISE FND_API.G_EXC_ERROR;

4923: 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);
4924: END IF;
4925: EXCEPTION
4926: WHEN FND_API.G_EXC_ERROR THEN
4927: RAISE FND_API.G_EXC_ERROR;
4928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930: WHEN OTHERS THEN
4931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4924: END IF;
4925: EXCEPTION
4926: WHEN FND_API.G_EXC_ERROR THEN
4927: RAISE FND_API.G_EXC_ERROR;
4928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930: WHEN OTHERS THEN
4931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');

Line 4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4925: EXCEPTION
4926: WHEN FND_API.G_EXC_ERROR THEN
4927: RAISE FND_API.G_EXC_ERROR;
4928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930: WHEN OTHERS THEN
4931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4934: FND_MSG_PUB.ADD;
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4936: END find_duplicate_contact_points;
4937:
4938: PROCEDURE find_parties_dynamic (
4939: p_rule_id IN NUMBER,

Line 5283: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5284: RAISE FND_API.G_EXC_ERROR;

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

Line 5285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5291: FND_MSG_PUB.ADD;
5292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5293: END call_api_dynamic;
5294:
5295:
5296: PROCEDURE get_matching_party_sites (

Line 5527: WHEN FND_API.G_EXC_ERROR THEN

5523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5524: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5525: END IF;
5526: EXCEPTION
5527: WHEN FND_API.G_EXC_ERROR THEN
5528: RAISE FND_API.G_EXC_ERROR;
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN

Line 5528: RAISE FND_API.G_EXC_ERROR;

5524: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5525: END IF;
5526: EXCEPTION
5527: WHEN FND_API.G_EXC_ERROR THEN
5528: RAISE FND_API.G_EXC_ERROR;
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_party_sites');
5534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5535: FND_MSG_PUB.ADD;
5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5537: END get_matching_party_sites;
5538:
5539:
5540: PROCEDURE get_matching_contacts (

Line 5755: WHEN FND_API.G_EXC_ERROR THEN

5751: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5752: 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);
5753: END IF;
5754: EXCEPTION
5755: WHEN FND_API.G_EXC_ERROR THEN
5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5759: WHEN OTHERS THEN

Line 5756: RAISE FND_API.G_EXC_ERROR;

5752: 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);
5753: END IF;
5754: EXCEPTION
5755: WHEN FND_API.G_EXC_ERROR THEN
5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5753: END IF;
5754: EXCEPTION
5755: WHEN FND_API.G_EXC_ERROR THEN
5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');

Line 5758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5754: EXCEPTION
5755: WHEN FND_API.G_EXC_ERROR THEN
5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: END get_matching_contacts;
5766:
5767:
5768: PROCEDURE get_matching_contact_points (

Line 5897: WHEN FND_API.G_EXC_ERROR THEN

5893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5894: 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);
5895: END IF;
5896: EXCEPTION
5897: WHEN FND_API.G_EXC_ERROR THEN
5898: RAISE FND_API.G_EXC_ERROR;
5899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: WHEN OTHERS THEN

Line 5898: RAISE FND_API.G_EXC_ERROR;

5894: 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);
5895: END IF;
5896: EXCEPTION
5897: WHEN FND_API.G_EXC_ERROR THEN
5898: RAISE FND_API.G_EXC_ERROR;
5899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: WHEN OTHERS THEN
5902: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5895: END IF;
5896: EXCEPTION
5897: WHEN FND_API.G_EXC_ERROR THEN
5898: RAISE FND_API.G_EXC_ERROR;
5899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: WHEN OTHERS THEN
5902: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5903: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');

Line 5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5896: EXCEPTION
5897: WHEN FND_API.G_EXC_ERROR THEN
5898: RAISE FND_API.G_EXC_ERROR;
5899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: WHEN OTHERS THEN
5902: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5903: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5904: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5902: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5903: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5904: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: END get_matching_contact_points;
5908:
5909: /**********************************************************
5910: This procedure finds the score details for a specific party that

Line 6135: WHEN FND_API.G_EXC_ERROR THEN

6131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6132: 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);
6133: END IF;
6134: EXCEPTION
6135: WHEN FND_API.G_EXC_ERROR THEN
6136: RAISE FND_API.G_EXC_ERROR;
6137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6139: WHEN OTHERS THEN

Line 6136: RAISE FND_API.G_EXC_ERROR;

6132: 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);
6133: END IF;
6134: EXCEPTION
6135: WHEN FND_API.G_EXC_ERROR THEN
6136: RAISE FND_API.G_EXC_ERROR;
6137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6133: END IF;
6134: EXCEPTION
6135: WHEN FND_API.G_EXC_ERROR THEN
6136: RAISE FND_API.G_EXC_ERROR;
6137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');

Line 6138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6134: EXCEPTION
6135: WHEN FND_API.G_EXC_ERROR THEN
6136: RAISE FND_API.G_EXC_ERROR;
6137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;
6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6145: END get_score_details;
6146:
6147:
6148: /************************************************

Line 6258: WHEN FND_API.G_EXC_ERROR THEN

6254: END LOOP;
6255: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6256: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6257: EXCEPTION
6258: WHEN FND_API.G_EXC_ERROR THEN
6259: RAISE FND_API.G_EXC_ERROR;
6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: WHEN OTHERS THEN

Line 6259: RAISE FND_API.G_EXC_ERROR;

6255: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6256: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6257: EXCEPTION
6258: WHEN FND_API.G_EXC_ERROR THEN
6259: RAISE FND_API.G_EXC_ERROR;
6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: WHEN OTHERS THEN
6263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6256: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6257: EXCEPTION
6258: WHEN FND_API.G_EXC_ERROR THEN
6259: RAISE FND_API.G_EXC_ERROR;
6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: WHEN OTHERS THEN
6263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6264: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6257: EXCEPTION
6258: WHEN FND_API.G_EXC_ERROR THEN
6259: RAISE FND_API.G_EXC_ERROR;
6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: WHEN OTHERS THEN
6263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6264: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6264: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6266: FND_MSG_PUB.ADD;
6267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6268: END get_party_for_search;
6269:
6270: PROCEDURE get_search_criteria (
6271: p_party_id IN NUMBER,

Line 6310: WHEN FND_API.G_EXC_ERROR THEN

6306: END IF;
6307: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6308: END IF;
6309: EXCEPTION
6310: WHEN FND_API.G_EXC_ERROR THEN
6311: RAISE FND_API.G_EXC_ERROR;
6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6314: WHEN OTHERS THEN

Line 6311: RAISE FND_API.G_EXC_ERROR;

6307: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6308: END IF;
6309: EXCEPTION
6310: WHEN FND_API.G_EXC_ERROR THEN
6311: RAISE FND_API.G_EXC_ERROR;
6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6308: END IF;
6309: EXCEPTION
6310: WHEN FND_API.G_EXC_ERROR THEN
6311: RAISE FND_API.G_EXC_ERROR;
6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6309: EXCEPTION
6310: WHEN FND_API.G_EXC_ERROR THEN
6311: RAISE FND_API.G_EXC_ERROR;
6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6320: END get_search_criteria;
6321:
6322:
6323: /************************************************

Line 6382: RAISE FND_API.G_EXC_ERROR;

6378: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6379: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6381: FND_MSG_PUB.ADD;
6382: RAISE FND_API.G_EXC_ERROR;
6383: END get_party_rec;
6384:
6385: /************************************************
6386: This procedure retrieves the match rule party site attributes into

Line 6446: RAISE FND_API.G_EXC_ERROR;

6442: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6443: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6445: FND_MSG_PUB.ADD;
6446: RAISE FND_API.G_EXC_ERROR;
6447: END get_party_site_rec;
6448:
6449: /************************************************
6450: This procedure retrieves the match rule contact attributes into

Line 6504: RAISE FND_API.G_EXC_ERROR;

6500: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6501: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6503: FND_MSG_PUB.ADD;
6504: RAISE FND_API.G_EXC_ERROR;
6505: END get_contact_rec;
6506:
6507: /************************************************
6508: This procedure retrieves the match rule contact point attributes into

Line 6560: RAISE FND_API.G_EXC_ERROR;

6556: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6557: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6559: FND_MSG_PUB.ADD;
6560: RAISE FND_API.G_EXC_ERROR;
6561: END get_contact_point_rec;
6562:
6563: /************************************************
6564: This procedure maps a search record from the logical

Line 6755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6751: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6752: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6753: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6756: END;
6757:
6758:
6759: /************************************************

Line 6994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6990: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6991: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6993: FND_MSG_PUB.ADD;
6994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6995: END;
6996:
6997:
6998: /************************************************

Line 7097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7093: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7094: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7096: FND_MSG_PUB.ADD;
7097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7098: END;
7099:
7100:
7101: /************************************************

Line 7228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7224: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7225: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7226: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7227: FND_MSG_PUB.ADD;
7228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7229: END;
7230:
7231:
7232: /************************************************

Line 7253: RAISE FND_API.G_EXC_ERROR;

7249: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7250: ) THEN
7251: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7252: FND_MSG_PUB.ADD;
7253: RAISE FND_API.G_EXC_ERROR;
7254: END IF;
7255: END LOOP;
7256:
7257: IF p_party_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN

Line 7316: WHEN FND_API.G_EXC_ERROR THEN

7312: END IF;
7313: END LOOP;
7314: RETURN FALSE;
7315: EXCEPTION
7316: WHEN FND_API.G_EXC_ERROR THEN
7317: RAISE FND_API.G_EXC_ERROR;
7318: WHEN OTHERS THEN
7319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7320: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 7317: RAISE FND_API.G_EXC_ERROR;

7313: END LOOP;
7314: RETURN FALSE;
7315: EXCEPTION
7316: WHEN FND_API.G_EXC_ERROR THEN
7317: RAISE FND_API.G_EXC_ERROR;
7318: WHEN OTHERS THEN
7319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7320: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 7323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7320: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7322: FND_MSG_PUB.ADD;
7323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7324: END check_prim_cond;
7325:
7326: /************************************************
7327: This procedure checks if the input search condition

Line 7387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7384: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7386: FND_MSG_PUB.ADD;
7387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7388: END check_party_site_cond;
7389:
7390: /************************************************
7391: This procedure checks if the input search condition

Line 7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7444: END check_contact_cond;
7445:
7446: /************************************************
7447: This procedure checks if the input search condition

Line 7464: RAISE FND_API.G_EXC_ERROR;

7460: FOR I IN 1..p_contact_point_list.COUNT LOOP
7461: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7462: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7463: FND_MSG_PUB.ADD;
7464: RAISE FND_API.G_EXC_ERROR;
7465: END IF;
7466: END LOOP;
7467:
7468: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7487: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7489: FND_MSG_PUB.ADD;
7490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7491: END check_contact_point_cond;
7492:
7493: FUNCTION check_staged RETURN BOOLEAN IS
7494: