[20 Aug 2020 14:27:11] (index) database connection response [20 Aug 2020 14:27:11] (index) getConnection(): Resource id #1 [20 Aug 2020 14:27:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 14:27:11] (index) database connection response [20 Aug 2020 14:27:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 14:27:11] (index) database connection response [20 Aug 2020 14:27:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 14:27:11] (index) database connection response [20 Aug 2020 14:27:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'MO1200338099' AND ACCESS_CODE = '04795287' [20 Aug 2020 14:27:11] (index) database connection response [20 Aug 2020 14:27:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'MO1200338099' AND ACCESS_CODE = '04795287' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 14:27:11] (index) database connection response [20 Aug 2020 14:27:11] (index) getConnectionClose() called.... [20 Aug 2020 14:28:37] (index) database connection response [20 Aug 2020 14:28:37] (index) getConnection(): Resource id #1 [20 Aug 2020 14:28:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 14:28:37] (index) database connection response [20 Aug 2020 14:28:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 14:28:37] (index) database connection response [20 Aug 2020 14:28:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 14:28:37] (index) database connection response [20 Aug 2020 14:28:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338099' AND ACCESS_CODE = '04795287' [20 Aug 2020 14:28:37] (index) database connection response [20 Aug 2020 14:28:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338099' AND ACCESS_CODE = '04795287' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 14:28:37] (index) database connection response [20 Aug 2020 14:28:37] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000630623' [20 Aug 2020 14:28:37] (index) database connection response [20 Aug 2020 14:28:37] (index) getPatientReportsDetail() entered [20 Aug 2020 14:28:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338099', 'M0100000630623', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:28:38] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338099', 'M0100000630623', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:28:38] (index) p_Stop=N [20 Aug 2020 14:28:38] (index) p_Alert= [20 Aug 2020 14:28:38] (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 Aug 2020 14:28:38] (index) database connection response [20 Aug 2020 14:28:38] (index) getConnectionClose() called.... [20 Aug 2020 14:28:38] (index) getConnectionClose() called.... [20 Aug 2020 14:29:09] (viewOnlineReports) database connection response [20 Aug 2020 14:29:09] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:29:10] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '3', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:29:10] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:29:10] (viewOnlineReports) p_Alert= [20 Aug 2020 14:29:10] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:29:10] (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', '200373400', 'M01', '001', '3', '001000000000081028', 'M0100000630623_M01RCH20015098_1.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:29:10] (viewOnlineReports) database connection response [20 Aug 2020 14:29:10] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [20 Aug 2020 14:29:10] (viewOnlineReports) database connection response [20 Aug 2020 14:29:10] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:29:10] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:29:10] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:29:10] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000630623_M01RCH20015098_1.PDF [20 Aug 2020 14:29:10] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597915749M0100000630623_M01RCH20015098_1.PDF [20 Aug 2020 14:29:10] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597915749M0100000630623_M01RCH20015098_1.PDF [20 Aug 2020 14:29:10] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Aug 2020 14:29:10] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200373400/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597915749M0100000630623_M01RCH20015098_1.PDF [20 Aug 2020 14:30:47] (viewOnlineReports) database connection response [20 Aug 2020 14:30:47] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:30:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '9', '001000000000080092', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:30:47] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:30:47] (viewOnlineReports) p_Alert= [20 Aug 2020 14:30:47] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:30:47] (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', '200373400', 'M01', '001', '9', '001000000000080092', 'M0100000630623_M01SCH20008358_1.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:30:47] (viewOnlineReports) database connection response [20 Aug 2020 14:30:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '9' [20 Aug 2020 14:30:47] (viewOnlineReports) database connection response [20 Aug 2020 14:30:47] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:30:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:30:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:30:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000630623_M01SCH20008358_1.PDF [20 Aug 2020 14:30:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1597915847M0100000630623_M01SCH20008358_1.PDF [20 Aug 2020 14:30:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1597915847M0100000630623_M01SCH20008358_1.PDF [20 Aug 2020 14:30:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Aug 2020 14:30:47] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1597915847M0100000630623_M01SCH20008358_1.PDF [20 Aug 2020 14:40:05] (index) database connection response [20 Aug 2020 14:40:05] (index) getConnection(): Resource id #1 [20 Aug 2020 14:40:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 14:40:05] (index) database connection response [20 Aug 2020 14:40:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 14:40:05] (index) database connection response [20 Aug 2020 14:40:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 14:40:05] (index) database connection response [20 Aug 2020 14:40:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338099' AND ACCESS_CODE = '04795287' [20 Aug 2020 14:40:05] (index) database connection response [20 Aug 2020 14:40:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338099' AND ACCESS_CODE = '04795287' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 14:40:05] (index) database connection response [20 Aug 2020 14:40:05] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000630623' [20 Aug 2020 14:40:05] (index) database connection response [20 Aug 2020 14:40:05] (index) getPatientReportsDetail() entered [20 Aug 2020 14:40:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338099', 'M0100000630623', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:40:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338099', 'M0100000630623', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:40:05] (index) p_Stop=N [20 Aug 2020 14:40:05] (index) p_Alert= [20 Aug 2020 14:40:05] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [20 Aug 2020 14:40:05] (index) database connection response [20 Aug 2020 14:40:05] (index) getConnectionClose() called.... [20 Aug 2020 14:40:05] (index) getConnectionClose() called.... [20 Aug 2020 14:40:13] (viewOnlineReports) database connection response [20 Aug 2020 14:40:13] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:40:13] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '9', '001000000000080092', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:40:13] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:40:13] (viewOnlineReports) p_Alert= [20 Aug 2020 14:40:13] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:40:13] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200373400', 'M01', '001', '9', '001000000000080092', 'M0100000630623_M01SCH20008358_1.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:40:13] (viewOnlineReports) database connection response [20 Aug 2020 14:40:13] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '9' [20 Aug 2020 14:40:13] (viewOnlineReports) database connection response [20 Aug 2020 14:40:13] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:40:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:40:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:40:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000630623_M01SCH20008358_1.PDF [20 Aug 2020 14:40:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1597916413M0100000630623_M01SCH20008358_1.PDF [20 Aug 2020 14:40:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1597916413M0100000630623_M01SCH20008358_1.PDF [20 Aug 2020 14:40:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 14:40:13] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1597916413M0100000630623_M01SCH20008358_1.PDF [20 Aug 2020 14:41:10] (index) database connection response [20 Aug 2020 14:41:10] (index) getConnection(): Resource id #1 [20 Aug 2020 14:41:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 14:41:10] (index) database connection response [20 Aug 2020 14:41:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 14:41:10] (index) database connection response [20 Aug 2020 14:41:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 14:41:10] (index) database connection response [20 Aug 2020 14:41:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338099' AND ACCESS_CODE = '04795287' [20 Aug 2020 14:41:10] (index) database connection response [20 Aug 2020 14:41:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338099' AND ACCESS_CODE = '04795287' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 14:41:10] (index) database connection response [20 Aug 2020 14:41:10] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000630623' [20 Aug 2020 14:41:10] (index) database connection response [20 Aug 2020 14:41:10] (index) getPatientReportsDetail() entered [20 Aug 2020 14:41:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338099', 'M0100000630623', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:41:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338099', 'M0100000630623', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:41:10] (index) p_Stop=N [20 Aug 2020 14:41:10] (index) p_Alert= [20 Aug 2020 14:41:10] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [20 Aug 2020 14:41:10] (index) database connection response [20 Aug 2020 14:41:10] (index) getConnectionClose() called.... [20 Aug 2020 14:41:10] (index) getConnectionClose() called.... [20 Aug 2020 14:41:18] (viewOnlineReports) database connection response [20 Aug 2020 14:41:18] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:41:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '7', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:41:18] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:41:18] (viewOnlineReports) p_Alert= [20 Aug 2020 14:41:18] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:41: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', '200373400', 'M01', '001', '7', '001000000000084949', 'M0100000630623_M01RCH20015098_3.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:41:18] (viewOnlineReports) database connection response [20 Aug 2020 14:41:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '7' [20 Aug 2020 14:41:18] (viewOnlineReports) database connection response [20 Aug 2020 14:41:18] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:41:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:41:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:41:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000630623_M01RCH20015098_3.PDF [20 Aug 2020 14:41:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1597916478M0100000630623_M01RCH20015098_3.PDF [20 Aug 2020 14:41:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1597916478M0100000630623_M01RCH20015098_3.PDF [20 Aug 2020 14:41:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 14:41:18] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1597916478M0100000630623_M01RCH20015098_3.PDF [20 Aug 2020 14:42:10] (viewOnlineReports) database connection response [20 Aug 2020 14:42:10] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:42:10] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '6', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:42:10] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:42:10] (viewOnlineReports) p_Alert= [20 Aug 2020 14:42:10] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:42:10] (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', '200373400', 'M01', '001', '6', '001000000000084460', 'M0100000630623_M01RCH20015098_2.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:42:10] (viewOnlineReports) database connection response [20 Aug 2020 14:42:10] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '6' [20 Aug 2020 14:42:10] (viewOnlineReports) database connection response [20 Aug 2020 14:42:10] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:42:10] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:42:10] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:42:10] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000630623_M01RCH20015098_2.PDF [20 Aug 2020 14:42:10] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1597916530M0100000630623_M01RCH20015098_2.PDF [20 Aug 2020 14:42:10] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1597916530M0100000630623_M01RCH20015098_2.PDF [20 Aug 2020 14:42:10] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 14:42:10] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373400/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1597916530M0100000630623_M01RCH20015098_2.PDF [20 Aug 2020 14:42:38] (viewOnlineReports) database connection response [20 Aug 2020 14:42:38] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:42:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '5', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:42:38] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:42:38] (viewOnlineReports) p_Alert= [20 Aug 2020 14:42:38] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:42: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', '200373400', 'M01', '001', '5', '001000000000086302', 'M0100000630623_M01SCH20008358_3.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:42:38] (viewOnlineReports) database connection response [20 Aug 2020 14:42:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '5' [20 Aug 2020 14:42:38] (viewOnlineReports) database connection response [20 Aug 2020 14:42:38] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:42:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:42:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:42:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000630623_M01SCH20008358_3.PDF [20 Aug 2020 14:42:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1597916558M0100000630623_M01SCH20008358_3.PDF [20 Aug 2020 14:42:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1597916558M0100000630623_M01SCH20008358_3.PDF [20 Aug 2020 14:42:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 14:42:39] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1597916558M0100000630623_M01SCH20008358_3.PDF [20 Aug 2020 14:43:17] (viewOnlineReports) database connection response [20 Aug 2020 14:43:17] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:43:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '4', '001000000000086287', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:43:17] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:43:17] (viewOnlineReports) p_Alert= [20 Aug 2020 14:43:17] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:43:17] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200373400', 'M01', '001', '4', '001000000000086287', 'M0100000630623_M01SCH20008358_2.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:43:17] (viewOnlineReports) database connection response [20 Aug 2020 14:43:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '4' [20 Aug 2020 14:43:17] (viewOnlineReports) database connection response [20 Aug 2020 14:43:17] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:43:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:43:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:43:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000630623_M01SCH20008358_2.PDF [20 Aug 2020 14:43:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1597916597M0100000630623_M01SCH20008358_2.PDF [20 Aug 2020 14:43:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1597916597M0100000630623_M01SCH20008358_2.PDF [20 Aug 2020 14:43:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 14:43:17] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1597916597M0100000630623_M01SCH20008358_2.PDF [20 Aug 2020 14:43:38] (viewOnlineReports) database connection response [20 Aug 2020 14:43:38] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:43:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '3', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:43:38] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:43:38] (viewOnlineReports) p_Alert= [20 Aug 2020 14:43:38] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:43: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', '200373400', 'M01', '001', '3', '001000000000081028', 'M0100000630623_M01RCH20015098_1.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:43:38] (viewOnlineReports) database connection response [20 Aug 2020 14:43:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [20 Aug 2020 14:43:38] (viewOnlineReports) database connection response [20 Aug 2020 14:43:38] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:43:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:43:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:43:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000630623_M01RCH20015098_1.PDF [20 Aug 2020 14:43:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1597916618M0100000630623_M01RCH20015098_1.PDF [20 Aug 2020 14:43:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1597916618M0100000630623_M01RCH20015098_1.PDF [20 Aug 2020 14:43:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 14:43:38] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1597916618M0100000630623_M01RCH20015098_1.PDF [20 Aug 2020 14:44:07] (viewOnlineReports) database connection response [20 Aug 2020 14:44:07] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 14:44:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000630623', '001', '200373400', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 14:44:07] (viewOnlineReports) p_Stop=N [20 Aug 2020 14:44:07] (viewOnlineReports) p_Alert= [20 Aug 2020 14:44:07] (viewOnlineReports) Flag = 1 [20 Aug 2020 14:44:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200373400', 'M01', '001', '1', '001000000000085025', 'M0100000630623_M01HEM20011174_1.PDF', 'M0100000630623', SYSDATE) [20 Aug 2020 14:44:07] (viewOnlineReports) database connection response [20 Aug 2020 14:44:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373400' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [20 Aug 2020 14:44:07] (viewOnlineReports) database connection response [20 Aug 2020 14:44:07] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 14:44:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373400/ [20 Aug 2020 14:44:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373400/ [20 Aug 2020 14:44:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200820\M01\M0100000630623_M01HEM20011174_1.PDF [20 Aug 2020 14:44:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1597916647M0100000630623_M01HEM20011174_1.PDF [20 Aug 2020 14:44:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1597916647M0100000630623_M01HEM20011174_1.PDF [20 Aug 2020 14:44:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 14:44:07] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373400/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1597916647M0100000630623_M01HEM20011174_1.PDF [20 Aug 2020 15:00:43] (index) database connection response [20 Aug 2020 15:00:43] (index) getConnection(): Resource id #1 [20 Aug 2020 15:00:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 15:00:43] (index) database connection response [20 Aug 2020 15:00:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 15:00:43] (index) database connection response [20 Aug 2020 15:00:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 15:00:43] (index) database connection response [20 Aug 2020 15:00:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' [20 Aug 2020 15:00:43] (index) database connection response [20 Aug 2020 15:00:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 15:00:43] (index) database connection response [20 Aug 2020 15:00:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000608815' [20 Aug 2020 15:00:43] (index) database connection response [20 Aug 2020 15:00:43] (index) getPatientReportsDetail() entered [20 Aug 2020 15:00:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:00:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:00:43] (index) p_Stop=N [20 Aug 2020 15:00:43] (index) p_Alert= [20 Aug 2020 15:00:43] (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 Aug 2020 15:00:43] (index) database connection response [20 Aug 2020 15:00:43] (index) getConnectionClose() called.... [20 Aug 2020 15:01:03] (index) database connection response [20 Aug 2020 15:01:03] (index) getConnection(): Resource id #1 [20 Aug 2020 15:01:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 15:01:03] (index) database connection response [20 Aug 2020 15:01:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 15:01:03] (index) database connection response [20 Aug 2020 15:01:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 15:01:03] (index) database connection response [20 Aug 2020 15:01:03] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' [20 Aug 2020 15:01:03] (index) database connection response [20 Aug 2020 15:01:03] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 15:01:03] (index) database connection response [20 Aug 2020 15:01:03] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000608815' [20 Aug 2020 15:01:03] (index) database connection response [20 Aug 2020 15:01:03] (index) getPatientReportsDetail() entered [20 Aug 2020 15:01:03] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:01:03] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:01:03] (index) p_Stop=N [20 Aug 2020 15:01:03] (index) p_Alert= [20 Aug 2020 15:01:03] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [20 Aug 2020 15:01:03] (index) database connection response [20 Aug 2020 15:01:03] (index) getConnectionClose() called.... [20 Aug 2020 15:01:41] (index) database connection response [20 Aug 2020 15:01:41] (index) getConnection(): Resource id #1 [20 Aug 2020 15:01:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 15:01:41] (index) database connection response [20 Aug 2020 15:01:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 15:01:41] (index) database connection response [20 Aug 2020 15:01:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 15:01:41] (index) database connection response [20 Aug 2020 15:01:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' [20 Aug 2020 15:01:41] (index) database connection response [20 Aug 2020 15:01:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 15:01:41] (index) database connection response [20 Aug 2020 15:01:41] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000608815' [20 Aug 2020 15:01:41] (index) database connection response [20 Aug 2020 15:01:41] (index) getPatientReportsDetail() entered [20 Aug 2020 15:01:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:01:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:01:41] (index) p_Stop=N [20 Aug 2020 15:01:41] (index) p_Alert= [20 Aug 2020 15:01: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 Aug 2020 15:01:41] (index) database connection response [20 Aug 2020 15:01:41] (index) getConnectionClose() called.... [20 Aug 2020 15:02:11] (index) database connection response [20 Aug 2020 15:02:11] (index) getConnection(): Resource id #1 [20 Aug 2020 15:02:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 15:02:11] (index) database connection response [20 Aug 2020 15:02:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 15:02:11] (index) database connection response [20 Aug 2020 15:02:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 15:02:11] (index) database connection response [20 Aug 2020 15:02:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' [20 Aug 2020 15:02:11] (index) database connection response [20 Aug 2020 15:02:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 15:02:11] (index) database connection response [20 Aug 2020 15:02:11] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000608815' [20 Aug 2020 15:02:11] (index) database connection response [20 Aug 2020 15:02:11] (index) getPatientReportsDetail() entered [20 Aug 2020 15:02:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:02:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:02:11] (index) p_Stop=N [20 Aug 2020 15:02:11] (index) p_Alert= [20 Aug 2020 15:02: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 Aug 2020 15:02:11] (index) database connection response [20 Aug 2020 15:02:11] (index) getConnectionClose() called.... [20 Aug 2020 15:06:22] (index) database connection response [20 Aug 2020 15:06:22] (index) getConnection(): Resource id #1 [20 Aug 2020 15:06:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 15:06:22] (index) database connection response [20 Aug 2020 15:06:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 15:06:22] (index) database connection response [20 Aug 2020 15:06:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 15:06:22] (index) database connection response [20 Aug 2020 15:06:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' [20 Aug 2020 15:06:22] (index) database connection response [20 Aug 2020 15:06:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200338801' AND ACCESS_CODE = '09456418' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 15:06:22] (index) database connection response [20 Aug 2020 15:06:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000608815' [20 Aug 2020 15:06:22] (index) database connection response [20 Aug 2020 15:06:22] (index) getPatientReportsDetail() entered [20 Aug 2020 15:06:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:06:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200338801', 'M0100000608815', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 15:06:22] (index) p_Stop=N [20 Aug 2020 15:06:22] (index) p_Alert= [20 Aug 2020 15:06: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 Aug 2020 15:06:22] (index) database connection response [20 Aug 2020 15:06:22] (index) getConnectionClose() called.... [20 Aug 2020 19:12:47] (index) database connection response [20 Aug 2020 19:12:47] (index) getConnection(): Resource id #1 [20 Aug 2020 19:12:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 19:12:47] (index) database connection response [20 Aug 2020 19:12:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 19:12:47] (index) database connection response [20 Aug 2020 19:12:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 19:12:48] (index) database connection response [20 Aug 2020 19:12:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200337662' AND ACCESS_CODE = '08081437' [20 Aug 2020 19:12:48] (index) database connection response [20 Aug 2020 19:12:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200337662' AND ACCESS_CODE = '08081437' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 19:12:48] (index) database connection response [20 Aug 2020 19:12:48] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000610754' [20 Aug 2020 19:12:48] (index) database connection response [20 Aug 2020 19:12:48] (index) getPatientReportsDetail() entered [20 Aug 2020 19:12:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200337662', 'M0100000610754', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:12:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200337662', 'M0100000610754', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:12:48] (index) p_Stop=N [20 Aug 2020 19:12:48] (index) p_Alert= [20 Aug 2020 19:12:48] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [20 Aug 2020 19:12:48] (index) database connection response [20 Aug 2020 19:12:48] (index) getConnectionClose() called.... [20 Aug 2020 19:12:48] (index) getConnectionClose() called.... [20 Aug 2020 19:13:05] (viewOnlineReports) database connection response [20 Aug 2020 19:13:05] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 19:13:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000610754', '001', '200373262', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:13:05] (viewOnlineReports) p_Stop=N [20 Aug 2020 19:13:05] (viewOnlineReports) p_Alert= [20 Aug 2020 19:13:05] (viewOnlineReports) Flag = 1 [20 Aug 2020 19:13:05] (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', '200373262', 'M01', '001', '1', '001000000000085025', 'M0100000610754_M01HEM20011162_1.PDF', 'M0100000610754', SYSDATE) [20 Aug 2020 19:13:06] (viewOnlineReports) database connection response [20 Aug 2020 19:13:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373262' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [20 Aug 2020 19:13:06] (viewOnlineReports) database connection response [20 Aug 2020 19:13:06] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 19:13:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373262/ [20 Aug 2020 19:13:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373262/ [20 Aug 2020 19:13:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200820\M01\M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373262/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597932785M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373262/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597932785M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Aug 2020 19:13:06] (viewOnlineReports) Converting PDF to JPG with name as M0100000610754_M01HEM20011162_1.jpg [20 Aug 2020 19:13:06] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200373262/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597932785M0100000610754_M01HEM20011162_1.PDF ../../TEMP_PDF/200373262/M0100000610754_M01HEM20011162_1.jpg [20 Aug 2020 19:13:06] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200373262/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597932785M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:15] (viewOnlineReports) database connection response [20 Aug 2020 19:13:15] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 19:13:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000610754', '001', '200373262', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:13:15] (viewOnlineReports) p_Stop=N [20 Aug 2020 19:13:15] (viewOnlineReports) p_Alert= [20 Aug 2020 19:13:15] (viewOnlineReports) Flag = 1 [20 Aug 2020 19:13: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', '200373262', 'M01', '001', '1', '001000000000085025', 'M0100000610754_M01HEM20011162_1.PDF', 'M0100000610754', SYSDATE) [20 Aug 2020 19:13:15] (viewOnlineReports) database connection response [20 Aug 2020 19:13:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373262' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [20 Aug 2020 19:13:15] (viewOnlineReports) database connection response [20 Aug 2020 19:13:15] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 19:13:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373262/ [20 Aug 2020 19:13:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373262/ [20 Aug 2020 19:13:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200820\M01\M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373262/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1597932795M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373262/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1597932795M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Aug 2020 19:13:15] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200373262/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1597932795M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:31] (viewOnlineReports) database connection response [20 Aug 2020 19:13:31] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 19:13:31] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000610754', '001', '200373262', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:13:31] (viewOnlineReports) p_Stop=N [20 Aug 2020 19:13:31] (viewOnlineReports) p_Alert= [20 Aug 2020 19:13:31] (viewOnlineReports) Flag = 1 [20 Aug 2020 19:13:31] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200373262', 'M01', '001', '1', '001000000000085025', 'M0100000610754_M01HEM20011162_1.PDF', 'M0100000610754', SYSDATE) [20 Aug 2020 19:13:31] (viewOnlineReports) database connection response [20 Aug 2020 19:13:31] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373262' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [20 Aug 2020 19:13:31] (viewOnlineReports) database connection response [20 Aug 2020 19:13:31] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 19:13:31] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373262/ [20 Aug 2020 19:13:31] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373262/ [20 Aug 2020 19:13:31] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200820\M01\M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:31] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1597932811M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:31] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1597932811M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:31] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [20 Aug 2020 19:13:31] (viewOnlineReports) Converting PDF to JPG with name as M0100000610754_M01HEM20011162_1.jpg [20 Aug 2020 19:13:31] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1597932811M0100000610754_M01HEM20011162_1.PDF ../../TEMP_PDF/200373262/M0100000610754_M01HEM20011162_1.jpg [20 Aug 2020 19:13:31] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1597932811M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:52] (viewOnlineReports) database connection response [20 Aug 2020 19:13:52] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 19:13:52] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000610754', '001', '200373262', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:13:52] (viewOnlineReports) p_Stop=N [20 Aug 2020 19:13:52] (viewOnlineReports) p_Alert= [20 Aug 2020 19:13:52] (viewOnlineReports) Flag = 1 [20 Aug 2020 19:13:52] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200373262', 'M01', '001', '1', '001000000000085025', 'M0100000610754_M01HEM20011162_1.PDF', 'M0100000610754', SYSDATE) [20 Aug 2020 19:13:52] (viewOnlineReports) database connection response [20 Aug 2020 19:13:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373262' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [20 Aug 2020 19:13:52] (viewOnlineReports) database connection response [20 Aug 2020 19:13:52] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 19:13:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373262/ [20 Aug 2020 19:13:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373262/ [20 Aug 2020 19:13:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200820\M01\M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1597932832M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1597932832M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:13:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [20 Aug 2020 19:13:52] (viewOnlineReports) Converting PDF to JPG with name as M0100000610754_M01HEM20011162_1.jpg [20 Aug 2020 19:13:52] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1597932832M0100000610754_M01HEM20011162_1.PDF ../../TEMP_PDF/200373262/M0100000610754_M01HEM20011162_1.jpg [20 Aug 2020 19:13:52] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1597932832M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:14:12] (viewOnlineReports) database connection response [20 Aug 2020 19:14:12] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 19:14:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000610754', '001', '200373262', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:14:12] (viewOnlineReports) p_Stop=N [20 Aug 2020 19:14:12] (viewOnlineReports) p_Alert= [20 Aug 2020 19:14:12] (viewOnlineReports) Flag = 1 [20 Aug 2020 19:14:12] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200373262', 'M01', '001', '1', '001000000000085025', 'M0100000610754_M01HEM20011162_1.PDF', 'M0100000610754', SYSDATE) [20 Aug 2020 19:14:12] (viewOnlineReports) database connection response [20 Aug 2020 19:14:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373262' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [20 Aug 2020 19:14:12] (viewOnlineReports) database connection response [20 Aug 2020 19:14:12] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 19:14:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373262/ [20 Aug 2020 19:14:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373262/ [20 Aug 2020 19:14:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200820\M01\M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:14:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373262/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1597932852M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:14:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373262/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1597932852M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:14:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 19:14:12] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373262/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1597932852M0100000610754_M01HEM20011162_1.PDF [20 Aug 2020 19:18:07] (viewOnlineReports) database connection response [20 Aug 2020 19:18:07] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 19:18:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000610754', '001', '200373262', '3', '001000000000086287', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:18:07] (viewOnlineReports) p_Stop=N [20 Aug 2020 19:18:07] (viewOnlineReports) p_Alert= [20 Aug 2020 19:18:07] (viewOnlineReports) Flag = 1 [20 Aug 2020 19:18:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200373262', 'M01', '001', '3', '001000000000086287', 'M0100000610754_M01SCH20008351_1.PDF', 'M0100000610754', SYSDATE) [20 Aug 2020 19:18:07] (viewOnlineReports) database connection response [20 Aug 2020 19:18:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373262' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [20 Aug 2020 19:18:07] (viewOnlineReports) database connection response [20 Aug 2020 19:18:07] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 19:18:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373262/ [20 Aug 2020 19:18:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373262/ [20 Aug 2020 19:18:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000610754_M01SCH20008351_1.PDF [20 Aug 2020 19:18:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1597933087M0100000610754_M01SCH20008351_1.PDF [20 Aug 2020 19:18:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1597933087M0100000610754_M01SCH20008351_1.PDF [20 Aug 2020 19:18:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 19:18:07] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1597933087M0100000610754_M01SCH20008351_1.PDF [20 Aug 2020 19:18:24] (viewOnlineReports) database connection response [20 Aug 2020 19:18:24] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 19:18:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000610754', '001', '200373262', '4', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:18:24] (viewOnlineReports) p_Stop=N [20 Aug 2020 19:18:24] (viewOnlineReports) p_Alert= [20 Aug 2020 19:18:24] (viewOnlineReports) Flag = 1 [20 Aug 2020 19:18: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', '200373262', 'M01', '001', '4', '001000000000086302', 'M0100000610754_M01SCH20008351_2.PDF', 'M0100000610754', SYSDATE) [20 Aug 2020 19:18:24] (viewOnlineReports) database connection response [20 Aug 2020 19:18:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373262' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '4' [20 Aug 2020 19:18:24] (viewOnlineReports) database connection response [20 Aug 2020 19:18:24] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 19:18:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373262/ [20 Aug 2020 19:18:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373262/ [20 Aug 2020 19:18:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200819\M01\M0100000610754_M01SCH20008351_2.PDF [20 Aug 2020 19:18:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1597933104M0100000610754_M01SCH20008351_2.PDF [20 Aug 2020 19:18:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1597933104M0100000610754_M01SCH20008351_2.PDF [20 Aug 2020 19:18:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 19:18:24] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373262/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1597933104M0100000610754_M01SCH20008351_2.PDF [20 Aug 2020 19:18:32] (viewOnlineReports) database connection response [20 Aug 2020 19:18:32] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 19:18:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000610754', '001', '200373262', '2', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 19:18:32] (viewOnlineReports) p_Stop=N [20 Aug 2020 19:18:32] (viewOnlineReports) p_Alert= [20 Aug 2020 19:18:32] (viewOnlineReports) Flag = 1 [20 Aug 2020 19:18: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', '200373262', 'M01', '001', '2', '001000000000087630', 'M0100000610754_M01MOL20007245_1.PDF', 'M0100000610754', SYSDATE) [20 Aug 2020 19:18:32] (viewOnlineReports) database connection response [20 Aug 2020 19:18:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373262' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [20 Aug 2020 19:18:32] (viewOnlineReports) database connection response [20 Aug 2020 19:18:32] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 19:18:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373262/ [20 Aug 2020 19:18:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373262/ [20 Aug 2020 19:18:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200820\M01\M0100000610754_M01MOL20007245_1.PDF [20 Aug 2020 19:18:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373262/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597933112M0100000610754_M01MOL20007245_1.PDF [20 Aug 2020 19:18:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373262/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597933112M0100000610754_M01MOL20007245_1.PDF [20 Aug 2020 19:18:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [20 Aug 2020 19:18:32] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200373262/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1597933112M0100000610754_M01MOL20007245_1.PDF [20 Aug 2020 22:54:32] (index) database connection response [20 Aug 2020 22:54:32] (index) getConnection(): Resource id #2 [20 Aug 2020 22:54:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 22:54:32] (index) database connection response [20 Aug 2020 22:54:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 22:54:32] (index) database connection response [20 Aug 2020 22:54:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 22:54:32] (index) database connection response [20 Aug 2020 22:54:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200339646' AND ACCESS_CODE = '44118042' [20 Aug 2020 22:54:32] (index) database connection response [20 Aug 2020 22:54:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200339646' AND ACCESS_CODE = '44118042' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 22:54:32] (index) database connection response [20 Aug 2020 22:54:32] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000607617' [20 Aug 2020 22:54:32] (index) database connection response [20 Aug 2020 22:54:32] (index) getPatientReportsDetail() entered [20 Aug 2020 22:54:32] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200339646', 'M0100000607617', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 22:54:32] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200339646', 'M0100000607617', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 22:54:32] (index) p_Stop=N [20 Aug 2020 22:54:32] (index) p_Alert= [20 Aug 2020 22:54: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 Aug 2020 22:54:32] (index) database connection response [20 Aug 2020 22:54:32] (index) getConnectionClose() called.... [20 Aug 2020 22:54:32] (index) getConnectionClose() called.... [20 Aug 2020 22:58:53] (index) database connection response [20 Aug 2020 22:58:53] (index) getConnection(): Resource id #1 [20 Aug 2020 22:58:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [20 Aug 2020 22:58:53] (index) database connection response [20 Aug 2020 22:58:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [20 Aug 2020 22:58:53] (index) database connection response [20 Aug 2020 22:58:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [20 Aug 2020 22:58:53] (index) database connection response [20 Aug 2020 22:58:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200339646' AND ACCESS_CODE = '44118042' [20 Aug 2020 22:58:53] (index) database connection response [20 Aug 2020 22:58:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200339646' AND ACCESS_CODE = '44118042' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [20 Aug 2020 22:58:53] (index) database connection response [20 Aug 2020 22:58:53] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000607617' [20 Aug 2020 22:58:53] (index) database connection response [20 Aug 2020 22:58:53] (index) getPatientReportsDetail() entered [20 Aug 2020 22:58:53] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200339646', 'M0100000607617', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 22:58:53] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200339646', 'M0100000607617', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 22:58:53] (index) p_Stop=N [20 Aug 2020 22:58:53] (index) p_Alert= [20 Aug 2020 22:58: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 Aug 2020 22:58:53] (index) database connection response [20 Aug 2020 22:58:53] (index) getConnectionClose() called.... [20 Aug 2020 22:58:53] (index) getConnectionClose() called.... [20 Aug 2020 22:59:08] (viewOnlineReports) database connection response [20 Aug 2020 22:59:08] (viewOnlineReports) getConnection(): Resource id #1 [20 Aug 2020 22:59:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000607617', '001', '200373884', '1', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [20 Aug 2020 22:59:08] (viewOnlineReports) p_Stop=N [20 Aug 2020 22:59:08] (viewOnlineReports) p_Alert= [20 Aug 2020 22:59:08] (viewOnlineReports) Flag = 1 [20 Aug 2020 22:59: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', '200373884', 'M01', '001', '1', '001000000000087100', 'M0100000607617_M01MIC20005990_1.PDF', 'M0100000607617', SYSDATE) [20 Aug 2020 22:59:08] (viewOnlineReports) database connection response [20 Aug 2020 22:59:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200373884' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [20 Aug 2020 22:59:08] (viewOnlineReports) database connection response [20 Aug 2020 22:59:08] (viewOnlineReports) getConnectionClose() called.... [20 Aug 2020 22:59:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200373884/ [20 Aug 2020 22:59:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200373884/ [20 Aug 2020 22:59:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200820\M01\M0100000607617_M01MIC20005990_1.PDF [20 Aug 2020 22:59:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200373884/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1597946348M0100000607617_M01MIC20005990_1.PDF [20 Aug 2020 22:59:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200373884/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1597946348M0100000607617_M01MIC20005990_1.PDF [20 Aug 2020 22:59:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [20 Aug 2020 22:59:08] (viewOnlineReports) Downloading file ../../TEMP_PDF/200373884/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1597946348M0100000607617_M01MIC20005990_1.PDF