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

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

Line 1709: FND_MSG_PUB.ADD;

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

Line 1713: FND_MSG_PUB.ADD;

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

Line 1718: FND_MSG_PUB.ADD;

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

Line 1950: FND_MSG_PUB.ADD;

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

Line 1954: FND_MSG_PUB.ADD;

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

Line 1958: FND_MSG_PUB.ADD;

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

Line 1963: FND_MSG_PUB.ADD;

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

Line 2097: FND_MSG_PUB.ADD;

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

Line 2101: FND_MSG_PUB.ADD;

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

Line 2105: FND_MSG_PUB.ADD;

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

Line 2110: FND_MSG_PUB.ADD;

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

Line 2370: FND_MSG_PUB.ADD;

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

Line 2374: FND_MSG_PUB.ADD;

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

Line 2378: FND_MSG_PUB.ADD;

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

Line 2383: FND_MSG_PUB.ADD;

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

Line 2641: FND_MSG_PUB.ADD;

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

Line 2689: FND_MSG_PUB.ADD;

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

Line 2762: FND_MSG_PUB.ADD;

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

Line 2874: FND_MSG_PUB.ADD;

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

Line 2985: FND_MSG_PUB.ADD;

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

Line 3210: FND_MSG_PUB.ADD;

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

Line 3218: FND_MSG_PUB.ADD;

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

Line 3426: FND_MSG_PUB.ADD;

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

Line 3624: FND_MSG_PUB.ADD;

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

Line 3672: FND_MSG_PUB.ADD;

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

Line 3708: FND_MSG_PUB.ADD;

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

Line 3712: FND_MSG_PUB.ADD;

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

Line 3784: FND_MSG_PUB.ADD;

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

Line 4043: FND_MSG_PUB.ADD;

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

Line 4156: FND_MSG_PUB.ADD;

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

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: END IF;
4168: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4287: FND_MSG_PUB.ADD;

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

Line 4355: FND_MSG_PUB.ADD;

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

Line 4472: FND_MSG_PUB.ADD;

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

Line 4557: FND_MSG_PUB.ADD;

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

Line 4646: FND_MSG_PUB.ADD;

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

Line 4719: FND_MSG_PUB.ADD;

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

Line 5021: FND_MSG_PUB.ADD;

5017: WHEN OTHERS THEN
5018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5021: FND_MSG_PUB.ADD;
5022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5023: END call_api_dynamic;
5024:
5025:

Line 5261: FND_MSG_PUB.ADD;

5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END get_matching_party_sites;
5264:
5265:

Line 5486: FND_MSG_PUB.ADD;

5482: WHEN OTHERS THEN
5483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: END get_matching_contacts;
5489:
5490:

Line 5625: FND_MSG_PUB.ADD;

5621: WHEN OTHERS THEN
5622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5623: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5625: FND_MSG_PUB.ADD;
5626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5627: END get_matching_contact_points;
5628:
5629: /**********************************************************

Line 5851: FND_MSG_PUB.ADD;

5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: END get_score_details;
5854:
5855:

Line 5929: FND_MSG_PUB.ADD;

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

Line 5969: FND_MSG_PUB.ADD;

5965: WHEN OTHERS THEN
5966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5967: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5969: FND_MSG_PUB.ADD;
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: END get_search_criteria;
5972:
5973:

Line 6034: FND_MSG_PUB.ADD;

6030: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6031: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6032: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_ERROR;
6036: END get_party_rec;
6037:
6038: /************************************************

Line 6096: FND_MSG_PUB.ADD;

6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;
6097: RAISE FND_API.G_EXC_ERROR;
6098: END get_party_site_rec;
6099:
6100: /************************************************

Line 6152: FND_MSG_PUB.ADD;

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

Line 6204: FND_MSG_PUB.ADD;

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

Line 6418: FND_MSG_PUB.ADD;

6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6420: END;
6421:
6422:

Line 6630: FND_MSG_PUB.ADD;

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

Line 6672: FND_MSG_PUB.ADD;

6668: WHEN OTHERS THEN
6669: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6670: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6672: FND_MSG_PUB.ADD;
6673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6674: END;
6675:
6676:

Line 6739: FND_MSG_PUB.ADD;

6735: WHEN OTHERS THEN
6736: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6737: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6738: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6739: FND_MSG_PUB.ADD;
6740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6741: END;
6742:
6743:

Line 6806: FND_MSG_PUB.ADD;

6802: WHEN OTHERS THEN
6803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6804: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6806: FND_MSG_PUB.ADD;
6807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6808: END check_prim_cond;
6809:
6810: /************************************************

Line 6858: FND_MSG_PUB.ADD;

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

Line 6896: FND_MSG_PUB.ADD;

6892: WHEN OTHERS THEN
6893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6894: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6896: FND_MSG_PUB.ADD;
6897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6898: END check_contact_cond;
6899:
6900: /************************************************

Line 6917: FND_MSG_PUB.ADD;

6913:
6914: FOR I IN 1..p_contact_point_list.COUNT LOOP
6915: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6916: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6917: FND_MSG_PUB.ADD;
6918: RAISE FND_API.G_EXC_ERROR;
6919: END IF;
6920: END LOOP;
6921:

Line 6933: FND_MSG_PUB.ADD;

6929: WHEN OTHERS THEN
6930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6931: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6933: FND_MSG_PUB.ADD;
6934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6935: END check_contact_point_cond;
6936:
6937: FUNCTION check_staged RETURN BOOLEAN IS