APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on HR_UTILITY

Line 123: --hr_utility.trace_on(null,'ORACLE');

119: open c_geocode_patch_name;
120:
121: loop
122:
123: --hr_utility.trace_on(null,'ORACLE');
124:
125: fetch c_geocode_patch_name
126: into l_patch_name,
127: l_year;

Line 131: hr_utility.trace('l_patch_name = ' || l_patch_name);

127: l_year;
128:
129: exit when c_geocode_patch_name%NOTFOUND;
130:
131: hr_utility.trace('l_patch_name = ' || l_patch_name);
132: hr_utility.trace('l_year = ' || l_year);
133:
134: --place the log info into the concurrent log file generated by application
135: fnd_file.put_line(fnd_file.log, l_patch_name||' '|| l_year);

Line 132: hr_utility.trace('l_year = ' || l_year);

128:
129: exit when c_geocode_patch_name%NOTFOUND;
130:
131: hr_utility.trace('l_patch_name = ' || l_patch_name);
132: hr_utility.trace('l_year = ' || l_year);
133:
134: --place the log info into the concurrent log file generated by application
135: fnd_file.put_line(fnd_file.log, l_patch_name||' '|| l_year);
136:

Line 145: hr_utility.trace('l_patch_status = ' || l_patch_status);

141: open c_geocode_patch_status (l_patch_name);
142: fetch c_geocode_patch_status
143: into l_patch_status;
144:
145: hr_utility.trace('l_patch_status = ' || l_patch_status);
146:
147:
148: --place the log info into the concurrent log file generated by application
149: --fnd_file.put_line(fnd_file.log, 'status = '|| nvl(l_patch_status,'null'));

Line 180: hr_utility.trace('Inside ');

176: close c_geo_check_ca_assignments;
177:
178: IF l_ca_count >0 or l_us_count > 0 THEN -- Bug 5599273
179:
180: hr_utility.trace('Inside ');
181: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
182: retcode := 0;
183: -- get printing info
184: req_id:=fnd_profile.value('CONC_REQUEST_ID');

Line 210: hr_utility.trace(' call set print options');

206: else
207: save_buffer:=NULL;
208: end if;
209:
210: hr_utility.trace(' call set print options');
211:
212: -- get start of list
213: start_index:=1;
214: -- get end of list

Line 251: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

247: EXCEPTION
248:
249: WHEN OTHERS THEN
250:
251: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
252:
253: END ;
254:
255: commit;

Line 268: hr_utility.trace(' in ELSE');

264:
265:
266:
267: ELSE
268: hr_utility.trace(' in ELSE');
269: insert into pay_patch_status
270: (ID,
271: PATCH_NUMBER,
272: PATCH_NAME,

Line 296: hr_utility.trace(' status complete patch_name = ' || l_patch_name );

292: 'US',
293: '115',
294: 'Q2' );
295: END IF; --l_us_count IF
296: hr_utility.trace(' status complete patch_name = ' || l_patch_name );
297: open c_geo_patch_comp_stat(l_patch_name);
298:
299: fetch c_geo_patch_comp_stat
300: into l_completion_patch_status;

Line 302: hr_utility.trace('l_completion_patch_status = ' || l_completion_patch_status);

298:
299: fetch c_geo_patch_comp_stat
300: into l_completion_patch_status;
301:
302: hr_utility.trace('l_completion_patch_status = ' || l_completion_patch_status);
303:
304:
305: --place the log info into the concurrent log file generated by application
306: fnd_file.put_line(fnd_file.log, 'completion status = '|| l_completion_patch_status);

Line 332: hr_utility.trace('JIT patch has not been applied prior to running upgrade');

328: close c_geocode_patch_name;
329:
330: else -- max_geocode_patch_name%FOUND
331: -- Skip processing as the PREREQUSITE JIT patch has not been applied
332: hr_utility.trace('JIT patch has not been applied prior to running upgrade');
333:
334: end if;
335:
336: close c_max_geocode_patch_name;

Line 355: errbuf := hr_utility.get_message;

351: fnd_message.set_name('PAY', 'HR_75258_GEOCODE_PATCH_ERROR');
352: fnd_message.set_token('PATCH_NAME', l_patch_name);
353: fnd_message.set_token('REQ_ID', ('o' || l_req_id || '.out') );
354:
355: errbuf := hr_utility.get_message;
356: retcode := 2;
357: RAISE;
358: --
359:

Line 365: hr_utility.trace('sqlerrm = ' || sqlerrm);

361: WHEN others THEN
362: --
363: -- Set up error message and return code.
364: --
365: hr_utility.trace('sqlerrm = ' || sqlerrm);
366: errbuf := sqlerrm;
367: retcode := 2;
368:
369: end GEOCODE_UPGRADE;