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

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

Line 1518: FND_MSG_PUB.ADD;

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

Line 1522: FND_MSG_PUB.ADD;

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

Line 1527: FND_MSG_PUB.ADD;

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

Line 1759: FND_MSG_PUB.ADD;

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

Line 1763: FND_MSG_PUB.ADD;

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

Line 1767: FND_MSG_PUB.ADD;

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

Line 1772: FND_MSG_PUB.ADD;

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

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

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

Line 2183: FND_MSG_PUB.ADD;

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

Line 2187: FND_MSG_PUB.ADD;

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

Line 2192: FND_MSG_PUB.ADD;

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

Line 2446: FND_MSG_PUB.ADD;

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

Line 2494: FND_MSG_PUB.ADD;

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

Line 2567: FND_MSG_PUB.ADD;

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

Line 2679: FND_MSG_PUB.ADD;

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

Line 2790: FND_MSG_PUB.ADD;

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

Line 3015: FND_MSG_PUB.ADD;

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

Line 3023: FND_MSG_PUB.ADD;

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

Line 3231: FND_MSG_PUB.ADD;

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

Line 3425: FND_MSG_PUB.ADD;

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

Line 3473: FND_MSG_PUB.ADD;

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

Line 3509: FND_MSG_PUB.ADD;

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

Line 3513: FND_MSG_PUB.ADD;

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

Line 3585: FND_MSG_PUB.ADD;

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

Line 3844: FND_MSG_PUB.ADD;

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

Line 3957: FND_MSG_PUB.ADD;

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

Line 3965: FND_MSG_PUB.ADD;

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

Line 4088: FND_MSG_PUB.ADD;

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

Line 4156: FND_MSG_PUB.ADD;

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

Line 4273: FND_MSG_PUB.ADD;

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

Line 4358: FND_MSG_PUB.ADD;

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

Line 4447: FND_MSG_PUB.ADD;

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

Line 4520: FND_MSG_PUB.ADD;

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

Line 4825: FND_MSG_PUB.ADD;

4821: WHEN OTHERS THEN
4822: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4823: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');
4824: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4825: FND_MSG_PUB.ADD;
4826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4827: END call_api_dynamic;
4828:
4829:

Line 5061: FND_MSG_PUB.ADD;

5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5059: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');
5060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5061: FND_MSG_PUB.ADD;
5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5063: END get_matching_party_sites;
5064:
5065:

Line 5289: FND_MSG_PUB.ADD;

5285: WHEN OTHERS THEN
5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contacts');
5288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5289: FND_MSG_PUB.ADD;
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: END get_matching_contacts;
5292:
5293:

Line 5429: FND_MSG_PUB.ADD;

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

Line 5644: FND_MSG_PUB.ADD;

5640: WHEN OTHERS THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: END get_score_details;
5647:
5648:

Line 5767: FND_MSG_PUB.ADD;

5763: WHEN OTHERS THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5765: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5769: END get_party_for_search;
5770:
5771: PROCEDURE get_search_criteria (

Line 5819: FND_MSG_PUB.ADD;

5815: WHEN OTHERS THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5818: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5819: FND_MSG_PUB.ADD;
5820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5821: END get_search_criteria;
5822:
5823:

Line 5884: FND_MSG_PUB.ADD;

5880: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5881: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5882: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5884: FND_MSG_PUB.ADD;
5885: RAISE FND_API.G_EXC_ERROR;
5886: END get_party_rec;
5887:
5888: /************************************************

Line 5940: FND_MSG_PUB.ADD;

5936: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5937: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5938: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_ERROR;
5942: END get_party_site_rec;
5943:
5944: /************************************************

Line 5998: FND_MSG_PUB.ADD;

5994: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5995: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5996: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5997: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5998: FND_MSG_PUB.ADD;
5999: RAISE FND_API.G_EXC_ERROR;
6000: END get_contact_rec;
6001:
6002: /************************************************

Line 6052: FND_MSG_PUB.ADD;

6048: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6049: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6050: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6052: FND_MSG_PUB.ADD;
6053: RAISE FND_API.G_EXC_ERROR;
6054: END get_contact_point_rec;
6055:
6056: /************************************************

Line 6193: FND_MSG_PUB.ADD;

6189: WHEN OTHERS THEN
6190: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6191: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6192: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6193: FND_MSG_PUB.ADD;
6194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6195: END;
6196:
6197:

Line 6311: FND_MSG_PUB.ADD;

6307: WHEN OTHERS THEN
6308: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6309: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6311: FND_MSG_PUB.ADD;
6312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6313: END;
6314:
6315:

Line 6391: FND_MSG_PUB.ADD;

6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6393: END;
6394:
6395:

Line 6483: FND_MSG_PUB.ADD;

6479: WHEN OTHERS THEN
6480: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6481: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6482: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6483: FND_MSG_PUB.ADD;
6484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6485: END;
6486:
6487:

Line 6507: FND_MSG_PUB.ADD;

6503: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6504: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6505: ) THEN
6506: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6507: FND_MSG_PUB.ADD;
6508: RAISE FND_API.G_EXC_ERROR;
6509: END IF;
6510: END LOOP;
6511:

Line 6549: FND_MSG_PUB.ADD;

6545: WHEN OTHERS THEN
6546: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6547: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6551: END check_prim_cond;
6552:
6553: /************************************************

Line 6603: FND_MSG_PUB.ADD;

6599: WHEN OTHERS THEN
6600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6601: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6603: FND_MSG_PUB.ADD;
6604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6605: END check_party_site_cond;
6606:
6607: /************************************************

Line 6657: FND_MSG_PUB.ADD;

6653: WHEN OTHERS THEN
6654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6655: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6657: FND_MSG_PUB.ADD;
6658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6659: END check_contact_cond;
6660:
6661: /************************************************

Line 6678: FND_MSG_PUB.ADD;

6674:
6675: FOR I IN 1..p_contact_point_list.COUNT LOOP
6676: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6677: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6678: FND_MSG_PUB.ADD;
6679: RAISE FND_API.G_EXC_ERROR;
6680: END IF;
6681: END LOOP;
6682:

Line 6702: FND_MSG_PUB.ADD;

6698: WHEN OTHERS THEN
6699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6700: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6701: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6702: FND_MSG_PUB.ADD;
6703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6704: END check_contact_point_cond;
6705:
6706: FUNCTION check_staged RETURN BOOLEAN IS