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.

[Home] [Help]

APPS.PAY_GB_EDI_ROLLBACK dependencies on HR_UTILITY

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

34: from per_assignment_extra_info
35: where assignment_id = p_assig_id
36: and information_type = p_type;
37: BEGIN
38: hr_utility.set_location('Entering: '||l_proc,1);
39: open csr_ovn;
40: fetch csr_ovn into l_ovn, p_aei_id;
41: close csr_ovn;
42:

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

40: fetch csr_ovn into l_ovn, p_aei_id;
41: close csr_ovn;
42:
43: return l_ovn;
44: hr_utility.set_location('Leaving: '||l_proc,999);
45: END;
46:
47: PROCEDURE restored(p_type in varchar2,
48: p_pactid in number)

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

91: AND pei.information_type = 'GB_P46';
92: --For bug 7208046: End
93:
94: BEGIN
95: hr_utility.set_location('Entering: '||l_proc,1);
96: if p_type = 'GB WNU EDI' then
97: hr_utility.set_location(p_type,10);
98: for archive_rec in csr_archive_details loop
99: hr_utility.set_location(p_type,20);

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

93:
94: BEGIN
95: hr_utility.set_location('Entering: '||l_proc,1);
96: if p_type = 'GB WNU EDI' then
97: hr_utility.set_location(p_type,10);
98: for archive_rec in csr_archive_details loop
99: hr_utility.set_location(p_type,20);
100: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
101: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

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

95: hr_utility.set_location('Entering: '||l_proc,1);
96: if p_type = 'GB WNU EDI' then
97: hr_utility.set_location(p_type,10);
98: for archive_rec in csr_archive_details loop
99: hr_utility.set_location(p_type,20);
100: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
101: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
102: hr_utility.set_location(p_type,30);
103: hr_assignment_extra_info_api.update_assignment_extra_info

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

98: for archive_rec in csr_archive_details loop
99: hr_utility.set_location(p_type,20);
100: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
101: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
102: hr_utility.set_location(p_type,30);
103: hr_assignment_extra_info_api.update_assignment_extra_info
104: (p_validate => false,
105: p_object_version_number => l_ovn,
106: p_assignment_extra_info_id => l_aei_id,

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

112: end loop;
113: end if;
114:
115: if p_type = 'GB P45(3) EDI' then
116: hr_utility.set_location(p_type,10);
117: for archive_rec in csr_archive_details loop
118: hr_utility.set_location(p_type,20);
119: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
120: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

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

114:
115: if p_type = 'GB P45(3) EDI' then
116: hr_utility.set_location(p_type,10);
117: for archive_rec in csr_archive_details loop
118: hr_utility.set_location(p_type,20);
119: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
120: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
121: hr_utility.set_location(p_type,30);
122: hr_assignment_extra_info_api.update_assignment_extra_info

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

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

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

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

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

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

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

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

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

148:
149: --For bug 7208046: Start
150: IF p_type = 'GB P46_5 EDI'
151: THEN
152: hr_utility.set_location(p_type,10);
153: FOR archive_rec IN csr_archive_details
154: LOOP
155: FOR asg_extra IN csr_extra_details(archive_rec.assignment_id)
156: LOOP

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

207: END IF;
208: --For bug 7208046: End
209:
210: if p_type = 'GB P46 Pension EDI' then
211: hr_utility.set_location(p_type,10);
212: for archive_rec in csr_archive_details loop
213: hr_utility.set_location(p_type,20);
214: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
215: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

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

209:
210: if p_type = 'GB P46 Pension EDI' then
211: hr_utility.set_location(p_type,10);
212: for archive_rec in csr_archive_details loop
213: hr_utility.set_location(p_type,20);
214: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
215: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
216: hr_utility.set_location(p_type,30);
217: hr_assignment_extra_info_api.update_assignment_extra_info

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

212: for archive_rec in csr_archive_details loop
213: hr_utility.set_location(p_type,20);
214: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
215: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
216: hr_utility.set_location(p_type,30);
217: hr_assignment_extra_info_api.update_assignment_extra_info
218: (p_validate => false,
219: p_object_version_number => l_ovn,
220: p_assignment_extra_info_id => l_aei_id,

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

222: p_aei_information1 => 'Y');
223: end if;
224: end loop;
225: end if;
226: hr_utility.set_location('Leaving: '||l_proc,999);
227: END;
228: --- PUBLIC PROCEDURE ---
229: PROCEDURE edi_rollback(errbuf out NOCOPY VARCHAR2,
230: retcode out NOCOPY NUMBER,

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

234: IS
235: l_proc CONSTANT VARCHAR2(50):= g_package||'edi_rollback';
236: l_id number;
237: BEGIN
238: hr_utility.set_location('Entering: '||l_proc,1);
239: hr_utility.set_location('Type : ' || p_type, 10);
240: hr_utility.set_location('Year : ' || p_year, 10);
241: hr_utility.set_location('Action : ' || p_actid, 10);
242: -- If type is on of the following, do manual stuff first

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

235: l_proc CONSTANT VARCHAR2(50):= g_package||'edi_rollback';
236: l_id number;
237: BEGIN
238: hr_utility.set_location('Entering: '||l_proc,1);
239: hr_utility.set_location('Type : ' || p_type, 10);
240: hr_utility.set_location('Year : ' || p_year, 10);
241: hr_utility.set_location('Action : ' || p_actid, 10);
242: -- If type is on of the following, do manual stuff first
243: if p_type = 'GBEDIWNU' or p_type = 'GBEDIWNU3' then -- 5398360

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

236: l_id number;
237: BEGIN
238: hr_utility.set_location('Entering: '||l_proc,1);
239: hr_utility.set_location('Type : ' || p_type, 10);
240: hr_utility.set_location('Year : ' || p_year, 10);
241: hr_utility.set_location('Action : ' || p_actid, 10);
242: -- If type is on of the following, do manual stuff first
243: if p_type = 'GBEDIWNU' or p_type = 'GBEDIWNU3' then -- 5398360
244: restored('GB WNU EDI',p_actid);

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

237: BEGIN
238: hr_utility.set_location('Entering: '||l_proc,1);
239: hr_utility.set_location('Type : ' || p_type, 10);
240: hr_utility.set_location('Year : ' || p_year, 10);
241: hr_utility.set_location('Action : ' || p_actid, 10);
242: -- If type is on of the following, do manual stuff first
243: if p_type = 'GBEDIWNU' or p_type = 'GBEDIWNU3' then -- 5398360
244: restored('GB WNU EDI',p_actid);
245: end if;

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

260: if p_type = 'P46_PENNOT_EDI' then
261: restored('GB P46 Pension EDI',p_actid);
262: end if;
263:
264: hr_utility.set_location('Calling Core Rollback routine',20);
265: -- Next called the Core's ROLLBACK routine
266: l_id := fnd_request.submit_request(application => 'PAY',
267: program => 'ROLLBACK',
268: argument1 => 'ROLLBACK',

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

273: argument6 => p_actid, -- payroll action_id
274: argument7 => null, -- assignmenet_set
275: argument8 => 'PAYROLL_ACTION_ID='||p_actid,
276: argument9 => null);
277: hr_utility.set_location('Leaving: '||l_proc,999);
278: END edi_rollback;
279:
280: END PAY_GB_EDI_ROLLBACK;