DBA Data[Home] [Help]

APPS.JL_CO_FA_POST_PKG dependencies on FND_MESSAGE

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

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

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

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

Line 129: fnd_message.set_name('JL', 'JL_CO_FA_BOOK');

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:

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

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

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

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

Line 229: fnd_message.set_name ('JL', 'JL_ZZ_FA_PERIOD_NAME');

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

Line 230: fnd_message.set_token ('PERIOD_NAME', x_period_name);

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

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

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

Line 284: fnd_message.set_name('JL', 'JL_CO_FA_JE_CATEGORY');

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

Line 285: fnd_message.set_token('JE_CATEGORY', rec_category.user_je_category_name);

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

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

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

Line 442: fnd_message.set_name('JL', 'JL_CO_FA_PERIOD_NOT_DEFINED');

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

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

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

Line 444: -- err_msg := fnd_message.get;

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',

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

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 =>

Line 455: fnd_message.set_name('JL', 'JL_CO_FA_SAME_AS_PERIOD_CLOSED');

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

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

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

Line 457: fnd_message.set_token('PERIOD', x_period_name);

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

Line 458: -- err_msg := fnd_message.get;

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',

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

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 =>

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

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;

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

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

Line 472: -- err_msg := fnd_message.get;

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

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

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',

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

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;

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

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

Line 486: -- err_msg := fnd_message.get;

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

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

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',

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

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;

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

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

Line 500: -- err_msg := fnd_message.get;

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

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

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',

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

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;

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

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