index

Package px_record_of_employment_str

This package contains the error messages and error message functions for the Canadian Record of Employment API (PX_RECORD_OF_EMPLOYMENT).

Message NameError Message
CONTACT_PIDM_DECEASEDEmployee Identification Number to be Contacted for Record of Employment is deceased.
Employee Identification Number to be Contacted for Record of Employment is deceased.
INVALID_BENEFIT_DAY_WEEK_INDInvalid Benefit Payment Period Indicator for Record of Employment; valid values: D and W.
Valid values for Benefit Payment Period Indicator are D and W.
INVALID_BENEFIT_INDInvalid Employee Receiving Benefit Indicator for Record of Employment; Valid values: N and Y.
Valid values for Receiving Benefit Indicator are N and Y.
INVALID_BENIFIT_DAY_WEEK_INDBenefit Payment Period Indicator for Record of Employment cannot be entered if the employee does not have Benefit Indicator.
Benefit Payment Period Indicator for Record of Employment cannot be entered if the employee does not have Benefit Indicator.
INVALID_BENIFIT_GRSBenefit Amount for Record of Employment cannot be entered if the employee does not have Benefit Indicator.
Benefit Amount for Record of Employment cannot be entered if the employee does not have Benefit Indicator.
INVALID_BENIFIT_START_DTBenefit Start Date for Record of Employment cannot be entered if the employee does not have Benefit Indicator.
Benefit Start Date for Record of Employment cannot be entered if the employee does not have Benefit Indicator.
INVALID_CONTACT_PIDMInvalid Contact PIDM for Record of Employment.
Contact PIDM for Record of Employment is invalid.
INVALID_DAY_WORKEDEmployee Last Work Sate should be greater than Employee First Work Date.
Employee Last Work Sate should be greater than Employee First Work Date.
INVALID_EARN_CODE_VACInvalid Code for Vacation Pay Earnings Code.
Vacation Pay Earnings Code must exist in PTREARN.
INVALID_EMPCODEInvalid Employer Code for the employee.
Employer Code must exist in PHRDEDN.
INVALID_EMPR_CODEInvalid Employer Code for Record of Employment.
Employer Code must exist in PTREMPR.
INVALID_FED_EINInvalid Revenue Canadian Business Number for Record of Employment.
Revenue Canadian Business Number must exist in PTREMPR.
INVALID_FINAL_PAY_DATEInvalid Final Pay Date for Record of Employment.
Finaly Pay date for Record of Employment does not fall in the valid range.
INVALID_INSURABLE_ERANInvalid Total Insurable Hours for the Record of Employment.
Total Insurable Hours does not fall in the valid range.
INVALID_ISSUING_PIDMInvalid Issuing PIDM for Record of Employment.
Issuing Employee Identification Number is invalid.
INVALID_JOBEmployee must have a Job assigned to Pay Id selected.
Employee does not have a valid job assigned against the Payroll ID.
INVALID_LANGUAGE_INDInvalid Preferred Language Indicator for Record of Employment; Valid values: E and F.
Valid values for Language Indicator are E and F.
INVALID_MONEY_TYPE1Invalid Canadian ROE Types of Other Money 1 for Record of Employment; Valid values: A, B,E, G, H, I, N, O, R, S, U and Y.
Valid values for Canadian ROE Types of Other Money 1 are A, B,E, G, H, I, N, O, R, S, U and Y.
INVALID_MONEY_TYPE2Invalid Canadian ROE Types of Other Money 2 for Record of Employment; Valid values: A, B,E, G, H, I, N, O, R, S, U and Y.
Valid values for Canadian ROE Types of Other Money 2 are A, B,E, G, H, I, N, O, R, S, U and Y.
INVALID_MONEY_TYPE3Invalid Canadian ROE Types of Other Money 3 for Record of Employment; Valid values: A, B,E, G, H, I, N, O, R, S, U and Y.
Valid values for Canadian ROE Types of Other Money 2 are A, B,E, G, H, I, N, O, R, S, U and Y.
INVALID_OTHER_EARN_CODE1Invalid Code for Other Monies Earning Code 1.
Other Monies Earning Code 1 must exist in PTREARN.
INVALID_OTHER_EARN_CODE2Invalid Code for Other Monies Earning Code 2.
Other Monies Earning Code 2 must exist in PTREARN.
INVALID_OTHER_EARN_CODE3Invalid Code for Other Monies Earning Code 3.
Other Monies Earning Code must exist in PTREARN.
INVALID_PAY_PD_PICT_CODEThe Pay Period for the PICT code selected does not fall in the required Range of values.
The Pay Period for the PICT code selected does not fall in the required Range of values.
INVALID_PICT_CODEInvalid Payroll ID for Record of Employment.
Payroll ID must exist in PTRPICT.
INVALID_PIDMInvalid PIDM for Record of Employment.
Employee Identification Number for Record of Employment is invalid.
INVALID_PRINT_INDInvalid Ready to Print Indicator for Record of Employment; Valid values: N and Y.
Valid values for Ready to Pring Indicator are N and Y.
INVALID_PTRCALN_DATEInvalid Date on PTRCALN.
Final Pay Date must exist in PTRCALN.
INVALID_RECALL_DATECannot enter the Expected Date of the Employee Return to Active if the Record of Employment has the Employee Return to Active Employment Indicator other than Y
Cannot enter the Expected Date of the Employee Return to Active if the Record of Employment has the Employee Return to Active Employment Indicator other than Y.
INVALID_RECALL_INDInvalid Employee Return to Active Employment Indicator for Record of Employment; Valid values: N,S,U and Y.
Valid values for Return to Active Employment Indicator are N,S,U and Y.
INVALID_REPRINT_INDInvalid Reprint Amend Indicator for Record of Employment; Valid values: N and Y.
Valid values for Reprint Amend Indicator are N and Y.
INVALID_ROEC_CODEInvalid Reason for Issuing ROE for Record of Employment.
Reason for Issuing ROE must exist in PTVROER.
INVALID_ROE_PRINTINDRecord of Employment cannot be created or updated with a Print Indicator.
Cannot create or update a Record of Employment with Print Indicator.
INVALID_SINEmployee Social Insurance Number is invalid.
Social Insurance Number for the Employee is invalid.
INVALID_STAT_HOL_DATEStatutory Holiday Pay Dates must be different.
Statutory Holiday Pay Dates must not be the same.
INVALID_STAT_HOL_EARN_CODE1Invalid Code for Statutory Holiday Pay Earnings Code 1.
Statutory Holiday Pay Earnings Code 1 must exist in PTREARN.
INVALID_STAT_HOL_EARN_CODE2Invalid Code for Statutory Holiday Pay Earnings Code 2.
Statutory Holiday Pay Earnings Code 2 must exist in PTREARN.
INVALID_STAT_HOL_EARN_CODE3Invalid Code for Statutory Holiday Pay Earnings Code 3.
Statutory Holiday Pay Earnings Code 3 must exist in PTREARN.
INVALID_VAC_GRSVacation Pay Amount for Record of Employment cannot be entered if the employee does not have Vacation Pay Earnings Code.
Vacation Pay Amount for Record of Employment cannot be entered if the employee does not have Vacation Pay Earnings Code.
ISSUING_PIDM_DECEASEDIssuing Person Identification for Record of Employment is deceased.
Person Issuing Record of Employment is deceased.
MISING_OTR_ERN_COD1_GRSMissing mandatory Other Monies Earning Amount 1 for Record of Employment.
Other Monies Earning Amount 1 must be entered. This is a key value for the record in the table.
MISING_OTR_ERN_COD2_GRSMissing mandatory Other Monies Earning Amount 2 for Record of Employment.
Other Monies Earning Amount 2 must be entered. This is a key value for the record in the table.
MISING_OTR_ERN_COD3_GRSMissing mandatory Other Monies Earning Amount 3 for Record of Employment.
Other Monies Earning Amount 3 must be entered. This is a key value for the record in the table.
MISSING_BENEFIT_INDMissing mandatory Employee Benefit Indicator for Record of Employment.
Employee Benefit Indicator must be entered. This is a key value for the record in the table.
MISSING_CONTACT_PIDMMissing mandatory Employee Identification Number to be Contacted for Record of Employment.
Employee Identification Number to be Contacted must be entered. This is a key value for the record in the table.
MISSING_CONTACT_TELE_AREA_CODEMissing mandatory Employee Phone Number Area Code to be Contacted for Record of Employment.
Phone Number Area Code to be Contacted must be entered. This is a key value for the record in the table.
MISSING_CONTACT_TELE_NUMBERMissing mandatory Employee Phone Number to be Contacted for Record of Employment.
Employee Phone Number to be Contacted must be entered. This is a key value for the record in the table.
MISSING_EARN_CODE_VACMissing mandatory Vacation Pay Amount for Record of Employment.
Vacation Pay Amount must be entered. This is a key value for the record in the table.
MISSING_EMPR_CODEMissing mandatory Employer Code for Record of Employment.
Employer Code must be entered. This is a key value for the record in the table.
MISSING_EMPR_FED_EINMissing mandatory Revenue Canada Business Number for Record of Employment.
Revenue Canada Business Number must be entered. This is a key value for the record in the table.
MISSING_FINAL_PAY_DATEMissing mandatory Employee Final Pay Date for Record of Employment.
Employee Final Pay Date must be entered. This is a key value for the record in the table.
MISSING_FIRST_DAY_WORKEDMissing mandatory Employee First Worked Date for Record of Employment.
Employee First Worked Date must be entered. This is a key value for the record in the table.
MISSING_ISSUE_DATEMissing mandatory Issue Date for Record of Employment.
Issue Date must be entered. This is a key value for the record in the table.
MISSING_ISSUING_PIDMMissing mandatory Issuing Person Identification Number for Record of Employment.
Issuing Person Identification Number must be entered. This is a key value for the record in the table.
MISSING_ISSUING_TELE_AREA_CODEMissing mandatory Issuing Person Telephone Number Area Code for Record of Employment.
Issuing Telephone Number Area Code must be entered. This is a key value for the record in the table.
MISSING_ISSUING_TELE_NUMBERMissing mandatory Issuing Person Telephone Number for Record of Employment
Issuing Person Telephone Number must be entered. This is a key value for the recrd in the table.
MISSING_LANGUAGE_INDMissing mandatory Preferred Language of the Issuing Employer for Record of Employment.
Preferred Language of the Issuing Employer must be entered. This is a key value for the record in the table.
MISSING_LAST_DAY_WORKEDMissing mandatory Employee Last Day Worked for Record of Employment.
Employee Last Day Worked must be entered. This is a key value for the record in the table.
MISSING_MONEY_TYPE1Missing mandatory Canadian ROE Types of Other Money 1 for Record of Employment.
Canadian ROE Types of Other Money 1 must be entered. This is a key value for the record in the table.
MISSING_MONEY_TYPE2Missing mandatory Canadian ROE Types of Other Money 2 for Record of Employment.
Canadian ROE Types of Other Money 2 must be entered. This is a key value for the record in the table.
MISSING_MONEY_TYPE3Missing mandatory Canadian ROE Types of Other Money 3 for Record of Employment.
Canadian ROE Types of Other Money 3 must be entered. This is a key value for the record in the table.
MISSING_OTHER_EARN_CODE1Missing mandatory Other Monies Earning Code 1 for Record of Employment.
Other Monies Earning Code 1 must be entered. This is a key value for the record in the table.
MISSING_OTHER_EARN_CODE2Missing mandatory Other Monies Earning Code 2 for Record of Employment.
Other Monies Earning Code 2 must be entered. This is a key value for the record in the table.
MISSING_OTHER_EARN_CODE3Missing mandatory Other Monies Earning Code 3 for Record of Employment.
Other Monies Earning Code 3 must be entered. This is a key value for the record in the table.
MISSING_PICT_CODEMissing mandatory Payroll ID for Record of Employment.
Payroll ID must be entered. This is a key value for the record in the table.
MISSING_PIDMMissing mandatory Employee Identification Number for Record of Employment.
Employee Identification Number must be entered. This is a key value for the record in the table.
MISSING_PP1_GRSMissing mandatory Pay Period Amount Breakdown Number 1 for Record of Employment.
Pay Period Amount Breakdown Number 1 must be entered. This is akey value for the record in the table.
MISSING_PP1_PAYNOMissing mandatory Pay Period Breakdown Number 1 for Record of Employment.
Pay Period Breakdown Number 1 must be entered. This is akey value for the record in the table.
MISSING_PRINT_INDMissing mandatory Ready to Print Indicator for Record of Employment.
Ready to Print Indicator must be entered. This is a key value for the record in the table.
MISSING_RECALL_DATEMissing mandatory Employee Return Date for Record of Employment.
Employee Return Date must be entered. This is a key value for the record in the table.
MISSING_REPRINT_INDMissing mandatory Reprint Amend Indicator for Record of Employment.
Reprint Amend Indicator must be entered. This is a key value for the record in the table.
MISSING_ROEC_CODEMissing mandatory Reason for the Employer Issuing this ROE for Record of Employment.
Reason for Employer issuing this ROE must be entered. This is a key value for the record in the table.
MISSING_SEQ_NOMissing mandatory Record Sequence Number for Record of Employment.
Record Sequence Number must be entered. This is a key value for the record in the table.
MISSING_SINMissing mandatory Employee Social Insurance Number for Record of Employment.
Employee Social Insurance Number must be entered. This is a key value for the record in the table.
MISSING_STAT_EARN_CODE1Missing mandatory Statutory Holiday Earnings Code 1 for Record of Employment.
Statutory Holiday Earnings Code 1 must be entered. This is a key value for the record in the table.
MISSING_STAT_EARN_CODE2Missing mandatory Statutory Holiday Earnings Code 2 for Record of Employment.
Statutory Holiday Earnings Code 2 must be entered. This is a key value for the record in the table.
MISSING_STAT_EARN_CODE3Missing mandatory Statutory Holiday Earnings Code 3 for Record of Employment.
Statutory Holiday Earnings Code 3 must be entered. This is a key value for the record in the table.
MISSING_STAT_EARN_CODE4Missing mandatory Statutory Holiday Earnings Code 4 for Record of Employment.
Statutory Holiday Earnings Code 4 must be entered. This is a key value for the record in the table.
MISSING_STAT_EARN_CODE5Missing mandatory Statutory Holiday Earnings Code 5 for Record of Employment.
Statutory Holiday Earnings Code 5 must be entered. This is a key value for the record in the table.
MISSING_STAT_HOL_DATE1Missing mandatory Statutory Holiday Date 1 for Record of Employment.
Statutory Holiday Date 1 must be entered. this is a kye value for the record in the table.
MISSING_STAT_HOL_DATE2Missing mandatory Statutory Holiday Date 2 for Record of Employment.
Statutory Holiday Date 2 must be entered. this is a kye value for the record in the table.
MISSING_STAT_HOL_DATE3Missing mandatory Statutory Holiday Date 3 for Record of Employment.
Statutory Holiday Date 3 must be entered. this is a kye value for the record in the table.
MISSING_STAT_HOL_DATE4Missing mandatory Statutory Holiday Date 4 for Record of Employment.
Statutory Holiday Date 4 must be entered. this is a kye value for the record in the table.
MISSING_STAT_HOL_DATE5Missing mandatory Statutory Holiday Date 5 for Record of Employment.
Statutory Holiday Date 5 must be entered. this is a kye value for the record in the table.
MISSING_STAT_HOL_GRS1Missing mandatory Statutory Holiday Pay Amount 1 for Record of Employment.
Statutory Holiday Pay Amount 1 must be entered. This is a key value for the record in the table.
MISSING_STAT_HOL_GRS2Missing mandatory Statutory Holiday Pay Amount 2 for Record of Employment.
Statutory Holiday Pay Amount 2 must be entered. This is a key value for the record in the table.
MISSING_STAT_HOL_GRS3Missing mandatory Statutory Holiday Pay Amount 3 for Record of Employment.
Statutory Holiday Pay Amount 3 must be entered. This is a key value for the record in the table.
MISSING_STAT_HOL_GRS4Missing mandatory Statutory Holiday Pay Amount 4 for Record of Employment.
Statutory Holiday Pay Amount 4 must be entered. This is a key value for the record in the table.
MISSING_STAT_HOL_GRS5Missing mandatory Statutory Holiday Pay Amount 5 for Record of Employment.
Statutory Holiday Pay Amount 5 must be entered. This is a key value for the record in the table.
MISSING_TOTAL_HRSMissing mandatory Total Insurable Hours Worked by the Employee in the last 52 weeks for Record of Employment.
Total Insurable Hours Worked by the Employee in the last 52 weeks must be entered. This is a key value for the record in the table.
PIDM_DECEASEDEmployee Identification Number for Record of Employment is deceased.
Employee is deceased.
PK_NOT_FOUNDCannot update Record of employment; record does not exist.
Cannot update the record of Employment as the record does not exist.
PRINT_DELETE_FAILEDCannot delete Record of Employment, record already printed.
Cannot delete Record of Employment as the record already printed.
P_DELETE_FAILEDCannot delete Record of Employment, record does not exist.
Cannot delete Record of Employment as the record does not exist.
RECORD_EXISTSCannot create Record of Employment, record already exists.
Cannot create Record of Employment as the record already exists.
INVALID_VAC_ROEV_CODEInvalid Vacation for Issuing ROE for Record of Employment.
Vacation for Issuing ROE must exist in PTVROEV.
INVALID_VAC_ROEP_CODEInvalid Vacation for Issuing ROE for Record of Employment.
Rules have not been established in PTRROEP for this ROE code.
INVALID_VAC_GRSVacation Pay cannot be null.
Amount is required for this pay code.
INVALID_VAC_GRS1Vacation Pay should be null.
Amount cannot be reported for the ROE pay code entered.
INVALID_SDATEVacation Start Date cannot be null.
Start Date is required for this pay code.
INVALID_SDATE1Vacation Start Date should be null.
Start Date cannot be reported for the ROE pay code entered.
INVALID_EDATEVacation End Date cannot be null.
End Date is required for this pay code.
INVALID_EDATE1Vacation End Date should be null.
End Date cannot be reported for the ROE pay code entered.
INVALID_MONEY_TYPE1Invalid Money Type1.
Money Pay Code1 Should exists in PTVROEM.
INVALID_MONEY_TYPE2Invalid Money Type2.
Money Pay Code2 Should exists in PTVROEM.
INVALID_MONEY_TYPE3Invalid Money Type3.
Money Pay Code3 Should exists in PTVROEM.
INVALID_MONEY_TYPE1_ROEPInvalid Money Type1.
Rules have not been established in PTRROEP for this ROE pay code.
INVALID_MONEY_TYPE2_ROEPInvalid Money Type2.
Rules have not been established in PTRROEP for this ROE pay code.
INVALID_MONEY_TYPE3_ROEPInvalid Money Type3.
Rules have not been established in PTRROEP for this ROE pay code.
INVALID_OTH1_GRSVacation Pay cannot be null.
Amount is required for this pay code.
INVALID_OTH1_GRS1Vacation Pay should be null.
Amount cannot be reported for the ROE pay code entered.
INVALID_OTH2_GRSVacation Pay cannot be null.
Amount is required for this pay code.
INVALID_OTH2_GRS1Vacation Pay should be null.
Amount cannot be reported for the ROE pay code entered.
INVALID_OTH3_GRSVacation Pay cannot be null.
Amount is required for this pay code.
INVALID_OTH3_GRS1Vacation Pay should be null.
Amount cannot be reported for the ROE pay code entered.
INVALID_OTH1_SDATEOther Money Start Date1 cannot be null.
Other Money Start Date1 is required for this pay code.
INVALID_OTH2_SDATEOther Money Start Date2 cannot be null.
Other Money Start Date2 is required for this pay code.
INVALID_OTH3_SDATEOther Money Start Date3 cannot be null.
Other Money Start Date3 is required for this pay code.
INVALID_OTH1_SDATE1Other Money Start Date1 should be null.
Other Money Start Date1 cannot be reported for the ROE pay code entered.
INVALID_OTH2_SDATE1Other Money Start Date2 should be null.
Other Money Start Date2 cannot be reported for the ROE pay code entered.
INVALID_OTH3_SDATE1Other Money Start Date3 should be null.
Other Money Start Date3 cannot be reported for the ROE pay code entered.
INVALID_OTH1_EDATEOther Money End Date1 cannot be null.
Other Money End Date1 is required for this pay code.
INVALID_OTH2_EDATEOther Money End Date2 cannot be null.
Other Money End Date2 is required for this pay code.
INVALID_OTH3_EDATEOther Money End Date3 cannot be null.
Other Money End Date3 is required for this pay code.
INVALID_OTH1_EDATE1Other Money End Date1 should be null.
Other Money End Date1 cannot be reported for the ROE pay code entered.
INVALID_OTH2_EDATE1Other Money End Date2 should be null.
Other Money End Date2 cannot be reported for the ROE pay code entered.
INVALID_OTH3_EDATE1Other Money End Date3 should be null.
Other Money End Date3 cannot be reported for the ROE pay code entered.
INVALID_SP_SDATESpecial Payment Start Date1 cannot be null.
Special Payment Start Date1 is required for this pay code.
INVALID_SP2_SDATESpecial Payment Start Date2 cannot be null.
Special Payment Start Date2 is required for this pay code.
INVALID_SP3_SDATESpecial Payment Start Date3 cannot be null.
Special Payment Start Date3 is required for this pay code.
INVALID_SP4_SDATESpecial Payment Start Date4 cannot be null.
Special Payment Start Date4 is required for this pay code.
INVALID_SP_SDATE1Special Payment Start Date1 should be null.
Special Payment Start Date1 cannot be reported for the ROE pay code entered.
INVALID_SP2_SDATE1Special Payment Start Date2 should be null.
Special Payment Start Date2 cannot be reported for the ROE pay code entered.
INVALID_SP3_SDATE1Special Payment Start Date3 should be null.
Special Payment Start Date3 cannot be reported for the ROE pay code entered.
INVALID_SP4_SDATE1Special Payment Start Date4 should be null.
Special Payment Start Date4 cannot be reported for the ROE pay code entered.
INVALID_SP_EDATESpecial Payment End Date1 cannot be null.
Special Payment End Date1 is required for this pay code.
INVALID_SP2_EDATESpecial Payment End Date2 cannot be null.
Special Payment End Date2 is required for this pay code.
INVALID_SP3_EDATESpecial Payment End Date3 cannot be null.
Special Payment End Date3 is required for this pay code.
INVALID_SP4_EDATESpecial Payment End Date4 cannot be null.
Special Payment End Date4 is required for this pay code.
INVALID_SP_EDATE1Special Payment End Date1 should be null.
Special Payment End Date1 cannot be reported for the ROE pay code entered.
INVALID_SP2_EDATE1Special Payment End Date2 should be null.
Special Payment End Date2 cannot be reported for the ROE pay code entered.
INVALID_SP3_EDATE1Special Payment End Date3 should be null.
Special Payment End Date3 cannot be reported for the ROE pay code entered.
INVALID_SP4_EDATE1Special Payment End Date4 should be null.
Special Payment End Date4 cannot be reported for the ROE pay code entered.
INVALID_ROES_CODE1Invalid Roes Code.
Special Payment Code1 Should exists in PTVROES.
INVALID_ROES_CODE2Invalid Roes Code.
Special Payment Code2 Should exists in PTVROES.
INVALID_ROES_CODE3Invalid Roes Code.
Special Payment Code3 Should exists in PTVROES.
INVALID_ROES_CODE4Invalid Roes Code.
Special Payment Code4 Should exists in PTVROES.
INVALID_ROES_CODE1_ROEPInvalid Roes Code1.
Rules have not been established in PTRROEP for this ROE code.
INVALID_ROES_CODE2_ROEPInvalid Roes Code1.
Rules have not been established in PTRROEP for this ROE code.
INVALID_ROES_CODE3_ROEPInvalid Roes Code1.
Rules have not been established in PTRROEP for this ROE code.
INVALID_ROES_CODE4_ROEPInvalid Roes Code1.
Rules have not been established in PTRROEP for this ROE code.
INVALID_SP_GRSSpecial Payment cannot be null.
Amount is required for this pay code.
INVALID_SP_GRS1Special Payment should be null.
Amount cannot be reported for the ROE pay code entered.
INVALID_SP2_GRSSpecial Paymentcannot be null.
Amount is required for this pay code.
INVALID_SP2_GRS1Special Payment should be null.
Amount cannot be reported for the ROE pay code entered.
INVALID_SP3_GRSSpecial Paymentcannot be null.
Amount is required for this pay code.
INVALID_SP3_GRS1Special Payment should be null.
Amount cannot be reported for the ROE pay code entered.
INVALID_SP4_GRSSpecial Payment cannot be null.
Amount is required for this pay code.
INVALID_SP4_GRS1Special Payment should be null.
Amount cannot be reported for the ROE pay code entered.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Global PL/SQL table that holds the error messages.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global PL/SQL table that holds the error messages.


f_get_error

Function f_get_error(p_errorname VARCHAR2)
  RETURN gb_common_strings.err_type

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.