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_58 dependencies on FND_API

Line 102: RAISE FND_API.G_EXC_ERROR;

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;
106: RAISE FND_API.G_EXC_ERROR;

Line 106: RAISE FND_API.G_EXC_ERROR;

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;
110: END;

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
110: END;
111:
112:

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 828: RAISE FND_API.G_EXC_ERROR;

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

Line 1097: RAISE FND_API.G_EXC_ERROR;

1093: IF lengthb(l_party_contains_str) > 4000 THEN
1094: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1095: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1096: FND_MSG_PUB.ADD;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: IF (p_match_str = ' AND ' OR p_party_max_score 1100: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1101: hz_utility_v2pub.debug(p_message=>'party contains string returned by init_search is an AND between these strings ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1175: RAISE FND_API.G_EXC_ERROR;

1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: x_denorm_str := l_den_contains_str;
1178: RETURN l_contains_str;
1179: END;

Line 1256: RAISE FND_API.G_EXC_ERROR;

1252: IF lengthb(l_contains_str) > 4000 THEN
1253: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1254: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1255: FND_MSG_PUB.ADD;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258: x_denorm_str := l_den_contains_str;
1259: RETURN l_contains_str;
1260: END;

Line 1489: RAISE FND_API.G_EXC_ERROR;

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

Line 1493: RAISE FND_API.G_EXC_ERROR;

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

Line 1497: RAISE FND_API.G_EXC_ERROR;

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

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: else
1499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: end if;
1504: END;
1505:
1506: PROCEDURE open_party_site_cursor(

Line 1734: RAISE FND_API.G_EXC_ERROR;

1730: when others then
1731: if (instrb(SQLERRM,'DRG-51030')>0) then
1732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1733: FND_MSG_PUB.ADD;
1734: RAISE FND_API.G_EXC_ERROR;
1735: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1736: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1737: FND_MSG_PUB.ADD;
1738: RAISE FND_API.G_EXC_ERROR;

Line 1738: RAISE FND_API.G_EXC_ERROR;

1734: RAISE FND_API.G_EXC_ERROR;
1735: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1736: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1737: FND_MSG_PUB.ADD;
1738: RAISE FND_API.G_EXC_ERROR;
1739: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1740: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1741: FND_MSG_PUB.ADD;
1742: RAISE FND_API.G_EXC_ERROR;

Line 1742: RAISE FND_API.G_EXC_ERROR;

1738: RAISE FND_API.G_EXC_ERROR;
1739: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1740: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1741: FND_MSG_PUB.ADD;
1742: RAISE FND_API.G_EXC_ERROR;
1743: else
1744: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1745: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1746: FND_MSG_PUB.ADD;

Line 1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1743: else
1744: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1745: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1746: FND_MSG_PUB.ADD;
1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1748: end if;
1749: END;
1750:
1751: PROCEDURE open_contact_cursor(

Line 1881: RAISE FND_API.G_EXC_ERROR;

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

Line 1885: RAISE FND_API.G_EXC_ERROR;

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

Line 1889: RAISE FND_API.G_EXC_ERROR;

1885: RAISE FND_API.G_EXC_ERROR;
1886: elsif (instrb(SQLERRM,'ORA-20000')>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: else
1891: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1892: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1893: FND_MSG_PUB.ADD;

Line 1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1890: else
1891: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1892: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1893: FND_MSG_PUB.ADD;
1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895: end if;
1896: END;
1897:
1898: PROCEDURE open_contact_pt_cursor(

Line 2154: RAISE FND_API.G_EXC_ERROR;

2150: when others then
2151: if (instrb(SQLERRM,'DRG-51030')>0) then
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2153: FND_MSG_PUB.ADD;
2154: RAISE FND_API.G_EXC_ERROR;
2155: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2157: FND_MSG_PUB.ADD;
2158: RAISE FND_API.G_EXC_ERROR;

Line 2158: RAISE FND_API.G_EXC_ERROR;

2154: RAISE FND_API.G_EXC_ERROR;
2155: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2157: FND_MSG_PUB.ADD;
2158: RAISE FND_API.G_EXC_ERROR;
2159: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2160: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;

Line 2162: RAISE FND_API.G_EXC_ERROR;

2158: RAISE FND_API.G_EXC_ERROR;
2159: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2160: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: else
2164: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2166: FND_MSG_PUB.ADD;

Line 2167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2163: else
2164: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2166: FND_MSG_PUB.ADD;
2167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2168: end if;
2169: END;
2170:
2171:

Line 2419: RAISE FND_API.G_EXC_ERROR;

2415: 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);
2416: END IF;
2417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2418: FND_MSG_PUB.ADD;
2419: RAISE FND_API.G_EXC_ERROR;
2420: ELSE
2421: push_eval;
2422: RETURN;
2423: END IF;

Line 2467: RAISE FND_API.G_EXC_ERROR;

2463: 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);
2464: END IF;
2465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: ELSE
2469: push_eval;
2470: RETURN;
2471: END IF;

Line 2540: RAISE FND_API.G_EXC_ERROR;

2536: 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);
2537: END IF;
2538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2539: FND_MSG_PUB.ADD;
2540: RAISE FND_API.G_EXC_ERROR;
2541: ELSE
2542: push_eval;
2543: RETURN;
2544: END IF;

Line 2652: RAISE FND_API.G_EXC_ERROR;

2648: 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);
2649: END IF;
2650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2651: FND_MSG_PUB.ADD;
2652: RAISE FND_API.G_EXC_ERROR;
2653: ELSE
2654: push_eval;
2655: RETURN;
2656: END IF;

Line 2763: RAISE FND_API.G_EXC_ERROR;

2759: 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);
2760: END IF;
2761: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2762: FND_MSG_PUB.ADD;
2763: RAISE FND_API.G_EXC_ERROR;
2764: ELSE
2765: push_eval;
2766: RETURN;
2767: END IF;

Line 2988: RAISE FND_API.G_EXC_ERROR;

2984: 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);
2985: END IF;
2986: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;
2989: END IF;
2990: ELSE
2991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2992: 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);

Line 2996: RAISE FND_API.G_EXC_ERROR;

2992: 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);
2993: END IF;
2994: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2995: FND_MSG_PUB.ADD;
2996: RAISE FND_API.G_EXC_ERROR;
2997: END IF;
2998: END IF;
2999: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3000: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3195: WHEN FND_API.G_EXC_ERROR THEN

3191: END IF;
3192: EXCEPTION
3193: WHEN L_RETURN_IMM_EXC THEN
3194: RETURN;
3195: WHEN FND_API.G_EXC_ERROR THEN
3196: RAISE FND_API.G_EXC_ERROR;
3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3199: WHEN OTHERS THEN

Line 3196: RAISE FND_API.G_EXC_ERROR;

3192: EXCEPTION
3193: WHEN L_RETURN_IMM_EXC THEN
3194: RETURN;
3195: WHEN FND_API.G_EXC_ERROR THEN
3196: RAISE FND_API.G_EXC_ERROR;
3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3193: WHEN L_RETURN_IMM_EXC THEN
3194: RETURN;
3195: WHEN FND_API.G_EXC_ERROR THEN
3196: RAISE FND_API.G_EXC_ERROR;
3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');

Line 3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3194: RETURN;
3195: WHEN FND_API.G_EXC_ERROR THEN
3196: RAISE FND_API.G_EXC_ERROR;
3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END find_parties;
3206:
3207: PROCEDURE find_persons (
3208: p_rule_id IN NUMBER,

Line 3396: RAISE FND_API.G_EXC_ERROR;

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

Line 3444: RAISE FND_API.G_EXC_ERROR;

3440: 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);
3441: END IF;
3442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3443: FND_MSG_PUB.ADD;
3444: RAISE FND_API.G_EXC_ERROR;
3445: ELSE
3446: push_eval;
3447: RETURN;
3448: END IF;

Line 3480: RAISE FND_API.G_EXC_ERROR;

3476: when others then
3477: if (instrb(SQLERRM,'DRG-51030')>0) then
3478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3479: FND_MSG_PUB.ADD;
3480: RAISE FND_API.G_EXC_ERROR;
3481: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3483: FND_MSG_PUB.ADD;
3484: RAISE FND_API.G_EXC_ERROR;

Line 3484: RAISE FND_API.G_EXC_ERROR;

3480: RAISE FND_API.G_EXC_ERROR;
3481: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3483: FND_MSG_PUB.ADD;
3484: RAISE FND_API.G_EXC_ERROR;
3485: else
3486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3487: end if;
3488: END;

Line 3486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3483: FND_MSG_PUB.ADD;
3484: RAISE FND_API.G_EXC_ERROR;
3485: else
3486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3487: end if;
3488: END;
3489:
3490: /** Private procedure to acquire and score at party site level ***/

Line 3556: RAISE FND_API.G_EXC_ERROR;

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

Line 3815: RAISE FND_API.G_EXC_ERROR;

3811: 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);
3812: END IF;
3813: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3814: FND_MSG_PUB.ADD;
3815: RAISE FND_API.G_EXC_ERROR;
3816: ELSE
3817: push_eval;
3818: RETURN;
3819: END IF;

Line 3928: RAISE FND_API.G_EXC_ERROR;

3924: 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);
3925: END IF;
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_ERROR;
3929: END IF;
3930: ELSE
3931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3932: 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);

Line 3936: RAISE FND_API.G_EXC_ERROR;

3932: 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);
3933: END IF;
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;
3937: END IF;
3938: END IF;
3939: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3940: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4050: WHEN FND_API.G_EXC_ERROR THEN

4046: END IF;
4047: EXCEPTION
4048: WHEN L_RETURN_IMM_EXC THEN
4049: RETURN;
4050: WHEN FND_API.G_EXC_ERROR THEN
4051: RAISE FND_API.G_EXC_ERROR;
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN

Line 4051: RAISE FND_API.G_EXC_ERROR;

4047: EXCEPTION
4048: WHEN L_RETURN_IMM_EXC THEN
4049: RETURN;
4050: WHEN FND_API.G_EXC_ERROR THEN
4051: RAISE FND_API.G_EXC_ERROR;
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4048: WHEN L_RETURN_IMM_EXC THEN
4049: RETURN;
4050: WHEN FND_API.G_EXC_ERROR THEN
4051: RAISE FND_API.G_EXC_ERROR;
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4056: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');

Line 4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4049: RETURN;
4050: WHEN FND_API.G_EXC_ERROR THEN
4051: RAISE FND_API.G_EXC_ERROR;
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4056: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4056: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4058: FND_MSG_PUB.ADD;
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: END find_persons;
4061:
4062: PROCEDURE find_persons (
4063: p_rule_id IN NUMBER,

Line 4118: WHEN FND_API.G_EXC_ERROR THEN

4114: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4115: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4116: END IF;
4117: EXCEPTION
4118: WHEN FND_API.G_EXC_ERROR THEN
4119: RAISE FND_API.G_EXC_ERROR;
4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: WHEN OTHERS THEN

Line 4119: RAISE FND_API.G_EXC_ERROR;

4115: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4116: END IF;
4117: EXCEPTION
4118: WHEN FND_API.G_EXC_ERROR THEN
4119: RAISE FND_API.G_EXC_ERROR;
4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: WHEN OTHERS THEN
4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4116: END IF;
4117: EXCEPTION
4118: WHEN FND_API.G_EXC_ERROR THEN
4119: RAISE FND_API.G_EXC_ERROR;
4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: WHEN OTHERS THEN
4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4124: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');

Line 4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4117: EXCEPTION
4118: WHEN FND_API.G_EXC_ERROR THEN
4119: RAISE FND_API.G_EXC_ERROR;
4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: WHEN OTHERS THEN
4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4124: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4124: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4126: FND_MSG_PUB.ADD;
4127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4128: END find_party_details;
4129:
4130: PROCEDURE find_duplicate_parties (
4131: p_rule_id IN NUMBER,

Line 4235: WHEN FND_API.G_EXC_ERROR THEN

4231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4232: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4233: END IF;
4234: EXCEPTION
4235: WHEN FND_API.G_EXC_ERROR THEN
4236: RAISE FND_API.G_EXC_ERROR;
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: WHEN OTHERS THEN

Line 4236: RAISE FND_API.G_EXC_ERROR;

4232: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4233: END IF;
4234: EXCEPTION
4235: WHEN FND_API.G_EXC_ERROR THEN
4236: RAISE FND_API.G_EXC_ERROR;
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: WHEN OTHERS THEN
4240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4233: END IF;
4234: EXCEPTION
4235: WHEN FND_API.G_EXC_ERROR THEN
4236: RAISE FND_API.G_EXC_ERROR;
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: WHEN OTHERS THEN
4240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4241: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');

Line 4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4234: EXCEPTION
4235: WHEN FND_API.G_EXC_ERROR THEN
4236: RAISE FND_API.G_EXC_ERROR;
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: WHEN OTHERS THEN
4240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4241: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4241: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4243: FND_MSG_PUB.ADD;
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: END find_duplicate_parties;
4246:
4247: PROCEDURE find_duplicate_party_sites (
4248: p_rule_id IN NUMBER,

Line 4320: WHEN FND_API.G_EXC_ERROR THEN

4316: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4317: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4318: END IF;
4319: EXCEPTION
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: RAISE FND_API.G_EXC_ERROR;
4322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4324: WHEN OTHERS THEN

Line 4321: RAISE FND_API.G_EXC_ERROR;

4317: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4318: END IF;
4319: EXCEPTION
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: RAISE FND_API.G_EXC_ERROR;
4322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4324: WHEN OTHERS THEN
4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4318: END IF;
4319: EXCEPTION
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: RAISE FND_API.G_EXC_ERROR;
4322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4324: WHEN OTHERS THEN
4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4326: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');

Line 4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4319: EXCEPTION
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: RAISE FND_API.G_EXC_ERROR;
4322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4324: WHEN OTHERS THEN
4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4326: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4326: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4328: FND_MSG_PUB.ADD;
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: END find_duplicate_party_sites;
4331:
4332: PROCEDURE find_duplicate_contacts (
4333: p_rule_id IN NUMBER,

Line 4409: WHEN FND_API.G_EXC_ERROR THEN

4405: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4406: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4407: END IF;
4408: EXCEPTION
4409: WHEN FND_API.G_EXC_ERROR THEN
4410: RAISE FND_API.G_EXC_ERROR;
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: WHEN OTHERS THEN

Line 4410: RAISE FND_API.G_EXC_ERROR;

4406: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4407: END IF;
4408: EXCEPTION
4409: WHEN FND_API.G_EXC_ERROR THEN
4410: RAISE FND_API.G_EXC_ERROR;
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: WHEN OTHERS THEN
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4407: END IF;
4408: EXCEPTION
4409: WHEN FND_API.G_EXC_ERROR THEN
4410: RAISE FND_API.G_EXC_ERROR;
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: WHEN OTHERS THEN
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4415: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');

Line 4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4408: EXCEPTION
4409: WHEN FND_API.G_EXC_ERROR THEN
4410: RAISE FND_API.G_EXC_ERROR;
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: WHEN OTHERS THEN
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4415: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4415: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: END find_duplicate_contacts;
4420:
4421: PROCEDURE find_duplicate_contact_points (
4422: p_rule_id IN NUMBER,

Line 4482: WHEN FND_API.G_EXC_ERROR THEN

4478: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4479: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4480: END IF;
4481: EXCEPTION
4482: WHEN FND_API.G_EXC_ERROR THEN
4483: RAISE FND_API.G_EXC_ERROR;
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4486: WHEN OTHERS THEN

Line 4483: RAISE FND_API.G_EXC_ERROR;

4479: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4480: END IF;
4481: EXCEPTION
4482: WHEN FND_API.G_EXC_ERROR THEN
4483: RAISE FND_API.G_EXC_ERROR;
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4486: WHEN OTHERS THEN
4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4480: END IF;
4481: EXCEPTION
4482: WHEN FND_API.G_EXC_ERROR THEN
4483: RAISE FND_API.G_EXC_ERROR;
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4486: WHEN OTHERS THEN
4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4488: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');

Line 4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4481: EXCEPTION
4482: WHEN FND_API.G_EXC_ERROR THEN
4483: RAISE FND_API.G_EXC_ERROR;
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4486: WHEN OTHERS THEN
4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4488: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4488: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4492: END find_duplicate_contact_points;
4493:
4494: PROCEDURE find_parties_dynamic (
4495: p_rule_id IN NUMBER,

Line 4797: WHEN FND_API.G_EXC_ERROR THEN

4793: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4794: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4795: END IF;
4796: EXCEPTION
4797: WHEN FND_API.G_EXC_ERROR THEN
4798: RAISE FND_API.G_EXC_ERROR;
4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN

Line 4798: RAISE FND_API.G_EXC_ERROR;

4794: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4795: END IF;
4796: EXCEPTION
4797: WHEN FND_API.G_EXC_ERROR THEN
4798: RAISE FND_API.G_EXC_ERROR;
4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4795: END IF;
4796: EXCEPTION
4797: WHEN FND_API.G_EXC_ERROR THEN
4798: RAISE FND_API.G_EXC_ERROR;
4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');

Line 4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4796: EXCEPTION
4797: WHEN FND_API.G_EXC_ERROR THEN
4798: RAISE FND_API.G_EXC_ERROR;
4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END call_api_dynamic;
4808:
4809:
4810: PROCEDURE get_matching_party_sites (

Line 5032: WHEN FND_API.G_EXC_ERROR THEN

5028: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5029: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5030: END IF;
5031: EXCEPTION
5032: WHEN FND_API.G_EXC_ERROR THEN
5033: RAISE FND_API.G_EXC_ERROR;
5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036: WHEN OTHERS THEN

Line 5033: RAISE FND_API.G_EXC_ERROR;

5029: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5030: END IF;
5031: EXCEPTION
5032: WHEN FND_API.G_EXC_ERROR THEN
5033: RAISE FND_API.G_EXC_ERROR;
5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036: WHEN OTHERS THEN
5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5030: END IF;
5031: EXCEPTION
5032: WHEN FND_API.G_EXC_ERROR THEN
5033: RAISE FND_API.G_EXC_ERROR;
5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036: WHEN OTHERS THEN
5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');

Line 5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5031: EXCEPTION
5032: WHEN FND_API.G_EXC_ERROR THEN
5033: RAISE FND_API.G_EXC_ERROR;
5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036: WHEN OTHERS THEN
5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5040: FND_MSG_PUB.ADD;
5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5042: END get_matching_party_sites;
5043:
5044:
5045: PROCEDURE get_matching_contacts (

Line 5261: WHEN FND_API.G_EXC_ERROR THEN

5257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5258: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5259: END IF;
5260: EXCEPTION
5261: WHEN FND_API.G_EXC_ERROR THEN
5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN

Line 5262: RAISE FND_API.G_EXC_ERROR;

5258: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5259: END IF;
5260: EXCEPTION
5261: WHEN FND_API.G_EXC_ERROR THEN
5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5259: END IF;
5260: EXCEPTION
5261: WHEN FND_API.G_EXC_ERROR THEN
5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');

Line 5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5260: EXCEPTION
5261: WHEN FND_API.G_EXC_ERROR THEN
5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_contacts;
5272:
5273:
5274: PROCEDURE get_matching_contact_points (

Line 5403: WHEN FND_API.G_EXC_ERROR THEN

5399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5400: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5401: END IF;
5402: EXCEPTION
5403: WHEN FND_API.G_EXC_ERROR THEN
5404: RAISE FND_API.G_EXC_ERROR;
5405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: WHEN OTHERS THEN

Line 5404: RAISE FND_API.G_EXC_ERROR;

5400: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5401: END IF;
5402: EXCEPTION
5403: WHEN FND_API.G_EXC_ERROR THEN
5404: RAISE FND_API.G_EXC_ERROR;
5405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: WHEN OTHERS THEN
5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5401: END IF;
5402: EXCEPTION
5403: WHEN FND_API.G_EXC_ERROR THEN
5404: RAISE FND_API.G_EXC_ERROR;
5405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: WHEN OTHERS THEN
5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');

Line 5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5402: EXCEPTION
5403: WHEN FND_API.G_EXC_ERROR THEN
5404: RAISE FND_API.G_EXC_ERROR;
5405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: WHEN OTHERS THEN
5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5411: FND_MSG_PUB.ADD;
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5413: END get_matching_contact_points;
5414:
5415: /**********************************************************
5416: This procedure finds the score details for a specific party that

Line 5613: WHEN FND_API.G_EXC_ERROR THEN

5609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5610: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5611: END IF;
5612: EXCEPTION
5613: WHEN FND_API.G_EXC_ERROR THEN
5614: RAISE FND_API.G_EXC_ERROR;
5615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5617: WHEN OTHERS THEN

Line 5614: RAISE FND_API.G_EXC_ERROR;

5610: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5611: END IF;
5612: EXCEPTION
5613: WHEN FND_API.G_EXC_ERROR THEN
5614: RAISE FND_API.G_EXC_ERROR;
5615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5611: END IF;
5612: EXCEPTION
5613: WHEN FND_API.G_EXC_ERROR THEN
5614: RAISE FND_API.G_EXC_ERROR;
5615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');

Line 5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5612: EXCEPTION
5613: WHEN FND_API.G_EXC_ERROR THEN
5614: RAISE FND_API.G_EXC_ERROR;
5615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5621: FND_MSG_PUB.ADD;
5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5623: END get_score_details;
5624:
5625:
5626: /************************************************

Line 5701: WHEN FND_API.G_EXC_ERROR THEN

5697: END LOOP;
5698: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5699: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5700: EXCEPTION
5701: WHEN FND_API.G_EXC_ERROR THEN
5702: RAISE FND_API.G_EXC_ERROR;
5703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705: WHEN OTHERS THEN

Line 5702: RAISE FND_API.G_EXC_ERROR;

5698: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5699: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5700: EXCEPTION
5701: WHEN FND_API.G_EXC_ERROR THEN
5702: RAISE FND_API.G_EXC_ERROR;
5703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5699: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5700: EXCEPTION
5701: WHEN FND_API.G_EXC_ERROR THEN
5702: RAISE FND_API.G_EXC_ERROR;
5703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5700: EXCEPTION
5701: WHEN FND_API.G_EXC_ERROR THEN
5702: RAISE FND_API.G_EXC_ERROR;
5703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5709: FND_MSG_PUB.ADD;
5710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5711: END get_party_for_search;
5712:
5713: PROCEDURE get_search_criteria (
5714: p_party_id IN NUMBER,

Line 5747: WHEN FND_API.G_EXC_ERROR THEN

5743: END IF;
5744: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5745: END IF;
5746: EXCEPTION
5747: WHEN FND_API.G_EXC_ERROR THEN
5748: RAISE FND_API.G_EXC_ERROR;
5749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5751: WHEN OTHERS THEN

Line 5748: RAISE FND_API.G_EXC_ERROR;

5744: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5745: END IF;
5746: EXCEPTION
5747: WHEN FND_API.G_EXC_ERROR THEN
5748: RAISE FND_API.G_EXC_ERROR;
5749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5751: WHEN OTHERS THEN
5752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5745: END IF;
5746: EXCEPTION
5747: WHEN FND_API.G_EXC_ERROR THEN
5748: RAISE FND_API.G_EXC_ERROR;
5749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5751: WHEN OTHERS THEN
5752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5746: EXCEPTION
5747: WHEN FND_API.G_EXC_ERROR THEN
5748: RAISE FND_API.G_EXC_ERROR;
5749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5751: WHEN OTHERS THEN
5752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5755: FND_MSG_PUB.ADD;
5756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5757: END get_search_criteria;
5758:
5759:
5760: /************************************************

Line 5821: RAISE FND_API.G_EXC_ERROR;

5817: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5818: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5820: FND_MSG_PUB.ADD;
5821: RAISE FND_API.G_EXC_ERROR;
5822: END get_party_rec;
5823:
5824: /************************************************
5825: This procedure retrieves the match rule party site attributes into

Line 5873: RAISE FND_API.G_EXC_ERROR;

5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;
5874: END get_party_site_rec;
5875:
5876: /************************************************
5877: This procedure retrieves the match rule contact attributes into

Line 5931: RAISE FND_API.G_EXC_ERROR;

5927: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5928: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_ERROR;
5932: END get_contact_rec;
5933:
5934: /************************************************
5935: This procedure retrieves the match rule contact point attributes into

Line 5987: RAISE FND_API.G_EXC_ERROR;

5983: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5984: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_ERROR;
5988: END get_contact_point_rec;
5989:
5990: /************************************************
5991: This procedure maps a search record from the logical

Line 6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6157: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6158: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6160: FND_MSG_PUB.ADD;
6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6162: END;
6163:
6164:
6165: /************************************************

Line 6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6203: FND_MSG_PUB.ADD;
6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6205: END;
6206:
6207:
6208: /************************************************

Line 6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6257: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: END;
6263:
6264:
6265: /************************************************

Line 6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_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:
6396: /************************************************

Line 6417: RAISE FND_API.G_EXC_ERROR;

6413: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6414: ) THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6416: FND_MSG_PUB.ADD;
6417: RAISE FND_API.G_EXC_ERROR;
6418: END IF;
6419: END LOOP;
6420:
6421: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 6450: WHEN FND_API.G_EXC_ERROR THEN

6446: END IF;
6447: END LOOP;
6448: RETURN FALSE;
6449: EXCEPTION
6450: WHEN FND_API.G_EXC_ERROR THEN
6451: RAISE FND_API.G_EXC_ERROR;
6452: WHEN OTHERS THEN
6453: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6454: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6451: RAISE FND_API.G_EXC_ERROR;

6447: END LOOP;
6448: RETURN FALSE;
6449: EXCEPTION
6450: WHEN FND_API.G_EXC_ERROR THEN
6451: RAISE FND_API.G_EXC_ERROR;
6452: WHEN OTHERS THEN
6453: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6454: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6453: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6454: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6456: FND_MSG_PUB.ADD;
6457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6458: END check_prim_cond;
6459:
6460: /************************************************
6461: This procedure checks if the input search condition

Line 6503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6502: FND_MSG_PUB.ADD;
6503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6504: END check_party_site_cond;
6505:
6506: /************************************************
6507: This procedure checks if the input search condition

Line 6559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6558: FND_MSG_PUB.ADD;
6559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6560: END check_contact_cond;
6561:
6562: /************************************************
6563: This procedure checks if the input search condition

Line 6580: RAISE FND_API.G_EXC_ERROR;

6576: FOR I IN 1..p_contact_point_list.COUNT LOOP
6577: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6578: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_ERROR;
6581: END IF;
6582: END LOOP;
6583:
6584: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6603: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6605: FND_MSG_PUB.ADD;
6606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6607: END check_contact_point_cond;
6608:
6609: FUNCTION check_staged RETURN BOOLEAN IS
6610: