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_53 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 878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

874: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
875: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
877: FND_MSG_PUB.ADD;
878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
879: END;
880:
881:
882: /************************************************

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

899: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
900: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
901: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END;
905:
906:
907: /************************************************

Line 923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

919: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
920: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END;
925:
926:
927: /************************************************

Line 943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
940: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END;
945:
946: PROCEDURE init_score_context (
947: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1010: RAISE FND_API.G_EXC_ERROR;

1006: p_contact_list,
1007: p_contact_point_list) THEN
1008: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1013: 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);
1014: END IF;

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: IF lengthb(l_party_contains_str) > 4000 THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: IF (p_match_str = ' AND ' OR p_party_max_score 1305: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1306: 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 1401: RAISE FND_API.G_EXC_ERROR;

1397: IF lengthb(l_contains_str) > 4000 THEN
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1399: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403: x_denorm_str := l_den_contains_str;
1404: RETURN l_contains_str;
1405: END;

Line 1706: RAISE FND_API.G_EXC_ERROR;

1702: when others then
1703: if (instrb(SQLERRM,'DRG-51030')>0) then
1704: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1705: FND_MSG_PUB.ADD;
1706: RAISE FND_API.G_EXC_ERROR;
1707: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1708: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1709: FND_MSG_PUB.ADD;
1710: RAISE FND_API.G_EXC_ERROR;

Line 1710: RAISE FND_API.G_EXC_ERROR;

1706: RAISE FND_API.G_EXC_ERROR;
1707: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1708: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1709: FND_MSG_PUB.ADD;
1710: RAISE FND_API.G_EXC_ERROR;
1711: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1713: FND_MSG_PUB.ADD;
1714: RAISE FND_API.G_EXC_ERROR;

Line 1714: RAISE FND_API.G_EXC_ERROR;

1710: RAISE FND_API.G_EXC_ERROR;
1711: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1713: FND_MSG_PUB.ADD;
1714: RAISE FND_API.G_EXC_ERROR;
1715: else
1716: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1718: FND_MSG_PUB.ADD;

Line 1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1715: else
1716: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1718: FND_MSG_PUB.ADD;
1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1720: end if;
1721: END;
1722:
1723: PROCEDURE open_party_site_cursor(

Line 1951: RAISE FND_API.G_EXC_ERROR;

1947: when others then
1948: if (instrb(SQLERRM,'DRG-51030')>0) then
1949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_ERROR;
1952: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1954: FND_MSG_PUB.ADD;
1955: RAISE FND_API.G_EXC_ERROR;

Line 1955: RAISE FND_API.G_EXC_ERROR;

1951: RAISE FND_API.G_EXC_ERROR;
1952: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1954: FND_MSG_PUB.ADD;
1955: RAISE FND_API.G_EXC_ERROR;
1956: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1958: FND_MSG_PUB.ADD;
1959: RAISE FND_API.G_EXC_ERROR;

Line 1959: RAISE FND_API.G_EXC_ERROR;

1955: RAISE FND_API.G_EXC_ERROR;
1956: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1958: FND_MSG_PUB.ADD;
1959: RAISE FND_API.G_EXC_ERROR;
1960: else
1961: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1963: FND_MSG_PUB.ADD;

Line 1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1960: else
1961: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1963: FND_MSG_PUB.ADD;
1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1965: end if;
1966: END;
1967:
1968: PROCEDURE open_contact_cursor(

Line 2098: RAISE FND_API.G_EXC_ERROR;

2094: when others then
2095: if (instrb(SQLERRM,'DRG-51030')>0) then
2096: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2097: FND_MSG_PUB.ADD;
2098: RAISE FND_API.G_EXC_ERROR;
2099: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2101: FND_MSG_PUB.ADD;
2102: RAISE FND_API.G_EXC_ERROR;

Line 2102: RAISE FND_API.G_EXC_ERROR;

2098: RAISE FND_API.G_EXC_ERROR;
2099: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2101: FND_MSG_PUB.ADD;
2102: RAISE FND_API.G_EXC_ERROR;
2103: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2105: FND_MSG_PUB.ADD;
2106: RAISE FND_API.G_EXC_ERROR;

Line 2106: RAISE FND_API.G_EXC_ERROR;

2102: RAISE FND_API.G_EXC_ERROR;
2103: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2105: FND_MSG_PUB.ADD;
2106: RAISE FND_API.G_EXC_ERROR;
2107: else
2108: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2110: FND_MSG_PUB.ADD;

Line 2111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2107: else
2108: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2110: FND_MSG_PUB.ADD;
2111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2112: end if;
2113: END;
2114:
2115: PROCEDURE open_contact_pt_cursor(

Line 2371: RAISE FND_API.G_EXC_ERROR;

2367: when others then
2368: if (instrb(SQLERRM,'DRG-51030')>0) then
2369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2370: FND_MSG_PUB.ADD;
2371: RAISE FND_API.G_EXC_ERROR;
2372: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2373: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_ERROR;

Line 2375: RAISE FND_API.G_EXC_ERROR;

2371: RAISE FND_API.G_EXC_ERROR;
2372: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2373: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_ERROR;
2376: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2378: FND_MSG_PUB.ADD;
2379: RAISE FND_API.G_EXC_ERROR;

Line 2379: RAISE FND_API.G_EXC_ERROR;

2375: RAISE FND_API.G_EXC_ERROR;
2376: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2378: FND_MSG_PUB.ADD;
2379: RAISE FND_API.G_EXC_ERROR;
2380: else
2381: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2383: FND_MSG_PUB.ADD;

Line 2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2380: else
2381: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2383: FND_MSG_PUB.ADD;
2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2385: end if;
2386: END;
2387:
2388:

Line 2642: RAISE FND_API.G_EXC_ERROR;

2638: 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);
2639: END IF;
2640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2641: FND_MSG_PUB.ADD;
2642: RAISE FND_API.G_EXC_ERROR;
2643: ELSE
2644: push_eval;
2645: RETURN;
2646: END IF;

Line 2690: RAISE FND_API.G_EXC_ERROR;

2686: 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);
2687: END IF;
2688: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2689: FND_MSG_PUB.ADD;
2690: RAISE FND_API.G_EXC_ERROR;
2691: ELSE
2692: push_eval;
2693: RETURN;
2694: END IF;

Line 2763: RAISE FND_API.G_EXC_ERROR;

2759: 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);
2760: END IF;
2761: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2762: FND_MSG_PUB.ADD;
2763: RAISE FND_API.G_EXC_ERROR;
2764: ELSE
2765: push_eval;
2766: RETURN;
2767: END IF;

Line 2875: RAISE FND_API.G_EXC_ERROR;

2871: 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);
2872: END IF;
2873: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2874: FND_MSG_PUB.ADD;
2875: RAISE FND_API.G_EXC_ERROR;
2876: ELSE
2877: push_eval;
2878: RETURN;
2879: END IF;

Line 2986: RAISE FND_API.G_EXC_ERROR;

2982: 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);
2983: END IF;
2984: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2985: FND_MSG_PUB.ADD;
2986: RAISE FND_API.G_EXC_ERROR;
2987: ELSE
2988: push_eval;
2989: RETURN;
2990: END IF;

Line 3211: RAISE FND_API.G_EXC_ERROR;

3207: 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);
3208: END IF;
3209: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3210: FND_MSG_PUB.ADD;
3211: RAISE FND_API.G_EXC_ERROR;
3212: END IF;
3213: ELSE
3214: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3215: 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 3219: RAISE FND_API.G_EXC_ERROR;

3215: 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);
3216: END IF;
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3218: FND_MSG_PUB.ADD;
3219: RAISE FND_API.G_EXC_ERROR;
3220: END IF;
3221: END IF;
3222: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3223: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3418: WHEN FND_API.G_EXC_ERROR THEN

3414: END IF;
3415: EXCEPTION
3416: WHEN L_RETURN_IMM_EXC THEN
3417: RETURN;
3418: WHEN FND_API.G_EXC_ERROR THEN
3419: RAISE FND_API.G_EXC_ERROR;
3420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3422: WHEN OTHERS THEN

Line 3419: RAISE FND_API.G_EXC_ERROR;

3415: EXCEPTION
3416: WHEN L_RETURN_IMM_EXC THEN
3417: RETURN;
3418: WHEN FND_API.G_EXC_ERROR THEN
3419: RAISE FND_API.G_EXC_ERROR;
3420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3422: WHEN OTHERS THEN
3423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3416: WHEN L_RETURN_IMM_EXC THEN
3417: RETURN;
3418: WHEN FND_API.G_EXC_ERROR THEN
3419: RAISE FND_API.G_EXC_ERROR;
3420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3422: WHEN OTHERS THEN
3423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3424: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');

Line 3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3417: RETURN;
3418: WHEN FND_API.G_EXC_ERROR THEN
3419: RAISE FND_API.G_EXC_ERROR;
3420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3422: WHEN OTHERS THEN
3423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3424: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');
3425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3424: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');
3425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3426: FND_MSG_PUB.ADD;
3427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3428: END find_parties;
3429:
3430: PROCEDURE find_persons (
3431: p_rule_id IN NUMBER,

Line 3625: RAISE FND_API.G_EXC_ERROR;

3621: 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);
3622: END IF;
3623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3624: FND_MSG_PUB.ADD;
3625: RAISE FND_API.G_EXC_ERROR;
3626: ELSE
3627: push_eval;
3628: RETURN;
3629: END IF;

Line 3673: RAISE FND_API.G_EXC_ERROR;

3669: 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);
3670: END IF;
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3672: FND_MSG_PUB.ADD;
3673: RAISE FND_API.G_EXC_ERROR;
3674: ELSE
3675: push_eval;
3676: RETURN;
3677: END IF;

Line 3709: RAISE FND_API.G_EXC_ERROR;

3705: when others then
3706: if (instrb(SQLERRM,'DRG-51030')>0) then
3707: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3708: FND_MSG_PUB.ADD;
3709: RAISE FND_API.G_EXC_ERROR;
3710: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3712: FND_MSG_PUB.ADD;
3713: RAISE FND_API.G_EXC_ERROR;

Line 3713: RAISE FND_API.G_EXC_ERROR;

3709: RAISE FND_API.G_EXC_ERROR;
3710: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3712: FND_MSG_PUB.ADD;
3713: RAISE FND_API.G_EXC_ERROR;
3714: else
3715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3716: end if;
3717: END;

Line 3715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3712: FND_MSG_PUB.ADD;
3713: RAISE FND_API.G_EXC_ERROR;
3714: else
3715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3716: end if;
3717: END;
3718:
3719: /** Private procedure to acquire and score at party site level ***/

Line 3785: RAISE FND_API.G_EXC_ERROR;

3781: 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);
3782: END IF;
3783: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3784: FND_MSG_PUB.ADD;
3785: RAISE FND_API.G_EXC_ERROR;
3786: ELSE
3787: push_eval;
3788: RETURN;
3789: END IF;

Line 4044: RAISE FND_API.G_EXC_ERROR;

4040: 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);
4041: END IF;
4042: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4043: FND_MSG_PUB.ADD;
4044: RAISE FND_API.G_EXC_ERROR;
4045: ELSE
4046: push_eval;
4047: RETURN;
4048: END IF;

Line 4157: RAISE FND_API.G_EXC_ERROR;

4153: 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);
4154: END IF;
4155: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4156: FND_MSG_PUB.ADD;
4157: RAISE FND_API.G_EXC_ERROR;
4158: END IF;
4159: ELSE
4160: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4161: 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 4165: RAISE FND_API.G_EXC_ERROR;

4161: 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);
4162: END IF;
4163: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4164: FND_MSG_PUB.ADD;
4165: RAISE FND_API.G_EXC_ERROR;
4166: END IF;
4167: END IF;
4168: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4169: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4279: WHEN FND_API.G_EXC_ERROR THEN

4275: END IF;
4276: EXCEPTION
4277: WHEN L_RETURN_IMM_EXC THEN
4278: RETURN;
4279: WHEN FND_API.G_EXC_ERROR THEN
4280: RAISE FND_API.G_EXC_ERROR;
4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4283: WHEN OTHERS THEN

Line 4280: RAISE FND_API.G_EXC_ERROR;

4276: EXCEPTION
4277: WHEN L_RETURN_IMM_EXC THEN
4278: RETURN;
4279: WHEN FND_API.G_EXC_ERROR THEN
4280: RAISE FND_API.G_EXC_ERROR;
4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4283: WHEN OTHERS THEN
4284: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4277: WHEN L_RETURN_IMM_EXC THEN
4278: RETURN;
4279: WHEN FND_API.G_EXC_ERROR THEN
4280: RAISE FND_API.G_EXC_ERROR;
4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4283: WHEN OTHERS THEN
4284: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4285: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');

Line 4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4347: WHEN FND_API.G_EXC_ERROR THEN

4343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4344: 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);
4345: END IF;
4346: EXCEPTION
4347: WHEN FND_API.G_EXC_ERROR THEN
4348: RAISE FND_API.G_EXC_ERROR;
4349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4351: WHEN OTHERS THEN

Line 4348: RAISE FND_API.G_EXC_ERROR;

4344: 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);
4345: END IF;
4346: EXCEPTION
4347: WHEN FND_API.G_EXC_ERROR THEN
4348: RAISE FND_API.G_EXC_ERROR;
4349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4351: WHEN OTHERS THEN
4352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4345: END IF;
4346: EXCEPTION
4347: WHEN FND_API.G_EXC_ERROR THEN
4348: RAISE FND_API.G_EXC_ERROR;
4349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4351: WHEN OTHERS THEN
4352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4353: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');

Line 4350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4346: EXCEPTION
4347: WHEN FND_API.G_EXC_ERROR THEN
4348: RAISE FND_API.G_EXC_ERROR;
4349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4351: WHEN OTHERS THEN
4352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4353: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');
4354: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4353: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');
4354: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4355: FND_MSG_PUB.ADD;
4356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4357: END find_party_details;
4358:
4359: PROCEDURE find_duplicate_parties (
4360: p_rule_id IN NUMBER,

Line 4464: WHEN FND_API.G_EXC_ERROR THEN

4460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4461: 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);
4462: END IF;
4463: EXCEPTION
4464: WHEN FND_API.G_EXC_ERROR THEN
4465: RAISE FND_API.G_EXC_ERROR;
4466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4468: WHEN OTHERS THEN

Line 4465: RAISE FND_API.G_EXC_ERROR;

4461: 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);
4462: END IF;
4463: EXCEPTION
4464: WHEN FND_API.G_EXC_ERROR THEN
4465: RAISE FND_API.G_EXC_ERROR;
4466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4468: WHEN OTHERS THEN
4469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4462: END IF;
4463: EXCEPTION
4464: WHEN FND_API.G_EXC_ERROR THEN
4465: RAISE FND_API.G_EXC_ERROR;
4466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4468: WHEN OTHERS THEN
4469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4470: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');

Line 4467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4463: EXCEPTION
4464: WHEN FND_API.G_EXC_ERROR THEN
4465: RAISE FND_API.G_EXC_ERROR;
4466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4468: WHEN OTHERS THEN
4469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4470: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');
4471: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4470: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');
4471: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4472: FND_MSG_PUB.ADD;
4473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4474: END find_duplicate_parties;
4475:
4476: PROCEDURE find_duplicate_party_sites (
4477: p_rule_id IN NUMBER,

Line 4549: WHEN FND_API.G_EXC_ERROR THEN

4545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4546: 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);
4547: END IF;
4548: EXCEPTION
4549: WHEN FND_API.G_EXC_ERROR THEN
4550: RAISE FND_API.G_EXC_ERROR;
4551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: WHEN OTHERS THEN

Line 4550: RAISE FND_API.G_EXC_ERROR;

4546: 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);
4547: END IF;
4548: EXCEPTION
4549: WHEN FND_API.G_EXC_ERROR THEN
4550: RAISE FND_API.G_EXC_ERROR;
4551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: WHEN OTHERS THEN
4554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4547: END IF;
4548: EXCEPTION
4549: WHEN FND_API.G_EXC_ERROR THEN
4550: RAISE FND_API.G_EXC_ERROR;
4551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: WHEN OTHERS THEN
4554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4555: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');

Line 4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4548: EXCEPTION
4549: WHEN FND_API.G_EXC_ERROR THEN
4550: RAISE FND_API.G_EXC_ERROR;
4551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: WHEN OTHERS THEN
4554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4555: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');
4556: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4555: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');
4556: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4557: FND_MSG_PUB.ADD;
4558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4559: END find_duplicate_party_sites;
4560:
4561: PROCEDURE find_duplicate_contacts (
4562: p_rule_id IN NUMBER,

Line 4638: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4639: RAISE FND_API.G_EXC_ERROR;

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

Line 4640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4643: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4644: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');
4645: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4646: FND_MSG_PUB.ADD;
4647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4648: END find_duplicate_contacts;
4649:
4650: PROCEDURE find_duplicate_contact_points (
4651: p_rule_id IN NUMBER,

Line 4711: WHEN FND_API.G_EXC_ERROR THEN

4707: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4708: 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);
4709: END IF;
4710: EXCEPTION
4711: WHEN FND_API.G_EXC_ERROR THEN
4712: RAISE FND_API.G_EXC_ERROR;
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4715: WHEN OTHERS THEN

Line 4712: RAISE FND_API.G_EXC_ERROR;

4708: 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);
4709: END IF;
4710: EXCEPTION
4711: WHEN FND_API.G_EXC_ERROR THEN
4712: RAISE FND_API.G_EXC_ERROR;
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4715: WHEN OTHERS THEN
4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4709: END IF;
4710: EXCEPTION
4711: WHEN FND_API.G_EXC_ERROR THEN
4712: RAISE FND_API.G_EXC_ERROR;
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4715: WHEN OTHERS THEN
4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');

Line 4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4710: EXCEPTION
4711: WHEN FND_API.G_EXC_ERROR THEN
4712: RAISE FND_API.G_EXC_ERROR;
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4715: WHEN OTHERS THEN
4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');
4718: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');
4718: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4719: FND_MSG_PUB.ADD;
4720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4721: END find_duplicate_contact_points;
4722:
4723: PROCEDURE find_parties_dynamic (
4724: p_rule_id IN NUMBER,

Line 5013: WHEN FND_API.G_EXC_ERROR THEN

5009: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5010: 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);
5011: END IF;
5012: EXCEPTION
5013: WHEN FND_API.G_EXC_ERROR THEN
5014: RAISE FND_API.G_EXC_ERROR;
5015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: WHEN OTHERS THEN

Line 5014: RAISE FND_API.G_EXC_ERROR;

5010: 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);
5011: END IF;
5012: EXCEPTION
5013: WHEN FND_API.G_EXC_ERROR THEN
5014: RAISE FND_API.G_EXC_ERROR;
5015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: WHEN OTHERS THEN
5018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5011: END IF;
5012: EXCEPTION
5013: WHEN FND_API.G_EXC_ERROR THEN
5014: RAISE FND_API.G_EXC_ERROR;
5015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: WHEN OTHERS THEN
5018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');

Line 5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5012: EXCEPTION
5013: WHEN FND_API.G_EXC_ERROR THEN
5014: RAISE FND_API.G_EXC_ERROR;
5015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: WHEN OTHERS THEN
5018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5021: FND_MSG_PUB.ADD;
5022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5023: END call_api_dynamic;
5024:
5025:
5026: PROCEDURE get_matching_party_sites (

Line 5253: WHEN FND_API.G_EXC_ERROR THEN

5249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5250: 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);
5251: END IF;
5252: EXCEPTION
5253: WHEN FND_API.G_EXC_ERROR THEN
5254: RAISE FND_API.G_EXC_ERROR;
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN

Line 5254: RAISE FND_API.G_EXC_ERROR;

5250: 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);
5251: END IF;
5252: EXCEPTION
5253: WHEN FND_API.G_EXC_ERROR THEN
5254: RAISE FND_API.G_EXC_ERROR;
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5251: END IF;
5252: EXCEPTION
5253: WHEN FND_API.G_EXC_ERROR THEN
5254: RAISE FND_API.G_EXC_ERROR;
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');

Line 5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5252: EXCEPTION
5253: WHEN FND_API.G_EXC_ERROR THEN
5254: RAISE FND_API.G_EXC_ERROR;
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END get_matching_party_sites;
5264:
5265:
5266: PROCEDURE get_matching_contacts (

Line 5478: WHEN FND_API.G_EXC_ERROR THEN

5474: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5475: 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);
5476: END IF;
5477: EXCEPTION
5478: WHEN FND_API.G_EXC_ERROR THEN
5479: RAISE FND_API.G_EXC_ERROR;
5480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5482: WHEN OTHERS THEN

Line 5479: RAISE FND_API.G_EXC_ERROR;

5475: 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);
5476: END IF;
5477: EXCEPTION
5478: WHEN FND_API.G_EXC_ERROR THEN
5479: RAISE FND_API.G_EXC_ERROR;
5480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5482: WHEN OTHERS THEN
5483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5476: END IF;
5477: EXCEPTION
5478: WHEN FND_API.G_EXC_ERROR THEN
5479: RAISE FND_API.G_EXC_ERROR;
5480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5482: WHEN OTHERS THEN
5483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');

Line 5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5477: EXCEPTION
5478: WHEN FND_API.G_EXC_ERROR THEN
5479: RAISE FND_API.G_EXC_ERROR;
5480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5482: WHEN OTHERS THEN
5483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: END get_matching_contacts;
5489:
5490:
5491: PROCEDURE get_matching_contact_points (

Line 5617: WHEN FND_API.G_EXC_ERROR THEN

5613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5614: 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);
5615: END IF;
5616: EXCEPTION
5617: WHEN FND_API.G_EXC_ERROR THEN
5618: RAISE FND_API.G_EXC_ERROR;
5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: WHEN OTHERS THEN

Line 5618: RAISE FND_API.G_EXC_ERROR;

5614: 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);
5615: END IF;
5616: EXCEPTION
5617: WHEN FND_API.G_EXC_ERROR THEN
5618: RAISE FND_API.G_EXC_ERROR;
5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: WHEN OTHERS THEN
5622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5615: END IF;
5616: EXCEPTION
5617: WHEN FND_API.G_EXC_ERROR THEN
5618: RAISE FND_API.G_EXC_ERROR;
5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: WHEN OTHERS THEN
5622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5623: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');

Line 5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5616: EXCEPTION
5617: WHEN FND_API.G_EXC_ERROR THEN
5618: RAISE FND_API.G_EXC_ERROR;
5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: WHEN OTHERS THEN
5622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5623: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5623: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5625: FND_MSG_PUB.ADD;
5626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5627: END get_matching_contact_points;
5628:
5629: /**********************************************************
5630: This procedure finds the score details for a specific party that

Line 5843: WHEN FND_API.G_EXC_ERROR THEN

5839: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5840: 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);
5841: END IF;
5842: EXCEPTION
5843: WHEN FND_API.G_EXC_ERROR THEN
5844: RAISE FND_API.G_EXC_ERROR;
5845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: WHEN OTHERS THEN

Line 5844: RAISE FND_API.G_EXC_ERROR;

5840: 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);
5841: END IF;
5842: EXCEPTION
5843: WHEN FND_API.G_EXC_ERROR THEN
5844: RAISE FND_API.G_EXC_ERROR;
5845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5841: END IF;
5842: EXCEPTION
5843: WHEN FND_API.G_EXC_ERROR THEN
5844: RAISE FND_API.G_EXC_ERROR;
5845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');

Line 5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5842: EXCEPTION
5843: WHEN FND_API.G_EXC_ERROR THEN
5844: RAISE FND_API.G_EXC_ERROR;
5845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: END get_score_details;
5854:
5855:
5856: /************************************************

Line 5921: WHEN FND_API.G_EXC_ERROR THEN

5917: END LOOP;
5918: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5919: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5920: EXCEPTION
5921: WHEN FND_API.G_EXC_ERROR THEN
5922: RAISE FND_API.G_EXC_ERROR;
5923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: WHEN OTHERS THEN

Line 5922: RAISE FND_API.G_EXC_ERROR;

5918: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5919: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5920: EXCEPTION
5921: WHEN FND_API.G_EXC_ERROR THEN
5922: RAISE FND_API.G_EXC_ERROR;
5923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5919: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5920: EXCEPTION
5921: WHEN FND_API.G_EXC_ERROR THEN
5922: RAISE FND_API.G_EXC_ERROR;
5923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5920: EXCEPTION
5921: WHEN FND_API.G_EXC_ERROR THEN
5922: RAISE FND_API.G_EXC_ERROR;
5923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5929: FND_MSG_PUB.ADD;
5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5931: END get_party_for_search;
5932:
5933: PROCEDURE get_search_criteria (
5934: p_party_id IN NUMBER,

Line 5961: WHEN FND_API.G_EXC_ERROR THEN

5957: END IF;
5958: get_party_site_rec(p_party_site_ids, x_party_site_list);
5959: END IF;
5960: EXCEPTION
5961: WHEN FND_API.G_EXC_ERROR THEN
5962: RAISE FND_API.G_EXC_ERROR;
5963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5965: WHEN OTHERS THEN

Line 5962: RAISE FND_API.G_EXC_ERROR;

5958: get_party_site_rec(p_party_site_ids, x_party_site_list);
5959: END IF;
5960: EXCEPTION
5961: WHEN FND_API.G_EXC_ERROR THEN
5962: RAISE FND_API.G_EXC_ERROR;
5963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5965: WHEN OTHERS THEN
5966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5959: END IF;
5960: EXCEPTION
5961: WHEN FND_API.G_EXC_ERROR THEN
5962: RAISE FND_API.G_EXC_ERROR;
5963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5965: WHEN OTHERS THEN
5966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5967: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5960: EXCEPTION
5961: WHEN FND_API.G_EXC_ERROR THEN
5962: RAISE FND_API.G_EXC_ERROR;
5963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5965: WHEN OTHERS THEN
5966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5967: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5967: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5969: FND_MSG_PUB.ADD;
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: END get_search_criteria;
5972:
5973:
5974: /************************************************

Line 6035: RAISE FND_API.G_EXC_ERROR;

6031: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6032: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_ERROR;
6036: END get_party_rec;
6037:
6038: /************************************************
6039: This procedure retrieves the match rule party site attributes into

Line 6097: RAISE FND_API.G_EXC_ERROR;

6093: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;
6097: RAISE FND_API.G_EXC_ERROR;
6098: END get_party_site_rec;
6099:
6100: /************************************************
6101: This procedure retrieves the match rule contact attributes into

Line 6153: RAISE FND_API.G_EXC_ERROR;

6149: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6150: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6152: FND_MSG_PUB.ADD;
6153: RAISE FND_API.G_EXC_ERROR;
6154: END get_contact_rec;
6155:
6156: /************************************************
6157: This procedure retrieves the match rule contact point attributes into

Line 6205: RAISE FND_API.G_EXC_ERROR;

6201: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6202: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6204: FND_MSG_PUB.ADD;
6205: RAISE FND_API.G_EXC_ERROR;
6206: END get_contact_point_rec;
6207:
6208: /************************************************
6209: This procedure maps a search record from the logical

Line 6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6415: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6420: END;
6421:
6422:
6423: /************************************************

Line 6631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6627: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6628: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6630: FND_MSG_PUB.ADD;
6631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6632: END;
6633:
6634:
6635: /************************************************

Line 6673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6669: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6670: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6672: FND_MSG_PUB.ADD;
6673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6674: END;
6675:
6676:
6677: /************************************************

Line 6740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6736: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6737: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6738: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6739: FND_MSG_PUB.ADD;
6740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6741: END;
6742:
6743:
6744: /************************************************

Line 6800: WHEN FND_API.G_EXC_ERROR THEN

6796: END IF;
6797: END LOOP;
6798: RETURN FALSE;
6799: EXCEPTION
6800: WHEN FND_API.G_EXC_ERROR THEN
6801: RAISE FND_API.G_EXC_ERROR;
6802: WHEN OTHERS THEN
6803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6804: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6801: RAISE FND_API.G_EXC_ERROR;

6797: END LOOP;
6798: RETURN FALSE;
6799: EXCEPTION
6800: WHEN FND_API.G_EXC_ERROR THEN
6801: RAISE FND_API.G_EXC_ERROR;
6802: WHEN OTHERS THEN
6803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6804: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6804: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6806: FND_MSG_PUB.ADD;
6807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6808: END check_prim_cond;
6809:
6810: /************************************************
6811: This procedure checks if the input search condition

Line 6859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6855: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6856: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6857: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6858: FND_MSG_PUB.ADD;
6859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6860: END check_party_site_cond;
6861:
6862: /************************************************
6863: This procedure checks if the input search condition

Line 6897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6894: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6896: FND_MSG_PUB.ADD;
6897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6898: END check_contact_cond;
6899:
6900: /************************************************
6901: This procedure checks if the input search condition

Line 6918: RAISE FND_API.G_EXC_ERROR;

6914: FOR I IN 1..p_contact_point_list.COUNT LOOP
6915: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6916: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6917: FND_MSG_PUB.ADD;
6918: RAISE FND_API.G_EXC_ERROR;
6919: END IF;
6920: END LOOP;
6921:
6922: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6931: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6933: FND_MSG_PUB.ADD;
6934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6935: END check_contact_point_cond;
6936:
6937: FUNCTION check_staged RETURN BOOLEAN IS
6938: