/****************************************************
AUTHOR NAME : PABITRA BEHERA
OBJECTIVE : GET EMPLOYEE RELATED DATA BY SELECTION
CREATED DATE: 17 NOVEMBER 2017
MODIFY DATE : 17 NOVEMBER 2017
MODIFY RESON:
****************************************************
*/
CREATE PROCEDURE [dbo].[USP_GET_SELECTION_DATA]
(
@Action VARCHAR(50)=NULL,
@Emp_Code VARCHAR(8)=NULL,
@Emp_Name VARCHAR(70)=NULL,
@message VARCHAR(100)=NULL OUT
)
AS
BEGIN
SET NOCOUNT ON;
--DECLARE @ERROR_COUNT INT
--SET @ERROR_COUNT=0;
BEGIN TRAN GET_EMP_DATA
--*********BEGIN TRY
BEGIN TRY
BEGIN
--*****************************
---EXISTS Employee Code OR Not
IF(@Action='EXIST_EMPLOYEE')
BEGIN
SELECT Emp_Code FROM Mst_Employee WHERE Emp_Code=@Emp_Code;
--IF(@@ERROR<>0)
--SET @ERROR_COUNT=100;
END
COMMIT TRAN GET_EMP_DATA
--********* COMMIT TRAN
END
END TRY
--*********END TRY
BEGIN CATCH
IF XACT_STATE() <> 0
BEGIN
--******ROLLBACK TRAN
ROLLBACK TRAN GET_EMP_DATA
--******ROLLBACK TRAN
END
END CATCH
END
No comments:
Post a Comment