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

793: BEGIN
794: NULL ;
795: EXCEPTION
796: WHEN OTHERS THEN
797: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
798: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

794: NULL ;
795: EXCEPTION
796: WHEN OTHERS THEN
797: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
798: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
802: END;

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

795: EXCEPTION
796: WHEN OTHERS THEN
797: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
798: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
802: END;
803:

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

813: BEGIN
814: NULL ;
815: EXCEPTION
816: WHEN OTHERS THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
818: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

814: NULL ;
815: EXCEPTION
816: WHEN OTHERS THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
818: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END;

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

815: EXCEPTION
816: WHEN OTHERS THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
818: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END;
823:

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

833: BEGIN
834: NULL ;
835: EXCEPTION
836: WHEN OTHERS THEN
837: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
838: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
839: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

834: NULL ;
835: EXCEPTION
836: WHEN OTHERS THEN
837: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
838: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
839: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END;

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

835: EXCEPTION
836: WHEN OTHERS THEN
837: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
838: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
839: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END;
843:

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

853: BEGIN
854: NULL ;
855: EXCEPTION
856: WHEN OTHERS THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
858: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

854: NULL ;
855: EXCEPTION
856: WHEN OTHERS THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
858: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END;

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

855: EXCEPTION
856: WHEN OTHERS THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
858: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
859: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END;
863:

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

922: IF NOT check_prim_cond (p_party_search_rec,
923: p_party_site_list,
924: p_contact_list,
925: p_contact_point_list) THEN
926: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1179: ELSE
1180: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1181: END IF;
1182: IF lengthb(l_party_contains_str) > 4000 THEN
1183: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1184: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1185: FND_MSG_PUB.ADD;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;

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

1180: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1181: END IF;
1182: IF lengthb(l_party_contains_str) > 4000 THEN
1183: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1184: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1185: FND_MSG_PUB.ADD;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: IF (p_match_str = ' AND ' OR p_party_max_score

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

1248: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1249: END LOOP;
1250: -- Add the search criteria to query string
1251: IF lengthb(l_contains_str) > 4000 THEN
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_ERROR;
1256: END IF;

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

1249: END LOOP;
1250: -- Add the search criteria to query string
1251: IF lengthb(l_contains_str) > 4000 THEN
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_ERROR;
1256: END IF;
1257: x_denorm_str := l_den_contains_str;

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

1292: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1293: END LOOP;
1294: -- Add the search criteria to query string
1295: IF lengthb(l_contains_str) > 4000 THEN
1296: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1297: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1298: FND_MSG_PUB.ADD;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;

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

1293: END LOOP;
1294: -- Add the search criteria to query string
1295: IF lengthb(l_contains_str) > 4000 THEN
1296: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1297: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1298: FND_MSG_PUB.ADD;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301: x_denorm_str := l_den_contains_str;

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

1337: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1338: END LOOP;
1339: -- Add the search criteria to query string
1340: IF lengthb(l_contains_str) > 4000 THEN
1341: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1342: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1343: FND_MSG_PUB.ADD;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;

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

1338: END LOOP;
1339: -- Add the search criteria to query string
1340: IF lengthb(l_contains_str) > 4000 THEN
1341: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1342: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1343: FND_MSG_PUB.ADD;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346: x_denorm_str := l_den_contains_str;

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

1563: END IF;
1564: exception
1565: when others then
1566: if (instrb(SQLERRM,'DRG-51030')>0) then
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1568: FND_MSG_PUB.ADD;
1569: RAISE FND_API.G_EXC_ERROR;
1570: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1567: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1568: FND_MSG_PUB.ADD;
1569: RAISE FND_API.G_EXC_ERROR;
1570: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1572: FND_MSG_PUB.ADD;
1573: RAISE FND_API.G_EXC_ERROR;
1574: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1576: FND_MSG_PUB.ADD;
1577: RAISE FND_API.G_EXC_ERROR;
1578: else
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1576: FND_MSG_PUB.ADD;
1577: RAISE FND_API.G_EXC_ERROR;
1578: else
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: end if;

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

1576: FND_MSG_PUB.ADD;
1577: RAISE FND_API.G_EXC_ERROR;
1578: else
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: end if;
1584: END;

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

1808: output_long_strings('Restrict Sql = '||p_restrict_sql);
1809: exception
1810: when others then
1811: if (instrb(SQLERRM,'DRG-51030')>0) then
1812: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1813: FND_MSG_PUB.ADD;
1814: RAISE FND_API.G_EXC_ERROR;
1815: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1812: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1813: FND_MSG_PUB.ADD;
1814: RAISE FND_API.G_EXC_ERROR;
1815: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1821: FND_MSG_PUB.ADD;
1822: RAISE FND_API.G_EXC_ERROR;
1823: else
1824: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1821: FND_MSG_PUB.ADD;
1822: RAISE FND_API.G_EXC_ERROR;
1823: else
1824: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1828: end if;

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

1821: FND_MSG_PUB.ADD;
1822: RAISE FND_API.G_EXC_ERROR;
1823: else
1824: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1828: end if;
1829: END;

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

1955: output_long_strings('Restrict Sql = '||p_restrict_sql);
1956: exception
1957: when others then
1958: if (instrb(SQLERRM,'DRG-51030')>0) then
1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;

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

1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;
1976: END;

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

2228: output_long_strings('Restrict Sql = '||p_restrict_sql);
2229: exception
2230: when others then
2231: if (instrb(SQLERRM,'DRG-51030')>0) then
2232: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;
2235: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2232: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;
2235: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2237: FND_MSG_PUB.ADD;
2238: RAISE FND_API.G_EXC_ERROR;
2239: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2237: FND_MSG_PUB.ADD;
2238: RAISE FND_API.G_EXC_ERROR;
2239: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: else
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: else
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2245: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2248: end if;

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

2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: else
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2245: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2248: end if;
2249: END;

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

2495: IF p_index>1 THEN
2496: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2497: 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);
2498: END IF;
2499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2500: FND_MSG_PUB.ADD;
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSE
2503: push_eval;

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

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

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

2616: IF p_index>1 THEN
2617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2618: 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);
2619: END IF;
2620: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2621: FND_MSG_PUB.ADD;
2622: RAISE FND_API.G_EXC_ERROR;
2623: ELSE
2624: push_eval;

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

2728: IF p_index>1 THEN
2729: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2730: 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);
2731: END IF;
2732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2733: FND_MSG_PUB.ADD;
2734: RAISE FND_API.G_EXC_ERROR;
2735: ELSE
2736: push_eval;

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

2839: IF p_index>1 THEN
2840: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2841: 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);
2842: END IF;
2843: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2844: FND_MSG_PUB.ADD;
2845: RAISE FND_API.G_EXC_ERROR;
2846: ELSE
2847: push_eval;

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

2983: ELSE
2984: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2985: 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);
2986: END IF;
2987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2988: FND_MSG_PUB.ADD;
2989: RAISE FND_API.G_EXC_ERROR;
2990: END IF;
2991: ELSE

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

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

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

3240: RAISE FND_API.G_EXC_ERROR;
3241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: WHEN OTHERS THEN
3244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3245: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');
3246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3247: FND_MSG_PUB.ADD;
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3245: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');

3241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: WHEN OTHERS THEN
3244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3245: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');
3246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3247: FND_MSG_PUB.ADD;
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3249: END find_parties;

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

3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: WHEN OTHERS THEN
3244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3245: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_parties');
3246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3247: FND_MSG_PUB.ADD;
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3249: END find_parties;
3250:

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

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

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

3484: IF p_index>1 THEN
3485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3486: 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);
3487: END IF;
3488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3489: FND_MSG_PUB.ADD;
3490: RAISE FND_API.G_EXC_ERROR;
3491: ELSE
3492: push_eval;

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

3520: and d.search_context_id = p_search_ctx_id);
3521: exception
3522: when others then
3523: if (instrb(SQLERRM,'DRG-51030')>0) then
3524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3525: FND_MSG_PUB.ADD;
3526: RAISE FND_API.G_EXC_ERROR;
3527: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3525: FND_MSG_PUB.ADD;
3526: RAISE FND_API.G_EXC_ERROR;
3527: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3529: FND_MSG_PUB.ADD;
3530: RAISE FND_API.G_EXC_ERROR;
3531: else
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3596: IF p_index>1 THEN
3597: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3598: 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);
3599: END IF;
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;
3603: ELSE
3604: push_eval;

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

3785: IF p_index>1 THEN
3786: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3787: 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);
3788: END IF;
3789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3790: FND_MSG_PUB.ADD;
3791: RAISE FND_API.G_EXC_ERROR;
3792: ELSE
3793: push_eval;

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

3873: ELSE
3874: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3875: 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);
3876: END IF;
3877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3878: FND_MSG_PUB.ADD;
3879: RAISE FND_API.G_EXC_ERROR;
3880: END IF;
3881: ELSE

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

3881: ELSE
3882: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3883: 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);
3884: END IF;
3885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3886: FND_MSG_PUB.ADD;
3887: RAISE FND_API.G_EXC_ERROR;
3888: END IF;
3889: END IF;

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

4028: RAISE FND_API.G_EXC_ERROR;
4029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: WHEN OTHERS THEN
4032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4033: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');
4034: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4035: FND_MSG_PUB.ADD;
4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4033: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');

4029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: WHEN OTHERS THEN
4032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4033: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');
4034: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4035: FND_MSG_PUB.ADD;
4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4037: END find_persons;

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

4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: WHEN OTHERS THEN
4032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4033: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');
4034: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4035: FND_MSG_PUB.ADD;
4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4037: END find_persons;
4038:

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_6.find_party_details');
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_6.find_party_details');

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_6.find_party_details');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4103: FND_MSG_PUB.ADD;
4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4105: END find_party_details;

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_6.find_party_details');
4102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4103: FND_MSG_PUB.ADD;
4104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4105: END find_party_details;
4106:

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

4213: RAISE FND_API.G_EXC_ERROR;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4216: WHEN OTHERS THEN
4217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');
4219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');

4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4216: WHEN OTHERS THEN
4217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');
4219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4222: END find_duplicate_parties;

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

4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4216: WHEN OTHERS THEN
4217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');
4219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4222: END find_duplicate_parties;
4223:

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

4298: RAISE FND_API.G_EXC_ERROR;
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: WHEN OTHERS THEN
4302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4303: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');
4304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4305: FND_MSG_PUB.ADD;
4306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4303: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');

4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: WHEN OTHERS THEN
4302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4303: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');
4304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4305: FND_MSG_PUB.ADD;
4306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4307: END find_duplicate_party_sites;

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

4300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4301: WHEN OTHERS THEN
4302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4303: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');
4304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4305: FND_MSG_PUB.ADD;
4306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4307: END find_duplicate_party_sites;
4308:

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

4387: RAISE FND_API.G_EXC_ERROR;
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4390: WHEN OTHERS THEN
4391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4392: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');
4393: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4394: FND_MSG_PUB.ADD;
4395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4392: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');

4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4390: WHEN OTHERS THEN
4391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4392: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');
4393: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4394: FND_MSG_PUB.ADD;
4395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4396: END find_duplicate_contacts;

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

4389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4390: WHEN OTHERS THEN
4391: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4392: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');
4393: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4394: FND_MSG_PUB.ADD;
4395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4396: END find_duplicate_contacts;
4397:

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

4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');

4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END find_duplicate_contact_points;

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

4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END find_duplicate_contact_points;
4470:

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

4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');

4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4774: END call_api_dynamic;

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

4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4774: END call_api_dynamic;
4775:

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

5001: RAISE FND_API.G_EXC_ERROR;
5002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5004: WHEN OTHERS THEN
5005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5006: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');
5007: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5008: FND_MSG_PUB.ADD;
5009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5006: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');

5002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5004: WHEN OTHERS THEN
5005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5006: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');
5007: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5008: FND_MSG_PUB.ADD;
5009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5010: END get_matching_party_sites;

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

5003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5004: WHEN OTHERS THEN
5005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5006: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');
5007: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5008: FND_MSG_PUB.ADD;
5009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5010: END get_matching_party_sites;
5011:

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

5230: RAISE FND_API.G_EXC_ERROR;
5231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5233: WHEN OTHERS THEN
5234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');
5236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5237: FND_MSG_PUB.ADD;
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');

5231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5233: WHEN OTHERS THEN
5234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');
5236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5237: FND_MSG_PUB.ADD;
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239: END get_matching_contacts;

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

5232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5233: WHEN OTHERS THEN
5234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');
5236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5237: FND_MSG_PUB.ADD;
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239: END get_matching_contacts;
5240:

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

5370: RAISE FND_API.G_EXC_ERROR;
5371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5373: WHEN OTHERS THEN
5374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5375: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5377: FND_MSG_PUB.ADD;
5378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5375: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');

5371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5373: WHEN OTHERS THEN
5374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5375: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5377: FND_MSG_PUB.ADD;
5378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5379: END get_matching_contact_points;

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

5372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5373: WHEN OTHERS THEN
5374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5375: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5377: FND_MSG_PUB.ADD;
5378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5379: END get_matching_contact_points;
5380:

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

5587: RAISE FND_API.G_EXC_ERROR;
5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5594: FND_MSG_PUB.ADD;
5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');

5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5594: FND_MSG_PUB.ADD;
5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5596: END get_score_details;

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

5589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5592: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5594: FND_MSG_PUB.ADD;
5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5596: END get_score_details;
5597:

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

5710: RAISE FND_API.G_EXC_ERROR;
5711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5717: FND_MSG_PUB.ADD;
5718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5717: FND_MSG_PUB.ADD;
5718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5719: END get_party_for_search;

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

5712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5717: FND_MSG_PUB.ADD;
5718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5719: END get_party_for_search;
5720:

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

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

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

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

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

5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: WHEN OTHERS THEN
5766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5767: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5769: FND_MSG_PUB.ADD;
5770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5771: END get_search_criteria;
5772:

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

5826: END IF;
5827:
5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;

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

5827:
5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;

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

5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_party_rec;

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

5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_party_rec;
5837:

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

5882: END LOOP;
5883:
5884: EXCEPTION
5885: WHEN OTHERS THEN
5886: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5887: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5888: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5890: FND_MSG_PUB.ADD;

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

5883:
5884: EXCEPTION
5885: WHEN OTHERS THEN
5886: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5887: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5888: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5890: FND_MSG_PUB.ADD;
5891: RAISE FND_API.G_EXC_ERROR;

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

5884: EXCEPTION
5885: WHEN OTHERS THEN
5886: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5887: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5888: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5890: FND_MSG_PUB.ADD;
5891: RAISE FND_API.G_EXC_ERROR;
5892: END get_party_site_rec;

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

5885: WHEN OTHERS THEN
5886: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5887: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5888: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5890: FND_MSG_PUB.ADD;
5891: RAISE FND_API.G_EXC_ERROR;
5892: END get_party_site_rec;
5893:

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

5940: END LOOP;
5941:
5942: EXCEPTION
5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5946: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5948: FND_MSG_PUB.ADD;

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

5941:
5942: EXCEPTION
5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5946: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_ERROR;

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

5942: EXCEPTION
5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5946: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_ERROR;
5950: END get_contact_rec;

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

5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5946: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_ERROR;
5950: END get_contact_rec;
5951:

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

5994: END LOOP;
5995:
5996: EXCEPTION
5997: WHEN OTHERS THEN
5998: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5999: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6000: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6001: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6002: FND_MSG_PUB.ADD;

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

5995:
5996: EXCEPTION
5997: WHEN OTHERS THEN
5998: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5999: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6000: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6001: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6002: FND_MSG_PUB.ADD;
6003: RAISE FND_API.G_EXC_ERROR;

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

5996: EXCEPTION
5997: WHEN OTHERS THEN
5998: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5999: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6000: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6001: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6002: FND_MSG_PUB.ADD;
6003: RAISE FND_API.G_EXC_ERROR;
6004: END get_contact_point_rec;

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

5997: WHEN OTHERS THEN
5998: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5999: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6000: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6001: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6002: FND_MSG_PUB.ADD;
6003: RAISE FND_API.G_EXC_ERROR;
6004: END get_contact_point_rec;
6005:

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

6163: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6164: END IF;
6165: EXCEPTION
6166: WHEN OTHERS THEN
6167: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6168: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6170: FND_MSG_PUB.ADD;
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6164: END IF;
6165: EXCEPTION
6166: WHEN OTHERS THEN
6167: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6168: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6170: FND_MSG_PUB.ADD;
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: END;

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

6165: EXCEPTION
6166: WHEN OTHERS THEN
6167: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6168: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6170: FND_MSG_PUB.ADD;
6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: END;
6173:

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

6281: END IF;
6282: END LOOP;
6283: EXCEPTION
6284: WHEN OTHERS THEN
6285: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6286: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6287: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6288: FND_MSG_PUB.ADD;
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6282: END LOOP;
6283: EXCEPTION
6284: WHEN OTHERS THEN
6285: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6286: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6287: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6288: FND_MSG_PUB.ADD;
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: END;

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

6283: EXCEPTION
6284: WHEN OTHERS THEN
6285: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6286: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6287: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6288: FND_MSG_PUB.ADD;
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: END;
6291:

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

6384: END IF;
6385: END LOOP;
6386: EXCEPTION
6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6385: END LOOP;
6386: EXCEPTION
6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6393: END;

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

6386: EXCEPTION
6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6393: END;
6394:

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

6452: END IF;
6453: END LOOP;
6454: EXCEPTION
6455: WHEN OTHERS THEN
6456: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6459: FND_MSG_PUB.ADD;
6460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6453: END LOOP;
6454: EXCEPTION
6455: WHEN OTHERS THEN
6456: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6459: FND_MSG_PUB.ADD;
6460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6461: END;

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

6454: EXCEPTION
6455: WHEN OTHERS THEN
6456: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6459: FND_MSG_PUB.ADD;
6460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6461: END;
6462:

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

6478: FOR I IN 1..p_contact_point_list.COUNT LOOP
6479: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6480: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6481: ) THEN
6482: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6483: FND_MSG_PUB.ADD;
6484: RAISE FND_API.G_EXC_ERROR;
6485: END IF;
6486: END LOOP;

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

6518: EXCEPTION
6519: WHEN FND_API.G_EXC_ERROR THEN
6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN OTHERS THEN
6522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6523: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6525: FND_MSG_PUB.ADD;
6526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6519: WHEN FND_API.G_EXC_ERROR THEN
6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN OTHERS THEN
6522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6523: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6525: FND_MSG_PUB.ADD;
6526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6527: END check_prim_cond;

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

6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN OTHERS THEN
6522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6523: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6525: FND_MSG_PUB.ADD;
6526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6527: END check_prim_cond;
6528:

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

6572: EXIT WHEN x_secondary;
6573: END LOOP;
6574: EXCEPTION
6575: WHEN OTHERS THEN
6576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6577: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6573: END LOOP;
6574: EXCEPTION
6575: WHEN OTHERS THEN
6576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6577: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6581: END check_party_site_cond;

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

6574: EXCEPTION
6575: WHEN OTHERS THEN
6576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6577: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6581: END check_party_site_cond;
6582:

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

6626: EXIT WHEN x_secondary;
6627: END LOOP;
6628: EXCEPTION
6629: WHEN OTHERS THEN
6630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6631: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6627: END LOOP;
6628: EXCEPTION
6629: WHEN OTHERS THEN
6630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6631: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6635: END check_contact_cond;

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

6628: EXCEPTION
6629: WHEN OTHERS THEN
6630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6631: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6635: END check_contact_cond;
6636:

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

6649: x_secondary:= FALSE;
6650:
6651: FOR I IN 1..p_contact_point_list.COUNT LOOP
6652: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6653: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_ERROR;
6656: END IF;
6657: END LOOP;

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

6671: EXIT WHEN x_secondary;
6672: END LOOP;
6673: EXCEPTION
6674: WHEN OTHERS THEN
6675: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6676: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6677: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6678: FND_MSG_PUB.ADD;
6679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6672: END LOOP;
6673: EXCEPTION
6674: WHEN OTHERS THEN
6675: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6676: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6677: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6678: FND_MSG_PUB.ADD;
6679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6680: END check_contact_point_cond;

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

6673: EXCEPTION
6674: WHEN OTHERS THEN
6675: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6676: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6677: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6678: FND_MSG_PUB.ADD;
6679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6680: END check_contact_point_cond;
6681: