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.CZ_RULE_IMPORT dependencies on FND_API

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

329: CLOSE c_rec;
330: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
331: x_msg_count := 1;
332: report(x_msg_data, p_run_id, 'cnd_rules', v_debug);
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: RAISE CZRI_ERR_FATAL_ERROR;
335: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
336: CLOSE c_rec;
337: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

336: CLOSE c_rec;
337: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
338: x_msg_count := 1;
339: report(x_msg_data, p_run_id, 'cnd_rules', v_debug);
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341: RAISE CZRI_ERR_FATAL_ERROR;
342: END;
343: ---------------------------------------------------------------------------------------
344: PROCEDURE krs_rules(p_api_version IN NUMBER,

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

540: CLOSE c_rec;
541: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
542: x_msg_count := 1;
543: report(x_msg_data, p_run_id, 'krs_rules', v_debug);
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: RAISE CZRI_ERR_FATAL_ERROR;
546: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
547: CLOSE c_rec;
548: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

547: CLOSE c_rec;
548: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
549: x_msg_count := 1;
550: report(x_msg_data, p_run_id, 'krs_rules', v_debug);
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: RAISE CZRI_ERR_FATAL_ERROR;
553: END;
554: ---------------------------------------------------------------------------------------
555: PROCEDURE xfr_rules(p_api_version IN NUMBER,

Line 1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1169: CLOSE c_rec;
1170: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1171: x_msg_count := 1;
1172: report(x_msg_data, p_run_id, 'xfr_rules', v_debug);
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174: RAISE CZRI_ERR_FATAL_ERROR;
1175: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1176: CLOSE c_rec;
1177: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1176: CLOSE c_rec;
1177: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1178: x_msg_count := 1;
1179: report(x_msg_data, p_run_id, 'xfr_rules', v_debug);
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1181: RAISE CZRI_ERR_FATAL_ERROR;
1182: END;
1183: ---------------------------------------------------------------------------------------
1184: PROCEDURE rpt_rules(p_api_version IN NUMBER,

Line 1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1205: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1206: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1207: x_msg_count := 1;
1208: report(x_msg_data, p_run_id, 'rpt_rules', v_debug);
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: RAISE CZRI_ERR_REPORT_ERROR;
1211: END;
1212: ---------------------------------------------------------------------------------------
1213: PROCEDURE restat_rules(p_api_version IN NUMBER,

Line 1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1432: CLOSE c_rec;
1433: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1434: x_msg_count := 1;
1435: report(x_msg_data, p_run_id, 'cnd_localized_texts', v_debug);
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437: RAISE CZRI_ERR_FATAL_ERROR;
1438: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1439: CLOSE c_rec;
1440: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1439: CLOSE c_rec;
1440: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1441: x_msg_count := 1;
1442: report(x_msg_data, p_run_id, 'cnd_localized_texts', v_debug);
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: RAISE CZRI_ERR_FATAL_ERROR;
1445: END;
1446: ---------------------------------------------------------------------------------------
1447: PROCEDURE krs_localized_texts(p_api_version IN NUMBER,

Line 1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1626: CLOSE c_rec;
1627: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1628: x_msg_count := 1;
1629: report(x_msg_data, p_run_id, 'krs_localized_texts', v_debug);
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1631: RAISE CZRI_ERR_FATAL_ERROR;
1632: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1633: CLOSE c_rec;
1634: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1633: CLOSE c_rec;
1634: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1635: x_msg_count := 1;
1636: report(x_msg_data, p_run_id, 'krs_localized_texts', v_debug);
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: RAISE CZRI_ERR_FATAL_ERROR;
1639: END;
1640: ---------------------------------------------------------------------------------------
1641: PROCEDURE xfr_localized_texts(p_api_version IN NUMBER,

Line 1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1930: CLOSE c_rec;
1931: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1932: x_msg_count := 1;
1933: report(x_msg_data, p_run_id, 'xfr_localized_texts', v_debug);
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: RAISE CZRI_ERR_FATAL_ERROR;
1936: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1937: CLOSE c_rec;
1938: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 1941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1937: CLOSE c_rec;
1938: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1939: x_msg_count := 1;
1940: report(x_msg_data, p_run_id, 'xfr_localized_texts', v_debug);
1941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1942: RAISE CZRI_ERR_FATAL_ERROR;
1943: END;
1944: ---------------------------------------------------------------------------------------
1945: PROCEDURE rpt_localized_texts(p_api_version IN NUMBER,

Line 1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1967: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1968: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1969: x_msg_count := 1;
1970: report(x_msg_data, p_run_id, 'rpt_localized_texts', v_debug);
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: RAISE CZRI_ERR_REPORT_ERROR;
1973: END;
1974: ---------------------------------------------------------------------------------------
1975: PROCEDURE restat_localized_texts(p_api_version IN NUMBER,

Line 2053: x_return_status := FND_API.G_RET_STS_SUCCESS;

2049: v_debug NUMBER := 12000;
2050: BEGIN
2051:
2052: x_msg_count := 0;
2053: x_return_status := FND_API.G_RET_STS_SUCCESS;
2054:
2055: restat_localized_texts(p_api_version, p_run_id, x_return_status, x_msg_count, x_msg_data);
2056: restat_rules(p_api_version, p_run_id, x_return_status, x_msg_count, x_msg_data);
2057:

Line 2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2062: WHEN OTHERS THEN
2063: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2064: x_msg_count := 1;
2065: report(x_msg_data, p_run_id, 'refresh_statistics', v_debug);
2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2067: END;
2068: ---------------------------------------------------------------------------------------
2069: PROCEDURE rule_import(p_api_version IN NUMBER,
2070: p_run_id IN OUT NOCOPY NUMBER,

Line 2115: x_return_status := FND_API.G_RET_STS_SUCCESS;

2111: --Initialize error counter and output parameters.
2112:
2113: v_errors := 0;
2114: x_msg_count := 0;
2115: x_return_status := FND_API.G_RET_STS_SUCCESS;
2116:
2117: --If necessary, generate a run_id and update the source records with this value.
2118:
2119: IF(p_run_id IS NULL)THEN

Line 2193: IF(v_errors > 0)THEN x_return_status := FND_API.G_RET_STS_ERROR; END IF;

2189: WHERE run_id = p_run_id;
2190:
2191: --IF there were any errors, the return status will be 'Warning', not 'Success'.
2192:
2193: IF(v_errors > 0)THEN x_return_status := FND_API.G_RET_STS_ERROR; END IF;
2194:
2195: --If there were no successfully transferred rules, the return status will be 'Error'.
2196:
2197: BEGIN

Line 2221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2217: WHEN CZRI_ERR_ACTIVE_SESSIONS THEN
2218: x_msg_data := cz_utils.get_text('CZRI_IMP_ACTIVESESSION', 'RUNID', p_run_id);
2219: x_msg_count := 1;
2220: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2222: DBMS_APPLICATION_INFO.SET_MODULE('','');
2223: WHEN CZRI_ERR_RUNID_EXISTS THEN
2224: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);
2225: x_msg_count := 1;

Line 2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2223: WHEN CZRI_ERR_RUNID_EXISTS THEN
2224: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);
2225: x_msg_count := 1;
2226: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2228: DBMS_APPLICATION_INFO.SET_MODULE('','');
2229: WHEN CZRI_ERR_RUNID_INCORRECT THEN
2230: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);
2231: x_msg_count := 1;

Line 2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2229: WHEN CZRI_ERR_RUNID_INCORRECT THEN
2230: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);
2231: x_msg_count := 1;
2232: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: DBMS_APPLICATION_INFO.SET_MODULE('','');
2235: WHEN CZRI_ERR_DATA_INCORRECT THEN
2236: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);
2237: x_msg_count := 1;

Line 2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2235: WHEN CZRI_ERR_DATA_INCORRECT THEN
2236: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);
2237: x_msg_count := 1;
2238: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: DBMS_APPLICATION_INFO.SET_MODULE('','');
2241: WHEN CZRI_ERR_FATAL_ERROR THEN
2242: --hard errors occurred in underlying procedures, already logged.
2243: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2245: --unexpected errors occurred in the procedure.
2246: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2247: x_msg_count := 1;
2248: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: DBMS_APPLICATION_INFO.SET_MODULE('','');
2251: END;
2252:
2253: -----------------------

Line 2272: x_return_status := FND_API.G_RET_STS_SUCCESS;

2268:
2269: BEGIN
2270: ----initialize FND stack
2271: FND_MSG_PUB.initialize;
2272: x_return_status := FND_API.G_RET_STS_SUCCESS;
2273: x_msg_data := NULL;
2274: x_msg_count := 0;
2275: x_locked_entities := SYSTEM.CZ_NUMBER_TBL_TYPE();
2276:

Line 2302: FND_API.G_FALSE,

2298: FOR I IN l_model_id_tbl.FIRST..l_model_id_tbl.LAST
2299: LOOP
2300: cz_security_pvt.lock_model(1.0,
2301: l_model_id_tbl(i),
2302: FND_API.G_FALSE,
2303: FND_API.G_FALSE,
2304: FND_API.G_FALSE,
2305: l_locked_entities,
2306: x_return_status,

Line 2303: FND_API.G_FALSE,

2299: LOOP
2300: cz_security_pvt.lock_model(1.0,
2301: l_model_id_tbl(i),
2302: FND_API.G_FALSE,
2303: FND_API.G_FALSE,
2304: FND_API.G_FALSE,
2305: l_locked_entities,
2306: x_return_status,
2307: x_msg_count,

Line 2304: FND_API.G_FALSE,

2300: cz_security_pvt.lock_model(1.0,
2301: l_model_id_tbl(i),
2302: FND_API.G_FALSE,
2303: FND_API.G_FALSE,
2304: FND_API.G_FALSE,
2305: l_locked_entities,
2306: x_return_status,
2307: x_msg_count,
2308: x_msg_data);

Line 2310: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2306: x_return_status,
2307: x_msg_count,
2308: x_msg_data);
2309:
2310: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2311: RAISE MODEL_IS_LOCKED;
2312: ELSE
2313: IF (l_locked_entities.COUNT > 0) THEN
2314: x_locked_entities.EXTEND(1);

Line 2321: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;

2317: END IF;
2318: END IF;
2319: END LOOP;
2320: END IF;
2321: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
2322: EXCEPTION
2323: WHEN MODEL_IS_LOCKED THEN
2324: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2325: WHEN NO_DATA_FOUND THEN

Line 2324: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);

2320: END IF;
2321: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
2322: EXCEPTION
2323: WHEN MODEL_IS_LOCKED THEN
2324: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2325: WHEN NO_DATA_FOUND THEN
2326: NULL;
2327: WHEN OTHERS THEN
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2324: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2325: WHEN NO_DATA_FOUND THEN
2326: NULL;
2327: WHEN OTHERS THEN
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2329: fnd_msg_pub.add_exc_msg('CZ_RULE_IMPORT', 'lock_models');
2330: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2331: END lock_models;
2332: ---------------------------------------------------------------------------------------

Line 2330: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);

2326: NULL;
2327: WHEN OTHERS THEN
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2329: fnd_msg_pub.add_exc_msg('CZ_RULE_IMPORT', 'lock_models');
2330: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2331: END lock_models;
2332: ---------------------------------------------------------------------------------------
2333: END;