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 CSM_UTIL_PKG

Line 86: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC ',

82: AND procedure_name = 'REFRESH_ACC';
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;

Line 100: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;

96: END IF;
97:
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

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 112: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

108:
109: --mark dirty for delete
110: IF l_access_list.count > 0 THEN
111: FOR i IN 1..l_access_list.count LOOP
112: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
113: l_access_list(i),
114: l_user_list(i),
115: asg_download.del,
116: sysdate);

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 137: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

133: CLOSE csr_ctr_reading_upd;
134:
135: IF l_access_list.count > 0 THEN
136: FOR i IN 1..l_access_list.count LOOP
137: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
138: l_access_list(i),
139: l_user_list(i),
140: asg_download.upd,
141: sysdate);

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 173: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

169: CLOSE csr_ctr_reading_ins;
170:
171: IF l_access_list.count > 0 THEN
172: FOR i IN 1..l_access_list.count LOOP
173: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
174: l_access_list(i),
175: l_user_list(i),
176: asg_download.ins,
177: sysdate);

Line 223: CSM_UTIL_PKG.LOG('Leaving CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC ',

219:
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

Line 233: CSM_UTIL_PKG.LOG('Exception in CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,

229: l_sqlerrmsg := substr(SQLERRM, 1,2000);
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,

Line 275: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS ',

271: AND val_acc.user_id =cnt_acc.user_id);
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;

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 295: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

291: CLOSE csr_ctr_reading_ins;
292:
293: IF l_access_list.count > 0 THEN
294: FOR i IN 1..l_access_list.count LOOP
295: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
296: l_access_list(i),
297: l_user_list(i),
298: asg_download.ins,
299: sysdate);

Line 334: CSM_UTIL_PKG.LOG('Leaving CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS ',

330: l_access_list.delete;
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:

Line 346: CSM_UTIL_PKG.LOG('Exception in CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS: ' || l_sqlerrno || ':' || l_sqlerrmsg,

342: l_sqlerrmsg := substr(SQLERRM, 1,2000);
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:

Line 379: CSM_UTIL_PKG.LOG('Entering CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD ',

375: WHERE val_acc.counter_value_id =c_counter_value_id;
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;

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 397: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

393: CLOSE csr_ctr_reading_upd;
394:
395: IF l_access_list.count > 0 THEN
396: FOR i IN 1..l_access_list.count LOOP
397: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
398: l_access_list(i),
399: l_user_list(i),
400: asg_download.ins,
401: sysdate);

Line 409: CSM_UTIL_PKG.LOG('Leaving CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD ',

405: l_access_list.delete;
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:

Line 421: CSM_UTIL_PKG.LOG('Exception in CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD: ' || l_sqlerrno || ':' || l_sqlerrmsg,

417: l_sqlerrmsg := substr(SQLERRM, 1,2000);
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;