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_COUNTER_READING_EVENT_PKG

Line 1: PACKAGE BODY CSM_COUNTER_READING_EVENT_PKG AS

1: PACKAGE BODY CSM_COUNTER_READING_EVENT_PKG AS
2: /* $Header: csmecrdb.pls 120.0 2006/06/30 12:41:57 trajasek noship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 81: WHERE package_name = 'CSM_COUNTER_READING_EVENT_PKG'

77: CURSOR l_last_run_date_csr
78: IS
79: SELECT nvl(last_run_date, (sysdate - 365*50))
80: FROM jtm_con_request_data
81: WHERE package_name = 'CSM_COUNTER_READING_EVENT_PKG'
82: AND procedure_name = 'REFRESH_ACC';
83:
84: BEGIN
85:

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 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 215: WHERE package_name = 'CSM_COUNTER_READING_EVENT_PKG'

211:
212: -- update last_run_date
213: UPDATE jtm_con_request_data
214: SET last_run_date = sysdate
215: WHERE package_name = 'CSM_COUNTER_READING_EVENT_PKG'
216: AND procedure_name= 'REFRESH_ACC';
217:
218: COMMIT;
219:

Line 221: p_message := 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC Executed successfully';

217:
218: COMMIT;
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:

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 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 231: p_message := 'Error in CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;

227: WHEN others THEN
228: l_sqlerrno := to_char(SQLCODE);
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;

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 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 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 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 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 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 343: p_error_msg := 'Error in CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS :' || l_sqlerrno || ':' || l_sqlerrmsg;

339: EXCEPTION
340: WHEN others THEN
341: l_sqlerrno := to_char(SQLCODE);
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);

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 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 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 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 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 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 418: p_error_msg := 'Error in CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD :' || l_sqlerrno || ':' || l_sqlerrmsg;

414: EXCEPTION
415: WHEN others THEN
416: l_sqlerrno := to_char(SQLCODE);
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);

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;

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;

Line 425: END CSM_COUNTER_READING_EVENT_PKG;

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;