DBA Data[Home] [Help]

APPS.CZ_NETWORK_API_PUB dependencies on CZ_UTILS

Line 214: l_err_buf := CZ_UTILS.GET_TEXT('CZ_NET_API_DEL_CFG_ERR','ConfigHdrId',

210: l_usage_exists,
211: l_error_message,
212: l_Return_value);
213: IF (l_Return_value <> 1) THEN
214: l_err_buf := CZ_UTILS.GET_TEXT('CZ_NET_API_DEL_CFG_ERR','ConfigHdrId',
215: p_config_model_tbl(i).config_hdr_id,'ConfigRevNbr',p_config_model_tbl(i).config_rev_nbr);
216: END IF;
217: END LOOP;
218: END IF;

Line 221: l_err_buf := CZ_UTILS.GET_TEXT('CZ_NET_API_DEL_CONFIG_ERR');

217: END LOOP;
218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN
221: l_err_buf := CZ_UTILS.GET_TEXT('CZ_NET_API_DEL_CONFIG_ERR');
222: set_error_message(l_err_code,l_msg_count,l_msg_data,l_err_buf);
223: set_error_message(l_err_code,l_msg_count,l_msg_data,'delete config err');
224: END delete_configuration;
225: ---------------------------------------------------------------------------

Line 1364: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_VERSION_ERR', 'CODEVERSION', l_api_version, 'VERSION', p_api_version);

1360: x_return_status);
1361: COMMIT;
1362: EXCEPTION
1363: WHEN G_INCOMPATIBLE_API THEN
1364: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_VERSION_ERR', 'CODEVERSION', l_api_version, 'VERSION', p_api_version);
1365: set_fnd_message('CZ_NET_API_VERSION_ERR','CODEVERSION',l_api_version, 'VERSION', p_api_version);
1366: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1367: COMMIT;
1368: WHEN INVALID_VALIDATION_TYPE THEN

Line 1369: l_errbuf := CZ_UTILS.GET_TEXT('CZ_BV_INVALID_TYPE','TYPE',p_validation_type);

1365: set_fnd_message('CZ_NET_API_VERSION_ERR','CODEVERSION',l_api_version, 'VERSION', p_api_version);
1366: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1367: COMMIT;
1368: WHEN INVALID_VALIDATION_TYPE THEN
1369: l_errbuf := CZ_UTILS.GET_TEXT('CZ_BV_INVALID_TYPE','TYPE',p_validation_type);
1370: set_fnd_message('CZ_BV_INVALID_TYPE','TYPE',p_validation_type);
1371: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1372: COMMIT;
1373: WHEN NO_INPUT_RECORDS THEN

Line 1374: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_config_tbl','PROC',l_api_name );

1370: set_fnd_message('CZ_BV_INVALID_TYPE','TYPE',p_validation_type);
1371: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1372: COMMIT;
1373: WHEN NO_INPUT_RECORDS THEN
1374: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_config_tbl','PROC',l_api_name );
1375: set_fnd_message('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_config_tbl','PROC',l_api_name);
1376: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1377: COMMIT;
1378: WHEN INPUT_TREE_MODE_NULL THEN

Line 1379: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);

1375: set_fnd_message('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_config_tbl','PROC',l_api_name);
1376: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1377: COMMIT;
1378: WHEN INPUT_TREE_MODE_NULL THEN
1379: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1380: set_fnd_message('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1381: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1382: COMMIT;
1383: WHEN NO_VALIDATION_CONTEXT THEN

Line 1384: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);

1380: set_fnd_message('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1381: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1382: COMMIT;
1383: WHEN NO_VALIDATION_CONTEXT THEN
1384: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);
1385: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1386: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1387: COMMIT;
1388: WHEN INVALID_CONTEXT THEN

Line 1389: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);

1385: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1386: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1387: COMMIT;
1388: WHEN INVALID_CONTEXT THEN
1389: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);
1390: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1391: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1392: COMMIT;
1393: WHEN INVALID_CONTAINER_HDR THEN

Line 1394: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_SESSION_HDR','HDRID',l_config_hdr_id,'REV',l_config_rev_nbr);

1390: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1391: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1392: COMMIT;
1393: WHEN INVALID_CONTAINER_HDR THEN
1394: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_SESSION_HDR','HDRID',l_config_hdr_id,'REV',l_config_rev_nbr);
1395: set_fnd_message('CZ_NET_API_NO_SESSION_HDR','HDRID',l_config_hdr_id,'REV',l_config_rev_nbr);
1396: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1397: delete_configuration(x_config_model_tbl);
1398: x_config_model_tbl.DELETE;

Line 1401: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_INST_HDR',

1397: delete_configuration(x_config_model_tbl);
1398: x_config_model_tbl.DELETE;
1399: COMMIT;
1400: WHEN INVALID_HEADER_TYPE THEN
1401: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_INST_HDR',
1402: 'modelInstType', l_model_instantiation_type,
1403: 'compInstType' , l_component_instance_type,
1404: 'Hdr',l_config_hdr_id,
1405: 'Rev',l_config_rev_nbr);

Line 1416: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr);

1412: delete_configuration(x_config_model_tbl);
1413: x_config_model_tbl.DELETE;
1414: COMMIT;
1415: WHEN INVALID_INV_ORG_ID THEN
1416: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr);
1417: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr);
1418: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1419: delete_configuration(x_config_model_tbl);
1420: x_config_model_tbl.DELETE;

Line 1423: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);

1419: delete_configuration(x_config_model_tbl);
1420: x_config_model_tbl.DELETE;
1421: COMMIT;
1422: WHEN INVALID_OUT_INV_ORG_ID THEN
1423: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);
1424: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);
1425: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1426: IF x_config_model_tbl.COUNT>0 AND p_validation_type<>CZ_API_PUB.VALIDATE_RETURN THEN
1427: delete_configuration(x_config_model_tbl);

Line 1432: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);

1428: x_config_model_tbl.DELETE;
1429: END IF;
1430: COMMIT;
1431: WHEN INVALID_TREE_MODE_ERR THEN
1432: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1433: set_fnd_message('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1434: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1435: delete_configuration(x_config_model_tbl);
1436: x_config_model_tbl.DELETE;

Line 1439: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_DIFF_ORGS');

1435: delete_configuration(x_config_model_tbl);
1436: x_config_model_tbl.DELETE;
1437: COMMIT;
1438: WHEN ORG_ID_EXCEP THEN
1439: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_DIFF_ORGS');
1440: set_fnd_message('CZ_NET_API_DIFF_ORGS',null,null, null, null);
1441: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1442: delete_configuration(x_config_model_tbl);
1443: x_config_model_tbl.DELETE;

Line 1446: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_COPY_CONFIG_ERR', 'HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr,'ERR',l_copy_config_msg);

1442: delete_configuration(x_config_model_tbl);
1443: x_config_model_tbl.DELETE;
1444: COMMIT;
1445: WHEN COPY_CONFIG_FAILURE_EXCEP THEN
1446: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_COPY_CONFIG_ERR', 'HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr,'ERR',l_copy_config_msg);
1447: set_fnd_message('CZ_NET_API_COPY_CONFIG_ERR','HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr,'ERR',l_copy_config_msg,null,null);
1448: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1449: delete_configuration(x_config_model_tbl);
1450: x_config_model_tbl.DELETE;

Line 1453: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_SESSION_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);

1449: delete_configuration(x_config_model_tbl);
1450: x_config_model_tbl.DELETE;
1451: COMMIT;
1452: WHEN INVALID_HEADER_EXCEP THEN
1453: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_SESSION_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1454: set_fnd_message('CZ_NET_API_NO_SESSION_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1455: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1456: delete_configuration(x_config_model_tbl);
1457: x_config_model_tbl.DELETE;

Line 1460: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg);

1456: delete_configuration(x_config_model_tbl);
1457: x_config_model_tbl.DELETE;
1458: COMMIT;
1459: WHEN BATCH_VALID_ERR THEN
1460: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg);
1461: set_fnd_message('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg,null,null);
1462: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1463: delete_configuration(x_config_model_tbl);
1464: x_config_model_tbl.DELETE;

Line 1468: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_PARSE_BV_XML_ERR','Err',l_config_err_msg,1,2000);

1464: x_config_model_tbl.DELETE;
1465: COMMIT;
1466: WHEN PARSE_XML_ERROR THEN
1467: l_config_err_msg := get_terminate_msg(v_xml_str);
1468: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_PARSE_BV_XML_ERR','Err',l_config_err_msg,1,2000);
1469: set_fnd_message('CZ_NET_API_PARSE_BV_XML_ERR', 'ERR', substr(v_xml_str,1,2000),null,null);
1470: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1471: delete_configuration(x_config_model_tbl);
1472: x_config_model_tbl.DELETE;

Line 1808: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_VERSION_ERR', 'CODEVERSION', l_api_version, 'VERSION', p_api_version);

1804: ,x_return_status,x_msg_count,x_msg_data);
1805: COMMIT;
1806: EXCEPTION
1807: WHEN G_INCOMPATIBLE_API THEN
1808: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_VERSION_ERR', 'CODEVERSION', l_api_version, 'VERSION', p_api_version);
1809: set_fnd_message('CZ_NET_API_VERSION_ERR','CODEVERSION',l_api_version, 'VERSION', p_api_version);
1810: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1811: COMMIT;
1812: WHEN NO_INPUT_RECORDS THEN

Line 1813: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_instance_tbl','PROC',l_api_name );

1809: set_fnd_message('CZ_NET_API_VERSION_ERR','CODEVERSION',l_api_version, 'VERSION', p_api_version);
1810: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1811: COMMIT;
1812: WHEN NO_INPUT_RECORDS THEN
1813: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_instance_tbl','PROC',l_api_name );
1814: set_fnd_message('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_instance_tbl','PROC',l_api_name);
1815: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1816: COMMIT;
1817: WHEN INVALID_HEADER_TYPE THEN

Line 1818: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_INST_HDR','modelInstType', l_model_instantiation_type,

1814: set_fnd_message('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_instance_tbl','PROC',l_api_name);
1815: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1816: COMMIT;
1817: WHEN INVALID_HEADER_TYPE THEN
1818: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_INST_HDR','modelInstType', l_model_instantiation_type,
1819: 'compInstType',l_component_instance_type,'Hdr',l_config_hdr_id,
1820: 'Rev',l_config_rev_nbr);
1821: set_fnd_message('CZ_NET_API_INVALID_INST_HDR','modelInstType', l_model_instantiation_type,
1822: 'compInstType',l_component_instance_type,'Hdr',l_config_hdr_id,

Line 1827: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);

1823: 'Rev',l_config_rev_nbr);
1824: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1825: COMMIT;
1826: WHEN INVALID_CONTEXT THEN
1827: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);
1828: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX',p_validation_context, null, null);
1829: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1830: COMMIT;
1831: WHEN NO_VALIDATION_CONTEXT THEN

Line 1832: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context);

1828: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX',p_validation_context, null, null);
1829: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1830: COMMIT;
1831: WHEN NO_VALIDATION_CONTEXT THEN
1832: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context);
1833: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1834: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1835: COMMIT;
1836: WHEN INVALID_INV_ORG_ID THEN

Line 1837: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);

1833: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1834: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1835: COMMIT;
1836: WHEN INVALID_INV_ORG_ID THEN
1837: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1838: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1839: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1840: COMMIT;
1841: WHEN MODEL_ORG_EXCEP THEN

Line 1842: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_MODELID_ORGID_ERR',

1838: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1839: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1840: COMMIT;
1841: WHEN MODEL_ORG_EXCEP THEN
1842: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_MODELID_ORGID_ERR',
1843: 'ITEM1',l_inventory_item_id,
1844: 'ORGID1',l_organization_id,
1845: 'HDRID',p_config_hdr_id,
1846: 'REVNBR',p_config_rev_nbr,

Line 1859: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg);

1855: 'ORGID2',p_organization_id);
1856: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1857: COMMIT;
1858: WHEN BATCH_VALID_ERR THEN
1859: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg);
1860: set_fnd_message('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg, null, null);
1861: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1862: COMMIT;
1863: WHEN PARSE_XML_ERROR THEN

Line 1865: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_PARSE_BV_XML_ERR','ERR',l_config_err_msg);

1861: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1862: COMMIT;
1863: WHEN PARSE_XML_ERROR THEN
1864: l_config_err_msg := get_terminate_msg(v_xml_str);
1865: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_PARSE_BV_XML_ERR','ERR',l_config_err_msg);
1866: set_fnd_message('CZ_NET_API_NO_CFG_HDR', 'ERR', substr(v_xml_str,1,2000),null,null);
1867: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1868: COMMIT;
1869: WHEN GEN_CONFIG_TREE_ERR THEN

Line 1870: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_TREE_GEN_ERR','HDR',l_config_hdr_id,'REV',l_config_rev_nbr);

1866: set_fnd_message('CZ_NET_API_NO_CFG_HDR', 'ERR', substr(v_xml_str,1,2000),null,null);
1867: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1868: COMMIT;
1869: WHEN GEN_CONFIG_TREE_ERR THEN
1870: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_TREE_GEN_ERR','HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1871: set_fnd_message('CZ_NET_API_TREE_GEN_ERR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1872: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1873: COMMIT;
1874: WHEN OTHERS THEN