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_7 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 683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

679: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
680: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
681: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END;
685:
686:
687: /************************************************

Line 703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

699: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
700: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
701: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
702: FND_MSG_PUB.ADD;
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END;
705:
706:
707: /************************************************

Line 723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

719: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
720: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END;
725:
726:
727: /************************************************

Line 743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

739: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
740: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
741: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
742: FND_MSG_PUB.ADD;
743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
744: END;
745:
746: PROCEDURE init_score_context (
747: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 810: RAISE FND_API.G_EXC_ERROR;

806: p_contact_list,
807: p_contact_point_list) THEN
808: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
813: 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);
814: END IF;

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041: IF lengthb(l_party_contains_str) > 4000 THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1043: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1044: FND_MSG_PUB.ADD;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047: IF (p_match_str = ' AND ' OR p_party_max_score 1048: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1049: 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 1114: RAISE FND_API.G_EXC_ERROR;

1110: IF lengthb(l_contains_str) > 4000 THEN
1111: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1112: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1113: FND_MSG_PUB.ADD;
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116: x_denorm_str := l_den_contains_str;
1117: RETURN l_contains_str;
1118: END;

Line 1175: RAISE FND_API.G_EXC_ERROR;

1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: x_denorm_str := l_den_contains_str;
1178: RETURN l_contains_str;
1179: END;

Line 1395: RAISE FND_API.G_EXC_ERROR;

1391: when others then
1392: if (instrb(SQLERRM,'DRG-51030')>0) then
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1398: FND_MSG_PUB.ADD;
1399: RAISE FND_API.G_EXC_ERROR;

Line 1399: RAISE FND_API.G_EXC_ERROR;

1395: RAISE FND_API.G_EXC_ERROR;
1396: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1398: FND_MSG_PUB.ADD;
1399: RAISE FND_API.G_EXC_ERROR;
1400: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;

Line 1403: RAISE FND_API.G_EXC_ERROR;

1399: RAISE FND_API.G_EXC_ERROR;
1400: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: else
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;

Line 1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1404: else
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: end if;
1410: END;
1411:
1412: PROCEDURE open_party_site_cursor(

Line 1640: RAISE FND_API.G_EXC_ERROR;

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

Line 1644: RAISE FND_API.G_EXC_ERROR;

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

Line 1648: RAISE FND_API.G_EXC_ERROR;

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

Line 1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1787: RAISE FND_API.G_EXC_ERROR;

1783: when others then
1784: if (instrb(SQLERRM,'DRG-51030')>0) then
1785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1786: FND_MSG_PUB.ADD;
1787: RAISE FND_API.G_EXC_ERROR;
1788: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1790: FND_MSG_PUB.ADD;
1791: RAISE FND_API.G_EXC_ERROR;

Line 1791: RAISE FND_API.G_EXC_ERROR;

1787: RAISE FND_API.G_EXC_ERROR;
1788: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1790: FND_MSG_PUB.ADD;
1791: RAISE FND_API.G_EXC_ERROR;
1792: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1794: FND_MSG_PUB.ADD;
1795: RAISE FND_API.G_EXC_ERROR;

Line 1795: RAISE FND_API.G_EXC_ERROR;

1791: RAISE FND_API.G_EXC_ERROR;
1792: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1794: FND_MSG_PUB.ADD;
1795: RAISE FND_API.G_EXC_ERROR;
1796: else
1797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1798: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1799: FND_MSG_PUB.ADD;

Line 1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1796: else
1797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1798: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1799: FND_MSG_PUB.ADD;
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: end if;
1802: END;
1803:
1804: PROCEDURE open_contact_pt_cursor(

Line 2060: RAISE FND_API.G_EXC_ERROR;

2056: when others then
2057: if (instrb(SQLERRM,'DRG-51030')>0) then
2058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2059: FND_MSG_PUB.ADD;
2060: RAISE FND_API.G_EXC_ERROR;
2061: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2063: FND_MSG_PUB.ADD;
2064: RAISE FND_API.G_EXC_ERROR;

Line 2064: RAISE FND_API.G_EXC_ERROR;

2060: RAISE FND_API.G_EXC_ERROR;
2061: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2063: FND_MSG_PUB.ADD;
2064: RAISE FND_API.G_EXC_ERROR;
2065: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2067: FND_MSG_PUB.ADD;
2068: RAISE FND_API.G_EXC_ERROR;

Line 2068: RAISE FND_API.G_EXC_ERROR;

2064: RAISE FND_API.G_EXC_ERROR;
2065: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2067: FND_MSG_PUB.ADD;
2068: RAISE FND_API.G_EXC_ERROR;
2069: else
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2072: FND_MSG_PUB.ADD;

Line 2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2069: else
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2072: FND_MSG_PUB.ADD;
2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2074: end if;
2075: END;
2076:
2077:

Line 2326: RAISE FND_API.G_EXC_ERROR;

2322: 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);
2323: END IF;
2324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2325: FND_MSG_PUB.ADD;
2326: RAISE FND_API.G_EXC_ERROR;
2327: ELSE
2328: push_eval;
2329: RETURN;
2330: END IF;

Line 2374: RAISE FND_API.G_EXC_ERROR;

2370: 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);
2371: END IF;
2372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2373: FND_MSG_PUB.ADD;
2374: RAISE FND_API.G_EXC_ERROR;
2375: ELSE
2376: push_eval;
2377: RETURN;
2378: END IF;

Line 2447: RAISE FND_API.G_EXC_ERROR;

2443: 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);
2444: END IF;
2445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2446: FND_MSG_PUB.ADD;
2447: RAISE FND_API.G_EXC_ERROR;
2448: ELSE
2449: push_eval;
2450: RETURN;
2451: END IF;

Line 2559: RAISE FND_API.G_EXC_ERROR;

2555: 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);
2556: END IF;
2557: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2558: FND_MSG_PUB.ADD;
2559: RAISE FND_API.G_EXC_ERROR;
2560: ELSE
2561: push_eval;
2562: RETURN;
2563: END IF;

Line 2670: RAISE FND_API.G_EXC_ERROR;

2666: 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);
2667: END IF;
2668: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2669: FND_MSG_PUB.ADD;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSE
2672: push_eval;
2673: RETURN;
2674: END IF;

Line 2814: RAISE FND_API.G_EXC_ERROR;

2810: 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);
2811: END IF;
2812: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2813: FND_MSG_PUB.ADD;
2814: RAISE FND_API.G_EXC_ERROR;
2815: END IF;
2816: ELSE
2817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2818: 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 2822: RAISE FND_API.G_EXC_ERROR;

2818: 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);
2819: END IF;
2820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2821: FND_MSG_PUB.ADD;
2822: RAISE FND_API.G_EXC_ERROR;
2823: END IF;
2824: END IF;
2825: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2826: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3064: WHEN FND_API.G_EXC_ERROR THEN

3060: END IF;
3061: EXCEPTION
3062: WHEN L_RETURN_IMM_EXC THEN
3063: RETURN;
3064: WHEN FND_API.G_EXC_ERROR THEN
3065: RAISE FND_API.G_EXC_ERROR;
3066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: WHEN OTHERS THEN

Line 3065: RAISE FND_API.G_EXC_ERROR;

3061: EXCEPTION
3062: WHEN L_RETURN_IMM_EXC THEN
3063: RETURN;
3064: WHEN FND_API.G_EXC_ERROR THEN
3065: RAISE FND_API.G_EXC_ERROR;
3066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: WHEN OTHERS THEN
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3062: WHEN L_RETURN_IMM_EXC THEN
3063: RETURN;
3064: WHEN FND_API.G_EXC_ERROR THEN
3065: RAISE FND_API.G_EXC_ERROR;
3066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: WHEN OTHERS THEN
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3070: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_parties');

Line 3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3063: RETURN;
3064: WHEN FND_API.G_EXC_ERROR THEN
3065: RAISE FND_API.G_EXC_ERROR;
3066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: WHEN OTHERS THEN
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3070: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_parties');
3071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3070: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_parties');
3071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3072: FND_MSG_PUB.ADD;
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074: END find_parties;
3075:
3076: PROCEDURE find_persons (
3077: p_rule_id IN NUMBER,

Line 3266: RAISE FND_API.G_EXC_ERROR;

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

Line 3314: RAISE FND_API.G_EXC_ERROR;

3310: 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);
3311: END IF;
3312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3313: FND_MSG_PUB.ADD;
3314: RAISE FND_API.G_EXC_ERROR;
3315: ELSE
3316: push_eval;
3317: RETURN;
3318: END IF;

Line 3350: RAISE FND_API.G_EXC_ERROR;

3346: when others then
3347: if (instrb(SQLERRM,'DRG-51030')>0) then
3348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3353: FND_MSG_PUB.ADD;
3354: RAISE FND_API.G_EXC_ERROR;

Line 3354: RAISE FND_API.G_EXC_ERROR;

3350: RAISE FND_API.G_EXC_ERROR;
3351: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3353: FND_MSG_PUB.ADD;
3354: RAISE FND_API.G_EXC_ERROR;
3355: else
3356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3357: end if;
3358: END;

Line 3356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3353: FND_MSG_PUB.ADD;
3354: RAISE FND_API.G_EXC_ERROR;
3355: else
3356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3357: end if;
3358: END;
3359:
3360: /** Private procedure to acquire and score at party site level ***/

Line 3426: RAISE FND_API.G_EXC_ERROR;

3422: 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);
3423: END IF;
3424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3425: FND_MSG_PUB.ADD;
3426: RAISE FND_API.G_EXC_ERROR;
3427: ELSE
3428: push_eval;
3429: RETURN;
3430: END IF;

Line 3615: RAISE FND_API.G_EXC_ERROR;

3611: 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);
3612: END IF;
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: ELSE
3617: push_eval;
3618: RETURN;
3619: END IF;

Line 3703: RAISE FND_API.G_EXC_ERROR;

3699: 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);
3700: END IF;
3701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3702: FND_MSG_PUB.ADD;
3703: RAISE FND_API.G_EXC_ERROR;
3704: END IF;
3705: ELSE
3706: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3707: 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 3711: RAISE FND_API.G_EXC_ERROR;

3707: 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);
3708: END IF;
3709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3710: FND_MSG_PUB.ADD;
3711: RAISE FND_API.G_EXC_ERROR;
3712: END IF;
3713: END IF;
3714: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3715: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3851: WHEN FND_API.G_EXC_ERROR THEN

3847: END IF;
3848: EXCEPTION
3849: WHEN L_RETURN_IMM_EXC THEN
3850: RETURN;
3851: WHEN FND_API.G_EXC_ERROR THEN
3852: RAISE FND_API.G_EXC_ERROR;
3853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3855: WHEN OTHERS THEN

Line 3852: RAISE FND_API.G_EXC_ERROR;

3848: EXCEPTION
3849: WHEN L_RETURN_IMM_EXC THEN
3850: RETURN;
3851: WHEN FND_API.G_EXC_ERROR THEN
3852: RAISE FND_API.G_EXC_ERROR;
3853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3855: WHEN OTHERS THEN
3856: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3849: WHEN L_RETURN_IMM_EXC THEN
3850: RETURN;
3851: WHEN FND_API.G_EXC_ERROR THEN
3852: RAISE FND_API.G_EXC_ERROR;
3853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3855: WHEN OTHERS THEN
3856: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3857: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');

Line 3854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3850: RETURN;
3851: WHEN FND_API.G_EXC_ERROR THEN
3852: RAISE FND_API.G_EXC_ERROR;
3853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3855: WHEN OTHERS THEN
3856: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3857: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3856: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3857: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3859: FND_MSG_PUB.ADD;
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: END find_persons;
3862:
3863: PROCEDURE find_persons (
3864: p_rule_id IN NUMBER,

Line 3919: WHEN FND_API.G_EXC_ERROR THEN

3915: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3916: 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);
3917: END IF;
3918: EXCEPTION
3919: WHEN FND_API.G_EXC_ERROR THEN
3920: RAISE FND_API.G_EXC_ERROR;
3921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: WHEN OTHERS THEN

Line 3920: RAISE FND_API.G_EXC_ERROR;

3916: 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);
3917: END IF;
3918: EXCEPTION
3919: WHEN FND_API.G_EXC_ERROR THEN
3920: RAISE FND_API.G_EXC_ERROR;
3921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: WHEN OTHERS THEN
3924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3917: END IF;
3918: EXCEPTION
3919: WHEN FND_API.G_EXC_ERROR THEN
3920: RAISE FND_API.G_EXC_ERROR;
3921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: WHEN OTHERS THEN
3924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3925: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');

Line 3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3918: EXCEPTION
3919: WHEN FND_API.G_EXC_ERROR THEN
3920: RAISE FND_API.G_EXC_ERROR;
3921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: WHEN OTHERS THEN
3924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3925: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3925: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3929: END find_party_details;
3930:
3931: PROCEDURE find_duplicate_parties (
3932: p_rule_id IN NUMBER,

Line 4036: WHEN FND_API.G_EXC_ERROR THEN

4032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4033: 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);
4034: END IF;
4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN

Line 4037: RAISE FND_API.G_EXC_ERROR;

4033: 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);
4034: END IF;
4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4034: END IF;
4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');

Line 4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4046: END find_duplicate_parties;
4047:
4048: PROCEDURE find_duplicate_party_sites (
4049: p_rule_id IN NUMBER,

Line 4121: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4122: RAISE FND_API.G_EXC_ERROR;

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

Line 4123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4210: WHEN FND_API.G_EXC_ERROR THEN

4206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4207: 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);
4208: END IF;
4209: EXCEPTION
4210: WHEN FND_API.G_EXC_ERROR THEN
4211: RAISE FND_API.G_EXC_ERROR;
4212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4214: WHEN OTHERS THEN

Line 4211: RAISE FND_API.G_EXC_ERROR;

4207: 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);
4208: END IF;
4209: EXCEPTION
4210: WHEN FND_API.G_EXC_ERROR THEN
4211: RAISE FND_API.G_EXC_ERROR;
4212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4214: WHEN OTHERS THEN
4215: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4208: END IF;
4209: EXCEPTION
4210: WHEN FND_API.G_EXC_ERROR THEN
4211: RAISE FND_API.G_EXC_ERROR;
4212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4214: WHEN OTHERS THEN
4215: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4216: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');

Line 4213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4209: EXCEPTION
4210: WHEN FND_API.G_EXC_ERROR THEN
4211: RAISE FND_API.G_EXC_ERROR;
4212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4214: WHEN OTHERS THEN
4215: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4216: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4217: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4215: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4216: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4217: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4218: FND_MSG_PUB.ADD;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: END find_duplicate_contacts;
4221:
4222: PROCEDURE find_duplicate_contact_points (
4223: p_rule_id IN NUMBER,

Line 4283: WHEN FND_API.G_EXC_ERROR THEN

4279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4280: 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);
4281: END IF;
4282: EXCEPTION
4283: WHEN FND_API.G_EXC_ERROR THEN
4284: RAISE FND_API.G_EXC_ERROR;
4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN

Line 4284: RAISE FND_API.G_EXC_ERROR;

4280: 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);
4281: END IF;
4282: EXCEPTION
4283: WHEN FND_API.G_EXC_ERROR THEN
4284: RAISE FND_API.G_EXC_ERROR;
4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4281: END IF;
4282: EXCEPTION
4283: WHEN FND_API.G_EXC_ERROR THEN
4284: RAISE FND_API.G_EXC_ERROR;
4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');

Line 4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4282: EXCEPTION
4283: WHEN FND_API.G_EXC_ERROR THEN
4284: RAISE FND_API.G_EXC_ERROR;
4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END find_duplicate_contact_points;
4294:
4295: PROCEDURE find_parties_dynamic (
4296: p_rule_id IN NUMBER,

Line 4591: WHEN FND_API.G_EXC_ERROR THEN

4587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4588: 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);
4589: END IF;
4590: EXCEPTION
4591: WHEN FND_API.G_EXC_ERROR THEN
4592: RAISE FND_API.G_EXC_ERROR;
4593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4595: WHEN OTHERS THEN

Line 4592: RAISE FND_API.G_EXC_ERROR;

4588: 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);
4589: END IF;
4590: EXCEPTION
4591: WHEN FND_API.G_EXC_ERROR THEN
4592: RAISE FND_API.G_EXC_ERROR;
4593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4595: WHEN OTHERS THEN
4596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4589: END IF;
4590: EXCEPTION
4591: WHEN FND_API.G_EXC_ERROR THEN
4592: RAISE FND_API.G_EXC_ERROR;
4593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4595: WHEN OTHERS THEN
4596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');

Line 4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4590: EXCEPTION
4591: WHEN FND_API.G_EXC_ERROR THEN
4592: RAISE FND_API.G_EXC_ERROR;
4593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4595: WHEN OTHERS THEN
4596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4599: FND_MSG_PUB.ADD;
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: END call_api_dynamic;
4602:
4603:
4604: PROCEDURE get_matching_party_sites (

Line 4829: WHEN FND_API.G_EXC_ERROR THEN

4825: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4826: 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);
4827: END IF;
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: RAISE FND_API.G_EXC_ERROR;
4831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: WHEN OTHERS THEN

Line 4830: RAISE FND_API.G_EXC_ERROR;

4826: 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);
4827: END IF;
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: RAISE FND_API.G_EXC_ERROR;
4831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: WHEN OTHERS THEN
4834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4827: END IF;
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: RAISE FND_API.G_EXC_ERROR;
4831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: WHEN OTHERS THEN
4834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4835: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');

Line 4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: RAISE FND_API.G_EXC_ERROR;
4831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: WHEN OTHERS THEN
4834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4835: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4835: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4837: FND_MSG_PUB.ADD;
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4839: END get_matching_party_sites;
4840:
4841:
4842: PROCEDURE get_matching_contacts (

Line 5057: WHEN FND_API.G_EXC_ERROR THEN

5053: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5054: 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);
5055: END IF;
5056: EXCEPTION
5057: WHEN FND_API.G_EXC_ERROR THEN
5058: RAISE FND_API.G_EXC_ERROR;
5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN

Line 5058: RAISE FND_API.G_EXC_ERROR;

5054: 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);
5055: END IF;
5056: EXCEPTION
5057: WHEN FND_API.G_EXC_ERROR THEN
5058: RAISE FND_API.G_EXC_ERROR;
5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5055: END IF;
5056: EXCEPTION
5057: WHEN FND_API.G_EXC_ERROR THEN
5058: RAISE FND_API.G_EXC_ERROR;
5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');

Line 5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5056: EXCEPTION
5057: WHEN FND_API.G_EXC_ERROR THEN
5058: RAISE FND_API.G_EXC_ERROR;
5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END get_matching_contacts;
5068:
5069:
5070: PROCEDURE get_matching_contact_points (

Line 5199: WHEN FND_API.G_EXC_ERROR THEN

5195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5196: 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);
5197: END IF;
5198: EXCEPTION
5199: WHEN FND_API.G_EXC_ERROR THEN
5200: RAISE FND_API.G_EXC_ERROR;
5201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: WHEN OTHERS THEN

Line 5200: RAISE FND_API.G_EXC_ERROR;

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

Line 5201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5197: END IF;
5198: EXCEPTION
5199: WHEN FND_API.G_EXC_ERROR THEN
5200: RAISE FND_API.G_EXC_ERROR;
5201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: WHEN OTHERS THEN
5204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5205: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');

Line 5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5198: EXCEPTION
5199: WHEN FND_API.G_EXC_ERROR THEN
5200: RAISE FND_API.G_EXC_ERROR;
5201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: WHEN OTHERS THEN
5204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5205: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5205: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5207: FND_MSG_PUB.ADD;
5208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5209: END get_matching_contact_points;
5210:
5211: /**********************************************************
5212: This procedure finds the score details for a specific party that

Line 5412: WHEN FND_API.G_EXC_ERROR THEN

5408: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5409: 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);
5410: END IF;
5411: EXCEPTION
5412: WHEN FND_API.G_EXC_ERROR THEN
5413: RAISE FND_API.G_EXC_ERROR;
5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN

Line 5413: RAISE FND_API.G_EXC_ERROR;

5409: 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);
5410: END IF;
5411: EXCEPTION
5412: WHEN FND_API.G_EXC_ERROR THEN
5413: RAISE FND_API.G_EXC_ERROR;
5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5522: WHEN FND_API.G_EXC_ERROR THEN

5518: END LOOP;
5519: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5520: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5521: EXCEPTION
5522: WHEN FND_API.G_EXC_ERROR THEN
5523: RAISE FND_API.G_EXC_ERROR;
5524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: WHEN OTHERS THEN

Line 5523: RAISE FND_API.G_EXC_ERROR;

5519: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5520: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5521: EXCEPTION
5522: WHEN FND_API.G_EXC_ERROR THEN
5523: RAISE FND_API.G_EXC_ERROR;
5524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: WHEN OTHERS THEN
5527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5520: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5521: EXCEPTION
5522: WHEN FND_API.G_EXC_ERROR THEN
5523: RAISE FND_API.G_EXC_ERROR;
5524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: WHEN OTHERS THEN
5527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5528: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5521: EXCEPTION
5522: WHEN FND_API.G_EXC_ERROR THEN
5523: RAISE FND_API.G_EXC_ERROR;
5524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: WHEN OTHERS THEN
5527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5528: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5528: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5532: END get_party_for_search;
5533:
5534: PROCEDURE get_search_criteria (
5535: p_party_id IN NUMBER,

Line 5568: WHEN FND_API.G_EXC_ERROR THEN

5564: END IF;
5565: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5566: END IF;
5567: EXCEPTION
5568: WHEN FND_API.G_EXC_ERROR THEN
5569: RAISE FND_API.G_EXC_ERROR;
5570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5572: WHEN OTHERS THEN

Line 5569: RAISE FND_API.G_EXC_ERROR;

5565: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5566: END IF;
5567: EXCEPTION
5568: WHEN FND_API.G_EXC_ERROR THEN
5569: RAISE FND_API.G_EXC_ERROR;
5570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5572: WHEN OTHERS THEN
5573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5566: END IF;
5567: EXCEPTION
5568: WHEN FND_API.G_EXC_ERROR THEN
5569: RAISE FND_API.G_EXC_ERROR;
5570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5572: WHEN OTHERS THEN
5573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5574: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5567: EXCEPTION
5568: WHEN FND_API.G_EXC_ERROR THEN
5569: RAISE FND_API.G_EXC_ERROR;
5570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5572: WHEN OTHERS THEN
5573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5574: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5575: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5574: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5575: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5576: FND_MSG_PUB.ADD;
5577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5578: END get_search_criteria;
5579:
5580:
5581: /************************************************

Line 5638: RAISE FND_API.G_EXC_ERROR;

5634: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5635: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5637: FND_MSG_PUB.ADD;
5638: RAISE FND_API.G_EXC_ERROR;
5639: END get_party_rec;
5640:
5641: /************************************************
5642: This procedure retrieves the match rule party site attributes into

Line 5694: RAISE FND_API.G_EXC_ERROR;

5690: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5691: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5692: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5693: FND_MSG_PUB.ADD;
5694: RAISE FND_API.G_EXC_ERROR;
5695: END get_party_site_rec;
5696:
5697: /************************************************
5698: This procedure retrieves the match rule contact attributes into

Line 5750: RAISE FND_API.G_EXC_ERROR;

5746: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5747: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5748: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5749: FND_MSG_PUB.ADD;
5750: RAISE FND_API.G_EXC_ERROR;
5751: END get_contact_rec;
5752:
5753: /************************************************
5754: This procedure retrieves the match rule contact point attributes into

Line 5806: RAISE FND_API.G_EXC_ERROR;

5802: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5803: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;
5807: END get_contact_point_rec;
5808:
5809: /************************************************
5810: This procedure maps a search record from the logical

Line 5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5937: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: END;
5943:
5944:
5945: /************************************************

Line 6059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6055: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6056: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6060: END;
6061:
6062:
6063: /************************************************

Line 6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6097: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6099: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6100: FND_MSG_PUB.ADD;
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: END;
6103:
6104:
6105: /************************************************

Line 6208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6204: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6205: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6207: FND_MSG_PUB.ADD;
6208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6209: END;
6210:
6211:
6212: /************************************************

Line 6232: RAISE FND_API.G_EXC_ERROR;

6228: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6229: ) THEN
6230: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6231: FND_MSG_PUB.ADD;
6232: RAISE FND_API.G_EXC_ERROR;
6233: END IF;
6234: END LOOP;
6235:
6236: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 6259: WHEN FND_API.G_EXC_ERROR THEN

6255: END IF;
6256: END LOOP;
6257: RETURN FALSE;
6258: EXCEPTION
6259: WHEN FND_API.G_EXC_ERROR THEN
6260: RAISE FND_API.G_EXC_ERROR;
6261: WHEN OTHERS THEN
6262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6263: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6260: RAISE FND_API.G_EXC_ERROR;

6256: END LOOP;
6257: RETURN FALSE;
6258: EXCEPTION
6259: WHEN FND_API.G_EXC_ERROR THEN
6260: RAISE FND_API.G_EXC_ERROR;
6261: WHEN OTHERS THEN
6262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6263: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6263: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6265: FND_MSG_PUB.ADD;
6266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6267: END check_prim_cond;
6268:
6269: /************************************************
6270: This procedure checks if the input search condition

Line 6321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6317: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6318: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6320: FND_MSG_PUB.ADD;
6321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6322: END check_party_site_cond;
6323:
6324: /************************************************
6325: This procedure checks if the input search condition

Line 6368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6365: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6367: FND_MSG_PUB.ADD;
6368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6369: END check_contact_cond;
6370:
6371: /************************************************
6372: This procedure checks if the input search condition

Line 6389: RAISE FND_API.G_EXC_ERROR;

6385: FOR I IN 1..p_contact_point_list.COUNT LOOP
6386: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6387: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6388: FND_MSG_PUB.ADD;
6389: RAISE FND_API.G_EXC_ERROR;
6390: END IF;
6391: END LOOP;
6392:
6393: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6411: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6412: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6413: FND_MSG_PUB.ADD;
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415: END check_contact_point_cond;
6416:
6417: FUNCTION check_staged RETURN BOOLEAN IS
6418: