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

937: BEGIN
938: NULL ;
939: EXCEPTION
940: WHEN OTHERS THEN
941: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
942: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
944: FND_MSG_PUB.ADD;
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

938: NULL ;
939: EXCEPTION
940: WHEN OTHERS THEN
941: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
942: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
944: FND_MSG_PUB.ADD;
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END;

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

939: EXCEPTION
940: WHEN OTHERS THEN
941: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
942: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
944: FND_MSG_PUB.ADD;
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END;
947:

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

962: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
963: END IF ;
964: EXCEPTION
965: WHEN OTHERS THEN
966: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
967: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

963: END IF ;
964: EXCEPTION
965: WHEN OTHERS THEN
966: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
967: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: END;

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

964: EXCEPTION
965: WHEN OTHERS THEN
966: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
967: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: END;
972:

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

982: BEGIN
983: NULL ;
984: EXCEPTION
985: WHEN OTHERS THEN
986: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
987: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

983: NULL ;
984: EXCEPTION
985: WHEN OTHERS THEN
986: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
987: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END;

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

984: EXCEPTION
985: WHEN OTHERS THEN
986: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
987: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END;
992:

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

1002: BEGIN
1003: NULL ;
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1003: NULL ;
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END;

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

1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END;
1012:

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

1071: IF NOT check_prim_cond (p_party_search_rec,
1072: p_party_site_list,
1073: p_contact_list,
1074: p_contact_point_list) THEN
1075: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1076: FND_MSG_PUB.ADD;
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1288: ELSE
1289: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1290: END IF;
1291: IF lengthb(l_party_contains_str) > 4000 THEN
1292: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1293: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1294: FND_MSG_PUB.ADD;
1295: RAISE FND_API.G_EXC_ERROR;
1296: END IF;

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

1289: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1290: END IF;
1291: IF lengthb(l_party_contains_str) > 4000 THEN
1292: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1293: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1294: FND_MSG_PUB.ADD;
1295: RAISE FND_API.G_EXC_ERROR;
1296: END IF;
1297: IF (p_match_str = ' AND ' OR p_party_max_score

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

1367: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1368: END LOOP;
1369: -- Add the search criteria to query string
1370: IF lengthb(l_contains_str) > 4000 THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1372: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1373: FND_MSG_PUB.ADD;
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;

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

1368: END LOOP;
1369: -- Add the search criteria to query string
1370: IF lengthb(l_contains_str) > 4000 THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1372: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1373: FND_MSG_PUB.ADD;
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376: x_denorm_str := l_den_contains_str;

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

1414: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1415: END LOOP;
1416: -- Add the search criteria to query string
1417: IF lengthb(l_contains_str) > 4000 THEN
1418: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1419: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1420: FND_MSG_PUB.ADD;
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;

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

1415: END LOOP;
1416: -- Add the search criteria to query string
1417: IF lengthb(l_contains_str) > 4000 THEN
1418: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1419: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1420: FND_MSG_PUB.ADD;
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423: x_denorm_str := l_den_contains_str;

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

1459: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1460: END LOOP;
1461: -- Add the search criteria to query string
1462: IF lengthb(l_contains_str) > 4000 THEN
1463: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1464: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1465: FND_MSG_PUB.ADD;
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;

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

1460: END LOOP;
1461: -- Add the search criteria to query string
1462: IF lengthb(l_contains_str) > 4000 THEN
1463: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1464: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1465: FND_MSG_PUB.ADD;
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468: x_denorm_str := l_den_contains_str;

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

1687: END IF;
1688: exception
1689: when others then
1690: if (instrb(SQLERRM,'DRG-51030')>0) then
1691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1692: FND_MSG_PUB.ADD;
1693: RAISE FND_API.G_EXC_ERROR;
1694: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1692: FND_MSG_PUB.ADD;
1693: RAISE FND_API.G_EXC_ERROR;
1694: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: end if;

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

1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: end if;
1708: END;

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

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

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

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

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

1940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1941: FND_MSG_PUB.ADD;
1942: RAISE FND_API.G_EXC_ERROR;
1943: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_ERROR;
1947: else
1948: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_ERROR;
1947: else
1948: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1949: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1952: end if;

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

1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_ERROR;
1947: else
1948: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1949: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1952: end if;
1953: END;

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

2079: output_long_strings('Restrict Sql = '||p_restrict_sql);
2080: exception
2081: when others then
2082: if (instrb(SQLERRM,'DRG-51030')>0) then
2083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2084: FND_MSG_PUB.ADD;
2085: RAISE FND_API.G_EXC_ERROR;
2086: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2084: FND_MSG_PUB.ADD;
2085: RAISE FND_API.G_EXC_ERROR;
2086: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2088: FND_MSG_PUB.ADD;
2089: RAISE FND_API.G_EXC_ERROR;
2090: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2087: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2088: FND_MSG_PUB.ADD;
2089: RAISE FND_API.G_EXC_ERROR;
2090: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: else
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: else
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2096: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2097: FND_MSG_PUB.ADD;
2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2099: end if;

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

2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: else
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2096: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2097: FND_MSG_PUB.ADD;
2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2099: end if;
2100: END;

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

2352: output_long_strings('Restrict Sql = '||p_restrict_sql);
2353: exception
2354: when others then
2355: if (instrb(SQLERRM,'DRG-51030')>0) then
2356: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2357: FND_MSG_PUB.ADD;
2358: RAISE FND_API.G_EXC_ERROR;
2359: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2356: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2357: FND_MSG_PUB.ADD;
2358: RAISE FND_API.G_EXC_ERROR;
2359: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2361: FND_MSG_PUB.ADD;
2362: RAISE FND_API.G_EXC_ERROR;
2363: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2361: FND_MSG_PUB.ADD;
2362: RAISE FND_API.G_EXC_ERROR;
2363: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2365: FND_MSG_PUB.ADD;
2366: RAISE FND_API.G_EXC_ERROR;
2367: else
2368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2365: FND_MSG_PUB.ADD;
2366: RAISE FND_API.G_EXC_ERROR;
2367: else
2368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2370: FND_MSG_PUB.ADD;
2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2372: end if;

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

2365: FND_MSG_PUB.ADD;
2366: RAISE FND_API.G_EXC_ERROR;
2367: else
2368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2370: FND_MSG_PUB.ADD;
2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2372: end if;
2373: END;

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

2626: IF p_index>1 THEN
2627: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2628: 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);
2629: END IF;
2630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2631: FND_MSG_PUB.ADD;
2632: RAISE FND_API.G_EXC_ERROR;
2633: ELSE
2634: push_eval;

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

2674: IF p_index>1 THEN
2675: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2676: 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);
2677: END IF;
2678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2679: FND_MSG_PUB.ADD;
2680: RAISE FND_API.G_EXC_ERROR;
2681: ELSE
2682: push_eval;

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

2747: IF p_index>1 THEN
2748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2749: 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);
2750: END IF;
2751: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2752: FND_MSG_PUB.ADD;
2753: RAISE FND_API.G_EXC_ERROR;
2754: ELSE
2755: push_eval;

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

2859: IF p_index>1 THEN
2860: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2861: 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);
2862: END IF;
2863: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2864: FND_MSG_PUB.ADD;
2865: RAISE FND_API.G_EXC_ERROR;
2866: ELSE
2867: push_eval;

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

2970: IF p_index>1 THEN
2971: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2972: 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);
2973: END IF;
2974: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2975: FND_MSG_PUB.ADD;
2976: RAISE FND_API.G_EXC_ERROR;
2977: ELSE
2978: push_eval;

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

3114: ELSE
3115: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3116: 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);
3117: END IF;
3118: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3119: FND_MSG_PUB.ADD;
3120: RAISE FND_API.G_EXC_ERROR;
3121: END IF;
3122: ELSE

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

3122: ELSE
3123: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3124: 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);
3125: END IF;
3126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3127: FND_MSG_PUB.ADD;
3128: RAISE FND_API.G_EXC_ERROR;
3129: END IF;
3130: END IF;

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

3371: RAISE FND_API.G_EXC_ERROR;
3372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: WHEN OTHERS THEN
3375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3376: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_parties');
3377: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3378: FND_MSG_PUB.ADD;
3379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3376: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_parties');

3372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: WHEN OTHERS THEN
3375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3376: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_parties');
3377: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3378: FND_MSG_PUB.ADD;
3379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3380: END find_parties;

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

3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: WHEN OTHERS THEN
3375: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3376: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_parties');
3377: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3378: FND_MSG_PUB.ADD;
3379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3380: END find_parties;
3381:

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

3574: IF p_index>1 THEN
3575: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3576: 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);
3577: END IF;
3578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3579: FND_MSG_PUB.ADD;
3580: RAISE FND_API.G_EXC_ERROR;
3581: ELSE
3582: push_eval;

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

3622: IF p_index>1 THEN
3623: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3624: 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);
3625: END IF;
3626: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3627: FND_MSG_PUB.ADD;
3628: RAISE FND_API.G_EXC_ERROR;
3629: ELSE
3630: push_eval;

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

3658: and d.search_context_id = p_search_ctx_id);
3659: exception
3660: when others then
3661: if (instrb(SQLERRM,'DRG-51030')>0) then
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3663: FND_MSG_PUB.ADD;
3664: RAISE FND_API.G_EXC_ERROR;
3665: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3663: FND_MSG_PUB.ADD;
3664: RAISE FND_API.G_EXC_ERROR;
3665: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3667: FND_MSG_PUB.ADD;
3668: RAISE FND_API.G_EXC_ERROR;
3669: else
3670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3734: IF p_index>1 THEN
3735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3736: 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);
3737: END IF;
3738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3739: FND_MSG_PUB.ADD;
3740: RAISE FND_API.G_EXC_ERROR;
3741: ELSE
3742: push_eval;

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

3923: IF p_index>1 THEN
3924: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3925: 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);
3926: END IF;
3927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3928: FND_MSG_PUB.ADD;
3929: RAISE FND_API.G_EXC_ERROR;
3930: ELSE
3931: push_eval;

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

4011: ELSE
4012: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4013: 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);
4014: END IF;
4015: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4016: FND_MSG_PUB.ADD;
4017: RAISE FND_API.G_EXC_ERROR;
4018: END IF;
4019: ELSE

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

4019: ELSE
4020: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4021: 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);
4022: END IF;
4023: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4024: FND_MSG_PUB.ADD;
4025: RAISE FND_API.G_EXC_ERROR;
4026: END IF;
4027: END IF;

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

4166: RAISE FND_API.G_EXC_ERROR;
4167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4169: WHEN OTHERS THEN
4170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4173: FND_MSG_PUB.ADD;
4174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');

4167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4169: WHEN OTHERS THEN
4170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4173: FND_MSG_PUB.ADD;
4174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4175: END find_persons;

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

4168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4169: WHEN OTHERS THEN
4170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4173: FND_MSG_PUB.ADD;
4174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4175: END find_persons;
4176:

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

4234: RAISE FND_API.G_EXC_ERROR;
4235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: WHEN OTHERS THEN
4238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');
4240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4241: FND_MSG_PUB.ADD;
4242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');

4235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: WHEN OTHERS THEN
4238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');
4240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4241: FND_MSG_PUB.ADD;
4242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4243: END find_party_details;

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

4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: WHEN OTHERS THEN
4238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4239: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');
4240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4241: FND_MSG_PUB.ADD;
4242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4243: END find_party_details;
4244:

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

4351: RAISE FND_API.G_EXC_ERROR;
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4354: WHEN OTHERS THEN
4355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4356: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4357: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4358: FND_MSG_PUB.ADD;
4359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4356: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');

4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4354: WHEN OTHERS THEN
4355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4356: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4357: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4358: FND_MSG_PUB.ADD;
4359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4360: END find_duplicate_parties;

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

4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4354: WHEN OTHERS THEN
4355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4356: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4357: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4358: FND_MSG_PUB.ADD;
4359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4360: END find_duplicate_parties;
4361:

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

4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4443: FND_MSG_PUB.ADD;
4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');

4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4443: FND_MSG_PUB.ADD;
4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4445: END find_duplicate_party_sites;

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

4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4443: FND_MSG_PUB.ADD;
4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4445: END find_duplicate_party_sites;
4446:

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

4525: RAISE FND_API.G_EXC_ERROR;
4526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4528: WHEN OTHERS THEN
4529: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4530: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4532: FND_MSG_PUB.ADD;
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4530: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');

4526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4528: WHEN OTHERS THEN
4529: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4530: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4532: FND_MSG_PUB.ADD;
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: END find_duplicate_contacts;

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

4527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4528: WHEN OTHERS THEN
4529: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4530: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4532: FND_MSG_PUB.ADD;
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: END find_duplicate_contacts;
4535:

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

4598: RAISE FND_API.G_EXC_ERROR;
4599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: WHEN OTHERS THEN
4602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4603: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4605: FND_MSG_PUB.ADD;
4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4603: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');

4599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: WHEN OTHERS THEN
4602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4603: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4605: FND_MSG_PUB.ADD;
4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4607: END find_duplicate_contact_points;

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

4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: WHEN OTHERS THEN
4602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4603: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4605: FND_MSG_PUB.ADD;
4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4607: END find_duplicate_contact_points;
4608:

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

4941: RAISE FND_API.G_EXC_ERROR;
4942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: WHEN OTHERS THEN
4945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4948: FND_MSG_PUB.ADD;
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');

4942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: WHEN OTHERS THEN
4945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4948: FND_MSG_PUB.ADD;
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: END call_api_dynamic;

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

4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: WHEN OTHERS THEN
4945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4948: FND_MSG_PUB.ADD;
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: END call_api_dynamic;
4951:

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

5188: RAISE FND_API.G_EXC_ERROR;
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: WHEN OTHERS THEN
5192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5193: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5195: FND_MSG_PUB.ADD;
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5193: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');

5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: WHEN OTHERS THEN
5192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5193: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5195: FND_MSG_PUB.ADD;
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: END get_matching_party_sites;

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

5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: WHEN OTHERS THEN
5192: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5193: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5195: FND_MSG_PUB.ADD;
5196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5197: END get_matching_party_sites;
5198:

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

5417: RAISE FND_API.G_EXC_ERROR;
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');

5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5426: END get_matching_contacts;

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

5419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5420: WHEN OTHERS THEN
5421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5422: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5426: END get_matching_contacts;
5427:

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

5559: RAISE FND_API.G_EXC_ERROR;
5560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5562: WHEN OTHERS THEN
5563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5566: FND_MSG_PUB.ADD;
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');

5560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5562: WHEN OTHERS THEN
5563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5566: FND_MSG_PUB.ADD;
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568: END get_matching_contact_points;

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

5561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5562: WHEN OTHERS THEN
5563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5566: FND_MSG_PUB.ADD;
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568: END get_matching_contact_points;
5569:

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

5798: RAISE FND_API.G_EXC_ERROR;
5799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');

5799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5807: END get_score_details;

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

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

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

5921: RAISE FND_API.G_EXC_ERROR;
5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5924: WHEN OTHERS THEN
5925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5926: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5924: WHEN OTHERS THEN
5925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5926: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: END get_party_for_search;

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

5923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5924: WHEN OTHERS THEN
5925: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5926: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: END get_party_for_search;
5931:

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

5973: RAISE FND_API.G_EXC_ERROR;
5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5980: FND_MSG_PUB.ADD;
5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5980: FND_MSG_PUB.ADD;
5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5982: END get_search_criteria;

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

5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5980: FND_MSG_PUB.ADD;
5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5982: END get_search_criteria;
5983:

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

6017: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6018:
6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6024: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6025: FND_MSG_PUB.ADD;

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

6018:
6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6024: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6025: FND_MSG_PUB.ADD;
6026: RAISE FND_API.G_EXC_ERROR;

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

6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6024: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6025: FND_MSG_PUB.ADD;
6026: RAISE FND_API.G_EXC_ERROR;
6027: END get_party_rec;

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

6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6024: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6025: FND_MSG_PUB.ADD;
6026: RAISE FND_API.G_EXC_ERROR;
6027: END get_party_rec;
6028:

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

6083: END LOOP;
6084:
6085: EXCEPTION
6086: WHEN OTHERS THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6089: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;

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

6084:
6085: EXCEPTION
6086: WHEN OTHERS THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6089: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_ERROR;

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

6085: EXCEPTION
6086: WHEN OTHERS THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6089: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_ERROR;
6093: END get_party_site_rec;

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

6086: WHEN OTHERS THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6089: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_ERROR;
6093: END get_party_site_rec;
6094:

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

6141: END LOOP;
6142:
6143: EXCEPTION
6144: WHEN OTHERS THEN
6145: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6146: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6147: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6149: FND_MSG_PUB.ADD;

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

6142:
6143: EXCEPTION
6144: WHEN OTHERS THEN
6145: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6146: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6147: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6149: FND_MSG_PUB.ADD;
6150: RAISE FND_API.G_EXC_ERROR;

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

6143: EXCEPTION
6144: WHEN OTHERS THEN
6145: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6146: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6147: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6149: FND_MSG_PUB.ADD;
6150: RAISE FND_API.G_EXC_ERROR;
6151: END get_contact_rec;

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

6144: WHEN OTHERS THEN
6145: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6146: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6147: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6149: FND_MSG_PUB.ADD;
6150: RAISE FND_API.G_EXC_ERROR;
6151: END get_contact_rec;
6152:

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

6197: END LOOP;
6198:
6199: EXCEPTION
6200: WHEN OTHERS THEN
6201: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6202: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6203: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6205: FND_MSG_PUB.ADD;

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

6198:
6199: EXCEPTION
6200: WHEN OTHERS THEN
6201: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6202: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6203: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6205: FND_MSG_PUB.ADD;
6206: RAISE FND_API.G_EXC_ERROR;

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

6199: EXCEPTION
6200: WHEN OTHERS THEN
6201: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6202: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6203: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6205: FND_MSG_PUB.ADD;
6206: RAISE FND_API.G_EXC_ERROR;
6207: END get_contact_point_rec;

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

6200: WHEN OTHERS THEN
6201: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6202: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6203: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6205: FND_MSG_PUB.ADD;
6206: RAISE FND_API.G_EXC_ERROR;
6207: END get_contact_point_rec;
6208:

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

6294: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6295: END IF;
6296: EXCEPTION
6297: WHEN OTHERS THEN
6298: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6299: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6301: FND_MSG_PUB.ADD;
6302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6295: END IF;
6296: EXCEPTION
6297: WHEN OTHERS THEN
6298: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6299: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6301: FND_MSG_PUB.ADD;
6302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6303: END;

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

6296: EXCEPTION
6297: WHEN OTHERS THEN
6298: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6299: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6301: FND_MSG_PUB.ADD;
6302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6303: END;
6304:

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

6564: END IF;
6565: END LOOP;
6566: EXCEPTION
6567: WHEN OTHERS THEN
6568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6571: FND_MSG_PUB.ADD;
6572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6565: END LOOP;
6566: EXCEPTION
6567: WHEN OTHERS THEN
6568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6571: FND_MSG_PUB.ADD;
6572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6573: END;

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

6566: EXCEPTION
6567: WHEN OTHERS THEN
6568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6571: FND_MSG_PUB.ADD;
6572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6573: END;
6574:

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

6621: END IF;
6622: END LOOP;
6623: EXCEPTION
6624: WHEN OTHERS THEN
6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6628: FND_MSG_PUB.ADD;
6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6622: END LOOP;
6623: EXCEPTION
6624: WHEN OTHERS THEN
6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6628: FND_MSG_PUB.ADD;
6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6630: END;

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

6623: EXCEPTION
6624: WHEN OTHERS THEN
6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6628: FND_MSG_PUB.ADD;
6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6630: END;
6631:

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

6728: END IF;
6729: END LOOP;
6730: EXCEPTION
6731: WHEN OTHERS THEN
6732: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6733: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6735: FND_MSG_PUB.ADD;
6736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6729: END LOOP;
6730: EXCEPTION
6731: WHEN OTHERS THEN
6732: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6733: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6735: FND_MSG_PUB.ADD;
6736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6737: END;

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

6730: EXCEPTION
6731: WHEN OTHERS THEN
6732: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6733: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6735: FND_MSG_PUB.ADD;
6736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6737: END;
6738:

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

6754: FOR I IN 1..p_contact_point_list.COUNT LOOP
6755: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6756: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6757: ) THEN
6758: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6759: FND_MSG_PUB.ADD;
6760: RAISE FND_API.G_EXC_ERROR;
6761: END IF;
6762: END LOOP;

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

6793: EXCEPTION
6794: WHEN FND_API.G_EXC_ERROR THEN
6795: RAISE FND_API.G_EXC_ERROR;
6796: WHEN OTHERS THEN
6797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6798: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6800: FND_MSG_PUB.ADD;
6801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6794: WHEN FND_API.G_EXC_ERROR THEN
6795: RAISE FND_API.G_EXC_ERROR;
6796: WHEN OTHERS THEN
6797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6798: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6800: FND_MSG_PUB.ADD;
6801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6802: END check_prim_cond;

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

6795: RAISE FND_API.G_EXC_ERROR;
6796: WHEN OTHERS THEN
6797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6798: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6800: FND_MSG_PUB.ADD;
6801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6802: END check_prim_cond;
6803:

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

6854: EXIT WHEN x_secondary;
6855: END LOOP;
6856: EXCEPTION
6857: WHEN OTHERS THEN
6858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6859: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6861: FND_MSG_PUB.ADD;
6862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6855: END LOOP;
6856: EXCEPTION
6857: WHEN OTHERS THEN
6858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6859: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6861: FND_MSG_PUB.ADD;
6862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6863: END check_party_site_cond;

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

6856: EXCEPTION
6857: WHEN OTHERS THEN
6858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6859: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6861: FND_MSG_PUB.ADD;
6862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6863: END check_party_site_cond;
6864:

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

6909: EXIT WHEN x_secondary;
6910: END LOOP;
6911: EXCEPTION
6912: WHEN OTHERS THEN
6913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6914: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6916: FND_MSG_PUB.ADD;
6917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6910: END LOOP;
6911: EXCEPTION
6912: WHEN OTHERS THEN
6913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6914: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6916: FND_MSG_PUB.ADD;
6917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6918: END check_contact_cond;

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

6911: EXCEPTION
6912: WHEN OTHERS THEN
6913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6914: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6916: FND_MSG_PUB.ADD;
6917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6918: END check_contact_cond;
6919:

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

6932: x_secondary:= FALSE;
6933:
6934: FOR I IN 1..p_contact_point_list.COUNT LOOP
6935: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6936: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6937: FND_MSG_PUB.ADD;
6938: RAISE FND_API.G_EXC_ERROR;
6939: END IF;
6940: END LOOP;

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

6955: EXIT WHEN x_secondary;
6956: END LOOP;
6957: EXCEPTION
6958: WHEN OTHERS THEN
6959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6960: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6962: FND_MSG_PUB.ADD;
6963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6956: END LOOP;
6957: EXCEPTION
6958: WHEN OTHERS THEN
6959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6960: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6962: FND_MSG_PUB.ADD;
6963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6964: END check_contact_point_cond;

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

6957: EXCEPTION
6958: WHEN OTHERS THEN
6959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6960: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6962: FND_MSG_PUB.ADD;
6963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6964: END check_contact_point_cond;
6965: