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 FND_LOG

Line 252: error_message, fnd_log.LEVEL_ERROR);

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

Line 259: error_message, fnd_log.LEVEL_UNEXPECTED);

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

Line 478: fnd_log.LEVEL_ERROR);

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

Line 485: fnd_log.LEVEL_ERROR);

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

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

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

Line 584: fnd_log.LEVEL_UNEXPECTED);

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

Line 1175: fnd_log.LEVEL_ERROR);

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

Line 1183: fnd_log.LEVEL_UNEXPECTED);

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)
1187: RETURN 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 1501: SQLERRM, fnd_log.LEVEL_EXCEPTION);

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:
1505: -------------------------------------------------------------------------------- pvt

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

1839: IF l_url IS NULL THEN
1840: l_url := FND_PROFILE.Value('CZ_UIMGR_URL');
1841: END IF;
1842:
1843: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1844: IF l_log_stmt AND p_init_msg IS NOT NULL THEN
1845: CZ_UTILS.log_report(G_PKG_NAME,l_api_name,l_nDebug,'URL='||l_url,FND_LOG.LEVEL_STATEMENT);
1846: l_start := 1;
1847: l_end := instr(p_init_msg, '', l_start);

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

1841: END IF;
1842:
1843: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1844: IF l_log_stmt AND p_init_msg IS NOT NULL THEN
1845: CZ_UTILS.log_report(G_PKG_NAME,l_api_name,l_nDebug,'URL='||l_url,FND_LOG.LEVEL_STATEMENT);
1846: l_start := 1;
1847: l_end := instr(p_init_msg, '', l_start);
1848: WHILE l_end > 0 LOOP
1849: l_end := l_end + 8;

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

1848: WHILE l_end > 0 LOOP
1849: l_end := l_end + 8;
1850: l_msg := substr(p_init_msg, l_start, (l_end - l_start));
1851: -- dbms_output.put_line(l_msg);
1852: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1853: l_start := l_end;
1854: l_end := instr(p_init_msg, '', l_start);
1855: END LOOP;
1856: IF l_start < length(p_init_msg) THEN

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

1854: l_end := instr(p_init_msg, '', l_start);
1855: END LOOP;
1856: IF l_start < length(p_init_msg) THEN
1857: l_msg := substr(p_init_msg, l_start);
1858: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1859: -- dbms_output.put_line(l_msg);
1860: END IF;
1861: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug,
1862: 'Validate type: ' || p_validation_type, FND_LOG.LEVEL_STATEMENT);

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

1858: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1859: -- dbms_output.put_line(l_msg);
1860: END IF;
1861: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug,
1862: 'Validate type: ' || p_validation_type, FND_LOG.LEVEL_STATEMENT);
1863: END IF;
1864:
1865: l_nDebug := 2;
1866: l_has_item := p_config_item_tbl IS NOT NULL AND p_config_item_tbl.COUNT > 0;

Line 1894: l_pseudo_hdr_id, FND_LOG.LEVEL_STATEMENT);

1890: );
1891:
1892: IF l_log_stmt THEN
1893: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'pseudo hdr=' ||
1894: l_pseudo_hdr_id, FND_LOG.LEVEL_STATEMENT);
1895: END IF;
1896:
1897: l_nDebug := 3;
1898: l_idx := 0;

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

1916: ',qty=' || p_config_item_tbl(i).quantity ||
1917: ',nam=' || p_config_item_tbl(i).instance_name ||
1918: ',lid=' || p_config_item_tbl(i).location_id ||
1919: ',ltc=' || p_config_item_tbl(i).location_type_code;
1920: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1921: END IF;
1922:
1923: IF p_config_item_tbl(i).config_item_id IS NULL OR
1924: p_config_item_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN

Line 2064: FND_LOG.LEVEL_STATEMENT);

2060: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
2061: AND config_item_id = l_config_item_tbl(i);
2062: IF l_log_stmt THEN
2063: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'item sequences reordered',
2064: FND_LOG.LEVEL_STATEMENT);
2065: END IF;
2066: END IF;
2067: END IF;
2068:

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

2086: ', seq=' || p_config_ext_attr_tbl(i).sequence_nbr ||
2087: ', nam=' || p_config_ext_attr_tbl(i).attribute_name ||
2088: ', grp=' || p_config_ext_attr_tbl(i).attribute_group ||
2089: ', val=' || p_config_ext_attr_tbl(i).attribute_value;
2090: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2091: END IF;
2092:
2093: IF p_config_ext_attr_tbl(i).config_item_id IS NULL OR
2094: p_config_ext_attr_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN

Line 2228: FND_LOG.LEVEL_STATEMENT);

2224: AND config_item_id = l_config_item_tbl(i);
2225:
2226: IF l_log_stmt THEN
2227: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'attr sequences reordered',
2228: FND_LOG.LEVEL_STATEMENT);
2229: END IF;
2230: END IF;
2231:
2232: END IF;

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

2242: ,v_detailed_error_message
2243: );
2244:
2245: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'validation status: ' ||
2246: l_validation_status||v_detailed_error_message, FND_LOG.LEVEL_PROCEDURE);
2247:
2248: IF l_validation_status = INIT_TOO_LONG THEN
2249: fnd_message.set_name('CZ', 'CZ_BV_ERR_INIT_MSG');
2250: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);

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

2399: DELTA_CHECK_FAILURE EXCEPTION;
2400:
2401: BEGIN
2402: l_nDebug := 1;
2403: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2404: IF l_log_stmt THEN
2405: l_msg := 'Number of inputs=' || config_input_list.COUNT;
2406: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2407: END IF;

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

2402: l_nDebug := 1;
2403: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2404: IF l_log_stmt THEN
2405: l_msg := 'Number of inputs=' || config_input_list.COUNT;
2406: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2407: END IF;
2408:
2409: IF config_input_list.COUNT > 0 THEN
2410: BEGIN

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

2430:
2431: l_rec1_seq := config_input_list(config_input_list.FIRST).input_seq;
2432: IF l_log_stmt THEN
2433: l_msg := '1st rec input_seq=' || l_rec1_seq;
2434: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2435: l_msg := 'pseudo hdr=' || l_pseudo_hdr_id;
2436: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2437: END IF;
2438:

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

2432: IF l_log_stmt THEN
2433: l_msg := '1st rec input_seq=' || l_rec1_seq;
2434: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2435: l_msg := 'pseudo hdr=' || l_pseudo_hdr_id;
2436: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2437: END IF;
2438:
2439: l_nDebug := 2;
2440: l_hdr_id := 0;

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

2443: LOOP
2444: IF config_input_list(i).component_code IS NULL OR
2445: config_input_list(i).quantity IS NULL THEN
2446: l_msg := 'The component code or quantity passed in rec ' || i || ' is NULL';
2447: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);
2448: RAISE INVALID_OPTION_EXCEPTION;
2449: END IF;
2450:
2451: l_quantity_tbl(i) := config_input_list(i).quantity;

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

2461: IF l_hdr_id = 0 THEN
2462: get_config_hdr(init_message, l_hdr_id, l_rev_nbr);
2463: IF l_log_stmt THEN
2464: l_msg := 'hdr in init msg=' || l_hdr_id || ',' || l_rev_nbr;
2465: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2466: END IF;
2467: END IF;
2468: get_ext_comp_code(l_hdr_id, l_rev_nbr, l_item_id, l_ext_comp_code, l_item_depth);
2469: IF l_ext_comp_code IS NULL OR l_ext_comp_code = '' THEN

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

2468: get_ext_comp_code(l_hdr_id, l_rev_nbr, l_item_id, l_ext_comp_code, l_item_depth);
2469: IF l_ext_comp_code IS NULL OR l_ext_comp_code = '' THEN
2470: l_msg := 'The config item id '||l_item_id||' passed in rec '||i||' for config header id '||
2471: l_hdr_id || ' and rev nbr ' || l_rev_nbr || ' is invalid';
2472: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);
2473: RAISE INVALID_OPTION_EXCEPTION;
2474: END IF;
2475: ELSE
2476: append_instance_nbr(config_input_list(i).component_code, l_ext_comp_code, l_item_depth);

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

2545: WHEN OTHERS THEN
2546: validation_status:=DATABASE_ERROR;
2547: ROLLBACK;
2548: l_msg := SQLERRM;
2549: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_ERROR);
2550: RETURN;
2551: END;
2552:
2553: END IF;

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

2562: ,v_detailed_error_message
2563: );
2564:
2565: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'validation status: ' ||
2566: validation_status||v_detailed_error_message, FND_LOG.LEVEL_PROCEDURE);
2567:
2568: l_nDebug := 6;
2569: -- this block would set the config status status in the terminate message to FALSE
2570: -- if the config_input_list is empty and validation_status is CONFIG_PROCESSED

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

2592: WHEN DELTA_CHECK_FAILURE THEN
2593: validation_status:=CONFIG_EXCEPTION;
2594: COMMIT;
2595: l_msg := 'DELTA_CHECK_FAILURE';
2596: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg||v_detailed_error_message, FND_LOG.LEVEL_ERROR);
2597:
2598: WHEN OTHERS THEN
2599: delete_bv_records(l_pseudo_hdr_id, FALSE, FALSE);
2600: validation_status:=CONFIG_EXCEPTION;

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

2598: WHEN OTHERS THEN
2599: delete_bv_records(l_pseudo_hdr_id, FALSE, FALSE);
2600: validation_status:=CONFIG_EXCEPTION;
2601: l_msg := SQLERRM;
2602: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg||v_detailed_error_message, FND_LOG.LEVEL_ERROR);
2603: END validate; -- old
2604:
2605: ------------------------------------------------------------------------------------------
2606: FUNCTION model_for_item(inventory_item_id NUMBER,

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

Line 2712: fnd_log.LEVEL_UNEXPECTED);

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

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

Line 2921: SQLERRM, fnd_log.LEVEL_UNEXPECTED);

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

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

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

Line 3054: SQLERRM, fnd_log.LEVEL_UNEXPECTED);

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

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

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

Line 3159: SQLERRM, fnd_log.LEVEL_UNEXPECTED);

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

Line 3445: SQLERRM, fnd_log.LEVEL_UNEXPECTED);

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

Line 3734: fnd_log.LEVEL_UNEXPECTED);

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:
3737: ------------------------------------------------------------------------------------------------
3738:

Line 3764: fnd_log.LEVEL_UNEXPECTED);

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:
3767: --------------------------------------------------------------------------------
3768: PROCEDURE pub_for_item_mobile_pvt