eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FED_BUS dependencies on HR_API

Line 55: and nvl(p_sui_state_code,hr_api.g_varchar2)

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

Line 156: hr_api.mandatory_arg_error

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: );

Line 254: hr_api.mandatory_arg_error

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: );

Line 263: and nvl(p_sui_jurisdiction_code,hr_api.g_varchar2)

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

Line 264: <> nvl(pay_fed_shd.g_old_rec.sui_jurisdiction_code,hr_api.g_varchar2)

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: --

Line 336: and nvl(p_additional_wa_amount,hr_api.g_number) <>

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

Line 407: hr_api.mandatory_arg_error

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: );

Line 416: and nvl(p_filing_status_code,hr_api.g_varchar2)

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

Line 429: if hr_api.not_exists_in_dt_hr_lookups

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'

Line 491: and nvl(p_fit_override_amount,hr_api.g_number)

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

Line 492: <> nvl(pay_fed_shd.g_old_rec.fit_override_amount,hr_api.g_number))

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: --

Line 557: and nvl(p_fit_override_rate,hr_api.g_number)

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

Line 558: <> nvl(pay_fed_shd.g_old_rec.fit_override_rate,hr_api.g_number))

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: --

Line 623: and nvl(p_withholding_allowances,hr_api.g_number)

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

Line 624: <> nvl(pay_fed_shd.g_old_rec.withholding_allowances,hr_api.g_number))

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: --

Line 694: hr_api.mandatory_arg_error

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: );

Line 703: and nvl(p_eic_filing_status_code,hr_api.g_varchar2)

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: --

Line 704: <> nvl(pay_fed_shd.g_old_rec.eic_filing_status_code,hr_api.g_varchar2))

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

Line 714: if hr_api.not_exists_in_dt_hr_lookups

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'

Line 775: and nvl(p_fit_additional_tax,hr_api.g_number)

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: --

Line 776: <> nvl(pay_fed_shd.g_old_rec.fit_additional_tax,hr_api.g_number))

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

Line 841: and nvl(p_supp_tax_override_rate,hr_api.g_number)

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: --

Line 842: <> nvl(pay_fed_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))

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

Line 940: hr_api.mandatory_arg_error

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: );

Line 946: hr_api.mandatory_arg_error

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: );

Line 964: if p_datetrack_mode = hr_api.g_zap then

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;

Line 965: l_effective_date := trunc(hr_api.g_sot);

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: --

Line 1064: if (nvl(p_rec.assignment_id, hr_api.g_number) <>

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;

Line 1071: if (nvl(p_rec.business_group_id, hr_api.g_number) <>

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;

Line 1079: hr_api.argument_changed_error

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

Line 1132: hr_api.mandatory_arg_error

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: --

Line 1144: hr_api.mandatory_arg_error

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: --

Line 1149: 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: --
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: --

Line 1229: hr_api.mandatory_arg_error

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: --

Line 1243: hr_api.mandatory_arg_error

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: --

Line 1248: 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: --
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: --

Line 1253: 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: --
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: --

Line 1526: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

Line 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.