APPS.CSM_MTL_ITEM_SUBINV_EVENT_PKG dependencies on CSM_UTIL_PKG

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

64: AND acc.secondary_inventory = mis.secondary_inventory
65: );
66:
67: BEGIN
68: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV ',
69: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
70:
71: l_run_date := SYSDATE;
72:

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

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

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

86: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_STATEMENT);
87:
88: -- make dirty calls
89: FOR i IN 1..l_access_id_tbl.count LOOP
90: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(g_pub_item,
91: l_access_id_tbl(i),
92: p_user_id,
93: asg_download.ins,
94: l_run_date);

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

114: );
115: END LOOP;
116: */
117:
118: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV ',
119: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
120:
121: EXCEPTION
122: WHEN others THEN

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

122: WHEN others THEN
123: l_sqlerrno := to_char(SQLCODE);
124: l_sqlerrmsg := substr(SQLERRM, 1,2000);
125: -- ROLLBACK;
126: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,
127: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);
128: END INSERT_MTL_ITEM_SUBINV;
129:
130:

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

152: AND acc.organization_id = p_organizationid
153: AND acc.user_id = p_userid;
154:
155: BEGIN
156: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV ',
157: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
158:
159: l_run_date := SYSDATE;
160:

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

179:
180: l_access_id_tbl.DELETE;
181: END IF;
182:
183: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV ',
184: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
185:
186: EXCEPTION
187: WHEN others THEN

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

187: WHEN others THEN
188: l_sqlerrno := to_char(SQLCODE);
189: l_sqlerrmsg := substr(SQLERRM, 1,2000);
190: ROLLBACK;
191: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,
192: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);
193: END UPDATE_MTL_ITEM_SUBINV;
194:
195:

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

221: AND mis.secondary_inventory = acc.secondary_inventory
222: );
223:
224: BEGIN
225: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV ',
226: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
227:
228: IF l_inventory_items_tbl.count > 0 THEN
229: l_inventory_items_tbl.delete;

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

259: END LOOP;
260:
261: END IF;
262:
263: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV ',
264: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);
265:
266: EXCEPTION
267: WHEN others THEN

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

267: WHEN others THEN
268: l_sqlerrno := to_char(SQLCODE);
269: l_sqlerrmsg := substr(SQLERRM, 1,2000);
270: ROLLBACK;
271: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV: ' || l_sqlerrno || ':' || l_sqlerrmsg,
272: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);
273: END DELETE_MTL_ITEM_SUBINV;
274:
275:

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

359: FROM asg_user
360: WHERE resource_id = p_resourceid;
361:
362: BEGIN
363: CSM_UTIL_PKG.LOG('Entering CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_acc ',
364: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_PROCEDURE);
365:
366: l_run_date := SYSDATE;
367:

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

428: l_sqlerrmsg := substr(SQLERRM, 1,2000);
429: p_status := 'ERROR';
430: p_message := 'Error in CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
431: ROLLBACK;
432: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_ITEM_SUBINV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
433: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);
434: END Refresh_acc;
435:
436: END CSM_MTL_ITEM_SUBINV_EVENT_PKG;