[06 Nov 2020 09:35:43] (index) database connection response
[06 Nov 2020 09:35:43] (index) getConnection(): Resource id #1
[06 Nov 2020 09:35:43] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 09:35:43] (index) database connection response
[06 Nov 2020 09:35:43] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 09:35:43] (index) database connection response
[06 Nov 2020 09:35:43] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 09:35:43] (index) database connection response
[06 Nov 2020 09:35:43] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200475565'  AND ACCESS_CODE = '93228802'
[06 Nov 2020 09:35:43] (index) database connection response
[06 Nov 2020 09:35:43] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200475565'  AND ACCESS_CODE = '93228802'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 09:35:43] (index) database connection response
[06 Nov 2020 09:35:43] (index) getConnectionClose() called....
[06 Nov 2020 09:36:22] (index) database connection response
[06 Nov 2020 09:36:22] (index) getConnection(): Resource id #1
[06 Nov 2020 09:36:22] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 09:36:22] (index) database connection response
[06 Nov 2020 09:36:22] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 09:36:22] (index) database connection response
[06 Nov 2020 09:36:22] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 09:36:22] (index) database connection response
[06 Nov 2020 09:36:22] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M1200475564'  AND ACCESS_CODE = '93228802'
[06 Nov 2020 09:36:22] (index) database connection response
[06 Nov 2020 09:36:22] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M1200475564'  AND ACCESS_CODE = '93228802'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 09:36:22] (index) database connection response
[06 Nov 2020 09:36:22] (index) getConnectionClose() called....
[06 Nov 2020 09:41:42] (index) database connection response
[06 Nov 2020 09:41:42] (index) getConnection(): Resource id #1
[06 Nov 2020 09:41:42] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 09:41:42] (index) database connection response
[06 Nov 2020 09:41:42] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 09:41:42] (index) database connection response
[06 Nov 2020 09:41:42] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 09:41:42] (index) database connection response
[06 Nov 2020 09:41:42] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200475564'  AND ACCESS_CODE = '93228802'
[06 Nov 2020 09:41:42] (index) database connection response
[06 Nov 2020 09:41:42] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200475564'  AND ACCESS_CODE = '93228802'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 09:41:42] (index) database connection response
[06 Nov 2020 09:41:42] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000641523'
[06 Nov 2020 09:41:42] (index) database connection response
[06 Nov 2020 09:41:42] (index) getPatientReportsDetail() entered
[06 Nov 2020 09:41:42] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200475564', 'M0100000641523', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 09:41:42] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200475564', 'M0100000641523', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 09:41:42] (index) p_Stop=N
[06 Nov 2020 09:41:42] (index) p_Alert=
[06 Nov 2020 09:41:42] (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
[06 Nov 2020 09:41:42] (index) database connection response
[06 Nov 2020 09:41:42] (index) getConnectionClose() called....
[06 Nov 2020 09:41:42] (index) getConnectionClose() called....
[06 Nov 2020 09:41:48] (viewOnlineReports) database connection response
[06 Nov 2020 09:41:48] (viewOnlineReports) getConnection(): Resource id #1
[06 Nov 2020 09:41:48] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '013', 'M0100000641523', '001', '200416788', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 09:41:48] (viewOnlineReports) p_Stop=N
[06 Nov 2020 09:41:48] (viewOnlineReports) p_Alert=
[06 Nov 2020 09:41:48] (viewOnlineReports) Flag = 1
[06 Nov 2020 09:41:48] (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',    '200416788',    'M01',    '013',    '1',    '001000000000087630',    'M0100000641523_M01MOL20011875_1.PDF',    'M0100000641523',    SYSDATE)
[06 Nov 2020 09:41:48] (viewOnlineReports) database connection response
[06 Nov 2020 09:41:48] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200416788'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '013'   AND TRANSACTION_NO 	 = '1'
[06 Nov 2020 09:41:48] (viewOnlineReports) database connection response
[06 Nov 2020 09:41:48] (viewOnlineReports) getConnectionClose() called....
[06 Nov 2020 09:41:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200416788/
[06 Nov 2020 09:41:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200416788/
[06 Nov 2020 09:41:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201105\M01\M0100000641523_M01MOL20011875_1.PDF
[06 Nov 2020 09:41:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200416788/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1604637708M0100000641523_M01MOL20011875_1.PDF
[06 Nov 2020 09:41:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200416788/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1604637708M0100000641523_M01MOL20011875_1.PDF
[06 Nov 2020 09:41:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[06 Nov 2020 09:41:48] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200416788/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1604637708M0100000641523_M01MOL20011875_1.PDF
[06 Nov 2020 09:42:04] (viewOnlineReports) database connection response
[06 Nov 2020 09:42:04] (viewOnlineReports) getConnection(): Resource id #1
[06 Nov 2020 09:42:04] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '013', 'M0100000641523', '001', '200416788', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 09:42:04] (viewOnlineReports) p_Stop=N
[06 Nov 2020 09:42:04] (viewOnlineReports) p_Alert=
[06 Nov 2020 09:42:04] (viewOnlineReports) Flag = 1
[06 Nov 2020 09:42:04] (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',    '200416788',    'M01',    '013',    '1',    '001000000000087630',    'M0100000641523_M01MOL20011875_1.PDF',    'M0100000641523',    SYSDATE)
[06 Nov 2020 09:42:04] (viewOnlineReports) database connection response
[06 Nov 2020 09:42:04] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200416788'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '013'   AND TRANSACTION_NO 	 = '1'
[06 Nov 2020 09:42:04] (viewOnlineReports) database connection response
[06 Nov 2020 09:42:04] (viewOnlineReports) getConnectionClose() called....
[06 Nov 2020 09:42:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200416788/
[06 Nov 2020 09:42:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200416788/
[06 Nov 2020 09:42:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201105\M01\M0100000641523_M01MOL20011875_1.PDF
[06 Nov 2020 09:42:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200416788/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1604637724M0100000641523_M01MOL20011875_1.PDF
[06 Nov 2020 09:42:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200416788/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1604637724M0100000641523_M01MOL20011875_1.PDF
[06 Nov 2020 09:42:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD
[06 Nov 2020 09:42:04] (viewOnlineReports) Downloading file ../../TEMP_PDF/200416788/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1604637724M0100000641523_M01MOL20011875_1.PDF
[06 Nov 2020 11:07:28] (index) database connection response
[06 Nov 2020 11:07:28] (index) getConnection(): Resource id #1
[06 Nov 2020 11:07:28] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 11:07:28] (index) database connection response
[06 Nov 2020 11:07:28] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 11:07:28] (index) database connection response
[06 Nov 2020 11:07:28] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '86'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 11:07:28] (index) database connection response
[06 Nov 2020 11:07:28] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200366866'  AND ACCESS_CODE = '70094353'
[06 Nov 2020 11:07:28] (index) database connection response
[06 Nov 2020 11:07:28] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200366866'  AND ACCESS_CODE = '70094353'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 11:07:28] (index) database connection response
[06 Nov 2020 11:07:28] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000629113'
[06 Nov 2020 11:07:28] (index) database connection response
[06 Nov 2020 11:07:28] (index) getPatientReportsDetail() entered
[06 Nov 2020 11:07:28] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200366866', 'M0100000629113', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 11:07:28] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200366866', 'M0100000629113', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 11:07:28] (index) p_Stop=N
[06 Nov 2020 11:07:28] (index) p_Alert=
[06 Nov 2020 11:07:28] (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
[06 Nov 2020 11:07:28] (index) database connection response
[06 Nov 2020 11:07:28] (index) getConnectionClose() called....
[06 Nov 2020 11:07:28] (index) getConnectionClose() called....
[06 Nov 2020 11:07:50] (viewOnlineReports) database connection response
[06 Nov 2020 11:07:50] (viewOnlineReports) getConnection(): Resource id #1
[06 Nov 2020 11:07:51] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000629113', '001', '200380922', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 11:07:51] (viewOnlineReports) p_Stop=N
[06 Nov 2020 11:07:51] (viewOnlineReports) p_Alert=
[06 Nov 2020 11:07:51] (viewOnlineReports) Flag = 1
[06 Nov 2020 11:07:51] (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',    '200380922',    'M01',    '010',    '1',    '001000000000085025',    'M0100000629113_M01HEM20012158_1.PDF',    'M0100000629113',    SYSDATE)
[06 Nov 2020 11:07:51] (viewOnlineReports) database connection response
[06 Nov 2020 11:07:51] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200380922'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '010'   AND TRANSACTION_NO 	 = '1'
[06 Nov 2020 11:07:51] (viewOnlineReports) database connection response
[06 Nov 2020 11:07:51] (viewOnlineReports) getConnectionClose() called....
[06 Nov 2020 11:07:51] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380922/
[06 Nov 2020 11:07:51] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380922/
[06 Nov 2020 11:07:51] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:07:51] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380922/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1604642870M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:07:51] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380922/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1604642870M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:07:51] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[06 Nov 2020 11:07:51] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380922/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1604642870M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:08:13] (viewOnlineReports) database connection response
[06 Nov 2020 11:08:13] (viewOnlineReports) getConnection(): Resource id #1
[06 Nov 2020 11:08:13] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000629113', '001', '200380922', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 11:08:13] (viewOnlineReports) p_Stop=N
[06 Nov 2020 11:08:13] (viewOnlineReports) p_Alert=
[06 Nov 2020 11:08:13] (viewOnlineReports) Flag = 1
[06 Nov 2020 11:08:13] (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',    '200380922',    'M01',    '010',    '1',    '001000000000085025',    'M0100000629113_M01HEM20012158_1.PDF',    'M0100000629113',    SYSDATE)
[06 Nov 2020 11:08:13] (viewOnlineReports) database connection response
[06 Nov 2020 11:08:13] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200380922'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '010'   AND TRANSACTION_NO 	 = '1'
[06 Nov 2020 11:08:13] (viewOnlineReports) database connection response
[06 Nov 2020 11:08:13] (viewOnlineReports) getConnectionClose() called....
[06 Nov 2020 11:08:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380922/
[06 Nov 2020 11:08:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380922/
[06 Nov 2020 11:08:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:08:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380922/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1604642893M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:08:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380922/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1604642893M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:08:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[06 Nov 2020 11:08:13] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380922/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1604642893M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:08:39] (viewOnlineReports) database connection response
[06 Nov 2020 11:08:39] (viewOnlineReports) getConnection(): Resource id #1
[06 Nov 2020 11:08:39] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000629113', '001', '200380922', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 11:08:39] (viewOnlineReports) p_Stop=N
[06 Nov 2020 11:08:39] (viewOnlineReports) p_Alert=
[06 Nov 2020 11:08:39] (viewOnlineReports) Flag = 1
[06 Nov 2020 11:08: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',    '200380922',    'M01',    '010',    '1',    '001000000000085025',    'M0100000629113_M01HEM20012158_1.PDF',    'M0100000629113',    SYSDATE)
[06 Nov 2020 11:08:39] (viewOnlineReports) database connection response
[06 Nov 2020 11:08:39] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200380922'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '010'   AND TRANSACTION_NO 	 = '1'
[06 Nov 2020 11:08:39] (viewOnlineReports) database connection response
[06 Nov 2020 11:08:39] (viewOnlineReports) getConnectionClose() called....
[06 Nov 2020 11:08:39] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380922/
[06 Nov 2020 11:08:39] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380922/
[06 Nov 2020 11:08:39] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:08:39] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380922/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1604642919M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:08:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380922/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1604642919M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 11:08:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[06 Nov 2020 11:08:39] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380922/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1604642919M0100000629113_M01HEM20012158_1.PDF
[06 Nov 2020 12:02:47] (index) database connection response
[06 Nov 2020 12:02:47] (index) getConnection(): Resource id #1
[06 Nov 2020 12:02:47] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'NETSCAPE' 	   AND BROWSER_VERSION = '5'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 12:02:47] (index) database connection response
[06 Nov 2020 12:02:47] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'NETSCAPE' 	   AND BROWSER_VERSION = '5'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 12:02:47] (index) database connection response
[06 Nov 2020 12:02:47] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'NETSCAPE' 	   AND BROWSER_VERSION = '5'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 12:02:47] (index) database connection response
[06 Nov 2020 12:02:47] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200475846'  AND ACCESS_CODE = '32899052'
[06 Nov 2020 12:02:47] (index) database connection response
[06 Nov 2020 12:02:47] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200475846'  AND ACCESS_CODE = '32899052'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 12:02:47] (index) database connection response
[06 Nov 2020 12:02:47] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000161159'
[06 Nov 2020 12:02:47] (index) database connection response
[06 Nov 2020 12:02:47] (index) getPatientReportsDetail() entered
[06 Nov 2020 12:02:47] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200475846', 'M0100000161159', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 12:02:47] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200475846', 'M0100000161159', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 12:02:47] (index) p_Stop=N
[06 Nov 2020 12:02:47] (index) p_Alert=
[06 Nov 2020 12:02:47] (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
[06 Nov 2020 12:02:47] (index) database connection response
[06 Nov 2020 12:02:47] (index) getConnectionClose() called....
[06 Nov 2020 12:02:47] (index) getConnectionClose() called....
[06 Nov 2020 12:02:54] (viewOnlineReports) database connection response
[06 Nov 2020 12:02:54] (viewOnlineReports) getConnection(): Resource id #1
[06 Nov 2020 12:02:54] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '013', 'M0100000161159', '001', '200416932', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 12:02:54] (viewOnlineReports) p_Stop=N
[06 Nov 2020 12:02:54] (viewOnlineReports) p_Alert=
[06 Nov 2020 12:02:54] (viewOnlineReports) Flag = 1
[06 Nov 2020 12:02: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',    '200416932',    'M01',    '013',    '1',    '001000000000087630',    'M0100000161159_M01MOL20011898_1.PDF',    'M0100000161159',    SYSDATE)
[06 Nov 2020 12:02:54] (viewOnlineReports) database connection response
[06 Nov 2020 12:02:54] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200416932'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '013'   AND TRANSACTION_NO 	 = '1'
[06 Nov 2020 12:02:54] (viewOnlineReports) database connection response
[06 Nov 2020 12:02:54] (viewOnlineReports) getConnectionClose() called....
[06 Nov 2020 12:02:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200416932/
[06 Nov 2020 12:02:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200416932/
[06 Nov 2020 12:02:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201106\M01\M0100000161159_M01MOL20011898_1.PDF
[06 Nov 2020 12:02:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200416932/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1604646174M0100000161159_M01MOL20011898_1.PDF
[06 Nov 2020 12:02:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200416932/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1604646174M0100000161159_M01MOL20011898_1.PDF
[06 Nov 2020 12:02:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[06 Nov 2020 12:02:54] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200416932/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1604646174M0100000161159_M01MOL20011898_1.PDF
[06 Nov 2020 12:34:00] (viewOnlineReports) database connection response
[06 Nov 2020 12:34:00] (viewOnlineReports) getConnection(): Resource id #1
[06 Nov 2020 12:34:00] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '013', '00100000000000', '001', '200416932', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 12:34:00] (viewOnlineReports) p_Stop=N
[06 Nov 2020 12:34:00] (viewOnlineReports) p_Alert=
[06 Nov 2020 12:34:00] (viewOnlineReports) Flag = 1
[06 Nov 2020 12:34: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',    '200416932',    'M01',    '013',    '1',    '001000000000087630',    'M0100000161159_M01MOL20011898_1.PDF',    '00100000000000',    SYSDATE)
[06 Nov 2020 12:34:00] (viewOnlineReports) database connection response
[06 Nov 2020 12:34:00] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200416932'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '013'   AND TRANSACTION_NO 	 = '1'
[06 Nov 2020 12:34:00] (viewOnlineReports) database connection response
[06 Nov 2020 12:34:00] (viewOnlineReports) getConnectionClose() called....
[06 Nov 2020 12:34:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200416932/
[06 Nov 2020 12:34:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200416932/
[06 Nov 2020 12:34:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201106\M01\M0100000161159_M01MOL20011898_1.PDF
[06 Nov 2020 12:34:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200416932/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZM0100000161159_M01MOL20011898_1.PDF
[06 Nov 2020 12:34:00] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200416932/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZM0100000161159_M01MOL20011898_1.PDF
[06 Nov 2020 12:34:00] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF
[06 Nov 2020 12:34:00] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200416932/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZM0100000161159_M01MOL20011898_1.PDF
[06 Nov 2020 12:54:19] (index) database connection response
[06 Nov 2020 12:54:19] (index) getConnection(): Resource id #1
[06 Nov 2020 12:54:19] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 12:54:20] (index) database connection response
[06 Nov 2020 12:54:20] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 12:54:20] (index) database connection response
[06 Nov 2020 12:54:20] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 12:54:20] (index) database connection response
[06 Nov 2020 12:54:20] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200447094'  AND ACCESS_CODE = '59403968'
[06 Nov 2020 12:54:20] (index) database connection response
[06 Nov 2020 12:54:20] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200447094'  AND ACCESS_CODE = '59403968'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 12:54:20] (index) database connection response
[06 Nov 2020 12:54:20] (index) getConnectionClose() called....
[06 Nov 2020 12:56:02] (index) database connection response
[06 Nov 2020 12:56:02] (index) getConnection(): Resource id #1
[06 Nov 2020 12:56:02] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 12:56:02] (index) database connection response
[06 Nov 2020 12:56:02] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 12:56:02] (index) database connection response
[06 Nov 2020 12:56:02] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'SAFARI' 	   AND BROWSER_VERSION = '604'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 12:56:02] (index) database connection response
[06 Nov 2020 12:56:02] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200470946'  AND ACCESS_CODE = '59403968'
[06 Nov 2020 12:56:02] (index) database connection response
[06 Nov 2020 12:56:02] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200470946'  AND ACCESS_CODE = '59403968'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 12:56:02] (index) database connection response
[06 Nov 2020 12:56:02] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000060324'
[06 Nov 2020 12:56:02] (index) database connection response
[06 Nov 2020 12:56:02] (index) getPatientReportsDetail() entered
[06 Nov 2020 12:56:02] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200470946', 'M0100000060324', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 12:56:02] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200470946', 'M0100000060324', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 12:56:02] (index) p_Stop=N
[06 Nov 2020 12:56:02] (index) p_Alert=
[06 Nov 2020 12:56:02] (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
[06 Nov 2020 12:56:02] (index) database connection response
[06 Nov 2020 12:56:02] (index) getConnectionClose() called....
[06 Nov 2020 12:56:02] (index) getConnectionClose() called....
[06 Nov 2020 12:56:17] (viewOnlineReports) database connection response
[06 Nov 2020 12:56:17] (viewOnlineReports) getConnection(): Resource id #1
[06 Nov 2020 12:56:17] (viewOnlineReports) BEGIN  HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000060324', '001', '200415196', '1', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 12:56:17] (viewOnlineReports) p_Stop=N
[06 Nov 2020 12:56:17] (viewOnlineReports) p_Alert=
[06 Nov 2020 12:56:17] (viewOnlineReports) Flag = 1
[06 Nov 2020 12:56: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',    '200415196',    'M01',    '047',    '1',    '001000000000084460',    'M0100000060324_M01RCH20021111_1.PDF',    'M0100000060324',    SYSDATE)
[06 Nov 2020 12:56:17] (viewOnlineReports) database connection response
[06 Nov 2020 12:56:17] (viewOnlineReports) insertRow():  UPDATE   CCWEB.ONLINE_REPORTS  SET VIEWED = 'Y',  	   LAST_VIEW_DATE = SYSDATE  WHERE     ORDER_TYPE_ID 	 = '001'  AND ORDER_NO 		 = '200415196'   AND LOCATION_ID 		 = 'M01'   AND ORDER_LOCATION_ID = '047'   AND TRANSACTION_NO 	 = '1'
[06 Nov 2020 12:56:17] (viewOnlineReports) database connection response
[06 Nov 2020 12:56:17] (viewOnlineReports) getConnectionClose() called....
[06 Nov 2020 12:56:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200415196/
[06 Nov 2020 12:56:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200415196/
[06 Nov 2020 12:56:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201103\M01\M0100000060324_M01RCH20021111_1.PDF
[06 Nov 2020 12:56:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200415196/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1604649377M0100000060324_M01RCH20021111_1.PDF
[06 Nov 2020 12:56:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200415196/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1604649377M0100000060324_M01RCH20021111_1.PDF
[06 Nov 2020 12:56:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG
[06 Nov 2020 12:56:18] (viewOnlineReports) Converting PDF to JPG with name as M0100000060324_M01RCH20021111_1.jpg
[06 Nov 2020 12:56:18] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports  Command =    "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200415196/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1604649377M0100000060324_M01RCH20021111_1.PDF ../../TEMP_PDF/200415196/M0100000060324_M01RCH20021111_1.jpg
[06 Nov 2020 12:56:18] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200415196/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1604649377M0100000060324_M01RCH20021111_1.PDF
[06 Nov 2020 15:28:49] (index) database connection response
[06 Nov 2020 15:28:49] (index) getConnection(): Resource id #1
[06 Nov 2020 15:28:49] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 15:28:49] (index) database connection response
[06 Nov 2020 15:28:49] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 15:28:49] (index) database connection response
[06 Nov 2020 15:28:49] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 15:28:49] (index) database connection response
[06 Nov 2020 15:28:49] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M0120047190'  AND ACCESS_CODE = '30682932'
[06 Nov 2020 15:28:49] (index) database connection response
[06 Nov 2020 15:28:49] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M0120047190'  AND ACCESS_CODE = '30682932'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 15:28:49] (index) database connection response
[06 Nov 2020 15:28:49] (index) getConnectionClose() called....
[06 Nov 2020 15:29:27] (index) database connection response
[06 Nov 2020 15:29:27] (index) getConnection(): Resource id #1
[06 Nov 2020 15:29:27] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 15:29:27] (index) database connection response
[06 Nov 2020 15:29:27] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 15:29:27] (index) database connection response
[06 Nov 2020 15:29:27] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 15:29:27] (index) database connection response
[06 Nov 2020 15:29:27] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200477190'  AND ACCESS_CODE = '30682932'
[06 Nov 2020 15:29:27] (index) database connection response
[06 Nov 2020 15:29:27] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200477190'  AND ACCESS_CODE = '30682932'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 15:29:27] (index) database connection response
[06 Nov 2020 15:29:27] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000641369'
[06 Nov 2020 15:29:27] (index) database connection response
[06 Nov 2020 15:29:27] (index) getPatientReportsDetail() entered
[06 Nov 2020 15:29:27] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200477190', 'M0100000641369', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 15:29:27] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200477190', 'M0100000641369', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 15:29:27] (index) p_Stop=N
[06 Nov 2020 15:29:27] (index) p_Alert=
[06 Nov 2020 15:29:27] (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
[06 Nov 2020 15:29:27] (index) database connection response
[06 Nov 2020 15:29:27] (index) getConnectionClose() called....
[06 Nov 2020 15:29:27] (index) getConnectionClose() called....
[06 Nov 2020 16:11:50] (index) database connection response
[06 Nov 2020 16:11:50] (index) getConnection(): Resource id #1
[06 Nov 2020 16:11:50] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'POP-UP'
[06 Nov 2020 16:11:50] (index) database connection response
[06 Nov 2020 16:11:50] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'PLUG-IN'
[06 Nov 2020 16:11:50] (index) database connection response
[06 Nov 2020 16:11:50] (index) getQueryExecuted():  SELECT INSTRUCTIONS FROM  CCWEB.BROWSER_WISE_INSTRUCTIONS   WHERE UPPER(BROWSER_NAME) = 'CHROME' 	   AND BROWSER_VERSION = '79'  	   AND INSTRUCTION_TYPE = 'DOWNLOAD PDF'
[06 Nov 2020 16:11:50] (index) database connection response
[06 Nov 2020 16:11:50] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200477190'  AND ACCESS_CODE = '30682932'
[06 Nov 2020 16:11:50] (index) database connection response
[06 Nov 2020 16:11:50] (index) getQueryExecuted():  SELECT INVOICE_NO, MRNO,   TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS  INVOICE_DATE FROM   BILLING.INVOICE_MASTER   WHERE INVOICE_NO = 'M01200477190'  AND ACCESS_CODE = '30682932'  AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6)
[06 Nov 2020 16:11:50] (index) database connection response
[06 Nov 2020 16:11:50] (index) getQueryExecuted():  SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO,    MRNO,    NAME    FROM   REGISTRATION.PATIENT    WHERE MRNO =  'M0100000641369'
[06 Nov 2020 16:11:50] (index) database connection response
[06 Nov 2020 16:11:50] (index) getPatientReportsDetail() entered
[06 Nov 2020 16:11:50] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200477190', 'M0100000641369', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 16:11:50] (index) BEGIN  HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200477190', 'M0100000641369', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient',  :p_Stop , :p_Alert );  END;
[06 Nov 2020 16:11:50] (index) p_Stop=N
[06 Nov 2020 16:11:50] (index) p_Alert=
[06 Nov 2020 16:11: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
[06 Nov 2020 16:11:50] (index) database connection response
[06 Nov 2020 16:11:50] (index) getConnectionClose() called....
[06 Nov 2020 16:11:50] (index) getConnectionClose() called....