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

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

Line 1920: FND_MSG_PUB.ADD;

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

Line 1924: FND_MSG_PUB.ADD;

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

Line 1929: FND_MSG_PUB.ADD;

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

Line 2161: FND_MSG_PUB.ADD;

2157: exception
2158: when others then
2159: if (instrb(SQLERRM,'DRG-51030')>0) then
2160: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2165: FND_MSG_PUB.ADD;

Line 2165: FND_MSG_PUB.ADD;

2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2165: FND_MSG_PUB.ADD;
2166: RAISE FND_API.G_EXC_ERROR;
2167: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2169: FND_MSG_PUB.ADD;

Line 2169: FND_MSG_PUB.ADD;

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

Line 2174: FND_MSG_PUB.ADD;

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

Line 2308: FND_MSG_PUB.ADD;

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

Line 2312: FND_MSG_PUB.ADD;

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

Line 2316: FND_MSG_PUB.ADD;

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

Line 2321: FND_MSG_PUB.ADD;

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

Line 2581: FND_MSG_PUB.ADD;

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

Line 2585: FND_MSG_PUB.ADD;

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

Line 2589: FND_MSG_PUB.ADD;

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

Line 2594: FND_MSG_PUB.ADD;

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

Line 2856: FND_MSG_PUB.ADD;

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

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 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);
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: ELSE
2909: push_eval;
2910: RETURN;

Line 2979: FND_MSG_PUB.ADD;

2975: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2976: 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);
2977: END IF;
2978: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2979: FND_MSG_PUB.ADD;
2980: RAISE FND_API.G_EXC_ERROR;
2981: ELSE
2982: push_eval;
2983: RETURN;

Line 3091: FND_MSG_PUB.ADD;

3087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3088: 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);
3089: END IF;
3090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3091: FND_MSG_PUB.ADD;
3092: RAISE FND_API.G_EXC_ERROR;
3093: ELSE
3094: push_eval;
3095: RETURN;

Line 3202: FND_MSG_PUB.ADD;

3198: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3199: 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);
3200: END IF;
3201: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3202: FND_MSG_PUB.ADD;
3203: RAISE FND_API.G_EXC_ERROR;
3204: ELSE
3205: push_eval;
3206: RETURN;

Line 3427: FND_MSG_PUB.ADD;

3423: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3424: 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);
3425: END IF;
3426: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3427: FND_MSG_PUB.ADD;
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430: ELSE
3431: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3435: FND_MSG_PUB.ADD;

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

Line 3643: FND_MSG_PUB.ADD;

3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END find_parties;
3646:
3647: PROCEDURE find_persons (

Line 3845: FND_MSG_PUB.ADD;

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

Line 3895: FND_MSG_PUB.ADD;

3891: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3892: 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);
3893: END IF;
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3895: FND_MSG_PUB.ADD;
3896: RAISE FND_API.G_EXC_ERROR;
3897: ELSE
3898: push_eval;
3899: RETURN;

Line 3931: FND_MSG_PUB.ADD;

3927: exception
3928: when others then
3929: if (instrb(SQLERRM,'DRG-51030')>0) then
3930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3931: FND_MSG_PUB.ADD;
3932: RAISE FND_API.G_EXC_ERROR;
3933: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3935: FND_MSG_PUB.ADD;

Line 3935: FND_MSG_PUB.ADD;

3931: FND_MSG_PUB.ADD;
3932: RAISE FND_API.G_EXC_ERROR;
3933: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;
3937: else
3938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3939: end if;

Line 4007: FND_MSG_PUB.ADD;

4003: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4004: 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);
4005: END IF;
4006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4007: FND_MSG_PUB.ADD;
4008: RAISE FND_API.G_EXC_ERROR;
4009: ELSE
4010: push_eval;
4011: RETURN;

Line 4266: FND_MSG_PUB.ADD;

4262: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4263: 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);
4264: END IF;
4265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4266: FND_MSG_PUB.ADD;
4267: RAISE FND_API.G_EXC_ERROR;
4268: ELSE
4269: push_eval;
4270: RETURN;

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: ELSE
4383: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4387: FND_MSG_PUB.ADD;

4383: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4384: 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);
4385: END IF;
4386: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4387: FND_MSG_PUB.ADD;
4388: RAISE FND_API.G_EXC_ERROR;
4389: END IF;
4390: END IF;
4391: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4510: FND_MSG_PUB.ADD;

4506: WHEN OTHERS THEN
4507: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4508: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4510: FND_MSG_PUB.ADD;
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: END find_persons;
4513:
4514: PROCEDURE find_persons (

Line 4578: FND_MSG_PUB.ADD;

4574: WHEN OTHERS THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4576: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4578: FND_MSG_PUB.ADD;
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: END find_party_details;
4581:
4582: PROCEDURE find_duplicate_parties (

Line 4695: FND_MSG_PUB.ADD;

4691: WHEN OTHERS THEN
4692: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4693: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4694: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4695: FND_MSG_PUB.ADD;
4696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4697: END find_duplicate_parties;
4698:
4699: PROCEDURE find_duplicate_party_sites (

Line 4780: FND_MSG_PUB.ADD;

4776: WHEN OTHERS THEN
4777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4780: FND_MSG_PUB.ADD;
4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4782: END find_duplicate_party_sites;
4783:
4784: PROCEDURE find_duplicate_contacts (

Line 4869: FND_MSG_PUB.ADD;

4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END find_duplicate_contacts;
4872:
4873: PROCEDURE find_duplicate_contact_points (

Line 4942: FND_MSG_PUB.ADD;

4938: WHEN OTHERS THEN
4939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4942: FND_MSG_PUB.ADD;
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: END find_duplicate_contact_points;
4945:
4946: PROCEDURE find_parties_dynamic (

Line 5299: FND_MSG_PUB.ADD;

5295: WHEN OTHERS THEN
5296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5297: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5299: FND_MSG_PUB.ADD;
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: END call_api_dynamic;
5302:
5303:

Line 5543: FND_MSG_PUB.ADD;

5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_party_sites');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_party_sites;
5546:
5547:

Line 5771: FND_MSG_PUB.ADD;

5767: WHEN OTHERS THEN
5768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5769: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5770: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5771: FND_MSG_PUB.ADD;
5772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5773: END get_matching_contacts;
5774:
5775:

Line 5913: FND_MSG_PUB.ADD;

5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5913: FND_MSG_PUB.ADD;
5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5915: END get_matching_contact_points;
5916:
5917: /**********************************************************

Line 6154: FND_MSG_PUB.ADD;

6150: WHEN OTHERS THEN
6151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6152: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6153: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6154: FND_MSG_PUB.ADD;
6155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6156: END get_score_details;
6157:
6158:

Line 6277: FND_MSG_PUB.ADD;

6273: WHEN OTHERS THEN
6274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6275: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6277: FND_MSG_PUB.ADD;
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: END get_party_for_search;
6280:
6281: PROCEDURE get_search_criteria (

Line 6329: FND_MSG_PUB.ADD;

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

Line 6392: FND_MSG_PUB.ADD;

6388: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6390: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;
6394: END get_party_rec;
6395:
6396: /************************************************

Line 6456: FND_MSG_PUB.ADD;

6452: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6453: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6454: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6456: FND_MSG_PUB.ADD;
6457: RAISE FND_API.G_EXC_ERROR;
6458: END get_party_site_rec;
6459:
6460: /************************************************

Line 6514: FND_MSG_PUB.ADD;

6510: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6512: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6514: FND_MSG_PUB.ADD;
6515: RAISE FND_API.G_EXC_ERROR;
6516: END get_contact_rec;
6517:
6518: /************************************************

Line 6570: FND_MSG_PUB.ADD;

6566: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6568: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6570: FND_MSG_PUB.ADD;
6571: RAISE FND_API.G_EXC_ERROR;
6572: END get_contact_point_rec;
6573:
6574: /************************************************

Line 6765: FND_MSG_PUB.ADD;

6761: WHEN OTHERS THEN
6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6767: END;
6768:
6769:

Line 7004: FND_MSG_PUB.ADD;

7000: WHEN OTHERS THEN
7001: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7002: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7004: FND_MSG_PUB.ADD;
7005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7006: END;
7007:
7008:

Line 7107: FND_MSG_PUB.ADD;

7103: WHEN OTHERS THEN
7104: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7105: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7107: FND_MSG_PUB.ADD;
7108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7109: END;
7110:
7111:

Line 7238: FND_MSG_PUB.ADD;

7234: WHEN OTHERS THEN
7235: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7236: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7237: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7238: FND_MSG_PUB.ADD;
7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7240: END;
7241:
7242:

Line 7263: FND_MSG_PUB.ADD;

7259: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7260: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7261: ) THEN
7262: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7263: FND_MSG_PUB.ADD;
7264: RAISE FND_API.G_EXC_ERROR;
7265: END IF;
7266: END LOOP;
7267:

Line 7333: FND_MSG_PUB.ADD;

7329: WHEN OTHERS THEN
7330: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7331: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7332: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7333: FND_MSG_PUB.ADD;
7334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7335: END check_prim_cond;
7336:
7337: /************************************************

Line 7397: FND_MSG_PUB.ADD;

7393: WHEN OTHERS THEN
7394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7395: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7397: FND_MSG_PUB.ADD;
7398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7399: END check_party_site_cond;
7400:
7401: /************************************************

Line 7453: FND_MSG_PUB.ADD;

7449: WHEN OTHERS THEN
7450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7451: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7453: FND_MSG_PUB.ADD;
7454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7455: END check_contact_cond;
7456:
7457: /************************************************

Line 7474: FND_MSG_PUB.ADD;

7470:
7471: FOR I IN 1..p_contact_point_list.COUNT LOOP
7472: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7473: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7474: FND_MSG_PUB.ADD;
7475: RAISE FND_API.G_EXC_ERROR;
7476: END IF;
7477: END LOOP;
7478:

Line 7500: FND_MSG_PUB.ADD;

7496: WHEN OTHERS THEN
7497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7498: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7500: FND_MSG_PUB.ADD;
7501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7502: END check_contact_point_cond;
7503:
7504: FUNCTION check_staged RETURN BOOLEAN IS