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

Line 72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

68: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
69: FND_MESSAGE.SET_TOKEN('PROC','check_parties_bulk');
70: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END check_parties_bulk ;
74:
75: /************************************************
76: This procedure checks if the input search condition

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

98: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
99: FND_MESSAGE.SET_TOKEN('PROC','check_party_sites_bulk');
100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END check_party_sites_bulk ;
104:
105: /************************************************
106: This procedure checks if the input search condition

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
128: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
130: FND_MSG_PUB.ADD;
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END check_contacts_bulk ;
133:
134: /************************************************
135: This procedure checks if the input search condition

Line 162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
159: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
161: FND_MSG_PUB.ADD;
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END check_cpts_bulk ;
164:
165: FUNCTION map_id (in_id NUMBER) RETURN NUMBER IS
166: l_newidx NUMBER;

Line 949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

945: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
946: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END;
951:
952:
953: /************************************************

Line 974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

970: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
971: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
973: FND_MSG_PUB.ADD;
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975: END;
976:
977:
978: /************************************************

Line 994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

990: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
991: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
993: FND_MSG_PUB.ADD;
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: END;
996:
997:
998: /************************************************

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1010: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1011: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1013: FND_MSG_PUB.ADD;
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END;
1016:
1017: PROCEDURE init_score_context (
1018: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1070: RAISE FND_API.G_EXC_ERROR;

1066: p_contact_list,
1067: p_contact_point_list) THEN
1068: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: HZ_DQM_SEARCH_UTIL.set_score;
1073: g_mappings.DELETE;
1074: g_party_site_stage_list.DELETE;

Line 1267: RAISE FND_API.G_EXC_ERROR;

1263: when others then
1264: if (instrb(SQLERRM,'DRG-51030')>0) then
1265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1266: FND_MSG_PUB.ADD;
1267: RAISE FND_API.G_EXC_ERROR;
1268: else
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: end if;
1271: END;

Line 1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1266: FND_MSG_PUB.ADD;
1267: RAISE FND_API.G_EXC_ERROR;
1268: else
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: end if;
1271: END;
1272:
1273: PROCEDURE open_party_site_cursor(

Line 1364: RAISE FND_API.G_EXC_ERROR;

1360: when others then
1361: if (instrb(SQLERRM,'DRG-51030')>0) then
1362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1363: FND_MSG_PUB.ADD;
1364: RAISE FND_API.G_EXC_ERROR;
1365: else
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: end if;
1368: END;

Line 1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1363: FND_MSG_PUB.ADD;
1364: RAISE FND_API.G_EXC_ERROR;
1365: else
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: end if;
1368: END;
1369:
1370: PROCEDURE open_contact_cursor(

Line 1465: RAISE FND_API.G_EXC_ERROR;

1461: when others then
1462: if (instrb(SQLERRM,'DRG-51030')>0) then
1463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1464: FND_MSG_PUB.ADD;
1465: RAISE FND_API.G_EXC_ERROR;
1466: else
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: end if;
1469: END;

Line 1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1464: FND_MSG_PUB.ADD;
1465: RAISE FND_API.G_EXC_ERROR;
1466: else
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: end if;
1469: END;
1470:
1471: PROCEDURE open_contact_pt_cursor(

Line 1606: RAISE FND_API.G_EXC_ERROR;

1602: when others then
1603: if (instrb(SQLERRM,'DRG-51030')>0) then
1604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1605: FND_MSG_PUB.ADD;
1606: RAISE FND_API.G_EXC_ERROR;
1607: else
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: end if;
1610: END;

Line 1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1605: FND_MSG_PUB.ADD;
1606: RAISE FND_API.G_EXC_ERROR;
1607: else
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: end if;
1610: END;
1611:
1612: FUNCTION get_new_score_rec (

Line 1821: RAISE FND_API.G_EXC_ERROR;

1817: 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);
1818: END IF;
1819: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: ELSE
1823: push_eval;
1824: RETURN;
1825: END IF;

Line 1890: RAISE FND_API.G_EXC_ERROR;

1886: 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);
1887: END IF;
1888: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1889: FND_MSG_PUB.ADD;
1890: RAISE FND_API.G_EXC_ERROR;
1891: ELSE
1892: push_eval;
1893: RETURN;
1894: END IF;

Line 1966: RAISE FND_API.G_EXC_ERROR;

1962: 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);
1963: END IF;
1964: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: ELSE
1968: push_eval;
1969: RETURN;
1970: END IF;

Line 2042: RAISE FND_API.G_EXC_ERROR;

2038: 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);
2039: END IF;
2040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: ELSE
2044: push_eval;
2045: RETURN;
2046: END IF;

Line 2086: RAISE FND_API.G_EXC_ERROR;

2082: 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);
2083: END IF;
2084: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2085: FND_MSG_PUB.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;
2088: END IF;
2089: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2090: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2264: WHEN FND_API.G_EXC_ERROR THEN

2260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2261: hz_utility_v2pub.debug(p_message=>'find_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2262: END IF;
2263: EXCEPTION
2264: WHEN FND_API.G_EXC_ERROR THEN
2265: ROLLBACK to find_parties;
2266: RAISE FND_API.G_EXC_ERROR;
2267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2268: ROLLBACK to find_parties;

Line 2266: RAISE FND_API.G_EXC_ERROR;

2262: END IF;
2263: EXCEPTION
2264: WHEN FND_API.G_EXC_ERROR THEN
2265: ROLLBACK to find_parties;
2266: RAISE FND_API.G_EXC_ERROR;
2267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2268: ROLLBACK to find_parties;
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: WHEN OTHERS THEN

Line 2267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2263: EXCEPTION
2264: WHEN FND_API.G_EXC_ERROR THEN
2265: ROLLBACK to find_parties;
2266: RAISE FND_API.G_EXC_ERROR;
2267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2268: ROLLBACK to find_parties;
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: WHEN OTHERS THEN
2271: ROLLBACK to find_parties;

Line 2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2265: ROLLBACK to find_parties;
2266: RAISE FND_API.G_EXC_ERROR;
2267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2268: ROLLBACK to find_parties;
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: WHEN OTHERS THEN
2271: ROLLBACK to find_parties;
2272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2273: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_parties');

Line 2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2273: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_parties');
2274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END find_parties;
2278:
2279: -------------------------------------------------------------------------------------
2280: -------------------- BULK MATCH RULE ::: find_persons ------------------------------

Line 2485: RAISE FND_API.G_EXC_ERROR;

2481: 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);
2482: END IF;
2483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2484: FND_MSG_PUB.ADD;
2485: RAISE FND_API.G_EXC_ERROR;
2486: ELSE
2487: push_eval;
2488: RETURN;
2489: END IF;

Line 2521: RAISE FND_API.G_EXC_ERROR;

2517: when others then
2518: if (instrb(SQLERRM,'DRG-51030')>0) then
2519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2520: FND_MSG_PUB.ADD;
2521: RAISE FND_API.G_EXC_ERROR;
2522: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2523: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2524: FND_MSG_PUB.ADD;
2525: RAISE FND_API.G_EXC_ERROR;

Line 2525: RAISE FND_API.G_EXC_ERROR;

2521: RAISE FND_API.G_EXC_ERROR;
2522: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2523: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2524: FND_MSG_PUB.ADD;
2525: RAISE FND_API.G_EXC_ERROR;
2526: else
2527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2528: end if;
2529: END;

Line 2527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2523: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2524: FND_MSG_PUB.ADD;
2525: RAISE FND_API.G_EXC_ERROR;
2526: else
2527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2528: end if;
2529: END;
2530:
2531: /** Private procedure to acquire and score at party site level ***/

Line 2601: RAISE FND_API.G_EXC_ERROR;

2597: 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);
2598: END IF;
2599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2600: FND_MSG_PUB.ADD;
2601: RAISE FND_API.G_EXC_ERROR;
2602: ELSE
2603: push_eval;
2604: RETURN;
2605: END IF;

Line 2738: RAISE FND_API.G_EXC_ERROR;

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

Line 2787: RAISE FND_API.G_EXC_ERROR;

2783: 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);
2784: END IF;
2785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2786: FND_MSG_PUB.ADD;
2787: RAISE FND_API.G_EXC_ERROR;
2788: END IF;
2789: END IF;
2790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2919: WHEN FND_API.G_EXC_ERROR THEN

2915: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2916: hz_utility_v2pub.debug(p_message=>'find_persons(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2917: END IF;
2918: EXCEPTION
2919: WHEN FND_API.G_EXC_ERROR THEN
2920: ROLLBACK to find_persons;
2921: RAISE FND_API.G_EXC_ERROR;
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: ROLLBACK to find_persons;

Line 2921: RAISE FND_API.G_EXC_ERROR;

2917: END IF;
2918: EXCEPTION
2919: WHEN FND_API.G_EXC_ERROR THEN
2920: ROLLBACK to find_persons;
2921: RAISE FND_API.G_EXC_ERROR;
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: ROLLBACK to find_persons;
2924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2925: WHEN OTHERS THEN

Line 2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2918: EXCEPTION
2919: WHEN FND_API.G_EXC_ERROR THEN
2920: ROLLBACK to find_persons;
2921: RAISE FND_API.G_EXC_ERROR;
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: ROLLBACK to find_persons;
2924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2925: WHEN OTHERS THEN
2926: ROLLBACK to find_persons;

Line 2924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2920: ROLLBACK to find_persons;
2921: RAISE FND_API.G_EXC_ERROR;
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: ROLLBACK to find_persons;
2924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2925: WHEN OTHERS THEN
2926: ROLLBACK to find_persons;
2927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_persons');

Line 2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_persons');
2929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2930: FND_MSG_PUB.ADD;
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END find_persons;
2933: PROCEDURE find_persons (
2934: p_rule_id IN NUMBER,
2935: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

Line 2992: WHEN FND_API.G_EXC_ERROR THEN

2988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2989: 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);
2990: END IF;
2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN

Line 2993: RAISE FND_API.G_EXC_ERROR;

2989: 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);
2990: END IF;
2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2990: END IF;
2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');

