DBA Data[Home] [Help]

APPS.CSM_CUSTMZ_VIEWS_EVENT_PKG dependencies on FND_LOG

Line 148: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

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;
152: CLOSE c_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 164: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

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
168: CSM_ACC_PKG.DELETE_ACC(

Line 179: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

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:
183:

Line 190: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

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
194: CSM_ACC_PKG.UPDATE_ACC(

Line 204: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

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--
208: OPEN c_insert;

Line 213: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

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
217: CSM_ACC_PKG.INSERT_ACC(

Line 229: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

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
233: SET last_run_date = sysdate

Line 243: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);

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

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 320: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

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:
324: --insert--

Line 330: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

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
334: CSM_ACC_PKG.INSERT_ACC(

Line 344: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

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:
348: END CSM_CUSTMZ_VIEWS_EVENT_PKG;