09/01/2018 10:55:19  *****  ERROR DE SISTEMA:   *****  mramirez  *****  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, 1008, 0000000687, 2018, 002) 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,'002' 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='1008' 

09/01/2018 12:05:29  *****  ERROR DE SISTEMA:   *****  mramirez  *****  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, 1008, 0000000687, 2018, 002) 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,'002' 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='1008' 

09/01/2018 15:16:33  *****  ERROR DE SISTEMA:   *****  mramirez  *****  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, 1008, 0000000687, 2018, 002) 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,'002' 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='1008' 

09/01/2018 21:06:43  *****  ERROR DE SISTEMA:   *****  RSUAREZ  *****  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, 1008, 0000000687, 2018, 002) 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,'002' 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='1008'