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

Line 88: hr_api.mandatory_arg_error

84: hr_utility.set_message(801,'PAY_72738_CTY_BG_NOT_NULL');
85: hr_utility.raise_error;
86: end if;
87: --
88: hr_api.mandatory_arg_error
89: (p_api_name => l_proc
90: ,p_argument => 'effective_date'
91: ,p_argument_value => p_effective_date
92: );

Line 111: if nvl(p_business_group_id, hr_api.g_number) <> l_business_group_id

107: else
108: --
109: close csr_business_grp;
110: --
111: if nvl(p_business_group_id, hr_api.g_number) <> l_business_group_id
112: then
113: hr_utility.set_message(801, 'PAY_72737_CTY_BG_MATCH_ASG');
114: hr_utility.raise_error;
115: else

Line 249: hr_api.mandatory_arg_error

245: hr_utility.set_location('Entering: '|| l_proc, 5);
246: --
247: -- Check to see if mandatory parameters have been set.
248: --
249: hr_api.mandatory_arg_error
250: (p_api_name => l_proc
251: ,p_argument => 'state_code'
252: ,p_argument_value => p_state_code
253: );

Line 407: hr_api.mandatory_arg_error

403: hr_utility.set_message(801,'PAY_72744_CTY_JD_NOT_NULL');
404: hr_utility.raise_error;
405: end if;
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc
409: ,p_argument => 'state_code'
410: ,p_argument_value => p_state_code
411: );

Line 413: hr_api.mandatory_arg_error

409: ,p_argument => 'state_code'
410: ,p_argument_value => p_state_code
411: );
412: --
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc
415: ,p_argument => 'county_code'
416: ,p_argument_value => p_county_code
417: );

Line 419: hr_api.mandatory_arg_error

415: ,p_argument => 'county_code'
416: ,p_argument_value => p_county_code
417: );
418: --
419: hr_api.mandatory_arg_error
420: (p_api_name => l_proc
421: ,p_argument => 'city_code'
422: ,p_argument_value => p_city_code
423: );

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

480: --
481: -- If value is being inserted or updated ...
482: --
483: if (p_emp_city_tax_rule_id is not null
484: and nvl(p_additional_wa_rate,hr_api.g_number) <>
485: pay_cty_shd.g_old_rec.additional_wa_rate)
486: or (p_emp_city_tax_rule_id is null) then
487: --
488: -- Check that additional_wa_rate is not null.

Line 557: hr_api.mandatory_arg_error

553: begin
554: --
555: hr_utility.set_location('Entering: '|| l_proc, 5);
556: --
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc
559: ,p_argument => 'effective_date'
560: ,p_argument_value => p_effective_date
561: );

Line 563: hr_api.mandatory_arg_error

559: ,p_argument => 'effective_date'
560: ,p_argument_value => p_effective_date
561: );
562: --
563: hr_api.mandatory_arg_error
564: (p_api_name => l_proc
565: ,p_argument => 'state_code'
566: ,p_argument_value => p_state_code
567: );

Line 569: hr_api.mandatory_arg_error

565: ,p_argument => 'state_code'
566: ,p_argument_value => p_state_code
567: );
568: --
569: hr_api.mandatory_arg_error
570: (p_api_name => l_proc
571: ,p_argument => 'validation_start_date'
572: ,p_argument_value => p_validation_start_date
573: );

Line 575: hr_api.mandatory_arg_error

571: ,p_argument => 'validation_start_date'
572: ,p_argument_value => p_validation_start_date
573: );
574: --
575: hr_api.mandatory_arg_error
576: (p_api_name => l_proc
577: ,p_argument => 'validation_end_date'
578: ,p_argument_value => p_validation_end_date
579: );

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

580: --
581: -- If value is being inserted or updated ...
582: --
583: if (p_emp_city_tax_rule_id is not null
584: and nvl(p_filing_status_code,hr_api.g_varchar2) <>
585: pay_cty_shd.g_old_rec.filing_status_code)
586: or (p_emp_city_tax_rule_id is null) then
587: --
588: -- Check that filing_status_code is not null.

Line 597: if hr_api.not_exists_in_dt_hr_lookups

593: else
594: --
595: -- Check that filing_status_code is in a valid range.
596: --
597: if hr_api.not_exists_in_dt_hr_lookups
598: (p_effective_date => p_effective_date
599: ,p_validation_start_date => p_validation_start_date
600: ,p_validation_end_date => p_validation_end_date
601: ,p_lookup_type => 'US_LIT_FILING_STATUS'

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

653: --
654: -- If value is being inserted or updated ...
655: --
656: if (p_emp_city_tax_rule_id is not null
657: and nvl(p_lit_additional_tax,hr_api.g_number) <>
658: pay_cty_shd.g_old_rec.lit_additional_tax)
659: or (p_emp_city_tax_rule_id is null) then
660: --
661: -- Check that lit_additional_tax is not null.

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

718: --
719: -- If value is being inserted or updated ...
720: --
721: if (p_emp_city_tax_rule_id is not null
722: and nvl(p_lit_override_amount,hr_api.g_number) <>
723: pay_cty_shd.g_old_rec.lit_override_amount)
724: or (p_emp_city_tax_rule_id is null) then
725: --
726: -- Check that lit_override_amount is not null.

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

783: --
784: -- If value is being inserted or updated ...
785: --
786: if (p_emp_city_tax_rule_id is not null
787: and nvl(p_lit_override_rate,hr_api.g_number) <>
788: pay_cty_shd.g_old_rec.lit_override_rate)
789: or (p_emp_city_tax_rule_id is null) then
790: --
791: -- Check that lit_override_rate is not null.

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

847: --
848: -- If value is being inserted or updated ...
849: --
850: if (p_emp_city_tax_rule_id is not null
851: and nvl(p_withholding_allowances,hr_api.g_number) <>
852: pay_cty_shd.g_old_rec.withholding_allowances)
853: or (p_emp_city_tax_rule_id is null) then
854: --
855: -- Check that withholding_allowances is not null.

Line 988: hr_api.mandatory_arg_error

984: --
985: begin
986: hr_utility.set_location('Entering: '|| l_proc, 5);
987: --
988: hr_api.mandatory_arg_error
989: (p_api_name => l_proc
990: ,p_argument => 'state_code'
991: ,p_argument_value => p_state_code
992: );

Line 994: hr_api.mandatory_arg_error

990: ,p_argument => 'state_code'
991: ,p_argument_value => p_state_code
992: );
993: --
994: hr_api.mandatory_arg_error
995: (p_api_name => l_proc
996: ,p_argument => 'county_code'
997: ,p_argument_value => p_county_code
998: );

Line 1000: hr_api.mandatory_arg_error

996: ,p_argument => 'county_code'
997: ,p_argument_value => p_county_code
998: );
999: --
1000: hr_api.mandatory_arg_error
1001: (p_api_name => l_proc
1002: ,p_argument => 'city_code'
1003: ,p_argument_value => p_city_code
1004: );

Line 1016: and nvl(p_school_district_code,hr_api.g_number) <>

1012: --
1013: -- If the value is being inserted or updated...
1014: --
1015: if (l_api_updating
1016: and nvl(p_school_district_code,hr_api.g_number) <>
1017: pay_cty_shd.g_old_rec.school_district_code)
1018: or (not l_api_updating) then
1019: --
1020: -- Check school_district_code.

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

1176: per_addresses pa
1177: where paf.assignment_id = p_assignment_id
1178: and pa.person_id = paf.person_id
1179: and pa.primary_flag = 'Y'
1180: and nvl(pa.date_to, hr_api.g_eot) > p_csr_tmp_date
1181: and exists (select null
1182: from pay_us_states pus,
1183: pay_us_counties puco,
1184: pay_us_city_names puci

Line 1202: if p_delete_mode = hr_api.g_zap then

1198: hr_utility.set_location('Entering: '|| l_proc, 5);
1199: --
1200: if p_delete_mode in ('ZAP','DELETE') then
1201: hr_utility.set_location(l_proc, 10);
1202: if p_delete_mode = hr_api.g_zap then
1203: l_effective_date := trunc(hr_api.g_sot);
1204: else
1205: l_effective_date := trunc(p_effective_date);
1206: end if;

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

1199: --
1200: if p_delete_mode in ('ZAP','DELETE') then
1201: hr_utility.set_location(l_proc, 10);
1202: if p_delete_mode = hr_api.g_zap then
1203: l_effective_date := trunc(hr_api.g_sot);
1204: else
1205: l_effective_date := trunc(p_effective_date);
1206: end if;
1207: if p_delete_mode = 'DELETE' and p_delete_routine = 'ASSIGNMENT' then

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

1294: hr_utility.set_message_token('STEP',20);
1295: end if;
1296: hr_utility.set_location(l_proc, 30);
1297: --
1298: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
1299: pay_cty_shd.g_old_rec.business_group_id) then
1300: l_argument := 'business_group_id';
1301: raise l_error;
1302: end if;

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

1301: raise l_error;
1302: end if;
1303: hr_utility.set_location(l_proc, 40);
1304: --
1305: if (nvl(p_rec.assignment_id, hr_api.g_number) <>
1306: pay_cty_shd.g_old_rec.assignment_id) then
1307: l_argument := 'assignment_id';
1308: raise l_error;
1309: end if;

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

1308: raise l_error;
1309: end if;
1310: hr_utility.set_location(l_proc, 50);
1311: --
1312: if (nvl(p_rec.state_code, hr_api.g_varchar2) <>
1313: pay_cty_shd.g_old_rec.state_code) then
1314: l_argument := 'state_code';
1315: raise l_error;
1316: end if;

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

1315: raise l_error;
1316: end if;
1317: hr_utility.set_location(l_proc, 60);
1318: --
1319: if (nvl(p_rec.county_code, hr_api.g_varchar2) <>
1320: pay_cty_shd.g_old_rec.county_code) then
1321: l_argument := 'county_code';
1322: raise l_error;
1323: end if;

Line 1326: if (nvl(p_rec.city_code, hr_api.g_varchar2) <>

1322: raise l_error;
1323: end if;
1324: hr_utility.set_location(l_proc, 70);
1325: --
1326: if (nvl(p_rec.city_code, hr_api.g_varchar2) <>
1327: pay_cty_shd.g_old_rec.city_code) then
1328: l_argument := 'city_code';
1329: raise l_error;
1330: end if;

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

1329: raise l_error;
1330: end if;
1331: hr_utility.set_location(l_proc, 80);
1332: --
1333: if (nvl(p_rec.jurisdiction_code, hr_api.g_varchar2) <>
1334: pay_cty_shd.g_old_rec.jurisdiction_code) then
1335: l_argument := 'jurisdiction_code';
1336: raise l_error;
1337: end if;

Line 1342: hr_api.argument_changed_error

1338: hr_utility.set_location('Leaving: '||l_proc, 90);
1339: --
1340: exception
1341: when l_error then
1342: hr_api.argument_changed_error
1343: (p_api_name => l_proc,
1344: p_argument => l_argument
1345: );
1346: when others then

Line 1395: hr_api.mandatory_arg_error

1391: hr_utility.set_location('Entering:'||l_proc, 5);
1392: --
1393: -- Ensure that the p_datetrack_mode argument is not null
1394: --
1395: hr_api.mandatory_arg_error
1396: (p_api_name => l_proc,
1397: p_argument => 'datetrack_mode',
1398: p_argument_value => p_datetrack_mode);
1399: --

Line 1407: hr_api.mandatory_arg_error

1403: --
1404: --
1405: -- Ensure the arguments are not null
1406: --
1407: hr_api.mandatory_arg_error
1408: (p_api_name => l_proc,
1409: p_argument => 'validation_start_date',
1410: p_argument_value => p_validation_start_date);
1411: --

Line 1412: hr_api.mandatory_arg_error

1408: (p_api_name => l_proc,
1409: p_argument => 'validation_start_date',
1410: p_argument_value => p_validation_start_date);
1411: --
1412: hr_api.mandatory_arg_error
1413: (p_api_name => l_proc,
1414: p_argument => 'validation_end_date',
1415: p_argument_value => p_validation_end_date);
1416: --

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 1506: hr_api.mandatory_arg_error

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

Line 1511: hr_api.mandatory_arg_error

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

Line 1516: hr_api.mandatory_arg_error

1512: (p_api_name => l_proc,
1513: p_argument => 'validation_end_date',
1514: p_argument_value => p_validation_end_date);
1515: --
1516: hr_api.mandatory_arg_error
1517: (p_api_name => l_proc,
1518: p_argument => 'emp_city_tax_rule_id',
1519: p_argument_value => p_emp_city_tax_rule_id);
1520: --

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

1789: hr_utility.set_location('Entering:'|| l_proc, 10);
1790: --
1791: -- Ensure that all the mandatory parameter are not null
1792: --
1793: hr_api.mandatory_arg_error(p_api_name => l_proc,
1794: p_argument => 'emp_city_tax_rule_id',
1795: p_argument_value => p_emp_city_tax_rule_id);
1796: --
1797: if nvl(g_cty_tax_rule_id, hr_api.g_number) = p_emp_city_tax_rule_id then

Line 1797: if nvl(g_cty_tax_rule_id, hr_api.g_number) = p_emp_city_tax_rule_id then

1793: hr_api.mandatory_arg_error(p_api_name => l_proc,
1794: p_argument => 'emp_city_tax_rule_id',
1795: p_argument_value => p_emp_city_tax_rule_id);
1796: --
1797: if nvl(g_cty_tax_rule_id, hr_api.g_number) = p_emp_city_tax_rule_id then
1798: --
1799: -- The legislation code has already been found with a previous
1800: -- call to this function. Just return the value in the global
1801: -- variable.