[25 Oct 2020 11:21:06] (index) database connection response
[25 Oct 2020 11:21:06] (index) getConnection(): Resource id #12
[25 Oct 2020 11:21:06] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[25 Oct 2020 11:21:06] (index) database connection response
[25 Oct 2020 11:21:06] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[25 Oct 2020 11:21:06] (index) database connection response
[25 Oct 2020 11:21:06] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[25 Oct 2020 11:21:06] (index) database connection response
[25 Oct 2020 11:21:06] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = '00639912'  AND ACCESS_CODE = '50102133'
[25 Oct 2020 11:21:06] (index) database connection response
[25 Oct 2020 11:21:06] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = '00639912'  AND ACCESS_CODE = '50102133'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[25 Oct 2020 11:21:06] (index) database connection response
[25 Oct 2020 11:21:06] (index) getConnectionClose() called....
[25 Oct 2020 11:21:50] (index) database connection response
[25 Oct 2020 11:21:50] (index) getConnection(): Resource id #1
[25 Oct 2020 11:21:50] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[25 Oct 2020 11:21:50] (index) database connection response
[25 Oct 2020 11:21:50] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[25 Oct 2020 11:21:50] (index) database connection response
[25 Oct 2020 11:21:50] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[25 Oct 2020 11:21:50] (index) database connection response
[25 Oct 2020 11:21:50] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456440'  AND ACCESS_CODE = '50102133'
[25 Oct 2020 11:21:50] (index) database connection response
[25 Oct 2020 11:21:50] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456440'  AND ACCESS_CODE = '50102133'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[25 Oct 2020 11:21:50] (index) database connection response
[25 Oct 2020 11:21:50] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000639912'
[25 Oct 2020 11:21:50] (index) database connection response
[25 Oct 2020 11:21:50] (index) getPatientReportsDetail() entered
[25 Oct 2020 11:21:50] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200456440', 'M0100000639912', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:21:50] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200456440', 'M0100000639912', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:21:50] (index) p_Stop=N
[25 Oct 2020 11:21:50] (index) p_Alert=
[25 Oct 2020 11:21:50] (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
[25 Oct 2020 11:21:50] (index) database connection response
[25 Oct 2020 11:21:50] (index) getConnectionClose() called....
[25 Oct 2020 11:21:50] (index) getConnectionClose() called....
[25 Oct 2020 11:22:54] (viewOnlineReports) database connection response
[25 Oct 2020 11:22:54] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:22:54] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639912', '001', '200410630', '1', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:22:54] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:22:54] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:22:54] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:22:54] (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',    '200410630',    'M01',    '047',    '1',    '001000000000086900',    'M0100000639912_M01BBK20002496_1.PDF',    'M0100000639912',    SYSDATE)
[25 Oct 2020 11:22:54] (viewOnlineReports) database connection response
[25 Oct 2020 11:22:54] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410630'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[25 Oct 2020 11:22:54] (viewOnlineReports) database connection response
[25 Oct 2020 11:22:54] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:22:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410630/
[25 Oct 2020 11:22:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410630/
[25 Oct 2020 11:22:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:22:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603606974M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:22:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603606974M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:22:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG
[25 Oct 2020 11:22:54] (viewOnlineReports) Converting PDF to JPG with name as M0100000639912_M01BBK20002496_1.jpg
[25 Oct 2020 11:22:54] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603606974M0100000639912_M01BBK20002496_1.PDF ../../TEMP_PDF/200410630/M0100000639912_M01BBK20002496_1.jpg
[25 Oct 2020 11:22:54] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603606974M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:03] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:03] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:23:03] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639912', '001', '200410630', '1', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:23:03] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:23:03] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:23:03] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:23:03] (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',    '200410630',    'M01',    '047',    '1',    '001000000000086900',    'M0100000639912_M01BBK20002496_1.PDF',    'M0100000639912',    SYSDATE)
[25 Oct 2020 11:23:03] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:03] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410630'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[25 Oct 2020 11:23:03] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:03] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:23:03] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410630/
[25 Oct 2020 11:23:03] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410630/
[25 Oct 2020 11:23:03] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:03] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410630/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1603606983M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410630/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1603606983M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[25 Oct 2020 11:23:03] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200410630/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1603606983M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:16] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:16] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:23:16] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639912', '001', '200410630', '1', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:23:16] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:23:16] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:23:16] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:23:16] (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',    '200410630',    'M01',    '047',    '1',    '001000000000086900',    'M0100000639912_M01BBK20002496_1.PDF',    'M0100000639912',    SYSDATE)
[25 Oct 2020 11:23:16] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:16] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410630'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[25 Oct 2020 11:23:16] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:16] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:23:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410630/
[25 Oct 2020 11:23:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410630/
[25 Oct 2020 11:23:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1603606996M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1603606996M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[25 Oct 2020 11:23:16] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1603606996M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:28] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:28] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:23:28] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639912', '001', '200410630', '1', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:23:28] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:23:28] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:23:28] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:23:28] (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',    '200410630',    'M01',    '047',    '1',    '001000000000086900',    'M0100000639912_M01BBK20002496_1.PDF',    'M0100000639912',    SYSDATE)
[25 Oct 2020 11:23:28] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:28] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410630'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[25 Oct 2020 11:23:28] (viewOnlineReports) database connection response
[25 Oct 2020 11:23:28] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:23:28] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410630/
[25 Oct 2020 11:23:28] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410630/
[25 Oct 2020 11:23:28] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:28] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603607008M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603607008M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:23:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER
[25 Oct 2020 11:23:28] (viewOnlineReports) Converting PDF to JPG with name as M0100000639912_M01BBK20002496_1.jpg
[25 Oct 2020 11:23:28] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603607008M0100000639912_M01BBK20002496_1.PDF ../../TEMP_PDF/200410630/M0100000639912_M01BBK20002496_1.jpg
[25 Oct 2020 11:23:28] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603607008M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:24:25] (viewOnlineReports) database connection response
[25 Oct 2020 11:24:25] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:24:25] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639912', '001', '200410630', '1', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:24:25] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:24:25] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:24:25] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:24:25] (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',    '200410630',    'M01',    '047',    '1',    '001000000000086900',    'M0100000639912_M01BBK20002496_1.PDF',    'M0100000639912',    SYSDATE)
[25 Oct 2020 11:24:25] (viewOnlineReports) database connection response
[25 Oct 2020 11:24:25] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410630'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[25 Oct 2020 11:24:25] (viewOnlineReports) database connection response
[25 Oct 2020 11:24:25] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:24:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410630/
[25 Oct 2020 11:24:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410630/
[25 Oct 2020 11:24:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:24:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410630/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1603607065M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:24:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410630/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1603607065M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:24:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[25 Oct 2020 11:24:25] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200410630/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1603607065M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:24:52] (viewOnlineReports) database connection response
[25 Oct 2020 11:24:52] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:24:52] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639912', '001', '200410630', '1', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:24:52] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:24:52] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:24:52] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:24:52] (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',    '200410630',    'M01',    '047',    '1',    '001000000000086900',    'M0100000639912_M01BBK20002496_1.PDF',    'M0100000639912',    SYSDATE)
[25 Oct 2020 11:24:52] (viewOnlineReports) database connection response
[25 Oct 2020 11:24:52] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410630'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[25 Oct 2020 11:24:52] (viewOnlineReports) database connection response
[25 Oct 2020 11:24:52] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:24:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410630/
[25 Oct 2020 11:24:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410630/
[25 Oct 2020 11:24:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:24:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1603607092M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:24:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1603607092M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:24:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG
[25 Oct 2020 11:24:52] (viewOnlineReports) Converting PDF to JPG with name as M0100000639912_M01BBK20002496_1.jpg
[25 Oct 2020 11:24:52] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1603607092M0100000639912_M01BBK20002496_1.PDF ../../TEMP_PDF/200410630/M0100000639912_M01BBK20002496_1.jpg
[25 Oct 2020 11:24:52] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200410630/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1603607092M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:32:36] (index) database connection response
[25 Oct 2020 11:32:36] (index) getConnection(): Resource id #1
[25 Oct 2020 11:32:36] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[25 Oct 2020 11:32:36] (index) database connection response
[25 Oct 2020 11:32:36] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[25 Oct 2020 11:32:36] (index) database connection response
[25 Oct 2020 11:32:36] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[25 Oct 2020 11:32:36] (index) database connection response
[25 Oct 2020 11:32:36] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456440'  AND ACCESS_CODE = '501022133'
[25 Oct 2020 11:32:36] (index) database connection response
[25 Oct 2020 11:32:36] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456440'  AND ACCESS_CODE = '501022133'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[25 Oct 2020 11:32:36] (index) database connection response
[25 Oct 2020 11:32:36] (index) getConnectionClose() called....
[25 Oct 2020 11:33:05] (index) database connection response
[25 Oct 2020 11:33:05] (index) getConnection(): Resource id #1
[25 Oct 2020 11:33:05] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[25 Oct 2020 11:33:05] (index) database connection response
[25 Oct 2020 11:33:05] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[25 Oct 2020 11:33:05] (index) database connection response
[25 Oct 2020 11:33:05] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[25 Oct 2020 11:33:05] (index) database connection response
[25 Oct 2020 11:33:05] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456440'  AND ACCESS_CODE = '50102133'
[25 Oct 2020 11:33:05] (index) database connection response
[25 Oct 2020 11:33:05] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456440'  AND ACCESS_CODE = '50102133'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[25 Oct 2020 11:33:05] (index) database connection response
[25 Oct 2020 11:33:05] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000639912'
[25 Oct 2020 11:33:05] (index) database connection response
[25 Oct 2020 11:33:05] (index) getPatientReportsDetail() entered
[25 Oct 2020 11:33:05] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200456440', 'M0100000639912', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:33:05] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200456440', 'M0100000639912', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:33:05] (index) p_Stop=N
[25 Oct 2020 11:33:05] (index) p_Alert=
[25 Oct 2020 11:33:05] (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
[25 Oct 2020 11:33:05] (index) database connection response
[25 Oct 2020 11:33:05] (index) getConnectionClose() called....
[25 Oct 2020 11:33:05] (index) getConnectionClose() called....
[25 Oct 2020 11:33:19] (viewOnlineReports) database connection response
[25 Oct 2020 11:33:19] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:33:19] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639912', '001', '200410630', '1', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:33:19] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:33:19] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:33:19] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:33:19] (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',    '200410630',    'M01',    '047',    '1',    '001000000000086900',    'M0100000639912_M01BBK20002496_1.PDF',    'M0100000639912',    SYSDATE)
[25 Oct 2020 11:33:19] (viewOnlineReports) database connection response
[25 Oct 2020 11:33:19] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410630'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[25 Oct 2020 11:33:19] (viewOnlineReports) database connection response
[25 Oct 2020 11:33:19] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:33:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410630/
[25 Oct 2020 11:33:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410630/
[25 Oct 2020 11:33:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:33:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410630/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1603607599M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:33:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410630/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1603607599M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:33:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[25 Oct 2020 11:33:19] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200410630/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1603607599M0100000639912_M01BBK20002496_1.PDF
[25 Oct 2020 11:35:26] (index) database connection response
[25 Oct 2020 11:35:26] (index) getConnection(): Resource id #1
[25 Oct 2020 11:35:26] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[25 Oct 2020 11:35:26] (index) database connection response
[25 Oct 2020 11:35:26] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[25 Oct 2020 11:35:26] (index) database connection response
[25 Oct 2020 11:35:26] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[25 Oct 2020 11:35:26] (index) database connection response
[25 Oct 2020 11:35:26] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456429'  AND ACCESS_CODE = '56311347'
[25 Oct 2020 11:35:26] (index) database connection response
[25 Oct 2020 11:35:26] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456429'  AND ACCESS_CODE = '56311347'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[25 Oct 2020 11:35:26] (index) database connection response
[25 Oct 2020 11:35:26] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000602255'
[25 Oct 2020 11:35:26] (index) database connection response
[25 Oct 2020 11:35:26] (index) getPatientReportsDetail() entered
[25 Oct 2020 11:35:26] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200456429', 'M0100000602255', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:35:26] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200456429', 'M0100000602255', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:35:26] (index) p_Stop=N
[25 Oct 2020 11:35:26] (index) p_Alert=
[25 Oct 2020 11:35:26] (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
[25 Oct 2020 11:35:26] (index) database connection response
[25 Oct 2020 11:35:26] (index) getConnectionClose() called....
[25 Oct 2020 11:35:26] (index) getConnectionClose() called....
[25 Oct 2020 11:35:39] (viewOnlineReports) database connection response
[25 Oct 2020 11:35:39] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:35:39] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000602255', '001', '200410626', '1', '001000000000080092', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:35:39] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:35:39] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:35:39] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:35:39] (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',    '200410626',    'M01',    '047',    '1',    '001000000000080092',    'M0100000602255_M01SCH20011318_1.PDF',    'M0100000602255',    SYSDATE)
[25 Oct 2020 11:35:39] (viewOnlineReports) database connection response
[25 Oct 2020 11:35:39] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410626'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[25 Oct 2020 11:35:39] (viewOnlineReports) database connection response
[25 Oct 2020 11:35:39] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:35:39] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410626/
[25 Oct 2020 11:35:39] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410626/
[25 Oct 2020 11:35:39] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000602255_M01SCH20011318_1.PDF
[25 Oct 2020 11:35:39] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410626/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1603607739M0100000602255_M01SCH20011318_1.PDF
[25 Oct 2020 11:35:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410626/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1603607739M0100000602255_M01SCH20011318_1.PDF
[25 Oct 2020 11:35:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[25 Oct 2020 11:35:39] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200410626/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1603607739M0100000602255_M01SCH20011318_1.PDF
[25 Oct 2020 11:37:34] (viewOnlineReports) database connection response
[25 Oct 2020 11:37:34] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:37:34] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000602255', '001', '200410626', '2', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:37:34] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:37:34] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:37:34] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:37:34] (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',    '200410626',    'M01',    '047',    '2',    '001000000000084296',    'M0100000602255_M01RCH20020362_1.PDF',    'M0100000602255',    SYSDATE)
[25 Oct 2020 11:37:34] (viewOnlineReports) database connection response
[25 Oct 2020 11:37:34] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410626'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '2'
[25 Oct 2020 11:37:34] (viewOnlineReports) database connection response
[25 Oct 2020 11:37:34] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:37:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410626/
[25 Oct 2020 11:37:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410626/
[25 Oct 2020 11:37:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000602255_M01RCH20020362_1.PDF
[25 Oct 2020 11:37:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410626/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603607854M0100000602255_M01RCH20020362_1.PDF
[25 Oct 2020 11:37:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410626/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603607854M0100000602255_M01RCH20020362_1.PDF
[25 Oct 2020 11:37:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[25 Oct 2020 11:37:34] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200410626/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603607854M0100000602255_M01RCH20020362_1.PDF
[25 Oct 2020 11:38:15] (viewOnlineReports) database connection response
[25 Oct 2020 11:38:15] (viewOnlineReports) getConnection(): Resource id #1
[25 Oct 2020 11:38:15] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000602255', '001', '200410626', '2', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 11:38:15] (viewOnlineReports) p_Stop=N
[25 Oct 2020 11:38:15] (viewOnlineReports) p_Alert=
[25 Oct 2020 11:38:15] (viewOnlineReports) Flag = 1
[25 Oct 2020 11:38: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',    '200410626',    'M01',    '047',    '2',    '001000000000084296',    'M0100000602255_M01RCH20020362_1.PDF',    'M0100000602255',    SYSDATE)
[25 Oct 2020 11:38:15] (viewOnlineReports) database connection response
[25 Oct 2020 11:38:15] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200410626'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '2'
[25 Oct 2020 11:38:15] (viewOnlineReports) database connection response
[25 Oct 2020 11:38:15] (viewOnlineReports) getConnectionClose() called....
[25 Oct 2020 11:38:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200410626/
[25 Oct 2020 11:38:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200410626/
[25 Oct 2020 11:38:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201024\M01\M0100000602255_M01RCH20020362_1.PDF
[25 Oct 2020 11:38:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200410626/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1603607895M0100000602255_M01RCH20020362_1.PDF
[25 Oct 2020 11:38:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200410626/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1603607895M0100000602255_M01RCH20020362_1.PDF
[25 Oct 2020 11:38:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[25 Oct 2020 11:38:15] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200410626/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1603607895M0100000602255_M01RCH20020362_1.PDF
[25 Oct 2020 12:27:16] (index) database connection response
[25 Oct 2020 12:27:16] (index) getConnection(): Resource id #1
[25 Oct 2020 12:27:16] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '14'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[25 Oct 2020 12:27:16] (index) database connection response
[25 Oct 2020 12:27:16] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '14'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[25 Oct 2020 12:27:16] (index) database connection response
[25 Oct 2020 12:27:16] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '14'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[25 Oct 2020 12:27:16] (index) database connection response
[25 Oct 2020 12:27:16] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200446212'  AND ACCESS_CODE = '75064200'
[25 Oct 2020 12:27:16] (index) database connection response
[25 Oct 2020 12:27:16] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200446212'  AND ACCESS_CODE = '75064200'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[25 Oct 2020 12:27:16] (index) database connection response
[25 Oct 2020 12:27:16] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000545639'
[25 Oct 2020 12:27:16] (index) database connection response
[25 Oct 2020 12:27:16] (index) getPatientReportsDetail() entered
[25 Oct 2020 12:27:16] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200446212', 'M0100000545639', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 12:27:16] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200446212', 'M0100000545639', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 12:27:16] (index) p_Stop=N
[25 Oct 2020 12:27:16] (index) p_Alert=
[25 Oct 2020 12:27:16] (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
[25 Oct 2020 12:27:16] (index) database connection response
[25 Oct 2020 12:27:16] (index) getConnectionClose() called....
[25 Oct 2020 12:27:16] (index) getConnectionClose() called....
[25 Oct 2020 14:13:26] (index) database connection response
[25 Oct 2020 14:13:26] (index) getConnection(): Resource id #1
[25 Oct 2020 14:13:26] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[25 Oct 2020 14:13:26] (index) database connection response
[25 Oct 2020 14:13:26] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[25 Oct 2020 14:13:26] (index) database connection response
[25 Oct 2020 14:13:26] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '84'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[25 Oct 2020 14:13:26] (index) database connection response
[25 Oct 2020 14:13:26] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200416419'  AND ACCESS_CODE = '23217733'
[25 Oct 2020 14:13:26] (index) database connection response
[25 Oct 2020 14:13:26] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200416419'  AND ACCESS_CODE = '23217733'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[25 Oct 2020 14:13:26] (index) database connection response
[25 Oct 2020 14:13:26] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000636909'
[25 Oct 2020 14:13:26] (index) database connection response
[25 Oct 2020 14:13:26] (index) getPatientReportsDetail() entered
[25 Oct 2020 14:13:26] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416419', 'M0100000636909', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 14:13:26] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416419', 'M0100000636909', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 14:13:26] (index) p_Stop=N
[25 Oct 2020 14:13:26] (index) p_Alert=
[25 Oct 2020 14:13:26] (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
[25 Oct 2020 14:13:26] (index) database connection response
[25 Oct 2020 14:13:26] (index) getConnectionClose() called....
[25 Oct 2020 14:13:26] (index) getConnectionClose() called....
[25 Oct 2020 22:06:54] (index) database connection response
[25 Oct 2020 22:06:54] (index) getConnection(): Resource id #1
[25 Oct 2020 22:06:54] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'FIREFOX' 	   AND BROWSER_VERSION = '81'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[25 Oct 2020 22:06:54] (index) database connection response
[25 Oct 2020 22:06:54] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'FIREFOX' 	   AND BROWSER_VERSION = '81'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[25 Oct 2020 22:06:54] (index) database connection response
[25 Oct 2020 22:06:54] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'FIREFOX' 	   AND BROWSER_VERSION = '81'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[25 Oct 2020 22:06:54] (index) database connection response
[25 Oct 2020 22:06:54] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456899'  AND ACCESS_CODE = '87530118'
[25 Oct 2020 22:06:54] (index) database connection response
[25 Oct 2020 22:06:54] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200456899'  AND ACCESS_CODE = '87530118'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[25 Oct 2020 22:06:54] (index) database connection response
[25 Oct 2020 22:06:54] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000639935'
[25 Oct 2020 22:06:54] (index) database connection response
[25 Oct 2020 22:06:54] (index) getPatientReportsDetail() entered
[25 Oct 2020 22:06:54] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200456899', 'M0100000639935', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 22:06:54] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200456899', 'M0100000639935', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[25 Oct 2020 22:06:54] (index) p_Stop=N
[25 Oct 2020 22:06:54] (index) p_Alert=
[25 Oct 2020 22:06:54] (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
[25 Oct 2020 22:06:54] (index) database connection response
[25 Oct 2020 22:06:54] (index) getConnectionClose() called....
[25 Oct 2020 22:06:54] (index) getConnectionClose() called....