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

633: WHEN OTHERS THEN
634: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
635: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END;
640:
641:

Line 657: FND_MSG_PUB.ADD;

653: WHEN OTHERS THEN
654: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
655: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
657: FND_MSG_PUB.ADD;
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END;
660:
661:

Line 677: FND_MSG_PUB.ADD;

673: WHEN OTHERS THEN
674: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
675: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END;
680:
681:

Line 697: FND_MSG_PUB.ADD;

693: WHEN OTHERS THEN
694: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
695: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END;
700:
701: PROCEDURE init_score_context (

Line 764: FND_MSG_PUB.ADD;

760: p_party_site_list,
761: p_contact_list,
762: p_contact_point_list) THEN
763: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
764: FND_MSG_PUB.ADD;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
768: 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 1016: FND_MSG_PUB.ADD;

1012: END IF;
1013: IF lengthb(l_party_contains_str) > 4000 THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1015: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1016: FND_MSG_PUB.ADD;
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019: IF (p_match_str = ' AND ' OR p_party_max_score 1020: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1085: FND_MSG_PUB.ADD;

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

Line 1175: FND_MSG_PUB.ADD;

1171: -- Add the search criteria to query string
1172: IF lengthb(l_contains_str) > 4000 THEN
1173: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1174: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1175: FND_MSG_PUB.ADD;
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: x_denorm_str := l_den_contains_str;
1179: RETURN l_contains_str;

Line 1402: FND_MSG_PUB.ADD;

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

Line 1406: FND_MSG_PUB.ADD;

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

Line 1410: FND_MSG_PUB.ADD;

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

Line 1415: FND_MSG_PUB.ADD;

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

Line 1647: FND_MSG_PUB.ADD;

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

Line 1651: FND_MSG_PUB.ADD;

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

Line 1655: FND_MSG_PUB.ADD;

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

Line 1660: FND_MSG_PUB.ADD;

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

Line 1794: FND_MSG_PUB.ADD;

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

Line 1798: FND_MSG_PUB.ADD;

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

Line 1802: FND_MSG_PUB.ADD;

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

Line 1807: FND_MSG_PUB.ADD;

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

Line 2067: FND_MSG_PUB.ADD;

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

Line 2071: FND_MSG_PUB.ADD;

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

Line 2075: FND_MSG_PUB.ADD;

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

Line 2080: FND_MSG_PUB.ADD;

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

Line 2329: FND_MSG_PUB.ADD;

2325: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2326: 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);
2327: END IF;
2328: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2329: FND_MSG_PUB.ADD;
2330: RAISE FND_API.G_EXC_ERROR;
2331: ELSE
2332: push_eval;
2333: RETURN;

Line 2377: FND_MSG_PUB.ADD;

2373: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2374: 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);
2375: END IF;
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2377: FND_MSG_PUB.ADD;
2378: RAISE FND_API.G_EXC_ERROR;
2379: ELSE
2380: push_eval;
2381: RETURN;

Line 2450: FND_MSG_PUB.ADD;

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

Line 2562: FND_MSG_PUB.ADD;

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

Line 2673: FND_MSG_PUB.ADD;

2669: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2670: 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);
2671: END IF;
2672: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2673: FND_MSG_PUB.ADD;
2674: RAISE FND_API.G_EXC_ERROR;
2675: ELSE
2676: push_eval;
2677: RETURN;

Line 2898: FND_MSG_PUB.ADD;

2894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2895: 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);
2896: END IF;
2897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2898: FND_MSG_PUB.ADD;
2899: RAISE FND_API.G_EXC_ERROR;
2900: END IF;
2901: ELSE
2902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2906: FND_MSG_PUB.ADD;

2902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2903: 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);
2904: END IF;
2905: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2906: FND_MSG_PUB.ADD;
2907: RAISE FND_API.G_EXC_ERROR;
2908: END IF;
2909: END IF;
2910: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3114: FND_MSG_PUB.ADD;

3110: WHEN OTHERS THEN
3111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3112: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_parties');
3113: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3114: FND_MSG_PUB.ADD;
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: END find_parties;
3117:
3118: PROCEDURE find_persons (

Line 3303: FND_MSG_PUB.ADD;

3299: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3300: 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);
3301: END IF;
3302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3303: FND_MSG_PUB.ADD;
3304: RAISE FND_API.G_EXC_ERROR;
3305: ELSE
3306: push_eval;
3307: RETURN;

Line 3351: FND_MSG_PUB.ADD;

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

Line 3387: FND_MSG_PUB.ADD;

3383: exception
3384: when others then
3385: if (instrb(SQLERRM,'DRG-51030')>0) then
3386: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3387: FND_MSG_PUB.ADD;
3388: RAISE FND_API.G_EXC_ERROR;
3389: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3391: FND_MSG_PUB.ADD;

Line 3391: FND_MSG_PUB.ADD;

3387: FND_MSG_PUB.ADD;
3388: RAISE FND_API.G_EXC_ERROR;
3389: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3391: FND_MSG_PUB.ADD;
3392: RAISE FND_API.G_EXC_ERROR;
3393: else
3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3395: end if;

Line 3463: FND_MSG_PUB.ADD;

3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3460: 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);
3461: END IF;
3462: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3463: FND_MSG_PUB.ADD;
3464: RAISE FND_API.G_EXC_ERROR;
3465: ELSE
3466: push_eval;
3467: RETURN;

Line 3722: FND_MSG_PUB.ADD;

3718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3719: 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);
3720: END IF;
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: ELSE
3725: push_eval;
3726: RETURN;

Line 3835: FND_MSG_PUB.ADD;

3831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3832: 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);
3833: END IF;
3834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3835: FND_MSG_PUB.ADD;
3836: RAISE FND_API.G_EXC_ERROR;
3837: END IF;
3838: ELSE
3839: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3843: FND_MSG_PUB.ADD;

3839: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3840: 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);
3841: END IF;
3842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3843: FND_MSG_PUB.ADD;
3844: RAISE FND_API.G_EXC_ERROR;
3845: END IF;
3846: END IF;
3847: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3966: FND_MSG_PUB.ADD;

3962: WHEN OTHERS THEN
3963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_persons');
3965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END find_persons;
3969:
3970: PROCEDURE find_persons (

Line 4034: FND_MSG_PUB.ADD;

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

Line 4151: FND_MSG_PUB.ADD;

4147: WHEN OTHERS THEN
4148: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4149: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_parties');
4150: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4151: FND_MSG_PUB.ADD;
4152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4153: END find_duplicate_parties;
4154:
4155: PROCEDURE find_duplicate_party_sites (

Line 4236: FND_MSG_PUB.ADD;

4232: WHEN OTHERS THEN
4233: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4234: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_party_sites');
4235: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4236: FND_MSG_PUB.ADD;
4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4238: END find_duplicate_party_sites;
4239:
4240: PROCEDURE find_duplicate_contacts (

Line 4325: FND_MSG_PUB.ADD;

4321: WHEN OTHERS THEN
4322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4323: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contacts');
4324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4325: FND_MSG_PUB.ADD;
4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4327: END find_duplicate_contacts;
4328:
4329: PROCEDURE find_duplicate_contact_points (

Line 4398: FND_MSG_PUB.ADD;

4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contact_points');
4397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4398: FND_MSG_PUB.ADD;
4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4400: END find_duplicate_contact_points;
4401:
4402: PROCEDURE find_parties_dynamic (

Line 4689: FND_MSG_PUB.ADD;

4685: WHEN OTHERS THEN
4686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.call_api_dynamic');
4688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4689: FND_MSG_PUB.ADD;
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: END call_api_dynamic;
4692:
4693:

Line 4924: FND_MSG_PUB.ADD;

4920: WHEN OTHERS THEN
4921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_party_sites');
4923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4924: FND_MSG_PUB.ADD;
4925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4926: END get_matching_party_sites;
4927:
4928:

Line 5150: FND_MSG_PUB.ADD;

5146: WHEN OTHERS THEN
5147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5148: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contacts');
5149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5150: FND_MSG_PUB.ADD;
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: END get_matching_contacts;
5153:
5154:

Line 5290: FND_MSG_PUB.ADD;

5286: WHEN OTHERS THEN
5287: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5288: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contact_points');
5289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5292: END get_matching_contact_points;
5293:
5294: /**********************************************************

Line 5492: FND_MSG_PUB.ADD;

5488: WHEN OTHERS THEN
5489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_score_details');
5491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5494: END get_score_details;
5495:
5496:

Line 5602: FND_MSG_PUB.ADD;

5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END get_party_for_search;
5605:
5606: PROCEDURE get_search_criteria (

Line 5648: FND_MSG_PUB.ADD;

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

Line 5711: FND_MSG_PUB.ADD;

5707: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5708: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5709: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5711: FND_MSG_PUB.ADD;
5712: RAISE FND_API.G_EXC_ERROR;
5713: END get_party_rec;
5714:
5715: /************************************************

Line 5767: FND_MSG_PUB.ADD;

5763: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5765: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_ERROR;
5769: END get_party_site_rec;
5770:
5771: /************************************************

Line 5823: FND_MSG_PUB.ADD;

5819: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5821: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5822: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5823: FND_MSG_PUB.ADD;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END get_contact_rec;
5826:
5827: /************************************************

Line 5877: FND_MSG_PUB.ADD;

5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;
5878: RAISE FND_API.G_EXC_ERROR;
5879: END get_contact_point_rec;
5880:
5881: /************************************************

Line 5995: FND_MSG_PUB.ADD;

5991: WHEN OTHERS THEN
5992: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5993: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5994: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5995: FND_MSG_PUB.ADD;
5996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5997: END;
5998:
5999:

Line 6090: FND_MSG_PUB.ADD;

6086: WHEN OTHERS THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6090: FND_MSG_PUB.ADD;
6091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6092: END;
6093:
6094:

Line 6132: FND_MSG_PUB.ADD;

6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6134: END;
6135:
6136:

Line 6224: FND_MSG_PUB.ADD;

6220: WHEN OTHERS THEN
6221: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6222: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6224: FND_MSG_PUB.ADD;
6225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6226: END;
6227:
6228:

Line 6248: FND_MSG_PUB.ADD;

6244: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6245: p_contact_point_list(I).PHONE_NUMBER IS NOT NULL
6246: ) THEN
6247: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6248: FND_MSG_PUB.ADD;
6249: RAISE FND_API.G_EXC_ERROR;
6250: END IF;
6251: END LOOP;
6252:

Line 6285: FND_MSG_PUB.ADD;

6281: WHEN OTHERS THEN
6282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6283: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6285: FND_MSG_PUB.ADD;
6286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6287: END check_prim_cond;
6288:
6289: /************************************************

Line 6339: FND_MSG_PUB.ADD;

6335: WHEN OTHERS THEN
6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6339: FND_MSG_PUB.ADD;
6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6341: END check_party_site_cond;
6342:
6343: /************************************************

Line 6385: FND_MSG_PUB.ADD;

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

Line 6406: FND_MSG_PUB.ADD;

6402:
6403: FOR I IN 1..p_contact_point_list.COUNT LOOP
6404: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6405: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6406: FND_MSG_PUB.ADD;
6407: RAISE FND_API.G_EXC_ERROR;
6408: END IF;
6409: END LOOP;
6410:

Line 6430: FND_MSG_PUB.ADD;

6426: WHEN OTHERS THEN
6427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6428: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6432: END check_contact_point_cond;
6433:
6434: FUNCTION check_staged RETURN BOOLEAN IS