APPS.CSM_MTL_ITEM_SUBINV_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 74: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV ',

70: AND acc.secondary_inventory = mis.secondary_inventory
71: );
72:
73: BEGIN
74: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV ',
75: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
76:
77: l_run_date := SYSDATE;
78:

Line 91: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_item_subinv_acc for user ' || p_user_id ,

87: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
88: VALUES (l_access_id_tbl(i), p_user_id, l_inventory_items_tbl(i), l_organizations_tbl(i),l_sec_inventory_tbl(i), 1,
89: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
90:
91: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_item_subinv_acc for user ' || p_user_id ,
92: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_STATEMENT);
93:
94: -- make dirty calls
95: FOR i IN 1..l_access_id_tbl.count LOOP

Line 96: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(g_pub_item,

92: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_STATEMENT);
93:
94: -- make dirty calls
95: FOR i IN 1..l_access_id_tbl.count LOOP
96: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(g_pub_item,
97: l_access_id_tbl(i),
98: p_user_id,
99: asg_download.ins,
100: l_run_date);

Line 124: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV ',

120: );
121: END LOOP;
122: */
123:
124: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV ',
125: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
126:
127: EXCEPTION
128: WHEN others THEN

Line 132: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,

128: WHEN others THEN
129: l_sqlerrno := to_char(SQLCODE);
130: l_sqlerrmsg := substr(SQLERRM, 1,2000);
131: -- ROLLBACK;
132: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,
133: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);
134: END INSERT_MTL_ITEM_SUBINV;
135:
136:

Line 162: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV ',

158: AND acc.organization_id = p_organizationid
159: AND acc.user_id = p_userid;
160:
161: BEGIN
162: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV ',
163: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
164:
165: l_run_date := SYSDATE;
166:

Line 189: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV ',

185:
186: l_access_id_tbl.DELETE;
187: END IF;
188:
189: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV ',
190: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
191:
192: EXCEPTION
193: WHEN others THEN

Line 197: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,

193: WHEN others THEN
194: l_sqlerrno := to_char(SQLCODE);
195: l_sqlerrmsg := substr(SQLERRM, 1,2000);
196: ROLLBACK;
197: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,
198: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);
199: END UPDATE_MTL_ITEM_SUBINV;
200:
201:

Line 231: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV ',

227: AND mis.secondary_inventory = acc.secondary_inventory
228: );
229:
230: BEGIN
231: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV ',
232: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
233:
234: IF l_inventory_items_tbl.count > 0 THEN
235: l_inventory_items_tbl.delete;

Line 269: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV ',

265: END LOOP;
266:
267: END IF;
268:
269: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV ',
270: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
271:
272: EXCEPTION
273: WHEN others THEN

Line 277: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,

273: WHEN others THEN
274: l_sqlerrno := to_char(SQLCODE);
275: l_sqlerrmsg := substr(SQLERRM, 1,2000);
276: ROLLBACK;
277: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,
278: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);
279: END DELETE_MTL_ITEM_SUBINV;
280:
281:

Line 409: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_acc ',

405: FROM asg_user
406: WHERE resource_id = p_resourceid;
407:
408: BEGIN
409: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_acc ',
410: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_PROCEDURE);
411:
412: l_run_date := SYSDATE;
413:

Line 478: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,

474: l_sqlerrmsg := substr(SQLERRM, 1,2000);
475: p_status := 'ERROR';
476: p_message := 'Error in CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
477: ROLLBACK;
478: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
479: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);
480: END Refresh_acc;
481:
482: END CSM_MTL_ITEM_SUBINV_EVENT_PKG;