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_STA_BUS dependencies on HR_API

Line 165: hr_api.mandatory_arg_error

161: hr_utility.set_message(801, 'PAY_72808_STA_BG_NOT_NULL');
162: hr_utility.raise_error;
163: end if;
164: --
165: hr_api.mandatory_arg_error
166: (p_api_name => l_proc
167: ,p_argument => 'effective_date'
168: ,p_argument_value => p_effective_date
169: );

Line 274: hr_api.mandatory_arg_error

270: Begin
271: --
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: hr_api.mandatory_arg_error
275: (p_api_name => l_proc
276: ,p_argument => 'effective_date'
277: ,p_argument_value => p_effective_date
278: );

Line 288: and nvl(p_sit_optional_calc_ind,hr_api.g_varchar2)

284: --
285: -- If the value is being inserted or updated...
286: --
287: if (l_api_updating
288: and nvl(p_sit_optional_calc_ind,hr_api.g_varchar2)
289: <> pay_sta_shd.g_old_rec.sit_optional_calc_ind
290: or not l_api_updating) then
291: --
292: -- Validate only if attribute is not null

Line 312: if hr_api.not_exists_in_hr_lookups

308: pay_sta_shd.constraint_error('PAY_US_EMP_STATE_TAX_RULES_FK1');
309:
310: end If;
311: close csr_get_state_abbrev;
312: if hr_api.not_exists_in_hr_lookups
313: (p_lookup_type => 'US_SIT_OPT_CALC_' || lv_state_abbrev,
314: p_lookup_code => p_sit_optional_calc_ind,
315: p_effective_date => p_effective_date) then
316: --

Line 380: hr_api.mandatory_arg_error

376: hr_utility.set_location('Entering:'||l_proc,5);
377: --
378: -- Check that the mandatory parameters have been set
379: --
380: hr_api.mandatory_arg_error
381: (p_api_name => l_proc
382: ,p_argument => 'state_code'
383: ,p_argument_value => p_state_code
384: );

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

455: --
456: -- If the value is being inserted or updated...
457: --
458: if (p_emp_state_tax_rule_id is not null
459: and nvl(p_additional_wa_amount,hr_api.g_number) <>
460: pay_sta_shd.g_old_rec.additional_wa_amount)
461: or (p_emp_state_tax_rule_id is null) then
462: --
463: -- Check that the mandatory parameters have been set

Line 550: hr_api.mandatory_arg_error

546:
547: --
548: -- Check that the mandatory parameters have been set
549: --
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc
552: ,p_argument => 'effective_date'
553: ,p_argument_value => p_effective_date
554: );

Line 556: hr_api.mandatory_arg_error

552: ,p_argument => 'effective_date'
553: ,p_argument_value => p_effective_date
554: );
555: --
556: hr_api.mandatory_arg_error
557: (p_api_name => l_proc
558: ,p_argument => 'state_code'
559: ,p_argument_value => p_state_code
560: );

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

567: --
568: -- If the value is being inserted or updated...
569: --
570: if (p_emp_state_tax_rule_id is not null
571: and nvl(p_filing_status_code,hr_api.g_varchar2)
572: <> pay_sta_shd.g_old_rec.filing_status_code)
573: or (p_emp_state_tax_rule_id is null) then
574: --
575: -- Check that the mandatory parameters have been set

Line 584: if hr_api.not_exists_in_dt_hr_lookups

580: end if;
581: --
582: -- check if filing_status_code value exists in hr_lookups table
583: --
584: if hr_api.not_exists_in_dt_hr_lookups
585: (p_effective_date => p_effective_date
586: ,p_validation_start_date => p_validation_start_date
587: ,p_validation_end_date => p_validation_end_date
588: ,p_lookup_type => l_fs_lookup_type

Line 644: and nvl(p_sit_additional_tax,hr_api.g_number)

640: --
641: -- If the value is being inserted or updated...
642: --
643: if (p_emp_state_tax_rule_id is not null
644: and nvl(p_sit_additional_tax,hr_api.g_number)
645: <> nvl(pay_sta_shd.g_old_rec.sit_additional_tax,hr_api.g_number))
646: or (p_emp_state_tax_rule_id is null) then
647: --
648: -- Check that the mandatory parameters have been set

Line 645: <> nvl(pay_sta_shd.g_old_rec.sit_additional_tax,hr_api.g_number))

641: -- If the value is being inserted or updated...
642: --
643: if (p_emp_state_tax_rule_id is not null
644: and nvl(p_sit_additional_tax,hr_api.g_number)
645: <> nvl(pay_sta_shd.g_old_rec.sit_additional_tax,hr_api.g_number))
646: or (p_emp_state_tax_rule_id is null) then
647: --
648: -- Check that the mandatory parameters have been set
649: --

Line 710: and nvl(p_sit_override_amount,hr_api.g_number)

706: --
707: -- If the value is being inserted or updated...
708: --
709: if (p_emp_state_tax_rule_id is not null
710: and nvl(p_sit_override_amount,hr_api.g_number)
711: <> nvl(pay_sta_shd.g_old_rec.sit_override_amount,hr_api.g_number))
712: or (p_emp_state_tax_rule_id is null) then
713: --
714: -- Check that the mandatory parameters have been set

Line 711: <> nvl(pay_sta_shd.g_old_rec.sit_override_amount,hr_api.g_number))

707: -- If the value is being inserted or updated...
708: --
709: if (p_emp_state_tax_rule_id is not null
710: and nvl(p_sit_override_amount,hr_api.g_number)
711: <> nvl(pay_sta_shd.g_old_rec.sit_override_amount,hr_api.g_number))
712: or (p_emp_state_tax_rule_id is null) then
713: --
714: -- Check that the mandatory parameters have been set
715: --

Line 776: and nvl(p_sit_override_rate,hr_api.g_number)

772: --
773: -- If the value is being inserted or updated...
774: --
775: if (p_emp_state_tax_rule_id is not null
776: and nvl(p_sit_override_rate,hr_api.g_number)
777: <> nvl(pay_sta_shd.g_old_rec.sit_override_rate,hr_api.g_number))
778: or (p_emp_state_tax_rule_id is null) then
779: --
780: -- Check that the mandatory parameters have been set

Line 777: <> nvl(pay_sta_shd.g_old_rec.sit_override_rate,hr_api.g_number))

773: -- If the value is being inserted or updated...
774: --
775: if (p_emp_state_tax_rule_id is not null
776: and nvl(p_sit_override_rate,hr_api.g_number)
777: <> nvl(pay_sta_shd.g_old_rec.sit_override_rate,hr_api.g_number))
778: or (p_emp_state_tax_rule_id is null) then
779: --
780: -- Check that the mandatory parameters have been set
781: --

Line 842: and nvl(p_remainder_percent,hr_api.g_number)

838: --
839: -- If the value is being inserted or updated...
840: --
841: if (p_emp_state_tax_rule_id is not null
842: and nvl(p_remainder_percent,hr_api.g_number)
843: <> nvl(pay_sta_shd.g_old_rec.remainder_percent,hr_api.g_number))
844: or (p_emp_state_tax_rule_id is null) then
845: --
846: -- Check that the mandatory parameters have been set

Line 843: <> nvl(pay_sta_shd.g_old_rec.remainder_percent,hr_api.g_number))

839: -- If the value is being inserted or updated...
840: --
841: if (p_emp_state_tax_rule_id is not null
842: and nvl(p_remainder_percent,hr_api.g_number)
843: <> nvl(pay_sta_shd.g_old_rec.remainder_percent,hr_api.g_number))
844: or (p_emp_state_tax_rule_id is null) then
845: --
846: -- Check that the mandatory parameters have been set
847: --

Line 907: and nvl(p_secondary_wa,hr_api.g_number)

903: --
904: -- If the value is being inserted or updated...
905: --
906: if (p_emp_state_tax_rule_id is not null
907: and nvl(p_secondary_wa,hr_api.g_number)
908: <> nvl(pay_sta_shd.g_old_rec.secondary_wa,hr_api.g_number))
909: or (p_emp_state_tax_rule_id is null) then
910: --
911: -- Check that the mandatory parameters have been set

Line 908: <> nvl(pay_sta_shd.g_old_rec.secondary_wa,hr_api.g_number))

904: -- If the value is being inserted or updated...
905: --
906: if (p_emp_state_tax_rule_id is not null
907: and nvl(p_secondary_wa,hr_api.g_number)
908: <> nvl(pay_sta_shd.g_old_rec.secondary_wa,hr_api.g_number))
909: or (p_emp_state_tax_rule_id is null) then
910: --
911: -- Check that the mandatory parameters have been set
912: --

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

969: --
970: -- If the value is being inserted or updated...
971: --
972: if (p_emp_state_tax_rule_id is not null
973: and nvl(p_withholding_allowances,hr_api.g_number)
974: <> nvl(pay_sta_shd.g_old_rec.withholding_allowances,hr_api.g_number))
975: or (p_emp_state_tax_rule_id is null) then
976: --
977: -- Check that the mandatory parameters have been set

Line 974: <> nvl(pay_sta_shd.g_old_rec.withholding_allowances,hr_api.g_number))

970: -- If the value is being inserted or updated...
971: --
972: if (p_emp_state_tax_rule_id is not null
973: and nvl(p_withholding_allowances,hr_api.g_number)
974: <> nvl(pay_sta_shd.g_old_rec.withholding_allowances,hr_api.g_number))
975: or (p_emp_state_tax_rule_id is null) then
976: --
977: -- Check that the mandatory parameters have been set
978: --

Line 1039: and nvl(p_sui_wage_base_override_amo,hr_api.g_number) <>

1035: --
1036: -- If the value is being inserted or updated...
1037: --
1038: if ((p_emp_state_tax_rule_id is not null
1039: and nvl(p_sui_wage_base_override_amo,hr_api.g_number) <>
1040: nvl(pay_sta_shd.g_old_rec.sui_wage_base_override_amount,hr_api.g_number))
1041: or
1042: (p_emp_state_tax_rule_id is null)) then
1043: --

Line 1040: nvl(pay_sta_shd.g_old_rec.sui_wage_base_override_amount,hr_api.g_number))

1036: -- If the value is being inserted or updated...
1037: --
1038: if ((p_emp_state_tax_rule_id is not null
1039: and nvl(p_sui_wage_base_override_amo,hr_api.g_number) <>
1040: nvl(pay_sta_shd.g_old_rec.sui_wage_base_override_amount,hr_api.g_number))
1041: or
1042: (p_emp_state_tax_rule_id is null)) then
1043: --
1044: -- Validate only if attribute is not null

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

1101: --
1102: -- If the value is being inserted or updated...
1103: --
1104: if ((p_emp_state_tax_rule_id is not null
1105: and nvl(p_supp_tax_override_rate,hr_api.g_number)
1106: <> nvl(pay_sta_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))
1107: or
1108: (p_emp_state_tax_rule_id is null)) then
1109: --

Line 1106: <> nvl(pay_sta_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))

1102: -- If the value is being inserted or updated...
1103: --
1104: if ((p_emp_state_tax_rule_id is not null
1105: and nvl(p_supp_tax_override_rate,hr_api.g_number)
1106: <> nvl(pay_sta_shd.g_old_rec.supp_tax_override_rate,hr_api.g_number))
1107: or
1108: (p_emp_state_tax_rule_id is null)) then
1109: --
1110: -- Validate only if attribute is not null

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

1185: hr_utility.set_message_token('STEP', '20');
1186: end if;
1187: hr_utility.set_location(l_proc, 30);
1188: --
1189: if (nvl(p_rec.assignment_id, hr_api.g_number) <>
1190: pay_sta_shd.g_old_rec.assignment_id) then
1191: l_argument := 'assignment_id';
1192: raise l_error;
1193: end if;

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

1192: raise l_error;
1193: end if;
1194: hr_utility.set_location(l_proc, 40);
1195: --
1196: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1197: pay_sta_shd.g_old_rec.business_group_id) then
1198: l_argument := 'business_group_id';
1199: raise l_error;
1200: end if;

Line 1203: if nvl(p_rec.state_code, hr_api.g_varchar2) <>

1199: raise l_error;
1200: end if;
1201: hr_utility.set_location(l_proc, 50);
1202: --
1203: if nvl(p_rec.state_code, hr_api.g_varchar2) <>
1204: pay_sta_shd.g_old_rec.state_code then
1205: l_argument := 'state_code';
1206: raise l_error;
1207: end if;

Line 1210: if nvl(p_rec.jurisdiction_code, hr_api.g_varchar2) <>

1206: raise l_error;
1207: end if;
1208: hr_utility.set_location(l_proc, 60);
1209: --
1210: if nvl(p_rec.jurisdiction_code, hr_api.g_varchar2) <>
1211: pay_sta_shd.g_old_rec.jurisdiction_code then
1212: l_argument := 'jurisdiction_code';
1213: raise l_error;
1214: end if;

Line 1218: hr_api.argument_changed_error

1214: end if;
1215: hr_utility.set_location(l_proc, 70);
1216: exception
1217: when l_error then
1218: hr_api.argument_changed_error
1219: (p_api_name => l_proc
1220: ,p_argument => l_argument
1221: );
1222: when others then

Line 1308: and nvl(pad.date_to, hr_api.g_eot) > p_csr_tmp_date

1304: per_addresses pad
1305: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1306: and pad.person_id = asg.person_id
1307: and pad.primary_flag = 'Y'
1308: and nvl(pad.date_to, hr_api.g_eot) > p_csr_tmp_date
1309: and exists (select null
1310: from pay_us_states pus
1311: where pus.state_abbrev = pad.region_2
1312: and pus.state_code = pay_sta_shd.g_old_rec.state_code);

Line 1329: hr_api.mandatory_arg_error

1325: hr_utility.set_location('Entering:'|| l_proc, 1);
1326: --
1327: -- Check mandatory parameters have been set
1328: --
1329: hr_api.mandatory_arg_error
1330: (p_api_name => l_proc
1331: ,p_argument => 'effective_date'
1332: ,p_argument_value => p_effective_date
1333: );

Line 1335: hr_api.mandatory_arg_error

1331: ,p_argument => 'effective_date'
1332: ,p_argument_value => p_effective_date
1333: );
1334: --
1335: hr_api.mandatory_arg_error
1336: (p_api_name => l_proc
1337: ,p_argument => 'datetrack_mode'
1338: ,p_argument_value => p_datetrack_mode
1339: );

Line 1349: If p_datetrack_mode in(hr_api.g_zap, hr_api.g_delete) then

1345: if nvl(p_delete_routine,'X') = 'ASSIGNMENT' then
1346: --
1347: -- Perform validation for valid datetrack delete modes.
1348: --
1349: If p_datetrack_mode in(hr_api.g_zap, hr_api.g_delete) then
1350: --
1351: hr_utility.set_location(l_proc,20);
1352: --
1353: if p_datetrack_mode = hr_api.g_zap then

Line 1353: if p_datetrack_mode = hr_api.g_zap then

1349: If p_datetrack_mode in(hr_api.g_zap, hr_api.g_delete) then
1350: --
1351: hr_utility.set_location(l_proc,20);
1352: --
1353: if p_datetrack_mode = hr_api.g_zap then
1354: l_effective_date := trunc(hr_api.g_sot);
1355: else
1356: l_effective_date := trunc(p_effective_date);
1357: end if;

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

1350: --
1351: hr_utility.set_location(l_proc,20);
1352: --
1353: if p_datetrack_mode = hr_api.g_zap then
1354: l_effective_date := trunc(hr_api.g_sot);
1355: else
1356: l_effective_date := trunc(p_effective_date);
1357: end if;
1358: --

Line 1375: if p_datetrack_mode = hr_api.g_zap then

1371: else -- p_delete_routine <> 'ASSIGNMENT'
1372: --
1373: hr_utility.set_location(l_proc,20);
1374: --
1375: if p_datetrack_mode = hr_api.g_zap then
1376: --
1377: l_effective_date := trunc(hr_api.g_sot);
1378: --
1379: -- Check if payroll has been run for this state

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

1373: hr_utility.set_location(l_proc,20);
1374: --
1375: if p_datetrack_mode = hr_api.g_zap then
1376: --
1377: l_effective_date := trunc(hr_api.g_sot);
1378: --
1379: -- Check if payroll has been run for this state
1380: --
1381: open csr_check_payroll(l_effective_date);

Line 1489: hr_api.mandatory_arg_error

1485: hr_utility.set_location('Entering:'||l_proc, 5);
1486: --
1487: -- Ensure that the p_datetrack_mode argument is not null
1488: --
1489: hr_api.mandatory_arg_error
1490: (p_api_name => l_proc,
1491: p_argument => 'datetrack_mode',
1492: p_argument_value => p_datetrack_mode);
1493: --

Line 1501: hr_api.mandatory_arg_error

1497: --
1498: --
1499: -- Ensure the arguments are not null
1500: --
1501: hr_api.mandatory_arg_error
1502: (p_api_name => l_proc,
1503: p_argument => 'validation_start_date',
1504: p_argument_value => p_validation_start_date);
1505: --

Line 1506: hr_api.mandatory_arg_error

1502: (p_api_name => l_proc,
1503: p_argument => 'validation_start_date',
1504: p_argument_value => p_validation_start_date);
1505: --
1506: hr_api.mandatory_arg_error
1507: (p_api_name => l_proc,
1508: p_argument => 'validation_end_date',
1509: p_argument_value => p_validation_end_date);
1510: --

Line 1586: hr_api.mandatory_arg_error

1582: hr_utility.set_location('Entering:'||l_proc, 5);
1583: --
1584: -- Ensure that the p_datetrack_mode argument is not null
1585: --
1586: hr_api.mandatory_arg_error
1587: (p_api_name => l_proc,
1588: p_argument => 'datetrack_mode',
1589: p_argument_value => p_datetrack_mode);
1590: --

Line 1600: hr_api.mandatory_arg_error

1596: --
1597: --
1598: -- Ensure the arguments are not null
1599: --
1600: hr_api.mandatory_arg_error
1601: (p_api_name => l_proc,
1602: p_argument => 'validation_start_date',
1603: p_argument_value => p_validation_start_date);
1604: --

Line 1605: hr_api.mandatory_arg_error

1601: (p_api_name => l_proc,
1602: p_argument => 'validation_start_date',
1603: p_argument_value => p_validation_start_date);
1604: --
1605: hr_api.mandatory_arg_error
1606: (p_api_name => l_proc,
1607: p_argument => 'validation_end_date',
1608: p_argument_value => p_validation_end_date);
1609: --

Line 1610: hr_api.mandatory_arg_error

1606: (p_api_name => l_proc,
1607: p_argument => 'validation_end_date',
1608: p_argument_value => p_validation_end_date);
1609: --
1610: hr_api.mandatory_arg_error
1611: (p_api_name => l_proc,
1612: p_argument => 'emp_state_tax_rule_id',
1613: p_argument_value => p_emp_state_tax_rule_id);
1614: --

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

1893: hr_utility.set_location('Entering:'|| l_proc, 10);
1894: --
1895: -- Ensure that all the mandatory parameter are not null
1896: --
1897: hr_api.mandatory_arg_error(p_api_name => l_proc,
1898: p_argument => 'emp_state_tax_rule_id',
1899: p_argument_value => p_emp_state_tax_rule_id);
1900: --
1901: if nvl(g_sta_tax_rule_id, hr_api.g_number) = p_emp_state_tax_rule_id then

Line 1901: if nvl(g_sta_tax_rule_id, hr_api.g_number) = p_emp_state_tax_rule_id then

1897: hr_api.mandatory_arg_error(p_api_name => l_proc,
1898: p_argument => 'emp_state_tax_rule_id',
1899: p_argument_value => p_emp_state_tax_rule_id);
1900: --
1901: if nvl(g_sta_tax_rule_id, hr_api.g_number) = p_emp_state_tax_rule_id then
1902: --
1903: -- The legislation code has already been found with a previous
1904: -- call to this function. Just return the value in the global
1905: -- variable.