eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_COUNTER_READING_EVENT_PKG dependencies on FND_LOG

Line 87: 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);

83:
84: BEGIN
85:
86: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC ',
87: 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);
88:
89: -- get last conc program update date
90: OPEN l_last_run_date_csr;
91: FETCH l_last_run_date_csr INTO l_prog_update_date;

Line 102: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);

98: -- get resource list of all omfs users
99: l_all_omfs_resource_list := l_null_omfs_resource_list;
100: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
101:
102: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
103:
104: -- process all deletes
105: OPEN csr_ctr_reading_del;
106: FETCH csr_ctr_reading_del BULK COLLECT INTO l_access_list,l_user_list;

Line 127: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

123:
124: l_access_list.delete;
125: END IF; -- end of process deletes
126:
127: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
128:
129:
130: -- process all updates
131: OPEN csr_ctr_reading_upd(l_prog_update_date);

Line 164: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

160: IF l_access_list.count > 0 THEN
161: l_access_list.delete;
162: END IF;
163:
164: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
165:
166: --process all inserts
167: OPEN csr_ctr_reading_ins;
168: FETCH csr_ctr_reading_ins BULK COLLECT INTO l_access_list, l_counter_value_id_tbl, l_counter_id_tbl, l_user_list;

Line 224: 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

220: p_status := 'FINE';
221: p_message := 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC Executed successfully';
222:
223: CSM_UTIL_PKG.LOG('Leaving CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC ',
224: 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
225:
226: EXCEPTION
227: WHEN others THEN
228: l_sqlerrno := to_char(SQLCODE);

Line 234: 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);

230: p_status := 'Error';
231: p_message := 'Error in CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
232: ROLLBACK;
233: CSM_UTIL_PKG.LOG('Exception in CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
234: 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
235: END REFRESH_ACC;
236:
237: PROCEDURE COUNTER_VALUE_ACC_INS(p_counter_value_id IN NUMBER,
238: p_counter_id IN NUMBER,

Line 276: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS', FND_LOG.LEVEL_PROCEDURE);

272:
273: BEGIN
274:
275: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS ',
276: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS', FND_LOG.LEVEL_PROCEDURE);
277:
278: IF l_access_list.count > 0 THEN
279: l_access_list.delete;
280: l_counter_value_id_tbl.delete;

Line 286: CSM_UTIL_PKG.LOG('Entering Insert ', 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS',FND_LOG.LEVEL_STATEMENT);

282: l_user_list.delete;
283: END IF;
284:
285:
286: CSM_UTIL_PKG.LOG('Entering Insert ', 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS',FND_LOG.LEVEL_STATEMENT);
287:
288: --process all inserts
289: OPEN csr_ctr_reading_ins(p_counter_value_id,p_counter_id);
290: FETCH csr_ctr_reading_ins BULK COLLECT INTO l_access_list, l_counter_value_id_tbl, l_counter_id_tbl, l_user_list;

Line 335: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS',FND_LOG.LEVEL_PROCEDURE);

331:
332: END IF; -- end of process insert
333:
334: CSM_UTIL_PKG.LOG('Leaving CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS ',
335: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS',FND_LOG.LEVEL_PROCEDURE);
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338:
339: EXCEPTION

Line 347: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS',FND_LOG.LEVEL_EXCEPTION);

343: p_error_msg := 'Error in CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS :' || l_sqlerrno || ':' || l_sqlerrmsg;
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: RAISE;
346: CSM_UTIL_PKG.LOG('Exception in CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS: ' || l_sqlerrno || ':' || l_sqlerrmsg,
347: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS',FND_LOG.LEVEL_EXCEPTION);
348: END COUNTER_VALUE_ACC_INS;
349:
350:
351:

Line 380: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD', FND_LOG.LEVEL_PROCEDURE);

376:
377: BEGIN
378:
379: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD ',
380: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD', FND_LOG.LEVEL_PROCEDURE);
381:
382: IF l_access_list.count > 0 THEN
383: l_access_list.delete;
384: l_user_list.delete;

Line 388: CSM_UTIL_PKG.LOG('Entering Update Counter Value id ', 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD',FND_LOG.LEVEL_STATEMENT);

384: l_user_list.delete;
385: END IF;
386:
387:
388: CSM_UTIL_PKG.LOG('Entering Update Counter Value id ', 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD',FND_LOG.LEVEL_STATEMENT);
389:
390: --process all inserts
391: OPEN csr_ctr_reading_upd(p_counter_value_id);
392: FETCH csr_ctr_reading_upd BULK COLLECT INTO l_access_list,l_user_list;

Line 410: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD',FND_LOG.LEVEL_PROCEDURE);

406:
407: END IF; -- end of process insert
408:
409: CSM_UTIL_PKG.LOG('Leaving CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD ',
410: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD',FND_LOG.LEVEL_PROCEDURE);
411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412:
413:
414: EXCEPTION

Line 422: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD',FND_LOG.LEVEL_EXCEPTION);

418: p_error_msg := 'Error in CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD :' || l_sqlerrno || ':' || l_sqlerrmsg;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: RAISE;
421: CSM_UTIL_PKG.LOG('Exception in CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD: ' || l_sqlerrno || ':' || l_sqlerrmsg,
422: 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD',FND_LOG.LEVEL_EXCEPTION);
423: END COUNTER_VALUE_ACC_UPD;
424:
425: END CSM_COUNTER_READING_EVENT_PKG;