[06 Sep 2020 00:17:29] (index) database connection response [06 Sep 2020 00:17:29] (index) getConnection(): Resource id #1 [06 Sep 2020 00:17:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '64' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 00:17:29] (index) database connection response [06 Sep 2020 00:17:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '64' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 00:17:29] (index) database connection response [06 Sep 2020 00:17:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '64' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 00:17:29] (index) database connection response [06 Sep 2020 00:17:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365591' AND ACCESS_CODE = '68009604' [06 Sep 2020 00:17:29] (index) database connection response [06 Sep 2020 00:17:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365591' AND ACCESS_CODE = '68009604' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 00:17:29] (index) database connection response [06 Sep 2020 00:17:29] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000036228' [06 Sep 2020 00:17:29] (index) database connection response [06 Sep 2020 00:17:29] (index) getPatientReportsDetail() entered [06 Sep 2020 00:17:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365591', 'M0100000036228', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:17:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365591', 'M0100000036228', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:17:29] (index) p_Stop=N [06 Sep 2020 00:17:29] (index) p_Alert= [06 Sep 2020 00:17:29] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 00:17:29] (index) database connection response [06 Sep 2020 00:17:29] (index) getConnectionClose() called.... [06 Sep 2020 00:17:29] (index) getConnectionClose() called.... [06 Sep 2020 00:17:54] (viewOnlineReports) database connection response [06 Sep 2020 00:17:54] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:17:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:17:54] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:17:54] (viewOnlineReports) p_Alert= [06 Sep 2020 00:17:54] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:17:54] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380782', 'M01', '047', '2', '001000000000085651', 'M0100000036228_M01HEM20012106_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:17:54] (viewOnlineReports) database connection response [06 Sep 2020 00:17:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Sep 2020 00:17:54] (viewOnlineReports) database connection response [06 Sep 2020 00:17:54] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:17:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:17:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:17:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 00:17:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333474M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 00:17:55] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333474M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 00:17:55] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:17:55] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 00:17:55] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333474M0100000036228_M01HEM20012106_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 00:17:55] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333474M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 00:18:12] (viewOnlineReports) database connection response [06 Sep 2020 00:18:12] (viewOnlineReports) getConnection(): Resource id #2 [06 Sep 2020 00:18:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:18:12] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:18:12] (viewOnlineReports) p_Alert= [06 Sep 2020 00:18:12] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:18:12] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380782', 'M01', '047', '2', '001000000000085651', 'M0100000036228_M01HEM20012106_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:18:12] (viewOnlineReports) database connection response [06 Sep 2020 00:18:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Sep 2020 00:18:12] (viewOnlineReports) database connection response [06 Sep 2020 00:18:12] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:18:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:18:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:18:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 00:18:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1599333491M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 00:18:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1599333491M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 00:18:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:18:12] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 00:18:12] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1599333491M0100000036228_M01HEM20012106_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 00:18:12] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1599333491M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 00:18:45] (viewOnlineReports) database connection response [06 Sep 2020 00:18:45] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:18:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '3', '001000000000082607', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:18:45] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:18:45] (viewOnlineReports) p_Alert= [06 Sep 2020 00:18:45] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:18: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', '200380782', 'M01', '047', '3', '001000000000082607', 'M0100000036228_M01SCH20009067_1.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:18:45] (viewOnlineReports) database connection response [06 Sep 2020 00:18:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Sep 2020 00:18:45] (viewOnlineReports) database connection response [06 Sep 2020 00:18:45] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:18:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:18:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:18:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 00:18:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599333525M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 00:18:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599333525M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 00:18:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:18:45] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01SCH20009067_1.jpg [06 Sep 2020 00:18:45] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599333525M0100000036228_M01SCH20009067_1.PDF ../../TEMP_PDF/200380782/M0100000036228_M01SCH20009067_1.jpg [06 Sep 2020 00:18:45] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599333525M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 00:19:32] (viewOnlineReports) database connection response [06 Sep 2020 00:19:32] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:19:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '4', '001000000000086287', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:19:32] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:19:32] (viewOnlineReports) p_Alert= [06 Sep 2020 00:19:32] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:19: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', '200380782', 'M01', '047', '4', '001000000000086287', 'M0100000036228_M01SCH20009067_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:19:32] (viewOnlineReports) database connection response [06 Sep 2020 00:19:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [06 Sep 2020 00:19:32] (viewOnlineReports) database connection response [06 Sep 2020 00:19:32] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:19:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:19:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:19:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01SCH20009067_2.PDF [06 Sep 2020 00:19:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599333572M0100000036228_M01SCH20009067_2.PDF [06 Sep 2020 00:19:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599333572M0100000036228_M01SCH20009067_2.PDF [06 Sep 2020 00:19:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:19:32] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01SCH20009067_2.jpg [06 Sep 2020 00:19:32] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599333572M0100000036228_M01SCH20009067_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01SCH20009067_2.jpg [06 Sep 2020 00:19:32] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599333572M0100000036228_M01SCH20009067_2.PDF [06 Sep 2020 00:20:04] (viewOnlineReports) database connection response [06 Sep 2020 00:20:04] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:20:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '5', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:20:04] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:20:04] (viewOnlineReports) p_Alert= [06 Sep 2020 00:20:04] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:20: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', '200380782', 'M01', '047', '5', '001000000000086302', 'M0100000036228_M01SCH20009067_3.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:20:04] (viewOnlineReports) database connection response [06 Sep 2020 00:20:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [06 Sep 2020 00:20:04] (viewOnlineReports) database connection response [06 Sep 2020 00:20:04] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:20:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:20:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:20:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01SCH20009067_3.PDF [06 Sep 2020 00:20:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333604M0100000036228_M01SCH20009067_3.PDF [06 Sep 2020 00:20:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333604M0100000036228_M01SCH20009067_3.PDF [06 Sep 2020 00:20:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:20:04] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01SCH20009067_3.jpg [06 Sep 2020 00:20:04] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333604M0100000036228_M01SCH20009067_3.PDF ../../TEMP_PDF/200380782/M0100000036228_M01SCH20009067_3.jpg [06 Sep 2020 00:20:04] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333604M0100000036228_M01SCH20009067_3.PDF [06 Sep 2020 00:20:20] (viewOnlineReports) database connection response [06 Sep 2020 00:20:20] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:20:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '6', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:20:20] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:20:20] (viewOnlineReports) p_Alert= [06 Sep 2020 00:20:20] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:20: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', '200380782', 'M01', '047', '6', '001000000000084949', 'M0100000036228_M01RCH20016369_4.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:20:20] (viewOnlineReports) database connection response [06 Sep 2020 00:20:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [06 Sep 2020 00:20:20] (viewOnlineReports) database connection response [06 Sep 2020 00:20:20] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:20:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:20:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:20:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_4.PDF [06 Sep 2020 00:20:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599333620M0100000036228_M01RCH20016369_4.PDF [06 Sep 2020 00:20:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599333620M0100000036228_M01RCH20016369_4.PDF [06 Sep 2020 00:20:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:20:21] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_4.jpg [06 Sep 2020 00:20:21] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599333620M0100000036228_M01RCH20016369_4.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_4.jpg [06 Sep 2020 00:20:21] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599333620M0100000036228_M01RCH20016369_4.PDF [06 Sep 2020 00:21:00] (viewOnlineReports) database connection response [06 Sep 2020 00:21:00] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:21:00] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '8', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:21:00] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:21:00] (viewOnlineReports) p_Alert= [06 Sep 2020 00:21:00] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:21: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', '200380782', 'M01', '047', '8', '001000000000084296', 'M0100000036228_M01RCH20016369_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:21:00] (viewOnlineReports) database connection response [06 Sep 2020 00:21:00] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [06 Sep 2020 00:21:00] (viewOnlineReports) database connection response [06 Sep 2020 00:21:00] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:21:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:21:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:21:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_2.PDF [06 Sep 2020 00:21:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333660M0100000036228_M01RCH20016369_2.PDF [06 Sep 2020 00:21:00] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333660M0100000036228_M01RCH20016369_2.PDF [06 Sep 2020 00:21:00] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:21:00] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_2.jpg [06 Sep 2020 00:21:00] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333660M0100000036228_M01RCH20016369_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_2.jpg [06 Sep 2020 00:21:00] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333660M0100000036228_M01RCH20016369_2.PDF [06 Sep 2020 00:21:14] (viewOnlineReports) database connection response [06 Sep 2020 00:21:14] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:21:14] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '9', '001000000000083540', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:21:14] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:21:14] (viewOnlineReports) p_Alert= [06 Sep 2020 00:21:14] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:21:14] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380782', 'M01', '047', '9', '001000000000083540', 'M0100000036228_M01RCH20016369_1.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:21:14] (viewOnlineReports) database connection response [06 Sep 2020 00:21:14] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '9' [06 Sep 2020 00:21:14] (viewOnlineReports) database connection response [06 Sep 2020 00:21:14] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:21:14] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:21:14] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:21:14] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:21:14] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599333674M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:21:14] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599333674M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:21:14] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:21:14] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_1.jpg [06 Sep 2020 00:21:14] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599333674M0100000036228_M01RCH20016369_1.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_1.jpg [06 Sep 2020 00:21:14] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599333674M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:20] (viewOnlineReports) database connection response [06 Sep 2020 00:24:20] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:24:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '9', '001000000000083540', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:24:20] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:24:20] (viewOnlineReports) p_Alert= [06 Sep 2020 00:24:20] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:24: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', '200380782', 'M01', '047', '9', '001000000000083540', 'M0100000036228_M01RCH20016369_1.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:24:20] (viewOnlineReports) database connection response [06 Sep 2020 00:24:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '9' [06 Sep 2020 00:24:20] (viewOnlineReports) database connection response [06 Sep 2020 00:24:20] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:24:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:24:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:24:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1599333860M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1599333860M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:24:20] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_1.jpg [06 Sep 2020 00:24:20] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1599333860M0100000036228_M01RCH20016369_1.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_1.jpg [06 Sep 2020 00:24:20] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1599333860M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:30] (viewOnlineReports) database connection response [06 Sep 2020 00:24:30] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:24:30] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '9', '001000000000083540', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:24:30] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:24:30] (viewOnlineReports) p_Alert= [06 Sep 2020 00:24:30] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:24:30] (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', '200380782', 'M01', '047', '9', '001000000000083540', 'M0100000036228_M01RCH20016369_1.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:24:30] (viewOnlineReports) database connection response [06 Sep 2020 00:24:30] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '9' [06 Sep 2020 00:24:30] (viewOnlineReports) database connection response [06 Sep 2020 00:24:30] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:24:30] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:24:30] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:24:30] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:30] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333870M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:30] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333870M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:30] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:24:30] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_1.jpg [06 Sep 2020 00:24:30] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333870M0100000036228_M01RCH20016369_1.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_1.jpg [06 Sep 2020 00:24:30] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333870M0100000036228_M01RCH20016369_1.PDF [06 Sep 2020 00:24:58] (viewOnlineReports) database connection response [06 Sep 2020 00:24:58] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:24:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '8', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:24:58] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:24:58] (viewOnlineReports) p_Alert= [06 Sep 2020 00:24:58] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:24: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', '200380782', 'M01', '047', '8', '001000000000084296', 'M0100000036228_M01RCH20016369_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:24:58] (viewOnlineReports) database connection response [06 Sep 2020 00:24:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [06 Sep 2020 00:24:58] (viewOnlineReports) database connection response [06 Sep 2020 00:24:58] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:24:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:24:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:24:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_2.PDF [06 Sep 2020 00:24:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333897M0100000036228_M01RCH20016369_2.PDF [06 Sep 2020 00:24:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333897M0100000036228_M01RCH20016369_2.PDF [06 Sep 2020 00:24:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:24:58] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_2.jpg [06 Sep 2020 00:24:58] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333897M0100000036228_M01RCH20016369_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_2.jpg [06 Sep 2020 00:24:58] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599333897M0100000036228_M01RCH20016369_2.PDF [06 Sep 2020 00:27:22] (viewOnlineReports) database connection response [06 Sep 2020 00:27:22] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:27:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '5', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:27:22] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:27:22] (viewOnlineReports) p_Alert= [06 Sep 2020 00:27:22] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:27:22] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380782', 'M01', '047', '5', '001000000000086302', 'M0100000036228_M01SCH20009067_3.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:27:22] (viewOnlineReports) database connection response [06 Sep 2020 00:27:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [06 Sep 2020 00:27:22] (viewOnlineReports) database connection response [06 Sep 2020 00:27:22] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:27:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:27:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:27:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01SCH20009067_3.PDF [06 Sep 2020 00:27:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334042M0100000036228_M01SCH20009067_3.PDF [06 Sep 2020 00:27:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334042M0100000036228_M01SCH20009067_3.PDF [06 Sep 2020 00:27:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:27:22] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01SCH20009067_3.jpg [06 Sep 2020 00:27:22] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334042M0100000036228_M01SCH20009067_3.PDF ../../TEMP_PDF/200380782/M0100000036228_M01SCH20009067_3.jpg [06 Sep 2020 00:27:22] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334042M0100000036228_M01SCH20009067_3.PDF [06 Sep 2020 00:27:37] (viewOnlineReports) database connection response [06 Sep 2020 00:27:37] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:27:37] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '3', '001000000000082607', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:27:37] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:27:37] (viewOnlineReports) p_Alert= [06 Sep 2020 00:27:37] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:27: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', '200380782', 'M01', '047', '3', '001000000000082607', 'M0100000036228_M01SCH20009067_1.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 00:27:37] (viewOnlineReports) database connection response [06 Sep 2020 00:27:37] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Sep 2020 00:27:37] (viewOnlineReports) database connection response [06 Sep 2020 00:27:37] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:27:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 00:27:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 00:27:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 00:27:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599334057M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 00:27:37] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599334057M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 00:27:37] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:27:37] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01SCH20009067_1.jpg [06 Sep 2020 00:27:37] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599334057M0100000036228_M01SCH20009067_1.PDF ../../TEMP_PDF/200380782/M0100000036228_M01SCH20009067_1.jpg [06 Sep 2020 00:27:37] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599334057M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 00:28:47] (index) database connection response [06 Sep 2020 00:28:47] (index) getConnection(): Resource id #1 [06 Sep 2020 00:28:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 00:28:47] (index) database connection response [06 Sep 2020 00:28:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 00:28:47] (index) database connection response [06 Sep 2020 00:28:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 00:28:47] (index) database connection response [06 Sep 2020 00:28:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' [06 Sep 2020 00:28:48] (index) database connection response [06 Sep 2020 00:28:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 00:28:48] (index) database connection response [06 Sep 2020 00:28:48] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000593995' [06 Sep 2020 00:28:48] (index) database connection response [06 Sep 2020 00:28:48] (index) getPatientReportsDetail() entered [06 Sep 2020 00:28:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:28:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:28:48] (index) p_Stop=N [06 Sep 2020 00:28:48] (index) p_Alert= [06 Sep 2020 00:28: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 [06 Sep 2020 00:28:48] (index) database connection response [06 Sep 2020 00:28:48] (index) getConnectionClose() called.... [06 Sep 2020 00:28:48] (index) getConnectionClose() called.... [06 Sep 2020 00:28:56] (viewOnlineReports) database connection response [06 Sep 2020 00:28:56] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:28:56] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '2', '001000000000087040', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:28:56] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:28:56] (viewOnlineReports) p_Alert= [06 Sep 2020 00:28:56] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:28:56] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376613', 'M01', '001', '2', '001000000000087040', 'M0100000593995_M01MIC20006219_4.PDF', 'M0100000593995', SYSDATE) [06 Sep 2020 00:28:56] (viewOnlineReports) database connection response [06 Sep 2020 00:28:56] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [06 Sep 2020 00:28:56] (viewOnlineReports) database connection response [06 Sep 2020 00:28:56] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:28:56] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [06 Sep 2020 00:28:56] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [06 Sep 2020 00:28:56] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200903\M01\M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:28:56] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599334136M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:28:56] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599334136M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:28:56] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 00:28:56] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599334136M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:29:09] (viewOnlineReports) database connection response [06 Sep 2020 00:29:09] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:29:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '2', '001000000000087040', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:29:09] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:29:09] (viewOnlineReports) p_Alert= [06 Sep 2020 00:29:09] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:29: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', '200376613', 'M01', '001', '2', '001000000000087040', 'M0100000593995_M01MIC20006219_4.PDF', 'M0100000593995', SYSDATE) [06 Sep 2020 00:29:09] (viewOnlineReports) database connection response [06 Sep 2020 00:29:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [06 Sep 2020 00:29:09] (viewOnlineReports) database connection response [06 Sep 2020 00:29:09] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:29:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [06 Sep 2020 00:29:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [06 Sep 2020 00:29:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200903\M01\M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:29:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334149M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:29:09] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334149M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:29:09] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Sep 2020 00:29:09] (viewOnlineReports) Converting PDF to JPG with name as M0100000593995_M01MIC20006219_4.jpg [06 Sep 2020 00:29:09] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376613/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334149M0100000593995_M01MIC20006219_4.PDF ../../TEMP_PDF/200376613/M0100000593995_M01MIC20006219_4.jpg [06 Sep 2020 00:29:09] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376613/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334149M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:29:27] (viewOnlineReports) database connection response [06 Sep 2020 00:29:27] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:29:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '2', '001000000000087040', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:29:27] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:29:27] (viewOnlineReports) p_Alert= [06 Sep 2020 00:29:27] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:29: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', '200376613', 'M01', '001', '2', '001000000000087040', 'M0100000593995_M01MIC20006219_4.PDF', 'M0100000593995', SYSDATE) [06 Sep 2020 00:29:27] (viewOnlineReports) database connection response [06 Sep 2020 00:29:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [06 Sep 2020 00:29:27] (viewOnlineReports) database connection response [06 Sep 2020 00:29:27] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:29:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [06 Sep 2020 00:29:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [06 Sep 2020 00:29:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200903\M01\M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:29:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1599334167M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:29:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1599334167M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:29:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:29:27] (viewOnlineReports) Converting PDF to JPG with name as M0100000593995_M01MIC20006219_4.jpg [06 Sep 2020 00:29:27] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1599334167M0100000593995_M01MIC20006219_4.PDF ../../TEMP_PDF/200376613/M0100000593995_M01MIC20006219_4.jpg [06 Sep 2020 00:29:27] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376613/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1599334167M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:30:57] (viewOnlineReports) database connection response [06 Sep 2020 00:30:57] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:30:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000593995', '001', '200376613', '2', '001000000000087040', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:30:57] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:30:57] (viewOnlineReports) p_Alert= [06 Sep 2020 00:30:57] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:30:57] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376613', 'M01', '001', '2', '001000000000087040', 'M0100000593995_M01MIC20006219_4.PDF', 'M0100000593995', SYSDATE) [06 Sep 2020 00:30:57] (viewOnlineReports) database connection response [06 Sep 2020 00:30:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376613' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [06 Sep 2020 00:30:57] (viewOnlineReports) database connection response [06 Sep 2020 00:30:57] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:30:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376613/ [06 Sep 2020 00:30:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376613/ [06 Sep 2020 00:30:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200903\M01\M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:30:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376613/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334257M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:30:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376613/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334257M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:30:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 00:30:57] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376613/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334257M0100000593995_M01MIC20006219_4.PDF [06 Sep 2020 00:32:35] (index) database connection response [06 Sep 2020 00:32:35] (index) getConnection(): Resource id #1 [06 Sep 2020 00:32:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 00:32:35] (index) database connection response [06 Sep 2020 00:32:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 00:32:35] (index) database connection response [06 Sep 2020 00:32:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 00:32:35] (index) database connection response [06 Sep 2020 00:32:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365246' AND ACCESS_CODE = '94182234' [06 Sep 2020 00:32:35] (index) database connection response [06 Sep 2020 00:32:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365246' AND ACCESS_CODE = '94182234' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 00:32:35] (index) database connection response [06 Sep 2020 00:32:35] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000021138' [06 Sep 2020 00:32:35] (index) database connection response [06 Sep 2020 00:32:35] (index) getPatientReportsDetail() entered [06 Sep 2020 00:32:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365246', 'M0100000021138', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:32:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365246', 'M0100000021138', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:32:35] (index) p_Stop=N [06 Sep 2020 00:32:35] (index) p_Alert= [06 Sep 2020 00:32:35] (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 [06 Sep 2020 00:32:35] (index) database connection response [06 Sep 2020 00:32:35] (index) getConnectionClose() called.... [06 Sep 2020 00:32:35] (index) getConnectionClose() called.... [06 Sep 2020 00:33:04] (viewOnlineReports) database connection response [06 Sep 2020 00:33:04] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:33:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000021138', '001', '200380650', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:33:04] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:33:04] (viewOnlineReports) p_Alert= [06 Sep 2020 00:33:04] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:33: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', '200380650', 'M01', '047', '1', '001000000000085025', 'M0100000021138_M01HEM20012094_1.PDF', 'M0100000021138', SYSDATE) [06 Sep 2020 00:33:04] (viewOnlineReports) database connection response [06 Sep 2020 00:33:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380650' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 00:33:04] (viewOnlineReports) database connection response [06 Sep 2020 00:33:04] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:33:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380650/ [06 Sep 2020 00:33:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380650/ [06 Sep 2020 00:33:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380650/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1599334384M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380650/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1599334384M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 00:33:05] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380650/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1599334384M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:13] (viewOnlineReports) database connection response [06 Sep 2020 00:33:13] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:33:13] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000021138', '001', '200380650', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:33:13] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:33:13] (viewOnlineReports) p_Alert= [06 Sep 2020 00:33:13] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:33: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', '200380650', 'M01', '047', '1', '001000000000085025', 'M0100000021138_M01HEM20012094_1.PDF', 'M0100000021138', SYSDATE) [06 Sep 2020 00:33:13] (viewOnlineReports) database connection response [06 Sep 2020 00:33:13] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380650' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 00:33:13] (viewOnlineReports) database connection response [06 Sep 2020 00:33:13] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:33:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380650/ [06 Sep 2020 00:33:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380650/ [06 Sep 2020 00:33:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380650/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334393M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380650/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334393M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 00:33:13] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380650/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334393M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:22] (viewOnlineReports) database connection response [06 Sep 2020 00:33:22] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:33:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000021138', '001', '200380650', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:33:22] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:33:22] (viewOnlineReports) p_Alert= [06 Sep 2020 00:33:22] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:33:22] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380650', 'M01', '047', '1', '001000000000085025', 'M0100000021138_M01HEM20012094_1.PDF', 'M0100000021138', SYSDATE) [06 Sep 2020 00:33:22] (viewOnlineReports) database connection response [06 Sep 2020 00:33:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380650' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 00:33:22] (viewOnlineReports) database connection response [06 Sep 2020 00:33:22] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:33:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380650/ [06 Sep 2020 00:33:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380650/ [06 Sep 2020 00:33:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380650/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1599334402M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380650/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1599334402M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:33:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 00:33:22] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380650/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1599334402M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 00:41:08] (index) database connection response [06 Sep 2020 00:41:08] (index) getConnection(): Resource id #1 [06 Sep 2020 00:41:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 00:41:08] (index) database connection response [06 Sep 2020 00:41:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 00:41:08] (index) database connection response [06 Sep 2020 00:41:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 00:41:08] (index) database connection response [06 Sep 2020 00:41:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200364861' AND ACCESS_CODE = '93597681' [06 Sep 2020 00:41:08] (index) database connection response [06 Sep 2020 00:41:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200364861' AND ACCESS_CODE = '93597681' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 00:41:08] (index) database connection response [06 Sep 2020 00:41:08] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000632039' [06 Sep 2020 00:41:08] (index) database connection response [06 Sep 2020 00:41:08] (index) getPatientReportsDetail() entered [06 Sep 2020 00:41:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200364861', 'M0100000632039', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:41:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200364861', 'M0100000632039', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:41:08] (index) p_Stop=N [06 Sep 2020 00:41:08] (index) p_Alert= [06 Sep 2020 00:41: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 [06 Sep 2020 00:41:08] (index) database connection response [06 Sep 2020 00:41:08] (index) getConnectionClose() called.... [06 Sep 2020 00:41:08] (index) getConnectionClose() called.... [06 Sep 2020 00:41:21] (viewOnlineReports) database connection response [06 Sep 2020 00:41:21] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:41:21] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632039', '001', '200380488', '3', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:41:21] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:41:21] (viewOnlineReports) p_Alert= [06 Sep 2020 00:41:21] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:41: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', '200380488', 'M01', '047', '3', '001000000000082306', 'M0100000632039_M01SCH20009046_1.PDF', 'M0100000632039', SYSDATE) [06 Sep 2020 00:41:21] (viewOnlineReports) database connection response [06 Sep 2020 00:41:21] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Sep 2020 00:41:21] (viewOnlineReports) database connection response [06 Sep 2020 00:41:21] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:41:21] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 00:41:21] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 00:41:21] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 00:41:21] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334881M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 00:41:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334881M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 00:41:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 00:41:21] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380488/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599334881M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 00:41:34] (viewOnlineReports) database connection response [06 Sep 2020 00:41:34] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:41:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632039', '001', '200380488', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:41:34] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:41:34] (viewOnlineReports) p_Alert= [06 Sep 2020 00:41:34] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:41: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', '200380488', 'M01', '047', '1', '001000000000085025', 'M0100000632039_M01HEM20012079_1.PDF', 'M0100000632039', SYSDATE) [06 Sep 2020 00:41:34] (viewOnlineReports) database connection response [06 Sep 2020 00:41:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 00:41:34] (viewOnlineReports) database connection response [06 Sep 2020 00:41:34] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:41:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 00:41:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 00:41:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01HEM20012079_1.PDF [06 Sep 2020 00:41:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1599334894M0100000632039_M01HEM20012079_1.PDF [06 Sep 2020 00:41:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1599334894M0100000632039_M01HEM20012079_1.PDF [06 Sep 2020 00:41:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 00:41:34] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380488/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1599334894M0100000632039_M01HEM20012079_1.PDF [06 Sep 2020 00:41:46] (viewOnlineReports) database connection response [06 Sep 2020 00:41:46] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:41:46] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632039', '001', '200380488', '2', '001000000000083540', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:41:46] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:41:46] (viewOnlineReports) p_Alert= [06 Sep 2020 00:41:46] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:41: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', '200380488', 'M01', '047', '2', '001000000000083540', 'M0100000632039_M01RCH20016333_1.PDF', 'M0100000632039', SYSDATE) [06 Sep 2020 00:41:46] (viewOnlineReports) database connection response [06 Sep 2020 00:41:46] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Sep 2020 00:41:46] (viewOnlineReports) database connection response [06 Sep 2020 00:41:46] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:41:46] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 00:41:46] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 00:41:46] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01RCH20016333_1.PDF [06 Sep 2020 00:41:46] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599334906M0100000632039_M01RCH20016333_1.PDF [06 Sep 2020 00:41:46] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599334906M0100000632039_M01RCH20016333_1.PDF [06 Sep 2020 00:41:46] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 00:41:46] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599334906M0100000632039_M01RCH20016333_1.PDF [06 Sep 2020 00:41:57] (viewOnlineReports) database connection response [06 Sep 2020 00:41:57] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:41:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632039', '001', '200380488', '4', '001000000000084480', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:41:57] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:41:57] (viewOnlineReports) p_Alert= [06 Sep 2020 00:41:57] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:41:57] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380488', 'M01', '047', '4', '001000000000084480', 'M0100000632039_M01SCH20009046_4.PDF', 'M0100000632039', SYSDATE) [06 Sep 2020 00:41:57] (viewOnlineReports) database connection response [06 Sep 2020 00:41:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [06 Sep 2020 00:41:57] (viewOnlineReports) database connection response [06 Sep 2020 00:41:57] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:41:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 00:41:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 00:41:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01SCH20009046_4.PDF [06 Sep 2020 00:41:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599334917M0100000632039_M01SCH20009046_4.PDF [06 Sep 2020 00:41:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599334917M0100000632039_M01SCH20009046_4.PDF [06 Sep 2020 00:41:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 00:41:57] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599334917M0100000632039_M01SCH20009046_4.PDF [06 Sep 2020 00:42:09] (viewOnlineReports) database connection response [06 Sep 2020 00:42:09] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:42:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632039', '001', '200380488', '5', '001000000000084436', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:42:09] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:42:09] (viewOnlineReports) p_Alert= [06 Sep 2020 00:42:09] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:42: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', '200380488', 'M01', '047', '5', '001000000000084436', 'M0100000632039_M01SCH20009046_2.PDF', 'M0100000632039', SYSDATE) [06 Sep 2020 00:42:09] (viewOnlineReports) database connection response [06 Sep 2020 00:42:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [06 Sep 2020 00:42:09] (viewOnlineReports) database connection response [06 Sep 2020 00:42:09] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:42:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 00:42:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 00:42:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01SCH20009046_2.PDF [06 Sep 2020 00:42:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1599334929M0100000632039_M01SCH20009046_2.PDF [06 Sep 2020 00:42:09] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1599334929M0100000632039_M01SCH20009046_2.PDF [06 Sep 2020 00:42:09] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 00:42:09] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380488/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1599334929M0100000632039_M01SCH20009046_2.PDF [06 Sep 2020 00:42:16] (viewOnlineReports) database connection response [06 Sep 2020 00:42:16] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:42:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632039', '001', '200380488', '6', '001000000000084443', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:42:16] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:42:16] (viewOnlineReports) p_Alert= [06 Sep 2020 00:42:16] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:42: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', '200380488', 'M01', '047', '6', '001000000000084443', 'M0100000632039_M01SCH20009046_3.PDF', 'M0100000632039', SYSDATE) [06 Sep 2020 00:42:16] (viewOnlineReports) database connection response [06 Sep 2020 00:42:16] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [06 Sep 2020 00:42:16] (viewOnlineReports) database connection response [06 Sep 2020 00:42:16] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:42:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 00:42:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 00:42:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01SCH20009046_3.PDF [06 Sep 2020 00:42:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1599334936M0100000632039_M01SCH20009046_3.PDF [06 Sep 2020 00:42:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1599334936M0100000632039_M01SCH20009046_3.PDF [06 Sep 2020 00:42:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 00:42:16] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380488/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1599334936M0100000632039_M01SCH20009046_3.PDF [06 Sep 2020 00:48:42] (index) database connection response [06 Sep 2020 00:48:42] (index) getConnection(): Resource id #1 [06 Sep 2020 00:48:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 00:48:42] (index) database connection response [06 Sep 2020 00:48:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 00:48:42] (index) database connection response [06 Sep 2020 00:48:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 00:48:42] (index) database connection response [06 Sep 2020 00:48:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200364861' AND ACCESS_CODE = '93597681' [06 Sep 2020 00:48:42] (index) database connection response [06 Sep 2020 00:48:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200364861' AND ACCESS_CODE = '93597681' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 00:48:42] (index) database connection response [06 Sep 2020 00:48:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000632039' [06 Sep 2020 00:48:42] (index) database connection response [06 Sep 2020 00:48:42] (index) getPatientReportsDetail() entered [06 Sep 2020 00:48:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200364861', 'M0100000632039', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:48:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200364861', 'M0100000632039', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:48:42] (index) p_Stop=N [06 Sep 2020 00:48:42] (index) p_Alert= [06 Sep 2020 00:48:42] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 00:48:42] (index) database connection response [06 Sep 2020 00:48:42] (index) getConnectionClose() called.... [06 Sep 2020 00:48:42] (index) getConnectionClose() called.... [06 Sep 2020 00:49:05] (viewOnlineReports) database connection response [06 Sep 2020 00:49:05] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:49:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632039', '001', '200380488', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:49:05] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:49:05] (viewOnlineReports) p_Alert= [06 Sep 2020 00:49:05] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:49: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', '200380488', 'M01', '047', '1', '001000000000085025', 'M0100000632039_M01HEM20012079_1.PDF', 'M0100000632039', SYSDATE) [06 Sep 2020 00:49:05] (viewOnlineReports) database connection response [06 Sep 2020 00:49:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 00:49:05] (viewOnlineReports) database connection response [06 Sep 2020 00:49:05] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:49:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 00:49:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 00:49:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01HEM20012079_1.PDF [06 Sep 2020 00:49:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599335345M0100000632039_M01HEM20012079_1.PDF [06 Sep 2020 00:49:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599335345M0100000632039_M01HEM20012079_1.PDF [06 Sep 2020 00:49:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 00:49:05] (viewOnlineReports) Converting PDF to JPG with name as M0100000632039_M01HEM20012079_1.jpg [06 Sep 2020 00:49:05] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599335345M0100000632039_M01HEM20012079_1.PDF ../../TEMP_PDF/200380488/M0100000632039_M01HEM20012079_1.jpg [06 Sep 2020 00:49:05] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599335345M0100000632039_M01HEM20012079_1.PDF [06 Sep 2020 00:49:18] (viewOnlineReports) database connection response [06 Sep 2020 00:49:18] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:49:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632039', '001', '200380488', '3', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:49:18] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:49:18] (viewOnlineReports) p_Alert= [06 Sep 2020 00:49:18] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:49: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', '200380488', 'M01', '047', '3', '001000000000082306', 'M0100000632039_M01SCH20009046_1.PDF', 'M0100000632039', SYSDATE) [06 Sep 2020 00:49:18] (viewOnlineReports) database connection response [06 Sep 2020 00:49:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Sep 2020 00:49:18] (viewOnlineReports) database connection response [06 Sep 2020 00:49:18] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:49:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 00:49:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 00:49:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 00:49:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599335358M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 00:49:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599335358M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 00:49:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Sep 2020 00:49:18] (viewOnlineReports) Converting PDF to JPG with name as M0100000632039_M01SCH20009046_1.jpg [06 Sep 2020 00:49:18] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599335358M0100000632039_M01SCH20009046_1.PDF ../../TEMP_PDF/200380488/M0100000632039_M01SCH20009046_1.jpg [06 Sep 2020 00:49:18] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380488/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599335358M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 00:49:29] (index) database connection response [06 Sep 2020 00:49:29] (index) getConnection(): Resource id #1 [06 Sep 2020 00:49:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 00:49:29] (index) database connection response [06 Sep 2020 00:49:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 00:49:29] (index) database connection response [06 Sep 2020 00:49:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 00:49:29] (index) database connection response [06 Sep 2020 00:49:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365341' AND ACCESS_CODE = '83085870' [06 Sep 2020 00:49:29] (index) database connection response [06 Sep 2020 00:49:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365341' AND ACCESS_CODE = '83085870' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 00:49:29] (index) database connection response [06 Sep 2020 00:49:29] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000046258' [06 Sep 2020 00:49:29] (index) database connection response [06 Sep 2020 00:49:29] (index) getPatientReportsDetail() entered [06 Sep 2020 00:49:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365341', 'M0100000046258', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:49:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365341', 'M0100000046258', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:49:29] (index) p_Stop=N [06 Sep 2020 00:49:29] (index) p_Alert= [06 Sep 2020 00:49:29] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 00:49:29] (index) database connection response [06 Sep 2020 00:49:29] (index) getConnectionClose() called.... [06 Sep 2020 00:49:29] (index) getConnectionClose() called.... [06 Sep 2020 00:49:38] (viewOnlineReports) database connection response [06 Sep 2020 00:49:38] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 00:49:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000046258', '001', '200380685', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 00:49:38] (viewOnlineReports) p_Stop=N [06 Sep 2020 00:49:38] (viewOnlineReports) p_Alert= [06 Sep 2020 00:49:38] (viewOnlineReports) Flag = 1 [06 Sep 2020 00:49: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', '200380685', 'M01', '047', '1', '001000000000085025', 'M0100000046258_M01HEM20012097_1.PDF', 'M0100000046258', SYSDATE) [06 Sep 2020 00:49:38] (viewOnlineReports) database connection response [06 Sep 2020 00:49:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380685' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 00:49:38] (viewOnlineReports) database connection response [06 Sep 2020 00:49:38] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 00:49:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380685/ [06 Sep 2020 00:49:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380685/ [06 Sep 2020 00:49:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000046258_M01HEM20012097_1.PDF [06 Sep 2020 00:49:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380685/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599335377M0100000046258_M01HEM20012097_1.PDF [06 Sep 2020 00:49:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380685/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599335377M0100000046258_M01HEM20012097_1.PDF [06 Sep 2020 00:49:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 00:49:38] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380685/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599335377M0100000046258_M01HEM20012097_1.PDF [06 Sep 2020 01:14:37] (viewOnlineReports) database connection response [06 Sep 2020 01:14:37] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 01:14:37] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200380488', '3', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 01:14:37] (viewOnlineReports) p_Stop=N [06 Sep 2020 01:14:37] (viewOnlineReports) p_Alert= [06 Sep 2020 01:14:37] (viewOnlineReports) Flag = 1 [06 Sep 2020 01:14: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', '200380488', 'M01', '047', '3', '001000000000082306', 'M0100000632039_M01SCH20009046_1.PDF', '00100000000000', SYSDATE) [06 Sep 2020 01:14:37] (viewOnlineReports) database connection response [06 Sep 2020 01:14:37] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380488' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Sep 2020 01:14:37] (viewOnlineReports) database connection response [06 Sep 2020 01:14:37] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 01:14:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380488/ [06 Sep 2020 01:14:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380488/ [06 Sep 2020 01:14:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 01:14:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380488/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZM0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 01:14:37] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380488/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZM0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 01:14:37] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Sep 2020 01:14:37] (viewOnlineReports) Converting PDF to JPG with name as M0100000632039_M01SCH20009046_1.jpg [06 Sep 2020 01:14:37] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380488/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZM0100000632039_M01SCH20009046_1.PDF ../../TEMP_PDF/200380488/M0100000632039_M01SCH20009046_1.jpg [06 Sep 2020 01:14:37] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380488/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZM0100000632039_M01SCH20009046_1.PDF [06 Sep 2020 01:24:53] (viewOnlineReports) database connection response [06 Sep 2020 01:24:53] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 01:24:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', '00100000000000', '001', '200374285', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 01:24:53] (viewOnlineReports) p_Stop=N [06 Sep 2020 01:24:53] (viewOnlineReports) p_Alert= [06 Sep 2020 01:24:53] (viewOnlineReports) Flag = 1 [06 Sep 2020 01:24: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', '200374285', 'M01', '001', '2', '001000000000087086', 'M0100000513156_M01MIC20006022_1.PDF', '00100000000000', SYSDATE) [06 Sep 2020 01:24:53] (viewOnlineReports) database connection response [06 Sep 2020 01:24:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200374285' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [06 Sep 2020 01:24:53] (viewOnlineReports) database connection response [06 Sep 2020 01:24:53] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 01:24:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200374285/ [06 Sep 2020 01:24:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200374285/ [06 Sep 2020 01:24:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200824\M01\M0100000513156_M01MIC20006022_1.PDF [06 Sep 2020 01:24:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200374285/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000513156_M01MIC20006022_1.PDF [06 Sep 2020 01:24:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200374285/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000513156_M01MIC20006022_1.PDF [06 Sep 2020 01:24:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 01:24:53] (viewOnlineReports) Downloading file ../../TEMP_PDF/200374285/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000513156_M01MIC20006022_1.PDF [06 Sep 2020 01:46:53] (index) database connection response [06 Sep 2020 01:46:53] (index) getConnection(): Resource id #1 [06 Sep 2020 01:46:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 01:46:53] (index) database connection response [06 Sep 2020 01:46:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 01:46:53] (index) database connection response [06 Sep 2020 01:46:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 01:46:53] (index) database connection response [06 Sep 2020 01:46:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365194' AND ACCESS_CODE = '95452095' [06 Sep 2020 01:46:53] (index) database connection response [06 Sep 2020 01:46:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365194' AND ACCESS_CODE = '95452095' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 01:46:53] (index) database connection response [06 Sep 2020 01:46:53] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000003258' [06 Sep 2020 01:46:53] (index) database connection response [06 Sep 2020 01:46:53] (index) getPatientReportsDetail() entered [06 Sep 2020 01:46:53] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365194', 'M0100000003258', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 01:46:53] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365194', 'M0100000003258', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 01:46:53] (index) p_Stop=N [06 Sep 2020 01:46:53] (index) p_Alert= [06 Sep 2020 01:46:53] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 01:46:53] (index) database connection response [06 Sep 2020 01:46:53] (index) getConnectionClose() called.... [06 Sep 2020 01:46:53] (index) getConnectionClose() called.... [06 Sep 2020 01:47:01] (viewOnlineReports) database connection response [06 Sep 2020 01:47:01] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 01:47:01] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000003258', '001', '200380633', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 01:47:01] (viewOnlineReports) p_Stop=N [06 Sep 2020 01:47:01] (viewOnlineReports) p_Alert= [06 Sep 2020 01:47:01] (viewOnlineReports) Flag = 1 [06 Sep 2020 01:47: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', '200380633', 'M01', '047', '1', '001000000000085025', 'M0100000003258_M01HEM20012092_1.PDF', 'M0100000003258', SYSDATE) [06 Sep 2020 01:47:01] (viewOnlineReports) database connection response [06 Sep 2020 01:47:01] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380633' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 01:47:01] (viewOnlineReports) database connection response [06 Sep 2020 01:47:01] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 01:47:01] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380633/ [06 Sep 2020 01:47:01] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380633/ [06 Sep 2020 01:47:01] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000003258_M01HEM20012092_1.PDF [06 Sep 2020 01:47:01] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380633/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1599338821M0100000003258_M01HEM20012092_1.PDF [06 Sep 2020 01:47:01] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380633/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1599338821M0100000003258_M01HEM20012092_1.PDF [06 Sep 2020 01:47:01] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 01:47:01] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380633/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1599338821M0100000003258_M01HEM20012092_1.PDF [06 Sep 2020 01:59:37] (index) database connection response [06 Sep 2020 01:59:37] (index) getConnection(): Resource id #1 [06 Sep 2020 01:59:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 01:59:37] (index) database connection response [06 Sep 2020 01:59:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 01:59:37] (index) database connection response [06 Sep 2020 01:59:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 01:59:37] (index) database connection response [06 Sep 2020 01:59:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365591' AND ACCESS_CODE = '68009604' [06 Sep 2020 01:59:37] (index) database connection response [06 Sep 2020 01:59:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365591' AND ACCESS_CODE = '68009604' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 01:59:37] (index) database connection response [06 Sep 2020 01:59:37] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000036228' [06 Sep 2020 01:59:37] (index) database connection response [06 Sep 2020 01:59:37] (index) getPatientReportsDetail() entered [06 Sep 2020 01:59:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365591', 'M0100000036228', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 01:59:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365591', 'M0100000036228', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 01:59:37] (index) p_Stop=N [06 Sep 2020 01:59:37] (index) p_Alert= [06 Sep 2020 01:59: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 [06 Sep 2020 01:59:37] (index) database connection response [06 Sep 2020 01:59:37] (index) getConnectionClose() called.... [06 Sep 2020 01:59:37] (index) getConnectionClose() called.... [06 Sep 2020 01:59:57] (viewOnlineReports) database connection response [06 Sep 2020 01:59:57] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 01:59:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '7', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 01:59:57] (viewOnlineReports) p_Stop=N [06 Sep 2020 01:59:57] (viewOnlineReports) p_Alert= [06 Sep 2020 01:59:57] (viewOnlineReports) Flag = 1 [06 Sep 2020 01:59:57] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380782', 'M01', '047', '7', '001000000000084460', 'M0100000036228_M01RCH20016369_3.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 01:59:57] (viewOnlineReports) database connection response [06 Sep 2020 01:59:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [06 Sep 2020 01:59:57] (viewOnlineReports) database connection response [06 Sep 2020 01:59:57] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 01:59:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 01:59:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 01:59:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 01:59:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599339597M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 01:59:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599339597M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 01:59:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 01:59:57] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_3.jpg [06 Sep 2020 01:59:57] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599339597M0100000036228_M01RCH20016369_3.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_3.jpg [06 Sep 2020 01:59:57] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599339597M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 02:00:15] (viewOnlineReports) database connection response [06 Sep 2020 02:00:15] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 02:00:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '7', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 02:00:15] (viewOnlineReports) p_Stop=N [06 Sep 2020 02:00:15] (viewOnlineReports) p_Alert= [06 Sep 2020 02:00:15] (viewOnlineReports) Flag = 1 [06 Sep 2020 02:00: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', '200380782', 'M01', '047', '7', '001000000000084460', 'M0100000036228_M01RCH20016369_3.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 02:00:15] (viewOnlineReports) database connection response [06 Sep 2020 02:00:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [06 Sep 2020 02:00:15] (viewOnlineReports) database connection response [06 Sep 2020 02:00:15] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 02:00:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 02:00:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 02:00:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 02:00:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599339615M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 02:00:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599339615M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 02:00:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 02:00:15] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_3.jpg [06 Sep 2020 02:00:15] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599339615M0100000036228_M01RCH20016369_3.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_3.jpg [06 Sep 2020 02:00:16] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599339615M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 02:00:31] (viewOnlineReports) database connection response [06 Sep 2020 02:00:31] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 02:00:31] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '7', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 02:00:31] (viewOnlineReports) p_Stop=N [06 Sep 2020 02:00:31] (viewOnlineReports) p_Alert= [06 Sep 2020 02:00:31] (viewOnlineReports) Flag = 1 [06 Sep 2020 02:00: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', '200380782', 'M01', '047', '7', '001000000000084460', 'M0100000036228_M01RCH20016369_3.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 02:00:31] (viewOnlineReports) database connection response [06 Sep 2020 02:00:31] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [06 Sep 2020 02:00:31] (viewOnlineReports) database connection response [06 Sep 2020 02:00:31] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 02:00:31] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 02:00:31] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 02:00:31] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 02:00:31] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599339631M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 02:00:31] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599339631M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 02:00:31] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Sep 2020 02:00:31] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_3.jpg [06 Sep 2020 02:00:31] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599339631M0100000036228_M01RCH20016369_3.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_3.jpg [06 Sep 2020 02:00:31] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599339631M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 10:03:11] (index) database connection response [06 Sep 2020 10:03:11] (index) getConnection(): Resource id #1 [06 Sep 2020 10:03:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 10:03:11] (index) database connection response [06 Sep 2020 10:03:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 10:03:11] (index) database connection response [06 Sep 2020 10:03:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 10:03:11] (index) database connection response [06 Sep 2020 10:03:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365627' AND ACCESS_CODE = '57819023' [06 Sep 2020 10:03:11] (index) database connection response [06 Sep 2020 10:03:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365627' AND ACCESS_CODE = '57819023' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 10:03:11] (index) database connection response [06 Sep 2020 10:03:11] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000052946' [06 Sep 2020 10:03:12] (index) database connection response [06 Sep 2020 10:03:12] (index) getPatientReportsDetail() entered [06 Sep 2020 10:03:12] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365627', 'M0100000052946', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:03:12] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365627', 'M0100000052946', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:03:12] (index) p_Stop=N [06 Sep 2020 10:03:12] (index) p_Alert= [06 Sep 2020 10:03:12] (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 [06 Sep 2020 10:03:12] (index) database connection response [06 Sep 2020 10:03:12] (index) getConnectionClose() called.... [06 Sep 2020 10:03:12] (index) getConnectionClose() called.... [06 Sep 2020 10:03:35] (viewOnlineReports) database connection response [06 Sep 2020 10:03:35] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:03:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052946', '001', '200380798', '2', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:03:35] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:03:35] (viewOnlineReports) p_Alert= [06 Sep 2020 10:03:35] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:03: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', '200380798', 'M01', '001', '2', '001000000000084460', 'M0100000052946_M01RCH20016371_1.PDF', 'M0100000052946', SYSDATE) [06 Sep 2020 10:03:35] (viewOnlineReports) database connection response [06 Sep 2020 10:03:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380798' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [06 Sep 2020 10:03:35] (viewOnlineReports) database connection response [06 Sep 2020 10:03:35] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:03:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380798/ [06 Sep 2020 10:03:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380798/ [06 Sep 2020 10:03:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:03:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380798/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599368615M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:03:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380798/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599368615M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:03:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 10:03:35] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380798/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599368615M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:03:51] (viewOnlineReports) database connection response [06 Sep 2020 10:03:51] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:03:51] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052946', '001', '200380798', '2', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:03:51] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:03:51] (viewOnlineReports) p_Alert= [06 Sep 2020 10:03:51] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:03:51] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380798', 'M01', '001', '2', '001000000000084460', 'M0100000052946_M01RCH20016371_1.PDF', 'M0100000052946', SYSDATE) [06 Sep 2020 10:03:51] (viewOnlineReports) database connection response [06 Sep 2020 10:03:51] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380798' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [06 Sep 2020 10:03:51] (viewOnlineReports) database connection response [06 Sep 2020 10:03:51] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:03:51] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380798/ [06 Sep 2020 10:03:51] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380798/ [06 Sep 2020 10:03:51] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:03:51] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380798/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599368631M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:03:51] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380798/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599368631M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:03:51] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 10:03:51] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380798/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599368631M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:05:12] (viewOnlineReports) database connection response [06 Sep 2020 10:05:12] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:05:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052946', '001', '200380798', '4', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:05:12] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:05:12] (viewOnlineReports) p_Alert= [06 Sep 2020 10:05:12] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:05:12] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380798', 'M01', '001', '4', '001000000000087100', 'M0100000052946_M01MIC20006513_1.PDF', 'M0100000052946', SYSDATE) [06 Sep 2020 10:05:12] (viewOnlineReports) database connection response [06 Sep 2020 10:05:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380798' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '4' [06 Sep 2020 10:05:12] (viewOnlineReports) database connection response [06 Sep 2020 10:05:12] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:05:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380798/ [06 Sep 2020 10:05:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380798/ [06 Sep 2020 10:05:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000052946_M01MIC20006513_1.PDF [06 Sep 2020 10:05:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380798/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599368712M0100000052946_M01MIC20006513_1.PDF [06 Sep 2020 10:05:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380798/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599368712M0100000052946_M01MIC20006513_1.PDF [06 Sep 2020 10:05:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 10:05:12] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380798/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599368712M0100000052946_M01MIC20006513_1.PDF [06 Sep 2020 10:06:19] (viewOnlineReports) database connection response [06 Sep 2020 10:06:19] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:06:19] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000052946', '001', '200380798', '2', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:06:19] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:06:19] (viewOnlineReports) p_Alert= [06 Sep 2020 10:06:19] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:06: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', '200380798', 'M01', '001', '2', '001000000000084460', 'M0100000052946_M01RCH20016371_1.PDF', 'M0100000052946', SYSDATE) [06 Sep 2020 10:06:19] (viewOnlineReports) database connection response [06 Sep 2020 10:06:19] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380798' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [06 Sep 2020 10:06:19] (viewOnlineReports) database connection response [06 Sep 2020 10:06:19] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:06:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380798/ [06 Sep 2020 10:06:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380798/ [06 Sep 2020 10:06:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:06:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380798/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599368779M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:06:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380798/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599368779M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:06:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 10:06:19] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380798/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599368779M0100000052946_M01RCH20016371_1.PDF [06 Sep 2020 10:53:23] (index) database connection response [06 Sep 2020 10:53:23] (index) getConnection(): Resource id #1 [06 Sep 2020 10:53:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 10:53:23] (index) database connection response [06 Sep 2020 10:53:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 10:53:23] (index) database connection response [06 Sep 2020 10:53:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 10:53:23] (index) database connection response [06 Sep 2020 10:53:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365591' AND ACCESS_CODE = '68009604' [06 Sep 2020 10:53:23] (index) database connection response [06 Sep 2020 10:53:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365591' AND ACCESS_CODE = '68009604' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 10:53:23] (index) database connection response [06 Sep 2020 10:53:23] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000036228' [06 Sep 2020 10:53:23] (index) database connection response [06 Sep 2020 10:53:23] (index) getPatientReportsDetail() entered [06 Sep 2020 10:53:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365591', 'M0100000036228', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:53:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365591', 'M0100000036228', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:53:23] (index) p_Stop=N [06 Sep 2020 10:53:23] (index) p_Alert= [06 Sep 2020 10:53:23] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 10:53:23] (index) database connection response [06 Sep 2020 10:53:23] (index) getConnectionClose() called.... [06 Sep 2020 10:53:23] (index) getConnectionClose() called.... [06 Sep 2020 10:56:34] (viewOnlineReports) database connection response [06 Sep 2020 10:56:34] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:56:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:56:34] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:56:34] (viewOnlineReports) p_Alert= [06 Sep 2020 10:56:34] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:56: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', '200380782', 'M01', '047', '2', '001000000000085651', 'M0100000036228_M01HEM20012106_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 10:56:34] (viewOnlineReports) database connection response [06 Sep 2020 10:56:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Sep 2020 10:56:34] (viewOnlineReports) database connection response [06 Sep 2020 10:56:34] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:56:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 10:56:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 10:56:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599371794M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599371794M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 10:56:34] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 10:56:34] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599371794M0100000036228_M01HEM20012106_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 10:56:34] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599371794M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:44] (viewOnlineReports) database connection response [06 Sep 2020 10:56:44] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:56:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:56:44] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:56:44] (viewOnlineReports) p_Alert= [06 Sep 2020 10:56:44] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:56: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', '200380782', 'M01', '047', '2', '001000000000085651', 'M0100000036228_M01HEM20012106_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 10:56:44] (viewOnlineReports) database connection response [06 Sep 2020 10:56:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Sep 2020 10:56:44] (viewOnlineReports) database connection response [06 Sep 2020 10:56:44] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:56:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 10:56:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 10:56:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599371804M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599371804M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 10:56:44] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 10:56:44] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599371804M0100000036228_M01HEM20012106_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 10:56:44] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599371804M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:55] (viewOnlineReports) database connection response [06 Sep 2020 10:56:55] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:56:55] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:56:55] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:56:55] (viewOnlineReports) p_Alert= [06 Sep 2020 10:56:55] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:56: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', '200380782', 'M01', '047', '2', '001000000000085651', 'M0100000036228_M01HEM20012106_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 10:56:55] (viewOnlineReports) database connection response [06 Sep 2020 10:56:55] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Sep 2020 10:56:55] (viewOnlineReports) database connection response [06 Sep 2020 10:56:55] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:56:55] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 10:56:55] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 10:56:55] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:55] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599371815M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:55] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599371815M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:56:55] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 10:56:55] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 10:56:55] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599371815M0100000036228_M01HEM20012106_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 10:56:55] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599371815M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:58:09] (viewOnlineReports) database connection response [06 Sep 2020 10:58:09] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:58:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:58:09] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:58:09] (viewOnlineReports) p_Alert= [06 Sep 2020 10:58:09] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:58: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', '200380782', 'M01', '047', '2', '001000000000085651', 'M0100000036228_M01HEM20012106_2.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 10:58:09] (viewOnlineReports) database connection response [06 Sep 2020 10:58:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Sep 2020 10:58:09] (viewOnlineReports) database connection response [06 Sep 2020 10:58:09] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:58:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 10:58:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 10:58:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:58:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599371889M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:58:09] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599371889M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:58:09] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Sep 2020 10:58:09] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 10:58:09] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599371889M0100000036228_M01HEM20012106_2.PDF ../../TEMP_PDF/200380782/M0100000036228_M01HEM20012106_2.jpg [06 Sep 2020 10:58:09] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599371889M0100000036228_M01HEM20012106_2.PDF [06 Sep 2020 10:58:14] (viewOnlineReports) database connection response [06 Sep 2020 10:58:14] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:58:14] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '3', '001000000000082607', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:58:14] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:58:14] (viewOnlineReports) p_Alert= [06 Sep 2020 10:58:14] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:58:14] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380782', 'M01', '047', '3', '001000000000082607', 'M0100000036228_M01SCH20009067_1.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 10:58:14] (viewOnlineReports) database connection response [06 Sep 2020 10:58:14] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Sep 2020 10:58:14] (viewOnlineReports) database connection response [06 Sep 2020 10:58:14] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:58:14] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 10:58:14] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 10:58:14] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 10:58:14] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599371894M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 10:58:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599371894M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 10:58:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 10:58:15] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01SCH20009067_1.jpg [06 Sep 2020 10:58:15] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599371894M0100000036228_M01SCH20009067_1.PDF ../../TEMP_PDF/200380782/M0100000036228_M01SCH20009067_1.jpg [06 Sep 2020 10:58:15] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599371894M0100000036228_M01SCH20009067_1.PDF [06 Sep 2020 10:58:38] (viewOnlineReports) database connection response [06 Sep 2020 10:58:38] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 10:58:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200380782', '7', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 10:58:38] (viewOnlineReports) p_Stop=N [06 Sep 2020 10:58:38] (viewOnlineReports) p_Alert= [06 Sep 2020 10:58:38] (viewOnlineReports) Flag = 1 [06 Sep 2020 10:58: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', '200380782', 'M01', '047', '7', '001000000000084460', 'M0100000036228_M01RCH20016369_3.PDF', 'M0100000036228', SYSDATE) [06 Sep 2020 10:58:38] (viewOnlineReports) database connection response [06 Sep 2020 10:58:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380782' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [06 Sep 2020 10:58:38] (viewOnlineReports) database connection response [06 Sep 2020 10:58:38] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 10:58:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380782/ [06 Sep 2020 10:58:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380782/ [06 Sep 2020 10:58:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 10:58:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599371918M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 10:58:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599371918M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 10:58:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 10:58:38] (viewOnlineReports) Converting PDF to JPG with name as M0100000036228_M01RCH20016369_3.jpg [06 Sep 2020 10:58:38] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599371918M0100000036228_M01RCH20016369_3.PDF ../../TEMP_PDF/200380782/M0100000036228_M01RCH20016369_3.jpg [06 Sep 2020 10:58:38] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380782/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599371918M0100000036228_M01RCH20016369_3.PDF [06 Sep 2020 13:12:12] (viewOnlineReports) database connection response [06 Sep 2020 13:12:12] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 13:12:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200380650', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 13:12:12] (viewOnlineReports) p_Stop=N [06 Sep 2020 13:12:12] (viewOnlineReports) p_Alert= [06 Sep 2020 13:12:12] (viewOnlineReports) Flag = 1 [06 Sep 2020 13:12:12] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380650', 'M01', '047', '1', '001000000000085025', 'M0100000021138_M01HEM20012094_1.PDF', '00100000000000', SYSDATE) [06 Sep 2020 13:12:12] (viewOnlineReports) database connection response [06 Sep 2020 13:12:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380650' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 13:12:12] (viewOnlineReports) database connection response [06 Sep 2020 13:12:12] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 13:12:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380650/ [06 Sep 2020 13:12:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380650/ [06 Sep 2020 13:12:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 13:12:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380650/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZM0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 13:12:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380650/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZM0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 13:12:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 13:12:12] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380650/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZM0100000021138_M01HEM20012094_1.PDF [06 Sep 2020 15:17:14] (index) database connection response [06 Sep 2020 15:17:14] (index) getConnection(): Resource id #1 [06 Sep 2020 15:17:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 15:17:14] (index) database connection response [06 Sep 2020 15:17:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 15:17:14] (index) database connection response [06 Sep 2020 15:17:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 15:17:14] (index) database connection response [06 Sep 2020 15:17:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200364778' AND ACCESS_CODE = '98754163' [06 Sep 2020 15:17:14] (index) database connection response [06 Sep 2020 15:17:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200364778' AND ACCESS_CODE = '98754163' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 15:17:14] (index) database connection response [06 Sep 2020 15:17:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000594805' [06 Sep 2020 15:17:14] (index) database connection response [06 Sep 2020 15:17:14] (index) getPatientReportsDetail() entered [06 Sep 2020 15:17:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200364778', 'M0100000594805', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:17:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200364778', 'M0100000594805', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:17:14] (index) p_Stop=N [06 Sep 2020 15:17:14] (index) p_Alert= [06 Sep 2020 15:17: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 [06 Sep 2020 15:17:14] (index) database connection response [06 Sep 2020 15:17:14] (index) getConnectionClose() called.... [06 Sep 2020 15:17:14] (index) getConnectionClose() called.... [06 Sep 2020 15:18:08] (viewOnlineReports) database connection response [06 Sep 2020 15:18:08] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:18:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '1', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:18:08] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:18:08] (viewOnlineReports) p_Alert= [06 Sep 2020 15:18:08] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:18: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', '200380445', 'M01', '047', '1', '001000000000084949', 'M0100000594805_M01RCH20016328_4.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:18:08] (viewOnlineReports) database connection response [06 Sep 2020 15:18:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 15:18:08] (viewOnlineReports) database connection response [06 Sep 2020 15:18:08] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:18:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:18:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:18:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599387488M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599387488M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 15:18:08] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380445/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599387488M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:19] (viewOnlineReports) database connection response [06 Sep 2020 15:18:19] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:18:19] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '1', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:18:19] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:18:19] (viewOnlineReports) p_Alert= [06 Sep 2020 15:18:19] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:18: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', '200380445', 'M01', '047', '1', '001000000000084949', 'M0100000594805_M01RCH20016328_4.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:18:19] (viewOnlineReports) database connection response [06 Sep 2020 15:18:19] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 15:18:19] (viewOnlineReports) database connection response [06 Sep 2020 15:18:19] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:18:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:18:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:18:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599387499M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599387499M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Sep 2020 15:18:19] (viewOnlineReports) Converting PDF to JPG with name as M0100000594805_M01RCH20016328_4.jpg [06 Sep 2020 15:18:19] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380445/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599387499M0100000594805_M01RCH20016328_4.PDF ../../TEMP_PDF/200380445/M0100000594805_M01RCH20016328_4.jpg [06 Sep 2020 15:18:19] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380445/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599387499M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:41] (viewOnlineReports) database connection response [06 Sep 2020 15:18:41] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:18:41] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '1', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:18:41] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:18:41] (viewOnlineReports) p_Alert= [06 Sep 2020 15:18:41] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:18: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', '200380445', 'M01', '047', '1', '001000000000084949', 'M0100000594805_M01RCH20016328_4.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:18:41] (viewOnlineReports) database connection response [06 Sep 2020 15:18:41] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 15:18:41] (viewOnlineReports) database connection response [06 Sep 2020 15:18:41] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:18:41] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:18:41] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:18:41] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:41] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387521M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:41] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387521M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:18:41] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:18:41] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387521M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:20:48] (viewOnlineReports) database connection response [06 Sep 2020 15:20:48] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:20:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '2', '001000000000081265', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:20:48] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:20:48] (viewOnlineReports) p_Alert= [06 Sep 2020 15:20:48] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:20: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', '200380445', 'M01', '047', '2', '001000000000081265', 'M0100000594805_M01RCH20016328_2.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:20:48] (viewOnlineReports) database connection response [06 Sep 2020 15:20:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Sep 2020 15:20:48] (viewOnlineReports) database connection response [06 Sep 2020 15:20:48] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:20:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:20:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:20:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_2.PDF [06 Sep 2020 15:20:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387648M0100000594805_M01RCH20016328_2.PDF [06 Sep 2020 15:20:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387648M0100000594805_M01RCH20016328_2.PDF [06 Sep 2020 15:20:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:20:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387648M0100000594805_M01RCH20016328_2.PDF [06 Sep 2020 15:21:14] (viewOnlineReports) database connection response [06 Sep 2020 15:21:14] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:21:14] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '3', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:21:14] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:21:14] (viewOnlineReports) p_Alert= [06 Sep 2020 15:21:14] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:21:14] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380445', 'M01', '047', '3', '001000000000084296', 'M0100000594805_M01RCH20016328_3.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:21:14] (viewOnlineReports) database connection response [06 Sep 2020 15:21:14] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Sep 2020 15:21:14] (viewOnlineReports) database connection response [06 Sep 2020 15:21:14] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:21:14] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:21:14] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:21:14] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_3.PDF [06 Sep 2020 15:21:14] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387674M0100000594805_M01RCH20016328_3.PDF [06 Sep 2020 15:21:14] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387674M0100000594805_M01RCH20016328_3.PDF [06 Sep 2020 15:21:14] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:21:14] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387674M0100000594805_M01RCH20016328_3.PDF [06 Sep 2020 15:21:32] (viewOnlineReports) database connection response [06 Sep 2020 15:21:32] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:21:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '4', '001000000000085610', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:21:32] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:21:32] (viewOnlineReports) p_Alert= [06 Sep 2020 15:21:32] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:21: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', '200380445', 'M01', '047', '4', '001000000000085610', 'M0100000594805_M01HEM20012076_1.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:21:32] (viewOnlineReports) database connection response [06 Sep 2020 15:21:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [06 Sep 2020 15:21:32] (viewOnlineReports) database connection response [06 Sep 2020 15:21:32] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:21:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:21:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:21:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01HEM20012076_1.PDF [06 Sep 2020 15:21:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599387692M0100000594805_M01HEM20012076_1.PDF [06 Sep 2020 15:21:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599387692M0100000594805_M01HEM20012076_1.PDF [06 Sep 2020 15:21:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:21:32] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599387692M0100000594805_M01HEM20012076_1.PDF [06 Sep 2020 15:22:09] (viewOnlineReports) database connection response [06 Sep 2020 15:22:09] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:22:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '5', '001000000000085730', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:22:09] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:22:09] (viewOnlineReports) p_Alert= [06 Sep 2020 15:22:09] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:22: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', '200380445', 'M01', '047', '5', '001000000000085730', 'M0100000594805_M01HEM20012076_2.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:22:09] (viewOnlineReports) database connection response [06 Sep 2020 15:22:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [06 Sep 2020 15:22:09] (viewOnlineReports) database connection response [06 Sep 2020 15:22:09] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:22:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:22:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:22:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01HEM20012076_2.PDF [06 Sep 2020 15:22:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387729M0100000594805_M01HEM20012076_2.PDF [06 Sep 2020 15:22:09] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387729M0100000594805_M01HEM20012076_2.PDF [06 Sep 2020 15:22:09] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:22:09] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387729M0100000594805_M01HEM20012076_2.PDF [06 Sep 2020 15:22:36] (viewOnlineReports) database connection response [06 Sep 2020 15:22:36] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:22:36] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '6', '001000000000080058', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:22:36] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:22:36] (viewOnlineReports) p_Alert= [06 Sep 2020 15:22:36] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:22:36] (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', '200380445', 'M01', '047', '6', '001000000000080058', 'M0100000594805_M01RCH20016328_1.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:22:36] (viewOnlineReports) database connection response [06 Sep 2020 15:22:36] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [06 Sep 2020 15:22:36] (viewOnlineReports) database connection response [06 Sep 2020 15:22:36] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:22:36] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:22:36] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:22:36] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_1.PDF [06 Sep 2020 15:22:36] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599387756M0100000594805_M01RCH20016328_1.PDF [06 Sep 2020 15:22:36] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599387756M0100000594805_M01RCH20016328_1.PDF [06 Sep 2020 15:22:36] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:22:36] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599387756M0100000594805_M01RCH20016328_1.PDF [06 Sep 2020 15:22:44] (viewOnlineReports) database connection response [06 Sep 2020 15:22:44] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:22:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '8', '001000000000086287', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:22:44] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:22:44] (viewOnlineReports) p_Alert= [06 Sep 2020 15:22:44] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:22: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', '200380445', 'M01', '047', '8', '001000000000086287', 'M0100000594805_M01SCH20009041_1.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:22:44] (viewOnlineReports) database connection response [06 Sep 2020 15:22:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [06 Sep 2020 15:22:44] (viewOnlineReports) database connection response [06 Sep 2020 15:22:44] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:22:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:22:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:22:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01SCH20009041_1.PDF [06 Sep 2020 15:22:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599387764M0100000594805_M01SCH20009041_1.PDF [06 Sep 2020 15:22:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599387764M0100000594805_M01SCH20009041_1.PDF [06 Sep 2020 15:22:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:22:44] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599387764M0100000594805_M01SCH20009041_1.PDF [06 Sep 2020 15:22:57] (viewOnlineReports) database connection response [06 Sep 2020 15:22:57] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:22:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '1', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:22:57] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:22:57] (viewOnlineReports) p_Alert= [06 Sep 2020 15:22:57] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:22:57] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380445', 'M01', '047', '1', '001000000000084949', 'M0100000594805_M01RCH20016328_4.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:22:57] (viewOnlineReports) database connection response [06 Sep 2020 15:22:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 15:22:57] (viewOnlineReports) database connection response [06 Sep 2020 15:22:57] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:22:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:22:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:22:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:22:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599387777M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:22:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599387777M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:22:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Sep 2020 15:22:57] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380445/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599387777M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:23:02] (viewOnlineReports) database connection response [06 Sep 2020 15:23:02] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:23:02] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '1', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:23:02] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:23:02] (viewOnlineReports) p_Alert= [06 Sep 2020 15:23:02] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:23:02] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380445', 'M01', '047', '1', '001000000000084949', 'M0100000594805_M01RCH20016328_4.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:23:02] (viewOnlineReports) database connection response [06 Sep 2020 15:23:02] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Sep 2020 15:23:02] (viewOnlineReports) database connection response [06 Sep 2020 15:23:02] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:23:02] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:23:02] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:23:02] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:23:02] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599387782M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:23:02] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599387782M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:23:02] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:23:02] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599387782M0100000594805_M01RCH20016328_4.PDF [06 Sep 2020 15:23:12] (viewOnlineReports) database connection response [06 Sep 2020 15:23:12] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:23:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000594805', '001', '200380445', '6', '001000000000080058', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:23:12] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:23:12] (viewOnlineReports) p_Alert= [06 Sep 2020 15:23:12] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:23:12] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380445', 'M01', '047', '6', '001000000000080058', 'M0100000594805_M01RCH20016328_1.PDF', 'M0100000594805', SYSDATE) [06 Sep 2020 15:23:12] (viewOnlineReports) database connection response [06 Sep 2020 15:23:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380445' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [06 Sep 2020 15:23:12] (viewOnlineReports) database connection response [06 Sep 2020 15:23:12] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:23:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380445/ [06 Sep 2020 15:23:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380445/ [06 Sep 2020 15:23:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200905\M01\M0100000594805_M01RCH20016328_1.PDF [06 Sep 2020 15:23:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380445/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387792M0100000594805_M01RCH20016328_1.PDF [06 Sep 2020 15:23:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380445/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387792M0100000594805_M01RCH20016328_1.PDF [06 Sep 2020 15:23:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:23:12] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380445/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599387792M0100000594805_M01RCH20016328_1.PDF [06 Sep 2020 15:25:21] (index) database connection response [06 Sep 2020 15:25:21] (index) getConnection(): Resource id #1 [06 Sep 2020 15:25:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 15:25:21] (index) database connection response [06 Sep 2020 15:25:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 15:25:21] (index) database connection response [06 Sep 2020 15:25:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 15:25:21] (index) database connection response [06 Sep 2020 15:25:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365830' AND ACCESS_CODE = '11736155' [06 Sep 2020 15:25:22] (index) database connection response [06 Sep 2020 15:25:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365830' AND ACCESS_CODE = '11736155' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 15:25:22] (index) database connection response [06 Sep 2020 15:25:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000504263' [06 Sep 2020 15:25:22] (index) database connection response [06 Sep 2020 15:25:22] (index) getPatientReportsDetail() entered [06 Sep 2020 15:25:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365830', 'M0100000504263', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:25:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365830', 'M0100000504263', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:25:22] (index) p_Stop=N [06 Sep 2020 15:25:22] (index) p_Alert= [06 Sep 2020 15:25:22] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 15:25:22] (index) database connection response [06 Sep 2020 15:25:22] (index) getConnectionClose() called.... [06 Sep 2020 15:25:22] (index) getConnectionClose() called.... [06 Sep 2020 15:25:48] (viewOnlineReports) database connection response [06 Sep 2020 15:25:48] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:25:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000504263', '001', '200380819', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:25:48] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:25:48] (viewOnlineReports) p_Alert= [06 Sep 2020 15:25:48] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:25: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', '200380819', 'M01', '027', '1', '001000000000085025', 'M0100000504263_M01HEM20012113_1.PDF', 'M0100000504263', SYSDATE) [06 Sep 2020 15:25:48] (viewOnlineReports) database connection response [06 Sep 2020 15:25:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380819' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [06 Sep 2020 15:25:48] (viewOnlineReports) database connection response [06 Sep 2020 15:25:48] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:25:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380819/ [06 Sep 2020 15:25:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380819/ [06 Sep 2020 15:25:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200906\M01\M0100000504263_M01HEM20012113_1.PDF [06 Sep 2020 15:25:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380819/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1599387948M0100000504263_M01HEM20012113_1.PDF [06 Sep 2020 15:25:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380819/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1599387948M0100000504263_M01HEM20012113_1.PDF [06 Sep 2020 15:25:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:25:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380819/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1599387948M0100000504263_M01HEM20012113_1.PDF [06 Sep 2020 15:25:50] (viewOnlineReports) database connection response [06 Sep 2020 15:25:50] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:25:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000504263', '001', '200380819', '2', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:25:50] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:25:50] (viewOnlineReports) p_Alert= [06 Sep 2020 15:25:50] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:25: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', '200380819', 'M01', '027', '2', '001000000000082047', 'M0100000504263_M01RCH20016377_1.PDF', 'M0100000504263', SYSDATE) [06 Sep 2020 15:25:50] (viewOnlineReports) database connection response [06 Sep 2020 15:25:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380819' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [06 Sep 2020 15:25:50] (viewOnlineReports) database connection response [06 Sep 2020 15:25:50] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:25:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380819/ [06 Sep 2020 15:25:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380819/ [06 Sep 2020 15:25:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200906\M01\M0100000504263_M01RCH20016377_1.PDF [06 Sep 2020 15:25:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380819/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599387950M0100000504263_M01RCH20016377_1.PDF [06 Sep 2020 15:25:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380819/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599387950M0100000504263_M01RCH20016377_1.PDF [06 Sep 2020 15:25:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:25:50] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380819/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599387950M0100000504263_M01RCH20016377_1.PDF [06 Sep 2020 15:25:53] (viewOnlineReports) database connection response [06 Sep 2020 15:25:53] (viewOnlineReports) getConnection(): Resource id #1 [06 Sep 2020 15:25:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000504263', '001', '200380819', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 15:25:53] (viewOnlineReports) p_Stop=N [06 Sep 2020 15:25:53] (viewOnlineReports) p_Alert= [06 Sep 2020 15:25:53] (viewOnlineReports) Flag = 1 [06 Sep 2020 15:25: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', '200380819', 'M01', '027', '3', '001000000000087100', 'M0100000504263_M01MIC20006517_1.PDF', 'M0100000504263', SYSDATE) [06 Sep 2020 15:25:53] (viewOnlineReports) database connection response [06 Sep 2020 15:25:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380819' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '3' [06 Sep 2020 15:25:53] (viewOnlineReports) database connection response [06 Sep 2020 15:25:53] (viewOnlineReports) getConnectionClose() called.... [06 Sep 2020 15:25:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380819/ [06 Sep 2020 15:25:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380819/ [06 Sep 2020 15:25:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200906\M01\M0100000504263_M01MIC20006517_1.PDF [06 Sep 2020 15:25:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380819/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599387952M0100000504263_M01MIC20006517_1.PDF [06 Sep 2020 15:25:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380819/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599387952M0100000504263_M01MIC20006517_1.PDF [06 Sep 2020 15:25:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Sep 2020 15:25:53] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380819/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599387952M0100000504263_M01MIC20006517_1.PDF [06 Sep 2020 16:10:01] (index) database connection response [06 Sep 2020 16:10:01] (index) getConnection(): Resource id #1 [06 Sep 2020 16:10:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 16:10:01] (index) database connection response [06 Sep 2020 16:10:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 16:10:01] (index) database connection response [06 Sep 2020 16:10:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 16:10:01] (index) database connection response [06 Sep 2020 16:10:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' [06 Sep 2020 16:10:01] (index) database connection response [06 Sep 2020 16:10:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 16:10:01] (index) database connection response [06 Sep 2020 16:10:01] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000564519' [06 Sep 2020 16:10:01] (index) database connection response [06 Sep 2020 16:10:01] (index) getPatientReportsDetail() entered [06 Sep 2020 16:10:01] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 16:10:01] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 16:10:01] (index) p_Stop=N [06 Sep 2020 16:10:01] (index) p_Alert= [06 Sep 2020 16:10:01] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 16:10:01] (index) database connection response [06 Sep 2020 16:10:01] (index) getConnectionClose() called.... [06 Sep 2020 16:10:01] (index) getConnectionClose() called.... [06 Sep 2020 18:31:19] (index) database connection response [06 Sep 2020 18:31:19] (index) getConnection(): Resource id #1 [06 Sep 2020 18:31:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 18:31:19] (index) database connection response [06 Sep 2020 18:31:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 18:31:19] (index) database connection response [06 Sep 2020 18:31:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 18:31:19] (index) database connection response [06 Sep 2020 18:31:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365627' AND ACCESS_CODE = '57818033' [06 Sep 2020 18:31:19] (index) database connection response [06 Sep 2020 18:31:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365627' AND ACCESS_CODE = '57818033' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 18:31:19] (index) database connection response [06 Sep 2020 18:31:19] (index) getConnectionClose() called.... [06 Sep 2020 18:31:43] (index) database connection response [06 Sep 2020 18:31:43] (index) getConnection(): Resource id #1 [06 Sep 2020 18:31:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 18:31:43] (index) database connection response [06 Sep 2020 18:31:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 18:31:43] (index) database connection response [06 Sep 2020 18:31:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 18:31:43] (index) database connection response [06 Sep 2020 18:31:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365627' AND ACCESS_CODE = '57819023' [06 Sep 2020 18:31:43] (index) database connection response [06 Sep 2020 18:31:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365627' AND ACCESS_CODE = '57819023' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 18:31:43] (index) database connection response [06 Sep 2020 18:31:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000052946' [06 Sep 2020 18:31:43] (index) database connection response [06 Sep 2020 18:31:43] (index) getPatientReportsDetail() entered [06 Sep 2020 18:31:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365627', 'M0100000052946', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 18:31:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365627', 'M0100000052946', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 18:31:43] (index) p_Stop=N [06 Sep 2020 18:31:43] (index) p_Alert= [06 Sep 2020 18:31: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 [06 Sep 2020 18:31:43] (index) database connection response [06 Sep 2020 18:31:43] (index) getConnectionClose() called.... [06 Sep 2020 18:31:43] (index) getConnectionClose() called.... [06 Sep 2020 18:32:21] (index) database connection response [06 Sep 2020 18:32:21] (index) getConnection(): Resource id #1 [06 Sep 2020 18:32:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 18:32:21] (index) database connection response [06 Sep 2020 18:32:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 18:32:21] (index) database connection response [06 Sep 2020 18:32:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 18:32:21] (index) database connection response [06 Sep 2020 18:32:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365627' AND ACCESS_CODE = '57819023' [06 Sep 2020 18:32:21] (index) database connection response [06 Sep 2020 18:32:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365627' AND ACCESS_CODE = '57819023' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 18:32:21] (index) database connection response [06 Sep 2020 18:32:21] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000052946' [06 Sep 2020 18:32:21] (index) database connection response [06 Sep 2020 18:32:21] (index) getPatientReportsDetail() entered [06 Sep 2020 18:32:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365627', 'M0100000052946', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 18:32:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365627', 'M0100000052946', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 18:32:21] (index) p_Stop=N [06 Sep 2020 18:32:21] (index) p_Alert= [06 Sep 2020 18:32:21] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 18:32:21] (index) database connection response [06 Sep 2020 18:32:21] (index) getConnectionClose() called.... [06 Sep 2020 18:32:21] (index) getConnectionClose() called.... [06 Sep 2020 19:02:05] (index) database connection response [06 Sep 2020 19:02:05] (index) getConnection(): Resource id #1 [06 Sep 2020 19:02:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 19:02:05] (index) database connection response [06 Sep 2020 19:02:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 19:02:05] (index) database connection response [06 Sep 2020 19:02:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 19:02:05] (index) database connection response [06 Sep 2020 19:02:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01190207652' AND ACCESS_CODE = '97433290' [06 Sep 2020 19:02:05] (index) database connection response [06 Sep 2020 19:02:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01190207652' AND ACCESS_CODE = '97433290' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 19:02:05] (index) database connection response [06 Sep 2020 19:02:05] (index) getConnectionClose() called.... [06 Sep 2020 19:38:15] (index) database connection response [06 Sep 2020 19:38:15] (index) getConnection(): Resource id #1 [06 Sep 2020 19:38:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '56' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 19:38:15] (index) database connection response [06 Sep 2020 19:38:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '56' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 19:38:15] (index) database connection response [06 Sep 2020 19:38:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '56' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 19:38:15] (index) database connection response [06 Sep 2020 19:38:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200339355' AND ACCESS_CODE = '11878529' [06 Sep 2020 19:38:15] (index) database connection response [06 Sep 2020 19:38:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200339355' AND ACCESS_CODE = '11878529' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 19:38:15] (index) database connection response [06 Sep 2020 19:38:15] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000028188' [06 Sep 2020 19:38:15] (index) database connection response [06 Sep 2020 19:38:15] (index) getPatientReportsDetail() entered [06 Sep 2020 19:38:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200339355', 'M0100000028188', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 19:38:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200339355', 'M0100000028188', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 19:38:15] (index) p_Stop=N [06 Sep 2020 19:38:15] (index) p_Alert= [06 Sep 2020 19:38:15] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 19:38:15] (index) database connection response [06 Sep 2020 19:38:15] (index) getConnectionClose() called.... [06 Sep 2020 19:38:15] (index) getConnectionClose() called.... [06 Sep 2020 20:43:34] (index) database connection response [06 Sep 2020 20:43:34] (index) getConnection(): Resource id #1 [06 Sep 2020 20:43:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 20:43:34] (index) database connection response [06 Sep 2020 20:43:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 20:43:34] (index) database connection response [06 Sep 2020 20:43:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 20:43:35] (index) database connection response [06 Sep 2020 20:43:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' [06 Sep 2020 20:43:35] (index) database connection response [06 Sep 2020 20:43:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 20:43:35] (index) database connection response [06 Sep 2020 20:43:35] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000564519' [06 Sep 2020 20:43:35] (index) database connection response [06 Sep 2020 20:43:35] (index) getPatientReportsDetail() entered [06 Sep 2020 20:43:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 20:43:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 20:43:35] (index) p_Stop=N [06 Sep 2020 20:43:35] (index) p_Alert= [06 Sep 2020 20:43:35] (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 [06 Sep 2020 20:43:35] (index) database connection response [06 Sep 2020 20:43:35] (index) getConnectionClose() called.... [06 Sep 2020 20:43:35] (index) getConnectionClose() called.... [06 Sep 2020 22:13:02] (index) database connection response [06 Sep 2020 22:13:02] (index) getConnection(): Resource id #1 [06 Sep 2020 22:13:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'POP-UP' [06 Sep 2020 22:13:02] (index) database connection response [06 Sep 2020 22:13:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Sep 2020 22:13:02] (index) database connection response [06 Sep 2020 22:13:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Sep 2020 22:13:02] (index) database connection response [06 Sep 2020 22:13:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' [06 Sep 2020 22:13:02] (index) database connection response [06 Sep 2020 22:13:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Sep 2020 22:13:02] (index) database connection response [06 Sep 2020 22:13:02] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000564519' [06 Sep 2020 22:13:02] (index) database connection response [06 Sep 2020 22:13:02] (index) getPatientReportsDetail() entered [06 Sep 2020 22:13:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 22:13:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Sep 2020 22:13:02] (index) p_Stop=N [06 Sep 2020 22:13:02] (index) p_Alert= [06 Sep 2020 22:13:02] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [06 Sep 2020 22:13:02] (index) database connection response [06 Sep 2020 22:13:02] (index) getConnectionClose() called.... [06 Sep 2020 22:13:02] (index) getConnectionClose() called....