You will not need seq_audit_id_audit_upload_log.NEXTVAL; instead declare column AUL_UPLOAD_ID as IDENTITY
CREATE PROCEDURE SQL_Procedure
@AUL_SLA_CATEORY NVARCHAR(255),
@AUL_FROM_DATE DATETIME,
@AUL_TO_DATE DATETIME,
@AUL_USER_FILE_NAME NVARCHAR(255),
@AUL_SAVED_FILE_NAME NVARCHAR(255),
@AUL_UPLOADED_BY NVARCHAR(255)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO audit_upload_log
(AUL_SLA_CATEORY,AUL_FROM_DATE,AUL_TO_DATE,AUL_USER_FILE_NAME,AUL_SAVED_FILE_NAME,AUL_UPLOADED_DATE,AUL_UPLOADED_BY)
VALUES (@AUL_SLA_CATEORY, @AUL_FROM_DATE, @AUL_TO_DATE, @AUL_USER_FILE_NAME , @AUL_SAVED_FILE_NAME, GETDATE(), @AUL_UPLOADED_BY)
END
code block added