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

1029: WHEN OTHERS THEN
1030: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1031: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1032: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1033: FND_MSG_PUB.ADD;
1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1035: END;
1036:
1037:

Line 1058: FND_MSG_PUB.ADD;

1054: WHEN OTHERS THEN
1055: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1056: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1058: FND_MSG_PUB.ADD;
1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060: END;
1061:
1062:

Line 1078: FND_MSG_PUB.ADD;

1074: WHEN OTHERS THEN
1075: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1076: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1078: FND_MSG_PUB.ADD;
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: END;
1081:
1082:

Line 1098: FND_MSG_PUB.ADD;

1094: WHEN OTHERS THEN
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1096: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1098: FND_MSG_PUB.ADD;
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END;
1101:
1102: PROCEDURE init_score_context (

Line 1165: FND_MSG_PUB.ADD;

1161: p_party_site_list,
1162: p_contact_list,
1163: p_contact_point_list) THEN
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1165: FND_MSG_PUB.ADD;
1166: RAISE FND_API.G_EXC_ERROR;
1167: END IF;
1168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1169: 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 1434: FND_MSG_PUB.ADD;

1430: END IF;
1431: IF lengthb(l_party_contains_str) > 4000 THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1433: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1434: FND_MSG_PUB.ADD;
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: IF (p_match_str = ' AND ' OR p_party_max_score 1438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1547: FND_MSG_PUB.ADD;

1543: -- Add the search criteria to query string
1544: IF lengthb(l_contains_str) > 4000 THEN
1545: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1546: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550: x_denorm_str := l_den_contains_str;
1551: RETURN l_contains_str;

Line 1594: FND_MSG_PUB.ADD;

1590: -- Add the search criteria to query string
1591: IF lengthb(l_contains_str) > 4000 THEN
1592: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1593: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1594: FND_MSG_PUB.ADD;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597: x_denorm_str := l_den_contains_str;
1598: RETURN l_contains_str;

Line 1675: FND_MSG_PUB.ADD;

1671: -- Add the search criteria to query string
1672: IF lengthb(l_contains_str) > 4000 THEN
1673: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1674: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678: x_denorm_str := l_den_contains_str;
1679: RETURN l_contains_str;

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

2188: exception
2189: when others then
2190: if (instrb(SQLERRM,'DRG-51030')>0) then
2191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2192: FND_MSG_PUB.ADD;
2193: RAISE FND_API.G_EXC_ERROR;
2194: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2196: FND_MSG_PUB.ADD;

Line 2196: FND_MSG_PUB.ADD;

2192: FND_MSG_PUB.ADD;
2193: RAISE FND_API.G_EXC_ERROR;
2194: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2196: FND_MSG_PUB.ADD;
2197: RAISE FND_API.G_EXC_ERROR;
2198: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2199: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2200: FND_MSG_PUB.ADD;

Line 2200: FND_MSG_PUB.ADD;

2196: FND_MSG_PUB.ADD;
2197: RAISE FND_API.G_EXC_ERROR;
2198: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2199: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2200: FND_MSG_PUB.ADD;
2201: RAISE FND_API.G_EXC_ERROR;
2202: else
2203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2205: FND_MSG_PUB.ADD;

2201: RAISE FND_API.G_EXC_ERROR;
2202: else
2203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2205: FND_MSG_PUB.ADD;
2206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2207: end if;
2208: END;
2209:

Line 2339: FND_MSG_PUB.ADD;

2335: exception
2336: when others then
2337: if (instrb(SQLERRM,'DRG-51030')>0) then
2338: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2339: FND_MSG_PUB.ADD;
2340: RAISE FND_API.G_EXC_ERROR;
2341: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2342: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2343: FND_MSG_PUB.ADD;

Line 2343: FND_MSG_PUB.ADD;

2339: FND_MSG_PUB.ADD;
2340: RAISE FND_API.G_EXC_ERROR;
2341: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2342: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2343: FND_MSG_PUB.ADD;
2344: RAISE FND_API.G_EXC_ERROR;
2345: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2346: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2347: FND_MSG_PUB.ADD;

Line 2347: FND_MSG_PUB.ADD;

2343: FND_MSG_PUB.ADD;
2344: RAISE FND_API.G_EXC_ERROR;
2345: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2346: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2347: FND_MSG_PUB.ADD;
2348: RAISE FND_API.G_EXC_ERROR;
2349: else
2350: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2351: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2352: FND_MSG_PUB.ADD;

2348: RAISE FND_API.G_EXC_ERROR;
2349: else
2350: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2351: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2352: FND_MSG_PUB.ADD;
2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2354: end if;
2355: END;
2356:

Line 2612: FND_MSG_PUB.ADD;

2608: exception
2609: when others then
2610: if (instrb(SQLERRM,'DRG-51030')>0) then
2611: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2612: FND_MSG_PUB.ADD;
2613: RAISE FND_API.G_EXC_ERROR;
2614: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2615: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2616: FND_MSG_PUB.ADD;

Line 2616: FND_MSG_PUB.ADD;

2612: FND_MSG_PUB.ADD;
2613: RAISE FND_API.G_EXC_ERROR;
2614: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2615: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2616: FND_MSG_PUB.ADD;
2617: RAISE FND_API.G_EXC_ERROR;
2618: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2619: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2620: FND_MSG_PUB.ADD;

Line 2620: FND_MSG_PUB.ADD;

2616: FND_MSG_PUB.ADD;
2617: RAISE FND_API.G_EXC_ERROR;
2618: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2619: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: else
2623: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2625: FND_MSG_PUB.ADD;

2621: RAISE FND_API.G_EXC_ERROR;
2622: else
2623: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2627: end if;
2628: END;
2629:

Line 2887: FND_MSG_PUB.ADD;

2883: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2884: 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);
2885: END IF;
2886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2887: FND_MSG_PUB.ADD;
2888: RAISE FND_API.G_EXC_ERROR;
2889: ELSE
2890: push_eval;
2891: RETURN;

Line 2937: FND_MSG_PUB.ADD;

2933: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2934: 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);
2935: END IF;
2936: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2937: FND_MSG_PUB.ADD;
2938: RAISE FND_API.G_EXC_ERROR;
2939: ELSE
2940: push_eval;
2941: RETURN;

Line 3010: FND_MSG_PUB.ADD;

3006: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3007: 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);
3008: END IF;
3009: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3010: FND_MSG_PUB.ADD;
3011: RAISE FND_API.G_EXC_ERROR;
3012: ELSE
3013: push_eval;
3014: RETURN;

Line 3122: FND_MSG_PUB.ADD;

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

Line 3233: FND_MSG_PUB.ADD;

3229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3230: 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);
3231: END IF;
3232: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3233: FND_MSG_PUB.ADD;
3234: RAISE FND_API.G_EXC_ERROR;
3235: ELSE
3236: push_eval;
3237: RETURN;

Line 3458: FND_MSG_PUB.ADD;

3454: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3455: 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);
3456: END IF;
3457: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3458: FND_MSG_PUB.ADD;
3459: RAISE FND_API.G_EXC_ERROR;
3460: END IF;
3461: ELSE
3462: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3466: FND_MSG_PUB.ADD;

3462: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3463: 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);
3464: END IF;
3465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3466: FND_MSG_PUB.ADD;
3467: RAISE FND_API.G_EXC_ERROR;
3468: END IF;
3469: END IF;
3470: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3674: FND_MSG_PUB.ADD;

3670: WHEN OTHERS THEN
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3672: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3673: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: END find_parties;
3677:
3678: PROCEDURE find_persons (

Line 3876: FND_MSG_PUB.ADD;

3872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3873: 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);
3874: END IF;
3875: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3876: FND_MSG_PUB.ADD;
3877: RAISE FND_API.G_EXC_ERROR;
3878: ELSE
3879: push_eval;
3880: RETURN;

Line 3926: FND_MSG_PUB.ADD;

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

Line 3962: FND_MSG_PUB.ADD;

3958: exception
3959: when others then
3960: if (instrb(SQLERRM,'DRG-51030')>0) then
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3962: FND_MSG_PUB.ADD;
3963: RAISE FND_API.G_EXC_ERROR;
3964: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3966: FND_MSG_PUB.ADD;

Line 3966: FND_MSG_PUB.ADD;

3962: FND_MSG_PUB.ADD;
3963: RAISE FND_API.G_EXC_ERROR;
3964: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_ERROR;
3968: else
3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3970: end if;

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

4293: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4294: 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);
4295: END IF;
4296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4297: FND_MSG_PUB.ADD;
4298: RAISE FND_API.G_EXC_ERROR;
4299: ELSE
4300: push_eval;
4301: RETURN;

Line 4410: FND_MSG_PUB.ADD;

4406: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4407: 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);
4408: END IF;
4409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4410: FND_MSG_PUB.ADD;
4411: RAISE FND_API.G_EXC_ERROR;
4412: END IF;
4413: ELSE
4414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4418: FND_MSG_PUB.ADD;

4414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4415: 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);
4416: END IF;
4417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4418: FND_MSG_PUB.ADD;
4419: RAISE FND_API.G_EXC_ERROR;
4420: END IF;
4421: END IF;
4422: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4541: FND_MSG_PUB.ADD;

4537: WHEN OTHERS THEN
4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4539: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');
4540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4541: FND_MSG_PUB.ADD;
4542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4543: END find_persons;
4544:
4545: PROCEDURE find_persons (

Line 4609: FND_MSG_PUB.ADD;

4605: WHEN OTHERS THEN
4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4607: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');
4608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4609: FND_MSG_PUB.ADD;
4610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4611: END find_party_details;
4612:
4613: PROCEDURE find_duplicate_parties (

Line 4726: FND_MSG_PUB.ADD;

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

Line 4811: FND_MSG_PUB.ADD;

4807: WHEN OTHERS THEN
4808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4809: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');
4810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4811: FND_MSG_PUB.ADD;
4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4813: END find_duplicate_party_sites;
4814:
4815: PROCEDURE find_duplicate_contacts (

Line 4900: FND_MSG_PUB.ADD;

4896: WHEN OTHERS THEN
4897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4898: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');
4899: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4900: FND_MSG_PUB.ADD;
4901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4902: END find_duplicate_contacts;
4903:
4904: PROCEDURE find_duplicate_contact_points (

Line 4973: FND_MSG_PUB.ADD;

4969: WHEN OTHERS THEN
4970: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4971: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');
4972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4973: FND_MSG_PUB.ADD;
4974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4975: END find_duplicate_contact_points;
4976:
4977: PROCEDURE find_parties_dynamic (

Line 5330: FND_MSG_PUB.ADD;

5326: WHEN OTHERS THEN
5327: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5328: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');
5329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5330: FND_MSG_PUB.ADD;
5331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5332: END call_api_dynamic;
5333:
5334:

Line 5575: FND_MSG_PUB.ADD;

5571: WHEN OTHERS THEN
5572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5573: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');
5574: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5575: FND_MSG_PUB.ADD;
5576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5577: END get_matching_party_sites;
5578:
5579:

Line 5804: FND_MSG_PUB.ADD;

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

Line 5946: FND_MSG_PUB.ADD;

5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5948: END get_matching_contact_points;
5949:
5950: /**********************************************************

Line 6187: FND_MSG_PUB.ADD;

6183: WHEN OTHERS THEN
6184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');
6186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6187: FND_MSG_PUB.ADD;
6188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6189: END get_score_details;
6190:
6191:

Line 6310: FND_MSG_PUB.ADD;

6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6312: END get_party_for_search;
6313:
6314: PROCEDURE get_search_criteria (

Line 6362: FND_MSG_PUB.ADD;

6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6364: END get_search_criteria;
6365:
6366:

Line 6427: FND_MSG_PUB.ADD;

6423: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6424: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6425: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6427: FND_MSG_PUB.ADD;
6428: RAISE FND_API.G_EXC_ERROR;
6429: END get_party_rec;
6430:
6431: /************************************************

Line 6491: FND_MSG_PUB.ADD;

6487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6489: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6491: FND_MSG_PUB.ADD;
6492: RAISE FND_API.G_EXC_ERROR;
6493: END get_party_site_rec;
6494:
6495: /************************************************

Line 6549: FND_MSG_PUB.ADD;

6545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6546: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6547: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_ERROR;
6551: END get_contact_rec;
6552:
6553: /************************************************

Line 6605: FND_MSG_PUB.ADD;

6601: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6602: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6603: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6605: FND_MSG_PUB.ADD;
6606: RAISE FND_API.G_EXC_ERROR;
6607: END get_contact_point_rec;
6608:
6609: /************************************************

Line 6779: FND_MSG_PUB.ADD;

6775: WHEN OTHERS THEN
6776: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6777: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6778: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6779: FND_MSG_PUB.ADD;
6780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6781: END;
6782:
6783:

Line 7020: FND_MSG_PUB.ADD;

7016: WHEN OTHERS THEN
7017: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7018: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7020: FND_MSG_PUB.ADD;
7021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7022: END;
7023:
7024:

Line 7077: FND_MSG_PUB.ADD;

7073: WHEN OTHERS THEN
7074: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7075: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7076: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7077: FND_MSG_PUB.ADD;
7078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7079: END;
7080:
7081:

Line 7208: FND_MSG_PUB.ADD;

7204: WHEN OTHERS THEN
7205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7208: FND_MSG_PUB.ADD;
7209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7210: END;
7211:
7212:

Line 7233: FND_MSG_PUB.ADD;

7229: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7230: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7231: ) THEN
7232: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7233: FND_MSG_PUB.ADD;
7234: RAISE FND_API.G_EXC_ERROR;
7235: END IF;
7236: END LOOP;
7237:

Line 7303: FND_MSG_PUB.ADD;

7299: WHEN OTHERS THEN
7300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7301: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7303: FND_MSG_PUB.ADD;
7304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7305: END check_prim_cond;
7306:
7307: /************************************************

Line 7367: FND_MSG_PUB.ADD;

7363: WHEN OTHERS THEN
7364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7365: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7367: FND_MSG_PUB.ADD;
7368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7369: END check_party_site_cond;
7370:
7371: /************************************************

Line 7423: FND_MSG_PUB.ADD;

7419: WHEN OTHERS THEN
7420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7421: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7423: FND_MSG_PUB.ADD;
7424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7425: END check_contact_cond;
7426:
7427: /************************************************

Line 7444: FND_MSG_PUB.ADD;

7440:
7441: FOR I IN 1..p_contact_point_list.COUNT LOOP
7442: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7443: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7444: FND_MSG_PUB.ADD;
7445: RAISE FND_API.G_EXC_ERROR;
7446: END IF;
7447: END LOOP;
7448:

Line 7470: FND_MSG_PUB.ADD;

7466: WHEN OTHERS THEN
7467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7468: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7470: FND_MSG_PUB.ADD;
7471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7472: END check_contact_point_cond;
7473:
7474: FUNCTION check_staged RETURN BOOLEAN IS