[Home] [Help]
3116: , p_source_id => NULL
3117: , p_source_text => NULL
3118: , p_tax_unit_id => l_tax_unit_id
3119: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3120: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_SENDER_ID')
3121: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3122: , p_action_information6 => 'Sender ID is null'
3123: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3124: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3136: , p_source_id => NULL
3137: , p_source_text => NULL
3138: , p_tax_unit_id => l_tax_unit_id
3139: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3140: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_PERSON_NM')
3141: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3142: , p_action_information6 => 'Contact Person is null'
3143: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3144: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3156: , p_source_id => NULL
3157: , p_source_text => NULL
3158: , p_tax_unit_id => l_tax_unit_id
3159: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3160: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CONTACT_NO')
3161: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3162: , p_action_information6 => 'Contact Number is null'
3163: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3164: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3176: , p_source_id => NULL
3177: , p_source_text => NULL
3178: , p_tax_unit_id => l_tax_unit_id
3179: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3180: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_NO')
3181: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3182: , p_action_information6 => 'Tax Registration Number is null'
3183: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3184: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3197: , p_source_id => NULL
3198: , p_source_text => NULL
3199: , p_tax_unit_id => l_tax_unit_id
3200: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3201: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_FORMAT')
3202: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3203: , p_action_information6 => 'Tax Registration Number is not in the format 111111111L11'
3204: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3205: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3217: , p_source_id => NULL
3218: , p_source_text => NULL
3219: , p_tax_unit_id => l_tax_unit_id
3220: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3221: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_NAME')
3222: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3223: , p_action_information6 => 'Tax Reporting Name is null'
3224: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3225: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3404: , p_source_id => NULL
3405: , p_source_text => NULL
3406: , p_tax_unit_id => l_tax_unit_id
3407: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3408: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_SECTOR')
3409: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3410: , p_action_information6 => 'Mandatory check on Sector'
3411: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3412: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3422: , p_source_id => NULL
3423: , p_source_text => NULL
3424: , p_tax_unit_id => l_tax_unit_id
3425: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3426: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_RISK_GROUP')
3427: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3428: , p_action_information6 => 'No Risk Group'
3429: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3430: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3442: , p_source_id => NULL
3443: , p_source_text => NULL
3444: , p_tax_unit_id => l_tax_unit_id
3445: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3446: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_BASE_WEWE') -- Message Code should have been '%_WEWA'
3447: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3448: , p_action_information6 => 'Waiting Money Fund contribution base is zero'
3449: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3450: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3462: , p_source_id => NULL
3463: , p_source_text => NULL
3464: , p_tax_unit_id => l_tax_unit_id
3465: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3466: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_AWF')
3467: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3468: , p_action_information6 => 'AWF contribution base is zero'
3469: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3470: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3718: , p_source_id => NULL
3719: , p_source_text => NULL
3720: , p_tax_unit_id => l_tax_unit_id
3721: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3722: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_SECTOR')
3723: , p_action_information5 => l_period_dates_rec.End_date
3724: , p_action_information6 => 'Mandatory check on Sector'
3725: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3726: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3736: , p_source_id => NULL
3737: , p_source_text => NULL
3738: , p_tax_unit_id => l_tax_unit_id
3739: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3740: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_RISK_GROUP')
3741: , p_action_information5 => l_period_dates_rec.End_date
3742: , p_action_information6 => 'No Risk Group'
3743: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3744: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3756: , p_source_id => NULL
3757: , p_source_text => NULL
3758: , p_tax_unit_id => l_tax_unit_id
3759: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3760: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_BASE_WEWE') -- Message Code should have been '%_WEWA'
3761: , p_action_information5 => l_period_dates_rec.End_date
3762: , p_action_information6 => 'Waiting Money Fund contribution base is zero'
3763: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3764: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3776: , p_source_id => NULL
3777: , p_source_text => NULL
3778: , p_tax_unit_id => l_tax_unit_id
3779: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
3780: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_AWF')
3781: , p_action_information5 => l_period_dates_rec.End_date
3782: , p_action_information6 => 'AWF contribution base is zero'
3783: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3784: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4792: , p_source_id => NULL
4793: , p_source_text => NULL
4794: , p_tax_unit_id => p_tax_unit_id
4795: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4796: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_STREET')
4797: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
4798: , p_action_information6 => 'Street name missing in the address'
4799: , p_action_information7 => p_name
4800: , p_action_information8 => p_assignment_number);
4812: , p_source_id => NULL
4813: , p_source_text => NULL
4814: , p_tax_unit_id => p_tax_unit_id
4815: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4816: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CITY')
4817: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
4818: , p_action_information6 => 'City name missing in the address'
4819: , p_action_information7 => p_name
4820: , p_action_information8 => p_assignment_number);
4832: , p_source_id => NULL
4833: , p_source_text => NULL
4834: , p_tax_unit_id => p_tax_unit_id
4835: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4836: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_PO_CODE')
4837: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
4838: , p_action_information6 => 'Postal Code missing in address'
4839: , p_action_information7 => p_name
4840: , p_action_information8 => p_assignment_number);
4852: , p_source_id => NULL
4853: , p_source_text => NULL
4854: , p_tax_unit_id => p_tax_unit_id
4855: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4856: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_COUNTRY')
4857: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
4858: , p_action_information6 => 'Country is missing in address'
4859: , p_action_information7 => p_name
4860: , p_action_information8 => p_assignment_number);
4881: , p_source_id => NULL
4882: , p_source_text => NULL
4883: , p_tax_unit_id => p_tax_unit_id
4884: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4885: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_PO_FORMAT')
4886: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
4887: , p_action_information6 => 'Postal Code is not in the format 9999XX'
4888: , p_action_information7 => p_name
4889: , p_action_information8 => p_assignment_number);
4954: , p_source_id => NULL
4955: , p_source_text => NULL
4956: , p_tax_unit_id => p_tax_unit_id
4957: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4958: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ADDRESS')
4959: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
4960: , p_action_information6 => 'Address details are null'
4961: , p_action_information7 => p_name
4962: , p_action_information8 => p_assignment_number);
5293: , p_source_id => NULL
5294: , p_source_text => NULL
5295: , p_tax_unit_id => p_tax_unit_id
5296: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5297: , p_action_information4 => fnd_message.get_string('PER','HR_NL_UFO_AND_AWF')
5298: , p_action_information5 => fnd_date.date_to_canonical(p_date)
5299: , p_action_information6 => 'UFO Contributions and AWF Contributions exist'
5300: , p_action_information7 => p_name
5301: , p_action_information8 => p_assignment_id);
5313: , p_source_id => NULL
5314: , p_source_text => NULL
5315: , p_tax_unit_id => p_tax_unit_id
5316: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5317: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_WEWA')
5318: , p_action_information5 => fnd_date.date_to_canonical(p_date)
5319: , p_action_information6 => 'Waiting Money Fund contribution is zero'
5320: , p_action_information7 => p_name
5321: , p_action_information8 => p_assignment_id);
5333: , p_source_id => NULL
5334: , p_source_text => NULL
5335: , p_tax_unit_id => p_tax_unit_id
5336: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5337: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_WEWE')
5338: , p_action_information5 => fnd_date.date_to_canonical(p_date)
5339: , p_action_information6 => 'AWF contribution is zero'
5340: , p_action_information7 => p_name
5341: , p_action_information8 => p_assignment_id);
7391: , p_source_id => NULL
7392: , p_source_text => NULL
7393: , p_tax_unit_id => l_tax_unit_id
7394: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7395: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ASG_RISK_GRP')
7396: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
7397: , p_action_information6 => 'Assignment has no Sector or Risk Group'
7398: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7399: , p_action_information8 => l_emp_rec.assignment_number);
7454: , p_source_id => NULL
7455: , p_source_text => NULL
7456: , p_tax_unit_id => l_tax_unit_id
7457: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7458: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ZVW_CODE_INSURED')
7459: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
7460: , p_action_information6 => 'Code ZVW is defaulted to - A'
7461: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7462: , p_action_information8 => l_emp_rec.assignment_number);
7474: , p_source_id => NULL
7475: , p_source_text => NULL
7476: , p_tax_unit_id => l_tax_unit_id
7477: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7478: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_LABOR_CODE')
7479: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
7480: , p_action_information6 => 'Labor Relation code is null'
7481: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7482: , p_action_information8 => l_emp_rec.assignment_number);
7494: , p_source_id => NULL
7495: , p_source_text => NULL
7496: , p_tax_unit_id => l_tax_unit_id
7497: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7498: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CONTRACT_CODE')
7499: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
7500: , p_action_information6 => 'Code contract for limited or unlimited time is null'
7501: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7502: , p_action_information8 => l_emp_rec.assignment_number);
7514: , p_source_id => NULL
7515: , p_source_text => NULL
7516: , p_tax_unit_id => l_tax_unit_id
7517: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7518: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_WORK_PATTERN')
7519: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
7520: , p_action_information6 => 'Indication regular work pattern is null'
7521: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7522: , p_action_information8 => l_emp_rec.assignment_number);
7534: , p_source_id => NULL
7535: , p_source_text => NULL
7536: , p_tax_unit_id => l_tax_unit_id
7537: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7538: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TEMP_LABOR_CODE')
7539: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
7540: , p_action_information6 => 'Temp Labor Code is null'
7541: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7542: , p_action_information8 => l_emp_rec.assignment_number);
7554: , p_source_id => NULL
7555: , p_source_text => NULL
7556: , p_tax_unit_id => l_tax_unit_id
7557: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7558: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_COMPANY_CAR_USE')
7559: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
7560: , p_action_information6 => 'Company Car Usage code invalid'
7561: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7562: , p_action_information8 => l_emp_rec.assignment_number);
7684: , p_source_id => NULL
7685: , p_source_text => NULL
7686: , p_tax_unit_id => l_tax_unit_id
7687: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7688: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ASG_RISK_GRP')
7689: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
7690: , p_action_information6 => 'Assignment has no Sector or Risk Group'
7691: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7692: , p_action_information8 => l_emp_rec.assignment_number);
7706: , p_source_id => NULL
7707: , p_source_text => NULL
7708: , p_tax_unit_id => l_tax_unit_id
7709: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7710: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ZVW_CODE_INSURED')
7711: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
7712: , p_action_information6 => 'Code ZVW is defaulted to - A'
7713: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7714: , p_action_information8 => l_emp_rec.assignment_number);
7726: , p_source_id => NULL
7727: , p_source_text => NULL
7728: , p_tax_unit_id => l_tax_unit_id
7729: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7730: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_LABOR_CODE')
7731: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
7732: , p_action_information6 => 'Labor Relation code is null'
7733: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7734: , p_action_information8 => l_emp_rec.assignment_number);
7746: , p_source_id => NULL
7747: , p_source_text => NULL
7748: , p_tax_unit_id => l_tax_unit_id
7749: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7750: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CONTRACT_CODE')
7751: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
7752: , p_action_information6 => 'Code contract for limited or unlimited time is null'
7753: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7754: , p_action_information8 => l_emp_rec.assignment_number);
7766: , p_source_id => NULL
7767: , p_source_text => NULL
7768: , p_tax_unit_id => l_tax_unit_id
7769: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7770: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_WORK_PATTERN')
7771: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
7772: , p_action_information6 => 'Indication regular work pattern is null'
7773: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7774: , p_action_information8 => l_emp_rec.assignment_number);
7786: , p_source_id => NULL
7787: , p_source_text => NULL
7788: , p_tax_unit_id => l_tax_unit_id
7789: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7790: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TEMP_LABOR_CODE')
7791: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
7792: , p_action_information6 => 'Temp Labor Code is null'
7793: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7794: , p_action_information8 => l_emp_rec.assignment_number);
7806: , p_source_id => NULL
7807: , p_source_text => NULL
7808: , p_tax_unit_id => l_tax_unit_id
7809: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7810: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_COMPANY_CAR_USE')
7811: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
7812: , p_action_information6 => 'Company Car Usage code invalid'
7813: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
7814: , p_action_information8 => l_emp_rec.assignment_number);