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_5 dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

96:
97: exception
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');

Line 104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 478: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

474: BEGIN
475: NULL ;
476: EXCEPTION
477: WHEN OTHERS THEN
478: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
479: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 479: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');

475: NULL ;
476: EXCEPTION
477: WHEN OTHERS THEN
478: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
479: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END;

Line 480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

476: EXCEPTION
477: WHEN OTHERS THEN
478: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
479: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END;
484:

Line 498: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

494: BEGIN
495: NULL ;
496: EXCEPTION
497: WHEN OTHERS THEN
498: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
499: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
501: FND_MSG_PUB.ADD;
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 499: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');

495: NULL ;
496: EXCEPTION
497: WHEN OTHERS THEN
498: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
499: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
501: FND_MSG_PUB.ADD;
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END;

Line 500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

496: EXCEPTION
497: WHEN OTHERS THEN
498: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
499: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
501: FND_MSG_PUB.ADD;
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END;
504:

Line 518: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

514: BEGIN
515: NULL ;
516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
519: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
520: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
521: FND_MSG_PUB.ADD;
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 519: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');

515: NULL ;
516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
519: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
520: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
521: FND_MSG_PUB.ADD;
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END;

Line 520: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
519: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
520: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
521: FND_MSG_PUB.ADD;
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END;
524:

Line 538: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

534: BEGIN
535: NULL ;
536: EXCEPTION
537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
539: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 539: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');

535: NULL ;
536: EXCEPTION
537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
539: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: END;

Line 540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

536: EXCEPTION
537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
539: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: END;
544:

Line 607: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');

603: IF NOT check_prim_cond (p_party_search_rec,
604: p_party_site_list,
605: p_contact_list,
606: p_contact_point_list) THEN
607: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
608: FND_MSG_PUB.ADD;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 824: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

820: ELSE
821: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
822: END IF;
823: IF lengthb(l_party_contains_str) > 4000 THEN
824: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
825: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
826: FND_MSG_PUB.ADD;
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;

Line 825: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

821: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
822: END IF;
823: IF lengthb(l_party_contains_str) > 4000 THEN
824: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
825: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
826: FND_MSG_PUB.ADD;
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829: IF (p_match_str = ' AND ' OR p_party_max_score

Line 886: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

882: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
883: END LOOP;
884: -- Add the search criteria to query string
885: IF lengthb(l_contains_str) > 4000 THEN
886: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
887: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
888: FND_MSG_PUB.ADD;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;

Line 887: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');

883: END LOOP;
884: -- Add the search criteria to query string
885: IF lengthb(l_contains_str) > 4000 THEN
886: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
887: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
888: FND_MSG_PUB.ADD;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: x_denorm_str := l_den_contains_str;

Line 1136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1132: END IF;
1133: exception
1134: when others then
1135: if (instrb(SQLERRM,'DRG-51030')>0) then
1136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1137: FND_MSG_PUB.ADD;
1138: RAISE FND_API.G_EXC_ERROR;
1139: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1137: FND_MSG_PUB.ADD;
1138: RAISE FND_API.G_EXC_ERROR;
1139: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1141: FND_MSG_PUB.ADD;
1142: RAISE FND_API.G_EXC_ERROR;
1143: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1141: FND_MSG_PUB.ADD;
1142: RAISE FND_API.G_EXC_ERROR;
1143: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: else
1148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: else
1148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1150: FND_MSG_PUB.ADD;
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: end if;

Line 1149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: else
1148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1150: FND_MSG_PUB.ADD;
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: end if;
1153: END;

Line 1381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1377: output_long_strings('Restrict Sql = '||p_restrict_sql);
1378: exception
1379: when others then
1380: if (instrb(SQLERRM,'DRG-51030')>0) then
1381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1382: FND_MSG_PUB.ADD;
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1382: FND_MSG_PUB.ADD;
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1386: FND_MSG_PUB.ADD;
1387: RAISE FND_API.G_EXC_ERROR;
1388: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1389: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1389: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1386: FND_MSG_PUB.ADD;
1387: RAISE FND_API.G_EXC_ERROR;
1388: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1389: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_ERROR;
1392: else
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1393: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1389: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_ERROR;
1392: else
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1395: FND_MSG_PUB.ADD;
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: end if;

Line 1394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_ERROR;
1392: else
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1395: FND_MSG_PUB.ADD;
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: end if;
1398: END;

Line 1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1524: output_long_strings('Restrict Sql = '||p_restrict_sql);
1525: exception
1526: when others then
1527: if (instrb(SQLERRM,'DRG-51030')>0) then
1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_ERROR;
1531: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_ERROR;
1531: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1533: FND_MSG_PUB.ADD;
1534: RAISE FND_API.G_EXC_ERROR;
1535: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1533: FND_MSG_PUB.ADD;
1534: RAISE FND_API.G_EXC_ERROR;
1535: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1537: FND_MSG_PUB.ADD;
1538: RAISE FND_API.G_EXC_ERROR;
1539: else
1540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1537: FND_MSG_PUB.ADD;
1538: RAISE FND_API.G_EXC_ERROR;
1539: else
1540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: end if;

Line 1541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1537: FND_MSG_PUB.ADD;
1538: RAISE FND_API.G_EXC_ERROR;
1539: else
1540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: end if;
1545: END;

Line 1801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1797: output_long_strings('Restrict Sql = '||p_restrict_sql);
1798: exception
1799: when others then
1800: if (instrb(SQLERRM,'DRG-51030')>0) then
1801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1802: FND_MSG_PUB.ADD;
1803: RAISE FND_API.G_EXC_ERROR;
1804: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1802: FND_MSG_PUB.ADD;
1803: RAISE FND_API.G_EXC_ERROR;
1804: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1810: FND_MSG_PUB.ADD;
1811: RAISE FND_API.G_EXC_ERROR;
1812: else
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1813: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1810: FND_MSG_PUB.ADD;
1811: RAISE FND_API.G_EXC_ERROR;
1812: else
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1815: FND_MSG_PUB.ADD;
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817: end if;

Line 1814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1810: FND_MSG_PUB.ADD;
1811: RAISE FND_API.G_EXC_ERROR;
1812: else
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1815: FND_MSG_PUB.ADD;
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817: end if;
1818: END;

Line 2061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2057: IF p_index>1 THEN
2058: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2059: 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);
2060: END IF;
2061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;
2064: ELSE
2065: push_eval;

Line 2109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2105: IF p_index>1 THEN
2106: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2107: 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);
2108: END IF;
2109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2110: FND_MSG_PUB.ADD;
2111: RAISE FND_API.G_EXC_ERROR;
2112: ELSE
2113: push_eval;

Line 2182: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2178: IF p_index>1 THEN
2179: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2180: 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);
2181: END IF;
2182: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2183: FND_MSG_PUB.ADD;
2184: RAISE FND_API.G_EXC_ERROR;
2185: ELSE
2186: push_eval;

Line 2294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2290: IF p_index>1 THEN
2291: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2292: 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);
2293: END IF;
2294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2295: FND_MSG_PUB.ADD;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSE
2298: push_eval;

Line 2405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2401: IF p_index>1 THEN
2402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2403: 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);
2404: END IF;
2405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2406: FND_MSG_PUB.ADD;
2407: RAISE FND_API.G_EXC_ERROR;
2408: ELSE
2409: push_eval;

Line 2549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2545: ELSE
2546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2547: 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);
2548: END IF;
2549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2550: FND_MSG_PUB.ADD;
2551: RAISE FND_API.G_EXC_ERROR;
2552: END IF;
2553: ELSE

Line 2557: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2553: ELSE
2554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2555: 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);
2556: END IF;
2557: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2558: FND_MSG_PUB.ADD;
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;
2561: END IF;

Line 2806: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

2802: RAISE FND_API.G_EXC_ERROR;
2803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2805: WHEN OTHERS THEN
2806: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2807: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');
2808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2809: FND_MSG_PUB.ADD;
2810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2807: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');

2803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2805: WHEN OTHERS THEN
2806: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2807: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');
2808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2809: FND_MSG_PUB.ADD;
2810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2811: END find_parties;

Line 2808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

2804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2805: WHEN OTHERS THEN
2806: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2807: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');
2808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2809: FND_MSG_PUB.ADD;
2810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2811: END find_parties;
2812:

Line 2995: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2991: IF p_index>1 THEN
2992: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2993: 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);
2994: END IF;
2995: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2996: FND_MSG_PUB.ADD;
2997: RAISE FND_API.G_EXC_ERROR;
2998: ELSE
2999: push_eval;

Line 3043: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3039: IF p_index>1 THEN
3040: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3041: 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);
3042: END IF;
3043: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3044: FND_MSG_PUB.ADD;
3045: RAISE FND_API.G_EXC_ERROR;
3046: ELSE
3047: push_eval;

Line 3079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

3075: and d.search_context_id = p_search_ctx_id);
3076: exception
3077: when others then
3078: if (instrb(SQLERRM,'DRG-51030')>0) then
3079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3080: FND_MSG_PUB.ADD;
3081: RAISE FND_API.G_EXC_ERROR;
3082: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 3083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

3079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3080: FND_MSG_PUB.ADD;
3081: RAISE FND_API.G_EXC_ERROR;
3082: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3084: FND_MSG_PUB.ADD;
3085: RAISE FND_API.G_EXC_ERROR;
3086: else
3087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3155: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3151: IF p_index>1 THEN
3152: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3153: 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);
3154: END IF;
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_ERROR;
3158: ELSE
3159: push_eval;

Line 3344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3340: IF p_index>1 THEN
3341: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3342: 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);
3343: END IF;
3344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3345: FND_MSG_PUB.ADD;
3346: RAISE FND_API.G_EXC_ERROR;
3347: ELSE
3348: push_eval;

Line 3432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3428: ELSE
3429: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3430: 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);
3431: END IF;
3432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3433: FND_MSG_PUB.ADD;
3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436: ELSE

Line 3440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3436: ELSE
3437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3438: 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);
3439: END IF;
3440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3441: FND_MSG_PUB.ADD;
3442: RAISE FND_API.G_EXC_ERROR;
3443: END IF;
3444: END IF;

Line 3587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3583: RAISE FND_API.G_EXC_ERROR;
3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: WHEN OTHERS THEN
3587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3590: FND_MSG_PUB.ADD;
3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');

3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: WHEN OTHERS THEN
3587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3590: FND_MSG_PUB.ADD;
3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3592: END find_persons;

Line 3589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: WHEN OTHERS THEN
3587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3590: FND_MSG_PUB.ADD;
3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3592: END find_persons;
3593:

Line 3655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3651: RAISE FND_API.G_EXC_ERROR;
3652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3654: WHEN OTHERS THEN
3655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3656: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3658: FND_MSG_PUB.ADD;
3659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3656: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');

3652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3654: WHEN OTHERS THEN
3655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3656: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3658: FND_MSG_PUB.ADD;
3659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3660: END find_party_details;

Line 3657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3654: WHEN OTHERS THEN
3655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3656: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3658: FND_MSG_PUB.ADD;
3659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3660: END find_party_details;
3661:

Line 3772: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3768: RAISE FND_API.G_EXC_ERROR;
3769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3771: WHEN OTHERS THEN
3772: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3773: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3775: FND_MSG_PUB.ADD;
3776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3773: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');

3769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3771: WHEN OTHERS THEN
3772: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3773: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3775: FND_MSG_PUB.ADD;
3776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3777: END find_duplicate_parties;

Line 3774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3771: WHEN OTHERS THEN
3772: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3773: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3775: FND_MSG_PUB.ADD;
3776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3777: END find_duplicate_parties;
3778:

Line 3857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3853: RAISE FND_API.G_EXC_ERROR;
3854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: WHEN OTHERS THEN
3857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3858: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');
3859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3860: FND_MSG_PUB.ADD;
3861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3858: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');

3854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: WHEN OTHERS THEN
3857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3858: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');
3859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3860: FND_MSG_PUB.ADD;
3861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3862: END find_duplicate_party_sites;

Line 3859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3856: WHEN OTHERS THEN
3857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3858: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');
3859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3860: FND_MSG_PUB.ADD;
3861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3862: END find_duplicate_party_sites;
3863:

Line 3946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3942: RAISE FND_API.G_EXC_ERROR;
3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: WHEN OTHERS THEN
3946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3947: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3948: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3949: FND_MSG_PUB.ADD;
3950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3947: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');

3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: WHEN OTHERS THEN
3946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3947: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3948: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3949: FND_MSG_PUB.ADD;
3950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3951: END find_duplicate_contacts;

Line 3948: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: WHEN OTHERS THEN
3946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3947: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3948: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3949: FND_MSG_PUB.ADD;
3950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3951: END find_duplicate_contacts;
3952:

Line 4019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4015: RAISE FND_API.G_EXC_ERROR;
4016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4018: WHEN OTHERS THEN
4019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4020: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4022: FND_MSG_PUB.ADD;
4023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4020: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');

4016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4018: WHEN OTHERS THEN
4019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4020: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4022: FND_MSG_PUB.ADD;
4023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4024: END find_duplicate_contact_points;

Line 4021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4018: WHEN OTHERS THEN
4019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4020: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4022: FND_MSG_PUB.ADD;
4023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4024: END find_duplicate_contact_points;
4025:

Line 4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');

4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4284: END call_api_dynamic;

Line 4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4284: END call_api_dynamic;
4285:

Line 4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');

4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4518: END get_matching_party_sites;

Line 4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4518: END get_matching_party_sites;
4519:

Line 4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');

4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4743: END get_matching_contacts;

Line 4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4743: END get_matching_contacts;
4744:

Line 4877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4873: RAISE FND_API.G_EXC_ERROR;
4874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4876: WHEN OTHERS THEN
4877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4878: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4880: FND_MSG_PUB.ADD;
4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4878: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');

4874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4876: WHEN OTHERS THEN
4877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4878: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4880: FND_MSG_PUB.ADD;
4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4882: END get_matching_contact_points;

Line 4879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4876: WHEN OTHERS THEN
4877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4878: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4880: FND_MSG_PUB.ADD;
4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4882: END get_matching_contact_points;
4883:

Line 5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5071: RAISE FND_API.G_EXC_ERROR;
5072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5074: WHEN OTHERS THEN
5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5076: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5078: FND_MSG_PUB.ADD;
5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5076: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');

5072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5074: WHEN OTHERS THEN
5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5076: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5078: FND_MSG_PUB.ADD;
5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5080: END get_score_details;

Line 5077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5074: WHEN OTHERS THEN
5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5076: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5078: FND_MSG_PUB.ADD;
5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5080: END get_score_details;
5081:

Line 5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5149: RAISE FND_API.G_EXC_ERROR;
5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: WHEN OTHERS THEN
5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5154: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5156: FND_MSG_PUB.ADD;
5157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5154: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: WHEN OTHERS THEN
5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5154: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5156: FND_MSG_PUB.ADD;
5157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5158: END get_party_for_search;

Line 5155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: WHEN OTHERS THEN
5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5154: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5156: FND_MSG_PUB.ADD;
5157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5158: END get_party_for_search;
5159:

Line 5193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5189: RAISE FND_API.G_EXC_ERROR;
5190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5194: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5196: FND_MSG_PUB.ADD;
5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5194: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

5190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5194: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5196: FND_MSG_PUB.ADD;
5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5198: END get_search_criteria;

Line 5195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5194: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5196: FND_MSG_PUB.ADD;
5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5198: END get_search_criteria;
5199:

Line 5253: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5249: END IF;
5250:
5251: EXCEPTION
5252: WHEN OTHERS THEN
5253: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5255: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5257: FND_MSG_PUB.ADD;

Line 5254: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');

5250:
5251: EXCEPTION
5252: WHEN OTHERS THEN
5253: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5255: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5257: FND_MSG_PUB.ADD;
5258: RAISE FND_API.G_EXC_ERROR;

Line 5255: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);

5251: EXCEPTION
5252: WHEN OTHERS THEN
5253: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5255: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5257: FND_MSG_PUB.ADD;
5258: RAISE FND_API.G_EXC_ERROR;
5259: END get_party_rec;

Line 5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5252: WHEN OTHERS THEN
5253: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5255: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5257: FND_MSG_PUB.ADD;
5258: RAISE FND_API.G_EXC_ERROR;
5259: END get_party_rec;
5260:

Line 5309: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5305: END LOOP;
5306:
5307: EXCEPTION
5308: WHEN OTHERS THEN
5309: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5310: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5311: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5312: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5313: FND_MSG_PUB.ADD;

Line 5310: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');

5306:
5307: EXCEPTION
5308: WHEN OTHERS THEN
5309: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5310: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5311: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5312: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5313: FND_MSG_PUB.ADD;
5314: RAISE FND_API.G_EXC_ERROR;

Line 5311: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);

5307: EXCEPTION
5308: WHEN OTHERS THEN
5309: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5310: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5311: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5312: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5313: FND_MSG_PUB.ADD;
5314: RAISE FND_API.G_EXC_ERROR;
5315: END get_party_site_rec;

Line 5312: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5308: WHEN OTHERS THEN
5309: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5310: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5311: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5312: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5313: FND_MSG_PUB.ADD;
5314: RAISE FND_API.G_EXC_ERROR;
5315: END get_party_site_rec;
5316:

Line 5365: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5361: END LOOP;
5362:
5363: EXCEPTION
5364: WHEN OTHERS THEN
5365: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5366: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5367: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5369: FND_MSG_PUB.ADD;

Line 5366: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');

5362:
5363: EXCEPTION
5364: WHEN OTHERS THEN
5365: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5366: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5367: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5369: FND_MSG_PUB.ADD;
5370: RAISE FND_API.G_EXC_ERROR;

Line 5367: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);

5363: EXCEPTION
5364: WHEN OTHERS THEN
5365: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5366: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5367: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5369: FND_MSG_PUB.ADD;
5370: RAISE FND_API.G_EXC_ERROR;
5371: END get_contact_rec;

Line 5368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5364: WHEN OTHERS THEN
5365: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5366: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5367: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5369: FND_MSG_PUB.ADD;
5370: RAISE FND_API.G_EXC_ERROR;
5371: END get_contact_rec;
5372:

Line 5417: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5413: END LOOP;
5414:
5415: EXCEPTION
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5419: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5421: FND_MSG_PUB.ADD;

Line 5418: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');

5414:
5415: EXCEPTION
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5419: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5421: FND_MSG_PUB.ADD;
5422: RAISE FND_API.G_EXC_ERROR;

Line 5419: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);

5415: EXCEPTION
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5419: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5421: FND_MSG_PUB.ADD;
5422: RAISE FND_API.G_EXC_ERROR;
5423: END get_contact_point_rec;

Line 5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5419: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5421: FND_MSG_PUB.ADD;
5422: RAISE FND_API.G_EXC_ERROR;
5423: END get_contact_point_rec;
5424:

Line 5523: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5519: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5520: END IF;
5521: EXCEPTION
5522: WHEN OTHERS THEN
5523: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5524: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5526: FND_MSG_PUB.ADD;
5527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5524: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');

5520: END IF;
5521: EXCEPTION
5522: WHEN OTHERS THEN
5523: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5524: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5526: FND_MSG_PUB.ADD;
5527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5528: END;

Line 5525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

5521: EXCEPTION
5522: WHEN OTHERS THEN
5523: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5524: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5526: FND_MSG_PUB.ADD;
5527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5528: END;
5529:

Line 5638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5634: END IF;
5635: END LOOP;
5636: EXCEPTION
5637: WHEN OTHERS THEN
5638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5641: FND_MSG_PUB.ADD;
5642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');

5635: END LOOP;
5636: EXCEPTION
5637: WHEN OTHERS THEN
5638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5641: FND_MSG_PUB.ADD;
5642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5643: END;

Line 5640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

5636: EXCEPTION
5637: WHEN OTHERS THEN
5638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5641: FND_MSG_PUB.ADD;
5642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5643: END;
5644:

Line 5680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5676: END IF;
5677: NULL;
5678: EXCEPTION
5679: WHEN OTHERS THEN
5680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5683: FND_MSG_PUB.ADD;
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');

5677: NULL;
5678: EXCEPTION
5679: WHEN OTHERS THEN
5680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5683: FND_MSG_PUB.ADD;
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: END;

Line 5682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

5678: EXCEPTION
5679: WHEN OTHERS THEN
5680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5683: FND_MSG_PUB.ADD;
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: END;
5686:

Line 5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5719: END IF;
5720: NULL;
5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');

5720: NULL;
5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END;

Line 5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END;
5729:

Line 5758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5754: EXCEPTION
5755: WHEN FND_API.G_EXC_ERROR THEN
5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN OTHERS THEN
5758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5759: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5759: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

5755: WHEN FND_API.G_EXC_ERROR THEN
5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN OTHERS THEN
5758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5759: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: END check_prim_cond;

Line 5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN OTHERS THEN
5758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5759: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: END check_prim_cond;
5764:

Line 5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5798: NULL;
5799: END LOOP;
5800: EXCEPTION
5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5803: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');

5799: END LOOP;
5800: EXCEPTION
5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5807: END check_party_site_cond;

Line 5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5800: EXCEPTION
5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5807: END check_party_site_cond;
5808:

Line 5840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5836: NULL;
5837: END LOOP;
5838: EXCEPTION
5839: WHEN OTHERS THEN
5840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5841: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5843: FND_MSG_PUB.ADD;
5844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5841: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');

5837: END LOOP;
5838: EXCEPTION
5839: WHEN OTHERS THEN
5840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5841: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5843: FND_MSG_PUB.ADD;
5844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5845: END check_contact_cond;

Line 5842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5838: EXCEPTION
5839: WHEN OTHERS THEN
5840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5841: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5843: FND_MSG_PUB.ADD;
5844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5845: END check_contact_cond;
5846:

Line 5863: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

5859: x_secondary:= FALSE;
5860:
5861: FOR I IN 1..p_contact_point_list.COUNT LOOP
5862: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5863: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END IF;
5867: END LOOP;

Line 5877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5873: NULL;
5874: END LOOP;
5875: EXCEPTION
5876: WHEN OTHERS THEN
5877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5878: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5880: FND_MSG_PUB.ADD;
5881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5878: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');

5874: END LOOP;
5875: EXCEPTION
5876: WHEN OTHERS THEN
5877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5878: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5880: FND_MSG_PUB.ADD;
5881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5882: END check_contact_point_cond;

Line 5879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5875: EXCEPTION
5876: WHEN OTHERS THEN
5877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5878: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5880: FND_MSG_PUB.ADD;
5881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5882: END check_contact_point_cond;
5883: