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 126: ghr_utility.process_nfc_auth_date(

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 227: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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