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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: WHEN OTHERS THEN
4036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4037: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_persons');
4038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4039: FND_MSG_PUB.ADD;
4040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4041: END find_persons;
4042:

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

4100: RAISE FND_API.G_EXC_ERROR;
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: WHEN OTHERS THEN
4104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_party_details');
4106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4107: FND_MSG_PUB.ADD;
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_party_details');

4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: WHEN OTHERS THEN
4104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_party_details');
4106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4107: FND_MSG_PUB.ADD;
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END find_party_details;

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

4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: WHEN OTHERS THEN
4104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_party_details');
4106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4107: FND_MSG_PUB.ADD;
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END find_party_details;
4110:

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

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

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

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

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

4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: WHEN OTHERS THEN
4221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4222: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_parties');
4223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4224: FND_MSG_PUB.ADD;
4225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4226: END find_duplicate_parties;
4227:

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

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

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

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

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

4304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4305: WHEN OTHERS THEN
4306: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4307: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_party_sites');
4308: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4309: FND_MSG_PUB.ADD;
4310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4311: END find_duplicate_party_sites;
4312:

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

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

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

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

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

4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contacts');
4397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4398: FND_MSG_PUB.ADD;
4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4400: END find_duplicate_contacts;
4401:

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

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

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

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

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

4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4467: WHEN OTHERS THEN
4468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.find_duplicate_contact_points');
4470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4471: FND_MSG_PUB.ADD;
4472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4473: END find_duplicate_contact_points;
4474:

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

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

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

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

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

4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4772: WHEN OTHERS THEN
4773: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4774: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.call_api_dynamic');
4775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4776: FND_MSG_PUB.ADD;
4777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4778: END call_api_dynamic;
4779:

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

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

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

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

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

5007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5008: WHEN OTHERS THEN
5009: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5010: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_party_sites');
5011: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5012: FND_MSG_PUB.ADD;
5013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5014: END get_matching_party_sites;
5015:

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

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

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

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

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

5236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5237: WHEN OTHERS THEN
5238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contacts');
5240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5241: FND_MSG_PUB.ADD;
5242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5243: END get_matching_contacts;
5244:

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

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

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

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

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

5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_matching_contact_points');
5380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END get_matching_contact_points;
5384:

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

5592: RAISE FND_API.G_EXC_ERROR;
5593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5595: WHEN OTHERS THEN
5596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5599: FND_MSG_PUB.ADD;
5600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5595: WHEN OTHERS THEN
5596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5599: FND_MSG_PUB.ADD;
5600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5601: END get_score_details;

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

5594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5595: WHEN OTHERS THEN
5596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_6.get_score_details');
5598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5599: FND_MSG_PUB.ADD;
5600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5601: END get_score_details;
5602:

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

5715: RAISE FND_API.G_EXC_ERROR;
5716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5722: FND_MSG_PUB.ADD;
5723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5722: FND_MSG_PUB.ADD;
5723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5724: END get_party_for_search;

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

5717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5722: FND_MSG_PUB.ADD;
5723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5724: END get_party_for_search;
5725:

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

5767: RAISE FND_API.G_EXC_ERROR;
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: WHEN OTHERS THEN
5771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5772: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5773: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5774: FND_MSG_PUB.ADD;
5775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: WHEN OTHERS THEN
5771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5772: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5773: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5774: FND_MSG_PUB.ADD;
5775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5776: END get_search_criteria;

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

5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: WHEN OTHERS THEN
5771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5772: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5773: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5774: FND_MSG_PUB.ADD;
5775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5776: END get_search_criteria;
5777:

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

5831: END IF;
5832:
5833: EXCEPTION
5834: WHEN OTHERS THEN
5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;

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

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

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

5833: EXCEPTION
5834: WHEN OTHERS THEN
5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END get_party_rec;

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

5834: WHEN OTHERS THEN
5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END get_party_rec;
5842:

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

5887: END LOOP;
5888:
5889: EXCEPTION
5890: WHEN OTHERS THEN
5891: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5892: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5893: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5895: FND_MSG_PUB.ADD;

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

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

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

5889: EXCEPTION
5890: WHEN OTHERS THEN
5891: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5892: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5893: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5895: FND_MSG_PUB.ADD;
5896: RAISE FND_API.G_EXC_ERROR;
5897: END get_party_site_rec;

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

5890: WHEN OTHERS THEN
5891: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5892: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5893: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5895: FND_MSG_PUB.ADD;
5896: RAISE FND_API.G_EXC_ERROR;
5897: END get_party_site_rec;
5898:

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

5945: END LOOP;
5946:
5947: EXCEPTION
5948: WHEN OTHERS THEN
5949: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5950: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5951: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5953: FND_MSG_PUB.ADD;

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

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

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

5947: EXCEPTION
5948: WHEN OTHERS THEN
5949: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5950: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5951: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5953: FND_MSG_PUB.ADD;
5954: RAISE FND_API.G_EXC_ERROR;
5955: END get_contact_rec;

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

5948: WHEN OTHERS THEN
5949: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5950: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5951: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5953: FND_MSG_PUB.ADD;
5954: RAISE FND_API.G_EXC_ERROR;
5955: END get_contact_rec;
5956:

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

5999: END LOOP;
6000:
6001: EXCEPTION
6002: WHEN OTHERS THEN
6003: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6004: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6005: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6007: FND_MSG_PUB.ADD;

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

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

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

6001: EXCEPTION
6002: WHEN OTHERS THEN
6003: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6004: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6005: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6007: FND_MSG_PUB.ADD;
6008: RAISE FND_API.G_EXC_ERROR;
6009: END get_contact_point_rec;

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

6002: WHEN OTHERS THEN
6003: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6004: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6005: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6007: FND_MSG_PUB.ADD;
6008: RAISE FND_API.G_EXC_ERROR;
6009: END get_contact_point_rec;
6010:

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

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

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

6169: END IF;
6170: EXCEPTION
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6175: FND_MSG_PUB.ADD;
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: END;

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

6170: EXCEPTION
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6175: FND_MSG_PUB.ADD;
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: END;
6178:

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

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

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

6287: END LOOP;
6288: EXCEPTION
6289: WHEN OTHERS THEN
6290: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6291: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6293: FND_MSG_PUB.ADD;
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: END;

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

6288: EXCEPTION
6289: WHEN OTHERS THEN
6290: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6291: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6293: FND_MSG_PUB.ADD;
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: END;
6296:

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

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

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

6390: END LOOP;
6391: EXCEPTION
6392: WHEN OTHERS THEN
6393: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6394: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6398: END;

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

6391: EXCEPTION
6392: WHEN OTHERS THEN
6393: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6394: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6398: END;
6399:

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

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

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

6458: END LOOP;
6459: EXCEPTION
6460: WHEN OTHERS THEN
6461: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6462: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6463: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6464: FND_MSG_PUB.ADD;
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: END;

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

6459: EXCEPTION
6460: WHEN OTHERS THEN
6461: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6462: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6463: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6464: FND_MSG_PUB.ADD;
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: END;
6467:

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

6483: FOR I IN 1..p_contact_point_list.COUNT LOOP
6484: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6485: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6486: ) THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6488: FND_MSG_PUB.ADD;
6489: RAISE FND_API.G_EXC_ERROR;
6490: END IF;
6491: END LOOP;

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

6523: EXCEPTION
6524: WHEN FND_API.G_EXC_ERROR THEN
6525: RAISE FND_API.G_EXC_ERROR;
6526: WHEN OTHERS THEN
6527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6528: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6530: FND_MSG_PUB.ADD;
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6524: WHEN FND_API.G_EXC_ERROR THEN
6525: RAISE FND_API.G_EXC_ERROR;
6526: WHEN OTHERS THEN
6527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6528: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6530: FND_MSG_PUB.ADD;
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: END check_prim_cond;

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

6525: RAISE FND_API.G_EXC_ERROR;
6526: WHEN OTHERS THEN
6527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6528: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6530: FND_MSG_PUB.ADD;
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: END check_prim_cond;
6533:

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

6577: EXIT WHEN x_secondary;
6578: END LOOP;
6579: EXCEPTION
6580: WHEN OTHERS THEN
6581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6582: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6583: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6584: FND_MSG_PUB.ADD;
6585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6578: END LOOP;
6579: EXCEPTION
6580: WHEN OTHERS THEN
6581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6582: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6583: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6584: FND_MSG_PUB.ADD;
6585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6586: END check_party_site_cond;

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

6579: EXCEPTION
6580: WHEN OTHERS THEN
6581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6582: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6583: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6584: FND_MSG_PUB.ADD;
6585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6586: END check_party_site_cond;
6587:

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

6631: EXIT WHEN x_secondary;
6632: END LOOP;
6633: EXCEPTION
6634: WHEN OTHERS THEN
6635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6636: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6638: FND_MSG_PUB.ADD;
6639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6632: END LOOP;
6633: EXCEPTION
6634: WHEN OTHERS THEN
6635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6636: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6638: FND_MSG_PUB.ADD;
6639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6640: END check_contact_cond;

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

6633: EXCEPTION
6634: WHEN OTHERS THEN
6635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6636: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6638: FND_MSG_PUB.ADD;
6639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6640: END check_contact_cond;
6641:

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

6654: x_secondary:= FALSE;
6655:
6656: FOR I IN 1..p_contact_point_list.COUNT LOOP
6657: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6658: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6659: FND_MSG_PUB.ADD;
6660: RAISE FND_API.G_EXC_ERROR;
6661: END IF;
6662: END LOOP;

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

6676: EXIT WHEN x_secondary;
6677: END LOOP;
6678: EXCEPTION
6679: WHEN OTHERS THEN
6680: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6677: END LOOP;
6678: EXCEPTION
6679: WHEN OTHERS THEN
6680: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6685: END check_contact_point_cond;

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

6678: EXCEPTION
6679: WHEN OTHERS THEN
6680: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6685: END check_contact_point_cond;
6686: