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_42 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 1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1388: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END;
1393:
1394:
1395: /************************************************

Line 1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1412: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1413: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1417: END;
1418:
1419:
1420: /************************************************

Line 1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1432: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1433: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END;
1438:
1439:
1440: /************************************************

Line 1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1452: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1453: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1454: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;
1458:
1459: PROCEDURE init_score_context (
1460: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1523: RAISE FND_API.G_EXC_ERROR;

1519: p_contact_list,
1520: p_contact_point_list) THEN
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1522: FND_MSG_PUB.ADD;
1523: RAISE FND_API.G_EXC_ERROR;
1524: END IF;
1525: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1526: 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);
1527: END IF;

Line 1911: RAISE FND_API.G_EXC_ERROR;

1907: IF lengthb(l_party_contains_str) > 4000 THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1909: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1913: IF (p_match_str = ' AND ' OR p_party_max_score 1914: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1915: 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 2030: RAISE FND_API.G_EXC_ERROR;

2026: IF lengthb(l_contains_str) > 4000 THEN
2027: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2028: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2029: FND_MSG_PUB.ADD;
2030: RAISE FND_API.G_EXC_ERROR;
2031: END IF;
2032: x_denorm_str := l_den_contains_str;
2033: RETURN l_contains_str;
2034: END;

Line 2074: RAISE FND_API.G_EXC_ERROR;

2070: IF lengthb(l_contains_str) > 4000 THEN
2071: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2072: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
2073: FND_MSG_PUB.ADD;
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;
2076: x_denorm_str := l_den_contains_str;
2077: RETURN l_contains_str;
2078: END;

Line 2155: RAISE FND_API.G_EXC_ERROR;

2151: IF lengthb(l_contains_str) > 4000 THEN
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2153: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2154: FND_MSG_PUB.ADD;
2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;
2157: x_denorm_str := l_den_contains_str;
2158: RETURN l_contains_str;
2159: END;

Line 2478: RAISE FND_API.G_EXC_ERROR;

2474: when others then
2475: if (instrb(SQLERRM,'DRG-51030')>0) then
2476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2477: FND_MSG_PUB.ADD;
2478: RAISE FND_API.G_EXC_ERROR;
2479: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2480: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2481: FND_MSG_PUB.ADD;
2482: RAISE FND_API.G_EXC_ERROR;

Line 2482: RAISE FND_API.G_EXC_ERROR;

2478: RAISE FND_API.G_EXC_ERROR;
2479: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2480: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2481: FND_MSG_PUB.ADD;
2482: RAISE FND_API.G_EXC_ERROR;
2483: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2485: FND_MSG_PUB.ADD;
2486: RAISE FND_API.G_EXC_ERROR;

Line 2486: RAISE FND_API.G_EXC_ERROR;

2482: RAISE FND_API.G_EXC_ERROR;
2483: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2485: FND_MSG_PUB.ADD;
2486: RAISE FND_API.G_EXC_ERROR;
2487: else
2488: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2490: FND_MSG_PUB.ADD;

Line 2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2487: else
2488: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2490: FND_MSG_PUB.ADD;
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: end if;
2493: END;
2494:
2495: PROCEDURE open_party_site_cursor(

Line 2723: RAISE FND_API.G_EXC_ERROR;

2719: when others then
2720: if (instrb(SQLERRM,'DRG-51030')>0) then
2721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2722: FND_MSG_PUB.ADD;
2723: RAISE FND_API.G_EXC_ERROR;
2724: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2726: FND_MSG_PUB.ADD;
2727: RAISE FND_API.G_EXC_ERROR;

Line 2727: RAISE FND_API.G_EXC_ERROR;

2723: RAISE FND_API.G_EXC_ERROR;
2724: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2726: FND_MSG_PUB.ADD;
2727: RAISE FND_API.G_EXC_ERROR;
2728: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2729: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2730: FND_MSG_PUB.ADD;
2731: RAISE FND_API.G_EXC_ERROR;

Line 2731: RAISE FND_API.G_EXC_ERROR;

2727: RAISE FND_API.G_EXC_ERROR;
2728: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2729: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2730: FND_MSG_PUB.ADD;
2731: RAISE FND_API.G_EXC_ERROR;
2732: else
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2735: FND_MSG_PUB.ADD;

Line 2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2732: else
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2735: FND_MSG_PUB.ADD;
2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737: end if;
2738: END;
2739:
2740: PROCEDURE open_contact_cursor(

Line 2870: RAISE FND_API.G_EXC_ERROR;

2866: when others then
2867: if (instrb(SQLERRM,'DRG-51030')>0) then
2868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2869: FND_MSG_PUB.ADD;
2870: RAISE FND_API.G_EXC_ERROR;
2871: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2873: FND_MSG_PUB.ADD;
2874: RAISE FND_API.G_EXC_ERROR;

Line 2874: RAISE FND_API.G_EXC_ERROR;

2870: RAISE FND_API.G_EXC_ERROR;
2871: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2873: FND_MSG_PUB.ADD;
2874: RAISE FND_API.G_EXC_ERROR;
2875: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2877: FND_MSG_PUB.ADD;
2878: RAISE FND_API.G_EXC_ERROR;

Line 2878: RAISE FND_API.G_EXC_ERROR;

2874: RAISE FND_API.G_EXC_ERROR;
2875: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2877: FND_MSG_PUB.ADD;
2878: RAISE FND_API.G_EXC_ERROR;
2879: else
2880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2882: FND_MSG_PUB.ADD;

Line 2883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2879: else
2880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2882: FND_MSG_PUB.ADD;
2883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2884: end if;
2885: END;
2886:
2887: PROCEDURE open_contact_pt_cursor(

Line 3143: RAISE FND_API.G_EXC_ERROR;

3139: when others then
3140: if (instrb(SQLERRM,'DRG-51030')>0) then
3141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3142: FND_MSG_PUB.ADD;
3143: RAISE FND_API.G_EXC_ERROR;
3144: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3145: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3146: FND_MSG_PUB.ADD;
3147: RAISE FND_API.G_EXC_ERROR;

Line 3147: RAISE FND_API.G_EXC_ERROR;

3143: RAISE FND_API.G_EXC_ERROR;
3144: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3145: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3146: FND_MSG_PUB.ADD;
3147: RAISE FND_API.G_EXC_ERROR;
3148: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3150: FND_MSG_PUB.ADD;
3151: RAISE FND_API.G_EXC_ERROR;

Line 3151: RAISE FND_API.G_EXC_ERROR;

3147: RAISE FND_API.G_EXC_ERROR;
3148: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3150: FND_MSG_PUB.ADD;
3151: RAISE FND_API.G_EXC_ERROR;
3152: else
3153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3155: FND_MSG_PUB.ADD;

Line 3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3152: else
3153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3155: FND_MSG_PUB.ADD;
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: end if;
3158: END;
3159:
3160:

Line 3421: RAISE FND_API.G_EXC_ERROR;

3417: 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);
3418: END IF;
3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3420: FND_MSG_PUB.ADD;
3421: RAISE FND_API.G_EXC_ERROR;
3422: ELSE
3423: push_eval;
3424: RETURN;
3425: END IF;

Line 3469: RAISE FND_API.G_EXC_ERROR;

3465: 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);
3466: END IF;
3467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3468: FND_MSG_PUB.ADD;
3469: RAISE FND_API.G_EXC_ERROR;
3470: ELSE
3471: push_eval;
3472: RETURN;
3473: END IF;

Line 3542: RAISE FND_API.G_EXC_ERROR;

3538: 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);
3539: END IF;
3540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3541: FND_MSG_PUB.ADD;
3542: RAISE FND_API.G_EXC_ERROR;
3543: ELSE
3544: push_eval;
3545: RETURN;
3546: END IF;

Line 3654: RAISE FND_API.G_EXC_ERROR;

3650: 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);
3651: END IF;
3652: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3653: FND_MSG_PUB.ADD;
3654: RAISE FND_API.G_EXC_ERROR;
3655: ELSE
3656: push_eval;
3657: RETURN;
3658: END IF;

Line 3765: RAISE FND_API.G_EXC_ERROR;

3761: 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);
3762: END IF;
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3764: FND_MSG_PUB.ADD;
3765: RAISE FND_API.G_EXC_ERROR;
3766: ELSE
3767: push_eval;
3768: RETURN;
3769: END IF;

Line 3990: RAISE FND_API.G_EXC_ERROR;

3986: 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);
3987: END IF;
3988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3989: FND_MSG_PUB.ADD;
3990: RAISE FND_API.G_EXC_ERROR;
3991: END IF;
3992: ELSE
3993: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3994: 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 3998: RAISE FND_API.G_EXC_ERROR;

3994: 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);
3995: END IF;
3996: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3997: FND_MSG_PUB.ADD;
3998: RAISE FND_API.G_EXC_ERROR;
3999: END IF;
4000: END IF;
4001: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4002: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4197: WHEN FND_API.G_EXC_ERROR THEN

4193: END IF;
4194: EXCEPTION
4195: WHEN L_RETURN_IMM_EXC THEN
4196: RETURN;
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: RAISE FND_API.G_EXC_ERROR;
4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4201: WHEN OTHERS THEN

Line 4198: RAISE FND_API.G_EXC_ERROR;

4194: EXCEPTION
4195: WHEN L_RETURN_IMM_EXC THEN
4196: RETURN;
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: RAISE FND_API.G_EXC_ERROR;
4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4201: WHEN OTHERS THEN
4202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4195: WHEN L_RETURN_IMM_EXC THEN
4196: RETURN;
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: RAISE FND_API.G_EXC_ERROR;
4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4201: WHEN OTHERS THEN
4202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');

Line 4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4196: RETURN;
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: RAISE FND_API.G_EXC_ERROR;
4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4201: WHEN OTHERS THEN
4202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');
4204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');
4204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4205: FND_MSG_PUB.ADD;
4206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4207: END find_parties;
4208:
4209: PROCEDURE find_persons (
4210: p_rule_id IN NUMBER,

Line 4411: RAISE FND_API.G_EXC_ERROR;

4407: 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);
4408: END IF;
4409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4410: FND_MSG_PUB.ADD;
4411: RAISE FND_API.G_EXC_ERROR;
4412: ELSE
4413: push_eval;
4414: RETURN;
4415: END IF;

Line 4459: RAISE FND_API.G_EXC_ERROR;

4455: 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);
4456: END IF;
4457: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4458: FND_MSG_PUB.ADD;
4459: RAISE FND_API.G_EXC_ERROR;
4460: ELSE
4461: push_eval;
4462: RETURN;
4463: END IF;

Line 4495: RAISE FND_API.G_EXC_ERROR;

4491: when others then
4492: if (instrb(SQLERRM,'DRG-51030')>0) then
4493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_ERROR;

Line 4499: RAISE FND_API.G_EXC_ERROR;

4495: RAISE FND_API.G_EXC_ERROR;
4496: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_ERROR;
4500: else
4501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4502: end if;
4503: END;

Line 4501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_ERROR;
4500: else
4501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4502: end if;
4503: END;
4504:
4505: /** Private procedure to acquire and score at party site level ***/

Line 4571: RAISE FND_API.G_EXC_ERROR;

4567: 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);
4568: END IF;
4569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4570: FND_MSG_PUB.ADD;
4571: RAISE FND_API.G_EXC_ERROR;
4572: ELSE
4573: push_eval;
4574: RETURN;
4575: END IF;

Line 4830: RAISE FND_API.G_EXC_ERROR;

4826: 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);
4827: END IF;
4828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4829: FND_MSG_PUB.ADD;
4830: RAISE FND_API.G_EXC_ERROR;
4831: ELSE
4832: push_eval;
4833: RETURN;
4834: END IF;

Line 4943: RAISE FND_API.G_EXC_ERROR;

4939: 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);
4940: END IF;
4941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4942: FND_MSG_PUB.ADD;
4943: RAISE FND_API.G_EXC_ERROR;
4944: END IF;
4945: ELSE
4946: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4947: 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 4951: RAISE FND_API.G_EXC_ERROR;

4947: 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);
4948: END IF;
4949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4950: FND_MSG_PUB.ADD;
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;
4953: END IF;
4954: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4955: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 5065: WHEN FND_API.G_EXC_ERROR THEN

5061: END IF;
5062: EXCEPTION
5063: WHEN L_RETURN_IMM_EXC THEN
5064: RETURN;
5065: WHEN FND_API.G_EXC_ERROR THEN
5066: RAISE FND_API.G_EXC_ERROR;
5067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: WHEN OTHERS THEN

Line 5066: RAISE FND_API.G_EXC_ERROR;

5062: EXCEPTION
5063: WHEN L_RETURN_IMM_EXC THEN
5064: RETURN;
5065: WHEN FND_API.G_EXC_ERROR THEN
5066: RAISE FND_API.G_EXC_ERROR;
5067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: WHEN OTHERS THEN
5070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5063: WHEN L_RETURN_IMM_EXC THEN
5064: RETURN;
5065: WHEN FND_API.G_EXC_ERROR THEN
5066: RAISE FND_API.G_EXC_ERROR;
5067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: WHEN OTHERS THEN
5070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5071: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');

Line 5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5064: RETURN;
5065: WHEN FND_API.G_EXC_ERROR THEN
5066: RAISE FND_API.G_EXC_ERROR;
5067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: WHEN OTHERS THEN
5070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5071: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5072: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5071: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5072: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5073: FND_MSG_PUB.ADD;
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5075: END find_persons;
5076:
5077: PROCEDURE find_persons (
5078: p_rule_id IN NUMBER,

Line 5133: WHEN FND_API.G_EXC_ERROR THEN

5129: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5130: 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);
5131: END IF;
5132: EXCEPTION
5133: WHEN FND_API.G_EXC_ERROR THEN
5134: RAISE FND_API.G_EXC_ERROR;
5135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5137: WHEN OTHERS THEN

Line 5134: RAISE FND_API.G_EXC_ERROR;

5130: 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);
5131: END IF;
5132: EXCEPTION
5133: WHEN FND_API.G_EXC_ERROR THEN
5134: RAISE FND_API.G_EXC_ERROR;
5135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5137: WHEN OTHERS THEN
5138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5131: END IF;
5132: EXCEPTION
5133: WHEN FND_API.G_EXC_ERROR THEN
5134: RAISE FND_API.G_EXC_ERROR;
5135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5137: WHEN OTHERS THEN
5138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');

Line 5136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5132: EXCEPTION
5133: WHEN FND_API.G_EXC_ERROR THEN
5134: RAISE FND_API.G_EXC_ERROR;
5135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5137: WHEN OTHERS THEN
5138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');
5140: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');
5140: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5141: FND_MSG_PUB.ADD;
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: END find_party_details;
5144:
5145: PROCEDURE find_duplicate_parties (
5146: p_rule_id IN NUMBER,

Line 5250: WHEN FND_API.G_EXC_ERROR THEN

5246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5247: 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);
5248: END IF;
5249: EXCEPTION
5250: WHEN FND_API.G_EXC_ERROR THEN
5251: RAISE FND_API.G_EXC_ERROR;
5252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5254: WHEN OTHERS THEN

Line 5251: RAISE FND_API.G_EXC_ERROR;

5247: 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);
5248: END IF;
5249: EXCEPTION
5250: WHEN FND_API.G_EXC_ERROR THEN
5251: RAISE FND_API.G_EXC_ERROR;
5252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5254: WHEN OTHERS THEN
5255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5248: END IF;
5249: EXCEPTION
5250: WHEN FND_API.G_EXC_ERROR THEN
5251: RAISE FND_API.G_EXC_ERROR;
5252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5254: WHEN OTHERS THEN
5255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5256: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');

Line 5253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5249: EXCEPTION
5250: WHEN FND_API.G_EXC_ERROR THEN
5251: RAISE FND_API.G_EXC_ERROR;
5252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5254: WHEN OTHERS THEN
5255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5256: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');
5257: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5256: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');
5257: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5258: FND_MSG_PUB.ADD;
5259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5260: END find_duplicate_parties;
5261:
5262: PROCEDURE find_duplicate_party_sites (
5263: p_rule_id IN NUMBER,

Line 5335: WHEN FND_API.G_EXC_ERROR THEN

5331: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5332: 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);
5333: END IF;
5334: EXCEPTION
5335: WHEN FND_API.G_EXC_ERROR THEN
5336: RAISE FND_API.G_EXC_ERROR;
5337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5339: WHEN OTHERS THEN

Line 5336: RAISE FND_API.G_EXC_ERROR;

5332: 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);
5333: END IF;
5334: EXCEPTION
5335: WHEN FND_API.G_EXC_ERROR THEN
5336: RAISE FND_API.G_EXC_ERROR;
5337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5339: WHEN OTHERS THEN
5340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5333: END IF;
5334: EXCEPTION
5335: WHEN FND_API.G_EXC_ERROR THEN
5336: RAISE FND_API.G_EXC_ERROR;
5337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5339: WHEN OTHERS THEN
5340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5341: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');

Line 5338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5334: EXCEPTION
5335: WHEN FND_API.G_EXC_ERROR THEN
5336: RAISE FND_API.G_EXC_ERROR;
5337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5339: WHEN OTHERS THEN
5340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5341: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5342: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5341: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5342: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5343: FND_MSG_PUB.ADD;
5344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5345: END find_duplicate_party_sites;
5346:
5347: PROCEDURE find_duplicate_contacts (
5348: p_rule_id IN NUMBER,

Line 5424: WHEN FND_API.G_EXC_ERROR THEN

5420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5421: 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);
5422: END IF;
5423: EXCEPTION
5424: WHEN FND_API.G_EXC_ERROR THEN
5425: RAISE FND_API.G_EXC_ERROR;
5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: WHEN OTHERS THEN

Line 5425: RAISE FND_API.G_EXC_ERROR;

5421: 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);
5422: END IF;
5423: EXCEPTION
5424: WHEN FND_API.G_EXC_ERROR THEN
5425: RAISE FND_API.G_EXC_ERROR;
5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: WHEN OTHERS THEN
5429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5422: END IF;
5423: EXCEPTION
5424: WHEN FND_API.G_EXC_ERROR THEN
5425: RAISE FND_API.G_EXC_ERROR;
5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: WHEN OTHERS THEN
5429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5430: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');

Line 5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5423: EXCEPTION
5424: WHEN FND_API.G_EXC_ERROR THEN
5425: RAISE FND_API.G_EXC_ERROR;
5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: WHEN OTHERS THEN
5429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5430: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5430: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5432: FND_MSG_PUB.ADD;
5433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5434: END find_duplicate_contacts;
5435:
5436: PROCEDURE find_duplicate_contact_points (
5437: p_rule_id IN NUMBER,

Line 5497: WHEN FND_API.G_EXC_ERROR THEN

5493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5494: 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);
5495: END IF;
5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN
5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN

Line 5498: RAISE FND_API.G_EXC_ERROR;

5494: 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);
5495: END IF;
5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN
5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5495: END IF;
5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN
5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');

Line 5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN
5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5505: FND_MSG_PUB.ADD;
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5507: END find_duplicate_contact_points;
5508:
5509: PROCEDURE find_parties_dynamic (
5510: p_rule_id IN NUMBER,

Line 5917: WHEN FND_API.G_EXC_ERROR THEN

5913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5914: 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);
5915: END IF;
5916: EXCEPTION
5917: WHEN FND_API.G_EXC_ERROR THEN
5918: RAISE FND_API.G_EXC_ERROR;
5919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5921: WHEN OTHERS THEN

Line 5918: RAISE FND_API.G_EXC_ERROR;

5914: 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);
5915: END IF;
5916: EXCEPTION
5917: WHEN FND_API.G_EXC_ERROR THEN
5918: RAISE FND_API.G_EXC_ERROR;
5919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5921: WHEN OTHERS THEN
5922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5915: END IF;
5916: EXCEPTION
5917: WHEN FND_API.G_EXC_ERROR THEN
5918: RAISE FND_API.G_EXC_ERROR;
5919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5921: WHEN OTHERS THEN
5922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');

Line 5920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5916: EXCEPTION
5917: WHEN FND_API.G_EXC_ERROR THEN
5918: RAISE FND_API.G_EXC_ERROR;
5919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5921: WHEN OTHERS THEN
5922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5927: END call_api_dynamic;
5928:
5929:
5930: PROCEDURE get_matching_party_sites (

Line 6159: WHEN FND_API.G_EXC_ERROR THEN

6155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6156: 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);
6157: END IF;
6158: EXCEPTION
6159: WHEN FND_API.G_EXC_ERROR THEN
6160: RAISE FND_API.G_EXC_ERROR;
6161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6163: WHEN OTHERS THEN

Line 6160: RAISE FND_API.G_EXC_ERROR;

6156: 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);
6157: END IF;
6158: EXCEPTION
6159: WHEN FND_API.G_EXC_ERROR THEN
6160: RAISE FND_API.G_EXC_ERROR;
6161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6157: END IF;
6158: EXCEPTION
6159: WHEN FND_API.G_EXC_ERROR THEN
6160: RAISE FND_API.G_EXC_ERROR;
6161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');

Line 6162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6158: EXCEPTION
6159: WHEN FND_API.G_EXC_ERROR THEN
6160: RAISE FND_API.G_EXC_ERROR;
6161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END get_matching_party_sites;
6170:
6171:
6172: PROCEDURE get_matching_contacts (

Line 6387: WHEN FND_API.G_EXC_ERROR THEN

6383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6384: 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);
6385: END IF;
6386: EXCEPTION
6387: WHEN FND_API.G_EXC_ERROR THEN
6388: RAISE FND_API.G_EXC_ERROR;
6389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6391: WHEN OTHERS THEN

Line 6388: RAISE FND_API.G_EXC_ERROR;

6384: 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);
6385: END IF;
6386: EXCEPTION
6387: WHEN FND_API.G_EXC_ERROR THEN
6388: RAISE FND_API.G_EXC_ERROR;
6389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6385: END IF;
6386: EXCEPTION
6387: WHEN FND_API.G_EXC_ERROR THEN
6388: RAISE FND_API.G_EXC_ERROR;
6389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');

Line 6390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6386: EXCEPTION
6387: WHEN FND_API.G_EXC_ERROR THEN
6388: RAISE FND_API.G_EXC_ERROR;
6389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6395: FND_MSG_PUB.ADD;
6396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6397: END get_matching_contacts;
6398:
6399:
6400: PROCEDURE get_matching_contact_points (

Line 6528: WHEN FND_API.G_EXC_ERROR THEN

6524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6525: 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);
6526: END IF;
6527: EXCEPTION
6528: WHEN FND_API.G_EXC_ERROR THEN
6529: RAISE FND_API.G_EXC_ERROR;
6530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: WHEN OTHERS THEN

Line 6529: RAISE FND_API.G_EXC_ERROR;

6525: 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);
6526: END IF;
6527: EXCEPTION
6528: WHEN FND_API.G_EXC_ERROR THEN
6529: RAISE FND_API.G_EXC_ERROR;
6530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6526: END IF;
6527: EXCEPTION
6528: WHEN FND_API.G_EXC_ERROR THEN
6529: RAISE FND_API.G_EXC_ERROR;
6530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');

Line 6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6527: EXCEPTION
6528: WHEN FND_API.G_EXC_ERROR THEN
6529: RAISE FND_API.G_EXC_ERROR;
6530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6538: END get_matching_contact_points;
6539:
6540: /**********************************************************
6541: This procedure finds the score details for a specific party that

Line 6772: WHEN FND_API.G_EXC_ERROR THEN

6768: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6769: 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);
6770: END IF;
6771: EXCEPTION
6772: WHEN FND_API.G_EXC_ERROR THEN
6773: RAISE FND_API.G_EXC_ERROR;
6774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6776: WHEN OTHERS THEN

Line 6773: RAISE FND_API.G_EXC_ERROR;

6769: 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);
6770: END IF;
6771: EXCEPTION
6772: WHEN FND_API.G_EXC_ERROR THEN
6773: RAISE FND_API.G_EXC_ERROR;
6774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6776: WHEN OTHERS THEN
6777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6770: END IF;
6771: EXCEPTION
6772: WHEN FND_API.G_EXC_ERROR THEN
6773: RAISE FND_API.G_EXC_ERROR;
6774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6776: WHEN OTHERS THEN
6777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');

Line 6775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6771: EXCEPTION
6772: WHEN FND_API.G_EXC_ERROR THEN
6773: RAISE FND_API.G_EXC_ERROR;
6774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6776: WHEN OTHERS THEN
6777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6780: FND_MSG_PUB.ADD;
6781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6782: END get_score_details;
6783:
6784:
6785: /************************************************

Line 6895: WHEN FND_API.G_EXC_ERROR THEN

6891: END LOOP;
6892: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6893: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6894: EXCEPTION
6895: WHEN FND_API.G_EXC_ERROR THEN
6896: RAISE FND_API.G_EXC_ERROR;
6897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6899: WHEN OTHERS THEN

Line 6896: RAISE FND_API.G_EXC_ERROR;

6892: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6893: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6894: EXCEPTION
6895: WHEN FND_API.G_EXC_ERROR THEN
6896: RAISE FND_API.G_EXC_ERROR;
6897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6899: WHEN OTHERS THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6893: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6894: EXCEPTION
6895: WHEN FND_API.G_EXC_ERROR THEN
6896: RAISE FND_API.G_EXC_ERROR;
6897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6899: WHEN OTHERS THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6901: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6894: EXCEPTION
6895: WHEN FND_API.G_EXC_ERROR THEN
6896: RAISE FND_API.G_EXC_ERROR;
6897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6899: WHEN OTHERS THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6901: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6902: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6901: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6902: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6903: FND_MSG_PUB.ADD;
6904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6905: END get_party_for_search;
6906:
6907: PROCEDURE get_search_criteria (
6908: p_party_id IN NUMBER,

Line 6947: WHEN FND_API.G_EXC_ERROR THEN

6943: END IF;
6944: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6945: END IF;
6946: EXCEPTION
6947: WHEN FND_API.G_EXC_ERROR THEN
6948: RAISE FND_API.G_EXC_ERROR;
6949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: WHEN OTHERS THEN

Line 6948: RAISE FND_API.G_EXC_ERROR;

6944: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6945: END IF;
6946: EXCEPTION
6947: WHEN FND_API.G_EXC_ERROR THEN
6948: RAISE FND_API.G_EXC_ERROR;
6949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: WHEN OTHERS THEN
6952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6945: END IF;
6946: EXCEPTION
6947: WHEN FND_API.G_EXC_ERROR THEN
6948: RAISE FND_API.G_EXC_ERROR;
6949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: WHEN OTHERS THEN
6952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6953: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6946: EXCEPTION
6947: WHEN FND_API.G_EXC_ERROR THEN
6948: RAISE FND_API.G_EXC_ERROR;
6949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: WHEN OTHERS THEN
6952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6953: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6953: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6955: FND_MSG_PUB.ADD;
6956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6957: END get_search_criteria;
6958:
6959:
6960: /************************************************

Line 7047: RAISE FND_API.G_EXC_ERROR;

7043: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7044: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7046: FND_MSG_PUB.ADD;
7047: RAISE FND_API.G_EXC_ERROR;
7048: END get_party_rec;
7049:
7050: /************************************************
7051: This procedure retrieves the match rule party site attributes into

Line 7113: RAISE FND_API.G_EXC_ERROR;

7109: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7110: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7112: FND_MSG_PUB.ADD;
7113: RAISE FND_API.G_EXC_ERROR;
7114: END get_party_site_rec;
7115:
7116: /************************************************
7117: This procedure retrieves the match rule contact attributes into

Line 7171: RAISE FND_API.G_EXC_ERROR;

7167: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7168: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7170: FND_MSG_PUB.ADD;
7171: RAISE FND_API.G_EXC_ERROR;
7172: END get_contact_rec;
7173:
7174: /************************************************
7175: This procedure retrieves the match rule contact point attributes into

Line 7227: RAISE FND_API.G_EXC_ERROR;

7223: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7224: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7225: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;
7228: END get_contact_point_rec;
7229:
7230: /************************************************
7231: This procedure maps a search record from the logical

Line 7493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7489: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7490: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7492: FND_MSG_PUB.ADD;
7493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7494: END;
7495:
7496:
7497: /************************************************

Line 7701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7697: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7698: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7700: FND_MSG_PUB.ADD;
7701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7702: END;
7703:
7704:
7705: /************************************************

Line 7781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7777: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7778: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7780: FND_MSG_PUB.ADD;
7781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7782: END;
7783:
7784:
7785: /************************************************

Line 7889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7885: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7886: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7888: FND_MSG_PUB.ADD;
7889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7890: END;
7891:
7892:
7893: /************************************************

Line 7914: RAISE FND_API.G_EXC_ERROR;

7910: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7911: ) THEN
7912: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7913: FND_MSG_PUB.ADD;
7914: RAISE FND_API.G_EXC_ERROR;
7915: END IF;
7916: END LOOP;
7917:
7918: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 8003: WHEN FND_API.G_EXC_ERROR THEN

7999: END IF;
8000: END LOOP;
8001: RETURN FALSE;
8002: EXCEPTION
8003: WHEN FND_API.G_EXC_ERROR THEN
8004: RAISE FND_API.G_EXC_ERROR;
8005: WHEN OTHERS THEN
8006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8007: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 8004: RAISE FND_API.G_EXC_ERROR;

8000: END LOOP;
8001: RETURN FALSE;
8002: EXCEPTION
8003: WHEN FND_API.G_EXC_ERROR THEN
8004: RAISE FND_API.G_EXC_ERROR;
8005: WHEN OTHERS THEN
8006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8007: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8007: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8009: FND_MSG_PUB.ADD;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END check_prim_cond;
8012:
8013: /************************************************
8014: This procedure checks if the input search condition

Line 8076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8073: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8075: FND_MSG_PUB.ADD;
8076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8077: END check_party_site_cond;
8078:
8079: /************************************************
8080: This procedure checks if the input search condition

Line 8132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8128: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8129: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8130: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8131: FND_MSG_PUB.ADD;
8132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8133: END check_contact_cond;
8134:
8135: /************************************************
8136: This procedure checks if the input search condition

Line 8153: RAISE FND_API.G_EXC_ERROR;

8149: FOR I IN 1..p_contact_point_list.COUNT LOOP
8150: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8151: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8152: FND_MSG_PUB.ADD;
8153: RAISE FND_API.G_EXC_ERROR;
8154: END IF;
8155: END LOOP;
8156:
8157: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 8179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8175: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8176: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8177: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8178: FND_MSG_PUB.ADD;
8179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8180: END check_contact_point_cond;
8181:
8182: FUNCTION check_staged RETURN BOOLEAN IS
8183: