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: if p_actual_termination_date is not null
192: and p_last_day_worked is null then
193: hr_utility.set_message(800,'PER_75019_LWD_ATD_NULL');
194: hr_utility.raise_error;

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

189: --
190: hr_utility.set_location(l_proc,80);
191: if p_actual_termination_date is not null
192: and p_last_day_worked is null then
193: hr_utility.set_message(800,'PER_75019_LWD_ATD_NULL');
194: hr_utility.raise_error;
195: end if;
196: --
197: hr_utility.set_location(l_proc,90);

Line 194: hr_utility.raise_error;

190: hr_utility.set_location(l_proc,80);
191: if p_actual_termination_date is not null
192: and p_last_day_worked is null then
193: hr_utility.set_message(800,'PER_75019_LWD_ATD_NULL');
194: hr_utility.raise_error;
195: end if;
196: --
197: hr_utility.set_location(l_proc,90);
198: end validate;

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

193: hr_utility.set_message(800,'PER_75019_LWD_ATD_NULL');
194: hr_utility.raise_error;
195: end if;
196: --
197: hr_utility.set_location(l_proc,90);
198: end validate;
199: --
200: /* -------------------------------------------------------------------------
201: Local procedure to delete and create the element entry

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

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

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

275: close c_get_asg;
276: --
277: -- Remove any existing element entry effective as of ATD
278: --
279: hr_utility.set_location(l_proc,20);
280: open c_entry;
281: fetch c_entry into l_element_entry_id;
282: if c_entry%found then
283: hr_entry_api.delete_element_entry

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

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

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

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

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

322: --
323: IF l_element_name = 'FR_LAST_DAY_WORKED' THEN
324:
325: hr_utility.set_location('l_elemen_type_id'||l_element_type_id, 100);
326: hr_utility.set_location('l_assignment_id'||l_assignment_id, 100);
327: hr_utility.set_location('l_element_link_id'||l_element_link_id, 100);
328: Open c_input_value;
329: Fetch c_input_value into l_input_value_id;
330: Close c_input_value;

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

323: IF l_element_name = 'FR_LAST_DAY_WORKED' THEN
324:
325: hr_utility.set_location('l_elemen_type_id'||l_element_type_id, 100);
326: hr_utility.set_location('l_assignment_id'||l_assignment_id, 100);
327: hr_utility.set_location('l_element_link_id'||l_element_link_id, 100);
328: Open c_input_value;
329: Fetch c_input_value into l_input_value_id;
330: Close c_input_value;
331: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);

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

327: hr_utility.set_location('l_element_link_id'||l_element_link_id, 100);
328: Open c_input_value;
329: Fetch c_input_value into l_input_value_id;
330: Close c_input_value;
331: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);
332: hr_utility.set_location('LWD'|| p_last_day_worked, 100);
333: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
334: IF l_input_value_id IS NOT NULL THEN
335: hr_utility.set_location('DT Updating EE ', 100);

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

328: Open c_input_value;
329: Fetch c_input_value into l_input_value_id;
330: Close c_input_value;
331: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);
332: hr_utility.set_location('LWD'|| p_last_day_worked, 100);
333: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
334: IF l_input_value_id IS NOT NULL THEN
335: hr_utility.set_location('DT Updating EE ', 100);
336: IF p_last_day_worked < p_actual_termination_date THEN

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

329: Fetch c_input_value into l_input_value_id;
330: Close c_input_value;
331: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);
332: hr_utility.set_location('LWD'|| p_last_day_worked, 100);
333: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
334: IF l_input_value_id IS NOT NULL THEN
335: hr_utility.set_location('DT Updating EE ', 100);
336: IF p_last_day_worked < p_actual_termination_date THEN
337: hr_utility.set_location('Updating EE with LWD date='|| (p_last_day_worked + 1), 100);

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

331: hr_utility.set_location('l_input_value_id'||l_input_value_id, 100);
332: hr_utility.set_location('LWD'|| p_last_day_worked, 100);
333: hr_utility.set_location('ATD'|| p_actual_termination_date, 100);
334: IF l_input_value_id IS NOT NULL THEN
335: hr_utility.set_location('DT Updating EE ', 100);
336: IF p_last_day_worked < p_actual_termination_date THEN
337: hr_utility.set_location('Updating EE with LWD date='|| (p_last_day_worked + 1), 100);
338: hr_entry_api.update_element_entry
339: (p_dt_update_mode => 'UPDATE'

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

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

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

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

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

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

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

365: end if; -- if l_element_type_id is not null
366: END LOOP;
367: CLOSE c_element;
368: --
369: hr_utility.set_location(l_proc,40);
370: --
371: end last_day_worked_entry;
372: --
373: /* -------------------------------------------------------------------------

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

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

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

424: l_leaving_reason := p_leaving_reason;
425: end if;
426: --
427: for a in c_get_asg loop
428: hr_utility.trace(a.assignment_id);
429: hr_utility.trace(p_period_of_service_id);
430: hr_utility.trace(p_actual_termination_date);
431: l_object_version_number := a.object_version_number;
432: hr_assignment_api.update_emp_asg

Line 429: hr_utility.trace(p_period_of_service_id);

425: end if;
426: --
427: for a in c_get_asg loop
428: hr_utility.trace(a.assignment_id);
429: hr_utility.trace(p_period_of_service_id);
430: hr_utility.trace(p_actual_termination_date);
431: l_object_version_number := a.object_version_number;
432: hr_assignment_api.update_emp_asg
433: (P_VALIDATE => FALSE

Line 430: hr_utility.trace(p_actual_termination_date);

426: --
427: for a in c_get_asg loop
428: hr_utility.trace(a.assignment_id);
429: hr_utility.trace(p_period_of_service_id);
430: hr_utility.trace(p_actual_termination_date);
431: l_object_version_number := a.object_version_number;
432: hr_assignment_api.update_emp_asg
433: (P_VALIDATE => FALSE
434: ,P_EFFECTIVE_DATE => p_actual_termination_date

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

445: ,P_NO_MANAGERS_WARNING => l_no_managers_warning
446: ,P_OTHER_MANAGER_WARNING => l_other_manager_warning);
447: end loop;
448: --
449: hr_utility.set_location(l_proc,20);
450: end correct_assignment;
451: --
452:
453: --

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

470: begin
471:
472: --
473: /* Added for GSI Bug 5472781 */
474: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
475: hr_utility.set_location('Leaving : '||l_proc , 10);
476: return;
477: END IF;
478: --

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

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

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

475: hr_utility.set_location('Leaving : '||l_proc , 10);
476: return;
477: END IF;
478: --
479: hr_utility.set_location(l_proc,10);
480: hr_utility.trace('Actually Terminating');
481: open c_get_pds;
482: fetch c_get_pds into l_leaving_reason;
483: close c_get_pds;

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

476: return;
477: END IF;
478: --
479: hr_utility.set_location(l_proc,10);
480: hr_utility.trace('Actually Terminating');
481: open c_get_pds;
482: fetch c_get_pds into l_leaving_reason;
483: close c_get_pds;
484: --

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

484: --
485: correct_assignment(p_period_of_service_id
486: ,p_actual_termination_date
487: ,l_leaving_reason);
488: hr_utility.set_location(l_proc,20);
489: end;
490: --
491: /* -------------------------------------------------------------------------
492: External procedure called from Termination API Row Handler After Update

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

601:
602: begin
603: --
604: /* Added for GSI Bug 5472781 */
605: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
606: hr_utility.set_location('Leaving : '||l_proc , 10);
607: return;
608: END IF;
609: --

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

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

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

606: hr_utility.set_location('Leaving : '||l_proc , 10);
607: return;
608: END IF;
609: --
610: hr_utility.set_location(l_proc,10);
611: --
612: -- Initiate Person ID package variable
613: --
614: initiate(p_period_of_service_id);

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

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

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

646: end if;
647: --
648: -- Create or update contract on day after ATD
649: --
650: hr_utility.trace(c.contract_id||' '||l_update_mode);
651: hr_contract_api.update_contract
652: (P_VALIDATE => FALSE
653: ,P_CONTRACT_ID => c.contract_id
654: ,P_EFFECTIVE_START_DATE => l_effective_start_date

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

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

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

711: --
712: if p_actual_termination_date is not null and
713: ((l_atd_changed and p_leaving_reason is not null) or
714: (l_leaving_reason_changed )) then
715: hr_utility.set_location(l_proc,40);
716: if p_leaving_reason is null or
717: not validate_leaving_reason('CONTRACT_END_REASON',p_leaving_reason) then
718: l_leaving_reason := null;
719: else

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

722: --
723: l_effective_date := p_actual_termination_date;
724: for c in c_get_ctr loop
725: if p_actual_termination_date = c.effective_end_date then
726: hr_utility.trace(c.contract_id);
727: l_object_version_number := c.object_version_number;
728: hr_contract_api.update_contract
729: (P_VALIDATE => FALSE
730: ,P_CONTRACT_ID => c.contract_id

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

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

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

753: last_day_worked_entry(l_last_day_worked
754: ,p_actual_termination_date);
755: end if; -- if p_actual_termination_date is not null
756: --
757: hr_utility.set_location(l_proc,60);
758: end termination;
759: --
760: procedure reverse
761: (p_period_of_service_id number

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

826: --
827: ctr2 c_get_ctr2%rowtype;
828: --
829: begin
830: hr_utility.set_location(l_proc,10);
831: initiate(p_period_of_service_id);
832: --
833: -- On reversing a terination update the assignment record that ended
834: -- at ATD to set the ending reason to NULL

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

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

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

887: close c_get_status;
888: end if;
889: end if; -- if c.effective_start_date = l_effective_date
890: end loop;
891: hr_utility.set_location(l_proc,30);
892: */
893: --
894: --
895: -- On reversing a terination update the contract record that ended

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

939: else
940: close c_get_ctr2;
941: end if;
942: end loop;
943: hr_utility.set_location(l_proc,40);
944: --
945: -- Delete the FR_LAST_DAY_WORKED element entry that exists on ATD
946: --
947: last_day_worked_entry(null

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

946: --
947: last_day_worked_entry(null
948: ,p_actual_termination_date);
949:
950: hr_utility.set_location(l_proc,50);
951: end reverse;
952: --
953:
954: FUNCTION npil_earnings_base_12months (p_assignment_id in Number,