16-Oct-23 10:32:04	Start: QRBATCHINFO
16-Oct-23 10:32:04	Received: Data: Gx3tlmxTn/SPEQFO81HtO1egwdk4G8vaboJa8kZGF/anzeZKRfsj2XbsZ3YSV5gXcJez4Qrtql+x2+439yUpQbrhDugxA9I4PM1LJS70aOSdKYdUczPagDy7yQ9T/pYEzNOihcOd62SfnXDYWl3vA7tB1XP9l9Z1/d3/TSYdjflJsHFQhkdnCTnV81DD8bjy6hkZFfvtNYzTBSGBX8ZZ+fl6W137n/PYSFie53YKkUvH7fnttECifMWR9qqn8rOAOmjpSO3g+lCr2cOQwBCmYl9qAMoZirvkAZwo8KXWrLL1vd0vzJ2CAf+x4wJpmrJA+DHS0m8jheANcrlcVtUd5gt0EEj+at678fqztibnRJ0GTjpJt38Jkc2n2KitUf6qpND78w0DUjgcN3UW2bgJsquuTVwMMj1+sedArBh+yygaBDmfV6ObphGgMJgTPJnY10ubq/CmiGiK47WWPbpoOwboablvUMKjrffqloH/ZJEI8vQuSwMeWnD2BaU4GY8LMuQKV1T8KcL5ZvlbnBsUscsfJ4GfslqroiTEF2eHyFgioRMThuygSy6QxXmvKjmiZHpMbODt7fkwhqRIFCDajaBAy0M0HIBIBTkOcMLYnG7IVfJeCCrO25SKuJqFliK4DY2kZopDO09lMujX5t2Y9qc3UO71AKkoAw0rBi7+AtqZPhBIsXZcVSqi3l5gadVZBI0vu5g04Dilq0vNFI7kPUT8L9JcBUZqBz3WjsUCho1xFfnR91W3fCBxVYnVzyjyOLxzIzXGAUBPCA+t2d1QShPOyPvIkuNdY0mNCLbnrhq8YrPfXDq0DR7Ye/+uqR8McSxyMqfAPhlTyNLGIndsSv9rUg7GSk7lrAbAoCz9QzIgT3Z45y9hT1ZYW2szzQkRRiq67HAggP/xh+f38g6CenCLC3+Lal7tMzH2vGfePVD3Cvrdmk7Mwtg/mxWa961B565S2ZWbLbE8U8SmmZFQwHRcONGzBgPoWJGyIwagdLL5gw9Ido1Kxky9lhm4I9lqcPYFpTgZjwtL9C6FQXlrZndzm2ej3zysMQCTSPGleVeXeO+qxno9y+SDxquuAHGHwz9IEBZSR4HcI92Ia9wL34UT9ncbdG7kdJxyRI/0x8qP+fx9nUuHqUyqy9npbgkvTE60i1pf5CJ6dtlbjl5fcA==,HasKeyVal pfizersecQnsetu2023
16-Oct-23 10:32:04	Decrypted Data: {  "Request": [{"MATERIAL_CODE":"F000153477","MATERIAL_DESCRIPTION":"Asthetic Antacid Gel","BRAND_NAME":"bb MINT GEL 200 ML","MFG_NAME":"Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195","MFG_ADDRESS":"Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195","BATCH_NO":"batchaj77662","Batch_Created":"2023-10-09T13:35:14.017","Lot_No":"batchaj77662","BATCH_QTY":3,"MFG_DATE":"2023-10-09","EXPIRY_DATE":"2083-09-30","MFG_LICENSE_NUMBER":"G\/25A\/3864-A","Line_no":10120,"PLANT_Code":"123","Location_Code":"Loc1","COMPANY_CODE":"QN","PRINT_QTY":3,"Printing_Date":"2023-10-16T10:26:12.560","Partial_Closed_Batch_Qty":3,"Fully_Closed_Batch_Qty":0,"ACCEPTED_QTY":1,"REJECTED_AUTO_QTY":2,"REJECTED_MANUAL_QTY":0,"DIGILINK":"F000153477batchaj776620000001326","Process_Order_No":"","Created_By":40025,"BatchStatus":"FULL","GTIN":"8008877000000"}] }
16-Oct-23 10:32:04	Fetch Config Data , Request: QRBATCHINFO
16-Oct-23 10:32:04	Fetch Config Data , Response: QRBATCHINFO
16-Oct-23 10:32:04	Converting JSON DATA to XML : 
16-Oct-23 10:32:04	Request JSON DATA to XML : <NewDataSet>
  <Request>
    <MATERIAL_CODE>F000153477</MATERIAL_CODE>
    <MATERIAL_DESCRIPTION>Asthetic Antacid Gel</MATERIAL_DESCRIPTION>
    <BRAND_NAME>bb MINT GEL 200 ML</BRAND_NAME>
    <MFG_NAME>Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195</MFG_NAME>
    <MFG_ADDRESS>Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195</MFG_ADDRESS>
    <BATCH_NO>batchaj77662</BATCH_NO>
    <Batch_Created>2023-10-09T13:35:14.017</Batch_Created>
    <Lot_No>batchaj77662</Lot_No>
    <BATCH_QTY>3</BATCH_QTY>
    <MFG_DATE>2023-10-09</MFG_DATE>
    <EXPIRY_DATE>2083-09-30</EXPIRY_DATE>
    <MFG_LICENSE_NUMBER>G/25A/3864-A</MFG_LICENSE_NUMBER>
    <Line_no>10120</Line_no>
    <PLANT_Code>123</PLANT_Code>
    <Location_Code>Loc1</Location_Code>
    <COMPANY_CODE>QN</COMPANY_CODE>
    <PRINT_QTY>3</PRINT_QTY>
    <Printing_Date>2023-10-16T10:26:12.56</Printing_Date>
    <Partial_Closed_Batch_Qty>3</Partial_Closed_Batch_Qty>
    <Fully_Closed_Batch_Qty>0</Fully_Closed_Batch_Qty>
    <ACCEPTED_QTY>1</ACCEPTED_QTY>
    <REJECTED_AUTO_QTY>2</REJECTED_AUTO_QTY>
    <REJECTED_MANUAL_QTY>0</REJECTED_MANUAL_QTY>
    <DIGILINK>F000153477batchaj776620000001326</DIGILINK>
    <Process_Order_No />
    <Created_By>40025</Created_By>
    <BatchStatus>FULL</BatchStatus>
    <GTIN>8008877000000</GTIN>
  </Request>
</NewDataSet>
16-Oct-23 10:32:04	Data Request: SP NAME: SP_INSERT_MASTER_DATAXML:<NewDataSet>
  <Request>
    <MATERIAL_CODE>F000153477</MATERIAL_CODE>
    <MATERIAL_DESCRIPTION>Asthetic Antacid Gel</MATERIAL_DESCRIPTION>
    <BRAND_NAME>bb MINT GEL 200 ML</BRAND_NAME>
    <MFG_NAME>Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195</MFG_NAME>
    <MFG_ADDRESS>Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195</MFG_ADDRESS>
    <BATCH_NO>batchaj77662</BATCH_NO>
    <Batch_Created>2023-10-09T13:35:14.017</Batch_Created>
    <Lot_No>batchaj77662</Lot_No>
    <BATCH_QTY>3</BATCH_QTY>
    <MFG_DATE>2023-10-09</MFG_DATE>
    <EXPIRY_DATE>2083-09-30</EXPIRY_DATE>
    <MFG_LICENSE_NUMBER>G/25A/3864-A</MFG_LICENSE_NUMBER>
    <Line_no>10120</Line_no>
    <PLANT_Code>123</PLANT_Code>
    <Location_Code>Loc1</Location_Code>
    <COMPANY_CODE>QN</COMPANY_CODE>
    <PRINT_QTY>3</PRINT_QTY>
    <Printing_Date>2023-10-16T10:26:12.56</Printing_Date>
    <Partial_Closed_Batch_Qty>3</Partial_Closed_Batch_Qty>
    <Fully_Closed_Batch_Qty>0</Fully_Closed_Batch_Qty>
    <ACCEPTED_QTY>1</ACCEPTED_QTY>
    <REJECTED_AUTO_QTY>2</REJECTED_AUTO_QTY>
    <REJECTED_MANUAL_QTY>0</REJECTED_MANUAL_QTY>
    <DIGILINK>F000153477batchaj776620000001326</DIGILINK>
    <Process_Order_No />
    <Created_By>40025</Created_By>
    <BatchStatus>FULL</BatchStatus>
    <GTIN>8008877000000</GTIN>
  </Request>
</NewDataSet>
16-Oct-23 10:32:05	Data Response: <NewDataSet>
  <Table>
    <IsSuccessful>True</IsSuccessful>
    <Message>Success</Message>
    <MessageCode>200</MessageCode>
    <BATCH_NO>batchaj77662</BATCH_NO>
    <LOT_NO>batchaj77662</LOT_NO>
    <PLANT_CODE>123</PLANT_CODE>
  </Table>
  <Table1>
    <IsSuccessful>True</IsSuccessful>
    <Message>Success</Message>
    <MessageCode>200</MessageCode>
    <BATCH_NO>batchaj77662</BATCH_NO>
    <LOT_NO>batchaj77662</LOT_NO>
    <PLANT_CODE>123</PLANT_CODE>
  </Table1>
</NewDataSet>
16-Oct-23 10:32:05	Response JSON Data:[{"IsSuccessful":"True","Message":"Success","MessageCode":"200","BATCH_NO":"batchaj77662","LOT_NO":"batchaj77662","PLANT_CODE":"123"}]
16-Oct-23 19:24:45	Start: QRBATCHINFO
16-Oct-23 19:24:45	Received: Data: Gx3tlmxTn/SPEQFO81HtO1egwdk4G8vaboJa8kZGF/anzeZKRfsj2XbsZ3YSV5gXcJez4Qrtql+x2+439yUpQbrhDugxA9I4PM1LJS70aOSdKYdUczPagDy7yQ9T/pYEzNOihcOd62SfnXDYWl3vA7tB1XP9l9Z1/d3/TSYdjflJsHFQhkdnCTnV81DD8bjy6hkZFfvtNYzTBSGBX8ZZ+fl6W137n/PYSFie53YKkUvH7fnttECifMWR9qqn8rOAOmjpSO3g+lCr2cOQwBCmYl9qAMoZirvkAZwo8KXWrLL1vd0vzJ2CAf+x4wJpmrJA+DHS0m8jheANcrlcVtUd5gt0EEj+at678fqztibnRJ0GTjpJt38Jkc2n2KitUf6qpND78w0DUjgcN3UW2bgJsquuTVwMMj1+1EAzqbizrUIaBDmfV6ObphGgMJgTPJnY10ubq/CmiGgFMYM43iilA2tL7S9r0tRIrffqloH/ZJEI8vQuSwMeWgow4ToB3IrqMuQKV1T8KcL5ZvlbnBsUscsfJ4GfslqroiTEF2eHyFhnxKxuZ0h2fC6QxXmvKjmiZHpMbODt7fkwhqRIFCDajaBAy0M0HIBIBTkOcMLYnG7IVfJeCCrO25SKuJqFliK4DY2kZopDO09lMujX5t2Y9qc3UO71AKkoAw0rBi7+AtqZPhBIsXZcVSqi3l5gadVZBI0vu5g04Dilq0vNFI7kPUT8L9JcBUZqBz3WjsUCho1xFfnR91W3fCBxVYnVzyjyOLxzIzXGAUBPCA+t2d1QShPOyPvIkuNdY0mNCLbnrhqc5S8zEZ2BDjYLByaO4ZwPcSxyMqfAPhlTyNLGIndsSv9rUg7GSk7lrAbAoCz9QzIgT3Z45y9hT1ZYW2szzQkRRiq67HAggP/xh+f38g6Cehv3AmrNR1lkMzH2vGfePVD3Cvrdmk7MwictdnfZhPOR565S2ZWbLbE8U8SmmZFQwHRcONGzBgPoWJGyIwagdLL5gw9Ido1Kxky9lhm4I9lqCjDhOgHciupL9C6FQXlrZqbh0jE1rzOQMQCTSPGleVeXeO+qxno9y+SDxquuAHGHwz9IEBZSR4HcI92Ia9wL34UT9ncbdG7kdJxyRI/0x8qP+fx9nUuHqUyqy9npbgkvTE60i1pf5CJ6dtlbjl5fcA==, HasKeyVal:  pfizersecQnsetu2023
16-Oct-23 19:24:45	Decrypted Data: {  "Request": [{"MATERIAL_CODE":"F000153477","MATERIAL_DESCRIPTION":"Asthetic Antacid Gel","BRAND_NAME":"bb MINT GEL 200 ML","MFG_NAME":"Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195","MFG_ADDRESS":"Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195","BATCH_NO":"batchaji2023","Batch_Created":"2023-10-16T18:08:06.067","Lot_No":"batchaji2023","BATCH_QTY":3,"MFG_DATE":"2023-10-16","EXPIRY_DATE":"2083-09-30","MFG_LICENSE_NUMBER":"G\/25A\/3864-A","Line_no":10120,"PLANT_Code":"123","Location_Code":"Loc1","COMPANY_CODE":"QN","PRINT_QTY":3,"Printing_Date":"2023-10-16T18:08:22.170","Partial_Closed_Batch_Qty":3,"Fully_Closed_Batch_Qty":0,"ACCEPTED_QTY":2,"REJECTED_AUTO_QTY":1,"REJECTED_MANUAL_QTY":0,"DIGILINK":"F000153477batchaji20230000001386","Process_Order_No":"","Created_By":40025,"BatchStatus":"FULL","GTIN":"8008877000000"}] }
16-Oct-23 19:24:45	Fetch Config Data , Request: QRBATCHINFO
16-Oct-23 19:24:46	Fetch Config Data , Response: QRBATCHINFO
16-Oct-23 19:24:46	Converting JSON DATA to XML : 
16-Oct-23 19:24:46	Request JSON DATA to XML : <NewDataSet>
  <Request>
    <MATERIAL_CODE>F000153477</MATERIAL_CODE>
    <MATERIAL_DESCRIPTION>Asthetic Antacid Gel</MATERIAL_DESCRIPTION>
    <BRAND_NAME>bb MINT GEL 200 ML</BRAND_NAME>
    <MFG_NAME>Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195</MFG_NAME>
    <MFG_ADDRESS>Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195</MFG_ADDRESS>
    <BATCH_NO>batchaji2023</BATCH_NO>
    <Batch_Created>2023-10-16T18:08:06.067</Batch_Created>
    <Lot_No>batchaji2023</Lot_No>
    <BATCH_QTY>3</BATCH_QTY>
    <MFG_DATE>2023-10-16</MFG_DATE>
    <EXPIRY_DATE>2083-09-30</EXPIRY_DATE>
    <MFG_LICENSE_NUMBER>G/25A/3864-A</MFG_LICENSE_NUMBER>
    <Line_no>10120</Line_no>
    <PLANT_Code>123</PLANT_Code>
    <Location_Code>Loc1</Location_Code>
    <COMPANY_CODE>QN</COMPANY_CODE>
    <PRINT_QTY>3</PRINT_QTY>
    <Printing_Date>2023-10-16T18:08:22.17</Printing_Date>
    <Partial_Closed_Batch_Qty>3</Partial_Closed_Batch_Qty>
    <Fully_Closed_Batch_Qty>0</Fully_Closed_Batch_Qty>
    <ACCEPTED_QTY>2</ACCEPTED_QTY>
    <REJECTED_AUTO_QTY>1</REJECTED_AUTO_QTY>
    <REJECTED_MANUAL_QTY>0</REJECTED_MANUAL_QTY>
    <DIGILINK>F000153477batchaji20230000001386</DIGILINK>
    <Process_Order_No />
    <Created_By>40025</Created_By>
    <BatchStatus>FULL</BatchStatus>
    <GTIN>8008877000000</GTIN>
  </Request>
</NewDataSet>
16-Oct-23 19:24:46	Data Request: SP NAME: SP_INSERT_MASTER_DATAXML:<NewDataSet>
  <Request>
    <MATERIAL_CODE>F000153477</MATERIAL_CODE>
    <MATERIAL_DESCRIPTION>Asthetic Antacid Gel</MATERIAL_DESCRIPTION>
    <BRAND_NAME>bb MINT GEL 200 ML</BRAND_NAME>
    <MFG_NAME>Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195</MFG_NAME>
    <MFG_ADDRESS>Plot No. 1802-1805, G.I.D.C. Phase III, Post-Vapi, Dist-Valsad-396195</MFG_ADDRESS>
    <BATCH_NO>batchaji2023</BATCH_NO>
    <Batch_Created>2023-10-16T18:08:06.067</Batch_Created>
    <Lot_No>batchaji2023</Lot_No>
    <BATCH_QTY>3</BATCH_QTY>
    <MFG_DATE>2023-10-16</MFG_DATE>
    <EXPIRY_DATE>2083-09-30</EXPIRY_DATE>
    <MFG_LICENSE_NUMBER>G/25A/3864-A</MFG_LICENSE_NUMBER>
    <Line_no>10120</Line_no>
    <PLANT_Code>123</PLANT_Code>
    <Location_Code>Loc1</Location_Code>
    <COMPANY_CODE>QN</COMPANY_CODE>
    <PRINT_QTY>3</PRINT_QTY>
    <Printing_Date>2023-10-16T18:08:22.17</Printing_Date>
    <Partial_Closed_Batch_Qty>3</Partial_Closed_Batch_Qty>
    <Fully_Closed_Batch_Qty>0</Fully_Closed_Batch_Qty>
    <ACCEPTED_QTY>2</ACCEPTED_QTY>
    <REJECTED_AUTO_QTY>1</REJECTED_AUTO_QTY>
    <REJECTED_MANUAL_QTY>0</REJECTED_MANUAL_QTY>
    <DIGILINK>F000153477batchaji20230000001386</DIGILINK>
    <Process_Order_No />
    <Created_By>40025</Created_By>
    <BatchStatus>FULL</BatchStatus>
    <GTIN>8008877000000</GTIN>
  </Request>
</NewDataSet>
16-Oct-23 19:24:46	Data Response: <NewDataSet>
  <Table>
    <IsSuccessful>True</IsSuccessful>
    <Message>Success</Message>
    <MessageCode>200</MessageCode>
    <BATCH_NO>batchaji2023</BATCH_NO>
    <LOT_NO>batchaji2023</LOT_NO>
    <PLANT_CODE>123</PLANT_CODE>
  </Table>
  <Table1>
    <IsSuccessful>True</IsSuccessful>
    <Message>Success</Message>
    <MessageCode>200</MessageCode>
    <BATCH_NO>batchaji2023</BATCH_NO>
    <LOT_NO>batchaji2023</LOT_NO>
    <PLANT_CODE>123</PLANT_CODE>
  </Table1>
</NewDataSet>
16-Oct-23 19:24:46	DTToJSON start: 
16-Oct-23 19:24:46	DTToJSON End: [{"IsSuccessful":"True","Message":"Success","MessageCode":"200","BATCH_NO":"batchaji2023","LOT_NO":"batchaji2023","PLANT_CODE":"123"}]
16-Oct-23 19:24:46	Response JSON Data:[{"IsSuccessful":"True","Message":"Success","MessageCode":"200","BATCH_NO":"batchaji2023","LOT_NO":"batchaji2023","PLANT_CODE":"123"}]