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

1403: WHEN OTHERS THEN
1404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1405: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END;
1410:
1411:

Line 1432: FND_MSG_PUB.ADD;

1428: WHEN OTHERS THEN
1429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1430: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END;
1435:
1436:

Line 1452: FND_MSG_PUB.ADD;

1448: WHEN OTHERS THEN
1449: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1450: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1454: END;
1455:
1456:

Line 1472: FND_MSG_PUB.ADD;

1468: WHEN OTHERS THEN
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1471: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END;
1475:
1476: PROCEDURE init_score_context (

Line 1539: FND_MSG_PUB.ADD;

1535: p_party_site_list,
1536: p_contact_list,
1537: p_contact_point_list) THEN
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1543: 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 1929: FND_MSG_PUB.ADD;

1925: END IF;
1926: IF lengthb(l_party_contains_str) > 4000 THEN
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1928: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1929: FND_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_ERROR;
1931: END IF;
1932: IF (p_match_str = ' AND ' OR p_party_max_score 1933: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2041: FND_MSG_PUB.ADD;

2037: -- Add the search criteria to query string
2038: IF lengthb(l_contains_str) > 4000 THEN
2039: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2040: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044: x_denorm_str := l_den_contains_str;
2045: RETURN l_contains_str;

Line 2131: FND_MSG_PUB.ADD;

2127: -- Add the search criteria to query string
2128: IF lengthb(l_contains_str) > 4000 THEN
2129: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2130: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134: x_denorm_str := l_den_contains_str;
2135: RETURN l_contains_str;

Line 2466: FND_MSG_PUB.ADD;

2462: exception
2463: when others then
2464: if (instrb(SQLERRM,'DRG-51030')>0) then
2465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2470: FND_MSG_PUB.ADD;

Line 2470: FND_MSG_PUB.ADD;

2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2470: FND_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;
2472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2474: FND_MSG_PUB.ADD;

Line 2474: FND_MSG_PUB.ADD;

2470: FND_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;
2472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2474: FND_MSG_PUB.ADD;
2475: RAISE FND_API.G_EXC_ERROR;
2476: else
2477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2479: FND_MSG_PUB.ADD;

2475: RAISE FND_API.G_EXC_ERROR;
2476: else
2477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2479: FND_MSG_PUB.ADD;
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: end if;
2482: END;
2483:

Line 2711: FND_MSG_PUB.ADD;

2707: exception
2708: when others then
2709: if (instrb(SQLERRM,'DRG-51030')>0) then
2710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2711: FND_MSG_PUB.ADD;
2712: RAISE FND_API.G_EXC_ERROR;
2713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2715: FND_MSG_PUB.ADD;

Line 2715: FND_MSG_PUB.ADD;

2711: FND_MSG_PUB.ADD;
2712: RAISE FND_API.G_EXC_ERROR;
2713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2719: FND_MSG_PUB.ADD;

Line 2719: FND_MSG_PUB.ADD;

2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2719: FND_MSG_PUB.ADD;
2720: RAISE FND_API.G_EXC_ERROR;
2721: else
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2724: FND_MSG_PUB.ADD;

2720: RAISE FND_API.G_EXC_ERROR;
2721: else
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2724: FND_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: end if;
2727: END;
2728:

Line 2858: FND_MSG_PUB.ADD;

2854: exception
2855: when others then
2856: if (instrb(SQLERRM,'DRG-51030')>0) then
2857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2858: FND_MSG_PUB.ADD;
2859: RAISE FND_API.G_EXC_ERROR;
2860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2862: FND_MSG_PUB.ADD;

Line 2862: FND_MSG_PUB.ADD;

2858: FND_MSG_PUB.ADD;
2859: RAISE FND_API.G_EXC_ERROR;
2860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_ERROR;
2864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2866: FND_MSG_PUB.ADD;

Line 2866: FND_MSG_PUB.ADD;

2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_ERROR;
2864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2866: FND_MSG_PUB.ADD;
2867: RAISE FND_API.G_EXC_ERROR;
2868: else
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2871: FND_MSG_PUB.ADD;

2867: RAISE FND_API.G_EXC_ERROR;
2868: else
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2871: FND_MSG_PUB.ADD;
2872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2873: end if;
2874: END;
2875:

Line 3131: FND_MSG_PUB.ADD;

3127: exception
3128: when others then
3129: if (instrb(SQLERRM,'DRG-51030')>0) then
3130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3131: FND_MSG_PUB.ADD;
3132: RAISE FND_API.G_EXC_ERROR;
3133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3135: FND_MSG_PUB.ADD;

Line 3135: FND_MSG_PUB.ADD;

3131: FND_MSG_PUB.ADD;
3132: RAISE FND_API.G_EXC_ERROR;
3133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3135: FND_MSG_PUB.ADD;
3136: RAISE FND_API.G_EXC_ERROR;
3137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3139: FND_MSG_PUB.ADD;

Line 3139: FND_MSG_PUB.ADD;

3135: FND_MSG_PUB.ADD;
3136: RAISE FND_API.G_EXC_ERROR;
3137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3139: FND_MSG_PUB.ADD;
3140: RAISE FND_API.G_EXC_ERROR;
3141: else
3142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 3144: FND_MSG_PUB.ADD;

3140: RAISE FND_API.G_EXC_ERROR;
3141: else
3142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3146: end if;
3147: END;
3148:

Line 3414: FND_MSG_PUB.ADD;

3410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3411: 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);
3412: END IF;
3413: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3414: FND_MSG_PUB.ADD;
3415: RAISE FND_API.G_EXC_ERROR;
3416: ELSE
3417: push_eval;
3418: RETURN;

Line 3464: FND_MSG_PUB.ADD;

3460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3461: 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);
3462: END IF;
3463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3464: FND_MSG_PUB.ADD;
3465: RAISE FND_API.G_EXC_ERROR;
3466: ELSE
3467: push_eval;
3468: RETURN;

Line 3537: FND_MSG_PUB.ADD;

3533: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3534: 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);
3535: END IF;
3536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3537: FND_MSG_PUB.ADD;
3538: RAISE FND_API.G_EXC_ERROR;
3539: ELSE
3540: push_eval;
3541: RETURN;

Line 3649: FND_MSG_PUB.ADD;

3645: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3646: 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);
3647: END IF;
3648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3649: FND_MSG_PUB.ADD;
3650: RAISE FND_API.G_EXC_ERROR;
3651: ELSE
3652: push_eval;
3653: RETURN;

Line 3760: FND_MSG_PUB.ADD;

3756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3757: 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);
3758: END IF;
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3760: FND_MSG_PUB.ADD;
3761: RAISE FND_API.G_EXC_ERROR;
3762: ELSE
3763: push_eval;
3764: RETURN;

Line 3985: FND_MSG_PUB.ADD;

3981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3982: 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);
3983: END IF;
3984: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3985: FND_MSG_PUB.ADD;
3986: RAISE FND_API.G_EXC_ERROR;
3987: END IF;
3988: ELSE
3989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3993: FND_MSG_PUB.ADD;

3989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3990: 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);
3991: END IF;
3992: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3993: FND_MSG_PUB.ADD;
3994: RAISE FND_API.G_EXC_ERROR;
3995: END IF;
3996: END IF;
3997: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4201: FND_MSG_PUB.ADD;

4197: WHEN OTHERS THEN
4198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4199: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4201: FND_MSG_PUB.ADD;
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4203: END find_parties;
4204:
4205: PROCEDURE find_persons (

Line 4411: FND_MSG_PUB.ADD;

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

Line 4461: FND_MSG_PUB.ADD;

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

Line 4497: FND_MSG_PUB.ADD;

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

Line 4501: FND_MSG_PUB.ADD;

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

Line 4573: FND_MSG_PUB.ADD;

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

Line 4832: FND_MSG_PUB.ADD;

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

Line 4945: FND_MSG_PUB.ADD;

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

Line 4953: FND_MSG_PUB.ADD;

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

Line 5076: FND_MSG_PUB.ADD;

5072: WHEN OTHERS THEN
5073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5074: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5075: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5076: FND_MSG_PUB.ADD;
5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5078: END find_persons;
5079:
5080: PROCEDURE find_persons (

Line 5144: FND_MSG_PUB.ADD;

5140: WHEN OTHERS THEN
5141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5142: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5144: FND_MSG_PUB.ADD;
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: END find_party_details;
5147:
5148: PROCEDURE find_duplicate_parties (

Line 5261: FND_MSG_PUB.ADD;

5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END find_duplicate_parties;
5264:
5265: PROCEDURE find_duplicate_party_sites (

Line 5346: FND_MSG_PUB.ADD;

5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5348: END find_duplicate_party_sites;
5349:
5350: PROCEDURE find_duplicate_contacts (

Line 5435: FND_MSG_PUB.ADD;

5431: WHEN OTHERS THEN
5432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5435: FND_MSG_PUB.ADD;
5436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5437: END find_duplicate_contacts;
5438:
5439: PROCEDURE find_duplicate_contact_points (

Line 5508: FND_MSG_PUB.ADD;

5504: WHEN OTHERS THEN
5505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5510: END find_duplicate_contact_points;
5511:
5512: PROCEDURE find_parties_dynamic (

Line 5938: FND_MSG_PUB.ADD;

5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5940: END call_api_dynamic;
5941:
5942:

Line 6182: FND_MSG_PUB.ADD;

6178: WHEN OTHERS THEN
6179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6180: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6182: FND_MSG_PUB.ADD;
6183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6184: END get_matching_party_sites;
6185:
6186:

Line 6410: FND_MSG_PUB.ADD;

6406: WHEN OTHERS THEN
6407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6412: END get_matching_contacts;
6413:
6414:

Line 6552: FND_MSG_PUB.ADD;

6548: WHEN OTHERS THEN
6549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');
6551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6552: FND_MSG_PUB.ADD;
6553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6554: END get_matching_contact_points;
6555:
6556: /**********************************************************

Line 6807: FND_MSG_PUB.ADD;

6803: WHEN OTHERS THEN
6804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6805: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6807: FND_MSG_PUB.ADD;
6808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6809: END get_score_details;
6810:
6811:

Line 6917: FND_MSG_PUB.ADD;

6913: WHEN OTHERS THEN
6914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6915: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6916: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6917: FND_MSG_PUB.ADD;
6918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6919: END get_party_for_search;
6920:
6921: PROCEDURE get_search_criteria (

Line 6963: FND_MSG_PUB.ADD;

6959: WHEN OTHERS THEN
6960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6961: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6963: FND_MSG_PUB.ADD;
6964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6965: END get_search_criteria;
6966:
6967:

Line 7052: FND_MSG_PUB.ADD;

7048: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7049: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7050: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7052: FND_MSG_PUB.ADD;
7053: RAISE FND_API.G_EXC_ERROR;
7054: END get_party_rec;
7055:
7056: /************************************************

Line 7116: FND_MSG_PUB.ADD;

7112: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7113: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7114: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7116: FND_MSG_PUB.ADD;
7117: RAISE FND_API.G_EXC_ERROR;
7118: END get_party_site_rec;
7119:
7120: /************************************************

Line 7172: FND_MSG_PUB.ADD;

7168: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7169: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7170: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7172: FND_MSG_PUB.ADD;
7173: RAISE FND_API.G_EXC_ERROR;
7174: END get_contact_rec;
7175:
7176: /************************************************

Line 7230: FND_MSG_PUB.ADD;

7226: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7227: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7228: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7230: FND_MSG_PUB.ADD;
7231: RAISE FND_API.G_EXC_ERROR;
7232: END get_contact_point_rec;
7233:
7234: /************************************************

Line 7560: FND_MSG_PUB.ADD;

7556: WHEN OTHERS THEN
7557: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7558: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7560: FND_MSG_PUB.ADD;
7561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7562: END;
7563:
7564:

Line 7767: FND_MSG_PUB.ADD;

7763: WHEN OTHERS THEN
7764: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7765: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7767: FND_MSG_PUB.ADD;
7768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7769: END;
7770:
7771:

Line 7809: FND_MSG_PUB.ADD;

7805: WHEN OTHERS THEN
7806: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7807: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7809: FND_MSG_PUB.ADD;
7810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7811: END;
7812:
7813:

Line 7953: FND_MSG_PUB.ADD;

7949: WHEN OTHERS THEN
7950: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7951: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7953: FND_MSG_PUB.ADD;
7954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7955: END;
7956:
7957:

Line 7977: FND_MSG_PUB.ADD;

7973: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7974: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7975: ) THEN
7976: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7977: FND_MSG_PUB.ADD;
7978: RAISE FND_API.G_EXC_ERROR;
7979: END IF;
7980: END LOOP;
7981:

Line 8058: FND_MSG_PUB.ADD;

8054: WHEN OTHERS THEN
8055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8056: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8058: FND_MSG_PUB.ADD;
8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8060: END check_prim_cond;
8061:
8062: /************************************************

Line 8122: FND_MSG_PUB.ADD;

8118: WHEN OTHERS THEN
8119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8120: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8121: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8122: FND_MSG_PUB.ADD;
8123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8124: END check_party_site_cond;
8125:
8126: /************************************************

Line 8170: FND_MSG_PUB.ADD;

8166: WHEN OTHERS THEN
8167: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8168: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8170: FND_MSG_PUB.ADD;
8171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8172: END check_contact_cond;
8173:
8174: /************************************************

Line 8191: FND_MSG_PUB.ADD;

8187:
8188: FOR I IN 1..p_contact_point_list.COUNT LOOP
8189: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8190: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8191: FND_MSG_PUB.ADD;
8192: RAISE FND_API.G_EXC_ERROR;
8193: END IF;
8194: END LOOP;
8195:

Line 8217: FND_MSG_PUB.ADD;

8213: WHEN OTHERS THEN
8214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8215: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8217: FND_MSG_PUB.ADD;
8218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8219: END check_contact_point_cond;
8220:
8221: FUNCTION check_staged RETURN BOOLEAN IS