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 2479: FND_MSG_PUB.ADD;

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

Line 2483: FND_MSG_PUB.ADD;

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

Line 2487: FND_MSG_PUB.ADD;

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

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

Line 2724: FND_MSG_PUB.ADD;

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

Line 2728: FND_MSG_PUB.ADD;

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

Line 2732: FND_MSG_PUB.ADD;

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

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

Line 2871: FND_MSG_PUB.ADD;

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

Line 2875: FND_MSG_PUB.ADD;

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

Line 2879: FND_MSG_PUB.ADD;

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

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

Line 3144: FND_MSG_PUB.ADD;

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

Line 3148: FND_MSG_PUB.ADD;

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

Line 3152: FND_MSG_PUB.ADD;

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

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

Line 3423: FND_MSG_PUB.ADD;

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

Line 3473: FND_MSG_PUB.ADD;

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

Line 3546: FND_MSG_PUB.ADD;

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

Line 3658: FND_MSG_PUB.ADD;

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

Line 3769: FND_MSG_PUB.ADD;

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

Line 3994: FND_MSG_PUB.ADD;

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

Line 4002: FND_MSG_PUB.ADD;

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

Line 4210: FND_MSG_PUB.ADD;

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 );
4210: FND_MSG_PUB.ADD;
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4212: END find_parties;
4213:
4214: PROCEDURE find_persons (

Line 4416: FND_MSG_PUB.ADD;

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

Line 4466: FND_MSG_PUB.ADD;

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

Line 4502: FND_MSG_PUB.ADD;

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

Line 4506: FND_MSG_PUB.ADD;

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;
4508: else
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4510: end if;

Line 4578: FND_MSG_PUB.ADD;

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

Line 4837: FND_MSG_PUB.ADD;

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

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

Line 4958: FND_MSG_PUB.ADD;

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

Line 5081: FND_MSG_PUB.ADD;

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 );
5081: FND_MSG_PUB.ADD;
5082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5083: END find_persons;
5084:
5085: PROCEDURE find_persons (

Line 5149: FND_MSG_PUB.ADD;

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 );
5149: FND_MSG_PUB.ADD;
5150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5151: END find_party_details;
5152:
5153: PROCEDURE find_duplicate_parties (

Line 5266: FND_MSG_PUB.ADD;

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

Line 5351: FND_MSG_PUB.ADD;

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

Line 5440: FND_MSG_PUB.ADD;

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

Line 5513: FND_MSG_PUB.ADD;

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

Line 5933: FND_MSG_PUB.ADD;

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 );
5933: FND_MSG_PUB.ADD;
5934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5935: END call_api_dynamic;
5936:
5937:

Line 6175: FND_MSG_PUB.ADD;

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 );
6175: FND_MSG_PUB.ADD;
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: END get_matching_party_sites;
6178:
6179:

Line 6403: FND_MSG_PUB.ADD;

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 );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END get_matching_contacts;
6406:
6407:

Line 6544: FND_MSG_PUB.ADD;

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 );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END get_matching_contact_points;
6547:
6548: /**********************************************************

Line 6791: FND_MSG_PUB.ADD;

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 );
6791: FND_MSG_PUB.ADD;
6792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6793: END get_score_details;
6794:
6795:

Line 6914: FND_MSG_PUB.ADD;

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

Line 6966: FND_MSG_PUB.ADD;

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 );
6966: FND_MSG_PUB.ADD;
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END get_search_criteria;
6969:
6970:

Line 7057: FND_MSG_PUB.ADD;

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

Line 7123: FND_MSG_PUB.ADD;

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

Line 7181: FND_MSG_PUB.ADD;

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

Line 7237: FND_MSG_PUB.ADD;

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

Line 7503: FND_MSG_PUB.ADD;

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

Line 7711: FND_MSG_PUB.ADD;

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

Line 7791: FND_MSG_PUB.ADD;

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

Line 7899: FND_MSG_PUB.ADD;

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

Line 7924: FND_MSG_PUB.ADD;

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

Line 8020: FND_MSG_PUB.ADD;

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 );
8020: FND_MSG_PUB.ADD;
8021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8022: END check_prim_cond;
8023:
8024: /************************************************

Line 8086: FND_MSG_PUB.ADD;

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

Line 8142: FND_MSG_PUB.ADD;

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

Line 8163: FND_MSG_PUB.ADD;

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

Line 8189: FND_MSG_PUB.ADD;

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