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

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

Line 1271: FND_MSG_PUB.ADD;

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

Line 1275: FND_MSG_PUB.ADD;

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

Line 1280: FND_MSG_PUB.ADD;

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

Line 1512: FND_MSG_PUB.ADD;

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

Line 1516: FND_MSG_PUB.ADD;

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

Line 1520: FND_MSG_PUB.ADD;

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

Line 1525: FND_MSG_PUB.ADD;

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

Line 1659: FND_MSG_PUB.ADD;

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

Line 1663: FND_MSG_PUB.ADD;

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

Line 1667: FND_MSG_PUB.ADD;

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

Line 1672: FND_MSG_PUB.ADD;

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

Line 1932: FND_MSG_PUB.ADD;

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

Line 1936: FND_MSG_PUB.ADD;

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

Line 1940: FND_MSG_PUB.ADD;

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

Line 1945: FND_MSG_PUB.ADD;

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

Line 2195: FND_MSG_PUB.ADD;

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

Line 2243: FND_MSG_PUB.ADD;

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

Line 2316: FND_MSG_PUB.ADD;

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

Line 2428: FND_MSG_PUB.ADD;

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

Line 2539: FND_MSG_PUB.ADD;

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

Line 2764: FND_MSG_PUB.ADD;

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

Line 2772: FND_MSG_PUB.ADD;

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

Line 2980: FND_MSG_PUB.ADD;

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

Line 3170: FND_MSG_PUB.ADD;

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

Line 3218: FND_MSG_PUB.ADD;

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

Line 3254: FND_MSG_PUB.ADD;

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

Line 3258: FND_MSG_PUB.ADD;

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

Line 3330: FND_MSG_PUB.ADD;

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

Line 3589: FND_MSG_PUB.ADD;

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

Line 3702: FND_MSG_PUB.ADD;

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

Line 3710: FND_MSG_PUB.ADD;

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

Line 3833: FND_MSG_PUB.ADD;

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

Line 3901: FND_MSG_PUB.ADD;

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

Line 4018: FND_MSG_PUB.ADD;

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

Line 4103: FND_MSG_PUB.ADD;

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

Line 4192: FND_MSG_PUB.ADD;

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

Line 4265: FND_MSG_PUB.ADD;

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

Line 4559: FND_MSG_PUB.ADD;

4555: WHEN OTHERS THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4559: FND_MSG_PUB.ADD;
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: END call_api_dynamic;
4562:
4563:

Line 4794: FND_MSG_PUB.ADD;

4790: WHEN OTHERS THEN
4791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4792: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4794: FND_MSG_PUB.ADD;
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: END get_matching_party_sites;
4797:
4798:

Line 5023: FND_MSG_PUB.ADD;

5019: WHEN OTHERS THEN
5020: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5021: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5023: FND_MSG_PUB.ADD;
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: END get_matching_contacts;
5026:
5027:

Line 5165: FND_MSG_PUB.ADD;

5161: WHEN OTHERS THEN
5162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5163: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');
5164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5165: FND_MSG_PUB.ADD;
5166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5167: END get_matching_contact_points;
5168:
5169: /**********************************************************

Line 5370: FND_MSG_PUB.ADD;

5366: WHEN OTHERS THEN
5367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5368: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5372: END get_score_details;
5373:
5374:

Line 5458: FND_MSG_PUB.ADD;

5454: WHEN OTHERS THEN
5455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5456: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5458: FND_MSG_PUB.ADD;
5459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5460: END get_party_for_search;
5461:
5462: PROCEDURE get_search_criteria (

Line 5504: FND_MSG_PUB.ADD;

5500: WHEN OTHERS THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5502: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5503: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5504: FND_MSG_PUB.ADD;
5505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5506: END get_search_criteria;
5507:
5508:

Line 5549: FND_MSG_PUB.ADD;

5545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5546: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5547: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;
5551: END get_party_rec;
5552:
5553: /************************************************

Line 5601: FND_MSG_PUB.ADD;

5597: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5598: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5599: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5601: FND_MSG_PUB.ADD;
5602: RAISE FND_API.G_EXC_ERROR;
5603: END get_party_site_rec;
5604:
5605: /************************************************

Line 5659: FND_MSG_PUB.ADD;

5655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5656: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_ERROR;
5661: END get_contact_rec;
5662:
5663: /************************************************

Line 5715: FND_MSG_PUB.ADD;

5711: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5712: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5713: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5715: FND_MSG_PUB.ADD;
5716: RAISE FND_API.G_EXC_ERROR;
5717: END get_contact_point_rec;
5718:
5719: /************************************************

Line 5811: FND_MSG_PUB.ADD;

5807: WHEN OTHERS THEN
5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5809: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5811: FND_MSG_PUB.ADD;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5813: END;
5814:
5815:

Line 5854: FND_MSG_PUB.ADD;

5850: WHEN OTHERS THEN
5851: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5852: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5853: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5854: FND_MSG_PUB.ADD;
5855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5856: END;
5857:
5858:

Line 5911: FND_MSG_PUB.ADD;

5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END;
5914:
5915:

Line 6042: FND_MSG_PUB.ADD;

6038: WHEN OTHERS THEN
6039: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6040: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6042: FND_MSG_PUB.ADD;
6043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6044: END;
6045:
6046:

Line 6067: FND_MSG_PUB.ADD;

6063: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6064: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6065: ) THEN
6066: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6067: FND_MSG_PUB.ADD;
6068: RAISE FND_API.G_EXC_ERROR;
6069: END IF;
6070: END LOOP;
6071:

Line 6098: FND_MSG_PUB.ADD;

6094: WHEN OTHERS THEN
6095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6096: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6100: END check_prim_cond;
6101:
6102: /************************************************

Line 6144: FND_MSG_PUB.ADD;

6140: WHEN OTHERS THEN
6141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6142: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6146: END check_party_site_cond;
6147:
6148: /************************************************

Line 6200: FND_MSG_PUB.ADD;

6196: WHEN OTHERS THEN
6197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6198: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6202: END check_contact_cond;
6203:
6204: /************************************************

Line 6221: FND_MSG_PUB.ADD;

6217:
6218: FOR I IN 1..p_contact_point_list.COUNT LOOP
6219: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6220: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6221: FND_MSG_PUB.ADD;
6222: RAISE FND_API.G_EXC_ERROR;
6223: END IF;
6224: END LOOP;
6225:

Line 6247: FND_MSG_PUB.ADD;

6243: WHEN OTHERS THEN
6244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6245: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6247: FND_MSG_PUB.ADD;
6248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6249: END check_contact_point_cond;
6250:
6251: FUNCTION check_staged RETURN BOOLEAN IS