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_62 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 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1034: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1036: FND_MSG_PUB.ADD;
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END;
1039:
1040:
1041: /************************************************

Line 1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1058: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1059: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1061: FND_MSG_PUB.ADD;
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END;
1064:
1065:
1066: /************************************************

Line 1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1079: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1081: FND_MSG_PUB.ADD;
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END;
1084:
1085:
1086: /************************************************

Line 1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1098: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1099: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1101: FND_MSG_PUB.ADD;
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END;
1104:
1105: PROCEDURE init_score_context (
1106: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1169: RAISE FND_API.G_EXC_ERROR;

1165: p_contact_list,
1166: p_contact_point_list) THEN
1167: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1168: FND_MSG_PUB.ADD;
1169: RAISE FND_API.G_EXC_ERROR;
1170: END IF;
1171: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1172: 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);
1173: END IF;

Line 1461: RAISE FND_API.G_EXC_ERROR;

1457: IF lengthb(l_party_contains_str) > 4000 THEN
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_ERROR;
1462: END IF;
1463: IF (p_match_str = ' AND ' OR p_party_max_score 1464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1465: 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 1570: RAISE FND_API.G_EXC_ERROR;

1566: IF lengthb(l_contains_str) > 4000 THEN
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1568: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: x_denorm_str := l_den_contains_str;
1573: RETURN l_contains_str;
1574: END;

Line 1667: RAISE FND_API.G_EXC_ERROR;

1663: IF lengthb(l_contains_str) > 4000 THEN
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1665: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1666: FND_MSG_PUB.ADD;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: x_denorm_str := l_den_contains_str;
1670: RETURN l_contains_str;
1671: END;

Line 1941: RAISE FND_API.G_EXC_ERROR;

1937: when others then
1938: if (instrb(SQLERRM,'DRG-51030')>0) then
1939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1940: FND_MSG_PUB.ADD;
1941: RAISE FND_API.G_EXC_ERROR;
1942: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1944: FND_MSG_PUB.ADD;
1945: RAISE FND_API.G_EXC_ERROR;

Line 1945: RAISE FND_API.G_EXC_ERROR;

1941: RAISE FND_API.G_EXC_ERROR;
1942: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1944: FND_MSG_PUB.ADD;
1945: RAISE FND_API.G_EXC_ERROR;
1946: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1947: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1948: FND_MSG_PUB.ADD;
1949: RAISE FND_API.G_EXC_ERROR;

Line 1949: RAISE FND_API.G_EXC_ERROR;

1945: RAISE FND_API.G_EXC_ERROR;
1946: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1947: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1948: FND_MSG_PUB.ADD;
1949: RAISE FND_API.G_EXC_ERROR;
1950: else
1951: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1953: FND_MSG_PUB.ADD;

Line 1954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1950: else
1951: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1953: FND_MSG_PUB.ADD;
1954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1955: end if;
1956: END;
1957:
1958: PROCEDURE open_party_site_cursor(

Line 2186: RAISE FND_API.G_EXC_ERROR;

2182: when others then
2183: if (instrb(SQLERRM,'DRG-51030')>0) then
2184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2185: FND_MSG_PUB.ADD;
2186: RAISE FND_API.G_EXC_ERROR;
2187: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2189: FND_MSG_PUB.ADD;
2190: RAISE FND_API.G_EXC_ERROR;

Line 2190: RAISE FND_API.G_EXC_ERROR;

2186: RAISE FND_API.G_EXC_ERROR;
2187: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2189: FND_MSG_PUB.ADD;
2190: RAISE FND_API.G_EXC_ERROR;
2191: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2193: FND_MSG_PUB.ADD;
2194: RAISE FND_API.G_EXC_ERROR;

Line 2194: RAISE FND_API.G_EXC_ERROR;

2190: RAISE FND_API.G_EXC_ERROR;
2191: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2193: FND_MSG_PUB.ADD;
2194: RAISE FND_API.G_EXC_ERROR;
2195: else
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2198: FND_MSG_PUB.ADD;

Line 2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2195: else
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2198: FND_MSG_PUB.ADD;
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2200: end if;
2201: END;
2202:
2203: PROCEDURE open_contact_cursor(

Line 2333: RAISE FND_API.G_EXC_ERROR;

2329: when others then
2330: if (instrb(SQLERRM,'DRG-51030')>0) then
2331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2332: FND_MSG_PUB.ADD;
2333: RAISE FND_API.G_EXC_ERROR;
2334: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2336: FND_MSG_PUB.ADD;
2337: RAISE FND_API.G_EXC_ERROR;

Line 2337: RAISE FND_API.G_EXC_ERROR;

2333: RAISE FND_API.G_EXC_ERROR;
2334: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2336: FND_MSG_PUB.ADD;
2337: RAISE FND_API.G_EXC_ERROR;
2338: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2340: FND_MSG_PUB.ADD;
2341: RAISE FND_API.G_EXC_ERROR;

Line 2341: RAISE FND_API.G_EXC_ERROR;

2337: RAISE FND_API.G_EXC_ERROR;
2338: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2340: FND_MSG_PUB.ADD;
2341: RAISE FND_API.G_EXC_ERROR;
2342: else
2343: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2344: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2345: FND_MSG_PUB.ADD;

Line 2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2342: else
2343: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2344: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2345: FND_MSG_PUB.ADD;
2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2347: end if;
2348: END;
2349:
2350: PROCEDURE open_contact_pt_cursor(

Line 2606: RAISE FND_API.G_EXC_ERROR;

2602: when others then
2603: if (instrb(SQLERRM,'DRG-51030')>0) then
2604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2609: FND_MSG_PUB.ADD;
2610: RAISE FND_API.G_EXC_ERROR;

Line 2610: RAISE FND_API.G_EXC_ERROR;

2606: RAISE FND_API.G_EXC_ERROR;
2607: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2609: FND_MSG_PUB.ADD;
2610: RAISE FND_API.G_EXC_ERROR;
2611: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2612: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2613: FND_MSG_PUB.ADD;
2614: RAISE FND_API.G_EXC_ERROR;

Line 2614: RAISE FND_API.G_EXC_ERROR;

2610: RAISE FND_API.G_EXC_ERROR;
2611: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2612: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2613: FND_MSG_PUB.ADD;
2614: RAISE FND_API.G_EXC_ERROR;
2615: else
2616: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2618: FND_MSG_PUB.ADD;

Line 2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2615: else
2616: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2618: FND_MSG_PUB.ADD;
2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2620: end if;
2621: END;
2622:
2623:

Line 2881: RAISE FND_API.G_EXC_ERROR;

2877: 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);
2878: END IF;
2879: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2880: FND_MSG_PUB.ADD;
2881: RAISE FND_API.G_EXC_ERROR;
2882: ELSE
2883: push_eval;
2884: RETURN;
2885: END IF;

Line 2929: RAISE FND_API.G_EXC_ERROR;

2925: 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);
2926: END IF;
2927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2928: FND_MSG_PUB.ADD;
2929: RAISE FND_API.G_EXC_ERROR;
2930: ELSE
2931: push_eval;
2932: RETURN;
2933: END IF;

Line 3002: RAISE FND_API.G_EXC_ERROR;

2998: 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);
2999: END IF;
3000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3001: FND_MSG_PUB.ADD;
3002: RAISE FND_API.G_EXC_ERROR;
3003: ELSE
3004: push_eval;
3005: RETURN;
3006: END IF;

Line 3114: RAISE FND_API.G_EXC_ERROR;

3110: 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);
3111: END IF;
3112: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3113: FND_MSG_PUB.ADD;
3114: RAISE FND_API.G_EXC_ERROR;
3115: ELSE
3116: push_eval;
3117: RETURN;
3118: END IF;

Line 3225: RAISE FND_API.G_EXC_ERROR;

3221: 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);
3222: END IF;
3223: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3224: FND_MSG_PUB.ADD;
3225: RAISE FND_API.G_EXC_ERROR;
3226: ELSE
3227: push_eval;
3228: RETURN;
3229: END IF;

Line 3450: RAISE FND_API.G_EXC_ERROR;

3446: 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);
3447: END IF;
3448: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3449: FND_MSG_PUB.ADD;
3450: RAISE FND_API.G_EXC_ERROR;
3451: END IF;
3452: ELSE
3453: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3454: 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 3458: RAISE FND_API.G_EXC_ERROR;

3454: 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);
3455: END IF;
3456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3457: FND_MSG_PUB.ADD;
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460: END IF;
3461: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3462: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3657: WHEN FND_API.G_EXC_ERROR THEN

3653: END IF;
3654: EXCEPTION
3655: WHEN L_RETURN_IMM_EXC THEN
3656: RETURN;
3657: WHEN FND_API.G_EXC_ERROR THEN
3658: RAISE FND_API.G_EXC_ERROR;
3659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3661: WHEN OTHERS THEN

Line 3658: RAISE FND_API.G_EXC_ERROR;

3654: EXCEPTION
3655: WHEN L_RETURN_IMM_EXC THEN
3656: RETURN;
3657: WHEN FND_API.G_EXC_ERROR THEN
3658: RAISE FND_API.G_EXC_ERROR;
3659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3661: WHEN OTHERS THEN
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3655: WHEN L_RETURN_IMM_EXC THEN
3656: RETURN;
3657: WHEN FND_API.G_EXC_ERROR THEN
3658: RAISE FND_API.G_EXC_ERROR;
3659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3661: WHEN OTHERS THEN
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3663: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');

Line 3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3656: RETURN;
3657: WHEN FND_API.G_EXC_ERROR THEN
3658: RAISE FND_API.G_EXC_ERROR;
3659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3661: WHEN OTHERS THEN
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3663: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3663: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3665: FND_MSG_PUB.ADD;
3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3667: END find_parties;
3668:
3669: PROCEDURE find_persons (
3670: p_rule_id IN NUMBER,

Line 3868: RAISE FND_API.G_EXC_ERROR;

3864: 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);
3865: END IF;
3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3867: FND_MSG_PUB.ADD;
3868: RAISE FND_API.G_EXC_ERROR;
3869: ELSE
3870: push_eval;
3871: RETURN;
3872: END IF;

Line 3916: RAISE FND_API.G_EXC_ERROR;

3912: 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);
3913: END IF;
3914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3915: FND_MSG_PUB.ADD;
3916: RAISE FND_API.G_EXC_ERROR;
3917: ELSE
3918: push_eval;
3919: RETURN;
3920: END IF;

Line 3952: RAISE FND_API.G_EXC_ERROR;

3948: when others then
3949: if (instrb(SQLERRM,'DRG-51030')>0) then
3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3951: FND_MSG_PUB.ADD;
3952: RAISE FND_API.G_EXC_ERROR;
3953: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3955: FND_MSG_PUB.ADD;
3956: RAISE FND_API.G_EXC_ERROR;

Line 3956: RAISE FND_API.G_EXC_ERROR;

3952: RAISE FND_API.G_EXC_ERROR;
3953: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3955: FND_MSG_PUB.ADD;
3956: RAISE FND_API.G_EXC_ERROR;
3957: else
3958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3959: end if;
3960: END;

Line 3958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3955: FND_MSG_PUB.ADD;
3956: RAISE FND_API.G_EXC_ERROR;
3957: else
3958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3959: end if;
3960: END;
3961:
3962: /** Private procedure to acquire and score at party site level ***/

Line 4028: RAISE FND_API.G_EXC_ERROR;

4024: 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);
4025: END IF;
4026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4027: FND_MSG_PUB.ADD;
4028: RAISE FND_API.G_EXC_ERROR;
4029: ELSE
4030: push_eval;
4031: RETURN;
4032: END IF;

Line 4287: RAISE FND_API.G_EXC_ERROR;

4283: 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);
4284: END IF;
4285: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4286: FND_MSG_PUB.ADD;
4287: RAISE FND_API.G_EXC_ERROR;
4288: ELSE
4289: push_eval;
4290: RETURN;
4291: END IF;

Line 4400: RAISE FND_API.G_EXC_ERROR;

4396: 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);
4397: END IF;
4398: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4399: FND_MSG_PUB.ADD;
4400: RAISE FND_API.G_EXC_ERROR;
4401: END IF;
4402: ELSE
4403: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4404: 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 4408: RAISE FND_API.G_EXC_ERROR;

4404: 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);
4405: END IF;
4406: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4407: FND_MSG_PUB.ADD;
4408: RAISE FND_API.G_EXC_ERROR;
4409: END IF;
4410: END IF;
4411: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4412: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4522: WHEN FND_API.G_EXC_ERROR THEN

4518: END IF;
4519: EXCEPTION
4520: WHEN L_RETURN_IMM_EXC THEN
4521: RETURN;
4522: WHEN FND_API.G_EXC_ERROR THEN
4523: RAISE FND_API.G_EXC_ERROR;
4524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4526: WHEN OTHERS THEN

Line 4523: RAISE FND_API.G_EXC_ERROR;

4519: EXCEPTION
4520: WHEN L_RETURN_IMM_EXC THEN
4521: RETURN;
4522: WHEN FND_API.G_EXC_ERROR THEN
4523: RAISE FND_API.G_EXC_ERROR;
4524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4526: WHEN OTHERS THEN
4527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4520: WHEN L_RETURN_IMM_EXC THEN
4521: RETURN;
4522: WHEN FND_API.G_EXC_ERROR THEN
4523: RAISE FND_API.G_EXC_ERROR;
4524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4526: WHEN OTHERS THEN
4527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4528: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');

Line 4525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4521: RETURN;
4522: WHEN FND_API.G_EXC_ERROR THEN
4523: RAISE FND_API.G_EXC_ERROR;
4524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4526: WHEN OTHERS THEN
4527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4528: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4528: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4530: FND_MSG_PUB.ADD;
4531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4532: END find_persons;
4533:
4534: PROCEDURE find_persons (
4535: p_rule_id IN NUMBER,

Line 4590: WHEN FND_API.G_EXC_ERROR THEN

4586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4587: 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);
4588: END IF;
4589: EXCEPTION
4590: WHEN FND_API.G_EXC_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4594: WHEN OTHERS THEN

Line 4591: RAISE FND_API.G_EXC_ERROR;

4587: 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);
4588: END IF;
4589: EXCEPTION
4590: WHEN FND_API.G_EXC_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4594: WHEN OTHERS THEN
4595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4588: END IF;
4589: EXCEPTION
4590: WHEN FND_API.G_EXC_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4594: WHEN OTHERS THEN
4595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4596: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');

Line 4593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4589: EXCEPTION
4590: WHEN FND_API.G_EXC_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4594: WHEN OTHERS THEN
4595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4596: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4596: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4598: FND_MSG_PUB.ADD;
4599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4600: END find_party_details;
4601:
4602: PROCEDURE find_duplicate_parties (
4603: p_rule_id IN NUMBER,

Line 4707: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4708: RAISE FND_API.G_EXC_ERROR;

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

Line 4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4792: WHEN FND_API.G_EXC_ERROR THEN

4788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4789: 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);
4790: END IF;
4791: EXCEPTION
4792: WHEN FND_API.G_EXC_ERROR THEN
4793: RAISE FND_API.G_EXC_ERROR;
4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: WHEN OTHERS THEN

Line 4793: RAISE FND_API.G_EXC_ERROR;

4789: 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);
4790: END IF;
4791: EXCEPTION
4792: WHEN FND_API.G_EXC_ERROR THEN
4793: RAISE FND_API.G_EXC_ERROR;
4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: WHEN OTHERS THEN
4797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4790: END IF;
4791: EXCEPTION
4792: WHEN FND_API.G_EXC_ERROR THEN
4793: RAISE FND_API.G_EXC_ERROR;
4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: WHEN OTHERS THEN
4797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');

Line 4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4791: EXCEPTION
4792: WHEN FND_API.G_EXC_ERROR THEN
4793: RAISE FND_API.G_EXC_ERROR;
4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: WHEN OTHERS THEN
4797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4800: FND_MSG_PUB.ADD;
4801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4802: END find_duplicate_party_sites;
4803:
4804: PROCEDURE find_duplicate_contacts (
4805: p_rule_id IN NUMBER,

Line 4881: WHEN FND_API.G_EXC_ERROR THEN

4877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4878: 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);
4879: END IF;
4880: EXCEPTION
4881: WHEN FND_API.G_EXC_ERROR THEN
4882: RAISE FND_API.G_EXC_ERROR;
4883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4885: WHEN OTHERS THEN

Line 4882: RAISE FND_API.G_EXC_ERROR;

4878: 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);
4879: END IF;
4880: EXCEPTION
4881: WHEN FND_API.G_EXC_ERROR THEN
4882: RAISE FND_API.G_EXC_ERROR;
4883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4885: WHEN OTHERS THEN
4886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4879: END IF;
4880: EXCEPTION
4881: WHEN FND_API.G_EXC_ERROR THEN
4882: RAISE FND_API.G_EXC_ERROR;
4883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4885: WHEN OTHERS THEN
4886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4887: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');

Line 4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4880: EXCEPTION
4881: WHEN FND_API.G_EXC_ERROR THEN
4882: RAISE FND_API.G_EXC_ERROR;
4883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4885: WHEN OTHERS THEN
4886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4887: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4888: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4887: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4888: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4889: FND_MSG_PUB.ADD;
4890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4891: END find_duplicate_contacts;
4892:
4893: PROCEDURE find_duplicate_contact_points (
4894: p_rule_id IN NUMBER,

Line 4954: WHEN FND_API.G_EXC_ERROR THEN

4950: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4951: 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);
4952: END IF;
4953: EXCEPTION
4954: WHEN FND_API.G_EXC_ERROR THEN
4955: RAISE FND_API.G_EXC_ERROR;
4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN

Line 4955: RAISE FND_API.G_EXC_ERROR;

4951: 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);
4952: END IF;
4953: EXCEPTION
4954: WHEN FND_API.G_EXC_ERROR THEN
4955: RAISE FND_API.G_EXC_ERROR;
4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4952: END IF;
4953: EXCEPTION
4954: WHEN FND_API.G_EXC_ERROR THEN
4955: RAISE FND_API.G_EXC_ERROR;
4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');

Line 4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4953: EXCEPTION
4954: WHEN FND_API.G_EXC_ERROR THEN
4955: RAISE FND_API.G_EXC_ERROR;
4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4962: FND_MSG_PUB.ADD;
4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4964: END find_duplicate_contact_points;
4965:
4966: PROCEDURE find_parties_dynamic (
4967: p_rule_id IN NUMBER,

Line 5311: WHEN FND_API.G_EXC_ERROR THEN

5307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5308: 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);
5309: END IF;
5310: EXCEPTION
5311: WHEN FND_API.G_EXC_ERROR THEN
5312: RAISE FND_API.G_EXC_ERROR;
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315: WHEN OTHERS THEN

Line 5312: RAISE FND_API.G_EXC_ERROR;

5308: 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);
5309: END IF;
5310: EXCEPTION
5311: WHEN FND_API.G_EXC_ERROR THEN
5312: RAISE FND_API.G_EXC_ERROR;
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315: WHEN OTHERS THEN
5316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5309: END IF;
5310: EXCEPTION
5311: WHEN FND_API.G_EXC_ERROR THEN
5312: RAISE FND_API.G_EXC_ERROR;
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315: WHEN OTHERS THEN
5316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5317: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');

Line 5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5310: EXCEPTION
5311: WHEN FND_API.G_EXC_ERROR THEN
5312: RAISE FND_API.G_EXC_ERROR;
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315: WHEN OTHERS THEN
5316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5317: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5317: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5319: FND_MSG_PUB.ADD;
5320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5321: END call_api_dynamic;
5322:
5323:
5324: PROCEDURE get_matching_party_sites (

Line 5556: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5557: RAISE FND_API.G_EXC_ERROR;

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

Line 5558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5561: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5566: END get_matching_party_sites;
5567:
5568:
5569: PROCEDURE get_matching_contacts (

Line 5784: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5785: RAISE FND_API.G_EXC_ERROR;

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

Line 5786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5790: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5792: FND_MSG_PUB.ADD;
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: END get_matching_contacts;
5795:
5796:
5797: PROCEDURE get_matching_contact_points (

Line 5926: WHEN FND_API.G_EXC_ERROR THEN

5922: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5923: 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);
5924: END IF;
5925: EXCEPTION
5926: WHEN FND_API.G_EXC_ERROR THEN
5927: RAISE FND_API.G_EXC_ERROR;
5928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: WHEN OTHERS THEN

Line 5927: RAISE FND_API.G_EXC_ERROR;

5923: 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);
5924: END IF;
5925: EXCEPTION
5926: WHEN FND_API.G_EXC_ERROR THEN
5927: RAISE FND_API.G_EXC_ERROR;
5928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5924: END IF;
5925: EXCEPTION
5926: WHEN FND_API.G_EXC_ERROR THEN
5927: RAISE FND_API.G_EXC_ERROR;
5928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');

Line 5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5925: EXCEPTION
5926: WHEN FND_API.G_EXC_ERROR THEN
5927: RAISE FND_API.G_EXC_ERROR;
5928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: END get_matching_contact_points;
5937:
5938: /**********************************************************
5939: This procedure finds the score details for a specific party that

Line 6165: WHEN FND_API.G_EXC_ERROR THEN

6161: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6162: 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);
6163: END IF;
6164: EXCEPTION
6165: WHEN FND_API.G_EXC_ERROR THEN
6166: RAISE FND_API.G_EXC_ERROR;
6167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: WHEN OTHERS THEN

Line 6166: RAISE FND_API.G_EXC_ERROR;

6162: 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);
6163: END IF;
6164: EXCEPTION
6165: WHEN FND_API.G_EXC_ERROR THEN
6166: RAISE FND_API.G_EXC_ERROR;
6167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: WHEN OTHERS THEN
6170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6163: END IF;
6164: EXCEPTION
6165: WHEN FND_API.G_EXC_ERROR THEN
6166: RAISE FND_API.G_EXC_ERROR;
6167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: WHEN OTHERS THEN
6170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');

Line 6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6164: EXCEPTION
6165: WHEN FND_API.G_EXC_ERROR THEN
6166: RAISE FND_API.G_EXC_ERROR;
6167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: WHEN OTHERS THEN
6170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6173: FND_MSG_PUB.ADD;
6174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6175: END get_score_details;
6176:
6177:
6178: /************************************************

Line 6275: WHEN FND_API.G_EXC_ERROR THEN

6271: END LOOP;
6272: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6273: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6274: EXCEPTION
6275: WHEN FND_API.G_EXC_ERROR THEN
6276: RAISE FND_API.G_EXC_ERROR;
6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: WHEN OTHERS THEN

Line 6276: RAISE FND_API.G_EXC_ERROR;

6272: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6273: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6274: EXCEPTION
6275: WHEN FND_API.G_EXC_ERROR THEN
6276: RAISE FND_API.G_EXC_ERROR;
6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: WHEN OTHERS THEN
6280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6273: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6274: EXCEPTION
6275: WHEN FND_API.G_EXC_ERROR THEN
6276: RAISE FND_API.G_EXC_ERROR;
6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: WHEN OTHERS THEN
6280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6281: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6274: EXCEPTION
6275: WHEN FND_API.G_EXC_ERROR THEN
6276: RAISE FND_API.G_EXC_ERROR;
6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: WHEN OTHERS THEN
6280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6281: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6281: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6283: FND_MSG_PUB.ADD;
6284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6285: END get_party_for_search;
6286:
6287: PROCEDURE get_search_criteria (
6288: p_party_id IN NUMBER,

Line 6321: WHEN FND_API.G_EXC_ERROR THEN

6317: END IF;
6318: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6319: END IF;
6320: EXCEPTION
6321: WHEN FND_API.G_EXC_ERROR THEN
6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN

Line 6322: RAISE FND_API.G_EXC_ERROR;

6318: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6319: END IF;
6320: EXCEPTION
6321: WHEN FND_API.G_EXC_ERROR THEN
6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6319: END IF;
6320: EXCEPTION
6321: WHEN FND_API.G_EXC_ERROR THEN
6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6320: EXCEPTION
6321: WHEN FND_API.G_EXC_ERROR THEN
6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6329: FND_MSG_PUB.ADD;
6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6331: END get_search_criteria;
6332:
6333:
6334: /************************************************

Line 6397: RAISE FND_API.G_EXC_ERROR;

6393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_ERROR;
6398: END get_party_rec;
6399:
6400: /************************************************
6401: This procedure retrieves the match rule party site attributes into

Line 6461: RAISE FND_API.G_EXC_ERROR;

6457: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6458: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: END get_party_site_rec;
6463:
6464: /************************************************
6465: This procedure retrieves the match rule contact attributes into

Line 6517: RAISE FND_API.G_EXC_ERROR;

6513: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6514: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6516: FND_MSG_PUB.ADD;
6517: RAISE FND_API.G_EXC_ERROR;
6518: END get_contact_rec;
6519:
6520: /************************************************
6521: This procedure retrieves the match rule contact point attributes into

Line 6573: RAISE FND_API.G_EXC_ERROR;

6569: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6570: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6572: FND_MSG_PUB.ADD;
6573: RAISE FND_API.G_EXC_ERROR;
6574: END get_contact_point_rec;
6575:
6576: /************************************************
6577: This procedure maps a search record from the logical

Line 6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6767: END;
6768:
6769:
6770: /************************************************

Line 7007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7003: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7004: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7006: FND_MSG_PUB.ADD;
7007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7008: END;
7009:
7010:
7011: /************************************************

Line 7049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7045: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7046: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7048: FND_MSG_PUB.ADD;
7049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7050: END;
7051:
7052:
7053: /************************************************

Line 7180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7176: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7177: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7178: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7179: FND_MSG_PUB.ADD;
7180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7181: END;
7182:
7183:
7184: /************************************************

Line 7205: RAISE FND_API.G_EXC_ERROR;

7201: OR p_contact_point_list(I).URL IS NOT NULL
7202: ) THEN
7203: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7204: FND_MSG_PUB.ADD;
7205: RAISE FND_API.G_EXC_ERROR;
7206: END IF;
7207: END LOOP;
7208:
7209: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 7266: WHEN FND_API.G_EXC_ERROR THEN

7262: END IF;
7263: END LOOP;
7264: RETURN FALSE;
7265: EXCEPTION
7266: WHEN FND_API.G_EXC_ERROR THEN
7267: RAISE FND_API.G_EXC_ERROR;
7268: WHEN OTHERS THEN
7269: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7270: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 7267: RAISE FND_API.G_EXC_ERROR;

7263: END LOOP;
7264: RETURN FALSE;
7265: EXCEPTION
7266: WHEN FND_API.G_EXC_ERROR THEN
7267: RAISE FND_API.G_EXC_ERROR;
7268: WHEN OTHERS THEN
7269: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7270: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 7273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7269: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7270: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7272: FND_MSG_PUB.ADD;
7273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7274: END check_prim_cond;
7275:
7276: /************************************************
7277: This procedure checks if the input search condition

Line 7337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7334: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7336: FND_MSG_PUB.ADD;
7337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7338: END check_party_site_cond;
7339:
7340: /************************************************
7341: This procedure checks if the input search condition

Line 7385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7382: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7383: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7384: FND_MSG_PUB.ADD;
7385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7386: END check_contact_cond;
7387:
7388: /************************************************
7389: This procedure checks if the input search condition

Line 7406: RAISE FND_API.G_EXC_ERROR;

7402: FOR I IN 1..p_contact_point_list.COUNT LOOP
7403: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7404: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7405: FND_MSG_PUB.ADD;
7406: RAISE FND_API.G_EXC_ERROR;
7407: END IF;
7408: END LOOP;
7409:
7410: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 7432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7429: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7431: FND_MSG_PUB.ADD;
7432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7433: END check_contact_point_cond;
7434:
7435: FUNCTION check_staged RETURN BOOLEAN IS
7436: