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.

[Home] [Help]

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

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

Line 1575: RAISE FND_API.G_EXC_ERROR;

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

Line 1579: RAISE FND_API.G_EXC_ERROR;

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

Line 1584: RAISE FND_API.G_EXC_UNEXPECTED_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:
1588: PROCEDURE open_party_site_cursor(

Line 1816: RAISE FND_API.G_EXC_ERROR;

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

Line 1820: RAISE FND_API.G_EXC_ERROR;

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

Line 1824: RAISE FND_API.G_EXC_ERROR;

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

Line 1829: RAISE FND_API.G_EXC_UNEXPECTED_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:
1833: PROCEDURE open_contact_cursor(

Line 1963: RAISE FND_API.G_EXC_ERROR;

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

Line 1967: RAISE FND_API.G_EXC_ERROR;

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

Line 1971: RAISE FND_API.G_EXC_ERROR;

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

Line 1976: RAISE FND_API.G_EXC_UNEXPECTED_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:
1980: PROCEDURE open_contact_pt_cursor(

Line 2236: RAISE FND_API.G_EXC_ERROR;

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

Line 2240: RAISE FND_API.G_EXC_ERROR;

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

Line 2244: RAISE FND_API.G_EXC_ERROR;

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

Line 2249: RAISE FND_API.G_EXC_UNEXPECTED_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:
2253:

Line 2504: RAISE FND_API.G_EXC_ERROR;

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

Line 2552: RAISE FND_API.G_EXC_ERROR;

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

Line 2625: RAISE FND_API.G_EXC_ERROR;

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

Line 2737: RAISE FND_API.G_EXC_ERROR;

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

Line 2848: RAISE FND_API.G_EXC_ERROR;

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

Line 2992: RAISE FND_API.G_EXC_ERROR;

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
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);

Line 3000: RAISE FND_API.G_EXC_ERROR;

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
3004: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3242: WHEN FND_API.G_EXC_ERROR THEN

3238: END IF;
3239: EXCEPTION
3240: WHEN L_RETURN_IMM_EXC THEN
3241: RETURN;
3242: WHEN FND_API.G_EXC_ERROR THEN
3243: RAISE FND_API.G_EXC_ERROR;
3244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3246: WHEN OTHERS THEN

Line 3243: RAISE FND_API.G_EXC_ERROR;

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

Line 3244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3240: WHEN L_RETURN_IMM_EXC THEN
3241: RETURN;
3242: WHEN FND_API.G_EXC_ERROR THEN
3243: RAISE FND_API.G_EXC_ERROR;
3244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 3245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3241: RETURN;
3242: WHEN FND_API.G_EXC_ERROR THEN
3243: RAISE FND_API.G_EXC_ERROR;
3244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 3251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
3255: p_rule_id IN NUMBER,

Line 3446: RAISE FND_API.G_EXC_ERROR;

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

Line 3494: RAISE FND_API.G_EXC_ERROR;

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

Line 3530: RAISE FND_API.G_EXC_ERROR;

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

Line 3534: RAISE FND_API.G_EXC_ERROR;

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

Line 3536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
3538: END;
3539:
3540: /** Private procedure to acquire and score at party site level ***/

Line 3606: RAISE FND_API.G_EXC_ERROR;

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

Line 3795: RAISE FND_API.G_EXC_ERROR;

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

Line 3883: RAISE FND_API.G_EXC_ERROR;

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
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);

Line 3891: RAISE FND_API.G_EXC_ERROR;

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
3895: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4031: WHEN FND_API.G_EXC_ERROR THEN

4027: END IF;
4028: EXCEPTION
4029: WHEN L_RETURN_IMM_EXC THEN
4030: RETURN;
4031: WHEN FND_API.G_EXC_ERROR THEN
4032: RAISE FND_API.G_EXC_ERROR;
4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: WHEN OTHERS THEN

Line 4032: RAISE FND_API.G_EXC_ERROR;

4028: EXCEPTION
4029: WHEN L_RETURN_IMM_EXC THEN
4030: RETURN;
4031: WHEN FND_API.G_EXC_ERROR THEN
4032: RAISE FND_API.G_EXC_ERROR;
4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: WHEN OTHERS THEN
4036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4029: WHEN L_RETURN_IMM_EXC THEN
4030: RETURN;
4031: WHEN FND_API.G_EXC_ERROR THEN
4032: RAISE FND_API.G_EXC_ERROR;
4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4030: RETURN;
4031: WHEN FND_API.G_EXC_ERROR THEN
4032: RAISE FND_API.G_EXC_ERROR;
4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4044: p_rule_id IN NUMBER,

Line 4099: WHEN FND_API.G_EXC_ERROR THEN

4095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4096: 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);
4097: END IF;
4098: EXCEPTION
4099: WHEN FND_API.G_EXC_ERROR THEN
4100: RAISE FND_API.G_EXC_ERROR;
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: WHEN OTHERS THEN

Line 4100: RAISE FND_API.G_EXC_ERROR;

4096: 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);
4097: END IF;
4098: EXCEPTION
4099: WHEN FND_API.G_EXC_ERROR THEN
4100: RAISE FND_API.G_EXC_ERROR;
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: WHEN OTHERS THEN
4104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4097: END IF;
4098: EXCEPTION
4099: WHEN FND_API.G_EXC_ERROR THEN
4100: RAISE FND_API.G_EXC_ERROR;
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4098: EXCEPTION
4099: WHEN FND_API.G_EXC_ERROR THEN
4100: RAISE FND_API.G_EXC_ERROR;
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4112: p_rule_id IN NUMBER,

Line 4216: WHEN FND_API.G_EXC_ERROR THEN

4212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4213: 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);
4214: END IF;
4215: EXCEPTION
4216: WHEN FND_API.G_EXC_ERROR THEN
4217: RAISE FND_API.G_EXC_ERROR;
4218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: WHEN OTHERS THEN

Line 4217: RAISE FND_API.G_EXC_ERROR;

4213: 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);
4214: END IF;
4215: EXCEPTION
4216: WHEN FND_API.G_EXC_ERROR THEN
4217: RAISE FND_API.G_EXC_ERROR;
4218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: WHEN OTHERS THEN
4221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4214: END IF;
4215: EXCEPTION
4216: WHEN FND_API.G_EXC_ERROR THEN
4217: RAISE FND_API.G_EXC_ERROR;
4218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4215: EXCEPTION
4216: WHEN FND_API.G_EXC_ERROR THEN
4217: RAISE FND_API.G_EXC_ERROR;
4218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4229: p_rule_id IN NUMBER,

Line 4301: WHEN FND_API.G_EXC_ERROR THEN

4297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4298: 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);
4299: END IF;
4300: EXCEPTION
4301: WHEN FND_API.G_EXC_ERROR THEN
4302: RAISE FND_API.G_EXC_ERROR;
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4305: WHEN OTHERS THEN

Line 4302: RAISE FND_API.G_EXC_ERROR;

4298: 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);
4299: END IF;
4300: EXCEPTION
4301: WHEN FND_API.G_EXC_ERROR THEN
4302: RAISE FND_API.G_EXC_ERROR;
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4305: WHEN OTHERS THEN
4306: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4299: END IF;
4300: EXCEPTION
4301: WHEN FND_API.G_EXC_ERROR THEN
4302: RAISE FND_API.G_EXC_ERROR;
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4300: EXCEPTION
4301: WHEN FND_API.G_EXC_ERROR THEN
4302: RAISE FND_API.G_EXC_ERROR;
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4314: p_rule_id IN NUMBER,

Line 4390: WHEN FND_API.G_EXC_ERROR THEN

4386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4387: 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);
4388: END IF;
4389: EXCEPTION
4390: WHEN FND_API.G_EXC_ERROR THEN
4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN

Line 4391: RAISE FND_API.G_EXC_ERROR;

4387: 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);
4388: END IF;
4389: EXCEPTION
4390: WHEN FND_API.G_EXC_ERROR THEN
4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4388: END IF;
4389: EXCEPTION
4390: WHEN FND_API.G_EXC_ERROR THEN
4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4389: EXCEPTION
4390: WHEN FND_API.G_EXC_ERROR THEN
4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4403: p_rule_id IN NUMBER,

Line 4463: WHEN FND_API.G_EXC_ERROR THEN

4459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4460: 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);
4461: END IF;
4462: EXCEPTION
4463: WHEN FND_API.G_EXC_ERROR THEN
4464: RAISE FND_API.G_EXC_ERROR;
4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4467: WHEN OTHERS THEN

Line 4464: RAISE FND_API.G_EXC_ERROR;

