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 FND_LOG

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 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 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;