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_98 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 546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

542: BEGIN
543: NULL ;
544: EXCEPTION
545: WHEN OTHERS THEN
546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
547: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

543: NULL ;
544: EXCEPTION
545: WHEN OTHERS THEN
546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
547: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END;

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

544: EXCEPTION
545: WHEN OTHERS THEN
546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
547: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END;
552:

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

562: BEGIN
563: NULL ;
564: EXCEPTION
565: WHEN OTHERS THEN
566: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
567: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
569: FND_MSG_PUB.ADD;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

563: NULL ;
564: EXCEPTION
565: WHEN OTHERS THEN
566: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
567: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
569: FND_MSG_PUB.ADD;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END;

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

564: EXCEPTION
565: WHEN OTHERS THEN
566: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
567: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
569: FND_MSG_PUB.ADD;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END;
572:

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

582: BEGIN
583: NULL ;
584: EXCEPTION
585: WHEN OTHERS THEN
586: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
587: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
588: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
589: FND_MSG_PUB.ADD;
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

583: NULL ;
584: EXCEPTION
585: WHEN OTHERS THEN
586: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
587: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
588: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
589: FND_MSG_PUB.ADD;
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END;

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

584: EXCEPTION
585: WHEN OTHERS THEN
586: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
587: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
588: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
589: FND_MSG_PUB.ADD;
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END;
592:

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

602: BEGIN
603: NULL ;
604: EXCEPTION
605: WHEN OTHERS THEN
606: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
607: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
609: FND_MSG_PUB.ADD;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

603: NULL ;
604: EXCEPTION
605: WHEN OTHERS THEN
606: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
607: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
609: FND_MSG_PUB.ADD;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END;

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

604: EXCEPTION
605: WHEN OTHERS THEN
606: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
607: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
609: FND_MSG_PUB.ADD;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END;
612:

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

671: IF NOT check_prim_cond (p_party_search_rec,
672: p_party_site_list,
673: p_contact_list,
674: p_contact_point_list) THEN
675: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
676: FND_MSG_PUB.ADD;
677: RAISE FND_API.G_EXC_ERROR;
678: END IF;
679: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

888: ELSE
889: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
890: END IF;
891: IF lengthb(l_party_contains_str) > 4000 THEN
892: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
893: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;

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

889: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
890: END IF;
891: IF lengthb(l_party_contains_str) > 4000 THEN
892: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
893: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: IF (p_match_str = ' AND ' OR p_party_max_score

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

966: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
967: END LOOP;
968: -- Add the search criteria to query string
969: IF lengthb(l_contains_str) > 4000 THEN
970: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
971: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;

Line 971: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');

967: END LOOP;
968: -- Add the search criteria to query string
969: IF lengthb(l_contains_str) > 4000 THEN
970: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
971: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: x_denorm_str := l_den_contains_str;

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

1047: END IF;
1048: END LOOP;
1049: -- Add the search criteria to query string
1050: IF lengthb(l_contains_str) > 4000 THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1052: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1053: FND_MSG_PUB.ADD;
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;

Line 1052: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');

1048: END LOOP;
1049: -- Add the search criteria to query string
1050: IF lengthb(l_contains_str) > 4000 THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1052: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1053: FND_MSG_PUB.ADD;
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056: x_denorm_str := l_den_contains_str;

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

1262: END IF;
1263: exception
1264: when others then
1265: if (instrb(SQLERRM,'DRG-51030')>0) then
1266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1267: FND_MSG_PUB.ADD;
1268: RAISE FND_API.G_EXC_ERROR;
1269: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1267: FND_MSG_PUB.ADD;
1268: RAISE FND_API.G_EXC_ERROR;
1269: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1271: FND_MSG_PUB.ADD;
1272: RAISE FND_API.G_EXC_ERROR;
1273: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1271: FND_MSG_PUB.ADD;
1272: RAISE FND_API.G_EXC_ERROR;
1273: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1275: FND_MSG_PUB.ADD;
1276: RAISE FND_API.G_EXC_ERROR;
1277: else
1278: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1275: FND_MSG_PUB.ADD;
1276: RAISE FND_API.G_EXC_ERROR;
1277: else
1278: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1279: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1280: FND_MSG_PUB.ADD;
1281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1282: end if;

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

1275: FND_MSG_PUB.ADD;
1276: RAISE FND_API.G_EXC_ERROR;
1277: else
1278: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1279: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1280: FND_MSG_PUB.ADD;
1281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1282: end if;
1283: END;

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

1507: output_long_strings('Restrict Sql = '||p_restrict_sql);
1508: exception
1509: when others then
1510: if (instrb(SQLERRM,'DRG-51030')>0) then
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1515: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1511: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1515: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1516: FND_MSG_PUB.ADD;
1517: RAISE FND_API.G_EXC_ERROR;
1518: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1515: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1516: FND_MSG_PUB.ADD;
1517: RAISE FND_API.G_EXC_ERROR;
1518: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1520: FND_MSG_PUB.ADD;
1521: RAISE FND_API.G_EXC_ERROR;
1522: else
1523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1520: FND_MSG_PUB.ADD;
1521: RAISE FND_API.G_EXC_ERROR;
1522: else
1523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1525: FND_MSG_PUB.ADD;
1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1527: end if;

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

1520: FND_MSG_PUB.ADD;
1521: RAISE FND_API.G_EXC_ERROR;
1522: else
1523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1525: FND_MSG_PUB.ADD;
1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1527: end if;
1528: END;

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

1654: output_long_strings('Restrict Sql = '||p_restrict_sql);
1655: exception
1656: when others then
1657: if (instrb(SQLERRM,'DRG-51030')>0) then
1658: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1659: FND_MSG_PUB.ADD;
1660: RAISE FND_API.G_EXC_ERROR;
1661: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1658: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1659: FND_MSG_PUB.ADD;
1660: RAISE FND_API.G_EXC_ERROR;
1661: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1663: FND_MSG_PUB.ADD;
1664: RAISE FND_API.G_EXC_ERROR;
1665: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1663: FND_MSG_PUB.ADD;
1664: RAISE FND_API.G_EXC_ERROR;
1665: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1667: FND_MSG_PUB.ADD;
1668: RAISE FND_API.G_EXC_ERROR;
1669: else
1670: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1667: FND_MSG_PUB.ADD;
1668: RAISE FND_API.G_EXC_ERROR;
1669: else
1670: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1672: FND_MSG_PUB.ADD;
1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1674: end if;

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

1667: FND_MSG_PUB.ADD;
1668: RAISE FND_API.G_EXC_ERROR;
1669: else
1670: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1672: FND_MSG_PUB.ADD;
1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1674: end if;
1675: END;

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

1927: output_long_strings('Restrict Sql = '||p_restrict_sql);
1928: exception
1929: when others then
1930: if (instrb(SQLERRM,'DRG-51030')>0) then
1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1932: FND_MSG_PUB.ADD;
1933: RAISE FND_API.G_EXC_ERROR;
1934: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1932: FND_MSG_PUB.ADD;
1933: RAISE FND_API.G_EXC_ERROR;
1934: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1936: FND_MSG_PUB.ADD;
1937: RAISE FND_API.G_EXC_ERROR;
1938: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1936: FND_MSG_PUB.ADD;
1937: RAISE FND_API.G_EXC_ERROR;
1938: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1940: FND_MSG_PUB.ADD;
1941: RAISE FND_API.G_EXC_ERROR;
1942: else
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1940: FND_MSG_PUB.ADD;
1941: RAISE FND_API.G_EXC_ERROR;
1942: else
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1947: end if;

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

1940: FND_MSG_PUB.ADD;
1941: RAISE FND_API.G_EXC_ERROR;
1942: else
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1947: end if;
1948: END;

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

2190: IF p_index>1 THEN
2191: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2192: 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);
2193: END IF;
2194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2195: FND_MSG_PUB.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197: ELSE
2198: push_eval;

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

2238: IF p_index>1 THEN
2239: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2240: 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);
2241: END IF;
2242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2243: FND_MSG_PUB.ADD;
2244: RAISE FND_API.G_EXC_ERROR;
2245: ELSE
2246: push_eval;

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

2311: IF p_index>1 THEN
2312: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2313: 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);
2314: END IF;
2315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2316: FND_MSG_PUB.ADD;
2317: RAISE FND_API.G_EXC_ERROR;
2318: ELSE
2319: push_eval;

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

2423: IF p_index>1 THEN
2424: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2425: 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);
2426: END IF;
2427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2428: FND_MSG_PUB.ADD;
2429: RAISE FND_API.G_EXC_ERROR;
2430: ELSE
2431: push_eval;

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

2534: IF p_index>1 THEN
2535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2536: 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);
2537: END IF;
2538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2539: FND_MSG_PUB.ADD;
2540: RAISE FND_API.G_EXC_ERROR;
2541: ELSE
2542: push_eval;

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

2759: ELSE
2760: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2761: 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);
2762: END IF;
2763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2764: FND_MSG_PUB.ADD;
2765: RAISE FND_API.G_EXC_ERROR;
2766: END IF;
2767: ELSE

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

2767: ELSE
2768: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2769: 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);
2770: END IF;
2771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2772: FND_MSG_PUB.ADD;
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;
2775: END IF;

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

2973: RAISE FND_API.G_EXC_ERROR;
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976: WHEN OTHERS THEN
2977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2978: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_parties');
2979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2980: FND_MSG_PUB.ADD;
2981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2978: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_parties');

2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976: WHEN OTHERS THEN
2977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2978: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_parties');
2979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2980: FND_MSG_PUB.ADD;
2981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2982: END find_parties;

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

2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976: WHEN OTHERS THEN
2977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2978: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_parties');
2979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2980: FND_MSG_PUB.ADD;
2981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2982: END find_parties;
2983:

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

3165: IF p_index>1 THEN
3166: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3167: 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);
3168: END IF;
3169: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3170: FND_MSG_PUB.ADD;
3171: RAISE FND_API.G_EXC_ERROR;
3172: ELSE
3173: push_eval;

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

3213: IF p_index>1 THEN
3214: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3215: 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);
3216: END IF;
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3218: FND_MSG_PUB.ADD;
3219: RAISE FND_API.G_EXC_ERROR;
3220: ELSE
3221: push_eval;

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

3249: and d.search_context_id = p_search_ctx_id);
3250: exception
3251: when others then
3252: if (instrb(SQLERRM,'DRG-51030')>0) then
3253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3254: FND_MSG_PUB.ADD;
3255: RAISE FND_API.G_EXC_ERROR;
3256: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3254: FND_MSG_PUB.ADD;
3255: RAISE FND_API.G_EXC_ERROR;
3256: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3258: FND_MSG_PUB.ADD;
3259: RAISE FND_API.G_EXC_ERROR;
3260: else
3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3325: IF p_index>1 THEN
3326: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3327: 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);
3328: END IF;
3329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3330: FND_MSG_PUB.ADD;
3331: RAISE FND_API.G_EXC_ERROR;
3332: ELSE
3333: push_eval;

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

3584: IF p_index>1 THEN
3585: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3586: 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);
3587: END IF;
3588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3589: FND_MSG_PUB.ADD;
3590: RAISE FND_API.G_EXC_ERROR;
3591: ELSE
3592: push_eval;

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

3697: ELSE
3698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3699: 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);
3700: END IF;
3701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3702: FND_MSG_PUB.ADD;
3703: RAISE FND_API.G_EXC_ERROR;
3704: END IF;
3705: ELSE

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

3705: ELSE
3706: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3707: 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);
3708: END IF;
3709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3710: FND_MSG_PUB.ADD;
3711: RAISE FND_API.G_EXC_ERROR;
3712: END IF;
3713: END IF;

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

3826: RAISE FND_API.G_EXC_ERROR;
3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: WHEN OTHERS THEN
3830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3833: FND_MSG_PUB.ADD;
3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');

3827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: WHEN OTHERS THEN
3830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3833: FND_MSG_PUB.ADD;
3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3835: END find_persons;

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

3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: WHEN OTHERS THEN
3830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3833: FND_MSG_PUB.ADD;
3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3835: END find_persons;
3836:

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

3894: RAISE FND_API.G_EXC_ERROR;
3895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3897: WHEN OTHERS THEN
3898: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3899: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3901: FND_MSG_PUB.ADD;
3902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3899: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');

3895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3897: WHEN OTHERS THEN
3898: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3899: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3901: FND_MSG_PUB.ADD;
3902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3903: END find_party_details;

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

3896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3897: WHEN OTHERS THEN
3898: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3899: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3901: FND_MSG_PUB.ADD;
3902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3903: END find_party_details;
3904:

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

4011: RAISE FND_API.G_EXC_ERROR;
4012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN
4015: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4016: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4017: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4018: FND_MSG_PUB.ADD;
4019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4016: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');

4012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN
4015: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4016: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4017: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4018: FND_MSG_PUB.ADD;
4019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4020: END find_duplicate_parties;

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

4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN
4015: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4016: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4017: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4018: FND_MSG_PUB.ADD;
4019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4020: END find_duplicate_parties;
4021:

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

4096: RAISE FND_API.G_EXC_ERROR;
4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN
4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4103: FND_MSG_PUB.ADD;
4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');

4097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN
4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4103: FND_MSG_PUB.ADD;
4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4105: END find_duplicate_party_sites;

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

4098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4099: WHEN OTHERS THEN
4100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4101: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4103: FND_MSG_PUB.ADD;
4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4105: END find_duplicate_party_sites;
4106:

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

4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');

4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: END find_duplicate_contacts;

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

4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: END find_duplicate_contacts;
4195:

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

4258: RAISE FND_API.G_EXC_ERROR;
4259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: WHEN OTHERS THEN
4262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4263: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4265: FND_MSG_PUB.ADD;
4266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4263: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');

4259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: WHEN OTHERS THEN
4262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4263: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4265: FND_MSG_PUB.ADD;
4266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4267: END find_duplicate_contact_points;

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

4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: WHEN OTHERS THEN
4262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4263: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4265: FND_MSG_PUB.ADD;
4266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4267: END find_duplicate_contact_points;
4268:

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

4552: RAISE FND_API.G_EXC_ERROR;
4553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: WHEN OTHERS THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4559: FND_MSG_PUB.ADD;
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4557: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');

4553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: WHEN OTHERS THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4559: FND_MSG_PUB.ADD;
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: END call_api_dynamic;

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

4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: WHEN OTHERS THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4559: FND_MSG_PUB.ADD;
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: END call_api_dynamic;
4562:

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

4787: RAISE FND_API.G_EXC_ERROR;
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: WHEN OTHERS THEN
4791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4792: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4794: FND_MSG_PUB.ADD;
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4792: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');

4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: WHEN OTHERS THEN
4791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4792: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4794: FND_MSG_PUB.ADD;
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: END get_matching_party_sites;

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

4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: WHEN OTHERS THEN
4791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4792: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4794: FND_MSG_PUB.ADD;
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: END get_matching_party_sites;
4797:

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

5016: RAISE FND_API.G_EXC_ERROR;
5017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5019: WHEN OTHERS THEN
5020: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5021: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5023: FND_MSG_PUB.ADD;
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5021: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');

5017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5019: WHEN OTHERS THEN
5020: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5021: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5023: FND_MSG_PUB.ADD;
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: END get_matching_contacts;

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

5018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5019: WHEN OTHERS THEN
5020: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5021: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5023: FND_MSG_PUB.ADD;
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: END get_matching_contacts;
5026:

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

5158: RAISE FND_API.G_EXC_ERROR;
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5161: WHEN OTHERS THEN
5162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5163: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');
5164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5165: FND_MSG_PUB.ADD;
5166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5163: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');

5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5161: WHEN OTHERS THEN
5162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5163: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');
5164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5165: FND_MSG_PUB.ADD;
5166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5167: END get_matching_contact_points;

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

5160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5161: WHEN OTHERS THEN
5162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5163: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contact_points');
5164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5165: FND_MSG_PUB.ADD;
5166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5167: END get_matching_contact_points;
5168:

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

5363: RAISE FND_API.G_EXC_ERROR;
5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5366: WHEN OTHERS THEN
5367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5368: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5368: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');

5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5366: WHEN OTHERS THEN
5367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5368: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5372: END get_score_details;

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

5365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5366: WHEN OTHERS THEN
5367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5368: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5372: END get_score_details;
5373:

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

5451: RAISE FND_API.G_EXC_ERROR;
5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5454: WHEN OTHERS THEN
5455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5456: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5458: FND_MSG_PUB.ADD;
5459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5454: WHEN OTHERS THEN
5455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5456: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5458: FND_MSG_PUB.ADD;
5459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5460: END get_party_for_search;

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

5453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5454: WHEN OTHERS THEN
5455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5456: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5457: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5458: FND_MSG_PUB.ADD;
5459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5460: END get_party_for_search;
5461:

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

5497: RAISE FND_API.G_EXC_ERROR;
5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5500: WHEN OTHERS THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5502: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5503: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5504: FND_MSG_PUB.ADD;
5505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5500: WHEN OTHERS THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5502: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5503: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5504: FND_MSG_PUB.ADD;
5505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5506: END get_search_criteria;

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

5499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5500: WHEN OTHERS THEN
5501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5502: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5503: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5504: FND_MSG_PUB.ADD;
5505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5506: END get_search_criteria;
5507:

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

5541: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5542:
5543: EXCEPTION
5544: WHEN OTHERS THEN
5545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5546: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5547: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5549: FND_MSG_PUB.ADD;

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

5542:
5543: EXCEPTION
5544: WHEN OTHERS THEN
5545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5546: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5547: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;

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

5543: EXCEPTION
5544: WHEN OTHERS THEN
5545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5546: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5547: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;
5551: END get_party_rec;

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

5544: WHEN OTHERS THEN
5545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5546: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5547: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;
5551: END get_party_rec;
5552:

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

5593: END LOOP;
5594:
5595: EXCEPTION
5596: WHEN OTHERS THEN
5597: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5598: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5599: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5601: FND_MSG_PUB.ADD;

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

5594:
5595: EXCEPTION
5596: WHEN OTHERS THEN
5597: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5598: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5599: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5601: FND_MSG_PUB.ADD;
5602: RAISE FND_API.G_EXC_ERROR;

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

5595: EXCEPTION
5596: WHEN OTHERS THEN
5597: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5598: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5599: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5601: FND_MSG_PUB.ADD;
5602: RAISE FND_API.G_EXC_ERROR;
5603: END get_party_site_rec;

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

5596: WHEN OTHERS THEN
5597: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5598: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5599: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5601: FND_MSG_PUB.ADD;
5602: RAISE FND_API.G_EXC_ERROR;
5603: END get_party_site_rec;
5604:

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

5651: END LOOP;
5652:
5653: EXCEPTION
5654: WHEN OTHERS THEN
5655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5656: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;

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

5652:
5653: EXCEPTION
5654: WHEN OTHERS THEN
5655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5656: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_ERROR;

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

5653: EXCEPTION
5654: WHEN OTHERS THEN
5655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5656: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_ERROR;
5661: END get_contact_rec;

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

5654: WHEN OTHERS THEN
5655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5656: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_ERROR;
5661: END get_contact_rec;
5662:

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

5707: END LOOP;
5708:
5709: EXCEPTION
5710: WHEN OTHERS THEN
5711: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5712: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5713: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5715: FND_MSG_PUB.ADD;

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

5708:
5709: EXCEPTION
5710: WHEN OTHERS THEN
5711: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5712: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5713: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5715: FND_MSG_PUB.ADD;
5716: RAISE FND_API.G_EXC_ERROR;

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

5709: EXCEPTION
5710: WHEN OTHERS THEN
5711: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5712: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5713: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5715: FND_MSG_PUB.ADD;
5716: RAISE FND_API.G_EXC_ERROR;
5717: END get_contact_point_rec;

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

5710: WHEN OTHERS THEN
5711: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5712: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5713: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5715: FND_MSG_PUB.ADD;
5716: RAISE FND_API.G_EXC_ERROR;
5717: END get_contact_point_rec;
5718:

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

5804: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5805: END IF;
5806: EXCEPTION
5807: WHEN OTHERS THEN
5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5809: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5811: FND_MSG_PUB.ADD;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

5847: END IF;
5848: NULL;
5849: EXCEPTION
5850: WHEN OTHERS THEN
5851: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5852: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5853: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5854: FND_MSG_PUB.ADD;
5855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5848: NULL;
5849: EXCEPTION
5850: WHEN OTHERS THEN
5851: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5852: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5853: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5854: FND_MSG_PUB.ADD;
5855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5856: END;

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

5849: EXCEPTION
5850: WHEN OTHERS THEN
5851: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5852: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5853: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5854: FND_MSG_PUB.ADD;
5855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5856: END;
5857:

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

5904: END IF;
5905: END LOOP;
5906: EXCEPTION
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5905: END LOOP;
5906: EXCEPTION
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END;

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

5906: EXCEPTION
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END;
5914:

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

6035: END IF;
6036: END LOOP;
6037: EXCEPTION
6038: WHEN OTHERS THEN
6039: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6040: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6042: FND_MSG_PUB.ADD;
6043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6036: END LOOP;
6037: EXCEPTION
6038: WHEN OTHERS THEN
6039: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6040: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6042: FND_MSG_PUB.ADD;
6043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6044: END;

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

6037: EXCEPTION
6038: WHEN OTHERS THEN
6039: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6040: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6042: FND_MSG_PUB.ADD;
6043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6044: END;
6045:

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

6062: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6063: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6064: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6065: ) THEN
6066: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6067: FND_MSG_PUB.ADD;
6068: RAISE FND_API.G_EXC_ERROR;
6069: END IF;
6070: END LOOP;

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

6091: EXCEPTION
6092: WHEN FND_API.G_EXC_ERROR THEN
6093: RAISE FND_API.G_EXC_ERROR;
6094: WHEN OTHERS THEN
6095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6096: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6092: WHEN FND_API.G_EXC_ERROR THEN
6093: RAISE FND_API.G_EXC_ERROR;
6094: WHEN OTHERS THEN
6095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6096: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6100: END check_prim_cond;

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

6093: RAISE FND_API.G_EXC_ERROR;
6094: WHEN OTHERS THEN
6095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6096: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6098: FND_MSG_PUB.ADD;
6099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6100: END check_prim_cond;
6101:

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

6137: EXIT WHEN x_secondary;
6138: END LOOP;
6139: EXCEPTION
6140: WHEN OTHERS THEN
6141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6142: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6138: END LOOP;
6139: EXCEPTION
6140: WHEN OTHERS THEN
6141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6142: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6146: END check_party_site_cond;

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

6139: EXCEPTION
6140: WHEN OTHERS THEN
6141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6142: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6146: END check_party_site_cond;
6147:

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

6193: EXIT WHEN x_secondary;
6194: END LOOP;
6195: EXCEPTION
6196: WHEN OTHERS THEN
6197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6198: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6194: END LOOP;
6195: EXCEPTION
6196: WHEN OTHERS THEN
6197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6198: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6202: END check_contact_cond;

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

6195: EXCEPTION
6196: WHEN OTHERS THEN
6197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6198: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6202: END check_contact_cond;
6203:

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

6216: x_secondary:= FALSE;
6217:
6218: FOR I IN 1..p_contact_point_list.COUNT LOOP
6219: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6220: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6221: FND_MSG_PUB.ADD;
6222: RAISE FND_API.G_EXC_ERROR;
6223: END IF;
6224: END LOOP;

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

6240: EXIT WHEN x_secondary;
6241: END LOOP;
6242: EXCEPTION
6243: WHEN OTHERS THEN
6244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6245: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6247: FND_MSG_PUB.ADD;
6248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6241: END LOOP;
6242: EXCEPTION
6243: WHEN OTHERS THEN
6244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6245: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6247: FND_MSG_PUB.ADD;
6248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6249: END check_contact_point_cond;

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

6242: EXCEPTION
6243: WHEN OTHERS THEN
6244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6245: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6247: FND_MSG_PUB.ADD;
6248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6249: END check_contact_point_cond;
6250: