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

369: CLOSE c_rec;
370: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
371: x_msg_count := 1;
372: report(x_msg_data, p_run_id, 'cnd_rules', v_debug);
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: RAISE CZRI_ERR_FATAL_ERROR;
375: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
376: CLOSE c_rec;
377: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

376: CLOSE c_rec;
377: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
378: x_msg_count := 1;
379: report(x_msg_data, p_run_id, 'cnd_rules', v_debug);
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: RAISE CZRI_ERR_FATAL_ERROR;
382: END;
383: ---------------------------------------------------------------------------------------
384: PROCEDURE krs_rules(p_api_version IN NUMBER,

Line 796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

792: CLOSE c_rec;
793: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
794: x_msg_count := 1;
795: report(x_msg_data, p_run_id, 'krs_rules', v_debug);
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: RAISE CZRI_ERR_FATAL_ERROR;
798: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
799: CLOSE c_rec;
800: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

799: CLOSE c_rec;
800: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
801: x_msg_count := 1;
802: report(x_msg_data, p_run_id, 'krs_rules', v_debug);
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: RAISE CZRI_ERR_FATAL_ERROR;
805: END;
806: ---------------------------------------------------------------------------------------
807: PROCEDURE xfr_rules(p_api_version IN NUMBER,

Line 1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1515: CLOSE c_rec_nochange;
1516: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1517: x_msg_count := 1;
1518: report(x_msg_data, p_run_id, 'xfr_rules', v_debug);
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: RAISE CZRI_ERR_FATAL_ERROR;
1521: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1522: CLOSE c_rec;
1523: CLOSE c_rec_nochange;

Line 1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1523: CLOSE c_rec_nochange;
1524: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1525: x_msg_count := 1;
1526: report(x_msg_data, p_run_id, 'xfr_rules', v_debug);
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: RAISE CZRI_ERR_FATAL_ERROR;
1529: END;
1530: ---------------------------------------------------------------------------------------
1531: PROCEDURE rpt_rules(p_api_version IN NUMBER,

Line 1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1552: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1553: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1554: x_msg_count := 1;
1555: report(x_msg_data, p_run_id, 'rpt_rules', v_debug);
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: RAISE CZRI_ERR_REPORT_ERROR;
1558: END;
1559: ---------------------------------------------------------------------------------------
1560: PROCEDURE restat_rules(p_api_version IN NUMBER,

Line 1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1788: CLOSE c_rec;
1789: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1790: x_msg_count := 1;
1791: report(x_msg_data, p_run_id, 'cnd_localized_texts', v_debug);
1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1793: RAISE CZRI_ERR_FATAL_ERROR;
1794: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1795: CLOSE c_rec;
1796: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1795: CLOSE c_rec;
1796: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1797: x_msg_count := 1;
1798: report(x_msg_data, p_run_id, 'cnd_localized_texts', v_debug);
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1800: RAISE CZRI_ERR_FATAL_ERROR;
1801: END;
1802: ---------------------------------------------------------------------------------------
1803: PROCEDURE krs_localized_texts(p_api_version IN NUMBER,

Line 2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2009: CLOSE c_rec;
2010: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
2011: x_msg_count := 1;
2012: report(x_msg_data, p_run_id, 'krs_localized_texts', v_debug);
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: RAISE CZRI_ERR_FATAL_ERROR;
2015: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
2016: CLOSE c_rec;
2017: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

Line 2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2016: CLOSE c_rec;
2017: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2018: x_msg_count := 1;
2019: report(x_msg_data, p_run_id, 'krs_localized_texts', v_debug);
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021: RAISE CZRI_ERR_FATAL_ERROR;
2022: END;
2023: ---------------------------------------------------------------------------------------
2024: PROCEDURE xfr_localized_texts(p_api_version IN NUMBER,

Line 2353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2349: CLOSE c_rec_nochange;
2350: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
2351: x_msg_count := 1;
2352: report(x_msg_data, p_run_id, 'xfr_localized_texts', v_debug);
2353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2354: RAISE CZRI_ERR_FATAL_ERROR;
2355: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
2356: CLOSE c_rec;
2357: CLOSE c_rec_nochange;

Line 2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2357: CLOSE c_rec_nochange;
2358: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2359: x_msg_count := 1;
2360: report(x_msg_data, p_run_id, 'xfr_localized_texts', v_debug);
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2362: RAISE CZRI_ERR_FATAL_ERROR;
2363: END;
2364: ---------------------------------------------------------------------------------------
2365: PROCEDURE rpt_localized_texts(p_api_version IN NUMBER,

Line 2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2387: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
2388: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2389: x_msg_count := 1;
2390: report(x_msg_data, p_run_id, 'rpt_localized_texts', v_debug);
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2392: RAISE CZRI_ERR_REPORT_ERROR;
2393: END;
2394: ---------------------------------------------------------------------------------------
2395: PROCEDURE restat_localized_texts(p_api_version IN NUMBER,

Line 2473: x_return_status := FND_API.G_RET_STS_SUCCESS;

2469: v_debug NUMBER := 12000;
2470: BEGIN
2471:
2472: x_msg_count := 0;
2473: x_return_status := FND_API.G_RET_STS_SUCCESS;
2474:
2475: restat_localized_texts(p_api_version, p_run_id, x_return_status, x_msg_count, x_msg_data);
2476: restat_rules(p_api_version, p_run_id, x_return_status, x_msg_count, x_msg_data);
2477:

Line 2486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2482: WHEN OTHERS THEN
2483: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2484: x_msg_count := 1;
2485: report(x_msg_data, p_run_id, 'refresh_statistics', v_debug);
2486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2487: END;
2488: ---------------------------------------------------------------------------------------
2489: PROCEDURE rule_import(p_api_version IN NUMBER,
2490: p_run_id IN OUT NOCOPY NUMBER,

Line 2535: x_return_status := FND_API.G_RET_STS_SUCCESS;

2531: --Initialize error counter and output parameters.
2532:
2533: v_errors := 0;
2534: x_msg_count := 0;
2535: x_return_status := FND_API.G_RET_STS_SUCCESS;
2536:
2537: --If necessary, generate a run_id and update the source records with this value.
2538:
2539: IF(p_run_id IS NULL)THEN

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

2609: WHERE run_id = p_run_id;
2610:
2611: --IF there were any errors, the return status will be 'Warning', not 'Success'.
2612:
2613: IF(v_errors > 0)THEN x_return_status := FND_API.G_RET_STS_ERROR; END IF;
2614:
2615: --If there were no successfully transferred rules, the return status will be 'Error'.
2616:
2617: BEGIN

Line 2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2637: WHEN CZRI_ERR_ACTIVE_SESSIONS THEN
2638: x_msg_data := cz_utils.get_text('CZRI_IMP_ACTIVESESSION', 'RUNID', p_run_id);
2639: x_msg_count := 1;
2640: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2642: DBMS_APPLICATION_INFO.SET_MODULE('','');
2643: WHEN CZRI_ERR_RUNID_EXISTS THEN
2644: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);
2645: x_msg_count := 1;

Line 2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2643: WHEN CZRI_ERR_RUNID_EXISTS THEN
2644: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);
2645: x_msg_count := 1;
2646: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: DBMS_APPLICATION_INFO.SET_MODULE('','');
2649: WHEN CZRI_ERR_RUNID_INCORRECT THEN
2650: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);
2651: x_msg_count := 1;

Line 2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2649: WHEN CZRI_ERR_RUNID_INCORRECT THEN
2650: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);
2651: x_msg_count := 1;
2652: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2654: DBMS_APPLICATION_INFO.SET_MODULE('','');
2655: WHEN CZRI_ERR_DATA_INCORRECT THEN
2656: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);
2657: x_msg_count := 1;

Line 2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2655: WHEN CZRI_ERR_DATA_INCORRECT THEN
2656: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);
2657: x_msg_count := 1;
2658: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660: DBMS_APPLICATION_INFO.SET_MODULE('','');
2661: WHEN CZRI_ERR_FATAL_ERROR THEN
2662: --hard errors occurred in underlying procedures, already logged.
2663: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 2669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2665: --unexpected errors occurred in the procedure.
2666: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2667: x_msg_count := 1;
2668: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2670: DBMS_APPLICATION_INFO.SET_MODULE('','');
2671: END;
2672:
2673: -----------------------

Line 2692: x_return_status := FND_API.G_RET_STS_SUCCESS;

2688:
2689: BEGIN
2690: ----initialize FND stack
2691: FND_MSG_PUB.initialize;
2692: x_return_status := FND_API.G_RET_STS_SUCCESS;
2693: x_msg_data := NULL;
2694: x_msg_count := 0;
2695: x_locked_entities := SYSTEM.CZ_NUMBER_TBL_TYPE();
2696:

Line 2722: FND_API.G_FALSE,

2718: FOR I IN l_model_id_tbl.FIRST..l_model_id_tbl.LAST
2719: LOOP
2720: cz_security_pvt.lock_model(1.0,
2721: l_model_id_tbl(i),
2722: FND_API.G_FALSE,
2723: FND_API.G_FALSE,
2724: FND_API.G_FALSE,
2725: l_locked_entities,
2726: x_return_status,

Line 2723: FND_API.G_FALSE,

2719: LOOP
2720: cz_security_pvt.lock_model(1.0,
2721: l_model_id_tbl(i),
2722: FND_API.G_FALSE,
2723: FND_API.G_FALSE,
2724: FND_API.G_FALSE,
2725: l_locked_entities,
2726: x_return_status,
2727: x_msg_count,

Line 2724: FND_API.G_FALSE,

2720: cz_security_pvt.lock_model(1.0,
2721: l_model_id_tbl(i),
2722: FND_API.G_FALSE,
2723: FND_API.G_FALSE,
2724: FND_API.G_FALSE,
2725: l_locked_entities,
2726: x_return_status,
2727: x_msg_count,
2728: x_msg_data);

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

2726: x_return_status,
2727: x_msg_count,
2728: x_msg_data);
2729:
2730: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2731: RAISE MODEL_IS_LOCKED;
2732: ELSE
2733: IF (l_locked_entities.COUNT > 0) THEN
2734: x_locked_entities.EXTEND(1);

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

2737: END IF;
2738: END IF;
2739: END LOOP;
2740: END IF;
2741: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
2742: EXCEPTION
2743: WHEN MODEL_IS_LOCKED THEN
2744: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2745: WHEN NO_DATA_FOUND THEN

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

2740: END IF;
2741: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
2742: EXCEPTION
2743: WHEN MODEL_IS_LOCKED THEN
2744: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2745: WHEN NO_DATA_FOUND THEN
2746: NULL;
2747: WHEN OTHERS THEN
2748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2744: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2745: WHEN NO_DATA_FOUND THEN
2746: NULL;
2747: WHEN OTHERS THEN
2748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2749: fnd_msg_pub.add_exc_msg('CZ_RULE_IMPORT', 'lock_models');
2750: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2751: END lock_models;
2752:

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

2746: NULL;
2747: WHEN OTHERS THEN
2748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2749: fnd_msg_pub.add_exc_msg('CZ_RULE_IMPORT', 'lock_models');
2750: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
2751: END lock_models;
2752:
2753: -------------------------------------------------------------------
2754: --This procedure creates/updates the localized text records for