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_SYSTEM_ITEM_EVENT_PKG dependencies on FND_LOG

Line 47: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

43: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
44:
45: BEGIN
46: CSM_UTIL_PKG.LOG('Entering DELETE_SYSTEM_ITEMS ',
47: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
48:
49: l_run_date := SYSDATE;
50:
51: l_tab_access_id.DELETE;

Line 86: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

82: DELETE FROM csm_system_items_acc WHERE access_id = l_tab_access_id(i);
83: END IF;
84:
85: CSM_UTIL_PKG.LOG('Leaving DELETE_SYSTEM_ITEMS ',
86: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
87: EXCEPTION
88: WHEN others THEN
89: l_sqlerrno := TO_CHAR(SQLCODE);
90: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 92: 'csm_system_item_event_pkg.delete_system_items',FND_LOG.LEVEL_EXCEPTION);

88: WHEN others THEN
89: l_sqlerrno := TO_CHAR(SQLCODE);
90: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
91: CSM_UTIL_PKG.LOG('Exception in delete_system_items: ' || l_sqlerrno || ':' || l_sqlerrmsg,
92: 'csm_system_item_event_pkg.delete_system_items',FND_LOG.LEVEL_EXCEPTION);
93: RAISE;
94: END delete_system_items;
95:
96: /*

Line 125: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

121: l_userid NUMBER;
122:
123: BEGIN
124: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',
125: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
126:
127: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
128: l_current_run_date := SYSDATE;
129:

Line 177: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

173:
174: END IF;
175:
176: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',
177: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: --logm('ErrorLog' || substr(SQLERRM, 1, 250));

Line 183: CSM_UTIL_PKG.LOG(x_result,'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);

179: EXCEPTION
180: WHEN OTHERS THEN
181: --logm('ErrorLog' || substr(SQLERRM, 1, 250));
182: x_result := ' FAILED PURGE_SYSTEM_ITEMS old_OrganizationId: ' || to_char(l_old_organization_id);
183: CSM_UTIL_PKG.LOG(x_result,'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
184: wf_core.context('CSM_SYSTEM_ITEM_EVENT_PKG', 'PURGE_SYSTEM_ITEMS', p_itemtype, p_itemkey, to_char(p_actid),
185: 'Organization ID: ' || to_char(l_old_organization_id), p_funcmode);
186: RAISE;
187:

Line 243: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

239: l_user_id NUMBER;
240:
241: BEGIN
242: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',
243: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
244:
245: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
246: l_current_run_date := SYSDATE;
247:

Line 308: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

304:
305: END IF;
306:
307: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',
308: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: x_result := ' FAILED GET_NEW_SYSTEM_ITEMS OrganizationId: ' || to_char(l_organization_id);

Line 313: CSM_UTIL_PKG.LOG(x_result, 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);

309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: x_result := ' FAILED GET_NEW_SYSTEM_ITEMS OrganizationId: ' || to_char(l_organization_id);
313: CSM_UTIL_PKG.LOG(x_result, 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
314: wf_core.context('CSM_SYSTEM_ITEM_EVENT_PKG', 'GET_NEW_SYSTEM_ITEMS', p_itemtype, p_itemkey, to_char(p_actid),
315: 'Organization ID: ' || to_char(l_organization_id), p_funcmode);
316: RAISE;
317:

Line 861: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);

857: l_cnt NUMBER :=0;
858:
859: BEGIN
860: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
861: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
862:
863: l_current_run_date := SYSDATE;
864:
865: --*** Push deleted records to client ***

Line 905: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);

901: EXIT WHEN acc_id_lst.COUNT = 0;
902:
903: IF acc_id_lst.COUNT > 0 THEN
904: CSM_UTIL_PKG.LOG('Pushing ' || acc_id_lst.COUNT || 'deleted records',
905: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
906:
907: -- do bulk makedirty
908: l_dummy := asg_download.mark_dirty(
909: P_PUB_ITEM => g_pub_item

Line 970: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);

966:
967: IF user_id_lst.COUNT > 0 THEN
968: --*** push to oLite using asg_download ***
969: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || 'updated records',
970: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
971:
972: FORALL i IN user_id_lst.FIRST..user_id_lst.LAST
973: UPDATE CSM_MTL_ONHAND_QTY_ACC
974: SET LAST_UPDATE_DATE = l_current_run_date,

Line 1048: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);

1044: -- check if there are any items to be downloaded
1045: IF inv_id.COUNT > 0 THEN
1046: --*** push to oLite using asg_download ***
1047: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',
1048: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
1049:
1050: FOR i IN inv_id.FIRST..inv_id.LAST LOOP
1051: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
1052: END LOOP;

Line 1103: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);

1099: END LOOP;
1100:
1101:
1102: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
1103: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
1104:
1105: p_status := 'FINE';
1106: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY Executed successfully';
1107:

Line 1194: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);

1190: l_count NUMBER;
1191:
1192: BEGIN
1193: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1194: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1195:
1196: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
1197: l_current_run_date := SYSDATE;
1198: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);

Line 1208: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);

1204: CLOSE l_prev_user_csr;
1205:
1206: IF l_user_id IS NOT NULL THEN
1207: CSM_UTIL_PKG.LOG(' Found MFS user created with organization_id: ' || l_organization_id,
1208: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1209:
1210: IF l_acc_id_lst.COUNT > 0 THEN
1211: l_acc_id_lst.DELETE;
1212: END IF;

Line 1252: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);

1248: CLOSE l_systemitems_ins_acc_csr;
1249: ELSE
1250: -- process inserts
1251: CSM_UTIL_PKG.LOG(' First user with organization_id: ' || l_organization_id,
1252: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1253:
1254: OPEN l_systemitems_ins_csr (p_organization_id=>l_organization_id, p_user_id=>p_user_id);
1255: LOOP
1256: IF l_acc_id_lst.COUNT > 0 THEN

Line 1292: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);

1288: CLOSE l_systemitems_ins_csr;
1289: END IF;
1290:
1291: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1292: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1293:
1294: EXCEPTION
1295: WHEN others THEN
1296: l_sqlerrno := to_char(SQLCODE);

Line 1298: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);

1294: EXCEPTION
1295: WHEN others THEN
1296: l_sqlerrno := to_char(SQLCODE);
1297: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1298: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);
1299: RAISE;
1300: END get_new_user_system_items;
1301:
1302: PROCEDURE SYSTEM_ITEM_MDIRTY_I(p_inventory_item_id IN NUMBER,

Line 1313: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

1309: l_return_status VARCHAR2(2000);
1310:
1311: BEGIN
1312: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,
1313: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1314:
1315: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1316: -- insert into csm_system_items_acc
1317: CSM_ACC_PKG.Insert_Acc

Line 1330: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

1326: );
1327: END IF;
1328:
1329: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,
1330: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: l_sqlerrno := to_char(SQLCODE);
1334: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1337: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

1333: l_sqlerrno := to_char(SQLCODE);
1334: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1335: l_error_msg := ' Exception in SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id
1336: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1337: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
1338: RAISE;
1339: END SYSTEM_ITEM_MDIRTY_I;
1340:
1341: PROCEDURE SYSTEM_ITEM_MDIRTY_D(p_inventory_item_id IN NUMBER,

Line 1352: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

1348: l_return_status VARCHAR2(2000);
1349:
1350: BEGIN
1351: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,
1352: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1353:
1354: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1355: -- delete from csm_system_items_acc
1356: CSM_ACC_PKG.Delete_Acc

Line 1368: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

1364: );
1365: END IF;
1366:
1367: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,
1368: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: l_sqlerrno := to_char(SQLCODE);
1372: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1375: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

1371: l_sqlerrno := to_char(SQLCODE);
1372: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1373: l_error_msg := ' Exception in SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id
1374: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1375: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
1376: RAISE;
1377: END SYSTEM_ITEM_MDIRTY_D;
1378:
1379: PROCEDURE RECEIVED_MTL_ONHAND(p_org_id IN NUMBER,p_subinv_code IN VARCHAR2,p_item_id IN NUMBER,p_user_id IN NUMBER)

Line 1506: CSM_UTIL_PKG.LOG('Entered RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1502: l_return_status VARCHAR2(100);
1503: l_err_msg VARCHAR2(4000);
1504:
1505: BEGIN
1506: CSM_UTIL_PKG.LOG('Entered RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1507:
1508: OPEN l_onhand_update_csr;
1509: FETCH l_onhand_update_csr BULK COLLECT INTO user_id_lst, inv_id, org_id, sub_code, loc_id, rvsion, lot_num, dummy_qty, qty;
1510: CLOSE l_onhand_update_csr;

Line 1515: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1511:
1512: IF user_id_lst.COUNT > 0 THEN
1513: --*** push to oLite using asg_download ***
1514: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || ' updates',
1515: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1516:
1517: FORALL i IN 1..user_id_lst.COUNT
1518: UPDATE CSM_MTL_ONHAND_QTY_ACC
1519: SET LAST_UPDATE_DATE = sysdate, QUANTITY = qty(i)

Line 1563: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1559: -- check if there are any items to be downloaded
1560: IF inv_id.COUNT > 0 THEN
1561: --*** push to oLite using asg_download ***
1562: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || ' inserts',
1563: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1564:
1565: FOR i IN 1..inv_id.COUNT LOOP
1566: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
1567: END LOOP;

Line 1585: CSM_UTIL_PKG.LOG('Find and add instances if the received item is IB trackable', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1581: , P_TIMESTAMP => sysdate
1582: );
1583: END IF;
1584:
1585: CSM_UTIL_PKG.LOG('Find and add instances if the received item is IB trackable', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1586: FOR rec IN c_find_instances
1587: LOOP
1588: CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR(rec.instance_id,rec.USER_ID,NULL,l_return_status,l_err_msg);
1589: END LOOP;

Line 1591: CSM_UTIL_PKG.LOG('Leaving RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1587: LOOP
1588: CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR(rec.instance_id,rec.USER_ID,NULL,l_return_status,l_err_msg);
1589: END LOOP;
1590:
1591: CSM_UTIL_PKG.LOG('Leaving RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1592: END RECEIVED_MTL_ONHAND;
1593:
1594: END CSM_SYSTEM_ITEM_EVENT_PKG;
1595: