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_8 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 875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

891: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
892: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END;
897:
898:
899: /************************************************

Line 915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

911: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
912: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
914: FND_MSG_PUB.ADD;
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END;
917:
918:
919: /************************************************

Line 935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

931: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
932: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
936: END;
937:
938: PROCEDURE init_score_context (
939: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1002: RAISE FND_API.G_EXC_ERROR;

998: p_contact_list,
999: p_contact_point_list) THEN
1000: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1001: FND_MSG_PUB.ADD;
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1005: 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);
1006: END IF;

Line 1243: RAISE FND_API.G_EXC_ERROR;

1239: IF lengthb(l_party_contains_str) > 4000 THEN
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1242: FND_MSG_PUB.ADD;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245: IF (p_match_str = ' AND ' OR p_party_max_score 1246: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1247: 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 1332: RAISE FND_API.G_EXC_ERROR;

1328: IF lengthb(l_contains_str) > 4000 THEN
1329: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1330: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1331: FND_MSG_PUB.ADD;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334: x_denorm_str := l_den_contains_str;
1335: RETURN l_contains_str;
1336: END;

Line 1376: RAISE FND_API.G_EXC_ERROR;

1372: IF lengthb(l_contains_str) > 4000 THEN
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1374: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1375: FND_MSG_PUB.ADD;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378: x_denorm_str := l_den_contains_str;
1379: RETURN l_contains_str;
1380: END;

Line 1464: RAISE FND_API.G_EXC_ERROR;

1460: IF lengthb(l_contains_str) > 4000 THEN
1461: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1462: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1463: FND_MSG_PUB.ADD;
1464: RAISE FND_API.G_EXC_ERROR;
1465: END IF;
1466: x_denorm_str := l_den_contains_str;
1467: RETURN l_contains_str;
1468: END;

Line 1703: RAISE FND_API.G_EXC_ERROR;

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

Line 1707: RAISE FND_API.G_EXC_ERROR;

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

Line 1711: RAISE FND_API.G_EXC_ERROR;

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

Line 1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1948: RAISE FND_API.G_EXC_ERROR;

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

Line 1952: RAISE FND_API.G_EXC_ERROR;

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

Line 1956: RAISE FND_API.G_EXC_ERROR;

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

Line 1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2095: RAISE FND_API.G_EXC_ERROR;

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

Line 2099: RAISE FND_API.G_EXC_ERROR;

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

Line 2103: RAISE FND_API.G_EXC_ERROR;

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

Line 2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2368: RAISE FND_API.G_EXC_ERROR;

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

Line 2372: RAISE FND_API.G_EXC_ERROR;

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

Line 2376: RAISE FND_API.G_EXC_ERROR;

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

Line 2381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2638: RAISE FND_API.G_EXC_ERROR;

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

Line 2686: RAISE FND_API.G_EXC_ERROR;

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

Line 2759: RAISE FND_API.G_EXC_ERROR;

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

Line 2871: RAISE FND_API.G_EXC_ERROR;

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

Line 2982: RAISE FND_API.G_EXC_ERROR;

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

Line 3207: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3414: WHEN FND_API.G_EXC_ERROR THEN

3410: END IF;
3411: EXCEPTION
3412: WHEN L_RETURN_IMM_EXC THEN
3413: RETURN;
3414: WHEN FND_API.G_EXC_ERROR THEN
3415: RAISE FND_API.G_EXC_ERROR;
3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: WHEN OTHERS THEN

Line 3415: RAISE FND_API.G_EXC_ERROR;

3411: EXCEPTION
3412: WHEN L_RETURN_IMM_EXC THEN
3413: RETURN;
3414: WHEN FND_API.G_EXC_ERROR THEN
3415: RAISE FND_API.G_EXC_ERROR;
3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: WHEN OTHERS THEN
3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3412: WHEN L_RETURN_IMM_EXC THEN
3413: RETURN;
3414: WHEN FND_API.G_EXC_ERROR THEN
3415: RAISE FND_API.G_EXC_ERROR;
3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: WHEN OTHERS THEN
3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3420: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_parties');

Line 3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3413: RETURN;
3414: WHEN FND_API.G_EXC_ERROR THEN
3415: RAISE FND_API.G_EXC_ERROR;
3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: WHEN OTHERS THEN
3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3420: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_parties');
3421: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3420: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_parties');
3421: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3422: FND_MSG_PUB.ADD;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3424: END find_parties;
3425:
3426: PROCEDURE find_persons (
3427: p_rule_id IN NUMBER,

Line 3620: RAISE FND_API.G_EXC_ERROR;

3616: 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);
3617: END IF;
3618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3619: FND_MSG_PUB.ADD;
3620: RAISE FND_API.G_EXC_ERROR;
3621: ELSE
3622: push_eval;
3623: RETURN;
3624: END IF;

Line 3668: RAISE FND_API.G_EXC_ERROR;

3664: 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);
3665: END IF;
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3667: FND_MSG_PUB.ADD;
3668: RAISE FND_API.G_EXC_ERROR;
3669: ELSE
3670: push_eval;
3671: RETURN;
3672: END IF;

Line 3704: RAISE FND_API.G_EXC_ERROR;

3700: when others then
3701: if (instrb(SQLERRM,'DRG-51030')>0) then
3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3703: FND_MSG_PUB.ADD;
3704: RAISE FND_API.G_EXC_ERROR;
3705: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3707: FND_MSG_PUB.ADD;
3708: RAISE FND_API.G_EXC_ERROR;

Line 3708: RAISE FND_API.G_EXC_ERROR;

3704: RAISE FND_API.G_EXC_ERROR;
3705: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3707: FND_MSG_PUB.ADD;
3708: RAISE FND_API.G_EXC_ERROR;
3709: else
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: end if;
3712: END;

Line 3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3707: FND_MSG_PUB.ADD;
3708: RAISE FND_API.G_EXC_ERROR;
3709: else
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: end if;
3712: END;
3713:
3714: /** Private procedure to acquire and score at party site level ***/

Line 3780: RAISE FND_API.G_EXC_ERROR;

3776: 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);
3777: END IF;
3778: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3779: FND_MSG_PUB.ADD;
3780: RAISE FND_API.G_EXC_ERROR;
3781: ELSE
3782: push_eval;
3783: RETURN;
3784: END IF;

Line 4039: RAISE FND_API.G_EXC_ERROR;

4035: 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);
4036: END IF;
4037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4038: FND_MSG_PUB.ADD;
4039: RAISE FND_API.G_EXC_ERROR;
4040: ELSE
4041: push_eval;
4042: RETURN;
4043: END IF;

Line 4152: RAISE FND_API.G_EXC_ERROR;

4148: 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);
4149: END IF;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4151: FND_MSG_PUB.ADD;
4152: RAISE FND_API.G_EXC_ERROR;
4153: END IF;
4154: ELSE
4155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4156: 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 4160: RAISE FND_API.G_EXC_ERROR;

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

Line 4274: WHEN FND_API.G_EXC_ERROR THEN

4270: END IF;
4271: EXCEPTION
4272: WHEN L_RETURN_IMM_EXC THEN
4273: RETURN;
4274: WHEN FND_API.G_EXC_ERROR THEN
4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN

Line 4275: RAISE FND_API.G_EXC_ERROR;

4271: EXCEPTION
4272: WHEN L_RETURN_IMM_EXC THEN
4273: RETURN;
4274: WHEN FND_API.G_EXC_ERROR THEN
4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4272: WHEN L_RETURN_IMM_EXC THEN
4273: RETURN;
4274: WHEN FND_API.G_EXC_ERROR THEN
4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');

Line 4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4273: RETURN;
4274: WHEN FND_API.G_EXC_ERROR THEN
4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4284: END find_persons;
4285:
4286: PROCEDURE find_persons (
4287: p_rule_id IN NUMBER,

Line 4342: WHEN FND_API.G_EXC_ERROR THEN

4338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4339: 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);
4340: END IF;
4341: EXCEPTION
4342: WHEN FND_API.G_EXC_ERROR THEN
4343: RAISE FND_API.G_EXC_ERROR;
4344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4346: WHEN OTHERS THEN

Line 4343: RAISE FND_API.G_EXC_ERROR;

4339: 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);
4340: END IF;
4341: EXCEPTION
4342: WHEN FND_API.G_EXC_ERROR THEN
4343: RAISE FND_API.G_EXC_ERROR;
4344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4346: WHEN OTHERS THEN
4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4340: END IF;
4341: EXCEPTION
4342: WHEN FND_API.G_EXC_ERROR THEN
4343: RAISE FND_API.G_EXC_ERROR;
4344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4346: WHEN OTHERS THEN
4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4348: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');

Line 4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4341: EXCEPTION
4342: WHEN FND_API.G_EXC_ERROR THEN
4343: RAISE FND_API.G_EXC_ERROR;
4344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4346: WHEN OTHERS THEN
4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4348: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');
4349: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4348: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');
4349: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4350: FND_MSG_PUB.ADD;
4351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4352: END find_party_details;
4353:
4354: PROCEDURE find_duplicate_parties (
4355: p_rule_id IN NUMBER,

Line 4459: WHEN FND_API.G_EXC_ERROR THEN

4455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4456: 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);
4457: END IF;
4458: EXCEPTION
4459: WHEN FND_API.G_EXC_ERROR THEN
4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN

Line 4460: RAISE FND_API.G_EXC_ERROR;

4456: 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);
4457: END IF;
4458: EXCEPTION
4459: WHEN FND_API.G_EXC_ERROR THEN
4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4457: END IF;
4458: EXCEPTION
4459: WHEN FND_API.G_EXC_ERROR THEN
4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');

Line 4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4458: EXCEPTION
4459: WHEN FND_API.G_EXC_ERROR THEN
4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END find_duplicate_parties;
4470:
4471: PROCEDURE find_duplicate_party_sites (
4472: p_rule_id IN NUMBER,

Line 4544: WHEN FND_API.G_EXC_ERROR THEN

4540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4541: 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);
4542: END IF;
4543: EXCEPTION
4544: WHEN FND_API.G_EXC_ERROR THEN
4545: RAISE FND_API.G_EXC_ERROR;
4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: WHEN OTHERS THEN

Line 4545: RAISE FND_API.G_EXC_ERROR;

4541: 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);
4542: END IF;
4543: EXCEPTION
4544: WHEN FND_API.G_EXC_ERROR THEN
4545: RAISE FND_API.G_EXC_ERROR;
4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: WHEN OTHERS THEN
4549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4542: END IF;
4543: EXCEPTION
4544: WHEN FND_API.G_EXC_ERROR THEN
4545: RAISE FND_API.G_EXC_ERROR;
4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: WHEN OTHERS THEN
4549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');

Line 4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4543: EXCEPTION
4544: WHEN FND_API.G_EXC_ERROR THEN
4545: RAISE FND_API.G_EXC_ERROR;
4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: WHEN OTHERS THEN
4549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');
4551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');
4551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4552: FND_MSG_PUB.ADD;
4553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4554: END find_duplicate_party_sites;
4555:
4556: PROCEDURE find_duplicate_contacts (
4557: p_rule_id IN NUMBER,

Line 4633: WHEN FND_API.G_EXC_ERROR THEN

4629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4630: 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);
4631: END IF;
4632: EXCEPTION
4633: WHEN FND_API.G_EXC_ERROR THEN
4634: RAISE FND_API.G_EXC_ERROR;
4635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4637: WHEN OTHERS THEN

Line 4634: RAISE FND_API.G_EXC_ERROR;

4630: 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);
4631: END IF;
4632: EXCEPTION
4633: WHEN FND_API.G_EXC_ERROR THEN
4634: RAISE FND_API.G_EXC_ERROR;
4635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4637: WHEN OTHERS THEN
4638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4631: END IF;
4632: EXCEPTION
4633: WHEN FND_API.G_EXC_ERROR THEN
4634: RAISE FND_API.G_EXC_ERROR;
4635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4637: WHEN OTHERS THEN
4638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4639: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');

Line 4636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4632: EXCEPTION
4633: WHEN FND_API.G_EXC_ERROR THEN
4634: RAISE FND_API.G_EXC_ERROR;
4635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4637: WHEN OTHERS THEN
4638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4639: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');
4640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4639: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');
4640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4641: FND_MSG_PUB.ADD;
4642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4643: END find_duplicate_contacts;
4644:
4645: PROCEDURE find_duplicate_contact_points (
4646: p_rule_id IN NUMBER,

Line 4706: WHEN FND_API.G_EXC_ERROR THEN

4702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4703: 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);
4704: END IF;
4705: EXCEPTION
4706: WHEN FND_API.G_EXC_ERROR THEN
4707: RAISE FND_API.G_EXC_ERROR;
4708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: WHEN OTHERS THEN

Line 4707: RAISE FND_API.G_EXC_ERROR;

4703: 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);
4704: END IF;
4705: EXCEPTION
4706: WHEN FND_API.G_EXC_ERROR THEN
4707: RAISE FND_API.G_EXC_ERROR;
4708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: WHEN OTHERS THEN
4711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4704: END IF;
4705: EXCEPTION
4706: WHEN FND_API.G_EXC_ERROR THEN
4707: RAISE FND_API.G_EXC_ERROR;
4708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: WHEN OTHERS THEN
4711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4712: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');

Line 4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4705: EXCEPTION
4706: WHEN FND_API.G_EXC_ERROR THEN
4707: RAISE FND_API.G_EXC_ERROR;
4708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: WHEN OTHERS THEN
4711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4712: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');
4713: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4712: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');
4713: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4714: FND_MSG_PUB.ADD;
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: END find_duplicate_contact_points;
4717:
4718: PROCEDURE find_parties_dynamic (
4719: p_rule_id IN NUMBER,

Line 5059: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5060: RAISE FND_API.G_EXC_ERROR;

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

Line 5061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.call_api_dynamic');
5066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5067: FND_MSG_PUB.ADD;
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: END call_api_dynamic;
5070:
5071:
5072: 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_8.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_8.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_8.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_8.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_8.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_8.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 5674: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5675: RAISE FND_API.G_EXC_ERROR;

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

Line 5676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5903: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5904: RAISE FND_API.G_EXC_ERROR;

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

Line 5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6026: WHEN FND_API.G_EXC_ERROR THEN

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

Line 6027: RAISE FND_API.G_EXC_ERROR;

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

Line 6028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 6029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6078: WHEN FND_API.G_EXC_ERROR THEN

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

Line 6079: RAISE FND_API.G_EXC_ERROR;

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

Line 6080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 6081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6139: RAISE FND_API.G_EXC_ERROR;

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

Line 6199: RAISE FND_API.G_EXC_ERROR;

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

Line 6257: RAISE FND_API.G_EXC_ERROR;

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

Line 6315: RAISE FND_API.G_EXC_ERROR;

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

Line 6433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6430: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6434: END;
6435:
6436:
6437: /************************************************

Line 6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6715: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6716: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6718: FND_MSG_PUB.ADD;
6719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6720: END;
6721:
6722:
6723: /************************************************

Line 6876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6872: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6873: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6874: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6875: FND_MSG_PUB.ADD;
6876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6877: END;
6878:
6879:
6880: /************************************************

Line 6902: RAISE FND_API.G_EXC_ERROR;

6898: OR p_contact_point_list(I).URL IS NOT NULL
6899: ) THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6901: FND_MSG_PUB.ADD;
6902: RAISE FND_API.G_EXC_ERROR;
6903: END IF;
6904: END LOOP;
6905:
6906: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN

Line 6954: WHEN FND_API.G_EXC_ERROR THEN

6950: END IF;
6951: END LOOP;
6952: RETURN FALSE;
6953: EXCEPTION
6954: WHEN FND_API.G_EXC_ERROR THEN
6955: RAISE FND_API.G_EXC_ERROR;
6956: WHEN OTHERS THEN
6957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6958: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6955: RAISE FND_API.G_EXC_ERROR;

6951: END LOOP;
6952: RETURN FALSE;
6953: EXCEPTION
6954: WHEN FND_API.G_EXC_ERROR THEN
6955: RAISE FND_API.G_EXC_ERROR;
6956: WHEN OTHERS THEN
6957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6958: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6958: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6960: FND_MSG_PUB.ADD;
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: END check_prim_cond;
6963:
6964: /************************************************
6965: This procedure checks if the input search condition

Line 7023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7020: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7022: FND_MSG_PUB.ADD;
7023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7024: END check_party_site_cond;
7025:
7026: /************************************************
7027: This procedure checks if the input search condition

Line 7081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7078: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7079: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7080: FND_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7082: END check_contact_cond;
7083:
7084: /************************************************
7085: This procedure checks if the input search condition

Line 7102: RAISE FND_API.G_EXC_ERROR;

7098: FOR I IN 1..p_contact_point_list.COUNT LOOP
7099: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7100: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7101: FND_MSG_PUB.ADD;
7102: RAISE FND_API.G_EXC_ERROR;
7103: END IF;
7104: END LOOP;
7105:
7106: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7127: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7129: FND_MSG_PUB.ADD;
7130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7131: END check_contact_point_cond;
7132:
7133: FUNCTION check_staged RETURN BOOLEAN IS
7134: