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

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

Line 1397: RAISE FND_API.G_EXC_ERROR;

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

Line 1401: RAISE FND_API.G_EXC_ERROR;

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

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1638: RAISE FND_API.G_EXC_ERROR;

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

Line 1642: RAISE FND_API.G_EXC_ERROR;

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

Line 1646: RAISE FND_API.G_EXC_ERROR;

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

Line 1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1785: RAISE FND_API.G_EXC_ERROR;

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

Line 1789: RAISE FND_API.G_EXC_ERROR;

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

Line 1793: RAISE FND_API.G_EXC_ERROR;

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

Line 1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2058: RAISE FND_API.G_EXC_ERROR;

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

Line 2062: RAISE FND_API.G_EXC_ERROR;

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

Line 2066: RAISE FND_API.G_EXC_ERROR;

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

Line 2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2323: RAISE FND_API.G_EXC_ERROR;

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

Line 2371: RAISE FND_API.G_EXC_ERROR;

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

Line 2444: RAISE FND_API.G_EXC_ERROR;

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

Line 2556: RAISE FND_API.G_EXC_ERROR;

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

Line 2667: RAISE FND_API.G_EXC_ERROR;

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

Line 2811: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3061: WHEN FND_API.G_EXC_ERROR THEN

3057: END IF;
3058: EXCEPTION
3059: WHEN L_RETURN_IMM_EXC THEN
3060: RETURN;
3061: WHEN FND_API.G_EXC_ERROR THEN
3062: RAISE FND_API.G_EXC_ERROR;
3063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3065: WHEN OTHERS THEN

Line 3062: RAISE FND_API.G_EXC_ERROR;

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

Line 3063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3262: RAISE FND_API.G_EXC_ERROR;

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

Line 3310: RAISE FND_API.G_EXC_ERROR;

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

Line 3346: RAISE FND_API.G_EXC_ERROR;

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

Line 3350: RAISE FND_API.G_EXC_ERROR;

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

Line 3352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3422: RAISE FND_API.G_EXC_ERROR;

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

Line 3611: RAISE FND_API.G_EXC_ERROR;

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

Line 3699: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3847: WHEN FND_API.G_EXC_ERROR THEN

3843: END IF;
3844: EXCEPTION
3845: WHEN L_RETURN_IMM_EXC THEN
3846: RETURN;
3847: WHEN FND_API.G_EXC_ERROR THEN
3848: RAISE FND_API.G_EXC_ERROR;
3849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3851: WHEN OTHERS THEN

Line 3848: RAISE FND_API.G_EXC_ERROR;

3844: EXCEPTION
3845: WHEN L_RETURN_IMM_EXC THEN
3846: RETURN;
3847: WHEN FND_API.G_EXC_ERROR THEN
3848: RAISE FND_API.G_EXC_ERROR;
3849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3851: WHEN OTHERS THEN
3852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3845: WHEN L_RETURN_IMM_EXC THEN
3846: RETURN;
3847: WHEN FND_API.G_EXC_ERROR THEN
3848: RAISE FND_API.G_EXC_ERROR;
3849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3851: WHEN OTHERS THEN
3852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');

Line 3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3846: RETURN;
3847: WHEN FND_API.G_EXC_ERROR THEN
3848: RAISE FND_API.G_EXC_ERROR;
3849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3851: WHEN OTHERS THEN
3852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3915: WHEN FND_API.G_EXC_ERROR THEN

3911: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3912: 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);
3913: END IF;
3914: EXCEPTION
3915: WHEN FND_API.G_EXC_ERROR THEN
3916: RAISE FND_API.G_EXC_ERROR;
3917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3919: WHEN OTHERS THEN

Line 3916: RAISE FND_API.G_EXC_ERROR;

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

Line 3917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3913: END IF;
3914: EXCEPTION
3915: WHEN FND_API.G_EXC_ERROR THEN
3916: RAISE FND_API.G_EXC_ERROR;
3917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3919: WHEN OTHERS THEN
3920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3921: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');

Line 3918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3914: EXCEPTION
3915: WHEN FND_API.G_EXC_ERROR THEN
3916: RAISE FND_API.G_EXC_ERROR;
3917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3919: WHEN OTHERS THEN
3920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3921: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4032: WHEN FND_API.G_EXC_ERROR THEN

4028: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4029: 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);
4030: END IF;
4031: EXCEPTION
4032: WHEN FND_API.G_EXC_ERROR THEN
4033: RAISE FND_API.G_EXC_ERROR;
4034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: WHEN OTHERS THEN

Line 4033: RAISE FND_API.G_EXC_ERROR;

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

Line 4034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4030: END IF;
4031: EXCEPTION
4032: WHEN FND_API.G_EXC_ERROR THEN
4033: RAISE FND_API.G_EXC_ERROR;
4034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: WHEN OTHERS THEN
4037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');

Line 4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4031: EXCEPTION
4032: WHEN FND_API.G_EXC_ERROR THEN
4033: RAISE FND_API.G_EXC_ERROR;
4034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: WHEN OTHERS THEN
4037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4117: WHEN FND_API.G_EXC_ERROR THEN

4113: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4114: 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);
4115: END IF;
4116: EXCEPTION
4117: WHEN FND_API.G_EXC_ERROR THEN
4118: RAISE FND_API.G_EXC_ERROR;
4119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4121: WHEN OTHERS THEN

Line 4118: RAISE FND_API.G_EXC_ERROR;

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

Line 4119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4115: END IF;
4116: EXCEPTION
4117: WHEN FND_API.G_EXC_ERROR THEN
4118: RAISE FND_API.G_EXC_ERROR;
4119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4121: WHEN OTHERS THEN
4122: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4123: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');

Line 4120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4116: EXCEPTION
4117: WHEN FND_API.G_EXC_ERROR THEN
4118: RAISE FND_API.G_EXC_ERROR;
4119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4121: WHEN OTHERS THEN
4122: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4123: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');
4124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4206: WHEN FND_API.G_EXC_ERROR THEN

4202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4203: 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);
4204: END IF;
4205: EXCEPTION
4206: WHEN FND_API.G_EXC_ERROR THEN
4207: RAISE FND_API.G_EXC_ERROR;
4208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: WHEN OTHERS THEN

Line 4207: RAISE FND_API.G_EXC_ERROR;

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

Line 4208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4204: END IF;
4205: EXCEPTION
4206: WHEN FND_API.G_EXC_ERROR THEN
4207: RAISE FND_API.G_EXC_ERROR;
4208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: WHEN OTHERS THEN
4211: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4212: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');

Line 4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4205: EXCEPTION
4206: WHEN FND_API.G_EXC_ERROR THEN
4207: RAISE FND_API.G_EXC_ERROR;
4208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: WHEN OTHERS THEN
4211: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4212: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4279: WHEN FND_API.G_EXC_ERROR THEN

4275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4276: 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);
4277: END IF;
4278: EXCEPTION
4279: WHEN FND_API.G_EXC_ERROR THEN
4280: RAISE FND_API.G_EXC_ERROR;
4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4283: WHEN OTHERS THEN

Line 4280: RAISE FND_API.G_EXC_ERROR;

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

Line 4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4277: END IF;
4278: EXCEPTION
4279: WHEN FND_API.G_EXC_ERROR THEN
4280: RAISE FND_API.G_EXC_ERROR;
4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4283: WHEN OTHERS THEN
4284: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4285: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');

Line 4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4278: EXCEPTION
4279: WHEN FND_API.G_EXC_ERROR THEN
4280: RAISE FND_API.G_EXC_ERROR;
4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4283: WHEN OTHERS THEN
4284: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4285: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4286: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4587: WHEN FND_API.G_EXC_ERROR THEN

4583: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4584: 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);
4585: END IF;
4586: EXCEPTION
4587: WHEN FND_API.G_EXC_ERROR THEN
4588: RAISE FND_API.G_EXC_ERROR;
4589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4591: WHEN OTHERS THEN

Line 4588: RAISE FND_API.G_EXC_ERROR;

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

Line 4589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4585: END IF;
4586: EXCEPTION
4587: WHEN FND_API.G_EXC_ERROR THEN
4588: RAISE FND_API.G_EXC_ERROR;
4589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4591: WHEN OTHERS THEN
4592: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4593: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');

Line 4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4586: EXCEPTION
4587: WHEN FND_API.G_EXC_ERROR THEN
4588: RAISE FND_API.G_EXC_ERROR;
4589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4591: WHEN OTHERS THEN
4592: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4593: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4594: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4592: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4593: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4594: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4595: FND_MSG_PUB.ADD;
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: END call_api_dynamic;
4598:
4599:
4600: PROCEDURE get_matching_party_sites (

Line 4825: WHEN FND_API.G_EXC_ERROR THEN

4821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4822: 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);
4823: END IF;
4824: EXCEPTION
4825: WHEN FND_API.G_EXC_ERROR THEN
4826: RAISE FND_API.G_EXC_ERROR;
4827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4829: WHEN OTHERS THEN

Line 4826: RAISE FND_API.G_EXC_ERROR;

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

Line 4827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4823: END IF;
4824: EXCEPTION
4825: WHEN FND_API.G_EXC_ERROR THEN
4826: RAISE FND_API.G_EXC_ERROR;
4827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4829: WHEN OTHERS THEN
4830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');

Line 4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4824: EXCEPTION
4825: WHEN FND_API.G_EXC_ERROR THEN
4826: RAISE FND_API.G_EXC_ERROR;
4827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4829: WHEN OTHERS THEN
4830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4833: FND_MSG_PUB.ADD;
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4835: END get_matching_party_sites;
4836:
4837:
4838: PROCEDURE get_matching_contacts (

Line 5053: WHEN FND_API.G_EXC_ERROR THEN

5049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5050: 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);
5051: END IF;
5052: EXCEPTION
5053: WHEN FND_API.G_EXC_ERROR THEN
5054: RAISE FND_API.G_EXC_ERROR;
5055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5057: WHEN OTHERS THEN

Line 5054: RAISE FND_API.G_EXC_ERROR;

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

Line 5055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5051: END IF;
5052: EXCEPTION
5053: WHEN FND_API.G_EXC_ERROR THEN
5054: RAISE FND_API.G_EXC_ERROR;
5055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5059: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');

Line 5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5052: EXCEPTION
5053: WHEN FND_API.G_EXC_ERROR THEN
5054: RAISE FND_API.G_EXC_ERROR;
5055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5059: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5059: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5061: FND_MSG_PUB.ADD;
5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5063: END get_matching_contacts;
5064:
5065:
5066: PROCEDURE get_matching_contact_points (

Line 5195: WHEN FND_API.G_EXC_ERROR THEN

5191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5192: 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);
5193: END IF;
5194: EXCEPTION
5195: WHEN FND_API.G_EXC_ERROR THEN
5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN

Line 5196: RAISE FND_API.G_EXC_ERROR;

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

Line 5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5193: END IF;
5194: EXCEPTION
5195: WHEN FND_API.G_EXC_ERROR THEN
5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');

Line 5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5194: EXCEPTION
5195: WHEN FND_API.G_EXC_ERROR THEN
5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5407: WHEN FND_API.G_EXC_ERROR THEN

5403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5404: 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);
5405: END IF;
5406: EXCEPTION
5407: WHEN FND_API.G_EXC_ERROR THEN
5408: RAISE FND_API.G_EXC_ERROR;
5409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5411: WHEN OTHERS THEN

Line 5408: RAISE FND_API.G_EXC_ERROR;

5404: 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);
5405: END IF;
5406: EXCEPTION
5407: WHEN FND_API.G_EXC_ERROR THEN
5408: RAISE FND_API.G_EXC_ERROR;
5409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5411: WHEN OTHERS THEN
5412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5405: END IF;
5406: EXCEPTION
5407: WHEN FND_API.G_EXC_ERROR THEN
5408: RAISE FND_API.G_EXC_ERROR;
5409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5411: WHEN OTHERS THEN
5412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');

Line 5410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5406: EXCEPTION
5407: WHEN FND_API.G_EXC_ERROR THEN
5408: RAISE FND_API.G_EXC_ERROR;
5409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5411: WHEN OTHERS THEN
5412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5415: FND_MSG_PUB.ADD;
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417: END get_score_details;
5418:
5419:
5420: /************************************************

Line 5517: WHEN FND_API.G_EXC_ERROR THEN

5513: END LOOP;
5514: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5515: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5516: EXCEPTION
5517: WHEN FND_API.G_EXC_ERROR THEN
5518: RAISE FND_API.G_EXC_ERROR;
5519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5521: WHEN OTHERS THEN

Line 5518: RAISE FND_API.G_EXC_ERROR;

5514: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5515: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5516: EXCEPTION
5517: WHEN FND_API.G_EXC_ERROR THEN
5518: RAISE FND_API.G_EXC_ERROR;
5519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5521: WHEN OTHERS THEN
5522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5515: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5516: EXCEPTION
5517: WHEN FND_API.G_EXC_ERROR THEN
5518: RAISE FND_API.G_EXC_ERROR;
5519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5521: WHEN OTHERS THEN
5522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5523: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5516: EXCEPTION
5517: WHEN FND_API.G_EXC_ERROR THEN
5518: RAISE FND_API.G_EXC_ERROR;
5519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5521: WHEN OTHERS THEN
5522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5523: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5523: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5525: FND_MSG_PUB.ADD;
5526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5527: END get_party_for_search;
5528:
5529: PROCEDURE get_search_criteria (
5530: p_party_id IN NUMBER,

Line 5563: WHEN FND_API.G_EXC_ERROR THEN

5559: END IF;
5560: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5561: END IF;
5562: EXCEPTION
5563: WHEN FND_API.G_EXC_ERROR THEN
5564: RAISE FND_API.G_EXC_ERROR;
5565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5567: WHEN OTHERS THEN

Line 5564: RAISE FND_API.G_EXC_ERROR;

5560: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5561: END IF;
5562: EXCEPTION
5563: WHEN FND_API.G_EXC_ERROR THEN
5564: RAISE FND_API.G_EXC_ERROR;
5565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5567: WHEN OTHERS THEN
5568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5561: END IF;
5562: EXCEPTION
5563: WHEN FND_API.G_EXC_ERROR THEN
5564: RAISE FND_API.G_EXC_ERROR;
5565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5567: WHEN OTHERS THEN
5568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5569: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5562: EXCEPTION
5563: WHEN FND_API.G_EXC_ERROR THEN
5564: RAISE FND_API.G_EXC_ERROR;
5565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5567: WHEN OTHERS THEN
5568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5569: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5569: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5571: FND_MSG_PUB.ADD;
5572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5573: END get_search_criteria;
5574:
5575:
5576: /************************************************

Line 5633: RAISE FND_API.G_EXC_ERROR;

5629: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5630: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_ERROR;
5634: END get_party_rec;
5635:
5636: /************************************************
5637: This procedure retrieves the match rule party site attributes into

Line 5689: RAISE FND_API.G_EXC_ERROR;

5685: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5686: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_ERROR;
5690: END get_party_site_rec;
5691:
5692: /************************************************
5693: This procedure retrieves the match rule contact attributes into

Line 5745: RAISE FND_API.G_EXC_ERROR;

5741: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5742: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5744: FND_MSG_PUB.ADD;
5745: RAISE FND_API.G_EXC_ERROR;
5746: END get_contact_rec;
5747:
5748: /************************************************
5749: This procedure retrieves the match rule contact point attributes into

Line 5801: RAISE FND_API.G_EXC_ERROR;

5797: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5798: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_ERROR;
5802: END get_contact_point_rec;
5803:
5804: /************************************************
5805: This procedure maps a search record from the logical

Line 5936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5932: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5933: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5935: FND_MSG_PUB.ADD;
5936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5937: END;
5938:
5939:
5940: /************************************************

Line 6054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6050: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6051: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6053: FND_MSG_PUB.ADD;
6054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6055: END;
6056:
6057:
6058: /************************************************

Line 6096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6092: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6094: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6095: FND_MSG_PUB.ADD;
6096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6097: END;
6098:
6099:
6100: /************************************************

Line 6203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6199: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6200: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6204: END;
6205:
6206:
6207: /************************************************

Line 6227: RAISE FND_API.G_EXC_ERROR;

6223: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6224: ) THEN
6225: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6226: FND_MSG_PUB.ADD;
6227: RAISE FND_API.G_EXC_ERROR;
6228: END IF;
6229: END LOOP;
6230:
6231: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 6254: WHEN FND_API.G_EXC_ERROR THEN

6250: END IF;
6251: END LOOP;
6252: RETURN FALSE;
6253: EXCEPTION
6254: WHEN FND_API.G_EXC_ERROR THEN
6255: RAISE FND_API.G_EXC_ERROR;
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6255: RAISE FND_API.G_EXC_ERROR;

6251: END LOOP;
6252: RETURN FALSE;
6253: EXCEPTION
6254: WHEN FND_API.G_EXC_ERROR THEN
6255: RAISE FND_API.G_EXC_ERROR;
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: END check_prim_cond;
6263:
6264: /************************************************
6265: This procedure checks if the input search condition

Line 6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6317: END check_party_site_cond;
6318:
6319: /************************************************
6320: This procedure checks if the input search condition

Line 6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6364: END check_contact_cond;
6365:
6366: /************************************************
6367: This procedure checks if the input search condition

Line 6384: RAISE FND_API.G_EXC_ERROR;

6380: FOR I IN 1..p_contact_point_list.COUNT LOOP
6381: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6382: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_ERROR;
6385: END IF;
6386: END LOOP;
6387:
6388: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6406: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6407: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6408: FND_MSG_PUB.ADD;
6409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6410: END check_contact_point_cond;
6411:
6412: FUNCTION check_staged RETURN BOOLEAN IS
6413: