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_CTR_PROP_READ_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 47: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS', FND_LOG.LEVEL_PROCEDURE);

43:
44: BEGIN
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46: l_err_msg := 'Entering CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS' || ' for PK ' || to_char(p_counter_value_id);
47: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS', FND_LOG.LEVEL_PROCEDURE);
48:
49: -- Open USER IDs loop
50: FOR r_cntr_prp_val_rec IN c_prop_value_ins(p_counter_value_id,p_user_id) LOOP
51: -- Call Insert ACC

Line 63: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS', FND_LOG.LEVEL_PROCEDURE);

59: );
60: END LOOP ; --End USER IDs loop
61:
62: l_err_msg := 'Leaving CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS' || ' for Counter ' || to_char(p_counter_value_id);
63: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS', FND_LOG.LEVEL_PROCEDURE);
64:
65: EXCEPTION
66: WHEN OTHERS THEN
67: IF c_prop_value_ins%ISOPEN then

Line 73: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS',FND_LOG.LEVEL_EXCEPTION);

69: END IF;
70:
71: p_error_msg := ' FAILED CTR_PROPERTY_READ_INS FOR COUNTER VALUE:' || to_char(p_counter_value_id);
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS',FND_LOG.LEVEL_EXCEPTION);
74: RAISE;
75:
76: END CTR_PROPERTY_READ_INS;
77:

Line 106: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD', FND_LOG.LEVEL_PROCEDURE);

102:
103: BEGIN
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: l_err_msg := 'Entering CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD' || ' for PK(COUNTER VALUE ID) ' || to_char(p_counter_value_id);
106: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD', FND_LOG.LEVEL_PROCEDURE);
107:
108: -- Open USER IDs loop
109: FOR r_cntr_prp_val_rec IN c_prop_value_upd(p_counter_value_id,p_user_id) LOOP
110: -- Call Insert ACC

Line 111: l_markdirty := csm_util_pkg.MakeDirtyForUser ( l_pub_item_name

107:
108: -- Open USER IDs loop
109: FOR r_cntr_prp_val_rec IN c_prop_value_upd(p_counter_value_id,p_user_id) LOOP
110: -- Call Insert ACC
111: l_markdirty := csm_util_pkg.MakeDirtyForUser ( l_pub_item_name
112: , r_cntr_prp_val_rec.access_id
113: , r_cntr_prp_val_rec.user_id
114: , 'U'
115: , sysdate);

Line 119: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD', FND_LOG.LEVEL_PROCEDURE);

115: , sysdate);
116: END LOOP ; --End USER IDs loop
117:
118: l_err_msg := 'Leaving CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD' || ' for Counter value ' || to_char(p_counter_value_id);
119: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD', FND_LOG.LEVEL_PROCEDURE);
120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: IF c_prop_value_upd%ISOPEN then

Line 129: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD',FND_LOG.LEVEL_EXCEPTION);

125: END IF;
126:
127: p_error_msg := ' FAILED CTR_PROPERTY_READ_UPD FOR COUNTER VALUE ID : ' || to_char(p_counter_value_id);
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD',FND_LOG.LEVEL_EXCEPTION);
130: RAISE;
131:
132:
133: END CTR_PROPERTY_READ_UPD;

Line 160: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL', FND_LOG.LEVEL_PROCEDURE);

156:
157: BEGIN
158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159: l_err_msg := 'Entering CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL' || ' for PK(COUNTER VALUE ID ' || to_char(p_counter_value_id);
160: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL', FND_LOG.LEVEL_PROCEDURE);
161:
162: -- Open counter property id loop
163: FOR r_cntr_prp_val_rec IN c_prop_value_del(p_counter_value_id,p_user_id) LOOP
164: -- Call Delete ACC

Line 175: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL', FND_LOG.LEVEL_PROCEDURE);

171: );
172: END LOOP ; --End USER IDs loop
173:
174: l_err_msg := 'Leaving CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL' || ' for Counter value' || to_char(p_counter_value_id);
175: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL', FND_LOG.LEVEL_PROCEDURE);
176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: IF c_prop_value_del%ISOPEN then

Line 185: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL',FND_LOG.LEVEL_EXCEPTION);

181: END IF;
182:
183: p_error_msg := ' FAILED CTR_PROPERTY_READ_DEL FOR COUNTER VALUE ID : ' || to_char(p_counter_value_id);
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL',FND_LOG.LEVEL_EXCEPTION);
186: RAISE;
187:
188: END CTR_PROPERTY_READ_DEL;
189:

Line 251: CSM_UTIL_PKG.LOG('Entering CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC ',

247: AND procedure_name = 'REFRESH_ACC';
248:
249: BEGIN
250:
251: CSM_UTIL_PKG.LOG('Entering CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC ',
252: 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);
253:
254: -- get last conc program update date
255: OPEN l_last_run_date_csr;

Line 265: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;

261: END IF;
262:
263: -- get resource list of all omfs users
264: l_all_omfs_resource_list := l_null_omfs_resource_list;
265: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
266:
267: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
268:
269: -- process all deletes

Line 267: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);

263: -- get resource list of all omfs users
264: l_all_omfs_resource_list := l_null_omfs_resource_list;
265: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
266:
267: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
268:
269: -- process all deletes
270: OPEN csr_ctr_prop_reading_del;
271: FETCH csr_ctr_prop_reading_del BULK COLLECT INTO l_access_list,l_user_list;

Line 277: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

273:
274: --mark dirty for delete
275: IF l_access_list.count > 0 THEN
276: FOR i IN 1..l_access_list.count LOOP
277: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
278: l_access_list(i),
279: l_user_list(i),
280: asg_download.del,
281: sysdate);

Line 293: CSM_UTIL_PKG.LOG('Leaving DELETE and entering inserts', 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

289: l_access_list.delete;
290: END IF; -- end of process deletes
291:
292:
293: CSM_UTIL_PKG.LOG('Leaving DELETE and entering inserts', 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
294:
295: --process all inserts
296: OPEN csr_ctr_prop_reading_ins (l_prog_update_date);
297: FETCH csr_ctr_prop_reading_ins BULK COLLECT INTO l_access_list, l_counter_prop_value_id_tbl,l_user_list;

Line 302: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,

298: CLOSE csr_ctr_prop_reading_ins;
299:
300: IF l_access_list.count > 0 THEN
301: FOR i IN 1..l_access_list.count LOOP
302: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
303: l_access_list(i),
304: l_user_list(i),
305: asg_download.ins,
306: sysdate);

Line 349: CSM_UTIL_PKG.LOG('Leaving CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC ',

345:
346: p_status := 'FINE';
347: p_message := 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC Executed successfully';
348:
349: CSM_UTIL_PKG.LOG('Leaving CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC ',
350: 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
351:
352: EXCEPTION
353: WHEN others THEN

Line 359: CSM_UTIL_PKG.LOG('Exception in CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,

355: l_sqlerrmsg := substr(SQLERRM, 1,2000);
356: p_status := 'Error';
357: p_message := 'Error in CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
358: ROLLBACK;
359: CSM_UTIL_PKG.LOG('Exception in CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
360: 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
361: END REFRESH_ACC;
362:
363: