DBA Data[Home] [Help]

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.29.12010000.3 2008/09/29 05:42:27 ubhat 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 134: l_proc varchar2(200):= 'PER_ASSIGNMENTS_F_PKG.INSERT_ROW';

130: --
131: l_return_code number;
132: l_return_text varchar2(240);
133: l_session_date date;
134: l_proc varchar2(200):= 'PER_ASSIGNMENTS_F_PKG.INSERT_ROW';
135: --
136: /*
137: --WWBUG 2130950 Begin hrwf synchronization --tpapired
138: l_asg_rec per_all_assignments_f%rowtype;

Line 695: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');

691: if ASS_CUR%notfound then
692: close ASS_CUR;
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE',
695: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
696: fnd_message.set_token('STEP', '1');
697: fnd_message.raise_error;
698: end if;
699: close ASS_CUR;

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

1298: if csr_chk_loc_change%NOTFOUND then
1299: close csr_chk_loc_change;
1300: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1301: fnd_message.set_token('PROCEDURE',
1302: 'per_assignments_f_pkg.update_row');
1303: fnd_message.set_token('STEP','1');
1304: fnd_message.raise_error;
1305: else
1306: if l_loc_id <> p_location_id 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 1699: END PER_ASSIGNMENTS_F_PKG;

1695: -- **** End of standard ON-* checks. ****
1696: --
1697: -----------------------------------------------------------------------------
1698: --
1699: END PER_ASSIGNMENTS_F_PKG;