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 CSM_UTIL_PKG

Line 32: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',

28: l_sqlerrno varchar2(20);
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

Line 46: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',

42: ,P_PK2_NUM_VALUE => p_organization_id
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

Line 53: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,

49: 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:

Line 67: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',

63: l_sqlerrmsg varchar2(2000);
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

Line 86: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',

82: ,P_ACCESS_ID => l_access_id
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

Line 93: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,

89: 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:

Line 106: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',

102: l_sqlerrno varchar2(20);
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

Line 119: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',

115: ,P_PK2_NUM_VALUE => p_organization_id
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

Line 126: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,

122: 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:

Line 188: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',

184: AND NOT EXISTS(SELECT 1 FROM csm_mtl_sec_inv_acc acc WHERE csi.organization_id=acc.organization_id
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;

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 209: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,

205:
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

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 238: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,

234:
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

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 265: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into CSM_INTERORG_FREIGHTS_ACC' ,

261:
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,

Line 299: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',

295:
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

Line 309: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,

305: l_sqlerrmsg := substr(SQLERRM, 1,2000);
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;