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

Line 33: hr_utility.set_location('Entering: ' || c_proc, 10);

29: where pdf.person_id =papf.person_id
30: and pdf.category not in ('Y','N','ND')
31: and papf.person_id = p_person_id);
32: begin
33: hr_utility.set_location('Entering: ' || c_proc, 10);
34: --
35: open csr_exists;
36: fetch csr_exists into l_exists;
37:

Line 46: hr_utility.trace(p_person_id || ' : ' || p_qualifier);

42: end if;
43:
44: close csr_exists;
45: --
46: hr_utility.trace(p_person_id || ' : ' || p_qualifier);
47: hr_utility.set_location('Leaving: ' || c_proc, 100);
48:
49: end qualify_disability_status;
50:

Line 47: hr_utility.set_location('Leaving: ' || c_proc, 100);

43:
44: close csr_exists;
45: --
46: hr_utility.trace(p_person_id || ' : ' || p_qualifier);
47: hr_utility.set_location('Leaving: ' || c_proc, 100);
48:
49: end qualify_disability_status;
50:
51: PROCEDURE upg_disability_status(p_person_id in number) is

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

124: v_dis_det csr_get_disability%rowtype;
125: begin
126:
127: l_category :='X';
128: hr_utility.set_location('Entering ' || l_proc,10);
129:
130: open csr_disability_det;
131: fetch csr_disability_det into v_disability_id,v_object_version_number;
132: if csr_disability_det%notfound then

Line 136: hr_utility.set_location('Entering ' || l_proc,20);

132: if csr_disability_det%notfound then
133:
134: for v_csr_details in csr_person_details
135: loop
136: hr_utility.set_location('Entering ' || l_proc,20);
137: if l_count = 1 then
138: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
139: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
140: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');

Line 157: hr_utility.trace('v_csr_details.person_id='||v_csr_details.person_id);

153:
154: l_count := l_count + 1;
155:
156:
157: hr_utility.trace('v_csr_details.person_id='||v_csr_details.person_id);
158:
159: if l_category <> v_csr_details.category then
160:
161: open csr_disability_details;

Line 165: hr_utility.set_location('Entering ' || l_proc,30);

161: open csr_disability_details;
162: fetch csr_disability_details into v_disability_id_new,v_object_version_number_new;
163: if csr_disability_details%notfound then
164:
165: hr_utility.set_location('Entering ' || l_proc,30);
166: insert into per_disabilities_f
167: (disability_id
168: ,effective_start_date
169: ,effective_end_date

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

200:
201: else
202:
203: -- Creating date track updates against Disability records
204: hr_utility.set_location('Entering ' || l_proc,40);
205: insert into per_disabilities_f
206: (disability_id
207: ,effective_start_date
208: ,effective_end_date

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

252: open csr_disability_details;
253: fetch csr_disability_details into v_disability_id_new,v_object_version_number_new;
254: if csr_disability_details%found then
255:
256: hr_utility.set_location('Entering ' || l_proc,45);
257: update per_disabilities_f
258: set effective_end_date = v_csr_details.effective_end_date
259: where disability_id = v_disability_id_new
260: and category = v_csr_details.category;

Line 265: hr_utility.set_location('Entering ' || l_proc,50);

261: end if;
262: close csr_disability_details;
263: end if; -- end of category
264:
265: hr_utility.set_location('Entering ' || l_proc,50);
266: --Correcting the person record, setting Disability field to null
267:
268: update per_all_people_f
269: set registered_disabled_flag = null

Line 282: hr_utility.set_location('Entering ' || l_proc,60);

278: else
279: for v_dis_det in csr_get_disability(p_person_id)
280: loop
281:
282: hr_utility.set_location('Entering ' || l_proc,60);
283: if l_count = 1 then
284: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
285: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
286: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');

Line 302: hr_utility.set_location('Entering ' || l_proc,70);

298: ||' '||rpad(to_char(v_dis_det.effective_end_date,'DD/MM/YYYY'),20));
299:
300:
301: --Correcting the disability record, updating category field to 'Yes' against non-GB Categories.
302: hr_utility.set_location('Entering ' || l_proc,70);
303:
304: update per_disabilities_f
305: set category='Y'
306: where effective_start_date = v_dis_det.effective_start_date

Line 309: hr_utility.set_location('Entering ' || l_proc,80);

305: set category='Y'
306: where effective_start_date = v_dis_det.effective_start_date
307: and disability_id = v_dis_det.disability_id ;
308:
309: hr_utility.set_location('Entering ' || l_proc,80);
310: l_count := l_count + 1;
311: end loop;
312: end if; -- end of main
313: close csr_disability_det;

Line 315: hr_utility.set_location('Leaving ' || l_proc,90);

311: end loop;
312: end if; -- end of main
313: close csr_disability_det;
314:
315: hr_utility.set_location('Leaving ' || l_proc,90);
316: end upg_disability_status;
317:
318: end pay_gb_upgrade_pkg;