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

Line 53: hr_utility.set_location('Entering: '||l_proc,1);

49: from per_assignment_extra_info
50: where assignment_id = p_assig_id
51: and information_type = p_type;
52: BEGIN
53: hr_utility.set_location('Entering: '||l_proc,1);
54: open csr_ovn;
55: fetch csr_ovn into l_ovn, p_aei_id;
56: close csr_ovn;
57:

Line 59: hr_utility.set_location('Leaving: '||l_proc,999);

55: fetch csr_ovn into l_ovn, p_aei_id;
56: close csr_ovn;
57:
58: return l_ovn;
59: hr_utility.set_location('Leaving: '||l_proc,999);
60: END;
61:
62: PROCEDURE restored(p_type in varchar2,
63: p_pactid in number)

Line 110: hr_utility.set_location('Entering: '||l_proc,1);

106: AND pei.information_type = 'GB_P46';
107: --For bug 7208046: End
108:
109: BEGIN
110: hr_utility.set_location('Entering: '||l_proc,1);
111: if p_type = 'GB WNU EDI' then
112: hr_utility.set_location(p_type,10);
113: for archive_rec in csr_archive_details loop
114: hr_utility.set_location(p_type,20);

Line 112: hr_utility.set_location(p_type,10);

108:
109: BEGIN
110: hr_utility.set_location('Entering: '||l_proc,1);
111: if p_type = 'GB WNU EDI' then
112: hr_utility.set_location(p_type,10);
113: for archive_rec in csr_archive_details loop
114: hr_utility.set_location(p_type,20);
115: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
116: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 114: hr_utility.set_location(p_type,20);

110: hr_utility.set_location('Entering: '||l_proc,1);
111: if p_type = 'GB WNU EDI' then
112: hr_utility.set_location(p_type,10);
113: for archive_rec in csr_archive_details loop
114: hr_utility.set_location(p_type,20);
115: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
116: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
117: hr_utility.set_location(p_type,30);
118: hr_assignment_extra_info_api.update_assignment_extra_info

Line 117: hr_utility.set_location(p_type,30);

113: for archive_rec in csr_archive_details loop
114: hr_utility.set_location(p_type,20);
115: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
116: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
117: hr_utility.set_location(p_type,30);
118: hr_assignment_extra_info_api.update_assignment_extra_info
119: (p_validate => false,
120: p_object_version_number => l_ovn,
121: p_assignment_extra_info_id => l_aei_id,

Line 131: hr_utility.set_location(p_type,10);

127: end loop;
128: end if;
129:
130: if p_type = 'GB P45(3) EDI' then
131: hr_utility.set_location(p_type,10);
132: for archive_rec in csr_archive_details loop
133: hr_utility.set_location(p_type,20);
134: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
135: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 133: hr_utility.set_location(p_type,20);

129:
130: if p_type = 'GB P45(3) EDI' then
131: hr_utility.set_location(p_type,10);
132: for archive_rec in csr_archive_details loop
133: hr_utility.set_location(p_type,20);
134: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
135: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
136: hr_utility.set_location(p_type,30);
137: hr_assignment_extra_info_api.update_assignment_extra_info

Line 136: hr_utility.set_location(p_type,30);

132: for archive_rec in csr_archive_details loop
133: hr_utility.set_location(p_type,20);
134: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
135: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
136: hr_utility.set_location(p_type,30);
137: hr_assignment_extra_info_api.update_assignment_extra_info
138: (p_validate => false,
139: p_object_version_number => l_ovn,
140: p_assignment_extra_info_id => l_aei_id,

Line 148: hr_utility.set_location(p_type,10);

144: end loop;
145: end if;
146: /* EOY Changes P45(3) Version 6 Starts */
147: if p_type = 'GB P45(3) EDI' then
148: hr_utility.set_location(p_type,10);
149: for archive_rec in csr_archive_details loop
150: hr_utility.set_location(p_type,20);
151: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
152: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 150: hr_utility.set_location(p_type,20);

146: /* EOY Changes P45(3) Version 6 Starts */
147: if p_type = 'GB P45(3) EDI' then
148: hr_utility.set_location(p_type,10);
149: for archive_rec in csr_archive_details loop
150: hr_utility.set_location(p_type,20);
151: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
152: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
153: hr_utility.set_location(p_type,30);
154: hr_assignment_extra_info_api.update_assignment_extra_info

Line 153: hr_utility.set_location(p_type,30);

149: for archive_rec in csr_archive_details loop
150: hr_utility.set_location(p_type,20);
151: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
152: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
153: hr_utility.set_location(p_type,30);
154: hr_assignment_extra_info_api.update_assignment_extra_info
155: (p_validate => false,
156: p_object_version_number => l_ovn,
157: p_assignment_extra_info_id => l_aei_id,

Line 166: hr_utility.set_location(p_type,10);

162: end if;
163: /* EOY Changes P45(3) Version 6 Ends */
164:
165: if p_type = 'GB P46 EDI' then
166: hr_utility.set_location(p_type,10);
167: for archive_rec in csr_archive_details loop
168: hr_utility.set_location(p_type,20);
169: l_ovn := get_version(archive_rec.assignment_id,'GB_P46',l_aei_id);
170: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 168: hr_utility.set_location(p_type,20);

164:
165: if p_type = 'GB P46 EDI' then
166: hr_utility.set_location(p_type,10);
167: for archive_rec in csr_archive_details loop
168: hr_utility.set_location(p_type,20);
169: l_ovn := get_version(archive_rec.assignment_id,'GB_P46',l_aei_id);
170: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
171: hr_utility.set_location(p_type,30);
172: hr_assignment_extra_info_api.update_assignment_extra_info

Line 171: hr_utility.set_location(p_type,30);

167: for archive_rec in csr_archive_details loop
168: hr_utility.set_location(p_type,20);
169: l_ovn := get_version(archive_rec.assignment_id,'GB_P46',l_aei_id);
170: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
171: hr_utility.set_location(p_type,30);
172: hr_assignment_extra_info_api.update_assignment_extra_info
173: (p_validate => false,
174: p_object_version_number => l_ovn,
175: p_assignment_extra_info_id => l_aei_id,

Line 185: hr_utility.set_location(p_type,10);

181:
182: /*Changes for P46EXP_Ver6 starts*/
183:
184: if p_type = 'GB P46EXP EDI' then
185: hr_utility.set_location(p_type,10);
186: for archive_rec in csr_archive_details loop
187: hr_utility.set_location(p_type,20);
188: l_ovn := get_version(archive_rec.assignment_id,'GB_P46EXP',l_aei_id);
189: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 187: hr_utility.set_location(p_type,20);

183:
184: if p_type = 'GB P46EXP EDI' then
185: hr_utility.set_location(p_type,10);
186: for archive_rec in csr_archive_details loop
187: hr_utility.set_location(p_type,20);
188: l_ovn := get_version(archive_rec.assignment_id,'GB_P46EXP',l_aei_id);
189: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
190: hr_utility.set_location(p_type,30);
191: hr_assignment_extra_info_api.update_assignment_extra_info

Line 190: hr_utility.set_location(p_type,30);

186: for archive_rec in csr_archive_details loop
187: hr_utility.set_location(p_type,20);
188: l_ovn := get_version(archive_rec.assignment_id,'GB_P46EXP',l_aei_id);
189: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
190: hr_utility.set_location(p_type,30);
191: hr_assignment_extra_info_api.update_assignment_extra_info
192: (p_validate => false,
193: p_object_version_number => l_ovn,
194: p_assignment_extra_info_id => l_aei_id,

Line 206: hr_utility.set_location(p_type,10);

202:
203: --For bug 7208046: Start
204: IF p_type = 'GB P46_5 EDI'
205: THEN
206: hr_utility.set_location(p_type,10);
207: FOR archive_rec IN csr_archive_details
208: LOOP
209: FOR asg_extra IN csr_extra_details(archive_rec.assignment_id)
210: LOOP

Line 265: hr_utility.set_location(p_type,10);

261: END IF;
262: --For bug 7208046: End
263:
264: if p_type = 'GB P46 PENNOT EDI' then ---GB P46 Pension EDI
265: hr_utility.set_location(p_type,10);
266: for archive_rec in csr_archive_details loop
267: hr_utility.set_location(p_type,20);
268: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
269: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 267: hr_utility.set_location(p_type,20);

263:
264: if p_type = 'GB P46 PENNOT EDI' then ---GB P46 Pension EDI
265: hr_utility.set_location(p_type,10);
266: for archive_rec in csr_archive_details loop
267: hr_utility.set_location(p_type,20);
268: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
269: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
270: hr_utility.set_location(p_type,30);
271: hr_assignment_extra_info_api.update_assignment_extra_info

Line 270: hr_utility.set_location(p_type,30);

266: for archive_rec in csr_archive_details loop
267: hr_utility.set_location(p_type,20);
268: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
269: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
270: hr_utility.set_location(p_type,30);
271: hr_assignment_extra_info_api.update_assignment_extra_info
272: (p_validate => false,
273: p_object_version_number => l_ovn,
274: p_assignment_extra_info_id => l_aei_id,

Line 280: hr_utility.set_location('Leaving: '||l_proc,999);

276: p_aei_information1 => 'Y');
277: end if;
278: end loop;
279: end if;
280: hr_utility.set_location('Leaving: '||l_proc,999);
281: END;
282: --- PUBLIC PROCEDURE ---
283: PROCEDURE edi_rollback(errbuf out NOCOPY VARCHAR2,
284: retcode out NOCOPY NUMBER,

Line 292: hr_utility.set_location('Entering: '||l_proc,1);

288: IS
289: l_proc CONSTANT VARCHAR2(50):= g_package||'edi_rollback';
290: l_id number;
291: BEGIN
292: hr_utility.set_location('Entering: '||l_proc,1);
293: hr_utility.set_location('Type : ' || p_type, 10);
294: hr_utility.set_location('Year : ' || p_year, 10);
295: hr_utility.set_location('Action : ' || p_actid, 10);
296: -- If type is on of the following, do manual stuff first

Line 293: hr_utility.set_location('Type : ' || p_type, 10);

289: l_proc CONSTANT VARCHAR2(50):= g_package||'edi_rollback';
290: l_id number;
291: BEGIN
292: hr_utility.set_location('Entering: '||l_proc,1);
293: hr_utility.set_location('Type : ' || p_type, 10);
294: hr_utility.set_location('Year : ' || p_year, 10);
295: hr_utility.set_location('Action : ' || p_actid, 10);
296: -- If type is on of the following, do manual stuff first
297: if p_type = 'GBEDIWNU' or p_type = 'GBEDIWNU3' or p_type = 'GBEDIWNU3ET' then -- 5398360 --Added GBEDIWNU3ET for bug 9186359

Line 294: hr_utility.set_location('Year : ' || p_year, 10);

290: l_id number;
291: BEGIN
292: hr_utility.set_location('Entering: '||l_proc,1);
293: hr_utility.set_location('Type : ' || p_type, 10);
294: hr_utility.set_location('Year : ' || p_year, 10);
295: hr_utility.set_location('Action : ' || p_actid, 10);
296: -- If type is on of the following, do manual stuff first
297: if p_type = 'GBEDIWNU' or p_type = 'GBEDIWNU3' or p_type = 'GBEDIWNU3ET' then -- 5398360 --Added GBEDIWNU3ET for bug 9186359
298: restored('GB WNU EDI',p_actid);

Line 295: hr_utility.set_location('Action : ' || p_actid, 10);

291: BEGIN
292: hr_utility.set_location('Entering: '||l_proc,1);
293: hr_utility.set_location('Type : ' || p_type, 10);
294: hr_utility.set_location('Year : ' || p_year, 10);
295: hr_utility.set_location('Action : ' || p_actid, 10);
296: -- If type is on of the following, do manual stuff first
297: if p_type = 'GBEDIWNU' or p_type = 'GBEDIWNU3' or p_type = 'GBEDIWNU3ET' then -- 5398360 --Added GBEDIWNU3ET for bug 9186359
298: restored('GB WNU EDI',p_actid);
299: end if;

Line 333: hr_utility.set_location('Calling Core Rollback routine',20);

329: if p_type in ('P46_PENNOT_EDI','P46_5_PENNOT_EDI','P46_VER6_PENNOT') then
330: restored('GB P46 PENNOT EDI',p_actid);
331: end if;
332:
333: hr_utility.set_location('Calling Core Rollback routine',20);
334: -- Next called the Core's ROLLBACK routine
335: l_id := fnd_request.submit_request(application => 'PAY',
336: program => 'ROLLBACK',
337: argument1 => 'ROLLBACK',

Line 346: hr_utility.set_location('Leaving: '||l_proc,999);

342: argument6 => p_actid, -- payroll action_id
343: argument7 => null, -- assignmenet_set
344: argument8 => 'PAYROLL_ACTION_ID='||p_actid,
345: argument9 => null);
346: hr_utility.set_location('Leaving: '||l_proc,999);
347: END edi_rollback;
348:
349: END PAY_GB_EDI_ROLLBACK;