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_PROBCODE_MAPPING_EVENT_PKG dependencies on CSM_PROBCODE_MAPPING_EVENT_PKG

Line 1: PACKAGE BODY CSM_PROBCODE_MAPPING_EVENT_PKG AS

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

Line 70: WHERE package_name = 'CSM_PROBCODE_MAPPING_EVENT_PKG'

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

Line 75: CSM_UTIL_PKG.LOG('Entering CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',

71: AND procedure_name = 'REFRESH_PROBCODE_MAPPING_ACC';
72:
73: BEGIN
74:
75: CSM_UTIL_PKG.LOG('Entering CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',
76: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc', FND_LOG.LEVEL_PROCEDURE);
77:
78: -- data program is run
79: l_run_date := SYSDATE;

Line 76: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc', FND_LOG.LEVEL_PROCEDURE);

72:
73: BEGIN
74:
75: CSM_UTIL_PKG.LOG('Entering CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',
76: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc', FND_LOG.LEVEL_PROCEDURE);
77:
78: -- data program is run
79: l_run_date := SYSDATE;
80:

Line 94: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_STATEMENT);

90: -- get resource list of all omfs palm users
91: l_all_omfs_resource_list := l_null_omfs_resource_list;
92: l_all_omfs_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
93:
94: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_STATEMENT);
95:
96: -- process all deletes
97: OPEN csr_probcode_map_del;
98: FETCH csr_probcode_map_del BULK COLLECT INTO l_map_access_list;

Line 120: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);

116:
117: l_map_access_list.delete;
118: END IF; -- end of process deletes
119:
120: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);
121:
122: -- process all updates
123: OPEN csr_probcode_map_upd(l_prog_update_date);
124: FETCH csr_probcode_map_upd BULK COLLECT INTO l_map_access_list;

Line 146: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);

142: IF l_problem_map_detail_id_tbl.count > 0 THEN
143: l_problem_map_detail_id_tbl.delete;
144: END IF;
145:
146: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);
147:
148: --process all inserts
149: OPEN csr_probcode_map_ins;
150: FETCH csr_probcode_map_ins BULK COLLECT INTO l_map_access_list, l_problem_map_detail_id_tbl;

Line 188: WHERE package_name = 'CSM_PROBCODE_MAPPING_EVENT_PKG'

184:
185: -- update last_run_date
186: UPDATE jtm_con_request_data
187: SET last_run_date = l_run_date
188: WHERE package_name = 'CSM_PROBCODE_MAPPING_EVENT_PKG'
189: AND procedure_name = 'REFRESH_PROBCODE_MAPPING_ACC';
190:
191: COMMIT;
192:

Line 194: p_message := 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc Executed successfully';

190:
191: COMMIT;
192:
193: p_status := 'FINE';
194: p_message := 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc Executed successfully';
195:
196: CSM_UTIL_PKG.LOG('Leaving CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',
197: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);
198:

Line 196: CSM_UTIL_PKG.LOG('Leaving CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',

192:
193: p_status := 'FINE';
194: p_message := 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc Executed successfully';
195:
196: CSM_UTIL_PKG.LOG('Leaving CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',
197: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);
198:
199: EXCEPTION
200: WHEN others THEN

Line 197: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);

193: p_status := 'FINE';
194: p_message := 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc Executed successfully';
195:
196: CSM_UTIL_PKG.LOG('Leaving CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc ',
197: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);
198:
199: EXCEPTION
200: WHEN others THEN
201: l_sqlerrno := to_char(SQLCODE);

Line 204: p_message := 'Error in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc :' || l_sqlerrno || ':' || l_sqlerrmsg;

200: WHEN others THEN
201: l_sqlerrno := to_char(SQLCODE);
202: l_sqlerrmsg := substr(SQLERRM, 1,2000);
203: p_status := 'Error';
204: p_message := 'Error in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
205: ROLLBACK;
206: CSM_UTIL_PKG.LOG('Exception in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
207: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_EXCEPTION);
208: END Refresh_probcode_mapping_acc;

Line 206: CSM_UTIL_PKG.LOG('Exception in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,

202: l_sqlerrmsg := substr(SQLERRM, 1,2000);
203: p_status := 'Error';
204: p_message := 'Error in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
205: ROLLBACK;
206: CSM_UTIL_PKG.LOG('Exception in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
207: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_EXCEPTION);
208: END Refresh_probcode_mapping_acc;
209:
210: END CSM_PROBCODE_MAPPING_EVENT_PKG;

Line 207: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_EXCEPTION);

203: p_status := 'Error';
204: p_message := 'Error in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
205: ROLLBACK;
206: CSM_UTIL_PKG.LOG('Exception in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
207: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_EXCEPTION);
208: END Refresh_probcode_mapping_acc;
209:
210: END CSM_PROBCODE_MAPPING_EVENT_PKG;

Line 210: END CSM_PROBCODE_MAPPING_EVENT_PKG;

206: CSM_UTIL_PKG.LOG('Exception in CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
207: 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_EXCEPTION);
208: END Refresh_probcode_mapping_acc;
209:
210: END CSM_PROBCODE_MAPPING_EVENT_PKG;