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

Line 147: hr_utility.set_location('Code:'||p_code||',Value:'||l_retval,52);

143: l_retval := substr(l_retval,2,(l_end_pos-l_start_pos)-2);
144: END IF;
145: END IF;
146:
147: hr_utility.set_location('Code:'||p_code||',Value:'||l_retval,52);
148:
149: return l_retval;
150:
151: END get_code_value;

Line 216: -- hr_utility.trace_on(NULL,'ZAITREF');

212: And papf.PER_INFORMATION_CATEGORY = 'ZA'; -- Bug 12991144
213:
214: BEGIN
215: -- Uncomment the below line to enable trace
216: -- hr_utility.trace_on(NULL,'ZAITREF');
217:
218: hr_utility.set_location('Entering:'||g_pkg_name,5);
219:
220: -- Find Busincess group name

Line 218: hr_utility.set_location('Entering:'||g_pkg_name,5);

214: BEGIN
215: -- Uncomment the below line to enable trace
216: -- hr_utility.trace_on(NULL,'ZAITREF');
217:
218: hr_utility.set_location('Entering:'||g_pkg_name,5);
219:
220: -- Find Busincess group name
221: SELECT pbg.name
222: INTO cp_bg_name

Line 226: hr_utility.set_location('Business Group Name:'||cp_bg_name,10);

222: INTO cp_bg_name
223: FROM per_business_groups pbg
224: WHERE pbg.business_group_id = p_business_group_id
225: AND p_effective_date BETWEEN pbg.date_from AND nvl(pbg.date_to,to_date ('31-12-4712','DD-MM-YYYY'));
226: hr_utility.set_location('Business Group Name:'||cp_bg_name,10);
227:
228: -- Get the directory path from the profile
229: --fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
230: fnd_profile.get_specific('PER_DATA_EXCHANGE_DIR',

Line 238: hr_utility.set_location('Input Directory:'|| l_location ,15);

234: l_location,
235: l_defined,
236: FND_GLOBAL.ORG_ID,
237: FND_GLOBAL.server_id);
238: hr_utility.set_location('Input Directory:'|| l_location ,15);
239: IF l_location IS NULL THEN
240: RAISE E_DATA_EX_DIR_NOT_DEFINED;
241: END IF;
242:

Line 248: hr_utility.set_location('Validate mode is false',20);

244: -- no longer required since API is not being used
245: /*
246: -- Set the processing mode
247: IF P_MODE = 'Validate and Update' THEN
248: hr_utility.set_location('Validate mode is false',20);
249: l_validate := false;
250: ELSE
251: hr_utility.set_location('Validate mode is true',25);
252: l_validate := true;

Line 251: hr_utility.set_location('Validate mode is true',25);

247: IF P_MODE = 'Validate and Update' THEN
248: hr_utility.set_location('Validate mode is false',20);
249: l_validate := false;
250: ELSE
251: hr_utility.set_location('Validate mode is true',25);
252: l_validate := true;
253: END IF;
254: */
255: -- Bug 12991144

Line 259: hr_utility.set_location(p_file_name|| ' File Opened for Processing',30);

255: -- Bug 12991144
256:
257: -- Open the CSV file for Processing
258: l_file_handle := utl_file.fopen(l_location,p_file_name,'r');
259: hr_utility.set_location(p_file_name|| ' File Opened for Processing',30);
260:
261: -- Create a Payroll action id
262: create_payroll_action();
263: hr_utility.set_location('Payroll action id:'||G_PAYROLL_ACTION_ID ,35);

Line 263: hr_utility.set_location('Payroll action id:'||G_PAYROLL_ACTION_ID ,35);

259: hr_utility.set_location(p_file_name|| ' File Opened for Processing',30);
260:
261: -- Create a Payroll action id
262: create_payroll_action();
263: hr_utility.set_location('Payroll action id:'||G_PAYROLL_ACTION_ID ,35);
264:
265: -- Read each csv record and process
266: LOOP
267: -- Read line from the file

Line 272: hr_utility.set_location('Finished Processing the file:'||p_file_name,40);

268: BEGIN
269: utl_file.get_line(l_file_handle,l_present_line);
270: EXCEPTION
271: WHEN NO_DATA_FOUND THEN -- Reached End of the file
272: hr_utility.set_location('Finished Processing the file:'||p_file_name,40);
273: UTL_FILE.FCLOSE(l_file_handle);
274: EXIT;
275: END;
276:

Line 280: hr_utility.set_location('Processing Line No:'||l_line_num,45);

276:
277: -- Process the csv line
278: IF (substr(l_present_line,1,4) = 3010) THEN
279: l_line_num := l_line_num+1;
280: hr_utility.set_location('Processing Line No:'||l_line_num,45);
281: hr_utility.set_location('Processing Line:'||l_present_line,50);
282:
283: -- Convert csv line to record
284: convert_line_to_rec(l_present_line,l_line_num,csv_rec);

Line 281: hr_utility.set_location('Processing Line:'||l_present_line,50);

277: -- Process the csv line
278: IF (substr(l_present_line,1,4) = 3010) THEN
279: l_line_num := l_line_num+1;
280: hr_utility.set_location('Processing Line No:'||l_line_num,45);
281: hr_utility.set_location('Processing Line:'||l_present_line,50);
282:
283: -- Convert csv line to record
284: convert_line_to_rec(l_present_line,l_line_num,csv_rec);
285:

Line 290: hr_utility.set_location('As no data provided by SARS, no need to process csv record of employee number:'||csv_rec.emp_num,52);

286: -- Bug 12991144
287:
288: -- Checking if the record needs to be processed depending upon the status returned by SARS
289: IF upper(csv_rec.status) in ('TAXPAYER TO CONTACT SARS', 'INSUFFICIENT INFORMATION', 'NOT VERIFIED', 'NON-INDIVIDUAL') THEN
290: hr_utility.set_location('As no data provided by SARS, no need to process csv record of employee number:'||csv_rec.emp_num,52);
291: create_action_information(csv_rec,'NA');
292: ELSIF upper(csv_rec.status) in ('REGISTERED', 'EXISTING TAXPAYER') THEN
293:
294: -- Bug 12991144

Line 298: hr_utility.set_location('Processing csv record of employee number:'||csv_rec.emp_num,55);

294: -- Bug 12991144
295:
296: -- Check if employee number and tax ref number exists
297: IF (csv_rec.emp_num IS NOT NULL AND csv_rec.tax_ref_num IS NOT NULL) THEN
298: hr_utility.set_location('Processing csv record of employee number:'||csv_rec.emp_num,55);
299: OPEN csr_find_by_emp_num(csv_rec.emp_num);
300: FETCH csr_find_by_emp_num into l_person_rec;
301:
302: IF (csr_find_by_emp_num%NOTFOUND) THEN

Line 329: hr_utility.set_location('Processing employee number in Mode:'||l_datetrack_update_mode,60);

325: ELSE
326: l_datetrack_update_mode := 'CORRECTION';
327: l_result := 'FC';
328: END IF;
329: hr_utility.set_location('Processing employee number in Mode:'||l_datetrack_update_mode,60);
330: BEGIN
331: hr_person_api.update_person(p_validate => l_validate
332: ,p_effective_date => p_effective_date
333: ,p_datetrack_update_mode => l_datetrack_update_mode

Line 352: hr_utility.set_location('Updated Employee IT Ref number:'||l_person_rec.employee_number,65);

348: */
349: -- Bug 12991144
350: -- Report the record as Sucessfully Processed
351: create_action_information(csv_rec,l_result,null,l_person_rec.per_information1);
352: hr_utility.set_location('Updated Employee IT Ref number:'||l_person_rec.employee_number,65);
353:
354: -- Bug 12991144
355: /* ELSE
356: -- Report the record as Error While Processing

Line 357: create_action_information(csv_rec,'CE',SUBSTR(hr_utility.get_message,1,100));

353:
354: -- Bug 12991144
355: /* ELSE
356: -- Report the record as Error While Processing
357: create_action_information(csv_rec,'CE',SUBSTR(hr_utility.get_message,1,100));
358: hr_utility.set_location('Error in Updating Employee IT Ref number'||l_person_rec.employee_number,68);
359: END IF;
360: */
361: -- Bug 12991144

Line 358: hr_utility.set_location('Error in Updating Employee IT Ref number'||l_person_rec.employee_number,68);

354: -- Bug 12991144
355: /* ELSE
356: -- Report the record as Error While Processing
357: create_action_information(csv_rec,'CE',SUBSTR(hr_utility.get_message,1,100));
358: hr_utility.set_location('Error in Updating Employee IT Ref number'||l_person_rec.employee_number,68);
359: END IF;
360: */
361: -- Bug 12991144
362: EXCEPTION

Line 364: hr_utility.set_location('Error in Updating Employee IT Ref number'||l_person_rec.employee_number,70);

360: */
361: -- Bug 12991144
362: EXCEPTION
363: WHEN OTHERS THEN
364: hr_utility.set_location('Error in Updating Employee IT Ref number'||l_person_rec.employee_number,70);
365: hr_utility.set_location('Error:'||SUBSTR(hr_utility.get_message,1,100),76);
366: -- Report the record as Error While Processing
367: create_action_information(csv_rec,'CE',SUBSTR(hr_utility.get_message,1,100));
368: END;

Line 365: hr_utility.set_location('Error:'||SUBSTR(hr_utility.get_message,1,100),76);

361: -- Bug 12991144
362: EXCEPTION
363: WHEN OTHERS THEN
364: hr_utility.set_location('Error in Updating Employee IT Ref number'||l_person_rec.employee_number,70);
365: hr_utility.set_location('Error:'||SUBSTR(hr_utility.get_message,1,100),76);
366: -- Report the record as Error While Processing
367: create_action_information(csv_rec,'CE',SUBSTR(hr_utility.get_message,1,100));
368: END;
369: ELSE -- CSV ITREF and Employee ITREF is same

Line 367: create_action_information(csv_rec,'CE',SUBSTR(hr_utility.get_message,1,100));

363: WHEN OTHERS THEN
364: hr_utility.set_location('Error in Updating Employee IT Ref number'||l_person_rec.employee_number,70);
365: hr_utility.set_location('Error:'||SUBSTR(hr_utility.get_message,1,100),76);
366: -- Report the record as Error While Processing
367: create_action_information(csv_rec,'CE',SUBSTR(hr_utility.get_message,1,100));
368: END;
369: ELSE -- CSV ITREF and Employee ITREF is same
370: -- Report ITREF is same in both CSV Record and employee
371: create_action_information(csv_rec,'DS');

Line 389: --hr_utility.trace_off;

385: END IF;
386:
387: END LOOP;
388:
389: --hr_utility.trace_off;
390: return true;
391:
392:
393: EXCEPTION

Line 395: hr_utility.set_location('Exception :'||g_pkg_name,100);

391:
392:
393: EXCEPTION
394: WHEN E_DATA_EX_DIR_NOT_DEFINED THEN
395: hr_utility.set_location('Exception :'||g_pkg_name,100);
396: ROLLBACK;
397: RAISE_APPLICATION_ERROR(-20010,'Input directory not defined. Set PER_DATA_EXCHANGE_DIR profile (HR: Data Exchange directory).');
398: WHEN UTL_FILE.INVALID_OPERATION THEN
399: UTL_FILE.FCLOSE(l_file_handle);

Line 400: hr_utility.set_location('Exception :'||g_pkg_name,110);

396: ROLLBACK;
397: RAISE_APPLICATION_ERROR(-20010,'Input directory not defined. Set PER_DATA_EXCHANGE_DIR profile (HR: Data Exchange directory).');
398: WHEN UTL_FILE.INVALID_OPERATION THEN
399: UTL_FILE.FCLOSE(l_file_handle);
400: hr_utility.set_location('Exception :'||g_pkg_name,110);
401: ROLLBACK;
402: RAISE;
403: WHEN UTL_FILE.INTERNAL_ERROR THEN
404: UTL_FILE.FCLOSE(l_file_handle);

Line 405: hr_utility.set_location('Exception :'||g_pkg_name,120);

401: ROLLBACK;
402: RAISE;
403: WHEN UTL_FILE.INTERNAL_ERROR THEN
404: UTL_FILE.FCLOSE(l_file_handle);
405: hr_utility.set_location('Exception :'||g_pkg_name,120);
406: ROLLBACK;
407: RAISE;
408: WHEN UTL_FILE.INVALID_MODE THEN
409: UTL_FILE.FCLOSE(l_file_handle);

Line 410: hr_utility.set_location('Exception :'||g_pkg_name,130);

406: ROLLBACK;
407: RAISE;
408: WHEN UTL_FILE.INVALID_MODE THEN
409: UTL_FILE.FCLOSE(l_file_handle);
410: hr_utility.set_location('Exception :'||g_pkg_name,130);
411: ROLLBACK;
412: RAISE;
413: WHEN UTL_FILE.INVALID_PATH THEN
414: UTL_FILE.FCLOSE(l_file_handle);

Line 415: hr_utility.set_location('Exception :'||g_pkg_name,140);

411: ROLLBACK;
412: RAISE;
413: WHEN UTL_FILE.INVALID_PATH THEN
414: UTL_FILE.FCLOSE(l_file_handle);
415: hr_utility.set_location('Exception :'||g_pkg_name,140);
416: ROLLBACK;
417: RAISE;
418: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
419: UTL_FILE.FCLOSE(l_file_handle);

Line 420: hr_utility.set_location('Exception :'||g_pkg_name,150);

416: ROLLBACK;
417: RAISE;
418: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
419: UTL_FILE.FCLOSE(l_file_handle);
420: hr_utility.set_location('Exception :'||g_pkg_name,150);
421: ROLLBACK;
422: RAISE;
423: WHEN UTL_FILE.READ_ERROR THEN
424: UTL_FILE.FCLOSE(l_file_handle);

Line 425: hr_utility.set_location('Exception :'||g_pkg_name,160);

421: ROLLBACK;
422: RAISE;
423: WHEN UTL_FILE.READ_ERROR THEN
424: UTL_FILE.FCLOSE(l_file_handle);
425: hr_utility.set_location('Exception :'||g_pkg_name,160);
426: ROLLBACK;
427: RAISE;
428: WHEN NO_DATA_FOUND THEN
429: UTL_FILE.FCLOSE(l_file_handle);

Line 430: hr_utility.set_location('Exception :'||g_pkg_name,170);

426: ROLLBACK;
427: RAISE;
428: WHEN NO_DATA_FOUND THEN
429: UTL_FILE.FCLOSE(l_file_handle);
430: hr_utility.set_location('Exception :'||g_pkg_name,170);
431: ROLLBACK;
432: RAISE;
433: WHEN OTHERS THEN
434: UTL_FILE.FCLOSE(l_file_handle);

Line 435: hr_utility.set_location('Exception :'||g_pkg_name,180);

431: ROLLBACK;
432: RAISE;
433: WHEN OTHERS THEN
434: UTL_FILE.FCLOSE(l_file_handle);
435: hr_utility.set_location('Exception :'||g_pkg_name,180);
436: ROLLBACK;
437: RAISE;
438:
439: END BEFOREREPORT;