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 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_party_site_cursor(

Line 1786: RAISE FND_API.G_EXC_ERROR;

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

Line 1790: RAISE FND_API.G_EXC_ERROR;

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

Line 1794: RAISE FND_API.G_EXC_ERROR;

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

Line 1799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1933: RAISE FND_API.G_EXC_ERROR;

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

Line 1937: RAISE FND_API.G_EXC_ERROR;

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

Line 1941: RAISE FND_API.G_EXC_ERROR;

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

Line 1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2206: RAISE FND_API.G_EXC_ERROR;

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

Line 2210: RAISE FND_API.G_EXC_ERROR;

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

Line 2214: RAISE FND_API.G_EXC_ERROR;

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

Line 2219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2471: RAISE FND_API.G_EXC_ERROR;

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

Line 2519: RAISE FND_API.G_EXC_ERROR;

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

Line 2592: RAISE FND_API.G_EXC_ERROR;

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

Line 2704: RAISE FND_API.G_EXC_ERROR;

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

Line 2815: RAISE FND_API.G_EXC_ERROR;

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

Line 2959: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3209: WHEN FND_API.G_EXC_ERROR THEN

3205: END IF;
3206: EXCEPTION
3207: WHEN L_RETURN_IMM_EXC THEN
3208: RETURN;
3209: WHEN FND_API.G_EXC_ERROR THEN
3210: RAISE FND_API.G_EXC_ERROR;
3211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3213: WHEN OTHERS THEN

Line 3210: RAISE FND_API.G_EXC_ERROR;

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

Line 3211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3410: RAISE FND_API.G_EXC_ERROR;

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

Line 3458: RAISE FND_API.G_EXC_ERROR;

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

Line 3494: RAISE FND_API.G_EXC_ERROR;

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

Line 3498: RAISE FND_API.G_EXC_ERROR;

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

Line 3500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3570: RAISE FND_API.G_EXC_ERROR;

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

Line 3759: RAISE FND_API.G_EXC_ERROR;

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

Line 3847: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3995: WHEN FND_API.G_EXC_ERROR THEN

3991: END IF;
3992: EXCEPTION
3993: WHEN L_RETURN_IMM_EXC THEN
3994: RETURN;
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN

Line 3996: RAISE FND_API.G_EXC_ERROR;

3992: EXCEPTION
3993: WHEN L_RETURN_IMM_EXC THEN
3994: RETURN;
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3993: WHEN L_RETURN_IMM_EXC THEN
3994: RETURN;
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');

Line 3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3994: RETURN;
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4063: WHEN FND_API.G_EXC_ERROR THEN

4059: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4060: 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);
4061: END IF;
4062: EXCEPTION
4063: WHEN FND_API.G_EXC_ERROR THEN
4064: RAISE FND_API.G_EXC_ERROR;
4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: WHEN OTHERS THEN

Line 4064: RAISE FND_API.G_EXC_ERROR;

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

Line 4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4061: END IF;
4062: EXCEPTION
4063: WHEN FND_API.G_EXC_ERROR THEN
4064: RAISE FND_API.G_EXC_ERROR;
4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: WHEN OTHERS THEN
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');

Line 4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4062: EXCEPTION
4063: WHEN FND_API.G_EXC_ERROR THEN
4064: RAISE FND_API.G_EXC_ERROR;
4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: WHEN OTHERS THEN
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4180: WHEN FND_API.G_EXC_ERROR THEN

4176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4177: 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);
4178: END IF;
4179: EXCEPTION
4180: WHEN FND_API.G_EXC_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN

Line 4181: RAISE FND_API.G_EXC_ERROR;

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

Line 4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4178: END IF;
4179: EXCEPTION
4180: WHEN FND_API.G_EXC_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');

Line 4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4179: EXCEPTION
4180: WHEN FND_API.G_EXC_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4265: WHEN FND_API.G_EXC_ERROR THEN

4261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4262: 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);
4263: END IF;
4264: EXCEPTION
4265: WHEN FND_API.G_EXC_ERROR THEN
4266: RAISE FND_API.G_EXC_ERROR;
4267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: WHEN OTHERS THEN

Line 4266: RAISE FND_API.G_EXC_ERROR;

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

Line 4267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4263: END IF;
4264: EXCEPTION
4265: WHEN FND_API.G_EXC_ERROR THEN
4266: RAISE FND_API.G_EXC_ERROR;
4267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: WHEN OTHERS THEN
4270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4271: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');

Line 4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4264: EXCEPTION
4265: WHEN FND_API.G_EXC_ERROR THEN
4266: RAISE FND_API.G_EXC_ERROR;
4267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: WHEN OTHERS THEN
4270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4271: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4272: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4354: WHEN FND_API.G_EXC_ERROR THEN

4350: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4351: 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);
4352: END IF;
4353: EXCEPTION
4354: WHEN FND_API.G_EXC_ERROR THEN
4355: RAISE FND_API.G_EXC_ERROR;
4356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: WHEN OTHERS THEN

Line 4355: RAISE FND_API.G_EXC_ERROR;

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

Line 4356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4352: END IF;
4353: EXCEPTION
4354: WHEN FND_API.G_EXC_ERROR THEN
4355: RAISE FND_API.G_EXC_ERROR;
4356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: WHEN OTHERS THEN
4359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4360: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');

Line 4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4353: EXCEPTION
4354: WHEN FND_API.G_EXC_ERROR THEN
4355: RAISE FND_API.G_EXC_ERROR;
4356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: WHEN OTHERS THEN
4359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4360: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4427: WHEN FND_API.G_EXC_ERROR THEN

4423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4424: 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);
4425: END IF;
4426: EXCEPTION
4427: WHEN FND_API.G_EXC_ERROR THEN
4428: RAISE FND_API.G_EXC_ERROR;
4429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4431: WHEN OTHERS THEN

Line 4428: RAISE FND_API.G_EXC_ERROR;

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

Line 4429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4425: END IF;
4426: EXCEPTION
4427: WHEN FND_API.G_EXC_ERROR THEN
4428: RAISE FND_API.G_EXC_ERROR;
4429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4431: WHEN OTHERS THEN
4432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');

Line 4430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4426: EXCEPTION
4427: WHEN FND_API.G_EXC_ERROR THEN
4428: RAISE FND_API.G_EXC_ERROR;
4429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4431: WHEN OTHERS THEN
4432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4715: WHEN FND_API.G_EXC_ERROR THEN

4711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4712: 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);
4713: END IF;
4714: EXCEPTION
4715: WHEN FND_API.G_EXC_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN

Line 4716: RAISE FND_API.G_EXC_ERROR;

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

Line 4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4713: END IF;
4714: EXCEPTION
4715: WHEN FND_API.G_EXC_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');

Line 4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4714: EXCEPTION
4715: WHEN FND_API.G_EXC_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: END call_api_dynamic;
4726:
4727:
4728: PROCEDURE get_matching_party_sites (

Line 4951: WHEN FND_API.G_EXC_ERROR THEN

4947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4948: 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);
4949: END IF;
4950: EXCEPTION
4951: WHEN FND_API.G_EXC_ERROR THEN
4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN

Line 4952: RAISE FND_API.G_EXC_ERROR;

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

Line 4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4949: END IF;
4950: EXCEPTION
4951: WHEN FND_API.G_EXC_ERROR THEN
4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');

Line 4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4950: EXCEPTION
4951: WHEN FND_API.G_EXC_ERROR THEN
4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4959: FND_MSG_PUB.ADD;
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: END get_matching_party_sites;
4962:
4963:
4964: PROCEDURE get_matching_contacts (

Line 5176: WHEN FND_API.G_EXC_ERROR THEN

5172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5173: 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);
5174: END IF;
5175: EXCEPTION
5176: WHEN FND_API.G_EXC_ERROR THEN
5177: RAISE FND_API.G_EXC_ERROR;
5178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5180: WHEN OTHERS THEN

Line 5177: RAISE FND_API.G_EXC_ERROR;

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

Line 5178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5174: END IF;
5175: EXCEPTION
5176: WHEN FND_API.G_EXC_ERROR THEN
5177: RAISE FND_API.G_EXC_ERROR;
5178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5180: WHEN OTHERS THEN
5181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');

Line 5179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5175: EXCEPTION
5176: WHEN FND_API.G_EXC_ERROR THEN
5177: RAISE FND_API.G_EXC_ERROR;
5178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5180: WHEN OTHERS THEN
5181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5184: FND_MSG_PUB.ADD;
5185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5186: END get_matching_contacts;
5187:
5188:
5189: PROCEDURE get_matching_contact_points (

Line 5315: WHEN FND_API.G_EXC_ERROR THEN

5311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5312: 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);
5313: END IF;
5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN

Line 5316: RAISE FND_API.G_EXC_ERROR;

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

Line 5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5313: END IF;
5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');

Line 5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5525: WHEN FND_API.G_EXC_ERROR THEN

5521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5522: 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);
5523: END IF;
5524: EXCEPTION
5525: WHEN FND_API.G_EXC_ERROR THEN
5526: RAISE FND_API.G_EXC_ERROR;
5527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5529: WHEN OTHERS THEN

Line 5526: RAISE FND_API.G_EXC_ERROR;

5522: 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);
5523: END IF;
5524: EXCEPTION
5525: WHEN FND_API.G_EXC_ERROR THEN
5526: RAISE FND_API.G_EXC_ERROR;
5527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5529: WHEN OTHERS THEN
5530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5523: END IF;
5524: EXCEPTION
5525: WHEN FND_API.G_EXC_ERROR THEN
5526: RAISE FND_API.G_EXC_ERROR;
5527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5529: WHEN OTHERS THEN
5530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');

Line 5528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5524: EXCEPTION
5525: WHEN FND_API.G_EXC_ERROR THEN
5526: RAISE FND_API.G_EXC_ERROR;
5527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5529: WHEN OTHERS THEN
5530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5533: FND_MSG_PUB.ADD;
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: END get_score_details;
5536:
5537:
5538: /************************************************

Line 5603: WHEN FND_API.G_EXC_ERROR THEN

5599: END LOOP;
5600: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5601: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5602: EXCEPTION
5603: WHEN FND_API.G_EXC_ERROR THEN
5604: RAISE FND_API.G_EXC_ERROR;
5605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5607: WHEN OTHERS THEN

Line 5604: RAISE FND_API.G_EXC_ERROR;

5600: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5601: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5602: EXCEPTION
5603: WHEN FND_API.G_EXC_ERROR THEN
5604: RAISE FND_API.G_EXC_ERROR;
5605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5607: WHEN OTHERS THEN
5608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5601: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5602: EXCEPTION
5603: WHEN FND_API.G_EXC_ERROR THEN
5604: RAISE FND_API.G_EXC_ERROR;
5605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5607: WHEN OTHERS THEN
5608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5609: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5602: EXCEPTION
5603: WHEN FND_API.G_EXC_ERROR THEN
5604: RAISE FND_API.G_EXC_ERROR;
5605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5607: WHEN OTHERS THEN
5608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5609: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5609: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5611: FND_MSG_PUB.ADD;
5612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5613: END get_party_for_search;
5614:
5615: PROCEDURE get_search_criteria (
5616: p_party_id IN NUMBER,

Line 5643: WHEN FND_API.G_EXC_ERROR THEN

5639: END IF;
5640: get_party_site_rec(p_party_site_ids, x_party_site_list);
5641: END IF;
5642: EXCEPTION
5643: WHEN FND_API.G_EXC_ERROR THEN
5644: RAISE FND_API.G_EXC_ERROR;
5645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: WHEN OTHERS THEN

Line 5644: RAISE FND_API.G_EXC_ERROR;

5640: get_party_site_rec(p_party_site_ids, x_party_site_list);
5641: END IF;
5642: EXCEPTION
5643: WHEN FND_API.G_EXC_ERROR THEN
5644: RAISE FND_API.G_EXC_ERROR;
5645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: WHEN OTHERS THEN
5648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5641: END IF;
5642: EXCEPTION
5643: WHEN FND_API.G_EXC_ERROR THEN
5644: RAISE FND_API.G_EXC_ERROR;
5645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: WHEN OTHERS THEN
5648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5649: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5642: EXCEPTION
5643: WHEN FND_API.G_EXC_ERROR THEN
5644: RAISE FND_API.G_EXC_ERROR;
5645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: WHEN OTHERS THEN
5648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5649: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5650: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5649: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5650: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5651: FND_MSG_PUB.ADD;
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5653: END get_search_criteria;
5654:
5655:
5656: /************************************************

Line 5719: RAISE FND_API.G_EXC_ERROR;

5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5716: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5718: FND_MSG_PUB.ADD;
5719: RAISE FND_API.G_EXC_ERROR;
5720: END get_party_rec;
5721:
5722: /************************************************
5723: This procedure retrieves the match rule party site attributes into

Line 5779: RAISE FND_API.G_EXC_ERROR;

5775: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5778: FND_MSG_PUB.ADD;
5779: RAISE FND_API.G_EXC_ERROR;
5780: END get_party_site_rec;
5781:
5782: /************************************************
5783: This procedure retrieves the match rule contact attributes into

Line 5835: RAISE FND_API.G_EXC_ERROR;

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

Line 5887: RAISE FND_API.G_EXC_ERROR;

5883: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5884: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5886: FND_MSG_PUB.ADD;
5887: RAISE FND_API.G_EXC_ERROR;
5888: END get_contact_point_rec;
5889:
5890: /************************************************
5891: This procedure maps a search record from the logical

Line 6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6036: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END;
6042:
6043:
6044: /************************************************

Line 6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6166: FND_MSG_PUB.ADD;
6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6168: END;
6169:
6170:
6171: /************************************************

Line 6209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6208: FND_MSG_PUB.ADD;
6209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6210: END;
6211:
6212:
6213: /************************************************

Line 6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6248: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6249: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6251: FND_MSG_PUB.ADD;
6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6253: END;
6254:
6255:
6256: /************************************************

Line 6304: WHEN FND_API.G_EXC_ERROR THEN

6300: END IF;
6301: END LOOP;
6302: RETURN FALSE;
6303: EXCEPTION
6304: WHEN FND_API.G_EXC_ERROR THEN
6305: RAISE FND_API.G_EXC_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6305: RAISE FND_API.G_EXC_ERROR;

6301: END LOOP;
6302: RETURN FALSE;
6303: EXCEPTION
6304: WHEN FND_API.G_EXC_ERROR THEN
6305: RAISE FND_API.G_EXC_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6312: END check_prim_cond;
6313:
6314: /************************************************
6315: This procedure checks if the input search condition

Line 6361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6358: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6360: FND_MSG_PUB.ADD;
6361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6362: END check_party_site_cond;
6363:
6364: /************************************************
6365: This procedure checks if the input search condition

Line 6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6396: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6398: FND_MSG_PUB.ADD;
6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6400: END check_contact_cond;
6401:
6402: /************************************************
6403: This procedure checks if the input search condition

Line 6420: RAISE FND_API.G_EXC_ERROR;

6416: FOR I IN 1..p_contact_point_list.COUNT LOOP
6417: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6418: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6419: FND_MSG_PUB.ADD;
6420: RAISE FND_API.G_EXC_ERROR;
6421: END IF;
6422: END LOOP;
6423:
6424: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6433: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6435: FND_MSG_PUB.ADD;
6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6437: END check_contact_point_cond;
6438:
6439: FUNCTION check_staged RETURN BOOLEAN IS
6440: