index

Package ab_adv_individual_str

This package contains the error messages and error message functions for the Advancement Individual API (ab_adv_individual).

Message KeyError Message
AARMEMB_EXISTSCannot delete, membership information exists
Must delete membership record (AARMEMB) before deleting Advancement individual record.
AFRCSLT_EXISTSCannot delete, member of a solicitor organization
Must delete solicitor organization (AFRCLST) before deleting Advancement individual record.
AFRCTYP_EXISTSCannot delete, they have been assigned as a solicitor
Must delete solicitor record (AFRCTYP) before deleting Advancement individual record.
AFRCTYP2_EXISTSCannot delete, they have been assigned to a solicitor
Must delete solicitor record (AFRCTYP) before deleting Advancement individual record.
AMREXRT_EXISTSCannot delete, external ratings exist
Must delete external ratings (AMREXTR) before deleting Advancement individual record.
AMRINFO_EXISTSCannot delete, prospect information exists
Must delete prospect information (AMRINFO) before deleting Advancement individual record.
APRACTY_EXISTSCannot delete, activity information exists
Must delete activity information (APRACTY) before deleting Advancement individual record.
APRADEG_EXISTSCannot delete, academic history exists
Must delete academic history information (APRADEG) before deleting Advancement individual record.
APRCHIS_EXISTSCannot delete, giving history record exists
Must delete giving history information (APRCHIS) before deleting Advancement individual record.
APRCHLD_EXISTSCannot delete, child data exists
Must delete child information (APRCHLD) before deleting Advancement individual record.
APRCONF_EXISTSCannot delete, comments exist
Must delete comment information (APRCONF) before deleting Advancement individual record.
APRCSPS_EXISTSCannot delete, spouse information exists
Must delete spouse information (APRCSPS) before deleting Advancement individual record.
APREHIS_EXISTSCannot delete, employment history data exists
Must delete employment history information (APREHIS) before deleting Advancement individual record.
APREXCL_EXISTSCannot delete, exclusions exist
Must delete exclusion information (APREXCL) before deleting Advancement individual record.
APRMAIL_EXISTSCannot delete, mail codes exist
Must delete mail code information (APRMAIL) before deleting Advancement individual record.
APRPMEM_EXISTSCannot delete, pledge soft credit information exists
Must delete pledge soft credit information (APRPMEM) before deleting Advancement individual record.
APRPROS_EXISTSCannot delete, special purpose information exists
Must delete special purpose information (APRPROS) before deleting Advancement individual record.
APRSALU_EXISTSCannot delete, salutations exist
Must delete salutation information (APRSALU) before deleting Advancement individual record.
APRVIPC_EXISTSCannot delete, variable purpose information exists
Must delete variable purpose information (APRVIPC) before deleting Advancement individual record.
APRXREF_EXISTSCannot delete, cross references exist
Must delete cross-reference information (APRXREF) before deleting Advancement individual record.
ASRSORG_EXISTSCannot delete, member of a solicitor organization.
Must delete solicitor organization information (ASRSORG) before deleting Advancement individual record.
INVALID_ATYP_CODE_CMInvalid value for Combined Address Type
Combined address type must be valid in the Constituent Information table (APBCONS).
NO_ADDR_ATYP_CODE_CMNo active address for Combined Address Type
Combined address type must exist in the Address table (SPRADDR).
INVALID_ATYP_CODE_GEORInvalid value for Region Address
Region address code must be valid in the Constituent Information table (APBCONS).
NO_ADDR_ATYP_CODE_GEORNo active address for Region Address
Region address code must exist in the Address table (SPRADDR).
INVALID_ATYP_CODE_PREFInvalid value for Preferred Address Code
Preferred address code must be valid in the Constituent Information table (APBCONS).
NO_ADDR_ATYP_CODE_PREFNo active address for Preferred Address Code
Preferred address code must exist in the Address table (SPRADDR).
MISSING_ADDR_ATYP_CODE_PREFMissing mandatory value for Preferred Address Code
Enter a valid Preferred Address Code.
INVALID_COLL_CODE_PREFInvalid value for Preferred College Code
Preferred college code must be valid in the Constituent Information table (APBCONS).
INVALID_DOTT_CODEInvalid value for Occupation Title
Occupation title must be valid in the Constituent Information table (APBCONS).
INVALID_INCM_CODEInvalid value for Income Level
Income level must be valid in the Constituent Information table (APBCONS).
INVALID_NATN_CODE_HOMEInvalid value for Nation of Origin
Nation of origin code must be valid in the Constituent Information table (APBCONS).
INVALID_PIDMInvalid or missing pidm
PIDM must be valid in the Constituent Information table (APBCONS).
INVALID_PREF_CLASInvalid value for Preferred Class Year
Preferred class year must be valid in the Constituent Information table (APBCONS).
INVALID_STAT_CODE_HOMEInvalid value for State/Province of Origin
State/province of origin must be valid in the Constituent Information table (APBCONS).
MISSING_PIDMMissing mandatory value for APBCONS_PIDM
Enter a valid PIDM (SPRIDEN) for the individual.
MISSING_PREF_CLASMissing mandatory value for Preferred Class Year
Enter a preferred class year for the individual.
PK_NOT_FOUNDCannot find record using primary or unique key
PIDM does not exist as an individual.
P_DELETE_FAILEDCannot delete, record does not exist
PIDM does not exist as an individual.
RECORD_EXISTSCannot create, record already exists
PIDM already exists as an individual.


Program units
f_get_error   Returns error 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 message corresponding to p_errorname

Parameters
p_errorname   Name associated with error message.