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

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

Line 1253: RAISE FND_API.G_EXC_ERROR;

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

Line 1257: RAISE FND_API.G_EXC_ERROR;

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

Line 1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1494: RAISE FND_API.G_EXC_ERROR;

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

Line 1498: RAISE FND_API.G_EXC_ERROR;

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

Line 1502: RAISE FND_API.G_EXC_ERROR;

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

Line 1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1641: RAISE FND_API.G_EXC_ERROR;

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

Line 1645: RAISE FND_API.G_EXC_ERROR;

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

Line 1649: RAISE FND_API.G_EXC_ERROR;

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

Line 1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1914: RAISE FND_API.G_EXC_ERROR;

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

Line 1918: RAISE FND_API.G_EXC_ERROR;

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

Line 1922: RAISE FND_API.G_EXC_ERROR;

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

Line 1927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2176: RAISE FND_API.G_EXC_ERROR;

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

Line 2224: RAISE FND_API.G_EXC_ERROR;

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

Line 2297: RAISE FND_API.G_EXC_ERROR;

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

Line 2409: RAISE FND_API.G_EXC_ERROR;

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

Line 2520: RAISE FND_API.G_EXC_ERROR;

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

Line 2664: RAISE FND_API.G_EXC_ERROR;

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

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

Line 2914: WHEN FND_API.G_EXC_ERROR THEN

2910: END IF;
2911: EXCEPTION
2912: WHEN L_RETURN_IMM_EXC THEN
2913: RETURN;
2914: WHEN FND_API.G_EXC_ERROR THEN
2915: RAISE FND_API.G_EXC_ERROR;
2916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: WHEN OTHERS THEN

Line 2915: RAISE FND_API.G_EXC_ERROR;

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

Line 2916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3112: RAISE FND_API.G_EXC_ERROR;

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

Line 3160: RAISE FND_API.G_EXC_ERROR;

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

Line 3196: RAISE FND_API.G_EXC_ERROR;

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

Line 3200: RAISE FND_API.G_EXC_ERROR;

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

Line 3202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3272: RAISE FND_API.G_EXC_ERROR;

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

Line 3461: RAISE FND_API.G_EXC_ERROR;

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

Line 3549: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3697: WHEN FND_API.G_EXC_ERROR THEN

3693: END IF;
3694: EXCEPTION
3695: WHEN L_RETURN_IMM_EXC THEN
3696: RETURN;
3697: WHEN FND_API.G_EXC_ERROR THEN
3698: RAISE FND_API.G_EXC_ERROR;
3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3701: WHEN OTHERS THEN

Line 3698: RAISE FND_API.G_EXC_ERROR;

3694: EXCEPTION
3695: WHEN L_RETURN_IMM_EXC THEN
3696: RETURN;
3697: WHEN FND_API.G_EXC_ERROR THEN
3698: RAISE FND_API.G_EXC_ERROR;
3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3701: WHEN OTHERS THEN
3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3695: WHEN L_RETURN_IMM_EXC THEN
3696: RETURN;
3697: WHEN FND_API.G_EXC_ERROR THEN
3698: RAISE FND_API.G_EXC_ERROR;
3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3701: WHEN OTHERS THEN
3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3703: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');

Line 3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3696: RETURN;
3697: WHEN FND_API.G_EXC_ERROR THEN
3698: RAISE FND_API.G_EXC_ERROR;
3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3701: WHEN OTHERS THEN
3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3703: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');
3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3765: WHEN FND_API.G_EXC_ERROR THEN

3761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3762: 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);
3763: END IF;
3764: EXCEPTION
3765: WHEN FND_API.G_EXC_ERROR THEN
3766: RAISE FND_API.G_EXC_ERROR;
3767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: WHEN OTHERS THEN

Line 3766: RAISE FND_API.G_EXC_ERROR;

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

Line 3767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3763: END IF;
3764: EXCEPTION
3765: WHEN FND_API.G_EXC_ERROR THEN
3766: RAISE FND_API.G_EXC_ERROR;
3767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: WHEN OTHERS THEN
3770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3771: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');

Line 3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3764: EXCEPTION
3765: WHEN FND_API.G_EXC_ERROR THEN
3766: RAISE FND_API.G_EXC_ERROR;
3767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: WHEN OTHERS THEN
3770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3771: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');
3772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3882: WHEN FND_API.G_EXC_ERROR THEN

3878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3879: 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);
3880: END IF;
3881: EXCEPTION
3882: WHEN FND_API.G_EXC_ERROR THEN
3883: RAISE FND_API.G_EXC_ERROR;
3884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: WHEN OTHERS THEN

Line 3883: RAISE FND_API.G_EXC_ERROR;

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

Line 3884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3880: END IF;
3881: EXCEPTION
3882: WHEN FND_API.G_EXC_ERROR THEN
3883: RAISE FND_API.G_EXC_ERROR;
3884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: WHEN OTHERS THEN
3887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3888: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');

Line 3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3881: EXCEPTION
3882: WHEN FND_API.G_EXC_ERROR THEN
3883: RAISE FND_API.G_EXC_ERROR;
3884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: WHEN OTHERS THEN
3887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3888: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');
3889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3967: WHEN FND_API.G_EXC_ERROR THEN

3963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3964: 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);
3965: END IF;
3966: EXCEPTION
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN

Line 3968: RAISE FND_API.G_EXC_ERROR;

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

Line 3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3965: END IF;
3966: EXCEPTION
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');

Line 3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3966: EXCEPTION
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4056: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4057: RAISE FND_API.G_EXC_ERROR;

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

Line 4058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4054: END IF;
4055: EXCEPTION
4056: WHEN FND_API.G_EXC_ERROR THEN
4057: RAISE FND_API.G_EXC_ERROR;
4058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: WHEN OTHERS THEN
4061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4062: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contacts');

Line 4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4055: EXCEPTION
4056: WHEN FND_API.G_EXC_ERROR THEN
4057: RAISE FND_API.G_EXC_ERROR;
4058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: WHEN OTHERS THEN
4061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4062: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contacts');
4063: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4129: WHEN FND_API.G_EXC_ERROR THEN

4125: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4126: 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);
4127: END IF;
4128: EXCEPTION
4129: WHEN FND_API.G_EXC_ERROR THEN
4130: RAISE FND_API.G_EXC_ERROR;
4131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4133: WHEN OTHERS THEN

Line 4130: RAISE FND_API.G_EXC_ERROR;

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

Line 4131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4127: END IF;
4128: EXCEPTION
4129: WHEN FND_API.G_EXC_ERROR THEN
4130: RAISE FND_API.G_EXC_ERROR;
4131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4133: WHEN OTHERS THEN
4134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4135: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');

Line 4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4128: EXCEPTION
4129: WHEN FND_API.G_EXC_ERROR THEN
4130: RAISE FND_API.G_EXC_ERROR;
4131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4133: WHEN OTHERS THEN
4134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4135: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');
4136: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4403: WHEN FND_API.G_EXC_ERROR THEN

4399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4400: 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);
4401: END IF;
4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: RAISE FND_API.G_EXC_ERROR;
4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN

Line 4404: RAISE FND_API.G_EXC_ERROR;

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

Line 4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4401: END IF;
4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: RAISE FND_API.G_EXC_ERROR;
4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN
4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');

Line 4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: RAISE FND_API.G_EXC_ERROR;
4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN
4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4411: FND_MSG_PUB.ADD;
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: END call_api_dynamic;
4414:
4415:
4416: PROCEDURE get_matching_party_sites (

Line 4637: WHEN FND_API.G_EXC_ERROR THEN

4633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4634: 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);
4635: END IF;
4636: EXCEPTION
4637: WHEN FND_API.G_EXC_ERROR THEN
4638: RAISE FND_API.G_EXC_ERROR;
4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: WHEN OTHERS THEN

Line 4638: RAISE FND_API.G_EXC_ERROR;

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

Line 4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4635: END IF;
4636: EXCEPTION
4637: WHEN FND_API.G_EXC_ERROR THEN
4638: RAISE FND_API.G_EXC_ERROR;
4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: WHEN OTHERS THEN
4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');

Line 4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4636: EXCEPTION
4637: WHEN FND_API.G_EXC_ERROR THEN
4638: RAISE FND_API.G_EXC_ERROR;
4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: WHEN OTHERS THEN
4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4645: FND_MSG_PUB.ADD;
4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4647: END get_matching_party_sites;
4648:
4649:
4650: PROCEDURE get_matching_contacts (

Line 4862: WHEN FND_API.G_EXC_ERROR THEN

4858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4859: 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);
4860: END IF;
4861: EXCEPTION
4862: WHEN FND_API.G_EXC_ERROR THEN
4863: RAISE FND_API.G_EXC_ERROR;
4864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4866: WHEN OTHERS THEN

Line 4863: RAISE FND_API.G_EXC_ERROR;

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

Line 4864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4860: END IF;
4861: EXCEPTION
4862: WHEN FND_API.G_EXC_ERROR THEN
4863: RAISE FND_API.G_EXC_ERROR;
4864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4866: WHEN OTHERS THEN
4867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');

Line 4865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4861: EXCEPTION
4862: WHEN FND_API.G_EXC_ERROR THEN
4863: RAISE FND_API.G_EXC_ERROR;
4864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4866: WHEN OTHERS THEN
4867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');
4869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');
4869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4870: FND_MSG_PUB.ADD;
4871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4872: END get_matching_contacts;
4873:
4874:
4875: PROCEDURE get_matching_contact_points (

Line 5001: WHEN FND_API.G_EXC_ERROR THEN

4997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4998: 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);
4999: END IF;
5000: EXCEPTION
5001: WHEN FND_API.G_EXC_ERROR THEN
5002: RAISE FND_API.G_EXC_ERROR;
5003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5005: WHEN OTHERS THEN

Line 5002: RAISE FND_API.G_EXC_ERROR;

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

Line 5003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4999: END IF;
5000: EXCEPTION
5001: WHEN FND_API.G_EXC_ERROR THEN
5002: RAISE FND_API.G_EXC_ERROR;
5003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5005: WHEN OTHERS THEN
5006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5007: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');

Line 5004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5000: EXCEPTION
5001: WHEN FND_API.G_EXC_ERROR THEN
5002: RAISE FND_API.G_EXC_ERROR;
5003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5005: WHEN OTHERS THEN
5006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5007: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');
5008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5203: WHEN FND_API.G_EXC_ERROR THEN

5199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5200: 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);
5201: END IF;
5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
5204: RAISE FND_API.G_EXC_ERROR;
5205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: WHEN OTHERS THEN

Line 5204: RAISE FND_API.G_EXC_ERROR;

5200: 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);
5201: END IF;
5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
5204: RAISE FND_API.G_EXC_ERROR;
5205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: WHEN OTHERS THEN
5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5201: END IF;
5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
5204: RAISE FND_API.G_EXC_ERROR;
5205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: WHEN OTHERS THEN
5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5209: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');

Line 5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
5204: RAISE FND_API.G_EXC_ERROR;
5205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: WHEN OTHERS THEN
5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5209: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5210: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5209: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5210: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5211: FND_MSG_PUB.ADD;
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: END get_score_details;
5214:
5215:
5216: /************************************************

Line 5281: WHEN FND_API.G_EXC_ERROR THEN

5277: END LOOP;
5278: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5279: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5280: EXCEPTION
5281: WHEN FND_API.G_EXC_ERROR THEN
5282: RAISE FND_API.G_EXC_ERROR;
5283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5285: WHEN OTHERS THEN

Line 5282: RAISE FND_API.G_EXC_ERROR;

5278: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5279: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5280: EXCEPTION
5281: WHEN FND_API.G_EXC_ERROR THEN
5282: RAISE FND_API.G_EXC_ERROR;
5283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5285: WHEN OTHERS THEN
5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5279: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5280: EXCEPTION
5281: WHEN FND_API.G_EXC_ERROR THEN
5282: RAISE FND_API.G_EXC_ERROR;
5283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5285: WHEN OTHERS THEN
5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5287: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5280: EXCEPTION
5281: WHEN FND_API.G_EXC_ERROR THEN
5282: RAISE FND_API.G_EXC_ERROR;
5283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5285: WHEN OTHERS THEN
5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5287: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5287: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5289: FND_MSG_PUB.ADD;
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: END get_party_for_search;
5292:
5293: PROCEDURE get_search_criteria (
5294: p_party_id IN NUMBER,

Line 5321: WHEN FND_API.G_EXC_ERROR THEN

5317: END IF;
5318: get_party_site_rec(p_party_site_ids, x_party_site_list);
5319: END IF;
5320: EXCEPTION
5321: WHEN FND_API.G_EXC_ERROR THEN
5322: RAISE FND_API.G_EXC_ERROR;
5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: WHEN OTHERS THEN

Line 5322: RAISE FND_API.G_EXC_ERROR;

5318: get_party_site_rec(p_party_site_ids, x_party_site_list);
5319: END IF;
5320: EXCEPTION
5321: WHEN FND_API.G_EXC_ERROR THEN
5322: RAISE FND_API.G_EXC_ERROR;
5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: WHEN OTHERS THEN
5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5319: END IF;
5320: EXCEPTION
5321: WHEN FND_API.G_EXC_ERROR THEN
5322: RAISE FND_API.G_EXC_ERROR;
5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: WHEN OTHERS THEN
5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5320: EXCEPTION
5321: WHEN FND_API.G_EXC_ERROR THEN
5322: RAISE FND_API.G_EXC_ERROR;
5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: WHEN OTHERS THEN
5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5329: FND_MSG_PUB.ADD;
5330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5331: END get_search_criteria;
5332:
5333:
5334: /************************************************

Line 5397: RAISE FND_API.G_EXC_ERROR;

5393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5396: FND_MSG_PUB.ADD;
5397: RAISE FND_API.G_EXC_ERROR;
5398: END get_party_rec;
5399:
5400: /************************************************
5401: This procedure retrieves the match rule party site attributes into

Line 5453: RAISE FND_API.G_EXC_ERROR;

5449: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5450: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END get_party_site_rec;
5455:
5456: /************************************************
5457: This procedure retrieves the match rule contact attributes into

Line 5509: RAISE FND_API.G_EXC_ERROR;

5505: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5506: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_ERROR;
5510: END get_contact_rec;
5511:
5512: /************************************************
5513: This procedure retrieves the match rule contact point attributes into

Line 5561: RAISE FND_API.G_EXC_ERROR;

5557: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5558: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5560: FND_MSG_PUB.ADD;
5561: RAISE FND_API.G_EXC_ERROR;
5562: END get_contact_point_rec;
5563:
5564: /************************************************
5565: This procedure maps a search record from the logical

Line 5708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5704: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5705: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5707: FND_MSG_PUB.ADD;
5708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5709: END;
5710:
5711:
5712: /************************************************

Line 5823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5819: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5821: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5822: FND_MSG_PUB.ADD;
5823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5824: END;
5825:
5826:
5827: /************************************************

Line 5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5866: END;
5867:
5868:
5869: /************************************************

Line 5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5936: WHEN FND_API.G_EXC_ERROR THEN

5932: END IF;
5933: END LOOP;
5934: RETURN FALSE;
5935: EXCEPTION
5936: WHEN FND_API.G_EXC_ERROR THEN
5937: RAISE FND_API.G_EXC_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5937: RAISE FND_API.G_EXC_ERROR;

5933: END LOOP;
5934: RETURN FALSE;
5935: EXCEPTION
5936: WHEN FND_API.G_EXC_ERROR THEN
5937: RAISE FND_API.G_EXC_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5944: END check_prim_cond;
5945:
5946: /************************************************
5947: This procedure checks if the input search condition

Line 5987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5988: END check_party_site_cond;
5989:
5990: /************************************************
5991: This procedure checks if the input search condition

Line 6025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6024: FND_MSG_PUB.ADD;
6025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6026: END check_contact_cond;
6027:
6028: /************************************************
6029: This procedure checks if the input search condition

Line 6046: RAISE FND_API.G_EXC_ERROR;

6042: FOR I IN 1..p_contact_point_list.COUNT LOOP
6043: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6044: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END IF;
6048: END LOOP;
6049:
6050: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6059: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6061: FND_MSG_PUB.ADD;
6062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6063: END check_contact_point_cond;
6064:
6065: FUNCTION check_staged RETURN BOOLEAN IS
6066: