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

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

Line 1696: FND_MSG_PUB.ADD;

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

Line 1700: FND_MSG_PUB.ADD;

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

Line 1705: FND_MSG_PUB.ADD;

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

Line 1937: FND_MSG_PUB.ADD;

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

Line 1941: FND_MSG_PUB.ADD;

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

Line 1945: FND_MSG_PUB.ADD;

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

Line 1950: FND_MSG_PUB.ADD;

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

Line 2084: FND_MSG_PUB.ADD;

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

Line 2088: FND_MSG_PUB.ADD;

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

Line 2092: FND_MSG_PUB.ADD;

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

Line 2097: FND_MSG_PUB.ADD;

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

Line 2357: FND_MSG_PUB.ADD;

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

Line 2361: FND_MSG_PUB.ADD;

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

Line 2365: FND_MSG_PUB.ADD;

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

Line 2370: FND_MSG_PUB.ADD;

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

Line 2631: FND_MSG_PUB.ADD;

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

Line 2679: FND_MSG_PUB.ADD;

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

Line 2752: FND_MSG_PUB.ADD;

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

Line 2864: FND_MSG_PUB.ADD;

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

Line 2975: FND_MSG_PUB.ADD;

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

Line 3119: FND_MSG_PUB.ADD;

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

Line 3127: FND_MSG_PUB.ADD;

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

Line 3378: FND_MSG_PUB.ADD;

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

Line 3579: FND_MSG_PUB.ADD;

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

Line 3627: FND_MSG_PUB.ADD;

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

Line 3663: FND_MSG_PUB.ADD;

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

Line 3667: FND_MSG_PUB.ADD;

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

Line 3739: FND_MSG_PUB.ADD;

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

Line 3928: FND_MSG_PUB.ADD;

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

Line 4016: FND_MSG_PUB.ADD;

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

Line 4024: FND_MSG_PUB.ADD;

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

Line 4173: FND_MSG_PUB.ADD;

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

Line 4241: FND_MSG_PUB.ADD;

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

Line 4358: FND_MSG_PUB.ADD;

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

Line 4443: FND_MSG_PUB.ADD;

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

Line 4532: FND_MSG_PUB.ADD;

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

Line 4605: FND_MSG_PUB.ADD;

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

Line 4948: FND_MSG_PUB.ADD;

4944: WHEN OTHERS THEN
4945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4948: FND_MSG_PUB.ADD;
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: END call_api_dynamic;
4951:
4952:

Line 5195: FND_MSG_PUB.ADD;

5191: WHEN OTHERS THEN
5192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5193: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5195: FND_MSG_PUB.ADD;
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: END get_matching_party_sites;
5198:
5199:

Line 5424: FND_MSG_PUB.ADD;

5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5426: END get_matching_contacts;
5427:
5428:

Line 5566: FND_MSG_PUB.ADD;

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

Line 5805: FND_MSG_PUB.ADD;

5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5807: END get_score_details;
5808:
5809:

Line 5928: FND_MSG_PUB.ADD;

5924: WHEN OTHERS THEN
5925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5926: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: END get_party_for_search;
5931:
5932: PROCEDURE get_search_criteria (

Line 5980: FND_MSG_PUB.ADD;

5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5980: FND_MSG_PUB.ADD;
5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5982: END get_search_criteria;
5983:
5984:

Line 6025: FND_MSG_PUB.ADD;

6021: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6024: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6025: FND_MSG_PUB.ADD;
6026: RAISE FND_API.G_EXC_ERROR;
6027: END get_party_rec;
6028:
6029: /************************************************

Line 6091: FND_MSG_PUB.ADD;

6087: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6089: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_ERROR;
6093: END get_party_site_rec;
6094:
6095: /************************************************

Line 6149: FND_MSG_PUB.ADD;

6145: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6146: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6147: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6149: FND_MSG_PUB.ADD;
6150: RAISE FND_API.G_EXC_ERROR;
6151: END get_contact_rec;
6152:
6153: /************************************************

Line 6205: FND_MSG_PUB.ADD;

6201: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6202: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6203: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6205: FND_MSG_PUB.ADD;
6206: RAISE FND_API.G_EXC_ERROR;
6207: END get_contact_point_rec;
6208:
6209: /************************************************

Line 6301: FND_MSG_PUB.ADD;

6297: WHEN OTHERS THEN
6298: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6299: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6301: FND_MSG_PUB.ADD;
6302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6303: END;
6304:
6305:

Line 6571: FND_MSG_PUB.ADD;

6567: WHEN OTHERS THEN
6568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6571: FND_MSG_PUB.ADD;
6572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6573: END;
6574:
6575:

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

6731: WHEN OTHERS THEN
6732: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6733: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6735: FND_MSG_PUB.ADD;
6736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6737: END;
6738:
6739:

Line 6759: FND_MSG_PUB.ADD;

6755: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6756: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6757: ) THEN
6758: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6759: FND_MSG_PUB.ADD;
6760: RAISE FND_API.G_EXC_ERROR;
6761: END IF;
6762: END LOOP;
6763:

Line 6800: FND_MSG_PUB.ADD;

6796: WHEN OTHERS THEN
6797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6798: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6800: FND_MSG_PUB.ADD;
6801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6802: END check_prim_cond;
6803:
6804: /************************************************

Line 6861: FND_MSG_PUB.ADD;

6857: WHEN OTHERS THEN
6858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6859: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6861: FND_MSG_PUB.ADD;
6862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6863: END check_party_site_cond;
6864:
6865: /************************************************

Line 6916: FND_MSG_PUB.ADD;

6912: WHEN OTHERS THEN
6913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6914: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6916: FND_MSG_PUB.ADD;
6917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6918: END check_contact_cond;
6919:
6920: /************************************************

Line 6937: FND_MSG_PUB.ADD;

6933:
6934: FOR I IN 1..p_contact_point_list.COUNT LOOP
6935: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6936: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6937: FND_MSG_PUB.ADD;
6938: RAISE FND_API.G_EXC_ERROR;
6939: END IF;
6940: END LOOP;
6941:

Line 6962: FND_MSG_PUB.ADD;

6958: WHEN OTHERS THEN
6959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6960: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6962: FND_MSG_PUB.ADD;
6963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6964: END check_contact_point_cond;
6965:
6966: FUNCTION check_staged RETURN BOOLEAN IS