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

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

Line 591: FND_MSG_PUB.ADD;

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

Line 611: FND_MSG_PUB.ADD;

607: WHEN OTHERS THEN
608: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
609: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
611: FND_MSG_PUB.ADD;
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END;
614:
615:

Line 631: FND_MSG_PUB.ADD;

627: WHEN OTHERS THEN
628: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
629: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
630: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
631: FND_MSG_PUB.ADD;
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END;
634:
635: PROCEDURE init_score_context (

Line 698: FND_MSG_PUB.ADD;

694: p_party_site_list,
695: p_contact_list,
696: p_contact_point_list) THEN
697: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
698: FND_MSG_PUB.ADD;
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
702: 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 916: FND_MSG_PUB.ADD;

912: END IF;
913: IF lengthb(l_party_contains_str) > 4000 THEN
914: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
915: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
916: FND_MSG_PUB.ADD;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919: IF (p_match_str = ' AND ' OR p_party_max_score 920: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 985: FND_MSG_PUB.ADD;

981: -- Add the search criteria to query string
982: IF lengthb(l_contains_str) > 4000 THEN
983: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
984: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988: x_denorm_str := l_den_contains_str;
989: RETURN l_contains_str;

Line 1082: FND_MSG_PUB.ADD;

1078: -- Add the search criteria to query string
1079: IF lengthb(l_contains_str) > 4000 THEN
1080: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1081: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085: x_denorm_str := l_den_contains_str;
1086: RETURN l_contains_str;

Line 1295: FND_MSG_PUB.ADD;

1291: exception
1292: when others then
1293: if (instrb(SQLERRM,'DRG-51030')>0) then
1294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1295: FND_MSG_PUB.ADD;
1296: RAISE FND_API.G_EXC_ERROR;
1297: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1299: FND_MSG_PUB.ADD;

Line 1299: FND_MSG_PUB.ADD;

1295: FND_MSG_PUB.ADD;
1296: RAISE FND_API.G_EXC_ERROR;
1297: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1299: FND_MSG_PUB.ADD;
1300: RAISE FND_API.G_EXC_ERROR;
1301: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1303: FND_MSG_PUB.ADD;

Line 1303: FND_MSG_PUB.ADD;

1299: FND_MSG_PUB.ADD;
1300: RAISE FND_API.G_EXC_ERROR;
1301: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1303: FND_MSG_PUB.ADD;
1304: RAISE FND_API.G_EXC_ERROR;
1305: else
1306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1308: FND_MSG_PUB.ADD;

1304: RAISE FND_API.G_EXC_ERROR;
1305: else
1306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1308: FND_MSG_PUB.ADD;
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: end if;
1311: END;
1312:

Line 1540: FND_MSG_PUB.ADD;

1536: exception
1537: when others then
1538: if (instrb(SQLERRM,'DRG-51030')>0) then
1539: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1544: FND_MSG_PUB.ADD;

Line 1544: FND_MSG_PUB.ADD;

1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;
1546: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1548: FND_MSG_PUB.ADD;

Line 1548: FND_MSG_PUB.ADD;

1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;
1546: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1553: FND_MSG_PUB.ADD;

1549: RAISE FND_API.G_EXC_ERROR;
1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: end if;
1556: END;
1557:

Line 1687: FND_MSG_PUB.ADD;

1683: exception
1684: when others then
1685: if (instrb(SQLERRM,'DRG-51030')>0) then
1686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1687: FND_MSG_PUB.ADD;
1688: RAISE FND_API.G_EXC_ERROR;
1689: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1690: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1691: FND_MSG_PUB.ADD;

Line 1691: FND_MSG_PUB.ADD;

1687: FND_MSG_PUB.ADD;
1688: RAISE FND_API.G_EXC_ERROR;
1689: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1690: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1691: FND_MSG_PUB.ADD;
1692: RAISE FND_API.G_EXC_ERROR;
1693: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1695: FND_MSG_PUB.ADD;

Line 1695: FND_MSG_PUB.ADD;

1691: FND_MSG_PUB.ADD;
1692: RAISE FND_API.G_EXC_ERROR;
1693: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1695: FND_MSG_PUB.ADD;
1696: RAISE FND_API.G_EXC_ERROR;
1697: else
1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1700: FND_MSG_PUB.ADD;

1696: RAISE FND_API.G_EXC_ERROR;
1697: else
1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: end if;
1703: END;
1704:

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

2217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2218: 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);
2219: END IF;
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2221: FND_MSG_PUB.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: ELSE
2224: push_eval;
2225: RETURN;

Line 2269: FND_MSG_PUB.ADD;

2265: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2266: 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);
2267: END IF;
2268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2269: FND_MSG_PUB.ADD;
2270: RAISE FND_API.G_EXC_ERROR;
2271: ELSE
2272: push_eval;
2273: RETURN;

Line 2342: FND_MSG_PUB.ADD;

2338: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2339: 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);
2340: END IF;
2341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2342: FND_MSG_PUB.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: ELSE
2345: push_eval;
2346: RETURN;

Line 2454: FND_MSG_PUB.ADD;

2450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2451: 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);
2452: END IF;
2453: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2454: FND_MSG_PUB.ADD;
2455: RAISE FND_API.G_EXC_ERROR;
2456: ELSE
2457: push_eval;
2458: RETURN;

Line 2565: FND_MSG_PUB.ADD;

2561: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2562: 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);
2563: END IF;
2564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: ELSE
2568: push_eval;
2569: RETURN;

Line 2790: FND_MSG_PUB.ADD;

2786: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2787: 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);
2788: END IF;
2789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2790: FND_MSG_PUB.ADD;
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;
2793: ELSE
2794: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2798: FND_MSG_PUB.ADD;

2794: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2795: 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);
2796: END IF;
2797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2798: FND_MSG_PUB.ADD;
2799: RAISE FND_API.G_EXC_ERROR;
2800: END IF;
2801: END IF;
2802: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3006: FND_MSG_PUB.ADD;

3002: WHEN OTHERS THEN
3003: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3004: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_parties');
3005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3006: FND_MSG_PUB.ADD;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008: END find_parties;
3009:
3010: PROCEDURE find_persons (

Line 3194: FND_MSG_PUB.ADD;

3190: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3191: 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);
3192: END IF;
3193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3194: FND_MSG_PUB.ADD;
3195: RAISE FND_API.G_EXC_ERROR;
3196: ELSE
3197: push_eval;
3198: RETURN;

Line 3242: FND_MSG_PUB.ADD;

3238: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3239: 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);
3240: END IF;
3241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3242: FND_MSG_PUB.ADD;
3243: RAISE FND_API.G_EXC_ERROR;
3244: ELSE
3245: push_eval;
3246: RETURN;

Line 3278: FND_MSG_PUB.ADD;

3274: exception
3275: when others then
3276: if (instrb(SQLERRM,'DRG-51030')>0) then
3277: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3278: FND_MSG_PUB.ADD;
3279: RAISE FND_API.G_EXC_ERROR;
3280: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3281: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3282: FND_MSG_PUB.ADD;

Line 3282: FND_MSG_PUB.ADD;

3278: FND_MSG_PUB.ADD;
3279: RAISE FND_API.G_EXC_ERROR;
3280: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3281: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3282: FND_MSG_PUB.ADD;
3283: RAISE FND_API.G_EXC_ERROR;
3284: else
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: end if;

Line 3354: FND_MSG_PUB.ADD;

3350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3351: 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);
3352: END IF;
3353: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3354: FND_MSG_PUB.ADD;
3355: RAISE FND_API.G_EXC_ERROR;
3356: ELSE
3357: push_eval;
3358: RETURN;

Line 3613: FND_MSG_PUB.ADD;

3609: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3610: 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);
3611: END IF;
3612: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3613: FND_MSG_PUB.ADD;
3614: RAISE FND_API.G_EXC_ERROR;
3615: ELSE
3616: push_eval;
3617: RETURN;

Line 3726: FND_MSG_PUB.ADD;

3722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3723: 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);
3724: END IF;
3725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: END IF;
3729: ELSE
3730: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3734: FND_MSG_PUB.ADD;

3730: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3731: 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);
3732: END IF;
3733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3734: FND_MSG_PUB.ADD;
3735: RAISE FND_API.G_EXC_ERROR;
3736: END IF;
3737: END IF;
3738: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3857: FND_MSG_PUB.ADD;

3853: WHEN OTHERS THEN
3854: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3855: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_persons');
3856: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3857: FND_MSG_PUB.ADD;
3858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3859: END find_persons;
3860:
3861: PROCEDURE find_persons (

Line 3925: FND_MSG_PUB.ADD;

3921: WHEN OTHERS THEN
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_party_details');
3924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3925: FND_MSG_PUB.ADD;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: END find_party_details;
3928:
3929: PROCEDURE find_duplicate_parties (

Line 4042: FND_MSG_PUB.ADD;

4038: WHEN OTHERS THEN
4039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4040: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_parties');
4041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4042: FND_MSG_PUB.ADD;
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: END find_duplicate_parties;
4045:
4046: PROCEDURE find_duplicate_party_sites (

Line 4127: FND_MSG_PUB.ADD;

4123: WHEN OTHERS THEN
4124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4125: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_party_sites');
4126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4127: FND_MSG_PUB.ADD;
4128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4129: END find_duplicate_party_sites;
4130:
4131: PROCEDURE find_duplicate_contacts (

Line 4216: FND_MSG_PUB.ADD;

4212: WHEN OTHERS THEN
4213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contacts');
4215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4216: FND_MSG_PUB.ADD;
4217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4218: END find_duplicate_contacts;
4219:
4220: PROCEDURE find_duplicate_contact_points (

Line 4289: FND_MSG_PUB.ADD;

4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contact_points');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END find_duplicate_contact_points;
4292:
4293: PROCEDURE find_parties_dynamic (

Line 4590: FND_MSG_PUB.ADD;

4586: WHEN OTHERS THEN
4587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.call_api_dynamic');
4589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4590: FND_MSG_PUB.ADD;
4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4592: END call_api_dynamic;
4593:
4594:

Line 4826: FND_MSG_PUB.ADD;

4822: WHEN OTHERS THEN
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4824: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_party_sites');
4825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4826: FND_MSG_PUB.ADD;
4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4828: END get_matching_party_sites;
4829:
4830:

Line 5053: FND_MSG_PUB.ADD;

5049: WHEN OTHERS THEN
5050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contacts');
5052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5053: FND_MSG_PUB.ADD;
5054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5055: END get_matching_contacts;
5056:
5057:

Line 5194: FND_MSG_PUB.ADD;

5190: WHEN OTHERS THEN
5191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contact_points');
5193: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5194: FND_MSG_PUB.ADD;
5195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5196: END get_matching_contact_points;
5197:
5198: /**********************************************************

Line 5395: FND_MSG_PUB.ADD;

5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_score_details');
5394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5395: FND_MSG_PUB.ADD;
5396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5397: END get_score_details;
5398:
5399:

Line 5505: FND_MSG_PUB.ADD;

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

Line 5551: FND_MSG_PUB.ADD;

5547: WHEN OTHERS THEN
5548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5549: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5551: FND_MSG_PUB.ADD;
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5553: END get_search_criteria;
5554:
5555:

Line 5608: FND_MSG_PUB.ADD;

5604: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5606: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5608: FND_MSG_PUB.ADD;
5609: RAISE FND_API.G_EXC_ERROR;
5610: END get_party_rec;
5611:
5612: /************************************************

Line 5664: FND_MSG_PUB.ADD;

5660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5664: FND_MSG_PUB.ADD;
5665: RAISE FND_API.G_EXC_ERROR;
5666: END get_party_site_rec;
5667:
5668: /************************************************

Line 5720: FND_MSG_PUB.ADD;

5716: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5717: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5718: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_ERROR;
5722: END get_contact_rec;
5723:
5724: /************************************************

Line 5776: FND_MSG_PUB.ADD;

5772: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5773: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5774: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END get_contact_point_rec;
5779:
5780: /************************************************

Line 5851: FND_MSG_PUB.ADD;

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

Line 5946: FND_MSG_PUB.ADD;

5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5948: END;
5949:
5950:

Line 5988: FND_MSG_PUB.ADD;

5984: WHEN OTHERS THEN
5985: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5986: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5987: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5990: END;
5991:
5992:

Line 6106: FND_MSG_PUB.ADD;

6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6108: END;
6109:
6110:

Line 6131: FND_MSG_PUB.ADD;

6127: p_contact_point_list(I).PHONE_NUMBER IS NOT NULL
6128: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6129: ) THEN
6130: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6131: FND_MSG_PUB.ADD;
6132: RAISE FND_API.G_EXC_ERROR;
6133: END IF;
6134: END LOOP;
6135:

Line 6167: FND_MSG_PUB.ADD;

6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END check_prim_cond;
6170:
6171: /************************************************

Line 6223: FND_MSG_PUB.ADD;

6219: WHEN OTHERS THEN
6220: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6221: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6222: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6223: FND_MSG_PUB.ADD;
6224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6225: END check_party_site_cond;
6226:
6227: /************************************************

Line 6271: FND_MSG_PUB.ADD;

6267: WHEN OTHERS THEN
6268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6269: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6270: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6271: FND_MSG_PUB.ADD;
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: END check_contact_cond;
6274:
6275: /************************************************

Line 6292: FND_MSG_PUB.ADD;

6288:
6289: FOR I IN 1..p_contact_point_list.COUNT LOOP
6290: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6292: FND_MSG_PUB.ADD;
6293: RAISE FND_API.G_EXC_ERROR;
6294: END IF;
6295: END LOOP;
6296:

Line 6318: FND_MSG_PUB.ADD;

6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6320: END check_contact_point_cond;
6321:
6322: FUNCTION check_staged RETURN BOOLEAN IS