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_MESSAGE

Line 186: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');

182: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
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);

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 189: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');

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');
193: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);

Line 190: fnd_message.set_token('BOOK', p_book);

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');
193: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);
194: fnd_file.put_line( 1, fnd_message.get);

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 192: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');

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, '----------------------------------------');
196: ---------------------------------------------------------

Line 193: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);

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, '----------------------------------------');
196: ---------------------------------------------------------
197: -- Find who_columns values --

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 410: fnd_message.set_name('JL', 'JL_CO_FA_APPR_MESG');

406: <>
407:
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

Line 411: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);

407:
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);

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 492: fnd_message.set_name('JL', 'JL_ZZ_FA_ASSET_RETIRED');

488: ---------------------------------------------------------
489:
490: IF (NVL(rec_asset.cost, 0) = 0) THEN
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',

Line 493: fnd_message.set_token('ASSET_NUMBER', rec_asset.asset_number);

489:
490: IF (NVL(rec_asset.cost, 0) = 0) THEN
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 => '');

Line 494: fnd_message.set_token('BOOK', p_book);

490: IF (NVL(rec_asset.cost, 0) = 0) THEN
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;

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 501: fnd_message.set_name('JL', 'JL_ZZ_FA_FUTURE_DATE');

497: message => '');
498: null;
499: /* ELSIF (rec_asset.date_placed_in_service > x_end_date) THEN
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',

Line 502: fnd_message.set_token('ASSET_NUMBER', rec_asset.asset_number);

498: null;
499: /* ELSIF (rec_asset.date_placed_in_service > x_end_date) THEN
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 => '');*/

Line 503: fnd_message.set_token('BOOK', p_book);

499: /* ELSIF (rec_asset.date_placed_in_service > x_end_date) THEN
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

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 1341: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_TAX_BOOK');

1337:
1338: EXCEPTION
1339:
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','');

Line 1342: fnd_message.set_token('BOOK', p_book);

1338: EXCEPTION
1339:
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: /*

Line 1343: err_msg := fnd_message.get;

1339:
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;

Line 1347: fnd_message.raise_error;

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: */
1349: WHEN JE_CAT_NOT_DEFINED THEN
1350: fnd_message.set_name('JL', 'JL_ZZ_FA_JE_CAT_NOT_DEFINED');
1351: fnd_message.set_token('BOOK', p_book);

Line 1350: fnd_message.set_name('JL', 'JL_ZZ_FA_JE_CAT_NOT_DEFINED');

1346: /*
1347: fnd_message.raise_error;
1348: */
1349: WHEN JE_CAT_NOT_DEFINED THEN
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);

Line 1351: fnd_message.set_token('BOOK', p_book);

1347: fnd_message.raise_error;
1348: */
1349: WHEN JE_CAT_NOT_DEFINED THEN
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','');

Line 1352: err_msg := fnd_message.get;

1348: */
1349: WHEN JE_CAT_NOT_DEFINED THEN
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: /*

Line 1357: fnd_message.raise_error;

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: */
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);

Line 1360: fnd_message.set_name('JL', 'JL_CO_FA_POSTING_NOT_ALLOWED');

1356: /*
1357: fnd_message.raise_error;
1358: */
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','');

Line 1361: fnd_message.set_token('BOOK', p_book);

1357: fnd_message.raise_error;
1358: */
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: /*

Line 1362: err_msg := fnd_message.get;

1358: */
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;

Line 1366: fnd_message.raise_error;

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: */
1368: /* WHEN DIFF_FISCAL_YEAR THEN
1369: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_FISCAL_YEAR');
1370: err_msg := fnd_message.get;

Line 1369: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_FISCAL_YEAR');

1365: /*
1366: fnd_message.raise_error;
1367: */
1368: /* WHEN DIFF_FISCAL_YEAR THEN
1369: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_FISCAL_YEAR');
1370: err_msg := fnd_message.get;
1371: app_exception.raise_exception (exception_type => 'APP',
1372: exception_code =>
1373: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_FA_INVALID_FISCAL_YEAR'),

Line 1370: err_msg := fnd_message.get;

1366: fnd_message.raise_error;
1367: */
1368: /* WHEN DIFF_FISCAL_YEAR THEN
1369: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_FISCAL_YEAR');
1370: err_msg := fnd_message.get;
1371: app_exception.raise_exception (exception_type => 'APP',
1372: exception_code =>
1373: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_FA_INVALID_FISCAL_YEAR'),
1374: exception_text => err_msg);

Line 1378: fnd_message.set_name('JL', 'JL_CO_FA_DEPRECIATION_STATUS');

1374: exception_text => err_msg);
1375: */
1376:
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','');

Line 1379: fnd_message.set_token('BOOK', p_book);

1375: */
1376:
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: /*

Line 1380: err_msg := fnd_message.get;

1376:
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;

Line 1384: fnd_message.raise_error;

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: */
1386: WHEN INVALID_CCID THEN
1387: SELECT LTRIM(RTRIM(segment1))||LTRIM(RTRIM(segment2))||
1388: LTRIM(RTRIM(segment3))||LTRIM(RTRIM(segment4))||

Line 1395: fnd_message.set_name('JL', 'JL_CO_FA_CCID_NOT_DEFINED');

1391: INTO x_category
1392: FROM fa_categories
1393: WHERE category_id = x_category_id;
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','');

Line 1396: fnd_message.set_token('CATEGORY', x_category);

1392: FROM fa_categories
1393: WHERE category_id = x_category_id;
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: /*

Line 1397: err_msg := fnd_message.get;

1393: WHERE category_id = x_category_id;
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;

Line 1401: fnd_message.raise_error;

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: */
1403:
1404: WHEN CCID_NOT_FOUND THEN
1405: SELECT LTRIM(RTRIM(segment1))||LTRIM(RTRIM(segment2))||

Line 1413: fnd_message.set_name('JL', 'JL_CO_FA_CCID_NOT_DEFINED');

1409: INTO x_category
1410: FROM fa_categories
1411: WHERE category_id = x_category_id;
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','');

Line 1414: fnd_message.set_token('CATEGORY', x_category);

1410: FROM fa_categories
1411: WHERE category_id = x_category_id;
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: /*

Line 1415: err_msg := fnd_message.get;

1411: WHERE category_id = x_category_id;
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;

Line 1419: fnd_message.raise_error;

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: */
1421:
1422: /* WHEN REVALUATION_RUN THEN
1423: fnd_message.set_name('JL', 'JL_CO_FA_REVALUATION_RUN');

Line 1423: fnd_message.set_name('JL', 'JL_CO_FA_REVALUATION_RUN');

1419: fnd_message.raise_error;
1420: */
1421:
1422: /* WHEN REVALUATION_RUN THEN
1423: fnd_message.set_name('JL', 'JL_CO_FA_REVALUATION_RUN');
1424: fnd_message.set_token('APPRAISAL_NUMBER', to_char(p_appraisal_id));
1425: fnd_message.set_token('BOOK', p_book);
1426: err_msg := fnd_message.get;
1427: app_exception.raise_exception (exception_type => 'APP',

Line 1424: fnd_message.set_token('APPRAISAL_NUMBER', to_char(p_appraisal_id));

1420: */
1421:
1422: /* WHEN REVALUATION_RUN THEN
1423: fnd_message.set_name('JL', 'JL_CO_FA_REVALUATION_RUN');
1424: fnd_message.set_token('APPRAISAL_NUMBER', to_char(p_appraisal_id));
1425: fnd_message.set_token('BOOK', p_book);
1426: err_msg := fnd_message.get;
1427: app_exception.raise_exception (exception_type => 'APP',
1428: exception_code =>

Line 1425: fnd_message.set_token('BOOK', p_book);

1421:
1422: /* WHEN REVALUATION_RUN THEN
1423: fnd_message.set_name('JL', 'JL_CO_FA_REVALUATION_RUN');
1424: fnd_message.set_token('APPRAISAL_NUMBER', to_char(p_appraisal_id));
1425: fnd_message.set_token('BOOK', p_book);
1426: err_msg := fnd_message.get;
1427: app_exception.raise_exception (exception_type => 'APP',
1428: exception_code =>
1429: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_FA_REVALUATION_RUN'),

Line 1426: err_msg := fnd_message.get;

1422: /* WHEN REVALUATION_RUN THEN
1423: fnd_message.set_name('JL', 'JL_CO_FA_REVALUATION_RUN');
1424: fnd_message.set_token('APPRAISAL_NUMBER', to_char(p_appraisal_id));
1425: fnd_message.set_token('BOOK', p_book);
1426: err_msg := fnd_message.get;
1427: app_exception.raise_exception (exception_type => 'APP',
1428: exception_code =>
1429: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_FA_REVALUATION_RUN'),
1430: exception_text => err_msg);

Line 1433: fnd_message.set_name('JL', 'JL_CO_FA_DIFFERENT_CURRENCY');

1429: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_FA_REVALUATION_RUN'),
1430: exception_text => err_msg);
1431: */
1432: WHEN INVALID_CURRENCY_CODE THEN
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);

Line 1434: fnd_message.set_token('APPRAISAL_NUMBER', to_char(p_appraisal_id));

1430: exception_text => err_msg);
1431: */
1432: WHEN INVALID_CURRENCY_CODE THEN
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','');

Line 1435: fnd_message.set_token('BOOK', p_book);

1431: */
1432: WHEN INVALID_CURRENCY_CODE THEN
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: /*

Line 1436: err_msg := fnd_message.get;

1432: WHEN INVALID_CURRENCY_CODE THEN
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;

Line 1440: fnd_message.raise_error;

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: */
1442:
1443: WHEN OTHERS THEN
1444: IF x_statement = 'BOOK_INFO' THEN

Line 1445: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

1441: */
1442:
1443: WHEN OTHERS THEN
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','');

Line 1446: fnd_message.set_token('NUMBER', '1');

1442:
1443: WHEN OTHERS THEN
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: /*

Line 1447: err_msg := fnd_message.get;

1443: WHEN OTHERS THEN
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;

Line 1451: fnd_message.raise_error;

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: */
1453:
1454: ELSIF x_statement = 'FLEX_INFO' THEN
1455: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

Line 1455: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

1451: fnd_message.raise_error;
1452: */
1453:
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','');

Line 1456: fnd_message.set_token('NUMBER', '2');

1452: */
1453:
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: /*

Line 1457: err_msg := fnd_message.get;

1453:
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;

Line 1461: fnd_message.raise_error;

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: */
1463:
1464: ELSIF x_statement = 'CURR_INFO' THEN
1465: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

Line 1465: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

1461: fnd_message.raise_error;
1462: */
1463:
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','');

Line 1466: fnd_message.set_token('NUMBER', '3');

1462: */
1463:
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: /*

Line 1467: err_msg := fnd_message.get;

1463:
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;

Line 1471: fnd_message.raise_error;

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: */
1473:
1474: ELSIF x_statement = 'ACCT_INFO' THEN
1475: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

Line 1475: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

1471: fnd_message.raise_error;
1472: */
1473:
1474: ELSIF x_statement = 'ACCT_INFO' THEN
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);

Line 1476: fnd_message.set_token('NUMBER', '4');

1472: */
1473:
1474: ELSIF x_statement = 'ACCT_INFO' THEN
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','');

Line 1477: err_msg := fnd_message.get;

1473:
1474: ELSIF x_statement = 'ACCT_INFO' THEN
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: /*

Line 1482: fnd_message.raise_error;

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: */
1484:
1485: ELSIF x_statement = 'COST_ACCT_INFO' THEN
1486: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

Line 1486: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

1482: fnd_message.raise_error;
1483: */
1484:
1485: ELSIF x_statement = 'COST_ACCT_INFO' THEN
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);

Line 1487: fnd_message.set_token('NUMBER', '5');

1483: */
1484:
1485: ELSIF x_statement = 'COST_ACCT_INFO' THEN
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','');

Line 1488: err_msg := fnd_message.get;

1484:
1485: ELSIF x_statement = 'COST_ACCT_INFO' THEN
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: /*

Line 1493: fnd_message.raise_error;

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: */
1495:
1496: ELSIF x_statement = 'INSERT_ADJ' THEN
1497: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

Line 1497: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

1493: fnd_message.raise_error;
1494: */
1495:
1496: ELSIF x_statement = 'INSERT_ADJ' THEN
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);

Line 1498: fnd_message.set_token('NUMBER', '6');

1494: */
1495:
1496: ELSIF x_statement = 'INSERT_ADJ' THEN
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','');

Line 1499: err_msg := fnd_message.get;

1495:
1496: ELSIF x_statement = 'INSERT_ADJ' THEN
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: /*

Line 1504: fnd_message.raise_error;

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: */
1506:
1507: ELSIF x_statement = 'PERIOD_INFO' THEN
1508: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

Line 1508: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

1504: fnd_message.raise_error;
1505: */
1506:
1507: ELSIF x_statement = 'PERIOD_INFO' THEN
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);

Line 1509: fnd_message.set_token('NUMBER', '7');

1505: */
1506:
1507: ELSIF x_statement = 'PERIOD_INFO' THEN
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','');

Line 1510: err_msg := fnd_message.get;

1506:
1507: ELSIF x_statement = 'PERIOD_INFO' THEN
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: /*

Line 1515: fnd_message.raise_error;

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: */
1517:
1518: ELSE
1519: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');

Line 1519: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');

1515: fnd_message.raise_error;
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;

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 1741: fnd_message.set_name('JL', 'JL_CO_FA_ASSET_NOT_REVALUED');

1737:
1738: BEGIN
1739:
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:

Line 1742: -- fnd_message.set_token('BOOK', P_book_type_code);

1738: BEGIN
1739:
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;

Line 1743: fnd_message.set_token('ASSET_NUMBER', rec_asset.asset_number);

1739:
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;

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: