eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_60 dependencies on FND_API

Line 102: RAISE FND_API.G_EXC_ERROR;

98: when others then
99: if (instrb(SQLERRM,'DRG-51030')>0) then
100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;

Line 106: RAISE FND_API.G_EXC_ERROR;

102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;
110: END;

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;
110: END;
111:
112:

Line 1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1166: RAISE FND_API.G_EXC_ERROR;

1162: p_contact_list,
1163: p_contact_point_list) THEN
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1165: FND_MSG_PUB.ADD;
1166: RAISE FND_API.G_EXC_ERROR;
1167: END IF;
1168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1169: hz_utility_v2pub.debug(p_message=>'In init_search calling util package set_score',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1170: END IF;

Line 1435: RAISE FND_API.G_EXC_ERROR;

1431: IF lengthb(l_party_contains_str) > 4000 THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1433: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1434: FND_MSG_PUB.ADD;
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: IF (p_match_str = ' AND ' OR p_party_max_score 1438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1439: hz_utility_v2pub.debug(p_message=>'party contains string returned by init_search is an AND between these strings ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1548: RAISE FND_API.G_EXC_ERROR;

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

Line 1595: RAISE FND_API.G_EXC_ERROR;

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

Line 1676: RAISE FND_API.G_EXC_ERROR;

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

Line 1946: RAISE FND_API.G_EXC_ERROR;

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

Line 1950: RAISE FND_API.G_EXC_ERROR;

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

Line 1954: RAISE FND_API.G_EXC_ERROR;

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

Line 1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2191: RAISE FND_API.G_EXC_ERROR;

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

Line 2195: RAISE FND_API.G_EXC_ERROR;

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

Line 2199: RAISE FND_API.G_EXC_ERROR;

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

Line 2204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2338: RAISE FND_API.G_EXC_ERROR;

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

Line 2342: RAISE FND_API.G_EXC_ERROR;

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

Line 2346: RAISE FND_API.G_EXC_ERROR;

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

Line 2351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2611: RAISE FND_API.G_EXC_ERROR;

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

Line 2615: RAISE FND_API.G_EXC_ERROR;

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

Line 2619: RAISE FND_API.G_EXC_ERROR;

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

Line 2624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2885: RAISE FND_API.G_EXC_ERROR;

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

Line 2933: RAISE FND_API.G_EXC_ERROR;

2929: 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);
2930: END IF;
2931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_ERROR;
2934: ELSE
2935: push_eval;
2936: RETURN;
2937: END IF;

Line 3006: RAISE FND_API.G_EXC_ERROR;

3002: 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);
3003: END IF;
3004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3005: FND_MSG_PUB.ADD;
3006: RAISE FND_API.G_EXC_ERROR;
3007: ELSE
3008: push_eval;
3009: RETURN;
3010: END IF;

Line 3118: RAISE FND_API.G_EXC_ERROR;

3114: 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);
3115: END IF;
3116: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3117: FND_MSG_PUB.ADD;
3118: RAISE FND_API.G_EXC_ERROR;
3119: ELSE
3120: push_eval;
3121: RETURN;
3122: END IF;

Line 3229: RAISE FND_API.G_EXC_ERROR;

3225: 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);
3226: END IF;
3227: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_ERROR;
3230: ELSE
3231: push_eval;
3232: RETURN;
3233: END IF;

Line 3454: RAISE FND_API.G_EXC_ERROR;

3450: 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);
3451: END IF;
3452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3453: FND_MSG_PUB.ADD;
3454: RAISE FND_API.G_EXC_ERROR;
3455: END IF;
3456: ELSE
3457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3458: 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 3462: RAISE FND_API.G_EXC_ERROR;

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

Line 3661: WHEN FND_API.G_EXC_ERROR THEN

3657: END IF;
3658: EXCEPTION
3659: WHEN L_RETURN_IMM_EXC THEN
3660: RETURN;
3661: WHEN FND_API.G_EXC_ERROR THEN
3662: RAISE FND_API.G_EXC_ERROR;
3663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3665: WHEN OTHERS THEN

Line 3662: RAISE FND_API.G_EXC_ERROR;

3658: EXCEPTION
3659: WHEN L_RETURN_IMM_EXC THEN
3660: RETURN;
3661: WHEN FND_API.G_EXC_ERROR THEN
3662: RAISE FND_API.G_EXC_ERROR;
3663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3665: WHEN OTHERS THEN
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3659: WHEN L_RETURN_IMM_EXC THEN
3660: RETURN;
3661: WHEN FND_API.G_EXC_ERROR THEN
3662: RAISE FND_API.G_EXC_ERROR;
3663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3665: WHEN OTHERS THEN
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3667: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');

Line 3664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3660: RETURN;
3661: WHEN FND_API.G_EXC_ERROR THEN
3662: RAISE FND_API.G_EXC_ERROR;
3663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3665: WHEN OTHERS THEN
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3667: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3668: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3667: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3668: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3669: FND_MSG_PUB.ADD;
3670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3671: END find_parties;
3672:
3673: PROCEDURE find_persons (
3674: p_rule_id IN NUMBER,

Line 3871: RAISE FND_API.G_EXC_ERROR;

3867: 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);
3868: END IF;
3869: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_ERROR;
3872: ELSE
3873: push_eval;
3874: RETURN;
3875: END IF;

Line 3919: RAISE FND_API.G_EXC_ERROR;

3915: 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);
3916: END IF;
3917: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3918: FND_MSG_PUB.ADD;
3919: RAISE FND_API.G_EXC_ERROR;
3920: ELSE
3921: push_eval;
3922: RETURN;
3923: END IF;

Line 3955: RAISE FND_API.G_EXC_ERROR;

3951: when others then
3952: if (instrb(SQLERRM,'DRG-51030')>0) then
3953: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3954: FND_MSG_PUB.ADD;
3955: RAISE FND_API.G_EXC_ERROR;
3956: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3958: FND_MSG_PUB.ADD;
3959: RAISE FND_API.G_EXC_ERROR;

Line 3959: RAISE FND_API.G_EXC_ERROR;

3955: RAISE FND_API.G_EXC_ERROR;
3956: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3958: FND_MSG_PUB.ADD;
3959: RAISE FND_API.G_EXC_ERROR;
3960: else
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: end if;
3963: END;

Line 3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3958: FND_MSG_PUB.ADD;
3959: RAISE FND_API.G_EXC_ERROR;
3960: else
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: end if;
3963: END;
3964:
3965: /** Private procedure to acquire and score at party site level ***/

Line 4031: RAISE FND_API.G_EXC_ERROR;

4027: 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);
4028: END IF;
4029: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4030: FND_MSG_PUB.ADD;
4031: RAISE FND_API.G_EXC_ERROR;
4032: ELSE
4033: push_eval;
4034: RETURN;
4035: END IF;

Line 4290: RAISE FND_API.G_EXC_ERROR;

4286: 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);
4287: END IF;
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_ERROR;
4291: ELSE
4292: push_eval;
4293: RETURN;
4294: END IF;

Line 4403: RAISE FND_API.G_EXC_ERROR;

4399: 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);
4400: END IF;
4401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4402: FND_MSG_PUB.ADD;
4403: RAISE FND_API.G_EXC_ERROR;
4404: END IF;
4405: ELSE
4406: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4407: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4411: RAISE FND_API.G_EXC_ERROR;

4407: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4408: END IF;
4409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4410: FND_MSG_PUB.ADD;
4411: RAISE FND_API.G_EXC_ERROR;
4412: END IF;
4413: END IF;
4414: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4415: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4525: WHEN FND_API.G_EXC_ERROR THEN

4521: END IF;
4522: EXCEPTION
4523: WHEN L_RETURN_IMM_EXC THEN
4524: RETURN;
4525: WHEN FND_API.G_EXC_ERROR THEN
4526: RAISE FND_API.G_EXC_ERROR;
4527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4529: WHEN OTHERS THEN

Line 4526: RAISE FND_API.G_EXC_ERROR;

4522: EXCEPTION
4523: WHEN L_RETURN_IMM_EXC THEN
4524: RETURN;
4525: WHEN FND_API.G_EXC_ERROR THEN
4526: RAISE FND_API.G_EXC_ERROR;
4527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4529: WHEN OTHERS THEN
4530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4523: WHEN L_RETURN_IMM_EXC THEN
4524: RETURN;
4525: WHEN FND_API.G_EXC_ERROR THEN
4526: RAISE FND_API.G_EXC_ERROR;
4527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4529: WHEN OTHERS THEN
4530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');

Line 4528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4524: RETURN;
4525: WHEN FND_API.G_EXC_ERROR THEN
4526: RAISE FND_API.G_EXC_ERROR;
4527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4529: WHEN OTHERS THEN
4530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');
4532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');
4532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4533: FND_MSG_PUB.ADD;
4534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4535: END find_persons;
4536:
4537: PROCEDURE find_persons (
4538: p_rule_id IN NUMBER,

Line 4593: WHEN FND_API.G_EXC_ERROR THEN

4589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4590: 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);
4591: END IF;
4592: EXCEPTION
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: RAISE FND_API.G_EXC_ERROR;
4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN

Line 4594: RAISE FND_API.G_EXC_ERROR;

4590: 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);
4591: END IF;
4592: EXCEPTION
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: RAISE FND_API.G_EXC_ERROR;
4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4591: END IF;
4592: EXCEPTION
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: RAISE FND_API.G_EXC_ERROR;
4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');

Line 4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4592: EXCEPTION
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: RAISE FND_API.G_EXC_ERROR;
4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');
4600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');
4600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4601: FND_MSG_PUB.ADD;
4602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4603: END find_party_details;
4604:
4605: PROCEDURE find_duplicate_parties (
4606: p_rule_id IN NUMBER,

Line 4710: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4711: RAISE FND_API.G_EXC_ERROR;

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

Line 4712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4715: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4716: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_parties');
4717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4718: FND_MSG_PUB.ADD;
4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4720: END find_duplicate_parties;
4721:
4722: PROCEDURE find_duplicate_party_sites (
4723: p_rule_id IN NUMBER,

Line 4795: WHEN FND_API.G_EXC_ERROR THEN

4791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4792: 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);
4793: END IF;
4794: EXCEPTION
4795: WHEN FND_API.G_EXC_ERROR THEN
4796: RAISE FND_API.G_EXC_ERROR;
4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: WHEN OTHERS THEN

Line 4796: RAISE FND_API.G_EXC_ERROR;

4792: 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);
4793: END IF;
4794: EXCEPTION
4795: WHEN FND_API.G_EXC_ERROR THEN
4796: RAISE FND_API.G_EXC_ERROR;
4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: WHEN OTHERS THEN
4800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4793: END IF;
4794: EXCEPTION
4795: WHEN FND_API.G_EXC_ERROR THEN
4796: RAISE FND_API.G_EXC_ERROR;
4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: WHEN OTHERS THEN
4800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4801: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');

Line 4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4794: EXCEPTION
4795: WHEN FND_API.G_EXC_ERROR THEN
4796: RAISE FND_API.G_EXC_ERROR;
4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: WHEN OTHERS THEN
4800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4801: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');
4802: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4801: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');
4802: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4803: FND_MSG_PUB.ADD;
4804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4805: END find_duplicate_party_sites;
4806:
4807: PROCEDURE find_duplicate_contacts (
4808: p_rule_id IN NUMBER,

Line 4884: WHEN FND_API.G_EXC_ERROR THEN

4880: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4881: 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);
4882: END IF;
4883: EXCEPTION
4884: WHEN FND_API.G_EXC_ERROR THEN
4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN

Line 4885: RAISE FND_API.G_EXC_ERROR;

4881: 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);
4882: END IF;
4883: EXCEPTION
4884: WHEN FND_API.G_EXC_ERROR THEN
4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4882: END IF;
4883: EXCEPTION
4884: WHEN FND_API.G_EXC_ERROR THEN
4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');

Line 4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4883: EXCEPTION
4884: WHEN FND_API.G_EXC_ERROR THEN
4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4892: FND_MSG_PUB.ADD;
4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4894: END find_duplicate_contacts;
4895:
4896: PROCEDURE find_duplicate_contact_points (
4897: p_rule_id IN NUMBER,

Line 4957: WHEN FND_API.G_EXC_ERROR THEN

4953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4954: 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);
4955: END IF;
4956: EXCEPTION
4957: WHEN FND_API.G_EXC_ERROR THEN
4958: RAISE FND_API.G_EXC_ERROR;
4959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: WHEN OTHERS THEN

Line 4958: RAISE FND_API.G_EXC_ERROR;

4954: 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);
4955: END IF;
4956: EXCEPTION
4957: WHEN FND_API.G_EXC_ERROR THEN
4958: RAISE FND_API.G_EXC_ERROR;
4959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: WHEN OTHERS THEN
4962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4955: END IF;
4956: EXCEPTION
4957: WHEN FND_API.G_EXC_ERROR THEN
4958: RAISE FND_API.G_EXC_ERROR;
4959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: WHEN OTHERS THEN
4962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4963: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');

Line 4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4956: EXCEPTION
4957: WHEN FND_API.G_EXC_ERROR THEN
4958: RAISE FND_API.G_EXC_ERROR;
4959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: WHEN OTHERS THEN
4962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4963: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');
4964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4963: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');
4964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4965: FND_MSG_PUB.ADD;
4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4967: END find_duplicate_contact_points;
4968:
4969: PROCEDURE find_parties_dynamic (
4970: p_rule_id IN NUMBER,

Line 5314: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5315: RAISE FND_API.G_EXC_ERROR;

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

Line 5316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5320: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');
5321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5322: FND_MSG_PUB.ADD;
5323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5324: END call_api_dynamic;
5325:
5326:
5327: PROCEDURE get_matching_party_sites (

Line 5559: WHEN FND_API.G_EXC_ERROR THEN

5555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5556: 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);
5557: END IF;
5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN

Line 5560: RAISE FND_API.G_EXC_ERROR;

5556: 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);
5557: END IF;
5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5557: END IF;
5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');

Line 5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');
5566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');
5566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5567: FND_MSG_PUB.ADD;
5568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5569: END get_matching_party_sites;
5570:
5571:
5572: PROCEDURE get_matching_contacts (

Line 5788: WHEN FND_API.G_EXC_ERROR THEN

5784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5785: 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);
5786: END IF;
5787: EXCEPTION
5788: WHEN FND_API.G_EXC_ERROR THEN
5789: RAISE FND_API.G_EXC_ERROR;
5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5792: WHEN OTHERS THEN

Line 5789: RAISE FND_API.G_EXC_ERROR;

5785: 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);
5786: END IF;
5787: EXCEPTION
5788: WHEN FND_API.G_EXC_ERROR THEN
5789: RAISE FND_API.G_EXC_ERROR;
5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5792: WHEN OTHERS THEN
5793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5786: END IF;
5787: EXCEPTION
5788: WHEN FND_API.G_EXC_ERROR THEN
5789: RAISE FND_API.G_EXC_ERROR;
5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5792: WHEN OTHERS THEN
5793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');

Line 5791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5787: EXCEPTION
5788: WHEN FND_API.G_EXC_ERROR THEN
5789: RAISE FND_API.G_EXC_ERROR;
5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5792: WHEN OTHERS THEN
5793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5796: FND_MSG_PUB.ADD;
5797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5798: END get_matching_contacts;
5799:
5800:
5801: PROCEDURE get_matching_contact_points (

Line 5930: WHEN FND_API.G_EXC_ERROR THEN

5926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5927: 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);
5928: END IF;
5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN

Line 5931: RAISE FND_API.G_EXC_ERROR;

5927: 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);
5928: END IF;
5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5928: END IF;
5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');

Line 5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5940: END get_matching_contact_points;
5941:
5942: /**********************************************************
5943: This procedure finds the score details for a specific party that

Line 6168: WHEN FND_API.G_EXC_ERROR THEN

6164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6165: 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);
6166: END IF;
6167: EXCEPTION
6168: WHEN FND_API.G_EXC_ERROR THEN
6169: RAISE FND_API.G_EXC_ERROR;
6170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: WHEN OTHERS THEN

Line 6169: RAISE FND_API.G_EXC_ERROR;

6165: 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);
6166: END IF;
6167: EXCEPTION
6168: WHEN FND_API.G_EXC_ERROR THEN
6169: RAISE FND_API.G_EXC_ERROR;
6170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: WHEN OTHERS THEN
6173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6166: END IF;
6167: EXCEPTION
6168: WHEN FND_API.G_EXC_ERROR THEN
6169: RAISE FND_API.G_EXC_ERROR;
6170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: WHEN OTHERS THEN
6173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');

Line 6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6167: EXCEPTION
6168: WHEN FND_API.G_EXC_ERROR THEN
6169: RAISE FND_API.G_EXC_ERROR;
6170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: WHEN OTHERS THEN
6173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');
6175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');
6175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6176: FND_MSG_PUB.ADD;
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: END get_score_details;
6179:
6180:
6181: /************************************************

Line 6291: WHEN FND_API.G_EXC_ERROR THEN

6287: END LOOP;
6288: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6289: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6290: EXCEPTION
6291: WHEN FND_API.G_EXC_ERROR THEN
6292: RAISE FND_API.G_EXC_ERROR;
6293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: WHEN OTHERS THEN

Line 6292: RAISE FND_API.G_EXC_ERROR;

6288: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6289: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6290: EXCEPTION
6291: WHEN FND_API.G_EXC_ERROR THEN
6292: RAISE FND_API.G_EXC_ERROR;
6293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: WHEN OTHERS THEN
6296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6289: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6290: EXCEPTION
6291: WHEN FND_API.G_EXC_ERROR THEN
6292: RAISE FND_API.G_EXC_ERROR;
6293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: WHEN OTHERS THEN
6296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6297: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6290: EXCEPTION
6291: WHEN FND_API.G_EXC_ERROR THEN
6292: RAISE FND_API.G_EXC_ERROR;
6293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: WHEN OTHERS THEN
6296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6297: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6297: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6299: FND_MSG_PUB.ADD;
6300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6301: END get_party_for_search;
6302:
6303: PROCEDURE get_search_criteria (
6304: p_party_id IN NUMBER,

Line 6343: WHEN FND_API.G_EXC_ERROR THEN

6339: END IF;
6340: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6341: END IF;
6342: EXCEPTION
6343: WHEN FND_API.G_EXC_ERROR THEN
6344: RAISE FND_API.G_EXC_ERROR;
6345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6347: WHEN OTHERS THEN

Line 6344: RAISE FND_API.G_EXC_ERROR;

6340: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6341: END IF;
6342: EXCEPTION
6343: WHEN FND_API.G_EXC_ERROR THEN
6344: RAISE FND_API.G_EXC_ERROR;
6345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6347: WHEN OTHERS THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6341: END IF;
6342: EXCEPTION
6343: WHEN FND_API.G_EXC_ERROR THEN
6344: RAISE FND_API.G_EXC_ERROR;
6345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6347: WHEN OTHERS THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6349: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6342: EXCEPTION
6343: WHEN FND_API.G_EXC_ERROR THEN
6344: RAISE FND_API.G_EXC_ERROR;
6345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6347: WHEN OTHERS THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6349: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6349: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6351: FND_MSG_PUB.ADD;
6352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6353: END get_search_criteria;
6354:
6355:
6356: /************************************************

Line 6417: RAISE FND_API.G_EXC_ERROR;

6413: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6414: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6415: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6416: FND_MSG_PUB.ADD;
6417: RAISE FND_API.G_EXC_ERROR;
6418: END get_party_rec;
6419:
6420: /************************************************
6421: This procedure retrieves the match rule party site attributes into

Line 6481: RAISE FND_API.G_EXC_ERROR;

6477: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;
6482: END get_party_site_rec;
6483:
6484: /************************************************
6485: This procedure retrieves the match rule contact attributes into

Line 6539: RAISE FND_API.G_EXC_ERROR;

6535: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6536: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6538: FND_MSG_PUB.ADD;
6539: RAISE FND_API.G_EXC_ERROR;
6540: END get_contact_rec;
6541:
6542: /************************************************
6543: This procedure retrieves the match rule contact point attributes into

Line 6595: RAISE FND_API.G_EXC_ERROR;

6591: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6592: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6594: FND_MSG_PUB.ADD;
6595: RAISE FND_API.G_EXC_ERROR;
6596: END get_contact_point_rec;
6597:
6598: /************************************************
6599: This procedure maps a search record from the logical

Line 6769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 7010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7006: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7007: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7009: FND_MSG_PUB.ADD;
7010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7011: END;
7012:
7013:
7014: /************************************************

Line 7067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7063: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7064: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7066: FND_MSG_PUB.ADD;
7067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7068: END;
7069:
7070:
7071: /************************************************

Line 7198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7194: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7195: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7197: FND_MSG_PUB.ADD;
7198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7199: END;
7200:
7201:
7202: /************************************************

Line 7223: RAISE FND_API.G_EXC_ERROR;

7219: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7220: ) THEN
7221: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7222: FND_MSG_PUB.ADD;
7223: RAISE FND_API.G_EXC_ERROR;
7224: END IF;
7225: END LOOP;
7226:
7227: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 7286: WHEN FND_API.G_EXC_ERROR THEN

7282: END IF;
7283: END LOOP;
7284: RETURN FALSE;
7285: EXCEPTION
7286: WHEN FND_API.G_EXC_ERROR THEN
7287: RAISE FND_API.G_EXC_ERROR;
7288: WHEN OTHERS THEN
7289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7290: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 7287: RAISE FND_API.G_EXC_ERROR;

7283: END LOOP;
7284: RETURN FALSE;
7285: EXCEPTION
7286: WHEN FND_API.G_EXC_ERROR THEN
7287: RAISE FND_API.G_EXC_ERROR;
7288: WHEN OTHERS THEN
7289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7290: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 7293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7290: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7292: FND_MSG_PUB.ADD;
7293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7294: END check_prim_cond;
7295:
7296: /************************************************
7297: This procedure checks if the input search condition

Line 7357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7353: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7354: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7356: FND_MSG_PUB.ADD;
7357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7358: END check_party_site_cond;
7359:
7360: /************************************************
7361: This procedure checks if the input search condition

Line 7413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7410: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7412: FND_MSG_PUB.ADD;
7413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7414: END check_contact_cond;
7415:
7416: /************************************************
7417: This procedure checks if the input search condition

Line 7434: RAISE FND_API.G_EXC_ERROR;

7430: FOR I IN 1..p_contact_point_list.COUNT LOOP
7431: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7432: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7433: FND_MSG_PUB.ADD;
7434: RAISE FND_API.G_EXC_ERROR;
7435: END IF;
7436: END LOOP;
7437:
7438: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7457: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7459: FND_MSG_PUB.ADD;
7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7461: END check_contact_point_cond;
7462:
7463: FUNCTION check_staged RETURN BOOLEAN IS
7464: