122: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
123: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
124: END IF;
125:
126: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
123: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
124: END IF;
125:
126: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
131: fnd_file.put_line( 1, fnd_message.get);
125:
126: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
131: fnd_file.put_line( 1, fnd_message.get);
132: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
133:
126: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
131: fnd_file.put_line( 1, fnd_message.get);
132: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
133:
134: ---------------------------------------------------------
127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
128: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');
130: fnd_message.set_token('BOOK', p_book);
131: fnd_file.put_line( 1, fnd_message.get);
132: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
133:
134: ---------------------------------------------------------
135: -- Find who_columns values --
225: -----------------------------------------------------------------------------
226: -- Write close globalization period name on log file --
227: -----------------------------------------------------------------------------
228:
229: fnd_message.set_name ('JL', 'JL_ZZ_FA_PERIOD_NAME');
230: fnd_message.set_token ('PERIOD_NAME', x_period_name);
231: fnd_file.put_line (1, fnd_message.get);
232:
233: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
226: -- Write close globalization period name on log file --
227: -----------------------------------------------------------------------------
228:
229: fnd_message.set_name ('JL', 'JL_ZZ_FA_PERIOD_NAME');
230: fnd_message.set_token ('PERIOD_NAME', x_period_name);
231: fnd_file.put_line (1, fnd_message.get);
232:
233: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
234: fnd_file.put_line( 1, 'Period Name :'||x_period_name);
227: -----------------------------------------------------------------------------
228:
229: fnd_message.set_name ('JL', 'JL_ZZ_FA_PERIOD_NAME');
230: fnd_message.set_token ('PERIOD_NAME', x_period_name);
231: fnd_file.put_line (1, fnd_message.get);
232:
233: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
234: fnd_file.put_line( 1, 'Period Name :'||x_period_name);
235: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Period Name :'||x_period_name);
280: ---------------------------------------------------------
281:
282: FOR rec_category IN c_category LOOP
283:
284: fnd_message.set_name('JL', 'JL_CO_FA_JE_CATEGORY');
285: fnd_message.set_token('JE_CATEGORY', rec_category.user_je_category_name);
286: fnd_file.put_line( 1, fnd_message.get);
287:
288: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
281:
282: FOR rec_category IN c_category LOOP
283:
284: fnd_message.set_name('JL', 'JL_CO_FA_JE_CATEGORY');
285: fnd_message.set_token('JE_CATEGORY', rec_category.user_je_category_name);
286: fnd_file.put_line( 1, fnd_message.get);
287:
288: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
289: fnd_file.put_line( 1, 'Je category name :'||rec_category.je_category_name);
282: FOR rec_category IN c_category LOOP
283:
284: fnd_message.set_name('JL', 'JL_CO_FA_JE_CATEGORY');
285: fnd_message.set_token('JE_CATEGORY', rec_category.user_je_category_name);
286: fnd_file.put_line( 1, fnd_message.get);
287:
288: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
289: fnd_file.put_line( 1, 'Je category name :'||rec_category.je_category_name);
290: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Je category name :'||rec_category.je_category_name);
438:
439: EXCEPTION
440:
441: WHEN PERIOD_NOT_DEFINED THEN
442: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
443: fnd_message.set_token('BOOK', p_book);
444: -- err_msg := fnd_message.get;
445: fnd_file.put_line (fnd_file.log, fnd_message.get);
446: call_status := fnd_concurrent.set_completion_status('ERROR','');
439: EXCEPTION
440:
441: WHEN PERIOD_NOT_DEFINED THEN
442: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
443: fnd_message.set_token('BOOK', p_book);
444: -- err_msg := fnd_message.get;
445: fnd_file.put_line (fnd_file.log, fnd_message.get);
446: call_status := fnd_concurrent.set_completion_status('ERROR','');
447: /*
440:
441: WHEN PERIOD_NOT_DEFINED THEN
442: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
443: fnd_message.set_token('BOOK', p_book);
444: -- err_msg := fnd_message.get;
445: fnd_file.put_line (fnd_file.log, fnd_message.get);
446: call_status := fnd_concurrent.set_completion_status('ERROR','');
447: /*
448: app_exception.raise_exception (exception_type => 'APP',
441: WHEN PERIOD_NOT_DEFINED THEN
442: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
443: fnd_message.set_token('BOOK', p_book);
444: -- err_msg := fnd_message.get;
445: fnd_file.put_line (fnd_file.log, fnd_message.get);
446: call_status := fnd_concurrent.set_completion_status('ERROR','');
447: /*
448: app_exception.raise_exception (exception_type => 'APP',
449: exception_code =>
451: exception_text => err_msg);
452: */
453:
454: WHEN SAME_AS_PERIOD_CLOSED THEN
455: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
456: fnd_message.set_token('BOOK', p_book);
457: fnd_message.set_token('PERIOD', x_period_name);
458: -- err_msg := fnd_message.get;
459: fnd_file.put_line (fnd_file.log, fnd_message.get);
452: */
453:
454: WHEN SAME_AS_PERIOD_CLOSED THEN
455: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
456: fnd_message.set_token('BOOK', p_book);
457: fnd_message.set_token('PERIOD', x_period_name);
458: -- err_msg := fnd_message.get;
459: fnd_file.put_line (fnd_file.log, fnd_message.get);
460: call_status := fnd_concurrent.set_completion_status('ERROR','');
453:
454: WHEN SAME_AS_PERIOD_CLOSED THEN
455: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
456: fnd_message.set_token('BOOK', p_book);
457: fnd_message.set_token('PERIOD', x_period_name);
458: -- err_msg := fnd_message.get;
459: fnd_file.put_line (fnd_file.log, fnd_message.get);
460: call_status := fnd_concurrent.set_completion_status('ERROR','');
461: /*
454: WHEN SAME_AS_PERIOD_CLOSED THEN
455: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
456: fnd_message.set_token('BOOK', p_book);
457: fnd_message.set_token('PERIOD', x_period_name);
458: -- err_msg := fnd_message.get;
459: fnd_file.put_line (fnd_file.log, fnd_message.get);
460: call_status := fnd_concurrent.set_completion_status('ERROR','');
461: /*
462: app_exception.raise_exception (exception_type => 'APP',
455: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
456: fnd_message.set_token('BOOK', p_book);
457: fnd_message.set_token('PERIOD', x_period_name);
458: -- err_msg := fnd_message.get;
459: fnd_file.put_line (fnd_file.log, fnd_message.get);
460: call_status := fnd_concurrent.set_completion_status('ERROR','');
461: /*
462: app_exception.raise_exception (exception_type => 'APP',
463: exception_code =>
466: */
467:
468: WHEN OTHERS THEN
469: IF x_statement = 'BOOK_INFO' THEN
470: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
471: fnd_message.set_token('NUMBER', '1');
472: -- err_msg := fnd_message.get;
473: fnd_file.put_line (fnd_file.log, fnd_message.get);
474: ROLLBACK;
467:
468: WHEN OTHERS THEN
469: IF x_statement = 'BOOK_INFO' THEN
470: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
471: fnd_message.set_token('NUMBER', '1');
472: -- err_msg := fnd_message.get;
473: fnd_file.put_line (fnd_file.log, fnd_message.get);
474: ROLLBACK;
475: call_status := fnd_concurrent.set_completion_status('ERROR','');
468: WHEN OTHERS THEN
469: IF x_statement = 'BOOK_INFO' THEN
470: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
471: fnd_message.set_token('NUMBER', '1');
472: -- err_msg := fnd_message.get;
473: fnd_file.put_line (fnd_file.log, fnd_message.get);
474: ROLLBACK;
475: call_status := fnd_concurrent.set_completion_status('ERROR','');
476: /*
469: IF x_statement = 'BOOK_INFO' THEN
470: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
471: fnd_message.set_token('NUMBER', '1');
472: -- err_msg := fnd_message.get;
473: fnd_file.put_line (fnd_file.log, fnd_message.get);
474: ROLLBACK;
475: call_status := fnd_concurrent.set_completion_status('ERROR','');
476: /*
477: app_exception.raise_exception (exception_type => 'APP',
480: exception_text => err_msg);
481: */
482:
483: ELSIF x_statement = 'CURR_INFO' THEN
484: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
485: fnd_message.set_token('NUMBER', '2');
486: -- err_msg := fnd_message.get;
487: fnd_file.put_line (fnd_file.log, fnd_message.get);
488: ROLLBACK;
481: */
482:
483: ELSIF x_statement = 'CURR_INFO' THEN
484: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
485: fnd_message.set_token('NUMBER', '2');
486: -- err_msg := fnd_message.get;
487: fnd_file.put_line (fnd_file.log, fnd_message.get);
488: ROLLBACK;
489: call_status := fnd_concurrent.set_completion_status('ERROR','');
482:
483: ELSIF x_statement = 'CURR_INFO' THEN
484: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
485: fnd_message.set_token('NUMBER', '2');
486: -- err_msg := fnd_message.get;
487: fnd_file.put_line (fnd_file.log, fnd_message.get);
488: ROLLBACK;
489: call_status := fnd_concurrent.set_completion_status('ERROR','');
490: /*
483: ELSIF x_statement = 'CURR_INFO' THEN
484: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
485: fnd_message.set_token('NUMBER', '2');
486: -- err_msg := fnd_message.get;
487: fnd_file.put_line (fnd_file.log, fnd_message.get);
488: ROLLBACK;
489: call_status := fnd_concurrent.set_completion_status('ERROR','');
490: /*
491: app_exception.raise_exception (exception_type => 'APP',
494: exception_text => err_msg);
495: */
496:
497: ELSIF x_statement = 'CAL_INFO' THEN
498: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
499: fnd_message.set_token('NUMBER', '3');
500: -- err_msg := fnd_message.get;
501: fnd_file.put_line (fnd_file.log, fnd_message.get);
502: ROLLBACK;
495: */
496:
497: ELSIF x_statement = 'CAL_INFO' THEN
498: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
499: fnd_message.set_token('NUMBER', '3');
500: -- err_msg := fnd_message.get;
501: fnd_file.put_line (fnd_file.log, fnd_message.get);
502: ROLLBACK;
503: call_status := fnd_concurrent.set_completion_status('ERROR','');
496:
497: ELSIF x_statement = 'CAL_INFO' THEN
498: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
499: fnd_message.set_token('NUMBER', '3');
500: -- err_msg := fnd_message.get;
501: fnd_file.put_line (fnd_file.log, fnd_message.get);
502: ROLLBACK;
503: call_status := fnd_concurrent.set_completion_status('ERROR','');
504: /*
497: ELSIF x_statement = 'CAL_INFO' THEN
498: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
499: fnd_message.set_token('NUMBER', '3');
500: -- err_msg := fnd_message.get;
501: fnd_file.put_line (fnd_file.log, fnd_message.get);
502: ROLLBACK;
503: call_status := fnd_concurrent.set_completion_status('ERROR','');
504: /*
505: app_exception.raise_exception (exception_type => 'APP',
508: exception_text => err_msg);
509: */
510:
511: ELSE
512: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
513: fnd_file.put_line( fnd_file.log, fnd_message.get);
514: err_num := SQLCODE;
515: err_msg := substr(SQLERRM, 1, 200);
516: ROLLBACK;
509: */
510:
511: ELSE
512: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
513: fnd_file.put_line( fnd_file.log, fnd_message.get);
514: err_num := SQLCODE;
515: err_msg := substr(SQLERRM, 1, 200);
516: ROLLBACK;
517: RAISE_APPLICATION_ERROR( err_num, err_msg);