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_MTL_TXN_REASONS_EVENT_PKG dependencies on CSM_MTL_TXN_REASONS_EVENT_PKG

Line 1: PACKAGE BODY CSM_MTL_TXN_REASONS_EVENT_PKG

1: PACKAGE BODY CSM_MTL_TXN_REASONS_EVENT_PKG
2: /* $Header: csmemtrb.pls 120.1 2005/07/25 00:15:12 trajasek noship $*/
3: AS
4: --
5: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE

Line 78: WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'

74: CURSOR l_last_run_date_csr
75: IS
76: SELECT nvl(last_run_date, (sysdate - 365*50))
77: FROM jtm_con_request_data
78: WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
79: AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';
80:
81: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_txn_reasons_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
82: TYPE reason_id_tbl_typ IS TABLE OF mtl_transaction_reasons.reason_id%TYPE INDEX BY BINARY_INTEGER;

Line 89: CSM_UTIL_PKG.LOG('Entering CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',

85: l_reason_id_tbl reason_id_tbl_typ;
86:
87: BEGIN
88:
89: CSM_UTIL_PKG.LOG('Entering CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',
90: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
91:
92: -- data program is run
93: l_run_date := SYSDATE;

Line 90: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

86:
87: BEGIN
88:
89: CSM_UTIL_PKG.LOG('Entering CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',
90: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
91:
92: -- data program is run
93: l_run_date := SYSDATE;
94:

Line 108: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

104: -- get resource list of all omfs palm users
105: l_all_omfs_palm_resource_list := l_null_palm_omfs_resource_list;
106: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
107:
108: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
109:
110: -- process all deletes
111: OPEN l_del_mtl_txn_reasons_csr(l_prog_update_date);
112: FETCH l_del_mtl_txn_reasons_csr BULK COLLECT INTO l_access_id_tbl;

Line 134: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

130:
131: l_access_id_tbl.delete;
132: END IF; -- end of process deletes
133:
134: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
135:
136: -- process all updates
137: OPEN l_upd_mtl_txn_reasons_csr(l_prog_update_date);
138: FETCH l_upd_mtl_txn_reasons_csr BULK COLLECT INTO l_access_id_tbl;

Line 160: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

156: IF l_reason_id_tbl.count > 0 THEN
157: l_reason_id_tbl.delete;
158: END IF;
159:
160: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
161:
162: --process all inserts
163: OPEN l_ins_mtl_txn_reasons_csr(l_prog_update_date);
164: FETCH l_ins_mtl_txn_reasons_csr BULK COLLECT INTO l_access_id_tbl, l_reason_id_tbl;

Line 191: WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'

187:
188: -- update last_run_date
189: UPDATE jtm_con_request_data
190: SET last_run_date = l_run_date
191: WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
192: AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';
193:
194: COMMIT;
195:

Line 197: p_message := 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC Executed successfully';

193:
194: COMMIT;
195:
196: p_status := 'FINE';
197: p_message := 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC Executed successfully';
198:
199: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',
200: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
201:

Line 199: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',

195:
196: p_status := 'FINE';
197: p_message := 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC Executed successfully';
198:
199: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',
200: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
201:
202: EXCEPTION
203: WHEN others THEN

Line 200: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

196: p_status := 'FINE';
197: p_message := 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC Executed successfully';
198:
199: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',
200: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
201:
202: EXCEPTION
203: WHEN others THEN
204: l_sqlerrno := to_char(SQLCODE);

Line 207: p_message := 'Error in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: '|| l_sqlerrno || ':' || l_sqlerrmsg;

203: WHEN others THEN
204: l_sqlerrno := to_char(SQLCODE);
205: l_sqlerrmsg := substr(SQLERRM, 1,2000);
206: p_status := 'ERROR';
207: p_message := 'Error in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: '|| l_sqlerrno || ':' || l_sqlerrmsg;
208: ROLLBACK;
209: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
210: 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC',FND_LOG.LEVEL_EXCEPTION);
211: END REFRESH_MTL_TXN_REASONS_ACC;

Line 209: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,

205: l_sqlerrmsg := substr(SQLERRM, 1,2000);
206: p_status := 'ERROR';
207: p_message := 'Error in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: '|| l_sqlerrno || ':' || l_sqlerrmsg;
208: ROLLBACK;
209: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
210: 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC',FND_LOG.LEVEL_EXCEPTION);
211: END REFRESH_MTL_TXN_REASONS_ACC;
212:
213: END CSM_MTL_TXN_REASONS_EVENT_PKG;

Line 210: 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC',FND_LOG.LEVEL_EXCEPTION);

206: p_status := 'ERROR';
207: p_message := 'Error in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: '|| l_sqlerrno || ':' || l_sqlerrmsg;
208: ROLLBACK;
209: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
210: 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC',FND_LOG.LEVEL_EXCEPTION);
211: END REFRESH_MTL_TXN_REASONS_ACC;
212:
213: END CSM_MTL_TXN_REASONS_EVENT_PKG;

Line 213: END CSM_MTL_TXN_REASONS_EVENT_PKG;

209: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
210: 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC',FND_LOG.LEVEL_EXCEPTION);
211: END REFRESH_MTL_TXN_REASONS_ACC;
212:
213: END CSM_MTL_TXN_REASONS_EVENT_PKG;