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_99 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 883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

879: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
880: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
882: FND_MSG_PUB.ADD;
883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
884: END;
885:
886:
887: /************************************************

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
905: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
907: FND_MSG_PUB.ADD;
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END;
910:
911:
912: /************************************************

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
925: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END;
930:
931:
932: /************************************************

Line 948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

944: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
945: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
947: FND_MSG_PUB.ADD;
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END;
950:
951: PROCEDURE init_score_context (
952: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1015: RAISE FND_API.G_EXC_ERROR;

1011: p_contact_list,
1012: p_contact_point_list) THEN
1013: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1018: 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);
1019: END IF;

Line 1233: RAISE FND_API.G_EXC_ERROR;

1229: IF lengthb(l_party_contains_str) > 4000 THEN
1230: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1231: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1232: FND_MSG_PUB.ADD;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235: IF (p_match_str = ' AND ' OR p_party_max_score 1236: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1237: 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 1342: RAISE FND_API.G_EXC_ERROR;

1338: IF lengthb(l_contains_str) > 4000 THEN
1339: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1340: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1341: FND_MSG_PUB.ADD;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344: x_denorm_str := l_den_contains_str;
1345: RETURN l_contains_str;
1346: END;

Line 1389: RAISE FND_API.G_EXC_ERROR;

1385: IF lengthb(l_contains_str) > 4000 THEN
1386: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1387: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: END IF;
1391: x_denorm_str := l_den_contains_str;
1392: RETURN l_contains_str;
1393: END;

Line 1470: RAISE FND_API.G_EXC_ERROR;

1466: IF lengthb(l_contains_str) > 4000 THEN
1467: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1468: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1469: FND_MSG_PUB.ADD;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472: x_denorm_str := l_den_contains_str;
1473: RETURN l_contains_str;
1474: END;

Line 1718: RAISE FND_API.G_EXC_ERROR;

1714: when others then
1715: if (instrb(SQLERRM,'DRG-51030')>0) then
1716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1717: FND_MSG_PUB.ADD;
1718: RAISE FND_API.G_EXC_ERROR;
1719: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1721: FND_MSG_PUB.ADD;
1722: RAISE FND_API.G_EXC_ERROR;

Line 1722: RAISE FND_API.G_EXC_ERROR;

1718: RAISE FND_API.G_EXC_ERROR;
1719: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1721: FND_MSG_PUB.ADD;
1722: RAISE FND_API.G_EXC_ERROR;
1723: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1725: FND_MSG_PUB.ADD;
1726: RAISE FND_API.G_EXC_ERROR;

Line 1726: RAISE FND_API.G_EXC_ERROR;

1722: RAISE FND_API.G_EXC_ERROR;
1723: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1725: FND_MSG_PUB.ADD;
1726: RAISE FND_API.G_EXC_ERROR;
1727: else
1728: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1730: FND_MSG_PUB.ADD;

Line 1731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1727: else
1728: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1730: FND_MSG_PUB.ADD;
1731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1732: end if;
1733: END;
1734:
1735: PROCEDURE open_party_site_cursor(

Line 1963: RAISE FND_API.G_EXC_ERROR;

1959: when others then
1960: if (instrb(SQLERRM,'DRG-51030')>0) then
1961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1962: FND_MSG_PUB.ADD;
1963: RAISE FND_API.G_EXC_ERROR;
1964: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1966: FND_MSG_PUB.ADD;
1967: RAISE FND_API.G_EXC_ERROR;

Line 1967: RAISE FND_API.G_EXC_ERROR;

1963: RAISE FND_API.G_EXC_ERROR;
1964: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1966: FND_MSG_PUB.ADD;
1967: RAISE FND_API.G_EXC_ERROR;
1968: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1969: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1970: FND_MSG_PUB.ADD;
1971: RAISE FND_API.G_EXC_ERROR;

Line 1971: RAISE FND_API.G_EXC_ERROR;

1967: RAISE FND_API.G_EXC_ERROR;
1968: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1969: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1970: FND_MSG_PUB.ADD;
1971: RAISE FND_API.G_EXC_ERROR;
1972: else
1973: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1975: FND_MSG_PUB.ADD;

Line 1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1972: else
1973: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1975: FND_MSG_PUB.ADD;
1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1977: end if;
1978: END;
1979:
1980: PROCEDURE open_contact_cursor(

Line 2110: RAISE FND_API.G_EXC_ERROR;

2106: when others then
2107: if (instrb(SQLERRM,'DRG-51030')>0) then
2108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2109: FND_MSG_PUB.ADD;
2110: RAISE FND_API.G_EXC_ERROR;
2111: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2112: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2113: FND_MSG_PUB.ADD;
2114: RAISE FND_API.G_EXC_ERROR;

Line 2114: RAISE FND_API.G_EXC_ERROR;

2110: RAISE FND_API.G_EXC_ERROR;
2111: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2112: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2113: FND_MSG_PUB.ADD;
2114: RAISE FND_API.G_EXC_ERROR;
2115: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2116: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2117: FND_MSG_PUB.ADD;
2118: RAISE FND_API.G_EXC_ERROR;

Line 2118: RAISE FND_API.G_EXC_ERROR;

2114: RAISE FND_API.G_EXC_ERROR;
2115: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2116: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2117: FND_MSG_PUB.ADD;
2118: RAISE FND_API.G_EXC_ERROR;
2119: else
2120: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2121: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2122: FND_MSG_PUB.ADD;

Line 2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2119: else
2120: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2121: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2122: FND_MSG_PUB.ADD;
2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2124: end if;
2125: END;
2126:
2127: PROCEDURE open_contact_pt_cursor(

Line 2383: RAISE FND_API.G_EXC_ERROR;

2379: when others then
2380: if (instrb(SQLERRM,'DRG-51030')>0) then
2381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2382: FND_MSG_PUB.ADD;
2383: RAISE FND_API.G_EXC_ERROR;
2384: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2386: FND_MSG_PUB.ADD;
2387: RAISE FND_API.G_EXC_ERROR;

Line 2387: RAISE FND_API.G_EXC_ERROR;

2383: RAISE FND_API.G_EXC_ERROR;
2384: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2386: FND_MSG_PUB.ADD;
2387: RAISE FND_API.G_EXC_ERROR;
2388: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2389: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2390: FND_MSG_PUB.ADD;
2391: RAISE FND_API.G_EXC_ERROR;

Line 2391: RAISE FND_API.G_EXC_ERROR;

2387: RAISE FND_API.G_EXC_ERROR;
2388: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2389: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2390: FND_MSG_PUB.ADD;
2391: RAISE FND_API.G_EXC_ERROR;
2392: else
2393: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2395: FND_MSG_PUB.ADD;

Line 2396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2392: else
2393: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2395: FND_MSG_PUB.ADD;
2396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2397: end if;
2398: END;
2399:
2400:

Line 2655: RAISE FND_API.G_EXC_ERROR;

2651: 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);
2652: END IF;
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2654: FND_MSG_PUB.ADD;
2655: RAISE FND_API.G_EXC_ERROR;
2656: ELSE
2657: push_eval;
2658: RETURN;
2659: END IF;

Line 2703: RAISE FND_API.G_EXC_ERROR;

2699: 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);
2700: END IF;
2701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2702: FND_MSG_PUB.ADD;
2703: RAISE FND_API.G_EXC_ERROR;
2704: ELSE
2705: push_eval;
2706: RETURN;
2707: END IF;

Line 2776: RAISE FND_API.G_EXC_ERROR;

2772: 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);
2773: END IF;
2774: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2775: FND_MSG_PUB.ADD;
2776: RAISE FND_API.G_EXC_ERROR;
2777: ELSE
2778: push_eval;
2779: RETURN;
2780: END IF;

Line 2888: RAISE FND_API.G_EXC_ERROR;

2884: 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);
2885: END IF;
2886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2887: FND_MSG_PUB.ADD;
2888: RAISE FND_API.G_EXC_ERROR;
2889: ELSE
2890: push_eval;
2891: RETURN;
2892: END IF;

Line 2999: RAISE FND_API.G_EXC_ERROR;

2995: 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);
2996: END IF;
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2998: FND_MSG_PUB.ADD;
2999: RAISE FND_API.G_EXC_ERROR;
3000: ELSE
3001: push_eval;
3002: RETURN;
3003: END IF;

Line 3224: RAISE FND_API.G_EXC_ERROR;

3220: 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);
3221: END IF;
3222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3223: FND_MSG_PUB.ADD;
3224: RAISE FND_API.G_EXC_ERROR;
3225: END IF;
3226: ELSE
3227: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3228: 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 3232: RAISE FND_API.G_EXC_ERROR;

3228: 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);
3229: END IF;
3230: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3231: FND_MSG_PUB.ADD;
3232: RAISE FND_API.G_EXC_ERROR;
3233: END IF;
3234: END IF;
3235: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3236: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3431: WHEN FND_API.G_EXC_ERROR THEN

3427: END IF;
3428: EXCEPTION
3429: WHEN L_RETURN_IMM_EXC THEN
3430: RETURN;
3431: WHEN FND_API.G_EXC_ERROR THEN
3432: RAISE FND_API.G_EXC_ERROR;
3433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3435: WHEN OTHERS THEN

Line 3432: RAISE FND_API.G_EXC_ERROR;

3428: EXCEPTION
3429: WHEN L_RETURN_IMM_EXC THEN
3430: RETURN;
3431: WHEN FND_API.G_EXC_ERROR THEN
3432: RAISE FND_API.G_EXC_ERROR;
3433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3435: WHEN OTHERS THEN
3436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3429: WHEN L_RETURN_IMM_EXC THEN
3430: RETURN;
3431: WHEN FND_API.G_EXC_ERROR THEN
3432: RAISE FND_API.G_EXC_ERROR;
3433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3435: WHEN OTHERS THEN
3436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_parties');

Line 3434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3430: RETURN;
3431: WHEN FND_API.G_EXC_ERROR THEN
3432: RAISE FND_API.G_EXC_ERROR;
3433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3435: WHEN OTHERS THEN
3436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_parties');
3438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_parties');
3438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3439: FND_MSG_PUB.ADD;
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: END find_parties;
3442:
3443: PROCEDURE find_persons (
3444: p_rule_id IN NUMBER,

Line 3639: RAISE FND_API.G_EXC_ERROR;

3635: 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);
3636: END IF;
3637: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3638: FND_MSG_PUB.ADD;
3639: RAISE FND_API.G_EXC_ERROR;
3640: ELSE
3641: push_eval;
3642: RETURN;
3643: END IF;

Line 3687: RAISE FND_API.G_EXC_ERROR;

3683: 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);
3684: END IF;
3685: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3686: FND_MSG_PUB.ADD;
3687: RAISE FND_API.G_EXC_ERROR;
3688: ELSE
3689: push_eval;
3690: RETURN;
3691: END IF;

Line 3723: RAISE FND_API.G_EXC_ERROR;

3719: when others then
3720: if (instrb(SQLERRM,'DRG-51030')>0) then
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;

Line 3727: RAISE FND_API.G_EXC_ERROR;

3723: RAISE FND_API.G_EXC_ERROR;
3724: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: else
3729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3730: end if;
3731: END;

Line 3729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: else
3729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3730: end if;
3731: END;
3732:
3733: /** Private procedure to acquire and score at party site level ***/

Line 3799: RAISE FND_API.G_EXC_ERROR;

3795: 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);
3796: END IF;
3797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3798: FND_MSG_PUB.ADD;
3799: RAISE FND_API.G_EXC_ERROR;
3800: ELSE
3801: push_eval;
3802: RETURN;
3803: END IF;

Line 4058: RAISE FND_API.G_EXC_ERROR;

4054: 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);
4055: END IF;
4056: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4057: FND_MSG_PUB.ADD;
4058: RAISE FND_API.G_EXC_ERROR;
4059: ELSE
4060: push_eval;
4061: RETURN;
4062: END IF;

Line 4171: RAISE FND_API.G_EXC_ERROR;

4167: 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);
4168: END IF;
4169: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4170: FND_MSG_PUB.ADD;
4171: RAISE FND_API.G_EXC_ERROR;
4172: END IF;
4173: ELSE
4174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4175: 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 4179: RAISE FND_API.G_EXC_ERROR;

4175: 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);
4176: END IF;
4177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4178: FND_MSG_PUB.ADD;
4179: RAISE FND_API.G_EXC_ERROR;
4180: END IF;
4181: END IF;
4182: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4183: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4293: WHEN FND_API.G_EXC_ERROR THEN

4289: END IF;
4290: EXCEPTION
4291: WHEN L_RETURN_IMM_EXC THEN
4292: RETURN;
4293: WHEN FND_API.G_EXC_ERROR THEN
4294: RAISE FND_API.G_EXC_ERROR;
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: WHEN OTHERS THEN

Line 4294: RAISE FND_API.G_EXC_ERROR;

4290: EXCEPTION
4291: WHEN L_RETURN_IMM_EXC THEN
4292: RETURN;
4293: WHEN FND_API.G_EXC_ERROR THEN
4294: RAISE FND_API.G_EXC_ERROR;
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: WHEN OTHERS THEN
4298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4291: WHEN L_RETURN_IMM_EXC THEN
4292: RETURN;
4293: WHEN FND_API.G_EXC_ERROR THEN
4294: RAISE FND_API.G_EXC_ERROR;
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: WHEN OTHERS THEN
4298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4299: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');

Line 4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4292: RETURN;
4293: WHEN FND_API.G_EXC_ERROR THEN
4294: RAISE FND_API.G_EXC_ERROR;
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: WHEN OTHERS THEN
4298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4299: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');
4300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4299: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');
4300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4301: FND_MSG_PUB.ADD;
4302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4303: END find_persons;
4304:
4305: PROCEDURE find_persons (
4306: p_rule_id IN NUMBER,

Line 4361: WHEN FND_API.G_EXC_ERROR THEN

4357: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4358: 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);
4359: END IF;
4360: EXCEPTION
4361: WHEN FND_API.G_EXC_ERROR THEN
4362: RAISE FND_API.G_EXC_ERROR;
4363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: WHEN OTHERS THEN

Line 4362: RAISE FND_API.G_EXC_ERROR;

4358: 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);
4359: END IF;
4360: EXCEPTION
4361: WHEN FND_API.G_EXC_ERROR THEN
4362: RAISE FND_API.G_EXC_ERROR;
4363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: WHEN OTHERS THEN
4366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4359: END IF;
4360: EXCEPTION
4361: WHEN FND_API.G_EXC_ERROR THEN
4362: RAISE FND_API.G_EXC_ERROR;
4363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: WHEN OTHERS THEN
4366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4367: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_party_details');

Line 4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4360: EXCEPTION
4361: WHEN FND_API.G_EXC_ERROR THEN
4362: RAISE FND_API.G_EXC_ERROR;
4363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: WHEN OTHERS THEN
4366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4367: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_party_details');
4368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4367: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_party_details');
4368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4369: FND_MSG_PUB.ADD;
4370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4371: END find_party_details;
4372:
4373: PROCEDURE find_duplicate_parties (
4374: p_rule_id IN NUMBER,

Line 4478: WHEN FND_API.G_EXC_ERROR THEN

4474: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4475: 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);
4476: END IF;
4477: EXCEPTION
4478: WHEN FND_API.G_EXC_ERROR THEN
4479: RAISE FND_API.G_EXC_ERROR;
4480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: WHEN OTHERS THEN

Line 4479: RAISE FND_API.G_EXC_ERROR;

4475: 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);
4476: END IF;
4477: EXCEPTION
4478: WHEN FND_API.G_EXC_ERROR THEN
4479: RAISE FND_API.G_EXC_ERROR;
4480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: WHEN OTHERS THEN
4483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4476: END IF;
4477: EXCEPTION
4478: WHEN FND_API.G_EXC_ERROR THEN
4479: RAISE FND_API.G_EXC_ERROR;
4480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: WHEN OTHERS THEN
4483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');

Line 4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4477: EXCEPTION
4478: WHEN FND_API.G_EXC_ERROR THEN
4479: RAISE FND_API.G_EXC_ERROR;
4480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: WHEN OTHERS THEN
4483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');
4485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');
4485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4486: FND_MSG_PUB.ADD;
4487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4488: END find_duplicate_parties;
4489:
4490: PROCEDURE find_duplicate_party_sites (
4491: p_rule_id IN NUMBER,

Line 4563: WHEN FND_API.G_EXC_ERROR THEN

4559: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4560: 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);
4561: END IF;
4562: EXCEPTION
4563: WHEN FND_API.G_EXC_ERROR THEN
4564: RAISE FND_API.G_EXC_ERROR;
4565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: WHEN OTHERS THEN

Line 4564: RAISE FND_API.G_EXC_ERROR;

4560: 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);
4561: END IF;
4562: EXCEPTION
4563: WHEN FND_API.G_EXC_ERROR THEN
4564: RAISE FND_API.G_EXC_ERROR;
4565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: WHEN OTHERS THEN
4568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4561: END IF;
4562: EXCEPTION
4563: WHEN FND_API.G_EXC_ERROR THEN
4564: RAISE FND_API.G_EXC_ERROR;
4565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: WHEN OTHERS THEN
4568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4569: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');

Line 4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4562: EXCEPTION
4563: WHEN FND_API.G_EXC_ERROR THEN
4564: RAISE FND_API.G_EXC_ERROR;
4565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: WHEN OTHERS THEN
4568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4569: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');
4570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4569: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');
4570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4571: FND_MSG_PUB.ADD;
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: END find_duplicate_party_sites;
4574:
4575: PROCEDURE find_duplicate_contacts (
4576: p_rule_id IN NUMBER,

Line 4652: WHEN FND_API.G_EXC_ERROR THEN

4648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4649: 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);
4650: END IF;
4651: EXCEPTION
4652: WHEN FND_API.G_EXC_ERROR THEN
4653: RAISE FND_API.G_EXC_ERROR;
4654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: WHEN OTHERS THEN

Line 4653: RAISE FND_API.G_EXC_ERROR;

4649: 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);
4650: END IF;
4651: EXCEPTION
4652: WHEN FND_API.G_EXC_ERROR THEN
4653: RAISE FND_API.G_EXC_ERROR;
4654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: WHEN OTHERS THEN
4657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4650: END IF;
4651: EXCEPTION
4652: WHEN FND_API.G_EXC_ERROR THEN
4653: RAISE FND_API.G_EXC_ERROR;
4654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: WHEN OTHERS THEN
4657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4658: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');

Line 4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4651: EXCEPTION
4652: WHEN FND_API.G_EXC_ERROR THEN
4653: RAISE FND_API.G_EXC_ERROR;
4654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: WHEN OTHERS THEN
4657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4658: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');
4659: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4658: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');
4659: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4660: FND_MSG_PUB.ADD;
4661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4662: END find_duplicate_contacts;
4663:
4664: PROCEDURE find_duplicate_contact_points (
4665: p_rule_id IN NUMBER,

Line 4725: WHEN FND_API.G_EXC_ERROR THEN

4721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4722: 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);
4723: END IF;
4724: EXCEPTION
4725: WHEN FND_API.G_EXC_ERROR THEN
4726: RAISE FND_API.G_EXC_ERROR;
4727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: WHEN OTHERS THEN

Line 4726: RAISE FND_API.G_EXC_ERROR;

4722: 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);
4723: END IF;
4724: EXCEPTION
4725: WHEN FND_API.G_EXC_ERROR THEN
4726: RAISE FND_API.G_EXC_ERROR;
4727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: WHEN OTHERS THEN
4730: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4723: END IF;
4724: EXCEPTION
4725: WHEN FND_API.G_EXC_ERROR THEN
4726: RAISE FND_API.G_EXC_ERROR;
4727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: WHEN OTHERS THEN
4730: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4731: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');

Line 4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4724: EXCEPTION
4725: WHEN FND_API.G_EXC_ERROR THEN
4726: RAISE FND_API.G_EXC_ERROR;
4727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: WHEN OTHERS THEN
4730: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4731: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');
4732: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4730: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4731: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');
4732: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4733: FND_MSG_PUB.ADD;
4734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4735: END find_duplicate_contact_points;
4736:
4737: PROCEDURE find_parties_dynamic (
4738: p_rule_id IN NUMBER,

Line 5061: WHEN FND_API.G_EXC_ERROR THEN

5057: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5058: 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);
5059: END IF;
5060: EXCEPTION
5061: WHEN FND_API.G_EXC_ERROR THEN
5062: RAISE FND_API.G_EXC_ERROR;
5063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5065: WHEN OTHERS THEN

Line 5062: RAISE FND_API.G_EXC_ERROR;

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

Line 5063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5059: END IF;
5060: EXCEPTION
5061: WHEN FND_API.G_EXC_ERROR THEN
5062: RAISE FND_API.G_EXC_ERROR;
5063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5065: WHEN OTHERS THEN
5066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5067: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');

Line 5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5060: EXCEPTION
5061: WHEN FND_API.G_EXC_ERROR THEN
5062: RAISE FND_API.G_EXC_ERROR;
5063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5065: WHEN OTHERS THEN
5066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5067: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');
5068: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5067: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');
5068: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5069: FND_MSG_PUB.ADD;
5070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5071: END call_api_dynamic;
5072:
5073:
5074: PROCEDURE get_matching_party_sites (

Line 5306: WHEN FND_API.G_EXC_ERROR THEN

5302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5303: 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);
5304: END IF;
5305: EXCEPTION
5306: WHEN FND_API.G_EXC_ERROR THEN
5307: RAISE FND_API.G_EXC_ERROR;
5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: WHEN OTHERS THEN

Line 5307: RAISE FND_API.G_EXC_ERROR;

5303: 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);
5304: END IF;
5305: EXCEPTION
5306: WHEN FND_API.G_EXC_ERROR THEN
5307: RAISE FND_API.G_EXC_ERROR;
5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: WHEN OTHERS THEN
5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5304: END IF;
5305: EXCEPTION
5306: WHEN FND_API.G_EXC_ERROR THEN
5307: RAISE FND_API.G_EXC_ERROR;
5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: WHEN OTHERS THEN
5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5312: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');

Line 5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5305: EXCEPTION
5306: WHEN FND_API.G_EXC_ERROR THEN
5307: RAISE FND_API.G_EXC_ERROR;
5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: WHEN OTHERS THEN
5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5312: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5312: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5314: FND_MSG_PUB.ADD;
5315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5316: END get_matching_party_sites;
5317:
5318:
5319: PROCEDURE get_matching_contacts (

Line 5535: WHEN FND_API.G_EXC_ERROR THEN

5531: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5532: 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);
5533: END IF;
5534: EXCEPTION
5535: WHEN FND_API.G_EXC_ERROR THEN
5536: RAISE FND_API.G_EXC_ERROR;
5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN

Line 5536: RAISE FND_API.G_EXC_ERROR;

5532: 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);
5533: END IF;
5534: EXCEPTION
5535: WHEN FND_API.G_EXC_ERROR THEN
5536: RAISE FND_API.G_EXC_ERROR;
5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5533: END IF;
5534: EXCEPTION
5535: WHEN FND_API.G_EXC_ERROR THEN
5536: RAISE FND_API.G_EXC_ERROR;
5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');

Line 5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5534: EXCEPTION
5535: WHEN FND_API.G_EXC_ERROR THEN
5536: RAISE FND_API.G_EXC_ERROR;
5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_contacts;
5546:
5547:
5548: PROCEDURE get_matching_contact_points (

Line 5677: WHEN FND_API.G_EXC_ERROR THEN

5673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5674: 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);
5675: END IF;
5676: EXCEPTION
5677: WHEN FND_API.G_EXC_ERROR THEN
5678: RAISE FND_API.G_EXC_ERROR;
5679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5681: WHEN OTHERS THEN

Line 5678: RAISE FND_API.G_EXC_ERROR;

5674: 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);
5675: END IF;
5676: EXCEPTION
5677: WHEN FND_API.G_EXC_ERROR THEN
5678: RAISE FND_API.G_EXC_ERROR;
5679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5681: WHEN OTHERS THEN
5682: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5675: END IF;
5676: EXCEPTION
5677: WHEN FND_API.G_EXC_ERROR THEN
5678: RAISE FND_API.G_EXC_ERROR;
5679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5681: WHEN OTHERS THEN
5682: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5683: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');

Line 5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5676: EXCEPTION
5677: WHEN FND_API.G_EXC_ERROR THEN
5678: RAISE FND_API.G_EXC_ERROR;
5679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5681: WHEN OTHERS THEN
5682: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5683: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');
5684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5682: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5683: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');
5684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5685: FND_MSG_PUB.ADD;
5686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5687: END get_matching_contact_points;
5688:
5689: /**********************************************************
5690: This procedure finds the score details for a specific party that

Line 5910: WHEN FND_API.G_EXC_ERROR THEN

5906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5907: 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);
5908: END IF;
5909: EXCEPTION
5910: WHEN FND_API.G_EXC_ERROR THEN
5911: RAISE FND_API.G_EXC_ERROR;
5912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: WHEN OTHERS THEN

Line 5911: RAISE FND_API.G_EXC_ERROR;

5907: 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);
5908: END IF;
5909: EXCEPTION
5910: WHEN FND_API.G_EXC_ERROR THEN
5911: RAISE FND_API.G_EXC_ERROR;
5912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: WHEN OTHERS THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5908: END IF;
5909: EXCEPTION
5910: WHEN FND_API.G_EXC_ERROR THEN
5911: RAISE FND_API.G_EXC_ERROR;
5912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: WHEN OTHERS THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5916: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');

Line 5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5909: EXCEPTION
5910: WHEN FND_API.G_EXC_ERROR THEN
5911: RAISE FND_API.G_EXC_ERROR;
5912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: WHEN OTHERS THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5916: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5917: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5916: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5917: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5918: FND_MSG_PUB.ADD;
5919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5920: END get_score_details;
5921:
5922:
5923: /************************************************

Line 6033: WHEN FND_API.G_EXC_ERROR THEN

6029: END LOOP;
6030: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6031: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6032: EXCEPTION
6033: WHEN FND_API.G_EXC_ERROR THEN
6034: RAISE FND_API.G_EXC_ERROR;
6035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6037: WHEN OTHERS THEN

Line 6034: RAISE FND_API.G_EXC_ERROR;

6030: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6031: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6032: EXCEPTION
6033: WHEN FND_API.G_EXC_ERROR THEN
6034: RAISE FND_API.G_EXC_ERROR;
6035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6037: WHEN OTHERS THEN
6038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6031: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6032: EXCEPTION
6033: WHEN FND_API.G_EXC_ERROR THEN
6034: RAISE FND_API.G_EXC_ERROR;
6035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6037: WHEN OTHERS THEN
6038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6039: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6032: EXCEPTION
6033: WHEN FND_API.G_EXC_ERROR THEN
6034: RAISE FND_API.G_EXC_ERROR;
6035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6037: WHEN OTHERS THEN
6038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6039: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6039: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6041: FND_MSG_PUB.ADD;
6042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6043: END get_party_for_search;
6044:
6045: PROCEDURE get_search_criteria (
6046: p_party_id IN NUMBER,

Line 6085: WHEN FND_API.G_EXC_ERROR THEN

6081: END IF;
6082: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6083: END IF;
6084: EXCEPTION
6085: WHEN FND_API.G_EXC_ERROR THEN
6086: RAISE FND_API.G_EXC_ERROR;
6087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6089: WHEN OTHERS THEN

Line 6086: RAISE FND_API.G_EXC_ERROR;

6082: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6083: END IF;
6084: EXCEPTION
6085: WHEN FND_API.G_EXC_ERROR THEN
6086: RAISE FND_API.G_EXC_ERROR;
6087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6083: END IF;
6084: EXCEPTION
6085: WHEN FND_API.G_EXC_ERROR THEN
6086: RAISE FND_API.G_EXC_ERROR;
6087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6084: EXCEPTION
6085: WHEN FND_API.G_EXC_ERROR THEN
6086: RAISE FND_API.G_EXC_ERROR;
6087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END get_search_criteria;
6096:
6097:
6098: /************************************************

Line 6139: RAISE FND_API.G_EXC_ERROR;

6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END get_party_rec;
6141:
6142: /************************************************
6143: This procedure retrieves the match rule party site attributes into

Line 6203: RAISE FND_API.G_EXC_ERROR;

6199: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6200: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_ERROR;
6204: END get_party_site_rec;
6205:
6206: /************************************************
6207: This procedure retrieves the match rule contact attributes into

Line 6261: RAISE FND_API.G_EXC_ERROR;

6257: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6258: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_ERROR;
6262: END get_contact_rec;
6263:
6264: /************************************************
6265: This procedure retrieves the match rule contact point attributes into

Line 6317: RAISE FND_API.G_EXC_ERROR;

6313: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6314: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6315: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6316: FND_MSG_PUB.ADD;
6317: RAISE FND_API.G_EXC_ERROR;
6318: END get_contact_point_rec;
6319:
6320: /************************************************
6321: This procedure maps a search record from the logical

Line 6413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6409: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6410: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6414: END;
6415:
6416:
6417: /************************************************

Line 6654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6650: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6651: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6653: FND_MSG_PUB.ADD;
6654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6655: END;
6656:
6657:
6658: /************************************************

Line 6711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6707: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6708: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6710: FND_MSG_PUB.ADD;
6711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6712: END;
6713:
6714:
6715: /************************************************

Line 6842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6838: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6839: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6840: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6841: FND_MSG_PUB.ADD;
6842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6843: END;
6844:
6845:
6846: /************************************************

Line 6867: RAISE FND_API.G_EXC_ERROR;

6863: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6864: ) THEN
6865: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6866: FND_MSG_PUB.ADD;
6867: RAISE FND_API.G_EXC_ERROR;
6868: END IF;
6869: END LOOP;
6870:
6871: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN

Line 6921: WHEN FND_API.G_EXC_ERROR THEN

6917: END IF;
6918: END LOOP;
6919: RETURN FALSE;
6920: EXCEPTION
6921: WHEN FND_API.G_EXC_ERROR THEN
6922: RAISE FND_API.G_EXC_ERROR;
6923: WHEN OTHERS THEN
6924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6925: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6922: RAISE FND_API.G_EXC_ERROR;

6918: END LOOP;
6919: RETURN FALSE;
6920: EXCEPTION
6921: WHEN FND_API.G_EXC_ERROR THEN
6922: RAISE FND_API.G_EXC_ERROR;
6923: WHEN OTHERS THEN
6924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6925: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6925: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6927: FND_MSG_PUB.ADD;
6928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6929: END check_prim_cond;
6930:
6931: /************************************************
6932: This procedure checks if the input search condition

Line 6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6991: FND_MSG_PUB.ADD;
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6993: END check_party_site_cond;
6994:
6995: /************************************************
6996: This procedure checks if the input search condition

Line 7048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7045: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7047: FND_MSG_PUB.ADD;
7048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7049: END check_contact_cond;
7050:
7051: /************************************************
7052: This procedure checks if the input search condition

Line 7069: RAISE FND_API.G_EXC_ERROR;

7065: FOR I IN 1..p_contact_point_list.COUNT LOOP
7066: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7067: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7068: FND_MSG_PUB.ADD;
7069: RAISE FND_API.G_EXC_ERROR;
7070: END IF;
7071: END LOOP;
7072:
7073: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7092: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7094: FND_MSG_PUB.ADD;
7095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7096: END check_contact_point_cond;
7097:
7098: FUNCTION check_staged RETURN BOOLEAN IS
7099: