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

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

Line 1061: FND_MSG_PUB.ADD;

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

Line 1081: FND_MSG_PUB.ADD;

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

Line 1101: FND_MSG_PUB.ADD;

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

Line 1168: FND_MSG_PUB.ADD;

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

1456: END IF;
1457: IF lengthb(l_party_contains_str) > 4000 THEN
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_ERROR;
1462: END IF;
1463: IF (p_match_str = ' AND ' OR p_party_max_score 1464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1569: FND_MSG_PUB.ADD;

1565: -- Add the search criteria to query string
1566: IF lengthb(l_contains_str) > 4000 THEN
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1568: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: x_denorm_str := l_den_contains_str;
1573: RETURN l_contains_str;

Line 1666: FND_MSG_PUB.ADD;

1662: -- Add the search criteria to query string
1663: IF lengthb(l_contains_str) > 4000 THEN
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1665: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1666: FND_MSG_PUB.ADD;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: x_denorm_str := l_den_contains_str;
1670: RETURN l_contains_str;

Line 1940: FND_MSG_PUB.ADD;

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

Line 1944: FND_MSG_PUB.ADD;

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

Line 1948: FND_MSG_PUB.ADD;

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

Line 1953: FND_MSG_PUB.ADD;

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

Line 2185: FND_MSG_PUB.ADD;

2181: exception
2182: when others then
2183: if (instrb(SQLERRM,'DRG-51030')>0) then
2184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2185: FND_MSG_PUB.ADD;
2186: RAISE FND_API.G_EXC_ERROR;
2187: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2189: FND_MSG_PUB.ADD;

Line 2189: FND_MSG_PUB.ADD;

2185: FND_MSG_PUB.ADD;
2186: RAISE FND_API.G_EXC_ERROR;
2187: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2189: FND_MSG_PUB.ADD;
2190: RAISE FND_API.G_EXC_ERROR;
2191: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2193: FND_MSG_PUB.ADD;

Line 2193: FND_MSG_PUB.ADD;

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

Line 2198: FND_MSG_PUB.ADD;

2194: RAISE FND_API.G_EXC_ERROR;
2195: else
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2198: FND_MSG_PUB.ADD;
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2200: end if;
2201: END;
2202:

Line 2332: FND_MSG_PUB.ADD;

2328: exception
2329: when others then
2330: if (instrb(SQLERRM,'DRG-51030')>0) then
2331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2332: FND_MSG_PUB.ADD;
2333: RAISE FND_API.G_EXC_ERROR;
2334: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2336: FND_MSG_PUB.ADD;

Line 2336: FND_MSG_PUB.ADD;

2332: FND_MSG_PUB.ADD;
2333: RAISE FND_API.G_EXC_ERROR;
2334: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2336: FND_MSG_PUB.ADD;
2337: RAISE FND_API.G_EXC_ERROR;
2338: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2340: FND_MSG_PUB.ADD;

Line 2340: FND_MSG_PUB.ADD;

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

Line 2345: FND_MSG_PUB.ADD;

2341: RAISE FND_API.G_EXC_ERROR;
2342: else
2343: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2344: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2345: FND_MSG_PUB.ADD;
2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2347: end if;
2348: END;
2349:

Line 2605: FND_MSG_PUB.ADD;

2601: exception
2602: when others then
2603: if (instrb(SQLERRM,'DRG-51030')>0) then
2604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2609: FND_MSG_PUB.ADD;

Line 2609: FND_MSG_PUB.ADD;

2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2609: FND_MSG_PUB.ADD;
2610: RAISE FND_API.G_EXC_ERROR;
2611: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2612: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2613: FND_MSG_PUB.ADD;

Line 2613: FND_MSG_PUB.ADD;

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

Line 2618: FND_MSG_PUB.ADD;

2614: RAISE FND_API.G_EXC_ERROR;
2615: else
2616: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2618: FND_MSG_PUB.ADD;
2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2620: end if;
2621: END;
2622:

Line 2880: FND_MSG_PUB.ADD;

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

Line 2928: FND_MSG_PUB.ADD;

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

Line 3001: FND_MSG_PUB.ADD;

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

Line 3113: FND_MSG_PUB.ADD;

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

Line 3224: FND_MSG_PUB.ADD;

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

Line 3449: FND_MSG_PUB.ADD;

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

Line 3457: FND_MSG_PUB.ADD;

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

Line 3665: FND_MSG_PUB.ADD;

3661: WHEN OTHERS THEN
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3663: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3665: FND_MSG_PUB.ADD;
3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3667: END find_parties;
3668:
3669: PROCEDURE find_persons (

Line 3867: FND_MSG_PUB.ADD;

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

Line 3915: FND_MSG_PUB.ADD;

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

Line 3951: FND_MSG_PUB.ADD;

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

Line 3955: FND_MSG_PUB.ADD;

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

Line 4027: FND_MSG_PUB.ADD;

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

Line 4286: FND_MSG_PUB.ADD;

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

Line 4399: FND_MSG_PUB.ADD;

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

Line 4407: FND_MSG_PUB.ADD;

4403: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4404: 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);
4405: END IF;
4406: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4407: FND_MSG_PUB.ADD;
4408: RAISE FND_API.G_EXC_ERROR;
4409: END IF;
4410: END IF;
4411: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4530: FND_MSG_PUB.ADD;

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

Line 4598: FND_MSG_PUB.ADD;

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

Line 4715: FND_MSG_PUB.ADD;

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

Line 4800: FND_MSG_PUB.ADD;

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

Line 4889: FND_MSG_PUB.ADD;

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

Line 4962: FND_MSG_PUB.ADD;

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

Line 5319: FND_MSG_PUB.ADD;

5315: WHEN OTHERS THEN
5316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5317: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5319: FND_MSG_PUB.ADD;
5320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5321: END call_api_dynamic;
5322:
5323:

Line 5564: FND_MSG_PUB.ADD;

5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5566: END get_matching_party_sites;
5567:
5568:

Line 5792: FND_MSG_PUB.ADD;

5788: WHEN OTHERS THEN
5789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5790: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5792: FND_MSG_PUB.ADD;
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: END get_matching_contacts;
5795:
5796:

Line 5934: FND_MSG_PUB.ADD;

5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: END get_matching_contact_points;
5937:
5938: /**********************************************************

Line 6173: FND_MSG_PUB.ADD;

6169: WHEN OTHERS THEN
6170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6173: FND_MSG_PUB.ADD;
6174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6175: END get_score_details;
6176:
6177:

Line 6283: FND_MSG_PUB.ADD;

6279: WHEN OTHERS THEN
6280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6281: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6283: FND_MSG_PUB.ADD;
6284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6285: END get_party_for_search;
6286:
6287: PROCEDURE get_search_criteria (

Line 6329: FND_MSG_PUB.ADD;

6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6329: FND_MSG_PUB.ADD;
6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6331: END get_search_criteria;
6332:
6333:

Line 6396: FND_MSG_PUB.ADD;

6392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_ERROR;
6398: END get_party_rec;
6399:
6400: /************************************************

Line 6460: FND_MSG_PUB.ADD;

6456: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6458: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: END get_party_site_rec;
6463:
6464: /************************************************

Line 6516: FND_MSG_PUB.ADD;

6512: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6513: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6514: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6516: FND_MSG_PUB.ADD;
6517: RAISE FND_API.G_EXC_ERROR;
6518: END get_contact_rec;
6519:
6520: /************************************************

Line 6572: FND_MSG_PUB.ADD;

6568: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6570: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6572: FND_MSG_PUB.ADD;
6573: RAISE FND_API.G_EXC_ERROR;
6574: END get_contact_point_rec;
6575:
6576: /************************************************

Line 6765: FND_MSG_PUB.ADD;

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

Line 7006: FND_MSG_PUB.ADD;

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

Line 7048: FND_MSG_PUB.ADD;

7044: WHEN OTHERS THEN
7045: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7046: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7048: FND_MSG_PUB.ADD;
7049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7050: END;
7051:
7052:

Line 7179: FND_MSG_PUB.ADD;

7175: WHEN OTHERS THEN
7176: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7177: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7178: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7179: FND_MSG_PUB.ADD;
7180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7181: END;
7182:
7183:

Line 7204: FND_MSG_PUB.ADD;

7200: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7201: OR p_contact_point_list(I).URL IS NOT NULL
7202: ) THEN
7203: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7204: FND_MSG_PUB.ADD;
7205: RAISE FND_API.G_EXC_ERROR;
7206: END IF;
7207: END LOOP;
7208:

Line 7272: FND_MSG_PUB.ADD;

7268: WHEN OTHERS THEN
7269: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7270: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7272: FND_MSG_PUB.ADD;
7273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7274: END check_prim_cond;
7275:
7276: /************************************************

Line 7336: FND_MSG_PUB.ADD;

7332: WHEN OTHERS THEN
7333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7334: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7336: FND_MSG_PUB.ADD;
7337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7338: END check_party_site_cond;
7339:
7340: /************************************************

Line 7384: FND_MSG_PUB.ADD;

7380: WHEN OTHERS THEN
7381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7382: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7383: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7384: FND_MSG_PUB.ADD;
7385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7386: END check_contact_cond;
7387:
7388: /************************************************

Line 7405: FND_MSG_PUB.ADD;

7401:
7402: FOR I IN 1..p_contact_point_list.COUNT LOOP
7403: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7404: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7405: FND_MSG_PUB.ADD;
7406: RAISE FND_API.G_EXC_ERROR;
7407: END IF;
7408: END LOOP;
7409:

Line 7431: FND_MSG_PUB.ADD;

7427: WHEN OTHERS THEN
7428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7429: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7431: FND_MSG_PUB.ADD;
7432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7433: END check_contact_point_cond;
7434:
7435: FUNCTION check_staged RETURN BOOLEAN IS