DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F_PKG dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

404: p_projected_assignment_end
405: );
406: end;
407: --
408: hr_utility.set_location( l_proc, 30);
409:
410: -- Insert a row into irc_assignment_statuses for irecruitment
411: if p_assignment_type = 'A' then
412: IRC_ASG_STATUS_API.create_irc_asg_status

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

418: , p_assignment_status_id => l_assignment_status_id
419: , p_object_version_number => l_object_version_number
420: );
421: end if;
422: hr_utility.set_location( l_proc, 40);
423: open c2;
424: fetch c2 into P_ROW_ID;
425: close c2;
426: -- bug 1228430 Adding a call to default tax with validation for

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

428:
429: l_session_date := p_effective_start_date;
430:
431: -- Bug 1319140 fix begin: Added US legislation code check.
432: hr_utility.set_location( l_proc, 50);
433: open ac1;
434: fetch ac1 into l_legislation_code;
435: if ac1%notfound then
436: close ac1;

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

440: fnd_message.set_token('STEP', '0');
441: fnd_message.raise_error;
442: end if;
443: close ac1;
444: hr_utility.set_location( l_proc, 60);
445:
446: -- Start of fix 3634447
447: -- Add the person to the appropriate security lists
448: hr_security_internal.add_to_person_list(

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

450: p_assignment_id => p_assignment_id);
451: -- End of fix 3634447
452: hr_security.add_assignment(p_person_id, p_assignment_id); -- Bug 4018555
453: --
454: hr_utility.set_location( l_proc, 70);
455:
456: IF l_legislation_code = 'US' THEN
457: pay_us_emp_dt_tax_rules.default_tax_with_validation(
458: p_assignment_id => p_assignment_id,

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

468: p_return_text => l_return_text);
469: END IF;
470: -- Bug 1319140 fix end: Added US legislation code check.
471: --
472: hr_utility.set_location( l_proc, 80);
473:
474: ben_dt_trgr_handle.assignment
475: (p_rowid => null
476: ,p_assignment_id => p_assignment_id

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

1290: --the person when assigned to the default business group and we want to
1291: --restrict access immediately the organization is entered, rather than waiting
1292: --for the next run of listgen.
1293: --
1294: hr_utility.set_location('per_assignments_f_pkg.update_row',1);
1295: open csr_chk_loc_change;
1296: fetch csr_chk_loc_change into l_loc_id;
1297:
1298: if csr_chk_loc_change%NOTFOUND then

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

1317: --
1318: if p_pay_basis_id is null then
1319: open c_pay_proposals;
1320:
1321: hr_utility.set_location('per_assignments_f_pkg.update_row',10);
1322: fetch c_pay_proposals into l_change_date;
1323: if c_pay_proposals%FOUND then
1324: if l_change_date < p_session_date then
1325: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');

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

1324: if l_change_date < p_session_date then
1325: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');
1326: fnd_message.raise_error;
1327: end if;
1328: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1329: end if;
1330: hr_utility.set_location('per_assignments_f_pkg.update_row',30);
1331: end if;
1332:

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

1326: fnd_message.raise_error;
1327: end if;
1328: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1329: end if;
1330: hr_utility.set_location('per_assignments_f_pkg.update_row',30);
1331: end if;
1332:
1333: -- End Bug 2365872
1334: **/

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

1333: -- End Bug 2365872
1334: **/
1335:
1336: /************************************/
1337: hr_utility.set_location(g_package || l_proc, 20);
1338:
1339: open perav1(chartorowid(p_row_id));
1340: fetch perav1 into l_organization_id, l_legislation_code,
1341: l_location_id;

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

1372:
1373: --
1374: -- changed p_rowid => null to p_rowid => p_row_id
1375: --
1376: hr_utility.set_location(g_package || l_proc, 30);
1377:
1378: ben_dt_trgr_handle.assignment
1379: (p_rowid => p_row_id
1380: ,p_assignment_id => p_assignment_id

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

1431: ,p_ass_attribute29 => p_ass_attribute29
1432: ,p_ass_attribute30 => p_ass_attribute30
1433: );
1434: --
1435: hr_utility.set_location(g_package || l_proc, 40);
1436: -- Retrieve Previous assignment_status_id
1437: select assignment_status_type_id into l_previous_asg_status
1438: from per_assignments_f
1439: where rowid = chartorowid(P_ROW_ID);

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

1437: select assignment_status_type_id into l_previous_asg_status
1438: from per_assignments_f
1439: where rowid = chartorowid(P_ROW_ID);
1440:
1441: hr_utility.set_location(g_package || l_proc, 45);
1442:
1443: if l_previous_asg_status <> p_assignment_status_type_id
1444: and p_assignment_type = 'A' then
1445: IRC_ASG_STATUS_API.create_irc_asg_status

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

1450: , p_assignment_status_id => l_assignment_status_id
1451: , p_object_version_number => l_asg_status_ovn);
1452: end if;
1453:
1454: hr_utility.set_location(g_package || l_proc, 50);
1455: update per_assignments_f a
1456: set a.assignment_id = P_ASSIGNMENT_ID,
1457: a.effective_start_date = P_EFFECTIVE_START_DATE,
1458: a.effective_end_date = P_EFFECTIVE_END_DATE,

Line 1567: hr_utility.set_location(g_package || l_proc, 60);

1563: a.projected_assignment_end = p_projected_assignment_end
1564: where a.rowid = chartorowid(P_ROW_ID);
1565: --
1566: -- Start of fix 3815024
1567: hr_utility.set_location(g_package || l_proc, 60);
1568:
1569: /*if l_organization_id = p_business_group_id and
1570: p_organization_id <> p_business_group_id then*/ -- Commented for bug 6167879
1571: --

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

1573: p_person_id => p_person_id);
1574: --
1575: /*end if;*/ -- Commented for 6167879
1576: --
1577: hr_utility.set_location(g_package || l_proc, 70);
1578:
1579: hr_security_internal.add_to_person_list(
1580: p_effective_date => p_effective_start_date,
1581: p_assignment_id => p_assignment_id);

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

1604: l_location_id := p_location_id;
1605: l_dt_update_mode := p_dt_update_mode;
1606: end if;
1607:
1608: hr_utility.set_location(g_package || l_proc, 80);
1609:
1610: pay_us_emp_dt_tax_rules.default_tax_with_validation(
1611: p_assignment_id => p_assignment_id,
1612: p_person_id => p_person_id,

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

1657: --
1658: l_proc varchar2(13) := 'dml_promotion';
1659: --
1660: begin
1661: -- g_debug := hr_utility.debug_enabled; -- get debug status
1662: IF g_debug THEN
1663: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1664: END IF;
1665:

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

1659: --
1660: begin
1661: -- g_debug := hr_utility.debug_enabled; -- get debug status
1662: IF g_debug THEN
1663: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
1664: END IF;
1665:
1666: open c_promotion_exists;
1667: fetch c_promotion_exists into l_promotion_rec;

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

1686: end if;
1687: --
1688: close c_promotion_exists;
1689: --
1690: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
1691: --
1692: end dml_promotion;
1693: -----------------------------------------------------------------------------
1694: --