51: --
52: -- If the value is being inserted or updated...
53: --
54: if (p_emp_fed_tax_rule_id is not null
55: and nvl(p_sui_state_code,hr_api.g_varchar2)
56: <> pay_fed_shd.g_old_rec.sui_state_code)
57: or (p_emp_fed_tax_rule_id is null) then
58: --
59: -- Check that the mandatory parameters have been set
152: hr_utility.set_message(801, 'PAY_72782_FED_BG_NOT_NULL');
153: hr_utility.raise_error;
154: end if;
155: --
156: hr_api.mandatory_arg_error
157: (p_api_name => l_proc
158: ,p_argument => 'effective_date'
159: ,p_argument_value => p_effective_date
160: );
250: hr_utility.set_location('Entering:'||l_proc,5);
251: --
252: -- Check that the mandatory parameters have been set
253: --
254: hr_api.mandatory_arg_error
255: (p_api_name => l_proc
256: ,p_argument => 'sui_state_code'
257: ,p_argument_value => p_sui_state_code
258: );
259: --
260: -- If the value is being inserted or updated...
261: --
262: if (p_emp_fed_tax_rule_id is not null
263: and nvl(p_sui_jurisdiction_code,hr_api.g_varchar2)
264: <> nvl(pay_fed_shd.g_old_rec.sui_jurisdiction_code,hr_api.g_varchar2)
265: or (p_emp_fed_tax_rule_id is null)) then
266: --
267: -- Check that the mandatory parameters have been set
260: -- If the value is being inserted or updated...
261: --
262: if (p_emp_fed_tax_rule_id is not null
263: and nvl(p_sui_jurisdiction_code,hr_api.g_varchar2)
264: <> nvl(pay_fed_shd.g_old_rec.sui_jurisdiction_code,hr_api.g_varchar2)
265: or (p_emp_fed_tax_rule_id is null)) then
266: --
267: -- Check that the mandatory parameters have been set
268: --
332: --
333: -- If the value is being inserted or updated...
334: --
335: if (p_emp_fed_tax_rule_id is not null
336: and nvl(p_additional_wa_amount,hr_api.g_number) <>
337: pay_fed_shd.g_old_rec.additional_wa_amount)
338: or (p_emp_fed_tax_rule_id is null) then
339: --
340: -- Check that the mandatory parameters have been set
403: hr_utility.set_location('Entering:'||l_proc,5);
404: --
405: -- Check that the mandatory parameters have been set
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc
409: ,p_argument => 'effective_date'
410: ,p_argument_value => p_effective_date
411: );
412: --
413: -- If the value is being inserted or updated...
414: --
415: if (p_emp_fed_tax_rule_id is not null
416: and nvl(p_filing_status_code,hr_api.g_varchar2)
417: <> pay_fed_shd.g_old_rec.filing_status_code)
418: or (p_emp_fed_tax_rule_id is null) then
419: --
420: -- Check that the mandatory parameters have been set
425: end if;
426: --
427: -- check if filing_status_code value exists in hr_lookups table
428: --
429: if hr_api.not_exists_in_dt_hr_lookups
430: (p_effective_date => p_effective_date
431: ,p_validation_start_date => p_validation_start_date
432: ,p_validation_end_date => p_validation_end_date
433: ,p_lookup_type => 'US_FIT_FILING_STATUS'
487: --
488: -- If the value is being inserted or updated...
489: --
490: if (p_emp_fed_tax_rule_id is not null
491: and nvl(p_fit_override_amount,hr_api.g_number)
492: <> nvl(pay_fed_shd.g_old_rec.fit_override_amount,hr_api.g_number))
493: or (p_emp_fed_tax_rule_id is null) then
494: --
495: -- Check that the mandatory parameters have been set
488: -- If the value is being inserted or updated...
489: --
490: if (p_emp_fed_tax_rule_id is not null
491: and nvl(p_fit_override_amount,hr_api.g_number)
492: <> nvl(pay_fed_shd.g_old_rec.fit_override_amount,hr_api.g_number))
493: or (p_emp_fed_tax_rule_id is null) then
494: --
495: -- Check that the mandatory parameters have been set
496: --
553: --
554: -- If the value is being inserted or updated...
555: --
556: if (p_emp_fed_tax_rule_id is not null
557: and nvl(p_fit_override_rate,hr_api.g_number)
558: <> nvl(pay_fed_shd.g_old_rec.fit_override_rate,hr_api.g_number))
559: or (p_emp_fed_tax_rule_id is null) then
560: --
561: -- Check that the mandatory parameters have been set
554: -- If the value is being inserted or updated...
555: --
556: if (p_emp_fed_tax_rule_id is not null
557: and nvl(p_fit_override_rate,hr_api.g_number)
558: <> nvl(pay_fed_shd.g_old_rec.fit_override_rate,hr_api.g_number))
559: or (p_emp_fed_tax_rule_id is null) then
560: --
561: -- Check that the mandatory parameters have been set
562: --
619: --
620: -- If the value is being inserted or updated...
621: --
622: if (p_emp_fed_tax_rule_id is not null
623: and nvl(p_withholding_allowances,hr_api.g_number)
624: <> nvl(pay_fed_shd.g_old_rec.withholding_allowances,hr_api.g_number))
625: or (p_emp_fed_tax_rule_id is null) then
626: --
627: -- Check that the mandatory parameters have been set
620: -- If the value is being inserted or updated...
621: --
622: if (p_emp_fed_tax_rule_id is not null
623: and nvl(p_withholding_allowances,hr_api.g_number)
624: <> nvl(pay_fed_shd.g_old_rec.withholding_allowances,hr_api.g_number))
625: or (p_emp_fed_tax_rule_id is null) then
626: --
627: -- Check that the mandatory parameters have been set
628: --
690: hr_utility.set_location('Entering:'||l_proc,5);
691: --
692: -- Check that the mandatory parameters have been set
693: --
694: hr_api.mandatory_arg_error
695: (p_api_name => l_proc
696: ,p_argument => 'effective_date'
697: ,p_argument_value => p_effective_date
698: );
699: --
700: -- If the value is being updated or inserted...
701: --
702: if ((p_emp_fed_tax_rule_id is not null
703: and nvl(p_eic_filing_status_code,hr_api.g_varchar2)
704: <> nvl(pay_fed_shd.g_old_rec.eic_filing_status_code,hr_api.g_varchar2))
705: or
706: (p_emp_fed_tax_rule_id is null)) then
707: --
700: -- If the value is being updated or inserted...
701: --
702: if ((p_emp_fed_tax_rule_id is not null
703: and nvl(p_eic_filing_status_code,hr_api.g_varchar2)
704: <> nvl(pay_fed_shd.g_old_rec.eic_filing_status_code,hr_api.g_varchar2))
705: or
706: (p_emp_fed_tax_rule_id is null)) then
707: --
708: -- Validate only if attribute is not null
710: if p_eic_filing_status_code is not null then
711: --
712: -- check if eic_filing_status_code value exists in hr_lookups table
713: --
714: if hr_api.not_exists_in_dt_hr_lookups
715: (p_effective_date => p_effective_date
716: ,p_validation_start_date => p_validation_start_date
717: ,p_validation_end_date => p_validation_end_date
718: ,p_lookup_type => 'US_EIC_FILING_STATUS'
771: --
772: -- If the value is being updated or inserted...
773: --
774: if ((p_emp_fed_tax_rule_id is not null
775: and nvl(p_fit_additional_tax,hr_api.g_number)
776: <> nvl(pay_fed_shd.g_old_rec.fit_additional_tax,hr_api.g_number))
777: or
778: (p_emp_fed_tax_rule_id is null)) then
779: --
772: -- If the value is being updated or inserted...
773: --
774: if ((p_emp_fed_tax_rule_id is not null
775: and nvl(p_fit_additional_tax,hr_api.g_number)
776: <> nvl(pay_fed_shd.g_old_rec.fit_additional_tax,hr_api.g_number))
777: or
778: (p_emp_fed_tax_rule_id is null)) then
779: --
780: -- Validate only if attribute is not null
837: --
838: -- If the value is being updated or inserted...
839: --
840: if ((p_emp_fed_tax_rule_id is not null
841: and nvl(p_supp_tax_override_rate,hr_api.g_number)
842: <> nvl(pay_fed_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))
843: or
844: (p_emp_fed_tax_rule_id is null)) then
845: --
838: -- If the value is being updated or inserted...
839: --
840: if ((p_emp_fed_tax_rule_id is not null
841: and nvl(p_supp_tax_override_rate,hr_api.g_number)
842: <> nvl(pay_fed_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))
843: or
844: (p_emp_fed_tax_rule_id is null)) then
845: --
846: -- Validate only if attribute is not null
936: hr_utility.set_location('Entering:'|| l_proc, 1);
937: --
938: -- Check mandatory parameters have been set
939: --
940: hr_api.mandatory_arg_error
941: (p_api_name => l_proc
942: ,p_argument => 'effective_date'
943: ,p_argument_value => p_effective_date
944: );
942: ,p_argument => 'effective_date'
943: ,p_argument_value => p_effective_date
944: );
945: --
946: hr_api.mandatory_arg_error
947: (p_api_name => l_proc
948: ,p_argument => 'datetrack_mode'
949: ,p_argument_value => p_datetrack_mode
950: );
960: --
961: --
962: if p_datetrack_mode in('ZAP', 'DELETE') then
963: --
964: if p_datetrack_mode = hr_api.g_zap then
965: l_effective_date := trunc(hr_api.g_sot);
966: else
967: l_effective_date := trunc(p_effective_date);
968: end if;
961: --
962: if p_datetrack_mode in('ZAP', 'DELETE') then
963: --
964: if p_datetrack_mode = hr_api.g_zap then
965: l_effective_date := trunc(hr_api.g_sot);
966: else
967: l_effective_date := trunc(p_effective_date);
968: end if;
969: --
1060: hr_utility.set_message_token('STEP', '20');
1061: end if;
1062: hr_utility.set_location(l_proc, 30);
1063: --
1064: if (nvl(p_rec.assignment_id, hr_api.g_number) <>
1065: pay_fed_shd.g_old_rec.assignment_id)then
1066: l_argument := 'assignment_id';
1067: raise l_error;
1068: end if;
1067: raise l_error;
1068: end if;
1069: hr_utility.set_location(l_proc, 40);
1070: --
1071: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1072: pay_fed_shd.g_old_rec.business_group_id)then
1073: l_argument := 'business_group_id';
1074: raise l_error;
1075: end if;
1075: end if;
1076: hr_utility.set_location(l_proc, 50);
1077: exception
1078: when l_error then
1079: hr_api.argument_changed_error
1080: (p_api_name => l_proc
1081: ,p_argument => l_argument
1082: );
1083: when others then
1128: hr_utility.set_location('Entering:'||l_proc, 5);
1129: --
1130: -- Ensure that the p_datetrack_mode argument is not null
1131: --
1132: hr_api.mandatory_arg_error
1133: (p_api_name => l_proc,
1134: p_argument => 'datetrack_mode',
1135: p_argument_value => p_datetrack_mode);
1136: --
1140: --
1141: --
1142: -- Ensure the arguments are not null
1143: --
1144: hr_api.mandatory_arg_error
1145: (p_api_name => l_proc,
1146: p_argument => 'validation_start_date',
1147: p_argument_value => p_validation_start_date);
1148: --
1145: (p_api_name => l_proc,
1146: p_argument => 'validation_start_date',
1147: p_argument_value => p_validation_start_date);
1148: --
1149: hr_api.mandatory_arg_error
1150: (p_api_name => l_proc,
1151: p_argument => 'validation_end_date',
1152: p_argument_value => p_validation_end_date);
1153: --
1225: hr_utility.set_location('Entering:'||l_proc, 5);
1226: --
1227: -- Ensure that the p_datetrack_mode argument is not null
1228: --
1229: hr_api.mandatory_arg_error
1230: (p_api_name => l_proc,
1231: p_argument => 'datetrack_mode',
1232: p_argument_value => p_datetrack_mode);
1233: --
1239: --
1240: --
1241: -- Ensure the arguments are not null
1242: --
1243: hr_api.mandatory_arg_error
1244: (p_api_name => l_proc,
1245: p_argument => 'validation_start_date',
1246: p_argument_value => p_validation_start_date);
1247: --
1244: (p_api_name => l_proc,
1245: p_argument => 'validation_start_date',
1246: p_argument_value => p_validation_start_date);
1247: --
1248: hr_api.mandatory_arg_error
1249: (p_api_name => l_proc,
1250: p_argument => 'validation_end_date',
1251: p_argument_value => p_validation_end_date);
1252: --
1249: (p_api_name => l_proc,
1250: p_argument => 'validation_end_date',
1251: p_argument_value => p_validation_end_date);
1252: --
1253: hr_api.mandatory_arg_error
1254: (p_api_name => l_proc,
1255: p_argument => 'emp_fed_tax_rule_id',
1256: p_argument_value => p_emp_fed_tax_rule_id);
1257: --
1522: hr_utility.set_location('Entering:'|| l_proc, 10);
1523: --
1524: -- Ensure that all the mandatory parameter are not null
1525: --
1526: hr_api.mandatory_arg_error(p_api_name => l_proc,
1527: p_argument => 'emp_fed_tax_rule_id',
1528: p_argument_value => p_emp_fed_tax_rule_id);
1529: --
1530: if nvl(g_fed_tax_rule_id, hr_api.g_number) = p_emp_fed_tax_rule_id then
1526: hr_api.mandatory_arg_error(p_api_name => l_proc,
1527: p_argument => 'emp_fed_tax_rule_id',
1528: p_argument_value => p_emp_fed_tax_rule_id);
1529: --
1530: if nvl(g_fed_tax_rule_id, hr_api.g_number) = p_emp_fed_tax_rule_id then
1531: --
1532: -- The legislation code has already been found with a previous
1533: -- call to this function. Just return the value in the global
1534: -- variable.