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

Line 95: hr_api.mandatory_arg_error

91: hr_utility.set_message(801,'PAY_72760_CNT_ASG_NOT_NULL');
92: hr_utility.raise_error;
93: end if;
94: --
95: hr_api.mandatory_arg_error
96: (p_api_name => l_proc
97: ,p_argument => 'effective_date'
98: ,p_argument_value => p_effective_date
99: );

Line 254: hr_api.mandatory_arg_error

250: hr_utility.set_location('Entering: '|| l_proc, 5);
251: --
252: -- Check to see if mandatory parameters have been set.
253: --
254: hr_api.mandatory_arg_error
255: (p_api_name => l_proc
256: ,p_argument => 'state_code'
257: ,p_argument_value => p_state_code
258: );

Line 329: hr_api.mandatory_arg_error

325: hr_utility.set_message(801,'PAY_72834_CNT_JD_NOT_NULL');
326: hr_utility.raise_error;
327: end if;
328: --
329: hr_api.mandatory_arg_error
330: (p_api_name => l_proc
331: ,p_argument => 'state_code'
332: ,p_argument_value => p_state_code
333: );

Line 335: hr_api.mandatory_arg_error

331: ,p_argument => 'state_code'
332: ,p_argument_value => p_state_code
333: );
334: --
335: hr_api.mandatory_arg_error
336: (p_api_name => l_proc
337: ,p_argument => 'county_code'
338: ,p_argument_value => p_county_code
339: );

Line 400: and nvl(p_additional_wa_rate,hr_api.g_number) <>

396: --
397: -- If value is being inserted or updated ...
398: --
399: if (p_emp_county_tax_rule_id is not null
400: and nvl(p_additional_wa_rate,hr_api.g_number) <>
401: nvl(pay_cnt_shd.g_old_rec.additional_wa_rate, hr_api.g_number))
402: or (p_emp_county_tax_rule_id is null) then
403: --
404: -- Check that additional_wa_rate is not null.

Line 401: nvl(pay_cnt_shd.g_old_rec.additional_wa_rate, hr_api.g_number))

397: -- If value is being inserted or updated ...
398: --
399: if (p_emp_county_tax_rule_id is not null
400: and nvl(p_additional_wa_rate,hr_api.g_number) <>
401: nvl(pay_cnt_shd.g_old_rec.additional_wa_rate, hr_api.g_number))
402: or (p_emp_county_tax_rule_id is null) then
403: --
404: -- Check that additional_wa_rate is not null.
405: --

Line 478: hr_api.mandatory_arg_error

474: begin
475: --
476: hr_utility.set_location('Entering: '|| l_proc, 5);
477: --
478: hr_api.mandatory_arg_error
479: (p_api_name => l_proc
480: ,p_argument => 'effective_date'
481: ,p_argument_value => p_effective_date
482: );

Line 486: hr_api.mandatory_arg_error

482: );
483: --
484: hr_utility.set_location(l_proc, 10);
485: --
486: hr_api.mandatory_arg_error
487: (p_api_name => l_proc
488: ,p_argument => 'state_code'
489: ,p_argument_value => p_state_code
490: );

Line 502: and nvl(p_filing_status_code, hr_api.g_varchar2) <>

498: --
499: -- If the value is being inserted or updated...
500: --
501: if (l_api_updating
502: and nvl(p_filing_status_code, hr_api.g_varchar2) <>
503: nvl(pay_sta_shd.g_old_rec.filing_status_code,hr_api.g_varchar2))
504: or (not l_api_updating) then
505: --
506: -- Check that filing_status_code is not null.

Line 503: nvl(pay_sta_shd.g_old_rec.filing_status_code,hr_api.g_varchar2))

499: -- If the value is being inserted or updated...
500: --
501: if (l_api_updating
502: and nvl(p_filing_status_code, hr_api.g_varchar2) <>
503: nvl(pay_sta_shd.g_old_rec.filing_status_code,hr_api.g_varchar2))
504: or (not l_api_updating) then
505: --
506: -- Check that filing_status_code is not null.
507: --

Line 515: if hr_api.not_exists_in_dt_hr_lookups

511: else
512: --
513: -- Check that filing_status_code is a valid value.
514: --
515: if hr_api.not_exists_in_dt_hr_lookups
516: (p_effective_date => p_effective_date
517: ,p_validation_start_date => p_validation_start_date
518: ,p_validation_end_date => p_validation_end_date
519: ,p_lookup_type => 'US_LIT_FILING_STATUS'

Line 577: and nvl(p_lit_additional_tax,hr_api.g_number) <>

573: --
574: -- If value is being inserted or updated ...
575: --
576: if (p_emp_county_tax_rule_id is not null
577: and nvl(p_lit_additional_tax,hr_api.g_number) <>
578: nvl(pay_cnt_shd.g_old_rec.lit_additional_tax, hr_api.g_number))
579: or (p_emp_county_tax_rule_id is null) then
580: --
581: -- Check that lit_additional_tax is not null.

Line 578: nvl(pay_cnt_shd.g_old_rec.lit_additional_tax, hr_api.g_number))

574: -- If value is being inserted or updated ...
575: --
576: if (p_emp_county_tax_rule_id is not null
577: and nvl(p_lit_additional_tax,hr_api.g_number) <>
578: nvl(pay_cnt_shd.g_old_rec.lit_additional_tax, hr_api.g_number))
579: or (p_emp_county_tax_rule_id is null) then
580: --
581: -- Check that lit_additional_tax is not null.
582: --

Line 643: and nvl(p_lit_override_amount,hr_api.g_number) <>

639: --
640: -- If value is being inserted or updated ...
641: --
642: if (p_emp_county_tax_rule_id is not null
643: and nvl(p_lit_override_amount,hr_api.g_number) <>
644: nvl(pay_cnt_shd.g_old_rec.lit_override_amount,hr_api.g_number))
645: or (p_emp_county_tax_rule_id is null) then
646: --
647: -- Check that lit_override_amount is not null.

Line 644: nvl(pay_cnt_shd.g_old_rec.lit_override_amount,hr_api.g_number))

640: -- If value is being inserted or updated ...
641: --
642: if (p_emp_county_tax_rule_id is not null
643: and nvl(p_lit_override_amount,hr_api.g_number) <>
644: nvl(pay_cnt_shd.g_old_rec.lit_override_amount,hr_api.g_number))
645: or (p_emp_county_tax_rule_id is null) then
646: --
647: -- Check that lit_override_amount is not null.
648: --

Line 711: and nvl(p_lit_override_rate,hr_api.g_number) <>

707: --
708: -- If value is being inserted or updated ...
709: --
710: if (p_emp_county_tax_rule_id is not null
711: and nvl(p_lit_override_rate,hr_api.g_number) <>
712: nvl(pay_cnt_shd.g_old_rec.lit_override_rate,hr_api.g_number))
713: or (p_emp_county_tax_rule_id is null) then
714: --
715: -- Check that lit_override_rate is not null.

Line 712: nvl(pay_cnt_shd.g_old_rec.lit_override_rate,hr_api.g_number))

708: -- If value is being inserted or updated ...
709: --
710: if (p_emp_county_tax_rule_id is not null
711: and nvl(p_lit_override_rate,hr_api.g_number) <>
712: nvl(pay_cnt_shd.g_old_rec.lit_override_rate,hr_api.g_number))
713: or (p_emp_county_tax_rule_id is null) then
714: --
715: -- Check that lit_override_rate is not null.
716: --

Line 779: and nvl(p_withholding_allowances,hr_api.g_number) <>

775: --
776: -- If value is being inserted or updated ...
777: --
778: if (p_emp_county_tax_rule_id is not null
779: and nvl(p_withholding_allowances,hr_api.g_number) <>
780: nvl(pay_cnt_shd.g_old_rec.withholding_allowances,hr_api.g_number))
781: or (p_emp_county_tax_rule_id is null) then
782: --
783: -- Check that withholding_allowances is not null.

Line 780: nvl(pay_cnt_shd.g_old_rec.withholding_allowances,hr_api.g_number))

776: -- If value is being inserted or updated ...
777: --
778: if (p_emp_county_tax_rule_id is not null
779: and nvl(p_withholding_allowances,hr_api.g_number) <>
780: nvl(pay_cnt_shd.g_old_rec.withholding_allowances,hr_api.g_number))
781: or (p_emp_county_tax_rule_id is null) then
782: --
783: -- Check that withholding_allowances is not null.
784: --

Line 916: hr_api.mandatory_arg_error

912: begin
913: --
914: hr_utility.set_location('Entering: '|| l_proc, 5);
915: --
916: hr_api.mandatory_arg_error
917: (p_api_name => l_proc
918: ,p_argument => 'state_code'
919: ,p_argument_value => p_state_code
920: );

Line 922: hr_api.mandatory_arg_error

918: ,p_argument => 'state_code'
919: ,p_argument_value => p_state_code
920: );
921: --
922: hr_api.mandatory_arg_error
923: (p_api_name => l_proc
924: ,p_argument => 'county_code'
925: ,p_argument_value => p_county_code
926: );

Line 938: and nvl(p_school_district_code,hr_api.g_varchar2) <>

934: --
935: -- Only perform validation if the school district code value has changed
936: --
937: if (l_api_updating
938: and nvl(p_school_district_code,hr_api.g_varchar2) <>
939: nvl(pay_cnt_shd.g_old_rec.school_district_code,hr_api.g_varchar2))
940: or (not l_api_updating) then
941: --
942: -- Check school_district_code.

Line 939: nvl(pay_cnt_shd.g_old_rec.school_district_code,hr_api.g_varchar2))

935: -- Only perform validation if the school district code value has changed
936: --
937: if (l_api_updating
938: and nvl(p_school_district_code,hr_api.g_varchar2) <>
939: nvl(pay_cnt_shd.g_old_rec.school_district_code,hr_api.g_varchar2))
940: or (not l_api_updating) then
941: --
942: -- Check school_district_code.
943: --

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

1034: hr_utility.set_message_token('STEP','20');
1035: end if;
1036: hr_utility.set_location(l_proc, 30);
1037: --
1038: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1039: nvl(pay_cnt_shd.g_old_rec.business_group_id, hr_api.g_number)) then
1040: l_argument := 'business_group_id';
1041: raise l_error;
1042: end if;

Line 1039: nvl(pay_cnt_shd.g_old_rec.business_group_id, hr_api.g_number)) then

1035: end if;
1036: hr_utility.set_location(l_proc, 30);
1037: --
1038: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1039: nvl(pay_cnt_shd.g_old_rec.business_group_id, hr_api.g_number)) then
1040: l_argument := 'business_group_id';
1041: raise l_error;
1042: end if;
1043: hr_utility.set_location(l_proc, 40);

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

1041: raise l_error;
1042: end if;
1043: hr_utility.set_location(l_proc, 40);
1044: --
1045: if (nvl(p_rec.assignment_id, hr_api.g_number) <>
1046: pay_cnt_shd.g_old_rec.assignment_id) then
1047: l_argument := 'assignment_id';
1048: raise l_error;
1049: end if;

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

1048: raise l_error;
1049: end if;
1050: hr_utility.set_location(l_proc, 50);
1051: --
1052: if (nvl(p_rec.state_code, hr_api.g_varchar2) <>
1053: pay_cnt_shd.g_old_rec.state_code) then
1054: l_argument := 'state_code';
1055: raise l_error;
1056: end if;

Line 1059: if (nvl(p_rec.county_code, hr_api.g_varchar2) <>

1055: raise l_error;
1056: end if;
1057: hr_utility.set_location(l_proc, 60);
1058: --
1059: if (nvl(p_rec.county_code, hr_api.g_varchar2) <>
1060: pay_cnt_shd.g_old_rec.county_code) then
1061: l_argument := 'county_code';
1062: raise l_error;
1063: end if;

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

1062: raise l_error;
1063: end if;
1064: hr_utility.set_location(l_proc, 70);
1065: --
1066: if (nvl(p_rec.jurisdiction_code, hr_api.g_varchar2) <>
1067: pay_cnt_shd.g_old_rec.jurisdiction_code) then
1068: l_argument := 'jurisdiction_code';
1069: raise l_error;
1070: end if;

Line 1075: hr_api.argument_changed_error

1071: hr_utility.set_location('Leaving: '||l_proc, 80);
1072: --
1073: exception
1074: when l_error then
1075: hr_api.argument_changed_error
1076: (p_api_name => l_proc,
1077: p_argument => l_argument
1078: );
1079: when others then

Line 1188: and nvl(pa.date_to, hr_api.g_eot) > p_csr_tmp_date

1184: per_addresses pa
1185: where paf.assignment_id = p_assignment_id
1186: and pa.person_id = paf.person_id
1187: and pa.primary_flag = 'Y'
1188: and nvl(pa.date_to, hr_api.g_eot) > p_csr_tmp_date
1189: and exists (select null
1190: from pay_us_states pus,
1191: pay_us_counties puco
1192: where pus.state_abbrev = pa.region_2

Line 1217: if nvl(p_delete_mode,hr_api.g_varchar2) in ('ZAP','DELETE') then

1213: -- the effective date will be removed. Check that no payroll has been run
1214: -- for this assignment, state and county after the date from which records
1215: -- are removed.
1216: --
1217: if nvl(p_delete_mode,hr_api.g_varchar2) in ('ZAP','DELETE') then
1218: hr_utility.set_location(l_proc, 10);
1219: if p_delete_mode = hr_api.g_zap then
1220: l_effective_date := trunc(hr_api.g_sot);
1221: else

Line 1219: if p_delete_mode = hr_api.g_zap then

1215: -- are removed.
1216: --
1217: if nvl(p_delete_mode,hr_api.g_varchar2) in ('ZAP','DELETE') then
1218: hr_utility.set_location(l_proc, 10);
1219: if p_delete_mode = hr_api.g_zap then
1220: l_effective_date := trunc(hr_api.g_sot);
1221: else
1222: l_effective_date := trunc(p_effective_date);
1223: end if;

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

1216: --
1217: if nvl(p_delete_mode,hr_api.g_varchar2) in ('ZAP','DELETE') then
1218: hr_utility.set_location(l_proc, 10);
1219: if p_delete_mode = hr_api.g_zap then
1220: l_effective_date := trunc(hr_api.g_sot);
1221: else
1222: l_effective_date := trunc(p_effective_date);
1223: end if;
1224: open chk_county_payroll(l_effective_date);

Line 1238: if nvl(p_delete_mode,hr_api.g_varchar2) = 'ZAP'

1234: -- If the user wants to purge this tax record, check that this county is
1235: -- not the county of a work location, or the county of a primary residence
1236: -- for the person.
1237: --
1238: if nvl(p_delete_mode,hr_api.g_varchar2) = 'ZAP'
1239: and nvl(p_delete_routine,hr_api.g_varchar2)
1240: <> 'ASSIGNMENT' then
1241: hr_utility.set_location(l_proc, 15);
1242: open chk_county_work(l_effective_date);

Line 1239: and nvl(p_delete_routine,hr_api.g_varchar2)

1235: -- not the county of a work location, or the county of a primary residence
1236: -- for the person.
1237: --
1238: if nvl(p_delete_mode,hr_api.g_varchar2) = 'ZAP'
1239: and nvl(p_delete_routine,hr_api.g_varchar2)
1240: <> 'ASSIGNMENT' then
1241: hr_utility.set_location(l_proc, 15);
1242: open chk_county_work(l_effective_date);
1243: fetch chk_county_work into l_county_work_exists;

Line 1266: if nvl(p_delete_mode,hr_api.g_varchar2) <> 'ZAP'

1262: -- If the delete action is not called from the assignment routine (called by
1263: -- user), and the mode is not ZAP, raise an error. ZAP is the only valid
1264: -- mode that can be used directly by the user.
1265: --
1266: if nvl(p_delete_mode,hr_api.g_varchar2) <> 'ZAP'
1267: and nvl(p_delete_routine,hr_api.g_varchar2)
1268: <> 'ASSIGNMENT' then
1269: hr_utility.set_message(801,'PAY_52971_TAX_ZAP_ONLY');
1270: hr_utility.raise_error;

Line 1267: and nvl(p_delete_routine,hr_api.g_varchar2)

1263: -- user), and the mode is not ZAP, raise an error. ZAP is the only valid
1264: -- mode that can be used directly by the user.
1265: --
1266: if nvl(p_delete_mode,hr_api.g_varchar2) <> 'ZAP'
1267: and nvl(p_delete_routine,hr_api.g_varchar2)
1268: <> 'ASSIGNMENT' then
1269: hr_utility.set_message(801,'PAY_52971_TAX_ZAP_ONLY');
1270: hr_utility.raise_error;
1271: end if;

Line 1333: hr_api.mandatory_arg_error

1329: hr_utility.set_location('Entering:'||l_proc, 5);
1330: --
1331: -- Ensure that the p_datetrack_mode argument is not null
1332: --
1333: hr_api.mandatory_arg_error
1334: (p_api_name => l_proc,
1335: p_argument => 'datetrack_mode',
1336: p_argument_value => p_datetrack_mode);
1337: --

Line 1345: hr_api.mandatory_arg_error

1341: --
1342: --
1343: -- Ensure the arguments are not null
1344: --
1345: hr_api.mandatory_arg_error
1346: (p_api_name => l_proc,
1347: p_argument => 'validation_start_date',
1348: p_argument_value => p_validation_start_date);
1349: --

Line 1350: hr_api.mandatory_arg_error

1346: (p_api_name => l_proc,
1347: p_argument => 'validation_start_date',
1348: p_argument_value => p_validation_start_date);
1349: --
1350: hr_api.mandatory_arg_error
1351: (p_api_name => l_proc,
1352: p_argument => 'validation_end_date',
1353: p_argument_value => p_validation_end_date);
1354: --

Line 1430: hr_api.mandatory_arg_error

1426: hr_utility.set_location('Entering:'||l_proc, 5);
1427: --
1428: -- Ensure that the p_datetrack_mode argument is not null
1429: --
1430: hr_api.mandatory_arg_error
1431: (p_api_name => l_proc,
1432: p_argument => 'datetrack_mode',
1433: p_argument_value => p_datetrack_mode);
1434: --

Line 1444: hr_api.mandatory_arg_error

1440: --
1441: --
1442: -- Ensure the arguments are not null
1443: --
1444: hr_api.mandatory_arg_error
1445: (p_api_name => l_proc,
1446: p_argument => 'validation_start_date',
1447: p_argument_value => p_validation_start_date);
1448: --

Line 1449: hr_api.mandatory_arg_error

1445: (p_api_name => l_proc,
1446: p_argument => 'validation_start_date',
1447: p_argument_value => p_validation_start_date);
1448: --
1449: hr_api.mandatory_arg_error
1450: (p_api_name => l_proc,
1451: p_argument => 'validation_end_date',
1452: p_argument_value => p_validation_end_date);
1453: --

Line 1454: hr_api.mandatory_arg_error

1450: (p_api_name => l_proc,
1451: p_argument => 'validation_end_date',
1452: p_argument_value => p_validation_end_date);
1453: --
1454: hr_api.mandatory_arg_error
1455: (p_api_name => l_proc,
1456: p_argument => 'emp_county_tax_rule_id',
1457: p_argument_value => p_emp_county_tax_rule_id);
1458: --

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

1708: hr_utility.set_location('Entering:'|| l_proc, 10);
1709: --
1710: -- Ensure that all the mandatory parameter are not null
1711: --
1712: hr_api.mandatory_arg_error(p_api_name => l_proc,
1713: p_argument => 'emp_county_tax_rule_id',
1714: p_argument_value => p_emp_county_tax_rule_id);
1715: --
1716: if nvl(g_cnt_tax_rule_id, hr_api.g_number) = p_emp_county_tax_rule_id then

Line 1716: if nvl(g_cnt_tax_rule_id, hr_api.g_number) = p_emp_county_tax_rule_id then

1712: hr_api.mandatory_arg_error(p_api_name => l_proc,
1713: p_argument => 'emp_county_tax_rule_id',
1714: p_argument_value => p_emp_county_tax_rule_id);
1715: --
1716: if nvl(g_cnt_tax_rule_id, hr_api.g_number) = p_emp_county_tax_rule_id then
1717: --
1718: -- The legislation code has already been found with a previous
1719: -- call to this function. Just return the value in the global
1720: -- variable.