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_51 dependencies on FND_API

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
66: FND_MESSAGE.SET_TOKEN('PROC','check_parties_bulk');
67: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
68: FND_MSG_PUB.ADD;
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END check_parties_bulk ;
71:
72: /************************************************
73: This procedure checks if the input search condition

Line 99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

95: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
96: FND_MESSAGE.SET_TOKEN('PROC','check_party_sites_bulk');
97: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
98: FND_MSG_PUB.ADD;
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100: END check_party_sites_bulk ;
101:
102: /************************************************
103: This procedure checks if the input search condition

Line 124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
121: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
123: FND_MSG_PUB.ADD;
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END check_contacts_bulk ;
126:
127: /************************************************
128: This procedure checks if the input search condition

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
151: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
153: FND_MSG_PUB.ADD;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END check_cpts_bulk ;
156:
157: FUNCTION map_id (in_id NUMBER) RETURN NUMBER IS
158: l_newidx NUMBER;

Line 739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

735: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
736: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
737: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END;
741:
742:
743: /************************************************

Line 764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

760: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
761: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: END;
766:
767:
768: /************************************************

Line 784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

780: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
781: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
783: FND_MSG_PUB.ADD;
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END;
786:
787:
788: /************************************************

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
801: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
802: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
803: FND_MSG_PUB.ADD;
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END;
806:
807: PROCEDURE init_score_context (
808: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 860: RAISE FND_API.G_EXC_ERROR;

856: p_contact_list,
857: p_contact_point_list) THEN
858: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: HZ_DQM_SEARCH_UTIL.set_score;
863: g_mappings.DELETE;
864: g_party_site_stage_list.DELETE;

Line 1040: RAISE FND_API.G_EXC_ERROR;

1036: when others then
1037: if (instrb(SQLERRM,'DRG-51030')>0) then
1038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;
1041: else
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: end if;
1044: END;

Line 1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;
1041: else
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: end if;
1044: END;
1045:
1046: PROCEDURE open_party_site_cursor(

Line 1136: RAISE FND_API.G_EXC_ERROR;

1132: when others then
1133: if (instrb(SQLERRM,'DRG-51030')>0) then
1134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1135: FND_MSG_PUB.ADD;
1136: RAISE FND_API.G_EXC_ERROR;
1137: else
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: end if;
1140: END;

Line 1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1135: FND_MSG_PUB.ADD;
1136: RAISE FND_API.G_EXC_ERROR;
1137: else
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: end if;
1140: END;
1141:
1142: PROCEDURE open_contact_cursor(

Line 1268: RAISE FND_API.G_EXC_ERROR;

1264: when others then
1265: if (instrb(SQLERRM,'DRG-51030')>0) then
1266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1267: FND_MSG_PUB.ADD;
1268: RAISE FND_API.G_EXC_ERROR;
1269: else
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: end if;
1272: END;

Line 1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1267: FND_MSG_PUB.ADD;
1268: RAISE FND_API.G_EXC_ERROR;
1269: else
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: end if;
1272: END;
1273:
1274: FUNCTION get_new_score_rec (

Line 1480: RAISE FND_API.G_EXC_ERROR;

1476: 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);
1477: END IF;
1478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1479: FND_MSG_PUB.ADD;
1480: RAISE FND_API.G_EXC_ERROR;
1481: ELSE
1482: push_eval;
1483: RETURN;
1484: END IF;

Line 1549: RAISE FND_API.G_EXC_ERROR;

1545: 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);
1546: END IF;
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: ELSE
1551: push_eval;
1552: RETURN;
1553: END IF;

Line 1625: RAISE FND_API.G_EXC_ERROR;

1621: 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);
1622: END IF;
1623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1624: FND_MSG_PUB.ADD;
1625: RAISE FND_API.G_EXC_ERROR;
1626: ELSE
1627: push_eval;
1628: RETURN;
1629: END IF;

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697: 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);
1698: END IF;
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: ELSE
1703: push_eval;
1704: RETURN;
1705: END IF;

Line 1745: RAISE FND_API.G_EXC_ERROR;

1741: 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);
1742: END IF;
1743: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1744: FND_MSG_PUB.ADD;
1745: RAISE FND_API.G_EXC_ERROR;
1746: END IF;
1747: END IF;
1748: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
1749: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 1923: WHEN FND_API.G_EXC_ERROR THEN

1919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1920: hz_utility_v2pub.debug(p_message=>'find_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1921: END IF;
1922: EXCEPTION
1923: WHEN FND_API.G_EXC_ERROR THEN
1924: ROLLBACK to find_parties;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1927: ROLLBACK to find_parties;

Line 1925: RAISE FND_API.G_EXC_ERROR;

1921: END IF;
1922: EXCEPTION
1923: WHEN FND_API.G_EXC_ERROR THEN
1924: ROLLBACK to find_parties;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1927: ROLLBACK to find_parties;
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: WHEN OTHERS THEN

Line 1926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1922: EXCEPTION
1923: WHEN FND_API.G_EXC_ERROR THEN
1924: ROLLBACK to find_parties;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1927: ROLLBACK to find_parties;
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: WHEN OTHERS THEN
1930: ROLLBACK to find_parties;

Line 1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1924: ROLLBACK to find_parties;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1927: ROLLBACK to find_parties;
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: WHEN OTHERS THEN
1930: ROLLBACK to find_parties;
1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_parties');

Line 1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_parties');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END find_parties;
1937:
1938: -------------------------------------------------------------------------------------
1939: -------------------- BULK MATCH RULE ::: find_persons ------------------------------

Line 2141: RAISE FND_API.G_EXC_ERROR;

2137: 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);
2138: END IF;
2139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2140: FND_MSG_PUB.ADD;
2141: RAISE FND_API.G_EXC_ERROR;
2142: ELSE
2143: push_eval;
2144: RETURN;
2145: END IF;

Line 2177: RAISE FND_API.G_EXC_ERROR;

2173: when others then
2174: if (instrb(SQLERRM,'DRG-51030')>0) then
2175: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2176: FND_MSG_PUB.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2180: FND_MSG_PUB.ADD;
2181: RAISE FND_API.G_EXC_ERROR;

Line 2181: RAISE FND_API.G_EXC_ERROR;

2177: RAISE FND_API.G_EXC_ERROR;
2178: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2180: FND_MSG_PUB.ADD;
2181: RAISE FND_API.G_EXC_ERROR;
2182: else
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: end if;
2185: END;

Line 2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2180: FND_MSG_PUB.ADD;
2181: RAISE FND_API.G_EXC_ERROR;
2182: else
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: end if;
2185: END;
2186:
2187: /** Private procedure to acquire and score at party site level ***/

Line 2257: RAISE FND_API.G_EXC_ERROR;

2253: 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);
2254: END IF;
2255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;
2258: ELSE
2259: push_eval;
2260: RETURN;
2261: END IF;

Line 2394: RAISE FND_API.G_EXC_ERROR;

2390: 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);
2391: END IF;
2392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2393: FND_MSG_PUB.ADD;
2394: RAISE FND_API.G_EXC_ERROR;
2395: ELSE
2396: push_eval;
2397: RETURN;
2398: END IF;

Line 2443: RAISE FND_API.G_EXC_ERROR;

2439: 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);
2440: END IF;
2441: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2442: FND_MSG_PUB.ADD;
2443: RAISE FND_API.G_EXC_ERROR;
2444: END IF;
2445: END IF;
2446: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2447: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2575: WHEN FND_API.G_EXC_ERROR THEN

2571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2572: hz_utility_v2pub.debug(p_message=>'find_persons(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2573: END IF;
2574: EXCEPTION
2575: WHEN FND_API.G_EXC_ERROR THEN
2576: ROLLBACK to find_persons;
2577: RAISE FND_API.G_EXC_ERROR;
2578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2579: ROLLBACK to find_persons;

Line 2577: RAISE FND_API.G_EXC_ERROR;

2573: END IF;
2574: EXCEPTION
2575: WHEN FND_API.G_EXC_ERROR THEN
2576: ROLLBACK to find_persons;
2577: RAISE FND_API.G_EXC_ERROR;
2578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2579: ROLLBACK to find_persons;
2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: WHEN OTHERS THEN

Line 2578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2574: EXCEPTION
2575: WHEN FND_API.G_EXC_ERROR THEN
2576: ROLLBACK to find_persons;
2577: RAISE FND_API.G_EXC_ERROR;
2578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2579: ROLLBACK to find_persons;
2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: WHEN OTHERS THEN
2582: ROLLBACK to find_persons;

Line 2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2576: ROLLBACK to find_persons;
2577: RAISE FND_API.G_EXC_ERROR;
2578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2579: ROLLBACK to find_persons;
2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: WHEN OTHERS THEN
2582: ROLLBACK to find_persons;
2583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2584: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_persons');

Line 2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2584: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_persons');
2585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2586: FND_MSG_PUB.ADD;
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END find_persons;
2589: PROCEDURE find_persons (
2590: p_rule_id IN NUMBER,
2591: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

Line 2648: WHEN FND_API.G_EXC_ERROR THEN

2644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2645: 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);
2646: END IF;
2647: EXCEPTION
2648: WHEN FND_API.G_EXC_ERROR THEN
2649: RAISE FND_API.G_EXC_ERROR;
2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: WHEN OTHERS THEN

Line 2649: RAISE FND_API.G_EXC_ERROR;

2645: 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);
2646: END IF;
2647: EXCEPTION
2648: WHEN FND_API.G_EXC_ERROR THEN
2649: RAISE FND_API.G_EXC_ERROR;
2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: WHEN OTHERS THEN
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2646: END IF;
2647: EXCEPTION
2648: WHEN FND_API.G_EXC_ERROR THEN
2649: RAISE FND_API.G_EXC_ERROR;
2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: WHEN OTHERS THEN
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');

Line 2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2647: EXCEPTION
2648: WHEN FND_API.G_EXC_ERROR THEN
2649: RAISE FND_API.G_EXC_ERROR;
2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: WHEN OTHERS THEN
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');
2655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');
2655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2656: FND_MSG_PUB.ADD;
2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2658: END find_party_details;
2659:
2660: -------------------------------------------------------------------------------------
2661: -------------------- BULK MATCH RULE ::: find_duplicate_parties -------------------

Line 2736: WHEN FND_API.G_EXC_ERROR THEN

2732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2733: 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);
2734: END IF;
2735: EXCEPTION
2736: WHEN FND_API.G_EXC_ERROR THEN
2737: RAISE FND_API.G_EXC_ERROR;
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: WHEN OTHERS THEN

Line 2737: RAISE FND_API.G_EXC_ERROR;

2733: 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);
2734: END IF;
2735: EXCEPTION
2736: WHEN FND_API.G_EXC_ERROR THEN
2737: RAISE FND_API.G_EXC_ERROR;
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: WHEN OTHERS THEN
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2734: END IF;
2735: EXCEPTION
2736: WHEN FND_API.G_EXC_ERROR THEN
2737: RAISE FND_API.G_EXC_ERROR;
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: WHEN OTHERS THEN
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');

Line 2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2735: EXCEPTION
2736: WHEN FND_API.G_EXC_ERROR THEN
2737: RAISE FND_API.G_EXC_ERROR;
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: WHEN OTHERS THEN
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');
2743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');
2743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2744: FND_MSG_PUB.ADD;
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2746: END find_duplicate_parties;
2747:
2748: -------------------------------------------------------------------------------------
2749: -------------------- BULK MATCH RULE ::: find_duplicate_party_sites-----------------

Line 2824: WHEN FND_API.G_EXC_ERROR THEN

2820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2821: 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);
2822: END IF;
2823: EXCEPTION
2824: WHEN FND_API.G_EXC_ERROR THEN
2825: RAISE FND_API.G_EXC_ERROR;
2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2828: WHEN OTHERS THEN

Line 2825: RAISE FND_API.G_EXC_ERROR;

2821: 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);
2822: END IF;
2823: EXCEPTION
2824: WHEN FND_API.G_EXC_ERROR THEN
2825: RAISE FND_API.G_EXC_ERROR;
2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2828: WHEN OTHERS THEN
2829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2822: END IF;
2823: EXCEPTION
2824: WHEN FND_API.G_EXC_ERROR THEN
2825: RAISE FND_API.G_EXC_ERROR;
2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2828: WHEN OTHERS THEN
2829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');

Line 2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2823: EXCEPTION
2824: WHEN FND_API.G_EXC_ERROR THEN
2825: RAISE FND_API.G_EXC_ERROR;
2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2828: WHEN OTHERS THEN
2829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');
2831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');
2831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2832: FND_MSG_PUB.ADD;
2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2834: END find_duplicate_party_sites;
2835:
2836: -------------------------------------------------------------------------------------
2837: -------------------- BULK MATCH RULE ::: find_duplicate_contacts--------------------

Line 2916: WHEN FND_API.G_EXC_ERROR THEN

2912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2913: 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);
2914: END IF;
2915: EXCEPTION
2916: WHEN FND_API.G_EXC_ERROR THEN
2917: RAISE FND_API.G_EXC_ERROR;
2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: WHEN OTHERS THEN

Line 2917: RAISE FND_API.G_EXC_ERROR;

2913: 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);
2914: END IF;
2915: EXCEPTION
2916: WHEN FND_API.G_EXC_ERROR THEN
2917: RAISE FND_API.G_EXC_ERROR;
2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: WHEN OTHERS THEN
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2914: END IF;
2915: EXCEPTION
2916: WHEN FND_API.G_EXC_ERROR THEN
2917: RAISE FND_API.G_EXC_ERROR;
2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: WHEN OTHERS THEN
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');

Line 2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2915: EXCEPTION
2916: WHEN FND_API.G_EXC_ERROR THEN
2917: RAISE FND_API.G_EXC_ERROR;
2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: WHEN OTHERS THEN
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');
2923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');
2923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2924: FND_MSG_PUB.ADD;
2925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2926: END find_duplicate_contacts;
2927:
2928: -------------------------------------------------------------------------------------
2929: -------------------- BULK MATCH RULE ::: find_duplicate_contact_points -------------

Line 2992: WHEN FND_API.G_EXC_ERROR THEN

2988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2989: 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);
2990: END IF;
2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN

Line 2993: RAISE FND_API.G_EXC_ERROR;

2989: 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);
2990: END IF;
2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2990: END IF;
2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contact_points');

Line 2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contact_points');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contact_points');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END find_duplicate_contact_points;
3003:
3004: -------------------------------------------------------------------------------------
3005: -------------------- BULK MATCH RULE ::: find_parties_dynamic-----------------------

Line 3331: WHEN FND_API.G_EXC_ERROR THEN

3327: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3328: 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);
3329: END IF;
3330: EXCEPTION
3331: WHEN FND_API.G_EXC_ERROR THEN
3332: RAISE FND_API.G_EXC_ERROR;
3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: WHEN OTHERS THEN

Line 3332: RAISE FND_API.G_EXC_ERROR;

3328: 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);
3329: END IF;
3330: EXCEPTION
3331: WHEN FND_API.G_EXC_ERROR THEN
3332: RAISE FND_API.G_EXC_ERROR;
3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: WHEN OTHERS THEN
3336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3329: END IF;
3330: EXCEPTION
3331: WHEN FND_API.G_EXC_ERROR THEN
3332: RAISE FND_API.G_EXC_ERROR;
3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: WHEN OTHERS THEN
3336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');

Line 3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3330: EXCEPTION
3331: WHEN FND_API.G_EXC_ERROR THEN
3332: RAISE FND_API.G_EXC_ERROR;
3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: WHEN OTHERS THEN
3336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');
3338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');
3338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3339: FND_MSG_PUB.ADD;
3340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3341: END call_api_dynamic;
3342:
3343: -------------------------------------------------------------------------------------
3344: -------------------- BULK MATCH RULE ::: get_matching_party_sites ------------------

Line 3555: WHEN FND_API.G_EXC_ERROR THEN

3551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3552: 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);
3553: END IF;
3554: EXCEPTION
3555: WHEN FND_API.G_EXC_ERROR THEN
3556: ROLLBACK to get_matching_party_sites ;
3557: RAISE FND_API.G_EXC_ERROR;
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: ROLLBACK to get_matching_party_sites ;

Line 3557: RAISE FND_API.G_EXC_ERROR;

3553: END IF;
3554: EXCEPTION
3555: WHEN FND_API.G_EXC_ERROR THEN
3556: ROLLBACK to get_matching_party_sites ;
3557: RAISE FND_API.G_EXC_ERROR;
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: ROLLBACK to get_matching_party_sites ;
3560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3561: WHEN OTHERS THEN

Line 3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3554: EXCEPTION
3555: WHEN FND_API.G_EXC_ERROR THEN
3556: ROLLBACK to get_matching_party_sites ;
3557: RAISE FND_API.G_EXC_ERROR;
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: ROLLBACK to get_matching_party_sites ;
3560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3561: WHEN OTHERS THEN
3562: ROLLBACK to get_matching_party_sites ;

Line 3560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3556: ROLLBACK to get_matching_party_sites ;
3557: RAISE FND_API.G_EXC_ERROR;
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: ROLLBACK to get_matching_party_sites ;
3560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3561: WHEN OTHERS THEN
3562: ROLLBACK to get_matching_party_sites ;
3563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_party_sites');

Line 3567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_party_sites');
3565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3566: FND_MSG_PUB.ADD;
3567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3568: END get_matching_party_sites;
3569:
3570: -------------------------------------------------------------------------------------
3571: -------------------- BULK MATCH RULE ::: get_matching_contacts --------------------

Line 3774: WHEN FND_API.G_EXC_ERROR THEN

3770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3771: 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);
3772: END IF;
3773: EXCEPTION
3774: WHEN FND_API.G_EXC_ERROR THEN
3775: ROLLBACK to get_matching_contacts ;
3776: RAISE FND_API.G_EXC_ERROR;
3777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3778: ROLLBACK to get_matching_contacts ;

Line 3776: RAISE FND_API.G_EXC_ERROR;

3772: END IF;
3773: EXCEPTION
3774: WHEN FND_API.G_EXC_ERROR THEN
3775: ROLLBACK to get_matching_contacts ;
3776: RAISE FND_API.G_EXC_ERROR;
3777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3778: ROLLBACK to get_matching_contacts ;
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: WHEN OTHERS THEN

Line 3777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3773: EXCEPTION
3774: WHEN FND_API.G_EXC_ERROR THEN
3775: ROLLBACK to get_matching_contacts ;
3776: RAISE FND_API.G_EXC_ERROR;
3777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3778: ROLLBACK to get_matching_contacts ;
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: WHEN OTHERS THEN
3781: ROLLBACK to get_matching_contacts ;

Line 3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3775: ROLLBACK to get_matching_contacts ;
3776: RAISE FND_API.G_EXC_ERROR;
3777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3778: ROLLBACK to get_matching_contacts ;
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: WHEN OTHERS THEN
3781: ROLLBACK to get_matching_contacts ;
3782: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3783: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contacts');

Line 3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3782: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3783: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contacts');
3784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3785: FND_MSG_PUB.ADD;
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3787: END get_matching_contacts;
3788:
3789: -------------------------------------------------------------------------------------
3790: -------------------- BULK MATCH RULE ::: get_matching_contact_points ---------------

Line 3921: WHEN FND_API.G_EXC_ERROR THEN

3917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3918: 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);
3919: END IF;
3920: EXCEPTION
3921: WHEN FND_API.G_EXC_ERROR THEN
3922: ROLLBACK to get_matching_contact_points ;
3923: RAISE FND_API.G_EXC_ERROR;
3924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3925: ROLLBACK to get_matching_contact_points ;

Line 3923: RAISE FND_API.G_EXC_ERROR;

3919: END IF;
3920: EXCEPTION
3921: WHEN FND_API.G_EXC_ERROR THEN
3922: ROLLBACK to get_matching_contact_points ;
3923: RAISE FND_API.G_EXC_ERROR;
3924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3925: ROLLBACK to get_matching_contact_points ;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: WHEN OTHERS THEN

Line 3924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3920: EXCEPTION
3921: WHEN FND_API.G_EXC_ERROR THEN
3922: ROLLBACK to get_matching_contact_points ;
3923: RAISE FND_API.G_EXC_ERROR;
3924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3925: ROLLBACK to get_matching_contact_points ;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: WHEN OTHERS THEN
3928: ROLLBACK to get_matching_contact_points ;

Line 3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3922: ROLLBACK to get_matching_contact_points ;
3923: RAISE FND_API.G_EXC_ERROR;
3924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3925: ROLLBACK to get_matching_contact_points ;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: WHEN OTHERS THEN
3928: ROLLBACK to get_matching_contact_points ;
3929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contact_points');

Line 3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contact_points');
3931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3932: FND_MSG_PUB.ADD;
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END get_matching_contact_points;
3935:
3936: /**********************************************************
3937: This procedure finds the score details for a specific party that

Line 4130: WHEN FND_API.G_EXC_ERROR THEN

4126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4127: 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);
4128: END IF;
4129: EXCEPTION
4130: WHEN FND_API.G_EXC_ERROR THEN
4131: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4132: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4133: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4134: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

Line 4136: RAISE FND_API.G_EXC_ERROR;

4132: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4133: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4134: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4135: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4136: RAISE FND_API.G_EXC_ERROR;
4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4138: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4140: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

Line 4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4133: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4134: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4135: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4136: RAISE FND_API.G_EXC_ERROR;
4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4138: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4140: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4141: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

Line 4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4140: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4141: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4142: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4144: WHEN OTHERS THEN
4145: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4146: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4147: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

Line 4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4153: FND_MSG_PUB.ADD;
4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4155: END get_score_details;
4156:
4157:
4158: /************************************************

Line 4252: WHEN FND_API.G_EXC_ERROR THEN

4248: END LOOP;
4249: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
4250: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4251: EXCEPTION
4252: WHEN FND_API.G_EXC_ERROR THEN
4253: RAISE FND_API.G_EXC_ERROR;
4254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256: WHEN OTHERS THEN

Line 4253: RAISE FND_API.G_EXC_ERROR;

4249: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
4250: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4251: EXCEPTION
4252: WHEN FND_API.G_EXC_ERROR THEN
4253: RAISE FND_API.G_EXC_ERROR;
4254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256: WHEN OTHERS THEN
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4250: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4251: EXCEPTION
4252: WHEN FND_API.G_EXC_ERROR THEN
4253: RAISE FND_API.G_EXC_ERROR;
4254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256: WHEN OTHERS THEN
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4258: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4251: EXCEPTION
4252: WHEN FND_API.G_EXC_ERROR THEN
4253: RAISE FND_API.G_EXC_ERROR;
4254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256: WHEN OTHERS THEN
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4258: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4258: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4260: FND_MSG_PUB.ADD;
4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4262: END get_party_for_search;
4263:
4264: PROCEDURE get_search_criteria (
4265: p_party_id IN NUMBER,

Line 4298: WHEN FND_API.G_EXC_ERROR THEN

4294: END IF;
4295: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
4296: END IF;
4297: EXCEPTION
4298: WHEN FND_API.G_EXC_ERROR THEN
4299: RAISE FND_API.G_EXC_ERROR;
4300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: WHEN OTHERS THEN

Line 4299: RAISE FND_API.G_EXC_ERROR;

4295: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
4296: END IF;
4297: EXCEPTION
4298: WHEN FND_API.G_EXC_ERROR THEN
4299: RAISE FND_API.G_EXC_ERROR;
4300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: WHEN OTHERS THEN
4303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4296: END IF;
4297: EXCEPTION
4298: WHEN FND_API.G_EXC_ERROR THEN
4299: RAISE FND_API.G_EXC_ERROR;
4300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: WHEN OTHERS THEN
4303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4304: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4297: EXCEPTION
4298: WHEN FND_API.G_EXC_ERROR THEN
4299: RAISE FND_API.G_EXC_ERROR;
4300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: WHEN OTHERS THEN
4303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4304: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4304: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4306: FND_MSG_PUB.ADD;
4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4308: END get_search_criteria;
4309:
4310:
4311: /************************************************

Line 4372: RAISE FND_API.G_EXC_ERROR;

4368: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4369: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4370: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4371: FND_MSG_PUB.ADD;
4372: RAISE FND_API.G_EXC_ERROR;
4373: END get_party_rec;
4374:
4375: /************************************************
4376: This procedure retrieves the match rule party site attributes into

Line 4434: RAISE FND_API.G_EXC_ERROR;

4430: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4431: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4432: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4433: FND_MSG_PUB.ADD;
4434: RAISE FND_API.G_EXC_ERROR;
4435: END get_party_site_rec;
4436:
4437: /************************************************
4438: This procedure retrieves the match rule contact attributes into

Line 4490: RAISE FND_API.G_EXC_ERROR;

4486: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4487: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;
4491: END get_contact_rec;
4492:
4493: /************************************************
4494: This procedure retrieves the match rule contact point attributes into

Line 4546: RAISE FND_API.G_EXC_ERROR;

4542: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4543: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4544: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4545: FND_MSG_PUB.ADD;
4546: RAISE FND_API.G_EXC_ERROR;
4547: END get_contact_point_rec;
4548:
4549: /************************************************
4550: This procedure maps a search record from the logical

Line 4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: END;
4651:
4652:
4653: /************************************************

Line 4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4803: END;
4804:
4805:
4806: /************************************************

Line 4844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4840: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4841: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
4842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4843: FND_MSG_PUB.ADD;
4844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4845: END;
4846:
4847:
4848: /************************************************

Line 4946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4942: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4943: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
4944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4945: FND_MSG_PUB.ADD;
4946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4947: END;
4948:
4949:
4950: /************************************************

Line 4971: RAISE FND_API.G_EXC_ERROR;

4967: OR p_contact_point_list(I).RAW_PHONE_NUMBER IS NOT NULL
4968: ) THEN
4969: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_ERROR;
4972: END IF;
4973: END LOOP;
4974:
4975: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 4998: WHEN FND_API.G_EXC_ERROR THEN

4994: END IF;
4995: END LOOP;
4996: RETURN FALSE;
4997: EXCEPTION
4998: WHEN FND_API.G_EXC_ERROR THEN
4999: RAISE FND_API.G_EXC_ERROR;
5000: WHEN OTHERS THEN
5001: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5002: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 4999: RAISE FND_API.G_EXC_ERROR;

4995: END LOOP;
4996: RETURN FALSE;
4997: EXCEPTION
4998: WHEN FND_API.G_EXC_ERROR THEN
4999: RAISE FND_API.G_EXC_ERROR;
5000: WHEN OTHERS THEN
5001: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5002: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5001: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5002: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5004: FND_MSG_PUB.ADD;
5005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5006: END check_prim_cond;
5007:
5008: /************************************************
5009: This procedure checks if the input search condition

Line 5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5059: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5060: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5061: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5062: FND_MSG_PUB.ADD;
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: END check_party_site_cond;
5065:
5066: /************************************************
5067: This procedure checks if the input search condition

Line 5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5107: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5108: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5110: FND_MSG_PUB.ADD;
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: END check_contact_cond;
5113:
5114: /************************************************
5115: This procedure checks if the input search condition

Line 5132: RAISE FND_API.G_EXC_ERROR;

5128: FOR I IN 1..p_contact_point_list.COUNT LOOP
5129: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5130: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5131: FND_MSG_PUB.ADD;
5132: RAISE FND_API.G_EXC_ERROR;
5133: END IF;
5134: END LOOP;
5135:
5136: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5155: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5157: FND_MSG_PUB.ADD;
5158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5159: END check_contact_point_cond;
5160:
5161: FUNCTION check_staged RETURN BOOLEAN IS
5162: