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_FR_TERMINATION dependencies on HR_UTILITY

Line 20: hr_utility.set_location(l_proc,10);

16: where period_of_service_id = p_period_of_service_id;
17: --
18: l_proc varchar2(72) := g_package || '.intiate';
19: begin
20: hr_utility.set_location(l_proc,10);
21: open c_get_pds;
22: fetch c_get_pds into g_person_id;
23: close c_get_pds;
24: end initiate;

Line 44: hr_utility.set_location(l_proc,10);

40: and lookup_code = p_lookup_code;
41: --
42: l_proc varchar2(72) := g_package || '.validate_leaving_reason';
43: begin
44: hr_utility.set_location(l_proc,10);
45: open c_get_lkp;
46: fetch c_get_lkp into l_dummy;
47: if c_get_lkp%found then
48: close c_get_lkp;

Line 49: hr_utility.set_location(l_proc,20);

45: open c_get_lkp;
46: fetch c_get_lkp into l_dummy;
47: if c_get_lkp%found then
48: close c_get_lkp;
49: hr_utility.set_location(l_proc,20);
50: return TRUE;
51: else
52: close c_get_lkp;
53: hr_utility.set_location(l_proc,30);

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

49: hr_utility.set_location(l_proc,20);
50: return TRUE;
51: else
52: close c_get_lkp;
53: hr_utility.set_location(l_proc,30);
54: return FALSE;
55: end if;
56: end validate_leaving_reason;
57: --

Line 103: hr_utility.set_location(l_proc,10);

99: )));
100: --
101: l_proc varchar2(72) := g_package || '.validate';
102: begin
103: hr_utility.set_location(l_proc,10);
104: --
105: -- Added for bug#5191942
106: -- if final process date is on or before actual termination date
107: -- then raise an error

Line 108: hr_utility.set_location(l_proc, 10);

104: --
105: -- Added for bug#5191942
106: -- if final process date is on or before actual termination date
107: -- then raise an error
108: hr_utility.set_location(l_proc, 10);
109: /*if p_final_process_date is not null
110: and p_actual_termination_date is not null then
111: if p_final_process_date < p_actual_termination_date
112: or p_final_process_date = p_actual_termination_date then

Line 114: hr_utility.set_message(800, 'PER_75099_FINAL_CLOSE_ATD');

110: and p_actual_termination_date is not null then
111: if p_final_process_date < p_actual_termination_date
112: or p_final_process_date = p_actual_termination_date then
113: --
114: hr_utility.set_message(800, 'PER_75099_FINAL_CLOSE_ATD');
115: hr_utility.raise_error;
116: --
117: end if;
118: end if;*/

Line 115: hr_utility.raise_error;

111: if p_final_process_date < p_actual_termination_date
112: or p_final_process_date = p_actual_termination_date then
113: --
114: hr_utility.set_message(800, 'PER_75099_FINAL_CLOSE_ATD');
115: hr_utility.raise_error;
116: --
117: end if;
118: end if;*/
119: --

Line 123: hr_utility.set_location(l_proc,20);

119: --
120: -- If either the NPS or NPE have changed and if either is NOT NULL then
121: -- validate that NPS is not after NPE
122: --
123: hr_utility.set_location(l_proc,20);
124: if l_nps_changed or l_npe_changed then
125: if p_notice_period_start_date > p_notice_period_end_date then
126: hr_utility.set_message(800,'PER_75013_NOTICE_PERIOD_DATES');
127: hr_utility.raise_error;

Line 126: hr_utility.set_message(800,'PER_75013_NOTICE_PERIOD_DATES');

122: --
123: hr_utility.set_location(l_proc,20);
124: if l_nps_changed or l_npe_changed then
125: if p_notice_period_start_date > p_notice_period_end_date then
126: hr_utility.set_message(800,'PER_75013_NOTICE_PERIOD_DATES');
127: hr_utility.raise_error;
128: end if;
129: end if;
130: --

Line 127: hr_utility.raise_error;

123: hr_utility.set_location(l_proc,20);
124: if l_nps_changed or l_npe_changed then
125: if p_notice_period_start_date > p_notice_period_end_date then
126: hr_utility.set_message(800,'PER_75013_NOTICE_PERIOD_DATES');
127: hr_utility.raise_error;
128: end if;
129: end if;
130: --
131: -- If NPS has changed or LWD has changed then ensure that

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

130: --
131: -- If NPS has changed or LWD has changed then ensure that
132: -- Notice period start is not later than LWD
133: --
134: hr_utility.set_location(l_proc,30);
135: if l_nps_changed or l_lwd_changed then
136: if p_notice_period_start_date > p_last_day_worked then
137: hr_utility.set_message(800,'PER_75014_NPS_LWD_DATES');
138: hr_utility.raise_error;

Line 137: hr_utility.set_message(800,'PER_75014_NPS_LWD_DATES');

133: --
134: hr_utility.set_location(l_proc,30);
135: if l_nps_changed or l_lwd_changed then
136: if p_notice_period_start_date > p_last_day_worked then
137: hr_utility.set_message(800,'PER_75014_NPS_LWD_DATES');
138: hr_utility.raise_error;
139: end if;
140: end if;
141: --

Line 138: hr_utility.raise_error;

134: hr_utility.set_location(l_proc,30);
135: if l_nps_changed or l_lwd_changed then
136: if p_notice_period_start_date > p_last_day_worked then
137: hr_utility.set_message(800,'PER_75014_NPS_LWD_DATES');
138: hr_utility.raise_error;
139: end if;
140: end if;
141: --
142: -- If NPE has changed or LWD has changed then ensure that

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

141: --
142: -- If NPE has changed or LWD has changed then ensure that
143: -- Notice period end is not earlier than LWD
144: --
145: hr_utility.set_location(l_proc,40);
146: if l_npe_changed or l_lwd_changed then
147: if p_notice_period_end_date < p_last_day_worked then
148: hr_utility.set_message(800,'PER_75015_NPE_LWD_DATES');
149: hr_utility.raise_error;

Line 148: hr_utility.set_message(800,'PER_75015_NPE_LWD_DATES');

144: --
145: hr_utility.set_location(l_proc,40);
146: if l_npe_changed or l_lwd_changed then
147: if p_notice_period_end_date < p_last_day_worked then
148: hr_utility.set_message(800,'PER_75015_NPE_LWD_DATES');
149: hr_utility.raise_error;
150: end if;
151: end if;
152: --

Line 149: hr_utility.raise_error;

145: hr_utility.set_location(l_proc,40);
146: if l_npe_changed or l_lwd_changed then
147: if p_notice_period_end_date < p_last_day_worked then
148: hr_utility.set_message(800,'PER_75015_NPE_LWD_DATES');
149: hr_utility.raise_error;
150: end if;
151: end if;
152: --
153: -- If NPE is not null then NPS must also be not null

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

151: end if;
152: --
153: -- If NPE is not null then NPS must also be not null
154: --
155: hr_utility.set_location(l_proc,50);
156: if p_notice_period_start_date is null
157: and p_notice_period_end_date is not null then
158: hr_utility.set_message(800,'PER_75016_NPS_NPE_DATES');
159: hr_utility.raise_error;

Line 158: hr_utility.set_message(800,'PER_75016_NPS_NPE_DATES');

154: --
155: hr_utility.set_location(l_proc,50);
156: if p_notice_period_start_date is null
157: and p_notice_period_end_date is not null then
158: hr_utility.set_message(800,'PER_75016_NPS_NPE_DATES');
159: hr_utility.raise_error;
160: end if;
161: --
162: -- If ATD is not null then it must be on or after NPS and

Line 159: hr_utility.raise_error;

155: hr_utility.set_location(l_proc,50);
156: if p_notice_period_start_date is null
157: and p_notice_period_end_date is not null then
158: hr_utility.set_message(800,'PER_75016_NPS_NPE_DATES');
159: hr_utility.raise_error;
160: end if;
161: --
162: -- If ATD is not null then it must be on or after NPS and
163: -- on or before NPE

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

161: --
162: -- If ATD is not null then it must be on or after NPS and
163: -- on or before NPE
164: --
165: hr_utility.set_location(l_proc,60);
166: if p_actual_termination_date is not null
167: and p_notice_period_start_date is not null
168: and p_notice_period_end_date is not null then
169: if p_notice_period_start_date > p_actual_termination_date

Line 171: hr_utility.set_message(800,'PER_75017_NPS_ATD_DATES');

167: and p_notice_period_start_date is not null
168: and p_notice_period_end_date is not null then
169: if p_notice_period_start_date > p_actual_termination_date
170: or p_notice_period_end_date < p_actual_termination_date then
171: hr_utility.set_message(800,'PER_75017_NPS_ATD_DATES');
172: hr_utility.raise_error;
173: end if;
174: end if;
175: --

Line 172: hr_utility.raise_error;

168: and p_notice_period_end_date is not null then
169: if p_notice_period_start_date > p_actual_termination_date
170: or p_notice_period_end_date < p_actual_termination_date then
171: hr_utility.set_message(800,'PER_75017_NPS_ATD_DATES');
172: hr_utility.raise_error;
173: end if;
174: end if;
175: --
176: -- If ATD is not null and LWD is not null then LWD must be on or

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

175: --
176: -- If ATD is not null and LWD is not null then LWD must be on or
177: -- before ATD
178: --
179: hr_utility.set_location(l_proc,70);
180: if p_actual_termination_date is not null
181: and p_last_day_worked is not null then
182: if p_last_day_worked > p_actual_termination_date then
183: hr_utility.set_message(800,'PER_75018_LWD_ATD_DATES');

Line 183: hr_utility.set_message(800,'PER_75018_LWD_ATD_DATES');

179: hr_utility.set_location(l_proc,70);
180: if p_actual_termination_date is not null
181: and p_last_day_worked is not null then
182: if p_last_day_worked > p_actual_termination_date then
183: hr_utility.set_message(800,'PER_75018_LWD_ATD_DATES');
184: hr_utility.raise_error;
185: end if;
186: end if;
187: --

Line 184: hr_utility.raise_error;

180: if p_actual_termination_date is not null
181: and p_last_day_worked is not null then
182: if p_last_day_worked > p_actual_termination_date then
183: hr_utility.set_message(800,'PER_75018_LWD_ATD_DATES');
184: hr_utility.raise_error;
185: end if;
186: end if;
187: --
188: -- If ATD is not null then LWD must be entered

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

186: end if;
187: --
188: -- If ATD is not null then LWD must be entered
189: --
190: hr_utility.set_location(l_proc,80);
191:
192: IF per_per_bus.g_global_transfer_in_process IS NULL --12394469
193: OR per_per_bus.g_global_transfer_in_process = false --12394469
194: THEN

Line 197: hr_utility.set_message(800,'PER_75019_LWD_ATD_NULL');

193: OR per_per_bus.g_global_transfer_in_process = false --12394469
194: THEN
195: if p_actual_termination_date is not null
196: and p_last_day_worked is null then
197: hr_utility.set_message(800,'PER_75019_LWD_ATD_NULL');
198: hr_utility.raise_error;
199: end if;
200: END IF; --12394469
201: --

Line 198: hr_utility.raise_error;

194: THEN
195: if p_actual_termination_date is not null
196: and p_last_day_worked is null then
197: hr_utility.set_message(800,'PER_75019_LWD_ATD_NULL');
198: hr_utility.raise_error;
199: end if;
200: END IF; --12394469
201: --
202: hr_utility.set_location(l_proc,90);

Line 202: hr_utility.set_location(l_proc,90);

198: hr_utility.raise_error;
199: end if;
200: END IF; --12394469
201: --
202: hr_utility.set_location(l_proc,90);
203: end validate;
204: --
205: /* -------------------------------------------------------------------------
206: Local procedure to delete and create the element entry

Line 265: hr_utility.set_location(l_proc,10);

261: between l.effective_start_date and l.effective_end_date;
262: --
263: l_proc varchar2(72) := g_package || '.last_day_worked_entry';
264: begin
265: hr_utility.set_location(l_proc,10);
266: --
267: -- Get the FR_LAST_DAY_WORKED element type ID as of Actual Termination Date
268: --
269: l_effective_date := p_actual_termination_date;

Line 284: hr_utility.set_location(l_proc,20);

280: close c_get_asg;
281: --
282: -- Remove any existing element entry effective as of ATD
283: --
284: hr_utility.set_location(l_proc,20);
285: open c_entry;
286: fetch c_entry into l_element_entry_id;
287: if c_entry%found then
288: hr_entry_api.delete_element_entry

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

296: --
297: -- Now, if called from Terminate process, create new element entry
298: -- effective as of LWD
299: --
300: hr_utility.set_location(l_proc,30);
301: if p_last_day_worked is not null then
302: l_effective_date := p_last_day_worked;
303: open c_get_asg;
304: fetch c_get_asg into l_assignment_id;

Line 330: hr_utility.set_location('l_elemen_type_id'||l_element_type_id, 100);

326: -- A dummy input value is changed so that proration will occur.
327: --
328: IF l_element_name = 'FR_LAST_DAY_WORKED' THEN
329:
330: hr_utility.set_location('l_elemen_type_id'||l_element_type_id, 100);
331: hr_utility.set_location('l_assignment_id'||l_assignment_id, 100);
332: hr_utility.set_location('l_element_link_id'||l_element_link_id, 100);
333: Open c_input_value;
334: Fetch c_input_value into l_input_value_id;

Line 331: hr_utility.set_location('l_assignment_id'||l_assignment_id, 100);

327: --
328: IF l_element_name = 'FR_LAST_DAY_WORKED' THEN
329:
330: hr_utility.set_location('l_elemen_type_id'||l_element_type_id, 100);
331: hr_utility.set_location('l_assignment_id'||l_assignment_id, 100);
332: hr_utility.set_location('l_element_link_id'||l_element_link_id, 100);
333: Open c_input_value;
334: Fetch c_input_value into l_input_value_id;
335: Close c_input_value;

Line 332: hr_utility.set_location('l_element_link_id'||l_element_link_id, 100);

328: IF l_element_name = 'FR_LAST_DAY_WORKED' THEN
329:
330: hr_utility.set_location('l_elemen_type_id'||l_element_type_id, 100);
331: hr_utility.set_location('l_assignment_id'||l_assignment_id, 100);
332: hr_utility.set_location('l_element_link_id'||l_element_link_id, 100);
333: Open c_input_value;
334: Fetch c_input_value into l_input_value_id;
335: Close c_input_value;
336: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);

Line 336: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);

332: hr_utility.set_location('l_element_link_id'||l_element_link_id, 100);
333: Open c_input_value;
334: Fetch c_input_value into l_input_value_id;
335: Close c_input_value;
336: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);
337: hr_utility.set_location('LWD'|| p_last_day_worked, 100);
338: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
339: IF l_input_value_id IS NOT NULL THEN
340: hr_utility.set_location('DT Updating EE ', 100);

Line 337: hr_utility.set_location('LWD'|| p_last_day_worked, 100);

333: Open c_input_value;
334: Fetch c_input_value into l_input_value_id;
335: Close c_input_value;
336: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);
337: hr_utility.set_location('LWD'|| p_last_day_worked, 100);
338: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
339: IF l_input_value_id IS NOT NULL THEN
340: hr_utility.set_location('DT Updating EE ', 100);
341: IF p_last_day_worked < p_actual_termination_date THEN

Line 338: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);

334: Fetch c_input_value into l_input_value_id;
335: Close c_input_value;
336: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);
337: hr_utility.set_location('LWD'|| p_last_day_worked, 100);
338: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
339: IF l_input_value_id IS NOT NULL THEN
340: hr_utility.set_location('DT Updating EE ', 100);
341: IF p_last_day_worked < p_actual_termination_date THEN
342: hr_utility.set_location('Updating EE with LWD date='|| (p_last_day_worked + 1), 100);

Line 340: hr_utility.set_location('DT Updating EE ', 100);

336: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);
337: hr_utility.set_location('LWD'|| p_last_day_worked, 100);
338: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
339: IF l_input_value_id IS NOT NULL THEN
340: hr_utility.set_location('DT Updating EE ', 100);
341: IF p_last_day_worked < p_actual_termination_date THEN
342: hr_utility.set_location('Updating EE with LWD date='|| (p_last_day_worked + 1), 100);
343: hr_entry_api.update_element_entry
344: (p_dt_update_mode => 'UPDATE'

Line 342: hr_utility.set_location('Updating EE with LWD date='|| (p_last_day_worked + 1), 100);

338: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
339: IF l_input_value_id IS NOT NULL THEN
340: hr_utility.set_location('DT Updating EE ', 100);
341: IF p_last_day_worked < p_actual_termination_date THEN
342: hr_utility.set_location('Updating EE with LWD date='|| (p_last_day_worked + 1), 100);
343: hr_entry_api.update_element_entry
344: (p_dt_update_mode => 'UPDATE'
345: ,p_session_date => p_last_day_worked + 1
346: ,p_element_entry_id => l_element_entry_id

Line 353: hr_utility.set_location('Updating EE with ATD date='||(p_actual_termination_date + 1), 100);

349: ,p_entry_value1 => '2'
350: );
351: END IF;
352: -- Bug #2884200
353: hr_utility.set_location('Updating EE with ATD date='||(p_actual_termination_date + 1), 100);
354: -- Bug#6003309
355: hr_utility.set_location('Checking if ATD = FPD', 100);
356: IF p_actual_termination_date <> l_effective_end_date THEN
357: hr_entry_api.update_element_entry

Line 355: hr_utility.set_location('Checking if ATD = FPD', 100);

351: END IF;
352: -- Bug #2884200
353: hr_utility.set_location('Updating EE with ATD date='||(p_actual_termination_date + 1), 100);
354: -- Bug#6003309
355: hr_utility.set_location('Checking if ATD = FPD', 100);
356: IF p_actual_termination_date <> l_effective_end_date THEN
357: hr_entry_api.update_element_entry
358: (p_dt_update_mode => 'UPDATE'
359: ,p_session_date => p_actual_termination_date + 1

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

370: end if; -- if l_element_type_id is not null
371: END LOOP;
372: CLOSE c_element;
373: --
374: hr_utility.set_location(l_proc,40);
375: --
376: end last_day_worked_entry;
377: --
378: /* -------------------------------------------------------------------------

Line 421: hr_utility.set_location(l_proc,10);

417: and ast.per_system_status <> 'TERM_ASSIGN'
418: and a.soft_coding_keyflex_id = scl.soft_coding_keyflex_id (+);
419: --
420: begin
421: hr_utility.set_location(l_proc,10);
422: --
423: -- Process assignments ending on Actual Termination Date - set End Reason
424: --
425: if p_leaving_reason is null or

Line 433: hr_utility.trace(a.assignment_id);

429: l_leaving_reason := p_leaving_reason;
430: end if;
431: --
432: for a in c_get_asg loop
433: hr_utility.trace(a.assignment_id);
434: hr_utility.trace(p_period_of_service_id);
435: hr_utility.trace(p_actual_termination_date);
436: l_object_version_number := a.object_version_number;
437: hr_assignment_api.update_emp_asg

Line 434: hr_utility.trace(p_period_of_service_id);

430: end if;
431: --
432: for a in c_get_asg loop
433: hr_utility.trace(a.assignment_id);
434: hr_utility.trace(p_period_of_service_id);
435: hr_utility.trace(p_actual_termination_date);
436: l_object_version_number := a.object_version_number;
437: hr_assignment_api.update_emp_asg
438: (P_VALIDATE => FALSE

Line 435: hr_utility.trace(p_actual_termination_date);

431: --
432: for a in c_get_asg loop
433: hr_utility.trace(a.assignment_id);
434: hr_utility.trace(p_period_of_service_id);
435: hr_utility.trace(p_actual_termination_date);
436: l_object_version_number := a.object_version_number;
437: hr_assignment_api.update_emp_asg
438: (P_VALIDATE => FALSE
439: ,P_EFFECTIVE_DATE => p_actual_termination_date

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

450: ,P_NO_MANAGERS_WARNING => l_no_managers_warning
451: ,P_OTHER_MANAGER_WARNING => l_other_manager_warning);
452: end loop;
453: --
454: hr_utility.set_location(l_proc,20);
455: end correct_assignment;
456: --
457:
458: --

Line 479: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

475: begin
476:
477: --
478: /* Added for GSI Bug 5472781 */
479: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
480: hr_utility.set_location('Leaving : '||l_proc , 10);
481: return;
482: END IF;
483: --

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

476:
477: --
478: /* Added for GSI Bug 5472781 */
479: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
480: hr_utility.set_location('Leaving : '||l_proc , 10);
481: return;
482: END IF;
483: --
484: hr_utility.set_location(l_proc,10);

Line 484: hr_utility.set_location(l_proc,10);

480: hr_utility.set_location('Leaving : '||l_proc , 10);
481: return;
482: END IF;
483: --
484: hr_utility.set_location(l_proc,10);
485: hr_utility.trace('Actually Terminating');
486: open c_get_pds;
487: fetch c_get_pds into l_leaving_reason;
488: close c_get_pds;

Line 485: hr_utility.trace('Actually Terminating');

481: return;
482: END IF;
483: --
484: hr_utility.set_location(l_proc,10);
485: hr_utility.trace('Actually Terminating');
486: open c_get_pds;
487: fetch c_get_pds into l_leaving_reason;
488: close c_get_pds;
489: --

Line 493: hr_utility.set_location(l_proc,20);

489: --
490: correct_assignment(p_period_of_service_id
491: ,p_actual_termination_date
492: ,l_leaving_reason);
493: hr_utility.set_location(l_proc,20);
494: end;
495: --
496: /* -------------------------------------------------------------------------
497: External procedure called from Termination API Row Handler After Update

Line 610: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

606:
607: begin
608: --
609: /* Added for GSI Bug 5472781 */
610: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
611: hr_utility.set_location('Leaving : '||l_proc , 10);
612: return;
613: END IF;
614: --

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

607: begin
608: --
609: /* Added for GSI Bug 5472781 */
610: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
611: hr_utility.set_location('Leaving : '||l_proc , 10);
612: return;
613: END IF;
614: --
615: hr_utility.set_location(l_proc,10);

Line 615: hr_utility.set_location(l_proc,10);

611: hr_utility.set_location('Leaving : '||l_proc , 10);
612: return;
613: END IF;
614: --
615: hr_utility.set_location(l_proc,10);
616: --
617: -- Initiate Person ID package variable
618: --
619: initiate(p_period_of_service_id);

Line 639: hr_utility.set_location(l_proc,20);

635: -- ATD
636: --
637: -- This needs to take into account future changes to contract
638: --
639: hr_utility.set_location(l_proc,20);
640: if l_atd_changed then
641: l_effective_date := p_actual_termination_date + 1;
642: for c in c_get_ctr loop
643: l_object_version_number := c.object_version_number;

Line 655: hr_utility.trace(c.contract_id||' '||l_update_mode);

651: end if;
652: --
653: -- Create or update contract on day after ATD
654: --
655: hr_utility.trace(c.contract_id||' '||l_update_mode);
656: hr_contract_api.update_contract
657: (P_VALIDATE => FALSE
658: ,P_CONTRACT_ID => c.contract_id
659: ,P_EFFECTIVE_START_DATE => l_effective_start_date

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

686: -- reason after termination )
687: -- It is therefore safe to assume that there will be Assignment
688: -- records ending on the ATD. These records will have a datetrack CORRECTION.
689: --
690: hr_utility.set_location(l_proc,30);
691: if p_actual_termination_date is not null and
692: (not l_atd_changed) and l_leaving_reason_changed then
693: --
694: correct_assignment(p_period_of_service_id

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

716: --
717: if p_actual_termination_date is not null and
718: ((l_atd_changed and p_leaving_reason is not null) or
719: (l_leaving_reason_changed )) then
720: hr_utility.set_location(l_proc,40);
721: if p_leaving_reason is null or
722: not validate_leaving_reason('CONTRACT_END_REASON',p_leaving_reason) then
723: l_leaving_reason := null;
724: else

Line 731: hr_utility.trace(c.contract_id);

727: --
728: l_effective_date := p_actual_termination_date;
729: for c in c_get_ctr loop
730: if p_actual_termination_date = c.effective_end_date then
731: hr_utility.trace(c.contract_id);
732: l_object_version_number := c.object_version_number;
733: hr_contract_api.update_contract
734: (P_VALIDATE => FALSE
735: ,P_CONTRACT_ID => c.contract_id

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

750: -- Now handle creation of Last Day Worked Element Entry
751: -- The element should be created if ATD is not null and LWD is not null
752: -- and either LWD has been updated or termination is taking place.
753: --
754: hr_utility.set_location(l_proc,50);
755: if p_actual_termination_date is not null
756: and l_last_day_worked is not null
757: and (l_lwd_changed or l_atd_changed) then
758: last_day_worked_entry(l_last_day_worked

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

758: last_day_worked_entry(l_last_day_worked
759: ,p_actual_termination_date);
760: end if; -- if p_actual_termination_date is not null
761: --
762: hr_utility.set_location(l_proc,60);
763: end termination;
764: --
765: procedure reverse
766: (p_period_of_service_id number

Line 835: hr_utility.set_location(l_proc,10);

831: --
832: ctr2 c_get_ctr2%rowtype;
833: --
834: begin
835: hr_utility.set_location(l_proc,10);
836: initiate(p_period_of_service_id);
837: --
838: -- On reversing a terination update the assignment record that ended
839: -- at ATD to set the ending reason to NULL

Line 859: hr_utility.set_location(l_proc,20);

855: ,P_EFFECTIVE_END_DATE => l_effective_end_date
856: ,P_NO_MANAGERS_WARNING => l_no_managers_warning
857: ,P_OTHER_MANAGER_WARNING => l_other_manager_warning);
858: end loop;
859: hr_utility.set_location(l_proc,20);
860: /*
861: --
862: -- On reversing a terination update the contract record that started
863: -- on the day after ATD, set status back to Active

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

892: close c_get_status;
893: end if;
894: end if; -- if c.effective_start_date = l_effective_date
895: end loop;
896: hr_utility.set_location(l_proc,30);
897: */
898: --
899: --
900: -- On reversing a terination update the contract record that ended

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

944: else
945: close c_get_ctr2;
946: end if;
947: end loop;
948: hr_utility.set_location(l_proc,40);
949: --
950: -- Delete the FR_LAST_DAY_WORKED element entry that exists on ATD
951: --
952: last_day_worked_entry(null

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

951: --
952: last_day_worked_entry(null
953: ,p_actual_termination_date);
954:
955: hr_utility.set_location(l_proc,50);
956: end reverse;
957: --
958:
959: FUNCTION npil_earnings_base_12months (p_assignment_id in Number,