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

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

Line 1492: FND_MSG_PUB.ADD;

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

Line 1496: FND_MSG_PUB.ADD;

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

Line 1501: FND_MSG_PUB.ADD;

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

Line 1733: FND_MSG_PUB.ADD;

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

Line 1737: FND_MSG_PUB.ADD;

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

Line 1741: FND_MSG_PUB.ADD;

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

Line 1746: FND_MSG_PUB.ADD;

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

Line 1880: FND_MSG_PUB.ADD;

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

Line 1884: FND_MSG_PUB.ADD;

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

Line 1888: FND_MSG_PUB.ADD;

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

Line 1893: FND_MSG_PUB.ADD;

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

Line 2153: FND_MSG_PUB.ADD;

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

Line 2157: FND_MSG_PUB.ADD;

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

Line 2161: FND_MSG_PUB.ADD;

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

Line 2166: FND_MSG_PUB.ADD;

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

Line 2418: FND_MSG_PUB.ADD;

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

Line 2466: FND_MSG_PUB.ADD;

2462: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2463: 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);
2464: END IF;
2465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: ELSE
2469: push_eval;
2470: RETURN;

Line 2539: FND_MSG_PUB.ADD;

2535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2536: 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);
2537: END IF;
2538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2539: FND_MSG_PUB.ADD;
2540: RAISE FND_API.G_EXC_ERROR;
2541: ELSE
2542: push_eval;
2543: RETURN;

Line 2651: FND_MSG_PUB.ADD;

2647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2648: 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);
2649: END IF;
2650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2651: FND_MSG_PUB.ADD;
2652: RAISE FND_API.G_EXC_ERROR;
2653: ELSE
2654: push_eval;
2655: RETURN;

Line 2762: FND_MSG_PUB.ADD;

2758: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2759: 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);
2760: END IF;
2761: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2762: FND_MSG_PUB.ADD;
2763: RAISE FND_API.G_EXC_ERROR;
2764: ELSE
2765: push_eval;
2766: RETURN;

Line 2987: FND_MSG_PUB.ADD;

2983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2984: 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);
2985: END IF;
2986: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;
2989: END IF;
2990: ELSE
2991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2995: FND_MSG_PUB.ADD;

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

Line 3203: FND_MSG_PUB.ADD;

3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END find_parties;
3206:
3207: PROCEDURE find_persons (

Line 3395: FND_MSG_PUB.ADD;

3391: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3392: 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);
3393: END IF;
3394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3395: FND_MSG_PUB.ADD;
3396: RAISE FND_API.G_EXC_ERROR;
3397: ELSE
3398: push_eval;
3399: RETURN;

Line 3443: FND_MSG_PUB.ADD;

3439: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3440: 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);
3441: END IF;
3442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3443: FND_MSG_PUB.ADD;
3444: RAISE FND_API.G_EXC_ERROR;
3445: ELSE
3446: push_eval;
3447: RETURN;

Line 3479: FND_MSG_PUB.ADD;

3475: exception
3476: when others then
3477: if (instrb(SQLERRM,'DRG-51030')>0) then
3478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3479: FND_MSG_PUB.ADD;
3480: RAISE FND_API.G_EXC_ERROR;
3481: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3483: FND_MSG_PUB.ADD;

Line 3483: FND_MSG_PUB.ADD;

3479: FND_MSG_PUB.ADD;
3480: RAISE FND_API.G_EXC_ERROR;
3481: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3483: FND_MSG_PUB.ADD;
3484: RAISE FND_API.G_EXC_ERROR;
3485: else
3486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3487: end if;

Line 3555: FND_MSG_PUB.ADD;

3551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3552: 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);
3553: END IF;
3554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3555: FND_MSG_PUB.ADD;
3556: RAISE FND_API.G_EXC_ERROR;
3557: ELSE
3558: push_eval;
3559: RETURN;

Line 3814: FND_MSG_PUB.ADD;

3810: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3811: 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);
3812: END IF;
3813: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3814: FND_MSG_PUB.ADD;
3815: RAISE FND_API.G_EXC_ERROR;
3816: ELSE
3817: push_eval;
3818: RETURN;

Line 3927: FND_MSG_PUB.ADD;

3923: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3924: 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);
3925: END IF;
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_ERROR;
3929: END IF;
3930: ELSE
3931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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: END IF;
3939: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4058: FND_MSG_PUB.ADD;

4054: WHEN OTHERS THEN
4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4056: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4058: FND_MSG_PUB.ADD;
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: END find_persons;
4061:
4062: PROCEDURE find_persons (

Line 4126: FND_MSG_PUB.ADD;

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

Line 4243: FND_MSG_PUB.ADD;

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

Line 4328: FND_MSG_PUB.ADD;

4324: WHEN OTHERS THEN
4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4326: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4328: FND_MSG_PUB.ADD;
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: END find_duplicate_party_sites;
4331:
4332: PROCEDURE find_duplicate_contacts (

Line 4417: FND_MSG_PUB.ADD;

4413: WHEN OTHERS THEN
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4415: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: END find_duplicate_contacts;
4420:
4421: PROCEDURE find_duplicate_contact_points (

Line 4490: FND_MSG_PUB.ADD;

4486: WHEN OTHERS THEN
4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4488: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4492: END find_duplicate_contact_points;
4493:
4494: PROCEDURE find_parties_dynamic (

Line 4805: FND_MSG_PUB.ADD;

4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END call_api_dynamic;
4808:
4809:

Line 5040: FND_MSG_PUB.ADD;

5036: WHEN OTHERS THEN
5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5040: FND_MSG_PUB.ADD;
5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5042: END get_matching_party_sites;
5043:
5044:

Line 5269: FND_MSG_PUB.ADD;

5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_contacts;
5272:
5273:

Line 5411: FND_MSG_PUB.ADD;

5407: WHEN OTHERS THEN
5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5411: FND_MSG_PUB.ADD;
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5413: END get_matching_contact_points;
5414:
5415: /**********************************************************

Line 5621: FND_MSG_PUB.ADD;

5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5621: FND_MSG_PUB.ADD;
5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5623: END get_score_details;
5624:
5625:

Line 5709: FND_MSG_PUB.ADD;

5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5709: FND_MSG_PUB.ADD;
5710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5711: END get_party_for_search;
5712:
5713: PROCEDURE get_search_criteria (

Line 5755: FND_MSG_PUB.ADD;

5751: WHEN OTHERS THEN
5752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5755: FND_MSG_PUB.ADD;
5756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5757: END get_search_criteria;
5758:
5759:

Line 5820: FND_MSG_PUB.ADD;

5816: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5818: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5820: FND_MSG_PUB.ADD;
5821: RAISE FND_API.G_EXC_ERROR;
5822: END get_party_rec;
5823:
5824: /************************************************

Line 5872: FND_MSG_PUB.ADD;

5868: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;
5874: END get_party_site_rec;
5875:
5876: /************************************************

Line 5930: FND_MSG_PUB.ADD;

5926: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5928: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_ERROR;
5932: END get_contact_rec;
5933:
5934: /************************************************

Line 5986: FND_MSG_PUB.ADD;

5982: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5983: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5984: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_ERROR;
5988: END get_contact_point_rec;
5989:
5990: /************************************************

Line 6160: FND_MSG_PUB.ADD;

6156: WHEN OTHERS THEN
6157: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6158: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6160: FND_MSG_PUB.ADD;
6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6162: END;
6163:
6164:

Line 6203: FND_MSG_PUB.ADD;

6199: WHEN OTHERS THEN
6200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6203: FND_MSG_PUB.ADD;
6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6205: END;
6206:
6207:

Line 6260: FND_MSG_PUB.ADD;

6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: END;
6263:
6264:

Line 6391: FND_MSG_PUB.ADD;

6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6393: END;
6394:
6395:

Line 6416: FND_MSG_PUB.ADD;

6412: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6413: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6414: ) THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6416: FND_MSG_PUB.ADD;
6417: RAISE FND_API.G_EXC_ERROR;
6418: END IF;
6419: END LOOP;
6420:

Line 6456: FND_MSG_PUB.ADD;

6452: WHEN OTHERS THEN
6453: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6454: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6456: FND_MSG_PUB.ADD;
6457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6458: END check_prim_cond;
6459:
6460: /************************************************

Line 6502: FND_MSG_PUB.ADD;

6498: WHEN OTHERS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6502: FND_MSG_PUB.ADD;
6503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6504: END check_party_site_cond;
6505:
6506: /************************************************

Line 6558: FND_MSG_PUB.ADD;

6554: WHEN OTHERS THEN
6555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6558: FND_MSG_PUB.ADD;
6559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6560: END check_contact_cond;
6561:
6562: /************************************************

Line 6579: FND_MSG_PUB.ADD;

6575:
6576: FOR I IN 1..p_contact_point_list.COUNT LOOP
6577: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6578: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_ERROR;
6581: END IF;
6582: END LOOP;
6583:

Line 6605: FND_MSG_PUB.ADD;

6601: WHEN OTHERS THEN
6602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6603: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6605: FND_MSG_PUB.ADD;
6606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6607: END check_contact_point_cond;
6608:
6609: FUNCTION check_staged RETURN BOOLEAN IS