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_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 702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
706: /************************************************

Line 722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
726: /************************************************

Line 742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
746: /************************************************

Line 762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
766: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 829: RAISE FND_API.G_EXC_ERROR;

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);
833: END IF;

Line 1087: RAISE FND_API.G_EXC_ERROR;

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

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

Line 1200: RAISE FND_API.G_EXC_ERROR;

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

Line 1274: RAISE FND_API.G_EXC_ERROR;

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

Line 1513: RAISE FND_API.G_EXC_ERROR;

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

Line 1517: RAISE FND_API.G_EXC_ERROR;

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

Line 1521: RAISE FND_API.G_EXC_ERROR;

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

Line 1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1758: RAISE FND_API.G_EXC_ERROR;

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

Line 1762: RAISE FND_API.G_EXC_ERROR;

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

Line 1766: RAISE FND_API.G_EXC_ERROR;

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

Line 1771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1905: RAISE FND_API.G_EXC_ERROR;

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

Line 1909: RAISE FND_API.G_EXC_ERROR;

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

Line 1913: RAISE FND_API.G_EXC_ERROR;

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

Line 1918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2178: RAISE FND_API.G_EXC_ERROR;

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

Line 2182: RAISE FND_API.G_EXC_ERROR;

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

Line 2186: RAISE FND_API.G_EXC_ERROR;

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

Line 2191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2444: RAISE FND_API.G_EXC_ERROR;

2440: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2441: END IF;
2442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2443: FND_MSG_PUB.ADD;
2444: RAISE FND_API.G_EXC_ERROR;
2445: ELSE
2446: push_eval;
2447: RETURN;
2448: END IF;

Line 2492: RAISE FND_API.G_EXC_ERROR;

2488: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2489: END IF;
2490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2491: FND_MSG_PUB.ADD;
2492: RAISE FND_API.G_EXC_ERROR;
2493: ELSE
2494: push_eval;
2495: RETURN;
2496: END IF;

Line 2565: RAISE FND_API.G_EXC_ERROR;

2561: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2562: END IF;
2563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2564: FND_MSG_PUB.ADD;
2565: RAISE FND_API.G_EXC_ERROR;
2566: ELSE
2567: push_eval;
2568: RETURN;
2569: END IF;

Line 2677: RAISE FND_API.G_EXC_ERROR;

2673: hz_utility_v2pub.debug(p_message=>'In eval contact level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2674: END IF;
2675: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2676: FND_MSG_PUB.ADD;
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSE
2679: push_eval;
2680: RETURN;
2681: END IF;

Line 2788: RAISE FND_API.G_EXC_ERROR;

2784: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2785: END IF;
2786: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2787: FND_MSG_PUB.ADD;
2788: RAISE FND_API.G_EXC_ERROR;
2789: ELSE
2790: push_eval;
2791: RETURN;
2792: END IF;

Line 3013: RAISE FND_API.G_EXC_ERROR;

3009: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3010: END IF;
3011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3012: FND_MSG_PUB.ADD;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END IF;
3015: ELSE
3016: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3017: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 3021: RAISE FND_API.G_EXC_ERROR;

3017: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3018: END IF;
3019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_ERROR;
3022: END IF;
3023: END IF;
3024: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3025: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3220: WHEN FND_API.G_EXC_ERROR THEN

3216: END IF;
3217: EXCEPTION
3218: WHEN L_RETURN_IMM_EXC THEN
3219: RETURN;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: WHEN OTHERS THEN

Line 3221: RAISE FND_API.G_EXC_ERROR;

3217: EXCEPTION
3218: WHEN L_RETURN_IMM_EXC THEN
3219: RETURN;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: WHEN OTHERS THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3218: WHEN L_RETURN_IMM_EXC THEN
3219: RETURN;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: WHEN OTHERS THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3226: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_parties');

Line 3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3219: RETURN;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: WHEN OTHERS THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3226: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_parties');
3227: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3422: RAISE FND_API.G_EXC_ERROR;

3418: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3419: END IF;
3420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3421: FND_MSG_PUB.ADD;
3422: RAISE FND_API.G_EXC_ERROR;
3423: ELSE
3424: push_eval;
3425: RETURN;
3426: END IF;

Line 3470: RAISE FND_API.G_EXC_ERROR;

3466: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3467: END IF;
3468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3469: FND_MSG_PUB.ADD;
3470: RAISE FND_API.G_EXC_ERROR;
3471: ELSE
3472: push_eval;
3473: RETURN;
3474: END IF;

Line 3506: RAISE FND_API.G_EXC_ERROR;

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

Line 3510: RAISE FND_API.G_EXC_ERROR;

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

Line 3512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3508: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3509: FND_MSG_PUB.ADD;
3510: RAISE FND_API.G_EXC_ERROR;
3511: else
3512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3513: end if;
3514: END;
3515:
3516: /** Private procedure to acquire and score at party site level ***/

Line 3582: RAISE FND_API.G_EXC_ERROR;

3578: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3579: END IF;
3580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3581: FND_MSG_PUB.ADD;
3582: RAISE FND_API.G_EXC_ERROR;
3583: ELSE
3584: push_eval;
3585: RETURN;
3586: END IF;

Line 3841: RAISE FND_API.G_EXC_ERROR;

3837: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3838: END IF;
3839: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3840: FND_MSG_PUB.ADD;
3841: RAISE FND_API.G_EXC_ERROR;
3842: ELSE
3843: push_eval;
3844: RETURN;
3845: END IF;

Line 3954: RAISE FND_API.G_EXC_ERROR;

3950: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3951: END IF;
3952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3953: FND_MSG_PUB.ADD;
3954: RAISE FND_API.G_EXC_ERROR;
3955: END IF;
3956: ELSE
3957: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3958: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 3962: RAISE FND_API.G_EXC_ERROR;

3958: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3959: END IF;
3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3961: FND_MSG_PUB.ADD;
3962: RAISE FND_API.G_EXC_ERROR;
3963: END IF;
3964: END IF;
3965: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3966: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4076: WHEN FND_API.G_EXC_ERROR THEN

4072: END IF;
4073: EXCEPTION
4074: WHEN L_RETURN_IMM_EXC THEN
4075: RETURN;
4076: WHEN FND_API.G_EXC_ERROR THEN
4077: RAISE FND_API.G_EXC_ERROR;
4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080: WHEN OTHERS THEN

Line 4077: RAISE FND_API.G_EXC_ERROR;

4073: EXCEPTION
4074: WHEN L_RETURN_IMM_EXC THEN
4075: RETURN;
4076: WHEN FND_API.G_EXC_ERROR THEN
4077: RAISE FND_API.G_EXC_ERROR;
4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080: WHEN OTHERS THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4074: WHEN L_RETURN_IMM_EXC THEN
4075: RETURN;
4076: WHEN FND_API.G_EXC_ERROR THEN
4077: RAISE FND_API.G_EXC_ERROR;
4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080: WHEN OTHERS THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4082: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_persons');

Line 4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4075: RETURN;
4076: WHEN FND_API.G_EXC_ERROR THEN
4077: RAISE FND_API.G_EXC_ERROR;
4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080: WHEN OTHERS THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4082: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_persons');
4083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4144: WHEN FND_API.G_EXC_ERROR THEN

4140: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4141: 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);
4142: END IF;
4143: EXCEPTION
4144: WHEN FND_API.G_EXC_ERROR THEN
4145: RAISE FND_API.G_EXC_ERROR;
4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4148: WHEN OTHERS THEN

Line 4145: RAISE FND_API.G_EXC_ERROR;

4141: 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);
4142: END IF;
4143: EXCEPTION
4144: WHEN FND_API.G_EXC_ERROR THEN
4145: RAISE FND_API.G_EXC_ERROR;
4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4148: WHEN OTHERS THEN
4149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4142: END IF;
4143: EXCEPTION
4144: WHEN FND_API.G_EXC_ERROR THEN
4145: RAISE FND_API.G_EXC_ERROR;
4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4148: WHEN OTHERS THEN
4149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4150: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_party_details');

Line 4147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4143: EXCEPTION
4144: WHEN FND_API.G_EXC_ERROR THEN
4145: RAISE FND_API.G_EXC_ERROR;
4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4148: WHEN OTHERS THEN
4149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4150: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_party_details');
4151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4261: WHEN FND_API.G_EXC_ERROR THEN

4257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4258: 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);
4259: END IF;
4260: EXCEPTION
4261: WHEN FND_API.G_EXC_ERROR THEN
4262: RAISE FND_API.G_EXC_ERROR;
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4265: WHEN OTHERS THEN

Line 4262: RAISE FND_API.G_EXC_ERROR;

4258: 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);
4259: END IF;
4260: EXCEPTION
4261: WHEN FND_API.G_EXC_ERROR THEN
4262: RAISE FND_API.G_EXC_ERROR;
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4265: WHEN OTHERS THEN
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4259: END IF;
4260: EXCEPTION
4261: WHEN FND_API.G_EXC_ERROR THEN
4262: RAISE FND_API.G_EXC_ERROR;
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4265: WHEN OTHERS THEN
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_parties');

Line 4264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4260: EXCEPTION
4261: WHEN FND_API.G_EXC_ERROR THEN
4262: RAISE FND_API.G_EXC_ERROR;
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4265: WHEN OTHERS THEN
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_parties');
4268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4346: WHEN FND_API.G_EXC_ERROR THEN

4342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4343: 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);
4344: END IF;
4345: EXCEPTION
4346: WHEN FND_API.G_EXC_ERROR THEN
4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN

Line 4347: RAISE FND_API.G_EXC_ERROR;

4343: 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);
4344: END IF;
4345: EXCEPTION
4346: WHEN FND_API.G_EXC_ERROR THEN
4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4344: END IF;
4345: EXCEPTION
4346: WHEN FND_API.G_EXC_ERROR THEN
4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_party_sites');

Line 4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4345: EXCEPTION
4346: WHEN FND_API.G_EXC_ERROR THEN
4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_party_sites');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4435: WHEN FND_API.G_EXC_ERROR THEN

4431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4432: 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);
4433: END IF;
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_ERROR THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN

Line 4436: RAISE FND_API.G_EXC_ERROR;

4432: 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);
4433: END IF;
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_ERROR THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4433: END IF;
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_ERROR THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contacts');

Line 4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4434: EXCEPTION
4435: WHEN FND_API.G_EXC_ERROR THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contacts');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4508: WHEN FND_API.G_EXC_ERROR THEN

4504: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4505: 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);
4506: END IF;
4507: EXCEPTION
4508: WHEN FND_API.G_EXC_ERROR THEN
4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN

Line 4509: RAISE FND_API.G_EXC_ERROR;

4505: 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);
4506: END IF;
4507: EXCEPTION
4508: WHEN FND_API.G_EXC_ERROR THEN
4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4506: END IF;
4507: EXCEPTION
4508: WHEN FND_API.G_EXC_ERROR THEN
4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contact_points');

Line 4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4507: EXCEPTION
4508: WHEN FND_API.G_EXC_ERROR THEN
4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contact_points');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4813: WHEN FND_API.G_EXC_ERROR THEN

4809: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4810: 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);
4811: END IF;
4812: EXCEPTION
4813: WHEN FND_API.G_EXC_ERROR THEN
4814: RAISE FND_API.G_EXC_ERROR;
4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4817: WHEN OTHERS THEN

Line 4814: RAISE FND_API.G_EXC_ERROR;

4810: 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);
4811: END IF;
4812: EXCEPTION
4813: WHEN FND_API.G_EXC_ERROR THEN
4814: RAISE FND_API.G_EXC_ERROR;
4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4817: WHEN OTHERS THEN
4818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4811: END IF;
4812: EXCEPTION
4813: WHEN FND_API.G_EXC_ERROR THEN
4814: RAISE FND_API.G_EXC_ERROR;
4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4817: WHEN OTHERS THEN
4818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4819: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');

Line 4816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4812: EXCEPTION
4813: WHEN FND_API.G_EXC_ERROR THEN
4814: RAISE FND_API.G_EXC_ERROR;
4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4817: WHEN OTHERS THEN
4818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4819: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');
4820: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5049: WHEN FND_API.G_EXC_ERROR THEN

5045: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5046: 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);
5047: END IF;
5048: EXCEPTION
5049: WHEN FND_API.G_EXC_ERROR THEN
5050: RAISE FND_API.G_EXC_ERROR;
5051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5053: WHEN OTHERS THEN

Line 5050: RAISE FND_API.G_EXC_ERROR;

5046: 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);
5047: END IF;
5048: EXCEPTION
5049: WHEN FND_API.G_EXC_ERROR THEN
5050: RAISE FND_API.G_EXC_ERROR;
5051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5053: WHEN OTHERS THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5047: END IF;
5048: EXCEPTION
5049: WHEN FND_API.G_EXC_ERROR THEN
5050: RAISE FND_API.G_EXC_ERROR;
5051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5053: WHEN OTHERS THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');

Line 5052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5048: EXCEPTION
5049: WHEN FND_API.G_EXC_ERROR THEN
5050: RAISE FND_API.G_EXC_ERROR;
5051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5053: WHEN OTHERS THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');
5056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5277: WHEN FND_API.G_EXC_ERROR THEN

5273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5274: 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);
5275: END IF;
5276: EXCEPTION
5277: WHEN FND_API.G_EXC_ERROR THEN
5278: RAISE FND_API.G_EXC_ERROR;
5279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5281: WHEN OTHERS THEN

Line 5278: RAISE FND_API.G_EXC_ERROR;

5274: 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);
5275: END IF;
5276: EXCEPTION
5277: WHEN FND_API.G_EXC_ERROR THEN
5278: RAISE FND_API.G_EXC_ERROR;
5279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5281: WHEN OTHERS THEN
5282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5275: END IF;
5276: EXCEPTION
5277: WHEN FND_API.G_EXC_ERROR THEN
5278: RAISE FND_API.G_EXC_ERROR;
5279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5281: WHEN OTHERS THEN
5282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5283: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contacts');

Line 5280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5276: EXCEPTION
5277: WHEN FND_API.G_EXC_ERROR THEN
5278: RAISE FND_API.G_EXC_ERROR;
5279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5281: WHEN OTHERS THEN
5282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5283: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contacts');
5284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5417: WHEN FND_API.G_EXC_ERROR THEN

5413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5414: 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);
5415: END IF;
5416: EXCEPTION
5417: WHEN FND_API.G_EXC_ERROR THEN
5418: RAISE FND_API.G_EXC_ERROR;
5419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: WHEN OTHERS THEN

Line 5418: RAISE FND_API.G_EXC_ERROR;

5414: 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);
5415: END IF;
5416: EXCEPTION
5417: WHEN FND_API.G_EXC_ERROR THEN
5418: RAISE FND_API.G_EXC_ERROR;
5419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5415: END IF;
5416: EXCEPTION
5417: WHEN FND_API.G_EXC_ERROR THEN
5418: RAISE FND_API.G_EXC_ERROR;
5419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');

Line 5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5416: EXCEPTION
5417: WHEN FND_API.G_EXC_ERROR THEN
5418: RAISE FND_API.G_EXC_ERROR;
5419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');
5424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');
5424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5425: FND_MSG_PUB.ADD;
5426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5427: END get_matching_contact_points;
5428:
5429: /**********************************************************
5430: This procedure finds the score details for a specific party that

Line 5631: WHEN FND_API.G_EXC_ERROR THEN

5627: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5628: 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);
5629: END IF;
5630: EXCEPTION
5631: WHEN FND_API.G_EXC_ERROR THEN
5632: RAISE FND_API.G_EXC_ERROR;
5633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: WHEN OTHERS THEN

Line 5632: RAISE FND_API.G_EXC_ERROR;

5628: 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);
5629: END IF;
5630: EXCEPTION
5631: WHEN FND_API.G_EXC_ERROR THEN
5632: RAISE FND_API.G_EXC_ERROR;
5633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: WHEN OTHERS THEN
5636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5629: END IF;
5630: EXCEPTION
5631: WHEN FND_API.G_EXC_ERROR THEN
5632: RAISE FND_API.G_EXC_ERROR;
5633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: WHEN OTHERS THEN
5636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5637: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');

Line 5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5630: EXCEPTION
5631: WHEN FND_API.G_EXC_ERROR THEN
5632: RAISE FND_API.G_EXC_ERROR;
5633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: WHEN OTHERS THEN
5636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5637: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5754: WHEN FND_API.G_EXC_ERROR THEN

5750: END LOOP;
5751: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5752: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5753: EXCEPTION
5754: WHEN FND_API.G_EXC_ERROR THEN
5755: RAISE FND_API.G_EXC_ERROR;
5756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5758: WHEN OTHERS THEN

Line 5755: RAISE FND_API.G_EXC_ERROR;

5751: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5752: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5753: EXCEPTION
5754: WHEN FND_API.G_EXC_ERROR THEN
5755: RAISE FND_API.G_EXC_ERROR;
5756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5758: WHEN OTHERS THEN
5759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5752: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5753: EXCEPTION
5754: WHEN FND_API.G_EXC_ERROR THEN
5755: RAISE FND_API.G_EXC_ERROR;
5756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5758: WHEN OTHERS THEN
5759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5760: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5753: EXCEPTION
5754: WHEN FND_API.G_EXC_ERROR THEN
5755: RAISE FND_API.G_EXC_ERROR;
5756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5758: WHEN OTHERS THEN
5759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5760: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5806: WHEN FND_API.G_EXC_ERROR THEN

5802: END IF;
5803: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5804: END IF;
5805: EXCEPTION
5806: WHEN FND_API.G_EXC_ERROR THEN
5807: RAISE FND_API.G_EXC_ERROR;
5808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5810: WHEN OTHERS THEN

Line 5807: RAISE FND_API.G_EXC_ERROR;

5803: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5804: END IF;
5805: EXCEPTION
5806: WHEN FND_API.G_EXC_ERROR THEN
5807: RAISE FND_API.G_EXC_ERROR;
5808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5810: WHEN OTHERS THEN
5811: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5804: END IF;
5805: EXCEPTION
5806: WHEN FND_API.G_EXC_ERROR THEN
5807: RAISE FND_API.G_EXC_ERROR;
5808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5810: WHEN OTHERS THEN
5811: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5812: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5805: EXCEPTION
5806: WHEN FND_API.G_EXC_ERROR THEN
5807: RAISE FND_API.G_EXC_ERROR;
5808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5810: WHEN OTHERS THEN
5811: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5812: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5813: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5880: RAISE FND_API.G_EXC_ERROR;

5876: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5877: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5878: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5879: FND_MSG_PUB.ADD;
5880: RAISE FND_API.G_EXC_ERROR;
5881: END get_party_rec;
5882:
5883: /************************************************
5884: This procedure retrieves the match rule party site attributes into

Line 5936: RAISE FND_API.G_EXC_ERROR;

5932: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5933: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5935: FND_MSG_PUB.ADD;
5936: RAISE FND_API.G_EXC_ERROR;
5937: END get_party_site_rec;
5938:
5939: /************************************************
5940: This procedure retrieves the match rule contact attributes into

Line 5994: RAISE FND_API.G_EXC_ERROR;

5990: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5991: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;
5995: END get_contact_rec;
5996:
5997: /************************************************
5998: This procedure retrieves the match rule contact point attributes into

Line 6048: RAISE FND_API.G_EXC_ERROR;

6044: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6045: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6047: FND_MSG_PUB.ADD;
6048: RAISE FND_API.G_EXC_ERROR;
6049: END get_contact_point_rec;
6050:
6051: /************************************************
6052: This procedure maps a search record from the logical

Line 6189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6503: RAISE FND_API.G_EXC_ERROR;

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

Line 6538: WHEN FND_API.G_EXC_ERROR THEN

6534: END IF;
6535: END LOOP;
6536: RETURN FALSE;
6537: EXCEPTION
6538: WHEN FND_API.G_EXC_ERROR THEN
6539: RAISE FND_API.G_EXC_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6539: RAISE FND_API.G_EXC_ERROR;

6535: END LOOP;
6536: RETURN FALSE;
6537: EXCEPTION
6538: WHEN FND_API.G_EXC_ERROR THEN
6539: RAISE FND_API.G_EXC_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END check_prim_cond;
6547:
6548: /************************************************
6549: This procedure checks if the input search condition

Line 6599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6596: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6598: FND_MSG_PUB.ADD;
6599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6600: END check_party_site_cond;
6601:
6602: /************************************************
6603: This procedure checks if the input search condition

Line 6653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6650: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6652: FND_MSG_PUB.ADD;
6653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6654: END check_contact_cond;
6655:
6656: /************************************************
6657: This procedure checks if the input search condition

Line 6674: RAISE FND_API.G_EXC_ERROR;

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

Line 6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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