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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3822: RAISE FND_API.G_EXC_ERROR;
3823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3825: WHEN OTHERS THEN
3826: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3827: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3829: FND_MSG_PUB.ADD;
3830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3825: WHEN OTHERS THEN
3826: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3827: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_persons');
3828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3829: FND_MSG_PUB.ADD;
3830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3831: END find_persons;

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

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

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

3890: RAISE FND_API.G_EXC_ERROR;
3891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3893: WHEN OTHERS THEN
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3897: FND_MSG_PUB.ADD;
3898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3893: WHEN OTHERS THEN
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_party_details');
3896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3897: FND_MSG_PUB.ADD;
3898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3899: END find_party_details;

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

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

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

4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: WHEN OTHERS THEN
4011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4012: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4013: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4014: FND_MSG_PUB.ADD;
4015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: WHEN OTHERS THEN
4011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4012: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_parties');
4013: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4014: FND_MSG_PUB.ADD;
4015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4016: END find_duplicate_parties;

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

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

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

4092: RAISE FND_API.G_EXC_ERROR;
4093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: WHEN OTHERS THEN
4096: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4097: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4098: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4099: FND_MSG_PUB.ADD;
4100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: WHEN OTHERS THEN
4096: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4097: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_party_sites');
4098: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4099: FND_MSG_PUB.ADD;
4100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4101: END find_duplicate_party_sites;

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

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

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

4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4188: FND_MSG_PUB.ADD;
4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contacts');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4188: FND_MSG_PUB.ADD;
4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4190: END find_duplicate_contacts;

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

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

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

4254: RAISE FND_API.G_EXC_ERROR;
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4257: WHEN OTHERS THEN
4258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4261: FND_MSG_PUB.ADD;
4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4257: WHEN OTHERS THEN
4258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.find_duplicate_contact_points');
4260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4261: FND_MSG_PUB.ADD;
4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4263: END find_duplicate_contact_points;

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

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

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

4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4551: WHEN OTHERS THEN
4552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4555: FND_MSG_PUB.ADD;
4556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4551: WHEN OTHERS THEN
4552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.call_api_dynamic');
4554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4555: FND_MSG_PUB.ADD;
4556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4557: END call_api_dynamic;

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

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

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

4783: RAISE FND_API.G_EXC_ERROR;
4784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4786: WHEN OTHERS THEN
4787: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4788: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4789: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4790: FND_MSG_PUB.ADD;
4791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4786: WHEN OTHERS THEN
4787: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4788: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_party_sites');
4789: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4790: FND_MSG_PUB.ADD;
4791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4792: END get_matching_party_sites;

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

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

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

5012: RAISE FND_API.G_EXC_ERROR;
5013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: WHEN OTHERS THEN
5016: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5017: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5018: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5019: FND_MSG_PUB.ADD;
5020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: WHEN OTHERS THEN
5016: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5017: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_matching_contacts');
5018: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5019: FND_MSG_PUB.ADD;
5020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5021: END get_matching_contacts;

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

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

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','HZ_MATCH_RULE_98.get_matching_contact_points');
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','HZ_MATCH_RULE_98.get_matching_contact_points');

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','HZ_MATCH_RULE_98.get_matching_contact_points');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5163: END get_matching_contact_points;

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','HZ_MATCH_RULE_98.get_matching_contact_points');
5160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5161: FND_MSG_PUB.ADD;
5162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5163: END get_matching_contact_points;
5164:

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

5358: RAISE FND_API.G_EXC_ERROR;
5359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: WHEN OTHERS THEN
5362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5365: FND_MSG_PUB.ADD;
5366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: WHEN OTHERS THEN
5362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5365: FND_MSG_PUB.ADD;
5366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5367: END get_score_details;

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

5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: WHEN OTHERS THEN
5362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_98.get_score_details');
5364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5365: FND_MSG_PUB.ADD;
5366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5367: END get_score_details;
5368:

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

5446: RAISE FND_API.G_EXC_ERROR;
5447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5449: WHEN OTHERS THEN
5450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5451: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5453: FND_MSG_PUB.ADD;
5454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5449: WHEN OTHERS THEN
5450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5451: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5453: FND_MSG_PUB.ADD;
5454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5455: END get_party_for_search;

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

5448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5449: WHEN OTHERS THEN
5450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5451: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5453: FND_MSG_PUB.ADD;
5454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5455: END get_party_for_search;
5456:

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

5492: RAISE FND_API.G_EXC_ERROR;
5493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: WHEN OTHERS THEN
5496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5497: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5498: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5499: FND_MSG_PUB.ADD;
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: WHEN OTHERS THEN
5496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5497: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5498: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5499: FND_MSG_PUB.ADD;
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: END get_search_criteria;

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

5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: WHEN OTHERS THEN
5496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5497: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5498: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5499: FND_MSG_PUB.ADD;
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: END get_search_criteria;
5502:

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

5536: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5537:
5538: EXCEPTION
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5542: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;

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

5537:
5538: EXCEPTION
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5542: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_ERROR;

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

5538: EXCEPTION
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5542: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_ERROR;
5546: END get_party_rec;

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

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

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

5588: END LOOP;
5589:
5590: EXCEPTION
5591: WHEN OTHERS THEN
5592: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5593: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5594: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;

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

5589:
5590: EXCEPTION
5591: WHEN OTHERS THEN
5592: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5593: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5594: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;
5597: RAISE FND_API.G_EXC_ERROR;

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

5590: EXCEPTION
5591: WHEN OTHERS THEN
5592: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5593: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5594: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;
5597: RAISE FND_API.G_EXC_ERROR;
5598: END get_party_site_rec;

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

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

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

5646: END LOOP;
5647:
5648: EXCEPTION
5649: WHEN OTHERS THEN
5650: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5651: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5652: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5654: FND_MSG_PUB.ADD;

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

5647:
5648: EXCEPTION
5649: WHEN OTHERS THEN
5650: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5651: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5652: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5654: FND_MSG_PUB.ADD;
5655: RAISE FND_API.G_EXC_ERROR;

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

5648: EXCEPTION
5649: WHEN OTHERS THEN
5650: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5651: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5652: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5654: FND_MSG_PUB.ADD;
5655: RAISE FND_API.G_EXC_ERROR;
5656: END get_contact_rec;

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

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

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

5702: END LOOP;
5703:
5704: EXCEPTION
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5708: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5710: FND_MSG_PUB.ADD;

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

5703:
5704: EXCEPTION
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5708: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5710: FND_MSG_PUB.ADD;
5711: RAISE FND_API.G_EXC_ERROR;

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

5704: EXCEPTION
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5708: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5710: FND_MSG_PUB.ADD;
5711: RAISE FND_API.G_EXC_ERROR;
5712: END get_contact_point_rec;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5899: END IF;
5900: END LOOP;
5901: EXCEPTION
5902: WHEN OTHERS THEN
5903: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5904: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5906: FND_MSG_PUB.ADD;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5900: END LOOP;
5901: EXCEPTION
5902: WHEN OTHERS THEN
5903: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5904: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5906: FND_MSG_PUB.ADD;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5908: END;

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

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

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

6030: END IF;
6031: END LOOP;
6032: EXCEPTION
6033: WHEN OTHERS THEN
6034: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6035: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6036: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6037: FND_MSG_PUB.ADD;
6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6031: END LOOP;
6032: EXCEPTION
6033: WHEN OTHERS THEN
6034: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6035: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6036: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6037: FND_MSG_PUB.ADD;
6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6039: END;

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

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

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

6057: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6058: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6059: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6060: ) THEN
6061: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6062: FND_MSG_PUB.ADD;
6063: RAISE FND_API.G_EXC_ERROR;
6064: END IF;
6065: END LOOP;

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

6086: EXCEPTION
6087: WHEN FND_API.G_EXC_ERROR THEN
6088: RAISE FND_API.G_EXC_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6087: WHEN FND_API.G_EXC_ERROR THEN
6088: RAISE FND_API.G_EXC_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END check_prim_cond;

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

6088: RAISE FND_API.G_EXC_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END check_prim_cond;
6096:

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

6132: EXIT WHEN x_secondary;
6133: END LOOP;
6134: EXCEPTION
6135: WHEN OTHERS THEN
6136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6137: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6138: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6139: FND_MSG_PUB.ADD;
6140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6133: END LOOP;
6134: EXCEPTION
6135: WHEN OTHERS THEN
6136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6137: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6138: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6139: FND_MSG_PUB.ADD;
6140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6141: END check_party_site_cond;

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

6134: EXCEPTION
6135: WHEN OTHERS THEN
6136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6137: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6138: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6139: FND_MSG_PUB.ADD;
6140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6141: END check_party_site_cond;
6142:

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

6188: EXIT WHEN x_secondary;
6189: END LOOP;
6190: EXCEPTION
6191: WHEN OTHERS THEN
6192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6193: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6195: FND_MSG_PUB.ADD;
6196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6189: END LOOP;
6190: EXCEPTION
6191: WHEN OTHERS THEN
6192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6193: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6195: FND_MSG_PUB.ADD;
6196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6197: END check_contact_cond;

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

6190: EXCEPTION
6191: WHEN OTHERS THEN
6192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6193: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6195: FND_MSG_PUB.ADD;
6196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6197: END check_contact_cond;
6198:

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

6211: x_secondary:= FALSE;
6212:
6213: FOR I IN 1..p_contact_point_list.COUNT LOOP
6214: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6215: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6216: FND_MSG_PUB.ADD;
6217: RAISE FND_API.G_EXC_ERROR;
6218: END IF;
6219: END LOOP;

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

6235: EXIT WHEN x_secondary;
6236: END LOOP;
6237: EXCEPTION
6238: WHEN OTHERS THEN
6239: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6240: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6241: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6242: FND_MSG_PUB.ADD;
6243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6236: END LOOP;
6237: EXCEPTION
6238: WHEN OTHERS THEN
6239: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6240: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6241: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6242: FND_MSG_PUB.ADD;
6243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6244: END check_contact_point_cond;

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

6237: EXCEPTION
6238: WHEN OTHERS THEN
6239: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6240: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6241: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6242: FND_MSG_PUB.ADD;
6243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6244: END check_contact_point_cond;
6245: