[30 Sep 2020 00:03:59] (index) database connection response [30 Sep 2020 00:03:59] (index) getConnection(): Resource id #1 [30 Sep 2020 00:03:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 00:03:59] (index) database connection response [30 Sep 2020 00:03:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 00:03:59] (index) database connection response [30 Sep 2020 00:03:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 00:03:59] (index) database connection response [30 Sep 2020 00:03:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411103' AND ACCESS_CODE = '36234918' [30 Sep 2020 00:03:59] (index) database connection response [30 Sep 2020 00:03:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411103' AND ACCESS_CODE = '36234918' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 00:03:59] (index) database connection response [30 Sep 2020 00:03:59] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000031392' [30 Sep 2020 00:03:59] (index) database connection response [30 Sep 2020 00:03:59] (index) getPatientReportsDetail() entered [30 Sep 2020 00:03:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411103', 'M0100000031392', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:03:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411103', 'M0100000031392', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:03:59] (index) p_Stop=N [30 Sep 2020 00:03:59] (index) p_Alert= [30 Sep 2020 00:03:59] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 00:03:59] (index) database connection response [30 Sep 2020 00:03:59] (index) getConnectionClose() called.... [30 Sep 2020 00:03:59] (index) getConnectionClose() called.... [30 Sep 2020 00:04:27] (viewOnlineReports) database connection response [30 Sep 2020 00:04:27] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 00:04:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000031392', '001', '200395736', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:04:27] (viewOnlineReports) p_Stop=N [30 Sep 2020 00:04:27] (viewOnlineReports) p_Alert= [30 Sep 2020 00:04:27] (viewOnlineReports) Flag = 1 [30 Sep 2020 00:04:27] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395736', 'M01', '047', '1', '001000000000081028', 'M0100000031392_M01RCH20018292_1.PDF', 'M0100000031392', SYSDATE) [30 Sep 2020 00:04:27] (viewOnlineReports) database connection response [30 Sep 2020 00:04:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395736' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [30 Sep 2020 00:04:27] (viewOnlineReports) database connection response [30 Sep 2020 00:04:27] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 00:04:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395736/ [30 Sep 2020 00:04:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395736/ [30 Sep 2020 00:04:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:04:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601406267M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:04:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601406267M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:04:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 00:04:28] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601406267M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:04:35] (viewOnlineReports) database connection response [30 Sep 2020 00:04:35] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 00:04:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000031392', '001', '200395736', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:04:35] (viewOnlineReports) p_Stop=N [30 Sep 2020 00:04:35] (viewOnlineReports) p_Alert= [30 Sep 2020 00:04:35] (viewOnlineReports) Flag = 1 [30 Sep 2020 00:04:35] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395736', 'M01', '047', '1', '001000000000081028', 'M0100000031392_M01RCH20018292_1.PDF', 'M0100000031392', SYSDATE) [30 Sep 2020 00:04:35] (viewOnlineReports) database connection response [30 Sep 2020 00:04:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395736' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [30 Sep 2020 00:04:35] (viewOnlineReports) database connection response [30 Sep 2020 00:04:35] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 00:04:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395736/ [30 Sep 2020 00:04:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395736/ [30 Sep 2020 00:04:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:04:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601406275M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:04:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601406275M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:04:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 00:04:35] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601406275M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:05:00] (viewOnlineReports) database connection response [30 Sep 2020 00:05:00] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 00:05:00] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000031392', '001', '200395736', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:05:00] (viewOnlineReports) p_Stop=N [30 Sep 2020 00:05:00] (viewOnlineReports) p_Alert= [30 Sep 2020 00:05:00] (viewOnlineReports) Flag = 1 [30 Sep 2020 00:05:00] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395736', 'M01', '047', '1', '001000000000081028', 'M0100000031392_M01RCH20018292_1.PDF', 'M0100000031392', SYSDATE) [30 Sep 2020 00:05:00] (viewOnlineReports) database connection response [30 Sep 2020 00:05:00] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395736' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [30 Sep 2020 00:05:00] (viewOnlineReports) database connection response [30 Sep 2020 00:05:00] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 00:05:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395736/ [30 Sep 2020 00:05:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395736/ [30 Sep 2020 00:05:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:05:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395736/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601406300M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:05:00] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395736/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601406300M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:05:00] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 00:05:00] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395736/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601406300M0100000031392_M01RCH20018292_1.PDF [30 Sep 2020 00:06:03] (viewOnlineReports) database connection response [30 Sep 2020 00:06:03] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 00:06:03] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000031392', '001', '200395736', '2', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:06:03] (viewOnlineReports) p_Stop=N [30 Sep 2020 00:06:03] (viewOnlineReports) p_Alert= [30 Sep 2020 00:06:03] (viewOnlineReports) Flag = 1 [30 Sep 2020 00:06:03] (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', '200395736', 'M01', '047', '2', '001000000000084443', 'M0100000031392_M01SCH20010190_3.PDF', 'M0100000031392', SYSDATE) [30 Sep 2020 00:06:03] (viewOnlineReports) database connection response [30 Sep 2020 00:06:03] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395736' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [30 Sep 2020 00:06:03] (viewOnlineReports) database connection response [30 Sep 2020 00:06:03] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 00:06:03] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395736/ [30 Sep 2020 00:06:03] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395736/ [30 Sep 2020 00:06:03] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000031392_M01SCH20010190_3.PDF [30 Sep 2020 00:06:03] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601406363M0100000031392_M01SCH20010190_3.PDF [30 Sep 2020 00:06:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601406363M0100000031392_M01SCH20010190_3.PDF [30 Sep 2020 00:06:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 00:06:03] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601406363M0100000031392_M01SCH20010190_3.PDF [30 Sep 2020 00:06:20] (viewOnlineReports) database connection response [30 Sep 2020 00:06:20] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 00:06:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000031392', '001', '200395736', '4', '001000000000084439', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:06:20] (viewOnlineReports) p_Stop=N [30 Sep 2020 00:06:20] (viewOnlineReports) p_Alert= [30 Sep 2020 00:06:20] (viewOnlineReports) Flag = 1 [30 Sep 2020 00:06: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', '200395736', 'M01', '047', '4', '001000000000084439', 'M0100000031392_M01SCH20010190_2.PDF', 'M0100000031392', SYSDATE) [30 Sep 2020 00:06:20] (viewOnlineReports) database connection response [30 Sep 2020 00:06:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395736' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [30 Sep 2020 00:06:20] (viewOnlineReports) database connection response [30 Sep 2020 00:06:20] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 00:06:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395736/ [30 Sep 2020 00:06:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395736/ [30 Sep 2020 00:06:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000031392_M01SCH20010190_2.PDF [30 Sep 2020 00:06:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395736/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601406380M0100000031392_M01SCH20010190_2.PDF [30 Sep 2020 00:06:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395736/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601406380M0100000031392_M01SCH20010190_2.PDF [30 Sep 2020 00:06:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 00:06:20] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395736/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601406380M0100000031392_M01SCH20010190_2.PDF [30 Sep 2020 00:06:41] (viewOnlineReports) database connection response [30 Sep 2020 00:06:41] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 00:06:41] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000031392', '001', '200395736', '5', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:06:41] (viewOnlineReports) p_Stop=N [30 Sep 2020 00:06:41] (viewOnlineReports) p_Alert= [30 Sep 2020 00:06:41] (viewOnlineReports) Flag = 1 [30 Sep 2020 00:06:41] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395736', 'M01', '047', '5', '001000000000082306', 'M0100000031392_M01SCH20010190_1.PDF', 'M0100000031392', SYSDATE) [30 Sep 2020 00:06:41] (viewOnlineReports) database connection response [30 Sep 2020 00:06:41] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395736' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [30 Sep 2020 00:06:41] (viewOnlineReports) database connection response [30 Sep 2020 00:06:41] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 00:06:41] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395736/ [30 Sep 2020 00:06:41] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395736/ [30 Sep 2020 00:06:41] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000031392_M01SCH20010190_1.PDF [30 Sep 2020 00:06:41] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601406401M0100000031392_M01SCH20010190_1.PDF [30 Sep 2020 00:06:41] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601406401M0100000031392_M01SCH20010190_1.PDF [30 Sep 2020 00:06:41] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 00:06:41] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395736/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601406401M0100000031392_M01SCH20010190_1.PDF [30 Sep 2020 00:25:36] (index) database connection response [30 Sep 2020 00:25:36] (index) getConnection(): Resource id #1 [30 Sep 2020 00:25:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 00:25:36] (index) database connection response [30 Sep 2020 00:25:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 00:25:36] (index) database connection response [30 Sep 2020 00:25:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 00:25:36] (index) database connection response [30 Sep 2020 00:25:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411479' AND ACCESS_CODE = '86312337' [30 Sep 2020 00:25:36] (index) database connection response [30 Sep 2020 00:25:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411479' AND ACCESS_CODE = '86312337' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 00:25:36] (index) database connection response [30 Sep 2020 00:25:36] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634657' [30 Sep 2020 00:25:36] (index) database connection response [30 Sep 2020 00:25:36] (index) getPatientReportsDetail() entered [30 Sep 2020 00:25:36] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411479', 'M0100000634657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:25:36] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411479', 'M0100000634657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:25:36] (index) p_Stop=N [30 Sep 2020 00:25:36] (index) p_Alert= [30 Sep 2020 00:25: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 [30 Sep 2020 00:25:36] (index) database connection response [30 Sep 2020 00:25:36] (index) getConnectionClose() called.... [30 Sep 2020 00:25:36] (index) getConnectionClose() called.... [30 Sep 2020 00:26:38] (index) database connection response [30 Sep 2020 00:26:38] (index) getConnection(): Resource id #1 [30 Sep 2020 00:26:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 00:26:38] (index) database connection response [30 Sep 2020 00:26:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 00:26:38] (index) database connection response [30 Sep 2020 00:26:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 00:26:38] (index) database connection response [30 Sep 2020 00:26:38] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200408672' AND ACCESS_CODE = '27390679' [30 Sep 2020 00:26:38] (index) database connection response [30 Sep 2020 00:26:38] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200408672' AND ACCESS_CODE = '27390679' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 00:26:38] (index) database connection response [30 Sep 2020 00:26:38] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000636049' [30 Sep 2020 00:26:38] (index) database connection response [30 Sep 2020 00:26:38] (index) getPatientReportsDetail() entered [30 Sep 2020 00:26:38] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200408672', 'M0100000636049', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:26:38] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200408672', 'M0100000636049', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:26:38] (index) p_Stop=N [30 Sep 2020 00:26:38] (index) p_Alert= [30 Sep 2020 00:26:38] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 00:26:38] (index) database connection response [30 Sep 2020 00:26:38] (index) getConnectionClose() called.... [30 Sep 2020 00:26:38] (index) getConnectionClose() called.... [30 Sep 2020 00:26:43] (viewOnlineReports) database connection response [30 Sep 2020 00:26:43] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 00:26:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636049', '001', '200394736', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 00:26:44] (viewOnlineReports) p_Stop=N [30 Sep 2020 00:26:44] (viewOnlineReports) p_Alert= [30 Sep 2020 00:26:44] (viewOnlineReports) Flag = 1 [30 Sep 2020 00:26:44] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200394736', 'M01', '047', '2', '001000000000085025', 'M0100000636049_M01HEM20013452_1.PDF', 'M0100000636049', SYSDATE) [30 Sep 2020 00:26:44] (viewOnlineReports) database connection response [30 Sep 2020 00:26:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200394736' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [30 Sep 2020 00:26:44] (viewOnlineReports) database connection response [30 Sep 2020 00:26:44] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 00:26:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200394736/ [30 Sep 2020 00:26:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200394736/ [30 Sep 2020 00:26:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636049_M01HEM20013452_1.PDF [30 Sep 2020 00:26:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200394736/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601407603M0100000636049_M01HEM20013452_1.PDF [30 Sep 2020 00:26:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200394736/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601407603M0100000636049_M01HEM20013452_1.PDF [30 Sep 2020 00:26:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 00:26:44] (viewOnlineReports) Downloading file ../../TEMP_PDF/200394736/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601407603M0100000636049_M01HEM20013452_1.PDF [30 Sep 2020 01:15:48] (index) database connection response [30 Sep 2020 01:15:48] (index) getConnection(): Resource id #1 [30 Sep 2020 01:15:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 01:15:48] (index) database connection response [30 Sep 2020 01:15:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 01:15:48] (index) database connection response [30 Sep 2020 01:15:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 01:15:48] (index) database connection response [30 Sep 2020 01:15:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411671' AND ACCESS_CODE = '60050106' [30 Sep 2020 01:15:48] (index) database connection response [30 Sep 2020 01:15:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411671' AND ACCESS_CODE = '60050106' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 01:15:48] (index) database connection response [30 Sep 2020 01:15:48] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000546347' [30 Sep 2020 01:15:48] (index) database connection response [30 Sep 2020 01:15:48] (index) getPatientReportsDetail() entered [30 Sep 2020 01:15:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411671', 'M0100000546347', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:15:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411671', 'M0100000546347', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:15:48] (index) p_Stop=N [30 Sep 2020 01:15:48] (index) p_Alert= [30 Sep 2020 01:15: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 [30 Sep 2020 01:15:48] (index) database connection response [30 Sep 2020 01:15:48] (index) getConnectionClose() called.... [30 Sep 2020 01:15:48] (index) getConnectionClose() called.... [30 Sep 2020 01:16:40] (viewOnlineReports) database connection response [30 Sep 2020 01:16:40] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 01:16:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000546347', '001', '200396027', '3', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:16:40] (viewOnlineReports) p_Stop=N [30 Sep 2020 01:16:40] (viewOnlineReports) p_Alert= [30 Sep 2020 01:16:40] (viewOnlineReports) Flag = 1 [30 Sep 2020 01:16:40] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200396027', 'M01', '010', '3', '001000000000082306', 'M0100000546347_M01SCH20010202_1.PDF', 'M0100000546347', SYSDATE) [30 Sep 2020 01:16:40] (viewOnlineReports) database connection response [30 Sep 2020 01:16:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396027' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '3' [30 Sep 2020 01:16:40] (viewOnlineReports) database connection response [30 Sep 2020 01:16:40] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 01:16:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396027/ [30 Sep 2020 01:16:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396027/ [30 Sep 2020 01:16:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000546347_M01SCH20010202_1.PDF [30 Sep 2020 01:16:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396027/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601410600M0100000546347_M01SCH20010202_1.PDF [30 Sep 2020 01:16:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396027/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601410600M0100000546347_M01SCH20010202_1.PDF [30 Sep 2020 01:16:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 01:16:40] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200396027/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601410600M0100000546347_M01SCH20010202_1.PDF [30 Sep 2020 01:16:50] (viewOnlineReports) database connection response [30 Sep 2020 01:16:50] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 01:16:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000546347', '001', '200396027', '2', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:16:50] (viewOnlineReports) p_Stop=N [30 Sep 2020 01:16:50] (viewOnlineReports) p_Alert= [30 Sep 2020 01:16:50] (viewOnlineReports) Flag = 1 [30 Sep 2020 01:16: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', '200396027', 'M01', '010', '2', '001000000000081028', 'M0100000546347_M01RCH20018310_1.PDF', 'M0100000546347', SYSDATE) [30 Sep 2020 01:16:50] (viewOnlineReports) database connection response [30 Sep 2020 01:16:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396027' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '2' [30 Sep 2020 01:16:50] (viewOnlineReports) database connection response [30 Sep 2020 01:16:50] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 01:16:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396027/ [30 Sep 2020 01:16:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396027/ [30 Sep 2020 01:16:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:16:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1601410610M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:16:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1601410610M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:16:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [30 Sep 2020 01:16:50] (viewOnlineReports) Converting PDF to JPG with name as M0100000546347_M01RCH20018310_1.jpg [30 Sep 2020 01:16:50] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1601410610M0100000546347_M01RCH20018310_1.PDF ../../TEMP_PDF/200396027/M0100000546347_M01RCH20018310_1.jpg [30 Sep 2020 01:16:50] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1601410610M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:33:55] (viewOnlineReports) database connection response [30 Sep 2020 01:33:55] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 01:33:55] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000546347', '001', '200396027', '2', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:33:55] (viewOnlineReports) p_Stop=N [30 Sep 2020 01:33:55] (viewOnlineReports) p_Alert= [30 Sep 2020 01:33:55] (viewOnlineReports) Flag = 1 [30 Sep 2020 01:33: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', '200396027', 'M01', '010', '2', '001000000000081028', 'M0100000546347_M01RCH20018310_1.PDF', 'M0100000546347', SYSDATE) [30 Sep 2020 01:33:55] (viewOnlineReports) database connection response [30 Sep 2020 01:33:55] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396027' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '2' [30 Sep 2020 01:33:55] (viewOnlineReports) database connection response [30 Sep 2020 01:33:55] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 01:33:55] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396027/ [30 Sep 2020 01:33:55] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396027/ [30 Sep 2020 01:33:55] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:33:55] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601411635M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:33:55] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601411635M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:33:55] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [30 Sep 2020 01:33:55] (viewOnlineReports) Converting PDF to JPG with name as M0100000546347_M01RCH20018310_1.jpg [30 Sep 2020 01:33:55] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601411635M0100000546347_M01RCH20018310_1.PDF ../../TEMP_PDF/200396027/M0100000546347_M01RCH20018310_1.jpg [30 Sep 2020 01:33:55] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601411635M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:34:16] (viewOnlineReports) database connection response [30 Sep 2020 01:34:16] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 01:34:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000546347', '001', '200396027', '2', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:34:16] (viewOnlineReports) p_Stop=N [30 Sep 2020 01:34:16] (viewOnlineReports) p_Alert= [30 Sep 2020 01:34:16] (viewOnlineReports) Flag = 1 [30 Sep 2020 01:34:16] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200396027', 'M01', '010', '2', '001000000000081028', 'M0100000546347_M01RCH20018310_1.PDF', 'M0100000546347', SYSDATE) [30 Sep 2020 01:34:16] (viewOnlineReports) database connection response [30 Sep 2020 01:34:16] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396027' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '2' [30 Sep 2020 01:34:16] (viewOnlineReports) database connection response [30 Sep 2020 01:34:16] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 01:34:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396027/ [30 Sep 2020 01:34:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396027/ [30 Sep 2020 01:34:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:34:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601411656M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:34:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601411656M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:34:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 01:34:16] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601411656M0100000546347_M01RCH20018310_1.PDF [30 Sep 2020 01:34:32] (viewOnlineReports) database connection response [30 Sep 2020 01:34:32] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 01:34:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000546347', '001', '200396027', '3', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:34:32] (viewOnlineReports) p_Stop=N [30 Sep 2020 01:34:32] (viewOnlineReports) p_Alert= [30 Sep 2020 01:34:32] (viewOnlineReports) Flag = 1 [30 Sep 2020 01:34:32] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200396027', 'M01', '010', '3', '001000000000082306', 'M0100000546347_M01SCH20010202_1.PDF', 'M0100000546347', SYSDATE) [30 Sep 2020 01:34:32] (viewOnlineReports) database connection response [30 Sep 2020 01:34:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396027' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '3' [30 Sep 2020 01:34:32] (viewOnlineReports) database connection response [30 Sep 2020 01:34:32] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 01:34:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396027/ [30 Sep 2020 01:34:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396027/ [30 Sep 2020 01:34:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000546347_M01SCH20010202_1.PDF [30 Sep 2020 01:34:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396027/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601411672M0100000546347_M01SCH20010202_1.PDF [30 Sep 2020 01:34:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396027/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601411672M0100000546347_M01SCH20010202_1.PDF [30 Sep 2020 01:34:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 01:34:32] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200396027/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601411672M0100000546347_M01SCH20010202_1.PDF [30 Sep 2020 01:34:46] (viewOnlineReports) database connection response [30 Sep 2020 01:34:46] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 01:34:46] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000546347', '001', '200396027', '4', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:34:46] (viewOnlineReports) p_Stop=N [30 Sep 2020 01:34:46] (viewOnlineReports) p_Alert= [30 Sep 2020 01:34:46] (viewOnlineReports) Flag = 1 [30 Sep 2020 01:34:46] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200396027', 'M01', '010', '4', '001000000000082047', 'M0100000546347_M01RCH20018310_2.PDF', 'M0100000546347', SYSDATE) [30 Sep 2020 01:34:46] (viewOnlineReports) database connection response [30 Sep 2020 01:34:46] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396027' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '4' [30 Sep 2020 01:34:46] (viewOnlineReports) database connection response [30 Sep 2020 01:34:46] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 01:34:46] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396027/ [30 Sep 2020 01:34:46] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396027/ [30 Sep 2020 01:34:46] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000546347_M01RCH20018310_2.PDF [30 Sep 2020 01:34:46] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601411686M0100000546347_M01RCH20018310_2.PDF [30 Sep 2020 01:34:46] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601411686M0100000546347_M01RCH20018310_2.PDF [30 Sep 2020 01:34:46] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 01:34:46] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601411686M0100000546347_M01RCH20018310_2.PDF [30 Sep 2020 01:35:15] (viewOnlineReports) database connection response [30 Sep 2020 01:35:15] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 01:35:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000546347', '001', '200396027', '5', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 01:35:15] (viewOnlineReports) p_Stop=N [30 Sep 2020 01:35:15] (viewOnlineReports) p_Alert= [30 Sep 2020 01:35:15] (viewOnlineReports) Flag = 1 [30 Sep 2020 01:35: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', '200396027', 'M01', '010', '5', '001000000000084443', 'M0100000546347_M01SCH20010202_2.PDF', 'M0100000546347', SYSDATE) [30 Sep 2020 01:35:15] (viewOnlineReports) database connection response [30 Sep 2020 01:35:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396027' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '5' [30 Sep 2020 01:35:15] (viewOnlineReports) database connection response [30 Sep 2020 01:35:15] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 01:35:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396027/ [30 Sep 2020 01:35:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396027/ [30 Sep 2020 01:35:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000546347_M01SCH20010202_2.PDF [30 Sep 2020 01:35:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601411715M0100000546347_M01SCH20010202_2.PDF [30 Sep 2020 01:35:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601411715M0100000546347_M01SCH20010202_2.PDF [30 Sep 2020 01:35:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 01:35:16] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200396027/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601411715M0100000546347_M01SCH20010202_2.PDF [30 Sep 2020 03:47:04] (index) database connection response [30 Sep 2020 03:47:04] (index) getConnection(): Resource id #1 [30 Sep 2020 03:47:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '50' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 03:47:04] (index) database connection response [30 Sep 2020 03:47:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '50' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 03:47:04] (index) database connection response [30 Sep 2020 03:47:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '50' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 03:47:04] (index) database connection response [30 Sep 2020 03:47:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411553' AND ACCESS_CODE = '42137194' [30 Sep 2020 03:47:04] (index) database connection response [30 Sep 2020 03:47:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411553' AND ACCESS_CODE = '42137194' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 03:47:04] (index) database connection response [30 Sep 2020 03:47:04] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000636482' [30 Sep 2020 03:47:04] (index) database connection response [30 Sep 2020 03:47:04] (index) getPatientReportsDetail() entered [30 Sep 2020 03:47:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411553', 'M0100000636482', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 03:47:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411553', 'M0100000636482', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 03:47:04] (index) p_Stop=N [30 Sep 2020 03:47:04] (index) p_Alert= [30 Sep 2020 03:47: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 [30 Sep 2020 03:47:04] (index) database connection response [30 Sep 2020 03:47:04] (index) getConnectionClose() called.... [30 Sep 2020 03:47:04] (index) getConnectionClose() called.... [30 Sep 2020 03:47:20] (viewOnlineReports) database connection response [30 Sep 2020 03:47:20] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 03:47:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636482', '001', '200395962', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 03:47:20] (viewOnlineReports) p_Stop=N [30 Sep 2020 03:47:20] (viewOnlineReports) p_Alert= [30 Sep 2020 03:47:20] (viewOnlineReports) Flag = 1 [30 Sep 2020 03:47: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', '200395962', 'M01', '070', '1', '001000000000087630', 'M0100000636482_M01MOL20009724_1.PDF', 'M0100000636482', SYSDATE) [30 Sep 2020 03:47:20] (viewOnlineReports) database connection response [30 Sep 2020 03:47:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395962' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 03:47:20] (viewOnlineReports) database connection response [30 Sep 2020 03:47:20] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 03:47:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395962/ [30 Sep 2020 03:47:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395962/ [30 Sep 2020 03:47:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636482_M01MOL20009724_1.PDF [30 Sep 2020 03:47:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395962/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601419640M0100000636482_M01MOL20009724_1.PDF [30 Sep 2020 03:47:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395962/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601419640M0100000636482_M01MOL20009724_1.PDF [30 Sep 2020 03:47:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [30 Sep 2020 03:47:20] (viewOnlineReports) Converting PDF to JPG with name as M0100000636482_M01MOL20009724_1.jpg [30 Sep 2020 03:47:20] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200395962/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601419640M0100000636482_M01MOL20009724_1.PDF ../../TEMP_PDF/200395962/M0100000636482_M01MOL20009724_1.jpg [30 Sep 2020 03:47:20] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200395962/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601419640M0100000636482_M01MOL20009724_1.PDF [30 Sep 2020 03:47:43] (viewOnlineReports) database connection response [30 Sep 2020 03:47:43] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 03:47:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636482', '001', '200395962', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 03:47:43] (viewOnlineReports) p_Stop=N [30 Sep 2020 03:47:43] (viewOnlineReports) p_Alert= [30 Sep 2020 03:47:43] (viewOnlineReports) Flag = 1 [30 Sep 2020 03:47:43] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395962', 'M01', '070', '1', '001000000000087630', 'M0100000636482_M01MOL20009724_1.PDF', 'M0100000636482', SYSDATE) [30 Sep 2020 03:47:43] (viewOnlineReports) database connection response [30 Sep 2020 03:47:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395962' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 03:47:43] (viewOnlineReports) database connection response [30 Sep 2020 03:47:43] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 03:47:43] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395962/ [30 Sep 2020 03:47:43] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395962/ [30 Sep 2020 03:47:43] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636482_M01MOL20009724_1.PDF [30 Sep 2020 03:47:43] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395962/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601419663M0100000636482_M01MOL20009724_1.PDF [30 Sep 2020 03:47:43] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395962/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601419663M0100000636482_M01MOL20009724_1.PDF [30 Sep 2020 03:47:43] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 03:47:43] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395962/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601419663M0100000636482_M01MOL20009724_1.PDF [30 Sep 2020 07:48:43] (index) database connection response [30 Sep 2020 07:48:43] (index) getConnection(): Resource id #1 [30 Sep 2020 07:48:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 07:48:43] (index) database connection response [30 Sep 2020 07:48:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 07:48:43] (index) database connection response [30 Sep 2020 07:48:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 07:48:43] (index) database connection response [30 Sep 2020 07:48:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '20009750' AND ACCESS_CODE = '00000636541' [30 Sep 2020 07:48:43] (index) database connection response [30 Sep 2020 07:48:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '20009750' AND ACCESS_CODE = '00000636541' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 07:48:43] (index) database connection response [30 Sep 2020 07:48:43] (index) getConnectionClose() called.... [30 Sep 2020 07:50:49] (index) database connection response [30 Sep 2020 07:50:49] (index) getConnection(): Resource id #1 [30 Sep 2020 07:50:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 07:50:49] (index) database connection response [30 Sep 2020 07:50:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 07:50:49] (index) database connection response [30 Sep 2020 07:50:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 07:50:49] (index) database connection response [30 Sep 2020 07:50:49] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01MOL200097' AND ACCESS_CODE = 'M01-00000636541' [30 Sep 2020 07:50:49] (index) database connection response [30 Sep 2020 07:50:49] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01MOL200097' AND ACCESS_CODE = 'M01-00000636541' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 07:50:49] (index) database connection response [30 Sep 2020 07:50:49] (index) getConnectionClose() called.... [30 Sep 2020 09:35:31] (index) database connection response [30 Sep 2020 09:35:31] (index) getConnection(): Resource id #1 [30 Sep 2020 09:35:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 09:35:31] (index) database connection response [30 Sep 2020 09:35:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 09:35:31] (index) database connection response [30 Sep 2020 09:35:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '81' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 09:35:31] (index) database connection response [30 Sep 2020 09:35:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412267' AND ACCESS_CODE = '000-00635708' [30 Sep 2020 09:35:32] (index) database connection response [30 Sep 2020 09:35:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412267' AND ACCESS_CODE = '000-00635708' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 09:35:32] (index) database connection response [30 Sep 2020 09:35:32] (index) getConnectionClose() called.... [30 Sep 2020 10:47:05] (index) database connection response [30 Sep 2020 10:47:05] (index) getConnection(): Resource id #1 [30 Sep 2020 10:47:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 10:47:05] (index) database connection response [30 Sep 2020 10:47:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 10:47:05] (index) database connection response [30 Sep 2020 10:47:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 10:47:05] (index) database connection response [30 Sep 2020 10:47:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200395487' AND ACCESS_CODE = '46207773' [30 Sep 2020 10:47:05] (index) database connection response [30 Sep 2020 10:47:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200395487' AND ACCESS_CODE = '46207773' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 10:47:05] (index) database connection response [30 Sep 2020 10:47:05] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634283' [30 Sep 2020 10:47:05] (index) database connection response [30 Sep 2020 10:47:05] (index) getPatientReportsDetail() entered [30 Sep 2020 10:47:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200395487', 'M0100000634283', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:47:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200395487', 'M0100000634283', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:47:06] (index) p_Stop=N [30 Sep 2020 10:47:06] (index) p_Alert= [30 Sep 2020 10:47: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 [30 Sep 2020 10:47:06] (index) database connection response [30 Sep 2020 10:47:06] (index) getConnectionClose() called.... [30 Sep 2020 10:47:06] (index) getConnectionClose() called.... [30 Sep 2020 10:47:15] (viewOnlineReports) database connection response [30 Sep 2020 10:47:15] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 10:47:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634283', '001', '200389668', '1', '001000000000081257', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:47:15] (viewOnlineReports) p_Stop=N [30 Sep 2020 10:47:15] (viewOnlineReports) p_Alert= [30 Sep 2020 10:47:15] (viewOnlineReports) Flag = 1 [30 Sep 2020 10:47: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', '200389668', 'M01', '047', '1', '001000000000081257', 'M0100000634283_M01MIC20007156_1.PDF', 'M0100000634283', SYSDATE) [30 Sep 2020 10:47:15] (viewOnlineReports) database connection response [30 Sep 2020 10:47:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200389668' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [30 Sep 2020 10:47:15] (viewOnlineReports) database connection response [30 Sep 2020 10:47:15] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 10:47:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200389668/ [30 Sep 2020 10:47:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200389668/ [30 Sep 2020 10:47:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200922\M01\M0100000634283_M01MIC20007156_1.PDF [30 Sep 2020 10:47:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200389668/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601444835M0100000634283_M01MIC20007156_1.PDF [30 Sep 2020 10:47:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200389668/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601444835M0100000634283_M01MIC20007156_1.PDF [30 Sep 2020 10:47:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 10:47:16] (viewOnlineReports) Downloading file ../../TEMP_PDF/200389668/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601444835M0100000634283_M01MIC20007156_1.PDF [30 Sep 2020 10:47:31] (viewOnlineReports) database connection response [30 Sep 2020 10:47:31] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 10:47:31] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634283', '001', '200389668', '2', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:47:31] (viewOnlineReports) p_Stop=N [30 Sep 2020 10:47:31] (viewOnlineReports) p_Alert= [30 Sep 2020 10:47:31] (viewOnlineReports) Flag = 1 [30 Sep 2020 10:47: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', '200389668', 'M01', '047', '2', '001000000000086302', 'M0100000634283_M01SCH20009835_1.PDF', 'M0100000634283', SYSDATE) [30 Sep 2020 10:47:31] (viewOnlineReports) database connection response [30 Sep 2020 10:47:31] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200389668' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [30 Sep 2020 10:47:31] (viewOnlineReports) database connection response [30 Sep 2020 10:47:31] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 10:47:31] (viewOnlineReports) creating directory structure../../TEMP_PDF/200389668/ [30 Sep 2020 10:47:31] (viewOnlineReports) directory structure created ../../TEMP_PDF/200389668/ [30 Sep 2020 10:47:31] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200922\M01\M0100000634283_M01SCH20009835_1.PDF [30 Sep 2020 10:47:31] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200389668/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1601444851M0100000634283_M01SCH20009835_1.PDF [30 Sep 2020 10:47:31] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200389668/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1601444851M0100000634283_M01SCH20009835_1.PDF [30 Sep 2020 10:47:31] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 10:47:31] (viewOnlineReports) Downloading file ../../TEMP_PDF/200389668/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1601444851M0100000634283_M01SCH20009835_1.PDF [30 Sep 2020 10:47:40] (viewOnlineReports) database connection response [30 Sep 2020 10:47:40] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 10:47:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634283', '001', '200389668', '3', '001000000000086720', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:47:40] (viewOnlineReports) p_Stop=N [30 Sep 2020 10:47:40] (viewOnlineReports) p_Alert= [30 Sep 2020 10:47:40] (viewOnlineReports) Flag = 1 [30 Sep 2020 10:47:40] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200389668', 'M01', '047', '3', '001000000000086720', 'M0100000634283_M01SCH20009835_2.PDF', 'M0100000634283', SYSDATE) [30 Sep 2020 10:47:40] (viewOnlineReports) database connection response [30 Sep 2020 10:47:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200389668' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [30 Sep 2020 10:47:40] (viewOnlineReports) database connection response [30 Sep 2020 10:47:40] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 10:47:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200389668/ [30 Sep 2020 10:47:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200389668/ [30 Sep 2020 10:47:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200922\M01\M0100000634283_M01SCH20009835_2.PDF [30 Sep 2020 10:47:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200389668/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601444860M0100000634283_M01SCH20009835_2.PDF [30 Sep 2020 10:47:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200389668/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601444860M0100000634283_M01SCH20009835_2.PDF [30 Sep 2020 10:47:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 10:47:40] (viewOnlineReports) Downloading file ../../TEMP_PDF/200389668/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601444860M0100000634283_M01SCH20009835_2.PDF [30 Sep 2020 10:57:14] (index) database connection response [30 Sep 2020 10:57:14] (index) getConnection(): Resource id #1 [30 Sep 2020 10:57:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 10:57:14] (index) database connection response [30 Sep 2020 10:57:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 10:57:14] (index) database connection response [30 Sep 2020 10:57:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 10:57:14] (index) database connection response [30 Sep 2020 10:57:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200395484' AND ACCESS_CODE = '49776538' [30 Sep 2020 10:57:14] (index) database connection response [30 Sep 2020 10:57:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200395484' AND ACCESS_CODE = '49776538' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 10:57:14] (index) database connection response [30 Sep 2020 10:57:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634279' [30 Sep 2020 10:57:14] (index) database connection response [30 Sep 2020 10:57:14] (index) getPatientReportsDetail() entered [30 Sep 2020 10:57:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200395484', 'M0100000634279', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:57:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200395484', 'M0100000634279', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:57:14] (index) p_Stop=N [30 Sep 2020 10:57:14] (index) p_Alert= [30 Sep 2020 10:57: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 [30 Sep 2020 10:57:14] (index) database connection response [30 Sep 2020 10:57:14] (index) getConnectionClose() called.... [30 Sep 2020 10:57:14] (index) getConnectionClose() called.... [30 Sep 2020 10:57:21] (viewOnlineReports) database connection response [30 Sep 2020 10:57:21] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 10:57:21] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634279', '001', '200389664', '1', '001000000000081257', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:57:21] (viewOnlineReports) p_Stop=N [30 Sep 2020 10:57:21] (viewOnlineReports) p_Alert= [30 Sep 2020 10:57:21] (viewOnlineReports) Flag = 1 [30 Sep 2020 10:57:21] (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', '200389664', 'M01', '047', '1', '001000000000081257', 'M0100000634279_M01MIC20007155_1.PDF', 'M0100000634279', SYSDATE) [30 Sep 2020 10:57:21] (viewOnlineReports) database connection response [30 Sep 2020 10:57:21] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200389664' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [30 Sep 2020 10:57:21] (viewOnlineReports) database connection response [30 Sep 2020 10:57:21] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 10:57:21] (viewOnlineReports) creating directory structure../../TEMP_PDF/200389664/ [30 Sep 2020 10:57:21] (viewOnlineReports) directory structure created ../../TEMP_PDF/200389664/ [30 Sep 2020 10:57:21] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200922\M01\M0100000634279_M01MIC20007155_1.PDF [30 Sep 2020 10:57:21] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200389664/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601445441M0100000634279_M01MIC20007155_1.PDF [30 Sep 2020 10:57:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200389664/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601445441M0100000634279_M01MIC20007155_1.PDF [30 Sep 2020 10:57:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 10:57:21] (viewOnlineReports) Downloading file ../../TEMP_PDF/200389664/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601445441M0100000634279_M01MIC20007155_1.PDF [30 Sep 2020 10:57:31] (viewOnlineReports) database connection response [30 Sep 2020 10:57:31] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 10:57:31] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634279', '001', '200389664', '2', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:57:31] (viewOnlineReports) p_Stop=N [30 Sep 2020 10:57:31] (viewOnlineReports) p_Alert= [30 Sep 2020 10:57:31] (viewOnlineReports) Flag = 1 [30 Sep 2020 10:57: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', '200389664', 'M01', '047', '2', '001000000000086302', 'M0100000634279_M01SCH20009834_1.PDF', 'M0100000634279', SYSDATE) [30 Sep 2020 10:57:31] (viewOnlineReports) database connection response [30 Sep 2020 10:57:31] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200389664' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [30 Sep 2020 10:57:31] (viewOnlineReports) database connection response [30 Sep 2020 10:57:31] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 10:57:31] (viewOnlineReports) creating directory structure../../TEMP_PDF/200389664/ [30 Sep 2020 10:57:31] (viewOnlineReports) directory structure created ../../TEMP_PDF/200389664/ [30 Sep 2020 10:57:31] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200922\M01\M0100000634279_M01SCH20009834_1.PDF [30 Sep 2020 10:57:31] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200389664/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601445451M0100000634279_M01SCH20009834_1.PDF [30 Sep 2020 10:57:31] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200389664/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601445451M0100000634279_M01SCH20009834_1.PDF [30 Sep 2020 10:57:31] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 10:57:31] (viewOnlineReports) Downloading file ../../TEMP_PDF/200389664/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601445451M0100000634279_M01SCH20009834_1.PDF [30 Sep 2020 10:57:37] (viewOnlineReports) database connection response [30 Sep 2020 10:57:37] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 10:57:37] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634279', '001', '200389664', '3', '001000000000086720', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:57:37] (viewOnlineReports) p_Stop=N [30 Sep 2020 10:57:37] (viewOnlineReports) p_Alert= [30 Sep 2020 10:57:37] (viewOnlineReports) Flag = 1 [30 Sep 2020 10:57:37] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200389664', 'M01', '047', '3', '001000000000086720', 'M0100000634279_M01SCH20009834_2.PDF', 'M0100000634279', SYSDATE) [30 Sep 2020 10:57:37] (viewOnlineReports) database connection response [30 Sep 2020 10:57:37] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200389664' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [30 Sep 2020 10:57:37] (viewOnlineReports) database connection response [30 Sep 2020 10:57:37] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 10:57:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200389664/ [30 Sep 2020 10:57:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200389664/ [30 Sep 2020 10:57:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200922\M01\M0100000634279_M01SCH20009834_2.PDF [30 Sep 2020 10:57:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200389664/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601445457M0100000634279_M01SCH20009834_2.PDF [30 Sep 2020 10:57:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200389664/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601445457M0100000634279_M01SCH20009834_2.PDF [30 Sep 2020 10:57:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 10:57:38] (viewOnlineReports) Downloading file ../../TEMP_PDF/200389664/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601445457M0100000634279_M01SCH20009834_2.PDF [30 Sep 2020 10:59:07] (viewOnlineReports) database connection response [30 Sep 2020 10:59:07] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 10:59:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200395062', '1', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 10:59:07] (viewOnlineReports) p_Stop=N [30 Sep 2020 10:59:07] (viewOnlineReports) p_Alert= [30 Sep 2020 10:59:07] (viewOnlineReports) Flag = 1 [30 Sep 2020 10:59:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395062', 'M01', '047', '1', '001000000000084443', 'M0100000634176_M01SCH20010147_1.PDF', '00100000000000', SYSDATE) [30 Sep 2020 10:59:07] (viewOnlineReports) database connection response [30 Sep 2020 10:59:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395062' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [30 Sep 2020 10:59:07] (viewOnlineReports) database connection response [30 Sep 2020 10:59:07] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 10:59:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395062/ [30 Sep 2020 10:59:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395062/ [30 Sep 2020 10:59:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200928\M01\M0100000634176_M01SCH20010147_1.PDF [30 Sep 2020 10:59:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395062/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZM0100000634176_M01SCH20010147_1.PDF [30 Sep 2020 10:59:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395062/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZM0100000634176_M01SCH20010147_1.PDF [30 Sep 2020 10:59:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 10:59:07] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395062/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZM0100000634176_M01SCH20010147_1.PDF [30 Sep 2020 11:03:16] (index) database connection response [30 Sep 2020 11:03:16] (index) getConnection(): Resource id #1 [30 Sep 2020 11:03:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 11:03:16] (index) database connection response [30 Sep 2020 11:03:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 11:03:16] (index) database connection response [30 Sep 2020 11:03:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 11:03:16] (index) database connection response [30 Sep 2020 11:03:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200400647' AND ACCESS_CODE = '86292601' [30 Sep 2020 11:03:17] (index) database connection response [30 Sep 2020 11:03:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200400647' AND ACCESS_CODE = '86292601' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 11:03:17] (index) database connection response [30 Sep 2020 11:03:17] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634943' [30 Sep 2020 11:03:17] (index) database connection response [30 Sep 2020 11:03:17] (index) getPatientReportsDetail() entered [30 Sep 2020 11:03:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200400647', 'M0100000634943', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:03:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200400647', 'M0100000634943', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:03:17] (index) p_Stop=N [30 Sep 2020 11:03:17] (index) p_Alert= [30 Sep 2020 11:03:17] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 11:03:17] (index) database connection response [30 Sep 2020 11:03:17] (index) getConnectionClose() called.... [30 Sep 2020 11:03:17] (index) getConnectionClose() called.... [30 Sep 2020 11:32:09] (index) database connection response [30 Sep 2020 11:32:09] (index) getConnection(): Resource id #1 [30 Sep 2020 11:32:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 11:32:09] (index) database connection response [30 Sep 2020 11:32:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 11:32:09] (index) database connection response [30 Sep 2020 11:32:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 11:32:09] (index) database connection response [30 Sep 2020 11:32:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200410754' AND ACCESS_CODE = '93532160' [30 Sep 2020 11:32:09] (index) database connection response [30 Sep 2020 11:32:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200410754' AND ACCESS_CODE = '93532160' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 11:32:09] (index) database connection response [30 Sep 2020 11:32:09] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000636377' [30 Sep 2020 11:32:09] (index) database connection response [30 Sep 2020 11:32:09] (index) getPatientReportsDetail() entered [30 Sep 2020 11:32:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200410754', 'M0100000636377', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:32:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200410754', 'M0100000636377', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:32:09] (index) p_Stop=N [30 Sep 2020 11:32:09] (index) p_Alert= [30 Sep 2020 11:32: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 [30 Sep 2020 11:32:09] (index) database connection response [30 Sep 2020 11:32:09] (index) getConnectionClose() called.... [30 Sep 2020 11:32:09] (index) getConnectionClose() called.... [30 Sep 2020 11:32:45] (viewOnlineReports) database connection response [30 Sep 2020 11:32:45] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 11:32:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636377', '001', '200395595', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:32:45] (viewOnlineReports) p_Stop=N [30 Sep 2020 11:32:45] (viewOnlineReports) p_Alert= [30 Sep 2020 11:32:45] (viewOnlineReports) Flag = 1 [30 Sep 2020 11:32:45] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395595', 'M01', '070', '1', '001000000000087630', 'M0100000636377_M01MOL20009671_1.PDF', 'M0100000636377', SYSDATE) [30 Sep 2020 11:32:45] (viewOnlineReports) database connection response [30 Sep 2020 11:32:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395595' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 11:32:45] (viewOnlineReports) database connection response [30 Sep 2020 11:32:45] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 11:32:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395595/ [30 Sep 2020 11:32:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395595/ [30 Sep 2020 11:32:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:32:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395595/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601447565M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:32:46] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395595/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601447565M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:32:46] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 11:32:46] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395595/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601447565M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:32:46] (viewOnlineReports) database connection response [30 Sep 2020 11:32:46] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 11:32:46] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636377', '001', '200395595', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:32:46] (viewOnlineReports) p_Stop=N [30 Sep 2020 11:32:46] (viewOnlineReports) p_Alert= [30 Sep 2020 11:32:46] (viewOnlineReports) Flag = 1 [30 Sep 2020 11:32:46] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395595', 'M01', '070', '1', '001000000000087630', 'M0100000636377_M01MOL20009671_1.PDF', 'M0100000636377', SYSDATE) [30 Sep 2020 11:32:46] (viewOnlineReports) database connection response [30 Sep 2020 11:32:46] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395595' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 11:32:46] (viewOnlineReports) database connection response [30 Sep 2020 11:32:46] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 11:32:46] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395595/ [30 Sep 2020 11:32:46] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395595/ [30 Sep 2020 11:32:46] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:32:46] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601447566M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:32:46] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601447566M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:32:46] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 11:32:46] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601447566M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:49:59] (viewOnlineReports) database connection response [30 Sep 2020 11:49:59] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 11:49:59] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636377', '001', '200395595', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:49:59] (viewOnlineReports) p_Stop=N [30 Sep 2020 11:49:59] (viewOnlineReports) p_Alert= [30 Sep 2020 11:49:59] (viewOnlineReports) Flag = 1 [30 Sep 2020 11:49:59] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395595', 'M01', '070', '1', '001000000000087630', 'M0100000636377_M01MOL20009671_1.PDF', 'M0100000636377', SYSDATE) [30 Sep 2020 11:49:59] (viewOnlineReports) database connection response [30 Sep 2020 11:49:59] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395595' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 11:49:59] (viewOnlineReports) database connection response [30 Sep 2020 11:49:59] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 11:49:59] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395595/ [30 Sep 2020 11:49:59] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395595/ [30 Sep 2020 11:49:59] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:49:59] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601448599M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:49:59] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601448599M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:49:59] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [30 Sep 2020 11:49:59] (viewOnlineReports) Converting PDF to JPG with name as M0100000636377_M01MOL20009671_1.jpg [30 Sep 2020 11:49:59] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601448599M0100000636377_M01MOL20009671_1.PDF ../../TEMP_PDF/200395595/M0100000636377_M01MOL20009671_1.jpg [30 Sep 2020 11:49:59] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601448599M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:50:06] (viewOnlineReports) database connection response [30 Sep 2020 11:50:06] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 11:50:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636377', '001', '200395595', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:50:06] (viewOnlineReports) p_Stop=N [30 Sep 2020 11:50:06] (viewOnlineReports) p_Alert= [30 Sep 2020 11:50:06] (viewOnlineReports) Flag = 1 [30 Sep 2020 11:50:06] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395595', 'M01', '070', '1', '001000000000087630', 'M0100000636377_M01MOL20009671_1.PDF', 'M0100000636377', SYSDATE) [30 Sep 2020 11:50:06] (viewOnlineReports) database connection response [30 Sep 2020 11:50:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395595' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 11:50:06] (viewOnlineReports) database connection response [30 Sep 2020 11:50:06] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 11:50:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395595/ [30 Sep 2020 11:50:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395595/ [30 Sep 2020 11:50:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:50:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601448606M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:50:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601448606M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:50:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [30 Sep 2020 11:50:06] (viewOnlineReports) Converting PDF to JPG with name as M0100000636377_M01MOL20009671_1.jpg [30 Sep 2020 11:50:06] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601448606M0100000636377_M01MOL20009671_1.PDF ../../TEMP_PDF/200395595/M0100000636377_M01MOL20009671_1.jpg [30 Sep 2020 11:50:06] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601448606M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:51:11] (viewOnlineReports) database connection response [30 Sep 2020 11:51:11] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 11:51:11] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636377', '001', '200395595', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 11:51:11] (viewOnlineReports) p_Stop=N [30 Sep 2020 11:51:11] (viewOnlineReports) p_Alert= [30 Sep 2020 11:51:11] (viewOnlineReports) Flag = 1 [30 Sep 2020 11:51:11] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395595', 'M01', '070', '1', '001000000000087630', 'M0100000636377_M01MOL20009671_1.PDF', 'M0100000636377', SYSDATE) [30 Sep 2020 11:51:11] (viewOnlineReports) database connection response [30 Sep 2020 11:51:11] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395595' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 11:51:11] (viewOnlineReports) database connection response [30 Sep 2020 11:51:11] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 11:51:11] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395595/ [30 Sep 2020 11:51:11] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395595/ [30 Sep 2020 11:51:11] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:51:11] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601448671M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:51:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601448671M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 11:51:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [30 Sep 2020 11:51:11] (viewOnlineReports) Converting PDF to JPG with name as M0100000636377_M01MOL20009671_1.jpg [30 Sep 2020 11:51:11] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601448671M0100000636377_M01MOL20009671_1.PDF ../../TEMP_PDF/200395595/M0100000636377_M01MOL20009671_1.jpg [30 Sep 2020 11:51:11] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200395595/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601448671M0100000636377_M01MOL20009671_1.PDF [30 Sep 2020 13:05:37] (index) database connection response [30 Sep 2020 13:05:37] (index) getConnection(): Resource id #1 [30 Sep 2020 13:05:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 13:05:37] (index) database connection response [30 Sep 2020 13:05:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 13:05:37] (index) database connection response [30 Sep 2020 13:05:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 13:05:37] (index) database connection response [30 Sep 2020 13:05:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411524' AND ACCESS_CODE = '03097675' [30 Sep 2020 13:05:37] (index) database connection response [30 Sep 2020 13:05:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411524' AND ACCESS_CODE = '03097675' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 13:05:37] (index) database connection response [30 Sep 2020 13:05:37] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000636473' [30 Sep 2020 13:05:37] (index) database connection response [30 Sep 2020 13:05:37] (index) getPatientReportsDetail() entered [30 Sep 2020 13:05:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411524', 'M0100000636473', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:05:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411524', 'M0100000636473', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:05:37] (index) p_Stop=N [30 Sep 2020 13:05:37] (index) p_Alert= [30 Sep 2020 13:05:37] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 13:05:37] (index) database connection response [30 Sep 2020 13:05:37] (index) getConnectionClose() called.... [30 Sep 2020 13:05:37] (index) getConnectionClose() called.... [30 Sep 2020 13:07:45] (viewOnlineReports) database connection response [30 Sep 2020 13:07:45] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:07:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '10', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:07:45] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:07:45] (viewOnlineReports) p_Alert= [30 Sep 2020 13:07:45] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:07:45] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '10', '001000000000084443', 'M0100000636473_M01SCH20010200_2.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:07:45] (viewOnlineReports) database connection response [30 Sep 2020 13:07:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '10' [30 Sep 2020 13:07:45] (viewOnlineReports) database connection response [30 Sep 2020 13:07:45] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:07:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:07:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:07:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 13:07:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453265M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 13:07:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453265M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 13:07:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:07:45] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453265M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 13:09:06] (viewOnlineReports) database connection response [30 Sep 2020 13:09:06] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:09:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '10', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:09:06] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:09:06] (viewOnlineReports) p_Alert= [30 Sep 2020 13:09:06] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:09:06] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '10', '001000000000084443', 'M0100000636473_M01SCH20010200_2.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:09:06] (viewOnlineReports) database connection response [30 Sep 2020 13:09:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '10' [30 Sep 2020 13:09:06] (viewOnlineReports) database connection response [30 Sep 2020 13:09:06] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:09:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:09:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:09:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 13:09:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453346M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 13:09:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453346M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 13:09:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:09:06] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453346M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 13:09:38] (viewOnlineReports) database connection response [30 Sep 2020 13:09:38] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:09:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '9', '001000000000084436', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:09:38] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:09:38] (viewOnlineReports) p_Alert= [30 Sep 2020 13:09:38] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:09:38] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '9', '001000000000084436', 'M0100000636473_M01SCH20010200_1.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:09:38] (viewOnlineReports) database connection response [30 Sep 2020 13:09:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '9' [30 Sep 2020 13:09:38] (viewOnlineReports) database connection response [30 Sep 2020 13:09:38] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:09:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:09:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:09:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01SCH20010200_1.PDF [30 Sep 2020 13:09:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1601453378M0100000636473_M01SCH20010200_1.PDF [30 Sep 2020 13:09:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1601453378M0100000636473_M01SCH20010200_1.PDF [30 Sep 2020 13:09:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:09:39] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1601453378M0100000636473_M01SCH20010200_1.PDF [30 Sep 2020 13:09:52] (viewOnlineReports) database connection response [30 Sep 2020 13:09:52] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:09:52] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '8', '001000000000084480', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:09:52] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:09:52] (viewOnlineReports) p_Alert= [30 Sep 2020 13:09:52] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:09:52] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '8', '001000000000084480', 'M0100000636473_M01SCH20010200_3.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:09:52] (viewOnlineReports) database connection response [30 Sep 2020 13:09:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [30 Sep 2020 13:09:52] (viewOnlineReports) database connection response [30 Sep 2020 13:09:52] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:09:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:09:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:09:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01SCH20010200_3.PDF [30 Sep 2020 13:09:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453392M0100000636473_M01SCH20010200_3.PDF [30 Sep 2020 13:09:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453392M0100000636473_M01SCH20010200_3.PDF [30 Sep 2020 13:09:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:09:52] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453392M0100000636473_M01SCH20010200_3.PDF [30 Sep 2020 13:10:09] (viewOnlineReports) database connection response [30 Sep 2020 13:10:09] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:10:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '7', '001000000000081027', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:10:09] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:10:09] (viewOnlineReports) p_Alert= [30 Sep 2020 13:10:09] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:10:09] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '7', '001000000000081027', 'M0100000636473_M01RCH20018307_2.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:10:09] (viewOnlineReports) database connection response [30 Sep 2020 13:10:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [30 Sep 2020 13:10:09] (viewOnlineReports) database connection response [30 Sep 2020 13:10:09] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:10:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:10:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:10:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01RCH20018307_2.PDF [30 Sep 2020 13:10:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453409M0100000636473_M01RCH20018307_2.PDF [30 Sep 2020 13:10:09] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453409M0100000636473_M01RCH20018307_2.PDF [30 Sep 2020 13:10:09] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:10:09] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453409M0100000636473_M01RCH20018307_2.PDF [30 Sep 2020 13:10:37] (viewOnlineReports) database connection response [30 Sep 2020 13:10:37] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:10:37] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '6', '001000000000080058', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:10:37] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:10:37] (viewOnlineReports) p_Alert= [30 Sep 2020 13:10:37] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:10:37] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '6', '001000000000080058', 'M0100000636473_M01RCH20018307_1.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:10:37] (viewOnlineReports) database connection response [30 Sep 2020 13:10:37] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [30 Sep 2020 13:10:37] (viewOnlineReports) database connection response [30 Sep 2020 13:10:37] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:10:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:10:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:10:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01RCH20018307_1.PDF [30 Sep 2020 13:10:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453437M0100000636473_M01RCH20018307_1.PDF [30 Sep 2020 13:10:37] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453437M0100000636473_M01RCH20018307_1.PDF [30 Sep 2020 13:10:37] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:10:37] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453437M0100000636473_M01RCH20018307_1.PDF [30 Sep 2020 13:12:13] (viewOnlineReports) database connection response [30 Sep 2020 13:12:13] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:12:13] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '5', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:12:13] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:12:13] (viewOnlineReports) p_Alert= [30 Sep 2020 13:12:13] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:12: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', '200395953', 'M01', '047', '5', '001000000000087100', 'M0100000636473_M01MIC20007393_1.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:12:13] (viewOnlineReports) database connection response [30 Sep 2020 13:12:13] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [30 Sep 2020 13:12:13] (viewOnlineReports) database connection response [30 Sep 2020 13:12:13] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:12:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:12:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:12:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01MIC20007393_1.PDF [30 Sep 2020 13:12:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601453533M0100000636473_M01MIC20007393_1.PDF [30 Sep 2020 13:12:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601453533M0100000636473_M01MIC20007393_1.PDF [30 Sep 2020 13:12:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:12:13] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601453533M0100000636473_M01MIC20007393_1.PDF [30 Sep 2020 13:13:18] (viewOnlineReports) database connection response [30 Sep 2020 13:13:18] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:13:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '4', '001000000000083036', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:13:18] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:13:18] (viewOnlineReports) p_Alert= [30 Sep 2020 13:13:18] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:13:18] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '4', '001000000000083036', 'M0100000636473_M01RCH20018307_3.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:13:18] (viewOnlineReports) database connection response [30 Sep 2020 13:13:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [30 Sep 2020 13:13:18] (viewOnlineReports) database connection response [30 Sep 2020 13:13:18] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:13:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:13:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:13:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 13:13:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453598M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 13:13:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453598M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 13:13:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:13:18] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453598M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 13:13:58] (viewOnlineReports) database connection response [30 Sep 2020 13:13:58] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:13:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '3', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:13:58] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:13:58] (viewOnlineReports) p_Alert= [30 Sep 2020 13:13:58] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:13: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', '200395953', 'M01', '047', '3', '001000000000084949', 'M0100000636473_M01RCH20018307_4.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:13:58] (viewOnlineReports) database connection response [30 Sep 2020 13:13:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [30 Sep 2020 13:13:58] (viewOnlineReports) database connection response [30 Sep 2020 13:13:58] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:13:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:13:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:13:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01RCH20018307_4.PDF [30 Sep 2020 13:13:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453637M0100000636473_M01RCH20018307_4.PDF [30 Sep 2020 13:13:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453637M0100000636473_M01RCH20018307_4.PDF [30 Sep 2020 13:13:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:13:58] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1601453637M0100000636473_M01RCH20018307_4.PDF [30 Sep 2020 13:14:59] (viewOnlineReports) database connection response [30 Sep 2020 13:14:59] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:14:59] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:14:59] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:14:59] (viewOnlineReports) p_Alert= [30 Sep 2020 13:14:59] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:14:59] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '2', '001000000000085025', 'M0100000636473_M01HEM20013547_1.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 13:14:59] (viewOnlineReports) database connection response [30 Sep 2020 13:14:59] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [30 Sep 2020 13:14:59] (viewOnlineReports) database connection response [30 Sep 2020 13:14:59] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:14:59] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 13:14:59] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 13:14:59] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01HEM20013547_1.PDF [30 Sep 2020 13:14:59] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453699M0100000636473_M01HEM20013547_1.PDF [30 Sep 2020 13:14:59] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453699M0100000636473_M01HEM20013547_1.PDF [30 Sep 2020 13:14:59] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 13:14:59] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1601453699M0100000636473_M01HEM20013547_1.PDF [30 Sep 2020 13:54:42] (index) database connection response [30 Sep 2020 13:54:42] (index) getConnection(): Resource id #1 [30 Sep 2020 13:54:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 13:54:42] (index) database connection response [30 Sep 2020 13:54:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 13:54:42] (index) database connection response [30 Sep 2020 13:54:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 13:54:42] (index) database connection response [30 Sep 2020 13:54:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200410238' AND ACCESS_CODE = '47521968' [30 Sep 2020 13:54:42] (index) database connection response [30 Sep 2020 13:54:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200410238' AND ACCESS_CODE = '47521968' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 13:54:42] (index) database connection response [30 Sep 2020 13:54:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000558438' [30 Sep 2020 13:54:42] (index) database connection response [30 Sep 2020 13:54:42] (index) getPatientReportsDetail() entered [30 Sep 2020 13:54:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200410238', 'M0100000558438', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:54:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200410238', 'M0100000558438', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:54:43] (index) p_Stop=N [30 Sep 2020 13:54:43] (index) p_Alert= [30 Sep 2020 13:54:43] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 13:54:43] (index) database connection response [30 Sep 2020 13:54:43] (index) getConnectionClose() called.... [30 Sep 2020 13:54:43] (index) getConnectionClose() called.... [30 Sep 2020 13:55:01] (viewOnlineReports) database connection response [30 Sep 2020 13:55:01] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:55:01] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200395352', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:55:01] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:55:01] (viewOnlineReports) p_Alert= [30 Sep 2020 13:55:01] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:55:01] (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', '200395352', 'M01', '047', '2', '001000000000085025', 'M0100000558438_M01HEM20013501_1.PDF', 'M0100000558438', SYSDATE) [30 Sep 2020 13:55:01] (viewOnlineReports) database connection response [30 Sep 2020 13:55:01] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395352' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [30 Sep 2020 13:55:01] (viewOnlineReports) database connection response [30 Sep 2020 13:55:01] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:55:01] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395352/ [30 Sep 2020 13:55:01] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395352/ [30 Sep 2020 13:55:01] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000558438_M01HEM20013501_1.PDF [30 Sep 2020 13:55:01] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395352/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601456101M0100000558438_M01HEM20013501_1.PDF [30 Sep 2020 13:55:01] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395352/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601456101M0100000558438_M01HEM20013501_1.PDF [30 Sep 2020 13:55:01] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 13:55:01] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395352/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601456101M0100000558438_M01HEM20013501_1.PDF [30 Sep 2020 13:55:04] (viewOnlineReports) database connection response [30 Sep 2020 13:55:04] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:55:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200395352', '3', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:55:04] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:55:04] (viewOnlineReports) p_Alert= [30 Sep 2020 13:55:04] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:55:04] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395352', 'M01', '047', '3', '001000000000082947', 'M0100000558438_M01RCH20018250_1.PDF', 'M0100000558438', SYSDATE) [30 Sep 2020 13:55:04] (viewOnlineReports) database connection response [30 Sep 2020 13:55:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395352' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [30 Sep 2020 13:55:04] (viewOnlineReports) database connection response [30 Sep 2020 13:55:04] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:55:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395352/ [30 Sep 2020 13:55:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395352/ [30 Sep 2020 13:55:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000558438_M01RCH20018250_1.PDF [30 Sep 2020 13:55:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395352/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601456104M0100000558438_M01RCH20018250_1.PDF [30 Sep 2020 13:55:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395352/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601456104M0100000558438_M01RCH20018250_1.PDF [30 Sep 2020 13:55:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 13:55:04] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395352/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601456104M0100000558438_M01RCH20018250_1.PDF [30 Sep 2020 13:55:07] (viewOnlineReports) database connection response [30 Sep 2020 13:55:07] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 13:55:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200395352', '5', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 13:55:07] (viewOnlineReports) p_Stop=N [30 Sep 2020 13:55:07] (viewOnlineReports) p_Alert= [30 Sep 2020 13:55:07] (viewOnlineReports) Flag = 1 [30 Sep 2020 13:55:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395352', 'M01', '047', '5', '001000000000087100', 'M0100000558438_M01MIC20007371_1.PDF', 'M0100000558438', SYSDATE) [30 Sep 2020 13:55:07] (viewOnlineReports) database connection response [30 Sep 2020 13:55:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395352' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [30 Sep 2020 13:55:07] (viewOnlineReports) database connection response [30 Sep 2020 13:55:07] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 13:55:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395352/ [30 Sep 2020 13:55:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395352/ [30 Sep 2020 13:55:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000558438_M01MIC20007371_1.PDF [30 Sep 2020 13:55:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395352/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601456107M0100000558438_M01MIC20007371_1.PDF [30 Sep 2020 13:55:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395352/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601456107M0100000558438_M01MIC20007371_1.PDF [30 Sep 2020 13:55:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 13:55:07] (viewOnlineReports) Downloading file ../../TEMP_PDF/200395352/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601456107M0100000558438_M01MIC20007371_1.PDF [30 Sep 2020 14:23:08] (index) database connection response [30 Sep 2020 14:23:08] (index) getConnection(): Resource id #1 [30 Sep 2020 14:23:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 14:23:08] (index) database connection response [30 Sep 2020 14:23:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 14:23:08] (index) database connection response [30 Sep 2020 14:23:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 14:23:08] (index) database connection response [30 Sep 2020 14:23:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412344' AND ACCESS_CODE = '42433529' [30 Sep 2020 14:23:08] (index) database connection response [30 Sep 2020 14:23:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412344' AND ACCESS_CODE = '42433529' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 14:23:08] (index) database connection response [30 Sep 2020 14:23:08] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000636591' [30 Sep 2020 14:23:08] (index) database connection response [30 Sep 2020 14:23:08] (index) getPatientReportsDetail() entered [30 Sep 2020 14:23:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412344', 'M0100000636591', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 14:23:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412344', 'M0100000636591', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 14:23:08] (index) p_Stop=N [30 Sep 2020 14:23:08] (index) p_Alert= [30 Sep 2020 14:23:08] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 14:23:08] (index) database connection response [30 Sep 2020 14:23:08] (index) getConnectionClose() called.... [30 Sep 2020 14:23:08] (index) getConnectionClose() called.... [30 Sep 2020 14:23:34] (viewOnlineReports) database connection response [30 Sep 2020 14:23:34] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 14:23:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636591', '001', '200396242', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 14:23:34] (viewOnlineReports) p_Stop=N [30 Sep 2020 14:23:34] (viewOnlineReports) p_Alert= [30 Sep 2020 14:23:34] (viewOnlineReports) Flag = 1 [30 Sep 2020 14:23: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', '200396242', 'M01', '070', '1', '001000000000087630', 'M0100000636591_M01MOL20009796_1.PDF', 'M0100000636591', SYSDATE) [30 Sep 2020 14:23:34] (viewOnlineReports) database connection response [30 Sep 2020 14:23:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396242' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 14:23:34] (viewOnlineReports) database connection response [30 Sep 2020 14:23:34] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 14:23:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396242/ [30 Sep 2020 14:23:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396242/ [30 Sep 2020 14:23:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000636591_M01MOL20009796_1.PDF [30 Sep 2020 14:23:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396242/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601457814M0100000636591_M01MOL20009796_1.PDF [30 Sep 2020 14:23:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396242/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601457814M0100000636591_M01MOL20009796_1.PDF [30 Sep 2020 14:23:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 14:23:34] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200396242/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601457814M0100000636591_M01MOL20009796_1.PDF [30 Sep 2020 14:23:48] (viewOnlineReports) database connection response [30 Sep 2020 14:23:48] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 14:23:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000636591', '001', '200396242', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 14:23:48] (viewOnlineReports) p_Stop=N [30 Sep 2020 14:23:48] (viewOnlineReports) p_Alert= [30 Sep 2020 14:23:48] (viewOnlineReports) Flag = 1 [30 Sep 2020 14:23: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', '200396242', 'M01', '070', '1', '001000000000087630', 'M0100000636591_M01MOL20009796_1.PDF', 'M0100000636591', SYSDATE) [30 Sep 2020 14:23:48] (viewOnlineReports) database connection response [30 Sep 2020 14:23:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396242' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [30 Sep 2020 14:23:48] (viewOnlineReports) database connection response [30 Sep 2020 14:23:48] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 14:23:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396242/ [30 Sep 2020 14:23:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396242/ [30 Sep 2020 14:23:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000636591_M01MOL20009796_1.PDF [30 Sep 2020 14:23:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396242/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601457828M0100000636591_M01MOL20009796_1.PDF [30 Sep 2020 14:23:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396242/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601457828M0100000636591_M01MOL20009796_1.PDF [30 Sep 2020 14:23:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 14:23:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200396242/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601457828M0100000636591_M01MOL20009796_1.PDF [30 Sep 2020 14:39:07] (index) database connection response [30 Sep 2020 14:39:07] (index) getConnection(): Resource id #1 [30 Sep 2020 14:39:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 14:39:07] (index) database connection response [30 Sep 2020 14:39:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 14:39:07] (index) database connection response [30 Sep 2020 14:39:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 14:39:07] (index) database connection response [30 Sep 2020 14:39:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412515' AND ACCESS_CODE = '91465495' [30 Sep 2020 14:39:07] (index) database connection response [30 Sep 2020 14:39:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412515' AND ACCESS_CODE = '91465495' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 14:39:07] (index) database connection response [30 Sep 2020 14:39:07] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000049930' [30 Sep 2020 14:39:07] (index) database connection response [30 Sep 2020 14:39:07] (index) getPatientReportsDetail() entered [30 Sep 2020 14:39:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412515', 'M0100000049930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 14:39:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412515', 'M0100000049930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 14:39:07] (index) p_Stop=N [30 Sep 2020 14:39:07] (index) p_Alert= [30 Sep 2020 14:39:07] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 14:39:07] (index) database connection response [30 Sep 2020 14:39:07] (index) getConnectionClose() called.... [30 Sep 2020 14:39:07] (index) getConnectionClose() called.... [30 Sep 2020 14:39:19] (viewOnlineReports) database connection response [30 Sep 2020 14:39:19] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 14:39:19] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000049930', '001', '200396287', '1', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 14:39:19] (viewOnlineReports) p_Stop=N [30 Sep 2020 14:39:19] (viewOnlineReports) p_Alert= [30 Sep 2020 14:39:19] (viewOnlineReports) Flag = 1 [30 Sep 2020 14:39:19] (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', '200396287', 'M01', '047', '1', '001000000000084443', 'M0100000049930_M01SCH20010234_1.PDF', 'M0100000049930', SYSDATE) [30 Sep 2020 14:39:19] (viewOnlineReports) database connection response [30 Sep 2020 14:39:19] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396287' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [30 Sep 2020 14:39:19] (viewOnlineReports) database connection response [30 Sep 2020 14:39:19] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 14:39:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396287/ [30 Sep 2020 14:39:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396287/ [30 Sep 2020 14:39:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000049930_M01SCH20010234_1.PDF [30 Sep 2020 14:39:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396287/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601458759M0100000049930_M01SCH20010234_1.PDF [30 Sep 2020 14:39:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396287/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601458759M0100000049930_M01SCH20010234_1.PDF [30 Sep 2020 14:39:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 14:39:19] (viewOnlineReports) Downloading file ../../TEMP_PDF/200396287/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601458759M0100000049930_M01SCH20010234_1.PDF [30 Sep 2020 15:36:49] (viewOnlineReports) database connection response [30 Sep 2020 15:36:49] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 15:36:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200395953', '4', '001000000000083036', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 15:36:49] (viewOnlineReports) p_Stop=N [30 Sep 2020 15:36:49] (viewOnlineReports) p_Alert= [30 Sep 2020 15:36:49] (viewOnlineReports) Flag = 1 [30 Sep 2020 15:36:49] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '4', '001000000000083036', 'M0100000636473_M01RCH20018307_3.PDF', '00100000000000', SYSDATE) [30 Sep 2020 15:36:49] (viewOnlineReports) database connection response [30 Sep 2020 15:36:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [30 Sep 2020 15:36:49] (viewOnlineReports) database connection response [30 Sep 2020 15:36:49] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 15:36:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 15:36:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 15:36:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 15:36:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZM0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 15:36:49] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZM0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 15:36:49] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 15:36:49] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZM0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 15:41:46] (index) database connection response [30 Sep 2020 15:41:46] (index) getConnection(): Resource id #1 [30 Sep 2020 15:41:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 15:41:46] (index) database connection response [30 Sep 2020 15:41:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 15:41:46] (index) database connection response [30 Sep 2020 15:41:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 15:41:46] (index) database connection response [30 Sep 2020 15:41:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411524' AND ACCESS_CODE = '03097675' [30 Sep 2020 15:41:46] (index) database connection response [30 Sep 2020 15:41:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411524' AND ACCESS_CODE = '03097675' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 15:41:46] (index) database connection response [30 Sep 2020 15:41:46] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000636473' [30 Sep 2020 15:41:46] (index) database connection response [30 Sep 2020 15:41:46] (index) getPatientReportsDetail() entered [30 Sep 2020 15:41:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411524', 'M0100000636473', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 15:41:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200411524', 'M0100000636473', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 15:41:46] (index) p_Stop=N [30 Sep 2020 15:41:46] (index) p_Alert= [30 Sep 2020 15:41:46] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 15:41:46] (index) database connection response [30 Sep 2020 15:41:46] (index) getConnectionClose() called.... [30 Sep 2020 15:41:46] (index) getConnectionClose() called.... [30 Sep 2020 15:42:08] (viewOnlineReports) database connection response [30 Sep 2020 15:42:08] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 15:42:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '4', '001000000000083036', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 15:42:08] (viewOnlineReports) p_Stop=N [30 Sep 2020 15:42:08] (viewOnlineReports) p_Alert= [30 Sep 2020 15:42:08] (viewOnlineReports) Flag = 1 [30 Sep 2020 15:42: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', '200395953', 'M01', '047', '4', '001000000000083036', 'M0100000636473_M01RCH20018307_3.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 15:42:08] (viewOnlineReports) database connection response [30 Sep 2020 15:42:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [30 Sep 2020 15:42:08] (viewOnlineReports) database connection response [30 Sep 2020 15:42:08] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 15:42:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 15:42:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 15:42:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 15:42:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601462528M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 15:42:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601462528M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 15:42:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 15:42:08] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1601462528M0100000636473_M01RCH20018307_3.PDF [30 Sep 2020 15:42:26] (viewOnlineReports) database connection response [30 Sep 2020 15:42:26] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 15:42:26] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '8', '001000000000084480', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 15:42:26] (viewOnlineReports) p_Stop=N [30 Sep 2020 15:42:26] (viewOnlineReports) p_Alert= [30 Sep 2020 15:42:26] (viewOnlineReports) Flag = 1 [30 Sep 2020 15:42:26] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '8', '001000000000084480', 'M0100000636473_M01SCH20010200_3.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 15:42:26] (viewOnlineReports) database connection response [30 Sep 2020 15:42:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [30 Sep 2020 15:42:26] (viewOnlineReports) database connection response [30 Sep 2020 15:42:26] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 15:42:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 15:42:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 15:42:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01SCH20010200_3.PDF [30 Sep 2020 15:42:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462546M0100000636473_M01SCH20010200_3.PDF [30 Sep 2020 15:42:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462546M0100000636473_M01SCH20010200_3.PDF [30 Sep 2020 15:42:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 15:42:26] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462546M0100000636473_M01SCH20010200_3.PDF [30 Sep 2020 15:42:29] (viewOnlineReports) database connection response [30 Sep 2020 15:42:29] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 15:42:29] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '9', '001000000000084436', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 15:42:29] (viewOnlineReports) p_Stop=N [30 Sep 2020 15:42:29] (viewOnlineReports) p_Alert= [30 Sep 2020 15:42:29] (viewOnlineReports) Flag = 1 [30 Sep 2020 15:42: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', '200395953', 'M01', '047', '9', '001000000000084436', 'M0100000636473_M01SCH20010200_1.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 15:42:29] (viewOnlineReports) database connection response [30 Sep 2020 15:42:29] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '9' [30 Sep 2020 15:42:29] (viewOnlineReports) database connection response [30 Sep 2020 15:42:29] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 15:42:29] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 15:42:29] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 15:42:29] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01SCH20010200_1.PDF [30 Sep 2020 15:42:29] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462549M0100000636473_M01SCH20010200_1.PDF [30 Sep 2020 15:42:30] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462549M0100000636473_M01SCH20010200_1.PDF [30 Sep 2020 15:42:30] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 15:42:30] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462549M0100000636473_M01SCH20010200_1.PDF [30 Sep 2020 15:42:32] (viewOnlineReports) database connection response [30 Sep 2020 15:42:32] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 15:42:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636473', '001', '200395953', '10', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 15:42:32] (viewOnlineReports) p_Stop=N [30 Sep 2020 15:42:32] (viewOnlineReports) p_Alert= [30 Sep 2020 15:42:32] (viewOnlineReports) Flag = 1 [30 Sep 2020 15:42:32] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200395953', 'M01', '047', '10', '001000000000084443', 'M0100000636473_M01SCH20010200_2.PDF', 'M0100000636473', SYSDATE) [30 Sep 2020 15:42:32] (viewOnlineReports) database connection response [30 Sep 2020 15:42:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200395953' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '10' [30 Sep 2020 15:42:32] (viewOnlineReports) database connection response [30 Sep 2020 15:42:32] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 15:42:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200395953/ [30 Sep 2020 15:42:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200395953/ [30 Sep 2020 15:42:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200929\M01\M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 15:42:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200395953/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462552M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 15:42:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200395953/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462552M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 15:42:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 15:42:32] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200395953/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601462552M0100000636473_M01SCH20010200_2.PDF [30 Sep 2020 15:54:50] (index) database connection response [30 Sep 2020 15:54:50] (index) getConnection(): Resource id #1 [30 Sep 2020 15:54:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 15:54:50] (index) database connection response [30 Sep 2020 15:54:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 15:54:50] (index) database connection response [30 Sep 2020 15:54:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 15:54:50] (index) database connection response [30 Sep 2020 15:54:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200308398' AND ACCESS_CODE = '636119' [30 Sep 2020 15:54:50] (index) database connection response [30 Sep 2020 15:54:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200308398' AND ACCESS_CODE = '636119' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 15:54:50] (index) database connection response [30 Sep 2020 15:54:50] (index) getConnectionClose() called.... [30 Sep 2020 15:55:23] (index) database connection response [30 Sep 2020 15:55:23] (index) getConnection(): Resource id #1 [30 Sep 2020 15:55:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 15:55:23] (index) database connection response [30 Sep 2020 15:55:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 15:55:23] (index) database connection response [30 Sep 2020 15:55:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 15:55:23] (index) database connection response [30 Sep 2020 15:55:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200409132' AND ACCESS_CODE = '636119' [30 Sep 2020 15:55:23] (index) database connection response [30 Sep 2020 15:55:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200409132' AND ACCESS_CODE = '636119' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 15:55:23] (index) database connection response [30 Sep 2020 15:55:23] (index) getConnectionClose() called.... [30 Sep 2020 15:56:34] (index) database connection response [30 Sep 2020 15:56:34] (index) getConnection(): Resource id #1 [30 Sep 2020 15:56:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 15:56:34] (index) database connection response [30 Sep 2020 15:56:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 15:56:34] (index) database connection response [30 Sep 2020 15:56:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 15:56:34] (index) database connection response [30 Sep 2020 15:56:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411768' AND ACCESS_CODE = '636119' [30 Sep 2020 15:56:34] (index) database connection response [30 Sep 2020 15:56:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200411768' AND ACCESS_CODE = '636119' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 15:56:34] (index) database connection response [30 Sep 2020 15:56:34] (index) getConnectionClose() called.... [30 Sep 2020 15:58:44] (index) database connection response [30 Sep 2020 15:58:44] (index) getConnection(): Resource id #1 [30 Sep 2020 15:58:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 15:58:44] (index) database connection response [30 Sep 2020 15:58:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 15:58:44] (index) database connection response [30 Sep 2020 15:58:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 15:58:44] (index) database connection response [30 Sep 2020 15:58:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200310651' AND ACCESS_CODE = '35151427' [30 Sep 2020 15:58:44] (index) database connection response [30 Sep 2020 15:58:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200310651' AND ACCESS_CODE = '35151427' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 15:58:44] (index) database connection response [30 Sep 2020 15:58:44] (index) getConnectionClose() called.... [30 Sep 2020 16:03:18] (index) database connection response [30 Sep 2020 16:03:18] (index) getConnection(): Resource id #1 [30 Sep 2020 16:03:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 16:03:18] (index) database connection response [30 Sep 2020 16:03:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 16:03:18] (index) database connection response [30 Sep 2020 16:03:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 16:03:18] (index) database connection response [30 Sep 2020 16:03:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412192' AND ACCESS_CODE = '35151427' [30 Sep 2020 16:03:18] (index) database connection response [30 Sep 2020 16:03:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412192' AND ACCESS_CODE = '35151427' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 16:03:18] (index) database connection response [30 Sep 2020 16:03:18] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000052138' [30 Sep 2020 16:03:18] (index) database connection response [30 Sep 2020 16:03:18] (index) getPatientReportsDetail() entered [30 Sep 2020 16:03:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412192', 'M0100000052138', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 16:03:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412192', 'M0100000052138', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 16:03:18] (index) p_Stop=N [30 Sep 2020 16:03:18] (index) p_Alert= [30 Sep 2020 16:03:18] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 16:03:18] (index) database connection response [30 Sep 2020 16:03:18] (index) getConnectionClose() called.... [30 Sep 2020 16:03:18] (index) getConnectionClose() called.... [30 Sep 2020 16:21:38] (index) database connection response [30 Sep 2020 16:21:38] (index) getConnection(): Resource id #1 [30 Sep 2020 16:21:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 16:21:38] (index) database connection response [30 Sep 2020 16:21:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 16:21:38] (index) database connection response [30 Sep 2020 16:21:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 16:21:38] (index) database connection response [30 Sep 2020 16:21:38] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M1200400647' AND ACCESS_CODE = '86292601' [30 Sep 2020 16:21:38] (index) database connection response [30 Sep 2020 16:21:38] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M1200400647' AND ACCESS_CODE = '86292601' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 16:21:38] (index) database connection response [30 Sep 2020 16:21:38] (index) getConnectionClose() called.... [30 Sep 2020 16:22:05] (index) database connection response [30 Sep 2020 16:22:05] (index) getConnection(): Resource id #1 [30 Sep 2020 16:22:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 16:22:05] (index) database connection response [30 Sep 2020 16:22:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 16:22:05] (index) database connection response [30 Sep 2020 16:22:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 16:22:05] (index) database connection response [30 Sep 2020 16:22:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200400647' AND ACCESS_CODE = '86292601' [30 Sep 2020 16:22:05] (index) database connection response [30 Sep 2020 16:22:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200400647' AND ACCESS_CODE = '86292601' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 16:22:05] (index) database connection response [30 Sep 2020 16:22:05] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634943' [30 Sep 2020 16:22:05] (index) database connection response [30 Sep 2020 16:22:05] (index) getPatientReportsDetail() entered [30 Sep 2020 16:22:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200400647', 'M0100000634943', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 16:22:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200400647', 'M0100000634943', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 16:22:05] (index) p_Stop=N [30 Sep 2020 16:22:05] (index) p_Alert= [30 Sep 2020 16:22:05] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 16:22:05] (index) database connection response [30 Sep 2020 16:22:05] (index) getConnectionClose() called.... [30 Sep 2020 16:22:05] (index) getConnectionClose() called.... [30 Sep 2020 19:34:57] (index) database connection response [30 Sep 2020 19:34:57] (index) getConnection(): Resource id #1 [30 Sep 2020 19:34:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 19:34:57] (index) database connection response [30 Sep 2020 19:34:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 19:34:57] (index) database connection response [30 Sep 2020 19:34:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 19:34:57] (index) database connection response [30 Sep 2020 19:34:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200400647' AND ACCESS_CODE = '86292601' [30 Sep 2020 19:34:57] (index) database connection response [30 Sep 2020 19:34:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200400647' AND ACCESS_CODE = '86292601' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 19:34:57] (index) database connection response [30 Sep 2020 19:34:57] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634943' [30 Sep 2020 19:34:57] (index) database connection response [30 Sep 2020 19:34:57] (index) getPatientReportsDetail() entered [30 Sep 2020 19:34:57] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200400647', 'M0100000634943', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 19:34:57] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200400647', 'M0100000634943', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 19:34:57] (index) p_Stop=N [30 Sep 2020 19:34:57] (index) p_Alert= [30 Sep 2020 19:34:57] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 19:34:57] (index) database connection response [30 Sep 2020 19:34:57] (index) getConnectionClose() called.... [30 Sep 2020 19:34:57] (index) getConnectionClose() called.... [30 Sep 2020 22:35:34] (index) database connection response [30 Sep 2020 22:35:34] (index) getConnection(): Resource id #1 [30 Sep 2020 22:35:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 22:35:34] (index) database connection response [30 Sep 2020 22:35:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 22:35:34] (index) database connection response [30 Sep 2020 22:35:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 22:35:34] (index) database connection response [30 Sep 2020 22:35:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M0120041253' AND ACCESS_CODE = '82962655' [30 Sep 2020 22:35:34] (index) database connection response [30 Sep 2020 22:35:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M0120041253' AND ACCESS_CODE = '82962655' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 22:35:34] (index) database connection response [30 Sep 2020 22:35:34] (index) getConnectionClose() called.... [30 Sep 2020 22:36:36] (index) database connection response [30 Sep 2020 22:36:36] (index) getConnection(): Resource id #1 [30 Sep 2020 22:36:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 22:36:36] (index) database connection response [30 Sep 2020 22:36:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 22:36:36] (index) database connection response [30 Sep 2020 22:36:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 22:36:36] (index) database connection response [30 Sep 2020 22:36:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412453' AND ACCESS_CODE = '82962655' [30 Sep 2020 22:36:37] (index) database connection response [30 Sep 2020 22:36:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412453' AND ACCESS_CODE = '82962655' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 22:36:37] (index) database connection response [30 Sep 2020 22:36:37] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000636202' [30 Sep 2020 22:36:37] (index) database connection response [30 Sep 2020 22:36:37] (index) getPatientReportsDetail() entered [30 Sep 2020 22:36:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412453', 'M0100000636202', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:36:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412453', 'M0100000636202', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:36:37] (index) p_Stop=N [30 Sep 2020 22:36:37] (index) p_Alert= [30 Sep 2020 22:36:37] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 22:36:37] (index) database connection response [30 Sep 2020 22:36:37] (index) getConnectionClose() called.... [30 Sep 2020 22:36:37] (index) getConnectionClose() called.... [30 Sep 2020 22:36:53] (viewOnlineReports) database connection response [30 Sep 2020 22:36:53] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 22:36:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636202', '001', '200396273', '8', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:36:53] (viewOnlineReports) p_Stop=N [30 Sep 2020 22:36:53] (viewOnlineReports) p_Alert= [30 Sep 2020 22:36:53] (viewOnlineReports) Flag = 1 [30 Sep 2020 22:36: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', '200396273', 'M01', '047', '8', '001000000000087100', 'M0100000636202_M01MIC20007422_1.PDF', 'M0100000636202', SYSDATE) [30 Sep 2020 22:36:53] (viewOnlineReports) database connection response [30 Sep 2020 22:36:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396273' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [30 Sep 2020 22:36:53] (viewOnlineReports) database connection response [30 Sep 2020 22:36:53] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 22:36:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396273/ [30 Sep 2020 22:36:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396273/ [30 Sep 2020 22:36:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:36:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396273/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601487412M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:36:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396273/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601487412M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:36:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [30 Sep 2020 22:36:53] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200396273/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1601487412M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:05] (viewOnlineReports) database connection response [30 Sep 2020 22:37:05] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 22:37:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636202', '001', '200396273', '8', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:37:05] (viewOnlineReports) p_Stop=N [30 Sep 2020 22:37:05] (viewOnlineReports) p_Alert= [30 Sep 2020 22:37:05] (viewOnlineReports) Flag = 1 [30 Sep 2020 22:37: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', '200396273', 'M01', '047', '8', '001000000000087100', 'M0100000636202_M01MIC20007422_1.PDF', 'M0100000636202', SYSDATE) [30 Sep 2020 22:37:05] (viewOnlineReports) database connection response [30 Sep 2020 22:37:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396273' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [30 Sep 2020 22:37:05] (viewOnlineReports) database connection response [30 Sep 2020 22:37:05] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 22:37:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396273/ [30 Sep 2020 22:37:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396273/ [30 Sep 2020 22:37:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396273/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601487425M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396273/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601487425M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [30 Sep 2020 22:37:05] (viewOnlineReports) Converting PDF to JPG with name as M0100000636202_M01MIC20007422_1.jpg [30 Sep 2020 22:37:05] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200396273/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601487425M0100000636202_M01MIC20007422_1.PDF ../../TEMP_PDF/200396273/M0100000636202_M01MIC20007422_1.jpg [30 Sep 2020 22:37:05] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200396273/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601487425M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:17] (viewOnlineReports) database connection response [30 Sep 2020 22:37:17] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 22:37:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636202', '001', '200396273', '8', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:37:17] (viewOnlineReports) p_Stop=N [30 Sep 2020 22:37:17] (viewOnlineReports) p_Alert= [30 Sep 2020 22:37:17] (viewOnlineReports) Flag = 1 [30 Sep 2020 22:37: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', '200396273', 'M01', '047', '8', '001000000000087100', 'M0100000636202_M01MIC20007422_1.PDF', 'M0100000636202', SYSDATE) [30 Sep 2020 22:37:17] (viewOnlineReports) database connection response [30 Sep 2020 22:37:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396273' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [30 Sep 2020 22:37:17] (viewOnlineReports) database connection response [30 Sep 2020 22:37:17] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 22:37:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396273/ [30 Sep 2020 22:37:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396273/ [30 Sep 2020 22:37:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396273/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1601487437M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396273/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1601487437M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [30 Sep 2020 22:37:17] (viewOnlineReports) Converting PDF to JPG with name as M0100000636202_M01MIC20007422_1.jpg [30 Sep 2020 22:37:17] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200396273/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1601487437M0100000636202_M01MIC20007422_1.PDF ../../TEMP_PDF/200396273/M0100000636202_M01MIC20007422_1.jpg [30 Sep 2020 22:37:17] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200396273/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1601487437M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:25] (viewOnlineReports) database connection response [30 Sep 2020 22:37:25] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 22:37:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000636202', '001', '200396273', '8', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:37:25] (viewOnlineReports) p_Stop=N [30 Sep 2020 22:37:25] (viewOnlineReports) p_Alert= [30 Sep 2020 22:37:25] (viewOnlineReports) Flag = 1 [30 Sep 2020 22:37:25] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200396273', 'M01', '047', '8', '001000000000087100', 'M0100000636202_M01MIC20007422_1.PDF', 'M0100000636202', SYSDATE) [30 Sep 2020 22:37:25] (viewOnlineReports) database connection response [30 Sep 2020 22:37:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396273' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [30 Sep 2020 22:37:25] (viewOnlineReports) database connection response [30 Sep 2020 22:37:25] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 22:37:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396273/ [30 Sep 2020 22:37:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396273/ [30 Sep 2020 22:37:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396273/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1601487445M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396273/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1601487445M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:37:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 22:37:25] (viewOnlineReports) Downloading file ../../TEMP_PDF/200396273/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1601487445M0100000636202_M01MIC20007422_1.PDF [30 Sep 2020 22:38:28] (index) database connection response [30 Sep 2020 22:38:28] (index) getConnection(): Resource id #1 [30 Sep 2020 22:38:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 22:38:28] (index) database connection response [30 Sep 2020 22:38:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 22:38:28] (index) database connection response [30 Sep 2020 22:38:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 22:38:28] (index) database connection response [30 Sep 2020 22:38:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412450' AND ACCESS_CODE = '03650585' [30 Sep 2020 22:38:28] (index) database connection response [30 Sep 2020 22:38:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412450' AND ACCESS_CODE = '03650585' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 22:38:28] (index) database connection response [30 Sep 2020 22:38:28] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000545639' [30 Sep 2020 22:38:28] (index) database connection response [30 Sep 2020 22:38:28] (index) getPatientReportsDetail() entered [30 Sep 2020 22:38:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412450', 'M0100000545639', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:38:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412450', 'M0100000545639', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:38:28] (index) p_Stop=N [30 Sep 2020 22:38:28] (index) p_Alert= [30 Sep 2020 22:38:28] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [30 Sep 2020 22:38:28] (index) database connection response [30 Sep 2020 22:38:28] (index) getConnectionClose() called.... [30 Sep 2020 22:38:28] (index) getConnectionClose() called.... [30 Sep 2020 22:38:44] (viewOnlineReports) database connection response [30 Sep 2020 22:38:44] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 22:38:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000545639', '001', '200396272', '8', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:38:44] (viewOnlineReports) p_Stop=N [30 Sep 2020 22:38:44] (viewOnlineReports) p_Alert= [30 Sep 2020 22:38:44] (viewOnlineReports) Flag = 1 [30 Sep 2020 22:38:44] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200396272', 'M01', '047', '8', '001000000000087100', 'M0100000545639_M01MIC20007423_1.PDF', 'M0100000545639', SYSDATE) [30 Sep 2020 22:38:44] (viewOnlineReports) database connection response [30 Sep 2020 22:38:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396272' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [30 Sep 2020 22:38:44] (viewOnlineReports) database connection response [30 Sep 2020 22:38:44] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 22:38:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396272/ [30 Sep 2020 22:38:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396272/ [30 Sep 2020 22:38:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000545639_M01MIC20007423_1.PDF [30 Sep 2020 22:38:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396272/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601487524M0100000545639_M01MIC20007423_1.PDF [30 Sep 2020 22:38:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396272/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601487524M0100000545639_M01MIC20007423_1.PDF [30 Sep 2020 22:38:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 22:38:44] (viewOnlineReports) Downloading file ../../TEMP_PDF/200396272/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601487524M0100000545639_M01MIC20007423_1.PDF [30 Sep 2020 22:39:31] (index) database connection response [30 Sep 2020 22:39:31] (index) getConnection(): Resource id #1 [30 Sep 2020 22:39:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [30 Sep 2020 22:39:31] (index) database connection response [30 Sep 2020 22:39:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [30 Sep 2020 22:39:31] (index) database connection response [30 Sep 2020 22:39:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [30 Sep 2020 22:39:31] (index) database connection response [30 Sep 2020 22:39:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412438' AND ACCESS_CODE = '26340450' [30 Sep 2020 22:39:31] (index) database connection response [30 Sep 2020 22:39:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200412438' AND ACCESS_CODE = '26340450' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [30 Sep 2020 22:39:31] (index) database connection response [30 Sep 2020 22:39:31] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000599517' [30 Sep 2020 22:39:31] (index) database connection response [30 Sep 2020 22:39:31] (index) getPatientReportsDetail() entered [30 Sep 2020 22:39:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412438', 'M0100000599517', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:39:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200412438', 'M0100000599517', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:39:31] (index) p_Stop=N [30 Sep 2020 22:39:31] (index) p_Alert= [30 Sep 2020 22:39: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 [30 Sep 2020 22:39:31] (index) database connection response [30 Sep 2020 22:39:31] (index) getConnectionClose() called.... [30 Sep 2020 22:39:31] (index) getConnectionClose() called.... [30 Sep 2020 22:39:42] (viewOnlineReports) database connection response [30 Sep 2020 22:39:42] (viewOnlineReports) getConnection(): Resource id #1 [30 Sep 2020 22:39:42] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000599517', '001', '200396269', '7', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [30 Sep 2020 22:39:42] (viewOnlineReports) p_Stop=N [30 Sep 2020 22:39:42] (viewOnlineReports) p_Alert= [30 Sep 2020 22:39:42] (viewOnlineReports) Flag = 1 [30 Sep 2020 22:39:42] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200396269', 'M01', '047', '7', '001000000000087100', 'M0100000599517_M01MIC20007421_1.PDF', 'M0100000599517', SYSDATE) [30 Sep 2020 22:39:42] (viewOnlineReports) database connection response [30 Sep 2020 22:39:42] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200396269' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [30 Sep 2020 22:39:42] (viewOnlineReports) database connection response [30 Sep 2020 22:39:42] (viewOnlineReports) getConnectionClose() called.... [30 Sep 2020 22:39:42] (viewOnlineReports) creating directory structure../../TEMP_PDF/200396269/ [30 Sep 2020 22:39:42] (viewOnlineReports) directory structure created ../../TEMP_PDF/200396269/ [30 Sep 2020 22:39:42] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200930\M01\M0100000599517_M01MIC20007421_1.PDF [30 Sep 2020 22:39:42] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200396269/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1601487582M0100000599517_M01MIC20007421_1.PDF [30 Sep 2020 22:39:42] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200396269/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1601487582M0100000599517_M01MIC20007421_1.PDF [30 Sep 2020 22:39:42] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [30 Sep 2020 22:39:42] (viewOnlineReports) Downloading file ../../TEMP_PDF/200396269/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1601487582M0100000599517_M01MIC20007421_1.PDF