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_61 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 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

662: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
663: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END;
668:
669:
670: /************************************************

Line 686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

682: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
683: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
685: FND_MSG_PUB.ADD;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END;
688:
689:
690: /************************************************

Line 706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
703: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
705: FND_MSG_PUB.ADD;
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END;
708:
709:
710: /************************************************

Line 726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
723: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
724: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
725: FND_MSG_PUB.ADD;
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END;
728:
729: PROCEDURE init_score_context (
730: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 793: RAISE FND_API.G_EXC_ERROR;

789: p_contact_list,
790: p_contact_point_list) THEN
791: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
792: FND_MSG_PUB.ADD;
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
796: 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);
797: END IF;

Line 1085: RAISE FND_API.G_EXC_ERROR;

1081: IF lengthb(l_party_contains_str) > 4000 THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1083: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1084: FND_MSG_PUB.ADD;
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087: IF (p_match_str = ' AND ' OR p_party_max_score 1088: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1089: 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 1206: RAISE FND_API.G_EXC_ERROR;

1202: IF lengthb(l_contains_str) > 4000 THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1204: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: x_denorm_str := l_den_contains_str;
1209: RETURN l_contains_str;
1210: END;

Line 1446: RAISE FND_API.G_EXC_ERROR;

1442: when others then
1443: if (instrb(SQLERRM,'DRG-51030')>0) then
1444: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1445: FND_MSG_PUB.ADD;
1446: RAISE FND_API.G_EXC_ERROR;
1447: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1448: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1449: FND_MSG_PUB.ADD;
1450: RAISE FND_API.G_EXC_ERROR;

Line 1450: RAISE FND_API.G_EXC_ERROR;

1446: RAISE FND_API.G_EXC_ERROR;
1447: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1448: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1449: FND_MSG_PUB.ADD;
1450: RAISE FND_API.G_EXC_ERROR;
1451: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1453: FND_MSG_PUB.ADD;
1454: RAISE FND_API.G_EXC_ERROR;

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450: RAISE FND_API.G_EXC_ERROR;
1451: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1453: FND_MSG_PUB.ADD;
1454: RAISE FND_API.G_EXC_ERROR;
1455: else
1456: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1458: FND_MSG_PUB.ADD;

Line 1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1455: else
1456: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1458: FND_MSG_PUB.ADD;
1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1460: end if;
1461: END;
1462:
1463: PROCEDURE open_party_site_cursor(

Line 1691: RAISE FND_API.G_EXC_ERROR;

1687: when others then
1688: if (instrb(SQLERRM,'DRG-51030')>0) then
1689: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1690: FND_MSG_PUB.ADD;
1691: RAISE FND_API.G_EXC_ERROR;
1692: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1694: FND_MSG_PUB.ADD;
1695: RAISE FND_API.G_EXC_ERROR;

Line 1695: RAISE FND_API.G_EXC_ERROR;

1691: RAISE FND_API.G_EXC_ERROR;
1692: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1694: FND_MSG_PUB.ADD;
1695: RAISE FND_API.G_EXC_ERROR;
1696: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1698: FND_MSG_PUB.ADD;
1699: RAISE FND_API.G_EXC_ERROR;

Line 1699: RAISE FND_API.G_EXC_ERROR;

1695: RAISE FND_API.G_EXC_ERROR;
1696: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1698: FND_MSG_PUB.ADD;
1699: RAISE FND_API.G_EXC_ERROR;
1700: else
1701: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1702: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1703: FND_MSG_PUB.ADD;

Line 1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1700: else
1701: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1702: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1703: FND_MSG_PUB.ADD;
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: end if;
1706: END;
1707:
1708: PROCEDURE open_contact_cursor(

Line 1838: RAISE FND_API.G_EXC_ERROR;

1834: when others then
1835: if (instrb(SQLERRM,'DRG-51030')>0) then
1836: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE FND_API.G_EXC_ERROR;

Line 1842: RAISE FND_API.G_EXC_ERROR;

1838: RAISE FND_API.G_EXC_ERROR;
1839: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1845: FND_MSG_PUB.ADD;
1846: RAISE FND_API.G_EXC_ERROR;

Line 1846: RAISE FND_API.G_EXC_ERROR;

1842: RAISE FND_API.G_EXC_ERROR;
1843: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1845: FND_MSG_PUB.ADD;
1846: RAISE FND_API.G_EXC_ERROR;
1847: else
1848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1850: FND_MSG_PUB.ADD;

Line 1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1847: else
1848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1850: FND_MSG_PUB.ADD;
1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1852: end if;
1853: END;
1854:
1855: PROCEDURE open_contact_pt_cursor(

Line 2111: RAISE FND_API.G_EXC_ERROR;

2107: when others then
2108: if (instrb(SQLERRM,'DRG-51030')>0) then
2109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2110: FND_MSG_PUB.ADD;
2111: RAISE FND_API.G_EXC_ERROR;
2112: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2114: FND_MSG_PUB.ADD;
2115: RAISE FND_API.G_EXC_ERROR;

Line 2115: RAISE FND_API.G_EXC_ERROR;

2111: RAISE FND_API.G_EXC_ERROR;
2112: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2114: FND_MSG_PUB.ADD;
2115: RAISE FND_API.G_EXC_ERROR;
2116: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2118: FND_MSG_PUB.ADD;
2119: RAISE FND_API.G_EXC_ERROR;

Line 2119: RAISE FND_API.G_EXC_ERROR;

2115: RAISE FND_API.G_EXC_ERROR;
2116: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2118: FND_MSG_PUB.ADD;
2119: RAISE FND_API.G_EXC_ERROR;
2120: else
2121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2123: FND_MSG_PUB.ADD;

Line 2124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2120: else
2121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2123: FND_MSG_PUB.ADD;
2124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2125: end if;
2126: END;
2127:
2128:

Line 2375: RAISE FND_API.G_EXC_ERROR;

2371: 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);
2372: END IF;
2373: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_ERROR;
2376: ELSE
2377: push_eval;
2378: RETURN;
2379: END IF;

Line 2423: RAISE FND_API.G_EXC_ERROR;

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

Line 2496: RAISE FND_API.G_EXC_ERROR;

2492: 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);
2493: END IF;
2494: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2495: FND_MSG_PUB.ADD;
2496: RAISE FND_API.G_EXC_ERROR;
2497: ELSE
2498: push_eval;
2499: RETURN;
2500: END IF;

Line 2608: RAISE FND_API.G_EXC_ERROR;

2604: 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);
2605: END IF;
2606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2607: FND_MSG_PUB.ADD;
2608: RAISE FND_API.G_EXC_ERROR;
2609: ELSE
2610: push_eval;
2611: RETURN;
2612: END IF;

Line 2719: RAISE FND_API.G_EXC_ERROR;

2715: 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);
2716: END IF;
2717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2718: FND_MSG_PUB.ADD;
2719: RAISE FND_API.G_EXC_ERROR;
2720: ELSE
2721: push_eval;
2722: RETURN;
2723: END IF;

Line 2944: RAISE FND_API.G_EXC_ERROR;

2940: 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);
2941: END IF;
2942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_ERROR;
2945: END IF;
2946: ELSE
2947: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2948: 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 2952: RAISE FND_API.G_EXC_ERROR;

2948: 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);
2949: END IF;
2950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2951: FND_MSG_PUB.ADD;
2952: RAISE FND_API.G_EXC_ERROR;
2953: END IF;
2954: END IF;
2955: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2956: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3151: WHEN FND_API.G_EXC_ERROR THEN

3147: END IF;
3148: EXCEPTION
3149: WHEN L_RETURN_IMM_EXC THEN
3150: RETURN;
3151: WHEN FND_API.G_EXC_ERROR THEN
3152: RAISE FND_API.G_EXC_ERROR;
3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: WHEN OTHERS THEN

Line 3152: RAISE FND_API.G_EXC_ERROR;

3148: EXCEPTION
3149: WHEN L_RETURN_IMM_EXC THEN
3150: RETURN;
3151: WHEN FND_API.G_EXC_ERROR THEN
3152: RAISE FND_API.G_EXC_ERROR;
3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: WHEN OTHERS THEN
3156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3149: WHEN L_RETURN_IMM_EXC THEN
3150: RETURN;
3151: WHEN FND_API.G_EXC_ERROR THEN
3152: RAISE FND_API.G_EXC_ERROR;
3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: WHEN OTHERS THEN
3156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3157: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');

Line 3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3150: RETURN;
3151: WHEN FND_API.G_EXC_ERROR THEN
3152: RAISE FND_API.G_EXC_ERROR;
3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: WHEN OTHERS THEN
3156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3157: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3157: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3159: FND_MSG_PUB.ADD;
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END find_parties;
3162:
3163: PROCEDURE find_persons (
3164: p_rule_id IN NUMBER,

Line 3351: RAISE FND_API.G_EXC_ERROR;

3347: 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);
3348: END IF;
3349: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3350: FND_MSG_PUB.ADD;
3351: RAISE FND_API.G_EXC_ERROR;
3352: ELSE
3353: push_eval;
3354: RETURN;
3355: END IF;

Line 3399: RAISE FND_API.G_EXC_ERROR;

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

Line 3435: RAISE FND_API.G_EXC_ERROR;

3431: when others then
3432: if (instrb(SQLERRM,'DRG-51030')>0) then
3433: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3434: FND_MSG_PUB.ADD;
3435: RAISE FND_API.G_EXC_ERROR;
3436: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3438: FND_MSG_PUB.ADD;
3439: RAISE FND_API.G_EXC_ERROR;

Line 3439: RAISE FND_API.G_EXC_ERROR;

3435: RAISE FND_API.G_EXC_ERROR;
3436: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3438: FND_MSG_PUB.ADD;
3439: RAISE FND_API.G_EXC_ERROR;
3440: else
3441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3442: end if;
3443: END;

Line 3441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3438: FND_MSG_PUB.ADD;
3439: RAISE FND_API.G_EXC_ERROR;
3440: else
3441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3442: end if;
3443: END;
3444:
3445: /** Private procedure to acquire and score at party site level ***/

Line 3511: RAISE FND_API.G_EXC_ERROR;

3507: 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);
3508: END IF;
3509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3510: FND_MSG_PUB.ADD;
3511: RAISE FND_API.G_EXC_ERROR;
3512: ELSE
3513: push_eval;
3514: RETURN;
3515: END IF;

Line 3770: RAISE FND_API.G_EXC_ERROR;

3766: 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);
3767: END IF;
3768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3769: FND_MSG_PUB.ADD;
3770: RAISE FND_API.G_EXC_ERROR;
3771: ELSE
3772: push_eval;
3773: RETURN;
3774: END IF;

Line 3883: RAISE FND_API.G_EXC_ERROR;

3879: 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);
3880: END IF;
3881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3882: FND_MSG_PUB.ADD;
3883: RAISE FND_API.G_EXC_ERROR;
3884: END IF;
3885: ELSE
3886: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3887: 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 3891: RAISE FND_API.G_EXC_ERROR;

3887: 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);
3888: END IF;
3889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893: END IF;
3894: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3895: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4005: WHEN FND_API.G_EXC_ERROR THEN

4001: END IF;
4002: EXCEPTION
4003: WHEN L_RETURN_IMM_EXC THEN
4004: RETURN;
4005: WHEN FND_API.G_EXC_ERROR THEN
4006: RAISE FND_API.G_EXC_ERROR;
4007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: WHEN OTHERS THEN

Line 4006: RAISE FND_API.G_EXC_ERROR;

4002: EXCEPTION
4003: WHEN L_RETURN_IMM_EXC THEN
4004: RETURN;
4005: WHEN FND_API.G_EXC_ERROR THEN
4006: RAISE FND_API.G_EXC_ERROR;
4007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: WHEN OTHERS THEN
4010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4003: WHEN L_RETURN_IMM_EXC THEN
4004: RETURN;
4005: WHEN FND_API.G_EXC_ERROR THEN
4006: RAISE FND_API.G_EXC_ERROR;
4007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: WHEN OTHERS THEN
4010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');

Line 4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4004: RETURN;
4005: WHEN FND_API.G_EXC_ERROR THEN
4006: RAISE FND_API.G_EXC_ERROR;
4007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: WHEN OTHERS THEN
4010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4013: FND_MSG_PUB.ADD;
4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4015: END find_persons;
4016:
4017: PROCEDURE find_persons (
4018: p_rule_id IN NUMBER,

Line 4073: WHEN FND_API.G_EXC_ERROR THEN

4069: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4070: 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);
4071: END IF;
4072: EXCEPTION
4073: WHEN FND_API.G_EXC_ERROR THEN
4074: RAISE FND_API.G_EXC_ERROR;
4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: WHEN OTHERS THEN

Line 4074: RAISE FND_API.G_EXC_ERROR;

4070: 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);
4071: END IF;
4072: EXCEPTION
4073: WHEN FND_API.G_EXC_ERROR THEN
4074: RAISE FND_API.G_EXC_ERROR;
4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: WHEN OTHERS THEN
4078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4071: END IF;
4072: EXCEPTION
4073: WHEN FND_API.G_EXC_ERROR THEN
4074: RAISE FND_API.G_EXC_ERROR;
4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: WHEN OTHERS THEN
4078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');

Line 4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4072: EXCEPTION
4073: WHEN FND_API.G_EXC_ERROR THEN
4074: RAISE FND_API.G_EXC_ERROR;
4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: WHEN OTHERS THEN
4078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4081: FND_MSG_PUB.ADD;
4082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4083: END find_party_details;
4084:
4085: PROCEDURE find_duplicate_parties (
4086: p_rule_id IN NUMBER,

Line 4190: WHEN FND_API.G_EXC_ERROR THEN

4186: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4187: 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);
4188: END IF;
4189: EXCEPTION
4190: WHEN FND_API.G_EXC_ERROR THEN
4191: RAISE FND_API.G_EXC_ERROR;
4192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: WHEN OTHERS THEN

Line 4191: RAISE FND_API.G_EXC_ERROR;

4187: 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);
4188: END IF;
4189: EXCEPTION
4190: WHEN FND_API.G_EXC_ERROR THEN
4191: RAISE FND_API.G_EXC_ERROR;
4192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: WHEN OTHERS THEN
4195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4188: END IF;
4189: EXCEPTION
4190: WHEN FND_API.G_EXC_ERROR THEN
4191: RAISE FND_API.G_EXC_ERROR;
4192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: WHEN OTHERS THEN
4195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4196: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');

Line 4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4189: EXCEPTION
4190: WHEN FND_API.G_EXC_ERROR THEN
4191: RAISE FND_API.G_EXC_ERROR;
4192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: WHEN OTHERS THEN
4195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4196: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4196: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4198: FND_MSG_PUB.ADD;
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4200: END find_duplicate_parties;
4201:
4202: PROCEDURE find_duplicate_party_sites (
4203: p_rule_id IN NUMBER,

Line 4275: WHEN FND_API.G_EXC_ERROR THEN

4271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4272: 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);
4273: END IF;
4274: EXCEPTION
4275: WHEN FND_API.G_EXC_ERROR THEN
4276: RAISE FND_API.G_EXC_ERROR;
4277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: WHEN OTHERS THEN

Line 4276: RAISE FND_API.G_EXC_ERROR;

4272: 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);
4273: END IF;
4274: EXCEPTION
4275: WHEN FND_API.G_EXC_ERROR THEN
4276: RAISE FND_API.G_EXC_ERROR;
4277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: WHEN OTHERS THEN
4280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4273: END IF;
4274: EXCEPTION
4275: WHEN FND_API.G_EXC_ERROR THEN
4276: RAISE FND_API.G_EXC_ERROR;
4277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: WHEN OTHERS THEN
4280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4281: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');

Line 4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4274: EXCEPTION
4275: WHEN FND_API.G_EXC_ERROR THEN
4276: RAISE FND_API.G_EXC_ERROR;
4277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: WHEN OTHERS THEN
4280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4281: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4281: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4283: FND_MSG_PUB.ADD;
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: END find_duplicate_party_sites;
4286:
4287: PROCEDURE find_duplicate_contacts (
4288: p_rule_id IN NUMBER,

Line 4364: WHEN FND_API.G_EXC_ERROR THEN

4360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4361: 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);
4362: END IF;
4363: EXCEPTION
4364: WHEN FND_API.G_EXC_ERROR THEN
4365: RAISE FND_API.G_EXC_ERROR;
4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: WHEN OTHERS THEN

Line 4365: RAISE FND_API.G_EXC_ERROR;

4361: 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);
4362: END IF;
4363: EXCEPTION
4364: WHEN FND_API.G_EXC_ERROR THEN
4365: RAISE FND_API.G_EXC_ERROR;
4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: WHEN OTHERS THEN
4369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4362: END IF;
4363: EXCEPTION
4364: WHEN FND_API.G_EXC_ERROR THEN
4365: RAISE FND_API.G_EXC_ERROR;
4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: WHEN OTHERS THEN
4369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4370: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');

Line 4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4363: EXCEPTION
4364: WHEN FND_API.G_EXC_ERROR THEN
4365: RAISE FND_API.G_EXC_ERROR;
4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: WHEN OTHERS THEN
4369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4370: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4370: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4372: FND_MSG_PUB.ADD;
4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4374: END find_duplicate_contacts;
4375:
4376: PROCEDURE find_duplicate_contact_points (
4377: p_rule_id IN NUMBER,

Line 4437: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4438: RAISE FND_API.G_EXC_ERROR;

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

Line 4439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4435: END IF;
4436: EXCEPTION
4437: WHEN FND_API.G_EXC_ERROR THEN
4438: RAISE FND_API.G_EXC_ERROR;
4439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: WHEN OTHERS THEN
4442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4443: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');

Line 4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4436: EXCEPTION
4437: WHEN FND_API.G_EXC_ERROR THEN
4438: RAISE FND_API.G_EXC_ERROR;
4439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: WHEN OTHERS THEN
4442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4443: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4728: WHEN FND_API.G_EXC_ERROR THEN

4724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4725: 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);
4726: END IF;
4727: EXCEPTION
4728: WHEN FND_API.G_EXC_ERROR THEN
4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN

Line 4729: RAISE FND_API.G_EXC_ERROR;

4725: 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);
4726: END IF;
4727: EXCEPTION
4728: WHEN FND_API.G_EXC_ERROR THEN
4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4726: END IF;
4727: EXCEPTION
4728: WHEN FND_API.G_EXC_ERROR THEN
4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');

Line 4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4727: EXCEPTION
4728: WHEN FND_API.G_EXC_ERROR THEN
4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: END call_api_dynamic;
4739:
4740:
4741: PROCEDURE get_matching_party_sites (

Line 4962: WHEN FND_API.G_EXC_ERROR THEN

4958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4959: 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);
4960: END IF;
4961: EXCEPTION
4962: WHEN FND_API.G_EXC_ERROR THEN
4963: RAISE FND_API.G_EXC_ERROR;
4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN

Line 4963: RAISE FND_API.G_EXC_ERROR;

4959: 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);
4960: END IF;
4961: EXCEPTION
4962: WHEN FND_API.G_EXC_ERROR THEN
4963: RAISE FND_API.G_EXC_ERROR;
4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4960: END IF;
4961: EXCEPTION
4962: WHEN FND_API.G_EXC_ERROR THEN
4963: RAISE FND_API.G_EXC_ERROR;
4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');

Line 4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4961: EXCEPTION
4962: WHEN FND_API.G_EXC_ERROR THEN
4963: RAISE FND_API.G_EXC_ERROR;
4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4972: END get_matching_party_sites;
4973:
4974:
4975: PROCEDURE get_matching_contacts (

Line 5189: WHEN FND_API.G_EXC_ERROR THEN

5185: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5186: 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);
5187: END IF;
5188: EXCEPTION
5189: WHEN FND_API.G_EXC_ERROR THEN
5190: RAISE FND_API.G_EXC_ERROR;
5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: WHEN OTHERS THEN

Line 5190: RAISE FND_API.G_EXC_ERROR;

5186: 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);
5187: END IF;
5188: EXCEPTION
5189: WHEN FND_API.G_EXC_ERROR THEN
5190: RAISE FND_API.G_EXC_ERROR;
5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: WHEN OTHERS THEN
5194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5187: END IF;
5188: EXCEPTION
5189: WHEN FND_API.G_EXC_ERROR THEN
5190: RAISE FND_API.G_EXC_ERROR;
5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: WHEN OTHERS THEN
5194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');

Line 5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5188: EXCEPTION
5189: WHEN FND_API.G_EXC_ERROR THEN
5190: RAISE FND_API.G_EXC_ERROR;
5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: WHEN OTHERS THEN
5194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5197: FND_MSG_PUB.ADD;
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: END get_matching_contacts;
5200:
5201:
5202: PROCEDURE get_matching_contact_points (

Line 5330: WHEN FND_API.G_EXC_ERROR THEN

5326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5327: 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);
5328: END IF;
5329: EXCEPTION
5330: WHEN FND_API.G_EXC_ERROR THEN
5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN

Line 5331: RAISE FND_API.G_EXC_ERROR;

5327: 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);
5328: END IF;
5329: EXCEPTION
5330: WHEN FND_API.G_EXC_ERROR THEN
5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5328: END IF;
5329: EXCEPTION
5330: WHEN FND_API.G_EXC_ERROR THEN
5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');

Line 5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5329: EXCEPTION
5330: WHEN FND_API.G_EXC_ERROR THEN
5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340: END get_matching_contact_points;
5341:
5342: /**********************************************************
5343: This procedure finds the score details for a specific party that

Line 5536: WHEN FND_API.G_EXC_ERROR THEN

5532: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5533: 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);
5534: END IF;
5535: EXCEPTION
5536: WHEN FND_API.G_EXC_ERROR THEN
5537: RAISE FND_API.G_EXC_ERROR;
5538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: WHEN OTHERS THEN

Line 5537: RAISE FND_API.G_EXC_ERROR;

5533: 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);
5534: END IF;
5535: EXCEPTION
5536: WHEN FND_API.G_EXC_ERROR THEN
5537: RAISE FND_API.G_EXC_ERROR;
5538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: WHEN OTHERS THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5534: END IF;
5535: EXCEPTION
5536: WHEN FND_API.G_EXC_ERROR THEN
5537: RAISE FND_API.G_EXC_ERROR;
5538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: WHEN OTHERS THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');

Line 5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5535: EXCEPTION
5536: WHEN FND_API.G_EXC_ERROR THEN
5537: RAISE FND_API.G_EXC_ERROR;
5538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: WHEN OTHERS THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5546: END get_score_details;
5547:
5548:
5549: /************************************************

Line 5611: WHEN FND_API.G_EXC_ERROR THEN

5607: END LOOP;
5608: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5609: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5610: EXCEPTION
5611: WHEN FND_API.G_EXC_ERROR THEN
5612: RAISE FND_API.G_EXC_ERROR;
5613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: WHEN OTHERS THEN

Line 5612: RAISE FND_API.G_EXC_ERROR;

5608: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5609: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5610: EXCEPTION
5611: WHEN FND_API.G_EXC_ERROR THEN
5612: RAISE FND_API.G_EXC_ERROR;
5613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: WHEN OTHERS THEN
5616: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5609: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5610: EXCEPTION
5611: WHEN FND_API.G_EXC_ERROR THEN
5612: RAISE FND_API.G_EXC_ERROR;
5613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: WHEN OTHERS THEN
5616: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5617: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5616: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5617: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5618: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5619: FND_MSG_PUB.ADD;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: END get_party_for_search;
5622:
5623: PROCEDURE get_search_criteria (
5624: p_party_id IN NUMBER,

Line 5651: WHEN FND_API.G_EXC_ERROR THEN

5647: END IF;
5648: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5649: END IF;
5650: EXCEPTION
5651: WHEN FND_API.G_EXC_ERROR THEN
5652: RAISE FND_API.G_EXC_ERROR;
5653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: WHEN OTHERS THEN

Line 5652: RAISE FND_API.G_EXC_ERROR;

5648: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5649: END IF;
5650: EXCEPTION
5651: WHEN FND_API.G_EXC_ERROR THEN
5652: RAISE FND_API.G_EXC_ERROR;
5653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: WHEN OTHERS THEN
5656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5649: END IF;
5650: EXCEPTION
5651: WHEN FND_API.G_EXC_ERROR THEN
5652: RAISE FND_API.G_EXC_ERROR;
5653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: WHEN OTHERS THEN
5656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5657: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5650: EXCEPTION
5651: WHEN FND_API.G_EXC_ERROR THEN
5652: RAISE FND_API.G_EXC_ERROR;
5653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: WHEN OTHERS THEN
5656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5657: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5657: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5661: END get_search_criteria;
5662:
5663:
5664: /************************************************

Line 5727: RAISE FND_API.G_EXC_ERROR;

5723: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5724: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_ERROR;
5728: END get_party_rec;
5729:
5730: /************************************************
5731: This procedure retrieves the match rule party site attributes into

Line 5779: RAISE FND_API.G_EXC_ERROR;

5775: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5778: FND_MSG_PUB.ADD;
5779: RAISE FND_API.G_EXC_ERROR;
5780: END get_party_site_rec;
5781:
5782: /************************************************
5783: This procedure retrieves the match rule contact attributes into

Line 5835: RAISE FND_API.G_EXC_ERROR;

5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_contact_rec;
5837:
5838: /************************************************
5839: This procedure retrieves the match rule contact point attributes into

Line 5889: RAISE FND_API.G_EXC_ERROR;

5885: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5886: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5888: FND_MSG_PUB.ADD;
5889: RAISE FND_API.G_EXC_ERROR;
5890: END get_contact_point_rec;
5891:
5892: /************************************************
5893: This procedure maps a search record from the logical

Line 6082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6079: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6081: FND_MSG_PUB.ADD;
6082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6083: END;
6084:
6085:
6086: /************************************************

Line 6125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6121: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6122: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6123: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6124: FND_MSG_PUB.ADD;
6125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6126: END;
6127:
6128:
6129: /************************************************

Line 6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6166: FND_MSG_PUB.ADD;
6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6168: END;
6169:
6170:
6171: /************************************************

Line 6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6268: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6269: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6270: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6271: FND_MSG_PUB.ADD;
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: END;
6274:
6275:
6276: /************************************************

Line 6296: RAISE FND_API.G_EXC_ERROR;

6292: p_contact_point_list(I).URL IS NOT NULL
6293: ) THEN
6294: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6295: FND_MSG_PUB.ADD;
6296: RAISE FND_API.G_EXC_ERROR;
6297: END IF;
6298: END LOOP;
6299:
6300: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 6322: WHEN FND_API.G_EXC_ERROR THEN

6318: END IF;
6319: END LOOP;
6320: RETURN FALSE;
6321: EXCEPTION
6322: WHEN FND_API.G_EXC_ERROR THEN
6323: RAISE FND_API.G_EXC_ERROR;
6324: WHEN OTHERS THEN
6325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6326: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6323: RAISE FND_API.G_EXC_ERROR;

6319: END LOOP;
6320: RETURN FALSE;
6321: EXCEPTION
6322: WHEN FND_API.G_EXC_ERROR THEN
6323: RAISE FND_API.G_EXC_ERROR;
6324: WHEN OTHERS THEN
6325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6326: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6326: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6328: FND_MSG_PUB.ADD;
6329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6330: END check_prim_cond;
6331:
6332: /************************************************
6333: This procedure checks if the input search condition

Line 6373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6370: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6374: END check_party_site_cond;
6375:
6376: /************************************************
6377: This procedure checks if the input search condition

Line 6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6420: END check_contact_cond;
6421:
6422: /************************************************
6423: This procedure checks if the input search condition

Line 6440: RAISE FND_API.G_EXC_ERROR;

6436: FOR I IN 1..p_contact_point_list.COUNT LOOP
6437: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6438: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6439: FND_MSG_PUB.ADD;
6440: RAISE FND_API.G_EXC_ERROR;
6441: END IF;
6442: END LOOP;
6443:
6444: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6460: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6461: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6462: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6463: FND_MSG_PUB.ADD;
6464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6465: END check_contact_point_cond;
6466:
6467: FUNCTION check_staged RETURN BOOLEAN IS
6468: