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

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

Line 2468: FND_MSG_PUB.ADD;

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

Line 2472: FND_MSG_PUB.ADD;

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

Line 2477: FND_MSG_PUB.ADD;

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

Line 2709: FND_MSG_PUB.ADD;

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

Line 2713: FND_MSG_PUB.ADD;

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

Line 2717: FND_MSG_PUB.ADD;

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

Line 2722: FND_MSG_PUB.ADD;

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

Line 2856: FND_MSG_PUB.ADD;

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

Line 2860: FND_MSG_PUB.ADD;

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

Line 2864: FND_MSG_PUB.ADD;

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

Line 2869: FND_MSG_PUB.ADD;

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

Line 3129: FND_MSG_PUB.ADD;

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

Line 3133: FND_MSG_PUB.ADD;

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

Line 3137: FND_MSG_PUB.ADD;

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

Line 3142: FND_MSG_PUB.ADD;

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

Line 3411: FND_MSG_PUB.ADD;

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

Line 3459: FND_MSG_PUB.ADD;

3455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3456: 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);
3457: END IF;
3458: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3459: FND_MSG_PUB.ADD;
3460: RAISE FND_API.G_EXC_ERROR;
3461: ELSE
3462: push_eval;
3463: RETURN;

Line 3532: FND_MSG_PUB.ADD;

3528: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3529: 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);
3530: END IF;
3531: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3532: FND_MSG_PUB.ADD;
3533: RAISE FND_API.G_EXC_ERROR;
3534: ELSE
3535: push_eval;
3536: RETURN;

Line 3644: FND_MSG_PUB.ADD;

3640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3641: 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);
3642: END IF;
3643: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3644: FND_MSG_PUB.ADD;
3645: RAISE FND_API.G_EXC_ERROR;
3646: ELSE
3647: push_eval;
3648: RETURN;

Line 3755: FND_MSG_PUB.ADD;

3751: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3752: 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);
3753: END IF;
3754: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3755: FND_MSG_PUB.ADD;
3756: RAISE FND_API.G_EXC_ERROR;
3757: ELSE
3758: push_eval;
3759: RETURN;

Line 3980: FND_MSG_PUB.ADD;

3976: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3977: 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);
3978: END IF;
3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3980: FND_MSG_PUB.ADD;
3981: RAISE FND_API.G_EXC_ERROR;
3982: END IF;
3983: ELSE
3984: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3988: FND_MSG_PUB.ADD;

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

Line 4196: FND_MSG_PUB.ADD;

4192: WHEN OTHERS THEN
4193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4194: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4196: FND_MSG_PUB.ADD;
4197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4198: END find_parties;
4199:
4200: PROCEDURE find_persons (

Line 4405: FND_MSG_PUB.ADD;

4401: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4402: 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);
4403: END IF;
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4405: FND_MSG_PUB.ADD;
4406: RAISE FND_API.G_EXC_ERROR;
4407: ELSE
4408: push_eval;
4409: RETURN;

Line 4453: FND_MSG_PUB.ADD;

4449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4450: 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);
4451: END IF;
4452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4453: FND_MSG_PUB.ADD;
4454: RAISE FND_API.G_EXC_ERROR;
4455: ELSE
4456: push_eval;
4457: RETURN;

Line 4489: FND_MSG_PUB.ADD;

4485: exception
4486: when others then
4487: if (instrb(SQLERRM,'DRG-51030')>0) then
4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;
4491: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4493: FND_MSG_PUB.ADD;

Line 4493: FND_MSG_PUB.ADD;

4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;
4491: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4493: FND_MSG_PUB.ADD;
4494: RAISE FND_API.G_EXC_ERROR;
4495: else
4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4497: end if;

Line 4565: FND_MSG_PUB.ADD;

4561: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4562: 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);
4563: END IF;
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_ERROR;
4567: ELSE
4568: push_eval;
4569: RETURN;

Line 4824: FND_MSG_PUB.ADD;

4820: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4821: 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);
4822: END IF;
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4824: FND_MSG_PUB.ADD;
4825: RAISE FND_API.G_EXC_ERROR;
4826: ELSE
4827: push_eval;
4828: RETURN;

Line 4937: FND_MSG_PUB.ADD;

4933: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4934: 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);
4935: END IF;
4936: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4937: FND_MSG_PUB.ADD;
4938: RAISE FND_API.G_EXC_ERROR;
4939: END IF;
4940: ELSE
4941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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: END IF;
4949: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 5068: FND_MSG_PUB.ADD;

