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

1016: WHEN OTHERS THEN
1017: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1018: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END;
1023:
1024:

Line 1045: FND_MSG_PUB.ADD;

1041: WHEN OTHERS THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1043: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1045: FND_MSG_PUB.ADD;
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END;
1048:
1049:

Line 1065: FND_MSG_PUB.ADD;

1061: WHEN OTHERS THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1063: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1065: FND_MSG_PUB.ADD;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END;
1068:
1069:

Line 1085: FND_MSG_PUB.ADD;

1081: WHEN OTHERS THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1083: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1085: FND_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END;
1088:
1089: PROCEDURE init_score_context (

Line 1152: FND_MSG_PUB.ADD;

1148: p_party_site_list,
1149: p_contact_list,
1150: p_contact_point_list) THEN
1151: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: 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 1421: FND_MSG_PUB.ADD;

1417: END IF;
1418: IF lengthb(l_party_contains_str) > 4000 THEN
1419: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1420: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1421: FND_MSG_PUB.ADD;
1422: RAISE FND_API.G_EXC_ERROR;
1423: END IF;
1424: IF (p_match_str = ' AND ' OR p_party_max_score 1425: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1527: FND_MSG_PUB.ADD;

1523: -- Add the search criteria to query string
1524: IF lengthb(l_contains_str) > 4000 THEN
1525: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1526: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1527: FND_MSG_PUB.ADD;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530: x_denorm_str := l_den_contains_str;
1531: RETURN l_contains_str;

Line 1573: FND_MSG_PUB.ADD;

1569: -- Add the search criteria to query string
1570: IF lengthb(l_contains_str) > 4000 THEN
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1572: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;
1576: x_denorm_str := l_den_contains_str;
1577: RETURN l_contains_str;

Line 1654: FND_MSG_PUB.ADD;

1650: -- Add the search criteria to query string
1651: IF lengthb(l_contains_str) > 4000 THEN
1652: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1653: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_ERROR;
1656: END IF;
1657: x_denorm_str := l_den_contains_str;
1658: RETURN l_contains_str;

Line 1914: FND_MSG_PUB.ADD;

1910: exception
1911: when others then
1912: if (instrb(SQLERRM,'DRG-51030')>0) then
1913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1914: FND_MSG_PUB.ADD;
1915: RAISE FND_API.G_EXC_ERROR;
1916: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1917: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1918: FND_MSG_PUB.ADD;

Line 1918: FND_MSG_PUB.ADD;

1914: FND_MSG_PUB.ADD;
1915: RAISE FND_API.G_EXC_ERROR;
1916: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1917: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1918: FND_MSG_PUB.ADD;
1919: RAISE FND_API.G_EXC_ERROR;
1920: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1922: FND_MSG_PUB.ADD;

Line 1922: FND_MSG_PUB.ADD;

1918: FND_MSG_PUB.ADD;
1919: RAISE FND_API.G_EXC_ERROR;
1920: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1922: FND_MSG_PUB.ADD;
1923: RAISE FND_API.G_EXC_ERROR;
1924: else
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1927: FND_MSG_PUB.ADD;

1923: RAISE FND_API.G_EXC_ERROR;
1924: else
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: end if;
1930: END;
1931:

Line 2159: FND_MSG_PUB.ADD;

2155: exception
2156: when others then
2157: if (instrb(SQLERRM,'DRG-51030')>0) then
2158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2159: FND_MSG_PUB.ADD;
2160: RAISE FND_API.G_EXC_ERROR;
2161: elsif (instrb(SQLERRM,'DRG-50943')>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,'DRG-50943')>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: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2167: FND_MSG_PUB.ADD;

Line 2167: FND_MSG_PUB.ADD;

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

Line 2172: FND_MSG_PUB.ADD;

2168: RAISE FND_API.G_EXC_ERROR;
2169: else
2170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2172: FND_MSG_PUB.ADD;
2173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2174: end if;
2175: END;
2176:

Line 2306: FND_MSG_PUB.ADD;

2302: exception
2303: when others then
2304: if (instrb(SQLERRM,'DRG-51030')>0) then
2305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2309: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2310: FND_MSG_PUB.ADD;

Line 2310: FND_MSG_PUB.ADD;

2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2309: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2310: FND_MSG_PUB.ADD;
2311: RAISE FND_API.G_EXC_ERROR;
2312: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2314: FND_MSG_PUB.ADD;

Line 2314: FND_MSG_PUB.ADD;

2310: FND_MSG_PUB.ADD;
2311: RAISE FND_API.G_EXC_ERROR;
2312: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2314: FND_MSG_PUB.ADD;
2315: RAISE FND_API.G_EXC_ERROR;
2316: else
2317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2319: FND_MSG_PUB.ADD;

2315: RAISE FND_API.G_EXC_ERROR;
2316: else
2317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2319: FND_MSG_PUB.ADD;
2320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2321: end if;
2322: END;
2323:

Line 2579: FND_MSG_PUB.ADD;

2575: exception
2576: when others then
2577: if (instrb(SQLERRM,'DRG-51030')>0) then
2578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2579: FND_MSG_PUB.ADD;
2580: RAISE FND_API.G_EXC_ERROR;
2581: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2583: FND_MSG_PUB.ADD;

Line 2583: FND_MSG_PUB.ADD;

2579: FND_MSG_PUB.ADD;
2580: RAISE FND_API.G_EXC_ERROR;
2581: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2586: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2587: FND_MSG_PUB.ADD;

Line 2587: FND_MSG_PUB.ADD;

2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2586: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2587: FND_MSG_PUB.ADD;
2588: RAISE FND_API.G_EXC_ERROR;
2589: else
2590: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2592: FND_MSG_PUB.ADD;

2588: RAISE FND_API.G_EXC_ERROR;
2589: else
2590: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2592: FND_MSG_PUB.ADD;
2593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2594: end if;
2595: END;
2596:

Line 2853: FND_MSG_PUB.ADD;

2849: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2850: 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);
2851: END IF;
2852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2853: FND_MSG_PUB.ADD;
2854: RAISE FND_API.G_EXC_ERROR;
2855: ELSE
2856: push_eval;
2857: RETURN;

Line 2901: FND_MSG_PUB.ADD;

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

Line 2974: FND_MSG_PUB.ADD;

2970: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2971: 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);
2972: END IF;
2973: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: ELSE
2977: push_eval;
2978: RETURN;

Line 3086: FND_MSG_PUB.ADD;

3082: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3083: 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);
3084: END IF;
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3086: FND_MSG_PUB.ADD;
3087: RAISE FND_API.G_EXC_ERROR;
3088: ELSE
3089: push_eval;
3090: RETURN;

Line 3197: FND_MSG_PUB.ADD;

3193: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3194: 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);
3195: END IF;
3196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: ELSE
3200: push_eval;
3201: RETURN;

Line 3422: FND_MSG_PUB.ADD;

3418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3419: 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);
3420: END IF;
3421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3422: FND_MSG_PUB.ADD;
3423: RAISE FND_API.G_EXC_ERROR;
3424: END IF;
3425: ELSE
3426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3430: FND_MSG_PUB.ADD;

3426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3427: 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);
3428: END IF;
3429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3430: FND_MSG_PUB.ADD;
3431: RAISE FND_API.G_EXC_ERROR;
3432: END IF;
3433: END IF;
3434: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3638: FND_MSG_PUB.ADD;

3634: WHEN OTHERS THEN
3635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3636: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3638: FND_MSG_PUB.ADD;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3640: END find_parties;
3641:
3642: PROCEDURE find_persons (

Line 3839: FND_MSG_PUB.ADD;

3835: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3836: 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);
3837: END IF;
3838: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3839: FND_MSG_PUB.ADD;
3840: RAISE FND_API.G_EXC_ERROR;
3841: ELSE
3842: push_eval;
3843: RETURN;

Line 3887: FND_MSG_PUB.ADD;

3883: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3884: 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);
3885: END IF;
3886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3887: FND_MSG_PUB.ADD;
3888: RAISE FND_API.G_EXC_ERROR;
3889: ELSE
3890: push_eval;
3891: RETURN;

Line 3923: FND_MSG_PUB.ADD;

3919: exception
3920: when others then
3921: if (instrb(SQLERRM,'DRG-51030')>0) then
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3923: FND_MSG_PUB.ADD;
3924: RAISE FND_API.G_EXC_ERROR;
3925: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3927: FND_MSG_PUB.ADD;

Line 3927: FND_MSG_PUB.ADD;

3923: FND_MSG_PUB.ADD;
3924: RAISE FND_API.G_EXC_ERROR;
3925: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_ERROR;
3929: else
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: end if;

Line 3999: FND_MSG_PUB.ADD;

3995: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3996: 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);
3997: END IF;
3998: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3999: FND_MSG_PUB.ADD;
4000: RAISE FND_API.G_EXC_ERROR;
4001: ELSE
4002: push_eval;
4003: RETURN;

Line 4258: FND_MSG_PUB.ADD;

4254: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4255: 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);
4256: END IF;
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4258: FND_MSG_PUB.ADD;
4259: RAISE FND_API.G_EXC_ERROR;
4260: ELSE
4261: push_eval;
4262: RETURN;

Line 4371: FND_MSG_PUB.ADD;

4367: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4368: 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);
4369: END IF;
4370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4371: FND_MSG_PUB.ADD;
4372: RAISE FND_API.G_EXC_ERROR;
4373: END IF;
4374: ELSE
4375: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4379: FND_MSG_PUB.ADD;

4375: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4376: 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);
4377: END IF;
4378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4379: FND_MSG_PUB.ADD;
4380: RAISE FND_API.G_EXC_ERROR;
4381: END IF;
4382: END IF;
4383: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4502: FND_MSG_PUB.ADD;

4498: WHEN OTHERS THEN
4499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4500: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4502: FND_MSG_PUB.ADD;
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: END find_persons;
4505:
4506: PROCEDURE find_persons (

Line 4570: FND_MSG_PUB.ADD;

4566: WHEN OTHERS THEN
4567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4568: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4570: FND_MSG_PUB.ADD;
4571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4572: END find_party_details;
4573:
4574: PROCEDURE find_duplicate_parties (

Line 4687: FND_MSG_PUB.ADD;

4683: WHEN OTHERS THEN
4684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4685: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4686: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4687: FND_MSG_PUB.ADD;
4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4689: END find_duplicate_parties;
4690:
4691: PROCEDURE find_duplicate_party_sites (

Line 4772: FND_MSG_PUB.ADD;

4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4774: END find_duplicate_party_sites;
4775:
4776: PROCEDURE find_duplicate_contacts (

Line 4861: FND_MSG_PUB.ADD;

4857: WHEN OTHERS THEN
4858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4859: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4861: FND_MSG_PUB.ADD;
4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4863: END find_duplicate_contacts;
4864:
4865: PROCEDURE find_duplicate_contact_points (

Line 4934: FND_MSG_PUB.ADD;

4930: WHEN OTHERS THEN
4931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4934: FND_MSG_PUB.ADD;
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4936: END find_duplicate_contact_points;
4937:
4938: PROCEDURE find_parties_dynamic (

Line 5291: FND_MSG_PUB.ADD;

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

Line 5535: FND_MSG_PUB.ADD;

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

Line 5763: FND_MSG_PUB.ADD;

5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: END get_matching_contacts;
5766:
5767:

Line 5905: FND_MSG_PUB.ADD;

5901: WHEN OTHERS THEN
5902: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5903: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5904: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: END get_matching_contact_points;
5908:
5909: /**********************************************************

Line 6143: FND_MSG_PUB.ADD;

6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;
6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6145: END get_score_details;
6146:
6147:

Line 6266: FND_MSG_PUB.ADD;

6262: WHEN OTHERS THEN
6263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6264: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6266: FND_MSG_PUB.ADD;
6267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6268: END get_party_for_search;
6269:
6270: PROCEDURE get_search_criteria (

Line 6318: FND_MSG_PUB.ADD;

6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6320: END get_search_criteria;
6321:
6322:

Line 6381: FND_MSG_PUB.ADD;

6377: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6378: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6379: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6381: FND_MSG_PUB.ADD;
6382: RAISE FND_API.G_EXC_ERROR;
6383: END get_party_rec;
6384:
6385: /************************************************

Line 6445: FND_MSG_PUB.ADD;

6441: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6442: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6443: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6445: FND_MSG_PUB.ADD;
6446: RAISE FND_API.G_EXC_ERROR;
6447: END get_party_site_rec;
6448:
6449: /************************************************

Line 6503: FND_MSG_PUB.ADD;

6499: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6501: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6503: FND_MSG_PUB.ADD;
6504: RAISE FND_API.G_EXC_ERROR;
6505: END get_contact_rec;
6506:
6507: /************************************************

Line 6559: FND_MSG_PUB.ADD;

6555: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6557: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6559: FND_MSG_PUB.ADD;
6560: RAISE FND_API.G_EXC_ERROR;
6561: END get_contact_point_rec;
6562:
6563: /************************************************

Line 6754: FND_MSG_PUB.ADD;

6750: WHEN OTHERS THEN
6751: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6752: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6753: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6756: END;
6757:
6758:

Line 6993: FND_MSG_PUB.ADD;

6989: WHEN OTHERS THEN
6990: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6991: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6993: FND_MSG_PUB.ADD;
6994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6995: END;
6996:
6997:

Line 7096: FND_MSG_PUB.ADD;

7092: WHEN OTHERS THEN
7093: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7094: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7096: FND_MSG_PUB.ADD;
7097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7098: END;
7099:
7100:

Line 7227: FND_MSG_PUB.ADD;

7223: WHEN OTHERS THEN
7224: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7225: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7226: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7227: FND_MSG_PUB.ADD;
7228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7229: END;
7230:
7231:

Line 7252: FND_MSG_PUB.ADD;

7248: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7249: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7250: ) THEN
7251: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7252: FND_MSG_PUB.ADD;
7253: RAISE FND_API.G_EXC_ERROR;
7254: END IF;
7255: END LOOP;
7256:

Line 7322: FND_MSG_PUB.ADD;

7318: WHEN OTHERS THEN
7319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7320: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7322: FND_MSG_PUB.ADD;
7323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7324: END check_prim_cond;
7325:
7326: /************************************************

Line 7386: FND_MSG_PUB.ADD;

7382: WHEN OTHERS THEN
7383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7384: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7386: FND_MSG_PUB.ADD;
7387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7388: END check_party_site_cond;
7389:
7390: /************************************************

Line 7442: FND_MSG_PUB.ADD;

7438: WHEN OTHERS THEN
7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7444: END check_contact_cond;
7445:
7446: /************************************************

Line 7463: FND_MSG_PUB.ADD;

7459:
7460: FOR I IN 1..p_contact_point_list.COUNT LOOP
7461: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7462: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7463: FND_MSG_PUB.ADD;
7464: RAISE FND_API.G_EXC_ERROR;
7465: END IF;
7466: END LOOP;
7467:

Line 7489: FND_MSG_PUB.ADD;

7485: WHEN OTHERS THEN
7486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7487: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7489: FND_MSG_PUB.ADD;
7490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7491: END check_contact_point_cond;
7492:
7493: FUNCTION check_staged RETURN BOOLEAN IS