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

Line 72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
128: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
130: FND_MSG_PUB.ADD;
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END check_contacts_bulk ;
133:
134: /************************************************
135: This procedure checks if the input search condition

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
158: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
160: FND_MSG_PUB.ADD;
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END check_cpts_bulk ;
163:
164: FUNCTION map_id (in_id NUMBER) RETURN NUMBER IS
165: l_newidx NUMBER;

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
925: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END;
930:
931:
932: /************************************************

Line 948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

944: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
945: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
947: FND_MSG_PUB.ADD;
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END;
950:
951:
952: /************************************************

Line 968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

964: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
965: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
966: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
967: FND_MSG_PUB.ADD;
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: END;
970:
971: PROCEDURE init_score_context (
972: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1024: RAISE FND_API.G_EXC_ERROR;

1020: p_contact_list,
1021: p_contact_point_list) THEN
1022: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1023: FND_MSG_PUB.ADD;
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: HZ_DQM_SEARCH_UTIL.set_score;
1027: g_mappings.DELETE;
1028: g_party_site_stage_list.DELETE;

Line 1221: RAISE FND_API.G_EXC_ERROR;

1217: when others then
1218: if (instrb(SQLERRM,'DRG-51030')>0) then
1219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1220: FND_MSG_PUB.ADD;
1221: RAISE FND_API.G_EXC_ERROR;
1222: else
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: end if;
1225: END;

Line 1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1220: FND_MSG_PUB.ADD;
1221: RAISE FND_API.G_EXC_ERROR;
1222: else
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: end if;
1225: END;
1226:
1227: PROCEDURE open_party_site_cursor(

Line 1318: RAISE FND_API.G_EXC_ERROR;

1314: when others then
1315: if (instrb(SQLERRM,'DRG-51030')>0) then
1316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1317: FND_MSG_PUB.ADD;
1318: RAISE FND_API.G_EXC_ERROR;
1319: else
1320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1321: end if;
1322: END;

Line 1320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1317: FND_MSG_PUB.ADD;
1318: RAISE FND_API.G_EXC_ERROR;
1319: else
1320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1321: end if;
1322: END;
1323:
1324: PROCEDURE open_contact_cursor(

Line 1419: RAISE FND_API.G_EXC_ERROR;

1415: when others then
1416: if (instrb(SQLERRM,'DRG-51030')>0) then
1417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1418: FND_MSG_PUB.ADD;
1419: RAISE FND_API.G_EXC_ERROR;
1420: else
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: end if;
1423: END;

Line 1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1418: FND_MSG_PUB.ADD;
1419: RAISE FND_API.G_EXC_ERROR;
1420: else
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: end if;
1423: END;
1424:
1425: PROCEDURE open_contact_pt_cursor(

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: when others then
1537: if (instrb(SQLERRM,'DRG-51030')>0) then
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: else
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: end if;
1544: END;

Line 1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: else
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: end if;
1544: END;
1545:
1546: FUNCTION get_new_score_rec (

Line 1754: RAISE FND_API.G_EXC_ERROR;

1750: 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);
1751: END IF;
1752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1753: FND_MSG_PUB.ADD;
1754: RAISE FND_API.G_EXC_ERROR;
1755: ELSE
1756: push_eval;
1757: RETURN;
1758: END IF;

Line 1823: RAISE FND_API.G_EXC_ERROR;

1819: 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);
1820: END IF;
1821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1822: FND_MSG_PUB.ADD;
1823: RAISE FND_API.G_EXC_ERROR;
1824: ELSE
1825: push_eval;
1826: RETURN;
1827: END IF;

Line 1899: RAISE FND_API.G_EXC_ERROR;

1895: 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);
1896: END IF;
1897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1898: FND_MSG_PUB.ADD;
1899: RAISE FND_API.G_EXC_ERROR;
1900: ELSE
1901: push_eval;
1902: RETURN;
1903: END IF;

Line 1975: RAISE FND_API.G_EXC_ERROR;

1971: 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);
1972: END IF;
1973: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1974: FND_MSG_PUB.ADD;
1975: RAISE FND_API.G_EXC_ERROR;
1976: ELSE
1977: push_eval;
1978: RETURN;
1979: END IF;

Line 2019: RAISE FND_API.G_EXC_ERROR;

2015: 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);
2016: END IF;
2017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2018: FND_MSG_PUB.ADD;
2019: RAISE FND_API.G_EXC_ERROR;
2020: END IF;
2021: END IF;
2022: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2023: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2197: WHEN FND_API.G_EXC_ERROR THEN

2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2194: 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);
2195: END IF;
2196: EXCEPTION
2197: WHEN FND_API.G_EXC_ERROR THEN
2198: ROLLBACK to find_parties;
2199: RAISE FND_API.G_EXC_ERROR;
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: ROLLBACK to find_parties;

Line 2199: RAISE FND_API.G_EXC_ERROR;

2195: END IF;
2196: EXCEPTION
2197: WHEN FND_API.G_EXC_ERROR THEN
2198: ROLLBACK to find_parties;
2199: RAISE FND_API.G_EXC_ERROR;
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: ROLLBACK to find_parties;
2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2203: WHEN OTHERS THEN

Line 2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2196: EXCEPTION
2197: WHEN FND_API.G_EXC_ERROR THEN
2198: ROLLBACK to find_parties;
2199: RAISE FND_API.G_EXC_ERROR;
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: ROLLBACK to find_parties;
2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2203: WHEN OTHERS THEN
2204: ROLLBACK to find_parties;

Line 2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2198: ROLLBACK to find_parties;
2199: RAISE FND_API.G_EXC_ERROR;
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: ROLLBACK to find_parties;
2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2203: WHEN OTHERS THEN
2204: ROLLBACK to find_parties;
2205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_parties');

Line 2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_parties');
2207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2208: FND_MSG_PUB.ADD;
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END find_parties;
2211:
2212: -------------------------------------------------------------------------------------
2213: -------------------- BULK MATCH RULE ::: find_persons ------------------------------

Line 2417: RAISE FND_API.G_EXC_ERROR;

2413: 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);
2414: END IF;
2415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2416: FND_MSG_PUB.ADD;
2417: RAISE FND_API.G_EXC_ERROR;
2418: ELSE
2419: push_eval;
2420: RETURN;
2421: END IF;

Line 2453: RAISE FND_API.G_EXC_ERROR;

2449: when others then
2450: if (instrb(SQLERRM,'DRG-51030')>0) then
2451: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2452: FND_MSG_PUB.ADD;
2453: RAISE FND_API.G_EXC_ERROR;
2454: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2456: FND_MSG_PUB.ADD;
2457: RAISE FND_API.G_EXC_ERROR;

Line 2457: RAISE FND_API.G_EXC_ERROR;

2453: RAISE FND_API.G_EXC_ERROR;
2454: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2456: FND_MSG_PUB.ADD;
2457: RAISE FND_API.G_EXC_ERROR;
2458: else
2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2460: end if;
2461: END;

Line 2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2456: FND_MSG_PUB.ADD;
2457: RAISE FND_API.G_EXC_ERROR;
2458: else
2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2460: end if;
2461: END;
2462:
2463: /** Private procedure to acquire and score at party site level ***/

Line 2533: RAISE FND_API.G_EXC_ERROR;

2529: 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);
2530: END IF;
2531: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2532: FND_MSG_PUB.ADD;
2533: RAISE FND_API.G_EXC_ERROR;
2534: ELSE
2535: push_eval;
2536: RETURN;
2537: END IF;

Line 2670: RAISE FND_API.G_EXC_ERROR;

2666: 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);
2667: END IF;
2668: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2669: FND_MSG_PUB.ADD;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSE
2672: push_eval;
2673: RETURN;
2674: END IF;

Line 2719: RAISE FND_API.G_EXC_ERROR;

2715: 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);
2716: END IF;
2717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2718: FND_MSG_PUB.ADD;
2719: RAISE FND_API.G_EXC_ERROR;
2720: END IF;
2721: END IF;
2722: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2723: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2851: WHEN FND_API.G_EXC_ERROR THEN

2847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2848: 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);
2849: END IF;
2850: EXCEPTION
2851: WHEN FND_API.G_EXC_ERROR THEN
2852: ROLLBACK to find_persons;
2853: RAISE FND_API.G_EXC_ERROR;
2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2855: ROLLBACK to find_persons;

Line 2853: RAISE FND_API.G_EXC_ERROR;

2849: END IF;
2850: EXCEPTION
2851: WHEN FND_API.G_EXC_ERROR THEN
2852: ROLLBACK to find_persons;
2853: RAISE FND_API.G_EXC_ERROR;
2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2855: ROLLBACK to find_persons;
2856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2857: WHEN OTHERS THEN

Line 2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2850: EXCEPTION
2851: WHEN FND_API.G_EXC_ERROR THEN
2852: ROLLBACK to find_persons;
2853: RAISE FND_API.G_EXC_ERROR;
2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2855: ROLLBACK to find_persons;
2856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2857: WHEN OTHERS THEN
2858: ROLLBACK to find_persons;

Line 2856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2852: ROLLBACK to find_persons;
2853: RAISE FND_API.G_EXC_ERROR;
2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2855: ROLLBACK to find_persons;
2856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2857: WHEN OTHERS THEN
2858: ROLLBACK to find_persons;
2859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_persons');

Line 2863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_persons');
2861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2864: END find_persons;
2865: PROCEDURE find_persons (
2866: p_rule_id IN NUMBER,
2867: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,

Line 2924: WHEN FND_API.G_EXC_ERROR THEN

2920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2921: 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);
2922: END IF;
2923: EXCEPTION
2924: WHEN FND_API.G_EXC_ERROR THEN
2925: RAISE FND_API.G_EXC_ERROR;
2926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: WHEN OTHERS THEN

Line 2925: RAISE FND_API.G_EXC_ERROR;

2921: 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);
2922: END IF;
2923: EXCEPTION
2924: WHEN FND_API.G_EXC_ERROR THEN
2925: RAISE FND_API.G_EXC_ERROR;
2926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: WHEN OTHERS THEN
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2922: END IF;
2923: EXCEPTION
2924: WHEN FND_API.G_EXC_ERROR THEN
2925: RAISE FND_API.G_EXC_ERROR;
2926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: WHEN OTHERS THEN
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');

Line 2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2923: EXCEPTION
2924: WHEN FND_API.G_EXC_ERROR THEN
2925: RAISE FND_API.G_EXC_ERROR;
2926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: WHEN OTHERS THEN
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');
2931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');
2931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2934: END find_party_details;
2935:
2936: -------------------------------------------------------------------------------------
2937: -------------------- BULK MATCH RULE ::: find_duplicate_parties -------------------

Line 3012: WHEN FND_API.G_EXC_ERROR THEN

3008: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3009: 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);
3010: END IF;
3011: EXCEPTION
3012: WHEN FND_API.G_EXC_ERROR THEN
3013: RAISE FND_API.G_EXC_ERROR;
3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: WHEN OTHERS THEN

Line 3013: RAISE FND_API.G_EXC_ERROR;

3009: 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);
3010: END IF;
3011: EXCEPTION
3012: WHEN FND_API.G_EXC_ERROR THEN
3013: RAISE FND_API.G_EXC_ERROR;
3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: WHEN OTHERS THEN
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3010: END IF;
3011: EXCEPTION
3012: WHEN FND_API.G_EXC_ERROR THEN
3013: RAISE FND_API.G_EXC_ERROR;
3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: WHEN OTHERS THEN
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');

Line 3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3011: EXCEPTION
3012: WHEN FND_API.G_EXC_ERROR THEN
3013: RAISE FND_API.G_EXC_ERROR;
3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: WHEN OTHERS THEN
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');
3019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');
3019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3022: END find_duplicate_parties;
3023:
3024: -------------------------------------------------------------------------------------
3025: -------------------- BULK MATCH RULE ::: find_duplicate_party_sites-----------------

Line 3100: WHEN FND_API.G_EXC_ERROR THEN

3096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3097: 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);
3098: END IF;
3099: EXCEPTION
3100: WHEN FND_API.G_EXC_ERROR THEN
3101: RAISE FND_API.G_EXC_ERROR;
3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3104: WHEN OTHERS THEN

Line 3101: RAISE FND_API.G_EXC_ERROR;

3097: 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);
3098: END IF;
3099: EXCEPTION
3100: WHEN FND_API.G_EXC_ERROR THEN
3101: RAISE FND_API.G_EXC_ERROR;
3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3104: WHEN OTHERS THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3098: END IF;
3099: EXCEPTION
3100: WHEN FND_API.G_EXC_ERROR THEN
3101: RAISE FND_API.G_EXC_ERROR;
3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3104: WHEN OTHERS THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');

Line 3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3099: EXCEPTION
3100: WHEN FND_API.G_EXC_ERROR THEN
3101: RAISE FND_API.G_EXC_ERROR;
3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3104: WHEN OTHERS THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');
3107: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');
3107: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3108: FND_MSG_PUB.ADD;
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: END find_duplicate_party_sites;
3111:
3112: -------------------------------------------------------------------------------------
3113: -------------------- BULK MATCH RULE ::: find_duplicate_contacts--------------------

Line 3192: WHEN FND_API.G_EXC_ERROR THEN

3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: 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);
3190: END IF;
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: WHEN OTHERS THEN

Line 3193: RAISE FND_API.G_EXC_ERROR;

3189: 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);
3190: END IF;
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: WHEN OTHERS THEN
3197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3190: END IF;
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: WHEN OTHERS THEN
3197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');

Line 3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: WHEN OTHERS THEN
3197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');
3199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');
3199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3200: FND_MSG_PUB.ADD;
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END find_duplicate_contacts;
3203:
3204: -------------------------------------------------------------------------------------
3205: -------------------- BULK MATCH RULE ::: find_duplicate_contact_points -------------

Line 3268: WHEN FND_API.G_EXC_ERROR THEN

3264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3265: 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);
3266: END IF;
3267: EXCEPTION
3268: WHEN FND_API.G_EXC_ERROR THEN
3269: RAISE FND_API.G_EXC_ERROR;
3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3272: WHEN OTHERS THEN

Line 3269: RAISE FND_API.G_EXC_ERROR;

3265: 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);
3266: END IF;
3267: EXCEPTION
3268: WHEN FND_API.G_EXC_ERROR THEN
3269: RAISE FND_API.G_EXC_ERROR;
3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3272: WHEN OTHERS THEN
3273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3266: END IF;
3267: EXCEPTION
3268: WHEN FND_API.G_EXC_ERROR THEN
3269: RAISE FND_API.G_EXC_ERROR;
3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3272: WHEN OTHERS THEN
3273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');

Line 3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3267: EXCEPTION
3268: WHEN FND_API.G_EXC_ERROR THEN
3269: RAISE FND_API.G_EXC_ERROR;
3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3272: WHEN OTHERS THEN
3273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');
3275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');
3275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3276: FND_MSG_PUB.ADD;
3277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3278: END find_duplicate_contact_points;
3279:
3280: -------------------------------------------------------------------------------------
3281: -------------------- BULK MATCH RULE ::: find_parties_dynamic-----------------------

Line 3635: WHEN FND_API.G_EXC_ERROR THEN

3631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3632: 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);
3633: END IF;
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN

Line 3636: RAISE FND_API.G_EXC_ERROR;

3632: 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);
3633: END IF;
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3633: END IF;
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');

Line 3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END call_api_dynamic;
3646:
3647: -------------------------------------------------------------------------------------
3648: -------------------- BULK MATCH RULE ::: get_matching_party_sites ------------------

Line 3859: WHEN FND_API.G_EXC_ERROR THEN

3855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3856: 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);
3857: END IF;
3858: EXCEPTION
3859: WHEN FND_API.G_EXC_ERROR THEN
3860: ROLLBACK to get_matching_party_sites ;
3861: RAISE FND_API.G_EXC_ERROR;
3862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3863: ROLLBACK to get_matching_party_sites ;

Line 3861: RAISE FND_API.G_EXC_ERROR;

3857: END IF;
3858: EXCEPTION
3859: WHEN FND_API.G_EXC_ERROR THEN
3860: ROLLBACK to get_matching_party_sites ;
3861: RAISE FND_API.G_EXC_ERROR;
3862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3863: ROLLBACK to get_matching_party_sites ;
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN

Line 3862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3858: EXCEPTION
3859: WHEN FND_API.G_EXC_ERROR THEN
3860: ROLLBACK to get_matching_party_sites ;
3861: RAISE FND_API.G_EXC_ERROR;
3862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3863: ROLLBACK to get_matching_party_sites ;
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: ROLLBACK to get_matching_party_sites ;

Line 3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3860: ROLLBACK to get_matching_party_sites ;
3861: RAISE FND_API.G_EXC_ERROR;
3862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3863: ROLLBACK to get_matching_party_sites ;
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: ROLLBACK to get_matching_party_sites ;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_party_sites');

Line 3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_party_sites');
3869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END get_matching_party_sites;
3873:
3874: -------------------------------------------------------------------------------------
3875: -------------------- BULK MATCH RULE ::: get_matching_contacts --------------------

Line 4081: WHEN FND_API.G_EXC_ERROR THEN

4077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4078: 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);
4079: END IF;
4080: EXCEPTION
4081: WHEN FND_API.G_EXC_ERROR THEN
4082: ROLLBACK to get_matching_contacts ;
4083: RAISE FND_API.G_EXC_ERROR;
4084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4085: ROLLBACK to get_matching_contacts ;

Line 4083: RAISE FND_API.G_EXC_ERROR;

4079: END IF;
4080: EXCEPTION
4081: WHEN FND_API.G_EXC_ERROR THEN
4082: ROLLBACK to get_matching_contacts ;
4083: RAISE FND_API.G_EXC_ERROR;
4084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4085: ROLLBACK to get_matching_contacts ;
4086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4087: WHEN OTHERS THEN

Line 4084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4080: EXCEPTION
4081: WHEN FND_API.G_EXC_ERROR THEN
4082: ROLLBACK to get_matching_contacts ;
4083: RAISE FND_API.G_EXC_ERROR;
4084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4085: ROLLBACK to get_matching_contacts ;
4086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4087: WHEN OTHERS THEN
4088: ROLLBACK to get_matching_contacts ;

Line 4086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4082: ROLLBACK to get_matching_contacts ;
4083: RAISE FND_API.G_EXC_ERROR;
4084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4085: ROLLBACK to get_matching_contacts ;
4086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4087: WHEN OTHERS THEN
4088: ROLLBACK to get_matching_contacts ;
4089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4090: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contacts');

Line 4093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4090: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contacts');
4091: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4092: FND_MSG_PUB.ADD;
4093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4094: END get_matching_contacts;
4095:
4096: -------------------------------------------------------------------------------------
4097: -------------------- BULK MATCH RULE ::: get_matching_contact_points ---------------

Line 4228: WHEN FND_API.G_EXC_ERROR THEN

4224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4225: 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);
4226: END IF;
4227: EXCEPTION
4228: WHEN FND_API.G_EXC_ERROR THEN
4229: ROLLBACK to get_matching_contact_points ;
4230: RAISE FND_API.G_EXC_ERROR;
4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: ROLLBACK to get_matching_contact_points ;

Line 4230: RAISE FND_API.G_EXC_ERROR;

4226: END IF;
4227: EXCEPTION
4228: WHEN FND_API.G_EXC_ERROR THEN
4229: ROLLBACK to get_matching_contact_points ;
4230: RAISE FND_API.G_EXC_ERROR;
4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: ROLLBACK to get_matching_contact_points ;
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: WHEN OTHERS THEN

Line 4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4227: EXCEPTION
4228: WHEN FND_API.G_EXC_ERROR THEN
4229: ROLLBACK to get_matching_contact_points ;
4230: RAISE FND_API.G_EXC_ERROR;
4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: ROLLBACK to get_matching_contact_points ;
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: WHEN OTHERS THEN
4235: ROLLBACK to get_matching_contact_points ;

Line 4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4229: ROLLBACK to get_matching_contact_points ;
4230: RAISE FND_API.G_EXC_ERROR;
4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: ROLLBACK to get_matching_contact_points ;
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: WHEN OTHERS THEN
4235: ROLLBACK to get_matching_contact_points ;
4236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4237: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contact_points');

Line 4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4237: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contact_points');
4238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4239: FND_MSG_PUB.ADD;
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: END get_matching_contact_points;
4242:
4243: /**********************************************************
4244: This procedure finds the score details for a specific party that

Line 4444: WHEN FND_API.G_EXC_ERROR THEN

4440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4441: 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);
4442: END IF;
4443: EXCEPTION
4444: WHEN FND_API.G_EXC_ERROR THEN
4445: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4446: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4447: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4448: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

Line 4450: RAISE FND_API.G_EXC_ERROR;

4446: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4447: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4448: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4449: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4450: RAISE FND_API.G_EXC_ERROR;
4451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4452: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4453: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4454: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

Line 4451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4447: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4448: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4449: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4450: RAISE FND_API.G_EXC_ERROR;
4451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4452: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4453: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4454: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4455: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;

Line 4457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4453: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4454: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4455: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4456: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4458: WHEN OTHERS THEN
4459: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4460: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4461: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;

Line 4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_score_details');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END get_score_details;
4470:
4471:
4472: /************************************************

Line 4578: WHEN FND_API.G_EXC_ERROR THEN

4574: END LOOP;
4575: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
4576: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4577: EXCEPTION
4578: WHEN FND_API.G_EXC_ERROR THEN
4579: RAISE FND_API.G_EXC_ERROR;
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: WHEN OTHERS THEN

Line 4579: RAISE FND_API.G_EXC_ERROR;

4575: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
4576: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4577: EXCEPTION
4578: WHEN FND_API.G_EXC_ERROR THEN
4579: RAISE FND_API.G_EXC_ERROR;
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: WHEN OTHERS THEN
4583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4576: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
4577: EXCEPTION
4578: WHEN FND_API.G_EXC_ERROR THEN
4579: RAISE FND_API.G_EXC_ERROR;
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: WHEN OTHERS THEN
4583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4584: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4577: EXCEPTION
4578: WHEN FND_API.G_EXC_ERROR THEN
4579: RAISE FND_API.G_EXC_ERROR;
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: WHEN OTHERS THEN
4583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4584: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4584: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4588: END get_party_for_search;
4589:
4590: PROCEDURE get_search_criteria (
4591: p_party_id IN NUMBER,

Line 4630: WHEN FND_API.G_EXC_ERROR THEN

4626: END IF;
4627: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
4628: END IF;
4629: EXCEPTION
4630: WHEN FND_API.G_EXC_ERROR THEN
4631: RAISE FND_API.G_EXC_ERROR;
4632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: WHEN OTHERS THEN

Line 4631: RAISE FND_API.G_EXC_ERROR;

4627: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
4628: END IF;
4629: EXCEPTION
4630: WHEN FND_API.G_EXC_ERROR THEN
4631: RAISE FND_API.G_EXC_ERROR;
4632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: WHEN OTHERS THEN
4635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4628: END IF;
4629: EXCEPTION
4630: WHEN FND_API.G_EXC_ERROR THEN
4631: RAISE FND_API.G_EXC_ERROR;
4632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: WHEN OTHERS THEN
4635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4636: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4629: EXCEPTION
4630: WHEN FND_API.G_EXC_ERROR THEN
4631: RAISE FND_API.G_EXC_ERROR;
4632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: WHEN OTHERS THEN
4635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4636: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4636: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4638: FND_MSG_PUB.ADD;
4639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4640: END get_search_criteria;
4641:
4642:
4643: /************************************************

Line 4708: RAISE FND_API.G_EXC_ERROR;

4704: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4705: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4707: FND_MSG_PUB.ADD;
4708: RAISE FND_API.G_EXC_ERROR;
4709: END get_party_rec;
4710:
4711: /************************************************
4712: This procedure retrieves the match rule party site attributes into

Line 4770: RAISE FND_API.G_EXC_ERROR;

4766: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4767: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4769: FND_MSG_PUB.ADD;
4770: RAISE FND_API.G_EXC_ERROR;
4771: END get_party_site_rec;
4772:
4773: /************************************************
4774: This procedure retrieves the match rule contact attributes into

Line 4830: RAISE FND_API.G_EXC_ERROR;

4826: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4827: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4829: FND_MSG_PUB.ADD;
4830: RAISE FND_API.G_EXC_ERROR;
4831: END get_contact_rec;
4832:
4833: /************************************************
4834: This procedure retrieves the match rule contact point attributes into

Line 4886: RAISE FND_API.G_EXC_ERROR;

4882: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4883: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4885: FND_MSG_PUB.ADD;
4886: RAISE FND_API.G_EXC_ERROR;
4887: END get_contact_point_rec;
4888:
4889: /************************************************
4890: This procedure maps a search record from the logical

Line 5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5010: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: END;
5016:
5017:
5018: /************************************************

Line 5167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5166: FND_MSG_PUB.ADD;
5167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5168: END;
5169:
5170:
5171: /************************************************

Line 5268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5264: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5265: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5266: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5267: FND_MSG_PUB.ADD;
5268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5269: END;
5270:
5271:
5272: /************************************************

Line 5393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5389: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5390: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5394: END;
5395:
5396:
5397: /************************************************

Line 5418: RAISE FND_API.G_EXC_ERROR;

5414: OR p_contact_point_list(I).RAW_PHONE_NUMBER IS NOT NULL
5415: ) THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5417: FND_MSG_PUB.ADD;
5418: RAISE FND_API.G_EXC_ERROR;
5419: END IF;
5420: END LOOP;
5421:
5422: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 5453: WHEN FND_API.G_EXC_ERROR THEN

5449: END IF;
5450: END LOOP;
5451: RETURN FALSE;
5452: EXCEPTION
5453: WHEN FND_API.G_EXC_ERROR THEN
5454: RAISE FND_API.G_EXC_ERROR;
5455: WHEN OTHERS THEN
5456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5457: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5454: RAISE FND_API.G_EXC_ERROR;

5450: END LOOP;
5451: RETURN FALSE;
5452: EXCEPTION
5453: WHEN FND_API.G_EXC_ERROR THEN
5454: RAISE FND_API.G_EXC_ERROR;
5455: WHEN OTHERS THEN
5456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5457: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5457: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5459: FND_MSG_PUB.ADD;
5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5461: END check_prim_cond;
5462:
5463: /************************************************
5464: This procedure checks if the input search condition

Line 5518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5514: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5515: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5516: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5517: FND_MSG_PUB.ADD;
5518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5519: END check_party_site_cond;
5520:
5521: /************************************************
5522: This procedure checks if the input search condition

Line 5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5572: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5574: FND_MSG_PUB.ADD;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5576: END check_contact_cond;
5577:
5578: /************************************************
5579: This procedure checks if the input search condition

Line 5596: RAISE FND_API.G_EXC_ERROR;

5592: FOR I IN 1..p_contact_point_list.COUNT LOOP
5593: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5594: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5595: FND_MSG_PUB.ADD;
5596: RAISE FND_API.G_EXC_ERROR;
5597: END IF;
5598: END LOOP;
5599:
5600: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5621: FND_MSG_PUB.ADD;
5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5623: END check_contact_point_cond;
5624:
5625: FUNCTION check_staged RETURN BOOLEAN IS
5626: