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

697: WHEN OTHERS THEN
698: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
699: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
700: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END;
704:
705:

Line 721: FND_MSG_PUB.ADD;

717: WHEN OTHERS THEN
718: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
719: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
721: FND_MSG_PUB.ADD;
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END;
724:
725:

Line 741: FND_MSG_PUB.ADD;

737: WHEN OTHERS THEN
738: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
739: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
741: FND_MSG_PUB.ADD;
742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
743: END;
744:
745:

Line 761: FND_MSG_PUB.ADD;

757: WHEN OTHERS THEN
758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END;
764:
765: PROCEDURE init_score_context (

Line 828: FND_MSG_PUB.ADD;

824: p_party_site_list,
825: p_contact_list,
826: p_contact_point_list) THEN
827: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
828: FND_MSG_PUB.ADD;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
832: 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 1086: FND_MSG_PUB.ADD;

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

Line 1155: FND_MSG_PUB.ADD;

1151: -- Add the search criteria to query string
1152: IF lengthb(l_contains_str) > 4000 THEN
1153: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1154: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1155: FND_MSG_PUB.ADD;
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: x_denorm_str := l_den_contains_str;
1159: RETURN l_contains_str;

Line 1199: FND_MSG_PUB.ADD;

1195: -- Add the search criteria to query string
1196: IF lengthb(l_contains_str) > 4000 THEN
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1198: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1199: FND_MSG_PUB.ADD;
1200: RAISE FND_API.G_EXC_ERROR;
1201: END IF;
1202: x_denorm_str := l_den_contains_str;
1203: RETURN l_contains_str;

Line 1273: FND_MSG_PUB.ADD;

1269: -- Add the search criteria to query string
1270: IF lengthb(l_contains_str) > 4000 THEN
1271: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_ERROR;
1275: END IF;
1276: x_denorm_str := l_den_contains_str;
1277: RETURN l_contains_str;

Line 1512: FND_MSG_PUB.ADD;

1508: exception
1509: when others then
1510: if (instrb(SQLERRM,'DRG-51030')>0) then
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1515: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1516: FND_MSG_PUB.ADD;

Line 1516: FND_MSG_PUB.ADD;

1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1515: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1516: FND_MSG_PUB.ADD;
1517: RAISE FND_API.G_EXC_ERROR;
1518: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1520: FND_MSG_PUB.ADD;

Line 1520: FND_MSG_PUB.ADD;

1516: FND_MSG_PUB.ADD;
1517: RAISE FND_API.G_EXC_ERROR;
1518: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1520: FND_MSG_PUB.ADD;
1521: RAISE FND_API.G_EXC_ERROR;
1522: else
1523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1525: FND_MSG_PUB.ADD;

1521: RAISE FND_API.G_EXC_ERROR;
1522: else
1523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1525: FND_MSG_PUB.ADD;
1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1527: end if;
1528: END;
1529:

Line 1757: FND_MSG_PUB.ADD;

1753: exception
1754: when others then
1755: if (instrb(SQLERRM,'DRG-51030')>0) then
1756: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1761: FND_MSG_PUB.ADD;

Line 1761: FND_MSG_PUB.ADD;

1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1761: FND_MSG_PUB.ADD;
1762: RAISE FND_API.G_EXC_ERROR;
1763: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1765: FND_MSG_PUB.ADD;

Line 1765: FND_MSG_PUB.ADD;

1761: FND_MSG_PUB.ADD;
1762: RAISE FND_API.G_EXC_ERROR;
1763: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1765: FND_MSG_PUB.ADD;
1766: RAISE FND_API.G_EXC_ERROR;
1767: else
1768: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1770: FND_MSG_PUB.ADD;

1766: RAISE FND_API.G_EXC_ERROR;
1767: else
1768: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1770: FND_MSG_PUB.ADD;
1771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1772: end if;
1773: END;
1774:

Line 1904: FND_MSG_PUB.ADD;

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

Line 1908: FND_MSG_PUB.ADD;

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

Line 1912: FND_MSG_PUB.ADD;

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

Line 1917: FND_MSG_PUB.ADD;

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

Line 2177: FND_MSG_PUB.ADD;

2173: exception
2174: when others then
2175: if (instrb(SQLERRM,'DRG-51030')>0) then
2176: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2177: FND_MSG_PUB.ADD;
2178: RAISE FND_API.G_EXC_ERROR;
2179: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2180: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2181: FND_MSG_PUB.ADD;

Line 2181: FND_MSG_PUB.ADD;

2177: FND_MSG_PUB.ADD;
2178: RAISE FND_API.G_EXC_ERROR;
2179: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2180: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2185: FND_MSG_PUB.ADD;

Line 2185: FND_MSG_PUB.ADD;

2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2185: FND_MSG_PUB.ADD;
2186: RAISE FND_API.G_EXC_ERROR;
2187: else
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2190: FND_MSG_PUB.ADD;

2186: RAISE FND_API.G_EXC_ERROR;
2187: else
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2190: FND_MSG_PUB.ADD;
2191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2192: end if;
2193: END;
2194:

Line 2443: FND_MSG_PUB.ADD;

2439: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2440: 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);
2441: END IF;
2442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2443: FND_MSG_PUB.ADD;
2444: RAISE FND_API.G_EXC_ERROR;
2445: ELSE
2446: push_eval;
2447: RETURN;

Line 2491: FND_MSG_PUB.ADD;

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

Line 2564: FND_MSG_PUB.ADD;

2560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2561: 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);
2562: END IF;
2563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2564: FND_MSG_PUB.ADD;
2565: RAISE FND_API.G_EXC_ERROR;
2566: ELSE
2567: push_eval;
2568: RETURN;

Line 2676: FND_MSG_PUB.ADD;

2672: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2673: 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);
2674: END IF;
2675: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2676: FND_MSG_PUB.ADD;
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSE
2679: push_eval;
2680: RETURN;

Line 2787: FND_MSG_PUB.ADD;

2783: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2784: 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);
2785: END IF;
2786: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2787: FND_MSG_PUB.ADD;
2788: RAISE FND_API.G_EXC_ERROR;
2789: ELSE
2790: push_eval;
2791: RETURN;

Line 3012: FND_MSG_PUB.ADD;

3008: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3009: 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);
3010: END IF;
3011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3012: FND_MSG_PUB.ADD;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END IF;
3015: ELSE
3016: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3020: FND_MSG_PUB.ADD;

3016: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3017: 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);
3018: END IF;
3019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_ERROR;
3022: END IF;
3023: END IF;
3024: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3228: FND_MSG_PUB.ADD;

3224: WHEN OTHERS THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3226: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_parties');
3227: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END find_parties;
3231:
3232: PROCEDURE find_persons (

Line 3421: FND_MSG_PUB.ADD;

3417: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3418: 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);
3419: END IF;
3420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3421: FND_MSG_PUB.ADD;
3422: RAISE FND_API.G_EXC_ERROR;
3423: ELSE
3424: push_eval;
3425: RETURN;

Line 3469: FND_MSG_PUB.ADD;

3465: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3466: 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);
3467: END IF;
3468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3469: FND_MSG_PUB.ADD;
3470: RAISE FND_API.G_EXC_ERROR;
3471: ELSE
3472: push_eval;
3473: RETURN;

Line 3505: FND_MSG_PUB.ADD;

3501: exception
3502: when others then
3503: if (instrb(SQLERRM,'DRG-51030')>0) then
3504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3505: FND_MSG_PUB.ADD;
3506: RAISE FND_API.G_EXC_ERROR;
3507: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3508: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3509: FND_MSG_PUB.ADD;

Line 3509: FND_MSG_PUB.ADD;

3505: FND_MSG_PUB.ADD;
3506: RAISE FND_API.G_EXC_ERROR;
3507: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3508: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3509: FND_MSG_PUB.ADD;
3510: RAISE FND_API.G_EXC_ERROR;
3511: else
3512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3513: end if;

Line 3581: FND_MSG_PUB.ADD;

3577: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3578: 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);
3579: END IF;
3580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3581: FND_MSG_PUB.ADD;
3582: RAISE FND_API.G_EXC_ERROR;
3583: ELSE
3584: push_eval;
3585: RETURN;

Line 3840: FND_MSG_PUB.ADD;

3836: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3837: 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);
3838: END IF;
3839: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3840: FND_MSG_PUB.ADD;
3841: RAISE FND_API.G_EXC_ERROR;
3842: ELSE
3843: push_eval;
3844: RETURN;

Line 3953: FND_MSG_PUB.ADD;

3949: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3950: 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);
3951: END IF;
3952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3953: FND_MSG_PUB.ADD;
3954: RAISE FND_API.G_EXC_ERROR;
3955: END IF;
3956: ELSE
3957: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3961: FND_MSG_PUB.ADD;

3957: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3958: 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);
3959: END IF;
3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3961: FND_MSG_PUB.ADD;
3962: RAISE FND_API.G_EXC_ERROR;
3963: END IF;
3964: END IF;
3965: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4084: FND_MSG_PUB.ADD;

4080: WHEN OTHERS THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4082: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_persons');
4083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4084: FND_MSG_PUB.ADD;
4085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4086: END find_persons;
4087:
4088: PROCEDURE find_persons (

Line 4152: FND_MSG_PUB.ADD;

4148: WHEN OTHERS THEN
4149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4150: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_party_details');
4151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4152: FND_MSG_PUB.ADD;
4153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4154: END find_party_details;
4155:
4156: PROCEDURE find_duplicate_parties (

Line 4269: FND_MSG_PUB.ADD;

4265: WHEN OTHERS THEN
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_parties');
4268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4269: FND_MSG_PUB.ADD;
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: END find_duplicate_parties;
4272:
4273: PROCEDURE find_duplicate_party_sites (

Line 4354: FND_MSG_PUB.ADD;

4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_party_sites');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: END find_duplicate_party_sites;
4357:
4358: PROCEDURE find_duplicate_contacts (

Line 4443: FND_MSG_PUB.ADD;

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

Line 4516: FND_MSG_PUB.ADD;

4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contact_points');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4518: END find_duplicate_contact_points;
4519:
4520: PROCEDURE find_parties_dynamic (

Line 4821: FND_MSG_PUB.ADD;

4817: WHEN OTHERS THEN
4818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4819: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');
4820: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4821: FND_MSG_PUB.ADD;
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: END call_api_dynamic;
4824:
4825:

Line 5057: FND_MSG_PUB.ADD;

5053: WHEN OTHERS THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');
5056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5057: FND_MSG_PUB.ADD;
5058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5059: END get_matching_party_sites;
5060:
5061:

Line 5285: FND_MSG_PUB.ADD;

5281: WHEN OTHERS THEN
5282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5283: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contacts');
5284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5285: FND_MSG_PUB.ADD;
5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5287: END get_matching_contacts;
5288:
5289:

Line 5425: FND_MSG_PUB.ADD;

5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');
5424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5425: FND_MSG_PUB.ADD;
5426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5427: END get_matching_contact_points;
5428:
5429: /**********************************************************

Line 5639: FND_MSG_PUB.ADD;

5635: WHEN OTHERS THEN
5636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5637: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5639: FND_MSG_PUB.ADD;
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: END get_score_details;
5642:
5643:

Line 5762: FND_MSG_PUB.ADD;

5758: WHEN OTHERS THEN
5759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5760: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5762: FND_MSG_PUB.ADD;
5763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5764: END get_party_for_search;
5765:
5766: PROCEDURE get_search_criteria (

Line 5814: FND_MSG_PUB.ADD;

5810: WHEN OTHERS THEN
5811: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5812: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5813: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5814: FND_MSG_PUB.ADD;
5815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5816: END get_search_criteria;
5817:
5818:

Line 5879: FND_MSG_PUB.ADD;

5875: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5876: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5877: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5878: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5879: FND_MSG_PUB.ADD;
5880: RAISE FND_API.G_EXC_ERROR;
5881: END get_party_rec;
5882:
5883: /************************************************

Line 5935: FND_MSG_PUB.ADD;

5931: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5933: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5935: FND_MSG_PUB.ADD;
5936: RAISE FND_API.G_EXC_ERROR;
5937: END get_party_site_rec;
5938:
5939: /************************************************

Line 5993: FND_MSG_PUB.ADD;

5989: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5990: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5991: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;
5995: END get_contact_rec;
5996:
5997: /************************************************

Line 6047: FND_MSG_PUB.ADD;

6043: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6044: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6045: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6047: FND_MSG_PUB.ADD;
6048: RAISE FND_API.G_EXC_ERROR;
6049: END get_contact_point_rec;
6050:
6051: /************************************************

Line 6188: FND_MSG_PUB.ADD;

6184: WHEN OTHERS THEN
6185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6186: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6188: FND_MSG_PUB.ADD;
6189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6190: END;
6191:
6192:

Line 6306: FND_MSG_PUB.ADD;

6302: WHEN OTHERS THEN
6303: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6304: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6306: FND_MSG_PUB.ADD;
6307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6308: END;
6309:
6310:

Line 6386: FND_MSG_PUB.ADD;

6382: WHEN OTHERS THEN
6383: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6384: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6386: FND_MSG_PUB.ADD;
6387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6388: END;
6389:
6390:

Line 6478: FND_MSG_PUB.ADD;

6474: WHEN OTHERS THEN
6475: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6476: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6478: FND_MSG_PUB.ADD;
6479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6480: END;
6481:
6482:

Line 6502: FND_MSG_PUB.ADD;

6498: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6499: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6500: ) THEN
6501: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6502: FND_MSG_PUB.ADD;
6503: RAISE FND_API.G_EXC_ERROR;
6504: END IF;
6505: END LOOP;
6506:

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','check_prim_cond');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END check_prim_cond;
6547:
6548: /************************************************

Line 6598: FND_MSG_PUB.ADD;

6594: WHEN OTHERS THEN
6595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6596: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6598: FND_MSG_PUB.ADD;
6599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6600: END check_party_site_cond;
6601:
6602: /************************************************

Line 6652: FND_MSG_PUB.ADD;

6648: WHEN OTHERS THEN
6649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6650: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6652: FND_MSG_PUB.ADD;
6653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6654: END check_contact_cond;
6655:
6656: /************************************************

Line 6673: FND_MSG_PUB.ADD;

6669:
6670: FOR I IN 1..p_contact_point_list.COUNT LOOP
6671: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6672: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6673: FND_MSG_PUB.ADD;
6674: RAISE FND_API.G_EXC_ERROR;
6675: END IF;
6676: END LOOP;
6677:

Line 6697: FND_MSG_PUB.ADD;

6693: WHEN OTHERS THEN
6694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6695: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6697: FND_MSG_PUB.ADD;
6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6699: END check_contact_point_cond;
6700:
6701: FUNCTION check_staged RETURN BOOLEAN IS