index

Package gb_identification_strings

Error messages and error message functions for the IDENTIFICATION STRINGS API (gb_identification).
 

Message Key Error Message
CHANGE_IND_REQUIREDChange indicator is required when PIDM is provided.
When creating the initial record for a person, a PIDM is always generated. If a PIDM is passed in, the assumption is that it is an audit record, and therefore Change Indicator is required.
COMPANY_FIRSTNAMEFirst name not allowed when the entity is a Company.
First name must be passed in as null when p_entity = 'C'.
DELETE_ID_NOT_FOUNDID not found.
A delete is being attempted, but the record cannot be located in the database. The key values or the ROWID must match a record in the database.
ENTITY_IND_REQUIREDEntity Indicator is required.
P_entity_ind must be supplied for all p_create operations.
FIRST_NAME_REQUIREDFirst Name is required for a Person Entity.
If p_entity_ind = 'P', first name cannot be null.
ID_AND_NAME_CHANGEID and Name cannot be changed at the same time.
p_update checked the current record against the data being passed in, and both an ID and a name change are being attempted at the same time. These operations must be done in two separate calls.
ID_EXISTSCannot create or update ID. ID already exists.
p_create or p_update were passed an ID that already exists in the database.
ID_OR_NAME_CHANGE_EXISTSID or Name change record already exists.
During p_create of a name change or id change audit record, the program detected that the name or ID already exists in the database.
RECORD_NOT_FOUNDCould not find identification record via PIDM or ROWID.
The record to be updated is located using the PIDM where spriden_change_ind is null, or where the ROWID passed matches a row in the database. No record was found, so supply a PIDM with spriden_change_ind NULL, or a valid ROWID.
ID_REQUIREDID is required.
p_id can never be passed as NULL. Either a valid ID or the word 'GENERATED' is required.
INVALID_CHANGE_INDInvalid Change Indicator.
Change Indicator must be NULL, I or N.
INVALID_ENTITY_INDInvalid Entity Indicator.
Entity indicator must be 'C' or 'P'.
INVALID_GENERATE_IDID can only be GENERATED when Change indicator is null.
When creating a record, ID = 'GENERATED' is only valid when the Change indicator is null. Either supply an ID, or pass in a Change indicator to make an audit record.
INVALID_ID_CHANGECannot insert a different name and ID at the same time.
An insert of an audit record for an ID change is being attempted, but the name is also being changed. Name changes and ID changes must be done in separate calls. Make sure the name matches the name of the current record for this PIDM.
INVALID_ID_DELETECannot delete the current record.
A delete is being attempted with a Change indicator of NULL. You must specify a Change indicator to select an audit record to delete. No deletion of the current record is allowed.
INVALID_NAME_TYPE_CODEInvalid Name Type.
The name type must exist in the gtvntyp validation table.
INVALID_PIDMPIDM must be a positive integer.
A negative PIDM was passed to p_create or p_update.
INVALID_UPDATEMust update at least the ID, Name, or Name Type.
An update was attempted, but the API could not tell that an ID, Name or Name Type change was passed.  No other fields can be updated unless one of these is changed as well.
LAST_NAME_REQUIREDLast Name is required.
Last Name is required.
NAME_CHANGE_ON_IDCannot update ID when the Change indicator = N.
Once an audit record is created with Change indicator of I, updates of the Name on that record are not allowed.
NAME_TYPE_CHANGE_ONLYThe only change to history records allowed is Name Type.
To preserve the audit trail of name and ID changes, only Name Type may be altered on a history record.
PIDM_ID_MISMATCHID is not for the PIDM given.
An attempt was made to create a name change audit record, but the ID passed is not for the PIDM passed. Make sure the ID and PIDM are for the same person.
PIDM_REQUIREDPIDM is required if Change indicator is provided.
A PIDM must be supplied to create an audit record.
ENTITY_CHANGE_ON_INSERTCannot insert record, a record exists with a different Entity Indicator.
Specify the same Entity Indicator of the existing records.
ENTITY_CHANGE_ON_UPDATECannot update, the Entity Indicator cannot be changed.
Specify the same Entity Indicator of the existing records.
IDEXISTS_IDCHANGECannot create ID change record, ID is used by a different PIDM.
Specify an ID that has not been used by another PIDM.
IDEXISTS_NEWCannot create new person record, ID given is in use by another PIDM.
Specify an ID that has not been used by another PIDM.
IDEXISTS_UPDATE_IDCannot update ID, the new ID is in use by another PIDM.
Specify an ID that has not been used by another PIDM.
ID_CHANGE_EXISTSCannot create record with this ID, there is already an ID change record for this pidm using this ID.
Specify a different ID.
NAME_CHANGE_EXISTSCannot create name change, there is already a record with this ID,Pidm, Name and Name Type.
Provide a different name.


Program units
f_get_error   Returns error the message corresponding to p_errorname

Variables
error_tab   Global error table that holds the error message.


error_tab

error_tab gb_common.errmsg_tab_type;

Global error table that holds the error message.


f_get_error

FUNCTION f_get_error(p_errorname VARCHAR2) RETURN VARCHAR2

Returns error the message corresponding to p_errorname

Parameters
p_errorname   Name associated with the error message.