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_SEC_INV_EVENT_PKG dependencies on FND_LOG

Line 33: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

29: l_sqlerrmsg varchar2(2000);
30:
31: BEGIN
32: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',
33: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
34:
35: CSM_ACC_PKG.Insert_Acc
36: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
37: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 47: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

43: ,P_USER_ID => p_user_id
44: );
45:
46: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',
47: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
48:
49: EXCEPTION
50: WHEN others THEN
51: l_sqlerrno := to_char(SQLCODE);

Line 54: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);

50: WHEN others THEN
51: l_sqlerrno := to_char(SQLCODE);
52: l_sqlerrmsg := substr(SQLERRM, 1,2000);
53: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
54: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
55:
56: END insert_mtl_sec_inventory;
57:
58: PROCEDURE update_mtl_sec_inventory( p_user_id NUMBER

Line 68: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

64: l_access_id number;
65:
66: BEGIN
67: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',
68: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
69:
70: l_access_id := CSM_ACC_PKG.Get_Acc_Id
71: ( P_ACC_TABLE_NAME => g_acc_table_name1
72: ,P_PK1_NAME => g_pk1_name1

Line 87: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

83: ,P_USER_ID => p_user_id
84: );
85:
86: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',
87: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
88:
89: EXCEPTION
90: WHEN others THEN
91: l_sqlerrno := to_char(SQLCODE);

Line 94: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);

90: WHEN others THEN
91: l_sqlerrno := to_char(SQLCODE);
92: l_sqlerrmsg := substr(SQLERRM, 1,2000);
93: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
94: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
95:
96: END update_mtl_sec_inventory;
97:
98: PROCEDURE delete_mtl_sec_inventory( p_user_id NUMBER

Line 107: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

103: l_sqlerrmsg varchar2(2000);
104:
105: BEGIN
106: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',
107: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
108:
109: CSM_ACC_PKG.Delete_Acc
110: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
111: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 120: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

116: ,P_USER_ID => p_user_id
117: );
118:
119: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',
120: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
121:
122: EXCEPTION
123: WHEN others THEN
124: l_sqlerrno := to_char(SQLCODE);

Line 127: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);

123: WHEN others THEN
124: l_sqlerrno := to_char(SQLCODE);
125: l_sqlerrmsg := substr(SQLERRM, 1,2000);
126: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
127: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
128:
129: END delete_mtl_sec_inventory;
130:
131: --used only for multi platform

Line 189: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);

185: AND csi.secondary_inventory_name=acc.secondary_inventory_name and acc.user_id=au.user_id);
186:
187: BEGIN
188: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
189: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
190:
191: -- data program is run
192: l_run_date := SYSDATE;
193:

Line 199: CSM_UTIL_PKG.LOG('Processing deletes', 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc', FND_LOG.LEVEL_PROCEDURE);

195: OPEN l_last_run_date_csr;
196: FETCH l_last_run_date_csr INTO l_prog_update_date;
197: CLOSE l_last_run_date_csr;
198:
199: CSM_UTIL_PKG.LOG('Processing deletes', 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc', FND_LOG.LEVEL_PROCEDURE);
200: -- process all deletes
201: OPEN c_del_cur;
202: LOOP
203: l_tab_access_id.DELETE;

Line 210: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

206: FETCH c_del_cur BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
207: EXIT WHEN l_tab_access_id.COUNT = 0;
208:
209: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,
210: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
211:
212: l_markdirty := asg_download.mark_dirty(
213: P_PUB_ITEM => g_pub_item
214: , p_accessList => l_tab_access_id

Line 228: CSM_UTIL_PKG.LOG('Processing Updates', 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc', FND_LOG.LEVEL_PROCEDURE);

224: END LOOP;
225: CLOSE c_del_cur;
226:
227:
228: CSM_UTIL_PKG.LOG('Processing Updates', 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc', FND_LOG.LEVEL_PROCEDURE);
229: -- process all deletes
230: OPEN l_upd_mtl_sec_inv_csr(l_prog_update_date);
231: LOOP
232: l_tab_access_id.DELETE;

Line 239: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

235: FETCH l_upd_mtl_sec_inv_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
236: EXIT WHEN l_tab_access_id.COUNT = 0;
237:
238: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,
239: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
240:
241: l_markdirty := asg_download.mark_dirty(
242: P_PUB_ITEM => g_pub_item
243: , p_accessList => l_tab_access_id

Line 252: CSM_UTIL_PKG.LOG('Processing inserts', 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc', FND_LOG.LEVEL_PROCEDURE);

248: COMMIT;
249: END LOOP;
250: CLOSE l_upd_mtl_sec_inv_csr;
251:
252: CSM_UTIL_PKG.LOG('Processing inserts', 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc', FND_LOG.LEVEL_PROCEDURE);
253: -- process all inserts
254:
255: OPEN c_ins_cur;
256: LOOP

Line 266: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

262: FETCH c_ins_cur BULK COLLECT INTO l_tab_access_id, l_tab_user_id,l_tab_org_id,l_tab_sub_code LIMIT 1000;
263: EXIT WHEN l_tab_access_id.COUNT = 0;
264:
265: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_FREIGHTS_ACC' ,
266: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
267:
268: FORALL i IN 1..l_tab_access_id.COUNT
269: INSERT INTO CSM_MTL_SEC_INV_ACC (access_id, user_id,organization_id, secondary_inventory_name,
270: counter, created_by, creation_date, last_updated_by, last_update_date ,lasT_update_login)

Line 300: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);

296: p_status := 'FINE';
297: p_message := 'CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc Executed successfully';
298:
299: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
300: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
301:
302: EXCEPTION
303: WHEN others THEN
304: l_sqlerrno := to_char(SQLCODE);

Line 310: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);

306: p_status := 'ERROR';
307: p_message := 'Error in CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
308: ROLLBACK;
309: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
310: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);
311: END refresh_acc;
312:
313: END CSM_MTL_SEC_INV_EVENT_PKG;