DBA Data[Home] [Help]

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.15.12010000.2 2008/11/05 17:26:06 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.15.12010000.2 2008/11/05 17:26:06 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 239: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);

235: EXCEPTION
236: WHEN API_CALL_EXC THEN
237: return_value:=0;
238: error_message:=CZ_UTILS.GET_TEXT('CZ_INCOMPAT_COPY_CFG');
239: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);
240: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,
241: error_message, fnd_log.LEVEL_ERROR);
242:
243: WHEN OTHERS THEN

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

236: WHEN API_CALL_EXC THEN
237: return_value:=0;
238: error_message:=CZ_UTILS.GET_TEXT('CZ_INCOMPAT_COPY_CFG');
239: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);
240: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,
241: error_message, fnd_log.LEVEL_ERROR);
242:
243: WHEN OTHERS THEN
244: return_value:=0;

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

242:
243: WHEN OTHERS THEN
244: return_value:=0;
245: error_message:=SQLERRM;
246: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);
247: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,
248: error_message, fnd_log.LEVEL_UNEXPECTED);
249: END copy_configuration;
250:

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

243: WHEN OTHERS THEN
244: return_value:=0;
245: error_message:=SQLERRM;
246: -- xERROR:=CZ_UTILS.REPORT(error_message,1,'CZ_CF_API: copy configuration',11276);
247: cz_utils.log_report('CZ_CF_API', 'copy_configuration', null,
248: error_message, fnd_log.LEVEL_UNEXPECTED);
249: END copy_configuration;
250:
251: -------------------------------------------------------------------------------------

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

261: IS
262:
263: PRAGMA AUTONOMOUS_TRANSACTION;
264: BEGIN
265: CZ_CF_API.copy_configuration(config_hdr_id,config_rev_nbr,new_config_flag,out_config_hdr_id,
266: out_config_rev_nbr,Error_message,Return_value,handle_deleted_flag, new_name);
267: COMMIT;
268: END copy_configuration_auto;
269:

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

442: WHEN CONFIG_HDR_TYPE_EXC THEN
443: Return_value:=0;
444: Error_message:=CZ_UTILS.GET_TEXT('CZ_CFG_DEL_HDR_TYPE', 'id', in_config_hdr_id,
445: 'revision', in_config_rev_nbr, 'type', l_component_instance_type);
446: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);
447: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message,
448: fnd_log.LEVEL_ERROR);
449:
450: WHEN del_ib_config_exc THEN

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

443: Return_value:=0;
444: Error_message:=CZ_UTILS.GET_TEXT('CZ_CFG_DEL_HDR_TYPE', 'id', in_config_hdr_id,
445: 'revision', in_config_rev_nbr, 'type', l_component_instance_type);
446: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);
447: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message,
448: fnd_log.LEVEL_ERROR);
449:
450: WHEN del_ib_config_exc THEN
451: Return_value := 0;

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

450: WHEN del_ib_config_exc THEN
451: Return_value := 0;
452: Error_message := retrieve_log_msg(l_run_id);
453: ROLLBACK TO start_transaction;
454: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message,
455: fnd_log.LEVEL_ERROR);
456:
457: WHEN OTHERS THEN
458: Return_value:=0;

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

461: ELSE
462: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', SQLERRM);
463: END IF;
464: ROLLBACK TO start_transaction;
465: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);
466: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message, fnd_log.LEVEL_UNEXPECTED);
467: END delete_configuration;
468:
469: ------------------------------------------------------------------------------------------

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

462: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', SQLERRM);
463: END IF;
464: ROLLBACK TO start_transaction;
465: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API.delete_configuration',11276);
466: cz_utils.log_report('CZ_CF_API', 'delete_configuration', l_ndebug, error_message, fnd_log.LEVEL_UNEXPECTED);
467: END delete_configuration;
468:
469: ------------------------------------------------------------------------------------------
470: PROCEDURE delete_configuration_usage(calling_application_id IN NUMBER,

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

485: WHEN OTHERS THEN
486: Return_value:=0;
487: Error_message:=SQLERRM;
488: ROLLBACK TO start_transaction;
489: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: delete configuration usage',11276);
490: cz_utils.log_report('CZ_CF_API', 'delete_configuration_usage', 1, error_message,
491: fnd_log.LEVEL_UNEXPECTED);
492: END delete_configuration_usage;
493: ------------------------------------------------------------------------------------------

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

486: Return_value:=0;
487: Error_message:=SQLERRM;
488: ROLLBACK TO start_transaction;
489: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: delete configuration usage',11276);
490: cz_utils.log_report('CZ_CF_API', 'delete_configuration_usage', 1, error_message,
491: fnd_log.LEVEL_UNEXPECTED);
492: END delete_configuration_usage;
493: ------------------------------------------------------------------------------------------
494: PROCEDURE update_configuration_usage(calling_application_id IN NUMBER,

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

548: WHEN OTHERS THEN
549: Return_value:=0;
550: Error_message:=SQLERRM;
551: ROLLBACK TO start_transaction;
552: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: update configuration usage',11276);
553: cz_utils.log_report('CZ_CF_API', 'update_configuration_usage', 1, error_message,
554: fnd_log.LEVEL_UNEXPECTED);
555: END update_configuration_usage;
556: ------------------------------------------------------------------------------------------

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

549: Return_value:=0;
550: Error_message:=SQLERRM;
551: ROLLBACK TO start_transaction;
552: -- xERROR:=CZ_UTILS.REPORT(Error_message,1,'CZ_CF_API: update configuration usage',11276);
553: cz_utils.log_report('CZ_CF_API', 'update_configuration_usage', 1, error_message,
554: fnd_log.LEVEL_UNEXPECTED);
555: END update_configuration_usage;
556: ------------------------------------------------------------------------------------------
557: PROCEDURE get_config_hdr(p_xml_string IN VARCHAR2,

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

1116: x_return_status := FND_API.G_RET_STS_SUCCESS;
1117: WHEN PARSE_XML_ERROR THEN
1118: ROLLBACK;
1119: -- l_report_status := CZ_UTILS.REPORT (v_parse_message,1,'ITEM DELTA',1);
1120: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, v_parse_message,
1121: fnd_log.LEVEL_ERROR);
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123: WHEN OTHERS THEN
1124: ROLLBACK;

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

1124: ROLLBACK;
1125: l_config_err_msg := SQLERRM;
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1127: -- l_report_status := CZ_UTILS.REPORT (l_config_err_msg,1,'ITEM DELTA',1);
1128: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, l_config_err_msg,
1129: fnd_log.LEVEL_UNEXPECTED);
1130: END check_deltas;
1131: -------------------------------------------------------------------------
1132: FUNCTION batchurlencode(p_str varchar2)

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

2299: END LOOP;
2300: RETURN t_models_for_items;
2301: EXCEPTION
2302: WHEN WRONG_ARRAYS_LENGTH THEN
2303: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);
2304: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null,
2305: 'The size of input arrays should be the same',
2306: fnd_log.LEVEL_EXCEPTION);
2307: RAISE_APPLICATION_ERROR (-20001,

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

2300: RETURN t_models_for_items;
2301: EXCEPTION
2302: WHEN WRONG_ARRAYS_LENGTH THEN
2303: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);
2304: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null,
2305: 'The size of input arrays should be the same',
2306: fnd_log.LEVEL_EXCEPTION);
2307: RAISE_APPLICATION_ERROR (-20001,
2308: 'The size of input arrays should be the same');

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

2306: fnd_log.LEVEL_EXCEPTION);
2307: RAISE_APPLICATION_ERROR (-20001,
2308: 'The size of input arrays should be the same');
2309: WHEN OTHERS THEN
2310: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);
2311: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null, SQLERRM,
2312: fnd_log.LEVEL_UNEXPECTED);
2313: END config_models_for_items;
2314:

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

2307: RAISE_APPLICATION_ERROR (-20001,
2308: 'The size of input arrays should be the same');
2309: WHEN OTHERS THEN
2310: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);
2311: cz_utils.log_report('CZ_CF_API', 'config_models_for_items', null, SQLERRM,
2312: fnd_log.LEVEL_UNEXPECTED);
2313: END config_models_for_items;
2314:
2315: ----------------------------------------------------------------------------------------

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

2508: RETURN t_uis_for_items;
2509:
2510: EXCEPTION
2511: WHEN WRONG_ARRAYS_LENGTH THEN
2512: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);
2513: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,
2514: 'The size of input arrays should be the same',
2515: fnd_log.LEVEL_EXCEPTION);
2516: RAISE_APPLICATION_ERROR (-20001,

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

2509:
2510: EXCEPTION
2511: WHEN WRONG_ARRAYS_LENGTH THEN
2512: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);
2513: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,
2514: 'The size of input arrays should be the same',
2515: fnd_log.LEVEL_EXCEPTION);
2516: RAISE_APPLICATION_ERROR (-20001,
2517: 'The size of input arrays should be the same');

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

2515: fnd_log.LEVEL_EXCEPTION);
2516: RAISE_APPLICATION_ERROR (-20001,
2517: 'The size of input arrays should be the same');
2518: WHEN OTHERS THEN
2519: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);
2520: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,
2521: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
2522: END config_uis_for_items;
2523:

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

2516: RAISE_APPLICATION_ERROR (-20001,
2517: 'The size of input arrays should be the same');
2518: WHEN OTHERS THEN
2519: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);
2520: cz_utils.log_report('CZ_CF_API', 'config_uis_for_items', null,
2521: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
2522: END config_uis_for_items;
2523:
2524: ---------------------------------------------------------------------------

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

2642: END LOOP;
2643: RETURN t_models_for_products;
2644: EXCEPTION
2645: WHEN WRONG_ARRAYS_LENGTH THEN
2646: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);
2647: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,
2648: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
2649: RAISE_APPLICATION_ERROR (-20001,
2650: 'The size of input arrays should be the same');

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

2643: RETURN t_models_for_products;
2644: EXCEPTION
2645: WHEN WRONG_ARRAYS_LENGTH THEN
2646: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);
2647: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,
2648: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
2649: RAISE_APPLICATION_ERROR (-20001,
2650: 'The size of input arrays should be the same');
2651: WHEN OTHERS THEN

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

2648: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
2649: RAISE_APPLICATION_ERROR (-20001,
2650: 'The size of input arrays should be the same');
2651: WHEN OTHERS THEN
2652: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);
2653: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,
2654: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
2655: END config_models_for_products;
2656:

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

2649: RAISE_APPLICATION_ERROR (-20001,
2650: 'The size of input arrays should be the same');
2651: WHEN OTHERS THEN
2652: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);
2653: cz_utils.log_report('CZ_CF_API', 'config_models_for_products', null,
2654: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
2655: END config_models_for_products;
2656:
2657: -----------------------------------------------------------------------------------

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

2747: END LOOP;
2748: RETURN t_uis_for_products;
2749: EXCEPTION
2750: WHEN WRONG_ARRAYS_LENGTH THEN
2751: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);
2752: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,
2753: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
2754: RAISE_APPLICATION_ERROR (-20001,
2755: 'The size of input arrays should be the same');

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

2748: RETURN t_uis_for_products;
2749: EXCEPTION
2750: WHEN WRONG_ARRAYS_LENGTH THEN
2751: -- xERROR:=CZ_UTILS.REPORT('The size of input arrays should be the same',1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);
2752: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,
2753: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
2754: RAISE_APPLICATION_ERROR (-20001,
2755: 'The size of input arrays should be the same');
2756: WHEN OTHERS THEN

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

2753: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);
2754: RAISE_APPLICATION_ERROR (-20001,
2755: 'The size of input arrays should be the same');
2756: WHEN OTHERS THEN
2757: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);
2758: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,
2759: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
2760: END config_uis_for_products;
2761:

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

2754: RAISE_APPLICATION_ERROR (-20001,
2755: 'The size of input arrays should be the same');
2756: WHEN OTHERS THEN
2757: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);
2758: cz_utils.log_report('CZ_CF_API', 'config_uis_for_products', null,
2759: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
2760: END config_uis_for_products;
2761:
2762: -----------------------------------------------------------------------------------

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

3040: END IF;
3041:
3042: EXCEPTION
3043: WHEN OTHERS THEN
3044: cz_utils.log_report('CZ_CF_API', 'publication_for_saved_config', v_ndebug,
3045: SQLERRM, fnd_log.LEVEL_UNEXPECTED);
3046: RAISE;
3047: END publication_for_saved_config;
3048:

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

3220:
3221: BEGIN
3222: IF p_config_hdr_id IS NULL OR p_config_rev_nbr IS NULL THEN
3223: RAISE_APPLICATION_ERROR(-20001, 'Config header ID AND config rev nbr ' ||
3224: 'are required arguments TO CZ_CF_API.' ||
3225: 'default_restored_cfg_dates');
3226: END IF;
3227:
3228: BEGIN

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

3327:
3328:
3329: EXCEPTION
3330: WHEN OTHERS THEN
3331: -- xERROR := cz_utils.REPORT('No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_item', NULL);
3332: cz_utils.log_report('CZ_CF_API', 'common_bill_for_item', null,
3333: 'No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM,
3334: fnd_log.LEVEL_UNEXPECTED);
3335: END common_bill_for_item;

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

3328:
3329: EXCEPTION
3330: WHEN OTHERS THEN
3331: -- xERROR := cz_utils.REPORT('No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_item', NULL);
3332: cz_utils.log_report('CZ_CF_API', 'common_bill_for_item', null,
3333: 'No common bill found for ' || in_inventory_item_id || ' ' || SQLERRM,
3334: fnd_log.LEVEL_UNEXPECTED);
3335: END common_bill_for_item;
3336:

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

3357:
3358:
3359: EXCEPTION
3360: WHEN OTHERS THEN
3361: -- xERROR := cz_utils.REPORT('No common bill found for ' || v_product_key || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_product', NULL);
3362: cz_utils.log_report('CZ_CF_API', 'common_bill_for_product', null,
3363: 'No common bill found for ' || v_product_key || ' ' || SQLERRM,
3364: fnd_log.LEVEL_UNEXPECTED);
3365: END common_bill_for_product;

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

3358:
3359: EXCEPTION
3360: WHEN OTHERS THEN
3361: -- xERROR := cz_utils.REPORT('No common bill found for ' || v_product_key || ' ' || SQLERRM, 1, 'CZ_CF_API.common_bill_for_product', NULL);
3362: cz_utils.log_report('CZ_CF_API', 'common_bill_for_product', null,
3363: 'No common bill found for ' || v_product_key || ' ' || SQLERRM,
3364: fnd_log.LEVEL_UNEXPECTED);
3365: END common_bill_for_product;
3366:

Line 3530: END CZ_CF_API;

3526: WHEN OTHERS THEN
3527: transferTimeout := NULL;
3528: defaultTimeout := NULL;
3529: END;
3530: END CZ_CF_API;