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_2 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 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

529: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
530: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END;
535:
536:
537: /************************************************

Line 553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

549: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
550: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END;
555:
556:
557: /************************************************

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END;
595:
596: PROCEDURE init_score_context (
597: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 660: RAISE FND_API.G_EXC_ERROR;

656: p_contact_list,
657: p_contact_point_list) THEN
658: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
659: FND_MSG_PUB.ADD;
660: RAISE FND_API.G_EXC_ERROR;
661: END IF;
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: 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);
664: END IF;

Line 918: RAISE FND_API.G_EXC_ERROR;

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

973: IF lengthb(l_contains_str) > 4000 THEN
974: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
975: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
976: FND_MSG_PUB.ADD;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: x_denorm_str := l_den_contains_str;
980: RETURN l_contains_str;
981: END;

Line 1244: RAISE FND_API.G_EXC_ERROR;

1240: when others then
1241: if (instrb(SQLERRM,'DRG-51030')>0) then
1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1247: FND_MSG_PUB.ADD;
1248: RAISE FND_API.G_EXC_ERROR;

Line 1248: RAISE FND_API.G_EXC_ERROR;

1244: RAISE FND_API.G_EXC_ERROR;
1245: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1247: FND_MSG_PUB.ADD;
1248: RAISE FND_API.G_EXC_ERROR;
1249: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;

Line 1252: RAISE FND_API.G_EXC_ERROR;

1248: RAISE FND_API.G_EXC_ERROR;
1249: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: else
1254: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1256: FND_MSG_PUB.ADD;

Line 1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1253: else
1254: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1256: FND_MSG_PUB.ADD;
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: end if;
1259: END;
1260:
1261: PROCEDURE open_party_site_cursor(

Line 1489: RAISE FND_API.G_EXC_ERROR;

1485: when others then
1486: if (instrb(SQLERRM,'DRG-51030')>0) then
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;

Line 1493: RAISE FND_API.G_EXC_ERROR;

1489: RAISE FND_API.G_EXC_ERROR;
1490: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1496: FND_MSG_PUB.ADD;
1497: RAISE FND_API.G_EXC_ERROR;

Line 1497: RAISE FND_API.G_EXC_ERROR;

1493: RAISE FND_API.G_EXC_ERROR;
1494: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1496: FND_MSG_PUB.ADD;
1497: RAISE FND_API.G_EXC_ERROR;
1498: else
1499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1501: FND_MSG_PUB.ADD;

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: else
1499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: end if;
1504: END;
1505:
1506: PROCEDURE open_contact_cursor(

Line 1636: RAISE FND_API.G_EXC_ERROR;

1632: when others then
1633: if (instrb(SQLERRM,'DRG-51030')>0) then
1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;

Line 1640: RAISE FND_API.G_EXC_ERROR;

1636: RAISE FND_API.G_EXC_ERROR;
1637: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;

Line 1644: RAISE FND_API.G_EXC_ERROR;

1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: else
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1648: FND_MSG_PUB.ADD;

Line 1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1645: else
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650: end if;
1651: END;
1652:
1653: PROCEDURE open_contact_pt_cursor(

Line 1909: RAISE FND_API.G_EXC_ERROR;

1905: when others then
1906: if (instrb(SQLERRM,'DRG-51030')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;

Line 1913: RAISE FND_API.G_EXC_ERROR;

1909: RAISE FND_API.G_EXC_ERROR;
1910: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;

Line 1917: RAISE FND_API.G_EXC_ERROR;

1913: RAISE FND_API.G_EXC_ERROR;
1914: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: else
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1921: FND_MSG_PUB.ADD;

Line 1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1918: else
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1921: FND_MSG_PUB.ADD;
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: end if;
1924: END;
1925:
1926:

Line 2170: RAISE FND_API.G_EXC_ERROR;

2166: 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);
2167: END IF;
2168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2169: FND_MSG_PUB.ADD;
2170: RAISE FND_API.G_EXC_ERROR;
2171: ELSE
2172: push_eval;
2173: RETURN;
2174: END IF;

Line 2218: RAISE FND_API.G_EXC_ERROR;

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

Line 2291: RAISE FND_API.G_EXC_ERROR;

2287: 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);
2288: END IF;
2289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2290: FND_MSG_PUB.ADD;
2291: RAISE FND_API.G_EXC_ERROR;
2292: ELSE
2293: push_eval;
2294: RETURN;
2295: END IF;

Line 2403: RAISE FND_API.G_EXC_ERROR;

2399: 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);
2400: END IF;
2401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2402: FND_MSG_PUB.ADD;
2403: RAISE FND_API.G_EXC_ERROR;
2404: ELSE
2405: push_eval;
2406: RETURN;
2407: END IF;

Line 2514: RAISE FND_API.G_EXC_ERROR;

2510: 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);
2511: END IF;
2512: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2513: FND_MSG_PUB.ADD;
2514: RAISE FND_API.G_EXC_ERROR;
2515: ELSE
2516: push_eval;
2517: RETURN;
2518: END IF;

Line 2658: RAISE FND_API.G_EXC_ERROR;

2654: 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);
2655: END IF;
2656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2657: FND_MSG_PUB.ADD;
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;
2660: ELSE
2661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2662: 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 2666: RAISE FND_API.G_EXC_ERROR;

2662: 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);
2663: END IF;
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668: END IF;
2669: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2670: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2908: WHEN FND_API.G_EXC_ERROR THEN

2904: END IF;
2905: EXCEPTION
2906: WHEN L_RETURN_IMM_EXC THEN
2907: RETURN;
2908: WHEN FND_API.G_EXC_ERROR THEN
2909: RAISE FND_API.G_EXC_ERROR;
2910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: WHEN OTHERS THEN

Line 2909: RAISE FND_API.G_EXC_ERROR;

2905: EXCEPTION
2906: WHEN L_RETURN_IMM_EXC THEN
2907: RETURN;
2908: WHEN FND_API.G_EXC_ERROR THEN
2909: RAISE FND_API.G_EXC_ERROR;
2910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2906: WHEN L_RETURN_IMM_EXC THEN
2907: RETURN;
2908: WHEN FND_API.G_EXC_ERROR THEN
2909: RAISE FND_API.G_EXC_ERROR;
2910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');

Line 2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2907: RETURN;
2908: WHEN FND_API.G_EXC_ERROR THEN
2909: RAISE FND_API.G_EXC_ERROR;
2910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END find_parties;
2919:
2920: PROCEDURE find_persons (
2921: p_rule_id IN NUMBER,

Line 3105: RAISE FND_API.G_EXC_ERROR;

3101: 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);
3102: END IF;
3103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3104: FND_MSG_PUB.ADD;
3105: RAISE FND_API.G_EXC_ERROR;
3106: ELSE
3107: push_eval;
3108: RETURN;
3109: END IF;

Line 3153: RAISE FND_API.G_EXC_ERROR;

3149: 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);
3150: END IF;
3151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: ELSE
3155: push_eval;
3156: RETURN;
3157: END IF;

Line 3189: RAISE FND_API.G_EXC_ERROR;

3185: when others then
3186: if (instrb(SQLERRM,'DRG-51030')>0) then
3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3192: FND_MSG_PUB.ADD;
3193: RAISE FND_API.G_EXC_ERROR;

Line 3193: RAISE FND_API.G_EXC_ERROR;

3189: RAISE FND_API.G_EXC_ERROR;
3190: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3192: FND_MSG_PUB.ADD;
3193: RAISE FND_API.G_EXC_ERROR;
3194: else
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: end if;
3197: END;

Line 3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3192: FND_MSG_PUB.ADD;
3193: RAISE FND_API.G_EXC_ERROR;
3194: else
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: end if;
3197: END;
3198:
3199: /** Private procedure to acquire and score at party site level ***/

Line 3265: RAISE FND_API.G_EXC_ERROR;

3261: 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);
3262: END IF;
3263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3264: FND_MSG_PUB.ADD;
3265: RAISE FND_API.G_EXC_ERROR;
3266: ELSE
3267: push_eval;
3268: RETURN;
3269: END IF;

Line 3454: RAISE FND_API.G_EXC_ERROR;

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

Line 3542: RAISE FND_API.G_EXC_ERROR;

3538: 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);
3539: END IF;
3540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3541: FND_MSG_PUB.ADD;
3542: RAISE FND_API.G_EXC_ERROR;
3543: END IF;
3544: ELSE
3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3546: 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 3550: RAISE FND_API.G_EXC_ERROR;

3546: 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);
3547: END IF;
3548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3549: FND_MSG_PUB.ADD;
3550: RAISE FND_API.G_EXC_ERROR;
3551: END IF;
3552: END IF;
3553: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3554: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3690: WHEN FND_API.G_EXC_ERROR THEN

3686: END IF;
3687: EXCEPTION
3688: WHEN L_RETURN_IMM_EXC THEN
3689: RETURN;
3690: WHEN FND_API.G_EXC_ERROR THEN
3691: RAISE FND_API.G_EXC_ERROR;
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694: WHEN OTHERS THEN

Line 3691: RAISE FND_API.G_EXC_ERROR;

3687: EXCEPTION
3688: WHEN L_RETURN_IMM_EXC THEN
3689: RETURN;
3690: WHEN FND_API.G_EXC_ERROR THEN
3691: RAISE FND_API.G_EXC_ERROR;
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694: WHEN OTHERS THEN
3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3688: WHEN L_RETURN_IMM_EXC THEN
3689: RETURN;
3690: WHEN FND_API.G_EXC_ERROR THEN
3691: RAISE FND_API.G_EXC_ERROR;
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694: WHEN OTHERS THEN
3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');

Line 3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3689: RETURN;
3690: WHEN FND_API.G_EXC_ERROR THEN
3691: RAISE FND_API.G_EXC_ERROR;
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694: WHEN OTHERS THEN
3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3697: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3697: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3700: END find_persons;
3701:
3702: PROCEDURE find_persons (
3703: p_rule_id IN NUMBER,

Line 3758: WHEN FND_API.G_EXC_ERROR THEN

3754: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3755: 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);
3756: END IF;
3757: EXCEPTION
3758: WHEN FND_API.G_EXC_ERROR THEN
3759: RAISE FND_API.G_EXC_ERROR;
3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3762: WHEN OTHERS THEN

Line 3759: RAISE FND_API.G_EXC_ERROR;

3755: 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);
3756: END IF;
3757: EXCEPTION
3758: WHEN FND_API.G_EXC_ERROR THEN
3759: RAISE FND_API.G_EXC_ERROR;
3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3762: WHEN OTHERS THEN
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3756: END IF;
3757: EXCEPTION
3758: WHEN FND_API.G_EXC_ERROR THEN
3759: RAISE FND_API.G_EXC_ERROR;
3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3762: WHEN OTHERS THEN
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');

Line 3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3757: EXCEPTION
3758: WHEN FND_API.G_EXC_ERROR THEN
3759: RAISE FND_API.G_EXC_ERROR;
3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3762: WHEN OTHERS THEN
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3766: FND_MSG_PUB.ADD;
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: END find_party_details;
3769:
3770: PROCEDURE find_duplicate_parties (
3771: p_rule_id IN NUMBER,

Line 3875: WHEN FND_API.G_EXC_ERROR THEN

3871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3872: 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);
3873: END IF;
3874: EXCEPTION
3875: WHEN FND_API.G_EXC_ERROR THEN
3876: RAISE FND_API.G_EXC_ERROR;
3877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3879: WHEN OTHERS THEN

Line 3876: RAISE FND_API.G_EXC_ERROR;

3872: 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);
3873: END IF;
3874: EXCEPTION
3875: WHEN FND_API.G_EXC_ERROR THEN
3876: RAISE FND_API.G_EXC_ERROR;
3877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3879: WHEN OTHERS THEN
3880: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3873: END IF;
3874: EXCEPTION
3875: WHEN FND_API.G_EXC_ERROR THEN
3876: RAISE FND_API.G_EXC_ERROR;
3877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3879: WHEN OTHERS THEN
3880: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3881: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');

Line 3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3874: EXCEPTION
3875: WHEN FND_API.G_EXC_ERROR THEN
3876: RAISE FND_API.G_EXC_ERROR;
3877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3879: WHEN OTHERS THEN
3880: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3881: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3880: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3881: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3883: FND_MSG_PUB.ADD;
3884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3885: END find_duplicate_parties;
3886:
3887: PROCEDURE find_duplicate_party_sites (
3888: p_rule_id IN NUMBER,

Line 3960: WHEN FND_API.G_EXC_ERROR THEN

3956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3957: 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);
3958: END IF;
3959: EXCEPTION
3960: WHEN FND_API.G_EXC_ERROR THEN
3961: RAISE FND_API.G_EXC_ERROR;
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: WHEN OTHERS THEN

Line 3961: RAISE FND_API.G_EXC_ERROR;

3957: 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);
3958: END IF;
3959: EXCEPTION
3960: WHEN FND_API.G_EXC_ERROR THEN
3961: RAISE FND_API.G_EXC_ERROR;
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: WHEN OTHERS THEN
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3958: END IF;
3959: EXCEPTION
3960: WHEN FND_API.G_EXC_ERROR THEN
3961: RAISE FND_API.G_EXC_ERROR;
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: WHEN OTHERS THEN
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3966: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');

Line 3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3959: EXCEPTION
3960: WHEN FND_API.G_EXC_ERROR THEN
3961: RAISE FND_API.G_EXC_ERROR;
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: WHEN OTHERS THEN
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3966: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3967: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3966: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3967: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3968: FND_MSG_PUB.ADD;
3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3970: END find_duplicate_party_sites;
3971:
3972: PROCEDURE find_duplicate_contacts (
3973: p_rule_id IN NUMBER,

Line 4049: WHEN FND_API.G_EXC_ERROR THEN

4045: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4046: 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);
4047: END IF;
4048: EXCEPTION
4049: WHEN FND_API.G_EXC_ERROR THEN
4050: RAISE FND_API.G_EXC_ERROR;
4051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4053: WHEN OTHERS THEN

Line 4050: RAISE FND_API.G_EXC_ERROR;

4046: 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);
4047: END IF;
4048: EXCEPTION
4049: WHEN FND_API.G_EXC_ERROR THEN
4050: RAISE FND_API.G_EXC_ERROR;
4051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4053: WHEN OTHERS THEN
4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4047: END IF;
4048: EXCEPTION
4049: WHEN FND_API.G_EXC_ERROR THEN
4050: RAISE FND_API.G_EXC_ERROR;
4051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4053: WHEN OTHERS THEN
4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');

Line 4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4048: EXCEPTION
4049: WHEN FND_API.G_EXC_ERROR THEN
4050: RAISE FND_API.G_EXC_ERROR;
4051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4053: WHEN OTHERS THEN
4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4057: FND_MSG_PUB.ADD;
4058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4059: END find_duplicate_contacts;
4060:
4061: PROCEDURE find_duplicate_contact_points (
4062: p_rule_id IN NUMBER,

Line 4122: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4123: RAISE FND_API.G_EXC_ERROR;

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

Line 4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4120: END IF;
4121: EXCEPTION
4122: WHEN FND_API.G_EXC_ERROR THEN
4123: RAISE FND_API.G_EXC_ERROR;
4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126: WHEN OTHERS THEN
4127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');

Line 4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4121: EXCEPTION
4122: WHEN FND_API.G_EXC_ERROR THEN
4123: RAISE FND_API.G_EXC_ERROR;
4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126: WHEN OTHERS THEN
4127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');
4129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');
4129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4130: FND_MSG_PUB.ADD;
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4132: END find_duplicate_contact_points;
4133:
4134: PROCEDURE find_parties_dynamic (
4135: p_rule_id IN NUMBER,

Line 4389: WHEN FND_API.G_EXC_ERROR THEN

4385: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4386: 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);
4387: END IF;
4388: EXCEPTION
4389: WHEN FND_API.G_EXC_ERROR THEN
4390: RAISE FND_API.G_EXC_ERROR;
4391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4393: WHEN OTHERS THEN

Line 4390: RAISE FND_API.G_EXC_ERROR;

4386: 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);
4387: END IF;
4388: EXCEPTION
4389: WHEN FND_API.G_EXC_ERROR THEN
4390: RAISE FND_API.G_EXC_ERROR;
4391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4393: WHEN OTHERS THEN
4394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4387: END IF;
4388: EXCEPTION
4389: WHEN FND_API.G_EXC_ERROR THEN
4390: RAISE FND_API.G_EXC_ERROR;
4391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4393: WHEN OTHERS THEN
4394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4395: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');

Line 4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4388: EXCEPTION
4389: WHEN FND_API.G_EXC_ERROR THEN
4390: RAISE FND_API.G_EXC_ERROR;
4391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4393: WHEN OTHERS THEN
4394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4395: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4395: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4397: FND_MSG_PUB.ADD;
4398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4399: END call_api_dynamic;
4400:
4401:
4402: PROCEDURE get_matching_party_sites (

Line 4622: WHEN FND_API.G_EXC_ERROR THEN

4618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4619: 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);
4620: END IF;
4621: EXCEPTION
4622: WHEN FND_API.G_EXC_ERROR THEN
4623: RAISE FND_API.G_EXC_ERROR;
4624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: WHEN OTHERS THEN

Line 4623: RAISE FND_API.G_EXC_ERROR;

4619: 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);
4620: END IF;
4621: EXCEPTION
4622: WHEN FND_API.G_EXC_ERROR THEN
4623: RAISE FND_API.G_EXC_ERROR;
4624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: WHEN OTHERS THEN
4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4620: END IF;
4621: EXCEPTION
4622: WHEN FND_API.G_EXC_ERROR THEN
4623: RAISE FND_API.G_EXC_ERROR;
4624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: WHEN OTHERS THEN
4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');

Line 4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4621: EXCEPTION
4622: WHEN FND_API.G_EXC_ERROR THEN
4623: RAISE FND_API.G_EXC_ERROR;
4624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: WHEN OTHERS THEN
4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4630: FND_MSG_PUB.ADD;
4631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4632: END get_matching_party_sites;
4633:
4634:
4635: PROCEDURE get_matching_contacts (

Line 4847: WHEN FND_API.G_EXC_ERROR THEN

4843: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4844: 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);
4845: END IF;
4846: EXCEPTION
4847: WHEN FND_API.G_EXC_ERROR THEN
4848: RAISE FND_API.G_EXC_ERROR;
4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: WHEN OTHERS THEN

Line 4848: RAISE FND_API.G_EXC_ERROR;

4844: 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);
4845: END IF;
4846: EXCEPTION
4847: WHEN FND_API.G_EXC_ERROR THEN
4848: RAISE FND_API.G_EXC_ERROR;
4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: WHEN OTHERS THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4845: END IF;
4846: EXCEPTION
4847: WHEN FND_API.G_EXC_ERROR THEN
4848: RAISE FND_API.G_EXC_ERROR;
4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: WHEN OTHERS THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');

Line 4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4846: EXCEPTION
4847: WHEN FND_API.G_EXC_ERROR THEN
4848: RAISE FND_API.G_EXC_ERROR;
4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: WHEN OTHERS THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4855: FND_MSG_PUB.ADD;
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: END get_matching_contacts;
4858:
4859:
4860: PROCEDURE get_matching_contact_points (

Line 4986: WHEN FND_API.G_EXC_ERROR THEN

4982: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4983: 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);
4984: END IF;
4985: EXCEPTION
4986: WHEN FND_API.G_EXC_ERROR THEN
4987: RAISE FND_API.G_EXC_ERROR;
4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: WHEN OTHERS THEN

Line 4987: RAISE FND_API.G_EXC_ERROR;

4983: 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);
4984: END IF;
4985: EXCEPTION
4986: WHEN FND_API.G_EXC_ERROR THEN
4987: RAISE FND_API.G_EXC_ERROR;
4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: WHEN OTHERS THEN
4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4984: END IF;
4985: EXCEPTION
4986: WHEN FND_API.G_EXC_ERROR THEN
4987: RAISE FND_API.G_EXC_ERROR;
4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: WHEN OTHERS THEN
4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');

Line 4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4985: EXCEPTION
4986: WHEN FND_API.G_EXC_ERROR THEN
4987: RAISE FND_API.G_EXC_ERROR;
4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: WHEN OTHERS THEN
4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4994: FND_MSG_PUB.ADD;
4995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4996: END get_matching_contact_points;
4997:
4998: /**********************************************************
4999: This procedure finds the score details for a specific party that

Line 5184: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5185: RAISE FND_API.G_EXC_ERROR;

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

Line 5186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5182: END IF;
5183: EXCEPTION
5184: WHEN FND_API.G_EXC_ERROR THEN
5185: RAISE FND_API.G_EXC_ERROR;
5186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5188: WHEN OTHERS THEN
5189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');

Line 5187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5183: EXCEPTION
5184: WHEN FND_API.G_EXC_ERROR THEN
5185: RAISE FND_API.G_EXC_ERROR;
5186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5188: WHEN OTHERS THEN
5189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5192: FND_MSG_PUB.ADD;
5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5194: END get_score_details;
5195:
5196:
5197: /************************************************

Line 5262: WHEN FND_API.G_EXC_ERROR THEN

5258: END LOOP;
5259: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5260: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5261: EXCEPTION
5262: WHEN FND_API.G_EXC_ERROR THEN
5263: RAISE FND_API.G_EXC_ERROR;
5264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: WHEN OTHERS THEN

Line 5263: RAISE FND_API.G_EXC_ERROR;

5259: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5260: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5261: EXCEPTION
5262: WHEN FND_API.G_EXC_ERROR THEN
5263: RAISE FND_API.G_EXC_ERROR;
5264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: WHEN OTHERS THEN
5267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5260: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5261: EXCEPTION
5262: WHEN FND_API.G_EXC_ERROR THEN
5263: RAISE FND_API.G_EXC_ERROR;
5264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: WHEN OTHERS THEN
5267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5268: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5261: EXCEPTION
5262: WHEN FND_API.G_EXC_ERROR THEN
5263: RAISE FND_API.G_EXC_ERROR;
5264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: WHEN OTHERS THEN
5267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5268: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5268: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5272: END get_party_for_search;
5273:
5274: PROCEDURE get_search_criteria (
5275: p_party_id IN NUMBER,

Line 5302: WHEN FND_API.G_EXC_ERROR THEN

5298: END IF;
5299: get_party_site_rec(p_party_site_ids, x_party_site_list);
5300: END IF;
5301: EXCEPTION
5302: WHEN FND_API.G_EXC_ERROR THEN
5303: RAISE FND_API.G_EXC_ERROR;
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN

Line 5303: RAISE FND_API.G_EXC_ERROR;

5299: get_party_site_rec(p_party_site_ids, x_party_site_list);
5300: END IF;
5301: EXCEPTION
5302: WHEN FND_API.G_EXC_ERROR THEN
5303: RAISE FND_API.G_EXC_ERROR;
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5376: RAISE FND_API.G_EXC_ERROR;

5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;
5377: END get_party_rec;
5378:
5379: /************************************************
5380: This procedure retrieves the match rule party site attributes into

Line 5430: RAISE FND_API.G_EXC_ERROR;

5426: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5427: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5429: FND_MSG_PUB.ADD;
5430: RAISE FND_API.G_EXC_ERROR;
5431: END get_party_site_rec;
5432:
5433: /************************************************
5434: This procedure retrieves the match rule contact attributes into

Line 5486: RAISE FND_API.G_EXC_ERROR;

5482: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5483: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5485: FND_MSG_PUB.ADD;
5486: RAISE FND_API.G_EXC_ERROR;
5487: END get_contact_rec;
5488:
5489: /************************************************
5490: This procedure retrieves the match rule contact point attributes into

Line 5538: RAISE FND_API.G_EXC_ERROR;

5534: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5535: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5536: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5537: FND_MSG_PUB.ADD;
5538: RAISE FND_API.G_EXC_ERROR;
5539: END get_contact_point_rec;
5540:
5541: /************************************************
5542: This procedure maps a search record from the logical

Line 5658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END;
5729:
5730:
5731: /************************************************

Line 5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5765: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5766: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5768: FND_MSG_PUB.ADD;
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: END;
5771:
5772:
5773: /************************************************

Line 5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5809: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5811: FND_MSG_PUB.ADD;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5813: END;
5814:
5815:
5816: /************************************************

Line 5846: WHEN FND_API.G_EXC_ERROR THEN

5842: END IF;
5843: END LOOP;
5844: RETURN FALSE;
5845: EXCEPTION
5846: WHEN FND_API.G_EXC_ERROR THEN
5847: RAISE FND_API.G_EXC_ERROR;
5848: WHEN OTHERS THEN
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5850: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5847: RAISE FND_API.G_EXC_ERROR;

5843: END LOOP;
5844: RETURN FALSE;
5845: EXCEPTION
5846: WHEN FND_API.G_EXC_ERROR THEN
5847: RAISE FND_API.G_EXC_ERROR;
5848: WHEN OTHERS THEN
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5850: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5850: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5852: FND_MSG_PUB.ADD;
5853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5854: END check_prim_cond;
5855:
5856: /************************************************
5857: This procedure checks if the input search condition

Line 5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5894: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5898: END check_party_site_cond;
5899:
5900: /************************************************
5901: This procedure checks if the input search condition

Line 5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: END check_contact_cond;
5937:
5938: /************************************************
5939: This procedure checks if the input search condition

Line 5956: RAISE FND_API.G_EXC_ERROR;

5952: FOR I IN 1..p_contact_point_list.COUNT LOOP
5953: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5954: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5955: FND_MSG_PUB.ADD;
5956: RAISE FND_API.G_EXC_ERROR;
5957: END IF;
5958: END LOOP;
5959:
5960: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5969: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5973: END check_contact_point_cond;
5974:
5975: FUNCTION check_staged RETURN BOOLEAN IS
5976: