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_ITEM_SUBINV_EVENT_PKG dependencies on CSM_MTL_ITEM_SUBINV_EVENT_PKG

Line 1: PACKAGE BODY CSM_MTL_ITEM_SUBINV_EVENT_PKG AS

1: PACKAGE BODY CSM_MTL_ITEM_SUBINV_EVENT_PKG AS
2: /* $Header: csmemisb.pls 120.1 2005/07/25 00:11:58 trajasek noship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

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 69: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);

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:
73: -- process inserts

Line 86: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_STATEMENT);

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
90: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(g_pub_item,

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 119: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);

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
123: l_sqlerrno := to_char(SQLCODE);

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 127: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);

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:
131: PROCEDURE UPDATE_MTL_ITEM_SUBINV( p_organization_id IN number

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 157: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);

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:
161: IF l_access_id_tbl.count > 0 THEN

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 184: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);

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
188: l_sqlerrno := to_char(SQLCODE);

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 192: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.UPDATE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);

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:
196: PROCEDURE DELETE_MTL_ITEM_SUBINV( p_organization_id IN number

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 226: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);

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;
230: END IF;

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 264: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_PROCEDURE);

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
268: l_sqlerrno := to_char(SQLCODE);

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 272: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.DELETE_MTL_ITEM_SUBINV',FND_LOG.LEVEL_EXCEPTION);

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

Line 296: WHERE package_name = 'CSM_MTL_ITEM_SUBINV_EVENT_PKG'

292: CURSOR l_last_run_date_csr
293: IS
294: SELECT nvl(last_run_date, (sysdate - 365*50))
295: FROM jtm_con_request_data
296: WHERE package_name = 'CSM_MTL_ITEM_SUBINV_EVENT_PKG'
297: AND procedure_name = 'REFRESH_ACC';
298:
299: --process inserts
300: CURSOR l_ins_mtl_item_subinv_csr

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 364: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_PROCEDURE);

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:
368: -- get last conc program update date

Line 417: WHERE package_name = 'CSM_MTL_ITEM_SUBINV_EVENT_PKG'

413:
414: -- update last_run_date
415: UPDATE jtm_con_request_data
416: SET last_run_date = l_run_date
417: WHERE package_name = 'CSM_MTL_ITEM_SUBINV_EVENT_PKG'
418: AND procedure_name = 'REFRESH_ACC';
419:
420: COMMIT;
421:

Line 423: p_message := 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_Acc Executed successfully';

419:
420: COMMIT;
421:
422: p_status := 'FINE';
423: p_message := 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_Acc Executed successfully';
424:
425: EXCEPTION
426: WHEN others THEN
427: l_sqlerrno := to_char(SQLCODE);

Line 430: p_message := 'Error in CSM_MTL_ITEM_SUBINV_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;

426: WHEN others THEN
427: l_sqlerrno := to_char(SQLCODE);
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;

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;

Line 433: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);

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;

Line 436: END CSM_MTL_ITEM_SUBINV_EVENT_PKG;

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;