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
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);
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
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(
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', '<
368:
369: p_request_id := fnd_request.submit_request(
370: application => 'GCS',
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
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', '<
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;
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', '<
385:
386: END;
387: