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

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

Line 902: FND_MSG_PUB.ADD;

898: WHEN OTHERS THEN
899: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
900: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
901: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END;
905:
906:

Line 922: FND_MSG_PUB.ADD;

918: WHEN OTHERS THEN
919: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
920: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END;
925:
926:

Line 942: FND_MSG_PUB.ADD;

938: WHEN OTHERS THEN
939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
940: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END;
945:
946: PROCEDURE init_score_context (

Line 1009: FND_MSG_PUB.ADD;

1005: p_party_site_list,
1006: p_contact_list,
1007: p_contact_point_list) THEN
1008: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1013: 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 1301: FND_MSG_PUB.ADD;

1297: END IF;
1298: IF lengthb(l_party_contains_str) > 4000 THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: IF (p_match_str = ' AND ' OR p_party_max_score 1305: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1400: FND_MSG_PUB.ADD;

1396: -- Add the search criteria to query string
1397: IF lengthb(l_contains_str) > 4000 THEN
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1399: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403: x_denorm_str := l_den_contains_str;
1404: RETURN l_contains_str;

Line 1707: FND_MSG_PUB.ADD;

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

Line 1711: FND_MSG_PUB.ADD;

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

Line 1715: FND_MSG_PUB.ADD;

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

Line 1720: FND_MSG_PUB.ADD;

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

Line 1952: FND_MSG_PUB.ADD;

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

Line 1956: FND_MSG_PUB.ADD;

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

Line 1960: FND_MSG_PUB.ADD;

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

Line 1965: FND_MSG_PUB.ADD;

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

Line 2099: FND_MSG_PUB.ADD;

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

Line 2103: FND_MSG_PUB.ADD;

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

Line 2107: FND_MSG_PUB.ADD;

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

Line 2112: FND_MSG_PUB.ADD;

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

Line 2372: FND_MSG_PUB.ADD;

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

Line 2376: FND_MSG_PUB.ADD;

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

Line 2380: FND_MSG_PUB.ADD;

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

Line 2385: FND_MSG_PUB.ADD;

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

Line 2644: FND_MSG_PUB.ADD;

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

Line 2694: FND_MSG_PUB.ADD;

2690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2691: 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);
2692: END IF;
2693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2694: FND_MSG_PUB.ADD;
2695: RAISE FND_API.G_EXC_ERROR;
2696: ELSE
2697: push_eval;
2698: RETURN;

Line 2767: FND_MSG_PUB.ADD;

2763: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2764: 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);
2765: END IF;
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2767: FND_MSG_PUB.ADD;
2768: RAISE FND_API.G_EXC_ERROR;
2769: ELSE
2770: push_eval;
2771: RETURN;

Line 2879: FND_MSG_PUB.ADD;

2875: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2876: 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);
2877: END IF;
2878: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2879: FND_MSG_PUB.ADD;
2880: RAISE FND_API.G_EXC_ERROR;
2881: ELSE
2882: push_eval;
2883: RETURN;

Line 2990: FND_MSG_PUB.ADD;

2986: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2987: 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);
2988: END IF;
2989: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2990: FND_MSG_PUB.ADD;
2991: RAISE FND_API.G_EXC_ERROR;
2992: ELSE
2993: push_eval;
2994: RETURN;

Line 3215: FND_MSG_PUB.ADD;

3211: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3212: 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);
3213: END IF;
3214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3215: FND_MSG_PUB.ADD;
3216: RAISE FND_API.G_EXC_ERROR;
3217: END IF;
3218: ELSE
3219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3223: FND_MSG_PUB.ADD;

3219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3220: 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);
3221: END IF;
3222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3223: FND_MSG_PUB.ADD;
3224: RAISE FND_API.G_EXC_ERROR;
3225: END IF;
3226: END IF;
3227: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3431: FND_MSG_PUB.ADD;

3427: WHEN OTHERS THEN
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3429: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');
3430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3431: FND_MSG_PUB.ADD;
3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3433: END find_parties;
3434:
3435: PROCEDURE find_persons (

Line 3630: FND_MSG_PUB.ADD;

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

Line 3680: FND_MSG_PUB.ADD;

3676: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3677: 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);
3678: END IF;
3679: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_ERROR;
3682: ELSE
3683: push_eval;
3684: RETURN;

Line 3716: FND_MSG_PUB.ADD;

3712: exception
3713: when others then
3714: if (instrb(SQLERRM,'DRG-51030')>0) then
3715: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3716: FND_MSG_PUB.ADD;
3717: RAISE FND_API.G_EXC_ERROR;
3718: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3720: FND_MSG_PUB.ADD;

Line 3720: FND_MSG_PUB.ADD;

3716: FND_MSG_PUB.ADD;
3717: RAISE FND_API.G_EXC_ERROR;
3718: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3720: FND_MSG_PUB.ADD;
3721: RAISE FND_API.G_EXC_ERROR;
3722: else
3723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3724: end if;

Line 3792: FND_MSG_PUB.ADD;

3788: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3789: 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);
3790: END IF;
3791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3792: FND_MSG_PUB.ADD;
3793: RAISE FND_API.G_EXC_ERROR;
3794: ELSE
3795: push_eval;
3796: RETURN;

Line 4051: FND_MSG_PUB.ADD;

4047: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4048: 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);
4049: END IF;
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4051: FND_MSG_PUB.ADD;
4052: RAISE FND_API.G_EXC_ERROR;
4053: ELSE
4054: push_eval;
4055: RETURN;

Line 4164: FND_MSG_PUB.ADD;

4160: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4161: 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);
4162: END IF;
4163: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4164: FND_MSG_PUB.ADD;
4165: RAISE FND_API.G_EXC_ERROR;
4166: END IF;
4167: ELSE
4168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4172: FND_MSG_PUB.ADD;

4168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4169: 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);
4170: END IF;
4171: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4172: FND_MSG_PUB.ADD;
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;
4175: END IF;
4176: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4295: FND_MSG_PUB.ADD;

4291: WHEN OTHERS THEN
4292: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4293: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');
4294: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4295: FND_MSG_PUB.ADD;
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: END find_persons;
4298:
4299: PROCEDURE find_persons (

Line 4363: FND_MSG_PUB.ADD;

4359: WHEN OTHERS THEN
4360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');
4362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4363: FND_MSG_PUB.ADD;
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: END find_party_details;
4366:
4367: PROCEDURE find_duplicate_parties (

Line 4480: FND_MSG_PUB.ADD;

4476: WHEN OTHERS THEN
4477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4478: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');
4479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4480: FND_MSG_PUB.ADD;
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: END find_duplicate_parties;
4483:
4484: PROCEDURE find_duplicate_party_sites (

Line 4565: FND_MSG_PUB.ADD;

4561: WHEN OTHERS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: END find_duplicate_party_sites;
4568:
4569: PROCEDURE find_duplicate_contacts (

Line 4654: FND_MSG_PUB.ADD;

4650: WHEN OTHERS THEN
4651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4652: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');
4653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4654: FND_MSG_PUB.ADD;
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: END find_duplicate_contacts;
4657:
4658: PROCEDURE find_duplicate_contact_points (

Line 4727: FND_MSG_PUB.ADD;

4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: END find_duplicate_contact_points;
4730:
4731: PROCEDURE find_parties_dynamic (

Line 5029: FND_MSG_PUB.ADD;

5025: WHEN OTHERS THEN
5026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5027: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5029: FND_MSG_PUB.ADD;
5030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5031: END call_api_dynamic;
5032:
5033:

Line 5269: FND_MSG_PUB.ADD;

5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_party_sites;
5272:
5273:

Line 5494: FND_MSG_PUB.ADD;

5490: WHEN OTHERS THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5492: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5493: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5494: FND_MSG_PUB.ADD;
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: END get_matching_contacts;
5497:
5498:

Line 5633: FND_MSG_PUB.ADD;

5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5633: FND_MSG_PUB.ADD;
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: END get_matching_contact_points;
5636:
5637: /**********************************************************

Line 5862: FND_MSG_PUB.ADD;

5858: WHEN OTHERS THEN
5859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5862: FND_MSG_PUB.ADD;
5863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5864: END get_score_details;
5865:
5866:

Line 5940: FND_MSG_PUB.ADD;

5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: END get_party_for_search;
5943:
5944: 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 6045: FND_MSG_PUB.ADD;

6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END get_party_rec;
6048:
6049: /************************************************

Line 6107: FND_MSG_PUB.ADD;

6103: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6105: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6107: FND_MSG_PUB.ADD;
6108: RAISE FND_API.G_EXC_ERROR;
6109: END get_party_site_rec;
6110:
6111: /************************************************

Line 6163: FND_MSG_PUB.ADD;

6159: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6160: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6161: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6162: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6163: FND_MSG_PUB.ADD;
6164: RAISE FND_API.G_EXC_ERROR;
6165: END get_contact_rec;
6166:
6167: /************************************************

Line 6215: FND_MSG_PUB.ADD;

6211: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6213: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6214: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6215: FND_MSG_PUB.ADD;
6216: RAISE FND_API.G_EXC_ERROR;
6217: END get_contact_point_rec;
6218:
6219: /************************************************

Line 6429: FND_MSG_PUB.ADD;

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

Line 6641: FND_MSG_PUB.ADD;

6637: WHEN OTHERS THEN
6638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6641: FND_MSG_PUB.ADD;
6642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6643: END;
6644:
6645:

Line 6683: FND_MSG_PUB.ADD;

6679: WHEN OTHERS THEN
6680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6685: END;
6686:
6687:

Line 6750: FND_MSG_PUB.ADD;

6746: WHEN OTHERS THEN
6747: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6748: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6750: FND_MSG_PUB.ADD;
6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6752: END;
6753:
6754:

Line 6817: FND_MSG_PUB.ADD;

6813: WHEN OTHERS THEN
6814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6815: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6817: FND_MSG_PUB.ADD;
6818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6819: END check_prim_cond;
6820:
6821: /************************************************

Line 6869: FND_MSG_PUB.ADD;

6865: WHEN OTHERS THEN
6866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6867: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6869: FND_MSG_PUB.ADD;
6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6871: END check_party_site_cond;
6872:
6873: /************************************************

Line 6907: FND_MSG_PUB.ADD;

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

Line 6928: FND_MSG_PUB.ADD;

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

Line 6944: FND_MSG_PUB.ADD;

6940: WHEN OTHERS THEN
6941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6942: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6944: FND_MSG_PUB.ADD;
6945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6946: END check_contact_point_cond;
6947:
6948: FUNCTION check_staged RETURN BOOLEAN IS