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_SR_TYPE_MAP_EVENT_PKG dependencies on CSM_SR_TYPE_MAP_EVENT_PKG

Line 1: PACKAGE BODY CSM_SR_TYPE_MAP_EVENT_PKG AS

1: PACKAGE BODY CSM_SR_TYPE_MAP_EVENT_PKG AS
2: /* $Header: csmeitmb.pls 120.2 2008/02/07 07:45:35 anaraman ship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 82: WHERE package_name = 'CSM_SR_TYPE_MAP_EVENT_PKG'

78: CURSOR l_last_run_date_csr
79: IS
80: SELECT nvl(last_run_date, (sysdate - 365*50))
81: FROM jtm_con_request_data
82: WHERE package_name = 'CSM_SR_TYPE_MAP_EVENT_PKG'
83: AND procedure_name = 'REFRESH_ACC';
84:
85: BEGIN
86:

Line 87: CSM_UTIL_PKG.LOG('Entering CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',

83: AND procedure_name = 'REFRESH_ACC';
84:
85: BEGIN
86:
87: CSM_UTIL_PKG.LOG('Entering CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',
88: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);
89:
90: -- get last conc program update date
91: OPEN l_last_run_date_csr;

Line 88: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);

84:
85: BEGIN
86:
87: CSM_UTIL_PKG.LOG('Entering CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',
88: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_PROCEDURE);
89:
90: -- get last conc program update date
91: OPEN l_last_run_date_csr;
92: FETCH l_last_run_date_csr INTO l_prog_update_date;

Line 102: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);

98:
99: -- get resource list of all omfs users R12 change
100: l_user_list := l_null_omfs_resource_list;
101:
102: CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
103:
104: -- process all deletes
105: OPEN csr_sr_type_map_del;
106: FETCH csr_sr_type_map_del BULK COLLECT INTO l_map_access_list,l_user_list;

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

124: l_map_access_list.delete;
125: l_user_list.delete;
126: END IF; -- end of process deletes
127:
128: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
129:
130:
131: -- process all updates
132: OPEN csr_sr_type_map_upd(l_prog_update_date);

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

154: IF l_responsibility_id_tbl.count > 0 THEN
155: l_responsibility_id_tbl.delete;
156: END IF;
157:
158: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
159:
160: --process all inserts
161: OPEN csr_sr_type_map_ins;
162: FETCH csr_sr_type_map_ins BULK COLLECT INTO l_map_access_list,l_user_list, l_sr_type_id_tbl, l_responsibility_id_tbl;

Line 203: WHERE package_name = 'CSM_SR_TYPE_MAP_EVENT_PKG'

199:
200: -- update last_run_date
201: UPDATE jtm_con_request_data
202: SET last_run_date = sysdate
203: WHERE package_name = 'CSM_SR_TYPE_MAP_EVENT_PKG'
204: AND procedure_name= 'REFRESH_ACC';
205:
206: COMMIT;
207:

Line 209: p_message := 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC Executed successfully';

205:
206: COMMIT;
207:
208: p_status := 'FINE';
209: p_message := 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC Executed successfully';
210:
211: CSM_UTIL_PKG.LOG('Leaving CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',
212: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
213:

Line 211: CSM_UTIL_PKG.LOG('Leaving CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',

207:
208: p_status := 'FINE';
209: p_message := 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC Executed successfully';
210:
211: CSM_UTIL_PKG.LOG('Leaving CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',
212: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
213:
214: EXCEPTION
215: WHEN others THEN

Line 212: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

208: p_status := 'FINE';
209: p_message := 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC Executed successfully';
210:
211: CSM_UTIL_PKG.LOG('Leaving CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC ',
212: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
213:
214: EXCEPTION
215: WHEN others THEN
216: l_sqlerrno := to_char(SQLCODE);

Line 219: p_message := 'Error in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;

215: WHEN others THEN
216: l_sqlerrno := to_char(SQLCODE);
217: l_sqlerrmsg := substr(SQLERRM, 1,2000);
218: p_status := 'Error';
219: p_message := 'Error in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
220: ROLLBACK;
221: CSM_UTIL_PKG.LOG('Exception in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
222: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
223: END REFRESH_ACC;

Line 221: CSM_UTIL_PKG.LOG('Exception in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,

217: l_sqlerrmsg := substr(SQLERRM, 1,2000);
218: p_status := 'Error';
219: p_message := 'Error in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
220: ROLLBACK;
221: CSM_UTIL_PKG.LOG('Exception in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
222: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
223: END REFRESH_ACC;
224:
225: END CSM_SR_TYPE_MAP_EVENT_PKG;

Line 222: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);

218: p_status := 'Error';
219: p_message := 'Error in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC :' || l_sqlerrno || ':' || l_sqlerrmsg;
220: ROLLBACK;
221: CSM_UTIL_PKG.LOG('Exception in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
222: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
223: END REFRESH_ACC;
224:
225: END CSM_SR_TYPE_MAP_EVENT_PKG;

Line 225: END CSM_SR_TYPE_MAP_EVENT_PKG;

221: CSM_UTIL_PKG.LOG('Exception in CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
222: 'CSM_SR_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_EXCEPTION);
223: END REFRESH_ACC;
224:
225: END CSM_SR_TYPE_MAP_EVENT_PKG;