1476: p_error_msg OUT NOCOPY VARCHAR2,
1477: x_return_status IN OUT NOCOPY VARCHAR2)
1478: IS
1479: BEGIN
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I ',
1482: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
1483:
1484: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1499: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I ',
1500: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
1501: EXCEPTION
1502: WHEN others THEN
1503: x_return_status := FND_API.G_RET_STS_ERROR;
1504: p_error_msg := ' FAILED MTL_SYSTEM_ITEMS_ACC_I INVENTORY_ITEM_ID: ' || to_char(p_inventory_item_id) || SUBSTR(SQLERRM,1,2000);
1505: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_EXCEPTION);
1506: RAISE;
1507: END MTL_SYSTEM_ITEMS_ACC_I;
1512: p_error_msg OUT NOCOPY VARCHAR2,
1513: x_return_status IN OUT NOCOPY VARCHAR2)
1514: IS
1515: BEGIN
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',
1518: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1519:
1520: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1533: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D ',
1534: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1535: EXCEPTION
1536: WHEN others THEN
1537: x_return_status := FND_API.G_RET_STS_ERROR;
1538: p_error_msg := ' FAILED MTL_SYSTEM_ITEMS_ACC_D INVENTORY_ITEM_ID: ' || to_char(p_inventory_item_id) || SUBSTR(SQLERRM,1,2000);
1539: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
1540: RAISE;
1541: END MTL_SYSTEM_ITEMS_ACC_D;