1230: ||' and '||
1231: parameter_record(7).p_parameter_name;
1232: l_amount:=l_ss_wage_limit/100;
1233: l_description:=' It is greater than '||to_char(l_amount);
1234: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1235: pay_core_utils.push_token('record_name',p_record_name);
1236: pay_core_utils.push_token('name_or_number',
1237: substr(l_emp_name_or_number,1,50));
1238: pay_core_utils.push_token('field_name',l_field_description);
1231: parameter_record(7).p_parameter_name;
1232: l_amount:=l_ss_wage_limit/100;
1233: l_description:=' It is greater than '||to_char(l_amount);
1234: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1235: pay_core_utils.push_token('record_name',p_record_name);
1236: pay_core_utils.push_token('name_or_number',
1237: substr(l_emp_name_or_number,1,50));
1238: pay_core_utils.push_token('field_name',l_field_description);
1239: pay_core_utils.push_token('description',
1232: l_amount:=l_ss_wage_limit/100;
1233: l_description:=' It is greater than '||to_char(l_amount);
1234: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1235: pay_core_utils.push_token('record_name',p_record_name);
1236: pay_core_utils.push_token('name_or_number',
1237: substr(l_emp_name_or_number,1,50));
1238: pay_core_utils.push_token('field_name',l_field_description);
1239: pay_core_utils.push_token('description',
1240: substr(l_description,1,50));
1234: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1235: pay_core_utils.push_token('record_name',p_record_name);
1236: pay_core_utils.push_token('name_or_number',
1237: substr(l_emp_name_or_number,1,50));
1238: pay_core_utils.push_token('field_name',l_field_description);
1239: pay_core_utils.push_token('description',
1240: substr(l_description,1,50));
1241: l_err := TRUE;
1242: END IF;
1235: pay_core_utils.push_token('record_name',p_record_name);
1236: pay_core_utils.push_token('name_or_number',
1237: substr(l_emp_name_or_number,1,50));
1238: pay_core_utils.push_token('field_name',l_field_description);
1239: pay_core_utils.push_token('description',
1240: substr(l_description,1,50));
1241: l_err := TRUE;
1242: END IF;
1243: IF rcw_wage_rec(4).wage_new_value > l_ss_tax_limit
1247: to_char(l_ss_tax_limit));
1248: l_err := TRUE;
1249: l_amount:=l_ss_tax_limit/100;
1250: l_description:=' It is greater than '||to_char(l_amount);
1251: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1252: pay_core_utils.push_token('record_name',p_record_name);
1253: pay_core_utils.push_token('name_or_number',
1254: substr(l_emp_name_or_number,1,50));
1255: pay_core_utils.push_token('field_name',parameter_record(4).p_parameter_name);
1248: l_err := TRUE;
1249: l_amount:=l_ss_tax_limit/100;
1250: l_description:=' It is greater than '||to_char(l_amount);
1251: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1252: pay_core_utils.push_token('record_name',p_record_name);
1253: pay_core_utils.push_token('name_or_number',
1254: substr(l_emp_name_or_number,1,50));
1255: pay_core_utils.push_token('field_name',parameter_record(4).p_parameter_name);
1256: pay_core_utils.push_token('description',l_description);
1249: l_amount:=l_ss_tax_limit/100;
1250: l_description:=' It is greater than '||to_char(l_amount);
1251: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1252: pay_core_utils.push_token('record_name',p_record_name);
1253: pay_core_utils.push_token('name_or_number',
1254: substr(l_emp_name_or_number,1,50));
1255: pay_core_utils.push_token('field_name',parameter_record(4).p_parameter_name);
1256: pay_core_utils.push_token('description',l_description);
1257: /* Sample message for SS Wage/Tax limit
1251: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1252: pay_core_utils.push_token('record_name',p_record_name);
1253: pay_core_utils.push_token('name_or_number',
1254: substr(l_emp_name_or_number,1,50));
1255: pay_core_utils.push_token('field_name',parameter_record(4).p_parameter_name);
1256: pay_core_utils.push_token('description',l_description);
1257: /* Sample message for SS Wage/Tax limit
1258: Error in RW record for Employee 1234 in Social Security Tax Withheld. It is greater than 498480 */
1259: --}
1252: pay_core_utils.push_token('record_name',p_record_name);
1253: pay_core_utils.push_token('name_or_number',
1254: substr(l_emp_name_or_number,1,50));
1255: pay_core_utils.push_token('field_name',parameter_record(4).p_parameter_name);
1256: pay_core_utils.push_token('description',l_description);
1257: /* Sample message for SS Wage/Tax limit
1258: Error in RW record for Employee 1234 in Social Security Tax Withheld. It is greater than 498480 */
1259: --}
1260: END IF; --l_ss_tax_limit