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

Line 127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);

123: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
124: END IF;
125:
126: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
131: fnd_file.put_line( 1, fnd_message.get);

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

124: END IF;
125:
126: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
131: fnd_file.put_line( 1, fnd_message.get);
132: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');

Line 131: fnd_file.put_line( 1, fnd_message.get);

127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
131: fnd_file.put_line( 1, fnd_message.get);
132: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
133:
134: ---------------------------------------------------------
135: -- Find who_columns values --

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

128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
131: fnd_file.put_line( 1, fnd_message.get);
132: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
133:
134: ---------------------------------------------------------
135: -- Find who_columns values --
136: ---------------------------------------------------------

Line 199: fnd_file.put_line( 1, 'Set of book id :'||to_char(x_set_of_book_id));

195: AND xs.application_id = 140;
196:
197:
198: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
199: fnd_file.put_line( 1, 'Set of book id :'||to_char(x_set_of_book_id));
200: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Set of book id :'||to_char(x_set_of_book_id));
201: fnd_file.put_line( 1, 'Depreciation Calender :'||x_deprn_calendar);
202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Depreciation Calender :'||x_deprn_calendar);
203: fnd_file.put_line( 1, 'Gl je source :'||x_gl_je_source);

Line 201: fnd_file.put_line( 1, 'Depreciation Calender :'||x_deprn_calendar);

197:
198: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
199: fnd_file.put_line( 1, 'Set of book id :'||to_char(x_set_of_book_id));
200: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Set of book id :'||to_char(x_set_of_book_id));
201: fnd_file.put_line( 1, 'Depreciation Calender :'||x_deprn_calendar);
202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Depreciation Calender :'||x_deprn_calendar);
203: fnd_file.put_line( 1, 'Gl je source :'||x_gl_je_source);
204: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Gl je source :'||x_gl_je_source);
205: fnd_file.put_line( 1, 'Distribution source book :'||x_distribution_source_book);

Line 203: fnd_file.put_line( 1, 'Gl je source :'||x_gl_je_source);

199: fnd_file.put_line( 1, 'Set of book id :'||to_char(x_set_of_book_id));
200: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Set of book id :'||to_char(x_set_of_book_id));
201: fnd_file.put_line( 1, 'Depreciation Calender :'||x_deprn_calendar);
202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Depreciation Calender :'||x_deprn_calendar);
203: fnd_file.put_line( 1, 'Gl je source :'||x_gl_je_source);
204: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Gl je source :'||x_gl_je_source);
205: fnd_file.put_line( 1, 'Distribution source book :'||x_distribution_source_book);
206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Distribution source book :'||x_distribution_source_book);
207: fnd_file.put_line( 1, 'Period counter :'||x_period_counter);

Line 205: fnd_file.put_line( 1, 'Distribution source book :'||x_distribution_source_book);

201: fnd_file.put_line( 1, 'Depreciation Calender :'||x_deprn_calendar);
202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Depreciation Calender :'||x_deprn_calendar);
203: fnd_file.put_line( 1, 'Gl je source :'||x_gl_je_source);
204: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Gl je source :'||x_gl_je_source);
205: fnd_file.put_line( 1, 'Distribution source book :'||x_distribution_source_book);
206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Distribution source book :'||x_distribution_source_book);
207: fnd_file.put_line( 1, 'Period counter :'||x_period_counter);
208: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period counter :'||x_period_counter);
209: fnd_file.put_line( 1, 'Period closed :'||x_period_closed);

Line 207: fnd_file.put_line( 1, 'Period counter :'||x_period_counter);

203: fnd_file.put_line( 1, 'Gl je source :'||x_gl_je_source);
204: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Gl je source :'||x_gl_je_source);
205: fnd_file.put_line( 1, 'Distribution source book :'||x_distribution_source_book);
206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Distribution source book :'||x_distribution_source_book);
207: fnd_file.put_line( 1, 'Period counter :'||x_period_counter);
208: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period counter :'||x_period_counter);
209: fnd_file.put_line( 1, 'Period closed :'||x_period_closed);
210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period closed :'||x_period_closed);
211: fnd_file.put_line( 1, 'User je source name :'||x_user_je_source_name );

Line 209: fnd_file.put_line( 1, 'Period closed :'||x_period_closed);

205: fnd_file.put_line( 1, 'Distribution source book :'||x_distribution_source_book);
206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Distribution source book :'||x_distribution_source_book);
207: fnd_file.put_line( 1, 'Period counter :'||x_period_counter);
208: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period counter :'||x_period_counter);
209: fnd_file.put_line( 1, 'Period closed :'||x_period_closed);
210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period closed :'||x_period_closed);
211: fnd_file.put_line( 1, 'User je source name :'||x_user_je_source_name );
212: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'User je source name :'||x_user_je_source_name );
213: END IF;

Line 211: fnd_file.put_line( 1, 'User je source name :'||x_user_je_source_name );

207: fnd_file.put_line( 1, 'Period counter :'||x_period_counter);
208: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period counter :'||x_period_counter);
209: fnd_file.put_line( 1, 'Period closed :'||x_period_closed);
210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period closed :'||x_period_closed);
211: fnd_file.put_line( 1, 'User je source name :'||x_user_je_source_name );
212: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'User je source name :'||x_user_je_source_name );
213: END IF;
214:
215: ---------------------------------------------------------

Line 231: fnd_file.put_line (1, fnd_message.get);

227: -----------------------------------------------------------------------------
228:
229: fnd_message.set_name ('JL', 'JL_ZZ_FA_PERIOD_NAME');
230: fnd_message.set_token ('PERIOD_NAME', x_period_name);
231: fnd_file.put_line (1, fnd_message.get);
232:
233: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
234: fnd_file.put_line( 1, 'Period Name :'||x_period_name);
235: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period Name :'||x_period_name);

Line 234: fnd_file.put_line( 1, 'Period Name :'||x_period_name);

230: fnd_message.set_token ('PERIOD_NAME', x_period_name);
231: fnd_file.put_line (1, fnd_message.get);
232:
233: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
234: fnd_file.put_line( 1, 'Period Name :'||x_period_name);
235: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period Name :'||x_period_name);
236: END IF;
237:
238:

Line 246: fnd_file.put_line( 1, 'End Date :'||x_end_date);

242: WHERE calendar_type = x_deprn_calendar
243: AND period_name = x_period_name;
244:
245: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
246: fnd_file.put_line( 1, 'End Date :'||x_end_date);
247: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'End Date :'||x_end_date);
248: END IF;
249:
250: ---------------------------------------------------------

Line 266: fnd_file.put_line( 1, 'Currency Code :'||x_currency_code);

262: FROM gl_sets_of_books
263: WHERE set_of_books_id = x_set_of_book_id;
264:
265: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
266: fnd_file.put_line( 1, 'Currency Code :'||x_currency_code);
267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Currency Code :'||x_currency_code);
268: END IF;
269:
270: ---------------------------------------------------------

Line 286: fnd_file.put_line( 1, fnd_message.get);

282: FOR rec_category IN c_category LOOP
283:
284: fnd_message.set_name('JL', 'JL_CO_FA_JE_CATEGORY');
285: fnd_message.set_token('JE_CATEGORY', rec_category.user_je_category_name);
286: fnd_file.put_line( 1, fnd_message.get);
287:
288: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
289: fnd_file.put_line( 1, 'Je category name :'||rec_category.je_category_name);
290: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Je category name :'||rec_category.je_category_name);

Line 289: fnd_file.put_line( 1, 'Je category name :'||rec_category.je_category_name);

285: fnd_message.set_token('JE_CATEGORY', rec_category.user_je_category_name);
286: fnd_file.put_line( 1, fnd_message.get);
287:
288: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
289: fnd_file.put_line( 1, 'Je category name :'||rec_category.je_category_name);
290: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Je category name :'||rec_category.je_category_name);
291: END IF;
292:
293: x_batch_name := x_user_je_source_name||' '||rec_category.user_je_category_name||' '||

Line 297: fnd_file.put_line( 1, 'Batch Name :'||x_batch_name);

293: x_batch_name := x_user_je_source_name||' '||rec_category.user_je_category_name||' '||
294: p_book||'/'||x_period_name;
295:
296: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
297: fnd_file.put_line( 1, 'Batch Name :'||x_batch_name);
298: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Batch Name :'||x_batch_name);
299: END IF;
300:
301: x_batch_description := p_book||'/'||x_period_name||' '||x_user_je_source_name||' '||

Line 304: fnd_file.put_line( 1, 'Batch description :'||x_batch_description);

300:
301: x_batch_description := p_book||'/'||x_period_name||' '||x_user_je_source_name||' '||
302: rec_category.user_je_category_name;
303: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
304: fnd_file.put_line( 1, 'Batch description :'||x_batch_description);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Batch description :'||x_batch_description);
306: END IF;
307:
308: x_journal_entry_name := x_batch_name;

Line 312: fnd_file.put_line( 1, 'Journal Entry_name :'||x_journal_entry_name);

308: x_journal_entry_name := x_batch_name;
309: x_journal_entry_description := x_batch_description;
310:
311: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
312: fnd_file.put_line( 1, 'Journal Entry_name :'||x_journal_entry_name);
313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Journal Entry_name :'||x_journal_entry_name);
314: fnd_file.put_line( 1, 'Journal Entry description :'||x_batch_description);
315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Journal Entry description :'||x_batch_description);
316: END IF;

Line 314: fnd_file.put_line( 1, 'Journal Entry description :'||x_batch_description);

310:
311: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
312: fnd_file.put_line( 1, 'Journal Entry_name :'||x_journal_entry_name);
313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Journal Entry_name :'||x_journal_entry_name);
314: fnd_file.put_line( 1, 'Journal Entry description :'||x_batch_description);
315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Journal Entry description :'||x_batch_description);
316: END IF;
317:
318:

Line 322: fnd_file.put_line( 1, 'Book_type_code :'||rec_adjustment.source_type_code);

318:
319: FOR rec_adjustment IN c_adjustment(x_period_counter, rec_category.je_category_name) LOOP
320:
321: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
322: fnd_file.put_line( 1, 'Book_type_code :'||rec_adjustment.source_type_code);
323: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Book_type_code :'||rec_adjustment.source_type_code);
324: fnd_file.put_line( 1, 'debit credit flag :'||rec_adjustment.debit_credit_flag);
325: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'debit credit flag :'||rec_adjustment.debit_credit_flag);
326: fnd_file.put_line( 1, 'code_combination_id :'||rec_adjustment.code_combination_id);

Line 324: fnd_file.put_line( 1, 'debit credit flag :'||rec_adjustment.debit_credit_flag);

320:
321: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
322: fnd_file.put_line( 1, 'Book_type_code :'||rec_adjustment.source_type_code);
323: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Book_type_code :'||rec_adjustment.source_type_code);
324: fnd_file.put_line( 1, 'debit credit flag :'||rec_adjustment.debit_credit_flag);
325: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'debit credit flag :'||rec_adjustment.debit_credit_flag);
326: fnd_file.put_line( 1, 'code_combination_id :'||rec_adjustment.code_combination_id);
327: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'code_combination_id :'||rec_adjustment.code_combination_id);
328: fnd_file.put_line( 1, 'Amount :'||to_char(rec_adjustment.x_amount));

Line 326: fnd_file.put_line( 1, 'code_combination_id :'||rec_adjustment.code_combination_id);

322: fnd_file.put_line( 1, 'Book_type_code :'||rec_adjustment.source_type_code);
323: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Book_type_code :'||rec_adjustment.source_type_code);
324: fnd_file.put_line( 1, 'debit credit flag :'||rec_adjustment.debit_credit_flag);
325: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'debit credit flag :'||rec_adjustment.debit_credit_flag);
326: fnd_file.put_line( 1, 'code_combination_id :'||rec_adjustment.code_combination_id);
327: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'code_combination_id :'||rec_adjustment.code_combination_id);
328: fnd_file.put_line( 1, 'Amount :'||to_char(rec_adjustment.x_amount));
329: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Amount :'||to_char(rec_adjustment.x_amount));
330: END IF;

Line 328: fnd_file.put_line( 1, 'Amount :'||to_char(rec_adjustment.x_amount));

324: fnd_file.put_line( 1, 'debit credit flag :'||rec_adjustment.debit_credit_flag);
325: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'debit credit flag :'||rec_adjustment.debit_credit_flag);
326: fnd_file.put_line( 1, 'code_combination_id :'||rec_adjustment.code_combination_id);
327: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'code_combination_id :'||rec_adjustment.code_combination_id);
328: fnd_file.put_line( 1, 'Amount :'||to_char(rec_adjustment.x_amount));
329: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Amount :'||to_char(rec_adjustment.x_amount));
330: END IF;
331:
332: IF rec_adjustment.x_amount <> 0 THEN

Line 349: fnd_file.put_line( 1, 'Inserting row into GL_INTERFACE');

345: IF (x_entered_dr > 0 OR x_entered_cr >0 ) THEN
346:
347:
348: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
349: fnd_file.put_line( 1, 'Inserting row into GL_INTERFACE');
350: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserting row into GL_INTERFACE');
351: END IF;
352:
353:

Line 401: fnd_file.put_line( 1, 'Inserted row into GL_INTERFACE');

397: rec_adjustment.code_combination_id);
398:
399:
400: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
401: fnd_file.put_line( 1, 'Inserted row into GL_INTERFACE');
402: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserted row into GL_INTERFACE');
403: END IF;
404:
405:

Line 451: fnd_file.put_line (fnd_file.log, fnd_message.get);

447: WHEN PERIOD_NOT_DEFINED THEN
448: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
449: fnd_message.set_token('BOOK', p_book);
450: -- err_msg := fnd_message.get;
451: fnd_file.put_line (fnd_file.log, fnd_message.get);
452: call_status := fnd_concurrent.set_completion_status('ERROR','');
453: /*
454: app_exception.raise_exception (exception_type => 'APP',
455: exception_code =>

Line 465: fnd_file.put_line (fnd_file.log, fnd_message.get);

461: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
462: fnd_message.set_token('BOOK', p_book);
463: fnd_message.set_token('PERIOD', x_period_name);
464: -- err_msg := fnd_message.get;
465: fnd_file.put_line (fnd_file.log, fnd_message.get);
466: call_status := fnd_concurrent.set_completion_status('ERROR','');
467: /*
468: app_exception.raise_exception (exception_type => 'APP',
469: exception_code =>

Line 479: fnd_file.put_line (fnd_file.log, fnd_message.get);

475: IF x_statement = 'BOOK_INFO' THEN
476: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
477: fnd_message.set_token('NUMBER', '1');
478: -- err_msg := fnd_message.get;
479: fnd_file.put_line (fnd_file.log, fnd_message.get);
480: ROLLBACK;
481: call_status := fnd_concurrent.set_completion_status('ERROR','');
482: /*
483: app_exception.raise_exception (exception_type => 'APP',

Line 493: fnd_file.put_line (fnd_file.log, fnd_message.get);

489: ELSIF x_statement = 'CURR_INFO' THEN
490: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
491: fnd_message.set_token('NUMBER', '2');
492: -- err_msg := fnd_message.get;
493: fnd_file.put_line (fnd_file.log, fnd_message.get);
494: ROLLBACK;
495: call_status := fnd_concurrent.set_completion_status('ERROR','');
496: /*
497: app_exception.raise_exception (exception_type => 'APP',

Line 507: fnd_file.put_line (fnd_file.log, fnd_message.get);

503: ELSIF x_statement = 'CAL_INFO' THEN
504: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
505: fnd_message.set_token('NUMBER', '3');
506: -- err_msg := fnd_message.get;
507: fnd_file.put_line (fnd_file.log, fnd_message.get);
508: ROLLBACK;
509: call_status := fnd_concurrent.set_completion_status('ERROR','');
510: /*
511: app_exception.raise_exception (exception_type => 'APP',

Line 519: fnd_file.put_line( fnd_file.log, fnd_message.get);

515: */
516:
517: ELSE
518: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
519: fnd_file.put_line( fnd_file.log, fnd_message.get);
520: err_num := SQLCODE;
521: err_msg := substr(SQLERRM, 1, 200);
522: ROLLBACK;
523: RAISE_APPLICATION_ERROR( err_num, err_msg);

Line 561: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));

557: x_program_id := fnd_global.conc_program_id;
558: x_sysdate := SYSDATE;
559:
560: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
561: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
562: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_update_login:'||to_char(x_last_update_login));
563: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));
565: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));

Line 563: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));

559:
560: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
561: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
562: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_update_login:'||to_char(x_last_update_login));
563: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));
565: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_request_id:'||to_char(x_request_id));
567: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));

Line 565: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));

561: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
562: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_update_login:'||to_char(x_last_update_login));
563: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));
565: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_request_id:'||to_char(x_request_id));
567: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
568: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_application_id :'||to_char(x_program_application_id ));
569: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));

Line 567: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));

563: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));
565: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_request_id:'||to_char(x_request_id));
567: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
568: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_application_id :'||to_char(x_program_application_id ));
569: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
570: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_id :'||to_char(x_program_id ));
571: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));

Line 569: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));

565: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_request_id:'||to_char(x_request_id));
567: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
568: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_application_id :'||to_char(x_program_application_id ));
569: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
570: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_id :'||to_char(x_program_id ));
571: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_sysdate :'||to_char(x_sysdate ));
573: END IF;

Line 571: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));

567: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
568: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_application_id :'||to_char(x_program_application_id ));
569: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
570: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_id :'||to_char(x_program_id ));
571: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_sysdate :'||to_char(x_sysdate ));
573: END IF;
574:
575: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN