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 CSM_UTIL_PKG

Line 46: CSM_UTIL_PKG.LOG('Entering DELETE_SYSTEM_ITEMS ',

42: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
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:

Line 85: CSM_UTIL_PKG.LOG('Leaving DELETE_SYSTEM_ITEMS ',

81: FORALL i IN 1..l_tab_access_id.COUNT
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);

Line 91: CSM_UTIL_PKG.LOG('Exception in delete_system_items: ' || l_sqlerrno || ':' || l_sqlerrmsg,

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

Line 124: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',

120: l_organization_id mtl_system_items.organization_id%TYPE;
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;

Line 176: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',

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

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 242: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',

238: l_organization_id mtl_system_items.organization_id%TYPE;
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;

Line 307: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',

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

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 535: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');

531: IF l_max_last_update_date_tl < l_last_run_date THEN
532: -- no updates
533: p_status := 'FINE';
534: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';
535: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');
536:
537: -- set the program update date in jtm_con_request_data to sysdate
538: UPDATE jtm_con_request_data
539: SET last_run_date = l_current_run_date

Line 591: l_user_id := csm_util_pkg.get_all_omfs_palm_user_list();

587: -- Get all the users list
588: IF l_user_id.COUNT > 0 THEN
589: l_user_id.DELETE;
590: END IF;
591: l_user_id := csm_util_pkg.get_all_omfs_palm_user_list();
592:
593: -- Get all the new items
594: OPEN l_systemitems_ins_su_csr (l_su_user_id,l_su_organization_id);
595: LOOP

Line 701: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

697: l_sqlerrmsg := substr(SQLERRM, 1,2000);
698: p_status := 'ERROR';
699: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS: ' || l_sqlerrno || ':' || l_sqlerrmsg;
700: ROLLBACK;
701: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
702: END Refresh_Acc;
703:
704: /* concurrent program that refreshes inventory */
705: PROCEDURE Refresh_mtl_onhand_quantity(p_status OUT NOCOPY VARCHAR2,

Line 860: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',

856: l_dml_tab user_idTab;
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:

Line 904: CSM_UTIL_PKG.LOG('Pushing ' || acc_id_lst.COUNT || 'deleted records',

900: FETCH l_onhand_delete_csr BULK COLLECT INTO user_id_lst, inv_id, org_id, acc_id_lst LIMIT 100;
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(

Line 969: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || 'updated records',

965: EXIT WHEN user_id_lst.COUNT = 0;
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

Line 1047: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',

1043:
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;

Line 1073: AND NOT CSM_UTIL_PKG.is_new_mmu_user(CSM_UTIL_PKG.get_user_name(user_id_lst(i)))) THEN -- this condition for new mmu user

1069: --To notify user
1070: FOR i in 1..acc_id_lst.COUNT
1071: LOOP
1072: IF(NOT l_dml_tab.EXISTS(acc_id_lst(i))
1073: AND NOT CSM_UTIL_PKG.is_new_mmu_user(CSM_UTIL_PKG.get_user_name(user_id_lst(i)))) THEN -- this condition for new mmu user
1074: l_cnt := l_cnt +1;
1075: l_pk_tab(l_cnt) := acc_id_lst(i);
1076: l_dml_tab(acc_id_lst(i)) := 1;
1077: END IF;

Line 1102: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',

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

Line 1117: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

1113: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1114: p_status := 'ERROR';
1115: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY: ' || l_sqlerrno || ':' || l_sqlerrmsg;
1116: ROLLBACK;
1117: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
1118:
1119: END Refresh_mtl_onhand_quantity;
1120:
1121: PROCEDURE get_new_user_system_items(p_user_id IN NUMBER)

Line 1193: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',

1189: l_organization_id mtl_system_items.organization_id%TYPE;
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;

Line 1207: CSM_UTIL_PKG.LOG(' Found MFS user created with organization_id: ' || l_organization_id,

1203: FETCH l_prev_user_csr INTO l_user_id;
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;

Line 1251: CSM_UTIL_PKG.LOG(' First user with organization_id: ' || l_organization_id,

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

Line 1291: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',

1287: END LOOP;
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

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 1312: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,

1308: l_error_msg VARCHAR2(4000);
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

Line 1329: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,

1325: ,P_USER_ID => p_user_id
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);

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 1351: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,

1347: l_error_msg VARCHAR2(4000);
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

Line 1367: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,

1363: ,P_USER_ID => p_user_id
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);

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 1514: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || ' updates',

1510: CLOSE l_onhand_update_csr;
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

Line 1562: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || ' inserts',

1558:
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;

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: