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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;

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

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

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

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

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

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

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

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;

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

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

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

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

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

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

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

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;

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

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

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

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

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

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

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

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;

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

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