index

Package px_mass_roe_strings

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

Message NameError Message
EMPLOYEE_DECEASEDEmployee Identification Number for Mass Record of Employment is deceased.
Employee is deceased.
INVALID_EMPCODEInvalid Employer Code for the employee.
Employer Code must exist in PHRDEDN.
INVALID_EMPR_CODEInvalid Employer Code for Mass Record of Employment.
Employer Code must exist in PTREMPR.
INVALID_FIRST_DAY_WORKEDEmployee Last Work Date should be greater than Employee First Work Date.
Employee Last Work Date should be greater than Employee First Work Date.
INVALID_RECALL_DATEEmployee Recall Date should be greater than Employee Last Work Date.
Employee Recall Date should be greater than Employee Last Work Date.
INVALID_JOBEmployee must have a Job assigned to Pay Id selected.
Employee does not have a Job assigned to the selected Payroll ID.
INVALID_LANGUAGE_INDInvalid Language Indicator for Mass Canadian Record of Employment; Valid values: E and F.
Valid values for Language Indicator are E and F.
INVALID_PICT_CODEInvalid Payroll ID for Mass Record of Employment.
Payroll ID must exist in PTRPICT.
INVALID_PIDMInvalid PIDM for Mass Record of Employment.
Employee Identification number is invalid.
INVALID_RECALL_INDInvalid Recall Indicator for Mass Canadian Record of Employment; Valid values: N, S, U and Y.
Valid values for Recall Indicator are N, S, U and Y.
INVALID_ROEC_CODEInvalid Reason for Issuing ROE for Mass Record of Employment.
Reason for issuing ROE must exist in PTVROER.
MISSING_EMPR_CODEMissing mandatory Employer Code for Mass Record of Employment.
Employer Code must be entered. It is a key value for the record in the table.
MISSING_FIRST_DAY_WORKEDMissing mandatory Employee First Worked Date for Mass Record of Employment.
PEmployee First Worked Date must be entered. It is a key value for the record in the table.
MISSING_LANGUAGE_INDMissing mandatory Language Indicator for Mass Record of Employment.
Language Indicator must be entered. It is a key value for the record in the table.
MISSING_LAST_DAY_WORKEDMissing mandatory Employee Last Day Worked for Mass Record of Employment.
Employee Last Worked Date must be entered. It is a key value for tecord in the table.
MISSING_PICT_CODEMissing mandatory Payroll ID for Mass Record of Employment.
Payroll ID must be entered. It is a key value for the record in the table.
MISSING_PIDMMissing mandatory Employee Identification Number for Mass Record of Employment.
Employee Identification Number must be entered. It is a key value for the record in the table.
MISSING_RECALL_DATEMissing mandatory Employee Return Date for Mass Record of Employment.
Employee Return Date must be entered. It is a key value for the record in the table.
MISSING_RECALL_INDMissing mandatory Employee Return Indicator for Mass Record of Employment.
Return Indicator must be entered. It is a key value for the record in the table.
MISSING_ROEC_CODEMissing mandatory Reason for the Employer Issuing this ROE for Mass Record of Employment.
Reason for Employer issuing the ROE must be enterd. It is a key value for the record in the table.
PK_NOT_FOUNDCannot update Mass Canadian Record of Employment; record does not exist.
Cannot update the Record of Employment as the record does not exist.
P_DELETE_FAILEDCannot delete Mass Canadian Record of Employment, record does not exist.
Cannot delete the Record of Employment as the record does not exist.


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.