22/10/2018 08:59:30  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR:  inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar»
DETAIL:  La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1002, 0000000000, 2018, 017) no está presente en la tabla «sno_hcargo».
Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar,                                   codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm,                                   depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper,                                   codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper,                                   quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper,                                   fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, 									catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, 									salnorper,estencper,obsrecper )      SELECT codemp, codnom, '2018' AS anocur,'017' AS codperi, codper, codsubnom,             codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm,             ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban,             codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper,             fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper,             pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper,             codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, 			  descasicar, coddep,salnorper,estencper,obsrecper        FROM sno_personalnomina       WHERE codemp='0001'         AND codnom='1002' 

22/10/2018 09:01:30  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR:  inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar»
DETAIL:  La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1002, 0000000000, 2018, 017) no está presente en la tabla «sno_hcargo».
Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar,                                   codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm,                                   depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper,                                   codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper,                                   quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper,                                   fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, 									catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, 									salnorper,estencper,obsrecper )      SELECT codemp, codnom, '2018' AS anocur,'017' AS codperi, codper, codsubnom,             codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm,             ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban,             codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper,             fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper,             pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper,             codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, 			  descasicar, coddep,salnorper,estencper,obsrecper        FROM sno_personalnomina       WHERE codemp='0001'         AND codnom='1002' 

22/10/2018 09:04:45  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR:  inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar»
DETAIL:  La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1002, 0000000000, 2018, 017) no está presente en la tabla «sno_hcargo».
Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar,                                   codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm,                                   depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper,                                   codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper,                                   quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper,                                   fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, 									catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, 									salnorper,estencper,obsrecper )      SELECT codemp, codnom, '2018' AS anocur,'017' AS codperi, codper, codsubnom,             codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm,             ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban,             codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper,             fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper,             pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper,             codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, 			  descasicar, coddep,salnorper,estencper,obsrecper        FROM sno_personalnomina       WHERE codemp='0001'         AND codnom='1002' 

22/10/2018 09:08:10  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR:  inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar»
DETAIL:  La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1002, 0000000000, 2018, 017) no está presente en la tabla «sno_hcargo».
Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar,                                   codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm,                                   depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper,                                   codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper,                                   quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper,                                   fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, 									catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, 									salnorper,estencper,obsrecper )      SELECT codemp, codnom, '2018' AS anocur,'017' AS codperi, codper, codsubnom,             codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm,             ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban,             codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper,             fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper,             pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper,             codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, 			  descasicar, coddep,salnorper,estencper,obsrecper        FROM sno_personalnomina       WHERE codemp='0001'         AND codnom='1002' 

22/10/2018 09:11:25  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR:  inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar»
DETAIL:  La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1002, 0000000000, 2018, 017) no está presente en la tabla «sno_hcargo».
Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar,                                   codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm,                                   depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper,                                   codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper,                                   quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper,                                   fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, 									catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, 									salnorper,estencper,obsrecper )      SELECT codemp, codnom, '2018' AS anocur,'017' AS codperi, codper, codsubnom,             codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm,             ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban,             codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper,             fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper,             pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper,             codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, 			  descasicar, coddep,salnorper,estencper,obsrecper        FROM sno_personalnomina       WHERE codemp='0001'         AND codnom='1002' 

22/10/2018 09:15:10  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR:  inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar»
DETAIL:  La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1002, 0000000000, 2018, 017) no está presente en la tabla «sno_hcargo».
Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar,                                   codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm,                                   depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper,                                   codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper,                                   quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper,                                   fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, 									catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, 									salnorper,estencper,obsrecper )      SELECT codemp, codnom, '2018' AS anocur,'017' AS codperi, codper, codsubnom,             codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm,             ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban,             codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper,             fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper,             pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper,             codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, 			  descasicar, coddep,salnorper,estencper,obsrecper        FROM sno_personalnomina       WHERE codemp='0001'         AND codnom='1002' 

22/10/2018 09:54:15  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR:  inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar»
DETAIL:  La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1003, 0000000000, 2018, 017) no está presente en la tabla «sno_hcargo».
Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar,                                   codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm,                                   depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper,                                   codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper,                                   quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper,                                   fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, 									catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, 									salnorper,estencper,obsrecper )      SELECT codemp, codnom, '2018' AS anocur,'017' AS codperi, codper, codsubnom,             codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm,             ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban,             codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper,             fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper,             pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper,             codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, 			  descasicar, coddep,salnorper,estencper,obsrecper        FROM sno_personalnomina       WHERE codemp='0001'         AND codnom='1003' 

22/10/2018 09:55:28  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR:  inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar»
DETAIL:  La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1003, 0000000000, 2018, 017) no está presente en la tabla «sno_hcargo».
Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar,                                   codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm,                                   depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper,                                   codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper,                                   quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper,                                   fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, 									catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, 									salnorper,estencper,obsrecper )      SELECT codemp, codnom, '2018' AS anocur,'017' AS codperi, codper, codsubnom,             codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm,             ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban,             codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper,             fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper,             pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper,             codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, 			  descasicar, coddep,salnorper,estencper,obsrecper        FROM sno_personalnomina       WHERE codemp='0001'         AND codnom='1003'