[27 Aug 2020 00:01:16] (index) database connection response [27 Aug 2020 00:01:16] (index) getConnection(): Resource id #1 [27 Aug 2020 00:01:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 00:01:16] (index) database connection response [27 Aug 2020 00:01:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 00:01:16] (index) database connection response [27 Aug 2020 00:01:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 00:01:16] (index) database connection response [27 Aug 2020 00:01:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348299' AND ACCESS_CODE = '12145043' [27 Aug 2020 00:01:16] (index) database connection response [27 Aug 2020 00:01:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348299' AND ACCESS_CODE = '12145043' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 00:01:16] (index) database connection response [27 Aug 2020 00:01:16] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000536078' [27 Aug 2020 00:01:16] (index) database connection response [27 Aug 2020 00:01:16] (index) getPatientReportsDetail() entered [27 Aug 2020 00:01:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348299', 'M0100000536078', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 00:01:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348299', 'M0100000536078', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 00:01:16] (index) p_Stop=N [27 Aug 2020 00:01:16] (index) p_Alert= [27 Aug 2020 00:01:16] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [27 Aug 2020 00:01:16] (index) database connection response [27 Aug 2020 00:01:16] (index) getConnectionClose() called.... [27 Aug 2020 00:01:16] (index) getConnectionClose() called.... [27 Aug 2020 00:07:28] (index) database connection response [27 Aug 2020 00:07:28] (index) getConnection(): Resource id #1 [27 Aug 2020 00:07:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 00:07:28] (index) database connection response [27 Aug 2020 00:07:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 00:07:28] (index) database connection response [27 Aug 2020 00:07:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 00:07:28] (index) database connection response [27 Aug 2020 00:07:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348299' AND ACCESS_CODE = '12145043' [27 Aug 2020 00:07:28] (index) database connection response [27 Aug 2020 00:07:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348299' AND ACCESS_CODE = '12145043' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 00:07:28] (index) database connection response [27 Aug 2020 00:07:28] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000536078' [27 Aug 2020 00:07:28] (index) database connection response [27 Aug 2020 00:07:28] (index) getPatientReportsDetail() entered [27 Aug 2020 00:07:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348299', 'M0100000536078', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 00:07:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348299', 'M0100000536078', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 00:07:28] (index) p_Stop=N [27 Aug 2020 00:07:28] (index) p_Alert= [27 Aug 2020 00:07:28] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [27 Aug 2020 00:07:28] (index) database connection response [27 Aug 2020 00:07:28] (index) getConnectionClose() called.... [27 Aug 2020 00:07:28] (index) getConnectionClose() called.... [27 Aug 2020 00:12:57] (index) database connection response [27 Aug 2020 00:12:57] (index) getConnection(): Resource id #1 [27 Aug 2020 00:12:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 00:12:57] (index) database connection response [27 Aug 2020 00:12:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 00:12:57] (index) database connection response [27 Aug 2020 00:12:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 00:12:57] (index) database connection response [27 Aug 2020 00:12:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348299' AND ACCESS_CODE = '12145043' [27 Aug 2020 00:12:57] (index) database connection response [27 Aug 2020 00:12:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348299' AND ACCESS_CODE = '12145043' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 00:12:57] (index) database connection response [27 Aug 2020 00:12:57] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000536078' [27 Aug 2020 00:12:57] (index) database connection response [27 Aug 2020 00:12:57] (index) getPatientReportsDetail() entered [27 Aug 2020 00:12:57] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348299', 'M0100000536078', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 00:12:57] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348299', 'M0100000536078', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 00:12:57] (index) p_Stop=N [27 Aug 2020 00:12:57] (index) p_Alert= [27 Aug 2020 00:12:57] (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 [27 Aug 2020 00:12:57] (index) database connection response [27 Aug 2020 00:12:57] (index) getConnectionClose() called.... [27 Aug 2020 00:12:57] (index) getConnectionClose() called.... [27 Aug 2020 00:20:21] (index) database connection response [27 Aug 2020 00:20:21] (index) getConnection(): Resource id #1 [27 Aug 2020 00:20:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 00:20:21] (index) database connection response [27 Aug 2020 00:20:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 00:20:21] (index) database connection response [27 Aug 2020 00:20:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 00:20:21] (index) database connection response [27 Aug 2020 00:20:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348299' AND ACCESS_CODE = '12145043' [27 Aug 2020 00:20:21] (index) database connection response [27 Aug 2020 00:20:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348299' AND ACCESS_CODE = '12145043' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 00:20:21] (index) database connection response [27 Aug 2020 00:20:21] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000536078' [27 Aug 2020 00:20:21] (index) database connection response [27 Aug 2020 00:20:21] (index) getPatientReportsDetail() entered [27 Aug 2020 00:20:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348299', 'M0100000536078', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 00:20:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348299', 'M0100000536078', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 00:20:21] (index) p_Stop=N [27 Aug 2020 00:20:21] (index) p_Alert= [27 Aug 2020 00:20:21] (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 [27 Aug 2020 00:20:21] (index) database connection response [27 Aug 2020 00:20:21] (index) getConnectionClose() called.... [27 Aug 2020 00:20:21] (index) getConnectionClose() called.... [27 Aug 2020 13:00:12] (index) database connection response [27 Aug 2020 13:00:12] (index) getConnection(): Resource id #1 [27 Aug 2020 13:00:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 13:00:12] (index) database connection response [27 Aug 2020 13:00:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 13:00:12] (index) database connection response [27 Aug 2020 13:00:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 13:00:12] (index) database connection response [27 Aug 2020 13:00:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200345297' AND ACCESS_CODE = '97676828' [27 Aug 2020 13:00:13] (index) database connection response [27 Aug 2020 13:00:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200345297' AND ACCESS_CODE = '97676828' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 13:00:13] (index) database connection response [27 Aug 2020 13:00:13] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000603502' [27 Aug 2020 13:00:13] (index) database connection response [27 Aug 2020 13:00:13] (index) getPatientReportsDetail() entered [27 Aug 2020 13:00:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200345297', 'M0100000603502', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 13:00:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200345297', 'M0100000603502', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 13:00:13] (index) p_Stop=N [27 Aug 2020 13:00:13] (index) p_Alert= [27 Aug 2020 13:00:13] (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 [27 Aug 2020 13:00:13] (index) database connection response [27 Aug 2020 13:00:13] (index) getConnectionClose() called.... [27 Aug 2020 13:00:13] (index) getConnectionClose() called.... [27 Aug 2020 15:00:14] (index) database connection response [27 Aug 2020 15:00:14] (index) getConnection(): Resource id #2 [27 Aug 2020 15:00:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '49' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 15:00:14] (index) database connection response [27 Aug 2020 15:00:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '49' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 15:00:14] (index) database connection response [27 Aug 2020 15:00:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '49' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 15:00:14] (index) database connection response [27 Aug 2020 15:00:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200347776' AND ACCESS_CODE = '37064257' [27 Aug 2020 15:00:14] (index) database connection response [27 Aug 2020 15:00:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200347776' AND ACCESS_CODE = '37064257' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 15:00:14] (index) database connection response [27 Aug 2020 15:00:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000048239' [27 Aug 2020 15:00:14] (index) database connection response [27 Aug 2020 15:00:14] (index) getPatientReportsDetail() entered [27 Aug 2020 15:00:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200347776', 'M0100000048239', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:00:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200347776', 'M0100000048239', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:00:15] (index) p_Stop=N [27 Aug 2020 15:00:15] (index) p_Alert= [27 Aug 2020 15:00:15] (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 [27 Aug 2020 15:00:15] (index) database connection response [27 Aug 2020 15:00:15] (index) getConnectionClose() called.... [27 Aug 2020 15:00:15] (index) getConnectionClose() called.... [27 Aug 2020 15:00:47] (viewOnlineReports) database connection response [27 Aug 2020 15:00:47] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:00:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000048239', '001', '200375979', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:00:47] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:00:47] (viewOnlineReports) p_Alert= [27 Aug 2020 15:00:47] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:00: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', '200375979', 'M01', '001', '1', '001000000000085025', 'M0100000048239_M01HEM20011518_1.PDF', 'M0100000048239', SYSDATE) [27 Aug 2020 15:00:47] (viewOnlineReports) database connection response [27 Aug 2020 15:00:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200375979' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [27 Aug 2020 15:00:47] (viewOnlineReports) database connection response [27 Aug 2020 15:00:47] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:00:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200375979/ [27 Aug 2020 15:00:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200375979/ [27 Aug 2020 15:00:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200826\M01\M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:00:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200375979/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598522447M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:00:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200375979/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598522447M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:00:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:00:47] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200375979/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598522447M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:00:58] (viewOnlineReports) database connection response [27 Aug 2020 15:00:58] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:00:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000048239', '001', '200375979', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:00:58] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:00:58] (viewOnlineReports) p_Alert= [27 Aug 2020 15:00:58] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:00: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', '200375979', 'M01', '001', '1', '001000000000085025', 'M0100000048239_M01HEM20011518_1.PDF', 'M0100000048239', SYSDATE) [27 Aug 2020 15:00:58] (viewOnlineReports) database connection response [27 Aug 2020 15:00:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200375979' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [27 Aug 2020 15:00:58] (viewOnlineReports) database connection response [27 Aug 2020 15:00:58] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:00:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200375979/ [27 Aug 2020 15:00:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200375979/ [27 Aug 2020 15:00:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200826\M01\M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:00:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200375979/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522458M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:00:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200375979/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522458M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:00:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:00:58] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200375979/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522458M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:01:18] (viewOnlineReports) database connection response [27 Aug 2020 15:01:18] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:01:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000048239', '001', '200375979', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:01:18] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:01:18] (viewOnlineReports) p_Alert= [27 Aug 2020 15:01:18] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:01: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', '200375979', 'M01', '001', '3', '001000000000082047', 'M0100000048239_M01RCH20015578_2.PDF', 'M0100000048239', SYSDATE) [27 Aug 2020 15:01:18] (viewOnlineReports) database connection response [27 Aug 2020 15:01:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200375979' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [27 Aug 2020 15:01:18] (viewOnlineReports) database connection response [27 Aug 2020 15:01:18] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:01:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200826\M01\M0100000048239_M01RCH20015578_2.PDF [27 Aug 2020 15:01:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200375979/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522478M0100000048239_M01RCH20015578_2.PDF [27 Aug 2020 15:01:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200375979/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522478M0100000048239_M01RCH20015578_2.PDF [27 Aug 2020 15:01:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:01:18] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200375979/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522478M0100000048239_M01RCH20015578_2.PDF [27 Aug 2020 15:01:28] (viewOnlineReports) database connection response [27 Aug 2020 15:01:28] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:01:28] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000048239', '001', '200375979', '2', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:01:28] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:01:28] (viewOnlineReports) p_Alert= [27 Aug 2020 15:01:28] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:01:28] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200375979', 'M01', '001', '2', '001000000000081028', 'M0100000048239_M01RCH20015578_1.PDF', 'M0100000048239', SYSDATE) [27 Aug 2020 15:01:28] (viewOnlineReports) database connection response [27 Aug 2020 15:01:28] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200375979' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [27 Aug 2020 15:01:28] (viewOnlineReports) database connection response [27 Aug 2020 15:01:28] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:01:28] (viewOnlineReports) creating directory structure../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:28] (viewOnlineReports) directory structure created ../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:28] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200826\M01\M0100000048239_M01RCH20015578_1.PDF [27 Aug 2020 15:01:28] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200375979/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522488M0100000048239_M01RCH20015578_1.PDF [27 Aug 2020 15:01:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200375979/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522488M0100000048239_M01RCH20015578_1.PDF [27 Aug 2020 15:01:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:01:28] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200375979/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598522488M0100000048239_M01RCH20015578_1.PDF [27 Aug 2020 15:01:38] (viewOnlineReports) database connection response [27 Aug 2020 15:01:38] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:01:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000048239', '001', '200375979', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:01:38] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:01:38] (viewOnlineReports) p_Alert= [27 Aug 2020 15:01:38] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:01: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', '200375979', 'M01', '001', '1', '001000000000085025', 'M0100000048239_M01HEM20011518_1.PDF', 'M0100000048239', SYSDATE) [27 Aug 2020 15:01:38] (viewOnlineReports) database connection response [27 Aug 2020 15:01:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200375979' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [27 Aug 2020 15:01:38] (viewOnlineReports) database connection response [27 Aug 2020 15:01:38] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:01:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200826\M01\M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:01:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200375979/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598522498M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:01:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200375979/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598522498M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:01:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 15:01:38] (viewOnlineReports) Downloading file ../../TEMP_PDF/200375979/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598522498M0100000048239_M01HEM20011518_1.PDF [27 Aug 2020 15:01:47] (viewOnlineReports) database connection response [27 Aug 2020 15:01:47] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:01:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000048239', '001', '200375979', '2', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:01:47] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:01:47] (viewOnlineReports) p_Alert= [27 Aug 2020 15:01:47] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:01: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', '200375979', 'M01', '001', '2', '001000000000081028', 'M0100000048239_M01RCH20015578_1.PDF', 'M0100000048239', SYSDATE) [27 Aug 2020 15:01:47] (viewOnlineReports) database connection response [27 Aug 2020 15:01:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200375979' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [27 Aug 2020 15:01:47] (viewOnlineReports) database connection response [27 Aug 2020 15:01:47] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:01:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200826\M01\M0100000048239_M01RCH20015578_1.PDF [27 Aug 2020 15:01:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200375979/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1598522507M0100000048239_M01RCH20015578_1.PDF [27 Aug 2020 15:01:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200375979/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1598522507M0100000048239_M01RCH20015578_1.PDF [27 Aug 2020 15:01:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 15:01:47] (viewOnlineReports) Downloading file ../../TEMP_PDF/200375979/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1598522507M0100000048239_M01RCH20015578_1.PDF [27 Aug 2020 15:01:50] (viewOnlineReports) database connection response [27 Aug 2020 15:01:50] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:01:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000048239', '001', '200375979', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:01:50] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:01:50] (viewOnlineReports) p_Alert= [27 Aug 2020 15:01:50] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:01: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', '200375979', 'M01', '001', '3', '001000000000082047', 'M0100000048239_M01RCH20015578_2.PDF', 'M0100000048239', SYSDATE) [27 Aug 2020 15:01:50] (viewOnlineReports) database connection response [27 Aug 2020 15:01:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200375979' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [27 Aug 2020 15:01:50] (viewOnlineReports) database connection response [27 Aug 2020 15:01:50] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:01:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200375979/ [27 Aug 2020 15:01:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200826\M01\M0100000048239_M01RCH20015578_2.PDF [27 Aug 2020 15:01:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200375979/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1598522510M0100000048239_M01RCH20015578_2.PDF [27 Aug 2020 15:01:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200375979/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1598522510M0100000048239_M01RCH20015578_2.PDF [27 Aug 2020 15:01:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 15:01:50] (viewOnlineReports) Downloading file ../../TEMP_PDF/200375979/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1598522510M0100000048239_M01RCH20015578_2.PDF [27 Aug 2020 15:54:55] (index) database connection response [27 Aug 2020 15:54:55] (index) getConnection(): Resource id #1 [27 Aug 2020 15:54:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 15:54:55] (index) database connection response [27 Aug 2020 15:54:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 15:54:55] (index) database connection response [27 Aug 2020 15:54:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 15:54:55] (index) database connection response [27 Aug 2020 15:54:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' [27 Aug 2020 15:54:55] (index) database connection response [27 Aug 2020 15:54:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 15:54:55] (index) database connection response [27 Aug 2020 15:54:55] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000593995' [27 Aug 2020 15:54:55] (index) database connection response [27 Aug 2020 15:54:55] (index) getPatientReportsDetail() entered [27 Aug 2020 15:54:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:54:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:54:56] (index) p_Stop=N [27 Aug 2020 15:54:56] (index) p_Alert= [27 Aug 2020 15:54:56] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [27 Aug 2020 15:54:56] (index) database connection response [27 Aug 2020 15:54:56] (index) getConnectionClose() called.... [27 Aug 2020 15:54:56] (index) getConnectionClose() called.... [27 Aug 2020 15:55:05] (viewOnlineReports) database connection response [27 Aug 2020 15:55:05] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:55:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '5', '001000000000086707', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:55:05] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:55:05] (viewOnlineReports) p_Alert= [27 Aug 2020 15:55:05] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:55: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', '200376613', 'M01', '001', '5', '001000000000086707', 'M0100000593995_M01MIC20006219_3.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:55:05] (viewOnlineReports) database connection response [27 Aug 2020 15:55:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '5' [27 Aug 2020 15:55:05] (viewOnlineReports) database connection response [27 Aug 2020 15:55:05] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:55:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1598525705M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1598525705M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 15:55:05] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376613/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1598525705M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:07] (viewOnlineReports) database connection response [27 Aug 2020 15:55:07] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:55:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '5', '001000000000086707', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:55:07] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:55:07] (viewOnlineReports) p_Alert= [27 Aug 2020 15:55:07] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:55: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', '200376613', 'M01', '001', '5', '001000000000086707', 'M0100000593995_M01MIC20006219_3.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:55:07] (viewOnlineReports) database connection response [27 Aug 2020 15:55:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '5' [27 Aug 2020 15:55:07] (viewOnlineReports) database connection response [27 Aug 2020 15:55:07] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:55:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1598525707M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1598525707M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 15:55:07] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1598525707M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:07] (viewOnlineReports) database connection response [27 Aug 2020 15:55:07] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:55:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '5', '001000000000086707', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:55:07] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:55:07] (viewOnlineReports) p_Alert= [27 Aug 2020 15:55:07] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:55: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', '200376613', 'M01', '001', '5', '001000000000086707', 'M0100000593995_M01MIC20006219_3.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:55:07] (viewOnlineReports) database connection response [27 Aug 2020 15:55:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '5' [27 Aug 2020 15:55:07] (viewOnlineReports) database connection response [27 Aug 2020 15:55:07] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:55:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598525707M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598525707M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 15:55:07] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598525707M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:55:34] (viewOnlineReports) database connection response [27 Aug 2020 15:55:34] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:55:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '4', '001000000000081256', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:55:34] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:55:34] (viewOnlineReports) p_Alert= [27 Aug 2020 15:55:34] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:55:34] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376613', 'M01', '001', '4', '001000000000081256', 'M0100000593995_M01MIC20006219_1.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:55:34] (viewOnlineReports) database connection response [27 Aug 2020 15:55:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '4' [27 Aug 2020 15:55:34] (viewOnlineReports) database connection response [27 Aug 2020 15:55:34] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:55:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_1.PDF [27 Aug 2020 15:55:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1598525734M0100000593995_M01MIC20006219_1.PDF [27 Aug 2020 15:55:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1598525734M0100000593995_M01MIC20006219_1.PDF [27 Aug 2020 15:55:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:55:34] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1598525734M0100000593995_M01MIC20006219_1.PDF [27 Aug 2020 15:55:50] (viewOnlineReports) database connection response [27 Aug 2020 15:55:50] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:55:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '6', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:55:50] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:55:50] (viewOnlineReports) p_Alert= [27 Aug 2020 15:55:50] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:55: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', '200376613', 'M01', '001', '6', '001000000000086354', 'M0100000593995_M01MIC20006219_2.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:55:50] (viewOnlineReports) database connection response [27 Aug 2020 15:55:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '6' [27 Aug 2020 15:55:50] (viewOnlineReports) database connection response [27 Aug 2020 15:55:50] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:55:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:55:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:55:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525750M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:55:51] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525750M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:55:51] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:55:51] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525750M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:56:20] (viewOnlineReports) database connection response [27 Aug 2020 15:56:20] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:56:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '6', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:56:20] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:56:20] (viewOnlineReports) p_Alert= [27 Aug 2020 15:56:20] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:56: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', '200376613', 'M01', '001', '6', '001000000000086354', 'M0100000593995_M01MIC20006219_2.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:56:20] (viewOnlineReports) database connection response [27 Aug 2020 15:56:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '6' [27 Aug 2020 15:56:20] (viewOnlineReports) database connection response [27 Aug 2020 15:56:20] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:56:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:56:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:56:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:56:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525780M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:56:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525780M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:56:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:56:20] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525780M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:56:50] (viewOnlineReports) database connection response [27 Aug 2020 15:56:50] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:56:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '5', '001000000000086707', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:56:50] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:56:50] (viewOnlineReports) p_Alert= [27 Aug 2020 15:56:50] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:56: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', '200376613', 'M01', '001', '5', '001000000000086707', 'M0100000593995_M01MIC20006219_3.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:56:50] (viewOnlineReports) database connection response [27 Aug 2020 15:56:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '5' [27 Aug 2020 15:56:50] (viewOnlineReports) database connection response [27 Aug 2020 15:56:50] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:56:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:56:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:56:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:56:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598525810M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:56:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598525810M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:56:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:56:50] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598525810M0100000593995_M01MIC20006219_3.PDF [27 Aug 2020 15:57:06] (viewOnlineReports) database connection response [27 Aug 2020 15:57:06] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:57:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '4', '001000000000081256', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:57:06] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:57:06] (viewOnlineReports) p_Alert= [27 Aug 2020 15:57:06] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:57:06] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376613', 'M01', '001', '4', '001000000000081256', 'M0100000593995_M01MIC20006219_1.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:57:06] (viewOnlineReports) database connection response [27 Aug 2020 15:57:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '4' [27 Aug 2020 15:57:06] (viewOnlineReports) database connection response [27 Aug 2020 15:57:06] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:57:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:57:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:57:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_1.PDF [27 Aug 2020 15:57:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525826M0100000593995_M01MIC20006219_1.PDF [27 Aug 2020 15:57:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525826M0100000593995_M01MIC20006219_1.PDF [27 Aug 2020 15:57:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:57:07] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525826M0100000593995_M01MIC20006219_1.PDF [27 Aug 2020 15:57:22] (viewOnlineReports) database connection response [27 Aug 2020 15:57:22] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:57:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:57:22] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:57:22] (viewOnlineReports) p_Alert= [27 Aug 2020 15:57:22] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:57:22] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376613', 'M01', '001', '3', '001000000000082047', 'M0100000593995_M01RCH20015692_1.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:57:22] (viewOnlineReports) database connection response [27 Aug 2020 15:57:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [27 Aug 2020 15:57:22] (viewOnlineReports) database connection response [27 Aug 2020 15:57:22] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:57:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:57:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:57:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01RCH20015692_1.PDF [27 Aug 2020 15:57:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525842M0100000593995_M01RCH20015692_1.PDF [27 Aug 2020 15:57:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525842M0100000593995_M01RCH20015692_1.PDF [27 Aug 2020 15:57:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:57:22] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1598525842M0100000593995_M01RCH20015692_1.PDF [27 Aug 2020 15:58:47] (viewOnlineReports) database connection response [27 Aug 2020 15:58:47] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 15:58:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '6', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 15:58:47] (viewOnlineReports) p_Stop=N [27 Aug 2020 15:58:47] (viewOnlineReports) p_Alert= [27 Aug 2020 15:58:47] (viewOnlineReports) Flag = 1 [27 Aug 2020 15:58: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', '200376613', 'M01', '001', '6', '001000000000086354', 'M0100000593995_M01MIC20006219_2.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 15:58:47] (viewOnlineReports) database connection response [27 Aug 2020 15:58:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '6' [27 Aug 2020 15:58:47] (viewOnlineReports) database connection response [27 Aug 2020 15:58:47] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 15:58:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 15:58:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 15:58:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:58:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1598525927M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:58:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1598525927M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 15:58:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 15:58:47] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1598525927M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 16:27:45] (viewOnlineReports) database connection response [27 Aug 2020 16:27:45] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 16:27:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '6', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 16:27:45] (viewOnlineReports) p_Stop=N [27 Aug 2020 16:27:45] (viewOnlineReports) p_Alert= [27 Aug 2020 16:27:45] (viewOnlineReports) Flag = 1 [27 Aug 2020 16:27:45] (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', '200376613', 'M01', '001', '6', '001000000000086354', 'M0100000593995_M01MIC20006219_2.PDF', 'M0100000593995', SYSDATE) [27 Aug 2020 16:27:45] (viewOnlineReports) database connection response [27 Aug 2020 16:27:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '6' [27 Aug 2020 16:27:45] (viewOnlineReports) database connection response [27 Aug 2020 16:27:45] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 16:27:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [27 Aug 2020 16:27:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [27 Aug 2020 16:27:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 16:27:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1598527665M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 16:27:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1598527665M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 16:27:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 16:27:45] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1598527665M0100000593995_M01MIC20006219_2.PDF [27 Aug 2020 17:21:58] (index) database connection response [27 Aug 2020 17:21:58] (index) getConnection(): Resource id #1 [27 Aug 2020 17:21:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 17:21:58] (index) database connection response [27 Aug 2020 17:21:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 17:21:58] (index) database connection response [27 Aug 2020 17:21:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 17:21:58] (index) database connection response [27 Aug 2020 17:21:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340654' AND ACCESS_CODE = '24511640' [27 Aug 2020 17:21:58] (index) database connection response [27 Aug 2020 17:21:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340654' AND ACCESS_CODE = '24511640' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 17:21:58] (index) database connection response [27 Aug 2020 17:21:58] (index) getConnectionClose() called.... [27 Aug 2020 17:23:33] (index) database connection response [27 Aug 2020 17:23:33] (index) getConnection(): Resource id #1 [27 Aug 2020 17:23:33] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 17:23:33] (index) database connection response [27 Aug 2020 17:23:33] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 17:23:33] (index) database connection response [27 Aug 2020 17:23:33] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 17:23:33] (index) database connection response [27 Aug 2020 17:23:33] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340054' AND ACCESS_CODE = '24511640' [27 Aug 2020 17:23:33] (index) database connection response [27 Aug 2020 17:23:33] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340054' AND ACCESS_CODE = '24511640' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 17:23:33] (index) database connection response [27 Aug 2020 17:23:33] (index) getConnectionClose() called.... [27 Aug 2020 17:26:14] (index) database connection response [27 Aug 2020 17:26:14] (index) getConnection(): Resource id #1 [27 Aug 2020 17:26:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 17:26:14] (index) database connection response [27 Aug 2020 17:26:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 17:26:14] (index) database connection response [27 Aug 2020 17:26:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 17:26:14] (index) database connection response [27 Aug 2020 17:26:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349988' AND ACCESS_CODE = '96821404' [27 Aug 2020 17:26:14] (index) database connection response [27 Aug 2020 17:26:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349988' AND ACCESS_CODE = '96821404' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 17:26:14] (index) database connection response [27 Aug 2020 17:26:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631174' [27 Aug 2020 17:26:14] (index) database connection response [27 Aug 2020 17:26:14] (index) getPatientReportsDetail() entered [27 Aug 2020 17:26:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349988', 'M0100000631174', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 17:26:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349988', 'M0100000631174', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 17:26:14] (index) p_Stop=N [27 Aug 2020 17:26:14] (index) p_Alert= [27 Aug 2020 17:26:14] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [27 Aug 2020 17:26:14] (index) database connection response [27 Aug 2020 17:26:14] (index) getConnectionClose() called.... [27 Aug 2020 17:26:14] (index) getConnectionClose() called.... [27 Aug 2020 17:26:27] (viewOnlineReports) database connection response [27 Aug 2020 17:26:27] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 17:26:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631174', '001', '200376638', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 17:26:27] (viewOnlineReports) p_Stop=N [27 Aug 2020 17:26:27] (viewOnlineReports) p_Alert= [27 Aug 2020 17:26:27] (viewOnlineReports) Flag = 1 [27 Aug 2020 17:26:27] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376638', 'M01', '047', '1', '001000000000085025', 'M0100000631174_M01HEM20011600_1.PDF', 'M0100000631174', SYSDATE) [27 Aug 2020 17:26:27] (viewOnlineReports) database connection response [27 Aug 2020 17:26:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376638' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 17:26:27] (viewOnlineReports) database connection response [27 Aug 2020 17:26:27] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 17:26:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376638/ [27 Aug 2020 17:26:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376638/ [27 Aug 2020 17:26:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631174_M01HEM20011600_1.PDF [27 Aug 2020 17:26:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376638/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1598531187M0100000631174_M01HEM20011600_1.PDF [27 Aug 2020 17:26:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376638/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1598531187M0100000631174_M01HEM20011600_1.PDF [27 Aug 2020 17:26:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 17:26:27] (viewOnlineReports) Converting PDF to JPG with name as M0100000631174_M01HEM20011600_1.jpg [27 Aug 2020 17:26:27] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376638/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1598531187M0100000631174_M01HEM20011600_1.PDF ../../TEMP_PDF/200376638/M0100000631174_M01HEM20011600_1.jpg [27 Aug 2020 17:26:27] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376638/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1598531187M0100000631174_M01HEM20011600_1.PDF [27 Aug 2020 17:27:25] (viewOnlineReports) database connection response [27 Aug 2020 17:27:25] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 17:27:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631174', '001', '200376638', '2', '001000000000083036', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 17:27:25] (viewOnlineReports) p_Stop=N [27 Aug 2020 17:27:25] (viewOnlineReports) p_Alert= [27 Aug 2020 17:27:25] (viewOnlineReports) Flag = 1 [27 Aug 2020 17:27: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', '200376638', 'M01', '047', '2', '001000000000083036', 'M0100000631174_M01RCH20015695_2.PDF', 'M0100000631174', SYSDATE) [27 Aug 2020 17:27:25] (viewOnlineReports) database connection response [27 Aug 2020 17:27:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376638' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [27 Aug 2020 17:27:25] (viewOnlineReports) database connection response [27 Aug 2020 17:27:25] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 17:27:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376638/ [27 Aug 2020 17:27:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376638/ [27 Aug 2020 17:27:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631174_M01RCH20015695_2.PDF [27 Aug 2020 17:27:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376638/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598531245M0100000631174_M01RCH20015695_2.PDF [27 Aug 2020 17:27:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376638/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598531245M0100000631174_M01RCH20015695_2.PDF [27 Aug 2020 17:27:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 17:27:25] (viewOnlineReports) Converting PDF to JPG with name as M0100000631174_M01RCH20015695_2.jpg [27 Aug 2020 17:27:25] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376638/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598531245M0100000631174_M01RCH20015695_2.PDF ../../TEMP_PDF/200376638/M0100000631174_M01RCH20015695_2.jpg [27 Aug 2020 17:27:25] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376638/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598531245M0100000631174_M01RCH20015695_2.PDF [27 Aug 2020 17:27:46] (viewOnlineReports) database connection response [27 Aug 2020 17:27:46] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 17:27:46] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631174', '001', '200376638', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 17:27:46] (viewOnlineReports) p_Stop=N [27 Aug 2020 17:27:46] (viewOnlineReports) p_Alert= [27 Aug 2020 17:27:46] (viewOnlineReports) Flag = 1 [27 Aug 2020 17:27: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', '200376638', 'M01', '047', '3', '001000000000087100', 'M0100000631174_M01MIC20006222_1.PDF', 'M0100000631174', SYSDATE) [27 Aug 2020 17:27:46] (viewOnlineReports) database connection response [27 Aug 2020 17:27:46] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376638' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 17:27:46] (viewOnlineReports) database connection response [27 Aug 2020 17:27:46] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 17:27:46] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376638/ [27 Aug 2020 17:27:46] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376638/ [27 Aug 2020 17:27:46] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631174_M01MIC20006222_1.PDF [27 Aug 2020 17:27:46] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376638/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598531266M0100000631174_M01MIC20006222_1.PDF [27 Aug 2020 17:27:46] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376638/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598531266M0100000631174_M01MIC20006222_1.PDF [27 Aug 2020 17:27:46] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 17:27:46] (viewOnlineReports) Converting PDF to JPG with name as M0100000631174_M01MIC20006222_1.jpg [27 Aug 2020 17:27:46] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376638/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598531266M0100000631174_M01MIC20006222_1.PDF ../../TEMP_PDF/200376638/M0100000631174_M01MIC20006222_1.jpg [27 Aug 2020 17:27:46] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376638/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598531266M0100000631174_M01MIC20006222_1.PDF [27 Aug 2020 17:29:10] (viewOnlineReports) database connection response [27 Aug 2020 17:29:10] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 17:29:10] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631174', '001', '200376638', '4', '001000000000081027', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 17:29:10] (viewOnlineReports) p_Stop=N [27 Aug 2020 17:29:10] (viewOnlineReports) p_Alert= [27 Aug 2020 17:29:10] (viewOnlineReports) Flag = 1 [27 Aug 2020 17: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', '200376638', 'M01', '047', '4', '001000000000081027', 'M0100000631174_M01RCH20015695_1.PDF', 'M0100000631174', SYSDATE) [27 Aug 2020 17:29:10] (viewOnlineReports) database connection response [27 Aug 2020 17:29:10] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376638' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [27 Aug 2020 17:29:10] (viewOnlineReports) database connection response [27 Aug 2020 17:29:10] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 17:29:10] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376638/ [27 Aug 2020 17:29:10] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376638/ [27 Aug 2020 17:29:10] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631174_M01RCH20015695_1.PDF [27 Aug 2020 17:29:10] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376638/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1598531350M0100000631174_M01RCH20015695_1.PDF [27 Aug 2020 17:29:10] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376638/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1598531350M0100000631174_M01RCH20015695_1.PDF [27 Aug 2020 17:29:10] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 17:29:10] (viewOnlineReports) Converting PDF to JPG with name as M0100000631174_M01RCH20015695_1.jpg [27 Aug 2020 17:29:10] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376638/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1598531350M0100000631174_M01RCH20015695_1.PDF ../../TEMP_PDF/200376638/M0100000631174_M01RCH20015695_1.jpg [27 Aug 2020 17:29:10] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376638/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1598531350M0100000631174_M01RCH20015695_1.PDF [27 Aug 2020 17:29:28] (viewOnlineReports) database connection response [27 Aug 2020 17:29:28] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 17:29:28] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631174', '001', '200376638', '5', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 17:29:28] (viewOnlineReports) p_Stop=N [27 Aug 2020 17:29:28] (viewOnlineReports) p_Alert= [27 Aug 2020 17:29:28] (viewOnlineReports) Flag = 1 [27 Aug 2020 17:29:28] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376638', 'M01', '047', '5', '001000000000084443', 'M0100000631174_M01SCH20008682_1.PDF', 'M0100000631174', SYSDATE) [27 Aug 2020 17:29:28] (viewOnlineReports) database connection response [27 Aug 2020 17:29:28] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376638' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [27 Aug 2020 17:29:28] (viewOnlineReports) database connection response [27 Aug 2020 17:29:28] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 17:29:28] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376638/ [27 Aug 2020 17:29:28] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376638/ [27 Aug 2020 17:29:28] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631174_M01SCH20008682_1.PDF [27 Aug 2020 17:29:28] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376638/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598531367M0100000631174_M01SCH20008682_1.PDF [27 Aug 2020 17:29:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376638/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598531367M0100000631174_M01SCH20008682_1.PDF [27 Aug 2020 17:29:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 17:29:28] (viewOnlineReports) Converting PDF to JPG with name as M0100000631174_M01SCH20008682_1.jpg [27 Aug 2020 17:29:28] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376638/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598531367M0100000631174_M01SCH20008682_1.PDF ../../TEMP_PDF/200376638/M0100000631174_M01SCH20008682_1.jpg [27 Aug 2020 17:29:28] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376638/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598531367M0100000631174_M01SCH20008682_1.PDF [27 Aug 2020 17:52:29] (index) database connection response [27 Aug 2020 17:52:29] (index) getConnection(): Resource id #1 [27 Aug 2020 17:52:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 17:52:29] (index) database connection response [27 Aug 2020 17:52:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 17:52:29] (index) database connection response [27 Aug 2020 17:52:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 17:52:29] (index) database connection response [27 Aug 2020 17:52:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '200376791' [27 Aug 2020 17:52:29] (index) database connection response [27 Aug 2020 17:52:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '200376791' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 17:52:29] (index) database connection response [27 Aug 2020 17:52:29] (index) getConnectionClose() called.... [27 Aug 2020 17:56:00] (index) database connection response [27 Aug 2020 17:56:00] (index) getConnection(): Resource id #1 [27 Aug 2020 17:56:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 17:56:00] (index) database connection response [27 Aug 2020 17:56:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 17:56:00] (index) database connection response [27 Aug 2020 17:56:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 17:56:00] (index) database connection response [27 Aug 2020 17:56:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '03119444088' [27 Aug 2020 17:56:00] (index) database connection response [27 Aug 2020 17:56:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '03119444088' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 17:56:00] (index) database connection response [27 Aug 2020 17:56:00] (index) getConnectionClose() called.... [27 Aug 2020 17:58:18] (index) database connection response [27 Aug 2020 17:58:18] (index) getConnection(): Resource id #1 [27 Aug 2020 17:58:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 17:58:18] (index) database connection response [27 Aug 2020 17:58:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 17:58:18] (index) database connection response [27 Aug 2020 17:58:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 17:58:18] (index) database connection response [27 Aug 2020 17:58:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350263' AND ACCESS_CODE = 'm01200264623' [27 Aug 2020 17:58:18] (index) database connection response [27 Aug 2020 17:58:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350263' AND ACCESS_CODE = 'm01200264623' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 17:58:18] (index) database connection response [27 Aug 2020 17:58:18] (index) getConnectionClose() called.... [27 Aug 2020 18:01:31] (index) database connection response [27 Aug 2020 18:01:31] (index) getConnection(): Resource id #1 [27 Aug 2020 18:01:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 18:01:31] (index) database connection response [27 Aug 2020 18:01:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 18:01:31] (index) database connection response [27 Aug 2020 18:01:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 18:01:31] (index) database connection response [27 Aug 2020 18:01:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '78846837' [27 Aug 2020 18:01:31] (index) database connection response [27 Aug 2020 18:01:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '78846837' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 18:01:31] (index) database connection response [27 Aug 2020 18:01:31] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631293' [27 Aug 2020 18:01:31] (index) database connection response [27 Aug 2020 18:01:31] (index) getPatientReportsDetail() entered [27 Aug 2020 18:01:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350409', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:01:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350409', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:01:31] (index) p_Stop=N [27 Aug 2020 18:01:31] (index) p_Alert= [27 Aug 2020 18:01:31] (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 [27 Aug 2020 18:01:31] (index) database connection response [27 Aug 2020 18:01:31] (index) getConnectionClose() called.... [27 Aug 2020 18:01:31] (index) getConnectionClose() called.... [27 Aug 2020 18:02:18] (index) database connection response [27 Aug 2020 18:02:18] (index) getConnection(): Resource id #1 [27 Aug 2020 18:02:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 18:02:18] (index) database connection response [27 Aug 2020 18:02:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 18:02:18] (index) database connection response [27 Aug 2020 18:02:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 18:02:18] (index) database connection response [27 Aug 2020 18:02:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350385' AND ACCESS_CODE = '15188420' [27 Aug 2020 18:02:18] (index) database connection response [27 Aug 2020 18:02:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350385' AND ACCESS_CODE = '15188420' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 18:02:18] (index) database connection response [27 Aug 2020 18:02:18] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631293' [27 Aug 2020 18:02:18] (index) database connection response [27 Aug 2020 18:02:18] (index) getPatientReportsDetail() entered [27 Aug 2020 18:02:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350385', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:02:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350385', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:02:18] (index) p_Stop=N [27 Aug 2020 18:02:18] (index) p_Alert= [27 Aug 2020 18:02: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 [27 Aug 2020 18:02:18] (index) database connection response [27 Aug 2020 18:02:18] (index) getConnectionClose() called.... [27 Aug 2020 18:02:18] (index) getConnectionClose() called.... [27 Aug 2020 18:09:49] (viewOnlineReports) database connection response [27 Aug 2020 18:09:49] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 18:09:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:09:49] (viewOnlineReports) p_Stop=N [27 Aug 2020 18:09:49] (viewOnlineReports) p_Alert= [27 Aug 2020 18:09:49] (viewOnlineReports) Flag = 1 [27 Aug 2020 18:09: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', '200376791', 'M01', '047', '3', '001000000000087100', 'M0100000631293_M01MIC20006236_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 18:09:49] (viewOnlineReports) database connection response [27 Aug 2020 18:09:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 18:09:49] (viewOnlineReports) database connection response [27 Aug 2020 18:09:49] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 18:09:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 18:09:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 18:09:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:09:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1598533789M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:09:49] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1598533789M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:09:49] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 18:09:49] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01MIC20006236_1.jpg [27 Aug 2020 18:09:49] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376791/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1598533789M0100000631293_M01MIC20006236_1.PDF ../../TEMP_PDF/200376791/M0100000631293_M01MIC20006236_1.jpg [27 Aug 2020 18:09:49] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376791/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1598533789M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:10:08] (viewOnlineReports) database connection response [27 Aug 2020 18:10:08] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 18:10:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:10:08] (viewOnlineReports) p_Stop=N [27 Aug 2020 18:10:08] (viewOnlineReports) p_Alert= [27 Aug 2020 18:10:08] (viewOnlineReports) Flag = 1 [27 Aug 2020 18:10: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', '200376791', 'M01', '047', '3', '001000000000087100', 'M0100000631293_M01MIC20006236_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 18:10:08] (viewOnlineReports) database connection response [27 Aug 2020 18:10:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 18:10:08] (viewOnlineReports) database connection response [27 Aug 2020 18:10:08] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 18:10:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 18:10:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 18:10:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:10:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598533808M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:10:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598533808M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:10:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 18:10:08] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376791/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598533808M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:10:26] (viewOnlineReports) database connection response [27 Aug 2020 18:10:26] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 18:10:26] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:10:26] (viewOnlineReports) p_Stop=N [27 Aug 2020 18:10:26] (viewOnlineReports) p_Alert= [27 Aug 2020 18:10:26] (viewOnlineReports) Flag = 1 [27 Aug 2020 18:10:26] (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', '200376791', 'M01', '047', '3', '001000000000087100', 'M0100000631293_M01MIC20006236_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 18:10:26] (viewOnlineReports) database connection response [27 Aug 2020 18:10:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 18:10:26] (viewOnlineReports) database connection response [27 Aug 2020 18:10:26] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 18:10:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 18:10:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 18:10:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:10:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598533826M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:10:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598533826M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:10:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 18:10:26] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376791/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598533826M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:11:11] (viewOnlineReports) database connection response [27 Aug 2020 18:11:11] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 18:11:11] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:11:11] (viewOnlineReports) p_Stop=N [27 Aug 2020 18:11:11] (viewOnlineReports) p_Alert= [27 Aug 2020 18:11:11] (viewOnlineReports) Flag = 1 [27 Aug 2020 18:11:11] (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', '200376791', 'M01', '047', '3', '001000000000087100', 'M0100000631293_M01MIC20006236_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 18:11:11] (viewOnlineReports) database connection response [27 Aug 2020 18:11:11] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 18:11:11] (viewOnlineReports) database connection response [27 Aug 2020 18:11:11] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 18:11:11] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 18:11:11] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 18:11:11] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:11:11] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598533871M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:11:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598533871M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:11:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 18:11:11] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376791/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1598533871M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:11:40] (viewOnlineReports) database connection response [27 Aug 2020 18:11:40] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 18:11:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:11:40] (viewOnlineReports) p_Stop=N [27 Aug 2020 18:11:40] (viewOnlineReports) p_Alert= [27 Aug 2020 18:11:40] (viewOnlineReports) Flag = 1 [27 Aug 2020 18:11:40] (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', '200376791', 'M01', '047', '3', '001000000000087100', 'M0100000631293_M01MIC20006236_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 18:11:40] (viewOnlineReports) database connection response [27 Aug 2020 18:11:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 18:11:40] (viewOnlineReports) database connection response [27 Aug 2020 18:11:40] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 18:11:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 18:11:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 18:11:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:11:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598533900M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:11:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598533900M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:11:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [27 Aug 2020 18:11:40] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01MIC20006236_1.jpg [27 Aug 2020 18:11:40] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376791/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598533900M0100000631293_M01MIC20006236_1.PDF ../../TEMP_PDF/200376791/M0100000631293_M01MIC20006236_1.jpg [27 Aug 2020 18:11:40] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376791/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598533900M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:13:40] (viewOnlineReports) database connection response [27 Aug 2020 18:13:40] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 18:13:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:13:40] (viewOnlineReports) p_Stop=N [27 Aug 2020 18:13:40] (viewOnlineReports) p_Alert= [27 Aug 2020 18:13:40] (viewOnlineReports) Flag = 1 [27 Aug 2020 18:13:40] (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', '200376791', 'M01', '047', '3', '001000000000087100', 'M0100000631293_M01MIC20006236_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 18:13:40] (viewOnlineReports) database connection response [27 Aug 2020 18:13:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 18:13:40] (viewOnlineReports) database connection response [27 Aug 2020 18:13:40] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 18:13:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 18:13:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 18:13:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:13:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1598534020M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:13:41] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1598534020M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:13:41] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [27 Aug 2020 18:13:41] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01MIC20006236_1.jpg [27 Aug 2020 18:13:41] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376791/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1598534020M0100000631293_M01MIC20006236_1.PDF ../../TEMP_PDF/200376791/M0100000631293_M01MIC20006236_1.jpg [27 Aug 2020 18:13:41] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376791/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1598534020M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 18:14:46] (index) database connection response [27 Aug 2020 18:14:46] (index) getConnection(): Resource id #1 [27 Aug 2020 18:14:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 18:14:46] (index) database connection response [27 Aug 2020 18:14:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 18:14:46] (index) database connection response [27 Aug 2020 18:14:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 18:14:46] (index) database connection response [27 Aug 2020 18:14:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350385' AND ACCESS_CODE = '15188420' [27 Aug 2020 18:14:46] (index) database connection response [27 Aug 2020 18:14:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350385' AND ACCESS_CODE = '15188420' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 18:14:46] (index) database connection response [27 Aug 2020 18:14:46] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631293' [27 Aug 2020 18:14:46] (index) database connection response [27 Aug 2020 18:14:46] (index) getPatientReportsDetail() entered [27 Aug 2020 18:14:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350385', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:14:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350385', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:14:46] (index) p_Stop=N [27 Aug 2020 18:14:46] (index) p_Alert= [27 Aug 2020 18:14:46] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [27 Aug 2020 18:14:46] (index) database connection response [27 Aug 2020 18:14:46] (index) getConnectionClose() called.... [27 Aug 2020 18:14:46] (index) getConnectionClose() called.... [27 Aug 2020 18:24:18] (index) database connection response [27 Aug 2020 18:24:18] (index) getConnection(): Resource id #1 [27 Aug 2020 18:24:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 18:24:18] (index) database connection response [27 Aug 2020 18:24:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 18:24:18] (index) database connection response [27 Aug 2020 18:24:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 18:24:18] (index) database connection response [27 Aug 2020 18:24:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200270805' AND ACCESS_CODE = '60724186' [27 Aug 2020 18:24:18] (index) database connection response [27 Aug 2020 18:24:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200270805' AND ACCESS_CODE = '60724186' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 18:24:18] (index) database connection response [27 Aug 2020 18:24:18] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000593002' [27 Aug 2020 18:24:18] (index) database connection response [27 Aug 2020 18:24:18] (index) getPatientReportsDetail() entered [27 Aug 2020 18:24:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200270805', 'M0100000593002', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:24:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200270805', 'M0100000593002', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 18:24:18] (index) p_Stop=N [27 Aug 2020 18:24:18] (index) p_Alert= [27 Aug 2020 18:24: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 [27 Aug 2020 18:24:18] (index) database connection response [27 Aug 2020 18:24:18] (index) getConnectionClose() called.... [27 Aug 2020 18:24:18] (index) getConnectionClose() called.... [27 Aug 2020 20:00:01] (index) database connection response [27 Aug 2020 20:00:01] (index) getConnection(): Resource id #1 [27 Aug 2020 20:00:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 20:00:01] (index) database connection response [27 Aug 2020 20:00:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 20:00:01] (index) database connection response [27 Aug 2020 20:00:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 20:00:01] (index) database connection response [27 Aug 2020 20:00:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350186' AND ACCESS_CODE = '15265324' [27 Aug 2020 20:00:01] (index) database connection response [27 Aug 2020 20:00:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350186' AND ACCESS_CODE = '15265324' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 20:00:01] (index) database connection response [27 Aug 2020 20:00:01] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631278' [27 Aug 2020 20:00:01] (index) database connection response [27 Aug 2020 20:00:01] (index) getPatientReportsDetail() entered [27 Aug 2020 20:00:01] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350186', 'M0100000631278', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 20:00:01] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350186', 'M0100000631278', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 20:00:01] (index) p_Stop=N [27 Aug 2020 20:00:01] (index) p_Alert= [27 Aug 2020 20:00: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 [27 Aug 2020 20:00:01] (index) database connection response [27 Aug 2020 20:00:01] (index) getConnectionClose() called.... [27 Aug 2020 20:00:01] (index) getConnectionClose() called.... [27 Aug 2020 22:25:14] (index) database connection response [27 Aug 2020 22:25:14] (index) getConnection(): Resource id #1 [27 Aug 2020 22:25:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 22:25:14] (index) database connection response [27 Aug 2020 22:25:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 22:25:14] (index) database connection response [27 Aug 2020 22:25:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 22:25:14] (index) database connection response [27 Aug 2020 22:25:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '78846837' [27 Aug 2020 22:25:14] (index) database connection response [27 Aug 2020 22:25:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '78846837' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 22:25:14] (index) database connection response [27 Aug 2020 22:25:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631293' [27 Aug 2020 22:25:14] (index) database connection response [27 Aug 2020 22:25:14] (index) getPatientReportsDetail() entered [27 Aug 2020 22:25:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350409', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:25:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350409', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:25:14] (index) p_Stop=N [27 Aug 2020 22:25:14] (index) p_Alert= [27 Aug 2020 22:25:14] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [27 Aug 2020 22:25:14] (index) database connection response [27 Aug 2020 22:25:14] (index) getConnectionClose() called.... [27 Aug 2020 22:25:14] (index) getConnectionClose() called.... [27 Aug 2020 22:25:25] (viewOnlineReports) database connection response [27 Aug 2020 22:25:25] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:25:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:25:25] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:25:25] (viewOnlineReports) p_Alert= [27 Aug 2020 22:25:25] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:25: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', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:25:26] (viewOnlineReports) database connection response [27 Aug 2020 22:25:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:25:26] (viewOnlineReports) database connection response [27 Aug 2020 22:25:26] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:25:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:25:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:25:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:25:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1598549125M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:25:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1598549125M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:25:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:25:26] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:25:26] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1598549125M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:25:26] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1598549125M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:29:17] (index) database connection response [27 Aug 2020 22:29:17] (index) getConnection(): Resource id #1 [27 Aug 2020 22:29:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 22:29:17] (index) database connection response [27 Aug 2020 22:29:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 22:29:17] (index) database connection response [27 Aug 2020 22:29:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 22:29:17] (index) database connection response [27 Aug 2020 22:29:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '78846837' [27 Aug 2020 22:29:17] (index) database connection response [27 Aug 2020 22:29:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350409' AND ACCESS_CODE = '78846837' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 22:29:17] (index) database connection response [27 Aug 2020 22:29:17] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631293' [27 Aug 2020 22:29:17] (index) database connection response [27 Aug 2020 22:29:17] (index) getPatientReportsDetail() entered [27 Aug 2020 22:29:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350409', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:29:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350409', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:29:17] (index) p_Stop=N [27 Aug 2020 22:29:17] (index) p_Alert= [27 Aug 2020 22:29: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 [27 Aug 2020 22:29:17] (index) database connection response [27 Aug 2020 22:29:17] (index) getConnectionClose() called.... [27 Aug 2020 22:29:17] (index) getConnectionClose() called.... [27 Aug 2020 22:29:26] (viewOnlineReports) database connection response [27 Aug 2020 22:29:26] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:29:26] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:29:26] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:29:26] (viewOnlineReports) p_Alert= [27 Aug 2020 22:29:26] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:29:26] (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', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:29:26] (viewOnlineReports) database connection response [27 Aug 2020 22:29:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:29:26] (viewOnlineReports) database connection response [27 Aug 2020 22:29:26] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:29:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:29:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:29:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:29:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1598549366M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:29:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1598549366M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:29:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:29:26] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:29:26] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1598549366M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:29:26] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1598549366M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:30:54] (viewOnlineReports) database connection response [27 Aug 2020 22:30:54] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:30:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:30:54] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:30:54] (viewOnlineReports) p_Alert= [27 Aug 2020 22:30:54] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:30:54] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:30:54] (viewOnlineReports) database connection response [27 Aug 2020 22:30:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:30:54] (viewOnlineReports) database connection response [27 Aug 2020 22:30:54] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:30:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:30:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:30:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:30:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1598549454M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:30:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1598549454M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:30:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:30:54] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:30:54] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1598549454M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:30:54] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1598549454M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:30:59] (viewOnlineReports) database connection response [27 Aug 2020 22:30:59] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:30:59] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:30:59] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:30:59] (viewOnlineReports) p_Alert= [27 Aug 2020 22:30:59] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:30:59] (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', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:30:59] (viewOnlineReports) database connection response [27 Aug 2020 22:30:59] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:30:59] (viewOnlineReports) database connection response [27 Aug 2020 22:30:59] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:30:59] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:30:59] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:30:59] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:30:59] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598549459M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:30:59] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598549459M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:30:59] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:30:59] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:30:59] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598549459M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:30:59] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598549459M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:07] (viewOnlineReports) database connection response [27 Aug 2020 22:31:07] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:31:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:31:07] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:31:07] (viewOnlineReports) p_Alert= [27 Aug 2020 22:31:07] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:31: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', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:31:07] (viewOnlineReports) database connection response [27 Aug 2020 22:31:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:31:07] (viewOnlineReports) database connection response [27 Aug 2020 22:31:07] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:31:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1598549467M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1598549467M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:31:07] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:31:07] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1598549467M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:31:07] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1598549467M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:17] (viewOnlineReports) database connection response [27 Aug 2020 22:31:17] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:31:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:31:17] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:31:17] (viewOnlineReports) p_Alert= [27 Aug 2020 22:31:17] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:31: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', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:31:17] (viewOnlineReports) database connection response [27 Aug 2020 22:31:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:31:17] (viewOnlineReports) database connection response [27 Aug 2020 22:31:17] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:31:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598549477M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598549477M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:31:17] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:31:17] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598549477M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:31:17] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1598549477M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:25] (viewOnlineReports) database connection response [27 Aug 2020 22:31:25] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:31:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:31:25] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:31:25] (viewOnlineReports) p_Alert= [27 Aug 2020 22:31:25] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:31: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', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:31:25] (viewOnlineReports) database connection response [27 Aug 2020 22:31:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:31:25] (viewOnlineReports) database connection response [27 Aug 2020 22:31:25] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:31:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1598549485M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1598549485M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:31:26] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:31:26] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1598549485M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:31:26] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1598549485M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:34] (viewOnlineReports) database connection response [27 Aug 2020 22:31:34] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:31:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:31:34] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:31:34] (viewOnlineReports) p_Alert= [27 Aug 2020 22:31:34] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:31:34] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:31:34] (viewOnlineReports) database connection response [27 Aug 2020 22:31:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:31:34] (viewOnlineReports) database connection response [27 Aug 2020 22:31:34] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:31:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1598549494M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1598549494M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:31:34] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:31:34] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1598549494M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:31:34] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1598549494M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:43] (viewOnlineReports) database connection response [27 Aug 2020 22:31:43] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:31:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:31:43] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:31:43] (viewOnlineReports) p_Alert= [27 Aug 2020 22:31:43] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:31:43] (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', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:31:43] (viewOnlineReports) database connection response [27 Aug 2020 22:31:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:31:43] (viewOnlineReports) database connection response [27 Aug 2020 22:31:43] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:31:43] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:43] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:31:43] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:43] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598549503M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:43] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598549503M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:31:43] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 22:31:43] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376801/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1598549503M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:44:22] (viewOnlineReports) database connection response [27 Aug 2020 22:44:22] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:44:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376801', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:44:22] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:44:22] (viewOnlineReports) p_Alert= [27 Aug 2020 22:44:22] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:44:22] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376801', 'M01', '047', '1', '001000000000084702', 'M0100000631293_M01SCH20008695_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:44:23] (viewOnlineReports) database connection response [27 Aug 2020 22:44:23] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376801' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [27 Aug 2020 22:44:23] (viewOnlineReports) database connection response [27 Aug 2020 22:44:23] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:44:23] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376801/ [27 Aug 2020 22:44:23] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376801/ [27 Aug 2020 22:44:23] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:44:23] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1598550262M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:44:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1598550262M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:44:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [27 Aug 2020 22:44:23] (viewOnlineReports) Converting PDF to JPG with name as M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:44:23] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1598550262M0100000631293_M01SCH20008695_1.PDF ../../TEMP_PDF/200376801/M0100000631293_M01SCH20008695_1.jpg [27 Aug 2020 22:44:23] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376801/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1598550262M0100000631293_M01SCH20008695_1.PDF [27 Aug 2020 22:46:24] (index) database connection response [27 Aug 2020 22:46:24] (index) getConnection(): Resource id #1 [27 Aug 2020 22:46:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 22:46:24] (index) database connection response [27 Aug 2020 22:46:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 22:46:24] (index) database connection response [27 Aug 2020 22:46:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 22:46:24] (index) database connection response [27 Aug 2020 22:46:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350385' AND ACCESS_CODE = '15188420' [27 Aug 2020 22:46:24] (index) database connection response [27 Aug 2020 22:46:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200350385' AND ACCESS_CODE = '15188420' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 22:46:24] (index) database connection response [27 Aug 2020 22:46:24] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631293' [27 Aug 2020 22:46:24] (index) database connection response [27 Aug 2020 22:46:24] (index) getPatientReportsDetail() entered [27 Aug 2020 22:46:24] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350385', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:46:24] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200350385', 'M0100000631293', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:46:24] (index) p_Stop=N [27 Aug 2020 22:46:24] (index) p_Alert= [27 Aug 2020 22:46:24] (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 [27 Aug 2020 22:46:24] (index) database connection response [27 Aug 2020 22:46:24] (index) getConnectionClose() called.... [27 Aug 2020 22:46:24] (index) getConnectionClose() called.... [27 Aug 2020 22:46:34] (viewOnlineReports) database connection response [27 Aug 2020 22:46:34] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:46:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '2', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:46:34] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:46:34] (viewOnlineReports) p_Alert= [27 Aug 2020 22:46:34] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:46:34] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376791', 'M01', '047', '2', '001000000000084949', 'M0100000631293_M01RCH20015711_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:46:34] (viewOnlineReports) database connection response [27 Aug 2020 22:46:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [27 Aug 2020 22:46:34] (viewOnlineReports) database connection response [27 Aug 2020 22:46:34] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:46:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 22:46:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 22:46:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01RCH20015711_1.PDF [27 Aug 2020 22:46:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598550394M0100000631293_M01RCH20015711_1.PDF [27 Aug 2020 22:46:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598550394M0100000631293_M01RCH20015711_1.PDF [27 Aug 2020 22:46:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 22:46:34] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376791/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1598550394M0100000631293_M01RCH20015711_1.PDF [27 Aug 2020 22:47:00] (viewOnlineReports) database connection response [27 Aug 2020 22:47:00] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:47:00] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:47:00] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:47:00] (viewOnlineReports) p_Alert= [27 Aug 2020 22:47:00] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:47: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', '200376791', 'M01', '047', '3', '001000000000087100', 'M0100000631293_M01MIC20006236_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:47:00] (viewOnlineReports) database connection response [27 Aug 2020 22:47:00] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 22:47:00] (viewOnlineReports) database connection response [27 Aug 2020 22:47:00] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:47:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 22:47:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 22:47:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 22:47:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598550419M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 22:47:00] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598550419M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 22:47:00] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 22:47:00] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376791/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598550419M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 22:47:10] (viewOnlineReports) database connection response [27 Aug 2020 22:47:10] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:47:10] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:47:10] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:47:10] (viewOnlineReports) p_Alert= [27 Aug 2020 22:47:10] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:47: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', '200376791', 'M01', '047', '3', '001000000000087100', 'M0100000631293_M01MIC20006236_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:47:10] (viewOnlineReports) database connection response [27 Aug 2020 22:47:10] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [27 Aug 2020 22:47:10] (viewOnlineReports) database connection response [27 Aug 2020 22:47:10] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:47:10] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 22:47:10] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 22:47:10] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 22:47:10] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1598550430M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 22:47:10] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1598550430M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 22:47:10] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 22:47:10] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376791/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1598550430M0100000631293_M01MIC20006236_1.PDF [27 Aug 2020 22:48:52] (viewOnlineReports) database connection response [27 Aug 2020 22:48:52] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 22:48:52] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631293', '001', '200376791', '2', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 22:48:52] (viewOnlineReports) p_Stop=N [27 Aug 2020 22:48:52] (viewOnlineReports) p_Alert= [27 Aug 2020 22:48:52] (viewOnlineReports) Flag = 1 [27 Aug 2020 22:48: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', '200376791', 'M01', '047', '2', '001000000000084949', 'M0100000631293_M01RCH20015711_1.PDF', 'M0100000631293', SYSDATE) [27 Aug 2020 22:48:52] (viewOnlineReports) database connection response [27 Aug 2020 22:48:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376791' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [27 Aug 2020 22:48:52] (viewOnlineReports) database connection response [27 Aug 2020 22:48:52] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 22:48:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376791/ [27 Aug 2020 22:48:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376791/ [27 Aug 2020 22:48:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200827\M01\M0100000631293_M01RCH20015711_1.PDF [27 Aug 2020 22:48:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376791/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598550532M0100000631293_M01RCH20015711_1.PDF [27 Aug 2020 22:48:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376791/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598550532M0100000631293_M01RCH20015711_1.PDF [27 Aug 2020 22:48:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 22:48:52] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376791/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598550532M0100000631293_M01RCH20015711_1.PDF [27 Aug 2020 23:39:05] (index) database connection response [27 Aug 2020 23:39:05] (index) getConnection(): Resource id #1 [27 Aug 2020 23:39:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [27 Aug 2020 23:39:05] (index) database connection response [27 Aug 2020 23:39:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [27 Aug 2020 23:39:05] (index) database connection response [27 Aug 2020 23:39:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [27 Aug 2020 23:39:05] (index) database connection response [27 Aug 2020 23:39:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200335340' AND ACCESS_CODE = '87246190' [27 Aug 2020 23:39:05] (index) database connection response [27 Aug 2020 23:39:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200335340' AND ACCESS_CODE = '87246190' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [27 Aug 2020 23:39:05] (index) database connection response [27 Aug 2020 23:39:05] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000052865' [27 Aug 2020 23:39:05] (index) database connection response [27 Aug 2020 23:39:05] (index) getPatientReportsDetail() entered [27 Aug 2020 23:39:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200335340', 'M0100000052865', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:39:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200335340', 'M0100000052865', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:39:05] (index) p_Stop=N [27 Aug 2020 23:39:05] (index) p_Alert= [27 Aug 2020 23:39: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 [27 Aug 2020 23:39:05] (index) database connection response [27 Aug 2020 23:39:05] (index) getConnectionClose() called.... [27 Aug 2020 23:39:05] (index) getConnectionClose() called.... [27 Aug 2020 23:39:34] (viewOnlineReports) database connection response [27 Aug 2020 23:39:34] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:39:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '1', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:39:34] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:39:34] (viewOnlineReports) p_Alert= [27 Aug 2020 23:39:34] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:39:34] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200372586', 'M01', '001', '1', '001000000000084949', 'M0100000052865_M01RCH20014998_1.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:39:34] (viewOnlineReports) database connection response [27 Aug 2020 23:39:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [27 Aug 2020 23:39:34] (viewOnlineReports) database connection response [27 Aug 2020 23:39:34] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:39:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:39:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:39:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01RCH20014998_1.PDF [27 Aug 2020 23:39:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1598553574M0100000052865_M01RCH20014998_1.PDF [27 Aug 2020 23:39:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1598553574M0100000052865_M01RCH20014998_1.PDF [27 Aug 2020 23:39:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 23:39:34] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372586/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1598553574M0100000052865_M01RCH20014998_1.PDF [27 Aug 2020 23:40:29] (viewOnlineReports) database connection response [27 Aug 2020 23:40:29] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:40:29] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:40:29] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:40:29] (viewOnlineReports) p_Alert= [27 Aug 2020 23:40:29] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:40:29] (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', '200372586', 'M01', '001', '2', '001000000000084443', 'M0100000052865_M01SCH20008304_4.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:40:29] (viewOnlineReports) database connection response [27 Aug 2020 23:40:29] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [27 Aug 2020 23:40:29] (viewOnlineReports) database connection response [27 Aug 2020 23:40:29] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:40:29] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:40:29] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:40:29] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:29] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1598553628M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:29] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1598553628M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:29] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 23:40:29] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372586/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1598553628M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:39] (viewOnlineReports) database connection response [27 Aug 2020 23:40:39] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:40:39] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:40:39] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:40:39] (viewOnlineReports) p_Alert= [27 Aug 2020 23:40:39] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:40:39] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200372586', 'M01', '001', '2', '001000000000084443', 'M0100000052865_M01SCH20008304_4.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:40:39] (viewOnlineReports) database connection response [27 Aug 2020 23:40:39] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [27 Aug 2020 23:40:39] (viewOnlineReports) database connection response [27 Aug 2020 23:40:39] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:40:39] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:40:39] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:40:39] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:39] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1598553639M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1598553639M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 23:40:39] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372586/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1598553639M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:48] (viewOnlineReports) database connection response [27 Aug 2020 23:40:48] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:40:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:40:48] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:40:48] (viewOnlineReports) p_Alert= [27 Aug 2020 23:40:48] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:40:48] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200372586', 'M01', '001', '2', '001000000000084443', 'M0100000052865_M01SCH20008304_4.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:40:48] (viewOnlineReports) database connection response [27 Aug 2020 23:40:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [27 Aug 2020 23:40:48] (viewOnlineReports) database connection response [27 Aug 2020 23:40:48] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:40:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:40:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:40:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553648M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553648M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 23:40:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372586/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553648M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:50] (viewOnlineReports) database connection response [27 Aug 2020 23:40:50] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:40:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:40:50] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:40:50] (viewOnlineReports) p_Alert= [27 Aug 2020 23:40:50] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:40: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', '200372586', 'M01', '001', '2', '001000000000084443', 'M0100000052865_M01SCH20008304_4.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:40:50] (viewOnlineReports) database connection response [27 Aug 2020 23:40:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [27 Aug 2020 23:40:50] (viewOnlineReports) database connection response [27 Aug 2020 23:40:50] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:40:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:40:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:40:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1598553650M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1598553650M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:40:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 23:40:50] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200372586/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1598553650M0100000052865_M01SCH20008304_4.PDF [27 Aug 2020 23:41:29] (viewOnlineReports) database connection response [27 Aug 2020 23:41:29] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:41:29] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '3', '001000000000083001', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:41:29] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:41:29] (viewOnlineReports) p_Alert= [27 Aug 2020 23:41:29] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:41:29] (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', '200372586', 'M01', '001', '3', '001000000000083001', 'M0100000052865_M01SCH20008304_1.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:41:29] (viewOnlineReports) database connection response [27 Aug 2020 23:41:29] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [27 Aug 2020 23:41:29] (viewOnlineReports) database connection response [27 Aug 2020 23:41:29] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:41:29] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:41:29] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:41:29] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_1.PDF [27 Aug 2020 23:41:29] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1598553689M0100000052865_M01SCH20008304_1.PDF [27 Aug 2020 23:41:29] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1598553689M0100000052865_M01SCH20008304_1.PDF [27 Aug 2020 23:41:29] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 23:41:29] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372586/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1598553689M0100000052865_M01SCH20008304_1.PDF [27 Aug 2020 23:41:44] (viewOnlineReports) database connection response [27 Aug 2020 23:41:44] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:41:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '3', '001000000000083001', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:41:44] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:41:44] (viewOnlineReports) p_Alert= [27 Aug 2020 23:41:44] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:41: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', '200372586', 'M01', '001', '3', '001000000000083001', 'M0100000052865_M01SCH20008304_1.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:41:44] (viewOnlineReports) database connection response [27 Aug 2020 23:41:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [27 Aug 2020 23:41:44] (viewOnlineReports) database connection response [27 Aug 2020 23:41:44] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:41:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:41:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:41:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_1.PDF [27 Aug 2020 23:41:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1598553704M0100000052865_M01SCH20008304_1.PDF [27 Aug 2020 23:41:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1598553704M0100000052865_M01SCH20008304_1.PDF [27 Aug 2020 23:41:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 23:41:44] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200372586/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1598553704M0100000052865_M01SCH20008304_1.PDF [27 Aug 2020 23:42:05] (viewOnlineReports) database connection response [27 Aug 2020 23:42:05] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:42:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '4', '001000000000083002', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:42:05] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:42:05] (viewOnlineReports) p_Alert= [27 Aug 2020 23:42:05] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:42: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', '200372586', 'M01', '001', '4', '001000000000083002', 'M0100000052865_M01SCH20008304_2.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:42:05] (viewOnlineReports) database connection response [27 Aug 2020 23:42:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '4' [27 Aug 2020 23:42:05] (viewOnlineReports) database connection response [27 Aug 2020 23:42:05] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:42:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:42:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:42:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_2.PDF [27 Aug 2020 23:42:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553725M0100000052865_M01SCH20008304_2.PDF [27 Aug 2020 23:42:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553725M0100000052865_M01SCH20008304_2.PDF [27 Aug 2020 23:42:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 23:42:05] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372586/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553725M0100000052865_M01SCH20008304_2.PDF [27 Aug 2020 23:42:07] (viewOnlineReports) database connection response [27 Aug 2020 23:42:07] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:42:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '4', '001000000000083002', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:42:07] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:42:07] (viewOnlineReports) p_Alert= [27 Aug 2020 23:42:07] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:42: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', '200372586', 'M01', '001', '4', '001000000000083002', 'M0100000052865_M01SCH20008304_2.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:42:07] (viewOnlineReports) database connection response [27 Aug 2020 23:42:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '4' [27 Aug 2020 23:42:07] (viewOnlineReports) database connection response [27 Aug 2020 23:42:07] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:42:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:42:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:42:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_2.PDF [27 Aug 2020 23:42:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553727M0100000052865_M01SCH20008304_2.PDF [27 Aug 2020 23:42:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553727M0100000052865_M01SCH20008304_2.PDF [27 Aug 2020 23:42:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 23:42:07] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200372586/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1598553727M0100000052865_M01SCH20008304_2.PDF [27 Aug 2020 23:42:31] (viewOnlineReports) database connection response [27 Aug 2020 23:42:31] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:42:31] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '5', '001000000000084146', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:42:31] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:42:31] (viewOnlineReports) p_Alert= [27 Aug 2020 23:42:31] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:42: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', '200372586', 'M01', '001', '5', '001000000000084146', 'M0100000052865_M01SCH20008304_3.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:42:31] (viewOnlineReports) database connection response [27 Aug 2020 23:42:31] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '5' [27 Aug 2020 23:42:31] (viewOnlineReports) database connection response [27 Aug 2020 23:42:31] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:42:31] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:42:31] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:42:31] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_3.PDF [27 Aug 2020 23:42:31] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1598553751M0100000052865_M01SCH20008304_3.PDF [27 Aug 2020 23:42:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1598553751M0100000052865_M01SCH20008304_3.PDF [27 Aug 2020 23:42:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [27 Aug 2020 23:42:32] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372586/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1598553751M0100000052865_M01SCH20008304_3.PDF [27 Aug 2020 23:42:33] (viewOnlineReports) database connection response [27 Aug 2020 23:42:33] (viewOnlineReports) getConnection(): Resource id #1 [27 Aug 2020 23:42:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052865', '001', '200372586', '5', '001000000000084146', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [27 Aug 2020 23:42:33] (viewOnlineReports) p_Stop=N [27 Aug 2020 23:42:33] (viewOnlineReports) p_Alert= [27 Aug 2020 23:42:33] (viewOnlineReports) Flag = 1 [27 Aug 2020 23:42:33] (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', '200372586', 'M01', '001', '5', '001000000000084146', 'M0100000052865_M01SCH20008304_3.PDF', 'M0100000052865', SYSDATE) [27 Aug 2020 23:42:33] (viewOnlineReports) database connection response [27 Aug 2020 23:42:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372586' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '5' [27 Aug 2020 23:42:33] (viewOnlineReports) database connection response [27 Aug 2020 23:42:33] (viewOnlineReports) getConnectionClose() called.... [27 Aug 2020 23:42:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372586/ [27 Aug 2020 23:42:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372586/ [27 Aug 2020 23:42:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200818\M01\M0100000052865_M01SCH20008304_3.PDF [27 Aug 2020 23:42:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372586/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1598553753M0100000052865_M01SCH20008304_3.PDF [27 Aug 2020 23:42:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372586/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1598553753M0100000052865_M01SCH20008304_3.PDF [27 Aug 2020 23:42:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [27 Aug 2020 23:42:33] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200372586/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1598553753M0100000052865_M01SCH20008304_3.PDF