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

Line 199: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);

195: lv_debug_enabled := TRUE;
196: end if;
197:
198: If lv_debug_enabled then
199: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
200: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
201: fnd_file.put_line(fnd_file.log,'In P_START_PERIOD :'|| P_START_PERIOD);
202: fnd_file.put_line(fnd_file.log,'In P_END_PERIOD :'|| P_END_PERIOD);
203: End if;

Line 200: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);

196: end if;
197:
198: If lv_debug_enabled then
199: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
200: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
201: fnd_file.put_line(fnd_file.log,'In P_START_PERIOD :'|| P_START_PERIOD);
202: fnd_file.put_line(fnd_file.log,'In P_END_PERIOD :'|| P_END_PERIOD);
203: End if;
204:

Line 201: fnd_file.put_line(fnd_file.log,'In P_START_PERIOD :'|| P_START_PERIOD);

197:
198: If lv_debug_enabled then
199: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
200: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
201: fnd_file.put_line(fnd_file.log,'In P_START_PERIOD :'|| P_START_PERIOD);
202: fnd_file.put_line(fnd_file.log,'In P_END_PERIOD :'|| P_END_PERIOD);
203: End if;
204:
205: l_stmt_num :=0;

Line 202: fnd_file.put_line(fnd_file.log,'In P_END_PERIOD :'|| P_END_PERIOD);

198: If lv_debug_enabled then
199: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
200: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
201: fnd_file.put_line(fnd_file.log,'In P_START_PERIOD :'|| P_START_PERIOD);
202: fnd_file.put_line(fnd_file.log,'In P_END_PERIOD :'|| P_END_PERIOD);
203: End if;
204:
205: l_stmt_num :=0;
206: l_stmt_num :=5;

Line 250: fnd_file.put_line(fnd_file.log,'Before Trans_pay_patch_status ');

246:
247: /* Call Trans_pay_patch_status to Transfer rows from GL_PERIOD_STATUS to PAY_PATCH_STATUS */
248:
249: If lv_debug_enabled then
250: fnd_file.put_line(fnd_file.log,'Before Trans_pay_patch_status ');
251: End if;
252:
253: Trans_pay_patch_status (
254: P_LEDGER_ID => P_LEDGER_ID,

Line 259: fnd_file.put_line(fnd_file.log,'After Trans_pay_patch_status ');

255: P_START_PERIOD => P_START_PERIOD,
256: P_END_PERIOD => P_END_PERIOD);
257:
258: If lv_debug_enabled then
259: fnd_file.put_line(fnd_file.log,'After Trans_pay_patch_status ');
260: End if;
261:
262: lv_Num_Workers := X_Num_Workers;
263: /* Get the Pay Action Parameter Value of THREADS */

Line 266: fnd_file.put_line(fnd_file.log,'Before pay_core_utils.get_action_parameter ');

262: lv_Num_Workers := X_Num_Workers;
263: /* Get the Pay Action Parameter Value of THREADS */
264:
265: If lv_debug_enabled then
266: fnd_file.put_line(fnd_file.log,'Before pay_core_utils.get_action_parameter ');
267: End if;
268:
269: pay_core_utils.get_action_parameter('THREADS',lv_Num_Workers,lv_param_found);
270:

Line 276: fnd_file.put_line(fnd_file.log,'No of Workers :'||to_char(lv_Num_Workers));

272: lv_Num_Workers := x_Num_Workers;
273: end if;
274:
275: If lv_debug_enabled then
276: fnd_file.put_line(fnd_file.log,'No of Workers :'||to_char(lv_Num_Workers));
277: End if;
278:
279: If lv_debug_enabled then
280: fnd_file.put_line(fnd_file.log,'After pay_core_utils.get_action_parameter ');

Line 280: fnd_file.put_line(fnd_file.log,'After pay_core_utils.get_action_parameter ');

276: fnd_file.put_line(fnd_file.log,'No of Workers :'||to_char(lv_Num_Workers));
277: End if;
278:
279: If lv_debug_enabled then
280: fnd_file.put_line(fnd_file.log,'After pay_core_utils.get_action_parameter ');
281: End if;
282:
283: begin
284:

Line 286: fnd_file.put_line(fnd_file.log,'Before AD_CONC_UTILS_PKG.submit_subrequests ');

282:
283: begin
284:
285: If lv_debug_enabled then
286: fnd_file.put_line(fnd_file.log,'Before AD_CONC_UTILS_PKG.submit_subrequests ');
287: End if;
288:
289: AD_CONC_UTILS_PKG.submit_subrequests(
290: X_errbuf=>X_errbuf,

Line 305: fnd_file.put_line(FND_FILE.LOG,'Error '||sqlcode ||' '||sqlerrm);

301: X_Argument9 => null,
302: X_Argument10 => null);
303:
304: exception when others then
305: fnd_file.put_line(FND_FILE.LOG,'Error '||sqlcode ||' '||sqlerrm);
306:
307: end;
308:
309: If lv_debug_enabled then

Line 310: fnd_file.put_line(fnd_file.log,'After AD_CONC_UTILS_PKG.submit_subrequests ');

306:
307: end;
308:
309: If lv_debug_enabled then
310: fnd_file.put_line(fnd_file.log,'After AD_CONC_UTILS_PKG.submit_subrequests ');
311: End if;
312: exception
313: when no_data_found then
314: fnd_file.put_line(FND_FILE.LOG, 'No Payroll Sub Ledger data needs to be upgraded.');

Line 314: fnd_file.put_line(FND_FILE.LOG, 'No Payroll Sub Ledger data needs to be upgraded.');

310: fnd_file.put_line(fnd_file.log,'After AD_CONC_UTILS_PKG.submit_subrequests ');
311: End if;
312: exception
313: when no_data_found then
314: fnd_file.put_line(FND_FILE.LOG, 'No Payroll Sub Ledger data needs to be upgraded.');
315:
316: end;
317: end if;
318: else

Line 334: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

330:
331: end loop;
332:
333: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
334: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
335: fnd_file.put_line(FND_FILE.LOG,'-------------------Upgrade of Historical Payroll data to Subledger Accounting---------');
336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');
338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);

Line 335: fnd_file.put_line(FND_FILE.LOG,'-------------------Upgrade of Historical Payroll data to Subledger Accounting---------');

331: end loop;
332:
333: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
334: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
335: fnd_file.put_line(FND_FILE.LOG,'-------------------Upgrade of Historical Payroll data to Subledger Accounting---------');
336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');
338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);
339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);

Line 336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

332:
333: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
334: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
335: fnd_file.put_line(FND_FILE.LOG,'-------------------Upgrade of Historical Payroll data to Subledger Accounting---------');
336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');
338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);
339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);
340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);

Line 337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');

333: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
334: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
335: fnd_file.put_line(FND_FILE.LOG,'-------------------Upgrade of Historical Payroll data to Subledger Accounting---------');
336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');
338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);
339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);
340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);
341:

Line 338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);

334: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
335: fnd_file.put_line(FND_FILE.LOG,'-------------------Upgrade of Historical Payroll data to Subledger Accounting---------');
336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');
338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);
339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);
340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);
341:
342: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

Line 339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);

335: fnd_file.put_line(FND_FILE.LOG,'-------------------Upgrade of Historical Payroll data to Subledger Accounting---------');
336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');
338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);
339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);
340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);
341:
342: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
343: fnd_file.put_line(FND_FILE.LOG,' No Period Name Status Message ');

Line 340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);

336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');
338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);
339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);
340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);
341:
342: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
343: fnd_file.put_line(FND_FILE.LOG,' No Period Name Status Message ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

Line 342: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

338: fnd_file.put_line(FND_FILE.LOG,'Ledger Id : '||p_ledger_id);
339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);
340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);
341:
342: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
343: fnd_file.put_line(FND_FILE.LOG,' No Period Name Status Message ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
345:
346:

Line 343: fnd_file.put_line(FND_FILE.LOG,' No Period Name Status Message ');

339: fnd_file.put_line(FND_FILE.LOG,'Start Period : '||p_start_period);
340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);
341:
342: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
343: fnd_file.put_line(FND_FILE.LOG,' No Period Name Status Message ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
345:
346:
347: For b in csr_pay_patch_status(fnd_global.conc_request_id)

Line 344: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

340: fnd_file.put_line(FND_FILE.LOG,'End Period : '||p_end_period);
341:
342: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
343: fnd_file.put_line(FND_FILE.LOG,' No Period Name Status Message ');
344: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
345:
346:
347: For b in csr_pay_patch_status(fnd_global.conc_request_id)
348: loop

Line 349: fnd_file.put_line(FND_FILE.LOG,' '||substr(rpad(to_char(b.nu),3,' '),1,4)||' '||b.period_name||' '||b.status||' '||b.Description);

345:
346:
347: For b in csr_pay_patch_status(fnd_global.conc_request_id)
348: loop
349: fnd_file.put_line(FND_FILE.LOG,' '||substr(rpad(to_char(b.nu),3,' '),1,4)||' '||b.period_name||' '||b.status||' '||b.Description);
350: lv_no_periods := FALSE;
351: end loop;
352:
353: If lv_no_periods then

Line 354: fnd_file.put_line(FND_FILE.LOG,' There are no Closed/Permanently Closed Periods between this Start Date and End Date');

350: lv_no_periods := FALSE;
351: end loop;
352:
353: If lv_no_periods then
354: fnd_file.put_line(FND_FILE.LOG,' There are no Closed/Permanently Closed Periods between this Start Date and End Date');
355: end if;
356:
357: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
358: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

Line 357: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

353: If lv_no_periods then
354: fnd_file.put_line(FND_FILE.LOG,' There are no Closed/Permanently Closed Periods between this Start Date and End Date');
355: end if;
356:
357: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
358: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
359: end if;
360: end if;
361:

Line 358: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');

354: fnd_file.put_line(FND_FILE.LOG,' There are no Closed/Permanently Closed Periods between this Start Date and End Date');
355: end if;
356:
357: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
358: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
359: end if;
360: end if;
361:
362: If lv_debug_enabled then

Line 363: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);

359: end if;
360: end if;
361:
362: If lv_debug_enabled then
363: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);
364: End if;
365:
366: EXCEPTION
367: WHEN submit_conc_failed THEN

Line 441: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);

437: lv_debug_enabled := TRUE;
438: end if;
439:
440: If lv_debug_enabled then
441: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
442: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID(X_Argument4) :'|| X_Argument4);
443: End if;
444: --
445: BEGIN

Line 442: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID(X_Argument4) :'|| X_Argument4);

438: end if;
439:
440: If lv_debug_enabled then
441: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
442: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID(X_Argument4) :'|| X_Argument4);
443: End if;
444: --
445: BEGIN
446: l_stmt_num :=10;

Line 477: fnd_file.put_line(fnd_file.log,'Before calling Update_Payroll_Subledger');

473: while (l_any_rows_to_process = TRUE)
474: loop
475: l_stmt_num :=30;
476: If lv_debug_enabled then
477: fnd_file.put_line(fnd_file.log,'Before calling Update_Payroll_Subledger');
478: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);
479: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);
480: End if;
481:

Line 478: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);

474: loop
475: l_stmt_num :=30;
476: If lv_debug_enabled then
477: fnd_file.put_line(fnd_file.log,'Before calling Update_Payroll_Subledger');
478: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);
479: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);
480: End if;
481:
482: PAY_SLA_UPDATE_PKG.Update_Payroll_Subledger(

Line 479: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);

475: l_stmt_num :=30;
476: If lv_debug_enabled then
477: fnd_file.put_line(fnd_file.log,'Before calling Update_Payroll_Subledger');
478: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);
479: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);
480: End if;
481:
482: PAY_SLA_UPDATE_PKG.Update_Payroll_Subledger(
483: X_errbuf=>X_errbuf,

Line 492: fnd_file.put_line(fnd_file.log,'After calling Update_Payroll_Subledger');

488: P_MGR_REQ_ID=>X_Argument7,
489: P_DEBUG_FLAG=>X_Argument8);
490:
491: If lv_debug_enabled then
492: fnd_file.put_line(fnd_file.log,'After calling Update_Payroll_Subledger');
493: End if;
494:
495: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
496: raise update_subledger_exception;

Line 529: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);

525: raise;
526: END;
527:
528: If lv_debug_enabled then
529: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);
530: End if;
531:
532: EXCEPTION
533: WHEN update_subledger_exception THEN

Line 692: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);

688: lv_debug_enabled := TRUE;
689: end if;
690:
691: If lv_debug_enabled then
692: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
693: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
694: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
695: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
696: fnd_file.put_line(fnd_file.log,'In P_MGR_REQ_ID :'|| to_char(p_mgr_req_id));

Line 693: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);

689: end if;
690:
691: If lv_debug_enabled then
692: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
693: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
694: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
695: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
696: fnd_file.put_line(fnd_file.log,'In P_MGR_REQ_ID :'|| to_char(p_mgr_req_id));
697: End if;

Line 694: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));

690:
691: If lv_debug_enabled then
692: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
693: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
694: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
695: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
696: fnd_file.put_line(fnd_file.log,'In P_MGR_REQ_ID :'|| to_char(p_mgr_req_id));
697: End if;
698:

Line 695: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));

691: If lv_debug_enabled then
692: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
693: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
694: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
695: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
696: fnd_file.put_line(fnd_file.log,'In P_MGR_REQ_ID :'|| to_char(p_mgr_req_id));
697: End if;
698:
699: l_upg_batch_id := to_number(p_mgr_req_id);

Line 696: fnd_file.put_line(fnd_file.log,'In P_MGR_REQ_ID :'|| to_char(p_mgr_req_id));

692: fnd_file.put_line(fnd_file.log,'Enter :'||l_module);
693: fnd_file.put_line(fnd_file.log,'In P_LEDGER_ID :'|| P_LEDGER_ID);
694: fnd_file.put_line(fnd_file.log,'In X_START_ID :'|| to_char(X_start_id));
695: fnd_file.put_line(fnd_file.log,'In X_END_ID :'|| to_char(X_end_id));
696: fnd_file.put_line(fnd_file.log,'In P_MGR_REQ_ID :'|| to_char(p_mgr_req_id));
697: End if;
698:
699: l_upg_batch_id := to_number(p_mgr_req_id);
700:

Line 709: fnd_file.put_line(fnd_file.log,'Before upgrading ledger_id :'|| j.ledger_id);

705: For j in csr_get_periods(X_start_id ,X_end_id,gv_process_name,to_char(p_mgr_req_id))
706: Loop
707:
708: If lv_debug_enabled then
709: fnd_file.put_line(fnd_file.log,'Before upgrading ledger_id :'|| j.ledger_id);
710: fnd_file.put_line(fnd_file.log,'Before upgrading period_name :'|| j.period_name);
711: fnd_file.put_line(fnd_file.log,'Before upgrading gv_process_name :'|| gv_process_name);
712: End if;
713:

Line 710: fnd_file.put_line(fnd_file.log,'Before upgrading period_name :'|| j.period_name);

706: Loop
707:
708: If lv_debug_enabled then
709: fnd_file.put_line(fnd_file.log,'Before upgrading ledger_id :'|| j.ledger_id);
710: fnd_file.put_line(fnd_file.log,'Before upgrading period_name :'|| j.period_name);
711: fnd_file.put_line(fnd_file.log,'Before upgrading gv_process_name :'|| gv_process_name);
712: End if;
713:
714: Begin

Line 711: fnd_file.put_line(fnd_file.log,'Before upgrading gv_process_name :'|| gv_process_name);

707:
708: If lv_debug_enabled then
709: fnd_file.put_line(fnd_file.log,'Before upgrading ledger_id :'|| j.ledger_id);
710: fnd_file.put_line(fnd_file.log,'Before upgrading period_name :'|| j.period_name);
711: fnd_file.put_line(fnd_file.log,'Before upgrading gv_process_name :'|| gv_process_name);
712: End if;
713:
714: Begin
715:

Line 717: fnd_file.put_line(fnd_file.log,'Before updating GL Tables ');

713:
714: Begin
715:
716: If lv_debug_enabled then
717: fnd_file.put_line(fnd_file.log,'Before updating GL Tables ');
718: End if;
719:
720: For l in csr_get_headers(j.ledger_id,j.period_name,lv_application_name)
721: Loop

Line 745: fnd_file.put_line(fnd_file.log,'After updating GL Tables ');

741:
742: End loop;
743:
744: If lv_debug_enabled then
745: fnd_file.put_line(fnd_file.log,'After updating GL Tables ');
746: End if;
747:
748: If lv_debug_enabled then
749: fnd_file.put_line(fnd_file.log,'Before Inserting into XLA Tables ');

Line 749: fnd_file.put_line(fnd_file.log,'Before Inserting into XLA Tables ');

745: fnd_file.put_line(fnd_file.log,'After updating GL Tables ');
746: End if;
747:
748: If lv_debug_enabled then
749: fnd_file.put_line(fnd_file.log,'Before Inserting into XLA Tables ');
750: End if;
751:
752: INSERT ALL
753: WHEN (rank_id=1) then

Line 1115: fnd_file.put_line(fnd_file.log,'After Inserting into XLA Tables ');

1111: AND gjh.je_source=lv_application_name) A;
1112:
1113:
1114: If lv_debug_enabled then
1115: fnd_file.put_line(fnd_file.log,'After Inserting into XLA Tables ');
1116: End if;
1117:
1118: update pay_patch_status
1119: set status='U',

Line 1129: fnd_file.put_line(fnd_file.log,'Period '||j.period_name||' Successfully upgraded ');

1125:
1126: commit;
1127:
1128: If lv_debug_enabled then
1129: fnd_file.put_line(fnd_file.log,'Period '||j.period_name||' Successfully upgraded ');
1130: End if;
1131:
1132:
1133: Exception when others then

Line 1146: fnd_file.put_line(FND_FILE.LOG,'Error Update_Payroll_Subledger '||j.period_name||' '||lv_Error_msg);

1142: and phase =gv_process_name||P_MGR_REQ_ID
1143: and patch_number=j.ledger_id
1144: and patch_name =j.period_name;
1145:
1146: fnd_file.put_line(FND_FILE.LOG,'Error Update_Payroll_Subledger '||j.period_name||' '||lv_Error_msg);
1147:
1148: End;
1149:
1150: If lv_debug_enabled then

Line 1151: fnd_file.put_line(fnd_file.log,'After upgrading ledger_id :'|| j.ledger_id);

1147:
1148: End;
1149:
1150: If lv_debug_enabled then
1151: fnd_file.put_line(fnd_file.log,'After upgrading ledger_id :'|| j.ledger_id);
1152: fnd_file.put_line(fnd_file.log,'After upgrading period_name :'|| j.period_name);
1153: End if;
1154:
1155: End Loop;

Line 1152: fnd_file.put_line(fnd_file.log,'After upgrading period_name :'|| j.period_name);

1148: End;
1149:
1150: If lv_debug_enabled then
1151: fnd_file.put_line(fnd_file.log,'After upgrading ledger_id :'|| j.ledger_id);
1152: fnd_file.put_line(fnd_file.log,'After upgrading period_name :'|| j.period_name);
1153: End if;
1154:
1155: End Loop;
1156:

Line 1158: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);

1154:
1155: End Loop;
1156:
1157: If lv_debug_enabled then
1158: fnd_file.put_line(fnd_file.log,'Leaving :'||l_module);
1159: End if;
1160:
1161: EXCEPTION when others then
1162: Rollback;

Line 1164: fnd_file.put_line(FND_FILE.LOG,'Error Update_Payroll_Subledger '||SQLCODE||' '||SQLERRM);

1160:
1161: EXCEPTION when others then
1162: Rollback;
1163: X_errbuf:=l_module||': '|| SQLERRM;
1164: fnd_file.put_line(FND_FILE.LOG,'Error Update_Payroll_Subledger '||SQLCODE||' '||SQLERRM);
1165: end Update_Payroll_Subledger;
1166:
1167: END PAY_SLA_UPDATE_PKG;