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

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

Line 1411: FND_MSG_PUB.ADD;

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

Line 1415: FND_MSG_PUB.ADD;

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

Line 1420: FND_MSG_PUB.ADD;

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

Line 1652: FND_MSG_PUB.ADD;

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

Line 1656: FND_MSG_PUB.ADD;

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

Line 1660: FND_MSG_PUB.ADD;

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

Line 1665: FND_MSG_PUB.ADD;

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

Line 1799: FND_MSG_PUB.ADD;

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

Line 1803: FND_MSG_PUB.ADD;

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

Line 1807: FND_MSG_PUB.ADD;

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

Line 1812: FND_MSG_PUB.ADD;

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

Line 2072: FND_MSG_PUB.ADD;

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

Line 2076: FND_MSG_PUB.ADD;

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

Line 2080: FND_MSG_PUB.ADD;

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

Line 2085: FND_MSG_PUB.ADD;

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

Line 2338: FND_MSG_PUB.ADD;

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

Line 2386: FND_MSG_PUB.ADD;

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

Line 2459: FND_MSG_PUB.ADD;

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

Line 2571: FND_MSG_PUB.ADD;

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

Line 2682: FND_MSG_PUB.ADD;

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

Line 2907: FND_MSG_PUB.ADD;

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

Line 2915: FND_MSG_PUB.ADD;

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

Line 3123: FND_MSG_PUB.ADD;

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

Line 3316: FND_MSG_PUB.ADD;

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

Line 3364: FND_MSG_PUB.ADD;

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

Line 3400: FND_MSG_PUB.ADD;

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

Line 3404: FND_MSG_PUB.ADD;

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

Line 3476: FND_MSG_PUB.ADD;

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

Line 3735: FND_MSG_PUB.ADD;

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

Line 3848: FND_MSG_PUB.ADD;

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

Line 3856: FND_MSG_PUB.ADD;

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

Line 3979: FND_MSG_PUB.ADD;

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

Line 4047: FND_MSG_PUB.ADD;

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

Line 4164: FND_MSG_PUB.ADD;

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

Line 4249: FND_MSG_PUB.ADD;

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

Line 4338: FND_MSG_PUB.ADD;

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

Line 4411: FND_MSG_PUB.ADD;

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

Line 4719: FND_MSG_PUB.ADD;

4715: WHEN OTHERS THEN
4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4718: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4719: FND_MSG_PUB.ADD;
4720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4721: END call_api_dynamic;
4722:
4723:

Line 4957: FND_MSG_PUB.ADD;

4953: WHEN OTHERS THEN
4954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4955: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');
4956: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4957: FND_MSG_PUB.ADD;
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: END get_matching_party_sites;
4960:
4961:

Line 5185: FND_MSG_PUB.ADD;

5181: WHEN OTHERS THEN
5182: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5183: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5184: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5185: FND_MSG_PUB.ADD;
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: END get_matching_contacts;
5188:
5189:

Line 5327: FND_MSG_PUB.ADD;

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

Line 5540: FND_MSG_PUB.ADD;

5536: WHEN OTHERS THEN
5537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5538: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5540: FND_MSG_PUB.ADD;
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: END get_score_details;
5543:
5544:

Line 5650: FND_MSG_PUB.ADD;

5646: WHEN OTHERS THEN
5647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5648: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: END get_party_for_search;
5653:
5654: PROCEDURE get_search_criteria (

Line 5696: FND_MSG_PUB.ADD;

5692: WHEN OTHERS THEN
5693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5694: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5695: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5696: FND_MSG_PUB.ADD;
5697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5698: END get_search_criteria;
5699:
5700:

Line 5757: FND_MSG_PUB.ADD;

5753: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5754: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5755: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5756: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5757: FND_MSG_PUB.ADD;
5758: RAISE FND_API.G_EXC_ERROR;
5759: END get_party_rec;
5760:
5761: /************************************************

Line 5813: FND_MSG_PUB.ADD;

5809: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5810: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5811: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5813: FND_MSG_PUB.ADD;
5814: RAISE FND_API.G_EXC_ERROR;
5815: END get_party_site_rec;
5816:
5817: /************************************************

Line 5869: FND_MSG_PUB.ADD;

5865: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5866: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5867: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_ERROR;
5871: END get_contact_rec;
5872:
5873: /************************************************

Line 5925: FND_MSG_PUB.ADD;

5921: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5922: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5923: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_ERROR;
5927: END get_contact_point_rec;
5928:
5929: /************************************************

Line 6039: FND_MSG_PUB.ADD;

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

Line 6157: FND_MSG_PUB.ADD;

6153: WHEN OTHERS THEN
6154: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6155: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6157: FND_MSG_PUB.ADD;
6158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6159: END;
6160:
6161:

Line 6199: FND_MSG_PUB.ADD;

6195: WHEN OTHERS THEN
6196: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6197: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6199: FND_MSG_PUB.ADD;
6200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6201: END;
6202:
6203:

Line 6330: FND_MSG_PUB.ADD;

6326: WHEN OTHERS THEN
6327: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6328: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6330: FND_MSG_PUB.ADD;
6331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6332: END;
6333:
6334:

Line 6354: FND_MSG_PUB.ADD;

6350: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6351: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6352: ) THEN
6353: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6354: FND_MSG_PUB.ADD;
6355: RAISE FND_API.G_EXC_ERROR;
6356: END IF;
6357: END LOOP;
6358:

Line 6388: FND_MSG_PUB.ADD;

6384: WHEN OTHERS THEN
6385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6386: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6387: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6388: FND_MSG_PUB.ADD;
6389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6390: END check_prim_cond;
6391:
6392: /************************************************

Line 6443: FND_MSG_PUB.ADD;

6439: WHEN OTHERS THEN
6440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6441: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6443: FND_MSG_PUB.ADD;
6444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6445: END check_party_site_cond;
6446:
6447: /************************************************

Line 6490: FND_MSG_PUB.ADD;

6486: WHEN OTHERS THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6492: END check_contact_cond;
6493:
6494: /************************************************

Line 6511: FND_MSG_PUB.ADD;

6507:
6508: FOR I IN 1..p_contact_point_list.COUNT LOOP
6509: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6511: FND_MSG_PUB.ADD;
6512: RAISE FND_API.G_EXC_ERROR;
6513: END IF;
6514: END LOOP;
6515:

Line 6536: FND_MSG_PUB.ADD;

6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6538: END check_contact_point_cond;
6539:
6540: FUNCTION check_staged RETURN BOOLEAN IS