5064: WHEN OTHERS THEN
5065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5070: END find_persons;
5071:
5072: PROCEDURE find_persons (

Line 5136: FND_MSG_PUB.ADD;

5132: WHEN OTHERS THEN
5133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5134: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5136: FND_MSG_PUB.ADD;
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: END find_party_details;
5139:
5140: PROCEDURE find_duplicate_parties (

Line 5253: FND_MSG_PUB.ADD;

5249: WHEN OTHERS THEN
5250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5251: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5253: FND_MSG_PUB.ADD;
5254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5255: END find_duplicate_parties;
5256:
5257: PROCEDURE find_duplicate_party_sites (

Line 5338: FND_MSG_PUB.ADD;

5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340: END find_duplicate_party_sites;
5341:
5342: PROCEDURE find_duplicate_contacts (

Line 5427: FND_MSG_PUB.ADD;

5423: WHEN OTHERS THEN
5424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5425: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5427: FND_MSG_PUB.ADD;
5428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5429: END find_duplicate_contacts;
5430:
5431: PROCEDURE find_duplicate_contact_points (

Line 5500: FND_MSG_PUB.ADD;

5496: WHEN OTHERS THEN
5497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5498: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5500: FND_MSG_PUB.ADD;
5501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5502: END find_duplicate_contact_points;
5503:
5504: PROCEDURE find_parties_dynamic (

Line 5930: FND_MSG_PUB.ADD;

5926: WHEN OTHERS THEN
5927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5932: END call_api_dynamic;
5933:
5934:

Line 6174: FND_MSG_PUB.ADD;

6170: WHEN OTHERS THEN
6171: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6172: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6174: FND_MSG_PUB.ADD;
6175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6176: END get_matching_party_sites;
6177:
6178:

Line 6402: FND_MSG_PUB.ADD;

6398: WHEN OTHERS THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6404: END get_matching_contacts;
6405:
6406:

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

6792: WHEN OTHERS THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6796: FND_MSG_PUB.ADD;
6797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6798: END get_score_details;
6799:
6800:

Line 6906: FND_MSG_PUB.ADD;

6902: WHEN OTHERS THEN
6903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6904: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6906: FND_MSG_PUB.ADD;
6907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6908: END get_party_for_search;
6909:
6910: PROCEDURE get_search_criteria (

Line 6952: FND_MSG_PUB.ADD;

6948: WHEN OTHERS THEN
6949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6950: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6951: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6952: FND_MSG_PUB.ADD;
6953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6954: END get_search_criteria;
6955:
6956:

Line 7041: FND_MSG_PUB.ADD;

7037: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7038: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7039: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7041: FND_MSG_PUB.ADD;
7042: RAISE FND_API.G_EXC_ERROR;
7043: END get_party_rec;
7044:
7045: /************************************************

Line 7105: FND_MSG_PUB.ADD;

7101: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7102: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7103: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7105: FND_MSG_PUB.ADD;
7106: RAISE FND_API.G_EXC_ERROR;
7107: END get_party_site_rec;
7108:
7109: /************************************************

Line 7161: FND_MSG_PUB.ADD;

7157: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7158: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7159: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7161: FND_MSG_PUB.ADD;
7162: RAISE FND_API.G_EXC_ERROR;
7163: END get_contact_rec;
7164:
7165: /************************************************

Line 7219: FND_MSG_PUB.ADD;

7215: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7216: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7217: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7218: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7219: FND_MSG_PUB.ADD;
7220: RAISE FND_API.G_EXC_ERROR;
7221: END get_contact_point_rec;
7222:
7223: /************************************************

Line 7549: FND_MSG_PUB.ADD;

7545: WHEN OTHERS THEN
7546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7547: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7549: FND_MSG_PUB.ADD;
7550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7551: END;
7552:
7553:

Line 7756: FND_MSG_PUB.ADD;

7752: WHEN OTHERS THEN
7753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7756: FND_MSG_PUB.ADD;
7757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7758: END;
7759:
7760:

Line 7798: FND_MSG_PUB.ADD;

7794: WHEN OTHERS THEN
7795: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7796: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7798: FND_MSG_PUB.ADD;
7799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7800: END;
7801:
7802:

Line 7942: FND_MSG_PUB.ADD;

7938: WHEN OTHERS THEN
7939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7940: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7942: FND_MSG_PUB.ADD;
7943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7944: END;
7945:
7946:

Line 7966: FND_MSG_PUB.ADD;

7962: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7963: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7964: ) THEN
7965: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7966: FND_MSG_PUB.ADD;
7967: RAISE FND_API.G_EXC_ERROR;
7968: END IF;
7969: END LOOP;
7970:

Line 8047: FND_MSG_PUB.ADD;

8043: WHEN OTHERS THEN
8044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8045: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8047: FND_MSG_PUB.ADD;
8048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8049: END check_prim_cond;
8050:
8051: /************************************************

Line 8111: FND_MSG_PUB.ADD;

8107: WHEN OTHERS THEN
8108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8109: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8111: FND_MSG_PUB.ADD;
8112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8113: END check_party_site_cond;
8114:
8115: /************************************************

Line 8159: FND_MSG_PUB.ADD;

8155: WHEN OTHERS THEN
8156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8157: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8159: FND_MSG_PUB.ADD;
8160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8161: END check_contact_cond;
8162:
8163: /************************************************

Line 8180: FND_MSG_PUB.ADD;

8176:
8177: FOR I IN 1..p_contact_point_list.COUNT LOOP
8178: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8179: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8180: FND_MSG_PUB.ADD;
8181: RAISE FND_API.G_EXC_ERROR;
8182: END IF;
8183: END LOOP;
8184:

Line 8206: FND_MSG_PUB.ADD;

8202: WHEN OTHERS THEN
8203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8204: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8206: FND_MSG_PUB.ADD;
8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8208: END check_contact_point_cond;
8209:
8210: FUNCTION check_staged RETURN BOOLEAN IS