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 158: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',

154: AND msi.organization_id = acc.organization_id
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;

Line 171: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,

167: CLOSE l_last_run_date_csr;
168:
169: -- get all updated records from the backend table and post them to olite
170: FOR r_upd_mtl_sec_inv_rec IN l_upd_mtl_sec_inv_csr(l_prog_update_date) LOOP
171: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
172: r_upd_mtl_sec_inv_rec.access_id,
173: r_upd_mtl_sec_inv_rec.user_id,
174: ASG_DOWNLOAD.UPD,
175: l_run_date);

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

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

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

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