[26 Sep 2020 02:48:28] (index) database connection response [26 Sep 2020 02:48:28] (index) getConnection(): Resource id #1 [26 Sep 2020 02:48:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:48:28] (index) database connection response [26 Sep 2020 02:48:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:48:28] (index) database connection response [26 Sep 2020 02:48:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:48:28] (index) database connection response [26 Sep 2020 02:48:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200303171' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:48:28] (index) database connection response [26 Sep 2020 02:48:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200303171' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:48:28] (index) database connection response [26 Sep 2020 02:48:28] (index) getConnectionClose() called.... [26 Sep 2020 02:49:04] (index) database connection response [26 Sep 2020 02:49:04] (index) getConnection(): Resource id #1 [26 Sep 2020 02:49:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:49:04] (index) database connection response [26 Sep 2020 02:49:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:49:04] (index) database connection response [26 Sep 2020 02:49:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:49:04] (index) database connection response [26 Sep 2020 02:49:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:49:04] (index) database connection response [26 Sep 2020 02:49:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:49:04] (index) database connection response [26 Sep 2020 02:49:04] (index) getConnectionClose() called.... [26 Sep 2020 02:49:21] (index) database connection response [26 Sep 2020 02:49:21] (index) getConnection(): Resource id #1 [26 Sep 2020 02:49:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:49:21] (index) database connection response [26 Sep 2020 02:49:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:49:21] (index) database connection response [26 Sep 2020 02:49:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:49:21] (index) database connection response [26 Sep 2020 02:49:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:49:21] (index) database connection response [26 Sep 2020 02:49:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:49:21] (index) database connection response [26 Sep 2020 02:49:21] (index) getConnectionClose() called.... [26 Sep 2020 02:49:57] (index) database connection response [26 Sep 2020 02:49:57] (index) getConnection(): Resource id #1 [26 Sep 2020 02:49:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:49:57] (index) database connection response [26 Sep 2020 02:49:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:49:57] (index) database connection response [26 Sep 2020 02:49:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:49:57] (index) database connection response [26 Sep 2020 02:49:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:49:57] (index) database connection response [26 Sep 2020 02:49:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:49:57] (index) database connection response [26 Sep 2020 02:49:57] (index) getConnectionClose() called.... [26 Sep 2020 02:50:13] (index) database connection response [26 Sep 2020 02:50:13] (index) getConnection(): Resource id #1 [26 Sep 2020 02:50:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:50:13] (index) database connection response [26 Sep 2020 02:50:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:50:13] (index) database connection response [26 Sep 2020 02:50:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:50:13] (index) database connection response [26 Sep 2020 02:50:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200303171' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:50:13] (index) database connection response [26 Sep 2020 02:50:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200303171' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:50:13] (index) database connection response [26 Sep 2020 02:50:13] (index) getConnectionClose() called.... [26 Sep 2020 02:50:34] (index) database connection response [26 Sep 2020 02:50:34] (index) getConnection(): Resource id #1 [26 Sep 2020 02:50:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:50:34] (index) database connection response [26 Sep 2020 02:50:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:50:34] (index) database connection response [26 Sep 2020 02:50:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:50:34] (index) database connection response [26 Sep 2020 02:50:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:50:34] (index) database connection response [26 Sep 2020 02:50:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:50:34] (index) database connection response [26 Sep 2020 02:50:34] (index) getConnectionClose() called.... [26 Sep 2020 02:50:50] (index) database connection response [26 Sep 2020 02:50:50] (index) getConnection(): Resource id #1 [26 Sep 2020 02:50:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:50:50] (index) database connection response [26 Sep 2020 02:50:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:50:50] (index) database connection response [26 Sep 2020 02:50:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:50:50] (index) database connection response [26 Sep 2020 02:50:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:50:50] (index) database connection response [26 Sep 2020 02:50:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:50:50] (index) database connection response [26 Sep 2020 02:50:50] (index) getConnectionClose() called.... [26 Sep 2020 02:51:03] (index) database connection response [26 Sep 2020 02:51:03] (index) getConnection(): Resource id #1 [26 Sep 2020 02:51:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:51:03] (index) database connection response [26 Sep 2020 02:51:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:51:03] (index) database connection response [26 Sep 2020 02:51:03] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:51:03] (index) database connection response [26 Sep 2020 02:51:03] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:51:03] (index) database connection response [26 Sep 2020 02:51:03] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:51:03] (index) database connection response [26 Sep 2020 02:51:03] (index) getConnectionClose() called.... [26 Sep 2020 02:51:15] (index) database connection response [26 Sep 2020 02:51:15] (index) getConnection(): Resource id #1 [26 Sep 2020 02:51:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:51:15] (index) database connection response [26 Sep 2020 02:51:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:51:15] (index) database connection response [26 Sep 2020 02:51:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:51:15] (index) database connection response [26 Sep 2020 02:51:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:51:15] (index) database connection response [26 Sep 2020 02:51:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:51:15] (index) database connection response [26 Sep 2020 02:51:15] (index) getConnectionClose() called.... [26 Sep 2020 02:56:52] (index) database connection response [26 Sep 2020 02:56:52] (index) getConnection(): Resource id #1 [26 Sep 2020 02:56:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 02:56:52] (index) database connection response [26 Sep 2020 02:56:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 02:56:52] (index) database connection response [26 Sep 2020 02:56:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 02:56:52] (index) database connection response [26 Sep 2020 02:56:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 02:56:52] (index) database connection response [26 Sep 2020 02:56:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 02:56:52] (index) database connection response [26 Sep 2020 02:56:52] (index) getConnectionClose() called.... [26 Sep 2020 03:02:58] (index) database connection response [26 Sep 2020 03:02:58] (index) getConnection(): Resource id #1 [26 Sep 2020 03:02:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:02:58] (index) database connection response [26 Sep 2020 03:02:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:02:58] (index) database connection response [26 Sep 2020 03:02:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:02:58] (index) database connection response [26 Sep 2020 03:02:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = 'S06REP00078' [26 Sep 2020 03:02:58] (index) database connection response [26 Sep 2020 03:02:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = 'S06REP00078' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:02:58] (index) database connection response [26 Sep 2020 03:02:58] (index) getConnectionClose() called.... [26 Sep 2020 03:03:52] (index) database connection response [26 Sep 2020 03:03:52] (index) getConnection(): Resource id #1 [26 Sep 2020 03:03:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:03:52] (index) database connection response [26 Sep 2020 03:03:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:03:52] (index) database connection response [26 Sep 2020 03:03:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:03:52] (index) database connection response [26 Sep 2020 03:03:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 03:03:52] (index) database connection response [26 Sep 2020 03:03:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:03:52] (index) database connection response [26 Sep 2020 03:03:52] (index) getConnectionClose() called.... [26 Sep 2020 03:05:32] (index) database connection response [26 Sep 2020 03:05:32] (index) getConnection(): Resource id #1 [26 Sep 2020 03:05:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:05:32] (index) database connection response [26 Sep 2020 03:05:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:05:32] (index) database connection response [26 Sep 2020 03:05:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:05:32] (index) database connection response [26 Sep 2020 03:05:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 03:05:32] (index) database connection response [26 Sep 2020 03:05:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:05:32] (index) database connection response [26 Sep 2020 03:05:32] (index) getConnectionClose() called.... [26 Sep 2020 03:07:04] (index) database connection response [26 Sep 2020 03:07:04] (index) getConnection(): Resource id #1 [26 Sep 2020 03:07:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:07:04] (index) database connection response [26 Sep 2020 03:07:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:07:04] (index) database connection response [26 Sep 2020 03:07:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:07:04] (index) database connection response [26 Sep 2020 03:07:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 03:07:04] (index) database connection response [26 Sep 2020 03:07:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:07:04] (index) database connection response [26 Sep 2020 03:07:04] (index) getConnectionClose() called.... [26 Sep 2020 03:26:44] (index) database connection response [26 Sep 2020 03:26:44] (index) getConnection(): Resource id #1 [26 Sep 2020 03:26:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:26:44] (index) database connection response [26 Sep 2020 03:26:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:26:44] (index) database connection response [26 Sep 2020 03:26:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:26:44] (index) database connection response [26 Sep 2020 03:26:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 03:26:44] (index) database connection response [26 Sep 2020 03:26:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:26:44] (index) database connection response [26 Sep 2020 03:26:44] (index) getConnectionClose() called.... [26 Sep 2020 03:27:01] (index) database connection response [26 Sep 2020 03:27:01] (index) getConnection(): Resource id #1 [26 Sep 2020 03:27:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:27:01] (index) database connection response [26 Sep 2020 03:27:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:27:01] (index) database connection response [26 Sep 2020 03:27:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:27:01] (index) database connection response [26 Sep 2020 03:27:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 03:27:01] (index) database connection response [26 Sep 2020 03:27:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:27:01] (index) database connection response [26 Sep 2020 03:27:01] (index) getConnectionClose() called.... [26 Sep 2020 03:28:58] (index) database connection response [26 Sep 2020 03:28:58] (index) getConnection(): Resource id #1 [26 Sep 2020 03:28:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:28:58] (index) database connection response [26 Sep 2020 03:28:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:28:58] (index) database connection response [26 Sep 2020 03:28:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:28:58] (index) database connection response [26 Sep 2020 03:28:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 03:28:58] (index) database connection response [26 Sep 2020 03:28:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:28:58] (index) database connection response [26 Sep 2020 03:28:58] (index) getConnectionClose() called.... [26 Sep 2020 03:31:57] (index) database connection response [26 Sep 2020 03:31:57] (index) getConnection(): Resource id #1 [26 Sep 2020 03:31:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:31:57] (index) database connection response [26 Sep 2020 03:31:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:31:57] (index) database connection response [26 Sep 2020 03:31:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:31:57] (index) database connection response [26 Sep 2020 03:31:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 03:31:57] (index) database connection response [26 Sep 2020 03:31:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:31:57] (index) database connection response [26 Sep 2020 03:31:57] (index) getConnectionClose() called.... [26 Sep 2020 03:32:36] (index) database connection response [26 Sep 2020 03:32:36] (index) getConnection(): Resource id #1 [26 Sep 2020 03:32:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:32:36] (index) database connection response [26 Sep 2020 03:32:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:32:36] (index) database connection response [26 Sep 2020 03:32:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:32:36] (index) database connection response [26 Sep 2020 03:32:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' [26 Sep 2020 03:32:36] (index) database connection response [26 Sep 2020 03:32:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200491712' AND ACCESS_CODE = '56645730' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:32:36] (index) database connection response [26 Sep 2020 03:32:36] (index) getConnectionClose() called.... [26 Sep 2020 03:47:42] (index) database connection response [26 Sep 2020 03:47:42] (index) getConnection(): Resource id #1 [26 Sep 2020 03:47:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 03:47:42] (index) database connection response [26 Sep 2020 03:47:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 03:47:42] (index) database connection response [26 Sep 2020 03:47:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 03:47:42] (index) database connection response [26 Sep 2020 03:47:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403343' AND ACCESS_CODE = '20176724' [26 Sep 2020 03:47:42] (index) database connection response [26 Sep 2020 03:47:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403343' AND ACCESS_CODE = '20176724' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 03:47:43] (index) database connection response [26 Sep 2020 03:47:43] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000463990' [26 Sep 2020 03:47:43] (index) database connection response [26 Sep 2020 03:47:43] (index) getPatientReportsDetail() entered [26 Sep 2020 03:47:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403343', 'M0100000463990', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 03:47:43] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403343', 'M0100000463990', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 03:47:43] (index) p_Stop=N [26 Sep 2020 03:47:43] (index) p_Alert= [26 Sep 2020 03:47:43] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 03:47:43] (index) database connection response [26 Sep 2020 03:47:43] (index) getConnectionClose() called.... [26 Sep 2020 03:47:43] (index) getConnectionClose() called.... [26 Sep 2020 04:07:24] (viewOnlineReports) database connection response [26 Sep 2020 04:07:24] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 04:07:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000463990', '001', '200392706', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 04:07:24] (viewOnlineReports) p_Stop=N [26 Sep 2020 04:07:24] (viewOnlineReports) p_Alert= [26 Sep 2020 04:07:24] (viewOnlineReports) Flag = 1 [26 Sep 2020 04:07: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', '200392706', 'M01', '070', '1', '001000000000087630', 'M0100000463990_M01MOL20008903_1.PDF', 'M0100000463990', SYSDATE) [26 Sep 2020 04:07:24] (viewOnlineReports) database connection response [26 Sep 2020 04:07:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392706' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 04:07:24] (viewOnlineReports) database connection response [26 Sep 2020 04:07:24] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 04:07:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392706/ [26 Sep 2020 04:07:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392706/ [26 Sep 2020 04:07:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000463990_M01MOL20008903_1.PDF [26 Sep 2020 04:07:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392706/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601075244M0100000463990_M01MOL20008903_1.PDF [26 Sep 2020 04:07:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392706/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601075244M0100000463990_M01MOL20008903_1.PDF [26 Sep 2020 04:07:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 04:07:24] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200392706/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1601075244M0100000463990_M01MOL20008903_1.PDF [26 Sep 2020 08:32:46] (index) database connection response [26 Sep 2020 08:32:46] (index) getConnection(): Resource id #1 [26 Sep 2020 08:32:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 08:32:46] (index) database connection response [26 Sep 2020 08:32:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 08:32:46] (index) database connection response [26 Sep 2020 08:32:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 08:32:46] (index) database connection response [26 Sep 2020 08:32:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200494317' AND ACCESS_CODE = '26748611' [26 Sep 2020 08:32:46] (index) database connection response [26 Sep 2020 08:32:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200494317' AND ACCESS_CODE = '26748611' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 08:32:46] (index) database connection response [26 Sep 2020 08:32:46] (index) getConnectionClose() called.... [26 Sep 2020 09:56:44] (index) database connection response [26 Sep 2020 09:56:44] (index) getConnection(): Resource id #1 [26 Sep 2020 09:56:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 09:56:44] (index) database connection response [26 Sep 2020 09:56:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 09:56:44] (index) database connection response [26 Sep 2020 09:56:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 09:56:44] (index) database connection response [26 Sep 2020 09:56:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403353' AND ACCESS_CODE = '89690363' [26 Sep 2020 09:56:44] (index) database connection response [26 Sep 2020 09:56:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403353' AND ACCESS_CODE = '89690363' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 09:56:44] (index) database connection response [26 Sep 2020 09:56:44] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634772' [26 Sep 2020 09:56:44] (index) database connection response [26 Sep 2020 09:56:44] (index) getPatientReportsDetail() entered [26 Sep 2020 09:56:44] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403353', 'M0100000634772', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 09:56:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403353', 'M0100000634772', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 09:56:45] (index) p_Stop=N [26 Sep 2020 09:56:45] (index) p_Alert= [26 Sep 2020 09:56: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 [26 Sep 2020 09:56:45] (index) database connection response [26 Sep 2020 09:56:45] (index) getConnectionClose() called.... [26 Sep 2020 09:56:45] (index) getConnectionClose() called.... [26 Sep 2020 09:59:27] (index) database connection response [26 Sep 2020 09:59:27] (index) getConnection(): Resource id #1 [26 Sep 2020 09:59:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 09:59:27] (index) database connection response [26 Sep 2020 09:59:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 09:59:27] (index) database connection response [26 Sep 2020 09:59:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 09:59:27] (index) database connection response [26 Sep 2020 09:59:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200396821' AND ACCESS_CODE = '10723921' [26 Sep 2020 09:59:27] (index) database connection response [26 Sep 2020 09:59:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200396821' AND ACCESS_CODE = '10723921' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 09:59:27] (index) database connection response [26 Sep 2020 09:59:27] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000061285' [26 Sep 2020 09:59:27] (index) database connection response [26 Sep 2020 09:59:27] (index) getPatientReportsDetail() entered [26 Sep 2020 09:59:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200396821', 'M0100000061285', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 09:59:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200396821', 'M0100000061285', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 09:59:27] (index) p_Stop=N [26 Sep 2020 09:59:27] (index) p_Alert= [26 Sep 2020 09:59:27] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 09:59:27] (index) database connection response [26 Sep 2020 09:59:27] (index) getConnectionClose() called.... [26 Sep 2020 09:59:27] (index) getConnectionClose() called.... [26 Sep 2020 09:59:54] (viewOnlineReports) database connection response [26 Sep 2020 09:59:54] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 09:59:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000061285', '001', '200390269', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 09:59:54] (viewOnlineReports) p_Stop=N [26 Sep 2020 09:59:54] (viewOnlineReports) p_Alert= [26 Sep 2020 09:59:54] (viewOnlineReports) Flag = 1 [26 Sep 2020 09:59:54] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200390269', 'M01', '047', '1', '001000000000081028', 'M0100000061285_M01RCH20017726_1.PDF', 'M0100000061285', SYSDATE) [26 Sep 2020 09:59:54] (viewOnlineReports) database connection response [26 Sep 2020 09:59:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200390269' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 09:59:54] (viewOnlineReports) database connection response [26 Sep 2020 09:59:54] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 09:59:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200390269/ [26 Sep 2020 09:59:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200390269/ [26 Sep 2020 09:59:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200922\M01\M0100000061285_M01RCH20017726_1.PDF [26 Sep 2020 09:59:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200390269/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601096394M0100000061285_M01RCH20017726_1.PDF [26 Sep 2020 09:59:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200390269/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601096394M0100000061285_M01RCH20017726_1.PDF [26 Sep 2020 09:59:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 09:59:54] (viewOnlineReports) Downloading file ../../TEMP_PDF/200390269/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601096394M0100000061285_M01RCH20017726_1.PDF [26 Sep 2020 10:55:25] (index) database connection response [26 Sep 2020 10:55:25] (index) getConnection(): Resource id #1 [26 Sep 2020 10:55:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 10:55:25] (index) database connection response [26 Sep 2020 10:55:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 10:55:25] (index) database connection response [26 Sep 2020 10:55:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 10:55:25] (index) database connection response [26 Sep 2020 10:55:25] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200282567' AND ACCESS_CODE = '51672226' [26 Sep 2020 10:55:25] (index) database connection response [26 Sep 2020 10:55:25] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200282567' AND ACCESS_CODE = '51672226' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 10:55:25] (index) database connection response [26 Sep 2020 10:55:25] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000621340' [26 Sep 2020 10:55:25] (index) database connection response [26 Sep 2020 10:55:25] (index) getPatientReportsDetail() entered [26 Sep 2020 10:55:25] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200282567', 'M0100000621340', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 10:55:25] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200282567', 'M0100000621340', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 10:55:25] (index) p_Stop=N [26 Sep 2020 10:55:25] (index) p_Alert= [26 Sep 2020 10:55: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 [26 Sep 2020 10:55:25] (index) database connection response [26 Sep 2020 10:55:25] (index) getConnectionClose() called.... [26 Sep 2020 10:55:25] (index) getConnectionClose() called.... [26 Sep 2020 10:55:59] (viewOnlineReports) database connection response [26 Sep 2020 10:55:59] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 10:55:59] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000621340', '001', '200358238', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 10:55:59] (viewOnlineReports) p_Stop=N [26 Sep 2020 10:55:59] (viewOnlineReports) p_Alert= [26 Sep 2020 10:55:59] (viewOnlineReports) Flag = 1 [26 Sep 2020 10:55:59] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200358238', 'M01', '047', '1', '001000000000085025', 'M0100000621340_M01HEM20009356_1.PDF', 'M0100000621340', SYSDATE) [26 Sep 2020 10:55:59] (viewOnlineReports) database connection response [26 Sep 2020 10:55:59] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200358238' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 10:55:59] (viewOnlineReports) database connection response [26 Sep 2020 10:55:59] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 10:55:59] (viewOnlineReports) creating directory structure../../TEMP_PDF/200358238/ [26 Sep 2020 10:55:59] (viewOnlineReports) directory structure created ../../TEMP_PDF/200358238/ [26 Sep 2020 10:55:59] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200711\M01\M0100000621340_M01HEM20009356_1.PDF [26 Sep 2020 10:55:59] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200358238/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601099759M0100000621340_M01HEM20009356_1.PDF [26 Sep 2020 10:55:59] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200358238/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601099759M0100000621340_M01HEM20009356_1.PDF [26 Sep 2020 10:55:59] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Sep 2020 10:55:59] (viewOnlineReports) Converting PDF to JPG with name as M0100000621340_M01HEM20009356_1.jpg [26 Sep 2020 10:55:59] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200358238/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601099759M0100000621340_M01HEM20009356_1.PDF ../../TEMP_PDF/200358238/M0100000621340_M01HEM20009356_1.jpg [26 Sep 2020 10:55:59] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200358238/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1601099759M0100000621340_M01HEM20009356_1.PDF [26 Sep 2020 10:56:12] (viewOnlineReports) database connection response [26 Sep 2020 10:56:12] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 10:56:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000621340', '001', '200358238', '2', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 10:56:12] (viewOnlineReports) p_Stop=N [26 Sep 2020 10:56:12] (viewOnlineReports) p_Alert= [26 Sep 2020 10:56:12] (viewOnlineReports) Flag = 1 [26 Sep 2020 10:56:12] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200358238', 'M01', '047', '2', '001000000000086900', 'M0100000621340_M01BBK20001558_1.PDF', 'M0100000621340', SYSDATE) [26 Sep 2020 10:56:12] (viewOnlineReports) database connection response [26 Sep 2020 10:56:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200358238' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [26 Sep 2020 10:56:12] (viewOnlineReports) database connection response [26 Sep 2020 10:56:12] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 10:56:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200358238/ [26 Sep 2020 10:56:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200358238/ [26 Sep 2020 10:56:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200710\M01\M0100000621340_M01BBK20001558_1.PDF [26 Sep 2020 10:56:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200358238/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601099772M0100000621340_M01BBK20001558_1.PDF [26 Sep 2020 10:56:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200358238/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601099772M0100000621340_M01BBK20001558_1.PDF [26 Sep 2020 10:56:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Sep 2020 10:56:12] (viewOnlineReports) Converting PDF to JPG with name as M0100000621340_M01BBK20001558_1.jpg [26 Sep 2020 10:56:12] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200358238/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601099772M0100000621340_M01BBK20001558_1.PDF ../../TEMP_PDF/200358238/M0100000621340_M01BBK20001558_1.jpg [26 Sep 2020 10:56:12] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200358238/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601099772M0100000621340_M01BBK20001558_1.PDF [26 Sep 2020 10:56:20] (viewOnlineReports) database connection response [26 Sep 2020 10:56:20] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 10:56:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000621340', '001', '200358238', '3', '001000000000086287', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 10:56:20] (viewOnlineReports) p_Stop=N [26 Sep 2020 10:56:20] (viewOnlineReports) p_Alert= [26 Sep 2020 10:56:20] (viewOnlineReports) Flag = 1 [26 Sep 2020 10:56:20] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200358238', 'M01', '047', '3', '001000000000086287', 'M0100000621340_M01SCH20006859_1.PDF', 'M0100000621340', SYSDATE) [26 Sep 2020 10:56:20] (viewOnlineReports) database connection response [26 Sep 2020 10:56:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200358238' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Sep 2020 10:56:20] (viewOnlineReports) database connection response [26 Sep 2020 10:56:20] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 10:56:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200358238/ [26 Sep 2020 10:56:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200358238/ [26 Sep 2020 10:56:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200710\M01\M0100000621340_M01SCH20006859_1.PDF [26 Sep 2020 10:56:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200358238/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1601099779M0100000621340_M01SCH20006859_1.PDF [26 Sep 2020 10:56:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200358238/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1601099779M0100000621340_M01SCH20006859_1.PDF [26 Sep 2020 10:56:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Sep 2020 10:56:20] (viewOnlineReports) Converting PDF to JPG with name as M0100000621340_M01SCH20006859_1.jpg [26 Sep 2020 10:56:20] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200358238/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1601099779M0100000621340_M01SCH20006859_1.PDF ../../TEMP_PDF/200358238/M0100000621340_M01SCH20006859_1.jpg [26 Sep 2020 10:56:20] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200358238/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1601099779M0100000621340_M01SCH20006859_1.PDF [26 Sep 2020 10:56:24] (viewOnlineReports) database connection response [26 Sep 2020 10:56:24] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 10:56:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000621340', '001', '200358238', '4', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 10:56:24] (viewOnlineReports) p_Stop=N [26 Sep 2020 10:56:24] (viewOnlineReports) p_Alert= [26 Sep 2020 10:56:24] (viewOnlineReports) Flag = 1 [26 Sep 2020 10:56: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', '200358238', 'M01', '047', '4', '001000000000086302', 'M0100000621340_M01SCH20006859_2.PDF', 'M0100000621340', SYSDATE) [26 Sep 2020 10:56:24] (viewOnlineReports) database connection response [26 Sep 2020 10:56:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200358238' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [26 Sep 2020 10:56:24] (viewOnlineReports) database connection response [26 Sep 2020 10:56:24] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 10:56:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200358238/ [26 Sep 2020 10:56:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200358238/ [26 Sep 2020 10:56:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200710\M01\M0100000621340_M01SCH20006859_2.PDF [26 Sep 2020 10:56:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200358238/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1601099784M0100000621340_M01SCH20006859_2.PDF [26 Sep 2020 10:56:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200358238/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1601099784M0100000621340_M01SCH20006859_2.PDF [26 Sep 2020 10:56:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Sep 2020 10:56:25] (viewOnlineReports) Converting PDF to JPG with name as M0100000621340_M01SCH20006859_2.jpg [26 Sep 2020 10:56:25] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200358238/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1601099784M0100000621340_M01SCH20006859_2.PDF ../../TEMP_PDF/200358238/M0100000621340_M01SCH20006859_2.jpg [26 Sep 2020 10:56:25] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200358238/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1601099784M0100000621340_M01SCH20006859_2.PDF [26 Sep 2020 11:40:31] (index) database connection response [26 Sep 2020 11:40:31] (index) getConnection(): Resource id #1 [26 Sep 2020 11:40:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 11:40:31] (index) database connection response [26 Sep 2020 11:40:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 11:40:31] (index) database connection response [26 Sep 2020 11:40:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 11:40:31] (index) database connection response [26 Sep 2020 11:40:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403429' AND ACCESS_CODE = '19532714' [26 Sep 2020 11:40:31] (index) database connection response [26 Sep 2020 11:40:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403429' AND ACCESS_CODE = '19532714' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 11:40:31] (index) database connection response [26 Sep 2020 11:40:31] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000052650' [26 Sep 2020 11:40:31] (index) database connection response [26 Sep 2020 11:40:31] (index) getPatientReportsDetail() entered [26 Sep 2020 11:40:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403429', 'M0100000052650', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:40:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403429', 'M0100000052650', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:40:31] (index) p_Stop=N [26 Sep 2020 11:40:31] (index) p_Alert= [26 Sep 2020 11:40:31] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 11:40:31] (index) database connection response [26 Sep 2020 11:40:31] (index) getConnectionClose() called.... [26 Sep 2020 11:40:31] (index) getConnectionClose() called.... [26 Sep 2020 11:40:41] (viewOnlineReports) database connection response [26 Sep 2020 11:40:41] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 11:40:41] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000052650', '001', '200392739', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:40:41] (viewOnlineReports) p_Stop=N [26 Sep 2020 11:40:41] (viewOnlineReports) p_Alert= [26 Sep 2020 11:40:41] (viewOnlineReports) Flag = 1 [26 Sep 2020 11:40:41] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392739', 'M01', '047', '1', '001000000000085025', 'M0100000052650_M01HEM20013320_1.PDF', 'M0100000052650', SYSDATE) [26 Sep 2020 11:40:41] (viewOnlineReports) database connection response [26 Sep 2020 11:40:41] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392739' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 11:40:41] (viewOnlineReports) database connection response [26 Sep 2020 11:40:41] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 11:40:41] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392739/ [26 Sep 2020 11:40:41] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392739/ [26 Sep 2020 11:40:41] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200925\M01\M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:40:41] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601102441M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:40:42] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601102441M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:40:42] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Sep 2020 11:40:42] (viewOnlineReports) Converting PDF to JPG with name as M0100000052650_M01HEM20013320_1.jpg [26 Sep 2020 11:40:42] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601102441M0100000052650_M01HEM20013320_1.PDF ../../TEMP_PDF/200392739/M0100000052650_M01HEM20013320_1.jpg [26 Sep 2020 11:40:42] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601102441M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:00] (viewOnlineReports) database connection response [26 Sep 2020 11:41:00] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 11:41:00] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000052650', '001', '200392739', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:41:00] (viewOnlineReports) p_Stop=N [26 Sep 2020 11:41:00] (viewOnlineReports) p_Alert= [26 Sep 2020 11:41:00] (viewOnlineReports) Flag = 1 [26 Sep 2020 11:41:00] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392739', 'M01', '047', '1', '001000000000085025', 'M0100000052650_M01HEM20013320_1.PDF', 'M0100000052650', SYSDATE) [26 Sep 2020 11:41:00] (viewOnlineReports) database connection response [26 Sep 2020 11:41:00] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392739' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 11:41:00] (viewOnlineReports) database connection response [26 Sep 2020 11:41:00] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 11:41:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392739/ [26 Sep 2020 11:41:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392739/ [26 Sep 2020 11:41:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200925\M01\M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601102460M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:00] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601102460M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:00] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Sep 2020 11:41:00] (viewOnlineReports) Converting PDF to JPG with name as M0100000052650_M01HEM20013320_1.jpg [26 Sep 2020 11:41:00] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601102460M0100000052650_M01HEM20013320_1.PDF ../../TEMP_PDF/200392739/M0100000052650_M01HEM20013320_1.jpg [26 Sep 2020 11:41:00] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601102460M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:14] (viewOnlineReports) database connection response [26 Sep 2020 11:41:14] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 11:41:14] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000052650', '001', '200392739', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:41:14] (viewOnlineReports) p_Stop=N [26 Sep 2020 11:41:14] (viewOnlineReports) p_Alert= [26 Sep 2020 11:41:14] (viewOnlineReports) Flag = 1 [26 Sep 2020 11:41:14] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392739', 'M01', '047', '1', '001000000000085025', 'M0100000052650_M01HEM20013320_1.PDF', 'M0100000052650', SYSDATE) [26 Sep 2020 11:41:14] (viewOnlineReports) database connection response [26 Sep 2020 11:41:14] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392739' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 11:41:14] (viewOnlineReports) database connection response [26 Sep 2020 11:41:14] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 11:41:14] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392739/ [26 Sep 2020 11:41:14] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392739/ [26 Sep 2020 11:41:14] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200925\M01\M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:14] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601102474M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:14] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601102474M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:14] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Sep 2020 11:41:14] (viewOnlineReports) Converting PDF to JPG with name as M0100000052650_M01HEM20013320_1.jpg [26 Sep 2020 11:41:14] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601102474M0100000052650_M01HEM20013320_1.PDF ../../TEMP_PDF/200392739/M0100000052650_M01HEM20013320_1.jpg [26 Sep 2020 11:41:15] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601102474M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:58] (viewOnlineReports) database connection response [26 Sep 2020 11:41:58] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 11:41:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000052650', '001', '200392739', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:41:58] (viewOnlineReports) p_Stop=N [26 Sep 2020 11:41:58] (viewOnlineReports) p_Alert= [26 Sep 2020 11:41:58] (viewOnlineReports) Flag = 1 [26 Sep 2020 11:41:58] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392739', 'M01', '047', '1', '001000000000085025', 'M0100000052650_M01HEM20013320_1.PDF', 'M0100000052650', SYSDATE) [26 Sep 2020 11:41:58] (viewOnlineReports) database connection response [26 Sep 2020 11:41:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392739' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 11:41:58] (viewOnlineReports) database connection response [26 Sep 2020 11:41:58] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 11:41:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392739/ [26 Sep 2020 11:41:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392739/ [26 Sep 2020 11:41:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200925\M01\M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601102518M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601102518M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:41:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 11:41:58] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601102518M0100000052650_M01HEM20013320_1.PDF [26 Sep 2020 11:42:01] (viewOnlineReports) database connection response [26 Sep 2020 11:42:01] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 11:42:01] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000052650', '001', '200392739', '2', '001000000000082728', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:42:01] (viewOnlineReports) p_Stop=N [26 Sep 2020 11:42:01] (viewOnlineReports) p_Alert= [26 Sep 2020 11:42:01] (viewOnlineReports) Flag = 1 [26 Sep 2020 11:42:01] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392739', 'M01', '047', '2', '001000000000082728', 'M0100000052650_M01SCH20010016_3.PDF', 'M0100000052650', SYSDATE) [26 Sep 2020 11:42:01] (viewOnlineReports) database connection response [26 Sep 2020 11:42:01] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392739' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [26 Sep 2020 11:42:01] (viewOnlineReports) database connection response [26 Sep 2020 11:42:01] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 11:42:01] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392739/ [26 Sep 2020 11:42:01] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392739/ [26 Sep 2020 11:42:01] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200925\M01\M0100000052650_M01SCH20010016_3.PDF [26 Sep 2020 11:42:01] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392739/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601102521M0100000052650_M01SCH20010016_3.PDF [26 Sep 2020 11:42:01] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392739/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601102521M0100000052650_M01SCH20010016_3.PDF [26 Sep 2020 11:42:01] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 11:42:01] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392739/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601102521M0100000052650_M01SCH20010016_3.PDF [26 Sep 2020 11:42:04] (viewOnlineReports) database connection response [26 Sep 2020 11:42:04] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 11:42:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000052650', '001', '200392739', '3', '001000000000082607', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:42:04] (viewOnlineReports) p_Stop=N [26 Sep 2020 11:42:04] (viewOnlineReports) p_Alert= [26 Sep 2020 11:42:04] (viewOnlineReports) Flag = 1 [26 Sep 2020 11:42: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', '200392739', 'M01', '047', '3', '001000000000082607', 'M0100000052650_M01SCH20010016_2.PDF', 'M0100000052650', SYSDATE) [26 Sep 2020 11:42:04] (viewOnlineReports) database connection response [26 Sep 2020 11:42:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392739' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Sep 2020 11:42:04] (viewOnlineReports) database connection response [26 Sep 2020 11:42:04] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 11:42:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392739/ [26 Sep 2020 11:42:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392739/ [26 Sep 2020 11:42:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200925\M01\M0100000052650_M01SCH20010016_2.PDF [26 Sep 2020 11:42:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601102524M0100000052650_M01SCH20010016_2.PDF [26 Sep 2020 11:42:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601102524M0100000052650_M01SCH20010016_2.PDF [26 Sep 2020 11:42:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 11:42:04] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601102524M0100000052650_M01SCH20010016_2.PDF [26 Sep 2020 11:42:07] (viewOnlineReports) database connection response [26 Sep 2020 11:42:07] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 11:42:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000052650', '001', '200392739', '4', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 11:42:07] (viewOnlineReports) p_Stop=N [26 Sep 2020 11:42:07] (viewOnlineReports) p_Alert= [26 Sep 2020 11:42:07] (viewOnlineReports) Flag = 1 [26 Sep 2020 11:42:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392739', 'M01', '047', '4', '001000000000082306', 'M0100000052650_M01SCH20010016_1.PDF', 'M0100000052650', SYSDATE) [26 Sep 2020 11:42:07] (viewOnlineReports) database connection response [26 Sep 2020 11:42:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392739' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [26 Sep 2020 11:42:07] (viewOnlineReports) database connection response [26 Sep 2020 11:42:07] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 11:42:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392739/ [26 Sep 2020 11:42:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392739/ [26 Sep 2020 11:42:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200925\M01\M0100000052650_M01SCH20010016_1.PDF [26 Sep 2020 11:42:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1601102527M0100000052650_M01SCH20010016_1.PDF [26 Sep 2020 11:42:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1601102527M0100000052650_M01SCH20010016_1.PDF [26 Sep 2020 11:42:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 11:42:07] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392739/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1601102527M0100000052650_M01SCH20010016_1.PDF [26 Sep 2020 12:07:05] (index) database connection response [26 Sep 2020 12:07:05] (index) getConnection(): Resource id #1 [26 Sep 2020 12:07:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 12:07:05] (index) database connection response [26 Sep 2020 12:07:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 12:07:05] (index) database connection response [26 Sep 2020 12:07:05] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 12:07:05] (index) database connection response [26 Sep 2020 12:07:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403353' AND ACCESS_CODE = '89690363' [26 Sep 2020 12:07:05] (index) database connection response [26 Sep 2020 12:07:05] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403353' AND ACCESS_CODE = '89690363' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 12:07:05] (index) database connection response [26 Sep 2020 12:07:05] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634772' [26 Sep 2020 12:07:05] (index) database connection response [26 Sep 2020 12:07:05] (index) getPatientReportsDetail() entered [26 Sep 2020 12:07:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403353', 'M0100000634772', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 12:07:05] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403353', 'M0100000634772', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 12:07:05] (index) p_Stop=N [26 Sep 2020 12:07:05] (index) p_Alert= [26 Sep 2020 12:07:05] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 12:07:05] (index) database connection response [26 Sep 2020 12:07:05] (index) getConnectionClose() called.... [26 Sep 2020 12:07:05] (index) getConnectionClose() called.... [26 Sep 2020 12:07:19] (viewOnlineReports) database connection response [26 Sep 2020 12:07:19] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 12:07:19] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634772', '001', '200392707', '1', '00100000000R-86725', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 12:07:19] (viewOnlineReports) p_Stop=N [26 Sep 2020 12:07:19] (viewOnlineReports) p_Alert= [26 Sep 2020 12:07:19] (viewOnlineReports) Flag = 1 [26 Sep 2020 12:07:19] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392707', 'M01', '047', '1', '00100000000R-86725', 'M0100000634772_M01SCH20010014_1.PDF', 'M0100000634772', SYSDATE) [26 Sep 2020 12:07:19] (viewOnlineReports) database connection response [26 Sep 2020 12:07:19] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392707' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 12:07:19] (viewOnlineReports) database connection response [26 Sep 2020 12:07:19] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 12:07:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392707/ [26 Sep 2020 12:07:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392707/ [26 Sep 2020 12:07:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601104039M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601104039M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 12:07:19] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601104039M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:39] (viewOnlineReports) database connection response [26 Sep 2020 12:07:39] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 12:07:39] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634772', '001', '200392707', '1', '00100000000R-86725', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 12:07:39] (viewOnlineReports) p_Stop=N [26 Sep 2020 12:07:39] (viewOnlineReports) p_Alert= [26 Sep 2020 12:07:39] (viewOnlineReports) Flag = 1 [26 Sep 2020 12:07:39] (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', '200392707', 'M01', '047', '1', '00100000000R-86725', 'M0100000634772_M01SCH20010014_1.PDF', 'M0100000634772', SYSDATE) [26 Sep 2020 12:07:39] (viewOnlineReports) database connection response [26 Sep 2020 12:07:39] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392707' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 12:07:39] (viewOnlineReports) database connection response [26 Sep 2020 12:07:39] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 12:07:39] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392707/ [26 Sep 2020 12:07:39] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392707/ [26 Sep 2020 12:07:39] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:39] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392707/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1601104059M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392707/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1601104059M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 12:07:39] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200392707/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1601104059M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:39] (viewOnlineReports) database connection response [26 Sep 2020 12:07:39] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 12:07:39] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634772', '001', '200392707', '1', '00100000000R-86725', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 12:07:39] (viewOnlineReports) p_Stop=N [26 Sep 2020 12:07:39] (viewOnlineReports) p_Alert= [26 Sep 2020 12:07:39] (viewOnlineReports) Flag = 1 [26 Sep 2020 12:07:39] (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', '200392707', 'M01', '047', '1', '00100000000R-86725', 'M0100000634772_M01SCH20010014_1.PDF', 'M0100000634772', SYSDATE) [26 Sep 2020 12:07:39] (viewOnlineReports) database connection response [26 Sep 2020 12:07:39] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392707' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 12:07:39] (viewOnlineReports) database connection response [26 Sep 2020 12:07:39] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 12:07:39] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392707/ [26 Sep 2020 12:07:39] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392707/ [26 Sep 2020 12:07:39] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:39] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601104059M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601104059M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 12:07:39] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1601104059M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:50] (viewOnlineReports) database connection response [26 Sep 2020 12:07:50] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 12:07:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000634772', '001', '200392707', '1', '00100000000R-86725', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 12:07:50] (viewOnlineReports) p_Stop=N [26 Sep 2020 12:07:50] (viewOnlineReports) p_Alert= [26 Sep 2020 12:07:50] (viewOnlineReports) Flag = 1 [26 Sep 2020 12:07:50] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392707', 'M01', '047', '1', '00100000000R-86725', 'M0100000634772_M01SCH20010014_1.PDF', 'M0100000634772', SYSDATE) [26 Sep 2020 12:07:50] (viewOnlineReports) database connection response [26 Sep 2020 12:07:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392707' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 12:07:50] (viewOnlineReports) database connection response [26 Sep 2020 12:07:50] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 12:07:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392707/ [26 Sep 2020 12:07:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392707/ [26 Sep 2020 12:07:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601104070M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601104070M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:07:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 12:07:50] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392707/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1601104070M0100000634772_M01SCH20010014_1.PDF [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getConnection(): Resource id #1 [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200304525' AND ACCESS_CODE = '57651193' [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getConnection(): Resource id #1 [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200304525' AND ACCESS_CODE = '57651193' [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200304525' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 12:51:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200304525' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getConnectionClose() called.... [26 Sep 2020 12:51:39] (index) database connection response [26 Sep 2020 12:51:39] (index) getConnectionClose() called.... [26 Sep 2020 12:52:45] (index) database connection response [26 Sep 2020 12:52:45] (index) getConnection(): Resource id #1 [26 Sep 2020 12:52:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 12:52:45] (index) database connection response [26 Sep 2020 12:52:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 12:52:45] (index) database connection response [26 Sep 2020 12:52:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 12:52:45] (index) database connection response [26 Sep 2020 12:52:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000057' AND ACCESS_CODE = '57651193' [26 Sep 2020 12:52:45] (index) database connection response [26 Sep 2020 12:52:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000057' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 12:52:45] (index) database connection response [26 Sep 2020 12:52:45] (index) getConnectionClose() called.... [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getConnection(): Resource id #1 [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200304525' AND ACCESS_CODE = '57651193' [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200304525' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getConnectionClose() called.... [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getConnection(): Resource id #1 [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200304525' AND ACCESS_CODE = '57651193' [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200304525' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 12:53:39] (index) database connection response [26 Sep 2020 12:53:39] (index) getConnectionClose() called.... [26 Sep 2020 12:54:44] (index) database connection response [26 Sep 2020 12:54:44] (index) getConnection(): Resource id #1 [26 Sep 2020 12:54:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 12:54:44] (index) database connection response [26 Sep 2020 12:54:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 12:54:44] (index) database connection response [26 Sep 2020 12:54:44] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 12:54:44] (index) database connection response [26 Sep 2020 12:54:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600005749' AND ACCESS_CODE = '57651193' [26 Sep 2020 12:54:44] (index) database connection response [26 Sep 2020 12:54:44] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600005749' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 12:54:44] (index) database connection response [26 Sep 2020 12:54:44] (index) getConnectionClose() called.... [26 Sep 2020 12:55:09] (index) database connection response [26 Sep 2020 12:55:09] (index) getConnection(): Resource id #1 [26 Sep 2020 12:55:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 12:55:09] (index) database connection response [26 Sep 2020 12:55:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 12:55:09] (index) database connection response [26 Sep 2020 12:55:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 12:55:09] (index) database connection response [26 Sep 2020 12:55:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600005749' AND ACCESS_CODE = '57651193' [26 Sep 2020 12:55:09] (index) database connection response [26 Sep 2020 12:55:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600005749' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 12:55:09] (index) database connection response [26 Sep 2020 12:55:09] (index) getConnectionClose() called.... [26 Sep 2020 14:03:31] (index) database connection response [26 Sep 2020 14:03:31] (index) getConnection(): Resource id #1 [26 Sep 2020 14:03:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 14:03:31] (index) database connection response [26 Sep 2020 14:03:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 14:03:31] (index) database connection response [26 Sep 2020 14:03:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 14:03:31] (index) database connection response [26 Sep 2020 14:03:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403746' AND ACCESS_CODE = '57651193' [26 Sep 2020 14:03:31] (index) database connection response [26 Sep 2020 14:03:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403746' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 14:03:31] (index) database connection response [26 Sep 2020 14:03:31] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0160100005657' [26 Sep 2020 14:03:31] (index) database connection response [26 Sep 2020 14:03:31] (index) getPatientReportsDetail() entered [26 Sep 2020 14:03:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403746', 'M0160100005657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:03:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403746', 'M0160100005657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:03:31] (index) p_Stop=Y [26 Sep 2020 14:03:31] (index) p_Alert=Patient is confidential. You have no rights to view this EMR. [26 Sep 2020 14:03:31] (index) getConnectionClose() called.... [26 Sep 2020 14:03:41] (index) database connection response [26 Sep 2020 14:03:41] (index) getConnection(): Resource id #1 [26 Sep 2020 14:03:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 14:03:41] (index) database connection response [26 Sep 2020 14:03:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 14:03:41] (index) database connection response [26 Sep 2020 14:03:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 14:03:41] (index) database connection response [26 Sep 2020 14:03:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200400835' AND ACCESS_CODE = '28529690' [26 Sep 2020 14:03:42] (index) database connection response [26 Sep 2020 14:03:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200400835' AND ACCESS_CODE = '28529690' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 14:03:42] (index) database connection response [26 Sep 2020 14:03:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634980' [26 Sep 2020 14:03:42] (index) database connection response [26 Sep 2020 14:03:42] (index) getPatientReportsDetail() entered [26 Sep 2020 14:03:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200400835', 'M0100000634980', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:03:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200400835', 'M0100000634980', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:03:42] (index) p_Stop=N [26 Sep 2020 14:03:42] (index) p_Alert= [26 Sep 2020 14:03: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 [26 Sep 2020 14:03:42] (index) database connection response [26 Sep 2020 14:03:42] (index) getConnectionClose() called.... [26 Sep 2020 14:03:42] (index) getConnectionClose() called.... [26 Sep 2020 14:04:17] (viewOnlineReports) database connection response [26 Sep 2020 14:04:17] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 14:04:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000634980', '001', '200391786', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:04:17] (viewOnlineReports) p_Stop=N [26 Sep 2020 14:04:17] (viewOnlineReports) p_Alert= [26 Sep 2020 14:04:17] (viewOnlineReports) Flag = 1 [26 Sep 2020 14:04:17] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200391786', 'M01', '070', '1', '001000000000087630', 'M0100000634980_M01MOL20008671_1.PDF', 'M0100000634980', SYSDATE) [26 Sep 2020 14:04:17] (viewOnlineReports) database connection response [26 Sep 2020 14:04:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200391786' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 14:04:17] (viewOnlineReports) database connection response [26 Sep 2020 14:04:17] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 14:04:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200391786/ [26 Sep 2020 14:04:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200391786/ [26 Sep 2020 14:04:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200924\M01\M0100000634980_M01MOL20008671_1.PDF [26 Sep 2020 14:04:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200391786/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601111057M0100000634980_M01MOL20008671_1.PDF [26 Sep 2020 14:04:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200391786/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601111057M0100000634980_M01MOL20008671_1.PDF [26 Sep 2020 14:04:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 14:04:17] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200391786/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1601111057M0100000634980_M01MOL20008671_1.PDF [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getConnection(): Resource id #1 [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403746' AND ACCESS_CODE = '57651193' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403746' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0160100005657' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getPatientReportsDetail() entered [26 Sep 2020 14:04:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403746', 'M0160100005657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:04:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403746', 'M0160100005657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:04:30] (index) p_Stop=Y [26 Sep 2020 14:04:30] (index) p_Alert=Patient is confidential. You have no rights to view this EMR. [26 Sep 2020 14:04:30] (index) getConnectionClose() called.... [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getConnection(): Resource id #1 [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403746' AND ACCESS_CODE = '57651193' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403746' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0160100005657' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getPatientReportsDetail() entered [26 Sep 2020 14:04:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403746', 'M0160100005657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:04:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403746', 'M0160100005657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:04:30] (index) p_Stop=Y [26 Sep 2020 14:04:30] (index) p_Alert=Patient is confidential. You have no rights to view this EMR. [26 Sep 2020 14:04:30] (index) getConnectionClose() called.... [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getConnection(): Resource id #1 [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403746' AND ACCESS_CODE = '57651193' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403746' AND ACCESS_CODE = '57651193' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0160100005657' [26 Sep 2020 14:04:30] (index) database connection response [26 Sep 2020 14:04:30] (index) getPatientReportsDetail() entered [26 Sep 2020 14:04:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403746', 'M0160100005657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:04:30] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403746', 'M0160100005657', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:04:30] (index) p_Stop=Y [26 Sep 2020 14:04:30] (index) p_Alert=Patient is confidential. You have no rights to view this EMR. [26 Sep 2020 14:04:30] (index) getConnectionClose() called.... [26 Sep 2020 14:04:45] (viewOnlineReports) database connection response [26 Sep 2020 14:04:45] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 14:04:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000634980', '001', '200391786', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:04:45] (viewOnlineReports) p_Stop=N [26 Sep 2020 14:04:45] (viewOnlineReports) p_Alert= [26 Sep 2020 14:04:45] (viewOnlineReports) Flag = 1 [26 Sep 2020 14:04:45] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200391786', 'M01', '070', '1', '001000000000087630', 'M0100000634980_M01MOL20008671_1.PDF', 'M0100000634980', SYSDATE) [26 Sep 2020 14:04:45] (viewOnlineReports) database connection response [26 Sep 2020 14:04:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200391786' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 14:04:45] (viewOnlineReports) database connection response [26 Sep 2020 14:04:45] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 14:04:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200391786/ [26 Sep 2020 14:04:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200391786/ [26 Sep 2020 14:04:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200924\M01\M0100000634980_M01MOL20008671_1.PDF [26 Sep 2020 14:04:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200391786/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601111085M0100000634980_M01MOL20008671_1.PDF [26 Sep 2020 14:04:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200391786/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601111085M0100000634980_M01MOL20008671_1.PDF [26 Sep 2020 14:04:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 14:04:45] (viewOnlineReports) Downloading file ../../TEMP_PDF/200391786/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601111085M0100000634980_M01MOL20008671_1.PDF [26 Sep 2020 14:11:49] (index) database connection response [26 Sep 2020 14:11:49] (index) getConnection(): Resource id #1 [26 Sep 2020 14:11:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 14:11:49] (index) database connection response [26 Sep 2020 14:11:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 14:11:49] (index) database connection response [26 Sep 2020 14:11:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 14:11:49] (index) database connection response [26 Sep 2020 14:11:49] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403113' AND ACCESS_CODE = '07177796' [26 Sep 2020 14:11:49] (index) database connection response [26 Sep 2020 14:11:49] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200403113' AND ACCESS_CODE = '07177796' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 14:11:49] (index) database connection response [26 Sep 2020 14:11:49] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000523941' [26 Sep 2020 14:11:49] (index) database connection response [26 Sep 2020 14:11:49] (index) getPatientReportsDetail() entered [26 Sep 2020 14:11:49] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403113', 'M0100000523941', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:11:49] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200403113', 'M0100000523941', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:11:49] (index) p_Stop=N [26 Sep 2020 14:11:49] (index) p_Alert= [26 Sep 2020 14:11:49] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 14:11:49] (index) database connection response [26 Sep 2020 14:11:49] (index) getConnectionClose() called.... [26 Sep 2020 14:11:49] (index) getConnectionClose() called.... [26 Sep 2020 14:12:05] (viewOnlineReports) database connection response [26 Sep 2020 14:12:05] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 14:12:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000523941', '001', '200392634', '2', '001000000000081265', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:12:05] (viewOnlineReports) p_Stop=N [26 Sep 2020 14:12:05] (viewOnlineReports) p_Alert= [26 Sep 2020 14:12:05] (viewOnlineReports) Flag = 1 [26 Sep 2020 14:12: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', '200392634', 'M01', '047', '2', '001000000000081265', 'M0100000523941_M01RCH20018027_3.PDF', 'M0100000523941', SYSDATE) [26 Sep 2020 14:12:05] (viewOnlineReports) database connection response [26 Sep 2020 14:12:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392634' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [26 Sep 2020 14:12:05] (viewOnlineReports) database connection response [26 Sep 2020 14:12:05] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 14:12:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392634/ [26 Sep 2020 14:12:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392634/ [26 Sep 2020 14:12:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000523941_M01RCH20018027_3.PDF [26 Sep 2020 14:12:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392634/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601111525M0100000523941_M01RCH20018027_3.PDF [26 Sep 2020 14:12:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392634/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601111525M0100000523941_M01RCH20018027_3.PDF [26 Sep 2020 14:12:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 14:12:05] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200392634/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601111525M0100000523941_M01RCH20018027_3.PDF [26 Sep 2020 14:13:05] (viewOnlineReports) database connection response [26 Sep 2020 14:13:05] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 14:13:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000523941', '001', '200392634', '3', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:13:05] (viewOnlineReports) p_Stop=N [26 Sep 2020 14:13:05] (viewOnlineReports) p_Alert= [26 Sep 2020 14:13:05] (viewOnlineReports) Flag = 1 [26 Sep 2020 14:13: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', '200392634', 'M01', '047', '3', '001000000000084296', 'M0100000523941_M01RCH20018027_4.PDF', 'M0100000523941', SYSDATE) [26 Sep 2020 14:13:05] (viewOnlineReports) database connection response [26 Sep 2020 14:13:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392634' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [26 Sep 2020 14:13:05] (viewOnlineReports) database connection response [26 Sep 2020 14:13:05] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 14:13:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392634/ [26 Sep 2020 14:13:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392634/ [26 Sep 2020 14:13:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000523941_M01RCH20018027_4.PDF [26 Sep 2020 14:13:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392634/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601111585M0100000523941_M01RCH20018027_4.PDF [26 Sep 2020 14:13:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392634/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601111585M0100000523941_M01RCH20018027_4.PDF [26 Sep 2020 14:13:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 14:13:05] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392634/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601111585M0100000523941_M01RCH20018027_4.PDF [26 Sep 2020 14:14:16] (viewOnlineReports) database connection response [26 Sep 2020 14:14:16] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 14:14:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000523941', '001', '200392634', '6', '001000000000080061', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 14:14:16] (viewOnlineReports) p_Stop=N [26 Sep 2020 14:14:16] (viewOnlineReports) p_Alert= [26 Sep 2020 14:14:16] (viewOnlineReports) Flag = 1 [26 Sep 2020 14:14:16] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392634', 'M01', '047', '6', '001000000000080061', 'M0100000523941_M01RCH20018027_2.PDF', 'M0100000523941', SYSDATE) [26 Sep 2020 14:14:16] (viewOnlineReports) database connection response [26 Sep 2020 14:14:16] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392634' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [26 Sep 2020 14:14:16] (viewOnlineReports) database connection response [26 Sep 2020 14:14:16] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 14:14:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392634/ [26 Sep 2020 14:14:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392634/ [26 Sep 2020 14:14:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000523941_M01RCH20018027_2.PDF [26 Sep 2020 14:14:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392634/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601111656M0100000523941_M01RCH20018027_2.PDF [26 Sep 2020 14:14:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392634/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601111656M0100000523941_M01RCH20018027_2.PDF [26 Sep 2020 14:14:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 14:14:16] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392634/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1601111656M0100000523941_M01RCH20018027_2.PDF [26 Sep 2020 15:25:18] (index) database connection response [26 Sep 2020 15:25:18] (index) getConnection(): Resource id #1 [26 Sep 2020 15:25:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 15:25:18] (index) database connection response [26 Sep 2020 15:25:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 15:25:18] (index) database connection response [26 Sep 2020 15:25:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 15:25:18] (index) database connection response [26 Sep 2020 15:25:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404897' AND ACCESS_CODE = '69623620' [26 Sep 2020 15:25:18] (index) database connection response [26 Sep 2020 15:25:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404897' AND ACCESS_CODE = '69623620' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 15:25:18] (index) database connection response [26 Sep 2020 15:25:18] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000635418' [26 Sep 2020 15:25:18] (index) database connection response [26 Sep 2020 15:25:18] (index) getPatientReportsDetail() entered [26 Sep 2020 15:25:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404897', 'M0100000635418', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 15:25:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404897', 'M0100000635418', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 15:25:18] (index) p_Stop=N [26 Sep 2020 15:25:18] (index) p_Alert= [26 Sep 2020 15:25: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 [26 Sep 2020 15:25:18] (index) database connection response [26 Sep 2020 15:25:18] (index) getConnectionClose() called.... [26 Sep 2020 15:25:18] (index) getConnectionClose() called.... [26 Sep 2020 15:32:10] (viewOnlineReports) database connection response [26 Sep 2020 15:32:10] (viewOnlineReports) getConnection(): Resource id #2 [26 Sep 2020 15:32:10] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000635418', '001', '200393238', '2', '001000000000081010', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 15:32:10] (viewOnlineReports) p_Stop=N [26 Sep 2020 15:32:10] (viewOnlineReports) p_Alert= [26 Sep 2020 15:32:10] (viewOnlineReports) Flag = 1 [26 Sep 2020 15:32:10] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200393238', 'M01', '047', '2', '001000000000081010', 'M0100000635418_M01RCH20018035_1.PDF', 'M0100000635418', SYSDATE) [26 Sep 2020 15:32:10] (viewOnlineReports) database connection response [26 Sep 2020 15:32:10] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200393238' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [26 Sep 2020 15:32:10] (viewOnlineReports) database connection response [26 Sep 2020 15:32:10] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 15:32:10] (viewOnlineReports) creating directory structure../../TEMP_PDF/200393238/ [26 Sep 2020 15:32:10] (viewOnlineReports) directory structure created ../../TEMP_PDF/200393238/ [26 Sep 2020 15:32:10] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635418_M01RCH20018035_1.PDF [26 Sep 2020 15:32:10] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200393238/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601116330M0100000635418_M01RCH20018035_1.PDF [26 Sep 2020 15:32:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200393238/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601116330M0100000635418_M01RCH20018035_1.PDF [26 Sep 2020 15:32:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 15:32:11] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200393238/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1601116330M0100000635418_M01RCH20018035_1.PDF [26 Sep 2020 15:32:25] (viewOnlineReports) database connection response [26 Sep 2020 15:32:25] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 15:32:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000635418', '001', '200393238', '2', '001000000000081010', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 15:32:25] (viewOnlineReports) p_Stop=N [26 Sep 2020 15:32:25] (viewOnlineReports) p_Alert= [26 Sep 2020 15:32:25] (viewOnlineReports) Flag = 1 [26 Sep 2020 15:32: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', '200393238', 'M01', '047', '2', '001000000000081010', 'M0100000635418_M01RCH20018035_1.PDF', 'M0100000635418', SYSDATE) [26 Sep 2020 15:32:25] (viewOnlineReports) database connection response [26 Sep 2020 15:32:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200393238' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [26 Sep 2020 15:32:25] (viewOnlineReports) database connection response [26 Sep 2020 15:32:25] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 15:32:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200393238/ [26 Sep 2020 15:32:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200393238/ [26 Sep 2020 15:32:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635418_M01RCH20018035_1.PDF [26 Sep 2020 15:32:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200393238/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601116345M0100000635418_M01RCH20018035_1.PDF [26 Sep 2020 15:32:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200393238/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601116345M0100000635418_M01RCH20018035_1.PDF [26 Sep 2020 15:32:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 15:32:25] (viewOnlineReports) Downloading file ../../TEMP_PDF/200393238/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1601116345M0100000635418_M01RCH20018035_1.PDF [26 Sep 2020 16:28:36] (index) database connection response [26 Sep 2020 16:28:36] (index) getConnection(): Resource id #1 [26 Sep 2020 16:28:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 16:28:36] (index) database connection response [26 Sep 2020 16:28:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 16:28:36] (index) database connection response [26 Sep 2020 16:28:36] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 16:28:36] (index) database connection response [26 Sep 2020 16:28:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404534' AND ACCESS_CODE = '66034519' [26 Sep 2020 16:28:36] (index) database connection response [26 Sep 2020 16:28:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404534' AND ACCESS_CODE = '66034519' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 16:28:36] (index) database connection response [26 Sep 2020 16:28:36] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000635385' [26 Sep 2020 16:28:36] (index) database connection response [26 Sep 2020 16:28:36] (index) getPatientReportsDetail() entered [26 Sep 2020 16:28:36] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404534', 'M0100000635385', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 16:28:36] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404534', 'M0100000635385', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 16:28:36] (index) p_Stop=N [26 Sep 2020 16:28:36] (index) p_Alert= [26 Sep 2020 16:28: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 [26 Sep 2020 16:28:36] (index) database connection response [26 Sep 2020 16:28:36] (index) getConnectionClose() called.... [26 Sep 2020 16:28:36] (index) getConnectionClose() called.... [26 Sep 2020 16:29:16] (viewOnlineReports) database connection response [26 Sep 2020 16:29:16] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 16:29:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000635385', '001', '200393103', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 16:29:16] (viewOnlineReports) p_Stop=N [26 Sep 2020 16:29:16] (viewOnlineReports) p_Alert= [26 Sep 2020 16:29:16] (viewOnlineReports) Flag = 1 [26 Sep 2020 16:29:16] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200393103', 'M01', '070', '1', '001000000000087630', 'M0100000635385_M01MOL20008935_1.PDF', 'M0100000635385', SYSDATE) [26 Sep 2020 16:29:16] (viewOnlineReports) database connection response [26 Sep 2020 16:29:16] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200393103' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 16:29:16] (viewOnlineReports) database connection response [26 Sep 2020 16:29:16] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 16:29:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200393103/ [26 Sep 2020 16:29:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200393103/ [26 Sep 2020 16:29:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601119756M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601119756M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 16:29:16] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1601119756M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:34] (viewOnlineReports) database connection response [26 Sep 2020 16:29:34] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 16:29:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000635385', '001', '200393103', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 16:29:34] (viewOnlineReports) p_Stop=N [26 Sep 2020 16:29:34] (viewOnlineReports) p_Alert= [26 Sep 2020 16:29:34] (viewOnlineReports) Flag = 1 [26 Sep 2020 16:29:34] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200393103', 'M01', '070', '1', '001000000000087630', 'M0100000635385_M01MOL20008935_1.PDF', 'M0100000635385', SYSDATE) [26 Sep 2020 16:29:34] (viewOnlineReports) database connection response [26 Sep 2020 16:29:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200393103' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 16:29:34] (viewOnlineReports) database connection response [26 Sep 2020 16:29:34] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 16:29:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200393103/ [26 Sep 2020 16:29:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200393103/ [26 Sep 2020 16:29:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601119774M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601119774M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 16:29:34] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1601119774M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:53] (viewOnlineReports) database connection response [26 Sep 2020 16:29:53] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 16:29:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000635385', '001', '200393103', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 16:29:53] (viewOnlineReports) p_Stop=N [26 Sep 2020 16:29:53] (viewOnlineReports) p_Alert= [26 Sep 2020 16:29:53] (viewOnlineReports) Flag = 1 [26 Sep 2020 16:29:53] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200393103', 'M01', '070', '1', '001000000000087630', 'M0100000635385_M01MOL20008935_1.PDF', 'M0100000635385', SYSDATE) [26 Sep 2020 16:29:53] (viewOnlineReports) database connection response [26 Sep 2020 16:29:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200393103' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 16:29:53] (viewOnlineReports) database connection response [26 Sep 2020 16:29:53] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 16:29:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200393103/ [26 Sep 2020 16:29:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200393103/ [26 Sep 2020 16:29:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1601119793M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1601119793M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 16:29:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 16:29:53] (viewOnlineReports) Downloading file ../../TEMP_PDF/200393103/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1601119793M0100000635385_M01MOL20008935_1.PDF [26 Sep 2020 17:13:06] (index) database connection response [26 Sep 2020 17:13:06] (index) getConnection(): Resource id #1 [26 Sep 2020 17:13:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 17:13:06] (index) database connection response [26 Sep 2020 17:13:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 17:13:06] (index) database connection response [26 Sep 2020 17:13:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 17:13:06] (index) database connection response [26 Sep 2020 17:13:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200405258' AND ACCESS_CODE = '56159271' [26 Sep 2020 17:13:06] (index) database connection response [26 Sep 2020 17:13:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200405258' AND ACCESS_CODE = '56159271' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 17:13:06] (index) database connection response [26 Sep 2020 17:13:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000614106' [26 Sep 2020 17:13:06] (index) database connection response [26 Sep 2020 17:13:06] (index) getPatientReportsDetail() entered [26 Sep 2020 17:13:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200405258', 'M0100000614106', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:13:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200405258', 'M0100000614106', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:13:06] (index) p_Stop=N [26 Sep 2020 17:13:06] (index) p_Alert= [26 Sep 2020 17:13:06] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 17:13:06] (index) database connection response [26 Sep 2020 17:13:06] (index) getConnectionClose() called.... [26 Sep 2020 17:13:06] (index) getConnectionClose() called.... [26 Sep 2020 17:13:28] (viewOnlineReports) database connection response [26 Sep 2020 17:13:28] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 17:13:28] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000614106', '001', '200393374', '1', '001000000000085610', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:13:28] (viewOnlineReports) p_Stop=N [26 Sep 2020 17:13:28] (viewOnlineReports) p_Alert= [26 Sep 2020 17:13:28] (viewOnlineReports) Flag = 1 [26 Sep 2020 17:13:28] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200393374', 'M01', '047', '1', '001000000000085610', 'M0100000614106_M01HEM20013374_1.PDF', 'M0100000614106', SYSDATE) [26 Sep 2020 17:13:28] (viewOnlineReports) database connection response [26 Sep 2020 17:13:28] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200393374' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [26 Sep 2020 17:13:28] (viewOnlineReports) database connection response [26 Sep 2020 17:13:28] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 17:13:28] (viewOnlineReports) creating directory structure../../TEMP_PDF/200393374/ [26 Sep 2020 17:13:28] (viewOnlineReports) directory structure created ../../TEMP_PDF/200393374/ [26 Sep 2020 17:13:28] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000614106_M01HEM20013374_1.PDF [26 Sep 2020 17:13:28] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200393374/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601122408M0100000614106_M01HEM20013374_1.PDF [26 Sep 2020 17:13:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200393374/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601122408M0100000614106_M01HEM20013374_1.PDF [26 Sep 2020 17:13:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 17:13:28] (viewOnlineReports) Downloading file ../../TEMP_PDF/200393374/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601122408M0100000614106_M01HEM20013374_1.PDF [26 Sep 2020 17:35:48] (index) database connection response [26 Sep 2020 17:35:48] (index) getConnection(): Resource id #1 [26 Sep 2020 17:35:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 17:35:48] (index) database connection response [26 Sep 2020 17:35:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 17:35:48] (index) database connection response [26 Sep 2020 17:35:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 17:35:48] (index) database connection response [26 Sep 2020 17:35:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404670' AND ACCESS_CODE = '12602769' [26 Sep 2020 17:35:49] (index) database connection response [26 Sep 2020 17:35:49] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404670' AND ACCESS_CODE = '12602769' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 17:35:49] (index) database connection response [26 Sep 2020 17:35:49] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000635408' [26 Sep 2020 17:35:49] (index) database connection response [26 Sep 2020 17:35:49] (index) getPatientReportsDetail() entered [26 Sep 2020 17:35:49] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404670', 'M0100000635408', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:35:49] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404670', 'M0100000635408', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:35:49] (index) p_Stop=N [26 Sep 2020 17:35:49] (index) p_Alert= [26 Sep 2020 17:35:49] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 17:35:49] (index) database connection response [26 Sep 2020 17:35:49] (index) getConnectionClose() called.... [26 Sep 2020 17:35:49] (index) getConnectionClose() called.... [26 Sep 2020 17:38:18] (index) database connection response [26 Sep 2020 17:38:18] (index) getConnection(): Resource id #1 [26 Sep 2020 17:38:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 17:38:18] (index) database connection response [26 Sep 2020 17:38:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 17:38:18] (index) database connection response [26 Sep 2020 17:38:18] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 17:38:18] (index) database connection response [26 Sep 2020 17:38:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404707' AND ACCESS_CODE = '64155429' [26 Sep 2020 17:38:18] (index) database connection response [26 Sep 2020 17:38:18] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404707' AND ACCESS_CODE = '64155429' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 17:38:18] (index) database connection response [26 Sep 2020 17:38:18] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000635413' [26 Sep 2020 17:38:18] (index) database connection response [26 Sep 2020 17:38:18] (index) getPatientReportsDetail() entered [26 Sep 2020 17:38:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404707', 'M0100000635413', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:38:18] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404707', 'M0100000635413', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:38:18] (index) p_Stop=N [26 Sep 2020 17:38:18] (index) p_Alert= [26 Sep 2020 17:38: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 [26 Sep 2020 17:38:18] (index) database connection response [26 Sep 2020 17:38:18] (index) getConnectionClose() called.... [26 Sep 2020 17:38:18] (index) getConnectionClose() called.... [26 Sep 2020 17:39:06] (index) database connection response [26 Sep 2020 17:39:06] (index) getConnection(): Resource id #1 [26 Sep 2020 17:39:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 17:39:06] (index) database connection response [26 Sep 2020 17:39:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 17:39:06] (index) database connection response [26 Sep 2020 17:39:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 17:39:06] (index) database connection response [26 Sep 2020 17:39:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404679' AND ACCESS_CODE = '37688667' [26 Sep 2020 17:39:06] (index) database connection response [26 Sep 2020 17:39:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404679' AND ACCESS_CODE = '37688667' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 17:39:06] (index) database connection response [26 Sep 2020 17:39:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000635409' [26 Sep 2020 17:39:06] (index) database connection response [26 Sep 2020 17:39:06] (index) getPatientReportsDetail() entered [26 Sep 2020 17:39:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404679', 'M0100000635409', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:39:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404679', 'M0100000635409', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:39:06] (index) p_Stop=N [26 Sep 2020 17:39:06] (index) p_Alert= [26 Sep 2020 17:39:06] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 17:39:06] (index) database connection response [26 Sep 2020 17:39:06] (index) getConnectionClose() called.... [26 Sep 2020 17:39:06] (index) getConnectionClose() called.... [26 Sep 2020 17:40:01] (index) database connection response [26 Sep 2020 17:40:01] (index) getConnection(): Resource id #1 [26 Sep 2020 17:40:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 17:40:01] (index) database connection response [26 Sep 2020 17:40:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 17:40:01] (index) database connection response [26 Sep 2020 17:40:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 17:40:01] (index) database connection response [26 Sep 2020 17:40:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404704' AND ACCESS_CODE = '43628950' [26 Sep 2020 17:40:01] (index) database connection response [26 Sep 2020 17:40:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404704' AND ACCESS_CODE = '43628950' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 17:40:01] (index) database connection response [26 Sep 2020 17:40:01] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000635412' [26 Sep 2020 17:40:01] (index) database connection response [26 Sep 2020 17:40:01] (index) getPatientReportsDetail() entered [26 Sep 2020 17:40:01] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404704', 'M0100000635412', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:40:01] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404704', 'M0100000635412', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 17:40:01] (index) p_Stop=N [26 Sep 2020 17:40:01] (index) p_Alert= [26 Sep 2020 17:40:01] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 17:40:01] (index) database connection response [26 Sep 2020 17:40:01] (index) getConnectionClose() called.... [26 Sep 2020 17:40:01] (index) getConnectionClose() called.... [26 Sep 2020 19:03:51] (index) database connection response [26 Sep 2020 19:03:51] (index) getConnection(): Resource id #1 [26 Sep 2020 19:03:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 19:03:51] (index) database connection response [26 Sep 2020 19:03:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 19:03:51] (index) database connection response [26 Sep 2020 19:03:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 19:03:51] (index) database connection response [26 Sep 2020 19:03:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200405474' AND ACCESS_CODE = '74217304' [26 Sep 2020 19:03:51] (index) database connection response [26 Sep 2020 19:03:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200405474' AND ACCESS_CODE = '74217304' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 19:03:51] (index) database connection response [26 Sep 2020 19:03:51] (index) getConnectionClose() called.... [26 Sep 2020 19:04:35] (index) database connection response [26 Sep 2020 19:04:35] (index) getConnection(): Resource id #1 [26 Sep 2020 19:04:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 19:04:35] (index) database connection response [26 Sep 2020 19:04:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 19:04:35] (index) database connection response [26 Sep 2020 19:04:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 19:04:35] (index) database connection response [26 Sep 2020 19:04:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '03366770007' AND ACCESS_CODE = '74217304' [26 Sep 2020 19:04:35] (index) database connection response [26 Sep 2020 19:04:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '03366770007' AND ACCESS_CODE = '74217304' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 19:04:35] (index) database connection response [26 Sep 2020 19:04:35] (index) getConnectionClose() called.... [26 Sep 2020 21:07:16] (index) database connection response [26 Sep 2020 21:07:16] (index) getConnection(): Resource id #1 [26 Sep 2020 21:07:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 21:07:16] (index) database connection response [26 Sep 2020 21:07:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 21:07:16] (index) database connection response [26 Sep 2020 21:07:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 21:07:16] (index) database connection response [26 Sep 2020 21:07:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404086' AND ACCESS_CODE = '99287360' [26 Sep 2020 21:07:16] (index) database connection response [26 Sep 2020 21:07:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404086' AND ACCESS_CODE = '99287360' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 21:07:16] (index) database connection response [26 Sep 2020 21:07:16] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000635358' [26 Sep 2020 21:07:16] (index) database connection response [26 Sep 2020 21:07:16] (index) getPatientReportsDetail() entered [26 Sep 2020 21:07:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404086', 'M0100000635358', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 21:07:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404086', 'M0100000635358', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 21:07:17] (index) p_Stop=N [26 Sep 2020 21:07:17] (index) p_Alert= [26 Sep 2020 21:07:17] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 21:07:17] (index) database connection response [26 Sep 2020 21:07:17] (index) getConnectionClose() called.... [26 Sep 2020 21:07:17] (index) getConnectionClose() called.... [26 Sep 2020 21:07:39] (viewOnlineReports) database connection response [26 Sep 2020 21:07:39] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 21:07:39] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000635358', '001', '200392993', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 21:07:39] (viewOnlineReports) p_Stop=N [26 Sep 2020 21:07:39] (viewOnlineReports) p_Alert= [26 Sep 2020 21:07:39] (viewOnlineReports) Flag = 1 [26 Sep 2020 21:07:39] (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', '200392993', 'M01', '070', '1', '001000000000087630', 'M0100000635358_M01MOL20008882_1.PDF', 'M0100000635358', SYSDATE) [26 Sep 2020 21:07:39] (viewOnlineReports) database connection response [26 Sep 2020 21:07:39] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392993' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 21:07:40] (viewOnlineReports) database connection response [26 Sep 2020 21:07:40] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 21:07:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392993/ [26 Sep 2020 21:07:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392993/ [26 Sep 2020 21:07:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:07:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392993/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1601136459M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:07:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392993/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1601136459M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:07:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [26 Sep 2020 21:07:40] (viewOnlineReports) Converting PDF to JPG with name as M0100000635358_M01MOL20008882_1.jpg [26 Sep 2020 21:07:40] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200392993/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1601136459M0100000635358_M01MOL20008882_1.PDF ../../TEMP_PDF/200392993/M0100000635358_M01MOL20008882_1.jpg [26 Sep 2020 21:07:40] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200392993/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1601136459M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:07:54] (viewOnlineReports) database connection response [26 Sep 2020 21:07:54] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 21:07:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000635358', '001', '200392993', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 21:07:54] (viewOnlineReports) p_Stop=N [26 Sep 2020 21:07:54] (viewOnlineReports) p_Alert= [26 Sep 2020 21:07:54] (viewOnlineReports) Flag = 1 [26 Sep 2020 21:07:54] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392993', 'M01', '070', '1', '001000000000087630', 'M0100000635358_M01MOL20008882_1.PDF', 'M0100000635358', SYSDATE) [26 Sep 2020 21:07:54] (viewOnlineReports) database connection response [26 Sep 2020 21:07:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392993' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 21:07:54] (viewOnlineReports) database connection response [26 Sep 2020 21:07:54] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 21:07:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392993/ [26 Sep 2020 21:07:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392993/ [26 Sep 2020 21:07:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:07:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392993/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601136474M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:07:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392993/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601136474M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:07:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 21:07:54] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392993/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1601136474M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:22:02] (index) database connection response [26 Sep 2020 21:22:02] (index) getConnection(): Resource id #1 [26 Sep 2020 21:22:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 21:22:02] (index) database connection response [26 Sep 2020 21:22:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 21:22:02] (index) database connection response [26 Sep 2020 21:22:02] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 21:22:02] (index) database connection response [26 Sep 2020 21:22:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404086' AND ACCESS_CODE = '99287360' [26 Sep 2020 21:22:02] (index) database connection response [26 Sep 2020 21:22:02] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200404086' AND ACCESS_CODE = '99287360' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 21:22:02] (index) database connection response [26 Sep 2020 21:22:02] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000635358' [26 Sep 2020 21:22:02] (index) database connection response [26 Sep 2020 21:22:02] (index) getPatientReportsDetail() entered [26 Sep 2020 21:22:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404086', 'M0100000635358', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 21:22:02] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200404086', 'M0100000635358', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 21:22:02] (index) p_Stop=N [26 Sep 2020 21:22:02] (index) p_Alert= [26 Sep 2020 21:22:02] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 21:22:02] (index) database connection response [26 Sep 2020 21:22:02] (index) getConnectionClose() called.... [26 Sep 2020 21:22:02] (index) getConnectionClose() called.... [26 Sep 2020 21:22:17] (viewOnlineReports) database connection response [26 Sep 2020 21:22:17] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 21:22:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000635358', '001', '200392993', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 21:22:17] (viewOnlineReports) p_Stop=N [26 Sep 2020 21:22:17] (viewOnlineReports) p_Alert= [26 Sep 2020 21:22:17] (viewOnlineReports) Flag = 1 [26 Sep 2020 21:22:17] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392993', 'M01', '070', '1', '001000000000087630', 'M0100000635358_M01MOL20008882_1.PDF', 'M0100000635358', SYSDATE) [26 Sep 2020 21:22:17] (viewOnlineReports) database connection response [26 Sep 2020 21:22:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392993' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 21:22:17] (viewOnlineReports) database connection response [26 Sep 2020 21:22:17] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 21:22:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392993/ [26 Sep 2020 21:22:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392993/ [26 Sep 2020 21:22:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:22:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392993/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601137337M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:22:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392993/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601137337M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:22:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 21:22:17] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200392993/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1601137337M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:22:33] (viewOnlineReports) database connection response [26 Sep 2020 21:22:33] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 21:22:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000635358', '001', '200392993', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 21:22:33] (viewOnlineReports) p_Stop=N [26 Sep 2020 21:22:33] (viewOnlineReports) p_Alert= [26 Sep 2020 21:22:33] (viewOnlineReports) Flag = 1 [26 Sep 2020 21:22:33] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200392993', 'M01', '070', '1', '001000000000087630', 'M0100000635358_M01MOL20008882_1.PDF', 'M0100000635358', SYSDATE) [26 Sep 2020 21:22:33] (viewOnlineReports) database connection response [26 Sep 2020 21:22:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200392993' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [26 Sep 2020 21:22:33] (viewOnlineReports) database connection response [26 Sep 2020 21:22:33] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 21:22:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200392993/ [26 Sep 2020 21:22:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200392993/ [26 Sep 2020 21:22:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200926\M01\M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:22:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200392993/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601137353M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:22:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200392993/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601137353M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 21:22:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [26 Sep 2020 21:22:33] (viewOnlineReports) Downloading file ../../TEMP_PDF/200392993/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1601137353M0100000635358_M01MOL20008882_1.PDF [26 Sep 2020 22:21:48] (index) database connection response [26 Sep 2020 22:21:48] (index) getConnection(): Resource id #1 [26 Sep 2020 22:21:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 22:21:48] (index) database connection response [26 Sep 2020 22:21:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 22:21:48] (index) database connection response [26 Sep 2020 22:21:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 22:21:48] (index) database connection response [26 Sep 2020 22:21:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200394480' AND ACCESS_CODE = '52399806' [26 Sep 2020 22:21:48] (index) database connection response [26 Sep 2020 22:21:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200394480' AND ACCESS_CODE = '52399806' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 22:21:48] (index) database connection response [26 Sep 2020 22:21:48] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000634120' [26 Sep 2020 22:21:48] (index) database connection response [26 Sep 2020 22:21:48] (index) getPatientReportsDetail() entered [26 Sep 2020 22:21:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200394480', 'M0100000634120', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 22:21:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200394480', 'M0100000634120', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 22:21:48] (index) p_Stop=N [26 Sep 2020 22:21:48] (index) p_Alert= [26 Sep 2020 22:21:48] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 22:21:48] (index) database connection response [26 Sep 2020 22:21:48] (index) getConnectionClose() called.... [26 Sep 2020 22:21:48] (index) getConnectionClose() called.... [26 Sep 2020 22:22:02] (viewOnlineReports) database connection response [26 Sep 2020 22:22:02] (viewOnlineReports) getConnection(): Resource id #1 [26 Sep 2020 22:22:02] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000634120', '001', '200389320', '2', '001000000000086287', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 22:22:02] (viewOnlineReports) p_Stop=N [26 Sep 2020 22:22:02] (viewOnlineReports) p_Alert= [26 Sep 2020 22:22:02] (viewOnlineReports) Flag = 1 [26 Sep 2020 22:22:02] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200389320', 'M01', '001', '2', '001000000000086287', 'M0100000634120_M01SCH20009812_1.PDF', 'M0100000634120', SYSDATE) [26 Sep 2020 22:22:02] (viewOnlineReports) database connection response [26 Sep 2020 22:22:02] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200389320' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [26 Sep 2020 22:22:02] (viewOnlineReports) database connection response [26 Sep 2020 22:22:02] (viewOnlineReports) getConnectionClose() called.... [26 Sep 2020 22:22:02] (viewOnlineReports) creating directory structure../../TEMP_PDF/200389320/ [26 Sep 2020 22:22:02] (viewOnlineReports) directory structure created ../../TEMP_PDF/200389320/ [26 Sep 2020 22:22:02] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200921\M01\M0100000634120_M01SCH20009812_1.PDF [26 Sep 2020 22:22:02] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200389320/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601140922M0100000634120_M01SCH20009812_1.PDF [26 Sep 2020 22:22:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200389320/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601140922M0100000634120_M01SCH20009812_1.PDF [26 Sep 2020 22:22:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [26 Sep 2020 22:22:03] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200389320/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1601140922M0100000634120_M01SCH20009812_1.PDF [26 Sep 2020 22:48:14] (index) database connection response [26 Sep 2020 22:48:14] (index) getConnection(): Resource id #1 [26 Sep 2020 22:48:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 22:48:14] (index) database connection response [26 Sep 2020 22:48:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 22:48:14] (index) database connection response [26 Sep 2020 22:48:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 22:48:14] (index) database connection response [26 Sep 2020 22:48:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000058' AND ACCESS_CODE = 'MIH0642' [26 Sep 2020 22:48:14] (index) database connection response [26 Sep 2020 22:48:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000058' AND ACCESS_CODE = 'MIH0642' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 22:48:14] (index) database connection response [26 Sep 2020 22:48:14] (index) getConnectionClose() called.... [26 Sep 2020 22:48:37] (index) database connection response [26 Sep 2020 22:48:37] (index) getConnection(): Resource id #1 [26 Sep 2020 22:48:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 22:48:37] (index) database connection response [26 Sep 2020 22:48:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 22:48:37] (index) database connection response [26 Sep 2020 22:48:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 22:48:37] (index) database connection response [26 Sep 2020 22:48:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000058' AND ACCESS_CODE = 'APPV2' [26 Sep 2020 22:48:37] (index) database connection response [26 Sep 2020 22:48:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01600000058' AND ACCESS_CODE = 'APPV2' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 22:48:37] (index) database connection response [26 Sep 2020 22:48:37] (index) getConnectionClose() called.... [26 Sep 2020 22:50:12] (index) database connection response [26 Sep 2020 22:50:12] (index) getConnection(): Resource id #1 [26 Sep 2020 22:50:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 22:50:12] (index) database connection response [26 Sep 2020 22:50:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 22:50:12] (index) database connection response [26 Sep 2020 22:50:12] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 22:50:12] (index) database connection response [26 Sep 2020 22:50:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200401812' AND ACCESS_CODE = 'MIH0642' [26 Sep 2020 22:50:12] (index) database connection response [26 Sep 2020 22:50:12] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200401812' AND ACCESS_CODE = 'MIH0642' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 22:50:12] (index) database connection response [26 Sep 2020 22:50:12] (index) getConnectionClose() called.... [26 Sep 2020 23:08:28] (index) database connection response [26 Sep 2020 23:08:28] (index) getConnection(): Resource id #1 [26 Sep 2020 23:08:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '63' AND INSTRUCTION_TYPE = 'POP-UP' [26 Sep 2020 23:08:28] (index) database connection response [26 Sep 2020 23:08:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '63' AND INSTRUCTION_TYPE = 'PLUG-IN' [26 Sep 2020 23:08:28] (index) database connection response [26 Sep 2020 23:08:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '63' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [26 Sep 2020 23:08:28] (index) database connection response [26 Sep 2020 23:08:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200406190' AND ACCESS_CODE = '80660703' [26 Sep 2020 23:08:28] (index) database connection response [26 Sep 2020 23:08:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200406190' AND ACCESS_CODE = '80660703' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [26 Sep 2020 23:08:28] (index) database connection response [26 Sep 2020 23:08:28] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000524182' [26 Sep 2020 23:08:28] (index) database connection response [26 Sep 2020 23:08:28] (index) getPatientReportsDetail() entered [26 Sep 2020 23:08:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200406190', 'M0100000524182', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 23:08:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200406190', 'M0100000524182', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [26 Sep 2020 23:08:28] (index) p_Stop=N [26 Sep 2020 23:08:28] (index) p_Alert= [26 Sep 2020 23:08:28] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [26 Sep 2020 23:08:28] (index) database connection response [26 Sep 2020 23:08:28] (index) getConnectionClose() called.... [26 Sep 2020 23:08:28] (index) getConnectionClose() called....