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_SE_ALECTA_UPLOAD dependencies on FND_FILE

Line 54: -- fnd_file.put_line(fnd_file.log,'$$ Entering'||l_proc);

50: hr_utility.set_location('p_file_name '||p_file_name,1);
51: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
52:
53: hr_utility.set_location ( 'Entering:' || l_proc, 10);
54: -- fnd_file.put_line(fnd_file.log,'$$ Entering'||l_proc);
55:
56: OPEN csr_leg (p_business_group_id);
57: FETCH csr_leg INTO l_legislation_code, l_bg_name;
58: CLOSE csr_leg;

Line 61: -- fnd_file.put_line(fnd_file.log,'$$ l_legislation_code'||l_legislation_code);

57: FETCH csr_leg INTO l_legislation_code, l_bg_name;
58: CLOSE csr_leg;
59:
60: hr_utility.set_location ( 'Legislation = ' || l_legislation_code, 20);
61: -- fnd_file.put_line(fnd_file.log,'$$ l_legislation_code'||l_legislation_code);
62:
63: l_filename := p_file_name;
64: fnd_profile.get (c_data_exchange_dir, l_location);
65:

Line 67: -- fnd_file.put_line(fnd_file.log,'$$ l_location'||l_location);

63: l_filename := p_file_name;
64: fnd_profile.get (c_data_exchange_dir, l_location);
65:
66: hr_utility.set_location ( 'Directory = ' || l_location, 30);
67: -- fnd_file.put_line(fnd_file.log,'$$ l_location'||l_location);
68:
69: IF l_location IS NULL
70: THEN
71: hr_utility.set_location ( 'Raising I/O error = ' || l_location, 35);

Line 109: -- fnd_file.put_line(fnd_file.log,'$$ l_record_found'||l_record_found);

105: ,p_record_found => l_record_found
106: );
107:
108: hr_utility.set_location ( ' l_record_found = ' || l_record_found, 130);
109: -- fnd_file.put_line(fnd_file.log,'$$ l_record_found'||l_record_found);
110:
111: if l_record_found = 0 then
112: hr_utility.set_location ( ' Record not found', 110);
113: RAISE e_record_not_found;

Line 124: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

120: retcode := c_warning;
121: hr_utility.set_message (801, 'HR_377018_DK_INVALID_RECORD');
122: hr_utility.set_message_token (801, 'LINE', l_line_read);
123: hr_utility.set_location (l_proc, 260);
124: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
125: END;
126: END LOOP read_lines_in_file;
127:
128: UTL_FILE.fclose (l_file_type);

Line 238: --fnd_file.put_line(fnd_file.log,''||p_line);

234:
235: BEGIN
236:
237: hr_utility.set_location ( 'Entering:'|| l_proc, 70);
238: --fnd_file.put_line(fnd_file.log,''||p_line);
239:
240: l_org_number := get_token(p_line,1);
241: l_cost_centre := get_token(p_line,2);
242: l_agreed_product_id := get_token(p_line,3);

Line 256: /* fnd_file.put_line(fnd_file.log,'$$ l_org_number'||l_org_number);

252:
253: l_org_number := replace(l_org_number,'-',''); -- Bug#9345105 fix
254: l_person_number := replace(l_person_number,'-',''); -- Bug#9345105 fix
255:
256: /* fnd_file.put_line(fnd_file.log,'$$ l_org_number'||l_org_number);
257: fnd_file.put_line(fnd_file.log,'$$ l_cost_centre'||l_cost_centre);
258: fnd_file.put_line(fnd_file.log,'$$ l_agreed_product_id'||l_agreed_product_id);
259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);
260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);

Line 257: fnd_file.put_line(fnd_file.log,'$$ l_cost_centre'||l_cost_centre);

253: l_org_number := replace(l_org_number,'-',''); -- Bug#9345105 fix
254: l_person_number := replace(l_person_number,'-',''); -- Bug#9345105 fix
255:
256: /* fnd_file.put_line(fnd_file.log,'$$ l_org_number'||l_org_number);
257: fnd_file.put_line(fnd_file.log,'$$ l_cost_centre'||l_cost_centre);
258: fnd_file.put_line(fnd_file.log,'$$ l_agreed_product_id'||l_agreed_product_id);
259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);
260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);
261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);

Line 258: fnd_file.put_line(fnd_file.log,'$$ l_agreed_product_id'||l_agreed_product_id);

254: l_person_number := replace(l_person_number,'-',''); -- Bug#9345105 fix
255:
256: /* fnd_file.put_line(fnd_file.log,'$$ l_org_number'||l_org_number);
257: fnd_file.put_line(fnd_file.log,'$$ l_cost_centre'||l_cost_centre);
258: fnd_file.put_line(fnd_file.log,'$$ l_agreed_product_id'||l_agreed_product_id);
259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);
260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);
261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);
262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);

Line 259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);

255:
256: /* fnd_file.put_line(fnd_file.log,'$$ l_org_number'||l_org_number);
257: fnd_file.put_line(fnd_file.log,'$$ l_cost_centre'||l_cost_centre);
258: fnd_file.put_line(fnd_file.log,'$$ l_agreed_product_id'||l_agreed_product_id);
259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);
260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);
261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);
262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);
263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);

Line 260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);

256: /* fnd_file.put_line(fnd_file.log,'$$ l_org_number'||l_org_number);
257: fnd_file.put_line(fnd_file.log,'$$ l_cost_centre'||l_cost_centre);
258: fnd_file.put_line(fnd_file.log,'$$ l_agreed_product_id'||l_agreed_product_id);
259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);
260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);
261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);
262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);
263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);
264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);

Line 261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);

257: fnd_file.put_line(fnd_file.log,'$$ l_cost_centre'||l_cost_centre);
258: fnd_file.put_line(fnd_file.log,'$$ l_agreed_product_id'||l_agreed_product_id);
259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);
260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);
261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);
262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);
263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);
264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);
265: fnd_file.put_line(fnd_file.log,'$$ l_sick_leave'||l_sick_leave);

Line 262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);

258: fnd_file.put_line(fnd_file.log,'$$ l_agreed_product_id'||l_agreed_product_id);
259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);
260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);
261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);
262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);
263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);
264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);
265: fnd_file.put_line(fnd_file.log,'$$ l_sick_leave'||l_sick_leave);
266: fnd_file.put_line(fnd_file.log,'$$ l_parental_leave'||l_parental_leave);

Line 263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);

259: fnd_file.put_line(fnd_file.log,'$$ l_person_number'||l_person_number);
260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);
261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);
262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);
263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);
264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);
265: fnd_file.put_line(fnd_file.log,'$$ l_sick_leave'||l_sick_leave);
266: fnd_file.put_line(fnd_file.log,'$$ l_parental_leave'||l_parental_leave);
267: fnd_file.put_line(fnd_file.log,'$$ l_leave_of_absence'||l_leave_of_absence);

Line 264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);

260: fnd_file.put_line(fnd_file.log,'$$ l_last_name'||l_last_name);
261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);
262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);
263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);
264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);
265: fnd_file.put_line(fnd_file.log,'$$ l_sick_leave'||l_sick_leave);
266: fnd_file.put_line(fnd_file.log,'$$ l_parental_leave'||l_parental_leave);
267: fnd_file.put_line(fnd_file.log,'$$ l_leave_of_absence'||l_leave_of_absence);
268: */

Line 265: fnd_file.put_line(fnd_file.log,'$$ l_sick_leave'||l_sick_leave);

261: fnd_file.put_line(fnd_file.log,'$$ l_first_name'||l_first_name);
262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);
263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);
264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);
265: fnd_file.put_line(fnd_file.log,'$$ l_sick_leave'||l_sick_leave);
266: fnd_file.put_line(fnd_file.log,'$$ l_parental_leave'||l_parental_leave);
267: fnd_file.put_line(fnd_file.log,'$$ l_leave_of_absence'||l_leave_of_absence);
268: */
269:

Line 266: fnd_file.put_line(fnd_file.log,'$$ l_parental_leave'||l_parental_leave);

262: fnd_file.put_line(fnd_file.log,'$$ l_salary'||l_salary);
263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);
264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);
265: fnd_file.put_line(fnd_file.log,'$$ l_sick_leave'||l_sick_leave);
266: fnd_file.put_line(fnd_file.log,'$$ l_parental_leave'||l_parental_leave);
267: fnd_file.put_line(fnd_file.log,'$$ l_leave_of_absence'||l_leave_of_absence);
268: */
269:
270: /*

Line 267: fnd_file.put_line(fnd_file.log,'$$ l_leave_of_absence'||l_leave_of_absence);

263: fnd_file.put_line(fnd_file.log,'$$ l_time_of_event'||l_time_of_event);
264: fnd_file.put_line(fnd_file.log,'$$ l_alt_itp'||l_alt_itp);
265: fnd_file.put_line(fnd_file.log,'$$ l_sick_leave'||l_sick_leave);
266: fnd_file.put_line(fnd_file.log,'$$ l_parental_leave'||l_parental_leave);
267: fnd_file.put_line(fnd_file.log,'$$ l_leave_of_absence'||l_leave_of_absence);
268: */
269:
270: /*
271: ----------- Four cases -----------

Line 284: fnd_file.put_line(fnd_file.log,'## Case 1 New entry');

280: where org no, cost centre, agreed product, person no, time for event, last name,
281: first name, salary details are available
282: */
283: IF (l_first_name IS NOT NULL AND l_last_name IS NOT NULL) THEN
284: fnd_file.put_line(fnd_file.log,'## Case 1 New entry');
285: SELECT COUNT ('1') INTO l_record_found
286: FROM pay_action_information
287: WHERE action_information_category = 'EMEA REPORT INFORMATION'
288: AND action_information1 = 'PYSEALEA'

Line 304: fnd_file.put_line(fnd_file.log,'## Case 2 Moving with in comapnay');

300: where org no, cost centre, agreed plan, person no, time for event, salary deatails
301: are available
302: */
303: ELSIF (l_agreed_product_id IS NOT NULL) THEN
304: fnd_file.put_line(fnd_file.log,'## Case 2 Moving with in comapnay');
305: SELECT COUNT ('1') INTO l_record_found
306: FROM pay_action_information
307: WHERE action_information_category = 'EMEA REPORT INFORMATION'
308: AND action_information1 = 'PYSEALEA'

Line 321: fnd_file.put_line(fnd_file.log,'## Case 3 Salary change');

317: ----------- Case 3 Salary Change --------------
318: where org no, cost centre, person no, time for event, salary details are available
319: */
320: ELSIF (l_salary IS NOT NULL ) THEN
321: fnd_file.put_line(fnd_file.log,'## Case 3 Salary change');
322: SELECT COUNT ('1') INTO l_record_found
323: FROM pay_action_information
324: WHERE action_information_category = 'EMEA REPORT INFORMATION'
325: AND action_information1 = 'PYSEALEA'

Line 337: fnd_file.put_line(fnd_file.log,'## Case 4 Withdrawl');

333: ------------- Case 4 withdrawl ------------
334: where org no, cost centre, person no, time for event details are available
335: */
336: ELSE
337: fnd_file.put_line(fnd_file.log,'## Case 4 Withdrawl');
338: SELECT COUNT ('1') INTO l_record_found
339: FROM pay_action_information
340: WHERE action_information_category = 'EMEA REPORT INFORMATION'
341: AND action_information1 = 'PYSEALEA'

Line 350: --fnd_file.put_line(fnd_file.log,'## l_record_found'||l_record_found);

346: END IF;
347: END IF;
348:
349: p_record_found := l_record_found;
350: --fnd_file.put_line(fnd_file.log,'## l_record_found'||l_record_found);
351: hr_utility.set_location ( 'Leaving:'|| l_proc, 120);
352:
353: END compare_record;
354: