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_240 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 572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
569: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END;
574:
575:
576: /************************************************

Line 592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

588: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
589: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
591: FND_MSG_PUB.ADD;
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END;
594:
595:
596: /************************************************

Line 612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

608: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
609: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
611: FND_MSG_PUB.ADD;
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END;
614:
615:
616: /************************************************

Line 632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

628: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
629: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
630: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
631: FND_MSG_PUB.ADD;
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END;
634:
635: PROCEDURE init_score_context (
636: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 699: RAISE FND_API.G_EXC_ERROR;

695: p_contact_list,
696: p_contact_point_list) THEN
697: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
698: FND_MSG_PUB.ADD;
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
702: 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);
703: END IF;

Line 917: RAISE FND_API.G_EXC_ERROR;

913: IF lengthb(l_party_contains_str) > 4000 THEN
914: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
915: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
916: FND_MSG_PUB.ADD;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919: IF (p_match_str = ' AND ' OR p_party_max_score 920: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
921: 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 986: RAISE FND_API.G_EXC_ERROR;

982: IF lengthb(l_contains_str) > 4000 THEN
983: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
984: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988: x_denorm_str := l_den_contains_str;
989: RETURN l_contains_str;
990: END;

Line 1083: RAISE FND_API.G_EXC_ERROR;

1079: IF lengthb(l_contains_str) > 4000 THEN
1080: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1081: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085: x_denorm_str := l_den_contains_str;
1086: RETURN l_contains_str;
1087: END;

Line 1296: RAISE FND_API.G_EXC_ERROR;

1292: when others then
1293: if (instrb(SQLERRM,'DRG-51030')>0) then
1294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1295: FND_MSG_PUB.ADD;
1296: RAISE FND_API.G_EXC_ERROR;
1297: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1299: FND_MSG_PUB.ADD;
1300: RAISE FND_API.G_EXC_ERROR;

Line 1300: RAISE FND_API.G_EXC_ERROR;

1296: RAISE FND_API.G_EXC_ERROR;
1297: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1299: FND_MSG_PUB.ADD;
1300: RAISE FND_API.G_EXC_ERROR;
1301: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1303: FND_MSG_PUB.ADD;
1304: RAISE FND_API.G_EXC_ERROR;

Line 1304: RAISE FND_API.G_EXC_ERROR;

1300: RAISE FND_API.G_EXC_ERROR;
1301: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1303: FND_MSG_PUB.ADD;
1304: RAISE FND_API.G_EXC_ERROR;
1305: else
1306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1308: FND_MSG_PUB.ADD;

Line 1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1305: else
1306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1308: FND_MSG_PUB.ADD;
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: end if;
1311: END;
1312:
1313: PROCEDURE open_party_site_cursor(

Line 1541: RAISE FND_API.G_EXC_ERROR;

1537: when others then
1538: if (instrb(SQLERRM,'DRG-51030')>0) then
1539: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;

Line 1545: RAISE FND_API.G_EXC_ERROR;

1541: RAISE FND_API.G_EXC_ERROR;
1542: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;
1546: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;

Line 1549: RAISE FND_API.G_EXC_ERROR;

1545: RAISE FND_API.G_EXC_ERROR;
1546: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1553: FND_MSG_PUB.ADD;

Line 1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: end if;
1556: END;
1557:
1558: PROCEDURE open_contact_cursor(

Line 1688: RAISE FND_API.G_EXC_ERROR;

1684: when others then
1685: if (instrb(SQLERRM,'DRG-51030')>0) then
1686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1687: FND_MSG_PUB.ADD;
1688: RAISE FND_API.G_EXC_ERROR;
1689: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1690: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1691: FND_MSG_PUB.ADD;
1692: RAISE FND_API.G_EXC_ERROR;

Line 1692: RAISE FND_API.G_EXC_ERROR;

1688: RAISE FND_API.G_EXC_ERROR;
1689: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1690: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1691: FND_MSG_PUB.ADD;
1692: RAISE FND_API.G_EXC_ERROR;
1693: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1695: FND_MSG_PUB.ADD;
1696: RAISE FND_API.G_EXC_ERROR;

Line 1696: RAISE FND_API.G_EXC_ERROR;

1692: RAISE FND_API.G_EXC_ERROR;
1693: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1695: FND_MSG_PUB.ADD;
1696: RAISE FND_API.G_EXC_ERROR;
1697: else
1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1700: FND_MSG_PUB.ADD;

Line 1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1697: else
1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: end if;
1703: END;
1704:
1705: PROCEDURE open_contact_pt_cursor(

Line 1961: RAISE FND_API.G_EXC_ERROR;

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

Line 1965: RAISE FND_API.G_EXC_ERROR;

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

Line 1969: RAISE FND_API.G_EXC_ERROR;

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

Line 1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2222: RAISE FND_API.G_EXC_ERROR;

2218: 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);
2219: END IF;
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2221: FND_MSG_PUB.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: ELSE
2224: push_eval;
2225: RETURN;
2226: END IF;

Line 2270: RAISE FND_API.G_EXC_ERROR;

2266: 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);
2267: END IF;
2268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2269: FND_MSG_PUB.ADD;
2270: RAISE FND_API.G_EXC_ERROR;
2271: ELSE
2272: push_eval;
2273: RETURN;
2274: END IF;

Line 2343: RAISE FND_API.G_EXC_ERROR;

2339: 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);
2340: END IF;
2341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2342: FND_MSG_PUB.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: ELSE
2345: push_eval;
2346: RETURN;
2347: END IF;

Line 2455: RAISE FND_API.G_EXC_ERROR;

2451: 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);
2452: END IF;
2453: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2454: FND_MSG_PUB.ADD;
2455: RAISE FND_API.G_EXC_ERROR;
2456: ELSE
2457: push_eval;
2458: RETURN;
2459: END IF;

Line 2566: RAISE FND_API.G_EXC_ERROR;

2562: 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);
2563: END IF;
2564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: ELSE
2568: push_eval;
2569: RETURN;
2570: END IF;

Line 2791: RAISE FND_API.G_EXC_ERROR;

2787: 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);
2788: END IF;
2789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2790: FND_MSG_PUB.ADD;
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;
2793: ELSE
2794: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2795: 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 2799: RAISE FND_API.G_EXC_ERROR;

2795: 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);
2796: END IF;
2797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2798: FND_MSG_PUB.ADD;
2799: RAISE FND_API.G_EXC_ERROR;
2800: END IF;
2801: END IF;
2802: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2803: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2998: WHEN FND_API.G_EXC_ERROR THEN

2994: END IF;
2995: EXCEPTION
2996: WHEN L_RETURN_IMM_EXC THEN
2997: RETURN;
2998: WHEN FND_API.G_EXC_ERROR THEN
2999: RAISE FND_API.G_EXC_ERROR;
3000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: WHEN OTHERS THEN

Line 2999: RAISE FND_API.G_EXC_ERROR;

2995: EXCEPTION
2996: WHEN L_RETURN_IMM_EXC THEN
2997: RETURN;
2998: WHEN FND_API.G_EXC_ERROR THEN
2999: RAISE FND_API.G_EXC_ERROR;
3000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: WHEN OTHERS THEN
3003: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2996: WHEN L_RETURN_IMM_EXC THEN
2997: RETURN;
2998: WHEN FND_API.G_EXC_ERROR THEN
2999: RAISE FND_API.G_EXC_ERROR;
3000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: WHEN OTHERS THEN
3003: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3004: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_parties');

Line 3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2997: RETURN;
2998: WHEN FND_API.G_EXC_ERROR THEN
2999: RAISE FND_API.G_EXC_ERROR;
3000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: WHEN OTHERS THEN
3003: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3004: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_parties');
3005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3003: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3004: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_parties');
3005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3006: FND_MSG_PUB.ADD;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008: END find_parties;
3009:
3010: PROCEDURE find_persons (
3011: p_rule_id IN NUMBER,

Line 3195: RAISE FND_API.G_EXC_ERROR;

3191: 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);
3192: END IF;
3193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3194: FND_MSG_PUB.ADD;
3195: RAISE FND_API.G_EXC_ERROR;
3196: ELSE
3197: push_eval;
3198: RETURN;
3199: END IF;

Line 3243: RAISE FND_API.G_EXC_ERROR;

3239: 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);
3240: END IF;
3241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3242: FND_MSG_PUB.ADD;
3243: RAISE FND_API.G_EXC_ERROR;
3244: ELSE
3245: push_eval;
3246: RETURN;
3247: END IF;

Line 3279: RAISE FND_API.G_EXC_ERROR;

3275: when others then
3276: if (instrb(SQLERRM,'DRG-51030')>0) then
3277: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3278: FND_MSG_PUB.ADD;
3279: RAISE FND_API.G_EXC_ERROR;
3280: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3281: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3282: FND_MSG_PUB.ADD;
3283: RAISE FND_API.G_EXC_ERROR;

Line 3283: RAISE FND_API.G_EXC_ERROR;

3279: RAISE FND_API.G_EXC_ERROR;
3280: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3281: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3282: FND_MSG_PUB.ADD;
3283: RAISE FND_API.G_EXC_ERROR;
3284: else
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: end if;
3287: END;

Line 3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3281: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3282: FND_MSG_PUB.ADD;
3283: RAISE FND_API.G_EXC_ERROR;
3284: else
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: end if;
3287: END;
3288:
3289: /** Private procedure to acquire and score at party site level ***/

Line 3355: RAISE FND_API.G_EXC_ERROR;

3351: 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);
3352: END IF;
3353: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3354: FND_MSG_PUB.ADD;
3355: RAISE FND_API.G_EXC_ERROR;
3356: ELSE
3357: push_eval;
3358: RETURN;
3359: END IF;

Line 3614: RAISE FND_API.G_EXC_ERROR;

3610: 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);
3611: END IF;
3612: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3613: FND_MSG_PUB.ADD;
3614: RAISE FND_API.G_EXC_ERROR;
3615: ELSE
3616: push_eval;
3617: RETURN;
3618: END IF;

Line 3727: RAISE FND_API.G_EXC_ERROR;

3723: 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);
3724: END IF;
3725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: END IF;
3729: ELSE
3730: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3731: 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 3735: RAISE FND_API.G_EXC_ERROR;

3731: 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);
3732: END IF;
3733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3734: FND_MSG_PUB.ADD;
3735: RAISE FND_API.G_EXC_ERROR;
3736: END IF;
3737: END IF;
3738: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3739: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3849: WHEN FND_API.G_EXC_ERROR THEN

3845: END IF;
3846: EXCEPTION
3847: WHEN L_RETURN_IMM_EXC THEN
3848: RETURN;
3849: WHEN FND_API.G_EXC_ERROR THEN
3850: RAISE FND_API.G_EXC_ERROR;
3851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3853: WHEN OTHERS THEN

Line 3850: RAISE FND_API.G_EXC_ERROR;

3846: EXCEPTION
3847: WHEN L_RETURN_IMM_EXC THEN
3848: RETURN;
3849: WHEN FND_API.G_EXC_ERROR THEN
3850: RAISE FND_API.G_EXC_ERROR;
3851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3853: WHEN OTHERS THEN
3854: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3847: WHEN L_RETURN_IMM_EXC THEN
3848: RETURN;
3849: WHEN FND_API.G_EXC_ERROR THEN
3850: RAISE FND_API.G_EXC_ERROR;
3851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3853: WHEN OTHERS THEN
3854: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3855: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_persons');

Line 3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3848: RETURN;
3849: WHEN FND_API.G_EXC_ERROR THEN
3850: RAISE FND_API.G_EXC_ERROR;
3851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3853: WHEN OTHERS THEN
3854: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3855: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_persons');
3856: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3854: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3855: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_persons');
3856: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3857: FND_MSG_PUB.ADD;
3858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3859: END find_persons;
3860:
3861: PROCEDURE find_persons (
3862: p_rule_id IN NUMBER,

Line 3917: WHEN FND_API.G_EXC_ERROR THEN

3913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3914: 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);
3915: END IF;
3916: EXCEPTION
3917: WHEN FND_API.G_EXC_ERROR THEN
3918: RAISE FND_API.G_EXC_ERROR;
3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: WHEN OTHERS THEN

Line 3918: RAISE FND_API.G_EXC_ERROR;

3914: 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);
3915: END IF;
3916: EXCEPTION
3917: WHEN FND_API.G_EXC_ERROR THEN
3918: RAISE FND_API.G_EXC_ERROR;
3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: WHEN OTHERS THEN
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3915: END IF;
3916: EXCEPTION
3917: WHEN FND_API.G_EXC_ERROR THEN
3918: RAISE FND_API.G_EXC_ERROR;
3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: WHEN OTHERS THEN
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_party_details');

Line 3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3916: EXCEPTION
3917: WHEN FND_API.G_EXC_ERROR THEN
3918: RAISE FND_API.G_EXC_ERROR;
3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: WHEN OTHERS THEN
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_party_details');
3924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_party_details');
3924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3925: FND_MSG_PUB.ADD;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: END find_party_details;
3928:
3929: PROCEDURE find_duplicate_parties (
3930: p_rule_id IN NUMBER,

Line 4034: WHEN FND_API.G_EXC_ERROR THEN

4030: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4031: 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);
4032: END IF;
4033: EXCEPTION
4034: WHEN FND_API.G_EXC_ERROR THEN
4035: RAISE FND_API.G_EXC_ERROR;
4036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4038: WHEN OTHERS THEN

Line 4035: RAISE FND_API.G_EXC_ERROR;

4031: 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);
4032: END IF;
4033: EXCEPTION
4034: WHEN FND_API.G_EXC_ERROR THEN
4035: RAISE FND_API.G_EXC_ERROR;
4036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4038: WHEN OTHERS THEN
4039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4032: END IF;
4033: EXCEPTION
4034: WHEN FND_API.G_EXC_ERROR THEN
4035: RAISE FND_API.G_EXC_ERROR;
4036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4038: WHEN OTHERS THEN
4039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4040: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_parties');

Line 4037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4033: EXCEPTION
4034: WHEN FND_API.G_EXC_ERROR THEN
4035: RAISE FND_API.G_EXC_ERROR;
4036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4038: WHEN OTHERS THEN
4039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4040: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_parties');
4041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4040: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_parties');
4041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4042: FND_MSG_PUB.ADD;
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: END find_duplicate_parties;
4045:
4046: PROCEDURE find_duplicate_party_sites (
4047: p_rule_id IN NUMBER,

Line 4119: WHEN FND_API.G_EXC_ERROR THEN

4115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4116: 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);
4117: END IF;
4118: EXCEPTION
4119: WHEN FND_API.G_EXC_ERROR THEN
4120: RAISE FND_API.G_EXC_ERROR;
4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4123: WHEN OTHERS THEN

Line 4120: RAISE FND_API.G_EXC_ERROR;

4116: 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);
4117: END IF;
4118: EXCEPTION
4119: WHEN FND_API.G_EXC_ERROR THEN
4120: RAISE FND_API.G_EXC_ERROR;
4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4123: WHEN OTHERS THEN
4124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4117: END IF;
4118: EXCEPTION
4119: WHEN FND_API.G_EXC_ERROR THEN
4120: RAISE FND_API.G_EXC_ERROR;
4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4123: WHEN OTHERS THEN
4124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4125: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_party_sites');

Line 4122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4118: EXCEPTION
4119: WHEN FND_API.G_EXC_ERROR THEN
4120: RAISE FND_API.G_EXC_ERROR;
4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4123: WHEN OTHERS THEN
4124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4125: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_party_sites');
4126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4125: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_party_sites');
4126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4127: FND_MSG_PUB.ADD;
4128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4129: END find_duplicate_party_sites;
4130:
4131: PROCEDURE find_duplicate_contacts (
4132: p_rule_id IN NUMBER,

Line 4208: WHEN FND_API.G_EXC_ERROR THEN

4204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4205: 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);
4206: END IF;
4207: EXCEPTION
4208: WHEN FND_API.G_EXC_ERROR THEN
4209: RAISE FND_API.G_EXC_ERROR;
4210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4212: WHEN OTHERS THEN

Line 4209: RAISE FND_API.G_EXC_ERROR;

4205: 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);
4206: END IF;
4207: EXCEPTION
4208: WHEN FND_API.G_EXC_ERROR THEN
4209: RAISE FND_API.G_EXC_ERROR;
4210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4212: WHEN OTHERS THEN
4213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4206: END IF;
4207: EXCEPTION
4208: WHEN FND_API.G_EXC_ERROR THEN
4209: RAISE FND_API.G_EXC_ERROR;
4210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4212: WHEN OTHERS THEN
4213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contacts');

Line 4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4207: EXCEPTION
4208: WHEN FND_API.G_EXC_ERROR THEN
4209: RAISE FND_API.G_EXC_ERROR;
4210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4212: WHEN OTHERS THEN
4213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contacts');
4215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contacts');
4215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4216: FND_MSG_PUB.ADD;
4217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4218: END find_duplicate_contacts;
4219:
4220: PROCEDURE find_duplicate_contact_points (
4221: p_rule_id IN NUMBER,

Line 4281: WHEN FND_API.G_EXC_ERROR THEN

4277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4278: 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);
4279: END IF;
4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN

Line 4282: RAISE FND_API.G_EXC_ERROR;

4278: 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);
4279: END IF;
4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4279: END IF;
4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contact_points');

Line 4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contact_points');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contact_points');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END find_duplicate_contact_points;
4292:
4293: PROCEDURE find_parties_dynamic (
4294: p_rule_id IN NUMBER,

Line 4582: WHEN FND_API.G_EXC_ERROR THEN

4578: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4579: 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);
4580: END IF;
4581: EXCEPTION
4582: WHEN FND_API.G_EXC_ERROR THEN
4583: RAISE FND_API.G_EXC_ERROR;
4584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: WHEN OTHERS THEN

Line 4583: RAISE FND_API.G_EXC_ERROR;

4579: 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);
4580: END IF;
4581: EXCEPTION
4582: WHEN FND_API.G_EXC_ERROR THEN
4583: RAISE FND_API.G_EXC_ERROR;
4584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: WHEN OTHERS THEN
4587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4580: END IF;
4581: EXCEPTION
4582: WHEN FND_API.G_EXC_ERROR THEN
4583: RAISE FND_API.G_EXC_ERROR;
4584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: WHEN OTHERS THEN
4587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.call_api_dynamic');

Line 4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4581: EXCEPTION
4582: WHEN FND_API.G_EXC_ERROR THEN
4583: RAISE FND_API.G_EXC_ERROR;
4584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: WHEN OTHERS THEN
4587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.call_api_dynamic');
4589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.call_api_dynamic');
4589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4590: FND_MSG_PUB.ADD;
4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4592: END call_api_dynamic;
4593:
4594:
4595: PROCEDURE get_matching_party_sites (

Line 4818: WHEN FND_API.G_EXC_ERROR THEN

4814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4815: 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);
4816: END IF;
4817: EXCEPTION
4818: WHEN FND_API.G_EXC_ERROR THEN
4819: RAISE FND_API.G_EXC_ERROR;
4820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4822: WHEN OTHERS THEN

Line 4819: RAISE FND_API.G_EXC_ERROR;

4815: 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);
4816: END IF;
4817: EXCEPTION
4818: WHEN FND_API.G_EXC_ERROR THEN
4819: RAISE FND_API.G_EXC_ERROR;
4820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4822: WHEN OTHERS THEN
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4816: END IF;
4817: EXCEPTION
4818: WHEN FND_API.G_EXC_ERROR THEN
4819: RAISE FND_API.G_EXC_ERROR;
4820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4822: WHEN OTHERS THEN
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4824: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_party_sites');

Line 4821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4817: EXCEPTION
4818: WHEN FND_API.G_EXC_ERROR THEN
4819: RAISE FND_API.G_EXC_ERROR;
4820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4822: WHEN OTHERS THEN
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4824: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_party_sites');
4825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4824: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_party_sites');
4825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4826: FND_MSG_PUB.ADD;
4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4828: END get_matching_party_sites;
4829:
4830:
4831: PROCEDURE get_matching_contacts (

Line 5045: WHEN FND_API.G_EXC_ERROR THEN

5041: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5042: 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);
5043: END IF;
5044: EXCEPTION
5045: WHEN FND_API.G_EXC_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;
5047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: WHEN OTHERS THEN

Line 5046: RAISE FND_API.G_EXC_ERROR;

5042: 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);
5043: END IF;
5044: EXCEPTION
5045: WHEN FND_API.G_EXC_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;
5047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: WHEN OTHERS THEN
5050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5043: END IF;
5044: EXCEPTION
5045: WHEN FND_API.G_EXC_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;
5047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: WHEN OTHERS THEN
5050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contacts');

Line 5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5044: EXCEPTION
5045: WHEN FND_API.G_EXC_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;
5047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: WHEN OTHERS THEN
5050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contacts');
5052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contacts');
5052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5053: FND_MSG_PUB.ADD;
5054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5055: END get_matching_contacts;
5056:
5057:
5058: PROCEDURE get_matching_contact_points (

Line 5186: WHEN FND_API.G_EXC_ERROR THEN

5182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5183: 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);
5184: END IF;
5185: EXCEPTION
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: RAISE FND_API.G_EXC_ERROR;
5188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: WHEN OTHERS THEN

Line 5187: RAISE FND_API.G_EXC_ERROR;

5183: 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);
5184: END IF;
5185: EXCEPTION
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: RAISE FND_API.G_EXC_ERROR;
5188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: WHEN OTHERS THEN
5191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5184: END IF;
5185: EXCEPTION
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: RAISE FND_API.G_EXC_ERROR;
5188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: WHEN OTHERS THEN
5191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contact_points');

Line 5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5185: EXCEPTION
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: RAISE FND_API.G_EXC_ERROR;
5188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: WHEN OTHERS THEN
5191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contact_points');
5193: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contact_points');
5193: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5194: FND_MSG_PUB.ADD;
5195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5196: END get_matching_contact_points;
5197:
5198: /**********************************************************
5199: This procedure finds the score details for a specific party that

Line 5387: WHEN FND_API.G_EXC_ERROR THEN

5383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5384: 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);
5385: END IF;
5386: EXCEPTION
5387: WHEN FND_API.G_EXC_ERROR THEN
5388: RAISE FND_API.G_EXC_ERROR;
5389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5391: WHEN OTHERS THEN

Line 5388: RAISE FND_API.G_EXC_ERROR;

5384: 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);
5385: END IF;
5386: EXCEPTION
5387: WHEN FND_API.G_EXC_ERROR THEN
5388: RAISE FND_API.G_EXC_ERROR;
5389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5385: END IF;
5386: EXCEPTION
5387: WHEN FND_API.G_EXC_ERROR THEN
5388: RAISE FND_API.G_EXC_ERROR;
5389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_score_details');

Line 5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5386: EXCEPTION
5387: WHEN FND_API.G_EXC_ERROR THEN
5388: RAISE FND_API.G_EXC_ERROR;
5389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_score_details');
5394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_score_details');
5394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5395: FND_MSG_PUB.ADD;
5396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5397: END get_score_details;
5398:
5399:
5400: /************************************************

Line 5497: WHEN FND_API.G_EXC_ERROR THEN

5493: END LOOP;
5494: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5495: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN
5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN

Line 5498: RAISE FND_API.G_EXC_ERROR;

5494: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5495: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN
5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5495: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN
5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN
5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5505: FND_MSG_PUB.ADD;
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5507: END get_party_for_search;
5508:
5509: PROCEDURE get_search_criteria (
5510: p_party_id IN NUMBER,

Line 5543: WHEN FND_API.G_EXC_ERROR THEN

5539: END IF;
5540: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5541: END IF;
5542: EXCEPTION
5543: WHEN FND_API.G_EXC_ERROR THEN
5544: RAISE FND_API.G_EXC_ERROR;
5545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5547: WHEN OTHERS THEN

Line 5544: RAISE FND_API.G_EXC_ERROR;

5540: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5541: END IF;
5542: EXCEPTION
5543: WHEN FND_API.G_EXC_ERROR THEN
5544: RAISE FND_API.G_EXC_ERROR;
5545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5547: WHEN OTHERS THEN
5548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5541: END IF;
5542: EXCEPTION
5543: WHEN FND_API.G_EXC_ERROR THEN
5544: RAISE FND_API.G_EXC_ERROR;
5545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5547: WHEN OTHERS THEN
5548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5549: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5542: EXCEPTION
5543: WHEN FND_API.G_EXC_ERROR THEN
5544: RAISE FND_API.G_EXC_ERROR;
5545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5547: WHEN OTHERS THEN
5548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5549: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5549: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5551: FND_MSG_PUB.ADD;
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5553: END get_search_criteria;
5554:
5555:
5556: /************************************************

Line 5609: RAISE FND_API.G_EXC_ERROR;

5605: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5606: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5608: FND_MSG_PUB.ADD;
5609: RAISE FND_API.G_EXC_ERROR;
5610: END get_party_rec;
5611:
5612: /************************************************
5613: This procedure retrieves the match rule party site attributes into

Line 5665: RAISE FND_API.G_EXC_ERROR;

5661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5664: FND_MSG_PUB.ADD;
5665: RAISE FND_API.G_EXC_ERROR;
5666: END get_party_site_rec;
5667:
5668: /************************************************
5669: This procedure retrieves the match rule contact attributes into

Line 5721: RAISE FND_API.G_EXC_ERROR;

5717: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5718: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_ERROR;
5722: END get_contact_rec;
5723:
5724: /************************************************
5725: This procedure retrieves the match rule contact point attributes into

Line 5777: RAISE FND_API.G_EXC_ERROR;

5773: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5774: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END get_contact_point_rec;
5779:
5780: /************************************************
5781: This procedure maps a search record from the logical

Line 5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5848: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: END;
5854:
5855:
5856: /************************************************

Line 5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5943: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5948: END;
5949:
5950:
5951: /************************************************

Line 5989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5985: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5986: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5987: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5990: END;
5991:
5992:
5993: /************************************************

Line 6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6103: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6108: END;
6109:
6110:
6111: /************************************************

Line 6132: RAISE FND_API.G_EXC_ERROR;

6128: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6129: ) THEN
6130: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6131: FND_MSG_PUB.ADD;
6132: RAISE FND_API.G_EXC_ERROR;
6133: END IF;
6134: END LOOP;
6135:
6136: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 6161: WHEN FND_API.G_EXC_ERROR THEN

6157: END IF;
6158: END LOOP;
6159: RETURN FALSE;
6160: EXCEPTION
6161: WHEN FND_API.G_EXC_ERROR THEN
6162: RAISE FND_API.G_EXC_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6162: RAISE FND_API.G_EXC_ERROR;

6158: END LOOP;
6159: RETURN FALSE;
6160: EXCEPTION
6161: WHEN FND_API.G_EXC_ERROR THEN
6162: RAISE FND_API.G_EXC_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END check_prim_cond;
6170:
6171: /************************************************
6172: This procedure checks if the input search condition

Line 6224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6220: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6221: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6222: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6223: FND_MSG_PUB.ADD;
6224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6225: END check_party_site_cond;
6226:
6227: /************************************************
6228: This procedure checks if the input search condition

Line 6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6269: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6270: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6271: FND_MSG_PUB.ADD;
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: END check_contact_cond;
6274:
6275: /************************************************
6276: This procedure checks if the input search condition

Line 6293: RAISE FND_API.G_EXC_ERROR;

6289: FOR I IN 1..p_contact_point_list.COUNT LOOP
6290: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6292: FND_MSG_PUB.ADD;
6293: RAISE FND_API.G_EXC_ERROR;
6294: END IF;
6295: END LOOP;
6296:
6297: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6320: END check_contact_point_cond;
6321:
6322: FUNCTION check_staged RETURN BOOLEAN IS
6323: