APPS.CSM_CUSTMZ_VIEWS_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 147: CSM_UTIL_PKG.LOG('Entering CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc Package ',

143: l_sqlerrmsg VARCHAR2(4000);
144: l_dummy BOOLEAN;
145: l_resource_id NUMBER;
146: BEGIN
147: CSM_UTIL_PKG.LOG('Entering CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc Package ',
148: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
149:
150: OPEN c_lastrundate;
151: FETCH c_lastrundate INTO l_lastrundate;

Line 154: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ','CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

150: OPEN c_lastrundate;
151: FETCH c_lastrundate INTO l_lastrundate;
152: CLOSE c_lastrundate;
153:
154: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ','CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
155:
156: --delete--
157:
158: OPEN c_delete;

Line 163: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',

159: FETCH c_delete BULK COLLECT INTO l_tab;
160: CLOSE c_delete;
161:
162:
163: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
164: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
165:
166: FOR I IN 1..l_tab.COUNT
167: LOOP

Line 178: CSM_UTIL_PKG.LOG('DELETION successful',

174: END LOOP;
175:
176: COMMIT;
177:
178: CSM_UTIL_PKG.LOG('DELETION successful',
179: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
180:
181: l_tab.DELETE;
182:

Line 189: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',

185: OPEN c_update(l_lastrundate.LAST_RUN_DATE);
186: FETCH c_update BULK COLLECT INTO l_tab;
187: CLOSE c_update;
188:
189: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
190: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
191:
192: FOR I IN 1..l_tab.COUNT
193: LOOP

Line 203: CSM_UTIL_PKG.LOG('UPDATE Successful ',

199: END LOOP;
200:
201: COMMIT;
202:
203: CSM_UTIL_PKG.LOG('UPDATE Successful ',
204: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
205: l_tab.DELETE;
206:
207: --insert--

Line 212: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',

208: OPEN c_insert;
209: FETCH c_insert BULK COLLECT INTO l_tab;
210: CLOSE c_insert;
211:
212: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
213: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
214:
215: FOR I IN 1..l_tab.COUNT
216: LOOP

Line 228: CSM_UTIL_PKG.LOG('INSERTION Successful ',

224: END LOOP;
225:
226: COMMIT;
227:
228: CSM_UTIL_PKG.LOG('INSERTION Successful ',
229: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
230:
231:
232: UPDATE jtm_con_request_data

Line 242: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc Package ',

238:
239: COMMIT;
240: p_status := 'FINE';
241: p_message := 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc Executed successfully';
242: CSM_UTIL_PKG.LOG('Leaving CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc Package ',
243: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
244:
245: EXCEPTION
246: WHEN others THEN

Line 251: CSM_UTIL_PKG.LOG(p_message, 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_EXCEPTION);

247: l_sqlerrno := to_char(SQLCODE);
248: l_sqlerrmsg := substr(SQLERRM, 1,2000);
249: p_status := 'ERROR';
250: p_message := 'Error in CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
251: CSM_UTIL_PKG.LOG(p_message, 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_EXCEPTION);
252: ROLLBACK;
253:
254: END Refresh_Acc;
255:

Line 319: CSM_UTIL_PKG.LOG('Entering api REFRESH_USER with user id- '||p_user_id,

315: l_tab l_tab_type;
316:
317: BEGIN
318:
319: CSM_UTIL_PKG.LOG('Entering api REFRESH_USER with user id- '||p_user_id,
320: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
321:
322: DELETE FROM CSM_CUSTOMIZATION_VIEWS_ACC WHERE USER_ID=p_user_id;
323:

Line 329: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records for user',

325: OPEN c_insert(p_user_id);
326: FETCH c_insert BULK COLLECT INTO l_tab;
327: CLOSE c_insert;
328:
329: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records for user',
330: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
331:
332: FOR I IN 1..l_tab.COUNT
333: LOOP

Line 343: CSM_UTIL_PKG.LOG('INSERTION Successful ',

339: p_pk1_name => g_cust_view_pk1_name,
340: p_pk1_num_value => l_tab(I).CUST_VIEW_ID);
341: END LOOP;
342:
343: CSM_UTIL_PKG.LOG('INSERTION Successful ',
344: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
345:
346: END REFRESH_USER;
347: