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_EVENT_PKG dependencies on FND_API

Line 51: x_return_status := FND_API.G_RET_STS_SUCCESS;

47: AND acc.counter_value_id = cval.counter_value_id
48: AND cval.counter_id = p_counter_id;
49:
50: BEGIN
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP' || ' for PK ' || to_char(p_counter_id);
53: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP', FND_LOG.LEVEL_PROCEDURE);
54:
55: l_user_id := p_user_id;

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79:
80: EXCEPTION
81: WHEN others THEN
82: p_error_msg := ' FAILED COUNTER_VALS_MAKE_DIRTY_D_GRP:' || to_char(p_counter_id);
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_EXCEPTION);
85: -- RAISE;
86: END COUNTER_VALS_MAKE_DIRTY_D_GRP;
87:

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: AND counters.counter_id = b_counter_id
107: AND counter_groups.counter_group_id(+) = counters.group_id;
108:
109: BEGIN
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D' || ' for PK ' || to_char(p_counter_id);
112: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
113:
114: FOR r_acc_csr IN l_acc_csr(p_counter_id) LOOP

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

149:
150: EXCEPTION
151: WHEN others THEN
152: p_error_msg := ' FAILED COUNTER_MDIRTY_D:' || to_char(p_counter_id);
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
155: RAISE;
156: END COUNTER_MDIRTY_D;
157:

Line 167: x_return_status := FND_API.G_RET_STS_SUCCESS;

163: l_err_msg VARCHAR2(4000);
164: l_user_id NUMBER;
165:
166: BEGIN
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D' || ' for PK ' || to_char(p_counter_id);
169: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
170:
171: -- delete counter for the user

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193:
194: EXCEPTION
195: WHEN others THEN
196: p_error_msg := ' FAILED COUNTER_MDIRTY_D:' || to_char(p_counter_id);
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
199: RAISE;
200: END COUNTER_MDIRTY_D;
201:

Line 234: x_return_status := FND_API.G_RET_STS_SUCCESS;

230: AND vacc.user_id = acc.user_id
231: );
232:
233: BEGIN
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP' || ' for PK ' || to_char(p_counter_id);
236: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP', FND_LOG.LEVEL_PROCEDURE);
237:
238: l_user_id := p_user_id;

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262:
263: EXCEPTION
264: WHEN others THEN
265: p_error_msg := ' FAILED COUNTER_VALS_MAKE_DIRTY_D_GRP:' || to_char(p_counter_id);
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_EXCEPTION);
268: -- RAISE;
269: END COUNTER_VALS_MAKE_DIRTY_D_GRP;
270:

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288: FROM csm_counters_acc acc
289: WHERE acc.counter_id = p_counter_id;
290:
291: BEGIN
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_U_FOREACHUSER' || ' for PK ' || to_char(p_counter_id);
294: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
295:
296: FOR r_user_id_rec in l_user_ids_csr(p_counter_id) LOOP

Line 336: x_return_status := FND_API.G_RET_STS_ERROR;

332: close l_user_ids_csr;
333: end if ; -- cursor
334:
335: p_error_msg := ' FAILED CTR_MAKE_DIRTY_U_FOREACHUSER:' || to_char(p_counter_id);
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_U_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
338: RAISE;
339: END CTR_MAKE_DIRTY_U_FOREACHUSER;
340:

Line 369: x_return_status := FND_API.G_RET_STS_SUCCESS;

365: AND cas.source_object_id = acc.instance_id
366: AND ctr.counter_id = p_counter_id;
367:
368: BEGIN
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER' || ' for PK ' || to_char(p_counter_id);
371: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
372:
373: -- Open USER IDs loop

Line 407: x_return_status := FND_API.G_RET_STS_ERROR;

403: CLOSE l_user_ids_csr;
404: END IF;
405:
406: p_error_msg := ' FAILED CTR_MAKE_DIRTY_I_FOREACHUSER:' || to_char(p_counter_id);
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
409: RAISE;
410: END CTR_MAKE_DIRTY_I_FOREACHUSER;
411:

Line 476: x_return_status := FND_API.G_RET_STS_SUCCESS;

472:
473: l_max_counter_readings_rec l_max_counter_readings_csr%ROWTYPE;
474:
475: BEGIN
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER' || ' for cnt_grp_log_id ' || to_char(p_ctr_grp_log_id);
478: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
479:
480: FOR r_user_id_rec IN l_user_ids_csr(p_ctr_grp_log_id) LOOP

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547: CLOSE l_max_counter_readings_csr;
548: END IF;
549:
550: p_error_msg := ' FAILED CTR_VAL_MAKE_DIRTY_FOREACHUSER ctr_grp_log_id:' || to_char(p_ctr_grp_log_id);
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
553: RAISE;
554: END CTR_VAL_MAKE_DIRTY_FOREACHUSER;
555:

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS;

578: WHERE acc.counter_value_id = cv.counter_value_id
579: AND cv.transaction_id = p_counter_grp_log_id;
580:
581: BEGIN
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.CTR_VAL_MDIRTY_U_FOREACHUSER' || ' for cnt_grp_log_id ' || to_char(p_ctr_grp_log_id);
584: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MDIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
585:
586: l_publication_item_name := 'CSF_M_COUNTER_VALUES';

Line 630: x_return_status := FND_API.G_RET_STS_ERROR;

626: CLOSE l_user_ids_csr;
627: END IF;
628:
629: p_error_msg := ' FAILED CTR_VAL_MDIRTY_U_FOREACHUSER ctr_grp_log_id:' || to_char(p_ctr_grp_log_id);
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MDIRTY_U_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
632: RAISE;
633: END CTR_VAL_MDIRTY_U_FOREACHUSER;
634:

Line 644: x_return_status := FND_API.G_RET_STS_SUCCESS;

640: l_err_msg VARCHAR2(4000);
641: l_user_id NUMBER;
642:
643: BEGIN
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I' || ' for cnt_id ' || to_char(p_counter_id);
646: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I', FND_LOG.LEVEL_PROCEDURE);
647:
648: CSM_ACC_PKG.Insert_Acc

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671:
672: EXCEPTION
673: WHEN others THEN
674: p_error_msg := ' FAILED COUNTER_MDIRTY_I:' || to_char(p_counter_id);
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
677: RAISE;
678: END COUNTER_MDIRTY_I;
679:

Line 713: x_return_status := FND_API.G_RET_STS_SUCCESS;

709:
710: r_counter_value_rec l_counter_value_csr%ROWTYPE;
711:
712: BEGIN
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_I_GRP' || ' for cnt_id ' || to_char(p_counter_id);
715: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_I_GRP', FND_LOG.LEVEL_PROCEDURE);
716:
717: OPEN l_counter_value_csr(p_counter_id, p_instance_id, p_user_id);

Line 756: x_return_status := FND_API.G_RET_STS_ERROR;

752: IF l_counter_value_csr%ISOPEN THEN
753: CLOSE l_counter_value_csr;
754: END IF;
755: p_error_msg := ' FAILED COUNTER_VALS_MAKE_DIRTY_I_GRP:' || to_char(p_counter_id);
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_EXCEPTION);
758: RAISE;
759: END COUNTER_VALS_MAKE_DIRTY_I_GRP;
760: