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

696: WHEN OTHERS THEN
697: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
698: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
700: FND_MSG_PUB.ADD;
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END;
703:
704:

Line 720: FND_MSG_PUB.ADD;

716: WHEN OTHERS THEN
717: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
718: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
720: FND_MSG_PUB.ADD;
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END;
723:
724:

Line 740: FND_MSG_PUB.ADD;

736: WHEN OTHERS THEN
737: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
738: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END;
743:
744:

Line 760: FND_MSG_PUB.ADD;

756: WHEN OTHERS THEN
757: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
758: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
759: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
760: FND_MSG_PUB.ADD;
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END;
763:
764: PROCEDURE init_score_context (

Line 827: FND_MSG_PUB.ADD;

823: p_party_site_list,
824: p_contact_list,
825: p_contact_point_list) THEN
826: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
827: FND_MSG_PUB.ADD;
828: RAISE FND_API.G_EXC_ERROR;
829: END IF;
830: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
831: 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 1096: FND_MSG_PUB.ADD;

1092: END IF;
1093: IF lengthb(l_party_contains_str) > 4000 THEN
1094: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1095: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1096: FND_MSG_PUB.ADD;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: IF (p_match_str = ' AND ' OR p_party_max_score 1100: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1174: FND_MSG_PUB.ADD;

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

Line 1255: FND_MSG_PUB.ADD;

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

Line 1490: FND_MSG_PUB.ADD;

1486: exception
1487: when others then
1488: if (instrb(SQLERRM,'DRG-51030')>0) then
1489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1490: FND_MSG_PUB.ADD;
1491: RAISE FND_API.G_EXC_ERROR;
1492: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1494: FND_MSG_PUB.ADD;

Line 1494: FND_MSG_PUB.ADD;

1490: FND_MSG_PUB.ADD;
1491: RAISE FND_API.G_EXC_ERROR;
1492: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1494: FND_MSG_PUB.ADD;
1495: RAISE FND_API.G_EXC_ERROR;
1496: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1498: FND_MSG_PUB.ADD;

Line 1498: FND_MSG_PUB.ADD;

1494: FND_MSG_PUB.ADD;
1495: RAISE FND_API.G_EXC_ERROR;
1496: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1498: FND_MSG_PUB.ADD;
1499: RAISE FND_API.G_EXC_ERROR;
1500: else
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1503: FND_MSG_PUB.ADD;

1499: RAISE FND_API.G_EXC_ERROR;
1500: else
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: end if;
1506: END;
1507:

Line 1735: FND_MSG_PUB.ADD;

1731: exception
1732: when others then
1733: if (instrb(SQLERRM,'DRG-51030')>0) then
1734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1735: FND_MSG_PUB.ADD;
1736: RAISE FND_API.G_EXC_ERROR;
1737: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1739: FND_MSG_PUB.ADD;

Line 1739: FND_MSG_PUB.ADD;

1735: FND_MSG_PUB.ADD;
1736: RAISE FND_API.G_EXC_ERROR;
1737: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1739: FND_MSG_PUB.ADD;
1740: RAISE FND_API.G_EXC_ERROR;
1741: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1743: FND_MSG_PUB.ADD;

Line 1743: FND_MSG_PUB.ADD;

1739: FND_MSG_PUB.ADD;
1740: RAISE FND_API.G_EXC_ERROR;
1741: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1743: FND_MSG_PUB.ADD;
1744: RAISE FND_API.G_EXC_ERROR;
1745: else
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1748: FND_MSG_PUB.ADD;

1744: RAISE FND_API.G_EXC_ERROR;
1745: else
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1748: FND_MSG_PUB.ADD;
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1750: end if;
1751: END;
1752:

Line 1882: FND_MSG_PUB.ADD;

1878: exception
1879: when others then
1880: if (instrb(SQLERRM,'DRG-51030')>0) then
1881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1882: FND_MSG_PUB.ADD;
1883: RAISE FND_API.G_EXC_ERROR;
1884: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1886: FND_MSG_PUB.ADD;

Line 1886: FND_MSG_PUB.ADD;

1882: FND_MSG_PUB.ADD;
1883: RAISE FND_API.G_EXC_ERROR;
1884: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1890: FND_MSG_PUB.ADD;

Line 1890: FND_MSG_PUB.ADD;

1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1890: FND_MSG_PUB.ADD;
1891: RAISE FND_API.G_EXC_ERROR;
1892: else
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1895: FND_MSG_PUB.ADD;

1891: RAISE FND_API.G_EXC_ERROR;
1892: else
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: end if;
1898: END;
1899:

Line 2155: FND_MSG_PUB.ADD;

2151: exception
2152: when others then
2153: if (instrb(SQLERRM,'DRG-51030')>0) then
2154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2155: FND_MSG_PUB.ADD;
2156: RAISE FND_API.G_EXC_ERROR;
2157: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2159: FND_MSG_PUB.ADD;

Line 2159: FND_MSG_PUB.ADD;

2155: FND_MSG_PUB.ADD;
2156: RAISE FND_API.G_EXC_ERROR;
2157: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2159: FND_MSG_PUB.ADD;
2160: RAISE FND_API.G_EXC_ERROR;
2161: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2163: FND_MSG_PUB.ADD;

Line 2163: FND_MSG_PUB.ADD;

2159: FND_MSG_PUB.ADD;
2160: RAISE FND_API.G_EXC_ERROR;
2161: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: else
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2168: FND_MSG_PUB.ADD;

2164: RAISE FND_API.G_EXC_ERROR;
2165: else
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2168: FND_MSG_PUB.ADD;
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: end if;
2171: END;
2172:

Line 2421: FND_MSG_PUB.ADD;

2417: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2418: 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);
2419: END IF;
2420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2421: FND_MSG_PUB.ADD;
2422: RAISE FND_API.G_EXC_ERROR;
2423: ELSE
2424: push_eval;
2425: RETURN;

Line 2471: FND_MSG_PUB.ADD;

2467: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2468: 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);
2469: END IF;
2470: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2471: FND_MSG_PUB.ADD;
2472: RAISE FND_API.G_EXC_ERROR;
2473: ELSE
2474: push_eval;
2475: RETURN;

Line 2544: FND_MSG_PUB.ADD;

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

Line 2656: FND_MSG_PUB.ADD;

2652: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2653: 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);
2654: END IF;
2655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2656: FND_MSG_PUB.ADD;
2657: RAISE FND_API.G_EXC_ERROR;
2658: ELSE
2659: push_eval;
2660: RETURN;

Line 2767: FND_MSG_PUB.ADD;

2763: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2764: 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);
2765: END IF;
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2767: FND_MSG_PUB.ADD;
2768: RAISE FND_API.G_EXC_ERROR;
2769: ELSE
2770: push_eval;
2771: RETURN;

Line 2992: FND_MSG_PUB.ADD;

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

Line 3000: FND_MSG_PUB.ADD;

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

Line 3208: FND_MSG_PUB.ADD;

3204: WHEN OTHERS THEN
3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END find_parties;
3211:
3212: PROCEDURE find_persons (

Line 3401: FND_MSG_PUB.ADD;

3397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3398: 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);
3399: END IF;
3400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3401: FND_MSG_PUB.ADD;
3402: RAISE FND_API.G_EXC_ERROR;
3403: ELSE
3404: push_eval;
3405: RETURN;

Line 3451: FND_MSG_PUB.ADD;

3447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3448: 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);
3449: END IF;
3450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3451: FND_MSG_PUB.ADD;
3452: RAISE FND_API.G_EXC_ERROR;
3453: ELSE
3454: push_eval;
3455: RETURN;

Line 3487: FND_MSG_PUB.ADD;

3483: exception
3484: when others then
3485: if (instrb(SQLERRM,'DRG-51030')>0) then
3486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3487: FND_MSG_PUB.ADD;
3488: RAISE FND_API.G_EXC_ERROR;
3489: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3491: FND_MSG_PUB.ADD;

Line 3491: FND_MSG_PUB.ADD;

3487: FND_MSG_PUB.ADD;
3488: RAISE FND_API.G_EXC_ERROR;
3489: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3491: FND_MSG_PUB.ADD;
3492: RAISE FND_API.G_EXC_ERROR;
3493: else
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: end if;

Line 3563: FND_MSG_PUB.ADD;

3559: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3560: 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);
3561: END IF;
3562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3563: FND_MSG_PUB.ADD;
3564: RAISE FND_API.G_EXC_ERROR;
3565: ELSE
3566: push_eval;
3567: RETURN;

Line 3822: FND_MSG_PUB.ADD;

3818: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3819: 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);
3820: END IF;
3821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3822: FND_MSG_PUB.ADD;
3823: RAISE FND_API.G_EXC_ERROR;
3824: ELSE
3825: push_eval;
3826: RETURN;

Line 3935: FND_MSG_PUB.ADD;

3931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3932: 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);
3933: END IF;
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;
3937: END IF;
3938: ELSE
3939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3943: FND_MSG_PUB.ADD;

3939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3940: 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);
3941: END IF;
3942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3943: FND_MSG_PUB.ADD;
3944: RAISE FND_API.G_EXC_ERROR;
3945: END IF;
3946: END IF;
3947: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4066: FND_MSG_PUB.ADD;

4062: WHEN OTHERS THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4064: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4066: FND_MSG_PUB.ADD;
4067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4068: END find_persons;
4069:
4070: PROCEDURE find_persons (

Line 4134: FND_MSG_PUB.ADD;

4130: WHEN OTHERS THEN
4131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4132: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4134: FND_MSG_PUB.ADD;
4135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4136: END find_party_details;
4137:
4138: PROCEDURE find_duplicate_parties (

Line 4251: FND_MSG_PUB.ADD;

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

Line 4336: FND_MSG_PUB.ADD;

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

Line 4425: FND_MSG_PUB.ADD;

4421: WHEN OTHERS THEN
4422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4425: FND_MSG_PUB.ADD;
4426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4427: END find_duplicate_contacts;
4428:
4429: PROCEDURE find_duplicate_contact_points (

Line 4498: FND_MSG_PUB.ADD;

4494: WHEN OTHERS THEN
4495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4496: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4500: END find_duplicate_contact_points;
4501:
4502: PROCEDURE find_parties_dynamic (

Line 4813: FND_MSG_PUB.ADD;

4809: WHEN OTHERS THEN
4810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4811: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4813: FND_MSG_PUB.ADD;
4814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4815: END call_api_dynamic;
4816:
4817:

Line 5048: FND_MSG_PUB.ADD;

5044: WHEN OTHERS THEN
5045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5048: FND_MSG_PUB.ADD;
5049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5050: END get_matching_party_sites;
5051:
5052:

Line 5277: FND_MSG_PUB.ADD;

5273: WHEN OTHERS THEN
5274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5277: FND_MSG_PUB.ADD;
5278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5279: END get_matching_contacts;
5280:
5281:

Line 5419: FND_MSG_PUB.ADD;

5415: WHEN OTHERS THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5419: FND_MSG_PUB.ADD;
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: END get_matching_contact_points;
5422:
5423: /**********************************************************

Line 5632: FND_MSG_PUB.ADD;

5628: WHEN OTHERS THEN
5629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5630: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5634: END get_score_details;
5635:
5636:

Line 5720: FND_MSG_PUB.ADD;

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

Line 5766: FND_MSG_PUB.ADD;

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

Line 5831: FND_MSG_PUB.ADD;

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

Line 5883: FND_MSG_PUB.ADD;

5879: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5880: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5881: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5883: FND_MSG_PUB.ADD;
5884: RAISE FND_API.G_EXC_ERROR;
5885: END get_party_site_rec;
5886:
5887: /************************************************

Line 5941: FND_MSG_PUB.ADD;

5937: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5939: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5940: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5941: FND_MSG_PUB.ADD;
5942: RAISE FND_API.G_EXC_ERROR;
5943: END get_contact_rec;
5944:
5945: /************************************************

Line 5997: FND_MSG_PUB.ADD;

5993: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5994: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5995: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5996: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5997: FND_MSG_PUB.ADD;
5998: RAISE FND_API.G_EXC_ERROR;
5999: END get_contact_point_rec;
6000:
6001: /************************************************

Line 6171: FND_MSG_PUB.ADD;

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

Line 6214: FND_MSG_PUB.ADD;

6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6216: END;
6217:
6218:

Line 6271: FND_MSG_PUB.ADD;

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

Line 6402: FND_MSG_PUB.ADD;

6398: WHEN OTHERS THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6404: END;
6405:
6406:

Line 6427: FND_MSG_PUB.ADD;

6423: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6424: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6425: ) THEN
6426: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6427: FND_MSG_PUB.ADD;
6428: RAISE FND_API.G_EXC_ERROR;
6429: END IF;
6430: END LOOP;
6431:

Line 6467: FND_MSG_PUB.ADD;

6463: WHEN OTHERS THEN
6464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6465: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6467: FND_MSG_PUB.ADD;
6468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6469: END check_prim_cond;
6470:
6471: /************************************************

Line 6513: FND_MSG_PUB.ADD;

6509: WHEN OTHERS THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6513: FND_MSG_PUB.ADD;
6514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6515: END check_party_site_cond;
6516:
6517: /************************************************

Line 6569: FND_MSG_PUB.ADD;

6565: WHEN OTHERS THEN
6566: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6569: FND_MSG_PUB.ADD;
6570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6571: END check_contact_cond;
6572:
6573: /************************************************

Line 6590: FND_MSG_PUB.ADD;

6586:
6587: FOR I IN 1..p_contact_point_list.COUNT LOOP
6588: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6589: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6590: FND_MSG_PUB.ADD;
6591: RAISE FND_API.G_EXC_ERROR;
6592: END IF;
6593: END LOOP;
6594:

Line 6616: FND_MSG_PUB.ADD;

6612: WHEN OTHERS THEN
6613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6614: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6616: FND_MSG_PUB.ADD;
6617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6618: END check_contact_point_cond;
6619:
6620: FUNCTION check_staged RETURN BOOLEAN IS