4460: 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);
4461: END IF;
4462: EXCEPTION
4463: WHEN FND_API.G_EXC_ERROR THEN
4464: RAISE FND_API.G_EXC_ERROR;
4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4467: WHEN OTHERS THEN
4468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4461: END IF;
4462: EXCEPTION
4463: WHEN FND_API.G_EXC_ERROR THEN
4464: RAISE FND_API.G_EXC_ERROR;
4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4462: EXCEPTION
4463: WHEN FND_API.G_EXC_ERROR THEN
4464: RAISE FND_API.G_EXC_ERROR;
4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4476: p_rule_id IN NUMBER,

Line 4768: WHEN FND_API.G_EXC_ERROR THEN

4764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4765: 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);
4766: END IF;
4767: EXCEPTION
4768: WHEN FND_API.G_EXC_ERROR THEN
4769: RAISE FND_API.G_EXC_ERROR;
4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4772: WHEN OTHERS THEN

Line 4769: RAISE FND_API.G_EXC_ERROR;

4765: 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);
4766: END IF;
4767: EXCEPTION
4768: WHEN FND_API.G_EXC_ERROR THEN
4769: RAISE FND_API.G_EXC_ERROR;
4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4772: WHEN OTHERS THEN
4773: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4766: END IF;
4767: EXCEPTION
4768: WHEN FND_API.G_EXC_ERROR THEN
4769: RAISE FND_API.G_EXC_ERROR;
4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4767: EXCEPTION
4768: WHEN FND_API.G_EXC_ERROR THEN
4769: RAISE FND_API.G_EXC_ERROR;
4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
4781: PROCEDURE get_matching_party_sites (

Line 5004: WHEN FND_API.G_EXC_ERROR THEN

5000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5001: 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);
5002: END IF;
5003: EXCEPTION
5004: WHEN FND_API.G_EXC_ERROR THEN
5005: RAISE FND_API.G_EXC_ERROR;
5006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5008: WHEN OTHERS THEN

Line 5005: RAISE FND_API.G_EXC_ERROR;

5001: 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);
5002: END IF;
5003: EXCEPTION
5004: WHEN FND_API.G_EXC_ERROR THEN
5005: RAISE FND_API.G_EXC_ERROR;
5006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5008: WHEN OTHERS THEN
5009: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5002: END IF;
5003: EXCEPTION
5004: WHEN FND_API.G_EXC_ERROR THEN
5005: RAISE FND_API.G_EXC_ERROR;
5006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 5007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5003: EXCEPTION
5004: WHEN FND_API.G_EXC_ERROR THEN
5005: RAISE FND_API.G_EXC_ERROR;
5006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
5017: PROCEDURE get_matching_contacts (

Line 5233: WHEN FND_API.G_EXC_ERROR THEN

5229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5230: 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);
5231: END IF;
5232: EXCEPTION
5233: WHEN FND_API.G_EXC_ERROR THEN
5234: RAISE FND_API.G_EXC_ERROR;
5235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5237: WHEN OTHERS THEN

Line 5234: RAISE FND_API.G_EXC_ERROR;

5230: 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);
5231: END IF;
5232: EXCEPTION
5233: WHEN FND_API.G_EXC_ERROR THEN
5234: RAISE FND_API.G_EXC_ERROR;
5235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5237: WHEN OTHERS THEN
5238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5231: END IF;
5232: EXCEPTION
5233: WHEN FND_API.G_EXC_ERROR THEN
5234: RAISE FND_API.G_EXC_ERROR;
5235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 5236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5232: EXCEPTION
5233: WHEN FND_API.G_EXC_ERROR THEN
5234: RAISE FND_API.G_EXC_ERROR;
5235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
5246: PROCEDURE get_matching_contact_points (

Line 5373: WHEN FND_API.G_EXC_ERROR THEN

5369: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5370: 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);
5371: END IF;
5372: EXCEPTION
5373: WHEN FND_API.G_EXC_ERROR THEN
5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN

Line 5374: RAISE FND_API.G_EXC_ERROR;

5370: 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);
5371: END IF;
5372: EXCEPTION
5373: WHEN FND_API.G_EXC_ERROR THEN
5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5371: END IF;
5372: EXCEPTION
5373: WHEN FND_API.G_EXC_ERROR THEN
5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5372: EXCEPTION
5373: WHEN FND_API.G_EXC_ERROR THEN
5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: /**********************************************************
5386: This procedure finds the score details for a specific party that

Line 5591: WHEN FND_API.G_EXC_ERROR THEN

5587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5588: 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);
5589: END IF;
5590: EXCEPTION
5591: WHEN FND_API.G_EXC_ERROR THEN
5592: RAISE FND_API.G_EXC_ERROR;
5593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5595: WHEN OTHERS THEN

Line 5592: RAISE FND_API.G_EXC_ERROR;

5588: 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);
5589: END IF;
5590: EXCEPTION
5591: WHEN FND_API.G_EXC_ERROR THEN
5592: RAISE FND_API.G_EXC_ERROR;
5593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5595: WHEN OTHERS THEN
5596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5589: END IF;
5590: EXCEPTION
5591: WHEN FND_API.G_EXC_ERROR THEN
5592: RAISE FND_API.G_EXC_ERROR;
5593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 5594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5590: EXCEPTION
5591: WHEN FND_API.G_EXC_ERROR THEN
5592: RAISE FND_API.G_EXC_ERROR;
5593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5714: WHEN FND_API.G_EXC_ERROR THEN

5710: END LOOP;
5711: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5712: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5713: EXCEPTION
5714: WHEN FND_API.G_EXC_ERROR THEN
5715: RAISE FND_API.G_EXC_ERROR;
5716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5718: WHEN OTHERS THEN

Line 5715: RAISE FND_API.G_EXC_ERROR;

5711: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5712: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5713: EXCEPTION
5714: WHEN FND_API.G_EXC_ERROR THEN
5715: RAISE FND_API.G_EXC_ERROR;
5716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5712: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5713: EXCEPTION
5714: WHEN FND_API.G_EXC_ERROR THEN
5715: RAISE FND_API.G_EXC_ERROR;
5716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5713: EXCEPTION
5714: WHEN FND_API.G_EXC_ERROR THEN
5715: RAISE FND_API.G_EXC_ERROR;
5716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
5727: p_party_id IN NUMBER,

Line 5766: WHEN FND_API.G_EXC_ERROR THEN

5762: END IF;
5763: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5764: END IF;
5765: EXCEPTION
5766: WHEN FND_API.G_EXC_ERROR THEN
5767: RAISE FND_API.G_EXC_ERROR;
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: WHEN OTHERS THEN

Line 5767: RAISE FND_API.G_EXC_ERROR;

5763: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5764: END IF;
5765: EXCEPTION
5766: WHEN FND_API.G_EXC_ERROR THEN
5767: RAISE FND_API.G_EXC_ERROR;
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: WHEN OTHERS THEN
5771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5764: END IF;
5765: EXCEPTION
5766: WHEN FND_API.G_EXC_ERROR THEN
5767: RAISE FND_API.G_EXC_ERROR;
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: WHEN OTHERS THEN
5771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5772: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5765: EXCEPTION
5766: WHEN FND_API.G_EXC_ERROR THEN
5767: RAISE FND_API.G_EXC_ERROR;
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5840: RAISE FND_API.G_EXC_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: /************************************************
5844: This procedure retrieves the match rule party site attributes into

Line 5896: RAISE FND_API.G_EXC_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: /************************************************
5900: This procedure retrieves the match rule contact attributes into

Line 5954: RAISE FND_API.G_EXC_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: /************************************************
5958: This procedure retrieves the match rule contact point attributes into

Line 6008: RAISE FND_API.G_EXC_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: /************************************************
6012: This procedure maps a search record from the logical

Line 6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6489: RAISE FND_API.G_EXC_ERROR;

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:
6493: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 6524: WHEN FND_API.G_EXC_ERROR THEN

6520: END IF;
6521: END LOOP;
6522: RETURN FALSE;
6523: EXCEPTION
6524: WHEN FND_API.G_EXC_ERROR THEN
6525: RAISE FND_API.G_EXC_ERROR;
6526: WHEN OTHERS THEN
6527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6528: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6525: RAISE FND_API.G_EXC_ERROR;

6521: END LOOP;
6522: RETURN FALSE;
6523: EXCEPTION
6524: WHEN FND_API.G_EXC_ERROR THEN
6525: RAISE FND_API.G_EXC_ERROR;
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 );

Line 6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: /************************************************
6535: This procedure checks if the input search condition

Line 6585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: /************************************************
6589: This procedure checks if the input search condition

Line 6639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: /************************************************
6643: This procedure checks if the input search condition

Line 6660: RAISE FND_API.G_EXC_ERROR;

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:
6664: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
6688: