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

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

183: END IF;
184:
185:
186: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
187: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
188: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
189: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
190: fnd_message.set_token('BOOK', p_book);
191: fnd_file.put_line( 1, fnd_message.get);

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

184:
185:
186: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
187: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
188: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
189: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
190: fnd_message.set_token('BOOK', p_book);
191: fnd_file.put_line( 1, fnd_message.get);
192: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');

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

187: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
188: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
189: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
190: fnd_message.set_token('BOOK', p_book);
191: fnd_file.put_line( 1, fnd_message.get);
192: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');
193: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);
194: fnd_file.put_line( 1, fnd_message.get);
195: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');

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

190: fnd_message.set_token('BOOK', p_book);
191: fnd_file.put_line( 1, fnd_message.get);
192: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');
193: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);
194: fnd_file.put_line( 1, fnd_message.get);
195: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
196: ---------------------------------------------------------
197: -- Find who_columns values --
198: ---------------------------------------------------------

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

191: fnd_file.put_line( 1, fnd_message.get);
192: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');
193: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);
194: fnd_file.put_line( 1, fnd_message.get);
195: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
196: ---------------------------------------------------------
197: -- Find who_columns values --
198: ---------------------------------------------------------
199:

Line 315: fnd_file.put_line( 1, 'set_of_book_id :'||to_char(x_set_of_book_id) );

311:
312:
313: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
314:
315: fnd_file.put_line( 1, 'set_of_book_id :'||to_char(x_set_of_book_id) );
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'set_of_book_id :'||to_char(x_set_of_book_id) );
317: fnd_file.put_line( 1, 'deprn_calendar:'||x_deprn_calendar);
318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'deprn_calendar:'||x_deprn_calendar);
319: fnd_file.put_line( 1, 'x_book_class :'||x_book_class);

Line 317: fnd_file.put_line( 1, 'deprn_calendar:'||x_deprn_calendar);

313: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
314:
315: fnd_file.put_line( 1, 'set_of_book_id :'||to_char(x_set_of_book_id) );
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'set_of_book_id :'||to_char(x_set_of_book_id) );
317: fnd_file.put_line( 1, 'deprn_calendar:'||x_deprn_calendar);
318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'deprn_calendar:'||x_deprn_calendar);
319: fnd_file.put_line( 1, 'x_book_class :'||x_book_class);
320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_book_class :'||x_book_class);
321: fnd_file.put_line( 1, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);

Line 319: fnd_file.put_line( 1, 'x_book_class :'||x_book_class);

315: fnd_file.put_line( 1, 'set_of_book_id :'||to_char(x_set_of_book_id) );
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'set_of_book_id :'||to_char(x_set_of_book_id) );
317: fnd_file.put_line( 1, 'deprn_calendar:'||x_deprn_calendar);
318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'deprn_calendar:'||x_deprn_calendar);
319: fnd_file.put_line( 1, 'x_book_class :'||x_book_class);
320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_book_class :'||x_book_class);
321: fnd_file.put_line( 1, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);
322: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);
323: fnd_file.put_line( 1, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );

Line 321: fnd_file.put_line( 1, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);

317: fnd_file.put_line( 1, 'deprn_calendar:'||x_deprn_calendar);
318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'deprn_calendar:'||x_deprn_calendar);
319: fnd_file.put_line( 1, 'x_book_class :'||x_book_class);
320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_book_class :'||x_book_class);
321: fnd_file.put_line( 1, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);
322: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);
323: fnd_file.put_line( 1, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );
324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );
325: fnd_file.put_line( 1, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );

Line 323: fnd_file.put_line( 1, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );

319: fnd_file.put_line( 1, 'x_book_class :'||x_book_class);
320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_book_class :'||x_book_class);
321: fnd_file.put_line( 1, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);
322: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);
323: fnd_file.put_line( 1, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );
324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );
325: fnd_file.put_line( 1, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );
326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );
327: fnd_file.put_line( 1, 'x_gl_je_source :'||x_gl_je_source);

Line 325: fnd_file.put_line( 1, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );

321: fnd_file.put_line( 1, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);
322: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_gl_posting_allowed_flag :'||x_gl_posting_allowed_flag);
323: fnd_file.put_line( 1, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );
324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );
325: fnd_file.put_line( 1, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );
326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );
327: fnd_file.put_line( 1, 'x_gl_je_source :'||x_gl_je_source);
328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_gl_je_source :'||x_gl_je_source);
329: fnd_file.put_line( 1, 'x_distribution_source_book :'||x_distribution_source_book);

Line 327: fnd_file.put_line( 1, 'x_gl_je_source :'||x_gl_je_source);

323: fnd_file.put_line( 1, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );
324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_current_fiscal_year :'||to_char(x_current_fiscal_year) );
325: fnd_file.put_line( 1, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );
326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );
327: fnd_file.put_line( 1, 'x_gl_je_source :'||x_gl_je_source);
328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_gl_je_source :'||x_gl_je_source);
329: fnd_file.put_line( 1, 'x_distribution_source_book :'||x_distribution_source_book);
330: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_distribution_source_book :'||x_distribution_source_book);
331: fnd_file.put_line( 1, 'x_period_counter :'||to_char(x_period_counter) );

Line 329: fnd_file.put_line( 1, 'x_distribution_source_book :'||x_distribution_source_book);

325: fnd_file.put_line( 1, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );
326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_accounting_flex_structure :'||to_char(x_accounting_flex_structure) );
327: fnd_file.put_line( 1, 'x_gl_je_source :'||x_gl_je_source);
328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_gl_je_source :'||x_gl_je_source);
329: fnd_file.put_line( 1, 'x_distribution_source_book :'||x_distribution_source_book);
330: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_distribution_source_book :'||x_distribution_source_book);
331: fnd_file.put_line( 1, 'x_period_counter :'||to_char(x_period_counter) );
332: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_period_counter :'||to_char(x_period_counter) );
333: fnd_file.put_line( 1, 'x_deprn_status :'||x_deprn_status) ;

Line 331: fnd_file.put_line( 1, 'x_period_counter :'||to_char(x_period_counter) );

327: fnd_file.put_line( 1, 'x_gl_je_source :'||x_gl_je_source);
328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_gl_je_source :'||x_gl_je_source);
329: fnd_file.put_line( 1, 'x_distribution_source_book :'||x_distribution_source_book);
330: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_distribution_source_book :'||x_distribution_source_book);
331: fnd_file.put_line( 1, 'x_period_counter :'||to_char(x_period_counter) );
332: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_period_counter :'||to_char(x_period_counter) );
333: fnd_file.put_line( 1, 'x_deprn_status :'||x_deprn_status) ;
334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_deprn_status :'||x_deprn_status) ;
335: fnd_file.put_line( 1, 'x_je_category_name :'||x_je_category_name) ;

Line 333: fnd_file.put_line( 1, 'x_deprn_status :'||x_deprn_status) ;

329: fnd_file.put_line( 1, 'x_distribution_source_book :'||x_distribution_source_book);
330: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_distribution_source_book :'||x_distribution_source_book);
331: fnd_file.put_line( 1, 'x_period_counter :'||to_char(x_period_counter) );
332: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_period_counter :'||to_char(x_period_counter) );
333: fnd_file.put_line( 1, 'x_deprn_status :'||x_deprn_status) ;
334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_deprn_status :'||x_deprn_status) ;
335: fnd_file.put_line( 1, 'x_je_category_name :'||x_je_category_name) ;
336: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_je_category_name :'||x_je_category_name) ;
337: fnd_file.put_line( 1, 'x_currency_code :'||x_currency_code);

Line 335: fnd_file.put_line( 1, 'x_je_category_name :'||x_je_category_name) ;

331: fnd_file.put_line( 1, 'x_period_counter :'||to_char(x_period_counter) );
332: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_period_counter :'||to_char(x_period_counter) );
333: fnd_file.put_line( 1, 'x_deprn_status :'||x_deprn_status) ;
334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_deprn_status :'||x_deprn_status) ;
335: fnd_file.put_line( 1, 'x_je_category_name :'||x_je_category_name) ;
336: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_je_category_name :'||x_je_category_name) ;
337: fnd_file.put_line( 1, 'x_currency_code :'||x_currency_code);
338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_currency_code :'||x_currency_code);
339: fnd_file.put_line( 1, 'x_user_je_source_name :'||x_user_je_source_name) ;

Line 337: fnd_file.put_line( 1, 'x_currency_code :'||x_currency_code);

333: fnd_file.put_line( 1, 'x_deprn_status :'||x_deprn_status) ;
334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_deprn_status :'||x_deprn_status) ;
335: fnd_file.put_line( 1, 'x_je_category_name :'||x_je_category_name) ;
336: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_je_category_name :'||x_je_category_name) ;
337: fnd_file.put_line( 1, 'x_currency_code :'||x_currency_code);
338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_currency_code :'||x_currency_code);
339: fnd_file.put_line( 1, 'x_user_je_source_name :'||x_user_je_source_name) ;
340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_user_je_source_name :'||x_user_je_source_name);
341: fnd_file.put_line( 1, 'x_period_name :'||x_period_name);

Line 339: fnd_file.put_line( 1, 'x_user_je_source_name :'||x_user_je_source_name) ;

335: fnd_file.put_line( 1, 'x_je_category_name :'||x_je_category_name) ;
336: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_je_category_name :'||x_je_category_name) ;
337: fnd_file.put_line( 1, 'x_currency_code :'||x_currency_code);
338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_currency_code :'||x_currency_code);
339: fnd_file.put_line( 1, 'x_user_je_source_name :'||x_user_je_source_name) ;
340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_user_je_source_name :'||x_user_je_source_name);
341: fnd_file.put_line( 1, 'x_period_name :'||x_period_name);
342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_period_name :'||x_period_name);
343: fnd_file.put_line( 1, 'x_end_date :'||to_char(x_end_date));

Line 341: fnd_file.put_line( 1, 'x_period_name :'||x_period_name);

337: fnd_file.put_line( 1, 'x_currency_code :'||x_currency_code);
338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_currency_code :'||x_currency_code);
339: fnd_file.put_line( 1, 'x_user_je_source_name :'||x_user_je_source_name) ;
340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_user_je_source_name :'||x_user_je_source_name);
341: fnd_file.put_line( 1, 'x_period_name :'||x_period_name);
342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_period_name :'||x_period_name);
343: fnd_file.put_line( 1, 'x_end_date :'||to_char(x_end_date));
344: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_end_date :'||to_char(x_end_date));
345:

Line 343: fnd_file.put_line( 1, 'x_end_date :'||to_char(x_end_date));

339: fnd_file.put_line( 1, 'x_user_je_source_name :'||x_user_je_source_name) ;
340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_user_je_source_name :'||x_user_je_source_name);
341: fnd_file.put_line( 1, 'x_period_name :'||x_period_name);
342: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_period_name :'||x_period_name);
343: fnd_file.put_line( 1, 'x_end_date :'||to_char(x_end_date));
344: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_end_date :'||to_char(x_end_date));
345:
346:
347: END IF;

Line 388: fnd_file.put_line( 1, 'Balancing Qualifier :'||x_account_qualifier );

384:
385:
386: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
387:
388: fnd_file.put_line( 1, 'Balancing Qualifier :'||x_account_qualifier );
389: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Balancing Qualifier :'||x_account_qualifier);
390: fnd_file.put_line( 1, 'Balancing segment no :'||to_char(x_account_segment_no));
391: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Balancing segment no :'||to_char(x_account_segment_no));
392: END IF;

Line 390: fnd_file.put_line( 1, 'Balancing segment no :'||to_char(x_account_segment_no));

386: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
387:
388: fnd_file.put_line( 1, 'Balancing Qualifier :'||x_account_qualifier );
389: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Balancing Qualifier :'||x_account_qualifier);
390: fnd_file.put_line( 1, 'Balancing segment no :'||to_char(x_account_segment_no));
391: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Balancing segment no :'||to_char(x_account_segment_no));
392: END IF;
393:
394: ---------------------------------------------------------

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

408: FOR rec_appraisal IN c_appraisal LOOP
409:
410: fnd_message.set_name('JL', 'JL_CO_FA_APPR_MESG');
411: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
412: fnd_file.put_line( 1, fnd_message.get);
413:
414: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
415: fnd_file.put_line( 1, 'Currency code in appraisal :'||rec_appraisal.currency_code);
416: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Currency code in appraisal :'||rec_appraisal.currency_code);

Line 415: fnd_file.put_line( 1, 'Currency code in appraisal :'||rec_appraisal.currency_code);

411: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
412: fnd_file.put_line( 1, fnd_message.get);
413:
414: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
415: fnd_file.put_line( 1, 'Currency code in appraisal :'||rec_appraisal.currency_code);
416: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Currency code in appraisal :'||rec_appraisal.currency_code);
417: fnd_file.put_line( 1, 'Appraisal Date :'||rec_appraisal.appraisal_date);
418: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal Date :'||rec_appraisal.appraisal_date);
419: END IF;

Line 417: fnd_file.put_line( 1, 'Appraisal Date :'||rec_appraisal.appraisal_date);

413:
414: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
415: fnd_file.put_line( 1, 'Currency code in appraisal :'||rec_appraisal.currency_code);
416: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Currency code in appraisal :'||rec_appraisal.currency_code);
417: fnd_file.put_line( 1, 'Appraisal Date :'||rec_appraisal.appraisal_date);
418: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal Date :'||rec_appraisal.appraisal_date);
419: END IF;
420:
421: /* IF (x_current_fiscal_year <> rec_appraisal.fiscal_year) THEN

Line 450: fnd_file.put_line( 1, 'appraisal_id : '||to_char(rec_appraisal.appraisal_id));

446:
447: ELSE
448:
449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
450: fnd_file.put_line( 1, 'appraisal_id : '||to_char(rec_appraisal.appraisal_id));
451: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'appraisal_id : '||to_char(rec_appraisal.appraisal_id));
452: fnd_file.put_line( 1, 'End_date : '||x_end_date);
453: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'End_date : '||x_end_date);
454: END IF;

Line 452: fnd_file.put_line( 1, 'End_date : '||x_end_date);

448:
449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
450: fnd_file.put_line( 1, 'appraisal_id : '||to_char(rec_appraisal.appraisal_id));
451: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'appraisal_id : '||to_char(rec_appraisal.appraisal_id));
452: fnd_file.put_line( 1, 'End_date : '||x_end_date);
453: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'End_date : '||x_end_date);
454: END IF;
455:
456: ---------------------------------------------------------

Line 468: fnd_file.put_line( 1, 'Asset_Number :'||rec_asset.asset_number);

464: FOR rec_asset IN c_asset(rec_appraisal.appraisal_id, x_period_counter) LOOP
465:
466: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
467:
468: fnd_file.put_line( 1, 'Asset_Number :'||rec_asset.asset_number);
469: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset_Number :'||rec_asset.asset_number);
470: fnd_file.put_line( 1, 'Appraisal value :'||to_char(rec_asset.appraisal_value));
471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal value :'||to_char(rec_asset.appraisal_value));
472: fnd_file.put_line( 1, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));

Line 470: fnd_file.put_line( 1, 'Appraisal value :'||to_char(rec_asset.appraisal_value));

466: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
467:
468: fnd_file.put_line( 1, 'Asset_Number :'||rec_asset.asset_number);
469: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset_Number :'||rec_asset.asset_number);
470: fnd_file.put_line( 1, 'Appraisal value :'||to_char(rec_asset.appraisal_value));
471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal value :'||to_char(rec_asset.appraisal_value));
472: fnd_file.put_line( 1, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));
474: fnd_file.put_line( 1, 'Asset Id :'||to_char(rec_asset.asset_id));

Line 472: fnd_file.put_line( 1, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));

468: fnd_file.put_line( 1, 'Asset_Number :'||rec_asset.asset_number);
469: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset_Number :'||rec_asset.asset_number);
470: fnd_file.put_line( 1, 'Appraisal value :'||to_char(rec_asset.appraisal_value));
471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal value :'||to_char(rec_asset.appraisal_value));
472: fnd_file.put_line( 1, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));
474: fnd_file.put_line( 1, 'Asset Id :'||to_char(rec_asset.asset_id));
475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Id :'||to_char(rec_asset.asset_id));
476: fnd_file.put_line( 1, 'Asset Cost :'||to_char(rec_asset.cost));

Line 474: fnd_file.put_line( 1, 'Asset Id :'||to_char(rec_asset.asset_id));

470: fnd_file.put_line( 1, 'Appraisal value :'||to_char(rec_asset.appraisal_value));
471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal value :'||to_char(rec_asset.appraisal_value));
472: fnd_file.put_line( 1, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));
474: fnd_file.put_line( 1, 'Asset Id :'||to_char(rec_asset.asset_id));
475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Id :'||to_char(rec_asset.asset_id));
476: fnd_file.put_line( 1, 'Asset Cost :'||to_char(rec_asset.cost));
477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Cost :'||to_char(rec_asset.cost));
478: fnd_file.put_line( 1, 'Previous revaluation :'||rec_asset.prev_revaluation);

Line 476: fnd_file.put_line( 1, 'Asset Cost :'||to_char(rec_asset.cost));

472: fnd_file.put_line( 1, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Category Id :'||to_char(rec_asset.asset_category_id));
474: fnd_file.put_line( 1, 'Asset Id :'||to_char(rec_asset.asset_id));
475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Id :'||to_char(rec_asset.asset_id));
476: fnd_file.put_line( 1, 'Asset Cost :'||to_char(rec_asset.cost));
477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Cost :'||to_char(rec_asset.cost));
478: fnd_file.put_line( 1, 'Previous revaluation :'||rec_asset.prev_revaluation);
479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Previous revaluation :'||rec_asset.prev_revaluation);
480: fnd_file.put_line( 1, 'Depreciation reserve :'||to_char(rec_asset.deprn_reserve));

Line 478: fnd_file.put_line( 1, 'Previous revaluation :'||rec_asset.prev_revaluation);

474: fnd_file.put_line( 1, 'Asset Id :'||to_char(rec_asset.asset_id));
475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Id :'||to_char(rec_asset.asset_id));
476: fnd_file.put_line( 1, 'Asset Cost :'||to_char(rec_asset.cost));
477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Cost :'||to_char(rec_asset.cost));
478: fnd_file.put_line( 1, 'Previous revaluation :'||rec_asset.prev_revaluation);
479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Previous revaluation :'||rec_asset.prev_revaluation);
480: fnd_file.put_line( 1, 'Depreciation reserve :'||to_char(rec_asset.deprn_reserve));
481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Depreciation reserve :'||to_char(rec_asset.deprn_reserve));
482: END IF;

Line 480: fnd_file.put_line( 1, 'Depreciation reserve :'||to_char(rec_asset.deprn_reserve));

476: fnd_file.put_line( 1, 'Asset Cost :'||to_char(rec_asset.cost));
477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Asset Cost :'||to_char(rec_asset.cost));
478: fnd_file.put_line( 1, 'Previous revaluation :'||rec_asset.prev_revaluation);
479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Previous revaluation :'||rec_asset.prev_revaluation);
480: fnd_file.put_line( 1, 'Depreciation reserve :'||to_char(rec_asset.deprn_reserve));
481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Depreciation reserve :'||to_char(rec_asset.deprn_reserve));
482: END IF;
483:
484: ---------------------------------------------------------

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

491:
492: fnd_message.set_name('JL', 'JL_ZZ_FA_ASSET_RETIRED');
493: fnd_message.set_token('ASSET_NUMBER', rec_asset.asset_number);
494: fnd_message.set_token('BOOK', p_book);
495: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
496: x_temporal := fnd_concurrent.set_completion_status( status => 'WARNING',
497: message => '');
498: null;
499: /* ELSIF (rec_asset.date_placed_in_service > x_end_date) THEN

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

500:
501: fnd_message.set_name('JL', 'JL_ZZ_FA_FUTURE_DATE');
502: fnd_message.set_token('ASSET_NUMBER', rec_asset.asset_number);
503: fnd_message.set_token('BOOK', p_book);
504: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
505: x_temporal := fnd_concurrent.set_completion_status( status => 'WARNING',
506: message => '');*/
507: ELSE
508:

Line 520: fnd_file.put_line( 1, 'Appraisal Revaluation :'||to_char(x_appr_revaluation));

516: x_net_revaluation := x_appr_revaluation - x_prev_revaluation;
517:
518: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
519:
520: fnd_file.put_line( 1, 'Appraisal Revaluation :'||to_char(x_appr_revaluation));
521: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal Revaluation :'||to_char(x_appr_revaluation));
522: fnd_file.put_line( 1, 'Previous Revaluation :'||to_char(x_prev_revaluation));
523: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Previous Revaluation :'||to_char(x_prev_revaluation));
524: fnd_file.put_line( 1, 'Net Revaluation :'||to_char(x_net_revaluation));

Line 522: fnd_file.put_line( 1, 'Previous Revaluation :'||to_char(x_prev_revaluation));

518: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
519:
520: fnd_file.put_line( 1, 'Appraisal Revaluation :'||to_char(x_appr_revaluation));
521: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal Revaluation :'||to_char(x_appr_revaluation));
522: fnd_file.put_line( 1, 'Previous Revaluation :'||to_char(x_prev_revaluation));
523: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Previous Revaluation :'||to_char(x_prev_revaluation));
524: fnd_file.put_line( 1, 'Net Revaluation :'||to_char(x_net_revaluation));
525: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Net Revaluation :'||to_char(x_net_revaluation));
526:

Line 524: fnd_file.put_line( 1, 'Net Revaluation :'||to_char(x_net_revaluation));

520: fnd_file.put_line( 1, 'Appraisal Revaluation :'||to_char(x_appr_revaluation));
521: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Appraisal Revaluation :'||to_char(x_appr_revaluation));
522: fnd_file.put_line( 1, 'Previous Revaluation :'||to_char(x_prev_revaluation));
523: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Previous Revaluation :'||to_char(x_prev_revaluation));
524: fnd_file.put_line( 1, 'Net Revaluation :'||to_char(x_net_revaluation));
525: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Net Revaluation :'||to_char(x_net_revaluation));
526:
527: END IF;
528:

Line 556: fnd_file.put_line( 1, 'For Category ID '||to_char(x_category_id)||' and book '||p_book||' :');

552: WHERE category_id = x_category_id
553: AND book_type_code = p_book;
554:
555: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
556: fnd_file.put_line( 1, 'For Category ID '||to_char(x_category_id)||' and book '||p_book||' :');
557: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'For Category ID '||to_char(x_category_id)||' and book '||p_book||' :');
558: fnd_file.put_line( 1, 'CCID of revaluation account :'||x_revaluation_account);
559: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of revaluation account :'||x_revaluation_account);
560: fnd_file.put_line( 1, 'CCID of surplus account account :'||x_surplus_account);

Line 558: fnd_file.put_line( 1, 'CCID of revaluation account :'||x_revaluation_account);

554:
555: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
556: fnd_file.put_line( 1, 'For Category ID '||to_char(x_category_id)||' and book '||p_book||' :');
557: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'For Category ID '||to_char(x_category_id)||' and book '||p_book||' :');
558: fnd_file.put_line( 1, 'CCID of revaluation account :'||x_revaluation_account);
559: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of revaluation account :'||x_revaluation_account);
560: fnd_file.put_line( 1, 'CCID of surplus account account :'||x_surplus_account);
561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of surplus account account :'||x_surplus_account);
562: fnd_file.put_line( 1, 'CCID of reserve account :'||x_reserve_account);

Line 560: fnd_file.put_line( 1, 'CCID of surplus account account :'||x_surplus_account);

556: fnd_file.put_line( 1, 'For Category ID '||to_char(x_category_id)||' and book '||p_book||' :');
557: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'For Category ID '||to_char(x_category_id)||' and book '||p_book||' :');
558: fnd_file.put_line( 1, 'CCID of revaluation account :'||x_revaluation_account);
559: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of revaluation account :'||x_revaluation_account);
560: fnd_file.put_line( 1, 'CCID of surplus account account :'||x_surplus_account);
561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of surplus account account :'||x_surplus_account);
562: fnd_file.put_line( 1, 'CCID of reserve account :'||x_reserve_account);
563: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of reserve account :'||x_reserve_account);
564: fnd_file.put_line( 1, 'CCID of expense account :'||x_expense_account);

Line 562: fnd_file.put_line( 1, 'CCID of reserve account :'||x_reserve_account);

558: fnd_file.put_line( 1, 'CCID of revaluation account :'||x_revaluation_account);
559: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of revaluation account :'||x_revaluation_account);
560: fnd_file.put_line( 1, 'CCID of surplus account account :'||x_surplus_account);
561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of surplus account account :'||x_surplus_account);
562: fnd_file.put_line( 1, 'CCID of reserve account :'||x_reserve_account);
563: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of reserve account :'||x_reserve_account);
564: fnd_file.put_line( 1, 'CCID of expense account :'||x_expense_account);
565: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of expense account :'||x_expense_account);
566: fnd_file.put_line( 1, 'CCID of recovery account :'||x_recovery_account);

Line 564: fnd_file.put_line( 1, 'CCID of expense account :'||x_expense_account);

560: fnd_file.put_line( 1, 'CCID of surplus account account :'||x_surplus_account);
561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of surplus account account :'||x_surplus_account);
562: fnd_file.put_line( 1, 'CCID of reserve account :'||x_reserve_account);
563: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of reserve account :'||x_reserve_account);
564: fnd_file.put_line( 1, 'CCID of expense account :'||x_expense_account);
565: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of expense account :'||x_expense_account);
566: fnd_file.put_line( 1, 'CCID of recovery account :'||x_recovery_account);
567: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of recovery account :'||x_recovery_account);
568: fnd_file.put_line( 1, 'Default cost account ccid :'||to_char(x_asset_cost_account_ccid));

Line 566: fnd_file.put_line( 1, 'CCID of recovery account :'||x_recovery_account);

562: fnd_file.put_line( 1, 'CCID of reserve account :'||x_reserve_account);
563: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of reserve account :'||x_reserve_account);
564: fnd_file.put_line( 1, 'CCID of expense account :'||x_expense_account);
565: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of expense account :'||x_expense_account);
566: fnd_file.put_line( 1, 'CCID of recovery account :'||x_recovery_account);
567: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of recovery account :'||x_recovery_account);
568: fnd_file.put_line( 1, 'Default cost account ccid :'||to_char(x_asset_cost_account_ccid));
569: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Default cost account ccid :'||to_char(x_asset_cost_account_ccid));
570: fnd_file.put_line( 1, 'Account segment Value of cost acct :'||x_asset_cost_acct_segval);

Line 568: fnd_file.put_line( 1, 'Default cost account ccid :'||to_char(x_asset_cost_account_ccid));

564: fnd_file.put_line( 1, 'CCID of expense account :'||x_expense_account);
565: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of expense account :'||x_expense_account);
566: fnd_file.put_line( 1, 'CCID of recovery account :'||x_recovery_account);
567: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of recovery account :'||x_recovery_account);
568: fnd_file.put_line( 1, 'Default cost account ccid :'||to_char(x_asset_cost_account_ccid));
569: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Default cost account ccid :'||to_char(x_asset_cost_account_ccid));
570: fnd_file.put_line( 1, 'Account segment Value of cost acct :'||x_asset_cost_acct_segval);
571: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Account segment Value of cost acct :'||x_asset_cost_acct_segval);
572: END IF;

Line 570: fnd_file.put_line( 1, 'Account segment Value of cost acct :'||x_asset_cost_acct_segval);

566: fnd_file.put_line( 1, 'CCID of recovery account :'||x_recovery_account);
567: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID of recovery account :'||x_recovery_account);
568: fnd_file.put_line( 1, 'Default cost account ccid :'||to_char(x_asset_cost_account_ccid));
569: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Default cost account ccid :'||to_char(x_asset_cost_account_ccid));
570: fnd_file.put_line( 1, 'Account segment Value of cost acct :'||x_asset_cost_acct_segval);
571: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Account segment Value of cost acct :'||x_asset_cost_acct_segval);
572: END IF;
573:
574: ---------------------------------------------------------

Line 604: fnd_file.put_line( 1, 'Distribution ID :'||to_char(rec_dist.distribution_id));

600: FOR rec_dist IN c_distribution(rec_asset.asset_id, x_book) LOOP
601:
602:
603: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
604: fnd_file.put_line( 1, 'Distribution ID :'||to_char(rec_dist.distribution_id));
605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Distribution ID :'||to_char(rec_dist.distribution_id));
606: fnd_file.put_line( 1, 'Assigned Unit :'||to_char(rec_dist.units_assigned));
607: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Assigned Unit :'||to_char(rec_dist.units_assigned));
608: fnd_file.put_line( 1, 'CCID :'||to_char(rec_dist.code_combination_id));

Line 606: fnd_file.put_line( 1, 'Assigned Unit :'||to_char(rec_dist.units_assigned));

602:
603: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
604: fnd_file.put_line( 1, 'Distribution ID :'||to_char(rec_dist.distribution_id));
605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Distribution ID :'||to_char(rec_dist.distribution_id));
606: fnd_file.put_line( 1, 'Assigned Unit :'||to_char(rec_dist.units_assigned));
607: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Assigned Unit :'||to_char(rec_dist.units_assigned));
608: fnd_file.put_line( 1, 'CCID :'||to_char(rec_dist.code_combination_id));
609: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID :'||to_char(rec_dist.code_combination_id));
610: END IF;

Line 608: fnd_file.put_line( 1, 'CCID :'||to_char(rec_dist.code_combination_id));

604: fnd_file.put_line( 1, 'Distribution ID :'||to_char(rec_dist.distribution_id));
605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Distribution ID :'||to_char(rec_dist.distribution_id));
606: fnd_file.put_line( 1, 'Assigned Unit :'||to_char(rec_dist.units_assigned));
607: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Assigned Unit :'||to_char(rec_dist.units_assigned));
608: fnd_file.put_line( 1, 'CCID :'||to_char(rec_dist.code_combination_id));
609: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CCID :'||to_char(rec_dist.code_combination_id));
610: END IF;
611:
612: ---------------------------------------------------------

Line 627: fnd_file.put_line( 1, 'actual cost acct ccid :'||to_char(x_actual_cost_acct_ccid));

623: X_concat_segs => x_cost_account_code,
624: X_return_value => x_rtn_value);
625:
626: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
627: fnd_file.put_line( 1, 'actual cost acct ccid :'||to_char(x_actual_cost_acct_ccid));
628: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'actual cost acct ccid :'||to_char(x_actual_cost_acct_ccid));
629: END IF;
630:
631:

Line 660: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

656: RAISE CCID_NOT_FOUND;
657: END IF;
658:
659: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
660: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
661: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
662: END IF;
663:
664: insert_row( p_adjustment_type => 'APPR_REVAL',

Line 695: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

691: END IF;
692:
693:
694: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
695: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
696: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
697: END IF;
698:
699:

Line 733: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

729: RAISE CCID_NOT_FOUND;
730: END IF;
731:
732: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
733: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
734: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
735: END IF;
736:
737:

Line 767: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

763: RAISE CCID_NOT_FOUND;
764: END IF;
765:
766: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
767: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
768: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
769: END IF;
770:
771:

Line 806: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

802: END IF;
803:
804:
805: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
806: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
808: END IF;
809:
810:

Line 839: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

835: RAISE CCID_NOT_FOUND;
836: END IF;
837:
838: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
839: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
841: END IF;
842:
843:

Line 872: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

868: RAISE CCID_NOT_FOUND;
869: END IF;
870:
871: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
872: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
873: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
874: END IF;
875:
876:

Line 906: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

902: RAISE CCID_NOT_FOUND;
903: END IF;
904:
905: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
906: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
907: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
908: END IF;
909:
910:

Line 947: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

943: END IF;
944:
945:
946: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
947: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
948: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
949: END IF;
950:
951:

Line 980: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

976: RAISE CCID_NOT_FOUND;
977: END IF;
978:
979: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
980: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
981: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
982: END IF;
983:
984:

Line 1014: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

1010: RAISE CCID_NOT_FOUND;
1011: END IF;
1012:
1013: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1014: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
1015: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
1016: END IF;
1017:
1018:

Line 1047: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

1043: RAISE CCID_NOT_FOUND;
1044: END IF;
1045:
1046: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1047: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
1048: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
1049: END IF;
1050:
1051:

Line 1085: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

1081: RAISE CCID_NOT_FOUND;
1082: END IF;
1083:
1084: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1085: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
1086: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
1087: END IF;
1088:
1089:

Line 1119: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

1115: RAISE CCID_NOT_FOUND;
1116: END IF;
1117:
1118: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1119: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
1120: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
1121: END IF;
1122:
1123:

Line 1158: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

1154: RAISE CCID_NOT_FOUND;
1155: END IF;
1156:
1157: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1158: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
1159: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
1160: END IF;
1161:
1162:

Line 1192: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));

1188: RAISE CCID_NOT_FOUND;
1189: END IF;
1190:
1191: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1192: fnd_file.put_line( 1, 'New CCID:'||to_char(x_ccid));
1193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'New CCID:'||to_char(x_ccid));
1194: END IF;
1195:
1196:

Line 1218: fnd_file.put_line( 1, 'Updating JL_CO_FA_ASSET_APPRS');

1214: -- Update jl_co_fa_appr_assts. For each asset set --
1215: -- status = 'P' ie. processed --
1216: ---------------------------------------------------------
1217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1218: fnd_file.put_line( 1, 'Updating JL_CO_FA_ASSET_APPRS');
1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_ASSET_APPRS');
1220: END IF;
1221:
1222: UPDATE jl_co_fa_asset_apprs SET status = 'P',

Line 1229: fnd_file.put_line( 1, 'Updated JL_CO_FA_ASSET_APPRS');

1225: last_update_login = x_last_update_login
1226: WHERE CURRENT OF c_asset;
1227:
1228: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1229: fnd_file.put_line( 1, 'Updated JL_CO_FA_ASSET_APPRS');
1230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated JL_CO_FA_ASSET_APPRS');
1231: END IF;*/
1232: ---------------------------------------------------------
1233: -- Update fa_book for each asset --

Line 1237: fnd_file.put_line( 1, 'Updating FA_BOOKS');

1233: -- Update fa_book for each asset --
1234: ---------------------------------------------------------
1235:
1236: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1237: fnd_file.put_line( 1, 'Updating FA_BOOKS');
1238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating FA_BOOKS');
1239: END IF;
1240:
1241: UPDATE fa_books SET

Line 1256: fnd_file.put_line( 1, 'Updated FA_BOOKS');

1252: AND transaction_header_id_out IS NULL
1253: AND date_ineffective IS NULL ;
1254:
1255: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1256: fnd_file.put_line( 1, 'Updated FA_BOOKS');
1257: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated FA_BOOKS');
1258: END IF;
1259:
1260: ---------------------------------------------------------

Line 1281: fnd_file.put_line( 1, 'Updating JL_CO_FA_APPRAISALS');

1277: -- Update jl_co_fa_appraisals table --
1278: ---------------------------------------------------------
1279:
1280: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1281: fnd_file.put_line( 1, 'Updating JL_CO_FA_APPRAISALS');
1282: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_APPRAISALS');
1283: END IF;
1284:
1285: UPDATE jl_co_fa_appraisals SET appraisal_status = 'P',

Line 1293: fnd_file.put_line( 1, 'Updated JL_CO_FA_APPRAISALS');

1289:
1290: WHERE CURRENT OF c_appraisal;
1291:
1292: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1293: fnd_file.put_line( 1, 'Updated JL_CO_FA_APPRAISALS');
1294: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated JL_CO_FA_APPRAISALS');
1295: END IF;
1296:
1297: ---------------------------------------------------------

Line 1344: fnd_file.put_line(fnd_file.log, err_msg);

1340: WHEN NOT_A_TAX_BOOK THEN
1341: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_TAX_BOOK');
1342: fnd_message.set_token('BOOK', p_book);
1343: err_msg := fnd_message.get;
1344: fnd_file.put_line(fnd_file.log, err_msg);
1345: call_status := fnd_concurrent.set_completion_status('ERROR','');
1346: /*
1347: fnd_message.raise_error;
1348: */

Line 1354: fnd_file.put_line(fnd_file.log, err_msg);

1350: fnd_message.set_name('JL', 'JL_ZZ_FA_JE_CAT_NOT_DEFINED');
1351: fnd_message.set_token('BOOK', p_book);
1352: err_msg := fnd_message.get;
1353: ROLLBACK;
1354: fnd_file.put_line(fnd_file.log, err_msg);
1355: call_status := fnd_concurrent.set_completion_status('ERROR','');
1356: /*
1357: fnd_message.raise_error;
1358: */

Line 1363: fnd_file.put_line(fnd_file.log, err_msg);

1359: WHEN GL_POSTING_NOT_ALLOWED THEN
1360: fnd_message.set_name('JL', 'JL_CO_FA_POSTING_NOT_ALLOWED');
1361: fnd_message.set_token('BOOK', p_book);
1362: err_msg := fnd_message.get;
1363: fnd_file.put_line(fnd_file.log, err_msg);
1364: call_status := fnd_concurrent.set_completion_status('ERROR','');
1365: /*
1366: fnd_message.raise_error;
1367: */

Line 1381: fnd_file.put_line(fnd_file.log, err_msg);

1377: WHEN DEPRN_STATUS_NOT_C THEN
1378: fnd_message.set_name('JL', 'JL_CO_FA_DEPRECIATION_STATUS');
1379: fnd_message.set_token('BOOK', p_book);
1380: err_msg := fnd_message.get;
1381: fnd_file.put_line(fnd_file.log, err_msg);
1382: call_status := fnd_concurrent.set_completion_status('ERROR','');
1383: /*
1384: fnd_message.raise_error;
1385: */

Line 1398: fnd_file.put_line(fnd_file.log, err_msg);

1394: ROLLBACK;
1395: fnd_message.set_name('JL', 'JL_CO_FA_CCID_NOT_DEFINED');
1396: fnd_message.set_token('CATEGORY', x_category);
1397: err_msg := fnd_message.get;
1398: fnd_file.put_line(fnd_file.log, err_msg);
1399: call_status := fnd_concurrent.set_completion_status('ERROR','');
1400: /*
1401: fnd_message.raise_error;
1402: */

Line 1416: fnd_file.put_line(fnd_file.log, err_msg);

1412: ROLLBACK;
1413: fnd_message.set_name('JL', 'JL_CO_FA_CCID_NOT_DEFINED');
1414: fnd_message.set_token('CATEGORY', x_category);
1415: err_msg := fnd_message.get;
1416: fnd_file.put_line(fnd_file.log, err_msg);
1417: call_status := fnd_concurrent.set_completion_status('ERROR','');
1418: /*
1419: fnd_message.raise_error;
1420: */

Line 1437: fnd_file.put_line(fnd_file.log, err_msg);

1433: fnd_message.set_name('JL', 'JL_CO_FA_DIFFERENT_CURRENCY');
1434: fnd_message.set_token('APPRAISAL_NUMBER', to_char(p_appraisal_id));
1435: fnd_message.set_token('BOOK', p_book);
1436: err_msg := fnd_message.get;
1437: fnd_file.put_line(fnd_file.log, err_msg);
1438: call_status := fnd_concurrent.set_completion_status('ERROR','');
1439: /*
1440: fnd_message.raise_error;
1441: */

Line 1448: fnd_file.put_line(fnd_file.log, err_msg);

1444: IF x_statement = 'BOOK_INFO' THEN
1445: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
1446: fnd_message.set_token('NUMBER', '1');
1447: err_msg := fnd_message.get;
1448: fnd_file.put_line(fnd_file.log, err_msg);
1449: call_status := fnd_concurrent.set_completion_status('ERROR','');
1450: /*
1451: fnd_message.raise_error;
1452: */

Line 1458: fnd_file.put_line(fnd_file.log, err_msg);

1454: ELSIF x_statement = 'FLEX_INFO' THEN
1455: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
1456: fnd_message.set_token('NUMBER', '2');
1457: err_msg := fnd_message.get;
1458: fnd_file.put_line(fnd_file.log, err_msg);
1459: call_status := fnd_concurrent.set_completion_status('ERROR','');
1460: /*
1461: fnd_message.raise_error;
1462: */

Line 1468: fnd_file.put_line(fnd_file.log, err_msg);

1464: ELSIF x_statement = 'CURR_INFO' THEN
1465: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
1466: fnd_message.set_token('NUMBER', '3');
1467: err_msg := fnd_message.get;
1468: fnd_file.put_line(fnd_file.log, err_msg);
1469: call_status := fnd_concurrent.set_completion_status('ERROR','');
1470: /*
1471: fnd_message.raise_error;
1472: */

Line 1479: fnd_file.put_line(fnd_file.log, err_msg);

1475: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
1476: fnd_message.set_token('NUMBER', '4');
1477: err_msg := fnd_message.get;
1478: ROLLBACK;
1479: fnd_file.put_line(fnd_file.log, err_msg);
1480: call_status := fnd_concurrent.set_completion_status('ERROR','');
1481: /*
1482: fnd_message.raise_error;
1483: */

Line 1490: fnd_file.put_line(fnd_file.log, err_msg);

1486: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
1487: fnd_message.set_token('NUMBER', '5');
1488: err_msg := fnd_message.get;
1489: ROLLBACK;
1490: fnd_file.put_line(fnd_file.log, err_msg);
1491: call_status := fnd_concurrent.set_completion_status('ERROR','');
1492: /*
1493: fnd_message.raise_error;
1494: */

Line 1501: fnd_file.put_line(fnd_file.log, err_msg);

1497: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
1498: fnd_message.set_token('NUMBER', '6');
1499: err_msg := fnd_message.get;
1500: ROLLBACK;
1501: fnd_file.put_line(fnd_file.log, err_msg);
1502: call_status := fnd_concurrent.set_completion_status('ERROR','');
1503: /*
1504: fnd_message.raise_error;
1505: */

Line 1512: fnd_file.put_line(fnd_file.log, err_msg);

1508: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
1509: fnd_message.set_token('NUMBER', '7');
1510: err_msg := fnd_message.get;
1511: ROLLBACK;
1512: fnd_file.put_line(fnd_file.log, err_msg);
1513: call_status := fnd_concurrent.set_completion_status('ERROR','');
1514: /*
1515: fnd_message.raise_error;
1516: */

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

1516: */
1517:
1518: ELSE
1519: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
1520: fnd_file.put_line( fnd_file.log, fnd_message.get);
1521: err_num := SQLCODE;
1522: err_msg := substr(SQLERRM, 1, 200);
1523: ROLLBACK;
1524: RAISE_APPLICATION_ERROR( err_num, err_msg);

Line 1583: fnd_file.put_line( 1, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');

1579: AND period_close_date IS NULL;
1580:
1581:
1582: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1583: fnd_file.put_line( 1, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');
1584: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');
1585: END IF;
1586:
1587:

Line 1636: fnd_file.put_line( 1, 'Inseted Row into JL_CO_FA_ADJUSTMENTS');

1632: x_sysdate);
1633: END IF;
1634:
1635: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1636: fnd_file.put_line( 1, 'Inseted Row into JL_CO_FA_ADJUSTMENTS');
1637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserted Row into JL_CO_FA_ADJUSTMENTS');
1638: END IF;
1639:
1640: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1675: x_program_id := fnd_global.conc_program_id;
1676: x_sysdate := SYSDATE;
1677:
1678: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1679: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
1680: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_update_login:'||to_char(x_last_update_login));
1681: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
1682: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));
1683: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));

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

1677:
1678: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1679: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
1680: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_update_login:'||to_char(x_last_update_login));
1681: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
1682: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));
1683: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
1684: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_request_id:'||to_char(x_request_id));
1685: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));

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

1679: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
1680: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_update_login:'||to_char(x_last_update_login));
1681: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
1682: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));
1683: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
1684: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_request_id:'||to_char(x_request_id));
1685: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
1686: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_application_id :'||to_char(x_program_application_id ));
1687: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));

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

1681: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
1682: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));
1683: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
1684: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_request_id:'||to_char(x_request_id));
1685: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
1686: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_application_id :'||to_char(x_program_application_id ));
1687: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
1688: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_id :'||to_char(x_program_id ));
1689: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));

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

1683: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
1684: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_request_id:'||to_char(x_request_id));
1685: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
1686: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_application_id :'||to_char(x_program_application_id ));
1687: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
1688: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_id :'||to_char(x_program_id ));
1689: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
1690: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_sysdate :'||to_char(x_sysdate ));
1691:

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

1685: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
1686: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_application_id :'||to_char(x_program_application_id ));
1687: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
1688: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_program_id :'||to_char(x_program_id ));
1689: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
1690: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_sysdate :'||to_char(x_sysdate ));
1691:
1692: END IF;
1693:

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

1740: FOR rec_asset IN c_asset LOOP
1741: fnd_message.set_name('JL', 'JL_CO_FA_ASSET_NOT_REVALUED');
1742: -- fnd_message.set_token('BOOK', P_book_type_code);
1743: fnd_message.set_token('ASSET_NUMBER', rec_asset.asset_number);
1744: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1745:
1746: x_count := x_count + 1;
1747: END LOOP;
1748: