Log File Initialized... 3/31/2024 6:20:58 AM
3/31/2024 6:20:58 AM: Executing Procedure HCM.UPDATE_EMP_CALENDAR_T params: 
3/31/2024 6:20:58 AM: @P_ORG_ID=4
3/31/2024 6:20:58 AM: @P_EMPLOYEE_ID=54
3/31/2024 6:20:58 AM: @P_CAL_YEAR=2024
3/31/2024 6:20:58 AM: ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at ZealERP.ZealFramework.Utils.DB.SelectProc_Dataset(String SpName, OracleParameter[] param)
   at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters)
3/31/2024 6:20:58 AM: ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
   at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters)
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.AfterSaveAndCommit(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.<SaveDataSecure>b__0()
3/31/2024 6:22:16 AM: Employee number 'ZS035' already exist
ZealERP.ZealFramework.Utils.ZealException: Employee number 'ZS035' already exist
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.ValidateEmployeeNumber(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.BeforeSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
3/31/2024 6:22:16 AM: Error.. Employee number 'ZS035' already exist
ZealERP.ZealFramework.Utils.ZealException: Error.. Employee number 'ZS035' already exist
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.<SaveDataSecure>b__0()
3/31/2024 6:23:18 AM: Employee number 'ZS035' already exist
ZealERP.ZealFramework.Utils.ZealException: Employee number 'ZS035' already exist
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.ValidateEmployeeNumber(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.BeforeSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
3/31/2024 6:23:18 AM: Error.. Employee number 'ZS035' already exist
ZealERP.ZealFramework.Utils.ZealException: Error.. Employee number 'ZS035' already exist
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.<SaveDataSecure>b__0()
3/31/2024 6:26:32 AM: No post available at this position
ZealERP.ZealFramework.Utils.ZealException: No post available at this position
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployeeAssignment.ValidatePosition(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployeeAssignment.BeforeSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
3/31/2024 6:26:32 AM: Error.. No post available at this position
ZealERP.ZealFramework.Utils.ZealException: Error.. No post available at this position
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.<SaveDataSecure>b__0()
3/31/2024 6:50:24 AM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TaskDataExtractReport.TaskDataExtract.PrepareReport()
3/31/2024 11:29:07 AM: Executing Procedure HCM.UPDATE_EMP_CALENDAR_T params: 
3/31/2024 11:29:07 AM: @P_ORG_ID=5
3/31/2024 11:29:07 AM: @P_EMPLOYEE_ID=55
3/31/2024 11:29:07 AM: @P_CAL_YEAR=2024
3/31/2024 11:29:07 AM: ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at ZealERP.ZealFramework.Utils.DB.SelectProc_Dataset(String SpName, OracleParameter[] param)
   at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters)
3/31/2024 11:29:07 AM: ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
   at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters)
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.AfterSaveAndCommit(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.<SaveDataSecure>b__0()
3/31/2024 11:30:52 AM: Employee number 'ZP020' already exist
ZealERP.ZealFramework.Utils.ZealException: Employee number 'ZP020' already exist
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.ValidateEmployeeNumber(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.BeforeSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
3/31/2024 11:30:52 AM: Error.. Employee number 'ZP020' already exist
ZealERP.ZealFramework.Utils.ZealException: Error.. Employee number 'ZP020' already exist
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.<SaveDataSecure>b__0()
3/31/2024 11:38:53 AM: Executing Procedure HCM.UPDATE_EMP_CALENDAR_T params: 
3/31/2024 11:38:53 AM: @P_ORG_ID=5
3/31/2024 11:38:53 AM: @P_EMPLOYEE_ID=56
3/31/2024 11:38:53 AM: @P_CAL_YEAR=2024
3/31/2024 11:38:53 AM: ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at ZealERP.ZealFramework.Utils.DB.SelectProc_Dataset(String SpName, OracleParameter[] param)
   at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters)
3/31/2024 11:38:53 AM: ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-20001: ORA-01403: no data found
ORA-06512: at "HCM.UPDATE_EMP_CALENDAR_T", line 64
ORA-06512: at line 1
   at ZealERP.ZealFramework.Utils.DB.ExecuteSP(String procedureName, OracleParameter[] oracleParameters)
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployee.AfterSaveAndCommit(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.<SaveDataSecure>b__0()
3/31/2024 11:40:10 AM: No post available at this position
ZealERP.ZealFramework.Utils.ZealException: No post available at this position
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployeeAssignment.ValidatePosition(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealTakaful.Services.DBServiceChildEmployeeAssignment.BeforeSave(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
3/31/2024 11:40:10 AM: Error.. No post available at this position
ZealERP.ZealFramework.Utils.ZealException: Error.. No post available at this position
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.<SaveDataSecure>b__0()
3/31/2024 11:12:48 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:13:21 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:14:57 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:14:59 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:15:18 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:15:50 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:16:03 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:21:57 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:34:05 PM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
3/31/2024 11:39:53 PM: Number of days finished to make changes
ZealERP.ZealFramework.Utils.ZealException: Number of days finished to make changes
   at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeUpdate(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass25_0.<Update>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
3/31/2024 11:39:53 PM: Error.. Number of days finished to make changes
ZealERP.ZealFramework.Utils.ZealException: Error.. Number of days finished to make changes
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Update(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.UpdateSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass7_0.<UpdateDataSecure>b__0()
3/31/2024 11:42:20 PM: Number of days finished to make changes
ZealERP.ZealFramework.Utils.ZealException: Number of days finished to make changes
   at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeUpdate(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass25_0.<Update>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
3/31/2024 11:42:20 PM: Error.. Number of days finished to make changes
ZealERP.ZealFramework.Utils.ZealException: Error.. Number of days finished to make changes
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Update(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.UpdateSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass7_0.<UpdateDataSecure>b__0()