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

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

Line 1706: FND_MSG_PUB.ADD;

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

Line 1710: FND_MSG_PUB.ADD;

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

Line 1715: FND_MSG_PUB.ADD;

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

Line 1947: FND_MSG_PUB.ADD;

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

Line 1951: FND_MSG_PUB.ADD;

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

Line 1955: FND_MSG_PUB.ADD;

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

Line 1960: FND_MSG_PUB.ADD;

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

Line 2094: FND_MSG_PUB.ADD;

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

Line 2098: FND_MSG_PUB.ADD;

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

Line 2102: FND_MSG_PUB.ADD;

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

Line 2107: FND_MSG_PUB.ADD;

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

Line 2367: FND_MSG_PUB.ADD;

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

Line 2371: FND_MSG_PUB.ADD;

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

Line 2375: FND_MSG_PUB.ADD;

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

Line 2380: FND_MSG_PUB.ADD;

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

Line 2637: FND_MSG_PUB.ADD;

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

Line 2685: FND_MSG_PUB.ADD;

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

Line 2758: FND_MSG_PUB.ADD;

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

Line 2870: FND_MSG_PUB.ADD;

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

Line 2981: FND_MSG_PUB.ADD;

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

Line 3206: FND_MSG_PUB.ADD;

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

Line 3214: FND_MSG_PUB.ADD;

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

Line 3422: FND_MSG_PUB.ADD;

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

Line 3619: FND_MSG_PUB.ADD;

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

Line 3667: FND_MSG_PUB.ADD;

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

Line 3703: FND_MSG_PUB.ADD;

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

Line 3707: FND_MSG_PUB.ADD;

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

Line 3779: FND_MSG_PUB.ADD;

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

Line 4038: FND_MSG_PUB.ADD;

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

Line 4151: FND_MSG_PUB.ADD;

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

Line 4159: FND_MSG_PUB.ADD;

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

Line 4282: FND_MSG_PUB.ADD;

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

Line 4350: FND_MSG_PUB.ADD;

4346: WHEN OTHERS THEN
4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4348: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');
4349: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4350: FND_MSG_PUB.ADD;
4351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4352: END find_party_details;
4353:
4354: PROCEDURE find_duplicate_parties (

Line 4467: FND_MSG_PUB.ADD;

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

Line 4552: FND_MSG_PUB.ADD;

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

Line 4641: FND_MSG_PUB.ADD;

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

Line 4714: FND_MSG_PUB.ADD;

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

Line 5067: FND_MSG_PUB.ADD;

5063: WHEN OTHERS THEN
5064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.call_api_dynamic');
5066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5067: FND_MSG_PUB.ADD;
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: END call_api_dynamic;
5070:
5071:

Line 5310: FND_MSG_PUB.ADD;

5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_matching_party_sites;
5313:
5314:

Line 5539: FND_MSG_PUB.ADD;

5535: WHEN OTHERS THEN
5536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contacts');
5538: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5539: FND_MSG_PUB.ADD;
5540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5541: END get_matching_contacts;
5542:
5543:

Line 5682: FND_MSG_PUB.ADD;

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

Line 5911: FND_MSG_PUB.ADD;

5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END get_score_details;
5914:
5915:

Line 6034: FND_MSG_PUB.ADD;

6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6036: END get_party_for_search;
6037:
6038: PROCEDURE get_search_criteria (

Line 6086: FND_MSG_PUB.ADD;

6082: WHEN OTHERS THEN
6083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6084: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;
6087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6088: END get_search_criteria;
6089:
6090:

Line 6138: FND_MSG_PUB.ADD;

6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END get_party_rec;
6141:
6142: /************************************************

Line 6198: FND_MSG_PUB.ADD;

6194: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6195: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6196: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_ERROR;
6200: END get_party_site_rec;
6201:
6202: /************************************************

Line 6256: FND_MSG_PUB.ADD;

6252: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6253: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6254: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_ERROR;
6258: END get_contact_rec;
6259:
6260: /************************************************

Line 6314: FND_MSG_PUB.ADD;

6310: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6311: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6312: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6314: FND_MSG_PUB.ADD;
6315: RAISE FND_API.G_EXC_ERROR;
6316: END get_contact_point_rec;
6317:
6318: /************************************************

Line 6432: FND_MSG_PUB.ADD;

6428: WHEN OTHERS THEN
6429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6430: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6434: END;
6435:
6436:

Line 6628: FND_MSG_PUB.ADD;

6624: WHEN OTHERS THEN
6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6628: FND_MSG_PUB.ADD;
6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6630: END;
6631:
6632:

Line 6718: FND_MSG_PUB.ADD;

6714: WHEN OTHERS THEN
6715: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6716: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6718: FND_MSG_PUB.ADD;
6719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6720: END;
6721:
6722:

Line 6875: FND_MSG_PUB.ADD;

6871: WHEN OTHERS THEN
6872: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6873: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6874: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6875: FND_MSG_PUB.ADD;
6876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6877: END;
6878:
6879:

Line 6901: FND_MSG_PUB.ADD;

6897: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6898: OR p_contact_point_list(I).URL IS NOT NULL
6899: ) THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6901: FND_MSG_PUB.ADD;
6902: RAISE FND_API.G_EXC_ERROR;
6903: END IF;
6904: END LOOP;
6905:

Line 6960: FND_MSG_PUB.ADD;

6956: WHEN OTHERS THEN
6957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6958: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6960: FND_MSG_PUB.ADD;
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: END check_prim_cond;
6963:
6964: /************************************************

Line 7022: FND_MSG_PUB.ADD;

7018: WHEN OTHERS THEN
7019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7020: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7022: FND_MSG_PUB.ADD;
7023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7024: END check_party_site_cond;
7025:
7026: /************************************************

Line 7080: FND_MSG_PUB.ADD;

7076: WHEN OTHERS THEN
7077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7078: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7079: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7080: FND_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7082: END check_contact_cond;
7083:
7084: /************************************************

Line 7101: FND_MSG_PUB.ADD;

7097:
7098: FOR I IN 1..p_contact_point_list.COUNT LOOP
7099: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7100: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7101: FND_MSG_PUB.ADD;
7102: RAISE FND_API.G_EXC_ERROR;
7103: END IF;
7104: END LOOP;
7105:

Line 7129: FND_MSG_PUB.ADD;

7125: WHEN OTHERS THEN
7126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7127: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7129: FND_MSG_PUB.ADD;
7130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7131: END check_contact_point_cond;
7132:
7133: FUNCTION check_staged RETURN BOOLEAN IS