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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4162: RAISE FND_API.G_EXC_ERROR;
4163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: WHEN OTHERS THEN
4166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4169: FND_MSG_PUB.ADD;
4170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4165: WHEN OTHERS THEN
4166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4167: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_persons');
4168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4169: FND_MSG_PUB.ADD;
4170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4171: END find_persons;

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

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

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

4230: RAISE FND_API.G_EXC_ERROR;
4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4233: WHEN OTHERS THEN
4234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');
4236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4237: FND_MSG_PUB.ADD;
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4233: WHEN OTHERS THEN
4234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4235: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_party_details');
4236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4237: FND_MSG_PUB.ADD;
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: END find_party_details;

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

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

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

4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_parties');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: END find_duplicate_parties;

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

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

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

4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4439: FND_MSG_PUB.ADD;
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_party_sites');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4439: FND_MSG_PUB.ADD;
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: END find_duplicate_party_sites;

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

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

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

4521: RAISE FND_API.G_EXC_ERROR;
4522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4524: WHEN OTHERS THEN
4525: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4526: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4528: FND_MSG_PUB.ADD;
4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4524: WHEN OTHERS THEN
4525: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4526: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contacts');
4527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4528: FND_MSG_PUB.ADD;
4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4530: END find_duplicate_contacts;

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

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

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

4594: RAISE FND_API.G_EXC_ERROR;
4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4601: FND_MSG_PUB.ADD;
4602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.find_duplicate_contact_points');
4600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4601: FND_MSG_PUB.ADD;
4602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4603: END find_duplicate_contact_points;

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

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

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

4937: RAISE FND_API.G_EXC_ERROR;
4938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4940: WHEN OTHERS THEN
4941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4942: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4944: FND_MSG_PUB.ADD;
4945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4940: WHEN OTHERS THEN
4941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4942: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.call_api_dynamic');
4943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4944: FND_MSG_PUB.ADD;
4945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4946: END call_api_dynamic;

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

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

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

5184: RAISE FND_API.G_EXC_ERROR;
5185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: WHEN OTHERS THEN
5188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5189: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5191: FND_MSG_PUB.ADD;
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: WHEN OTHERS THEN
5188: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5189: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_party_sites');
5190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5191: FND_MSG_PUB.ADD;
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: END get_matching_party_sites;

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

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

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

5413: RAISE FND_API.G_EXC_ERROR;
5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contacts');
5419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: END get_matching_contacts;

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

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

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

5555: RAISE FND_API.G_EXC_ERROR;
5556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5561: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_matching_contact_points');
5561: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5564: END get_matching_contact_points;

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

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

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

5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5802: END get_score_details;

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

5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_38.get_score_details');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5802: END get_score_details;
5803:

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

5916: RAISE FND_API.G_EXC_ERROR;
5917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5919: WHEN OTHERS THEN
5920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5921: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5923: FND_MSG_PUB.ADD;
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5919: WHEN OTHERS THEN
5920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5921: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5923: FND_MSG_PUB.ADD;
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: END get_party_for_search;

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

5918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5919: WHEN OTHERS THEN
5920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5921: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5923: FND_MSG_PUB.ADD;
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: END get_party_for_search;
5926:

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

5968: RAISE FND_API.G_EXC_ERROR;
5969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: WHEN OTHERS THEN
5972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5973: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5975: FND_MSG_PUB.ADD;
5976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: WHEN OTHERS THEN
5972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5973: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5975: FND_MSG_PUB.ADD;
5976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5977: END get_search_criteria;

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

5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: WHEN OTHERS THEN
5972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5973: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5975: FND_MSG_PUB.ADD;
5976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5977: END get_search_criteria;
5978:

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

6012: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6013:
6014: EXCEPTION
6015: WHEN OTHERS THEN
6016: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6017: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6018: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6020: FND_MSG_PUB.ADD;

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

6013:
6014: EXCEPTION
6015: WHEN OTHERS THEN
6016: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6017: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6018: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6020: FND_MSG_PUB.ADD;
6021: RAISE FND_API.G_EXC_ERROR;

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

6014: EXCEPTION
6015: WHEN OTHERS THEN
6016: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6017: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6018: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6020: FND_MSG_PUB.ADD;
6021: RAISE FND_API.G_EXC_ERROR;
6022: END get_party_rec;

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

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

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

6078: END LOOP;
6079:
6080: EXCEPTION
6081: WHEN OTHERS THEN
6082: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6083: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6084: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;

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

6079:
6080: EXCEPTION
6081: WHEN OTHERS THEN
6082: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6083: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6084: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;
6087: RAISE FND_API.G_EXC_ERROR;

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

6080: EXCEPTION
6081: WHEN OTHERS THEN
6082: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6083: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6084: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;
6087: RAISE FND_API.G_EXC_ERROR;
6088: END get_party_site_rec;

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

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

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

6136: END LOOP;
6137:
6138: EXCEPTION
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6142: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;

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

6137:
6138: EXCEPTION
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6142: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_ERROR;

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

6138: EXCEPTION
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6142: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6144: FND_MSG_PUB.ADD;
6145: RAISE FND_API.G_EXC_ERROR;
6146: END get_contact_rec;

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

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

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

6192: END LOOP;
6193:
6194: EXCEPTION
6195: WHEN OTHERS THEN
6196: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6197: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6198: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;

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

6193:
6194: EXCEPTION
6195: WHEN OTHERS THEN
6196: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6197: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6198: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_ERROR;

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

6194: EXCEPTION
6195: WHEN OTHERS THEN
6196: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6197: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6198: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6200: FND_MSG_PUB.ADD;
6201: RAISE FND_API.G_EXC_ERROR;
6202: END get_contact_point_rec;

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

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

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

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

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

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

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

6291: EXCEPTION
6292: WHEN OTHERS THEN
6293: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6294: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6295: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6296: FND_MSG_PUB.ADD;
6297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6298: END;
6299:

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

6559: END IF;
6560: END LOOP;
6561: EXCEPTION
6562: WHEN OTHERS THEN
6563: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6564: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6566: FND_MSG_PUB.ADD;
6567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6560: END LOOP;
6561: EXCEPTION
6562: WHEN OTHERS THEN
6563: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6564: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6566: FND_MSG_PUB.ADD;
6567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6568: END;

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

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

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

6616: END IF;
6617: END LOOP;
6618: EXCEPTION
6619: WHEN OTHERS THEN
6620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6621: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6623: FND_MSG_PUB.ADD;
6624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6617: END LOOP;
6618: EXCEPTION
6619: WHEN OTHERS THEN
6620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6621: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6623: FND_MSG_PUB.ADD;
6624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6625: END;

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

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

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

6723: END IF;
6724: END LOOP;
6725: EXCEPTION
6726: WHEN OTHERS THEN
6727: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6728: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6730: FND_MSG_PUB.ADD;
6731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6724: END LOOP;
6725: EXCEPTION
6726: WHEN OTHERS THEN
6727: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6728: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6730: FND_MSG_PUB.ADD;
6731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6732: END;

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

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

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

6749: FOR I IN 1..p_contact_point_list.COUNT LOOP
6750: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6751: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6752: ) THEN
6753: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_ERROR;
6756: END IF;
6757: END LOOP;

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

6788: EXCEPTION
6789: WHEN FND_API.G_EXC_ERROR THEN
6790: RAISE FND_API.G_EXC_ERROR;
6791: WHEN OTHERS THEN
6792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6793: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6795: FND_MSG_PUB.ADD;
6796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6789: WHEN FND_API.G_EXC_ERROR THEN
6790: RAISE FND_API.G_EXC_ERROR;
6791: WHEN OTHERS THEN
6792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6793: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6795: FND_MSG_PUB.ADD;
6796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6797: END check_prim_cond;

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

6790: RAISE FND_API.G_EXC_ERROR;
6791: WHEN OTHERS THEN
6792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6793: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6795: FND_MSG_PUB.ADD;
6796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6797: END check_prim_cond;
6798:

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

6849: EXIT WHEN x_secondary;
6850: END LOOP;
6851: EXCEPTION
6852: WHEN OTHERS THEN
6853: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6854: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6855: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6856: FND_MSG_PUB.ADD;
6857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6850: END LOOP;
6851: EXCEPTION
6852: WHEN OTHERS THEN
6853: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6854: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6855: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6856: FND_MSG_PUB.ADD;
6857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6858: END check_party_site_cond;

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

6851: EXCEPTION
6852: WHEN OTHERS THEN
6853: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6854: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6855: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6856: FND_MSG_PUB.ADD;
6857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6858: END check_party_site_cond;
6859:

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

6904: EXIT WHEN x_secondary;
6905: END LOOP;
6906: EXCEPTION
6907: WHEN OTHERS THEN
6908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6909: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6911: FND_MSG_PUB.ADD;
6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6905: END LOOP;
6906: EXCEPTION
6907: WHEN OTHERS THEN
6908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6909: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6911: FND_MSG_PUB.ADD;
6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6913: END check_contact_cond;

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

6906: EXCEPTION
6907: WHEN OTHERS THEN
6908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6909: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6911: FND_MSG_PUB.ADD;
6912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6913: END check_contact_cond;
6914:

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

6927: x_secondary:= FALSE;
6928:
6929: FOR I IN 1..p_contact_point_list.COUNT LOOP
6930: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6931: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6932: FND_MSG_PUB.ADD;
6933: RAISE FND_API.G_EXC_ERROR;
6934: END IF;
6935: END LOOP;

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

6950: EXIT WHEN x_secondary;
6951: END LOOP;
6952: EXCEPTION
6953: WHEN OTHERS THEN
6954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6955: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6956: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6957: FND_MSG_PUB.ADD;
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6951: END LOOP;
6952: EXCEPTION
6953: WHEN OTHERS THEN
6954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6955: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6956: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6957: FND_MSG_PUB.ADD;
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6959: END check_contact_point_cond;

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

6952: EXCEPTION
6953: WHEN OTHERS THEN
6954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6955: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6956: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6957: FND_MSG_PUB.ADD;
6958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6959: END check_contact_point_cond;
6960: