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

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

Line 1720: RAISE FND_API.G_EXC_ERROR;

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

Line 1724: RAISE FND_API.G_EXC_ERROR;

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

Line 1729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1961: RAISE FND_API.G_EXC_ERROR;

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

Line 1965: RAISE FND_API.G_EXC_ERROR;

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

Line 1969: RAISE FND_API.G_EXC_ERROR;

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

Line 1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2108: RAISE FND_API.G_EXC_ERROR;

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

Line 2112: RAISE FND_API.G_EXC_ERROR;

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

Line 2116: RAISE FND_API.G_EXC_ERROR;

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

Line 2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2381: RAISE FND_API.G_EXC_ERROR;

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

Line 2385: RAISE FND_API.G_EXC_ERROR;

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

Line 2389: RAISE FND_API.G_EXC_ERROR;

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

Line 2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2652: RAISE FND_API.G_EXC_ERROR;

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

Line 2700: RAISE FND_API.G_EXC_ERROR;

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

Line 2773: RAISE FND_API.G_EXC_ERROR;

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

Line 2885: RAISE FND_API.G_EXC_ERROR;

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

Line 2996: RAISE FND_API.G_EXC_ERROR;

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

Line 3221: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3428: WHEN FND_API.G_EXC_ERROR THEN

3424: END IF;
3425: EXCEPTION
3426: WHEN L_RETURN_IMM_EXC THEN
3427: RETURN;
3428: WHEN FND_API.G_EXC_ERROR THEN
3429: RAISE FND_API.G_EXC_ERROR;
3430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3432: WHEN OTHERS THEN

Line 3429: RAISE FND_API.G_EXC_ERROR;

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

Line 3430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3635: RAISE FND_API.G_EXC_ERROR;

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

Line 3683: RAISE FND_API.G_EXC_ERROR;

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

Line 3719: RAISE FND_API.G_EXC_ERROR;

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

Line 3723: RAISE FND_API.G_EXC_ERROR;

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

Line 3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3795: RAISE FND_API.G_EXC_ERROR;

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

Line 4054: RAISE FND_API.G_EXC_ERROR;

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

Line 4167: RAISE FND_API.G_EXC_ERROR;

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

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

Line 4289: WHEN FND_API.G_EXC_ERROR THEN

4285: END IF;
4286: EXCEPTION
4287: WHEN L_RETURN_IMM_EXC THEN
4288: RETURN;
4289: WHEN FND_API.G_EXC_ERROR THEN
4290: RAISE FND_API.G_EXC_ERROR;
4291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: WHEN OTHERS THEN

Line 4290: RAISE FND_API.G_EXC_ERROR;

4286: EXCEPTION
4287: WHEN L_RETURN_IMM_EXC THEN
4288: RETURN;
4289: WHEN FND_API.G_EXC_ERROR THEN
4290: RAISE FND_API.G_EXC_ERROR;
4291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: WHEN OTHERS THEN
4294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4287: WHEN L_RETURN_IMM_EXC THEN
4288: RETURN;
4289: WHEN FND_API.G_EXC_ERROR THEN
4290: RAISE FND_API.G_EXC_ERROR;
4291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: WHEN OTHERS THEN
4294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4295: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');

Line 4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4288: RETURN;
4289: WHEN FND_API.G_EXC_ERROR THEN
4290: RAISE FND_API.G_EXC_ERROR;
4291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: WHEN OTHERS THEN
4294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4295: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');
4296: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4357: WHEN FND_API.G_EXC_ERROR THEN

4353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4354: 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);
4355: END IF;
4356: EXCEPTION
4357: WHEN FND_API.G_EXC_ERROR THEN
4358: RAISE FND_API.G_EXC_ERROR;
4359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4361: WHEN OTHERS THEN

Line 4358: RAISE FND_API.G_EXC_ERROR;

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

Line 4359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4355: END IF;
4356: EXCEPTION
4357: WHEN FND_API.G_EXC_ERROR THEN
4358: RAISE FND_API.G_EXC_ERROR;
4359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4361: WHEN OTHERS THEN
4362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_party_details');

Line 4360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4356: EXCEPTION
4357: WHEN FND_API.G_EXC_ERROR THEN
4358: RAISE FND_API.G_EXC_ERROR;
4359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4361: WHEN OTHERS THEN
4362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_party_details');
4364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4474: WHEN FND_API.G_EXC_ERROR THEN

4470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4471: 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);
4472: END IF;
4473: EXCEPTION
4474: WHEN FND_API.G_EXC_ERROR THEN
4475: RAISE FND_API.G_EXC_ERROR;
4476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4478: WHEN OTHERS THEN

Line 4475: RAISE FND_API.G_EXC_ERROR;

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

Line 4476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4472: END IF;
4473: EXCEPTION
4474: WHEN FND_API.G_EXC_ERROR THEN
4475: RAISE FND_API.G_EXC_ERROR;
4476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4478: WHEN OTHERS THEN
4479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4480: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');

Line 4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4473: EXCEPTION
4474: WHEN FND_API.G_EXC_ERROR THEN
4475: RAISE FND_API.G_EXC_ERROR;
4476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4478: WHEN OTHERS THEN
4479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4480: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');
4481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4559: WHEN FND_API.G_EXC_ERROR THEN

4555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4556: 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);
4557: END IF;
4558: EXCEPTION
4559: WHEN FND_API.G_EXC_ERROR THEN
4560: RAISE FND_API.G_EXC_ERROR;
4561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4563: WHEN OTHERS THEN

Line 4560: RAISE FND_API.G_EXC_ERROR;

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

Line 4561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4557: END IF;
4558: EXCEPTION
4559: WHEN FND_API.G_EXC_ERROR THEN
4560: RAISE FND_API.G_EXC_ERROR;
4561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4563: WHEN OTHERS THEN
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');

Line 4562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4558: EXCEPTION
4559: WHEN FND_API.G_EXC_ERROR THEN
4560: RAISE FND_API.G_EXC_ERROR;
4561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4563: WHEN OTHERS THEN
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');
4566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4648: WHEN FND_API.G_EXC_ERROR THEN

4644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4645: 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);
4646: END IF;
4647: EXCEPTION
4648: WHEN FND_API.G_EXC_ERROR THEN
4649: RAISE FND_API.G_EXC_ERROR;
4650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4652: WHEN OTHERS THEN

Line 4649: RAISE FND_API.G_EXC_ERROR;

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

Line 4650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4646: END IF;
4647: EXCEPTION
4648: WHEN FND_API.G_EXC_ERROR THEN
4649: RAISE FND_API.G_EXC_ERROR;
4650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4652: WHEN OTHERS THEN
4653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');

Line 4651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4647: EXCEPTION
4648: WHEN FND_API.G_EXC_ERROR THEN
4649: RAISE FND_API.G_EXC_ERROR;
4650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4652: WHEN OTHERS THEN
4653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');
4655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4721: WHEN FND_API.G_EXC_ERROR THEN

4717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4718: 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);
4719: END IF;
4720: EXCEPTION
4721: WHEN FND_API.G_EXC_ERROR THEN
4722: RAISE FND_API.G_EXC_ERROR;
4723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: WHEN OTHERS THEN

Line 4722: RAISE FND_API.G_EXC_ERROR;

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

Line 4723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4719: END IF;
4720: EXCEPTION
4721: WHEN FND_API.G_EXC_ERROR THEN
4722: RAISE FND_API.G_EXC_ERROR;
4723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: WHEN OTHERS THEN
4726: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4727: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');

Line 4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4720: EXCEPTION
4721: WHEN FND_API.G_EXC_ERROR THEN
4722: RAISE FND_API.G_EXC_ERROR;
4723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: WHEN OTHERS THEN
4726: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4727: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');
4728: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5057: WHEN FND_API.G_EXC_ERROR THEN

5053: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5054: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5055: END IF;
5056: EXCEPTION
5057: WHEN FND_API.G_EXC_ERROR THEN
5058: RAISE FND_API.G_EXC_ERROR;
5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN

Line 5058: RAISE FND_API.G_EXC_ERROR;

5054: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5055: END IF;
5056: EXCEPTION
5057: WHEN FND_API.G_EXC_ERROR THEN
5058: RAISE FND_API.G_EXC_ERROR;
5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5302: WHEN FND_API.G_EXC_ERROR THEN

5298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5299: 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);
5300: END IF;
5301: EXCEPTION
5302: WHEN FND_API.G_EXC_ERROR THEN
5303: RAISE FND_API.G_EXC_ERROR;
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN

Line 5303: RAISE FND_API.G_EXC_ERROR;

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

Line 5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5300: END IF;
5301: EXCEPTION
5302: WHEN FND_API.G_EXC_ERROR THEN
5303: RAISE FND_API.G_EXC_ERROR;
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');

Line 5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5301: EXCEPTION
5302: WHEN FND_API.G_EXC_ERROR THEN
5303: RAISE FND_API.G_EXC_ERROR;
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_matching_party_sites;
5313:
5314:
5315: PROCEDURE get_matching_contacts (

Line 5531: WHEN FND_API.G_EXC_ERROR THEN

5527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5528: 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);
5529: END IF;
5530: EXCEPTION
5531: WHEN FND_API.G_EXC_ERROR THEN
5532: RAISE FND_API.G_EXC_ERROR;
5533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: WHEN OTHERS THEN

Line 5532: RAISE FND_API.G_EXC_ERROR;

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

Line 5533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5529: END IF;
5530: EXCEPTION
5531: WHEN FND_API.G_EXC_ERROR THEN
5532: RAISE FND_API.G_EXC_ERROR;
5533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: WHEN OTHERS THEN
5536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');

Line 5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5530: EXCEPTION
5531: WHEN FND_API.G_EXC_ERROR THEN
5532: RAISE FND_API.G_EXC_ERROR;
5533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: WHEN OTHERS THEN
5536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');
5538: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');
5538: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5539: FND_MSG_PUB.ADD;
5540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5541: END get_matching_contacts;
5542:
5543:
5544: PROCEDURE get_matching_contact_points (

Line 5673: WHEN FND_API.G_EXC_ERROR THEN

5669: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5670: 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);
5671: END IF;
5672: EXCEPTION
5673: WHEN FND_API.G_EXC_ERROR THEN
5674: RAISE FND_API.G_EXC_ERROR;
5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5677: WHEN OTHERS THEN

Line 5674: RAISE FND_API.G_EXC_ERROR;

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

Line 5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5671: END IF;
5672: EXCEPTION
5673: WHEN FND_API.G_EXC_ERROR THEN
5674: RAISE FND_API.G_EXC_ERROR;
5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5677: WHEN OTHERS THEN
5678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5679: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');

Line 5676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5672: EXCEPTION
5673: WHEN FND_API.G_EXC_ERROR THEN
5674: RAISE FND_API.G_EXC_ERROR;
5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5677: WHEN OTHERS THEN
5678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5679: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');
5680: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5905: WHEN FND_API.G_EXC_ERROR THEN

5901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5902: 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);
5903: END IF;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN

Line 5906: RAISE FND_API.G_EXC_ERROR;

5902: 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);
5903: END IF;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5903: END IF;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');

Line 5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6028: WHEN FND_API.G_EXC_ERROR THEN

6024: END LOOP;
6025: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6026: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6027: EXCEPTION
6028: WHEN FND_API.G_EXC_ERROR THEN
6029: RAISE FND_API.G_EXC_ERROR;
6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6032: WHEN OTHERS THEN

Line 6029: RAISE FND_API.G_EXC_ERROR;

6025: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6026: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6027: EXCEPTION
6028: WHEN FND_API.G_EXC_ERROR THEN
6029: RAISE FND_API.G_EXC_ERROR;
6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6032: WHEN OTHERS THEN
6033: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6026: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6027: EXCEPTION
6028: WHEN FND_API.G_EXC_ERROR THEN
6029: RAISE FND_API.G_EXC_ERROR;
6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6032: WHEN OTHERS THEN
6033: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6034: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6027: EXCEPTION
6028: WHEN FND_API.G_EXC_ERROR THEN
6029: RAISE FND_API.G_EXC_ERROR;
6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6032: WHEN OTHERS THEN
6033: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6034: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6033: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6034: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6036: FND_MSG_PUB.ADD;
6037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6038: END get_party_for_search;
6039:
6040: PROCEDURE get_search_criteria (
6041: p_party_id IN NUMBER,

Line 6080: WHEN FND_API.G_EXC_ERROR THEN

6076: END IF;
6077: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6078: END IF;
6079: EXCEPTION
6080: WHEN FND_API.G_EXC_ERROR THEN
6081: RAISE FND_API.G_EXC_ERROR;
6082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6084: WHEN OTHERS THEN

Line 6081: RAISE FND_API.G_EXC_ERROR;

6077: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6078: END IF;
6079: EXCEPTION
6080: WHEN FND_API.G_EXC_ERROR THEN
6081: RAISE FND_API.G_EXC_ERROR;
6082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6084: WHEN OTHERS THEN
6085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6078: END IF;
6079: EXCEPTION
6080: WHEN FND_API.G_EXC_ERROR THEN
6081: RAISE FND_API.G_EXC_ERROR;
6082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6084: WHEN OTHERS THEN
6085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6086: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6079: EXCEPTION
6080: WHEN FND_API.G_EXC_ERROR THEN
6081: RAISE FND_API.G_EXC_ERROR;
6082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6084: WHEN OTHERS THEN
6085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6086: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6086: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6090: END get_search_criteria;
6091:
6092:
6093: /************************************************

Line 6134: RAISE FND_API.G_EXC_ERROR;

6130: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6131: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6133: FND_MSG_PUB.ADD;
6134: RAISE FND_API.G_EXC_ERROR;
6135: END get_party_rec;
6136:
6137: /************************************************
6138: This procedure retrieves the match rule party site attributes into

Line 6198: RAISE FND_API.G_EXC_ERROR;

6194: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6195: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6197: FND_MSG_PUB.ADD;
6198: RAISE FND_API.G_EXC_ERROR;
6199: END get_party_site_rec;
6200:
6201: /************************************************
6202: This procedure retrieves the match rule contact attributes into

Line 6256: RAISE FND_API.G_EXC_ERROR;

6252: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6253: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6254: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6255: FND_MSG_PUB.ADD;
6256: RAISE FND_API.G_EXC_ERROR;
6257: END get_contact_rec;
6258:
6259: /************************************************
6260: This procedure retrieves the match rule contact point attributes into

Line 6312: RAISE FND_API.G_EXC_ERROR;

6308: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6309: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6311: FND_MSG_PUB.ADD;
6312: RAISE FND_API.G_EXC_ERROR;
6313: END get_contact_point_rec;
6314:
6315: /************************************************
6316: This procedure maps a search record from the logical

Line 6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: END;
6410:
6411:
6412: /************************************************

Line 6649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6648: FND_MSG_PUB.ADD;
6649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6650: END;
6651:
6652:
6653: /************************************************

Line 6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6703: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6705: FND_MSG_PUB.ADD;
6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6707: END;
6708:
6709:
6710: /************************************************

Line 6837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6833: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6834: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6835: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6836: FND_MSG_PUB.ADD;
6837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6838: END;
6839:
6840:
6841: /************************************************

Line 6862: RAISE FND_API.G_EXC_ERROR;

6858: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6859: ) THEN
6860: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6861: FND_MSG_PUB.ADD;
6862: RAISE FND_API.G_EXC_ERROR;
6863: END IF;
6864: END LOOP;
6865:
6866: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN

Line 6916: WHEN FND_API.G_EXC_ERROR THEN

6912: END IF;
6913: END LOOP;
6914: RETURN FALSE;
6915: EXCEPTION
6916: WHEN FND_API.G_EXC_ERROR THEN
6917: RAISE FND_API.G_EXC_ERROR;
6918: WHEN OTHERS THEN
6919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6920: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6917: RAISE FND_API.G_EXC_ERROR;

6913: END LOOP;
6914: RETURN FALSE;
6915: EXCEPTION
6916: WHEN FND_API.G_EXC_ERROR THEN
6917: RAISE FND_API.G_EXC_ERROR;
6918: WHEN OTHERS THEN
6919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6920: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6920: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6922: FND_MSG_PUB.ADD;
6923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6924: END check_prim_cond;
6925:
6926: /************************************************
6927: This procedure checks if the input search condition

Line 6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6986: FND_MSG_PUB.ADD;
6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6988: END check_party_site_cond;
6989:
6990: /************************************************
6991: This procedure checks if the input search condition

Line 7043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7040: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7042: FND_MSG_PUB.ADD;
7043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7044: END check_contact_cond;
7045:
7046: /************************************************
7047: This procedure checks if the input search condition

Line 7064: RAISE FND_API.G_EXC_ERROR;

7060: FOR I IN 1..p_contact_point_list.COUNT LOOP
7061: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7062: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7063: FND_MSG_PUB.ADD;
7064: RAISE FND_API.G_EXC_ERROR;
7065: END IF;
7066: END LOOP;
7067:
7068: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7087: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7089: FND_MSG_PUB.ADD;
7090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7091: END check_contact_point_cond;
7092:
7093: FUNCTION check_staged RETURN BOOLEAN IS
7094: