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_6 dependencies on FND_API

Line 102: RAISE FND_API.G_EXC_ERROR;

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;
106: RAISE FND_API.G_EXC_ERROR;

Line 106: RAISE FND_API.G_EXC_ERROR;

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;
110: END;

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
110: END;
111:
112:

Line 801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
805: /************************************************

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
825: /************************************************

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
845: /************************************************

Line 861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
865: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 928: RAISE FND_API.G_EXC_ERROR;

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);
932: END IF;

Line 1186: RAISE FND_API.G_EXC_ERROR;

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 1189: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1190: hz_utility_v2pub.debug(p_message=>'party contains string returned by init_search is an AND between these strings ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1255: RAISE FND_API.G_EXC_ERROR;

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;
1259: END;

Line 1299: RAISE FND_API.G_EXC_ERROR;

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;
1303: END;

Line 1344: RAISE FND_API.G_EXC_ERROR;

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;
1348: END;

Line 1569: RAISE FND_API.G_EXC_ERROR;

1565: when others then
1566: if (instrb(SQLERRM,'DRG-51030')>0) then
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1568: FND_MSG_PUB.ADD;
1569: RAISE FND_API.G_EXC_ERROR;
1570: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;

Line 1573: RAISE FND_API.G_EXC_ERROR;

1569: RAISE FND_API.G_EXC_ERROR;
1570: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1576: FND_MSG_PUB.ADD;
1577: RAISE FND_API.G_EXC_ERROR;

Line 1577: RAISE FND_API.G_EXC_ERROR;

1573: RAISE FND_API.G_EXC_ERROR;
1574: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1576: FND_MSG_PUB.ADD;
1577: RAISE FND_API.G_EXC_ERROR;
1578: else
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1581: FND_MSG_PUB.ADD;

Line 1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1578: else
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: end if;
1584: END;
1585:
1586: PROCEDURE open_party_site_cursor(

Line 1814: RAISE FND_API.G_EXC_ERROR;

1810: when others then
1811: if (instrb(SQLERRM,'DRG-51030')>0) then
1812: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1813: FND_MSG_PUB.ADD;
1814: RAISE FND_API.G_EXC_ERROR;
1815: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;

Line 1818: RAISE FND_API.G_EXC_ERROR;

1814: RAISE FND_API.G_EXC_ERROR;
1815: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1821: FND_MSG_PUB.ADD;
1822: RAISE FND_API.G_EXC_ERROR;

Line 1822: RAISE FND_API.G_EXC_ERROR;

1818: RAISE FND_API.G_EXC_ERROR;
1819: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1821: FND_MSG_PUB.ADD;
1822: RAISE FND_API.G_EXC_ERROR;
1823: else
1824: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1826: FND_MSG_PUB.ADD;

Line 1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1823: else
1824: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1828: end if;
1829: END;
1830:
1831: PROCEDURE open_contact_cursor(

Line 1961: RAISE FND_API.G_EXC_ERROR;

1957: when others then
1958: if (instrb(SQLERRM,'DRG-51030')>0) then
1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;

Line 1965: RAISE FND_API.G_EXC_ERROR;

1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;

Line 1969: RAISE FND_API.G_EXC_ERROR;

1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;

Line 1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;
1976: END;
1977:
1978: PROCEDURE open_contact_pt_cursor(

Line 2234: RAISE FND_API.G_EXC_ERROR;

2230: when others then
2231: if (instrb(SQLERRM,'DRG-51030')>0) then
2232: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;
2235: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2237: FND_MSG_PUB.ADD;
2238: RAISE FND_API.G_EXC_ERROR;

Line 2238: RAISE FND_API.G_EXC_ERROR;

2234: RAISE FND_API.G_EXC_ERROR;
2235: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2237: FND_MSG_PUB.ADD;
2238: RAISE FND_API.G_EXC_ERROR;
2239: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;

Line 2242: RAISE FND_API.G_EXC_ERROR;

2238: RAISE FND_API.G_EXC_ERROR;
2239: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: else
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2245: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2246: FND_MSG_PUB.ADD;

Line 2247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2243: else
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2245: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2248: end if;
2249: END;
2250:
2251:

Line 2501: RAISE FND_API.G_EXC_ERROR;

2497: 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);
2498: END IF;
2499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2500: FND_MSG_PUB.ADD;
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSE
2503: push_eval;
2504: RETURN;
2505: END IF;

Line 2549: RAISE FND_API.G_EXC_ERROR;

2545: 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);
2546: END IF;
2547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2548: FND_MSG_PUB.ADD;
2549: RAISE FND_API.G_EXC_ERROR;
2550: ELSE
2551: push_eval;
2552: RETURN;
2553: END IF;

Line 2622: RAISE FND_API.G_EXC_ERROR;

2618: 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);
2619: END IF;
2620: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2621: FND_MSG_PUB.ADD;
2622: RAISE FND_API.G_EXC_ERROR;
2623: ELSE
2624: push_eval;
2625: RETURN;
2626: END IF;

Line 2734: RAISE FND_API.G_EXC_ERROR;

2730: 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);
2731: END IF;
2732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2733: FND_MSG_PUB.ADD;
2734: RAISE FND_API.G_EXC_ERROR;
2735: ELSE
2736: push_eval;
2737: RETURN;
2738: END IF;

Line 2845: RAISE FND_API.G_EXC_ERROR;

2841: 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);
2842: END IF;
2843: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2844: FND_MSG_PUB.ADD;
2845: RAISE FND_API.G_EXC_ERROR;
2846: ELSE
2847: push_eval;
2848: RETURN;
2849: END IF;

Line 2989: RAISE FND_API.G_EXC_ERROR;

2985: 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);
2986: END IF;
2987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2988: FND_MSG_PUB.ADD;
2989: RAISE FND_API.G_EXC_ERROR;
2990: END IF;
2991: ELSE
2992: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2993: 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);

Line 2997: RAISE FND_API.G_EXC_ERROR;

2993: 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);
2994: END IF;
2995: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2996: FND_MSG_PUB.ADD;
2997: RAISE FND_API.G_EXC_ERROR;
2998: END IF;
2999: END IF;
3000: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3001: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3239: WHEN FND_API.G_EXC_ERROR THEN

3235: END IF;
3236: EXCEPTION
3237: WHEN L_RETURN_IMM_EXC THEN
3238: RETURN;
3239: WHEN FND_API.G_EXC_ERROR THEN
3240: RAISE FND_API.G_EXC_ERROR;
3241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: WHEN OTHERS THEN

Line 3240: RAISE FND_API.G_EXC_ERROR;

3236: EXCEPTION
3237: WHEN L_RETURN_IMM_EXC THEN
3238: RETURN;
3239: WHEN FND_API.G_EXC_ERROR THEN
3240: RAISE FND_API.G_EXC_ERROR;
3241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: WHEN OTHERS THEN
3244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3237: WHEN L_RETURN_IMM_EXC THEN
3238: RETURN;
3239: WHEN FND_API.G_EXC_ERROR THEN
3240: RAISE FND_API.G_EXC_ERROR;
3241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: WHEN OTHERS THEN
3244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3245: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');

Line 3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3238: RETURN;
3239: WHEN FND_API.G_EXC_ERROR THEN
3240: RAISE FND_API.G_EXC_ERROR;
3241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: WHEN OTHERS THEN
3244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3245: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');
3246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3245: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');
3246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3247: FND_MSG_PUB.ADD;
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3249: END find_parties;
3250:
3251: PROCEDURE find_persons (
3252: p_rule_id IN NUMBER,

Line 3442: RAISE FND_API.G_EXC_ERROR;

3438: 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);
3439: END IF;
3440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3441: FND_MSG_PUB.ADD;
3442: RAISE FND_API.G_EXC_ERROR;
3443: ELSE
3444: push_eval;
3445: RETURN;
3446: END IF;

Line 3490: RAISE FND_API.G_EXC_ERROR;

3486: 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);
3487: END IF;
3488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3489: FND_MSG_PUB.ADD;
3490: RAISE FND_API.G_EXC_ERROR;
3491: ELSE
3492: push_eval;
3493: RETURN;
3494: END IF;

Line 3526: RAISE FND_API.G_EXC_ERROR;

3522: when others then
3523: if (instrb(SQLERRM,'DRG-51030')>0) then
3524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3525: FND_MSG_PUB.ADD;
3526: RAISE FND_API.G_EXC_ERROR;
3527: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3529: FND_MSG_PUB.ADD;
3530: RAISE FND_API.G_EXC_ERROR;

Line 3530: RAISE FND_API.G_EXC_ERROR;

3526: RAISE FND_API.G_EXC_ERROR;
3527: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3529: FND_MSG_PUB.ADD;
3530: RAISE FND_API.G_EXC_ERROR;
3531: else
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3533: end if;
3534: END;

Line 3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3529: FND_MSG_PUB.ADD;
3530: RAISE FND_API.G_EXC_ERROR;
3531: else
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3533: end if;
3534: END;
3535:
3536: /** Private procedure to acquire and score at party site level ***/

Line 3602: RAISE FND_API.G_EXC_ERROR;

3598: 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);
3599: END IF;
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;
3603: ELSE
3604: push_eval;
3605: RETURN;
3606: END IF;

Line 3791: RAISE FND_API.G_EXC_ERROR;

3787: 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);
3788: END IF;
3789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3790: FND_MSG_PUB.ADD;
3791: RAISE FND_API.G_EXC_ERROR;
3792: ELSE
3793: push_eval;
3794: RETURN;
3795: END IF;

Line 3879: RAISE FND_API.G_EXC_ERROR;

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

Line 3887: RAISE FND_API.G_EXC_ERROR;

3883: 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);
3884: END IF;
3885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3886: FND_MSG_PUB.ADD;
3887: RAISE FND_API.G_EXC_ERROR;
3888: END IF;
3889: END IF;
3890: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3891: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4027: WHEN FND_API.G_EXC_ERROR THEN

4023: END IF;
4024: EXCEPTION
4025: WHEN L_RETURN_IMM_EXC THEN
4026: RETURN;
4027: WHEN FND_API.G_EXC_ERROR THEN
4028: RAISE FND_API.G_EXC_ERROR;
4029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: WHEN OTHERS THEN

Line 4028: RAISE FND_API.G_EXC_ERROR;

4024: EXCEPTION
4025: WHEN L_RETURN_IMM_EXC THEN
4026: RETURN;
4027: WHEN FND_API.G_EXC_ERROR THEN
4028: RAISE FND_API.G_EXC_ERROR;
4029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: WHEN OTHERS THEN
4032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4025: WHEN L_RETURN_IMM_EXC THEN
4026: RETURN;
4027: WHEN FND_API.G_EXC_ERROR THEN
4028: RAISE FND_API.G_EXC_ERROR;
4029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: WHEN OTHERS THEN
4032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4033: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');

Line 4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4026: RETURN;
4027: WHEN FND_API.G_EXC_ERROR THEN
4028: RAISE FND_API.G_EXC_ERROR;
4029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: WHEN OTHERS THEN
4032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4033: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');
4034: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4033: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');
4034: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4035: FND_MSG_PUB.ADD;
4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4037: END find_persons;
4038:
4039: PROCEDURE find_persons (
4040: p_rule_id IN NUMBER,

Line 4095: WHEN FND_API.G_EXC_ERROR THEN

4091: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4092: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4093: END IF;
4094: EXCEPTION
4095: WHEN FND_API.G_EXC_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN

Line 4096: RAISE FND_API.G_EXC_ERROR;

4092: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4093: END IF;
4094: EXCEPTION
4095: WHEN FND_API.G_EXC_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN
4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4093: END IF;
4094: EXCEPTION
4095: WHEN FND_API.G_EXC_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN
4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_party_details');

Line 4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4094: EXCEPTION
4095: WHEN FND_API.G_EXC_ERROR THEN
4096: RAISE FND_API.G_EXC_ERROR;
4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN
4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_party_details');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_party_details');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4103: FND_MSG_PUB.ADD;
4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4105: END find_party_details;
4106:
4107: PROCEDURE find_duplicate_parties (
4108: p_rule_id IN NUMBER,

Line 4212: WHEN FND_API.G_EXC_ERROR THEN

4208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4209: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4210: END IF;
4211: EXCEPTION
4212: WHEN FND_API.G_EXC_ERROR THEN
4213: RAISE FND_API.G_EXC_ERROR;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4216: WHEN OTHERS THEN

Line 4213: RAISE FND_API.G_EXC_ERROR;

4209: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4210: END IF;
4211: EXCEPTION
4212: WHEN FND_API.G_EXC_ERROR THEN
4213: RAISE FND_API.G_EXC_ERROR;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4216: WHEN OTHERS THEN
4217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4210: END IF;
4211: EXCEPTION
4212: WHEN FND_API.G_EXC_ERROR THEN
4213: RAISE FND_API.G_EXC_ERROR;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4216: WHEN OTHERS THEN
4217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');

Line 4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4211: EXCEPTION
4212: WHEN FND_API.G_EXC_ERROR THEN
4213: RAISE FND_API.G_EXC_ERROR;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4216: WHEN OTHERS THEN
4217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');
4219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');
4219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4222: END find_duplicate_parties;
4223:
4224: PROCEDURE find_duplicate_party_sites (
4225: p_rule_id IN NUMBER,

Line 4297: WHEN FND_API.G_EXC_ERROR THEN

4293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4294: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4295: END IF;
4296: EXCEPTION
4297: WHEN FND_API.G_EXC_ERROR THEN
4298: RAISE FND_API.G_EXC_ERROR;
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: WHEN OTHERS THEN

Line 4298: RAISE FND_API.G_EXC_ERROR;

4294: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4295: END IF;
4296: EXCEPTION
4297: WHEN FND_API.G_EXC_ERROR THEN
4298: RAISE FND_API.G_EXC_ERROR;
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: WHEN OTHERS THEN
4302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4295: END IF;
4296: EXCEPTION
4297: WHEN FND_API.G_EXC_ERROR THEN
4298: RAISE FND_API.G_EXC_ERROR;
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: WHEN OTHERS THEN
4302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4303: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');

Line 4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4296: EXCEPTION
4297: WHEN FND_API.G_EXC_ERROR THEN
4298: RAISE FND_API.G_EXC_ERROR;
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: WHEN OTHERS THEN
4302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4303: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');
4304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4303: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');
4304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4305: FND_MSG_PUB.ADD;
4306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4307: END find_duplicate_party_sites;
4308:
4309: PROCEDURE find_duplicate_contacts (
4310: p_rule_id IN NUMBER,

Line 4386: WHEN FND_API.G_EXC_ERROR THEN

4382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4383: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4384: END IF;
4385: EXCEPTION
4386: WHEN FND_API.G_EXC_ERROR THEN
4387: RAISE FND_API.G_EXC_ERROR;
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4390: WHEN OTHERS THEN

Line 4387: RAISE FND_API.G_EXC_ERROR;

4383: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4384: END IF;
4385: EXCEPTION
4386: WHEN FND_API.G_EXC_ERROR THEN
4387: RAISE FND_API.G_EXC_ERROR;
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4390: WHEN OTHERS THEN
4391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4384: END IF;
4385: EXCEPTION
4386: WHEN FND_API.G_EXC_ERROR THEN
4387: RAISE FND_API.G_EXC_ERROR;
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4390: WHEN OTHERS THEN
4391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4392: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');

Line 4389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4385: EXCEPTION
4386: WHEN FND_API.G_EXC_ERROR THEN
4387: RAISE FND_API.G_EXC_ERROR;
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4390: WHEN OTHERS THEN
4391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4392: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');
4393: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4392: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');
4393: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4394: FND_MSG_PUB.ADD;
4395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4396: END find_duplicate_contacts;
4397:
4398: PROCEDURE find_duplicate_contact_points (
4399: p_rule_id IN NUMBER,

Line 4459: WHEN FND_API.G_EXC_ERROR THEN

4455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4456: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4457: END IF;
4458: EXCEPTION
4459: WHEN FND_API.G_EXC_ERROR THEN
4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN

Line 4460: RAISE FND_API.G_EXC_ERROR;

4456: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4457: END IF;
4458: EXCEPTION
4459: WHEN FND_API.G_EXC_ERROR THEN
4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4457: END IF;
4458: EXCEPTION
4459: WHEN FND_API.G_EXC_ERROR THEN
4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');

Line 4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4458: EXCEPTION
4459: WHEN FND_API.G_EXC_ERROR THEN
4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END find_duplicate_contact_points;
4470:
4471: PROCEDURE find_parties_dynamic (
4472: p_rule_id IN NUMBER,

Line 4764: WHEN FND_API.G_EXC_ERROR THEN

4760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4761: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4762: END IF;
4763: EXCEPTION
4764: WHEN FND_API.G_EXC_ERROR THEN
4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN

Line 4765: RAISE FND_API.G_EXC_ERROR;

4761: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4762: END IF;
4763: EXCEPTION
4764: WHEN FND_API.G_EXC_ERROR THEN
4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4762: END IF;
4763: EXCEPTION
4764: WHEN FND_API.G_EXC_ERROR THEN
4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');

Line 4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4763: EXCEPTION
4764: WHEN FND_API.G_EXC_ERROR THEN
4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4774: END call_api_dynamic;
4775:
4776:
4777: PROCEDURE get_matching_party_sites (

Line 5000: WHEN FND_API.G_EXC_ERROR THEN

4996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4997: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4998: END IF;
4999: EXCEPTION
5000: WHEN FND_API.G_EXC_ERROR THEN
5001: RAISE FND_API.G_EXC_ERROR;
5002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5004: WHEN OTHERS THEN

Line 5001: RAISE FND_API.G_EXC_ERROR;

4997: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4998: END IF;
4999: EXCEPTION
5000: WHEN FND_API.G_EXC_ERROR THEN
5001: RAISE FND_API.G_EXC_ERROR;
5002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5004: WHEN OTHERS THEN
5005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4998: END IF;
4999: EXCEPTION
5000: WHEN FND_API.G_EXC_ERROR THEN
5001: RAISE FND_API.G_EXC_ERROR;
5002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5004: WHEN OTHERS THEN
5005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5006: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');

Line 5003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4999: EXCEPTION
5000: WHEN FND_API.G_EXC_ERROR THEN
5001: RAISE FND_API.G_EXC_ERROR;
5002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5004: WHEN OTHERS THEN
5005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5006: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');
5007: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5006: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');
5007: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5008: FND_MSG_PUB.ADD;
5009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5010: END get_matching_party_sites;
5011:
5012:
5013: PROCEDURE get_matching_contacts (

Line 5229: WHEN FND_API.G_EXC_ERROR THEN

5225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5226: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5227: END IF;
5228: EXCEPTION
5229: WHEN FND_API.G_EXC_ERROR THEN
5230: RAISE FND_API.G_EXC_ERROR;
5231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5233: WHEN OTHERS THEN

Line 5230: RAISE FND_API.G_EXC_ERROR;

5226: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5227: END IF;
5228: EXCEPTION
5229: WHEN FND_API.G_EXC_ERROR THEN
5230: RAISE FND_API.G_EXC_ERROR;
5231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5233: WHEN OTHERS THEN
5234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5227: END IF;
5228: EXCEPTION
5229: WHEN FND_API.G_EXC_ERROR THEN
5230: RAISE FND_API.G_EXC_ERROR;
5231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5233: WHEN OTHERS THEN
5234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');

Line 5232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5228: EXCEPTION
5229: WHEN FND_API.G_EXC_ERROR THEN
5230: RAISE FND_API.G_EXC_ERROR;
5231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5233: WHEN OTHERS THEN
5234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');
5236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');
5236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5237: FND_MSG_PUB.ADD;
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239: END get_matching_contacts;
5240:
5241:
5242: PROCEDURE get_matching_contact_points (

Line 5369: WHEN FND_API.G_EXC_ERROR THEN

5365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5366: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5367: END IF;
5368: EXCEPTION
5369: WHEN FND_API.G_EXC_ERROR THEN
5370: RAISE FND_API.G_EXC_ERROR;
5371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5373: WHEN OTHERS THEN

Line 5370: RAISE FND_API.G_EXC_ERROR;

5366: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5367: END IF;
5368: EXCEPTION
5369: WHEN FND_API.G_EXC_ERROR THEN
5370: RAISE FND_API.G_EXC_ERROR;
5371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5373: WHEN OTHERS THEN
5374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5367: END IF;
5368: EXCEPTION
5369: WHEN FND_API.G_EXC_ERROR THEN
5370: RAISE FND_API.G_EXC_ERROR;
5371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5373: WHEN OTHERS THEN
5374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5375: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');

Line 5372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5368: EXCEPTION
5369: WHEN FND_API.G_EXC_ERROR THEN
5370: RAISE FND_API.G_EXC_ERROR;
5371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5373: WHEN OTHERS THEN
5374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5375: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5375: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5377: FND_MSG_PUB.ADD;
5378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5379: END get_matching_contact_points;
5380:
5381: /**********************************************************
5382: This procedure finds the score details for a specific party that

Line 5586: WHEN FND_API.G_EXC_ERROR THEN

5582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5583: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5584: END IF;
5585: EXCEPTION
5586: WHEN FND_API.G_EXC_ERROR THEN
5587: RAISE FND_API.G_EXC_ERROR;
5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5590: WHEN OTHERS THEN

Line 5587: RAISE FND_API.G_EXC_ERROR;

5583: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5584: END IF;
5585: EXCEPTION
5586: WHEN FND_API.G_EXC_ERROR THEN
5587: RAISE FND_API.G_EXC_ERROR;
5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5584: END IF;
5585: EXCEPTION
5586: WHEN FND_API.G_EXC_ERROR THEN
5587: RAISE FND_API.G_EXC_ERROR;
5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');

Line 5589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5585: EXCEPTION
5586: WHEN FND_API.G_EXC_ERROR THEN
5587: RAISE FND_API.G_EXC_ERROR;
5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5594: FND_MSG_PUB.ADD;
5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5596: END get_score_details;
5597:
5598:
5599: /************************************************

Line 5709: WHEN FND_API.G_EXC_ERROR THEN

5705: END LOOP;
5706: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5707: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5708: EXCEPTION
5709: WHEN FND_API.G_EXC_ERROR THEN
5710: RAISE FND_API.G_EXC_ERROR;
5711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5713: WHEN OTHERS THEN

Line 5710: RAISE FND_API.G_EXC_ERROR;

5706: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5707: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5708: EXCEPTION
5709: WHEN FND_API.G_EXC_ERROR THEN
5710: RAISE FND_API.G_EXC_ERROR;
5711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5707: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5708: EXCEPTION
5709: WHEN FND_API.G_EXC_ERROR THEN
5710: RAISE FND_API.G_EXC_ERROR;
5711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5708: EXCEPTION
5709: WHEN FND_API.G_EXC_ERROR THEN
5710: RAISE FND_API.G_EXC_ERROR;
5711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5717: FND_MSG_PUB.ADD;
5718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5719: END get_party_for_search;
5720:
5721: PROCEDURE get_search_criteria (
5722: p_party_id IN NUMBER,

Line 5761: WHEN FND_API.G_EXC_ERROR THEN

5757: END IF;
5758: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5759: END IF;
5760: EXCEPTION
5761: WHEN FND_API.G_EXC_ERROR THEN
5762: RAISE FND_API.G_EXC_ERROR;
5763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: WHEN OTHERS THEN

Line 5762: RAISE FND_API.G_EXC_ERROR;

5758: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5759: END IF;
5760: EXCEPTION
5761: WHEN FND_API.G_EXC_ERROR THEN
5762: RAISE FND_API.G_EXC_ERROR;
5763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: WHEN OTHERS THEN
5766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5759: END IF;
5760: EXCEPTION
5761: WHEN FND_API.G_EXC_ERROR THEN
5762: RAISE FND_API.G_EXC_ERROR;
5763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: WHEN OTHERS THEN
5766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5767: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5760: EXCEPTION
5761: WHEN FND_API.G_EXC_ERROR THEN
5762: RAISE FND_API.G_EXC_ERROR;
5763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: WHEN OTHERS THEN
5766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5767: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5767: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5769: FND_MSG_PUB.ADD;
5770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5771: END get_search_criteria;
5772:
5773:
5774: /************************************************

Line 5835: RAISE FND_API.G_EXC_ERROR;

5831: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_party_rec;
5837:
5838: /************************************************
5839: This procedure retrieves the match rule party site attributes into

Line 5891: RAISE FND_API.G_EXC_ERROR;

5887: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5888: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5890: FND_MSG_PUB.ADD;
5891: RAISE FND_API.G_EXC_ERROR;
5892: END get_party_site_rec;
5893:
5894: /************************************************
5895: This procedure retrieves the match rule contact attributes into

Line 5949: RAISE FND_API.G_EXC_ERROR;

5945: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5946: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_ERROR;
5950: END get_contact_rec;
5951:
5952: /************************************************
5953: This procedure retrieves the match rule contact point attributes into

Line 6003: RAISE FND_API.G_EXC_ERROR;

5999: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6000: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6001: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6002: FND_MSG_PUB.ADD;
6003: RAISE FND_API.G_EXC_ERROR;
6004: END get_contact_point_rec;
6005:
6006: /************************************************
6007: This procedure maps a search record from the logical

Line 6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6167: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6168: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6170: FND_MSG_PUB.ADD;
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: END;
6173:
6174:
6175: /************************************************

Line 6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6285: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6286: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6287: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6288: FND_MSG_PUB.ADD;
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: END;
6291:
6292:
6293: /************************************************

Line 6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6393: END;
6394:
6395:
6396: /************************************************

Line 6460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6456: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6459: FND_MSG_PUB.ADD;
6460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6461: END;
6462:
6463:
6464: /************************************************

Line 6484: RAISE FND_API.G_EXC_ERROR;

6480: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6481: ) THEN
6482: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6483: FND_MSG_PUB.ADD;
6484: RAISE FND_API.G_EXC_ERROR;
6485: END IF;
6486: END LOOP;
6487:
6488: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 6519: WHEN FND_API.G_EXC_ERROR THEN

6515: END IF;
6516: END LOOP;
6517: RETURN FALSE;
6518: EXCEPTION
6519: WHEN FND_API.G_EXC_ERROR THEN
6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN OTHERS THEN
6522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6523: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6520: RAISE FND_API.G_EXC_ERROR;

6516: END LOOP;
6517: RETURN FALSE;
6518: EXCEPTION
6519: WHEN FND_API.G_EXC_ERROR THEN
6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN OTHERS THEN
6522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6523: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6523: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6525: FND_MSG_PUB.ADD;
6526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6527: END check_prim_cond;
6528:
6529: /************************************************
6530: This procedure checks if the input search condition

Line 6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6577: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6581: END check_party_site_cond;
6582:
6583: /************************************************
6584: This procedure checks if the input search condition

Line 6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6631: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6635: END check_contact_cond;
6636:
6637: /************************************************
6638: This procedure checks if the input search condition

Line 6655: RAISE FND_API.G_EXC_ERROR;

6651: FOR I IN 1..p_contact_point_list.COUNT LOOP
6652: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6653: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;
6657: END LOOP;
6658:
6659: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6675: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6676: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6677: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6678: FND_MSG_PUB.ADD;
6679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6680: END check_contact_point_cond;
6681:
6682: FUNCTION check_staged RETURN BOOLEAN IS
6683: