633: l_set_value_present VARCHAR2(1) := 'N';
634: request_failed EXCEPTION;
635: CURSOR get_nls_date_format IS
636: SELECT VALUE
637: FROM v$nls_parameters
638: WHERE parameter = 'NLS_DATE_FORMAT';
639: l_nls_date_format v$nls_parameters.VALUE%TYPE;
640: BEGIN
641: IF (G_DEBUG_ENABLED = 'Y') THEN
635: CURSOR get_nls_date_format IS
636: SELECT VALUE
637: FROM v$nls_parameters
638: WHERE parameter = 'NLS_DATE_FORMAT';
639: l_nls_date_format v$nls_parameters.VALUE%TYPE;
640: BEGIN
641: IF (G_DEBUG_ENABLED = 'Y') THEN
642: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
643: END IF;