DBA Data[Home] [Help]

APPS.GCS_CREATE_DYN_INDEX_PKG dependencies on FND_LOG

Line 193: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;

189: l_sys_option NUMBER;
190: l_epb_table VARCHAR2(30);
191:
192: -- Store the log level
193: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
194: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
195: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
196:
197: -- Bugfix 5498824: Status of EPB Code Generation

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

190: l_epb_table VARCHAR2(30);
191:
192: -- Store the log level
193: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
194: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
195: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
196:
197: -- Bugfix 5498824: Status of EPB Code Generation
198: l_status_code VARCHAR2(30);

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

191:
192: -- Store the log level
193: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
194: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
195: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
196:
197: -- Bugfix 5498824: Status of EPB Code Generation
198: l_status_code VARCHAR2(30);
199: BEGIN

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

361: PROCEDURE submit_request (p_request_id OUT NOCOPY NUMBER) IS
362:
363: BEGIN
364:
365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
366: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.begin', '<>');
367: END IF;
368:
369: p_request_id := fnd_request.submit_request(

Line 366: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.begin', '<>');

362:
363: BEGIN
364:
365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
366: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.begin', '<>');
367: END IF;
368:
369: p_request_id := fnd_request.submit_request(
370: application => 'GCS',

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

374: --Bugfix 4333250: Add commit in order for request to be submitted
375:
376: COMMIT;
377:
378: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request', 'Submitted Request ID : ' || p_request_id);
380: END IF;
381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request', 'Submitted Request ID : ' || p_request_id);

375:
376: COMMIT;
377:
378: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request', 'Submitted Request ID : ' || p_request_id);
380: END IF;
381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.end', '<>');

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

378: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request', 'Submitted Request ID : ' || p_request_id);
380: END IF;
381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.end', '<>');
384: END IF;
385:
386: END;

Line 383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.end', '<>');

379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request', 'Submitted Request ID : ' || p_request_id);
380: END IF;
381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'gcs.plsql.GCS_CREATE_DYN_INDEX_PKG.submit_request.end', '<>');
384: END IF;
385:
386: END;
387: