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

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

Line 2097: RAISE FND_API.G_EXC_ERROR;

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

Line 2101: RAISE FND_API.G_EXC_ERROR;

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

Line 2106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2338: RAISE FND_API.G_EXC_ERROR;

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

Line 2342: RAISE FND_API.G_EXC_ERROR;

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

Line 2346: RAISE FND_API.G_EXC_ERROR;

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

Line 2351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2485: RAISE FND_API.G_EXC_ERROR;

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

Line 2489: RAISE FND_API.G_EXC_ERROR;

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

Line 2493: RAISE FND_API.G_EXC_ERROR;

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

Line 2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2758: RAISE FND_API.G_EXC_ERROR;

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

Line 2762: RAISE FND_API.G_EXC_ERROR;

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

Line 2766: RAISE FND_API.G_EXC_ERROR;

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

Line 2771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3036: RAISE FND_API.G_EXC_ERROR;

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

Line 3084: RAISE FND_API.G_EXC_ERROR;

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

Line 3157: RAISE FND_API.G_EXC_ERROR;

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

Line 3269: RAISE FND_API.G_EXC_ERROR;

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

Line 3380: RAISE FND_API.G_EXC_ERROR;

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

Line 3605: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3812: WHEN FND_API.G_EXC_ERROR THEN

3808: END IF;
3809: EXCEPTION
3810: WHEN L_RETURN_IMM_EXC THEN
3811: RETURN;
3812: WHEN FND_API.G_EXC_ERROR THEN
3813: RAISE FND_API.G_EXC_ERROR;
3814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3816: WHEN OTHERS THEN

Line 3813: RAISE FND_API.G_EXC_ERROR;

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

Line 3814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4026: RAISE FND_API.G_EXC_ERROR;

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

Line 4074: RAISE FND_API.G_EXC_ERROR;

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

Line 4110: RAISE FND_API.G_EXC_ERROR;

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

Line 4114: RAISE FND_API.G_EXC_ERROR;

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

Line 4116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4186: RAISE FND_API.G_EXC_ERROR;

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

Line 4445: RAISE FND_API.G_EXC_ERROR;

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

Line 4558: RAISE FND_API.G_EXC_ERROR;

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

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

Line 4680: WHEN FND_API.G_EXC_ERROR THEN

4676: END IF;
4677: EXCEPTION
4678: WHEN L_RETURN_IMM_EXC THEN
4679: RETURN;
4680: WHEN FND_API.G_EXC_ERROR THEN
4681: RAISE FND_API.G_EXC_ERROR;
4682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4684: WHEN OTHERS THEN

Line 4681: RAISE FND_API.G_EXC_ERROR;

4677: EXCEPTION
4678: WHEN L_RETURN_IMM_EXC THEN
4679: RETURN;
4680: WHEN FND_API.G_EXC_ERROR THEN
4681: RAISE FND_API.G_EXC_ERROR;
4682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4684: WHEN OTHERS THEN
4685: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4678: WHEN L_RETURN_IMM_EXC THEN
4679: RETURN;
4680: WHEN FND_API.G_EXC_ERROR THEN
4681: RAISE FND_API.G_EXC_ERROR;
4682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4684: WHEN OTHERS THEN
4685: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4686: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');

Line 4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4679: RETURN;
4680: WHEN FND_API.G_EXC_ERROR THEN
4681: RAISE FND_API.G_EXC_ERROR;
4682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4684: WHEN OTHERS THEN
4685: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4686: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');
4687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4748: WHEN FND_API.G_EXC_ERROR THEN

4744: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4745: 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);
4746: END IF;
4747: EXCEPTION
4748: WHEN FND_API.G_EXC_ERROR THEN
4749: RAISE FND_API.G_EXC_ERROR;
4750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4752: WHEN OTHERS THEN

Line 4749: RAISE FND_API.G_EXC_ERROR;

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

Line 4750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4746: END IF;
4747: EXCEPTION
4748: WHEN FND_API.G_EXC_ERROR THEN
4749: RAISE FND_API.G_EXC_ERROR;
4750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4752: WHEN OTHERS THEN
4753: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4754: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');

Line 4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4747: EXCEPTION
4748: WHEN FND_API.G_EXC_ERROR THEN
4749: RAISE FND_API.G_EXC_ERROR;
4750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4752: WHEN OTHERS THEN
4753: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4754: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');
4755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4865: WHEN FND_API.G_EXC_ERROR THEN

4861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4862: 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);
4863: END IF;
4864: EXCEPTION
4865: WHEN FND_API.G_EXC_ERROR THEN
4866: RAISE FND_API.G_EXC_ERROR;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN

Line 4866: RAISE FND_API.G_EXC_ERROR;

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

Line 4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4863: END IF;
4864: EXCEPTION
4865: WHEN FND_API.G_EXC_ERROR THEN
4866: RAISE FND_API.G_EXC_ERROR;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_parties');

Line 4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4864: EXCEPTION
4865: WHEN FND_API.G_EXC_ERROR THEN
4866: RAISE FND_API.G_EXC_ERROR;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_parties');
4872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4950: WHEN FND_API.G_EXC_ERROR THEN

4946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4947: 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);
4948: END IF;
4949: EXCEPTION
4950: WHEN FND_API.G_EXC_ERROR THEN
4951: RAISE FND_API.G_EXC_ERROR;
4952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4954: WHEN OTHERS THEN

Line 4951: RAISE FND_API.G_EXC_ERROR;

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

Line 4952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4948: END IF;
4949: EXCEPTION
4950: WHEN FND_API.G_EXC_ERROR THEN
4951: RAISE FND_API.G_EXC_ERROR;
4952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4954: WHEN OTHERS THEN
4955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4956: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');

Line 4953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4949: EXCEPTION
4950: WHEN FND_API.G_EXC_ERROR THEN
4951: RAISE FND_API.G_EXC_ERROR;
4952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4954: WHEN OTHERS THEN
4955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4956: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');
4957: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5039: WHEN FND_API.G_EXC_ERROR THEN

5035: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5036: 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);
5037: END IF;
5038: EXCEPTION
5039: WHEN FND_API.G_EXC_ERROR THEN
5040: RAISE FND_API.G_EXC_ERROR;
5041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5043: WHEN OTHERS THEN

Line 5040: RAISE FND_API.G_EXC_ERROR;

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

Line 5041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5037: END IF;
5038: EXCEPTION
5039: WHEN FND_API.G_EXC_ERROR THEN
5040: RAISE FND_API.G_EXC_ERROR;
5041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5043: WHEN OTHERS THEN
5044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');

Line 5042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5038: EXCEPTION
5039: WHEN FND_API.G_EXC_ERROR THEN
5040: RAISE FND_API.G_EXC_ERROR;
5041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5043: WHEN OTHERS THEN
5044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');
5046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5112: WHEN FND_API.G_EXC_ERROR THEN

5108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5109: 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);
5110: END IF;
5111: EXCEPTION
5112: WHEN FND_API.G_EXC_ERROR THEN
5113: RAISE FND_API.G_EXC_ERROR;
5114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5116: WHEN OTHERS THEN

Line 5113: RAISE FND_API.G_EXC_ERROR;

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

Line 5114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5110: END IF;
5111: EXCEPTION
5112: WHEN FND_API.G_EXC_ERROR THEN
5113: RAISE FND_API.G_EXC_ERROR;
5114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5116: WHEN OTHERS THEN
5117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');

Line 5115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5111: EXCEPTION
5112: WHEN FND_API.G_EXC_ERROR THEN
5113: RAISE FND_API.G_EXC_ERROR;
5114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5116: WHEN OTHERS THEN
5117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');
5119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5483: WHEN FND_API.G_EXC_ERROR THEN

5479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5480: 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);
5481: END IF;
5482: EXCEPTION
5483: WHEN FND_API.G_EXC_ERROR THEN
5484: RAISE FND_API.G_EXC_ERROR;
5485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5487: WHEN OTHERS THEN

Line 5484: RAISE FND_API.G_EXC_ERROR;

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

Line 5485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5481: END IF;
5482: EXCEPTION
5483: WHEN FND_API.G_EXC_ERROR THEN
5484: RAISE FND_API.G_EXC_ERROR;
5485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5487: WHEN OTHERS THEN
5488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');

Line 5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5482: EXCEPTION
5483: WHEN FND_API.G_EXC_ERROR THEN
5484: RAISE FND_API.G_EXC_ERROR;
5485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5487: WHEN OTHERS THEN
5488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5493: END call_api_dynamic;
5494:
5495:
5496: PROCEDURE get_matching_party_sites (

Line 5726: WHEN FND_API.G_EXC_ERROR THEN

5722: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5723: 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);
5724: END IF;
5725: EXCEPTION
5726: WHEN FND_API.G_EXC_ERROR THEN
5727: RAISE FND_API.G_EXC_ERROR;
5728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5730: WHEN OTHERS THEN

Line 5727: RAISE FND_API.G_EXC_ERROR;

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

Line 5728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5724: END IF;
5725: EXCEPTION
5726: WHEN FND_API.G_EXC_ERROR THEN
5727: RAISE FND_API.G_EXC_ERROR;
5728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5730: WHEN OTHERS THEN
5731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5732: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');

Line 5729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5725: EXCEPTION
5726: WHEN FND_API.G_EXC_ERROR THEN
5727: RAISE FND_API.G_EXC_ERROR;
5728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5730: WHEN OTHERS THEN
5731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5732: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5732: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5734: FND_MSG_PUB.ADD;
5735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5736: END get_matching_party_sites;
5737:
5738:
5739: PROCEDURE get_matching_contacts (

Line 5956: WHEN FND_API.G_EXC_ERROR THEN

5952: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5953: 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);
5954: END IF;
5955: EXCEPTION
5956: WHEN FND_API.G_EXC_ERROR THEN
5957: RAISE FND_API.G_EXC_ERROR;
5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5960: WHEN OTHERS THEN

Line 5957: RAISE FND_API.G_EXC_ERROR;

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

Line 5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5954: END IF;
5955: EXCEPTION
5956: WHEN FND_API.G_EXC_ERROR THEN
5957: RAISE FND_API.G_EXC_ERROR;
5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5960: WHEN OTHERS THEN
5961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');

Line 5959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5955: EXCEPTION
5956: WHEN FND_API.G_EXC_ERROR THEN
5957: RAISE FND_API.G_EXC_ERROR;
5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5960: WHEN OTHERS THEN
5961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5964: FND_MSG_PUB.ADD;
5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5966: END get_matching_contacts;
5967:
5968:
5969: PROCEDURE get_matching_contact_points (

Line 6098: WHEN FND_API.G_EXC_ERROR THEN

6094: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6095: 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);
6096: END IF;
6097: EXCEPTION
6098: WHEN FND_API.G_EXC_ERROR THEN
6099: RAISE FND_API.G_EXC_ERROR;
6100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: WHEN OTHERS THEN

Line 6099: RAISE FND_API.G_EXC_ERROR;

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

Line 6100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6096: END IF;
6097: EXCEPTION
6098: WHEN FND_API.G_EXC_ERROR THEN
6099: RAISE FND_API.G_EXC_ERROR;
6100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');

Line 6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6097: EXCEPTION
6098: WHEN FND_API.G_EXC_ERROR THEN
6099: RAISE FND_API.G_EXC_ERROR;
6100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6344: WHEN FND_API.G_EXC_ERROR THEN

6340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6341: 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);
6342: END IF;
6343: EXCEPTION
6344: WHEN FND_API.G_EXC_ERROR THEN
6345: RAISE FND_API.G_EXC_ERROR;
6346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6348: WHEN OTHERS THEN

Line 6345: RAISE FND_API.G_EXC_ERROR;

6341: 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);
6342: END IF;
6343: EXCEPTION
6344: WHEN FND_API.G_EXC_ERROR THEN
6345: RAISE FND_API.G_EXC_ERROR;
6346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6348: WHEN OTHERS THEN
6349: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 6347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6467: WHEN FND_API.G_EXC_ERROR THEN

6463: END LOOP;
6464: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6465: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6466: EXCEPTION
6467: WHEN FND_API.G_EXC_ERROR THEN
6468: RAISE FND_API.G_EXC_ERROR;
6469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6471: WHEN OTHERS THEN

Line 6468: RAISE FND_API.G_EXC_ERROR;

6464: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6465: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6466: EXCEPTION
6467: WHEN FND_API.G_EXC_ERROR THEN
6468: RAISE FND_API.G_EXC_ERROR;
6469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6471: WHEN OTHERS THEN
6472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6465: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6466: EXCEPTION
6467: WHEN FND_API.G_EXC_ERROR THEN
6468: RAISE FND_API.G_EXC_ERROR;
6469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6471: WHEN OTHERS THEN
6472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6473: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6466: EXCEPTION
6467: WHEN FND_API.G_EXC_ERROR THEN
6468: RAISE FND_API.G_EXC_ERROR;
6469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6471: WHEN OTHERS THEN
6472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6473: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6473: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6475: FND_MSG_PUB.ADD;
6476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6477: END get_party_for_search;
6478:
6479: PROCEDURE get_search_criteria (
6480: p_party_id IN NUMBER,

Line 6519: WHEN FND_API.G_EXC_ERROR THEN

6515: END IF;
6516: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6517: END IF;
6518: EXCEPTION
6519: WHEN FND_API.G_EXC_ERROR THEN
6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6523: WHEN OTHERS THEN

Line 6520: RAISE FND_API.G_EXC_ERROR;

6516: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6517: END IF;
6518: EXCEPTION
6519: WHEN FND_API.G_EXC_ERROR THEN
6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6523: WHEN OTHERS THEN
6524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6517: END IF;
6518: EXCEPTION
6519: WHEN FND_API.G_EXC_ERROR THEN
6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6523: WHEN OTHERS THEN
6524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6525: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6518: EXCEPTION
6519: WHEN FND_API.G_EXC_ERROR THEN
6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6523: WHEN OTHERS THEN
6524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6525: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6525: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6529: END get_search_criteria;
6530:
6531:
6532: /************************************************

Line 6603: RAISE FND_API.G_EXC_ERROR;

6599: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6600: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6602: FND_MSG_PUB.ADD;
6603: RAISE FND_API.G_EXC_ERROR;
6604: END get_party_rec;
6605:
6606: /************************************************
6607: This procedure retrieves the match rule party site attributes into

Line 6665: RAISE FND_API.G_EXC_ERROR;

6661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6664: FND_MSG_PUB.ADD;
6665: RAISE FND_API.G_EXC_ERROR;
6666: END get_party_site_rec;
6667:
6668: /************************************************
6669: This procedure retrieves the match rule contact attributes into

Line 6723: RAISE FND_API.G_EXC_ERROR;

6719: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6720: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;
6723: RAISE FND_API.G_EXC_ERROR;
6724: END get_contact_rec;
6725:
6726: /************************************************
6727: This procedure retrieves the match rule contact point attributes into

Line 6779: RAISE FND_API.G_EXC_ERROR;

6775: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;
6779: RAISE FND_API.G_EXC_ERROR;
6780: END get_contact_point_rec;
6781:
6782: /************************************************
6783: This procedure maps a search record from the logical

Line 6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 7204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7203: FND_MSG_PUB.ADD;
7204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7205: END;
7206:
7207:
7208: /************************************************

Line 7320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7316: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7317: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7319: FND_MSG_PUB.ADD;
7320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7321: END;
7322:
7323:
7324: /************************************************

Line 7451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7447: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7448: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7449: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7450: FND_MSG_PUB.ADD;
7451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7452: END;
7453:
7454:
7455: /************************************************

Line 7476: RAISE FND_API.G_EXC_ERROR;

7472: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7473: ) THEN
7474: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7475: FND_MSG_PUB.ADD;
7476: RAISE FND_API.G_EXC_ERROR;
7477: END IF;
7478: END LOOP;
7479:
7480: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 7540: WHEN FND_API.G_EXC_ERROR THEN

7536: END IF;
7537: END LOOP;
7538: RETURN FALSE;
7539: EXCEPTION
7540: WHEN FND_API.G_EXC_ERROR THEN
7541: RAISE FND_API.G_EXC_ERROR;
7542: WHEN OTHERS THEN
7543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7544: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 7541: RAISE FND_API.G_EXC_ERROR;

7537: END LOOP;
7538: RETURN FALSE;
7539: EXCEPTION
7540: WHEN FND_API.G_EXC_ERROR THEN
7541: RAISE FND_API.G_EXC_ERROR;
7542: WHEN OTHERS THEN
7543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7544: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 7547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7544: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7546: FND_MSG_PUB.ADD;
7547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7548: END check_prim_cond;
7549:
7550: /************************************************
7551: This procedure checks if the input search condition

Line 7609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7605: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7606: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7608: FND_MSG_PUB.ADD;
7609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7610: END check_party_site_cond;
7611:
7612: /************************************************
7613: This procedure checks if the input search condition

Line 7665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7661: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7662: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7664: FND_MSG_PUB.ADD;
7665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7666: END check_contact_cond;
7667:
7668: /************************************************
7669: This procedure checks if the input search condition

Line 7686: RAISE FND_API.G_EXC_ERROR;

7682: FOR I IN 1..p_contact_point_list.COUNT LOOP
7683: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7684: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7685: FND_MSG_PUB.ADD;
7686: RAISE FND_API.G_EXC_ERROR;
7687: END IF;
7688: END LOOP;
7689:
7690: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7708: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7709: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7711: FND_MSG_PUB.ADD;
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: END check_contact_point_cond;
7714:
7715: FUNCTION check_staged RETURN BOOLEAN IS
7716: