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_RESCODE_MAPPING_EVENT_PKG dependencies on CSM_RESCODE_MAPPING_EVENT_PKG

Line 1: PACKAGE BODY CSM_RESCODE_MAPPING_EVENT_PKG AS

1: PACKAGE BODY CSM_RESCODE_MAPPING_EVENT_PKG AS
2: /* $Header: csmercmb.pls 120.0 2005/11/14 09:11:21 trajasek noship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 68: WHERE package_name = 'CSM_RESCODE_MAPPING_EVENT_PKG'

64: CURSOR l_last_run_date_csr
65: IS
66: SELECT nvl(last_run_date, (sysdate - 365*50))
67: FROM jtm_con_request_data
68: WHERE package_name = 'CSM_RESCODE_MAPPING_EVENT_PKG'
69: AND procedure_name = 'REFRESH_ACC';
70:
71: BEGIN
72:

Line 73: CSM_UTIL_PKG.LOG('Entering CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',

69: AND procedure_name = 'REFRESH_ACC';
70:
71: BEGIN
72:
73: CSM_UTIL_PKG.LOG('Entering CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',
74: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);
75:
76: -- get last conc program update date
77: OPEN l_last_run_date_csr;

Line 74: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);

70:
71: BEGIN
72:
73: CSM_UTIL_PKG.LOG('Entering CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',
74: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);
75:
76: -- get last conc program update date
77: OPEN l_last_run_date_csr;
78: FETCH l_last_run_date_csr INTO l_prog_update_date;

Line 89: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);

85: -- get resource list of all omfs users
86: l_all_omfs_resource_list := l_null_omfs_resource_list;
87: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
88:
89: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
90:
91: -- process all deletes
92: OPEN csr_rescode_map_del;
93: FETCH csr_rescode_map_del BULK COLLECT INTO l_map_access_list;

Line 116: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

112:
113: l_map_access_list.delete;
114: END IF; -- end of process deletes
115:
116: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
117:
118:
119: -- process all updates
120: OPEN csr_rescode_map_upd(l_prog_update_date);

Line 143: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

139: IF l_resol_map_id_tbl.count > 0 THEN
140: l_resol_map_id_tbl.delete;
141: END IF;
142:
143: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
144:
145: --process all inserts
146: OPEN csr_rescode_map_ins;
147: FETCH csr_rescode_map_ins BULK COLLECT INTO l_map_access_list, l_resol_map_id_tbl;

Line 185: WHERE package_name = 'CSM_RESCODE_MAPPING_EVENT_PKG'

181:
182: -- update last_run_date
183: UPDATE jtm_con_request_data
184: SET last_run_date = sysdate
185: WHERE package_name = 'CSM_RESCODE_MAPPING_EVENT_PKG'
186: AND procedure_name= 'REFRESH_ACC';
187:
188: COMMIT;
189:

Line 191: p_message := 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC Executed successfully';

187:
188: COMMIT;
189:
190: p_status := 'FINE';
191: p_message := 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC Executed successfully';
192:
193: CSM_UTIL_PKG.LOG('Leaving CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',
194: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
195:

Line 193: CSM_UTIL_PKG.LOG('Leaving CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',

189:
190: p_status := 'FINE';
191: p_message := 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC Executed successfully';
192:
193: CSM_UTIL_PKG.LOG('Leaving CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',
194: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
195:
196: EXCEPTION
197: WHEN others THEN

Line 194: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

190: p_status := 'FINE';
191: p_message := 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC Executed successfully';
192:
193: CSM_UTIL_PKG.LOG('Leaving CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC ',
194: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
195:
196: EXCEPTION
197: WHEN others THEN
198: l_sqlerrno := to_char(SQLCODE);

Line 201: p_message := 'Error in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;

197: WHEN others THEN
198: l_sqlerrno := to_char(SQLCODE);
199: l_sqlerrmsg := substr(SQLERRM, 1,2000);
200: p_status := 'Error';
201: p_message := 'Error in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
202: ROLLBACK;
203: CSM_UTIL_PKG.LOG('Exception in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
204: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
205: END REFRESH_ACC;

Line 203: CSM_UTIL_PKG.LOG('Exception in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,

199: l_sqlerrmsg := substr(SQLERRM, 1,2000);
200: p_status := 'Error';
201: p_message := 'Error in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
202: ROLLBACK;
203: CSM_UTIL_PKG.LOG('Exception in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
204: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
205: END REFRESH_ACC;
206:
207: END CSM_RESCODE_MAPPING_EVENT_PKG;

Line 204: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);

200: p_status := 'Error';
201: p_message := 'Error in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
202: ROLLBACK;
203: CSM_UTIL_PKG.LOG('Exception in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
204: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
205: END REFRESH_ACC;
206:
207: END CSM_RESCODE_MAPPING_EVENT_PKG;

Line 207: END CSM_RESCODE_MAPPING_EVENT_PKG;

203: CSM_UTIL_PKG.LOG('Exception in CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
204: 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
205: END REFRESH_ACC;
206:
207: END CSM_RESCODE_MAPPING_EVENT_PKG;