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

Line 36: --fnd_file.put_line(fnd_file.log,'Range Code 23'||p_token);

32: l_delimiter VARCHAR2(1):=' ';
33: l_proc VARCHAR2(240):= g_package||' get parameter ';
34: BEGIN
35: --
36: --fnd_file.put_line(fnd_file.log,'Range Code 23'||p_token);
37: IF g_debug THEN
38: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
39: END IF;
40: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');

Line 67: --fnd_file.put_line(fnd_file.log,'Range Code 24');

63: IF g_debug THEN
64: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
65: END IF;
66:
67: --fnd_file.put_line(fnd_file.log,'Range Code 24');
68: RETURN l_parameter;
69:
70: END;
71:

Line 95: --fnd_file.put_line(fnd_file.log,'Range Code 21'||TO_CHAR(p_payroll_action_id));

91: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
92: --
93: BEGIN
94:
95: --fnd_file.put_line(fnd_file.log,'Range Code 21'||TO_CHAR(p_payroll_action_id));
96:
97: OPEN csr_parameter_info (p_payroll_action_id);
98:
99: FETCH csr_parameter_info

Line 107: --fnd_file.put_line(fnd_file.log,'Range Code 22');

103: ,p_effective_date
104: ,p_business_group_id;
105: CLOSE csr_parameter_info;
106:
107: --fnd_file.put_line(fnd_file.log,'Range Code 22');
108: --
109: IF g_debug THEN
110: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
111: END IF;

Line 112: --fnd_file.put_line(fnd_file.log,'Range Code 22222');

108: --
109: IF g_debug THEN
110: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
111: END IF;
112: --fnd_file.put_line(fnd_file.log,'Range Code 22222');
113: END GET_ALL_PARAMETERS;
114:
115: /* RANGE CODE */
116: PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER

Line 160: --fnd_file.put_line(fnd_file.log,'InsideRange Code');

156: g_effective_date := NULL ;
157: g_person_id := NULL ;
158: g_payroll_action_id := p_payroll_action_id ;
159:
160: --fnd_file.put_line(fnd_file.log,'InsideRange Code');
161:
162: PAY_SE_ARCHIVE_TETA.GET_ALL_PARAMETERS(
163: p_payroll_action_id
164: ,g_business_group_id

Line 172: --fnd_file.put_line(fnd_file.log,'Inside Range Code Archive');

168: ,g_archive ) ;
169:
170: IF g_archive = 'Y' THEN
171:
172: --fnd_file.put_line(fnd_file.log,'Inside Range Code Archive');
173: SELECT count(*)
174: INTO l_count
175: FROM pay_action_information
176: WHERE action_information_category = 'EMEA REPORT DETAILS'

Line 182: --fnd_file.put_line(fnd_file.log,'Range Code Count');

178: AND action_context_id = p_payroll_action_id;
179:
180: IF l_count < 1 then
181:
182: --fnd_file.put_line(fnd_file.log,'Range Code Count');
183: FOR person_rec IN csr_person_details( g_person_id , g_date_report )
184: LOOP
185:
186: --fnd_file.put_line(fnd_file.log,'Range Code LOOP');

Line 186: --fnd_file.put_line(fnd_file.log,'Range Code LOOP');

182: --fnd_file.put_line(fnd_file.log,'Range Code Count');
183: FOR person_rec IN csr_person_details( g_person_id , g_date_report )
184: LOOP
185:
186: --fnd_file.put_line(fnd_file.log,'Range Code LOOP');
187: pay_action_information_api.create_action_information (
188: p_action_information_id => l_action_info_id
189: ,p_action_context_id => p_payroll_action_id
190: ,p_action_context_type => 'PA'

Line 295: --fnd_file.put_line(fnd_file.log,'Assignment Action Code');

291: IF g_debug THEN
292: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
293: END IF;
294:
295: --fnd_file.put_line(fnd_file.log,'Assignment Action Code');
296:
297: PAY_SE_ARCHIVE_TETA.GET_ALL_PARAMETERS(
298: p_payroll_action_id
299: ,g_business_group_id

Line 310: --fnd_file.put_line(fnd_file.log,'Assignment Action Code Loop');

306:
307: FOR person_assignments_rec IN csr_person_assignments( g_person_id, g_business_group_id, g_date_report)
308: LOOP
309:
310: --fnd_file.put_line(fnd_file.log,'Assignment Action Code Loop');
311:
312: SELECT pay_assignment_actions_s.NEXTVAL
313: INTO l_actid
314: FROM dual;

Line 489: --fnd_file.put_line(fnd_file.log,'Archive Code');

485: IF g_debug THEN
486: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
487: END IF;
488:
489: --fnd_file.put_line(fnd_file.log,'Archive Code');
490: IF g_archive='Y' THEN
491:
492:
493:

Line 508: --fnd_file.put_line(fnd_file.log,'Before Loop Archive Code');

504: OPEN csr_assign_id;
505: FETCH csr_assign_id INTO l_assign_id;
506: CLOSE csr_assign_id;
507:
508: --fnd_file.put_line(fnd_file.log,'Before Loop Archive Code');
509:
510: FOR person_teta_rec IN csr_person_teta( l_assign_id,g_person_id, g_business_group_id, g_date_report)
511: LOOP
512:

Line 514: --fnd_file.put_line(fnd_file.log,'Inside Loop Archive Code');

510: FOR person_teta_rec IN csr_person_teta( l_assign_id,g_person_id, g_business_group_id, g_date_report)
511: LOOP
512:
513:
514: --fnd_file.put_line(fnd_file.log,'Inside Loop Archive Code');
515:
516: OPEN csr_emp_catg( person_teta_rec.employment_category, g_date_report);
517: FETCH csr_emp_catg INTO rec_emp_catg;
518: CLOSE csr_emp_catg;

Line 572: --fnd_file.put_line(fnd_file.log,'Inside Loop Archive Code');

568: FOR person_sum_teta_rec IN csr_person_sum_teta( l_assign_id,g_person_id, g_business_group_id, g_date_report)
569: LOOP
570:
571:
572: --fnd_file.put_line(fnd_file.log,'Inside Loop Archive Code');
573:
574: OPEN csr_emp_catg( person_sum_teta_rec.employment_category, g_date_report);
575: FETCH csr_emp_catg INTO rec_emp_catg;
576: CLOSE csr_emp_catg;

Line 691: --fnd_file.put_line(fnd_file.log,'Inside Deinitialization Code');

687: ,g_archive ) ;
688:
689: g_payroll_action_id :=p_payroll_action_id;
690:
691: --fnd_file.put_line(fnd_file.log,'Inside Deinitialization Code');
692:
693: FOR person_prev_teta_rec IN csr_person_prev_teta( g_person_id, g_business_group_id, g_date_report)
694: LOOP
695:

Line 697: --fnd_file.put_line(fnd_file.log,'Inside Loop Archive Code');

693: FOR person_prev_teta_rec IN csr_person_prev_teta( g_person_id, g_business_group_id, g_date_report)
694: LOOP
695:
696:
697: --fnd_file.put_line(fnd_file.log,'Inside Loop Archive Code');
698:
699: pay_action_information_api.create_action_information (
700: p_action_information_id=> l_action_info_id,
701: p_action_context_id=> p_payroll_action_id,

Line 746: fnd_file.put_line(fnd_file.log,'Inside Loop Deinitialization Code');

742:
743: FOR sum_time_rec IN csr_sum_time
744: LOOP
745:
746: fnd_file.put_line(fnd_file.log,'Inside Loop Deinitialization Code');
747: IF sum_time_rec.total_days_worked >= 365 THEN
748:
749: l_years_worked := trunc(sum_time_rec.total_days_worked/365);
750: l_days_worked := mod(sum_time_rec.total_days_worked,365);