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

844: WHEN OTHERS THEN
845: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
846: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
848: FND_MSG_PUB.ADD;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END;
851:
852:

Line 873: FND_MSG_PUB.ADD;

869: WHEN OTHERS THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
871: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END;
876:
877:

Line 893: FND_MSG_PUB.ADD;

889: WHEN OTHERS THEN
890: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
891: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
892: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
893: FND_MSG_PUB.ADD;
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END;
896:
897:

Line 913: FND_MSG_PUB.ADD;

909: WHEN OTHERS THEN
910: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
911: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END;
916:
917: PROCEDURE init_score_context (

Line 980: FND_MSG_PUB.ADD;

976: p_party_site_list,
977: p_contact_list,
978: p_contact_point_list) THEN
979: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
984: 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 1215: FND_MSG_PUB.ADD;

1211: END IF;
1212: IF lengthb(l_party_contains_str) > 4000 THEN
1213: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1214: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1215: FND_MSG_PUB.ADD;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: IF (p_match_str = ' AND ' OR p_party_max_score 1219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1334: FND_MSG_PUB.ADD;

1330: -- Add the search criteria to query string
1331: IF lengthb(l_contains_str) > 4000 THEN
1332: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1333: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337: x_denorm_str := l_den_contains_str;
1338: RETURN l_contains_str;

Line 1639: FND_MSG_PUB.ADD;

1635: exception
1636: when others then
1637: if (instrb(SQLERRM,'DRG-51030')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;

Line 1643: FND_MSG_PUB.ADD;

1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1647: FND_MSG_PUB.ADD;

Line 1647: FND_MSG_PUB.ADD;

1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1652: FND_MSG_PUB.ADD;

1648: RAISE FND_API.G_EXC_ERROR;
1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: FND_MSG_PUB.ADD;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: end if;
1655: END;
1656:

Line 1884: FND_MSG_PUB.ADD;

1880: exception
1881: when others then
1882: if (instrb(SQLERRM,'DRG-51030')>0) then
1883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1884: FND_MSG_PUB.ADD;
1885: RAISE FND_API.G_EXC_ERROR;
1886: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1888: FND_MSG_PUB.ADD;

Line 1888: FND_MSG_PUB.ADD;

1884: FND_MSG_PUB.ADD;
1885: RAISE FND_API.G_EXC_ERROR;
1886: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1888: FND_MSG_PUB.ADD;
1889: RAISE FND_API.G_EXC_ERROR;
1890: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1892: FND_MSG_PUB.ADD;

Line 1892: FND_MSG_PUB.ADD;

1888: FND_MSG_PUB.ADD;
1889: RAISE FND_API.G_EXC_ERROR;
1890: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1892: FND_MSG_PUB.ADD;
1893: RAISE FND_API.G_EXC_ERROR;
1894: else
1895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1897: FND_MSG_PUB.ADD;

1893: RAISE FND_API.G_EXC_ERROR;
1894: else
1895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1899: end if;
1900: END;
1901:

Line 2031: FND_MSG_PUB.ADD;

2027: exception
2028: when others then
2029: if (instrb(SQLERRM,'DRG-51030')>0) then
2030: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2031: FND_MSG_PUB.ADD;
2032: RAISE FND_API.G_EXC_ERROR;
2033: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2034: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2035: FND_MSG_PUB.ADD;

Line 2035: FND_MSG_PUB.ADD;

2031: FND_MSG_PUB.ADD;
2032: RAISE FND_API.G_EXC_ERROR;
2033: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2034: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2035: FND_MSG_PUB.ADD;
2036: RAISE FND_API.G_EXC_ERROR;
2037: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2039: FND_MSG_PUB.ADD;

Line 2039: FND_MSG_PUB.ADD;

2035: FND_MSG_PUB.ADD;
2036: RAISE FND_API.G_EXC_ERROR;
2037: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2039: FND_MSG_PUB.ADD;
2040: RAISE FND_API.G_EXC_ERROR;
2041: else
2042: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2044: FND_MSG_PUB.ADD;

2040: RAISE FND_API.G_EXC_ERROR;
2041: else
2042: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2044: FND_MSG_PUB.ADD;
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: end if;
2047: END;
2048:

Line 2304: FND_MSG_PUB.ADD;

2300: exception
2301: when others then
2302: if (instrb(SQLERRM,'DRG-51030')>0) then
2303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2304: FND_MSG_PUB.ADD;
2305: RAISE FND_API.G_EXC_ERROR;
2306: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2308: FND_MSG_PUB.ADD;

Line 2308: FND_MSG_PUB.ADD;

2304: FND_MSG_PUB.ADD;
2305: RAISE FND_API.G_EXC_ERROR;
2306: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2308: FND_MSG_PUB.ADD;
2309: RAISE FND_API.G_EXC_ERROR;
2310: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2312: FND_MSG_PUB.ADD;

Line 2312: FND_MSG_PUB.ADD;

2308: FND_MSG_PUB.ADD;
2309: RAISE FND_API.G_EXC_ERROR;
2310: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.G_EXC_ERROR;
2314: else
2315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2316: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2317: FND_MSG_PUB.ADD;

2313: RAISE FND_API.G_EXC_ERROR;
2314: else
2315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2316: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2317: FND_MSG_PUB.ADD;
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: end if;
2320: END;
2321:

Line 2575: FND_MSG_PUB.ADD;

2571: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2572: 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);
2573: END IF;
2574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: ELSE
2578: push_eval;
2579: RETURN;

Line 2623: FND_MSG_PUB.ADD;

2619: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2620: 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);
2621: END IF;
2622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2623: FND_MSG_PUB.ADD;
2624: RAISE FND_API.G_EXC_ERROR;
2625: ELSE
2626: push_eval;
2627: RETURN;

Line 2696: FND_MSG_PUB.ADD;

2692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2693: 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);
2694: END IF;
2695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2696: FND_MSG_PUB.ADD;
2697: RAISE FND_API.G_EXC_ERROR;
2698: ELSE
2699: push_eval;
2700: RETURN;

Line 2808: FND_MSG_PUB.ADD;

2804: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2805: 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);
2806: END IF;
2807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2808: FND_MSG_PUB.ADD;
2809: RAISE FND_API.G_EXC_ERROR;
2810: ELSE
2811: push_eval;
2812: RETURN;

Line 2919: FND_MSG_PUB.ADD;

2915: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2916: 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);
2917: END IF;
2918: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2919: FND_MSG_PUB.ADD;
2920: RAISE FND_API.G_EXC_ERROR;
2921: ELSE
2922: push_eval;
2923: RETURN;

Line 3144: FND_MSG_PUB.ADD;

3140: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3141: 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);
3142: END IF;
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_ERROR;
3146: END IF;
3147: ELSE
3148: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3152: FND_MSG_PUB.ADD;

3148: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3149: 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);
3150: END IF;
3151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: END IF;
3155: END IF;
3156: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3360: FND_MSG_PUB.ADD;

3356: WHEN OTHERS THEN
3357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3358: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');
3359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3360: FND_MSG_PUB.ADD;
3361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3362: END find_parties;
3363:
3364: PROCEDURE find_persons (

Line 3558: FND_MSG_PUB.ADD;

3554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3555: 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);
3556: END IF;
3557: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3558: FND_MSG_PUB.ADD;
3559: RAISE FND_API.G_EXC_ERROR;
3560: ELSE
3561: push_eval;
3562: RETURN;

Line 3606: FND_MSG_PUB.ADD;

3602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3603: 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);
3604: END IF;
3605: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3606: FND_MSG_PUB.ADD;
3607: RAISE FND_API.G_EXC_ERROR;
3608: ELSE
3609: push_eval;
3610: RETURN;

Line 3642: FND_MSG_PUB.ADD;

3638: exception
3639: when others then
3640: if (instrb(SQLERRM,'DRG-51030')>0) then
3641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3642: FND_MSG_PUB.ADD;
3643: RAISE FND_API.G_EXC_ERROR;
3644: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3646: FND_MSG_PUB.ADD;

Line 3646: FND_MSG_PUB.ADD;

3642: FND_MSG_PUB.ADD;
3643: RAISE FND_API.G_EXC_ERROR;
3644: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: else
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650: end if;

Line 3718: FND_MSG_PUB.ADD;

3714: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3715: 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);
3716: END IF;
3717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3718: FND_MSG_PUB.ADD;
3719: RAISE FND_API.G_EXC_ERROR;
3720: ELSE
3721: push_eval;
3722: RETURN;

Line 3977: FND_MSG_PUB.ADD;

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

Line 4090: FND_MSG_PUB.ADD;

4086: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4087: 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);
4088: END IF;
4089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4090: FND_MSG_PUB.ADD;
4091: RAISE FND_API.G_EXC_ERROR;
4092: END IF;
4093: ELSE
4094: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4098: FND_MSG_PUB.ADD;

4094: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4095: 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);
4096: END IF;
4097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4098: FND_MSG_PUB.ADD;
4099: RAISE FND_API.G_EXC_ERROR;
4100: END IF;
4101: END IF;
4102: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4221: FND_MSG_PUB.ADD;

4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4221: FND_MSG_PUB.ADD;
4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4223: END find_persons;
4224:
4225: PROCEDURE find_persons (

Line 4289: FND_MSG_PUB.ADD;

4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END find_party_details;
4292:
4293: PROCEDURE find_duplicate_parties (

Line 4406: FND_MSG_PUB.ADD;

4402: WHEN OTHERS THEN
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4404: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');
4405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4406: FND_MSG_PUB.ADD;
4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4408: END find_duplicate_parties;
4409:
4410: PROCEDURE find_duplicate_party_sites (

Line 4491: FND_MSG_PUB.ADD;

4487: WHEN OTHERS THEN
4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');
4490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4491: FND_MSG_PUB.ADD;
4492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4493: END find_duplicate_party_sites;
4494:
4495: PROCEDURE find_duplicate_contacts (

Line 4580: FND_MSG_PUB.ADD;

4576: WHEN OTHERS THEN
4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4578: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4579: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4580: FND_MSG_PUB.ADD;
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: END find_duplicate_contacts;
4583:
4584: PROCEDURE find_duplicate_contact_points (

Line 4653: FND_MSG_PUB.ADD;

4649: WHEN OTHERS THEN
4650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4651: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4653: FND_MSG_PUB.ADD;
4654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4655: END find_duplicate_contact_points;
4656:
4657: PROCEDURE find_parties_dynamic (

Line 4955: FND_MSG_PUB.ADD;

4951: WHEN OTHERS THEN
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4953: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4955: FND_MSG_PUB.ADD;
4956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4957: END call_api_dynamic;
4958:
4959:

Line 5199: FND_MSG_PUB.ADD;

5195: WHEN OTHERS THEN
5196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5197: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5199: FND_MSG_PUB.ADD;
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: END get_matching_party_sites;
5202:
5203:

Line 5424: FND_MSG_PUB.ADD;

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

Line 5563: FND_MSG_PUB.ADD;

5559: WHEN OTHERS THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5561: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5565: END get_matching_contact_points;
5566:
5567: /**********************************************************

Line 5793: FND_MSG_PUB.ADD;

5789: WHEN OTHERS THEN
5790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5791: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5792: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5793: FND_MSG_PUB.ADD;
5794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5795: END get_score_details;
5796:
5797:

Line 5871: FND_MSG_PUB.ADD;

5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5871: FND_MSG_PUB.ADD;
5872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5873: END get_party_for_search;
5874:
5875: PROCEDURE get_search_criteria (

Line 5911: FND_MSG_PUB.ADD;

5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END get_search_criteria;
5914:
5915:

Line 5974: FND_MSG_PUB.ADD;

5970: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5971: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5972: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5973: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5974: FND_MSG_PUB.ADD;
5975: RAISE FND_API.G_EXC_ERROR;
5976: END get_party_rec;
5977:
5978: /************************************************

Line 6040: FND_MSG_PUB.ADD;

6036: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;
6041: RAISE FND_API.G_EXC_ERROR;
6042: END get_party_site_rec;
6043:
6044: /************************************************

Line 6096: FND_MSG_PUB.ADD;

6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;
6097: RAISE FND_API.G_EXC_ERROR;
6098: END get_contact_rec;
6099:
6100: /************************************************

Line 6148: FND_MSG_PUB.ADD;

6144: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6145: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6146: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6147: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END get_contact_point_rec;
6151:
6152: /************************************************

Line 6270: FND_MSG_PUB.ADD;

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

Line 6540: FND_MSG_PUB.ADD;

6536: WHEN OTHERS THEN
6537: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6538: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6540: FND_MSG_PUB.ADD;
6541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6542: END;
6543:
6544:

Line 6582: FND_MSG_PUB.ADD;

6578: WHEN OTHERS THEN
6579: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6581: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6582: FND_MSG_PUB.ADD;
6583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6584: END;
6585:
6586:

Line 6649: FND_MSG_PUB.ADD;

6645: WHEN OTHERS THEN
6646: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6647: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6649: FND_MSG_PUB.ADD;
6650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6651: END;
6652:
6653:

Line 6717: FND_MSG_PUB.ADD;

6713: WHEN OTHERS THEN
6714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6715: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;
6718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6719: END check_prim_cond;
6720:
6721: /************************************************

Line 6773: FND_MSG_PUB.ADD;

6769: WHEN OTHERS THEN
6770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6771: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6773: FND_MSG_PUB.ADD;
6774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6775: END check_party_site_cond;
6776:
6777: /************************************************

Line 6811: FND_MSG_PUB.ADD;

6807: WHEN OTHERS THEN
6808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6809: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6811: FND_MSG_PUB.ADD;
6812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6813: END check_contact_cond;
6814:
6815: /************************************************

Line 6832: FND_MSG_PUB.ADD;

6828:
6829: FOR I IN 1..p_contact_point_list.COUNT LOOP
6830: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6831: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6832: FND_MSG_PUB.ADD;
6833: RAISE FND_API.G_EXC_ERROR;
6834: END IF;
6835: END LOOP;
6836:

Line 6848: FND_MSG_PUB.ADD;

6844: WHEN OTHERS THEN
6845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6846: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6848: FND_MSG_PUB.ADD;
6849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6850: END check_contact_point_cond;
6851:
6852: FUNCTION check_staged RETURN BOOLEAN IS