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_MSG_PUB

Line 101: FND_MSG_PUB.ADD;

97: exception
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;

Line 105: FND_MSG_PUB.ADD;

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;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;

Line 1390: FND_MSG_PUB.ADD;

1386: WHEN OTHERS THEN
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:

Line 1415: FND_MSG_PUB.ADD;

1411: WHEN OTHERS THEN
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:

Line 1435: FND_MSG_PUB.ADD;

1431: WHEN OTHERS THEN
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:

Line 1455: FND_MSG_PUB.ADD;

1451: WHEN OTHERS THEN
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 (

Line 1522: FND_MSG_PUB.ADD;

1518: p_party_site_list,
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);

Line 1910: FND_MSG_PUB.ADD;

1906: END IF;
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

Line 2029: FND_MSG_PUB.ADD;

2025: -- Add the search criteria to query string
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;

Line 2073: FND_MSG_PUB.ADD;

2069: -- Add the search criteria to query string
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;

Line 2154: FND_MSG_PUB.ADD;

2150: -- Add the search criteria to query string
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;

Line 2477: FND_MSG_PUB.ADD;

2473: exception
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;

Line 2481: FND_MSG_PUB.ADD;

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;
2483: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2485: FND_MSG_PUB.ADD;

Line 2485: FND_MSG_PUB.ADD;

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;
2487: else
2488: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2490: 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;
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: end if;
2493: END;
2494:

Line 2722: FND_MSG_PUB.ADD;

2718: exception
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;

Line 2726: FND_MSG_PUB.ADD;

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;
2728: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2729: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2730: FND_MSG_PUB.ADD;

Line 2730: FND_MSG_PUB.ADD;

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;
2732: else
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2735: 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;
2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737: end if;
2738: END;
2739:

Line 2869: FND_MSG_PUB.ADD;

2865: exception
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;

Line 2873: FND_MSG_PUB.ADD;

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;
2875: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2877: FND_MSG_PUB.ADD;

Line 2877: FND_MSG_PUB.ADD;

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;
2879: else
2880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2882: 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;
2883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2884: end if;
2885: END;
2886:

Line 3142: FND_MSG_PUB.ADD;

3138: exception
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;

Line 3146: FND_MSG_PUB.ADD;

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;
3148: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3150: FND_MSG_PUB.ADD;

Line 3150: FND_MSG_PUB.ADD;

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;
3152: else
3153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 3155: 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;
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: end if;
3158: END;
3159:

Line 3420: FND_MSG_PUB.ADD;

3416: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3468: FND_MSG_PUB.ADD;

3464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3541: FND_MSG_PUB.ADD;

3537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3653: FND_MSG_PUB.ADD;

3649: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3764: FND_MSG_PUB.ADD;

3760: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 3989: FND_MSG_PUB.ADD;

3985: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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

Line 3997: FND_MSG_PUB.ADD;

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);
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

Line 4205: FND_MSG_PUB.ADD;

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 );
4205: FND_MSG_PUB.ADD;
4206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4207: END find_parties;
4208:
4209: PROCEDURE find_persons (

Line 4410: FND_MSG_PUB.ADD;

4406: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 4458: FND_MSG_PUB.ADD;

4454: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 4494: FND_MSG_PUB.ADD;

4490: exception
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;

Line 4498: FND_MSG_PUB.ADD;

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;
4500: else
4501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4502: end if;

Line 4570: FND_MSG_PUB.ADD;

4566: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 4829: FND_MSG_PUB.ADD;

4825: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;

Line 4942: FND_MSG_PUB.ADD;

4938: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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

Line 4950: FND_MSG_PUB.ADD;

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);
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

Line 5073: FND_MSG_PUB.ADD;

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 );
5073: FND_MSG_PUB.ADD;
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5075: END find_persons;
5076:
5077: PROCEDURE find_persons (

Line 5141: FND_MSG_PUB.ADD;

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 );
5141: FND_MSG_PUB.ADD;
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: END find_party_details;
5144:
5145: PROCEDURE find_duplicate_parties (

Line 5258: FND_MSG_PUB.ADD;

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 );
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 (

Line 5343: FND_MSG_PUB.ADD;

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 );
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 (

Line 5432: FND_MSG_PUB.ADD;

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 );
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 (

Line 5505: FND_MSG_PUB.ADD;

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 );
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 (

Line 5925: FND_MSG_PUB.ADD;

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 );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5927: END call_api_dynamic;
5928:
5929:

Line 6167: FND_MSG_PUB.ADD;

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 );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END get_matching_party_sites;
6170:
6171:

Line 6395: FND_MSG_PUB.ADD;

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 );
6395: FND_MSG_PUB.ADD;
6396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6397: END get_matching_contacts;
6398:
6399:

Line 6536: FND_MSG_PUB.ADD;

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 );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6538: END get_matching_contact_points;
6539:
6540: /**********************************************************

Line 6780: FND_MSG_PUB.ADD;

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 );
6780: FND_MSG_PUB.ADD;
6781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6782: END get_score_details;
6783:
6784:

Line 6903: FND_MSG_PUB.ADD;

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 );
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 (

Line 6955: FND_MSG_PUB.ADD;

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 );
6955: FND_MSG_PUB.ADD;
6956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6957: END get_search_criteria;
6958:
6959:

Line 7046: FND_MSG_PUB.ADD;

7042: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_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: /************************************************

Line 7112: FND_MSG_PUB.ADD;

7108: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_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: /************************************************

Line 7170: FND_MSG_PUB.ADD;

7166: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_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: /************************************************

Line 7226: FND_MSG_PUB.ADD;

7222: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_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: /************************************************

Line 7492: FND_MSG_PUB.ADD;

7488: WHEN OTHERS THEN
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:

Line 7700: FND_MSG_PUB.ADD;

7696: WHEN OTHERS THEN
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:

Line 7780: FND_MSG_PUB.ADD;

7776: WHEN OTHERS THEN
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:

Line 7888: FND_MSG_PUB.ADD;

7884: WHEN OTHERS THEN
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:

Line 7913: FND_MSG_PUB.ADD;

7909: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
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:

Line 8009: FND_MSG_PUB.ADD;

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 );
8009: FND_MSG_PUB.ADD;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END check_prim_cond;
8012:
8013: /************************************************

Line 8075: FND_MSG_PUB.ADD;

8071: WHEN OTHERS THEN
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: /************************************************

Line 8131: FND_MSG_PUB.ADD;

8127: WHEN OTHERS THEN
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: /************************************************

Line 8152: FND_MSG_PUB.ADD;

8148:
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:

Line 8178: FND_MSG_PUB.ADD;

8174: WHEN OTHERS THEN
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