16-Oct-23 21:05:18	Start:QRBATCHINFO
16-Oct-23 21:05:18	Data Received: {"Request":[{"Process_Order_No":"-","MATERIAL_CODE":"F000196734","GTIN":"8902393003250","MATERIAL_DESCRIPTION":"BECOSULES Z CAPSULES","BRAND_NAME":"BECOSULES Z CAPSULES","MFG_NAME":"Pfizer Limited At:","MFG_ADDRESS":"D-5, M.I.D.C.,PAITHAN, AURANGABAD -431148","BATCH_NO":"2330116N","Batch_Created":"10/15/2023 1:26:00 AM","Lot_No":"2330116N","BATCH_QTY":5000,"MFG_DATE":"10/13/2023 1:21:05 AM","EXPIRY_DATE":"3/18/2025 12:00:00 AM","MFG_LICENSE_NUMBER":"MH/102954A","Line_no":"Line No.14","PLANT_Code":"ENCORE","Location_Code":"8906050709998","COMPANY_CODE":"890605070","PRINT_QTY":3083,"Printing_Date":"10/16/2023 9:05:17 PM","Partial_Closed_Batch_Qty":1917,"Fully_Closed_Batch_Qty":0,"ACCEPTED_QTY":2421,"REJECTED_AUTO_QTY":662,"REJECTED_MANUAL_QTY":0,"DIGILINK":"https://llq.pfizerem.in/kv/qnuiddata.aspx/01/8902393003250/10/2330116N?17=250300","BatchStatus":"PARTIAL","Created_By":"shubham.randad"}]}
16-Oct-23 21:05:18	Fetch Config Data , Request: QRBATCHINFO
16-Oct-23 21:05:18	Fetch Config Data , Response: QRBATCHINFO
16-Oct-23 21:05:18	Converting JSON DATA to XML : 
16-Oct-23 21:05:18	Request JSON DATA to XML : <NewDataSet>
  <Request>
    <Process_Order_No>-</Process_Order_No>
    <MATERIAL_CODE>F000196734</MATERIAL_CODE>
    <GTIN>8902393003250</GTIN>
    <MATERIAL_DESCRIPTION>BECOSULES Z CAPSULES</MATERIAL_DESCRIPTION>
    <BRAND_NAME>BECOSULES Z CAPSULES</BRAND_NAME>
    <MFG_NAME>Pfizer Limited At:</MFG_NAME>
    <MFG_ADDRESS>D-5, M.I.D.C.,PAITHAN, AURANGABAD -431148</MFG_ADDRESS>
    <BATCH_NO>2330116N</BATCH_NO>
    <Batch_Created>10/15/2023 1:26:00 AM</Batch_Created>
    <Lot_No>2330116N</Lot_No>
    <BATCH_QTY>5000</BATCH_QTY>
    <MFG_DATE>10/13/2023 1:21:05 AM</MFG_DATE>
    <EXPIRY_DATE>3/18/2025 12:00:00 AM</EXPIRY_DATE>
    <MFG_LICENSE_NUMBER>MH/102954A</MFG_LICENSE_NUMBER>
    <Line_no>Line No.14</Line_no>
    <PLANT_Code>ENCORE</PLANT_Code>
    <Location_Code>8906050709998</Location_Code>
    <COMPANY_CODE>890605070</COMPANY_CODE>
    <PRINT_QTY>3083</PRINT_QTY>
    <Printing_Date>10/16/2023 9:05:17 PM</Printing_Date>
    <Partial_Closed_Batch_Qty>1917</Partial_Closed_Batch_Qty>
    <Fully_Closed_Batch_Qty>0</Fully_Closed_Batch_Qty>
    <ACCEPTED_QTY>2421</ACCEPTED_QTY>
    <REJECTED_AUTO_QTY>662</REJECTED_AUTO_QTY>
    <REJECTED_MANUAL_QTY>0</REJECTED_MANUAL_QTY>
    <DIGILINK>https://llq.pfizerem.in/kv/qnuiddata.aspx/01/8902393003250/10/2330116N?17=250300</DIGILINK>
    <BatchStatus>PARTIAL</BatchStatus>
    <Created_By>shubham.randad</Created_By>
  </Request>
</NewDataSet>
16-Oct-23 21:05:18	Data Request: SP NAME: SP_INSERT_MASTER_DATAXML:<NewDataSet>
  <Request>
    <Process_Order_No>-</Process_Order_No>
    <MATERIAL_CODE>F000196734</MATERIAL_CODE>
    <GTIN>8902393003250</GTIN>
    <MATERIAL_DESCRIPTION>BECOSULES Z CAPSULES</MATERIAL_DESCRIPTION>
    <BRAND_NAME>BECOSULES Z CAPSULES</BRAND_NAME>
    <MFG_NAME>Pfizer Limited At:</MFG_NAME>
    <MFG_ADDRESS>D-5, M.I.D.C.,PAITHAN, AURANGABAD -431148</MFG_ADDRESS>
    <BATCH_NO>2330116N</BATCH_NO>
    <Batch_Created>10/15/2023 1:26:00 AM</Batch_Created>
    <Lot_No>2330116N</Lot_No>
    <BATCH_QTY>5000</BATCH_QTY>
    <MFG_DATE>10/13/2023 1:21:05 AM</MFG_DATE>
    <EXPIRY_DATE>3/18/2025 12:00:00 AM</EXPIRY_DATE>
    <MFG_LICENSE_NUMBER>MH/102954A</MFG_LICENSE_NUMBER>
    <Line_no>Line No.14</Line_no>
    <PLANT_Code>ENCORE</PLANT_Code>
    <Location_Code>8906050709998</Location_Code>
    <COMPANY_CODE>890605070</COMPANY_CODE>
    <PRINT_QTY>3083</PRINT_QTY>
    <Printing_Date>10/16/2023 9:05:17 PM</Printing_Date>
    <Partial_Closed_Batch_Qty>1917</Partial_Closed_Batch_Qty>
    <Fully_Closed_Batch_Qty>0</Fully_Closed_Batch_Qty>
    <ACCEPTED_QTY>2421</ACCEPTED_QTY>
    <REJECTED_AUTO_QTY>662</REJECTED_AUTO_QTY>
    <REJECTED_MANUAL_QTY>0</REJECTED_MANUAL_QTY>
    <DIGILINK>https://llq.pfizerem.in/kv/qnuiddata.aspx/01/8902393003250/10/2330116N?17=250300</DIGILINK>
    <BatchStatus>PARTIAL</BatchStatus>
    <Created_By>shubham.randad</Created_By>
  </Request>
</NewDataSet>
16-Oct-23 21:05:19	Data Response: <NewDataSet>
  <Table>
    <IsSuccessful>True</IsSuccessful>
    <Message>Success</Message>
    <MessageCode>200</MessageCode>
    <BATCH_NO>2330116N</BATCH_NO>
    <LOT_NO>2330116N</LOT_NO>
    <PLANT_CODE>ENCORE</PLANT_CODE>
  </Table>
  <Table1>
    <IsSuccessful>True</IsSuccessful>
    <Message>Success</Message>
    <MessageCode>200</MessageCode>
    <BATCH_NO>2330116N</BATCH_NO>
    <LOT_NO>2330116N</LOT_NO>
    <PLANT_CODE>ENCORE</PLANT_CODE>
  </Table1>
</NewDataSet>
16-Oct-23 21:05:19	Response JSON Data:[{"IsSuccessful":"True","Message":"Success","MessageCode":"200","BATCH_NO":"2330116N","LOT_NO":"2330116N","PLANT_CODE":"ENCORE"}]