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

662: WHEN OTHERS THEN
663: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
664: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
666: FND_MSG_PUB.ADD;
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END;
669:
670:

Line 686: FND_MSG_PUB.ADD;

682: WHEN OTHERS THEN
683: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
684: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
686: FND_MSG_PUB.ADD;
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END;
689:
690:

Line 706: FND_MSG_PUB.ADD;

702: WHEN OTHERS THEN
703: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
704: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END;
709:
710:

Line 726: FND_MSG_PUB.ADD;

722: WHEN OTHERS THEN
723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
724: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
726: FND_MSG_PUB.ADD;
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END;
729:
730: PROCEDURE init_score_context (

Line 793: FND_MSG_PUB.ADD;

789: p_party_site_list,
790: p_contact_list,
791: p_contact_point_list) THEN
792: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
797: 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 1028: FND_MSG_PUB.ADD;

1024: END IF;
1025: IF lengthb(l_party_contains_str) > 4000 THEN
1026: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1027: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1028: FND_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: IF (p_match_str = ' AND ' OR p_party_max_score 1032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1097: FND_MSG_PUB.ADD;

1093: -- Add the search criteria to query string
1094: IF lengthb(l_contains_str) > 4000 THEN
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1096: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: x_denorm_str := l_den_contains_str;
1101: RETURN l_contains_str;

Line 1187: FND_MSG_PUB.ADD;

1183: -- Add the search criteria to query string
1184: IF lengthb(l_contains_str) > 4000 THEN
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1186: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1187: FND_MSG_PUB.ADD;
1188: RAISE FND_API.G_EXC_ERROR;
1189: END IF;
1190: x_denorm_str := l_den_contains_str;
1191: RETURN l_contains_str;

Line 1405: FND_MSG_PUB.ADD;

1401: exception
1402: when others then
1403: if (instrb(SQLERRM,'DRG-51030')>0) then
1404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_ERROR;
1407: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1409: FND_MSG_PUB.ADD;

Line 1409: FND_MSG_PUB.ADD;

1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_ERROR;
1407: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1409: FND_MSG_PUB.ADD;
1410: RAISE FND_API.G_EXC_ERROR;
1411: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1413: FND_MSG_PUB.ADD;

Line 1413: FND_MSG_PUB.ADD;

1409: FND_MSG_PUB.ADD;
1410: RAISE FND_API.G_EXC_ERROR;
1411: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1413: FND_MSG_PUB.ADD;
1414: RAISE FND_API.G_EXC_ERROR;
1415: else
1416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1418: FND_MSG_PUB.ADD;

1414: RAISE FND_API.G_EXC_ERROR;
1415: else
1416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1418: FND_MSG_PUB.ADD;
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: end if;
1421: END;
1422:

Line 1650: FND_MSG_PUB.ADD;

1646: exception
1647: when others then
1648: if (instrb(SQLERRM,'DRG-51030')>0) then
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1650: FND_MSG_PUB.ADD;
1651: RAISE FND_API.G_EXC_ERROR;
1652: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1654: FND_MSG_PUB.ADD;

Line 1654: FND_MSG_PUB.ADD;

1650: FND_MSG_PUB.ADD;
1651: RAISE FND_API.G_EXC_ERROR;
1652: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_ERROR;
1656: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1658: FND_MSG_PUB.ADD;

Line 1658: FND_MSG_PUB.ADD;

1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_ERROR;
1656: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1658: FND_MSG_PUB.ADD;
1659: RAISE FND_API.G_EXC_ERROR;
1660: else
1661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1662: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1663: FND_MSG_PUB.ADD;

1659: RAISE FND_API.G_EXC_ERROR;
1660: else
1661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1662: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1663: FND_MSG_PUB.ADD;
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: end if;
1666: END;
1667:

Line 1797: FND_MSG_PUB.ADD;

1793: exception
1794: when others then
1795: if (instrb(SQLERRM,'DRG-51030')>0) then
1796: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1801: FND_MSG_PUB.ADD;

Line 1801: FND_MSG_PUB.ADD;

1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1801: FND_MSG_PUB.ADD;
1802: RAISE FND_API.G_EXC_ERROR;
1803: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1805: FND_MSG_PUB.ADD;

Line 1805: FND_MSG_PUB.ADD;

1801: FND_MSG_PUB.ADD;
1802: RAISE FND_API.G_EXC_ERROR;
1803: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1805: FND_MSG_PUB.ADD;
1806: RAISE FND_API.G_EXC_ERROR;
1807: else
1808: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1809: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1810: FND_MSG_PUB.ADD;

1806: RAISE FND_API.G_EXC_ERROR;
1807: else
1808: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1809: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1810: FND_MSG_PUB.ADD;
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: end if;
1813: END;
1814:

Line 2070: FND_MSG_PUB.ADD;

2066: exception
2067: when others then
2068: if (instrb(SQLERRM,'DRG-51030')>0) then
2069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2070: FND_MSG_PUB.ADD;
2071: RAISE FND_API.G_EXC_ERROR;
2072: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2074: FND_MSG_PUB.ADD;

Line 2074: FND_MSG_PUB.ADD;

2070: FND_MSG_PUB.ADD;
2071: RAISE FND_API.G_EXC_ERROR;
2072: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2074: FND_MSG_PUB.ADD;
2075: RAISE FND_API.G_EXC_ERROR;
2076: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2078: FND_MSG_PUB.ADD;

Line 2078: FND_MSG_PUB.ADD;

2074: FND_MSG_PUB.ADD;
2075: RAISE FND_API.G_EXC_ERROR;
2076: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: else
2081: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2083: FND_MSG_PUB.ADD;

2079: RAISE FND_API.G_EXC_ERROR;
2080: else
2081: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2083: FND_MSG_PUB.ADD;
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: end if;
2086: END;
2087:

Line 2335: FND_MSG_PUB.ADD;

2331: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2332: 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);
2333: END IF;
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2335: FND_MSG_PUB.ADD;
2336: RAISE FND_API.G_EXC_ERROR;
2337: ELSE
2338: push_eval;
2339: RETURN;

Line 2383: FND_MSG_PUB.ADD;

2379: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2380: 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);
2381: END IF;
2382: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2383: FND_MSG_PUB.ADD;
2384: RAISE FND_API.G_EXC_ERROR;
2385: ELSE
2386: push_eval;
2387: RETURN;

Line 2456: FND_MSG_PUB.ADD;

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

Line 2568: FND_MSG_PUB.ADD;

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

Line 2679: FND_MSG_PUB.ADD;

2675: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2676: 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);
2677: END IF;
2678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2679: FND_MSG_PUB.ADD;
2680: RAISE FND_API.G_EXC_ERROR;
2681: ELSE
2682: push_eval;
2683: RETURN;

Line 2904: FND_MSG_PUB.ADD;

2900: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2901: 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);
2902: END IF;
2903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2904: FND_MSG_PUB.ADD;
2905: RAISE FND_API.G_EXC_ERROR;
2906: END IF;
2907: ELSE
2908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2912: FND_MSG_PUB.ADD;

2908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2909: 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);
2910: END IF;
2911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2912: FND_MSG_PUB.ADD;
2913: RAISE FND_API.G_EXC_ERROR;
2914: END IF;
2915: END IF;
2916: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3120: FND_MSG_PUB.ADD;

3116: WHEN OTHERS THEN
3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_parties');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3120: FND_MSG_PUB.ADD;
3121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3122: END find_parties;
3123:
3124: PROCEDURE find_persons (

Line 3312: FND_MSG_PUB.ADD;

3308: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3309: 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);
3310: END IF;
3311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3312: FND_MSG_PUB.ADD;
3313: RAISE FND_API.G_EXC_ERROR;
3314: ELSE
3315: push_eval;
3316: RETURN;

Line 3360: FND_MSG_PUB.ADD;

3356: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3357: 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);
3358: END IF;
3359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3360: FND_MSG_PUB.ADD;
3361: RAISE FND_API.G_EXC_ERROR;
3362: ELSE
3363: push_eval;
3364: RETURN;

Line 3396: FND_MSG_PUB.ADD;

3392: exception
3393: when others then
3394: if (instrb(SQLERRM,'DRG-51030')>0) then
3395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3396: FND_MSG_PUB.ADD;
3397: RAISE FND_API.G_EXC_ERROR;
3398: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3400: FND_MSG_PUB.ADD;

Line 3400: FND_MSG_PUB.ADD;

3396: FND_MSG_PUB.ADD;
3397: RAISE FND_API.G_EXC_ERROR;
3398: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3400: FND_MSG_PUB.ADD;
3401: RAISE FND_API.G_EXC_ERROR;
3402: else
3403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3404: end if;

Line 3472: FND_MSG_PUB.ADD;

3468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3469: 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);
3470: END IF;
3471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3472: FND_MSG_PUB.ADD;
3473: RAISE FND_API.G_EXC_ERROR;
3474: ELSE
3475: push_eval;
3476: RETURN;

Line 3731: FND_MSG_PUB.ADD;

3727: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3728: 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);
3729: END IF;
3730: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3731: FND_MSG_PUB.ADD;
3732: RAISE FND_API.G_EXC_ERROR;
3733: ELSE
3734: push_eval;
3735: RETURN;

Line 3844: FND_MSG_PUB.ADD;

3840: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3841: 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);
3842: END IF;
3843: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3844: FND_MSG_PUB.ADD;
3845: RAISE FND_API.G_EXC_ERROR;
3846: END IF;
3847: ELSE
3848: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3852: FND_MSG_PUB.ADD;

3848: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3849: 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);
3850: END IF;
3851: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3852: FND_MSG_PUB.ADD;
3853: RAISE FND_API.G_EXC_ERROR;
3854: END IF;
3855: END IF;
3856: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3975: FND_MSG_PUB.ADD;

3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_persons;
3978:
3979: PROCEDURE find_persons (

Line 4043: FND_MSG_PUB.ADD;

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

Line 4160: FND_MSG_PUB.ADD;

4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4162: END find_duplicate_parties;
4163:
4164: PROCEDURE find_duplicate_party_sites (

Line 4245: FND_MSG_PUB.ADD;

4241: WHEN OTHERS THEN
4242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4243: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');
4244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4245: FND_MSG_PUB.ADD;
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: END find_duplicate_party_sites;
4248:
4249: PROCEDURE find_duplicate_contacts (

Line 4334: FND_MSG_PUB.ADD;

4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END find_duplicate_contacts;
4337:
4338: PROCEDURE find_duplicate_contact_points (

Line 4407: FND_MSG_PUB.ADD;

4403: WHEN OTHERS THEN
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4405: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contact_points');
4406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4407: FND_MSG_PUB.ADD;
4408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4409: END find_duplicate_contact_points;
4410:
4411: PROCEDURE find_parties_dynamic (

Line 4715: FND_MSG_PUB.ADD;

4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4715: FND_MSG_PUB.ADD;
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END call_api_dynamic;
4718:
4719:

Line 4953: FND_MSG_PUB.ADD;

4949: WHEN OTHERS THEN
4950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');
4952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: END get_matching_party_sites;
4956:
4957:

Line 5181: FND_MSG_PUB.ADD;

5177: WHEN OTHERS THEN
5178: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5179: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5181: FND_MSG_PUB.ADD;
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: END get_matching_contacts;
5184:
5185:

Line 5323: FND_MSG_PUB.ADD;

5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: END get_matching_contact_points;
5326:
5327: /**********************************************************

Line 5535: FND_MSG_PUB.ADD;

5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5535: FND_MSG_PUB.ADD;
5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5537: END get_score_details;
5538:
5539:

Line 5645: FND_MSG_PUB.ADD;

5641: WHEN OTHERS THEN
5642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5643: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5645: FND_MSG_PUB.ADD;
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: END get_party_for_search;
5648:
5649: PROCEDURE get_search_criteria (

Line 5691: FND_MSG_PUB.ADD;

5687: WHEN OTHERS THEN
5688: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5689: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5690: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5691: FND_MSG_PUB.ADD;
5692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5693: END get_search_criteria;
5694:
5695:

Line 5752: FND_MSG_PUB.ADD;

5748: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5750: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5752: FND_MSG_PUB.ADD;
5753: RAISE FND_API.G_EXC_ERROR;
5754: END get_party_rec;
5755:
5756: /************************************************

Line 5808: FND_MSG_PUB.ADD;

5804: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5806: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5808: FND_MSG_PUB.ADD;
5809: RAISE FND_API.G_EXC_ERROR;
5810: END get_party_site_rec;
5811:
5812: /************************************************

Line 5864: FND_MSG_PUB.ADD;

5860: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5861: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5862: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END get_contact_rec;
5867:
5868: /************************************************

Line 5920: FND_MSG_PUB.ADD;

5916: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5917: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5918: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5919: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5920: FND_MSG_PUB.ADD;
5921: RAISE FND_API.G_EXC_ERROR;
5922: END get_contact_point_rec;
5923:
5924: /************************************************

Line 6034: FND_MSG_PUB.ADD;

6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6036: END;
6037:
6038:

Line 6152: FND_MSG_PUB.ADD;

6148: WHEN OTHERS THEN
6149: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6152: FND_MSG_PUB.ADD;
6153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6154: END;
6155:
6156:

Line 6194: FND_MSG_PUB.ADD;

6190: WHEN OTHERS THEN
6191: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6192: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6193: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6194: FND_MSG_PUB.ADD;
6195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6196: END;
6197:
6198:

Line 6325: FND_MSG_PUB.ADD;

6321: WHEN OTHERS THEN
6322: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6323: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6325: FND_MSG_PUB.ADD;
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END;
6328:
6329:

Line 6349: FND_MSG_PUB.ADD;

6345: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6346: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6347: ) THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6349: FND_MSG_PUB.ADD;
6350: RAISE FND_API.G_EXC_ERROR;
6351: END IF;
6352: END LOOP;
6353:

Line 6383: FND_MSG_PUB.ADD;

6379: WHEN OTHERS THEN
6380: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6381: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6385: END check_prim_cond;
6386:
6387: /************************************************

Line 6438: FND_MSG_PUB.ADD;

6434: WHEN OTHERS THEN
6435: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6436: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6437: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6438: FND_MSG_PUB.ADD;
6439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6440: END check_party_site_cond;
6441:
6442: /************************************************

Line 6485: FND_MSG_PUB.ADD;

6481: WHEN OTHERS THEN
6482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6483: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6485: FND_MSG_PUB.ADD;
6486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6487: END check_contact_cond;
6488:
6489: /************************************************

Line 6506: FND_MSG_PUB.ADD;

6502:
6503: FOR I IN 1..p_contact_point_list.COUNT LOOP
6504: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6505: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6506: FND_MSG_PUB.ADD;
6507: RAISE FND_API.G_EXC_ERROR;
6508: END IF;
6509: END LOOP;
6510:

Line 6531: FND_MSG_PUB.ADD;

6527: WHEN OTHERS THEN
6528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6529: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6531: FND_MSG_PUB.ADD;
6532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6533: END check_contact_point_cond;
6534:
6535: FUNCTION check_staged RETURN BOOLEAN IS