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

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

Line 1949: FND_MSG_PUB.ADD;

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

Line 1953: FND_MSG_PUB.ADD;

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

Line 1958: FND_MSG_PUB.ADD;

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

Line 2190: FND_MSG_PUB.ADD;

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

Line 2194: FND_MSG_PUB.ADD;

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

Line 2198: FND_MSG_PUB.ADD;

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

Line 2203: FND_MSG_PUB.ADD;

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

Line 2337: FND_MSG_PUB.ADD;

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

Line 2341: FND_MSG_PUB.ADD;

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

Line 2345: FND_MSG_PUB.ADD;

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

Line 2350: FND_MSG_PUB.ADD;

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

Line 2610: FND_MSG_PUB.ADD;

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

Line 2614: FND_MSG_PUB.ADD;

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

Line 2618: FND_MSG_PUB.ADD;

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

Line 2623: FND_MSG_PUB.ADD;

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

Line 2884: FND_MSG_PUB.ADD;

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

Line 2932: FND_MSG_PUB.ADD;

2928: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2929: 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);
2930: END IF;
2931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_ERROR;
2934: ELSE
2935: push_eval;
2936: RETURN;

Line 3005: FND_MSG_PUB.ADD;

3001: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3002: 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);
3003: END IF;
3004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3005: FND_MSG_PUB.ADD;
3006: RAISE FND_API.G_EXC_ERROR;
3007: ELSE
3008: push_eval;
3009: RETURN;

Line 3117: FND_MSG_PUB.ADD;

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

Line 3228: FND_MSG_PUB.ADD;

3224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3225: 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);
3226: END IF;
3227: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_ERROR;
3230: ELSE
3231: push_eval;
3232: RETURN;

Line 3453: FND_MSG_PUB.ADD;

3449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3450: 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);
3451: END IF;
3452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3453: FND_MSG_PUB.ADD;
3454: RAISE FND_API.G_EXC_ERROR;
3455: END IF;
3456: ELSE
3457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3461: FND_MSG_PUB.ADD;

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

Line 3669: FND_MSG_PUB.ADD;

3665: WHEN OTHERS THEN
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3667: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3668: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3669: FND_MSG_PUB.ADD;
3670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3671: END find_parties;
3672:
3673: PROCEDURE find_persons (

Line 3870: FND_MSG_PUB.ADD;

3866: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3867: 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);
3868: END IF;
3869: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_ERROR;
3872: ELSE
3873: push_eval;
3874: RETURN;

Line 3918: FND_MSG_PUB.ADD;

3914: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3915: 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);
3916: END IF;
3917: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3918: FND_MSG_PUB.ADD;
3919: RAISE FND_API.G_EXC_ERROR;
3920: ELSE
3921: push_eval;
3922: RETURN;

Line 3954: FND_MSG_PUB.ADD;

3950: exception
3951: when others then
3952: if (instrb(SQLERRM,'DRG-51030')>0) then
3953: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3954: FND_MSG_PUB.ADD;
3955: RAISE FND_API.G_EXC_ERROR;
3956: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3958: FND_MSG_PUB.ADD;

Line 3958: FND_MSG_PUB.ADD;

3954: FND_MSG_PUB.ADD;
3955: RAISE FND_API.G_EXC_ERROR;
3956: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3958: FND_MSG_PUB.ADD;
3959: RAISE FND_API.G_EXC_ERROR;
3960: else
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: end if;

Line 4030: FND_MSG_PUB.ADD;

4026: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4027: 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);
4028: END IF;
4029: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4030: FND_MSG_PUB.ADD;
4031: RAISE FND_API.G_EXC_ERROR;
4032: ELSE
4033: push_eval;
4034: RETURN;

Line 4289: FND_MSG_PUB.ADD;

4285: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4286: 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);
4287: END IF;
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_ERROR;
4291: ELSE
4292: push_eval;
4293: RETURN;

Line 4402: FND_MSG_PUB.ADD;

4398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4399: 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);
4400: END IF;
4401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4402: FND_MSG_PUB.ADD;
4403: RAISE FND_API.G_EXC_ERROR;
4404: END IF;
4405: ELSE
4406: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

Line 4533: FND_MSG_PUB.ADD;

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

Line 4601: FND_MSG_PUB.ADD;

4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');
4600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4601: FND_MSG_PUB.ADD;
4602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4603: END find_party_details;
4604:
4605: PROCEDURE find_duplicate_parties (

Line 4718: FND_MSG_PUB.ADD;

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

Line 4803: FND_MSG_PUB.ADD;

4799: WHEN OTHERS THEN
4800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4801: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');
4802: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4803: FND_MSG_PUB.ADD;
4804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4805: END find_duplicate_party_sites;
4806:
4807: PROCEDURE find_duplicate_contacts (

Line 4892: FND_MSG_PUB.ADD;

4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4892: FND_MSG_PUB.ADD;
4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4894: END find_duplicate_contacts;
4895:
4896: PROCEDURE find_duplicate_contact_points (

Line 4965: FND_MSG_PUB.ADD;

4961: WHEN OTHERS THEN
4962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4963: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');
4964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4965: FND_MSG_PUB.ADD;
4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4967: END find_duplicate_contact_points;
4968:
4969: PROCEDURE find_parties_dynamic (

Line 5322: FND_MSG_PUB.ADD;

5318: WHEN OTHERS THEN
5319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5320: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');
5321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5322: FND_MSG_PUB.ADD;
5323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5324: END call_api_dynamic;
5325:
5326:

Line 5567: FND_MSG_PUB.ADD;

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

Line 5796: FND_MSG_PUB.ADD;

5792: WHEN OTHERS THEN
5793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5796: FND_MSG_PUB.ADD;
5797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5798: END get_matching_contacts;
5799:
5800:

Line 5938: FND_MSG_PUB.ADD;

5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5940: END get_matching_contact_points;
5941:
5942: /**********************************************************

Line 6176: FND_MSG_PUB.ADD;

6172: WHEN OTHERS THEN
6173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');
6175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6176: FND_MSG_PUB.ADD;
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: END get_score_details;
6179:
6180:

Line 6299: FND_MSG_PUB.ADD;

6295: WHEN OTHERS THEN
6296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6297: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6299: FND_MSG_PUB.ADD;
6300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6301: END get_party_for_search;
6302:
6303: PROCEDURE get_search_criteria (

Line 6351: FND_MSG_PUB.ADD;

6347: WHEN OTHERS THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6349: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6351: FND_MSG_PUB.ADD;
6352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6353: END get_search_criteria;
6354:
6355:

Line 6416: FND_MSG_PUB.ADD;

6412: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6413: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6414: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6415: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6416: FND_MSG_PUB.ADD;
6417: RAISE FND_API.G_EXC_ERROR;
6418: END get_party_rec;
6419:
6420: /************************************************

Line 6480: FND_MSG_PUB.ADD;

6476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6477: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;
6482: END get_party_site_rec;
6483:
6484: /************************************************

Line 6538: FND_MSG_PUB.ADD;

6534: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6535: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6536: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6538: FND_MSG_PUB.ADD;
6539: RAISE FND_API.G_EXC_ERROR;
6540: END get_contact_rec;
6541:
6542: /************************************************

Line 6594: FND_MSG_PUB.ADD;

6590: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6591: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6592: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6594: FND_MSG_PUB.ADD;
6595: RAISE FND_API.G_EXC_ERROR;
6596: END get_contact_point_rec;
6597:
6598: /************************************************

Line 6768: FND_MSG_PUB.ADD;

6764: WHEN OTHERS THEN
6765: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6766: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6768: FND_MSG_PUB.ADD;
6769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6770: END;
6771:
6772:

Line 7009: FND_MSG_PUB.ADD;

7005: WHEN OTHERS THEN
7006: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7007: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7009: FND_MSG_PUB.ADD;
7010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7011: END;
7012:
7013:

Line 7066: FND_MSG_PUB.ADD;

7062: WHEN OTHERS THEN
7063: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7064: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7066: FND_MSG_PUB.ADD;
7067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7068: END;
7069:
7070:

Line 7197: FND_MSG_PUB.ADD;

7193: WHEN OTHERS THEN
7194: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7195: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7197: FND_MSG_PUB.ADD;
7198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7199: END;
7200:
7201:

Line 7222: FND_MSG_PUB.ADD;

7218: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7219: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7220: ) THEN
7221: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7222: FND_MSG_PUB.ADD;
7223: RAISE FND_API.G_EXC_ERROR;
7224: END IF;
7225: END LOOP;
7226:

Line 7292: FND_MSG_PUB.ADD;

7288: WHEN OTHERS THEN
7289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7290: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7292: FND_MSG_PUB.ADD;
7293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7294: END check_prim_cond;
7295:
7296: /************************************************

Line 7356: FND_MSG_PUB.ADD;

7352: WHEN OTHERS THEN
7353: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7354: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7356: FND_MSG_PUB.ADD;
7357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7358: END check_party_site_cond;
7359:
7360: /************************************************

Line 7412: FND_MSG_PUB.ADD;

7408: WHEN OTHERS THEN
7409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7410: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7412: FND_MSG_PUB.ADD;
7413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7414: END check_contact_cond;
7415:
7416: /************************************************

Line 7433: FND_MSG_PUB.ADD;

7429:
7430: FOR I IN 1..p_contact_point_list.COUNT LOOP
7431: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7432: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7433: FND_MSG_PUB.ADD;
7434: RAISE FND_API.G_EXC_ERROR;
7435: END IF;
7436: END LOOP;
7437:

Line 7459: FND_MSG_PUB.ADD;

7455: WHEN OTHERS THEN
7456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7457: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7459: FND_MSG_PUB.ADD;
7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7461: END check_contact_point_cond;
7462:
7463: FUNCTION check_staged RETURN BOOLEAN IS