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_62 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 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1169: RAISE FND_API.G_EXC_ERROR;

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

Line 1461: RAISE FND_API.G_EXC_ERROR;

1457: IF lengthb(l_party_contains_str) > 4000 THEN
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_ERROR;
1462: END IF;
1463: IF (p_match_str = ' AND ' OR p_party_max_score 1464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1465: 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 1570: RAISE FND_API.G_EXC_ERROR;

1566: IF lengthb(l_contains_str) > 4000 THEN
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1568: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: x_denorm_str := l_den_contains_str;
1573: RETURN l_contains_str;
1574: END;

Line 1667: RAISE FND_API.G_EXC_ERROR;

1663: IF lengthb(l_contains_str) > 4000 THEN
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1665: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1666: FND_MSG_PUB.ADD;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: x_denorm_str := l_den_contains_str;
1670: RETURN l_contains_str;
1671: END;

Line 1943: RAISE FND_API.G_EXC_ERROR;

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

Line 1947: RAISE FND_API.G_EXC_ERROR;

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

Line 1951: RAISE FND_API.G_EXC_ERROR;

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

Line 1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2188: RAISE FND_API.G_EXC_ERROR;

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

Line 2192: RAISE FND_API.G_EXC_ERROR;

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

Line 2196: RAISE FND_API.G_EXC_ERROR;

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

Line 2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2335: RAISE FND_API.G_EXC_ERROR;

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

Line 2339: RAISE FND_API.G_EXC_ERROR;

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

Line 2343: RAISE FND_API.G_EXC_ERROR;

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

Line 2348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2608: RAISE FND_API.G_EXC_ERROR;

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

Line 2612: RAISE FND_API.G_EXC_ERROR;

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

Line 2616: RAISE FND_API.G_EXC_ERROR;

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

Line 2621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2884: RAISE FND_API.G_EXC_ERROR;

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

Line 2934: RAISE FND_API.G_EXC_ERROR;

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

Line 3007: RAISE FND_API.G_EXC_ERROR;

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

Line 3119: RAISE FND_API.G_EXC_ERROR;

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

Line 3230: RAISE FND_API.G_EXC_ERROR;

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

Line 3455: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3662: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3663: RAISE FND_API.G_EXC_ERROR;

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

Line 3664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3874: RAISE FND_API.G_EXC_ERROR;

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

Line 3924: RAISE FND_API.G_EXC_ERROR;

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

Line 3960: RAISE FND_API.G_EXC_ERROR;

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

Line 3964: RAISE FND_API.G_EXC_ERROR;

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

Line 3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4036: RAISE FND_API.G_EXC_ERROR;

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

Line 4295: RAISE FND_API.G_EXC_ERROR;

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

Line 4408: RAISE FND_API.G_EXC_ERROR;

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

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

Line 4530: WHEN FND_API.G_EXC_ERROR THEN

4526: END IF;
4527: EXCEPTION
4528: WHEN L_RETURN_IMM_EXC THEN
4529: RETURN;
4530: WHEN FND_API.G_EXC_ERROR THEN
4531: RAISE FND_API.G_EXC_ERROR;
4532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: WHEN OTHERS THEN

Line 4531: RAISE FND_API.G_EXC_ERROR;

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

Line 4532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4528: WHEN L_RETURN_IMM_EXC THEN
4529: RETURN;
4530: WHEN FND_API.G_EXC_ERROR THEN
4531: RAISE FND_API.G_EXC_ERROR;
4532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: WHEN OTHERS THEN
4535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');

Line 4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4529: RETURN;
4530: WHEN FND_API.G_EXC_ERROR THEN
4531: RAISE FND_API.G_EXC_ERROR;
4532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: WHEN OTHERS THEN
4535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4598: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4599: RAISE FND_API.G_EXC_ERROR;

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

Line 4600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4596: END IF;
4597: EXCEPTION
4598: WHEN FND_API.G_EXC_ERROR THEN
4599: RAISE FND_API.G_EXC_ERROR;
4600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4602: WHEN OTHERS THEN
4603: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4604: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');

Line 4601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4597: EXCEPTION
4598: WHEN FND_API.G_EXC_ERROR THEN
4599: RAISE FND_API.G_EXC_ERROR;
4600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4602: WHEN OTHERS THEN
4603: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4604: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4715: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4716: RAISE FND_API.G_EXC_ERROR;

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

Line 4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4713: END IF;
4714: EXCEPTION
4715: WHEN FND_API.G_EXC_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');

Line 4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4714: EXCEPTION
4715: WHEN FND_API.G_EXC_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4800: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4801: RAISE FND_API.G_EXC_ERROR;

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

Line 4802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4798: END IF;
4799: EXCEPTION
4800: WHEN FND_API.G_EXC_ERROR THEN
4801: RAISE FND_API.G_EXC_ERROR;
4802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4804: WHEN OTHERS THEN
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4806: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');

Line 4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4799: EXCEPTION
4800: WHEN FND_API.G_EXC_ERROR THEN
4801: RAISE FND_API.G_EXC_ERROR;
4802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4804: WHEN OTHERS THEN
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4806: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4889: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4890: RAISE FND_API.G_EXC_ERROR;

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

Line 4891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4887: END IF;
4888: EXCEPTION
4889: WHEN FND_API.G_EXC_ERROR THEN
4890: RAISE FND_API.G_EXC_ERROR;
4891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: WHEN OTHERS THEN
4894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');

Line 4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4888: EXCEPTION
4889: WHEN FND_API.G_EXC_ERROR THEN
4890: RAISE FND_API.G_EXC_ERROR;
4891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: WHEN OTHERS THEN
4894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4962: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4963: RAISE FND_API.G_EXC_ERROR;

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

Line 4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4960: END IF;
4961: EXCEPTION
4962: WHEN FND_API.G_EXC_ERROR THEN
4963: RAISE FND_API.G_EXC_ERROR;
4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');

Line 4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4961: EXCEPTION
4962: WHEN FND_API.G_EXC_ERROR THEN
4963: RAISE FND_API.G_EXC_ERROR;
4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5319: WHEN FND_API.G_EXC_ERROR THEN

5315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5316: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5317: END IF;
5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN

Line 5320: RAISE FND_API.G_EXC_ERROR;

5316: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5317: END IF;
5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5327: FND_MSG_PUB.ADD;
5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5329: END call_api_dynamic;
5330:
5331:
5332: PROCEDURE get_matching_party_sites (

Line 5564: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5565: RAISE FND_API.G_EXC_ERROR;

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

Line 5566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5562: END IF;
5563: EXCEPTION
5564: WHEN FND_API.G_EXC_ERROR THEN
5565: RAISE FND_API.G_EXC_ERROR;
5566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568: WHEN OTHERS THEN
5569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5570: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');

Line 5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5563: EXCEPTION
5564: WHEN FND_API.G_EXC_ERROR THEN
5565: RAISE FND_API.G_EXC_ERROR;
5566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568: WHEN OTHERS THEN
5569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5570: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5570: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5574: END get_matching_party_sites;
5575:
5576:
5577: PROCEDURE get_matching_contacts (

Line 5792: WHEN FND_API.G_EXC_ERROR THEN

5788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5789: 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);
5790: END IF;
5791: EXCEPTION
5792: WHEN FND_API.G_EXC_ERROR THEN
5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN

Line 5793: RAISE FND_API.G_EXC_ERROR;

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

Line 5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5790: END IF;
5791: EXCEPTION
5792: WHEN FND_API.G_EXC_ERROR THEN
5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');

Line 5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5791: EXCEPTION
5792: WHEN FND_API.G_EXC_ERROR THEN
5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5802: END get_matching_contacts;
5803:
5804:
5805: PROCEDURE get_matching_contact_points (

Line 5934: WHEN FND_API.G_EXC_ERROR THEN

5930: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5931: 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);
5932: END IF;
5933: EXCEPTION
5934: WHEN FND_API.G_EXC_ERROR THEN
5935: RAISE FND_API.G_EXC_ERROR;
5936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5938: WHEN OTHERS THEN

Line 5935: RAISE FND_API.G_EXC_ERROR;

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

Line 5936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5932: END IF;
5933: EXCEPTION
5934: WHEN FND_API.G_EXC_ERROR THEN
5935: RAISE FND_API.G_EXC_ERROR;
5936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');

Line 5937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5933: EXCEPTION
5934: WHEN FND_API.G_EXC_ERROR THEN
5935: RAISE FND_API.G_EXC_ERROR;
5936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6176: WHEN FND_API.G_EXC_ERROR THEN

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

Line 6177: RAISE FND_API.G_EXC_ERROR;

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

Line 6178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6174: END IF;
6175: EXCEPTION
6176: WHEN FND_API.G_EXC_ERROR THEN
6177: RAISE FND_API.G_EXC_ERROR;
6178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6180: WHEN OTHERS THEN
6181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');

Line 6179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6175: EXCEPTION
6176: WHEN FND_API.G_EXC_ERROR THEN
6177: RAISE FND_API.G_EXC_ERROR;
6178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6180: WHEN OTHERS THEN
6181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6184: FND_MSG_PUB.ADD;
6185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6186: END get_score_details;
6187:
6188:
6189: /************************************************

Line 6286: WHEN FND_API.G_EXC_ERROR THEN

6282: END LOOP;
6283: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6284: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6285: EXCEPTION
6286: WHEN FND_API.G_EXC_ERROR THEN
6287: RAISE FND_API.G_EXC_ERROR;
6288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: WHEN OTHERS THEN

Line 6287: RAISE FND_API.G_EXC_ERROR;

6283: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6284: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6285: EXCEPTION
6286: WHEN FND_API.G_EXC_ERROR THEN
6287: RAISE FND_API.G_EXC_ERROR;
6288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: WHEN OTHERS THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6284: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6285: EXCEPTION
6286: WHEN FND_API.G_EXC_ERROR THEN
6287: RAISE FND_API.G_EXC_ERROR;
6288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: WHEN OTHERS THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6285: EXCEPTION
6286: WHEN FND_API.G_EXC_ERROR THEN
6287: RAISE FND_API.G_EXC_ERROR;
6288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: WHEN OTHERS THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6294: FND_MSG_PUB.ADD;
6295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6296: END get_party_for_search;
6297:
6298: PROCEDURE get_search_criteria (
6299: p_party_id IN NUMBER,

Line 6332: WHEN FND_API.G_EXC_ERROR THEN

6328: END IF;
6329: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6330: END IF;
6331: EXCEPTION
6332: WHEN FND_API.G_EXC_ERROR THEN
6333: RAISE FND_API.G_EXC_ERROR;
6334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: WHEN OTHERS THEN

Line 6333: RAISE FND_API.G_EXC_ERROR;

6329: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6330: END IF;
6331: EXCEPTION
6332: WHEN FND_API.G_EXC_ERROR THEN
6333: RAISE FND_API.G_EXC_ERROR;
6334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: WHEN OTHERS THEN
6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6330: END IF;
6331: EXCEPTION
6332: WHEN FND_API.G_EXC_ERROR THEN
6333: RAISE FND_API.G_EXC_ERROR;
6334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: WHEN OTHERS THEN
6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6338: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6331: EXCEPTION
6332: WHEN FND_API.G_EXC_ERROR THEN
6333: RAISE FND_API.G_EXC_ERROR;
6334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: WHEN OTHERS THEN
6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6338: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6339: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6338: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6339: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6340: FND_MSG_PUB.ADD;
6341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6342: END get_search_criteria;
6343:
6344:
6345: /************************************************

Line 6408: RAISE FND_API.G_EXC_ERROR;

6404: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6405: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_ERROR;
6409: END get_party_rec;
6410:
6411: /************************************************
6412: This procedure retrieves the match rule party site attributes into

Line 6472: RAISE FND_API.G_EXC_ERROR;

6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6469: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6471: FND_MSG_PUB.ADD;
6472: RAISE FND_API.G_EXC_ERROR;
6473: END get_party_site_rec;
6474:
6475: /************************************************
6476: This procedure retrieves the match rule contact attributes into

Line 6528: RAISE FND_API.G_EXC_ERROR;

6524: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6525: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_ERROR;
6529: END get_contact_rec;
6530:
6531: /************************************************
6532: This procedure retrieves the match rule contact point attributes into

Line 6584: RAISE FND_API.G_EXC_ERROR;

6580: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6581: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6583: FND_MSG_PUB.ADD;
6584: RAISE FND_API.G_EXC_ERROR;
6585: END get_contact_point_rec;
6586:
6587: /************************************************
6588: This procedure maps a search record from the logical

Line 6777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 7018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 7060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7056: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7057: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7058: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7059: FND_MSG_PUB.ADD;
7060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7061: END;
7062:
7063:
7064: /************************************************

Line 7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7187: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7188: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7190: FND_MSG_PUB.ADD;
7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7192: END;
7193:
7194:
7195: /************************************************

Line 7216: RAISE FND_API.G_EXC_ERROR;

7212: OR p_contact_point_list(I).URL IS NOT NULL
7213: ) THEN
7214: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7215: FND_MSG_PUB.ADD;
7216: RAISE FND_API.G_EXC_ERROR;
7217: END IF;
7218: END LOOP;
7219:
7220: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 7277: WHEN FND_API.G_EXC_ERROR THEN

7273: END IF;
7274: END LOOP;
7275: RETURN FALSE;
7276: EXCEPTION
7277: WHEN FND_API.G_EXC_ERROR THEN
7278: RAISE FND_API.G_EXC_ERROR;
7279: WHEN OTHERS THEN
7280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7281: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 7278: RAISE FND_API.G_EXC_ERROR;

7274: END LOOP;
7275: RETURN FALSE;
7276: EXCEPTION
7277: WHEN FND_API.G_EXC_ERROR THEN
7278: RAISE FND_API.G_EXC_ERROR;
7279: WHEN OTHERS THEN
7280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7281: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 7284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7281: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7283: FND_MSG_PUB.ADD;
7284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7285: END check_prim_cond;
7286:
7287: /************************************************
7288: This procedure checks if the input search condition

Line 7348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7345: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7347: FND_MSG_PUB.ADD;
7348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7349: END check_party_site_cond;
7350:
7351: /************************************************
7352: This procedure checks if the input search condition

Line 7396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 7417: RAISE FND_API.G_EXC_ERROR;

7413: FOR I IN 1..p_contact_point_list.COUNT LOOP
7414: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7415: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7416: FND_MSG_PUB.ADD;
7417: RAISE FND_API.G_EXC_ERROR;
7418: END IF;
7419: END LOOP;
7420:
7421: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7444: END check_contact_point_cond;
7445:
7446: FUNCTION check_staged RETURN BOOLEAN IS
7447: