[20 Nov 2020 00:09:11] (index) database connection response [20 Nov 2020 00:09:11] (index) getConnection(): Resource id #1 [20 Nov 2020 00:09:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 00:09:11] (index) database connection response [20 Nov 2020 00:09:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 00:09:11] (index) database connection response [20 Nov 2020 00:09:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 00:09:11] (index) database connection response [20 Nov 2020 00:09:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' [20 Nov 2020 00:09:11] (index) database connection response [20 Nov 2020 00:09:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 00:09:11] (index) database connection response [20 Nov 2020 00:09:11] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 00:09:11] (index) database connection response [20 Nov 2020 00:09:11] (index) getPatientReportsDetail() entered [20 Nov 2020 00:09:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 00:09:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 00:09:11] (index) p_Stop=N [20 Nov 2020 00:09:11] (index) p_Alert= [20 Nov 2020 00:09:11] (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 [20 Nov 2020 00:09:11] (index) database connection response [20 Nov 2020 00:09:11] (index) getConnectionClose() called.... [20 Nov 2020 00:09:11] (index) getConnectionClose() called.... [20 Nov 2020 01:14:40] (index) database connection response [20 Nov 2020 01:14:40] (index) getConnection(): Resource id #1 [20 Nov 2020 01:14:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 01:14:40] (index) database connection response [20 Nov 2020 01:14:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 01:14:40] (index) database connection response [20 Nov 2020 01:14:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 01:14:40] (index) database connection response [20 Nov 2020 01:14:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' [20 Nov 2020 01:14:40] (index) database connection response [20 Nov 2020 01:14:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 01:14:40] (index) database connection response [20 Nov 2020 01:14:40] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 01:14:40] (index) database connection response [20 Nov 2020 01:14:40] (index) getPatientReportsDetail() entered [20 Nov 2020 01:14:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 01:14:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 01:14:40] (index) p_Stop=N [20 Nov 2020 01:14:40] (index) p_Alert= [20 Nov 2020 01:14:40] (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 [20 Nov 2020 01:14:40] (index) database connection response [20 Nov 2020 01:14:40] (index) getConnectionClose() called.... [20 Nov 2020 01:14:40] (index) getConnectionClose() called.... [20 Nov 2020 06:43:29] (index) database connection response [20 Nov 2020 06:43:29] (index) getConnection(): Resource id #1 [20 Nov 2020 06:43:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 06:43:29] (index) database connection response [20 Nov 2020 06:43:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 06:43:29] (index) database connection response [20 Nov 2020 06:43:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 06:43:29] (index) database connection response [20 Nov 2020 06:43:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200499940' AND ACCESS_CODE = '00938198' [20 Nov 2020 06:43:29] (index) database connection response [20 Nov 2020 06:43:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200499940' AND ACCESS_CODE = '00938198' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 06:43:29] (index) database connection response [20 Nov 2020 06:43:29] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000607697' [20 Nov 2020 06:43:30] (index) database connection response [20 Nov 2020 06:43:30] (index) getPatientReportsDetail() entered [20 Nov 2020 06:43:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200499940', 'M0100000607697', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:43:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200499940', 'M0100000607697', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:43:30] (index) p_Stop=N [20 Nov 2020 06:43:30] (index) p_Alert= [20 Nov 2020 06:43: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 [20 Nov 2020 06:43:30] (index) database connection response [20 Nov 2020 06:43:30] (index) getConnectionClose() called.... [20 Nov 2020 06:43:30] (index) getConnectionClose() called.... [20 Nov 2020 06:43:50] (viewOnlineReports) database connection response [20 Nov 2020 06:43:50] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 06:43:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000607697', '001', '200424612', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:43:50] (viewOnlineReports) p_Stop=N [20 Nov 2020 06:43:50] (viewOnlineReports) p_Alert= [20 Nov 2020 06:43:50] (viewOnlineReports) Flag = 1 [20 Nov 2020 06:43: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', '200424612', 'M01', '070', '1', '001000000000087630', 'M0100000607697_M01MOL20012973_1.PDF', 'M0100000607697', SYSDATE) [20 Nov 2020 06:43:50] (viewOnlineReports) database connection response [20 Nov 2020 06:43:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424612' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 06:43:50] (viewOnlineReports) database connection response [20 Nov 2020 06:43:50] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 06:43:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424612/ [20 Nov 2020 06:43:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424612/ [20 Nov 2020 06:43:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000607697_M01MOL20012973_1.PDF [20 Nov 2020 06:43:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424612/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1605836630M0100000607697_M01MOL20012973_1.PDF [20 Nov 2020 06:43:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424612/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1605836630M0100000607697_M01MOL20012973_1.PDF [20 Nov 2020 06:43:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Nov 2020 06:43:50] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200424612/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1605836630M0100000607697_M01MOL20012973_1.PDF [20 Nov 2020 06:44:02] (viewOnlineReports) database connection response [20 Nov 2020 06:44:02] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 06:44:02] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000607697', '001', '200424612', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:44:02] (viewOnlineReports) p_Stop=N [20 Nov 2020 06:44:02] (viewOnlineReports) p_Alert= [20 Nov 2020 06:44:02] (viewOnlineReports) Flag = 1 [20 Nov 2020 06:44:02] (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', '200424612', 'M01', '070', '1', '001000000000087630', 'M0100000607697_M01MOL20012973_1.PDF', 'M0100000607697', SYSDATE) [20 Nov 2020 06:44:02] (viewOnlineReports) database connection response [20 Nov 2020 06:44:02] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424612' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 06:44:02] (viewOnlineReports) database connection response [20 Nov 2020 06:44:02] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 06:44:02] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424612/ [20 Nov 2020 06:44:02] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424612/ [20 Nov 2020 06:44:02] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000607697_M01MOL20012973_1.PDF [20 Nov 2020 06:44:02] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424612/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605836642M0100000607697_M01MOL20012973_1.PDF [20 Nov 2020 06:44:02] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424612/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605836642M0100000607697_M01MOL20012973_1.PDF [20 Nov 2020 06:44:02] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 06:44:02] (viewOnlineReports) Downloading file ../../TEMP_PDF/200424612/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605836642M0100000607697_M01MOL20012973_1.PDF [20 Nov 2020 06:46:40] (index) database connection response [20 Nov 2020 06:46:40] (index) getConnection(): Resource id #1 [20 Nov 2020 06:46:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 06:46:40] (index) database connection response [20 Nov 2020 06:46:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 06:46:40] (index) database connection response [20 Nov 2020 06:46:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 06:46:40] (index) database connection response [20 Nov 2020 06:46:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200499933' AND ACCESS_CODE = '73706298' [20 Nov 2020 06:46:40] (index) database connection response [20 Nov 2020 06:46:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200499933' AND ACCESS_CODE = '73706298' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 06:46:40] (index) database connection response [20 Nov 2020 06:46:40] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643566' [20 Nov 2020 06:46:40] (index) database connection response [20 Nov 2020 06:46:40] (index) getPatientReportsDetail() entered [20 Nov 2020 06:46:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200499933', 'M0100000643566', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:46:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200499933', 'M0100000643566', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:46:40] (index) p_Stop=N [20 Nov 2020 06:46:40] (index) p_Alert= [20 Nov 2020 06:46:40] (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 [20 Nov 2020 06:46:40] (index) database connection response [20 Nov 2020 06:46:40] (index) getConnectionClose() called.... [20 Nov 2020 06:46:40] (index) getConnectionClose() called.... [20 Nov 2020 06:46:46] (viewOnlineReports) database connection response [20 Nov 2020 06:46:46] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 06:46:46] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000643566', '001', '200424609', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:46:46] (viewOnlineReports) p_Stop=N [20 Nov 2020 06:46:46] (viewOnlineReports) p_Alert= [20 Nov 2020 06:46:46] (viewOnlineReports) Flag = 1 [20 Nov 2020 06:46:46] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200424609', 'M01', '070', '1', '001000000000087630', 'M0100000643566_M01MOL20012972_1.PDF', 'M0100000643566', SYSDATE) [20 Nov 2020 06:46:46] (viewOnlineReports) database connection response [20 Nov 2020 06:46:46] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424609' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 06:46:46] (viewOnlineReports) database connection response [20 Nov 2020 06:46:46] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 06:46:46] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424609/ [20 Nov 2020 06:46:46] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424609/ [20 Nov 2020 06:46:46] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:46:46] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424609/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1605836806M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:46:46] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424609/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1605836806M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:46:46] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 06:46:46] (viewOnlineReports) Downloading file ../../TEMP_PDF/200424609/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1605836806M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:16] (viewOnlineReports) database connection response [20 Nov 2020 06:51:16] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 06:51:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000643566', '001', '200424609', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:51:16] (viewOnlineReports) p_Stop=N [20 Nov 2020 06:51:16] (viewOnlineReports) p_Alert= [20 Nov 2020 06:51:16] (viewOnlineReports) Flag = 1 [20 Nov 2020 06:51:16] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200424609', 'M01', '070', '1', '001000000000087630', 'M0100000643566_M01MOL20012972_1.PDF', 'M0100000643566', SYSDATE) [20 Nov 2020 06:51:16] (viewOnlineReports) database connection response [20 Nov 2020 06:51:16] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424609' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 06:51:16] (viewOnlineReports) database connection response [20 Nov 2020 06:51:16] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 06:51:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424609/ [20 Nov 2020 06:51:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424609/ [20 Nov 2020 06:51:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424609/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1605837076M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424609/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1605837076M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Nov 2020 06:51:16] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200424609/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1605837076M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:24] (viewOnlineReports) database connection response [20 Nov 2020 06:51:24] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 06:51:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000643566', '001', '200424609', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:51:24] (viewOnlineReports) p_Stop=N [20 Nov 2020 06:51:24] (viewOnlineReports) p_Alert= [20 Nov 2020 06:51:24] (viewOnlineReports) Flag = 1 [20 Nov 2020 06:51:24] (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', '200424609', 'M01', '070', '1', '001000000000087630', 'M0100000643566_M01MOL20012972_1.PDF', 'M0100000643566', SYSDATE) [20 Nov 2020 06:51:24] (viewOnlineReports) database connection response [20 Nov 2020 06:51:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424609' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 06:51:24] (viewOnlineReports) database connection response [20 Nov 2020 06:51:24] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 06:51:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424609/ [20 Nov 2020 06:51:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424609/ [20 Nov 2020 06:51:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424609/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605837084M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424609/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605837084M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Nov 2020 06:51:24] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200424609/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1605837084M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:32] (viewOnlineReports) database connection response [20 Nov 2020 06:51:32] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 06:51:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000643566', '001', '200424609', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:51:32] (viewOnlineReports) p_Stop=N [20 Nov 2020 06:51:32] (viewOnlineReports) p_Alert= [20 Nov 2020 06:51:32] (viewOnlineReports) Flag = 1 [20 Nov 2020 06:51: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', '200424609', 'M01', '070', '1', '001000000000087630', 'M0100000643566_M01MOL20012972_1.PDF', 'M0100000643566', SYSDATE) [20 Nov 2020 06:51:32] (viewOnlineReports) database connection response [20 Nov 2020 06:51:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424609' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 06:51:32] (viewOnlineReports) database connection response [20 Nov 2020 06:51:32] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 06:51:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424609/ [20 Nov 2020 06:51:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424609/ [20 Nov 2020 06:51:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424609/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605837092M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424609/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605837092M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 06:51:32] (viewOnlineReports) Converting PDF to JPG with name as M0100000643566_M01MOL20012972_1.jpg [20 Nov 2020 06:51:32] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200424609/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605837092M0100000643566_M01MOL20012972_1.PDF ../../TEMP_PDF/200424609/M0100000643566_M01MOL20012972_1.jpg [20 Nov 2020 06:51:32] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200424609/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605837092M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:44] (viewOnlineReports) database connection response [20 Nov 2020 06:51:44] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 06:51:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000643566', '001', '200424609', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 06:51:44] (viewOnlineReports) p_Stop=N [20 Nov 2020 06:51:44] (viewOnlineReports) p_Alert= [20 Nov 2020 06:51:44] (viewOnlineReports) Flag = 1 [20 Nov 2020 06:51:44] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200424609', 'M01', '070', '1', '001000000000087630', 'M0100000643566_M01MOL20012972_1.PDF', 'M0100000643566', SYSDATE) [20 Nov 2020 06:51:44] (viewOnlineReports) database connection response [20 Nov 2020 06:51:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424609' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 06:51:44] (viewOnlineReports) database connection response [20 Nov 2020 06:51:44] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 06:51:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424609/ [20 Nov 2020 06:51:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424609/ [20 Nov 2020 06:51:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424609/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605837104M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424609/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605837104M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 06:51:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 06:51:44] (viewOnlineReports) Downloading file ../../TEMP_PDF/200424609/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1605837104M0100000643566_M01MOL20012972_1.PDF [20 Nov 2020 09:05:14] (viewOnlineReports) database connection response [20 Nov 2020 09:05:14] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 09:05:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', '00100000000000', '001', '200424395', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 09:05:15] (viewOnlineReports) p_Stop=N [20 Nov 2020 09:05:15] (viewOnlineReports) p_Alert= [20 Nov 2020 09:05:15] (viewOnlineReports) Flag = 1 [20 Nov 2020 09:05: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', '200424395', 'M01', '070', '1', '001000000000087630', 'M0100000135792_M01MOL20012947_1.PDF', '00100000000000', SYSDATE) [20 Nov 2020 09:05:15] (viewOnlineReports) database connection response [20 Nov 2020 09:05:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424395' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 09:05:15] (viewOnlineReports) database connection response [20 Nov 2020 09:05:15] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 09:05:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424395/ [20 Nov 2020 09:05:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424395/ [20 Nov 2020 09:05:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000135792_M01MOL20012947_1.PDF [20 Nov 2020 09:05:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424395/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZM0100000135792_M01MOL20012947_1.PDF [20 Nov 2020 09:05:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424395/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZM0100000135792_M01MOL20012947_1.PDF [20 Nov 2020 09:05:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 09:05:15] (viewOnlineReports) Downloading file ../../TEMP_PDF/200424395/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZM0100000135792_M01MOL20012947_1.PDF [20 Nov 2020 09:05:20] (index) database connection response [20 Nov 2020 09:05:20] (index) getConnection(): Resource id #1 [20 Nov 2020 09:05:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '58' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 09:05:20] (index) database connection response [20 Nov 2020 09:05:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '58' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 09:05:20] (index) database connection response [20 Nov 2020 09:05:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '58' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 09:05:20] (index) database connection response [20 Nov 2020 09:05:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200499377' AND ACCESS_CODE = '03036413' [20 Nov 2020 09:05:20] (index) database connection response [20 Nov 2020 09:05:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200499377' AND ACCESS_CODE = '03036413' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 09:05:20] (index) database connection response [20 Nov 2020 09:05:20] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000599348' [20 Nov 2020 09:05:20] (index) database connection response [20 Nov 2020 09:05:20] (index) getPatientReportsDetail() entered [20 Nov 2020 09:05:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200499377', 'M0100000599348', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 09:05:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200499377', 'M0100000599348', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 09:05:20] (index) p_Stop=N [20 Nov 2020 09:05:20] (index) p_Alert= [20 Nov 2020 09:05: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 [20 Nov 2020 09:05:20] (index) database connection response [20 Nov 2020 09:05:20] (index) getConnectionClose() called.... [20 Nov 2020 09:05:20] (index) getConnectionClose() called.... [20 Nov 2020 09:05:24] (viewOnlineReports) database connection response [20 Nov 2020 09:05:24] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 09:05:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000599348', '001', '200424396', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 09:05:24] (viewOnlineReports) p_Stop=N [20 Nov 2020 09:05:24] (viewOnlineReports) p_Alert= [20 Nov 2020 09:05:24] (viewOnlineReports) Flag = 1 [20 Nov 2020 09:05:24] (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', '200424396', 'M01', '047', '1', '001000000000085025', 'M0100000599348_M01HEM20016547_1.PDF', 'M0100000599348', SYSDATE) [20 Nov 2020 09:05:25] (viewOnlineReports) database connection response [20 Nov 2020 09:05:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424396' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 09:05:25] (viewOnlineReports) database connection response [20 Nov 2020 09:05:25] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 09:05:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424396/ [20 Nov 2020 09:05:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424396/ [20 Nov 2020 09:05:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424396/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845124M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424396/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845124M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 09:05:25] (viewOnlineReports) Converting PDF to JPG with name as M0100000599348_M01HEM20016547_1.jpg [20 Nov 2020 09:05:25] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200424396/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845124M0100000599348_M01HEM20016547_1.PDF ../../TEMP_PDF/200424396/M0100000599348_M01HEM20016547_1.jpg [20 Nov 2020 09:05:25] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200424396/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845124M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:32] (viewOnlineReports) database connection response [20 Nov 2020 09:05:32] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 09:05:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000599348', '001', '200424396', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 09:05:32] (viewOnlineReports) p_Stop=N [20 Nov 2020 09:05:32] (viewOnlineReports) p_Alert= [20 Nov 2020 09:05:32] (viewOnlineReports) Flag = 1 [20 Nov 2020 09:05: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', '200424396', 'M01', '047', '1', '001000000000085025', 'M0100000599348_M01HEM20016547_1.PDF', 'M0100000599348', SYSDATE) [20 Nov 2020 09:05:32] (viewOnlineReports) database connection response [20 Nov 2020 09:05:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424396' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 09:05:32] (viewOnlineReports) database connection response [20 Nov 2020 09:05:32] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 09:05:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424396/ [20 Nov 2020 09:05:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424396/ [20 Nov 2020 09:05:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424396/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845132M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424396/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845132M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Nov 2020 09:05:32] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200424396/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845132M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:38] (viewOnlineReports) database connection response [20 Nov 2020 09:05:38] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 09:05:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000599348', '001', '200424396', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 09:05:38] (viewOnlineReports) p_Stop=N [20 Nov 2020 09:05:38] (viewOnlineReports) p_Alert= [20 Nov 2020 09:05:38] (viewOnlineReports) Flag = 1 [20 Nov 2020 09:05:38] (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', '200424396', 'M01', '047', '1', '001000000000085025', 'M0100000599348_M01HEM20016547_1.PDF', 'M0100000599348', SYSDATE) [20 Nov 2020 09:05:38] (viewOnlineReports) database connection response [20 Nov 2020 09:05:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424396' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 09:05:38] (viewOnlineReports) database connection response [20 Nov 2020 09:05:38] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 09:05:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424396/ [20 Nov 2020 09:05:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424396/ [20 Nov 2020 09:05:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201119\M01\M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424396/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845138M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424396/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845138M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:05:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Nov 2020 09:05:39] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200424396/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605845138M0100000599348_M01HEM20016547_1.PDF [20 Nov 2020 09:38:37] (index) database connection response [20 Nov 2020 09:38:37] (index) getConnection(): Resource id #1 [20 Nov 2020 09:38:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 09:38:37] (index) database connection response [20 Nov 2020 09:38:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 09:38:37] (index) database connection response [20 Nov 2020 09:38:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 09:38:37] (index) database connection response [20 Nov 2020 09:38:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' [20 Nov 2020 09:38:37] (index) database connection response [20 Nov 2020 09:38:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 09:38:37] (index) database connection response [20 Nov 2020 09:38:37] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 09:38:37] (index) database connection response [20 Nov 2020 09:38:37] (index) getPatientReportsDetail() entered [20 Nov 2020 09:38:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 09:38:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 09:38:37] (index) p_Stop=N [20 Nov 2020 09:38:37] (index) p_Alert= [20 Nov 2020 09:38: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 [20 Nov 2020 09:38:37] (index) database connection response [20 Nov 2020 09:38:37] (index) getConnectionClose() called.... [20 Nov 2020 09:38:37] (index) getConnectionClose() called.... [20 Nov 2020 10:03:09] (index) database connection response [20 Nov 2020 10:03:09] (index) getConnection(): Resource id #1 [20 Nov 2020 10:03:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 10:03:09] (index) database connection response [20 Nov 2020 10:03:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 10:03:09] (index) database connection response [20 Nov 2020 10:03:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 10:03:09] (index) database connection response [20 Nov 2020 10:03:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' [20 Nov 2020 10:03:09] (index) database connection response [20 Nov 2020 10:03:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 10:03:09] (index) database connection response [20 Nov 2020 10:03:09] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 10:03:09] (index) database connection response [20 Nov 2020 10:03:09] (index) getPatientReportsDetail() entered [20 Nov 2020 10:03:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 10:03:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 10:03:09] (index) p_Stop=N [20 Nov 2020 10:03:09] (index) p_Alert= [20 Nov 2020 10:03: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 [20 Nov 2020 10:03:09] (index) database connection response [20 Nov 2020 10:03:09] (index) getConnectionClose() called.... [20 Nov 2020 10:03:09] (index) getConnectionClose() called.... [20 Nov 2020 10:54:01] (index) database connection response [20 Nov 2020 10:54:01] (index) getConnection(): Resource id #1 [20 Nov 2020 10:54:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 10:54:01] (index) database connection response [20 Nov 2020 10:54:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 10:54:01] (index) database connection response [20 Nov 2020 10:54:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 10:54:01] (index) database connection response [20 Nov 2020 10:54:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' [20 Nov 2020 10:54:01] (index) database connection response [20 Nov 2020 10:54:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 10:54:01] (index) database connection response [20 Nov 2020 10:54:01] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 10:54:01] (index) database connection response [20 Nov 2020 10:54:01] (index) getPatientReportsDetail() entered [20 Nov 2020 10:54:01] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 10:54:01] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 10:54:01] (index) p_Stop=N [20 Nov 2020 10:54:01] (index) p_Alert= [20 Nov 2020 10:54:01] (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 [20 Nov 2020 10:54:01] (index) database connection response [20 Nov 2020 10:54:01] (index) getConnectionClose() called.... [20 Nov 2020 10:54:01] (index) getConnectionClose() called.... [20 Nov 2020 11:25:17] (index) database connection response [20 Nov 2020 11:25:17] (index) getConnection(): Resource id #1 [20 Nov 2020 11:25:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 11:25:17] (index) database connection response [20 Nov 2020 11:25:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 11:25:17] (index) database connection response [20 Nov 2020 11:25:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 11:25:17] (index) database connection response [20 Nov 2020 11:25:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' [20 Nov 2020 11:25:17] (index) database connection response [20 Nov 2020 11:25:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 11:25:17] (index) database connection response [20 Nov 2020 11:25:17] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 11:25:17] (index) database connection response [20 Nov 2020 11:25:17] (index) getPatientReportsDetail() entered [20 Nov 2020 11:25:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 11:25:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 11:25:17] (index) p_Stop=N [20 Nov 2020 11:25:17] (index) p_Alert= [20 Nov 2020 11:25: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 [20 Nov 2020 11:25:17] (index) database connection response [20 Nov 2020 11:25:17] (index) getConnectionClose() called.... [20 Nov 2020 11:25:17] (index) getConnectionClose() called.... [20 Nov 2020 11:28:12] (index) database connection response [20 Nov 2020 11:28:12] (index) getConnection(): Resource id #1 [20 Nov 2020 11:28:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 11:28:12] (index) database connection response [20 Nov 2020 11:28:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 11:28:12] (index) database connection response [20 Nov 2020 11:28:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 11:28:12] (index) database connection response [20 Nov 2020 11:28:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M10MOL200129' AND ACCESS_CODE = 'M01-00000643537' [20 Nov 2020 11:28:12] (index) database connection response [20 Nov 2020 11:28:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M10MOL200129' AND ACCESS_CODE = 'M01-00000643537' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 11:28:12] (index) database connection response [20 Nov 2020 11:28:12] (index) getConnectionClose() called.... [20 Nov 2020 12:07:18] (index) database connection response [20 Nov 2020 12:07:18] (index) getConnection(): Resource id #1 [20 Nov 2020 12:07:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 12:07:18] (index) database connection response [20 Nov 2020 12:07:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 12:07:18] (index) database connection response [20 Nov 2020 12:07:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 12:07:18] (index) database connection response [20 Nov 2020 12:07:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' [20 Nov 2020 12:07:18] (index) database connection response [20 Nov 2020 12:07:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 12:07:18] (index) database connection response [20 Nov 2020 12:07:18] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 12:07:18] (index) database connection response [20 Nov 2020 12:07:18] (index) getPatientReportsDetail() entered [20 Nov 2020 12:07:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 12:07:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 12:07:18] (index) p_Stop=N [20 Nov 2020 12:07:18] (index) p_Alert= [20 Nov 2020 12:07: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 [20 Nov 2020 12:07:18] (index) database connection response [20 Nov 2020 12:07:18] (index) getConnectionClose() called.... [20 Nov 2020 12:07:18] (index) getConnectionClose() called.... [20 Nov 2020 12:07:24] (viewOnlineReports) database connection response [20 Nov 2020 12:07:24] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 12:07:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000583634', '001', '200424742', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 12:07:25] (viewOnlineReports) p_Stop=N [20 Nov 2020 12:07:25] (viewOnlineReports) p_Alert= [20 Nov 2020 12:07:25] (viewOnlineReports) Flag = 1 [20 Nov 2020 12:07:25] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200424742', 'M01', '047', '1', '001000000000085025', 'M0100000583634_M01HEM20016567_1.PDF', 'M0100000583634', SYSDATE) [20 Nov 2020 12:07:25] (viewOnlineReports) database connection response [20 Nov 2020 12:07:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424742' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 12:07:25] (viewOnlineReports) database connection response [20 Nov 2020 12:07:25] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 12:07:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424742/ [20 Nov 2020 12:07:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424742/ [20 Nov 2020 12:07:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201120\M01\M0100000583634_M01HEM20016567_1.PDF [20 Nov 2020 12:07:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424742/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605856044M0100000583634_M01HEM20016567_1.PDF [20 Nov 2020 12:07:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424742/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605856044M0100000583634_M01HEM20016567_1.PDF [20 Nov 2020 12:07:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 12:07:25] (viewOnlineReports) Converting PDF to JPG with name as M0100000583634_M01HEM20016567_1.jpg [20 Nov 2020 12:07:25] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200424742/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605856044M0100000583634_M01HEM20016567_1.PDF ../../TEMP_PDF/200424742/M0100000583634_M01HEM20016567_1.jpg [20 Nov 2020 12:07:25] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200424742/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605856044M0100000583634_M01HEM20016567_1.PDF [20 Nov 2020 14:18:58] (index) database connection response [20 Nov 2020 14:18:58] (index) getConnection(): Resource id #1 [20 Nov 2020 14:18:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 14:18:58] (index) database connection response [20 Nov 2020 14:18:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 14:18:58] (index) database connection response [20 Nov 2020 14:18:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 14:18:58] (index) database connection response [20 Nov 2020 14:18:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' [20 Nov 2020 14:18:58] (index) database connection response [20 Nov 2020 14:18:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 14:18:58] (index) database connection response [20 Nov 2020 14:18:58] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000012689' [20 Nov 2020 14:18:58] (index) database connection response [20 Nov 2020 14:18:58] (index) getPatientReportsDetail() entered [20 Nov 2020 14:18:58] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 14:18:58] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 14:18:58] (index) p_Stop=N [20 Nov 2020 14:18:58] (index) p_Alert= [20 Nov 2020 14:18:58] (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 [20 Nov 2020 14:18:58] (index) database connection response [20 Nov 2020 14:18:58] (index) getConnectionClose() called.... [20 Nov 2020 14:18:58] (index) getConnectionClose() called.... [20 Nov 2020 14:21:08] (index) database connection response [20 Nov 2020 14:21:08] (index) getConnection(): Resource id #1 [20 Nov 2020 14:21:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 14:21:08] (index) database connection response [20 Nov 2020 14:21:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 14:21:08] (index) database connection response [20 Nov 2020 14:21:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 14:21:08] (index) database connection response [20 Nov 2020 14:21:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200497942' AND ACCESS_CODE = '82056181' [20 Nov 2020 14:21:08] (index) database connection response [20 Nov 2020 14:21:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200497942' AND ACCESS_CODE = '82056181' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 14:21:08] (index) database connection response [20 Nov 2020 14:21:08] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000594180' [20 Nov 2020 14:21:08] (index) database connection response [20 Nov 2020 14:21:08] (index) getPatientReportsDetail() entered [20 Nov 2020 14:21:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200497942', 'M0100000594180', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 14:21:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200497942', 'M0100000594180', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 14:21:09] (index) p_Stop=N [20 Nov 2020 14:21:09] (index) p_Alert= [20 Nov 2020 14:21: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 [20 Nov 2020 14:21:09] (index) database connection response [20 Nov 2020 14:21:09] (index) getConnectionClose() called.... [20 Nov 2020 14:21:09] (index) getConnectionClose() called.... [20 Nov 2020 14:42:59] (index) database connection response [20 Nov 2020 14:42:59] (index) getConnection(): Resource id #1 [20 Nov 2020 14:42:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 14:42:59] (index) database connection response [20 Nov 2020 14:42:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 14:42:59] (index) database connection response [20 Nov 2020 14:42:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 14:42:59] (index) database connection response [20 Nov 2020 14:42:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' [20 Nov 2020 14:42:59] (index) database connection response [20 Nov 2020 14:42:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 14:42:59] (index) database connection response [20 Nov 2020 14:42:59] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000012689' [20 Nov 2020 14:42:59] (index) database connection response [20 Nov 2020 14:42:59] (index) getPatientReportsDetail() entered [20 Nov 2020 14:42:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 14:42:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 14:42:59] (index) p_Stop=N [20 Nov 2020 14:42:59] (index) p_Alert= [20 Nov 2020 14:42: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 [20 Nov 2020 14:42:59] (index) database connection response [20 Nov 2020 14:42:59] (index) getConnectionClose() called.... [20 Nov 2020 14:42:59] (index) getConnectionClose() called.... [20 Nov 2020 15:02:42] (index) database connection response [20 Nov 2020 15:02:42] (index) getConnection(): Resource id #1 [20 Nov 2020 15:02:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 15:02:42] (index) database connection response [20 Nov 2020 15:02:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 15:02:42] (index) database connection response [20 Nov 2020 15:02:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 15:02:42] (index) database connection response [20 Nov 2020 15:02:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' [20 Nov 2020 15:02:42] (index) database connection response [20 Nov 2020 15:02:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 15:02:42] (index) database connection response [20 Nov 2020 15:02:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000012689' [20 Nov 2020 15:02:42] (index) database connection response [20 Nov 2020 15:02:42] (index) getPatientReportsDetail() entered [20 Nov 2020 15:02:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 15:02:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 15:02:42] (index) p_Stop=N [20 Nov 2020 15:02:42] (index) p_Alert= [20 Nov 2020 15:02: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 [20 Nov 2020 15:02:42] (index) database connection response [20 Nov 2020 15:02:42] (index) getConnectionClose() called.... [20 Nov 2020 15:02:42] (index) getConnectionClose() called.... [20 Nov 2020 15:20:02] (index) database connection response [20 Nov 2020 15:20:02] (index) getConnection(): Resource id #1 [20 Nov 2020 15:20:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 15:20:02] (index) database connection response [20 Nov 2020 15:20:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 15:20:02] (index) database connection response [20 Nov 2020 15:20:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 15:20:02] (index) database connection response [20 Nov 2020 15:20:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' [20 Nov 2020 15:20:02] (index) database connection response [20 Nov 2020 15:20:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 15:20:02] (index) database connection response [20 Nov 2020 15:20:02] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000012689' [20 Nov 2020 15:20:02] (index) database connection response [20 Nov 2020 15:20:02] (index) getPatientReportsDetail() entered [20 Nov 2020 15:20:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 15:20:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 15:20:02] (index) p_Stop=N [20 Nov 2020 15:20:02] (index) p_Alert= [20 Nov 2020 15:20: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 [20 Nov 2020 15:20:02] (index) database connection response [20 Nov 2020 15:20:02] (index) getConnectionClose() called.... [20 Nov 2020 15:20:02] (index) getConnectionClose() called.... [20 Nov 2020 15:37:23] (index) database connection response [20 Nov 2020 15:37:23] (index) getConnection(): Resource id #1 [20 Nov 2020 15:37:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 15:37:23] (index) database connection response [20 Nov 2020 15:37:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 15:37:23] (index) database connection response [20 Nov 2020 15:37:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 15:37:23] (index) database connection response [20 Nov 2020 15:37:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' [20 Nov 2020 15:37:23] (index) database connection response [20 Nov 2020 15:37:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 15:37:23] (index) database connection response [20 Nov 2020 15:37:23] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000012689' [20 Nov 2020 15:37:23] (index) database connection response [20 Nov 2020 15:37:23] (index) getPatientReportsDetail() entered [20 Nov 2020 15:37:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 15:37:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 15:37:23] (index) p_Stop=N [20 Nov 2020 15:37:23] (index) p_Alert= [20 Nov 2020 15:37:23] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [20 Nov 2020 15:37:23] (index) database connection response [20 Nov 2020 15:37:23] (index) getConnectionClose() called.... [20 Nov 2020 15:37:23] (index) getConnectionClose() called.... [20 Nov 2020 15:42:57] (index) database connection response [20 Nov 2020 15:42:57] (index) getConnection(): Resource id #1 [20 Nov 2020 15:42:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 15:42:57] (index) database connection response [20 Nov 2020 15:42:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 15:42:58] (index) database connection response [20 Nov 2020 15:42:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 15:42:58] (index) database connection response [20 Nov 2020 15:42:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' [20 Nov 2020 15:42:58] (index) database connection response [20 Nov 2020 15:42:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500887' AND ACCESS_CODE = '93251660' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 15:42:58] (index) database connection response [20 Nov 2020 15:42:58] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000012689' [20 Nov 2020 15:42:58] (index) database connection response [20 Nov 2020 15:42:58] (index) getPatientReportsDetail() entered [20 Nov 2020 15:42:58] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 15:42:58] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 15:42:58] (index) p_Stop=N [20 Nov 2020 15:42:58] (index) p_Alert= [20 Nov 2020 15:42:58] (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 [20 Nov 2020 15:42:58] (index) database connection response [20 Nov 2020 15:42:58] (index) getConnectionClose() called.... [20 Nov 2020 15:42:58] (index) getConnectionClose() called.... [20 Nov 2020 16:07:44] (index) database connection response [20 Nov 2020 16:07:44] (index) getConnection(): Resource id #1 [20 Nov 2020 16:07:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 16:07:44] (index) database connection response [20 Nov 2020 16:07:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 16:07:44] (index) database connection response [20 Nov 2020 16:07:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 16:07:44] (index) database connection response [20 Nov 2020 16: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 = 'M01200500887' AND ACCESS_CODE = '93251660' [20 Nov 2020 16:07:44] (index) database connection response [20 Nov 2020 16: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 = 'M01200500887' AND ACCESS_CODE = '93251660' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 16:07:44] (index) database connection response [20 Nov 2020 16:07:44] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000012689' [20 Nov 2020 16:07:44] (index) database connection response [20 Nov 2020 16:07:44] (index) getPatientReportsDetail() entered [20 Nov 2020 16:07:44] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 16:07:44] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500887', 'M0100000012689', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 16:07:44] (index) p_Stop=N [20 Nov 2020 16:07:44] (index) p_Alert= [20 Nov 2020 16: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 [20 Nov 2020 16:07:44] (index) database connection response [20 Nov 2020 16:07:44] (index) getConnectionClose() called.... [20 Nov 2020 16:07:44] (index) getConnectionClose() called.... [20 Nov 2020 16:08:32] (viewOnlineReports) database connection response [20 Nov 2020 16:08:32] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 16:08:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000012689', '001', '200424872', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 16:08:32] (viewOnlineReports) p_Stop=N [20 Nov 2020 16:08:32] (viewOnlineReports) p_Alert= [20 Nov 2020 16:08:32] (viewOnlineReports) Flag = 1 [20 Nov 2020 16:08: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', '200424872', 'M01', '070', '1', '001000000000087630', 'M0100000012689_M01MOL20013006_1.PDF', 'M0100000012689', SYSDATE) [20 Nov 2020 16:08:33] (viewOnlineReports) database connection response [20 Nov 2020 16:08:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424872' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [20 Nov 2020 16:08:33] (viewOnlineReports) database connection response [20 Nov 2020 16:08:33] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 16:08:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424872/ [20 Nov 2020 16:08:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424872/ [20 Nov 2020 16:08:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201120\M01\M0100000012689_M01MOL20013006_1.PDF [20 Nov 2020 16:08:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424872/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605870512M0100000012689_M01MOL20013006_1.PDF [20 Nov 2020 16:08:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424872/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605870512M0100000012689_M01MOL20013006_1.PDF [20 Nov 2020 16:08:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 16:08:33] (viewOnlineReports) Downloading file ../../TEMP_PDF/200424872/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1605870512M0100000012689_M01MOL20013006_1.PDF [20 Nov 2020 16:39:40] (index) database connection response [20 Nov 2020 16:39:40] (index) getConnection(): Resource id #1 [20 Nov 2020 16:39:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 16:39:40] (index) database connection response [20 Nov 2020 16:39:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 16:39:41] (index) database connection response [20 Nov 2020 16:39:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 16:39:41] (index) database connection response [20 Nov 2020 16:39:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200489502' AND ACCESS_CODE = '99170118' [20 Nov 2020 16:39:41] (index) database connection response [20 Nov 2020 16:39:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200489502' AND ACCESS_CODE = '99170118' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 16:39:41] (index) database connection response [20 Nov 2020 16:39:41] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000145473' [20 Nov 2020 16:39:41] (index) database connection response [20 Nov 2020 16:39:41] (index) getPatientReportsDetail() entered [20 Nov 2020 16:39:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200489502', 'M0100000145473', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 16:39:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200489502', 'M0100000145473', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 16:39:41] (index) p_Stop=N [20 Nov 2020 16:39:41] (index) p_Alert= [20 Nov 2020 16:39: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 [20 Nov 2020 16:39:41] (index) database connection response [20 Nov 2020 16:39:41] (index) getConnectionClose() called.... [20 Nov 2020 16:39:41] (index) getConnectionClose() called.... [20 Nov 2020 16:39:58] (viewOnlineReports) database connection response [20 Nov 2020 16:39:58] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 16:39:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000145473', '001', '200421297', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 16:39:58] (viewOnlineReports) p_Stop=N [20 Nov 2020 16:39:58] (viewOnlineReports) p_Alert= [20 Nov 2020 16:39:58] (viewOnlineReports) Flag = 1 [20 Nov 2020 16:39: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', '200421297', 'M01', '047', '2', '001000000000087086', 'M0100000145473_M01MIC20008894_1.PDF', 'M0100000145473', SYSDATE) [20 Nov 2020 16:39:58] (viewOnlineReports) database connection response [20 Nov 2020 16:39:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200421297' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [20 Nov 2020 16:39:58] (viewOnlineReports) database connection response [20 Nov 2020 16:39:58] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 16:39:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200421297/ [20 Nov 2020 16:39:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200421297/ [20 Nov 2020 16:39:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:39:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200421297/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1605872398M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:39:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1605872398M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:39:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 16:39:58] (viewOnlineReports) Converting PDF to JPG with name as M0100000145473_M01MIC20008894_1.jpg [20 Nov 2020 16:39:58] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1605872398M0100000145473_M01MIC20008894_1.PDF ../../TEMP_PDF/200421297/M0100000145473_M01MIC20008894_1.jpg [20 Nov 2020 16:39:58] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1605872398M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:40:02] (viewOnlineReports) database connection response [20 Nov 2020 16:40:02] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 16:40:02] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000145473', '001', '200421297', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 16:40:02] (viewOnlineReports) p_Stop=N [20 Nov 2020 16:40:02] (viewOnlineReports) p_Alert= [20 Nov 2020 16:40:02] (viewOnlineReports) Flag = 1 [20 Nov 2020 16:40:02] (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', '200421297', 'M01', '047', '2', '001000000000087086', 'M0100000145473_M01MIC20008894_1.PDF', 'M0100000145473', SYSDATE) [20 Nov 2020 16:40:02] (viewOnlineReports) database connection response [20 Nov 2020 16:40:02] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200421297' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [20 Nov 2020 16:40:02] (viewOnlineReports) database connection response [20 Nov 2020 16:40:02] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 16:40:02] (viewOnlineReports) creating directory structure../../TEMP_PDF/200421297/ [20 Nov 2020 16:40:02] (viewOnlineReports) directory structure created ../../TEMP_PDF/200421297/ [20 Nov 2020 16:40:02] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:40:02] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200421297/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605872402M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:40:02] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200421297/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605872402M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:40:02] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 16:40:02] (viewOnlineReports) Converting PDF to JPG with name as M0100000145473_M01MIC20008894_1.jpg [20 Nov 2020 16:40:02] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200421297/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605872402M0100000145473_M01MIC20008894_1.PDF ../../TEMP_PDF/200421297/M0100000145473_M01MIC20008894_1.jpg [20 Nov 2020 16:40:02] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200421297/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605872402M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:40:37] (viewOnlineReports) database connection response [20 Nov 2020 16:40:37] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 16:40:37] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000145473', '001', '200421297', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 16:40:37] (viewOnlineReports) p_Stop=N [20 Nov 2020 16:40:37] (viewOnlineReports) p_Alert= [20 Nov 2020 16:40:37] (viewOnlineReports) Flag = 1 [20 Nov 2020 16:40:37] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200421297', 'M01', '047', '2', '001000000000087086', 'M0100000145473_M01MIC20008894_1.PDF', 'M0100000145473', SYSDATE) [20 Nov 2020 16:40:37] (viewOnlineReports) database connection response [20 Nov 2020 16:40:37] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200421297' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [20 Nov 2020 16:40:37] (viewOnlineReports) database connection response [20 Nov 2020 16:40:37] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 16:40:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200421297/ [20 Nov 2020 16:40:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200421297/ [20 Nov 2020 16:40:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:40:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1605872437M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:40:37] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1605872437M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 16:40:37] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Nov 2020 16:40:37] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1605872437M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:14:57] (viewOnlineReports) database connection response [20 Nov 2020 17:14:57] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 17:14:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200421297', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:14:57] (viewOnlineReports) p_Stop=N [20 Nov 2020 17:14:57] (viewOnlineReports) p_Alert= [20 Nov 2020 17:14:57] (viewOnlineReports) Flag = 1 [20 Nov 2020 17:14:57] (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', '200421297', 'M01', '047', '2', '001000000000087086', 'M0100000145473_M01MIC20008894_1.PDF', '00100000000000', SYSDATE) [20 Nov 2020 17:14:57] (viewOnlineReports) database connection response [20 Nov 2020 17:14:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200421297' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [20 Nov 2020 17:14:57] (viewOnlineReports) database connection response [20 Nov 2020 17:14:57] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 17:14:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200421297/ [20 Nov 2020 17:14:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200421297/ [20 Nov 2020 17:14:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:14:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200421297/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:14:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200421297/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:14:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 17:14:57] (viewOnlineReports) Downloading file ../../TEMP_PDF/200421297/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:15:08] (index) database connection response [20 Nov 2020 17:15:08] (index) getConnection(): Resource id #1 [20 Nov 2020 17:15:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 17:15:08] (index) database connection response [20 Nov 2020 17:15:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 17:15:08] (index) database connection response [20 Nov 2020 17:15:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 17:15:08] (index) database connection response [20 Nov 2020 17:15:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200489502' AND ACCESS_CODE = '99170118' [20 Nov 2020 17:15:08] (index) database connection response [20 Nov 2020 17:15:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200489502' AND ACCESS_CODE = '99170118' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 17:15:08] (index) database connection response [20 Nov 2020 17:15:08] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000145473' [20 Nov 2020 17:15:08] (index) database connection response [20 Nov 2020 17:15:08] (index) getPatientReportsDetail() entered [20 Nov 2020 17:15:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200489502', 'M0100000145473', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:15:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200489502', 'M0100000145473', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:15:08] (index) p_Stop=N [20 Nov 2020 17:15:08] (index) p_Alert= [20 Nov 2020 17:15:08] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [20 Nov 2020 17:15:08] (index) database connection response [20 Nov 2020 17:15:08] (index) getConnectionClose() called.... [20 Nov 2020 17:15:08] (index) getConnectionClose() called.... [20 Nov 2020 17:15:14] (viewOnlineReports) database connection response [20 Nov 2020 17:15:14] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 17:15:14] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000145473', '001', '200421297', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:15:14] (viewOnlineReports) p_Stop=N [20 Nov 2020 17:15:14] (viewOnlineReports) p_Alert= [20 Nov 2020 17:15:14] (viewOnlineReports) Flag = 1 [20 Nov 2020 17:15:14] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200421297', 'M01', '047', '2', '001000000000087086', 'M0100000145473_M01MIC20008894_1.PDF', 'M0100000145473', SYSDATE) [20 Nov 2020 17:15:14] (viewOnlineReports) database connection response [20 Nov 2020 17:15:14] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200421297' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [20 Nov 2020 17:15:14] (viewOnlineReports) database connection response [20 Nov 2020 17:15:14] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 17:15:14] (viewOnlineReports) creating directory structure../../TEMP_PDF/200421297/ [20 Nov 2020 17:15:14] (viewOnlineReports) directory structure created ../../TEMP_PDF/200421297/ [20 Nov 2020 17:15:14] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:15:14] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200421297/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605874514M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:15:14] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200421297/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605874514M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:15:14] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Nov 2020 17:15:14] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200421297/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605874514M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:15:18] (viewOnlineReports) database connection response [20 Nov 2020 17:15:18] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 17:15:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000145473', '001', '200421297', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:15:18] (viewOnlineReports) p_Stop=N [20 Nov 2020 17:15:18] (viewOnlineReports) p_Alert= [20 Nov 2020 17:15:18] (viewOnlineReports) Flag = 1 [20 Nov 2020 17:15:18] (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', '200421297', 'M01', '047', '2', '001000000000087086', 'M0100000145473_M01MIC20008894_1.PDF', 'M0100000145473', SYSDATE) [20 Nov 2020 17:15:18] (viewOnlineReports) database connection response [20 Nov 2020 17:15:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200421297' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [20 Nov 2020 17:15:18] (viewOnlineReports) database connection response [20 Nov 2020 17:15:18] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 17:15:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200421297/ [20 Nov 2020 17:15:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200421297/ [20 Nov 2020 17:15:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:15:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605874518M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:15:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605874518M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:15:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 17:15:18] (viewOnlineReports) Downloading file ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605874518M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 17:39:24] (index) database connection response [20 Nov 2020 17:39:24] (index) getConnection(): Resource id #1 [20 Nov 2020 17:39:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 17:39:24] (index) database connection response [20 Nov 2020 17:39:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 17:39:24] (index) database connection response [20 Nov 2020 17:39:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 17:39:24] (index) database connection response [20 Nov 2020 17:39:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200235640' AND ACCESS_CODE = '91014213' [20 Nov 2020 17:39:24] (index) database connection response [20 Nov 2020 17:39:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200235640' AND ACCESS_CODE = '91014213' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 17:39:24] (index) database connection response [20 Nov 2020 17:39:24] (index) getConnectionClose() called.... [20 Nov 2020 17:40:22] (index) database connection response [20 Nov 2020 17:40:22] (index) getConnection(): Resource id #1 [20 Nov 2020 17:40:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 17:40:22] (index) database connection response [20 Nov 2020 17:40:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 17:40:22] (index) database connection response [20 Nov 2020 17:40:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 17:40:22] (index) database connection response [20 Nov 2020 17:40:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200234640' AND ACCESS_CODE = '91014213' [20 Nov 2020 17:40:22] (index) database connection response [20 Nov 2020 17:40:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200234640' AND ACCESS_CODE = '91014213' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 17:40:22] (index) database connection response [20 Nov 2020 17:40:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000593939' [20 Nov 2020 17:40:22] (index) database connection response [20 Nov 2020 17:40:22] (index) getPatientReportsDetail() entered [20 Nov 2020 17:40:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200234640', 'M0100000593939', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:40:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200234640', 'M0100000593939', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:40:22] (index) p_Stop=N [20 Nov 2020 17:40:22] (index) p_Alert= [20 Nov 2020 17:40: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 [20 Nov 2020 17:40:22] (index) database connection response [20 Nov 2020 17:40:22] (index) getConnectionClose() called.... [20 Nov 2020 17:40:22] (index) getConnectionClose() called.... [20 Nov 2020 17:40:31] (index) database connection response [20 Nov 2020 17:40:31] (index) getConnection(): Resource id #1 [20 Nov 2020 17:40:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 17:40:31] (index) database connection response [20 Nov 2020 17:40:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 17:40:31] (index) database connection response [20 Nov 2020 17:40:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 17:40:31] (index) database connection response [20 Nov 2020 17:40:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200490120' AND ACCESS_CODE = '96226613' [20 Nov 2020 17:40:32] (index) database connection response [20 Nov 2020 17:40:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200490120' AND ACCESS_CODE = '96226613' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 17:40:32] (index) database connection response [20 Nov 2020 17:40:32] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000642776' [20 Nov 2020 17:40:32] (index) database connection response [20 Nov 2020 17:40:32] (index) getPatientReportsDetail() entered [20 Nov 2020 17:40:32] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200490120', 'M0100000642776', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:40:32] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200490120', 'M0100000642776', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:40:32] (index) p_Stop=N [20 Nov 2020 17:40:32] (index) p_Alert= [20 Nov 2020 17:40:32] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [20 Nov 2020 17:40:32] (index) database connection response [20 Nov 2020 17:40:32] (index) getConnectionClose() called.... [20 Nov 2020 17:40:32] (index) getConnectionClose() called.... [20 Nov 2020 17:40:37] (viewOnlineReports) database connection response [20 Nov 2020 17:40:37] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 17:40:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000593939', '001', '200343199', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:40:38] (viewOnlineReports) p_Stop=N [20 Nov 2020 17:40:38] (viewOnlineReports) p_Alert= [20 Nov 2020 17:40:38] (viewOnlineReports) Flag = 1 [20 Nov 2020 17:40:38] (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', '200343199', 'M01', '027', '1', '001000000000087630', 'M0100000593939_M01MOL20002802_1.PDF', 'M0100000593939', SYSDATE) [20 Nov 2020 17:40:38] (viewOnlineReports) database connection response [20 Nov 2020 17:40:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200343199' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [20 Nov 2020 17:40:38] (viewOnlineReports) database connection response [20 Nov 2020 17:40:38] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 17:40:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200343199/ [20 Nov 2020 17:40:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200343199/ [20 Nov 2020 17:40:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200606\M01\M0100000593939_M01MOL20002802_1.PDF [20 Nov 2020 17:40:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200343199/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605876037M0100000593939_M01MOL20002802_1.PDF [20 Nov 2020 17:40:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200343199/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605876037M0100000593939_M01MOL20002802_1.PDF [20 Nov 2020 17:40:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 17:40:38] (viewOnlineReports) Downloading file ../../TEMP_PDF/200343199/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605876037M0100000593939_M01MOL20002802_1.PDF [20 Nov 2020 17:40:49] (viewOnlineReports) database connection response [20 Nov 2020 17:40:49] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 17:40:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000642776', '001', '200421532', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 17:40:49] (viewOnlineReports) p_Stop=N [20 Nov 2020 17:40:49] (viewOnlineReports) p_Alert= [20 Nov 2020 17:40:49] (viewOnlineReports) Flag = 1 [20 Nov 2020 17:40:49] (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', '200421532', 'M01', '070', '2', '001000000000085025', 'M0100000642776_M01HEM20016224_1.PDF', 'M0100000642776', SYSDATE) [20 Nov 2020 17:40:49] (viewOnlineReports) database connection response [20 Nov 2020 17:40:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200421532' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '2' [20 Nov 2020 17:40:49] (viewOnlineReports) database connection response [20 Nov 2020 17:40:49] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 17:40:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200421532/ [20 Nov 2020 17:40:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200421532/ [20 Nov 2020 17:40:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201113\M01\M0100000642776_M01HEM20016224_1.PDF [20 Nov 2020 17:40:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200421532/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605876049M0100000642776_M01HEM20016224_1.PDF [20 Nov 2020 17:40:49] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200421532/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605876049M0100000642776_M01HEM20016224_1.PDF [20 Nov 2020 17:40:49] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 17:40:49] (viewOnlineReports) Downloading file ../../TEMP_PDF/200421532/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1605876049M0100000642776_M01HEM20016224_1.PDF [20 Nov 2020 19:19:24] (index) database connection response [20 Nov 2020 19:19:24] (index) getConnection(): Resource id #1 [20 Nov 2020 19:19:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 19:19:24] (index) database connection response [20 Nov 2020 19:19:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 19:19:24] (index) database connection response [20 Nov 2020 19:19:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 19:19:24] (index) database connection response [20 Nov 2020 19:19:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200375833' AND ACCESS_CODE = '09331628' [20 Nov 2020 19:19:24] (index) database connection response [20 Nov 2020 19:19:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200375833' AND ACCESS_CODE = '09331628' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 19:19:24] (index) database connection response [20 Nov 2020 19:19:24] (index) getConnectionClose() called.... [20 Nov 2020 19:20:28] (index) database connection response [20 Nov 2020 19:20:28] (index) getConnection(): Resource id #1 [20 Nov 2020 19:20:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 19:20:28] (index) database connection response [20 Nov 2020 19:20:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 19:20:28] (index) database connection response [20 Nov 2020 19:20:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 19:20:28] (index) database connection response [20 Nov 2020 19:20:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500905' AND ACCESS_CODE = '09331628' [20 Nov 2020 19:20:28] (index) database connection response [20 Nov 2020 19:20:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500905' AND ACCESS_CODE = '09331628' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 19:20:29] (index) database connection response [20 Nov 2020 19:20:29] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643642' [20 Nov 2020 19:20:29] (index) database connection response [20 Nov 2020 19:20:29] (index) getPatientReportsDetail() entered [20 Nov 2020 19:20:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500905', 'M0100000643642', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 19:20:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500905', 'M0100000643642', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 19:20:29] (index) p_Stop=N [20 Nov 2020 19:20:29] (index) p_Alert= [20 Nov 2020 19:20: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 [20 Nov 2020 19:20:29] (index) database connection response [20 Nov 2020 19:20:29] (index) getConnectionClose() called.... [20 Nov 2020 19:20:29] (index) getConnectionClose() called.... [20 Nov 2020 19:28:55] (index) database connection response [20 Nov 2020 19:28:55] (index) getConnection(): Resource id #1 [20 Nov 2020 19:28:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 19:28:55] (index) database connection response [20 Nov 2020 19:28:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 19:28:55] (index) database connection response [20 Nov 2020 19:28:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 19:28:55] (index) database connection response [20 Nov 2020 19:28:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500905' AND ACCESS_CODE = '09331628' [20 Nov 2020 19:28:55] (index) database connection response [20 Nov 2020 19:28:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500905' AND ACCESS_CODE = '09331628' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 19:28:55] (index) database connection response [20 Nov 2020 19:28:55] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000643642' [20 Nov 2020 19:28:55] (index) database connection response [20 Nov 2020 19:28:55] (index) getPatientReportsDetail() entered [20 Nov 2020 19:28:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500905', 'M0100000643642', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 19:28:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500905', 'M0100000643642', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 19:28:55] (index) p_Stop=N [20 Nov 2020 19:28:55] (index) p_Alert= [20 Nov 2020 19:28: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 [20 Nov 2020 19:28:55] (index) database connection response [20 Nov 2020 19:28:55] (index) getConnectionClose() called.... [20 Nov 2020 19:28:55] (index) getConnectionClose() called.... [20 Nov 2020 19:34:29] (index) database connection response [20 Nov 2020 19:34:29] (index) getConnection(): Resource id #1 [20 Nov 2020 19:34:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 19:34:29] (index) database connection response [20 Nov 2020 19:34:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 19:34:29] (index) database connection response [20 Nov 2020 19:34:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 19:34:29] (index) database connection response [20 Nov 2020 19:34:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200501500' AND ACCESS_CODE = '42331994' [20 Nov 2020 19:34:29] (index) database connection response [20 Nov 2020 19:34:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200501500' AND ACCESS_CODE = '42331994' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 19:34:30] (index) database connection response [20 Nov 2020 19:34:30] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000641886' [20 Nov 2020 19:34:30] (index) database connection response [20 Nov 2020 19:34:30] (index) getPatientReportsDetail() entered [20 Nov 2020 19:34:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200501500', 'M0100000641886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 19:34:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200501500', 'M0100000641886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 19:34:30] (index) p_Stop=N [20 Nov 2020 19:34:30] (index) p_Alert= [20 Nov 2020 19:34: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 [20 Nov 2020 19:34:30] (index) database connection response [20 Nov 2020 19:34:30] (index) getConnectionClose() called.... [20 Nov 2020 19:34:30] (index) getConnectionClose() called.... [20 Nov 2020 20:52:40] (index) database connection response [20 Nov 2020 20:52:40] (index) getConnection(): Resource id #1 [20 Nov 2020 20:52:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 20:52:40] (index) database connection response [20 Nov 2020 20:52:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 20:52:40] (index) database connection response [20 Nov 2020 20:52:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 20:52:40] (index) database connection response [20 Nov 2020 20:52:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500009' AND ACCESS_CODE = '82286847' [20 Nov 2020 20:52:40] (index) database connection response [20 Nov 2020 20:52:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500009' AND ACCESS_CODE = '82286847' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 20:52:40] (index) database connection response [20 Nov 2020 20:52:40] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000492152' [20 Nov 2020 20:52:40] (index) database connection response [20 Nov 2020 20:52:40] (index) getPatientReportsDetail() entered [20 Nov 2020 20:52:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500009', 'M0100000492152', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 20:52:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500009', 'M0100000492152', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 20:52:41] (index) p_Stop=N [20 Nov 2020 20:52:41] (index) p_Alert= [20 Nov 2020 20:52: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 [20 Nov 2020 20:52:41] (index) database connection response [20 Nov 2020 20:52:41] (index) getConnectionClose() called.... [20 Nov 2020 20:52:41] (index) getConnectionClose() called.... [20 Nov 2020 20:53:08] (viewOnlineReports) database connection response [20 Nov 2020 20:53:08] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 20:53:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000492152', '001', '200424643', '1', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 20:53:08] (viewOnlineReports) p_Stop=N [20 Nov 2020 20:53:08] (viewOnlineReports) p_Alert= [20 Nov 2020 20:53:08] (viewOnlineReports) Flag = 1 [20 Nov 2020 20:53:08] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200424643', 'M01', '047', '1', '001000000000087100', 'M0100000492152_M01MIC20009131_2.PDF', 'M0100000492152', SYSDATE) [20 Nov 2020 20:53:08] (viewOnlineReports) database connection response [20 Nov 2020 20:53:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424643' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 20:53:08] (viewOnlineReports) database connection response [20 Nov 2020 20:53:08] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 20:53:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424643/ [20 Nov 2020 20:53:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424643/ [20 Nov 2020 20:53:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201120\M01\M0100000492152_M01MIC20009131_2.PDF [20 Nov 2020 20:53:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424643/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605887588M0100000492152_M01MIC20009131_2.PDF [20 Nov 2020 20:53:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424643/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605887588M0100000492152_M01MIC20009131_2.PDF [20 Nov 2020 20:53:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 20:53:08] (viewOnlineReports) Converting PDF to JPG with name as M0100000492152_M01MIC20009131_2.jpg [20 Nov 2020 20:53:08] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200424643/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605887588M0100000492152_M01MIC20009131_2.PDF ../../TEMP_PDF/200424643/M0100000492152_M01MIC20009131_2.jpg [20 Nov 2020 20:53:08] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200424643/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1605887588M0100000492152_M01MIC20009131_2.PDF [20 Nov 2020 21:37:20] (viewOnlineReports) database connection response [20 Nov 2020 21:37:20] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 21:37:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200421297', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 21:37:20] (viewOnlineReports) p_Stop=N [20 Nov 2020 21:37:20] (viewOnlineReports) p_Alert= [20 Nov 2020 21:37:20] (viewOnlineReports) Flag = 1 [20 Nov 2020 21:37:20] (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', '200421297', 'M01', '047', '2', '001000000000087086', 'M0100000145473_M01MIC20008894_1.PDF', '00100000000000', SYSDATE) [20 Nov 2020 21:37:20] (viewOnlineReports) database connection response [20 Nov 2020 21:37:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200421297' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [20 Nov 2020 21:37:20] (viewOnlineReports) database connection response [20 Nov 2020 21:37:20] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 21:37:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200421297/ [20 Nov 2020 21:37:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200421297/ [20 Nov 2020 21:37:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201116\M01\M0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 21:37:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZM0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 21:37:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZM0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 21:37:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 21:37:20] (viewOnlineReports) Downloading file ../../TEMP_PDF/200421297/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZM0100000145473_M01MIC20008894_1.PDF [20 Nov 2020 22:52:56] (viewOnlineReports) database connection response [20 Nov 2020 22:52:56] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 22:52:56] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200424742', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 22:52:56] (viewOnlineReports) p_Stop=N [20 Nov 2020 22:52:56] (viewOnlineReports) p_Alert= [20 Nov 2020 22:52:56] (viewOnlineReports) Flag = 1 [20 Nov 2020 22:52:56] (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', '200424742', 'M01', '047', '1', '001000000000085025', 'M0100000583634_M01HEM20016567_1.PDF', '00100000000000', SYSDATE) [20 Nov 2020 22:52:56] (viewOnlineReports) database connection response [20 Nov 2020 22:52:56] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200424742' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 22:52:56] (viewOnlineReports) database connection response [20 Nov 2020 22:52:56] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 22:52:56] (viewOnlineReports) creating directory structure../../TEMP_PDF/200424742/ [20 Nov 2020 22:52:56] (viewOnlineReports) directory structure created ../../TEMP_PDF/200424742/ [20 Nov 2020 22:52:56] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201120\M01\M0100000583634_M01HEM20016567_1.PDF [20 Nov 2020 22:52:56] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200424742/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZM0100000583634_M01HEM20016567_1.PDF [20 Nov 2020 22:52:56] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200424742/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZM0100000583634_M01HEM20016567_1.PDF [20 Nov 2020 22:52:56] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 22:52:56] (viewOnlineReports) Converting PDF to JPG with name as M0100000583634_M01HEM20016567_1.jpg [20 Nov 2020 22:52:56] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200424742/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZM0100000583634_M01HEM20016567_1.PDF ../../TEMP_PDF/200424742/M0100000583634_M01HEM20016567_1.jpg [20 Nov 2020 22:52:56] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200424742/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZM0100000583634_M01HEM20016567_1.PDF [20 Nov 2020 22:53:06] (index) database connection response [20 Nov 2020 22:53:06] (index) getConnection(): Resource id #1 [20 Nov 2020 22:53:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 22:53:06] (index) database connection response [20 Nov 2020 22:53:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 22:53:06] (index) database connection response [20 Nov 2020 22:53:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 22:53:06] (index) database connection response [20 Nov 2020 22:53:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' [20 Nov 2020 22:53:06] (index) database connection response [20 Nov 2020 22:53:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200500210' AND ACCESS_CODE = '58514062' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 22:53:06] (index) database connection response [20 Nov 2020 22:53:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 22:53:06] (index) database connection response [20 Nov 2020 22:53:06] (index) getPatientReportsDetail() entered [20 Nov 2020 22:53:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 22:53:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200500210', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 22:53:06] (index) p_Stop=N [20 Nov 2020 22:53:06] (index) p_Alert= [20 Nov 2020 22:53:06] (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 [20 Nov 2020 22:53:06] (index) database connection response [20 Nov 2020 22:53:06] (index) getConnectionClose() called.... [20 Nov 2020 22:53:06] (index) getConnectionClose() called.... [20 Nov 2020 23:03:53] (index) database connection response [20 Nov 2020 23:03:53] (index) getConnection(): Resource id #1 [20 Nov 2020 23:03:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [20 Nov 2020 23:03:53] (index) database connection response [20 Nov 2020 23:03:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Nov 2020 23:03:53] (index) database connection response [20 Nov 2020 23:03:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Nov 2020 23:03:53] (index) database connection response [20 Nov 2020 23:03:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200501457' AND ACCESS_CODE = '49006048' [20 Nov 2020 23:03:53] (index) database connection response [20 Nov 2020 23:03:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200501457' AND ACCESS_CODE = '49006048' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Nov 2020 23:03:53] (index) database connection response [20 Nov 2020 23:03:53] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000583634' [20 Nov 2020 23:03:53] (index) database connection response [20 Nov 2020 23:03:53] (index) getPatientReportsDetail() entered [20 Nov 2020 23:03:53] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200501457', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 23:03:53] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200501457', 'M0100000583634', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 23:03:53] (index) p_Stop=N [20 Nov 2020 23:03:53] (index) p_Alert= [20 Nov 2020 23:03:53] (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 [20 Nov 2020 23:03:53] (index) database connection response [20 Nov 2020 23:03:53] (index) getConnectionClose() called.... [20 Nov 2020 23:03:53] (index) getConnectionClose() called.... [20 Nov 2020 23:04:00] (viewOnlineReports) database connection response [20 Nov 2020 23:04:00] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 23:04:00] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000583634', '001', '200425126', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 23:04:00] (viewOnlineReports) p_Stop=N [20 Nov 2020 23:04:00] (viewOnlineReports) p_Alert= [20 Nov 2020 23:04:00] (viewOnlineReports) Flag = 1 [20 Nov 2020 23:04:00] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200425126', 'M01', '047', '1', '001000000000087630', 'M0100000583634_M01MOL20013038_1.PDF', 'M0100000583634', SYSDATE) [20 Nov 2020 23:04:00] (viewOnlineReports) database connection response [20 Nov 2020 23:04:00] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200425126' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 23:04:00] (viewOnlineReports) database connection response [20 Nov 2020 23:04:00] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 23:04:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200425126/ [20 Nov 2020 23:04:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200425126/ [20 Nov 2020 23:04:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201120\M01\M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200425126/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1605895440M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:00] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200425126/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1605895440M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:00] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 23:04:00] (viewOnlineReports) Converting PDF to JPG with name as M0100000583634_M01MOL20013038_1.jpg [20 Nov 2020 23:04:00] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200425126/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1605895440M0100000583634_M01MOL20013038_1.PDF ../../TEMP_PDF/200425126/M0100000583634_M01MOL20013038_1.jpg [20 Nov 2020 23:04:00] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200425126/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1605895440M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:08] (viewOnlineReports) database connection response [20 Nov 2020 23:04:08] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 23:04:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000583634', '001', '200425126', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 23:04:08] (viewOnlineReports) p_Stop=N [20 Nov 2020 23:04:08] (viewOnlineReports) p_Alert= [20 Nov 2020 23:04:08] (viewOnlineReports) Flag = 1 [20 Nov 2020 23:04:08] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200425126', 'M01', '047', '1', '001000000000087630', 'M0100000583634_M01MOL20013038_1.PDF', 'M0100000583634', SYSDATE) [20 Nov 2020 23:04:08] (viewOnlineReports) database connection response [20 Nov 2020 23:04:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200425126' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 23:04:08] (viewOnlineReports) database connection response [20 Nov 2020 23:04:08] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 23:04:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200425126/ [20 Nov 2020 23:04:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200425126/ [20 Nov 2020 23:04:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201120\M01\M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200425126/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1605895448M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200425126/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1605895448M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Nov 2020 23:04:08] (viewOnlineReports) Converting PDF to JPG with name as M0100000583634_M01MOL20013038_1.jpg [20 Nov 2020 23:04:08] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200425126/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1605895448M0100000583634_M01MOL20013038_1.PDF ../../TEMP_PDF/200425126/M0100000583634_M01MOL20013038_1.jpg [20 Nov 2020 23:04:08] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200425126/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1605895448M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:23] (viewOnlineReports) database connection response [20 Nov 2020 23:04:23] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 23:04:23] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000583634', '001', '200425126', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 23:04:23] (viewOnlineReports) p_Stop=N [20 Nov 2020 23:04:23] (viewOnlineReports) p_Alert= [20 Nov 2020 23:04:23] (viewOnlineReports) Flag = 1 [20 Nov 2020 23:04: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', '200425126', 'M01', '047', '1', '001000000000087630', 'M0100000583634_M01MOL20013038_1.PDF', 'M0100000583634', SYSDATE) [20 Nov 2020 23:04:23] (viewOnlineReports) database connection response [20 Nov 2020 23:04:23] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200425126' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 23:04:23] (viewOnlineReports) database connection response [20 Nov 2020 23:04:23] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 23:04:23] (viewOnlineReports) creating directory structure../../TEMP_PDF/200425126/ [20 Nov 2020 23:04:23] (viewOnlineReports) directory structure created ../../TEMP_PDF/200425126/ [20 Nov 2020 23:04:23] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201120\M01\M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:23] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200425126/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605895463M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200425126/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605895463M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Nov 2020 23:04:23] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200425126/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1605895463M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:35] (viewOnlineReports) database connection response [20 Nov 2020 23:04:35] (viewOnlineReports) getConnection(): Resource id #1 [20 Nov 2020 23:04:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000583634', '001', '200425126', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Nov 2020 23:04:35] (viewOnlineReports) p_Stop=N [20 Nov 2020 23:04:35] (viewOnlineReports) p_Alert= [20 Nov 2020 23:04:35] (viewOnlineReports) Flag = 1 [20 Nov 2020 23:04: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', '200425126', 'M01', '047', '1', '001000000000087630', 'M0100000583634_M01MOL20013038_1.PDF', 'M0100000583634', SYSDATE) [20 Nov 2020 23:04:35] (viewOnlineReports) database connection response [20 Nov 2020 23:04:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200425126' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [20 Nov 2020 23:04:35] (viewOnlineReports) database connection response [20 Nov 2020 23:04:35] (viewOnlineReports) getConnectionClose() called.... [20 Nov 2020 23:04:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200425126/ [20 Nov 2020 23:04:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200425126/ [20 Nov 2020 23:04:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201120\M01\M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200425126/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605895474M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200425126/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605895474M0100000583634_M01MOL20013038_1.PDF [20 Nov 2020 23:04:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Nov 2020 23:04:35] (viewOnlineReports) Downloading file ../../TEMP_PDF/200425126/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1605895474M0100000583634_M01MOL20013038_1.PDF