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 713: and nvl(p_sit_override_amount,hr_api.g_number)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1221: hr_api.argument_changed_error

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

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

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

Line 1332: hr_api.mandatory_arg_error

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

Line 1338: hr_api.mandatory_arg_error

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

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

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

Line 1356: if p_datetrack_mode = hr_api.g_zap then

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

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

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

Line 1378: if p_datetrack_mode = hr_api.g_zap then

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

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

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

Line 1492: hr_api.mandatory_arg_error

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

Line 1504: hr_api.mandatory_arg_error

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

Line 1509: hr_api.mandatory_arg_error

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

Line 1589: hr_api.mandatory_arg_error

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

Line 1603: hr_api.mandatory_arg_error

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

Line 1608: hr_api.mandatory_arg_error

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

Line 1613: hr_api.mandatory_arg_error

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

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

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

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

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