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

940: WHEN OTHERS THEN
941: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
942: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
944: FND_MSG_PUB.ADD;
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END;
947:
948:

Line 969: FND_MSG_PUB.ADD;

965: WHEN OTHERS THEN
966: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
967: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: END;
972:
973:

Line 989: FND_MSG_PUB.ADD;

985: WHEN OTHERS THEN
986: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
987: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END;
992:
993:

Line 1009: FND_MSG_PUB.ADD;

1005: WHEN OTHERS THEN
1006: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END;
1012:
1013: PROCEDURE init_score_context (

Line 1076: FND_MSG_PUB.ADD;

1072: p_party_site_list,
1073: p_contact_list,
1074: p_contact_point_list) THEN
1075: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1076: FND_MSG_PUB.ADD;
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1080: 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 1294: FND_MSG_PUB.ADD;

1290: END IF;
1291: IF lengthb(l_party_contains_str) > 4000 THEN
1292: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1293: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1294: FND_MSG_PUB.ADD;
1295: RAISE FND_API.G_EXC_ERROR;
1296: END IF;
1297: IF (p_match_str = ' AND ' OR p_party_max_score 1298: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1373: FND_MSG_PUB.ADD;

1369: -- Add the search criteria to query string
1370: IF lengthb(l_contains_str) > 4000 THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1372: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1373: FND_MSG_PUB.ADD;
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376: x_denorm_str := l_den_contains_str;
1377: RETURN l_contains_str;

Line 1420: FND_MSG_PUB.ADD;

1416: -- Add the search criteria to query string
1417: IF lengthb(l_contains_str) > 4000 THEN
1418: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1419: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1420: FND_MSG_PUB.ADD;
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423: x_denorm_str := l_den_contains_str;
1424: RETURN l_contains_str;

Line 1465: FND_MSG_PUB.ADD;

1461: -- Add the search criteria to query string
1462: IF lengthb(l_contains_str) > 4000 THEN
1463: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1464: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1465: FND_MSG_PUB.ADD;
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468: x_denorm_str := l_den_contains_str;
1469: RETURN l_contains_str;

Line 1690: FND_MSG_PUB.ADD;

1686: exception
1687: when others then
1688: if (instrb(SQLERRM,'DRG-51030')>0) then
1689: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1690: FND_MSG_PUB.ADD;
1691: RAISE FND_API.G_EXC_ERROR;
1692: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1694: FND_MSG_PUB.ADD;

Line 1694: FND_MSG_PUB.ADD;

1690: FND_MSG_PUB.ADD;
1691: RAISE FND_API.G_EXC_ERROR;
1692: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1694: FND_MSG_PUB.ADD;
1695: RAISE FND_API.G_EXC_ERROR;
1696: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1698: FND_MSG_PUB.ADD;

Line 1698: FND_MSG_PUB.ADD;

1694: FND_MSG_PUB.ADD;
1695: RAISE FND_API.G_EXC_ERROR;
1696: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1698: FND_MSG_PUB.ADD;
1699: RAISE FND_API.G_EXC_ERROR;
1700: else
1701: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1702: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1703: FND_MSG_PUB.ADD;

1699: RAISE FND_API.G_EXC_ERROR;
1700: else
1701: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1702: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1703: FND_MSG_PUB.ADD;
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: end if;
1706: END;
1707:

Line 1935: FND_MSG_PUB.ADD;

1931: exception
1932: when others then
1933: if (instrb(SQLERRM,'DRG-51030')>0) then
1934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1935: FND_MSG_PUB.ADD;
1936: RAISE FND_API.G_EXC_ERROR;
1937: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1938: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1939: FND_MSG_PUB.ADD;

Line 1939: FND_MSG_PUB.ADD;

1935: FND_MSG_PUB.ADD;
1936: RAISE FND_API.G_EXC_ERROR;
1937: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1938: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1939: FND_MSG_PUB.ADD;
1940: RAISE FND_API.G_EXC_ERROR;
1941: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1943: FND_MSG_PUB.ADD;

Line 1943: FND_MSG_PUB.ADD;

1939: FND_MSG_PUB.ADD;
1940: RAISE FND_API.G_EXC_ERROR;
1941: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1943: FND_MSG_PUB.ADD;
1944: RAISE FND_API.G_EXC_ERROR;
1945: else
1946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1948: FND_MSG_PUB.ADD;

1944: RAISE FND_API.G_EXC_ERROR;
1945: else
1946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1948: FND_MSG_PUB.ADD;
1949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1950: end if;
1951: END;
1952:

Line 2082: FND_MSG_PUB.ADD;

2078: exception
2079: when others then
2080: if (instrb(SQLERRM,'DRG-51030')>0) then
2081: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2082: FND_MSG_PUB.ADD;
2083: RAISE FND_API.G_EXC_ERROR;
2084: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2086: FND_MSG_PUB.ADD;

Line 2086: FND_MSG_PUB.ADD;

2082: FND_MSG_PUB.ADD;
2083: RAISE FND_API.G_EXC_ERROR;
2084: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2086: FND_MSG_PUB.ADD;
2087: RAISE FND_API.G_EXC_ERROR;
2088: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2090: FND_MSG_PUB.ADD;

Line 2090: FND_MSG_PUB.ADD;

2086: FND_MSG_PUB.ADD;
2087: RAISE FND_API.G_EXC_ERROR;
2088: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2090: FND_MSG_PUB.ADD;
2091: RAISE FND_API.G_EXC_ERROR;
2092: else
2093: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2094: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2095: FND_MSG_PUB.ADD;

2091: RAISE FND_API.G_EXC_ERROR;
2092: else
2093: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2094: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2095: FND_MSG_PUB.ADD;
2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: end if;
2098: END;
2099:

Line 2355: FND_MSG_PUB.ADD;

2351: exception
2352: when others then
2353: if (instrb(SQLERRM,'DRG-51030')>0) then
2354: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2355: FND_MSG_PUB.ADD;
2356: RAISE FND_API.G_EXC_ERROR;
2357: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2358: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2359: FND_MSG_PUB.ADD;

Line 2359: FND_MSG_PUB.ADD;

2355: FND_MSG_PUB.ADD;
2356: RAISE FND_API.G_EXC_ERROR;
2357: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2358: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2359: FND_MSG_PUB.ADD;
2360: RAISE FND_API.G_EXC_ERROR;
2361: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2363: FND_MSG_PUB.ADD;

Line 2363: FND_MSG_PUB.ADD;

2359: FND_MSG_PUB.ADD;
2360: RAISE FND_API.G_EXC_ERROR;
2361: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2363: FND_MSG_PUB.ADD;
2364: RAISE FND_API.G_EXC_ERROR;
2365: else
2366: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2367: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2368: FND_MSG_PUB.ADD;

2364: RAISE FND_API.G_EXC_ERROR;
2365: else
2366: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2367: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2368: FND_MSG_PUB.ADD;
2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2370: end if;
2371: END;
2372:

Line 2628: FND_MSG_PUB.ADD;

2624: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2625: 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);
2626: END IF;
2627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2628: FND_MSG_PUB.ADD;
2629: RAISE FND_API.G_EXC_ERROR;
2630: ELSE
2631: push_eval;
2632: RETURN;

Line 2676: FND_MSG_PUB.ADD;

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

Line 2749: FND_MSG_PUB.ADD;

2745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2746: 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);
2747: END IF;
2748: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2749: FND_MSG_PUB.ADD;
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSE
2752: push_eval;
2753: RETURN;

Line 2861: FND_MSG_PUB.ADD;

2857: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2858: 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);
2859: END IF;
2860: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2861: FND_MSG_PUB.ADD;
2862: RAISE FND_API.G_EXC_ERROR;
2863: ELSE
2864: push_eval;
2865: RETURN;

Line 2972: FND_MSG_PUB.ADD;

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

Line 3116: FND_MSG_PUB.ADD;

3112: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3113: 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);
3114: END IF;
3115: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3116: FND_MSG_PUB.ADD;
3117: RAISE FND_API.G_EXC_ERROR;
3118: END IF;
3119: ELSE
3120: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3124: FND_MSG_PUB.ADD;

3120: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3121: 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);
3122: END IF;
3123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3124: FND_MSG_PUB.ADD;
3125: RAISE FND_API.G_EXC_ERROR;
3126: END IF;
3127: END IF;
3128: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3375: FND_MSG_PUB.ADD;

3371: WHEN OTHERS THEN
3372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3373: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_parties');
3374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3375: FND_MSG_PUB.ADD;
3376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3377: END find_parties;
3378:
3379: PROCEDURE find_persons (

Line 3575: FND_MSG_PUB.ADD;

3571: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3572: 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);
3573: END IF;
3574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3575: FND_MSG_PUB.ADD;
3576: RAISE FND_API.G_EXC_ERROR;
3577: ELSE
3578: push_eval;
3579: RETURN;

Line 3623: FND_MSG_PUB.ADD;

3619: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3620: 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);
3621: END IF;
3622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3623: FND_MSG_PUB.ADD;
3624: RAISE FND_API.G_EXC_ERROR;
3625: ELSE
3626: push_eval;
3627: RETURN;

Line 3659: FND_MSG_PUB.ADD;

3655: exception
3656: when others then
3657: if (instrb(SQLERRM,'DRG-51030')>0) then
3658: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3659: FND_MSG_PUB.ADD;
3660: RAISE FND_API.G_EXC_ERROR;
3661: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3663: FND_MSG_PUB.ADD;

Line 3663: FND_MSG_PUB.ADD;

3659: FND_MSG_PUB.ADD;
3660: RAISE FND_API.G_EXC_ERROR;
3661: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3663: FND_MSG_PUB.ADD;
3664: RAISE FND_API.G_EXC_ERROR;
3665: else
3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3667: end if;

Line 3735: FND_MSG_PUB.ADD;

3731: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3732: 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);
3733: END IF;
3734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3735: FND_MSG_PUB.ADD;
3736: RAISE FND_API.G_EXC_ERROR;
3737: ELSE
3738: push_eval;
3739: RETURN;

Line 3924: FND_MSG_PUB.ADD;

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

Line 4012: FND_MSG_PUB.ADD;

4008: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4009: 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);
4010: END IF;
4011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4012: FND_MSG_PUB.ADD;
4013: RAISE FND_API.G_EXC_ERROR;
4014: END IF;
4015: ELSE
4016: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4020: FND_MSG_PUB.ADD;

4016: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4017: 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);
4018: END IF;
4019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4020: FND_MSG_PUB.ADD;
4021: RAISE FND_API.G_EXC_ERROR;
4022: END IF;
4023: END IF;
4024: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4169: FND_MSG_PUB.ADD;

4165: WHEN OTHERS THEN
4166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4169: FND_MSG_PUB.ADD;
4170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4171: END find_persons;
4172:
4173: PROCEDURE find_persons (

Line 4237: FND_MSG_PUB.ADD;

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

Line 4354: FND_MSG_PUB.ADD;

4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: END find_duplicate_parties;
4357:
4358: PROCEDURE find_duplicate_party_sites (

Line 4439: FND_MSG_PUB.ADD;

4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4439: FND_MSG_PUB.ADD;
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: END find_duplicate_party_sites;
4442:
4443: PROCEDURE find_duplicate_contacts (

Line 4528: FND_MSG_PUB.ADD;

4524: WHEN OTHERS THEN
4525: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4526: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4528: FND_MSG_PUB.ADD;
4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4530: END find_duplicate_contacts;
4531:
4532: PROCEDURE find_duplicate_contact_points (

Line 4601: FND_MSG_PUB.ADD;

4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4601: FND_MSG_PUB.ADD;
4602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4603: END find_duplicate_contact_points;
4604:
4605: PROCEDURE find_parties_dynamic (

Line 4944: FND_MSG_PUB.ADD;

4940: WHEN OTHERS THEN
4941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4942: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4944: FND_MSG_PUB.ADD;
4945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4946: END call_api_dynamic;
4947:
4948:

Line 5191: FND_MSG_PUB.ADD;

5187: WHEN OTHERS THEN
5188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5189: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5191: FND_MSG_PUB.ADD;
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: END get_matching_party_sites;
5194:
5195:

Line 5420: FND_MSG_PUB.ADD;

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

Line 5562: FND_MSG_PUB.ADD;

5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5561: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5564: END get_matching_contact_points;
5565:
5566: /**********************************************************

Line 5800: FND_MSG_PUB.ADD;

5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5802: END get_score_details;
5803:
5804:

Line 5923: FND_MSG_PUB.ADD;

5919: WHEN OTHERS THEN
5920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5921: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5923: FND_MSG_PUB.ADD;
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: END get_party_for_search;
5926:
5927: PROCEDURE get_search_criteria (

Line 5975: FND_MSG_PUB.ADD;

5971: WHEN OTHERS THEN
5972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5973: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5975: FND_MSG_PUB.ADD;
5976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5977: END get_search_criteria;
5978:
5979:

Line 6020: FND_MSG_PUB.ADD;

6016: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6017: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6018: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6020: FND_MSG_PUB.ADD;
6021: RAISE FND_API.G_EXC_ERROR;
6022: END get_party_rec;
6023:
6024: /************************************************

Line 6086: FND_MSG_PUB.ADD;

6082: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6083: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6084: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;
6087: RAISE FND_API.G_EXC_ERROR;
6088: END get_party_site_rec;
6089:
6090: /************************************************

Line 6144: FND_MSG_PUB.ADD;

6140: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6142: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_ERROR;
6146: END get_contact_rec;
6147:
6148: /************************************************

Line 6200: FND_MSG_PUB.ADD;

6196: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6197: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6198: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_ERROR;
6202: END get_contact_point_rec;
6203:
6204: /************************************************

Line 6296: FND_MSG_PUB.ADD;

6292: WHEN OTHERS THEN
6293: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6294: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6295: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6296: FND_MSG_PUB.ADD;
6297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6298: END;
6299:
6300:

Line 6566: FND_MSG_PUB.ADD;

6562: WHEN OTHERS THEN
6563: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6564: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6566: FND_MSG_PUB.ADD;
6567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6568: END;
6569:
6570:

Line 6623: FND_MSG_PUB.ADD;

6619: WHEN OTHERS THEN
6620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6621: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6623: FND_MSG_PUB.ADD;
6624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6625: END;
6626:
6627:

Line 6730: FND_MSG_PUB.ADD;

6726: WHEN OTHERS THEN
6727: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6728: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6730: FND_MSG_PUB.ADD;
6731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6732: END;
6733:
6734:

Line 6754: FND_MSG_PUB.ADD;

6750: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6751: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6752: ) THEN
6753: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_ERROR;
6756: END IF;
6757: END LOOP;
6758:

Line 6795: FND_MSG_PUB.ADD;

6791: WHEN OTHERS THEN
6792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6793: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6795: FND_MSG_PUB.ADD;
6796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6797: END check_prim_cond;
6798:
6799: /************************************************

Line 6856: FND_MSG_PUB.ADD;

6852: WHEN OTHERS THEN
6853: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6854: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6855: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6856: FND_MSG_PUB.ADD;
6857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6858: END check_party_site_cond;
6859:
6860: /************************************************

Line 6911: FND_MSG_PUB.ADD;

6907: WHEN OTHERS THEN
6908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6909: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6911: FND_MSG_PUB.ADD;
6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6913: END check_contact_cond;
6914:
6915: /************************************************

Line 6932: FND_MSG_PUB.ADD;

6928:
6929: FOR I IN 1..p_contact_point_list.COUNT LOOP
6930: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6931: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6932: FND_MSG_PUB.ADD;
6933: RAISE FND_API.G_EXC_ERROR;
6934: END IF;
6935: END LOOP;
6936:

Line 6957: FND_MSG_PUB.ADD;

6953: WHEN OTHERS THEN
6954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6955: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6956: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6957: FND_MSG_PUB.ADD;
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6959: END check_contact_point_cond;
6960:
6961: FUNCTION check_staged RETURN BOOLEAN IS