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 165: if ( hr_utility.debug_enabled()) then

161: BEGIN
162:
163: l_proc := g_package||'.get_latest_pa_req_id';
164:
165: if ( hr_utility.debug_enabled()) then
166: hr_utility.set_location('Entering... ' ||l_proc,1000);
167: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
168: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
169: end if;

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

162:
163: l_proc := g_package||'.get_latest_pa_req_id';
164:
165: if ( hr_utility.debug_enabled()) then
166: hr_utility.set_location('Entering... ' ||l_proc,1000);
167: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
168: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
169: end if;
170:

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

163: l_proc := g_package||'.get_latest_pa_req_id';
164:
165: if ( hr_utility.debug_enabled()) then
166: hr_utility.set_location('Entering... ' ||l_proc,1000);
167: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
168: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
169: end if;
170:
171: for notification_id_rec in c_notification_id

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

164:
165: if ( hr_utility.debug_enabled()) then
166: hr_utility.set_location('Entering... ' ||l_proc,1000);
167: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
168: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
169: end if;
170:
171: for notification_id_rec in c_notification_id
172: loop

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

173: l_notification_id := notification_id_rec.notification_id;
174: exit;
175: end loop;
176:
177: hr_utility.set_location('notification_id : ' || l_notification_id, 1000);
178:
179: for pa_request_id_rec in c_request_id (l_notification_id)
180: loop
181: l_pa_request_id := pa_request_id_rec.pa_request_id;

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

181: l_pa_request_id := pa_request_id_rec.pa_request_id;
182: exit;
183: end loop;
184:
185: hr_utility.set_location('pa_request_id : ' || l_pa_request_id, 1000);
186:
187: return (l_pa_request_id);
188:
189: END get_latest_pa_req_id;

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

233: Begin
234:
235: l_proc := g_package||'.get_latest_perf_rating';
236:
237: if ( hr_utility.debug_enabled()) then
238: hr_utility.set_location('Entering... ' ||l_proc,1000);
239: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
240: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
241: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);

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

234:
235: l_proc := g_package||'.get_latest_perf_rating';
236:
237: if ( hr_utility.debug_enabled()) then
238: hr_utility.set_location('Entering... ' ||l_proc,1000);
239: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
240: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
241: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);
242: end if;

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

235: l_proc := g_package||'.get_latest_perf_rating';
236:
237: if ( hr_utility.debug_enabled()) then
238: hr_utility.set_location('Entering... ' ||l_proc,1000);
239: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
240: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
241: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);
242: end if;
243:

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

236:
237: if ( hr_utility.debug_enabled()) then
238: hr_utility.set_location('Entering... ' ||l_proc,1000);
239: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
240: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
241: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);
242: end if;
243:
244: If g_perf_flex_num is null THEN

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

237: if ( hr_utility.debug_enabled()) then
238: hr_utility.set_location('Entering... ' ||l_proc,1000);
239: hr_utility.set_location('Person_id : ' || p_person_id, 1000);
240: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
241: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1000);
242: end if;
243:
244: If g_perf_flex_num is null THEN
245: for get_flex_num_rec in get_flex_num

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

248: exit;
249: End loop;
250: END IF;
251:
252: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 10);
253:
254: for get_latest_perf_rating_rec in get_latest_perf_rating
255: loop
256: l_perf_rating := get_latest_perf_rating_rec.rating_of_record;

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

256: l_perf_rating := get_latest_perf_rating_rec.rating_of_record;
257: exit;
258: End loop;
259:
260: hr_utility.set_location('Performance rating : ' || l_perf_rating, 1000);
261:
262: return( l_perf_rating);
263:
264: End get_latest_perf_rating;

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

310: l_new_element_name := p_element_name;
311:
312: IF (p_element_name = 'Basic Salary Rate'
313: and (fnd_profile.value('HR_USER_TYPE') = 'INT')) THEN
314: hr_utility.set_location('PAYROLL User -- BSR -- from asgid-- '||l_proc, 1);
315: l_new_element_name :=
316: pqp_fedhr_uspay_int_utils.return_new_element_name(
317: p_assignment_id => p_assignment_id,
318: p_business_group_id => p_business_group_id,

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

318: p_business_group_id => p_business_group_id,
319: p_effective_date => p_effective_date);
320:
321: ELSE
322: hr_utility.set_location('HR USER or PAYROLL User without BSR element -- from elt name -- '||l_proc, 1);
323: l_new_element_name :=
324: pqp_fedhr_uspay_int_utils.return_new_element_name(
325: p_fedhr_element_name => p_element_name,
326: p_business_group_id => p_business_group_id,

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

328: p_pay_basis => NULL);
329:
330: END IF;
331:
332: if ( hr_utility.debug_enabled()) then
333: hr_utility.set_location('Element Name ' ||p_element_name,1000);
334: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
335: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
336: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);

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

329:
330: END IF;
331:
332: if ( hr_utility.debug_enabled()) then
333: hr_utility.set_location('Element Name ' ||p_element_name,1000);
334: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
335: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
336: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
337: end if;

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

330: END IF;
331:
332: if ( hr_utility.debug_enabled()) then
333: hr_utility.set_location('Element Name ' ||p_element_name,1000);
334: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
335: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
336: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
337: end if;
338:

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

331:
332: if ( hr_utility.debug_enabled()) then
333: hr_utility.set_location('Element Name ' ||p_element_name,1000);
334: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
335: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
336: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
337: end if;
338:
339: for c_ele_input_curr_code_rec in c_ele_input_curr_code

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

332: if ( hr_utility.debug_enabled()) then
333: hr_utility.set_location('Element Name ' ||p_element_name,1000);
334: hr_utility.set_location('BG ID '|| p_business_group_id,2000);
335: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
336: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
337: end if;
338:
339: for c_ele_input_curr_code_rec in c_ele_input_curr_code
340: Loop

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

341: l_input_curr_code := c_ele_input_curr_code_rec.input_curr_code;
342: exit;
343: End Loop;
344:
345: hr_utility.set_location('Input currency code ' ||l_input_curr_code,100000);
346:
347: return (l_input_curr_code);
348:
349: End retrieve_element_curr_code;

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

364: Begin
365:
366: l_proc := g_package||'.get_loc_pay_area_percentage';
367:
368: if ( hr_utility.debug_enabled()) then
369: hr_utility.set_location('Entering... ' ||l_proc,1000);
370: hr_utility.set_location('Location id : ' || p_location_id, 1000);
371: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
372: end if;

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

365:
366: l_proc := g_package||'.get_loc_pay_area_percentage';
367:
368: if ( hr_utility.debug_enabled()) then
369: hr_utility.set_location('Entering... ' ||l_proc,1000);
370: hr_utility.set_location('Location id : ' || p_location_id, 1000);
371: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
372: end if;
373:

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

366: l_proc := g_package||'.get_loc_pay_area_percentage';
367:
368: if ( hr_utility.debug_enabled()) then
369: hr_utility.set_location('Entering... ' ||l_proc,1000);
370: hr_utility.set_location('Location id : ' || p_location_id, 1000);
371: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
372: end if;
373:
374: ghr_per_sum.get_duty_station_details (p_location_id

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

367:
368: if ( hr_utility.debug_enabled()) then
369: hr_utility.set_location('Entering... ' ||l_proc,1000);
370: hr_utility.set_location('Location id : ' || p_location_id, 1000);
371: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
372: end if;
373:
374: ghr_per_sum.get_duty_station_details (p_location_id
375: ,p_effective_date

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

377: ,l_duty_station_desc
378: ,l_locality_pay_area
379: ,l_locality_pay_area_percentage ) ;
380:
381: hr_utility.set_location('locality pay area percentage : ' || l_locality_pay_area_percentage, 1000);
382: return (l_locality_pay_area_percentage);
383:
384: End get_loc_pay_area_percentage;
385:

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

416:
417: l_proc := g_package||'.check_if_awards_exists';
418: l_award_bonus := 'No' ;
419:
420: if ( hr_utility.debug_enabled()) then
421: hr_utility.set_location('Entering... ' ||l_proc,1000);
422: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
423: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
424: end if;

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

417: l_proc := g_package||'.check_if_awards_exists';
418: l_award_bonus := 'No' ;
419:
420: if ( hr_utility.debug_enabled()) then
421: hr_utility.set_location('Entering... ' ||l_proc,1000);
422: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
423: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
424: end if;
425:

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

418: l_award_bonus := 'No' ;
419:
420: if ( hr_utility.debug_enabled()) then
421: hr_utility.set_location('Entering... ' ||l_proc,1000);
422: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
423: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
424: end if;
425:
426: FOR award_check_rec IN award_check (p_assignment_id , p_effective_date)LOOP

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

419:
420: if ( hr_utility.debug_enabled()) then
421: hr_utility.set_location('Entering... ' ||l_proc,1000);
422: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
423: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
424: end if;
425:
426: FOR award_check_rec IN award_check (p_assignment_id , p_effective_date)LOOP
427: l_award_bonus := 'Yes';

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

427: l_award_bonus := 'Yes';
428: EXIT;
429: END LOOP;
430:
431: hr_utility.set_location('Check for Award : ' || l_award_bonus, 1004);
432:
433: RETURN(l_award_bonus);
434:
435: END check_if_awards_exists;

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

465: BEGIN
466:
467: l_proc := g_package||'.check_if_bonus_exists';
468: l_award_bonus := 'No' ;
469: if ( hr_utility.debug_enabled()) then
470: hr_utility.set_location('Entering... ' ||l_proc,1000);
471: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
472: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
473: end if;

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

466:
467: l_proc := g_package||'.check_if_bonus_exists';
468: l_award_bonus := 'No' ;
469: if ( hr_utility.debug_enabled()) then
470: hr_utility.set_location('Entering... ' ||l_proc,1000);
471: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
472: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
473: end if;
474:

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

467: l_proc := g_package||'.check_if_bonus_exists';
468: l_award_bonus := 'No' ;
469: if ( hr_utility.debug_enabled()) then
470: hr_utility.set_location('Entering... ' ||l_proc,1000);
471: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
472: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
473: end if;
474:
475: FOR bonus_check_rec IN bonus_check (p_assignment_id , p_effective_date)LOOP

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

468: l_award_bonus := 'No' ;
469: if ( hr_utility.debug_enabled()) then
470: hr_utility.set_location('Entering... ' ||l_proc,1000);
471: hr_utility.set_location('assignement_id : ' || p_assignment_id, 1001);
472: hr_utility.set_location('Effective_date : ' || p_effective_date, 1002);
473: end if;
474:
475: FOR bonus_check_rec IN bonus_check (p_assignment_id , p_effective_date)LOOP
476: l_award_bonus := 'Yes';

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

477: EXIT;
478: END LOOP;
479:
480:
481: hr_utility.set_location('Check for Bonus : ' || l_award_bonus, 1004);
482:
483: RETURN(l_award_bonus);
484:
485: END check_if_bonus_exists;

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

538: Begin
539:
540: l_proc := g_package||'.get_asg_ei_id_ason_date';
541:
542: if ( hr_utility.debug_enabled()) then
543: hr_utility.set_location('Entering... ' ||l_proc,1000);
544: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
545: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
546: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

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

539:
540: l_proc := g_package||'.get_asg_ei_id_ason_date';
541:
542: if ( hr_utility.debug_enabled()) then
543: hr_utility.set_location('Entering... ' ||l_proc,1000);
544: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
545: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
546: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
547: End if;

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

540: l_proc := g_package||'.get_asg_ei_id_ason_date';
541:
542: if ( hr_utility.debug_enabled()) then
543: hr_utility.set_location('Entering... ' ||l_proc,1000);
544: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
545: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
546: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
547: End if;
548:

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

541:
542: if ( hr_utility.debug_enabled()) then
543: hr_utility.set_location('Entering... ' ||l_proc,1000);
544: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
545: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
546: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
547: End if;
548:
549: for history_id_rec in c_history_id loop

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

542: if ( hr_utility.debug_enabled()) then
543: hr_utility.set_location('Entering... ' ||l_proc,1000);
544: hr_utility.set_location('Assignment_id : ' || p_asg_id, 1000);
545: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
546: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
547: End if;
548:
549: for history_id_rec in c_history_id loop
550: l_history_id := history_id_rec.pa_history_id;

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

550: l_history_id := history_id_rec.pa_history_id;
551: exit;
552: end loop;
553:
554: hr_utility.set_location('history_id : ' || l_history_id, 1000);
555: return (l_history_id);
556:
557: End get_assignment_ei_id_ason_date;
558:

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

590: Begin
591:
592: l_proc := g_package||'.get_position_ei_id_ason_date';
593:
594: if ( hr_utility.debug_enabled()) then
595: hr_utility.set_location('Entering... ' ||l_proc,1000);
596: hr_utility.set_location('position_id : ' || p_position_id, 1000);
597: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
598: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);

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

591:
592: l_proc := g_package||'.get_position_ei_id_ason_date';
593:
594: if ( hr_utility.debug_enabled()) then
595: hr_utility.set_location('Entering... ' ||l_proc,1000);
596: hr_utility.set_location('position_id : ' || p_position_id, 1000);
597: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
598: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
599: End if;

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

592: l_proc := g_package||'.get_position_ei_id_ason_date';
593:
594: if ( hr_utility.debug_enabled()) then
595: hr_utility.set_location('Entering... ' ||l_proc,1000);
596: hr_utility.set_location('position_id : ' || p_position_id, 1000);
597: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
598: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
599: End if;
600:

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

593:
594: if ( hr_utility.debug_enabled()) then
595: hr_utility.set_location('Entering... ' ||l_proc,1000);
596: hr_utility.set_location('position_id : ' || p_position_id, 1000);
597: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
598: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
599: End if;
600:
601: for history_id_rec in c_history_id loop

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

594: if ( hr_utility.debug_enabled()) then
595: hr_utility.set_location('Entering... ' ||l_proc,1000);
596: hr_utility.set_location('position_id : ' || p_position_id, 1000);
597: hr_utility.set_location('Information_type : ' || p_information_type, 1000);
598: hr_utility.set_location('Effective_date : ' || p_effective_date, 1000);
599: End if;
600:
601: for history_id_rec in c_history_id loop
602: l_history_id := history_id_rec.pa_history_id;

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

602: l_history_id := history_id_rec.pa_history_id;
603: exit;
604: end loop;
605:
606: hr_utility.set_location('history_id : ' || l_history_id, 1000);
607:
608: return (l_history_id);
609:
610: end get_position_ei_id_ason_date;

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

646: Begin
647:
648: l_proc := g_package || '.get_rating_of_record';
649:
650: if (hr_utility.debug_enabled()) then
651: hr_utility.set_location('Entering... ' || l_proc, 1001);
652: hr_utility.set_location('Person_id : ' || p_person_id, 1001);
653: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);
654: end if;

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

647:
648: l_proc := g_package || '.get_rating_of_record';
649:
650: if (hr_utility.debug_enabled()) then
651: hr_utility.set_location('Entering... ' || l_proc, 1001);
652: hr_utility.set_location('Person_id : ' || p_person_id, 1001);
653: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);
654: end if;
655:

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

648: l_proc := g_package || '.get_rating_of_record';
649:
650: if (hr_utility.debug_enabled()) then
651: hr_utility.set_location('Entering... ' || l_proc, 1001);
652: hr_utility.set_location('Person_id : ' || p_person_id, 1001);
653: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);
654: end if;
655:
656: If g_perf_flex_num is null THEN

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

649:
650: if (hr_utility.debug_enabled()) then
651: hr_utility.set_location('Entering... ' || l_proc, 1001);
652: hr_utility.set_location('Person_id : ' || p_person_id, 1001);
653: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 1001);
654: end if;
655:
656: If g_perf_flex_num is null THEN
657: for get_flex_num_rec in get_flex_num loop

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

659: exit;
660: End loop;
661: END IF;
662:
663: hr_utility.set_location('perf Flex Num : ' || g_perf_flex_num, 101);
664:
665: for get_rating_of_record_rec in get_rating_of_record loop
666: l_perf_rating := get_rating_of_record_rec.rating_of_record;
667: exit;

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

666: l_perf_rating := get_rating_of_record_rec.rating_of_record;
667: exit;
668: End loop;
669:
670: hr_utility.set_location('Performance rating : ' || l_perf_rating, 1001);
671:
672: return(l_perf_rating);
673:
674: End get_rating_of_record;