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

Line 102: RAISE FND_API.G_EXC_ERROR;

98: when others then
99: if (instrb(SQLERRM,'DRG-51030')>0) then
100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;

Line 106: RAISE FND_API.G_EXC_ERROR;

102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;
110: END;

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;
110: END;
111:
112:

Line 849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

845: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
846: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
848: FND_MSG_PUB.ADD;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END;
851:
852:
853: /************************************************

Line 874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

910: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
911: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END;
916:
917: PROCEDURE init_score_context (
918: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 981: RAISE FND_API.G_EXC_ERROR;

977: p_contact_list,
978: p_contact_point_list) THEN
979: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
984: hz_utility_v2pub.debug(p_message=>'In init_search calling util package set_score',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
985: END IF;

Line 1216: RAISE FND_API.G_EXC_ERROR;

1212: IF lengthb(l_party_contains_str) > 4000 THEN
1213: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1214: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1215: FND_MSG_PUB.ADD;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: IF (p_match_str = ' AND ' OR p_party_max_score 1219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1220: hz_utility_v2pub.debug(p_message=>'party contains string returned by init_search is an AND between these strings ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1335: RAISE FND_API.G_EXC_ERROR;

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

Line 1640: RAISE FND_API.G_EXC_ERROR;

1636: when others then
1637: if (instrb(SQLERRM,'DRG-51030')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;

Line 1644: RAISE FND_API.G_EXC_ERROR;

1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;

Line 1648: RAISE FND_API.G_EXC_ERROR;

1644: RAISE FND_API.G_EXC_ERROR;
1645: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: FND_MSG_PUB.ADD;

Line 1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: FND_MSG_PUB.ADD;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: end if;
1655: END;
1656:
1657: PROCEDURE open_party_site_cursor(

Line 1885: RAISE FND_API.G_EXC_ERROR;

1881: when others then
1882: if (instrb(SQLERRM,'DRG-51030')>0) then
1883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1884: FND_MSG_PUB.ADD;
1885: RAISE FND_API.G_EXC_ERROR;
1886: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1888: FND_MSG_PUB.ADD;
1889: RAISE FND_API.G_EXC_ERROR;

Line 1889: RAISE FND_API.G_EXC_ERROR;

1885: RAISE FND_API.G_EXC_ERROR;
1886: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1888: FND_MSG_PUB.ADD;
1889: RAISE FND_API.G_EXC_ERROR;
1890: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1892: FND_MSG_PUB.ADD;
1893: RAISE FND_API.G_EXC_ERROR;

Line 1893: RAISE FND_API.G_EXC_ERROR;

1889: RAISE FND_API.G_EXC_ERROR;
1890: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1892: FND_MSG_PUB.ADD;
1893: RAISE FND_API.G_EXC_ERROR;
1894: else
1895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1897: FND_MSG_PUB.ADD;

Line 1898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1894: else
1895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1899: end if;
1900: END;
1901:
1902: PROCEDURE open_contact_cursor(

Line 2032: RAISE FND_API.G_EXC_ERROR;

2028: when others then
2029: if (instrb(SQLERRM,'DRG-51030')>0) then
2030: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2031: FND_MSG_PUB.ADD;
2032: RAISE FND_API.G_EXC_ERROR;
2033: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2034: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2035: FND_MSG_PUB.ADD;
2036: RAISE FND_API.G_EXC_ERROR;

Line 2036: RAISE FND_API.G_EXC_ERROR;

2032: RAISE FND_API.G_EXC_ERROR;
2033: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2034: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2035: FND_MSG_PUB.ADD;
2036: RAISE FND_API.G_EXC_ERROR;
2037: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2039: FND_MSG_PUB.ADD;
2040: RAISE FND_API.G_EXC_ERROR;

Line 2040: RAISE FND_API.G_EXC_ERROR;

2036: RAISE FND_API.G_EXC_ERROR;
2037: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2039: FND_MSG_PUB.ADD;
2040: RAISE FND_API.G_EXC_ERROR;
2041: else
2042: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2044: FND_MSG_PUB.ADD;

Line 2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2041: else
2042: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2044: FND_MSG_PUB.ADD;
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: end if;
2047: END;
2048:
2049: PROCEDURE open_contact_pt_cursor(

Line 2305: RAISE FND_API.G_EXC_ERROR;

2301: when others then
2302: if (instrb(SQLERRM,'DRG-51030')>0) then
2303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2304: FND_MSG_PUB.ADD;
2305: RAISE FND_API.G_EXC_ERROR;
2306: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2308: FND_MSG_PUB.ADD;
2309: RAISE FND_API.G_EXC_ERROR;

Line 2309: RAISE FND_API.G_EXC_ERROR;

2305: RAISE FND_API.G_EXC_ERROR;
2306: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2308: FND_MSG_PUB.ADD;
2309: RAISE FND_API.G_EXC_ERROR;
2310: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.G_EXC_ERROR;

Line 2313: RAISE FND_API.G_EXC_ERROR;

2309: RAISE FND_API.G_EXC_ERROR;
2310: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.G_EXC_ERROR;
2314: else
2315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2316: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2317: FND_MSG_PUB.ADD;

Line 2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2314: else
2315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2316: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2317: FND_MSG_PUB.ADD;
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: end if;
2320: END;
2321:
2322:

Line 2576: RAISE FND_API.G_EXC_ERROR;

2572: 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);
2573: END IF;
2574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: ELSE
2578: push_eval;
2579: RETURN;
2580: END IF;

Line 2624: RAISE FND_API.G_EXC_ERROR;

2620: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2621: END IF;
2622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2623: FND_MSG_PUB.ADD;
2624: RAISE FND_API.G_EXC_ERROR;
2625: ELSE
2626: push_eval;
2627: RETURN;
2628: END IF;

Line 2697: RAISE FND_API.G_EXC_ERROR;

2693: 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);
2694: END IF;
2695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2696: FND_MSG_PUB.ADD;
2697: RAISE FND_API.G_EXC_ERROR;
2698: ELSE
2699: push_eval;
2700: RETURN;
2701: END IF;

Line 2809: RAISE FND_API.G_EXC_ERROR;

2805: 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);
2806: END IF;
2807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2808: FND_MSG_PUB.ADD;
2809: RAISE FND_API.G_EXC_ERROR;
2810: ELSE
2811: push_eval;
2812: RETURN;
2813: END IF;

Line 2920: RAISE FND_API.G_EXC_ERROR;

2916: 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);
2917: END IF;
2918: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2919: FND_MSG_PUB.ADD;
2920: RAISE FND_API.G_EXC_ERROR;
2921: ELSE
2922: push_eval;
2923: RETURN;
2924: END IF;

Line 3145: RAISE FND_API.G_EXC_ERROR;

3141: 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);
3142: END IF;
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_ERROR;
3146: END IF;
3147: ELSE
3148: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3149: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 3153: RAISE FND_API.G_EXC_ERROR;

3149: 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);
3150: END IF;
3151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: END IF;
3155: END IF;
3156: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3157: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3352: WHEN FND_API.G_EXC_ERROR THEN

3348: END IF;
3349: EXCEPTION
3350: WHEN L_RETURN_IMM_EXC THEN
3351: RETURN;
3352: WHEN FND_API.G_EXC_ERROR THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3356: WHEN OTHERS THEN

Line 3353: RAISE FND_API.G_EXC_ERROR;

3349: EXCEPTION
3350: WHEN L_RETURN_IMM_EXC THEN
3351: RETURN;
3352: WHEN FND_API.G_EXC_ERROR THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3356: WHEN OTHERS THEN
3357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3350: WHEN L_RETURN_IMM_EXC THEN
3351: RETURN;
3352: WHEN FND_API.G_EXC_ERROR THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3356: WHEN OTHERS THEN
3357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3358: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');

Line 3355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3351: RETURN;
3352: WHEN FND_API.G_EXC_ERROR THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3356: WHEN OTHERS THEN
3357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3358: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');
3359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3358: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');
3359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3360: FND_MSG_PUB.ADD;
3361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3362: END find_parties;
3363:
3364: PROCEDURE find_persons (
3365: p_rule_id IN NUMBER,

Line 3559: RAISE FND_API.G_EXC_ERROR;

3555: 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);
3556: END IF;
3557: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3558: FND_MSG_PUB.ADD;
3559: RAISE FND_API.G_EXC_ERROR;
3560: ELSE
3561: push_eval;
3562: RETURN;
3563: END IF;

Line 3607: RAISE FND_API.G_EXC_ERROR;

3603: 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);
3604: END IF;
3605: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3606: FND_MSG_PUB.ADD;
3607: RAISE FND_API.G_EXC_ERROR;
3608: ELSE
3609: push_eval;
3610: RETURN;
3611: END IF;

Line 3643: RAISE FND_API.G_EXC_ERROR;

3639: when others then
3640: if (instrb(SQLERRM,'DRG-51030')>0) then
3641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3642: FND_MSG_PUB.ADD;
3643: RAISE FND_API.G_EXC_ERROR;
3644: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;

Line 3647: RAISE FND_API.G_EXC_ERROR;

3643: RAISE FND_API.G_EXC_ERROR;
3644: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: else
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650: end if;
3651: END;

Line 3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: else
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650: end if;
3651: END;
3652:
3653: /** Private procedure to acquire and score at party site level ***/

Line 3719: RAISE FND_API.G_EXC_ERROR;

3715: 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);
3716: END IF;
3717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3718: FND_MSG_PUB.ADD;
3719: RAISE FND_API.G_EXC_ERROR;
3720: ELSE
3721: push_eval;
3722: RETURN;
3723: END IF;

Line 3978: RAISE FND_API.G_EXC_ERROR;

3974: 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);
3975: END IF;
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3977: FND_MSG_PUB.ADD;
3978: RAISE FND_API.G_EXC_ERROR;
3979: ELSE
3980: push_eval;
3981: RETURN;
3982: END IF;

Line 4091: RAISE FND_API.G_EXC_ERROR;

4087: 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);
4088: END IF;
4089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4090: FND_MSG_PUB.ADD;
4091: RAISE FND_API.G_EXC_ERROR;
4092: END IF;
4093: ELSE
4094: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4095: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4099: RAISE FND_API.G_EXC_ERROR;

4095: 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);
4096: END IF;
4097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4098: FND_MSG_PUB.ADD;
4099: RAISE FND_API.G_EXC_ERROR;
4100: END IF;
4101: END IF;
4102: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4103: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4213: WHEN FND_API.G_EXC_ERROR THEN

4209: END IF;
4210: EXCEPTION
4211: WHEN L_RETURN_IMM_EXC THEN
4212: RETURN;
4213: WHEN FND_API.G_EXC_ERROR THEN
4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN

Line 4214: RAISE FND_API.G_EXC_ERROR;

4210: EXCEPTION
4211: WHEN L_RETURN_IMM_EXC THEN
4212: RETURN;
4213: WHEN FND_API.G_EXC_ERROR THEN
4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4211: WHEN L_RETURN_IMM_EXC THEN
4212: RETURN;
4213: WHEN FND_API.G_EXC_ERROR THEN
4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');

Line 4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4212: RETURN;
4213: WHEN FND_API.G_EXC_ERROR THEN
4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4221: FND_MSG_PUB.ADD;
4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4223: END find_persons;
4224:
4225: PROCEDURE find_persons (
4226: p_rule_id IN NUMBER,

Line 4281: WHEN FND_API.G_EXC_ERROR THEN

4277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4278: 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);
4279: END IF;
4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN

Line 4282: RAISE FND_API.G_EXC_ERROR;

4278: 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);
4279: END IF;
4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4279: END IF;
4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');

Line 4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END find_party_details;
4292:
4293: PROCEDURE find_duplicate_parties (
4294: p_rule_id IN NUMBER,

Line 4398: WHEN FND_API.G_EXC_ERROR THEN

4394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4395: 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);
4396: END IF;
4397: EXCEPTION
4398: WHEN FND_API.G_EXC_ERROR THEN
4399: RAISE FND_API.G_EXC_ERROR;
4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: WHEN OTHERS THEN

Line 4399: RAISE FND_API.G_EXC_ERROR;

4395: 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);
4396: END IF;
4397: EXCEPTION
4398: WHEN FND_API.G_EXC_ERROR THEN
4399: RAISE FND_API.G_EXC_ERROR;
4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: WHEN OTHERS THEN
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4396: END IF;
4397: EXCEPTION
4398: WHEN FND_API.G_EXC_ERROR THEN
4399: RAISE FND_API.G_EXC_ERROR;
4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: WHEN OTHERS THEN
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4404: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');

Line 4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4397: EXCEPTION
4398: WHEN FND_API.G_EXC_ERROR THEN
4399: RAISE FND_API.G_EXC_ERROR;
4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: WHEN OTHERS THEN
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4404: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');
4405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4404: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');
4405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4406: FND_MSG_PUB.ADD;
4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4408: END find_duplicate_parties;
4409:
4410: PROCEDURE find_duplicate_party_sites (
4411: p_rule_id IN NUMBER,

Line 4483: WHEN FND_API.G_EXC_ERROR THEN

4479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4480: 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);
4481: END IF;
4482: EXCEPTION
4483: WHEN FND_API.G_EXC_ERROR THEN
4484: RAISE FND_API.G_EXC_ERROR;
4485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4487: WHEN OTHERS THEN

Line 4484: RAISE FND_API.G_EXC_ERROR;

4480: 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);
4481: END IF;
4482: EXCEPTION
4483: WHEN FND_API.G_EXC_ERROR THEN
4484: RAISE FND_API.G_EXC_ERROR;
4485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4487: WHEN OTHERS THEN
4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4481: END IF;
4482: EXCEPTION
4483: WHEN FND_API.G_EXC_ERROR THEN
4484: RAISE FND_API.G_EXC_ERROR;
4485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4487: WHEN OTHERS THEN
4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');

Line 4486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4482: EXCEPTION
4483: WHEN FND_API.G_EXC_ERROR THEN
4484: RAISE FND_API.G_EXC_ERROR;
4485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4487: WHEN OTHERS THEN
4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');
4490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');
4490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4491: FND_MSG_PUB.ADD;
4492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4493: END find_duplicate_party_sites;
4494:
4495: PROCEDURE find_duplicate_contacts (
4496: p_rule_id IN NUMBER,

Line 4572: WHEN FND_API.G_EXC_ERROR THEN

4568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4569: 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);
4570: END IF;
4571: EXCEPTION
4572: WHEN FND_API.G_EXC_ERROR THEN
4573: RAISE FND_API.G_EXC_ERROR;
4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: WHEN OTHERS THEN

Line 4573: RAISE FND_API.G_EXC_ERROR;

4569: 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);
4570: END IF;
4571: EXCEPTION
4572: WHEN FND_API.G_EXC_ERROR THEN
4573: RAISE FND_API.G_EXC_ERROR;
4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: WHEN OTHERS THEN
4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4570: END IF;
4571: EXCEPTION
4572: WHEN FND_API.G_EXC_ERROR THEN
4573: RAISE FND_API.G_EXC_ERROR;
4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: WHEN OTHERS THEN
4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4578: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');

Line 4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4571: EXCEPTION
4572: WHEN FND_API.G_EXC_ERROR THEN
4573: RAISE FND_API.G_EXC_ERROR;
4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: WHEN OTHERS THEN
4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4578: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4579: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4578: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4579: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4580: FND_MSG_PUB.ADD;
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: END find_duplicate_contacts;
4583:
4584: PROCEDURE find_duplicate_contact_points (
4585: p_rule_id IN NUMBER,

Line 4645: WHEN FND_API.G_EXC_ERROR THEN

4641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4642: 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);
4643: END IF;
4644: EXCEPTION
4645: WHEN FND_API.G_EXC_ERROR THEN
4646: RAISE FND_API.G_EXC_ERROR;
4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4649: WHEN OTHERS THEN

Line 4646: RAISE FND_API.G_EXC_ERROR;

4642: 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);
4643: END IF;
4644: EXCEPTION
4645: WHEN FND_API.G_EXC_ERROR THEN
4646: RAISE FND_API.G_EXC_ERROR;
4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4649: WHEN OTHERS THEN
4650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4643: END IF;
4644: EXCEPTION
4645: WHEN FND_API.G_EXC_ERROR THEN
4646: RAISE FND_API.G_EXC_ERROR;
4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4649: WHEN OTHERS THEN
4650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4651: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');

Line 4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4644: EXCEPTION
4645: WHEN FND_API.G_EXC_ERROR THEN
4646: RAISE FND_API.G_EXC_ERROR;
4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4649: WHEN OTHERS THEN
4650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4651: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4651: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4653: FND_MSG_PUB.ADD;
4654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4655: END find_duplicate_contact_points;
4656:
4657: PROCEDURE find_parties_dynamic (
4658: p_rule_id IN NUMBER,

Line 4947: WHEN FND_API.G_EXC_ERROR THEN

4943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4944: 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);
4945: END IF;
4946: EXCEPTION
4947: WHEN FND_API.G_EXC_ERROR THEN
4948: RAISE FND_API.G_EXC_ERROR;
4949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4951: WHEN OTHERS THEN

Line 4948: RAISE FND_API.G_EXC_ERROR;

4944: 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);
4945: END IF;
4946: EXCEPTION
4947: WHEN FND_API.G_EXC_ERROR THEN
4948: RAISE FND_API.G_EXC_ERROR;
4949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4951: WHEN OTHERS THEN
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4945: END IF;
4946: EXCEPTION
4947: WHEN FND_API.G_EXC_ERROR THEN
4948: RAISE FND_API.G_EXC_ERROR;
4949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4951: WHEN OTHERS THEN
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4953: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');

Line 4950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4946: EXCEPTION
4947: WHEN FND_API.G_EXC_ERROR THEN
4948: RAISE FND_API.G_EXC_ERROR;
4949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4951: WHEN OTHERS THEN
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4953: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4953: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4955: FND_MSG_PUB.ADD;
4956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4957: END call_api_dynamic;
4958:
4959:
4960: PROCEDURE get_matching_party_sites (

Line 5191: WHEN FND_API.G_EXC_ERROR THEN

5187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5188: 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);
5189: END IF;
5190: EXCEPTION
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: RAISE FND_API.G_EXC_ERROR;
5193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5195: WHEN OTHERS THEN

Line 5192: RAISE FND_API.G_EXC_ERROR;

5188: 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);
5189: END IF;
5190: EXCEPTION
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: RAISE FND_API.G_EXC_ERROR;
5193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5195: WHEN OTHERS THEN
5196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5189: END IF;
5190: EXCEPTION
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: RAISE FND_API.G_EXC_ERROR;
5193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5195: WHEN OTHERS THEN
5196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5197: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');

Line 5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5190: EXCEPTION
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: RAISE FND_API.G_EXC_ERROR;
5193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5195: WHEN OTHERS THEN
5196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5197: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5197: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5199: FND_MSG_PUB.ADD;
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: END get_matching_party_sites;
5202:
5203:
5204: PROCEDURE get_matching_contacts (

Line 5416: WHEN FND_API.G_EXC_ERROR THEN

5412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5413: 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);
5414: END IF;
5415: EXCEPTION
5416: WHEN FND_API.G_EXC_ERROR THEN
5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN

Line 5417: RAISE FND_API.G_EXC_ERROR;

5413: 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);
5414: END IF;
5415: EXCEPTION
5416: WHEN FND_API.G_EXC_ERROR THEN
5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5414: END IF;
5415: EXCEPTION
5416: WHEN FND_API.G_EXC_ERROR THEN
5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contacts');

Line 5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5415: EXCEPTION
5416: WHEN FND_API.G_EXC_ERROR THEN
5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contacts');
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contacts');
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5426: END get_matching_contacts;
5427:
5428:
5429: PROCEDURE get_matching_contact_points (

Line 5555: WHEN FND_API.G_EXC_ERROR THEN

5551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5552: 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);
5553: END IF;
5554: EXCEPTION
5555: WHEN FND_API.G_EXC_ERROR THEN
5556: RAISE FND_API.G_EXC_ERROR;
5557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: WHEN OTHERS THEN

Line 5556: RAISE FND_API.G_EXC_ERROR;

5552: 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);
5553: END IF;
5554: EXCEPTION
5555: WHEN FND_API.G_EXC_ERROR THEN
5556: RAISE FND_API.G_EXC_ERROR;
5557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: WHEN OTHERS THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5553: END IF;
5554: EXCEPTION
5555: WHEN FND_API.G_EXC_ERROR THEN
5556: RAISE FND_API.G_EXC_ERROR;
5557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: WHEN OTHERS THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5561: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');

Line 5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5554: EXCEPTION
5555: WHEN FND_API.G_EXC_ERROR THEN
5556: RAISE FND_API.G_EXC_ERROR;
5557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: WHEN OTHERS THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5561: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5561: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5565: END get_matching_contact_points;
5566:
5567: /**********************************************************
5568: This procedure finds the score details for a specific party that

Line 5785: WHEN FND_API.G_EXC_ERROR THEN

5781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5782: 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);
5783: END IF;
5784: EXCEPTION
5785: WHEN FND_API.G_EXC_ERROR THEN
5786: RAISE FND_API.G_EXC_ERROR;
5787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789: WHEN OTHERS THEN

Line 5786: RAISE FND_API.G_EXC_ERROR;

5782: 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);
5783: END IF;
5784: EXCEPTION
5785: WHEN FND_API.G_EXC_ERROR THEN
5786: RAISE FND_API.G_EXC_ERROR;
5787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789: WHEN OTHERS THEN
5790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5783: END IF;
5784: EXCEPTION
5785: WHEN FND_API.G_EXC_ERROR THEN
5786: RAISE FND_API.G_EXC_ERROR;
5787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789: WHEN OTHERS THEN
5790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5791: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');

Line 5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5784: EXCEPTION
5785: WHEN FND_API.G_EXC_ERROR THEN
5786: RAISE FND_API.G_EXC_ERROR;
5787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789: WHEN OTHERS THEN
5790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5791: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5792: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5791: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5792: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5793: FND_MSG_PUB.ADD;
5794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5795: END get_score_details;
5796:
5797:
5798: /************************************************

Line 5863: WHEN FND_API.G_EXC_ERROR THEN

5859: END LOOP;
5860: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5861: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5862: EXCEPTION
5863: WHEN FND_API.G_EXC_ERROR THEN
5864: RAISE FND_API.G_EXC_ERROR;
5865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5867: WHEN OTHERS THEN

Line 5864: RAISE FND_API.G_EXC_ERROR;

5860: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5861: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5862: EXCEPTION
5863: WHEN FND_API.G_EXC_ERROR THEN
5864: RAISE FND_API.G_EXC_ERROR;
5865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5861: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5862: EXCEPTION
5863: WHEN FND_API.G_EXC_ERROR THEN
5864: RAISE FND_API.G_EXC_ERROR;
5865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5862: EXCEPTION
5863: WHEN FND_API.G_EXC_ERROR THEN
5864: RAISE FND_API.G_EXC_ERROR;
5865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5871: FND_MSG_PUB.ADD;
5872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5873: END get_party_for_search;
5874:
5875: PROCEDURE get_search_criteria (
5876: p_party_id IN NUMBER,

Line 5903: WHEN FND_API.G_EXC_ERROR THEN

5899: END IF;
5900: get_party_site_rec(p_party_site_ids, x_party_site_list);
5901: END IF;
5902: EXCEPTION
5903: WHEN FND_API.G_EXC_ERROR THEN
5904: RAISE FND_API.G_EXC_ERROR;
5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: WHEN OTHERS THEN

Line 5904: RAISE FND_API.G_EXC_ERROR;

5900: get_party_site_rec(p_party_site_ids, x_party_site_list);
5901: END IF;
5902: EXCEPTION
5903: WHEN FND_API.G_EXC_ERROR THEN
5904: RAISE FND_API.G_EXC_ERROR;
5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5975: RAISE FND_API.G_EXC_ERROR;

5971: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5972: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5973: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5974: FND_MSG_PUB.ADD;
5975: RAISE FND_API.G_EXC_ERROR;
5976: END get_party_rec;
5977:
5978: /************************************************
5979: This procedure retrieves the match rule party site attributes into

Line 6041: RAISE FND_API.G_EXC_ERROR;

6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;
6041: RAISE FND_API.G_EXC_ERROR;
6042: END get_party_site_rec;
6043:
6044: /************************************************
6045: This procedure retrieves the match rule contact attributes into

Line 6097: RAISE FND_API.G_EXC_ERROR;

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

Line 6149: RAISE FND_API.G_EXC_ERROR;

6145: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6146: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6147: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END get_contact_point_rec;
6151:
6152: /************************************************
6153: This procedure maps a search record from the logical

Line 6271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6267: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6268: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6270: FND_MSG_PUB.ADD;
6271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6272: END;
6273:
6274:
6275: /************************************************

Line 6541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6537: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6538: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6540: FND_MSG_PUB.ADD;
6541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6542: END;
6543:
6544:
6545: /************************************************

Line 6583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6579: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6581: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6582: FND_MSG_PUB.ADD;
6583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6584: END;
6585:
6586:
6587: /************************************************

Line 6650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6646: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6647: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6649: FND_MSG_PUB.ADD;
6650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6651: END;
6652:
6653:
6654: /************************************************

Line 6711: WHEN FND_API.G_EXC_ERROR THEN

6707: END IF;
6708: END LOOP;
6709: RETURN FALSE;
6710: EXCEPTION
6711: WHEN FND_API.G_EXC_ERROR THEN
6712: RAISE FND_API.G_EXC_ERROR;
6713: WHEN OTHERS THEN
6714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6715: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6712: RAISE FND_API.G_EXC_ERROR;

6708: END LOOP;
6709: RETURN FALSE;
6710: EXCEPTION
6711: WHEN FND_API.G_EXC_ERROR THEN
6712: RAISE FND_API.G_EXC_ERROR;
6713: WHEN OTHERS THEN
6714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6715: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6715: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;
6718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6719: END check_prim_cond;
6720:
6721: /************************************************
6722: This procedure checks if the input search condition

Line 6774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6771: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6773: FND_MSG_PUB.ADD;
6774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6775: END check_party_site_cond;
6776:
6777: /************************************************
6778: This procedure checks if the input search condition

Line 6812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6809: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6811: FND_MSG_PUB.ADD;
6812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6813: END check_contact_cond;
6814:
6815: /************************************************
6816: This procedure checks if the input search condition

Line 6833: RAISE FND_API.G_EXC_ERROR;

6829: FOR I IN 1..p_contact_point_list.COUNT LOOP
6830: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6831: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6832: FND_MSG_PUB.ADD;
6833: RAISE FND_API.G_EXC_ERROR;
6834: END IF;
6835: END LOOP;
6836:
6837: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6846: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6848: FND_MSG_PUB.ADD;
6849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6850: END check_contact_point_cond;
6851:
6852: FUNCTION check_staged RETURN BOOLEAN IS
6853: