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

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

Line 1946: FND_MSG_PUB.ADD;

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

Line 1950: FND_MSG_PUB.ADD;

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

Line 1955: FND_MSG_PUB.ADD;

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

Line 2187: FND_MSG_PUB.ADD;

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

Line 2191: FND_MSG_PUB.ADD;

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

Line 2195: FND_MSG_PUB.ADD;

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

Line 2200: FND_MSG_PUB.ADD;

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

Line 2334: FND_MSG_PUB.ADD;

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

Line 2338: FND_MSG_PUB.ADD;

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

Line 2342: FND_MSG_PUB.ADD;

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

Line 2347: FND_MSG_PUB.ADD;

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

Line 2607: FND_MSG_PUB.ADD;

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

Line 2611: FND_MSG_PUB.ADD;

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

Line 2615: FND_MSG_PUB.ADD;

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

Line 2620: FND_MSG_PUB.ADD;

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

Line 2883: FND_MSG_PUB.ADD;

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

Line 2933: FND_MSG_PUB.ADD;

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

Line 3006: FND_MSG_PUB.ADD;

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

Line 3118: FND_MSG_PUB.ADD;

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

Line 3229: FND_MSG_PUB.ADD;

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

Line 3454: FND_MSG_PUB.ADD;

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

Line 3462: FND_MSG_PUB.ADD;

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

Line 3670: FND_MSG_PUB.ADD;

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

Line 3873: FND_MSG_PUB.ADD;

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

Line 3923: FND_MSG_PUB.ADD;

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

Line 3959: FND_MSG_PUB.ADD;

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

Line 3963: FND_MSG_PUB.ADD;

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

Line 4035: FND_MSG_PUB.ADD;

4031: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4032: 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);
4033: END IF;
4034: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4035: FND_MSG_PUB.ADD;
4036: RAISE FND_API.G_EXC_ERROR;
4037: ELSE
4038: push_eval;
4039: RETURN;

Line 4294: FND_MSG_PUB.ADD;

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

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: ELSE
4411: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4415: FND_MSG_PUB.ADD;

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

Line 4538: FND_MSG_PUB.ADD;

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

Line 4606: FND_MSG_PUB.ADD;

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

Line 4723: FND_MSG_PUB.ADD;

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

Line 4808: FND_MSG_PUB.ADD;

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

Line 4897: FND_MSG_PUB.ADD;

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

Line 4970: FND_MSG_PUB.ADD;

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

Line 5327: FND_MSG_PUB.ADD;

5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5327: FND_MSG_PUB.ADD;
5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5329: END call_api_dynamic;
5330:
5331:

Line 5572: FND_MSG_PUB.ADD;

5568: WHEN OTHERS THEN
5569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5570: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5574: END get_matching_party_sites;
5575:
5576:

Line 5800: FND_MSG_PUB.ADD;

5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5802: END get_matching_contacts;
5803:
5804:

Line 5942: FND_MSG_PUB.ADD;

5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5944: END get_matching_contact_points;
5945:
5946: /**********************************************************

Line 6184: FND_MSG_PUB.ADD;

6180: WHEN OTHERS THEN
6181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6184: FND_MSG_PUB.ADD;
6185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6186: END get_score_details;
6187:
6188:

Line 6294: FND_MSG_PUB.ADD;

6290: WHEN OTHERS THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6294: FND_MSG_PUB.ADD;
6295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6296: END get_party_for_search;
6297:
6298: PROCEDURE get_search_criteria (

Line 6340: FND_MSG_PUB.ADD;

6336: WHEN OTHERS THEN
6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6338: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6339: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6340: FND_MSG_PUB.ADD;
6341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6342: END get_search_criteria;
6343:
6344:

Line 6407: FND_MSG_PUB.ADD;

6403: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6404: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6405: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_ERROR;
6409: END get_party_rec;
6410:
6411: /************************************************

Line 6471: FND_MSG_PUB.ADD;

6467: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6469: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6471: FND_MSG_PUB.ADD;
6472: RAISE FND_API.G_EXC_ERROR;
6473: END get_party_site_rec;
6474:
6475: /************************************************

Line 6527: FND_MSG_PUB.ADD;

6523: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6524: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6525: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_ERROR;
6529: END get_contact_rec;
6530:
6531: /************************************************

Line 6583: FND_MSG_PUB.ADD;

6579: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6581: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6583: FND_MSG_PUB.ADD;
6584: RAISE FND_API.G_EXC_ERROR;
6585: END get_contact_point_rec;
6586:
6587: /************************************************

Line 6776: FND_MSG_PUB.ADD;

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

Line 7017: FND_MSG_PUB.ADD;

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

Line 7059: FND_MSG_PUB.ADD;

7055: WHEN OTHERS THEN
7056: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7057: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7058: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7059: FND_MSG_PUB.ADD;
7060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7061: END;
7062:
7063:

Line 7190: FND_MSG_PUB.ADD;

7186: WHEN OTHERS THEN
7187: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7188: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7190: FND_MSG_PUB.ADD;
7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7192: END;
7193:
7194:

Line 7215: FND_MSG_PUB.ADD;

7211: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7212: OR p_contact_point_list(I).URL IS NOT NULL
7213: ) THEN
7214: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7215: FND_MSG_PUB.ADD;
7216: RAISE FND_API.G_EXC_ERROR;
7217: END IF;
7218: END LOOP;
7219:

Line 7283: FND_MSG_PUB.ADD;

7279: WHEN OTHERS THEN
7280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7281: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7283: FND_MSG_PUB.ADD;
7284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7285: END check_prim_cond;
7286:
7287: /************************************************

Line 7347: FND_MSG_PUB.ADD;

7343: WHEN OTHERS THEN
7344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7345: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7347: FND_MSG_PUB.ADD;
7348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7349: END check_party_site_cond;
7350:
7351: /************************************************

Line 7395: FND_MSG_PUB.ADD;

7391: WHEN OTHERS THEN
7392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7393: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7395: FND_MSG_PUB.ADD;
7396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7397: END check_contact_cond;
7398:
7399: /************************************************

Line 7416: FND_MSG_PUB.ADD;

7412:
7413: FOR I IN 1..p_contact_point_list.COUNT LOOP
7414: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7415: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7416: FND_MSG_PUB.ADD;
7417: RAISE FND_API.G_EXC_ERROR;
7418: END IF;
7419: END LOOP;
7420:

Line 7442: FND_MSG_PUB.ADD;

7438: WHEN OTHERS THEN
7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7444: END check_contact_point_cond;
7445:
7446: FUNCTION check_staged RETURN BOOLEAN IS