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_SF52_POST_UPDATE dependencies on HR_UTILITY

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

36:
37: -- Get all data pertaining to Notifications
38:
39: begin
40: hr_utility.set_location('Entering ' || l_proc ,5);
41: l_object_version_number := p_object_version_number;
42:
43: hr_utility.set_location(l_proc ,10);
44:

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

39: begin
40: hr_utility.set_location('Entering ' || l_proc ,5);
41: l_object_version_number := p_object_version_number;
42:
43: hr_utility.set_location(l_proc ,10);
44:
45: -- Just get the notification_id and update ghr_pa_requests
46: --
47: open C_Sel1;

Line 51: hr_utility.set_location('to_position_id is '||p_sf52_data_result.to_position_id ,10);

47: open C_Sel1;
48: Fetch C_Sel1 Into l_pa_notification_id;
49: Close C_Sel1;
50:
51: hr_utility.set_location('to_position_id is '||p_sf52_data_result.to_position_id ,10);
52: IF nvl(p_called_from,hr_api.g_varchar2) = 'CORRECTION_SF52' THEN
53: ghr_par_upd.upd
54: (p_pa_request_id => p_pa_request_id
55: ,p_object_version_number => l_object_version_number

Line 123: ghr_utility.process_nfc_auth_date(

119: );
120: END IF;
121: -- Get the Authentication Date for NFC processing
122:
123: ghr_utility.process_nfc_auth_date(
124: p_effective_date => p_effective_date,
125: p_pa_request_id => p_pa_request_id);
126: hr_utility.set_location(l_proc ,20);
127:

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

122:
123: ghr_utility.process_nfc_auth_date(
124: p_effective_date => p_effective_date,
125: p_pa_request_id => p_pa_request_id);
126: hr_utility.set_location(l_proc ,20);
127:
128: --
129: --
130: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'UPDATE_HR_COMPLETE'

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

128: --
129: --
130: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'UPDATE_HR_COMPLETE'
131: --
132: hr_utility.set_location(l_proc,40);
133:
134: ghr_sf52_api.end_sf52
135: (p_pa_request_id => p_pa_request_id
136: ,p_action_taken => 'UPDATE_HR_COMPLETE'

Line 140: hr_utility.set_location('Leaving '||l_proc,45);

136: ,p_action_taken => 'UPDATE_HR_COMPLETE'
137: ,p_par_object_version_number => l_object_version_number
138: );
139: --
140: hr_utility.set_location('Leaving '||l_proc,45);
141:
142: EXCEPTION
143: WHEN others THEN
144: -- Reset IN OUT parameters and set OUT parameters

Line 207: hr_utility.set_location('Entering ' || l_proc ,5);

203:
204: -- Get all data pertaining to Notifications
205:
206: begin
207: hr_utility.set_location('Entering ' || l_proc ,5);
208: l_object_version_number := p_object_version_number;
209:
210: hr_utility.set_location(l_proc ,10);
211: --Check if the position is not already occupied

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

206: begin
207: hr_utility.set_location('Entering ' || l_proc ,5);
208: l_object_version_number := p_object_version_number;
209:
210: hr_utility.set_location(l_proc ,10);
211: --Check if the position is not already occupied
212: for per_asg_rec in c_person loop
213: l_person_id := per_asg_rec.person_id;
214: l_assignment_id := per_asg_rec.employee_assignment_id;

Line 223: hr_utility.set_message(8301,'GHR_38620_POS_ASSIGNED');

219: l_exists := true;
220: exit;
221: end loop;
222: If l_exists then
223: hr_utility.set_message(8301,'GHR_38620_POS_ASSIGNED');
224: hr_utility.raise_error;
225: End if;
226: End if;
227:

Line 224: hr_utility.raise_error;

220: exit;
221: end loop;
222: If l_exists then
223: hr_utility.set_message(8301,'GHR_38620_POS_ASSIGNED');
224: hr_utility.raise_error;
225: End if;
226: End if;
227:
228:

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

235: (p_pa_request_id => p_pa_request_id,
236: p_object_version_number => l_object_version_number,
237: p_pa_notification_id => l_pa_notification_id
238: );
239: hr_utility.set_location(l_proc ,20);
240:
241:
242: --
243: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'CANCELED'

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

241:
242: --
243: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'CANCELED'
244: --
245: hr_utility.set_location(l_proc,40);
246:
247: ghr_sf52_api.end_sf52
248: (p_pa_request_id => p_pa_request_id
249: ,p_action_taken => 'UPDATE_HR_COMPLETE'

Line 253: hr_utility.set_location('Leaving '||l_proc,45);

249: ,p_action_taken => 'UPDATE_HR_COMPLETE'
250: ,p_par_object_version_number => l_object_version_number
251: );
252: --
253: hr_utility.set_location('Leaving '||l_proc,45);
254:
255: EXCEPTION
256: WHEN others THEN
257: -- Reset IN OUT parameters and set OUT parameters

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

364: from ghr_pa_requests par
365: where par.pa_request_id = l_altered_pa_request_id;
366:
367: BEGIN
368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: --
371: l_agency_code := p_agency_code; --NOCOPY Changes
372: hr_utility.set_location(l_proc, 10);

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

368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: --
371: l_agency_code := p_agency_code; --NOCOPY Changes
372: hr_utility.set_location(l_proc, 10);
373: -- get the noa code to determine if it is an '800' or '790'.
374: -- If it is, then we need to handle the agency_code as a special case
375: -- and get it from extra information for the pa_request.
376: FOR pa_req in c_par LOOP

Line 383: hr_utility.set_location('PA Req ID : '||p_pa_request_id,10);

379: else
380: l_noa_code := pa_req.first_noa_code;
381: end if;
382: end loop;
383: hr_utility.set_location('PA Req ID : '||p_pa_request_id,10);
384: hr_utility.set_location('l_noa_code is '||l_noa_code,20);
385: -- Agency Desc
386: if nvl(p_to_position_id,hr_api.g_number) <> hr_api.g_number then
387: for bus_gp in c_bus_gp(p_to_position_id) loop

Line 384: hr_utility.set_location('l_noa_code is '||l_noa_code,20);

380: l_noa_code := pa_req.first_noa_code;
381: end if;
382: end loop;
383: hr_utility.set_location('PA Req ID : '||p_pa_request_id,10);
384: hr_utility.set_location('l_noa_code is '||l_noa_code,20);
385: -- Agency Desc
386: if nvl(p_to_position_id,hr_api.g_number) <> hr_api.g_number then
387: for bus_gp in c_bus_gp(p_to_position_id) loop
388: l_bus_gp := bus_gp.business_group_id;

Line 390: hr_utility.set_location(l_proc, 15);

386: if nvl(p_to_position_id,hr_api.g_number) <> hr_api.g_number then
387: for bus_gp in c_bus_gp(p_to_position_id) loop
388: l_bus_gp := bus_gp.business_group_id;
389: end loop;
390: hr_utility.set_location(l_proc, 15);
391:
392: if (l_noa_code = '800') then
393: for p_parei in c_par_ei('GHR_US_PAR_CHG_DATA_ELEMENT') LOOP
394: l_agency_code := p_parei.rei_information4;

Line 417: hr_utility.set_location('agency code ' || l_agency_code,1);

413: p_effective_date => p_effective_date
414: );
415: end if;
416: p_agency_code := l_agency_code;
417: hr_utility.set_location('agency code ' || l_agency_code,1);
418: hr_utility.set_location(l_proc,20);
419:
420: -- Employee_dept_or_agency
421: if p_agency_code is not null then

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

414: );
415: end if;
416: p_agency_code := l_agency_code;
417: hr_utility.set_location('agency code ' || l_agency_code,1);
418: hr_utility.set_location(l_proc,20);
419:
420: -- Employee_dept_or_agency
421: if p_agency_code is not null then
422: p_employee_dept_or_agency := hr_general.decode_lookup

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

422: p_employee_dept_or_agency := hr_general.decode_lookup
423: (p_lookup_type => 'GHR_US_AGENCY_CODE',
424: p_lookup_code => p_agency_code
425: );
426: hr_utility.set_location(l_proc, 30);
427: end if;
428:
429:
430: -- Personal_office_id and office_symbol

Line 449: hr_utility.set_location('NOA Code is 790',20);

445: -- personnel_office_id and from_office_symbol
446: if nvl(p_from_position_id,hr_api.g_number) <> hr_api.g_number then
447: -- Bug#4005843 Added the IF condition.
448: IF l_noa_code = '790' THEN
449: hr_utility.set_location('NOA Code is 790',20);
450: -- Bug#4344353 added the following code to get rid of ora-1841
451: IF p_effective_date = hr_api.g_date THEN
452: l_effective_date := trunc(sysdate) - 1;
453: ELSE

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

477: p_effective_date => p_effective_date
478: );
479:
480: p_from_agency_code := l_from_agency_code;
481: hr_utility.set_location(l_proc,50);
482:
483: if l_from_agency_code is not null then
484: p_from_agency_desc := hr_general.decode_lookup
485: (p_lookup_type => 'GHR_US_AGENCY_CODE',

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

484: p_from_agency_desc := hr_general.decode_lookup
485: (p_lookup_type => 'GHR_US_AGENCY_CODE',
486: p_lookup_code => l_from_agency_code
487: );
488: hr_utility.set_location(l_proc, 55);
489: end if;
490: end if;
491: p_personnel_office_id := l_personnel_office_id;
492:

Line 497: hr_utility.set_location('one of the positions is null',1);

493: -- If agency_code or the from_agency_code is null, which is likely to happen
494: -- only on corrections , try to get the agency code
495: -- from the original RPA.
496: If p_to_position_id is null or p_from_position_id is null then
497: hr_utility.set_location('one of the positions is null',1);
498: for orig_par in c_orig_par loop
499: If orig_par.noa_family_code = 'CORRECT' then
500: l_altered_pa_request_id := orig_par.altered_pa_request_id;
501: for agency_det_rec in c_agency_det loop