[18 Aug 2020 00:10:33] (index) database connection response
[18 Aug 2020 00:10:33] (index) getConnection(): Resource id #1
[18 Aug 2020 00:10:33] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[18 Aug 2020 00:10:33] (index) database connection response
[18 Aug 2020 00:10:33] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[18 Aug 2020 00:10:33] (index) database connection response
[18 Aug 2020 00:10:33] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[18 Aug 2020 00:10:33] (index) database connection response
[18 Aug 2020 00:10:33] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'MO1200220612'  AND ACCESS_CODE = '96570605'
[18 Aug 2020 00:10:33] (index) database connection response
[18 Aug 2020 00:10:33] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'MO1200220612'  AND ACCESS_CODE = '96570605'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[18 Aug 2020 00:10:33] (index) database connection response
[18 Aug 2020 00:10:33] (index) getConnectionClose() called....
[18 Aug 2020 00:11:31] (index) database connection response
[18 Aug 2020 00:11:31] (index) getConnection(): Resource id #1
[18 Aug 2020 00:11:31] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[18 Aug 2020 00:11:31] (index) database connection response
[18 Aug 2020 00:11:31] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[18 Aug 2020 00:11:31] (index) database connection response
[18 Aug 2020 00:11:31] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[18 Aug 2020 00:11:31] (index) database connection response
[18 Aug 2020 00:11:31] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200220612'  AND ACCESS_CODE = '96570605'
[18 Aug 2020 00:11:31] (index) database connection response
[18 Aug 2020 00:11:31] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200220612'  AND ACCESS_CODE = '96570605'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[18 Aug 2020 00:11:31] (index) database connection response
[18 Aug 2020 00:11:31] (index) getConnectionClose() called....
[18 Aug 2020 00:12:29] (index) database connection response
[18 Aug 2020 00:12:29] (index) getConnection(): Resource id #1
[18 Aug 2020 00:12:29] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[18 Aug 2020 00:12:29] (index) database connection response
[18 Aug 2020 00:12:29] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[18 Aug 2020 00:12:29] (index) database connection response
[18 Aug 2020 00:12:29] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '13'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[18 Aug 2020 00:12:29] (index) database connection response
[18 Aug 2020 00:12:29] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200291766'  AND ACCESS_CODE = '96570605'
[18 Aug 2020 00:12:29] (index) database connection response
[18 Aug 2020 00:12:29] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200291766'  AND ACCESS_CODE = '96570605'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[18 Aug 2020 00:12:29] (index) database connection response
[18 Aug 2020 00:12:29] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000606217'
[18 Aug 2020 00:12:29] (index) database connection response
[18 Aug 2020 00:12:29] (index) getPatientReportsDetail() entered
[18 Aug 2020 00:12:29] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200291766', 'M0100000606217', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 00:12:29] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200291766', 'M0100000606217', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 00:12:29] (index) p_Stop=N
[18 Aug 2020 00:12:29] (index) p_Alert=
[18 Aug 2020 00:12:29] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID,         MRNO,       NAME,       CPT_DESC,       LIST.CPT_ID,       SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID,       PDF_FILE_PATH,       PDF_FILE_NAME,       PDF_SERVER_NAME,       EXPECTED_REPORT_DATE,       ACTUAL_REPORT_DATE,       LAST_VIEW_DATE,       ORDER_DATE,       ORDER_NO,       ORDER_TYPE_ID,       LOCATION_ID,       ORDER_LOCATION_ID,       CPT_REPORT_ID,       TRANSACTION_NO,       LIST.ORDER_STATUS_ID,       OS.DESCRIPTION  FROM  ORDERENTRY.T_REPORT_LIST  LIST  ,   ORDERENTRY.ORDER_STATUS  OS   WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID
[18 Aug 2020 00:12:29] (index) database connection response
[18 Aug 2020 00:12:29] (index) getConnectionClose() called....
[18 Aug 2020 00:12:29] (index) getConnectionClose() called....
[18 Aug 2020 00:12:40] (viewOnlineReports) database connection response
[18 Aug 2020 00:12:40] (viewOnlineReports) getConnection(): Resource id #1
[18 Aug 2020 00:12:40] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000606217', '001', '200361073', '1', '001000000000087071', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 00:12:40] (viewOnlineReports) p_Stop=N
[18 Aug 2020 00:12:40] (viewOnlineReports) p_Alert=
[18 Aug 2020 00:12:40] (viewOnlineReports) Flag = 1
[18 Aug 2020 00:12:40] (viewOnlineReports) insertRow():  INSERT INTO   CCWEB.ONLINE_REPORTS_ACCESS_HISTORY   (ORDER_TYPE_ID,    		ORDER_NO, 				LOCATION_ID,    ORDER_LOCATION_ID, 	TRANSACTION_NO, 		CPT_REPORT_ID,    PDF_FILE_NAME, 		VIEWED_BY, 				VIEWED_DATE)  VALUES   ('001',    '200361073',    'M01',    '001',    '1',    '001000000000087071',    'M0100000606217_M01MIC20005117_1.PDF',    'M0100000606217',    SYSDATE)
[18 Aug 2020 00:12:40] (viewOnlineReports) database connection response
[18 Aug 2020 00:12:40] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200361073'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '001'   AND TRANSACTION_NO 	 = '1'
[18 Aug 2020 00:12:40] (viewOnlineReports) database connection response
[18 Aug 2020 00:12:40] (viewOnlineReports) getConnectionClose() called....
[18 Aug 2020 00:12:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200361073/
[18 Aug 2020 00:12:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200361073/
[18 Aug 2020 00:12:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200720\M01\M0100000606217_M01MIC20005117_1.PDF
[18 Aug 2020 00:12:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200361073/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1597691560M0100000606217_M01MIC20005117_1.PDF
[18 Aug 2020 00:12:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200361073/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1597691560M0100000606217_M01MIC20005117_1.PDF
[18 Aug 2020 00:12:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG
[18 Aug 2020 00:12:40] (viewOnlineReports) Converting PDF to JPG with name as M0100000606217_M01MIC20005117_1.jpg
[18 Aug 2020 00:12:40] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200361073/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1597691560M0100000606217_M01MIC20005117_1.PDF ../../TEMP_PDF/200361073/M0100000606217_M01MIC20005117_1.jpg
[18 Aug 2020 00:12:40] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200361073/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1597691560M0100000606217_M01MIC20005117_1.PDF
[18 Aug 2020 00:13:00] (viewOnlineReports) database connection response
[18 Aug 2020 00:13:00] (viewOnlineReports) getConnection(): Resource id #1
[18 Aug 2020 00:13:00] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000606217', '001', '200361073', '1', '001000000000087071', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 00:13:00] (viewOnlineReports) p_Stop=N
[18 Aug 2020 00:13:00] (viewOnlineReports) p_Alert=
[18 Aug 2020 00:13:00] (viewOnlineReports) Flag = 1
[18 Aug 2020 00:13:00] (viewOnlineReports) insertRow():  INSERT INTO   CCWEB.ONLINE_REPORTS_ACCESS_HISTORY   (ORDER_TYPE_ID,    		ORDER_NO, 				LOCATION_ID,    ORDER_LOCATION_ID, 	TRANSACTION_NO, 		CPT_REPORT_ID,    PDF_FILE_NAME, 		VIEWED_BY, 				VIEWED_DATE)  VALUES   ('001',    '200361073',    'M01',    '001',    '1',    '001000000000087071',    'M0100000606217_M01MIC20005117_1.PDF',    'M0100000606217',    SYSDATE)
[18 Aug 2020 00:13:00] (viewOnlineReports) database connection response
[18 Aug 2020 00:13:00] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200361073'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '001'   AND TRANSACTION_NO 	 = '1'
[18 Aug 2020 00:13:00] (viewOnlineReports) database connection response
[18 Aug 2020 00:13:00] (viewOnlineReports) getConnectionClose() called....
[18 Aug 2020 00:13:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200361073/
[18 Aug 2020 00:13:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200361073/
[18 Aug 2020 00:13:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200720\M01\M0100000606217_M01MIC20005117_1.PDF
[18 Aug 2020 00:13:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200361073/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1597691580M0100000606217_M01MIC20005117_1.PDF
[18 Aug 2020 00:13:01] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200361073/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1597691580M0100000606217_M01MIC20005117_1.PDF
[18 Aug 2020 00:13:01] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD
[18 Aug 2020 00:13:01] (viewOnlineReports) Downloading file ../../TEMP_PDF/200361073/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1597691580M0100000606217_M01MIC20005117_1.PDF
[18 Aug 2020 00:21:23] (index) database connection response
[18 Aug 2020 00:21:23] (index) getConnection(): Resource id #1
[18 Aug 2020 00:21:23] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[18 Aug 2020 00:21:23] (index) database connection response
[18 Aug 2020 00:21:23] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[18 Aug 2020 00:21:23] (index) database connection response
[18 Aug 2020 00:21:23] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[18 Aug 2020 00:21:23] (index) database connection response
[18 Aug 2020 00:21:23] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200333546'  AND ACCESS_CODE = '76411096'
[18 Aug 2020 00:21:23] (index) database connection response
[18 Aug 2020 00:21:23] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200333546'  AND ACCESS_CODE = '76411096'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[18 Aug 2020 00:21:23] (index) database connection response
[18 Aug 2020 00:21:23] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000630330'
[18 Aug 2020 00:21:23] (index) database connection response
[18 Aug 2020 00:21:23] (index) getPatientReportsDetail() entered
[18 Aug 2020 00:21:23] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200333546', 'M0100000630330', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 00:21:23] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200333546', 'M0100000630330', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 00:21:23] (index) p_Stop=N
[18 Aug 2020 00:21:23] (index) p_Alert=
[18 Aug 2020 00:21:23] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID,         MRNO,       NAME,       CPT_DESC,       LIST.CPT_ID,       SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID,       PDF_FILE_PATH,       PDF_FILE_NAME,       PDF_SERVER_NAME,       EXPECTED_REPORT_DATE,       ACTUAL_REPORT_DATE,       LAST_VIEW_DATE,       ORDER_DATE,       ORDER_NO,       ORDER_TYPE_ID,       LOCATION_ID,       ORDER_LOCATION_ID,       CPT_REPORT_ID,       TRANSACTION_NO,       LIST.ORDER_STATUS_ID,       OS.DESCRIPTION  FROM  ORDERENTRY.T_REPORT_LIST  LIST  ,   ORDERENTRY.ORDER_STATUS  OS   WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID
[18 Aug 2020 00:21:23] (index) database connection response
[18 Aug 2020 00:21:23] (index) getConnectionClose() called....
[18 Aug 2020 00:21:23] (index) getConnectionClose() called....
[18 Aug 2020 02:10:59] (index) database connection response
[18 Aug 2020 02:10:59] (index) getConnection(): Resource id #1
[18 Aug 2020 02:10:59] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[18 Aug 2020 02:10:59] (index) database connection response
[18 Aug 2020 02:10:59] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[18 Aug 2020 02:10:59] (index) database connection response
[18 Aug 2020 02:10:59] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[18 Aug 2020 02:10:59] (index) database connection response
[18 Aug 2020 02:10:59] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200333546'  AND ACCESS_CODE = '76411096'
[18 Aug 2020 02:10:59] (index) database connection response
[18 Aug 2020 02:10:59] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200333546'  AND ACCESS_CODE = '76411096'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[18 Aug 2020 02:10:59] (index) database connection response
[18 Aug 2020 02:10:59] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000630330'
[18 Aug 2020 02:10:59] (index) database connection response
[18 Aug 2020 02:10:59] (index) getPatientReportsDetail() entered
[18 Aug 2020 02:10:59] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200333546', 'M0100000630330', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 02:10:59] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200333546', 'M0100000630330', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 02:10:59] (index) p_Stop=N
[18 Aug 2020 02:10:59] (index) p_Alert=
[18 Aug 2020 02:10:59] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID,         MRNO,       NAME,       CPT_DESC,       LIST.CPT_ID,       SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID,       PDF_FILE_PATH,       PDF_FILE_NAME,       PDF_SERVER_NAME,       EXPECTED_REPORT_DATE,       ACTUAL_REPORT_DATE,       LAST_VIEW_DATE,       ORDER_DATE,       ORDER_NO,       ORDER_TYPE_ID,       LOCATION_ID,       ORDER_LOCATION_ID,       CPT_REPORT_ID,       TRANSACTION_NO,       LIST.ORDER_STATUS_ID,       OS.DESCRIPTION  FROM  ORDERENTRY.T_REPORT_LIST  LIST  ,   ORDERENTRY.ORDER_STATUS  OS   WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID
[18 Aug 2020 02:10:59] (index) database connection response
[18 Aug 2020 02:10:59] (index) getConnectionClose() called....
[18 Aug 2020 02:10:59] (index) getConnectionClose() called....
[18 Aug 2020 02:11:06] (viewOnlineReports) database connection response
[18 Aug 2020 02:11:06] (viewOnlineReports) getConnection(): Resource id #1
[18 Aug 2020 02:11:06] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000630330', '001', '200372004', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 02:11:06] (viewOnlineReports) p_Stop=N
[18 Aug 2020 02:11:06] (viewOnlineReports) p_Alert=
[18 Aug 2020 02:11:06] (viewOnlineReports) Flag = 1
[18 Aug 2020 02:11:06] (viewOnlineReports) insertRow():  INSERT INTO   CCWEB.ONLINE_REPORTS_ACCESS_HISTORY   (ORDER_TYPE_ID,    		ORDER_NO, 				LOCATION_ID,    ORDER_LOCATION_ID, 	TRANSACTION_NO, 		CPT_REPORT_ID,    PDF_FILE_NAME, 		VIEWED_BY, 				VIEWED_DATE)  VALUES   ('001',    '200372004',    'M01',    '070',    '1',    '001000000000087630',    'M0100000630330_M01MOL20007191_1.PDF',    'M0100000630330',    SYSDATE)
[18 Aug 2020 02:11:06] (viewOnlineReports) database connection response
[18 Aug 2020 02:11:06] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200372004'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '070'   AND TRANSACTION_NO 	 = '1'
[18 Aug 2020 02:11:06] (viewOnlineReports) database connection response
[18 Aug 2020 02:11:06] (viewOnlineReports) getConnectionClose() called....
[18 Aug 2020 02:11:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372004/
[18 Aug 2020 02:11:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372004/
[18 Aug 2020 02:11:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200817\M01\M0100000630330_M01MOL20007191_1.PDF
[18 Aug 2020 02:11:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372004/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1597698666M0100000630330_M01MOL20007191_1.PDF
[18 Aug 2020 02:11:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372004/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1597698666M0100000630330_M01MOL20007191_1.PDF
[18 Aug 2020 02:11:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[18 Aug 2020 02:11:06] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200372004/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1597698666M0100000630330_M01MOL20007191_1.PDF
[18 Aug 2020 02:11:17] (viewOnlineReports) database connection response
[18 Aug 2020 02:11:17] (viewOnlineReports) getConnection(): Resource id #1
[18 Aug 2020 02:11:17] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000630330', '001', '200372004', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 02:11:17] (viewOnlineReports) p_Stop=N
[18 Aug 2020 02:11:17] (viewOnlineReports) p_Alert=
[18 Aug 2020 02:11:17] (viewOnlineReports) Flag = 1
[18 Aug 2020 02:11:17] (viewOnlineReports) insertRow():  INSERT INTO   CCWEB.ONLINE_REPORTS_ACCESS_HISTORY   (ORDER_TYPE_ID,    		ORDER_NO, 				LOCATION_ID,    ORDER_LOCATION_ID, 	TRANSACTION_NO, 		CPT_REPORT_ID,    PDF_FILE_NAME, 		VIEWED_BY, 				VIEWED_DATE)  VALUES   ('001',    '200372004',    'M01',    '070',    '1',    '001000000000087630',    'M0100000630330_M01MOL20007191_1.PDF',    'M0100000630330',    SYSDATE)
[18 Aug 2020 02:11:17] (viewOnlineReports) database connection response
[18 Aug 2020 02:11:17] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200372004'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '070'   AND TRANSACTION_NO 	 = '1'
[18 Aug 2020 02:11:17] (viewOnlineReports) database connection response
[18 Aug 2020 02:11:17] (viewOnlineReports) getConnectionClose() called....
[18 Aug 2020 02:11:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372004/
[18 Aug 2020 02:11:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372004/
[18 Aug 2020 02:11:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200817\M01\M0100000630330_M01MOL20007191_1.PDF
[18 Aug 2020 02:11:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372004/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1597698677M0100000630330_M01MOL20007191_1.PDF
[18 Aug 2020 02:11:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372004/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1597698677M0100000630330_M01MOL20007191_1.PDF
[18 Aug 2020 02:11:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD
[18 Aug 2020 02:11:17] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372004/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1597698677M0100000630330_M01MOL20007191_1.PDF
[18 Aug 2020 10:44:51] (index) database connection response
[18 Aug 2020 10:44:51] (index) getConnection(): Resource id #1
[18 Aug 2020 10:44:51] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[18 Aug 2020 10:44:51] (index) database connection response
[18 Aug 2020 10:44:51] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[18 Aug 2020 10:44:51] (index) database connection response
[18 Aug 2020 10:44:51] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[18 Aug 2020 10:44:51] (index) database connection response
[18 Aug 2020 10:44:51] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = '630319'  AND ACCESS_CODE = '54522890'
[18 Aug 2020 10:44:51] (index) database connection response
[18 Aug 2020 10:44:51] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = '630319'  AND ACCESS_CODE = '54522890'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[18 Aug 2020 10:44:51] (index) database connection response
[18 Aug 2020 10:44:51] (index) getConnectionClose() called....
[18 Aug 2020 10:46:08] (index) database connection response
[18 Aug 2020 10:46:08] (index) getConnection(): Resource id #1
[18 Aug 2020 10:46:08] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[18 Aug 2020 10:46:08] (index) database connection response
[18 Aug 2020 10:46:08] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[18 Aug 2020 10:46:08] (index) database connection response
[18 Aug 2020 10:46:08] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[18 Aug 2020 10:46:08] (index) database connection response
[18 Aug 2020 10:46:08] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200333473'  AND ACCESS_CODE = '44522890'
[18 Aug 2020 10:46:08] (index) database connection response
[18 Aug 2020 10:46:08] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200333473'  AND ACCESS_CODE = '44522890'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[18 Aug 2020 10:46:08] (index) database connection response
[18 Aug 2020 10:46:08] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000630319'
[18 Aug 2020 10:46:08] (index) database connection response
[18 Aug 2020 10:46:08] (index) getPatientReportsDetail() entered
[18 Aug 2020 10:46:08] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200333473', 'M0100000630319', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 10:46:08] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200333473', 'M0100000630319', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 10:46:08] (index) p_Stop=N
[18 Aug 2020 10:46:08] (index) p_Alert=
[18 Aug 2020 10:46:08] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID,         MRNO,       NAME,       CPT_DESC,       LIST.CPT_ID,       SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID,       PDF_FILE_PATH,       PDF_FILE_NAME,       PDF_SERVER_NAME,       EXPECTED_REPORT_DATE,       ACTUAL_REPORT_DATE,       LAST_VIEW_DATE,       ORDER_DATE,       ORDER_NO,       ORDER_TYPE_ID,       LOCATION_ID,       ORDER_LOCATION_ID,       CPT_REPORT_ID,       TRANSACTION_NO,       LIST.ORDER_STATUS_ID,       OS.DESCRIPTION  FROM  ORDERENTRY.T_REPORT_LIST  LIST  ,   ORDERENTRY.ORDER_STATUS  OS   WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID
[18 Aug 2020 10:46:09] (index) database connection response
[18 Aug 2020 10:46:09] (index) getConnectionClose() called....
[18 Aug 2020 10:46:09] (index) getConnectionClose() called....
[18 Aug 2020 10:51:44] (viewOnlineReports) database connection response
[18 Aug 2020 10:51:44] (viewOnlineReports) getConnection(): Resource id #1
[18 Aug 2020 10:51:44] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000630319', '001', '200371975', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 10:51:44] (viewOnlineReports) p_Stop=N
[18 Aug 2020 10:51:44] (viewOnlineReports) p_Alert=
[18 Aug 2020 10:51:44] (viewOnlineReports) Flag = 1
[18 Aug 2020 10:51:44] (viewOnlineReports) insertRow():  INSERT INTO   CCWEB.ONLINE_REPORTS_ACCESS_HISTORY   (ORDER_TYPE_ID,    		ORDER_NO, 				LOCATION_ID,    ORDER_LOCATION_ID, 	TRANSACTION_NO, 		CPT_REPORT_ID,    PDF_FILE_NAME, 		VIEWED_BY, 				VIEWED_DATE)  VALUES   ('001',    '200371975',    'M01',    '070',    '1',    '001000000000087630',    'M0100000630319_M01MOL20007193_1.PDF',    'M0100000630319',    SYSDATE)
[18 Aug 2020 10:51:44] (viewOnlineReports) database connection response
[18 Aug 2020 10:51:44] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371975'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '070'   AND TRANSACTION_NO 	 = '1'
[18 Aug 2020 10:51:44] (viewOnlineReports) database connection response
[18 Aug 2020 10:51:44] (viewOnlineReports) getConnectionClose() called....
[18 Aug 2020 10:51:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371975/
[18 Aug 2020 10:51:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371975/
[18 Aug 2020 10:51:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200817\M01\M0100000630319_M01MOL20007193_1.PDF
[18 Aug 2020 10:51:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371975/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1597729904M0100000630319_M01MOL20007193_1.PDF
[18 Aug 2020 10:51:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371975/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1597729904M0100000630319_M01MOL20007193_1.PDF
[18 Aug 2020 10:51:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD
[18 Aug 2020 10:51:44] (viewOnlineReports) Downloading file ../../TEMP_PDF/200371975/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1597729904M0100000630319_M01MOL20007193_1.PDF
[18 Aug 2020 15:31:58] (index) database connection response
[18 Aug 2020 15:31:58] (index) getConnection(): Resource id #1
[18 Aug 2020 15:31:58] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[18 Aug 2020 15:31:59] (index) database connection response
[18 Aug 2020 15:31:59] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[18 Aug 2020 15:31:59] (index) database connection response
[18 Aug 2020 15:31:59] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[18 Aug 2020 15:31:59] (index) database connection response
[18 Aug 2020 15:31:59] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200333541'  AND ACCESS_CODE = '10947686'
[18 Aug 2020 15:31:59] (index) database connection response
[18 Aug 2020 15:31:59] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200333541'  AND ACCESS_CODE = '10947686'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[18 Aug 2020 15:31:59] (index) database connection response
[18 Aug 2020 15:31:59] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000049668'
[18 Aug 2020 15:31:59] (index) database connection response
[18 Aug 2020 15:31:59] (index) getPatientReportsDetail() entered
[18 Aug 2020 15:31:59] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200333541', 'M0100000049668', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 15:31:59] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200333541', 'M0100000049668', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 15:31:59] (index) p_Stop=N
[18 Aug 2020 15:31:59] (index) p_Alert=
[18 Aug 2020 15:31:59] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID,         MRNO,       NAME,       CPT_DESC,       LIST.CPT_ID,       SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID,       PDF_FILE_PATH,       PDF_FILE_NAME,       PDF_SERVER_NAME,       EXPECTED_REPORT_DATE,       ACTUAL_REPORT_DATE,       LAST_VIEW_DATE,       ORDER_DATE,       ORDER_NO,       ORDER_TYPE_ID,       LOCATION_ID,       ORDER_LOCATION_ID,       CPT_REPORT_ID,       TRANSACTION_NO,       LIST.ORDER_STATUS_ID,       OS.DESCRIPTION  FROM  ORDERENTRY.T_REPORT_LIST  LIST  ,   ORDERENTRY.ORDER_STATUS  OS   WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID
[18 Aug 2020 15:31:59] (index) database connection response
[18 Aug 2020 15:31:59] (index) getConnectionClose() called....
[18 Aug 2020 15:31:59] (index) getConnectionClose() called....
[18 Aug 2020 15:32:07] (viewOnlineReports) database connection response
[18 Aug 2020 15:32:07] (viewOnlineReports) getConnection(): Resource id #1
[18 Aug 2020 15:32:07] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000049668', '001', '200372002', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[18 Aug 2020 15:32:07] (viewOnlineReports) p_Stop=N
[18 Aug 2020 15:32:07] (viewOnlineReports) p_Alert=
[18 Aug 2020 15:32:07] (viewOnlineReports) Flag = 1
[18 Aug 2020 15:32:07] (viewOnlineReports) insertRow():  INSERT INTO   CCWEB.ONLINE_REPORTS_ACCESS_HISTORY   (ORDER_TYPE_ID,    		ORDER_NO, 				LOCATION_ID,    ORDER_LOCATION_ID, 	TRANSACTION_NO, 		CPT_REPORT_ID,    PDF_FILE_NAME, 		VIEWED_BY, 				VIEWED_DATE)  VALUES   ('001',    '200372002',    'M01',    '070',    '1',    '001000000000087630',    'M0100000049668_M01MOL20007192_1.PDF',    'M0100000049668',    SYSDATE)
[18 Aug 2020 15:32:07] (viewOnlineReports) database connection response
[18 Aug 2020 15:32:07] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200372002'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '070'   AND TRANSACTION_NO 	 = '1'
[18 Aug 2020 15:32:07] (viewOnlineReports) database connection response
[18 Aug 2020 15:32:07] (viewOnlineReports) getConnectionClose() called....
[18 Aug 2020 15:32:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372002/
[18 Aug 2020 15:32:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372002/
[18 Aug 2020 15:32:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200817\M01\M0100000049668_M01MOL20007192_1.PDF
[18 Aug 2020 15:32:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372002/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1597746727M0100000049668_M01MOL20007192_1.PDF
[18 Aug 2020 15:32:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372002/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1597746727M0100000049668_M01MOL20007192_1.PDF
[18 Aug 2020 15:32:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[18 Aug 2020 15:32:07] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200372002/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1597746727M0100000049668_M01MOL20007192_1.PDF