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

870: WHEN OTHERS THEN
871: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
872: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
876: END;
877:
878:

Line 894: FND_MSG_PUB.ADD;

890: WHEN OTHERS THEN
891: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
892: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END;
897:
898:

Line 914: FND_MSG_PUB.ADD;

910: WHEN OTHERS THEN
911: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
912: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
914: FND_MSG_PUB.ADD;
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END;
917:
918:

Line 934: FND_MSG_PUB.ADD;

930: WHEN OTHERS THEN
931: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
932: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
936: END;
937:
938: PROCEDURE init_score_context (

Line 1001: FND_MSG_PUB.ADD;

997: p_party_site_list,
998: p_contact_list,
999: p_contact_point_list) THEN
1000: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1001: FND_MSG_PUB.ADD;
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1005: 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 1242: FND_MSG_PUB.ADD;

1238: END IF;
1239: IF lengthb(l_party_contains_str) > 4000 THEN
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1242: FND_MSG_PUB.ADD;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245: IF (p_match_str = ' AND ' OR p_party_max_score 1246: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1331: FND_MSG_PUB.ADD;

1327: -- Add the search criteria to query string
1328: IF lengthb(l_contains_str) > 4000 THEN
1329: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1330: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1331: FND_MSG_PUB.ADD;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334: x_denorm_str := l_den_contains_str;
1335: RETURN l_contains_str;

Line 1375: FND_MSG_PUB.ADD;

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

Line 1463: FND_MSG_PUB.ADD;

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

Line 1704: FND_MSG_PUB.ADD;

1700: exception
1701: when others then
1702: if (instrb(SQLERRM,'DRG-51030')>0) then
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1704: FND_MSG_PUB.ADD;
1705: RAISE FND_API.G_EXC_ERROR;
1706: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1707: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1708: FND_MSG_PUB.ADD;

Line 1708: FND_MSG_PUB.ADD;

1704: FND_MSG_PUB.ADD;
1705: RAISE FND_API.G_EXC_ERROR;
1706: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1707: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1708: FND_MSG_PUB.ADD;
1709: RAISE FND_API.G_EXC_ERROR;
1710: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1712: FND_MSG_PUB.ADD;

Line 1712: FND_MSG_PUB.ADD;

1708: FND_MSG_PUB.ADD;
1709: RAISE FND_API.G_EXC_ERROR;
1710: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1712: FND_MSG_PUB.ADD;
1713: RAISE FND_API.G_EXC_ERROR;
1714: else
1715: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1717: FND_MSG_PUB.ADD;

1713: RAISE FND_API.G_EXC_ERROR;
1714: else
1715: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1717: FND_MSG_PUB.ADD;
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: end if;
1720: END;
1721:

Line 1949: FND_MSG_PUB.ADD;

1945: exception
1946: when others then
1947: if (instrb(SQLERRM,'DRG-51030')>0) then
1948: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1949: FND_MSG_PUB.ADD;
1950: RAISE FND_API.G_EXC_ERROR;
1951: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1953: FND_MSG_PUB.ADD;

Line 1953: FND_MSG_PUB.ADD;

1949: FND_MSG_PUB.ADD;
1950: RAISE FND_API.G_EXC_ERROR;
1951: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1953: FND_MSG_PUB.ADD;
1954: RAISE FND_API.G_EXC_ERROR;
1955: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1957: FND_MSG_PUB.ADD;

Line 1957: FND_MSG_PUB.ADD;

1953: FND_MSG_PUB.ADD;
1954: RAISE FND_API.G_EXC_ERROR;
1955: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1957: FND_MSG_PUB.ADD;
1958: RAISE FND_API.G_EXC_ERROR;
1959: else
1960: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1962: FND_MSG_PUB.ADD;

1958: RAISE FND_API.G_EXC_ERROR;
1959: else
1960: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1962: FND_MSG_PUB.ADD;
1963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1964: end if;
1965: END;
1966:

Line 2096: FND_MSG_PUB.ADD;

2092: exception
2093: when others then
2094: if (instrb(SQLERRM,'DRG-51030')>0) then
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2096: FND_MSG_PUB.ADD;
2097: RAISE FND_API.G_EXC_ERROR;
2098: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2100: FND_MSG_PUB.ADD;

Line 2100: FND_MSG_PUB.ADD;

2096: FND_MSG_PUB.ADD;
2097: RAISE FND_API.G_EXC_ERROR;
2098: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2100: FND_MSG_PUB.ADD;
2101: RAISE FND_API.G_EXC_ERROR;
2102: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2104: FND_MSG_PUB.ADD;

Line 2104: FND_MSG_PUB.ADD;

2100: FND_MSG_PUB.ADD;
2101: RAISE FND_API.G_EXC_ERROR;
2102: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2104: FND_MSG_PUB.ADD;
2105: RAISE FND_API.G_EXC_ERROR;
2106: else
2107: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2108: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2109: FND_MSG_PUB.ADD;

2105: RAISE FND_API.G_EXC_ERROR;
2106: else
2107: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2108: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2109: FND_MSG_PUB.ADD;
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: end if;
2112: END;
2113:

Line 2369: FND_MSG_PUB.ADD;

2365: exception
2366: when others then
2367: if (instrb(SQLERRM,'DRG-51030')>0) then
2368: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2369: FND_MSG_PUB.ADD;
2370: RAISE FND_API.G_EXC_ERROR;
2371: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2373: FND_MSG_PUB.ADD;

Line 2373: FND_MSG_PUB.ADD;

2369: FND_MSG_PUB.ADD;
2370: RAISE FND_API.G_EXC_ERROR;
2371: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2373: FND_MSG_PUB.ADD;
2374: RAISE FND_API.G_EXC_ERROR;
2375: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2377: FND_MSG_PUB.ADD;

Line 2377: FND_MSG_PUB.ADD;

2373: FND_MSG_PUB.ADD;
2374: RAISE FND_API.G_EXC_ERROR;
2375: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2377: FND_MSG_PUB.ADD;
2378: RAISE FND_API.G_EXC_ERROR;
2379: else
2380: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2381: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2382: FND_MSG_PUB.ADD;

2378: RAISE FND_API.G_EXC_ERROR;
2379: else
2380: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2381: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2382: FND_MSG_PUB.ADD;
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2384: end if;
2385: END;
2386:

Line 2640: FND_MSG_PUB.ADD;

2636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2637: 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);
2638: END IF;
2639: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2640: FND_MSG_PUB.ADD;
2641: RAISE FND_API.G_EXC_ERROR;
2642: ELSE
2643: push_eval;
2644: RETURN;

