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.IRC_GLOBAL_REMAP_PKG dependencies on HR_UTILITY

Line 155: hr_utility.set_location('Entering Remap employee:'||l_proc, 10);

151: and paf.creation_date > per2.creation_date);
152:
153: begin
154: --
155: hr_utility.set_location('Entering Remap employee:'||l_proc, 10);
156: --
157: if (p_person_id is not null) then
158: hr_utility.set_location('Entering Address updation:'||l_proc, 20);
159: --

Line 158: hr_utility.set_location('Entering Address updation:'||l_proc, 20);

154: --
155: hr_utility.set_location('Entering Remap employee:'||l_proc, 10);
156: --
157: if (p_person_id is not null) then
158: hr_utility.set_location('Entering Address updation:'||l_proc, 20);
159: --
160: -- Addresses Updation
161: --
162: for c_add_rec in csr_address loop

Line 167: hr_utility.set_location('Updating address:'||l_proc, 25);

163: l_add_ovn := c_add_rec.object_version_number;
164: --
165: -- Call to address row handler
166: --
167: hr_utility.set_location('Updating address:'||l_proc, 25);
168: per_add_upd.upd
169: (p_address_id => c_add_rec.address_id
170: ,p_person_id => p_person_id
171: ,p_business_group_id => c_add_rec.bg_id

Line 176: hr_utility.set_location('Leaving Address updation:'||l_proc, 30);

172: ,p_object_version_number => l_add_ovn
173: ,p_effective_date => p_effective_date
174: );
175: end loop;
176: hr_utility.set_location('Leaving Address updation:'||l_proc, 30);
177: --
178: -- Phones Updation
179: --
180: hr_utility.set_location('Entering Phones updation:'||l_proc, 40);

Line 180: hr_utility.set_location('Entering Phones updation:'||l_proc, 40);

176: hr_utility.set_location('Leaving Address updation:'||l_proc, 30);
177: --
178: -- Phones Updation
179: --
180: hr_utility.set_location('Entering Phones updation:'||l_proc, 40);
181: for c_phn_rec in csr_phones loop
182: l_phn_ovn := c_phn_rec.object_version_number;
183: --
184: -- call to phones row handler

Line 186: hr_utility.set_location('Updating phones:'||l_proc, 45);

182: l_phn_ovn := c_phn_rec.object_version_number;
183: --
184: -- call to phones row handler
185: --
186: hr_utility.set_location('Updating phones:'||l_proc, 45);
187: per_phn_upd.upd
188: (p_phone_id => c_phn_rec.phone_id
189: ,p_parent_id => p_person_id
190: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 195: hr_utility.set_location('Leaving Phones updation:'||l_proc, 50);

191: ,p_object_version_number => l_phn_ovn
192: ,p_effective_date => p_effective_date
193: );
194: end loop;
195: hr_utility.set_location('Leaving Phones updation:'||l_proc, 50);
196: --
197: -- Previous Employment Updation
198: --
199: hr_utility.set_location('Entering Previous Employment updation:'||l_proc, 60);

Line 199: hr_utility.set_location('Entering Previous Employment updation:'||l_proc, 60);

195: hr_utility.set_location('Leaving Phones updation:'||l_proc, 50);
196: --
197: -- Previous Employment Updation
198: --
199: hr_utility.set_location('Entering Previous Employment updation:'||l_proc, 60);
200: for c_pem_rec in csr_prev_emp loop
201: l_prev_emp_ovn := c_pem_rec.object_version_number;
202: --
203: -- call to previous employer row handler

Line 205: hr_utility.set_location('Updating previous employment:'||l_proc, 65);

201: l_prev_emp_ovn := c_pem_rec.object_version_number;
202: --
203: -- call to previous employer row handler
204: --
205: hr_utility.set_location('Updating previous employment:'||l_proc, 65);
206: per_pem_upd.upd
207: (p_effective_date => p_effective_date
208: ,p_person_id => p_person_id
209: ,p_previous_employer_id => c_pem_rec.previous_employer_id

Line 214: hr_utility.set_location('Leaving Previous Employment updation:'||l_proc, 70);

210: ,p_object_version_number => l_prev_emp_ovn
211: ,p_business_group_id => c_pem_rec.bg_id
212: );
213: end loop;
214: hr_utility.set_location('Leaving Previous Employment updation:'||l_proc, 70);
215: --
216: -- Qualifications Updation
217: --
218: hr_utility.set_location('Entering Qualifications updation:'||l_proc, 80);

Line 218: hr_utility.set_location('Entering Qualifications updation:'||l_proc, 80);

214: hr_utility.set_location('Leaving Previous Employment updation:'||l_proc, 70);
215: --
216: -- Qualifications Updation
217: --
218: hr_utility.set_location('Entering Qualifications updation:'||l_proc, 80);
219: for c_qua_rec in csr_qual loop
220: l_qua_ovn := c_qua_rec.object_version_number;
221: --
222: -- call to qualifications row handler

Line 224: hr_utility.set_location('Updating qualifications:'||l_proc, 85);

220: l_qua_ovn := c_qua_rec.object_version_number;
221: --
222: -- call to qualifications row handler
223: --
224: hr_utility.set_location('Updating qualifications:'||l_proc, 85);
225: per_qua_upd.upd
226: (p_qualification_id => c_qua_rec.qualification_id
227: ,p_object_version_number => l_qua_ovn
228: ,p_person_id => p_person_id

Line 233: hr_utility.set_location('Leaving Qualifications updation:'||l_proc, 90);

229: ,p_effective_date => p_effective_date
230: ,p_business_group_id => c_qua_rec.bg_id
231: );
232: end loop;
233: hr_utility.set_location('Leaving Qualifications updation:'||l_proc, 90);
234: --
235: -- Establishment Attendances Updation
236: --
237: hr_utility.set_location('Entering Establishment Attendances updation:'||l_proc, 100);

Line 237: hr_utility.set_location('Entering Establishment Attendances updation:'||l_proc, 100);

233: hr_utility.set_location('Leaving Qualifications updation:'||l_proc, 90);
234: --
235: -- Establishment Attendances Updation
236: --
237: hr_utility.set_location('Entering Establishment Attendances updation:'||l_proc, 100);
238: for c_esa_rec in csr_estab_attend loop
239: l_esa_ovn := c_esa_rec.object_version_number;
240: --
241: -- call to establishment attendances row handler

Line 243: hr_utility.set_location('Updating establishment attendances:'||l_proc, 105);

239: l_esa_ovn := c_esa_rec.object_version_number;
240: --
241: -- call to establishment attendances row handler
242: --
243: hr_utility.set_location('Updating establishment attendances:'||l_proc, 105);
244: per_esa_upd.upd
245: (p_attendance_id => c_esa_rec.attendance_id
246: ,p_business_group_id => c_esa_rec.bg_id
247: ,p_object_version_number => l_esa_ovn

Line 252: hr_utility.set_location('Leaving Establishment Attendances updation:'||l_proc, 110);

248: ,p_person_id => p_person_id
249: ,p_effective_date => p_effective_date
250: );
251: end loop;
252: hr_utility.set_location('Leaving Establishment Attendances updation:'||l_proc, 110);
253: --
254: else
255: --
256: -- Update all employee records

Line 258: hr_utility.set_location('Entering All Addresses updation:'||l_proc, 120);

254: else
255: --
256: -- Update all employee records
257: --
258: hr_utility.set_location('Entering All Addresses updation:'||l_proc, 120);
259: --
260: -- Addresses Updation
261: --
262: for c_add_rec in csr_all_address loop

Line 264: hr_utility.set_location('Updating address:'||l_proc, 125);

260: -- Addresses Updation
261: --
262: for c_add_rec in csr_all_address loop
263: l_add_ovn := c_add_rec.object_version_number;
264: hr_utility.set_location('Updating address:'||l_proc, 125);
265: --
266: -- Call to address row handler
267: --
268: per_add_upd.upd

Line 276: hr_utility.set_location('Leaving All Addresses updation:'||l_proc, 130);

272: ,p_object_version_number => l_add_ovn
273: ,p_effective_date => p_effective_date
274: );
275: end loop;
276: hr_utility.set_location('Leaving All Addresses updation:'||l_proc, 130);
277: --
278: -- Phones Updation
279: --
280: hr_utility.set_location('Entering All Phones updation:'||l_proc, 140);

Line 280: hr_utility.set_location('Entering All Phones updation:'||l_proc, 140);

276: hr_utility.set_location('Leaving All Addresses updation:'||l_proc, 130);
277: --
278: -- Phones Updation
279: --
280: hr_utility.set_location('Entering All Phones updation:'||l_proc, 140);
281: for c_phn_rec in csr_all_phones loop
282: l_phn_ovn := c_phn_rec.object_version_number;
283: --
284: -- call to phones row handler

Line 286: hr_utility.set_location('Updating phones:'||l_proc, 145);

282: l_phn_ovn := c_phn_rec.object_version_number;
283: --
284: -- call to phones row handler
285: --
286: hr_utility.set_location('Updating phones:'||l_proc, 145);
287: per_phn_upd.upd
288: (p_phone_id => c_phn_rec.phone_id
289: ,p_parent_id => c_phn_rec.paf_person_id
290: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 295: hr_utility.set_location('Leaving All Phones updation:'||l_proc, 150);

291: ,p_object_version_number => l_phn_ovn
292: ,p_effective_date => p_effective_date
293: );
294: end loop;
295: hr_utility.set_location('Leaving All Phones updation:'||l_proc, 150);
296: --
297: -- Previous Employment Updation
298: --
299: hr_utility.set_location('Entering All Previous Employment updation:'||l_proc, 160);

Line 299: hr_utility.set_location('Entering All Previous Employment updation:'||l_proc, 160);

295: hr_utility.set_location('Leaving All Phones updation:'||l_proc, 150);
296: --
297: -- Previous Employment Updation
298: --
299: hr_utility.set_location('Entering All Previous Employment updation:'||l_proc, 160);
300: for c_pem_rec in csr_all_prev_emp loop
301: l_prev_emp_ovn := c_pem_rec.object_version_number;
302: --
303: -- call to previous employer row handler

Line 305: hr_utility.set_location('Updating previous employment:'||l_proc, 165);

301: l_prev_emp_ovn := c_pem_rec.object_version_number;
302: --
303: -- call to previous employer row handler
304: --
305: hr_utility.set_location('Updating previous employment:'||l_proc, 165);
306: per_pem_upd.upd
307: (p_effective_date => p_effective_date
308: ,p_person_id => c_pem_rec.paf_person_id
309: ,p_previous_employer_id => c_pem_rec.previous_employer_id

Line 314: hr_utility.set_location('Leaving All Previous Employment updation:'||l_proc, 170);

310: ,p_object_version_number => l_prev_emp_ovn
311: ,p_business_group_id => c_pem_rec.bg_id
312: );
313: end loop;
314: hr_utility.set_location('Leaving All Previous Employment updation:'||l_proc, 170);
315: --
316: -- Qualifications Updation
317: --
318: hr_utility.set_location('Entering All Qualifications updation:'||l_proc, 180);

Line 318: hr_utility.set_location('Entering All Qualifications updation:'||l_proc, 180);

314: hr_utility.set_location('Leaving All Previous Employment updation:'||l_proc, 170);
315: --
316: -- Qualifications Updation
317: --
318: hr_utility.set_location('Entering All Qualifications updation:'||l_proc, 180);
319: for c_qua_rec in csr_all_qual loop
320: l_qua_ovn := c_qua_rec.object_version_number;
321: --
322: -- call to qualifications row handler

Line 324: hr_utility.set_location('Updating qualifications:'||l_proc, 185);

320: l_qua_ovn := c_qua_rec.object_version_number;
321: --
322: -- call to qualifications row handler
323: --
324: hr_utility.set_location('Updating qualifications:'||l_proc, 185);
325: per_qua_upd.upd
326: (p_qualification_id => c_qua_rec.qualification_id
327: ,p_object_version_number => l_qua_ovn
328: ,p_person_id => c_qua_rec.paf_person_id

Line 333: hr_utility.set_location('Leaving All Qualifications updation:'||l_proc, 190);

329: ,p_effective_date => p_effective_date
330: ,p_business_group_id => c_qua_rec.bg_id
331: );
332: end loop;
333: hr_utility.set_location('Leaving All Qualifications updation:'||l_proc, 190);
334: --
335: -- Establishment Attendances Updation
336: --
337: hr_utility.set_location('Entering All Establishment Attendances updation:'||l_proc, 200);

Line 337: hr_utility.set_location('Entering All Establishment Attendances updation:'||l_proc, 200);

333: hr_utility.set_location('Leaving All Qualifications updation:'||l_proc, 190);
334: --
335: -- Establishment Attendances Updation
336: --
337: hr_utility.set_location('Entering All Establishment Attendances updation:'||l_proc, 200);
338: for c_esa_rec in csr_all_estab_attend loop
339: l_esa_ovn := c_esa_rec.object_version_number;
340: --
341: -- call to establishment attendances row handler

Line 343: hr_utility.set_location('Updating establishment attendances:'||l_proc, 205);

339: l_esa_ovn := c_esa_rec.object_version_number;
340: --
341: -- call to establishment attendances row handler
342: --
343: hr_utility.set_location('Updating establishment attendances:'||l_proc, 205);
344: per_esa_upd.upd
345: (p_attendance_id => c_esa_rec.attendance_id
346: ,p_object_version_number => l_esa_ovn
347: ,p_person_id => c_esa_rec.paf_person_id

Line 352: hr_utility.set_location('Leaving All Establishment Attendances updation:'||l_proc, 210);

348: ,p_business_group_id => c_esa_rec.bg_id
349: ,p_effective_date => p_effective_date
350: );
351: end loop;
352: hr_utility.set_location('Leaving All Establishment Attendances updation:'||l_proc, 210);
353: end if;
354: NULL;
355: --
356: end remap_employee;

Line 369: hr_utility.set_location('Entering Remap employee:'||l_proc, 10);

365: --
366: l_proc varchar2(72) := 'IRC_GLOBAL_REMAP_PKG.remap_employee';
367: --
368: begin
369: hr_utility.set_location('Entering Remap employee:'||l_proc, 10);
370: remap_employee
371: (p_person_id => p_person_id
372: ,p_effective_date => fnd_date.canonical_to_date(p_effective_date)
373: );

Line 376: hr_utility.set_location('Leaving Remap employee:'||l_proc, 20);

372: ,p_effective_date => fnd_date.canonical_to_date(p_effective_date)
373: );
374: commit;
375: retcode := 0;
376: hr_utility.set_location('Leaving Remap employee:'||l_proc, 20);
377: --
378: exception
379: when others then
380: rollback;