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_CTR_PROP_READ_EVENT_PKG

Line 1: PACKAGE BODY CSM_CTR_PROP_READ_EVENT_PKG AS

1: PACKAGE BODY CSM_CTR_PROP_READ_EVENT_PKG AS
2: /* $Header: csmecprb.pls 120.2 2006/07/26 09:29:07 trajasek noship $ */
3:
4: --
5: -- Purpose: USed to downlaod Counter properties for each counter

Line 46: l_err_msg := 'Entering CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS' || ' for PK ' || to_char(p_counter_value_id);

42: l_err_msg VARCHAR2(4000);
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

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 62: l_err_msg := 'Leaving CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS' || ' for Counter ' || to_char(p_counter_value_id);

58: ,P_USER_ID => p_user_id
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

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 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);

101: l_pub_item_name VARCHAR2(240) := 'CSM_COUNTER_PROP_VALUES';
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

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 118: l_err_msg := 'Leaving CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD' || ' for Counter value ' || to_char(p_counter_value_id);

114: , 'U'
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

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 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);

155: l_err_msg VARCHAR2(4000);
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

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 174: l_err_msg := 'Leaving CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL' || ' for Counter value' || to_char(p_counter_value_id);

170: ,P_USER_ID => p_user_id
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

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 246: WHERE package_name = 'CSM_CTR_PROP_READ_EVENT_PKG'

242: CURSOR l_last_run_date_csr
243: IS
244: SELECT nvl(last_run_date, (sysdate - 365*50))
245: FROM jtm_con_request_data
246: WHERE package_name = 'CSM_CTR_PROP_READ_EVENT_PKG'
247: AND procedure_name = 'REFRESH_ACC';
248:
249: BEGIN
250:

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 252: 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);

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;
256: FETCH l_last_run_date_csr INTO l_prog_update_date;

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 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 341: WHERE package_name = 'CSM_CTR_PROP_READ_EVENT_PKG'

337:
338: -- update last_run_date
339: UPDATE jtm_con_request_data
340: SET last_run_date = sysdate
341: WHERE package_name = 'CSM_CTR_PROP_READ_EVENT_PKG'
342: AND procedure_name= 'REFRESH_ACC';
343:
344: COMMIT;
345:

Line 347: p_message := 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC Executed successfully';

343:
344: COMMIT;
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:

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 350: 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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
354: l_sqlerrno := to_char(SQLCODE);

Line 357: p_message := 'Error in CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;

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

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:

Line 360: 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);

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:
364: END CSM_CTR_PROP_READ_EVENT_PKG; -- Package spec of CSM_CTR_PROP_READ_EVENT_PKG

Line 364: END CSM_CTR_PROP_READ_EVENT_PKG; -- Package spec of CSM_CTR_PROP_READ_EVENT_PKG

360: 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
361: END REFRESH_ACC;
362:
363:
364: END CSM_CTR_PROP_READ_EVENT_PKG; -- Package spec of CSM_CTR_PROP_READ_EVENT_PKG