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

661: WHEN OTHERS THEN
662: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
663: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END;
668:
669:

Line 685: FND_MSG_PUB.ADD;

681: WHEN OTHERS THEN
682: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
683: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
685: FND_MSG_PUB.ADD;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END;
688:
689:

Line 705: FND_MSG_PUB.ADD;

701: WHEN OTHERS THEN
702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
703: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
705: FND_MSG_PUB.ADD;
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END;
708:
709:

Line 725: FND_MSG_PUB.ADD;

721: WHEN OTHERS THEN
722: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
723: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
724: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
725: FND_MSG_PUB.ADD;
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END;
728:
729: PROCEDURE init_score_context (

Line 792: FND_MSG_PUB.ADD;

788: p_party_site_list,
789: p_contact_list,
790: p_contact_point_list) THEN
791: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
792: FND_MSG_PUB.ADD;
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
796: 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 1084: FND_MSG_PUB.ADD;

1080: END IF;
1081: IF lengthb(l_party_contains_str) > 4000 THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1083: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1084: FND_MSG_PUB.ADD;
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087: IF (p_match_str = ' AND ' OR p_party_max_score 1088: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1205: FND_MSG_PUB.ADD;

1201: -- Add the search criteria to query string
1202: IF lengthb(l_contains_str) > 4000 THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1204: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: x_denorm_str := l_den_contains_str;
1209: RETURN l_contains_str;

Line 1445: FND_MSG_PUB.ADD;

1441: exception
1442: when others then
1443: if (instrb(SQLERRM,'DRG-51030')>0) then
1444: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1445: FND_MSG_PUB.ADD;
1446: RAISE FND_API.G_EXC_ERROR;
1447: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1448: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1449: FND_MSG_PUB.ADD;

Line 1449: FND_MSG_PUB.ADD;

1445: FND_MSG_PUB.ADD;
1446: RAISE FND_API.G_EXC_ERROR;
1447: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1448: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1449: FND_MSG_PUB.ADD;
1450: RAISE FND_API.G_EXC_ERROR;
1451: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1453: FND_MSG_PUB.ADD;

Line 1453: FND_MSG_PUB.ADD;

1449: FND_MSG_PUB.ADD;
1450: RAISE FND_API.G_EXC_ERROR;
1451: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1453: FND_MSG_PUB.ADD;
1454: RAISE FND_API.G_EXC_ERROR;
1455: else
1456: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1458: FND_MSG_PUB.ADD;

1454: RAISE FND_API.G_EXC_ERROR;
1455: else
1456: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1458: FND_MSG_PUB.ADD;
1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1460: end if;
1461: END;
1462:

Line 1690: FND_MSG_PUB.ADD;

1686: exception
1687: when others then
1688: if (instrb(SQLERRM,'DRG-51030')>0) then
1689: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1690: FND_MSG_PUB.ADD;
1691: RAISE FND_API.G_EXC_ERROR;
1692: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1694: FND_MSG_PUB.ADD;

Line 1694: FND_MSG_PUB.ADD;

1690: FND_MSG_PUB.ADD;
1691: RAISE FND_API.G_EXC_ERROR;
1692: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1694: FND_MSG_PUB.ADD;
1695: RAISE FND_API.G_EXC_ERROR;
1696: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1698: FND_MSG_PUB.ADD;

Line 1698: FND_MSG_PUB.ADD;

1694: FND_MSG_PUB.ADD;
1695: RAISE FND_API.G_EXC_ERROR;
1696: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1698: FND_MSG_PUB.ADD;
1699: RAISE FND_API.G_EXC_ERROR;
1700: else
1701: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1702: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1703: FND_MSG_PUB.ADD;

1699: RAISE FND_API.G_EXC_ERROR;
1700: else
1701: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1702: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1703: FND_MSG_PUB.ADD;
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: end if;
1706: END;
1707:

Line 1837: FND_MSG_PUB.ADD;

1833: exception
1834: when others then
1835: if (instrb(SQLERRM,'DRG-51030')>0) then
1836: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1841: FND_MSG_PUB.ADD;

Line 1841: FND_MSG_PUB.ADD;

1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1845: FND_MSG_PUB.ADD;

Line 1845: FND_MSG_PUB.ADD;

1841: FND_MSG_PUB.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1845: FND_MSG_PUB.ADD;
1846: RAISE FND_API.G_EXC_ERROR;
1847: else
1848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1850: FND_MSG_PUB.ADD;

1846: RAISE FND_API.G_EXC_ERROR;
1847: else
1848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1850: FND_MSG_PUB.ADD;
1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1852: end if;
1853: END;
1854:

Line 2110: FND_MSG_PUB.ADD;

2106: exception
2107: when others then
2108: if (instrb(SQLERRM,'DRG-51030')>0) then
2109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2110: FND_MSG_PUB.ADD;
2111: RAISE FND_API.G_EXC_ERROR;
2112: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2114: FND_MSG_PUB.ADD;

Line 2114: FND_MSG_PUB.ADD;

2110: FND_MSG_PUB.ADD;
2111: RAISE FND_API.G_EXC_ERROR;
2112: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2114: FND_MSG_PUB.ADD;
2115: RAISE FND_API.G_EXC_ERROR;
2116: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2118: FND_MSG_PUB.ADD;

Line 2118: FND_MSG_PUB.ADD;

2114: FND_MSG_PUB.ADD;
2115: RAISE FND_API.G_EXC_ERROR;
2116: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2118: FND_MSG_PUB.ADD;
2119: RAISE FND_API.G_EXC_ERROR;
2120: else
2121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2123: FND_MSG_PUB.ADD;

2119: RAISE FND_API.G_EXC_ERROR;
2120: else
2121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2123: FND_MSG_PUB.ADD;
2124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2125: end if;
2126: END;
2127:

Line 2374: FND_MSG_PUB.ADD;

2370: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2371: 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);
2372: END IF;
2373: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_ERROR;
2376: ELSE
2377: push_eval;
2378: RETURN;

Line 2422: FND_MSG_PUB.ADD;

2418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2419: 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);
2420: END IF;
2421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2422: FND_MSG_PUB.ADD;
2423: RAISE FND_API.G_EXC_ERROR;
2424: ELSE
2425: push_eval;
2426: RETURN;

Line 2495: FND_MSG_PUB.ADD;

2491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2492: 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);
2493: END IF;
2494: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2495: FND_MSG_PUB.ADD;
2496: RAISE FND_API.G_EXC_ERROR;
2497: ELSE
2498: push_eval;
2499: RETURN;

Line 2607: FND_MSG_PUB.ADD;

2603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2604: 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);
2605: END IF;
2606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2607: FND_MSG_PUB.ADD;
2608: RAISE FND_API.G_EXC_ERROR;
2609: ELSE
2610: push_eval;
2611: RETURN;

Line 2718: FND_MSG_PUB.ADD;

2714: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2715: 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);
2716: END IF;
2717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2718: FND_MSG_PUB.ADD;
2719: RAISE FND_API.G_EXC_ERROR;
2720: ELSE
2721: push_eval;
2722: RETURN;

Line 2943: FND_MSG_PUB.ADD;

2939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2940: 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);
2941: END IF;
2942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_ERROR;
2945: END IF;
2946: ELSE
2947: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2951: FND_MSG_PUB.ADD;

2947: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2948: 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);
2949: END IF;
2950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2951: FND_MSG_PUB.ADD;
2952: RAISE FND_API.G_EXC_ERROR;
2953: END IF;
2954: END IF;
2955: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3159: FND_MSG_PUB.ADD;

3155: WHEN OTHERS THEN
3156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3157: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3159: FND_MSG_PUB.ADD;
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END find_parties;
3162:
3163: PROCEDURE find_persons (

Line 3350: FND_MSG_PUB.ADD;

3346: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3347: 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);
3348: END IF;
3349: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3350: FND_MSG_PUB.ADD;
3351: RAISE FND_API.G_EXC_ERROR;
3352: ELSE
3353: push_eval;
3354: RETURN;

Line 3398: FND_MSG_PUB.ADD;

3394: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3395: 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);
3396: END IF;
3397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3398: FND_MSG_PUB.ADD;
3399: RAISE FND_API.G_EXC_ERROR;
3400: ELSE
3401: push_eval;
3402: RETURN;

Line 3434: FND_MSG_PUB.ADD;

3430: exception
3431: when others then
3432: if (instrb(SQLERRM,'DRG-51030')>0) then
3433: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3434: FND_MSG_PUB.ADD;
3435: RAISE FND_API.G_EXC_ERROR;
3436: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3438: FND_MSG_PUB.ADD;

Line 3438: FND_MSG_PUB.ADD;

3434: FND_MSG_PUB.ADD;
3435: RAISE FND_API.G_EXC_ERROR;
3436: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3438: FND_MSG_PUB.ADD;
3439: RAISE FND_API.G_EXC_ERROR;
3440: else
3441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3442: end if;

Line 3510: FND_MSG_PUB.ADD;

3506: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3507: 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);
3508: END IF;
3509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3510: FND_MSG_PUB.ADD;
3511: RAISE FND_API.G_EXC_ERROR;
3512: ELSE
3513: push_eval;
3514: 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 3882: FND_MSG_PUB.ADD;

3878: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3879: 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);
3880: END IF;
3881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3882: FND_MSG_PUB.ADD;
3883: RAISE FND_API.G_EXC_ERROR;
3884: END IF;
3885: ELSE
3886: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3890: FND_MSG_PUB.ADD;

3886: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3887: 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);
3888: END IF;
3889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893: END IF;
3894: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4013: FND_MSG_PUB.ADD;

4009: WHEN OTHERS THEN
4010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4013: FND_MSG_PUB.ADD;
4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4015: END find_persons;
4016:
4017: PROCEDURE find_persons (

Line 4081: FND_MSG_PUB.ADD;

4077: WHEN OTHERS THEN
4078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4081: FND_MSG_PUB.ADD;
4082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4083: END find_party_details;
4084:
4085: PROCEDURE find_duplicate_parties (

Line 4198: FND_MSG_PUB.ADD;

4194: WHEN OTHERS THEN
4195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4196: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4198: FND_MSG_PUB.ADD;
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4200: END find_duplicate_parties;
4201:
4202: PROCEDURE find_duplicate_party_sites (

Line 4283: FND_MSG_PUB.ADD;

4279: WHEN OTHERS THEN
4280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4281: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4283: FND_MSG_PUB.ADD;
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: END find_duplicate_party_sites;
4286:
4287: PROCEDURE find_duplicate_contacts (

Line 4372: FND_MSG_PUB.ADD;

4368: WHEN OTHERS THEN
4369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4370: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4372: FND_MSG_PUB.ADD;
4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4374: END find_duplicate_contacts;
4375:
4376: PROCEDURE find_duplicate_contact_points (

Line 4445: FND_MSG_PUB.ADD;

4441: WHEN OTHERS THEN
4442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4443: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4445: FND_MSG_PUB.ADD;
4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4447: END find_duplicate_contact_points;
4448:
4449: PROCEDURE find_parties_dynamic (

Line 4736: FND_MSG_PUB.ADD;

4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: END call_api_dynamic;
4739:
4740:

Line 4970: FND_MSG_PUB.ADD;

4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4972: END get_matching_party_sites;
4973:
4974:

Line 5197: FND_MSG_PUB.ADD;

5193: WHEN OTHERS THEN
5194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5197: FND_MSG_PUB.ADD;
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: END get_matching_contacts;
5200:
5201:

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_61.get_matching_contact_points');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340: END get_matching_contact_points;
5341:
5342: /**********************************************************

Line 5544: FND_MSG_PUB.ADD;

5540: WHEN OTHERS THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5546: END get_score_details;
5547:
5548:

Line 5619: FND_MSG_PUB.ADD;

5615: WHEN OTHERS THEN
5616: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5617: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5618: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5619: FND_MSG_PUB.ADD;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: END get_party_for_search;
5622:
5623: PROCEDURE get_search_criteria (

Line 5659: FND_MSG_PUB.ADD;

5655: WHEN OTHERS THEN
5656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5657: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5661: END get_search_criteria;
5662:
5663:

Line 5726: FND_MSG_PUB.ADD;

5722: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5723: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5724: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_ERROR;
5728: END get_party_rec;
5729:
5730: /************************************************

Line 5778: FND_MSG_PUB.ADD;

5774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5775: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5778: FND_MSG_PUB.ADD;
5779: RAISE FND_API.G_EXC_ERROR;
5780: END get_party_site_rec;
5781:
5782: /************************************************

Line 5834: FND_MSG_PUB.ADD;

5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_contact_rec;
5837:
5838: /************************************************

Line 5888: FND_MSG_PUB.ADD;

5884: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5885: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5886: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5888: FND_MSG_PUB.ADD;
5889: RAISE FND_API.G_EXC_ERROR;
5890: END get_contact_point_rec;
5891:
5892: /************************************************

Line 6081: FND_MSG_PUB.ADD;

6077: WHEN OTHERS THEN
6078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6079: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6081: FND_MSG_PUB.ADD;
6082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6083: END;
6084:
6085:

Line 6124: FND_MSG_PUB.ADD;

6120: WHEN OTHERS THEN
6121: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6122: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6123: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6124: FND_MSG_PUB.ADD;
6125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6126: END;
6127:
6128:

Line 6166: FND_MSG_PUB.ADD;

6162: WHEN OTHERS THEN
6163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6166: FND_MSG_PUB.ADD;
6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6168: END;
6169:
6170:

Line 6271: FND_MSG_PUB.ADD;

6267: WHEN OTHERS THEN
6268: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6269: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6270: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6271: FND_MSG_PUB.ADD;
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: END;
6274:
6275:

Line 6295: FND_MSG_PUB.ADD;

6291: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6292: p_contact_point_list(I).URL IS NOT NULL
6293: ) THEN
6294: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6295: FND_MSG_PUB.ADD;
6296: RAISE FND_API.G_EXC_ERROR;
6297: END IF;
6298: END LOOP;
6299:

Line 6328: FND_MSG_PUB.ADD;

6324: WHEN OTHERS THEN
6325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6326: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6328: FND_MSG_PUB.ADD;
6329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6330: END check_prim_cond;
6331:
6332: /************************************************

Line 6372: FND_MSG_PUB.ADD;

6368: WHEN OTHERS THEN
6369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6370: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6374: END check_party_site_cond;
6375:
6376: /************************************************

Line 6418: FND_MSG_PUB.ADD;

6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6420: END check_contact_cond;
6421:
6422: /************************************************

Line 6439: FND_MSG_PUB.ADD;

6435:
6436: FOR I IN 1..p_contact_point_list.COUNT LOOP
6437: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6438: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6439: FND_MSG_PUB.ADD;
6440: RAISE FND_API.G_EXC_ERROR;
6441: END IF;
6442: END LOOP;
6443:

Line 6463: FND_MSG_PUB.ADD;

6459: WHEN OTHERS THEN
6460: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6461: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6462: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6463: FND_MSG_PUB.ADD;
6464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6465: END check_contact_point_cond;
6466:
6467: FUNCTION check_staged RETURN BOOLEAN IS