APPS.PER_ASSIGNMENTS_F_PKG dependencies on PER_ASSIGNMENTS_F_PKG

Line 1: PACKAGE BODY PER_ASSIGNMENTS_F_PKG AS

1: PACKAGE BODY PER_ASSIGNMENTS_F_PKG AS
2: /* $Header: peasg01t.pkb 120.50.12020000.8 2013/02/06 07:35:03 srannama ship $ */
3: -----------------------------------------------------------------------------
4: --
5: -- **** Standard ON-* procedures of base view. *****

Line 12: --g_package varchar2(21) := 'PER_ASSIGNMENTS_F_PKG.';

8: --
9: -- Standard Insert procedure
10: --
11: --bug no 6028006 starts here
12: --g_package varchar2(21) := 'PER_ASSIGNMENTS_F_PKG.';
13: g_package varchar2(22) := 'PER_ASSIGNMENTS_F_PKG.';
14: --bug no 6028006 ends here
15: g_debug boolean; -- debug flag
16: --

Line 13: g_package varchar2(22) := 'PER_ASSIGNMENTS_F_PKG.';

9: -- Standard Insert procedure
10: --
11: --bug no 6028006 starts here
12: --g_package varchar2(21) := 'PER_ASSIGNMENTS_F_PKG.';
13: g_package varchar2(22) := 'PER_ASSIGNMENTS_F_PKG.';
14: --bug no 6028006 ends here
15: g_debug boolean; -- debug flag
16: --
17: procedure insert_row(

Line 135: l_proc varchar2(200):= 'PER_ASSIGNMENTS_F_PKG.INSERT_ROW';

131: l_work_at_home varchar2(1); --FIX FOR BUG 9215178
132: l_return_code number;
133: l_return_text varchar2(240);
134: l_session_date date;
135: l_proc varchar2(200):= 'PER_ASSIGNMENTS_F_PKG.INSERT_ROW';
136: l_labour_union_member_flag varchar2(1); -- bug fix 7698212
137: --
138: /*
139: --WWBUG 2130950 Begin hrwf synchronization --tpapired

Line 776: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');

772: if ASS_CUR%notfound then
773: close ASS_CUR;
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE',
776: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
777: fnd_message.set_token('STEP', '1');
778: fnd_message.raise_error;
779: end if;
780: close ASS_CUR;

Line 1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');

1441: --
1442: if ASS_CUR%notfound then
1443: close ASS_CUR;
1444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
1446: fnd_message.set_token('STEP', '1');
1447: fnd_message.raise_error;
1448: end if;
1449: --

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 1470: 'per_assignments_f_pkg.update_row');

1466: if csr_chk_loc_change%NOTFOUND then
1467: close csr_chk_loc_change;
1468: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE',
1470: 'per_assignments_f_pkg.update_row');
1471: fnd_message.set_token('STEP','1');
1472: fnd_message.raise_error;
1473: else
1474: if l_loc_id <> p_location_id 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 1992: END PER_ASSIGNMENTS_F_PKG;

1988: -- **** End of standard ON-* checks. ****
1989: --
1990: -----------------------------------------------------------------------------
1991: --
1992: END PER_ASSIGNMENTS_F_PKG;