COMMODITY_EXISTS

COMMODITY_EXISTS         CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0000','SQL','P_CREATE failed. Commodity Code  exists.');

Fail to insert commodity record due to existing record

CODE_REQUIRED

CODE_REQUIRED            CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0001','SQL','Commodity code is required.');

Commodity code required

DESC_REQUIRED

DESC_REQUIRED            CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0002','SQL','Commodity Description is required.');

Commodity description required

UOMS_REQUIRED

UOMS_REQUIRED            CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0003','SQL','Commodity Unit of measure is required.');

Unit of measure required

CREATE_FAILED

CREATE_FAILED            CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0004','SQL','P_CREATE failed.');

Fail to create commodity record

UPDATE_FAILED

UPDATE_FAILED            CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0005','SQL','P_UPDATE failed.');

Fail to update commodity record

DELETE_FAILED

DELETE_FAILED            CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0006','SQL','P_DELETE failed.');

Fail to delete commodity record

EXISTS_FAILED

EXISTS_FAILED            CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0007','SQL','F_EXISTS failed.');

Fail to run f_exists function

LOCK_FAILED

LOCK_FAILED              CONSTANT VARCHAR2(80) :=
  g$_nls.get('FOKB_COMM_S0-0008','SQL','F_LOCK failed.');

Fail to lock record

INVALID_COMM_CODE

INVALID_COMM_CODE        CONSTANT VARCHAR2(80) :=
  g$_nls.get('x','SQL','Invalid Commodity Code.');

Invalid commodity code

INACTIVE_COMM_CODE

INACTIVE_COMM_CODE       CONSTANT VARCHAR2(80) :=
  g$_nls.get('x','SQL','Inactive or terminated Commodity Code.');

Inactive commodity code