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: PROCEDURE refresh_acc(p_status OUT NOCOPY VARCHAR2,

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

155: AND msi.last_update_date >= p_last_upd_date;
156:
157: BEGIN
158: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
159: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
160:
161: -- data program is run
162: l_run_date := SYSDATE;
163:

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

186: p_status := 'FINE';
187: p_message := 'CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc Executed successfully';
188:
189: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
190: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
191:
192: EXCEPTION
193: WHEN others THEN
194: l_sqlerrno := to_char(SQLCODE);

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

196: p_status := 'ERROR';
197: p_message := 'Error in CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
198: ROLLBACK;
199: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
200: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);
201: END refresh_acc;
202:
203: END CSM_MTL_SEC_INV_EVENT_PKG;