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_39 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 564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

560: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
561: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END;
566:
567:
568: /************************************************

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

580: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
581: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END;
586:
587:
588: /************************************************

Line 604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

600: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
601: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END;
606:
607:
608: /************************************************

Line 624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
621: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END;
626:
627: PROCEDURE init_score_context (
628: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 691: RAISE FND_API.G_EXC_ERROR;

687: p_contact_list,
688: p_contact_point_list) THEN
689: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
694: 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);
695: END IF;

Line 909: RAISE FND_API.G_EXC_ERROR;

905: IF lengthb(l_party_contains_str) > 4000 THEN
906: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
907: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
908: FND_MSG_PUB.ADD;
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
911: IF (p_match_str = ' AND ' OR p_party_max_score 912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
913: 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 971: RAISE FND_API.G_EXC_ERROR;

967: IF lengthb(l_contains_str) > 4000 THEN
968: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
969: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973: x_denorm_str := l_den_contains_str;
974: RETURN l_contains_str;
975: END;

Line 1236: RAISE FND_API.G_EXC_ERROR;

1232: when others then
1233: if (instrb(SQLERRM,'DRG-51030')>0) then
1234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1235: FND_MSG_PUB.ADD;
1236: RAISE FND_API.G_EXC_ERROR;
1237: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;

Line 1240: RAISE FND_API.G_EXC_ERROR;

1236: RAISE FND_API.G_EXC_ERROR;
1237: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;

Line 1244: RAISE FND_API.G_EXC_ERROR;

1240: RAISE FND_API.G_EXC_ERROR;
1241: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: else
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1248: FND_MSG_PUB.ADD;

Line 1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1245: else
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1250: end if;
1251: END;
1252:
1253: PROCEDURE open_party_site_cursor(

Line 1481: RAISE FND_API.G_EXC_ERROR;

1477: when others then
1478: if (instrb(SQLERRM,'DRG-51030')>0) then
1479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1480: FND_MSG_PUB.ADD;
1481: RAISE FND_API.G_EXC_ERROR;
1482: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1484: FND_MSG_PUB.ADD;
1485: RAISE FND_API.G_EXC_ERROR;

Line 1485: RAISE FND_API.G_EXC_ERROR;

1481: RAISE FND_API.G_EXC_ERROR;
1482: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1484: FND_MSG_PUB.ADD;
1485: RAISE FND_API.G_EXC_ERROR;
1486: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;

Line 1489: RAISE FND_API.G_EXC_ERROR;

1485: RAISE FND_API.G_EXC_ERROR;
1486: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: else
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1492: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1493: FND_MSG_PUB.ADD;

Line 1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1490: else
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1492: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1493: FND_MSG_PUB.ADD;
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: end if;
1496: END;
1497:
1498: PROCEDURE open_contact_cursor(

Line 1628: RAISE FND_API.G_EXC_ERROR;

1624: when others then
1625: if (instrb(SQLERRM,'DRG-51030')>0) then
1626: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1627: FND_MSG_PUB.ADD;
1628: RAISE FND_API.G_EXC_ERROR;
1629: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1631: FND_MSG_PUB.ADD;
1632: RAISE FND_API.G_EXC_ERROR;

Line 1632: RAISE FND_API.G_EXC_ERROR;

1628: RAISE FND_API.G_EXC_ERROR;
1629: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1631: FND_MSG_PUB.ADD;
1632: RAISE FND_API.G_EXC_ERROR;
1633: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;

Line 1636: RAISE FND_API.G_EXC_ERROR;

1632: RAISE FND_API.G_EXC_ERROR;
1633: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: else
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1639: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1640: FND_MSG_PUB.ADD;

Line 1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1637: else
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1639: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1640: FND_MSG_PUB.ADD;
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: end if;
1643: END;
1644:
1645: PROCEDURE open_contact_pt_cursor(

Line 1901: RAISE FND_API.G_EXC_ERROR;

1897: when others then
1898: if (instrb(SQLERRM,'DRG-51030')>0) then
1899: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1900: FND_MSG_PUB.ADD;
1901: RAISE FND_API.G_EXC_ERROR;
1902: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1904: FND_MSG_PUB.ADD;
1905: RAISE FND_API.G_EXC_ERROR;

Line 1905: RAISE FND_API.G_EXC_ERROR;

1901: RAISE FND_API.G_EXC_ERROR;
1902: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1904: FND_MSG_PUB.ADD;
1905: RAISE FND_API.G_EXC_ERROR;
1906: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;

Line 1909: RAISE FND_API.G_EXC_ERROR;

1905: RAISE FND_API.G_EXC_ERROR;
1906: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: else
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1913: FND_MSG_PUB.ADD;

Line 1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1910: else
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1913: FND_MSG_PUB.ADD;
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1915: end if;
1916: END;
1917:
1918:

Line 2164: RAISE FND_API.G_EXC_ERROR;

2160: 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);
2161: END IF;
2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: ELSE
2166: push_eval;
2167: RETURN;
2168: END IF;

Line 2212: RAISE FND_API.G_EXC_ERROR;

2208: 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);
2209: END IF;
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSE
2214: push_eval;
2215: RETURN;
2216: END IF;

Line 2285: RAISE FND_API.G_EXC_ERROR;

2281: 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);
2282: END IF;
2283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2284: FND_MSG_PUB.ADD;
2285: RAISE FND_API.G_EXC_ERROR;
2286: ELSE
2287: push_eval;
2288: RETURN;
2289: END IF;

Line 2397: RAISE FND_API.G_EXC_ERROR;

2393: 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);
2394: END IF;
2395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2396: FND_MSG_PUB.ADD;
2397: RAISE FND_API.G_EXC_ERROR;
2398: ELSE
2399: push_eval;
2400: RETURN;
2401: END IF;

Line 2508: RAISE FND_API.G_EXC_ERROR;

2504: 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);
2505: END IF;
2506: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2507: FND_MSG_PUB.ADD;
2508: RAISE FND_API.G_EXC_ERROR;
2509: ELSE
2510: push_eval;
2511: RETURN;
2512: END IF;

Line 2733: RAISE FND_API.G_EXC_ERROR;

2729: 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);
2730: END IF;
2731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735: ELSE
2736: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2737: 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 2741: RAISE FND_API.G_EXC_ERROR;

2737: 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);
2738: END IF;
2739: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2740: FND_MSG_PUB.ADD;
2741: RAISE FND_API.G_EXC_ERROR;
2742: END IF;
2743: END IF;
2744: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2745: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2940: WHEN FND_API.G_EXC_ERROR THEN

2936: END IF;
2937: EXCEPTION
2938: WHEN L_RETURN_IMM_EXC THEN
2939: RETURN;
2940: WHEN FND_API.G_EXC_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: WHEN OTHERS THEN

Line 2941: RAISE FND_API.G_EXC_ERROR;

2937: EXCEPTION
2938: WHEN L_RETURN_IMM_EXC THEN
2939: RETURN;
2940: WHEN FND_API.G_EXC_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: WHEN OTHERS THEN
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2938: WHEN L_RETURN_IMM_EXC THEN
2939: RETURN;
2940: WHEN FND_API.G_EXC_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: WHEN OTHERS THEN
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_parties');

Line 2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2939: RETURN;
2940: WHEN FND_API.G_EXC_ERROR THEN
2941: RAISE FND_API.G_EXC_ERROR;
2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: WHEN OTHERS THEN
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_parties');
2947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_parties');
2947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2950: END find_parties;
2951:
2952: PROCEDURE find_persons (
2953: p_rule_id IN NUMBER,

Line 3139: RAISE FND_API.G_EXC_ERROR;

3135: 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);
3136: END IF;
3137: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3138: FND_MSG_PUB.ADD;
3139: RAISE FND_API.G_EXC_ERROR;
3140: ELSE
3141: push_eval;
3142: RETURN;
3143: END IF;

Line 3187: RAISE FND_API.G_EXC_ERROR;

3183: 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);
3184: END IF;
3185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3186: FND_MSG_PUB.ADD;
3187: RAISE FND_API.G_EXC_ERROR;
3188: ELSE
3189: push_eval;
3190: RETURN;
3191: END IF;

Line 3223: RAISE FND_API.G_EXC_ERROR;

3219: when others then
3220: if (instrb(SQLERRM,'DRG-51030')>0) then
3221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3222: FND_MSG_PUB.ADD;
3223: RAISE FND_API.G_EXC_ERROR;
3224: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3226: FND_MSG_PUB.ADD;
3227: RAISE FND_API.G_EXC_ERROR;

Line 3227: RAISE FND_API.G_EXC_ERROR;

3223: RAISE FND_API.G_EXC_ERROR;
3224: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3226: FND_MSG_PUB.ADD;
3227: RAISE FND_API.G_EXC_ERROR;
3228: else
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: end if;
3231: END;

Line 3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3226: FND_MSG_PUB.ADD;
3227: RAISE FND_API.G_EXC_ERROR;
3228: else
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: end if;
3231: END;
3232:
3233: /** Private procedure to acquire and score at party site level ***/

Line 3299: RAISE FND_API.G_EXC_ERROR;

3295: 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);
3296: END IF;
3297: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3298: FND_MSG_PUB.ADD;
3299: RAISE FND_API.G_EXC_ERROR;
3300: ELSE
3301: push_eval;
3302: RETURN;
3303: END IF;

Line 3558: RAISE FND_API.G_EXC_ERROR;

3554: 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);
3555: END IF;
3556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3557: FND_MSG_PUB.ADD;
3558: RAISE FND_API.G_EXC_ERROR;
3559: ELSE
3560: push_eval;
3561: RETURN;
3562: END IF;

Line 3671: RAISE FND_API.G_EXC_ERROR;

3667: 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);
3668: END IF;
3669: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3670: FND_MSG_PUB.ADD;
3671: RAISE FND_API.G_EXC_ERROR;
3672: END IF;
3673: ELSE
3674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3675: 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 3679: RAISE FND_API.G_EXC_ERROR;

3675: 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);
3676: END IF;
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3678: FND_MSG_PUB.ADD;
3679: RAISE FND_API.G_EXC_ERROR;
3680: END IF;
3681: END IF;
3682: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3683: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3793: WHEN FND_API.G_EXC_ERROR THEN

3789: END IF;
3790: EXCEPTION
3791: WHEN L_RETURN_IMM_EXC THEN
3792: RETURN;
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN

Line 3794: RAISE FND_API.G_EXC_ERROR;

3790: EXCEPTION
3791: WHEN L_RETURN_IMM_EXC THEN
3792: RETURN;
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3791: WHEN L_RETURN_IMM_EXC THEN
3792: RETURN;
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');

Line 3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3792: RETURN;
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3801: FND_MSG_PUB.ADD;
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3803: END find_persons;
3804:
3805: PROCEDURE find_persons (
3806: p_rule_id IN NUMBER,

Line 3861: WHEN FND_API.G_EXC_ERROR THEN

3857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3858: 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);
3859: END IF;
3860: EXCEPTION
3861: WHEN FND_API.G_EXC_ERROR THEN
3862: RAISE FND_API.G_EXC_ERROR;
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN

Line 3862: RAISE FND_API.G_EXC_ERROR;

3858: 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);
3859: END IF;
3860: EXCEPTION
3861: WHEN FND_API.G_EXC_ERROR THEN
3862: RAISE FND_API.G_EXC_ERROR;
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3859: END IF;
3860: EXCEPTION
3861: WHEN FND_API.G_EXC_ERROR THEN
3862: RAISE FND_API.G_EXC_ERROR;
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');

Line 3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3860: EXCEPTION
3861: WHEN FND_API.G_EXC_ERROR THEN
3862: RAISE FND_API.G_EXC_ERROR;
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3869: FND_MSG_PUB.ADD;
3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3871: END find_party_details;
3872:
3873: PROCEDURE find_duplicate_parties (
3874: p_rule_id IN NUMBER,

Line 3978: WHEN FND_API.G_EXC_ERROR THEN

3974: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3975: 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);
3976: END IF;
3977: EXCEPTION
3978: WHEN FND_API.G_EXC_ERROR THEN
3979: RAISE FND_API.G_EXC_ERROR;
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982: WHEN OTHERS THEN

Line 3979: RAISE FND_API.G_EXC_ERROR;

3975: 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);
3976: END IF;
3977: EXCEPTION
3978: WHEN FND_API.G_EXC_ERROR THEN
3979: RAISE FND_API.G_EXC_ERROR;
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982: WHEN OTHERS THEN
3983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3976: END IF;
3977: EXCEPTION
3978: WHEN FND_API.G_EXC_ERROR THEN
3979: RAISE FND_API.G_EXC_ERROR;
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982: WHEN OTHERS THEN
3983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3984: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');

Line 3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3977: EXCEPTION
3978: WHEN FND_API.G_EXC_ERROR THEN
3979: RAISE FND_API.G_EXC_ERROR;
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982: WHEN OTHERS THEN
3983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3984: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3984: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3986: FND_MSG_PUB.ADD;
3987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3988: END find_duplicate_parties;
3989:
3990: PROCEDURE find_duplicate_party_sites (
3991: 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_duplicate_party_sites(-) ',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_duplicate_party_sites(-) ',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_39.find_duplicate_party_sites');

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_39.find_duplicate_party_sites');
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_39.find_duplicate_party_sites');
4070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4071: FND_MSG_PUB.ADD;
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END find_duplicate_party_sites;
4074:
4075: PROCEDURE find_duplicate_contacts (
4076: p_rule_id IN NUMBER,

Line 4152: WHEN FND_API.G_EXC_ERROR THEN

4148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4149: 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);
4150: END IF;
4151: EXCEPTION
4152: WHEN FND_API.G_EXC_ERROR THEN
4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN

Line 4153: RAISE FND_API.G_EXC_ERROR;

4149: 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);
4150: END IF;
4151: EXCEPTION
4152: WHEN FND_API.G_EXC_ERROR THEN
4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4150: END IF;
4151: EXCEPTION
4152: WHEN FND_API.G_EXC_ERROR THEN
4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');

Line 4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4151: EXCEPTION
4152: WHEN FND_API.G_EXC_ERROR THEN
4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4162: END find_duplicate_contacts;
4163:
4164: PROCEDURE find_duplicate_contact_points (
4165: p_rule_id IN NUMBER,

Line 4225: WHEN FND_API.G_EXC_ERROR THEN

4221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4222: 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);
4223: END IF;
4224: EXCEPTION
4225: WHEN FND_API.G_EXC_ERROR THEN
4226: RAISE FND_API.G_EXC_ERROR;
4227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229: WHEN OTHERS THEN

Line 4226: RAISE FND_API.G_EXC_ERROR;

4222: 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);
4223: END IF;
4224: EXCEPTION
4225: WHEN FND_API.G_EXC_ERROR THEN
4226: RAISE FND_API.G_EXC_ERROR;
4227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229: WHEN OTHERS THEN
4230: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4223: END IF;
4224: EXCEPTION
4225: WHEN FND_API.G_EXC_ERROR THEN
4226: RAISE FND_API.G_EXC_ERROR;
4227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229: WHEN OTHERS THEN
4230: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4231: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');

Line 4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4224: EXCEPTION
4225: WHEN FND_API.G_EXC_ERROR THEN
4226: RAISE FND_API.G_EXC_ERROR;
4227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229: WHEN OTHERS THEN
4230: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4231: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4232: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4230: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4231: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4232: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4233: FND_MSG_PUB.ADD;
4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4235: END find_duplicate_contact_points;
4236:
4237: PROCEDURE find_parties_dynamic (
4238: p_rule_id IN NUMBER,

Line 4499: WHEN FND_API.G_EXC_ERROR THEN

4495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4496: 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);
4497: END IF;
4498: EXCEPTION
4499: WHEN FND_API.G_EXC_ERROR THEN
4500: RAISE FND_API.G_EXC_ERROR;
4501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4503: WHEN OTHERS THEN

Line 4500: RAISE FND_API.G_EXC_ERROR;

4496: 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);
4497: END IF;
4498: EXCEPTION
4499: WHEN FND_API.G_EXC_ERROR THEN
4500: RAISE FND_API.G_EXC_ERROR;
4501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4503: WHEN OTHERS THEN
4504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4497: END IF;
4498: EXCEPTION
4499: WHEN FND_API.G_EXC_ERROR THEN
4500: RAISE FND_API.G_EXC_ERROR;
4501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4503: WHEN OTHERS THEN
4504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4505: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');

Line 4502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4498: EXCEPTION
4499: WHEN FND_API.G_EXC_ERROR THEN
4500: RAISE FND_API.G_EXC_ERROR;
4501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4503: WHEN OTHERS THEN
4504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4505: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4506: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4505: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4506: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4507: FND_MSG_PUB.ADD;
4508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4509: END call_api_dynamic;
4510:
4511:
4512: PROCEDURE get_matching_party_sites (

Line 4733: WHEN FND_API.G_EXC_ERROR THEN

4729: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4730: 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);
4731: END IF;
4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN

Line 4734: RAISE FND_API.G_EXC_ERROR;

4730: 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);
4731: END IF;
4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4731: END IF;
4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');

Line 4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4743: END get_matching_party_sites;
4744:
4745:
4746: PROCEDURE get_matching_contacts (

Line 4958: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4959: RAISE FND_API.G_EXC_ERROR;

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

Line 4960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4956: END IF;
4957: EXCEPTION
4958: WHEN FND_API.G_EXC_ERROR THEN
4959: RAISE FND_API.G_EXC_ERROR;
4960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4962: WHEN OTHERS THEN
4963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');

Line 4961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4957: EXCEPTION
4958: WHEN FND_API.G_EXC_ERROR THEN
4959: RAISE FND_API.G_EXC_ERROR;
4960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4962: WHEN OTHERS THEN
4963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4966: FND_MSG_PUB.ADD;
4967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4968: END get_matching_contacts;
4969:
4970:
4971: PROCEDURE get_matching_contact_points (

Line 5097: WHEN FND_API.G_EXC_ERROR THEN

5093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5094: 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);
5095: END IF;
5096: EXCEPTION
5097: WHEN FND_API.G_EXC_ERROR THEN
5098: RAISE FND_API.G_EXC_ERROR;
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5101: WHEN OTHERS THEN

Line 5098: RAISE FND_API.G_EXC_ERROR;

5094: 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);
5095: END IF;
5096: EXCEPTION
5097: WHEN FND_API.G_EXC_ERROR THEN
5098: RAISE FND_API.G_EXC_ERROR;
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5101: WHEN OTHERS THEN
5102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5095: END IF;
5096: EXCEPTION
5097: WHEN FND_API.G_EXC_ERROR THEN
5098: RAISE FND_API.G_EXC_ERROR;
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5101: WHEN OTHERS THEN
5102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5103: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');

Line 5100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5096: EXCEPTION
5097: WHEN FND_API.G_EXC_ERROR THEN
5098: RAISE FND_API.G_EXC_ERROR;
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5101: WHEN OTHERS THEN
5102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5103: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5103: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5105: FND_MSG_PUB.ADD;
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: END get_matching_contact_points;
5108:
5109: /**********************************************************
5110: This procedure finds the score details for a specific party that

Line 5300: WHEN FND_API.G_EXC_ERROR THEN

5296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5297: 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);
5298: END IF;
5299: EXCEPTION
5300: WHEN FND_API.G_EXC_ERROR THEN
5301: RAISE FND_API.G_EXC_ERROR;
5302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5304: WHEN OTHERS THEN

Line 5301: RAISE FND_API.G_EXC_ERROR;

5297: 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);
5298: END IF;
5299: EXCEPTION
5300: WHEN FND_API.G_EXC_ERROR THEN
5301: RAISE FND_API.G_EXC_ERROR;
5302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5304: WHEN OTHERS THEN
5305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5298: END IF;
5299: EXCEPTION
5300: WHEN FND_API.G_EXC_ERROR THEN
5301: RAISE FND_API.G_EXC_ERROR;
5302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5304: WHEN OTHERS THEN
5305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5306: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');

Line 5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5299: EXCEPTION
5300: WHEN FND_API.G_EXC_ERROR THEN
5301: RAISE FND_API.G_EXC_ERROR;
5302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5304: WHEN OTHERS THEN
5305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5306: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5306: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5308: FND_MSG_PUB.ADD;
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: END get_score_details;
5311:
5312:
5313: /************************************************

Line 5378: WHEN FND_API.G_EXC_ERROR THEN

5374: END LOOP;
5375: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5376: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5377: EXCEPTION
5378: WHEN FND_API.G_EXC_ERROR THEN
5379: RAISE FND_API.G_EXC_ERROR;
5380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5382: WHEN OTHERS THEN

Line 5379: RAISE FND_API.G_EXC_ERROR;

5375: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5376: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5377: EXCEPTION
5378: WHEN FND_API.G_EXC_ERROR THEN
5379: RAISE FND_API.G_EXC_ERROR;
5380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5382: WHEN OTHERS THEN
5383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5376: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5377: EXCEPTION
5378: WHEN FND_API.G_EXC_ERROR THEN
5379: RAISE FND_API.G_EXC_ERROR;
5380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5382: WHEN OTHERS THEN
5383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5384: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5377: EXCEPTION
5378: WHEN FND_API.G_EXC_ERROR THEN
5379: RAISE FND_API.G_EXC_ERROR;
5380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5382: WHEN OTHERS THEN
5383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5384: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5384: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5386: FND_MSG_PUB.ADD;
5387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5388: END get_party_for_search;
5389:
5390: PROCEDURE get_search_criteria (
5391: p_party_id IN NUMBER,

Line 5418: WHEN FND_API.G_EXC_ERROR THEN

5414: END IF;
5415: get_party_site_rec(p_party_site_ids, x_party_site_list);
5416: END IF;
5417: EXCEPTION
5418: WHEN FND_API.G_EXC_ERROR THEN
5419: RAISE FND_API.G_EXC_ERROR;
5420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: WHEN OTHERS THEN

Line 5419: RAISE FND_API.G_EXC_ERROR;

5415: get_party_site_rec(p_party_site_ids, x_party_site_list);
5416: END IF;
5417: EXCEPTION
5418: WHEN FND_API.G_EXC_ERROR THEN
5419: RAISE FND_API.G_EXC_ERROR;
5420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: WHEN OTHERS THEN
5423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5416: END IF;
5417: EXCEPTION
5418: WHEN FND_API.G_EXC_ERROR THEN
5419: RAISE FND_API.G_EXC_ERROR;
5420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: WHEN OTHERS THEN
5423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5424: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5417: EXCEPTION
5418: WHEN FND_API.G_EXC_ERROR THEN
5419: RAISE FND_API.G_EXC_ERROR;
5420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: WHEN OTHERS THEN
5423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5424: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5424: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: END get_search_criteria;
5429:
5430:
5431: /************************************************

Line 5492: RAISE FND_API.G_EXC_ERROR;

5488: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5489: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_ERROR;
5493: END get_party_rec;
5494:
5495: /************************************************
5496: This procedure retrieves the match rule party site attributes into

Line 5548: RAISE FND_API.G_EXC_ERROR;

5544: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5545: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5546: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5547: FND_MSG_PUB.ADD;
5548: RAISE FND_API.G_EXC_ERROR;
5549: END get_party_site_rec;
5550:
5551: /************************************************
5552: This procedure retrieves the match rule contact attributes into

Line 5604: RAISE FND_API.G_EXC_ERROR;

5600: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5601: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5603: FND_MSG_PUB.ADD;
5604: RAISE FND_API.G_EXC_ERROR;
5605: END get_contact_rec;
5606:
5607: /************************************************
5608: This procedure retrieves the match rule contact point attributes into

Line 5656: RAISE FND_API.G_EXC_ERROR;

5652: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5653: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END get_contact_point_rec;
5658:
5659: /************************************************
5660: This procedure maps a search record from the logical

Line 5792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5791: FND_MSG_PUB.ADD;
5792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5793: END;
5794:
5795:
5796: /************************************************

Line 5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5903: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5904: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5906: FND_MSG_PUB.ADD;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5908: END;
5909:
5910:
5911: /************************************************

Line 5949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6012: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6013: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6014: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6017: END;
6018:
6019:
6020: /************************************************

Line 6044: WHEN FND_API.G_EXC_ERROR THEN

6040: END IF;
6041: END LOOP;
6042: RETURN FALSE;
6043: EXCEPTION
6044: WHEN FND_API.G_EXC_ERROR THEN
6045: RAISE FND_API.G_EXC_ERROR;
6046: WHEN OTHERS THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6048: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6045: RAISE FND_API.G_EXC_ERROR;

6041: END LOOP;
6042: RETURN FALSE;
6043: EXCEPTION
6044: WHEN FND_API.G_EXC_ERROR THEN
6045: RAISE FND_API.G_EXC_ERROR;
6046: WHEN OTHERS THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6048: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6048: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6050: FND_MSG_PUB.ADD;
6051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6052: END check_prim_cond;
6053:
6054: /************************************************
6055: This procedure checks if the input search condition

Line 6095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6092: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6094: FND_MSG_PUB.ADD;
6095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6096: END check_party_site_cond;
6097:
6098: /************************************************
6099: This procedure checks if the input search condition

Line 6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6129: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6134: END check_contact_cond;
6135:
6136: /************************************************
6137: This procedure checks if the input search condition

Line 6154: RAISE FND_API.G_EXC_ERROR;

6150: FOR I IN 1..p_contact_point_list.COUNT LOOP
6151: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6152: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6153: FND_MSG_PUB.ADD;
6154: RAISE FND_API.G_EXC_ERROR;
6155: END IF;
6156: END LOOP;
6157:
6158: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6167: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6169: FND_MSG_PUB.ADD;
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: END check_contact_point_cond;
6172:
6173: FUNCTION check_staged RETURN BOOLEAN IS
6174: