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_MSG_PUB

Line 145: FND_MSG_PUB.ADD;

141: WHEN OTHERS THEN
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:

Line 245: FND_MSG_PUB.ADD;

241: WHEN OTHERS THEN
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:

Line 303: FND_MSG_PUB.ADD;

299: WHEN OTHERS THEN
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:

Line 420: FND_MSG_PUB.ADD;

416: WHEN OTHERS THEN
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:

Line 562: FND_MSG_PUB.ADD;

558: WHEN OTHERS THEN
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)

Line 679: FND_MSG_PUB.ADD;

675: WHEN OTHERS THEN
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:

Line 784: FND_MSG_PUB.ADD;

780: WHEN OTHERS THEN
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:

Line 1039: FND_MSG_PUB.ADD;

1035: WHEN OTHERS THEN
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 ;

Line 1082: FND_MSG_PUB.ADD;

1078: WHEN OTHERS THEN
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 ;

Line 1175: FND_MSG_PUB.ADD;

1171: WHEN OTHERS THEN
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:

Line 1325: FND_MSG_PUB.ADD;

1321: WHEN OTHERS THEN
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 ;

Line 1472: FND_MSG_PUB.ADD;

1468: WHEN OTHERS THEN
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:

Line 1531: FND_MSG_PUB.ADD;

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;
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);

Line 1532: FND_MSG_PUB.Count_And_Get(

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;
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:

Line 1592: FND_MSG_PUB.ADD;

1588: WHEN OTHERS THEN
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 (

Line 1675: FND_MSG_PUB.ADD;

1671: WHEN OTHERS THEN
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:

Line 1755: FND_MSG_PUB.ADD;

1751: WHEN OTHERS THEN
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:

Line 1792: FND_MSG_PUB.ADD;

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;
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);

Line 1793: FND_MSG_PUB.Count_And_Get(

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;
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:

Line 1955: FND_MSG_PUB.ADD;

1951: WHEN OTHERS THEN
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:

Line 2007: FND_MSG_PUB.ADD;

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;
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);

Line 2008: FND_MSG_PUB.Count_And_Get(

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;
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:

Line 2056: FND_MSG_PUB.ADD;

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;
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);

Line 2057: FND_MSG_PUB.Count_And_Get(

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;
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:

Line 2146: FND_MSG_PUB.initialize;

2142: -- Initialize the compiled package name
2143: l_package_name := 'HZ_IMP_MATCH_RULE_'||p_match_rule_id;
2144:
2145: -- Initialize message stack
2146: FND_MSG_PUB.initialize;
2147:
2148: BEGIN
2149: -- Verify that the match rule exists
2150: SELECT 1 INTO l_batch_flag

Line 2157: FND_MSG_PUB.ADD;

2153:
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:

Line 2179: FND_MSG_PUB.ADD;

2175: WHEN OTHERS THEN
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;

Line 2198: FND_MSG_PUB.ADD;

2194: NULL;
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:

Line 2218: FND_MSG_PUB.Count_And_Get(

2214: HZ_GEN_PLSQL.compile_code;
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:

Line 2227: FND_MSG_PUB.Count_And_Get(

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);
2231: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2235: FND_MSG_PUB.Count_And_Get(

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);
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2247: FND_MSG_PUB.ADD;

2243:
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2245: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
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,

Line 2249: FND_MSG_PUB.Count_And_Get(

2245: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
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;

Line 2628: FND_MSG_PUB.Count_And_Get(

2624: ret_value := stamp_trivial_dup_sets ;
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: