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_UTILS

Line 249: error_message:=CZ_UTILS.GET_TEXT('CZ_INCOMPAT_COPY_CFG');

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

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 474: Error_message:=CZ_UTILS.GET_TEXT('CZ_CFG_DEL_HDR_TYPE', 'id', in_config_hdr_id,

470:
471: EXCEPTION
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);

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 490: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', error_message);

486:
487: WHEN OTHERS THEN
488: Return_value:=0;
489: IF (error_message IS NOT NULL) THEN
490: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', error_message);
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;

Line 492: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', SQLERRM);

488: Return_value:=0;
489: IF (error_message IS NOT NULL) THEN
490: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', error_message);
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);

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 889: l_delta_message := CZ_UTILS.GET_TEXT(p_message_name,

885: l_new_item_name);
886: l_msg_seq := get_next_msg_seq;
887:
888: IF ( (p_message_name = ITEM_DELETE_MESSAGE) OR (p_message_name = ITEM_ADD_MESSAGE ) ) THEN
889: l_delta_message := CZ_UTILS.GET_TEXT(p_message_name,
890: 'ITEMNAME',l_new_item_name,
891: 'QUANTITY',p_current_quantity,
892: 'COMPONENTCODE',p_component_code,
893: 'DESCRIPTION',l_description);

Line 895: l_delta_message := CZ_UTILS.GET_TEXT(p_message_name,

891: 'QUANTITY',p_current_quantity,
892: 'COMPONENTCODE',p_component_code,
893: 'DESCRIPTION',l_description);
894: ELSIF (p_message_name = QTY_CHANGE_MESSAGE ) THEN
895: l_delta_message := CZ_UTILS.GET_TEXT(p_message_name,
896: 'ITEMNAME',l_new_item_name,
897: 'CURRENT_QUANTITY',p_current_quantity,
898: 'NEW_QUANTITY',p_new_quantity,
899: 'COMPONENTCODE',p_component_code,

Line 1173: -- l_report_status := CZ_UTILS.REPORT (v_parse_message,1,'ITEM DELTA',1);

1169: WHEN NO_INPUT_HDR_EXCEP THEN
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

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 1181: -- l_report_status := CZ_UTILS.REPORT (l_config_err_msg,1,'ITEM DELTA',1);

1177: WHEN OTHERS THEN
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: -------------------------------------------------------------------------

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 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 1861: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug,

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);
1863: END IF;
1864:
1865: l_nDebug := 2;

Line 1893: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'pseudo hdr=' ||

1889: ,'0'
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;

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 2063: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'item sequences reordered',

2059: SET sequence_nbr = l_seq_nbr_tbl(i)
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;

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 2227: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'attr sequences reordered',

2223: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
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:

Line 2245: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'validation status: ' ||

2241: ,x_config_xml_msg
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');

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 2565: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'validation status: ' ||

2561: ,config_messages
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

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 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 3086: l_organization_id := cz_utils.conv_num(substr(product_key, 1, l_colon_pos-1));

3082:
3083: IF l_publication_id IS NULL THEN
3084: l_colon_pos := instr(product_key, ':');
3085: IF l_colon_pos > 0 THEN
3086: l_organization_id := cz_utils.conv_num(substr(product_key, 1, l_colon_pos-1));
3087: l_inventory_item_id := cz_utils.conv_num(substr(product_key, l_colon_pos+1));
3088: END IF;
3089:
3090: IF l_organization_id IS NULL OR l_inventory_item_id IS NULL THEN

Line 3087: l_inventory_item_id := cz_utils.conv_num(substr(product_key, l_colon_pos+1));

3083: IF l_publication_id IS NULL THEN
3084: l_colon_pos := instr(product_key, ':');
3085: IF l_colon_pos > 0 THEN
3086: l_organization_id := cz_utils.conv_num(substr(product_key, 1, l_colon_pos-1));
3087: l_inventory_item_id := cz_utils.conv_num(substr(product_key, l_colon_pos+1));
3088: END IF;
3089:
3090: IF l_organization_id IS NULL OR l_inventory_item_id IS NULL THEN
3091: ui_type := NULL;

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 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 4039: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);

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);
4041:
4042: END register_model_to_pool_cp;
4043: --------------------------------------------------------------------------------

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 4079: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);

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);
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:

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 4136: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);

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);
4138:
4139: END unregister_model_from_pool_cp;
4140:

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 4156: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);

4152: COMMIT;
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:

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 4177: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);

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

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 4195: errbuf:=CZ_UTILS.GET_TEXT('CZ_FATAL_INSTRUCTIONS','ERRORTEXT',SQLERRM);

4191: COMMIT;
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:

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 4221: xError := cz_utils.log_report('Provided model with ID= ' || inDevlProjectId

4217: AND object_type = 'PRJ' AND object_id = d.devl_project_id)
4218: AND orig_sys_ref IS NOT NULL;
4219: EXCEPTION
4220: WHEN NO_DATA_FOUND THEN
4221: xError := cz_utils.log_report('Provided model with ID= ' || inDevlProjectId
4222: || 'does not exist in the Repository.',1,'enable_model_for_import',9991,null);
4223: xStatus := 'ERR' ;
4224: RAISE;
4225: WHEN OTHERS THEN

Line 4226: xError := cz_utils.log_report('Error retrieving record for Model ID= ' ||

4222: || 'does not exist in the Repository.',1,'enable_model_for_import',9991,null);
4223: xStatus := 'ERR' ;
4224: RAISE;
4225: WHEN OTHERS THEN
4226: xError := cz_utils.log_report('Error retrieving record for Model ID= ' ||
4227: inDevlProjectId || ': ' || SQLERRM,1,'enable_model_for_import',9992,null);
4228: xStatus := 'ERR' ;
4229: RAISE;
4230: END ;

Line 4246: xError := cz_utils.log_report('Error: Another copy of the model enabled for Import : '

4242: --dbms_output.put_line('model id from Orig_sys_ref ' || lModelId);
4243:
4244: IF (lModelId <> inDevlProjectId) THEN
4245: --dbms_output.put_line('Can not enable model id ' || inDevlProjectId);
4246: xError := cz_utils.log_report('Error: Another copy of the model enabled for Import : '
4247: || lModelId || '. Disable it before enabling model ' ||inDevlProjectId ,1,'enable_model_for_import',9993,null);
4248: xStatus := 'ERR' ;
4249: END IF;
4250: EXCEPTION

Line 4256: xError := cz_utils.log_report('Model enabled for Import : '

4252: BEGIN
4253: UPDATE cz_devl_projects SET import_enabled = '1'
4254: WHERE deleted_flag = '0'
4255: AND devl_project_id = inDevlProjectId ;
4256: xError := cz_utils.log_report('Model enabled for Import : '
4257: || inDevlProjectId ,1,'enable_model_for_import',9994,null);
4258:
4259: EXCEPTION
4260: WHEN OTHERS THEN

Line 4261: xError := cz_utils.log_report('Error enabling model for Import with model id= ' ||

4257: || inDevlProjectId ,1,'enable_model_for_import',9994,null);
4258:
4259: EXCEPTION
4260: WHEN OTHERS THEN
4261: xError := cz_utils.log_report('Error enabling model for Import with model id= ' ||
4262: inDevlProjectId || ': ' || SQLERRM,1,'enable_model_for_import',9995,null);
4263: xStatus := 'ERR' ;
4264: RAISE;
4265: END;

Line 4267: xError := cz_utils.log_report('Error: Multiple copies of the model enabled for Import : ('

4263: xStatus := 'ERR' ;
4264: RAISE;
4265: END;
4266: WHEN TOO_MANY_ROWS THEN
4267: xError := cz_utils.log_report('Error: Multiple copies of the model enabled for Import : ('
4268: || lOSR || ')',1,'enable_model_for_import',9996,null);
4269: xStatus := 'ERR' ;
4270: RAISE;
4271: WHEN OTHERS THEN

Line 4272: xError := cz_utils.log_report('Error retrieving record for Model with orig_sys_ref= ' ||

4268: || lOSR || ')',1,'enable_model_for_import',9996,null);
4269: xStatus := 'ERR' ;
4270: RAISE;
4271: WHEN OTHERS THEN
4272: xError := cz_utils.log_report('Error retrieving record for Model with orig_sys_ref= ' ||
4273: lOSR || ': ' || SQLERRM,1,'enable_model_for_import',9997,null);
4274: xStatus := 'ERR' ;
4275: RAISE;
4276: END;

Line 4298: xError := cz_utils.log_report('Provided model with ID= ' || inDevlProjectId

4294: AND object_type = 'PRJ' AND object_id = d.devl_project_id)
4295: AND orig_sys_ref IS NOT NULL ;
4296: EXCEPTION
4297: WHEN NO_DATA_FOUND THEN
4298: xError := cz_utils.log_report('Provided model with ID= ' || inDevlProjectId
4299: || 'does not exist in the Repository.',1,'disable_model_for_import',9991,null);
4300: xStatus := 'ERR' ;
4301: RAISE;
4302: WHEN OTHERS THEN

Line 4303: xError := cz_utils.log_report('Error retrieving record for Model ID= ' ||

4299: || 'does not exist in the Repository.',1,'disable_model_for_import',9991,null);
4300: xStatus := 'ERR' ;
4301: RAISE;
4302: WHEN OTHERS THEN
4303: xError := cz_utils.log_report('Error retrieving record for Model ID= ' ||
4304: inDevlProjectId || ': ' || SQLERRM,1,'disable_model_for_import',9992,null);
4305: xStatus := 'ERR' ;
4306: RAISE;
4307: END ;

Line 4318: xError := cz_utils.log_report('Error while disabling the model for import. Model ID= ' ||

4314: COMMIT;
4315: xStatus := 'OK' ;
4316: EXCEPTION
4317: WHEN OTHERS THEN
4318: xError := cz_utils.log_report('Error while disabling the model for import. Model ID= ' ||
4319: inDevlProjectId || ': ' || SQLERRM,1,'disable_model_for_import',9999,null);
4320: commit;
4321: xStatus := 'ERR' ;
4322: END;

Line 4328: id_increment := cz_utils.conv_num(get_db_setting('SCHEMA', 'ORACLESEQUENCEINCR'));

4324: END disable_model_for_import;
4325: --------------------------------------------------------------------------------
4326:
4327: BEGIN
4328: id_increment := cz_utils.conv_num(get_db_setting('SCHEMA', 'ORACLESEQUENCEINCR'));
4329: IF id_increment IS NULL THEN
4330: id_increment := default_incr;
4331: END IF;
4332: