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

528: WHEN OTHERS THEN
529: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
530: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END;
535:
536:

Line 552: FND_MSG_PUB.ADD;

548: WHEN OTHERS THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
550: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END;
555:
556:

Line 572: FND_MSG_PUB.ADD;

568: WHEN OTHERS THEN
569: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
570: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END;
575:
576:

Line 592: FND_MSG_PUB.ADD;

588: WHEN OTHERS THEN
589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END;
595:
596: PROCEDURE init_score_context (

Line 659: FND_MSG_PUB.ADD;

655: p_party_site_list,
656: p_contact_list,
657: p_contact_point_list) THEN
658: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
659: FND_MSG_PUB.ADD;
660: RAISE FND_API.G_EXC_ERROR;
661: END IF;
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: 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 917: FND_MSG_PUB.ADD;

913: END IF;
914: IF lengthb(l_party_contains_str) > 4000 THEN
915: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
916: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: IF (p_match_str = ' AND ' OR p_party_max_score 921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 976: FND_MSG_PUB.ADD;

972: -- Add the search criteria to query string
973: IF lengthb(l_contains_str) > 4000 THEN
974: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
975: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
976: FND_MSG_PUB.ADD;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: x_denorm_str := l_den_contains_str;
980: RETURN l_contains_str;

Line 1241: FND_MSG_PUB.ADD;

1237: exception
1238: when others then
1239: if (instrb(SQLERRM,'DRG-51030')>0) then
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1241: FND_MSG_PUB.ADD;
1242: RAISE FND_API.G_EXC_ERROR;
1243: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1245: FND_MSG_PUB.ADD;

Line 1245: FND_MSG_PUB.ADD;

1241: FND_MSG_PUB.ADD;
1242: RAISE FND_API.G_EXC_ERROR;
1243: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1245: FND_MSG_PUB.ADD;
1246: RAISE FND_API.G_EXC_ERROR;
1247: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1249: FND_MSG_PUB.ADD;

Line 1249: FND_MSG_PUB.ADD;

1245: FND_MSG_PUB.ADD;
1246: RAISE FND_API.G_EXC_ERROR;
1247: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1249: FND_MSG_PUB.ADD;
1250: RAISE FND_API.G_EXC_ERROR;
1251: else
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1253: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1254: FND_MSG_PUB.ADD;

1250: RAISE FND_API.G_EXC_ERROR;
1251: else
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1253: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256: end if;
1257: END;
1258:

Line 1486: FND_MSG_PUB.ADD;

1482: exception
1483: when others then
1484: if (instrb(SQLERRM,'DRG-51030')>0) then
1485: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1486: FND_MSG_PUB.ADD;
1487: RAISE FND_API.G_EXC_ERROR;
1488: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1490: FND_MSG_PUB.ADD;

Line 1490: FND_MSG_PUB.ADD;

1486: FND_MSG_PUB.ADD;
1487: RAISE FND_API.G_EXC_ERROR;
1488: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1490: FND_MSG_PUB.ADD;
1491: RAISE FND_API.G_EXC_ERROR;
1492: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1494: FND_MSG_PUB.ADD;

Line 1494: FND_MSG_PUB.ADD;

1490: FND_MSG_PUB.ADD;
1491: RAISE FND_API.G_EXC_ERROR;
1492: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1494: FND_MSG_PUB.ADD;
1495: RAISE FND_API.G_EXC_ERROR;
1496: else
1497: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1498: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1499: FND_MSG_PUB.ADD;

1495: RAISE FND_API.G_EXC_ERROR;
1496: else
1497: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1498: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1499: FND_MSG_PUB.ADD;
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: end if;
1502: END;
1503:

Line 1633: FND_MSG_PUB.ADD;

1629: exception
1630: when others then
1631: if (instrb(SQLERRM,'DRG-51030')>0) then
1632: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1633: FND_MSG_PUB.ADD;
1634: RAISE FND_API.G_EXC_ERROR;
1635: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1637: FND_MSG_PUB.ADD;

Line 1637: FND_MSG_PUB.ADD;

1633: FND_MSG_PUB.ADD;
1634: RAISE FND_API.G_EXC_ERROR;
1635: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1637: FND_MSG_PUB.ADD;
1638: RAISE FND_API.G_EXC_ERROR;
1639: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1641: FND_MSG_PUB.ADD;

Line 1641: FND_MSG_PUB.ADD;

1637: FND_MSG_PUB.ADD;
1638: RAISE FND_API.G_EXC_ERROR;
1639: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1641: FND_MSG_PUB.ADD;
1642: RAISE FND_API.G_EXC_ERROR;
1643: else
1644: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1645: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1646: FND_MSG_PUB.ADD;

1642: RAISE FND_API.G_EXC_ERROR;
1643: else
1644: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1645: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1646: FND_MSG_PUB.ADD;
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: end if;
1649: END;
1650:

Line 1906: FND_MSG_PUB.ADD;

1902: exception
1903: when others then
1904: if (instrb(SQLERRM,'DRG-51030')>0) then
1905: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1906: FND_MSG_PUB.ADD;
1907: RAISE FND_API.G_EXC_ERROR;
1908: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1909: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1910: FND_MSG_PUB.ADD;

Line 1910: FND_MSG_PUB.ADD;

1906: FND_MSG_PUB.ADD;
1907: RAISE FND_API.G_EXC_ERROR;
1908: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1909: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1914: FND_MSG_PUB.ADD;

Line 1914: FND_MSG_PUB.ADD;

1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1914: FND_MSG_PUB.ADD;
1915: RAISE FND_API.G_EXC_ERROR;
1916: else
1917: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1918: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1919: FND_MSG_PUB.ADD;

1915: RAISE FND_API.G_EXC_ERROR;
1916: else
1917: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1918: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1919: FND_MSG_PUB.ADD;
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: end if;
1922: END;
1923:

Line 2166: FND_MSG_PUB.ADD;

2162: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2163: 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);
2164: END IF;
2165: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2166: FND_MSG_PUB.ADD;
2167: RAISE FND_API.G_EXC_ERROR;
2168: ELSE
2169: push_eval;
2170: RETURN;

Line 2214: FND_MSG_PUB.ADD;

2210: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2211: 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);
2212: END IF;
2213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2214: FND_MSG_PUB.ADD;
2215: RAISE FND_API.G_EXC_ERROR;
2216: ELSE
2217: push_eval;
2218: RETURN;

Line 2287: FND_MSG_PUB.ADD;

2283: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2284: 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);
2285: END IF;
2286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2287: FND_MSG_PUB.ADD;
2288: RAISE FND_API.G_EXC_ERROR;
2289: ELSE
2290: push_eval;
2291: RETURN;

Line 2399: FND_MSG_PUB.ADD;

2395: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2396: 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);
2397: END IF;
2398: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2399: FND_MSG_PUB.ADD;
2400: RAISE FND_API.G_EXC_ERROR;
2401: ELSE
2402: push_eval;
2403: RETURN;

Line 2510: FND_MSG_PUB.ADD;

2506: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2507: 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);
2508: END IF;
2509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2510: FND_MSG_PUB.ADD;
2511: RAISE FND_API.G_EXC_ERROR;
2512: ELSE
2513: push_eval;
2514: RETURN;

Line 2654: FND_MSG_PUB.ADD;

2650: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2651: 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);
2652: END IF;
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2654: FND_MSG_PUB.ADD;
2655: RAISE FND_API.G_EXC_ERROR;
2656: END IF;
2657: ELSE
2658: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2662: FND_MSG_PUB.ADD;

2658: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2659: 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);
2660: END IF;
2661: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2662: FND_MSG_PUB.ADD;
2663: RAISE FND_API.G_EXC_ERROR;
2664: END IF;
2665: END IF;
2666: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2913: FND_MSG_PUB.ADD;

2909: WHEN OTHERS THEN
2910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2913: FND_MSG_PUB.ADD;
2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2915: END find_parties;
2916:
2917: PROCEDURE find_persons (

Line 3100: FND_MSG_PUB.ADD;

3096: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3097: 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);
3098: END IF;
3099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3100: FND_MSG_PUB.ADD;
3101: RAISE FND_API.G_EXC_ERROR;
3102: ELSE
3103: push_eval;
3104: RETURN;

Line 3148: FND_MSG_PUB.ADD;

3144: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3145: 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);
3146: END IF;
3147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3148: FND_MSG_PUB.ADD;
3149: RAISE FND_API.G_EXC_ERROR;
3150: ELSE
3151: push_eval;
3152: RETURN;

Line 3184: FND_MSG_PUB.ADD;

3180: exception
3181: when others then
3182: if (instrb(SQLERRM,'DRG-51030')>0) then
3183: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3184: FND_MSG_PUB.ADD;
3185: RAISE FND_API.G_EXC_ERROR;
3186: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3188: FND_MSG_PUB.ADD;

Line 3188: FND_MSG_PUB.ADD;

3184: FND_MSG_PUB.ADD;
3185: RAISE FND_API.G_EXC_ERROR;
3186: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: else
3191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3192: end if;

Line 3260: FND_MSG_PUB.ADD;

3256: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3257: 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);
3258: END IF;
3259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3260: FND_MSG_PUB.ADD;
3261: RAISE FND_API.G_EXC_ERROR;
3262: ELSE
3263: push_eval;
3264: RETURN;

Line 3449: FND_MSG_PUB.ADD;

3445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3446: 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);
3447: END IF;
3448: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3449: FND_MSG_PUB.ADD;
3450: RAISE FND_API.G_EXC_ERROR;
3451: ELSE
3452: push_eval;
3453: 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 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);
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: END IF;
3540: ELSE
3541: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3545: FND_MSG_PUB.ADD;

3541: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3542: 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);
3543: END IF;
3544: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3545: FND_MSG_PUB.ADD;
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548: END IF;
3549: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3694: FND_MSG_PUB.ADD;

3690: WHEN OTHERS THEN
3691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3694: FND_MSG_PUB.ADD;
3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3696: END find_persons;
3697:
3698: PROCEDURE find_persons (

Line 3762: FND_MSG_PUB.ADD;

3758: WHEN OTHERS THEN
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3760: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3764: END find_party_details;
3765:
3766: PROCEDURE find_duplicate_parties (

Line 3879: FND_MSG_PUB.ADD;

3875: WHEN OTHERS THEN
3876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3877: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3878: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3879: FND_MSG_PUB.ADD;
3880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3881: END find_duplicate_parties;
3882:
3883: PROCEDURE find_duplicate_party_sites (

Line 3964: FND_MSG_PUB.ADD;

3960: WHEN OTHERS THEN
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3964: FND_MSG_PUB.ADD;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3966: END find_duplicate_party_sites;
3967:
3968: PROCEDURE find_duplicate_contacts (

Line 4053: FND_MSG_PUB.ADD;

4049: WHEN OTHERS THEN
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4053: FND_MSG_PUB.ADD;
4054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4055: END find_duplicate_contacts;
4056:
4057: PROCEDURE find_duplicate_contact_points (

Line 4126: FND_MSG_PUB.ADD;

4122: WHEN OTHERS THEN
4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4124: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');
4125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4126: FND_MSG_PUB.ADD;
4127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4128: END find_duplicate_contact_points;
4129:
4130: PROCEDURE find_parties_dynamic (

Line 4393: FND_MSG_PUB.ADD;

4389: WHEN OTHERS THEN
4390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4391: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4393: FND_MSG_PUB.ADD;
4394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4395: END call_api_dynamic;
4396:
4397:

Line 4626: FND_MSG_PUB.ADD;

4622: WHEN OTHERS THEN
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4624: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4625: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4626: FND_MSG_PUB.ADD;
4627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4628: END get_matching_party_sites;
4629:
4630:

Line 4851: FND_MSG_PUB.ADD;

4847: WHEN OTHERS THEN
4848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4851: FND_MSG_PUB.ADD;
4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4853: END get_matching_contacts;
4854:
4855:

Line 4990: FND_MSG_PUB.ADD;

4986: WHEN OTHERS THEN
4987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4988: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4989: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4990: FND_MSG_PUB.ADD;
4991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4992: END get_matching_contact_points;
4993:
4994: /**********************************************************

Line 5187: FND_MSG_PUB.ADD;

5183: WHEN OTHERS THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5187: FND_MSG_PUB.ADD;
5188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5189: END get_score_details;
5190:
5191:

Line 5265: FND_MSG_PUB.ADD;

5261: WHEN OTHERS THEN
5262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5263: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5265: FND_MSG_PUB.ADD;
5266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5267: END get_party_for_search;
5268:
5269: PROCEDURE get_search_criteria (

Line 5305: FND_MSG_PUB.ADD;

5301: WHEN OTHERS THEN
5302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5303: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5305: FND_MSG_PUB.ADD;
5306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5307: END get_search_criteria;
5308:
5309:

Line 5370: FND_MSG_PUB.ADD;

5366: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5367: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_ERROR;
5372: END get_party_rec;
5373:
5374: /************************************************

Line 5424: FND_MSG_PUB.ADD;

5420: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5421: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5422: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_ERROR;
5426: END get_party_site_rec;
5427:
5428: /************************************************

Line 5480: FND_MSG_PUB.ADD;

5476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5480: FND_MSG_PUB.ADD;
5481: RAISE FND_API.G_EXC_ERROR;
5482: END get_contact_rec;
5483:
5484: /************************************************

Line 5532: FND_MSG_PUB.ADD;

5528: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5529: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5530: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5532: FND_MSG_PUB.ADD;
5533: RAISE FND_API.G_EXC_ERROR;
5534: END get_contact_point_rec;
5535:
5536: /************************************************

Line 5652: FND_MSG_PUB.ADD;

5648: WHEN OTHERS THEN
5649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5650: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5652: FND_MSG_PUB.ADD;
5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5654: END;
5655:
5656:

Line 5721: FND_MSG_PUB.ADD;

5717: WHEN OTHERS THEN
5718: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5719: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5721: FND_MSG_PUB.ADD;
5722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5723: END;
5724:
5725:

Line 5763: FND_MSG_PUB.ADD;

5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: END;
5766:
5767:

Line 5806: FND_MSG_PUB.ADD;

5802: WHEN OTHERS THEN
5803: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5804: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5806: FND_MSG_PUB.ADD;
5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5808: END;
5809:
5810:

Line 5847: FND_MSG_PUB.ADD;

5843: WHEN OTHERS THEN
5844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5845: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5847: FND_MSG_PUB.ADD;
5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5849: END check_prim_cond;
5850:
5851: /************************************************

Line 5891: FND_MSG_PUB.ADD;

5887: WHEN OTHERS THEN
5888: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5889: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5893: END check_party_site_cond;
5894:
5895: /************************************************

Line 5929: FND_MSG_PUB.ADD;

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

Line 5950: FND_MSG_PUB.ADD;

5946:
5947: FOR I IN 1..p_contact_point_list.COUNT LOOP
5948: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5949: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5950: FND_MSG_PUB.ADD;
5951: RAISE FND_API.G_EXC_ERROR;
5952: END IF;
5953: END LOOP;
5954:

Line 5966: FND_MSG_PUB.ADD;

5962: WHEN OTHERS THEN
5963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5964: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5966: FND_MSG_PUB.ADD;
5967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5968: END check_contact_point_cond;
5969:
5970: FUNCTION check_staged RETURN BOOLEAN IS