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 238: error_message:=CZ_UTILS.GET_TEXT('CZ_INCOMPAT_COPY_CFG');

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

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

440:
441: EXCEPTION
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);

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

456:
457: WHEN OTHERS THEN
458: Return_value:=0;
459: IF (error_message IS NOT NULL) THEN
460: Error_message := CZ_UTILS.GET_TEXT('CZ_CFG_DEL_ERROR', 'HDRID', in_config_hdr_id, 'REVNBR', in_config_rev_nbr, 'ERRMSG', error_message);
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;

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

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

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

855: l_new_item_name);
856: l_msg_seq := get_next_msg_seq;
857:
858: IF ( (p_message_name = ITEM_DELETE_MESSAGE) OR (p_message_name = ITEM_ADD_MESSAGE ) ) THEN
859: l_delta_message := CZ_UTILS.GET_TEXT(p_message_name,
860: 'ITEMNAME',l_new_item_name,
861: 'QUANTITY',p_current_quantity,
862: 'COMPONENTCODE',p_component_code,
863: 'DESCRIPTION',l_description);

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

861: 'QUANTITY',p_current_quantity,
862: 'COMPONENTCODE',p_component_code,
863: 'DESCRIPTION',l_description);
864: ELSIF (p_message_name = QTY_CHANGE_MESSAGE ) THEN
865: l_delta_message := CZ_UTILS.GET_TEXT(p_message_name,
866: 'ITEMNAME',l_new_item_name,
867: 'CURRENT_QUANTITY',p_current_quantity,
868: 'NEW_QUANTITY',p_new_quantity,
869: 'COMPONENTCODE',p_component_code,

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

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

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

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

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

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);
1510: END IF;
1511:
1512: l_nDebug := 2;

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

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

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

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

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

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

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

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

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

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

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

2682:
2683: IF l_publication_id IS NULL THEN
2684: l_colon_pos := instr(product_key, ':');
2685: IF l_colon_pos > 0 THEN
2686: l_organization_id := cz_utils.conv_num(substr(product_key, 1, l_colon_pos-1));
2687: l_inventory_item_id := cz_utils.conv_num(substr(product_key, l_colon_pos+1));
2688: END IF;
2689:
2690: IF l_organization_id IS NULL OR l_inventory_item_id IS NULL THEN

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

2683: IF l_publication_id IS NULL THEN
2684: l_colon_pos := instr(product_key, ':');
2685: IF l_colon_pos > 0 THEN
2686: l_organization_id := cz_utils.conv_num(substr(product_key, 1, l_colon_pos-1));
2687: l_inventory_item_id := cz_utils.conv_num(substr(product_key, l_colon_pos+1));
2688: END IF;
2689:
2690: IF l_organization_id IS NULL OR l_inventory_item_id IS NULL THEN
2691: ui_type := NULL;

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 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 3517: id_increment := cz_utils.conv_num(get_db_setting('SCHEMA', 'ORACLESEQUENCEINCR'));

3513: END publication_for_item_mobile;
3514: --------------------------------------------------------------------------------
3515:
3516: BEGIN
3517: id_increment := cz_utils.conv_num(get_db_setting('SCHEMA', 'ORACLESEQUENCEINCR'));
3518: IF id_increment IS NULL THEN
3519: id_increment := default_incr;
3520: END IF;
3521: