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_CA_EMP_TAX_INF dependencies on HR_UTILITY

Line 47: hr_utility.set_location('pay_ca_emp_tax_inf.get_work_provinces',1);

43: and lkp.lookup_code = hrl.region_1
44: and lkp.lookup_type = 'CA_PROVINCE';
45: begin
46:
47: hr_utility.set_location('pay_ca_emp_tax_inf.get_work_provinces',1);
48:
49: /* Get the resident address details */
50:
51: open csr_get_resident_province;

Line 63: hr_utility.set_location('get_province_code',2);

59: p_res_province_name := null;
60:
61: end if;
62:
63: hr_utility.set_location('get_province_code',2);
64:
65: close csr_get_resident_province;
66:
67: /* Get the work location details */

Line 81: hr_utility.set_location('pay_ca_emp_tax_inf.get_work_provinces',3);

77: p_work_province_name := null;
78:
79: end if;
80:
81: hr_utility.set_location('pay_ca_emp_tax_inf.get_work_provinces',3);
82:
83: close csr_get_work_province;
84: end get_province_code;
85:

Line 253: hr_utility.set_location('province_code'||l_province_code,999);

249: ,p_prov_lsp_amount => 0
250: ,p_effective_date => p_effective_date
251: ,p_ppip_exempt_flag => 'N'
252: ) ;
253: hr_utility.set_location('province_code'||l_province_code,999);
254:
255: commit;
256:
257: hr_utility.set_location('pay_ca_emp_tax_inf.create_default_tax_record',99);

Line 257: hr_utility.set_location('pay_ca_emp_tax_inf.create_default_tax_record',99);

253: hr_utility.set_location('province_code'||l_province_code,999);
254:
255: commit;
256:
257: hr_utility.set_location('pay_ca_emp_tax_inf.create_default_tax_record',99);
258: /****/
259: end create_default_tax_record;
260:
261: function get_basic_exemption(p_effective_date date,

Line 1103: hr_utility.trace('IN heck_age_under18_or_over70');

1099: l_check_age := 'Y';
1100:
1101: end if;
1102: */
1103: hr_utility.trace('IN heck_age_under18_or_over70');
1104: hr_utility.trace('age is ' || round(MONTHS_BETWEEN(l_effective_date,p_date_of_birth)/12,1) || ' Yrs');
1105:
1106:
1107:

Line 1104: hr_utility.trace('age is ' || round(MONTHS_BETWEEN(l_effective_date,p_date_of_birth)/12,1) || ' Yrs');

1100:
1101: end if;
1102: */
1103: hr_utility.trace('IN heck_age_under18_or_over70');
1104: hr_utility.trace('age is ' || round(MONTHS_BETWEEN(l_effective_date,p_date_of_birth)/12,1) || ' Yrs');
1105:
1106:
1107:
1108: if (( add_months(trunc(p_date_of_birth,'MONTH'),(18*12)+1)) <= l_effective_date ) then

Line 1204: hr_utility.trace('IN get_location_change_retro_exemption');

1200:
1201: open csr_get_exemption_value(p_payroll_action_id,p_assignment_id,p_exemption);
1202: fetch csr_get_exemption_value into l_value;
1203: close csr_get_exemption_value;
1204: hr_utility.trace('IN get_location_change_retro_exemption');
1205: hr_utility.trace(p_exemption ||' value is: ' || l_value);
1206:
1207: elsif p_exemption in ('Effective Year') then
1208:

Line 1205: hr_utility.trace(p_exemption ||' value is: ' || l_value);

1201: open csr_get_exemption_value(p_payroll_action_id,p_assignment_id,p_exemption);
1202: fetch csr_get_exemption_value into l_value;
1203: close csr_get_exemption_value;
1204: hr_utility.trace('IN get_location_change_retro_exemption');
1205: hr_utility.trace(p_exemption ||' value is: ' || l_value);
1206:
1207: elsif p_exemption in ('Effective Year') then
1208:
1209: open csr_get_effective_year(p_payroll_action_id);

Line 1212: hr_utility.trace(p_exemption ||' value is: ' || l_value);

1208:
1209: open csr_get_effective_year(p_payroll_action_id);
1210: fetch csr_get_effective_year into l_value;
1211: close csr_get_effective_year;
1212: hr_utility.trace(p_exemption ||' value is: ' || l_value);
1213:
1214: end if;
1215: return l_value;
1216: end get_loc_change_retro_exemp;

Line 1433: hr_utility.set_location(' Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);

1429: --
1430: begin
1431: --
1432: --
1433: hr_utility.set_location(' Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1434: l_effective_date := trunc(p_effective_date);
1435: --
1436: -- Validate that a federal tax rule exists for this assignment
1437: --

Line 1446: hr_utility.set_location(l_proc, 20);

1442: raise l_exit_quietly;
1443: end if;
1444: close csr_fed_rule;
1445:
1446: hr_utility.set_location(l_proc, 20);
1447: --
1448: if p_datetrack_delete_mode NOT IN ('ZAP', 'DELETE') then
1449: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1450: hr_utility.raise_error;

Line 1449: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');

1445:
1446: hr_utility.set_location(l_proc, 20);
1447: --
1448: if p_datetrack_delete_mode NOT IN ('ZAP', 'DELETE') then
1449: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1450: hr_utility.raise_error;
1451: end if;
1452: --
1453: -- Validate that this routine is called from Assignment code

Line 1450: hr_utility.raise_error;

1446: hr_utility.set_location(l_proc, 20);
1447: --
1448: if p_datetrack_delete_mode NOT IN ('ZAP', 'DELETE') then
1449: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1450: hr_utility.raise_error;
1451: end if;
1452: --
1453: -- Validate that this routine is called from Assignment code
1454: --

Line 1456: hr_utility.set_location(l_proc, 30);

1452: --
1453: -- Validate that this routine is called from Assignment code
1454: --
1455:
1456: hr_utility.set_location(l_proc, 30);
1457:
1458: if nvl(p_delete_routine,'X') <> 'ASSIGNMENT' then
1459: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');
1460: hr_utility.raise_error;

Line 1459: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');

1455:
1456: hr_utility.set_location(l_proc, 30);
1457:
1458: if nvl(p_delete_routine,'X') <> 'ASSIGNMENT' then
1459: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');
1460: hr_utility.raise_error;
1461: end if;
1462: --
1463: open csr_prov_rule;

Line 1460: hr_utility.raise_error;

1456: hr_utility.set_location(l_proc, 30);
1457:
1458: if nvl(p_delete_routine,'X') <> 'ASSIGNMENT' then
1459: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');
1460: hr_utility.raise_error;
1461: end if;
1462: --
1463: open csr_prov_rule;
1464: loop

Line 1483: hr_utility.set_location(l_proc, 40);

1479: --
1480: end loop;
1481: close csr_prov_rule;
1482:
1483: hr_utility.set_location(l_proc, 40);
1484: --
1485: -- Need to check whether this procedure should be called
1486: /* maintain_wc(
1487: p_emp_fed_tax_rule_id => l_emp_fed_tax_inf_id

Line 1507: hr_utility.set_location(l_proc, 50);

1503: ,p_datetrack_mode => p_datetrack_delete_mode
1504: );
1505: --
1506: --
1507: hr_utility.set_location(l_proc, 50);
1508: --
1509: -- Set all output arguments
1510: --
1511: p_effective_start_date := l_effective_start_date;

Line 1515: hr_utility.set_location(' Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 60);

1511: p_effective_start_date := l_effective_start_date;
1512: p_effective_end_date := l_effective_end_date;
1513: p_object_version_number := l_object_version_number;
1514: --
1515: hr_utility.set_location(' Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 60);
1516: --
1517: exception
1518: --
1519: when l_exit_quietly then

Line 1525: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);

1521: p_effective_start_date := null;
1522: p_effective_end_date := null;
1523: p_object_version_number := null;
1524: --
1525: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);
1526: --
1527: --
1528: end delete_fed_tax_rule;
1529:

Line 1586: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);

1582: --
1583: --
1584: begin
1585: --
1586: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1587: --
1588: l_effective_date := trunc(p_effective_date);
1589: --
1590: hr_utility.set_location(l_proc, 20);

Line 1590: hr_utility.set_location(l_proc, 20);

1586: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1587: --
1588: l_effective_date := trunc(p_effective_date);
1589: --
1590: hr_utility.set_location(l_proc, 20);
1591: --
1592: -- First check if geocode has been installed or not. If no geocodes
1593: -- installed then return because there is nothing to be done by this
1594: -- procedure

Line 1599: hr_utility.set_location(l_proc, 30);

1595: if hr_general.chk_maintain_tax_records = 'N' then
1596: raise l_exit_quietly;
1597: end if;
1598:
1599: hr_utility.set_location(l_proc, 30);
1600:
1601: if p_datetrack_mode NOT IN ('ZAP',
1602: 'DELETE',
1603: 'UPDATE',

Line 1607: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');

1603: 'UPDATE',
1604: 'CORRECTION',
1605: 'UPDATE_OVERRIDE',
1606: 'UPDATE_CHANGE_INSERT') then
1607: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1608: hr_utility.raise_error;
1609: elsif p_datetrack_mode in ('ZAP', 'DELETE') then
1610: hr_utility.set_location(l_proc, 40);
1611: --

Line 1608: hr_utility.raise_error;

1604: 'CORRECTION',
1605: 'UPDATE_OVERRIDE',
1606: 'UPDATE_CHANGE_INSERT') then
1607: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1608: hr_utility.raise_error;
1609: elsif p_datetrack_mode in ('ZAP', 'DELETE') then
1610: hr_utility.set_location(l_proc, 40);
1611: --
1612: l_cnt := 0;

Line 1610: hr_utility.set_location(l_proc, 40);

1606: 'UPDATE_CHANGE_INSERT') then
1607: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1608: hr_utility.raise_error;
1609: elsif p_datetrack_mode in ('ZAP', 'DELETE') then
1610: hr_utility.set_location(l_proc, 40);
1611: --
1612: l_cnt := 0;
1613: for l_assgn_rec in csr_adr_asg_id loop
1614: l_cnt := l_cnt + 1;

Line 1620: hr_utility.set_location('number of assignments '||l_assignment_tbl.count, 45);

1616: end loop;
1617:
1618: --
1619:
1620: hr_utility.set_location('number of assignments '||l_assignment_tbl.count, 45);
1621:
1622: for l_cnt in 1..l_assignment_tbl.last loop
1623: open csr_asg_id(l_assignment_tbl(l_cnt));
1624: fetch csr_asg_id into l_temp_num;

Line 1627: hr_utility.set_message(801,'PAY_7702_PDT_VALUE_NOT_FOUND');

1623: open csr_asg_id(l_assignment_tbl(l_cnt));
1624: fetch csr_asg_id into l_temp_num;
1625: if csr_asg_id%notfound then
1626: close csr_asg_id;
1627: hr_utility.set_message(801,'PAY_7702_PDT_VALUE_NOT_FOUND');
1628: hr_utility.raise_error;
1629: end if;
1630: close csr_asg_id;
1631: --

Line 1628: hr_utility.raise_error;

1624: fetch csr_asg_id into l_temp_num;
1625: if csr_asg_id%notfound then
1626: close csr_asg_id;
1627: hr_utility.set_message(801,'PAY_7702_PDT_VALUE_NOT_FOUND');
1628: hr_utility.raise_error;
1629: end if;
1630: close csr_asg_id;
1631: --
1632: hr_utility.set_location(l_proc, 50);

Line 1632: hr_utility.set_location(l_proc, 50);

1628: hr_utility.raise_error;
1629: end if;
1630: close csr_asg_id;
1631: --
1632: hr_utility.set_location(l_proc, 50);
1633: hr_utility.set_location('assignment id '||l_assignment_tbl(l_cnt), 55);
1634: delete_fed_tax_rule(
1635: p_effective_date => l_effective_date
1636: ,p_datetrack_delete_mode => p_datetrack_mode

Line 1633: hr_utility.set_location('assignment id '||l_assignment_tbl(l_cnt), 55);

1629: end if;
1630: close csr_asg_id;
1631: --
1632: hr_utility.set_location(l_proc, 50);
1633: hr_utility.set_location('assignment id '||l_assignment_tbl(l_cnt), 55);
1634: delete_fed_tax_rule(
1635: p_effective_date => l_effective_date
1636: ,p_datetrack_delete_mode => p_datetrack_mode
1637: ,p_assignment_id => l_assignment_tbl(l_cnt)

Line 1647: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 60);

1643: end loop;
1644:
1645: end if; -- datetrack mode is ZAP?
1646: --
1647: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 60);
1648: --
1649: exception
1650: --
1651: when l_exit_quietly then

Line 1652: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);

1648: --
1649: exception
1650: --
1651: when l_exit_quietly then
1652: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);
1653: --
1654: end maintain_ca_employee_taxes;
1655:
1656: procedure delete_tax_record

Line 1667: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);

1663:
1664: begin
1665:
1666: --
1667: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1668: --
1669:
1670: maintain_ca_employee_taxes
1671: ( p_period_of_service_id => p_period_of_service_id,

Line 1677: hr_utility.set_location('Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 20);

1673: p_datetrack_mode => 'DELETE',
1674: p_delete_routine => 'ASSIGNMENT'
1675: );
1676:
1677: hr_utility.set_location('Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 20);
1678:
1679: exception
1680: --
1681: when others then

Line 1682: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 30);

1678:
1679: exception
1680: --
1681: when others then
1682: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 30);
1683: --
1684: end delete_tax_record;
1685:
1686: /* The following function is used for determining whether an employee assignment is