DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F_PKG dependencies on HR_UTILITY

Line 175: hr_utility.set_location('Entering '||l_proc,20);

171: fetch c1 into P_ASSIGNMENT_ID;
172: close c1;
173: --
174: /*-- Start change for the bug 5854568 ----*/
175: hr_utility.set_location('Entering '||l_proc,20);
176: hr_utility.set_location('In the insert row',21);
177: hr_utility.set_location('Assgid= '||P_ASSIGNMENT_ID,22);
178: hr_utility.set_location('Pid= '||p_position_id,23);
179: hr_utility.set_location('Date= '||P_EFFECTIVE_START_DATE,24);

Line 176: hr_utility.set_location('In the insert row',21);

172: close c1;
173: --
174: /*-- Start change for the bug 5854568 ----*/
175: hr_utility.set_location('Entering '||l_proc,20);
176: hr_utility.set_location('In the insert row',21);
177: hr_utility.set_location('Assgid= '||P_ASSIGNMENT_ID,22);
178: hr_utility.set_location('Pid= '||p_position_id,23);
179: hr_utility.set_location('Date= '||P_EFFECTIVE_START_DATE,24);
180:

Line 177: hr_utility.set_location('Assgid= '||P_ASSIGNMENT_ID,22);

173: --
174: /*-- Start change for the bug 5854568 ----*/
175: hr_utility.set_location('Entering '||l_proc,20);
176: hr_utility.set_location('In the insert row',21);
177: hr_utility.set_location('Assgid= '||P_ASSIGNMENT_ID,22);
178: hr_utility.set_location('Pid= '||p_position_id,23);
179: hr_utility.set_location('Date= '||P_EFFECTIVE_START_DATE,24);
180:
181: per_asg_bus1.chk_frozen_single_pos

Line 178: hr_utility.set_location('Pid= '||p_position_id,23);

174: /*-- Start change for the bug 5854568 ----*/
175: hr_utility.set_location('Entering '||l_proc,20);
176: hr_utility.set_location('In the insert row',21);
177: hr_utility.set_location('Assgid= '||P_ASSIGNMENT_ID,22);
178: hr_utility.set_location('Pid= '||p_position_id,23);
179: hr_utility.set_location('Date= '||P_EFFECTIVE_START_DATE,24);
180:
181: per_asg_bus1.chk_frozen_single_pos
182: (p_assignment_id => P_ASSIGNMENT_ID

Line 179: hr_utility.set_location('Date= '||P_EFFECTIVE_START_DATE,24);

175: hr_utility.set_location('Entering '||l_proc,20);
176: hr_utility.set_location('In the insert row',21);
177: hr_utility.set_location('Assgid= '||P_ASSIGNMENT_ID,22);
178: hr_utility.set_location('Pid= '||p_position_id,23);
179: hr_utility.set_location('Date= '||P_EFFECTIVE_START_DATE,24);
180:
181: per_asg_bus1.chk_frozen_single_pos
182: (p_assignment_id => P_ASSIGNMENT_ID
183: ,p_position_id => p_position_id

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

423: p_projected_assignment_end
424: );
425: end;
426: --
427: hr_utility.set_location( l_proc, 30);
428:
429: -- Insert a row into irc_assignment_statuses for irecruitment
430: if p_assignment_type = 'A' then
431: IRC_ASG_STATUS_API.create_irc_asg_status

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

437: , p_assignment_status_id => l_assignment_status_id
438: , p_object_version_number => l_object_version_number
439: );
440: end if;
441: hr_utility.set_location( l_proc, 40);
442: open c2;
443: fetch c2 into P_ROW_ID;
444: close c2;
445: -- bug 1228430 Adding a call to default tax with validation for

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

447:
448: l_session_date := p_effective_start_date;
449:
450: -- Bug 1319140 fix begin: Added US legislation code check.
451: hr_utility.set_location( l_proc, 50);
452: open ac1;
453: fetch ac1 into l_legislation_code;
454: if ac1%notfound then
455: close ac1;

Line 463: hr_utility.set_location( l_proc, 60);

459: fnd_message.set_token('STEP', '0');
460: fnd_message.raise_error;
461: end if;
462: close ac1;
463: hr_utility.set_location( l_proc, 60);
464:
465: -- Start of fix 3634447
466: -- Add the person to the appropriate security lists
467: hr_security_internal.add_to_person_list(

Line 473: hr_utility.set_location( l_proc, 70);

469: p_assignment_id => p_assignment_id);
470: -- End of fix 3634447
471: hr_security.add_assignment(p_person_id, p_assignment_id); -- Bug 4018555
472: --
473: hr_utility.set_location( l_proc, 70);
474:
475: IF l_legislation_code = 'US' THEN
476: pay_us_emp_dt_tax_rules.default_tax_with_validation(
477: p_assignment_id => p_assignment_id,

Line 491: hr_utility.set_location( l_proc, 80);

487: p_return_text => l_return_text);
488: END IF;
489: -- Bug 1319140 fix end: Added US legislation code check.
490: --
491: hr_utility.set_location( l_proc, 80);
492:
493: -- Start changes for bug 10180700
494:
495: /*

Line 1462: hr_utility.set_location('per_assignments_f_pkg.update_row',1);

1458: --the person when assigned to the default business group and we want to
1459: --restrict access immediately the organization is entered, rather than waiting
1460: --for the next run of listgen.
1461: --
1462: hr_utility.set_location('per_assignments_f_pkg.update_row',1);
1463: open csr_chk_loc_change;
1464: fetch csr_chk_loc_change into l_loc_id;
1465:
1466: if csr_chk_loc_change%NOTFOUND then

Line 1489: hr_utility.set_location('per_assignments_f_pkg.update_row',10);

1485: --
1486: if p_pay_basis_id is null then
1487: open c_pay_proposals;
1488:
1489: hr_utility.set_location('per_assignments_f_pkg.update_row',10);
1490: fetch c_pay_proposals into l_change_date;
1491: if c_pay_proposals%FOUND then
1492: if l_change_date < p_session_date then
1493: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');

Line 1496: hr_utility.set_location('per_assignments_f_pkg.update_row',20);

1492: if l_change_date < p_session_date then
1493: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');
1494: fnd_message.raise_error;
1495: end if;
1496: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1497: end if;
1498: hr_utility.set_location('per_assignments_f_pkg.update_row',30);
1499: end if;
1500:

Line 1498: hr_utility.set_location('per_assignments_f_pkg.update_row',30);

1494: fnd_message.raise_error;
1495: end if;
1496: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1497: end if;
1498: hr_utility.set_location('per_assignments_f_pkg.update_row',30);
1499: end if;
1500:
1501: -- End Bug 2365872
1502: **/

Line 1505: hr_utility.set_location(g_package || l_proc, 20);

1501: -- End Bug 2365872
1502: **/
1503:
1504: /************************************/
1505: hr_utility.set_location(g_package || l_proc, 20);
1506:
1507: open perav1(chartorowid(p_row_id));
1508: fetch perav1 into l_organization_id, l_legislation_code,
1509: l_location_id;

Line 1545: hr_utility.set_location(g_package || l_proc, 30);

1541: --
1542: -- changed p_rowid => null to p_rowid => p_row_id
1543: --
1544:
1545: hr_utility.set_location(g_package || l_proc, 30);
1546:
1547: -- Start changes for bug 10180700
1548: /*
1549: ben_dt_trgr_handle.assignment

Line 1608: hr_utility.set_location(g_package || l_proc, 40);

1604: );
1605: */
1606: -- Start changes for bug 10180700
1607: --
1608: hr_utility.set_location(g_package || l_proc, 40);
1609: -- Retrieve Previous assignment_status_id
1610: select assignment_status_type_id into l_previous_asg_status
1611: from per_assignments_f
1612: where rowid = chartorowid(P_ROW_ID);

Line 1614: hr_utility.set_location(g_package || l_proc, 45);

1610: select assignment_status_type_id into l_previous_asg_status
1611: from per_assignments_f
1612: where rowid = chartorowid(P_ROW_ID);
1613:
1614: hr_utility.set_location(g_package || l_proc, 45);
1615:
1616: if l_previous_asg_status <> p_assignment_status_type_id
1617: and p_assignment_type = 'A' then
1618: IRC_ASG_STATUS_API.create_irc_asg_status

Line 1627: hr_utility.set_location(g_package || l_proc, 50);

1623: , p_assignment_status_id => l_assignment_status_id
1624: , p_object_version_number => l_asg_status_ovn);
1625: end if;
1626:
1627: hr_utility.set_location(g_package || l_proc, 50);
1628: update per_assignments_f a
1629: set a.assignment_id = P_ASSIGNMENT_ID,
1630: a.effective_start_date = P_EFFECTIVE_START_DATE,
1631: a.effective_end_date = P_EFFECTIVE_END_DATE,

Line 1740: hr_utility.set_location(g_package || l_proc, 55);

1736: a.projected_assignment_end = p_projected_assignment_end
1737: where a.rowid = chartorowid(P_ROW_ID);
1738: --
1739: -- Start of fix 3815024
1740: hr_utility.set_location(g_package || l_proc, 55);
1741:
1742: -- Start changes for bug 10180700
1743: ben_dt_trgr_handle.assignment
1744: (p_rowid => p_row_id

Line 1823: hr_utility.set_location(g_package || l_proc, 70);

1819: p_person_id => p_person_id);
1820: --
1821: /*end if;*/ -- Commented for 6167879
1822: --
1823: hr_utility.set_location(g_package || l_proc, 70);
1824:
1825: -- Start of fix 8232830
1826: -- Start of fix 12972634
1827: if p_effective_start_date < trunc(sysdate) then

Line 1828: hr_utility.set_location('p_eff_strt_date:'||p_effective_start_date,66);

1824:
1825: -- Start of fix 8232830
1826: -- Start of fix 12972634
1827: if p_effective_start_date < trunc(sysdate) then
1828: hr_utility.set_location('p_eff_strt_date:'||p_effective_start_date,66);
1829: hr_utility.set_location('sysdate:'||trunc(sysdate),67);
1830: open csr_get_assign(p_person_id);
1831: loop
1832: fetch csr_get_assign into l_assignment_id;

Line 1829: hr_utility.set_location('sysdate:'||trunc(sysdate),67);

1825: -- Start of fix 8232830
1826: -- Start of fix 12972634
1827: if p_effective_start_date < trunc(sysdate) then
1828: hr_utility.set_location('p_eff_strt_date:'||p_effective_start_date,66);
1829: hr_utility.set_location('sysdate:'||trunc(sysdate),67);
1830: open csr_get_assign(p_person_id);
1831: loop
1832: fetch csr_get_assign into l_assignment_id;
1833: exit when csr_get_assign%NOTFOUND;

Line 1838: hr_utility.set_location('p_eff_strt_date:'||p_effective_start_date,68);

1834: hr_security_internal.add_to_person_list( p_effective_date => trunc(sysdate), -- for bug14592133
1835: p_assignment_id => l_assignment_id);
1836: end loop;
1837: else
1838: hr_utility.set_location('p_eff_strt_date:'||p_effective_start_date,68);
1839: open csr_get_assign1(p_person_id);
1840: loop
1841: fetch csr_get_assign1 into l_assignment_id;
1842: exit when csr_get_assign1%NOTFOUND;

Line 1881: hr_utility.set_message(801,'PAY_75264_US_PAYROLL_REMOVAL');

1877:
1878: IF csr_defaultpayrollremoved%FOUND then
1879: close csr_defaulting_date;
1880: close csr_defaultpayrollremoved;
1881: hr_utility.set_message(801,'PAY_75264_US_PAYROLL_REMOVAL');
1882: hr_utility.raise_error;
1883: END IF;
1884: CLOSE csr_defaultpayrollremoved;
1885:

Line 1882: hr_utility.raise_error;

1878: IF csr_defaultpayrollremoved%FOUND then
1879: close csr_defaulting_date;
1880: close csr_defaultpayrollremoved;
1881: hr_utility.set_message(801,'PAY_75264_US_PAYROLL_REMOVAL');
1882: hr_utility.raise_error;
1883: END IF;
1884: CLOSE csr_defaultpayrollremoved;
1885:
1886: END IF;

Line 1901: hr_utility.set_location(g_package || l_proc, 80);

1897: l_location_id := p_location_id;
1898: l_dt_update_mode := p_dt_update_mode;
1899: end if;
1900:
1901: hr_utility.set_location(g_package || l_proc, 80);
1902:
1903: pay_us_emp_dt_tax_rules.default_tax_with_validation(
1904: p_assignment_id => p_assignment_id,
1905: p_person_id => p_person_id,

Line 1954: -- g_debug := hr_utility.debug_enabled; -- get debug status

1950: --
1951: l_proc varchar2(13) := 'dml_promotion';
1952: --
1953: begin
1954: -- g_debug := hr_utility.debug_enabled; -- get debug status
1955: IF g_debug THEN
1956: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1957: END IF;
1958:

Line 1956: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);

1952: --
1953: begin
1954: -- g_debug := hr_utility.debug_enabled; -- get debug status
1955: IF g_debug THEN
1956: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1957: END IF;
1958:
1959: open c_promotion_exists;
1960: fetch c_promotion_exists into l_promotion_rec;

Line 1983: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);

1979: end if;
1980: --
1981: close c_promotion_exists;
1982: --
1983: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
1984: --
1985: end dml_promotion;
1986: -----------------------------------------------------------------------------
1987: --