Line 2688: FND_MSG_PUB.ADD;

2684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2685: 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);
2686: END IF;
2687: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2688: FND_MSG_PUB.ADD;
2689: RAISE FND_API.G_EXC_ERROR;
2690: ELSE
2691: push_eval;
2692: RETURN;

Line 2761: FND_MSG_PUB.ADD;

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

Line 2873: FND_MSG_PUB.ADD;

2869: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2870: 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);
2871: END IF;
2872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2873: FND_MSG_PUB.ADD;
2874: RAISE FND_API.G_EXC_ERROR;
2875: ELSE
2876: push_eval;
2877: RETURN;

Line 2984: FND_MSG_PUB.ADD;

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

Line 3209: FND_MSG_PUB.ADD;

3205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3206: 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);
3207: END IF;
3208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3209: FND_MSG_PUB.ADD;
3210: RAISE FND_API.G_EXC_ERROR;
3211: END IF;
3212: ELSE
3213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3217: FND_MSG_PUB.ADD;

3213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3214: 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);
3215: END IF;
3216: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3217: FND_MSG_PUB.ADD;
3218: RAISE FND_API.G_EXC_ERROR;
3219: END IF;
3220: END IF;
3221: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3425: FND_MSG_PUB.ADD;

3421: WHEN OTHERS THEN
3422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_parties');
3424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3425: FND_MSG_PUB.ADD;
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: END find_parties;
3428:
3429: PROCEDURE find_persons (

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

3667: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3668: 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);
3669: END IF;
3670: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3671: FND_MSG_PUB.ADD;
3672: RAISE FND_API.G_EXC_ERROR;
3673: ELSE
3674: push_eval;
3675: RETURN;

Line 3707: FND_MSG_PUB.ADD;

3703: exception
3704: when others then
3705: if (instrb(SQLERRM,'DRG-51030')>0) then
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3707: FND_MSG_PUB.ADD;
3708: RAISE FND_API.G_EXC_ERROR;
3709: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3711: FND_MSG_PUB.ADD;

Line 3711: FND_MSG_PUB.ADD;

3707: FND_MSG_PUB.ADD;
3708: RAISE FND_API.G_EXC_ERROR;
3709: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3711: FND_MSG_PUB.ADD;
3712: RAISE FND_API.G_EXC_ERROR;
3713: else
3714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3715: end if;

Line 3783: FND_MSG_PUB.ADD;

3779: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3780: 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);
3781: END IF;
3782: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3783: FND_MSG_PUB.ADD;
3784: RAISE FND_API.G_EXC_ERROR;
3785: ELSE
3786: push_eval;
3787: RETURN;

Line 4042: FND_MSG_PUB.ADD;

4038: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4039: 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);
4040: END IF;
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4042: FND_MSG_PUB.ADD;
4043: RAISE FND_API.G_EXC_ERROR;
4044: ELSE
4045: push_eval;
4046: RETURN;

Line 4155: FND_MSG_PUB.ADD;

4151: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4152: 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);
4153: END IF;
4154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4155: FND_MSG_PUB.ADD;
4156: RAISE FND_API.G_EXC_ERROR;
4157: END IF;
4158: ELSE
4159: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4163: FND_MSG_PUB.ADD;

4159: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4160: 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);
4161: END IF;
4162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4163: FND_MSG_PUB.ADD;
4164: RAISE FND_API.G_EXC_ERROR;
4165: END IF;
4166: END IF;
4167: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4286: FND_MSG_PUB.ADD;

4282: WHEN OTHERS THEN
4283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4284: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');
4285: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4286: FND_MSG_PUB.ADD;
4287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4288: END find_persons;
4289:
4290: PROCEDURE find_persons (

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_8.find_party_details');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: END find_party_details;
4357:
4358: PROCEDURE find_duplicate_parties (

Line 4471: FND_MSG_PUB.ADD;

4467: WHEN OTHERS THEN
4468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');
4470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4471: FND_MSG_PUB.ADD;
4472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4473: END find_duplicate_parties;
4474:
4475: PROCEDURE find_duplicate_party_sites (

Line 4556: FND_MSG_PUB.ADD;

4552: WHEN OTHERS THEN
4553: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4554: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');
4555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4556: FND_MSG_PUB.ADD;
4557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4558: END find_duplicate_party_sites;
4559:
4560: PROCEDURE find_duplicate_contacts (

Line 4645: FND_MSG_PUB.ADD;

4641: WHEN OTHERS THEN
4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');
4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4645: FND_MSG_PUB.ADD;
4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4647: END find_duplicate_contacts;
4648:
4649: PROCEDURE find_duplicate_contact_points (

Line 4718: FND_MSG_PUB.ADD;

4714: WHEN OTHERS THEN
4715: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4716: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');
4717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4718: FND_MSG_PUB.ADD;
4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4720: END find_duplicate_contact_points;
4721:
4722: PROCEDURE find_parties_dynamic (

Line 5071: FND_MSG_PUB.ADD;

5067: WHEN OTHERS THEN
5068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.call_api_dynamic');
5070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5071: FND_MSG_PUB.ADD;
5072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5073: END call_api_dynamic;
5074:
5075:

Line 5314: FND_MSG_PUB.ADD;

5310: WHEN OTHERS THEN
5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5312: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_party_sites');
5313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5314: FND_MSG_PUB.ADD;
5315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5316: END get_matching_party_sites;
5317:
5318:

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_8.get_matching_contacts');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_contacts;
5546:
5547:

Line 5686: FND_MSG_PUB.ADD;

5682: WHEN OTHERS THEN
5683: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5684: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contact_points');
5685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5686: FND_MSG_PUB.ADD;
5687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5688: END get_matching_contact_points;
5689:
5690: /**********************************************************

Line 5916: FND_MSG_PUB.ADD;

5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');
5915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5918: END get_score_details;
5919:
5920:

Line 6039: FND_MSG_PUB.ADD;

6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END get_party_for_search;
6042:
6043: PROCEDURE get_search_criteria (

Line 6091: FND_MSG_PUB.ADD;

6087: WHEN OTHERS THEN
6088: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6089: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6093: END get_search_criteria;
6094:
6095:

Line 6143: FND_MSG_PUB.ADD;

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

Line 6203: FND_MSG_PUB.ADD;

6199: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6200: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6201: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6203: FND_MSG_PUB.ADD;
6204: RAISE FND_API.G_EXC_ERROR;
6205: END get_party_site_rec;
6206:
6207: /************************************************

Line 6261: FND_MSG_PUB.ADD;

6257: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6259: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6261: FND_MSG_PUB.ADD;
6262: RAISE FND_API.G_EXC_ERROR;
6263: END get_contact_rec;
6264:
6265: /************************************************

Line 6319: FND_MSG_PUB.ADD;

6315: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6317: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6319: FND_MSG_PUB.ADD;
6320: RAISE FND_API.G_EXC_ERROR;
6321: END get_contact_point_rec;
6322:
6323: /************************************************

Line 6437: FND_MSG_PUB.ADD;

6433: WHEN OTHERS THEN
6434: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6435: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6436: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6437: FND_MSG_PUB.ADD;
6438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6439: END;
6440:
6441:

Line 6633: FND_MSG_PUB.ADD;

6629: WHEN OTHERS THEN
6630: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6631: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6635: END;
6636:
6637:

Line 6723: FND_MSG_PUB.ADD;

6719: WHEN OTHERS THEN
6720: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6721: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6723: FND_MSG_PUB.ADD;
6724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6725: END;
6726:
6727:

Line 6880: FND_MSG_PUB.ADD;

6876: WHEN OTHERS THEN
6877: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6878: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6882: END;
6883:
6884:

Line 6906: FND_MSG_PUB.ADD;

6902: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6903: OR p_contact_point_list(I).URL IS NOT NULL
6904: ) THEN
6905: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6906: FND_MSG_PUB.ADD;
6907: RAISE FND_API.G_EXC_ERROR;
6908: END IF;
6909: END LOOP;
6910:

Line 6965: FND_MSG_PUB.ADD;

6961: WHEN OTHERS THEN
6962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6963: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6965: FND_MSG_PUB.ADD;
6966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6967: END check_prim_cond;
6968:
6969: /************************************************

Line 7027: FND_MSG_PUB.ADD;

7023: WHEN OTHERS THEN
7024: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7025: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7027: FND_MSG_PUB.ADD;
7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7029: END check_party_site_cond;
7030:
7031: /************************************************

Line 7085: FND_MSG_PUB.ADD;

7081: WHEN OTHERS THEN
7082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7083: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7085: FND_MSG_PUB.ADD;
7086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7087: END check_contact_cond;
7088:
7089: /************************************************

Line 7106: FND_MSG_PUB.ADD;

7102:
7103: FOR I IN 1..p_contact_point_list.COUNT LOOP
7104: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7105: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7106: FND_MSG_PUB.ADD;
7107: RAISE FND_API.G_EXC_ERROR;
7108: END IF;
7109: END LOOP;
7110:

Line 7134: FND_MSG_PUB.ADD;

7130: WHEN OTHERS THEN
7131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7132: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7134: FND_MSG_PUB.ADD;
7135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7136: END check_contact_point_cond;
7137:
7138: FUNCTION check_staged RETURN BOOLEAN IS