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 251: hr_utility.set_location('province_code'||l_province_code,999);

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

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

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

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

1209: --
1210: begin
1211: --
1212: --
1213: hr_utility.set_location(' Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1214: l_effective_date := trunc(p_effective_date);
1215: --
1216: -- Validate that a federal tax rule exists for this assignment
1217: --

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

1222: raise l_exit_quietly;
1223: end if;
1224: close csr_fed_rule;
1225:
1226: hr_utility.set_location(l_proc, 20);
1227: --
1228: if p_datetrack_delete_mode NOT IN ('ZAP', 'DELETE') then
1229: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1230: hr_utility.raise_error;

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

1225:
1226: hr_utility.set_location(l_proc, 20);
1227: --
1228: if p_datetrack_delete_mode NOT IN ('ZAP', 'DELETE') then
1229: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1230: hr_utility.raise_error;
1231: end if;
1232: --
1233: -- Validate that this routine is called from Assignment code

Line 1230: hr_utility.raise_error;

1226: hr_utility.set_location(l_proc, 20);
1227: --
1228: if p_datetrack_delete_mode NOT IN ('ZAP', 'DELETE') then
1229: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1230: hr_utility.raise_error;
1231: end if;
1232: --
1233: -- Validate that this routine is called from Assignment code
1234: --

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

1232: --
1233: -- Validate that this routine is called from Assignment code
1234: --
1235:
1236: hr_utility.set_location(l_proc, 30);
1237:
1238: if nvl(p_delete_routine,'X') <> 'ASSIGNMENT' then
1239: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');
1240: hr_utility.raise_error;

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

1235:
1236: hr_utility.set_location(l_proc, 30);
1237:
1238: if nvl(p_delete_routine,'X') <> 'ASSIGNMENT' then
1239: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');
1240: hr_utility.raise_error;
1241: end if;
1242: --
1243: open csr_prov_rule;

Line 1240: hr_utility.raise_error;

1236: hr_utility.set_location(l_proc, 30);
1237:
1238: if nvl(p_delete_routine,'X') <> 'ASSIGNMENT' then
1239: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');
1240: hr_utility.raise_error;
1241: end if;
1242: --
1243: open csr_prov_rule;
1244: loop

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

1259: --
1260: end loop;
1261: close csr_prov_rule;
1262:
1263: hr_utility.set_location(l_proc, 40);
1264: --
1265: -- Need to check whether this procedure should be called
1266: /* maintain_wc(
1267: p_emp_fed_tax_rule_id => l_emp_fed_tax_inf_id

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

1283: ,p_datetrack_mode => p_datetrack_delete_mode
1284: );
1285: --
1286: --
1287: hr_utility.set_location(l_proc, 50);
1288: --
1289: -- Set all output arguments
1290: --
1291: p_effective_start_date := l_effective_start_date;

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

1291: p_effective_start_date := l_effective_start_date;
1292: p_effective_end_date := l_effective_end_date;
1293: p_object_version_number := l_object_version_number;
1294: --
1295: hr_utility.set_location(' Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 60);
1296: --
1297: exception
1298: --
1299: when l_exit_quietly then

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

1301: p_effective_start_date := null;
1302: p_effective_end_date := null;
1303: p_object_version_number := null;
1304: --
1305: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);
1306: --
1307: --
1308: end delete_fed_tax_rule;
1309:

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

1362: --
1363: --
1364: begin
1365: --
1366: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1367: --
1368: l_effective_date := trunc(p_effective_date);
1369: --
1370: hr_utility.set_location(l_proc, 20);

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

1366: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1367: --
1368: l_effective_date := trunc(p_effective_date);
1369: --
1370: hr_utility.set_location(l_proc, 20);
1371: --
1372: -- First check if geocode has been installed or not. If no geocodes
1373: -- installed then return because there is nothing to be done by this
1374: -- procedure

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

1375: if hr_general.chk_maintain_tax_records = 'N' then
1376: raise l_exit_quietly;
1377: end if;
1378:
1379: hr_utility.set_location(l_proc, 30);
1380:
1381: if p_datetrack_mode NOT IN ('ZAP',
1382: 'DELETE',
1383: 'UPDATE',

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

1383: 'UPDATE',
1384: 'CORRECTION',
1385: 'UPDATE_OVERRIDE',
1386: 'UPDATE_CHANGE_INSERT') then
1387: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1388: hr_utility.raise_error;
1389: elsif p_datetrack_mode in ('ZAP', 'DELETE') then
1390: hr_utility.set_location(l_proc, 40);
1391: --

Line 1388: hr_utility.raise_error;

1384: 'CORRECTION',
1385: 'UPDATE_OVERRIDE',
1386: 'UPDATE_CHANGE_INSERT') then
1387: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1388: hr_utility.raise_error;
1389: elsif p_datetrack_mode in ('ZAP', 'DELETE') then
1390: hr_utility.set_location(l_proc, 40);
1391: --
1392: l_cnt := 0;

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

1386: 'UPDATE_CHANGE_INSERT') then
1387: hr_utility.set_message(801, 'HR_7204_DT_DEL_MODE_INVALID');
1388: hr_utility.raise_error;
1389: elsif p_datetrack_mode in ('ZAP', 'DELETE') then
1390: hr_utility.set_location(l_proc, 40);
1391: --
1392: l_cnt := 0;
1393: for l_assgn_rec in csr_adr_asg_id loop
1394: l_cnt := l_cnt + 1;

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

1396: end loop;
1397:
1398: --
1399:
1400: hr_utility.set_location('number of assignments '||l_assignment_tbl.count, 45);
1401:
1402: for l_cnt in 1..l_assignment_tbl.last loop
1403: open csr_asg_id(l_assignment_tbl(l_cnt));
1404: fetch csr_asg_id into l_temp_num;

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

1403: open csr_asg_id(l_assignment_tbl(l_cnt));
1404: fetch csr_asg_id into l_temp_num;
1405: if csr_asg_id%notfound then
1406: close csr_asg_id;
1407: hr_utility.set_message(801,'PAY_7702_PDT_VALUE_NOT_FOUND');
1408: hr_utility.raise_error;
1409: end if;
1410: close csr_asg_id;
1411: --

Line 1408: hr_utility.raise_error;

1404: fetch csr_asg_id into l_temp_num;
1405: if csr_asg_id%notfound then
1406: close csr_asg_id;
1407: hr_utility.set_message(801,'PAY_7702_PDT_VALUE_NOT_FOUND');
1408: hr_utility.raise_error;
1409: end if;
1410: close csr_asg_id;
1411: --
1412: hr_utility.set_location(l_proc, 50);

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

1408: hr_utility.raise_error;
1409: end if;
1410: close csr_asg_id;
1411: --
1412: hr_utility.set_location(l_proc, 50);
1413: hr_utility.set_location('assignment id '||l_assignment_tbl(l_cnt), 55);
1414: delete_fed_tax_rule(
1415: p_effective_date => l_effective_date
1416: ,p_datetrack_delete_mode => p_datetrack_mode

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

1409: end if;
1410: close csr_asg_id;
1411: --
1412: hr_utility.set_location(l_proc, 50);
1413: hr_utility.set_location('assignment id '||l_assignment_tbl(l_cnt), 55);
1414: delete_fed_tax_rule(
1415: p_effective_date => l_effective_date
1416: ,p_datetrack_delete_mode => p_datetrack_mode
1417: ,p_assignment_id => l_assignment_tbl(l_cnt)

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

1423: end loop;
1424:
1425: end if; -- datetrack mode is ZAP?
1426: --
1427: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 60);
1428: --
1429: exception
1430: --
1431: when l_exit_quietly then

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

1428: --
1429: exception
1430: --
1431: when l_exit_quietly then
1432: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);
1433: --
1434: end maintain_ca_employee_taxes;
1435:
1436: procedure delete_tax_record

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

1443:
1444: begin
1445:
1446: --
1447: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1448: --
1449:
1450: maintain_ca_employee_taxes
1451: ( p_period_of_service_id => p_period_of_service_id,

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

1453: p_datetrack_mode => 'DELETE',
1454: p_delete_routine => 'ASSIGNMENT'
1455: );
1456:
1457: hr_utility.set_location('Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 20);
1458:
1459: exception
1460: --
1461: when others then

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

1458:
1459: exception
1460: --
1461: when others then
1462: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 30);
1463: --
1464: end delete_tax_record;
1465:
1466: end pay_ca_emp_tax_inf;