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_MSG_PUB

Line 101: FND_MSG_PUB.ADD;

97: exception
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;

Line 105: FND_MSG_PUB.ADD;

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;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;

Line 1143: FND_MSG_PUB.ADD;

1139: WHEN OTHERS THEN
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:

Line 1168: FND_MSG_PUB.ADD;

1164: WHEN OTHERS THEN
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:

Line 1188: FND_MSG_PUB.ADD;

1184: WHEN OTHERS THEN
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:

Line 1208: FND_MSG_PUB.ADD;

1204: WHEN OTHERS THEN
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 (

Line 1275: FND_MSG_PUB.ADD;

1271: p_party_site_list,
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);

Line 1580: FND_MSG_PUB.ADD;

1576: END IF;
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

Line 1679: FND_MSG_PUB.ADD;

1675: -- Add the search criteria to query string
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;

Line 1725: FND_MSG_PUB.ADD;

1721: -- Add the search criteria to query string
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;

Line 1806: FND_MSG_PUB.ADD;

1802: -- Add the search criteria to query string
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;

Line 2090: FND_MSG_PUB.ADD;

2086: exception
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;

Line 2094: FND_MSG_PUB.ADD;

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;
2096: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2098: FND_MSG_PUB.ADD;

Line 2098: FND_MSG_PUB.ADD;

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;
2100: else
2101: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2103: 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;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: end if;
2106: END;
2107:

Line 2335: FND_MSG_PUB.ADD;

2331: exception
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;

Line 2339: FND_MSG_PUB.ADD;

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;
2341: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2342: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2343: FND_MSG_PUB.ADD;

Line 2343: FND_MSG_PUB.ADD;

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;
2345: else
2346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2347: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2348: 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;
2349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2350: end if;
2351: END;
2352:

Line 2482: FND_MSG_PUB.ADD;

2478: exception
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;

Line 2486: FND_MSG_PUB.ADD;

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;
2488: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2490: FND_MSG_PUB.ADD;

Line 2490: FND_MSG_PUB.ADD;

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;
2492: else
2493: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2495: 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;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: end if;
2498: END;
2499:

Line 2755: FND_MSG_PUB.ADD;

2751: exception
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;

Line 2759: FND_MSG_PUB.ADD;

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;
2761: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2762: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2763: FND_MSG_PUB.ADD;

Line 2763: FND_MSG_PUB.ADD;

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;
2765: else
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2768: 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;
2769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2770: end if;
2771: END;
2772:

Line 3032: FND_MSG_PUB.ADD;

3028: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3080: FND_MSG_PUB.ADD;

3076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3153: FND_MSG_PUB.ADD;

3149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3265: FND_MSG_PUB.ADD;

3261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3376: FND_MSG_PUB.ADD;

3372: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3601: FND_MSG_PUB.ADD;

3597: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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

Line 3609: FND_MSG_PUB.ADD;

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);
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

Line 3817: FND_MSG_PUB.ADD;

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 );
3817: FND_MSG_PUB.ADD;
3818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3819: END find_parties;
3820:
3821: PROCEDURE find_persons (

Line 4021: FND_MSG_PUB.ADD;

4017: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 4069: FND_MSG_PUB.ADD;

4065: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 4105: FND_MSG_PUB.ADD;

4101: exception
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;

Line 4109: FND_MSG_PUB.ADD;

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;
4111: else
4112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4113: end if;

Line 4181: FND_MSG_PUB.ADD;

4177: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 4440: FND_MSG_PUB.ADD;

4436: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 4553: FND_MSG_PUB.ADD;

4549: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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

Line 4561: FND_MSG_PUB.ADD;

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);
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

Line 4684: FND_MSG_PUB.ADD;

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 );
4684: FND_MSG_PUB.ADD;
4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4686: END find_persons;
4687:
4688: PROCEDURE find_persons (

Line 4752: FND_MSG_PUB.ADD;

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 );
4752: FND_MSG_PUB.ADD;
4753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4754: END find_party_details;
4755:
4756: PROCEDURE find_duplicate_parties (

Line 4869: FND_MSG_PUB.ADD;

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 );
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 (

Line 4954: FND_MSG_PUB.ADD;

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 );
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 (

Line 5043: FND_MSG_PUB.ADD;

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 );
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 (

Line 5116: FND_MSG_PUB.ADD;

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 );
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 (

Line 5487: FND_MSG_PUB.ADD;

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 );
5487: FND_MSG_PUB.ADD;
5488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5489: END call_api_dynamic;
5490:
5491:

Line 5730: FND_MSG_PUB.ADD;

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 );
5730: FND_MSG_PUB.ADD;
5731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5732: END get_matching_party_sites;
5733:
5734:

Line 5960: FND_MSG_PUB.ADD;

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 );
5960: FND_MSG_PUB.ADD;
5961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5962: END get_matching_contacts;
5963:
5964:

Line 6102: FND_MSG_PUB.ADD;

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 );
6102: FND_MSG_PUB.ADD;
6103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6104: END get_matching_contact_points;
6105:
6106: /**********************************************************

Line 6347: FND_MSG_PUB.ADD;

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 );
6347: FND_MSG_PUB.ADD;
6348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6349: END get_score_details;
6350:
6351:

Line 6470: FND_MSG_PUB.ADD;

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 );
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 (

Line 6522: FND_MSG_PUB.ADD;

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 );
6522: FND_MSG_PUB.ADD;
6523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6524: END get_search_criteria;
6525:
6526:

Line 6597: FND_MSG_PUB.ADD;

6593: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_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: /************************************************

Line 6659: FND_MSG_PUB.ADD;

6655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_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: /************************************************

Line 6717: FND_MSG_PUB.ADD;

6713: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_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: /************************************************

Line 6773: FND_MSG_PUB.ADD;

6769: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_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: /************************************************

Line 6986: FND_MSG_PUB.ADD;

6982: WHEN OTHERS THEN
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:

Line 7198: FND_MSG_PUB.ADD;

7194: WHEN OTHERS THEN
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:

Line 7314: FND_MSG_PUB.ADD;

7310: WHEN OTHERS THEN
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:

Line 7445: FND_MSG_PUB.ADD;

7441: WHEN OTHERS THEN
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:

Line 7470: FND_MSG_PUB.ADD;

7466: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
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:

Line 7541: FND_MSG_PUB.ADD;

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 );
7541: FND_MSG_PUB.ADD;
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7543: END check_prim_cond;
7544:
7545: /************************************************

Line 7603: FND_MSG_PUB.ADD;

7599: WHEN OTHERS THEN
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: /************************************************

Line 7659: FND_MSG_PUB.ADD;

7655: WHEN OTHERS THEN
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: /************************************************

Line 7680: FND_MSG_PUB.ADD;

7676:
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:

Line 7706: FND_MSG_PUB.ADD;

7702: WHEN OTHERS THEN
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