6 Appendix: Error Codes

RWMS maintains many API interfaces to support the downloading of specific data used in the application. These interfaces provide both generic and specific return values to the RIB as each message is consumed. The appendices contain the status codes and error messages returned by the API interfaces.

The first table contains the entire list of return values with the status code in numeric order. The second table contains the same list, with the error messages in alphabetic order.

Detail of Procedures

Each CONSUME procedure returns both a status code and an error message. When the message is consumed successfully, the status code returns an S, and the error message is NULL.

Appendix: Error Codes

All error codes pertaining to RIB interface are contained in the RDMRIB_ERROR package.

Error Codes in Numerical Order

The following table includes error codes in numerical order.

Table 6-1 Error Codes in Numerical Order

Error Message	Status Code	Description
k_GENERAL_SUCCESS	S	A message was consumed.
k_GENERAL_API_FAILURE	E	A fatal error occurred in the procedure.
k_GENERAL_INVALID_FACILITY	102	Facility does not exist in the transshipment_setup table.
k_GENERAL_INVALID_ROUTING	103	An invalid destination was passed.
k_GENERAL_PRE_ADDL_PROCESSING	104	An error occurred in pre-additional processing.
k_GENERAL_FACILITY_NOT_FOUND	105	Facility does not exist in the transshipment_setup table.
k_VENDOR_DELETE_ERROR	200	Error while deleting a vendor.
k_VENDOR_OVERWRIT_STATUS_ERROR	201	Errors while retrieving overwrite status values.
k_VENDOR_MISSING_ERROR	202	Cannot delete or modify the record because it does not exist.
k_VENDOR_FOUND_ERROR	203	Cannot create record, record already exists.
k_VENDOR_ADDR_IND_UPDATE_ERROR	204	An error occurred updating the primary address indicator.
k_VENDOR_PRIMARY_KEY_ERROR	205	Primary Key Violation.
k_VENDOR_ADDR_PRIM_KEY_ERROR	206	Primary Key Violation.
k_VENDOR_FK_ERROR	207	Referential Integrity error.
k_VENDOR_ADDR_TYPE_UPD_ERROR	208	Unable to update the Vendor Address description.
k_VENDOR_STATE_FK_ERROR	209	Referential Integrity error.
k_VENDOR_ADDR_MISSING_ERROR	210	Cannot delete or modify the record because it does not exist.
k_VENDOR_ADDR_FOUND_ERROR	211	Cannot create record, record already exists.
k_DIFF_ID_MISSING_ERROR	250	Cannot delete or modify the record because it does not exist.
k_DIFF_INSERT_ERROR	251	Diff ID is already being used as a Diff Group ID.
k_DIFF_PRIMARY_KEY_ERROR	252	Primary Key Violation.
k_DIFF_OTHER_ERROR	253	Unanticipated Differentiator error.
k_DIFF_ID_FOUND_ERROR	254	Cannot create record, record already exists.
k_DIFF_GRP_ID_MISSING_ERROR	300	Cannot delete or modify the record because it does not exist.
k_DIFF_GROUP_INSERT_ERROR	301	A Diff Group already exists.
k_DIFF_GROUP_PRIMARY_KEY_ERROR	302	Primary Key Violation.
k_DIFF_GROUP_OTHER_ERROR	303	An error occurred evaluating the Diff Group ID.
k_DIFF_DELETE_DIFF_GROUP_ERROR	304	An error occurred deleting from the Diff Group Detail table.
k_DIFF_GRP_ID_FOUND_ERROR	306	Cannot create record, record already exists.
k_DIFF_GRP_DET_MISSING_ERROR	350	Cannot delete or modify the record because it does not exist.
k_DIFF_GRP_DET_FOUND_ERROR	351	Cannot create record, record already exists.
k_DIFF_GROUP_DET_PRI_KEY_ERROR	352	Primary Key Violation.
k_DIFF_GROUP_DET_DG_FK_ERROR	353	Referential Integrity error.
k_DIFF_GROUP_DET_DI_FK_ERROR	354	Referential Integrity error.
k_ITEM_UPC_IND_UPDATE_ERROR	400	An error occurred in updating the primary UPC indicator in item_upc.
k_ITEM_SUPP_IND_UPDATE_ERROR	401	An error occurred updating the item_supplier or item_master tables.
k_ITEM_COUNTRY_IND_UPD_ERROR	402	Error updating item_supp_country primary country indicator.
k_ITEM_OVERWRITE_STATUS_ERROR	403	Error when checking if a column can be overwritten.
k_APPT_DETAIL_POD_FK	404	Referential Integrity error.
k_ITEM_VENDOR_REF_ERROR	405	Foreign key error for vendor when creating an item.
k_ITEMM_PK_ERROR	406	Primary Key Violation.
k_ITEMM_UOM_FK_ERROR	407	Referential Integrity error.
k_ITEMM_VDR_FK_ERROR	408	Referential Integrity error.
k_ITEMM_CT_FK_ERROR	409	Referential Integrity error.
k_ITEMM_UPS_FK_ERROR	410	Referential Integrity error.
k_ITEMM_WC_FK_ERROR	411	Referential Integrity error.
k_ITEMUPC_PK_ERROR	412	Primary Key Violation.
k_ITEMUPC_IM_FK_ERROR	413	Referential Integrity error.
k_ITEMUPC_UNIQUE_ERROR	414	Unique error on item_upc UPC number when modifying a record.
k_ITEM_DIFF_PK_ERROR	415	Primary Key Violation.
k_ITEM_SUPP_PK_ERROR	416	Primary Key Violation.
k_ITEM_SUPP_IM_FK_ERROR	417	Referential Integrity error.
k_ITEM_SUPP_VDR_FK_ERROR	418	Referential Integrity error.
k_ISC_PK_ERROR	419	Primary Key Violation.
k_ISC_IS_FK_ERROR	420	Referential Integrity error.
k_ISCD_PK_ERROR	421	Primary Key Violation.
k_ISCD_ISC_FK_ERROR	422	Referential Integrity error.
k_ITEMA_PK_ERROR	423	Primary Key Violation.
k_ITEMA_ATTR_FK_ERROR	424	Referential Integrity error.
k_ITEMA_IM_FK_ERROR	425	Referential Integrity error.
k_PICKFROMLOC_ITEMM_FK_ERROR	426	Referential Integrity error.
k_PICKFROMLOC_LOC_FK_ERROR	427	Referential Integrity error.
k_STOCKA_ITEMM_FK_ERROR	428	Referential Integrity error.
k_ITEMCP_IM_FK_ERROR	429	Referential Integrity error.
k_ITEMCP_CURR_FK_ERROR	430	Referential Integrity error.
k_ITEM_SCD_OTHER_ERROR	431	Error while updating the dimensions of an item.
k_ITEM_CREATE_OTHER_ERROR	432	Unanticipated error while creating an item.
k_ITEM_SUPP_MOD_OTHER_ERROR	433	Unanticipated error while modifying an item.
k_ITEM_SUPP_ITEM_CRE_OTH_ERROR	434	Unanticipated error while modifying the item.
k_ITEM_MOD_MSG_OTHER_ERROR	435	Unanticipated error when modifying an item, item differentiator.
k_ITEM_MISSING_ERROR	436	Cannot delete or modify the record because it does not exist.
k_ITEM_FOUND_ERROR	437	Error when item is created. Item already exists.
k_ITEM_SUPPLIER_MISSING_ERROR	438	Cannot delete or modify the record because it does not exist.
k_ITEM_SUPPLIER_FOUND_ERROR	439	Cannot create record, record already exists.
k_ITEM_SUPP_CTR_MISSING_ERROR	440	Cannot delete or modify the record because it does not exist.
k_ITEM_SUPP_CTR_FOUND_ERROR	441	Cannot create record, record already exists.
k_ITEM_SUPP_CTR_DIM_MISS_ERROR	442	Cannot delete or modify the record because it does not exist.
k_ITEM_SUPP_CTR_DIM_FND_ERROR	443	Cannot create record, record already exists.
k_ITEM_UPC_MISSING_ERROR	444	Cannot delete or modify the record because it does not exist.
k_ITEM_UPC_FOUND_ERROR	445	Cannot create record, record already exists.
k_ITEM_UDA_MISSING_ERROR	446	Cannot delete or modify the record because it does not exist.
k_ITEM_UDA_FOUND_ERROR	447	Cannot create record, record already exists.
k_ITEM_BOM_MISSING_ERROR	448	Cannot delete or modify the record because it does not exist.
k_ITEM_BOM_FOUND_ERROR	449	Cannot create record, record already exists.
k_ITEM_DIFF_FOUND_ERROR	451	Cannot create record, record already exists.
k_ITEM_ATTR_DEFAULTS_ERROR	452	Error when creating item and processing the attributes.
k_ITEMBOM_COMP_MSTR_SAME_ERROR	453	MasterItemID is the same as the ComponentItemID.
k_ITEMBOM_CHECKING_ERROR	454	Error occurred checks to see if the MasterItemID is the same as the ComponentItemID.
k_ITEM_CLASS_ERROR	457	Error applying Item Download class.
k_PO_VENDOR_REF_ERROR	503	Error on the vendor foreign key reference when creating a record.
k_PO_PK_ERROR	504	Primary Key Violation.
k_PO_DETAIL_PK_ERROR	505	Primary Key Violation.
k_PO_DETAIL_PO_ERROR	506	Error on the foreign key reference to PO from PO details when creating a PO detail.
k_PO_DETAIL_ITEM_ERROR	507	Error on the foreign key reference to item from PO details when creating a PO detail.
k_PO_RECEIPT_FK_ERROR	508	Referential Integrity error.
k_PO_CRE_MOD_OTHER_ERROR	509	Unanticipated error while creating a PO.
k_PO_FOUND_ERROR	512	Cannot create record, record already exists.
k_PO_MISSING_ERROR	513	Cannot delete or modify the record because it does not exist.
k_PO_DETAIL_FOUND_ERROR	514	Cannot create record, record already exists.
k_PO_DETAIL_MISSING_ERROR	515	Cannot delete or modify the record because it does not exist.
k_PO_DELIVER_DATE_ERROR	516	Error on the deliver date while creating a PO.
k_PO_CNTRY_VENDOR_ITEM_ERROR	517	PO record exists, cannot delete Vendor.
k_PO_OTHER_ERROR	521	Error validating PO detail required fields.
k_POD_REQUESTED_QTY_ERROR	523	Error validating requested quantity.
k_PO_STATUS_CANNOT_CLOSE_ERROR	524	Error trying to Close a PO where an unreceived appointment exists.
k_PO_STATUS_CHECKING_ERROR	525	Error checking appointment information.
k_ATTRIBUTE_FOUND_ERROR	554	Cannot create record, record already exists.
k_ATTRIBUTE_MISSING_ERROR	555	Cannot delete or modify the record because it does not exist.
k_ATTRIBUTE_OTHER_ERROR	556	Unanticipated error occurred while validating the key.
k_ATTRIBUTE_TYPE_PK_ERROR	559	Primary Key Violation.
k_ATTRIBUTE_TYPE_FK_ERROR	560	Referential Integrity error.
k_ATTRIBUTE_DETAIL_FOUND_ERROR	600	Attribute record already exists.
k_ATTRIBUTE_DETAIL_MISS_ERROR	601	Cannot delete or modify the record because it does not exist.
k_ATTRIBUTE_DETAIL_PK_ERROR	603	Primary Key Violation.
k_ATTRIBUTE_DET_ITEM_FK_ERROR	604	Referential Integrity error.
k_ATTRIBUTE_DET_WIP_FK_ERROR	605	Referential Integrity error.
k_SHIP_OVERWRITE_STATUS_ERROR	650	Error retrieving ship destination overwrite status information.
k_SHIP_DEST_TYPE_NOT_VAL_ERROR	651	An error occurred checking the ship destination type.
k_SHIP_OWNING_DC_ERROR	652	Owning DC not found.
k_SHIP_DEST_FOUND_ERROR	653	Cannot create record, record already exists.
k_SHIP_DEST_MISSING_ERROR	654	Cannot delete or modify the record because it does not exist.
k_SHIP_DEST_REF_CONT_TYP_ERROR	655	Referential Integrity error.
k_SHIP_DEST_REF_UNIT_PCK_ERROR	656	Referential Integrity error.
k_SHIP_DEST_REF_ST_RDM_ERROR	657	Referential Integrity error.
k_SHIP_DEST_REF_PRIM_KEY_ERROR	658	Primary Key Violation.
k_SHIP_DEST_REF_DEF_CSR_ERROR	659	Referential Integrity error.
k_SHIP_DEST_REF_EXP_CSR_ERROR	660	Referential Integrity error.
k_SHIP_DEST_REF_CUR_CODE_ERROR	661	Referential Integrity error.
k_SHIP_DEST_ROUTE_ERROR	662	Referential Integrity error.
k_SHIP_INVALID_DEF_CSR_ERROR	663	Default_Service_Code, Default_Carrier_Code and/or Default_Route values are NULL.
k_SHIP_INVALID_EXP_CSR_ERROR	664	Expedite_Service_Code, Expedite_Carrier_Code and/or Expedite_Route values are NULL.
k_SHIP_MLD_FK_ERROR	665	Referential Integrity error.
k_SHIP_DEST_SEQ_NBR_ERROR	668	Error validating sequence number.
k_ASN_PK_ERROR	700	Primary Key Violation.
k_ASN_ITEM_PK_ERROR	701	Primary Key Violation.
k_ASN_ITEM_ASN_FK_ERROR	702	Referential Integrity error.
k_ASN_ITEM_SD_FK_ERROR	703	Referential Integrity error.
k_ASN_ITEM_POD_FK_ERROR	704	Referential Integrity error.
k_ASN_MISSING_ERROR	705	Cannot delete or modify the record because it does not exist.
k_ASN_FOUND_ERROR	706	Cannot create record, record already exists.
k_ASN_HDR_MOD_OTHER_ERROR	707	Unanticipated error while checking ASN type.
k_ASN_HDR_DEL_OTHER_ERROR	708	Unanticipated Error while checking appointment status for a delete.
k_ASN_ITEM_INVALID_QTY_ERROR	709	Change in unit quantity is less than zero.
k_ASN_ITEM_APPT_ERROR	710	Error, cannot deleted an already appointed ASN.
k_ASN_CNTR_MOD_OTHER_ERROR	711	Unanticipated error while attempting to modify the container.
k_ASN_CNTR_ITEM_CRE_OTH_ERROR	712	Unanticipated error while setting the distributed unit quantity.
k_ASN_CNTR_ITEM_MOD_OTH_ERROR	713	Unanticipated error while setting the distributed unit quantity.
k_ASN_MOD_WRONG_ASN_ERROR	714	Error, ASN type is incorrect.
k_ASN_DEL_NOT_ALLOWED_ERROR	715	Error, status is not received.
k_ASN_PO_DTL_COUNTRY_ERROR	716	Error, country not found in item supplier country.
k_ASN_APPOINT_OPEN_ERROR	717	Error, status in not received or null.
k_ASN_DATA_TRACKING_ERROR	718	Error occurred in ASN processing procedure.
k_ASN_NOZERO_APPT_ASNITM_ERROR	719	Error while deleting ASN item records.
k_VERIFY_ASN_PO_DATE_ERROR	720	Error, the deliver not after date is invalid.
k_VERIFY_ASN_PO_OTHER_ERROR	721	Error occurred verifying ASN Purchase Order.
k_VERIFY_ASN_ITEM_OTHER_ERROR	722	Unanticipated error occurred verifying ASN item record.
k_VERIFY_ASN_OTHER_ERROR	723	Unanticipated error occurred verifying the ASN record.
k_VERIFY_CONTAINER_OTHER_ERROR	724	Unanticipated error occurred verifying the container record.
k_VERIFY_CNTR_ITEM_OTHER_ERROR	725	Unanticipated error occurred verifying the container item record.
k_ASN_POST_ITEM_CRE_OTH_ERROR	726	Unanticipated error occurred in the post processing of ASN items.
k_ASN_POST_WIP_CODE_ERROR	727	Error occurred in the combine WIP codes procedure.
k_ASN_PO_INVALID_PO_ERROR	728	The PO is invalid for this ASN.
k_ASN_INVALID_STORE_DATE_ERROR	730	The In Store Date is invalid.
k_ASN_CONT_INVALID_ASN_ERROR	735	The ASN is incorrect for this container.
k_CONT_PK_ERROR	750	Primary Key Violation.
k_CONT_SD_FK_ERROR	751	Referential Integrity error.
k_CONT_LOC_FK1_ERROR	752	Referential Integrity error.
k_CONT_LOC_FK2_ERROR	753	Referential Integrity error.
k_CONT_CT_FK_ERROR	754	Referential Integrity error.
k_CONT_LOC_FK3_ERROR	755	Referential Integrity error.
k_CONT_ITEM_PK_ERROR	756	Primary Key Violation.
k_CONT_ITEM_CONT_FK_ERROR	757	Referential Integrity error.
k_CONT_ITEM_IM_FK_ERROR	758	Referential Integrity error.
k_CONT_MISSING_ERROR	759	Cannot delete or modify the record because it does not exist.
k_CONT_FOUND_ERROR	760	Cannot create record, record already exists.
k_CONT_ITEM_MISSING_ERROR	761	Cannot delete or modify the record because it does not exist.
k_CONT_ITEM_FOUND_ERROR	762	Cannot create record, record already exists.
k_STOCKO_PK_ERROR	800	Primary Key Violation.
k_STOCKO_STATE_FK1_ERROR	801	Referential Integrity error.
k_STOCKO_STATE_FK2_ERROR	802	Referential Integrity error.
k_STOCKO_PO_FK_ERROR	803	Referential Integrity error.
k_STOCK_NULL_SHIP_FIELD_ERROR	804	Error in ship field(s) when creating a stock order. One of the field(s) is null.
k_STOCK_PICK_DATE_ERROR	805	Error in the pick date when creating a stock order.
k_STOCK_MOD_CRE_OTHER_ERROR	806	Unanticipated error while modifying a stock order.
k_STOCK_ORDER_CRE_OTHER_ERROR	807	Unanticipated error while creating a stock order.
k_STOCKA_UP_REF1_ERROR	808	Referential Integrity error.
k_STOCKA_STOCKO_FK_ERROR	809	Referential Integrity error.
k_STOCKA_SHIPD_FK_ERROR	810	Referential Integrity error.
k_STOCK_INV_CARR_SERV_ERROR	811	Invalid carrier service when creating a stock order.
k_STOCK_INV_CARRIER_ERROR	812	Invalid carrier when creating a stock order.
k_STOCK_INV_CSR_ERROR	813	Invalid carrier service route when creating a stock order.
k_STOCK_ORDER_MISSING_ERROR	814	Cannot delete or modify the record because it does not exist.
k_STOCK_ORDER_FOUND_ERROR	815	Cannot create record, record already exists.
k_STOCK_ALLOC_MISSING_ERROR	816	Cannot delete or modify the record because it does not exist.
k_STOCK_ALLOC_FOUND_ERROR	817	Cannot create record, record already exists.
k_STOCK_MODIFY_OTHER_ERROR	818	Unanticipated error while modifying a stock order.
k_STOCK_DISTRIBUTION_ERROR	819	Invalid stock distribution error while modifying a stock order.
k_STOCK_UNCARTONIZE_ERROR	820	Error during the uncartonize process when stock orders are modified. The error occurs during the call to the perform cartonization package.
k_STOCK_ALLOC_CRE_OTHER_ERROR	821	Unanticipated error in the standard UOM when creating a stock order.
k_ST_ALLOC_CRE_MOD_OTHER_ERROR	822	Unanticipated error while creating a stock order.
k_ST_ALLOC_INSTORE_DATE_ERROR	823	In store date error while creating a stock order.
k_ST_ALLOC_MODIFY_OTHER_ERROR	824	Unanticipated error while modifying a stock allocation.
k_STOCK_DELETE_OTHER_ERROR	825	Unanticipated error while generating a SD stock order info status message when a stock allocation is deleted.
k_STOCK_CARTONIZATION_ERROR	826	Error in cartonization during the call to perform cartonization when a stock order is created.
k_SA_IN_DISTRIBUTION_ERROR	829	Stock Allocation is in distribution.
k_SO_IN_DISTRIBUTION_ERROR	830	Stock Order has an Allocation in distribution.
k_STOCK_REQUIRED_PO_ERROR	831	Missing PO number.
k_SA_NOT_FOUND_DELETE_ERROR	832	Cannot create the Stock Order Info Upload record, Stock Allocation record does not exist.
k_SO_INV_CD_DEST_TYPE	833	Invalid dest type when consumer_direct flag is N and DEST_TYPE is Virtual.
k_BOM_PK_ERROR	850	Primary Key Violation.
k_BOM_IM_FK1_ERROR	851	Referential Integrity error.
k_BOM_IM_FK2_ERROR	852	Referential Integrity error.
k_INBOUND_WO_PK_ERROR	900	Primary Key Violation.
k_INBOUND_WO_PO_FK_ERROR	901	Referential Integrity error.
k_INBOUND_WO_SD_FK_ERROR	902	Referential Integrity error.
k_INBOUND_WO_WIP_FK_ERROR	903	Referential Integrity error.
k_INBOUND_WO_FOUND_ERROR	904	Cannot create record, record already exists.
k_INBOUND_WO_MISSING_ERROR	905	Cannot delete or modify the record because it does not exist.
k_INBOUND_DEST_XML_OTHER_ERROR	906	Unanticipated
k_PENDING_RETURN_PK_ERROR	950	Primary Key Violation.
k_PENDING_RET_DET_PK_ERROR	952	Primary Key Violation.
k_PENDRET_DET_FK_PR_ERROR	953	Referential Integrity error.
k_PENDING_RETURN_FOUND_ERROR	954	Cannot create record, record already exists.
k_PENDING_RETURN_MISSING_ERROR	955	Cannot delete or modify the record because it does not exist.
k_PENDRET_DEST_XML_OTHER_ERROR	958	Unanticipated
k_PENDRET_ITEM_FK_ERROR	959	Referential Integrity error.
k_OUTBOUND_DEST_XML_OTH_ERROR	1001	Unanticipated
k_OBWO_STOCK_ALLOC_FK_ERROR	1002	Referential Integrity error.
k_OBWO_WIP_FK_ERROR	1003	Referential Integrity error.
k_OUTBOUND_WO_MISSING_ERROR	1004	Cannot delete or modify the record because it does not exist.
k_OUTBOUND_WO_FOUND_ERROR	1005	Cannot create record, record already exists.
k_SKU_ADD_OTHER_ERROR	1100	Unanticipated
k_SKU_MISSING_ERROR	1101	Cannot delete or modify the record because it does not exist.
k_SKU_FOUND_ERROR	1102	Task_Queue record already exists.
k_TASK_QUEUE_ACT_CODE_FK_ERROR	1103	Referential Integrity error.
k_TASK_QUEUE_WAVE_FK_ERROR	1104	Referential Integrity error.
k_TASK_QUEUE_ITEM_FK_ERROR	1105	Referential Integrity error.
k_STATE_NOT_FOUND_ERROR	10501	Cannot create record, record already exists.
k_COUNTRY_NOT_FOUND_ERROR	10502	Cannot create record, record already exists.
k_CURRENCY_NOT_FOUND_ERROR	10503	Cannot create record, record already exists.
k_CONTAINER_NOT_FOUND_ERROR	10504	Cannot create record, record already exists.
k_ITEM_UPDATE_COLUMNS_ERROR	10505	Cannot create record, record already exists.
k_PICK_DIR_SO_FK_ERROR	10506	Referential Integrity error.
k_COMP_TICK_STOCKO_ERROR	10507	Referential Integrity error.
k_KIT_BUILD_REF3_ERROR	10508	Referential Integrity error.
k_SORTED_ALLOC_REF1_ERROR	10510	Referential Integrity error.
k_DISTRO_IS_REF1_ERROR	10511	Referential Integrity error.
k_STOCKA_CID_REF1	10512	Referential Integrity error.
k_SCHDULE_NBR_NULL	10515	Schedule Number is null.
k_PO_NULL_ERROR	10516	PO Number published by host system is null.
k_ITEM_NULL_ERROR	10517	Item ID published by host system is null.
k_PO_INVALID_ERROR	10518	PO does not exist in PO table.
k_ITEM_INVALID_ERROR	10519	Item does not exist in PO_Detail table.
k_ITEM_LOC_INFO_MISSING	10520	Message arrived with no value for Item_Id
k_ITEM_LOC_NOT_FOUND	10521	Dest_Id is is not a valid DC Dest Id.
k_RETURNABLE_FLAG_UPD_ERROR	10522	No records were found for the Dest_Id, Item_Id combination.
k_COMB_CODE_INFO_MISSING	10523	Code type or Code is missing in the seed data.
k_COMB_CODE_INS_ERROR	10524	Unanticipated error while inserting Combinability Code.
k_COMB_CODE_UPD_ERROR	10525	Unanticipated error while updating Combinability Code.
k_COMB_CODE_DEL_ERROR	10526	Unanticipated error while deleting Combinability Code.

Error Codes in Alphabetical Order

The following table includes error codes in alphabetical order.

Table 6-2 Error Codes in Alphabetical Order

Error Message	Status Code	Description
k_APPT_DETAIL_POD_FK	404	Referential Integrity error.
k_ASN_APPOINT_OPEN_ERROR	717	Error, status in not received or null.
k_ASN_CNTR_ITEM_CRE_OTH_ERROR	712	Unanticipated error while setting the distributed unit quantity.
k_ASN_CNTR_ITEM_MOD_OTH_ERROR	713	Unanticipated error while setting the distributed unit quantity.
k_ASN_CNTR_MOD_OTHER_ERROR	711	Unanticipated error while attempting to modify the container.
k_ASN_CONT_INVALID_ASN_ERROR	735	The ASN is incorrect for this container.
k_ASN_DATA_TRACKING_ERROR	718	Error occurred in ASN processing procedure.
k_ASN_DEL_NOT_ALLOWED_ERROR	715	Error, status is not received.
k_ASN_FOUND_ERROR	706	Cannot create record, record already exists.
k_ASN_HDR_DEL_OTHER_ERROR	708	Unanticipated Error while checking appointment status for a delete.
k_ASN_HDR_MOD_OTHER_ERROR	707	Unanticipated error while checking ASN type.
k_ASN_INVALID_STORE_DATE_ERROR	730	The In Store Date is invalid.
k_ASN_ITEM_APPT_ERROR	710	Error, cannot deleted an already appointed ASN.
k_ASN_ITEM_ASN_FK_ERROR	702	Referential Integrity error.
k_ASN_ITEM_INVALID_QTY_ERROR	709	Change in unit quantity is less than zero.
k_ASN_ITEM_PK_ERROR	701	Primary Key Violation.
k_ASN_ITEM_POD_FK_ERROR	704	Referential Integrity error.
k_ASN_ITEM_SD_FK_ERROR	703	Referential Integrity error.
k_ASN_MISSING_ERROR	705	Cannot delete or modify the record because it does not exist.
k_ASN_MOD_WRONG_ASN_ERROR	714	Error, ASN type is incorrect.
k_ASN_NOZERO_APPT_ASNITM_ERROR	719	Error while deleting ASN item records.
k_ASN_PK_ERROR	700	Primary Key Violation.
k_ASN_PO_DTL_COUNTRY_ERROR	716	Error, country not found in item supplier country.
k_ASN_PO_INVALID_PO_ERROR	728	The PO is invalid for this ASN.
k_ASN_POST_ITEM_CRE_OTH_ERROR	726	Unanticipated error occurred in the post processing of ASN items.
k_ASN_POST_WIP_CODE_ERROR	727	Error occurred in the combine WIP codes procedure.
k_ATTRIBUTE_DET_ITEM_FK_ERROR	604	Referential Integrity error.
k_ATTRIBUTE_DET_WIP_FK_ERROR	605	Referential Integrity error.
k_ATTRIBUTE_DETAIL_FOUND_ERROR	600	Attribute record already exists.
k_ATTRIBUTE_DETAIL_MISS_ERROR	601	Cannot delete or modify the record because it does not exist.
k_ATTRIBUTE_DETAIL_PK_ERROR	603	Primary Key Violation.
k_ATTRIBUTE_FOUND_ERROR	554	Cannot create record, record already exists.
k_ATTRIBUTE_MISSING_ERROR	555	Cannot delete or modify the record because it does not exist.
k_ATTRIBUTE_OTHER_ERROR	556	Unanticipated error occurred while validating the key.
k_ATTRIBUTE_TYPE_FK_ERROR	560	Referential Integrity error.
k_ATTRIBUTE_TYPE_PK_ERROR	559	Primary Key Violation.
k_BOM_IM_FK1_ERROR	851	Referential Integrity error.
k_BOM_IM_FK2_ERROR	852	Referential Integrity error.
k_BOM_PK_ERROR	850	Primary Key Violation.
k_COMB_CODE_DEL_ERROR	10526	Unanticipated error while deleting Combinability Code.
k_COMB_CODE_INFO_MISSING	10523	Code type or Code is missing in the seed data.
k_COMB_CODE_INS_ERROR	10524	Unanticipated error while inserting Combinability Code.
k_COMB_CODE_UPD_ERROR	10525	Unanticipated error while updating Combinability Code.
k_COMP_TICK_STOCKO_ERROR	10507	Referential Integrity error.
k_CONT_CT_FK_ERROR	754	Referential Integrity error.
k_CONT_FOUND_ERROR	760	Cannot create record, record already exists.
k_CONT_ITEM_CONT_FK_ERROR	757	Referential Integrity error.
k_CONT_ITEM_FOUND_ERROR	762	Cannot create record, record already exists.
k_CONT_ITEM_IM_FK_ERROR	758	Referential Integrity error.
k_CONT_ITEM_MISSING_ERROR	761	Cannot delete or modify the record because it does not exist.
k_CONT_ITEM_PK_ERROR	756	Primary Key Violation.
k_CONT_LOC_FK1_ERROR	752	Referential Integrity error.
k_CONT_LOC_FK2_ERROR	753	Referential Integrity error.
k_CONT_LOC_FK3_ERROR	755	Referential Integrity error.
k_CONT_MISSING_ERROR	759	Cannot delete or modify the record because it does not exist.
k_CONT_PK_ERROR	750	Primary Key Violation.
k_CONT_SD_FK_ERROR	751	Referential Integrity error.
k_CONTAINER_NOT_FOUND_ERROR	10504	Cannot create record, record already exists.
k_COUNTRY_NOT_FOUND_ERROR	10502	Cannot create record, record already exists.
k_CURRENCY_NOT_FOUND_ERROR	10503	Cannot create record, record already exists.
k_DIFF_DELETE_DIFF_GROUP_ERROR	304	An error occurred deleting from the Diff Group Detail table.
k_DIFF_GROUP_DET_DG_FK_ERROR	353	Referential Integrity error.
k_DIFF_GROUP_DET_DI_FK_ERROR	354	Referential Integrity error.
k_DIFF_GROUP_DET_PRI_KEY_ERROR	352	Primary Key Violation.
k_DIFF_GROUP_INSERT_ERROR	301	A Diff Group already exists.
k_DIFF_GROUP_OTHER_ERROR	303	An error occurred evaluating the Diff Group ID.
k_DIFF_GROUP_PRIMARY_KEY_ERROR	302	Primary Key Violation.
k_DIFF_GRP_DET_FOUND_ERROR	351	Cannot create record, record already exists.
k_DIFF_GRP_DET_MISSING_ERROR	350	Cannot delete or modify the record because it does not exist.
k_DIFF_GRP_ID_FOUND_ERROR	306	Cannot create record, record already exists.
k_DIFF_GRP_ID_MISSING_ERROR	300	Cannot delete or modify the record because it does not exist.
k_DIFF_ID_FOUND_ERROR	254	Cannot create record, record already exists.
k_DIFF_ID_MISSING_ERROR	250	Cannot delete or modify the record because it does not exist.
k_DIFF_INSERT_ERROR	251	Diff ID is already being used as a Diff Group ID.
k_DIFF_OTHER_ERROR	253	Unanticipated Differentiator error.
k_DIFF_PRIMARY_KEY_ERROR	252	Primary Key Violation.
k_DISTRO_IS_REF1_ERROR	10511	Referential Integrity error.
k_GENERAL_API_FAILURE	E	A fatal error occurred in the procedure.
k_GENERAL_FACILITY_NOT_FOUND	105	Facility does not exist in the transshipment_setup table.
k_GENERAL_INVALID_FACILITY	102	Facility does not exist in the transshipment_setup table.
k_GENERAL_INVALID_ROUTING	103	An invalid destination was passed.
k_GENERAL_PRE_ADDL_PROCESSING	104	An error occurred in pre-additional processing.
k_GENERAL_SUCCESS	S	A message was consumed.
k_INBOUND_DEST_XML_OTHER_ERROR	906	Unanticipated
k_INBOUND_WO_FOUND_ERROR	904	Cannot create record, record already exists.
k_INBOUND_WO_MISSING_ERROR	905	Cannot delete or modify the record because it does not exist.
k_INBOUND_WO_PK_ERROR	900	Primary Key Violation.
k_INBOUND_WO_PO_FK_ERROR	901	Referential Integrity error.
k_INBOUND_WO_SD_FK_ERROR	902	Referential Integrity error.
k_INBOUND_WO_WIP_FK_ERROR	903	Referential Integrity error.
k_ISC_IS_FK_ERROR	420	Referential Integrity error.
k_ISC_PK_ERROR	419	Primary Key Violation.
k_ISCD_ISC_FK_ERROR	422	Referential Integrity error.
k_ISCD_PK_ERROR	421	Primary Key Violation.
k_ITEM_ATTR_DEFAULTS_ERROR	452	Error when creating item and processing the attributes.
k_ITEM_BOM_FOUND_ERROR	449	Cannot create record, record already exists.
k_ITEM_BOM_MISSING_ERROR	448	Cannot delete or modify the record because it does not exist.
k_ITEM_CLASS_ERROR	457	Error applying Item Download class.
k_ITEM_COUNTRY_IND_UPD_ERROR	402	Error updating item_supp_country primary country indicator.
k_ITEM_CREATE_OTHER_ERROR	432	Unanticipated error while creating an item.
k_ITEM_DIFF_FOUND_ERROR	451	Cannot create record, record already exists.
k_ITEM_DIFF_PK_ERROR	415	Primary Key Violation.
k_ITEM_FOUND_ERROR	437	Error when item is created. Item already exists.
k_ITEM_INVALID_ERROR	10519	Item does not exist in PO_Detail table.
k_ITEM_LOC_INFO_MISSING	10520	Message arrived with no value for Item_Id
k_ITEM_LOC_NOT_FOUND	10521	Dest_Id is is not a valid DC Dest Id.
k_ITEM_MISSING_ERROR	436	Cannot delete or modify the record because it does not exist.
k_ITEM_MOD_MSG_OTHER_ERROR	435	Unanticipated error when modifying an item, item differentiator.
k_ITEM_NULL_ERROR	10517	Item ID published by host system is null.
k_ITEM_OVERWRITE_STATUS_ERROR	403	Error when checking if a column can be overwritten.
k_ITEM_SCD_OTHER_ERROR	431	Error while updating the dimensions of an item.
k_ITEM_SUPP_CTR_DIM_FND_ERROR	443	Cannot create record, record already exists.
k_ITEM_SUPP_CTR_DIM_MISS_ERROR	442	Cannot delete or modify the record because it does not exist.
k_ITEM_SUPP_CTR_FOUND_ERROR	441	Cannot create record, record already exists.
k_ITEM_SUPP_CTR_MISSING_ERROR	440	Cannot delete or modify the record because it does not exist.
k_ITEM_SUPP_IM_FK_ERROR	417	Referential Integrity error.
k_ITEM_SUPP_IND_UPDATE_ERROR	401	An error occurred updating the item_supplier or item_master tables.
k_ITEM_SUPP_ITEM_CRE_OTH_ERROR	434	Unanticipated error while modifying the item.
k_ITEM_SUPP_MOD_OTHER_ERROR	433	Unanticipated error while modifying an item.
k_ITEM_SUPP_PK_ERROR	416	Primary Key Violation.
k_ITEM_SUPP_VDR_FK_ERROR	418	Referential Integrity error.
k_ITEM_SUPPLIER_FOUND_ERROR	439	Cannot create record, record already exists.
k_ITEM_SUPPLIER_MISSING_ERROR	438	Cannot delete or modify the record because it does not exist.
k_ITEM_UDA_FOUND_ERROR	447	Cannot create record, record already exists.
k_ITEM_UDA_MISSING_ERROR	446	Cannot delete or modify the record because it does not exist.
k_ITEM_UPC_FOUND_ERROR	445	Cannot create record, record already exists.
k_ITEM_UPC_IND_UPDATE_ERROR	400	An error occurred in updating the primary UPC indicator in item_upc.
k_ITEM_UPC_MISSING_ERROR	444	Cannot delete or modify the record because it does not exist.
k_ITEM_UPDATE_COLUMNS_ERROR	10505	Cannot create record, record already exists.
k_ITEM_VENDOR_REF_ERROR	405	Foreign key error for vendor when creating an item.
k_ITEMA_ATTR_FK_ERROR	424	Referential Integrity error.
k_ITEMA_IM_FK_ERROR	425	Referential Integrity error.
k_ITEMA_PK_ERROR	423	Primary Key Violation.
k_ITEMBOM_CHECKING_ERROR	454	Error occurred checks to see if the MasterItemID is the same as the ComponentItemID.
k_ITEMBOM_COMP_MSTR_SAME_ERROR	453	MasterItemID is the same as the ComponentItemID.
k_ITEMCP_CURR_FK_ERROR	430	Referential Integrity error.
k_ITEMCP_IM_FK_ERROR	429	Referential Integrity error.
k_ITEMM_CT_FK_ERROR	409	Referential Integrity error.
k_ITEMM_PK_ERROR	406	Primary Key Violation.
k_ITEMM_UOM_FK_ERROR	407	Referential Integrity error.
k_ITEMM_UPS_FK_ERROR	410	Referential Integrity error.
k_ITEMM_VDR_FK_ERROR	408	Referential Integrity error.
k_ITEMM_WC_FK_ERROR	411	Referential Integrity error.
k_ITEMUPC_IM_FK_ERROR	413	Referential Integrity error.
k_ITEMUPC_PK_ERROR	412	Primary Key Violation.
k_ITEMUPC_UNIQUE_ERROR	414	Unique error on item_upc UPC number when modifying a record.
k_KIT_BUILD_REF3_ERROR	10508	Referential Integrity error.
k_OBWO_STOCK_ALLOC_FK_ERROR	1002	Referential Integrity error.
k_OBWO_WIP_FK_ERROR	1003	Referential Integrity error.
k_OUTBOUND_DEST_XML_OTH_ERROR	1001	Unanticipated
k_OUTBOUND_WO_FOUND_ERROR	1005	Cannot create record, record already exists.
k_OUTBOUND_WO_MISSING_ERROR	1004	Cannot delete or modify the record because it does not exist.
k_PENDING_RET_DET_PK_ERROR	952	Primary Key Violation.
k_PENDING_RETURN_FOUND_ERROR	954	Cannot create record, record already exists.
k_PENDING_RETURN_MISSING_ERROR	955	Cannot delete or modify the record because it does not exist.
k_PENDING_RETURN_PK_ERROR	950	Primary Key Violation.
k_PENDRET_DEST_XML_OTHER_ERROR	958	Unanticipated
k_PENDRET_DET_FK_PR_ERROR	953	Referential Integrity error.
k_PENDRET_ITEM_FK_ERROR	959	Referential Integrity error.
k_PICK_DIR_SO_FK_ERROR	10506	Referential Integrity error.
k_PICKFROMLOC_ITEMM_FK_ERROR	426	Referential Integrity error.
k_PICKFROMLOC_LOC_FK_ERROR	427	Referential Integrity error.
k_PO_CNTRY_VENDOR_ITEM_ERROR	517	PO record exists, cannot delete Vendor.
k_PO_CRE_MOD_OTHER_ERROR	509	Unanticipated error while creating a PO.
k_PO_DELIVER_DATE_ERROR	516	Error on the deliver date while creating a PO.
k_PO_DETAIL_FOUND_ERROR	514	Cannot create record, record already exists.
k_PO_DETAIL_ITEM_ERROR	507	Error on the foreign key reference to item from PO details when creating a PO detail.
k_PO_DETAIL_MISSING_ERROR	515	Cannot delete or modify the record because it does not exist.
k_PO_DETAIL_PK_ERROR	505	Primary Key Violation.
k_PO_DETAIL_PO_ERROR	506	Error on the foreign key reference to PO from PO details when creating a PO detail.
k_PO_FOUND_ERROR	512	Cannot create record, record already exists.
k_PO_INVALID_ERROR	10518	PO does not exist in PO table.
k_PO_MISSING_ERROR	513	Cannot delete or modify the record because it does not exist.
k_PO_NULL_ERROR	10516	PO Number published by host system is null.
k_PO_OTHER_ERROR	521	Error validating PO detail required fields.
k_PO_PK_ERROR	504	Primary Key Violation.
k_PO_RECEIPT_FK_ERROR	508	Referential Integrity error.
k_PO_STATUS_CANNOT_CLOSE_ERROR	524	Error trying to Close a PO where an unreceived appointment exists.
k_PO_STATUS_CHECKING_ERROR	525	Error checking appointment information.
k_PO_VENDOR_REF_ERROR	503	Error on the vendor foreign key reference when creating a record.
k_POD_REQUESTED_QTY_ERROR	523	Error validating requested quantity.
k_RETURNABLE_FLAG_UPD_ERROR	10522	No records were found for the Dest_Id, Item_Id combination.
k_SA_IN_DISTRIBUTION_ERROR	829	Stock Allocation is in distribution.
k_SA_NOT_FOUND_DELETE_ERROR	832	Cannot create the Stock Order Info Upload record, Stock Allocation record does not exist.
k_SA_NOT_FOUND_DELETE_ERROR	832	Cannot create record, record already exists.
k_SCHDULE_NBR_NULL	10515	Schedule Number is null.
k_SHIP_DEST_FOUND_ERROR	653	Cannot create record, record already exists.
k_SHIP_DEST_MISSING_ERROR	654	Cannot delete or modify the record because it does not exist.
k_SHIP_DEST_REF_CONT_TYP_ERROR	655	Referential Integrity error.
k_SHIP_DEST_REF_CUR_CODE_ERROR	661	Referential Integrity error.
k_SHIP_DEST_REF_DEF_CSR_ERROR	659	Referential Integrity error.
k_SHIP_DEST_REF_EXP_CSR_ERROR	660	Referential Integrity error.
k_SHIP_DEST_REF_PRIM_KEY_ERROR	658	Primary Key Violation.
k_SHIP_DEST_REF_ST_RDM_ERROR	657	Referential Integrity error.
k_SHIP_DEST_REF_UNIT_PCK_ERROR	656	Referential Integrity error.
k_SHIP_DEST_ROUTE_ERROR	662	Referential Integrity error.
k_SHIP_DEST_SEQ_NBR_ERROR	668	Error validating sequence number.
k_SHIP_DEST_TYPE_NOT_VAL_ERROR	651	An error occurred checking the ship destination type.
k_SHIP_INVALID_DEF_CSR_ERROR	663	Default_Service_Code, Default_Carrier_Code and/or Default_Route values are NULL.
k_SHIP_INVALID_EXP_CSR_ERROR	664	Expedite_Service_Code, Expedite_Carrier_Code and/or Expedite_Route values are NULL.
k_SHIP_MLD_FK_ERROR	665	Referential Integrity error.
k_SHIP_OVERWRITE_STATUS_ERROR	650	Error retrieving ship destination overwrite status information.
k_SHIP_OWNING_DC_ERROR	652	Owning DC not found.
k_SKU_ADD_OTHER_ERROR	1100	Unanticipated
k_SKU_FOUND_ERROR	1102	Task_Queue record already exists.
k_SKU_MISSING_ERROR	1101	Cannot delete or modify the record because it does not exist.
k_SO_IN_DISTRIBUTION_ERROR	830	Stock Order has an Allocation in distribution.
k_SO_INV_CD_DEST_TYPE	833	Invalid dest type when consumer_direct flag is N and DEST_TYPE is Virtual.
k_SORTED_ALLOC_REF1_ERROR	10510	Referential Integrity error.
k_ST_ALLOC_CRE_MOD_OTHER_ERROR	822	Unanticipated error while creating a stock order.
k_ST_ALLOC_INSTORE_DATE_ERROR	823	In store date error while creating a stock order.
k_ST_ALLOC_MODIFY_OTHER_ERROR	824	Unanticipated error while modifying a stock allocation.
k_STATE_NOT_FOUND_ERROR	10501	Cannot create record, record already exists.
k_STOCK_ALLOC_CRE_OTHER_ERROR	821	Unanticipated error in the standard UOM when creating a stock order.
k_STOCK_ALLOC_FOUND_ERROR	817	Cannot create record, record already exists.
k_STOCK_ALLOC_MISSING_ERROR	816	Cannot delete or modify the record because it does not exist.
k_STOCK_CARTONIZATION_ERROR	826	Error in cartonization during the call to perform cartonization when a stock order is created.
k_STOCK_DELETE_OTHER_ERROR	825	Unanticipated error while generating a SD stock order info status message when a stock allocation is deleted.
k_STOCK_DISTRIBUTION_ERROR	819	Invalid stock distribution error while modifying a stock order.
k_STOCK_INV_CARR_SERV_ERROR	811	Invalid carrier service when creating a stock order.
k_STOCK_INV_CARRIER_ERROR	812	Invalid carrier when creating a stock order.
k_STOCK_INV_CSR_ERROR	813	Invalid carrier service route when creating a stock order.
k_STOCK_MOD_CRE_OTHER_ERROR	806	Unanticipated error while modifying a stock order.
k_STOCK_MODIFY_OTHER_ERROR	818	Unanticipated error while modifying a stock order.
k_STOCK_NULL_SHIP_FIELD_ERROR	804	Error in ship field(s) when creating a stock order. One of the field(s) is null.
k_STOCK_ORDER_CRE_OTHER_ERROR	807	Unanticipated error while creating a stock order.
k_STOCK_ORDER_FOUND_ERROR	815	Cannot create record, record already exists.
k_STOCK_ORDER_MISSING_ERROR	814	Cannot delete or modify the record because it does not exist.
k_STOCK_PICK_DATE_ERROR	805	Error in the pick date when creating a stock order.
k_STOCK_REQUIRED_PO_ERROR	831	Missing PO number.
k_STOCK_UNCARTONIZE_ERROR	820	Error during the uncartonize process when stock orders are modified. The error occurs during the call to the perform cartonization package.
k_STOCKA_CID_REF1	10512	Referential Integrity error.
k_STOCKA_ITEMM_FK_ERROR	428	Referential Integrity error.
k_STOCKA_SHIPD_FK_ERROR	810	Referential Integrity error.
k_STOCKA_STOCKO_FK_ERROR	809	Referential Integrity error.
k_STOCKA_UP_REF1_ERROR	808	Referential Integrity error.
k_STOCKO_PK_ERROR	800	Primary Key Violation.
k_STOCKO_PO_FK_ERROR	803	Referential Integrity error.
k_STOCKO_STATE_FK1_ERROR	801	Referential Integrity error.
k_STOCKO_STATE_FK2_ERROR	802	Referential Integrity error.
k_TASK_QUEUE_ACT_CODE_FK_ERROR	1103	Referential Integrity error.
k_TASK_QUEUE_ITEM_FK_ERROR	1105	Referential Integrity error.
k_TASK_QUEUE_WAVE_FK_ERROR	1104	Referential Integrity error.
k_VENDOR_ADDR_FOUND_ERROR	211	Cannot create record, record already exists.
k_VENDOR_ADDR_IND_UPDATE_ERROR	204	An error occurred updating the primary address indicator.
k_VENDOR_ADDR_MISSING_ERROR	210	Cannot delete or modify the record because it does not exist.
k_VENDOR_ADDR_PRIM_KEY_ERROR	206	Primary Key Violation.
k_VENDOR_ADDR_TYPE_UPD_ERROR	208	Unable to update the Vendor Address description.
k_VENDOR_DELETE_ERROR	200	Error while deleting a vendor.
k_VENDOR_FK_ERROR	207	Referential Integrity error.
k_VENDOR_FOUND_ERROR	203	Cannot create record, record already exists.
k_VENDOR_MISSING_ERROR	202	Cannot delete or modify the record because it does not exist.
k_VENDOR_OVERWRIT_STATUS_ERROR	201	Errors while retrieving overwrite status values.
k_VENDOR_PRIMARY_KEY_ERROR	205	Primary Key Violation.
k_VENDOR_STATE_FK_ERROR	209	Referential Integrity error.
k_VERIFY_ASN_ITEM_OTHER_ERROR	722	Unanticipated error occurred verifying ASN item record.
k_VERIFY_ASN_OTHER_ERROR	723	Unanticipated error occurred verifying the ASN record.
k_VERIFY_ASN_PO_DATE_ERROR	720	Error, the deliver not after date is invalid.
k_VERIFY_ASN_PO_OTHER_ERROR	721	Error occurred verifying ASN Purchase Order.
k_VERIFY_CNTR_ITEM_OTHER_ERROR	725	Unanticipated error occurred verifying the container item record.
k_VERIFY_CONTAINER_OTHER_ERROR	724	Unanticipated error occurred verifying the container record.