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.

[Home] [Help]

APPS.HZ_MATCH_RULE_3 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 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END;
499:
500:
501: /************************************************

Line 517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END;
519:
520:
521: /************************************************

Line 537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END;
539:
540:
541: /************************************************

Line 557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558: END;
559:
560: PROCEDURE init_score_context (
561: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 624: RAISE FND_API.G_EXC_ERROR;

620: p_contact_list,
621: p_contact_point_list) THEN
622: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
627: 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);
628: END IF;

Line 842: RAISE FND_API.G_EXC_ERROR;

838: IF lengthb(l_party_contains_str) > 4000 THEN
839: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
840: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: IF (p_match_str = ' AND ' OR p_party_max_score 845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
846: 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 941: RAISE FND_API.G_EXC_ERROR;

937: IF lengthb(l_contains_str) > 4000 THEN
938: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
939: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943: x_denorm_str := l_den_contains_str;
944: RETURN l_contains_str;
945: END;

Line 1162: RAISE FND_API.G_EXC_ERROR;

1158: when others then
1159: if (instrb(SQLERRM,'DRG-51030')>0) then
1160: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1161: FND_MSG_PUB.ADD;
1162: RAISE FND_API.G_EXC_ERROR;
1163: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1165: FND_MSG_PUB.ADD;
1166: RAISE FND_API.G_EXC_ERROR;

Line 1166: RAISE FND_API.G_EXC_ERROR;

1162: RAISE FND_API.G_EXC_ERROR;
1163: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1165: FND_MSG_PUB.ADD;
1166: RAISE FND_API.G_EXC_ERROR;
1167: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1169: FND_MSG_PUB.ADD;
1170: RAISE FND_API.G_EXC_ERROR;

Line 1170: RAISE FND_API.G_EXC_ERROR;

1166: RAISE FND_API.G_EXC_ERROR;
1167: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1169: FND_MSG_PUB.ADD;
1170: RAISE FND_API.G_EXC_ERROR;
1171: else
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1174: FND_MSG_PUB.ADD;

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1171: else
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: end if;
1177: END;
1178:
1179: PROCEDURE open_party_site_cursor(

Line 1407: RAISE FND_API.G_EXC_ERROR;

1403: when others then
1404: if (instrb(SQLERRM,'DRG-51030')>0) then
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1406: FND_MSG_PUB.ADD;
1407: RAISE FND_API.G_EXC_ERROR;
1408: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1410: FND_MSG_PUB.ADD;
1411: RAISE FND_API.G_EXC_ERROR;

Line 1411: RAISE FND_API.G_EXC_ERROR;

1407: RAISE FND_API.G_EXC_ERROR;
1408: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1410: FND_MSG_PUB.ADD;
1411: RAISE FND_API.G_EXC_ERROR;
1412: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1413: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1414: FND_MSG_PUB.ADD;
1415: RAISE FND_API.G_EXC_ERROR;

Line 1415: RAISE FND_API.G_EXC_ERROR;

1411: RAISE FND_API.G_EXC_ERROR;
1412: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1413: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1414: FND_MSG_PUB.ADD;
1415: RAISE FND_API.G_EXC_ERROR;
1416: else
1417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1419: FND_MSG_PUB.ADD;

Line 1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1416: else
1417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1419: FND_MSG_PUB.ADD;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: end if;
1422: END;
1423:
1424: PROCEDURE open_contact_cursor(

Line 1554: RAISE FND_API.G_EXC_ERROR;

1550: when others then
1551: if (instrb(SQLERRM,'DRG-51030')>0) then
1552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_ERROR;
1555: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1557: FND_MSG_PUB.ADD;
1558: RAISE FND_API.G_EXC_ERROR;

Line 1558: RAISE FND_API.G_EXC_ERROR;

1554: RAISE FND_API.G_EXC_ERROR;
1555: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1557: FND_MSG_PUB.ADD;
1558: RAISE FND_API.G_EXC_ERROR;
1559: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1561: FND_MSG_PUB.ADD;
1562: RAISE FND_API.G_EXC_ERROR;

Line 1562: RAISE FND_API.G_EXC_ERROR;

1558: RAISE FND_API.G_EXC_ERROR;
1559: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1561: FND_MSG_PUB.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: else
1564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1566: FND_MSG_PUB.ADD;

Line 1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1563: else
1564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1566: FND_MSG_PUB.ADD;
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: end if;
1569: END;
1570:
1571: PROCEDURE open_contact_pt_cursor(

Line 1827: RAISE FND_API.G_EXC_ERROR;

1823: when others then
1824: if (instrb(SQLERRM,'DRG-51030')>0) then
1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;
1828: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1830: FND_MSG_PUB.ADD;
1831: RAISE FND_API.G_EXC_ERROR;

Line 1831: RAISE FND_API.G_EXC_ERROR;

1827: RAISE FND_API.G_EXC_ERROR;
1828: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1830: FND_MSG_PUB.ADD;
1831: RAISE FND_API.G_EXC_ERROR;
1832: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1833: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1834: FND_MSG_PUB.ADD;
1835: RAISE FND_API.G_EXC_ERROR;

Line 1835: RAISE FND_API.G_EXC_ERROR;

1831: RAISE FND_API.G_EXC_ERROR;
1832: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1833: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1834: FND_MSG_PUB.ADD;
1835: RAISE FND_API.G_EXC_ERROR;
1836: else
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1839: FND_MSG_PUB.ADD;

Line 1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1836: else
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: end if;
1842: END;
1843:
1844:

Line 2088: RAISE FND_API.G_EXC_ERROR;

2084: 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);
2085: END IF;
2086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2087: FND_MSG_PUB.ADD;
2088: RAISE FND_API.G_EXC_ERROR;
2089: ELSE
2090: push_eval;
2091: RETURN;
2092: END IF;

Line 2136: RAISE FND_API.G_EXC_ERROR;

2132: 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);
2133: END IF;
2134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2135: FND_MSG_PUB.ADD;
2136: RAISE FND_API.G_EXC_ERROR;
2137: ELSE
2138: push_eval;
2139: RETURN;
2140: END IF;

Line 2209: RAISE FND_API.G_EXC_ERROR;

2205: 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);
2206: END IF;
2207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2208: FND_MSG_PUB.ADD;
2209: RAISE FND_API.G_EXC_ERROR;
2210: ELSE
2211: push_eval;
2212: RETURN;
2213: END IF;

Line 2321: RAISE FND_API.G_EXC_ERROR;

2317: 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);
2318: END IF;
2319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2320: FND_MSG_PUB.ADD;
2321: RAISE FND_API.G_EXC_ERROR;
2322: ELSE
2323: push_eval;
2324: RETURN;
2325: END IF;

Line 2432: RAISE FND_API.G_EXC_ERROR;

2428: 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);
2429: END IF;
2430: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2431: FND_MSG_PUB.ADD;
2432: RAISE FND_API.G_EXC_ERROR;
2433: ELSE
2434: push_eval;
2435: RETURN;
2436: END IF;

Line 2576: RAISE FND_API.G_EXC_ERROR;

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

2580: 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);
2581: END IF;
2582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;
2586: END IF;
2587: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2588: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2826: WHEN FND_API.G_EXC_ERROR THEN

2822: END IF;
2823: EXCEPTION
2824: WHEN L_RETURN_IMM_EXC THEN
2825: RETURN;
2826: WHEN FND_API.G_EXC_ERROR THEN
2827: RAISE FND_API.G_EXC_ERROR;
2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: WHEN OTHERS THEN

Line 2827: RAISE FND_API.G_EXC_ERROR;

2823: EXCEPTION
2824: WHEN L_RETURN_IMM_EXC THEN
2825: RETURN;
2826: WHEN FND_API.G_EXC_ERROR THEN
2827: RAISE FND_API.G_EXC_ERROR;
2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: WHEN OTHERS THEN
2831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2824: WHEN L_RETURN_IMM_EXC THEN
2825: RETURN;
2826: WHEN FND_API.G_EXC_ERROR THEN
2827: RAISE FND_API.G_EXC_ERROR;
2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: WHEN OTHERS THEN
2831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2832: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');

Line 2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2825: RETURN;
2826: WHEN FND_API.G_EXC_ERROR THEN
2827: RAISE FND_API.G_EXC_ERROR;
2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: WHEN OTHERS THEN
2831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2832: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2832: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2834: FND_MSG_PUB.ADD;
2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2836: END find_parties;
2837:
2838: PROCEDURE find_persons (
2839: p_rule_id IN NUMBER,

Line 3023: RAISE FND_API.G_EXC_ERROR;

3019: 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);
3020: END IF;
3021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3022: FND_MSG_PUB.ADD;
3023: RAISE FND_API.G_EXC_ERROR;
3024: ELSE
3025: push_eval;
3026: RETURN;
3027: END IF;

Line 3071: RAISE FND_API.G_EXC_ERROR;

3067: 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);
3068: END IF;
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3070: FND_MSG_PUB.ADD;
3071: RAISE FND_API.G_EXC_ERROR;
3072: ELSE
3073: push_eval;
3074: RETURN;
3075: END IF;

Line 3107: RAISE FND_API.G_EXC_ERROR;

3103: when others then
3104: if (instrb(SQLERRM,'DRG-51030')>0) then
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3106: FND_MSG_PUB.ADD;
3107: RAISE FND_API.G_EXC_ERROR;
3108: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3110: FND_MSG_PUB.ADD;
3111: RAISE FND_API.G_EXC_ERROR;

Line 3111: RAISE FND_API.G_EXC_ERROR;

3107: RAISE FND_API.G_EXC_ERROR;
3108: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3110: FND_MSG_PUB.ADD;
3111: RAISE FND_API.G_EXC_ERROR;
3112: else
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3114: end if;
3115: END;

Line 3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3110: FND_MSG_PUB.ADD;
3111: RAISE FND_API.G_EXC_ERROR;
3112: else
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3114: end if;
3115: END;
3116:
3117: /** Private procedure to acquire and score at party site level ***/

Line 3183: RAISE FND_API.G_EXC_ERROR;

3179: 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);
3180: END IF;
3181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3182: FND_MSG_PUB.ADD;
3183: RAISE FND_API.G_EXC_ERROR;
3184: ELSE
3185: push_eval;
3186: RETURN;
3187: END IF;

Line 3372: RAISE FND_API.G_EXC_ERROR;

3368: 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);
3369: END IF;
3370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3371: FND_MSG_PUB.ADD;
3372: RAISE FND_API.G_EXC_ERROR;
3373: ELSE
3374: push_eval;
3375: RETURN;
3376: END IF;

Line 3460: RAISE FND_API.G_EXC_ERROR;

3456: 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);
3457: END IF;
3458: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3459: FND_MSG_PUB.ADD;
3460: RAISE FND_API.G_EXC_ERROR;
3461: END IF;
3462: ELSE
3463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3464: 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 3468: RAISE FND_API.G_EXC_ERROR;

3464: 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);
3465: END IF;
3466: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3467: FND_MSG_PUB.ADD;
3468: RAISE FND_API.G_EXC_ERROR;
3469: END IF;
3470: END IF;
3471: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3472: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3608: WHEN FND_API.G_EXC_ERROR THEN

3604: END IF;
3605: EXCEPTION
3606: WHEN L_RETURN_IMM_EXC THEN
3607: RETURN;
3608: WHEN FND_API.G_EXC_ERROR THEN
3609: RAISE FND_API.G_EXC_ERROR;
3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: WHEN OTHERS THEN

Line 3609: RAISE FND_API.G_EXC_ERROR;

3605: EXCEPTION
3606: WHEN L_RETURN_IMM_EXC THEN
3607: RETURN;
3608: WHEN FND_API.G_EXC_ERROR THEN
3609: RAISE FND_API.G_EXC_ERROR;
3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: WHEN OTHERS THEN
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3606: WHEN L_RETURN_IMM_EXC THEN
3607: RETURN;
3608: WHEN FND_API.G_EXC_ERROR THEN
3609: RAISE FND_API.G_EXC_ERROR;
3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: WHEN OTHERS THEN
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3614: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');

Line 3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3607: RETURN;
3608: WHEN FND_API.G_EXC_ERROR THEN
3609: RAISE FND_API.G_EXC_ERROR;
3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: WHEN OTHERS THEN
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3614: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3614: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3616: FND_MSG_PUB.ADD;
3617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3618: END find_persons;
3619:
3620: PROCEDURE find_persons (
3621: p_rule_id IN NUMBER,

Line 3676: WHEN FND_API.G_EXC_ERROR THEN

3672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3673: 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);
3674: END IF;
3675: EXCEPTION
3676: WHEN FND_API.G_EXC_ERROR THEN
3677: RAISE FND_API.G_EXC_ERROR;
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: WHEN OTHERS THEN

Line 3677: RAISE FND_API.G_EXC_ERROR;

3673: 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);
3674: END IF;
3675: EXCEPTION
3676: WHEN FND_API.G_EXC_ERROR THEN
3677: RAISE FND_API.G_EXC_ERROR;
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: WHEN OTHERS THEN
3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3674: END IF;
3675: EXCEPTION
3676: WHEN FND_API.G_EXC_ERROR THEN
3677: RAISE FND_API.G_EXC_ERROR;
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: WHEN OTHERS THEN
3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');

Line 3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3675: EXCEPTION
3676: WHEN FND_API.G_EXC_ERROR THEN
3677: RAISE FND_API.G_EXC_ERROR;
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: WHEN OTHERS THEN
3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3684: FND_MSG_PUB.ADD;
3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3686: END find_party_details;
3687:
3688: PROCEDURE find_duplicate_parties (
3689: p_rule_id IN NUMBER,

Line 3793: WHEN FND_API.G_EXC_ERROR THEN

3789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3790: 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);
3791: END IF;
3792: EXCEPTION
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN

Line 3794: RAISE FND_API.G_EXC_ERROR;

3790: 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);
3791: END IF;
3792: EXCEPTION
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3791: END IF;
3792: EXCEPTION
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');

Line 3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3792: EXCEPTION
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3801: FND_MSG_PUB.ADD;
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3803: END find_duplicate_parties;
3804:
3805: PROCEDURE find_duplicate_party_sites (
3806: p_rule_id IN NUMBER,

Line 3878: WHEN FND_API.G_EXC_ERROR THEN

3874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3875: 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);
3876: END IF;
3877: EXCEPTION
3878: WHEN FND_API.G_EXC_ERROR THEN
3879: RAISE FND_API.G_EXC_ERROR;
3880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3882: WHEN OTHERS THEN

Line 3879: RAISE FND_API.G_EXC_ERROR;

3875: 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);
3876: END IF;
3877: EXCEPTION
3878: WHEN FND_API.G_EXC_ERROR THEN
3879: RAISE FND_API.G_EXC_ERROR;
3880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3882: WHEN OTHERS THEN
3883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3876: END IF;
3877: EXCEPTION
3878: WHEN FND_API.G_EXC_ERROR THEN
3879: RAISE FND_API.G_EXC_ERROR;
3880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3882: WHEN OTHERS THEN
3883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3884: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');

Line 3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3877: EXCEPTION
3878: WHEN FND_API.G_EXC_ERROR THEN
3879: RAISE FND_API.G_EXC_ERROR;
3880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3882: WHEN OTHERS THEN
3883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3884: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');
3885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3884: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');
3885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3886: FND_MSG_PUB.ADD;
3887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3888: END find_duplicate_party_sites;
3889:
3890: PROCEDURE find_duplicate_contacts (
3891: p_rule_id IN NUMBER,

Line 3967: WHEN FND_API.G_EXC_ERROR THEN

3963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3964: 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);
3965: END IF;
3966: EXCEPTION
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN

Line 3968: RAISE FND_API.G_EXC_ERROR;

3964: 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);
3965: END IF;
3966: EXCEPTION
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3965: END IF;
3966: EXCEPTION
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');

Line 3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3966: EXCEPTION
3967: WHEN FND_API.G_EXC_ERROR THEN
3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_duplicate_contacts;
3978:
3979: PROCEDURE find_duplicate_contact_points (
3980: p_rule_id IN NUMBER,

Line 4040: WHEN FND_API.G_EXC_ERROR THEN

4036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4037: 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);
4038: END IF;
4039: EXCEPTION
4040: WHEN FND_API.G_EXC_ERROR THEN
4041: RAISE FND_API.G_EXC_ERROR;
4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: WHEN OTHERS THEN

Line 4041: RAISE FND_API.G_EXC_ERROR;

4037: 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);
4038: END IF;
4039: EXCEPTION
4040: WHEN FND_API.G_EXC_ERROR THEN
4041: RAISE FND_API.G_EXC_ERROR;
4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: WHEN OTHERS THEN
4045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4038: END IF;
4039: EXCEPTION
4040: WHEN FND_API.G_EXC_ERROR THEN
4041: RAISE FND_API.G_EXC_ERROR;
4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: WHEN OTHERS THEN
4045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');

Line 4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4039: EXCEPTION
4040: WHEN FND_API.G_EXC_ERROR THEN
4041: RAISE FND_API.G_EXC_ERROR;
4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: WHEN OTHERS THEN
4045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4048: FND_MSG_PUB.ADD;
4049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4050: END find_duplicate_contact_points;
4051:
4052: PROCEDURE find_parties_dynamic (
4053: p_rule_id IN NUMBER,

Line 4334: WHEN FND_API.G_EXC_ERROR THEN

4330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4331: 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);
4332: END IF;
4333: EXCEPTION
4334: WHEN FND_API.G_EXC_ERROR THEN
4335: RAISE FND_API.G_EXC_ERROR;
4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: WHEN OTHERS THEN

Line 4335: RAISE FND_API.G_EXC_ERROR;

4331: 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);
4332: END IF;
4333: EXCEPTION
4334: WHEN FND_API.G_EXC_ERROR THEN
4335: RAISE FND_API.G_EXC_ERROR;
4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: WHEN OTHERS THEN
4339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4332: END IF;
4333: EXCEPTION
4334: WHEN FND_API.G_EXC_ERROR THEN
4335: RAISE FND_API.G_EXC_ERROR;
4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: WHEN OTHERS THEN
4339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4340: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');

Line 4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4333: EXCEPTION
4334: WHEN FND_API.G_EXC_ERROR THEN
4335: RAISE FND_API.G_EXC_ERROR;
4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: WHEN OTHERS THEN
4339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4340: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4341: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4340: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4341: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4342: FND_MSG_PUB.ADD;
4343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4344: END call_api_dynamic;
4345:
4346:
4347: PROCEDURE get_matching_party_sites (

Line 4569: WHEN FND_API.G_EXC_ERROR THEN

4565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4566: 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);
4567: END IF;
4568: EXCEPTION
4569: WHEN FND_API.G_EXC_ERROR THEN
4570: RAISE FND_API.G_EXC_ERROR;
4571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: WHEN OTHERS THEN

Line 4570: RAISE FND_API.G_EXC_ERROR;

4566: 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);
4567: END IF;
4568: EXCEPTION
4569: WHEN FND_API.G_EXC_ERROR THEN
4570: RAISE FND_API.G_EXC_ERROR;
4571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: WHEN OTHERS THEN
4574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4567: END IF;
4568: EXCEPTION
4569: WHEN FND_API.G_EXC_ERROR THEN
4570: RAISE FND_API.G_EXC_ERROR;
4571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: WHEN OTHERS THEN
4574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4575: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');

Line 4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4568: EXCEPTION
4569: WHEN FND_API.G_EXC_ERROR THEN
4570: RAISE FND_API.G_EXC_ERROR;
4571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: WHEN OTHERS THEN
4574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4575: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4576: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4575: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4576: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4577: FND_MSG_PUB.ADD;
4578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4579: END get_matching_party_sites;
4580:
4581:
4582: PROCEDURE get_matching_contacts (

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=>'get_matching_contacts(-) ',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=>'get_matching_contacts(-) ',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_3.get_matching_contacts');

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_3.get_matching_contacts');
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_3.get_matching_contacts');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END get_matching_contacts;
4808:
4809:
4810: PROCEDURE get_matching_contact_points (

Line 4939: WHEN FND_API.G_EXC_ERROR THEN

4935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4936: 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);
4937: END IF;
4938: EXCEPTION
4939: WHEN FND_API.G_EXC_ERROR THEN
4940: RAISE FND_API.G_EXC_ERROR;
4941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4943: WHEN OTHERS THEN

Line 4940: RAISE FND_API.G_EXC_ERROR;

4936: 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);
4937: END IF;
4938: EXCEPTION
4939: WHEN FND_API.G_EXC_ERROR THEN
4940: RAISE FND_API.G_EXC_ERROR;
4941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4943: WHEN OTHERS THEN
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4937: END IF;
4938: EXCEPTION
4939: WHEN FND_API.G_EXC_ERROR THEN
4940: RAISE FND_API.G_EXC_ERROR;
4941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4943: WHEN OTHERS THEN
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4945: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');

Line 4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4938: EXCEPTION
4939: WHEN FND_API.G_EXC_ERROR THEN
4940: RAISE FND_API.G_EXC_ERROR;
4941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4943: WHEN OTHERS THEN
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4945: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4945: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4947: FND_MSG_PUB.ADD;
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: END get_matching_contact_points;
4950:
4951: /**********************************************************
4952: This procedure finds the score details for a specific party that

Line 5139: WHEN FND_API.G_EXC_ERROR THEN

5135: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5136: 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);
5137: END IF;
5138: EXCEPTION
5139: WHEN FND_API.G_EXC_ERROR THEN
5140: RAISE FND_API.G_EXC_ERROR;
5141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: WHEN OTHERS THEN

Line 5140: RAISE FND_API.G_EXC_ERROR;

5136: 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);
5137: END IF;
5138: EXCEPTION
5139: WHEN FND_API.G_EXC_ERROR THEN
5140: RAISE FND_API.G_EXC_ERROR;
5141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: WHEN OTHERS THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5137: END IF;
5138: EXCEPTION
5139: WHEN FND_API.G_EXC_ERROR THEN
5140: RAISE FND_API.G_EXC_ERROR;
5141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: WHEN OTHERS THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5145: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');

Line 5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5138: EXCEPTION
5139: WHEN FND_API.G_EXC_ERROR THEN
5140: RAISE FND_API.G_EXC_ERROR;
5141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: WHEN OTHERS THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5145: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5146: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5145: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5146: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5147: FND_MSG_PUB.ADD;
5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5149: END get_score_details;
5150:
5151:
5152: /************************************************

Line 5214: WHEN FND_API.G_EXC_ERROR THEN

5210: END LOOP;
5211: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5212: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5213: EXCEPTION
5214: WHEN FND_API.G_EXC_ERROR THEN
5215: RAISE FND_API.G_EXC_ERROR;
5216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: WHEN OTHERS THEN

Line 5215: RAISE FND_API.G_EXC_ERROR;

5211: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5212: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5213: EXCEPTION
5214: WHEN FND_API.G_EXC_ERROR THEN
5215: RAISE FND_API.G_EXC_ERROR;
5216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: WHEN OTHERS THEN
5219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5212: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5213: EXCEPTION
5214: WHEN FND_API.G_EXC_ERROR THEN
5215: RAISE FND_API.G_EXC_ERROR;
5216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: WHEN OTHERS THEN
5219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5220: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5213: EXCEPTION
5214: WHEN FND_API.G_EXC_ERROR THEN
5215: RAISE FND_API.G_EXC_ERROR;
5216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: WHEN OTHERS THEN
5219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5220: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5221: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5220: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5221: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5222: FND_MSG_PUB.ADD;
5223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5224: END get_party_for_search;
5225:
5226: PROCEDURE get_search_criteria (
5227: p_party_id IN NUMBER,

Line 5254: WHEN FND_API.G_EXC_ERROR THEN

5250: END IF;
5251: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5252: END IF;
5253: EXCEPTION
5254: WHEN FND_API.G_EXC_ERROR THEN
5255: RAISE FND_API.G_EXC_ERROR;
5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: WHEN OTHERS THEN

Line 5255: RAISE FND_API.G_EXC_ERROR;

5251: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5252: END IF;
5253: EXCEPTION
5254: WHEN FND_API.G_EXC_ERROR THEN
5255: RAISE FND_API.G_EXC_ERROR;
5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: WHEN OTHERS THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5252: END IF;
5253: EXCEPTION
5254: WHEN FND_API.G_EXC_ERROR THEN
5255: RAISE FND_API.G_EXC_ERROR;
5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: WHEN OTHERS THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5260: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5253: EXCEPTION
5254: WHEN FND_API.G_EXC_ERROR THEN
5255: RAISE FND_API.G_EXC_ERROR;
5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: WHEN OTHERS THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5260: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5260: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5264: END get_search_criteria;
5265:
5266:
5267: /************************************************

Line 5324: RAISE FND_API.G_EXC_ERROR;

5320: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5321: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_ERROR;
5325: END get_party_rec;
5326:
5327: /************************************************
5328: This procedure retrieves the match rule party site attributes into

Line 5376: RAISE FND_API.G_EXC_ERROR;

5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;
5377: END get_party_site_rec;
5378:
5379: /************************************************
5380: This procedure retrieves the match rule contact attributes into

Line 5432: RAISE FND_API.G_EXC_ERROR;

5428: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5429: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5431: FND_MSG_PUB.ADD;
5432: RAISE FND_API.G_EXC_ERROR;
5433: END get_contact_rec;
5434:
5435: /************************************************
5436: This procedure retrieves the match rule contact point attributes into

Line 5488: RAISE FND_API.G_EXC_ERROR;

5484: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5485: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5486: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5487: FND_MSG_PUB.ADD;
5488: RAISE FND_API.G_EXC_ERROR;
5489: END get_contact_point_rec;
5490:
5491: /************************************************
5492: This procedure maps a search record from the logical

Line 5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5561: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5566: END;
5567:
5568:
5569: /************************************************

Line 5608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5604: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5607: FND_MSG_PUB.ADD;
5608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5609: END;
5610:
5611:
5612: /************************************************

Line 5650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5646: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5647: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5649: FND_MSG_PUB.ADD;
5650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5651: END;
5652:
5653:
5654: /************************************************

Line 5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5782: RAISE FND_API.G_EXC_ERROR;

5778: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
5779: ) THEN
5780: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5781: FND_MSG_PUB.ADD;
5782: RAISE FND_API.G_EXC_ERROR;
5783: END IF;
5784: END LOOP;
5785:
5786: IF p_party_search_rec.TAX_REFERENCE IS NOT NULL THEN

Line 5801: WHEN FND_API.G_EXC_ERROR THEN

5797: END IF;
5798: END LOOP;
5799: RETURN FALSE;
5800: EXCEPTION
5801: WHEN FND_API.G_EXC_ERROR THEN
5802: RAISE FND_API.G_EXC_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5802: RAISE FND_API.G_EXC_ERROR;

5798: END LOOP;
5799: RETURN FALSE;
5800: EXCEPTION
5801: WHEN FND_API.G_EXC_ERROR THEN
5802: RAISE FND_API.G_EXC_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5809: END check_prim_cond;
5810:
5811: /************************************************
5812: This procedure checks if the input search condition

Line 5854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5851: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5853: FND_MSG_PUB.ADD;
5854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5855: END check_party_site_cond;
5856:
5857: /************************************************
5858: This procedure checks if the input search condition

Line 5902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5898: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5899: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5901: FND_MSG_PUB.ADD;
5902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5903: END check_contact_cond;
5904:
5905: /************************************************
5906: This procedure checks if the input search condition

Line 5923: RAISE FND_API.G_EXC_ERROR;

5919: FOR I IN 1..p_contact_point_list.COUNT LOOP
5920: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5921: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5922: FND_MSG_PUB.ADD;
5923: RAISE FND_API.G_EXC_ERROR;
5924: END IF;
5925: END LOOP;
5926:
5927: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5946: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5950: END check_contact_point_cond;
5951:
5952: FUNCTION check_staged RETURN BOOLEAN IS
5953: