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 2092: FND_MSG_PUB.ADD;

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

Line 2096: FND_MSG_PUB.ADD;

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

Line 2100: FND_MSG_PUB.ADD;

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

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

Line 2337: FND_MSG_PUB.ADD;

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

Line 2341: FND_MSG_PUB.ADD;

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

Line 2345: FND_MSG_PUB.ADD;

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

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

Line 2484: FND_MSG_PUB.ADD;

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

Line 2488: FND_MSG_PUB.ADD;

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

Line 2492: FND_MSG_PUB.ADD;

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

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

Line 2757: FND_MSG_PUB.ADD;

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

Line 2761: FND_MSG_PUB.ADD;

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

Line 2765: FND_MSG_PUB.ADD;

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

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

Line 3035: FND_MSG_PUB.ADD;

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

Line 3083: FND_MSG_PUB.ADD;

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

Line 3156: FND_MSG_PUB.ADD;

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

Line 3268: FND_MSG_PUB.ADD;

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

Line 3379: FND_MSG_PUB.ADD;

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

Line 3604: FND_MSG_PUB.ADD;

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

Line 3612: FND_MSG_PUB.ADD;

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

Line 3820: FND_MSG_PUB.ADD;

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

Line 4025: FND_MSG_PUB.ADD;

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

Line 4073: FND_MSG_PUB.ADD;

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

Line 4109: FND_MSG_PUB.ADD;

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

Line 4113: FND_MSG_PUB.ADD;

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;
4115: else
4116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4117: end if;

Line 4185: FND_MSG_PUB.ADD;

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

Line 4444: FND_MSG_PUB.ADD;

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

Line 4557: FND_MSG_PUB.ADD;

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

Line 4565: FND_MSG_PUB.ADD;

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

Line 4688: FND_MSG_PUB.ADD;

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 );
4688: FND_MSG_PUB.ADD;
4689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4690: END find_persons;
4691:
4692: PROCEDURE find_persons (

Line 4756: FND_MSG_PUB.ADD;

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 );
4756: FND_MSG_PUB.ADD;
4757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4758: END find_party_details;
4759:
4760: PROCEDURE find_duplicate_parties (

Line 4873: FND_MSG_PUB.ADD;

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

Line 4958: FND_MSG_PUB.ADD;

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

Line 5047: FND_MSG_PUB.ADD;

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

Line 5120: FND_MSG_PUB.ADD;

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

Line 5491: FND_MSG_PUB.ADD;

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 );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5493: END call_api_dynamic;
5494:
5495:

Line 5734: FND_MSG_PUB.ADD;

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 );
5734: FND_MSG_PUB.ADD;
5735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5736: END get_matching_party_sites;
5737:
5738:

Line 5964: FND_MSG_PUB.ADD;

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 );
5964: FND_MSG_PUB.ADD;
5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5966: END get_matching_contacts;
5967:
5968:

Line 6106: FND_MSG_PUB.ADD;

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 );
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6108: END get_matching_contact_points;
6109:
6110: /**********************************************************

Line 6352: FND_MSG_PUB.ADD;

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 );
6352: FND_MSG_PUB.ADD;
6353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6354: END get_score_details;
6355:
6356:

Line 6475: FND_MSG_PUB.ADD;

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

Line 6527: FND_MSG_PUB.ADD;

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 );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6529: END get_search_criteria;
6530:
6531:

Line 6602: FND_MSG_PUB.ADD;

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

Line 6664: FND_MSG_PUB.ADD;

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

Line 6722: FND_MSG_PUB.ADD;

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

Line 6778: FND_MSG_PUB.ADD;

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

Line 6991: FND_MSG_PUB.ADD;

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

Line 7203: FND_MSG_PUB.ADD;

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

Line 7319: FND_MSG_PUB.ADD;

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

Line 7450: FND_MSG_PUB.ADD;

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

Line 7475: FND_MSG_PUB.ADD;

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

Line 7546: FND_MSG_PUB.ADD;

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 );
7546: FND_MSG_PUB.ADD;
7547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7548: END check_prim_cond;
7549:
7550: /************************************************

Line 7608: FND_MSG_PUB.ADD;

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

Line 7664: FND_MSG_PUB.ADD;

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

Line 7685: FND_MSG_PUB.ADD;

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

Line 7711: FND_MSG_PUB.ADD;

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