Line 2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END find_party_details;
3003:
3004: -------------------------------------------------------------------------------------
3005: -------------------- BULK MATCH RULE ::: find_duplicate_parties -------------------

Line 3080: WHEN FND_API.G_EXC_ERROR THEN

3076: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3077: 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);
3078: END IF;
3079: EXCEPTION
3080: WHEN FND_API.G_EXC_ERROR THEN
3081: RAISE FND_API.G_EXC_ERROR;
3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3084: WHEN OTHERS THEN

Line 3081: RAISE FND_API.G_EXC_ERROR;

3077: 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);
3078: END IF;
3079: EXCEPTION
3080: WHEN FND_API.G_EXC_ERROR THEN
3081: RAISE FND_API.G_EXC_ERROR;
3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3084: WHEN OTHERS THEN
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3078: END IF;
3079: EXCEPTION
3080: WHEN FND_API.G_EXC_ERROR THEN
3081: RAISE FND_API.G_EXC_ERROR;
3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3084: WHEN OTHERS THEN
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');

Line 3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3079: EXCEPTION
3080: WHEN FND_API.G_EXC_ERROR THEN
3081: RAISE FND_API.G_EXC_ERROR;
3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3084: WHEN OTHERS THEN
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');
3087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');
3087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3090: END find_duplicate_parties;
3091:
3092: -------------------------------------------------------------------------------------
3093: -------------------- BULK MATCH RULE ::: find_duplicate_party_sites-----------------

Line 3168: WHEN FND_API.G_EXC_ERROR THEN

3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: 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);
3166: END IF;
3167: EXCEPTION
3168: WHEN FND_API.G_EXC_ERROR THEN
3169: RAISE FND_API.G_EXC_ERROR;
3170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: WHEN OTHERS THEN

Line 3169: RAISE FND_API.G_EXC_ERROR;

3165: 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);
3166: END IF;
3167: EXCEPTION
3168: WHEN FND_API.G_EXC_ERROR THEN
3169: RAISE FND_API.G_EXC_ERROR;
3170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: WHEN OTHERS THEN
3173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3166: END IF;
3167: EXCEPTION
3168: WHEN FND_API.G_EXC_ERROR THEN
3169: RAISE FND_API.G_EXC_ERROR;
3170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: WHEN OTHERS THEN
3173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');

Line 3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3167: EXCEPTION
3168: WHEN FND_API.G_EXC_ERROR THEN
3169: RAISE FND_API.G_EXC_ERROR;
3170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: WHEN OTHERS THEN
3173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');
3175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');
3175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3176: FND_MSG_PUB.ADD;
3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3178: END find_duplicate_party_sites;
3179:
3180: -------------------------------------------------------------------------------------
3181: -------------------- BULK MATCH RULE ::: find_duplicate_contacts--------------------

Line 3260: WHEN FND_API.G_EXC_ERROR THEN

3256: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3257: 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);
3258: END IF;
3259: EXCEPTION
3260: WHEN FND_API.G_EXC_ERROR THEN
3261: RAISE FND_API.G_EXC_ERROR;
3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: WHEN OTHERS THEN

Line 3261: RAISE FND_API.G_EXC_ERROR;

3257: 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);
3258: END IF;
3259: EXCEPTION
3260: WHEN FND_API.G_EXC_ERROR THEN
3261: RAISE FND_API.G_EXC_ERROR;
3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: WHEN OTHERS THEN
3265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3258: END IF;
3259: EXCEPTION
3260: WHEN FND_API.G_EXC_ERROR THEN
3261: RAISE FND_API.G_EXC_ERROR;
3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: WHEN OTHERS THEN
3265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');

Line 3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3259: EXCEPTION
3260: WHEN FND_API.G_EXC_ERROR THEN
3261: RAISE FND_API.G_EXC_ERROR;
3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: WHEN OTHERS THEN
3265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');
3267: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');
3267: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3268: FND_MSG_PUB.ADD;
3269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3270: END find_duplicate_contacts;
3271:
3272: -------------------------------------------------------------------------------------
3273: -------------------- BULK MATCH RULE ::: find_duplicate_contact_points -------------

Line 3336: WHEN FND_API.G_EXC_ERROR THEN

3332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3333: 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);
3334: END IF;
3335: EXCEPTION
3336: WHEN FND_API.G_EXC_ERROR THEN
3337: RAISE FND_API.G_EXC_ERROR;
3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: WHEN OTHERS THEN

Line 3337: RAISE FND_API.G_EXC_ERROR;

3333: 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);
3334: END IF;
3335: EXCEPTION
3336: WHEN FND_API.G_EXC_ERROR THEN
3337: RAISE FND_API.G_EXC_ERROR;
3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: WHEN OTHERS THEN
3341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3334: END IF;
3335: EXCEPTION
3336: WHEN FND_API.G_EXC_ERROR THEN
3337: RAISE FND_API.G_EXC_ERROR;
3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: WHEN OTHERS THEN
3341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');

Line 3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3335: EXCEPTION
3336: WHEN FND_API.G_EXC_ERROR THEN
3337: RAISE FND_API.G_EXC_ERROR;
3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: WHEN OTHERS THEN
3341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');
3343: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');
3343: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3344: FND_MSG_PUB.ADD;
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3346: END find_duplicate_contact_points;
3347:
3348: -------------------------------------------------------------------------------------
3349: -------------------- BULK MATCH RULE ::: find_parties_dynamic-----------------------

Line 3727: WHEN FND_API.G_EXC_ERROR THEN

3723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3724: 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);
3725: END IF;
3726: EXCEPTION
3727: WHEN FND_API.G_EXC_ERROR THEN
3728: RAISE FND_API.G_EXC_ERROR;
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3731: WHEN OTHERS THEN

Line 3728: RAISE FND_API.G_EXC_ERROR;

3724: 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);
3725: END IF;
3726: EXCEPTION
3727: WHEN FND_API.G_EXC_ERROR THEN
3728: RAISE FND_API.G_EXC_ERROR;
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3731: WHEN OTHERS THEN
3732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3725: END IF;
3726: EXCEPTION
3727: WHEN FND_API.G_EXC_ERROR THEN
3728: RAISE FND_API.G_EXC_ERROR;
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3731: WHEN OTHERS THEN
3732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');

Line 3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3726: EXCEPTION
3727: WHEN FND_API.G_EXC_ERROR THEN
3728: RAISE FND_API.G_EXC_ERROR;
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3731: WHEN OTHERS THEN
3732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');
3734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');
3734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3735: FND_MSG_PUB.ADD;
3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3737: END call_api_dynamic;
3738:
3739: -------------------------------------------------------------------------------------
3740: -------------------- BULK MATCH RULE ::: get_matching_party_sites ------------------

Line 3952: WHEN FND_API.G_EXC_ERROR THEN

3948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3949: 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);
3950: END IF;
3951: EXCEPTION
3952: WHEN FND_API.G_EXC_ERROR THEN
3953: ROLLBACK to get_matching_party_sites ;
3954: RAISE FND_API.G_EXC_ERROR;
3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3956: ROLLBACK to get_matching_party_sites ;

Line 3954: RAISE FND_API.G_EXC_ERROR;

3950: END IF;
3951: EXCEPTION
3952: WHEN FND_API.G_EXC_ERROR THEN
3953: ROLLBACK to get_matching_party_sites ;
3954: RAISE FND_API.G_EXC_ERROR;
3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3956: ROLLBACK to get_matching_party_sites ;
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: WHEN OTHERS THEN

Line 3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3951: EXCEPTION
3952: WHEN FND_API.G_EXC_ERROR THEN
3953: ROLLBACK to get_matching_party_sites ;
3954: RAISE FND_API.G_EXC_ERROR;
3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3956: ROLLBACK to get_matching_party_sites ;
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: WHEN OTHERS THEN
3959: ROLLBACK to get_matching_party_sites ;

Line 3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3953: ROLLBACK to get_matching_party_sites ;
3954: RAISE FND_API.G_EXC_ERROR;
3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3956: ROLLBACK to get_matching_party_sites ;
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: WHEN OTHERS THEN
3959: ROLLBACK to get_matching_party_sites ;
3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_party_sites');

Line 3964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_party_sites');
3962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3965: END get_matching_party_sites;
3966:
3967: -------------------------------------------------------------------------------------
3968: -------------------- BULK MATCH RULE ::: get_matching_contacts --------------------

Line 4175: WHEN FND_API.G_EXC_ERROR THEN

4171: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4172: 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);
4173: END IF;
4174: EXCEPTION
4175: WHEN FND_API.G_EXC_ERROR THEN
4176: ROLLBACK to get_matching_contacts ;
4177: RAISE FND_API.G_EXC_ERROR;
4178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4179: ROLLBACK to get_matching_contacts ;

Line 4177: RAISE FND_API.G_EXC_ERROR;

4173: END IF;
4174: EXCEPTION
4175: WHEN FND_API.G_EXC_ERROR THEN
4176: ROLLBACK to get_matching_contacts ;
4177: RAISE FND_API.G_EXC_ERROR;
4178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4179: ROLLBACK to get_matching_contacts ;
4180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4181: WHEN OTHERS THEN

Line 4178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4174: EXCEPTION
4175: WHEN FND_API.G_EXC_ERROR THEN
4176: ROLLBACK to get_matching_contacts ;
4177: RAISE FND_API.G_EXC_ERROR;
4178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4179: ROLLBACK to get_matching_contacts ;
4180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4181: WHEN OTHERS THEN
4182: ROLLBACK to get_matching_contacts ;

Line 4180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4176: ROLLBACK to get_matching_contacts ;
4177: RAISE FND_API.G_EXC_ERROR;
4178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4179: ROLLBACK to get_matching_contacts ;
4180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4181: WHEN OTHERS THEN
4182: ROLLBACK to get_matching_contacts ;
4183: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4184: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contacts');

Line 4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4183: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4184: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contacts');
4185: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4186: FND_MSG_PUB.ADD;
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: END get_matching_contacts;
4189:
4190: -------------------------------------------------------------------------------------
4191: -------------------- BULK MATCH RULE ::: get_matching_contact_points ---------------

Line 4323: WHEN FND_API.G_EXC_ERROR THEN

4319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4320: 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);
4321: END IF;
4322: EXCEPTION
4323: WHEN FND_API.G_EXC_ERROR THEN
4324: ROLLBACK to get_matching_contact_points ;
4325: RAISE FND_API.G_EXC_ERROR;
4326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4327: ROLLBACK to get_matching_contact_points ;

Line 4325: RAISE FND_API.G_EXC_ERROR;

4321: END IF;
4322: EXCEPTION
4323: WHEN FND_API.G_EXC_ERROR THEN
4324: ROLLBACK to get_matching_contact_points ;
4325: RAISE FND_API.G_EXC_ERROR;
4326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4327: ROLLBACK to get_matching_contact_points ;
4328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4329: WHEN OTHERS THEN

Line 4326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4322: EXCEPTION
4323: WHEN FND_API.G_EXC_ERROR THEN
4324: ROLLBACK to get_matching_contact_points ;
4325: RAISE FND_API.G_EXC_ERROR;
4326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4327: ROLLBACK to get_matching_contact_points ;
4328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4329: WHEN OTHERS THEN
4330: ROLLBACK to get_matching_contact_points ;

Line 4328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4324: ROLLBACK to get_matching_contact_points ;
4325: RAISE FND_API.G_EXC_ERROR;
4326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4327: ROLLBACK to get_matching_contact_points ;
4328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4329: WHEN OTHERS THEN
4330: ROLLBACK to get_matching_contact_points ;
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contact_points');

Line 4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contact_points');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END get_matching_contact_points;
4337:
4338: /**********************************************************
4339: This procedure finds the score details for a specific party that

Line 4542: WHEN FND_API.G_EXC_ERROR THEN

4538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4539: 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);
4540: END IF;
4541: EXCEPTION
4542: WHEN FND_API.G_EXC_ERROR THEN
4543: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4544: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4545: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4546: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

Line 4548: RAISE FND_API.G_EXC_ERROR;

4544: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4545: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4546: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4547: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4551: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4552: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

Line 4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4545: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4546: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4547: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4551: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4552: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4553: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

Line 4555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4551: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4552: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4553: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4554: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4556: WHEN OTHERS THEN
4557: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4558: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4559: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

Line 4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_score_details');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: END get_score_details;
4568:
4569:
4570: /************************************************

Line 4676: WHEN FND_API.G_EXC_ERROR THEN

4672: END LOOP;
4673: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
4674: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4675: EXCEPTION
4676: WHEN FND_API.G_EXC_ERROR THEN
4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN

Line 4677: RAISE FND_API.G_EXC_ERROR;

4673: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
4674: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4675: EXCEPTION
4676: WHEN FND_API.G_EXC_ERROR THEN
4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4674: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4675: EXCEPTION
4676: WHEN FND_API.G_EXC_ERROR THEN
4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4675: EXCEPTION
4676: WHEN FND_API.G_EXC_ERROR THEN
4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4684: FND_MSG_PUB.ADD;
4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4686: END get_party_for_search;
4687:
4688: PROCEDURE get_search_criteria (
4689: p_party_id IN NUMBER,

Line 4728: WHEN FND_API.G_EXC_ERROR THEN

4724: END IF;
4725: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
4726: END IF;
4727: EXCEPTION
4728: WHEN FND_API.G_EXC_ERROR THEN
4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN

Line 4729: RAISE FND_API.G_EXC_ERROR;

4725: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
4726: END IF;
4727: EXCEPTION
4728: WHEN FND_API.G_EXC_ERROR THEN
4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4726: END IF;
4727: EXCEPTION
4728: WHEN FND_API.G_EXC_ERROR THEN
4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4727: EXCEPTION
4728: WHEN FND_API.G_EXC_ERROR THEN
4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: END get_search_criteria;
4739:
4740:
4741: /************************************************

Line 4806: RAISE FND_API.G_EXC_ERROR;

4802: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4803: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_ERROR;
4807: END get_party_rec;
4808:
4809: /************************************************
4810: This procedure retrieves the match rule party site attributes into

Line 4868: RAISE FND_API.G_EXC_ERROR;

4864: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4865: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4867: FND_MSG_PUB.ADD;
4868: RAISE FND_API.G_EXC_ERROR;
4869: END get_party_site_rec;
4870:
4871: /************************************************
4872: This procedure retrieves the match rule contact attributes into

Line 4928: RAISE FND_API.G_EXC_ERROR;

4924: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4925: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4927: FND_MSG_PUB.ADD;
4928: RAISE FND_API.G_EXC_ERROR;
4929: END get_contact_rec;
4930:
4931: /************************************************
4932: This procedure retrieves the match rule contact point attributes into

Line 4986: RAISE FND_API.G_EXC_ERROR;

4982: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4983: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4984: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4985: FND_MSG_PUB.ADD;
4986: RAISE FND_API.G_EXC_ERROR;
4987: END get_contact_point_rec;
4988:
4989: /************************************************
4990: This procedure maps a search record from the logical

Line 5114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5110: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5111: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5112: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5113: FND_MSG_PUB.ADD;
5114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5115: END;
5116:
5117:
5118: /************************************************

Line 5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5263: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5266: FND_MSG_PUB.ADD;
5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5268: END;
5269:
5270:
5271: /************************************************

Line 5368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5364: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5365: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5367: FND_MSG_PUB.ADD;
5368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5369: END;
5370:
5371:
5372: /************************************************

Line 5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5482: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5483: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5485: FND_MSG_PUB.ADD;
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5487: END;
5488:
5489:
5490: /************************************************

Line 5512: RAISE FND_API.G_EXC_ERROR;

5508: OR p_contact_point_list(I).URL IS NOT NULL
5509: ) THEN
5510: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5511: FND_MSG_PUB.ADD;
5512: RAISE FND_API.G_EXC_ERROR;
5513: END IF;
5514: END LOOP;
5515:
5516: IF p_party_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN

Line 5552: WHEN FND_API.G_EXC_ERROR THEN

5548: END IF;
5549: END LOOP;
5550: RETURN FALSE;
5551: EXCEPTION
5552: WHEN FND_API.G_EXC_ERROR THEN
5553: RAISE FND_API.G_EXC_ERROR;
5554: WHEN OTHERS THEN
5555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5556: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5553: RAISE FND_API.G_EXC_ERROR;

5549: END LOOP;
5550: RETURN FALSE;
5551: EXCEPTION
5552: WHEN FND_API.G_EXC_ERROR THEN
5553: RAISE FND_API.G_EXC_ERROR;
5554: WHEN OTHERS THEN
5555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5556: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5556: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5558: FND_MSG_PUB.ADD;
5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5560: END check_prim_cond;
5561:
5562: /************************************************
5563: This procedure checks if the input search condition

Line 5619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5615: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5616: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5618: FND_MSG_PUB.ADD;
5619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5620: END check_party_site_cond;
5621:
5622: /************************************************
5623: This procedure checks if the input search condition

Line 5678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5674: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5675: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5677: FND_MSG_PUB.ADD;
5678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5679: END check_contact_cond;
5680:
5681: /************************************************
5682: This procedure checks if the input search condition

Line 5699: RAISE FND_API.G_EXC_ERROR;

5695: FOR I IN 1..p_contact_point_list.COUNT LOOP
5696: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5697: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5698: FND_MSG_PUB.ADD;
5699: RAISE FND_API.G_EXC_ERROR;
5700: END IF;
5701: END LOOP;
5702:
5703: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END check_contact_point_cond;
5729:
5730: FUNCTION check_staged RETURN BOOLEAN IS
5731: