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_LOG

Line 53: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP', FND_LOG.LEVEL_PROCEDURE);

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;
56:
57: FOR r_counter_value_rec in l_counter_value_csr(p_counter_id, l_user_id) LOOP

Line 78: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP', FND_LOG.LEVEL_PROCEDURE);

74: );
75: END LOOP;
76:
77: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP' || ' for PK ' || to_char(p_counter_id);
78: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP', FND_LOG.LEVEL_PROCEDURE);
79:
80: EXCEPTION
81: WHEN others THEN
82: p_error_msg := ' FAILED COUNTER_VALS_MAKE_DIRTY_D_GRP:' || to_char(p_counter_id);

Line 84: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_EXCEPTION);

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:
88: PROCEDURE COUNTER_MDIRTY_D(p_counter_id IN NUMBER,

Line 112: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

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
115: l_user_id := r_acc_csr.user_id;
116:

Line 148: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

144:
145: END LOOP;
146:
147: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D' || ' for PK ' || to_char(p_counter_id);
148: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
149:
150: EXCEPTION
151: WHEN others THEN
152: p_error_msg := ' FAILED COUNTER_MDIRTY_D:' || to_char(p_counter_id);

Line 154: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

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:
158: PROCEDURE COUNTER_MDIRTY_D(p_counter_id IN NUMBER,

Line 169: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

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
172: CSM_ACC_PKG.Delete_Acc
173: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name

Line 192: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

188: --R12 DELETING Relationship for the counter & user
189: CSM_CNTR_RELATION_EVENT_PKG.COUNTER_RELATION_DEL(p_counter_id,p_user_id);
190:
191: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D' || ' for PK ' || to_char(p_counter_id);
192: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
193:
194: EXCEPTION
195: WHEN others THEN
196: p_error_msg := ' FAILED COUNTER_MDIRTY_D:' || to_char(p_counter_id);

Line 198: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

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:
202: PROCEDURE COUNTER_VALS_MAKE_DIRTY_D_GRP (p_counter_id IN NUMBER,

Line 236: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP', FND_LOG.LEVEL_PROCEDURE);

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;
239:
240: FOR r_counter_value_rec in l_counter_value_csr(p_counter_id, p_instance_id, l_user_id) LOOP

Line 261: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP', FND_LOG.LEVEL_PROCEDURE);

257:
258: END LOOP;
259:
260: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP' || ' for PK ' || to_char(p_counter_id);
261: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP', FND_LOG.LEVEL_PROCEDURE);
262:
263: EXCEPTION
264: WHEN others THEN
265: p_error_msg := ' FAILED COUNTER_VALS_MAKE_DIRTY_D_GRP:' || to_char(p_counter_id);

Line 267: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_EXCEPTION);

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:
271: PROCEDURE CTR_MAKE_DIRTY_U_FOREACHUSER(p_counter_id IN NUMBER,

Line 294: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

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
297:
298: l_publication_item_name := 'CSF_M_COUNTERS';

Line 327: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

323:
324: END LOOP ; --end user ids cursor loop
325:
326: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_U_FOREACHUSER' || ' for PK ' || to_char(p_counter_id);
327: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: if l_user_ids_csr%isopen then

Line 337: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_U_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);

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:
341: PROCEDURE CTR_MAKE_DIRTY_I_FOREACHUSER(p_counter_id IN NUMBER,

Line 371: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

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
374: FOR r_user_id_rec IN l_user_ids_csr(p_counter_id) LOOP
375: -- Call Insert ACC

Line 398: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

394:
395: END LOOP ; --End USER IDs loop
396:
397: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER' || ' for PK ' || to_char(p_counter_id);
398: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
399:
400: EXCEPTION
401: WHEN OTHERS THEN
402: IF l_user_ids_csr%ISOPEN then

Line 408: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);

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:
412: PROCEDURE CTR_VAL_MAKE_DIRTY_FOREACHUSER(p_ctr_grp_log_id cs_counter_grp_log.counter_grp_log_id%type,

Line 478: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

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
481: l_user_id := r_user_id_rec.user_id;
482: l_counter_value_id := r_user_id_rec.counter_value_id;

Line 538: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

534:
535: END LOOP ; --End USER IDs cursor loop
536:
537: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER' || ' for cnt_grp_log_id ' || to_char(p_ctr_grp_log_id);
538: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
539:
540: EXCEPTION
541: WHEN OTHERS THEN
542: IF l_user_ids_csr%ISOPEN THEN

Line 552: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MAKE_DIRTY_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);

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:
556: PROCEDURE CTR_VAL_MDIRTY_U_FOREACHUSER(p_ctr_grp_log_id cs_counter_grp_log.counter_grp_log_id%type,

Line 584: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MDIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

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';
587: l_dmllist := CSM_UTIL_PKG.GetAsgDmlConstant(ASG_DOWNLOAD.UPD);
588: l_counter_value_count := 0;

Line 621: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MDIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

617:
618: END LOOP;
619:
620: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.CTR_VAL_MDIRTY_U_FOREACHUSER' || ' for cnt_grp_log_id ' || to_char(p_ctr_grp_log_id);
621: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MDIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
622:
623: EXCEPTION
624: WHEN OTHERS THEN
625: IF l_user_ids_csr%ISOPEN then

Line 631: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.CTR_VAL_MDIRTY_U_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);

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:
635: PROCEDURE COUNTER_MDIRTY_I(p_counter_id IN NUMBER,

Line 646: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I', FND_LOG.LEVEL_PROCEDURE);

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
649: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
650: ,P_ACC_TABLE_NAME => g_counters_acc_table_name

Line 670: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I', FND_LOG.LEVEL_PROCEDURE);

666: );
667:
668:
669: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I' || ' for cnt_id ' || to_char(p_counter_id);
670: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I', FND_LOG.LEVEL_PROCEDURE);
671:
672: EXCEPTION
673: WHEN others THEN
674: p_error_msg := ' FAILED COUNTER_MDIRTY_I:' || to_char(p_counter_id);

Line 676: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

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:
680: PROCEDURE COUNTER_VALS_MAKE_DIRTY_I_GRP(p_counter_id IN NUMBER,

Line 715: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_I_GRP', FND_LOG.LEVEL_PROCEDURE);

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);
718: LOOP
719: FETCH l_counter_value_csr INTO r_counter_value_rec;

Line 748: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_I_GRP', FND_LOG.LEVEL_PROCEDURE);

744: CLOSE l_counter_value_csr;
745: END IF;
746:
747: l_err_msg := 'Leaving CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_I_GRP' || ' for cnt_id ' || to_char(p_counter_id);
748: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_I_GRP', FND_LOG.LEVEL_PROCEDURE);
749:
750: EXCEPTION
751: WHEN others THEN
752: IF l_counter_value_csr%ISOPEN THEN

Line 757: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_VALS_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_EXCEPTION);

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:
761: END CSM_COUNTER_EVENT_PKG; -- of package csm_counter_event_pkg