[16 Nov 2020 00:10:17] (index) database connection response [16 Nov 2020 00:10:17] (index) getConnection(): Resource id #1 [16 Nov 2020 00:10:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 00:10:17] (index) database connection response [16 Nov 2020 00:10:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 00:10:17] (index) database connection response [16 Nov 2020 00:10:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 00:10:17] (index) database connection response [16 Nov 2020 00:10:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492861' AND ACCESS_CODE = '83690477' [16 Nov 2020 00:10:17] (index) database connection response [16 Nov 2020 00:10:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492861' AND ACCESS_CODE = '83690477' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 00:10:17] (index) database connection response [16 Nov 2020 00:10:17] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000642971' [16 Nov 2020 00:10:17] (index) database connection response [16 Nov 2020 00:10:17] (index) getPatientReportsDetail() entered [16 Nov 2020 00:10:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492861', 'M0100000642971', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:10:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492861', 'M0100000642971', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:10:17] (index) p_Stop=N [16 Nov 2020 00:10:17] (index) p_Alert= [16 Nov 2020 00:10:17] (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 [16 Nov 2020 00:10:17] (index) database connection response [16 Nov 2020 00:10:17] (index) getConnectionClose() called.... [16 Nov 2020 00:10:17] (index) getConnectionClose() called.... [16 Nov 2020 00:15:56] (index) database connection response [16 Nov 2020 00:15:56] (index) getConnection(): Resource id #1 [16 Nov 2020 00:15:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 00:15:56] (index) database connection response [16 Nov 2020 00:15:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 00:15:56] (index) database connection response [16 Nov 2020 00:15:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 00:15:56] (index) database connection response [16 Nov 2020 00:15:56] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492861' AND ACCESS_CODE = '83690477' [16 Nov 2020 00:15:56] (index) database connection response [16 Nov 2020 00:15:56] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492861' AND ACCESS_CODE = '83690477' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 00:15:56] (index) database connection response [16 Nov 2020 00:15:56] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000642971' [16 Nov 2020 00:15:56] (index) database connection response [16 Nov 2020 00:15:56] (index) getPatientReportsDetail() entered [16 Nov 2020 00:15:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492861', 'M0100000642971', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:15:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492861', 'M0100000642971', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:15:56] (index) p_Stop=N [16 Nov 2020 00:15:56] (index) p_Alert= [16 Nov 2020 00:15:56] (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 [16 Nov 2020 00:15:56] (index) database connection response [16 Nov 2020 00:15:56] (index) getConnectionClose() called.... [16 Nov 2020 00:15:56] (index) getConnectionClose() called.... [16 Nov 2020 00:37:28] (index) database connection response [16 Nov 2020 00:37:28] (index) getConnection(): Resource id #1 [16 Nov 2020 00:37:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 00:37:28] (index) database connection response [16 Nov 2020 00:37:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 00:37:28] (index) database connection response [16 Nov 2020 00:37:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 00:37:28] (index) database connection response [16 Nov 2020 00:37:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492991' AND ACCESS_CODE = '81768598' [16 Nov 2020 00:37:28] (index) database connection response [16 Nov 2020 00:37:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492991' AND ACCESS_CODE = '81768598' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 00:37:28] (index) database connection response [16 Nov 2020 00:37:28] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000529131' [16 Nov 2020 00:37:28] (index) database connection response [16 Nov 2020 00:37:28] (index) getPatientReportsDetail() entered [16 Nov 2020 00:37:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492991', 'M0100000529131', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:37:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492991', 'M0100000529131', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:37:28] (index) p_Stop=N [16 Nov 2020 00:37:28] (index) p_Alert= [16 Nov 2020 00:37: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 [16 Nov 2020 00:37:28] (index) database connection response [16 Nov 2020 00:37:28] (index) getConnectionClose() called.... [16 Nov 2020 00:37:28] (index) getConnectionClose() called.... [16 Nov 2020 00:37:42] (viewOnlineReports) database connection response [16 Nov 2020 00:37:42] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 00:37:42] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000529131', '001', '200422318', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:37:42] (viewOnlineReports) p_Stop=N [16 Nov 2020 00:37:42] (viewOnlineReports) p_Alert= [16 Nov 2020 00:37:42] (viewOnlineReports) Flag = 1 [16 Nov 2020 00:37:42] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200422318', 'M01', '070', '1', '001000000000087630', 'M0100000529131_M01MOL20012636_1.PDF', 'M0100000529131', SYSDATE) [16 Nov 2020 00:37:42] (viewOnlineReports) database connection response [16 Nov 2020 00:37:42] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422318' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [16 Nov 2020 00:37:42] (viewOnlineReports) database connection response [16 Nov 2020 00:37:42] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 00:37:42] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422318/ [16 Nov 2020 00:37:42] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422318/ [16 Nov 2020 00:37:42] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201115\M01\M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:37:42] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422318/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605469062M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:37:42] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422318/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605469062M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:37:42] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [16 Nov 2020 00:37:42] (viewOnlineReports) Converting PDF to JPG with name as M0100000529131_M01MOL20012636_1.jpg [16 Nov 2020 00:37:42] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200422318/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605469062M0100000529131_M01MOL20012636_1.PDF ../../TEMP_PDF/200422318/M0100000529131_M01MOL20012636_1.jpg [16 Nov 2020 00:37:42] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200422318/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605469062M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:37:53] (viewOnlineReports) database connection response [16 Nov 2020 00:37:53] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 00:37:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000529131', '001', '200422318', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:37:53] (viewOnlineReports) p_Stop=N [16 Nov 2020 00:37:53] (viewOnlineReports) p_Alert= [16 Nov 2020 00:37:53] (viewOnlineReports) Flag = 1 [16 Nov 2020 00:37:53] (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', '200422318', 'M01', '070', '1', '001000000000087630', 'M0100000529131_M01MOL20012636_1.PDF', 'M0100000529131', SYSDATE) [16 Nov 2020 00:37:53] (viewOnlineReports) database connection response [16 Nov 2020 00:37:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422318' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [16 Nov 2020 00:37:53] (viewOnlineReports) database connection response [16 Nov 2020 00:37:53] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 00:37:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422318/ [16 Nov 2020 00:37:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422318/ [16 Nov 2020 00:37:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201115\M01\M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:37:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422318/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605469073M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:37:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422318/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605469073M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:37:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [16 Nov 2020 00:37:53] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200422318/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605469073M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:38:06] (viewOnlineReports) database connection response [16 Nov 2020 00:38:06] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 00:38:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000529131', '001', '200422318', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:38:06] (viewOnlineReports) p_Stop=N [16 Nov 2020 00:38:06] (viewOnlineReports) p_Alert= [16 Nov 2020 00:38:06] (viewOnlineReports) Flag = 1 [16 Nov 2020 00:38:06] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200422318', 'M01', '070', '1', '001000000000087630', 'M0100000529131_M01MOL20012636_1.PDF', 'M0100000529131', SYSDATE) [16 Nov 2020 00:38:06] (viewOnlineReports) database connection response [16 Nov 2020 00:38:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422318' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [16 Nov 2020 00:38:06] (viewOnlineReports) database connection response [16 Nov 2020 00:38:06] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 00:38:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422318/ [16 Nov 2020 00:38:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422318/ [16 Nov 2020 00:38:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201115\M01\M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:38:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422318/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469086M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:38:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422318/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469086M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:38:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [16 Nov 2020 00:38:06] (viewOnlineReports) Converting PDF to JPG with name as M0100000529131_M01MOL20012636_1.jpg [16 Nov 2020 00:38:06] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200422318/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469086M0100000529131_M01MOL20012636_1.PDF ../../TEMP_PDF/200422318/M0100000529131_M01MOL20012636_1.jpg [16 Nov 2020 00:38:07] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200422318/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469086M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:38:27] (viewOnlineReports) database connection response [16 Nov 2020 00:38:27] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 00:38:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000529131', '001', '200422318', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:38:27] (viewOnlineReports) p_Stop=N [16 Nov 2020 00:38:27] (viewOnlineReports) p_Alert= [16 Nov 2020 00:38:27] (viewOnlineReports) Flag = 1 [16 Nov 2020 00:38:27] (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', '200422318', 'M01', '070', '1', '001000000000087630', 'M0100000529131_M01MOL20012636_1.PDF', 'M0100000529131', SYSDATE) [16 Nov 2020 00:38:27] (viewOnlineReports) database connection response [16 Nov 2020 00:38:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422318' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [16 Nov 2020 00:38:27] (viewOnlineReports) database connection response [16 Nov 2020 00:38:27] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 00:38:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422318/ [16 Nov 2020 00:38:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422318/ [16 Nov 2020 00:38:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201115\M01\M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:38:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422318/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469107M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:38:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422318/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469107M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:38:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 00:38:27] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422318/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469107M0100000529131_M01MOL20012636_1.PDF [16 Nov 2020 00:39:29] (index) database connection response [16 Nov 2020 00:39:29] (index) getConnection(): Resource id #1 [16 Nov 2020 00:39:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 00:39:29] (index) database connection response [16 Nov 2020 00:39:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 00:39:29] (index) database connection response [16 Nov 2020 00:39:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 00:39:29] (index) database connection response [16 Nov 2020 00:39:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492992' AND ACCESS_CODE = '27989479' [16 Nov 2020 00:39:29] (index) database connection response [16 Nov 2020 00:39:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492992' AND ACCESS_CODE = '27989479' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 00:39:29] (index) database connection response [16 Nov 2020 00:39:29] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000517309' [16 Nov 2020 00:39:29] (index) database connection response [16 Nov 2020 00:39:29] (index) getPatientReportsDetail() entered [16 Nov 2020 00:39:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492992', 'M0100000517309', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:39:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492992', 'M0100000517309', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:39:29] (index) p_Stop=N [16 Nov 2020 00:39:29] (index) p_Alert= [16 Nov 2020 00:39:29] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [16 Nov 2020 00:39:29] (index) database connection response [16 Nov 2020 00:39:29] (index) getConnectionClose() called.... [16 Nov 2020 00:39:29] (index) getConnectionClose() called.... [16 Nov 2020 00:39:34] (viewOnlineReports) database connection response [16 Nov 2020 00:39:34] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 00:39:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000517309', '001', '200422317', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 00:39:34] (viewOnlineReports) p_Stop=N [16 Nov 2020 00:39:34] (viewOnlineReports) p_Alert= [16 Nov 2020 00:39:34] (viewOnlineReports) Flag = 1 [16 Nov 2020 00:39: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', '200422317', 'M01', '070', '1', '001000000000087630', 'M0100000517309_M01MOL20012635_1.PDF', 'M0100000517309', SYSDATE) [16 Nov 2020 00:39:34] (viewOnlineReports) database connection response [16 Nov 2020 00:39:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422317' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [16 Nov 2020 00:39:34] (viewOnlineReports) database connection response [16 Nov 2020 00:39:34] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 00:39:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422317/ [16 Nov 2020 00:39:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422317/ [16 Nov 2020 00:39:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201115\M01\M0100000517309_M01MOL20012635_1.PDF [16 Nov 2020 00:39:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422317/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469174M0100000517309_M01MOL20012635_1.PDF [16 Nov 2020 00:39:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422317/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469174M0100000517309_M01MOL20012635_1.PDF [16 Nov 2020 00:39:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 00:39:34] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422317/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605469174M0100000517309_M01MOL20012635_1.PDF [16 Nov 2020 07:11:20] (index) database connection response [16 Nov 2020 07:11:20] (index) getConnection(): Resource id #2 [16 Nov 2020 07:11:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 07:11:20] (index) database connection response [16 Nov 2020 07:11:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 07:11:20] (index) database connection response [16 Nov 2020 07:11:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 07:11:20] (index) database connection response [16 Nov 2020 07:11:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492861' AND ACCESS_CODE = '83690477' [16 Nov 2020 07:11:20] (index) database connection response [16 Nov 2020 07:11:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200492861' AND ACCESS_CODE = '83690477' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 07:11:20] (index) database connection response [16 Nov 2020 07:11:20] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000642971' [16 Nov 2020 07:11:20] (index) database connection response [16 Nov 2020 07:11:20] (index) getPatientReportsDetail() entered [16 Nov 2020 07:11:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492861', 'M0100000642971', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:11:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200492861', 'M0100000642971', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:11:20] (index) p_Stop=N [16 Nov 2020 07:11:20] (index) p_Alert= [16 Nov 2020 07:11:20] (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 [16 Nov 2020 07:11:20] (index) database connection response [16 Nov 2020 07:11:20] (index) getConnectionClose() called.... [16 Nov 2020 07:11:20] (index) getConnectionClose() called.... [16 Nov 2020 07:54:47] (index) database connection response [16 Nov 2020 07:54:47] (index) getConnection(): Resource id #1 [16 Nov 2020 07:54:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 07:54:47] (index) database connection response [16 Nov 2020 07:54:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 07:54:47] (index) database connection response [16 Nov 2020 07:54:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 07:54:47] (index) database connection response [16 Nov 2020 07:54:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200484086' AND ACCESS_CODE = '53111986' [16 Nov 2020 07:54:47] (index) database connection response [16 Nov 2020 07:54:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200484086' AND ACCESS_CODE = '53111986' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 07:54:47] (index) database connection response [16 Nov 2020 07:54:47] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000588878' [16 Nov 2020 07:54:47] (index) database connection response [16 Nov 2020 07:54:47] (index) getPatientReportsDetail() entered [16 Nov 2020 07:54:47] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200484086', 'M0100000588878', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:54:47] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200484086', 'M0100000588878', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:54:47] (index) p_Stop=N [16 Nov 2020 07:54:47] (index) p_Alert= [16 Nov 2020 07:54: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 [16 Nov 2020 07:54:47] (index) database connection response [16 Nov 2020 07:54:47] (index) getConnectionClose() called.... [16 Nov 2020 07:54:47] (index) getConnectionClose() called.... [16 Nov 2020 07:55:28] (viewOnlineReports) database connection response [16 Nov 2020 07:55:28] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 07:55:28] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000588878', '001', '200419414', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:55:28] (viewOnlineReports) p_Stop=N [16 Nov 2020 07:55:28] (viewOnlineReports) p_Alert= [16 Nov 2020 07:55:28] (viewOnlineReports) Flag = 1 [16 Nov 2020 07:55: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', '200419414', 'M01', '047', '1', '001000000000085025', 'M0100000588878_M01HEM20016004_1.PDF', 'M0100000588878', SYSDATE) [16 Nov 2020 07:55:28] (viewOnlineReports) database connection response [16 Nov 2020 07:55:28] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200419414' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [16 Nov 2020 07:55:28] (viewOnlineReports) database connection response [16 Nov 2020 07:55:28] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 07:55:28] (viewOnlineReports) creating directory structure../../TEMP_PDF/200419414/ [16 Nov 2020 07:55:28] (viewOnlineReports) directory structure created ../../TEMP_PDF/200419414/ [16 Nov 2020 07:55:28] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201110\M01\M0100000588878_M01HEM20016004_1.PDF [16 Nov 2020 07:55:28] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200419414/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1605495328M0100000588878_M01HEM20016004_1.PDF [16 Nov 2020 07:55:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200419414/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1605495328M0100000588878_M01HEM20016004_1.PDF [16 Nov 2020 07:55:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 07:55:28] (viewOnlineReports) Downloading file ../../TEMP_PDF/200419414/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1605495328M0100000588878_M01HEM20016004_1.PDF [16 Nov 2020 07:56:06] (viewOnlineReports) database connection response [16 Nov 2020 07:56:06] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 07:56:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000588878', '001', '200419414', '2', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:56:06] (viewOnlineReports) p_Stop=N [16 Nov 2020 07:56:06] (viewOnlineReports) p_Alert= [16 Nov 2020 07:56:06] (viewOnlineReports) Flag = 1 [16 Nov 2020 07:56:06] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200419414', 'M01', '047', '2', '001000000000081028', 'M0100000588878_M01RCH20021726_2.PDF', 'M0100000588878', SYSDATE) [16 Nov 2020 07:56:06] (viewOnlineReports) database connection response [16 Nov 2020 07:56:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200419414' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [16 Nov 2020 07:56:06] (viewOnlineReports) database connection response [16 Nov 2020 07:56:06] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 07:56:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200419414/ [16 Nov 2020 07:56:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200419414/ [16 Nov 2020 07:56:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201110\M01\M0100000588878_M01RCH20021726_2.PDF [16 Nov 2020 07:56:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200419414/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605495366M0100000588878_M01RCH20021726_2.PDF [16 Nov 2020 07:56:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200419414/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605495366M0100000588878_M01RCH20021726_2.PDF [16 Nov 2020 07:56:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 07:56:06] (viewOnlineReports) Downloading file ../../TEMP_PDF/200419414/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605495366M0100000588878_M01RCH20021726_2.PDF [16 Nov 2020 07:56:23] (viewOnlineReports) database connection response [16 Nov 2020 07:56:23] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 07:56:23] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000588878', '001', '200419414', '3', '001000000000080058', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:56:23] (viewOnlineReports) p_Stop=N [16 Nov 2020 07:56:23] (viewOnlineReports) p_Alert= [16 Nov 2020 07:56:23] (viewOnlineReports) Flag = 1 [16 Nov 2020 07:56:23] (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', '200419414', 'M01', '047', '3', '001000000000080058', 'M0100000588878_M01RCH20021726_1.PDF', 'M0100000588878', SYSDATE) [16 Nov 2020 07:56:23] (viewOnlineReports) database connection response [16 Nov 2020 07:56:23] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200419414' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [16 Nov 2020 07:56:23] (viewOnlineReports) database connection response [16 Nov 2020 07:56:23] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 07:56:23] (viewOnlineReports) creating directory structure../../TEMP_PDF/200419414/ [16 Nov 2020 07:56:23] (viewOnlineReports) directory structure created ../../TEMP_PDF/200419414/ [16 Nov 2020 07:56:23] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201110\M01\M0100000588878_M01RCH20021726_1.PDF [16 Nov 2020 07:56:23] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200419414/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495383M0100000588878_M01RCH20021726_1.PDF [16 Nov 2020 07:56:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200419414/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495383M0100000588878_M01RCH20021726_1.PDF [16 Nov 2020 07:56:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 07:56:23] (viewOnlineReports) Downloading file ../../TEMP_PDF/200419414/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495383M0100000588878_M01RCH20021726_1.PDF [16 Nov 2020 07:56:41] (viewOnlineReports) database connection response [16 Nov 2020 07:56:41] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 07:56:41] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000588878', '001', '200419414', '4', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:56:41] (viewOnlineReports) p_Stop=N [16 Nov 2020 07:56:41] (viewOnlineReports) p_Alert= [16 Nov 2020 07:56:41] (viewOnlineReports) Flag = 1 [16 Nov 2020 07:56:41] (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', '200419414', 'M01', '047', '4', '001000000000087100', 'M0100000588878_M01MIC20008796_1.PDF', 'M0100000588878', SYSDATE) [16 Nov 2020 07:56:41] (viewOnlineReports) database connection response [16 Nov 2020 07:56:41] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200419414' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [16 Nov 2020 07:56:41] (viewOnlineReports) database connection response [16 Nov 2020 07:56:41] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 07:56:41] (viewOnlineReports) creating directory structure../../TEMP_PDF/200419414/ [16 Nov 2020 07:56:41] (viewOnlineReports) directory structure created ../../TEMP_PDF/200419414/ [16 Nov 2020 07:56:41] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201110\M01\M0100000588878_M01MIC20008796_1.PDF [16 Nov 2020 07:56:41] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200419414/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1605495401M0100000588878_M01MIC20008796_1.PDF [16 Nov 2020 07:56:41] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200419414/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1605495401M0100000588878_M01MIC20008796_1.PDF [16 Nov 2020 07:56:41] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 07:56:41] (viewOnlineReports) Downloading file ../../TEMP_PDF/200419414/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1605495401M0100000588878_M01MIC20008796_1.PDF [16 Nov 2020 07:56:58] (viewOnlineReports) database connection response [16 Nov 2020 07:56:58] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 07:56:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000588878', '001', '200419414', '5', '001000000000081262', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:56:58] (viewOnlineReports) p_Stop=N [16 Nov 2020 07:56:58] (viewOnlineReports) p_Alert= [16 Nov 2020 07:56:58] (viewOnlineReports) Flag = 1 [16 Nov 2020 07:56:58] (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', '200419414', 'M01', '047', '5', '001000000000081262', 'M0100000588878_M01HEM20016005_4.PDF', 'M0100000588878', SYSDATE) [16 Nov 2020 07:56:58] (viewOnlineReports) database connection response [16 Nov 2020 07:56:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200419414' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [16 Nov 2020 07:56:58] (viewOnlineReports) database connection response [16 Nov 2020 07:56:58] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 07:56:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200419414/ [16 Nov 2020 07:56:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200419414/ [16 Nov 2020 07:56:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201110\M01\M0100000588878_M01HEM20016005_4.PDF [16 Nov 2020 07:56:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200419414/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1605495418M0100000588878_M01HEM20016005_4.PDF [16 Nov 2020 07:56:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200419414/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1605495418M0100000588878_M01HEM20016005_4.PDF [16 Nov 2020 07:56:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 07:56:58] (viewOnlineReports) Downloading file ../../TEMP_PDF/200419414/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1605495418M0100000588878_M01HEM20016005_4.PDF [16 Nov 2020 07:57:32] (viewOnlineReports) database connection response [16 Nov 2020 07:57:32] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 07:57:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000588878', '001', '200419414', '5', '001000000000085002', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:57:32] (viewOnlineReports) p_Stop=N [16 Nov 2020 07:57:32] (viewOnlineReports) p_Alert= [16 Nov 2020 07:57:32] (viewOnlineReports) Flag = 1 [16 Nov 2020 07:57:32] (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', '200419414', 'M01', '047', '5', '001000000000085002', 'M0100000588878_M01HEM20016005_2.PDF', 'M0100000588878', SYSDATE) [16 Nov 2020 07:57:32] (viewOnlineReports) database connection response [16 Nov 2020 07:57:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200419414' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [16 Nov 2020 07:57:32] (viewOnlineReports) database connection response [16 Nov 2020 07:57:32] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 07:57:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200419414/ [16 Nov 2020 07:57:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200419414/ [16 Nov 2020 07:57:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201110\M01\M0100000588878_M01HEM20016005_2.PDF [16 Nov 2020 07:57:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200419414/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495452M0100000588878_M01HEM20016005_2.PDF [16 Nov 2020 07:57:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200419414/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495452M0100000588878_M01HEM20016005_2.PDF [16 Nov 2020 07:57:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 07:57:32] (viewOnlineReports) Downloading file ../../TEMP_PDF/200419414/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495452M0100000588878_M01HEM20016005_2.PDF [16 Nov 2020 07:57:48] (viewOnlineReports) database connection response [16 Nov 2020 07:57:48] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 07:57:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000588878', '001', '200419414', '5', '001000000000085348', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 07:57:48] (viewOnlineReports) p_Stop=N [16 Nov 2020 07:57:48] (viewOnlineReports) p_Alert= [16 Nov 2020 07:57:48] (viewOnlineReports) Flag = 1 [16 Nov 2020 07:57: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', '200419414', 'M01', '047', '5', '001000000000085348', 'M0100000588878_M01HEM20016005_5.PDF', 'M0100000588878', SYSDATE) [16 Nov 2020 07:57:48] (viewOnlineReports) database connection response [16 Nov 2020 07:57:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200419414' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [16 Nov 2020 07:57:48] (viewOnlineReports) database connection response [16 Nov 2020 07:57:48] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 07:57:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200419414/ [16 Nov 2020 07:57:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200419414/ [16 Nov 2020 07:57:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201110\M01\M0100000588878_M01HEM20016005_5.PDF [16 Nov 2020 07:57:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200419414/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495468M0100000588878_M01HEM20016005_5.PDF [16 Nov 2020 07:57:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200419414/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495468M0100000588878_M01HEM20016005_5.PDF [16 Nov 2020 07:57:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 07:57:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200419414/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605495468M0100000588878_M01HEM20016005_5.PDF [16 Nov 2020 12:59:54] (index) database connection response [16 Nov 2020 12:59:54] (index) getConnection(): Resource id #1 [16 Nov 2020 12:59:54] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 12:59:54] (index) database connection response [16 Nov 2020 12:59:54] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 12:59:54] (index) database connection response [16 Nov 2020 12:59:54] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 12:59:54] (index) database connection response [16 Nov 2020 12:59:54] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200489150' AND ACCESS_CODE = 'M01200367031' [16 Nov 2020 12:59:54] (index) database connection response [16 Nov 2020 12:59:54] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200489150' AND ACCESS_CODE = 'M01200367031' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 12:59:54] (index) database connection response [16 Nov 2020 12:59:54] (index) getConnectionClose() called.... [16 Nov 2020 13:00:47] (index) database connection response [16 Nov 2020 13:00:47] (index) getConnection(): Resource id #1 [16 Nov 2020 13:00:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 13:00:47] (index) database connection response [16 Nov 2020 13:00:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 13:00:47] (index) database connection response [16 Nov 2020 13:00:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 13:00:47] (index) database connection response [16 Nov 2020 13:00:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200489150' AND ACCESS_CODE = 'S06REP00078' [16 Nov 2020 13:00:47] (index) database connection response [16 Nov 2020 13:00:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200489150' AND ACCESS_CODE = 'S06REP00078' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 13:00:47] (index) database connection response [16 Nov 2020 13:00:47] (index) getConnectionClose() called.... [16 Nov 2020 14:41:28] (index) database connection response [16 Nov 2020 14:41:28] (index) getConnection(): Resource id #1 [16 Nov 2020 14:41:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 14:41:28] (index) database connection response [16 Nov 2020 14:41:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 14:41:28] (index) database connection response [16 Nov 2020 14:41:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 14:41:28] (index) database connection response [16 Nov 2020 14:41:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200471273' AND ACCESS_CODE = '000-00609578' [16 Nov 2020 14:41:29] (index) database connection response [16 Nov 2020 14:41:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200471273' AND ACCESS_CODE = '000-00609578' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 14:41:29] (index) database connection response [16 Nov 2020 14:41:29] (index) getConnectionClose() called.... [16 Nov 2020 14:42:08] (index) database connection response [16 Nov 2020 14:42:08] (index) getConnection(): Resource id #1 [16 Nov 2020 14:42:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 14:42:08] (index) database connection response [16 Nov 2020 14:42:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 14:42:08] (index) database connection response [16 Nov 2020 14:42:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 14:42:08] (index) database connection response [16 Nov 2020 14:42:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200471273' AND ACCESS_CODE = '20-0415329' [16 Nov 2020 14:42:08] (index) database connection response [16 Nov 2020 14:42:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200471273' AND ACCESS_CODE = '20-0415329' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 14:42:08] (index) database connection response [16 Nov 2020 14:42:08] (index) getConnectionClose() called.... [16 Nov 2020 17:02:07] (index) database connection response [16 Nov 2020 17:02:07] (index) getConnection(): Resource id #1 [16 Nov 2020 17:02:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 17:02:07] (index) database connection response [16 Nov 2020 17:02:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 17:02:07] (index) database connection response [16 Nov 2020 17:02:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 17:02:07] (index) database connection response [16 Nov 2020 17:02:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493845' AND ACCESS_CODE = '67017062' [16 Nov 2020 17:02:07] (index) database connection response [16 Nov 2020 17:02:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493845' AND ACCESS_CODE = '67017062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 17:02:07] (index) database connection response [16 Nov 2020 17:02:07] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 17:02:07] (index) database connection response [16 Nov 2020 17:02:07] (index) getPatientReportsDetail() entered [16 Nov 2020 17:02:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493845', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:02:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493845', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:02:07] (index) p_Stop=N [16 Nov 2020 17:02:07] (index) p_Alert= [16 Nov 2020 17:02:07] (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 [16 Nov 2020 17:02:07] (index) database connection response [16 Nov 2020 17:02:07] (index) getConnectionClose() called.... [16 Nov 2020 17:02:07] (index) getConnectionClose() called.... [16 Nov 2020 17:02:13] (index) database connection response [16 Nov 2020 17:02:13] (index) getConnection(): Resource id #1 [16 Nov 2020 17:02:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 17:02:13] (index) database connection response [16 Nov 2020 17:02:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 17:02:13] (index) database connection response [16 Nov 2020 17:02:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 17:02:13] (index) database connection response [16 Nov 2020 17:02:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01MOL200125' AND ACCESS_CODE = '-00000642855' [16 Nov 2020 17:02:14] (index) database connection response [16 Nov 2020 17:02:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01MOL200125' AND ACCESS_CODE = '-00000642855' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 17:02:14] (index) database connection response [16 Nov 2020 17:02:14] (index) getConnectionClose() called.... [16 Nov 2020 17:02:48] (viewOnlineReports) database connection response [16 Nov 2020 17:02:48] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 17:02:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000643059', '001', '200422542', '3', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:02:48] (viewOnlineReports) p_Stop=N [16 Nov 2020 17:02:48] (viewOnlineReports) p_Alert= [16 Nov 2020 17:02:48] (viewOnlineReports) Flag = 1 [16 Nov 2020 17:02: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', '200422542', 'M01', '047', '3', '001000000000086354', 'M0100000643059_M01MIC20008970_1.PDF', 'M0100000643059', SYSDATE) [16 Nov 2020 17:02:49] (viewOnlineReports) database connection response [16 Nov 2020 17:02:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422542' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [16 Nov 2020 17:02:49] (viewOnlineReports) database connection response [16 Nov 2020 17:02:49] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 17:02:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422542/ [16 Nov 2020 17:02:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422542/ [16 Nov 2020 17:02:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:02:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422542/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1605528168M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:02:49] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422542/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1605528168M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:02:49] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [16 Nov 2020 17:02:49] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200422542/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1605528168M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:02:53] (index) database connection response [16 Nov 2020 17:02:53] (index) getConnection(): Resource id #1 [16 Nov 2020 17:02:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 17:02:53] (index) database connection response [16 Nov 2020 17:02:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 17:02:53] (index) database connection response [16 Nov 2020 17:02:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 17:02:53] (index) database connection response [16 Nov 2020 17:02:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01MOL200125' AND ACCESS_CODE = '642855' [16 Nov 2020 17:02:53] (index) database connection response [16 Nov 2020 17:02:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01MOL200125' AND ACCESS_CODE = '642855' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 17:02:53] (index) database connection response [16 Nov 2020 17:02:53] (index) getConnectionClose() called.... [16 Nov 2020 17:03:04] (viewOnlineReports) database connection response [16 Nov 2020 17:03:04] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 17:03:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000643059', '001', '200422542', '3', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:03:04] (viewOnlineReports) p_Stop=N [16 Nov 2020 17:03:04] (viewOnlineReports) p_Alert= [16 Nov 2020 17:03:04] (viewOnlineReports) Flag = 1 [16 Nov 2020 17:03: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', '200422542', 'M01', '047', '3', '001000000000086354', 'M0100000643059_M01MIC20008970_1.PDF', 'M0100000643059', SYSDATE) [16 Nov 2020 17:03:04] (viewOnlineReports) database connection response [16 Nov 2020 17:03:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422542' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [16 Nov 2020 17:03:04] (viewOnlineReports) database connection response [16 Nov 2020 17:03:04] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 17:03:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422542/ [16 Nov 2020 17:03:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422542/ [16 Nov 2020 17:03:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:03:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1605528184M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:03:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1605528184M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:03:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 17:03:04] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1605528184M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:04:42] (viewOnlineReports) database connection response [16 Nov 2020 17:04:42] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 17:04:42] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000643059', '001', '200422542', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:04:42] (viewOnlineReports) p_Stop=N [16 Nov 2020 17:04:42] (viewOnlineReports) p_Alert= [16 Nov 2020 17:04:42] (viewOnlineReports) Flag = 1 [16 Nov 2020 17:04:42] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200422542', 'M01', '047', '1', '001000000000085025', 'M0100000643059_M01HEM20016375_1.PDF', 'M0100000643059', SYSDATE) [16 Nov 2020 17:04:42] (viewOnlineReports) database connection response [16 Nov 2020 17:04:42] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422542' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [16 Nov 2020 17:04:42] (viewOnlineReports) database connection response [16 Nov 2020 17:04:42] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 17:04:42] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422542/ [16 Nov 2020 17:04:42] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422542/ [16 Nov 2020 17:04:42] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643059_M01HEM20016375_1.PDF [16 Nov 2020 17:04:42] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1605528282M0100000643059_M01HEM20016375_1.PDF [16 Nov 2020 17:04:42] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1605528282M0100000643059_M01HEM20016375_1.PDF [16 Nov 2020 17:04:42] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 17:04:42] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1605528282M0100000643059_M01HEM20016375_1.PDF [16 Nov 2020 17:07:43] (index) database connection response [16 Nov 2020 17:07:43] (index) getConnection(): Resource id #1 [16 Nov 2020 17:07:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 17:07:43] (index) database connection response [16 Nov 2020 17:07:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 17:07:43] (index) database connection response [16 Nov 2020 17:07:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 17:07:43] (index) database connection response [16 Nov 2020 17:07:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 17:07:44] (index) database connection response [16 Nov 2020 17:07:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 17:07:44] (index) database connection response [16 Nov 2020 17:07:44] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 17:07:44] (index) database connection response [16 Nov 2020 17:07:44] (index) getPatientReportsDetail() entered [16 Nov 2020 17:07:44] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:07:44] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:07:44] (index) p_Stop=N [16 Nov 2020 17:07:44] (index) p_Alert= [16 Nov 2020 17:07:44] (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 [16 Nov 2020 17:07:44] (index) database connection response [16 Nov 2020 17:07:44] (index) getConnectionClose() called.... [16 Nov 2020 17:07:44] (index) getConnectionClose() called.... [16 Nov 2020 17:09:09] (index) database connection response [16 Nov 2020 17:09:09] (index) getConnection(): Resource id #1 [16 Nov 2020 17:09:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 17:09:09] (index) database connection response [16 Nov 2020 17:09:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 17:09:09] (index) database connection response [16 Nov 2020 17:09:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 17:09:09] (index) database connection response [16 Nov 2020 17:09:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493845' AND ACCESS_CODE = '67017062' [16 Nov 2020 17:09:09] (index) database connection response [16 Nov 2020 17:09:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493845' AND ACCESS_CODE = '67017062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 17:09:09] (index) database connection response [16 Nov 2020 17:09:09] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 17:09:09] (index) database connection response [16 Nov 2020 17:09:09] (index) getPatientReportsDetail() entered [16 Nov 2020 17:09:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493845', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:09:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493845', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:09:09] (index) p_Stop=N [16 Nov 2020 17:09:09] (index) p_Alert= [16 Nov 2020 17:09:09] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [16 Nov 2020 17:09:09] (index) database connection response [16 Nov 2020 17:09:09] (index) getConnectionClose() called.... [16 Nov 2020 17:09:09] (index) getConnectionClose() called.... [16 Nov 2020 17:09:15] (viewOnlineReports) database connection response [16 Nov 2020 17:09:15] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 17:09:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000643059', '001', '200422542', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:09:15] (viewOnlineReports) p_Stop=N [16 Nov 2020 17:09:15] (viewOnlineReports) p_Alert= [16 Nov 2020 17:09:15] (viewOnlineReports) Flag = 1 [16 Nov 2020 17:09: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', '200422542', 'M01', '047', '1', '001000000000085025', 'M0100000643059_M01HEM20016375_1.PDF', 'M0100000643059', SYSDATE) [16 Nov 2020 17:09:15] (viewOnlineReports) database connection response [16 Nov 2020 17:09:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422542' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [16 Nov 2020 17:09:15] (viewOnlineReports) database connection response [16 Nov 2020 17:09:15] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 17:09:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422542/ [16 Nov 2020 17:09:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422542/ [16 Nov 2020 17:09:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643059_M01HEM20016375_1.PDF [16 Nov 2020 17:09:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422542/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605528555M0100000643059_M01HEM20016375_1.PDF [16 Nov 2020 17:09:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422542/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605528555M0100000643059_M01HEM20016375_1.PDF [16 Nov 2020 17:09:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 17:09:15] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422542/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605528555M0100000643059_M01HEM20016375_1.PDF [16 Nov 2020 17:50:42] (index) database connection response [16 Nov 2020 17:50:42] (index) getConnection(): Resource id #1 [16 Nov 2020 17:50:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 17:50:42] (index) database connection response [16 Nov 2020 17:50:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 17:50:42] (index) database connection response [16 Nov 2020 17:50:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 17:50:42] (index) database connection response [16 Nov 2020 17:50:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 17:50:42] (index) database connection response [16 Nov 2020 17:50:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 17:50:42] (index) database connection response [16 Nov 2020 17:50:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 17:50:42] (index) database connection response [16 Nov 2020 17:50:42] (index) getPatientReportsDetail() entered [16 Nov 2020 17:50:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:50:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:50:42] (index) p_Stop=N [16 Nov 2020 17:50:42] (index) p_Alert= [16 Nov 2020 17:50: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 [16 Nov 2020 17:50:42] (index) database connection response [16 Nov 2020 17:50:42] (index) getConnectionClose() called.... [16 Nov 2020 17:50:42] (index) getConnectionClose() called.... [16 Nov 2020 17:51:04] (index) database connection response [16 Nov 2020 17:51:04] (index) getConnection(): Resource id #1 [16 Nov 2020 17:51:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 17:51:04] (index) database connection response [16 Nov 2020 17:51:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 17:51:04] (index) database connection response [16 Nov 2020 17:51:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 17:51:04] (index) database connection response [16 Nov 2020 17:51:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493845' AND ACCESS_CODE = '67017062' [16 Nov 2020 17:51:04] (index) database connection response [16 Nov 2020 17:51:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493845' AND ACCESS_CODE = '67017062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 17:51:04] (index) database connection response [16 Nov 2020 17:51:04] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 17:51:04] (index) database connection response [16 Nov 2020 17:51:04] (index) getPatientReportsDetail() entered [16 Nov 2020 17:51:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493845', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:51:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493845', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:51:04] (index) p_Stop=N [16 Nov 2020 17:51:04] (index) p_Alert= [16 Nov 2020 17:51:04] (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 [16 Nov 2020 17:51:04] (index) database connection response [16 Nov 2020 17:51:04] (index) getConnectionClose() called.... [16 Nov 2020 17:51:04] (index) getConnectionClose() called.... [16 Nov 2020 17:52:30] (viewOnlineReports) database connection response [16 Nov 2020 17:52:30] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 17:52:30] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000643059', '001', '200422542', '3', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 17:52:30] (viewOnlineReports) p_Stop=N [16 Nov 2020 17:52:30] (viewOnlineReports) p_Alert= [16 Nov 2020 17:52:30] (viewOnlineReports) Flag = 1 [16 Nov 2020 17:52:30] (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', '200422542', 'M01', '047', '3', '001000000000086354', 'M0100000643059_M01MIC20008970_1.PDF', 'M0100000643059', SYSDATE) [16 Nov 2020 17:52:30] (viewOnlineReports) database connection response [16 Nov 2020 17:52:30] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422542' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [16 Nov 2020 17:52:30] (viewOnlineReports) database connection response [16 Nov 2020 17:52:30] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 17:52:30] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422542/ [16 Nov 2020 17:52:30] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422542/ [16 Nov 2020 17:52:30] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:52:30] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1605531150M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:52:30] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1605531150M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 17:52:30] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 17:52:30] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422542/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1605531150M0100000643059_M01MIC20008970_1.PDF [16 Nov 2020 18:13:48] (index) database connection response [16 Nov 2020 18:13:48] (index) getConnection(): Resource id #1 [16 Nov 2020 18:13:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 18:13:48] (index) database connection response [16 Nov 2020 18:13:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 18:13:48] (index) database connection response [16 Nov 2020 18:13:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 18:13:48] (index) database connection response [16 Nov 2020 18:13:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 18:13:48] (index) database connection response [16 Nov 2020 18:13:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 18:13:48] (index) database connection response [16 Nov 2020 18:13:48] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 18:13:48] (index) database connection response [16 Nov 2020 18:13:48] (index) getPatientReportsDetail() entered [16 Nov 2020 18:13:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 18:13:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 18:13:48] (index) p_Stop=N [16 Nov 2020 18:13:48] (index) p_Alert= [16 Nov 2020 18:13:48] (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 [16 Nov 2020 18:13:48] (index) database connection response [16 Nov 2020 18:13:48] (index) getConnectionClose() called.... [16 Nov 2020 18:13:48] (index) getConnectionClose() called.... [16 Nov 2020 18:14:27] (index) database connection response [16 Nov 2020 18:14:27] (index) getConnection(): Resource id #1 [16 Nov 2020 18:14:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 18:14:27] (index) database connection response [16 Nov 2020 18:14:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 18:14:27] (index) database connection response [16 Nov 2020 18:14:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 18:14:27] (index) database connection response [16 Nov 2020 18:14:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493845' AND ACCESS_CODE = '67017062' [16 Nov 2020 18:14:27] (index) database connection response [16 Nov 2020 18:14:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493845' AND ACCESS_CODE = '67017062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 18:14:27] (index) database connection response [16 Nov 2020 18:14:27] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 18:14:27] (index) database connection response [16 Nov 2020 18:14:27] (index) getPatientReportsDetail() entered [16 Nov 2020 18:14:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493845', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 18:14:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493845', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 18:14:27] (index) p_Stop=N [16 Nov 2020 18:14:27] (index) p_Alert= [16 Nov 2020 18:14: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 [16 Nov 2020 18:14:27] (index) database connection response [16 Nov 2020 18:14:27] (index) getConnectionClose() called.... [16 Nov 2020 18:14:27] (index) getConnectionClose() called.... [16 Nov 2020 19:22:14] (index) database connection response [16 Nov 2020 19:22:14] (index) getConnection(): Resource id #1 [16 Nov 2020 19:22:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 19:22:14] (index) database connection response [16 Nov 2020 19:22:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 19:22:14] (index) database connection response [16 Nov 2020 19:22:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 19:22:14] (index) database connection response [16 Nov 2020 19:22:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 19:22:14] (index) database connection response [16 Nov 2020 19:22:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 19:22:14] (index) database connection response [16 Nov 2020 19:22:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 19:22:14] (index) database connection response [16 Nov 2020 19:22:14] (index) getPatientReportsDetail() entered [16 Nov 2020 19:22:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 19:22:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 19:22:14] (index) p_Stop=N [16 Nov 2020 19:22:14] (index) p_Alert= [16 Nov 2020 19:22:14] (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 [16 Nov 2020 19:22:14] (index) database connection response [16 Nov 2020 19:22:14] (index) getConnectionClose() called.... [16 Nov 2020 19:22:14] (index) getConnectionClose() called.... [16 Nov 2020 20:07:55] (index) database connection response [16 Nov 2020 20:07:55] (index) getConnection(): Resource id #1 [16 Nov 2020 20:07:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 20:07:55] (index) database connection response [16 Nov 2020 20:07:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 20:07:55] (index) database connection response [16 Nov 2020 20:07:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 20:07:55] (index) database connection response [16 Nov 2020 20:07:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 20:07:55] (index) database connection response [16 Nov 2020 20:07:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 20:07:55] (index) database connection response [16 Nov 2020 20:07:55] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 20:07:55] (index) database connection response [16 Nov 2020 20:07:55] (index) getPatientReportsDetail() entered [16 Nov 2020 20:07:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 20:07:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 20:07:55] (index) p_Stop=N [16 Nov 2020 20:07:55] (index) p_Alert= [16 Nov 2020 20:07:55] (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 [16 Nov 2020 20:07:55] (index) database connection response [16 Nov 2020 20:07:55] (index) getConnectionClose() called.... [16 Nov 2020 20:07:55] (index) getConnectionClose() called.... [16 Nov 2020 20:16:03] (index) database connection response [16 Nov 2020 20:16:03] (index) getConnection(): Resource id #1 [16 Nov 2020 20:16:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 20:16:03] (index) database connection response [16 Nov 2020 20:16:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 20:16:03] (index) database connection response [16 Nov 2020 20:16:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 20:16:03] (index) database connection response [16 Nov 2020 20:16:03] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 20:16:03] (index) database connection response [16 Nov 2020 20:16:03] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 20:16:03] (index) database connection response [16 Nov 2020 20:16:03] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 20:16:03] (index) database connection response [16 Nov 2020 20:16:03] (index) getPatientReportsDetail() entered [16 Nov 2020 20:16:03] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 20:16:03] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 20:16:03] (index) p_Stop=N [16 Nov 2020 20:16:03] (index) p_Alert= [16 Nov 2020 20:16:03] (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 [16 Nov 2020 20:16:03] (index) database connection response [16 Nov 2020 20:16:03] (index) getConnectionClose() called.... [16 Nov 2020 20:16:03] (index) getConnectionClose() called.... [16 Nov 2020 20:29:07] (index) database connection response [16 Nov 2020 20:29:07] (index) getConnection(): Resource id #1 [16 Nov 2020 20:29:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 20:29:07] (index) database connection response [16 Nov 2020 20:29:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 20:29:07] (index) database connection response [16 Nov 2020 20:29:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 20:29:07] (index) database connection response [16 Nov 2020 20:29:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 20:29:07] (index) database connection response [16 Nov 2020 20:29:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 20:29:07] (index) database connection response [16 Nov 2020 20:29:07] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 20:29:07] (index) database connection response [16 Nov 2020 20:29:07] (index) getPatientReportsDetail() entered [16 Nov 2020 20:29:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 20:29:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 20:29:07] (index) p_Stop=N [16 Nov 2020 20:29:07] (index) p_Alert= [16 Nov 2020 20:29:07] (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 [16 Nov 2020 20:29:07] (index) database connection response [16 Nov 2020 20:29:07] (index) getConnectionClose() called.... [16 Nov 2020 20:29:07] (index) getConnectionClose() called.... [16 Nov 2020 20:41:59] (index) database connection response [16 Nov 2020 20:41:59] (index) getConnection(): Resource id #1 [16 Nov 2020 20:41:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 20:41:59] (index) database connection response [16 Nov 2020 20:41:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 20:41:59] (index) database connection response [16 Nov 2020 20:41:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 20:41:59] (index) database connection response [16 Nov 2020 20:41:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 20:41:59] (index) database connection response [16 Nov 2020 20:41:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 20:41:59] (index) database connection response [16 Nov 2020 20:41:59] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 20:41:59] (index) database connection response [16 Nov 2020 20:41:59] (index) getPatientReportsDetail() entered [16 Nov 2020 20:41:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 20:41:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 20:41:59] (index) p_Stop=N [16 Nov 2020 20:41:59] (index) p_Alert= [16 Nov 2020 20:41:59] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [16 Nov 2020 20:41:59] (index) database connection response [16 Nov 2020 20:41:59] (index) getConnectionClose() called.... [16 Nov 2020 20:41:59] (index) getConnectionClose() called.... [16 Nov 2020 21:25:46] (index) database connection response [16 Nov 2020 21:25:46] (index) getConnection(): Resource id #1 [16 Nov 2020 21:25:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 21:25:46] (index) database connection response [16 Nov 2020 21:25:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 21:25:46] (index) database connection response [16 Nov 2020 21:25:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 21:25:46] (index) database connection response [16 Nov 2020 21:25:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200486941' AND ACCESS_CODE = '65803245' [16 Nov 2020 21:25:46] (index) database connection response [16 Nov 2020 21:25:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200486941' AND ACCESS_CODE = '65803245' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 21:25:46] (index) database connection response [16 Nov 2020 21:25:46] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000642461' [16 Nov 2020 21:25:46] (index) database connection response [16 Nov 2020 21:25:46] (index) getPatientReportsDetail() entered [16 Nov 2020 21:25:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200486941', 'M0100000642461', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:25:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200486941', 'M0100000642461', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:25:46] (index) p_Stop=N [16 Nov 2020 21:25:46] (index) p_Alert= [16 Nov 2020 21:25:46] (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 [16 Nov 2020 21:25:46] (index) database connection response [16 Nov 2020 21:25:46] (index) getConnectionClose() called.... [16 Nov 2020 21:25:46] (index) getConnectionClose() called.... [16 Nov 2020 21:27:22] (viewOnlineReports) database connection response [16 Nov 2020 21:27:22] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 21:27:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000642461', '001', '200420330', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:27:22] (viewOnlineReports) p_Stop=N [16 Nov 2020 21:27:22] (viewOnlineReports) p_Alert= [16 Nov 2020 21:27:22] (viewOnlineReports) Flag = 1 [16 Nov 2020 21:27:22] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200420330', 'M01', '070', '1', '001000000000087630', 'M0100000642461_M01MOL20012344_1.PDF', 'M0100000642461', SYSDATE) [16 Nov 2020 21:27:22] (viewOnlineReports) database connection response [16 Nov 2020 21:27:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200420330' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [16 Nov 2020 21:27:22] (viewOnlineReports) database connection response [16 Nov 2020 21:27:22] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 21:27:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200420330/ [16 Nov 2020 21:27:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200420330/ [16 Nov 2020 21:27:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201112\M01\M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:27:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200420330/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1605544042M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:27:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200420330/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1605544042M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:27:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [16 Nov 2020 21:27:22] (viewOnlineReports) Converting PDF to JPG with name as M0100000642461_M01MOL20012344_1.jpg [16 Nov 2020 21:27:22] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200420330/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1605544042M0100000642461_M01MOL20012344_1.PDF ../../TEMP_PDF/200420330/M0100000642461_M01MOL20012344_1.jpg [16 Nov 2020 21:27:22] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200420330/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1605544042M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:27:54] (viewOnlineReports) database connection response [16 Nov 2020 21:27:54] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 21:27:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000642461', '001', '200420330', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:27:54] (viewOnlineReports) p_Stop=N [16 Nov 2020 21:27:54] (viewOnlineReports) p_Alert= [16 Nov 2020 21:27:54] (viewOnlineReports) Flag = 1 [16 Nov 2020 21:27: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', '200420330', 'M01', '070', '1', '001000000000087630', 'M0100000642461_M01MOL20012344_1.PDF', 'M0100000642461', SYSDATE) [16 Nov 2020 21:27:54] (viewOnlineReports) database connection response [16 Nov 2020 21:27:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200420330' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [16 Nov 2020 21:27:54] (viewOnlineReports) database connection response [16 Nov 2020 21:27:54] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 21:27:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200420330/ [16 Nov 2020 21:27:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200420330/ [16 Nov 2020 21:27:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201112\M01\M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:27:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200420330/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605544074M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:27:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200420330/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605544074M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:27:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [16 Nov 2020 21:27:54] (viewOnlineReports) Converting PDF to JPG with name as M0100000642461_M01MOL20012344_1.jpg [16 Nov 2020 21:27:54] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200420330/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605544074M0100000642461_M01MOL20012344_1.PDF ../../TEMP_PDF/200420330/M0100000642461_M01MOL20012344_1.jpg [16 Nov 2020 21:27:54] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200420330/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605544074M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:28:07] (viewOnlineReports) database connection response [16 Nov 2020 21:28:07] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 21:28:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000642461', '001', '200420330', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:28:07] (viewOnlineReports) p_Stop=N [16 Nov 2020 21:28:07] (viewOnlineReports) p_Alert= [16 Nov 2020 21:28:07] (viewOnlineReports) Flag = 1 [16 Nov 2020 21:28:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200420330', 'M01', '070', '1', '001000000000087630', 'M0100000642461_M01MOL20012344_1.PDF', 'M0100000642461', SYSDATE) [16 Nov 2020 21:28:07] (viewOnlineReports) database connection response [16 Nov 2020 21:28:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200420330' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [16 Nov 2020 21:28:07] (viewOnlineReports) database connection response [16 Nov 2020 21:28:07] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 21:28:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200420330/ [16 Nov 2020 21:28:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200420330/ [16 Nov 2020 21:28:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201112\M01\M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:28:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200420330/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605544087M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:28:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200420330/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605544087M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:28:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [16 Nov 2020 21:28:08] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200420330/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605544087M0100000642461_M01MOL20012344_1.PDF [16 Nov 2020 21:56:30] (index) database connection response [16 Nov 2020 21:56:30] (index) getConnection(): Resource id #1 [16 Nov 2020 21:56:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 21:56:30] (index) database connection response [16 Nov 2020 21:56:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 21:56:30] (index) database connection response [16 Nov 2020 21:56:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 21:56:30] (index) database connection response [16 Nov 2020 21:56:30] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 21:56:30] (index) database connection response [16 Nov 2020 21:56:30] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 21:56:30] (index) database connection response [16 Nov 2020 21:56:30] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 21:56:30] (index) database connection response [16 Nov 2020 21:56:30] (index) getPatientReportsDetail() entered [16 Nov 2020 21:56:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:56:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:56:30] (index) p_Stop=N [16 Nov 2020 21:56:30] (index) p_Alert= [16 Nov 2020 21:56:30] (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 [16 Nov 2020 21:56:30] (index) database connection response [16 Nov 2020 21:56:30] (index) getConnectionClose() called.... [16 Nov 2020 21:56:30] (index) getConnectionClose() called.... [16 Nov 2020 21:58:37] (index) database connection response [16 Nov 2020 21:58:37] (index) getConnection(): Resource id #1 [16 Nov 2020 21:58:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 21:58:37] (index) database connection response [16 Nov 2020 21:58:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 21:58:37] (index) database connection response [16 Nov 2020 21:58:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 21:58:37] (index) database connection response [16 Nov 2020 21:58:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 21:58:37] (index) database connection response [16 Nov 2020 21:58:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 21:58:37] (index) database connection response [16 Nov 2020 21:58:37] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 21:58:37] (index) database connection response [16 Nov 2020 21:58:37] (index) getPatientReportsDetail() entered [16 Nov 2020 21:58:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:58:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 21:58:37] (index) p_Stop=N [16 Nov 2020 21:58:37] (index) p_Alert= [16 Nov 2020 21:58:37] (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 [16 Nov 2020 21:58:37] (index) database connection response [16 Nov 2020 21:58:37] (index) getConnectionClose() called.... [16 Nov 2020 21:58:37] (index) getConnectionClose() called.... [16 Nov 2020 22:03:10] (index) database connection response [16 Nov 2020 22:03:10] (index) getConnection(): Resource id #1 [16 Nov 2020 22:03:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:03:10] (index) database connection response [16 Nov 2020 22:03:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:03:10] (index) database connection response [16 Nov 2020 22:03:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:03:10] (index) database connection response [16 Nov 2020 22:03:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:03:10] (index) database connection response [16 Nov 2020 22:03:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:03:10] (index) database connection response [16 Nov 2020 22:03:10] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:03:10] (index) database connection response [16 Nov 2020 22:03:10] (index) getPatientReportsDetail() entered [16 Nov 2020 22:03:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:03:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:03:10] (index) p_Stop=N [16 Nov 2020 22:03:10] (index) p_Alert= [16 Nov 2020 22:03:10] (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 [16 Nov 2020 22:03:10] (index) database connection response [16 Nov 2020 22:03:10] (index) getConnectionClose() called.... [16 Nov 2020 22:03:10] (index) getConnectionClose() called.... [16 Nov 2020 22:04:16] (index) database connection response [16 Nov 2020 22:04:16] (index) getConnection(): Resource id #1 [16 Nov 2020 22:04:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:04:16] (index) database connection response [16 Nov 2020 22:04:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:04:16] (index) database connection response [16 Nov 2020 22:04:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:04:16] (index) database connection response [16 Nov 2020 22:04:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:04:16] (index) database connection response [16 Nov 2020 22:04:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:04:16] (index) database connection response [16 Nov 2020 22:04:16] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:04:16] (index) database connection response [16 Nov 2020 22:04:16] (index) getPatientReportsDetail() entered [16 Nov 2020 22:04:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:04:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:04:16] (index) p_Stop=N [16 Nov 2020 22:04:16] (index) p_Alert= [16 Nov 2020 22:04: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 [16 Nov 2020 22:04:16] (index) database connection response [16 Nov 2020 22:04:16] (index) getConnectionClose() called.... [16 Nov 2020 22:04:16] (index) getConnectionClose() called.... [16 Nov 2020 22:09:14] (index) database connection response [16 Nov 2020 22:09:14] (index) getConnection(): Resource id #1 [16 Nov 2020 22:09:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:09:14] (index) database connection response [16 Nov 2020 22:09:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:09:14] (index) database connection response [16 Nov 2020 22:09:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:09:14] (index) database connection response [16 Nov 2020 22:09:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:09:14] (index) database connection response [16 Nov 2020 22:09:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:09:14] (index) database connection response [16 Nov 2020 22:09:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:09:14] (index) database connection response [16 Nov 2020 22:09:14] (index) getPatientReportsDetail() entered [16 Nov 2020 22:09:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:09:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:09:14] (index) p_Stop=N [16 Nov 2020 22:09:14] (index) p_Alert= [16 Nov 2020 22:09:14] (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 [16 Nov 2020 22:09:14] (index) database connection response [16 Nov 2020 22:09:14] (index) getConnectionClose() called.... [16 Nov 2020 22:09:14] (index) getConnectionClose() called.... [16 Nov 2020 22:18:12] (index) database connection response [16 Nov 2020 22:18:12] (index) getConnection(): Resource id #1 [16 Nov 2020 22:18:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:18:12] (index) database connection response [16 Nov 2020 22:18:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:18:12] (index) database connection response [16 Nov 2020 22:18:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:18:12] (index) database connection response [16 Nov 2020 22:18:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:18:12] (index) database connection response [16 Nov 2020 22:18:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:18:12] (index) database connection response [16 Nov 2020 22:18:12] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:18:12] (index) database connection response [16 Nov 2020 22:18:12] (index) getPatientReportsDetail() entered [16 Nov 2020 22:18:12] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:18:12] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:18:12] (index) p_Stop=N [16 Nov 2020 22:18:12] (index) p_Alert= [16 Nov 2020 22:18:12] (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 [16 Nov 2020 22:18:12] (index) database connection response [16 Nov 2020 22:18:12] (index) getConnectionClose() called.... [16 Nov 2020 22:18:12] (index) getConnectionClose() called.... [16 Nov 2020 22:20:45] (index) database connection response [16 Nov 2020 22:20:45] (index) getConnection(): Resource id #1 [16 Nov 2020 22:20:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:20:45] (index) database connection response [16 Nov 2020 22:20:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:20:45] (index) database connection response [16 Nov 2020 22:20:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:20:45] (index) database connection response [16 Nov 2020 22:20:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:20:45] (index) database connection response [16 Nov 2020 22:20:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:20:45] (index) database connection response [16 Nov 2020 22:20:45] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:20:45] (index) database connection response [16 Nov 2020 22:20:45] (index) getPatientReportsDetail() entered [16 Nov 2020 22:20:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:20:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:20:45] (index) p_Stop=N [16 Nov 2020 22:20:45] (index) p_Alert= [16 Nov 2020 22:20:45] (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 [16 Nov 2020 22:20:45] (index) database connection response [16 Nov 2020 22:20:45] (index) getConnectionClose() called.... [16 Nov 2020 22:20:45] (index) getConnectionClose() called.... [16 Nov 2020 22:25:22] (index) database connection response [16 Nov 2020 22:25:22] (index) getConnection(): Resource id #1 [16 Nov 2020 22:25:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:25:22] (index) database connection response [16 Nov 2020 22:25:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:25:22] (index) database connection response [16 Nov 2020 22:25:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:25:22] (index) database connection response [16 Nov 2020 22:25:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:25:22] (index) database connection response [16 Nov 2020 22:25:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:25:22] (index) database connection response [16 Nov 2020 22:25:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:25:22] (index) database connection response [16 Nov 2020 22:25:22] (index) getPatientReportsDetail() entered [16 Nov 2020 22:25:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:25:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:25:22] (index) p_Stop=N [16 Nov 2020 22:25:22] (index) p_Alert= [16 Nov 2020 22:25:22] (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 [16 Nov 2020 22:25:22] (index) database connection response [16 Nov 2020 22:25:22] (index) getConnectionClose() called.... [16 Nov 2020 22:25:22] (index) getConnectionClose() called.... [16 Nov 2020 22:32:02] (index) database connection response [16 Nov 2020 22:32:02] (index) getConnection(): Resource id #1 [16 Nov 2020 22:32:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:32:02] (index) database connection response [16 Nov 2020 22:32:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:32:02] (index) database connection response [16 Nov 2020 22:32:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:32:02] (index) database connection response [16 Nov 2020 22:32:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:32:02] (index) database connection response [16 Nov 2020 22:32:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:32:02] (index) database connection response [16 Nov 2020 22:32:02] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:32:02] (index) database connection response [16 Nov 2020 22:32:02] (index) getPatientReportsDetail() entered [16 Nov 2020 22:32:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:32:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:32:02] (index) p_Stop=N [16 Nov 2020 22:32:02] (index) p_Alert= [16 Nov 2020 22:32: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 [16 Nov 2020 22:32:02] (index) database connection response [16 Nov 2020 22:32:02] (index) getConnectionClose() called.... [16 Nov 2020 22:32:02] (index) getConnectionClose() called.... [16 Nov 2020 22:33:18] (index) database connection response [16 Nov 2020 22:33:18] (index) getConnection(): Resource id #1 [16 Nov 2020 22:33:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:33:18] (index) database connection response [16 Nov 2020 22:33:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:33:18] (index) database connection response [16 Nov 2020 22:33:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:33:18] (index) database connection response [16 Nov 2020 22:33:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:33:18] (index) database connection response [16 Nov 2020 22:33:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:33:18] (index) database connection response [16 Nov 2020 22:33:18] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:33:18] (index) database connection response [16 Nov 2020 22:33:18] (index) getPatientReportsDetail() entered [16 Nov 2020 22:33:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:33:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:33:18] (index) p_Stop=N [16 Nov 2020 22:33:18] (index) p_Alert= [16 Nov 2020 22:33:18] (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 [16 Nov 2020 22:33:18] (index) database connection response [16 Nov 2020 22:33:18] (index) getConnectionClose() called.... [16 Nov 2020 22:33:18] (index) getConnectionClose() called.... [16 Nov 2020 22:37:55] (index) database connection response [16 Nov 2020 22:37:55] (index) getConnection(): Resource id #1 [16 Nov 2020 22:37:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:37:55] (index) database connection response [16 Nov 2020 22:37:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:37:55] (index) database connection response [16 Nov 2020 22:37:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:37:55] (index) database connection response [16 Nov 2020 22:37:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:37:55] (index) database connection response [16 Nov 2020 22:37:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:37:55] (index) database connection response [16 Nov 2020 22:37:55] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:37:55] (index) database connection response [16 Nov 2020 22:37:55] (index) getPatientReportsDetail() entered [16 Nov 2020 22:37:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:37:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:37:55] (index) p_Stop=N [16 Nov 2020 22:37:55] (index) p_Alert= [16 Nov 2020 22:37:55] (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 [16 Nov 2020 22:37:55] (index) database connection response [16 Nov 2020 22:37:55] (index) getConnectionClose() called.... [16 Nov 2020 22:37:55] (index) getConnectionClose() called.... [16 Nov 2020 22:39:55] (index) database connection response [16 Nov 2020 22:39:55] (index) getConnection(): Resource id #1 [16 Nov 2020 22:39:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 22:39:55] (index) database connection response [16 Nov 2020 22:39:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 22:39:55] (index) database connection response [16 Nov 2020 22:39:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 22:39:55] (index) database connection response [16 Nov 2020 22:39:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' [16 Nov 2020 22:39:55] (index) database connection response [16 Nov 2020 22:39:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493777' AND ACCESS_CODE = '28786737' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 22:39:55] (index) database connection response [16 Nov 2020 22:39:55] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643059' [16 Nov 2020 22:39:55] (index) database connection response [16 Nov 2020 22:39:55] (index) getPatientReportsDetail() entered [16 Nov 2020 22:39:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:39:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493777', 'M0100000643059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 22:39:55] (index) p_Stop=N [16 Nov 2020 22:39:55] (index) p_Alert= [16 Nov 2020 22:39:55] (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 [16 Nov 2020 22:39:55] (index) database connection response [16 Nov 2020 22:39:55] (index) getConnectionClose() called.... [16 Nov 2020 22:39:55] (index) getConnectionClose() called.... [16 Nov 2020 23:00:40] (index) database connection response [16 Nov 2020 23:00:40] (index) getConnection(): Resource id #1 [16 Nov 2020 23:00:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 23:00:40] (index) database connection response [16 Nov 2020 23:00:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 23:00:40] (index) database connection response [16 Nov 2020 23:00:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 23:00:40] (index) database connection response [16 Nov 2020 23:00:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200494331' AND ACCESS_CODE = '69153145' [16 Nov 2020 23:00:41] (index) database connection response [16 Nov 2020 23:00:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200494331' AND ACCESS_CODE = '69153145' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 23:00:41] (index) database connection response [16 Nov 2020 23:00:41] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000559816' [16 Nov 2020 23:00:41] (index) database connection response [16 Nov 2020 23:00:41] (index) getPatientReportsDetail() entered [16 Nov 2020 23:00:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200494331', 'M0100000559816', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:00:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200494331', 'M0100000559816', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:00:41] (index) p_Stop=N [16 Nov 2020 23:00:41] (index) p_Alert= [16 Nov 2020 23:00:41] (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 [16 Nov 2020 23:00:41] (index) database connection response [16 Nov 2020 23:00:41] (index) getConnectionClose() called.... [16 Nov 2020 23:00:41] (index) getConnectionClose() called.... [16 Nov 2020 23:01:35] (viewOnlineReports) database connection response [16 Nov 2020 23:01:35] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:01:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000559816', '001', '200422705', '2', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:01:35] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:01:35] (viewOnlineReports) p_Alert= [16 Nov 2020 23:01:35] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:01:35] (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', '200422705', 'M01', '047', '2', '001000000000084949', 'M0100000559816_M01RCH20022281_1.PDF', 'M0100000559816', SYSDATE) [16 Nov 2020 23:01:35] (viewOnlineReports) database connection response [16 Nov 2020 23:01:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422705' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [16 Nov 2020 23:01:35] (viewOnlineReports) database connection response [16 Nov 2020 23:01:35] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:01:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422705/ [16 Nov 2020 23:01:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422705/ [16 Nov 2020 23:01:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000559816_M01RCH20022281_1.PDF [16 Nov 2020 23:01:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422705/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605549695M0100000559816_M01RCH20022281_1.PDF [16 Nov 2020 23:01:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422705/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605549695M0100000559816_M01RCH20022281_1.PDF [16 Nov 2020 23:01:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [16 Nov 2020 23:01:35] (viewOnlineReports) Converting PDF to JPG with name as M0100000559816_M01RCH20022281_1.jpg [16 Nov 2020 23:01:35] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200422705/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605549695M0100000559816_M01RCH20022281_1.PDF ../../TEMP_PDF/200422705/M0100000559816_M01RCH20022281_1.jpg [16 Nov 2020 23:01:35] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200422705/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605549695M0100000559816_M01RCH20022281_1.PDF [16 Nov 2020 23:03:04] (viewOnlineReports) database connection response [16 Nov 2020 23:03:04] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:03:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000559816', '001', '200422705', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:03:04] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:03:04] (viewOnlineReports) p_Alert= [16 Nov 2020 23:03:04] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:03: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', '200422705', 'M01', '047', '3', '001000000000087100', 'M0100000559816_M01MIC20008994_1.PDF', 'M0100000559816', SYSDATE) [16 Nov 2020 23:03:04] (viewOnlineReports) database connection response [16 Nov 2020 23:03:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422705' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [16 Nov 2020 23:03:04] (viewOnlineReports) database connection response [16 Nov 2020 23:03:04] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:03:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422705/ [16 Nov 2020 23:03:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422705/ [16 Nov 2020 23:03:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000559816_M01MIC20008994_1.PDF [16 Nov 2020 23:03:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422705/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605549784M0100000559816_M01MIC20008994_1.PDF [16 Nov 2020 23:03:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422705/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605549784M0100000559816_M01MIC20008994_1.PDF [16 Nov 2020 23:03:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [16 Nov 2020 23:03:04] (viewOnlineReports) Converting PDF to JPG with name as M0100000559816_M01MIC20008994_1.jpg [16 Nov 2020 23:03:04] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200422705/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605549784M0100000559816_M01MIC20008994_1.PDF ../../TEMP_PDF/200422705/M0100000559816_M01MIC20008994_1.jpg [16 Nov 2020 23:03:04] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200422705/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605549784M0100000559816_M01MIC20008994_1.PDF [16 Nov 2020 23:26:20] (index) database connection response [16 Nov 2020 23:26:20] (index) getConnection(): Resource id #1 [16 Nov 2020 23:26:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [16 Nov 2020 23:26:20] (index) database connection response [16 Nov 2020 23:26:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [16 Nov 2020 23:26:20] (index) database connection response [16 Nov 2020 23:26:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [16 Nov 2020 23:26:20] (index) database connection response [16 Nov 2020 23:26:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493688' AND ACCESS_CODE = '19123722' [16 Nov 2020 23:26:20] (index) database connection response [16 Nov 2020 23:26:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200493688' AND ACCESS_CODE = '19123722' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [16 Nov 2020 23:26:20] (index) database connection response [16 Nov 2020 23:26:20] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643036' [16 Nov 2020 23:26:20] (index) database connection response [16 Nov 2020 23:26:20] (index) getPatientReportsDetail() entered [16 Nov 2020 23:26:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493688', 'M0100000643036', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:26:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200493688', 'M0100000643036', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:26:20] (index) p_Stop=N [16 Nov 2020 23:26:20] (index) p_Alert= [16 Nov 2020 23:26:20] (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 [16 Nov 2020 23:26:20] (index) database connection response [16 Nov 2020 23:26:20] (index) getConnectionClose() called.... [16 Nov 2020 23:26:20] (index) getConnectionClose() called.... [16 Nov 2020 23:26:41] (viewOnlineReports) database connection response [16 Nov 2020 23:26:41] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:26:41] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000643036', '001', '200422468', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:26:41] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:26:41] (viewOnlineReports) p_Alert= [16 Nov 2020 23:26:41] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:26:41] (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', '200422468', 'M01', '010', '1', '001000000000085025', 'M0100000643036_M01HEM20016367_1.PDF', 'M0100000643036', SYSDATE) [16 Nov 2020 23:26:41] (viewOnlineReports) database connection response [16 Nov 2020 23:26:41] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422468' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '1' [16 Nov 2020 23:26:41] (viewOnlineReports) database connection response [16 Nov 2020 23:26:41] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:26:41] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422468/ [16 Nov 2020 23:26:41] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422468/ [16 Nov 2020 23:26:41] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643036_M01HEM20016367_1.PDF [16 Nov 2020 23:26:41] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422468/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605551201M0100000643036_M01HEM20016367_1.PDF [16 Nov 2020 23:26:41] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422468/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605551201M0100000643036_M01HEM20016367_1.PDF [16 Nov 2020 23:26:41] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 23:26:41] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422468/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605551201M0100000643036_M01HEM20016367_1.PDF [16 Nov 2020 23:27:09] (viewOnlineReports) database connection response [16 Nov 2020 23:27:09] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:27:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000643036', '001', '200422468', '2', '001000000000081010', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:27:09] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:27:09] (viewOnlineReports) p_Alert= [16 Nov 2020 23:27:09] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:27:09] (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', '200422468', 'M01', '010', '2', '001000000000081010', 'M0100000643036_M01RCH20022250_1.PDF', 'M0100000643036', SYSDATE) [16 Nov 2020 23:27:09] (viewOnlineReports) database connection response [16 Nov 2020 23:27:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422468' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '2' [16 Nov 2020 23:27:09] (viewOnlineReports) database connection response [16 Nov 2020 23:27:09] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:27:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422468/ [16 Nov 2020 23:27:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422468/ [16 Nov 2020 23:27:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643036_M01RCH20022250_1.PDF [16 Nov 2020 23:27:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422468/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605551229M0100000643036_M01RCH20022250_1.PDF [16 Nov 2020 23:27:10] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422468/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605551229M0100000643036_M01RCH20022250_1.PDF [16 Nov 2020 23:27:10] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 23:27:10] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422468/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605551229M0100000643036_M01RCH20022250_1.PDF [16 Nov 2020 23:27:17] (viewOnlineReports) database connection response [16 Nov 2020 23:27:17] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:27:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000643036', '001', '200422468', '3', '001000000000083036', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:27:17] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:27:17] (viewOnlineReports) p_Alert= [16 Nov 2020 23:27:17] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:27: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', '200422468', 'M01', '010', '3', '001000000000083036', 'M0100000643036_M01RCH20022250_2.PDF', 'M0100000643036', SYSDATE) [16 Nov 2020 23:27:17] (viewOnlineReports) database connection response [16 Nov 2020 23:27:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422468' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '3' [16 Nov 2020 23:27:17] (viewOnlineReports) database connection response [16 Nov 2020 23:27:17] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:27:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422468/ [16 Nov 2020 23:27:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422468/ [16 Nov 2020 23:27:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643036_M01RCH20022250_2.PDF [16 Nov 2020 23:27:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1605551237M0100000643036_M01RCH20022250_2.PDF [16 Nov 2020 23:27:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1605551237M0100000643036_M01RCH20022250_2.PDF [16 Nov 2020 23:27:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 23:27:17] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1605551237M0100000643036_M01RCH20022250_2.PDF [16 Nov 2020 23:27:23] (viewOnlineReports) database connection response [16 Nov 2020 23:27:23] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:27:23] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000643036', '001', '200422468', '5', '001000000000084550', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:27:23] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:27:23] (viewOnlineReports) p_Alert= [16 Nov 2020 23:27:23] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:27:23] (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', '200422468', 'M01', '010', '5', '001000000000084550', 'M0100000643036_M01RCH20022250_3.PDF', 'M0100000643036', SYSDATE) [16 Nov 2020 23:27:23] (viewOnlineReports) database connection response [16 Nov 2020 23:27:23] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422468' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '5' [16 Nov 2020 23:27:23] (viewOnlineReports) database connection response [16 Nov 2020 23:27:23] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:27:23] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422468/ [16 Nov 2020 23:27:23] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422468/ [16 Nov 2020 23:27:23] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643036_M01RCH20022250_3.PDF [16 Nov 2020 23:27:23] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605551243M0100000643036_M01RCH20022250_3.PDF [16 Nov 2020 23:27:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605551243M0100000643036_M01RCH20022250_3.PDF [16 Nov 2020 23:27:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [16 Nov 2020 23:27:23] (viewOnlineReports) Downloading file ../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605551243M0100000643036_M01RCH20022250_3.PDF [16 Nov 2020 23:34:23] (viewOnlineReports) database connection response [16 Nov 2020 23:34:23] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:34:23] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000643036', '001', '200422468', '5', '001000000000084550', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:34:23] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:34:23] (viewOnlineReports) p_Alert= [16 Nov 2020 23:34:23] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:34:23] (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', '200422468', 'M01', '010', '5', '001000000000084550', 'M0100000643036_M01RCH20022250_3.PDF', 'M0100000643036', SYSDATE) [16 Nov 2020 23:34:23] (viewOnlineReports) database connection response [16 Nov 2020 23:34:23] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422468' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '5' [16 Nov 2020 23:34:23] (viewOnlineReports) database connection response [16 Nov 2020 23:34:23] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:34:23] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422468/ [16 Nov 2020 23:34:23] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422468/ [16 Nov 2020 23:34:23] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643036_M01RCH20022250_3.PDF [16 Nov 2020 23:34:23] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1605551663M0100000643036_M01RCH20022250_3.PDF [16 Nov 2020 23:34:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1605551663M0100000643036_M01RCH20022250_3.PDF [16 Nov 2020 23:34:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [16 Nov 2020 23:34:23] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200422468/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1605551663M0100000643036_M01RCH20022250_3.PDF [16 Nov 2020 23:34:50] (viewOnlineReports) database connection response [16 Nov 2020 23:34:50] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:34:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000643036', '001', '200422468', '3', '001000000000083036', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:34:50] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:34:50] (viewOnlineReports) p_Alert= [16 Nov 2020 23:34:50] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:34:50] (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', '200422468', 'M01', '010', '3', '001000000000083036', 'M0100000643036_M01RCH20022250_2.PDF', 'M0100000643036', SYSDATE) [16 Nov 2020 23:34:50] (viewOnlineReports) database connection response [16 Nov 2020 23:34:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422468' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '3' [16 Nov 2020 23:34:50] (viewOnlineReports) database connection response [16 Nov 2020 23:34:50] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:34:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422468/ [16 Nov 2020 23:34:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422468/ [16 Nov 2020 23:34:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643036_M01RCH20022250_2.PDF [16 Nov 2020 23:34:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422468/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605551690M0100000643036_M01RCH20022250_2.PDF [16 Nov 2020 23:34:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422468/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605551690M0100000643036_M01RCH20022250_2.PDF [16 Nov 2020 23:34:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [16 Nov 2020 23:34:50] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200422468/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605551690M0100000643036_M01RCH20022250_2.PDF [16 Nov 2020 23:35:12] (viewOnlineReports) database connection response [16 Nov 2020 23:35:12] (viewOnlineReports) getConnection(): Resource id #1 [16 Nov 2020 23:35:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000643036', '001', '200422468', '2', '001000000000081010', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [16 Nov 2020 23:35:12] (viewOnlineReports) p_Stop=N [16 Nov 2020 23:35:12] (viewOnlineReports) p_Alert= [16 Nov 2020 23:35:12] (viewOnlineReports) Flag = 1 [16 Nov 2020 23:35:12] (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', '200422468', 'M01', '010', '2', '001000000000081010', 'M0100000643036_M01RCH20022250_1.PDF', 'M0100000643036', SYSDATE) [16 Nov 2020 23:35:12] (viewOnlineReports) database connection response [16 Nov 2020 23:35:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200422468' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '2' [16 Nov 2020 23:35:12] (viewOnlineReports) database connection response [16 Nov 2020 23:35:12] (viewOnlineReports) getConnectionClose() called.... [16 Nov 2020 23:35:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200422468/ [16 Nov 2020 23:35:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200422468/ [16 Nov 2020 23:35:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000643036_M01RCH20022250_1.PDF [16 Nov 2020 23:35:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200422468/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605551712M0100000643036_M01RCH20022250_1.PDF [16 Nov 2020 23:35:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200422468/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605551712M0100000643036_M01RCH20022250_1.PDF [16 Nov 2020 23:35:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [16 Nov 2020 23:35:12] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200422468/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605551712M0100000643036_M01RCH20022250_1.PDF