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_32 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 1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1140: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1141: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END;
1146:
1147:
1148: /************************************************

Line 1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1165: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1166: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1168: FND_MSG_PUB.ADD;
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END;
1171:
1172:
1173: /************************************************

Line 1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1186: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1188: FND_MSG_PUB.ADD;
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END;
1191:
1192:
1193: /************************************************

Line 1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1206: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1208: FND_MSG_PUB.ADD;
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END;
1211:
1212: PROCEDURE init_score_context (
1213: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1276: RAISE FND_API.G_EXC_ERROR;

1272: p_contact_list,
1273: p_contact_point_list) THEN
1274: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1275: FND_MSG_PUB.ADD;
1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;
1278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1279: 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);
1280: END IF;

Line 1581: RAISE FND_API.G_EXC_ERROR;

1577: IF lengthb(l_party_contains_str) > 4000 THEN
1578: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1579: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1580: FND_MSG_PUB.ADD;
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583: IF (p_match_str = ' AND ' OR p_party_max_score 1584: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1585: 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 1680: RAISE FND_API.G_EXC_ERROR;

1676: IF lengthb(l_contains_str) > 4000 THEN
1677: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1678: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1679: FND_MSG_PUB.ADD;
1680: RAISE FND_API.G_EXC_ERROR;
1681: END IF;
1682: x_denorm_str := l_den_contains_str;
1683: RETURN l_contains_str;
1684: END;

Line 1726: RAISE FND_API.G_EXC_ERROR;

1722: IF lengthb(l_contains_str) > 4000 THEN
1723: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1724: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1725: FND_MSG_PUB.ADD;
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728: x_denorm_str := l_den_contains_str;
1729: RETURN l_contains_str;
1730: END;

Line 1807: RAISE FND_API.G_EXC_ERROR;

1803: IF lengthb(l_contains_str) > 4000 THEN
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1805: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809: x_denorm_str := l_den_contains_str;
1810: RETURN l_contains_str;
1811: END;

Line 2091: RAISE FND_API.G_EXC_ERROR;

2087: when others then
2088: if (instrb(SQLERRM,'DRG-51030')>0) then
2089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2090: FND_MSG_PUB.ADD;
2091: RAISE FND_API.G_EXC_ERROR;
2092: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2093: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2094: FND_MSG_PUB.ADD;
2095: RAISE FND_API.G_EXC_ERROR;

Line 2095: RAISE FND_API.G_EXC_ERROR;

2091: RAISE FND_API.G_EXC_ERROR;
2092: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2093: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2094: FND_MSG_PUB.ADD;
2095: RAISE FND_API.G_EXC_ERROR;
2096: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2098: FND_MSG_PUB.ADD;
2099: RAISE FND_API.G_EXC_ERROR;

Line 2099: RAISE FND_API.G_EXC_ERROR;

2095: RAISE FND_API.G_EXC_ERROR;
2096: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2098: FND_MSG_PUB.ADD;
2099: RAISE FND_API.G_EXC_ERROR;
2100: else
2101: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2103: FND_MSG_PUB.ADD;

Line 2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2100: else
2101: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2103: FND_MSG_PUB.ADD;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: end if;
2106: END;
2107:
2108: PROCEDURE open_party_site_cursor(

Line 2336: RAISE FND_API.G_EXC_ERROR;

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

Line 2340: RAISE FND_API.G_EXC_ERROR;

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

Line 2344: RAISE FND_API.G_EXC_ERROR;

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

Line 2349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2483: RAISE FND_API.G_EXC_ERROR;

2479: when others then
2480: if (instrb(SQLERRM,'DRG-51030')>0) then
2481: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2482: FND_MSG_PUB.ADD;
2483: RAISE FND_API.G_EXC_ERROR;
2484: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2485: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2486: FND_MSG_PUB.ADD;
2487: RAISE FND_API.G_EXC_ERROR;

Line 2487: RAISE FND_API.G_EXC_ERROR;

2483: RAISE FND_API.G_EXC_ERROR;
2484: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2485: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2486: FND_MSG_PUB.ADD;
2487: RAISE FND_API.G_EXC_ERROR;
2488: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2490: FND_MSG_PUB.ADD;
2491: RAISE FND_API.G_EXC_ERROR;

Line 2491: RAISE FND_API.G_EXC_ERROR;

2487: RAISE FND_API.G_EXC_ERROR;
2488: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2490: FND_MSG_PUB.ADD;
2491: RAISE FND_API.G_EXC_ERROR;
2492: else
2493: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2495: FND_MSG_PUB.ADD;

Line 2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2492: else
2493: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2495: FND_MSG_PUB.ADD;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: end if;
2498: END;
2499:
2500: PROCEDURE open_contact_pt_cursor(

Line 2756: RAISE FND_API.G_EXC_ERROR;

2752: when others then
2753: if (instrb(SQLERRM,'DRG-51030')>0) then
2754: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;
2757: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2759: FND_MSG_PUB.ADD;
2760: RAISE FND_API.G_EXC_ERROR;

Line 2760: RAISE FND_API.G_EXC_ERROR;

2756: RAISE FND_API.G_EXC_ERROR;
2757: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2759: FND_MSG_PUB.ADD;
2760: RAISE FND_API.G_EXC_ERROR;
2761: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2762: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2763: FND_MSG_PUB.ADD;
2764: RAISE FND_API.G_EXC_ERROR;

Line 2764: RAISE FND_API.G_EXC_ERROR;

2760: RAISE FND_API.G_EXC_ERROR;
2761: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2762: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2763: FND_MSG_PUB.ADD;
2764: RAISE FND_API.G_EXC_ERROR;
2765: else
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2768: FND_MSG_PUB.ADD;

Line 2769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2765: else
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2768: FND_MSG_PUB.ADD;
2769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2770: end if;
2771: END;
2772:
2773:

Line 3033: RAISE FND_API.G_EXC_ERROR;

3029: 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);
3030: END IF;
3031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3032: FND_MSG_PUB.ADD;
3033: RAISE FND_API.G_EXC_ERROR;
3034: ELSE
3035: push_eval;
3036: RETURN;
3037: END IF;

Line 3081: RAISE FND_API.G_EXC_ERROR;

3077: 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);
3078: END IF;
3079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3080: FND_MSG_PUB.ADD;
3081: RAISE FND_API.G_EXC_ERROR;
3082: ELSE
3083: push_eval;
3084: RETURN;
3085: END IF;

Line 3154: RAISE FND_API.G_EXC_ERROR;

3150: 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);
3151: END IF;
3152: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3153: FND_MSG_PUB.ADD;
3154: RAISE FND_API.G_EXC_ERROR;
3155: ELSE
3156: push_eval;
3157: RETURN;
3158: END IF;

Line 3266: RAISE FND_API.G_EXC_ERROR;

3262: 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);
3263: END IF;
3264: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3265: FND_MSG_PUB.ADD;
3266: RAISE FND_API.G_EXC_ERROR;
3267: ELSE
3268: push_eval;
3269: RETURN;
3270: END IF;

Line 3377: RAISE FND_API.G_EXC_ERROR;

3373: 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);
3374: END IF;
3375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3376: FND_MSG_PUB.ADD;
3377: RAISE FND_API.G_EXC_ERROR;
3378: ELSE
3379: push_eval;
3380: RETURN;
3381: END IF;

Line 3602: RAISE FND_API.G_EXC_ERROR;

3598: 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);
3599: END IF;
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;
3603: END IF;
3604: ELSE
3605: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3606: 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 3610: RAISE FND_API.G_EXC_ERROR;

3606: 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);
3607: END IF;
3608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3609: FND_MSG_PUB.ADD;
3610: RAISE FND_API.G_EXC_ERROR;
3611: END IF;
3612: END IF;
3613: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3614: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3809: WHEN FND_API.G_EXC_ERROR THEN

3805: END IF;
3806: EXCEPTION
3807: WHEN L_RETURN_IMM_EXC THEN
3808: RETURN;
3809: WHEN FND_API.G_EXC_ERROR THEN
3810: RAISE FND_API.G_EXC_ERROR;
3811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3813: WHEN OTHERS THEN

Line 3810: RAISE FND_API.G_EXC_ERROR;

3806: EXCEPTION
3807: WHEN L_RETURN_IMM_EXC THEN
3808: RETURN;
3809: WHEN FND_API.G_EXC_ERROR THEN
3810: RAISE FND_API.G_EXC_ERROR;
3811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3813: WHEN OTHERS THEN
3814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3807: WHEN L_RETURN_IMM_EXC THEN
3808: RETURN;
3809: WHEN FND_API.G_EXC_ERROR THEN
3810: RAISE FND_API.G_EXC_ERROR;
3811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3813: WHEN OTHERS THEN
3814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3815: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_parties');

Line 3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3808: RETURN;
3809: WHEN FND_API.G_EXC_ERROR THEN
3810: RAISE FND_API.G_EXC_ERROR;
3811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3813: WHEN OTHERS THEN
3814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3815: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_parties');
3816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3815: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_parties');
3816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3817: FND_MSG_PUB.ADD;
3818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3819: END find_parties;
3820:
3821: PROCEDURE find_persons (
3822: p_rule_id IN NUMBER,

Line 4022: RAISE FND_API.G_EXC_ERROR;

4018: 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);
4019: END IF;
4020: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4021: FND_MSG_PUB.ADD;
4022: RAISE FND_API.G_EXC_ERROR;
4023: ELSE
4024: push_eval;
4025: RETURN;
4026: END IF;

Line 4070: RAISE FND_API.G_EXC_ERROR;

4066: 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);
4067: END IF;
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4069: FND_MSG_PUB.ADD;
4070: RAISE FND_API.G_EXC_ERROR;
4071: ELSE
4072: push_eval;
4073: RETURN;
4074: END IF;

Line 4106: RAISE FND_API.G_EXC_ERROR;

4102: when others then
4103: if (instrb(SQLERRM,'DRG-51030')>0) then
4104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4105: FND_MSG_PUB.ADD;
4106: RAISE FND_API.G_EXC_ERROR;
4107: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;

Line 4110: RAISE FND_API.G_EXC_ERROR;

4106: RAISE FND_API.G_EXC_ERROR;
4107: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;
4111: else
4112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4113: end if;
4114: END;

Line 4112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;
4111: else
4112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4113: end if;
4114: END;
4115:
4116: /** Private procedure to acquire and score at party site level ***/

Line 4182: RAISE FND_API.G_EXC_ERROR;

4178: 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);
4179: END IF;
4180: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4181: FND_MSG_PUB.ADD;
4182: RAISE FND_API.G_EXC_ERROR;
4183: ELSE
4184: push_eval;
4185: RETURN;
4186: END IF;

Line 4441: RAISE FND_API.G_EXC_ERROR;

4437: 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);
4438: END IF;
4439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4440: FND_MSG_PUB.ADD;
4441: RAISE FND_API.G_EXC_ERROR;
4442: ELSE
4443: push_eval;
4444: RETURN;
4445: END IF;

Line 4554: RAISE FND_API.G_EXC_ERROR;

4550: 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);
4551: END IF;
4552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4553: FND_MSG_PUB.ADD;
4554: RAISE FND_API.G_EXC_ERROR;
4555: END IF;
4556: ELSE
4557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4558: 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 4562: RAISE FND_API.G_EXC_ERROR;

4558: 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);
4559: END IF;
4560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4561: FND_MSG_PUB.ADD;
4562: RAISE FND_API.G_EXC_ERROR;
4563: END IF;
4564: END IF;
4565: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4566: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4676: WHEN FND_API.G_EXC_ERROR THEN

4672: END IF;
4673: EXCEPTION
4674: WHEN L_RETURN_IMM_EXC THEN
4675: RETURN;
4676: WHEN FND_API.G_EXC_ERROR THEN
4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN

Line 4677: RAISE FND_API.G_EXC_ERROR;

4673: EXCEPTION
4674: WHEN L_RETURN_IMM_EXC THEN
4675: RETURN;
4676: WHEN FND_API.G_EXC_ERROR THEN
4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4674: WHEN L_RETURN_IMM_EXC THEN
4675: RETURN;
4676: WHEN FND_API.G_EXC_ERROR THEN
4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');

Line 4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4675: RETURN;
4676: WHEN FND_API.G_EXC_ERROR THEN
4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4684: FND_MSG_PUB.ADD;
4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4686: END find_persons;
4687:
4688: PROCEDURE find_persons (
4689: p_rule_id IN NUMBER,

Line 4744: WHEN FND_API.G_EXC_ERROR THEN

4740: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4741: 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);
4742: END IF;
4743: EXCEPTION
4744: WHEN FND_API.G_EXC_ERROR THEN
4745: RAISE FND_API.G_EXC_ERROR;
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: WHEN OTHERS THEN

Line 4745: RAISE FND_API.G_EXC_ERROR;

4741: 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);
4742: END IF;
4743: EXCEPTION
4744: WHEN FND_API.G_EXC_ERROR THEN
4745: RAISE FND_API.G_EXC_ERROR;
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: WHEN OTHERS THEN
4749: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4742: END IF;
4743: EXCEPTION
4744: WHEN FND_API.G_EXC_ERROR THEN
4745: RAISE FND_API.G_EXC_ERROR;
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: WHEN OTHERS THEN
4749: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4750: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');

Line 4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4743: EXCEPTION
4744: WHEN FND_API.G_EXC_ERROR THEN
4745: RAISE FND_API.G_EXC_ERROR;
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: WHEN OTHERS THEN
4749: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4750: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');
4751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4749: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4750: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');
4751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4752: FND_MSG_PUB.ADD;
4753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4754: END find_party_details;
4755:
4756: PROCEDURE find_duplicate_parties (
4757: p_rule_id IN NUMBER,

Line 4861: WHEN FND_API.G_EXC_ERROR THEN

4857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4858: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4859: END IF;
4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN

Line 4862: RAISE FND_API.G_EXC_ERROR;

4858: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4859: END IF;
4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4946: WHEN FND_API.G_EXC_ERROR THEN

4942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4943: 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);
4944: END IF;
4945: EXCEPTION
4946: WHEN FND_API.G_EXC_ERROR THEN
4947: RAISE FND_API.G_EXC_ERROR;
4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: WHEN OTHERS THEN

Line 4947: RAISE FND_API.G_EXC_ERROR;

4943: 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);
4944: END IF;
4945: EXCEPTION
4946: WHEN FND_API.G_EXC_ERROR THEN
4947: RAISE FND_API.G_EXC_ERROR;
4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: WHEN OTHERS THEN
4951: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4944: END IF;
4945: EXCEPTION
4946: WHEN FND_API.G_EXC_ERROR THEN
4947: RAISE FND_API.G_EXC_ERROR;
4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: WHEN OTHERS THEN
4951: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4952: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');

Line 4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4945: EXCEPTION
4946: WHEN FND_API.G_EXC_ERROR THEN
4947: RAISE FND_API.G_EXC_ERROR;
4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: WHEN OTHERS THEN
4951: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4952: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');
4953: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4951: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4952: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');
4953: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4954: FND_MSG_PUB.ADD;
4955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4956: END find_duplicate_party_sites;
4957:
4958: PROCEDURE find_duplicate_contacts (
4959: p_rule_id IN NUMBER,

Line 5035: WHEN FND_API.G_EXC_ERROR THEN

5031: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5032: 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);
5033: END IF;
5034: EXCEPTION
5035: WHEN FND_API.G_EXC_ERROR THEN
5036: RAISE FND_API.G_EXC_ERROR;
5037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5039: WHEN OTHERS THEN

Line 5036: RAISE FND_API.G_EXC_ERROR;

5032: 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);
5033: END IF;
5034: EXCEPTION
5035: WHEN FND_API.G_EXC_ERROR THEN
5036: RAISE FND_API.G_EXC_ERROR;
5037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5039: WHEN OTHERS THEN
5040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5033: END IF;
5034: EXCEPTION
5035: WHEN FND_API.G_EXC_ERROR THEN
5036: RAISE FND_API.G_EXC_ERROR;
5037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5039: WHEN OTHERS THEN
5040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');

Line 5038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5034: EXCEPTION
5035: WHEN FND_API.G_EXC_ERROR THEN
5036: RAISE FND_API.G_EXC_ERROR;
5037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5039: WHEN OTHERS THEN
5040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');
5042: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');
5042: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5043: FND_MSG_PUB.ADD;
5044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5045: END find_duplicate_contacts;
5046:
5047: PROCEDURE find_duplicate_contact_points (
5048: p_rule_id IN NUMBER,

Line 5108: WHEN FND_API.G_EXC_ERROR THEN

5104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5105: 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);
5106: END IF;
5107: EXCEPTION
5108: WHEN FND_API.G_EXC_ERROR THEN
5109: RAISE FND_API.G_EXC_ERROR;
5110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: WHEN OTHERS THEN

Line 5109: RAISE FND_API.G_EXC_ERROR;

5105: 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);
5106: END IF;
5107: EXCEPTION
5108: WHEN FND_API.G_EXC_ERROR THEN
5109: RAISE FND_API.G_EXC_ERROR;
5110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: WHEN OTHERS THEN
5113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5106: END IF;
5107: EXCEPTION
5108: WHEN FND_API.G_EXC_ERROR THEN
5109: RAISE FND_API.G_EXC_ERROR;
5110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: WHEN OTHERS THEN
5113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5114: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');

Line 5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5107: EXCEPTION
5108: WHEN FND_API.G_EXC_ERROR THEN
5109: RAISE FND_API.G_EXC_ERROR;
5110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: WHEN OTHERS THEN
5113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5114: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');
5115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5114: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');
5115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5116: FND_MSG_PUB.ADD;
5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5118: END find_duplicate_contact_points;
5119:
5120: PROCEDURE find_parties_dynamic (
5121: p_rule_id IN NUMBER,

Line 5479: WHEN FND_API.G_EXC_ERROR THEN

5475: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5476: 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);
5477: END IF;
5478: EXCEPTION
5479: WHEN FND_API.G_EXC_ERROR THEN
5480: RAISE FND_API.G_EXC_ERROR;
5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5483: WHEN OTHERS THEN

Line 5480: RAISE FND_API.G_EXC_ERROR;

5476: 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);
5477: END IF;
5478: EXCEPTION
5479: WHEN FND_API.G_EXC_ERROR THEN
5480: RAISE FND_API.G_EXC_ERROR;
5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5483: WHEN OTHERS THEN
5484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5477: END IF;
5478: EXCEPTION
5479: WHEN FND_API.G_EXC_ERROR THEN
5480: RAISE FND_API.G_EXC_ERROR;
5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5483: WHEN OTHERS THEN
5484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5485: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');

Line 5482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5478: EXCEPTION
5479: WHEN FND_API.G_EXC_ERROR THEN
5480: RAISE FND_API.G_EXC_ERROR;
5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5483: WHEN OTHERS THEN
5484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5485: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5486: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5485: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5486: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5487: FND_MSG_PUB.ADD;
5488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5489: END call_api_dynamic;
5490:
5491:
5492: PROCEDURE get_matching_party_sites (

Line 5722: WHEN FND_API.G_EXC_ERROR THEN

5718: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5719: 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);
5720: END IF;
5721: EXCEPTION
5722: WHEN FND_API.G_EXC_ERROR THEN
5723: RAISE FND_API.G_EXC_ERROR;
5724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5726: WHEN OTHERS THEN

Line 5723: RAISE FND_API.G_EXC_ERROR;

5719: 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);
5720: END IF;
5721: EXCEPTION
5722: WHEN FND_API.G_EXC_ERROR THEN
5723: RAISE FND_API.G_EXC_ERROR;
5724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5726: WHEN OTHERS THEN
5727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5720: END IF;
5721: EXCEPTION
5722: WHEN FND_API.G_EXC_ERROR THEN
5723: RAISE FND_API.G_EXC_ERROR;
5724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5726: WHEN OTHERS THEN
5727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5728: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');

Line 5725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5721: EXCEPTION
5722: WHEN FND_API.G_EXC_ERROR THEN
5723: RAISE FND_API.G_EXC_ERROR;
5724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5726: WHEN OTHERS THEN
5727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5728: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5728: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5730: FND_MSG_PUB.ADD;
5731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5732: END get_matching_party_sites;
5733:
5734:
5735: PROCEDURE get_matching_contacts (

Line 5952: WHEN FND_API.G_EXC_ERROR THEN

5948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5949: 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);
5950: END IF;
5951: EXCEPTION
5952: WHEN FND_API.G_EXC_ERROR THEN
5953: RAISE FND_API.G_EXC_ERROR;
5954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5956: WHEN OTHERS THEN

Line 5953: RAISE FND_API.G_EXC_ERROR;

5949: 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);
5950: END IF;
5951: EXCEPTION
5952: WHEN FND_API.G_EXC_ERROR THEN
5953: RAISE FND_API.G_EXC_ERROR;
5954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5956: WHEN OTHERS THEN
5957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5950: END IF;
5951: EXCEPTION
5952: WHEN FND_API.G_EXC_ERROR THEN
5953: RAISE FND_API.G_EXC_ERROR;
5954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5956: WHEN OTHERS THEN
5957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5958: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');

Line 5955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5951: EXCEPTION
5952: WHEN FND_API.G_EXC_ERROR THEN
5953: RAISE FND_API.G_EXC_ERROR;
5954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5956: WHEN OTHERS THEN
5957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5958: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5958: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5960: FND_MSG_PUB.ADD;
5961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5962: END get_matching_contacts;
5963:
5964:
5965: PROCEDURE get_matching_contact_points (

Line 6094: WHEN FND_API.G_EXC_ERROR THEN

6090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6091: 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);
6092: END IF;
6093: EXCEPTION
6094: WHEN FND_API.G_EXC_ERROR THEN
6095: RAISE FND_API.G_EXC_ERROR;
6096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6098: WHEN OTHERS THEN

Line 6095: RAISE FND_API.G_EXC_ERROR;

6091: 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);
6092: END IF;
6093: EXCEPTION
6094: WHEN FND_API.G_EXC_ERROR THEN
6095: RAISE FND_API.G_EXC_ERROR;
6096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6098: WHEN OTHERS THEN
6099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6092: END IF;
6093: EXCEPTION
6094: WHEN FND_API.G_EXC_ERROR THEN
6095: RAISE FND_API.G_EXC_ERROR;
6096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6098: WHEN OTHERS THEN
6099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6100: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');

Line 6097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6093: EXCEPTION
6094: WHEN FND_API.G_EXC_ERROR THEN
6095: RAISE FND_API.G_EXC_ERROR;
6096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6098: WHEN OTHERS THEN
6099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6100: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');
6101: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6100: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');
6101: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6102: FND_MSG_PUB.ADD;
6103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6104: END get_matching_contact_points;
6105:
6106: /**********************************************************
6107: This procedure finds the score details for a specific party that

Line 6339: WHEN FND_API.G_EXC_ERROR THEN

6335: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6336: 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);
6337: END IF;
6338: EXCEPTION
6339: WHEN FND_API.G_EXC_ERROR THEN
6340: RAISE FND_API.G_EXC_ERROR;
6341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: WHEN OTHERS THEN

Line 6340: RAISE FND_API.G_EXC_ERROR;

6336: 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);
6337: END IF;
6338: EXCEPTION
6339: WHEN FND_API.G_EXC_ERROR THEN
6340: RAISE FND_API.G_EXC_ERROR;
6341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: WHEN OTHERS THEN
6344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6337: END IF;
6338: EXCEPTION
6339: WHEN FND_API.G_EXC_ERROR THEN
6340: RAISE FND_API.G_EXC_ERROR;
6341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: WHEN OTHERS THEN
6344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6345: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_score_details');

Line 6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6338: EXCEPTION
6339: WHEN FND_API.G_EXC_ERROR THEN
6340: RAISE FND_API.G_EXC_ERROR;
6341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: WHEN OTHERS THEN
6344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6345: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_score_details');
6346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6345: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_score_details');
6346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6347: FND_MSG_PUB.ADD;
6348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6349: END get_score_details;
6350:
6351:
6352: /************************************************

Line 6462: WHEN FND_API.G_EXC_ERROR THEN

6458: END LOOP;
6459: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6460: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6461: EXCEPTION
6462: WHEN FND_API.G_EXC_ERROR THEN
6463: RAISE FND_API.G_EXC_ERROR;
6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: WHEN OTHERS THEN

Line 6463: RAISE FND_API.G_EXC_ERROR;

6459: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6460: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6461: EXCEPTION
6462: WHEN FND_API.G_EXC_ERROR THEN
6463: RAISE FND_API.G_EXC_ERROR;
6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6460: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6461: EXCEPTION
6462: WHEN FND_API.G_EXC_ERROR THEN
6463: RAISE FND_API.G_EXC_ERROR;
6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6461: EXCEPTION
6462: WHEN FND_API.G_EXC_ERROR THEN
6463: RAISE FND_API.G_EXC_ERROR;
6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6472: END get_party_for_search;
6473:
6474: PROCEDURE get_search_criteria (
6475: p_party_id IN NUMBER,

Line 6514: WHEN FND_API.G_EXC_ERROR THEN

6510: END IF;
6511: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6512: END IF;
6513: EXCEPTION
6514: WHEN FND_API.G_EXC_ERROR THEN
6515: RAISE FND_API.G_EXC_ERROR;
6516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6518: WHEN OTHERS THEN

Line 6515: RAISE FND_API.G_EXC_ERROR;

6511: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6512: END IF;
6513: EXCEPTION
6514: WHEN FND_API.G_EXC_ERROR THEN
6515: RAISE FND_API.G_EXC_ERROR;
6516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6518: WHEN OTHERS THEN
6519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6512: END IF;
6513: EXCEPTION
6514: WHEN FND_API.G_EXC_ERROR THEN
6515: RAISE FND_API.G_EXC_ERROR;
6516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6518: WHEN OTHERS THEN
6519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6520: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6513: EXCEPTION
6514: WHEN FND_API.G_EXC_ERROR THEN
6515: RAISE FND_API.G_EXC_ERROR;
6516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6518: WHEN OTHERS THEN
6519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6520: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6521: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6520: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6521: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6522: FND_MSG_PUB.ADD;
6523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6524: END get_search_criteria;
6525:
6526:
6527: /************************************************

Line 6598: RAISE FND_API.G_EXC_ERROR;

6594: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6595: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6596: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6597: FND_MSG_PUB.ADD;
6598: RAISE FND_API.G_EXC_ERROR;
6599: END get_party_rec;
6600:
6601: /************************************************
6602: This procedure retrieves the match rule party site attributes into

Line 6660: RAISE FND_API.G_EXC_ERROR;

6656: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6659: FND_MSG_PUB.ADD;
6660: RAISE FND_API.G_EXC_ERROR;
6661: END get_party_site_rec;
6662:
6663: /************************************************
6664: This procedure retrieves the match rule contact attributes into

Line 6718: RAISE FND_API.G_EXC_ERROR;

6714: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6715: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;
6718: RAISE FND_API.G_EXC_ERROR;
6719: END get_contact_rec;
6720:
6721: /************************************************
6722: This procedure retrieves the match rule contact point attributes into

Line 6774: RAISE FND_API.G_EXC_ERROR;

6770: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6771: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6773: FND_MSG_PUB.ADD;
6774: RAISE FND_API.G_EXC_ERROR;
6775: END get_contact_point_rec;
6776:
6777: /************************************************
6778: This procedure maps a search record from the logical

Line 6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6983: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6984: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6986: FND_MSG_PUB.ADD;
6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6988: END;
6989:
6990:
6991: /************************************************

Line 7199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 7315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7311: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7312: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7314: FND_MSG_PUB.ADD;
7315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7316: END;
7317:
7318:
7319: /************************************************

Line 7446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7442: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7443: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7445: FND_MSG_PUB.ADD;
7446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7447: END;
7448:
7449:
7450: /************************************************

Line 7471: RAISE FND_API.G_EXC_ERROR;

7467: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7468: ) THEN
7469: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7470: FND_MSG_PUB.ADD;
7471: RAISE FND_API.G_EXC_ERROR;
7472: END IF;
7473: END LOOP;
7474:
7475: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 7535: WHEN FND_API.G_EXC_ERROR THEN

7531: END IF;
7532: END LOOP;
7533: RETURN FALSE;
7534: EXCEPTION
7535: WHEN FND_API.G_EXC_ERROR THEN
7536: RAISE FND_API.G_EXC_ERROR;
7537: WHEN OTHERS THEN
7538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7539: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 7536: RAISE FND_API.G_EXC_ERROR;

7532: END LOOP;
7533: RETURN FALSE;
7534: EXCEPTION
7535: WHEN FND_API.G_EXC_ERROR THEN
7536: RAISE FND_API.G_EXC_ERROR;
7537: WHEN OTHERS THEN
7538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7539: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7539: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7541: FND_MSG_PUB.ADD;
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7543: END check_prim_cond;
7544:
7545: /************************************************
7546: This procedure checks if the input search condition

Line 7604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7601: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7603: FND_MSG_PUB.ADD;
7604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7605: END check_party_site_cond;
7606:
7607: /************************************************
7608: This procedure checks if the input search condition

Line 7660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7657: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7659: FND_MSG_PUB.ADD;
7660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7661: END check_contact_cond;
7662:
7663: /************************************************
7664: This procedure checks if the input search condition

Line 7681: RAISE FND_API.G_EXC_ERROR;

7677: FOR I IN 1..p_contact_point_list.COUNT LOOP
7678: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7679: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7680: FND_MSG_PUB.ADD;
7681: RAISE FND_API.G_EXC_ERROR;
7682: END IF;
7683: END LOOP;
7684:
7685: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7703: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7704: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7706: FND_MSG_PUB.ADD;
7707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7708: END check_contact_point_cond;
7709:
7710: FUNCTION check_staged RETURN BOOLEAN IS
7711: