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

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

Line 1921: RAISE FND_API.G_EXC_ERROR;

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

Line 1925: RAISE FND_API.G_EXC_ERROR;

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

Line 1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2162: RAISE FND_API.G_EXC_ERROR;

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

Line 2166: RAISE FND_API.G_EXC_ERROR;

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

Line 2170: RAISE FND_API.G_EXC_ERROR;

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

Line 2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2309: RAISE FND_API.G_EXC_ERROR;

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

Line 2313: RAISE FND_API.G_EXC_ERROR;

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

Line 2317: RAISE FND_API.G_EXC_ERROR;

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

Line 2322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2582: RAISE FND_API.G_EXC_ERROR;

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

Line 2586: RAISE FND_API.G_EXC_ERROR;

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

Line 2590: RAISE FND_API.G_EXC_ERROR;

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

Line 2595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2857: RAISE FND_API.G_EXC_ERROR;

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

Line 2907: RAISE FND_API.G_EXC_ERROR;

2903: 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);
2904: END IF;
2905: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2906: FND_MSG_PUB.ADD;
2907: RAISE FND_API.G_EXC_ERROR;
2908: ELSE
2909: push_eval;
2910: RETURN;
2911: END IF;

Line 2980: RAISE FND_API.G_EXC_ERROR;

2976: 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);
2977: END IF;
2978: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2979: FND_MSG_PUB.ADD;
2980: RAISE FND_API.G_EXC_ERROR;
2981: ELSE
2982: push_eval;
2983: RETURN;
2984: END IF;

Line 3092: RAISE FND_API.G_EXC_ERROR;

3088: 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);
3089: END IF;
3090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3091: FND_MSG_PUB.ADD;
3092: RAISE FND_API.G_EXC_ERROR;
3093: ELSE
3094: push_eval;
3095: RETURN;
3096: END IF;

Line 3203: RAISE FND_API.G_EXC_ERROR;

3199: 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);
3200: END IF;
3201: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3202: FND_MSG_PUB.ADD;
3203: RAISE FND_API.G_EXC_ERROR;
3204: ELSE
3205: push_eval;
3206: RETURN;
3207: END IF;

Line 3428: RAISE FND_API.G_EXC_ERROR;

3424: 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);
3425: END IF;
3426: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3427: FND_MSG_PUB.ADD;
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430: ELSE
3431: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3432: 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 3436: RAISE FND_API.G_EXC_ERROR;

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

Line 3635: WHEN FND_API.G_EXC_ERROR THEN

3631: END IF;
3632: EXCEPTION
3633: WHEN L_RETURN_IMM_EXC THEN
3634: RETURN;
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN

Line 3636: RAISE FND_API.G_EXC_ERROR;

3632: EXCEPTION
3633: WHEN L_RETURN_IMM_EXC THEN
3634: RETURN;
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3633: WHEN L_RETURN_IMM_EXC THEN
3634: RETURN;
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');

Line 3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3634: RETURN;
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END find_parties;
3646:
3647: PROCEDURE find_persons (
3648: p_rule_id IN NUMBER,

Line 3846: RAISE FND_API.G_EXC_ERROR;

3842: 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);
3843: END IF;
3844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3845: FND_MSG_PUB.ADD;
3846: RAISE FND_API.G_EXC_ERROR;
3847: ELSE
3848: push_eval;
3849: RETURN;
3850: END IF;

Line 3896: RAISE FND_API.G_EXC_ERROR;

3892: 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);
3893: END IF;
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3895: FND_MSG_PUB.ADD;
3896: RAISE FND_API.G_EXC_ERROR;
3897: ELSE
3898: push_eval;
3899: RETURN;
3900: END IF;

Line 3932: RAISE FND_API.G_EXC_ERROR;

3928: when others then
3929: if (instrb(SQLERRM,'DRG-51030')>0) then
3930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3931: FND_MSG_PUB.ADD;
3932: RAISE FND_API.G_EXC_ERROR;
3933: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;

Line 3936: RAISE FND_API.G_EXC_ERROR;

3932: RAISE FND_API.G_EXC_ERROR;
3933: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;
3937: else
3938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3939: end if;
3940: END;

Line 3938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;
3937: else
3938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3939: end if;
3940: END;
3941:
3942: /** Private procedure to acquire and score at party site level ***/

Line 4008: RAISE FND_API.G_EXC_ERROR;

4004: 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);
4005: END IF;
4006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4007: FND_MSG_PUB.ADD;
4008: RAISE FND_API.G_EXC_ERROR;
4009: ELSE
4010: push_eval;
4011: RETURN;
4012: END IF;

Line 4267: RAISE FND_API.G_EXC_ERROR;

4263: 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);
4264: END IF;
4265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4266: FND_MSG_PUB.ADD;
4267: RAISE FND_API.G_EXC_ERROR;
4268: ELSE
4269: push_eval;
4270: RETURN;
4271: END IF;

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: ELSE
4383: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4384: 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 4388: RAISE FND_API.G_EXC_ERROR;

4384: 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);
4385: END IF;
4386: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4387: FND_MSG_PUB.ADD;
4388: RAISE FND_API.G_EXC_ERROR;
4389: END IF;
4390: END IF;
4391: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4392: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4502: WHEN FND_API.G_EXC_ERROR THEN

4498: END IF;
4499: EXCEPTION
4500: WHEN L_RETURN_IMM_EXC THEN
4501: RETURN;
4502: WHEN FND_API.G_EXC_ERROR THEN
4503: RAISE FND_API.G_EXC_ERROR;
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4506: WHEN OTHERS THEN

Line 4503: RAISE FND_API.G_EXC_ERROR;

4499: EXCEPTION
4500: WHEN L_RETURN_IMM_EXC THEN
4501: RETURN;
4502: WHEN FND_API.G_EXC_ERROR THEN
4503: RAISE FND_API.G_EXC_ERROR;
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4506: WHEN OTHERS THEN
4507: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4500: WHEN L_RETURN_IMM_EXC THEN
4501: RETURN;
4502: WHEN FND_API.G_EXC_ERROR THEN
4503: RAISE FND_API.G_EXC_ERROR;
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4506: WHEN OTHERS THEN
4507: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4508: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');

Line 4505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4501: RETURN;
4502: WHEN FND_API.G_EXC_ERROR THEN
4503: RAISE FND_API.G_EXC_ERROR;
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4506: WHEN OTHERS THEN
4507: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4508: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4507: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4508: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4510: FND_MSG_PUB.ADD;
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: END find_persons;
4513:
4514: PROCEDURE find_persons (
4515: p_rule_id IN NUMBER,

Line 4570: WHEN FND_API.G_EXC_ERROR THEN

4566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4567: 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);
4568: END IF;
4569: EXCEPTION
4570: WHEN FND_API.G_EXC_ERROR THEN
4571: RAISE FND_API.G_EXC_ERROR;
4572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4574: WHEN OTHERS THEN

Line 4571: RAISE FND_API.G_EXC_ERROR;

4567: 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);
4568: END IF;
4569: EXCEPTION
4570: WHEN FND_API.G_EXC_ERROR THEN
4571: RAISE FND_API.G_EXC_ERROR;
4572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4574: WHEN OTHERS THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4568: END IF;
4569: EXCEPTION
4570: WHEN FND_API.G_EXC_ERROR THEN
4571: RAISE FND_API.G_EXC_ERROR;
4572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4574: WHEN OTHERS THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4576: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');

Line 4573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4569: EXCEPTION
4570: WHEN FND_API.G_EXC_ERROR THEN
4571: RAISE FND_API.G_EXC_ERROR;
4572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4574: WHEN OTHERS THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4576: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4576: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4578: FND_MSG_PUB.ADD;
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: END find_party_details;
4581:
4582: PROCEDURE find_duplicate_parties (
4583: p_rule_id IN NUMBER,

Line 4687: WHEN FND_API.G_EXC_ERROR THEN

4683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4684: 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);
4685: END IF;
4686: EXCEPTION
4687: WHEN FND_API.G_EXC_ERROR THEN
4688: RAISE FND_API.G_EXC_ERROR;
4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: WHEN OTHERS THEN

Line 4688: RAISE FND_API.G_EXC_ERROR;

4684: 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);
4685: END IF;
4686: EXCEPTION
4687: WHEN FND_API.G_EXC_ERROR THEN
4688: RAISE FND_API.G_EXC_ERROR;
4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: WHEN OTHERS THEN
4692: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4685: END IF;
4686: EXCEPTION
4687: WHEN FND_API.G_EXC_ERROR THEN
4688: RAISE FND_API.G_EXC_ERROR;
4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: WHEN OTHERS THEN
4692: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4693: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');

Line 4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4686: EXCEPTION
4687: WHEN FND_API.G_EXC_ERROR THEN
4688: RAISE FND_API.G_EXC_ERROR;
4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: WHEN OTHERS THEN
4692: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4693: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4694: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4692: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4693: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4694: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4695: FND_MSG_PUB.ADD;
4696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4697: END find_duplicate_parties;
4698:
4699: PROCEDURE find_duplicate_party_sites (
4700: p_rule_id IN NUMBER,

Line 4772: WHEN FND_API.G_EXC_ERROR THEN

4768: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4769: 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);
4770: END IF;
4771: EXCEPTION
4772: WHEN FND_API.G_EXC_ERROR THEN
4773: RAISE FND_API.G_EXC_ERROR;
4774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: WHEN OTHERS THEN

Line 4773: RAISE FND_API.G_EXC_ERROR;

4769: 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);
4770: END IF;
4771: EXCEPTION
4772: WHEN FND_API.G_EXC_ERROR THEN
4773: RAISE FND_API.G_EXC_ERROR;
4774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: WHEN OTHERS THEN
4777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4770: END IF;
4771: EXCEPTION
4772: WHEN FND_API.G_EXC_ERROR THEN
4773: RAISE FND_API.G_EXC_ERROR;
4774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: WHEN OTHERS THEN
4777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');

Line 4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4771: EXCEPTION
4772: WHEN FND_API.G_EXC_ERROR THEN
4773: RAISE FND_API.G_EXC_ERROR;
4774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: WHEN OTHERS THEN
4777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4780: FND_MSG_PUB.ADD;
4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4782: END find_duplicate_party_sites;
4783:
4784: PROCEDURE find_duplicate_contacts (
4785: p_rule_id IN NUMBER,

Line 4861: WHEN FND_API.G_EXC_ERROR THEN

4857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4858: 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);
4859: END IF;
4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN

Line 4862: RAISE FND_API.G_EXC_ERROR;

4858: 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);
4859: END IF;
4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4859: END IF;
4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');

Line 4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END find_duplicate_contacts;
4872:
4873: PROCEDURE find_duplicate_contact_points (
4874: p_rule_id IN NUMBER,

Line 4934: WHEN FND_API.G_EXC_ERROR THEN

4930: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4931: 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);
4932: END IF;
4933: EXCEPTION
4934: WHEN FND_API.G_EXC_ERROR THEN
4935: RAISE FND_API.G_EXC_ERROR;
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: WHEN OTHERS THEN

Line 4935: RAISE FND_API.G_EXC_ERROR;

4931: 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);
4932: END IF;
4933: EXCEPTION
4934: WHEN FND_API.G_EXC_ERROR THEN
4935: RAISE FND_API.G_EXC_ERROR;
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: WHEN OTHERS THEN
4939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4932: END IF;
4933: EXCEPTION
4934: WHEN FND_API.G_EXC_ERROR THEN
4935: RAISE FND_API.G_EXC_ERROR;
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: WHEN OTHERS THEN
4939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');

Line 4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4933: EXCEPTION
4934: WHEN FND_API.G_EXC_ERROR THEN
4935: RAISE FND_API.G_EXC_ERROR;
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: WHEN OTHERS THEN
4939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4942: FND_MSG_PUB.ADD;
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: END find_duplicate_contact_points;
4945:
4946: PROCEDURE find_parties_dynamic (
4947: p_rule_id IN NUMBER,

Line 5291: WHEN FND_API.G_EXC_ERROR THEN

5287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5288: 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);
5289: END IF;
5290: EXCEPTION
5291: WHEN FND_API.G_EXC_ERROR THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5295: WHEN OTHERS THEN

Line 5292: RAISE FND_API.G_EXC_ERROR;

5288: 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);
5289: END IF;
5290: EXCEPTION
5291: WHEN FND_API.G_EXC_ERROR THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5295: WHEN OTHERS THEN
5296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5289: END IF;
5290: EXCEPTION
5291: WHEN FND_API.G_EXC_ERROR THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5295: WHEN OTHERS THEN
5296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5297: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');

Line 5294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5290: EXCEPTION
5291: WHEN FND_API.G_EXC_ERROR THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5295: WHEN OTHERS THEN
5296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5297: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5297: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5299: FND_MSG_PUB.ADD;
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: END call_api_dynamic;
5302:
5303:
5304: PROCEDURE get_matching_party_sites (

Line 5535: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5536: RAISE FND_API.G_EXC_ERROR;

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

Line 5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5533: END IF;
5534: EXCEPTION
5535: WHEN FND_API.G_EXC_ERROR THEN
5536: RAISE FND_API.G_EXC_ERROR;
5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_party_sites');

Line 5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5534: EXCEPTION
5535: WHEN FND_API.G_EXC_ERROR THEN
5536: RAISE FND_API.G_EXC_ERROR;
5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_party_sites');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_party_sites');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_party_sites;
5546:
5547:
5548: PROCEDURE get_matching_contacts (

Line 5763: WHEN FND_API.G_EXC_ERROR THEN

5759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5760: 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);
5761: END IF;
5762: EXCEPTION
5763: WHEN FND_API.G_EXC_ERROR THEN
5764: RAISE FND_API.G_EXC_ERROR;
5765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5767: WHEN OTHERS THEN

Line 5764: RAISE FND_API.G_EXC_ERROR;

5760: 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);
5761: END IF;
5762: EXCEPTION
5763: WHEN FND_API.G_EXC_ERROR THEN
5764: RAISE FND_API.G_EXC_ERROR;
5765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5767: WHEN OTHERS THEN
5768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5761: END IF;
5762: EXCEPTION
5763: WHEN FND_API.G_EXC_ERROR THEN
5764: RAISE FND_API.G_EXC_ERROR;
5765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5767: WHEN OTHERS THEN
5768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5769: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');

Line 5766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5762: EXCEPTION
5763: WHEN FND_API.G_EXC_ERROR THEN
5764: RAISE FND_API.G_EXC_ERROR;
5765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5767: WHEN OTHERS THEN
5768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5769: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5770: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5769: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5770: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5771: FND_MSG_PUB.ADD;
5772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5773: END get_matching_contacts;
5774:
5775:
5776: PROCEDURE get_matching_contact_points (

Line 5905: WHEN FND_API.G_EXC_ERROR THEN

5901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5902: 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);
5903: END IF;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN

Line 5906: RAISE FND_API.G_EXC_ERROR;

5902: 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);
5903: END IF;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5903: END IF;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');

Line 5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5913: FND_MSG_PUB.ADD;
5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5915: END get_matching_contact_points;
5916:
5917: /**********************************************************
5918: This procedure finds the score details for a specific party that

Line 6146: WHEN FND_API.G_EXC_ERROR THEN

6142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6143: 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);
6144: END IF;
6145: EXCEPTION
6146: WHEN FND_API.G_EXC_ERROR THEN
6147: RAISE FND_API.G_EXC_ERROR;
6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6150: WHEN OTHERS THEN

Line 6147: RAISE FND_API.G_EXC_ERROR;

6143: 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);
6144: END IF;
6145: EXCEPTION
6146: WHEN FND_API.G_EXC_ERROR THEN
6147: RAISE FND_API.G_EXC_ERROR;
6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6150: WHEN OTHERS THEN
6151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6144: END IF;
6145: EXCEPTION
6146: WHEN FND_API.G_EXC_ERROR THEN
6147: RAISE FND_API.G_EXC_ERROR;
6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6150: WHEN OTHERS THEN
6151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6152: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');

Line 6149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6145: EXCEPTION
6146: WHEN FND_API.G_EXC_ERROR THEN
6147: RAISE FND_API.G_EXC_ERROR;
6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6150: WHEN OTHERS THEN
6151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6152: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6153: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6152: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6153: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6154: FND_MSG_PUB.ADD;
6155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6156: END get_score_details;
6157:
6158:
6159: /************************************************

Line 6269: WHEN FND_API.G_EXC_ERROR THEN

6265: END LOOP;
6266: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6267: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6268: EXCEPTION
6269: WHEN FND_API.G_EXC_ERROR THEN
6270: RAISE FND_API.G_EXC_ERROR;
6271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: WHEN OTHERS THEN

Line 6270: RAISE FND_API.G_EXC_ERROR;

6266: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6267: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6268: EXCEPTION
6269: WHEN FND_API.G_EXC_ERROR THEN
6270: RAISE FND_API.G_EXC_ERROR;
6271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: WHEN OTHERS THEN
6274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6267: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6268: EXCEPTION
6269: WHEN FND_API.G_EXC_ERROR THEN
6270: RAISE FND_API.G_EXC_ERROR;
6271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: WHEN OTHERS THEN
6274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6275: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6268: EXCEPTION
6269: WHEN FND_API.G_EXC_ERROR THEN
6270: RAISE FND_API.G_EXC_ERROR;
6271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: WHEN OTHERS THEN
6274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6275: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6275: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6277: FND_MSG_PUB.ADD;
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: END get_party_for_search;
6280:
6281: PROCEDURE get_search_criteria (
6282: p_party_id IN NUMBER,

Line 6321: WHEN FND_API.G_EXC_ERROR THEN

6317: END IF;
6318: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6319: END IF;
6320: EXCEPTION
6321: WHEN FND_API.G_EXC_ERROR THEN
6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN

Line 6322: RAISE FND_API.G_EXC_ERROR;

6318: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6319: END IF;
6320: EXCEPTION
6321: WHEN FND_API.G_EXC_ERROR THEN
6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6319: END IF;
6320: EXCEPTION
6321: WHEN FND_API.G_EXC_ERROR THEN
6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6320: EXCEPTION
6321: WHEN FND_API.G_EXC_ERROR THEN
6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6393: RAISE FND_API.G_EXC_ERROR;

6389: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6390: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;
6394: END get_party_rec;
6395:
6396: /************************************************
6397: This procedure retrieves the match rule party site attributes into

Line 6457: RAISE FND_API.G_EXC_ERROR;

6453: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6454: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6456: FND_MSG_PUB.ADD;
6457: RAISE FND_API.G_EXC_ERROR;
6458: END get_party_site_rec;
6459:
6460: /************************************************
6461: This procedure retrieves the match rule contact attributes into

Line 6515: RAISE FND_API.G_EXC_ERROR;

6511: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6512: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6514: FND_MSG_PUB.ADD;
6515: RAISE FND_API.G_EXC_ERROR;
6516: END get_contact_rec;
6517:
6518: /************************************************
6519: This procedure retrieves the match rule contact point attributes into

Line 6571: RAISE FND_API.G_EXC_ERROR;

6567: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6568: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6570: FND_MSG_PUB.ADD;
6571: RAISE FND_API.G_EXC_ERROR;
6572: END get_contact_point_rec;
6573:
6574: /************************************************
6575: This procedure maps a search record from the logical

Line 6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6767: END;
6768:
6769:
6770: /************************************************

Line 7005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7001: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7002: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7004: FND_MSG_PUB.ADD;
7005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7006: END;
7007:
7008:
7009: /************************************************

Line 7108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7104: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7105: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7107: FND_MSG_PUB.ADD;
7108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7109: END;
7110:
7111:
7112: /************************************************

Line 7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7235: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7236: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7237: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7238: FND_MSG_PUB.ADD;
7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7240: END;
7241:
7242:
7243: /************************************************

Line 7264: RAISE FND_API.G_EXC_ERROR;

7260: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7261: ) THEN
7262: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7263: FND_MSG_PUB.ADD;
7264: RAISE FND_API.G_EXC_ERROR;
7265: END IF;
7266: END LOOP;
7267:
7268: IF p_party_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN

Line 7327: WHEN FND_API.G_EXC_ERROR THEN

7323: END IF;
7324: END LOOP;
7325: RETURN FALSE;
7326: EXCEPTION
7327: WHEN FND_API.G_EXC_ERROR THEN
7328: RAISE FND_API.G_EXC_ERROR;
7329: WHEN OTHERS THEN
7330: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7331: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 7328: RAISE FND_API.G_EXC_ERROR;

7324: END LOOP;
7325: RETURN FALSE;
7326: EXCEPTION
7327: WHEN FND_API.G_EXC_ERROR THEN
7328: RAISE FND_API.G_EXC_ERROR;
7329: WHEN OTHERS THEN
7330: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7331: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7332: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 7334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7330: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7331: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7332: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7333: FND_MSG_PUB.ADD;
7334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7335: END check_prim_cond;
7336:
7337: /************************************************
7338: This procedure checks if the input search condition

Line 7398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7395: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7397: FND_MSG_PUB.ADD;
7398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7399: END check_party_site_cond;
7400:
7401: /************************************************
7402: This procedure checks if the input search condition

Line 7454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7451: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7453: FND_MSG_PUB.ADD;
7454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7455: END check_contact_cond;
7456:
7457: /************************************************
7458: This procedure checks if the input search condition

Line 7475: RAISE FND_API.G_EXC_ERROR;

7471: FOR I IN 1..p_contact_point_list.COUNT LOOP
7472: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7473: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7474: FND_MSG_PUB.ADD;
7475: RAISE FND_API.G_EXC_ERROR;
7476: END IF;
7477: END LOOP;
7478:
7479: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7498: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7500: FND_MSG_PUB.ADD;
7501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7502: END check_contact_point_cond;
7503:
7504: FUNCTION check_staged RETURN BOOLEAN IS
7505: