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.PQP_GB_PENSRV_SVPN dependencies on FND_FILE

Line 143: fnd_file.put_line(fnd_file.log,'Entering ' || g_package_name || l_procedure_name);

139: l_procedure_name := '.derive_svpn';
140:
141: hr_utility.set_location('Entering ' || g_package_name || l_procedure_name,0);
142:
143: fnd_file.put_line(fnd_file.log,'Entering ' || g_package_name || l_procedure_name);
144: --fnd_file.put_line(fnd_file.log,'p_business_group_id '||p_business_group_id);
145: --fnd_file.put_line(fnd_file.log,'p_eff_end_date '||p_eff_end_date);
146: --fnd_file.put_line(fnd_file.log,'p_execution_mode '||p_execution_mode);
147:

Line 144: --fnd_file.put_line(fnd_file.log,'p_business_group_id '||p_business_group_id);

140:
141: hr_utility.set_location('Entering ' || g_package_name || l_procedure_name,0);
142:
143: fnd_file.put_line(fnd_file.log,'Entering ' || g_package_name || l_procedure_name);
144: --fnd_file.put_line(fnd_file.log,'p_business_group_id '||p_business_group_id);
145: --fnd_file.put_line(fnd_file.log,'p_eff_end_date '||p_eff_end_date);
146: --fnd_file.put_line(fnd_file.log,'p_execution_mode '||p_execution_mode);
147:
148: g_business_group_id := p_business_group_id;

Line 145: --fnd_file.put_line(fnd_file.log,'p_eff_end_date '||p_eff_end_date);

141: hr_utility.set_location('Entering ' || g_package_name || l_procedure_name,0);
142:
143: fnd_file.put_line(fnd_file.log,'Entering ' || g_package_name || l_procedure_name);
144: --fnd_file.put_line(fnd_file.log,'p_business_group_id '||p_business_group_id);
145: --fnd_file.put_line(fnd_file.log,'p_eff_end_date '||p_eff_end_date);
146: --fnd_file.put_line(fnd_file.log,'p_execution_mode '||p_execution_mode);
147:
148: g_business_group_id := p_business_group_id;
149: g_eff_end_date := fnd_date.canonical_to_date(p_eff_end_date);

Line 146: --fnd_file.put_line(fnd_file.log,'p_execution_mode '||p_execution_mode);

142:
143: fnd_file.put_line(fnd_file.log,'Entering ' || g_package_name || l_procedure_name);
144: --fnd_file.put_line(fnd_file.log,'p_business_group_id '||p_business_group_id);
145: --fnd_file.put_line(fnd_file.log,'p_eff_end_date '||p_eff_end_date);
146: --fnd_file.put_line(fnd_file.log,'p_execution_mode '||p_execution_mode);
147:
148: g_business_group_id := p_business_group_id;
149: g_eff_end_date := fnd_date.canonical_to_date(p_eff_end_date);
150:

Line 152: fnd_file.put_line(fnd_file.log,'Effective End Date should be greater than or equal to 31-JUL-2007.');

148: g_business_group_id := p_business_group_id;
149: g_eff_end_date := fnd_date.canonical_to_date(p_eff_end_date);
150:
151: IF g_eff_end_date < g_eff_start_date THEN
152: fnd_file.put_line(fnd_file.log,'Effective End Date should be greater than or equal to 31-JUL-2007.');
153: ELSE
154: OPEN csr_svpn_maintain_flag;
155: FETCH csr_svpn_maintain_flag INTO g_svpn_flag;
156: CLOSE csr_svpn_maintain_flag;

Line 164: fnd_file.put_line(fnd_file.log,'Maintain Service Period Number flag is set to Yes for the configuration PAYPOINT and CUTOVER INFORMATION.

160: -- Checking whether Maintain Service period flag is enabled or not.
161:
162: IF g_svpn_flag = 'Yes' THEN
163:
164: fnd_file.put_line(fnd_file.log,'Maintain Service Period Number flag is set to Yes for the configuration PAYPOINT and CUTOVER INFORMATION.
165: Concurrent Process will be executed to set the SPN only when the flag is not set to Yes.');
166: ELSE
167:
168: OPEN csr_pensrv_eligibility;

Line 173: --fnd_file.put_line(fnd_file.log,'g_asg_membership_context'||g_asg_membership_context);

169: FETCH csr_pensrv_eligibility INTO g_asg_membership_context,
170: g_asg_membership_col;
171: CLOSE csr_pensrv_eligibility;
172:
173: --fnd_file.put_line(fnd_file.log,'g_asg_membership_context'||g_asg_membership_context);
174: --fnd_file.put_line(fnd_file.log,'g_asg_membership_col '||g_asg_membership_col);
175:
176: -- Checking whether Pension Scheme Eligibility Configuration is configured or not
177:

Line 174: --fnd_file.put_line(fnd_file.log,'g_asg_membership_col '||g_asg_membership_col);

170: g_asg_membership_col;
171: CLOSE csr_pensrv_eligibility;
172:
173: --fnd_file.put_line(fnd_file.log,'g_asg_membership_context'||g_asg_membership_context);
174: --fnd_file.put_line(fnd_file.log,'g_asg_membership_col '||g_asg_membership_col);
175:
176: -- Checking whether Pension Scheme Eligibility Configuration is configured or not
177:
178: IF g_asg_membership_context IS NULL

Line 182: fnd_file.put_line(fnd_file.log,'Assignment Flexfield Context and Assignment Flexfield Column Name is

178: IF g_asg_membership_context IS NULL
179: OR
180: g_asg_membership_col IS NULL
181: THEN
182: fnd_file.put_line(fnd_file.log,'Assignment Flexfield Context and Assignment Flexfield Column Name is
183: Not configured under Pension Scheme Eligibilty Configuration for Penserver Interfaces.');
184: END IF;
185: END IF;
186:

Line 193: --fnd_file.put_line(fnd_file.log,' g_eff_end_date '|| g_eff_end_date );

189: IF g_asg_membership_context IS NOT NULL AND g_asg_membership_col IS NOT NULL
190: THEN
191: l_spn := 1;
192:
193: --fnd_file.put_line(fnd_file.log,' g_eff_end_date '|| g_eff_end_date );
194:
195: -- Service Period Number details writing into the out put file
196:
197: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

Line 197: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

193: --fnd_file.put_line(fnd_file.log,' g_eff_end_date '|| g_eff_end_date );
194:
195: -- Service Period Number details writing into the out put file
196:
197: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
198: fnd_file.put_line(FND_FILE.OUTPUT,' Service Period Number details for employees in Business group: '||rpad(g_business_group_id,30));
199: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| sysdate);
200: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
201: fnd_file.put_line(FND_FILE.OUTPUT,' ');

Line 198: fnd_file.put_line(FND_FILE.OUTPUT,' Service Period Number details for employees in Business group: '||rpad(g_business_group_id,30));

194:
195: -- Service Period Number details writing into the out put file
196:
197: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
198: fnd_file.put_line(FND_FILE.OUTPUT,' Service Period Number details for employees in Business group: '||rpad(g_business_group_id,30));
199: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| sysdate);
200: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
201: fnd_file.put_line(FND_FILE.OUTPUT,' ');
202: fnd_file.put_line(FND_FILE.OUTPUT, rpad('National Identifier',20)||' '||rpad('Person Number',20)||' '||rpad('Assignment Number',20)||' '||rpad('Service Period Number',22));

Line 199: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| sysdate);

195: -- Service Period Number details writing into the out put file
196:
197: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
198: fnd_file.put_line(FND_FILE.OUTPUT,' Service Period Number details for employees in Business group: '||rpad(g_business_group_id,30));
199: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| sysdate);
200: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
201: fnd_file.put_line(FND_FILE.OUTPUT,' ');
202: fnd_file.put_line(FND_FILE.OUTPUT, rpad('National Identifier',20)||' '||rpad('Person Number',20)||' '||rpad('Assignment Number',20)||' '||rpad('Service Period Number',22));
203: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

Line 200: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

196:
197: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
198: fnd_file.put_line(FND_FILE.OUTPUT,' Service Period Number details for employees in Business group: '||rpad(g_business_group_id,30));
199: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| sysdate);
200: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
201: fnd_file.put_line(FND_FILE.OUTPUT,' ');
202: fnd_file.put_line(FND_FILE.OUTPUT, rpad('National Identifier',20)||' '||rpad('Person Number',20)||' '||rpad('Assignment Number',20)||' '||rpad('Service Period Number',22));
203: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
204:

Line 201: fnd_file.put_line(FND_FILE.OUTPUT,' ');

197: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
198: fnd_file.put_line(FND_FILE.OUTPUT,' Service Period Number details for employees in Business group: '||rpad(g_business_group_id,30));
199: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| sysdate);
200: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
201: fnd_file.put_line(FND_FILE.OUTPUT,' ');
202: fnd_file.put_line(FND_FILE.OUTPUT, rpad('National Identifier',20)||' '||rpad('Person Number',20)||' '||rpad('Assignment Number',20)||' '||rpad('Service Period Number',22));
203: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
204:
205: -- For each assignment checking whether the assignment is eligible for genertion of service period number

Line 202: fnd_file.put_line(FND_FILE.OUTPUT, rpad('National Identifier',20)||' '||rpad('Person Number',20)||' '||rpad('Assignment Number',20)||' '||rpad('Service Period Number',22));

198: fnd_file.put_line(FND_FILE.OUTPUT,' Service Period Number details for employees in Business group: '||rpad(g_business_group_id,30));
199: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| sysdate);
200: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
201: fnd_file.put_line(FND_FILE.OUTPUT,' ');
202: fnd_file.put_line(FND_FILE.OUTPUT, rpad('National Identifier',20)||' '||rpad('Person Number',20)||' '||rpad('Assignment Number',20)||' '||rpad('Service Period Number',22));
203: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
204:
205: -- For each assignment checking whether the assignment is eligible for genertion of service period number
206: -- and generting SPN for valid assignments

Line 203: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

199: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| sysdate);
200: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
201: fnd_file.put_line(FND_FILE.OUTPUT,' ');
202: fnd_file.put_line(FND_FILE.OUTPUT, rpad('National Identifier',20)||' '||rpad('Person Number',20)||' '||rpad('Assignment Number',20)||' '||rpad('Service Period Number',22));
203: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
204:
205: -- For each assignment checking whether the assignment is eligible for genertion of service period number
206: -- and generting SPN for valid assignments
207:

Line 231: fnd_file.put_line(FND_FILE.OUTPUT,rpad(l_query_re.national_identifier,20)||' '||rpad(l_query_re.employee_number,20)||' '||

227: IF l_aei_information_category IS NULL THEN
228:
229: IF l_query_re.national_identifier IS NOT NULL
230: AND UPPER(SUBSTR(l_query_re.national_identifier,1,2)) <> 'TN' THEN
231: fnd_file.put_line(FND_FILE.OUTPUT,rpad(l_query_re.national_identifier,20)||' '||rpad(l_query_re.employee_number,20)||' '||
232: rpad(l_query_re.assignment_number,20)||' '||rpad(lpad(l_spn,2,'0'),20));
233: ELSE
234: l_spn := NULL;
235: IF l_query_re.national_identifier IS NULL THEN

Line 266: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20));

262: END IF; -- end of l_aei_information_category
263: END LOOP;
264:
265: -- writing warning heading in to the out put file
266: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20));
267: fnd_file.put_line(FND_FILE.OUTPUT,'Warnings: SPN is not set for the following employees');
268: fnd_file.put_line(FND_FILE.OUTPUT,rpad('---------',20));
269:
270: FOR i in 1 .. l_tp_ni_increment-1 LOOP

Line 267: fnd_file.put_line(FND_FILE.OUTPUT,'Warnings: SPN is not set for the following employees');

263: END LOOP;
264:
265: -- writing warning heading in to the out put file
266: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20));
267: fnd_file.put_line(FND_FILE.OUTPUT,'Warnings: SPN is not set for the following employees');
268: fnd_file.put_line(FND_FILE.OUTPUT,rpad('---------',20));
269:
270: FOR i in 1 .. l_tp_ni_increment-1 LOOP
271: fnd_file.put_line(FND_FILE.OUTPUT,rpad(l_ni_number(i),20)||' '||rpad(l_person_number(i),20)||' '||

Line 268: fnd_file.put_line(FND_FILE.OUTPUT,rpad('---------',20));

264:
265: -- writing warning heading in to the out put file
266: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20));
267: fnd_file.put_line(FND_FILE.OUTPUT,'Warnings: SPN is not set for the following employees');
268: fnd_file.put_line(FND_FILE.OUTPUT,rpad('---------',20));
269:
270: FOR i in 1 .. l_tp_ni_increment-1 LOOP
271: fnd_file.put_line(FND_FILE.OUTPUT,rpad(l_ni_number(i),20)||' '||rpad(l_person_number(i),20)||' '||
272: rpad(l_assignment_number(i),20)||' '||rpad(lpad(l_spn_number(i),2,'0'),20));

Line 271: fnd_file.put_line(FND_FILE.OUTPUT,rpad(l_ni_number(i),20)||' '||rpad(l_person_number(i),20)||' '||

267: fnd_file.put_line(FND_FILE.OUTPUT,'Warnings: SPN is not set for the following employees');
268: fnd_file.put_line(FND_FILE.OUTPUT,rpad('---------',20));
269:
270: FOR i in 1 .. l_tp_ni_increment-1 LOOP
271: fnd_file.put_line(FND_FILE.OUTPUT,rpad(l_ni_number(i),20)||' '||rpad(l_person_number(i),20)||' '||
272: rpad(l_assignment_number(i),20)||' '||rpad(lpad(l_spn_number(i),2,'0'),20));
273: END LOOP;
274: END IF;
275: END IF; -- end for checking whether start date is greater than end date

Line 276: fnd_file.put_line(fnd_file.log,'Leaving ' || g_package_name || l_procedure_name);

272: rpad(l_assignment_number(i),20)||' '||rpad(lpad(l_spn_number(i),2,'0'),20));
273: END LOOP;
274: END IF;
275: END IF; -- end for checking whether start date is greater than end date
276: fnd_file.put_line(fnd_file.log,'Leaving ' || g_package_name || l_procedure_name);
277:
278: EXCEPTION
279: WHEN others
280: THEN

Line 281: fnd_file.put_line(fnd_file.log,g_package_name || l_procedure_name);

277:
278: EXCEPTION
279: WHEN others
280: THEN
281: fnd_file.put_line(fnd_file.log,g_package_name || l_procedure_name);
282: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
283:
284: RAISE;
285: END derive_svpn;

Line 282: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

278: EXCEPTION
279: WHEN others
280: THEN
281: fnd_file.put_line(fnd_file.log,g_package_name || l_procedure_name);
282: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
283:
284: RAISE;
285: END derive_svpn;
286: