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 2480: RAISE FND_API.G_EXC_ERROR;

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

Line 2484: RAISE FND_API.G_EXC_ERROR;

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

Line 2488: RAISE FND_API.G_EXC_ERROR;

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

Line 2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2725: RAISE FND_API.G_EXC_ERROR;

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

Line 2729: RAISE FND_API.G_EXC_ERROR;

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

Line 2733: RAISE FND_API.G_EXC_ERROR;

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

Line 2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2872: RAISE FND_API.G_EXC_ERROR;

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

Line 2876: RAISE FND_API.G_EXC_ERROR;

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

Line 2880: RAISE FND_API.G_EXC_ERROR;

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

Line 2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3145: RAISE FND_API.G_EXC_ERROR;

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

Line 3149: RAISE FND_API.G_EXC_ERROR;

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

Line 3153: RAISE FND_API.G_EXC_ERROR;

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

Line 3158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3424: RAISE FND_API.G_EXC_ERROR;

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

Line 3474: RAISE FND_API.G_EXC_ERROR;

3470: 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);
3471: END IF;
3472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3473: FND_MSG_PUB.ADD;
3474: RAISE FND_API.G_EXC_ERROR;
3475: ELSE
3476: push_eval;
3477: RETURN;
3478: END IF;

Line 3547: RAISE FND_API.G_EXC_ERROR;

3543: 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);
3544: END IF;
3545: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3546: FND_MSG_PUB.ADD;
3547: RAISE FND_API.G_EXC_ERROR;
3548: ELSE
3549: push_eval;
3550: RETURN;
3551: END IF;

Line 3659: RAISE FND_API.G_EXC_ERROR;

3655: 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);
3656: END IF;
3657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3658: FND_MSG_PUB.ADD;
3659: RAISE FND_API.G_EXC_ERROR;
3660: ELSE
3661: push_eval;
3662: RETURN;
3663: END IF;

Line 3770: RAISE FND_API.G_EXC_ERROR;

3766: 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);
3767: END IF;
3768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3769: FND_MSG_PUB.ADD;
3770: RAISE FND_API.G_EXC_ERROR;
3771: ELSE
3772: push_eval;
3773: RETURN;
3774: END IF;

Line 3995: RAISE FND_API.G_EXC_ERROR;

3991: 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);
3992: END IF;
3993: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3994: FND_MSG_PUB.ADD;
3995: RAISE FND_API.G_EXC_ERROR;
3996: END IF;
3997: ELSE
3998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3999: 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 4003: RAISE FND_API.G_EXC_ERROR;

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

Line 4202: WHEN FND_API.G_EXC_ERROR THEN

4198: END IF;
4199: EXCEPTION
4200: WHEN L_RETURN_IMM_EXC THEN
4201: RETURN;
4202: WHEN FND_API.G_EXC_ERROR THEN
4203: RAISE FND_API.G_EXC_ERROR;
4204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4206: WHEN OTHERS THEN

Line 4203: RAISE FND_API.G_EXC_ERROR;

4199: EXCEPTION
4200: WHEN L_RETURN_IMM_EXC THEN
4201: RETURN;
4202: WHEN FND_API.G_EXC_ERROR THEN
4203: RAISE FND_API.G_EXC_ERROR;
4204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4206: WHEN OTHERS THEN
4207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4200: WHEN L_RETURN_IMM_EXC THEN
4201: RETURN;
4202: WHEN FND_API.G_EXC_ERROR THEN
4203: RAISE FND_API.G_EXC_ERROR;
4204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4206: WHEN OTHERS THEN
4207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4208: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');

Line 4205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4201: RETURN;
4202: WHEN FND_API.G_EXC_ERROR THEN
4203: RAISE FND_API.G_EXC_ERROR;
4204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4206: WHEN OTHERS THEN
4207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4208: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');
4209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4208: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');
4209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4210: FND_MSG_PUB.ADD;
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4212: END find_parties;
4213:
4214: PROCEDURE find_persons (
4215: p_rule_id IN NUMBER,

Line 4417: RAISE FND_API.G_EXC_ERROR;

4413: 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);
4414: END IF;
4415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4416: FND_MSG_PUB.ADD;
4417: RAISE FND_API.G_EXC_ERROR;
4418: ELSE
4419: push_eval;
4420: RETURN;
4421: END IF;

Line 4467: RAISE FND_API.G_EXC_ERROR;

4463: 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);
4464: END IF;
4465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4466: FND_MSG_PUB.ADD;
4467: RAISE FND_API.G_EXC_ERROR;
4468: ELSE
4469: push_eval;
4470: RETURN;
4471: END IF;

Line 4503: RAISE FND_API.G_EXC_ERROR;

4499: when others then
4500: if (instrb(SQLERRM,'DRG-51030')>0) then
4501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4502: FND_MSG_PUB.ADD;
4503: RAISE FND_API.G_EXC_ERROR;
4504: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4506: FND_MSG_PUB.ADD;
4507: RAISE FND_API.G_EXC_ERROR;

Line 4507: RAISE FND_API.G_EXC_ERROR;

4503: RAISE FND_API.G_EXC_ERROR;
4504: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4506: FND_MSG_PUB.ADD;
4507: RAISE FND_API.G_EXC_ERROR;
4508: else
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4510: end if;
4511: END;

Line 4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4506: FND_MSG_PUB.ADD;
4507: RAISE FND_API.G_EXC_ERROR;
4508: else
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4510: end if;
4511: END;
4512:
4513: /** Private procedure to acquire and score at party site level ***/

Line 4579: RAISE FND_API.G_EXC_ERROR;

4575: 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);
4576: END IF;
4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4578: FND_MSG_PUB.ADD;
4579: RAISE FND_API.G_EXC_ERROR;
4580: ELSE
4581: push_eval;
4582: RETURN;
4583: END IF;

Line 4838: RAISE FND_API.G_EXC_ERROR;

4834: 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);
4835: END IF;
4836: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4837: FND_MSG_PUB.ADD;
4838: RAISE FND_API.G_EXC_ERROR;
4839: ELSE
4840: push_eval;
4841: RETURN;
4842: END IF;

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: ELSE
4954: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4955: 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 4959: RAISE FND_API.G_EXC_ERROR;

4955: 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);
4956: END IF;
4957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4958: FND_MSG_PUB.ADD;
4959: RAISE FND_API.G_EXC_ERROR;
4960: END IF;
4961: END IF;
4962: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4963: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 5073: WHEN FND_API.G_EXC_ERROR THEN

5069: END IF;
5070: EXCEPTION
5071: WHEN L_RETURN_IMM_EXC THEN
5072: RETURN;
5073: WHEN FND_API.G_EXC_ERROR THEN
5074: RAISE FND_API.G_EXC_ERROR;
5075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN

Line 5074: RAISE FND_API.G_EXC_ERROR;

5070: EXCEPTION
5071: WHEN L_RETURN_IMM_EXC THEN
5072: RETURN;
5073: WHEN FND_API.G_EXC_ERROR THEN
5074: RAISE FND_API.G_EXC_ERROR;
5075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5071: WHEN L_RETURN_IMM_EXC THEN
5072: RETURN;
5073: WHEN FND_API.G_EXC_ERROR THEN
5074: RAISE FND_API.G_EXC_ERROR;
5075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');

Line 5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5072: RETURN;
5073: WHEN FND_API.G_EXC_ERROR THEN
5074: RAISE FND_API.G_EXC_ERROR;
5075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5081: FND_MSG_PUB.ADD;
5082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5083: END find_persons;
5084:
5085: PROCEDURE find_persons (
5086: p_rule_id IN NUMBER,

Line 5141: WHEN FND_API.G_EXC_ERROR THEN

5137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5138: 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);
5139: END IF;
5140: EXCEPTION
5141: WHEN FND_API.G_EXC_ERROR THEN
5142: RAISE FND_API.G_EXC_ERROR;
5143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5145: WHEN OTHERS THEN

Line 5142: RAISE FND_API.G_EXC_ERROR;

5138: 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);
5139: END IF;
5140: EXCEPTION
5141: WHEN FND_API.G_EXC_ERROR THEN
5142: RAISE FND_API.G_EXC_ERROR;
5143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5145: WHEN OTHERS THEN
5146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5139: END IF;
5140: EXCEPTION
5141: WHEN FND_API.G_EXC_ERROR THEN
5142: RAISE FND_API.G_EXC_ERROR;
5143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5145: WHEN OTHERS THEN
5146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');

Line 5144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5140: EXCEPTION
5141: WHEN FND_API.G_EXC_ERROR THEN
5142: RAISE FND_API.G_EXC_ERROR;
5143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5145: WHEN OTHERS THEN
5146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');
5148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');
5148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5149: FND_MSG_PUB.ADD;
5150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5151: END find_party_details;
5152:
5153: PROCEDURE find_duplicate_parties (
5154: p_rule_id IN NUMBER,

Line 5258: WHEN FND_API.G_EXC_ERROR THEN

5254: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5255: 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);
5256: END IF;
5257: EXCEPTION
5258: WHEN FND_API.G_EXC_ERROR THEN
5259: RAISE FND_API.G_EXC_ERROR;
5260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: WHEN OTHERS THEN

Line 5259: RAISE FND_API.G_EXC_ERROR;

5255: 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);
5256: END IF;
5257: EXCEPTION
5258: WHEN FND_API.G_EXC_ERROR THEN
5259: RAISE FND_API.G_EXC_ERROR;
5260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5256: END IF;
5257: EXCEPTION
5258: WHEN FND_API.G_EXC_ERROR THEN
5259: RAISE FND_API.G_EXC_ERROR;
5260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');

Line 5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5257: EXCEPTION
5258: WHEN FND_API.G_EXC_ERROR THEN
5259: RAISE FND_API.G_EXC_ERROR;
5260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5266: FND_MSG_PUB.ADD;
5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5268: END find_duplicate_parties;
5269:
5270: PROCEDURE find_duplicate_party_sites (
5271: p_rule_id IN NUMBER,

Line 5343: WHEN FND_API.G_EXC_ERROR THEN

5339: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5340: 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);
5341: END IF;
5342: EXCEPTION
5343: WHEN FND_API.G_EXC_ERROR THEN
5344: RAISE FND_API.G_EXC_ERROR;
5345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5347: WHEN OTHERS THEN

Line 5344: RAISE FND_API.G_EXC_ERROR;

5340: 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);
5341: END IF;
5342: EXCEPTION
5343: WHEN FND_API.G_EXC_ERROR THEN
5344: RAISE FND_API.G_EXC_ERROR;
5345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5347: WHEN OTHERS THEN
5348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5341: END IF;
5342: EXCEPTION
5343: WHEN FND_API.G_EXC_ERROR THEN
5344: RAISE FND_API.G_EXC_ERROR;
5345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5347: WHEN OTHERS THEN
5348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5349: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');

Line 5346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5342: EXCEPTION
5343: WHEN FND_API.G_EXC_ERROR THEN
5344: RAISE FND_API.G_EXC_ERROR;
5345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5347: WHEN OTHERS THEN
5348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5349: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5349: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5351: FND_MSG_PUB.ADD;
5352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5353: END find_duplicate_party_sites;
5354:
5355: PROCEDURE find_duplicate_contacts (
5356: p_rule_id IN NUMBER,

Line 5432: WHEN FND_API.G_EXC_ERROR THEN

5428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5429: 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);
5430: END IF;
5431: EXCEPTION
5432: WHEN FND_API.G_EXC_ERROR THEN
5433: RAISE FND_API.G_EXC_ERROR;
5434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5436: WHEN OTHERS THEN

Line 5433: RAISE FND_API.G_EXC_ERROR;

5429: 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);
5430: END IF;
5431: EXCEPTION
5432: WHEN FND_API.G_EXC_ERROR THEN
5433: RAISE FND_API.G_EXC_ERROR;
5434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5436: WHEN OTHERS THEN
5437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5430: END IF;
5431: EXCEPTION
5432: WHEN FND_API.G_EXC_ERROR THEN
5433: RAISE FND_API.G_EXC_ERROR;
5434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5436: WHEN OTHERS THEN
5437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5438: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');

Line 5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5431: EXCEPTION
5432: WHEN FND_API.G_EXC_ERROR THEN
5433: RAISE FND_API.G_EXC_ERROR;
5434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5436: WHEN OTHERS THEN
5437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5438: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5438: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5440: FND_MSG_PUB.ADD;
5441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5442: END find_duplicate_contacts;
5443:
5444: PROCEDURE find_duplicate_contact_points (
5445: p_rule_id IN NUMBER,

Line 5505: WHEN FND_API.G_EXC_ERROR THEN

5501: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5502: 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);
5503: END IF;
5504: EXCEPTION
5505: WHEN FND_API.G_EXC_ERROR THEN
5506: RAISE FND_API.G_EXC_ERROR;
5507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: WHEN OTHERS THEN

Line 5506: RAISE FND_API.G_EXC_ERROR;

5502: 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);
5503: END IF;
5504: EXCEPTION
5505: WHEN FND_API.G_EXC_ERROR THEN
5506: RAISE FND_API.G_EXC_ERROR;
5507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: WHEN OTHERS THEN
5510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5503: END IF;
5504: EXCEPTION
5505: WHEN FND_API.G_EXC_ERROR THEN
5506: RAISE FND_API.G_EXC_ERROR;
5507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: WHEN OTHERS THEN
5510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5511: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');

Line 5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5504: EXCEPTION
5505: WHEN FND_API.G_EXC_ERROR THEN
5506: RAISE FND_API.G_EXC_ERROR;
5507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: WHEN OTHERS THEN
5510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5511: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5511: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;
5514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5515: END find_duplicate_contact_points;
5516:
5517: PROCEDURE find_parties_dynamic (
5518: p_rule_id IN NUMBER,

Line 5925: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5926: RAISE FND_API.G_EXC_ERROR;

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

Line 5927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5931: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5933: FND_MSG_PUB.ADD;
5934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5935: END call_api_dynamic;
5936:
5937:
5938: PROCEDURE get_matching_party_sites (

Line 6167: WHEN FND_API.G_EXC_ERROR THEN

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

Line 6168: RAISE FND_API.G_EXC_ERROR;

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

Line 6169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6165: END IF;
6166: EXCEPTION
6167: WHEN FND_API.G_EXC_ERROR THEN
6168: RAISE FND_API.G_EXC_ERROR;
6169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');

Line 6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6166: EXCEPTION
6167: WHEN FND_API.G_EXC_ERROR THEN
6168: RAISE FND_API.G_EXC_ERROR;
6169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6175: FND_MSG_PUB.ADD;
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: END get_matching_party_sites;
6178:
6179:
6180: PROCEDURE get_matching_contacts (

Line 6395: WHEN FND_API.G_EXC_ERROR THEN

6391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6392: 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);
6393: END IF;
6394: EXCEPTION
6395: WHEN FND_API.G_EXC_ERROR THEN
6396: RAISE FND_API.G_EXC_ERROR;
6397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6399: WHEN OTHERS THEN

Line 6396: RAISE FND_API.G_EXC_ERROR;

6392: 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);
6393: END IF;
6394: EXCEPTION
6395: WHEN FND_API.G_EXC_ERROR THEN
6396: RAISE FND_API.G_EXC_ERROR;
6397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6393: END IF;
6394: EXCEPTION
6395: WHEN FND_API.G_EXC_ERROR THEN
6396: RAISE FND_API.G_EXC_ERROR;
6397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');

Line 6398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6394: EXCEPTION
6395: WHEN FND_API.G_EXC_ERROR THEN
6396: RAISE FND_API.G_EXC_ERROR;
6397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END get_matching_contacts;
6406:
6407:
6408: PROCEDURE get_matching_contact_points (

Line 6536: WHEN FND_API.G_EXC_ERROR THEN

6532: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6533: 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);
6534: END IF;
6535: EXCEPTION
6536: WHEN FND_API.G_EXC_ERROR THEN
6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN

Line 6537: RAISE FND_API.G_EXC_ERROR;

6533: 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);
6534: END IF;
6535: EXCEPTION
6536: WHEN FND_API.G_EXC_ERROR THEN
6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6534: END IF;
6535: EXCEPTION
6536: WHEN FND_API.G_EXC_ERROR THEN
6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');

Line 6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6535: EXCEPTION
6536: WHEN FND_API.G_EXC_ERROR THEN
6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END get_matching_contact_points;
6547:
6548: /**********************************************************
6549: This procedure finds the score details for a specific party that

Line 6783: WHEN FND_API.G_EXC_ERROR THEN

6779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6780: 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);
6781: END IF;
6782: EXCEPTION
6783: WHEN FND_API.G_EXC_ERROR THEN
6784: RAISE FND_API.G_EXC_ERROR;
6785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: WHEN OTHERS THEN

Line 6784: RAISE FND_API.G_EXC_ERROR;

6780: 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);
6781: END IF;
6782: EXCEPTION
6783: WHEN FND_API.G_EXC_ERROR THEN
6784: RAISE FND_API.G_EXC_ERROR;
6785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: WHEN OTHERS THEN
6788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6781: END IF;
6782: EXCEPTION
6783: WHEN FND_API.G_EXC_ERROR THEN
6784: RAISE FND_API.G_EXC_ERROR;
6785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: WHEN OTHERS THEN
6788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6789: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');

Line 6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6782: EXCEPTION
6783: WHEN FND_API.G_EXC_ERROR THEN
6784: RAISE FND_API.G_EXC_ERROR;
6785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: WHEN OTHERS THEN
6788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6789: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6789: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6791: FND_MSG_PUB.ADD;
6792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6793: END get_score_details;
6794:
6795:
6796: /************************************************

Line 6906: WHEN FND_API.G_EXC_ERROR THEN

6902: END LOOP;
6903: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6904: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6905: EXCEPTION
6906: WHEN FND_API.G_EXC_ERROR THEN
6907: RAISE FND_API.G_EXC_ERROR;
6908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6910: WHEN OTHERS THEN

Line 6907: RAISE FND_API.G_EXC_ERROR;

6903: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6904: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6905: EXCEPTION
6906: WHEN FND_API.G_EXC_ERROR THEN
6907: RAISE FND_API.G_EXC_ERROR;
6908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6910: WHEN OTHERS THEN
6911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6904: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6905: EXCEPTION
6906: WHEN FND_API.G_EXC_ERROR THEN
6907: RAISE FND_API.G_EXC_ERROR;
6908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6910: WHEN OTHERS THEN
6911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6912: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6905: EXCEPTION
6906: WHEN FND_API.G_EXC_ERROR THEN
6907: RAISE FND_API.G_EXC_ERROR;
6908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6910: WHEN OTHERS THEN
6911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6912: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6912: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6914: FND_MSG_PUB.ADD;
6915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6916: END get_party_for_search;
6917:
6918: PROCEDURE get_search_criteria (
6919: p_party_id IN NUMBER,

Line 6958: WHEN FND_API.G_EXC_ERROR THEN

6954: END IF;
6955: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6956: END IF;
6957: EXCEPTION
6958: WHEN FND_API.G_EXC_ERROR THEN
6959: RAISE FND_API.G_EXC_ERROR;
6960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: WHEN OTHERS THEN

Line 6959: RAISE FND_API.G_EXC_ERROR;

6955: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6956: END IF;
6957: EXCEPTION
6958: WHEN FND_API.G_EXC_ERROR THEN
6959: RAISE FND_API.G_EXC_ERROR;
6960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: WHEN OTHERS THEN
6963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6956: END IF;
6957: EXCEPTION
6958: WHEN FND_API.G_EXC_ERROR THEN
6959: RAISE FND_API.G_EXC_ERROR;
6960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: WHEN OTHERS THEN
6963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6964: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6957: EXCEPTION
6958: WHEN FND_API.G_EXC_ERROR THEN
6959: RAISE FND_API.G_EXC_ERROR;
6960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: WHEN OTHERS THEN
6963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6964: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6964: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6966: FND_MSG_PUB.ADD;
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END get_search_criteria;
6969:
6970:
6971: /************************************************

Line 7058: RAISE FND_API.G_EXC_ERROR;

7054: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7055: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7057: FND_MSG_PUB.ADD;
7058: RAISE FND_API.G_EXC_ERROR;
7059: END get_party_rec;
7060:
7061: /************************************************
7062: This procedure retrieves the match rule party site attributes into

Line 7124: RAISE FND_API.G_EXC_ERROR;

7120: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7121: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7123: FND_MSG_PUB.ADD;
7124: RAISE FND_API.G_EXC_ERROR;
7125: END get_party_site_rec;
7126:
7127: /************************************************
7128: This procedure retrieves the match rule contact attributes into

Line 7182: RAISE FND_API.G_EXC_ERROR;

7178: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7179: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7181: FND_MSG_PUB.ADD;
7182: RAISE FND_API.G_EXC_ERROR;
7183: END get_contact_rec;
7184:
7185: /************************************************
7186: This procedure retrieves the match rule contact point attributes into

Line 7238: RAISE FND_API.G_EXC_ERROR;

7234: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7235: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7237: FND_MSG_PUB.ADD;
7238: RAISE FND_API.G_EXC_ERROR;
7239: END get_contact_point_rec;
7240:
7241: /************************************************
7242: This procedure maps a search record from the logical

Line 7504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7500: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7501: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7503: FND_MSG_PUB.ADD;
7504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7505: END;
7506:
7507:
7508: /************************************************

Line 7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7708: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7709: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7711: FND_MSG_PUB.ADD;
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: END;
7714:
7715:
7716: /************************************************

Line 7792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7791: FND_MSG_PUB.ADD;
7792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7793: END;
7794:
7795:
7796: /************************************************

Line 7900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7896: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7897: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7899: FND_MSG_PUB.ADD;
7900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7901: END;
7902:
7903:
7904: /************************************************

Line 7925: RAISE FND_API.G_EXC_ERROR;

7921: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7922: ) THEN
7923: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7924: FND_MSG_PUB.ADD;
7925: RAISE FND_API.G_EXC_ERROR;
7926: END IF;
7927: END LOOP;
7928:
7929: IF p_party_search_rec.PARTY_NAME IS NOT NULL THEN

Line 8014: WHEN FND_API.G_EXC_ERROR THEN

8010: END IF;
8011: END LOOP;
8012: RETURN FALSE;
8013: EXCEPTION
8014: WHEN FND_API.G_EXC_ERROR THEN
8015: RAISE FND_API.G_EXC_ERROR;
8016: WHEN OTHERS THEN
8017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8018: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 8015: RAISE FND_API.G_EXC_ERROR;

8011: END LOOP;
8012: RETURN FALSE;
8013: EXCEPTION
8014: WHEN FND_API.G_EXC_ERROR THEN
8015: RAISE FND_API.G_EXC_ERROR;
8016: WHEN OTHERS THEN
8017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8018: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 8021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8018: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8020: FND_MSG_PUB.ADD;
8021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8022: END check_prim_cond;
8023:
8024: /************************************************
8025: This procedure checks if the input search condition

Line 8087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8084: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8086: FND_MSG_PUB.ADD;
8087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8088: END check_party_site_cond;
8089:
8090: /************************************************
8091: This procedure checks if the input search condition

Line 8143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8140: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8142: FND_MSG_PUB.ADD;
8143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8144: END check_contact_cond;
8145:
8146: /************************************************
8147: This procedure checks if the input search condition

Line 8164: RAISE FND_API.G_EXC_ERROR;

8160: FOR I IN 1..p_contact_point_list.COUNT LOOP
8161: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8162: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8163: FND_MSG_PUB.ADD;
8164: RAISE FND_API.G_EXC_ERROR;
8165: END IF;
8166: END LOOP;
8167:
8168: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 8190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8186: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8187: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8188: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8189: FND_MSG_PUB.ADD;
8190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8191: END check_contact_point_cond;
8192:
8193: FUNCTION check_staged RETURN BOOLEAN IS
8194: