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

796: WHEN OTHERS THEN
797: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
798: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
802: END;
803:
804:

Line 820: FND_MSG_PUB.ADD;

816: WHEN OTHERS THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
818: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END;
823:
824:

Line 840: FND_MSG_PUB.ADD;

836: WHEN OTHERS THEN
837: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
838: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
839: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END;
843:
844:

Line 860: FND_MSG_PUB.ADD;

856: WHEN OTHERS THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
858: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END;
863:
864: PROCEDURE init_score_context (

Line 927: FND_MSG_PUB.ADD;

923: p_party_site_list,
924: p_contact_list,
925: p_contact_point_list) THEN
926: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
931: 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 1185: FND_MSG_PUB.ADD;

1181: END IF;
1182: IF lengthb(l_party_contains_str) > 4000 THEN
1183: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1184: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1185: FND_MSG_PUB.ADD;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: IF (p_match_str = ' AND ' OR p_party_max_score 1189: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1254: FND_MSG_PUB.ADD;

1250: -- Add the search criteria to query string
1251: IF lengthb(l_contains_str) > 4000 THEN
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_ERROR;
1256: END IF;
1257: x_denorm_str := l_den_contains_str;
1258: RETURN l_contains_str;

Line 1298: FND_MSG_PUB.ADD;

1294: -- Add the search criteria to query string
1295: IF lengthb(l_contains_str) > 4000 THEN
1296: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1297: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1298: FND_MSG_PUB.ADD;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301: x_denorm_str := l_den_contains_str;
1302: RETURN l_contains_str;

Line 1343: FND_MSG_PUB.ADD;

1339: -- Add the search criteria to query string
1340: IF lengthb(l_contains_str) > 4000 THEN
1341: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1342: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1343: FND_MSG_PUB.ADD;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346: x_denorm_str := l_den_contains_str;
1347: RETURN l_contains_str;

Line 1568: FND_MSG_PUB.ADD;

1564: exception
1565: when others then
1566: if (instrb(SQLERRM,'DRG-51030')>0) then
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1568: FND_MSG_PUB.ADD;
1569: RAISE FND_API.G_EXC_ERROR;
1570: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1572: FND_MSG_PUB.ADD;

Line 1572: FND_MSG_PUB.ADD;

1568: FND_MSG_PUB.ADD;
1569: RAISE FND_API.G_EXC_ERROR;
1570: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1576: FND_MSG_PUB.ADD;

Line 1576: FND_MSG_PUB.ADD;

1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1576: FND_MSG_PUB.ADD;
1577: RAISE FND_API.G_EXC_ERROR;
1578: else
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1581: FND_MSG_PUB.ADD;

1577: RAISE FND_API.G_EXC_ERROR;
1578: else
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: end if;
1584: END;
1585:

Line 1813: FND_MSG_PUB.ADD;

1809: exception
1810: when others then
1811: if (instrb(SQLERRM,'DRG-51030')>0) then
1812: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1813: FND_MSG_PUB.ADD;
1814: RAISE FND_API.G_EXC_ERROR;
1815: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1817: FND_MSG_PUB.ADD;

Line 1817: FND_MSG_PUB.ADD;

1813: FND_MSG_PUB.ADD;
1814: RAISE FND_API.G_EXC_ERROR;
1815: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1821: FND_MSG_PUB.ADD;

Line 1821: FND_MSG_PUB.ADD;

1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1821: FND_MSG_PUB.ADD;
1822: RAISE FND_API.G_EXC_ERROR;
1823: else
1824: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1826: FND_MSG_PUB.ADD;

1822: RAISE FND_API.G_EXC_ERROR;
1823: else
1824: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1828: end if;
1829: END;
1830:

Line 1960: FND_MSG_PUB.ADD;

1956: exception
1957: when others then
1958: if (instrb(SQLERRM,'DRG-51030')>0) then
1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;

Line 1964: FND_MSG_PUB.ADD;

1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;

Line 1968: FND_MSG_PUB.ADD;

1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1973: FND_MSG_PUB.ADD;

1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;
1976: END;
1977:

Line 2233: FND_MSG_PUB.ADD;

2229: exception
2230: when others then
2231: if (instrb(SQLERRM,'DRG-51030')>0) then
2232: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;
2235: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2237: FND_MSG_PUB.ADD;

Line 2237: FND_MSG_PUB.ADD;

2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;
2235: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2237: FND_MSG_PUB.ADD;
2238: RAISE FND_API.G_EXC_ERROR;
2239: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2241: FND_MSG_PUB.ADD;

Line 2241: FND_MSG_PUB.ADD;

2237: FND_MSG_PUB.ADD;
2238: RAISE FND_API.G_EXC_ERROR;
2239: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: else
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2245: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2246: FND_MSG_PUB.ADD;

2242: RAISE FND_API.G_EXC_ERROR;
2243: else
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2245: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2248: end if;
2249: END;
2250:

Line 2500: FND_MSG_PUB.ADD;

2496: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2497: 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);
2498: END IF;
2499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2500: FND_MSG_PUB.ADD;
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSE
2503: push_eval;
2504: RETURN;

Line 2548: FND_MSG_PUB.ADD;

2544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2545: 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);
2546: END IF;
2547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2548: FND_MSG_PUB.ADD;
2549: RAISE FND_API.G_EXC_ERROR;
2550: ELSE
2551: push_eval;
2552: RETURN;

Line 2621: FND_MSG_PUB.ADD;

2617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2618: 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);
2619: END IF;
2620: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2621: FND_MSG_PUB.ADD;
2622: RAISE FND_API.G_EXC_ERROR;
2623: ELSE
2624: push_eval;
2625: RETURN;

Line 2733: FND_MSG_PUB.ADD;

2729: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2730: 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);
2731: END IF;
2732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2733: FND_MSG_PUB.ADD;
2734: RAISE FND_API.G_EXC_ERROR;
2735: ELSE
2736: push_eval;
2737: RETURN;

Line 2844: FND_MSG_PUB.ADD;

2840: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2841: 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);
2842: END IF;
2843: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2844: FND_MSG_PUB.ADD;
2845: RAISE FND_API.G_EXC_ERROR;
2846: ELSE
2847: push_eval;
2848: RETURN;

Line 2988: FND_MSG_PUB.ADD;

2984: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2985: 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);
2986: END IF;
2987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2988: FND_MSG_PUB.ADD;
2989: RAISE FND_API.G_EXC_ERROR;
2990: END IF;
2991: ELSE
2992: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2996: FND_MSG_PUB.ADD;

2992: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2993: 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);
2994: END IF;
2995: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2996: FND_MSG_PUB.ADD;
2997: RAISE FND_API.G_EXC_ERROR;
2998: END IF;
2999: END IF;
3000: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3247: FND_MSG_PUB.ADD;

3243: WHEN OTHERS THEN
3244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3245: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');
3246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3247: FND_MSG_PUB.ADD;
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3249: END find_parties;
3250:
3251: PROCEDURE find_persons (

Line 3441: FND_MSG_PUB.ADD;

3437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3438: 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);
3439: END IF;
3440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3441: FND_MSG_PUB.ADD;
3442: RAISE FND_API.G_EXC_ERROR;
3443: ELSE
3444: push_eval;
3445: RETURN;

Line 3489: FND_MSG_PUB.ADD;

3485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3486: 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);
3487: END IF;
3488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3489: FND_MSG_PUB.ADD;
3490: RAISE FND_API.G_EXC_ERROR;
3491: ELSE
3492: push_eval;
3493: RETURN;

Line 3525: FND_MSG_PUB.ADD;

3521: exception
3522: when others then
3523: if (instrb(SQLERRM,'DRG-51030')>0) then
3524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3525: FND_MSG_PUB.ADD;
3526: RAISE FND_API.G_EXC_ERROR;
3527: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3529: FND_MSG_PUB.ADD;

Line 3529: FND_MSG_PUB.ADD;

3525: FND_MSG_PUB.ADD;
3526: RAISE FND_API.G_EXC_ERROR;
3527: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3529: FND_MSG_PUB.ADD;
3530: RAISE FND_API.G_EXC_ERROR;
3531: else
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3533: end if;

Line 3601: FND_MSG_PUB.ADD;

3597: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3598: hz_utility_v2pub.debug(p_message=>'In 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);
3599: END IF;
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;
3603: ELSE
3604: push_eval;
3605: RETURN;

Line 3790: FND_MSG_PUB.ADD;

3786: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3787: 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);
3788: END IF;
3789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3790: FND_MSG_PUB.ADD;
3791: RAISE FND_API.G_EXC_ERROR;
3792: ELSE
3793: push_eval;
3794: RETURN;

Line 3878: FND_MSG_PUB.ADD;

3874: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3875: 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);
3876: END IF;
3877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3878: FND_MSG_PUB.ADD;
3879: RAISE FND_API.G_EXC_ERROR;
3880: END IF;
3881: ELSE
3882: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3886: FND_MSG_PUB.ADD;

3882: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3883: 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);
3884: END IF;
3885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3886: FND_MSG_PUB.ADD;
3887: RAISE FND_API.G_EXC_ERROR;
3888: END IF;
3889: END IF;
3890: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4035: FND_MSG_PUB.ADD;

4031: WHEN OTHERS THEN
4032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4033: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');
4034: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4035: FND_MSG_PUB.ADD;
4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4037: END find_persons;
4038:
4039: PROCEDURE find_persons (

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_6.find_party_details');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4103: FND_MSG_PUB.ADD;
4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4105: END find_party_details;
4106:
4107: PROCEDURE find_duplicate_parties (

Line 4220: FND_MSG_PUB.ADD;

4216: WHEN OTHERS THEN
4217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');
4219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4222: END find_duplicate_parties;
4223:
4224: PROCEDURE find_duplicate_party_sites (

Line 4305: FND_MSG_PUB.ADD;

4301: WHEN OTHERS THEN
4302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4303: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');
4304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4305: FND_MSG_PUB.ADD;
4306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4307: END find_duplicate_party_sites;
4308:
4309: PROCEDURE find_duplicate_contacts (

Line 4394: FND_MSG_PUB.ADD;

4390: WHEN OTHERS THEN
4391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4392: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');
4393: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4394: FND_MSG_PUB.ADD;
4395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4396: END find_duplicate_contacts;
4397:
4398: PROCEDURE find_duplicate_contact_points (

Line 4467: FND_MSG_PUB.ADD;

4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END find_duplicate_contact_points;
4470:
4471: PROCEDURE find_parties_dynamic (

Line 4772: FND_MSG_PUB.ADD;

4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4774: END call_api_dynamic;
4775:
4776:

Line 5008: FND_MSG_PUB.ADD;

5004: WHEN OTHERS THEN
5005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5006: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');
5007: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5008: FND_MSG_PUB.ADD;
5009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5010: END get_matching_party_sites;
5011:
5012:

Line 5237: FND_MSG_PUB.ADD;

5233: WHEN OTHERS THEN
5234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');
5236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5237: FND_MSG_PUB.ADD;
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239: END get_matching_contacts;
5240:
5241:

Line 5377: FND_MSG_PUB.ADD;

5373: WHEN OTHERS THEN
5374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5375: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5377: FND_MSG_PUB.ADD;
5378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5379: END get_matching_contact_points;
5380:
5381: /**********************************************************

Line 5594: FND_MSG_PUB.ADD;

5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5594: FND_MSG_PUB.ADD;
5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5596: END get_score_details;
5597:
5598:

Line 5717: FND_MSG_PUB.ADD;

5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5717: FND_MSG_PUB.ADD;
5718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5719: END get_party_for_search;
5720:
5721: PROCEDURE get_search_criteria (

Line 5769: FND_MSG_PUB.ADD;

5765: WHEN OTHERS THEN
5766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5767: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5769: FND_MSG_PUB.ADD;
5770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5771: END get_search_criteria;
5772:
5773:

Line 5834: FND_MSG_PUB.ADD;

5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_party_rec;
5837:
5838: /************************************************

Line 5890: FND_MSG_PUB.ADD;

5886: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5887: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5888: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5890: FND_MSG_PUB.ADD;
5891: RAISE FND_API.G_EXC_ERROR;
5892: END get_party_site_rec;
5893:
5894: /************************************************

Line 5948: FND_MSG_PUB.ADD;

5944: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5946: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_ERROR;
5950: END get_contact_rec;
5951:
5952: /************************************************

Line 6002: FND_MSG_PUB.ADD;

5998: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5999: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6000: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6001: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6002: FND_MSG_PUB.ADD;
6003: RAISE FND_API.G_EXC_ERROR;
6004: END get_contact_point_rec;
6005:
6006: /************************************************

Line 6170: FND_MSG_PUB.ADD;

6166: WHEN OTHERS THEN
6167: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6168: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6170: FND_MSG_PUB.ADD;
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: END;
6173:
6174:

Line 6288: FND_MSG_PUB.ADD;

6284: WHEN OTHERS THEN
6285: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6286: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6287: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6288: FND_MSG_PUB.ADD;
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: END;
6291:
6292:

Line 6391: FND_MSG_PUB.ADD;

6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6393: END;
6394:
6395:

Line 6459: FND_MSG_PUB.ADD;

6455: WHEN OTHERS THEN
6456: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6459: FND_MSG_PUB.ADD;
6460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6461: END;
6462:
6463:

Line 6483: FND_MSG_PUB.ADD;

6479: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6480: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6481: ) THEN
6482: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6483: FND_MSG_PUB.ADD;
6484: RAISE FND_API.G_EXC_ERROR;
6485: END IF;
6486: END LOOP;
6487:

Line 6525: FND_MSG_PUB.ADD;

6521: WHEN OTHERS THEN
6522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6523: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6525: FND_MSG_PUB.ADD;
6526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6527: END check_prim_cond;
6528:
6529: /************************************************

Line 6579: FND_MSG_PUB.ADD;

6575: WHEN OTHERS THEN
6576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6577: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6581: END check_party_site_cond;
6582:
6583: /************************************************

Line 6633: FND_MSG_PUB.ADD;

6629: WHEN OTHERS THEN
6630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6631: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6635: END check_contact_cond;
6636:
6637: /************************************************

Line 6654: FND_MSG_PUB.ADD;

6650:
6651: FOR I IN 1..p_contact_point_list.COUNT LOOP
6652: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6653: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;
6657: END LOOP;
6658:

Line 6678: FND_MSG_PUB.ADD;

6674: WHEN OTHERS THEN
6675: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6676: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6677: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6678: FND_MSG_PUB.ADD;
6679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6680: END check_contact_point_cond;
6681:
6682: FUNCTION check_staged RETURN BOOLEAN IS