[Home] [Help]
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;
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;
796: WHEN OTHERS THEN
797: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
798: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
802: END;
803:
804:
816: WHEN OTHERS THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
818: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END;
823:
824:
836: WHEN OTHERS THEN
837: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
838: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
839: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END;
843:
844:
856: WHEN OTHERS THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
858: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END;
863:
864: PROCEDURE init_score_context (
923: p_party_site_list,
924: p_contact_list,
925: p_contact_point_list) THEN
926: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
931: 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);
1181: END IF;
1182: IF lengthb(l_party_contains_str) > 4000 THEN
1183: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1184: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1185: FND_MSG_PUB.ADD;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: IF (p_match_str = ' AND ' OR p_party_max_score
1250: -- Add the search criteria to query string
1251: IF lengthb(l_contains_str) > 4000 THEN
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_ERROR;
1256: END IF;
1257: x_denorm_str := l_den_contains_str;
1258: RETURN l_contains_str;
1294: -- Add the search criteria to query string
1295: IF lengthb(l_contains_str) > 4000 THEN
1296: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1297: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1298: FND_MSG_PUB.ADD;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301: x_denorm_str := l_den_contains_str;
1302: RETURN l_contains_str;
1339: -- Add the search criteria to query string
1340: IF lengthb(l_contains_str) > 4000 THEN
1341: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1342: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1343: FND_MSG_PUB.ADD;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346: x_denorm_str := l_den_contains_str;
1347: RETURN l_contains_str;
1566: exception
1567: when others then
1568: if (instrb(SQLERRM,'DRG-51030')>0) then
1569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1570: FND_MSG_PUB.ADD;
1571: RAISE FND_API.G_EXC_ERROR;
1572: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1574: FND_MSG_PUB.ADD;
1570: FND_MSG_PUB.ADD;
1571: RAISE FND_API.G_EXC_ERROR;
1572: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1574: FND_MSG_PUB.ADD;
1575: RAISE FND_API.G_EXC_ERROR;
1576: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1578: FND_MSG_PUB.ADD;
1574: FND_MSG_PUB.ADD;
1575: RAISE FND_API.G_EXC_ERROR;
1576: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1578: FND_MSG_PUB.ADD;
1579: RAISE FND_API.G_EXC_ERROR;
1580: else
1581: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1579: RAISE FND_API.G_EXC_ERROR;
1580: else
1581: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1583: FND_MSG_PUB.ADD;
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: end if;
1586: END;
1587:
1811: exception
1812: when others then
1813: if (instrb(SQLERRM,'DRG-51030')>0) then
1814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1815: FND_MSG_PUB.ADD;
1816: RAISE FND_API.G_EXC_ERROR;
1817: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1819: FND_MSG_PUB.ADD;
1815: FND_MSG_PUB.ADD;
1816: RAISE FND_API.G_EXC_ERROR;
1817: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1819: FND_MSG_PUB.ADD;
1820: RAISE FND_API.G_EXC_ERROR;
1821: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1822: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1823: FND_MSG_PUB.ADD;
1819: FND_MSG_PUB.ADD;
1820: RAISE FND_API.G_EXC_ERROR;
1821: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1822: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1823: FND_MSG_PUB.ADD;
1824: RAISE FND_API.G_EXC_ERROR;
1825: else
1826: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1827: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1824: RAISE FND_API.G_EXC_ERROR;
1825: else
1826: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1827: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1830: end if;
1831: END;
1832:
1958: exception
1959: when others then
1960: if (instrb(SQLERRM,'DRG-51030')>0) then
1961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1962: FND_MSG_PUB.ADD;
1963: RAISE FND_API.G_EXC_ERROR;
1964: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1966: FND_MSG_PUB.ADD;
1962: FND_MSG_PUB.ADD;
1963: RAISE FND_API.G_EXC_ERROR;
1964: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1966: FND_MSG_PUB.ADD;
1967: RAISE FND_API.G_EXC_ERROR;
1968: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1969: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1970: FND_MSG_PUB.ADD;
1966: FND_MSG_PUB.ADD;
1967: RAISE FND_API.G_EXC_ERROR;
1968: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1969: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1970: FND_MSG_PUB.ADD;
1971: RAISE FND_API.G_EXC_ERROR;
1972: else
1973: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1971: RAISE FND_API.G_EXC_ERROR;
1972: else
1973: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1975: FND_MSG_PUB.ADD;
1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1977: end if;
1978: END;
1979:
2231: exception
2232: when others then
2233: if (instrb(SQLERRM,'DRG-51030')>0) then
2234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2235: FND_MSG_PUB.ADD;
2236: RAISE FND_API.G_EXC_ERROR;
2237: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2239: FND_MSG_PUB.ADD;
2235: FND_MSG_PUB.ADD;
2236: RAISE FND_API.G_EXC_ERROR;
2237: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2239: FND_MSG_PUB.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2243: FND_MSG_PUB.ADD;
2239: FND_MSG_PUB.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2243: FND_MSG_PUB.ADD;
2244: RAISE FND_API.G_EXC_ERROR;
2245: else
2246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2244: RAISE FND_API.G_EXC_ERROR;
2245: else
2246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2248: FND_MSG_PUB.ADD;
2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2250: end if;
2251: END;
2252:
2499: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2500: 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);
2501: END IF;
2502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2503: FND_MSG_PUB.ADD;
2504: RAISE FND_API.G_EXC_ERROR;
2505: ELSE
2506: push_eval;
2507: RETURN;
2547: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2548: 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);
2549: END IF;
2550: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2551: FND_MSG_PUB.ADD;
2552: RAISE FND_API.G_EXC_ERROR;
2553: ELSE
2554: push_eval;
2555: RETURN;
2620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2621: 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);
2622: END IF;
2623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2624: FND_MSG_PUB.ADD;
2625: RAISE FND_API.G_EXC_ERROR;
2626: ELSE
2627: push_eval;
2628: RETURN;
2732: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2733: 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);
2734: END IF;
2735: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2736: FND_MSG_PUB.ADD;
2737: RAISE FND_API.G_EXC_ERROR;
2738: ELSE
2739: push_eval;
2740: RETURN;
2843: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2844: 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);
2845: END IF;
2846: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2847: FND_MSG_PUB.ADD;
2848: RAISE FND_API.G_EXC_ERROR;
2849: ELSE
2850: push_eval;
2851: RETURN;
2987: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2988: 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);
2989: END IF;
2990: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2991: FND_MSG_PUB.ADD;
2992: RAISE FND_API.G_EXC_ERROR;
2993: END IF;
2994: ELSE
2995: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2995: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2996: 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);
2997: END IF;
2998: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2999: FND_MSG_PUB.ADD;
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: END IF;
3003: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3246: WHEN OTHERS THEN
3247: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3248: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');
3249: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3250: FND_MSG_PUB.ADD;
3251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3252: END find_parties;
3253:
3254: PROCEDURE find_persons (
3441: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3442: 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);
3443: END IF;
3444: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3445: FND_MSG_PUB.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: ELSE
3448: push_eval;
3449: RETURN;
3489: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3490: 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);
3491: END IF;
3492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3493: FND_MSG_PUB.ADD;
3494: RAISE FND_API.G_EXC_ERROR;
3495: ELSE
3496: push_eval;
3497: RETURN;
3525: exception
3526: when others then
3527: if (instrb(SQLERRM,'DRG-51030')>0) then
3528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3529: FND_MSG_PUB.ADD;
3530: RAISE FND_API.G_EXC_ERROR;
3531: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3533: FND_MSG_PUB.ADD;
3529: FND_MSG_PUB.ADD;
3530: RAISE FND_API.G_EXC_ERROR;
3531: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3533: FND_MSG_PUB.ADD;
3534: RAISE FND_API.G_EXC_ERROR;
3535: else
3536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3537: end if;
3601: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3602: 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);
3603: END IF;
3604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3605: FND_MSG_PUB.ADD;
3606: RAISE FND_API.G_EXC_ERROR;
3607: ELSE
3608: push_eval;
3609: RETURN;
3790: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3791: 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);
3792: END IF;
3793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3794: FND_MSG_PUB.ADD;
3795: RAISE FND_API.G_EXC_ERROR;
3796: ELSE
3797: push_eval;
3798: RETURN;
3878: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3879: 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);
3880: END IF;
3881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3882: FND_MSG_PUB.ADD;
3883: RAISE FND_API.G_EXC_ERROR;
3884: END IF;
3885: ELSE
3886: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3886: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3887: 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);
3888: END IF;
3889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893: END IF;
3894: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4035: WHEN OTHERS THEN
4036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4037: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');
4038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4039: FND_MSG_PUB.ADD;
4040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4041: END find_persons;
4042:
4043: PROCEDURE find_persons (
4103: WHEN OTHERS THEN
4104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_party_details');
4106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4107: FND_MSG_PUB.ADD;
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END find_party_details;
4110:
4111: PROCEDURE find_duplicate_parties (
4220: WHEN OTHERS THEN
4221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4222: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');
4223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4224: FND_MSG_PUB.ADD;
4225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4226: END find_duplicate_parties;
4227:
4228: PROCEDURE find_duplicate_party_sites (
4305: WHEN OTHERS THEN
4306: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4307: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');
4308: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4309: FND_MSG_PUB.ADD;
4310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4311: END find_duplicate_party_sites;
4312:
4313: PROCEDURE find_duplicate_contacts (
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');
4397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4398: FND_MSG_PUB.ADD;
4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4400: END find_duplicate_contacts;
4401:
4402: PROCEDURE find_duplicate_contact_points (
4467: WHEN OTHERS THEN
4468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');
4470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4471: FND_MSG_PUB.ADD;
4472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4473: END find_duplicate_contact_points;
4474:
4475: PROCEDURE find_parties_dynamic (
4772: WHEN OTHERS THEN
4773: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4774: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');
4775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4776: FND_MSG_PUB.ADD;
4777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4778: END call_api_dynamic;
4779:
4780:
5008: WHEN OTHERS THEN
5009: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5010: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');
5011: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5012: FND_MSG_PUB.ADD;
5013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5014: END get_matching_party_sites;
5015:
5016:
5237: WHEN OTHERS THEN
5238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');
5240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5241: FND_MSG_PUB.ADD;
5242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5243: END get_matching_contacts;
5244:
5245:
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');
5380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END get_matching_contact_points;
5384:
5385: /**********************************************************
5595: WHEN OTHERS THEN
5596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5599: FND_MSG_PUB.ADD;
5600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5601: END get_score_details;
5602:
5603:
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5722: FND_MSG_PUB.ADD;
5723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5724: END get_party_for_search;
5725:
5726: PROCEDURE get_search_criteria (
5770: WHEN OTHERS THEN
5771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5772: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5773: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5774: FND_MSG_PUB.ADD;
5775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5776: END get_search_criteria;
5777:
5778:
5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END get_party_rec;
5842:
5843: /************************************************
5891: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5892: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5893: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5895: FND_MSG_PUB.ADD;
5896: RAISE FND_API.G_EXC_ERROR;
5897: END get_party_site_rec;
5898:
5899: /************************************************
5949: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5950: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5951: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5953: FND_MSG_PUB.ADD;
5954: RAISE FND_API.G_EXC_ERROR;
5955: END get_contact_rec;
5956:
5957: /************************************************
6003: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6004: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6005: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6007: FND_MSG_PUB.ADD;
6008: RAISE FND_API.G_EXC_ERROR;
6009: END get_contact_point_rec;
6010:
6011: /************************************************
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6175: FND_MSG_PUB.ADD;
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: END;
6178:
6179:
6289: WHEN OTHERS THEN
6290: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6291: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6293: FND_MSG_PUB.ADD;
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: END;
6296:
6297:
6392: WHEN OTHERS THEN
6393: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6394: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6398: END;
6399:
6400:
6460: WHEN OTHERS THEN
6461: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6462: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6463: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6464: FND_MSG_PUB.ADD;
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: END;
6467:
6468:
6484: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6485: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6486: ) THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6488: FND_MSG_PUB.ADD;
6489: RAISE FND_API.G_EXC_ERROR;
6490: END IF;
6491: END LOOP;
6492:
6526: WHEN OTHERS THEN
6527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6528: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6530: FND_MSG_PUB.ADD;
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: END check_prim_cond;
6533:
6534: /************************************************
6580: WHEN OTHERS THEN
6581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6582: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6583: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6584: FND_MSG_PUB.ADD;
6585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6586: END check_party_site_cond;
6587:
6588: /************************************************
6634: WHEN OTHERS THEN
6635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6636: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6638: FND_MSG_PUB.ADD;
6639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6640: END check_contact_cond;
6641:
6642: /************************************************
6655:
6656: FOR I IN 1..p_contact_point_list.COUNT LOOP
6657: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6658: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6659: FND_MSG_PUB.ADD;
6660: RAISE FND_API.G_EXC_ERROR;
6661: END IF;
6662: END LOOP;
6663:
6679: WHEN OTHERS THEN
6680: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6685: END check_contact_point_cond;
6686:
6687: FUNCTION check_staged RETURN BOOLEAN IS