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

Line 46: if ( hr_utility.debug_enabled()) then

42: begin
43:
44: l_proc := g_package||'.get_people_ei_id_ason_date';
45:
46: if ( hr_utility.debug_enabled()) then
47: hr_utility.set_location('Entering... ' ||l_proc,1000);
48: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
49: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
50: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

Line 47: hr_utility.set_location('Entering... ' ||l_proc,1000);

43:
44: l_proc := g_package||'.get_people_ei_id_ason_date';
45:
46: if ( hr_utility.debug_enabled()) then
47: hr_utility.set_location('Entering... ' ||l_proc,1000);
48: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
49: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
50: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
51: End if;

Line 48: hr_utility.set_location('Person_id : ' || p_person_id, 1000);

44: l_proc := g_package||'.get_people_ei_id_ason_date';
45:
46: if ( hr_utility.debug_enabled()) then
47: hr_utility.set_location('Entering... ' ||l_proc,1000);
48: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
49: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
50: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
51: End if;
52:

Line 49: hr_utility.set_location('Information_type : ' || p_information_type, 1000);

45:
46: if ( hr_utility.debug_enabled()) then
47: hr_utility.set_location('Entering... ' ||l_proc,1000);
48: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
49: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
50: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
51: End if;
52:
53: for history_id_rec in c_history_id

Line 50: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

46: if ( hr_utility.debug_enabled()) then
47: hr_utility.set_location('Entering... ' ||l_proc,1000);
48: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
49: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
50: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
51: End if;
52:
53: for history_id_rec in c_history_id
54: loop

Line 59: hr_utility.set_location('history_id : ' || l_history_id, 1000);

55: l_history_id := history_id_rec.pa_history_id;
56: exit;
57: end loop;
58:
59: hr_utility.set_location('history_id : ' || l_history_id, 1000);
60:
61: return (l_history_id);
62:
63: end get_people_ei_id_ason_date;

Line 81: hr_utility.set_location('Entering... ' ||l_proc,1000);

77: l_effective_start_date date;
78: l_proc varchar2(50);
79: Begin
80: l_proc := g_package||'.get_ele_value_ason_date';
81: hr_utility.set_location('Entering... ' ||l_proc,1000);
82:
83: ghr_per_sum.get_element_details(p_ele_name,
84: p_input_name,
85: p_asg_id,

Line 92: hr_utility.set_location('Element input value : ' || l_screen_entry_value, 1000);

88: l_effective_start_date,
89: P_BUSINESS_GROUP_ID
90: );
91:
92: hr_utility.set_location('Element input value : ' || l_screen_entry_value, 1000);
93: return (l_screen_entry_value);
94:
95: End get_ele_value_ason_date;
96:

Line 112: hr_utility.set_location('Entering... ' ||l_proc,1000);

108: l_proc varchar2(100);
109: Begin
110:
111: l_proc := g_package||'.get_ele_entry_value_ason_date';
112: hr_utility.set_location('Entering... ' ||l_proc,1000);
113: ghr_per_sum.get_element_entry_values (p_element_entry_id
114: ,p_input_value_name
115: ,p_effective_date
116: ,l_value

Line 119: hr_utility.set_location('Element input value : ' || l_value, 1000);

115: ,p_effective_date
116: ,l_value
117: ,l_effective_start_date );
118:
119: hr_utility.set_location('Element input value : ' || l_value, 1000);
120: return (l_value);
121:
122: End get_ele_entry_value_ason_date;
123:

Line 190: if ( hr_utility.debug_enabled()) then

186: BEGIN
187:
188: l_proc := g_package||'.get_latest_pa_req_id';
189:
190: if ( hr_utility.debug_enabled()) then
191: hr_utility.set_location('Entering... ' ||l_proc,1000);
192: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
193: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
194: end if;

Line 191: hr_utility.set_location('Entering... ' ||l_proc,1000);

187:
188: l_proc := g_package||'.get_latest_pa_req_id';
189:
190: if ( hr_utility.debug_enabled()) then
191: hr_utility.set_location('Entering... ' ||l_proc,1000);
192: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
193: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
194: end if;
195:

Line 192: hr_utility.set_location('Person_id : ' || p_person_id, 1000);

188: l_proc := g_package||'.get_latest_pa_req_id';
189:
190: if ( hr_utility.debug_enabled()) then
191: hr_utility.set_location('Entering... ' ||l_proc,1000);
192: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
193: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
194: end if;
195:
196: for notification_id_rec in c_notification_id

Line 193: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

189:
190: if ( hr_utility.debug_enabled()) then
191: hr_utility.set_location('Entering... ' ||l_proc,1000);
192: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
193: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
194: end if;
195:
196: for notification_id_rec in c_notification_id
197: loop

Line 202: hr_utility.set_location('notification_id : ' || l_notification_id, 1000);

198: l_notification_id := notification_id_rec.notification_id;
199: exit;
200: end loop;
201:
202: hr_utility.set_location('notification_id : ' || l_notification_id, 1000);
203:
204: for pa_request_id_rec in c_request_id (l_notification_id)
205: loop
206: l_pa_request_id := pa_request_id_rec.pa_request_id;

Line 210: hr_utility.set_location('pa_request_id : ' || l_pa_request_id, 1000);

206: l_pa_request_id := pa_request_id_rec.pa_request_id;
207: exit;
208: end loop;
209:
210: hr_utility.set_location('pa_request_id : ' || l_pa_request_id, 1000);
211:
212: return (l_pa_request_id);
213:
214: END get_latest_pa_req_id;

Line 262: if ( hr_utility.debug_enabled()) then

258: Begin
259:
260: l_proc := g_package||'.get_latest_perf_rating';
261:
262: if ( hr_utility.debug_enabled()) then
263: hr_utility.set_location('Entering... ' ||l_proc,1000);
264: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
265: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
266: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);

Line 263: hr_utility.set_location('Entering... ' ||l_proc,1000);

259:
260: l_proc := g_package||'.get_latest_perf_rating';
261:
262: if ( hr_utility.debug_enabled()) then
263: hr_utility.set_location('Entering... ' ||l_proc,1000);
264: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
265: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
266: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);
267: end if;

Line 264: hr_utility.set_location('Person_id : ' || p_person_id, 1000);

260: l_proc := g_package||'.get_latest_perf_rating';
261:
262: if ( hr_utility.debug_enabled()) then
263: hr_utility.set_location('Entering... ' ||l_proc,1000);
264: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
265: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
266: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);
267: end if;
268:

Line 265: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

261:
262: if ( hr_utility.debug_enabled()) then
263: hr_utility.set_location('Entering... ' ||l_proc,1000);
264: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
265: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
266: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);
267: end if;
268:
269: If g_perf_flex_num is null THEN

Line 266: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);

262: if ( hr_utility.debug_enabled()) then
263: hr_utility.set_location('Entering... ' ||l_proc,1000);
264: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
265: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
266: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);
267: end if;
268:
269: If g_perf_flex_num is null THEN
270: for get_flex_num_rec in get_flex_num

Line 277: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 10);

273: exit;
274: End loop;
275: END IF;
276:
277: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 10);
278:
279: for get_latest_perf_rating_rec in get_latest_perf_rating
280: loop
281: l_perf_rating := get_latest_perf_rating_rec.rating_of_record;

Line 285: hr_utility.set_location('Performance rating : ' || l_perf_rating, 1000);

281: l_perf_rating := get_latest_perf_rating_rec.rating_of_record;
282: exit;
283: End loop;
284:
285: hr_utility.set_location('Performance rating : ' || l_perf_rating, 1000);
286:
287: return( l_perf_rating);
288:
289: End get_latest_perf_rating;

Line 339: hr_utility.set_location('PAYROLL User -- BSR -- from asgid-- '||l_proc, 1);

335: l_new_element_name := p_element_name;
336:
337: IF (p_element_name = 'Basic Salary Rate'
338: and (fnd_profile.value('HR_USER_TYPE') = 'INT')) THEN
339: hr_utility.set_location('PAYROLL User -- BSR -- from asgid-- '||l_proc, 1);
340: l_new_element_name :=
341: pqp_fedhr_uspay_int_utils.return_new_element_name(
342: p_assignment_id => p_assignment_id,
343: p_business_group_id => p_business_group_id,

Line 347: hr_utility.set_location('HR USER or PAYROLL User without BSR element -- from elt name -- '||l_proc, 1);

343: p_business_group_id => p_business_group_id,
344: p_effective_date => p_effective_date);
345:
346: ELSE
347: hr_utility.set_location('HR USER or PAYROLL User without BSR element -- from elt name -- '||l_proc, 1);
348: l_new_element_name :=
349: pqp_fedhr_uspay_int_utils.return_new_element_name(
350: p_fedhr_element_name => p_element_name,
351: p_business_group_id => p_business_group_id,

Line 357: if ( hr_utility.debug_enabled()) then

353: p_pay_basis => NULL);
354:
355: END IF;
356:
357: if ( hr_utility.debug_enabled()) then
358: hr_utility.set_location('Element Name ' ||p_element_name,1000);
359: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
360: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
361: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);

Line 358: hr_utility.set_location('Element Name ' ||p_element_name,1000);

354:
355: END IF;
356:
357: if ( hr_utility.debug_enabled()) then
358: hr_utility.set_location('Element Name ' ||p_element_name,1000);
359: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
360: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
361: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
362: end if;

Line 359: hr_utility.set_location('BG ID '|| p_business_group_id,2000);

355: END IF;
356:
357: if ( hr_utility.debug_enabled()) then
358: hr_utility.set_location('Element Name ' ||p_element_name,1000);
359: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
360: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
361: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
362: end if;
363:

Line 360: hr_utility.set_location('Eff date'|| p_effective_date ,3000);

356:
357: if ( hr_utility.debug_enabled()) then
358: hr_utility.set_location('Element Name ' ||p_element_name,1000);
359: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
360: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
361: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
362: end if;
363:
364: for c_ele_input_curr_code_rec in c_ele_input_curr_code

Line 361: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);

357: if ( hr_utility.debug_enabled()) then
358: hr_utility.set_location('Element Name ' ||p_element_name,1000);
359: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
360: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
361: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
362: end if;
363:
364: for c_ele_input_curr_code_rec in c_ele_input_curr_code
365: Loop

Line 370: hr_utility.set_location('Input currency code ' ||l_input_curr_code,100000);

366: l_input_curr_code := c_ele_input_curr_code_rec.input_curr_code;
367: exit;
368: End Loop;
369:
370: hr_utility.set_location('Input currency code ' ||l_input_curr_code,100000);
371:
372: return (l_input_curr_code);
373:
374: End retrieve_element_curr_code;

Line 393: if ( hr_utility.debug_enabled()) then

389: Begin
390:
391: l_proc := g_package||'.get_loc_pay_area_percentage';
392:
393: if ( hr_utility.debug_enabled()) then
394: hr_utility.set_location('Entering... ' ||l_proc,1000);
395: hr_utility.set_location('Location id : ' || p_location_id, 1000);
396: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
397: end if;

Line 394: hr_utility.set_location('Entering... ' ||l_proc,1000);

390:
391: l_proc := g_package||'.get_loc_pay_area_percentage';
392:
393: if ( hr_utility.debug_enabled()) then
394: hr_utility.set_location('Entering... ' ||l_proc,1000);
395: hr_utility.set_location('Location id : ' || p_location_id, 1000);
396: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
397: end if;
398:

Line 395: hr_utility.set_location('Location id : ' || p_location_id, 1000);

391: l_proc := g_package||'.get_loc_pay_area_percentage';
392:
393: if ( hr_utility.debug_enabled()) then
394: hr_utility.set_location('Entering... ' ||l_proc,1000);
395: hr_utility.set_location('Location id : ' || p_location_id, 1000);
396: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
397: end if;
398:
399: ghr_per_sum.get_duty_station_details (p_location_id

Line 396: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

392:
393: if ( hr_utility.debug_enabled()) then
394: hr_utility.set_location('Entering... ' ||l_proc,1000);
395: hr_utility.set_location('Location id : ' || p_location_id, 1000);
396: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
397: end if;
398:
399: ghr_per_sum.get_duty_station_details (p_location_id
400: ,p_effective_date

Line 406: hr_utility.set_location('locality pay area percentage : ' || l_locality_pay_area_percentage, 1000);

402: ,l_duty_station_desc
403: ,l_locality_pay_area
404: ,l_locality_pay_area_percentage ) ;
405:
406: hr_utility.set_location('locality pay area percentage : ' || l_locality_pay_area_percentage, 1000);
407: return (l_locality_pay_area_percentage);
408:
409: End get_loc_pay_area_percentage;
410:

Line 445: if ( hr_utility.debug_enabled()) then

441:
442: l_proc := g_package||'.check_if_awards_exists';
443: l_award_bonus := 'No' ;
444:
445: if ( hr_utility.debug_enabled()) then
446: hr_utility.set_location('Entering... ' ||l_proc,1000);
447: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
448: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
449: end if;

Line 446: hr_utility.set_location('Entering... ' ||l_proc,1000);

442: l_proc := g_package||'.check_if_awards_exists';
443: l_award_bonus := 'No' ;
444:
445: if ( hr_utility.debug_enabled()) then
446: hr_utility.set_location('Entering... ' ||l_proc,1000);
447: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
448: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
449: end if;
450:

Line 447: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);

443: l_award_bonus := 'No' ;
444:
445: if ( hr_utility.debug_enabled()) then
446: hr_utility.set_location('Entering... ' ||l_proc,1000);
447: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
448: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
449: end if;
450:
451: FOR award_check_rec IN award_check (p_assignment_id , p_effective_date)LOOP

Line 448: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);

444:
445: if ( hr_utility.debug_enabled()) then
446: hr_utility.set_location('Entering... ' ||l_proc,1000);
447: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
448: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
449: end if;
450:
451: FOR award_check_rec IN award_check (p_assignment_id , p_effective_date)LOOP
452: l_award_bonus := 'Yes';

Line 456: hr_utility.set_location('Check for Award : ' || l_award_bonus, 1004);

452: l_award_bonus := 'Yes';
453: EXIT;
454: END LOOP;
455:
456: hr_utility.set_location('Check for Award : ' || l_award_bonus, 1004);
457:
458: RETURN(l_award_bonus);
459:
460: END check_if_awards_exists;

Line 494: if ( hr_utility.debug_enabled()) then

490: BEGIN
491:
492: l_proc := g_package||'.check_if_bonus_exists';
493: l_award_bonus := 'No' ;
494: if ( hr_utility.debug_enabled()) then
495: hr_utility.set_location('Entering... ' ||l_proc,1000);
496: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
497: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
498: end if;

Line 495: hr_utility.set_location('Entering... ' ||l_proc,1000);

491:
492: l_proc := g_package||'.check_if_bonus_exists';
493: l_award_bonus := 'No' ;
494: if ( hr_utility.debug_enabled()) then
495: hr_utility.set_location('Entering... ' ||l_proc,1000);
496: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
497: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
498: end if;
499:

Line 496: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);

492: l_proc := g_package||'.check_if_bonus_exists';
493: l_award_bonus := 'No' ;
494: if ( hr_utility.debug_enabled()) then
495: hr_utility.set_location('Entering... ' ||l_proc,1000);
496: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
497: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
498: end if;
499:
500: FOR bonus_check_rec IN bonus_check (p_assignment_id , p_effective_date)LOOP

Line 497: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);

493: l_award_bonus := 'No' ;
494: if ( hr_utility.debug_enabled()) then
495: hr_utility.set_location('Entering... ' ||l_proc,1000);
496: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
497: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
498: end if;
499:
500: FOR bonus_check_rec IN bonus_check (p_assignment_id , p_effective_date)LOOP
501: l_award_bonus := 'Yes';

Line 506: hr_utility.set_location('Check for Bonus : ' || l_award_bonus, 1004);

502: EXIT;
503: END LOOP;
504:
505:
506: hr_utility.set_location('Check for Bonus : ' || l_award_bonus, 1004);
507:
508: RETURN(l_award_bonus);
509:
510: END check_if_bonus_exists;

Line 567: if ( hr_utility.debug_enabled()) then

563: Begin
564:
565: l_proc := g_package||'.get_asg_ei_id_ason_date';
566:
567: if ( hr_utility.debug_enabled()) then
568: hr_utility.set_location('Entering... ' ||l_proc,1000);
569: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
570: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
571: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

Line 568: hr_utility.set_location('Entering... ' ||l_proc,1000);

564:
565: l_proc := g_package||'.get_asg_ei_id_ason_date';
566:
567: if ( hr_utility.debug_enabled()) then
568: hr_utility.set_location('Entering... ' ||l_proc,1000);
569: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
570: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
571: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
572: End if;

Line 569: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);

565: l_proc := g_package||'.get_asg_ei_id_ason_date';
566:
567: if ( hr_utility.debug_enabled()) then
568: hr_utility.set_location('Entering... ' ||l_proc,1000);
569: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
570: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
571: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
572: End if;
573:

Line 570: hr_utility.set_location('Information_type : ' || p_information_type, 1000);

566:
567: if ( hr_utility.debug_enabled()) then
568: hr_utility.set_location('Entering... ' ||l_proc,1000);
569: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
570: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
571: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
572: End if;
573:
574: for history_id_rec in c_history_id loop

Line 571: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

567: if ( hr_utility.debug_enabled()) then
568: hr_utility.set_location('Entering... ' ||l_proc,1000);
569: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
570: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
571: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
572: End if;
573:
574: for history_id_rec in c_history_id loop
575: l_history_id := history_id_rec.pa_history_id;

Line 579: hr_utility.set_location('history_id : ' || l_history_id, 1000);

575: l_history_id := history_id_rec.pa_history_id;
576: exit;
577: end loop;
578:
579: hr_utility.set_location('history_id : ' || l_history_id, 1000);
580: return (l_history_id);
581:
582: End get_assignment_ei_id_ason_date;
583:

Line 619: if ( hr_utility.debug_enabled()) then

615: Begin
616:
617: l_proc := g_package||'.get_position_ei_id_ason_date';
618:
619: if ( hr_utility.debug_enabled()) then
620: hr_utility.set_location('Entering... ' ||l_proc,1000);
621: hr_utility.set_location('position_id : ' || p_position_id, 1000);
622: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
623: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

Line 620: hr_utility.set_location('Entering... ' ||l_proc,1000);

616:
617: l_proc := g_package||'.get_position_ei_id_ason_date';
618:
619: if ( hr_utility.debug_enabled()) then
620: hr_utility.set_location('Entering... ' ||l_proc,1000);
621: hr_utility.set_location('position_id : ' || p_position_id, 1000);
622: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
623: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
624: End if;

Line 621: hr_utility.set_location('position_id : ' || p_position_id, 1000);

617: l_proc := g_package||'.get_position_ei_id_ason_date';
618:
619: if ( hr_utility.debug_enabled()) then
620: hr_utility.set_location('Entering... ' ||l_proc,1000);
621: hr_utility.set_location('position_id : ' || p_position_id, 1000);
622: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
623: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
624: End if;
625:

Line 622: hr_utility.set_location('Information_type : ' || p_information_type, 1000);

618:
619: if ( hr_utility.debug_enabled()) then
620: hr_utility.set_location('Entering... ' ||l_proc,1000);
621: hr_utility.set_location('position_id : ' || p_position_id, 1000);
622: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
623: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
624: End if;
625:
626: for history_id_rec in c_history_id loop

Line 623: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

619: if ( hr_utility.debug_enabled()) then
620: hr_utility.set_location('Entering... ' ||l_proc,1000);
621: hr_utility.set_location('position_id : ' || p_position_id, 1000);
622: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
623: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
624: End if;
625:
626: for history_id_rec in c_history_id loop
627: l_history_id := history_id_rec.pa_history_id;

Line 631: hr_utility.set_location('history_id : ' || l_history_id, 1000);

627: l_history_id := history_id_rec.pa_history_id;
628: exit;
629: end loop;
630:
631: hr_utility.set_location('history_id : ' || l_history_id, 1000);
632:
633: return (l_history_id);
634:
635: end get_position_ei_id_ason_date;

Line 684: if (hr_utility.debug_enabled()) then

680: Begin
681:
682: l_proc := g_package || '.get_rating_of_record';
683:
684: if (hr_utility.debug_enabled()) then
685: hr_utility.set_location('Entering... ' || l_proc, 1001);
686: hr_utility.set_location('Person_id : ' || p_person_id, 1001);
687: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);
688: end if;

Line 685: hr_utility.set_location('Entering... ' || l_proc, 1001);

681:
682: l_proc := g_package || '.get_rating_of_record';
683:
684: if (hr_utility.debug_enabled()) then
685: hr_utility.set_location('Entering... ' || l_proc, 1001);
686: hr_utility.set_location('Person_id : ' || p_person_id, 1001);
687: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);
688: end if;
689:

Line 686: hr_utility.set_location('Person_id : ' || p_person_id, 1001);

682: l_proc := g_package || '.get_rating_of_record';
683:
684: if (hr_utility.debug_enabled()) then
685: hr_utility.set_location('Entering... ' || l_proc, 1001);
686: hr_utility.set_location('Person_id : ' || p_person_id, 1001);
687: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);
688: end if;
689:
690: If g_perf_flex_num is null THEN

Line 687: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);

683:
684: if (hr_utility.debug_enabled()) then
685: hr_utility.set_location('Entering... ' || l_proc, 1001);
686: hr_utility.set_location('Person_id : ' || p_person_id, 1001);
687: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);
688: end if;
689:
690: If g_perf_flex_num is null THEN
691: for get_flex_num_rec in get_flex_num loop

Line 697: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 101);

693: exit;
694: End loop;
695: END IF;
696:
697: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 101);
698:
699: for get_rating_of_record_rec in get_rating_of_record loop
700: l_perf_rating := get_rating_of_record_rec.rating_of_record;
701: exit;

Line 704: hr_utility.set_location('Performance rating : ' || l_perf_rating, 1001);

700: l_perf_rating := get_rating_of_record_rec.rating_of_record;
701: exit;
702: End loop;
703:
704: hr_utility.set_location('Performance rating : ' || l_perf_rating, 1001);
705:
706: return(l_perf_rating);
707:
708: End get_rating_of_record;

Line 803: hr_utility.set_location('Entering... ' ||l_proc,1001);

799: l_proc varchar2(50);
800: BEGIN
801:
802: l_proc := g_package||'.get_per_ele_value_ason_date';
803: hr_utility.set_location('Entering... ' ||l_proc,1001);
804: FOR l_assignement_id in assignement_id(p_person_id) LOOP
805: l_asg_id := l_assignement_id.assg_id;
806: exit;
807: END LOOP;

Line 818: hr_utility.set_location('Person Element input value : ' || l_screen_entry_value, 1000);

814: l_screen_entry_value,
815: l_effective_start_date,
816: P_BUSINESS_GROUP_ID
817: );
818: hr_utility.set_location('Person Element input value : ' || l_screen_entry_value, 1000);
819: return (l_screen_entry_value);
820:
821: END get_per_ele_value_ason_date;
822:

Line 881: hr_utility.set_location('Input currency code ' ||l_input_curr_code,100000);

877: l_input_curr_code := c_ele_input_curr_code_rec.input_curr_code;
878: exit;
879: End Loop;
880:
881: hr_utility.set_location('Input currency code ' ||l_input_curr_code,100000);
882:
883: return (l_input_curr_code);
884:
885: End get_elmt_curr_code_ason_dt;