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_48 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 771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

767: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
768: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
770: FND_MSG_PUB.ADD;
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END;
773:
774:
775: /************************************************

Line 796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

792: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
793: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END;
798:
799:
800: /************************************************

Line 816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

812: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
813: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
815: FND_MSG_PUB.ADD;
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END;
818:
819:
820: /************************************************

Line 836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

832: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
833: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
834: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
835: FND_MSG_PUB.ADD;
836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837: END;
838:
839: PROCEDURE init_score_context (
840: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 903: RAISE FND_API.G_EXC_ERROR;

899: p_contact_list,
900: p_contact_point_list) THEN
901: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;
905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
906: 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);
907: END IF;

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: IF lengthb(l_party_contains_str) > 4000 THEN
1171: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1172: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1173: FND_MSG_PUB.ADD;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176: IF (p_match_str = ' AND ' OR p_party_max_score 1177: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1178: 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 1263: RAISE FND_API.G_EXC_ERROR;

1259: IF lengthb(l_contains_str) > 4000 THEN
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1261: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1262: FND_MSG_PUB.ADD;
1263: RAISE FND_API.G_EXC_ERROR;
1264: END IF;
1265: x_denorm_str := l_den_contains_str;
1266: RETURN l_contains_str;
1267: END;

Line 1543: RAISE FND_API.G_EXC_ERROR;

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

Line 1547: RAISE FND_API.G_EXC_ERROR;

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

Line 1551: RAISE FND_API.G_EXC_ERROR;

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

Line 1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1788: RAISE FND_API.G_EXC_ERROR;

1784: when others then
1785: if (instrb(SQLERRM,'DRG-51030')>0) then
1786: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1787: FND_MSG_PUB.ADD;
1788: RAISE FND_API.G_EXC_ERROR;
1789: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;

Line 1792: RAISE FND_API.G_EXC_ERROR;

1788: RAISE FND_API.G_EXC_ERROR;
1789: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1795: FND_MSG_PUB.ADD;
1796: RAISE FND_API.G_EXC_ERROR;

Line 1796: RAISE FND_API.G_EXC_ERROR;

1792: RAISE FND_API.G_EXC_ERROR;
1793: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1795: FND_MSG_PUB.ADD;
1796: RAISE FND_API.G_EXC_ERROR;
1797: else
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;

Line 1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1797: else
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1802: end if;
1803: END;
1804:
1805: PROCEDURE open_contact_cursor(

Line 1935: RAISE FND_API.G_EXC_ERROR;

1931: when others then
1932: if (instrb(SQLERRM,'DRG-51030')>0) then
1933: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_ERROR;
1936: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1938: FND_MSG_PUB.ADD;
1939: RAISE FND_API.G_EXC_ERROR;

Line 1939: RAISE FND_API.G_EXC_ERROR;

1935: RAISE FND_API.G_EXC_ERROR;
1936: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1938: FND_MSG_PUB.ADD;
1939: RAISE FND_API.G_EXC_ERROR;
1940: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1942: FND_MSG_PUB.ADD;
1943: RAISE FND_API.G_EXC_ERROR;

Line 1943: RAISE FND_API.G_EXC_ERROR;

1939: RAISE FND_API.G_EXC_ERROR;
1940: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1942: FND_MSG_PUB.ADD;
1943: RAISE FND_API.G_EXC_ERROR;
1944: else
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1947: FND_MSG_PUB.ADD;

Line 1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1944: else
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949: end if;
1950: END;
1951:
1952: PROCEDURE open_contact_pt_cursor(

Line 2208: RAISE FND_API.G_EXC_ERROR;

2204: when others then
2205: if (instrb(SQLERRM,'DRG-51030')>0) then
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2207: FND_MSG_PUB.ADD;
2208: RAISE FND_API.G_EXC_ERROR;
2209: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;

Line 2212: RAISE FND_API.G_EXC_ERROR;

2208: RAISE FND_API.G_EXC_ERROR;
2209: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2215: FND_MSG_PUB.ADD;
2216: RAISE FND_API.G_EXC_ERROR;

Line 2216: RAISE FND_API.G_EXC_ERROR;

2212: RAISE FND_API.G_EXC_ERROR;
2213: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2215: FND_MSG_PUB.ADD;
2216: RAISE FND_API.G_EXC_ERROR;
2217: else
2218: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2220: FND_MSG_PUB.ADD;

Line 2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2217: else
2218: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2220: FND_MSG_PUB.ADD;
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: end if;
2223: END;
2224:
2225:

Line 2474: RAISE FND_API.G_EXC_ERROR;

2470: 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);
2471: END IF;
2472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2473: FND_MSG_PUB.ADD;
2474: RAISE FND_API.G_EXC_ERROR;
2475: ELSE
2476: push_eval;
2477: RETURN;
2478: END IF;

Line 2522: RAISE FND_API.G_EXC_ERROR;

2518: 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);
2519: END IF;
2520: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2521: FND_MSG_PUB.ADD;
2522: RAISE FND_API.G_EXC_ERROR;
2523: ELSE
2524: push_eval;
2525: RETURN;
2526: END IF;

Line 2595: RAISE FND_API.G_EXC_ERROR;

2591: 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);
2592: END IF;
2593: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2594: FND_MSG_PUB.ADD;
2595: RAISE FND_API.G_EXC_ERROR;
2596: ELSE
2597: push_eval;
2598: RETURN;
2599: END IF;

Line 2707: RAISE FND_API.G_EXC_ERROR;

2703: 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);
2704: END IF;
2705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2706: FND_MSG_PUB.ADD;
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSE
2709: push_eval;
2710: RETURN;
2711: END IF;

Line 2818: RAISE FND_API.G_EXC_ERROR;

2814: 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);
2815: END IF;
2816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2817: FND_MSG_PUB.ADD;
2818: RAISE FND_API.G_EXC_ERROR;
2819: ELSE
2820: push_eval;
2821: RETURN;
2822: END IF;

Line 2962: RAISE FND_API.G_EXC_ERROR;

2958: 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);
2959: END IF;
2960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2961: FND_MSG_PUB.ADD;
2962: RAISE FND_API.G_EXC_ERROR;
2963: END IF;
2964: ELSE
2965: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2966: 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 2970: RAISE FND_API.G_EXC_ERROR;

2966: 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);
2967: END IF;
2968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2969: FND_MSG_PUB.ADD;
2970: RAISE FND_API.G_EXC_ERROR;
2971: END IF;
2972: END IF;
2973: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2974: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3212: WHEN FND_API.G_EXC_ERROR THEN

3208: END IF;
3209: EXCEPTION
3210: WHEN L_RETURN_IMM_EXC THEN
3211: RETURN;
3212: WHEN FND_API.G_EXC_ERROR THEN
3213: RAISE FND_API.G_EXC_ERROR;
3214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3216: WHEN OTHERS THEN

Line 3213: RAISE FND_API.G_EXC_ERROR;

3209: EXCEPTION
3210: WHEN L_RETURN_IMM_EXC THEN
3211: RETURN;
3212: WHEN FND_API.G_EXC_ERROR THEN
3213: RAISE FND_API.G_EXC_ERROR;
3214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3216: WHEN OTHERS THEN
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3210: WHEN L_RETURN_IMM_EXC THEN
3211: RETURN;
3212: WHEN FND_API.G_EXC_ERROR THEN
3213: RAISE FND_API.G_EXC_ERROR;
3214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3216: WHEN OTHERS THEN
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_parties');

Line 3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3211: RETURN;
3212: WHEN FND_API.G_EXC_ERROR THEN
3213: RAISE FND_API.G_EXC_ERROR;
3214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3216: WHEN OTHERS THEN
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_parties');
3219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_parties');
3219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3220: FND_MSG_PUB.ADD;
3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3222: END find_parties;
3223:
3224: PROCEDURE find_persons (
3225: p_rule_id IN NUMBER,

Line 3414: RAISE FND_API.G_EXC_ERROR;

3410: 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);
3411: END IF;
3412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3413: FND_MSG_PUB.ADD;
3414: RAISE FND_API.G_EXC_ERROR;
3415: ELSE
3416: push_eval;
3417: RETURN;
3418: END IF;

Line 3462: RAISE FND_API.G_EXC_ERROR;

3458: 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);
3459: END IF;
3460: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3461: FND_MSG_PUB.ADD;
3462: RAISE FND_API.G_EXC_ERROR;
3463: ELSE
3464: push_eval;
3465: RETURN;
3466: END IF;

Line 3498: RAISE FND_API.G_EXC_ERROR;

3494: when others then
3495: if (instrb(SQLERRM,'DRG-51030')>0) then
3496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3497: FND_MSG_PUB.ADD;
3498: RAISE FND_API.G_EXC_ERROR;
3499: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3501: FND_MSG_PUB.ADD;
3502: RAISE FND_API.G_EXC_ERROR;

Line 3502: RAISE FND_API.G_EXC_ERROR;

3498: RAISE FND_API.G_EXC_ERROR;
3499: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3501: FND_MSG_PUB.ADD;
3502: RAISE FND_API.G_EXC_ERROR;
3503: else
3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3505: end if;
3506: END;

Line 3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3501: FND_MSG_PUB.ADD;
3502: RAISE FND_API.G_EXC_ERROR;
3503: else
3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3505: end if;
3506: END;
3507:
3508: /** Private procedure to acquire and score at party site level ***/

Line 3574: RAISE FND_API.G_EXC_ERROR;

3570: 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);
3571: END IF;
3572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3573: FND_MSG_PUB.ADD;
3574: RAISE FND_API.G_EXC_ERROR;
3575: ELSE
3576: push_eval;
3577: RETURN;
3578: END IF;

Line 3763: RAISE FND_API.G_EXC_ERROR;

3759: 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);
3760: END IF;
3761: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: ELSE
3765: push_eval;
3766: RETURN;
3767: END IF;

Line 3851: RAISE FND_API.G_EXC_ERROR;

3847: 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);
3848: END IF;
3849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3850: FND_MSG_PUB.ADD;
3851: RAISE FND_API.G_EXC_ERROR;
3852: END IF;
3853: ELSE
3854: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3855: 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 3859: RAISE FND_API.G_EXC_ERROR;

3855: 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);
3856: END IF;
3857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3858: FND_MSG_PUB.ADD;
3859: RAISE FND_API.G_EXC_ERROR;
3860: END IF;
3861: END IF;
3862: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3863: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3999: WHEN FND_API.G_EXC_ERROR THEN

3995: END IF;
3996: EXCEPTION
3997: WHEN L_RETURN_IMM_EXC THEN
3998: RETURN;
3999: WHEN FND_API.G_EXC_ERROR THEN
4000: RAISE FND_API.G_EXC_ERROR;
4001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003: WHEN OTHERS THEN

Line 4000: RAISE FND_API.G_EXC_ERROR;

3996: EXCEPTION
3997: WHEN L_RETURN_IMM_EXC THEN
3998: RETURN;
3999: WHEN FND_API.G_EXC_ERROR THEN
4000: RAISE FND_API.G_EXC_ERROR;
4001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003: WHEN OTHERS THEN
4004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3997: WHEN L_RETURN_IMM_EXC THEN
3998: RETURN;
3999: WHEN FND_API.G_EXC_ERROR THEN
4000: RAISE FND_API.G_EXC_ERROR;
4001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003: WHEN OTHERS THEN
4004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4005: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');

Line 4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3998: RETURN;
3999: WHEN FND_API.G_EXC_ERROR THEN
4000: RAISE FND_API.G_EXC_ERROR;
4001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003: WHEN OTHERS THEN
4004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4005: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4005: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4007: FND_MSG_PUB.ADD;
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: END find_persons;
4010:
4011: PROCEDURE find_persons (
4012: p_rule_id IN NUMBER,

Line 4067: WHEN FND_API.G_EXC_ERROR THEN

4063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4064: 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);
4065: END IF;
4066: EXCEPTION
4067: WHEN FND_API.G_EXC_ERROR THEN
4068: RAISE FND_API.G_EXC_ERROR;
4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4071: WHEN OTHERS THEN

Line 4068: RAISE FND_API.G_EXC_ERROR;

4064: 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);
4065: END IF;
4066: EXCEPTION
4067: WHEN FND_API.G_EXC_ERROR THEN
4068: RAISE FND_API.G_EXC_ERROR;
4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4071: WHEN OTHERS THEN
4072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4065: END IF;
4066: EXCEPTION
4067: WHEN FND_API.G_EXC_ERROR THEN
4068: RAISE FND_API.G_EXC_ERROR;
4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4071: WHEN OTHERS THEN
4072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4073: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');

Line 4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4066: EXCEPTION
4067: WHEN FND_API.G_EXC_ERROR THEN
4068: RAISE FND_API.G_EXC_ERROR;
4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4071: WHEN OTHERS THEN
4072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4073: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4073: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4075: FND_MSG_PUB.ADD;
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: END find_party_details;
4078:
4079: PROCEDURE find_duplicate_parties (
4080: p_rule_id IN NUMBER,

Line 4184: WHEN FND_API.G_EXC_ERROR THEN

4180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4181: 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);
4182: END IF;
4183: EXCEPTION
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN

Line 4185: RAISE FND_API.G_EXC_ERROR;

4181: 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);
4182: END IF;
4183: EXCEPTION
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4182: END IF;
4183: EXCEPTION
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');

Line 4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4183: EXCEPTION
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: END find_duplicate_parties;
4195:
4196: PROCEDURE find_duplicate_party_sites (
4197: p_rule_id IN NUMBER,

Line 4269: WHEN FND_API.G_EXC_ERROR THEN

4265: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4266: 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);
4267: END IF;
4268: EXCEPTION
4269: WHEN FND_API.G_EXC_ERROR THEN
4270: RAISE FND_API.G_EXC_ERROR;
4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4273: WHEN OTHERS THEN

Line 4270: RAISE FND_API.G_EXC_ERROR;

4266: 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);
4267: END IF;
4268: EXCEPTION
4269: WHEN FND_API.G_EXC_ERROR THEN
4270: RAISE FND_API.G_EXC_ERROR;
4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4273: WHEN OTHERS THEN
4274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4267: END IF;
4268: EXCEPTION
4269: WHEN FND_API.G_EXC_ERROR THEN
4270: RAISE FND_API.G_EXC_ERROR;
4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4273: WHEN OTHERS THEN
4274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');

Line 4272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4268: EXCEPTION
4269: WHEN FND_API.G_EXC_ERROR THEN
4270: RAISE FND_API.G_EXC_ERROR;
4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4273: WHEN OTHERS THEN
4274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4277: FND_MSG_PUB.ADD;
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: END find_duplicate_party_sites;
4280:
4281: PROCEDURE find_duplicate_contacts (
4282: p_rule_id IN NUMBER,

Line 4358: WHEN FND_API.G_EXC_ERROR THEN

4354: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4355: 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);
4356: END IF;
4357: EXCEPTION
4358: WHEN FND_API.G_EXC_ERROR THEN
4359: RAISE FND_API.G_EXC_ERROR;
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: WHEN OTHERS THEN

Line 4359: RAISE FND_API.G_EXC_ERROR;

4355: 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);
4356: END IF;
4357: EXCEPTION
4358: WHEN FND_API.G_EXC_ERROR THEN
4359: RAISE FND_API.G_EXC_ERROR;
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: WHEN OTHERS THEN
4363: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4356: END IF;
4357: EXCEPTION
4358: WHEN FND_API.G_EXC_ERROR THEN
4359: RAISE FND_API.G_EXC_ERROR;
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: WHEN OTHERS THEN
4363: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4364: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');

Line 4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4357: EXCEPTION
4358: WHEN FND_API.G_EXC_ERROR THEN
4359: RAISE FND_API.G_EXC_ERROR;
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: WHEN OTHERS THEN
4363: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4364: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4365: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4363: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4364: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4365: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4366: FND_MSG_PUB.ADD;
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: END find_duplicate_contacts;
4369:
4370: PROCEDURE find_duplicate_contact_points (
4371: p_rule_id IN NUMBER,

Line 4431: WHEN FND_API.G_EXC_ERROR THEN

4427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4428: 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);
4429: END IF;
4430: EXCEPTION
4431: WHEN FND_API.G_EXC_ERROR THEN
4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN

Line 4432: RAISE FND_API.G_EXC_ERROR;

4428: 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);
4429: END IF;
4430: EXCEPTION
4431: WHEN FND_API.G_EXC_ERROR THEN
4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4429: END IF;
4430: EXCEPTION
4431: WHEN FND_API.G_EXC_ERROR THEN
4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');

Line 4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4430: EXCEPTION
4431: WHEN FND_API.G_EXC_ERROR THEN
4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4439: FND_MSG_PUB.ADD;
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: END find_duplicate_contact_points;
4442:
4443: PROCEDURE find_parties_dynamic (
4444: p_rule_id IN NUMBER,

Line 4719: WHEN FND_API.G_EXC_ERROR THEN

4715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4716: 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);
4717: END IF;
4718: EXCEPTION
4719: WHEN FND_API.G_EXC_ERROR THEN
4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN

Line 4720: RAISE FND_API.G_EXC_ERROR;

4716: 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);
4717: END IF;
4718: EXCEPTION
4719: WHEN FND_API.G_EXC_ERROR THEN
4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4717: END IF;
4718: EXCEPTION
4719: WHEN FND_API.G_EXC_ERROR THEN
4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');

Line 4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4718: EXCEPTION
4719: WHEN FND_API.G_EXC_ERROR THEN
4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: END call_api_dynamic;
4730:
4731:
4732: PROCEDURE get_matching_party_sites (

Line 4955: WHEN FND_API.G_EXC_ERROR THEN

4951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4952: 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);
4953: END IF;
4954: EXCEPTION
4955: WHEN FND_API.G_EXC_ERROR THEN
4956: RAISE FND_API.G_EXC_ERROR;
4957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: WHEN OTHERS THEN

Line 4956: RAISE FND_API.G_EXC_ERROR;

4952: 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);
4953: END IF;
4954: EXCEPTION
4955: WHEN FND_API.G_EXC_ERROR THEN
4956: RAISE FND_API.G_EXC_ERROR;
4957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: WHEN OTHERS THEN
4960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4953: END IF;
4954: EXCEPTION
4955: WHEN FND_API.G_EXC_ERROR THEN
4956: RAISE FND_API.G_EXC_ERROR;
4957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: WHEN OTHERS THEN
4960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');

Line 4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4954: EXCEPTION
4955: WHEN FND_API.G_EXC_ERROR THEN
4956: RAISE FND_API.G_EXC_ERROR;
4957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: WHEN OTHERS THEN
4960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4963: FND_MSG_PUB.ADD;
4964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4965: END get_matching_party_sites;
4966:
4967:
4968: PROCEDURE get_matching_contacts (

Line 5180: WHEN FND_API.G_EXC_ERROR THEN

5176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5177: 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);
5178: END IF;
5179: EXCEPTION
5180: WHEN FND_API.G_EXC_ERROR THEN
5181: RAISE FND_API.G_EXC_ERROR;
5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5184: WHEN OTHERS THEN

Line 5181: RAISE FND_API.G_EXC_ERROR;

5177: 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);
5178: END IF;
5179: EXCEPTION
5180: WHEN FND_API.G_EXC_ERROR THEN
5181: RAISE FND_API.G_EXC_ERROR;
5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5184: WHEN OTHERS THEN
5185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5178: END IF;
5179: EXCEPTION
5180: WHEN FND_API.G_EXC_ERROR THEN
5181: RAISE FND_API.G_EXC_ERROR;
5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5184: WHEN OTHERS THEN
5185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');

Line 5183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5179: EXCEPTION
5180: WHEN FND_API.G_EXC_ERROR THEN
5181: RAISE FND_API.G_EXC_ERROR;
5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5184: WHEN OTHERS THEN
5185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5188: FND_MSG_PUB.ADD;
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: END get_matching_contacts;
5191:
5192:
5193: PROCEDURE get_matching_contact_points (

Line 5319: WHEN FND_API.G_EXC_ERROR THEN

5315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5316: 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);
5317: END IF;
5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN

Line 5320: RAISE FND_API.G_EXC_ERROR;

5316: 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);
5317: END IF;
5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5317: END IF;
5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');

Line 5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5318: EXCEPTION
5319: WHEN FND_API.G_EXC_ERROR THEN
5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5327: FND_MSG_PUB.ADD;
5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5329: END get_matching_contact_points;
5330:
5331: /**********************************************************
5332: This procedure finds the score details for a specific party that

Line 5530: WHEN FND_API.G_EXC_ERROR THEN

5526: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5527: 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);
5528: END IF;
5529: EXCEPTION
5530: WHEN FND_API.G_EXC_ERROR THEN
5531: RAISE FND_API.G_EXC_ERROR;
5532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5534: WHEN OTHERS THEN

Line 5531: RAISE FND_API.G_EXC_ERROR;

5527: 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);
5528: END IF;
5529: EXCEPTION
5530: WHEN FND_API.G_EXC_ERROR THEN
5531: RAISE FND_API.G_EXC_ERROR;
5532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5534: WHEN OTHERS THEN
5535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5528: END IF;
5529: EXCEPTION
5530: WHEN FND_API.G_EXC_ERROR THEN
5531: RAISE FND_API.G_EXC_ERROR;
5532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5534: WHEN OTHERS THEN
5535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');

Line 5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5529: EXCEPTION
5530: WHEN FND_API.G_EXC_ERROR THEN
5531: RAISE FND_API.G_EXC_ERROR;
5532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5534: WHEN OTHERS THEN
5535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5538: FND_MSG_PUB.ADD;
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: END get_score_details;
5541:
5542:
5543: /************************************************

Line 5608: WHEN FND_API.G_EXC_ERROR THEN

5604: END LOOP;
5605: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5606: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5607: EXCEPTION
5608: WHEN FND_API.G_EXC_ERROR THEN
5609: RAISE FND_API.G_EXC_ERROR;
5610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: WHEN OTHERS THEN

Line 5609: RAISE FND_API.G_EXC_ERROR;

5605: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5606: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5607: EXCEPTION
5608: WHEN FND_API.G_EXC_ERROR THEN
5609: RAISE FND_API.G_EXC_ERROR;
5610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: WHEN OTHERS THEN
5613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5606: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5607: EXCEPTION
5608: WHEN FND_API.G_EXC_ERROR THEN
5609: RAISE FND_API.G_EXC_ERROR;
5610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: WHEN OTHERS THEN
5613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5614: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5607: EXCEPTION
5608: WHEN FND_API.G_EXC_ERROR THEN
5609: RAISE FND_API.G_EXC_ERROR;
5610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: WHEN OTHERS THEN
5613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5614: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5614: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5616: FND_MSG_PUB.ADD;
5617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5618: END get_party_for_search;
5619:
5620: PROCEDURE get_search_criteria (
5621: p_party_id IN NUMBER,

Line 5648: WHEN FND_API.G_EXC_ERROR THEN

5644: END IF;
5645: get_party_site_rec(p_party_site_ids, x_party_site_list);
5646: END IF;
5647: EXCEPTION
5648: WHEN FND_API.G_EXC_ERROR THEN
5649: RAISE FND_API.G_EXC_ERROR;
5650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: WHEN OTHERS THEN

Line 5649: RAISE FND_API.G_EXC_ERROR;

5645: get_party_site_rec(p_party_site_ids, x_party_site_list);
5646: END IF;
5647: EXCEPTION
5648: WHEN FND_API.G_EXC_ERROR THEN
5649: RAISE FND_API.G_EXC_ERROR;
5650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: WHEN OTHERS THEN
5653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5646: END IF;
5647: EXCEPTION
5648: WHEN FND_API.G_EXC_ERROR THEN
5649: RAISE FND_API.G_EXC_ERROR;
5650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: WHEN OTHERS THEN
5653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5654: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5647: EXCEPTION
5648: WHEN FND_API.G_EXC_ERROR THEN
5649: RAISE FND_API.G_EXC_ERROR;
5650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: WHEN OTHERS THEN
5653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5654: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5654: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5656: FND_MSG_PUB.ADD;
5657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5658: END get_search_criteria;
5659:
5660:
5661: /************************************************

Line 5724: RAISE FND_API.G_EXC_ERROR;

5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5721: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5723: FND_MSG_PUB.ADD;
5724: RAISE FND_API.G_EXC_ERROR;
5725: END get_party_rec;
5726:
5727: /************************************************
5728: This procedure retrieves the match rule party site attributes into

Line 5784: RAISE FND_API.G_EXC_ERROR;

5780: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5781: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5783: FND_MSG_PUB.ADD;
5784: RAISE FND_API.G_EXC_ERROR;
5785: END get_party_site_rec;
5786:
5787: /************************************************
5788: This procedure retrieves the match rule contact attributes into

Line 5840: RAISE FND_API.G_EXC_ERROR;

5836: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END get_contact_rec;
5842:
5843: /************************************************
5844: This procedure retrieves the match rule contact point attributes into

Line 5892: RAISE FND_API.G_EXC_ERROR;

5888: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5889: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_ERROR;
5893: END get_contact_point_rec;
5894:
5895: /************************************************
5896: This procedure maps a search record from the logical

Line 6045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6041: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6044: FND_MSG_PUB.ADD;
6045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6046: END;
6047:
6048:
6049: /************************************************

Line 6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6210: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6211: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6212: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6213: FND_MSG_PUB.ADD;
6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6215: END;
6216:
6217:
6218: /************************************************

Line 6257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6253: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6254: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6258: END;
6259:
6260:
6261: /************************************************

Line 6309: WHEN FND_API.G_EXC_ERROR THEN

6305: END IF;
6306: END LOOP;
6307: RETURN FALSE;
6308: EXCEPTION
6309: WHEN FND_API.G_EXC_ERROR THEN
6310: RAISE FND_API.G_EXC_ERROR;
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6310: RAISE FND_API.G_EXC_ERROR;

6306: END LOOP;
6307: RETURN FALSE;
6308: EXCEPTION
6309: WHEN FND_API.G_EXC_ERROR THEN
6310: RAISE FND_API.G_EXC_ERROR;
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6317: END check_prim_cond;
6318:
6319: /************************************************
6320: This procedure checks if the input search condition

Line 6366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6363: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6365: FND_MSG_PUB.ADD;
6366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6367: END check_party_site_cond;
6368:
6369: /************************************************
6370: This procedure checks if the input search condition

Line 6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END check_contact_cond;
6406:
6407: /************************************************
6408: This procedure checks if the input search condition

Line 6425: RAISE FND_API.G_EXC_ERROR;

6421: FOR I IN 1..p_contact_point_list.COUNT LOOP
6422: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6423: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6424: FND_MSG_PUB.ADD;
6425: RAISE FND_API.G_EXC_ERROR;
6426: END IF;
6427: END LOOP;
6428:
6429: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6438: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6442: END check_contact_point_cond;
6443:
6444: FUNCTION check_staged RETURN BOOLEAN IS
6445: