03/02/2021 01:10:45  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Transferir Personal MÉTODO->ConsultaPersonalMovimiento ERROR->Invalid query: ERROR:  schema "sno_personalnomina" does not exist
LINE 7: ...puniadm||'-'||prouniadm = '0001-80-12-10-00'  AND sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nomper, sno_personal.apeper 
				  FROM sno_personal
				 INNER JOIN sno_personalnomina ON sno_personal.codemp = sno_personalnomina.codemp 
				                              AND sno_personal.codper = sno_personalnomina.codper
				 WHERE sno_personalnomina.codemp='0001' 
				   AND sno_personalnomina.codnom='' 					  
				     AND sno_personalnomina.codcar = '0000002000'  AND minorguniadm||'-'||ofiuniadm||'-'||uniuniadm||'-'||depuniadm||'-'||prouniadm = '0001-80-12-10-00'  AND sno_personalnomina.sueper  '10000.00'  AND sno_personalnomina.codded = '400'  AND sno_personalnomina.codtipper = '4002'  AND sno_personal.sexper = 'M' 
				    ORDER BY sno_personal.codper
				

03/02/2021 01:13:23  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Transferir Personal MÉTODO->ConsultaPersonalMovimiento ERROR->Invalid query: ERROR:  schema "sno_personalnomina" does not exist
LINE 7: ...puniadm||'-'||prouniadm = '0001-80-12-10-00'  AND sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nomper, sno_personal.apeper 
				  FROM sno_personal
				 INNER JOIN sno_personalnomina ON sno_personal.codemp = sno_personalnomina.codemp 
				                              AND sno_personal.codper = sno_personalnomina.codper
				 WHERE sno_personalnomina.codemp='0001' 
				   AND sno_personalnomina.codnom='' 					  
				     AND sno_personalnomina.codcar = '0000002000'  AND minorguniadm||'-'||ofiuniadm||'-'||uniuniadm||'-'||depuniadm||'-'||prouniadm = '0001-80-12-10-00'  AND sno_personalnomina.sueper  '10000.00'  AND sno_personalnomina.codded = '400'  AND sno_personalnomina.codtipper = '4002'  AND sno_personal.sexper = 'M' 
				    ORDER BY sno_personal.codper
				

03/02/2021 05:34:15  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Personal Nómina MÉTODO->uf_insert_constantepersonal ERROR->Invalid query: ERROR:  syntax error at or near "0001"
LINE 10:          WHERE codemp='0001'
                                ^
Whole query: INSERT INTO sno_constantepersonal (codemp,codnom,codper,codcons,moncon) SELECT codemp,codnom,'0000344478',codcons,valcon   FROM sno_constante  WHERE codemp = '0001'    AND codnom = '1008'; 
		                         UPDATE sno_constantepersonal 
								   SET moncon = (SELECT moncon 
												   FROM sno_constantepersonal cp
												  WHERE cp.codemp=sno_constantepersonal.codemp                    
													AND cp.codper=sno_constantepersonal.codper
													AND cp.codcons=sno_constantepersonal.codcons													
													AND cp.codnom='1005													
												)
									WHERE codemp='0001'
									  AND codnom='1008'
									  AND codper ='0000344478'
									  AND codcons IN (
													     SELECT DISTINCT codcons 
														   FROM sno_constantepersonal cp
														  WHERE cp.codemp=sno_constantepersonal.codemp                    
															AND cp.codper=sno_constantepersonal.codper
															AND cp.codcons=sno_constantepersonal.codcons													
															AND cp.codnom='1005
													  
													  )
								   ;
							 

03/02/2021 05:35:10  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Personal Nómina MÉTODO->uf_insert_constantepersonal ERROR->Invalid query: ERROR:  syntax error at or near "0001"
LINE 10:          WHERE codemp='0001'
                                ^
Whole query: INSERT INTO sno_constantepersonal (codemp,codnom,codper,codcons,moncon) SELECT codemp,codnom,'0000344478',codcons,valcon   FROM sno_constante  WHERE codemp = '0001'    AND codnom = '1008'; 
		                         UPDATE sno_constantepersonal 
								   SET moncon = (SELECT moncon 
												   FROM sno_constantepersonal cp
												  WHERE cp.codemp=sno_constantepersonal.codemp                    
													AND cp.codper=sno_constantepersonal.codper
													AND cp.codcons=sno_constantepersonal.codcons													
													AND cp.codnom='1005													
												)
									WHERE codemp='0001'
									  AND codnom='1008'
									  AND codper ='0000344478'
									  AND codcons IN (
													     SELECT DISTINCT codcons 
														   FROM sno_constantepersonal cp
														  WHERE cp.codemp=sno_constantepersonal.codemp                    
															AND cp.codper=sno_constantepersonal.codper
															AND cp.codcons=sno_constantepersonal.codcons													
															AND cp.codnom='1005
													  
													  )
								   ;
							 

03/02/2021 05:35:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Personal Nómina MÉTODO->uf_insert_constantepersonal ERROR->Invalid query: ERROR:  syntax error at or near "0001"
LINE 10:          WHERE codemp='0001'
                                ^
Whole query: INSERT INTO sno_constantepersonal (codemp,codnom,codper,codcons,moncon) SELECT codemp,codnom,'0000344478',codcons,valcon   FROM sno_constante  WHERE codemp = '0001'    AND codnom = '1008'; 
		                         UPDATE sno_constantepersonal 
								   SET moncon = (SELECT moncon 
												   FROM sno_constantepersonal cp
												  WHERE cp.codemp=sno_constantepersonal.codemp                    
													AND cp.codper=sno_constantepersonal.codper
													AND cp.codcons=sno_constantepersonal.codcons													
													AND cp.codnom='1005													
												)
									WHERE codemp='0001'
									  AND codnom='1008'
									  AND codper ='0000344478'
									  AND codcons IN (
													     SELECT DISTINCT codcons 
														   FROM sno_constantepersonal cp
														  WHERE cp.codemp=sno_constantepersonal.codemp                    
															AND cp.codper=sno_constantepersonal.codper
															AND cp.codcons=sno_constantepersonal.codcons													
															AND cp.codnom='1005
													  
													  )
								   ;
							 

03/02/2021 05:35:43  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Personal Nómina MÉTODO->uf_insert_constantepersonal ERROR->Invalid query: ERROR:  syntax error at or near "0001"
LINE 10:          WHERE codemp='0001'
                                ^
Whole query: INSERT INTO sno_constantepersonal (codemp,codnom,codper,codcons,moncon) SELECT codemp,codnom,'0000344478',codcons,valcon   FROM sno_constante  WHERE codemp = '0001'    AND codnom = '1008'; 
		                         UPDATE sno_constantepersonal 
								   SET moncon = (SELECT moncon 
												   FROM sno_constantepersonal cp
												  WHERE cp.codemp=sno_constantepersonal.codemp                    
													AND cp.codper=sno_constantepersonal.codper
													AND cp.codcons=sno_constantepersonal.codcons													
													AND cp.codnom='1005													
												)
									WHERE codemp='0001'
									  AND codnom='1008'
									  AND codper ='0000344478'
									  AND codcons IN (
													     SELECT DISTINCT codcons 
														   FROM sno_constantepersonal cp
														  WHERE cp.codemp=sno_constantepersonal.codemp                    
															AND cp.codper=sno_constantepersonal.codper
															AND cp.codcons=sno_constantepersonal.codcons													
															AND cp.codnom='1005
													  
													  )
								   ;
							 

03/02/2021 06:36:51  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Debe seleccionar al menos una persona !

03/02/2021 07:43:08  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  El personal fue Actualizado en la nómina.

03/02/2021 07:43:08  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  El personal fue Actualizado en la nómina.

03/02/2021 07:43:08  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  El personal fue Actualizado en la nómina.

03/02/2021 07:57:17  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Personal Nómina MÉTODO->uf_delete_personal ERROR->Invalid query: ERROR:  update or delete on table "sno_personalnomina" violates foreign key constraint "fk_sno_resu_sno_perso_sno_pers" on table "sno_resumen"
DETAIL:  Key (codemp, codper, codnom)=(0001, 0000344478, 1005) is still referenced from table "sno_resumen".
Whole query: DELETE FROM sno_personalnomina  WHERE codemp='0001'    AND codnom='1005'    AND codper='0000344478'  

03/02/2021 08:02:38  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  La nómina origen esta calculada y no puede ser modificada !

03/02/2021 08:04:46  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Debe seleccionar al menos una persona !

03/02/2021 08:07:15  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  El personal fue transferido.

03/02/2021 08:09:58  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  El personal fue transferido.

03/02/2021 08:10:34  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  El personal fue transferido.