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 1234: RAISE FND_API.G_EXC_ERROR;

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

Line 1238: RAISE FND_API.G_EXC_ERROR;

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

Line 1242: RAISE FND_API.G_EXC_ERROR;

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

Line 1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1479: RAISE FND_API.G_EXC_ERROR;

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

Line 1483: RAISE FND_API.G_EXC_ERROR;

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

Line 1487: RAISE FND_API.G_EXC_ERROR;

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

Line 1492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1626: RAISE FND_API.G_EXC_ERROR;

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

Line 1630: RAISE FND_API.G_EXC_ERROR;

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

Line 1634: RAISE FND_API.G_EXC_ERROR;

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

Line 1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1899: RAISE FND_API.G_EXC_ERROR;

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

Line 1903: RAISE FND_API.G_EXC_ERROR;

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

Line 1907: RAISE FND_API.G_EXC_ERROR;

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

Line 1912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2161: RAISE FND_API.G_EXC_ERROR;

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

Line 2209: RAISE FND_API.G_EXC_ERROR;

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

Line 2282: RAISE FND_API.G_EXC_ERROR;

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

Line 2394: RAISE FND_API.G_EXC_ERROR;

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

Line 2505: RAISE FND_API.G_EXC_ERROR;

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

Line 2730: RAISE FND_API.G_EXC_ERROR;

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

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

Line 2937: WHEN FND_API.G_EXC_ERROR THEN

2933: END IF;
2934: EXCEPTION
2935: WHEN L_RETURN_IMM_EXC THEN
2936: RETURN;
2937: WHEN FND_API.G_EXC_ERROR THEN
2938: RAISE FND_API.G_EXC_ERROR;
2939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2941: WHEN OTHERS THEN

Line 2938: RAISE FND_API.G_EXC_ERROR;

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

Line 2939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3135: RAISE FND_API.G_EXC_ERROR;

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

Line 3183: RAISE FND_API.G_EXC_ERROR;

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

Line 3219: RAISE FND_API.G_EXC_ERROR;

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

Line 3223: RAISE FND_API.G_EXC_ERROR;

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

Line 3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3295: RAISE FND_API.G_EXC_ERROR;

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

Line 3554: RAISE FND_API.G_EXC_ERROR;

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

Line 3667: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3789: WHEN FND_API.G_EXC_ERROR THEN

3785: END IF;
3786: EXCEPTION
3787: WHEN L_RETURN_IMM_EXC THEN
3788: RETURN;
3789: WHEN FND_API.G_EXC_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN

Line 3790: RAISE FND_API.G_EXC_ERROR;

3786: EXCEPTION
3787: WHEN L_RETURN_IMM_EXC THEN
3788: RETURN;
3789: WHEN FND_API.G_EXC_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3787: WHEN L_RETURN_IMM_EXC THEN
3788: RETURN;
3789: WHEN FND_API.G_EXC_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');

Line 3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3788: RETURN;
3789: WHEN FND_API.G_EXC_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3857: WHEN FND_API.G_EXC_ERROR THEN

3853: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3854: 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);
3855: END IF;
3856: EXCEPTION
3857: WHEN FND_API.G_EXC_ERROR THEN
3858: RAISE FND_API.G_EXC_ERROR;
3859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: WHEN OTHERS THEN

Line 3858: RAISE FND_API.G_EXC_ERROR;

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

Line 3859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3855: END IF;
3856: EXCEPTION
3857: WHEN FND_API.G_EXC_ERROR THEN
3858: RAISE FND_API.G_EXC_ERROR;
3859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: WHEN OTHERS THEN
3862: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3863: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');

Line 3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3856: EXCEPTION
3857: WHEN FND_API.G_EXC_ERROR THEN
3858: RAISE FND_API.G_EXC_ERROR;
3859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: WHEN OTHERS THEN
3862: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3863: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3864: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3974: WHEN FND_API.G_EXC_ERROR THEN

3970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3971: 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);
3972: END IF;
3973: EXCEPTION
3974: WHEN FND_API.G_EXC_ERROR THEN
3975: RAISE FND_API.G_EXC_ERROR;
3976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3978: WHEN OTHERS THEN

Line 3975: RAISE FND_API.G_EXC_ERROR;

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

Line 3976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3972: END IF;
3973: EXCEPTION
3974: WHEN FND_API.G_EXC_ERROR THEN
3975: RAISE FND_API.G_EXC_ERROR;
3976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3978: WHEN OTHERS THEN
3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3980: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');

Line 3977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3973: EXCEPTION
3974: WHEN FND_API.G_EXC_ERROR THEN
3975: RAISE FND_API.G_EXC_ERROR;
3976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3978: WHEN OTHERS THEN
3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3980: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3981: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3980: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3981: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3982: FND_MSG_PUB.ADD;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3984: END find_duplicate_parties;
3985:
3986: PROCEDURE find_duplicate_party_sites (
3987: p_rule_id IN NUMBER,

Line 4059: WHEN FND_API.G_EXC_ERROR THEN

4055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4056: 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);
4057: END IF;
4058: EXCEPTION
4059: WHEN FND_API.G_EXC_ERROR THEN
4060: RAISE FND_API.G_EXC_ERROR;
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4063: WHEN OTHERS THEN

Line 4060: RAISE FND_API.G_EXC_ERROR;

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

Line 4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4057: END IF;
4058: EXCEPTION
4059: WHEN FND_API.G_EXC_ERROR THEN
4060: RAISE FND_API.G_EXC_ERROR;
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4063: WHEN OTHERS THEN
4064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');

Line 4062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4058: EXCEPTION
4059: WHEN FND_API.G_EXC_ERROR THEN
4060: RAISE FND_API.G_EXC_ERROR;
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4063: WHEN OTHERS THEN
4064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');
4066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');
4066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4067: FND_MSG_PUB.ADD;
4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4069: END find_duplicate_party_sites;
4070:
4071: PROCEDURE find_duplicate_contacts (
4072: p_rule_id IN NUMBER,

Line 4148: WHEN FND_API.G_EXC_ERROR THEN

4144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4145: 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);
4146: END IF;
4147: EXCEPTION
4148: WHEN FND_API.G_EXC_ERROR THEN
4149: RAISE FND_API.G_EXC_ERROR;
4150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4152: WHEN OTHERS THEN

Line 4149: RAISE FND_API.G_EXC_ERROR;

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

Line 4150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4146: END IF;
4147: EXCEPTION
4148: WHEN FND_API.G_EXC_ERROR THEN
4149: RAISE FND_API.G_EXC_ERROR;
4150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4152: WHEN OTHERS THEN
4153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4154: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');

Line 4151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4147: EXCEPTION
4148: WHEN FND_API.G_EXC_ERROR THEN
4149: RAISE FND_API.G_EXC_ERROR;
4150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4152: WHEN OTHERS THEN
4153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4154: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4221: WHEN FND_API.G_EXC_ERROR THEN

4217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4218: 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);
4219: END IF;
4220: EXCEPTION
4221: WHEN FND_API.G_EXC_ERROR THEN
4222: RAISE FND_API.G_EXC_ERROR;
4223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: WHEN OTHERS THEN

Line 4222: RAISE FND_API.G_EXC_ERROR;

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

Line 4223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4219: END IF;
4220: EXCEPTION
4221: WHEN FND_API.G_EXC_ERROR THEN
4222: RAISE FND_API.G_EXC_ERROR;
4223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: WHEN OTHERS THEN
4226: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4227: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');

Line 4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4220: EXCEPTION
4221: WHEN FND_API.G_EXC_ERROR THEN
4222: RAISE FND_API.G_EXC_ERROR;
4223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: WHEN OTHERS THEN
4226: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4227: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4228: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4495: WHEN FND_API.G_EXC_ERROR THEN

4491: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4492: 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);
4493: END IF;
4494: EXCEPTION
4495: WHEN FND_API.G_EXC_ERROR THEN
4496: RAISE FND_API.G_EXC_ERROR;
4497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4499: WHEN OTHERS THEN

Line 4496: RAISE FND_API.G_EXC_ERROR;

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

Line 4497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4493: END IF;
4494: EXCEPTION
4495: WHEN FND_API.G_EXC_ERROR THEN
4496: RAISE FND_API.G_EXC_ERROR;
4497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4499: WHEN OTHERS THEN
4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');

Line 4498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4494: EXCEPTION
4495: WHEN FND_API.G_EXC_ERROR THEN
4496: RAISE FND_API.G_EXC_ERROR;
4497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4499: WHEN OTHERS THEN
4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4503: FND_MSG_PUB.ADD;
4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4505: END call_api_dynamic;
4506:
4507:
4508: PROCEDURE get_matching_party_sites (

Line 4729: WHEN FND_API.G_EXC_ERROR THEN

4725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4726: 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);
4727: END IF;
4728: EXCEPTION
4729: WHEN FND_API.G_EXC_ERROR THEN
4730: RAISE FND_API.G_EXC_ERROR;
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4733: WHEN OTHERS THEN

Line 4730: RAISE FND_API.G_EXC_ERROR;

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

Line 4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4735: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4737: FND_MSG_PUB.ADD;
4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4739: END get_matching_party_sites;
4740:
4741:
4742: PROCEDURE get_matching_contacts (

Line 4954: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4955: RAISE FND_API.G_EXC_ERROR;

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

Line 4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5093: WHEN FND_API.G_EXC_ERROR THEN

5089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5090: 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);
5091: END IF;
5092: EXCEPTION
5093: WHEN FND_API.G_EXC_ERROR THEN
5094: RAISE FND_API.G_EXC_ERROR;
5095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5097: WHEN OTHERS THEN

Line 5094: RAISE FND_API.G_EXC_ERROR;

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

Line 5095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5091: END IF;
5092: EXCEPTION
5093: WHEN FND_API.G_EXC_ERROR THEN
5094: RAISE FND_API.G_EXC_ERROR;
5095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5097: WHEN OTHERS THEN
5098: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5099: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');

Line 5096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5092: EXCEPTION
5093: WHEN FND_API.G_EXC_ERROR THEN
5094: RAISE FND_API.G_EXC_ERROR;
5095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5097: WHEN OTHERS THEN
5098: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5099: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5295: WHEN FND_API.G_EXC_ERROR THEN

5291: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5292: 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);
5293: END IF;
5294: EXCEPTION
5295: WHEN FND_API.G_EXC_ERROR THEN
5296: RAISE FND_API.G_EXC_ERROR;
5297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5299: WHEN OTHERS THEN

Line 5296: RAISE FND_API.G_EXC_ERROR;

5292: 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);
5293: END IF;
5294: EXCEPTION
5295: WHEN FND_API.G_EXC_ERROR THEN
5296: RAISE FND_API.G_EXC_ERROR;
5297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5299: WHEN OTHERS THEN
5300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5293: END IF;
5294: EXCEPTION
5295: WHEN FND_API.G_EXC_ERROR THEN
5296: RAISE FND_API.G_EXC_ERROR;
5297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5299: WHEN OTHERS THEN
5300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5301: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');

Line 5298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5294: EXCEPTION
5295: WHEN FND_API.G_EXC_ERROR THEN
5296: RAISE FND_API.G_EXC_ERROR;
5297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5299: WHEN OTHERS THEN
5300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5301: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5301: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5303: FND_MSG_PUB.ADD;
5304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5305: END get_score_details;
5306:
5307:
5308: /************************************************

Line 5373: WHEN FND_API.G_EXC_ERROR THEN

5369: END LOOP;
5370: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5371: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5372: EXCEPTION
5373: WHEN FND_API.G_EXC_ERROR THEN
5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN

Line 5374: RAISE FND_API.G_EXC_ERROR;

5370: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5371: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5372: EXCEPTION
5373: WHEN FND_API.G_EXC_ERROR THEN
5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5371: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5372: EXCEPTION
5373: WHEN FND_API.G_EXC_ERROR THEN
5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5372: EXCEPTION
5373: WHEN FND_API.G_EXC_ERROR THEN
5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END get_party_for_search;
5384:
5385: PROCEDURE get_search_criteria (
5386: p_party_id IN NUMBER,

Line 5413: WHEN FND_API.G_EXC_ERROR THEN

5409: END IF;
5410: get_party_site_rec(p_party_site_ids, x_party_site_list);
5411: END IF;
5412: EXCEPTION
5413: WHEN FND_API.G_EXC_ERROR THEN
5414: RAISE FND_API.G_EXC_ERROR;
5415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417: WHEN OTHERS THEN

Line 5414: RAISE FND_API.G_EXC_ERROR;

5410: get_party_site_rec(p_party_site_ids, x_party_site_list);
5411: END IF;
5412: EXCEPTION
5413: WHEN FND_API.G_EXC_ERROR THEN
5414: RAISE FND_API.G_EXC_ERROR;
5415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417: WHEN OTHERS THEN
5418: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5411: END IF;
5412: EXCEPTION
5413: WHEN FND_API.G_EXC_ERROR THEN
5414: RAISE FND_API.G_EXC_ERROR;
5415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417: WHEN OTHERS THEN
5418: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5419: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5412: EXCEPTION
5413: WHEN FND_API.G_EXC_ERROR THEN
5414: RAISE FND_API.G_EXC_ERROR;
5415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417: WHEN OTHERS THEN
5418: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5419: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5418: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5419: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5421: FND_MSG_PUB.ADD;
5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: END get_search_criteria;
5424:
5425:
5426: /************************************************

Line 5487: RAISE FND_API.G_EXC_ERROR;

5483: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5484: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;
5487: RAISE FND_API.G_EXC_ERROR;
5488: END get_party_rec;
5489:
5490: /************************************************
5491: This procedure retrieves the match rule party site attributes into

Line 5543: RAISE FND_API.G_EXC_ERROR;

5539: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5540: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5542: FND_MSG_PUB.ADD;
5543: RAISE FND_API.G_EXC_ERROR;
5544: END get_party_site_rec;
5545:
5546: /************************************************
5547: This procedure retrieves the match rule contact attributes into

Line 5599: RAISE FND_API.G_EXC_ERROR;

5595: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5596: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5598: FND_MSG_PUB.ADD;
5599: RAISE FND_API.G_EXC_ERROR;
5600: END get_contact_rec;
5601:
5602: /************************************************
5603: This procedure retrieves the match rule contact point attributes into

Line 5651: RAISE FND_API.G_EXC_ERROR;

5647: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5648: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_ERROR;
5652: END get_contact_point_rec;
5653:
5654: /************************************************
5655: This procedure maps a search record from the logical

Line 5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5783: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5784: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5785: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5786: FND_MSG_PUB.ADD;
5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5788: END;
5789:
5790:
5791: /************************************************

Line 5902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5898: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5899: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5901: FND_MSG_PUB.ADD;
5902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5903: END;
5904:
5905:
5906: /************************************************

Line 5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5940: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5941: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5943: FND_MSG_PUB.ADD;
5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5945: END;
5946:
5947:
5948: /************************************************

Line 6011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6007: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6008: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6009: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6010: FND_MSG_PUB.ADD;
6011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6012: END;
6013:
6014:
6015: /************************************************

Line 6039: WHEN FND_API.G_EXC_ERROR THEN

6035: END IF;
6036: END LOOP;
6037: RETURN FALSE;
6038: EXCEPTION
6039: WHEN FND_API.G_EXC_ERROR THEN
6040: RAISE FND_API.G_EXC_ERROR;
6041: WHEN OTHERS THEN
6042: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6043: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6040: RAISE FND_API.G_EXC_ERROR;

6036: END LOOP;
6037: RETURN FALSE;
6038: EXCEPTION
6039: WHEN FND_API.G_EXC_ERROR THEN
6040: RAISE FND_API.G_EXC_ERROR;
6041: WHEN OTHERS THEN
6042: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6043: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6042: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6043: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6047: END check_prim_cond;
6048:
6049: /************************************************
6050: This procedure checks if the input search condition

Line 6090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6087: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6089: FND_MSG_PUB.ADD;
6090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6091: END check_party_site_cond;
6092:
6093: /************************************************
6094: This procedure checks if the input search condition

Line 6128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6125: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6127: FND_MSG_PUB.ADD;
6128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6129: END check_contact_cond;
6130:
6131: /************************************************
6132: This procedure checks if the input search condition

Line 6149: RAISE FND_API.G_EXC_ERROR;

6145: FOR I IN 1..p_contact_point_list.COUNT LOOP
6146: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6147: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;
6151: END LOOP;
6152:
6153: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6162: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6164: FND_MSG_PUB.ADD;
6165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6166: END check_contact_point_cond;
6167:
6168: FUNCTION check_staged RETURN BOOLEAN IS
6169: