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_4 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 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_PARTY_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:
597: /************************************************

Line 613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

609: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
610: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END;
615:
616:
617: /************************************************

Line 633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

629: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
630: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
632: FND_MSG_PUB.ADD;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END;
635:
636:
637: /************************************************

Line 653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
650: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
652: FND_MSG_PUB.ADD;
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END;
655:
656: PROCEDURE init_score_context (
657: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 720: RAISE FND_API.G_EXC_ERROR;

716: p_contact_list,
717: p_contact_point_list) THEN
718: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
719: FND_MSG_PUB.ADD;
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
723: 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);
724: END IF;

Line 938: RAISE FND_API.G_EXC_ERROR;

934: IF lengthb(l_party_contains_str) > 4000 THEN
935: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
936: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
937: FND_MSG_PUB.ADD;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940: IF (p_match_str = ' AND ' OR p_party_max_score 941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
942: 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 1000: RAISE FND_API.G_EXC_ERROR;

996: IF lengthb(l_contains_str) > 4000 THEN
997: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
998: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
999: FND_MSG_PUB.ADD;
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002: x_denorm_str := l_den_contains_str;
1003: RETURN l_contains_str;
1004: END;

Line 1251: RAISE FND_API.G_EXC_ERROR;

1247: when others then
1248: if (instrb(SQLERRM,'DRG-51030')>0) then
1249: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1250: FND_MSG_PUB.ADD;
1251: RAISE FND_API.G_EXC_ERROR;
1252: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_ERROR;

Line 1255: RAISE FND_API.G_EXC_ERROR;

1251: RAISE FND_API.G_EXC_ERROR;
1252: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_ERROR;
1256: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;

Line 1259: RAISE FND_API.G_EXC_ERROR;

1255: RAISE FND_API.G_EXC_ERROR;
1256: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: else
1261: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1262: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1263: FND_MSG_PUB.ADD;

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260: else
1261: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1262: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1263: FND_MSG_PUB.ADD;
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: end if;
1266: END;
1267:
1268: PROCEDURE open_party_site_cursor(

Line 1496: RAISE FND_API.G_EXC_ERROR;

1492: when others then
1493: if (instrb(SQLERRM,'DRG-51030')>0) then
1494: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1495: FND_MSG_PUB.ADD;
1496: RAISE FND_API.G_EXC_ERROR;
1497: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1498: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1499: FND_MSG_PUB.ADD;
1500: RAISE FND_API.G_EXC_ERROR;

Line 1500: RAISE FND_API.G_EXC_ERROR;

1496: RAISE FND_API.G_EXC_ERROR;
1497: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1498: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1499: FND_MSG_PUB.ADD;
1500: RAISE FND_API.G_EXC_ERROR;
1501: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_ERROR;

Line 1504: RAISE FND_API.G_EXC_ERROR;

1500: RAISE FND_API.G_EXC_ERROR;
1501: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_ERROR;
1505: else
1506: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1508: FND_MSG_PUB.ADD;

Line 1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1505: else
1506: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1508: FND_MSG_PUB.ADD;
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: end if;
1511: END;
1512:
1513: PROCEDURE open_contact_cursor(

Line 1643: RAISE FND_API.G_EXC_ERROR;

1639: when others then
1640: if (instrb(SQLERRM,'DRG-51030')>0) then
1641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1642: FND_MSG_PUB.ADD;
1643: RAISE FND_API.G_EXC_ERROR;
1644: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1646: FND_MSG_PUB.ADD;
1647: RAISE FND_API.G_EXC_ERROR;

Line 1647: RAISE FND_API.G_EXC_ERROR;

1643: RAISE FND_API.G_EXC_ERROR;
1644: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1646: FND_MSG_PUB.ADD;
1647: RAISE FND_API.G_EXC_ERROR;
1648: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1650: FND_MSG_PUB.ADD;
1651: RAISE FND_API.G_EXC_ERROR;

Line 1651: RAISE FND_API.G_EXC_ERROR;

1647: RAISE FND_API.G_EXC_ERROR;
1648: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1650: FND_MSG_PUB.ADD;
1651: RAISE FND_API.G_EXC_ERROR;
1652: else
1653: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1655: FND_MSG_PUB.ADD;

Line 1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1652: else
1653: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1655: FND_MSG_PUB.ADD;
1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1657: end if;
1658: END;
1659:
1660: PROCEDURE open_contact_pt_cursor(

Line 1916: RAISE FND_API.G_EXC_ERROR;

1912: when others then
1913: if (instrb(SQLERRM,'DRG-51030')>0) then
1914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1915: FND_MSG_PUB.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1918: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1919: FND_MSG_PUB.ADD;
1920: RAISE FND_API.G_EXC_ERROR;

Line 1920: RAISE FND_API.G_EXC_ERROR;

1916: RAISE FND_API.G_EXC_ERROR;
1917: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1918: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1919: FND_MSG_PUB.ADD;
1920: RAISE FND_API.G_EXC_ERROR;
1921: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1923: FND_MSG_PUB.ADD;
1924: RAISE FND_API.G_EXC_ERROR;

Line 1924: RAISE FND_API.G_EXC_ERROR;

1920: RAISE FND_API.G_EXC_ERROR;
1921: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1923: FND_MSG_PUB.ADD;
1924: RAISE FND_API.G_EXC_ERROR;
1925: else
1926: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1928: FND_MSG_PUB.ADD;

Line 1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1925: else
1926: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1928: FND_MSG_PUB.ADD;
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: end if;
1931: END;
1932:
1933:

Line 2179: RAISE FND_API.G_EXC_ERROR;

2175: 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);
2176: END IF;
2177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2178: FND_MSG_PUB.ADD;
2179: RAISE FND_API.G_EXC_ERROR;
2180: ELSE
2181: push_eval;
2182: RETURN;
2183: END IF;

Line 2227: RAISE FND_API.G_EXC_ERROR;

2223: 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);
2224: END IF;
2225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2226: FND_MSG_PUB.ADD;
2227: RAISE FND_API.G_EXC_ERROR;
2228: ELSE
2229: push_eval;
2230: RETURN;
2231: END IF;

Line 2300: RAISE FND_API.G_EXC_ERROR;

2296: 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);
2297: END IF;
2298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2299: FND_MSG_PUB.ADD;
2300: RAISE FND_API.G_EXC_ERROR;
2301: ELSE
2302: push_eval;
2303: RETURN;
2304: END IF;

Line 2412: RAISE FND_API.G_EXC_ERROR;

2408: 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);
2409: END IF;
2410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2411: FND_MSG_PUB.ADD;
2412: RAISE FND_API.G_EXC_ERROR;
2413: ELSE
2414: push_eval;
2415: RETURN;
2416: END IF;

Line 2523: RAISE FND_API.G_EXC_ERROR;

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

Line 2667: RAISE FND_API.G_EXC_ERROR;

2663: 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);
2664: END IF;
2665: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2666: FND_MSG_PUB.ADD;
2667: RAISE FND_API.G_EXC_ERROR;
2668: END IF;
2669: ELSE
2670: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2671: 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 2675: RAISE FND_API.G_EXC_ERROR;

2671: 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);
2672: END IF;
2673: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2674: FND_MSG_PUB.ADD;
2675: RAISE FND_API.G_EXC_ERROR;
2676: END IF;
2677: END IF;
2678: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2679: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2917: WHEN FND_API.G_EXC_ERROR THEN

2913: END IF;
2914: EXCEPTION
2915: WHEN L_RETURN_IMM_EXC THEN
2916: RETURN;
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: RAISE FND_API.G_EXC_ERROR;
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2921: WHEN OTHERS THEN

Line 2918: RAISE FND_API.G_EXC_ERROR;

2914: EXCEPTION
2915: WHEN L_RETURN_IMM_EXC THEN
2916: RETURN;
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: RAISE FND_API.G_EXC_ERROR;
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2921: WHEN OTHERS THEN
2922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2915: WHEN L_RETURN_IMM_EXC THEN
2916: RETURN;
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: RAISE FND_API.G_EXC_ERROR;
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2921: WHEN OTHERS THEN
2922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_parties');

Line 2920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2916: RETURN;
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: RAISE FND_API.G_EXC_ERROR;
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2921: WHEN OTHERS THEN
2922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_parties');
2924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_parties');
2924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2925: FND_MSG_PUB.ADD;
2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2927: END find_parties;
2928:
2929: PROCEDURE find_persons (
2930: p_rule_id IN NUMBER,

Line 3116: RAISE FND_API.G_EXC_ERROR;

3112: 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);
3113: END IF;
3114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3115: FND_MSG_PUB.ADD;
3116: RAISE FND_API.G_EXC_ERROR;
3117: ELSE
3118: push_eval;
3119: RETURN;
3120: END IF;

Line 3164: RAISE FND_API.G_EXC_ERROR;

3160: 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);
3161: END IF;
3162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3163: FND_MSG_PUB.ADD;
3164: RAISE FND_API.G_EXC_ERROR;
3165: ELSE
3166: push_eval;
3167: RETURN;
3168: END IF;

Line 3200: RAISE FND_API.G_EXC_ERROR;

3196: when others then
3197: if (instrb(SQLERRM,'DRG-51030')>0) then
3198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3199: FND_MSG_PUB.ADD;
3200: RAISE FND_API.G_EXC_ERROR;
3201: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_ERROR;

Line 3204: RAISE FND_API.G_EXC_ERROR;

3200: RAISE FND_API.G_EXC_ERROR;
3201: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_ERROR;
3205: else
3206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3207: end if;
3208: END;

Line 3206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_ERROR;
3205: else
3206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3207: end if;
3208: END;
3209:
3210: /** Private procedure to acquire and score at party site level ***/

Line 3276: RAISE FND_API.G_EXC_ERROR;

3272: 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);
3273: END IF;
3274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3275: FND_MSG_PUB.ADD;
3276: RAISE FND_API.G_EXC_ERROR;
3277: ELSE
3278: push_eval;
3279: RETURN;
3280: END IF;

Line 3465: RAISE FND_API.G_EXC_ERROR;

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

Line 3553: RAISE FND_API.G_EXC_ERROR;

3549: 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);
3550: END IF;
3551: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3552: FND_MSG_PUB.ADD;
3553: RAISE FND_API.G_EXC_ERROR;
3554: END IF;
3555: ELSE
3556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3557: 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 3561: RAISE FND_API.G_EXC_ERROR;

3557: 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);
3558: END IF;
3559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3560: FND_MSG_PUB.ADD;
3561: RAISE FND_API.G_EXC_ERROR;
3562: END IF;
3563: END IF;
3564: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3565: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3701: WHEN FND_API.G_EXC_ERROR THEN

3697: END IF;
3698: EXCEPTION
3699: WHEN L_RETURN_IMM_EXC THEN
3700: RETURN;
3701: WHEN FND_API.G_EXC_ERROR THEN
3702: RAISE FND_API.G_EXC_ERROR;
3703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3705: WHEN OTHERS THEN

Line 3702: RAISE FND_API.G_EXC_ERROR;

3698: EXCEPTION
3699: WHEN L_RETURN_IMM_EXC THEN
3700: RETURN;
3701: WHEN FND_API.G_EXC_ERROR THEN
3702: RAISE FND_API.G_EXC_ERROR;
3703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3705: WHEN OTHERS THEN
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3699: WHEN L_RETURN_IMM_EXC THEN
3700: RETURN;
3701: WHEN FND_API.G_EXC_ERROR THEN
3702: RAISE FND_API.G_EXC_ERROR;
3703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3705: WHEN OTHERS THEN
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3707: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');

Line 3704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3700: RETURN;
3701: WHEN FND_API.G_EXC_ERROR THEN
3702: RAISE FND_API.G_EXC_ERROR;
3703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3705: WHEN OTHERS THEN
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3707: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');
3708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3707: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');
3708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3709: FND_MSG_PUB.ADD;
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: END find_persons;
3712:
3713: PROCEDURE find_persons (
3714: p_rule_id IN NUMBER,

Line 3769: WHEN FND_API.G_EXC_ERROR THEN

3765: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3766: 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);
3767: END IF;
3768: EXCEPTION
3769: WHEN FND_API.G_EXC_ERROR THEN
3770: RAISE FND_API.G_EXC_ERROR;
3771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: WHEN OTHERS THEN

Line 3770: RAISE FND_API.G_EXC_ERROR;

3766: 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);
3767: END IF;
3768: EXCEPTION
3769: WHEN FND_API.G_EXC_ERROR THEN
3770: RAISE FND_API.G_EXC_ERROR;
3771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: WHEN OTHERS THEN
3774: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3767: END IF;
3768: EXCEPTION
3769: WHEN FND_API.G_EXC_ERROR THEN
3770: RAISE FND_API.G_EXC_ERROR;
3771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: WHEN OTHERS THEN
3774: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3775: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');

Line 3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3768: EXCEPTION
3769: WHEN FND_API.G_EXC_ERROR THEN
3770: RAISE FND_API.G_EXC_ERROR;
3771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: WHEN OTHERS THEN
3774: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3775: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');
3776: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3774: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3775: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');
3776: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3777: FND_MSG_PUB.ADD;
3778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3779: END find_party_details;
3780:
3781: PROCEDURE find_duplicate_parties (
3782: p_rule_id IN NUMBER,

Line 3886: WHEN FND_API.G_EXC_ERROR THEN

3882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3883: 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);
3884: END IF;
3885: EXCEPTION
3886: WHEN FND_API.G_EXC_ERROR THEN
3887: RAISE FND_API.G_EXC_ERROR;
3888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: WHEN OTHERS THEN

Line 3887: RAISE FND_API.G_EXC_ERROR;

3883: 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);
3884: END IF;
3885: EXCEPTION
3886: WHEN FND_API.G_EXC_ERROR THEN
3887: RAISE FND_API.G_EXC_ERROR;
3888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: WHEN OTHERS THEN
3891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3884: END IF;
3885: EXCEPTION
3886: WHEN FND_API.G_EXC_ERROR THEN
3887: RAISE FND_API.G_EXC_ERROR;
3888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: WHEN OTHERS THEN
3891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3892: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');

Line 3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3885: EXCEPTION
3886: WHEN FND_API.G_EXC_ERROR THEN
3887: RAISE FND_API.G_EXC_ERROR;
3888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: WHEN OTHERS THEN
3891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3892: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');
3893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3892: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');
3893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3894: FND_MSG_PUB.ADD;
3895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3896: END find_duplicate_parties;
3897:
3898: PROCEDURE find_duplicate_party_sites (
3899: p_rule_id IN NUMBER,

Line 3971: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3972: RAISE FND_API.G_EXC_ERROR;

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

Line 3973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3969: END IF;
3970: EXCEPTION
3971: WHEN FND_API.G_EXC_ERROR THEN
3972: RAISE FND_API.G_EXC_ERROR;
3973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: WHEN OTHERS THEN
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3977: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');

Line 3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3970: EXCEPTION
3971: WHEN FND_API.G_EXC_ERROR THEN
3972: RAISE FND_API.G_EXC_ERROR;
3973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: WHEN OTHERS THEN
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3977: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');
3978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3977: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');
3978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3979: FND_MSG_PUB.ADD;
3980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3981: END find_duplicate_party_sites;
3982:
3983: PROCEDURE find_duplicate_contacts (
3984: p_rule_id IN NUMBER,

Line 4060: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4061: RAISE FND_API.G_EXC_ERROR;

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

Line 4062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4133: WHEN FND_API.G_EXC_ERROR THEN

4129: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4130: 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);
4131: END IF;
4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN
4134: RAISE FND_API.G_EXC_ERROR;
4135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: WHEN OTHERS THEN

Line 4134: RAISE FND_API.G_EXC_ERROR;

4130: 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);
4131: END IF;
4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN
4134: RAISE FND_API.G_EXC_ERROR;
4135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: WHEN OTHERS THEN
4138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4131: END IF;
4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN
4134: RAISE FND_API.G_EXC_ERROR;
4135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: WHEN OTHERS THEN
4138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');

Line 4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN
4134: RAISE FND_API.G_EXC_ERROR;
4135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: WHEN OTHERS THEN
4138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');
4140: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');
4140: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4143: END find_duplicate_contact_points;
4144:
4145: PROCEDURE find_parties_dynamic (
4146: p_rule_id IN NUMBER,

Line 4407: WHEN FND_API.G_EXC_ERROR THEN

4403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4404: 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);
4405: END IF;
4406: EXCEPTION
4407: WHEN FND_API.G_EXC_ERROR THEN
4408: RAISE FND_API.G_EXC_ERROR;
4409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4411: WHEN OTHERS THEN

Line 4408: RAISE FND_API.G_EXC_ERROR;

4404: 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);
4405: END IF;
4406: EXCEPTION
4407: WHEN FND_API.G_EXC_ERROR THEN
4408: RAISE FND_API.G_EXC_ERROR;
4409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4411: WHEN OTHERS THEN
4412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4405: END IF;
4406: EXCEPTION
4407: WHEN FND_API.G_EXC_ERROR THEN
4408: RAISE FND_API.G_EXC_ERROR;
4409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4411: WHEN OTHERS THEN
4412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');

Line 4410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4406: EXCEPTION
4407: WHEN FND_API.G_EXC_ERROR THEN
4408: RAISE FND_API.G_EXC_ERROR;
4409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4411: WHEN OTHERS THEN
4412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4415: FND_MSG_PUB.ADD;
4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4417: END call_api_dynamic;
4418:
4419:
4420: PROCEDURE get_matching_party_sites (

Line 4641: WHEN FND_API.G_EXC_ERROR THEN

4637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4638: 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);
4639: END IF;
4640: EXCEPTION
4641: WHEN FND_API.G_EXC_ERROR THEN
4642: RAISE FND_API.G_EXC_ERROR;
4643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4645: WHEN OTHERS THEN

Line 4642: RAISE FND_API.G_EXC_ERROR;

4638: 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);
4639: END IF;
4640: EXCEPTION
4641: WHEN FND_API.G_EXC_ERROR THEN
4642: RAISE FND_API.G_EXC_ERROR;
4643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4645: WHEN OTHERS THEN
4646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4639: END IF;
4640: EXCEPTION
4641: WHEN FND_API.G_EXC_ERROR THEN
4642: RAISE FND_API.G_EXC_ERROR;
4643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4645: WHEN OTHERS THEN
4646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4647: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');

Line 4644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4640: EXCEPTION
4641: WHEN FND_API.G_EXC_ERROR THEN
4642: RAISE FND_API.G_EXC_ERROR;
4643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4645: WHEN OTHERS THEN
4646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4647: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4647: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4649: FND_MSG_PUB.ADD;
4650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4651: END get_matching_party_sites;
4652:
4653:
4654: PROCEDURE get_matching_contacts (

Line 4866: WHEN FND_API.G_EXC_ERROR THEN

4862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4863: 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);
4864: END IF;
4865: EXCEPTION
4866: WHEN FND_API.G_EXC_ERROR THEN
4867: RAISE FND_API.G_EXC_ERROR;
4868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4870: WHEN OTHERS THEN

Line 4867: RAISE FND_API.G_EXC_ERROR;

4863: 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);
4864: END IF;
4865: EXCEPTION
4866: WHEN FND_API.G_EXC_ERROR THEN
4867: RAISE FND_API.G_EXC_ERROR;
4868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4870: WHEN OTHERS THEN
4871: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4864: END IF;
4865: EXCEPTION
4866: WHEN FND_API.G_EXC_ERROR THEN
4867: RAISE FND_API.G_EXC_ERROR;
4868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4870: WHEN OTHERS THEN
4871: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4872: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');

Line 4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4865: EXCEPTION
4866: WHEN FND_API.G_EXC_ERROR THEN
4867: RAISE FND_API.G_EXC_ERROR;
4868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4870: WHEN OTHERS THEN
4871: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4872: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');
4873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4871: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4872: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');
4873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4874: FND_MSG_PUB.ADD;
4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4876: END get_matching_contacts;
4877:
4878:
4879: PROCEDURE get_matching_contact_points (

Line 5005: WHEN FND_API.G_EXC_ERROR THEN

5001: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5002: 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);
5003: END IF;
5004: EXCEPTION
5005: WHEN FND_API.G_EXC_ERROR THEN
5006: RAISE FND_API.G_EXC_ERROR;
5007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: WHEN OTHERS THEN

Line 5006: RAISE FND_API.G_EXC_ERROR;

5002: 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);
5003: END IF;
5004: EXCEPTION
5005: WHEN FND_API.G_EXC_ERROR THEN
5006: RAISE FND_API.G_EXC_ERROR;
5007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: WHEN OTHERS THEN
5010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5003: END IF;
5004: EXCEPTION
5005: WHEN FND_API.G_EXC_ERROR THEN
5006: RAISE FND_API.G_EXC_ERROR;
5007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: WHEN OTHERS THEN
5010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');

Line 5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5004: EXCEPTION
5005: WHEN FND_API.G_EXC_ERROR THEN
5006: RAISE FND_API.G_EXC_ERROR;
5007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: WHEN OTHERS THEN
5010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');
5012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');
5012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: END get_matching_contact_points;
5016:
5017: /**********************************************************
5018: This procedure finds the score details for a specific party that

Line 5208: WHEN FND_API.G_EXC_ERROR THEN

5204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5205: 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);
5206: END IF;
5207: EXCEPTION
5208: WHEN FND_API.G_EXC_ERROR THEN
5209: RAISE FND_API.G_EXC_ERROR;
5210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5212: WHEN OTHERS THEN

Line 5209: RAISE FND_API.G_EXC_ERROR;

5205: 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);
5206: END IF;
5207: EXCEPTION
5208: WHEN FND_API.G_EXC_ERROR THEN
5209: RAISE FND_API.G_EXC_ERROR;
5210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5212: WHEN OTHERS THEN
5213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5206: END IF;
5207: EXCEPTION
5208: WHEN FND_API.G_EXC_ERROR THEN
5209: RAISE FND_API.G_EXC_ERROR;
5210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5212: WHEN OTHERS THEN
5213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');

Line 5211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5207: EXCEPTION
5208: WHEN FND_API.G_EXC_ERROR THEN
5209: RAISE FND_API.G_EXC_ERROR;
5210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5212: WHEN OTHERS THEN
5213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5216: FND_MSG_PUB.ADD;
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: END get_score_details;
5219:
5220:
5221: /************************************************

Line 5286: WHEN FND_API.G_EXC_ERROR THEN

5282: END LOOP;
5283: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5284: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: RAISE FND_API.G_EXC_ERROR;
5288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5290: WHEN OTHERS THEN

Line 5287: RAISE FND_API.G_EXC_ERROR;

5283: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5284: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: RAISE FND_API.G_EXC_ERROR;
5288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5290: WHEN OTHERS THEN
5291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5284: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: RAISE FND_API.G_EXC_ERROR;
5288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5290: WHEN OTHERS THEN
5291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: RAISE FND_API.G_EXC_ERROR;
5288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5290: WHEN OTHERS THEN
5291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5294: FND_MSG_PUB.ADD;
5295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5296: END get_party_for_search;
5297:
5298: PROCEDURE get_search_criteria (
5299: p_party_id IN NUMBER,

Line 5326: WHEN FND_API.G_EXC_ERROR THEN

5322: END IF;
5323: get_party_site_rec(p_party_site_ids, x_party_site_list);
5324: END IF;
5325: EXCEPTION
5326: WHEN FND_API.G_EXC_ERROR THEN
5327: RAISE FND_API.G_EXC_ERROR;
5328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5330: WHEN OTHERS THEN

Line 5327: RAISE FND_API.G_EXC_ERROR;

5323: get_party_site_rec(p_party_site_ids, x_party_site_list);
5324: END IF;
5325: EXCEPTION
5326: WHEN FND_API.G_EXC_ERROR THEN
5327: RAISE FND_API.G_EXC_ERROR;
5328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5330: WHEN OTHERS THEN
5331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5324: END IF;
5325: EXCEPTION
5326: WHEN FND_API.G_EXC_ERROR THEN
5327: RAISE FND_API.G_EXC_ERROR;
5328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5330: WHEN OTHERS THEN
5331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5332: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5325: EXCEPTION
5326: WHEN FND_API.G_EXC_ERROR THEN
5327: RAISE FND_API.G_EXC_ERROR;
5328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5330: WHEN OTHERS THEN
5331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5332: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5332: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5334: FND_MSG_PUB.ADD;
5335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5336: END get_search_criteria;
5337:
5338:
5339: /************************************************

Line 5402: RAISE FND_API.G_EXC_ERROR;

5398: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5399: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5400: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5401: FND_MSG_PUB.ADD;
5402: RAISE FND_API.G_EXC_ERROR;
5403: END get_party_rec;
5404:
5405: /************************************************
5406: This procedure retrieves the match rule party site attributes into

Line 5458: RAISE FND_API.G_EXC_ERROR;

5454: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5455: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5457: FND_MSG_PUB.ADD;
5458: RAISE FND_API.G_EXC_ERROR;
5459: END get_party_site_rec;
5460:
5461: /************************************************
5462: This procedure retrieves the match rule contact attributes into

Line 5514: RAISE FND_API.G_EXC_ERROR;

5510: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5511: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;
5514: RAISE FND_API.G_EXC_ERROR;
5515: END get_contact_rec;
5516:
5517: /************************************************
5518: This procedure retrieves the match rule contact point attributes into

Line 5566: RAISE FND_API.G_EXC_ERROR;

5562: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5563: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5565: FND_MSG_PUB.ADD;
5566: RAISE FND_API.G_EXC_ERROR;
5567: END get_contact_point_rec;
5568:
5569: /************************************************
5570: This procedure maps a search record from the logical

Line 5713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5709: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5710: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5711: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5712: FND_MSG_PUB.ADD;
5713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5714: END;
5715:
5716:
5717: /************************************************

Line 5828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5824: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5825: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5826: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5827: FND_MSG_PUB.ADD;
5828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5829: END;
5830:
5831:
5832: /************************************************

Line 5870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5866: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5867: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5871: END;
5872:
5873:
5874: /************************************************

Line 5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5909: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5910: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5911: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5912: FND_MSG_PUB.ADD;
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: END;
5915:
5916:
5917: /************************************************

Line 5941: WHEN FND_API.G_EXC_ERROR THEN

5937: END IF;
5938: END LOOP;
5939: RETURN FALSE;
5940: EXCEPTION
5941: WHEN FND_API.G_EXC_ERROR THEN
5942: RAISE FND_API.G_EXC_ERROR;
5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5942: RAISE FND_API.G_EXC_ERROR;

5938: END LOOP;
5939: RETURN FALSE;
5940: EXCEPTION
5941: WHEN FND_API.G_EXC_ERROR THEN
5942: RAISE FND_API.G_EXC_ERROR;
5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5947: FND_MSG_PUB.ADD;
5948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5949: END check_prim_cond;
5950:
5951: /************************************************
5952: This procedure checks if the input search condition

Line 5992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5991: FND_MSG_PUB.ADD;
5992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5993: END check_party_site_cond;
5994:
5995: /************************************************
5996: This procedure checks if the input search condition

Line 6030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6027: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6029: FND_MSG_PUB.ADD;
6030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6031: END check_contact_cond;
6032:
6033: /************************************************
6034: This procedure checks if the input search condition

Line 6051: RAISE FND_API.G_EXC_ERROR;

6047: FOR I IN 1..p_contact_point_list.COUNT LOOP
6048: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6049: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6050: FND_MSG_PUB.ADD;
6051: RAISE FND_API.G_EXC_ERROR;
6052: END IF;
6053: END LOOP;
6054:
6055: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6064: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6066: FND_MSG_PUB.ADD;
6067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6068: END check_contact_point_cond;
6069:
6070: FUNCTION check_staged RETURN BOOLEAN IS
6071: