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.PER_ASSIGNMENTS_F3_PKG dependencies on PER_ASSIGNMENTS_F

Line 1: PACKAGE BODY PER_ASSIGNMENTS_F3_PKG AS

1: PACKAGE BODY PER_ASSIGNMENTS_F3_PKG AS
2: /* $Header: peasg01t.pkb 120.29.12010000.3 2008/09/29 05:42:27 ubhat ship $ */
3: -----------------------------------------------------------------------------
4: --
5: g_package varchar2(24) := 'PER_ASSIGNMENTS_F3_PKG.';

Line 5: g_package varchar2(24) := 'PER_ASSIGNMENTS_F3_PKG.';

1: PACKAGE BODY PER_ASSIGNMENTS_F3_PKG AS
2: /* $Header: peasg01t.pkb 120.29.12010000.3 2008/09/29 05:42:27 ubhat ship $ */
3: -----------------------------------------------------------------------------
4: --
5: g_package varchar2(24) := 'PER_ASSIGNMENTS_F3_PKG.';
6: g_debug boolean; -- debug flag
7: --
8: procedure process_end_status(
9: p_ass_id number,

Line 18: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.process_end_status', 5);

14: -- If the status is changed to 'END' then if there are any future
15: -- changes then disallow the update.
16: ---
17: begin
18: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.process_end_status', 5);
19: if p_eff_end_date < p_eot then
20: fnd_message.set_name('PAY', 'HR_6071_APP_ASS_INVALID_END');
21: fnd_message.raise_error;
22: end if;

Line 29: hr_utility.set_location('Leaving: '|| 'PER_ASSIGNMENTS_F3_PKG.process_end_status', 5);

25: -- effective delete.
26: --
27: hr_assignment.del_ref_int_check(p_ass_id, 'END', p_sess_date);
28: --
29: hr_utility.set_location('Leaving: '|| 'PER_ASSIGNMENTS_F3_PKG.process_end_status', 5);
30: end process_end_status;
31: ---------------------------------------------------------------------------
32: procedure process_term_status(
33: p_ass_id number,

Line 42: from per_assignments_f a

38: -- other than TERM_ASSIGNs changes then disallow the update.
39: --
40: cursor term_assign is
41: select 1
42: from per_assignments_f a
43: where a.assignment_id = P_ASS_ID
44: and a.effective_start_date > P_SESS_DATE
45: and exists (select null
46: from per_assignment_status_types s

Line 51: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.process_term_status' , 5);

47: where s.assignment_status_type_id =
48: a.assignment_status_type_id
49: and s.per_system_status <> 'TERM_ASSIGN');
50: begin
51: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.process_term_status' , 5);
52: open term_assign;
53: fetch term_assign into l_dummy;
54: if term_assign%found then
55: fnd_message.set_name('PAY', 'HR_6387_EMP_ASS_INVALID_TERM');

Line 76: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.validate_primary_flag.' , 5);

72: -- HR_ASSIGNMENT.CHECK_ASS_FOR_PRIMARY performs these checks on an
73: -- assignment that has had its PRIMARY FLAG set to 'Yes'
74: --
75: begin
76: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.validate_primary_flag.' , 5);
77: hr_assignment.check_ass_for_primary(
78: p_pd_os_id,
79: p_ass_id,
80: p_val_st_date);

Line 102: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.test_for_cancel_term' , 5);

98: -- "leading TERM_ASSIGN" to be implicitly created (i.e. a row in the
99: -- future becomes the "leading TERM_ASSIGN").
100: --
101: begin
102: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.test_for_cancel_term' , 5);
103: hr_assignment.test_for_cancel_reterm(
104: p_ass_id,
105: p_val_start_date,
106: p_val_end_date,

Line 165: hr_utility.set_location('per_assignments_f3_pkg.check_future_primary',1);

161: -- shown on the client to select from a list of primary candidate
162: -- assignments.
163: --
164: begin
165: hr_utility.set_location('per_assignments_f3_pkg.check_future_primary',1);
166: p_show_cand_prim_assgts := null;
167: if p_dt_mode = 'UPDATE_OVERRIDE' then
168: l_start_date := p_val_start_date;
169: l_prim_flag := p_prim_flag;

Line 179: hr_utility.set_location('per_assignments_f3_pkg.check_future_primary',2);

175: -- Note last 3 parameters return values from server-side procedure.
176: -- The last is OUT only so no need to get p_prim_date_from, we will
177: -- only write to the item.
178: --
179: hr_utility.set_location('per_assignments_f3_pkg.check_future_primary',2);
180: hr_assignment.check_future_primary(
181: p_ass_id,
182: l_start_date,
183: p_eff_end_date,

Line 200: hr_utility.set_location('per_assignments_f3_pkg.check_future_primary',3);

196: --
197: -- As above, last parameter is OUT only - it's actually a varchar2
198: -- returning a number value!
199: --
200: hr_utility.set_location('per_assignments_f3_pkg.check_future_primary',3);
201: hr_assignment.get_new_primary_assignment(
202: p_ass_id,
203: p_pd_os_id,
204: l_start_date,

Line 257: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 5);

253: l_warning varchar2(80);
254: l_new_end_date date;
255: l_show_cand_prim_assgts varchar2(1);
256: begin
257: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 5);
258: --
259: -- NB RE_ENTRY_POINT_1 is no longer used but kept in so that
260: -- RE_ENTRY_POINT_2 will behave in the same way.
261: --

Line 312: hr_utility.set_location('PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 10);

308: end if;
309: --
310: <>
311: --
312: hr_utility.set_location('PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 10);
313: if p_per_sys_st = 'END' then
314: process_end_status(
315: p_ass_id,
316: p_sess_date,

Line 332: hr_utility.set_location('PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 20);

328: -- of other primary flags is necessary.
329: --
330: p_copy_y_to_prim_ch := null;
331: --
332: hr_utility.set_location('PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 20);
333: if p_s_prim_flag = p_prim_flag then
334: if p_upd_mode = 'UPDATE_OVERRIDE' then
335: check_future_primary(
336: p_upd_mode,

Line 376: hr_utility.set_location('PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 30);

372: --
373: -- Now check the changing of term_assign's with relation to it's
374: -- impact on element entries (G255).
375: --
376: hr_utility.set_location('PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 30);
377: test_for_cancel_term(
378: p_ass_id,
379: p_val_st_date,
380: p_val_end_date,

Line 404: hr_utility.set_location('Leaving: '|| 'PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 40);

400: end if;
401: --
402: p_re_entry_point := 0;
403: --
404: hr_utility.set_location('Leaving: '|| 'PER_ASSIGNMENTS_F3_PKG.pre_update_bundle2' , 40);
405: end pre_update_bundle2;
406: -----------------------------------------------------------------------------
407: --
408: -- UPDATE_AND_DELETE_BUNDLE: procedure to bundle procedure calls which follow

Line 567: hr_utility.set_location('per_assignments_f3_pkg.update_and_delete_bundle',1);

563: begin
564: p_returned_warning := null;
565: hr_utility.clear_warning;
566: --
567: hr_utility.set_location('per_assignments_f3_pkg.update_and_delete_bundle',1);
568: hr_utility.trace('RE_ENTRY_POINT is '||to_char(p_re_entry_point));
569:
570: --Bug# 5758747
571: OPEN get_leg_code;

Line 870: hr_utility.set_location('per_assignments_f3_pkg.update_and_delete_bundle',2);

866: -- end of fix for the bug 4612843
867: --
868: p_re_entry_point := 0;
869: --
870: hr_utility.set_location('per_assignments_f3_pkg.update_and_delete_bundle',2);
871: --
872: end update_and_delete_bundle;
873: -----------------------------------------------------------------------------
874: END PER_ASSIGNMENTS_F3_PKG;

Line 874: END PER_ASSIGNMENTS_F3_PKG;

870: hr_utility.set_location('per_assignments_f3_pkg.update_and_delete_bundle',2);
871: --
872: end update_and_delete_bundle;
873: -----------------------------------------------------------------------------
874: END PER_ASSIGNMENTS_F3_PKG;