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_DQM_DUP_ID_PKG dependencies on FND_API

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
143: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_DUP_RESULTS');
144: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
145: FND_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END;
148:
149:
150:

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
243: FND_MESSAGE.SET_TOKEN('PROC','SANITIZE_TCA_DUP_PARTIES');
244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247:
248: END;
249:
250:

Line 304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
301: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_INT_DUP_RESULTS');
302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END;
306:
307:
308:

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
418: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_PARTY_OSRS');
419: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
420: FND_MSG_PUB.ADD;
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422:
423: END;
424:
425:

Line 563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
560: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_ID');
561: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
562: FND_MSG_PUB.ADD;
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564:
565: END;
566: PROCEDURE sanitize_int_dup_detail_osrs(p_batch_id number)
567: IS

Line 680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

676: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
677: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_DETAIL_OSRS');
678: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
679: FND_MSG_PUB.ADD;
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681:
682: END;
683:
684:

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
782: FND_MESSAGE.SET_TOKEN('PROC','REPORT_TCA_DUP_PARTIES');
783: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
784: FND_MSG_PUB.ADD;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786:
787: END;
788:
789: FUNCTION check_bulk_feature return BOOLEAN IS

Line 1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1037: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_DUP_ID_WORKER');
1038: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041:
1042:
1043: END ;
1044:

Line 1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1080: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_SANITIZE_REPORT');
1081: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084:
1085:
1086: END ;
1087:

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1173: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_IMP_DUP_PARTIES');
1174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1175: FND_MSG_PUB.ADD;
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END;
1178:
1179:
1180: PROCEDURE report_int_tca_dup_parties (

Line 1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1323: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_PARTIES');
1324: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1325: FND_MSG_PUB.ADD;
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327:
1328:
1329: END ;
1330:

Line 1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_DETAILS');
1471: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END ;
1475:
1476:
1477:

Line 1496: x_return_status := FND_API.G_RET_STS_SUCCESS;

1492: l_pkg_name varchar2(2000);
1493: anon_str varchar2(255);
1494: BEGIN
1495: -- initialize API return status to success.
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1497:
1498: -- stage data into interface tables
1499: HZ_IMP_DQM_STAGE.pop_int_tca_search_tab( p_batch_id, p_match_rule_id,p_from_osr, p_to_osr,p_batch_mode_flag,
1500: x_return_status,x_msg_count,x_msg_data);

Line 1502: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1498: -- stage data into interface tables
1499: HZ_IMP_DQM_STAGE.pop_int_tca_search_tab( p_batch_id, p_match_rule_id,p_from_osr, p_to_osr,p_batch_mode_flag,
1500: x_return_status,x_msg_count,x_msg_data);
1501:
1502: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1503: THEN
1504: FND_FILE.put_line(FND_FILE.log,'Staging Unsuccessful - pop_int_tca_search_tab did not return success');
1505: return;
1506: END IF;

Line 1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1523: x_auto_merge_threshold ;
1524:
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1529: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_DUP_ID');
1530: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1531: FND_MSG_PUB.ADD;

Line 1533: p_encoded => FND_API.G_FALSE,

1529: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_DUP_ID');
1530: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1531: FND_MSG_PUB.ADD;
1532: FND_MSG_PUB.Count_And_Get(
1533: p_encoded => FND_API.G_FALSE,
1534: p_count => x_msg_count,
1535: p_data => x_msg_data);
1536:
1537: END ;

Line 1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1589: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1590: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_PARTY_DQM_ACTION_FLAG');
1591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1592: FND_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: END;
1595:
1596: PROCEDURE update_detail_dqm_action_flag (
1597: p_entity IN VARCHAR2,

Line 1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1672: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1673: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_DETAIL_DQM_ACTION_FLAG');
1674: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END;
1678:
1679:
1680: PROCEDURE final_process_int_tca_dup_id(p_batch_id IN number)

Line 1756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1753: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_ID');
1754: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1755: FND_MSG_PUB.ADD;
1756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1757:
1758: END;
1759:
1760:

Line 1774: x_return_status := FND_API.G_RET_STS_SUCCESS;

1770: IS
1771: x_party_count NUMBER := 0;
1772: BEGIN
1773: -- initialize API return status to success.
1774: x_return_status := FND_API.G_RET_STS_SUCCESS;
1775:
1776: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1777: FND_FILE.put_line(FND_FILE.log,'Entering interface_tca_sanitize_report ');
1778:

Line 1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1784:
1785:
1786: EXCEPTION
1787: WHEN OTHERS THEN
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1790: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_SANITIZE_REPORT');
1791: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1792: FND_MSG_PUB.ADD;

Line 1794: p_encoded => FND_API.G_FALSE,

1790: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_SANITIZE_REPORT');
1791: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1792: FND_MSG_PUB.ADD;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => FND_API.G_FALSE,
1795: p_count => x_msg_count,
1796: p_data => x_msg_data);
1797:
1798:

Line 1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1953: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_DUP_PARTY_OSRS');
1954: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: END ;
1958:
1959:
1960:

Line 1977: x_return_status := FND_API.G_RET_STS_SUCCESS;

1973: anon_str varchar2(255);
1974: l_pkg_name varchar2(2000);
1975: BEGIN
1976: -- initialize API return status to success.
1977: x_return_status := FND_API.G_RET_STS_SUCCESS;
1978:
1979: -- get the threshold
1980: select match_score into x_threshold
1981: from hz_match_rules_vl

Line 2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: -- dbms_output.put_line('err '||SQLERRM);
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2005: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_DUP_ID_WORKER');
2006: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2007: FND_MSG_PUB.ADD;

Line 2009: p_encoded => FND_API.G_FALSE,

2005: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_DUP_ID_WORKER');
2006: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2007: FND_MSG_PUB.ADD;
2008: FND_MSG_PUB.Count_And_Get(
2009: p_encoded => FND_API.G_FALSE,
2010: p_count => x_msg_count,
2011: p_data => x_msg_data);
2012:
2013: END ;

Line 2027: x_return_status := FND_API.G_RET_STS_SUCCESS;

2023: IS
2024: x_threshold number;
2025: BEGIN
2026: -- initialize API return status to success.
2027: x_return_status := FND_API.G_RET_STS_SUCCESS;
2028:
2029: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
2030: FND_FILE.put_line(FND_FILE.log,'Entering interface_sanitize_report ');
2031:

Line 2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2048: -- do final processing
2049: final_process_int_dup_id(p_batch_id);
2050: EXCEPTION
2051: WHEN OTHERS THEN
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2054: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_SANITIZE_REPORT');
2055: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2056: FND_MSG_PUB.ADD;

Line 2058: p_encoded => FND_API.G_FALSE,

2054: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_SANITIZE_REPORT');
2055: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2056: FND_MSG_PUB.ADD;
2057: FND_MSG_PUB.Count_And_Get(
2058: p_encoded => FND_API.G_FALSE,
2059: p_count => x_msg_count,
2060: p_data => x_msg_data);
2061:
2062:

Line 2140: x_return_status := FND_API.G_RET_STS_SUCCESS;

2136:
2137: BEGIN
2138:
2139: --Initialize API return status to success.
2140: x_return_status := FND_API.G_RET_STS_SUCCESS;
2141:
2142: -- Initialize the compiled package name
2143: l_package_name := 'HZ_IMP_MATCH_RULE_'||p_match_rule_id;
2144:

Line 2158: RAISE FND_API.G_EXC_ERROR;

2154: EXCEPTION
2155: WHEN NO_DATA_FOUND THEN
2156: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');
2157: FND_MSG_PUB.ADD;
2158: RAISE FND_API.G_EXC_ERROR;
2159: END;
2160:
2161:
2162: BEGIN

Line 2180: RAISE FND_API.G_EXC_ERROR;

2176: NULL;
2177: END;
2178: fnd_message.set_name('AR','HZ_SCORING_NO_ACQUISITION');
2179: FND_MSG_PUB.ADD;
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;
2182: CLOSE check_null_set;
2183: END;
2184:

Line 2199: RAISE FND_API.G_EXC_ERROR;

2195: END;
2196:
2197: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');
2198: FND_MSG_PUB.ADD;
2199: RAISE FND_API.G_EXC_ERROR;
2200: END IF;
2201: CLOSE check_inactive;
2202:
2203: -- Generate and compile match rule package spec

Line 2219: p_encoded => FND_API.G_FALSE,

2215:
2216:
2217: --Standard call to get message count and if count is 1, get message info.
2218: FND_MSG_PUB.Count_And_Get(
2219: p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222:
2223: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'C' WHERE MATCH_RULE_ID = p_match_rule_id;

Line 2226: WHEN FND_API.G_EXC_ERROR THEN

2222:
2223: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'C' WHERE MATCH_RULE_ID = p_match_rule_id;
2224: COMMIT;
2225: EXCEPTION
2226: WHEN FND_API.G_EXC_ERROR THEN
2227: FND_MSG_PUB.Count_And_Get(
2228: p_encoded => FND_API.G_FALSE,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data);

Line 2228: p_encoded => FND_API.G_FALSE,

2224: COMMIT;
2225: EXCEPTION
2226: WHEN FND_API.G_EXC_ERROR THEN
2227: FND_MSG_PUB.Count_And_Get(
2228: p_encoded => FND_API.G_FALSE,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data);
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;

Line 2231: x_return_status := FND_API.G_RET_STS_ERROR;

2227: FND_MSG_PUB.Count_And_Get(
2228: p_encoded => FND_API.G_FALSE,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data);
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2233: COMMIT;
2234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2235: FND_MSG_PUB.Count_And_Get(

Line 2234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2230: p_data => x_msg_data);
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2233: COMMIT;
2234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2235: FND_MSG_PUB.Count_And_Get(
2236: p_encoded => FND_API.G_FALSE,
2237: p_count => x_msg_count,
2238: p_data => x_msg_data);

Line 2236: p_encoded => FND_API.G_FALSE,

2232: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2233: COMMIT;
2234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2235: FND_MSG_PUB.Count_And_Get(
2236: p_encoded => FND_API.G_FALSE,
2237: p_count => x_msg_count,
2238: p_data => x_msg_data);
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;

Line 2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2235: FND_MSG_PUB.Count_And_Get(
2236: p_encoded => FND_API.G_FALSE,
2237: p_count => x_msg_count,
2238: p_data => x_msg_data);
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2241: COMMIT;
2242: WHEN OTHERS THEN
2243:

Line 2250: p_encoded => FND_API.G_FALSE,

2246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2247: FND_MSG_PUB.ADD;
2248:
2249: FND_MSG_PUB.Count_And_Get(
2250: p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count,
2252: p_data => x_msg_data);
2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2254: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;

Line 2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2249: FND_MSG_PUB.Count_And_Get(
2250: p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count,
2252: p_data => x_msg_data);
2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2254: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2255: COMMIT;
2256: END;
2257:

Line 2604: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2600: -- a master party id, by a smart update of an existing column
2601: --------------------------------------------------------------------------------------
2602: PROCEDURE identify_dup_sets (
2603: -- input parameters
2604: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2605: -- output parameters
2606: x_return_status OUT NOCOPY VARCHAR2,
2607: x_msg_count OUT NOCOPY NUMBER,
2608: x_msg_data OUT NOCOPY VARCHAR2

Line 2629: p_encoded => FND_API.G_FALSE,

2625:
2626:
2627: -- standard call to get message count and if count is 1, get message info.
2628: FND_MSG_PUB.Count_And_Get(
2629: p_encoded => FND_API.G_FALSE,
2630: p_count => x_msg_count,
2631: p_data => x_msg_data);
2632:
2633: