[26 Nov 2020 00:08:17] (viewOnlineReports) database connection response [26 Nov 2020 00:08:17] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 00:08:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644674', '001', '200428341', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 00:08:17] (viewOnlineReports) p_Stop=N [26 Nov 2020 00:08:17] (viewOnlineReports) p_Alert= [26 Nov 2020 00:08:17] (viewOnlineReports) Flag = 1 [26 Nov 2020 00:08:17] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428341', 'M01', '047', '3', '001000000000082047', 'M0100000644674_M01RCH20023163_1.PDF', 'M0100000644674', SYSDATE) [26 Nov 2020 00:08:17] (viewOnlineReports) database connection response [26 Nov 2020 00:08:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 00:08:17] (viewOnlineReports) database connection response [26 Nov 2020 00:08:17] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 00:08:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 00:08:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 00:08:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:08:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1606331296M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:08:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1606331296M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:08:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 00:08:17] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1606331296M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:08:44] (viewOnlineReports) database connection response [26 Nov 2020 00:08:44] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 00:08:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644674', '001', '200428341', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 00:08:44] (viewOnlineReports) p_Stop=N [26 Nov 2020 00:08:44] (viewOnlineReports) p_Alert= [26 Nov 2020 00:08:44] (viewOnlineReports) Flag = 1 [26 Nov 2020 00:08: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', '200428341', 'M01', '047', '3', '001000000000082047', 'M0100000644674_M01RCH20023163_1.PDF', 'M0100000644674', SYSDATE) [26 Nov 2020 00:08:44] (viewOnlineReports) database connection response [26 Nov 2020 00:08:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 00:08:44] (viewOnlineReports) database connection response [26 Nov 2020 00:08:44] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 00:08:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 00:08:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 00:08:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:08:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606331324M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:08:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606331324M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:08:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 00:08:44] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428341/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606331324M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:15:02] (viewOnlineReports) database connection response [26 Nov 2020 00:15:02] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 00:15:02] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644674', '001', '200428341', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 00:15:02] (viewOnlineReports) p_Stop=N [26 Nov 2020 00:15:02] (viewOnlineReports) p_Alert= [26 Nov 2020 00:15:02] (viewOnlineReports) Flag = 1 [26 Nov 2020 00:15: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', '200428341', 'M01', '047', '3', '001000000000082047', 'M0100000644674_M01RCH20023163_1.PDF', 'M0100000644674', SYSDATE) [26 Nov 2020 00:15:02] (viewOnlineReports) database connection response [26 Nov 2020 00:15:02] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 00:15:02] (viewOnlineReports) database connection response [26 Nov 2020 00:15:02] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 00:15:02] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 00:15:02] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 00:15:02] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:15:02] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606331702M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:15:02] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606331702M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:15:02] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 00:15:02] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606331702M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:15:32] (viewOnlineReports) database connection response [26 Nov 2020 00:15:32] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 00:15:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644674', '001', '200428341', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 00:15:32] (viewOnlineReports) p_Stop=N [26 Nov 2020 00:15:32] (viewOnlineReports) p_Alert= [26 Nov 2020 00:15:32] (viewOnlineReports) Flag = 1 [26 Nov 2020 00:15: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', '200428341', 'M01', '047', '3', '001000000000082047', 'M0100000644674_M01RCH20023163_1.PDF', 'M0100000644674', SYSDATE) [26 Nov 2020 00:15:32] (viewOnlineReports) database connection response [26 Nov 2020 00:15:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 00:15:32] (viewOnlineReports) database connection response [26 Nov 2020 00:15:32] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 00:15:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 00:15:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 00:15:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:15:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1606331732M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:15:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1606331732M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:15:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 00:15:32] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1606331732M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:24:43] (viewOnlineReports) database connection response [26 Nov 2020 00:24:43] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 00:24:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644674', '001', '200428341', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 00:24:43] (viewOnlineReports) p_Stop=N [26 Nov 2020 00:24:43] (viewOnlineReports) p_Alert= [26 Nov 2020 00:24:43] (viewOnlineReports) Flag = 1 [26 Nov 2020 00:24:43] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428341', 'M01', '047', '3', '001000000000082047', 'M0100000644674_M01RCH20023163_1.PDF', 'M0100000644674', SYSDATE) [26 Nov 2020 00:24:43] (viewOnlineReports) database connection response [26 Nov 2020 00:24:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 00:24:43] (viewOnlineReports) database connection response [26 Nov 2020 00:24:43] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 00:24:43] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 00:24:43] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 00:24:43] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:24:43] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1606332283M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:24:43] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1606332283M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:24:43] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 00:24:43] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1606332283M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:24:53] (viewOnlineReports) database connection response [26 Nov 2020 00:24:53] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 00:24:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644674', '001', '200428341', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 00:24:53] (viewOnlineReports) p_Stop=N [26 Nov 2020 00:24:53] (viewOnlineReports) p_Alert= [26 Nov 2020 00:24:53] (viewOnlineReports) Flag = 1 [26 Nov 2020 00: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', '200428341', 'M01', '047', '3', '001000000000082047', 'M0100000644674_M01RCH20023163_1.PDF', 'M0100000644674', SYSDATE) [26 Nov 2020 00:24:53] (viewOnlineReports) database connection response [26 Nov 2020 00:24:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 00:24:53] (viewOnlineReports) database connection response [26 Nov 2020 00:24:53] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 00:24:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 00:24:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 00:24:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:24:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1606332293M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:24:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1606332293M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 00:24:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 00:24:53] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1606332293M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 01:32:39] (index) database connection response [26 Nov 2020 01:32:39] (index) getConnection(): Resource id #1 [26 Nov 2020 01:32:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 01:32:40] (index) database connection response [26 Nov 2020 01:32:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 01:32:40] (index) database connection response [26 Nov 2020 01:32:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 01:32:40] (index) database connection response [26 Nov 2020 01:32:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510161' AND ACCESS_CODE = '01272748' [26 Nov 2020 01:32:40] (index) database connection response [26 Nov 2020 01:32:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510161' AND ACCESS_CODE = '01272748' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 01:32:40] (index) database connection response [26 Nov 2020 01:32:40] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000640378' [26 Nov 2020 01:32:40] (index) database connection response [26 Nov 2020 01:32:40] (index) getPatientReportsDetail() entered [26 Nov 2020 01:32:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200510161', 'M0100000640378', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 01:32:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200510161', 'M0100000640378', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 01:32:40] (index) p_Stop=N [26 Nov 2020 01:32:40] (index) p_Alert= [26 Nov 2020 01:32:40] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 01:32:40] (index) database connection response [26 Nov 2020 01:32:40] (index) getConnectionClose() called.... [26 Nov 2020 01:32:40] (index) getConnectionClose() called.... [26 Nov 2020 01:32:45] (viewOnlineReports) database connection response [26 Nov 2020 01:32:45] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 01:32:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000640378', '001', '200428095', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 01:32:45] (viewOnlineReports) p_Stop=N [26 Nov 2020 01:32:45] (viewOnlineReports) p_Alert= [26 Nov 2020 01:32:45] (viewOnlineReports) Flag = 1 [26 Nov 2020 01:32:45] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428095', 'M01', '070', '1', '001000000000087630', 'M0100000640378_M01MOL20013619_1.PDF', 'M0100000640378', SYSDATE) [26 Nov 2020 01:32:45] (viewOnlineReports) database connection response [26 Nov 2020 01:32:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428095' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 01:32:45] (viewOnlineReports) database connection response [26 Nov 2020 01:32:45] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 01:32:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428095/ [26 Nov 2020 01:32:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428095/ [26 Nov 2020 01:32:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000640378_M01MOL20013619_1.PDF [26 Nov 2020 01:32:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428095/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1606336365M0100000640378_M01MOL20013619_1.PDF [26 Nov 2020 01:32:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428095/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1606336365M0100000640378_M01MOL20013619_1.PDF [26 Nov 2020 01:32:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 01:32:45] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428095/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1606336365M0100000640378_M01MOL20013619_1.PDF [26 Nov 2020 08:40:06] (viewOnlineReports) database connection response [26 Nov 2020 08:40:06] (viewOnlineReports) getConnection(): Resource id #2 [26 Nov 2020 08:40:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200428341', '3', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 08:40:07] (viewOnlineReports) p_Stop=N [26 Nov 2020 08:40:07] (viewOnlineReports) p_Alert= [26 Nov 2020 08:40:07] (viewOnlineReports) Flag = 1 [26 Nov 2020 08:40:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428341', 'M01', '047', '3', '001000000000082047', 'M0100000644674_M01RCH20023163_1.PDF', '00100000000000', SYSDATE) [26 Nov 2020 08:40:07] (viewOnlineReports) database connection response [26 Nov 2020 08:40:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 08:40:07] (viewOnlineReports) database connection response [26 Nov 2020 08:40:07] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 08:40:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 08:40:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 08:40:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 08:40:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZM0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 08:40:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZM0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 08:40:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 08:40:07] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZM0100000644674_M01RCH20023163_1.PDF [26 Nov 2020 08:42:12] (index) database connection response [26 Nov 2020 08:42:12] (index) getConnection(): Resource id #1 [26 Nov 2020 08:42:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 08:42:12] (index) database connection response [26 Nov 2020 08:42:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 08:42:12] (index) database connection response [26 Nov 2020 08:42:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 08:42:12] (index) database connection response [26 Nov 2020 08:42:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510791' AND ACCESS_CODE = '98124102' [26 Nov 2020 08:42:12] (index) database connection response [26 Nov 2020 08:42:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510791' AND ACCESS_CODE = '98124102' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 08:42:12] (index) database connection response [26 Nov 2020 08:42:12] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000644674' [26 Nov 2020 08:42:12] (index) database connection response [26 Nov 2020 08:42:12] (index) getPatientReportsDetail() entered [26 Nov 2020 08:42:12] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200510791', 'M0100000644674', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 08:42:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200510791', 'M0100000644674', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 08:42:13] (index) p_Stop=N [26 Nov 2020 08:42:13] (index) p_Alert= [26 Nov 2020 08:42:13] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 08:42:13] (index) database connection response [26 Nov 2020 08:42:13] (index) getConnectionClose() called.... [26 Nov 2020 08:42:13] (index) getConnectionClose() called.... [26 Nov 2020 08:42:24] (viewOnlineReports) database connection response [26 Nov 2020 08:42:24] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 08:42:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644674', '001', '200428341', '7', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 08:42:24] (viewOnlineReports) p_Stop=N [26 Nov 2020 08:42:24] (viewOnlineReports) p_Alert= [26 Nov 2020 08:42:24] (viewOnlineReports) Flag = 1 [26 Nov 2020 08:42:24] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428341', 'M01', '047', '7', '001000000000087630', 'M0100000644674_M01MOL20013647_1.PDF', 'M0100000644674', SYSDATE) [26 Nov 2020 08:42:24] (viewOnlineReports) database connection response [26 Nov 2020 08:42:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [26 Nov 2020 08:42:24] (viewOnlineReports) database connection response [26 Nov 2020 08:42:24] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 08:42:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 08:42:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 08:42:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01MOL20013647_1.PDF [26 Nov 2020 08:42:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606362144M0100000644674_M01MOL20013647_1.PDF [26 Nov 2020 08:42:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606362144M0100000644674_M01MOL20013647_1.PDF [26 Nov 2020 08:42:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Nov 2020 08:42:24] (viewOnlineReports) Downloading file ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606362144M0100000644674_M01MOL20013647_1.PDF [26 Nov 2020 08:43:28] (viewOnlineReports) database connection response [26 Nov 2020 08:43:28] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 08:43:28] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644674', '001', '200428341', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 08:43:28] (viewOnlineReports) p_Stop=N [26 Nov 2020 08:43:28] (viewOnlineReports) p_Alert= [26 Nov 2020 08:43:28] (viewOnlineReports) Flag = 1 [26 Nov 2020 08:43:28] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428341', 'M01', '047', '1', '001000000000085025', 'M0100000644674_M01HEM20016969_1.PDF', 'M0100000644674', SYSDATE) [26 Nov 2020 08:43:28] (viewOnlineReports) database connection response [26 Nov 2020 08:43:28] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428341' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Nov 2020 08:43:28] (viewOnlineReports) database connection response [26 Nov 2020 08:43:28] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 08:43:28] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428341/ [26 Nov 2020 08:43:28] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428341/ [26 Nov 2020 08:43:28] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644674_M01HEM20016969_1.PDF [26 Nov 2020 08:43:28] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1606362208M0100000644674_M01HEM20016969_1.PDF [26 Nov 2020 08:43:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1606362208M0100000644674_M01HEM20016969_1.PDF [26 Nov 2020 08:43:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Nov 2020 08:43:28] (viewOnlineReports) Downloading file ../../TEMP_PDF/200428341/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1606362208M0100000644674_M01HEM20016969_1.PDF [26 Nov 2020 10:37:57] (index) database connection response [26 Nov 2020 10:37:57] (index) getConnection(): Resource id #1 [26 Nov 2020 10:37:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 10:37:57] (index) database connection response [26 Nov 2020 10:37:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 10:37:57] (index) database connection response [26 Nov 2020 10:37:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 10:37:57] (index) database connection response [26 Nov 2020 10:37:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'FX4114474' AND ACCESS_CODE = '00044717' [26 Nov 2020 10:37:58] (index) database connection response [26 Nov 2020 10:37:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'FX4114474' AND ACCESS_CODE = '00044717' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 10:37:58] (index) database connection response [26 Nov 2020 10:37:58] (index) getConnectionClose() called.... [26 Nov 2020 10:38:55] (index) database connection response [26 Nov 2020 10:38:55] (index) getConnection(): Resource id #1 [26 Nov 2020 10:38:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 10:38:55] (index) database connection response [26 Nov 2020 10:38:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 10:38:55] (index) database connection response [26 Nov 2020 10:38:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 10:38:55] (index) database connection response [26 Nov 2020 10:38:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '4114474' AND ACCESS_CODE = '000-44717' [26 Nov 2020 10:38:55] (index) database connection response [26 Nov 2020 10:38:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '4114474' AND ACCESS_CODE = '000-44717' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 10:38:55] (index) database connection response [26 Nov 2020 10:38:55] (index) getConnectionClose() called.... [26 Nov 2020 10:39:07] (index) database connection response [26 Nov 2020 10:39:07] (index) getConnection(): Resource id #1 [26 Nov 2020 10:39:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 10:39:07] (index) database connection response [26 Nov 2020 10:39:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 10:39:07] (index) database connection response [26 Nov 2020 10:39:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 10:39:07] (index) database connection response [26 Nov 2020 10:39:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'FX4114474' AND ACCESS_CODE = '000-44717' [26 Nov 2020 10:39:08] (index) database connection response [26 Nov 2020 10:39:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'FX4114474' AND ACCESS_CODE = '000-44717' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 10:39:08] (index) database connection response [26 Nov 2020 10:39:08] (index) getConnectionClose() called.... [26 Nov 2020 11:00:32] (index) database connection response [26 Nov 2020 11:00:32] (index) getConnection(): Resource id #1 [26 Nov 2020 11:00:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 11:00:32] (index) database connection response [26 Nov 2020 11:00:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 11:00:32] (index) database connection response [26 Nov 2020 11:00:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 11:00:32] (index) database connection response [26 Nov 2020 11:00:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510693' AND ACCESS_CODE = 'Lab reception' [26 Nov 2020 11:00:32] (index) database connection response [26 Nov 2020 11:00:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510693' AND ACCESS_CODE = 'Lab reception' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 11:00:32] (index) database connection response [26 Nov 2020 11:00:32] (index) getConnectionClose() called.... [26 Nov 2020 11:55:29] (index) database connection response [26 Nov 2020 11:55:29] (index) getConnection(): Resource id #1 [26 Nov 2020 11:55:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 11:55:29] (index) database connection response [26 Nov 2020 11:55:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 11:55:29] (index) database connection response [26 Nov 2020 11:55:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 11:55:29] (index) database connection response [26 Nov 2020 11:55:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'FX4114474' AND ACCESS_CODE = '00044717' [26 Nov 2020 11:55:29] (index) database connection response [26 Nov 2020 11:55:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'FX4114474' AND ACCESS_CODE = '00044717' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 11:55:30] (index) database connection response [26 Nov 2020 11:55:30] (index) getConnectionClose() called.... [26 Nov 2020 14:30:20] (index) database connection response [26 Nov 2020 14:30:20] (index) getConnection(): Resource id #1 [26 Nov 2020 14:30:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:30:20] (index) database connection response [26 Nov 2020 14:30:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:30:20] (index) database connection response [26 Nov 2020 14:30:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:30:20] (index) database connection response [26 Nov 2020 14:30:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'S06REP00078' [26 Nov 2020 14:30:20] (index) database connection response [26 Nov 2020 14:30:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'S06REP00078' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:30:20] (index) database connection response [26 Nov 2020 14:30:20] (index) getConnectionClose() called.... [26 Nov 2020 14:37:02] (index) database connection response [26 Nov 2020 14:37:02] (index) getConnection(): Resource id #1 [26 Nov 2020 14:37:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:37:02] (index) database connection response [26 Nov 2020 14:37:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:37:02] (index) database connection response [26 Nov 2020 14:37:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:37:02] (index) database connection response [26 Nov 2020 14:37:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'S06REP0078' [26 Nov 2020 14:37:02] (index) database connection response [26 Nov 2020 14:37:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'S06REP0078' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:37:02] (index) database connection response [26 Nov 2020 14:37:02] (index) getConnectionClose() called.... [26 Nov 2020 14:39:17] (index) database connection response [26 Nov 2020 14:39:17] (index) getConnection(): Resource id #1 [26 Nov 2020 14:39:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:39:17] (index) database connection response [26 Nov 2020 14:39:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:39:17] (index) database connection response [26 Nov 2020 14:39:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:39:17] (index) database connection response [26 Nov 2020 14:39:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'M0160000005222' [26 Nov 2020 14:39:17] (index) database connection response [26 Nov 2020 14:39:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'M0160000005222' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:39:18] (index) database connection response [26 Nov 2020 14:39:18] (index) getConnectionClose() called.... [26 Nov 2020 14:42:45] (index) database connection response [26 Nov 2020 14:42:45] (index) getConnection(): Resource id #1 [26 Nov 2020 14:42:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:42:45] (index) database connection response [26 Nov 2020 14:42:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:42:45] (index) database connection response [26 Nov 2020 14:42:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:42:45] (index) database connection response [26 Nov 2020 14:42:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'MIH133-3' [26 Nov 2020 14:42:45] (index) database connection response [26 Nov 2020 14:42:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'MIH133-3' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:42:45] (index) database connection response [26 Nov 2020 14:42:45] (index) getConnectionClose() called.... [26 Nov 2020 14:50:15] (index) database connection response [26 Nov 2020 14:50:15] (index) getConnection(): Resource id #1 [26 Nov 2020 14:50:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:50:15] (index) database connection response [26 Nov 2020 14:50:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:50:15] (index) database connection response [26 Nov 2020 14:50:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:50:15] (index) database connection response [26 Nov 2020 14:50:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = '000-00635350' [26 Nov 2020 14:50:16] (index) database connection response [26 Nov 2020 14:50:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = '000-00635350' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:50:16] (index) database connection response [26 Nov 2020 14:50:16] (index) getConnectionClose() called.... [26 Nov 2020 14:50:59] (index) database connection response [26 Nov 2020 14:50:59] (index) getConnection(): Resource id #1 [26 Nov 2020 14:50:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:50:59] (index) database connection response [26 Nov 2020 14:50:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:50:59] (index) database connection response [26 Nov 2020 14:50:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:50:59] (index) database connection response [26 Nov 2020 14:50:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = '20-0428432' [26 Nov 2020 14:50:59] (index) database connection response [26 Nov 2020 14:50:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = '20-0428432' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:50:59] (index) database connection response [26 Nov 2020 14:50:59] (index) getConnectionClose() called.... [26 Nov 2020 14:51:19] (index) database connection response [26 Nov 2020 14:51:19] (index) getConnection(): Resource id #1 [26 Nov 2020 14:51:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:51:19] (index) database connection response [26 Nov 2020 14:51:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:51:19] (index) database connection response [26 Nov 2020 14:51:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:51:19] (index) database connection response [26 Nov 2020 14:51:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'APPV2' [26 Nov 2020 14:51:19] (index) database connection response [26 Nov 2020 14:51:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'APPV2' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:51:19] (index) database connection response [26 Nov 2020 14:51:19] (index) getConnectionClose() called.... [26 Nov 2020 14:52:05] (index) database connection response [26 Nov 2020 14:52:05] (index) getConnection(): Resource id #1 [26 Nov 2020 14:52:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:52:05] (index) database connection response [26 Nov 2020 14:52:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:52:05] (index) database connection response [26 Nov 2020 14:52:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:52:05] (index) database connection response [26 Nov 2020 14:52:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'MIH133-3' [26 Nov 2020 14:52:05] (index) database connection response [26 Nov 2020 14:52:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = 'MIH133-3' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:52:05] (index) database connection response [26 Nov 2020 14:52:05] (index) getConnectionClose() called.... [26 Nov 2020 14:55:16] (index) database connection response [26 Nov 2020 14:55:16] (index) getConnection(): Resource id #1 [26 Nov 2020 14:55:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 14:55:16] (index) database connection response [26 Nov 2020 14:55:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 14:55:16] (index) database connection response [26 Nov 2020 14:55:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 14:55:16] (index) database connection response [26 Nov 2020 14:55:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000064' AND ACCESS_CODE = 'M01600000064' [26 Nov 2020 14:55:16] (index) database connection response [26 Nov 2020 14:55:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000064' AND ACCESS_CODE = 'M01600000064' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 14:55:17] (index) database connection response [26 Nov 2020 14:55:17] (index) getConnectionClose() called.... [26 Nov 2020 15:02:47] (index) database connection response [26 Nov 2020 15:02:47] (index) getConnection(): Resource id #1 [26 Nov 2020 15:02:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 15:02:47] (index) database connection response [26 Nov 2020 15:02:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 15:02:47] (index) database connection response [26 Nov 2020 15:02:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 15:02:47] (index) database connection response [26 Nov 2020 15:02:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200509954' AND ACCESS_CODE = '90430954' [26 Nov 2020 15:02:47] (index) database connection response [26 Nov 2020 15:02:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200509954' AND ACCESS_CODE = '90430954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 15:02:47] (index) database connection response [26 Nov 2020 15:02:47] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000644591' [26 Nov 2020 15:02:47] (index) database connection response [26 Nov 2020 15:02:47] (index) getPatientReportsDetail() entered [26 Nov 2020 15:02:47] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200509954', 'M0100000644591', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:02:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200509954', 'M0100000644591', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:02:48] (index) p_Stop=N [26 Nov 2020 15:02:48] (index) p_Alert= [26 Nov 2020 15:02: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 [26 Nov 2020 15:02:48] (index) database connection response [26 Nov 2020 15:02:48] (index) getConnectionClose() called.... [26 Nov 2020 15:02:48] (index) getConnectionClose() called.... [26 Nov 2020 15:02:57] (viewOnlineReports) database connection response [26 Nov 2020 15:02:57] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 15:02:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000644591', '001', '200428029', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:02:57] (viewOnlineReports) p_Stop=N [26 Nov 2020 15:02:57] (viewOnlineReports) p_Alert= [26 Nov 2020 15:02:57] (viewOnlineReports) Flag = 1 [26 Nov 2020 15:02: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', '200428029', 'M01', '070', '1', '001000000000087630', 'M0100000644591_M01MOL20013597_1.PDF', 'M0100000644591', SYSDATE) [26 Nov 2020 15:02:57] (viewOnlineReports) database connection response [26 Nov 2020 15:02:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428029' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 15:02:57] (viewOnlineReports) database connection response [26 Nov 2020 15:02:57] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 15:02:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428029/ [26 Nov 2020 15:02:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428029/ [26 Nov 2020 15:02:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644591_M01MOL20013597_1.PDF [26 Nov 2020 15:02:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428029/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606384977M0100000644591_M01MOL20013597_1.PDF [26 Nov 2020 15:02:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428029/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606384977M0100000644591_M01MOL20013597_1.PDF [26 Nov 2020 15:02:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Nov 2020 15:02:57] (viewOnlineReports) Downloading file ../../TEMP_PDF/200428029/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606384977M0100000644591_M01MOL20013597_1.PDF [26 Nov 2020 15:03:08] (index) database connection response [26 Nov 2020 15:03:08] (index) getConnection(): Resource id #1 [26 Nov 2020 15:03:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 15:03:08] (index) database connection response [26 Nov 2020 15:03:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 15:03:08] (index) database connection response [26 Nov 2020 15:03:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 15:03:08] (index) database connection response [26 Nov 2020 15:03:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = '000-00635350' [26 Nov 2020 15:03:08] (index) database connection response [26 Nov 2020 15:03:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = '000-00635350' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 15:03:08] (index) database connection response [26 Nov 2020 15:03:08] (index) getConnectionClose() called.... [26 Nov 2020 15:03:32] (index) database connection response [26 Nov 2020 15:03:32] (index) getConnection(): Resource id #1 [26 Nov 2020 15:03:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 15:03:32] (index) database connection response [26 Nov 2020 15:03:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 15:03:32] (index) database connection response [26 Nov 2020 15:03:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 15:03:32] (index) database connection response [26 Nov 2020 15:03:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = '00635350' [26 Nov 2020 15:03:32] (index) database connection response [26 Nov 2020 15:03:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511282' AND ACCESS_CODE = '00635350' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 15:03:32] (index) database connection response [26 Nov 2020 15:03:32] (index) getConnectionClose() called.... [26 Nov 2020 15:17:31] (index) database connection response [26 Nov 2020 15:17:31] (index) getConnection(): Resource id #1 [26 Nov 2020 15:17:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 15:17:31] (index) database connection response [26 Nov 2020 15:17:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 15:17:31] (index) database connection response [26 Nov 2020 15:17:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 15:17:31] (index) database connection response [26 Nov 2020 15:17:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' [26 Nov 2020 15:17:31] (index) database connection response [26 Nov 2020 15:17:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 15:17:31] (index) database connection response [26 Nov 2020 15:17:31] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 15:17:31] (index) database connection response [26 Nov 2020 15:17:31] (index) getPatientReportsDetail() entered [26 Nov 2020 15:17:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:17:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:17:31] (index) p_Stop=N [26 Nov 2020 15:17:31] (index) p_Alert= [26 Nov 2020 15:17:31] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 15:17:31] (index) database connection response [26 Nov 2020 15:17:31] (index) getConnectionClose() called.... [26 Nov 2020 15:17:31] (index) getConnectionClose() called.... [26 Nov 2020 15:32:15] (index) database connection response [26 Nov 2020 15:32:15] (index) getConnection(): Resource id #1 [26 Nov 2020 15:32:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 15:32:15] (index) database connection response [26 Nov 2020 15:32:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 15:32:15] (index) database connection response [26 Nov 2020 15:32:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 15:32:15] (index) database connection response [26 Nov 2020 15:32:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' [26 Nov 2020 15:32:15] (index) database connection response [26 Nov 2020 15:32:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 15:32:15] (index) database connection response [26 Nov 2020 15:32:15] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 15:32:15] (index) database connection response [26 Nov 2020 15:32:15] (index) getPatientReportsDetail() entered [26 Nov 2020 15:32:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:32:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:32:15] (index) p_Stop=N [26 Nov 2020 15:32:15] (index) p_Alert= [26 Nov 2020 15:32: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 [26 Nov 2020 15:32:15] (index) database connection response [26 Nov 2020 15:32:15] (index) getConnectionClose() called.... [26 Nov 2020 15:32:15] (index) getConnectionClose() called.... [26 Nov 2020 15:40:06] (index) database connection response [26 Nov 2020 15:40:06] (index) getConnection(): Resource id #1 [26 Nov 2020 15:40:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 15:40:06] (index) database connection response [26 Nov 2020 15:40:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 15:40:06] (index) database connection response [26 Nov 2020 15:40:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 15:40:06] (index) database connection response [26 Nov 2020 15:40:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' [26 Nov 2020 15:40:06] (index) database connection response [26 Nov 2020 15:40:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 15:40:06] (index) database connection response [26 Nov 2020 15:40:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 15:40:06] (index) database connection response [26 Nov 2020 15:40:06] (index) getPatientReportsDetail() entered [26 Nov 2020 15:40:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:40:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:40:06] (index) p_Stop=N [26 Nov 2020 15:40:06] (index) p_Alert= [26 Nov 2020 15:40:06] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 15:40:06] (index) database connection response [26 Nov 2020 15:40:06] (index) getConnectionClose() called.... [26 Nov 2020 15:40:06] (index) getConnectionClose() called.... [26 Nov 2020 15:51:29] (index) database connection response [26 Nov 2020 15:51:29] (index) getConnection(): Resource id #1 [26 Nov 2020 15:51:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 15:51:29] (index) database connection response [26 Nov 2020 15:51:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 15:51:29] (index) database connection response [26 Nov 2020 15:51:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 15:51:29] (index) database connection response [26 Nov 2020 15:51:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' [26 Nov 2020 15:51:29] (index) database connection response [26 Nov 2020 15:51:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 15:51:29] (index) database connection response [26 Nov 2020 15:51:29] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 15:51:29] (index) database connection response [26 Nov 2020 15:51:29] (index) getPatientReportsDetail() entered [26 Nov 2020 15:51:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:51:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 15:51:30] (index) p_Stop=N [26 Nov 2020 15:51:30] (index) p_Alert= [26 Nov 2020 15:51:30] (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 [26 Nov 2020 15:51:30] (index) database connection response [26 Nov 2020 15:51:30] (index) getConnectionClose() called.... [26 Nov 2020 15:51:30] (index) getConnectionClose() called.... [26 Nov 2020 16:16:27] (index) database connection response [26 Nov 2020 16:16:27] (index) getConnection(): Resource id #1 [26 Nov 2020 16:16:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 16:16:27] (index) database connection response [26 Nov 2020 16:16:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 16:16:27] (index) database connection response [26 Nov 2020 16:16:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 16:16:27] (index) database connection response [26 Nov 2020 16:16:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' [26 Nov 2020 16:16:27] (index) database connection response [26 Nov 2020 16:16:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 16:16:27] (index) database connection response [26 Nov 2020 16:16:27] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 16:16:27] (index) database connection response [26 Nov 2020 16:16:27] (index) getPatientReportsDetail() entered [26 Nov 2020 16:16:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:16:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:16:28] (index) p_Stop=N [26 Nov 2020 16:16:28] (index) p_Alert= [26 Nov 2020 16:16:28] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 16:16:28] (index) database connection response [26 Nov 2020 16:16:28] (index) getConnectionClose() called.... [26 Nov 2020 16:16:28] (index) getConnectionClose() called.... [26 Nov 2020 16:22:31] (index) database connection response [26 Nov 2020 16:22:31] (index) getConnection(): Resource id #1 [26 Nov 2020 16:22:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 16:22:31] (index) database connection response [26 Nov 2020 16:22:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 16:22:31] (index) database connection response [26 Nov 2020 16:22:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 16:22:31] (index) database connection response [26 Nov 2020 16:22:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511367' AND ACCESS_CODE = '31329574' [26 Nov 2020 16:22:31] (index) database connection response [26 Nov 2020 16:22:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511367' AND ACCESS_CODE = '31329574' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 16:22:31] (index) database connection response [26 Nov 2020 16:22:31] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000644744' [26 Nov 2020 16:22:31] (index) database connection response [26 Nov 2020 16:22:31] (index) getPatientReportsDetail() entered [26 Nov 2020 16:22:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511367', 'M0100000644744', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:22:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511367', 'M0100000644744', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:22:31] (index) p_Stop=N [26 Nov 2020 16:22:31] (index) p_Alert= [26 Nov 2020 16:22:31] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 16:22:31] (index) database connection response [26 Nov 2020 16:22:31] (index) getConnectionClose() called.... [26 Nov 2020 16:22:31] (index) getConnectionClose() called.... [26 Nov 2020 16:35:27] (index) database connection response [26 Nov 2020 16:35:27] (index) getConnection(): Resource id #1 [26 Nov 2020 16:35:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 16:35:27] (index) database connection response [26 Nov 2020 16:35:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 16:35:27] (index) database connection response [26 Nov 2020 16:35:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 16:35:27] (index) database connection response [26 Nov 2020 16:35:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' [26 Nov 2020 16:35:27] (index) database connection response [26 Nov 2020 16:35:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 16:35:27] (index) database connection response [26 Nov 2020 16:35:27] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 16:35:27] (index) database connection response [26 Nov 2020 16:35:27] (index) getPatientReportsDetail() entered [26 Nov 2020 16:35:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:35:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:35:27] (index) p_Stop=N [26 Nov 2020 16:35:27] (index) p_Alert= [26 Nov 2020 16:35:27] (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 [26 Nov 2020 16:35:27] (index) database connection response [26 Nov 2020 16:35:27] (index) getConnectionClose() called.... [26 Nov 2020 16:35:27] (index) getConnectionClose() called.... [26 Nov 2020 16:51:46] (index) database connection response [26 Nov 2020 16:51:46] (index) getConnection(): Resource id #1 [26 Nov 2020 16:51:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 16:51:46] (index) database connection response [26 Nov 2020 16:51:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 16:51:46] (index) database connection response [26 Nov 2020 16:51:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 16:51:46] (index) database connection response [26 Nov 2020 16:51:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511367' AND ACCESS_CODE = '31329574' [26 Nov 2020 16:51:46] (index) database connection response [26 Nov 2020 16:51:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511367' AND ACCESS_CODE = '31329574' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 16:51:46] (index) database connection response [26 Nov 2020 16:51:46] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000644744' [26 Nov 2020 16:51:46] (index) database connection response [26 Nov 2020 16:51:46] (index) getPatientReportsDetail() entered [26 Nov 2020 16:51:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511367', 'M0100000644744', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:51:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511367', 'M0100000644744', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:51:46] (index) p_Stop=N [26 Nov 2020 16:51:46] (index) p_Alert= [26 Nov 2020 16:51:46] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 16:51:46] (index) database connection response [26 Nov 2020 16:51:46] (index) getConnectionClose() called.... [26 Nov 2020 16:51:46] (index) getConnectionClose() called.... [26 Nov 2020 16:51:53] (viewOnlineReports) database connection response [26 Nov 2020 16:51:53] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 16:51:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000644744', '001', '200428461', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:51:53] (viewOnlineReports) p_Stop=N [26 Nov 2020 16:51:53] (viewOnlineReports) p_Alert= [26 Nov 2020 16:51:53] (viewOnlineReports) Flag = 1 [26 Nov 2020 16:51: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', '200428461', 'M01', '070', '1', '001000000000087630', 'M0100000644744_M01MOL20013697_1.PDF', 'M0100000644744', SYSDATE) [26 Nov 2020 16:51:53] (viewOnlineReports) database connection response [26 Nov 2020 16:51:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428461' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 16:51:53] (viewOnlineReports) database connection response [26 Nov 2020 16:51:53] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 16:51:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428461/ [26 Nov 2020 16:51:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428461/ [26 Nov 2020 16:51:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:51:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428461/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606391513M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:51:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428461/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606391513M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:51:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [26 Nov 2020 16:51:53] (viewOnlineReports) Converting PDF to JPG with name as M0100000644744_M01MOL20013697_1.jpg [26 Nov 2020 16:51:53] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200428461/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606391513M0100000644744_M01MOL20013697_1.PDF ../../TEMP_PDF/200428461/M0100000644744_M01MOL20013697_1.jpg [26 Nov 2020 16:51:53] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200428461/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606391513M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:11] (viewOnlineReports) database connection response [26 Nov 2020 16:52:11] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 16:52:11] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000644744', '001', '200428461', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:52:11] (viewOnlineReports) p_Stop=N [26 Nov 2020 16:52:11] (viewOnlineReports) p_Alert= [26 Nov 2020 16:52:11] (viewOnlineReports) Flag = 1 [26 Nov 2020 16:52:11] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428461', 'M01', '070', '1', '001000000000087630', 'M0100000644744_M01MOL20013697_1.PDF', 'M0100000644744', SYSDATE) [26 Nov 2020 16:52:11] (viewOnlineReports) database connection response [26 Nov 2020 16:52:11] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428461' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 16:52:11] (viewOnlineReports) database connection response [26 Nov 2020 16:52:11] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 16:52:11] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428461/ [26 Nov 2020 16:52:11] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428461/ [26 Nov 2020 16:52:11] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:11] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428461/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1606391531M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428461/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1606391531M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [26 Nov 2020 16:52:11] (viewOnlineReports) Converting PDF to JPG with name as M0100000644744_M01MOL20013697_1.jpg [26 Nov 2020 16:52:11] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200428461/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1606391531M0100000644744_M01MOL20013697_1.PDF ../../TEMP_PDF/200428461/M0100000644744_M01MOL20013697_1.jpg [26 Nov 2020 16:52:11] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200428461/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1606391531M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:26] (viewOnlineReports) database connection response [26 Nov 2020 16:52:26] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 16:52:26] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000644744', '001', '200428461', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:52:26] (viewOnlineReports) p_Stop=N [26 Nov 2020 16:52:26] (viewOnlineReports) p_Alert= [26 Nov 2020 16:52:26] (viewOnlineReports) Flag = 1 [26 Nov 2020 16:52:26] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428461', 'M01', '070', '1', '001000000000087630', 'M0100000644744_M01MOL20013697_1.PDF', 'M0100000644744', SYSDATE) [26 Nov 2020 16:52:26] (viewOnlineReports) database connection response [26 Nov 2020 16:52:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428461' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 16:52:26] (viewOnlineReports) database connection response [26 Nov 2020 16:52:26] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 16:52:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428461/ [26 Nov 2020 16:52:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428461/ [26 Nov 2020 16:52:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428461/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1606391546M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428461/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1606391546M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 16:52:26] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428461/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1606391546M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:41] (viewOnlineReports) database connection response [26 Nov 2020 16:52:41] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 16:52:41] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000644744', '001', '200428461', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:52:41] (viewOnlineReports) p_Stop=N [26 Nov 2020 16:52:41] (viewOnlineReports) p_Alert= [26 Nov 2020 16:52:41] (viewOnlineReports) Flag = 1 [26 Nov 2020 16:52: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', '200428461', 'M01', '070', '1', '001000000000087630', 'M0100000644744_M01MOL20013697_1.PDF', 'M0100000644744', SYSDATE) [26 Nov 2020 16:52:41] (viewOnlineReports) database connection response [26 Nov 2020 16:52:41] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428461' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 16:52:41] (viewOnlineReports) database connection response [26 Nov 2020 16:52:41] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 16:52:41] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428461/ [26 Nov 2020 16:52:41] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428461/ [26 Nov 2020 16:52:41] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:41] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428461/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1606391561M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:41] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428461/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1606391561M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:41] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 16:52:41] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428461/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1606391561M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:57] (viewOnlineReports) database connection response [26 Nov 2020 16:52:57] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 16:52:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000644744', '001', '200428461', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 16:52:57] (viewOnlineReports) p_Stop=N [26 Nov 2020 16:52:57] (viewOnlineReports) p_Alert= [26 Nov 2020 16:52:57] (viewOnlineReports) Flag = 1 [26 Nov 2020 16:52: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', '200428461', 'M01', '070', '1', '001000000000087630', 'M0100000644744_M01MOL20013697_1.PDF', 'M0100000644744', SYSDATE) [26 Nov 2020 16:52:57] (viewOnlineReports) database connection response [26 Nov 2020 16:52:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428461' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 16:52:57] (viewOnlineReports) database connection response [26 Nov 2020 16:52:57] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 16:52:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428461/ [26 Nov 2020 16:52:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428461/ [26 Nov 2020 16:52:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428461/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1606391577M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428461/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1606391577M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 16:52:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 16:52:57] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428461/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1606391577M0100000644744_M01MOL20013697_1.PDF [26 Nov 2020 17:22:22] (index) database connection response [26 Nov 2020 17:22:22] (index) getConnection(): Resource id #1 [26 Nov 2020 17:22:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 17:22:22] (index) database connection response [26 Nov 2020 17:22:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 17:22:22] (index) database connection response [26 Nov 2020 17:22:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 17:22:22] (index) database connection response [26 Nov 2020 17:22:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' [26 Nov 2020 17:22:22] (index) database connection response [26 Nov 2020 17:22:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511924' AND ACCESS_CODE = '65309559' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 17:22:22] (index) database connection response [26 Nov 2020 17:22:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 17:22:22] (index) database connection response [26 Nov 2020 17:22:22] (index) getPatientReportsDetail() entered [26 Nov 2020 17:22:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 17:22:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511924', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 17:22:22] (index) p_Stop=N [26 Nov 2020 17:22:22] (index) p_Alert= [26 Nov 2020 17:22: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 [26 Nov 2020 17:22:22] (index) database connection response [26 Nov 2020 17:22:22] (index) getConnectionClose() called.... [26 Nov 2020 17:22:22] (index) getConnectionClose() called.... [26 Nov 2020 17:22:33] (viewOnlineReports) database connection response [26 Nov 2020 17:22:33] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 17:22:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000472280', '001', '200428730', '1', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 17:22:34] (viewOnlineReports) p_Stop=N [26 Nov 2020 17:22:34] (viewOnlineReports) p_Alert= [26 Nov 2020 17:22:34] (viewOnlineReports) Flag = 1 [26 Nov 2020 17:22: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', '200428730', 'M01', '047', '1', '001000000000082047', 'M0100000472280_M01RCH20023251_1.PDF', 'M0100000472280', SYSDATE) [26 Nov 2020 17:22:34] (viewOnlineReports) database connection response [26 Nov 2020 17:22:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428730' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Nov 2020 17:22:34] (viewOnlineReports) database connection response [26 Nov 2020 17:22:34] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 17:22:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428730/ [26 Nov 2020 17:22:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428730/ [26 Nov 2020 17:22:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000472280_M01RCH20023251_1.PDF [26 Nov 2020 17:22:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428730/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1606393353M0100000472280_M01RCH20023251_1.PDF [26 Nov 2020 17:22:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428730/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1606393353M0100000472280_M01RCH20023251_1.PDF [26 Nov 2020 17:22:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Nov 2020 17:22:34] (viewOnlineReports) Converting PDF to JPG with name as M0100000472280_M01RCH20023251_1.jpg [26 Nov 2020 17:22:34] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200428730/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1606393353M0100000472280_M01RCH20023251_1.PDF ../../TEMP_PDF/200428730/M0100000472280_M01RCH20023251_1.jpg [26 Nov 2020 17:22:34] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200428730/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1606393353M0100000472280_M01RCH20023251_1.PDF [26 Nov 2020 17:23:09] (viewOnlineReports) database connection response [26 Nov 2020 17:23:09] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 17:23:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000472280', '001', '200428730', '2', '001000000000085378', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 17:23:09] (viewOnlineReports) p_Stop=N [26 Nov 2020 17:23:09] (viewOnlineReports) p_Alert= [26 Nov 2020 17:23:09] (viewOnlineReports) Flag = 1 [26 Nov 2020 17:23: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', '200428730', 'M01', '047', '2', '001000000000085378', 'M0100000472280_M01RCH20023251_3.PDF', 'M0100000472280', SYSDATE) [26 Nov 2020 17:23:09] (viewOnlineReports) database connection response [26 Nov 2020 17:23:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428730' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [26 Nov 2020 17:23:09] (viewOnlineReports) database connection response [26 Nov 2020 17:23:09] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 17:23:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428730/ [26 Nov 2020 17:23:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428730/ [26 Nov 2020 17:23:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000472280_M01RCH20023251_3.PDF [26 Nov 2020 17:23:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428730/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1606393389M0100000472280_M01RCH20023251_3.PDF [26 Nov 2020 17:23:09] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428730/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1606393389M0100000472280_M01RCH20023251_3.PDF [26 Nov 2020 17:23:09] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Nov 2020 17:23:09] (viewOnlineReports) Converting PDF to JPG with name as M0100000472280_M01RCH20023251_3.jpg [26 Nov 2020 17:23:09] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200428730/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1606393389M0100000472280_M01RCH20023251_3.PDF ../../TEMP_PDF/200428730/M0100000472280_M01RCH20023251_3.jpg [26 Nov 2020 17:23:09] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200428730/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1606393389M0100000472280_M01RCH20023251_3.PDF [26 Nov 2020 17:23:30] (viewOnlineReports) database connection response [26 Nov 2020 17:23:30] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 17:23:30] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000472280', '001', '200428730', '3', '001000000000082803', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 17:23:30] (viewOnlineReports) p_Stop=N [26 Nov 2020 17:23:30] (viewOnlineReports) p_Alert= [26 Nov 2020 17:23:30] (viewOnlineReports) Flag = 1 [26 Nov 2020 17:23: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', '200428730', 'M01', '047', '3', '001000000000082803', 'M0100000472280_M01RCH20023251_2.PDF', 'M0100000472280', SYSDATE) [26 Nov 2020 17:23:30] (viewOnlineReports) database connection response [26 Nov 2020 17:23:30] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428730' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 17:23:30] (viewOnlineReports) database connection response [26 Nov 2020 17:23:30] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 17:23:30] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428730/ [26 Nov 2020 17:23:30] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428730/ [26 Nov 2020 17:23:30] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000472280_M01RCH20023251_2.PDF [26 Nov 2020 17:23:30] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428730/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1606393410M0100000472280_M01RCH20023251_2.PDF [26 Nov 2020 17:23:30] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428730/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1606393410M0100000472280_M01RCH20023251_2.PDF [26 Nov 2020 17:23:30] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Nov 2020 17:23:30] (viewOnlineReports) Converting PDF to JPG with name as M0100000472280_M01RCH20023251_2.jpg [26 Nov 2020 17:23:30] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200428730/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1606393410M0100000472280_M01RCH20023251_2.PDF ../../TEMP_PDF/200428730/M0100000472280_M01RCH20023251_2.jpg [26 Nov 2020 17:23:30] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200428730/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1606393410M0100000472280_M01RCH20023251_2.PDF [26 Nov 2020 17:36:08] (viewOnlineReports) database connection response [26 Nov 2020 17:36:08] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 17:36:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200428730', '3', '001000000000082803', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 17:36:08] (viewOnlineReports) p_Stop=N [26 Nov 2020 17:36:08] (viewOnlineReports) p_Alert= [26 Nov 2020 17:36:08] (viewOnlineReports) Flag = 1 [26 Nov 2020 17:36: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', '200428730', 'M01', '047', '3', '001000000000082803', 'M0100000472280_M01RCH20023251_2.PDF', '00100000000000', SYSDATE) [26 Nov 2020 17:36:08] (viewOnlineReports) database connection response [26 Nov 2020 17:36:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428730' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Nov 2020 17:36:08] (viewOnlineReports) database connection response [26 Nov 2020 17:36:08] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 17:36:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428730/ [26 Nov 2020 17:36:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428730/ [26 Nov 2020 17:36:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000472280_M01RCH20023251_2.PDF [26 Nov 2020 17:36:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428730/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000472280_M01RCH20023251_2.PDF [26 Nov 2020 17:36:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428730/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000472280_M01RCH20023251_2.PDF [26 Nov 2020 17:36:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Nov 2020 17:36:08] (viewOnlineReports) Converting PDF to JPG with name as M0100000472280_M01RCH20023251_2.jpg [26 Nov 2020 17:36:08] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200428730/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000472280_M01RCH20023251_2.PDF ../../TEMP_PDF/200428730/M0100000472280_M01RCH20023251_2.jpg [26 Nov 2020 17:36:08] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200428730/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZM0100000472280_M01RCH20023251_2.PDF [26 Nov 2020 17:36:58] (index) database connection response [26 Nov 2020 17:36:58] (index) getConnection(): Resource id #1 [26 Nov 2020 17:36:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 17:36:58] (index) database connection response [26 Nov 2020 17:36:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 17:36:58] (index) database connection response [26 Nov 2020 17:36:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 17:36:58] (index) database connection response [26 Nov 2020 17:36:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06982954' [26 Nov 2020 17:36:58] (index) database connection response [26 Nov 2020 17:36:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06982954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 17:36:58] (index) database connection response [26 Nov 2020 17:36:58] (index) getConnectionClose() called.... [26 Nov 2020 17:39:11] (index) database connection response [26 Nov 2020 17:39:11] (index) getConnection(): Resource id #1 [26 Nov 2020 17:39:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 17:39:11] (index) database connection response [26 Nov 2020 17:39:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 17:39:11] (index) database connection response [26 Nov 2020 17:39:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 17:39:11] (index) database connection response [26 Nov 2020 17:39:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 17:39:11] (index) database connection response [26 Nov 2020 17:39:11] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 17:39:11] (index) database connection response [26 Nov 2020 17:39:11] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 17:39:11] (index) database connection response [26 Nov 2020 17:39:11] (index) getPatientReportsDetail() entered [26 Nov 2020 17:39:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 17:39:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 17:39:11] (index) p_Stop=N [26 Nov 2020 17:39:11] (index) p_Alert= [26 Nov 2020 17:39:11] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 17:39:11] (index) database connection response [26 Nov 2020 17:39:11] (index) getConnectionClose() called.... [26 Nov 2020 17:39:11] (index) getConnectionClose() called.... [26 Nov 2020 18:07:43] (index) database connection response [26 Nov 2020 18:07:43] (index) getConnection(): Resource id #1 [26 Nov 2020 18:07:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 18:07:43] (index) database connection response [26 Nov 2020 18:07:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 18:07:43] (index) database connection response [26 Nov 2020 18:07:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 18:07:43] (index) database connection response [26 Nov 2020 18:07:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512052' AND ACCESS_CODE = '52605981' [26 Nov 2020 18:07:43] (index) database connection response [26 Nov 2020 18:07:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512052' AND ACCESS_CODE = '52605981' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 18:07:43] (index) database connection response [26 Nov 2020 18:07:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000580477' [26 Nov 2020 18:07:43] (index) database connection response [26 Nov 2020 18:07:43] (index) getPatientReportsDetail() entered [26 Nov 2020 18:07:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512052', 'M0100000580477', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:07:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512052', 'M0100000580477', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:07:43] (index) p_Stop=N [26 Nov 2020 18:07:43] (index) p_Alert= [26 Nov 2020 18:07: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 [26 Nov 2020 18:07:43] (index) database connection response [26 Nov 2020 18:07:43] (index) getConnectionClose() called.... [26 Nov 2020 18:07:43] (index) getConnectionClose() called.... [26 Nov 2020 18:08:50] (index) database connection response [26 Nov 2020 18:08:50] (index) getConnection(): Resource id #1 [26 Nov 2020 18:08:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 18:08:50] (index) database connection response [26 Nov 2020 18:08:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 18:08:50] (index) database connection response [26 Nov 2020 18:08:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 18:08:50] (index) database connection response [26 Nov 2020 18:08:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510529' AND ACCESS_CODE = '40152764' [26 Nov 2020 18:08:50] (index) database connection response [26 Nov 2020 18:08:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510529' AND ACCESS_CODE = '40152764' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 18:08:50] (index) database connection response [26 Nov 2020 18:08:50] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000644628' [26 Nov 2020 18:08:50] (index) database connection response [26 Nov 2020 18:08:50] (index) getPatientReportsDetail() entered [26 Nov 2020 18:08:50] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200510529', 'M0100000644628', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:08:50] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200510529', 'M0100000644628', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:08:50] (index) p_Stop=N [26 Nov 2020 18:08:50] (index) p_Alert= [26 Nov 2020 18:08:50] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 18:08:50] (index) database connection response [26 Nov 2020 18:08:50] (index) getConnectionClose() called.... [26 Nov 2020 18:08:50] (index) getConnectionClose() called.... [26 Nov 2020 18:09:20] (viewOnlineReports) database connection response [26 Nov 2020 18:09:20] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 18:09:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000644628', '001', '200428245', '2', '001000000000080061', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:09:20] (viewOnlineReports) p_Stop=N [26 Nov 2020 18:09:20] (viewOnlineReports) p_Alert= [26 Nov 2020 18:09:20] (viewOnlineReports) Flag = 1 [26 Nov 2020 18:09: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', '200428245', 'M01', '047', '2', '001000000000080061', 'M0100000644628_M01RCH20023152_1.PDF', 'M0100000644628', SYSDATE) [26 Nov 2020 18:09:20] (viewOnlineReports) database connection response [26 Nov 2020 18:09:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428245' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [26 Nov 2020 18:09:20] (viewOnlineReports) database connection response [26 Nov 2020 18:09:20] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 18:09:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428245/ [26 Nov 2020 18:09:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428245/ [26 Nov 2020 18:09:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000644628_M01RCH20023152_1.PDF [26 Nov 2020 18:09:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428245/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606396160M0100000644628_M01RCH20023152_1.PDF [26 Nov 2020 18:09:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428245/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606396160M0100000644628_M01RCH20023152_1.PDF [26 Nov 2020 18:09:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 18:09:20] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428245/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1606396160M0100000644628_M01RCH20023152_1.PDF [26 Nov 2020 18:32:39] (index) database connection response [26 Nov 2020 18:32:39] (index) getConnection(): Resource id #1 [26 Nov 2020 18:32:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 18:32:39] (index) database connection response [26 Nov 2020 18:32:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 18:32:39] (index) database connection response [26 Nov 2020 18:32:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 18:32:39] (index) database connection response [26 Nov 2020 18:32:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 18:32:39] (index) database connection response [26 Nov 2020 18:32:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 18:32:39] (index) database connection response [26 Nov 2020 18:32:39] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 18:32:39] (index) database connection response [26 Nov 2020 18:32:39] (index) getPatientReportsDetail() entered [26 Nov 2020 18:32:39] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:32:39] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:32:39] (index) p_Stop=N [26 Nov 2020 18:32:39] (index) p_Alert= [26 Nov 2020 18:32:39] (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 [26 Nov 2020 18:32:39] (index) database connection response [26 Nov 2020 18:32:39] (index) getConnectionClose() called.... [26 Nov 2020 18:32:39] (index) getConnectionClose() called.... [26 Nov 2020 18:41:36] (index) database connection response [26 Nov 2020 18:41:36] (index) getConnection(): Resource id #1 [26 Nov 2020 18:41:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 18:41:36] (index) database connection response [26 Nov 2020 18:41:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 18:41:36] (index) database connection response [26 Nov 2020 18:41:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 18:41:36] (index) database connection response [26 Nov 2020 18:41:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512052' AND ACCESS_CODE = '52605981' [26 Nov 2020 18:41:36] (index) database connection response [26 Nov 2020 18:41:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512052' AND ACCESS_CODE = '52605981' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 18:41:37] (index) database connection response [26 Nov 2020 18:41:37] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000580477' [26 Nov 2020 18:41:37] (index) database connection response [26 Nov 2020 18:41:37] (index) getPatientReportsDetail() entered [26 Nov 2020 18:41:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512052', 'M0100000580477', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:41:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512052', 'M0100000580477', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 18:41:37] (index) p_Stop=N [26 Nov 2020 18:41:37] (index) p_Alert= [26 Nov 2020 18:41: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 [26 Nov 2020 18:41:37] (index) database connection response [26 Nov 2020 18:41:37] (index) getConnectionClose() called.... [26 Nov 2020 18:41:37] (index) getConnectionClose() called.... [26 Nov 2020 19:24:56] (index) database connection response [26 Nov 2020 19:24:56] (index) getConnection(): Resource id #1 [26 Nov 2020 19:24:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 19:24:56] (index) database connection response [26 Nov 2020 19:24:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 19:24:56] (index) database connection response [26 Nov 2020 19:24:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 19:24:56] (index) database connection response [26 Nov 2020 19:24:56] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 19:24:56] (index) database connection response [26 Nov 2020 19:24:56] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 19:24:56] (index) database connection response [26 Nov 2020 19:24:56] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 19:24:56] (index) database connection response [26 Nov 2020 19:24:56] (index) getPatientReportsDetail() entered [26 Nov 2020 19:24:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 19:24:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 19:24:56] (index) p_Stop=N [26 Nov 2020 19:24:56] (index) p_Alert= [26 Nov 2020 19:24:56] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 19:24:56] (index) database connection response [26 Nov 2020 19:24:56] (index) getConnectionClose() called.... [26 Nov 2020 19:24:56] (index) getConnectionClose() called.... [26 Nov 2020 19:37:07] (index) database connection response [26 Nov 2020 19:37:07] (index) getConnection(): Resource id #1 [26 Nov 2020 19:37:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 19:37:07] (index) database connection response [26 Nov 2020 19:37:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 19:37:07] (index) database connection response [26 Nov 2020 19:37:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 19:37:07] (index) database connection response [26 Nov 2020 19:37:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512052' AND ACCESS_CODE = '52605981' [26 Nov 2020 19:37:07] (index) database connection response [26 Nov 2020 19:37:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512052' AND ACCESS_CODE = '52605981' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 19:37:07] (index) database connection response [26 Nov 2020 19:37:07] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000580477' [26 Nov 2020 19:37:07] (index) database connection response [26 Nov 2020 19:37:07] (index) getPatientReportsDetail() entered [26 Nov 2020 19:37:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512052', 'M0100000580477', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 19:37:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512052', 'M0100000580477', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 19:37:07] (index) p_Stop=N [26 Nov 2020 19:37:07] (index) p_Alert= [26 Nov 2020 19:37:07] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 19:37:07] (index) database connection response [26 Nov 2020 19:37:07] (index) getConnectionClose() called.... [26 Nov 2020 19:37:07] (index) getConnectionClose() called.... [26 Nov 2020 19:43:56] (index) database connection response [26 Nov 2020 19:43:56] (index) getConnection(): Resource id #1 [26 Nov 2020 19:43:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 19:43:56] (index) database connection response [26 Nov 2020 19:43:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 19:43:56] (index) database connection response [26 Nov 2020 19:43:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 19:43:56] (index) database connection response [26 Nov 2020 19:43:56] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 19:43:56] (index) database connection response [26 Nov 2020 19:43:56] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 19:43:56] (index) database connection response [26 Nov 2020 19:43:56] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 19:43:56] (index) database connection response [26 Nov 2020 19:43:56] (index) getPatientReportsDetail() entered [26 Nov 2020 19:43:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 19:43:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 19:43:56] (index) p_Stop=N [26 Nov 2020 19:43:56] (index) p_Alert= [26 Nov 2020 19:43:56] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 19:43:56] (index) database connection response [26 Nov 2020 19:43:56] (index) getConnectionClose() called.... [26 Nov 2020 19:43:56] (index) getConnectionClose() called.... [26 Nov 2020 19:58:43] (index) database connection response [26 Nov 2020 19:58:43] (index) getConnection(): Resource id #1 [26 Nov 2020 19:58:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 19:58:43] (index) database connection response [26 Nov 2020 19:58:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 19:58:43] (index) database connection response [26 Nov 2020 19:58:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 19:58:43] (index) database connection response [26 Nov 2020 19:58:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512052' AND ACCESS_CODE = '52605981' [26 Nov 2020 19:58:43] (index) database connection response [26 Nov 2020 19:58:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512052' AND ACCESS_CODE = '52605981' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 19:58:43] (index) database connection response [26 Nov 2020 19:58:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000580477' [26 Nov 2020 19:58:43] (index) database connection response [26 Nov 2020 19:58:43] (index) getPatientReportsDetail() entered [26 Nov 2020 19:58:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512052', 'M0100000580477', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 19:58:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512052', 'M0100000580477', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 19:58:43] (index) p_Stop=N [26 Nov 2020 19:58:43] (index) p_Alert= [26 Nov 2020 19:58: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 [26 Nov 2020 19:58:43] (index) database connection response [26 Nov 2020 19:58:43] (index) getConnectionClose() called.... [26 Nov 2020 19:58:43] (index) getConnectionClose() called.... [26 Nov 2020 20:00:05] (index) database connection response [26 Nov 2020 20:00:05] (index) getConnection(): Resource id #1 [26 Nov 2020 20:00:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 20:00:05] (index) database connection response [26 Nov 2020 20:00:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 20:00:05] (index) database connection response [26 Nov 2020 20:00:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 20:00:05] (index) database connection response [26 Nov 2020 20:00:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 20:00:05] (index) database connection response [26 Nov 2020 20:00:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 20:00:05] (index) database connection response [26 Nov 2020 20:00:05] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 20:00:05] (index) database connection response [26 Nov 2020 20:00:05] (index) getPatientReportsDetail() entered [26 Nov 2020 20:00:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 20:00:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 20:00:05] (index) p_Stop=N [26 Nov 2020 20:00:05] (index) p_Alert= [26 Nov 2020 20:00:05] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 20:00:06] (index) database connection response [26 Nov 2020 20:00:06] (index) getConnectionClose() called.... [26 Nov 2020 20:00:06] (index) getConnectionClose() called.... [26 Nov 2020 20:04:40] (index) database connection response [26 Nov 2020 20:04:40] (index) getConnection(): Resource id #1 [26 Nov 2020 20:04:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 20:04:40] (index) database connection response [26 Nov 2020 20:04:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 20:04:40] (index) database connection response [26 Nov 2020 20:04:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 20:04:40] (index) database connection response [26 Nov 2020 20:04:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 20:04:40] (index) database connection response [26 Nov 2020 20:04:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 20:04:40] (index) database connection response [26 Nov 2020 20:04:40] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 20:04:40] (index) database connection response [26 Nov 2020 20:04:40] (index) getPatientReportsDetail() entered [26 Nov 2020 20:04:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 20:04:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 20:04:40] (index) p_Stop=N [26 Nov 2020 20:04:40] (index) p_Alert= [26 Nov 2020 20:04:40] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 20:04:40] (index) database connection response [26 Nov 2020 20:04:40] (index) getConnectionClose() called.... [26 Nov 2020 20:04:40] (index) getConnectionClose() called.... [26 Nov 2020 20:15:04] (index) database connection response [26 Nov 2020 20:15:04] (index) getConnection(): Resource id #1 [26 Nov 2020 20:15:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 20:15:04] (index) database connection response [26 Nov 2020 20:15:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 20:15:04] (index) database connection response [26 Nov 2020 20:15:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 20:15:04] (index) database connection response [26 Nov 2020 20:15:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 20:15:05] (index) database connection response [26 Nov 2020 20:15:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 20:15:05] (index) database connection response [26 Nov 2020 20:15:05] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 20:15:05] (index) database connection response [26 Nov 2020 20:15:05] (index) getPatientReportsDetail() entered [26 Nov 2020 20:15:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 20:15:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 20:15:05] (index) p_Stop=N [26 Nov 2020 20:15:05] (index) p_Alert= [26 Nov 2020 20:15:05] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Nov 2020 20:15:05] (index) database connection response [26 Nov 2020 20:15:05] (index) getConnectionClose() called.... [26 Nov 2020 20:15:05] (index) getConnectionClose() called.... [26 Nov 2020 21:13:34] (index) database connection response [26 Nov 2020 21:13:34] (index) getConnection(): Resource id #1 [26 Nov 2020 21:13:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 21:13:34] (index) database connection response [26 Nov 2020 21:13:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 21:13:34] (index) database connection response [26 Nov 2020 21:13:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 21:13:34] (index) database connection response [26 Nov 2020 21:13:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 21:13:34] (index) database connection response [26 Nov 2020 21:13:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 21:13:34] (index) database connection response [26 Nov 2020 21:13:34] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 21:13:34] (index) database connection response [26 Nov 2020 21:13:34] (index) getPatientReportsDetail() entered [26 Nov 2020 21:13:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:13:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:13:34] (index) p_Stop=N [26 Nov 2020 21:13:34] (index) p_Alert= [26 Nov 2020 21:13:34] (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 [26 Nov 2020 21:13:34] (index) database connection response [26 Nov 2020 21:13:34] (index) getConnectionClose() called.... [26 Nov 2020 21:13:34] (index) getConnectionClose() called.... [26 Nov 2020 21:21:47] (index) database connection response [26 Nov 2020 21:21:47] (index) getConnection(): Resource id #1 [26 Nov 2020 21:21:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 21:21:47] (index) database connection response [26 Nov 2020 21:21:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 21:21:47] (index) database connection response [26 Nov 2020 21:21:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 21:21:47] (index) database connection response [26 Nov 2020 21:21:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511773' AND ACCESS_CODE = '85487135' [26 Nov 2020 21:21:47] (index) database connection response [26 Nov 2020 21:21:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511773' AND ACCESS_CODE = '85487135' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 21:21:47] (index) database connection response [26 Nov 2020 21:21:47] (index) getConnectionClose() called.... [26 Nov 2020 21:25:19] (index) database connection response [26 Nov 2020 21:25:19] (index) getConnection(): Resource id #1 [26 Nov 2020 21:25:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 21:25:19] (index) database connection response [26 Nov 2020 21:25:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 21:25:19] (index) database connection response [26 Nov 2020 21:25:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 21:25:19] (index) database connection response [26 Nov 2020 21:25:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512044' AND ACCESS_CODE = '16539650' [26 Nov 2020 21:25:19] (index) database connection response [26 Nov 2020 21:25:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512044' AND ACCESS_CODE = '16539650' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 21:25:19] (index) database connection response [26 Nov 2020 21:25:19] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000644836' [26 Nov 2020 21:25:19] (index) database connection response [26 Nov 2020 21:25:19] (index) getPatientReportsDetail() entered [26 Nov 2020 21:25:19] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512044', 'M0100000644836', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:25:19] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512044', 'M0100000644836', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:25:19] (index) p_Stop=N [26 Nov 2020 21:25:19] (index) p_Alert= [26 Nov 2020 21:25:19] (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 [26 Nov 2020 21:25:19] (index) database connection response [26 Nov 2020 21:25:19] (index) getConnectionClose() called.... [26 Nov 2020 21:25:19] (index) getConnectionClose() called.... [26 Nov 2020 21:35:29] (index) database connection response [26 Nov 2020 21:35:29] (index) getConnection(): Resource id #1 [26 Nov 2020 21:35:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 21:35:29] (index) database connection response [26 Nov 2020 21:35:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 21:35:29] (index) database connection response [26 Nov 2020 21:35:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 21:35:29] (index) database connection response [26 Nov 2020 21:35:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 21:35:29] (index) database connection response [26 Nov 2020 21:35:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 21:35:29] (index) database connection response [26 Nov 2020 21:35:29] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 21:35:29] (index) database connection response [26 Nov 2020 21:35:29] (index) getPatientReportsDetail() entered [26 Nov 2020 21:35:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:35:29] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:35:29] (index) p_Stop=N [26 Nov 2020 21:35:29] (index) p_Alert= [26 Nov 2020 21:35: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 [26 Nov 2020 21:35:29] (index) database connection response [26 Nov 2020 21:35:29] (index) getConnectionClose() called.... [26 Nov 2020 21:35:29] (index) getConnectionClose() called.... [26 Nov 2020 21:40:19] (index) database connection response [26 Nov 2020 21:40:19] (index) getConnection(): Resource id #1 [26 Nov 2020 21:40:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 21:40:19] (index) database connection response [26 Nov 2020 21:40:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 21:40:19] (index) database connection response [26 Nov 2020 21:40:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 21:40:19] (index) database connection response [26 Nov 2020 21:40:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511773' AND ACCESS_CODE = '85467135' [26 Nov 2020 21:40:20] (index) database connection response [26 Nov 2020 21:40:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200511773' AND ACCESS_CODE = '85467135' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 21:40:20] (index) database connection response [26 Nov 2020 21:40:20] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000644813' [26 Nov 2020 21:40:20] (index) database connection response [26 Nov 2020 21:40:20] (index) getPatientReportsDetail() entered [26 Nov 2020 21:40:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511773', 'M0100000644813', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:40:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200511773', 'M0100000644813', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:40:20] (index) p_Stop=N [26 Nov 2020 21:40:20] (index) p_Alert= [26 Nov 2020 21:40:20] (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 [26 Nov 2020 21:40:20] (index) database connection response [26 Nov 2020 21:40:20] (index) getConnectionClose() called.... [26 Nov 2020 21:40:20] (index) getConnectionClose() called.... [26 Nov 2020 21:40:33] (viewOnlineReports) database connection response [26 Nov 2020 21:40:33] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 21:40:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000644813', '001', '200428674', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 21:40:33] (viewOnlineReports) p_Stop=N [26 Nov 2020 21:40:33] (viewOnlineReports) p_Alert= [26 Nov 2020 21:40:33] (viewOnlineReports) Flag = 1 [26 Nov 2020 21:40:33] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428674', 'M01', '070', '1', '001000000000087630', 'M0100000644813_M01MOL20013734_1.PDF', 'M0100000644813', SYSDATE) [26 Nov 2020 21:40:33] (viewOnlineReports) database connection response [26 Nov 2020 21:40:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428674' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 21:40:33] (viewOnlineReports) database connection response [26 Nov 2020 21:40:33] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 21:40:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428674/ [26 Nov 2020 21:40:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428674/ [26 Nov 2020 21:40:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000644813_M01MOL20013734_1.PDF [26 Nov 2020 21:40:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428674/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1606408833M0100000644813_M01MOL20013734_1.PDF [26 Nov 2020 21:40:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428674/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1606408833M0100000644813_M01MOL20013734_1.PDF [26 Nov 2020 21:40:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Nov 2020 21:40:34] (viewOnlineReports) Downloading file ../../TEMP_PDF/200428674/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1606408833M0100000644813_M01MOL20013734_1.PDF [26 Nov 2020 22:44:43] (index) database connection response [26 Nov 2020 22:44:43] (index) getConnection(): Resource id #1 [26 Nov 2020 22:44:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 22:44:43] (index) database connection response [26 Nov 2020 22:44:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 22:44:43] (index) database connection response [26 Nov 2020 22:44:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 22:44:43] (index) database connection response [26 Nov 2020 22:44:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510941' AND ACCESS_CODE = '28573203' [26 Nov 2020 22:44:43] (index) database connection response [26 Nov 2020 22:44:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200510941' AND ACCESS_CODE = '28573203' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 22:44:43] (index) database connection response [26 Nov 2020 22:44:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000534191' [26 Nov 2020 22:44:43] (index) database connection response [26 Nov 2020 22:44:43] (index) getPatientReportsDetail() entered [26 Nov 2020 22:44:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200510941', 'M0100000534191', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 22:44:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200510941', 'M0100000534191', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 22:44:43] (index) p_Stop=N [26 Nov 2020 22:44:43] (index) p_Alert= [26 Nov 2020 22:44: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 [26 Nov 2020 22:44:43] (index) database connection response [26 Nov 2020 22:44:43] (index) getConnectionClose() called.... [26 Nov 2020 22:44:43] (index) getConnectionClose() called.... [26 Nov 2020 22:45:09] (viewOnlineReports) database connection response [26 Nov 2020 22:45:09] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 22:45:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000534191', '001', '200428372', '1', '001000000000086000', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 22:45:09] (viewOnlineReports) p_Stop=N [26 Nov 2020 22:45:09] (viewOnlineReports) p_Alert= [26 Nov 2020 22:45:09] (viewOnlineReports) Flag = 1 [26 Nov 2020 22:45: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', '200428372', 'M01', '047', '1', '001000000000086000', 'M0100000534191_M01MIC20009288_1.PDF', 'M0100000534191', SYSDATE) [26 Nov 2020 22:45:09] (viewOnlineReports) database connection response [26 Nov 2020 22:45:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428372' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Nov 2020 22:45:09] (viewOnlineReports) database connection response [26 Nov 2020 22:45:09] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 22:45:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428372/ [26 Nov 2020 22:45:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428372/ [26 Nov 2020 22:45:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000534191_M01MIC20009288_1.PDF [26 Nov 2020 22:45:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428372/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606412709M0100000534191_M01MIC20009288_1.PDF [26 Nov 2020 22:45:10] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428372/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606412709M0100000534191_M01MIC20009288_1.PDF [26 Nov 2020 22:45:10] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Nov 2020 22:45:10] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200428372/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1606412709M0100000534191_M01MIC20009288_1.PDF [26 Nov 2020 22:45:35] (viewOnlineReports) database connection response [26 Nov 2020 22:45:35] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 22:45:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000534191', '001', '200428372', '1', '001000000000086000', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 22:45:35] (viewOnlineReports) p_Stop=N [26 Nov 2020 22:45:35] (viewOnlineReports) p_Alert= [26 Nov 2020 22:45:35] (viewOnlineReports) Flag = 1 [26 Nov 2020 22:45: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', '200428372', 'M01', '047', '1', '001000000000086000', 'M0100000534191_M01MIC20009288_1.PDF', 'M0100000534191', SYSDATE) [26 Nov 2020 22:45:35] (viewOnlineReports) database connection response [26 Nov 2020 22:45:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428372' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Nov 2020 22:45:35] (viewOnlineReports) database connection response [26 Nov 2020 22:45:35] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 22:45:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428372/ [26 Nov 2020 22:45:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428372/ [26 Nov 2020 22:45:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201125\M01\M0100000534191_M01MIC20009288_1.PDF [26 Nov 2020 22:45:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428372/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1606412735M0100000534191_M01MIC20009288_1.PDF [26 Nov 2020 22:45:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428372/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1606412735M0100000534191_M01MIC20009288_1.PDF [26 Nov 2020 22:45:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Nov 2020 22:45:35] (viewOnlineReports) Downloading file ../../TEMP_PDF/200428372/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1606412735M0100000534191_M01MIC20009288_1.PDF [26 Nov 2020 22:52:22] (index) database connection response [26 Nov 2020 22:52:22] (index) getConnection(): Resource id #1 [26 Nov 2020 22:52:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'POP-UP' [26 Nov 2020 22:52:22] (index) database connection response [26 Nov 2020 22:52:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Nov 2020 22:52:22] (index) database connection response [26 Nov 2020 22:52:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '87' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Nov 2020 22:52:22] (index) database connection response [26 Nov 2020 22:52:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' [26 Nov 2020 22:52:23] (index) database connection response [26 Nov 2020 22:52:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200512007' AND ACCESS_CODE = '06952954' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Nov 2020 22:52:23] (index) database connection response [26 Nov 2020 22:52:23] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000472280' [26 Nov 2020 22:52:23] (index) database connection response [26 Nov 2020 22:52:23] (index) getPatientReportsDetail() entered [26 Nov 2020 22:52:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 22:52:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200512007', 'M0100000472280', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 22:52:23] (index) p_Stop=N [26 Nov 2020 22:52:23] (index) p_Alert= [26 Nov 2020 22:52: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 [26 Nov 2020 22:52:23] (index) database connection response [26 Nov 2020 22:52:23] (index) getConnectionClose() called.... [26 Nov 2020 22:52:23] (index) getConnectionClose() called.... [26 Nov 2020 22:52:40] (viewOnlineReports) database connection response [26 Nov 2020 22:52:40] (viewOnlineReports) getConnection(): Resource id #1 [26 Nov 2020 22:52:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000472280', '001', '200428758', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Nov 2020 22:52:40] (viewOnlineReports) p_Stop=N [26 Nov 2020 22:52:40] (viewOnlineReports) p_Alert= [26 Nov 2020 22:52:40] (viewOnlineReports) Flag = 1 [26 Nov 2020 22:52:40] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200428758', 'M01', '070', '1', '001000000000087630', 'M0100000472280_M01MOL20013748_1.PDF', 'M0100000472280', SYSDATE) [26 Nov 2020 22:52:40] (viewOnlineReports) database connection response [26 Nov 2020 22:52:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200428758' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Nov 2020 22:52:40] (viewOnlineReports) database connection response [26 Nov 2020 22:52:40] (viewOnlineReports) getConnectionClose() called.... [26 Nov 2020 22:52:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200428758/ [26 Nov 2020 22:52:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200428758/ [26 Nov 2020 22:52:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201126\M01\M0100000472280_M01MOL20013748_1.PDF [26 Nov 2020 22:52:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200428758/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1606413160M0100000472280_M01MOL20013748_1.PDF [26 Nov 2020 22:52:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200428758/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1606413160M0100000472280_M01MOL20013748_1.PDF [26 Nov 2020 22:52:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Nov 2020 22:52:40] (viewOnlineReports) Converting PDF to JPG with name as M0100000472280_M01MOL20013748_1.jpg [26 Nov 2020 22:52:40] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200428758/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1606413160M0100000472280_M01MOL20013748_1.PDF ../../TEMP_PDF/200428758/M0100000472280_M01MOL20013748_1.jpg [26 Nov 2020 22:52:40] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200428758/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1606413160M0100000472280_M01MOL20013748_1.PDF