APPS.PAY_FR_UPDATE_PCS_CODE dependencies on FND_FILE

Line 42: fnd_file.put_line(fnd_file.log, get_pcs_code.job_name||', old pcs code '|| get_pcs_code.pcs_code||l_value||' '||get_pcs_code.job_id);

38: FETCH csr_get_new_code INTO l_new_code;
39: CLOSE csr_get_new_code;
40: IF l_new_code IS NULL THEN
41: l_value := pay_fr_general.get_payroll_message('PAY_75193_OLD_CODE', null, null, null);
42: fnd_file.put_line(fnd_file.log, get_pcs_code.job_name||', old pcs code '|| get_pcs_code.pcs_code||l_value||' '||get_pcs_code.job_id);
43: /* Making the old pcs code to be null. The user will take the jobs from the log message and change the
44: old pcs codes to new pcs codes manually */
45: update per_jobs
46: set job_information1 = NULL

Line 57: fnd_file.put_line(fnd_file.log, get_pcs_code.job_name||', old pcs code '|| get_pcs_code.pcs_code||' converted to ' ||l_new_code||'. '||l_value||' '||get_pcs_code.job_id);

53: where business_group_id = p_business_group_id
54: and JOB_INFORMATION_CATEGORY = 'FR'
55: and job_id = get_pcs_code.job_id;
56: l_value := pay_fr_general.get_payroll_message('PAY_75194_UPDATED', null, null, null);
57: fnd_file.put_line(fnd_file.log, get_pcs_code.job_name||', old pcs code '|| get_pcs_code.pcs_code||' converted to ' ||l_new_code||'. '||l_value||' '||get_pcs_code.job_id);
58: END IF;
59: END LOOP;
60: end update_old_pcs_codes;
61: