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

Line 40: hr_utility.set_location('Entering: '||l_proc, 10);

36: --
37: l_proc VARCHAR2(60) := 'pqp_log_alien_data_changes.check_for_changes';
38: --
39: BEGIN
40: hr_utility.set_location('Entering: '||l_proc, 10);
41: --
42: -- Log the events only if the process type is WINDSTAR
43: --
44: IF pqp_us_ff_functions.is_windstar

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

61: --
62: log_events(p_assignment_id => p_assignment_id
63: ,p_effective_date => p_effective_date);
64: --
65: hr_utility.set_location(l_proc, 20);
66: END IF;
67: END IF;
68: --
69: hr_utility.set_location('Leaving: '||l_proc, 10);

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

65: hr_utility.set_location(l_proc, 20);
66: END IF;
67: END IF;
68: --
69: hr_utility.set_location('Leaving: '||l_proc, 10);
70: --
71: END check_for_changes;
72: -----------------------------------------------------------------------------
73: -- ALIEN_ELEMENT_CHECK

Line 118: hr_utility.set_location('Entering: '||l_proc, 10);

114: --
115: l_proc VARCHAR2(60) := 'pqp_log_alien_data_changes.alien_element_check';
116: --
117: BEGIN
118: hr_utility.set_location('Entering: '||l_proc, 10);
119: --
120: l_exist:='N';
121: FOR c_element_rec in c_element LOOP
122: OPEN c_get_curent_code (p_assignment_id,

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

128: ,p_effective_date => p_effective_date);
129: END IF;
130: CLOSE c_get_curent_code;
131: --
132: hr_utility.set_location(l_proc, 20);
133: END LOOP;
134: hr_utility.set_location('Leaving: '||l_proc, 10);
135: --
136: END alien_element_check;

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

130: CLOSE c_get_curent_code;
131: --
132: hr_utility.set_location(l_proc, 20);
133: END LOOP;
134: hr_utility.set_location('Leaving: '||l_proc, 10);
135: --
136: END alien_element_check;
137: -----------------------------------------------------------------------------
138: -- PERSON_LEVEL_CHECK

Line 212: hr_utility.set_location('Entering: '||l_proc, 10);

208: AND NVL(l_session_date, sysdate) BETWEEN
209: effective_start_date AND effective_end_date;
210: --
211: BEGIN
212: hr_utility.set_location('Entering: '||l_proc, 10);
213: --
214: -- For address, log the changes only if the primary_flag = 'Y'
215: --
216: IF (p_table_name = 'PER_ADDRESSES' AND

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

214: -- For address, log the changes only if the primary_flag = 'Y'
215: --
216: IF (p_table_name = 'PER_ADDRESSES' AND
217: p_new_value_char1 = 'N') THEN
218: hr_utility.set_location(l_proc, 20);
219: -- do not do log changes if the address is secondary
220: ELSIF p_table_name = 'PER_PEOPLE_EXTRA_INFO' THEN
221: /*
222: * *** PLEASE NOTE the column mapping ***

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

231: * p_new_value_char9 = pei_information12
232: * p_new_value_char10 = pei_information13
233: */
234: IF p_new_value_char1 = 'PER_US_VISA_DETAILS' THEN
235: hr_utility.set_location(l_proc, 30);
236: l_new_char2 := p_new_value_char2; -- Visa type (info 5)
237: l_old_char2 := p_old_value_char2;
238: l_new_char3 := p_new_value_char3; -- Visa number (info 6)
239: l_old_char3 := p_old_value_char3;

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

244: l_new_char6 := p_new_value_char6; -- Visa category (info 9)
245: l_old_char6 := p_old_value_char6;
246: --
247: ELSIF p_new_value_char1 = 'PER_US_PASSPORT_DETAILS' THEN
248: hr_utility.set_location(l_proc, 40);
249: l_new_char2 := p_new_value_char2; -- country (info 5)
250: l_old_char2 := p_old_value_char2;
251: --
252: ELSIF p_new_value_char1 = 'PER_US_PAYROLL_DETAILS' THEN

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

249: l_new_char2 := p_new_value_char2; -- country (info 5)
250: l_old_char2 := p_old_value_char2;
251: --
252: ELSIF p_new_value_char1 = 'PER_US_PAYROLL_DETAILS' THEN
253: hr_utility.set_location(l_proc, 50);
254: l_new_char2 := p_new_value_char2; -- Income code (info 5)
255: l_old_char2 := p_old_value_char2;
256: l_new_char3 := p_new_value_char3; -- Prev ER treaty ben amt(info 6)
257: l_old_char3 := p_old_value_char3;

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

258: l_new_char4 := p_new_value_char4; -- Prev ER treaty ben year (info 7)
259: l_old_char4 := p_old_value_char4;
260: --
261: ELSIF p_new_value_char1 = 'PER_US_ADDITIONAL_DETAILS' THEN
262: hr_utility.set_location(l_proc, 60);
263: l_new_char2 := p_new_value_char2; -- Residency Status (info 5)
264: l_old_char2 := p_old_value_char2;
265: l_new_char3 := p_new_value_char4; -- Resident Status Date (info 8)
266: l_old_char3 := p_old_value_char4;

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

273: --
274: END IF;
275: -- call for each assignment
276: FOR c_rec in c_assign LOOP
277: hr_utility.set_location(l_proc, 70);
278: --
279: FOR c_rec in c_session LOOP
280: l_session_date := c_rec.effective_date;
281: END LOOP;

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

298: ,p_new_value_char7 => l_new_char7
299: ,p_old_value_char7 => l_old_char7 );
300: END LOOP;
301: ELSE
302: hr_utility.set_location(l_proc, 80);
303: IF l_session_date IS NULL THEN
304: FOR c_rec in c_session LOOP
305: hr_utility.set_location(l_proc, 90);
306: l_session_date := c_rec.effective_date;

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

301: ELSE
302: hr_utility.set_location(l_proc, 80);
303: IF l_session_date IS NULL THEN
304: FOR c_rec in c_session LOOP
305: hr_utility.set_location(l_proc, 90);
306: l_session_date := c_rec.effective_date;
307: END LOOP;
308: END IF;
309: --

Line 311: hr_utility.set_location(l_proc, 100);

307: END LOOP;
308: END IF;
309: --
310: FOR c_rec in c_assign LOOP
311: hr_utility.set_location(l_proc, 100);
312: check_for_changes(p_assignment_id => c_rec.assignment_id
313: ,p_person_id => p_person_id
314: ,p_effective_date => l_session_date
315: ,p_new_value_char1 => p_new_value_char1

Line 340: hr_utility.set_location(l_proc, 110);

336: ,p_old_value_date1 => p_old_value_date1
337: ,p_new_value_date2 => p_new_value_date2
338: ,p_old_value_date2 => p_old_value_date2 );
339: --
340: hr_utility.set_location(l_proc, 110);
341: END LOOP;
342: END IF;
343: hr_utility.set_location('Leaving: '||l_proc, 150);
344: --

Line 343: hr_utility.set_location('Leaving: '||l_proc, 150);

339: --
340: hr_utility.set_location(l_proc, 110);
341: END LOOP;
342: END IF;
343: hr_utility.set_location('Leaving: '||l_proc, 150);
344: --
345: END person_level_check;
346: -----------------------------------------------------------------------------
347: -- LOG_EVENTS

Line 368: hr_utility.set_location('Entering: '||l_proc, 10);

364: l_dummy2 number;
365: l_proc VARCHAR2(60) := 'pqp_log_alien_data_changes.log_events';
366: --
367: BEGIN
368: hr_utility.set_location('Entering: '||l_proc, 10);
369: --
370: OPEN c_asg_exists;
371: FETCH c_asg_exists into l_temp;
372: IF c_asg_exists%NOTFOUND THEN

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

381: ,p_description => 'PQP event logging'
382: ,p_process_event_id => l_dummy1
383: ,p_object_version_number => l_dummy2 );
384: --
385: hr_utility.set_location(l_proc, 20);
386: --
387: EXCEPTION
388: WHEN OTHERS THEN
389: hr_utility.set_location(l_proc, 50);

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

385: hr_utility.set_location(l_proc, 20);
386: --
387: EXCEPTION
388: WHEN OTHERS THEN
389: hr_utility.set_location(l_proc, 50);
390: raise;
391: END;
392: END IF;
393: CLOSE c_asg_exists;

Line 395: hr_utility.set_location('Leaving: '||l_proc, 100);

391: END;
392: END IF;
393: CLOSE c_asg_exists;
394: --
395: hr_utility.set_location('Leaving: '||l_proc, 100);
396: --
397: END log_events;
398: -----------------------------------------------------------------------------
399: -- LOG_PEI_INSERT_CHANGES

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

417: --
418: l_proc VARCHAR2(60) := 'pqp_log_alien_data_changes.log_pei_insert_changes';
419: --
420: BEGIN
421: hr_utility.set_location('Entering: '||l_proc, 10);
422: --
423: person_level_check
424: (p_person_id => p_person_id
425: ,p_table_name => 'PER_PEOPLE_EXTRA_INFO'

Line 448: hr_utility.set_location('Leaving: '||l_proc, 20);

444: ,p_old_value_char9 => NULL
445: ,p_new_value_char10 => p_pei_information13
446: ,p_old_value_char10 => NULL );
447: --
448: hr_utility.set_location('Leaving: '||l_proc, 20);
449: --
450: END log_pei_insert_changes;
451: -----------------------------------------------------------------------------
452: -- LOG_PEI_UPDATE_CHANGES

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

476: --
477: l_proc VARCHAR2(60) := 'pqp_log_alien_data_changes.log_pei_update_changes';
478: --
479: BEGIN
480: hr_utility.set_location('Entering: '||l_proc, 10);
481: --
482: person_level_check
483: (p_person_id => p_person_id
484: ,p_table_name => 'PER_PEOPLE_EXTRA_INFO'

Line 507: hr_utility.set_location('Leaving: '||l_proc, 20);

503: ,p_old_value_char9 => p_pei_information12_o
504: ,p_new_value_char10 => p_pei_information13
505: ,p_old_value_char10 => p_pei_information13_o );
506: --
507: hr_utility.set_location('Leaving: '||l_proc, 20);
508: --
509: END log_pei_update_changes;
510: --
511: END pqp_log_alien_data_changes;