APPS.CSM_COUNTER_PROPERTY_EVENT_PKG dependencies on FND_LOG

Line 48: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_INS', FND_LOG.LEVEL_PROCEDURE);

44:
45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: l_err_msg := 'Entering CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_INS' || ' for PK ' || to_char(p_counter_id);
48: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_INS', FND_LOG.LEVEL_PROCEDURE);
49:
50: -- Open USER IDs loop
51: FOR r_cntr_prp_rec IN c_property_ins(p_counter_id,p_user_id) LOOP
52: -- Call Insert ACC

Line 64: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_INS', FND_LOG.LEVEL_PROCEDURE);

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

Line 74: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_INS',FND_LOG.LEVEL_EXCEPTION);

70: END IF;
71:
72: p_error_msg := ' FAILED COUNTER_PROPERTY_INS:' || to_char(p_counter_id);
73: x_return_status := FND_API.G_RET_STS_ERROR;
74: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_INS',FND_LOG.LEVEL_EXCEPTION);
75: RAISE;
76:
77: END COUNTER_PROPERTY_INS;
78:

Line 107: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD', FND_LOG.LEVEL_PROCEDURE);

103:
104: BEGIN
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106: l_err_msg := 'Entering CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD' || ' for PK ' || to_char(p_counter_id);
107: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD', FND_LOG.LEVEL_PROCEDURE);
108:
109: -- Open USER IDs loop
110: FOR r_cntr_prp_rec IN c_property_upd(p_counter_id,p_user_id) LOOP
111: -- Call Insert ACC

Line 120: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD', FND_LOG.LEVEL_PROCEDURE);

116: , sysdate);
117: END LOOP ; --End USER IDs loop
118:
119: l_err_msg := 'Leaving CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD' || ' for Counter ' || to_char(p_counter_id);
120: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD', FND_LOG.LEVEL_PROCEDURE);
121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: IF c_property_upd%ISOPEN then

Line 130: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD',FND_LOG.LEVEL_EXCEPTION);

126: END IF;
127:
128: p_error_msg := ' FAILED COUNTER_PROPERTY_UPD FOR COUNTER : ' || to_char(p_counter_id);
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD',FND_LOG.LEVEL_EXCEPTION);
131: RAISE;
132:
133:
134: END COUNTER_PROPERTY_UPD;

Line 161: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL', FND_LOG.LEVEL_PROCEDURE);

157:
158: BEGIN
159: x_return_status := FND_API.G_RET_STS_SUCCESS;
160: l_err_msg := 'Entering CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL' || ' for PK ' || to_char(p_counter_id);
161: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL', FND_LOG.LEVEL_PROCEDURE);
162:
163: -- Open counter property id loop
164: FOR r_cntr_prp_rec IN c_property_del(p_counter_id,p_user_id) LOOP
165: -- Call Delete ACC

Line 176: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL', FND_LOG.LEVEL_PROCEDURE);

172: );
173: END LOOP ; --End USER IDs loop
174:
175: l_err_msg := 'Leaving CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL' || ' for Counter ' || to_char(p_counter_id);
176: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL', FND_LOG.LEVEL_PROCEDURE);
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: IF c_property_del%ISOPEN then

Line 186: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL',FND_LOG.LEVEL_EXCEPTION);

182: END IF;
183:
184: p_error_msg := ' FAILED COUNTER_PROPERTY_DEL FOR COUNTER : ' || to_char(p_counter_id);
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL',FND_LOG.LEVEL_EXCEPTION);
187: RAISE;
188:
189: END COUNTER_PROPERTY_DEL;
190: