DBA Data[Home] [Help]

APPS.GCS_BUILD_EPB_DIM_TR_PKG dependencies on FND_LOG

Line 91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

87: l_cat_value_setid NUMBER;
88:
89: BEGIN
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
93: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIM_TR_PKG' ||
94: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
95: END IF;

Line 92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',

88:
89: BEGIN
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
93: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIM_TR_PKG' ||
94: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
95: END IF;
96: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 333: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;

329:
330:
331: /* $Header: gcsdimtrb.pls 120.2 2006/06/09 17:48:36 skamdar noship $ */
332: -- Store the log level
333: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
334: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
335: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
336: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
337: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;

Line 334: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;

330:
331: /* $Header: gcsdimtrb.pls 120.2 2006/06/09 17:48:36 skamdar noship $ */
332: -- Store the log level
333: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
334: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
335: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
336: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
337: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
338: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;

Line 335: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;

331: /* $Header: gcsdimtrb.pls 120.2 2006/06/09 17:48:36 skamdar noship $ */
332: -- Store the log level
333: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
334: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
335: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
336: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
337: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
338: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
339:

Line 336: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;

332: -- Store the log level
333: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
334: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
335: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
336: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
337: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
338: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
339:
340: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;

Line 337: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;

333: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
334: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
335: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
336: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
337: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
338: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
339:
340: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
341:

Line 338: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;

334: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
335: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
336: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
337: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
338: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
339:
340: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
341:
342: DIM_LOAD_ERROR EXCEPTION;

Line 359: runtimeLogLevel := FND_LOG.g_current_runtime_level;

355: module VARCHAR2(30) := ''GCS_EPB_TR_DIM'';
356:
357: BEGIN
358:
359: runtimeLogLevel := FND_LOG.g_current_runtime_level;
360:
361: IF (procedureloglevel >= runtimeloglevel ) THEN
362: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_dim_tr_pkg.gcs_epb_tr_dim.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
363: END IF;

Line 362: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_dim_tr_pkg.gcs_epb_tr_dim.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));

358:
359: runtimeLogLevel := FND_LOG.g_current_runtime_level;
360:
361: IF (procedureloglevel >= runtimeloglevel ) THEN
362: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_dim_tr_pkg.gcs_epb_tr_dim.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
363: END IF;
364:
365: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Dim'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
366:

Line 782: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DIM_TR_PKG.GCS_EPB_TR_DIM'', ''GCS_NO_DATA_FOUND'');

778: EXCEPTION
779:
780: WHEN NO_DATA_FOUND THEN
781: IF (unexpectedloglevel >= runtimeloglevel ) THEN
782: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DIM_TR_PKG.GCS_EPB_TR_DIM'', ''GCS_NO_DATA_FOUND'');
783: END IF;
784: retcode := ''0'';
785: errbuf := ''GCS_NO_DATA_FOUND'';
786: RAISE NO_DATA_FOUND;

Line 790: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DIM_TR_PKG.GCS_EPB_TR_DIM'', ''GCS_DIM_LOAD_ERROR'');

786: RAISE NO_DATA_FOUND;
787:
788: WHEN DIM_LOAD_ERROR THEN
789: IF (unexpectedloglevel >= runtimeloglevel ) THEN
790: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DIM_TR_PKG.GCS_EPB_TR_DIM'', ''GCS_DIM_LOAD_ERROR'');
791: END IF;
792: retcode := ''0'';
793: FND_FILE.PUT_LINE(FND_FILE.LOG, '' Dimension Load Error - '' || errbuf );
794: RAISE;

Line 799: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DIM_TR_PKG.GCS_EPB_TR_DIM'', errbuf);

795:
796: WHEN OTHERS THEN
797: errbuf := substr( SQLERRM, 1, 2000);
798: IF (unexpectedloglevel >= runtimeloglevel ) THEN
799: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DIM_TR_PKG.GCS_EPB_TR_DIM'', errbuf);
800: END IF;
801: retcode := ''0'';
802: RAISE;
803:

Line 821: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

817: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', 'GCS_DYN_EPB_DIMTR_PKG',1, r - 1, 'FALSE', err);
818:
819: -- dbms_output.put_line('Error' || AD_DDL.error_buf);
820:
821: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIMTR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
823: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' ||
824: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
825: END IF;

Line 822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIMTR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',

818:
819: -- dbms_output.put_line('Error' || AD_DDL.error_buf);
820:
821: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIMTR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
823: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' ||
824: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
825: END IF;
826: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

826: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
832: 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
833: SUBSTR(SQLERRM, 1, 255));
834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 831: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
832: 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
833: SUBSTR(SQLERRM, 1, 255));
834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
835: 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',

Line 834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
832: 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
833: SUBSTR(SQLERRM, 1, 255));
834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
835: 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
836: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DIMTR_PKG' ||
837: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
838: END IF;