[14 Aug 2020 11:35:30] (index) database connection response
[14 Aug 2020 11:35:30] (index) getConnection(): Resource id #1
[14 Aug 2020 11:35:30] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[14 Aug 2020 11:35:30] (index) database connection response
[14 Aug 2020 11:35:30] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[14 Aug 2020 11:35:30] (index) database connection response
[14 Aug 2020 11:35:30] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[14 Aug 2020 11:35:30] (index) database connection response
[14 Aug 2020 11:35:30] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200329183'  AND ACCESS_CODE = '85710092'
[14 Aug 2020 11:35:30] (index) database connection response
[14 Aug 2020 11:35:30] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200329183'  AND ACCESS_CODE = '85710092'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[14 Aug 2020 11:35:30] (index) database connection response
[14 Aug 2020 11:35:30] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0160100004392'
[14 Aug 2020 11:35:30] (index) database connection response
[14 Aug 2020 11:35:30] (index) getPatientReportsDetail() entered
[14 Aug 2020 11:35:30] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200329183', 'M0160100004392', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 11:35:30] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200329183', 'M0160100004392', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 11:35:30] (index) p_Stop=Y
[14 Aug 2020 11:35:30] (index) p_Alert=Patient is confidential.  
You have no rights to view this EMR.
[14 Aug 2020 11:35:30] (index) getConnectionClose() called....
[14 Aug 2020 17:44:32] (index) database connection response
[14 Aug 2020 17:44:32] (index) getConnection(): Resource id #1
[14 Aug 2020 17:44:32] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[14 Aug 2020 17:44:32] (index) database connection response
[14 Aug 2020 17:44:32] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[14 Aug 2020 17:44:32] (index) database connection response
[14 Aug 2020 17:44:32] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[14 Aug 2020 17:44:32] (index) database connection response
[14 Aug 2020 17:44:32] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200329911'  AND ACCESS_CODE = '33206625'
[14 Aug 2020 17:44:32] (index) database connection response
[14 Aug 2020 17:44:32] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200329911'  AND ACCESS_CODE = '33206625'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[14 Aug 2020 17:44:32] (index) database connection response
[14 Aug 2020 17:44:32] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000613090'
[14 Aug 2020 17:44:32] (index) database connection response
[14 Aug 2020 17:44:32] (index) getPatientReportsDetail() entered
[14 Aug 2020 17:44:32] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200329911', 'M0100000613090', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:44:32] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200329911', 'M0100000613090', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:44:32] (index) p_Stop=N
[14 Aug 2020 17:44:32] (index) p_Alert=
[14 Aug 2020 17:44:32] (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
[14 Aug 2020 17:44:32] (index) database connection response
[14 Aug 2020 17:44:32] (index) getConnectionClose() called....
[14 Aug 2020 17:44:32] (index) getConnectionClose() called....
[14 Aug 2020 17:45:08] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:08] (viewOnlineReports) getConnection(): Resource id #1
[14 Aug 2020 17:45:08] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000613090', '001', '200371206', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:45:08] (viewOnlineReports) p_Stop=N
[14 Aug 2020 17:45:08] (viewOnlineReports) p_Alert=
[14 Aug 2020 17:45:08] (viewOnlineReports) Flag = 1
[14 Aug 2020 17:45:08] (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',    '200371206',    'M01',    '027',    '2',    '001000000000084443',    'M0100000613090_M01SCH20008158_4.PDF',    'M0100000613090',    SYSDATE)
[14 Aug 2020 17:45:08] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:08] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371206'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '027'   AND TRANSACTION_NO 	 = '2'
[14 Aug 2020 17:45:08] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:08] (viewOnlineReports) getConnectionClose() called....
[14 Aug 2020 17:45:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371206/
[14 Aug 2020 17:45:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371206/
[14 Aug 2020 17:45:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200814\M01\M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371206/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1597409108M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371206/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1597409108M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[14 Aug 2020 17:45:08] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200371206/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1597409108M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:22] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:22] (viewOnlineReports) getConnection(): Resource id #1
[14 Aug 2020 17:45:22] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000613090', '001', '200371206', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:45:22] (viewOnlineReports) p_Stop=N
[14 Aug 2020 17:45:22] (viewOnlineReports) p_Alert=
[14 Aug 2020 17:45:22] (viewOnlineReports) Flag = 1
[14 Aug 2020 17:45:22] (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',    '200371206',    'M01',    '027',    '2',    '001000000000084443',    'M0100000613090_M01SCH20008158_4.PDF',    'M0100000613090',    SYSDATE)
[14 Aug 2020 17:45:22] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:22] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371206'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '027'   AND TRANSACTION_NO 	 = '2'
[14 Aug 2020 17:45:22] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:22] (viewOnlineReports) getConnectionClose() called....
[14 Aug 2020 17:45:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371206/
[14 Aug 2020 17:45:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371206/
[14 Aug 2020 17:45:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200814\M01\M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371206/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1597409122M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371206/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1597409122M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[14 Aug 2020 17:45:23] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200371206/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1597409122M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:31] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:31] (viewOnlineReports) getConnection(): Resource id #1
[14 Aug 2020 17:45:31] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000613090', '001', '200371206', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:45:31] (viewOnlineReports) p_Stop=N
[14 Aug 2020 17:45:31] (viewOnlineReports) p_Alert=
[14 Aug 2020 17:45:31] (viewOnlineReports) Flag = 1
[14 Aug 2020 17:45:31] (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',    '200371206',    'M01',    '027',    '2',    '001000000000084443',    'M0100000613090_M01SCH20008158_4.PDF',    'M0100000613090',    SYSDATE)
[14 Aug 2020 17:45:31] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:31] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371206'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '027'   AND TRANSACTION_NO 	 = '2'
[14 Aug 2020 17:45:31] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:31] (viewOnlineReports) getConnectionClose() called....
[14 Aug 2020 17:45:31] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371206/
[14 Aug 2020 17:45:31] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371206/
[14 Aug 2020 17:45:31] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200814\M01\M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:31] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371206/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1597409131M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:31] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371206/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1597409131M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:31] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER
[14 Aug 2020 17:45:31] (viewOnlineReports) Converting PDF to JPG with name as M0100000613090_M01SCH20008158_4.jpg
[14 Aug 2020 17:45:31] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200371206/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1597409131M0100000613090_M01SCH20008158_4.PDF ../../TEMP_PDF/200371206/M0100000613090_M01SCH20008158_4.jpg
[14 Aug 2020 17:45:31] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200371206/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1597409131M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:42] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:42] (viewOnlineReports) getConnection(): Resource id #1
[14 Aug 2020 17:45:42] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000613090', '001', '200371206', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:45:42] (viewOnlineReports) p_Stop=N
[14 Aug 2020 17:45:42] (viewOnlineReports) p_Alert=
[14 Aug 2020 17:45:42] (viewOnlineReports) Flag = 1
[14 Aug 2020 17:45:42] (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',    '200371206',    'M01',    '027',    '2',    '001000000000084443',    'M0100000613090_M01SCH20008158_4.PDF',    'M0100000613090',    SYSDATE)
[14 Aug 2020 17:45:42] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:42] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371206'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '027'   AND TRANSACTION_NO 	 = '2'
[14 Aug 2020 17:45:42] (viewOnlineReports) database connection response
[14 Aug 2020 17:45:42] (viewOnlineReports) getConnectionClose() called....
[14 Aug 2020 17:45:42] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371206/
[14 Aug 2020 17:45:42] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371206/
[14 Aug 2020 17:45:42] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200814\M01\M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:42] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371206/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597409142M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:42] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371206/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597409142M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:45:42] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER
[14 Aug 2020 17:45:42] (viewOnlineReports) Converting PDF to JPG with name as M0100000613090_M01SCH20008158_4.jpg
[14 Aug 2020 17:45:42] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200371206/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597409142M0100000613090_M01SCH20008158_4.PDF ../../TEMP_PDF/200371206/M0100000613090_M01SCH20008158_4.jpg
[14 Aug 2020 17:45:42] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200371206/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597409142M0100000613090_M01SCH20008158_4.PDF
[14 Aug 2020 17:46:14] (viewOnlineReports) database connection response
[14 Aug 2020 17:46:14] (viewOnlineReports) getConnection(): Resource id #1
[14 Aug 2020 17:46:14] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000613090', '001', '200371206', '3', '001000000000083001', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:46:14] (viewOnlineReports) p_Stop=N
[14 Aug 2020 17:46:14] (viewOnlineReports) p_Alert=
[14 Aug 2020 17:46:14] (viewOnlineReports) Flag = 1
[14 Aug 2020 17:46:14] (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',    '200371206',    'M01',    '027',    '3',    '001000000000083001',    'M0100000613090_M01SCH20008158_1.PDF',    'M0100000613090',    SYSDATE)
[14 Aug 2020 17:46:14] (viewOnlineReports) database connection response
[14 Aug 2020 17:46:14] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371206'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '027'   AND TRANSACTION_NO 	 = '3'
[14 Aug 2020 17:46:14] (viewOnlineReports) database connection response
[14 Aug 2020 17:46:14] (viewOnlineReports) getConnectionClose() called....
[14 Aug 2020 17:46:14] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371206/
[14 Aug 2020 17:46:14] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371206/
[14 Aug 2020 17:46:14] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200814\M01\M0100000613090_M01SCH20008158_1.PDF
[14 Aug 2020 17:46:14] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371206/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1597409174M0100000613090_M01SCH20008158_1.PDF
[14 Aug 2020 17:46:14] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371206/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1597409174M0100000613090_M01SCH20008158_1.PDF
[14 Aug 2020 17:46:14] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER
[14 Aug 2020 17:46:14] (viewOnlineReports) Converting PDF to JPG with name as M0100000613090_M01SCH20008158_1.jpg
[14 Aug 2020 17:46:14] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200371206/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1597409174M0100000613090_M01SCH20008158_1.PDF ../../TEMP_PDF/200371206/M0100000613090_M01SCH20008158_1.jpg
[14 Aug 2020 17:46:14] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200371206/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1597409174M0100000613090_M01SCH20008158_1.PDF
[14 Aug 2020 17:46:46] (viewOnlineReports) database connection response
[14 Aug 2020 17:46:46] (viewOnlineReports) getConnection(): Resource id #1
[14 Aug 2020 17:46:46] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000613090', '001', '200371206', '4', '001000000000083002', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:46:46] (viewOnlineReports) p_Stop=N
[14 Aug 2020 17:46:46] (viewOnlineReports) p_Alert=
[14 Aug 2020 17:46:46] (viewOnlineReports) Flag = 1
[14 Aug 2020 17:46:46] (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',    '200371206',    'M01',    '027',    '4',    '001000000000083002',    'M0100000613090_M01SCH20008158_2.PDF',    'M0100000613090',    SYSDATE)
[14 Aug 2020 17:46:46] (viewOnlineReports) database connection response
[14 Aug 2020 17:46:46] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371206'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '027'   AND TRANSACTION_NO 	 = '4'
[14 Aug 2020 17:46:46] (viewOnlineReports) database connection response
[14 Aug 2020 17:46:46] (viewOnlineReports) getConnectionClose() called....
[14 Aug 2020 17:46:46] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371206/
[14 Aug 2020 17:46:46] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371206/
[14 Aug 2020 17:46:46] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200814\M01\M0100000613090_M01SCH20008158_2.PDF
[14 Aug 2020 17:46:46] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371206/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1597409206M0100000613090_M01SCH20008158_2.PDF
[14 Aug 2020 17:46:46] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371206/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1597409206M0100000613090_M01SCH20008158_2.PDF
[14 Aug 2020 17:46:46] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER
[14 Aug 2020 17:46:46] (viewOnlineReports) Converting PDF to JPG with name as M0100000613090_M01SCH20008158_2.jpg
[14 Aug 2020 17:46:46] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200371206/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1597409206M0100000613090_M01SCH20008158_2.PDF ../../TEMP_PDF/200371206/M0100000613090_M01SCH20008158_2.jpg
[14 Aug 2020 17:46:46] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200371206/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1597409206M0100000613090_M01SCH20008158_2.PDF
[14 Aug 2020 17:47:15] (viewOnlineReports) database connection response
[14 Aug 2020 17:47:15] (viewOnlineReports) getConnection(): Resource id #1
[14 Aug 2020 17:47:15] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000613090', '001', '200371206', '5', '001000000000084146', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 17:47:15] (viewOnlineReports) p_Stop=N
[14 Aug 2020 17:47:15] (viewOnlineReports) p_Alert=
[14 Aug 2020 17:47:15] (viewOnlineReports) Flag = 1
[14 Aug 2020 17:47:15] (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',    '200371206',    'M01',    '027',    '5',    '001000000000084146',    'M0100000613090_M01SCH20008158_3.PDF',    'M0100000613090',    SYSDATE)
[14 Aug 2020 17:47:15] (viewOnlineReports) database connection response
[14 Aug 2020 17:47:15] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371206'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '027'   AND TRANSACTION_NO 	 = '5'
[14 Aug 2020 17:47:15] (viewOnlineReports) database connection response
[14 Aug 2020 17:47:15] (viewOnlineReports) getConnectionClose() called....
[14 Aug 2020 17:47:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371206/
[14 Aug 2020 17:47:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371206/
[14 Aug 2020 17:47:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200814\M01\M0100000613090_M01SCH20008158_3.PDF
[14 Aug 2020 17:47:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371206/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1597409235M0100000613090_M01SCH20008158_3.PDF
[14 Aug 2020 17:47:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371206/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1597409235M0100000613090_M01SCH20008158_3.PDF
[14 Aug 2020 17:47:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER
[14 Aug 2020 17:47:15] (viewOnlineReports) Converting PDF to JPG with name as M0100000613090_M01SCH20008158_3.jpg
[14 Aug 2020 17:47:15] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200371206/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1597409235M0100000613090_M01SCH20008158_3.PDF ../../TEMP_PDF/200371206/M0100000613090_M01SCH20008158_3.jpg
[14 Aug 2020 17:47:15] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200371206/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1597409235M0100000613090_M01SCH20008158_3.PDF
[14 Aug 2020 18:43:37] (viewOnlineReports) database connection response
[14 Aug 2020 18:43:37] (viewOnlineReports) getConnection(): Resource id #1
[14 Aug 2020 18:43:37] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', '00100000000000', '001', '200371206', '3', '001000000000083001', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 18:43:37] (viewOnlineReports) p_Stop=N
[14 Aug 2020 18:43:37] (viewOnlineReports) p_Alert=
[14 Aug 2020 18:43:37] (viewOnlineReports) Flag = 1
[14 Aug 2020 18:43:37] (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',    '200371206',    'M01',    '027',    '3',    '001000000000083001',    'M0100000613090_M01SCH20008158_1.PDF',    '00100000000000',    SYSDATE)
[14 Aug 2020 18:43:37] (viewOnlineReports) database connection response
[14 Aug 2020 18:43:37] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200371206'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '027'   AND TRANSACTION_NO 	 = '3'
[14 Aug 2020 18:43:37] (viewOnlineReports) database connection response
[14 Aug 2020 18:43:37] (viewOnlineReports) getConnectionClose() called....
[14 Aug 2020 18:43:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200371206/
[14 Aug 2020 18:43:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200371206/
[14 Aug 2020 18:43:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200814\M01\M0100000613090_M01SCH20008158_1.PDF
[14 Aug 2020 18:43:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200371206/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000613090_M01SCH20008158_1.PDF
[14 Aug 2020 18:43:37] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200371206/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000613090_M01SCH20008158_1.PDF
[14 Aug 2020 18:43:37] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER
[14 Aug 2020 18:43:37] (viewOnlineReports) Converting PDF to JPG with name as M0100000613090_M01SCH20008158_1.jpg
[14 Aug 2020 18:43:37] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200371206/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000613090_M01SCH20008158_1.PDF ../../TEMP_PDF/200371206/M0100000613090_M01SCH20008158_1.jpg
[14 Aug 2020 18:43:37] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200371206/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000613090_M01SCH20008158_1.PDF
[14 Aug 2020 18:44:09] (index) database connection response
[14 Aug 2020 18:44:09] (index) getConnection(): Resource id #1
[14 Aug 2020 18:44:09] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[14 Aug 2020 18:44:09] (index) database connection response
[14 Aug 2020 18:44:09] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[14 Aug 2020 18:44:09] (index) database connection response
[14 Aug 2020 18:44:09] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[14 Aug 2020 18:44:09] (index) database connection response
[14 Aug 2020 18:44:09] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200329911'  AND ACCESS_CODE = '33206625'
[14 Aug 2020 18:44:09] (index) database connection response
[14 Aug 2020 18:44:09] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200329911'  AND ACCESS_CODE = '33206625'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[14 Aug 2020 18:44:09] (index) database connection response
[14 Aug 2020 18:44:09] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000613090'
[14 Aug 2020 18:44:09] (index) database connection response
[14 Aug 2020 18:44:09] (index) getPatientReportsDetail() entered
[14 Aug 2020 18:44:09] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200329911', 'M0100000613090', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 18:44:09] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200329911', 'M0100000613090', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[14 Aug 2020 18:44:09] (index) p_Stop=N
[14 Aug 2020 18:44:09] (index) p_Alert=
[14 Aug 2020 18:44:09] (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
[14 Aug 2020 18:44:09] (index) database connection response
[14 Aug 2020 18:44:09] (index) getConnectionClose() called....
[14 Aug 2020 18:44:09] (index) getConnectionClose() called....