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

477: WHEN OTHERS THEN
478: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
479: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END;
484:
485:

Line 501: FND_MSG_PUB.ADD;

497: WHEN OTHERS THEN
498: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
499: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
501: FND_MSG_PUB.ADD;
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END;
504:
505:

Line 521: FND_MSG_PUB.ADD;

517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
519: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
520: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
521: FND_MSG_PUB.ADD;
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END;
524:
525:

Line 541: FND_MSG_PUB.ADD;

537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
539: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: END;
544:
545: PROCEDURE init_score_context (

Line 608: FND_MSG_PUB.ADD;

604: p_party_site_list,
605: p_contact_list,
606: p_contact_point_list) THEN
607: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
608: FND_MSG_PUB.ADD;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
612: 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 826: FND_MSG_PUB.ADD;

822: END IF;
823: IF lengthb(l_party_contains_str) > 4000 THEN
824: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
825: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
826: FND_MSG_PUB.ADD;
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829: IF (p_match_str = ' AND ' OR p_party_max_score 830: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 888: FND_MSG_PUB.ADD;

884: -- Add the search criteria to query string
885: IF lengthb(l_contains_str) > 4000 THEN
886: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
887: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
888: FND_MSG_PUB.ADD;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: x_denorm_str := l_den_contains_str;
892: RETURN l_contains_str;

Line 1139: FND_MSG_PUB.ADD;

1135: exception
1136: when others then
1137: if (instrb(SQLERRM,'DRG-51030')>0) then
1138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1139: FND_MSG_PUB.ADD;
1140: RAISE FND_API.G_EXC_ERROR;
1141: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1143: FND_MSG_PUB.ADD;

Line 1143: FND_MSG_PUB.ADD;

1139: FND_MSG_PUB.ADD;
1140: RAISE FND_API.G_EXC_ERROR;
1141: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_ERROR;
1145: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1147: FND_MSG_PUB.ADD;

Line 1147: FND_MSG_PUB.ADD;

1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_ERROR;
1145: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1147: FND_MSG_PUB.ADD;
1148: RAISE FND_API.G_EXC_ERROR;
1149: else
1150: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1152: FND_MSG_PUB.ADD;

1148: RAISE FND_API.G_EXC_ERROR;
1149: else
1150: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: end if;
1155: END;
1156:

Line 1384: FND_MSG_PUB.ADD;

1380: exception
1381: when others then
1382: if (instrb(SQLERRM,'DRG-51030')>0) then
1383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1384: FND_MSG_PUB.ADD;
1385: RAISE FND_API.G_EXC_ERROR;
1386: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1388: FND_MSG_PUB.ADD;

Line 1388: FND_MSG_PUB.ADD;

1384: FND_MSG_PUB.ADD;
1385: RAISE FND_API.G_EXC_ERROR;
1386: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1392: FND_MSG_PUB.ADD;

Line 1392: FND_MSG_PUB.ADD;

1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1392: FND_MSG_PUB.ADD;
1393: RAISE FND_API.G_EXC_ERROR;
1394: else
1395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1397: FND_MSG_PUB.ADD;

1393: RAISE FND_API.G_EXC_ERROR;
1394: else
1395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1397: FND_MSG_PUB.ADD;
1398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1399: end if;
1400: END;
1401:

Line 1531: FND_MSG_PUB.ADD;

1527: exception
1528: when others then
1529: if (instrb(SQLERRM,'DRG-51030')>0) then
1530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;
1533: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1534: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1535: FND_MSG_PUB.ADD;

Line 1535: FND_MSG_PUB.ADD;

1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;
1533: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1534: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1535: FND_MSG_PUB.ADD;
1536: RAISE FND_API.G_EXC_ERROR;
1537: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1539: FND_MSG_PUB.ADD;

Line 1539: FND_MSG_PUB.ADD;

1535: FND_MSG_PUB.ADD;
1536: RAISE FND_API.G_EXC_ERROR;
1537: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: else
1542: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1544: FND_MSG_PUB.ADD;

1540: RAISE FND_API.G_EXC_ERROR;
1541: else
1542: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546: end if;
1547: END;
1548:

Line 1804: FND_MSG_PUB.ADD;

1800: exception
1801: when others then
1802: if (instrb(SQLERRM,'DRG-51030')>0) then
1803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1804: FND_MSG_PUB.ADD;
1805: RAISE FND_API.G_EXC_ERROR;
1806: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1808: FND_MSG_PUB.ADD;

Line 1808: FND_MSG_PUB.ADD;

1804: FND_MSG_PUB.ADD;
1805: RAISE FND_API.G_EXC_ERROR;
1806: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1808: FND_MSG_PUB.ADD;
1809: RAISE FND_API.G_EXC_ERROR;
1810: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1811: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1812: FND_MSG_PUB.ADD;

Line 1812: FND_MSG_PUB.ADD;

1808: FND_MSG_PUB.ADD;
1809: RAISE FND_API.G_EXC_ERROR;
1810: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1811: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1812: FND_MSG_PUB.ADD;
1813: RAISE FND_API.G_EXC_ERROR;
1814: else
1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1817: FND_MSG_PUB.ADD;

1813: RAISE FND_API.G_EXC_ERROR;
1814: else
1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1819: end if;
1820: END;
1821:

Line 2065: FND_MSG_PUB.ADD;

2061: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2062: 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);
2063: END IF;
2064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2065: FND_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2067: ELSE
2068: push_eval;
2069: RETURN;

Line 2113: FND_MSG_PUB.ADD;

2109: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2110: 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);
2111: END IF;
2112: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2113: FND_MSG_PUB.ADD;
2114: RAISE FND_API.G_EXC_ERROR;
2115: ELSE
2116: push_eval;
2117: RETURN;

Line 2186: FND_MSG_PUB.ADD;

2182: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2183: 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);
2184: END IF;
2185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2186: FND_MSG_PUB.ADD;
2187: RAISE FND_API.G_EXC_ERROR;
2188: ELSE
2189: push_eval;
2190: RETURN;

Line 2298: FND_MSG_PUB.ADD;

2294: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2295: 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);
2296: END IF;
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2298: FND_MSG_PUB.ADD;
2299: RAISE FND_API.G_EXC_ERROR;
2300: ELSE
2301: push_eval;
2302: RETURN;

Line 2409: FND_MSG_PUB.ADD;

2405: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2406: 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);
2407: END IF;
2408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2409: FND_MSG_PUB.ADD;
2410: RAISE FND_API.G_EXC_ERROR;
2411: ELSE
2412: push_eval;
2413: RETURN;

Line 2553: FND_MSG_PUB.ADD;

2549: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2550: 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);
2551: END IF;
2552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2553: FND_MSG_PUB.ADD;
2554: RAISE FND_API.G_EXC_ERROR;
2555: END IF;
2556: ELSE
2557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2561: FND_MSG_PUB.ADD;

2557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2558: 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);
2559: END IF;
2560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2561: FND_MSG_PUB.ADD;
2562: RAISE FND_API.G_EXC_ERROR;
2563: END IF;
2564: END IF;
2565: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2812: FND_MSG_PUB.ADD;

2808: WHEN OTHERS THEN
2809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2810: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');
2811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2812: FND_MSG_PUB.ADD;
2813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2814: END find_parties;
2815:
2816: PROCEDURE find_persons (

Line 3000: FND_MSG_PUB.ADD;

2996: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2997: 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);
2998: END IF;
2999: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSE
3003: push_eval;
3004: RETURN;

Line 3048: FND_MSG_PUB.ADD;

3044: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3045: 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);
3046: END IF;
3047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3048: FND_MSG_PUB.ADD;
3049: RAISE FND_API.G_EXC_ERROR;
3050: ELSE
3051: push_eval;
3052: RETURN;

Line 3084: FND_MSG_PUB.ADD;

3080: exception
3081: when others then
3082: if (instrb(SQLERRM,'DRG-51030')>0) then
3083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3084: FND_MSG_PUB.ADD;
3085: RAISE FND_API.G_EXC_ERROR;
3086: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3088: FND_MSG_PUB.ADD;

Line 3088: FND_MSG_PUB.ADD;

3084: FND_MSG_PUB.ADD;
3085: RAISE FND_API.G_EXC_ERROR;
3086: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_ERROR;
3090: else
3091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3092: end if;

Line 3160: FND_MSG_PUB.ADD;

3156: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3157: 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);
3158: END IF;
3159: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3160: FND_MSG_PUB.ADD;
3161: RAISE FND_API.G_EXC_ERROR;
3162: ELSE
3163: push_eval;
3164: RETURN;

Line 3349: FND_MSG_PUB.ADD;

3345: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3346: 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);
3347: END IF;
3348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: ELSE
3352: push_eval;
3353: RETURN;

Line 3437: FND_MSG_PUB.ADD;

3433: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3434: 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);
3435: END IF;
3436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3437: FND_MSG_PUB.ADD;
3438: RAISE FND_API.G_EXC_ERROR;
3439: END IF;
3440: ELSE
3441: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3445: FND_MSG_PUB.ADD;

3441: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3442: 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);
3443: END IF;
3444: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3445: FND_MSG_PUB.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: END IF;
3448: END IF;
3449: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3594: FND_MSG_PUB.ADD;

3590: WHEN OTHERS THEN
3591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3594: FND_MSG_PUB.ADD;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: END find_persons;
3597:
3598: PROCEDURE find_persons (

Line 3662: FND_MSG_PUB.ADD;

3658: WHEN OTHERS THEN
3659: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3660: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3661: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3662: FND_MSG_PUB.ADD;
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END find_party_details;
3665:
3666: PROCEDURE find_duplicate_parties (

Line 3779: FND_MSG_PUB.ADD;

3775: WHEN OTHERS THEN
3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3777: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3778: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3779: FND_MSG_PUB.ADD;
3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3781: END find_duplicate_parties;
3782:
3783: PROCEDURE find_duplicate_party_sites (

Line 3864: FND_MSG_PUB.ADD;

3860: WHEN OTHERS THEN
3861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3862: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');
3863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3864: FND_MSG_PUB.ADD;
3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3866: END find_duplicate_party_sites;
3867:
3868: PROCEDURE find_duplicate_contacts (

Line 3953: FND_MSG_PUB.ADD;

3949: WHEN OTHERS THEN
3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3953: FND_MSG_PUB.ADD;
3954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3955: END find_duplicate_contacts;
3956:
3957: PROCEDURE find_duplicate_contact_points (

Line 4026: FND_MSG_PUB.ADD;

4022: WHEN OTHERS THEN
4023: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4024: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4025: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4026: FND_MSG_PUB.ADD;
4027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4028: END find_duplicate_contact_points;
4029:
4030: PROCEDURE find_parties_dynamic (

Line 4286: FND_MSG_PUB.ADD;

4282: WHEN OTHERS THEN
4283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4284: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4285: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4286: FND_MSG_PUB.ADD;
4287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4288: END call_api_dynamic;
4289:
4290:

Line 4520: FND_MSG_PUB.ADD;

4516: WHEN OTHERS THEN
4517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4518: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4519: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4520: FND_MSG_PUB.ADD;
4521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4522: END get_matching_party_sites;
4523:
4524:

Line 4745: FND_MSG_PUB.ADD;

4741: WHEN OTHERS THEN
4742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4743: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4744: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4745: FND_MSG_PUB.ADD;
4746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4747: END get_matching_contacts;
4748:
4749:

Line 4884: FND_MSG_PUB.ADD;

4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4884: FND_MSG_PUB.ADD;
4885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4886: END get_matching_contact_points;
4887:
4888: /**********************************************************

Line 5083: FND_MSG_PUB.ADD;

5079: WHEN OTHERS THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5083: FND_MSG_PUB.ADD;
5084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5085: END get_score_details;
5086:
5087:

Line 5161: FND_MSG_PUB.ADD;

5157: WHEN OTHERS THEN
5158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5159: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5163: END get_party_for_search;
5164:
5165: PROCEDURE get_search_criteria (

Line 5201: FND_MSG_PUB.ADD;

5197: WHEN OTHERS THEN
5198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5199: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5201: FND_MSG_PUB.ADD;
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: END get_search_criteria;
5204:
5205:

Line 5262: FND_MSG_PUB.ADD;

5258: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5260: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_ERROR;
5264: END get_party_rec;
5265:
5266: /************************************************

Line 5318: FND_MSG_PUB.ADD;

5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;
5320: END get_party_site_rec;
5321:
5322: /************************************************

Line 5374: FND_MSG_PUB.ADD;

5370: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5371: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5372: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5373: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5374: FND_MSG_PUB.ADD;
5375: RAISE FND_API.G_EXC_ERROR;
5376: END get_contact_rec;
5377:
5378: /************************************************

Line 5426: FND_MSG_PUB.ADD;

5422: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5424: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_ERROR;
5428: END get_contact_point_rec;
5429:
5430: /************************************************

Line 5531: FND_MSG_PUB.ADD;

5527: WHEN OTHERS THEN
5528: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5529: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5531: FND_MSG_PUB.ADD;
5532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5533: END;
5534:
5535:

Line 5646: FND_MSG_PUB.ADD;

5642: WHEN OTHERS THEN
5643: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5644: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5645: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5646: FND_MSG_PUB.ADD;
5647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5648: END;
5649:
5650:

Line 5688: FND_MSG_PUB.ADD;

5684: WHEN OTHERS THEN
5685: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5686: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: END;
5691:
5692:

Line 5731: FND_MSG_PUB.ADD;

5727: WHEN OTHERS THEN
5728: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5729: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5730: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5731: FND_MSG_PUB.ADD;
5732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5733: END;
5734:
5735:

Line 5766: FND_MSG_PUB.ADD;

5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5766: FND_MSG_PUB.ADD;
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: END check_prim_cond;
5769:
5770: /************************************************

Line 5810: FND_MSG_PUB.ADD;

5806: WHEN OTHERS THEN
5807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5808: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5809: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5810: FND_MSG_PUB.ADD;
5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5812: END check_party_site_cond;
5813:
5814: /************************************************

Line 5848: FND_MSG_PUB.ADD;

5844: WHEN OTHERS THEN
5845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5846: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5848: FND_MSG_PUB.ADD;
5849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5850: END check_contact_cond;
5851:
5852: /************************************************

Line 5869: FND_MSG_PUB.ADD;

5865:
5866: FOR I IN 1..p_contact_point_list.COUNT LOOP
5867: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_ERROR;
5871: END IF;
5872: END LOOP;
5873:

Line 5885: FND_MSG_PUB.ADD;

5881: WHEN OTHERS THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5883: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5885: FND_MSG_PUB.ADD;
5886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5887: END check_contact_point_cond;
5888:
5889: FUNCTION check_staged RETURN BOOLEAN IS