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_CF_API dependencies on CZ_CF_API

Line 1: PACKAGE BODY CZ_CF_API AS

1: PACKAGE BODY CZ_CF_API AS
2: /* $Header: czcfapib.pls 120.28.12020000.2 2012/08/17 14:41:13 smanna ship $ */
3: ------------------------------------------------------------------------------------------
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CZ_CF_API';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CZ_CF_API';

1: PACKAGE BODY CZ_CF_API AS
2: /* $Header: czcfapib.pls 120.28.12020000.2 2012/08/17 14:41:13 smanna ship $ */
3: ------------------------------------------------------------------------------------------
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CZ_CF_API';
5:
6: TYPE str255_tbl_type IS TABLE OF VARCHAR2(255) INDEX BY PLS_INTEGER; -- name, ...
7: TYPE str1200_tbl_type IS TABLE OF VARCHAR2(1200) INDEX BY PLS_INTEGER; -- component code,...
8:

Line 250: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);

246: EXCEPTION
247: WHEN API_CALL_EXC THEN
248: return_value:=0;
249: error_message:=CZ_UTILS.GET_TEXT('CZ_INCOMPAT_COPY_CFG');
250: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);
251: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,
252: error_message, fnd_log.LEVEL_ERROR);
253:
254: WHEN OTHERS THEN

Line 251: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,

247: WHEN API_CALL_EXC THEN
248: return_value:=0;
249: error_message:=CZ_UTILS.GET_TEXT('CZ_INCOMPAT_COPY_CFG');
250: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);
251: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,
252: error_message, fnd_log.LEVEL_ERROR);
253:
254: WHEN OTHERS THEN
255: return_value:=0;

Line 257: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);

253:
254: WHEN OTHERS THEN
255: return_value:=0;
256: error_message:=SQLERRM;
257: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);
258: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,
259: error_message, fnd_log.LEVEL_UNEXPECTED);
260: END copy_configuration;
261:

Line 258: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,

254: WHEN OTHERS THEN
255: return_value:=0;
256: error_message:=SQLERRM;
257: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);
258: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,
259: error_message, fnd_log.LEVEL_UNEXPECTED);
260: END copy_configuration;
261:
262: -------------------------------------------------------------------------------------

Line 276: CZ_CF_API.copy_configuration(config_hdr_id,config_rev_nbr,new_config_flag,out_config_hdr_id,

272: IS
273:
274: PRAGMA AUTONOMOUS_TRANSACTION;
275: BEGIN
276: CZ_CF_API.copy_configuration(config_hdr_id,config_rev_nbr,new_config_flag,out_config_hdr_id,
277: out_config_rev_nbr,Error_message,Return_value,handle_deleted_flag, new_name);
278: COMMIT;
279: END copy_configuration_auto;
280:

Line 476: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);

472: WHEN CONFIG_HDR_TYPE_EXC THEN
473: Return_value:=0;
474: Error_message:=CZ_UTILS.GET_TEXT('CZ_CFG_DEL_HDR_TYPE', 'id', in_config_hdr_id,
475: 'revision', in_config_rev_nbr, 'type', l_component_instance_type);
476: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);
477: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message,
478: fnd_log.LEVEL_ERROR);
479:
480: WHEN del_ib_config_exc THEN

Line 477: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message,

473: Return_value:=0;
474: Error_message:=CZ_UTILS.GET_TEXT('CZ_CFG_DEL_HDR_TYPE', 'id', in_config_hdr_id,
475: 'revision', in_config_rev_nbr, 'type', l_component_instance_type);
476: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);
477: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message,
478: fnd_log.LEVEL_ERROR);
479:
480: WHEN del_ib_config_exc THEN
481: Return_value := 0;

Line 484: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message,

480: WHEN del_ib_config_exc THEN
481: Return_value := 0;
482: Error_message := retrieve_log_msg(l_run_id);
483: ROLLBACK TO start_transaction;
484: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message,
485: fnd_log.LEVEL_ERROR);
486:
487: WHEN OTHERS THEN
488: Return_value:=0;

Line 495: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);

491: ELSE
492: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', SQLERRM);
493: END IF;
494: ROLLBACK TO start_transaction;
495: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);
496: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message, fnd_log.LEVEL_UNEXPECTED);
497: END delete_configuration;
498:
499: ------------------------------------------------------------------------------------------

Line 496: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message, fnd_log.LEVEL_UNEXPECTED);

492: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', SQLERRM);
493: END IF;
494: ROLLBACK TO start_transaction;
495: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);
496: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message, fnd_log.LEVEL_UNEXPECTED);
497: END delete_configuration;
498:
499: ------------------------------------------------------------------------------------------
500: PROCEDURE delete_configuration_usage(calling_application_id IN NUMBER,

Line 519: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: delete configuration usage',11276);

515: WHEN OTHERS THEN
516: Return_value:=0;
517: Error_message:=SQLERRM;
518: ROLLBACK TO start_transaction;
519: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: delete configuration usage',11276);
520: cz_utils.log_report('CZ_CF_API', 'delete_configuration_usage', 1, error_message,
521: fnd_log.LEVEL_UNEXPECTED);
522: END delete_configuration_usage;
523: ------------------------------------------------------------------------------------------

Line 520: cz_utils.log_report('CZ_CF_API', 'delete_configuration_usage', 1, error_message,

516: Return_value:=0;
517: Error_message:=SQLERRM;
518: ROLLBACK TO start_transaction;
519: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: delete configuration usage',11276);
520: cz_utils.log_report('CZ_CF_API', 'delete_configuration_usage', 1, error_message,
521: fnd_log.LEVEL_UNEXPECTED);
522: END delete_configuration_usage;
523: ------------------------------------------------------------------------------------------
524: PROCEDURE update_configuration_usage(calling_application_id IN NUMBER,

Line 582: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: update configuration usage',11276);

578: WHEN OTHERS THEN
579: Return_value:=0;
580: Error_message:=SQLERRM;
581: ROLLBACK TO start_transaction;
582: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: update configuration usage',11276);
583: cz_utils.log_report('CZ_CF_API', 'update_configuration_usage', 1, error_message,
584: fnd_log.LEVEL_UNEXPECTED);
585: END update_configuration_usage;
586: ------------------------------------------------------------------------------------------

Line 583: cz_utils.log_report('CZ_CF_API', 'update_configuration_usage', 1, error_message,

579: Return_value:=0;
580: Error_message:=SQLERRM;
581: ROLLBACK TO start_transaction;
582: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: update configuration usage',11276);
583: cz_utils.log_report('CZ_CF_API', 'update_configuration_usage', 1, error_message,
584: fnd_log.LEVEL_UNEXPECTED);
585: END update_configuration_usage;
586: ------------------------------------------------------------------------------------------
587: PROCEDURE get_config_hdr(p_xml_string IN VARCHAR2,

Line 1174: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, v_parse_message,

1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171: WHEN PARSE_XML_ERROR THEN
1172: ROLLBACK;
1173: -- l_report_status := CZ_UTILS.REPORT (v_parse_message,1,'ITEM DELTA',1);
1174: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, v_parse_message,
1175: fnd_log.LEVEL_ERROR);
1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: WHEN OTHERS THEN
1178: ROLLBACK;

Line 1182: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, l_config_err_msg,

1178: ROLLBACK;
1179: l_config_err_msg := SQLERRM;
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1181: -- l_report_status := CZ_UTILS.REPORT (l_config_err_msg,1,'ITEM DELTA',1);
1182: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, l_config_err_msg,
1183: fnd_log.LEVEL_UNEXPECTED);
1184: END check_deltas;
1185: -------------------------------------------------------------------------
1186: FUNCTION batchurlencode(p_str varchar2)

Line 1292: CZ_UTILS.LOG_REPORT('cz_cf_api', 'return_html_pieces', null, 'Model to Pool Effinity is not properly defined', FND_LOG.LEVEL_EXCEPTION);

1288: END IF;
1289: COMMIT;
1290: EXCEPTION
1291: WHEN MODEL_POOL_EFFINITY_EXC THEN
1292: CZ_UTILS.LOG_REPORT('cz_cf_api', 'return_html_pieces', null, 'Model to Pool Effinity is not properly defined', FND_LOG.LEVEL_EXCEPTION);
1293: ROLLBACK;
1294: RAISE;
1295: WHEN OTHERS THEN
1296: ROLLBACK;

Line 1500: cz_utils.log_report('cz_cf_api', 'publication_for_init_message', null,

1496: SELECT product_key INTO x_product_key FROM cz_model_publications WHERE publication_id = x_publication_id;
1497: END IF;
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: cz_utils.log_report('cz_cf_api', 'publication_for_init_message', null,
1501: SQLERRM, fnd_log.LEVEL_EXCEPTION);
1502: RAISE;
1503: END publication_for_init_message;
1504:

Line 2339: CZ_CF_API.VALIDATE (config_input_list ,

2335: x_return_config_changed VARCHAR2(2) := NULL;
2336:
2337: BEGIN
2338:
2339: CZ_CF_API.VALIDATE (config_input_list ,
2340: init_message ,
2341: config_messages ,
2342: validation_status ,
2343: URL ,

Line 2703: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);

2699: END LOOP;
2700: RETURN t_models_for_items;
2701: EXCEPTION
2702: WHEN WRONG_ARRAYS_LENGTH THEN
2703: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);
2704: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null,
2705: 'The size of input arrays should be the same',
2706: fnd_log.LEVEL_EXCEPTION);
2707: RAISE_APPLICATION_ERROR (-20001,

Line 2704: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null,

2700: RETURN t_models_for_items;
2701: EXCEPTION
2702: WHEN WRONG_ARRAYS_LENGTH THEN
2703: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);
2704: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null,
2705: 'The size of input arrays should be the same',
2706: fnd_log.LEVEL_EXCEPTION);
2707: RAISE_APPLICATION_ERROR (-20001,
2708: 'The size of input arrays should be the same');

Line 2710: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);

2706: fnd_log.LEVEL_EXCEPTION);
2707: RAISE_APPLICATION_ERROR (-20001,
2708: 'The size of input arrays should be the same');
2709: WHEN OTHERS THEN
2710: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);
2711: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null, SQLERRM,
2712: fnd_log.LEVEL_UNEXPECTED);
2713: END config_models_for_items;
2714:

Line 2711: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null, SQLERRM,

2707: RAISE_APPLICATION_ERROR (-20001,
2708: 'The size of input arrays should be the same');
2709: WHEN OTHERS THEN
2710: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);
2711: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null, SQLERRM,
2712: fnd_log.LEVEL_UNEXPECTED);
2713: END config_models_for_items;
2714:
2715: ----------------------------------------------------------------------------------------

Line 2912: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);

2908: RETURN t_uis_for_items;
2909:
2910: EXCEPTION
2911: WHEN WRONG_ARRAYS_LENGTH THEN
2912: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);
2913: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,
2914: 'The size of input arrays should be the same',
2915: fnd_log.LEVEL_EXCEPTION);
2916: RAISE_APPLICATION_ERROR (-20001,

Line 2913: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,

2909:
2910: EXCEPTION
2911: WHEN WRONG_ARRAYS_LENGTH THEN
2912: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);
2913: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,
2914: 'The size of input arrays should be the same',
2915: fnd_log.LEVEL_EXCEPTION);
2916: RAISE_APPLICATION_ERROR (-20001,
2917: 'The size of input arrays should be the same');

Line 2919: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);

2915: fnd_log.LEVEL_EXCEPTION);
2916: RAISE_APPLICATION_ERROR (-20001,
2917: 'The size of input arrays should be the same');
2918: WHEN OTHERS THEN
2919: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);
2920: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,
2921: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
2922: END config_uis_for_items;
2923:

Line 2920: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,

2916: RAISE_APPLICATION_ERROR (-20001,
2917: 'The size of input arrays should be the same');
2918: WHEN OTHERS THEN
2919: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);
2920: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,
2921: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
2922: END config_uis_for_items;
2923:
2924: ---------------------------------------------------------------------------

Line 3046: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);

3042: END LOOP;
3043: RETURN t_models_for_products;
3044: EXCEPTION
3045: WHEN WRONG_ARRAYS_LENGTH THEN
3046: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);
3047: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,
3048: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
3049: RAISE_APPLICATION_ERROR (-20001,
3050: 'The size of input arrays should be the same');

Line 3047: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,

3043: RETURN t_models_for_products;
3044: EXCEPTION
3045: WHEN WRONG_ARRAYS_LENGTH THEN
3046: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);
3047: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,
3048: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
3049: RAISE_APPLICATION_ERROR (-20001,
3050: 'The size of input arrays should be the same');
3051: WHEN OTHERS THEN

Line 3052: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);

3048: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
3049: RAISE_APPLICATION_ERROR (-20001,
3050: 'The size of input arrays should be the same');
3051: WHEN OTHERS THEN
3052: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);
3053: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,
3054: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
3055: END config_models_for_products;
3056:

Line 3053: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,

3049: RAISE_APPLICATION_ERROR (-20001,
3050: 'The size of input arrays should be the same');
3051: WHEN OTHERS THEN
3052: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);
3053: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,
3054: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
3055: END config_models_for_products;
3056:
3057: -----------------------------------------------------------------------------------

Line 3151: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);

3147: END LOOP;
3148: RETURN t_uis_for_products;
3149: EXCEPTION
3150: WHEN WRONG_ARRAYS_LENGTH THEN
3151: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);
3152: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,
3153: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
3154: RAISE_APPLICATION_ERROR (-20001,
3155: 'The size of input arrays should be the same');

Line 3152: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,

3148: RETURN t_uis_for_products;
3149: EXCEPTION
3150: WHEN WRONG_ARRAYS_LENGTH THEN
3151: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);
3152: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,
3153: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
3154: RAISE_APPLICATION_ERROR (-20001,
3155: 'The size of input arrays should be the same');
3156: WHEN OTHERS THEN

Line 3157: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);

3153: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
3154: RAISE_APPLICATION_ERROR (-20001,
3155: 'The size of input arrays should be the same');
3156: WHEN OTHERS THEN
3157: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);
3158: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,
3159: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
3160: END config_uis_for_products;
3161:

Line 3158: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,

3154: RAISE_APPLICATION_ERROR (-20001,
3155: 'The size of input arrays should be the same');
3156: WHEN OTHERS THEN
3157: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);
3158: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,
3159: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
3160: END config_uis_for_products;
3161:
3162: -----------------------------------------------------------------------------------

Line 3444: cz_utils.log_report('CZ_CF_API', 'publication_for_saved_config', v_ndebug,

3440: END IF;
3441:
3442: EXCEPTION
3443: WHEN OTHERS THEN
3444: cz_utils.log_report('CZ_CF_API', 'publication_for_saved_config', v_ndebug,
3445: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
3446: RAISE;
3447: END publication_for_saved_config;
3448:

Line 3624: 'are required arguments TO CZ_CF_API.' ||

3620:
3621: BEGIN
3622: IF p_config_hdr_id IS NULL OR p_config_rev_nbr IS NULL THEN
3623: RAISE_APPLICATION_ERROR(-20001, 'Config header ID AND config rev nbr ' ||
3624: 'are required arguments TO CZ_CF_API.' ||
3625: 'default_restored_cfg_dates');
3626: END IF;
3627:
3628: BEGIN

Line 3731: -- xERROR := cz_utils.REPORT('No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_item', NULL);

3727:
3728:
3729: EXCEPTION
3730: WHEN OTHERS THEN
3731: -- xERROR := cz_utils.REPORT('No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_item', NULL);
3732: cz_utils.log_report('CZ_CF_API', 'common_bill_for_item', null,
3733: 'No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM,
3734: fnd_log.LEVEL_UNEXPECTED);
3735: END common_bill_for_item;

Line 3732: cz_utils.log_report('CZ_CF_API', 'common_bill_for_item', null,

3728:
3729: EXCEPTION
3730: WHEN OTHERS THEN
3731: -- xERROR := cz_utils.REPORT('No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_item', NULL);
3732: cz_utils.log_report('CZ_CF_API', 'common_bill_for_item', null,
3733: 'No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM,
3734: fnd_log.LEVEL_UNEXPECTED);
3735: END common_bill_for_item;
3736:

Line 3761: -- xERROR := cz_utils.REPORT('No common bill found for ' || v_product_key || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_product', NULL);

3757:
3758:
3759: EXCEPTION
3760: WHEN OTHERS THEN
3761: -- xERROR := cz_utils.REPORT('No common bill found for ' || v_product_key || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_product', NULL);
3762: cz_utils.log_report('CZ_CF_API', 'common_bill_for_product', null,
3763: 'No common bill found for ' || v_product_key || ' ' || SQLERRM,
3764: fnd_log.LEVEL_UNEXPECTED);
3765: END common_bill_for_product;

Line 3762: cz_utils.log_report('CZ_CF_API', 'common_bill_for_product', null,

3758:
3759: EXCEPTION
3760: WHEN OTHERS THEN
3761: -- xERROR := cz_utils.REPORT('No common bill found for ' || v_product_key || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_product', NULL);
3762: cz_utils.log_report('CZ_CF_API', 'common_bill_for_product', null,
3763: 'No common bill found for ' || v_product_key || ' ' || SQLERRM,
3764: fnd_log.LEVEL_UNEXPECTED);
3765: END common_bill_for_product;
3766:

Line 4032: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);

4028: WHEN MODEL_POOL_EFFINITY_EXC THEN
4029: retcode := 2;
4030: errbuf := 'Model to Pool affinity already exists for product key : ' ||
4031: nModel_product_key || '. Please unregister existing record before defining new affinity.';
4032: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);
4033: WHEN INVALID_OPTION_EXCEPTION THEN
4034: retcode := 2;
4035: errbuf := 'Organization ID OR Inventory Item ID can not be NULL';
4036: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);

Line 4036: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);

4032: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);
4033: WHEN INVALID_OPTION_EXCEPTION THEN
4034: retcode := 2;
4035: errbuf := 'Organization ID OR Inventory Item ID can not be NULL';
4036: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);
4037: WHEN OTHERS THEN
4038: retcode:=2;
4039: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);
4040: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);

Line 4040: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);

4036: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);
4037: WHEN OTHERS THEN
4038: retcode:=2;
4039: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);
4040: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);
4041:
4042: END register_model_to_pool_cp;
4043: --------------------------------------------------------------------------------
4044: PROCEDURE register_model_to_pool(errbuf IN OUT NOCOPY VARCHAR2,

Line 4075: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);

4071: WHEN MODEL_POOL_EFFINITY_EXC THEN
4072: retcode := 2;
4073: errbuf := 'Model to Pool affinity already exists for product key : ' ||
4074: p_model_product_key || '. Please unregister existing record before defining new affinity.';
4075: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);
4076: RAISE ;
4077: WHEN OTHERS THEN
4078: retcode:=2;
4079: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);

Line 4080: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);

4076: RAISE ;
4077: WHEN OTHERS THEN
4078: retcode:=2;
4079: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);
4080: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.register_model_to_pool_cp',99999,NULL);
4081: RAISE;
4082: END register_model_to_pool;
4083:
4084: --------------------------------------------------------------------------------

Line 4133: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_model_to_pool_cp',99999,NULL);

4129: EXCEPTION
4130: WHEN INVALID_OPTION_EXCEPTION THEN
4131: retcode := 2;
4132: errbuf := 'Organization ID OR Inventory Item ID can not be NULL';
4133: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_model_to_pool_cp',99999,NULL);
4134: WHEN OTHERS THEN
4135: retcode:=2;
4136: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);
4137: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_model_from_pool_cp',99999,NULL);

Line 4137: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_model_from_pool_cp',99999,NULL);

4133: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_model_to_pool_cp',99999,NULL);
4134: WHEN OTHERS THEN
4135: retcode:=2;
4136: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);
4137: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_model_from_pool_cp',99999,NULL);
4138:
4139: END unregister_model_from_pool_cp;
4140:
4141: --------------------------------------------------------------------------------

Line 4157: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_model_from_pool_cp',99999,NULL);

4153: EXCEPTION
4154: WHEN OTHERS THEN
4155: retcode:=2;
4156: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);
4157: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_model_from_pool_cp',99999,NULL);
4158: RAISE;
4159: END unregister_model_from_pool;
4160:
4161: --------------------------------------------------------------------------------

Line 4178: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_pool_cp',99999,NULL);

4174: EXCEPTION
4175: WHEN OTHERS THEN
4176: retcode:=2;
4177: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);
4178: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_pool_cp',99999,NULL);
4179: END unregister_pool_cp;
4180:
4181: --------------------------------------------------------------------------------
4182: PROCEDURE unregister_pool(errbuf IN OUT NOCOPY VARCHAR2,

Line 4196: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_pool_cp',99999,NULL);

4192: EXCEPTION
4193: WHEN OTHERS THEN
4194: retcode:=2;
4195: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);
4196: nRet := CZ_UTILS.log_report(errbuf,1,'CZ_CF_API.unregister_pool_cp',99999,NULL);
4197: RAISE;
4198: END unregister_pool;
4199:
4200: --------------------------------------------------------------------------------

Line 4341: END CZ_CF_API;

4337: WHEN OTHERS THEN
4338: transferTimeout := NULL;
4339: defaultTimeout := NULL;
4340: END;
4341: END CZ_CF_API;