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

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

Line 1709: RAISE FND_API.G_EXC_ERROR;

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

Line 1713: RAISE FND_API.G_EXC_ERROR;

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

Line 1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1950: RAISE FND_API.G_EXC_ERROR;

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

Line 1954: RAISE FND_API.G_EXC_ERROR;

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

Line 1958: RAISE FND_API.G_EXC_ERROR;

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

Line 1963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2097: RAISE FND_API.G_EXC_ERROR;

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

Line 2101: RAISE FND_API.G_EXC_ERROR;

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

Line 2105: RAISE FND_API.G_EXC_ERROR;

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

Line 2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2370: RAISE FND_API.G_EXC_ERROR;

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

Line 2374: RAISE FND_API.G_EXC_ERROR;

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

Line 2378: RAISE FND_API.G_EXC_ERROR;

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

Line 2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2641: RAISE FND_API.G_EXC_ERROR;

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

Line 2689: RAISE FND_API.G_EXC_ERROR;

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

Line 2762: RAISE FND_API.G_EXC_ERROR;

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

Line 2874: RAISE FND_API.G_EXC_ERROR;

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

Line 2985: RAISE FND_API.G_EXC_ERROR;

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

Line 3210: RAISE FND_API.G_EXC_ERROR;

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

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

Line 3417: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3418: RAISE FND_API.G_EXC_ERROR;

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

Line 3419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3624: RAISE FND_API.G_EXC_ERROR;

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

Line 3672: RAISE FND_API.G_EXC_ERROR;

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

Line 3708: RAISE FND_API.G_EXC_ERROR;

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

Line 3712: RAISE FND_API.G_EXC_ERROR;

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

Line 3714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3784: RAISE FND_API.G_EXC_ERROR;

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

Line 4043: RAISE FND_API.G_EXC_ERROR;

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

Line 4156: RAISE FND_API.G_EXC_ERROR;

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

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

Line 4278: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4279: RAISE FND_API.G_EXC_ERROR;

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

Line 4280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4346: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4347: RAISE FND_API.G_EXC_ERROR;

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

Line 4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4463: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4464: RAISE FND_API.G_EXC_ERROR;

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

Line 4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4548: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4549: RAISE FND_API.G_EXC_ERROR;

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

Line 4550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4637: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4638: RAISE FND_API.G_EXC_ERROR;

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

Line 4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4710: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4711: RAISE FND_API.G_EXC_ERROR;

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

Line 4712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5063: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5064: RAISE FND_API.G_EXC_ERROR;

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

Line 5065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5306: WHEN FND_API.G_EXC_ERROR THEN

5302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5303: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5304: END IF;
5305: EXCEPTION
5306: WHEN FND_API.G_EXC_ERROR THEN
5307: RAISE FND_API.G_EXC_ERROR;
5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: WHEN OTHERS THEN

Line 5307: RAISE FND_API.G_EXC_ERROR;

5303: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5304: END IF;
5305: EXCEPTION
5306: WHEN FND_API.G_EXC_ERROR THEN
5307: RAISE FND_API.G_EXC_ERROR;
5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: WHEN OTHERS THEN
5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5535: WHEN FND_API.G_EXC_ERROR THEN

5531: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5532: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5533: END IF;
5534: EXCEPTION
5535: WHEN FND_API.G_EXC_ERROR THEN
5536: RAISE FND_API.G_EXC_ERROR;
5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN

Line 5536: RAISE FND_API.G_EXC_ERROR;

5532: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5533: END IF;
5534: EXCEPTION
5535: WHEN FND_API.G_EXC_ERROR THEN
5536: RAISE FND_API.G_EXC_ERROR;
5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5678: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5679: RAISE FND_API.G_EXC_ERROR;

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

Line 5680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5908: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5909: RAISE FND_API.G_EXC_ERROR;

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

Line 5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6031: WHEN FND_API.G_EXC_ERROR THEN

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

Line 6032: RAISE FND_API.G_EXC_ERROR;

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

Line 6033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 6034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6083: WHEN FND_API.G_EXC_ERROR THEN

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

Line 6084: RAISE FND_API.G_EXC_ERROR;

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

Line 6085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 6086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6144: RAISE FND_API.G_EXC_ERROR;

6140: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6141: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;
6144: RAISE FND_API.G_EXC_ERROR;
6145: END get_party_rec;
6146:
6147: /************************************************
6148: This procedure retrieves the match rule party site attributes into

Line 6204: RAISE FND_API.G_EXC_ERROR;

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

Line 6262: RAISE FND_API.G_EXC_ERROR;

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

Line 6320: RAISE FND_API.G_EXC_ERROR;

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

Line 6438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6434: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6435: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6436: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6437: FND_MSG_PUB.ADD;
6438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6439: END;
6440:
6441:
6442: /************************************************

Line 6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6720: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6721: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6723: FND_MSG_PUB.ADD;
6724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6725: END;
6726:
6727:
6728: /************************************************

Line 6881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6877: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6878: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6882: END;
6883:
6884:
6885: /************************************************

Line 6907: RAISE FND_API.G_EXC_ERROR;

6903: OR p_contact_point_list(I).URL IS NOT NULL
6904: ) THEN
6905: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6906: FND_MSG_PUB.ADD;
6907: RAISE FND_API.G_EXC_ERROR;
6908: END IF;
6909: END LOOP;
6910:
6911: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN

Line 6959: WHEN FND_API.G_EXC_ERROR THEN

6955: END IF;
6956: END LOOP;
6957: RETURN FALSE;
6958: EXCEPTION
6959: WHEN FND_API.G_EXC_ERROR THEN
6960: RAISE FND_API.G_EXC_ERROR;
6961: WHEN OTHERS THEN
6962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6963: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6960: RAISE FND_API.G_EXC_ERROR;

6956: END LOOP;
6957: RETURN FALSE;
6958: EXCEPTION
6959: WHEN FND_API.G_EXC_ERROR THEN
6960: RAISE FND_API.G_EXC_ERROR;
6961: WHEN OTHERS THEN
6962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6963: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6963: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6965: FND_MSG_PUB.ADD;
6966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6967: END check_prim_cond;
6968:
6969: /************************************************
6970: This procedure checks if the input search condition

Line 7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7024: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7025: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7027: FND_MSG_PUB.ADD;
7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7029: END check_party_site_cond;
7030:
7031: /************************************************
7032: This procedure checks if the input search condition

Line 7086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7083: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7085: FND_MSG_PUB.ADD;
7086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7087: END check_contact_cond;
7088:
7089: /************************************************
7090: This procedure checks if the input search condition

Line 7107: RAISE FND_API.G_EXC_ERROR;

7103: FOR I IN 1..p_contact_point_list.COUNT LOOP
7104: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7105: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7106: FND_MSG_PUB.ADD;
7107: RAISE FND_API.G_EXC_ERROR;
7108: END IF;
7109: END LOOP;
7110:
7111: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7132: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7134: FND_MSG_PUB.ADD;
7135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7136: END check_contact_point_cond;
7137:
7138: FUNCTION check_staged RETURN BOOLEAN IS
7139: