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

Line 302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || okl_accounting_util.get_message_token

298:
299: header_report2_rec.accounted_amount :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
300: ('OKL_LP_GL_TRANSFER','OKL_AMOUNT'),l_accounted_amount_len,'TITLE');
301:
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || okl_accounting_util.get_message_token
303: ('OKL_LP_GL_TRANSFER','OKL_ACCT_LEASE_MANAGEMENT'));
304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || '-----------------------');
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || okl_accounting_util.get_message_token
306: ('OKL_LP_GL_TRANSFER','OKL_GL_TRANSFER_REPORT'));

Line 304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || '-----------------------');

300: ('OKL_LP_GL_TRANSFER','OKL_AMOUNT'),l_accounted_amount_len,'TITLE');
301:
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || okl_accounting_util.get_message_token
303: ('OKL_LP_GL_TRANSFER','OKL_ACCT_LEASE_MANAGEMENT'));
304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || '-----------------------');
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || okl_accounting_util.get_message_token
306: ('OKL_LP_GL_TRANSFER','OKL_GL_TRANSFER_REPORT'));
307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || '------------------------------');
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || okl_accounting_util.get_message_token

301:
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || okl_accounting_util.get_message_token
303: ('OKL_LP_GL_TRANSFER','OKL_ACCT_LEASE_MANAGEMENT'));
304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || '-----------------------');
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || okl_accounting_util.get_message_token
306: ('OKL_LP_GL_TRANSFER','OKL_GL_TRANSFER_REPORT'));
307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || '------------------------------');
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || '------------------------------');

303: ('OKL_LP_GL_TRANSFER','OKL_ACCT_LEASE_MANAGEMENT'));
304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || '-----------------------');
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || okl_accounting_util.get_message_token
306: ('OKL_LP_GL_TRANSFER','OKL_GL_TRANSFER_REPORT'));
307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || '------------------------------');
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
310:
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',

Line 308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

304: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 54 , ' ' ) || '-----------------------');
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || okl_accounting_util.get_message_token
306: ('OKL_LP_GL_TRANSFER','OKL_GL_TRANSFER_REPORT'));
307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || '------------------------------');
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
310:
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
312: 'OKL_RUN_DATE'),30,' ')||':'|| SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'),1,30));

Line 309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || okl_accounting_util.get_message_token
306: ('OKL_LP_GL_TRANSFER','OKL_GL_TRANSFER_REPORT'));
307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || '------------------------------');
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
310:
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
312: 'OKL_RUN_DATE'),30,' ')||':'|| SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'),1,30));
313:

Line 311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',

307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 51 , ' ' ) || '------------------------------');
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
310:
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
312: 'OKL_RUN_DATE'),30,' ')||':'|| SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'),1,30));
313:
314: l_set_of_books_name := okl_accounting_util.get_set_of_books_name (okl_accounting_util.get_set_of_books_id);
315:

Line 321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',

317: LOOP
318: l_org_name := org_rec.name;
319: END LOOP;
320:
321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
322: 'OKL_SET_OF_BOOKS'),30,' ')
323: ||':'|| RPAD(SUBSTR(l_set_of_books_name, 1, 30), 30, ' ') || LPAD(' ', 45 , ' ' ) );
324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD( okl_accounting_util.get_message_token
325: ('OKL_LP_GL_TRANSFER','OKL_OPERUNIT'),30,' ')

Line 324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD( okl_accounting_util.get_message_token

320:
321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
322: 'OKL_SET_OF_BOOKS'),30,' ')
323: ||':'|| RPAD(SUBSTR(l_set_of_books_name, 1, 30), 30, ' ') || LPAD(' ', 45 , ' ' ) );
324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD( okl_accounting_util.get_message_token
325: ('OKL_LP_GL_TRANSFER','OKL_OPERUNIT'),30,' ')
326: ||':'|| SUBSTR(l_org_name, 1, 30) );
327:
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

Line 328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD( okl_accounting_util.get_message_token
325: ('OKL_LP_GL_TRANSFER','OKL_OPERUNIT'),30,' ')
326: ||':'|| SUBSTR(l_org_name, 1, 30) );
327:
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
330:
331: FOR header_details_rec IN header_details_csr(p_request_id)
332: LOOP

Line 329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

325: ('OKL_LP_GL_TRANSFER','OKL_OPERUNIT'),30,' ')
326: ||':'|| SUBSTR(l_org_name, 1, 30) );
327:
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
330:
331: FOR header_details_rec IN header_details_csr(p_request_id)
332: LOOP
333:

Line 346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',

342: END LOOP;
343:
344: l_total_process :=l_success_process + l_error_process;
345:
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
347: 'OKL_TOTAL_ACCT_LINES'),65,' ') ||':'||l_total_process);
348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
349: 'OKL_ACCT_LINES_SUCCESS'),65,' ') ||':'||l_success_process);
350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',

Line 348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',

344: l_total_process :=l_success_process + l_error_process;
345:
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
347: 'OKL_TOTAL_ACCT_LINES'),65,' ') ||':'||l_total_process);
348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
349: 'OKL_ACCT_LINES_SUCCESS'),65,' ') ||':'||l_success_process);
350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
351: 'OKL_ACCT_LINES_ERROR'),65,' ') ||':'||l_error_process);
352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

Line 350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',

346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
347: 'OKL_TOTAL_ACCT_LINES'),65,' ') ||':'||l_total_process);
348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
349: 'OKL_ACCT_LINES_SUCCESS'),65,' ') ||':'||l_success_process);
350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
351: 'OKL_ACCT_LINES_ERROR'),65,' ') ||':'||l_error_process);
352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
354:

Line 352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
349: 'OKL_ACCT_LINES_SUCCESS'),65,' ') ||':'||l_success_process);
350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
351: 'OKL_ACCT_LINES_ERROR'),65,' ') ||':'||l_error_process);
352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
354:
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_PROCESSED_ENTRIES'));
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------------');

Line 353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

349: 'OKL_ACCT_LINES_SUCCESS'),65,' ') ||':'||l_success_process);
350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
351: 'OKL_ACCT_LINES_ERROR'),65,' ') ||':'||l_error_process);
352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
354:
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_PROCESSED_ENTRIES'));
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------------');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

Line 355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_PROCESSED_ENTRIES'));

351: 'OKL_ACCT_LINES_ERROR'),65,' ') ||':'||l_error_process);
352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
354:
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_PROCESSED_ENTRIES'));
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------------');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
358:
359: OPEN ae_category_csr(p_request_id);

Line 356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------------');

352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
354:
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_PROCESSED_ENTRIES'));
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------------');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
358:
359: OPEN ae_category_csr(p_request_id);
360:

Line 357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
354:
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_PROCESSED_ENTRIES'));
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------------');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
358:
359: OPEN ae_category_csr(p_request_id);
360:
361: IF ae_category_csr%NOTFOUND THEN

Line 362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_NO_RECORDS'));

358:
359: OPEN ae_category_csr(p_request_id);
360:
361: IF ae_category_csr%NOTFOUND THEN
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_NO_RECORDS'));
363: END IF;
364:
365: CLOSE ae_category_csr;
366:

Line 370: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',

366:
367: FOR ae_category_rec IN ae_category_csr(p_request_id)
368: LOOP
369:
370: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
371: 'OKL_JOURNAL_CATEGORY')||' :'||ae_category_rec.ae_category ||' '||
372: okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TRANSACTION_TYPE')||
373: ':'||ae_category_rec.try_name , l_line_length ,' '));
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

Line 374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

370: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER',
371: 'OKL_JOURNAL_CATEGORY')||' :'||ae_category_rec.ae_category ||' '||
372: okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TRANSACTION_TYPE')||
373: ':'||ae_category_rec.try_name , l_line_length ,' '));
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
375:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||
377: header_report1_rec.contract_number||
378: header_report1_rec.transaction_number ||

Line 376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||

372: okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TRANSACTION_TYPE')||
373: ':'||ae_category_rec.try_name , l_line_length ,' '));
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
375:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||
377: header_report1_rec.contract_number||
378: header_report1_rec.transaction_number ||
379: header_report1_rec.transaction_line_number ||
380: header_report1_rec.accounting_date ||

Line 385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report2_rec.transaction_date||

381: header_report1_rec.dr_cr_flag ||
382: header_report1_rec.accounted_amount ||
383: header_report1_rec.currency);
384:
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report2_rec.transaction_date||
386: header_report2_rec.contract_number||
387: header_report2_rec.transaction_number ||
388: header_report2_rec.transaction_line_number ||
389: header_report2_rec.accounting_date||

Line 393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD('-', l_line_length , '-' ));

389: header_report2_rec.accounting_date||
390: header_report2_rec.dr_cr_flag ||
391: header_report2_rec.accounted_amount );
392:
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD('-', l_line_length , '-' ));
394:
395: FOR gl_proc_dst_rec IN gl_proc_dst_csr(p_request_id,
396: ae_category_rec.ae_category,
397: ae_category_rec.try_id,

Line 452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,proc_report_rec.transaction_date ||

448: proc_report_rec.account := gl_proc_dst_rec.account;
449: proc_report_rec.currency := GET_PROPER_LENGTH(gl_proc_dst_rec.currency_code,
450: l_currency_len,'DATA');
451:
452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,proc_report_rec.transaction_date ||
453: proc_report_rec.contract_number ||
454: proc_report_rec.transaction_number ||
455: proc_report_rec.transaction_line_number ||
456: proc_report_rec.accounting_date ||

Line 461: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, header_report1_rec.account ||' : '|| proc_report_rec.account);

457: proc_report_rec.dr_cr_flag ||
458: proc_report_rec.accounted_amount||
459: proc_report_rec.currency);
460: --PAGARG Bug 4198290 Move account data to next line
461: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, header_report1_rec.account ||' : '|| proc_report_rec.account);
462:
463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_line_length , ' ' ));
464:
465: END LOOP;

Line 463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_line_length , ' ' ));

459: proc_report_rec.currency);
460: --PAGARG Bug 4198290 Move account data to next line
461: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, header_report1_rec.account ||' : '|| proc_report_rec.account);
462:
463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_line_length , ' ' ));
464:
465: END LOOP;
466:
467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));

Line 467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));

463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_line_length , ' ' ));
464:
465: END LOOP;
466:
467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));
468:
469: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TOTAL') ||
470: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_DEBIT'),l_accounted_amount_len,' ') ||':'||
471: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_dr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA') );

Line 469: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TOTAL') ||

465: END LOOP;
466:
467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));
468:
469: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TOTAL') ||
470: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_DEBIT'),l_accounted_amount_len,' ') ||':'||
471: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_dr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA') );
472:
473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TOTAL') ||

Line 473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TOTAL') ||

469: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TOTAL') ||
470: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_DEBIT'),l_accounted_amount_len,' ') ||':'||
471: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_dr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA') );
472:
473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TOTAL') ||
474: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_CREDIT_AMT'),l_accounted_amount_len,' ') ||':'||
475: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_cr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA'));
476:
477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));

Line 477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));

473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TOTAL') ||
474: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_CREDIT_AMT'),l_accounted_amount_len,' ') ||':'||
475: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_cr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA'));
476:
477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));
478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
480:
481: END LOOP;

Line 478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

474: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_CREDIT_AMT'),l_accounted_amount_len,' ') ||':'||
475: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_cr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA'));
476:
477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));
478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
480:
481: END LOOP;
482:

Line 479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

475: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_cr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA'));
476:
477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));
478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
480:
481: END LOOP;
482:
483: --For Unprocessed entries

Line 484: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_ERROR_LOG'));

480:
481: END LOOP;
482:
483: --For Unprocessed entries
484: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_ERROR_LOG'));
485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------');
486: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
487:
488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_INVALID_ACCOUNT'));

Line 485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------');

481: END LOOP;
482:
483: --For Unprocessed entries
484: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_ERROR_LOG'));
485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------');
486: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
487:
488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_INVALID_ACCOUNT'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------------');

Line 486: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

482:
483: --For Unprocessed entries
484: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_ERROR_LOG'));
485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------');
486: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
487:
488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_INVALID_ACCOUNT'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------------');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

Line 488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_INVALID_ACCOUNT'));

484: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_ERROR_LOG'));
485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------');
486: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
487:
488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_INVALID_ACCOUNT'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------------');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
491:
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||

Line 489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------------');

485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------');
486: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
487:
488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_INVALID_ACCOUNT'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------------');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
491:
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||
493: header_report1_rec.contract_number||

Line 490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

486: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
487:
488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_INVALID_ACCOUNT'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------------');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
491:
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||
493: header_report1_rec.contract_number||
494: header_report1_rec.transaction_number ||

Line 492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||

488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_INVALID_ACCOUNT'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'---------------');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
491:
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||
493: header_report1_rec.contract_number||
494: header_report1_rec.transaction_number ||
495: header_report1_rec.transaction_line_number ||
496: header_report1_rec.accounting_date ||

Line 502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report2_rec.transaction_date||

498: header_report1_rec.accounted_amount ||
499: header_report1_rec.currency);
500:
501:
502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report2_rec.transaction_date||
503: header_report2_rec.contract_number||
504: header_report2_rec.transaction_number ||
505: header_report2_rec.transaction_line_number ||
506: header_report2_rec.accounting_date||

Line 510: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD('-', l_line_length , '-' ));

506: header_report2_rec.accounting_date||
507: header_report2_rec.dr_cr_flag ||
508: header_report2_rec.accounted_amount );
509:
510: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD('-', l_line_length , '-' ));
511:
512: OPEN gl_error_dst_csr(p_request_id);
513:
514: IF gl_error_dst_csr%NOTFOUND THEN

Line 515: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_NO_RECORDS'));

511:
512: OPEN gl_error_dst_csr(p_request_id);
513:
514: IF gl_error_dst_csr%NOTFOUND THEN
515: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_NO_RECORDS'));
516: END IF;
517:
518: CLOSE gl_error_dst_csr;
519:

Line 569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,non_proc_report_rec.transaction_date ||

565: --check length, display complete data
566: non_proc_report_rec.account := gl_error_dst_rec.account;
567: non_proc_report_rec.currency := GET_PROPER_LENGTH(gl_error_dst_rec.currency_code,l_currency_len,'DATA');
568:
569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,non_proc_report_rec.transaction_date ||
570: non_proc_report_rec.contract_number ||
571: non_proc_report_rec.transaction_number ||
572: non_proc_report_rec.transaction_line_number ||
573: non_proc_report_rec.accounting_date ||

Line 578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, header_report1_rec.account ||' : '|| non_proc_report_rec.account);

574: non_proc_report_rec.dr_cr_flag ||
575: non_proc_report_rec.accounted_amount ||
576: non_proc_report_rec.currency);
577: --PAGARG Bug 4198290 Move account data to next line
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, header_report1_rec.account ||' : '|| non_proc_report_rec.account);
579:
580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_line_length , ' ' ));
581:
582: END LOOP;

Line 580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_line_length , ' ' ));

576: non_proc_report_rec.currency);
577: --PAGARG Bug 4198290 Move account data to next line
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, header_report1_rec.account ||' : '|| non_proc_report_rec.account);
579:
580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_line_length , ' ' ));
581:
582: END LOOP;
583:
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));

Line 584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));

580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_line_length , ' ' ));
581:
582: END LOOP;
583:
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_line_length , '-' ));
585:
586: END CREATE_REPORT;
587:
588:

Line 602: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

598: BEGIN
599: --Stubbed out this procedure for SLA Uptake of periodic reversal concurrent program.
600: FND_MESSAGE.SET_NAME( application => g_app_name ,
601: name => 'OKL_OBS_GL_TRANSFER_PRG' );
602: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
603: END OKL_GL_transfer;
604:
605: PROCEDURE OKL_gl_transfer_con
606: (p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE