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 OKL_ACCOUNTING_UTIL

Line 200: okl_Accounting_util.get_concat_segments(ael.code_combination_id) account,

196: aeh.accounting_date,
197: aeh.ae_category,
198: ael.accounted_dr,
199: ael.accounted_cr,
200: okl_Accounting_util.get_concat_segments(ael.code_combination_id) account,
201: ael.currency_code
202: FROM okl_ae_headers aeh,
203: okl_ae_lines ael,
204: okl_txl_cntrct_lns tcl,

Line 224: okl_Accounting_util.get_concat_segments(ael.code_combination_id) account,

220: aeh.accounting_date,
221: aeh.ae_category,
222: ael.accounted_dr,
223: ael.accounted_cr,
224: okl_Accounting_util.get_concat_segments(ael.code_combination_id) account,
225: ael.currency_code
226: FROM okl_ae_headers aeh,
227: okl_ae_lines ael
228: WHERE ael.ae_header_id = aeh.ae_header_id

Line 254: header_report1_rec.transaction_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

250: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
251:
252: --to print the header in 2 lines
253:
254: header_report1_rec.transaction_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
255: ('OKL_LP_GL_TRANSFER','OKL_TRANSACTION'),l_transaction_date_len,'TITLE');
256:
257: header_report1_rec.contract_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
258: ('OKL_LP_GL_TRANSFER','OKL_CONTRACT'),l_contract_num_len,'TITLE');

Line 257: header_report1_rec.contract_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

253:
254: header_report1_rec.transaction_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
255: ('OKL_LP_GL_TRANSFER','OKL_TRANSACTION'),l_transaction_date_len,'TITLE');
256:
257: header_report1_rec.contract_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
258: ('OKL_LP_GL_TRANSFER','OKL_CONTRACT'),l_contract_num_len,'TITLE');
259:
260: header_report1_rec.transaction_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
261: ('OKL_LP_GL_TRANSFER','OKL_TRANSACTION'),l_transaction_num_len,'TITLE');

Line 260: header_report1_rec.transaction_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

256:
257: header_report1_rec.contract_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
258: ('OKL_LP_GL_TRANSFER','OKL_CONTRACT'),l_contract_num_len,'TITLE');
259:
260: header_report1_rec.transaction_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
261: ('OKL_LP_GL_TRANSFER','OKL_TRANSACTION'),l_transaction_num_len,'TITLE');
262:
263: header_report1_rec.transaction_line_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
264: ('OKL_LP_GL_TRANSFER','OKL_ACC_LINE'),l_transaction_line_num_len,'TITLE');

Line 263: header_report1_rec.transaction_line_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

259:
260: header_report1_rec.transaction_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
261: ('OKL_LP_GL_TRANSFER','OKL_TRANSACTION'),l_transaction_num_len,'TITLE');
262:
263: header_report1_rec.transaction_line_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
264: ('OKL_LP_GL_TRANSFER','OKL_ACC_LINE'),l_transaction_line_num_len,'TITLE');
265:
266: header_report1_rec.accounting_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
267: ('OKL_LP_GL_TRANSFER','OKL_ACCOUNT_ING'),l_accounting_date_len,'TITLE');

Line 266: header_report1_rec.accounting_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

262:
263: header_report1_rec.transaction_line_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
264: ('OKL_LP_GL_TRANSFER','OKL_ACC_LINE'),l_transaction_line_num_len,'TITLE');
265:
266: header_report1_rec.accounting_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
267: ('OKL_LP_GL_TRANSFER','OKL_ACCOUNT_ING'),l_accounting_date_len,'TITLE');
268:
269: header_report1_rec.dr_cr_flag :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
270: ('OKL_LP_GL_TRANSFER','OKL_DR_CR_FLAG'),l_dr_cr_flag_len,'TITLE');

Line 269: header_report1_rec.dr_cr_flag :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

265:
266: header_report1_rec.accounting_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
267: ('OKL_LP_GL_TRANSFER','OKL_ACCOUNT_ING'),l_accounting_date_len,'TITLE');
268:
269: header_report1_rec.dr_cr_flag :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
270: ('OKL_LP_GL_TRANSFER','OKL_DR_CR_FLAG'),l_dr_cr_flag_len,'TITLE');
271:
272: header_report1_rec.accounted_amount :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
273: ('OKL_LP_GL_TRANSFER','OKL_ACCOUNTED'),l_accounted_amount_len,'TITLE');

Line 272: header_report1_rec.accounted_amount :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

268:
269: header_report1_rec.dr_cr_flag :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
270: ('OKL_LP_GL_TRANSFER','OKL_DR_CR_FLAG'),l_dr_cr_flag_len,'TITLE');
271:
272: header_report1_rec.accounted_amount :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
273: ('OKL_LP_GL_TRANSFER','OKL_ACCOUNTED'),l_accounted_amount_len,'TITLE');
274:
275: --PAGARG Bug 4198290 As Account is moved to next line, no need to trim it.
276: --Can accomodate the complete title

Line 277: header_report1_rec.account := okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_ACCOUNT');

273: ('OKL_LP_GL_TRANSFER','OKL_ACCOUNTED'),l_accounted_amount_len,'TITLE');
274:
275: --PAGARG Bug 4198290 As Account is moved to next line, no need to trim it.
276: --Can accomodate the complete title
277: header_report1_rec.account := okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_ACCOUNT');
278:
279: header_report1_rec.currency :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
280: ('OKL_LP_GL_TRANSFER','OKL_CURRENCY'),l_currency_len,'TITLE');
281:

Line 279: header_report1_rec.currency :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

275: --PAGARG Bug 4198290 As Account is moved to next line, no need to trim it.
276: --Can accomodate the complete title
277: header_report1_rec.account := okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_ACCOUNT');
278:
279: header_report1_rec.currency :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
280: ('OKL_LP_GL_TRANSFER','OKL_CURRENCY'),l_currency_len,'TITLE');
281:
282: header_report2_rec.transaction_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
283: ('OKL_LP_GL_TRANSFER','OKL_DATE'),l_transaction_date_len,'TITLE');

Line 282: header_report2_rec.transaction_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

278:
279: header_report1_rec.currency :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
280: ('OKL_LP_GL_TRANSFER','OKL_CURRENCY'),l_currency_len,'TITLE');
281:
282: header_report2_rec.transaction_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
283: ('OKL_LP_GL_TRANSFER','OKL_DATE'),l_transaction_date_len,'TITLE');
284:
285: header_report2_rec.contract_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
286: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_contract_num_len,'TITLE');

Line 285: header_report2_rec.contract_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

281:
282: header_report2_rec.transaction_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
283: ('OKL_LP_GL_TRANSFER','OKL_DATE'),l_transaction_date_len,'TITLE');
284:
285: header_report2_rec.contract_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
286: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_contract_num_len,'TITLE');
287:
288: header_report2_rec.transaction_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
289: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_transaction_num_len,'TITLE');

Line 288: header_report2_rec.transaction_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

284:
285: header_report2_rec.contract_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
286: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_contract_num_len,'TITLE');
287:
288: header_report2_rec.transaction_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
289: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_transaction_num_len,'TITLE');
290:
291: header_report2_rec.transaction_line_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
292: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_transaction_line_num_len,'TITLE');

Line 291: header_report2_rec.transaction_line_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

287:
288: header_report2_rec.transaction_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
289: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_transaction_num_len,'TITLE');
290:
291: header_report2_rec.transaction_line_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
292: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_transaction_line_num_len,'TITLE');
293:
294: header_report2_rec.accounting_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
295: ('OKL_LP_GL_TRANSFER','OKL_DATE'),l_accounting_date_len,'TITLE');

Line 294: header_report2_rec.accounting_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

290:
291: header_report2_rec.transaction_line_number :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
292: ('OKL_LP_GL_TRANSFER','OKL_NUMBER'),l_transaction_line_num_len,'TITLE');
293:
294: header_report2_rec.accounting_date :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token
295: ('OKL_LP_GL_TRANSFER','OKL_DATE'),l_accounting_date_len,'TITLE');
296:
297: header_report2_rec.dr_cr_flag :=LPAD(' ',l_dr_cr_flag_len,' ');
298:

Line 299: header_report2_rec.accounted_amount :=GET_PROPER_LENGTH(okl_accounting_util.get_message_token

295: ('OKL_LP_GL_TRANSFER','OKL_DATE'),l_accounting_date_len,'TITLE');
296:
297: header_report2_rec.dr_cr_flag :=LPAD(' ',l_dr_cr_flag_len,' ');
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'));

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 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 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 314: l_set_of_books_name := okl_accounting_util.get_set_of_books_name (okl_accounting_util.get_set_of_books_id);

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:
316: FOR org_rec IN org_csr (l_org_id)
317: LOOP
318: l_org_name := org_rec.name;

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 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 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 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 372: okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_TRANSACTION_TYPE')||

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,' '));
375:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,header_report1_rec.transaction_date||

Line 444: proc_report_rec.accounted_amount := GET_PROPER_LENGTH(okl_Accounting_util.format_amount(l_accounted_amount,gl_proc_dst_rec.currency_code),

440: proc_report_rec.accounting_date := GET_PROPER_LENGTH(gl_proc_dst_rec.accounting_date,
441: l_accounting_date_len,'DATA');
442: proc_report_rec.dr_cr_flag := GET_PROPER_LENGTH(l_dr_cr_flag,
443: l_dr_cr_flag_len,'DATA');
444: proc_report_rec.accounted_amount := GET_PROPER_LENGTH(okl_Accounting_util.format_amount(l_accounted_amount,gl_proc_dst_rec.currency_code),
445: l_accounted_amount_len,'DATA');
446: --PAGARG Bug 4198290 As Account is moved to next line, no need to
447: --check length, display complete data
448: proc_report_rec.account := gl_proc_dst_rec.account;

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 470: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_DEBIT'),l_accounted_amount_len,' ') ||':'||

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') ||
474: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_CREDIT_AMT'),l_accounted_amount_len,' ') ||':'||

Line 471: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_dr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA') );

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') ||
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'));

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 474: RPAD(okl_accounting_util.get_message_token('OKL_LP_GL_TRANSFER','OKL_CREDIT_AMT'),l_accounted_amount_len,' ') ||':'||

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 , '-' ));
478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

Line 475: GET_PROPER_LENGTH(okl_Accounting_util.format_amount(ae_category_rec.total_cr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA'));

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 , '-' ));
478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));
479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',l_line_length,' '));

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 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 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 562: non_proc_report_rec.accounted_amount := GET_PROPER_LENGTH(okl_Accounting_util.format_amount(l_accounted_amount,gl_error_dst_rec.currency_code),

558: non_proc_report_rec.transaction_line_number := GET_PROPER_LENGTH(l_temp_line_number,l_transaction_line_num_len,'DATA');
559: non_proc_report_rec.accounting_date := GET_PROPER_LENGTH(gl_error_dst_rec.accounting_date,l_accounting_date_len,'DATA');
560: non_proc_report_rec.dr_cr_flag := GET_PROPER_LENGTH(l_dr_cr_flag,
561: l_dr_cr_flag_len,'DATA');
562: non_proc_report_rec.accounted_amount := GET_PROPER_LENGTH(okl_Accounting_util.format_amount(l_accounted_amount,gl_error_dst_rec.currency_code),
563: l_accounted_amount_len,'DATA');
564: --PAGARG Bug 4198290 As Account is moved to next line, no need to
565: --check length, display complete data
566: non_proc_report_rec.account := gl_error_dst_rec.account;