1060: IF (p_record_name in ('RO','RW','RS','RCW','RCO','RSSUMM') OR
1061: (p_record_name = 'D' AND p_report_qualifier = 'AK_SQWL')) THEN
1062: l_description:=' The number is bigger than the given length '
1063: ||l_length;
1064: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1065: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1066: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1067: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1068: pay_core_utils.push_token('description',substr(l_description,1,50));
1061: (p_record_name = 'D' AND p_report_qualifier = 'AK_SQWL')) THEN
1062: l_description:=' The number is bigger than the given length '
1063: ||l_length;
1064: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1065: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1066: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1067: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1068: pay_core_utils.push_token('description',substr(l_description,1,50));
1069: /* Error in RW record for employee 1234 in Medicare wages.
1062: l_description:=' The number is bigger than the given length '
1063: ||l_length;
1064: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1065: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1066: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1067: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1068: pay_core_utils.push_token('description',substr(l_description,1,50));
1069: /* Error in RW record for employee 1234 in Medicare wages.
1070: The number is bigger than the given length 11 */
1063: ||l_length;
1064: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1065: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1066: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1067: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1068: pay_core_utils.push_token('description',substr(l_description,1,50));
1069: /* Error in RW record for employee 1234 in Medicare wages.
1070: The number is bigger than the given length 11 */
1071: hr_utility.trace(p_input_3 ||' '||l_description);
1064: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1065: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1066: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1067: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1068: pay_core_utils.push_token('description',substr(l_description,1,50));
1069: /* Error in RW record for employee 1234 in Medicare wages.
1070: The number is bigger than the given length 11 */
1071: hr_utility.trace(p_input_3 ||' '||l_description);
1072: END IF;
1081: return_value:='-'||lpad(nvl(replace(l_input_2,'-'),0),l_length-1,0);
1082: IF( p_record_name in ('RO','RW','RS','RCW','RCO','D','RSSUMM') OR
1083: (p_record_name = 'D' AND p_report_qualifier = 'AK_SQWL')) THEN
1084: l_description:=' The value is negative '||substr(l_input_2,1,l_length);
1085: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1086: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1087: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1088: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1089: pay_core_utils.push_token('description',substr(l_description,1,50));
1082: IF( p_record_name in ('RO','RW','RS','RCW','RCO','D','RSSUMM') OR
1083: (p_record_name = 'D' AND p_report_qualifier = 'AK_SQWL')) THEN
1084: l_description:=' The value is negative '||substr(l_input_2,1,l_length);
1085: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1086: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1087: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1088: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1089: pay_core_utils.push_token('description',substr(l_description,1,50));
1090:
1083: (p_record_name = 'D' AND p_report_qualifier = 'AK_SQWL')) THEN
1084: l_description:=' The value is negative '||substr(l_input_2,1,l_length);
1085: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1086: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1087: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1088: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1089: pay_core_utils.push_token('description',substr(l_description,1,50));
1090:
1091: /* sample mesg*/
1084: l_description:=' The value is negative '||substr(l_input_2,1,l_length);
1085: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1086: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1087: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1088: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1089: pay_core_utils.push_token('description',substr(l_description,1,50));
1090:
1091: /* sample mesg*/
1092: /* Error in RW record for employee 1234 in Medicare wages.
1085: pay_core_utils.push_message(801,'PAY_INVALID_EE_DATA','A');
1086: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
1087: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
1088: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1089: pay_core_utils.push_token('description',substr(l_description,1,50));
1090:
1091: /* sample mesg*/
1092: /* Error in RW record for employee 1234 in Medicare wages.
1093: The value is negative -2345 */