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_CUSTMZ_VIEWS_EVENT_PKG dependencies on CSM_CUSTMZ_VIEWS_EVENT_PKG

Line 1: PACKAGE BODY CSM_CUSTMZ_VIEWS_EVENT_PKG AS

1: PACKAGE BODY CSM_CUSTMZ_VIEWS_EVENT_PKG AS
2: /* $Header: csmeczvb.pls 120.8.12010000.2 2008/10/22 12:44:36 trajasek ship $ */
3:
4: /*** Globals ***/
5: g_cust_view_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS_ACC';

Line 12: g_cust_view_pkg_name CONSTANT VARCHAR2(30) := 'CSM_CUSTMZ_VIEWS_EVENT_PKG';

8: g_cust_view_pk1_name CONSTANT VARCHAR2(30) := 'CUST_VIEW_ID';
9: g_cust_view_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
10: CSM_ACC_PKG.t_publication_item_list('CSM_CUSTOMIZATION_VIEWS');
11:
12: g_cust_view_pkg_name CONSTANT VARCHAR2(30) := 'CSM_CUSTMZ_VIEWS_EVENT_PKG';
13: g_cust_view_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
14:
15:
16: PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2,

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 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 241: p_message := 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc Executed successfully';

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

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 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 250: p_message := 'Error in CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;

246: WHEN others THEN
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;

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;

Line 348: END CSM_CUSTMZ_VIEWS_EVENT_PKG;

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;