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_2 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 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

529: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
530: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END;
535:
536:
537: /************************************************

Line 553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

549: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
550: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END;
555:
556:
557: /************************************************

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
570: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END;
575:
576:
577: /************************************************

Line 593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END;
595:
596: PROCEDURE init_score_context (
597: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 660: RAISE FND_API.G_EXC_ERROR;

656: p_contact_list,
657: p_contact_point_list) THEN
658: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
659: FND_MSG_PUB.ADD;
660: RAISE FND_API.G_EXC_ERROR;
661: END IF;
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: 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);
664: END IF;

Line 918: RAISE FND_API.G_EXC_ERROR;

914: IF lengthb(l_party_contains_str) > 4000 THEN
915: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
916: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: IF (p_match_str = ' AND ' OR p_party_max_score 921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
922: 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 977: RAISE FND_API.G_EXC_ERROR;

973: IF lengthb(l_contains_str) > 4000 THEN
974: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
975: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
976: FND_MSG_PUB.ADD;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: x_denorm_str := l_den_contains_str;
980: RETURN l_contains_str;
981: END;

Line 1242: RAISE FND_API.G_EXC_ERROR;

1238: when others then
1239: if (instrb(SQLERRM,'DRG-51030')>0) then
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1241: FND_MSG_PUB.ADD;
1242: RAISE FND_API.G_EXC_ERROR;
1243: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1245: FND_MSG_PUB.ADD;
1246: RAISE FND_API.G_EXC_ERROR;

Line 1246: RAISE FND_API.G_EXC_ERROR;

1242: RAISE FND_API.G_EXC_ERROR;
1243: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1245: FND_MSG_PUB.ADD;
1246: RAISE FND_API.G_EXC_ERROR;
1247: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1249: FND_MSG_PUB.ADD;
1250: RAISE FND_API.G_EXC_ERROR;

Line 1250: RAISE FND_API.G_EXC_ERROR;

1246: RAISE FND_API.G_EXC_ERROR;
1247: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1249: FND_MSG_PUB.ADD;
1250: RAISE FND_API.G_EXC_ERROR;
1251: else
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1253: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1254: FND_MSG_PUB.ADD;

Line 1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1251: else
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1253: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256: end if;
1257: END;
1258:
1259: PROCEDURE open_party_site_cursor(

Line 1487: RAISE FND_API.G_EXC_ERROR;

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

Line 1491: RAISE FND_API.G_EXC_ERROR;

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

Line 1495: RAISE FND_API.G_EXC_ERROR;

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

Line 1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1634: RAISE FND_API.G_EXC_ERROR;

1630: when others then
1631: if (instrb(SQLERRM,'DRG-51030')>0) then
1632: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1633: FND_MSG_PUB.ADD;
1634: RAISE FND_API.G_EXC_ERROR;
1635: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1637: FND_MSG_PUB.ADD;
1638: RAISE FND_API.G_EXC_ERROR;

Line 1638: RAISE FND_API.G_EXC_ERROR;

1634: RAISE FND_API.G_EXC_ERROR;
1635: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1637: FND_MSG_PUB.ADD;
1638: RAISE FND_API.G_EXC_ERROR;
1639: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1641: FND_MSG_PUB.ADD;
1642: RAISE FND_API.G_EXC_ERROR;

Line 1642: RAISE FND_API.G_EXC_ERROR;

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

Line 1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1643: else
1644: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1645: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1646: FND_MSG_PUB.ADD;
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: end if;
1649: END;
1650:
1651: PROCEDURE open_contact_pt_cursor(

Line 1907: RAISE FND_API.G_EXC_ERROR;

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

Line 1911: RAISE FND_API.G_EXC_ERROR;

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

Line 1915: RAISE FND_API.G_EXC_ERROR;

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

Line 1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2167: RAISE FND_API.G_EXC_ERROR;

2163: 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);
2164: END IF;
2165: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2166: FND_MSG_PUB.ADD;
2167: RAISE FND_API.G_EXC_ERROR;
2168: ELSE
2169: push_eval;
2170: RETURN;
2171: END IF;

Line 2215: RAISE FND_API.G_EXC_ERROR;

2211: 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);
2212: END IF;
2213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2214: FND_MSG_PUB.ADD;
2215: RAISE FND_API.G_EXC_ERROR;
2216: ELSE
2217: push_eval;
2218: RETURN;
2219: END IF;

Line 2288: RAISE FND_API.G_EXC_ERROR;

2284: 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);
2285: END IF;
2286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2287: FND_MSG_PUB.ADD;
2288: RAISE FND_API.G_EXC_ERROR;
2289: ELSE
2290: push_eval;
2291: RETURN;
2292: END IF;

Line 2400: RAISE FND_API.G_EXC_ERROR;

2396: 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);
2397: END IF;
2398: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2399: FND_MSG_PUB.ADD;
2400: RAISE FND_API.G_EXC_ERROR;
2401: ELSE
2402: push_eval;
2403: RETURN;
2404: END IF;

Line 2511: RAISE FND_API.G_EXC_ERROR;

2507: 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);
2508: END IF;
2509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2510: FND_MSG_PUB.ADD;
2511: RAISE FND_API.G_EXC_ERROR;
2512: ELSE
2513: push_eval;
2514: RETURN;
2515: END IF;

Line 2655: RAISE FND_API.G_EXC_ERROR;

2651: 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);
2652: END IF;
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2654: FND_MSG_PUB.ADD;
2655: RAISE FND_API.G_EXC_ERROR;
2656: END IF;
2657: ELSE
2658: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2659: 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 2663: RAISE FND_API.G_EXC_ERROR;

2659: 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);
2660: END IF;
2661: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2662: FND_MSG_PUB.ADD;
2663: RAISE FND_API.G_EXC_ERROR;
2664: END IF;
2665: END IF;
2666: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2667: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2905: WHEN FND_API.G_EXC_ERROR THEN

2901: END IF;
2902: EXCEPTION
2903: WHEN L_RETURN_IMM_EXC THEN
2904: RETURN;
2905: WHEN FND_API.G_EXC_ERROR THEN
2906: RAISE FND_API.G_EXC_ERROR;
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2909: WHEN OTHERS THEN

Line 2906: RAISE FND_API.G_EXC_ERROR;

2902: EXCEPTION
2903: WHEN L_RETURN_IMM_EXC THEN
2904: RETURN;
2905: WHEN FND_API.G_EXC_ERROR THEN
2906: RAISE FND_API.G_EXC_ERROR;
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2909: WHEN OTHERS THEN
2910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2903: WHEN L_RETURN_IMM_EXC THEN
2904: RETURN;
2905: WHEN FND_API.G_EXC_ERROR THEN
2906: RAISE FND_API.G_EXC_ERROR;
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2909: WHEN OTHERS THEN
2910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');

Line 2908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2904: RETURN;
2905: WHEN FND_API.G_EXC_ERROR THEN
2906: RAISE FND_API.G_EXC_ERROR;
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2909: WHEN OTHERS THEN
2910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2913: FND_MSG_PUB.ADD;
2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2915: END find_parties;
2916:
2917: PROCEDURE find_persons (
2918: p_rule_id IN NUMBER,

Line 3101: RAISE FND_API.G_EXC_ERROR;

3097: 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);
3098: END IF;
3099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3100: FND_MSG_PUB.ADD;
3101: RAISE FND_API.G_EXC_ERROR;
3102: ELSE
3103: push_eval;
3104: RETURN;
3105: END IF;

Line 3149: RAISE FND_API.G_EXC_ERROR;

3145: 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);
3146: END IF;
3147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3148: FND_MSG_PUB.ADD;
3149: RAISE FND_API.G_EXC_ERROR;
3150: ELSE
3151: push_eval;
3152: RETURN;
3153: END IF;

Line 3185: RAISE FND_API.G_EXC_ERROR;

3181: when others then
3182: if (instrb(SQLERRM,'DRG-51030')>0) then
3183: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3184: FND_MSG_PUB.ADD;
3185: RAISE FND_API.G_EXC_ERROR;
3186: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;

Line 3189: RAISE FND_API.G_EXC_ERROR;

3185: RAISE FND_API.G_EXC_ERROR;
3186: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: else
3191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3192: end if;
3193: END;

Line 3191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: else
3191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3192: end if;
3193: END;
3194:
3195: /** Private procedure to acquire and score at party site level ***/

Line 3261: RAISE FND_API.G_EXC_ERROR;

3257: 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);
3258: END IF;
3259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3260: FND_MSG_PUB.ADD;
3261: RAISE FND_API.G_EXC_ERROR;
3262: ELSE
3263: push_eval;
3264: RETURN;
3265: END IF;

Line 3450: RAISE FND_API.G_EXC_ERROR;

3446: 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);
3447: END IF;
3448: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3449: FND_MSG_PUB.ADD;
3450: RAISE FND_API.G_EXC_ERROR;
3451: ELSE
3452: push_eval;
3453: RETURN;
3454: END IF;

Line 3538: RAISE FND_API.G_EXC_ERROR;

3534: 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);
3535: END IF;
3536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3537: FND_MSG_PUB.ADD;
3538: RAISE FND_API.G_EXC_ERROR;
3539: END IF;
3540: ELSE
3541: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3542: 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 3546: RAISE FND_API.G_EXC_ERROR;

3542: 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);
3543: END IF;
3544: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3545: FND_MSG_PUB.ADD;
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548: END IF;
3549: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3550: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3686: WHEN FND_API.G_EXC_ERROR THEN

3682: END IF;
3683: EXCEPTION
3684: WHEN L_RETURN_IMM_EXC THEN
3685: RETURN;
3686: WHEN FND_API.G_EXC_ERROR THEN
3687: RAISE FND_API.G_EXC_ERROR;
3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3690: WHEN OTHERS THEN

Line 3687: RAISE FND_API.G_EXC_ERROR;

3683: EXCEPTION
3684: WHEN L_RETURN_IMM_EXC THEN
3685: RETURN;
3686: WHEN FND_API.G_EXC_ERROR THEN
3687: RAISE FND_API.G_EXC_ERROR;
3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3690: WHEN OTHERS THEN
3691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3684: WHEN L_RETURN_IMM_EXC THEN
3685: RETURN;
3686: WHEN FND_API.G_EXC_ERROR THEN
3687: RAISE FND_API.G_EXC_ERROR;
3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3690: WHEN OTHERS THEN
3691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');

Line 3689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3685: RETURN;
3686: WHEN FND_API.G_EXC_ERROR THEN
3687: RAISE FND_API.G_EXC_ERROR;
3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3690: WHEN OTHERS THEN
3691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3694: FND_MSG_PUB.ADD;
3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3696: END find_persons;
3697:
3698: PROCEDURE find_persons (
3699: p_rule_id IN NUMBER,

Line 3754: WHEN FND_API.G_EXC_ERROR THEN

3750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3751: 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);
3752: END IF;
3753: EXCEPTION
3754: WHEN FND_API.G_EXC_ERROR THEN
3755: RAISE FND_API.G_EXC_ERROR;
3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3758: WHEN OTHERS THEN

Line 3755: RAISE FND_API.G_EXC_ERROR;

3751: 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);
3752: END IF;
3753: EXCEPTION
3754: WHEN FND_API.G_EXC_ERROR THEN
3755: RAISE FND_API.G_EXC_ERROR;
3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3758: WHEN OTHERS THEN
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3752: END IF;
3753: EXCEPTION
3754: WHEN FND_API.G_EXC_ERROR THEN
3755: RAISE FND_API.G_EXC_ERROR;
3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3758: WHEN OTHERS THEN
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3760: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');

Line 3757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3753: EXCEPTION
3754: WHEN FND_API.G_EXC_ERROR THEN
3755: RAISE FND_API.G_EXC_ERROR;
3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3758: WHEN OTHERS THEN
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3760: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3760: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3764: END find_party_details;
3765:
3766: PROCEDURE find_duplicate_parties (
3767: p_rule_id IN NUMBER,

Line 3871: WHEN FND_API.G_EXC_ERROR THEN

3867: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3868: 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);
3869: END IF;
3870: EXCEPTION
3871: WHEN FND_API.G_EXC_ERROR THEN
3872: RAISE FND_API.G_EXC_ERROR;
3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3875: WHEN OTHERS THEN

Line 3872: RAISE FND_API.G_EXC_ERROR;

3868: 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);
3869: END IF;
3870: EXCEPTION
3871: WHEN FND_API.G_EXC_ERROR THEN
3872: RAISE FND_API.G_EXC_ERROR;
3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3875: WHEN OTHERS THEN
3876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3869: END IF;
3870: EXCEPTION
3871: WHEN FND_API.G_EXC_ERROR THEN
3872: RAISE FND_API.G_EXC_ERROR;
3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3875: WHEN OTHERS THEN
3876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3877: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');

Line 3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3870: EXCEPTION
3871: WHEN FND_API.G_EXC_ERROR THEN
3872: RAISE FND_API.G_EXC_ERROR;
3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3875: WHEN OTHERS THEN
3876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3877: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3878: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3877: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3878: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3879: FND_MSG_PUB.ADD;
3880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3881: END find_duplicate_parties;
3882:
3883: PROCEDURE find_duplicate_party_sites (
3884: p_rule_id IN NUMBER,

Line 3956: WHEN FND_API.G_EXC_ERROR THEN

3952: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3953: 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);
3954: END IF;
3955: EXCEPTION
3956: WHEN FND_API.G_EXC_ERROR THEN
3957: RAISE FND_API.G_EXC_ERROR;
3958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3960: WHEN OTHERS THEN

Line 3957: RAISE FND_API.G_EXC_ERROR;

3953: 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);
3954: END IF;
3955: EXCEPTION
3956: WHEN FND_API.G_EXC_ERROR THEN
3957: RAISE FND_API.G_EXC_ERROR;
3958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3960: WHEN OTHERS THEN
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3954: END IF;
3955: EXCEPTION
3956: WHEN FND_API.G_EXC_ERROR THEN
3957: RAISE FND_API.G_EXC_ERROR;
3958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3960: WHEN OTHERS THEN
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');

Line 3959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3955: EXCEPTION
3956: WHEN FND_API.G_EXC_ERROR THEN
3957: RAISE FND_API.G_EXC_ERROR;
3958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3960: WHEN OTHERS THEN
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3964: FND_MSG_PUB.ADD;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3966: END find_duplicate_party_sites;
3967:
3968: PROCEDURE find_duplicate_contacts (
3969: p_rule_id IN NUMBER,

Line 4045: WHEN FND_API.G_EXC_ERROR THEN

4041: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4042: 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);
4043: END IF;
4044: EXCEPTION
4045: WHEN FND_API.G_EXC_ERROR THEN
4046: RAISE FND_API.G_EXC_ERROR;
4047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4049: WHEN OTHERS THEN

Line 4046: RAISE FND_API.G_EXC_ERROR;

4042: 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);
4043: END IF;
4044: EXCEPTION
4045: WHEN FND_API.G_EXC_ERROR THEN
4046: RAISE FND_API.G_EXC_ERROR;
4047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4049: WHEN OTHERS THEN
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4043: END IF;
4044: EXCEPTION
4045: WHEN FND_API.G_EXC_ERROR THEN
4046: RAISE FND_API.G_EXC_ERROR;
4047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4049: WHEN OTHERS THEN
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');

Line 4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4044: EXCEPTION
4045: WHEN FND_API.G_EXC_ERROR THEN
4046: RAISE FND_API.G_EXC_ERROR;
4047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4049: WHEN OTHERS THEN
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4053: FND_MSG_PUB.ADD;
4054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4055: END find_duplicate_contacts;
4056:
4057: PROCEDURE find_duplicate_contact_points (
4058: p_rule_id IN NUMBER,

Line 4118: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4119: RAISE FND_API.G_EXC_ERROR;

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

Line 4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4385: WHEN FND_API.G_EXC_ERROR THEN

4381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4382: 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);
4383: END IF;
4384: EXCEPTION
4385: WHEN FND_API.G_EXC_ERROR THEN
4386: RAISE FND_API.G_EXC_ERROR;
4387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4389: WHEN OTHERS THEN

Line 4386: RAISE FND_API.G_EXC_ERROR;

4382: 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);
4383: END IF;
4384: EXCEPTION
4385: WHEN FND_API.G_EXC_ERROR THEN
4386: RAISE FND_API.G_EXC_ERROR;
4387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4389: WHEN OTHERS THEN
4390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4383: END IF;
4384: EXCEPTION
4385: WHEN FND_API.G_EXC_ERROR THEN
4386: RAISE FND_API.G_EXC_ERROR;
4387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4389: WHEN OTHERS THEN
4390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4391: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');

Line 4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4384: EXCEPTION
4385: WHEN FND_API.G_EXC_ERROR THEN
4386: RAISE FND_API.G_EXC_ERROR;
4387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4389: WHEN OTHERS THEN
4390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4391: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4391: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4393: FND_MSG_PUB.ADD;
4394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4395: END call_api_dynamic;
4396:
4397:
4398: PROCEDURE get_matching_party_sites (

Line 4618: WHEN FND_API.G_EXC_ERROR THEN

4614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4615: 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);
4616: END IF;
4617: EXCEPTION
4618: WHEN FND_API.G_EXC_ERROR THEN
4619: RAISE FND_API.G_EXC_ERROR;
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4622: WHEN OTHERS THEN

Line 4619: RAISE FND_API.G_EXC_ERROR;

4615: 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);
4616: END IF;
4617: EXCEPTION
4618: WHEN FND_API.G_EXC_ERROR THEN
4619: RAISE FND_API.G_EXC_ERROR;
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4622: WHEN OTHERS THEN
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4616: END IF;
4617: EXCEPTION
4618: WHEN FND_API.G_EXC_ERROR THEN
4619: RAISE FND_API.G_EXC_ERROR;
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4622: WHEN OTHERS THEN
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4624: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');

Line 4621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4617: EXCEPTION
4618: WHEN FND_API.G_EXC_ERROR THEN
4619: RAISE FND_API.G_EXC_ERROR;
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4622: WHEN OTHERS THEN
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4624: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4625: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4624: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4625: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4626: FND_MSG_PUB.ADD;
4627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4628: END get_matching_party_sites;
4629:
4630:
4631: PROCEDURE get_matching_contacts (

Line 4843: WHEN FND_API.G_EXC_ERROR THEN

4839: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4840: 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);
4841: END IF;
4842: EXCEPTION
4843: WHEN FND_API.G_EXC_ERROR THEN
4844: RAISE FND_API.G_EXC_ERROR;
4845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: WHEN OTHERS THEN

Line 4844: RAISE FND_API.G_EXC_ERROR;

4840: 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);
4841: END IF;
4842: EXCEPTION
4843: WHEN FND_API.G_EXC_ERROR THEN
4844: RAISE FND_API.G_EXC_ERROR;
4845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: WHEN OTHERS THEN
4848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4841: END IF;
4842: EXCEPTION
4843: WHEN FND_API.G_EXC_ERROR THEN
4844: RAISE FND_API.G_EXC_ERROR;
4845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: WHEN OTHERS THEN
4848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');

Line 4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4842: EXCEPTION
4843: WHEN FND_API.G_EXC_ERROR THEN
4844: RAISE FND_API.G_EXC_ERROR;
4845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: WHEN OTHERS THEN
4848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4851: FND_MSG_PUB.ADD;
4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4853: END get_matching_contacts;
4854:
4855:
4856: PROCEDURE get_matching_contact_points (

Line 4982: WHEN FND_API.G_EXC_ERROR THEN

4978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4979: 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);
4980: END IF;
4981: EXCEPTION
4982: WHEN FND_API.G_EXC_ERROR THEN
4983: RAISE FND_API.G_EXC_ERROR;
4984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4986: WHEN OTHERS THEN

Line 4983: RAISE FND_API.G_EXC_ERROR;

4979: 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);
4980: END IF;
4981: EXCEPTION
4982: WHEN FND_API.G_EXC_ERROR THEN
4983: RAISE FND_API.G_EXC_ERROR;
4984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4986: WHEN OTHERS THEN
4987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4980: END IF;
4981: EXCEPTION
4982: WHEN FND_API.G_EXC_ERROR THEN
4983: RAISE FND_API.G_EXC_ERROR;
4984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4986: WHEN OTHERS THEN
4987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4988: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');

Line 4985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4981: EXCEPTION
4982: WHEN FND_API.G_EXC_ERROR THEN
4983: RAISE FND_API.G_EXC_ERROR;
4984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4986: WHEN OTHERS THEN
4987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4988: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4989: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4988: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4989: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4990: FND_MSG_PUB.ADD;
4991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4992: END get_matching_contact_points;
4993:
4994: /**********************************************************
4995: This procedure finds the score details for a specific party that

Line 5179: WHEN FND_API.G_EXC_ERROR THEN

5175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5176: 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);
5177: END IF;
5178: EXCEPTION
5179: WHEN FND_API.G_EXC_ERROR THEN
5180: RAISE FND_API.G_EXC_ERROR;
5181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: WHEN OTHERS THEN

Line 5180: RAISE FND_API.G_EXC_ERROR;

5176: 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);
5177: END IF;
5178: EXCEPTION
5179: WHEN FND_API.G_EXC_ERROR THEN
5180: RAISE FND_API.G_EXC_ERROR;
5181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: WHEN OTHERS THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5177: END IF;
5178: EXCEPTION
5179: WHEN FND_API.G_EXC_ERROR THEN
5180: RAISE FND_API.G_EXC_ERROR;
5181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: WHEN OTHERS THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');

Line 5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5178: EXCEPTION
5179: WHEN FND_API.G_EXC_ERROR THEN
5180: RAISE FND_API.G_EXC_ERROR;
5181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: WHEN OTHERS THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5187: FND_MSG_PUB.ADD;
5188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5189: END get_score_details;
5190:
5191:
5192: /************************************************

Line 5257: WHEN FND_API.G_EXC_ERROR THEN

5253: END LOOP;
5254: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5255: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5256: EXCEPTION
5257: WHEN FND_API.G_EXC_ERROR THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN

Line 5258: RAISE FND_API.G_EXC_ERROR;

5254: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5255: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5256: EXCEPTION
5257: WHEN FND_API.G_EXC_ERROR THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN
5262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5255: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5256: EXCEPTION
5257: WHEN FND_API.G_EXC_ERROR THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN
5262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5263: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5256: EXCEPTION
5257: WHEN FND_API.G_EXC_ERROR THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN
5262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5263: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5263: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5265: FND_MSG_PUB.ADD;
5266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5267: END get_party_for_search;
5268:
5269: PROCEDURE get_search_criteria (
5270: p_party_id IN NUMBER,

Line 5297: WHEN FND_API.G_EXC_ERROR THEN

5293: END IF;
5294: get_party_site_rec(p_party_site_ids, x_party_site_list);
5295: END IF;
5296: EXCEPTION
5297: WHEN FND_API.G_EXC_ERROR THEN
5298: RAISE FND_API.G_EXC_ERROR;
5299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: WHEN OTHERS THEN

Line 5298: RAISE FND_API.G_EXC_ERROR;

5294: get_party_site_rec(p_party_site_ids, x_party_site_list);
5295: END IF;
5296: EXCEPTION
5297: WHEN FND_API.G_EXC_ERROR THEN
5298: RAISE FND_API.G_EXC_ERROR;
5299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: WHEN OTHERS THEN
5302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5295: END IF;
5296: EXCEPTION
5297: WHEN FND_API.G_EXC_ERROR THEN
5298: RAISE FND_API.G_EXC_ERROR;
5299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: WHEN OTHERS THEN
5302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5303: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5296: EXCEPTION
5297: WHEN FND_API.G_EXC_ERROR THEN
5298: RAISE FND_API.G_EXC_ERROR;
5299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: WHEN OTHERS THEN
5302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5303: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5303: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5305: FND_MSG_PUB.ADD;
5306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5307: END get_search_criteria;
5308:
5309:
5310: /************************************************

Line 5371: RAISE FND_API.G_EXC_ERROR;

5367: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_ERROR;
5372: END get_party_rec;
5373:
5374: /************************************************
5375: This procedure retrieves the match rule party site attributes into

Line 5425: RAISE FND_API.G_EXC_ERROR;

5421: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5422: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_ERROR;
5426: END get_party_site_rec;
5427:
5428: /************************************************
5429: This procedure retrieves the match rule contact attributes into

Line 5481: RAISE FND_API.G_EXC_ERROR;

5477: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5480: FND_MSG_PUB.ADD;
5481: RAISE FND_API.G_EXC_ERROR;
5482: END get_contact_rec;
5483:
5484: /************************************************
5485: This procedure retrieves the match rule contact point attributes into

Line 5533: RAISE FND_API.G_EXC_ERROR;

5529: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5530: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5532: FND_MSG_PUB.ADD;
5533: RAISE FND_API.G_EXC_ERROR;
5534: END get_contact_point_rec;
5535:
5536: /************************************************
5537: This procedure maps a search record from the logical

Line 5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5650: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5652: FND_MSG_PUB.ADD;
5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5654: END;
5655:
5656:
5657: /************************************************

Line 5722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5718: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5719: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5721: FND_MSG_PUB.ADD;
5722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5723: END;
5724:
5725:
5726: /************************************************

Line 5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5760: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: END;
5766:
5767:
5768: /************************************************

Line 5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5803: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5804: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5806: FND_MSG_PUB.ADD;
5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5808: END;
5809:
5810:
5811: /************************************************

Line 5841: WHEN FND_API.G_EXC_ERROR THEN

5837: END IF;
5838: END LOOP;
5839: RETURN FALSE;
5840: EXCEPTION
5841: WHEN FND_API.G_EXC_ERROR THEN
5842: RAISE FND_API.G_EXC_ERROR;
5843: WHEN OTHERS THEN
5844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5845: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5842: RAISE FND_API.G_EXC_ERROR;

5838: END LOOP;
5839: RETURN FALSE;
5840: EXCEPTION
5841: WHEN FND_API.G_EXC_ERROR THEN
5842: RAISE FND_API.G_EXC_ERROR;
5843: WHEN OTHERS THEN
5844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5845: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5845: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5847: FND_MSG_PUB.ADD;
5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5849: END check_prim_cond;
5850:
5851: /************************************************
5852: This procedure checks if the input search condition

Line 5892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5888: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5889: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5893: END check_party_site_cond;
5894:
5895: /************************************************
5896: This procedure checks if the input search condition

Line 5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5929: FND_MSG_PUB.ADD;
5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5931: END check_contact_cond;
5932:
5933: /************************************************
5934: This procedure checks if the input search condition

Line 5951: RAISE FND_API.G_EXC_ERROR;

5947: FOR I IN 1..p_contact_point_list.COUNT LOOP
5948: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5949: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5950: FND_MSG_PUB.ADD;
5951: RAISE FND_API.G_EXC_ERROR;
5952: END IF;
5953: END LOOP;
5954:
5955: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5964: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5966: FND_MSG_PUB.ADD;
5967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5968: END check_contact_point_cond;
5969:
5970: FUNCTION check_staged RETURN BOOLEAN IS
5971: