[05 Oct 2020 01:39:23] (index) database connection response [05 Oct 2020 01:39:23] (index) getConnection(): Resource id #1 [05 Oct 2020 01:39:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 01:39:23] (index) database connection response [05 Oct 2020 01:39:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 01:39:23] (index) database connection response [05 Oct 2020 01:39:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 01:39:23] (index) database connection response [05 Oct 2020 01:39:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' [05 Oct 2020 01:39:23] (index) database connection response [05 Oct 2020 01:39:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 01:39:23] (index) database connection response [05 Oct 2020 01:39:23] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000621065' [05 Oct 2020 01:39:23] (index) database connection response [05 Oct 2020 01:39:23] (index) getPatientReportsDetail() entered [05 Oct 2020 01:39:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 01:39:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 01:39:23] (index) p_Stop=N [05 Oct 2020 01:39:23] (index) p_Alert= [05 Oct 2020 01:39:23] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 01:39:23] (index) database connection response [05 Oct 2020 01:39:23] (index) getConnectionClose() called.... [05 Oct 2020 01:39:23] (index) getConnectionClose() called.... [05 Oct 2020 10:36:40] (index) database connection response [05 Oct 2020 10:36:40] (index) getConnection(): Resource id #1 [05 Oct 2020 10:36:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 10:36:40] (index) database connection response [05 Oct 2020 10:36:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 10:36:40] (index) database connection response [05 Oct 2020 10:36:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 10:36:40] (index) database connection response [05 Oct 2020 10:36:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200419461' AND ACCESS_CODE = '81481176' [05 Oct 2020 10:36:40] (index) database connection response [05 Oct 2020 10:36:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200419461' AND ACCESS_CODE = '81481176' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 10:36:40] (index) database connection response [05 Oct 2020 10:36:40] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000559035' [05 Oct 2020 10:36:40] (index) database connection response [05 Oct 2020 10:36:40] (index) getPatientReportsDetail() entered [05 Oct 2020 10:36:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200419461', 'M0100000559035', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 10:36:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200419461', 'M0100000559035', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 10:36:41] (index) p_Stop=N [05 Oct 2020 10:36:41] (index) p_Alert= [05 Oct 2020 10:36:41] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 10:36:41] (index) database connection response [05 Oct 2020 10:36:41] (index) getConnectionClose() called.... [05 Oct 2020 10:36:41] (index) getConnectionClose() called.... [05 Oct 2020 10:36:54] (viewOnlineReports) database connection response [05 Oct 2020 10:36:54] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 10:36:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000559035', '001', '200398573', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 10:36:54] (viewOnlineReports) p_Stop=N [05 Oct 2020 10:36:54] (viewOnlineReports) p_Alert= [05 Oct 2020 10:36:54] (viewOnlineReports) Flag = 1 [05 Oct 2020 10:36: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', '200398573', 'M01', '047', '2', '001000000000085025', 'M0100000559035_M01HEM20013821_1.PDF', 'M0100000559035', SYSDATE) [05 Oct 2020 10:36:54] (viewOnlineReports) database connection response [05 Oct 2020 10:36:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398573' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [05 Oct 2020 10:36:54] (viewOnlineReports) database connection response [05 Oct 2020 10:36:54] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 10:36:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398573/ [05 Oct 2020 10:36:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398573/ [05 Oct 2020 10:36:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201003\M01\M0100000559035_M01HEM20013821_1.PDF [05 Oct 2020 10:36:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398573/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601876214M0100000559035_M01HEM20013821_1.PDF [05 Oct 2020 10:36:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398573/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601876214M0100000559035_M01HEM20013821_1.PDF [05 Oct 2020 10:36:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 10:36:54] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398573/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601876214M0100000559035_M01HEM20013821_1.PDF [05 Oct 2020 11:32:47] (index) database connection response [05 Oct 2020 11:32:47] (index) getConnection(): Resource id #1 [05 Oct 2020 11:32:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 11:32:47] (index) database connection response [05 Oct 2020 11:32:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 11:32:47] (index) database connection response [05 Oct 2020 11:32:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 11:32:47] (index) database connection response [05 Oct 2020 11:32:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' [05 Oct 2020 11:32:48] (index) database connection response [05 Oct 2020 11:32:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 11:32:48] (index) database connection response [05 Oct 2020 11:32:48] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000621065' [05 Oct 2020 11:32:48] (index) database connection response [05 Oct 2020 11:32:48] (index) getPatientReportsDetail() entered [05 Oct 2020 11:32:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 11:32:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 11:32:48] (index) p_Stop=N [05 Oct 2020 11:32:48] (index) p_Alert= [05 Oct 2020 11:32:48] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 11:32:48] (index) database connection response [05 Oct 2020 11:32:48] (index) getConnectionClose() called.... [05 Oct 2020 11:32:48] (index) getConnectionClose() called.... [05 Oct 2020 13:17:10] (index) database connection response [05 Oct 2020 13:17:10] (index) getConnection(): Resource id #1 [05 Oct 2020 13:17:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 13:17:10] (index) database connection response [05 Oct 2020 13:17:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 13:17:10] (index) database connection response [05 Oct 2020 13:17:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 13:17:10] (index) database connection response [05 Oct 2020 13:17:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200420889' AND ACCESS_CODE = '15183441' [05 Oct 2020 13:17:11] (index) database connection response [05 Oct 2020 13:17:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200420889' AND ACCESS_CODE = '15183441' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 13:17:11] (index) database connection response [05 Oct 2020 13:17:11] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000071839' [05 Oct 2020 13:17:11] (index) database connection response [05 Oct 2020 13:17:11] (index) getPatientReportsDetail() entered [05 Oct 2020 13:17:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200420889', 'M0100000071839', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 13:17:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200420889', 'M0100000071839', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 13:17:11] (index) p_Stop=N [05 Oct 2020 13:17:11] (index) p_Alert= [05 Oct 2020 13:17:11] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 13:17:11] (index) database connection response [05 Oct 2020 13:17:11] (index) getConnectionClose() called.... [05 Oct 2020 13:17:11] (index) getConnectionClose() called.... [05 Oct 2020 13:17:20] (viewOnlineReports) database connection response [05 Oct 2020 13:17:20] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 13:17:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000071839', '001', '200398888', '1', '001000000000084478', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 13:17:20] (viewOnlineReports) p_Stop=N [05 Oct 2020 13:17:20] (viewOnlineReports) p_Alert= [05 Oct 2020 13:17:20] (viewOnlineReports) Flag = 1 [05 Oct 2020 13:17: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', '200398888', 'M01', '047', '1', '001000000000084478', 'M0100000071839_M01RCH20018767_1.PDF', 'M0100000071839', SYSDATE) [05 Oct 2020 13:17:20] (viewOnlineReports) database connection response [05 Oct 2020 13:17:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398888' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 13:17:20] (viewOnlineReports) database connection response [05 Oct 2020 13:17:20] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 13:17:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398888/ [05 Oct 2020 13:17:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398888/ [05 Oct 2020 13:17:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000071839_M01RCH20018767_1.PDF [05 Oct 2020 13:17:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398888/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601885840M0100000071839_M01RCH20018767_1.PDF [05 Oct 2020 13:17:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398888/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601885840M0100000071839_M01RCH20018767_1.PDF [05 Oct 2020 13:17:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [05 Oct 2020 13:17:20] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200398888/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601885840M0100000071839_M01RCH20018767_1.PDF [05 Oct 2020 13:35:31] (viewOnlineReports) database connection response [05 Oct 2020 13:35:31] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 13:35:31] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000071839', '001', '200398888', '1', '001000000000084478', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 13:35:31] (viewOnlineReports) p_Stop=N [05 Oct 2020 13:35:31] (viewOnlineReports) p_Alert= [05 Oct 2020 13:35:31] (viewOnlineReports) Flag = 1 [05 Oct 2020 13:35: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', '200398888', 'M01', '047', '1', '001000000000084478', 'M0100000071839_M01RCH20018767_1.PDF', 'M0100000071839', SYSDATE) [05 Oct 2020 13:35:31] (viewOnlineReports) database connection response [05 Oct 2020 13:35:31] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398888' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 13:35:31] (viewOnlineReports) database connection response [05 Oct 2020 13:35:31] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 13:35:31] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398888/ [05 Oct 2020 13:35:31] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398888/ [05 Oct 2020 13:35:31] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000071839_M01RCH20018767_1.PDF [05 Oct 2020 13:35:31] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398888/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601886931M0100000071839_M01RCH20018767_1.PDF [05 Oct 2020 13:35:31] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398888/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601886931M0100000071839_M01RCH20018767_1.PDF [05 Oct 2020 13:35:31] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [05 Oct 2020 13:35:31] (viewOnlineReports) Converting PDF to JPG with name as M0100000071839_M01RCH20018767_1.jpg [05 Oct 2020 13:35:31] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200398888/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601886931M0100000071839_M01RCH20018767_1.PDF ../../TEMP_PDF/200398888/M0100000071839_M01RCH20018767_1.jpg [05 Oct 2020 13:35:32] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200398888/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601886931M0100000071839_M01RCH20018767_1.PDF [05 Oct 2020 14:02:06] (index) database connection response [05 Oct 2020 14:02:06] (index) getConnection(): Resource id #1 [05 Oct 2020 14:02:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 14:02:06] (index) database connection response [05 Oct 2020 14:02:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 14:02:06] (index) database connection response [05 Oct 2020 14:02:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 14:02:06] (index) database connection response [05 Oct 2020 14:02:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' [05 Oct 2020 14:02:06] (index) database connection response [05 Oct 2020 14:02:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 14:02:06] (index) database connection response [05 Oct 2020 14:02:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000621065' [05 Oct 2020 14:02:06] (index) database connection response [05 Oct 2020 14:02:06] (index) getPatientReportsDetail() entered [05 Oct 2020 14:02:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 14:02:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 14:02:06] (index) p_Stop=N [05 Oct 2020 14:02:06] (index) p_Alert= [05 Oct 2020 14:02:06] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 14:02:06] (index) database connection response [05 Oct 2020 14:02:06] (index) getConnectionClose() called.... [05 Oct 2020 14:02:06] (index) getConnectionClose() called.... [05 Oct 2020 15:42:42] (index) database connection response [05 Oct 2020 15:42:42] (index) getConnection(): Resource id #1 [05 Oct 2020 15:42:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 15:42:42] (index) database connection response [05 Oct 2020 15:42:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 15:42:42] (index) database connection response [05 Oct 2020 15:42:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 15:42:42] (index) database connection response [05 Oct 2020 15:42:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01190669696' AND ACCESS_CODE = '14375065' [05 Oct 2020 15:42:42] (index) database connection response [05 Oct 2020 15:42:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01190669696' AND ACCESS_CODE = '14375065' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 15:42:42] (index) database connection response [05 Oct 2020 15:42:42] (index) getConnectionClose() called.... [05 Oct 2020 15:50:07] (index) database connection response [05 Oct 2020 15:50:07] (index) getConnection(): Resource id #1 [05 Oct 2020 15:50:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 15:50:07] (index) database connection response [05 Oct 2020 15:50:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 15:50:07] (index) database connection response [05 Oct 2020 15:50:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 15:50:07] (index) database connection response [05 Oct 2020 15:50:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000057' AND ACCESS_CODE = 'MIH052' [05 Oct 2020 15:50:07] (index) database connection response [05 Oct 2020 15:50:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000057' AND ACCESS_CODE = 'MIH052' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 15:50:07] (index) database connection response [05 Oct 2020 15:50:07] (index) getConnectionClose() called.... [05 Oct 2020 15:51:01] (index) database connection response [05 Oct 2020 15:51:01] (index) getConnection(): Resource id #1 [05 Oct 2020 15:51:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 15:51:01] (index) database connection response [05 Oct 2020 15:51:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 15:51:01] (index) database connection response [05 Oct 2020 15:51:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 15:51:01] (index) database connection response [05 Oct 2020 15:51:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000057' AND ACCESS_CODE = 'APPV2' [05 Oct 2020 15:51:01] (index) database connection response [05 Oct 2020 15:51:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000057' AND ACCESS_CODE = 'APPV2' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 15:51:01] (index) database connection response [05 Oct 2020 15:51:01] (index) getConnectionClose() called.... [05 Oct 2020 15:52:09] (index) database connection response [05 Oct 2020 15:52:09] (index) getConnection(): Resource id #1 [05 Oct 2020 15:52:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 15:52:09] (index) database connection response [05 Oct 2020 15:52:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 15:52:09] (index) database connection response [05 Oct 2020 15:52:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 15:52:09] (index) database connection response [05 Oct 2020 15:52:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M1200316317' AND ACCESS_CODE = '19821954' [05 Oct 2020 15:52:09] (index) database connection response [05 Oct 2020 15:52:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M1200316317' AND ACCESS_CODE = '19821954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 15:52:09] (index) database connection response [05 Oct 2020 15:52:09] (index) getConnectionClose() called.... [05 Oct 2020 15:52:40] (index) database connection response [05 Oct 2020 15:52:40] (index) getConnection(): Resource id #1 [05 Oct 2020 15:52:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 15:52:40] (index) database connection response [05 Oct 2020 15:52:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 15:52:40] (index) database connection response [05 Oct 2020 15:52:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 15:52:40] (index) database connection response [05 Oct 2020 15:52:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200419995' AND ACCESS_CODE = '19821954' [05 Oct 2020 15:52:40] (index) database connection response [05 Oct 2020 15:52:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200419995' AND ACCESS_CODE = '19821954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 15:52:40] (index) database connection response [05 Oct 2020 15:52:40] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000058704' [05 Oct 2020 15:52:40] (index) database connection response [05 Oct 2020 15:52:40] (index) getPatientReportsDetail() entered [05 Oct 2020 15:52:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200419995', 'M0100000058704', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:52:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200419995', 'M0100000058704', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:52:40] (index) p_Stop=N [05 Oct 2020 15:52:40] (index) p_Alert= [05 Oct 2020 15:52:40] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 15:52:40] (index) database connection response [05 Oct 2020 15:52:40] (index) getConnectionClose() called.... [05 Oct 2020 15:52:40] (index) getConnectionClose() called.... [05 Oct 2020 15:52:55] (viewOnlineReports) database connection response [05 Oct 2020 15:52:55] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:52:55] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '1', '001000000000083036', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:52:55] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:52:55] (viewOnlineReports) p_Alert= [05 Oct 2020 15:52:55] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:52:55] (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', '200398651', 'M01', '027', '1', '001000000000083036', 'M0100000058704_M01RCH20018725_4.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:52:55] (viewOnlineReports) database connection response [05 Oct 2020 15:52:55] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [05 Oct 2020 15:52:55] (viewOnlineReports) database connection response [05 Oct 2020 15:52:55] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:52:55] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:52:55] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:52:55] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01RCH20018725_4.PDF [05 Oct 2020 15:52:55] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895175M0100000058704_M01RCH20018725_4.PDF [05 Oct 2020 15:52:55] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895175M0100000058704_M01RCH20018725_4.PDF [05 Oct 2020 15:52:55] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:52:55] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895175M0100000058704_M01RCH20018725_4.PDF [05 Oct 2020 15:52:58] (viewOnlineReports) database connection response [05 Oct 2020 15:52:58] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:52:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:52:58] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:52:58] (viewOnlineReports) p_Alert= [05 Oct 2020 15:52:58] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:52: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', '200398651', 'M01', '027', '2', '001000000000085025', 'M0100000058704_M01HEM20013852_1.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:52:58] (viewOnlineReports) database connection response [05 Oct 2020 15:52:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [05 Oct 2020 15:52:58] (viewOnlineReports) database connection response [05 Oct 2020 15:52:58] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:52:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:52:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:52:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01HEM20013852_1.PDF [05 Oct 2020 15:52:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895178M0100000058704_M01HEM20013852_1.PDF [05 Oct 2020 15:52:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895178M0100000058704_M01HEM20013852_1.PDF [05 Oct 2020 15:52:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:52:58] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895178M0100000058704_M01HEM20013852_1.PDF [05 Oct 2020 15:53:02] (viewOnlineReports) database connection response [05 Oct 2020 15:53:02] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:53:02] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '3', '001000000000081265', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:53:02] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:53:02] (viewOnlineReports) p_Alert= [05 Oct 2020 15:53:02] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:53:02] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200398651', 'M01', '027', '3', '001000000000081265', 'M0100000058704_M01RCH20018725_3.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:53:03] (viewOnlineReports) database connection response [05 Oct 2020 15:53:03] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '3' [05 Oct 2020 15:53:03] (viewOnlineReports) database connection response [05 Oct 2020 15:53:03] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:53:03] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:03] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:03] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01RCH20018725_3.PDF [05 Oct 2020 15:53:03] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601895182M0100000058704_M01RCH20018725_3.PDF [05 Oct 2020 15:53:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601895182M0100000058704_M01RCH20018725_3.PDF [05 Oct 2020 15:53:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:53:03] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601895182M0100000058704_M01RCH20018725_3.PDF [05 Oct 2020 15:53:05] (viewOnlineReports) database connection response [05 Oct 2020 15:53:05] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:53:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '4', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:53:05] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:53:05] (viewOnlineReports) p_Alert= [05 Oct 2020 15:53:05] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:53: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', '200398651', 'M01', '027', '4', '001000000000084296', 'M0100000058704_M01RCH20018725_5.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:53:05] (viewOnlineReports) database connection response [05 Oct 2020 15:53:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '4' [05 Oct 2020 15:53:05] (viewOnlineReports) database connection response [05 Oct 2020 15:53:05] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:53:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01RCH20018725_5.PDF [05 Oct 2020 15:53:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1601895185M0100000058704_M01RCH20018725_5.PDF [05 Oct 2020 15:53:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1601895185M0100000058704_M01RCH20018725_5.PDF [05 Oct 2020 15:53:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:53:05] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1601895185M0100000058704_M01RCH20018725_5.PDF [05 Oct 2020 15:53:08] (viewOnlineReports) database connection response [05 Oct 2020 15:53:08] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:53:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '5', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:53:08] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:53:08] (viewOnlineReports) p_Alert= [05 Oct 2020 15:53:08] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:53:08] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200398651', 'M01', '027', '5', '001000000000084443', 'M0100000058704_M01SCH20010406_2.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:53:08] (viewOnlineReports) database connection response [05 Oct 2020 15:53:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '5' [05 Oct 2020 15:53:08] (viewOnlineReports) database connection response [05 Oct 2020 15:53:08] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:53:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01SCH20010406_2.PDF [05 Oct 2020 15:53:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601895188M0100000058704_M01SCH20010406_2.PDF [05 Oct 2020 15:53:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601895188M0100000058704_M01SCH20010406_2.PDF [05 Oct 2020 15:53:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:53:08] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601895188M0100000058704_M01SCH20010406_2.PDF [05 Oct 2020 15:53:10] (viewOnlineReports) database connection response [05 Oct 2020 15:53:10] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:53:10] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '6', '001000000000080058', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:53:10] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:53:10] (viewOnlineReports) p_Alert= [05 Oct 2020 15:53:10] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:53: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', '200398651', 'M01', '027', '6', '001000000000080058', 'M0100000058704_M01RCH20018725_1.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:53:10] (viewOnlineReports) database connection response [05 Oct 2020 15:53:11] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '6' [05 Oct 2020 15:53:11] (viewOnlineReports) database connection response [05 Oct 2020 15:53:11] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:53:11] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:11] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:11] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01RCH20018725_1.PDF [05 Oct 2020 15:53:11] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1601895190M0100000058704_M01RCH20018725_1.PDF [05 Oct 2020 15:53:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1601895190M0100000058704_M01RCH20018725_1.PDF [05 Oct 2020 15:53:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:53:11] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1601895190M0100000058704_M01RCH20018725_1.PDF [05 Oct 2020 15:53:13] (viewOnlineReports) database connection response [05 Oct 2020 15:53:13] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:53:13] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '7', '001000000000080061', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:53:13] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:53:13] (viewOnlineReports) p_Alert= [05 Oct 2020 15:53:13] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:53:13] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200398651', 'M01', '027', '7', '001000000000080061', 'M0100000058704_M01RCH20018725_2.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:53:13] (viewOnlineReports) database connection response [05 Oct 2020 15:53:13] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '7' [05 Oct 2020 15:53:13] (viewOnlineReports) database connection response [05 Oct 2020 15:53:13] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:53:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01RCH20018725_2.PDF [05 Oct 2020 15:53:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895192M0100000058704_M01RCH20018725_2.PDF [05 Oct 2020 15:53:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895192M0100000058704_M01RCH20018725_2.PDF [05 Oct 2020 15:53:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:53:13] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601895192M0100000058704_M01RCH20018725_2.PDF [05 Oct 2020 15:53:15] (viewOnlineReports) database connection response [05 Oct 2020 15:53:15] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:53:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '8', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:53:15] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:53:15] (viewOnlineReports) p_Alert= [05 Oct 2020 15:53:15] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:53:15] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200398651', 'M01', '027', '8', '001000000000087100', 'M0100000058704_M01MIC20007572_1.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:53:15] (viewOnlineReports) database connection response [05 Oct 2020 15:53:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '8' [05 Oct 2020 15:53:15] (viewOnlineReports) database connection response [05 Oct 2020 15:53:15] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:53:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01MIC20007572_1.PDF [05 Oct 2020 15:53:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601895195M0100000058704_M01MIC20007572_1.PDF [05 Oct 2020 15:53:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601895195M0100000058704_M01MIC20007572_1.PDF [05 Oct 2020 15:53:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:53:15] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601895195M0100000058704_M01MIC20007572_1.PDF [05 Oct 2020 15:53:17] (viewOnlineReports) database connection response [05 Oct 2020 15:53:17] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 15:53:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000058704', '001', '200398651', '9', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 15:53:17] (viewOnlineReports) p_Stop=N [05 Oct 2020 15:53:17] (viewOnlineReports) p_Alert= [05 Oct 2020 15:53:17] (viewOnlineReports) Flag = 1 [05 Oct 2020 15:53: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', '200398651', 'M01', '027', '9', '001000000000082306', 'M0100000058704_M01SCH20010406_1.PDF', 'M0100000058704', SYSDATE) [05 Oct 2020 15:53:17] (viewOnlineReports) database connection response [05 Oct 2020 15:53:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398651' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '9' [05 Oct 2020 15:53:17] (viewOnlineReports) database connection response [05 Oct 2020 15:53:17] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 15:53:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398651/ [05 Oct 2020 15:53:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201004\M01\M0100000058704_M01SCH20010406_1.PDF [05 Oct 2020 15:53:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601895197M0100000058704_M01SCH20010406_1.PDF [05 Oct 2020 15:53:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601895197M0100000058704_M01SCH20010406_1.PDF [05 Oct 2020 15:53:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 15:53:17] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398651/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601895197M0100000058704_M01SCH20010406_1.PDF [05 Oct 2020 16:29:06] (index) database connection response [05 Oct 2020 16:29:06] (index) getConnection(): Resource id #1 [05 Oct 2020 16:29:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 16:29:06] (index) database connection response [05 Oct 2020 16:29:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 16:29:06] (index) database connection response [05 Oct 2020 16:29:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 16:29:06] (index) database connection response [05 Oct 2020 16:29:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200420948' AND ACCESS_CODE = '79669974' [05 Oct 2020 16:29:06] (index) database connection response [05 Oct 2020 16:29:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200420948' AND ACCESS_CODE = '79669974' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 16:29:06] (index) database connection response [05 Oct 2020 16:29:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000637190' [05 Oct 2020 16:29:06] (index) database connection response [05 Oct 2020 16:29:06] (index) getPatientReportsDetail() entered [05 Oct 2020 16:29:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200420948', 'M0100000637190', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 16:29:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200420948', 'M0100000637190', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 16:29:06] (index) p_Stop=N [05 Oct 2020 16:29:06] (index) p_Alert= [05 Oct 2020 16:29:06] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 16:29:06] (index) database connection response [05 Oct 2020 16:29:06] (index) getConnectionClose() called.... [05 Oct 2020 16:29:06] (index) getConnectionClose() called.... [05 Oct 2020 18:22:10] (index) database connection response [05 Oct 2020 18:22:10] (index) getConnection(): Resource id #1 [05 Oct 2020 18:22:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 18:22:10] (index) database connection response [05 Oct 2020 18:22:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 18:22:10] (index) database connection response [05 Oct 2020 18:22:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 18:22:10] (index) database connection response [05 Oct 2020 18:22:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200421036' AND ACCESS_CODE = '69643051' [05 Oct 2020 18:22:10] (index) database connection response [05 Oct 2020 18:22:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200421036' AND ACCESS_CODE = '69643051' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 18:22:10] (index) database connection response [05 Oct 2020 18:22:10] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000080926' [05 Oct 2020 18:22:10] (index) database connection response [05 Oct 2020 18:22:10] (index) getPatientReportsDetail() entered [05 Oct 2020 18:22:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200421036', 'M0100000080926', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 18:22:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200421036', 'M0100000080926', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 18:22:10] (index) p_Stop=N [05 Oct 2020 18:22:10] (index) p_Alert= [05 Oct 2020 18:22:10] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 18:22:10] (index) database connection response [05 Oct 2020 18:22:10] (index) getConnectionClose() called.... [05 Oct 2020 18:22:10] (index) getConnectionClose() called.... [05 Oct 2020 18:22:22] (viewOnlineReports) database connection response [05 Oct 2020 18:22:22] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 18:22:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000080926', '001', '200398954', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 18:22:22] (viewOnlineReports) p_Stop=N [05 Oct 2020 18:22:22] (viewOnlineReports) p_Alert= [05 Oct 2020 18:22:22] (viewOnlineReports) Flag = 1 [05 Oct 2020 18:22: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', '200398954', 'M01', '047', '1', '001000000000085025', 'M0100000080926_M01HEM20013886_1.PDF', 'M0100000080926', SYSDATE) [05 Oct 2020 18:22:22] (viewOnlineReports) database connection response [05 Oct 2020 18:22:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398954' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 18:22:22] (viewOnlineReports) database connection response [05 Oct 2020 18:22:22] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 18:22:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398954/ [05 Oct 2020 18:22:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398954/ [05 Oct 2020 18:22:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398954/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601904142M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398954/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601904142M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [05 Oct 2020 18:22:22] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200398954/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601904142M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:33] (viewOnlineReports) database connection response [05 Oct 2020 18:22:33] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 18:22:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000080926', '001', '200398954', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 18:22:33] (viewOnlineReports) p_Stop=N [05 Oct 2020 18:22:33] (viewOnlineReports) p_Alert= [05 Oct 2020 18:22:33] (viewOnlineReports) Flag = 1 [05 Oct 2020 18:22: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', '200398954', 'M01', '047', '1', '001000000000085025', 'M0100000080926_M01HEM20013886_1.PDF', 'M0100000080926', SYSDATE) [05 Oct 2020 18:22:33] (viewOnlineReports) database connection response [05 Oct 2020 18:22:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398954' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 18:22:33] (viewOnlineReports) database connection response [05 Oct 2020 18:22:33] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 18:22:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398954/ [05 Oct 2020 18:22:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398954/ [05 Oct 2020 18:22:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398954/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601904153M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398954/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601904153M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [05 Oct 2020 18:22:33] (viewOnlineReports) Converting PDF to JPG with name as M0100000080926_M01HEM20013886_1.jpg [05 Oct 2020 18:22:33] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200398954/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601904153M0100000080926_M01HEM20013886_1.PDF ../../TEMP_PDF/200398954/M0100000080926_M01HEM20013886_1.jpg [05 Oct 2020 18:22:33] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200398954/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601904153M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:50] (viewOnlineReports) database connection response [05 Oct 2020 18:22:50] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 18:22:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000080926', '001', '200398954', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 18:22:50] (viewOnlineReports) p_Stop=N [05 Oct 2020 18:22:50] (viewOnlineReports) p_Alert= [05 Oct 2020 18:22:50] (viewOnlineReports) Flag = 1 [05 Oct 2020 18:22: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', '200398954', 'M01', '047', '1', '001000000000085025', 'M0100000080926_M01HEM20013886_1.PDF', 'M0100000080926', SYSDATE) [05 Oct 2020 18:22:50] (viewOnlineReports) database connection response [05 Oct 2020 18:22:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398954' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 18:22:50] (viewOnlineReports) database connection response [05 Oct 2020 18:22:50] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 18:22:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398954/ [05 Oct 2020 18:22:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398954/ [05 Oct 2020 18:22:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398954/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601904170M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398954/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601904170M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:22:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [05 Oct 2020 18:22:50] (viewOnlineReports) Converting PDF to JPG with name as M0100000080926_M01HEM20013886_1.jpg [05 Oct 2020 18:22:50] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200398954/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601904170M0100000080926_M01HEM20013886_1.PDF ../../TEMP_PDF/200398954/M0100000080926_M01HEM20013886_1.jpg [05 Oct 2020 18:22:50] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200398954/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601904170M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:25:24] (index) database connection response [05 Oct 2020 18:25:24] (index) getConnection(): Resource id #1 [05 Oct 2020 18:25:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 18:25:24] (index) database connection response [05 Oct 2020 18:25:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 18:25:24] (index) database connection response [05 Oct 2020 18:25:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 18:25:24] (index) database connection response [05 Oct 2020 18:25:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200421036' AND ACCESS_CODE = '69643051' [05 Oct 2020 18:25:24] (index) database connection response [05 Oct 2020 18:25:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200421036' AND ACCESS_CODE = '69643051' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 18:25:24] (index) database connection response [05 Oct 2020 18:25:24] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000080926' [05 Oct 2020 18:25:24] (index) database connection response [05 Oct 2020 18:25:24] (index) getPatientReportsDetail() entered [05 Oct 2020 18:25:24] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200421036', 'M0100000080926', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 18:25:24] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200421036', 'M0100000080926', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 18:25:24] (index) p_Stop=N [05 Oct 2020 18:25:24] (index) p_Alert= [05 Oct 2020 18:25: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 [05 Oct 2020 18:25:24] (index) database connection response [05 Oct 2020 18:25:24] (index) getConnectionClose() called.... [05 Oct 2020 18:25:24] (index) getConnectionClose() called.... [05 Oct 2020 18:25:29] (viewOnlineReports) database connection response [05 Oct 2020 18:25:29] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 18:25:29] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000080926', '001', '200398954', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 18:25:29] (viewOnlineReports) p_Stop=N [05 Oct 2020 18:25:29] (viewOnlineReports) p_Alert= [05 Oct 2020 18:25:29] (viewOnlineReports) Flag = 1 [05 Oct 2020 18:25: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', '200398954', 'M01', '047', '1', '001000000000085025', 'M0100000080926_M01HEM20013886_1.PDF', 'M0100000080926', SYSDATE) [05 Oct 2020 18:25:29] (viewOnlineReports) database connection response [05 Oct 2020 18:25:29] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398954' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 18:25:29] (viewOnlineReports) database connection response [05 Oct 2020 18:25:29] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 18:25:29] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398954/ [05 Oct 2020 18:25:29] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398954/ [05 Oct 2020 18:25:29] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:25:29] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398954/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601904329M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:25:29] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398954/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601904329M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 18:25:29] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [05 Oct 2020 18:25:29] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200398954/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601904329M0100000080926_M01HEM20013886_1.PDF [05 Oct 2020 19:11:52] (index) database connection response [05 Oct 2020 19:11:52] (index) getConnection(): Resource id #1 [05 Oct 2020 19:11:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 19:11:52] (index) database connection response [05 Oct 2020 19:11:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 19:11:52] (index) database connection response [05 Oct 2020 19:11:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 19:11:52] (index) database connection response [05 Oct 2020 19:11:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' [05 Oct 2020 19:11:52] (index) database connection response [05 Oct 2020 19:11:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 19:11:52] (index) database connection response [05 Oct 2020 19:11:52] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000621065' [05 Oct 2020 19:11:52] (index) database connection response [05 Oct 2020 19:11:52] (index) getPatientReportsDetail() entered [05 Oct 2020 19:11:52] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 19:11:52] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 19:11:52] (index) p_Stop=N [05 Oct 2020 19:11:52] (index) p_Alert= [05 Oct 2020 19:11:52] (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 [05 Oct 2020 19:11:52] (index) database connection response [05 Oct 2020 19:11:52] (index) getConnectionClose() called.... [05 Oct 2020 19:11:52] (index) getConnectionClose() called.... [05 Oct 2020 20:32:11] (index) database connection response [05 Oct 2020 20:32:11] (index) getConnection(): Resource id #1 [05 Oct 2020 20:32:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 20:32:11] (index) database connection response [05 Oct 2020 20:32:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 20:32:11] (index) database connection response [05 Oct 2020 20:32:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 20:32:11] (index) database connection response [05 Oct 2020 20:32:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '000-96148' AND ACCESS_CODE = '000-96148' [05 Oct 2020 20:32:12] (index) database connection response [05 Oct 2020 20:32:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '000-96148' AND ACCESS_CODE = '000-96148' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 20:32:12] (index) database connection response [05 Oct 2020 20:32:12] (index) getConnectionClose() called.... [05 Oct 2020 21:20:25] (index) database connection response [05 Oct 2020 21:20:25] (index) getConnection(): Resource id #1 [05 Oct 2020 21:20:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 21:20:25] (index) database connection response [05 Oct 2020 21:20:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 21:20:25] (index) database connection response [05 Oct 2020 21:20:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 21:20:25] (index) database connection response [05 Oct 2020 21:20:25] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316845' AND ACCESS_CODE = '81336182' [05 Oct 2020 21:20:25] (index) database connection response [05 Oct 2020 21:20:25] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316845' AND ACCESS_CODE = '81336182' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 21:20:25] (index) database connection response [05 Oct 2020 21:20:25] (index) getConnectionClose() called.... [05 Oct 2020 21:21:02] (index) database connection response [05 Oct 2020 21:21:02] (index) getConnection(): Resource id #1 [05 Oct 2020 21:21:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 21:21:02] (index) database connection response [05 Oct 2020 21:21:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 21:21:02] (index) database connection response [05 Oct 2020 21:21:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 21:21:02] (index) database connection response [05 Oct 2020 21:21:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316845' AND ACCESS_CODE = '81326182' [05 Oct 2020 21:21:02] (index) database connection response [05 Oct 2020 21:21:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316845' AND ACCESS_CODE = '81326182' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 21:21:02] (index) database connection response [05 Oct 2020 21:21:02] (index) getConnectionClose() called.... [05 Oct 2020 21:34:31] (index) database connection response [05 Oct 2020 21:34:31] (index) getConnection(): Resource id #1 [05 Oct 2020 21:34:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 21:34:31] (index) database connection response [05 Oct 2020 21:34:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 21:34:31] (index) database connection response [05 Oct 2020 21:34:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 21:34:31] (index) database connection response [05 Oct 2020 21:34:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200421172' AND ACCESS_CODE = '58790911' [05 Oct 2020 21:34:31] (index) database connection response [05 Oct 2020 21:34:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200421172' AND ACCESS_CODE = '58790911' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 21:34:31] (index) database connection response [05 Oct 2020 21:34:31] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000596259' [05 Oct 2020 21:34:31] (index) database connection response [05 Oct 2020 21:34:31] (index) getPatientReportsDetail() entered [05 Oct 2020 21:34:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200421172', 'M0100000596259', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:34:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200421172', 'M0100000596259', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:34:31] (index) p_Stop=N [05 Oct 2020 21:34:31] (index) p_Alert= [05 Oct 2020 21:34: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 [05 Oct 2020 21:34:31] (index) database connection response [05 Oct 2020 21:34:31] (index) getConnectionClose() called.... [05 Oct 2020 21:34:31] (index) getConnectionClose() called.... [05 Oct 2020 21:34:51] (viewOnlineReports) database connection response [05 Oct 2020 21:34:51] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 21:34:51] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000596259', '001', '200399015', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:34:51] (viewOnlineReports) p_Stop=N [05 Oct 2020 21:34:51] (viewOnlineReports) p_Alert= [05 Oct 2020 21:34:51] (viewOnlineReports) Flag = 1 [05 Oct 2020 21:34:51] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200399015', 'M01', '047', '1', '001000000000085025', 'M0100000596259_M01HEM20013890_1.PDF', 'M0100000596259', SYSDATE) [05 Oct 2020 21:34:51] (viewOnlineReports) database connection response [05 Oct 2020 21:34:51] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200399015' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 21:34:51] (viewOnlineReports) database connection response [05 Oct 2020 21:34:51] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 21:34:51] (viewOnlineReports) creating directory structure../../TEMP_PDF/200399015/ [05 Oct 2020 21:34:51] (viewOnlineReports) directory structure created ../../TEMP_PDF/200399015/ [05 Oct 2020 21:34:51] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000596259_M01HEM20013890_1.PDF [05 Oct 2020 21:34:51] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200399015/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601915691M0100000596259_M01HEM20013890_1.PDF [05 Oct 2020 21:34:51] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200399015/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601915691M0100000596259_M01HEM20013890_1.PDF [05 Oct 2020 21:34:51] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [05 Oct 2020 21:34:51] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200399015/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601915691M0100000596259_M01HEM20013890_1.PDF [05 Oct 2020 21:42:09] (index) database connection response [05 Oct 2020 21:42:09] (index) getConnection(): Resource id #1 [05 Oct 2020 21:42:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 21:42:09] (index) database connection response [05 Oct 2020 21:42:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 21:42:09] (index) database connection response [05 Oct 2020 21:42:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 21:42:09] (index) database connection response [05 Oct 2020 21:42:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200420893' AND ACCESS_CODE = '81326182' [05 Oct 2020 21:42:09] (index) database connection response [05 Oct 2020 21:42:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200420893' AND ACCESS_CODE = '81326182' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 21:42:09] (index) database connection response [05 Oct 2020 21:42:09] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000637184' [05 Oct 2020 21:42:09] (index) database connection response [05 Oct 2020 21:42:09] (index) getPatientReportsDetail() entered [05 Oct 2020 21:42:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200420893', 'M0100000637184', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:42:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200420893', 'M0100000637184', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:42:09] (index) p_Stop=N [05 Oct 2020 21:42:09] (index) p_Alert= [05 Oct 2020 21:42:09] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 21:42:09] (index) database connection response [05 Oct 2020 21:42:09] (index) getConnectionClose() called.... [05 Oct 2020 21:42:09] (index) getConnectionClose() called.... [05 Oct 2020 21:42:22] (viewOnlineReports) database connection response [05 Oct 2020 21:42:22] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 21:42:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000637184', '001', '200398891', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:42:22] (viewOnlineReports) p_Stop=N [05 Oct 2020 21:42:22] (viewOnlineReports) p_Alert= [05 Oct 2020 21:42:22] (viewOnlineReports) Flag = 1 [05 Oct 2020 21:42: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', '200398891', 'M01', '070', '1', '001000000000084702', 'M0100000637184_M01SCH20010420_1.PDF', 'M0100000637184', SYSDATE) [05 Oct 2020 21:42:22] (viewOnlineReports) database connection response [05 Oct 2020 21:42:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398891' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [05 Oct 2020 21:42:22] (viewOnlineReports) database connection response [05 Oct 2020 21:42:22] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 21:42:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398891/ [05 Oct 2020 21:42:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398891/ [05 Oct 2020 21:42:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000637184_M01SCH20010420_1.PDF [05 Oct 2020 21:42:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398891/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601916142M0100000637184_M01SCH20010420_1.PDF [05 Oct 2020 21:42:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398891/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601916142M0100000637184_M01SCH20010420_1.PDF [05 Oct 2020 21:42:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [05 Oct 2020 21:42:22] (viewOnlineReports) Converting PDF to JPG with name as M0100000637184_M01SCH20010420_1.jpg [05 Oct 2020 21:42:22] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200398891/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601916142M0100000637184_M01SCH20010420_1.PDF ../../TEMP_PDF/200398891/M0100000637184_M01SCH20010420_1.jpg [05 Oct 2020 21:42:22] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200398891/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601916142M0100000637184_M01SCH20010420_1.PDF [05 Oct 2020 21:42:34] (viewOnlineReports) database connection response [05 Oct 2020 21:42:34] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 21:42:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000637184', '001', '200398891', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:42:34] (viewOnlineReports) p_Stop=N [05 Oct 2020 21:42:34] (viewOnlineReports) p_Alert= [05 Oct 2020 21:42:34] (viewOnlineReports) Flag = 1 [05 Oct 2020 21:42: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', '200398891', 'M01', '070', '1', '001000000000084702', 'M0100000637184_M01SCH20010420_1.PDF', 'M0100000637184', SYSDATE) [05 Oct 2020 21:42:34] (viewOnlineReports) database connection response [05 Oct 2020 21:42:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200398891' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [05 Oct 2020 21:42:34] (viewOnlineReports) database connection response [05 Oct 2020 21:42:34] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 21:42:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200398891/ [05 Oct 2020 21:42:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200398891/ [05 Oct 2020 21:42:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000637184_M01SCH20010420_1.PDF [05 Oct 2020 21:42:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200398891/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1601916154M0100000637184_M01SCH20010420_1.PDF [05 Oct 2020 21:42:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200398891/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1601916154M0100000637184_M01SCH20010420_1.PDF [05 Oct 2020 21:42:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 21:42:34] (viewOnlineReports) Downloading file ../../TEMP_PDF/200398891/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1601916154M0100000637184_M01SCH20010420_1.PDF [05 Oct 2020 21:57:41] (index) database connection response [05 Oct 2020 21:57:41] (index) getConnection(): Resource id #1 [05 Oct 2020 21:57:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 21:57:41] (index) database connection response [05 Oct 2020 21:57:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 21:57:41] (index) database connection response [05 Oct 2020 21:57:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 21:57:41] (index) database connection response [05 Oct 2020 21:57:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422597' AND ACCESS_CODE = '46419710' [05 Oct 2020 21:57:42] (index) database connection response [05 Oct 2020 21:57:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422597' AND ACCESS_CODE = '46419710' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 21:57:42] (index) database connection response [05 Oct 2020 21:57:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000005732' [05 Oct 2020 21:57:42] (index) database connection response [05 Oct 2020 21:57:42] (index) getPatientReportsDetail() entered [05 Oct 2020 21:57:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422597', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:57:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422597', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 21:57:42] (index) p_Stop=N [05 Oct 2020 21:57:42] (index) p_Alert= [05 Oct 2020 21:57:42] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 21:57:42] (index) database connection response [05 Oct 2020 21:57:42] (index) getConnectionClose() called.... [05 Oct 2020 21:57:42] (index) getConnectionClose() called.... [05 Oct 2020 22:00:00] (index) database connection response [05 Oct 2020 22:00:00] (index) getConnection(): Resource id #1 [05 Oct 2020 22:00:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 22:00:00] (index) database connection response [05 Oct 2020 22:00:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 22:00:00] (index) database connection response [05 Oct 2020 22:00:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 22:00:00] (index) database connection response [05 Oct 2020 22:00:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' [05 Oct 2020 22:00:00] (index) database connection response [05 Oct 2020 22:00:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 22:00:00] (index) database connection response [05 Oct 2020 22:00:00] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000005732' [05 Oct 2020 22:00:00] (index) database connection response [05 Oct 2020 22:00:00] (index) getPatientReportsDetail() entered [05 Oct 2020 22:00:00] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 22:00:00] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 22:00:00] (index) p_Stop=N [05 Oct 2020 22:00:00] (index) p_Alert= [05 Oct 2020 22:00:00] (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 [05 Oct 2020 22:00:00] (index) database connection response [05 Oct 2020 22:00:00] (index) getConnectionClose() called.... [05 Oct 2020 22:00:00] (index) getConnectionClose() called.... [05 Oct 2020 22:26:04] (index) database connection response [05 Oct 2020 22:26:04] (index) getConnection(): Resource id #1 [05 Oct 2020 22:26:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 22:26:04] (index) database connection response [05 Oct 2020 22:26:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 22:26:04] (index) database connection response [05 Oct 2020 22:26:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 22:26:04] (index) database connection response [05 Oct 2020 22:26:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' [05 Oct 2020 22:26:04] (index) database connection response [05 Oct 2020 22:26:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200416876' AND ACCESS_CODE = '25216139' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 22:26:04] (index) database connection response [05 Oct 2020 22:26:04] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000621065' [05 Oct 2020 22:26:04] (index) database connection response [05 Oct 2020 22:26:04] (index) getPatientReportsDetail() entered [05 Oct 2020 22:26:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 22:26:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200416876', 'M0100000621065', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 22:26:04] (index) p_Stop=N [05 Oct 2020 22:26:04] (index) p_Alert= [05 Oct 2020 22:26:04] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 22:26:04] (index) database connection response [05 Oct 2020 22:26:04] (index) getConnectionClose() called.... [05 Oct 2020 22:26:04] (index) getConnectionClose() called.... [05 Oct 2020 22:26:13] (viewOnlineReports) database connection response [05 Oct 2020 22:26:13] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 22:26:13] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '057', 'M0100000621065', '001', '200397697', '1', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 22:26:13] (viewOnlineReports) p_Stop=N [05 Oct 2020 22:26:13] (viewOnlineReports) p_Alert= [05 Oct 2020 22:26:13] (viewOnlineReports) Flag = 1 [05 Oct 2020 22:26:13] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200397697', 'M01', '057', '1', '001000000000087086', 'M0100000621065_M01MIC20007500_1.PDF', 'M0100000621065', SYSDATE) [05 Oct 2020 22:26:13] (viewOnlineReports) database connection response [05 Oct 2020 22:26:13] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200397697' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '057' AND TRANSACTION_NO = '1' [05 Oct 2020 22:26:13] (viewOnlineReports) database connection response [05 Oct 2020 22:26:13] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 22:26:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200397697/ [05 Oct 2020 22:26:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200397697/ [05 Oct 2020 22:26:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000621065_M01MIC20007500_1.PDF [05 Oct 2020 22:26:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200397697/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1601918773M0100000621065_M01MIC20007500_1.PDF [05 Oct 2020 22:26:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200397697/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1601918773M0100000621065_M01MIC20007500_1.PDF [05 Oct 2020 22:26:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 22:26:13] (viewOnlineReports) Downloading file ../../TEMP_PDF/200397697/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1601918773M0100000621065_M01MIC20007500_1.PDF [05 Oct 2020 23:05:02] (index) database connection response [05 Oct 2020 23:05:02] (index) getConnection(): Resource id #1 [05 Oct 2020 23:05:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:05:02] (index) database connection response [05 Oct 2020 23:05:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:05:02] (index) database connection response [05 Oct 2020 23:05:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:05:02] (index) database connection response [05 Oct 2020 23:05:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' [05 Oct 2020 23:05:02] (index) database connection response [05 Oct 2020 23:05:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:05:02] (index) database connection response [05 Oct 2020 23:05:02] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000005732' [05 Oct 2020 23:05:02] (index) database connection response [05 Oct 2020 23:05:02] (index) getPatientReportsDetail() entered [05 Oct 2020 23:05:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:05:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:05:02] (index) p_Stop=N [05 Oct 2020 23:05:02] (index) p_Alert= [05 Oct 2020 23:05:02] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 23:05:02] (index) database connection response [05 Oct 2020 23:05:02] (index) getConnectionClose() called.... [05 Oct 2020 23:05:02] (index) getConnectionClose() called.... [05 Oct 2020 23:06:50] (index) database connection response [05 Oct 2020 23:06:50] (index) getConnection(): Resource id #1 [05 Oct 2020 23:06:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:06:50] (index) database connection response [05 Oct 2020 23:06:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:06:50] (index) database connection response [05 Oct 2020 23:06:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:06:50] (index) database connection response [05 Oct 2020 23:06:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422597' AND ACCESS_CODE = '46419710' [05 Oct 2020 23:06:50] (index) database connection response [05 Oct 2020 23:06:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422597' AND ACCESS_CODE = '46419710' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:06:50] (index) database connection response [05 Oct 2020 23:06:50] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000005732' [05 Oct 2020 23:06:50] (index) database connection response [05 Oct 2020 23:06:50] (index) getPatientReportsDetail() entered [05 Oct 2020 23:06:50] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422597', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:06:50] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422597', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:06:50] (index) p_Stop=N [05 Oct 2020 23:06:50] (index) p_Alert= [05 Oct 2020 23:06:50] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 23:06:50] (index) database connection response [05 Oct 2020 23:06:50] (index) getConnectionClose() called.... [05 Oct 2020 23:06:50] (index) getConnectionClose() called.... [05 Oct 2020 23:07:12] (viewOnlineReports) database connection response [05 Oct 2020 23:07:12] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 23:07:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000005732', '001', '200399636', '1', '001000000000081256', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:07:12] (viewOnlineReports) p_Stop=N [05 Oct 2020 23:07:12] (viewOnlineReports) p_Alert= [05 Oct 2020 23:07:12] (viewOnlineReports) Flag = 1 [05 Oct 2020 23:07:12] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200399636', 'M01', '047', '1', '001000000000081256', 'M0100000005732_M01MIC20007623_1.PDF', 'M0100000005732', SYSDATE) [05 Oct 2020 23:07:12] (viewOnlineReports) database connection response [05 Oct 2020 23:07:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200399636' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 23:07:12] (viewOnlineReports) database connection response [05 Oct 2020 23:07:12] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 23:07:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200399636/ [05 Oct 2020 23:07:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200399636/ [05 Oct 2020 23:07:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000005732_M01MIC20007623_1.PDF [05 Oct 2020 23:07:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200399636/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601921232M0100000005732_M01MIC20007623_1.PDF [05 Oct 2020 23:07:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200399636/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601921232M0100000005732_M01MIC20007623_1.PDF [05 Oct 2020 23:07:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 23:07:12] (viewOnlineReports) Downloading file ../../TEMP_PDF/200399636/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601921232M0100000005732_M01MIC20007623_1.PDF [05 Oct 2020 23:07:34] (viewOnlineReports) database connection response [05 Oct 2020 23:07:34] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 23:07:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000005732', '001', '200399636', '2', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:07:34] (viewOnlineReports) p_Stop=N [05 Oct 2020 23:07:34] (viewOnlineReports) p_Alert= [05 Oct 2020 23:07:34] (viewOnlineReports) Flag = 1 [05 Oct 2020 23:07: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', '200399636', 'M01', '047', '2', '001000000000086354', 'M0100000005732_M01MIC20007623_2.PDF', 'M0100000005732', SYSDATE) [05 Oct 2020 23:07:34] (viewOnlineReports) database connection response [05 Oct 2020 23:07:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200399636' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [05 Oct 2020 23:07:34] (viewOnlineReports) database connection response [05 Oct 2020 23:07:34] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 23:07:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200399636/ [05 Oct 2020 23:07:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200399636/ [05 Oct 2020 23:07:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000005732_M01MIC20007623_2.PDF [05 Oct 2020 23:07:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200399636/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601921254M0100000005732_M01MIC20007623_2.PDF [05 Oct 2020 23:07:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200399636/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601921254M0100000005732_M01MIC20007623_2.PDF [05 Oct 2020 23:07:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [05 Oct 2020 23:07:34] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200399636/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601921254M0100000005732_M01MIC20007623_2.PDF [05 Oct 2020 23:07:48] (viewOnlineReports) database connection response [05 Oct 2020 23:07:48] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 23:07:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000005732', '001', '200399636', '1', '001000000000081256', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:07:48] (viewOnlineReports) p_Stop=N [05 Oct 2020 23:07:48] (viewOnlineReports) p_Alert= [05 Oct 2020 23:07:48] (viewOnlineReports) Flag = 1 [05 Oct 2020 23:07: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', '200399636', 'M01', '047', '1', '001000000000081256', 'M0100000005732_M01MIC20007623_1.PDF', 'M0100000005732', SYSDATE) [05 Oct 2020 23:07:48] (viewOnlineReports) database connection response [05 Oct 2020 23:07:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200399636' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [05 Oct 2020 23:07:48] (viewOnlineReports) database connection response [05 Oct 2020 23:07:48] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 23:07:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200399636/ [05 Oct 2020 23:07:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200399636/ [05 Oct 2020 23:07:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000005732_M01MIC20007623_1.PDF [05 Oct 2020 23:07:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200399636/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601921268M0100000005732_M01MIC20007623_1.PDF [05 Oct 2020 23:07:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200399636/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601921268M0100000005732_M01MIC20007623_1.PDF [05 Oct 2020 23:07:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 23:07:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200399636/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601921268M0100000005732_M01MIC20007623_1.PDF [05 Oct 2020 23:08:24] (viewOnlineReports) database connection response [05 Oct 2020 23:08:24] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 23:08:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000005732', '001', '200399636', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:08:24] (viewOnlineReports) p_Stop=N [05 Oct 2020 23:08:24] (viewOnlineReports) p_Alert= [05 Oct 2020 23:08:24] (viewOnlineReports) Flag = 1 [05 Oct 2020 23:08:24] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200399636', 'M01', '047', '3', '001000000000082047', 'M0100000005732_M01RCH20018842_1.PDF', 'M0100000005732', SYSDATE) [05 Oct 2020 23:08:24] (viewOnlineReports) database connection response [05 Oct 2020 23:08:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200399636' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [05 Oct 2020 23:08:24] (viewOnlineReports) database connection response [05 Oct 2020 23:08:24] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 23:08:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200399636/ [05 Oct 2020 23:08:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200399636/ [05 Oct 2020 23:08:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000005732_M01RCH20018842_1.PDF [05 Oct 2020 23:08:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200399636/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1601921303M0100000005732_M01RCH20018842_1.PDF [05 Oct 2020 23:08:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200399636/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1601921303M0100000005732_M01RCH20018842_1.PDF [05 Oct 2020 23:08:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 23:08:24] (viewOnlineReports) Downloading file ../../TEMP_PDF/200399636/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1601921303M0100000005732_M01RCH20018842_1.PDF [05 Oct 2020 23:09:53] (viewOnlineReports) database connection response [05 Oct 2020 23:09:53] (viewOnlineReports) getConnection(): Resource id #1 [05 Oct 2020 23:09:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000005732', '001', '200399636', '2', '001000000000086354', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:09:53] (viewOnlineReports) p_Stop=N [05 Oct 2020 23:09:53] (viewOnlineReports) p_Alert= [05 Oct 2020 23:09:53] (viewOnlineReports) Flag = 1 [05 Oct 2020 23:09:53] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200399636', 'M01', '047', '2', '001000000000086354', 'M0100000005732_M01MIC20007623_2.PDF', 'M0100000005732', SYSDATE) [05 Oct 2020 23:09:53] (viewOnlineReports) database connection response [05 Oct 2020 23:09:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200399636' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [05 Oct 2020 23:09:53] (viewOnlineReports) database connection response [05 Oct 2020 23:09:53] (viewOnlineReports) getConnectionClose() called.... [05 Oct 2020 23:09:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200399636/ [05 Oct 2020 23:09:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200399636/ [05 Oct 2020 23:09:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201005\M01\M0100000005732_M01MIC20007623_2.PDF [05 Oct 2020 23:09:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200399636/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601921393M0100000005732_M01MIC20007623_2.PDF [05 Oct 2020 23:09:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200399636/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601921393M0100000005732_M01MIC20007623_2.PDF [05 Oct 2020 23:09:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [05 Oct 2020 23:09:53] (viewOnlineReports) Downloading file ../../TEMP_PDF/200399636/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601921393M0100000005732_M01MIC20007623_2.PDF [05 Oct 2020 23:14:36] (index) database connection response [05 Oct 2020 23:14:36] (index) getConnection(): Resource id #1 [05 Oct 2020 23:14:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:14:36] (index) database connection response [05 Oct 2020 23:14:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:14:36] (index) database connection response [05 Oct 2020 23:14:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:14:36] (index) database connection response [05 Oct 2020 23:14:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' [05 Oct 2020 23:14:36] (index) database connection response [05 Oct 2020 23:14:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:14:36] (index) database connection response [05 Oct 2020 23:14:36] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000005732' [05 Oct 2020 23:14:36] (index) database connection response [05 Oct 2020 23:14:36] (index) getPatientReportsDetail() entered [05 Oct 2020 23:14:36] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:14:36] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:14:36] (index) p_Stop=N [05 Oct 2020 23:14:36] (index) p_Alert= [05 Oct 2020 23:14:36] (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 [05 Oct 2020 23:14:36] (index) database connection response [05 Oct 2020 23:14:36] (index) getConnectionClose() called.... [05 Oct 2020 23:14:36] (index) getConnectionClose() called.... [05 Oct 2020 23:16:13] (index) database connection response [05 Oct 2020 23:16:13] (index) getConnection(): Resource id #1 [05 Oct 2020 23:16:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:16:13] (index) database connection response [05 Oct 2020 23:16:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:16:13] (index) database connection response [05 Oct 2020 23:16:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:16:13] (index) database connection response [05 Oct 2020 23:16:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '58706566' [05 Oct 2020 23:16:13] (index) database connection response [05 Oct 2020 23:16:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '58706566' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:16:13] (index) database connection response [05 Oct 2020 23:16:13] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000053965' [05 Oct 2020 23:16:13] (index) database connection response [05 Oct 2020 23:16:13] (index) getPatientReportsDetail() entered [05 Oct 2020 23:16:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422603', 'M0100000053965', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:16:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422603', 'M0100000053965', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:16:13] (index) p_Stop=N [05 Oct 2020 23:16:13] (index) p_Alert= [05 Oct 2020 23:16: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 [05 Oct 2020 23:16:13] (index) database connection response [05 Oct 2020 23:16:13] (index) getConnectionClose() called.... [05 Oct 2020 23:16:13] (index) getConnectionClose() called.... [05 Oct 2020 23:29:00] (index) database connection response [05 Oct 2020 23:29:00] (index) getConnection(): Resource id #1 [05 Oct 2020 23:29:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:29:00] (index) database connection response [05 Oct 2020 23:29:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:29:00] (index) database connection response [05 Oct 2020 23:29:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:29:00] (index) database connection response [05 Oct 2020 23:29:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '50706566' [05 Oct 2020 23:29:00] (index) database connection response [05 Oct 2020 23:29:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '50706566' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:29:00] (index) database connection response [05 Oct 2020 23:29:00] (index) getConnectionClose() called.... [05 Oct 2020 23:29:34] (index) database connection response [05 Oct 2020 23:29:34] (index) getConnection(): Resource id #1 [05 Oct 2020 23:29:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:29:34] (index) database connection response [05 Oct 2020 23:29:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:29:34] (index) database connection response [05 Oct 2020 23:29:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:29:34] (index) database connection response [05 Oct 2020 23:29:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '50706566' [05 Oct 2020 23:29:34] (index) database connection response [05 Oct 2020 23:29:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '50706566' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:29:34] (index) database connection response [05 Oct 2020 23:29:34] (index) getConnectionClose() called.... [05 Oct 2020 23:30:23] (index) database connection response [05 Oct 2020 23:30:23] (index) getConnection(): Resource id #1 [05 Oct 2020 23:30:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:30:23] (index) database connection response [05 Oct 2020 23:30:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:30:23] (index) database connection response [05 Oct 2020 23:30:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:30:23] (index) database connection response [05 Oct 2020 23:30:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '58706566' [05 Oct 2020 23:30:23] (index) database connection response [05 Oct 2020 23:30:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '58706566' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:30:23] (index) database connection response [05 Oct 2020 23:30:23] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000053965' [05 Oct 2020 23:30:23] (index) database connection response [05 Oct 2020 23:30:23] (index) getPatientReportsDetail() entered [05 Oct 2020 23:30:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422603', 'M0100000053965', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:30:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422603', 'M0100000053965', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:30:23] (index) p_Stop=N [05 Oct 2020 23:30:23] (index) p_Alert= [05 Oct 2020 23:30:23] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 23:30:23] (index) database connection response [05 Oct 2020 23:30:23] (index) getConnectionClose() called.... [05 Oct 2020 23:30:23] (index) getConnectionClose() called.... [05 Oct 2020 23:31:42] (index) database connection response [05 Oct 2020 23:31:42] (index) getConnection(): Resource id #1 [05 Oct 2020 23:31:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:31:42] (index) database connection response [05 Oct 2020 23:31:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:31:42] (index) database connection response [05 Oct 2020 23:31:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:31:42] (index) database connection response [05 Oct 2020 23:31:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' [05 Oct 2020 23:31:42] (index) database connection response [05 Oct 2020 23:31:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:31:42] (index) database connection response [05 Oct 2020 23:31:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000005732' [05 Oct 2020 23:31:42] (index) database connection response [05 Oct 2020 23:31:42] (index) getPatientReportsDetail() entered [05 Oct 2020 23:31:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:31:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:31:42] (index) p_Stop=N [05 Oct 2020 23:31:42] (index) p_Alert= [05 Oct 2020 23:31:42] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 23:31:42] (index) database connection response [05 Oct 2020 23:31:42] (index) getConnectionClose() called.... [05 Oct 2020 23:31:42] (index) getConnectionClose() called.... [05 Oct 2020 23:45:14] (index) database connection response [05 Oct 2020 23:45:14] (index) getConnection(): Resource id #1 [05 Oct 2020 23:45:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:45:14] (index) database connection response [05 Oct 2020 23:45:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:45:14] (index) database connection response [05 Oct 2020 23:45:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:45:14] (index) database connection response [05 Oct 2020 23:45:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' [05 Oct 2020 23:45:14] (index) database connection response [05 Oct 2020 23:45:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422600' AND ACCESS_CODE = '13806077' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:45:14] (index) database connection response [05 Oct 2020 23:45:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000005732' [05 Oct 2020 23:45:14] (index) database connection response [05 Oct 2020 23:45:14] (index) getPatientReportsDetail() entered [05 Oct 2020 23:45:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:45:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422600', 'M0100000005732', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:45:14] (index) p_Stop=N [05 Oct 2020 23:45:14] (index) p_Alert= [05 Oct 2020 23:45: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 [05 Oct 2020 23:45:14] (index) database connection response [05 Oct 2020 23:45:14] (index) getConnectionClose() called.... [05 Oct 2020 23:45:14] (index) getConnectionClose() called.... [05 Oct 2020 23:46:50] (index) database connection response [05 Oct 2020 23:46:50] (index) getConnection(): Resource id #1 [05 Oct 2020 23:46:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'POP-UP' [05 Oct 2020 23:46:50] (index) database connection response [05 Oct 2020 23:46:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'PLUG-IN' [05 Oct 2020 23:46:50] (index) database connection response [05 Oct 2020 23:46:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '12' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [05 Oct 2020 23:46:50] (index) database connection response [05 Oct 2020 23:46:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '58706566' [05 Oct 2020 23:46:50] (index) database connection response [05 Oct 2020 23:46:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200422603' AND ACCESS_CODE = '58706566' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [05 Oct 2020 23:46:50] (index) database connection response [05 Oct 2020 23:46:50] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000053965' [05 Oct 2020 23:46:50] (index) database connection response [05 Oct 2020 23:46:50] (index) getPatientReportsDetail() entered [05 Oct 2020 23:46:50] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422603', 'M0100000053965', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:46:50] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200422603', 'M0100000053965', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [05 Oct 2020 23:46:50] (index) p_Stop=N [05 Oct 2020 23:46:50] (index) p_Alert= [05 Oct 2020 23:46:50] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [05 Oct 2020 23:46:50] (index) database connection response [05 Oct 2020 23:46:50] (index) getConnectionClose() called.... [05 Oct 2020 23:46:50] (index) getConnectionClose() called....