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_34 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 1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1405: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END;
1410:
1411:
1412: /************************************************

Line 1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1430: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END;
1435:
1436:
1437: /************************************************

Line 1453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1449: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1450: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1454: END;
1455:
1456:
1457: /************************************************

Line 1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1469: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1471: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END;
1475:
1476: PROCEDURE init_score_context (
1477: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: p_contact_list,
1537: p_contact_point_list) THEN
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1543: 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);
1544: END IF;

Line 1930: RAISE FND_API.G_EXC_ERROR;

1926: IF lengthb(l_party_contains_str) > 4000 THEN
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1928: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1929: FND_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_ERROR;
1931: END IF;
1932: IF (p_match_str = ' AND ' OR p_party_max_score 1933: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1934: 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 2042: RAISE FND_API.G_EXC_ERROR;

2038: IF lengthb(l_contains_str) > 4000 THEN
2039: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2040: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044: x_denorm_str := l_den_contains_str;
2045: RETURN l_contains_str;
2046: END;

Line 2132: RAISE FND_API.G_EXC_ERROR;

2128: IF lengthb(l_contains_str) > 4000 THEN
2129: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2130: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134: x_denorm_str := l_den_contains_str;
2135: RETURN l_contains_str;
2136: END;

Line 2467: RAISE FND_API.G_EXC_ERROR;

2463: when others then
2464: if (instrb(SQLERRM,'DRG-51030')>0) then
2465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2470: FND_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;

Line 2471: RAISE FND_API.G_EXC_ERROR;

2467: RAISE FND_API.G_EXC_ERROR;
2468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2470: FND_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;
2472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2474: FND_MSG_PUB.ADD;
2475: RAISE FND_API.G_EXC_ERROR;

Line 2475: RAISE FND_API.G_EXC_ERROR;

2471: RAISE FND_API.G_EXC_ERROR;
2472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2474: FND_MSG_PUB.ADD;
2475: RAISE FND_API.G_EXC_ERROR;
2476: else
2477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2479: FND_MSG_PUB.ADD;

Line 2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2476: else
2477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2479: FND_MSG_PUB.ADD;
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: end if;
2482: END;
2483:
2484: PROCEDURE open_party_site_cursor(

Line 2712: RAISE FND_API.G_EXC_ERROR;

2708: when others then
2709: if (instrb(SQLERRM,'DRG-51030')>0) then
2710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2711: FND_MSG_PUB.ADD;
2712: RAISE FND_API.G_EXC_ERROR;
2713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;

Line 2716: RAISE FND_API.G_EXC_ERROR;

2712: RAISE FND_API.G_EXC_ERROR;
2713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2719: FND_MSG_PUB.ADD;
2720: RAISE FND_API.G_EXC_ERROR;

Line 2720: RAISE FND_API.G_EXC_ERROR;

2716: RAISE FND_API.G_EXC_ERROR;
2717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2719: FND_MSG_PUB.ADD;
2720: RAISE FND_API.G_EXC_ERROR;
2721: else
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2724: FND_MSG_PUB.ADD;

Line 2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2721: else
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2724: FND_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: end if;
2727: END;
2728:
2729: PROCEDURE open_contact_cursor(

Line 2859: RAISE FND_API.G_EXC_ERROR;

2855: when others then
2856: if (instrb(SQLERRM,'DRG-51030')>0) then
2857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2858: FND_MSG_PUB.ADD;
2859: RAISE FND_API.G_EXC_ERROR;
2860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_ERROR;

Line 2863: RAISE FND_API.G_EXC_ERROR;

2859: RAISE FND_API.G_EXC_ERROR;
2860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_ERROR;
2864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2866: FND_MSG_PUB.ADD;
2867: RAISE FND_API.G_EXC_ERROR;

Line 2867: RAISE FND_API.G_EXC_ERROR;

2863: RAISE FND_API.G_EXC_ERROR;
2864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2866: FND_MSG_PUB.ADD;
2867: RAISE FND_API.G_EXC_ERROR;
2868: else
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2871: FND_MSG_PUB.ADD;

Line 2872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2868: else
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2871: FND_MSG_PUB.ADD;
2872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2873: end if;
2874: END;
2875:
2876: PROCEDURE open_contact_pt_cursor(

Line 3132: RAISE FND_API.G_EXC_ERROR;

3128: when others then
3129: if (instrb(SQLERRM,'DRG-51030')>0) then
3130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3131: FND_MSG_PUB.ADD;
3132: RAISE FND_API.G_EXC_ERROR;
3133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3135: FND_MSG_PUB.ADD;
3136: RAISE FND_API.G_EXC_ERROR;

Line 3136: RAISE FND_API.G_EXC_ERROR;

3132: RAISE FND_API.G_EXC_ERROR;
3133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3135: FND_MSG_PUB.ADD;
3136: RAISE FND_API.G_EXC_ERROR;
3137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3139: FND_MSG_PUB.ADD;
3140: RAISE FND_API.G_EXC_ERROR;

Line 3140: RAISE FND_API.G_EXC_ERROR;

3136: RAISE FND_API.G_EXC_ERROR;
3137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3139: FND_MSG_PUB.ADD;
3140: RAISE FND_API.G_EXC_ERROR;
3141: else
3142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3144: FND_MSG_PUB.ADD;

Line 3145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3141: else
3142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3146: end if;
3147: END;
3148:
3149:

Line 3415: RAISE FND_API.G_EXC_ERROR;

3411: 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);
3412: END IF;
3413: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3414: FND_MSG_PUB.ADD;
3415: RAISE FND_API.G_EXC_ERROR;
3416: ELSE
3417: push_eval;
3418: RETURN;
3419: END IF;

Line 3465: RAISE FND_API.G_EXC_ERROR;

3461: 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);
3462: END IF;
3463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3464: FND_MSG_PUB.ADD;
3465: RAISE FND_API.G_EXC_ERROR;
3466: ELSE
3467: push_eval;
3468: RETURN;
3469: END IF;

Line 3538: RAISE FND_API.G_EXC_ERROR;

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

Line 3650: RAISE FND_API.G_EXC_ERROR;

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

Line 3761: RAISE FND_API.G_EXC_ERROR;

3757: 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);
3758: END IF;
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3760: FND_MSG_PUB.ADD;
3761: RAISE FND_API.G_EXC_ERROR;
3762: ELSE
3763: push_eval;
3764: RETURN;
3765: END IF;

Line 3986: RAISE FND_API.G_EXC_ERROR;

3982: 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);
3983: END IF;
3984: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3985: FND_MSG_PUB.ADD;
3986: RAISE FND_API.G_EXC_ERROR;
3987: END IF;
3988: ELSE
3989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3990: 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 3994: RAISE FND_API.G_EXC_ERROR;

3990: 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);
3991: END IF;
3992: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3993: FND_MSG_PUB.ADD;
3994: RAISE FND_API.G_EXC_ERROR;
3995: END IF;
3996: END IF;
3997: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3998: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4193: WHEN FND_API.G_EXC_ERROR THEN

4189: END IF;
4190: EXCEPTION
4191: WHEN L_RETURN_IMM_EXC THEN
4192: RETURN;
4193: WHEN FND_API.G_EXC_ERROR THEN
4194: RAISE FND_API.G_EXC_ERROR;
4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: WHEN OTHERS THEN

Line 4194: RAISE FND_API.G_EXC_ERROR;

4190: EXCEPTION
4191: WHEN L_RETURN_IMM_EXC THEN
4192: RETURN;
4193: WHEN FND_API.G_EXC_ERROR THEN
4194: RAISE FND_API.G_EXC_ERROR;
4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: WHEN OTHERS THEN
4198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4191: WHEN L_RETURN_IMM_EXC THEN
4192: RETURN;
4193: WHEN FND_API.G_EXC_ERROR THEN
4194: RAISE FND_API.G_EXC_ERROR;
4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: WHEN OTHERS THEN
4198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4199: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');

Line 4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4192: RETURN;
4193: WHEN FND_API.G_EXC_ERROR THEN
4194: RAISE FND_API.G_EXC_ERROR;
4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: WHEN OTHERS THEN
4198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4199: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4199: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4201: FND_MSG_PUB.ADD;
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4203: END find_parties;
4204:
4205: PROCEDURE find_persons (
4206: p_rule_id IN NUMBER,

Line 4412: RAISE FND_API.G_EXC_ERROR;

4408: 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);
4409: END IF;
4410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4411: FND_MSG_PUB.ADD;
4412: RAISE FND_API.G_EXC_ERROR;
4413: ELSE
4414: push_eval;
4415: RETURN;
4416: END IF;

Line 4462: RAISE FND_API.G_EXC_ERROR;

4458: 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);
4459: END IF;
4460: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4461: FND_MSG_PUB.ADD;
4462: RAISE FND_API.G_EXC_ERROR;
4463: ELSE
4464: push_eval;
4465: RETURN;
4466: END IF;

Line 4498: RAISE FND_API.G_EXC_ERROR;

4494: when others then
4495: if (instrb(SQLERRM,'DRG-51030')>0) then
4496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4497: FND_MSG_PUB.ADD;
4498: RAISE FND_API.G_EXC_ERROR;
4499: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4501: FND_MSG_PUB.ADD;
4502: RAISE FND_API.G_EXC_ERROR;

Line 4502: RAISE FND_API.G_EXC_ERROR;

4498: RAISE FND_API.G_EXC_ERROR;
4499: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4501: FND_MSG_PUB.ADD;
4502: RAISE FND_API.G_EXC_ERROR;
4503: else
4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4505: end if;
4506: END;

Line 4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4501: FND_MSG_PUB.ADD;
4502: RAISE FND_API.G_EXC_ERROR;
4503: else
4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4505: end if;
4506: END;
4507:
4508: /** Private procedure to acquire and score at party site level ***/

Line 4574: RAISE FND_API.G_EXC_ERROR;

4570: 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);
4571: END IF;
4572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4573: FND_MSG_PUB.ADD;
4574: RAISE FND_API.G_EXC_ERROR;
4575: ELSE
4576: push_eval;
4577: RETURN;
4578: END IF;

Line 4833: RAISE FND_API.G_EXC_ERROR;

4829: 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);
4830: END IF;
4831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4832: FND_MSG_PUB.ADD;
4833: RAISE FND_API.G_EXC_ERROR;
4834: ELSE
4835: push_eval;
4836: RETURN;
4837: END IF;

Line 4946: RAISE FND_API.G_EXC_ERROR;

4942: 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);
4943: END IF;
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4945: FND_MSG_PUB.ADD;
4946: RAISE FND_API.G_EXC_ERROR;
4947: END IF;
4948: ELSE
4949: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4950: 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 4954: RAISE FND_API.G_EXC_ERROR;

4950: 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);
4951: END IF;
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_ERROR;
4955: END IF;
4956: END IF;
4957: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4958: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 5068: WHEN FND_API.G_EXC_ERROR THEN

5064: END IF;
5065: EXCEPTION
5066: WHEN L_RETURN_IMM_EXC THEN
5067: RETURN;
5068: WHEN FND_API.G_EXC_ERROR THEN
5069: RAISE FND_API.G_EXC_ERROR;
5070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5072: WHEN OTHERS THEN

Line 5069: RAISE FND_API.G_EXC_ERROR;

5065: EXCEPTION
5066: WHEN L_RETURN_IMM_EXC THEN
5067: RETURN;
5068: WHEN FND_API.G_EXC_ERROR THEN
5069: RAISE FND_API.G_EXC_ERROR;
5070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5072: WHEN OTHERS THEN
5073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5066: WHEN L_RETURN_IMM_EXC THEN
5067: RETURN;
5068: WHEN FND_API.G_EXC_ERROR THEN
5069: RAISE FND_API.G_EXC_ERROR;
5070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5072: WHEN OTHERS THEN
5073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5074: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');

Line 5071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5067: RETURN;
5068: WHEN FND_API.G_EXC_ERROR THEN
5069: RAISE FND_API.G_EXC_ERROR;
5070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5072: WHEN OTHERS THEN
5073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5074: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5075: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5074: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5075: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5076: FND_MSG_PUB.ADD;
5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5078: END find_persons;
5079:
5080: PROCEDURE find_persons (
5081: p_rule_id IN NUMBER,

Line 5136: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5137: RAISE FND_API.G_EXC_ERROR;

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

Line 5138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5134: END IF;
5135: EXCEPTION
5136: WHEN FND_API.G_EXC_ERROR THEN
5137: RAISE FND_API.G_EXC_ERROR;
5138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5140: WHEN OTHERS THEN
5141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5142: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');

Line 5139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5135: EXCEPTION
5136: WHEN FND_API.G_EXC_ERROR THEN
5137: RAISE FND_API.G_EXC_ERROR;
5138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5140: WHEN OTHERS THEN
5141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5142: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5142: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5144: FND_MSG_PUB.ADD;
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: END find_party_details;
5147:
5148: PROCEDURE find_duplicate_parties (
5149: p_rule_id IN NUMBER,

Line 5253: WHEN FND_API.G_EXC_ERROR THEN

5249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5250: 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);
5251: END IF;
5252: EXCEPTION
5253: WHEN FND_API.G_EXC_ERROR THEN
5254: RAISE FND_API.G_EXC_ERROR;
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN

Line 5254: RAISE FND_API.G_EXC_ERROR;

5250: 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);
5251: END IF;
5252: EXCEPTION
5253: WHEN FND_API.G_EXC_ERROR THEN
5254: RAISE FND_API.G_EXC_ERROR;
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END find_duplicate_parties;
5264:
5265: PROCEDURE find_duplicate_party_sites (
5266: p_rule_id IN NUMBER,

Line 5338: WHEN FND_API.G_EXC_ERROR THEN

5334: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5335: 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);
5336: END IF;
5337: EXCEPTION
5338: WHEN FND_API.G_EXC_ERROR THEN
5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN

Line 5339: RAISE FND_API.G_EXC_ERROR;

5335: 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);
5336: END IF;
5337: EXCEPTION
5338: WHEN FND_API.G_EXC_ERROR THEN
5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5336: END IF;
5337: EXCEPTION
5338: WHEN FND_API.G_EXC_ERROR THEN
5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');

Line 5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5337: EXCEPTION
5338: WHEN FND_API.G_EXC_ERROR THEN
5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5348: END find_duplicate_party_sites;
5349:
5350: PROCEDURE find_duplicate_contacts (
5351: p_rule_id IN NUMBER,

Line 5427: WHEN FND_API.G_EXC_ERROR THEN

5423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5424: 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);
5425: END IF;
5426: EXCEPTION
5427: WHEN FND_API.G_EXC_ERROR THEN
5428: RAISE FND_API.G_EXC_ERROR;
5429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: WHEN OTHERS THEN

Line 5428: RAISE FND_API.G_EXC_ERROR;

5424: 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);
5425: END IF;
5426: EXCEPTION
5427: WHEN FND_API.G_EXC_ERROR THEN
5428: RAISE FND_API.G_EXC_ERROR;
5429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: WHEN OTHERS THEN
5432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5425: END IF;
5426: EXCEPTION
5427: WHEN FND_API.G_EXC_ERROR THEN
5428: RAISE FND_API.G_EXC_ERROR;
5429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: WHEN OTHERS THEN
5432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');

Line 5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5426: EXCEPTION
5427: WHEN FND_API.G_EXC_ERROR THEN
5428: RAISE FND_API.G_EXC_ERROR;
5429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: WHEN OTHERS THEN
5432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5435: FND_MSG_PUB.ADD;
5436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5437: END find_duplicate_contacts;
5438:
5439: PROCEDURE find_duplicate_contact_points (
5440: p_rule_id IN NUMBER,

Line 5500: WHEN FND_API.G_EXC_ERROR THEN

5496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5497: 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);
5498: END IF;
5499: EXCEPTION
5500: WHEN FND_API.G_EXC_ERROR THEN
5501: RAISE FND_API.G_EXC_ERROR;
5502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5504: WHEN OTHERS THEN

Line 5501: RAISE FND_API.G_EXC_ERROR;

5497: 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);
5498: END IF;
5499: EXCEPTION
5500: WHEN FND_API.G_EXC_ERROR THEN
5501: RAISE FND_API.G_EXC_ERROR;
5502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5504: WHEN OTHERS THEN
5505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5498: END IF;
5499: EXCEPTION
5500: WHEN FND_API.G_EXC_ERROR THEN
5501: RAISE FND_API.G_EXC_ERROR;
5502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5504: WHEN OTHERS THEN
5505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');

Line 5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5499: EXCEPTION
5500: WHEN FND_API.G_EXC_ERROR THEN
5501: RAISE FND_API.G_EXC_ERROR;
5502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5504: WHEN OTHERS THEN
5505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5510: END find_duplicate_contact_points;
5511:
5512: PROCEDURE find_parties_dynamic (
5513: p_rule_id IN NUMBER,

Line 5930: WHEN FND_API.G_EXC_ERROR THEN

5926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5927: 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);
5928: END IF;
5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN

Line 5931: RAISE FND_API.G_EXC_ERROR;

5927: 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);
5928: END IF;
5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5928: END IF;
5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');

Line 5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5940: END call_api_dynamic;
5941:
5942:
5943: PROCEDURE get_matching_party_sites (

Line 6174: WHEN FND_API.G_EXC_ERROR THEN

6170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6171: 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);
6172: END IF;
6173: EXCEPTION
6174: WHEN FND_API.G_EXC_ERROR THEN
6175: RAISE FND_API.G_EXC_ERROR;
6176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: WHEN OTHERS THEN

Line 6175: RAISE FND_API.G_EXC_ERROR;

6171: 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);
6172: END IF;
6173: EXCEPTION
6174: WHEN FND_API.G_EXC_ERROR THEN
6175: RAISE FND_API.G_EXC_ERROR;
6176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: WHEN OTHERS THEN
6179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6172: END IF;
6173: EXCEPTION
6174: WHEN FND_API.G_EXC_ERROR THEN
6175: RAISE FND_API.G_EXC_ERROR;
6176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: WHEN OTHERS THEN
6179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6180: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');

Line 6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6173: EXCEPTION
6174: WHEN FND_API.G_EXC_ERROR THEN
6175: RAISE FND_API.G_EXC_ERROR;
6176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: WHEN OTHERS THEN
6179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6180: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6180: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6182: FND_MSG_PUB.ADD;
6183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6184: END get_matching_party_sites;
6185:
6186:
6187: PROCEDURE get_matching_contacts (

Line 6402: WHEN FND_API.G_EXC_ERROR THEN

6398: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6399: 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);
6400: END IF;
6401: EXCEPTION
6402: WHEN FND_API.G_EXC_ERROR THEN
6403: RAISE FND_API.G_EXC_ERROR;
6404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: WHEN OTHERS THEN

Line 6403: RAISE FND_API.G_EXC_ERROR;

6399: 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);
6400: END IF;
6401: EXCEPTION
6402: WHEN FND_API.G_EXC_ERROR THEN
6403: RAISE FND_API.G_EXC_ERROR;
6404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: WHEN OTHERS THEN
6407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6400: END IF;
6401: EXCEPTION
6402: WHEN FND_API.G_EXC_ERROR THEN
6403: RAISE FND_API.G_EXC_ERROR;
6404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: WHEN OTHERS THEN
6407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');

Line 6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6401: EXCEPTION
6402: WHEN FND_API.G_EXC_ERROR THEN
6403: RAISE FND_API.G_EXC_ERROR;
6404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: WHEN OTHERS THEN
6407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6412: END get_matching_contacts;
6413:
6414:
6415: PROCEDURE get_matching_contact_points (

Line 6544: WHEN FND_API.G_EXC_ERROR THEN

6540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6541: 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);
6542: END IF;
6543: EXCEPTION
6544: WHEN FND_API.G_EXC_ERROR THEN
6545: RAISE FND_API.G_EXC_ERROR;
6546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6548: WHEN OTHERS THEN

Line 6545: RAISE FND_API.G_EXC_ERROR;

6541: 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);
6542: END IF;
6543: EXCEPTION
6544: WHEN FND_API.G_EXC_ERROR THEN
6545: RAISE FND_API.G_EXC_ERROR;
6546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6548: WHEN OTHERS THEN
6549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6542: END IF;
6543: EXCEPTION
6544: WHEN FND_API.G_EXC_ERROR THEN
6545: RAISE FND_API.G_EXC_ERROR;
6546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6548: WHEN OTHERS THEN
6549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');

Line 6547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6543: EXCEPTION
6544: WHEN FND_API.G_EXC_ERROR THEN
6545: RAISE FND_API.G_EXC_ERROR;
6546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6548: WHEN OTHERS THEN
6549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');
6551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');
6551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6552: FND_MSG_PUB.ADD;
6553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6554: END get_matching_contact_points;
6555:
6556: /**********************************************************
6557: This procedure finds the score details for a specific party that

Line 6799: WHEN FND_API.G_EXC_ERROR THEN

6795: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6796: 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);
6797: END IF;
6798: EXCEPTION
6799: WHEN FND_API.G_EXC_ERROR THEN
6800: RAISE FND_API.G_EXC_ERROR;
6801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6803: WHEN OTHERS THEN

Line 6800: RAISE FND_API.G_EXC_ERROR;

6796: 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);
6797: END IF;
6798: EXCEPTION
6799: WHEN FND_API.G_EXC_ERROR THEN
6800: RAISE FND_API.G_EXC_ERROR;
6801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6803: WHEN OTHERS THEN
6804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6797: END IF;
6798: EXCEPTION
6799: WHEN FND_API.G_EXC_ERROR THEN
6800: RAISE FND_API.G_EXC_ERROR;
6801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6803: WHEN OTHERS THEN
6804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6805: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');

Line 6802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6798: EXCEPTION
6799: WHEN FND_API.G_EXC_ERROR THEN
6800: RAISE FND_API.G_EXC_ERROR;
6801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6803: WHEN OTHERS THEN
6804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6805: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6805: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6807: FND_MSG_PUB.ADD;
6808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6809: END get_score_details;
6810:
6811:
6812: /************************************************

Line 6909: WHEN FND_API.G_EXC_ERROR THEN

6905: END LOOP;
6906: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6907: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6908: EXCEPTION
6909: WHEN FND_API.G_EXC_ERROR THEN
6910: RAISE FND_API.G_EXC_ERROR;
6911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6913: WHEN OTHERS THEN

Line 6910: RAISE FND_API.G_EXC_ERROR;

6906: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6907: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6908: EXCEPTION
6909: WHEN FND_API.G_EXC_ERROR THEN
6910: RAISE FND_API.G_EXC_ERROR;
6911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6913: WHEN OTHERS THEN
6914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6907: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6908: EXCEPTION
6909: WHEN FND_API.G_EXC_ERROR THEN
6910: RAISE FND_API.G_EXC_ERROR;
6911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6913: WHEN OTHERS THEN
6914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6915: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6908: EXCEPTION
6909: WHEN FND_API.G_EXC_ERROR THEN
6910: RAISE FND_API.G_EXC_ERROR;
6911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6913: WHEN OTHERS THEN
6914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6915: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6916: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6915: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6916: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6917: FND_MSG_PUB.ADD;
6918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6919: END get_party_for_search;
6920:
6921: PROCEDURE get_search_criteria (
6922: p_party_id IN NUMBER,

Line 6955: WHEN FND_API.G_EXC_ERROR THEN

6951: END IF;
6952: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6953: END IF;
6954: EXCEPTION
6955: WHEN FND_API.G_EXC_ERROR THEN
6956: RAISE FND_API.G_EXC_ERROR;
6957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6959: WHEN OTHERS THEN

Line 6956: RAISE FND_API.G_EXC_ERROR;

6952: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6953: END IF;
6954: EXCEPTION
6955: WHEN FND_API.G_EXC_ERROR THEN
6956: RAISE FND_API.G_EXC_ERROR;
6957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6959: WHEN OTHERS THEN
6960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6953: END IF;
6954: EXCEPTION
6955: WHEN FND_API.G_EXC_ERROR THEN
6956: RAISE FND_API.G_EXC_ERROR;
6957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6959: WHEN OTHERS THEN
6960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6961: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6954: EXCEPTION
6955: WHEN FND_API.G_EXC_ERROR THEN
6956: RAISE FND_API.G_EXC_ERROR;
6957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6959: WHEN OTHERS THEN
6960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6961: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6961: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6963: FND_MSG_PUB.ADD;
6964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6965: END get_search_criteria;
6966:
6967:
6968: /************************************************

Line 7053: RAISE FND_API.G_EXC_ERROR;

7049: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7050: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7052: FND_MSG_PUB.ADD;
7053: RAISE FND_API.G_EXC_ERROR;
7054: END get_party_rec;
7055:
7056: /************************************************
7057: This procedure retrieves the match rule party site attributes into

Line 7117: RAISE FND_API.G_EXC_ERROR;

7113: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7114: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7116: FND_MSG_PUB.ADD;
7117: RAISE FND_API.G_EXC_ERROR;
7118: END get_party_site_rec;
7119:
7120: /************************************************
7121: This procedure retrieves the match rule contact attributes into

Line 7173: RAISE FND_API.G_EXC_ERROR;

7169: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7170: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7172: FND_MSG_PUB.ADD;
7173: RAISE FND_API.G_EXC_ERROR;
7174: END get_contact_rec;
7175:
7176: /************************************************
7177: This procedure retrieves the match rule contact point attributes into

Line 7231: RAISE FND_API.G_EXC_ERROR;

7227: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7228: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7230: FND_MSG_PUB.ADD;
7231: RAISE FND_API.G_EXC_ERROR;
7232: END get_contact_point_rec;
7233:
7234: /************************************************
7235: This procedure maps a search record from the logical

Line 7561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7557: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7558: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7560: FND_MSG_PUB.ADD;
7561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7562: END;
7563:
7564:
7565: /************************************************

Line 7768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7764: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7765: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7767: FND_MSG_PUB.ADD;
7768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7769: END;
7770:
7771:
7772: /************************************************

Line 7810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7806: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7807: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7809: FND_MSG_PUB.ADD;
7810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7811: END;
7812:
7813:
7814: /************************************************

Line 7954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7950: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7951: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7953: FND_MSG_PUB.ADD;
7954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7955: END;
7956:
7957:
7958: /************************************************

Line 7978: RAISE FND_API.G_EXC_ERROR;

7974: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7975: ) THEN
7976: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7977: FND_MSG_PUB.ADD;
7978: RAISE FND_API.G_EXC_ERROR;
7979: END IF;
7980: END LOOP;
7981:
7982: IF p_party_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN

Line 8052: WHEN FND_API.G_EXC_ERROR THEN

8048: END IF;
8049: END LOOP;
8050: RETURN FALSE;
8051: EXCEPTION
8052: WHEN FND_API.G_EXC_ERROR THEN
8053: RAISE FND_API.G_EXC_ERROR;
8054: WHEN OTHERS THEN
8055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8056: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 8053: RAISE FND_API.G_EXC_ERROR;

8049: END LOOP;
8050: RETURN FALSE;
8051: EXCEPTION
8052: WHEN FND_API.G_EXC_ERROR THEN
8053: RAISE FND_API.G_EXC_ERROR;
8054: WHEN OTHERS THEN
8055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8056: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8056: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8058: FND_MSG_PUB.ADD;
8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8060: END check_prim_cond;
8061:
8062: /************************************************
8063: This procedure checks if the input search condition

Line 8123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8120: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8121: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8122: FND_MSG_PUB.ADD;
8123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8124: END check_party_site_cond;
8125:
8126: /************************************************
8127: This procedure checks if the input search condition

Line 8171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8167: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8168: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8170: FND_MSG_PUB.ADD;
8171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8172: END check_contact_cond;
8173:
8174: /************************************************
8175: This procedure checks if the input search condition

Line 8192: RAISE FND_API.G_EXC_ERROR;

8188: FOR I IN 1..p_contact_point_list.COUNT LOOP
8189: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8190: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8191: FND_MSG_PUB.ADD;
8192: RAISE FND_API.G_EXC_ERROR;
8193: END IF;
8194: END LOOP;
8195:
8196: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 8218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8215: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8217: FND_MSG_PUB.ADD;
8218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8219: END check_contact_point_cond;
8220:
8221: FUNCTION check_staged RETURN BOOLEAN IS
8222: