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 1138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3590: WHEN OTHERS THEN
3591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3594: FND_MSG_PUB.ADD;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: END find_persons;
3597:

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

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

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

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

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

3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: WHEN OTHERS THEN
3659: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3660: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3661: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3662: FND_MSG_PUB.ADD;
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END find_party_details;
3665:

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

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

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

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

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

3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3775: WHEN OTHERS THEN
3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3777: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3778: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3779: FND_MSG_PUB.ADD;
3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3781: END find_duplicate_parties;
3782:

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

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

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

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

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

3859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3860: WHEN OTHERS THEN
3861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3862: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_party_sites');
3863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3864: FND_MSG_PUB.ADD;
3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3866: END find_duplicate_party_sites;
3867:

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

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

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

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

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

3948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3949: WHEN OTHERS THEN
3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3953: FND_MSG_PUB.ADD;
3954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3955: END find_duplicate_contacts;
3956:

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

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

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

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

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

4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4022: WHEN OTHERS THEN
4023: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4024: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4025: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4026: FND_MSG_PUB.ADD;
4027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4028: END find_duplicate_contact_points;
4029:

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

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

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

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

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

4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4282: WHEN OTHERS THEN
4283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4284: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4285: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4286: FND_MSG_PUB.ADD;
4287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4288: END call_api_dynamic;
4289:

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

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

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

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

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

4515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4516: WHEN OTHERS THEN
4517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4518: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4519: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4520: FND_MSG_PUB.ADD;
4521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4522: END get_matching_party_sites;
4523:

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

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

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

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

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

4740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4741: WHEN OTHERS THEN
4742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4743: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4744: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4745: FND_MSG_PUB.ADD;
4746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4747: END get_matching_contacts;
4748:

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

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

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

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

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

4879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4884: FND_MSG_PUB.ADD;
4885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4886: END get_matching_contact_points;
4887:

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

5076: RAISE FND_API.G_EXC_ERROR;
5077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5079: WHEN OTHERS THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5083: FND_MSG_PUB.ADD;
5084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5079: WHEN OTHERS THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5083: FND_MSG_PUB.ADD;
5084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5085: END get_score_details;

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

5078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5079: WHEN OTHERS THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5083: FND_MSG_PUB.ADD;
5084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5085: END get_score_details;
5086:

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

5154: RAISE FND_API.G_EXC_ERROR;
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5157: WHEN OTHERS THEN
5158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5159: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5157: WHEN OTHERS THEN
5158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5159: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5163: END get_party_for_search;

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

5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5157: WHEN OTHERS THEN
5158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5159: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5163: END get_party_for_search;
5164:

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

5194: RAISE FND_API.G_EXC_ERROR;
5195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: WHEN OTHERS THEN
5198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5199: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5201: FND_MSG_PUB.ADD;
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: WHEN OTHERS THEN
5198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5199: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5201: FND_MSG_PUB.ADD;
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: END get_search_criteria;

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

5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: WHEN OTHERS THEN
5198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5199: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5201: FND_MSG_PUB.ADD;
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: END get_search_criteria;
5204:

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

5254: END IF;
5255:
5256: EXCEPTION
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5260: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;

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

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

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

5256: EXCEPTION
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5260: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_ERROR;
5264: END get_party_rec;

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

5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5260: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_ERROR;
5264: END get_party_rec;
5265:

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

5310: END LOOP;
5311:
5312: EXCEPTION
5313: WHEN OTHERS THEN
5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;

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

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

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

5312: EXCEPTION
5313: WHEN OTHERS THEN
5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;
5320: END get_party_site_rec;

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

5313: WHEN OTHERS THEN
5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;
5320: END get_party_site_rec;
5321:

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

5366: END LOOP;
5367:
5368: EXCEPTION
5369: WHEN OTHERS THEN
5370: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5371: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5372: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5373: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5374: FND_MSG_PUB.ADD;

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

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

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

5368: EXCEPTION
5369: WHEN OTHERS THEN
5370: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5371: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5372: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5373: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5374: FND_MSG_PUB.ADD;
5375: RAISE FND_API.G_EXC_ERROR;
5376: END get_contact_rec;

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

5369: WHEN OTHERS THEN
5370: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5371: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5372: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5373: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5374: FND_MSG_PUB.ADD;
5375: RAISE FND_API.G_EXC_ERROR;
5376: END get_contact_rec;
5377:

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

5418: END LOOP;
5419:
5420: EXCEPTION
5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5424: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;

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

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

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

5420: EXCEPTION
5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5424: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_ERROR;
5428: END get_contact_point_rec;

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

5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5424: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_ERROR;
5428: END get_contact_point_rec;
5429:

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

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

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

5525: END IF;
5526: EXCEPTION
5527: WHEN OTHERS THEN
5528: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5529: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5531: FND_MSG_PUB.ADD;
5532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5533: END;

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

5526: EXCEPTION
5527: WHEN OTHERS THEN
5528: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5529: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5531: FND_MSG_PUB.ADD;
5532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5533: END;
5534:

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

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

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

5640: END LOOP;
5641: EXCEPTION
5642: WHEN OTHERS THEN
5643: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5644: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5645: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5646: FND_MSG_PUB.ADD;
5647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5648: END;

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

5641: EXCEPTION
5642: WHEN OTHERS THEN
5643: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5644: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5645: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5646: FND_MSG_PUB.ADD;
5647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5648: END;
5649:

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

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

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

5682: NULL;
5683: EXCEPTION
5684: WHEN OTHERS THEN
5685: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5686: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: END;

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

5683: EXCEPTION
5684: WHEN OTHERS THEN
5685: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5686: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: END;
5691:

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

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

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

5725: NULL;
5726: EXCEPTION
5727: WHEN OTHERS THEN
5728: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5729: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5730: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5731: FND_MSG_PUB.ADD;
5732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5733: END;

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

5726: EXCEPTION
5727: WHEN OTHERS THEN
5728: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5729: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5730: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5731: FND_MSG_PUB.ADD;
5732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5733: END;
5734:

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

5759: EXCEPTION
5760: WHEN FND_API.G_EXC_ERROR THEN
5761: RAISE FND_API.G_EXC_ERROR;
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5766: FND_MSG_PUB.ADD;
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5760: WHEN FND_API.G_EXC_ERROR THEN
5761: RAISE FND_API.G_EXC_ERROR;
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5766: FND_MSG_PUB.ADD;
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: END check_prim_cond;

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

5761: RAISE FND_API.G_EXC_ERROR;
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5766: FND_MSG_PUB.ADD;
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: END check_prim_cond;
5769:

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

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

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

5804: END LOOP;
5805: EXCEPTION
5806: WHEN OTHERS THEN
5807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5808: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5809: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5810: FND_MSG_PUB.ADD;
5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5812: END check_party_site_cond;

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

5805: EXCEPTION
5806: WHEN OTHERS THEN
5807: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5808: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5809: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5810: FND_MSG_PUB.ADD;
5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5812: END check_party_site_cond;
5813:

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

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

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

5842: END LOOP;
5843: EXCEPTION
5844: WHEN OTHERS THEN
5845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5846: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5848: FND_MSG_PUB.ADD;
5849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5850: END check_contact_cond;

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

5843: EXCEPTION
5844: WHEN OTHERS THEN
5845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5846: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5848: FND_MSG_PUB.ADD;
5849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5850: END check_contact_cond;
5851:

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

5864: x_secondary:= FALSE;
5865:
5866: FOR I IN 1..p_contact_point_list.COUNT LOOP
5867: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_ERROR;
5871: END IF;
5872: END LOOP;

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

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

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

5879: END LOOP;
5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5883: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5885: FND_MSG_PUB.ADD;
5886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5887: END check_contact_point_cond;

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

5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5883: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5885: FND_MSG_PUB.ADD;
5886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5887: END check_contact_point_cond;
5888: