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 480: fnd_file.put_line(fnd_file.log,'Before calling Update_Payroll_Subledger');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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