DBA Data[Home] [Help]

APPS.CZ_CF_API dependencies on FND_LOG

Line 241: error_message, fnd_log.LEVEL_ERROR);

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;
245: error_message:=SQLERRM;

Line 248: error_message, fnd_log.LEVEL_UNEXPECTED);

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: -------------------------------------------------------------------------------------
252: PROCEDURE copy_configuration_auto(config_hdr_id IN NUMBER,

Line 448: fnd_log.LEVEL_ERROR);

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;
452: Error_message := retrieve_log_msg(l_run_id);

Line 455: fnd_log.LEVEL_ERROR);

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;
459: IF (error_message IS NOT NULL) THEN

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 491: fnd_log.LEVEL_UNEXPECTED);

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,
495: calling_application_ref_key IN NUMBER,

Line 554: fnd_log.LEVEL_UNEXPECTED);

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,
558: p_config_header_id IN OUT NOCOPY NUMBER,

Line 1121: fnd_log.LEVEL_ERROR);

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;
1125: l_config_err_msg := SQLERRM;

Line 1129: fnd_log.LEVEL_UNEXPECTED);

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)
1133: RETURN VARCHAR2

Line 1490: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1486: IF l_url IS NULL THEN
1487: l_url := FND_PROFILE.Value('CZ_UIMGR_URL');
1488: END IF;
1489:
1490: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1491: IF l_log_stmt AND p_init_msg IS NOT NULL THEN
1492: CZ_UTILS.log_report(G_PKG_NAME,l_api_name,l_nDebug,'URL='||l_url,FND_LOG.LEVEL_STATEMENT);
1493: l_start := 1;
1494: l_end := instr(p_init_msg, '', l_start);

Line 1492: CZ_UTILS.log_report(G_PKG_NAME,l_api_name,l_nDebug,'URL='||l_url,FND_LOG.LEVEL_STATEMENT);

1488: END IF;
1489:
1490: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1491: IF l_log_stmt AND p_init_msg IS NOT NULL THEN
1492: CZ_UTILS.log_report(G_PKG_NAME,l_api_name,l_nDebug,'URL='||l_url,FND_LOG.LEVEL_STATEMENT);
1493: l_start := 1;
1494: l_end := instr(p_init_msg, '', l_start);
1495: WHILE l_end > 0 LOOP
1496: l_end := l_end + 8;

Line 1499: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);

1495: WHILE l_end > 0 LOOP
1496: l_end := l_end + 8;
1497: l_msg := substr(p_init_msg, l_start, (l_end - l_start));
1498: -- dbms_output.put_line(l_msg);
1499: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1500: l_start := l_end;
1501: l_end := instr(p_init_msg, '', l_start);
1502: END LOOP;
1503: IF l_start < length(p_init_msg) THEN

Line 1505: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);

1501: l_end := instr(p_init_msg, '', l_start);
1502: END LOOP;
1503: IF l_start < length(p_init_msg) THEN
1504: l_msg := substr(p_init_msg, l_start);
1505: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1506: -- dbms_output.put_line(l_msg);
1507: END IF;
1508: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug,
1509: 'Validate type: ' || p_validation_type, FND_LOG.LEVEL_STATEMENT);

Line 1509: 'Validate type: ' || p_validation_type, FND_LOG.LEVEL_STATEMENT);

1505: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1506: -- dbms_output.put_line(l_msg);
1507: END IF;
1508: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug,
1509: 'Validate type: ' || p_validation_type, FND_LOG.LEVEL_STATEMENT);
1510: END IF;
1511:
1512: l_nDebug := 2;
1513: l_has_item := p_config_item_tbl IS NOT NULL AND p_config_item_tbl.COUNT > 0;

Line 1541: l_pseudo_hdr_id, FND_LOG.LEVEL_STATEMENT);

1537: );
1538:
1539: IF l_log_stmt THEN
1540: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'pseudo hdr=' ||
1541: l_pseudo_hdr_id, FND_LOG.LEVEL_STATEMENT);
1542: END IF;
1543:
1544: l_nDebug := 3;
1545: l_idx := 0;

Line 1567: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);

1563: ',qty=' || p_config_item_tbl(i).quantity ||
1564: ',nam=' || p_config_item_tbl(i).instance_name ||
1565: ',lid=' || p_config_item_tbl(i).location_id ||
1566: ',ltc=' || p_config_item_tbl(i).location_type_code;
1567: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1568: END IF;
1569:
1570: IF p_config_item_tbl(i).config_item_id IS NULL OR
1571: p_config_item_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN

Line 1711: FND_LOG.LEVEL_STATEMENT);

1707: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
1708: AND config_item_id = l_config_item_tbl(i);
1709: IF l_log_stmt THEN
1710: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'item sequences reordered',
1711: FND_LOG.LEVEL_STATEMENT);
1712: END IF;
1713: END IF;
1714: END IF;
1715:

Line 1737: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);

1733: ', seq=' || p_config_ext_attr_tbl(i).sequence_nbr ||
1734: ', nam=' || p_config_ext_attr_tbl(i).attribute_name ||
1735: ', grp=' || p_config_ext_attr_tbl(i).attribute_group ||
1736: ', val=' || p_config_ext_attr_tbl(i).attribute_value;
1737: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1738: END IF;
1739:
1740: IF p_config_ext_attr_tbl(i).config_item_id IS NULL OR
1741: p_config_ext_attr_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN

Line 1875: FND_LOG.LEVEL_STATEMENT);

1871: AND config_item_id = l_config_item_tbl(i);
1872:
1873: IF l_log_stmt THEN
1874: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'attr sequences reordered',
1875: FND_LOG.LEVEL_STATEMENT);
1876: END IF;
1877: END IF;
1878:
1879: END IF;

Line 1893: l_validation_status||v_detailed_error_message, FND_LOG.LEVEL_PROCEDURE);

1889: ,v_detailed_error_message
1890: );
1891:
1892: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'validation status: ' ||
1893: l_validation_status||v_detailed_error_message, FND_LOG.LEVEL_PROCEDURE);
1894:
1895: IF l_validation_status = INIT_TOO_LONG THEN
1896: fnd_message.set_name('CZ', 'CZ_BV_ERR_INIT_MSG');
1897: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);

Line 2004: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2000: DELTA_CHECK_FAILURE EXCEPTION;
2001:
2002: BEGIN
2003: l_nDebug := 1;
2004: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2005: IF l_log_stmt THEN
2006: l_msg := 'Number of inputs=' || config_input_list.COUNT;
2007: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2008: END IF;

Line 2007: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);

2003: l_nDebug := 1;
2004: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2005: IF l_log_stmt THEN
2006: l_msg := 'Number of inputs=' || config_input_list.COUNT;
2007: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2008: END IF;
2009:
2010: IF config_input_list.COUNT > 0 THEN
2011: BEGIN

Line 2035: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);

2031:
2032: l_rec1_seq := config_input_list(config_input_list.FIRST).input_seq;
2033: IF l_log_stmt THEN
2034: l_msg := '1st rec input_seq=' || l_rec1_seq;
2035: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2036: l_msg := 'pseudo hdr=' || l_pseudo_hdr_id;
2037: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2038: END IF;
2039:

Line 2037: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);

2033: IF l_log_stmt THEN
2034: l_msg := '1st rec input_seq=' || l_rec1_seq;
2035: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2036: l_msg := 'pseudo hdr=' || l_pseudo_hdr_id;
2037: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2038: END IF;
2039:
2040: l_nDebug := 2;
2041: l_hdr_id := 0;

Line 2048: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);

2044: LOOP
2045: IF config_input_list(i).component_code IS NULL OR
2046: config_input_list(i).quantity IS NULL THEN
2047: l_msg := 'The component code or quantity passed in rec ' || i || ' is NULL';
2048: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);
2049: RAISE INVALID_OPTION_EXCEPTION;
2050: END IF;
2051:
2052: l_quantity_tbl(i) := config_input_list(i).quantity;

Line 2066: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);

2062: IF l_hdr_id = 0 THEN
2063: get_config_hdr(init_message, l_hdr_id, l_rev_nbr);
2064: IF l_log_stmt THEN
2065: l_msg := 'hdr in init msg=' || l_hdr_id || ',' || l_rev_nbr;
2066: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2067: END IF;
2068: END IF;
2069: get_ext_comp_code(l_hdr_id, l_rev_nbr, l_item_id, l_ext_comp_code, l_item_depth);
2070: IF l_ext_comp_code IS NULL OR l_ext_comp_code = '' THEN

Line 2073: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);

2069: get_ext_comp_code(l_hdr_id, l_rev_nbr, l_item_id, l_ext_comp_code, l_item_depth);
2070: IF l_ext_comp_code IS NULL OR l_ext_comp_code = '' THEN
2071: l_msg := 'The config item id '||l_item_id||' passed in rec '||i||' for config header id '||
2072: l_hdr_id || ' and rev nbr ' || l_rev_nbr || ' is invalid';
2073: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);
2074: RAISE INVALID_OPTION_EXCEPTION;
2075: END IF;
2076: ELSE
2077: append_instance_nbr(config_input_list(i).component_code, l_ext_comp_code, l_item_depth);

Line 2150: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);

2146: WHEN OTHERS THEN
2147: validation_status:=DATABASE_ERROR;
2148: ROLLBACK;
2149: l_msg := SQLERRM;
2150: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);
2151: RETURN;
2152: END;
2153:
2154: END IF;

Line 2167: validation_status||v_detailed_error_message, FND_LOG.LEVEL_PROCEDURE);

2163: ,v_detailed_error_message
2164: );
2165:
2166: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'validation status: ' ||
2167: validation_status||v_detailed_error_message, FND_LOG.LEVEL_PROCEDURE);
2168:
2169: l_nDebug := 6;
2170: -- this block would set the config status status in the terminate message to FALSE
2171: -- if the config_input_list is empty and validation_status is CONFIG_PROCESSED

Line 2196: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg||v_detailed_error_message, FND_LOG.LEVEL_ERROR);

2192: WHEN DELTA_CHECK_FAILURE THEN
2193: validation_status:=CONFIG_EXCEPTION;
2194: COMMIT;
2195: l_msg := 'DELTA_CHECK_FAILURE';
2196: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg||v_detailed_error_message, FND_LOG.LEVEL_ERROR);
2197:
2198: WHEN OTHERS THEN
2199: delete_bv_records(l_pseudo_hdr_id, FALSE, FALSE);
2200: validation_status:=CONFIG_EXCEPTION;

Line 2202: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg||v_detailed_error_message, FND_LOG.LEVEL_ERROR);

2198: WHEN OTHERS THEN
2199: delete_bv_records(l_pseudo_hdr_id, FALSE, FALSE);
2200: validation_status:=CONFIG_EXCEPTION;
2201: l_msg := SQLERRM;
2202: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg||v_detailed_error_message, FND_LOG.LEVEL_ERROR);
2203: END validate; -- old
2204:
2205: ------------------------------------------------------------------------------------------
2206: FUNCTION model_for_item(inventory_item_id NUMBER,

Line 2306: fnd_log.LEVEL_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');
2309: WHEN OTHERS THEN
2310: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_ITEMS',11222);

Line 2312: fnd_log.LEVEL_UNEXPECTED);

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: ----------------------------------------------------------------------------------------
2316: -- Returns the ui (ui_def_id and ui type) specified by input publication_id.

Line 2515: fnd_log.LEVEL_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');
2518: WHEN OTHERS THEN
2519: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_ITEMS',11222);

Line 2521: SQLERRM, fnd_log.LEVEL_UNEXPECTED);

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: ---------------------------------------------------------------------------
2525: FUNCTION model_for_publication_id (publication_id NUMBER)

Line 2648: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);

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
2652: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_MODELS_FOR_PRODUCTS',11222);

Line 2654: SQLERRM, fnd_log.LEVEL_UNEXPECTED);

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

Line 2753: 'The size of input arrays should be the same', fnd_log.LEVEL_EXCEPTION);

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
2757: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_CF_API.CONFIG_UIS_FOR_PRODUCTS',11222);

Line 2759: SQLERRM, fnd_log.LEVEL_UNEXPECTED);

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

Line 3045: SQLERRM, fnd_log.LEVEL_UNEXPECTED);

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

Line 3334: fnd_log.LEVEL_UNEXPECTED);

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:
3337: ------------------------------------------------------------------------------------------------
3338:

Line 3364: fnd_log.LEVEL_UNEXPECTED);

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:
3367: --------------------------------------------------------------------------------
3368: PROCEDURE pub_for_item_mobile_pvt