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);
444:
445: EXCEPTION
446:
447: WHEN PERIOD_NOT_DEFINED THEN
448: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
449: fnd_message.set_token('BOOK', p_book);
450: -- err_msg := fnd_message.get;
451: fnd_file.put_line (fnd_file.log, fnd_message.get);
452: call_status := fnd_concurrent.set_completion_status('ERROR','');
445: EXCEPTION
446:
447: WHEN PERIOD_NOT_DEFINED THEN
448: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
449: fnd_message.set_token('BOOK', p_book);
450: -- err_msg := fnd_message.get;
451: fnd_file.put_line (fnd_file.log, fnd_message.get);
452: call_status := fnd_concurrent.set_completion_status('ERROR','');
453: /*
446:
447: WHEN PERIOD_NOT_DEFINED THEN
448: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
449: fnd_message.set_token('BOOK', p_book);
450: -- err_msg := fnd_message.get;
451: fnd_file.put_line (fnd_file.log, fnd_message.get);
452: call_status := fnd_concurrent.set_completion_status('ERROR','');
453: /*
454: app_exception.raise_exception (exception_type => 'APP',
447: WHEN PERIOD_NOT_DEFINED THEN
448: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');
449: fnd_message.set_token('BOOK', p_book);
450: -- err_msg := fnd_message.get;
451: fnd_file.put_line (fnd_file.log, fnd_message.get);
452: call_status := fnd_concurrent.set_completion_status('ERROR','');
453: /*
454: app_exception.raise_exception (exception_type => 'APP',
455: exception_code =>
457: exception_text => err_msg);
458: */
459:
460: WHEN SAME_AS_PERIOD_CLOSED THEN
461: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
462: fnd_message.set_token('BOOK', p_book);
463: fnd_message.set_token('PERIOD', x_period_name);
464: -- err_msg := fnd_message.get;
465: fnd_file.put_line (fnd_file.log, fnd_message.get);
458: */
459:
460: WHEN SAME_AS_PERIOD_CLOSED THEN
461: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
462: fnd_message.set_token('BOOK', p_book);
463: fnd_message.set_token('PERIOD', x_period_name);
464: -- err_msg := fnd_message.get;
465: fnd_file.put_line (fnd_file.log, fnd_message.get);
466: call_status := fnd_concurrent.set_completion_status('ERROR','');
459:
460: WHEN SAME_AS_PERIOD_CLOSED THEN
461: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
462: fnd_message.set_token('BOOK', p_book);
463: fnd_message.set_token('PERIOD', x_period_name);
464: -- err_msg := fnd_message.get;
465: fnd_file.put_line (fnd_file.log, fnd_message.get);
466: call_status := fnd_concurrent.set_completion_status('ERROR','');
467: /*
460: WHEN SAME_AS_PERIOD_CLOSED THEN
461: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
462: fnd_message.set_token('BOOK', p_book);
463: fnd_message.set_token('PERIOD', x_period_name);
464: -- err_msg := fnd_message.get;
465: fnd_file.put_line (fnd_file.log, fnd_message.get);
466: call_status := fnd_concurrent.set_completion_status('ERROR','');
467: /*
468: app_exception.raise_exception (exception_type => 'APP',
461: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');
462: fnd_message.set_token('BOOK', p_book);
463: fnd_message.set_token('PERIOD', x_period_name);
464: -- err_msg := fnd_message.get;
465: fnd_file.put_line (fnd_file.log, fnd_message.get);
466: call_status := fnd_concurrent.set_completion_status('ERROR','');
467: /*
468: app_exception.raise_exception (exception_type => 'APP',
469: exception_code =>
472: */
473:
474: WHEN OTHERS THEN
475: IF x_statement = 'BOOK_INFO' THEN
476: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
477: fnd_message.set_token('NUMBER', '1');
478: -- err_msg := fnd_message.get;
479: fnd_file.put_line (fnd_file.log, fnd_message.get);
480: ROLLBACK;
473:
474: WHEN OTHERS THEN
475: IF x_statement = 'BOOK_INFO' THEN
476: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
477: fnd_message.set_token('NUMBER', '1');
478: -- err_msg := fnd_message.get;
479: fnd_file.put_line (fnd_file.log, fnd_message.get);
480: ROLLBACK;
481: call_status := fnd_concurrent.set_completion_status('ERROR','');
474: WHEN OTHERS THEN
475: IF x_statement = 'BOOK_INFO' THEN
476: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
477: fnd_message.set_token('NUMBER', '1');
478: -- err_msg := fnd_message.get;
479: fnd_file.put_line (fnd_file.log, fnd_message.get);
480: ROLLBACK;
481: call_status := fnd_concurrent.set_completion_status('ERROR','');
482: /*
475: IF x_statement = 'BOOK_INFO' THEN
476: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
477: fnd_message.set_token('NUMBER', '1');
478: -- err_msg := fnd_message.get;
479: fnd_file.put_line (fnd_file.log, fnd_message.get);
480: ROLLBACK;
481: call_status := fnd_concurrent.set_completion_status('ERROR','');
482: /*
483: app_exception.raise_exception (exception_type => 'APP',
486: exception_text => err_msg);
487: */
488:
489: ELSIF x_statement = 'CURR_INFO' THEN
490: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
491: fnd_message.set_token('NUMBER', '2');
492: -- err_msg := fnd_message.get;
493: fnd_file.put_line (fnd_file.log, fnd_message.get);
494: ROLLBACK;
487: */
488:
489: ELSIF x_statement = 'CURR_INFO' THEN
490: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
491: fnd_message.set_token('NUMBER', '2');
492: -- err_msg := fnd_message.get;
493: fnd_file.put_line (fnd_file.log, fnd_message.get);
494: ROLLBACK;
495: call_status := fnd_concurrent.set_completion_status('ERROR','');
488:
489: ELSIF x_statement = 'CURR_INFO' THEN
490: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
491: fnd_message.set_token('NUMBER', '2');
492: -- err_msg := fnd_message.get;
493: fnd_file.put_line (fnd_file.log, fnd_message.get);
494: ROLLBACK;
495: call_status := fnd_concurrent.set_completion_status('ERROR','');
496: /*
489: ELSIF x_statement = 'CURR_INFO' THEN
490: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
491: fnd_message.set_token('NUMBER', '2');
492: -- err_msg := fnd_message.get;
493: fnd_file.put_line (fnd_file.log, fnd_message.get);
494: ROLLBACK;
495: call_status := fnd_concurrent.set_completion_status('ERROR','');
496: /*
497: app_exception.raise_exception (exception_type => 'APP',
500: exception_text => err_msg);
501: */
502:
503: ELSIF x_statement = 'CAL_INFO' THEN
504: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
505: fnd_message.set_token('NUMBER', '3');
506: -- err_msg := fnd_message.get;
507: fnd_file.put_line (fnd_file.log, fnd_message.get);
508: ROLLBACK;
501: */
502:
503: ELSIF x_statement = 'CAL_INFO' THEN
504: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
505: fnd_message.set_token('NUMBER', '3');
506: -- err_msg := fnd_message.get;
507: fnd_file.put_line (fnd_file.log, fnd_message.get);
508: ROLLBACK;
509: call_status := fnd_concurrent.set_completion_status('ERROR','');
502:
503: ELSIF x_statement = 'CAL_INFO' THEN
504: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
505: fnd_message.set_token('NUMBER', '3');
506: -- err_msg := fnd_message.get;
507: fnd_file.put_line (fnd_file.log, fnd_message.get);
508: ROLLBACK;
509: call_status := fnd_concurrent.set_completion_status('ERROR','');
510: /*
503: ELSIF x_statement = 'CAL_INFO' THEN
504: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
505: fnd_message.set_token('NUMBER', '3');
506: -- err_msg := fnd_message.get;
507: fnd_file.put_line (fnd_file.log, fnd_message.get);
508: ROLLBACK;
509: call_status := fnd_concurrent.set_completion_status('ERROR','');
510: /*
511: app_exception.raise_exception (exception_type => 'APP',
514: exception_text => err_msg);
515: */
516:
517: ELSE
518: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
519: fnd_file.put_line( fnd_file.log, fnd_message.get);
520: err_num := SQLCODE;
521: err_msg := substr(SQLERRM, 1, 200);
522: ROLLBACK;
515: */
516:
517: ELSE
518: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
519: fnd_file.put_line( fnd_file.log, fnd_message.get);
520: err_num := SQLCODE;
521: err_msg := substr(SQLERRM, 1, 200);
522: ROLLBACK;
523: RAISE_APPLICATION_ERROR( err_num, err_msg);