[18 Sep 2020 00:07:49] (viewOnlineReports) database connection response [18 Sep 2020 00:07:49] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 00:07:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200386930', '1', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 00:07:49] (viewOnlineReports) p_Stop=N [18 Sep 2020 00:07:49] (viewOnlineReports) p_Alert= [18 Sep 2020 00:07:49] (viewOnlineReports) Flag = 1 [18 Sep 2020 00:07:49] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200386930', 'M01', '047', '1', '001000000000087100', 'M0100000449587_M01MIC20006996_1.PDF', '00100000000000', SYSDATE) [18 Sep 2020 00:07:49] (viewOnlineReports) database connection response [18 Sep 2020 00:07:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386930' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [18 Sep 2020 00:07:49] (viewOnlineReports) database connection response [18 Sep 2020 00:07:49] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 00:07:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386930/ [18 Sep 2020 00:07:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386930/ [18 Sep 2020 00:07:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200917\M01\M0100000449587_M01MIC20006996_1.PDF [18 Sep 2020 00:07:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386930/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZM0100000449587_M01MIC20006996_1.PDF [18 Sep 2020 00:07:49] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386930/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZM0100000449587_M01MIC20006996_1.PDF [18 Sep 2020 00:07:49] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [18 Sep 2020 00:07:49] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200386930/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZM0100000449587_M01MIC20006996_1.PDF [18 Sep 2020 02:07:47] (index) database connection response [18 Sep 2020 02:07:47] (index) getConnection(): Resource id #1 [18 Sep 2020 02:07:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 02:07:47] (index) database connection response [18 Sep 2020 02:07:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 02:07:47] (index) database connection response [18 Sep 2020 02:07:47] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 02:07:47] (index) database connection response [18 Sep 2020 02:07:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386480' AND ACCESS_CODE = '51248018' [18 Sep 2020 02:07:47] (index) database connection response [18 Sep 2020 02:07:47] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386480' AND ACCESS_CODE = '51248018' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 02:07:47] (index) database connection response [18 Sep 2020 02:07:47] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000059779' [18 Sep 2020 02:07:47] (index) database connection response [18 Sep 2020 02:07:47] (index) getPatientReportsDetail() entered [18 Sep 2020 02:07:47] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 02:07:47] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 02:07:47] (index) p_Stop=N [18 Sep 2020 02:07:47] (index) p_Alert= [18 Sep 2020 02:07:47] (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 [18 Sep 2020 02:07:47] (index) database connection response [18 Sep 2020 02:07:47] (index) getConnectionClose() called.... [18 Sep 2020 02:07:47] (index) getConnectionClose() called.... [18 Sep 2020 02:18:45] (index) database connection response [18 Sep 2020 02:18:45] (index) getConnection(): Resource id #1 [18 Sep 2020 02:18:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 02:18:45] (index) database connection response [18 Sep 2020 02:18:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 02:18:45] (index) database connection response [18 Sep 2020 02:18:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 02:18:45] (index) database connection response [18 Sep 2020 02:18:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 02:18:45] (index) database connection response [18 Sep 2020 02:18:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 02:18:45] (index) database connection response [18 Sep 2020 02:18:45] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 02:18:45] (index) database connection response [18 Sep 2020 02:18:45] (index) getPatientReportsDetail() entered [18 Sep 2020 02:18:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 02:18:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 02:18:45] (index) p_Stop=N [18 Sep 2020 02:18:45] (index) p_Alert= [18 Sep 2020 02:18:45] (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 [18 Sep 2020 02:18:45] (index) database connection response [18 Sep 2020 02:18:45] (index) getConnectionClose() called.... [18 Sep 2020 02:18:45] (index) getConnectionClose() called.... [18 Sep 2020 08:05:23] (index) database connection response [18 Sep 2020 08:05:23] (index) getConnection(): Resource id #1 [18 Sep 2020 08:05:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 08:05:23] (index) database connection response [18 Sep 2020 08:05:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 08:05:23] (index) database connection response [18 Sep 2020 08:05:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 08:05:23] (index) database connection response [18 Sep 2020 08:05:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386' AND ACCESS_CODE = '06212519' [18 Sep 2020 08:05:23] (index) database connection response [18 Sep 2020 08:05:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386' AND ACCESS_CODE = '06212519' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 08:05:23] (index) database connection response [18 Sep 2020 08:05:23] (index) getConnectionClose() called.... [18 Sep 2020 08:05:59] (index) database connection response [18 Sep 2020 08:05:59] (index) getConnection(): Resource id #1 [18 Sep 2020 08:05:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 08:05:59] (index) database connection response [18 Sep 2020 08:05:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 08:05:59] (index) database connection response [18 Sep 2020 08:05:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 08:05:59] (index) database connection response [18 Sep 2020 08:05:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386783' AND ACCESS_CODE = '06212519' [18 Sep 2020 08:05:59] (index) database connection response [18 Sep 2020 08:05:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386783' AND ACCESS_CODE = '06212519' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 08:05:59] (index) database connection response [18 Sep 2020 08:05:59] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000615417' [18 Sep 2020 08:05:59] (index) database connection response [18 Sep 2020 08:05:59] (index) getPatientReportsDetail() entered [18 Sep 2020 08:05:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386783', 'M0100000615417', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:05:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386783', 'M0100000615417', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:05:59] (index) p_Stop=N [18 Sep 2020 08:05:59] (index) p_Alert= [18 Sep 2020 08:05:59] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 08:05:59] (index) database connection response [18 Sep 2020 08:05:59] (index) getConnectionClose() called.... [18 Sep 2020 08:05:59] (index) getConnectionClose() called.... [18 Sep 2020 08:06:04] (viewOnlineReports) database connection response [18 Sep 2020 08:06:04] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 08:06:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000615417', '001', '200386851', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:06:04] (viewOnlineReports) p_Stop=N [18 Sep 2020 08:06:04] (viewOnlineReports) p_Alert= [18 Sep 2020 08:06:04] (viewOnlineReports) Flag = 1 [18 Sep 2020 08:06:04] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200386851', 'M01', '047', '1', '001000000000085025', 'M0100000615417_M01HEM20012832_1.PDF', 'M0100000615417', SYSDATE) [18 Sep 2020 08:06:04] (viewOnlineReports) database connection response [18 Sep 2020 08:06:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386851' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [18 Sep 2020 08:06:04] (viewOnlineReports) database connection response [18 Sep 2020 08:06:04] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 08:06:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386851/ [18 Sep 2020 08:06:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386851/ [18 Sep 2020 08:06:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200917\M01\M0100000615417_M01HEM20012832_1.PDF [18 Sep 2020 08:06:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386851/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1600398363M0100000615417_M01HEM20012832_1.PDF [18 Sep 2020 08:06:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386851/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1600398363M0100000615417_M01HEM20012832_1.PDF [18 Sep 2020 08:06:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [18 Sep 2020 08:06:04] (viewOnlineReports) Downloading file ../../TEMP_PDF/200386851/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1600398363M0100000615417_M01HEM20012832_1.PDF [18 Sep 2020 08:33:15] (index) database connection response [18 Sep 2020 08:33:15] (index) getConnection(): Resource id #1 [18 Sep 2020 08:33:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 08:33:15] (index) database connection response [18 Sep 2020 08:33:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 08:33:15] (index) database connection response [18 Sep 2020 08:33:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 08:33:15] (index) database connection response [18 Sep 2020 08:33:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200385287' AND ACCESS_CODE = '76845278' [18 Sep 2020 08:33:15] (index) database connection response [18 Sep 2020 08:33:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200385287' AND ACCESS_CODE = '76845278' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 08:33:15] (index) database connection response [18 Sep 2020 08:33:15] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000057226' [18 Sep 2020 08:33:15] (index) database connection response [18 Sep 2020 08:33:15] (index) getPatientReportsDetail() entered [18 Sep 2020 08:33:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200385287', 'M0100000057226', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:33:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200385287', 'M0100000057226', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:33:15] (index) p_Stop=N [18 Sep 2020 08:33:15] (index) p_Alert= [18 Sep 2020 08:33: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 [18 Sep 2020 08:33:15] (index) database connection response [18 Sep 2020 08:33:15] (index) getConnectionClose() called.... [18 Sep 2020 08:33:15] (index) getConnectionClose() called.... [18 Sep 2020 08:33:23] (viewOnlineReports) database connection response [18 Sep 2020 08:33:23] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 08:33:23] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000057226', '001', '200386434', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:33:23] (viewOnlineReports) p_Stop=N [18 Sep 2020 08:33:23] (viewOnlineReports) p_Alert= [18 Sep 2020 08:33:23] (viewOnlineReports) Flag = 1 [18 Sep 2020 08:33:23] (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', '200386434', 'M01', '047', '1', '001000000000085025', 'M0100000057226_M01HEM20012766_1.PDF', 'M0100000057226', SYSDATE) [18 Sep 2020 08:33:23] (viewOnlineReports) database connection response [18 Sep 2020 08:33:23] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386434' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [18 Sep 2020 08:33:23] (viewOnlineReports) database connection response [18 Sep 2020 08:33:23] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 08:33:23] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386434/ [18 Sep 2020 08:33:23] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386434/ [18 Sep 2020 08:33:23] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200917\M01\M0100000057226_M01HEM20012766_1.PDF [18 Sep 2020 08:33:23] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386434/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1600400003M0100000057226_M01HEM20012766_1.PDF [18 Sep 2020 08:33:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386434/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1600400003M0100000057226_M01HEM20012766_1.PDF [18 Sep 2020 08:33:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [18 Sep 2020 08:33:23] (viewOnlineReports) Downloading file ../../TEMP_PDF/200386434/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1600400003M0100000057226_M01HEM20012766_1.PDF [18 Sep 2020 08:34:57] (viewOnlineReports) database connection response [18 Sep 2020 08:34:57] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 08:34:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000057226', '001', '200386434', '2', '001000000000084550', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:34:57] (viewOnlineReports) p_Stop=N [18 Sep 2020 08:34:57] (viewOnlineReports) p_Alert= [18 Sep 2020 08:34:57] (viewOnlineReports) Flag = 1 [18 Sep 2020 08:34: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', '200386434', 'M01', '047', '2', '001000000000084550', 'M0100000057226_M01RCH20017248_2.PDF', 'M0100000057226', SYSDATE) [18 Sep 2020 08:34:57] (viewOnlineReports) database connection response [18 Sep 2020 08:34:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386434' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [18 Sep 2020 08:34:57] (viewOnlineReports) database connection response [18 Sep 2020 08:34:57] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 08:34:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386434/ [18 Sep 2020 08:34:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386434/ [18 Sep 2020 08:34:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200916\M01\M0100000057226_M01RCH20017248_2.PDF [18 Sep 2020 08:34:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386434/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1600400097M0100000057226_M01RCH20017248_2.PDF [18 Sep 2020 08:34:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386434/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1600400097M0100000057226_M01RCH20017248_2.PDF [18 Sep 2020 08:34:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [18 Sep 2020 08:34:57] (viewOnlineReports) Downloading file ../../TEMP_PDF/200386434/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1600400097M0100000057226_M01RCH20017248_2.PDF [18 Sep 2020 08:35:21] (viewOnlineReports) database connection response [18 Sep 2020 08:35:21] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 08:35:21] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000057226', '001', '200386434', '3', '001000000000080061', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:35:21] (viewOnlineReports) p_Stop=N [18 Sep 2020 08:35:21] (viewOnlineReports) p_Alert= [18 Sep 2020 08:35:21] (viewOnlineReports) Flag = 1 [18 Sep 2020 08:35:21] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200386434', 'M01', '047', '3', '001000000000080061', 'M0100000057226_M01RCH20017248_1.PDF', 'M0100000057226', SYSDATE) [18 Sep 2020 08:35:21] (viewOnlineReports) database connection response [18 Sep 2020 08:35:21] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386434' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [18 Sep 2020 08:35:21] (viewOnlineReports) database connection response [18 Sep 2020 08:35:21] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 08:35:21] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386434/ [18 Sep 2020 08:35:21] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386434/ [18 Sep 2020 08:35:21] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200916\M01\M0100000057226_M01RCH20017248_1.PDF [18 Sep 2020 08:35:21] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386434/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600400121M0100000057226_M01RCH20017248_1.PDF [18 Sep 2020 08:35:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386434/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600400121M0100000057226_M01RCH20017248_1.PDF [18 Sep 2020 08:35:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [18 Sep 2020 08:35:21] (viewOnlineReports) Downloading file ../../TEMP_PDF/200386434/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600400121M0100000057226_M01RCH20017248_1.PDF [18 Sep 2020 08:38:10] (index) database connection response [18 Sep 2020 08:38:10] (index) getConnection(): Resource id #1 [18 Sep 2020 08:38:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 08:38:10] (index) database connection response [18 Sep 2020 08:38:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 08:38:10] (index) database connection response [18 Sep 2020 08:38:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 08:38:10] (index) database connection response [18 Sep 2020 08:38:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386480' AND ACCESS_CODE = '51248018' [18 Sep 2020 08:38:10] (index) database connection response [18 Sep 2020 08:38:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386480' AND ACCESS_CODE = '51248018' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 08:38:11] (index) database connection response [18 Sep 2020 08:38:11] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000059779' [18 Sep 2020 08:38:11] (index) database connection response [18 Sep 2020 08:38:11] (index) getPatientReportsDetail() entered [18 Sep 2020 08:38:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:38:11] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 08:38:11] (index) p_Stop=N [18 Sep 2020 08:38:11] (index) p_Alert= [18 Sep 2020 08:38: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 [18 Sep 2020 08:38:11] (index) database connection response [18 Sep 2020 08:38:11] (index) getConnectionClose() called.... [18 Sep 2020 08:38:11] (index) getConnectionClose() called.... [18 Sep 2020 10:39:11] (index) database connection response [18 Sep 2020 10:39:11] (index) getConnection(): Resource id #1 [18 Sep 2020 10:39:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 10:39:11] (index) database connection response [18 Sep 2020 10:39:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 10:39:11] (index) database connection response [18 Sep 2020 10:39:11] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 10:39:11] (index) database connection response [18 Sep 2020 10: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 = 'M01200386480' AND ACCESS_CODE = '51248018' [18 Sep 2020 10:39:11] (index) database connection response [18 Sep 2020 10: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 = 'M01200386480' AND ACCESS_CODE = '51248018' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 10:39:12] (index) database connection response [18 Sep 2020 10:39:12] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000059779' [18 Sep 2020 10:39:12] (index) database connection response [18 Sep 2020 10:39:12] (index) getPatientReportsDetail() entered [18 Sep 2020 10:39:12] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 10:39:12] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 10:39:12] (index) p_Stop=N [18 Sep 2020 10:39:12] (index) p_Alert= [18 Sep 2020 10:39:12] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 10:39:12] (index) database connection response [18 Sep 2020 10:39:12] (index) getConnectionClose() called.... [18 Sep 2020 10:39:12] (index) getConnectionClose() called.... [18 Sep 2020 12:22:59] (index) database connection response [18 Sep 2020 12:22:59] (index) getConnection(): Resource id #1 [18 Sep 2020 12:22:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 12:22:59] (index) database connection response [18 Sep 2020 12:22:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 12:22:59] (index) database connection response [18 Sep 2020 12:22:59] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 12:22:59] (index) database connection response [18 Sep 2020 12:22:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 12:22:59] (index) database connection response [18 Sep 2020 12:22:59] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 12:22:59] (index) database connection response [18 Sep 2020 12:22:59] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 12:22:59] (index) database connection response [18 Sep 2020 12:22:59] (index) getPatientReportsDetail() entered [18 Sep 2020 12:22:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:22:59] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:22:59] (index) p_Stop=N [18 Sep 2020 12:22:59] (index) p_Alert= [18 Sep 2020 12:22:59] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 12:22:59] (index) database connection response [18 Sep 2020 12:22:59] (index) getConnectionClose() called.... [18 Sep 2020 12:22:59] (index) getConnectionClose() called.... [18 Sep 2020 12:36:40] (index) database connection response [18 Sep 2020 12:36:40] (index) getConnection(): Resource id #1 [18 Sep 2020 12:36:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 12:36:40] (index) database connection response [18 Sep 2020 12:36:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 12:36:40] (index) database connection response [18 Sep 2020 12:36:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 12:36:40] (index) database connection response [18 Sep 2020 12:36:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200385575' AND ACCESS_CODE = '41779623' [18 Sep 2020 12:36:41] (index) database connection response [18 Sep 2020 12:36:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200385575' AND ACCESS_CODE = '41779623' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 12:36:41] (index) database connection response [18 Sep 2020 12:36:41] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000632277' [18 Sep 2020 12:36:41] (index) database connection response [18 Sep 2020 12:36:41] (index) getPatientReportsDetail() entered [18 Sep 2020 12:36:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200385575', 'M0100000632277', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:36:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200385575', 'M0100000632277', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:36:41] (index) p_Stop=N [18 Sep 2020 12:36:41] (index) p_Alert= [18 Sep 2020 12:36:41] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 12:36:41] (index) database connection response [18 Sep 2020 12:36:41] (index) getConnectionClose() called.... [18 Sep 2020 12:36:41] (index) getConnectionClose() called.... [18 Sep 2020 12:37:25] (viewOnlineReports) database connection response [18 Sep 2020 12:37:25] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 12:37:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632277', '001', '200386546', '2', '001000000000082263', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:37:25] (viewOnlineReports) p_Stop=N [18 Sep 2020 12:37:25] (viewOnlineReports) p_Alert= [18 Sep 2020 12:37:25] (viewOnlineReports) Flag = 1 [18 Sep 2020 12:37:25] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200386546', 'M01', '047', '2', '001000000000082263', 'M0100000632277_M01MIC20007005_1.PDF', 'M0100000632277', SYSDATE) [18 Sep 2020 12:37:25] (viewOnlineReports) database connection response [18 Sep 2020 12:37:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386546' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [18 Sep 2020 12:37:25] (viewOnlineReports) database connection response [18 Sep 2020 12:37:25] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 12:37:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386546/ [18 Sep 2020 12:37:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386546/ [18 Sep 2020 12:37:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200917\M01\M0100000632277_M01MIC20007005_1.PDF [18 Sep 2020 12:37:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386546/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1600414645M0100000632277_M01MIC20007005_1.PDF [18 Sep 2020 12:37:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386546/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1600414645M0100000632277_M01MIC20007005_1.PDF [18 Sep 2020 12:37:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [18 Sep 2020 12:37:25] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200386546/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1600414645M0100000632277_M01MIC20007005_1.PDF [18 Sep 2020 12:37:36] (viewOnlineReports) database connection response [18 Sep 2020 12:37:36] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 12:37:36] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632277', '001', '200386546', '2', '001000000000082263', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:37:36] (viewOnlineReports) p_Stop=N [18 Sep 2020 12:37:36] (viewOnlineReports) p_Alert= [18 Sep 2020 12:37:36] (viewOnlineReports) Flag = 1 [18 Sep 2020 12:37:36] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200386546', 'M01', '047', '2', '001000000000082263', 'M0100000632277_M01MIC20007005_1.PDF', 'M0100000632277', SYSDATE) [18 Sep 2020 12:37:36] (viewOnlineReports) database connection response [18 Sep 2020 12:37:36] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386546' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [18 Sep 2020 12:37:36] (viewOnlineReports) database connection response [18 Sep 2020 12:37:36] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 12:37:36] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386546/ [18 Sep 2020 12:37:36] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386546/ [18 Sep 2020 12:37:36] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200917\M01\M0100000632277_M01MIC20007005_1.PDF [18 Sep 2020 12:37:36] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386546/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1600414656M0100000632277_M01MIC20007005_1.PDF [18 Sep 2020 12:37:36] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386546/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1600414656M0100000632277_M01MIC20007005_1.PDF [18 Sep 2020 12:37:36] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [18 Sep 2020 12:37:36] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200386546/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1600414656M0100000632277_M01MIC20007005_1.PDF [18 Sep 2020 12:50:20] (index) database connection response [18 Sep 2020 12:50:20] (index) getConnection(): Resource id #1 [18 Sep 2020 12:50:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 12:50:20] (index) database connection response [18 Sep 2020 12:50:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 12:50:20] (index) database connection response [18 Sep 2020 12:50:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 12:50:20] (index) database connection response [18 Sep 2020 12:50:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386480' AND ACCESS_CODE = '51248018' [18 Sep 2020 12:50:20] (index) database connection response [18 Sep 2020 12:50:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386480' AND ACCESS_CODE = '51248018' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 12:50:20] (index) database connection response [18 Sep 2020 12:50:20] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000059779' [18 Sep 2020 12:50:20] (index) database connection response [18 Sep 2020 12:50:20] (index) getPatientReportsDetail() entered [18 Sep 2020 12:50:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:50:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:50:20] (index) p_Stop=N [18 Sep 2020 12:50:20] (index) p_Alert= [18 Sep 2020 12:50: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 [18 Sep 2020 12:50:20] (index) database connection response [18 Sep 2020 12:50:20] (index) getConnectionClose() called.... [18 Sep 2020 12:50:20] (index) getConnectionClose() called.... [18 Sep 2020 12:55:06] (index) database connection response [18 Sep 2020 12:55:06] (index) getConnection(): Resource id #1 [18 Sep 2020 12:55:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 12:55:06] (index) database connection response [18 Sep 2020 12:55:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 12:55:06] (index) database connection response [18 Sep 2020 12:55:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 12:55:06] (index) database connection response [18 Sep 2020 12:55:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 12:55:06] (index) database connection response [18 Sep 2020 12:55:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 12:55:06] (index) database connection response [18 Sep 2020 12:55:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 12:55:06] (index) database connection response [18 Sep 2020 12:55:06] (index) getPatientReportsDetail() entered [18 Sep 2020 12:55:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:55:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 12:55:06] (index) p_Stop=N [18 Sep 2020 12:55:06] (index) p_Alert= [18 Sep 2020 12:55: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 [18 Sep 2020 12:55:06] (index) database connection response [18 Sep 2020 12:55:06] (index) getConnectionClose() called.... [18 Sep 2020 12:55:06] (index) getConnectionClose() called.... [18 Sep 2020 13:41:18] (index) database connection response [18 Sep 2020 13:41:18] (index) getConnection(): Resource id #1 [18 Sep 2020 13:41:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 13:41:18] (index) database connection response [18 Sep 2020 13:41:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 13:41:18] (index) database connection response [18 Sep 2020 13:41:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 13:41:18] (index) database connection response [18 Sep 2020 13:41:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M1200387144' AND ACCESS_CODE = '57907644' [18 Sep 2020 13:41:19] (index) database connection response [18 Sep 2020 13:41:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M1200387144' AND ACCESS_CODE = '57907644' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 13:41:19] (index) database connection response [18 Sep 2020 13:41:19] (index) getConnectionClose() called.... [18 Sep 2020 13:42:13] (index) database connection response [18 Sep 2020 13:42:13] (index) getConnection(): Resource id #1 [18 Sep 2020 13:42:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 13:42:13] (index) database connection response [18 Sep 2020 13:42:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 13:42:13] (index) database connection response [18 Sep 2020 13:42:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 13:42:13] (index) database connection response [18 Sep 2020 13:42:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200387144' AND ACCESS_CODE = '57907644' [18 Sep 2020 13:42:13] (index) database connection response [18 Sep 2020 13:42:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200387144' AND ACCESS_CODE = '57907644' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 13:42:13] (index) database connection response [18 Sep 2020 13:42:13] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000627886' [18 Sep 2020 13:42:13] (index) database connection response [18 Sep 2020 13:42:13] (index) getPatientReportsDetail() entered [18 Sep 2020 13:42:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200387144', 'M0100000627886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 13:42:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200387144', 'M0100000627886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 13:42:13] (index) p_Stop=N [18 Sep 2020 13:42:13] (index) p_Alert= [18 Sep 2020 13: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 [18 Sep 2020 13:42:13] (index) database connection response [18 Sep 2020 13:42:13] (index) getConnectionClose() called.... [18 Sep 2020 13:42:13] (index) getConnectionClose() called.... [18 Sep 2020 13:42:34] (viewOnlineReports) database connection response [18 Sep 2020 13:42:34] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 13:42:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000627886', '001', '200386936', '1', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 13:42:35] (viewOnlineReports) p_Stop=N [18 Sep 2020 13:42:35] (viewOnlineReports) p_Alert= [18 Sep 2020 13:42:35] (viewOnlineReports) Flag = 1 [18 Sep 2020 13:42: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', '200386936', 'M01', '047', '1', '001000000000087100', 'M0100000627886_M01MIC20006997_2.PDF', 'M0100000627886', SYSDATE) [18 Sep 2020 13:42:35] (viewOnlineReports) database connection response [18 Sep 2020 13:42:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386936' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [18 Sep 2020 13:42:35] (viewOnlineReports) database connection response [18 Sep 2020 13:42:35] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 13:42:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386936/ [18 Sep 2020 13:42:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386936/ [18 Sep 2020 13:42:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200917\M01\M0100000627886_M01MIC20006997_2.PDF [18 Sep 2020 13:42:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386936/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1600418554M0100000627886_M01MIC20006997_2.PDF [18 Sep 2020 13:42:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386936/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1600418554M0100000627886_M01MIC20006997_2.PDF [18 Sep 2020 13:42:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [18 Sep 2020 13:42:35] (viewOnlineReports) Converting PDF to JPG with name as M0100000627886_M01MIC20006997_2.jpg [18 Sep 2020 13:42:35] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200386936/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1600418554M0100000627886_M01MIC20006997_2.PDF ../../TEMP_PDF/200386936/M0100000627886_M01MIC20006997_2.jpg [18 Sep 2020 13:42:35] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200386936/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1600418554M0100000627886_M01MIC20006997_2.PDF [18 Sep 2020 13:43:52] (viewOnlineReports) database connection response [18 Sep 2020 13:43:52] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 13:43:52] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000627886', '001', '200386936', '1', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 13:43:52] (viewOnlineReports) p_Stop=N [18 Sep 2020 13:43:52] (viewOnlineReports) p_Alert= [18 Sep 2020 13:43:52] (viewOnlineReports) Flag = 1 [18 Sep 2020 13:43:52] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200386936', 'M01', '047', '1', '001000000000087100', 'M0100000627886_M01MIC20006997_2.PDF', 'M0100000627886', SYSDATE) [18 Sep 2020 13:43:52] (viewOnlineReports) database connection response [18 Sep 2020 13:43:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200386936' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [18 Sep 2020 13:43:52] (viewOnlineReports) database connection response [18 Sep 2020 13:43:52] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 13:43:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200386936/ [18 Sep 2020 13:43:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200386936/ [18 Sep 2020 13:43:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200917\M01\M0100000627886_M01MIC20006997_2.PDF [18 Sep 2020 13:43:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200386936/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600418632M0100000627886_M01MIC20006997_2.PDF [18 Sep 2020 13:43:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200386936/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600418632M0100000627886_M01MIC20006997_2.PDF [18 Sep 2020 13:43:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [18 Sep 2020 13:43:52] (viewOnlineReports) Downloading file ../../TEMP_PDF/200386936/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600418632M0100000627886_M01MIC20006997_2.PDF [18 Sep 2020 14:36:55] (index) database connection response [18 Sep 2020 14:36:55] (index) getConnection(): Resource id #1 [18 Sep 2020 14:36:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 14:36:55] (index) database connection response [18 Sep 2020 14:36:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 14:36:55] (index) database connection response [18 Sep 2020 14:36:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 14:36:55] (index) database connection response [18 Sep 2020 14:36:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386480' AND ACCESS_CODE = '51248018' [18 Sep 2020 14:36:55] (index) database connection response [18 Sep 2020 14:36:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200386480' AND ACCESS_CODE = '51248018' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 14:36:55] (index) database connection response [18 Sep 2020 14:36:55] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000059779' [18 Sep 2020 14:36:55] (index) database connection response [18 Sep 2020 14:36:55] (index) getPatientReportsDetail() entered [18 Sep 2020 14:36:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 14:36:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200386480', 'M0100000059779', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 14:36:55] (index) p_Stop=N [18 Sep 2020 14:36:55] (index) p_Alert= [18 Sep 2020 14:36:55] (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 [18 Sep 2020 14:36:55] (index) database connection response [18 Sep 2020 14:36:55] (index) getConnectionClose() called.... [18 Sep 2020 14:36:55] (index) getConnectionClose() called.... [18 Sep 2020 14:38:43] (index) database connection response [18 Sep 2020 14:38:43] (index) getConnection(): Resource id #1 [18 Sep 2020 14:38:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 14:38:43] (index) database connection response [18 Sep 2020 14:38:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 14:38:43] (index) database connection response [18 Sep 2020 14:38:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 14:38:43] (index) database connection response [18 Sep 2020 14:38:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 14:38:43] (index) database connection response [18 Sep 2020 14:38:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 14:38:43] (index) database connection response [18 Sep 2020 14:38:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 14:38:43] (index) database connection response [18 Sep 2020 14:38:43] (index) getPatientReportsDetail() entered [18 Sep 2020 14:38:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 14:38:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 14:38:43] (index) p_Stop=N [18 Sep 2020 14:38:43] (index) p_Alert= [18 Sep 2020 14:38: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 [18 Sep 2020 14:38:43] (index) database connection response [18 Sep 2020 14:38:43] (index) getConnectionClose() called.... [18 Sep 2020 14:38:43] (index) getConnectionClose() called.... [18 Sep 2020 15:09:57] (index) database connection response [18 Sep 2020 15:09:57] (index) getConnection(): Resource id #2 [18 Sep 2020 15:09:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 15:09:57] (index) database connection response [18 Sep 2020 15:09:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 15:09:57] (index) database connection response [18 Sep 2020 15:09:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 15:09:57] (index) database connection response [18 Sep 2020 15:09:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 15:09:57] (index) database connection response [18 Sep 2020 15:09:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 15:09:57] (index) database connection response [18 Sep 2020 15:09:57] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 15:09:57] (index) database connection response [18 Sep 2020 15:09:57] (index) getPatientReportsDetail() entered [18 Sep 2020 15:09:57] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:09:57] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:09:57] (index) p_Stop=N [18 Sep 2020 15:09:57] (index) p_Alert= [18 Sep 2020 15:09:57] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 15:09:57] (index) database connection response [18 Sep 2020 15:09:57] (index) getConnectionClose() called.... [18 Sep 2020 15:09:57] (index) getConnectionClose() called.... [18 Sep 2020 15:23:52] (index) database connection response [18 Sep 2020 15:23:52] (index) getConnection(): Resource id #1 [18 Sep 2020 15:23:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 15:23:52] (index) database connection response [18 Sep 2020 15:23:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 15:23:52] (index) database connection response [18 Sep 2020 15:23:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 15:23:52] (index) database connection response [18 Sep 2020 15:23:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M1200387144' AND ACCESS_CODE = '57907644' [18 Sep 2020 15:23:52] (index) database connection response [18 Sep 2020 15:23:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M1200387144' AND ACCESS_CODE = '57907644' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 15:23:52] (index) database connection response [18 Sep 2020 15:23:52] (index) getConnectionClose() called.... [18 Sep 2020 15:24:36] (index) database connection response [18 Sep 2020 15:24:36] (index) getConnection(): Resource id #1 [18 Sep 2020 15:24:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 15:24:36] (index) database connection response [18 Sep 2020 15:24:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 15:24:36] (index) database connection response [18 Sep 2020 15:24:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 15:24:36] (index) database connection response [18 Sep 2020 15:24:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200387144' AND ACCESS_CODE = '57907644' [18 Sep 2020 15:24:36] (index) database connection response [18 Sep 2020 15:24:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200387144' AND ACCESS_CODE = '57907644' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 15:24:36] (index) database connection response [18 Sep 2020 15:24:36] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000627886' [18 Sep 2020 15:24:36] (index) database connection response [18 Sep 2020 15:24:36] (index) getPatientReportsDetail() entered [18 Sep 2020 15:24:36] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200387144', 'M0100000627886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:24:36] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200387144', 'M0100000627886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:24:36] (index) p_Stop=N [18 Sep 2020 15:24:36] (index) p_Alert= [18 Sep 2020 15:24:36] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 15:24:36] (index) database connection response [18 Sep 2020 15:24:36] (index) getConnectionClose() called.... [18 Sep 2020 15:24:36] (index) getConnectionClose() called.... [18 Sep 2020 15:49:20] (index) database connection response [18 Sep 2020 15:49:20] (index) getConnection(): Resource id #1 [18 Sep 2020 15:49:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '44' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 15:49:20] (index) database connection response [18 Sep 2020 15:49:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '44' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 15:49:20] (index) database connection response [18 Sep 2020 15:49:20] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '44' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 15:49:20] (index) database connection response [18 Sep 2020 15:49:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200388206' AND ACCESS_CODE = '70917322' [18 Sep 2020 15:49:20] (index) database connection response [18 Sep 2020 15:49:20] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200388206' AND ACCESS_CODE = '70917322' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 15:49:20] (index) database connection response [18 Sep 2020 15:49:20] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000633556' [18 Sep 2020 15:49:20] (index) database connection response [18 Sep 2020 15:49:20] (index) getPatientReportsDetail() entered [18 Sep 2020 15:49:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200388206', 'M0100000633556', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:49:20] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200388206', 'M0100000633556', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:49:20] (index) p_Stop=N [18 Sep 2020 15:49:20] (index) p_Alert= [18 Sep 2020 15:49: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 [18 Sep 2020 15:49:20] (index) database connection response [18 Sep 2020 15:49:20] (index) getConnectionClose() called.... [18 Sep 2020 15:49:20] (index) getConnectionClose() called.... [18 Sep 2020 15:50:43] (viewOnlineReports) database connection response [18 Sep 2020 15:50:43] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 15:50:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000633556', '001', '200387231', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:50:43] (viewOnlineReports) p_Stop=N [18 Sep 2020 15:50:43] (viewOnlineReports) p_Alert= [18 Sep 2020 15:50:43] (viewOnlineReports) Flag = 1 [18 Sep 2020 15:50: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', '200387231', 'M01', '070', '1', '001000000000087630', 'M0100000633556_M01MOL20007837_1.PDF', 'M0100000633556', SYSDATE) [18 Sep 2020 15:50:43] (viewOnlineReports) database connection response [18 Sep 2020 15:50:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200387231' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [18 Sep 2020 15:50:44] (viewOnlineReports) database connection response [18 Sep 2020 15:50:44] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 15:50:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200387231/ [18 Sep 2020 15:50:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200387231/ [18 Sep 2020 15:50:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200918\M01\M0100000633556_M01MOL20007837_1.PDF [18 Sep 2020 15:50:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200387231/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1600426243M0100000633556_M01MOL20007837_1.PDF [18 Sep 2020 15:50:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200387231/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1600426243M0100000633556_M01MOL20007837_1.PDF [18 Sep 2020 15:50:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [18 Sep 2020 15:50:44] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200387231/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1600426243M0100000633556_M01MOL20007837_1.PDF [18 Sep 2020 15:52:24] (viewOnlineReports) database connection response [18 Sep 2020 15:52:24] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 15:52:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000633556', '001', '200387231', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:52:24] (viewOnlineReports) p_Stop=N [18 Sep 2020 15:52:24] (viewOnlineReports) p_Alert= [18 Sep 2020 15:52:24] (viewOnlineReports) Flag = 1 [18 Sep 2020 15:52: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', '200387231', 'M01', '070', '1', '001000000000087630', 'M0100000633556_M01MOL20007837_1.PDF', 'M0100000633556', SYSDATE) [18 Sep 2020 15:52:24] (viewOnlineReports) database connection response [18 Sep 2020 15:52:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200387231' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [18 Sep 2020 15:52:24] (viewOnlineReports) database connection response [18 Sep 2020 15:52:24] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 15:52:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200387231/ [18 Sep 2020 15:52:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200387231/ [18 Sep 2020 15:52:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200918\M01\M0100000633556_M01MOL20007837_1.PDF [18 Sep 2020 15:52:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200387231/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1600426344M0100000633556_M01MOL20007837_1.PDF [18 Sep 2020 15:52:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200387231/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1600426344M0100000633556_M01MOL20007837_1.PDF [18 Sep 2020 15:52:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [18 Sep 2020 15:52:24] (viewOnlineReports) Downloading file ../../TEMP_PDF/200387231/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1600426344M0100000633556_M01MOL20007837_1.PDF [18 Sep 2020 15:54:41] (index) database connection response [18 Sep 2020 15:54:41] (index) getConnection(): Resource id #1 [18 Sep 2020 15:54:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '44' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 15:54:41] (index) database connection response [18 Sep 2020 15:54:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '44' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 15:54:41] (index) database connection response [18 Sep 2020 15:54:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '44' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 15:54:41] (index) database connection response [18 Sep 2020 15:54:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200388215' AND ACCESS_CODE = '18751887' [18 Sep 2020 15:54:42] (index) database connection response [18 Sep 2020 15:54:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200388215' AND ACCESS_CODE = '18751887' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 15:54:42] (index) database connection response [18 Sep 2020 15:54:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000633557' [18 Sep 2020 15:54:42] (index) database connection response [18 Sep 2020 15:54:42] (index) getPatientReportsDetail() entered [18 Sep 2020 15:54:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200388215', 'M0100000633557', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:54:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200388215', 'M0100000633557', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:54:42] (index) p_Stop=N [18 Sep 2020 15:54:42] (index) p_Alert= [18 Sep 2020 15:54:42] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 15:54:42] (index) database connection response [18 Sep 2020 15:54:42] (index) getConnectionClose() called.... [18 Sep 2020 15:54:42] (index) getConnectionClose() called.... [18 Sep 2020 15:54:43] (index) database connection response [18 Sep 2020 15:54:43] (index) getConnection(): Resource id #1 [18 Sep 2020 15:54:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 15:54:43] (index) database connection response [18 Sep 2020 15:54:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 15:54:43] (index) database connection response [18 Sep 2020 15:54:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 15:54:43] (index) database connection response [18 Sep 2020 15:54:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 15:54:43] (index) database connection response [18 Sep 2020 15:54:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 15:54:43] (index) database connection response [18 Sep 2020 15:54:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 15:54:43] (index) database connection response [18 Sep 2020 15:54:43] (index) getPatientReportsDetail() entered [18 Sep 2020 15:54:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:54:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:54:43] (index) p_Stop=N [18 Sep 2020 15:54:43] (index) p_Alert= [18 Sep 2020 15:54:43] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 15:54:43] (index) database connection response [18 Sep 2020 15:54:43] (index) getConnectionClose() called.... [18 Sep 2020 15:54:43] (index) getConnectionClose() called.... [18 Sep 2020 15:54:51] (viewOnlineReports) database connection response [18 Sep 2020 15:54:51] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 15:54:51] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000633557', '001', '200387232', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:54:51] (viewOnlineReports) p_Stop=N [18 Sep 2020 15:54:51] (viewOnlineReports) p_Alert= [18 Sep 2020 15:54:51] (viewOnlineReports) Flag = 1 [18 Sep 2020 15:54:51] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200387232', 'M01', '070', '1', '001000000000087630', 'M0100000633557_M01MOL20007836_1.PDF', 'M0100000633557', SYSDATE) [18 Sep 2020 15:54:52] (viewOnlineReports) database connection response [18 Sep 2020 15:54:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200387232' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [18 Sep 2020 15:54:52] (viewOnlineReports) database connection response [18 Sep 2020 15:54:52] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 15:54:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200387232/ [18 Sep 2020 15:54:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200387232/ [18 Sep 2020 15:54:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200918\M01\M0100000633557_M01MOL20007836_1.PDF [18 Sep 2020 15:54:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200387232/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1600426491M0100000633557_M01MOL20007836_1.PDF [18 Sep 2020 15:54:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200387232/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1600426491M0100000633557_M01MOL20007836_1.PDF [18 Sep 2020 15:54:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [18 Sep 2020 15:54:52] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200387232/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1600426491M0100000633557_M01MOL20007836_1.PDF [18 Sep 2020 15:55:15] (viewOnlineReports) database connection response [18 Sep 2020 15:55:15] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 15:55:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000633557', '001', '200387232', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 15:55:15] (viewOnlineReports) p_Stop=N [18 Sep 2020 15:55:15] (viewOnlineReports) p_Alert= [18 Sep 2020 15:55:15] (viewOnlineReports) Flag = 1 [18 Sep 2020 15:55:15] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200387232', 'M01', '070', '1', '001000000000087630', 'M0100000633557_M01MOL20007836_1.PDF', 'M0100000633557', SYSDATE) [18 Sep 2020 15:55:15] (viewOnlineReports) database connection response [18 Sep 2020 15:55:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200387232' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [18 Sep 2020 15:55:15] (viewOnlineReports) database connection response [18 Sep 2020 15:55:15] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 15:55:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200387232/ [18 Sep 2020 15:55:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200387232/ [18 Sep 2020 15:55:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200918\M01\M0100000633557_M01MOL20007836_1.PDF [18 Sep 2020 15:55:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200387232/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600426515M0100000633557_M01MOL20007836_1.PDF [18 Sep 2020 15:55:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200387232/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600426515M0100000633557_M01MOL20007836_1.PDF [18 Sep 2020 15:55:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [18 Sep 2020 15:55:16] (viewOnlineReports) Downloading file ../../TEMP_PDF/200387232/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600426515M0100000633557_M01MOL20007836_1.PDF [18 Sep 2020 16:47:25] (index) database connection response [18 Sep 2020 16:47:25] (index) getConnection(): Resource id #1 [18 Sep 2020 16:47:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 16:47:25] (index) database connection response [18 Sep 2020 16:47:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 16:47:25] (index) database connection response [18 Sep 2020 16:47:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 16:47:25] (index) database connection response [18 Sep 2020 16:47:25] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 16:47:25] (index) database connection response [18 Sep 2020 16:47:25] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 16:47:25] (index) database connection response [18 Sep 2020 16:47:25] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 16:47:25] (index) database connection response [18 Sep 2020 16:47:25] (index) getPatientReportsDetail() entered [18 Sep 2020 16:47:25] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 16:47:25] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 16:47:25] (index) p_Stop=N [18 Sep 2020 16:47:25] (index) p_Alert= [18 Sep 2020 16:47:25] (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 [18 Sep 2020 16:47:25] (index) database connection response [18 Sep 2020 16:47:25] (index) getConnectionClose() called.... [18 Sep 2020 16:47:25] (index) getConnectionClose() called.... [18 Sep 2020 17:32:38] (index) database connection response [18 Sep 2020 17:32:38] (index) getConnection(): Resource id #1 [18 Sep 2020 17:32:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 17:32:38] (index) database connection response [18 Sep 2020 17:32:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 17:32:38] (index) database connection response [18 Sep 2020 17:32:38] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 17:32:38] (index) database connection response [18 Sep 2020 17:32:38] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 17:32:38] (index) database connection response [18 Sep 2020 17:32:38] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 17:32:38] (index) database connection response [18 Sep 2020 17:32:38] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 17:32:38] (index) database connection response [18 Sep 2020 17:32:38] (index) getPatientReportsDetail() entered [18 Sep 2020 17:32:38] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 17:32:38] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 17:32:38] (index) p_Stop=N [18 Sep 2020 17:32:38] (index) p_Alert= [18 Sep 2020 17:32:38] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 17:32:38] (index) database connection response [18 Sep 2020 17:32:38] (index) getConnectionClose() called.... [18 Sep 2020 17:32:38] (index) getConnectionClose() called.... [18 Sep 2020 18:17:43] (index) database connection response [18 Sep 2020 18:17:43] (index) getConnection(): Resource id #1 [18 Sep 2020 18:17:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 18:17:43] (index) database connection response [18 Sep 2020 18:17:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 18:17:43] (index) database connection response [18 Sep 2020 18:17:43] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 18:17:43] (index) database connection response [18 Sep 2020 18:17:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200387144' AND ACCESS_CODE = '57907644' [18 Sep 2020 18:17:43] (index) database connection response [18 Sep 2020 18:17:43] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200387144' AND ACCESS_CODE = '57907644' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 18:17:43] (index) database connection response [18 Sep 2020 18:17:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000627886' [18 Sep 2020 18:17:43] (index) database connection response [18 Sep 2020 18:17:43] (index) getPatientReportsDetail() entered [18 Sep 2020 18:17:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200387144', 'M0100000627886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 18:17:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200387144', 'M0100000627886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 18:17:43] (index) p_Stop=N [18 Sep 2020 18:17:43] (index) p_Alert= [18 Sep 2020 18:17: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 [18 Sep 2020 18:17:43] (index) database connection response [18 Sep 2020 18:17:43] (index) getConnectionClose() called.... [18 Sep 2020 18:17:43] (index) getConnectionClose() called.... [18 Sep 2020 19:42:24] (index) database connection response [18 Sep 2020 19:42:24] (index) getConnection(): Resource id #1 [18 Sep 2020 19:42:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 19:42:24] (index) database connection response [18 Sep 2020 19:42:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 19:42:24] (index) database connection response [18 Sep 2020 19:42:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 19:42:24] (index) database connection response [18 Sep 2020 19:42:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 19:42:24] (index) database connection response [18 Sep 2020 19:42:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 19:42:24] (index) database connection response [18 Sep 2020 19:42:24] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 19:42:24] (index) database connection response [18 Sep 2020 19:42:24] (index) getPatientReportsDetail() entered [18 Sep 2020 19:42:24] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 19:42:24] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 19:42:24] (index) p_Stop=N [18 Sep 2020 19:42:24] (index) p_Alert= [18 Sep 2020 19:42:24] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 19:42:24] (index) database connection response [18 Sep 2020 19:42:24] (index) getConnectionClose() called.... [18 Sep 2020 19:42:24] (index) getConnectionClose() called.... [18 Sep 2020 20:27:18] (index) database connection response [18 Sep 2020 20:27:18] (index) getConnection(): Resource id #1 [18 Sep 2020 20:27:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 20:27:18] (index) database connection response [18 Sep 2020 20:27:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 20:27:18] (index) database connection response [18 Sep 2020 20:27:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 20:27:18] (index) database connection response [18 Sep 2020 20:27:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200389506' AND ACCESS_CODE = '91095744' [18 Sep 2020 20:27:18] (index) database connection response [18 Sep 2020 20:27:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200389506' AND ACCESS_CODE = '91095744' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 20:27:18] (index) database connection response [18 Sep 2020 20:27:18] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000555600' [18 Sep 2020 20:27:18] (index) database connection response [18 Sep 2020 20:27:18] (index) getPatientReportsDetail() entered [18 Sep 2020 20:27:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200389506', 'M0100000555600', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 20:27:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200389506', 'M0100000555600', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 20:27:18] (index) p_Stop=N [18 Sep 2020 20:27:18] (index) p_Alert= [18 Sep 2020 20:27:18] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 20:27:18] (index) database connection response [18 Sep 2020 20:27:18] (index) getConnectionClose() called.... [18 Sep 2020 20:27:18] (index) getConnectionClose() called.... [18 Sep 2020 20:46:51] (index) database connection response [18 Sep 2020 20:46:51] (index) getConnection(): Resource id #1 [18 Sep 2020 20:46:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 20:46:51] (index) database connection response [18 Sep 2020 20:46:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 20:46:51] (index) database connection response [18 Sep 2020 20:46:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 20:46:51] (index) database connection response [18 Sep 2020 20:46:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 20:46:51] (index) database connection response [18 Sep 2020 20:46:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 20:46:51] (index) database connection response [18 Sep 2020 20:46:51] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 20:46:51] (index) database connection response [18 Sep 2020 20:46:51] (index) getPatientReportsDetail() entered [18 Sep 2020 20:46:51] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 20:46:51] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 20:46:51] (index) p_Stop=N [18 Sep 2020 20:46:51] (index) p_Alert= [18 Sep 2020 20:46:51] (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 [18 Sep 2020 20:46:51] (index) database connection response [18 Sep 2020 20:46:51] (index) getConnectionClose() called.... [18 Sep 2020 20:46:51] (index) getConnectionClose() called.... [18 Sep 2020 20:58:08] (index) database connection response [18 Sep 2020 20:58:08] (index) getConnection(): Resource id #1 [18 Sep 2020 20:58:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 20:58:08] (index) database connection response [18 Sep 2020 20:58:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 20:58:08] (index) database connection response [18 Sep 2020 20:58:08] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 20:58:08] (index) database connection response [18 Sep 2020 20:58:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200387144' AND ACCESS_CODE = '57907644' [18 Sep 2020 20:58:08] (index) database connection response [18 Sep 2020 20:58:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200387144' AND ACCESS_CODE = '57907644' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 20:58:08] (index) database connection response [18 Sep 2020 20:58:08] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000627886' [18 Sep 2020 20:58:08] (index) database connection response [18 Sep 2020 20:58:08] (index) getPatientReportsDetail() entered [18 Sep 2020 20:58:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200387144', 'M0100000627886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 20:58:08] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200387144', 'M0100000627886', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 20:58:08] (index) p_Stop=N [18 Sep 2020 20:58:08] (index) p_Alert= [18 Sep 2020 20:58:08] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 20:58:08] (index) database connection response [18 Sep 2020 20:58:08] (index) getConnectionClose() called.... [18 Sep 2020 20:58:08] (index) getConnectionClose() called.... [18 Sep 2020 21:53:41] (index) database connection response [18 Sep 2020 21:53:41] (index) getConnection(): Resource id #1 [18 Sep 2020 21:53:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 21:53:41] (index) database connection response [18 Sep 2020 21:53:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 21:53:41] (index) database connection response [18 Sep 2020 21:53:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 21:53:41] (index) database connection response [18 Sep 2020 21:53:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200389506' AND ACCESS_CODE = '91095744' [18 Sep 2020 21:53:41] (index) database connection response [18 Sep 2020 21:53:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200389506' AND ACCESS_CODE = '91095744' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 21:53:41] (index) database connection response [18 Sep 2020 21:53:41] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000555600' [18 Sep 2020 21:53:41] (index) database connection response [18 Sep 2020 21:53:41] (index) getPatientReportsDetail() entered [18 Sep 2020 21:53:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200389506', 'M0100000555600', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 21:53:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200389506', 'M0100000555600', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 21:53:41] (index) p_Stop=N [18 Sep 2020 21:53:41] (index) p_Alert= [18 Sep 2020 21:53:41] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 21:53:41] (index) database connection response [18 Sep 2020 21:53:41] (index) getConnectionClose() called.... [18 Sep 2020 21:53:41] (index) getConnectionClose() called.... [18 Sep 2020 22:55:16] (index) database connection response [18 Sep 2020 22:55:16] (index) getConnection(): Resource id #1 [18 Sep 2020 22:55:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 22:55:16] (index) database connection response [18 Sep 2020 22:55:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 22:55:16] (index) database connection response [18 Sep 2020 22:55:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 22:55:16] (index) database connection response [18 Sep 2020 22: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 = 'M01200383528' AND ACCESS_CODE = '73185029' [18 Sep 2020 22:55:16] (index) database connection response [18 Sep 2020 22: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 = 'M01200383528' AND ACCESS_CODE = '73185029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 22:55:16] (index) database connection response [18 Sep 2020 22:55:16] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000004930' [18 Sep 2020 22:55:16] (index) database connection response [18 Sep 2020 22:55:16] (index) getPatientReportsDetail() entered [18 Sep 2020 22:55:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 22:55:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200383528', 'M0100000004930', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 22:55:16] (index) p_Stop=N [18 Sep 2020 22:55:16] (index) p_Alert= [18 Sep 2020 22:55:16] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [18 Sep 2020 22:55:16] (index) database connection response [18 Sep 2020 22:55:16] (index) getConnectionClose() called.... [18 Sep 2020 22:55:16] (index) getConnectionClose() called.... [18 Sep 2020 23:58:15] (index) database connection response [18 Sep 2020 23:58:15] (index) getConnection(): Resource id #1 [18 Sep 2020 23:58:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [18 Sep 2020 23:58:15] (index) database connection response [18 Sep 2020 23:58:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [18 Sep 2020 23:58:15] (index) database connection response [18 Sep 2020 23:58:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [18 Sep 2020 23:58:15] (index) database connection response [18 Sep 2020 23:58:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200389506' AND ACCESS_CODE = '91095744' [18 Sep 2020 23:58:15] (index) database connection response [18 Sep 2020 23:58:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200389506' AND ACCESS_CODE = '91095744' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [18 Sep 2020 23:58:15] (index) database connection response [18 Sep 2020 23:58:15] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000555600' [18 Sep 2020 23:58:15] (index) database connection response [18 Sep 2020 23:58:15] (index) getPatientReportsDetail() entered [18 Sep 2020 23:58:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200389506', 'M0100000555600', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 23:58:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200389506', 'M0100000555600', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 23:58:15] (index) p_Stop=N [18 Sep 2020 23:58:15] (index) p_Alert= [18 Sep 2020 23:58: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 [18 Sep 2020 23:58:15] (index) database connection response [18 Sep 2020 23:58:15] (index) getConnectionClose() called.... [18 Sep 2020 23:58:15] (index) getConnectionClose() called.... [18 Sep 2020 23:58:23] (viewOnlineReports) database connection response [18 Sep 2020 23:58:23] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 23:58:23] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000555600', '001', '200387697', '1', '001000000000084702', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 23:58:23] (viewOnlineReports) p_Stop=N [18 Sep 2020 23:58:23] (viewOnlineReports) p_Alert= [18 Sep 2020 23:58:23] (viewOnlineReports) Flag = 1 [18 Sep 2020 23:58:23] (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', '200387697', 'M01', '047', '1', '001000000000084702', 'M0100000555600_M01SCH20009679_1.PDF', 'M0100000555600', SYSDATE) [18 Sep 2020 23:58:23] (viewOnlineReports) database connection response [18 Sep 2020 23:58:23] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200387697' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [18 Sep 2020 23:58:23] (viewOnlineReports) database connection response [18 Sep 2020 23:58:23] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 23:58:23] (viewOnlineReports) creating directory structure../../TEMP_PDF/200387697/ [18 Sep 2020 23:58:23] (viewOnlineReports) directory structure created ../../TEMP_PDF/200387697/ [18 Sep 2020 23:58:23] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200918\M01\M0100000555600_M01SCH20009679_1.PDF [18 Sep 2020 23:58:23] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200387697/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1600455503M0100000555600_M01SCH20009679_1.PDF [18 Sep 2020 23:58:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200387697/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1600455503M0100000555600_M01SCH20009679_1.PDF [18 Sep 2020 23:58:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [18 Sep 2020 23:58:23] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200387697/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1600455503M0100000555600_M01SCH20009679_1.PDF [18 Sep 2020 23:59:05] (viewOnlineReports) database connection response [18 Sep 2020 23:59:05] (viewOnlineReports) getConnection(): Resource id #1 [18 Sep 2020 23:59:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000555600', '001', '200387697', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [18 Sep 2020 23:59:05] (viewOnlineReports) p_Stop=N [18 Sep 2020 23:59:05] (viewOnlineReports) p_Alert= [18 Sep 2020 23:59:05] (viewOnlineReports) Flag = 1 [18 Sep 2020 23:59:05] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200387697', 'M01', '047', '2', '001000000000085025', 'M0100000555600_M01HEM20012906_1.PDF', 'M0100000555600', SYSDATE) [18 Sep 2020 23:59:05] (viewOnlineReports) database connection response [18 Sep 2020 23:59:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200387697' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [18 Sep 2020 23:59:05] (viewOnlineReports) database connection response [18 Sep 2020 23:59:05] (viewOnlineReports) getConnectionClose() called.... [18 Sep 2020 23:59:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200387697/ [18 Sep 2020 23:59:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200387697/ [18 Sep 2020 23:59:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200918\M01\M0100000555600_M01HEM20012906_1.PDF [18 Sep 2020 23:59:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200387697/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600455545M0100000555600_M01HEM20012906_1.PDF [18 Sep 2020 23:59:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200387697/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600455545M0100000555600_M01HEM20012906_1.PDF [18 Sep 2020 23:59:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [18 Sep 2020 23:59:06] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200387697/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1600455545M0100000555600_M01HEM20012906_1.PDF