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

545: WHEN OTHERS THEN
546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
547: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END;
552:
553:

Line 569: FND_MSG_PUB.ADD;

565: WHEN OTHERS THEN
566: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
567: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
569: FND_MSG_PUB.ADD;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END;
572:
573:

Line 589: FND_MSG_PUB.ADD;

585: WHEN OTHERS THEN
586: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
587: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
588: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
589: FND_MSG_PUB.ADD;
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END;
592:
593:

Line 609: FND_MSG_PUB.ADD;

605: WHEN OTHERS THEN
606: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
607: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
609: FND_MSG_PUB.ADD;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END;
612:
613: PROCEDURE init_score_context (

Line 676: FND_MSG_PUB.ADD;

672: p_party_site_list,
673: p_contact_list,
674: p_contact_point_list) THEN
675: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
676: FND_MSG_PUB.ADD;
677: RAISE FND_API.G_EXC_ERROR;
678: END IF;
679: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
680: 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 894: FND_MSG_PUB.ADD;

890: END IF;
891: IF lengthb(l_party_contains_str) > 4000 THEN
892: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
893: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: IF (p_match_str = ' AND ' OR p_party_max_score 898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 972: FND_MSG_PUB.ADD;

968: -- Add the search criteria to query string
969: IF lengthb(l_contains_str) > 4000 THEN
970: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
971: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: x_denorm_str := l_den_contains_str;
976: RETURN l_contains_str;

Line 1053: FND_MSG_PUB.ADD;

1049: -- Add the search criteria to query string
1050: IF lengthb(l_contains_str) > 4000 THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1052: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1053: FND_MSG_PUB.ADD;
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056: x_denorm_str := l_den_contains_str;
1057: RETURN l_contains_str;

Line 1265: FND_MSG_PUB.ADD;

1261: exception
1262: when others then
1263: if (instrb(SQLERRM,'DRG-51030')>0) then
1264: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1265: FND_MSG_PUB.ADD;
1266: RAISE FND_API.G_EXC_ERROR;
1267: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1269: FND_MSG_PUB.ADD;

Line 1269: FND_MSG_PUB.ADD;

1265: FND_MSG_PUB.ADD;
1266: RAISE FND_API.G_EXC_ERROR;
1267: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1269: FND_MSG_PUB.ADD;
1270: RAISE FND_API.G_EXC_ERROR;
1271: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1273: FND_MSG_PUB.ADD;

Line 1273: FND_MSG_PUB.ADD;

1269: FND_MSG_PUB.ADD;
1270: RAISE FND_API.G_EXC_ERROR;
1271: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_ERROR;
1275: else
1276: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1277: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1278: FND_MSG_PUB.ADD;

1274: RAISE FND_API.G_EXC_ERROR;
1275: else
1276: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1277: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1278: FND_MSG_PUB.ADD;
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: end if;
1281: END;
1282:

Line 1510: FND_MSG_PUB.ADD;

1506: exception
1507: when others then
1508: if (instrb(SQLERRM,'DRG-51030')>0) then
1509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1510: FND_MSG_PUB.ADD;
1511: RAISE FND_API.G_EXC_ERROR;
1512: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1514: FND_MSG_PUB.ADD;

Line 1514: FND_MSG_PUB.ADD;

1510: FND_MSG_PUB.ADD;
1511: RAISE FND_API.G_EXC_ERROR;
1512: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;
1516: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1518: FND_MSG_PUB.ADD;

Line 1518: FND_MSG_PUB.ADD;

1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;
1516: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1518: FND_MSG_PUB.ADD;
1519: RAISE FND_API.G_EXC_ERROR;
1520: else
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1522: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1523: FND_MSG_PUB.ADD;

1519: RAISE FND_API.G_EXC_ERROR;
1520: else
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1522: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1523: FND_MSG_PUB.ADD;
1524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1525: end if;
1526: END;
1527:

Line 1657: FND_MSG_PUB.ADD;

1653: exception
1654: when others then
1655: if (instrb(SQLERRM,'DRG-51030')>0) then
1656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1657: FND_MSG_PUB.ADD;
1658: RAISE FND_API.G_EXC_ERROR;
1659: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1660: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1661: FND_MSG_PUB.ADD;

Line 1661: FND_MSG_PUB.ADD;

1657: FND_MSG_PUB.ADD;
1658: RAISE FND_API.G_EXC_ERROR;
1659: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1660: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1661: FND_MSG_PUB.ADD;
1662: RAISE FND_API.G_EXC_ERROR;
1663: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1665: FND_MSG_PUB.ADD;

Line 1665: FND_MSG_PUB.ADD;

1661: FND_MSG_PUB.ADD;
1662: RAISE FND_API.G_EXC_ERROR;
1663: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1665: FND_MSG_PUB.ADD;
1666: RAISE FND_API.G_EXC_ERROR;
1667: else
1668: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1670: FND_MSG_PUB.ADD;

1666: RAISE FND_API.G_EXC_ERROR;
1667: else
1668: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1670: FND_MSG_PUB.ADD;
1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1672: end if;
1673: END;
1674:

Line 1930: FND_MSG_PUB.ADD;

1926: exception
1927: when others then
1928: if (instrb(SQLERRM,'DRG-51030')>0) then
1929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1930: FND_MSG_PUB.ADD;
1931: RAISE FND_API.G_EXC_ERROR;
1932: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1933: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1934: FND_MSG_PUB.ADD;

Line 1934: FND_MSG_PUB.ADD;

1930: FND_MSG_PUB.ADD;
1931: RAISE FND_API.G_EXC_ERROR;
1932: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1933: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_ERROR;
1936: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1938: FND_MSG_PUB.ADD;

Line 1938: FND_MSG_PUB.ADD;

1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_ERROR;
1936: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1938: FND_MSG_PUB.ADD;
1939: RAISE FND_API.G_EXC_ERROR;
1940: else
1941: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1943: FND_MSG_PUB.ADD;

1939: RAISE FND_API.G_EXC_ERROR;
1940: else
1941: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1943: FND_MSG_PUB.ADD;
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: end if;
1946: END;
1947:

Line 2192: FND_MSG_PUB.ADD;

2188: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2189: 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);
2190: END IF;
2191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2192: FND_MSG_PUB.ADD;
2193: RAISE FND_API.G_EXC_ERROR;
2194: ELSE
2195: push_eval;
2196: RETURN;

Line 2240: FND_MSG_PUB.ADD;

2236: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2237: 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);
2238: END IF;
2239: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2240: FND_MSG_PUB.ADD;
2241: RAISE FND_API.G_EXC_ERROR;
2242: ELSE
2243: push_eval;
2244: RETURN;

Line 2313: FND_MSG_PUB.ADD;

2309: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2310: 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);
2311: END IF;
2312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2313: FND_MSG_PUB.ADD;
2314: RAISE FND_API.G_EXC_ERROR;
2315: ELSE
2316: push_eval;
2317: RETURN;

Line 2425: FND_MSG_PUB.ADD;

2421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2422: 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);
2423: END IF;
2424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2425: FND_MSG_PUB.ADD;
2426: RAISE FND_API.G_EXC_ERROR;
2427: ELSE
2428: push_eval;
2429: RETURN;

Line 2536: FND_MSG_PUB.ADD;

2532: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2533: 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);
2534: END IF;
2535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2536: FND_MSG_PUB.ADD;
2537: RAISE FND_API.G_EXC_ERROR;
2538: ELSE
2539: push_eval;
2540: RETURN;

Line 2761: FND_MSG_PUB.ADD;

2757: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2758: 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);
2759: END IF;
2760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2761: FND_MSG_PUB.ADD;
2762: RAISE FND_API.G_EXC_ERROR;
2763: END IF;
2764: ELSE
2765: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2769: FND_MSG_PUB.ADD;

2765: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2766: 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);
2767: END IF;
2768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2769: FND_MSG_PUB.ADD;
2770: RAISE FND_API.G_EXC_ERROR;
2771: END IF;
2772: END IF;
2773: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2977: FND_MSG_PUB.ADD;

2973: WHEN OTHERS THEN
2974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2975: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_parties');
2976: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2977: FND_MSG_PUB.ADD;
2978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2979: END find_parties;
2980:
2981: PROCEDURE find_persons (

Line 3166: FND_MSG_PUB.ADD;

3162: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3163: 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);
3164: END IF;
3165: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3166: FND_MSG_PUB.ADD;
3167: RAISE FND_API.G_EXC_ERROR;
3168: ELSE
3169: push_eval;
3170: RETURN;

Line 3214: FND_MSG_PUB.ADD;

3210: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3211: 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);
3212: END IF;
3213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3214: FND_MSG_PUB.ADD;
3215: RAISE FND_API.G_EXC_ERROR;
3216: ELSE
3217: push_eval;
3218: RETURN;

Line 3250: FND_MSG_PUB.ADD;

3246: exception
3247: when others then
3248: if (instrb(SQLERRM,'DRG-51030')>0) then
3249: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3250: FND_MSG_PUB.ADD;
3251: RAISE FND_API.G_EXC_ERROR;
3252: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3254: FND_MSG_PUB.ADD;

Line 3254: FND_MSG_PUB.ADD;

3250: FND_MSG_PUB.ADD;
3251: RAISE FND_API.G_EXC_ERROR;
3252: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3254: FND_MSG_PUB.ADD;
3255: RAISE FND_API.G_EXC_ERROR;
3256: else
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258: end if;

Line 3326: FND_MSG_PUB.ADD;

3322: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3323: 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);
3324: END IF;
3325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3326: FND_MSG_PUB.ADD;
3327: RAISE FND_API.G_EXC_ERROR;
3328: ELSE
3329: push_eval;
3330: RETURN;

Line 3585: FND_MSG_PUB.ADD;

3581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3582: 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);
3583: END IF;
3584: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3585: FND_MSG_PUB.ADD;
3586: RAISE FND_API.G_EXC_ERROR;
3587: ELSE
3588: push_eval;
3589: RETURN;

Line 3698: FND_MSG_PUB.ADD;

3694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3695: 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);
3696: END IF;
3697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_ERROR;
3700: END IF;
3701: ELSE
3702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3706: FND_MSG_PUB.ADD;

3702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3703: 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);
3704: END IF;
3705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3706: FND_MSG_PUB.ADD;
3707: RAISE FND_API.G_EXC_ERROR;
3708: END IF;
3709: END IF;
3710: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3829: FND_MSG_PUB.ADD;

3825: WHEN OTHERS THEN
3826: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3827: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3829: FND_MSG_PUB.ADD;
3830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3831: END find_persons;
3832:
3833: PROCEDURE find_persons (

Line 3897: FND_MSG_PUB.ADD;

3893: WHEN OTHERS THEN
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3897: FND_MSG_PUB.ADD;
3898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3899: END find_party_details;
3900:
3901: PROCEDURE find_duplicate_parties (

Line 4014: FND_MSG_PUB.ADD;

4010: WHEN OTHERS THEN
4011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4012: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4013: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4014: FND_MSG_PUB.ADD;
4015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4016: END find_duplicate_parties;
4017:
4018: PROCEDURE find_duplicate_party_sites (

Line 4099: FND_MSG_PUB.ADD;

4095: WHEN OTHERS THEN
4096: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4097: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4098: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4099: FND_MSG_PUB.ADD;
4100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4101: END find_duplicate_party_sites;
4102:
4103: PROCEDURE find_duplicate_contacts (

Line 4188: FND_MSG_PUB.ADD;

4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4188: FND_MSG_PUB.ADD;
4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4190: END find_duplicate_contacts;
4191:
4192: PROCEDURE find_duplicate_contact_points (

Line 4261: FND_MSG_PUB.ADD;

4257: WHEN OTHERS THEN
4258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4261: FND_MSG_PUB.ADD;
4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4263: END find_duplicate_contact_points;
4264:
4265: PROCEDURE find_parties_dynamic (

Line 4555: FND_MSG_PUB.ADD;

4551: WHEN OTHERS THEN
4552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4555: FND_MSG_PUB.ADD;
4556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4557: END call_api_dynamic;
4558:
4559:

Line 4790: FND_MSG_PUB.ADD;

4786: WHEN OTHERS THEN
4787: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4788: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4789: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4790: FND_MSG_PUB.ADD;
4791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4792: END get_matching_party_sites;
4793:
4794:

Line 5019: FND_MSG_PUB.ADD;

5015: WHEN OTHERS THEN
5016: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5017: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5018: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5019: FND_MSG_PUB.ADD;
5020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5021: END get_matching_contacts;
5022:
5023:

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','HZ_MATCH_RULE_98.get_matching_contact_points');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5163: END get_matching_contact_points;
5164:
5165: /**********************************************************

Line 5365: FND_MSG_PUB.ADD;

5361: WHEN OTHERS THEN
5362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5365: FND_MSG_PUB.ADD;
5366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5367: END get_score_details;
5368:
5369:

Line 5453: FND_MSG_PUB.ADD;

5449: WHEN OTHERS THEN
5450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5451: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5453: FND_MSG_PUB.ADD;
5454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5455: END get_party_for_search;
5456:
5457: PROCEDURE get_search_criteria (

Line 5499: FND_MSG_PUB.ADD;

5495: WHEN OTHERS THEN
5496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5497: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5498: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5499: FND_MSG_PUB.ADD;
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: END get_search_criteria;
5502:
5503:

Line 5544: FND_MSG_PUB.ADD;

5540: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5542: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_ERROR;
5546: END get_party_rec;
5547:
5548: /************************************************

Line 5596: FND_MSG_PUB.ADD;

5592: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5593: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5594: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;
5597: RAISE FND_API.G_EXC_ERROR;
5598: END get_party_site_rec;
5599:
5600: /************************************************

Line 5654: FND_MSG_PUB.ADD;

5650: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5651: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5652: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5654: FND_MSG_PUB.ADD;
5655: RAISE FND_API.G_EXC_ERROR;
5656: END get_contact_rec;
5657:
5658: /************************************************

Line 5710: FND_MSG_PUB.ADD;

5706: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5708: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5710: FND_MSG_PUB.ADD;
5711: RAISE FND_API.G_EXC_ERROR;
5712: END get_contact_point_rec;
5713:
5714: /************************************************

Line 5806: FND_MSG_PUB.ADD;

5802: WHEN OTHERS THEN
5803: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5804: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5806: FND_MSG_PUB.ADD;
5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5808: END;
5809:
5810:

Line 5849: FND_MSG_PUB.ADD;

5845: WHEN OTHERS THEN
5846: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5847: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5848: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5849: FND_MSG_PUB.ADD;
5850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5851: END;
5852:
5853:

Line 5906: FND_MSG_PUB.ADD;

5902: WHEN OTHERS THEN
5903: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5904: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5906: FND_MSG_PUB.ADD;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5908: END;
5909:
5910:

Line 6037: FND_MSG_PUB.ADD;

6033: WHEN OTHERS THEN
6034: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6035: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6036: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6037: FND_MSG_PUB.ADD;
6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6039: END;
6040:
6041:

Line 6062: FND_MSG_PUB.ADD;

6058: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6059: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6060: ) THEN
6061: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6062: FND_MSG_PUB.ADD;
6063: RAISE FND_API.G_EXC_ERROR;
6064: END IF;
6065: END LOOP;
6066:

Line 6093: FND_MSG_PUB.ADD;

6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END check_prim_cond;
6096:
6097: /************************************************

Line 6139: FND_MSG_PUB.ADD;

6135: WHEN OTHERS THEN
6136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6137: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6138: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6139: FND_MSG_PUB.ADD;
6140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6141: END check_party_site_cond;
6142:
6143: /************************************************

Line 6195: FND_MSG_PUB.ADD;

6191: WHEN OTHERS THEN
6192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6193: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6195: FND_MSG_PUB.ADD;
6196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6197: END check_contact_cond;
6198:
6199: /************************************************

Line 6216: FND_MSG_PUB.ADD;

6212:
6213: FOR I IN 1..p_contact_point_list.COUNT LOOP
6214: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6215: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6216: FND_MSG_PUB.ADD;
6217: RAISE FND_API.G_EXC_ERROR;
6218: END IF;
6219: END LOOP;
6220:

Line 6242: FND_MSG_PUB.ADD;

6238: WHEN OTHERS THEN
6239: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6240: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6241: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6242: FND_MSG_PUB.ADD;
6243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6244: END check_contact_point_cond;
6245:
6246: FUNCTION check_staged RETURN BOOLEAN IS