eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HZ_MATCH_RULE_35 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 788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
790:
791:
792: /************************************************

Line 813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

809: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
810: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END;
815:
816:
817: /************************************************

Line 833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

829: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
830: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END;
835:
836:
837: /************************************************

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END;
855:
856: PROCEDURE init_score_context (
857: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 920: RAISE FND_API.G_EXC_ERROR;

916: p_contact_list,
917: p_contact_point_list) THEN
918: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
919: FND_MSG_PUB.ADD;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
923: 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);
924: END IF;

Line 1191: RAISE FND_API.G_EXC_ERROR;

1187: IF lengthb(l_party_contains_str) > 4000 THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1189: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: IF (p_match_str = ' AND ' OR p_party_max_score 1194: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1195: 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 1280: RAISE FND_API.G_EXC_ERROR;

1276: IF lengthb(l_contains_str) > 4000 THEN
1277: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1278: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282: x_denorm_str := l_den_contains_str;
1283: RETURN l_contains_str;
1284: END;

Line 1576: RAISE FND_API.G_EXC_ERROR;

1572: when others then
1573: if (instrb(SQLERRM,'DRG-51030')>0) then
1574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1575: FND_MSG_PUB.ADD;
1576: RAISE FND_API.G_EXC_ERROR;
1577: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_ERROR;

Line 1580: RAISE FND_API.G_EXC_ERROR;

1576: RAISE FND_API.G_EXC_ERROR;
1577: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_ERROR;
1581: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1583: FND_MSG_PUB.ADD;
1584: RAISE FND_API.G_EXC_ERROR;

Line 1584: RAISE FND_API.G_EXC_ERROR;

1580: RAISE FND_API.G_EXC_ERROR;
1581: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1583: FND_MSG_PUB.ADD;
1584: RAISE FND_API.G_EXC_ERROR;
1585: else
1586: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1587: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1588: FND_MSG_PUB.ADD;

Line 1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1585: else
1586: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1587: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1588: FND_MSG_PUB.ADD;
1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1590: end if;
1591: END;
1592:
1593: PROCEDURE open_party_site_cursor(

Line 1821: RAISE FND_API.G_EXC_ERROR;

1817: when others then
1818: if (instrb(SQLERRM,'DRG-51030')>0) then
1819: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1824: FND_MSG_PUB.ADD;
1825: RAISE FND_API.G_EXC_ERROR;

Line 1825: RAISE FND_API.G_EXC_ERROR;

1821: RAISE FND_API.G_EXC_ERROR;
1822: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1824: FND_MSG_PUB.ADD;
1825: RAISE FND_API.G_EXC_ERROR;
1826: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;

Line 1829: RAISE FND_API.G_EXC_ERROR;

1825: RAISE FND_API.G_EXC_ERROR;
1826: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;
1830: else
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1833: FND_MSG_PUB.ADD;

Line 1834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1830: else
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1833: FND_MSG_PUB.ADD;
1834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1835: end if;
1836: END;
1837:
1838: PROCEDURE open_contact_cursor(

Line 1968: RAISE FND_API.G_EXC_ERROR;

1964: when others then
1965: if (instrb(SQLERRM,'DRG-51030')>0) then
1966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1967: FND_MSG_PUB.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1970: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1971: FND_MSG_PUB.ADD;
1972: RAISE FND_API.G_EXC_ERROR;

Line 1972: RAISE FND_API.G_EXC_ERROR;

1968: RAISE FND_API.G_EXC_ERROR;
1969: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1970: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1971: FND_MSG_PUB.ADD;
1972: RAISE FND_API.G_EXC_ERROR;
1973: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1975: FND_MSG_PUB.ADD;
1976: RAISE FND_API.G_EXC_ERROR;

Line 1976: RAISE FND_API.G_EXC_ERROR;

1972: RAISE FND_API.G_EXC_ERROR;
1973: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1975: FND_MSG_PUB.ADD;
1976: RAISE FND_API.G_EXC_ERROR;
1977: else
1978: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1980: FND_MSG_PUB.ADD;

Line 1981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1977: else
1978: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1980: FND_MSG_PUB.ADD;
1981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1982: end if;
1983: END;
1984:
1985: PROCEDURE open_contact_pt_cursor(

Line 2241: RAISE FND_API.G_EXC_ERROR;

2237: when others then
2238: if (instrb(SQLERRM,'DRG-51030')>0) then
2239: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2240: FND_MSG_PUB.ADD;
2241: RAISE FND_API.G_EXC_ERROR;
2242: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2243: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2244: FND_MSG_PUB.ADD;
2245: RAISE FND_API.G_EXC_ERROR;

Line 2245: RAISE FND_API.G_EXC_ERROR;

2241: RAISE FND_API.G_EXC_ERROR;
2242: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2243: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2244: FND_MSG_PUB.ADD;
2245: RAISE FND_API.G_EXC_ERROR;
2246: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2247: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2248: FND_MSG_PUB.ADD;
2249: RAISE FND_API.G_EXC_ERROR;

Line 2249: RAISE FND_API.G_EXC_ERROR;

2245: RAISE FND_API.G_EXC_ERROR;
2246: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2247: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2248: FND_MSG_PUB.ADD;
2249: RAISE FND_API.G_EXC_ERROR;
2250: else
2251: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2253: FND_MSG_PUB.ADD;

Line 2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2250: else
2251: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2253: FND_MSG_PUB.ADD;
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2255: end if;
2256: END;
2257:
2258:

Line 2510: RAISE FND_API.G_EXC_ERROR;

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

Line 2558: RAISE FND_API.G_EXC_ERROR;

2554: 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);
2555: END IF;
2556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2557: FND_MSG_PUB.ADD;
2558: RAISE FND_API.G_EXC_ERROR;
2559: ELSE
2560: push_eval;
2561: RETURN;
2562: END IF;

Line 2631: RAISE FND_API.G_EXC_ERROR;

2627: 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);
2628: END IF;
2629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2630: FND_MSG_PUB.ADD;
2631: RAISE FND_API.G_EXC_ERROR;
2632: ELSE
2633: push_eval;
2634: RETURN;
2635: END IF;

Line 2743: RAISE FND_API.G_EXC_ERROR;

2739: 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);
2740: END IF;
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2742: FND_MSG_PUB.ADD;
2743: RAISE FND_API.G_EXC_ERROR;
2744: ELSE
2745: push_eval;
2746: RETURN;
2747: END IF;

Line 2854: RAISE FND_API.G_EXC_ERROR;

2850: 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);
2851: END IF;
2852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2853: FND_MSG_PUB.ADD;
2854: RAISE FND_API.G_EXC_ERROR;
2855: ELSE
2856: push_eval;
2857: RETURN;
2858: END IF;

Line 3079: RAISE FND_API.G_EXC_ERROR;

3075: 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);
3076: END IF;
3077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3078: FND_MSG_PUB.ADD;
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081: ELSE
3082: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3083: 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 3087: RAISE FND_API.G_EXC_ERROR;

3083: 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);
3084: END IF;
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3086: FND_MSG_PUB.ADD;
3087: RAISE FND_API.G_EXC_ERROR;
3088: END IF;
3089: END IF;
3090: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3091: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3286: WHEN FND_API.G_EXC_ERROR THEN

3282: END IF;
3283: EXCEPTION
3284: WHEN L_RETURN_IMM_EXC THEN
3285: RETURN;
3286: WHEN FND_API.G_EXC_ERROR THEN
3287: RAISE FND_API.G_EXC_ERROR;
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3290: WHEN OTHERS THEN

Line 3287: RAISE FND_API.G_EXC_ERROR;

3283: EXCEPTION
3284: WHEN L_RETURN_IMM_EXC THEN
3285: RETURN;
3286: WHEN FND_API.G_EXC_ERROR THEN
3287: RAISE FND_API.G_EXC_ERROR;
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3290: WHEN OTHERS THEN
3291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3284: WHEN L_RETURN_IMM_EXC THEN
3285: RETURN;
3286: WHEN FND_API.G_EXC_ERROR THEN
3287: RAISE FND_API.G_EXC_ERROR;
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3290: WHEN OTHERS THEN
3291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');

Line 3289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3285: RETURN;
3286: WHEN FND_API.G_EXC_ERROR THEN
3287: RAISE FND_API.G_EXC_ERROR;
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3290: WHEN OTHERS THEN
3291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3294: FND_MSG_PUB.ADD;
3295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3296: END find_parties;
3297:
3298: PROCEDURE find_persons (
3299: p_rule_id IN NUMBER,

Line 3491: RAISE FND_API.G_EXC_ERROR;

3487: 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);
3488: END IF;
3489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3490: FND_MSG_PUB.ADD;
3491: RAISE FND_API.G_EXC_ERROR;
3492: ELSE
3493: push_eval;
3494: RETURN;
3495: END IF;

Line 3539: RAISE FND_API.G_EXC_ERROR;

3535: 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);
3536: END IF;
3537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3538: FND_MSG_PUB.ADD;
3539: RAISE FND_API.G_EXC_ERROR;
3540: ELSE
3541: push_eval;
3542: RETURN;
3543: END IF;

Line 3575: RAISE FND_API.G_EXC_ERROR;

3571: when others then
3572: if (instrb(SQLERRM,'DRG-51030')>0) then
3573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;
3576: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3578: FND_MSG_PUB.ADD;
3579: RAISE FND_API.G_EXC_ERROR;

Line 3579: RAISE FND_API.G_EXC_ERROR;

3575: RAISE FND_API.G_EXC_ERROR;
3576: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3578: FND_MSG_PUB.ADD;
3579: RAISE FND_API.G_EXC_ERROR;
3580: else
3581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3582: end if;
3583: END;

Line 3581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3578: FND_MSG_PUB.ADD;
3579: RAISE FND_API.G_EXC_ERROR;
3580: else
3581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3582: end if;
3583: END;
3584:
3585: /** Private procedure to acquire and score at party site level ***/

Line 3651: RAISE FND_API.G_EXC_ERROR;

3647: 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);
3648: END IF;
3649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3650: FND_MSG_PUB.ADD;
3651: RAISE FND_API.G_EXC_ERROR;
3652: ELSE
3653: push_eval;
3654: RETURN;
3655: END IF;

Line 3910: RAISE FND_API.G_EXC_ERROR;

3906: 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);
3907: END IF;
3908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3909: FND_MSG_PUB.ADD;
3910: RAISE FND_API.G_EXC_ERROR;
3911: ELSE
3912: push_eval;
3913: RETURN;
3914: END IF;

Line 4023: RAISE FND_API.G_EXC_ERROR;

4019: 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);
4020: END IF;
4021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4022: FND_MSG_PUB.ADD;
4023: RAISE FND_API.G_EXC_ERROR;
4024: END IF;
4025: ELSE
4026: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4027: 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 4031: RAISE FND_API.G_EXC_ERROR;

4027: 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);
4028: END IF;
4029: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4030: FND_MSG_PUB.ADD;
4031: RAISE FND_API.G_EXC_ERROR;
4032: END IF;
4033: END IF;
4034: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4035: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4145: WHEN FND_API.G_EXC_ERROR THEN

4141: END IF;
4142: EXCEPTION
4143: WHEN L_RETURN_IMM_EXC THEN
4144: RETURN;
4145: WHEN FND_API.G_EXC_ERROR THEN
4146: RAISE FND_API.G_EXC_ERROR;
4147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: WHEN OTHERS THEN

Line 4146: RAISE FND_API.G_EXC_ERROR;

4142: EXCEPTION
4143: WHEN L_RETURN_IMM_EXC THEN
4144: RETURN;
4145: WHEN FND_API.G_EXC_ERROR THEN
4146: RAISE FND_API.G_EXC_ERROR;
4147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: WHEN OTHERS THEN
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4143: WHEN L_RETURN_IMM_EXC THEN
4144: RETURN;
4145: WHEN FND_API.G_EXC_ERROR THEN
4146: RAISE FND_API.G_EXC_ERROR;
4147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: WHEN OTHERS THEN
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');

Line 4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4144: RETURN;
4145: WHEN FND_API.G_EXC_ERROR THEN
4146: RAISE FND_API.G_EXC_ERROR;
4147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: WHEN OTHERS THEN
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4213: WHEN FND_API.G_EXC_ERROR THEN

4209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4210: 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);
4211: END IF;
4212: EXCEPTION
4213: WHEN FND_API.G_EXC_ERROR THEN
4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN

Line 4214: RAISE FND_API.G_EXC_ERROR;

4210: 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);
4211: END IF;
4212: EXCEPTION
4213: WHEN FND_API.G_EXC_ERROR THEN
4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4211: END IF;
4212: EXCEPTION
4213: WHEN FND_API.G_EXC_ERROR THEN
4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');

Line 4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4212: EXCEPTION
4213: WHEN FND_API.G_EXC_ERROR THEN
4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4221: FND_MSG_PUB.ADD;
4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4223: END find_party_details;
4224:
4225: PROCEDURE find_duplicate_parties (
4226: p_rule_id IN NUMBER,

Line 4330: WHEN FND_API.G_EXC_ERROR THEN

4326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4327: 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);
4328: END IF;
4329: EXCEPTION
4330: WHEN FND_API.G_EXC_ERROR THEN
4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN

Line 4331: RAISE FND_API.G_EXC_ERROR;

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

Line 4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4328: END IF;
4329: EXCEPTION
4330: WHEN FND_API.G_EXC_ERROR THEN
4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');

Line 4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4329: EXCEPTION
4330: WHEN FND_API.G_EXC_ERROR THEN
4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4340: END find_duplicate_parties;
4341:
4342: PROCEDURE find_duplicate_party_sites (
4343: p_rule_id IN NUMBER,

Line 4415: WHEN FND_API.G_EXC_ERROR THEN

4411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4412: 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);
4413: END IF;
4414: EXCEPTION
4415: WHEN FND_API.G_EXC_ERROR THEN
4416: RAISE FND_API.G_EXC_ERROR;
4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: WHEN OTHERS THEN

Line 4416: RAISE FND_API.G_EXC_ERROR;

4412: 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);
4413: END IF;
4414: EXCEPTION
4415: WHEN FND_API.G_EXC_ERROR THEN
4416: RAISE FND_API.G_EXC_ERROR;
4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: WHEN OTHERS THEN
4420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4413: END IF;
4414: EXCEPTION
4415: WHEN FND_API.G_EXC_ERROR THEN
4416: RAISE FND_API.G_EXC_ERROR;
4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: WHEN OTHERS THEN
4420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4421: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');

Line 4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4414: EXCEPTION
4415: WHEN FND_API.G_EXC_ERROR THEN
4416: RAISE FND_API.G_EXC_ERROR;
4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: WHEN OTHERS THEN
4420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4421: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');
4422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4421: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');
4422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4423: FND_MSG_PUB.ADD;
4424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4425: END find_duplicate_party_sites;
4426:
4427: PROCEDURE find_duplicate_contacts (
4428: p_rule_id IN NUMBER,

Line 4504: WHEN FND_API.G_EXC_ERROR THEN

4500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4501: 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);
4502: END IF;
4503: EXCEPTION
4504: WHEN FND_API.G_EXC_ERROR THEN
4505: RAISE FND_API.G_EXC_ERROR;
4506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4508: WHEN OTHERS THEN

Line 4505: RAISE FND_API.G_EXC_ERROR;

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

Line 4506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4502: END IF;
4503: EXCEPTION
4504: WHEN FND_API.G_EXC_ERROR THEN
4505: RAISE FND_API.G_EXC_ERROR;
4506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4508: WHEN OTHERS THEN
4509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4510: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');

Line 4507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4503: EXCEPTION
4504: WHEN FND_API.G_EXC_ERROR THEN
4505: RAISE FND_API.G_EXC_ERROR;
4506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4508: WHEN OTHERS THEN
4509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4510: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4511: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4510: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4511: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4512: FND_MSG_PUB.ADD;
4513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4514: END find_duplicate_contacts;
4515:
4516: PROCEDURE find_duplicate_contact_points (
4517: p_rule_id IN NUMBER,

Line 4577: WHEN FND_API.G_EXC_ERROR THEN

4573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4574: 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);
4575: END IF;
4576: EXCEPTION
4577: WHEN FND_API.G_EXC_ERROR THEN
4578: RAISE FND_API.G_EXC_ERROR;
4579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4581: WHEN OTHERS THEN

Line 4578: RAISE FND_API.G_EXC_ERROR;

4574: 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);
4575: END IF;
4576: EXCEPTION
4577: WHEN FND_API.G_EXC_ERROR THEN
4578: RAISE FND_API.G_EXC_ERROR;
4579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4581: WHEN OTHERS THEN
4582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4575: END IF;
4576: EXCEPTION
4577: WHEN FND_API.G_EXC_ERROR THEN
4578: RAISE FND_API.G_EXC_ERROR;
4579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4581: WHEN OTHERS THEN
4582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4583: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');

Line 4580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4576: EXCEPTION
4577: WHEN FND_API.G_EXC_ERROR THEN
4578: RAISE FND_API.G_EXC_ERROR;
4579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4581: WHEN OTHERS THEN
4582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4583: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');
4584: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4583: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');
4584: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4585: FND_MSG_PUB.ADD;
4586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4587: END find_duplicate_contact_points;
4588:
4589: PROCEDURE find_parties_dynamic (
4590: p_rule_id IN NUMBER,

Line 4865: WHEN FND_API.G_EXC_ERROR THEN

4861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4862: 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);
4863: END IF;
4864: EXCEPTION
4865: WHEN FND_API.G_EXC_ERROR THEN
4866: RAISE FND_API.G_EXC_ERROR;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN

Line 4866: RAISE FND_API.G_EXC_ERROR;

4862: 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);
4863: END IF;
4864: EXCEPTION
4865: WHEN FND_API.G_EXC_ERROR THEN
4866: RAISE FND_API.G_EXC_ERROR;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4863: END IF;
4864: EXCEPTION
4865: WHEN FND_API.G_EXC_ERROR THEN
4866: RAISE FND_API.G_EXC_ERROR;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');

Line 4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4864: EXCEPTION
4865: WHEN FND_API.G_EXC_ERROR THEN
4866: RAISE FND_API.G_EXC_ERROR;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4875: END call_api_dynamic;
4876:
4877:
4878: PROCEDURE get_matching_party_sites (

Line 5103: WHEN FND_API.G_EXC_ERROR THEN

5099: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5100: 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);
5101: END IF;
5102: EXCEPTION
5103: WHEN FND_API.G_EXC_ERROR THEN
5104: RAISE FND_API.G_EXC_ERROR;
5105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: WHEN OTHERS THEN

Line 5104: RAISE FND_API.G_EXC_ERROR;

5100: 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);
5101: END IF;
5102: EXCEPTION
5103: WHEN FND_API.G_EXC_ERROR THEN
5104: RAISE FND_API.G_EXC_ERROR;
5105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: WHEN OTHERS THEN
5108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5101: END IF;
5102: EXCEPTION
5103: WHEN FND_API.G_EXC_ERROR THEN
5104: RAISE FND_API.G_EXC_ERROR;
5105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: WHEN OTHERS THEN
5108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5109: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');

Line 5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5102: EXCEPTION
5103: WHEN FND_API.G_EXC_ERROR THEN
5104: RAISE FND_API.G_EXC_ERROR;
5105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: WHEN OTHERS THEN
5108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5109: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5109: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5111: FND_MSG_PUB.ADD;
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: END get_matching_party_sites;
5114:
5115:
5116: PROCEDURE get_matching_contacts (

Line 5328: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5329: RAISE FND_API.G_EXC_ERROR;

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

Line 5330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5326: END IF;
5327: EXCEPTION
5328: WHEN FND_API.G_EXC_ERROR THEN
5329: RAISE FND_API.G_EXC_ERROR;
5330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5332: WHEN OTHERS THEN
5333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');

Line 5331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5327: EXCEPTION
5328: WHEN FND_API.G_EXC_ERROR THEN
5329: RAISE FND_API.G_EXC_ERROR;
5330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5332: WHEN OTHERS THEN
5333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5336: FND_MSG_PUB.ADD;
5337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5338: END get_matching_contacts;
5339:
5340:
5341: PROCEDURE get_matching_contact_points (

Line 5467: WHEN FND_API.G_EXC_ERROR THEN

5463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5464: 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);
5465: END IF;
5466: EXCEPTION
5467: WHEN FND_API.G_EXC_ERROR THEN
5468: RAISE FND_API.G_EXC_ERROR;
5469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5471: WHEN OTHERS THEN

Line 5468: RAISE FND_API.G_EXC_ERROR;

5464: 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);
5465: END IF;
5466: EXCEPTION
5467: WHEN FND_API.G_EXC_ERROR THEN
5468: RAISE FND_API.G_EXC_ERROR;
5469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5471: WHEN OTHERS THEN
5472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5465: END IF;
5466: EXCEPTION
5467: WHEN FND_API.G_EXC_ERROR THEN
5468: RAISE FND_API.G_EXC_ERROR;
5469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5471: WHEN OTHERS THEN
5472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5473: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');

Line 5470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5466: EXCEPTION
5467: WHEN FND_API.G_EXC_ERROR THEN
5468: RAISE FND_API.G_EXC_ERROR;
5469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5471: WHEN OTHERS THEN
5472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5473: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5473: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5475: FND_MSG_PUB.ADD;
5476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5477: END get_matching_contact_points;
5478:
5479: /**********************************************************
5480: This procedure finds the score details for a specific party that

Line 5686: WHEN FND_API.G_EXC_ERROR THEN

5682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5683: 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);
5684: END IF;
5685: EXCEPTION
5686: WHEN FND_API.G_EXC_ERROR THEN
5687: RAISE FND_API.G_EXC_ERROR;
5688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: WHEN OTHERS THEN

Line 5687: RAISE FND_API.G_EXC_ERROR;

5683: 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);
5684: END IF;
5685: EXCEPTION
5686: WHEN FND_API.G_EXC_ERROR THEN
5687: RAISE FND_API.G_EXC_ERROR;
5688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: WHEN OTHERS THEN
5691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5684: END IF;
5685: EXCEPTION
5686: WHEN FND_API.G_EXC_ERROR THEN
5687: RAISE FND_API.G_EXC_ERROR;
5688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: WHEN OTHERS THEN
5691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');

Line 5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5685: EXCEPTION
5686: WHEN FND_API.G_EXC_ERROR THEN
5687: RAISE FND_API.G_EXC_ERROR;
5688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: WHEN OTHERS THEN
5691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5694: FND_MSG_PUB.ADD;
5695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5696: END get_score_details;
5697:
5698:
5699: /************************************************

Line 5764: WHEN FND_API.G_EXC_ERROR THEN

5760: END LOOP;
5761: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5762: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5763: EXCEPTION
5764: WHEN FND_API.G_EXC_ERROR THEN
5765: RAISE FND_API.G_EXC_ERROR;
5766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: WHEN OTHERS THEN

Line 5765: RAISE FND_API.G_EXC_ERROR;

5761: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5762: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5763: EXCEPTION
5764: WHEN FND_API.G_EXC_ERROR THEN
5765: RAISE FND_API.G_EXC_ERROR;
5766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: WHEN OTHERS THEN
5769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5762: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5763: EXCEPTION
5764: WHEN FND_API.G_EXC_ERROR THEN
5765: RAISE FND_API.G_EXC_ERROR;
5766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: WHEN OTHERS THEN
5769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5770: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5763: EXCEPTION
5764: WHEN FND_API.G_EXC_ERROR THEN
5765: RAISE FND_API.G_EXC_ERROR;
5766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: WHEN OTHERS THEN
5769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5770: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5770: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5772: FND_MSG_PUB.ADD;
5773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5774: END get_party_for_search;
5775:
5776: PROCEDURE get_search_criteria (
5777: p_party_id IN NUMBER,

Line 5804: WHEN FND_API.G_EXC_ERROR THEN

5800: END IF;
5801: get_party_site_rec(p_party_site_ids, x_party_site_list);
5802: END IF;
5803: EXCEPTION
5804: WHEN FND_API.G_EXC_ERROR THEN
5805: RAISE FND_API.G_EXC_ERROR;
5806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5808: WHEN OTHERS THEN

Line 5805: RAISE FND_API.G_EXC_ERROR;

5801: get_party_site_rec(p_party_site_ids, x_party_site_list);
5802: END IF;
5803: EXCEPTION
5804: WHEN FND_API.G_EXC_ERROR THEN
5805: RAISE FND_API.G_EXC_ERROR;
5806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5808: WHEN OTHERS THEN
5809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5878: RAISE FND_API.G_EXC_ERROR;

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

Line 5938: RAISE FND_API.G_EXC_ERROR;

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

Line 5994: RAISE FND_API.G_EXC_ERROR;

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

Line 6046: RAISE FND_API.G_EXC_ERROR;

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

Line 6199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6195: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6196: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6200: END;
6201:
6202:
6203: /************************************************

Line 6362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6358: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6359: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6360: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6361: FND_MSG_PUB.ADD;
6362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6363: END;
6364:
6365:
6366: /************************************************

Line 6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6400: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END;
6406:
6407:
6408: /************************************************

Line 6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6467: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6472: END;
6473:
6474:
6475: /************************************************

Line 6523: WHEN FND_API.G_EXC_ERROR THEN

6519: END IF;
6520: END LOOP;
6521: RETURN FALSE;
6522: EXCEPTION
6523: WHEN FND_API.G_EXC_ERROR THEN
6524: RAISE FND_API.G_EXC_ERROR;
6525: WHEN OTHERS THEN
6526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6527: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6524: RAISE FND_API.G_EXC_ERROR;

6520: END LOOP;
6521: RETURN FALSE;
6522: EXCEPTION
6523: WHEN FND_API.G_EXC_ERROR THEN
6524: RAISE FND_API.G_EXC_ERROR;
6525: WHEN OTHERS THEN
6526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6527: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6527: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6529: FND_MSG_PUB.ADD;
6530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6531: END check_prim_cond;
6532:
6533: /************************************************
6534: This procedure checks if the input search condition

Line 6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6577: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6581: END check_party_site_cond;
6582:
6583: /************************************************
6584: This procedure checks if the input search condition

Line 6618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6614: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6615: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6616: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6617: FND_MSG_PUB.ADD;
6618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6619: END check_contact_cond;
6620:
6621: /************************************************
6622: This procedure checks if the input search condition

Line 6639: RAISE FND_API.G_EXC_ERROR;

6635: FOR I IN 1..p_contact_point_list.COUNT LOOP
6636: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6637: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6638: FND_MSG_PUB.ADD;
6639: RAISE FND_API.G_EXC_ERROR;
6640: END IF;
6641: END LOOP;
6642:
6643: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6652: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6656: END check_contact_point_cond;
6657:
6658: FUNCTION check_staged RETURN BOOLEAN IS
6659: